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 <cfform action="search.cfm" enctype="multipart/form-data" format="html"> <cfset SESSION.SonglList = ArrayNew(2)> <cfset SESSION.CheckboxList = ArrayNew(2)> <cfset SESSION.Jukebox = StructNew() > <cfset SESSION.loopLimit = #getAudioList.RecordCount#> <cfloop from="1" to="#SESSION.loopLimit#" index="k" > <cfset SESSION.CheckboxList[#k#][1] = 0 > <cfset SESSION.CheckboxList[#k#][2] = 0 > <cfinput type="checkbox" name="CheckboxListChecked" value="#k#" > <cfoutput query="getAudioList" startrow="#k#" maxrows="1"> <cfset SESSION.CheckboxList[#k#][1] = #Genre_No# > <cfset SESSION.CheckboxList[#k#][2] = #Song_No# > </cfform> Bob -----Original Message----- From: Ray Thompson [mailto:[EMAIL PROTECTED] Sent: Monday, July 23, 2007 12:19 PM To: SQL Subject: RE: SQL not answering 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> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2885 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
