Subject | RE: [firebird-php] SP selects?? |
---|---|
Author | Alan McDonald |
Post date | 2003-10-31T01:22:29Z |
ok ibase-fetch_row works but fetch or fetch object does not..
Alan
-----Original Message-----
From: Alan McDonald [mailto:alan@...]
Sent: Friday, 31 October 2003 12:18 PM
To: firebird-php@yahoogroups.com
Subject: [firebird-php] SP selects??
I have an SP which executes with params and returns a success code..
I am using ibase_query(SELECT CODE FROM MYSP(PARAM1, PARAM2)
The query runs fine - I see the result in the db, I can also see the
return
value ok if I run it manually.
But I can't get the return value from either
while ($row = ibase_fetch($sth)) {
print $row->ins_ok."\n";
}
or
while ($row = ibase_fetch_object($sth)) {
print $row->ins_ok."\n";
}
or $row[0] syntax...
Is there an issue with this? can I get the result from a select SP this
way?
thanks
Alan
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
To unsubscribe from this group, send an email to:
firebird-php-unsubscribe@yahoogroups.com
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]
Alan
-----Original Message-----
From: Alan McDonald [mailto:alan@...]
Sent: Friday, 31 October 2003 12:18 PM
To: firebird-php@yahoogroups.com
Subject: [firebird-php] SP selects??
I have an SP which executes with params and returns a success code..
I am using ibase_query(SELECT CODE FROM MYSP(PARAM1, PARAM2)
The query runs fine - I see the result in the db, I can also see the
return
value ok if I run it manually.
But I can't get the return value from either
while ($row = ibase_fetch($sth)) {
print $row->ins_ok."\n";
}
or
while ($row = ibase_fetch_object($sth)) {
print $row->ins_ok."\n";
}
or $row[0] syntax...
Is there an issue with this? can I get the result from a select SP this
way?
thanks
Alan
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
To unsubscribe from this group, send an email to:
firebird-php-unsubscribe@yahoogroups.com
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]