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
>
>
>
>
