Search results for query: *

Below returns zero recordset from the stats table (when I know there are 100's): <cfset today = createDate(year(now()), month(now()), day(now()))> <cfset yesterday = dateAdd("d", -1, today)> <cfquery name="GetAptsStats" datasource="#DSN#"> SELECT listingFk, listingId, timeStampStats...

I am tracking two different pages when a person leaves my site and signs up with a merchant partner. When the person leaves my site to the merchant's landing form page I enter information about that person in my database table called 'tracking'. When that person successfully fills out the form...

I have users that input data that is sometimes is not correct. For instance they might misspell their city or they might write 'St John' instead of 'St. John'. I would rather not dirty up my database so I would like to check with Google to see if what the user inputted was correct. How do I...

I have a database table of zipcodes that includes latitude and longitude coordinates. CREATE TABLE `zipcodes` ( `zip` INT(5) NOT NULL DEFAULT '0', `suburb` VARCHAR(30) NOT NULL DEFAULT '', `state` CHAR(2) NOT NULL DEFAULT '', `latitude` DECIMAL(10,6) NOT NULL DEFAULT '0.000000'...

Instead of repeating the same code over and over 15 times: <cfif GetNewImages.photo1 NEQ ""> - Lots of code to process the image on to my server - </cfif> <cfif GetNewImages.photo3 NEQ ""> - Lots of code to process the image on to my server - </cfif> <cfif GetNewImages.photo4 NEQ ""> -...

My computer has had two blue screen of death errors during the night while I was asleep the past two nights. I need help reading my DMP files to find out what action I need to take here are the two dmp files: http://cid-b0e0608436fc9d0e.office.live.com/self.aspx/.Public/060910-26239-01.dmp...

I have two operating systems installed on my computer. One is Vista and the other is Windows 7. Vista is the original OS on my computer [d:] and I just installed Win7 on a new hard drive [c:]. I am done with my Vista drive and would like to remove it or use it as another backup drive but I...

I picked up Windows 7 today and a new hard drive. Right now I am waiting for my computer to format my new 1TB drive (taking about 4 hours). My thought is to install Windows 7 on the new drive while still having my C: drive loaded with Vista. Then I can boot to whichever OS I want and take my...

Hi, I am new to PHP. I created a web site template in PHP for people to use: http://www.pickrent.com/widgets/template.cfm Within the template I am pulling in rental listing info from my site (pickrent.com) and displaying it on a template on their server using an IFrame. This is working just...

I have the following query that works fine when providing me with the average rent for the entire metro area: <!--- 135 is Denver ---> <cfset cs = 135> <cfquery name="avgRentpermonth" datasource="#DSN#"> SELECT AVG(rentpermonth) as rentavg FROM listing WHERE metroFk = <cfqueryparam...

http://www.pickrent.com/widgets/template.cfm I created a free property management web site template within a zip file that people can download. I want to dynamically record how many times it has been downloaded. I understand how to create a DB table and record each time a page has been...

SELECT listing.rentaladtitle , images.tnName , listing.listingId , listing.rentpermonth , listing.bedrooms , listing.bathrooms , listing.city , listing.address , listing.latitude , listing.longitude , listing.phoneAd , listing.nameContactAd ...

http://www.pickrent.com/map/core-sidebar.cfm?pm=grace-management See the map I created above. What I would like to do when a property manager inputs their unique name in to my system is for the map to be centered for all the properties. As you can see from my example the properties are not...

I have had no luck upgrading my XP machine to Windows 7 today. The DVD drive doesn't want to read the DVD ISO disc. I know the disc works because I have tried it in other machines. So I thought I would try upgrading to Vista to see if it could read the disc, but that didn't work either. I have...

I have several scheduled tasks I run nightly that I would like to capture the results of to a static html document so in the morning if I want to check what happened the night before I can see the results of the tasks. I used to have this neat feature on my old Coldfusion dedicated box, but I...

The code below copies information from one table to another (I am changing my database structure). The code works, however as you can imagine it updates all entries in the zipcode table for matching "Denver" and "CO" records and I only want to update the first Denver it comes to. Is there some...

Zipcode 350 mile radius search. <!--- Set the raduis of the search in miles ---> <cfset radiusMiles = 350> <!--- Get one zipcode to create a raduis around ---> <cfquery name="GetZipInfo" datasource="#Application.DSN#"> SELECT * FROM zipcodes WHERE zip = 80202 </cfquery> <!--- Get all...

Will setting a log in for 4 hours: <CFLOGIN idletimeout="14400"> be trumped by <cfset this.applicationTimeout = createTimeSpan(0,0,20,0)> (20 minutes) within the Application.cfc? So what I am asking is even though I have cflogin set to 4 hours will applicationTimeout make it time out after...

I have an area of my web site that I allow image uploads without signing in. However if I person never activates their listing I would like to flush those images on a daily basis. How do I query the table of good images and then <cffile action="delete" file="d:\inetpub\example\photos\#x#"> the...

I do not want a visitor to submit a form on my site that does not have JavaScript enabled. In the following code the form submits just fine but my validation function does not run. The Form: <form name="addedit" action="crud_add_process.cfm" method="post" onSubmit="return validate_addedit();">...