Re: CREATE question
| From: | Daniel Brown | Date: | Thu, 30 Oct 2008 20:08:28 +0000 |
| Subject: | Re: CREATE question | ||
| References: | 1 | Groups: | php.db php.general |
| Request: | Send a blank email to php-general+get-282656@lists.php.net to get a copy of this message | ||
On Thu, Oct 30, 2008 at 2:19 PM, Dan Shirah <mrsquash2@gmail.com> wrote:
>
> Is it possible for us to use PHP to create temp tables in our database?
[snip!]
>
> But all that does is give me an "ifx_prepare fails" message.
(Forwarded to PHP-DB as well.)
Dan, make sure Informix is set to allow that user to use the
CREATE syntax. Also, not sure about IFX, but with other SQL databases
- including MySQL - you have to use the full word
TEMPORARY, not
just TEMP.
--
</Daniel P. Brown>
http://www.parasane.net/
daniel.brown@parasane.net || danbrown@php.net
Ask me about our current hosting/dedicated server deals!