9 Random Records - Returns All But First Record In RS

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:

View Replies


ADVERTISEMENT

SQL Table Returns All Records

I have this sql query

SQL="SELECT title,body FROM cinema WHERE date_end > #" &date()& "#"

cinema is a table which contains announcements about cinema title,body (txt fields)are columns of my a table called cinema date_end(DATE/Time Field): is a date (DD/MM/YYYY, short format).This date shows when the announcements expire .But SQL returns all the announcements that the table contains even those that have already expired. Why??I cant find any mistake.

View Replies View Related

Crosstable Query Returns Too Many Records

I'm writing a work schedule application in ASP, and I am using an Access 2000 DB with the following tables:

WorkSchedule
--------------------------
| ID | Date | EmployeeID |
| .
| .
| .

Employees
---------------------
| EmployeeID | Name |
| .
| .
| .

Status
----------------------------------------------------
| StatusID | DateFrom | DateTo | EmployeeID | Type |
| .
| .
| .

I need to retrieve a list of employees, which are not scheduled for work between the given dates and which have no status (sick leave, maternity leave etc). The object is to see which employees are available for scheduling on the different dates.

The resulting table/recordset should contain one record per date per available employee (see example below). Code:

View Replies View Related

Random Record From DB

I 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?

View Replies View Related

Get Random Record

Is there a simple code I can use in order to get a random record from a access database in ASP ?

View Replies View Related

Random Record

I have an access database, and in a table is the field "names". There are over 100 different values in this field. I was wondering if it was possible to connect to the database and randomly select 1 of these names from the field and display it.

View Replies View Related

Select RANDOM Record

Ok here is what I'm trying to do. I want to grab a random record from a specific table. This is how I am doing it now:

x = 0
Set rs = Conn.Execute("SELECT Count(*) as total FROM [user] WHERE active = '1'")
If rs.EOF <> True then
total = rs("total")
End if
Randomize timer
randnum1 = int(rnd * total)
If randnum1 = 0 then
randnum1 = 1
End if
rs.close
set rs = nothing

Set rs = Conn.Execute("SELECT * FROM [user] WHERE id = '" & randnum1 & "' ")
Now that would work fine, BUT the id is a autonumber int of 1.

Now look at this example. Let's say I have 50 records, so I have the ID values of 1 through 50. Now I delete record number 46. So now my count goes up to 49. So the random number will pull up ANY number between 1 and 49, so if it pulls up 46 then BAAAM record can not be found.

There has to be an easier/more efficient way of getting a random record. I don't plan on deleting any records, but I just don't feel this is the best way of doing this.

View Replies View Related

Random Record Retrival

I want to create a record set for all the products in my database, i then want to randomly select some of them each time the page loads and display them, these have to change upon each refresh.

any ideas

my final problem i will post seperatly however, heres the score if any has any ideas.

ive created a product database of bikes, they have diferent sizes and colours. at the moment i am having to display each individual record. rather than having a single record and then on the detail page being able to have a dropdown menu or a choice of sizes there?

View Replies View Related

Random Record Selection

i have an access database with 5 records in and i need to show them in a random order every time the page is refreshed or reloaded. i've searched round and tryed no end of code but nothing seems to work.

i just need something really simple that selects a random feild from my DB. Sql = "SELECT * FROM tblmain ORDER BY RND()" - ive tryed this and it just shows the results in teh same order.

View Replies View Related

3 Random Records From DB

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)?

View Replies View Related

Random Records

I 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?

View Replies View Related

How To Choose A Random Record From A Database

ill have a database with 1 table and 3 fields:

ID FIRSTNAME LASTNAME

(the ID field will be the auto incrementing index)

there might be 10 records in the DB, there might be 10,000. i need to open the DB and randomly select a record (and then display the name, which i dont have a problem with)

how can i randomly select a record? im guessing id have to open a recordset and check the count to get the number of records, so lets say there were 100 records. i imagine i would have to generate a random number between 1 and 100....

View Replies View Related

Random Record Selection Error

I'm trying to create a piece of code that randomly selects a record from a database (providing the record has not already been chosen for any of the previous 4 sections).
Here is my code:

View Replies View Related

Random Record With SELECT TOP Does NOT Work

<%
Dim oConn, oRS, randNum
Randomize()
randNum = (CInt(1000 * Rnd) + 1) * -1
Set oConn=Server.CreateObject("ADODB.Connection")
Set oRS=Server.CreateObject("ADODB.recordset")
oConn.Provider="Microsoft.Jet.OLEDB.4.0"
oConn.Open Server.MapPath("temp.mdb")

oRS.Open "SELECT TOP 1 EMAIL_ADDRESS, r = Rnd(" & randNum & ") FROM TABLE1 ORDER BY r", oConn, adOpenStatic, adLockReadOnly

Response.Write oRS("EMAIL_ADDRESS")

oRS.close
oConn.close
Set oConn = nothing
Set oRS = nothing
%>

this gives the error: "No value given for one or more required parameters".

what i would really LOVE is for someone to fill in whatever required parameter im missing, but more important i would like to understand whats going on. there are people who go through life dumb and happy once something "works", but i need to understand how and why its working. even if this code did work, im confused with the SELECT statement (no, i dont have much SQL experience aside from basic queries). what is the "r = Rnd" line doing in the middle of the querie? how am i ordering by r?? also, i dont have an indexed, primary "ID" field in this databae. is that ok for this code to work?

View Replies View Related

DB Random Records From Array

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?

View Replies View Related

Random Pictures Records

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.

View Replies View Related

Random Display Of Records

I am doing a simple program which display random records to students.The student table has the following fields(Access Database) Code:

1.Studentid-Number
2.Studentname-Text
3.Class-Text
4.Ans-Text

and Question table as

1.Questionid-Number
2.Questions-Text

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:

View Replies View Related

Random Records Code

Here's what i need:

[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

View Replies View Related

Controlling Random Records

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:

View Replies View Related

Displaying 2 Random Records For DB

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?

View Replies View Related

Random Database Records

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.

Is there any quick and dirty way of doing this?

View Replies View Related

Selecting Random Records

i want to select some records from my database by random. i want also to set a limit (limit=9).

View Replies View Related

Select 5 Random Records

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?

View Replies View Related

Weighted Random Records

Do you have any idea about weighted random records ? (for MSAccess AND SQL Server) Also can I get weighted random records just by SQL Language ?

View Replies View Related

Selecting Random Records From 2 Different Databases

I have a tough question that i ca't get over it for all the day.
I have two different news tables. I can't get any of them and list.

Bu i want to do something different. I want to get both and randomize them and list them.

for example,

1. news (from the 1st db)
2. news (from the 2nd db)

etc.

is that possible, because i couln't find any solution for this.

View Replies View Related

To Retreive 'unique' Random Records

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.

View Replies View Related

Selecting Random Records From Database How?

The following code should select the specified number of records randomly from the database .....

View Replies View Related

Show Random Records - New Set On Refresh!

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.

View Replies View Related

Display Records In Random Order

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

Anyone has a solution to this problem?

View Replies View Related

Returning Random 10 Records Form A Database?

How can I do it?

View Replies View Related

Pick Five Records At Random From Db And Rotate Them Weekly

I need to pull five records randomly from a database, and display them on a web page. These need to change weekly.

Is there a way to do this in ASP?

View Replies View Related

Records After 10 Record

Is there any way to read the records after every 10 records
from database. I dont mean paging recordset here, but I need
to do that to generate table cells.
What I mean here is for example if we have 50 records in a table,
how can I get the every 10th record say, 40th, 30th, 20th and 10th record only .
Is there something like skip command in SQL or ASP?

View Replies View Related

Populate A Popup Window With Clickable Records From An Access DB And Upon Clicking, Populate A Selectbox On The Original Webpage With The Clicked Record

We have an ASP site that hits up an Access database of categories of
products and products. (e.g. Categories = Napkins, Tablecloths;
Products = 20x20 Napkins, 21x21 Napkins, 54x54 Tablecloths, 60x60
Tablecloths)

We currently have select boxes that when you select a category, it
populates the next select box with the proper list of products (i.e. I
select Napkins as a category, I get a listing of the Napkins)

We would like to put a clickable link before each of these select
boxes that would pull up a pop up with links from the records from the
proper table.

(e.g. I click the categories link and a popup with html
anchor tags of Napkins and Tablecloths appear) I click on the Napkins
anchor and it populates the Categories Select box with Categories and
Napkins being selected.

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved