Your criteria expression is the problem (i.e., the WHERE
ID='#Session.TradeID#' clause)
My guess is that the TradeID field isn't a text field in which case there
shouldn't be any quote marks around it. Remove them and see what you get.
Jesse D. Roberts
Business Process Analyst
Procurement Quality Assurance
Boeing - Huntington Beach, CA
[EMAIL PROTECTED]
Ph. 714-896-3462
Fx. 714-896-3303
> -----Original Message-----
> From: Samantha Jones [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, June 02, 2000 3:17 AM
> To: [EMAIL PROTECTED]
> Subject: writing to a database error
>
> Hi,
> I'm new to this so I hope I've mailed the right list...
>
> I keep getting the following error:
>
> ODBC Error Code = 22005 (Error in assignment)
> [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria
> expression.
> The error occurred while processing an element with a general identifier
> of (CFQUERY), occupying document position (199:1) to (199:49).
>
> I am trying to update the database with text fields, and also a date,
> which I create at the top of the document. I don't think it's this
> that's causing the error as in another part of the system, I add a line
> to the db with the date. Even when I take the date out of the update, it
> says there is a syntax error, even though it is exactly the same syntax
> used elsewhere that works perfectly well. This is the update code:
>
> <CFQUERY NAME="UpdateTrade" DATASOURCE="updates">
> UPDATE Trade
> SET TradeTitle='#Session.TradeTitle#',
> DateFromDay='#Session.DateFromDay#',
> DateFromMonth='#Session.DateFromMonth#',
> DateFromYear='#Session.DateFromYear#',
> DateToDay='#Session.DateToDay#',
> DateToMonth='#Session.DateToMonth#',
> DateToYear='#Session.DateToYear#',
> FromDate='#FromDate#',
> ToDate='#ToDate#',
> Venue='#Session.Venue#',
> StandNumber='#Session.StandNumber#',
> Town='#Session.Town#',
> Country='#Session.Country#'
> WHERE ID='#Session.TradeID#'
> </CFQUERY>
>
> Am I missing something dead obvious cos I've been looking at it too
> long?
>
> Any ideas would be greatly appreciated,
>
> Sam
>
> Sam Jones
> Web Developer
> The Loop
> 0207 721 8643
>
> --------------------------------------------------------------------------
> ----
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
