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
_______________________________________________
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/
