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
