User Profile

Collapse

Profile Sidebar

Collapse
gwb
gwb
Last Activity: Nov 21 '06, 01:00 PM
Joined: Nov 15 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • gwb
    replied to Query Database where my date field is less than 31 days
    in Access
    That was the fix!!! Thank You All Very Much! I hope with time I'll be able to help out someone like you fine folks have helped me.

    Thanks again to everyone who helped....
    See more | Go to post

      Leave a comment:

    • gwb
      replied to Query Database where my date field is less than 31 days
      in Access
      This code seems to process through the query but it sends me back to my login page. Just to make sure I am not messing this up, I need this statement to search the records in my access database and if the email and password match what is in the database and the memberdate (date member signed up) is not more than 31 days old, the member is granted access to the members area, if not the member is redirected back to the login page To make sure I am...
      See more | Go to post

        Leave a comment:

      • gwb
        replied to Query Database where my date field is less than 31 days
        in Access
        Now receiving this error. Tried moving the last parentheses outside the quote that gave me the second error listed.

        Error with both parentheses inside quote
        Microsoft VBScript compilation error '800a03ee'

        Expected ')'

        /verifypassword. asp, line 212

        "AND ([memberdate]>#" & Format(Date()-31,"m/d/yyyy") & "#))"
        -----------------------------------------------------------------------------------^...
        See more | Go to post

          Leave a comment:

        • gwb
          replied to Query Database where my date field is less than 31 days
          in Access
          Here is revised code with double quotes:
          Code:
          set rscheck = my_conn.Execute ( _
"SELECT * " & _
"FROM member " & _
"WHERE (([email]='" & email & "') " & _
  "AND ([password]='" & password & "') " & _
  "AND ([memberdate]>#" & Format(Date()-31,"m/d/yyyy") & "#"))
          Generates...
          See more | Go to post

            Leave a comment:

          • gwb
            replied to Query Database where my date field is less than 31 days
            in Access
            Thanks for the help! In the m/d/yyyy format it doesn't like the single quotes it seems
            Now receiving this error:

            Microsoft VBScript compilation error '800a03ea'

            Syntax error

            /verifypassword. asp, line 212

            "AND ([memberdate]>#" & Format(Date()-31,'m/d/yyyy') & "#"))
            -----------------------------------------^...
            See more | Go to post

              Leave a comment:

            • gwb
              replied to Query Database where my date field is less than 31 days
              in Access
              I copied and pasted the way your code example was and then I noticed no closing parentheses so I also tried adding the closing parentheses, neither way worked it gave error below

              Received This Error :

              Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

              [Microsoft][ODBC Microsoft Access Driver] Undefined function 'GETDATE' in expression....
              See more | Go to post

                Leave a comment:

              • gwb
                replied to Query Database where my date field is less than 31 days
                in Access
                Sorry I guess i should have expanded on this a bit more. Thank you for your reply by the way. I am using this to login to a section on a website using asp. my sql statement to select only the records that meets the criteria is:

                set rscheck = my_conn.Execute ("Select * from member where email='" & email & "' and password='" & password & "' AND memberdate='"DA TEDIFF(Day, [memberdate], GETDATE()...
                See more | Go to post

                  Leave a comment:

                • gwb
                  started a topic Query Database where my date field is less than 31 days
                  in Access

                  Query Database where my date field is less than 31 days

                  I am new to database queries. I am using access, trying to query my database where the field memberdate is less than 31 days old. I thought maybe the DateDiff function would work but I'm not sure how to use it correctly.

                  I would appreciate any help. Thanks
                  See more | Go to post
                  No activity results to display
                  Show More
                  Working...