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.
