-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Lyle Kopnicky
Sent: Wednesday, November 23, 2005 11:41 AM
To: perl-win32-users
Subject: SQL problem
Hi folks,
Perhaps I should send this question to a SQL Server forum, but someone
here might be able to spot the problem.
I am acce
### when program starts
$MinsUsedInRangeQuery1
= $DBH->prepare('DECLARE @StartRange datetime, @EndRange datetime'
. ' SET @StartRange = ?, @EndRange = ?'
. ' SELECT SUM(DATEDIFF(mi,StartTime,EndTime))'
. ' AS MinsUsed FROM Sessions'
. ' WHERE AuthSource = ? AND UserID = ?'
. ' A
Hi folks,
Perhaps I should send this question to a SQL Server forum, but someone
here might be able to spot the problem.
I am accessing SQL Server through Perl and DBI. I have written a number
of queries. I prepare all the queries once at the start of the program,
and then execute them as
ot; <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Wednesday, January 24, 2001 12:54 PM
Subject: SQL-Problem - UPPER()
> Hello List,
>
> if a problem with this sql-stement (i use DBI and the CSV-Modul) :
>
> $sql = "SELECT * FROM gbook
Hello List,
if a problem with this sql-stement (i use DBI and the CSV-Modul) :
$sql = "SELECT * FROM gbook WHERE notes LIKE '%$in{'searchValue'}%' OR
keywords LIKE '%$in{'searchValue'}%'";
i would have a case sensive search, so when i use the UPPER() command i get
an error:
Parse er
