I have a site that currently collects info from a form. The info is then emailed to an elected email address. It occurs to me that perhaps there is some way of collecting the information and sending to a spreadsheet that would keep updating. THe information is all word based (as in mostly yes or no answers).
View RepliesWhen the output is in excel format for an ASP page, some of the values displayed get transformed to decimal numbers instead of their true values. How to solve this problem? When the output is in plain html, the values are displayed correctly. Note that the values to be displayed are in TIME format. How can i change the format of excel cells in asp?
For output in excel when the form method is POST, no parameter values get posted to the other page. But when it is GET the values get posted. Y? I even change use request.querystring for GET but the result is the same.
I create an excel chart by using the asp, but due to my selected database is quite large until the chart shows the data in a messy way and it is too tight even the name for the unit also cannot see.
Is any way to seperate it? i mean show it in another way for eg show it for 10 data in a page and can click on a "next" to link another page, or create another drop down list to select for how many data to show in a page? and how to write that ?
I have a asp page which will get the data from multiple tables (with
functions and procedures)and display data in HTML tables <TABLE> on ASP
page.Is there any way we can create a excel file from the output of this ASP
file.I know how to export if this information on ASP page is coming from single
query from a database table.
I am developing my application in ASP and there is a requirement to save the output in Excel. One option is to use Content-Disposition header but it prompts user for saving. As per our requirement the output should get automatically saved.
View Replies View RelatedThe website sends users through a series of questions. When they are done they can view there results and open a printer friendly version, but my boss wants the user to have the option to send their answers to Word or Excel so they can either change their answers or the layout of whatever. Is there a way to do this?
View Replies View RelatedI have written an ASP script that connects to a database and runs a stored procedure and displays the results in text format ...using the <TABLE> tag. But I would like to
have these results appear in a NEW Window in an Excel format. I used :
<%
Response.ContentType = "application/vnd.ms-excel"
Response.Buffer = true
Response.Clear
%>
This opens up Excel in the same window and usually does not refresh my data ...even though the stored procedure is actually running on the database server.
i have created a quotation page where customer could view the quotation details and i just thinking to allow customer to print his/her quotation as a reference. all the data are fetched from db and displayed in the table.
View Replies View RelatedI am in the process of building a small Intranet application. Iam using ASP along with access backend on IIS 5.0.
Info will be sent from an HTML form, [an inventory report] various drop down lists, text boxes, etc.
This info from the form is then added to the mdb, but an administrator needs to pull the same form back to add further info to complete the form, [cookies?] and finally it gets exported to excel format and saved on the server. Also an admin page needs setting up so "admin" can confirm when some reports are completed and when others need completing, maybe this could be the way the first part of the form could be stored and pulled back from ? Could it all be done in MS office applications?
how to convert asp file output in excel dynamically.
View Replies View RelatedI have one problem, that is i design a ASP report getting data from MS SQL Server 2000 and displays it as a desinged format and also "one option to export this same format to MS EXCEL". Before i seen it, but i dont know its code:
View Replies View RelatedI am trying to change a current emailer script.
The current version will run a FOR loop for each form element and will give them a label (by a variable). This label is then attached to each form element's value on the email.
However the email is pretty untidy so I would like to change the code so that groups of labels appear as groups on the email.
I am using asp to submit a form I've created in asp. I was wondering if there was a way to output the vlaues of three listbox menus.
1. User selects hour
2. user selects minute
3. user selects am/pm
This is now outputting into my strBody as seperate entries. I'd like to combine them into one entry within the strBody.
Please reference strStartTime, I've tried to incorporate this into the email strBody, but am unable to accomplish this. Any help would be appreciated. Thanks Everyone!!!
Here is the asp code for the form: ......
I want to set up a form that will in all, send the information once filled to an email address (easy), second save the file as a .doc in a designated folder on a server for later retrieval? Is there a way to do this or a best way to possibly do this?
i have no problem getting information to send to an email account. that is easy. I just wanted to save the info to a doc once they click submit and add to a folder that is designated?
I have made some email forms using CDONTS. I have a problem when it comes to the textarea field; all the text shows up on one single line when i receieve it in the email.
Is it possible to create a new line automatically when the user press the enter key in the textarea? Any ideas?
I have an Excel Template that is filled out in certain senarios. What I want to be able to do is access this existing Excel Template through a webpage, enter nessisary data into the template, and then e-mail these changes to certain people. The original Excel template needs to stay Unfilled out and unmodified once the process is complete. If saving a different copy to e-mail is nessisary that is ok. I have Created the Excel object on the server to be filled with database info from a query, but I'm not sure how to open an current excel document and then email that document onces it is filled out..
View Replies View RelatedI have a 2000 server running IIS 5. I need to send approximately 10000 emails to recipients from an excel spreadsheet with a small word document. These are requested emails, no spamming. I don't have a clue as to where/how to start this.
View Replies View RelatedHow can I retrieve the output that has been sent to the client, e.g
[vbs]
<html>
<head><title>Test</title></head>
<body>
this is output
</body>
</html>
<%
Dim strContents
'Now I want to put the contents in an variable, something like
strContents = Response.Contents '(but that doesn't work)
%>
[/vbs]
With this line of command :
Response.ContentType = "application/vnd.ms-excel"
I can output a file in XLS format with no problem.
But on a specific server, the file pops as an ASP page. My code is fairly simple.
Does the server need to have Excel installed in order to work ??
How do I output an ASP variable insde of Javascript?
View Replies View RelatedThe problem i have in my system you can seacrh clients and then display their details. what i wanna do is find the client i want and then have a button called e.g. generate and then the asp pops up a word or rtf document with there details sloted in to a preformatted document.
Now i know i could do this by creating the doc line by line with asp on the file but is there a faster way of just inserting the asp values into placeholders in the word or rtf file which has already been setup?
I'm having a problem controlling the output from an access db and the css two column layout. It goes like this.Left side has a connection string and outputs 3 columns of db data to the leftside of the page. There is also a conection string on the right side of the page. It outputs that db data AFTER the right side processes that data. So the page is staggered, left to right instead of displaying the results across from each other.
View Replies View RelatedI have an ASP program. It outputs HTML with some
XML data islands in it. When I run the program, the
browser sees the HTML and doesn't work the way
I want it to. however, if I view source on the output
page, save the source as an XML file, then open the
saved file, it works properly.
How do I get the browser to treat the output from an
ASP program as XML instead of HTML?
How can I send gzipped (compressed) output back to the browser, using ASP (and IIS)?
I'm looking for a function similiar to PHP's ob_start("ob_gzhandler"); function.
This is really puzzling me; I am developing a site for a client and have uploaded it to a remote server with ASP enabled; I and my friends do not have a problem diplaying the output HTML from my ASP statements however, my client is unable to see it. He says he can see all the other page (CSS layout) but is unable to view the content (output HTML) from my ASP statement.
Now I am clever enough to know that ASP is server side, so I cannot understand why he can't see it- and he has tried this with two of his computers.
The only possible explanation that I can come up with is that he may have Javascript disabled in his browser as my pages contain a small amount of Javascript.
if guy can help how to output if my customer make reservation....enter everything ..etc enter first name, last name. then after click make reservation button it will come out his/her name on the page for his/her referrence ...then it will clear once another customer enter it.
View Replies View RelatedThis might sound stupid to you guys, ok i have this:
------------------------------------------------------------
perc = (total*100)/limit
response.write (" You are using ")
response.write perc
response.write (" % Of your 1GB")
-------------------------------------------------------------
but on the output i just need the first two digits, but i get this
You are using 21.8057899 % Of your 1GB
Please guide me. How can I output the records from my recordset in columns in a table? That is, instead of just one record per row in a table, how can I have multiple records per row?
View Replies View RelatedThere is no error in the code but can't get output from this code;
<html>
<head>
<title>g</title>
</head>
<% set db=server.CreateObject("ADODB.Connection")
db.Provider="Microsoft.Jet.OLEDB.4.0"
db.open "C:/data/CIS_data.mdb"
VarQuery="SELECT FullName,ICNo FRoM Patient_Details"
set rs=db.Execute(VarQuery) %>
<% Do while NOT rs.EOF %>
<% rs.movenext %>
<% Loop %>
<% rs.close %>
</html>
</head>
if something similar to php (ob_get_contents(), output
buffering) exists in ASP/VBscript.
I haven't being doing that much in ASP, but I have to create this:
It has to read out data from some DB to excel.
The following (corrected) code works if just it outputs as html, once
the Response.ContentType is excel. then it offers to open/save the
file, and stops - file not found - what do I do wrong? Code:
this question is not about SQL exactly
so, I am asking here.
how to get output from sql procedure ?
my sql p. like below
Code:
if not exists(select .....................)
set @result=0
else
set @result=1
so, how can I get @result in ASP
Does anyone know of any freely usable code that helps automate the
process of generating RTF files from ASP (particularly generating the
code needed for tables)?