I appreciate the clearer, more detailed description. Unfortunately, I
probably cannot help as much with this one. If it were my problem, I would
try finding and downloading the source for the Sybase modules, then look for
someone to contact in the notes. I would also exhaust any contacts I have
with Sybase, mostly because much of the original code for the interface
modules probably came from them originally (derived from their old C
interface modules).
Another approach would be to try to unload the source for the Stored
Procedure, and try to split up the queries (I believe the results you are
seeing are produced by a UNION, but I'm not certain). Sybase can compile
its query procedures on the fly, with only slightly longer run times, or you
could create a new procedure from what you find and store that one.
Good Luck,
Warren Vail
-----Original Message-----
From: Herouth Maoz [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 15, 2001 12:19 AM
To: Warren Vail; [EMAIL PROTECTED]
Subject: Re: [PHP] Problem: Sybase, PHP and multiple result sets
On Wednesday 15 August 2001 10:07, Warren Vail wrote:
> The ability to select a set from a previously selected set is
> possible in Sybase because the database supports creation of
> temporary tables and the select insert.
No, you seem to have missed my point entirely. So I'll explain in a
little more detail.
I run a stored procedure. Let's assume I run it from the interactive
utility and not from PHP for the moment.
> SP_SOMETHING_OR_OTHER PARAM1 PARAM2 PARAM3
The database returns:
foo bar
=== ===
10 20
30 40
field1 field2 field3
====== ====== ======
string bla 15
nothing bla 12
As you can see, it returns TWO result sets. One with two numeric
columns. The next with three columns, the first two string and the
last numeric.
This is, of course, just an example.
Now back to the web interface.
If I use PHP, I get only the first result set. That is, I write
something along the lines of:
$rs = sybase_query( "SP_SOMETHING_OR_OTHER PARAM1 PARAM2 PARAM3",
$conn );
while ( $row = sybase_fetch_row( $rs ) ) {
echo $row[0]; // and so on
}
This will only display the results of the first result set - the one
with the two fields, foo and bar.
There is no way for me to reach the second table generated by the
query. This is supposed to be the significant table.
Now, in ASP, there is something like
set rs = rs.NextResultSet
Which sets the rs to the second result set, the one with the three
fields of mixed types, at which point you loop, just like above, and
retrieve the new information. This method or an equivalent of it is
not in the PHP documented set of Sybase functions.
I hope I made myself clearer. And by the way, you don't have to sell
me on the uselessness of ASP, the general uselessness of Microsoft
etc. - I don't use any Microsoft products, even at work.
Herouth
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
