I'd like to set up an ASP page where I can add, delete and modify records in
a simple and small CSV data base. The data base (table) will only have a few
lines and columns.
I'm guessing that there is already a sample asp page on the net that I can
use as my starting template but I can't for the life of me find it...
Any ideas...
guy wrote:
> I'd like to set up an ASP page where I can add, delete and modify
> records in a simple and small CSV data base. The data base (table)
> will only have a few lines and columns.
>
> I'm guessing that there is already a sample asp page on the net that
> I can use as my starting template but I can't for the life of me find
> it...
> Any ideas...
This is a bad idea unless you are planning to only allow one user to edit
the file. There is no builtin functionality to help you deal with
concurrency the way there is with a dbms.
Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
I hear what you're saying and agree with you. There will only be 3 of us
editing this data base and we'll be doing it while we're working together so
concurrency won't be a problem for this project.
What I'm looking for is a very simple example of being able to store some
data entered on a web page and then retrieve and edit that data.
"Bob Barrows [MVP]"
news:OEUTzQfBFHA.1452@TK2MSFTNGP11.phx.gbl...
> guy wrote:
>> I'd like to set up an ASP page where I can add, delete and modify
>> records in a simple and small CSV data base. The data base (table)
>> will only have a few lines and columns.
>>
>> I'm guessing that there is already a sample asp page on the net that
>> I can use as my starting template but I can't for the life of me find
>> it...
>> Any ideas...
>
> This is a bad idea unless you are planning to only allow one user to edit
> the file. There is no builtin functionality to help you deal with
> concurrency the way there is with a dbms.
>
> Bob Barrows
> --
> Microsoft MVP - ASP/ASP.NET
> Please reply to the newsgroup. This email account is my spam trap so I
> don't check it very often. If you must reply off-line, then remove the
> "NO SPAM"
>
Well, do a search for filesystemobject if you decide to go that way.
Alternatively, you can use the Jet OLE DB provider to access a text file.
See www.able-consulting.com/ado_conn.htm for a connection string example.
Another alternative is to use XML with the XML Parser. A search for either
of these terms should yield results.
Bob Barrows
guy wrote:
> I hear what you're saying and agree with you. There will only be 3 of
> us editing this data base and we'll be doing it while we're working
> together so concurrency won't be a problem for this project.
>
> What I'm looking for is a very simple example of being able to store
> some data entered on a web page and then retrieve and edit that data.
>
>
> "Bob Barrows [MVP]"
> news:OEUTzQfBFHA.1452@TK2MSFTNGP11.phx.gbl...
>> guy wrote:
>>> I'd like to set up an ASP page where I can add, delete and modify
>>> records in a simple and small CSV data base. The data base (table)
>>> will only have a few lines and columns.
>>>
>>> I'm guessing that there is already a sample asp page on the net that
>>> I can use as my starting template but I can't for the life of me
>>> find it...
>>> Any ideas...
>>
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
Thanks Bob. I hadn't thought of the XML approach which sounds more
structured so I might look into that.
"Bob Barrows [MVP]"
news:eumsfAhBFHA.2676@TK2MSFTNGP12.phx.gbl...
> Well, do a search for filesystemobject if you decide to go that way.
>
> Alternatively, you can use the Jet OLE DB provider to access a text file.
> See www.able-consulting.com/ado_conn.htm for a connection string example.
>
> Another alternative is to use XML with the XML Parser. A search for either
> of these terms should yield results.
>
> Bob Barrows
>
> guy wrote:
>> I hear what you're saying and agree with you. There will only be 3 of
>> us editing this data base and we'll be doing it while we're working
>> together so concurrency won't be a problem for this project.
>>
>> What I'm looking for is a very simple example of being able to store
>> some data entered on a web page and then retrieve and edit that data.
>>
>>
>> "Bob Barrows [MVP]"
>> news:OEUTzQfBFHA.1452@TK2MSFTNGP11.phx.gbl...
>>> guy wrote:
>>>> I'd like to set up an ASP page where I can add, delete and modify
>>>> records in a simple and small CSV data base. The data base (table)
>>>> will only have a few lines and columns.
>>>>
>>>> I'm guessing that there is already a sample asp page on the net that
>>>> I can use as my starting template but I can't for the life of me
>>>> find it...
>>>> Any ideas...
>>>
>
>
> --
> Microsoft MVP - ASP/ASP.NET
> Please reply to the newsgroup. This email account is my spam trap so I
> don't check it very often. If you must reply off-line, then remove the
> "NO SPAM"
>
<<
I'd like to set up an ASP page where I can add, delete and modify
records in
a simple and small CSV data base. The data base (table) will only have a
few
lines and columns.
I'm guessing that there is already a sample asp page on the net that I
can
use as my starting template but I can't for the life of me find it...
Any ideas...
>>
www.asp101.com has some good, short database examples in its Samples
area using Access databases.
And for help connecting to a text file (such as a .csv file) using the
Jet OLE DB provider:
http://www.able-consulting.com/MDAC/ADO/Connection/OLEDB_Pro viders.htm#O
LEDBProviderForMicrosoftJetText
And based on the above link realize that the actual filename does NOT go
in the connection string - rather it goes in the SQL statement
(definitely a little tricky).
Best regards,
J. Paul Schmidt, Freelance ASP Web Developer
http://www.Bullschmidt.com
ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Thanks for the links Paul. Plenty of stuff to work with.
"Bullschmidt"
news:uPw5CG2BFHA.2180@TK2MSFTNGP10.phx.gbl...
> <<
> I'd like to set up an ASP page where I can add, delete and modify
> records in
> a simple and small CSV data base. The data base (table) will only have a
> few
> lines and columns.
>
> I'm guessing that there is already a sample asp page on the net that I
> can
> use as my starting template but I can't for the life of me find it...
>
> Any ideas...
>>>
>
> www.asp101.com has some good, short database examples in its Samples
> area using Access databases.
>
> And for help connecting to a text file (such as a .csv file) using the
> Jet OLE DB provider:
> http://www.able-consulting.com/MDAC/ADO/Connection/OLEDB_Pro viders.htm#O
> LEDBProviderForMicrosoftJetText
>
> And based on the above link realize that the actual filename does NOT go
> in the connection string - rather it goes in the SQL statement
> (definitely a little tricky).
>
> Best regards,
> J. Paul Schmidt, Freelance ASP Web Developer
> http://www.Bullschmidt.com
> ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!
After some investigation I bow to your superior wisdom and have gone the
data base route. I now have the ASP returning results from an Access data
base. Only problem is that I can't get the ASP to write to the data base.
I'm getting a "Database or object is read-only" error and I can't seem to be
able to set the permissions correctly. I've found the IUSR_MyComputer user
but I can't seem to find the place or way to give that user the correct
permissions.
Thanks for your help.
"Bob Barrows [MVP]"
news:eumsfAhBFHA.2676@TK2MSFTNGP12.phx.gbl...
> Well, do a search for filesystemobject if you decide to go that way.
>
> Alternatively, you can use the Jet OLE DB provider to access a text file.
> See www.able-consulting.com/ado_conn.htm for a connection string example.
>
> Another alternative is to use XML with the XML Parser. A search for either
> of these terms should yield results.
>
> Bob Barrows
>
> guy wrote:
>> I hear what you're saying and agree with you. There will only be 3 of
>> us editing this data base and we'll be doing it while we're working
>> together so concurrency won't be a problem for this project.
>>
>> What I'm looking for is a very simple example of being able to store
>> some data entered on a web page and then retrieve and edit that data.
>>
>>
>> "Bob Barrows [MVP]"
>> news:OEUTzQfBFHA.1452@TK2MSFTNGP11.phx.gbl...
>>> guy wrote:
>>>> I'd like to set up an ASP page where I can add, delete and modify
>>>> records in a simple and small CSV data base. The data base (table)
>>>> will only have a few lines and columns.
>>>>
>>>> I'm guessing that there is already a sample asp page on the net that
>>>> I can use as my starting template but I can't for the life of me
>>>> find it...
>>>> Any ideas...
>>>
>
>
> --
> Microsoft MVP - ASP/ASP.NET
> Please reply to the newsgroup. This email account is my spam trap so I
> don't check it very often. If you must reply off-line, then remove the
> "NO SPAM"
>
guy wrote:
> After some investigation I bow to your superior wisdom and have gone
> the data base route. I now have the ASP returning results from an
> Access data base. Only problem is that I can't get the ASP to write
> to the data base. I'm getting a "Database or object is read-only"
> error and I can't seem to be able to set the permissions correctly.
> I've found the IUSR_MyComputer user but I can't seem to find the
> place or way to give that user the correct permissions.
>
> Thanks for your help.
>
http://www.aspfaq.com/show.asp?id=2009
http://www.aspfaq.com/show.asp?id=2062
Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.