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
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 pass
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 problem is
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
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
(
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
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
7 matches
Mail list logo