note 71689 added to function.odbc-exec
| From: | manishmatknowledgeplusdotcomdotau at osu1 dot php dot net | Date: | Tue, 12 Dec 2006 02:57:58 +0000 |
| Subject: | note 71689 added to function.odbc-exec | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-120525@lists.php.net to get a copy of this message | ||
It seems that the ODBC Driver for Access while working with PHP does NOT like any double quotes
anywhere in SQL provided - as in here...
FirstName & " " & LastName as FullName
Just use single quotes like
FirstName & ' ' & LastName as FullName
and it works!
So I assume, there is some program line which is covering the whole SQL while run-time and
that's where the conflict asises with the internal included double quotes!
----
Server IP: 203.220.0.234
Probable Submitter: 203.28.159.167 (proxied: 150.101.22.62)
----
Manual Page -- http://www.php.net/manual/en/function.odbc-exec.php
Edit -- https://master.php.net/note/edit/71689
Del: integrated -- https://master.php.net/note/delete/71689/integrated
Del: useless -- https://master.php.net/note/delete/71689/useless
Del: bad code -- https://master.php.net/note/delete/71689/bad+code
Del: spam -- https://master.php.net/note/delete/71689/spam
Del: non-english -- https://master.php.net/note/delete/71689/non-english
Del: in docs -- https://master.php.net/note/delete/71689/in+docs
Del: other reasons-- https://master.php.net/note/delete/71689
Reject -- https://master.php.net/note/reject/71689
Search -- https://master.php.net/manage/user-notes.php