> Since lists are also strings why not pass it in as a
> varchar using cfsqltype="CF_SQL_VARCHAR"
>
> then within the stored procedure
>
> select * from country
> where country_id IN (@countries)
>
> just make sure the varchar is large enough to hold a
> little more than the maximum number of
characters that the list can contain
At 03:52 AM 4/16/2002, you wrote:
>Adrian,
>Im not sure as I am new to stored procedures.What do you think it should
>be ?
>
>
>-Original Message-
>From: Adrian Lynch [mailto:[EMAIL PROTECTED]]
>Sent: 16 April 2002 11:43
>To:
Thanks very Much Mike
-Original Message-
From: Mike Bruce [mailto:[EMAIL PROTECTED]]
Sent: 16 April 2002 12:07
To: CF-Talk
Subject: Re: Stored Process
Unfortunately building an 'in' statement in a stored procedure is not as
straight forward as one would like. You can not simp
6 April 2002 11:52
To: CF-Talk
Subject: RE: Stored Process
Adrian,
Im not sure as I am new to stored procedures.What do you think it should
be ?
-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED]]
Sent: 16 April 2002 11:43
To: CF-Talk
Subject: RE: Stored Process
cfsqltype
#x27;
EXEC spExecuteSQL @SQLStatement
---
Check Books online to verify the syntax.
Mike Bruce
- Original Message -
From: "Jerry Staple" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, April 16, 2002 6:52 AM
Subje
Adrian,
Im not sure as I am new to stored procedures.What do you think it should
be ?
-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED]]
Sent: 16 April 2002 11:43
To: CF-Talk
Subject: RE: Stored Process
cfsqltype="CF_SQL_INTEGER" <<<<<<<<
cfsqltype="CF_SQL_INTEGER" is that correct??
-Original Message-
From: Jerry Staple [mailto:[EMAIL PROTECTED]]
Sent: 16 April 2002 11:31
To: CF-Talk
Subject: Stored Process
Hi ,
I am transferring few queries into stored procedures but I have
come across a stumbling block
7 matches
Mail list logo