sybperl-l Archive

From: "Warren Pollans" <wpollans at verio dot net>
Subject: trying to execute "sp_columns"
Date: Feb 28 2001 7:11PM

Hello,

I would like to execute "sp_columns tablename" for some table.  I've tried
to do it the same way I execute a "select ..." query, but it doesn't work.

	I can connect to the DB OK.

	$dbh->dbcmd($q); is OK

	$dbh->dbsqlexec; is OK

but

	$dbh->dbresults; FAILS

What's the correct way to do this?


I'm trying to write a web-based utility (cgi) that will take a tablename as
an argument and return assorted information about the table.

Feel free to point me somewhere else.

Thanks,

Warren