tman; beginners@perl.org
=> Subject: Re: Strange behaviour while using DBI with binding
=>
=> On Wed, Aug 18, 2010 at 19:55, Babale Fongo
=> wrote:
=> snip
=> > In the first example, DBI always passed the value for offset and
=> ignored the
=> > second value after the c
Babale Fongo wrote:
2) This works fine (with or without space in the string).
my $sth = $dbh->prepare(qq{
Select fname, lname, dob, substr(desc, 1, 200) from user
left join personal_data on
user.id = personal_data.id where gender = ? and position = ?
order by lname limit $l
On Wed, Aug 18, 2010 at 19:55, Babale Fongo wrote:
snip
> In the first example, DBI always passed the value for offset and ignored the
> second value after the comma.
>
> I'm now using the second code as it works without problem even if string
> contains space. I just need to understand why DBI be
On Wed, Aug 18, 2010 at 6:55 PM, Babale Fongo wrote:
> Below are 2 pieces of code. Both have been tested with space in the string
> and again without space.
>
> $limit = "$offset,$number_rows" or $limit = "$offset, $number_rows";
>
> [snip...]
>
> 2) This works fine (with or without space in the
>From your last comments, I am not sure where this is leading to, but here is
all I have to say.
Below are 2 pieces of code. Both have been tested with space in the string
and again without space.
$limit = "$offset,$number_rows" or $limit = "$offset, $number_rows";
1) This does not work (with
> "MC" == Mimi Cafe writes:
MC> You asked why I am concatenating the 2 scalars, comma and the space
below?
MC> my $limit = "$offset" . ', ' . "$number_rows";
MC> I agree your suggestion below should work as well, but I was desperate to
find the error, so I tried several option to se
1
17 Query SELECT fname, lname, dob, substr(desc, 1, 200)
FROM user LEFT JOIN personal_data ON user.id = personal_data.id WHERE gender =
'male' and position = 'HR Admin' order by lname LIMIT 20
Quit
=> -Original Message-----
=> F
>>>>> "MC" == Mimi Cafe writes:
MC> I experienced a strange behaviour while using DBI binding for MySQL query
MC> with LIMIT clause. My CGI program behaved so strange and the result was
MC> always unpredictable and it took me several hours before I f
I experienced a strange behaviour while using DBI binding for MySQL query
with LIMIT clause. My CGI program behaved so strange and the result was
always unpredictable and it took me several hours before I finally detected
the problem.
In my program I use binding as in the example below
On Feb 12, 2008 5:51 AM, Rajpreet <[EMAIL PROTECTED]> wrote:
> Greetings,
>
> I am trying to append an alphabetical counter to a string. But
> concatenation shows a very strange behaviour in this case. Can some
> one please help?
>
> The piece of code looks like :
>
Greetings,
I am trying to append an alphabetical counter to a string. But
concatenation shows a very strange behaviour in this case. Can some
one please help?
The piece of code looks like :
$self->{"log"}->debug(" In Function _process_array_data. ");
$self->{&
On Thu, Jun 03, 2004 at 01:23:19AM +0800, Edward Wijaya wrote:
> The codes below gives this result:
>
> ATGC
> A:2 2
> T:1 1
> C:1 1
> G:2 5
> _END_
>
> which I found strange, because the value for first
> row of second column should be 0.
> My question is how can I avoid my code
>
Dear Sirs,
The codes below gives this result:
ATGC
A:2 2
T:1 1
C:1 1
G:2 5
_END_
which I found strange, because the value for first
row of second column should be 0.
For example in the element of @array = , it takes
the value of the first element of the array @pwmA (i.e 2)
instead
drive
mapping, I would recommend mapping it within your script if you have the
same problems.
-Original Message-
From: Smith Jeff D [mailto:[EMAIL PROTECTED]
Sent: Monday, June 30, 2003 7:47 AM
To: 'Tim Johnson'; 'Akens, Anthony'; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Subje
EMAIL PROTECTED]
Sent: Monday, June 30, 2003 9:47 AM
To: 'Tim Johnson'; Akens, Anthony; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Strange behaviour of chdir in mapped drives
On the last point, does this happen even when using the Task Scheduler
utility and running the script
ED]
Subject: RE: Strange behaviour of chdir in mapped drives
That's exactly right. You will run into the same problem if you try running
your scripts in the scheduler.
-Original Message-
From: Akens, Anthony [mailto:[EMAIL PROTECTED]
Sent: Monday, June 30, 2003 7:12 AM
To: [EMAIL PROTECTE
That's exactly right. You will run into the same problem if you try running
your scripts in the scheduler.
-Original Message-
From: Akens, Anthony [mailto:[EMAIL PROTECTED]
Sent: Monday, June 30, 2003 7:12 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Strange behavio
ver\share
Tony
-Original Message-
From: beginner beginner [mailto:[EMAIL PROTECTED]
Sent: Monday, June 30, 2003 8:57 AM
To: [EMAIL PROTECTED]
Subject: Re: Strange behaviour of chdir in mapped drives
Hi,
I have tried it through command line It is working When i used
the same code and pu
Beginner Beginner wrote:
> Hi,
>I have tried it through command line It is working When i used the same code and
> put the file in cgi-bin and try to run
> through explorer it didn't worked
>
> $basedir= "I:/tech/work/web/Documents";
> chdir($basedir) or die $!;
> $test=`dir /s /b *.*`;
> pri
Hi,
I have tried it through command line It is working When i used the same code and
put the file in cgi-bin and try to run through explorer it didn't worked
$basedir= "I:/tech/work/web/Documents";
chdir($basedir) or die $!;
$test=`dir /s /b *.*`;
print $test;
If I simply replace I: with D:
From: "Rob Dixon" <[EMAIL PROTECTED]>
> Beginner Beginner wrote:
> > Hi All,
> > I wanted to search for *.html file on Server which I can
> > mount in my Windows XP:
> > e.g. I drive mapped to tech\work\web\documents.
> > as I:\tech\work\web\documents
> > now i try to go inside this
Beginner Beginner wrote:
> Hi All,
> I wanted to search for *.html file on Server which I can mount in my Windows
> XP:
> e.g. I drive mapped to tech\work\web\documents.
> as I:\tech\work\web\documents
> now i try to go inside this directory
> as
> $basedir="I:/tech/work/web/documents";
>
Hi All,
I wanted to search for *.html file on Server which I can mount in my Windows
XP:
e.g. I drive mapped to tech\work\web\documents.
as I:\tech\work\web\documents
now i try to go inside this directory
as
$basedir="I:/tech/work/web/documents";
chdir($basedir);
but this is not working
Jessee Parker wrote:
> Honestly I'm stuck. If I kill the process after it does it's job, I'm
> thinking that there is no residual from the previous program. When I do
> a ps -A there is only 1 program left to kill after it finishes
> processing. I kill this process and run my script. Whenever the
2 5:26 PM
To: [EMAIL PROTECTED]
Subject: Re: Strange behaviour
Jessee Parker wrote:
> I am currently running this on Redhat Linux version 7.3 and using Perl
> version 5.8.0. I've tried different things - let the process run and
> process multiple batches of files and I have killed it wit
Jessee Parker wrote:
> I am currently running this on Redhat Linux version 7.3 and using Perl
> version 5.8.0. I've tried different things - let the process run and
> process multiple batches of files and I have killed it with kill -9
> command on the pid and then restarted the program. First run
that is of
any help.
Jessee
- Original Message -
From: "david" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, November 07, 2002 5:02 PM
Subject: Re: Strange behaviour
> Jessee Parker wrote:
>
> > Hi all,
> >
> > I have a sc
Jessee Parker wrote:
> Hi all,
>
> I have a script that basically waits for 2 files to be delivered to
> it,
> then it processes the 2 files, inserts them into the database and then
> starts sending information. After information is sent, it deletes the
> record from the database and incr
Hi all,
I have a script that basically waits for 2 files to be delivered to it,
then it processes the 2 files, inserts them into the database and then
starts sending information. After information is sent, it deletes the record
from the database and increments a counter. I do a fork in the sub
29 matches
Mail list logo