> Got it.... whoo hoo ... now that is really very cool. I like it. i should point out that most hard core sql server types would whomp me silly for suggesting that. if its at all possible build an sp for each possible SELECT/ORDER BY combo you need & clientside (ie cf server) determine which sp to call. you will get the most bang for your buck (euro) from your sp that way.
--- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.311 / Virus Database: 172 - Release Date: 12/27/2001 ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

