Thread: Perl and Dates

    #1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2000
    Location
    Cape Town, WP, South Africa
    Posts
    39
    Rep Power
    15
    Hi there

    I am trying to use a date as a criteria in a sql statement

    the database is an access data base and requires the date to be put between hashes
    eg. #27/05/00#

    however perl sees this as commenting out
    I thought of writing it like this

    eg. #27/05/00# but it doed not seem to work

    does any body have any ideas

    Thanks
  2. #2
  3. Ole` Timer
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2000
    Location
    N.W. Iowa
    Posts
    472
    Rep Power
    15
    You could do something like this:
    <BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">code:</font><HR><pre>
    my $date = qq(#27/05/00#);
    [/code]

    Now the $date variable should be passed withouth the need to escape everything and will produce the desire value.



    ------------------
    <A HREF="http://www.thunder-rain.com" TARGET=_blank>
    Thunder Rain Internet Publishing</A>
    Providing Personal/Business
    Internet Solutions that work!

IMN logo majestic logo threadwatch logo seochat tools logo