I got it never mind :)
-----Original Message-----
From: Phillip Perry [mailto:[EMAIL PROTECTED]
Sent: Friday, October 22, 2004 12:34 AM
To: CF-Talk
Subject: Can someone tell me why this doesn't work?
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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
The annual ColdFusion User Conference is being held Sat 6/26 - Sun 6/27/04 8am-5pm in
the Washington DC Area.
http://www.houseoffusion.com/banners/view.cfm?bannerid=44
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182298
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
