Freeze Table Headers.
There is what i would like to do, I have a page that pulls all the
hours for our staff over a given period calculated them and reports
back on 15 different colums and is aproximatly 500 individual rows of
data for a table. Now as you could imagine that is a night mare to look
at for anyone, i have done a few things to make remeber which columns
are which however a simple Solution would be to the top row, or rows i
define stay constantly at the top as your scroll down.
This is classic ASP and not ASP.NET, I can find alot of resources for
ASP.NET but nothing for ASP.
I have considered Frames, but who really wants to mess around with that
ad there are alot of controls at the top of the page that manipulate
the data.
Also i have heard of using JavaScript or CSS, Has anyone achieved this
before?
View Replies
ADVERTISEMENT
i try to freeze the head row of the html table (like in excel) scrol only the rest of the table! how to do it?
View Replies
View Related
we have a requirement to freeze the column and row column heading... so that when the user scrolls to the right the first two columns ( I refer them as "row headings") will stay and the remaining columns scroll left and when the user scrolls to the bottom the first row stays ("column headings")and the remaining rows will scroll up.. This can be easily accomplished in EXCEL by freezing the itersecting cell... How can the same be accomplished using HTML tables /ASP code.... Is there any Active X control available that can be used to accomplish the same?Our technical env is ASP and Oracle DB
View Replies
View Related
i have got the code that read the data in the Database and display inside a Excel file, but how can i use ASP code to set certain column inside that Excel file to become a freeze panel?
View Replies
View Related
Just like to know benefits of adding headers. Why we add them.
View Replies
View Related
If I want to have a username/password dialog in my page, how can I add
http header in ASP for username/password dialog? I want to hardcode
the username/password in my page and check the authentication.
View Replies
View Related
I am getting the following error on one of my asp pages.The HTTP headers are already written to the client browser. Any HTTP header modifications must be made before writing page content.I think I understand what the problem is, but what I am curious about
is I only get this problem when the page resides on my web server (Windows 2K3).
However when it resides on my development machine (Windows XP with IIS 5.1) I do not have this problem. The browser is the same in both instances. Is there a setting somewhere in IIS that is responsible for this different behavior?
View Replies
View Related
If I have an ASP file that sends less than 110 I believe its 110 characters IIS will, at the top of the document, add some header info about the server and page. This
happens in every web directory I have. If I take out the <HEAD></HEAD> section of the page, this information is not added.
View Replies
View Related
When I catch HTTP headers with the Live HTTP Headers plugin in Firefox I get some information that I'd like to catch with ASP: Code:
View Replies
View Related
Is there a way to add a header to a page that will change what text the
browser displays in the address field?
For example, say I point my browser to
http://www.domain.com/request.asp?a=1&b=2.
I would like IIS to send back the content generated by the page
request.asp, but would like the address is in the browser to read
"http://www.domain.com/request/index.asp"
Is there any possible way to do this? It seems like this should be possible.
View Replies
View Related
I'm having trouble showing images stored in a SQl server database in asp3.0. The images are inserted into SQL server using a access front-end. Access adds ole headers to the image field. These headers prevent images to show in asp. Is there a way to remove these headers using asp?
View Replies
View Related
I need to put headers and footers in my word doc from asp and cannt get it to work. Found this code on the net Cannt get word to open the external file. Any ideas Code:
View Replies
View Related
I have one table that has a course's ID number and the titles of the units for that course, with an ID for a set of units.
Then I have another table that has the units for all courses within it, this table also has the CourseID they belong to and the ID of the Unit header that they belong to. My problem is trying to get the header displayed first then all the units that belong to that header, so it looks like this: Code:
View Replies
View Related
This is the scenario: I am making a wizard composed of several steps, each
step being a form with the post method. The first steps may be completed
whether the user is logged on to the website or not. But from a certain step
on the user must be logged on to complete the wizard. What I do is post the
data gathered so far to the logon page; the logon page is essentially an ASP
page with an HTML logon form that posts to itself. Once the user logs on he
is taken again to the wizard, to the step where he left off.
Right now I am using the HTML form / approach on the
logon page: after the user is authenticated, the asp page builds a form with
the "saved" data, pointing to the next step of the wizard, and uses the
onLoad event of the body tag to submit the form. And this does what I
intended.
But I believe there must be a more elegant way to do this, and I suspect it
involves setting headers directly using Response.AddHeader but I don't know
how to do it. Am I right? If so, how to do it?
View Replies
View Related
My WebApp has to do some database work in page1.ASP Because this may
take a few second, before Page1 connects to the database, it doeas a
"Response.Buffer=false", and pumps out a bit of javascript which
displays a progress bar. Code:
View Replies
View Related
I'm getting an error:" http headers already written", when I redirect back the page I came from.
I writing an on-line store app. The page 1 lists products, desc, price in a table. Click on a product, it adds it to an XML shopping bag and , thru a link, jumps to page2 that prints everyhing in the bag so far. At the bottom of page2 is a TYPE SUBMIT button that takes you back to page 1 for more shopping. The form for the button uses Code:
View Replies
View Related
I need to send headers to login to 3rd party portal from ASP is there an example available. I also would like to have a ASP script that reads all headers and displays them.
View Replies
View Related
How to get/set and send the HTTP Headers(user-defined) coming from another domain/site]
In one SMS gateway project i need a great and urgent help from u all. There,the Service Providers sending the data thru "HTTP Headers" (For ex.sms-Id,sms-source [user defined]).
So i need to get and parse the name value pairs, and need to respond/send the same way as coining the "HTTP Headers" (For ex. sms-Id,sms-destination,sms-msg [user defined]).
View Replies
View Related
Any ASP functions can get the HTTP request and response headers?
View Replies
View Related
I have aproblem to transfer a data from table x to table y based on id. Its mean when 2 table have same id all data table x must move to table y. I don't know which command need to use is it insert into or update?
<%
Dim conn
Dim rs
Dim MYSQL,MYSQL2
Set conn = Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.Recordset")
Set cmd = Server.CreateObject("ADODB.Recordset")
conn.ConnectionString = "DSN=prmm;UID=administrator;pwd=sa"
conn.Open
startdate=request("tarikh1")
enddate=request("tarikh2")
MYSQL = "SELECT * FROM table_x where paymentdate between '" & tarikh1 & "' and '" & tarikh2 & "'"
rs.open MYSQL,conn ....
View Replies
View Related
I am trying to display the content of a Table called
'Order Detail' directly from the database (e.g., Northwind.mdb). I have the following commands:
Set tableSet = Server.CreateObject("ADODB.Recordset")
tableSet.Open table_name, DB_name, adOpenForwardOnly, _
adLockOptimistic, adCmdTable
where, table_name = ''Order Detail" Or
table_name = 'Order Detail' Or different variations.
I always get error on the second command with the following message:
Syntax error in query. Incomplete query clause
which I believe because of space in the Table Name. How can I resolve this issue? (working with file or table name with space)?
View Replies
View Related
I have a table with many txt boxes which i have inside a form with a submit button to an update page which adds all the details to a db. The problem is i have a another table inside the first e.g. table 2. i want to be able to update table2 by clicking a second submit button that would update it. Is it possible to have a form within a form or how can i do it??
Also i need to update the entire table in one go. For exampple if i have 3 records in table2 i want to be able to update them all by clicking the one update button. Code:
View Replies
View Related
I have the following code but this is inserting manually. I want to make a query from table 1 and automatically enter the records into table 2. What needs to be modified? Code:
View Replies
View Related
Have an app which dynamically creates table rows depending on records, these can be several hundred (don't ask). Hence a very long page at time. Each row includes a hyper link to a new page, and a link back to the original page.
Is there any method (maybe via js) where on leaving the second page l can redirect the browser to the table row the end user clicked on? Hence the bookmarking. Can do this via Visual Basic on the desktop app, but can't work it out on the web app.
View Replies
View Related
I have a table produced with names across the top and services down the left hand side with boxes for numbers for people who recieve services then the info is written into a table in an access db. That works fine and here is that code:
View Replies
View Related
I have two tables. Table A has 20,000 records, Table B has 2,000 records. Table A is what needs to be updated from the data in Table B. Only some fields will be updated and of course, only some records - both tables have the same field as a ClientID so matching up records should be easy.
Anyways, been a while since I have used ASP to work on things like this but would like to work through this one. I understand the process I believe, it is just how to make it go on to the next record once it has finished updating the first.
Basically, I was thinking of having it set up to reaad the top record from Table B, update applicable data in Table A. Delete that record in Table B. Move on to the next.
View Replies
View Related
The redirect page is giving error.
UPDATE insertanswer SET passages = "God created" WHERE [id] = 1;
UPDATE insertanswer SET passages = "there be ligh" WHERE [id] = 3;
Response object error 'ASP 0156 : 80004005'
Header Error
/wheelofgod/pageing4.asp, line 76
The HTTP headers are already written to the client browser. Any HTTP header modifications must be made before writing page content.
View Replies
View Related
Hello I have a page for registering users.
I am reciveing this error:
The following errors occured:
- An error occured. -2147217904 : No value given for one or more required parameters.
there are students and teachers. therefore I have 3 tables one for logins and one for staff and on for students.
I have a form designed to capeture the need information.
in the code I am runing an if and elseif statmetn to determin the tables. I then insert the userid and password into the login table.
then i enter the remaining information into ither the staff or student table. what i am trying to do is select the perimary number that is generated as the userid and passeword are enterd. and add this to the second table. Code:
View Replies
View Related
I want MS Access 2000 database column of table 1 = column of table 2. This is what I was doing: Code:
View Replies
View Related
I have a database app that I'm building and displaying my results in a table.
I need to know for anyone who can help how to have one row say red and the next row say green for instance.
View Replies
View Related
I have menubox that shows all the datbases in a directory. When the user highlights a database, the chosen value gets stored in an Application variable(its a control panel).
Id like this Application variable to populate another menubox with a listing of all the tables within the selected database. However, I'm having trouble getting these values and google hasn't been much help. Code:
View Replies
View Related
Can i, using asp code, create whole new table in my DB?
I have clients on my site and each client buys itmes and i want to store the purchase list.so i thought that each client has its own table like member "John" has "JohnOrders" a table reserved only for him..
Which means i need to create a table using code each time a user register.
am i doing this right beacuse i've seen people have just one "ORDERS" table but i cant understand how the stuff all the info about all users into 1 table?
View Replies
View Related
how can i get the table row index so that i can highlight the entire row when the user click on the row.Below is teh code i have tried but failed... cos it only hightlight a single cell.
var oSelected = null;
if (oSelected != null)
{
oSelected.bgColor = "white";
}
oSelected = window.event.srcElement;
oSelected.bgColor = "lightskyblue";
View Replies
View Related
