|
| 
| Submitted on: 11/10/2003 11:19:21 AM
By: Chad Snyder
Level: Advanced
User Rating:
By 2 Users
Compatibility:ASP (Active Server Pages)
Users have accessed this code 3217 times.
| (About the author) |
| | | This is one asp file that will allow you to view/add/edit/delete records in any database table. All you need to do is change a couple of parameters at the top of the file to point to your database/table/key field. I know this will make my life allot easier. This one file replaces five deferent files needed to do the same things. I hope you can use this.
| |
| |
|
Download code
Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. Afterdownloading it, you will need a program like Winzip to decompress it.
Virus note:All files are scanned once-a-day by Planet Source Code for viruses,but new viruses come out every day, so no prevention program can catch 100% of them.
FOR YOUR OWN SAFETY, PLEASE:
1)Re-scan downloaded files using your personal virus checker before using it.
2)NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.
If you don't have a virus scanner, you can get one at many places on the net including:McAfee.com
|
Terms of Agreement:
By using this code, you agree to the following terms...
1) You may use
this code in your own programs (and may compile it into a program and distribute it in compiled format for languages that allow it) freely and with no charge.
2) You MAY NOT redistribute this code (for example to a web site) without written permission from the original author. Failure to do so is a violation of copyright laws.
3) You may link to this code from another website, but ONLY if it is not wrapped in a frame.
4) You will abide by any additional copyright restrictions which the author may have placed in the code or code's description. |
Other 3 submission(s) by this author
|
|
| |
| Report Bad Submission |
|
| |
| Your Vote! |
|
See Voting Log |
| |
| Other User Comments |
11/11/2003 4:47:02 AM:
please send me a your .mdb northwind in
example not is present. Tks in
advance.
gss.italy@iol.it
|
11/11/2003 8:31:30 AM:cmsnyder
I would rather not upload the
Northwind.mdb file because of its size.
If your running MS Office you have it.
Just do a search for it or use one of
your own Database's. This file will
work with any Access database and SQL
Server database if you change the get
db string. I tried to send you an
e-mail with the northwind DB but your
mail box is full.
|
12/1/2003 1:59:15 AM:
I get an error running your
code.
Microsoft JET Database Engine
(0x80040E07)
Line 227 - Set
MyRs=MyConn.Execute(MySQL)
I don't
know how to fix it. By the way I'm
using a access database.
|
12/1/2003 9:04:17 AM:cmsnyder
This sounds like it may be the table
you are grabbing. Try putting []
around your table name, like
|
12/4/2003 10:50:58 AM:
I am new for this ASP / VBscript
codes... and I really want to try your
codes.
|
1/13/2004 11:13:55 AM:
This is a great script but the edit is
not working for me. I have a table with
a key field that is indexed, no
duplicates. I use the edit feature and
change information and nothing is
changed. The add and delete work great!
|
1/13/2004 11:20:27 AM:Chad Snyder
Let me look at this and I will let you
know what I come up with. give me your
e-mail if you want me to let you know
when I get this done.
Thanks
|
1/13/2004 11:38:38 AM:Chad Snyder
I checked it on my side and seams to
work fine. The only things I can think
of is:
1.Make sure your key field is
name "ID"
2.Is your Key field an
AutoNumber field? It should be. I just
tried the ID as a number and it
broke.
|
1/16/2004 9:53:09 AM:
Duh! I should have caught that, no it
was named just ID. I shall fix it!
Thanks great script. Very easy to use
and will come in handy.
|
1/16/2004 9:53:51 AM:
Meant to say it was "not" named ID.
|
|
| Add Your Feedback! |
Note:Not only will your feedback be posted, but an email will be sent to the code's author in your name.
NOTICE: The author of this code has been kind enough to share it with you. If you have a criticism, please state it politely or it will be deleted.
For feedback not related to this particular code, please click here.
|
|
