question for a command object

[crsdev]

Hello Friends,
I have a report with a command -- something like this

select id
from some_table s
where s.name='{?NAME}'

and the user gets to pick a name from a drop down list.

The problem is we have couple of names with apostrophe like "sam's" where the apostrophe is read as a single quote hence produces an error.

does anyone know a workaround for this issue.

THanks.

 

[synapsevampire]

Why do you have quotes around the parameter in the command object? Try it without them.

-k

 

[crsdev]

Synapsevampire,
If i don't put the single quotes around the parameter i get the same error.
The column "name" is a varchar in the table: some_table.
and the parameter is type -- string.

Thanks.

 

[lbass]

Try the following. Create two commands:

select id
from some_table s
where replace(s.name,chr(39),'') ='{?NAME}'

Use this to populate your report. The second command, below, should be used to populate your list of values for {?NAME}:

select replace(s.name,chr(39),'')
from some_table s

Do not link the commands to each other.

-LB