Sybase stored proc problem..

Anon

I am calling a stored proc using php/sybase.

The stored proc creates a new entry in the database and is supposed to return a status_code and the primary key (max+1).

However, the stored procedure works, (meaning it does add the entry to the DB correctly) but when I do:

$new_result = @sybase_query($sql,$connection) or die (sybase_get_last_message());

$row = sybase_fetch_row($new_result) or die (sybase_get_last_message());

$row = sybase_fetch_row($result);

I get the error:
[28-May-2002 15:30:30] PHP Warning: 1 is not a Sybase result index in /www/htdocs/CHOMP/test_syb.php on line 78

and the last sybase message was:

Changed database context to 'promodb'.

this baffling me. I have tried many different avenues to get this to work.

Thanks for any help

-Nate

Anon

What's the second sybase_fetch_row? Did yo mistype it or did $result get set somewhere else (instead of $new_result)?

Anon

that was a mistype.. sorry.

It should just be the first sybase_fetch_row.

-Nate

zone16

Hey Nate,
How do you return your status_code and primary_key from the stored proc(you use select or return)?
The 'Change database...' message is just a sybase message saying you're using db promodb. There is no error after that on the sybase side, but it's on the php side.
So I suspect the problem stems from the way you are returning your data...

cheers,

Zone16