I've created a form for users to fill in, and I want to be able to write the details of each form to a text file. Each file is named username.txt (eg. JohnSmith.txt or MikeStiletti.txt)
However, when the code below is processed i get a "Path not found" error. Now these files are on a web server and i am trying to write to my C drive. It would be great if I could create these files on the same web server too by just removing the "C:Surveys" on the bolded line. Code:
i have managed to pass over one item from a form and put it into the database, using this code:
' This writes information from the form to the customer database field (cust_name) dim name
name =request.Form("name")
strSQL="INSERT INTO customer (cust_name) VALUES ('" & name & "');"
con.Execute strSQL %>
how do i pass over more than one field and put them into the database, at the moment i can only pass over the name data and then store it into the cust_name field in the data base now i want to pass over address postcode , e.g and put that into the db how can i do this.
I need to be able to write results from a form picklist to a file. I know I can append the output at the end of the file but is there a way to add the output to a certain place in the file. i.e Code:
Is it possible to run an asp script to display the details (i.e. last modifed time/date) of several files held on the client and or on the server running IIS (if i map it to the folder with the files in question).
I have a strSQL line.. that basically does a SELECT * from many joined tables. The output is displayed into a table. What I'd like to do is, to have each table's field entries (say a Name field) displayed as a URL.
Clicking this URL will spawn an external viewer, which will open a predefined MS Word template. ASP code should then do a few SELECT statements, parse them, and write them to certain areas of the MS-Word document.
Practically, a user should be able to click on a name, and have MS-Word launch, filling in details on the Word document, such as Name, Address, ZipCode and so on, which are stored in SQL-Server 2k. how I can get this to work?
I have a folder that has a batch of leaflets in it, these are PDF files. In my application I have a list of courses and one of the fields has the name of the file.
Is it possible, without automatically having to add them by hand, to grab the file sizes and use them on a page or insert into the relevant db field?
I am using the following to create an SQL statement using the names and values from request.form. The loop goes through each item in request.form
The issue comes in having an additional "and" at the end of the loop and the value of x3 as not all options may be selected from the form yet the loop goes through the entire request.form list
I have to add addtional code to strip off the last "and" and was wondering if there is a way to eliminate the additional code needed for stripping the "and".
Is there a way to determine which is the very last request.form.item(i) that has a .key value and use that as x3? I would imagine I would not need the additional code if there is a way to determine this. Code:
I have written a program where according to my query all the ouput is written to the text file. I want to add 3 lines to my text file which are needed so that it can be exported into outlook. Code:
We have an existing ASP app that is doing a very simple form submission to an Access db. So it opens a connection does a write and closes the connection.
The problem is that every other form submission is failing because of an "Unspecified Error" - according to our IIS web server log.
I have 2 things I'd like help with.
1) Writing to a log file: I'd like to write to a log file (either the web servers or a different one) from the server side code within the ASP app. So, once the code opens the DB connect I would like to know it was a success. Once it writes, I want to see the string its trying to put in, etc...
How would I do this in our ASP/IIS environment?
2) Catch errors:
If I'm opening a db connection to this access db, how can I be sure the connection is a success? does a value get returned that would indicate success/failure? if so how do I capture it? I'm speaking of some type of try-catch system.
is there another approach I should be taking to debug this problem?
im writing an asp code to extract data textfiles from the server using FSO, but when I run the script the file were save at the server drive(c not on my local drive
Error Type: Microsoft VBScript compilation (0x800A0401) Expected end of statement /Web2_Local/custquery.asp, line 180, column 21 Open "DOWNLOAD.FIL" For Binary Access Write As #1
filename = server.mappath(session("Directory") & "/Text/" & ExportFileName) Set ScriptObject = Server.CreateObject("Scripting.FileSystemObject") Set MyFile = ScriptObject.OpenTextFile(filename,2,true) Myfile.writeline exportString MyFile.Close
I'm putting tabs in the exportString the C way e.g. " " but they come out in the text file literally. How does one write a tab to a file with asp? (I don't want an HTML tab!)
I am a web developer that deals with reporting.I am trying to make a print application so i can choose a few reports and then print them.I tried to do the window.print() but i don't want the print dialog box to come up.I am going to try and print from the server using WSH.
is that i need to write what is on my page to a file.The pages are dynamically created and have many tables on them.Is there a way to write the page that i am displaying to a file while keeping the formating intact.
How can I, or is it possible to create a file with a .htm extention and have includes within that file? I am trying to do so through the following code but nothing is happening when I view the newly created file.
dim fs dim file
set fs = CreateObject("Scripting.FileSystemObject") set file = fs.CreateTextFile(path & newFileName & ".htm", true) file.WriteLine("<!-- #include file='header.htm'-->") file.Close
This creates the new file but when I try to view it, the header information is not included, so how can I accomplish this?
I have an asp page that is supposed to write text to a text file. I know how to write to a text file using Server.MapPath, but how to I write to a file that is on another server?
I have a form that submits an order and it sends it to the visa site and they get the info, but my problem is I get the info back from them with the amount of the order but I don't know what they purchased and the quantity.
What I want to do is on my page is also have it write to a text file on my server, but I am not sure how to do that? I have text fields and radio buttons on my site what I want it to do on submit is also write the info to a text file so I have the customers information as to what they purchased and the quantity.
Is there a way to have it submit to the CC company and write to a text file at the same time using asp code? do I need to write a loop of somekind?
I'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"?
I would like to create a file on the hosting server (if it doesn't exist yet), then I would like to write some error information into it. Finnaly I would like to retreive that information later.
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:
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:
user wants to download XLS file(which would be genrated dynamically dedending on the user selection).
i dont want to create xls file on the server each time a user wants to download xls file. I want to create some sort of stream and write that stream to the new popup window by using response object?
I am trying to setup an ASP code to write a text file to the client side, not the server side, for the purpose where it will be email attachment.
The following code seems to only work on the server side and was wondering if there as an equivalent out there for the client side since I am trying to avoid potential interruptions on the server side:
Const TemporaryFolder = 2 Dim myFSO, WriteStuff, myAttachment, tfolder Set myFSO = CreateObject("Scripting.FileSystemObject") Set tfolder = myFSO.GetSpecialFolder(TemporaryFolder) if (right(tfolder,1) <> "") then tfolder = tfolder & "" end if myAttachment = tfolder & "test.txt" Set WriteStuff = myFSO.CreateTextFile(myAttachment, True)
I had to disable Script Blocking, afterwards it worked just fine. HTH Norton Script Blocking cause this problem. the 9o days testing product are finished earlier.
I am writing one line and for a reason I ignore it adds a line which is screwing up a few things.
<% Set fso = CreateObject("Scripting.FileSystemObject") dim sLine sArchivo="switch.txt" path = Server.MapPath("../Flash") sFile = path & "" & sArchivo
if fso.FileExists(sFile) then fso.DeleteFile(sFile) end if Set a = fso.CreateTextFile(sFile, True) if request("radiobutton") = 1 then sLine = "&ver=si" else sLine = "&ver=no" end if
I'm writing a asp file dynamically. The code works 70% or the time. It pulls info from access and creates the file -- for some reason though some characters (and I see nothing different about these) causes the following error on the line objfile.writeline
