I 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 RepliesI am hosting a website on Windows 2003 server, IS6, MS SQL Server. I
have one ASP file I would like to run daily. How can I do it if I do
not have acces to OS's management (to use, for example, task scheduler)
and I do not want to include this page within other pages of the
website to be run (because that may slow down the page loading for
users)?
using classic asp and COMless scripting, is there a way for the asp on a server to automatically perform a function on a scheduled time, im thinking of things like database replication, clearing old data etc.
View Replies View RelatedI have an ASP page which checks some condition from database and based on that it sends mails to respective persons. All mail details is in SQL server. The page works perfectly fine.
What i need is this page has to be executed daily without the interaction of any user/administrator. Is it possible?
I need no send birthday emails every day. I need something to check everyday on my database for birthdays, but I don't have any components to do that and I dont have rights to install it on my webserver.
Is there a way to do it without installing anything? Only through asp?
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 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:
I'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?