From the ASP application I am trying to 1) open a template 2) add data to a couple of fields (passed from order.asp to invoice.asp) 3) do a Save As so that the user can save to client.
I have this code working fine for a word document, but I am having touble with the XLT. Any suggestions?
I have a databse in MS Excel which I would like to use it in ASP? I got instruction on how to open and display the Excel databes in ASP, but I cannot make it to modify/add/delete the records.
View Replies View RelatedI 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 RelatedIs it possible to send data from ASP and put it into a existing template? i don't want to create an excel document I only want to send one piece of information from ASP to the Exisiting Template.
We have created a online quote number genetrator for our sales team and we want it to open the excel quote template and put the quote number on that excel template.
How do I change the text between a carriage return and a colon ":" in a variable?
I am calling a memo field in a recordset and want to change the format of text (colour) between these two points. How can I do it?
I want to erase a line (or modify a number) in a text file throught asp, how do I do that? I have noticed that there are three ways of opening files,
1=ForReading - Open a file for reading. You cannot write to this file.
2=ForWriting - Open a file for writing. (If open an existing file, it deletes everything)
8=ForAppending - Open a file and write to the end of the file.
How can I just skip a few lines and erase a destinated line or maybe change a word in a line. without using an brute force (copy the file back and forth...)?
I've built an array like this and I've put it into an application:
Code:
If not isArray(Application("utenti"))thenDim online(1,4)online(0,0)=4 online(1,0)=1online(0,1)=5online(1,1)=1online(0,2)=7online(1,2)=1online(0,3)=9 online(1,3)=3online(0,4)=15online(1,4)=3application("utenti")=onlineEnd if
Now is it possible to modify some values in this application-array?For example trying to set the value in position 1,1 equal to 3 I wrote: application("utenti")(1,1)=3
or
Redim Preserve application("utenti")(1,1)
application("utenti")(1,1)=3
I've developed a web app that generates documents (like word files, opendocument, excel etc) let's the user download it to their computer, edit it, and then upload the modified version, where it would be stored in a database.
I'm trying to find a way to let the user edit the file on-the-fly, and when saving it automatically update the database. That is, I'm looking for a way to automate the download-open-edit-save-upload cycle. Ideally, when clicking on a link, the user would choose to open the file with the apropiate application, and when saving it the database would be updated. So, any ideas?
Does anyone know if there is a way of changing IIS settings using ASP specifically:
"The content where this content should come from" radio button property set on the Virtual Directory Tab (of a VD).
I managed to find the problem with my script thanks to jmurray's help. However I am now left with a confusing puzzle and I cannot any information about a workaround.
The error I now get is:
Cannot modify or delete an object that was added using the COM+ Admin SDK
I know now the reason for this is because I changed the 'from' email address in my script. If I put it as 'service@safetouch.com' it works fine. If I change the address to ANYTHING else, I get the above error. Is this something that can be corrected through scripting? If not, any ideas where I should be looking?
any way to modify text content of a word document through ASP?
View Replies View RelatedI'm looking for a code already written if it is possible (as i need to do this soon)I have a database(access) and the users submit data from a asp page and it stores the values. Then it also allows the users to login to the web page using the data (username and password) inserted by the user.
What i want is that when the user logins, to be able to modify the inserted data..Perhaps the user wants to change the e-mail address. I tried doing some search in google but the results were no good.
I would like to modify IE page setup before printing the window. But i want to do it without opening the FILE-> Page Setup window. In fact, i would like to remove the header and footer of pages beforeprinting them. but i want to do it using asp or vbscript and without any end user action.
View Replies View RelatedI have a program that will need to update a certain table entry repeatedly - so I want the transaction to take place without using up too much time or system resources. I basically want to update the field with the current time i.e. Now(). Let’s assume:
The table is called tblExample. The field is called LastTime.
I could do this very easily using record sets, but I understand that using pure SQL is much faster than using record sets. So, how would I update the field using only SQL?
I created an asp page it looks different when looked from an 1024x768 than it looked on 800x600 resolution. how to control this?
View Replies View RelatedI've got quite 20 identical MDB files running on an IIS5 server. From time to time I need to go into various tables and add a field or two. It would be great if there were an application out there that could either: sync all MDB designs (and/or data) esignated to match one I've added some fields/tables to OR go into all designated MDBs and create new field(s) or table(s).
I've began writing something like this that right now just does part of (b) but I'd rather find something that is much more slick and complete.
I manage to solve the last problem, but now I've encountered another one. I think there is something wrong with the UPDATE statement in this code. I am using Oracle 8i and Sun One ASP. Code:
View Replies View RelatedI need to alter a dremweaver Update Record function but am a bit lost with it. I basically need to take the values from 3 drop downs that let you selct the date (day, month year). I've written a variavble that adds these together to make a date:
JJ_theDate = Request.Form(selectDay) & "-" & Request.Form(selectMonth) & "-" & Request.Form(selectYear)
but have no idea how/where to slot this in with Dreamwevers code (below) that does the SQL update.. Code:
If anyone can guide me to change my basic data results link bar buttons (First, Next, Previous Last). I will like to use my custom arrow buttons but don't know how. The default buttons are generated by default with i create a query. Where do i go to modify these buttons, and what code do i use in the new buttons i will like to use....
can use template with asp like php ?
View Replies View RelatedI am looking for a website that provides a message board template.
Also one that provides a form that allows customers to pay membership dues online while inputing information to be stored in a database.
I am trying to update a website that uses ASP to connect to a database.
I want to change a template file i have so that it is CSS driven with as few tables as possible.
I have managed to strip the tables from the header and footer sections of the template and replace them with divs and CSS styled unordered lists.
I am struggling with the site breadcrumb, navigation and main content areas as these use ASP code to draw data from a database (i dont have access to the database). The site is updated using a Content Management System.
The main site webmaster has told me that a CSS driven template is unworkable. I think that she just cannot be bothered to change with the times and therefore won't move to a CSS driven layout. She took great lengths explaining that she had been doing the job for six years and that tables were the best way to go.
I have the template file i'm trying to change. I have included the full template unchanged below. The template code is below: Code:
I need sample in asp how ? so when I change into news/link/ or somthing then I get the info in default ??? can somone tell me how? or where I can find templete in ASP not html??
Default.asp
Include
Left.asp
Right.asp
Top.asp
Bottom.asp
Are there any template engines out there for ASP? I'm a PHP guy at heart and I love my Smarty template engine. Is there a template engine out there for ASP that is comparable to Smarty? Are there any template engines at all for that matter?
View Replies View RelatedI need to create a template for an online newsletter that will auto-generate
page number (with current page not hyperlinked) and previous and next
buttons (no previous on first page and no next on last page).
Does anyone know of any quick asp code that will do this? I don't think
that it'd be too hard to do, but I'm very new at asp. Code:
Is it possible to open a Outlook Template via ASP? The template will be housed on the webserver itself.
View Replies View RelatedMy client has 35 domains (web addresses) that they want to host on a Windows 2K box with IIS 5. They want one application built using ASP and SQL server, hosted somehow on the IIS so that it appears as the same application for each domain. The end user of each domain will actually be using the same application.The head of each of the 35 domain, or the jr. web master of each domain should be able to cutomize the look of the each of their domain. This customization feature would be built into the ASP application. Things that can be changed would be some text, color of text, size and color of input boxes.
This application will be similar to some of the eCommerce sites that have a web interface for their merchants to be able to modify their individual sites. Sort of selecting and modifying templates. They want 1 application so any changes and update of the application will reflect on all domains.My question is how do I start designing this?
Where can I get info on this project, any opensource stuff I can look at?
Do I incorporate XML anywhere?The domains will be accessing the same DB, how do I minimize DB trips?
I have created a word template(.dot) with several bookmarks but know I don't know how to fill this information from the asp page. I have to retrieve the information from the database and fill the information in the word document Code:
View Replies View Relatedi work a lot with smarty that is a template manager for php.. there is someone similar for asp ?
View Replies View RelatedI am looking for a script or a tutorial on how to generate a web page by having a user fill in a few chosen fields and entering the information into some preprogrammed html code using variables.It would then display their page and underneath it the html code.
Exactly like this, but in asp or cold fusion:
http://www.tupics.com/freead/create.pl
I would like to code a message template. I have 2 pages here, to ease my illustration, I named it as FirstPage.asp and SecondPage.asp. I had coded a button on FirstPage.asp, so that when user clicks on the button,then the SecondPage.asp will pop up and a list of messages which is retrieved from database will be displayed, row by row accordingly.
my doubt is how to set a selected message from SecondPage.asp to put it in FirstPage.asp's textbox?
Does anybody have the code to open a Word template held on the same machine, from an asp page,. say path is "C: emplatesBuild1.dot". I've tried a lot of different codes but none open it. If this is possible can I write to it with "response.write" statements.?
View Replies View RelatedI am implementing print template solution. I would like to use it in asp
app. I open new document then generate print preview then print and
finally close preview window, but I am not able to close previewed document.
I try to move document window out of screen - somewhere like
9999999,9999999 position, view preview then print and finnaly close
preview window. Then document window is invisible but still exists.
How can I close the document window after preview??
I belive it would be better solution if I could open printed document in
my ActiveX (with browser ActiveX included) but trying do it I receive
login page :-( . I am not able to share session between document and
implemented ActiveX.