I have several text files on my server and I would like to combine them into one text file by just appending each file to the end of the combo file. I know this should be possible, I just don't know how to approach it. Some combination of OpenTextFile and CreateTextFile?
View RepliesCan I use FileSystemObjects to Read Text Files on my server rather than just on my local drive?
View Replies View RelatedMay I know how to combine the text that get from textfield with the "strings" and insert it into database? Can anyone help me to check whether example below is correct or not. Any syntax error?
userid= request.form("userid")
emailaddress=userid + "@xxx.com"
insertsql= "insert into database(email) VALUES( '"&emailaddress&"')"
I have several (three) CSV files each with different columns and dissimilar data. The only common column is transaction date. What I'd like to do is combine the data chronologically. I can't do a join query because the transaction dates do not line up from file to file and no other columns will match either.
I just want all the rows from the three different files put in chronological order in one place understanding that my columns wont line up since the source columns are different. I've exhausted every effort on the SQL side to combine these, but I'm thinking maybe there's a way to do it with FSO or something else.
Is it possible to recall a variable with the combination of text + rs.field? i want to recall the variable "speler1", at the place weher rs("speler") is 1. It's probably again easy.
View Replies View RelatedQuick Question: Using the FileSystem Object in Classic ASP is there any way to read the files in a folder in the order they were created?
Dim ObjFSO, ObjFile, ObjFolder, x
Set ObjFSO = Server.CreateObject("Scripting.FileSystemObject")
Set ObjFolder = ObjFSO.GetFolder(Server.MapPath("../myfolder"))
x= 0
For Each ObjFile in ObjFolder.Files
Do while x <10
Response.write(ObjFile.Name & " - " & ObjFile.DateCreated)
x = x+1
Loop
Next
This script reads in the first 10 files found in the designated folder, but how can I be sure of getting the 10 most recent files? It seems that the default ordering is by file name.
The only method I have at the moment is to read in ALL the files attributes into Arrays and performing a Bubble Sort. This gets increasing inefficient as more files are added to the folder I am reading from.
Is there any methods in the FileSystem or Folder Object which will allow me to sort the files by DateCreated or Modified before selecting the first 10 files I find?
I know this is going to be blindingly simple but I've had one of those days where the more I search and try, the further away from finding the solution I am!
What I'm trying to do is really simple, but the last part of it I can't seem to get right... hopefully someone will spot it straight away.
<%
fPath = Server.MapPath(".")
qDate = DateAdd("d", -7, Now())
Response.write qDate
Set objFSO = Server.CreateObject("Scripting.FileSystemObject")
Set Folder = objFSO.GetFolder(fPath)
For Each i In Folder.Files
If i.DateCreated <= qDate Then
'objFSO.DeleteFile(i.Name)
Response.Write i.Name & "<br>"
End If
Next
Set i = nothing
Set Folder = nothing
%>
As you can see, I've got down to selecting all the week old files no problem, but when I come to execute the 'objFSO.DeleteFile(i.Name)' line - I either get file not found or nothing at all.
Something to do with the ServerPath?
I want write a text file with FileSystemObject but I want this file be in UTF-8
View Replies View RelatedI'm bulding text files manager in my site and it works fine. The problem occur when I'm trying to save hebrew text in the file. Code:
View Replies View RelatedI have added a db driven marquee to my site and need to combine the global asa's to 1 global asa file. Code: ......
View Replies View RelatedWhen using ASP's FileSystemObject to create text files, I am unable to get user submitted text (in Hebrew) to save as anything other than "?????". The text file is being saved in Unicode and setting the CodePage in ASP proved unsuccessful. Strangely, hard coded Hebrew text in an ASP variable does add to the text file correctly.
Any ideas of why this happens and how to get it to work correctly?
I have an ASP (not ASP .NET) application that I have to modify. I am now using Visual studio .net as the editor. I would like to be able to work on the files together with a colleague and have versioning included in the ASP text files each time they are modified.
In addition, any comments that I make about the files as a whole in the editor should be automatically inserted in the ASP file as comments. Anyone knows an editor that can help me with this?
I haven't started programming with databases yet, but instead have been saving data in asp files. The files would look something like this.... Code:
View Replies View RelatedI'm writing a script lately to write some records into a text file for backup purpose. But may i know do asp allow update for the text file? Cause i dun want it to overwrite my previous records.
View Replies View Relatedi have a text file (tsv) with products in, but i want to run queries on certain fields, e.g. description, i ahve tried linking the txt file to a databse but the recordset does not work,
does anybody have a sample script that will query a tsv, csv file.. e.g.
SELECT FROM prices.tsv
WHERE products = cisco
I have developed a search engine to search through an Access database.It uses three fields to say if the number of people is less than 300 then display these fields.
I have searched for an engine to do the same thing using a text file as oppossed to Access.I have only found examples saying you can search through text files to find character similar to the search term.Does anyone know if it is possible to pull a character form a text file and use ASP to say if its less or more than.
I want to read textfiles with ASP. But I want to do this in a special way.
I want to set a variable, for each line.
So for example:
Dim line1, line2, line3, line4, line5
line1 = Line 1 of the text file
line2 = Line 2 of the text file
line3 = Line 3 of the text file
line4 = Line 4 of the text file
line5 = Line 5 of the text file
How do I have to do this? .....
I want to be able to compare 2 text files and display the diffeneces.on a webpage.
View Replies View RelatedI was under the impression if I had a page with several database queries to 3 different databases, it would be faster if I just had the queries cached to text files since the query result won't change that often and I build the cache manually when needed.
So my question is would it be faster to just include text files instead of doing multiple Access and SQL queries on a web page?
i want to upload text files present on my comp (running IIS) to a ftp site which is password protected (I have the "write" access to the site) how do i go about doing it?
View Replies View RelatedI'm trying to remotely get a pdf file - http://remoteServer/file.pdf - in order to store it into another server, maybe with Scripting.FileSystemObject
However the following code doesn't work properly:
------------
url = "http://remoteServer/file.pdf"
set xmlhttp = CreateObject("MSXML2.ServerXMLHTTP")
xmlhttp.open "GET", url, false
xmlhttp.send ""
------------
as xmlhttp.responseText does not contain the whole file textStream, but only a part of it.
I need to know how to write a text file to a local machine. Here is my code:
Set myFSO = Server.CreateObject("Scripting.FileSystemObject")
Set WriteText = MyDrive.CreateTextFile("C: est.txt", True, False)
Right now it writes the file to the C: drive on the server.
i know how to create text files using ASP, but is there any way to create fixed width text file using ASP? i need to have the data lined up in the same location at each row.
View Replies View RelatedI have made a asp page that will read a db table and select certain fields concerning the current day's activities to be written to a text file. After the information about the current day's activities has been compiled, it is stored in a variable and written to a text file.
What I would like to do is create a text file for each day instead of over-writing the same one. Is there another Server.CreateObject method that will allow the 'creation' of a text file rather than just over-writing a text file that already exists? I would use "month(date)", "day(date)","year(date)" to append to a text file name to keep it unique.
Below is what I currently use to create a text file. But any new information will only overwrite what is already contained in the text file. Code:
im wondering if there is a method/command which can be used so that when an asp page is called, it can 'explode' content from a text file (.txt) onto a web page, thus enabling a n00b to alter the text within the file, rather than the web page itself?
Further more, if I wanted to incorporate the text which is exploded into a CSS to give it some style flava, how would I do this? Is it possible?
I am trying to display a random background image for a webpage. I found this code to do it
<%
'Defines the number of background images you have
Const NUMBER_OF_IMAGES = 2
'Initiates the randomize function
Randomize
'Sets a variable: this will be used to hold the
'random generated value
Dim intImageNumber
'This is where we create the random number
intImageNumber = Int((NUMBER_OF_IMAGES * Rnd) + 1)
%>
Modify the body tag to accept the random number. In this case we are going
to place it within the image so as to facilitate the selection of a random
image. Code:
Right now i have multiple record sets. Im using the following Select statements:
How can I combine ClaimNbrSQL, ClaimCovSQL, and ClaimantSQL to pull data based on ClaimdraftSQL.
They have different Where_parts because one field is not accounted for in the innerjoins for the the last 3 selects. Anyone know of a better way of doing this? The problem is the queried table is not matched up correctly. For example if there are 2 rows where dft_mirco_ecd_nbr are blank, the ClamiantSQL is off by 2 rows. Code:
I want to let users select one or more of my 5 choices in checkbox format, but also want to have a choice that is "all 5 choices". When "all 5 choices" is selected, I want to make sure they can't check any of the 5 choices. Is this possible?
View Replies View RelatedWhat I try to do is to combine 2 fields in one directly in a form before the 'submit' button. I use Access and Dreamweaver MX ( ASP VBscript).
In the form, the fields to combine are 'Course' and 'Schedule' to one field 'Course+Schedule'.
I know that we can combine fields in Access. But I need to combine them before to submit the form.
I have this code that will combine month day and year for some reason it puts the data in the database as January9,2005 February, 22,2005 . I need a space after the first month and I cannt figure out where the c
DateCovered1 = request.form("DatesCoveredMonth1") & " " & request.form("DatesCoveredDay1") & "," & request.form("DatesCoveredYear1")
DateCovered2 = request.form("DatesCoveredMonth2") & " " & request.form("DatesCoveredDay2") & "," & request.form("DatesCoveredYear2")
I'd like to combine if possible these two statements drawing from a total of 3 tables.
sql = "SELECT p.Sub_ID, p.Cat_ID, p.Sub_Name, COUNT(c.Sub_ID) as ct FROM
Subs p LEFT JOIN Links c ON p.Sub_Id = c.Sub_Id GROUP BY p.Sub_ID, p.Cat_ID,
p.Sub_Name ORDER BY p.Sub_Name"
sql = "select * from Subs inner join Cats on Cats.Cat_ID=Subs.Cat_ID ORDER
BY Sub_Name"
Is it possible? Am I totaly screwed up for even trying? The goal is to count the relations ships in the Subs and Links table based on Sub_ID, to display needed data from the Subs table, and to display the Cat_name table from the Cats table in relationship to the Cat_ID in both the Cats and Subs Table.
I want to take the contents of many fields of various datatypes (varchars
and text) and combine them into a single "junk" field that I will perform
SQL Server free text searching upon, e.g.:
tblArticles
Title
Subtitle
ArticleText
CombinedField [Title, Subtitle, and Article text smashed together]
Is it possible to create a query or T-SQL stored proc that would do this? Is
SQL Server DTS a better approach? It needs to be built for each row in the
table, and it needs to happen regularly.
I have 2 store procedure, I need to pass both into the asp page, and combine the result set of two. What is the syntax or the approach to do this.
View Replies View Related