I am displaying a table that contains 36 columns and 20-40000 rows.The first row is a header.When i scroll the page down the header disappears(anyways this is a fact).Is there any way in which i can keep the header/first row constant when i scroll the page downwards or sideways for n number of records? I am using Access as the Backend and the front scripting is by ASP and connecting thru ADO.
View RepliesI am trying to display all the records in my database when I click a button that I made. Can anyone show me how to do that? Right now I have no code for this. I just want a button on my page, so that someone can print out a list of all the records in my database and have it for reference.
View Replies View RelatedHow do you display all your fields from an SQL table in a web page - BUT make them clickable to make any changes???
E.G. I have a users table with firstname and surname in, but I wish to amend the surname??
I know the code to amend the changes, but dont know how to display the records and make them clickable!!!
is there a code or query that i can use to display everything but the first record?
here's my sql:
sql = "SELECT * FROM Hotstory ORDER by DateTime DESC"
what i'm using to display:
Response.Write("<a href=' " & rs("URL") & " 'target='_blank'>" &rs("Title")&"-"&rs("DateTime")& "</a>")
I was wondering if anyone would be able to help with the following;
I have a database which contains a list of products with prices and a set of variables.
I'd like to store the product prices as session variables....
I found a displaying records of a Database in a HTML table,but i want the opposite. I want to insert the content from an HTML or ASP page and no a TXT file into a Database.
View Replies View RelatedI have a database that has a column for an expiring date. How would I query the database to display only records whose expiring date is greater than the current date? For example, if the current date was 6/16/2004 and there were these expiring dates:
6/1/2004 6/15/2004 6/17/2004 6/18/2004 then only 6/17 and 6/18 would display.
I am building an asp webshop and have an accesss database with all the products. I can create a catalogue page using repeating regions to display all the products no problems but I want to customise a bit. Just say I want to display products 3, 7 and 10, what I have been doing is to created 3 seperate recordsets in Dreamweaver with the filter ProdID = Entered Value 3, 7 and 10 respectively.
I then bind the product name, price, description for each of the 3 products to the page. My questions - Is there a better way of doing this especially if I have a catalogue page with many products and many recordsets. I want to build the pages in this manner so it is like a static page but with a database content (not with repeating regions).
Is it possible to have just 1 recordset and pass the values 3, 7 and 10 through it and then bind the results to the page seperately (How do I code it?). If this is possible is it a more efficient way of working than having a seperate recordset for each product. Is it a drain on the server to have to deal with say 10 recordsets or it OK?
my search engine shows 14 records per page and displays the total number of pages with that search criteria.
if there are 140 search results it shows 10 page links at the bottom of the screen ( 1 2 3 4 5 6 7 8 9 10)it also does the same thing if there are 1400 results 1 2 3 4 5 6 7 8 9 10 11 12 13 etc etc up untill 140)
i am trying to stop this and only allow it to show 10 page links at a time then next, for example if there are 12 pages it would look like this 1 2 3 4 5 6 7 8 9 10 >next> (then the next links. i would like this to show 10 pages each time.
I am working on exporting my results to excel and running into an issue where I wasn't getting any records but have since now been able to see some records now....it appears to only be showing records that I have added thru the web interface to the database, it's not showing the records that I imported (SQL database).
My results.asp displays all the records properly, it's just not working on my export to excel. I've looked at the data in the SQL table but I don't see anything unusual. Has anyone ever run into this before and have any clue on what I can check now?
I want to be able to display records inputed from Monday at 12:00am to Sunday at 5 pm. Every week.
So far, I can display records for the last 7 days, but How can I be more specific?
Any Ideas??
I've got some code that displays public event info on a page - unfortunately, it seems to have stopped working today for some reason and I don't know why (there are 2 records in the database that match the criteria, so I know that's not the problem: Code:
View Replies View RelatedI have a search page which has radio buttons for two search options (location, price) and checkboxes for one other option (type). The radio buttons reference the "general" table in my database, and the checkboxes reference boolean records in the "cuisine" table.
My task is to display, on a subsequent page, records that match the two radio buttons selected as well as each checkbox. Code:
short n simple question: I want to display the number of records returned from a search. Code fragment as follows:
// d/b retrieval SQL code
SQLCode = SQLCode
Set objRS = objConn.Execute (SQLCode)
// displaying the returned results
Do While (Not objRS.EOF
<< spit out records >>
objRS.MoveNext
Loop
Now, is there an instance of objRS I can call that will just display how many records were returned? I tried objRS.Count on a longshot, but that didn't work
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 RelatedSay i have 100 rows in a table and i make a query:"Select * from table", i will get all the 100 rows displayed, but what i want to do is to display 20rows in a page and then have 'Next' and 'Previous' links to navigate through the records 20 by 20. This is in fact exactly as in this forum where only 20 posts are displayed sorted by most recent ones and so on.
View Replies View RelatedI have created a website using dreamweaver mx 2004 and access 2000 for the database. i want to display the results of a recordset in a grid with a different record in each grid. the grid will be fixed in width and the cells will be fixed in width and height but if more cells are required (eg more records to display) then they will be added to the bottom of the grid. at the minute its not working. This is a screenshot of what im sort of after.
View Replies View RelatedI'm displaying records from an Access db and would appreciate advice on the most efficient/easiest way of displaying a field.
The db holds a list of furniture products where there are a number of ranges. Each record has the range name against it but I've only put the range description against the first record in that range Code:
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 currently have entries in my dbase with time stamps. Does anyone know how I would display only those records with the time stamp that reflects a particular day. For example I want to display all records from today which would be 8/23/2004 on the page.
Im assuming this has something to do with the Date () function but i dont understand how it could incorporate it into code.
I have an ASP page where I want to display the 3 most recent records within a database using a SQL query. The problem is that my page which output the results is only showing the first most recent record and not the two past ones aswell.
Am I right in thinking that might be related to the 'loop' function? I know that my SQL code is fine as I have previewed the results from the code and they are correct. Code:
I need to know how to display a new post above an old one:
here is my script to display the database (news):
Code:
<%@ Language=VBScript %>
<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Provider = "Microsoft.Jet.OLEDB.4.0"
Conn.ConnectionString = "Data Source=" & Server.MapPath ("database/news.mdb")
Conn.Open
Set Rs = Server.CreateObject("ADODB.Recordset")
Rs.Open "SELECT * from news", Conn, 1,3
do while not rs.EOF
Response.Write rs("name") & " " & rs("when") & "<br>" & rs("news") & "<p>"
rs.MoveNext
loop
set Rs = nothing
set Conn = nothing
%>
I have a set of code for displaying information from the database. However now i can only view text with no pics... what can i add in order to see pics together with the text and what data type should i put for the pics in the database? Code:
View Replies View RelatedI am building a website where users can place advertisements with images. I have decided to place the images in an Access database to ensure the right images are matched the correct advertisements. My problem is that I can retrieve all of the data from the table which holds the photos (eg, filename, file size, content type) except for the actual photo itself. When I try to download the photo or press the hyperlink to display the photo all I get is the square with the red cross. I do not get any error messages.
Does anyone know why this is happening. My code is below:
I am trying to display images on a results page which have been saved in a Access database as BLOBS. I also trying to resize the images at the same time so that each record on the results page has the same dimensions. I have 2 include files on the webpage to resize the images, a processing ASP page to download the images and the syntax to make it all work.
My problem is that I am new at ASP programming and having the problem of putting all of the pieces together. I keep on getting an error message on 1 particular line and have no idea on how to fix it after many hours of trying different ideas. Code:
I have a page that allows users to sign on and then have access to the site. What I need to do is to have them sign on and see selected (tables) or data that is in the database.
I need some help. How would this be written. Unfortunalely the only book I have on the subject is asp.net. Code:
I have just recently use record paging, i now have a problem the way the records are displayed.
I have a table header with each header name of records to be displayed, and each individual record should be displayed directly underneath each other PHP Code:
I am using MS Sql server and asp pages together.The problem I am getting is not knowing what data type to best set my data to.There is a part # set to nvarchar which seems to work great.
THen an Inductance, currently set as float. My inductance values show as 1.5 and 5, 3, 3.2, etc etc, however I need it to show 5.00 and 3.00, 3.20 etc.the inductance is measured in mH and another column called DCR is measured in Ù. Is there anyway to get this symbol to show in my table on my asp page? or do I need to enter the symbol into the database table?
i would like to store images in a database so that when a link is clicked on a html page a new page opens with the image taken from the database. I have heard that you should only store the image path name in the database. how i would do this and then display the image on a HTML page.
View Replies View RelatedI have a database on my server that houses information regarding trouble tickets. I know how to write asp page to take the inputted info from a form and put it in the database but what I would like to know if someone could show me or point me in the direction of a good tutorial that shows me how to list all the content in my database on a web page.
For instance I would have a page titled, view all tickets, then on that page would be a listing of all the tickets and their information with buttons to add, delete or update ticket.
I have an Access database set up with a number of text fields and a hyperlink field which references a different image per record. I am trying write ASP code to retrieve allt his data and images onto a web page. I have the data but the images are causing a problem.
The code I am using is as follows:
For the data: ....
I can display information to a webpage from a database and handle the connections etc. My next task is a bit more complicated for myelf. Id like to have a page the pulls information from a record set and displays like this.
down one side
the container numbers
along the top
the products in the containers
the information in the middle would be the amount of product that came on that container.
Im just wondering how the best way to setup my database would be, and the best way to setup the asp webpage. (oh) nearly forgot, it has to repeat the information till all the records are finished but i guess that gos without saying.
This code has worked in the past on this same page, and for some reason it doesn't want to calculate the numbers anymore. Anyone see anything that is out of whack?
Basically I am taking the input numbers for each field and adding them up on one column, then taking the totals of all of those columns and adding it up to display as an overall total. Code: