I have in the past run some ASPs that generated Excel reports via the following line:
Response.ContentType = "application/vnd.ms-excel"
Response.AddHeader "Content-Disposition", "attachment; filename=rpt_s2dpoc_Access_dump.xls"
I have a critical issue where I need to from an ASP gereate and excell spreadsheet but with three tabs. I will need different sections of the asp to write to those three tabs.
Code:
I have a client who is requesting information in a batch type form in their CMS (easy enough).And they've asked that these reports would print one per page (hmm). From my experience I don't think this is possible but thought I'd ask on the forums here.Anyone know about this?
View Replies View RelatedI am exporting data from ASP page to an excel sheet using the following
code.
Response.AddHeader "Content-Disposition", "attachment;filename=ExcelView.xls"
Response.ContentType="application/vnd.ms-excel"
I have two questions.
1. How the excel file gets created on the server before it is sent to the
client.
2. Is there any prerequisite for exporting the data to excel? I mean do we
need to install any software like MS office on to the server?
I have writing a ASP that export an Excel file by using response.contentType
= "application/vnd.ms-excel"
I can export an Excel:
However, the grey color gridline is missed, how can I display it again? I won't draw table and set it's border = 1 since there have up to 65536 row in Excel....
i have been set a task at work.We produce alot of excel reports that are repeated for all our branches and want to move these to the internet ie asp.
I have been tasked to learn asp but the employer will not provide any sofware and think it is straight forward to create the pages through typing all code into instead of using any software like asp.net etc. Could someone help me as all i seem to find are asp.net books and not pure asp. I have soem knowledge of vba for excel and wondered how best to learn asp.
i'm trying to display a page in an excel format.
I'm using:
Response.ContentType = "application/vnd.ms-excel"
at the beginning
it opens an excel web sheet, but all i get is:
Code:
As the subject of this topic suggestions I am trying to find a way to
use ASP, SQL Server, Com+ and Crystal Reports 8.5 to Create Dynamic PDF
Reports Over The Web, but the only article I found that decribes this
process is located on ASPToday.com which is no longer an active
website. When I try and suscribe to the site I just get a message
saying to email, and when I email I don't recieve a response. Code:
I want to create a webpage with asp. on that website, clients can get data from the
database with SQL.
I can already view the report in the crystal reports viewer on my asp page, but i want to
design the report at that time. is that possible? i have read something about RDC, but is there another way to do it. i don`t have VB experience and tolls to use RDC.
I’m trying to build an application that will flow like this “when the data from my form1 is submitted an auto increment is generated id will generated...I want to be able to used the generated id in other form or page in my application.. this is because the id would be use as foreign key in other table in the database” …is there anybody can guide me on these issue.. I manage to develop it only until the submission of the first form after that I didn’t know how to call the generated id.. For your information I’m using mysql as database.
View Replies View RelatedCan anyone provide me with, or point me in the direction of somewhere where I can get the code to get the server to create and send an email.
Basically, when an order is completed on my site, I need to create and send an email notification both to the client and also to ourselves.
Is there anything else I need to be aware of when dealing with this? Any help would be greatly appreciated.
Im trying to send plain text emails to a japanese mobile phone.they use 3G in japan. However,one make of mobile phone can't read messages when the message is generated from two strings concatenated together.yes,i dont belive it either
e.g.
message = "Hi"
message = message & " Bye"
cannot be read on one type of mobile phone (giving invalid content error).
I've also tried message = message + " Bye" but that gives the same problem.This email can be read on all otehr types of phones. A single string can be read, but as soon as the string is ended and then started again,it breaks.
I used to have a piece of code that would generate a random string of
8,16,24 or 32 characters in length.
I got it from this group, does any one have this piece of code?
It will be used for a double opt-in email newsletter.
I want to send customers and automatecly generated email once they submit a form/place order. I've been searching the net for a whille but I haven't been able to find any usefull information.
View Replies View Related<%
for Counter = 1 to Sections
%>
<tr>
<td><input name="<%=Counter%>_Title" type="text" value="Item Number <%=Counter%>" size="40"></td>
</tr>
<%
next
%>
As you can see, the name for the text field is being generated as (in this instance) 1_Title
the form submits to another page.
How do I retreive the new value of that form?
<%=1_Title%> returns an error.
I have an insert query that creates a customer record, this record is given a ReferenceNo that is autoincremented within Access.
What I want to know is how can I retrieve this value after I have applied this update. Using MySQL I know there was a way to retrieve autogenereated keys, but is there something similar that I can do via the ADO stuff and access?
have a number of text box rows generated dynamically with the same name. This gets posted to the same page as a comma delimted string.
The Problem: If a user enters a comma the string gets disjointed.
Need to parse(remove commas)the dynamic text box values generated on client side.
i need to build a booking system which relies on a calender. basically i have a db of clinics thar offer allotted times for appointments on certain dates. eg: a clinic may offer five 20 minutes slots 2 days a week.
so i need to get the data out of the db and display that in a calender form which the user can then select the time/date convenient to them. my question is (apart from how do i build this!?!?!?!) does anyone know a good calender that would fit my purpose? Code:
I have an asp page that collects data on referrals. The user inputs the
information and selects the rep to receive the referral. My data is being
saved to a backend database (SQL) and the user is receiving a confirmation
page after hitting the Submit button. Now, what I need is a way to have an
email sent to the rep that is selected in the drop down list on the asp form.
I have a SQL table containing the reps and corresponding email addresses.
Is it even possible to achieve what I am trying to do? I am trying to avoid
sending a blanket email to a single address and having someone filter them
from there.
I know you can use the XMLHTTP object to retrieve Html, but how can you get html created by an asp page? Is there a way.
View Replies View RelatedHow could I create a random filename for a single-use download? So, if a user was to download a file from a site it would send them a unique filename that could only be used once. That link would not be available after the download completed.
View Replies View RelatedI am relatively new to this generation of variables in ASP. I am unable to proceed from here. Can somebody advise?
Challenge :
I get number of participants in an exam, from a sql statement and stored into a variable called headcount.
After that, I am using the following to initialize randomly generated variables. For example if there are 4 students in the class, I intend to get student1, student2, student3 and student4, all of them initialized to 0.
For j=1 To CLng(headcount)
Eval Execute("student" & j & "=" & 0)
Next
Now we are trying to find out question wise defaults in the test. I have a for loop that does traverse through all the questions in the test. As I go question by question, if there is any failure I would like to increment the errorcounter of that participant.
Which means .....
I am not the ASP programmer on this project so I am simply asking for possiblities.
We are using ASP to generate html documents with data drawn from a database. We need to email some of these pages to our users.
We do not want to create separate email-able versions of all of these pages. It would be ideal to create an html email or attach and html document to an email, using the html code the asp code generates on the existing page.
Can this be done? My programmers tell me that the second option (write the generated code to a file, attach it to an email, send it, delete the file) would need to use FSO and the this object opens security holes.
Can anyone point me in the right direction for tutorials etc on dynamically generated pdfs from pages created from a database.
View Replies View RelatedI have to make a page with an inline frame, in this frame will come a dynamic generated PDF.
The PDF will have to be stored on the server to load in the preview frame but after the user had loaded the pdf in his browser I want it removed.
I thougt maybe I could use a General variable defined in global.asa that counts from 1 to 100 or something and every time a pdf is generated the number = number + 1 so I can create a pdf with the name ' filename & number & ".pdf" ' so that there would be constantly 100 pdf's on the server but not more and there is no danger of mixing up the preview which users get to see because it takes a while before their number is used again / their pdf is overwritten ...
My Asp database generated pages' content links all open a new window containing the same page by default; this is strange since the default behavior for anchor links is to open in the same window; I can and have corrected this with target="_self" but I have additional anchor links that call JavaScript to submit a form and these aren't stopped from opening the new window by the "_self" value.
Interestingly, once the new window is open with the original page within, the links all work as expected in that window(!?!); is there a window or DOM value I need to instantiate so the generated windows will "recognize"themselves?
I wrote an asp script to generate an email only to find there is no mail server on the server running my scripts.
View Replies View RelatedI have some ASP pages that use ASPmail to generate emails containing infomation taken from an Access database (the info is selected from a random record, in a particular database field, and then inserted in the email text as a variable). When the emails arrive at their destination, they contain a random space. The position of the space is completely random. It can appear in the ordinary body text, or in the lines of text generated by displaying the contents of the aforementioned variables.
eg the line in the email may say:-
I am a line in an em ail.
or
I am another li ne in an email.
or
I am yet ano ther line in an email.
Sometimes the space appears in a hyperlink and causes it to fail.....
I am generating a shipment order booking. For this, I am generating a report which contains the container details. And another report from another file, generating the packing list.
These two report are from two different pages. I want to send these two reports together by mail.
i've got a client that wants to be able to review records about IIS
generated emails.
in his own words, he wants the "ability to track and report message status
(i.e. how many messages were sent successfully, how many were blocked, how
many bounced back with an incorrect address)"
i'd start by adding a new row containing the email address, dateTime, etc
when first sending the email, but how to track the rest of the info? for
instance, if an email bounces back, does it bounce back to IIS or to the
"from" email address? what about the blocked (i.e. spam filter) emails? is
there a way to track blocked email? since most spam filters don't generate
response emails, there's not much i can really do about this, is there?
this will be run off an IIS6 server. can anybody tell me my options?
ken any 1 enlighten me on wat to do for the following:
im suppose to allow user to enter their particulars in this registration for,
following which Im suppose to auto generate a password and email it to them at the same time(after they have submitted their registration form).
I would like to incorporate a Randomly Generated Validation Code Immage into my New Registration page (so when users register they have to enter a validation code produced by the immage).
View Replies View RelatedI know it's possible to extract data from a named range on an excel sheet. What I want to know is can I dynamically generate a named range with X columns and Y rows with VBScript.
View Replies View RelatedThis is a tricky one for me and I'm hoping someone might have a bright idea. Ok, here goes. I've made a form generator which generates a html file. I need the user to be able to go back and edit the form at a later date perhaps adding another form element.
I know that you can 'openTextfile' and get the html code. I need to work out a way of the user being able to add a form element at a specific point (ie between two other previously generated form elements).
I know I could load the html into a textarea and have the user edit it from there, but I am assuming the end-user has no (or little) html knowledge.