[lug] php/oracle question (somewhat OT)

[Chip Atkinson]

Sorry for the delay.  Other work stuff got in the way...
PHP is kind of like perl in that length issues are generally not a
problem.
I'm trying to avoid going down the temporary table path right now because
that seems even more involved that the mess that I'm trying to deal with
now.
Thanks for your thoughts and suggestions though.  If I figure out the
problem I'll post it, if for no other reason that archive searches.

Chip

 On Mon, 17 Jun 2002, D. Stimits wrote:

<SNIP>
> > > > $query2 = "declare tmp char(40);
>
> Without knowing specifics of both php and oracle, I would still be
> suspicious of a single temp variable of 40 characters width being used
> to select multiple results into it. So aside from the quoting, perhaps
> the temp variable holding only one value. It wouldn't give you all the
> answers in a single variable, but if you do a test by selecting into a
> temp table instead of a variable, and the error goes away, you can
> probably bet the :tmp is the problem. So maybe instead of a char(40) use
> a table instead just to see if the error goes away; you can even create
> a non-temp table so you can examine it.
>
> D. Stimits, stimits at idcomm.com
>