I use the following SQL statement coded in ASP to delete a record from a SQL server database:
It deletes the record based on a dropdown menu which send the Business_ID.
I also want to delete an image that is associated with the record from a table called [Business_Logos].
Here is the structure of the [Business_Logos] table:
Logo_ID – Logo data
The field that links them is [Business].LogoID and [Business_ Logos].Logo_ID.
Can anyone help?
Thanks.
It deletes the record based on a dropdown menu which send the Business_ID.
Code:
SQL = "DELETE FROM Business"
SQL = SQL & " WHERE [Business_ID]='" & str_delete & "'"
I also want to delete an image that is associated with the record from a table called [Business_Logos].
Here is the structure of the [Business_Logos] table:
Logo_ID – Logo data
The field that links them is [Business].LogoID and [Business_ Logos].Logo_ID.
Can anyone help?
Thanks.