Article View: borland.public.vdbase.data.sql
Article #500Re: query using '?' in string parameter
From: Karen Elmquist
Date: Wed, 02 Sep 1998 00:00
Date: Wed, 02 Sep 1998 00:00
33 lines
1486 bytes
1486 bytes
i'm not looking for the 'hello' string.....i'm trying to update a database
field with a string that happens to have a '?' in it. So far, it's blowing
up on me.
Christopher F. Neumann wrote in message <6sjugt$fq718@forums.borland.com>...
>If you are looking for the hello string, use %.
>
>'hello%' - if it starts with hello
>'%hello' - if it ends with hello
>'%hello%' - if it has with hello
>
>--
>Christopher F. Neumann
>
>"Failure is not an option!"
>
>Karen Elmquist <kelmquis@wisdomwareNOSPAM.com> wrote in message
>6sjidu$eq98@forums.borland.com...
>>when I execute an update or insert SQL statement and there is a '?' in a
>>string value, I get exceptions.
>>
>>for example:
>>
>>Query1.SQL.Add('Update table set description = :value1 where number =
>>:value2');
>>Query1.Params[0].AsString := 'hello?';
>>Query1.Params[1].AsInteger := 1;
>>Query1.ExecSql;
>>
>> --- boom!!
>
>
>
Technical Details
Message-ID:
<6sk55h$fq825@forums.borland.com>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<6sjidu$eq98@forums.borland.com> <6sjugt$fq718@forums.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: ff5a1,87f82f8ff4ab83fc X-Google-Attributes: gidff5a1,public From: "Karen Elmquist" <kelmquis@wisdomwareNOSPAM.com> Subject: Re: query using '?' in string parameter Date: 1998/09/02 Message-ID: <6sk55h$fq825@forums.borland.com> X-Deja-AN: 387219285 References: <6sjidu$eq98@forums.borland.com> <6sjugt$fq718@forums.borland.com> X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3 Organization: Another Netscape Collabra Server User Newsgroups: borland.public.vdbase.data.sql