Let's say I'm trying to update the column "PRICE" in rows 1, 2 and 3
when my form is submitted:
<cfif IsDefined("form.upDATEME") AND #form.upDATEME# EQ "Yes">
<cfset QuerySetCell(ventkit, "PRICE", #form.Price1# , 1)>
<cfset QuerySetCell(ventkit, "PRICE", #form.Price2# , 2)>
<cfset QuerySetCell(ventkit, "PRICE", #form.Price3# , 3)>
</cfif>
"ventkit" is the name of my query on the page.
The formfields containing the values are named "Price1", "Price2" and
"Price3".
Using SQL Server
This isn't giving an error, but isn't updating the database either. I'm
not sure what I'm doing wrong. Obviously I'm a "QuerySetCell Newbie"...
Advise please?
--
Les Mizzell
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=35
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182392
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
