|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
September 26th, 2003, 06:00 AM
|
|||
|
|||
|
create random words (letters and numbers) inside a column
hi all
 ,i need a suggestion: i have a table in which there are 2 columns filled with 'NODATA' word. now i want to update those cloumns with random letters and number, they never must be the same (these columns are for UserID and password). the lenght is from 6 to 10 chars. anyone have suggestion? i thougth to use Excel to create random words and then update the DB, but i also don't know how to create words which are never the same  thanks all! Nick
|
|
#2
September 26th, 2003, 09:03 AM
|
|||
|
|||
|
Hi Sushy - You will be glad to know that there is a nice and simple solution to your problem. Excel will do the job for you. To save me writing in detail, follow the link at the bottom for a tutorial on how to do it. They also provide a downloadable template which should make your life a lot easier, although you may have to tweak it a little to get the exact number of letters and numbers that you want generated. Good Luck. URL
|
|
#4
March 5th, 2004, 10:58 PM
|
|||
|
|||
|
generating random sequence in asp and oracle as database
hi....
we have made quiz program using asp and oracle8i as database. We have to generate random question and randomize there option each time we use. But in our coding we r getting random questions each time but we are not getting random options for them. so please so the solution for that The coding for that is as shown below: <!--#include file="DataConnect.asp"--> <% Response.Buffer = True %> <html> <body> <br> <% Const adCmdText = &H0001 Dim query query ="select * from form " Dim rs Set rs = Server.CreateObject("ADODB.Recordset") rs.Open query, objConn, 3, , adCmdText Dim intRnd Randomize Timer intRnd = (Int(RND * rs.RecordCount)) rs.Move intRnd Response.Write (rs("question")&"<br>") Response.Write (rs("option1") &"<br>") Response.Write (rs("option2") &"<br>") Response.Write (rs("option3") &"<br>") Response.Write (rs("option4") &"<br>") Response.Write (rs("option5") &"<br>") Response.Write (rs("option6") &"<br>") Response.Write (rs("option7") &"<br>") Response.Write (rs("option8") &"<br>") Response.Write (rs("option9") &"<br>") Response.Write (rs("option10") &"<br>") rs.Close Set rs = Nothing %> </p> </body> </html> Do please care to reply thank u
|
|
| Viewing: Dev Shed Forums > Databases > Database Management > create random words (letters and numbers) inside a column |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
