I am using <cfstoredproc> so I won't be 'execing' anything. I need to know how to costruct a dynamic ORDER BY (or a WHERE for that matter) clause for the query. Do I glue it together in CF and then pass the whole line to the SQL Server, or do I pass several different variables. In other words, how would you convert a query like this to a stored procedure, and then how could you call it with <cfstoredproc>?
<cfquery> SELECT id FROM tblOrder <cfif isdefined("attributes.sortBy")> ORDER BY #sortBy# </cfif> <cfif isdefined("attributes.sortOrder")> #attributes.sortOrder# </cfif> </cfquery> Thanks for any help and pointers. ----- Original Message ----- From: "Don Vawter" <[EMAIL PROTECTED]> 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]> > 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! ______________________________________________________________________ Why Share? Dedicated Win 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=coldfusionc 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