Hi jamie ... took a look I know its a bit of a fudge but as SQL's letting you down cant you wrap the bit that outputs the results in a <cfif like this ?
<cfif qGetMatches.rowcont NEQ 0 > <tr ...... </tr> </cfif> Not ideal I know .... > Simon - Here's the dumps - the GetMatches dump has never returned > results for me (though it seems like it is doing something since it's > outputting results) > > GetWantedCards Query - query > CARDID USERID > 1 41001101 7 > 2 41001102 7 > 3 41001151 7 > 4 41001152 7 > 5 41001153 7 > GetMatches Query - query > CARDID USERID > > If this is too confusing, you can see this 'live' by going here: > > http://www.mtgotradingpost.com/users/login.cfm > > username: yourmom > password: yourmom > > Then goto Trading->Match (http://www.mtgotradingpost.com/traders/match. > cfm) > > Thanks Marco for the MySQL info - if I hear one more report of "you > can't do that in 4.0, but 4.1 supports it" I swear to God I will shoot > myself. We don't have a 4.1 server up yet since there's not enough > call for it (and no one wants to attempt a conversion) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187736 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
