to many parsed variable

[nicktan]

This is my current script, I know it is not right, but I don't know how to correct it. Please help. THANKS

@list_source = "a,b,c,d"

Set MyConn=Server.CreateObject("ADODB.Connection&quot
MyConn.Open "DBNAME", "sa", ""
SQL = "Select * From CUSTOMER where src in " & @list_source & ";"
Set RS = MyConn.Execute(SQL)

 

[DeRoe]

If you are not sure about a SQL query you should try it in the database itself. Then you know that at least your query is correct.
Try the following query:
Select * From CUSTOMER where src in (a,b,c,d)
With ( and without ;

Greets

 

[mwolf00]

You need parentheses

@list_source = "(a,b,c,d)"
-----------------------------------------------------------------
Be nice. It's only doing what you tell it to do.
mikewolf@tst-us.com