I've to got a login script, but in the middle of the verification script, I'd like once the vify has been ok'd to look for a sql file, that has insertion data in it, once the file has been found the asp code must read and carry out the sql command (insert the data in the access db), once done the sql file gets deleted. Code:
View RepliesI have a routine I'm writing to read the contents of a file and modify it. However the file will not parse properly into an array, so I strongly suspect I'm using the wrong character to parse the file. The line of code that is supposed to parse the file is:
arrLines = Split(sFileContent, vbCRLF)
When I view the array, it appears as one continuous line, but when I open the file in a file editor it's very clear there are 15 lines.
I've got a league standings file that gets uploaded as an xls file. To display the contents, I'm not sure what the most efficient way is:
1.) Import the xls file into a database every time the file is updated
2.) Read the contents of the xls file using OpenDataSource or OpenRow Set
3.) Something I haven't thought of yet!
Im having a bit of trouble with taking a csv file and sperating each row with a "," because we all know that csv's are serpated by cammas, my problem is the rows are getting messy because say I have for the first Collum "Toy, Really fast", it will seperate the collum name because of the , Is there any way I can remove these or whats the best way.
Heres my code right now: Code:
I am developing a web page, in that i have to get user's photo from user and insert it in to database. how to upload this photo from local drive to my server
View Replies View RelatedI am trying to read in an XML file I don't know the node/structure,so I basically just want to load in the file and then print out the entire file on the page through Response.Writes. how do I loop over the nodes if I don't know the names?
View Replies View Relatedi want to 'grab' an rss news feed from a public site that has the xml file published on an hourly basis. how do i do this in asp?
View Replies View RelatedWhat's the code for reading a TXT file and assigning it's contents to an ASP variable?
create variable
open a text file... read it's contents into the variable
.... perform string manip. on the variable... etc etc...
how can i read a xml file using the node item name.
one example:
i could use:
root.childNodes.item(0).childNodes.item(0).text
but instead of that, i want something like this:
root.childNodes.item("item_name").childNodes.item("sub_item_name").text
is it possible ? how can i do that ?
Consider the following code snippet:
<%
Dim objFSO,objOpenFile,strPath
strPath=Server.MapPath("ADList1.txt")
Set objFSO=Server.CreateObject("SCRIPTING.FILESYSTEMOBJECT")
Set objOpenFile=objFSO.OpenTextFile(strPath,1)
Do While Not objOpenFile.AtEndOfStream
Response.Write(objOpenFile.ReadLine() & "<br>")
Loop
objOpenFile.Close
Set objOpenFile=Nothing
Set objFSO=Nothing
%>
When I try to execute the above code, the code never gets executed. Neither
am I shown a script timeout error. After a lot of investigations, I
concluded that the code is not getting executed due to the presence of
Set objOpenFile=objFSO.OpenTextFile(strPath,1)
If I comment line nos. 3 to 8, then the code gets executed but as expected
without any output. Is this happening because of some permission which has
not been given to IIS 5.0? If so, what is it? I am working on Windows 2000
Professional.
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 understand i can not use Scripting.FileSystemObject to read a file that resident on another server and i need to use something else.
View Replies View RelatedI have a form that updates a text file. This text file writes variables (i.e. username = tom). This file is used to preview an HTML page and when you go to the form the variables are populated into the form fields again.
For some reason when someone else modifies the text file (using the form) I only see the old contents in the form fields. When I look at the preview HTML file, however, everything is fine.Why doesn't the form re-populate with the new info?
i have a variable 'user', and a text file 'users.txt'. how can i search the text file and select the line thats the same as the variable 'user', then put that line into a variable?
'user' = 'root'
'users.txt' =
testuser1|kfkfjd
root|18273
test2|fjfkds
I need to create something that will read a text file and send e-mail statements from that text file. I know this is a basic application, but I am not sure where to start with this. The text file already contains all of the information for the statements. It is one file that starts with the customer e-mail address and then separates each statement by an <eob> marker. I need to be able to browse to upload the file and then have the application cycle through and generate all of the e-mails. I don't need to do any formatting to the text file, just read it and send the e-mails. The server currently uses CDOSYS to send other e-mails from a shopping cart application.
View Replies View RelatedI have some messages in a text file.I would like to read one message every day from the text file. My Text file looks something like this
If you take medication for your blood pressure, you may need to be wary of adding certain pain relievers to your system. A class of pain-relieving anti-inflammatory medication often used to treat arthritis may interfere with a common blood pressure medication, according to research. The hash is just for demarcation. As I havent worked much with FileSystem can anyone help me how to go about acheiving the same.
I have a text file which I would like to read from the end and display only a certain number of records. Is there any way of doing this?
View Replies View Relatedhow can i read the excel file from asp or from javascript.
View Replies View Relatedi understand i can not use Scripting.FileSystemObject to read a file
that resident on another server and i need to use something else.
I m using
<input type="file" name="abc">
But when I retrieve the contents sent after browsing the file from the system using
Request.Form("abc")
the retrieved value is null, ie., blank.
Why is that occuring??
I'm trying to read a tab-delimited file into an array so I can pick out different fields for a report. I keep getting a "Type Mismatch" error that I don't understand.
sReceiveFile = "receipt.txt"
sDataFile = sReceiveFolder & sReceiveFile
sDelimiter = "Chr(9)"
Dim objFileSystem, objFile
Set objFileSystem= CreateObject("Scripting.FileSystemObject")
Set objFile = objFileSystem.OpenTextFile(sDataFile,1)
sReadLine = objFile.readline
Do While objFile.AtEndOfStream <> True
Response.Write "<UL>" & Chr(10)
'Response.Write objFile.ReadLine & "<br>"
sSplit = split(objFile.Readline,"Chr(9)")
Response.write sSplit ' I want to see the contents and this line is giving me the error
Response.Write "</UL>" & Chr(10)
Loop
objFile.Close
%>
I wanted to write a simple page to let me choose a directory and then list
the files in it. The end goal was to make an easy way to copy all the
file names in a directory. I tested with Opera7, Mozilla 1.4 and IE6 -- all
on windows XP Pro
Here is the code. In all three, when I select a file, the complete path
is displayed in the file input box. In Opera, reading the form field gives
me the same full path. But in IE and Moz I get only the filename -- none of
the path information. Code:
I need to read a simple txt file where there are some variables. I've done
this a lot of times but in this case I have something different: the text
file is located at an ftp server.
The FTP server has anynomous access.
Anyone know how can I do this?
i am able to read from a txt file and this is the code:
View Replies View RelatedI get a CD from O2 containing call data.I want to read the txt file on the CD and use the content of the textfile in an asp file to import to the database.But how do i read the file?
View Replies View RelatedI am trying to read a file which resides on FILESERVERMYFOLDERmyfile.txt.I can not map this server on the webserver. I need to access it through UNC.I have a domain account which when used with ASP.NET works fine through impersonation. I use it for ASPUpload and it works fine to save files on FILESERVERMYFOLDER
I want to read the file through FILESYSTEMOBJECT. I don't know if I can impersonate using FILE SYSTEM OJBECT.How can I read the file.
i am not able to read alphabet data from csv file using VBscript. In the following it gives error when i try to read the first record itself.
it gives the following error.
Run-time error '-2147467259(80004005)'
[Microsoft][ODBC Text Driver] Numeric field Overflow.
the source code is:
<%
Set fso = CreateObject("Scripting.FileSystemObject")
Set a = fso.OpenTextFile(Server.MapPath("") & "/learn.txt")
mystring=a.readAll
Response.Write ("<pre>" & mystring & "</pre>")
Set a = Nothing
Set fso = Nothing
%>
The output is:
abc
ABC
i don't understand this:
Set fso = CreateObject("Scripting.FileSystemObject")
Set a = fso.OpenTextFile(Server.MapPath("") & "/learn.txt")
what should be insect in ("Scripting.FileSystemObject")?
and what should be insect in (Server.MapPath("") & "/learn.txt") ?
I am building a link exchagne for a medical web site. To get categories for the link exchange, I Googled "medical categories" and came up with a very, very good list of medical categories. they were seperated by a <br> tag. I went through the code and extracted all but the following (see below).
What I want to do is somehow create a list of "options" for this categories in a select dropdown, with the category being the value for the option AND displayed in the dropdown. You know what I mean. I would think it would involve reading in a text file and inserting the necessary code. Code:
Here is what I have setup:
- a form that updates a text file.
- for example, in the form I have two fields, title and story. then, this write to a textfile (i.e. theinfo.asp). the update.asp file looks like this:
TSO.write "<%" & vbCrLf
TSO.write "title = """
TSO.write Request.Form("title")
TSO.write """" & vbCrLf
TSO.write "story = """
TSO.write Request.Form("story")
TSO.write """" & vbCrLf
- so, essentially it is creating an asp file with two variables.
- this works fine, it updates the file and i can call these variables in other pages. however, when i call these variables into a form : old versions of the variables populate the form: Code:
i had a vbscript that will read the text file from the bottom to the top, and after reading the file, it will be displayed in the screen, and the code look like this:
PHP Code: Code:
I am writing a asp code that can take values from user in html form, process it and display it back in some kind of report.
the problem i m encountering is that I have a field which is numeric and I want to compare it with tax-table like for example:
if value in field is 6 then I have to look into table in pdf file (tax table form 1040ez) to compare it with the value and then write it to appropriate field. the problem i m facing is that it's in pdf and also the data is so large (4 pages in pdf) that i don;t know how tocompare it .....
I have prepared a mail merge application in VB. Now i want the same to convert to ASP. how to go about it. I mean what class need to be used for that.
View Replies View Related