Thanks Paul, That threw up the fact that it didn't like the date format. Problem solved!
cheers paddy ----- Original Message ----- From: "Paul Johnston" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, January 13, 2003 3:32 PM Subject: RE: [ cf-dev ] Probs with Data types under CFMX > 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] > -- ** 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]
