Re: Literalizing commas in CHARVAR2 text strings
From: Gordon E. Hooker <gordonh_at_acslink.net.au>
Date: 1995/10/01
Message-ID: <44n77b$1u9_at_dingo.cc.uq.oz.au>#1/1
Date: 1995/10/01
Message-ID: <44n77b$1u9_at_dingo.cc.uq.oz.au>#1/1
Hagen Finley <hagen_at_violet.berkeley.edu> wrote:
>I am attempting to insert text strings into a table using SQL on the WIN95
>PO7 beta version. The text is from philosophy texts I am researching and,
>unremarkably, the sentences I am attempting to insert include commas.
>Although I may be misinterpreting the problem, but my hunch is the insert is
>failing on the commas within the string which normally indicate a new column
>during insert. Is there a simple method of literalizing commas within the
>string?
>Any other suggestions would be appreciated.
If you are using the INSERT statement single quotes should escape the meaning of a comma. 'Why, are we here'.
-----------------------------\ooOoo/----------------------------------- Gordon Hooker MACS PCP ,--_|\ 25 Clarke Street, Ripley, Queensland, 4306, Australia / \ gordonh_at_acslink.net.au \_.--._/ mobile: 018883835 phone: 61-7-2889716 V -----------------------------------------------------------------------It is far better to remain silent and appear a fool, than to open ones mouth and remove all doubt... Received on Sun Oct 01 1995 - 00:00:00 CET