SQL strings should be in single quotes

Rich P...

-----Original Message-----
From: bill@... [mailto:bill@...]
Sent: 24 April 2002 07:13
To: ib-support@yahoogroups.com
Subject: Re: [ib-support] insert string from php


try ... "dave''s company" ie an extra "'" ...

bill

Screawn wrote:

> performing an sql insert into interbase 6.0 from php 4.0 question.
>
> >From php
>
> $sqlstring="Insert into customers(customer_no,company_name)values
> (4000,"dave's company");
> ..execute query($sqlstring)
>
> The previous expression($sqlstring) works from the ibconsol but not
> from within php. The problem is the single quote giving ownership in
> dave's company. Any idea how one can get around this problem of
> single quotes as ownership.
>
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/