http://www.w3schools.com/ado/met_rs_save.asp
....it describes how to save a recordset to file with the following...
You can save a Recordset in XML format:
<%
set xmlDoc=CreateObject("Microsoft.XMLDOM")
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "c:/webdata/northwind.mdb"
set rs = Server.CreateObject("ADODB.recordset")
rs.Open "Customers", conn
'Save the Recordset into a DOM tree
rs.Save xmldoc, 1
%>
What I don't get is where does one stipulate a filename? I put the above
code in my page and it appeared to load and execute without error. But no
file.
I am using IIS as a remote configuration tool to modify an XML config file on the server. So I pull my XML config file through XSLT to give me an HTML file with forms on. Something like this: Code:
What I´m trying to do is, after the page is printed in users IE, it saves the HTML page in the server. Doing something like this, it´s just too much ugly for my code:
I have a basic classified as form where people can enter their name, title, message, and include an attachment. I have it working so that it will save the name, title, and message into my database. However, I don't know the code for the attachment.
What I'd like to have happen is this:
When they click save, the path name that was entered is saved as the Internal_Name and the actual attachment itself is placed into a file called ClassFiles. They are connected through the use of a class_ID number.
to save asp pages to MS Word, saves the text on the pages OK, but, pictures, icons etc are just saved as a link to the original picture file . If the picture/image is not on the current PC opening the WORD file, then none is shown..
I was wondering if I could save the asp pages WITH images/pictures & icons using MS WORD on the server and then the users downloading the .doc file from the server to their PC, would this embed the pictures etc in the .doc file, so it could be shown on any PC. (which has WORD or a WORD Viewer installed).
If this is possible could someone point me in the direction as to how to get started opening WORD on the server and saving the .doc file on the server.
When I try to save any ASP page, I get the message that "The page will not save correctly". Even though I go ahead and when I go offline the space of images is blank.
I have this website also where I am using ASP pages and my users are facing the same problem. HTML page is created but images are not saved.
What changes are required in ASP code so that images are also saved.
I am trying to create an XML file from a recordset. I know that there are conversion methods out there, but for what I'm doing, everything that I have found doesn't seem to work correctly.What I decided to do was to create hidden fields from a recordset and pass those variables into a page that has XML template tags already created. I am simply passing the variables into existing tags. I now need to save that page as a Text file or and XML file.
It shouldn't matter what kind of file it is as long as I can save the XML tree structure that is being shown on the page. Keep in mind that my users want simplicity, so they don't want to have to cut and paste what is on the screen into notepad or something like that. They want to be able to push one button after the recordset is presented and have all of the tags filled in with the variables and then have a "Save As" dialog box pop up guiding them to save the contents of the page. Is this even possible?
My original thought was to save the recordset into a text file. However, because of permissions I am unable to do this and will not be able to change the permissions. My next thought was to open it in excel. However, the table is too large and I get the Cell Table: too many rows or columns error. I need the user to be able to save the records on her computer.
i have a very simple online store/shop which is still in development, once payment has been accepted the contents of the shopping cart is written to a database what i want to do is also write this info to a text or html file so i can then send it via email using cdosys i have all ready tried to do this using .creatmhtmlbody() but this will not work due to the way i am using session variables.
the main program i am using is Dreamweaver, i am using access as the database this is all running/testing on a windows server 2003 the code is in JScript (before you all start shouting at me i know i should have used VB script and SQL but too late for me now) but either way i am just asking for roughly how to do this, even if it can be done.
I've got a simple recordset which writes a html table. I've put the following code at the top of my asp page:Code:
response.ContentType = "application/vnd.ms-excel" response.AddHeader "content-disposition", "inline; filename=filename.xls" ...then done a response.write to write the table.
This should output an Excel file, but it doesn't? It just writes the table to my browser as a standard HTML page. Can anyone see how to solve this problem?
Is it possible to have a search page that queries a sql database and then writes the results to a comma-delimited text file instead of displaying the results.
I have no problem creating the search page and displaying the results I just don't know how to create the comma-delimited text file from the recordset results.
Last week, my shopping cart was still working well until I began getting the following errors 2days ago..
Error Type:
ADODB.Recordset (0x800A0BCD) Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. ../order/saveorder.asp, line 157
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)
Page: GET /main/saveorder.asp
Could you check my code below and let me know what possibly the error is?
I recieved an FTP address and found no files in html, but in asp. The source code of the site looks like normal html and I updated it locally but don't know how to save it to .asp and replace the file on the server. I can't open the .asp file. What do I need to do this?
How do I load and save a UTF-8 document in XML in ASP/VBS?
Well, the loading* is not the problem actually -- the file is in UTF-8, and understood correctly -- but once saved, the UTF-8 is replaced by what seems to be iso-8859-1 (which Flash doesn't understand, but that's another problem).
i am encountering some problems in converting some data into CSV format..i have alreadi retrieve the data however i do not knoe of ani methods of converting to CSV...is there ani method to save the directory to .csv
I'm currently doing some work with ASP and XML DOM.
Is there any way when saving XML to get ASP to save it in a formatted way? Similar to PHP's formatOutput setting? At the moment my xml is being appended on line e.g
<test>1</test><test>2</test> Is there a setting to get ASP to save XML like:
<test>1</test> <test>2</test>
The XML document I'm working on is fairly large and its proving very difficult to read through the xml at the moment.
--------------------------- <IMG SRC="calendar.gif" Align="center" Border="0" onMousedown="alert('Please! Do not download this image. Thanks!')"> -----------------------------
Now what this thing does is that it displays a dialog saying "Plz DO ..." ... What should i do if i want that NOTHING should happen when a User right clicks on IMAGE ..absolutely nothing should happen ...
Is It POSSIBLE?
Another thing ... When the MOUSE moves over the image a FLOATING TOOLBOX kind of thing appears which has buttons likes SAVE,PRINT,EMAIL and things like that ... so what should i do so that NOTHING happens when the mouse moves over the IMAGE ...
i can't seem to think of a way around, this maybe more of a security question but htought i'd give this forum a shot first.
I have server A and server B
IIS on A but not on B
I have a webapplication that needs to save a file on server B. I can't set up a virtual directory with B since it doens't have iis i believe. If i were to do shortcuts or mapped drives those i think would use the credentials of the internet user i believe which won't have access to the directory, at least that's why i think it won't access them.
Can any one think of a clever workaround this? Can i just set the permissions to allow internet users to write to a folder on server B and it'll save that way?
--------------------------- <IMG SRC="calendar.gif" Align="center" Border="0" onMousedown="alert('Please! Do not download this image. Thanks!')"> -----------------------------
Now what this thing does is that it displays a dialog saying "Plz DO ..." ... What should i do if i want that NOTHING should happen when a User right clicks on IMAGE ..absolutely nothing should happen ...
Is It POSSIBLE ?????
Another thing ... When the MOUSE moves over the image a FLOATING TOOLBOX kind of thing appears which has buttons likes SAVE,PRINT,EMAIL and things like that ... so what should i do so that NOTHING happens when the mouse moves over the IMAGE ...
Is it possible to remove just the session.sessionID, I have other session variables that I would like to keep?I use this for saving cart information but it needs to be different each time.
I have an asp application that should allow the user to enter Unicode characters.
The characters appear correctly in the browser. When saved in sql 2000 thought they are converted to question marks etc.
When I enter the characters directly in SQL (using enterprise manager), they appear correctly in sql as well as in the browser when the asp page retrieves them.
As soon as I hit save they get overwritten in sql incorrectly.
Forme time to time, when attempting to save a webpage in IE6, I see the error: ------------------------------------ Error saving web page The web page cannot be saved to the selectged location ------------------------------------ It would not save on any other location. What is the reason for this error?
Is this a code (server side or client side) to prevent a page from being saved
I made a website for my work and we have it secure to where you have to login when you come to the site. But for some reason when you use the check box to SAVE PASSWORD it will not save the password.
So each time a client comes back to the site they have to put thier password in (and they arent happy about it) Just wondering if there is a setting I can turn off or turn on to enable the passwords to be saved.
I live in the UK and thus our standard date format is:
DAY/MONTH/YEAR
In my ASP page, when i try to save a date value to a date field in my MS ACCESS database, it will switch the day and month around if the day value is less than the month value. EXAMPLE:
Try to save the 1st of February 2004 as 01/02/2004. When this is saved in to the database, it is saved as 02/01/2004. This plays havoc with my search pages as they cannot find that date since half of it has been swapped around. Ive tried saving it as a string in to a text field and it still does the same.
i have been trying to save data collected from a form to a access db. The problem is that whenever the page refreshes the asp script to save the data is executing. how can i make sure that the insert statement is executed only if the button is clicked.
ive got something on my site where if they visit a page that does not exist a asp page will come up where you can inform me about it if its a broken link ive got a code which i have took from a registration form in a login system but it still runs a query im quite new to asp and dont know how to remove it if ne1 can help the code is below! Code:
I am building a site using ASP & MS Access. I will be migrating the database to Oracle 8i when it is built. I have some date fields on one of my pages which are optional, i.e. users don't have to put dates in them. However, when the date fields are left blank, the information does not get saved to the database, because the SQL statement is incorrect. what value do I put in my SQL statement in order to save a date as 'Null'?
I have created an access DB with a few BLOBs in it to upload files to, all good and well this is working fine.
However found out I can not write the data directly to the BLOB as I have to upload the file first to the server and than read it with the ADODB.Stream object.
This is like a double action: first I have to write the file to the server and only then I can read it to the DB...
Is there anyway to do this all at once, I.E. read a file from the client and as I am reading it to actually write it to the DB???
I have been playing with some things and with lots of help from Doug and Techniweb I have a script that parses data from a sports web page and returns the results of a table with all the html stripped out - or most of it anyway.
Now I have been working on saving the info to a file so that I can input it to my DB. As far as I can tell the script info is in an array called "myarray" and I have come up with the following code to try and save it:
if Not objFSO.FileExists("nbastats.txt") Then objFSO.CreateTextFile(Server.MapPath("nbastats.txt")) Set objFile = objFSO.GetFile(Server.mapPath("nbastats.txt")) Set objWrite = objFile.OpenAsTextStream( 2,-2 ) 'Response.Write( myarray ) 'Response.End() objWrite.Write( myarray ) objWrite.Close() Set objFile = Nothing Set objWrite = Nothing
If I change obj.write and response.write to any of the other named process of the script i get results - obviously they are not completely parsed. When I try it as it is above - which should be the completley parsed data. I get this error: