Mike,
You need to remove the quotes from your ID field
(which is a number, I assume...)
<CFQUERY DATASOURCE="dbcms">
UPDATE tbldistrib
SET distrib_name='#Form.distrib_name#',
distrib_city='#Form.distrib_city#',
distrib_state='#Form.distrib_state#',
distrib_phone='#Form.distrib_phone#'
WHERE distrib_id = #distrib_id#
</CFQUERY>
> Any help with this will be much appreciated.
>
> My Query is as follows:
>
> <CFQUERY DATASOURCE="dbcms">
> UPDATE tbldistrib
> SET distrib_name='#Form.distrib_name#',
> distrib_city='#Form.distrib_city#',
> distrib_state='#Form.distrib_state#',
> distrib_phone='#Form.distrib_phone#'
> WHERE distrib_id = '#distrib_id#'
> </CFQUERY>
>
> I have a hidden field in my update form for the
> distributor ID:
>
> <INPUT TYPE="hidden" NAME="distrib_id"
> Value="#distrib_id#">
>
> The error I receive is:
>
> ODBC Error Code = 22005 (Error in assignment)
> [Microsoft][ODBC Microsoft Access Driver] Data type
> mismatch in criteria
> expression.
>
> SQL = "UPDATE tbldistrib SET distrib_name='Calico
> Corners III',
> distrib_city='Charlston', distrib_state='SOUTH
> CAROLINA',
> distrib_phone='555-555-5555' WHERE distrib_id =
> '31'"
> Data Source = "DBCMS"
>
> The error occurred while processing an element with
> a general identifier of
> (CFQUERY), occupying document position (2:1) to
> (2:29) in the template file
> c:\inetpub\wwwroot\cms\updatedata.cfm.
>
> Thanks for your time,
> Mike
>
>
------------------------------------------------------------------------------------------------
> Archives:
>
http://www.mail-archive.com/[email protected]/
> Unsubscribe:
> http://www.houseoffusion.com/index.cfm?sidebar=lists
> or send a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
__________________________________________________
Do You Yahoo!?
Yahoo! Messenger - Talk while you surf! It's FREE.
http://im.yahoo.com/
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
