It's in the original e-mail I send.
I pull it from the 2 dimensional Array called SESSION.SongList[][].
<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>
-----Original Message-----
From: Ray Thompson [mailto:[EMAIL PROTECTED]
Sent: Monday, July 23, 2007 1:13 PM
To: SQL
Subject: RE: SQL not answering
I don't see where you have SongNumber (which you are using in the query)
in
the sending form.
Ray Thompson
Tau Beta Pi (www.tbp.org)
The Engineering Honor Society
865-546-4578
-----Original Message-----
From: Robert Ketrick [mailto:[EMAIL PROTECTED]
Sent: Monday, July 23, 2007 12:55 PM
To: SQL
Subject: RE: SQL not answering
Hi Ray,
Is what I am using. I used a IsNumeric() test at one point to see if it
is an integer.
I passed the IsNumeric test.
Bob
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:2886
Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
