Recent content by 3dColor

Thanks Rudy that worked.

Andrew, thanks for answering my question. I tried this but it returns all the records instead of the ones just for yesterday. What did I do wrong? <cfquery name="GetAptsStats" datasource="#DSN#"> SELECT listingFk, listingId, DATE(DATE_SUB( timeStampStats, INTERVAL 1 DAY)) FROM...

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...

Rudy, I thought it was working when i first tried it but now since I have a lot of data now it does not return the correct recordset. It is returning 59 out of the 64 records in the table. I only have only 1 successful thankyou (1) page accessed so I should only see 1 record returned. I just...

Wow! Thanks once again Rudy. You are the man! Looks like you got up early this morning.

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 got it working with the help of Ray Camden: <cfhttp url="http://maps.googleapis.com/maps/api/geocode/xml?address=1600+Amphitheatre+Parkway,+Mountain+View,+CA&sensor=true" method="GET" resolveurl="No" timeout="30" throwonerror="yes"> </cfhttp> <cfset xmlDoc = XmlParse(CFHTTP.FileContent)>...

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...

Wow, I can't believe I actually figured it out by myself! <!--- Davenport FL 33836 closest to 172 ---> <cfset dbvlatitude = "30.476181"> <cfset dbvlongitude = "-83.403030"> <cfquery name="GetNearestMetroFk" datasource="#DSN#"> SELECT zip , latitude , longitude...

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'...

Thanks Rudy, I really appreciate it!

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...

Thanks everyone for the help. I tried a bunch of stuff including bootrec.exe and other command prompt stuff but the registry was screwed so I started all over again with a clean install.

OK, I am reporting back with what I found. The repair idea didn't work for some reason. I took pictures of what I tried and placed them on my web site of all the screen captures. http://www.davecolorado.com/index.php/moving-system-active-to-another-hard-drive-2/ Please take a look at what I...