Re: Problem with DBI and placeholders

 I may not have expressed myself well, I have to migrate tables between two databases that contain millions of rows and I only need specific columns. Now it works using placeholders only for the values but is very slow for inserts even with AutoCommit disabled. Getting data from $src_db is f

Re: Problem with DBI and placeholders

On 4/9/21 7:11 AM, mailing lists via beginners wrote: thanks Andrew I need to insert millions of rows so I need to have a good performance using placeholders You can not use placeholders for the table name. If you have millions of *tables*, there is something very, very, very wrong with

Re: Problem with DBI and placeholders

quoting field values rather than entering table or field names. "SELECT * FROM $table" is probably what you want. On Fri, Apr 9, 2021 at 12:49 PM mailing lists via beginners wrote: Hello, I am having a problem with a very simple task and I don't see where the fault is. The first

Re: Problem with DBI and placeholders

wrote: thanks Andrew I need to insert millions of rows so I need to have a good performance using placeholders On Friday, April 9, 2021, 1:57:25 PM GMT+2, Andrew Solomon wrote: The ? is for quoting field values rather than entering table or field names. "SELECT * FROM

Re: Problem with DBI and placeholders

, 1:57:25 PM GMT+2, Andrew Solomon < > and...@geekuni.com> wrote: > > > The ? is for quoting field values rather than entering table or field > names. "SELECT * FROM $table" is probably what you want. > > On Fri, Apr 9, 2021 at 12:49 PM mailing lists via beginn

Re: Problem with DBI and placeholders

, April 9, 2021, 1:57:25 PM GMT+2, Andrew Solomon wrote: The ? is for quoting field values rather than entering table or field names. "SELECT * FROM $table" is probably what you want. On Fri, Apr 9, 2021 at 12:49 PM mailing lists via beginners wrote: Hello, I am having a prob

Re: Problem with DBI and placeholders

ou want. On Fri, Apr 9, 2021 at 12:49 PM mailing lists via beginners wrote: Hello, I am having a problem with a very simple task and I don't see where the fault is. The first query works with problem but the second one fails with this error:  ./test.pl OK 1 DBD::mysql::st execute fail

Re: Problem with DBI and placeholders

e" is probably what you want. On Fri, Apr 9, 2021 at 12:49 PM mailing lists via beginners wrote: Hello, I am having a problem with a very simple task and I don't see where the fault is. The first query works with problem but the second one fails with this error:  ./test.pl OK 1 DBD::my

Re: Problem with DBI and placeholders

The ? is for quoting field values rather than entering table or field names. "SELECT * FROM $table" is probably what you want. On Fri, Apr 9, 2021 at 12:49 PM mailing lists via beginners < beginners@perl.org> wrote: > Hello, > > I am having a problem with a very simple t

Problem with DBI and placeholders

Hello, I am having a problem with a very simple task and I don't see where the fault is. The first query works with problem but the second one fails with this error:  ./test.pl OK 1 DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to

Problem with interaction of open3, sysread and DBI (pg)

I have a strange issue with sysread and postgres (and ffpeg/stderr) If the main program throws an error sysread stops if I write to the database (a log table) this is the program (need open3 because ffmpeg writes to stderr not stdout) use IPC::Open3; my($file,$in, $out); my $pid; use Symbol 'gen

Re: Problem with perlbrew and LiteSpeed

> On Dec 5, 2017, at 10:23 AM, Chas. Owens wrote: > > Test one: does the file actually exist. Thanks for the tests. It turns out there was a typo in the shebang line. It was a tough one to diagnose as the error said the file wasn't there. Frank -- To unsubscribe, e-mail: beginners-

Re: Problem with perlbrew and LiteSpeed

Test one: does the file actually exist. It is possible that the user is different, or something else in the park is wrong Test two: are the permissions on the file and the directories leading up to the file correct. If the process can't see the file, then there will be a problem. Test three: Is

Problem with perlbrew and LiteSpeed

I'm hoping someone has seen this before and can point me in the right direction. I'm moving my site to a VPS to be able to use a more modern version of Perl, but I've run into a problem. I installed perlbrew along with Perl 5.26.1. That went smoothly. However, when I try to r

problem with AnyEvent and blocking events

Hello teachers, I'm converting a simple perl multimedia script to an event based one, but it seems that I'm missing something very basic because I'm unable to make it work. The script receives commands from Lirc::Client (1.54) via next_codes() which is in blocking state whilst no data is avai

Re: problem with regex qr operator

Mike: On Thu, Jun 25, 2015 at 5:42 AM, Mike Martin wrote: > Hi > I am currently getting issues with regexes that use the qr operator. > > The results with qr are different than without. This is a small sample > program to illustrate it > > use strict; > > my $str='Database Administrator'; > my $p

problem with regex qr operator

Hi I am currently getting issues with regexes that use the qr operator. The results with qr are different than without. This is a small sample program to illustrate it use strict; my $str='Database Administrator'; my $pattern= '(?=^(?:(?!(?:datab|network|system)).)*$).*(?:Adm(?:in(?:i?strat(?:o

Re: Problem with regex

> On 6 Oct 2014, at 18:57, punit jain wrote: > > Thanks Paul. However I think I couldnot explain the problem. > > The issue is when I have mailid's as well as a part of input stream. > > Input stream ---> $str="ldap:///uid=user1,ou=People,o=test.com > ,a...@test.com

Re: Problem with regex

Thanks Paul. However I think I couldnot explain the problem. The issue is when I have mailid's as well as a part of input stream. Input stream ---> $str="ldap:///uid=user1,ou=People,o=test.com,a...@test.com ,t...@test.com,r...@test.com,ldap:///uid=user2,ou=People,o=test.com ,ldap:///uid=user3,ou

Re: Problem with regex

On Mon, Oct 06, 2014 at 09:34:15PM +0530, punit jain wrote: > Hi, > > I have a regex problem. My current working program is like this :- > > > #!/usr/bin/perl > > *$str='ldap:///uid=user1,ou=People,o=test.com > ,mailto:us...@test.com > ,ldap:///uid=user2,ou=People,o=test.com >

Re: Problem with regex

On 7 October 2014 05:04, punit jain wrote: > it breaks. I tried multiple regex, however could not get it working. > Any clue on regex changes to accomodate this ? > > 1. You said you have a regex, and that you can't get it working, but what is it that isn't working? 2. This might not be applicabl

Problem with regex

Hi, I have a regex problem. My current working program is like this :- #!/usr/bin/perl *$str='ldap:///uid=user1,ou=People,o=test.com ,mailto:us...@test.com ,ldap:///uid=user2,ou=People,o=test.com ,ldap:///uid=user3,ou=People,o=test.com ';* whi

Re: what's the problem with a system call

Shlomi Fish wrote: What system() does (at least on UNIX-like OSes) is fork a child, call exec() with a new process and wait for the new child to terminate (plus some other stuff to get rid of misbehaviours). ... and if you call "system" with just one long string, then Perl opens the system def

Re: what's the problem with a system call

Hi xiaolan, On Tue, 14 May 2013 18:51:51 +0800 xiaolan wrote: > Thanks all the answers. > Shlomi long time no see :) Yes. :-) I am available on IM: http://www.shlomifish.org/me/contact-me/ > > Have another question that, what's the difference between the system call > child process and the

Re: what's the problem with a system call

Thanks all the answers. Shlomi long time no see :) Have another question that, what's the difference between the system call child process and the native forked child process? Does the child process of system call have the problems of receiving signals from the parent? On Tue, May 14, 2013 a

Re: what's the problem with a system call

Hi Brian, thanks for replying well to xiaolan’s question. Regards, Shlomi Fish -- - Shlomi Fish http://www.shlomifish.org/ My Public Domain Photos - http://www.flickr.com/photos/shlomif/ 95% of Programmers consider

Re: what's the problem with a system call

On Tue, May 14, 2013 at 12:35 AM, xiaolan wrote: > Hello, > > what's the disadvantage when calling a system command from Perl? > i.e, system call to "rsync" rather than using the File::Rsync module. > is it hard to control the signals between the caller process and the > called system command? >

Re: what's the problem with a system call

On Tue, May 14, 2013 at 5:35 AM, xiaolan wrote: > Hello, > > what's the disadvantage when calling a system command from Perl? > i.e, system call to "rsync" rather than using the File::Rsync module. > is it hard to control the signals between the caller process and the called > system command? We

what's the problem with a system call

Hello, what's the disadvantage when calling a system command from Perl? i.e, system call to "rsync" rather than using the File::Rsync module. is it hard to control the signals between the caller process and the called system command? Thanks.

Re: problem with File::Util::readlimit

On Thu, May 09, 2013 at 08:51:23AM +0200, Luca Ferrari wrote: > In fact I was discovering it too reading the code, I've > submitted a bug report for this. I also submitted a bug report (so now I feel doubly bad for not letting the list know so he didn't get duplicates; twice the noise). I was info

Re: problem with File::Util::readlimit

On Wed, May 8, 2013 at 8:24 PM, Brandon McCaig wrote: > Looks like it raises an exception if the argument doesn't match a > NON-"digit" character. Which seems like the opposite of what is > wanted. > In fact I was discovering it too reading the code, I've submitted a bug report for this. Thanks

Re: problem with File::Util::readlimit

On Wed, May 08, 2013 at 06:49:48PM +0200, Luca Ferrari wrote: > Hello, Hello, > I'm encountering a problem with File::Util that I'm not able to > see, and I'm sure it's trivial: > > my $handle_file = new File::Util; > my $files_for = {}; > my

RE: problem with File::Util::readlimit

u out any. Regards, Peter From: fluca1...@gmail.com [fluca1...@gmail.com] On Behalf Of Luca Ferrari [fluca1...@infinito.it] Sent: Wednesday, May 08, 2013 9:49 AM To: beginners@perl.org Subject: problem with File::Util::readlimit Hello, I'm encountering a pro

problem with File::Util::readlimit

Hello, I'm encountering a problem with File::Util that I'm not able to see, and I'm sure it's trivial: my $handle_file = new File::Util; my $files_for = {}; my $max_file_size = int( 1024 * 1024 * 1024 ); $handle_file->readlimit( $max_file_size ); that once run produ

Re: Problem with Active Perl PPM on Windows

ou do with it is your gift back to God. --- From: Jim Gibson To: Perl Beginners Sent: Saturday, 9 March 2013 12:18 PM Subject: Re: Problem with Active Perl PPM on Windows On Mar 8,

Re: Problem with Active Perl PPM on Windows

On Mar 8, 2013, at 8:57 PM, *Shaji Kalidasan* wrote: > Greetings, > > I did a fresh installation of Active Perl version 5.16.2 and while using Perl > Package Manager (PPM) GUI interface, the view all packages (Ctrl + 1) shows > only the packages that comes with standard Perl distribution. > >

Problem with Active Perl PPM on Windows

Greetings, I did a fresh installation of Active Perl version 5.16.2 and while using Perl Package Manager (PPM) GUI interface, the view all packages (Ctrl + 1) shows only the packages that comes with standard Perl distribution. It shows the total number of known packages (272 packages), number o

Re: Problem with unless statement

On Apr 28, 2012, Shawn H Corey wrote: > Moral of the story: use meaningful variable names. Yep, you're right. =:\ I thought it was going to be a simple question about the unless statement. Turns out I was headed down the wrong path, so I changed the variable name to make it clear. Ne

Re: Problem with unless statement

On 04/28/2012 01:28 PM, Shawn H Corey wrote: On 12-04-28 12:36 PM, Uri Guttman wrote: that reduces to just: my $host = $mail_field || 'localhost' ; which is the classic defaulting style. it has one flaw, it makes '' and 0 not allowed for values in $mail_field. but i doubt those would ever be g

Re: Problem with unless statement

On 12-04-28 12:36 PM, Uri Guttman wrote: that reduces to just: my $host = $mail_field || 'localhost' ; which is the classic defaulting style. it has one flaw, it makes '' and 0 not allowed for values in $mail_field. but i doubt those would ever be good host names so it should be fine here. you

Re: Problem with unless statement

On 04/28/2012 12:10 PM, Jim Gibson wrote: On Apr 28, 2012, at 9:04 AM, sono...@fannullone.us wrote: my $host = 'localhost'; if ( defined ($mail_field) and ($mail_field ne '') ) { $host = $mail_field; } I would use: my $host = $mail_field ? $mail_field : 'localhost' ; that reduces

Re: Problem with unless statement

On Sat, Apr 28, 2012 at 12:16:57PM -0400, Shawn H Corey wrote: > On 12-04-28 12:10 PM, Jim Gibson wrote: >> >> On Apr 28, 2012, at 9:04 AM, sono...@fannullone.us wrote: >> >>> my $host = 'localhost'; >>> >>> if ( defined ($mail_field) and ($mail_field ne '') ) { >>> $host = $mail_field; >>> } >

Re: Problem with unless statement

On 12-04-28 12:10 PM, Jim Gibson wrote: On Apr 28, 2012, at 9:04 AM, sono...@fannullone.us wrote: my $host = 'localhost'; if ( defined ($mail_field) and ($mail_field ne '') ) { $host = $mail_field; } I would use: my $host = $mail_field ? $mail_field : 'localhost' ; Well, since

Re: Problem with unless statement

On Apr 28, 2012, at 9:04 AM, sono...@fannullone.us wrote: > my $host = 'localhost'; > > if ( defined ($mail_field) and ($mail_field ne '') ) { > $host = $mail_field; > } I would use: my $host = $mail_field ? $mail_field : 'localhost' ; -- To unsubscribe, e-mail: beginners-unsubscr...@

Re: Problem with unless statement

On Apr 28, 2012, Lesley Binks wrote: > To be robust, you might need to check that $xtra is defined AND has something > sensible in it using a regexp. Well, after being set straight to the error of my ways, I finally have code that seems to work in any situation: my $mail_field; # set

Re: Problem with unless statement

On Sat, Apr 28, 2012 at 08:00:09AM -0700, sono...@fannullone.us wrote: > Shawn, > > > are you sure this is what you want? > > I'm not sure of anything anymore. ;) > > I found something that sets $host properly: > > my $xtra = 'mail.example.com'; > my $host = 'localhost'; > That's a

Re: Problem with unless statement

On Apr 28, 2012, at 10:40 AM, sono...@fannullone.us wrote: > On Apr 28, 2012, at 7:32 AM, Lesley Binks wrote: > >> Says the $host identifier will be assigned the value 'localhost' only if >> $extra >> is not defined. >> >> But $extra is defined as 'mail.example.com' so $host won't be. > >

Re: Problem with unless statement

wrote in message news:65c0134b-14b8-4912-a22c-d92389b0b...@fannullone.us... Hi Shlomi, Thanks for getting back to me. What you should do is: [CODE] my $host; unless (defined($xtra)) { $host = 'localhost'; } Unfortunately, that gives me the same error. I had tried it before, but I was just

Re: Problem with unless statement

Shawn, > are you sure this is what you want? I'm not sure of anything anymore. ;) I found something that sets $host properly: my $xtra = 'mail.example.com'; my $host = 'localhost'; $host = $xtra if (length $xtra > 0); Can anyone see any holes in this code? Marc --

Re: Problem with unless statement

On 12-04-28 10:16 AM, sono...@fannullone.us wrote: I'm having a problem with the following code: #!/usr/bin/perl use strict; use warnings; my $xtra = 'mail.example.com'; my $host = 'localhost' unless (defined ($xtra)); # this is the same as saying: my $xtra

Re: Problem with unless statement

Shlomi, > It's a bad idea to declare variables with a trailing conditional statement Never mind my "why" question. It finally dawned on me that the unless statement will not set the $host variable. And I thought sleeping on it would help. :\ Marc -- To unsubscribe, e-mail: beginners-

Re: Problem with unless statement

On Apr 28, 2012, at 7:32 AM, Lesley Binks wrote: > Says the $host identifier will be assigned the value 'localhost' only if > $extra > is not defined. > > But $extra is defined as 'mail.example.com' so $host won't be. That makes sense. What I'm trying to do is set $host to one of the

Re: Problem with unless statement

Hi Shlomi, Thanks for getting back to me. > What you should do is: > > [CODE] > > my $host; > unless (defined($xtra)) > { > $host = 'localhost'; > } Unfortunately, that gives me the same error. I had tried it before, but I was just trying for a one-liner. ;) > It's a b

Re: Problem with unless statement

On Sat, Apr 28, 2012 at 07:16:18AM -0700, sono...@fannullone.us wrote: > I'm having a problem with the following code: > > #!/usr/bin/perl > use strict; > use warnings; > > my $xtra = 'mail.example.com'; > > my $host = 'localhost' unle

Re: Problem with unless statement

On 04/28/2012 09:16 AM, sono...@fannullone.us wrote: I'm having a problem with the following code: #!/usr/bin/perl use strict; use warnings; my $xtra = 'mail.example.com'; my $host = 'localhost' unless (defined ($xtra)); print $host; I get the mess

Re: Problem with unless statement

Hi Marc, On Sat, 28 Apr 2012 07:16:18 -0700 sono...@fannullone.us wrote: > I'm having a problem with the following code: > > #!/usr/bin/perl > use strict; > use warnings; > > my $xtra = 'mail.example.com'; > > my $host = 'localhost&#x

Problem with unless statement

I'm having a problem with the following code: #!/usr/bin/perl use strict; use warnings; my $xtra = 'mail.example.com'; my $host = 'localhost' unless (defined ($xtra)); print $host; I get the message "Use of uninitialized value $host in print

RE: problem with nested regex matchs

Chris Stinemetz [chrisstinem...@gmail.com] wrote: >Hello Shanmugam, > >Please start a new thread when you post a new topic. > > >On Wed, Mar 7, 2012 at 5:14 PM, shanmugam m wrote: >> Hi, >> This is my first perl program..I'm getting wired errors.Please take a >> look. >> >> This line looks inco

RE: problem with nested regex matchs

> -Original Message- > From: Chris Stinemetz [mailto:chrisstinem...@gmail.com] > Sent: Wednesday, March 07, 2012 8:57 PM > To: John W. Krahn; beginners@perl.org > Subject: Re: problem with nested regex matchs > > >> > >>> > >>> open(MYI

Re: problem with nested regex matchs

>> >>> >>> open(MYINPUTFILE ,"/net/fallsroot/export/d100/m4/input_file"); >>> open(MYOUTFILE, ">  output_file"); >> >> >> it is recommended to use a three argument filehandle > > > "three argument filehandle"? What I meant to imply was: "3-argument version of open" > > >> open my $INPUTFILE, '<',

Re: problem with nested regex matchs

On 12-03-07 06:40 PM, Chris Stinemetz wrote: On Wed, Mar 7, 2012 at 5:14 PM, shanmugam m wrote: my @column1 = split("/\\/",$line); I'm not sure what you are trying to do here. Split will split on white space by default I think he's trying to split on a backslash. Try: my @column1 =

Re: problem with nested regex matchs

Chris Stinemetz wrote: Hello Shanmugam, Please start a new thread when you post a new topic. On Wed, Mar 7, 2012 at 5:14 PM, shanmugam m wrote: Hi, This is my first perl program..I'm getting wired errors.Please take a look. #!persist/pkg/bin/perl use diagnostics; use warnings; always u

Re: problem with nested regex matchs

Subject: Re: problem with nested regex matchs What does this post have to do with "nested regex matchs"? shanmugam m wrote: Hi, This is my first perl program..I'm getting wired errors.Please take a look. What errors are you getting? #!persist/pkg/bin/perl use d

Re: problem with nested regex matchs

correction > while ( my $line = $INPUTFILE ) { should be: while ( my $line = <$INPUTFILE> ) { -- To unsubscribe, e-mail: beginners-unsubscr...@perl.org For additional commands, e-mail: beginners-h...@perl.org http://learn.perl.org/

Re: problem with nested regex matchs

Hello Shanmugam, Please start a new thread when you post a new topic. On Wed, Mar 7, 2012 at 5:14 PM, shanmugam m wrote: > Hi, >  This is my first perl program..I'm getting wired errors.Please take a > look. > > > #!persist/pkg/bin/perl > use diagnostics; > use warnings; always use the strict

Re: problem with nested regex matchs

Hi, This is my first perl program..I'm getting wired errors.Please take a look. #!persist/pkg/bin/perl use diagnostics; use warnings; open(MYINPUTFILE ,"/net/fallsroot/export/d100/m4/input_file"); open(MYOUTFILE, "> output_file"); foreach $line (){ chomp($line);# remo

Re: problem with nested regex matchs

On 07/03/2012 16:18, mailing lists wrote: Hello, is there any way to extract the queued ID (7BC5A446) from the first line and also match the second with only one regex?? #!/usr/bin/perl use strict; use warnings; use 5.010; while(){ if (/^(?\S+?)\s+?(?\S+?)\s+?(?\S+?)\s+?(?\S+?)\s+?(?\S+

problem with nested regex matchs

Hello, is there any way to extract the queued ID (7BC5A446) from the first line and also match the second with only one regex?? #!/usr/bin/perl use strict; use warnings; use 5.010; while(){     if (/^(?\S+?)\s+?(?\S+?)\s+?(?\S+?)\s+?(?\S+?)\s+?(?\S+?):\s+?(?\S+?):\s+?to=(?\S+?),\s+?relay=(?\

Re: Problem with $_

On Sun, 04 Mar 2012 11:15:34 + Rob Dixon wrote: ... > > $_ is a package variable. You can fully-qualify it here and access it > as $main::_. > > Perl itself takes care of using $_ in foreach loops by localizing it > within every such loop. The problem is usually when it is implicitly > use

Re: Problem with $_

On 04/03/2012 10:21, Manfred Lotz wrote: You have discovered why many people say it is unsafe to use $_. $_ is a global variable, and the loop while (<$fh> ) { print; } modifies it, leaving it undefined at end of file. Unfortunately the loop foreach ( @cmds ) { say sub1($_); }; has

Re: Problem with $_

Hi Timothy, Thanks for your reply. On Sun, 4 Mar 2012 10:52:04 +0100 timothy adigun <2teezp...@gmail.com> wrote: > Hi Manfred, > > On Sun, Mar 4, 2012 at 8:56 AM, Manfred Lotz > wrote: > > > Hi there, > > I've got a strange problem with $_. It seems I

Re: Problem with $_

Hi Rob, Thanks for your reply. On Sun, 04 Mar 2012 09:50:07 + Rob Dixon wrote: > On 04/03/2012 07:56, Manfred Lotz wrote: ... > > > > Running this gives: > > > > Sub3: Issuing [uname -a] > > Linux hogwart 3.0.0-14-generic-pae #23~lucid1-Ubuntu SMP Thu Dec 8 > > 15:03:12 UTC 2011 i686 GNU/L

Re: Problem with $_

Hi Manfred, On Sun, Mar 4, 2012 at 8:56 AM, Manfred Lotz wrote: > Hi there, > I've got a strange problem with $_. It seems I do not understand > something which might be basic. Anyway, here is a minimal example. > > #! /usr/bin/perl > > use strict; > use warnin

Re: Problem with $_

On 04/03/2012 07:56, Manfred Lotz wrote: Hi there, I've got a strange problem with $_. It seems I do not understand something which might be basic. Anyway, here is a minimal example. #! /usr/bin/perl use strict; use warnings; use 5.010; sub sub1 { my $cmd = shift; print "Sub

Problem with $_

Hi there, I've got a strange problem with $_. It seems I do not understand something which might be basic. Anyway, here is a minimal example. #! /usr/bin/perl use strict; use warnings; use 5.010; sub sub1 { my $cmd = shift; print "Sub3: Issuing [$cmd]\n"; open my $fh, &

Re: problem with passing variables

Hi Mark, On Fri, 30 Dec 2011 14:19:04 -0500 Mark Haney wrote: > On 12/30/2011 12:50 PM, Igor Dovgiy wrote: > > If you pass into SQL query something assigned by user, use > > placeholders by all means. ) It's not that hard, but it'll save you a > > lot of headaches, believe me. ) > > > > 2011/1

Re: problem with passing variables

On 12/30/2011 12:50 PM, Igor Dovgiy wrote: If you pass into SQL query something assigned by user, use placeholders by all means. ) It's not that hard, but it'll save you a lot of headaches, believe me. ) 2011/12/30 Mark Haney mailto:ma...@abemblem.com>> But there's another (and in my opi

Re: problem with passing variables

If you pass into SQL query something assigned by user, use placeholders by all means. ) It's not that hard, but it'll save you a lot of headaches, believe me. ) 2011/12/30 Mark Haney > But there's another (and in my opinion, usually better) way: using > prepared sql statement: > my $sth = $dbh->

Re: problem with passing variables

Hi Mark, On Fri, 30 Dec 2011 12:39:04 -0500 Mark Haney wrote: > On 12/30/2011 12:30 PM, Igor Dovgiy wrote: > > Hi Mark, > > > > If your variables are strictly internal and by no means might be ever > > tainted (read: user input), what you're doing is mostly ok. > > But you need to quote the dat

Re: problem with passing variables

On 12/30/2011 12:30 PM, Igor Dovgiy wrote: Hi Mark, If your variables are strictly internal and by no means might be ever tainted (read: user input), what you're doing is mostly ok. But you need to quote the dates passed within query itself, like this: my $sql = qq/SELECT * FROM `events` WHER

Re: problem with passing variables

On Fri, 30 Dec 2011 12:08:50 -0500 Mark Haney wrote: > I'm not sure if this is the right list for this, so bear with me. If it > isn't I'll be glad to post it on the correct one. > > I've got a problem with passing variables to a SQL server inside a CGI

Re: problem with passing variables

the right list for this, so bear with me. If it > isn't I'll be glad to post it on the correct one. > > I've got a problem with passing variables to a SQL server inside a CGI > script. My code is like this: > > my $begin_time = "2011-11-16 11:00:00"; >

problem with passing variables

I'm not sure if this is the right list for this, so bear with me. If it isn't I'll be glad to post it on the correct one. I've got a problem with passing variables to a SQL server inside a CGI script. My code is like this: my $begin_time = "2011-11-16 11:00:00&quo

Re: Problem with SDL::Perl

Adam what distro are you on? On Tue, 2011-06-14 at 13:54 -0700, Adam Fairbrother wrote: > $LD_LIBRARY_PATH was unset. I set it manually to the SDL Libs folder, and the > error no longer happens. My test picture dosn't show up, but I think that's > an issue I can hack through myself. > > Thanks

Re: AW: Problem with SDL::Perl

e.kar...@gmail.com] > Gesendet: Dienstag, 14. Juni 2011 22:19 > An: Adam Fairbrother > Cc: beginners@perl.org; sdl-devel > Betreff: Re: Problem with SDL::Perl > > Hmm that is all fine. Can I see your LD_LIBRARY_PATH? > > echo $LD_LIBRARY_PATH > > Are you still getting the pr

AW: Problem with SDL::Perl

Its not looking good imo. See, its just installing libjpeg.la, not libjpeg.so.8 ... -Ursprüngliche Nachricht- Von: Kartik Thakore [mailto:thakore.kar...@gmail.com] Gesendet: Dienstag, 14. Juni 2011 22:19 An: Adam Fairbrother Cc: beginners@perl.org; sdl-devel Betreff: Re: Problem with

Re: Problem with SDL::Perl

Hmm that is all fine. Can I see your LD_LIBRARY_PATH? echo $LD_LIBRARY_PATH Are you still getting the problem btw cause the tests run fine. On Tue, 2011-06-14 at 09:47 -0700, Adam Fairbrother wrote: > My bad, I guess I glossed by the sdl-de...@perl.org list when I was looking > through. > >

Re: Problem with SDL::Perl

$LD_LIBRARY_PATH was unset. I set it manually to the SDL Libs folder, and the error no longer happens. My test picture dosn't show up, but I think that's an issue I can hack through myself. Thanks you for all the help with this. #-- Adam Fair

Re: Problem with SDL::Perl

> Hi, H Adam, > > It's been a week since I asked about this and No one has responded, Did I > ask incorrectly or in the wrong mailing list? > Apologies for that I normally don't see this mailing list. sdl-de...@perl.org is a better list for these things. > Any help that could be provided would b

Re: Problem with SDL::Perl

My bad, I guess I glossed by the sdl-de...@perl.org list when I was looking through. Here is a link to a file that contains the stdout from "fforce install Alien::SDL SDL" inside the cpan shell. If it's not the information you were looking for let me know and I can provide the correct info. h

Re: Problem with SDL::Perl

On Tue, Jun 14, 2011 at 2:41 AM, Adam Fairbrother wrote: > Hi, > > It's been a week since I asked about this and No one has responded,  Did I > ask incorrectly or in the wrong mailing list? > > Any help that could be provided would be appreciated. > > Thanks, > > #

Re: Problem with SDL::Perl

Hi, It's been a week since I asked about this and No one has responded, Did I ask incorrectly or in the wrong mailing list? Any help that could be provided would be appreciated. Thanks, #-- Adam Fairbrother Help Desk Technician af

Re: Question/Problem with foreach loop

Gents, Sorry for my delayed response. Thank you for your suggestions. Based on your feedback, I made the following changes, and the hook is now working as expected. Thanks a million! my $taskstate = $taskEntity->GetFieldValue(state)->GetValue();     $session->OutputDebugString ("Task's state

Problem with SDL::Perl

Hi I'm having a bit of trouble getting a SDL::Perl running on a debian Lenny setup. I have SDL::Perl installed from CPAN. Alien::SDL installed from cpan with the option to build all dependencies and library's. When I was testing to get things working, my short test script would throw an error.

Re: problem with dbi oracle blob

On Wed, May 25, 2011 at 11:45:13 + , Marco van Kammen wrote: > Hi List, > > I'm struggeling with the following: > > There is a blob field in the oracle db which contains xml... > I want to read this blob and make a single xml file out of it... > Now when using the code below I get the data o

problem with dbi oracle blob

Hi List, I'm struggeling with the following: There is a blob field in the oracle db which contains xml... I want to read this blob and make a single xml file out of it... Now when using the code below I get the data out of the blob with parts of xml but its all messed up... ’^@^Esr^@^Porg.j

Re: Question/Problem with foreach loop

> "CA" == CM Analyst writes: CA> my $taskEntity = $session->GetEntity ('almtask', $_); that gets a perl object in $taskEntity. CA> $taskEntity->GetFieldValue(state)->GetValue(); where is the value being assigned to? $taskEntity is not being modified or set in that line of code. it is j

Re: Question/Problem with foreach loop

On 5/18/11 Wed May 18, 2011 5:06 PM, "CM Analyst" scribbled: > Hi, > > In this code, the intent is to iterate through the tasks and modify the ID > field. The Task record (entity) should not be modified if it's state equals > "Completed". > > When I run this routine, there are two problems:

Question/Problem with foreach loop

Hi, In this code, the intent is to iterate through the tasks and modify the ID field. The Task record (entity) should not be modified if it's state equals "Completed". When I run this routine, there are two problems: Problem 1) The "if" statement is not being evaluated. The record (even if it

sample problem with mimedefang

hello list hello all "the" guru it's my first post I present to you a problem that I can not solve this alone deals mimedefang and perl I am currently facing this code in mimedefang $gi = Geo::IP->new(GEOIP_STANDARD); $country = $gi->country_code_by_name($Helo); action_add_hea

  1   2   3   4   5   6   7   8   9   10   >