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
