Marcus Willemsen [EMAIL PROTECTED] 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?
Does it find the row if you select one of the other columns
in that table besides the textfield? What is the data
type of the id column?
--
Hardy Merrill
Red Hat, Inc.
