Add/Edit/Delete Form for database

  • Thread starter Thread starter Paul Schandel
  • Start date Start date
P

Paul Schandel

I have created a picklist page that brings up another page to display the
data. This is great and works fine.

Now I want to take it to the next level.

I would like to create a page that allows me to add/edit/delete records. I
am guessing that each page may have to be seperate as the preform different
functions to the database. I am using an Access 2002 database. Any
pointers, hints, tips, or otherwise to point me in the direction of creating
this page to perform these tasks would be greatly appreciated.

While I wait for this information I'll go back to formatting my output page
fromt he picklist and make it look pretty for management. :)

Sidenote: Thanks to all of you who have offered suggestions, help, and
otherwise as I create this website. Its my first time doing anything of
this nature outside of your basic html, and I cant express enough gratitude
for the help. Ok, how about I throw a party in Santa Cruz.... you have to
supply your own transportation and housing though... lol
 
You'll be using SQL statements to perform any of the
database input commands. A quick tutorial on how thw
syntax is laid out can be found at

http://www.sqlcourse.com/

Assuming you have established a databse connection in
your asp page, then the commands set forth at the above
web site will do the trick. The basic format is:

strSQL = "INSERT INTO Sessions (UserID, Date) VALUES ('"
& ThisUserName & "', Now())

Sessions refers to the table in my database, UserID and
Date are names of fields in my table, and ThisUserName
and Date are names of variables with real values I've
created.
 
I am guessing from the first response this means there is no built in wizard
to perform this action automatically for someone?
 
Great! Perfect! Just what I was looking for... but why do I get this error
when the wizard generated the code itself?


Active Server Pages error 'ASP 0131'

Disallowed Parent Path

/DROnline_interface/DROnline/editor/detail.asp, line 18

The Include file '../../../_fpclass/fpdblib.inc' cannot contain '..' to
indicate the parent directory.





message In FP2002, there is the Database Interface Wizard:
http://www.at-frontpage.com/2002/diw.htm

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/
 
Actualy I found the KB article dealing with this... So I have to wait till
the morning to fix this..

ciao
paul
 
Back
Top