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
