RE: Date Errors in MX ?

Ian Vaughan Mon, 22 Dec 2003 07:31:25 -0800

Jochem

I have just changed the query to what is below and received the
following error

Error Occurred While Processing Request

Error Executing Database Query.

[Macromedia][Oracle JDBC Driver][Oracle]ORA-00911: invalid character

The error occurred in
F:\Websites\Intranet\itintranet\publishing\articleaction.cfm: line 54

52 : <cfqueryparam cfsqltype="cf_sql_varchar" value="#security#">,
53 : <cfif
isdefined("file.serverFile")>'#file.serverFile#'<cfelse>NULL</cfif>,
54 :     <cfqueryparam cfsqltype="cf_sql_blob" value="#content#">;
55 : </cfquery>
56 :

<cftransaction>

  <cfquery name="LOOKUP" datasource="intranetv8">
   SELECT Max(id) NewID
   FROM itarticle
  </cfquery>

  <cfif lookup.newid is "">
   <cfset id = 1>
  <cfelse>
   <cfset id = lookup.newid + 1>
  </cfif>



<cfset articledate = form.event_month & "/" & form.event_day & "/" &
form.event_year>
<cfset articledate = #CreateODBCDate(articledate)#>
<cfset formatted_date = dateformat(articledate, "MM/DD/YYYY")>

<cfset content = REReplacenocase(content, "</*font[^<>]*>", "", "ALL")>
<cfset content = REReplacenocase(content, "</*span[^<>]*>", "", "ALL")>

<cfif form.uploadfile neq "">

<cffile action="" filefield="Form.UploadFile"
destination="F:\Websites\Intranet\itintranet\itnews\images\"
nameconflict="OVERWRITE">
</cfif>




<cfquery datasource="#Application.DSN#" name="insert_query">
  INSERT INTO itarticle (id, articledate, articletitle, articlesummary,
articleauthor, security, imgsrc, articlebody)
  VALUES (
    <cfqueryparam cfsqltype="cf_sql_date" value="#articledate#">,
    <cfqueryparam cfsqltype="cf_sql_varchar" value="#articletitle#">,
    <cfqueryparam cfsqltype="cf_sql_varchar" value="#articlesummary#">,
    <cfqueryparam cfsqltype="cf_sql_varchar" value="#Session.Fname#
#Session.Lname#">,
    <cfqueryparam cfsqltype="cf_sql_varchar" value="#security#">,
    <cfif
isdefined("file.serverFile")>'#file.serverFile#'<cfelse>NULL</cfif>,
    <cfqueryparam cfsqltype="cf_sql_blob" value="#content#">
</cfquery>

</cftransaction>

-----Original Message-----
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: 22 December 2003 12:08
To: CF-Talk
Subject: RE: Date Errors in MX ?

Ian Vaughan said:
>
> <cftransaction>

It would be better to use a sequence for primary key generation.
If
you also use cfqueryparam your 3 query transaction reduces to 1
query.

<cfset storydate =
CreateDate(form.event_year,form.event_month,form.event_day>

<cfset content =
REReplacenocase(content,"</*(font|span)[^<>]*>","","ALL")>

<cfquery datasource="#Application.DSN#" name="insert_query">
  INSERT INTO itarticle (
    articledate,
    articletitle,
    etc.
    itarticle
    )
  VALUES (
    <cfqueryparam cfsqltype="cf_sql_date" value="#storydate#">,
    <cfqueryparam cfsqltype="cf_sql_varchar"
value="#articletitle#">,
    etc.
    <cfqueryparam cfsqltype="cf_sql_clob" value="#content#">
</cfquery>

Jochem
________________________________

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: Date Errors in MX ?

Reply via email to