For anyone interested in how I fixed the error I was getting using
Query_repeater and CF 4.5:
I simply removed the "maxrows" attribute from the code that actually runs
the query. I'm not sure why that was throwing back the "can't convert
99999999999 to and integer" error, but deleting the attribute altogether
makes it run like a charm - like it did on 4.01.
Thanks for the tips, hints and advice.
Erika
----- Original Message -----
From: "Peter Tilbrook" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, April 18, 2000 9:09 PM
Subject: RE: What the heck is wrong with 4.5 and my queries?
> The custom tag just might not be compatible with 4.5. I had to go back to
> 4.01 for a similar reason (but with a CFX).
>
> -----Original Message-----
> From: Erika Foster [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, 19 April 2000 2:56 PM
> To: [EMAIL PROTECTED]
> Subject: What the heck is wrong with 4.5 and my queries?
>
>
> The first problem I encountered after ugrading was 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.
> ~~~~~~~~~~~~~~~~~~~~~~~
>
> When using query_repeater. This error never happened with 4.01.
>
> Now, I'm getting the following error with the code below:
>
> Error:
>
> ODBC Error Code = S1000 (General error)
> [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable
> query.
> SQL = "INSERT INTO Inventory (SL, SLN, compound, manufacturer, activity,
> product, NSN, ContainerSize, quantity, ro, rop) VALUES ('FL-1', 'abc',
> '256', 'abc', '05A05', 'abc', 'abc', 'abc', 'a', 'abc', 'abc')"
>
> Code:
>
> <cfloop index="i" FROM="1" TO= "10" >
> <cfset Thissl = Evaluate("Form.sl" & i)>
> <cfset Thiscompound = Evaluate("Form.compound" & i)>
> <cfset Thisactivity = Evaluate("Form.activity" & i)>
> <cfset ThisManufacturer = Evaluate("Form.Manufacturer" & i)>
> <cfset ThisProduct = Evaluate("Form.Product" & i)>
> <cfset ThisNSN = Evaluate("Form.NSN" & i)>
> <cfset ThisContainerSize = Evaluate("Form.ContainerSize" & i)>
> <cfset ThisQuantity = Evaluate("Form.Quantity" & i)>
> <cfset ThisRO = Evaluate("Form.RO" & i)>
> <cfset ThisROP = Evaluate("Form.ROP" & i)>
> <cfset ThisSLN = Evaluate("Form.SLN" & i)>
>
> <cfif (Evaluate("Form.Product"&i) NEQ "")>
> <cfquery name="addrow" datasource="facilities">
> INSERT INTO Inventory (SL, SLN, compound, manufacturer, activity,
> product, NSN, ContainerSize, quantity, ro, rop)
> VALUES ('#thissl#', '#thissln#', '#thiscompound#',
> '#ThisManufacturer#', '#thisactivity#', '#thisproduct#', '#thisNSN#',
> '#thiscontainersize#', '#thisquantity#', '#thisro#', '#thisrop#')
> </cfquery>
> </cfif>
> </cfloop>
>
> Can someone help? I'm in the process of upgrading to 4.5.1 right now -
I'm
> hovering at 89% complete but I'm tired and cranky and need this to work
> tomorrow. Will the upgrade fix this? Anyone?
>
> Thanks,
> 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.
>
> --------------------------------------------------------------------------
----
> 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.
------------------------------------------------------------------------------
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.
