edit records in a sql database

[Guest]

I am still learning. So far I have created a database, developed a form to
add records, developed another form to search the database and display
records that match input submitted by the user. Now I need to be able to
search and edit the file (changes and deletions). I have searched the content
of this website for information and now I am totally confused. Can I develope
another form that will allow only the edit features or do I have to start
over and create a new page to do it all. I can't find any real help in the FP
help either. Please help me .

 

[Trevor L.]

I am still learning. So far I have created a database, developed a
form to add records, developed another form to search the database
and display records that match input submitted by the user. Now I
need to be able to search and edit the file (changes and deletions).
I have searched the content of this website for information and now I
am totally confused. Can I develope another form that will allow only
the edit features or do I have to start over and create a new page to
do it all. I can't find any real help in the FP help either. Please
help me . --
RWS FLorida

I am looking for exactly the same information (I think).

I can display, add and delete, but my attempts to amend an existing record
result in the fields being set to blank. )If you are looking for how to
delete, I have managed that, so I can post the code here,)

However, I would also appreciate any help on how to amend an *existing*
record to a specified value (usign an <input> starement) .

I have posted a query here on how to amend, so I won't repeat the details.

BTW,
I am using an Access DB (.mdb)

 

[Trevor L.]

I am looking for exactly the same information (I think).

I can display, add and delete, but my attempts to amend an existing
record result in the fields being set to blank. )If you are looking
for how to delete, I have managed that, so I can post the code here,)

However, I would also appreciate any help on how to amend an
*existing* record to a specified value (usign an <input> starement) .

I have posted a query here on how to amend, so I won't repeat the
details.
BTW,
I am using an Access DB (.mdb)
--

RWS FLorida

I have sorted out how to update an Access mdb

I use 4 linked files
1. update_password.asp
This reqests a password and calls
2. update_guestbook.asp
This lists all the records and a selected record is linked to
3. update_form.asp
This has input fields for the selected record and calls
4. update_entry.asp
This udpates the database

It would probably be better if I could update more than one record at a
time, but this is where I am up to at the moment

If you want them, I can post them (perhaps as attachments)

 

[Stefan B Rusynko]

See http://www.asp101.com/samples/
and the references for ASP/SQL/ADO at http://www.w3schools.com/default.asp

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| RWS Fl wrote:
| > I am still learning. So far I have created a database, developed a
| > form to add records, developed another form to search the database
| > and display records that match input submitted by the user. Now I
| > need to be able to search and edit the file (changes and deletions).
| > I have searched the content of this website for information and now I
| > am totally confused. Can I develope another form that will allow only
| > the edit features or do I have to start over and create a new page to
| > do it all. I can't find any real help in the FP help either. Please
| > help me . --
| > RWS FLorida
|
| I am looking for exactly the same information (I think).
|
| I can display, add and delete, but my attempts to amend an existing record
| result in the fields being set to blank. )If you are looking for how to
| delete, I have managed that, so I can post the code here,)
|
| However, I would also appreciate any help on how to amend an *existing*
| record to a specified value (usign an <input> starement) .
|
| I have posted a query here on how to amend, so I won't repeat the details.
|
| BTW,
| I am using an Access DB (.mdb)
| --
| Cheers,
| Trevor L.
| [ Microsoft MVP - FrontPage ]
| MVPS Website: http://trevorl.mvps.org/
|