Try outputting the SQL query as text (ie change cfquery for cfoutput) and then run that code in Access to find out what's going wrong. Should help.
Paul ------------------------------------------- Paul Johnston PJ Net Solutions Ltd http://www.pjnetsolutions.com [EMAIL PROTECTED] +44 (0)7866 573013 > -----Original Message----- > From: Paddy McKay [mailto:[EMAIL PROTECTED]] > Sent: 13 January 2003 15:08 > To: [EMAIL PROTECTED] > Subject: [ cf-dev ] Probs with Data types under CFMX > > > HELP! > > I've upgraded my development web server and have installed > everything from scratch i.e. Windows NT 4 Server SP6a, IIS4, > and CFMX Pro. > > Having got the box running, and configured the datasources > for CFMX, I am now finding that one of the routines that > worked quite happily under CF 4.5 is not working. It is > attempting to update a table in Access97, and is throwing the > following error > > Type Database > Cfcatch Message: Error Executing Database Query. > Detail [MERANT][SequeLink JDBC Driver][ODBC > Socket][Microsoft][ODBC Microsoft Access 97 Driver] Data type > mismatch in criteria expression. > > > > > The CF code is:- > > <cfquery name="act_updateLISComment" > datasource="#request.maindsn#"> update LISComments set > COMMENT = '#attributes.COMMENT#', CREAT_DTE = > '#attributes.CREAT_DTE#', USER_ID = '#attributes.USER_ID#', > CommentType = '#attributes.CommentType#', CommentSource = > '#attributes.CommentSource#', UPdate_DATE = #now()#, > Update_User = '#request.username#' where COMENT_ID = > #attributes.COMENT_ID# </cfquery> > > The data type of the field Coment_ID is Number, with the size > Double. Changing the data type or size would have knock on > effects as the data gets copied up to SQL Server twice a week. > > Anyone any thoughts on how to get around this? > > All help much appreciated. > > paddy > > ------ > Paddy McKay > Scottish Property Network > www.ScottishProperty.co.uk > Tel: 0141 561 7300 > Fax: 0141 561 7319 > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: > [EMAIL PROTECTED] For human help, e-mail: > [EMAIL PROTECTED] > > > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
