Tuesday, June 18, 2002, 8:12:30 PM, A Taylor wrote:
> I have a script that allows me to connect to my SQL Server7 database, and
> run a SQL command:
> use Win32::OLE;
> $conn = new Win32::OLE('Adodb.Connection');
[snip]
> $conn->Execute(<<EOF);
> SELECT * FROM Customers
> EOF
> But how do I get the fields returned from the SQL command 'SELECT * FROM
> Customers'
You could try the ADO docs:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdmthcnnexecute.asp
They might help.
A more Perlish way to do it would be to use DBI, which
provides an abstraction layer for database access. That and
DBD::ADO or similar would probably be easier to work with.
--
Best Regards,
Daniel [EMAIL PROTECTED]
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
