MS SQL stored procedure

[lfsxdth]

I am new to MS SQL server and stored procedures. I currently have a query that
looks like:

select from table where fieldname IN (#variables.myvar#)

I am trying to convert this to a stored procedure.

CREATE PROCEDURE dbo.SelectProc
@myvar varchar(255)
AS
select from table
where fieldname in (@myvar)
GO

using this to call
<cfstoredproc procedure="SelectProc" datasource="dsDES">
<cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" dbvarname="myvar"
value="#variables.myvar#" null="no">
<cfprocresult name="WhatChecked">
</cfstoredproc>

How do I convert the varchar to an array of integers so the stored procedure
will operate, or is there a way to pass an array from CF to MS Sql stored
procedure (I will need to change my stored procedure obviously)

[Brian Hogue]

Are you getting an SQL Server error message?

-brian

"lfsxdth" <webforumsuser@macromedia.com> wrote in message
news:def7ui$m05$1@forums.macromedia.com...

> I am new to MS SQL server and stored procedures. I currently have a query

that

> looks like:
>
> select from table where fieldname IN (#variables.myvar#)
>
> I am trying to convert this to a stored procedure.
>
> CREATE PROCEDURE dbo.SelectProc
> @myvar varchar(255)
> AS
> select from table
> where fieldname in (@myvar)
> GO
>
> using this to call
> <cfstoredproc procedure="SelectProc" datasource="dsDES">
> <cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" dbvarname="myvar"
> value="#variables.myvar#" null="no">
> <cfprocresult name="WhatChecked">
> </cfstoredproc>
>
> How do I convert the varchar to an array of integers so the stored

procedure

> will operate, or is there a way to pass an array from CF to MS Sql stored
> procedure (I will need to change my stored procedure obviously)
>

[lfsxdth]

I figure this out myself after posting. First create a string, then execute it.

CREATE PROCEDURE dbo.myResults
@myvar varchar(255))
AS
declare @sql varchar(1000)

set @sql =select From table Where fieldname IN (' + @myvar + ')'

execute (@sql)
GO