---------- Original Message ----------------------------------
From: "Pascal Peters" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date: Wed, 11 Aug 2004 08:47:52 +0200
>And the problem is ... ?
>
>> -----Original Message-----
>> From: dave [mailto:[EMAIL PROTECTED]
>> Sent: 11 August 2004 08:34
>> To: CF-Talk
>> Subject: scheduled task woes
>>
>> havin some probs with this scheduled task running
>> its on a linux server and has been registered with the host too run
>the
>> task
>> needs to run ever 15 minutes
>>
>> code
>> this is on the page the task is set too run on
>>
>> <!--- run every 15 minutes --->
>> <cfschedule
>> Task="River Flow Updates"
>> ACTION=""> >> OPERATION="httprequest"
>> URL=""> >> INTERVAL="900"
>> STARTDATE="08/11/2004"
>> >
>>
>>
>>
>> the scheduled page
>> actually needs to loop through recordset
>> (simple version)
>>
>>
>> <!--- get all rivers --->
>> <cfquery name="qGetRivers" datasource="#dsn#" username="#un#"
>> password="#pw#">
>> SELECT * FROM flows
>> </cfquery>
>>
>>
>> <!--- retrieve info from USGS website --->
>> <cfhttp url=""> >> method="get">
>> </cfhttp>
>>
>> <!--- place contents into a formated variable --->
>> <cfset data = ""> >>
>>
>> <!--- set retrieved variables--->
>> <cfset setDate = DateFormat(dateTime, "mmm-dd-yyyy")>
>> <cfset setTime = TimeFormat(dateTime, 'hh:mm:ss tt')>
>> <cfset last = listLast(data, "USGS")>
>> <cfset riverNumber = listGetAt(last, 1, chr(9))>
>> <cfset dateTime = listGetAt(last, 2, chr(9))>
>> <cfset waterFlow = listGetAt(last, 3, chr(9))>
>>
>> <!--- check too see if this river has temp available --->
>> <cfif #qGetRivers.riverType# EQ 2>
>> <cfset waterTemp = listGetAt(last, 4, chr(9))>
>> <cfelse>
>> <cfset waterTemp = "N/A">
>> </cfif>
>>
>>
>>
>> <!--- insert the contents of the form into the db --->
>> <cfquery name="addflows" datasource="#dsn#" username="#un#"
>> password="#pw#">
>> UPDATE flows
>> SET riverNumber = '#riverNumber#'
>> , enteredDate = '#setDate#'
>> , enteredTime = '#setTime#'
>> , waterFlow = '#waterFlow#'
>> , waterTemp = '#waterTemp#'
>>
>> WHERE riverID = '#qgetRecords.riverID#'
>> </cfquery>
>>
>>
>>
>> any thoughts
>> tia
>>
>>
>>
>>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
