Generate Xml Without Need To Persist It In A File?
i get data with ado i need to get a xml string from the recordset how can i get it without having to persist the recordset in a (xml) text file is there a simple way ?
View Repliesi get data with ado i need to get a xml string from the recordset how can i get it without having to persist the recordset in a (xml) text file is there a simple way ?
View Repliescurrently, i export data from ASP to Excel. but i want to change it to RTF. i have looked at microsoft website and tried whay i have studied but failed to make it. at microsoft website, the table is created using rtf script but in my case, i just want to create it using html script.
and then, when user click PRINT button, i want my system shows the detail contents of rtf file and then open the Print window later. so user does not need to click File->Print and so on. is there any example script i can study?
how to generate a text file with data from the db in asp and save that file in clients system.
View Replies View RelatedIs it possible in a global.asa file (or some other way) to have an xml file generated by an asp script and saved to the server some how?
<%
Dim xmlDoc, rootEl, child1, child2, p'Create an XML document
Set xmlDoc = Server.CreateObject("Microsoft.XMLDOM")'Create a root element and append it to the document
Set rootEl = xmlDoc.createElement("root")
xmlDoc.appendChild rootEl'Create and append child elements
Set child1 = xmlDoc.createElement("child1")
Set child2 = xmlDoc.createElement("child2")
rootEl.appendChild child1
rootEl.appendChild child2'Add an XML processing instruction
'and insert it before the root element
Set p=xmlDoc.createProcessingInstruction("xml","version='1.0'")
xmlDoc.insertBefore p,xmlDoc.childNodes(0)'Save the XML file to the c directory
xmlDoc.Save "c: est.xml"
%>
THis seems to be what i am after but when I try to modify the xmlDoc.Save line to either "/images/listings/test.xml" or imageslistings est.xml" and it comes back saying it can't find the path. If I just leave "text.xml" it comes back saying permission denied. If I can solve this path issue so as to be able to save the file to a directory I think I will have it solved.
I have an application form that when filled out is being written to a singular HTML file. I want to convert it to generate a unique file name each time a user fills it out.
Secondarily, I want to be able to attach the unique file to the email that is sent to us when it is submitted.
Here are the current snippets of code:
set ObjFS = server.createobject("Scripting.FileSystemObject")
set objTheFile = objFS.OpenTextFile("e:credapp2.html",2,-1)
objTheFile.WriteLine(FileToWrite)
objTheFile.Close
and...
objMail2.AttachFile "e:credapp2.html"
With response.contenttype = "application/vnd.ms-excel", I can easily export my data to Excel which is embeded and shown within a browser. If I'm going to save the Excel file through ASP programming, which method can I use? I need to save the data to Excel file with dynamic name (the file name should contain key values and appended with system datetime).
View Replies View Relatedhow to create (generate) .html file by using asp. I am not sure if this possibility even exists... if not, is there any other way I could generate .html files? The thing is that I have to retrieve info from database and the generate .html file.
I know I could have it as .asp, but this woudl my index page and I would like to use it for search engine, which are not very happy with other extensions than .html.
how to create (generate) .html file by using asp. I am not sure if this possibility even exists... if not, is there any other way to do it?
View Replies View RelatedIs it possible to get information from a database and generate it to
unicode text files using ASP?
Is there any product/COM out there that can do this? If not, is there
any other solutions? It doesn't have to be ASP, but it would be nice.
generate an ms word file for an asp output?
<%
x=date
response.write(x)
%>
- is it possible for the date (code above) to be displayed on ms word?
On each site there is a global.asa file that ties into an Access database. The fields from the Access database instantiate the values of session variables used in the site. I am trying to do away with the need for a database and was wondering if when I set up a site I also set the .asa file for that site.
Then if a shop wants to change something like an address, phone, number, directions, etc., they would go a toolbox area of the site and there would be a form whose field values would be populated by the session variables from the global.asa file.
When the form was submitted I was thinking I could somehow use asp to write a new global.asa file and store it in the server. Is this feasible? Also, what would this mean insofar as permissions on the root directory of the site? I'd imagine they'd have to have write permissions no? Code:
I'm looking fo a solution to generate automaticaly a PDF file.
My aim is to use a template define by a user and to insert dynamicly
datas form SQL server in this document.
Can you tell me if it exist PDF template like .dot for word ?
If such file exist is it possible to generate list of information like
aacount report with datas coming for Database like Sql server.
I can only get one cookie (which does not persist) from the following asp script:
<script language="vbscript" runat="server">
' cookie_test.asp
' Copyright (c) 2002 by Dr. Herong Yang
' This ASP page displays all the cookies received by the server.
'
response.write("<html><body>")
' Displaying all the cookies
response.write("<b>Cookies received at this time:</b>:<br/>")
set c = request.Cookies
response.write("Cookies.Count = " & c.Count & "<br/>")
for each n in c
response.write( n & " = " & c(n) & "<br/>")
next
response.write("<b>Cookie added by the server:</b><br/>")
n = "Cookie_" & (c.Count+1)
v = "Value_" & (c.Count+1)
response.write( n & " = " & v & "<br/>")
response.cookies(n) = v
response.write("</body></html>")
</script>
Which results in:
Cookies received at this time::
Cookies.Count = 0
Cookie added by the server:
Cookie_1 = Value_1
Changing the Session.Timeout value has no effect.
(I'm not sure if this is the right forum for my post - my question is about vbscript, but I didn't see any vbscript forum, so here goes.)
I've created a registration page on my website which gets called from a number of links on the site - I want to capture user information before allowing them access to these sections of the site.
Once a user has registered, I want to recognise that fact when they click on any of the other links, so I'm setting a cookie. However, while it works fine in Firefox, it won't persist in IE - even across a single session.
Here's the code I'm using :
In the 'Thank you for registering' page, the very first lines on the page are :
<%
Response.Cookies("Registered") = "True"
Response.Cookies("Registered").Expires = Date + 1000
%>
Where the links that require registration appear on the site, I am building the <a href> tag as follows :
<a href=
<% if Request.Cookies("Registered") = "True" then %>
"PageX.asp"
<% else %>
"Register.asp?RequestedArea=ReportDesign"
<% end if %>
class="bodyLink">Report Design</a>
but it keeps going to the Else part - ie. it's not finding that the Registered cookie has a value of True.
I'm working in a mysql db, and I need to submit a form and persist all the values from an sql search. I tried Code:
add_records.asp?recset=rs
rs being the recordset. Didn't seem to work.
i have logically divided each .asp page in one or more "states" then i need to store somewhere information about what state has each client on each page i consider 3 ways:
store info in the DB : {page,sessionid} is the PK - in a file: which i have to read on enter to the page and write on exit the page - in the session object: storing an array on a session variable, like session("x")[1...N] each way has a pros and cons, i'm choosing the last method, but i know it consumes much memory.
i'm setting up my web new server. i see that cookies do not persist after a Server.Transfer or Response.Redirect although i do expire them the next year.
View Replies View RelatedHaving trouble getting Session to persist. Have checked properties of the Virtual Directory in IIS4 manager and "Enable Session State" is checked, with time out set to 20 Mins. Have also checked the Project Properties in Interdev 6.0 and confirmed that
"Sensionless ASP Pages" is NOT checked.
When moving from one page to another within the application it starts a new session for each page : I've confirmed this both by Writing the SessionID and by adding a Variable into the On_Start of the Global.asa. Only trying to store a single digit in a Session variable.
how I generate a new XML file that I can then use with an XSLT file. I am trying to use an XML file generated from Microsoft Project or even better generate an XML file from the project file (MPP File) itself. Which I can then use with an XSLT file
I am new to XML and want to create a project viewer using XML, ASP and XHTML. I have an idea of how this should work but would really appritiate any help someone can offer. Is it possible to take an XML file and generate it in ASP without using an XSLT file??
I've been trying to Google this but have been getting far too many hits to be of use. Is there a slick way to generate a CSV or other Excel-friendly format and push it to the client? I'm using VBScript (and HTML and other typical stuff of course) on the ASP pages (no .NET stuff). Just a shove in the right direction is all I really need here.
View Replies View Relatedhow can i generate ID(automatically) when user press the "New Record" button in my registration pages.the ID will get from the existing database and start with C01234.let says the last id in database is C01234,then when the New Record is entered,then the id number will change to C01235.
View Replies View RelatedI noticed that PHP have the ability to create PDF files without using any third partty componentys. Most notably is via FPDF. It generates PDF by using "pdf markups" / or ghostscripts .
I believe the same can be done via ASP too. One has to use response.write pdf headers. Has anyone succeeded in doing that? I have the intention to go thru PHP's FPDF and try to convert that to VBScript.
I trying to generate a new XML file everytime a user post a value through a simple form.
The form has one textfield called "price" and I want to save a new XML file (rewriting the file if the case) using the value entered. I don't want to append the value. I saw many turorials, but none of them work for me, and everytime I try to edit them, nothing seems to work.
Can you tell me how to generate a GUID value in ASP?
View Replies View RelatedI want to create an Excel object from an ASP page. Basically, the input parameters to the Excel would be from the ASP. I know ASP and I know VBA, but I haven't used both of them together. Here's what I would like to do -
The ASP should generate an Excel report by passing 2 parameters to the Excel application (I have done this independently; without interfacing with ASP).
I know that I can create an excel handle from the ASP as -
Set MyExcel = Server.CreateObject("Excel.Application")
I dont know where the VBA code has to go? DO I have to include it in the ASP?
I have a web page using frameset split into few pages. And I want to generate one page of HTML code and send it through email. My question is have to generate a HTML page using asp?
View Replies View RelatedI want to be able to generate a date (day,month,year)
and add it to a DB so as to prove when a record was added(when a transaction was completed)I then want to delete a record automatically 1 day after the date was generated.
I have a form which contains drop down box with several available selections. Based on the users selection, I would like to have a popup box appear upon the form submission that gives them some additional information about their dropdown box selection. Is this possible?If so, how do I go about doing something like this?
View Replies View Relatedi have a long recordset that i want to page through. can sql pass back say, 5 records from 20 to 25 out of 1000?
i can then pass 2 variables between the pages to dynamically generate the sql and thus page through the results. can someone post up a simple example of this if its possible?
I have design a single row (which includes text box and combo box) with muptilpe columns. When user enters a one details (for example: employee id), the other boxes will be automatically be filled in with that employees details. This I can do. However, how if I want to add more rows (to get more than one employee's details)? I can add rows but then the previous info (say on row one) goes missing
View Replies View RelatedI've looked around for a good while trying to figure out how to do this... and I need your help.I have a web page that is dynamically generated and it display rows from a DB and the rows get to be in the 100s. I need to break it up into sections... but I'm not sure how to go about doing it.What I'm wanting is something like this:
<< Previous 1 | 2 | 3 | 4 Next >>
(kindof like what is at the bottom of the forums here)
I have two webpages main.asp with some codes and text.html I need joint
(insert) text into main.asp.
I forgotten instructions to insert first webpage into second. How I can do
it?
I need to create a table with 4 cols and X rows based on the number records
in my database. I dont know how this can be done, mabye with an array?
If I got for example 6 records in my database, a table with 4 cols and 2
rows should be generated, the last row will only have 2 cols with
information... Code: