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

    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