Thank you Tim, Okay, I've traced my query and apparently the LongReadLen attribute for the ODBC driver is set to 0 by default but after changing it everything works fine.
> -----Original Message----- > From: Tim Bunce [mailto:[EMAIL PROTECTED] > Sent: Monday, December 15, 2003 6:35 PM > To: Marcus Willemsen > Cc: [EMAIL PROTECTED] > Subject: Re: Selects to MS SQL Server 2000 > > > Use trace. > > Tim. > > On Mon, Dec 15, 2003 at 03:34:46PM +0100, Marcus Willemsen wrote: > > Hi everybody, > > > > > > I managed to establish a connection with Microsofts SQL Server 2000 > > using DBI without any problems. My only problem is SELECTing > > textfields from the database. A query like: > > ---Snippet--- > > my $sth = $dbh->prepare("SELECT [textfield] FROM > > [database].[dbo].[table] WHERE [id] = 3315"); > > $sth->execute; > > if(my $r = $sth->fetchrow_hashref){ > > print ("$r->{textfield}"); > > } > > else { > > print("No Entry<br>"); > > } > > ---Snippet--- > > Always results in a "No Entry" despite the fact that there > is an entry > > in the table. I get a result using the SQL Query Analyzer. > So is there > > anything special about SELECTing textfields? > > > > Greetings Marcus > > > > > > > > >
