Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
CFLOOP of recordset/insert into seperate table
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. -
CFLOOP of recordset/insert into seperate table
Thanks Lyndon, I had it stuck in my head that a CFLOOP was going to be needed. Your solution worked out great. -
CFLOOP of recordset/insert into seperate table
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... -
Scheduled tasks across two servers - Run same time!!
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... -
Textbox Entry - Set as Two Variables
OOPS, Disregard example3 in last post. Wouldn't work.. Dave -
Textbox Entry - Set as Two Variables
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... -
CFCHART x-axis baseline
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... -
disconnect from a datasource
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. -
CFMX Server
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 -
CFMX Server
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
