>
> <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]
