I would agree with Paul's statement. I initially did my dynamic stored proc s like Paul has suggested and then I stopped and created a stored proc for what I needed instead of doing dynamic procs.
Clint ---------- Original Message ---------------------------------- from: [EMAIL PROTECTED] (Paul Hastings) Reply-To: [EMAIL PROTECTED] date: Fri, 4 Jan 2002 01:52:00 +0700 > 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
