I know there are plenty of threads relating to 'random' records, but non of the code samples seem to return random results each time I refresh the page; or don't show any results at all? The ID numbers for my recordset are not necessarily consecutive numbers (some items may have been deleted). I simply want to feature 2 or 3 random news teasers on my home page WHERE feature="yes". I guess I need to call 3 random id's, and keep looking until a record is returned? I would also like to change the number of 'teasers' displayed via another database table - I can do this later, but the code has to accommodate a flexible way to change how many records are returned.
Here's the Access table:
news (TBL):
id
title
shortdescr
longdescr
feature
If you have a possible answer for me could you please provide sample code and spell it out clearly.
I'm running Windows 2000 SP4 with the latest IIS and all its patches. I'm working on designing a shopping cart using ASP. The problem I'm running into is that I get random errors when I hit the reload/refresh button. Is this a common issue? The problem seems to stem from my use of the ODBC connection. I'm using a set of commands like this:
'Create command object and recordset Set cm = Server.CreateObject("ADODB.Command") Set rs = Server.CreateObject("ADODB.Recordset")
' Specify the system DSN path cm.ActiveConnection = "SpiritPOS"
cm.CommandText= "SELECT * FROM table_master"
Set rs = cm.Execute
'Clean up Set rs = Nothing
Does anyone see any apparent problems with this? I seem to get some errors stating there is a problem with ActiveConnection sometimes, too. Do I need to set this object to Nothing as well?
I 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)?
The table is full of records; many are duplicates.
What would be the correct syntax to show ONLY those records appearing more than once?
A. Please do not use Stored Procedures B. Please do not use User Defined Functions C. Please do not use Variables D. Please do not use Temporary Tables E. Please do not use Views
I have read 10000 opinions on returning random records and I am more confused now that before I started. I have a small access db that will contain 20 or so rows with 3 or 4 columns. I like to return a set of 6 distinct rows and display the columns in html. I have seen response.write and loops but can't I throw the 6 random rows in a array and pull the data as I need it in the page? Examples?
I have this page where I want to display 3 random pictures in a vertical table. Each picture represents a record in an Access database. The field "picname" holds the name of the picture (e.g. "pic1.jpg", "pic2.jpg", etc). Each record has a unique ID. How do I go about selecting these 3 records? I want the pictures to alternate everytime someone enters the page or refreshes it. I found a couple of javascript options, but they only choose the picture from within a folder, and I need to be able to link the pictures to each record.I don't know if I made myself clear enough.
Now What i am trying to do is , when the first time is student is login,he wil be shown a random record from the question and his answered wil be stored in the Ans field of the student table with column separeated.
The he will be redirected to the same page with one new question.This question should not be in the Ans Field, and must be randomly generated.I am using this code.But this not working. Code:
[vbs] "SELECT * FROM Articles WHERE Category = 'Reviews' and SubCat = {RANDOM CATEGORY} LIMIT 5;" [/vbs]
Now, I think the last post on the thread I read said the guy could make an Array and just pick a random item out of that...and that makes sense in my case, listing all the Categories and then picking a random one.But, I don't know how to do it! I don't have much experience in arrays
i am currently working on an online test tool using ASP. Now, the questions would be generated randomly from a database(access), so two or more candidates will not have the same question. There will be one question per page. Now, i have successfully generated the radom questions from the database.
But i have a problem which is:
1. When i click the next link to go the next question, my code displays the question on the previous.
2. Also, when i click on the previous link to go back to the previous question my code changes the question from the previously answered to a new question. Code:
Im looking for a very simple and small script that will display 2 random records for a database, but i havnt found one yet. Can someone help me on this one?
I'm trying to create a portion of script that would select x (variable) number of random records from a table.
in PHP, I could do this pretty simply with a line like, "select * from table order by rand() limit x", but the solutions I've seen so far for asp and access involve things like 40 lines of code, selecting the entire contents of a database, creating temporary tables, etc.
I want to select 5 random records from my database..I tried to suft the net and foundout this sql
SELECT TOP (3) Question, Choice1, Choice2, Choice3, Choice4 FROM Question
But when i tried to execute,i t always gave me the most top 2 records. why?Is this sql statement woring?How can i select 5 random records from the database?
I am using the following code which works if there is records, if there is not it shows blank screen, how do I make a message show if there were no records found? Code:
I have been using this script which basically works fine, with on hitch. I populate a recordset from a database. Then, use the total number of records as a UBound.
I then want to display 9 random records. I get my 9 random images, but for some reason, if I do a sort by ID on the database, the lowest numbered ID file never comes up in the list. Here is my code: Code:
I have to develop an online quiz on my website. the site is developed in ASP. i have a access database of the questions, the multiple ans.s and the correct ans. every quest. has an unique id.
i want a way by which any 10 'unique' quests. will be selected from the database everytime an user takes the test.
I Have searched the forum but have no solution to this problem.
I want to display my records in a random order. I loop through my records so I don't know how many records will be displayed. I dont want to count the records and then use the TOP statement. I'm looking for a better solution.
Set rs = Server.CreateObject("ADODB.Recordset") rs.Open SELECT test FROM testTable WHERE testId = 1, objConn Do While Not rs.EOF Response.Write "<b>" & rs("test") & "</b>" <- I want theese records to be displayed in random order rs.MoveNext Loop
I'm trying to only show 10 records at a time. I have the first 10 records showing. The problem is that when I click the Next button I get an error message: ADODB.Recordset (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another. Also different people are going to search for different things so there will always be a different amount of records returned each time. I can't figure this out. My code is:
I have a page with 2 frames. The first one has a link that loads a page in the second frame. This page has a button on it. When the button is hit, the page does some processing and loads another page in the same frame (the second).
I use ASP and response.redirect or javascript in the onclick event of the button to do the redirection. When I refresh the page by clicking the button on the browser (IE), the second frame becomes empty. Please note that the src attribute of the frame is not set.
If I set the src attribute of the second frame to some asp page and then navigate to another page inside the same frame, when I refresh the page, the initial asp page is loaded in the frame regardless of the asp page currently loaded into the frame.
It seems that when you refresh the page, the frames are reinitialized no matter what pages are currently loaded in the frames.
I solved the problem by redirecting to the main page in the top frame, passing some parameters and resetting the src of the frame to the desired asp page. Thus, when the page is refreshed, all the frames are properly refreshed too.
I have an ASP site that uses frames two frames. (yes I should be using include files, but we started ou using frames so we have been stuck with frames.)
When I get a page expired warning (I am not caching pages) and a user clicks refresh from the menu bar the user is taken back to the home page! The home page is a frame with a top frame that is repeated on each subsequent asp pages
The lower half of the home page is a login screen.
After login the next page is shown in the lower half of the frame. Refreshing within the individual frames is ok.
But when the Refresh from the menu bar is used the home page is returned any ideas why?
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.
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?
The problem concerns 2 tables, cart_products and cart_shoppingcart.
Cart_products contains all the product data (eg, prices, product's key name, etc), but most importantly, it contains the quantity of stock (prod_quantity) for each item.
cart_shoppingcart contains all of the user's items in their shoppingcart, including those that are part of an (customer) order; these have the order_number to differentiate from those that aren't in any order (their Order_number is 'no_order', the others have the order number).
Now, what I want to do is this:
For every item in the order (ie, every entry in cart_shoppingcart that matches the username and order number), take the quantity (x) the customer is ordering, then take the quantity of stock remaining (y), then subtract x from y to create the new stock level (z) and update the appropriate record in cart_products with z (all this with SQl preferably).
I was thinking of using a Do while loop, but realised that it wouldn't work as I'd have to use several SQL statements and then I'd run into a problem the minute ASP reads "objrec.movenext".
I'm trying to pull the last 5 records from my database.
<% j=5 rs.MoveLast While ((j>0) AND (NOT rs_article.BOF))%> ''Execute HTML and data insertion here
<%rs_article.MovePrevious j=j-1 Wend%>
Everytime I attempt to run this code, I recieve an HTTP 500- Internal Server Error. It tells me no more than that. I know that my connection settings are OK because when I move forward through the database (first five records), the code executes without error. And yes, my Cursor type is Dynamic.
Alternatively, I would also like to know how to add new recordset to the beginning of a database rather than the end.