Assign A Random Number
I have this simple application that I put together using ASP. It has an html form that submits to an access database through a simple ASP file. It’s a survey form basically. One of the departments here wants to get some feedback from their students and in return for filling out the survey they will be entered into a drawing for a gift certificate. The catch is that the survey is anonymous. What they want to happen is each person is given a unique number at the end of the survey and they will pick one of those numbers randomly to see who the winner is. How can I possibly do this? I am stuck.
I think I may know what I need to do:
Pull a unique number from a database and post it onto the HTML form near the submit button. Notate on the page that the user write the number down and when they hit submit it is inserted into the database along with the record. I have absolutely no idea how to do that.
The HTML form submits into the database using this "add.asp" file:
Code: ....
View Replies
ADVERTISEMENT
I have a web page that submits a form to a database. Each time a form is submitted, I need to assign it a unique case number and insert the case number into the database along with the information entered in the form.
I am able to insert all the data into the database, but am not sure how to generate the case number to insert. Is there a way to do this based on number from the previous entry, like just add 1 to it?
View Replies
View Related
I am trying to generate a random number. I am using randomize and then rnd to return a decimal number between 100 and 120. This will give me a longitude. I am doing something similar to generate a latitude.
I created this on a page which refreshs every minute. I put these points into a map and they are showing up in groups of straight lines. Since rnd is time based will refreshing every 60 seconds return similar numbers?
View Replies
View Related
trying to get a random number from 0000 to 9999, is there an easy way to do this? i'm using this for a unique filename and want it to be 4 digits from 0000 to 9999.
View Replies
View Related
x = ROUND((0.9+1.005*RND()-0.4),1)
y = INT(y * x)
This is what I'm trying to acheive:
- "Y" has a preset value between 1-100
- "X" should be random between 0.8 and 1.2
- "X * Y" is the final value of "Y" as a whole number
What I'm struggling with is getting the value of X to be random between 0.8 and 1.2....
View Replies
View Related
How would you go changing a random number generated into a item drawn from a database with SQL....
View Replies
View Related
I need to create a random number, or even better, and random combination of letters and numbers, to be used as a type of security key for changing a user's password on this site i'm working on. Basically, the user fills out this form which sends them and e-mail w/ instructions on how to change their password (pretty basic, lots of sites do it).
In the e-mail of course is a link which links to a page with querystring values that include their customer number, the action (reset password), and hopefully this "key." What I'd like to do is have the key written to a database when the e-mail is sent and then deleted when the password is changed. So, how can I generate this key. I think I can take care of the writing to/deleting from the database.
View Replies
View Related
I'm trying to create a random number that has to solid letters at the beginning followed by 8 random numbers (DN13523781) This number also can't be in use alreaddy which means it can't alreaddy be in a colum called number in the database.
I can do the letters followed by one number, but I can't figure out how to get 8 numbers in a row without getting the same ones over and over(88888888)
I also don't know how to check if it's alreaddy used in the database.
Also does someone know how I can prevent the same number from being produced before it can be added to the database at an other location/pc.
I'm building an online store and I want to give people an order number when they order something. Code:
View Replies
View Related
Does anyone know of any parameters for either of these functions?
Say, if I wanted only numbers between 1 and 100?
Code:
<%
randomize()
response.write(rnd())
%>
View Replies
View Related
How can I generate a unique random number?
View Replies
View Related
I've got a realy wierd server problem - everytime i ask for a random number using rnd() i get 0.7055475. This problem just appeared the other day. I hadnt changed any server or os settings, however i have recently recieved a 6 part xp pro update... - has anybody come accross this before?
View Replies
View Related
I want to display a random banner from a selection of 5 banners. So if number = 1 then display baner 1 etc. My code is as follows:
bannerCount = bannerRecordSet.RecordCount
Dim bannerSelected
Randomize
bannerSelected = Int(Rnd * bannerCount)
The above code works although it never seems to generate the value 1, ie 2-5. Also when I refresh the page sometimes a random banner is displayed and other times I get an error. Is this because I am generating a value outside 1-5? Code:
View Replies
View Related
Does anyone know how to code in a very simple random number generator?
Basically, my ASP site is linked to an SQL d/base. What I want to do is have a "Random quote of the day"... the R.N.G. should spit out a number, and that number references the random_quote_ID in the d/base and spits it out.
View Replies
View Related
I've tried using javascript to rotate an image upon reload, but I can't get it working, so now I'm trying it with asp. I don't understand why this won't work. Any ideas? Code:
View Replies
View Related
I want to create a random number where it concatenates with the "day counter" as explained below and name of the person inorder to generate a unique id.
by day counter i mean. there are 365 days in a year and today is the 18th day of the yeat. so the counter generated shud be 18&Smilesmita. How do i do this in ASP ?
View Replies
View Related
I know this is not a php forum, but i've been given a task to create a form that requires a unique number every time the form is loaded. The form has been created but they have php on their site. windows would be in 3 weeks time but they want the form asap. The field is a hidden field since i've never looked at a php code page b4 i need some help.
View Replies
View Related
I have used:
set typ = server.createobject("Scriptlet.TypeLib")
to create a random string of 36 characters. However, is there a way to
create a random string of digits in the length I request? Perhaps a string
of 20 digits with a few asterisks thrown in for ease of typing?
for example:
4515-81301-75454-45136-1
Would this be reated with RegExp? And how?
View Replies
View Related
not after code, just thoughts, suppose i'm generating a random 8-digit pin number for our clients, first i'll be checking against the db to see if it already exists before assigning it. what i might do for that is getstring all of the exsiting pins at the top of the script and just keep performing an instr until i get a 0. (i dont expect to ever go above a thousand clients for this system and hopefully my initial number will be random enough that these checks are for backup/redundancy assertion anyway)
but anyway, the main problem is: i dont want to generate a random pin that is one (or maybe two) digit(s) different from another,. i.e.
11111111 is too close to 14115111 and much too close to 11111811. 11121111 is right out of the question as it can be entered as a typo, as is 11111411 because of the numpad
so i'm after thoughts on how to perform that check, i suppose if i went with the "big string of all pins that went before" check i could perform a number of regex searches on the string. i.e.
my pin is 12345678 and i dont want ony to be one digit different so i'd check the string against .2345678 1.345678 12.45678 and so on. think i just answered my own question, anyone else got any ideas? especially for the two digit case (dont want to be performing 36 regex checks do i!)
View Replies
View Related
However, what I want to do is include a request.querystring("ID"), so that IF an ID is defined, eg ID=3, , it will display the relevant (not random) information. I've tried this every way I can think and get type mismatches, etc etc. It's probably really simple but I can't see it.
<%
limit=3
redim link(limit)
redim image (limit)
link(1)="xxx"
image(1)="image1.jpg"
link(2)="xxx"
image(2)="image2.jpg"
link(3)="xxx"
image(3)="image3.jpg"
randomize
random=int(rnd*limit)+1
%>
<center>
<a href="<%= link(random) %>">
<img src="<%= image(random) %>" border="0"></a>
View Replies
View Related
I just wanted to know whats the best way to generate 50 or say X amount of number at random without having to repeat any of the previous number...
so far I've the following:
[VBS]<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<%
function RandomNumber()
dim theRandom
Randomize
'RandomNumber = Int((upperbound - lowerbound + 1) * Rnd + lowerbound)
theRandom= Int((99 - (0) + 1) * Rnd + (0))
if (theRandom<10) then theRandom = "0" & theRandom
RandomNumber = theRandom
end function
%>[/VBS]
and then I've this in the body of HTML doc: Code:
View Replies
View Related
We have the need to have a random token (a 16 char alphanumeric field) to be used as the key for one of our SQL tables. I have created a random token generator, however after only 3 months in production, it appears that we had an instance where a token that already existed in the tables was created. There are 3810 records currently in the database so it isn't like there are billions of records there.
I contacted an old college buddy of mine who is a mathematician, and he claims, assuming that random really does mean random, that the chances of getting a duplicate token are 1 in 79.5 septillion (79,500,000,000,000,000,000,000,000).
So my conclusion is that this was either a complete freak of nature occurance, or my random generator isn't really all that random. Here is the code behind how I am generating this: Code:
View Replies
View Related
itemname = "select sw_item_itemid, sw_item_item , sw_item_lowquantity"
itemname = itemname & " from sw_item"
itemname = itemname & " where sw_itemcategory_catid = "&catid&""
set displayitem = objconn.execute(itemname)
if displayitem.bof and displayitem.eof then
counting = counting + 1
("countnotitem" & counting ) = filtercategory("sw_cat_catlabel")
how can I assign countnoitem with a digit ?
View Replies
View Related
I got a session variable for username. Now, i want to assign this value to the textbox.
HOW WOULD I ACHIEVE THIS?
View Replies
View Related
I put in a request recently for a script which would return 9 random numbers between 1 and 30. I got a reply which gave me this script, which writes them out.
It works great, but in the loop that writes them out, instead I would like to assign each value to a variable, such as img1,img2,img3,img4, etc. in the for loop, is this possible, or should I write out 9 statement lines, each assigning a value to a variable. I intend to plug the values into a java applet which rotates images.
Come to think of it, I could just put each value of the array right into the img tag, no? <img src="images/<%=random_number(1)=>.jpg"> Code:
View Replies
View Related
I have a code somewhat like this:
Dim screenSize
If Request.Form("resScreen") = "1024x768" Then
screenSize = "big"
Else
screenSize = "small"
End If
this works fine, but when this page is reloaded, it doesn't
find this Request.Form("resScreen")
(this form is also on another page, which explains why) but can I store this variable "big" the first time it loads somehow?
View Replies
View Related
For Each objitem in Request.Form
if request.form(objitem).count > 0 then
For intLoop = 1 to Request.Form(objitem).count
Objitem = request.form(objitem)
End if
Next
server error in line of "end if"
I want to collect the values from the form and assign a variable to each value field
View Replies
View Related
I am using Visual Studio I have created a website using HTML code and the pages look fine I now need to do the following.
I have a picture where if some one clicks on it it then needs to query an SQL database and return on a different page the results. How do I assign a sql database to my website and how do I connect to it ?
View Replies
View Related
I would like to ask izzit correct that assign a variable in asp and store the value select from XSL list at below: (in my asp page) Code:
View Replies
View Related
I'm retrieving the screen resoltion with javascript code, but i can't assign the correct value to asp. the response.write is displaying zero (0) for screen res., although when i do a document.write in the javascript part, then my screen res. is 1004 ...
View Replies
View Related
If I assign VBScript server side variable a to javascript variable x, it is fine.
<%
Dim a, b
a = 10
%>
var x = <%= a %>;
alert(x);
But if I do the other way around, then it has 500 error. any ideas??
<% b %> = x;
View Replies
View Related
My ASP page contains the following VBScript code:
<%
zipCode = Request.Form("zip")
%> <br>zip: <%= zipCode %>, rf: <%= Request.Form("zip") %>
When I enter "abc" into the "zip" field on the form, I get the
following output:
zip: , rf: abc
Why doesn't the first statement assign the "abc" string to the
variable "zipCode"? What am I not seeing?
View Replies
View Related
I'm setting the title attribute of an input box to assign a tooltip. If I assign title the value "Agent does not exist", when hovering over the textbox the tooltip will only display "Agent" it's the same with all my tooltips (only the first word is displayed).
View Replies
View Related
I'm having a bit of a problem and I was hoping someone could help me out. I'm trying to create an interface for manipulating historical stock prices obtained through finance.yahoo.com. I need to make a recordset contain the data of a CSV file that Yahoo returns, but the catch is that I want to pass the data along by pointing the recordset to the URL of the CSV files on the Yahoo server.
Yahoo creates its CSV files dynamically through the querystring of its URL (see below), and I would use inputs to my interface to manipulate the URL for specific ticker symbols, dates, etc. I guess the simplest example is that a user could input a ticker to my interface, the recordset would somehow "call" the URL for the correct data, and then that data would be in the recordset, where I could manipulate it, before returning the information back to the user.
I'm just stumped on how to get the CSV data into the recordset on the fly, just by calling the URL.
The following link is an example of what Yahoo does. Manipulating the querystring changes the ticker, date range, and level of detail. You can also change the table.csv to table.txt and return the actual data in one big text file. Code:
View Replies
View Related
