I need help. Below is some code from my website.
I have an array that I use to keep stack of the selected songlist.
The FORM.SongNumber is correct, but I can not get the query to answer in the
<cfoutput> (****) clause listed below.
if I just set the query to a specific integer, it answers and the <cfoutput>
clause mentioned creates text.
Do I have a type casting problem? Why does the query not answer?
Thanks,
Bob
<cfquery name="getAudioInfo"
datasource="#APPLICATION.DataSource#" >
SELECT * FROM tbl_audio
WHERE
tbl_audio.Song_No = #FORM.SongNumber#
</cfquery>
<cfxml variable="xmlObject" casesensitive="yes">
<node>
<cfloop from="1" to="#(SESSION.SongListPtr - 1)#" index="y" >
<cfset FORM.SongNumber = #SESSION.SongList[#y#][2]# >
****>>> <cfoutput>Song Number = #FORM.SongNumber#
<node label="#FORM.SongNumber#" album=""
artist="" >
</node></cfoutput>
<cfoutput query="getAudioInfo">
<node label="#Title#" album="#Album_No#" artist="" >
</node>
</cfoutput>
</cfloop>
</node>
</cfxml>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Check out the new features and enhancements in the
latest product release - download the "What's New PDF" now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf
Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2882
Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
