when SELECTing. It's ugly, but it would work...
-Original Message-
From: AKA Hook [mailto:[EMAIL PROTECTED]]
Sent: Sunday, July 15, 2001 7:21 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] PLEASE HELP! Problem with ODBC string insert
I tried double quotes and many different combinations
and let us know what SQL query it's
>
> > producing?
> >
> > echo "
> > INSERT INTO News
> >(NewsDate,NewsTitle,NewsText)
> > VALUES
> > ('$NowDate','$NewsTitle','$NewsText')
> > ";
> >
> >
lto:[EMAIL PROTECTED]]
Sent: Sunday, July 15, 2001 3:56 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] PLEASE HELP! Problem with ODBC string insert
Here is the echo output.
UPDATE News SET NewsTitle = 'Text',
NewsText = 'can\'t use quotes!' WHERE NewsID = 16
"Ma
27;$NewsTitle','$NewsText')
> ";
>
>
> -Original Message-
> From: AKA Hook [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, July 15, 2001 1:03 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] PLEASE HELP! Problem with ODBC string insert
>
>
> I a
quot;;
-Original Message-
From: AKA Hook [mailto:[EMAIL PROTECTED]]
Sent: Sunday, July 15, 2001 1:03 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] PLEASE HELP! Problem with ODBC string insert
I am using an Access DBASE and trying to insert text from a form field.
When I use quotes in my text
I am using an Access DBASE and trying to insert text from a form field.
When I use quotes in my text the code errors out, otherwise it works fine.
I have Magic Quotes turned on which is supposed to fix this problem
but IT DOES NOT!
I have posted in several forums but no one has been able to help
