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]
_____
<<attachment: winmail.dat>>
