I'm trying to update the pageviews + 1 every time a banner is shown on the browser. But for some reason my code stopped at 2. It wont go any higher. The first and second times the code updated correctly. It went from 1 pageview to 2 pageviews..now everything is 2 pageviews even though there are at least 3 in the db. Here is my code...The highlighted portion of the code is my addition statement. I seem to think its about my calling pageviews from getinfo3 but i cant wrap my noggin around it.
....<cfquery datasource="applewood" name="Getinfo3"> SELECT * FROM ImageData WHERE ImageID = #ListRandImage# </cfquery> <cfquery DATASOURCE="#mydbname#" NAME="UpdateData"> INSERT INTO ImageData ( PageViews, ImageID, ImageShowDate ) VALUES ( (#Getinfo3.PageViews# + 1), #ListRandImage#, #createodbcdate(DateFormat(now(), "mm/dd/yyyy"))# ) </cfquery> Any thoughts? Phil ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Sams Teach Yourself Regular Expressions in 10 Minutes by Ben Forta http://www.houseoffusion.com/banners/view.cfm?bannerid=40 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182407 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
