You can indeed set query cells in CF, but those won't automatically update the database, you'll just be updating the query in memory. If you need to post the updates to a database you'll need to do that yourself.
--- Ben -----Original Message----- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Thursday, October 21, 2004 4:22 PM To: CF-Talk Subject: Referencing a Specific Row I know I can reference a specific row (SQL Server) like: #myQUERY.myCOLUMN[3]# Out of curiosity, can you also use that to UPDATE a record? (In sorta Engligh) Update myTABLE Set myCOLUMN[3] to form.input3, Set myCOLUMN[5] to form.input5 ??? -- Les Mizzell ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=34 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182274 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
