Stored procedures with ODBC

[email protected] (Brian Lalor)
Newsgroups php.pear
Message-ID <Pine.A41.4.31.0102081522320.6840-100000@hcirisc.cs.binghamton.edu>
Hey all.  I'm delving into PEAR's database abstraction library for the
first time.  I'm trying to get a handle on the overall use of the
packages.

ODBC is causing me some problems with regard to stored procedures, and I
think this could carry over to Oracle stored procedures as well, but I'm
not sure.  Anyway, when I execute a stored procedure with ODBC, I'm just
doing it like
	$db->query("spStored_Proc 'arg1', 'arg2', 'etc.', 'ad', 'nauseum'")
fetch() does a preg_match() on the query string, and if it doesn't contain
SELECT, it returns DB_OK instead of the result set.

What's the best way to decide whether or not a query is supposed to return
data?

Thanks,
B
_____________________________________________________________________________
B r i a n  L a l o r                         [email protected]
http://hcirisc.cs.binghamton.edu/~blalor     Spam me not.
   To get my pgp key, put "get pgp key" in the subject of your message

I will not fake seizures
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.