I have this query...
<cfquery DATASOURCE="#mydbname#" NAME="UpdateData">
UPDATE ImageData
SET PageViews = (PageViews + 1),
ImageID = ListRandImage
WHERE ImageID = ListRandImage
</cfquery>
With this error code...
Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft
Access Driver] Too few parameters. Expected 1.
The error occurred in E:\_Applewood\admin\testbanner\showbanner.cfm: line 45
45 : <cfquery DATASOURCE="applewood" NAME="UpdateData">
46 : UPDATE ImageData
47 : SET PageViews = (PageViews + 1),
Every variable in there is valid. Would it be because PageViews is empty at
the moment?
Thanks
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:182296
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=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
