Dave,
I seem to remember there being a problem (read: bug) accessing the query
values from a nested loop. That is, if you're outer most loop is over a
query, the inner loops won't have access to the query variables. I
cannot remember off-hand if this affects only <cfoutput> looping or if
it also affects <cfloop> looping. What you could do *I think* is store
the value of qWpLocs.numLocationID in a variable in the outside loop,
and then access that variable in the inner loop.
Chris
Dave Crandell wrote:
Hey guys - this code has been driving me nuts for two days now....
I've got a query that is supposed to insert data from a few different
recordsets ... all the data is inserted fine except the value
#qWpLocs.numLocationID#.
I print the variable twice for debugging and on the first iteration
just inside my loop of qWpLocs, it prints correctly. However when I
try to insert it/print it from inside my qProdContent output, it only
inserts and prints the value from the first iteration...
below is a sample of my debug output and below that is my code ... if
y'all can see what I may be doing wrong, that'd rule...
1834
1834
1834
1812
1834
1834
1820
1834
1834
1824
1834
1834
1826
1834
1834
1850
1834
1834
1866
1834
1834
1874
1834
1834
-------
<cfoutput>
<!--- INSERT WizPlayer Production Record INTO
tblProductions --->
<cfquery name="qInsWPProd" datasource="#dbCn#"
username="#dbUsr#" password="#dbPw#">
INSERT INTO tblProductions
(autProductionID, dtmCreated, numCustomerID, intDeleted)
VALUES (#qProdData.autProductionID#,
#Now()#, #qProdData.intCustomerID#, 0)
</cfquery>
</cfoutput>
<!--- LOOP THROUGH WP LOCATIONS--->
<cfloop query="qWpLocs">
<cfoutput><div
style="color:blue;">#qWpLocs.numLocationID#</div></cfoutput>
<!--- INSERT WizPlayer Production Content INTO
tblProductionContent --->
<cfoutput query="qProdContent">
<cfquery name="qInsWPProdContent"
datasource="#dbCn#" username="#dbUsr#" password="#dbPw#">
INSERT INTO tblProductionContent
(
numProductionID,
numLocationID,
txtBGMusicFile,
intSortOrder,
txtWaveFile,
txtUploadTime,
dtmUpload,
intContentID,
intChange,
intMusicInterval
)
VALUES
(
#qProdData.autProductionID#,
#qWpLocs.numLocationID#,
'#qProdData.txtBGMusicFile#',
#qProdContent.intSortOrder#,
'#qProdContent.txtWaveFile#',
'#qProdData.dtmUploaded#',
'#qProdData.txtUploadTime#',
#qProdContent.autProductionContentID#,
1,
#qProdData.intSeconds#
)
</cfquery>
<div>#qWpLocs.numLocationID#</div>
</cfoutput>
</cfloop>
--
Dave C
www.davesbizarre.com <http://www.davesbizarre.com>
------------------------------------------------------------------------
_______________________________________________
Reply to DFWCFUG:
[email protected]
Subscribe/Unsubscribe:
http://lists1.safesecureweb.com/mailman/listinfo/list
List Archives:
http://www.mail-archive.com/list%40list.dfwcfug.org/
http://www.mail-archive.com/list%40dfwcfug.org/
DFWCFUG Sponsors:
www.instantspot.com/
www.teksystems.com/
--
http://www.cjordan.us
_______________________________________________
Reply to DFWCFUG:
[email protected]
Subscribe/Unsubscribe:
http://lists1.safesecureweb.com/mailman/listinfo/list
List Archives:
http://www.mail-archive.com/list%40list.dfwcfug.org/
http://www.mail-archive.com/list%40dfwcfug.org/
DFWCFUG Sponsors:
www.instantspot.com/
www.teksystems.com/
