Thanks, Neil. >-----Original Message----- >> I use DBD::ODBC with Easysoft ODBC bridge to connect SQL >> server 6.5 from >> Linux. I have a stored procedure that is supposed to return >> several fields. >> It only returns the first field of my result set. I searched >> >Not sure what you mean. What does the sp do? If it's just >returning a rowset >so you will >be better off to clarify this to the list. > My stored procedure is actually used for customer's log on our server, it first check the username and password, if ok, update the customer log time and finally return customer's account information (several fields) for later use. It works fine except only one field(first field) in my final query return. >> context". I am not >> sure about this "scalar context", is this something related > >@list = $sth->fetchrow_array; # ie (1,2,3,4) >$scalar = $sth->fetchrow_array; # only gets 1st element $list[0] Thank you for clarification. I thought it's something specific to DBI. I used them all the time. Thanks. Guangzu
