Delete all records ASP/VBS Access

Report · Oct 18, 2006

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

Report · Oct 19, 2006

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
>
>
>

Report · Oct 19, 2006

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