-- I have a database with user records (name, photo, etc. etc.)
I want to use asp to generate (on the homepage) a series of 4 randomly selected 'user records' from the database -- say just the headshot photo or name from the database.
In addition to the recordset being randomly generated (i.e. our of about 50 records, only records 4, 18, 23 and 26 are displayed) I need to MAKE SURE they are not duplicated (i.e. out of the 50 records, records 4, 18, 23 and 23 -- where the last two are duplicates).
Is there a way I can pull this off and how do I go about it exactly?
how can I do a "select" action and select lines randomly, for example: "select * from items where views>100" and to choose from that 5 objects randomly.
I've got a csv file with names, addresses, emails, etc. I've been asked to randomly select a name from a csv file. I've found plenty of RandNum examples, but I'm not sure how to apply it to these names. Can anyone point out a sample I could use?
I want to select a random record from a table within my Access database, however I am running into problems. When the page is executed, it always shows the same record. Code:
I am trying to get an access random image script to simply update the content from a folder on my server...... Automaticlly without having to go into the database to add a the new image and location, i just want it to randomly select one. is this possible?
Still working on my soccer database, I have a list of 100s of teams and want to give users various ways of accessing the information. One of those methods would be via a drop down box which would have
A-F G-M N-T U-Z
If a user selects a-f how could I write my sql statement so that it pulls out the relevant teams, in alphabetical order, that begin with the letters a-f?
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.
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 display work request records from a db table into a .html table dynamically by cycling through the db table until RS.EOF.
To the right of each record displayed I have two checkboxes, "chk_dev_accept", "chk_dev_sendnotif". These are the only editable items on the page.
"chk_dev_accept" is clicked by the developer to assign the work request to his/herself. "chk_dev_sendnotif" is clicked if the developer wants to notify the customer that the status of the job has changed (optional and automatic - I don't have a problem with this part).
Upon clicking the "Update Record" button, I want the records with the checkboxes clicked to update.
The db record fields that would be updated are: "dev_developer" (The developer that will do the job, read from a cookie) and "dev_proj_status" (changed to 'Assigned'). These two fields should update when the "chk_dev_accept" is clicked and form submitted. I want the developer to check as many records as he/she wishes.
My problem is I'm not sure how to code that <input checkbox....> tag, and then, how to take that checked value to select the appropriate records to update.
I nwant to pull out the description form the table orders where the first letter is A. I dont have any script tried, because I dont have a clue, I was told it's simple to do though.
strquery = SELECT description FROM orders WHERE ...?
I'm building a form select from a record set and then using the selected result to call another record set. This a maybe a dumb problem but it has me stumped. The first record always has a comma after it, theres no comma in the database and no comma in the code. Can someone tell where this comma is coming from? Code:
I am working on a site with MS Access and ASP that needs to have data selected from a listbox, populate several span fields. I can do it with JavaScript but the array data is hard coded, I want the data brought in dynamically from an Access database. Here is my JavaScript code:
Does anyone know if it's possible to use the records stored in an Access 2002 database to log users into an ASP.net page? I'm trying to code it in vb.net but im not sure how it could be done. Basically I think I need 2 text boxes on the ASP page where the user can enter their name and password.
I then somehow need to retrieve the name and password from fields in the database (using ADO.net i think) and compare them with those entered by the user. If they match then I want to load another page, and if not then I want to display a message saying login details are incorrect.
Any help on this subject would be much appreciated- the fields i have at the moment are called 'User' and 'Password' in a table called PERSON.
I need to insert many records from one table of one db to another table in another db. I have done this, but I have a problem in the case that if an IDNumber is unique in the destination table.
How can I, In the case that record (IDNumber) already exists, to skip that record and continue normally with the rest of records. Not to update that record but to skip that record.
How could I create a random filename for a single-use download? So, if a user was to download a file from a site it would send them a unique filename that could only be used once. That link would not be available after the download completed.
I am relatively new to this generation of variables in ASP. I am unable to proceed from here. Can somebody advise?
Challenge :
I get number of participants in an exam, from a sql statement and stored into a variable called headcount.
After that, I am using the following to initialize randomly generated variables. For example if there are 4 students in the class, I intend to get student1, student2, student3 and student4, all of them initialized to 0.
For j=1 To CLng(headcount) Eval Execute("student" & j & "=" & 0) Next
Now we are trying to find out question wise defaults in the test. I have a for loop that does traverse through all the questions in the test. As I go question by question, if there is any failure I would like to increment the errorcounter of that participant.
i need to choose a data, randomly, in a database based n category (cat1, cat2, cat3, cat4, cat5, cat6). i only need to show 1 data of each category in the html page. kindly inform where to find a sample tuts for this.
I have a Windows 2003 Server Web running 5 web sites. Every few days, the ASP pages stop responding. There are no events in the event log. The HTML pages are still served successfully. These pages have no database interaction (others use MySQL). I have to restart IIS in order for the pages to work again. I haven't been able to find anything about this issue on the web. Has anyone seen this before? Any idea how to fix it?
I have a form that I want to use to add records to a database. The form and database have only three fields. Trouble is I get a "page cannot be displayed" in IE. The database and the form page are in the same folder. Here's my code:
I've got this bit of code that prints out the data from a database to a webpage. Some of the entries in the db are blank whereas others aren't. The code checks if its blank and moves to the next record. If it's not blank it lables it and prints the data stored in the db cell.
The prob that it won't print out the db info in the else statement. If I get rid of the if statement completly, it prints every cell including the blank ones. I'm drawing a blank on how to fix it. Could be because I've been looking at it too long.....
I am workin on a project at home,asp vbscript website, n im having problems with inserting records into my database .. I am using a dsn-less ADODB connection, but it seems that some kind of security is preventing me from writing in the db.. i can access n retrieve, but NOT WRITE.. ive tried disabling every type of security, still doesnt work..
Does anyone know how i could print multiple records from a database using a series of check boxes on a webpage? i.e it prints all the records that have been ticked?
I want to know the number of records in my database when performing a query by sql. I am getting -1 as number of records.
<% connectme="DSN=hotel" sqltemp="SELECT Count([All Rooms].Engaged) AS CountOfFREEROOM FROM [All Rooms] GROUP BY [All Rooms].Engaged HAVING ((([All Rooms].Engaged)=False));" set rstemp=Server.CreateObject("adodb.Recordset") rstemp.open sqltemp, connectme, adopenstatic howmanyrecs=rstemp.recordcount response.write howmanyrecs & " records in<br>" & sqltemp rstemp.close set rstemp=nothing %>
my project is on an online hotel reservation. I want to have the number of rooms available each time the page loads.
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.
what the best way to update a ms access database from an asp page is.I have a db with 3 different tables,these tables are bound to each other via the relationships.
On my asp page,I want to create one page where the user would enter in information and hit submit.The problem I have though is that how do I have only one button that will update information from 3 or more tables all at once?