php-db | 2001071

RE: [PHP-DB] PLEASE HELP! Problem with ODBC string insert From: Matthew Loff (matt <email protected>)
Date: 07/15/01

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 <email protected>]
Sent: Sunday, July 15, 2001 1:03 PM
To: php-db <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 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 <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>