I caught it and already made the change.
<cfset nextSERNO = nexSerno.serno>
<cfoutput query="getKits">
<cfset nextSERNO = nextSERNO + 1>
<cfquery name="insKITS" datasource="pbl_tracking">.....
</cfoutput>
Again, thanks for your assistance.
I need help doing a loop over the following recordsets to insert into another table. Hopefully the code/markup will explain it better.
<!--- select all kits associated with a service instruction from the form --->
<cfquery name="getKits" datasource="#dsn#">
SELECT kit
FROM ACFT_KIT
WHERE...
Since the tasks are running on two seperate servers, there could be no conflict between the two. One server is likely the problem. Check to insure that the scheduled task is set to run at the correct time in your schedule log for each. Then check to insure the servers' time settings are...
If the variables are only used for inserting the value of #form.test# into the two db columns, why use variables at all?
Example1:
INSERT INTO db_TBL(test1,test2)
VALUES('#form.test#','#form.test#')
Only if there will be further need to manipulate the values (ie.. using a CF Function to add...
How can I set the starting point of the line graph to start at the far left. The chart I am trying to create, when only one data point is available shows a grid line mid way across the x-axis. In other words it splits the chart in half and plots it right in the center, instead of the far left...
I haven't had this problem but, make sure that "Maintain Connections" is not checked in CF Admin data source. This has caused a lot of problems with Access connections for me.
Sorry I didn't get back sooner. Thanks for the links. Both turned out to be dead ends. I still haven't fixed the problem, but I haven't had time to get back to it lately.
Dave
I just installed CFMX on a WindowsXP Pro workstation w/IIS, and am receiving the following error msg in the system log.
The ColdFusion MX Application Server service terminated with service-specific error 2 (0x2).
Has anybody got the answer to why?
thanks for any help
Dave
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.