Re: pl/sql and hochkommas

"Mark C. Stock" <mcstockX_at_Xenquery .com> schrieb im Newsbeitrag news:fMidnXRtF6Uv-kmiRVn-jg_at_comcast.com...
>
> "Hubert Holler" <haiflosse_at_gmx.net> wrote in message
> news:3fd422d4$0$19008$91cee783_at_newsreader02.highway.telekom.at...
> |
> | > >
> | > > I'm not 100% sure I understand what you are asking.
> | > > You might want to use the CHR() function in place of single or
double
> | > > quote marks.
> | > >
> |
> | When I try:
> | select count(*) into v_vorhanden from wort_suche where wort_id =
v_id_wort
> | and buchstabe = CHR(39) || upper(buchstabe) || CHR(39) and benutzer_id =
> | login.getid_benutzer;
> |
> | it doesn't work but when I try:
> |
> | select count(*) into v_vorhanden from wort_suche where wort_id =
v_id_wort
> | and buchstabe = 'J' and benutzer_id = login.getid_benutzer;
> |
> | it does work.
> |
> | I hope someone can tell me the correct syntax for it.
> |
> | Thank a lot
> |
> | Hubert
> |
> |
> |
>
> what do you mean by 'it doesn't work'? are you getting an error message?
or
> are you not getting the rows returned that you expect? as i mentioned in
my
> other post, your expression "buchstabe = CHR(39) || upper(buchstabe) ||
> CHR(39)" will never evaluate to true -- is that the problem?
>

yes. What should I do now that it works. I will not get an error message.

Hubert Received on Mon Dec 08 2003 - 15:26:08 CST