note 71689 deleted from function.odbc-exec by bjori
| From: | bjori@php.net | Date: | Tue, 12 Dec 2006 09:01:45 +0000 |
| Subject: | note 71689 deleted from function.odbc-exec by bjori | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-120539@lists.php.net to get a copy of this message | ||
Note Submitter: manishm at knowledgeplus dot com dot au
Reason: useless
----
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!