<cfoutput>
INSERT INTO IVES.VIDEO (IVESID, VIDEOID, INVENTORYKEYCODE) VALUES (#IvesId#, #VideoNumber#, '#InventoryKeyCode#')<br />
</cfoutput>
That will spit each of your queries out to the screen and you can see what CF is seeing--might make tracking down the issue a bit easier. Unless you're experiencing general database issues, there *has* to be something in your data that is causing the query to blow up.
Matt
On May 17, 2005, at 8:31 PM, Gary L. Alford wrote:
All data types are correct. That's the first thing I checked. The
InventoryKeyCode is a system generated number established in a <cfset... tag
nested inside a <cfloop... The loop syntax is
<cfloop from="1" to="#form.VideoNo#" index="VideoNumber"> <cfset InventoryKeyCode = #InventoryKeyCode# & #VideoIdent# & "-" & #VideoNumber#> <cfquery name="AddCase" datasource="#DBDSN#" username="#AppID#"> password="#AppPW#"> INSERT INTO IVES.VIDEO ( IVESID, VIDEOID, INVENTORYKEYCODE) VALUES ( #IvesId#, #VideoNumber#, '#InventoryKeyCode#') </cfquery> </cfloop>
I really don't know what to make of this problem.
________________________________
Gary L. Alford Adjunct Professor, Dallas Baptist University (817) 261-6238 [EMAIL PROTECTED] ________________________________
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Matthew Woodward
Sent: Tuesday, May 17, 2005 8:02 PM
To: [email protected]
Subject: Re: I'm about to pull out what little hair I have...
Guessing here, but the first thing I'd check is the datatypes of the data
that you're inserting into the database and other data-related issues.
First off, make sure that IvesID and VideoNumber are both integers; if not,
they'll need single-quotes around them. (I'm assuming this is the case and
they're fine as is, but you never know ...) Second, what's up with the
InventoryKeyCode? Does that piece of data itself have any single quotes in
it or other characters that might throw the database?
It would be really helpful if you created your query statement as a string
and just output it to the screen--then you could see what CF sees when it's
attempting to do the insert.
Matt
On May 17, 2005, at 7:55 PM, Gary L. Alford wrote:
Windows 2000 Server IE Version 6.0.2800.1106 Oracle 9i Database CFMX Server 6.1 Development running on IIS (no public / hosted server as yet)
I have a query:
<cfquery name="AddCase" datasource="#DBDSN#" username="#AppID#" password="#AppPW#"> INSERT INTO IVES.VIDEO ( IVESID, VIDEOID, INVENTORYKEYCODE) VALUES ( #IvesId#, #VideoNumber#, '#InventoryKeyCode#') </cfquery>
that returns the following error:
Error Occurred While Processing Request
The string is not closed.
String begins on line 398, column 44.
The CFML compiler was processing:
* The body of a cfquery tag beginning on line 269, column 2.
The error occurred in C:\Inetpub\wwwroot\IVES\admin \AddCaseAction.cfm: line 398
396 : #IvesId#,
397 : #VideoNumber#,
398 : '#InventoryKeyCode#')
399 : </cfquery>
400 : </cfloop>
Similar problems have arose when trying to insert a literal value in other queries (i.e. INSERT INTO DATATABLE (FIELD1) VALUES ('V').
Can someone please shed some light? (Please note: I am not a CF Administrator guru. If it involves settings in my CF Administrator, please walk me through it carefully.)
TIA
_____
Gary L. Alford Adjunct Professor, Dallas Baptist University (817) 261-6238 [EMAIL PROTECTED] _____
<winmail.dat>
-- Matthew Woodward [EMAIL PROTECTED]
---------------------------------------------------------- To post, send email to [email protected] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm
---------------------------------------------------------- To post, send email to [email protected] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm
-- Matthew Woodward [EMAIL PROTECTED]
----------------------------------------------------------
To post, send email to [email protected]
To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm
To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm
