pdo and dabase schema
| From: | Alain Roger | Date: | Wed, 15 Oct 2008 05:49:24 +0000 |
| Subject: | pdo and dabase schema | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-281935@lists.php.net to get a copy of this message | ||
Hi,
is there a way with PDO class to not have:
- to execute a simple SET search_path TO myschema;
- and after to fletch another SQL request, like select to be sure that the
SQL statement will be perform on this schema ?
(basically i want to do it in 1 step)
because i tried to specify the schema into my sql statement but in this case
PDO returns me 0 record.
thanks a lot,
--
Alain
------------------------------------
Windows XP SP3
PostgreSQL 8.2.4 / MS SQL server 2005
Apache 2.2.4
PHP 5.2.4
C# 2005-2008