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?
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
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?
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.
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?
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.
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.
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?
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:
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:
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?
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:
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:
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.
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]).
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
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:
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:
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.
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:
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.
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:
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.
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:
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?
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";