RE: Selects to MS SQL Server 2000
From: Marcus Willemsen (marcus.willemsen_at_juve.de)
Date: 12/16/03
- Next message: David Claughton: "RE: :Proxy::st execute failed: CallMethod: Can't bind unknown pla ceholder"
- Previous message: Rudy Lippan: "Re: Error-handling Question"
- Maybe in reply to: Marcus Willemsen: "Selects to MS SQL Server 2000"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Tue, 16 Dec 2003 10:22:48 +0100 To: <dbi-users@perl.org>
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:Tim.Bunce@pobox.com]
> Sent: Monday, December 15, 2003 6:35 PM
> To: Marcus Willemsen
> Cc: dbi-users@perl.org
> 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
> >
> >
> >
> >
>
- Next message: David Claughton: "RE: :Proxy::st execute failed: CallMethod: Can't bind unknown pla ceholder"
- Previous message: Rudy Lippan: "Re: Error-handling Question"
- Maybe in reply to: Marcus Willemsen: "Selects to MS SQL Server 2000"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
