note 16989 added to function.odbc-exec
| From: | sk2xml at gmx dot net | Date: | Wed, 21 Nov 2001 11:15:49 +0000 |
| Subject: | note 16989 added to function.odbc-exec | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-21098@lists.php.net to get a copy of this message | ||
Problem: Fieldnames in SQL-Statement have blanks and [] don't work!
Solution: Try "" instead
Ex.:
SELECT table2.first, table1.[last name] FROM tabel1, table2 -> don't work
SELECT table2.first, table1.\"last name\" FROM tabel1, table2 -> Try this
PS: Don't forget the espace characters !!!
--
http://www.php.net/manual/en/function.odbc-exec.php
http://master.php.net/manage/user-notes.php?action=edit+16989
http://master.php.net/manage/user-notes.php?action=delete+16989
http://master.php.net/manage/user-notes.php?action=reject+16989