I've tried using javascript to rotate an image upon reload, but I can't get it working, so now I'm trying it with asp. I don't understand why this won't work. Any ideas? Code:
I am using dreamweaver MX to connect to a microsoft database with the typical data stored such as name, address etc. I gt this information to displlay via recordsets and thats all good.
BUt im having trouble exporting the data from the database inot an XML document. I know I can do it on Acces itself but i want to be able to generate it using ASP. How do I do this?
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.
[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 using the following code to Query information from my db table. The problem I have is that it displays the whole table rather than displaying 5 random results by ProductID.
<% objConn2.open strconn2 Set objRS2 = Server.CreateObject("ADODB.Recordset") objRS2.Open "SELECT * FROM Products", objConn2
Do While Not objRS2.EOF Response.Write ":: <a href=""productsDisplay.asp?ProductID=" & objRS2("ProductID") & """>" & objRS2("Product_Description") & "</a><br>" objRS2.MoveNext Loop objRS2.Close objConn2.Close Set objConn2 = Nothing %>
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 have a ASP/vbscript program that generates random passwords. The problem is I need to insert those passwords into an Access database of 327 clients. I have the random password program generating the 327 passwords, but have had no luck inserting them. Code:
(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....
obviously in standard asp. and i'm not even sure where to begin. I currently have it set up for a random quote every time a user refreshes the site. This was no problem. Any help or if you can point me in the right direction.
I am trying to retrieve images from the database and display them in a random order. The order of the images is supposed to change each time page is refreshed.
Below is my code, I am using an array to store the images but the images are not displayed for some reason. Any help would be appreciated.
<% Dim rstResult Dim strSQL Dim img(100) imgID = 0 set rstResult = Server.CreateObject("ADODB.Recordset") strSQL = "sp_sel_TilesByType 'O'" rstResult.Open strSQL, strConnect
I am trying to write an array of random numbers to a database. The array part is working fine, but when I go to update the dataabse, it inserts the last value of the array into all the fields in the database .....
Dim MyValue,sqlRandom Dim arrayRandom(8) for i = 1 to 8 Randomize MyValue = Int((100 * Rnd) + 1) arrayRandom(i) = MyValue response.write "<p> Array Value:" & arrayRandom(i)
We have some ASP code in a database, say something like Code:
<%=session("strFirstName")%>
If we ever call that, instead of resolving to the value of the session variable "strFirstName", it shows the whole line of text "<%=session("strFirstName")%>".
The question is, how can we get code like that in the database to generate on the page along with the rest of the ASP 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.
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:
Does anybody have code to add a "Database Last Updated...." line on your webpages that are generated from an MDB? There is simple ASP and javascript for 'page last updated', but the code that I have found just detects the time when the page was generated, which is every time the page loads since it is querying the database.
Im looking for code that queries when the database was last updated, then displays that info on the page.
i just wanna a simple code for ADD, Find, EDIT, REMOVE asp code to manage a simple database contains only products name and its details and picture to be viewed in web site. is there any?
I have a two pages. The first is a data entry screen (which saves the form data to a DB) and the second page displays the text that was inputted on the previous page( pulled from DB). Is there a way to insert <%=date()%> into one of the text areas and have it be processed on the second page when that text is pulled from the database?
I downloaded an online quiz application from the Internet. The application works fine but and after I answer questions, it does not produce any results and display it on the screen. It gives an error message saying the database is read only.
I think there is a problem with reading the database to retrieve the correct answers. It is an MS Access database. But I don't know what it is and how to solve it.
I'm showing page contents text coming from database, normally the contents are plain text or in html formatting... it works fine.. but I want to add ASP code within page contents, as well... i did try but it dispalys ASP code as it is in the output...
is there any way to execute those asp code lines coming from database...?
How to create a database paging with the code i have. im trying to do database record paging, im not quite sure how i had tried couple of open source code but cant not get it to work with my code:
Can anyone help me find a code for Database Paging? I have seen some of it but its very hard for me to read, its too advance. Need to have a code with beginner to intermediate level.
i have built an interface for template making. i am using a simple form with a text area and submit button to save the code, i want to show in a template page, into the database. I also use the same textare to view any code saved to the database for a specific page.
THE PROBLEM - i have to save a
response.write("<textarea..............></textarea>") the minute i paste it into the textarea it saves it fine but shows it wrong as if once it reads the </textarea> in my saved code the main page 'closes' the main textarea . i.e. the rest of my saved code is shown as part of the page - and its not pretty!