Somewhere in the back of my head there is an idea that the hash key is
case sensitive. Try reversing the case (upper if you are using lower
now).
____________________________
Jeff Seger
Fairchild Semiconductor
[EMAIL PROTECTED]
____________________________
"Marcus Willemsen" <[EMAIL PROTECTED]>
12/15/2003 09:34 AM
To: <[EMAIL PROTECTED]>
cc:
Subject: Selects to MS SQL Server 2000
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
