RE: HELP going from Dynamic CF Queries to Stored Procedures

2001-03-21 Thread Kevan . Windle
This would be messy to code for your example but would allow for optimisation. -Original Message- From: metzy martinez [mailto:[EMAIL PROTECTED]] Sent: 07 March 2001 19:01 To: CF-Talk Subject: HELP going from Dynamic CF Queries to Stored Procedures Our company is going from using regul

RE: [HELP going from Dynamic CF Queries to Stored Procedures]

2001-03-07 Thread metzy martinez
r entered something into the name field and if they did they are appending the statement to the where clause > -Original Message- > From: Alex [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, March 07, 2001 12:23 PM > To: CF-Talk > Subject: Re: [HELP going from Dynamic CF Q

Re: [HELP going from Dynamic CF Queries to Stored Procedures]

2001-03-07 Thread Alex
you can't use ColdFusion ifs but you can use your DB's ifs. what's your DB? "metzy martinez" <[EMAIL PROTECTED]> wrote: Our company is going from using regular cfquery statements to putting them into stored procedures in order to get the load of our cold fusion box and letting the sql server bo

HELP going from Dynamic CF Queries to Stored Procedures

2001-03-07 Thread metzy martinez
-Original Message- From: metzy martinez [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 07, 2001 1:01 PM To: CF-Talk Subject: HELP going from Dynamic CF Queries to Stored Procedures Our company is going from using regular cfquery statements to putting them into stored procedures

HELP going from Dynamic CF Queries to Stored Procedures

2001-03-07 Thread metzy martinez
Our company is going from using regular cfquery statements to putting them into stored procedures in order to get the load of our cold fusion box and letting the sql server box handle the load. where i'm having problems is making a query that is dynamic and changing it to a stored procedure. i'm