Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. General Programming
  3. C#
  4. hi its very urgent

hi its very urgent

Scheduled Pinned Locked Moved C#
database
17 Posts 11 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • T Tauseef A

    hi all please tell me the query actually i have a table named history from which i want to get first and last record of a particualr person based on a date given in the query parameter thanks hello

    hello

    S Offline
    S Offline
    Stefan Troschuetz
    wrote on last edited by
    #4

    If you don't show that you at least tried to solve this on your own (include the query you come up with until now and which does not work), most probably nobody here will help you cause this forum is no place to let others completely do your work.


    "Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook

    www.troschuetz.de

    1 Reply Last reply
    0
    • S Stefan Troschuetz

      quiteSmart wrote:

      Does that make the response faster?

      Your answer was quite fast :-D


      "Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook

      www.troschuetz.de

      Q Offline
      Q Offline
      quiteSmart
      wrote on last edited by
      #5

      Stefan Troschütz wrote:

      Your answer was quite fast

      Was it a time record?? :laugh::laugh::laugh::laugh:

      S 1 Reply Last reply
      0
      • T Tauseef A

        hi all please tell me the query actually i have a table named history from which i want to get first and last record of a particualr person based on a date given in the query parameter thanks hello

        hello

        G Offline
        G Offline
        Guffa
        wrote on last edited by
        #6

        Please don't cross post.

        --- Year happy = new Year(2007);

        1 Reply Last reply
        0
        • Q quiteSmart

          Stefan Troschütz wrote:

          Your answer was quite fast

          Was it a time record?? :laugh::laugh::laugh::laugh:

          S Offline
          S Offline
          Stefan Troschuetz
          wrote on last edited by
          #7

          quiteSmart wrote:

          Was it a time record??

          I don't think so, but nevertheless pretty impressive ;)


          "Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook

          www.troschuetz.de

          Q 1 Reply Last reply
          0
          • S Stefan Troschuetz

            quiteSmart wrote:

            Was it a time record??

            I don't think so, but nevertheless pretty impressive ;)


            "Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook

            www.troschuetz.de

            Q Offline
            Q Offline
            quiteSmart
            wrote on last edited by
            #8

            Stefan Troschütz wrote:

            I don't think so

            mmmmmmmm i have to practice more:-D:-D:laugh::laugh::laugh::laugh::laugh:

            1 Reply Last reply
            0
            • T Tauseef A

              hi all please tell me the query actually i have a table named history from which i want to get first and last record of a particualr person based on a date given in the query parameter thanks hello

              hello

              V Offline
              V Offline
              V 0
              wrote on last edited by
              #9

              You'll find this[^] useful...

              V. I found a living worth working for, but haven't found work worth living for.

              1 Reply Last reply
              0
              • T Tauseef A

                hi all please tell me the query actually i have a table named history from which i want to get first and last record of a particualr person based on a date given in the query parameter thanks hello

                hello

                E Offline
                E Offline
                ednrgc
                wrote on last edited by
                #10

                Urgent = rarely gets answered Very Urgent = almost never gets answered Cross posted Very Urgent = ignored by the regulars here.

                1 Reply Last reply
                0
                • T Tauseef A

                  hi all please tell me the query actually i have a table named history from which i want to get first and last record of a particualr person based on a date given in the query parameter thanks hello

                  hello

                  D Offline
                  D Offline
                  Dan Neely
                  wrote on last edited by
                  #11

                  SELECT username FROM cpPosters WHERE clue = 0 returned: ghumman63

                  -- Rules of thumb should not be taken for the whole hand.

                  1 Reply Last reply
                  0
                  • T Tauseef A

                    hi all please tell me the query actually i have a table named history from which i want to get first and last record of a particualr person based on a date given in the query parameter thanks hello

                    hello

                    B Offline
                    B Offline
                    BedHead
                    wrote on last edited by
                    #12

                    what are the fields on the history record that you want to display?

                    - I want to know.

                    1 Reply Last reply
                    0
                    • Q quiteSmart

                      ghumman63 wrote:

                      hi its very urgent

                      mmmmmmmmmm What if no body answered? Why is it always that some people have to say it is urgent? Does that make the response faster? I don't think so.:mad: :mad:

                      E Offline
                      E Offline
                      Exelioindia
                      wrote on last edited by
                      #13

                      if u knw the answer, then just say the answer, but pass your comments about their subject coz they only know their bad position, at tht time thy cant search for an good subject , also it's silly

                      Know is Drop, Unknown is Ocean

                      V S 2 Replies Last reply
                      0
                      • E Exelioindia

                        if u knw the answer, then just say the answer, but pass your comments about their subject coz they only know their bad position, at tht time thy cant search for an good subject , also it's silly

                        Know is Drop, Unknown is Ocean

                        V Offline
                        V Offline
                        V 0
                        wrote on last edited by
                        #14

                        I disagree, the 'community' CP only runs smoothly if a certain (n)etiquette is used. People who don't want to use this (n)etiquette don't belong here. A lot of people will flame someone for not 'following the rules' and with reason, this place wouldn't be so nice without. If you don't believe me, feel free to ask in the lounge. (The C# forum is not intended for discussions like this.)

                        V. I found a living worth working for, but haven't found work worth living for.

                        1 Reply Last reply
                        0
                        • E Exelioindia

                          if u knw the answer, then just say the answer, but pass your comments about their subject coz they only know their bad position, at tht time thy cant search for an good subject , also it's silly

                          Know is Drop, Unknown is Ocean

                          S Offline
                          S Offline
                          Stefan Troschuetz
                          wrote on last edited by
                          #15

                          Exelioindia wrote:

                          if u knw the answer, then just say the answer

                          Do you know the saying: "Give a man a fish and he will eat for a day ... teach a man to fish and he will eat for a lifetime". If a questioner shows that he has at least tried to solve a problem by himself, he will surely get a solution or hints pointing him in the right direction, if somebody has one. Nobody here will do the complete work for someone else.

                          Exelioindia wrote:

                          at tht time thy cant search for an good subject

                          They should take the time (and its not much to find a more expressive subject), if they expect us to take the time doing their work.


                          "Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook

                          www.troschuetz.de

                          1 Reply Last reply
                          0
                          • T Tauseef A

                            hi all please tell me the query actually i have a table named history from which i want to get first and last record of a particualr person based on a date given in the query parameter thanks hello

                            hello

                            C Offline
                            C Offline
                            Christian Graus
                            wrote on last edited by
                            #16

                            Wow - you got a lot of responses and very little help.  That doesn't surprise me, you posted an message with a meaningless header ( EVERYONE thinks their question is 'urgent', what would the forum look like if they all said so ? ), you provide no info with which people can help you, and apparently you've cross posted this, instead of taking the time to post in the right place, with a question that shows you've tried to do some work yourself, and gives people the info they need to help you. I suggest instead of feeling discouraged, you think it through and try again.

                            Christian Graus - C++ MVP 'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert

                            1 Reply Last reply
                            0
                            • T Tauseef A

                              hi all please tell me the query actually i have a table named history from which i want to get first and last record of a particualr person based on a date given in the query parameter thanks hello

                              hello

                              D Offline
                              D Offline
                              David Domingues
                              wrote on last edited by
                              #17

                              It is important to give to your subject a meaning. It should sumarize your text. DAO provided nice function like .movefirst and .movelast. Nowadays i see no other alternative than making the query into a DataReader and read it from top to bottom. In addition, if your table has a sequencer to differenciate the key (main key built from a foreign key + sequencer), then you should use two queries with min and max to retrieve your records.

                              Contact me! Please feel free to visit my site

                              1 Reply Last reply
                              0
                              Reply
                              • Reply as topic
                              Log in to reply
                              • Oldest to Newest
                              • Newest to Oldest
                              • Most Votes


                              • Login

                              • Don't have an account? Register

                              • Login or register to search.
                              • First post
                                Last post
                              0
                              • Categories
                              • Recent
                              • Tags
                              • Popular
                              • World
                              • Users
                              • Groups