Can any1 help me on how to do this? That is.. I need to send the user his password if his username exists in the DB if not then I would need to let the user know.
Is there a server behavior out there somewhere that would do this?
I have made the query to look up the given username an its password. thats it I´m stuck <img src=../images/dmxzone/forum/icon_smile_wink.gif border=0 align=middle> But trying to learn! <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

Ingi Orn Gretarsson

I pretty much know the mailing part.. and the part where i check to see if the username exists (with the query) the problem mainly is on how to do this if it doesn´t exist

Ingi Orn Gretarsson

Well, the code for detecting if a recordset has no data in it is:

if rcdRecordset.BOF or rcdRecordset.EOF then ..............

That's why you'll see UD code where when displaying recordset data, it'll pre-empt it with:

if NOT rcdRecordset.BOF or NOT rcdRecordset.EOF then .......

try the magic-beat extension suite, there are some handy ectensions in there like redirect if recordet is empty... (i lbelive)

you can get it over here... it's really handy..

www.magicbeat.com/mb/magicsuite2000.asp

Matthijs
----------------
UD4/WY2K/IIS/ASP-VB
www.chaps.nl

Thanks guy´s.. I will try this..

Ingi Orn Gretarsson