User Profile

Collapse

Profile Sidebar

Collapse
xoozlez
xoozlez
Last Activity: Jan 17 '08, 09:06 AM
Joined: Jul 25 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • xoozlez
    replied to Query past events of 2007
    in ASP Classic
    Thank you Jared!

    I manage to get it. In case it might be of some help to few of you. This is the code I am using.

    varEventDate = FormatDateTime( CDate(rs("Event DateBegin")),1)


    Cheers!
    See more | Go to post

      Leave a comment:

    • xoozlez
      replied to Query past events of 2007
      in ASP Classic
      Hey Jared! GREAT! It works! Thank you so much for your effort and help in this. I am really so happy. :)

      Ok just a little bit more. I like to enhance the dateformat such that it is showing DDMMYY. You got any idea how should I change it? As the current results is showing MMDDYY...
      See more | Go to post

        Leave a comment:

      • xoozlez
        replied to Query past events of 2007
        in ASP Classic
        Hi Jared,

        Thank you for helping me with this problem. I had tried and this is the error I am getting:

        Microsoft OLE DB Provider for SQL Server error '80040e14'
        Line 1: Incorrect syntax near '#'.
        /Form/index.asp, line 38

        :)...
        See more | Go to post

          Leave a comment:

        • xoozlez
          replied to Query past events of 2007
          in ASP Classic
          Hi there, any help? :)
          See more | Go to post

            Leave a comment:

          • xoozlez
            replied to Query past events of 2007
            in ASP Classic
            Hi guys, thank you for getting back to me.

            I am using MSSQL, thus apostrophes is using here. It is not working such that all events from 2007 are still showing up. I would think it is something to do with date format, but I have no idea how to proceed on and resolve from there....
            See more | Go to post

              Leave a comment:

            • xoozlez
              started a topic Query past events of 2007
              in ASP Classic

              Query past events of 2007

              Hi there,

              I have a registration form where I like to filter out the past events of 2007. This is the code I am using :

              strSQL = "SELECT EventID, EventName, EventDateBegin, EventDateEnd, EventTimeBegin, Category FROM Events WHERE EventDateBegin >'01/01/2008' AND Events.Category LIKE '3' OR Events.Category LIKE '4' OR Events.Category LIKE '5' OR Events.Category LIKE '6' OR Events.Category LIKE '7' OR Events.Category...
              See more | Go to post
              • xoozlez
                replied to How to insert new records from one table to another table
                in Access
                Thanks so much for your guidance. That is useful and I manage to get it work out.

                In case some of you may need it. This is the query I used in

                INSERT INTO NonMembers ( Email )
                SELECT dbo_company.con tact_email
                FROM dbo_company
                WHERE (((dbo_company. mem_type)="Non-Member") AND ((dbo_company.d ate_created)>#7/25/2007#));
                See more | Go to post

                  Leave a comment:

                • xoozlez
                  replied to How to insert new records from one table to another table
                  in Access
                  Hi people,

                  I tried this but don't think I am doing the right way. Any people can advise? :)

                  SELECT dbo_company.ceo _email, dbo_company.con tact_email, dbo_company.mem _type, dbo_company.dat e_created, Members.Email
                  FROM dbo_company, Members
                  WHERE (((dbo_company. mem_type)<>"Non-Member") AND ((dbo_company.d ate_created)>#7/25/2007#))
                  INSERT INTO Members.Email;
                  See more | Go to post

                    Leave a comment:

                  • xoozlez
                    started a topic How to insert new records from one table to another table
                    in Access

                    How to insert new records from one table to another table

                    Hi there,

                    How do I insert new records from a dbo table to another table?
                    This is what I have:

                    1 dbo_company
                    1 Member (table)

                    I made a query in dbo_company with the criteria I only want to retrieve out new records from "ceo_email" and "contact_em ail" column after e.g 25.July.07

                    Thereafter I want to insert these new records into the Member table with a single...
                    See more | Go to post
                    No activity results to display
                    Show More
                    Working...