I have been doing the CFDUMP. It looks fine. -----Original Message----- From: Ray Thompson [mailto:[EMAIL PROTECTED] Sent: Monday, July 23, 2007 1:33 PM To: SQL Subject: RE: SQL not answering
I missed that. I would do a CFDUMP on that form variables to see if you really have a number in that field and if it is a number, that it is formatted properly. You might have decimal or some other form that will pass the IsNumber() test, but fail on the query. CFDUMP is your friend. 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 1:19 PM To: SQL Subject: RE: SQL not answering 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> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2888 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
