On 10/30/08, Daniel Brown [EMAIL PROTECTED] wrote:
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!
Ah! You both may be right. I was running my entire using AQT and it ran
fine without any problems but once I pulled it into my web application it
took a swan dive.
You're probably totally right, of course it could create it in AQT because
I'm connecting to it with my credentials, whereas the web application is
connecting as a different user.
Thanks guys, I'll check out my permissions and hopefully that's all it is.
Just an FYI, the use of temp instead of temporary does work in Informix
:)