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 sql server 2k db behind an asp site and I want to know how to allow users to download the results of a recordset. I understand it has something to do with the adodb.stream object but I really have no idea just exactly how to put it together.
View Replies View RelatedI've got a SQL Server database, and am pulling records from it via ASP.Everything works fine, apart from the field which is stored as 'text' data type in SQL Server.If I change this data type to 'varchar' it works fine, but I need more than 8000 characters, so really I need the data type to be 'text'.Can anyone suggest why this might be happening, and how it could be resolved?
View Replies View RelatedI'm trying to query a set of data from MSSql which contains field type "text" for unlimited length of characters.
I make a query and store the data into a recordset. However, soon as the page try to access the unlimited field, it seems as if the recordset looses all the data it was holding.
Does anyone know how to get around this problem? or what's causing this? I dont even get an error msg. It just doesn't show anything as if there was nothing there.
i'm converting an image file to hexa..then the hexa is saved to a text file..
can any one help me how to read the content text of a text file?...
im doing it this way because i don't want to save hexa in my database, because it makes the database slower to open up.
Does anyone know of a method of converting text files to sound files (.wav, mp3 etc) which can be accessed from ASP?
I have an ASP-based website that enables users to design choreography for equestrian dressage. The resulting design is held as a series of coded movements in a database and it can then be reproduced as text or as a series of diagrams. I would like to offer the option of an audio version.
On this page...
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 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?
Does anyone have knowledge of converting text file to .iff file. I am working on a VB ASP application. I searched for example on internet but I didn't get anything.
If you have any idea of converting text file to .iff file (VB ASP) please share with me.
I want to read an asp file as a text file. The problem is that the file that I want it to read is located on a server. For example: I want to read te content of this file: http://www.bnro.ro/Ro/Info/default.asp . I want to look after some values in that file.
View Replies View RelatedIs 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.
how can i write a line to a text file? also, how can i put every line of a text file into an array - and see whether a value mathes any of the lines in the array?
View Replies View RelatedI have an asp page that is populated by an access db, I want to create a text file on the server based on the asp file. Then provide a link for people to download that text file. How would I do this quickly?
View Replies View RelatedI've a very small form just a name and a few checkboxes.when user submits the form, we want to store the data in a CSV text file and send an email to one of us here. Has any one had done it before please give me some ideas how to do it.
View Replies View RelatedI'm using ASP 3.0. I'm taking form contents and dumping it into a text file
on the server. how to add the TIME to this statement. I create the text file with the name of file, month, day and year.I would like to add TIME to it.
-------------------------------------------------------------
set fso = createobject("scripting.filesystemobject")
Set act = fso.CreateTextFile(server.mappath("/data/"&g_filename & "-"&
month(date())& day(date())& year(date()) &".htm"), true)
-------------------------------------------------------------
is asp code able to do the extraction of text from PDF File without using a third party software?
View Replies View RelatedI have a page which sends a query to an DB2 using an ODBC. The
results are then written to a text file. I am unable to write directly to
the users drive because of permissions.
The problem I have is that when the
query set becomes too big, I get error '8007000e' Not enough storage is
available to complete this operation. The query is returning 100, 000
records or more. So my question is how do I handle this? Somebody had
suggested to me to chunk the data. Code:
I would like to know how I could accomplish this without using DB. There's a long text file named "TEST.TXT" The TEST file contains special character 'º' which will be used as pagebreak. I want an ASP page that will read the TEST.TXT file and split it into multiple web pages with navigation control. (eg. <FIRST<PREVIOUS>
<NEXT<LAST)
If it is possible
I'm write an asp to include part of a text file into my asp output html, I use FileSystemObject to get the content of the text file, but the asp just hang when it runs, the source code is listed below if anyone could help: Code:
I am new to working with ASP and I would like to know
the code to create a textfile on the serer and then write
something in it using ASP.
I want to loop through a recordset and save each records contents as text files and then zip all the text files and promt user to download the zip --- can this be done?? Does anyone have any code?
View Replies View RelatedI'm writing data from an access db to a text file then emailing the text file. Everything works fine but it needs to tab deliminated. Can some one post the code for a "tab"?
View Replies View RelatedI was having trouble with the text file regarding the path of the img source depending on the location of the image so I thought I could use the full URL of the image.
Now the site im working has to work on 3 different versions testing / staging and live which gives a server name for the url everytime.
How could i reflect this in my text file to have
servername & ''/img/picone.jpg''
But cant see this working as its a text file..
how to write (String data) to a text file from an ASP page?
View Replies View RelatedI wrote an asp program that displays some information line by line such as
name, address, town, state, zip
and it prints about 200 lines to their browsers when the asp file is called.
It is comma delimted so they can import into their database using access for
example.
1. when they do file-save as to a txt file, it does not import right for
them. It seems the lines blend into each other.
1. the only way they can do it is if they view the source code, then save as
txt file. then when they import into access, it parses right.
odd, what can i do on my asp end to make sure they can just do a file save
as right from browser instead of viewing source.
Can this be done? For example, in the line below. There may not always be a & objRS("ShippingAddress2") and I'm wondering if there is a way to use an if/then in there some how. If there is no data in that field then I need to pass over this part completely & objRS("ShippingAddress2") & "|"
I'l have several instances where I need to do this Code:
fname.WriteLine("hd2|" & objRS("ShippingName") & "|" & objRS("ShippingAddress") & "|" & objRS("ShippingAddress2") & "|")
i found this piece of code from a site and it claims that you could create a text file into directory "c:test.txt" and writes the line Hello world in it. Code:
View Replies View RelatedI have the following file whatnew.txt on my server! It consists of lines each line hase 3 items seperated by commas like this:
item1,item2,item3
item12,item22,item32
...
...
I need the code to add new items to this file using the browser!
I wanted some information on how I can do the following thing.Any kind of links/urls /programs related to this topic would be appreciated:
I want to perform an export of data to a text file,tab delimited. The user will basically select the date range and hit submit.After the submit button is hit,i get the pop up sayind that the data is in Ex.txt file .
I need to then use this text file to transport stuff into quickbooks.
I need to use asp code in a text file (.txt extension). But when i try to call the text file (with asp code inside) in a browser , it simply displays the asp code i have written on the file. I know that i can set options in IIS administrative panel so that my text file is parsed as asp. But assuming i have no access to the web server, how to do this?
View Replies View Relatedi want to know the process of updating a text file through asp how can i update my text file through ASP.
View Replies View RelatedI have a text file that is the result of using XMLHTTP object to pull back a
page of search results from a search engine.
So I have the entire results page in HTML, and want to break out each hit
result from the text file as a unique item and do what I want with each hit
result.
Is there any suggested algorithms or any other techniques I could be
directed to?