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]
