Created the cron job in the cfide. Then I went to the CFusionMX/lib
directory and looked at the neo-cron.xml file.
Sure enough my entry was there.
So I copied the entry in the neo-cron.xml, went back to the cfide and
deleted the manual entry I made in the Scheduled Tasks setting. Sure enough
it cleared out the neo-cron file.
So I then pasted the earlier copied (old version with the entry) contents
into neo-cron.xml. Just like it was when I created the entry through the
cfide.
Ok, all seemed well, the entry was gone in the CFIDE like I wanted....but
when I went to refresh the CFIDE screen where the scheduled tasks appear it
must do a manual sweep of the xml directories because it kept cleaning out
the file contents in neo-cron.xml...any thoughts????
Steve
-----Original Message-----
From: Schuster, Steven [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 23, 2003 9:21 AM
To: CF-Talk
Subject: Scheduled Task question?
In MX 6.1 does a scheduled task have to exist in the CF Administrator for it
to work. I was able to add them to the registry in 5 so they would not
appear in the CF Administrator and get hosed up by developers poking around.
Any ideas? I was thinking it was just an XML entry in 6.1 but was not sure
where it was stored?
Steve
-----Original Message-----
From: Ian Vaughan [mailto:[EMAIL PROTECTED]
Sent: Monday, December 22, 2003 9:24 AM
To: CF-Talk
Subject: RE: Date Errors in MX ?
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>
<!--- Insert contact into the contacts tabel in the tes8 Database --->
<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>
<!--- Make sure that file is of correct type --->
<!--- Insert the story record --->
<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]
