Hi all, 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'); $conn->Open(<<EOF); Provider=SQLOLEDB; Persist Security Info=False; User ID=sa; Pwd=something; Initial Catalog=Northwind; EOF $conn->Execute(<<EOF); SELECT * FROM Customers EOF But how do I get the fields returned from the SQL command 'SELECT * FROM Customers' Any help would be much appreciated !!!!! Anadi _________________________________________________________________ Join the world’s largest e-mail service with MSN Hotmail. http://www.hotmail.com -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]