I have an Excel file and NEED to show the data onto the webpage using ASP. The data shown on the page varies depending on the ID entered in the webpage.
Right now i Import the data into Access and then show it on the page with the JET engine.
I have three sets checkboxes in my .
Checkbox a,b,c with different names
If a user selects checkboxes in set A. He cannot select any check box in set B, but he must select in C. If a user selects check boxes in set B. He cannot select any check box in A and C. If a user selects check boxes in C. He cannot select any check box in set B, but he must select in set A.
i would like to show a summary of data in our database. it's more like a report showing things like totals for 2006, 2005, etc. what is the best way to do this and make it efficient?
i have a report right now consisting of about 20 queries i've been slowly putting together. when i run all of these on the page, it takes a good 15 seconds for it to generate the figures (and this is on a dual 3.0 ghz xeon machine). does anyone have any suggests on an efficient way to accomplish this?
My code show no error but the record cannot appear. My code =
if request("tarikh") = "" then
tarikh = Date()
else
tarikh = request("tarikh")
if isdate(tarikh) = false then
ralat = "Sila masukkan tarikh dalam format dd/mm/yyyy"
tarikh = Date()
end if
end if
sql = "select * from audit_trail where cstr(tarikhlogin) = '"&tarikh &"' order by masalogin desc"
set rs = conn.execute(sql)
response.write sql =
select * from audit_trail where cstr(tarikhlogin) = '04/02/2005' order by masalogin desc
Storing record have no problem but this code cant display any data.
how to show excel data in asp?
View Replies View RelatedI was just wondering if there is a variable or procedure for getting all the POST data sent to a page. I don't want to have to handle every case for the POST data, I just want all POST data sent to the page to be outputted automatically.
View Replies View RelatedI have two pages in my Web system that works in such a manner:
1. Page A allows users to input data into the web form
2. Page B displays data from Page A and other additional info
Page A contains only data inputs of HTML types TEXT and SELECT.I'd like to have an "Edit" button in Page B where it allows users to be redirected to Page A to view all of the previously entered data (and edit the data from there).
Can I do this without using "Request.QueryString" or "Request.Form" commands? I can't use "history.back()" or "history.go(-1)" commands, because with them, Page A is shown with empty data in it.
I have a strange problem. I have to show demo presentation in CD. In
this presentation record will be show from database. But we dont have
to install the database. any body can see the cd and can search the
data. how it is possible because the databse will not be installed in
CD and computer also.
I have announcements down the left hand column of a site and want to display contact info if it is available - if it is entered into the database. So I only want to display a space plus the data if there is data in the field. Code:
View Replies View Relatedis there a tutorial around anywhere that tells you how to change images on the page when a user selects from a select box
View Replies View RelatedI have a database of songs listed as Title, Artist,Description, DiscNo and TrackNo with a seperate record in that format for each song.What I would like to do is search through them for the Description, show only the disc numbers in the results.
This I can do easily. Where I am lost is that I only want each individual disc number to show once. If I moveNext through the recordset, it shows the disc number 15 times per disc. Is there a filter I can add to limit this display?
Is there any way to input .asp code so that a specific element isn't show on a page? example: I don't want a menu on a specific product page, but I want it on all the others. Is there any code to input into a site wide includes file to implement this?
View Replies View RelatedI have a ASP application which let user to download their reports in pdf format. I would like to show a progress bar, or change the mouse cursor to a hourglass while the user is waiting for the file. How to acomplish this? In the asp code, I use response.BinaryWrite to create the pdf file directly to the browser. How to detect when the file is ready?
View Replies View RelatedI create a page which will show me all the Regions from the table "RegionTable" where I have no information (empty fields) in on of the fields RegionDescription or RegionRank.
It is to make my content managing easier. I do not want to see those records which contain all the necessary info (region description and rank).
I tried the following code, but it does not work
qry = "SELECT * FROM RegionTable WHERE RegionDescription="" AND RegionRank="" "
error message is:
([Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1)
I have a query that displays values from a db.
The problem is that the value displays like this:
R 6.5
instead of like this:
R 6.50
How would I get it to show the full value?
ok, well what I have been having some trouble with is to show the person character name like this:
Welcome, 'Username' <-- Here I want it to show the persons username from the database.
I am using a Cdonts e-mail script that e-mails the results of a form to my address. It currently displays the data like:
Amount: 12.00
Percent: 2.00
I need it to say:
Amount: $12.00
Percent: 2.00%
How can I get the $ and % symbols to be included in the e-mail template without getting a 500 error?
Here is what I have:
Body = Body & vbcrlf & "Amount: " & request.form("amount")
Body = Body & vbcrlf & "Percent: " & request.form("percent")
I've tried a few diffrent ways but here is one example:
Body = Body & vbcrlf & "Amount: $" & request.form("amount")
Body = Body & vbcrlf & "Percent: " & request.form("percent")%
I've tried using / before the symbols and "" but everything I've tried keeps coming up with a 500 error. How can I add these symbols to my template so they will show up in the e-mail?
I know we have this thread somewhere, but I can't seem
to find it now
I want to show the first 100 chars of a string, but
I don't want a word to be cut in half at the end, it must
show the whole word then and go a bit beyond 100 chars.
How do you print out all of the contents of an array if all you know is the array name?
FOr example, I am looking at pre existing code that looks like this:Code:
scartItem2 = session("cartItem")
arrCart2 = session("MyCart")
For Z = 0 to scartItem2
cartfields2="&Email=YES" & "&processed" & z & "=" & arrCart2(cProductid,z) & "&quantity=" & arrCart2(cQuantity,z)
What I need to find out is if there are ANY other elements other than cProductid AND cQuantity in this array and what their names would be so I can add them to the code.
I know that I could print out the values of the above by simply doing this:
response.write(cartfields2)
But how do I find out if there's a cFeature or any other element?
i have very strange error.i can not see some of the asp pages on my browser. when i
look from view source, all the source is there but browser does not show anything, just an empty page.
im looking to find out how can i make, when the pointer is over a link or picture without clickin on the link an small textbox(something like that) open and show the content of that link. for example in this forum when you go over a thread you can see the content.
View Replies View RelatedI have a ASP page that when a user clicks a link it uses a DLL to stamp a .pdf with a watermark and then display the .pdf in there web browser using the Adobe Reader. This all works fine.
if a user views a pdf and then modifes it if they click the link again it still shows the old version of the file. They have to hit there refresh button to show the changes. How can I make it so my page always displays the lastest version of the PDF and not what is in the cache?
i have a website that users log on to. On one of the pages is a form. What I want to do is only show a certain part of the form for specific users. The way i want to do this is by using their username as a 'show if' command in dreamweaver. What I currently have is this
<% If Session("MM_Username") = "union" %>
all data to be hidden shown is here
<% End If %>
But this doesnt work for me! Any suggestions on how to show this properly?
I want to show the currency like that xxx.00. In my database, i already set the type of column which i want to show to currency. However, the currency can no be shown as my expect. It only show like that XXX..
View Replies View RelatedIn one of my ASP page, I want to show the visitor's IP. Who can I do that?
View Replies View Relatedhow to show popup windows (html format) and the size is depending on the size of image?
View Replies View Relatedi m displaying only 4 lines of my main news..and after that there is one link more...if user click on this link then the detail of this news will display....but problem is i want to show the rest of content of this news at same place..i maen to say after clicking more it will display my main news content in place of 4 line and more link Code:
View Replies View RelatedI have some problems with how to show error message. Now I have two asp pages such as page "A" and page "B" and When I click a button on page "A" then the process will check conditions from page "B" ,so if there're some errors it will redirect to page "A" and show error message box.
I would like to know that how to show the message box?
where in i could show in a dropdown the database table name as i would like the whole databse be searched according to a specific table?
View Replies View RelatedI have clustered IIS 5.0. It is working on a fail-over clustered model (Active-Passive), with one node as a preferred owner and the other only as a failover. I make the changes to IIS from one node, and then synchronize it with the other node.
All of the data is stored on a shared external disk array. I have around 50 websites. All of them work fine and are accessible. Recently I have found out a confusing problem though. Code:
I have a problem. I tried my best but could not solve is. I have a
page where user selects the folder name from a drop down list. It takes
user to show.asp page, where it how all the files in the folder and
also user can click on them and download them. If I select name of the
folder from the list, on show.asp it shows all the files and their
link.
When I click on the link then most of the file which has long
name and have space in their names wont be hyper linked. For example if
files name is Virus Control.vsd or file name is INCIDENT-ACCIDENT
INVESTIGATION REPORT.htm. If I click on them it will say "The page
cannot be found". Code:
I have table that list some companies, when the user selects the company a form comes up that list all the company info, where they can view it and also update some info. One of the fields they update is a drop down list. I'm having trouble populating the menu with the value from the company it comes up blank. Here is the code:
View Replies View RelatedI have a problem . I have a table of field name ,roll_name, age
I have to show name and roll_number in combo box list.
<select name=id1>
<option value="<rs(0)>"><%=rs(0)%><%=rs(1)%></option>