i have a db where ± 15 users stores multiple second hand items with images. Now i wish to display on the openingpage a list of all users with 1 item + image. So far no problem.
But now i wish to change the order of the users every time the pages open.
How can i shuffle the recordset before i load the users in a array, or how
can i shuffle the array after populating with the users? Code:
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>
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:
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:
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?
I want to display data of a Random Member on my page.. and I did a search in these forums and I tried to do this:
[CODE] SELECT tblMiembros.*, tblDatosPersonales.*
FROM tblMiembros, tblDatosPersonales
ORDER BY rnd(isnull(tblMiembros.ID_APLICANTE) * 0 + 1)"[/CODE]
This doesnt throw any errors. but it always displays the same row... (first in database)
am I doing something wrong? am I missing something?
I have a client asking me about random images on his site, basically I am using the following code:-
<%
RANDOMIZE
Response.write("<IMG SRC='../gfx/bg-img0" & INT((3)*RND()) & ".jpg'>")
%>
Agreed its not the best code, but he is finding that the same image could be repeated like three times in a run.
I have an include file which displays the image, and the random script is placed inside that include. So when he is going from page to page this is where the issue lies.
Can anyone help me out here, is it even possible to have a different image load each time, and not have them repeating.
I am using random number to be used as a unique identifir. Since random numbers are in decimals I am using going to convert it into an integer and since I need to append this Id into my URL, I am converting it into a string. SO my formula looks like this.
CStr(Int((Highest-Lowest+1)*Rnd+Lowest))
S0 now every time a new record is generated would this formula generate a unique number for unique identification in the table. I can't see how it can do it. Say A user is assigned a random number; then another user subscribes so how would the server determines that the random value assigned to next user is not already assigned to any other user.
In case if this can't work (a unique ID for every user) then I'll stick to this very same formula and after the random number is generated, I'll check this number with the table in the database and see whether it's been assigned already. If yes, I'll request another random value, if not then I'll go with it. Is this the right strategy?
I have done random image display with the help suggestion from this discussion form. now I want to provide link on each image. i.e. all the images display randomly, should have different link. is it possible? if yes, how?
View Replies View Relatedis there sombody who can helpme witht he following, i am ''pretty new'' to
php and am looking for a script to show images randomly at a 10/ 15 seconds
interval. is there anybody who can help me with this or does know where to
find a good template script for this?
example:
When u see some sites ,
the advetisement images are changing ,
when ever the browser is refreshed...
.....
like tha i want to do that.....
I have the below ASP function to display a random image from a folder.
<%
Function RandomImage(strPath)
Randomize()
If Right(strPath, 1) <> Chr(47) Then strPath = strPath & Chr(47)
strPhysical = Server.MapPath(strPath)
Set objFSO = Server.CreateObject("Scripting.FileSystemObject")
Set objFolder = objFSO.GetFolder("C:Inetpubwwwrootpag-siteimages
andoms")
Set objFiles = objFolder.Files
For Each objFile in objFiles
strFile = LCase(objFile.Name)
strFiles = strFiles & strFile & vbTab
Next
strImages = Split(strFiles, vbTab)
If UBound(strImages) > 1 Then
RandomImage = strPath & strImages(Int(Rnd(1)*UBound(strImages)))
End If
End Function
%>
and this places the image in the HTML
<img name="Intropic" src="<%=RandomImage("images/randoms/")%>" width="211" height="158" alt="" />
but sometimes the script places a ._ before the image file name in the outputted HTML?
I'm afraid I have a technical problem here. Basically what happens is that I'm getting some random errors(like Type mismatch... etc) that shouldn't under normal circumstances occur. Then I connect to my server via remote desktop and Recycle the application pool on which my asp pages run. Errors then disappear
View Replies View RelatedI have a file where i want to call a random asp file using the "include file" statement. I know it can be done with images, but can it be done with other asp files? and how?
View Replies View RelatedI want to take 3 records from a database. The selection must first take any record marked as priority and then random records (so there could be 3 priority records and no more or 1 priority and 2 random etc)
My theory is to build a recordset filtered by records marked priority, and if there are less than 3, build a second recordset of all the other records.
Questions
1, how can I select random records form the second recordset, without selecting the same one twice?
2, OR, could I write a sql statement which would randomly select 3 records from my table
3, Or is they a way I could write a query (view) in Access which would do the whole lot for me (select the priority records and then random records up to 3)?
I set up a random code for people registering with my site.....
letters="1234567890abcdefghijklmnopqrstuvwxyz"
for i=1 to 16
Randomize()
rNum=Int(Rnd()*36)+1
code=code&mid(letters,rNum,1)
next
but for some reason it sometimes saves code as an empty string. When I register a fake name, ie zzz, it seems to work fine, but for some of my members is saves as an empty string.
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 RelatedHow do i produce a random string.anything from A-Z or a-z or 1-9 for the password.how do i do that
View Replies View RelatedI'm trying to sort a list of 10 people into two groups--RANDOMLY. I've gotten as far as to generate a random number and assign a name to it. I just need to know how to generate 9 more numbers, making sure no numbers/names repeat. Code:
View Replies View RelatedI have a DB with 10 items and an SQL statement:
"SELECT * FROM myTable WHERE Activate=true"
How do I make it so that every time the page refreshes it will display a random record?
I'm trying to get one of 3 files randomly included in an ASP page.
The thing is, when the code is printed out, it becomes a comment and it doesn't .. "include" the page..
Btw: I'm a PHP novice, and have no experience with ASP. I just looked up a few randomization tutorials and tried to get this working.
I have a problem creating random numbers. I basically have this
Randomize()
iRandom = Int(10 * Rnd + 1)
If I do not wait a few sec before hitting the page again it will create the same random number as generated a few seconds before.Any idea why it is like that? Another way to reprocess the "bug" is to just fit F5 few times in a row and you end up with the same number being generated. Its annoying and I need some help to "fix" it!
I have a script which show quotes randomly, Here is the code::
Code:
<%
Dim quotes(3), iNumber, iRandom
'Dim an array of 3 variables
quotes(1) = "This is quote 1"
quotes(2) = "This is quote 2"
quotes(3) = "This is quote 3"
iRandom = ubound(quotes)
randomize 'call random function
iNumber = Int((iRandom)* Rnd) 'get random quote number
Response.Write(Quotes(iNumber)) 'write output to screen
%>
How can i do a thing like:: (for example)
Show the Quote(1) on 10th September 2004
Show the Quote(2) on 11th Sep 2004
Show the Quote(3) on 12th sep 2004
Is that possible?
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....
I have the following select statement, but need to randomise the results to draw just 1 record at a time for banner displaying. How can I do it? ....
View Replies View RelatedI know how to generate random record from a database, the problem i need to overcome is like this:
1.If the user refreshes the page is a way i can control the randomized data from not repeating itself on display?
I'm trying to generate three random different numbers to display three images on a page without repeating them. I can't seem to be able to get them to always be different. There's probably some simple solution, but I can't figure it out.
Here's my current code: ....
I'm not sure, but this might be a question not right for this group.
Problem:
I have a sql statement that selects all rows with a sertain criteria, an display it on a page. What I need to do is to order these by random...
Is there any way to order by random?
example:
SELECT * FROM [table] WHERE [whatever] ORDER BY [random]
How do I do this?
So we use the Randomize function and Rnd to make a random number. Well my numbers can hardly be called random. So I have to ask is those two functions dependent on the web server? The web server sucks so much that it cant generate new Random numbers?
How Random is this?
Game1
2006-05-14 20:01:32 You picked a 4 of Clubs
2006-05-14 20:01:34 You picked a 4 of Clubs
2006-05-14 20:01:35 You picked a 2 of Diamonds
2006-05-14 20:01:37 You picked a 2 of Diamonds
2006-05-14 20:01:38 You picked a 2 of Diamonds
And then I added a Session function which takes the Number generated and make sure that it doesnt happen twice in a Row. But then it just switches between two values.
Game2
2006-08-09 13:55:12 You got hit by 11276
2006-08-09 13:55:16 You recieved 88515m³ Ice.
2006-08-09 13:55:21 You got hit by 11276
2006-08-09 13:55:30 You recieved 88515m³ Ice.
2006-08-09 13:55:37 You got hit by 11276
2006-08-09 13:55:39 You recieved 88515m³ Ice.
If I had'nt had the Session function it would simply be "2006-08-09 13:55:12 You got hit by 11276" 4 times in a row or something.
So I ask myself what is wrong? Is it the server or is it faulty programming on my side?
iOre = Int(30000 * Rnd + 5000)
If IsEmpty(Session("OreRandom")) = False then
DO WHILE Session("OreRandom") = iOre
Randomize
iOre = Int(30000 * Rnd + 5000)
LOOP
End If
Session("OreRandom") = iOre
How would you go changing a random number generated into a item drawn from a database with SQL....
View Replies View RelatedI am trying to generate a random number between 1 and 100 into a label, using c#....
View Replies View RelatedI need to come with some ASP code that can select a new record out of the database as a sort of "tip of the day". However I want it to do this randomly and daily, I do not wish to have to set a display date or whatever. I am going to use it on my website as a "tip of the day" section however I want to be able to input 100 records at one time and just let it randomly choose one everyday.
View Replies View Relatedi wondered what's a random func in active server page ?! i'm a newbie with ASP.
I'm finding a random func same "rand()" in PHP.