The exec is inside the stored procedure. The stored procedure builds the sql
string and then executes it
You cfstoredproc calls the stored proce with your order by class as an input
parameter
----- Original Message -----
From: "stas" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, January 03, 2002 11:12 AM
Subject: Re: Dynamic stored procs
> 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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
