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>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
ColdFusion is delivering applications solutions at at top companies
around the world in government. Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us
Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2884
Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
