I'm using Nate Weiss's custom tag "Query_Repeater" to update many records in
a table with one submit button. It works great with CF 4.01, but since I
upgraded to 4.5, I get this error:
~~~~~~~~~~~~~~~~~~~~~~~
Error Diagnostic Information
Cannot convert 9999999999 to integer.
Please, check the ColdFusion manual for the allowed conversions between data
types
The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (68:3) to (72:35) in the template
file C:\CFUSION\CustomTags\QUERY_Repeater.cfm.
~~~~~~~~~~~~~~~~~~~~~~~~
Here's the query code, only the ID is an integer.
<cf_query_repeater
Datasource="facilities"
SQL=" UPDATE Inventory
SET sln ='##sln##',
product = '##product##',
NSN = '##NSN##',
manufacturer = '##manufacturer##',
containersize = '##containersize##',
quantity = '##quantity##',
RO = '##RO##',
ROP = '##ROP##',
date_updated='##date_updated##'
WHERE ID = ##ID## ">
Any ideas would be appreciated.
Erika
------------------------------------------------------------------------------
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.
