This doesn't work, but I'm guessing you guys know what I'm trying to
accomplish.
<cfquery name="prospects" datasource="#dsn#">
UPDATE Wishlist
SET WritingNo='ABCDE'
WHERE WishlistID IN (13,15,74,87)
</cfquery
What's the correct syntax to do this?
Scott
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3390
Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/sql/unsubscribe.cfm
