type difference

[Viktor Popov]

Hi,

I am tryind to delete from a table using a Stored Procedure, but I don't
know how to do the following:

The DELETE STATEMENT must be:

DELETE FROM MESSAGES
WHERE MSSGID IN (@MSGIDS)

The problem is that @MSGIDS always is something like this:
1,3,5,7,11,12. It's VARCHAR parameter. The problem is that MSSGID is the
Primary key and it is INT. How could be solved this problem?

Thank you in advance!

Viktor
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.754 / Virus Database: 504 - Release Date: 06.9.2004 a.

[cody]

create the param by concatenating the id's:

string param = id1+","+id2+","+id3;

--
cody

Freeware Tools, Games and Humour
http://www.deutronium.de.vu || http://www.deutronium.tk
"Viktor Popov" <vi****@yahoo.com> schrieb im Newsbeitrag
news:#F**************@TK2MSFTNGP09.phx.gbl...

Hi,

I am tryind to delete from a table using a Stored Procedure, but I don't
know how to do the following:

The DELETE STATEMENT must be:

DELETE FROM MESSAGES
WHERE MSSGID IN (@MSGIDS)

The problem is that @MSGIDS always is something like this:
1,3,5,7,11,12. It's VARCHAR parameter. The problem is that MSSGID is the
Primary key and it is INT. How could be solved this problem?

Thank you in advance!

Viktor
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.754 / Virus Database: 504 - Release Date: 06.9.2004 a.

[Hugo Wetterberg]

Hi Viktor,
It looks like you need something like the Javascript Eval() function,
rather than getting the correct type.

You could pass the string as usual and then split it in SQL-Server and
store it in a temporary table. Take a look at this article:
http://www.winnetmag.com/SQLServer/A...071/21071.html

/Hugo

On Thu, 9 Sep 2004 10:09:26 +0300, Viktor Popov wrote:

From: Viktor Popov <vi****@yahoo.com>
Subject: type difference
Date: Thu, 9 Sep 2004 10:09:26 +0300
Lines: 25
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2741.2600
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2742.200
Message-ID: <#F**************@TK2MSFTNGP09.phx.gbl>
Newsgroups: microsoft.public.dotnet.languages.csharp
NNTP-Posting-Host: 212-104-102-239.cable.evrocom.net 212.104.102.239
Path: TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
Xref: TK2MSFTNGP08.phx.gbl microsoft.public.dotnet.languages.csharp:273618

Hi,

I am tryind to delete from a table using a Stored Procedure, but I don't
know how to do the following:

The DELETE STATEMENT must be:

DELETE FROM MESSAGES
WHERE MSSGID IN (@MSGIDS)

The problem is that @MSGIDS always is something like this:
1,3,5,7,11,12. It's VARCHAR parameter. The problem is that MSSGID is the
Primary key and it is INT. How could be solved this problem?

Thank you in advance!

Viktor
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.754 / Virus Database: 504 - Release Date: 06.9.2004 a.