http://www.4guysfromrolla.com/webtech/031004-1.shtml
-Original Message-
From: Ali Awan [mailto:[EMAIL PROTECTED]
Sent: Friday, March 17, 2006 3:17 PM
To: CF-Talk
Subject: Re: Converting a Query to Stored Procedure
Thanks to everyone who posted suggestions.
Qasim, the article showed
Thanks to everyone who posted suggestions.
Qasim, the article showed several examples using an integer list.
I am looking for an example using a character list.
I ended up searching some SQL sites and came up with something on my own.
Using preservesinglequotes in ColdFusion, did not help, it actu
Ali,
There were several examples on this article to use delimited list with SQL
Server stored procedure. From coldfusion side, I beleive you have to use
preservesinglequotes function.
HTH
Qasim
On 3/17/06, Ali Awan <[EMAIL PROTECTED]> wrote:
>
> >this might help you Ali
> >
> >http://vyaskn.tri
I got this SQL UDF off of the list a long time ago. I believe it will
do what you need.
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS OFF
GO
/** Object: User Defined Function dbo.fnc_ParseDelimited
Script Date: 1/12/2005 3:18:53 PM **/
CREATE FUNCTION dbo.fnc_ParseDelimited
(
There are a few ways you can do this. Either do a subquery so you don't have to
pass a list, mark up the list with single quotes already in your list or use
cfqueryparam and use the option to say it's a list and it will mark up your
data to pass in correctly.
Bob
~~~
>this might help you Ali
>
>http://vyaskn.tripod.com/passing_arrays_to_stored_procedures.htm
>
>Qasim
>
>On 3/17/06, Ali Awan <[EMAIL PROTECTED]> wrote:
>>
Thanks Qasim,
that almost helps, but my ID's are 6 character varchars.
So what I'm passing, is all delimited by single quotes.
My first prob
this might help you Ali
http://vyaskn.tripod.com/passing_arrays_to_stored_procedures.htm
Qasim
On 3/17/06, Ali Awan <[EMAIL PROTECTED]> wrote:
>
> I have a query that I want to convert to a stored procedure.
>
> The problem I am having is that the query has lists in it and I don't know
> how to
7 matches
Mail list logo
