how to make an effective invitation number in activation emails

[netsooz Amir Hamidi]

Hi folks I'm just trying to complete a registration sector and for that I've done evrything except for activation email. I know the algorithm and how to do that but my problem is where I can't get a beautiful activation number. I want to write and sql query by which I can select from 3 beggining letters of name, 2 final letters of last name and month and day of registration date and ... (which are enetered in registration form) . So I can make a complicated activation code. you know what do I mean! my problem would be solved only if you tell me how I can write and handle that sql query for selection. Thanks alot.

Proper Prepration Prevents Poor Performance! h

[Christian Graus]

I would use GUIDs for codes to send for activation. SQL generates them natively.

Christian Graus Driven to the arms of OSX by Vista. "! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums. I can do things with my brain that I can't even google. I can flex the front part of my brain instantly anytime I want. It can be exhausting and it even causes me vision problems for some reason. - CaptainSeeSharp

[N a v a n e e t h]

URL Object Serialization: An Effortless Approach to User Account Confirmation[^] is a great article on the subject. :)

Navaneeth How to use google | Ask smart questions