Professional Web Applications Themes

date query problem, date in variable - MySQL

I am using the following query : $query_archief = "SELECT * FROM vacatures where dd_eind_plaatsing < $dd_eind_plaatsing_archief1" note: $dd_eind_plaatsing_archief1 = 2005-10-21 it seems the variable $dd_eind_plaatsing_archief1 is not exepted as a proper date, what is the correct way to set up a query using a date variable....

  1. #1

    Default date query problem, date in variable

    I am using the following query :

    $query_archief = "SELECT * FROM vacatures where dd_eind_plaatsing <
    $dd_eind_plaatsing_archief1"

    note: $dd_eind_plaatsing_archief1 = 2005-10-21

    it seems the variable $dd_eind_plaatsing_archief1 is not exepted as a
    proper date, what is the correct way to set up a query using a date
    variable.





    roy Guest

  2. #2

    Default Re: date query problem, date in variable

    roy wrote:
    > I am using the following query :
    >
    > $query_archief = "SELECT * FROM vacatures where dd_eind_plaatsing <
    > $dd_eind_plaatsing_archief1"
    >
    > note: $dd_eind_plaatsing_archief1 = 2005-10-21
    >
    > it seems the variable $dd_eind_plaatsing_archief1 is not exepted as a
    > proper date, what is the correct way to set up a query using a date
    > variable.
    Wrinting 2005-10-21 in your script language yields to the number 1974
    (2005 minus 10 minus 21). The same is happening in the SQL-query.
    You must quote the date properly:

    WHERE dd_eind_plaatsing<'$dd_eind_plaatsing_archief1'

    Please check for SQL-injection.

    Greetings
    Kai

    --
    This signature is left as an exercise for the reader.
    Kai Ruhnau Guest

Similar Threads

  1. More Date Query Problem
    By Daniel Eng in forum Coldfusion - Getting Started
    Replies: 5
    Last Post: September 16th, 01:32 PM
  2. SELECT query Error, possible date problem?
    By rowbeast in forum Coldfusion Database Access
    Replies: 2
    Last Post: April 20th, 02:15 PM
  3. Replies: 2
    Last Post: November 28th, 03:12 AM
  4. Replies: 0
    Last Post: August 12th, 04:20 PM
  5. Problem with ADO query against a DBF date field
    By Nicole Calinoiu in forum ASP Database
    Replies: 3
    Last Post: August 7th, 12:22 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139