Howdy Luis, Friday, January 24, 2003, 4:32:42 PM, Luis Lebron wrote:
> I am trying to run the following query with an Access database > <cfquery name="UpdateMessage" datasource=#DataSource#> > Update messages set > title='#Form.title#',subject='#Form.subject#',body='#Form.body#' where > id='#Form.id#' > </cfquery> I'm guessing that your "id" field is of type numeric. If so, remove the single quotes and it should work ok, i.e., where id = #form.id#. Hope that helps. -- Chris Montgomery monty @ airtightweb.com Airtight Web Services http://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-2415 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
