3 6:35 PM
> To: Marcus Willemsen
> Cc: [EMAIL PROTECTED]
> 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 e
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--
Marcus Willemsen [EMAIL PROTECTED] wrote:
> Hello Hardy,
>
> Thanks for your reply,
>
> > Does it find the row if you select one of the other columns
> > in that table besides the textfield?
>
> Yes, using the same query with other fields it finds most of the other
> fields (varchars, ints, tiny
Hello Hardy,
Thanks for your reply,
> Does it find the row if you select one of the other columns
> in that table besides the textfield?
Yes, using the same query with other fields it finds most of the other
fields (varchars, ints, tinyints). Althought some are not returned, eg.
a timestamp fiel
t; <[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 SEL
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 [textf
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");
$
