Response.ContentType = "application/vnd.ms-excel"
I'm using Response.ContentType = "application/vnd.ms-excel" to display contents in excel file.
I have one problem my SQL Query is working fine,because I checked it 1000 times and the most important thing is because if I don't use Response.ContentType = "application/vnd.ms-excel" and just printing the contents as a table it works!!! But when I write Response.ContentType = "application/vnd.ms-excel" I don't see the contents!?
One more thing ,when I use the same file with other SQL Query that is a little different I can see the Excel perfect.
View Replies
ADVERTISEMENT
I have created an Excel spreadsheet for the web. When it opens in IE
6.0 I get the message that the format is not supported. This is because
it is in tab delimited format. Ane when I save the file, It saves it as
txt. How can this file be created so that Excel sees it as an .xls
format. I created the data in VB 6.0 with a vbtab to seperate the
columns.
View Replies
View Related
You know how you can use "Response.ContentType" to tell the browser to display the content as Excel or Word and it will automatically convert your html page into an .xls or .doc file. My question is can I convert it to PDF? If so how?
View Replies
View Related
I am using Response.ContentType = "application/msword" to open the page as a word file (obviously). As an asp page, the page opens great and looks great.
But, when it's opened as application/msword, i get unwanted line breaks after every table as well as table borders and inaccurate table widths that weren't there when the response.contenttype line was commented out.
I'd make it one table but the page is a report that consists of rows and columns... some rows not lining up, hence new table. (it has to be exact).
View Replies
View Related
I have a page called createWordDoc.asp, that starts with the line <% Response.ContentType = "application/msword" %>.
What it does, is receicves information from a form on the previous page, formats everything using html, and saves it as a word document.
Everything is working ok, except when I open the word document, there should be a picture in amongst the text, but it isn't there.
Does anyone know about creating word docs from asp, or has anyone had simliar problems?
View Replies
View Related
<%Response.ContentType = "video/x-ms-asf" %>
<% dim songs
set songs = server.CreateObject("scripting.dictionary") set songs = session("cart") %>
This code works fine in IE but in mozilla/netscape, session object is lost and returns error. However, if i resmove the first line for contenttype, the code works fine in mozilla but i ned the first line as this code is part of playing a window media playlist
View Replies
View Related
I had a asp file that generated asx files using
Response.ContentType = "video/x-ms-asf"
It was working fine up until a day or so ago. Now all of a sudden it does not work. If I take out the Response.ContentType line and copy the source code to a asx file it works fine. if I copy the URLs out of the code and put them into the browser it plays. So it is generating the file correctly, it is opening Windows media player, but it then errors saying it cant fine the file. Yet copying the URL from the generated asx works fine.
View Replies
View Related
I am trying to generate an RSS feed with ASP, however, IE will not
display the feed as an XML document, instead returning it as text.
I have <% Response.Buffer = true %> and <% Response.ContentType =
"text/xml" %> at the top of the page, but it does not make a
difference. Netscape/Mozilla recognizes the contenttype and displays
it as XML, and the feed is valid.
View Replies
View Related
What would prevent Code:
Response.ContentType = "application/vnd.ms-excel"
from opening the page in excel assuming that excel IS on the clients machine?
The page has a couple included pages that contain ASP and JS, the page itself dynamically writes the table cells in html like so...Code:
strTable = RS.GetString(,,"</td><td>","</td></tr><tr><td>"," ")
View Replies
View Related
I have a problem in that i have a page that works fine and shows all records/Output until i add Response.ContentType=msword
And then i only show every other record.
I probably should have coded the page differently. But for context - it's a school report system and i have setup a Subroutine which queries a database and builds a summary report for a girl. I wanted to print out a class list of these. I.e one for each girl in a class and so i loop around the results of one recordset and within each loop make a new query and create the report. This is probably not the best way to do it.
Anyhow, in the browser it woorks fine. As soon as i add the code to output it to word (or excel ) i lose evry other report.
View Replies
View Related
When I use the Excel.Application object in window 2000 Advanced Server,
I have the following issue
'------------------------------------------get excel template file
'create excel application
Set xlApp = server.CreateObject("Excel.Application")
'open excel file
Set xlbook = xlApp.Workbooks.Open(targetFile)
xlApp.Workbooks.Open(targetFile) will create a shortcut under the C: etc.
So when I open as many as files, the shortcuts under c: are so many.
How could I avoid create the the shortcuts under c:????
View Replies
View Related
I am using the below snipped of code to dump the Recordset content in my asp
page to an excel file.
response.ContentType="application/vnd.ms-excel"
However when the query is complete the content gets displayed to the web
page in excel format instead of being prompted to save the file to the local
machine.
View Replies
View Related
i trying to use Server.CreateObject("excel.application"), but get an error message:
Server objecterror 'ASP 0177 : 800401f3' . Server.CreateObject Failed. Invalid ProgID.
i can use Server.CreateObject("Scripting.FileSystemObject") successfully, why this excel.application cannot work?is there any other way to read data from an excel file?
View Replies
View Related
I am trying to create a report in xls format using ASP. I need to do some formatting to the report. To do this, I'm using xml. But, somehow, I cannot get the columns to autofit causing the report not to print in one page. What am I missing?
Here is the code
******************
<%
Response.Contenttype="application/vnd.ms-excel"
Response.AddHeader "content-disposition", "attachment; filename="Report"
strHeader" = "User criteria goes here"
%>
<HTML xmlns:x="urn:schemas-microsoft-com:office:excel">
<HEAD>
<style>
<!--
td
{mso-width-source:auto;}
col
{mso-width-source:auto;}
@page
{
mso-header-data:"&CDate: &D
View Replies
View Related
It involves using ASP/VbScript and ADODB.Stream to read binary data from a *.DOC or *.RTF
file and then send it to the user with Response.ContentType and BinaryWrite.
Everything works fine until I try to Replace() certain strings in the *.RTF
file with my own data. I'm assuming Replace() is choking on the binary characters, or
incorrectly thinking 0x00 values are marking end of string. Code:
View Replies
View Related
<a target="_blank"
href="IndividualGamePerformances.asp?MatchID=<%=RS("MatchID")%>&TeamID=<%=Request("TeamID")%>">
Can anyone please tell me what to enter after Response.Write to write the above to the HTTP Response body.
View Replies
View Related
We have our web-site developed in classic ASP, and I need to add this additional feature on one of the pages to access a VB application. How can I do that? The VB application basically sends output to the COM3 port and opens a USB-Cash drawer that is attached to it. I am not sure how to go about with this.
View Replies
View Related
Is there any point in having response.end after response.redirect?
View Replies
View Related
Sometime this morning our classic asp web application stopped
authenticating against active directory. This is our only "classic" asp
app that authenticates against ad. Note that this app has been in
production for three years with no problems. All .NET apps are
authenticating fine from the same server. This same classic asp app
authenticates fine from our development server. There have been no code
changes to this app.
We're using the login id and password to bind the necessary ad objects
- we check for err.number - if equal to zero, we're authenticated, if
not equal to zero then authentication failed.
We checked with the network people and they say ad is working fine and
the server is able to authenticate. The app doesn't go through a
firewall -so no hang up there. The guys who manage the web server say
they haven't made any changes to it. They confirmed that the app is in
the correct app pool so it doesn't conflict with 2.0 apps.
I'm stumped.
View Replies
View Related
I remember coming across a MS tool that would allow me to monitor the performance of all aspects of a DNA based application - all the way from the ASP level to MS SQL server. It was part of the NT resource kit. I am trying to locate this tool for Win 2000. Can someone who has come across such a tool help me
View Replies
View Related
I've just been given some code to decipher in classic ASP and have come across this function (Application()) in several instances. I can't seem to figure out what it does?
View Replies
View Related
I am about to create a web application using asp and vbs to build an online
roster for a department of 25 people. The roster covers some 10 shifts a
day, 7 days a week always starting on a Sunday. I will be using an access
database file to hold the information. At this this stage I will hold all
the data for each week based on the date that the week starts.
I am looking for ideas on how to dynamically give the user the option to
choose any given week in any given year, always starting on a sunday. Could
this be created on the fly or would it be easier creating a database table
holding the dates for Sunday for a year or 2 ?
Once a week is chosen a check on the database will determine if that weeks
roster has been created or not. If not a user with the correct permissions
can then create it.The rosters are currently written out by hand. It is a labourious task which must have certain numbers of staff working each shift for a given day. By
creating a web application automating the checking process and making the
roster available online and by email will make life easier for all staff
involved.
View Replies
View Related
i am trying to install my ASP web application to my client side server, but 1 thing i am worry is they my stole my source code to sell-over or they might modify my source code... how those software house which develop ASP web application they gonna avoid this?I know Microsoft have a program that can encrypt & encode ASP files and run properly in IIS.... But to bad... i also found the Decode program too
So what is the safety way to deploy my application to client without any worries?
Some might ask me go for .NEt, in this momment not yet toward .NET.
View Replies
View Related
I am Geting the Error "Application uses a value of the wrong type for the current operation in one of my asp pages"
VB Method
oCMD.Parameters.Append oCMD.CreateParameter("@CustNo", adDecimal, adParamInput, 9, intCustNo)
oCMD.Parameters("@CustNo").Precision = 9
oCMD.Parameters("@CustNo").NumericScale = 0
For adDecimal Data Type Should i have to set Length as 5 instead of 9.
Is this causing the above or something else ?
View Replies
View Related
I am trying to develop an ASP.net application
using Visual Studio .Net 2003. When I attempt to create
the project, it gives me an error stating that the IIS on
my hosting server may not be compatible and the active
directory cannot find the web server. The server is
running Windows 2000, IE 5.5. Is there some sort of
patch I can download to allow me to create ASP projects
on that server? Or something I should install?
View Replies
View Related
I am trying to set up a fax ASP web (or vb 6) application and I want to use the FaxComEx.dll library that comes with winXP fax services. But I cant find documentation about this library.
I found something in msdn but it is very dificult to watch the logic that appeared. It's very confusing. Is there something else that can I rely to learn how to make a fax application?
View Replies
View Related
I have a client that wants to have ticket system on their web site where people could order a ticket online and after they send their payment to paypal they would be redirected back to the web site and have a unique ticket that they would be able to print out the ticket but they cant be the same ticket to prevent people from printing out the same tickets. Is this possible? Is there a program?
View Replies
View Related
My web application i need to view it on the palm. Backend is SQl and front end is ASP
How do i make it work on the PALm
View Replies
View Related
create a user subdirectorie with a webpage that he o0r she can fill with there own logo and with some text,perhaps a link but just one page.That page must automaticly come up in a link page so people can see his page.
Thing I want to have is a way that our customers, that dont want to pay for a a bigger website,can have just one page on our website in there own subdir.
I see lot's of free csm style websites but that's to time consuming for people that want just a simple page with just there logo an advertising and some info.
View Replies
View Related
I am developing a web application that will allow user 3 trials to login with the correct password and user name.
View Replies
View Related
I am building a web reservation system for a hotel. I'm working in the hotel as a manager as well. Hotel has 18 rooms and 4 Suites. Now it is my first time with such application. I planned to use ASP and Access DB. Can anyone give me ideas of basics. How to start and what an application should look alike. This is nonpaid project so i cannot actually go somewhere else except looking into forums and i can find anything.
Functionality will be, for user, gives dates, no of people and search, select room and pay. backend will be process payment(i have one processor), store it in db and generate email for the reception. Managing will be set availability, review availabity and set prices individually for the room. how the database should look alike and what will be the search criteria.
View Replies
View Related
I need to build a web application based on user's rights (roles) web interface where each user has his/her own web page depending on their user role.It is a web application that is based totally the user needs Could you please give me some insite on where to begin.
View Replies
View Related
how i can run the command prompt from an asp application?
View Replies
View Related