Beefy Boxes and Bandwidth Generously Provided by pair Networks
P is for Practical

DBI - Table names & placeholders

by McDarren (Abbot)
on Apr 24, 2010 at 04:48 UTC ( #836640=perlquestion: print w/replies, xml ) Need Help??

Help for this page

Select Code to Download

  1. or download this
    INSERT INTO Widgets201003 (moo, baa, cluck) VALUES (?, ?, ?)
    INSERT INTO Widgets201004 (moo, baa, cluck) VALUES (?, ?, ?)
    INSERT INTO Widgets201005 (moo, baa, cluck) VALUES (?, ?, ?)
  2. or download this
    INSERT INTO ? (moo, baa, cluck) VALUES (?, ?, ?)

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://836640]
Approved by GrandFather
[Cosmic37]: now I have tried another blunder - can anyone explain why I am such a dunderhead?
[Cosmic37]: if ( $line =~ /$mydt/ ) { print $line; }
[Cosmic37]: I try to match successive date times stored in variable $mydt
[Cosmic37]: I guess it is searching for the string "$mydt"
[Corion]: Indeed cool, erix ;)
[Cosmic37]: rather than the value of $mydt which is a date time strong such as 2016-01-01 12:30:56
[Corion]: Cosmic37: No, but maybe $mydt doesn't contain what you think it does, or it contains characters that are special in a regular expression? Try if( $line =~ /\Q$mydt\E/) { ... for a literal match
[Cosmic37]: I mean string grrr
[Corion]: Maybe add an else branch in which you print what the values of $line and $mydt are?
[Cosmic37]: ah thank you I will try

How do I use this? | Other CB clients
Other Users?
Others studying the Monastery: (8)
As of 2017-06-29 17:00 GMT
Find Nodes?
    Voting Booth?
    How many monitors do you use while coding?

    Results (673 votes). Check out past polls.