What does your form data look like? Is the form truly returning a number? Also I would suggest you use cfqueryparam to avoid SQL injection site hacks.
Ray Thompson Tau Beta Pi (www.tbp.org) The Engineering Honor Society 865-546-4578 -----Original Message----- From: Bob Ketrick [mailto:[EMAIL PROTECTED] Sent: Monday, July 23, 2007 11:59 AM To: SQL Subject: SQL not answering 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> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2883 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
