Too Few Parameters?? Date field?

Ask a Question related to Adobe Dreamweaver & Contribute, Design and Development.

  1. #1

    Default Too Few Parameters?? Date field?

    Hi,

    Access, DWMX, ASP, VBScript.

    SELECT eventydate
    FROM qryEvents
    ORDER BY eventydate ASC

    Is returning:

    Too Few Parameters, Expected 1??

    What is wrong?
    PS. I called it eventydate because I was worried that eventdate was a field
    name I perhaps couldn't use? Both produce the same error.

    Doing my head in this.

    Nath.


    Nathon Jones Guest

  2. Similar Questions and Discussions

    1. Query one database field with 2 parameters.
      I am trying to query a database field with several check boxes from a form. I though this would work but it doesn?t : Select * From table WHERE ...
    2. How do I use URL parameters to return a specific field?
      I have a form, when users complete it I would like to have a confirmation page that returns the value of the "first_name" field from the form, eg....
    3. Converting a text field to a date field - FM6
      I need to convert a Text field containing both auto and manually entered dates over to a Date field. The records that were autoentered move over...
    4. OpenReport with date parameters
      "osti" <gottholmd@osti.gov> wrote: osti, SQL requires dates in a specific format: date in US format (that is mm/dd/yyyy) enclosed in #...
    5. Linking date field to text field entry
      Is there a way to setup a date field that will automatically enter the date when any information is entered into a field next to it?
  3. #2

    Default Re: Too Few Parameters?? Date field?

    Unless you have a field in your query called eventydate then this statement
    is not going to work.

    --
    Regards

    Paul Whitham
    Macromedia Certified Professional for Dreamweaver MX2004
    Valleybiz Internet Design
    [url]www.valleybiz.net[/url]

    Team Macromedia Volunteer for Ultradev/Dreamweaver MX
    [url]www.macromedia.com/support/forums/team_macromedia[/url]

    "Nathon Jones" <nathonjonesNOT@kirkmoor.com> wrote in message
    news:cvl1us$3t6$1@forums.macromedia.com...
    > Hi,
    >
    > Access, DWMX, ASP, VBScript.
    >
    > SELECT eventydate
    > FROM qryEvents
    > ORDER BY eventydate ASC
    >
    > Is returning:
    >
    > Too Few Parameters, Expected 1??
    >
    > What is wrong?
    > PS. I called it eventydate because I was worried that eventdate was a
    field
    > name I perhaps couldn't use? Both produce the same error.
    >
    > Doing my head in this.
    >
    > Nath.
    >
    >

    Paul Whitham TMM Guest

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