That is very true, and I have added the missing line
<cfqueryparam cfsqltype="cf_sql_number" value="#id#">,
But did not make any difference to the error message it is still saying
what is shown below. It is also worth looking at the SQL and you will
see that no values have been passed just (param1), (param2) etc ???
Error Executing Database Query.
[Macromedia][Oracle JDBC Driver][Oracle]ORA-00917: missing comma
The error occurred in
F:\Websites\Intranet\itintranet\publishing\articleaction.cfm: line 55
53 : <cfqueryparam cfsqltype="cf_sql_varchar" value="#security#">,
54 : <cfif
isdefined("file.serverFile")>'#file.serverFile#'<cfelse>NULL</cfif>,
55 : <cfqueryparam cfsqltype="cf_sql_blob" value="#content#">
56 : </cfquery>
57 :
________________________________
SQL INSERT INTO itarticle (id, articledate, articletitle,
articlesummary, articleauthor, security, imgsrc, articlebody) VALUES (
(param 1) , (param 2) , (param 3) , (param 4) , (param 5) , (param 6) ,
NULL, (param 7)
DATASOURCE intranetv8
VENDORERRORCODE 917
-----Original Message-----
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: 22 December 2003 14:52
To: CF-Talk
Subject: RE: Date Errors in MX ?
Ian Vaughan said:
>
> Error Executing Database Query.
>
> [Macromedia][Oracle JDBC Driver][Oracle]ORA-00917: missing
comma
Your field list has 8 entries, your values list only 7.
Jochem
________________________________
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
