PC Review Forums Newsgroups Microsoft DotNet Microsoft ADO .NET insert value list in paramter

Reply

insert value list in paramter

 
Thread Tools Rate Thread
Old 06-04-2006, 07:59 AM   #1
=?Utf-8?B?a2lrZGU=?=
Guest
 
Posts: n/a
Default insert value list in paramter


Hi, i'm using a sql-select command (commandtyp:text) and the sql-query is
build with commands:

sql="... and PROD in ( :PRDCT_NAME )"
Cmd.Parameters.Add(":PRDCT_NAME", OracleType.VarChar, 0, "PRDCT_NAME")
Cmd.Parameters.Item(":PRDCT_NAME").Value = _Product

_Product contains a value list like "'a','b','c'"
an error occurs during executing the command.
where is the failure?

Thanks
jens


  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off