Tablename issue..
| From: | Tom Wallace | Date: | Wed, 29 Aug 2001 19:06:06 +0000 |
| Subject: | Tablename issue.. | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-11963@lists.php.net to get a copy of this message | ||
Hola,
I'm having a difficult time figuring out the syntax here -- my table name
has spaces & dashes in it..Unfortunately I can't permanently change the
tablename.. I've tried a half dozen different ways to access the table, each
return an error similar to this:
Warning: SQL error: [ISAM]No data found, SQL state S00 in SQLExecDirect in
c:\inetpub\wwwroot\test8.php on line 14
but removing the spaces from the tablename and updating the php fixes it..
any ideas?
$sql2 = odbc_exec($conn,"SELECT Character_Field FROM ABC - Table");
Thanks,
-Tom