Hi folks,
Vacation appears to be over here ;( I've run into something that has me
scratching my head a bit. I have the following code that displays a list
of records, or is supposed to display a list based on those NOT IN
ThisList. I've dumped ThisList after voting on a couple of records to
test it out, there are 5 total atm for testing and it shows me the money
on both records, however, in the cfloop output only the first record
that shows up in the dump is omitted after voting on 2. Changed the
single quotes to double and on refresh it works???? I am using MySQL5
here btw on Coldfusion MX 7,0,2,142559
Any ideas as to why this might be happening or how to correct it? TIA
<cfset ThisList = ValueList(tempvoteslist.packet_id, ",")>
<!--- get all those packets that are not in the list to display
for more voting --->
<cfquery name="getNewList" datasource="packets">
SELECT * FROM review_packets
WHERE id NOT IN ('#ThisList#')
</cfquery>
<cfloop query="getNewList">
<cfoutput>
<tr>
<td>
<a
href="#self#?fuseaction=reviews.getthispacket&ID=#ID#&name=#Name#&voterI
D=#thisEmailID#">#name#</a> <br />
</td>
</tr>
</cfoutput>
</cfloop>
Bob
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4658
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
