On lun, 2004-08-09 at 12:41 +0200, Steffen Goeldner wrote:
> Olivier Poulet wrote:
>
[snip]
> >
> > my $sql =<<'EOFSQL';
> > SELECT
> > LOWER(field_one), field_two, UPPER(field_three)
> > FROM sample_table (NOLOCK)
> > WHERE
> > field_one = ?
> > EOFSQL
[snip]
> > Using the MSSQL 'LOWER' and 'UPPE
Olivier Poulet wrote:
> Hello to all,
>
> I am running a snippet similar to this against MSSQL 2000, on a Win32
> box.
>
> my $sql =<<'EOFSQL';
> SELECT
> LOWER(field_one), field_two, UPPER(field_three)
> FROM sample_table (NOLOCK)
> WHERE
> field_one = ?
> EOFSQL
>
> my $sth = $dbh->prepare($sql)
On Sat, Aug 07, 2004 at 04:53:44PM +, amonotod wrote:
> > From: Olivier Poulet <[EMAIL PROTECTED]>
> > Date: 2004/08/07 Sat AM 09:39:59 GMT
> > my $sql =<<'EOFSQL';
> > SELECT
> > LOWER(field_one)
>
> as field_one
>
> >, field_two, UPPER(field_three)
>
> as field_three
>
> > FROM sample_ta
> From: Olivier Poulet <[EMAIL PROTECTED]>
> Date: 2004/08/07 Sat AM 09:39:59 GMT
> my $sql =<<'EOFSQL';
> SELECT
> LOWER(field_one)
as field_one
>, field_two, UPPER(field_three)
as field_three
> FROM sample_table (NOLOCK)
> WHERE
> field_one = ?
> EOFSQL
That should do it...
HTH,
amonotod
Hello to all,
I am running a snippet similar to this against MSSQL 2000, on a Win32
box.
my $sql =<<'EOFSQL';
SELECT
LOWER(field_one), field_two, UPPER(field_three)
FROM sample_table (NOLOCK)
WHERE
field_one = ?
EOFSQL
my $sth = $dbh->prepare($sql) or die;
my ($field_one, $field_two, $field_th