>Try outputting the text to the screen before the query - see what's >being sent to the Dbengine... That usually helps
Tried that, with no luck looks ok the query being sent to the DB is correct it just doesn't like the trailing </CFIF> take it out and get teh <CFIF> with no end tag error So Tried a block out side that create a variable that contains the conditions and it doesn't like the #varirables.orderbystring# but looking at the debug info the correct query is being sent its as if the query is sent twice once coded and once not?????? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
