Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

string parameters in command

Status
Not open for further replies.

Dimitrie1

Programmer
Jan 5, 2007
138
CA
I have a string parameter called PlaceName

this works for single value p.Name = '{?PlaceName}'

but I want a multi select and this is erroring AND p.Name IN '{?PlaceName}'
I've also tried AND p.Name IN ('{?PlaceName}') and it errors too

help please

Linda
 
If I’m remembering correctly, for multiple value string parameters, you need to remove the quotes.

-LB
 
I have always had issues with multiple value and strings in a command. Seems to me that I read that you have to do the equivalent of a Crystal Reports Join function (I do not recall currently how to do it).
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top