RE: [PHP-DB] PLEASE HELP! Problem with ODBC string insert
| From: | Matthew Loff | Date: | Mon, 16 Jul 2001 05:37:16 +0000 |
| Subject: | RE: [PHP-DB] PLEASE HELP! Problem with ODBC string insert | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-10431@lists.php.net to get a copy of this message | ||
It would be a hack, but if the data is only going to be used for the
site (e.g. nobody is going to use the data through access) you could
str_replace() the single quote to something else (perhaps an HTML ASCII
representation like &#xxxx;) before the INSERT/UPDATE, and converting
back when SELECTing. It's ugly, but it would work...
-----Original Message-----
From: AKA Hook [mailto:aka_hook@hotmail.com]
Sent: Sunday, July 15, 2001 7:21 PM
To: php-db@lists.php.net
Subject: Re: [PHP-DB] PLEASE HELP! Problem with ODBC string insert
I tried double quotes and many different combinations of single and
double but nothing has worked.
There HAS to be an answer out there! Do certain SQL statements just not
work in PHP / Access? Is this a bug in Access or PHP?
If I can't get this to work then I won't be able to use PHP for this
site! Someone please shed some light on this!
"Matthew Loff" <matt@willetts.com> wrote in message
news:001701c10dae$53146280$0100a8c0@bang...
>
>
> That looks like a valid query to me... I know this would break SQL92
> standard, but have you tried enclosing the values in double quotes? I
> know that's valid with MySQL...
>
> I don't have any other suggestions... Does anyone else?
>
>
> -----Original Message-----
> From: AKA Hook [mailto:aka_hook@hotmail.com]
> Sent: Sunday, July 15, 2001 3:56 PM
> To: php-db@lists.php.net
> 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
>
>
> "Matthew Loff" <matt@willetts.com> wrote in message
> news:000e01c10d89$6fa576c0$0100a8c0@bang...
> >
> > It might help us to see exactly what the query is...
> >
> > Could you insert an echo statement and let us know what SQL query
> > it's
>
> > producing?
> >
> > echo "
> > INSERT INTO News
> > (NewsDate,NewsTitle,NewsText)
> > VALUES
> > ('$NowDate','$NewsTitle','$NewsText')
> > ";
> >
> >
> > -----Original Message-----
> > From: AKA Hook [mailto:aka_hook@hotmail.com]
> > Sent: Sunday, July 15, 2001 1:03 PM
> > To: php-db@lists.php.net
> > 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 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 me!
> > Here is my code:
> > --------------------------------------------------------------------
> > --
> > --
> > ----
> > --
> >
> > $NowDate = date("m/d/y");
> >
> > $DBASE = odbc_connect(mno,admin,admin);
> > $getnews = odbc_exec($DBASE,
> > "
> > INSERT INTO News
> > (NewsDate,NewsTitle,NewsText)
> > VALUES
> > ('$NowDate','$NewsTitle','$NewsText')
> > "
> > );
> >
> > Here is the error when using quotes in the "NewsText" form field:
> > --------------------------------------------------------------------
> > --
> > --
> > ----
> > ----
> > Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Syntax
> > error (missing operator) in query expression ''can\'t use
quotes!')'.,
> > SQL state 37000 in SQLExecDirect in W:\www\clanmno\news_post2.php on
> > line 22
> >
> > Thanks in advance...
> >
> >
> >
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For
> > additional commands, e-mail: php-db-help@lists.php.net To contact
> > the list administrators, e-mail: php-list-admin@lists.php.net
> >
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
> For additional commands, e-mail: php-db-help@lists.php.net
> To contact the list administrators, e-mail:
php-list-admin@lists.php.net
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
For additional commands, e-mail: php-db-help@lists.php.net
To contact the list administrators, e-mail: php-list-admin@lists.php.net