Re: 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 >