Problem with Recordset

[nsanto17]

I have a recordset that uses a Parameter as the Where statement selection

My SQL code is
Select *
From dbo.SS_Pipeline_Review
Where Branch in (var_Branch)

the var_Branch Value is set to Session ("Branch_Access_List") which pulls a value from the database. For example 6500, 7500

For some reason this is not working right. Does any one have any ideas?

 

[johnwm]

Which server-side language are you using? Which database?

I notice that although you have asked over 140 questions, you have only had 10 answers you consider valuable. You may like to read faq222-2244 to see how to ask better questions. If you have had more than 10 valuable answers, read faq222-2244 to remind yourself how to recognise them.

If you want the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller

 

[nsanto17]

I am using ASP and SQL. Sorry i have been working on this all day and my brain is shot.

 

[johnwm]

Although you don't specify, I guess you are using a dynamic SQL statement. If so try setting your SQL string to:

mySQL="Select * From dbo.SS_Pipeline_Review Where Branch in (" & var_Branch & ");"

If you want the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller