Read/write DBase IV Files
I've got to learn how to read/write dBase IV files fast. Please provide a good quick start / tutorial and / or some good links here.
View RepliesI've got to learn how to read/write dBase IV files fast. Please provide a good quick start / tutorial and / or some good links here.
View RepliesHow can I use ASP to both read and write to a TXT file?
View Replies View RelatedI need to do something very basic in asp. What I want to do is have one page that has a text box, and a button... the user can type whatever in the text box, and click submit, and it will create a txt file. Every time the button is pushed it overwites the file...
Then on a seperate page, whenever the page is loaded, it reads from the file and posts it on the page..I think this is very basic, but I'm very new.... I need to write it in standard ASP. One other thing that would be helpful is to have a limit on the amount that the text box will hold.
im making a proj. that would read ini or txt files.. and would display the content of that file in a combo box..
ex.
aaa
bbb
ccc
im currently using this "<!--#include virtual="//path/filename.ini"-->" but the problem is, it would display all the text on that file..
is it possible to retrieve the content and display it in a combo box per line?
ex.
line 1 : aaa = list.index(0)
line 2 : bbb = list.index(1)
line 3 : ccc = list.index(2)
Alright im tryin 2 write 2 a text file and then read from tat text file on the same page is this possible this is what i got so far. Code:
View Replies View RelatedI've just re-installed my PC with IIS (WinXP w/ service pack2) and now when I try to access or write data to any .asp site locally I get this error.
'Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)'; file already in use.
I have a csv file that has 2 columns - Name and Team. I want to display both of these on a page in seperate dropdown boxes..Ideally I would then like to have an option where the user of the page can click a button to change which team an employee is a part off, in effect overwriting that line of data but not deleting everything else in the file
The code below lets me see each column from the csv file on a page in a separate dropdown box but I don't think I have the logic right to do what I need..I've checked Google and w3schools but I must not be searching for the correct thing as I can't find a way to do this... Code:
Im writing a web interface for a CRM product which has the ability to store files within a database... Now, the problem is, these files are binary files, and VBScript doesn't have support for binary files (as far as i know...)...
To overcome this i wrote a component (ActiveX DLL) in VB6. This component works fine, but as soon as i use it in ASP, my computer beeps and then sits there looking like it's doing something forever...
I was working on my site yesterday -builiding on laptop -and was able to add/edit data to my database fine.
Today i get "Operation must use an updateable query."
I've checked the lit. and it seems the most likely explanation is that the folder or the DB has read only permission set.
So i checked out this in IIS and it seems everything is OK - i enclose pics of the setup -
I can't see what else is causing this.
I made a cut down page just to test the query and the same problem is occuring. I even rebuilt the database - access - just in case it was a corruption of some kind but nothing seems to work. I can retrieve data no problem just can't write or edit.
I've enclosed the code that i have used as a test just in case i'm missing something. Code:
I am working on a safetywear deduction system and i need to perform the following functions: write to a text file and read from a test file and wrute to a table in the database. I need code to write and read to a text file in asp please.
View Replies View RelatedI'm converting a VB6/SQL Server application to a web application. I need to
read data to and from Excel and Word. I'm not allowed to install Excel and
Word on the server, only on the client. Is there a way to use client side
scripts to read from and write to Excel/Word files?
how can i read the datas in specific columns and rows from excel(.csv) file and then use that datas to calculate the min(example) and write the results into the same excel(.csv) file.
View Replies View Relatedi need to set read/write persmissions on an Access DB, can access IIS folder permissions -> not alleviating issues can't access explorer security -> why is this? ad infinitum require UPDATE operation on access DB, this erroring out with : Operation must use an updateable query.
View Replies View RelatedHow can I use ASP to read data in an Excel file and than write it in the format of XML?
View Replies View RelatedI am wanting to use ASP to read the IIS log files on our web server. Can anyone help?
View Replies View RelatedI need some help because I don't know much about ASP files and I have some on my computer but am unable to read them. What program do I need to install to do that?
View Replies View RelatedI am having a few .wav files and want to read some contenet out the .wav files do i need any componenet to read this file , or it can be done via asp using file system objects or any other possibilites.
if you open any .wav files in any text editor you can see it shows some information garbled and then some text which is useful for tracking the wave files if stored in database i want to do that same.
this is what i see in the last row of my wav file from which i hv
06908 08282006 121408 23 8038 21 0314476 000000000 20 03 0
does anyone know of a ASP script that opens .doc files , read its contents and displays them on browser. please i need this script urgently, i know its read binary and not text but i want someone to help me with the script.
View Replies View RelatedI 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 was wondering if it is possible to read an excel file from the client side and for example, print the cells info in a <table> using ASP of course
I have one that makes this but, i have to indicate the fisical location of the file (C:inetpubwwwrootexcelfileexmpl.xls), wich means, my machine.
IIS cannot read files in a directory reporting that :
Microsoft VBScript runtime (0x800A01B6)
Object doesn't support this property or method: 'Fso.GetFolder'
This has to do with Scripting.FileSystemObject.
I make sure the scrrun.dll is properly registered with regsvr32.
Still the problem persists.
Previously I do not know what I did right once in permission setting and
managed to display the said files but it went away after tweaking the
permission for make other functions available.
I scoured the web and this problem is a perrenial one. Many many suggestions
have been made even in expertsexchange site but no real solution. I don't
understand why it is so difficult to have this file system service up and
running.
Can I use FileSystemObjects to Read Text Files on my server rather than just on my local drive?
View Replies View RelatedI have client who has database full of crap. One field in the "property" table is imageurl. I have been able to successfully extract only the file name from the string, such as "2030323.jpg". All images are stored in a directory called "listings". What I am trying to do is to loop through the recordset, and read each imageurl.
If there is an image file in the "listings" directory, then delete the file. It appears that some fields contain imageurls that no longer exist in the listing directory. Here is the code I have so far, I almost had it, as it told me at one point the file didn't exist. Then I screwed up the code and this is where I am at: Code:
How can use ASP to read in the ms-word document files the content, then copy
the content to access?
I attempt ("word.application") have opened with CreateObject to word
document only. Can I use "Find" function to search ms-word content in ASP?
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 need to read a SQL Server table into a Web Page and within the Web
Page to permit my users to make changes to the records, delete or add
new records and then save the entire contents back to the SQL Server
table back.
The functionality I am looking is almost the same as In the SQL
Enterprise Manager whereby I can choose a table open the table and
then return all rows and I can maintain the same and save it back to
the SQL Server table. I want almost a similar web interface to such a
functionality.
Even if not a generic functionality as the SQL Enterprise Manager
table maintenance appreciate if somebody can share the code with a
sample how I can do it in ASP pages + T-SQL if need be.
I have stolen code from another thread in this forum that I am attempting to modify. The original code uses a Microsoft Access database file but I can't create one cos I don't have Microsoft Access. Instead I am using Microsoft Works to create a dBASE IV .dbf file.
This is the code i have attempted to use but it doesnt work. Code:
I'm trying to debug an application that causes ASP to stop responding
while the other IIS services continue to run and the server continues
to serve static HTML pages. I've captured a set of log files using
the IISState utility but I'm not sure what I should be looking for.
Would you be able to point me to some resources to help me to learn
how to interpret these files?
I am creating ASP pages which call for information from a database, however when I have completed the page in FP, exit, and go to Access to modify a Query, I am told the Database is still in use and that only "Shared access " is available.This does not happen if I reboot the computer.The page was generated by Access "HTML Wizard.I am using FP98 and W98.
View Replies View RelatedHow can you insert a quote ' or " into a database from a forum without getting an sql error due to the quotes closing, or opening a new field in the sql string.
View Replies View RelatedI have a Parks Database where anyone can see a complete list of parks we have. What I would like is for people to be able to sort this list by certain parameters, one of them being a "District" parameter, but could conceivably be parameters such as Sort By "Playground" to see a list of Parks with Playgrounds.
Is there a way for me to do this via some sort of hyperlink to the "District", that if it's clicked on, does a new form (Maybe a form named sortViaDistrict) within the same page? I'm not too sure how to do something like this. Code:
I've got a little user poll system and I'm trying to create an 'edit' form. The form relates to 2 database tables, one holds the poll details (title, start date, end date, etc) and the other holds the answers/options (answer_id, answer, etc). I've successfully setup the form so it updates the poll details but I can't work out how to update the answers? Code:
View Replies View RelatedIt will export a database (Access) table to an Excel sheet.
Set rsC = Server.CreateObject("ADODB.Recordset")
rsC.Open "select * from CFL WHERE Emp_no = '"&empno&"'",myConn,1,3
'**** create excel file
Response.ContentType = "application/vnd.ms-excel"
Response.AddHeader "Content-Disposition", "attachment; filename=CFL.xls" .......
my script is working properly but i want to create another sheet of the Excel file because i will export multiple tables from the dtabase to an Excel file with multiple sheets. it only creates one sheet?