Re: Access and cfquery problem
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 > > Update messages set > title='#Form.title#',subject='#Form.subject#',body='#Form.body#' where > id='#Form.id#' > 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 Montgomerymonty @ 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
Access and cfquery problem
I am trying to run the following query with an Access database Update messages set title='#Form.title#',subject='#Form.subject#',body='#Form.body#' where id='#Form.id#' However, I get the following error: Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression. The error occurred on line 15. Any ideas on what is happening? thanks, Luis R. Lebron Project Manager Sigmatech, Inc ~| 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
