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> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2887 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
