You can certainly do it in sql server. I can't say for other engines. Just have the sp build the sql string and then have exec (@st) after you build the string.
----- Original Message ----- From: "stas" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, January 03, 2002 7:53 AM Subject: Dynamic stored procs > I have a dynamically generated ORDER BY clause (as in ORDER BY > #attributes.orderByClause# ). Is there a way to pass that on to a stored > procedure if I wanted to convert a <cfquery> to <cfstoredproc>? Thanks! > > ______________________________________________________________________ Get Your Own 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=coldfusionb 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
