On Thu, Oct 30, 2008 at 2:19 PM, Dan Shirah <mrsquash2@xxxxxxxxx> 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@xxxxxxxxxxxx || danbrown@xxxxxxx
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
