hi its very urgent

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

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:

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

Stefan Troschuetz

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

quiteSmart

Stefan Troschütz wrote:

Your answer was quite fast

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

Guffa

Please don't cross post.

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

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

quiteSmart

Stefan Troschütz wrote:

I don't think so

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

V 0

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

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

ednrgc

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

Dan Neely

SELECT username FROM cpPosters WHERE clue = 0 returned: ghumman63

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

BedHead

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

- I want to know.

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 0

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.

Stefan Troschuetz

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

Christian Graus

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

David Domingues

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