Hi, Tom... it's MySQL 5.
The code in my last email is working properly.
However, now I have a problem executing this:
<cfschedule
action = "run"
task = "02_Process HMLS Office Data Text File"
startdate = "#DateFormat(Now(), 'm/d/yy')#"
starttime = "#TimeFormat(DateAdd('n', 5,
now()), 'h:mm tt')#"
interval = "once" >
I'm trying to run code like this at the end of each document that is
processed as a scheduled task to set up the next task one the current task
is complete. (The tasks are dependent)
I keep getting this error: Error 500: Internal Server Error
Is there anything wrong with the code above?
Thanks,
Rick
> -----Original Message-----
> From: Tom Chiverton [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 26, 2008 5:29 AM
> To: CF-Talk
> Subject: Re: Trying to read a text file of data and input into db...
>
> On Thursday 26 Jun 2008, Rick Faircloth wrote:
> > I'm trying to read a tab-delimited text file of data
> > and separate it into field data so I can input it into a database.
>
> Almost all databases have a special bulk import tool or command, which may or
> may not require cfexecute.
> What database is this ?
>
> --
> Tom Chiverton
>
> ****************************************************
>
> This email is sent for and on behalf of Halliwells LLP.
>
> Halliwells LLP is a limited liability partnership registered in England and
> Wales under registered
> number OC307980 whose registered office address is at Halliwells LLP, 3
> Hardman Square,
Spinningfields,
> Manchester, M3 3EB. A list of members is available for inspection at the
> registered office. Any
> reference to a partner in relation to Halliwells LLP means a member of
> Halliwells LLP. Regulated
by The
> Solicitors Regulation Authority.
>
> CONFIDENTIALITY
>
> This email is intended only for the use of the addressee named above and may
> be confidential or
legally
> privileged. If you are not the addressee you must not read it and must not
> use any information
> contained in nor copy it nor inform any person other than Halliwells LLP or
> the addressee of its
> existence or contents. If you have received this email in error please
> delete it and notify
Halliwells
> LLP IT Department on 0870 365 2500.
>
> For more information about Halliwells LLP visit www.halliwells.com.
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308184
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4