Delete all records ASP/VBS Access

[Newsgroup_User]

Hi,

Is it possible to delete all records that match a textfield

i.e. I have a text field on a form and I would like to delete all records in
the database table that match the textfield in a column.

Using ASP/VBS MS Access

Regards,

Sanj

[Newsgroup_User]

www.sqlcourse.com
www.sqlcourse2.com

F1 in Access will help, too.


"Sanj" <webuser@mm.com> wrote in message
news:eh6fsg$5k3$1@forums.macromedia.com...
> Hi,
>
> Is it possible to delete all records that match a textfield
>
> i.e. I have a text field on a form and I would like to delete all records
> in the database table that match the textfield in a column.
>
> Using ASP/VBS MS Access
>
> Regards,
>
> Sanj
>
>
>

[Newsgroup_User]

DELETE FROM tablename
WHERE column = 'value'

This is very basic SQL so I would strongly advise you to look into the
courses that Lionstone pointed out to give yourself a good grounding.
HTH
Cheers,
http://robgt.com/ [Tutorials and Extensions]
Firebox stuff: http://robgt.com/firebox
Skype stuff: http://robgt.com/skype
SatNav stuff: http://robgt.com/satnav