On Thu, Oct 30, 2008 at 2:19 PM, Dan Shirah <[EMAIL PROTECTED]> 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/
[EMAIL PROTECTED] || [EMAIL PROTECTED]
Ask me about our current hosting/dedicated server deals!

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to