JLRodgers
Level: Moderator
Registered: 04-04-2002
Posts: 1617
|
Re: Deleting a record from a database
There are at least two ways... one of which has the recordset variable, and you select "delete" from the list.
the other (easier in a way) is to do: "DELETE * FROM tablename WHERE conditions_for_deletion"
like: DELETE * FROM users WHERE username='doejohn'
or
DELETE * FROM users WHERE id=24
then it's using the connection_variable.execute (ex: adc.execute "DELETE ....")
____________________________
Everywhere's Local (classifieds, job postings, & more for everycity in the world - user entered)
|
