Me again...

Here's my code (rsDeleteEntry is declared above):

elseif lAction ="Delete" then

strSQL = "SELECT * FROM tblList WHERE (tblName,tblDesc,tblPrice) Values('" 
& request("frmName") & "', '" & request("frmDesc") & "', '" & request
("frmPrice") & "')"

rsDeleteEntry = strSQL
rsDeleteEntry.Delete

Response.Write("your record has been deleted!")

conn.execute(strSQL)
end if

Here's the error:

Object required: 'SELECT * FROM tblList

I use:

DELETE FROM Members WHERE CallID LIKE  <variable>

As my command string not SELECT

Regards,
Chuck





>From: "Lori Bannon" <lori@s...>
>Reply-To: "Access ASP" <access_asp@p...>
>To: "Access ASP" <access_asp@p...>
>Subject: [access_asp] Deleting record from database?
>Date: Fri, 13 Dec 2002 22:52:38
>
>Me again...
>
>Here's my code (rsDeleteEntry is declared above):
>
>elseif lAction ="Delete" then
>
>strSQL = "SELECT * FROM tblList WHERE (tblName,tblDesc,tblPrice) Values('"
>& request("frmName") & "', '" & request("frmDesc") & "', '" & request
>("frmPrice") & "')"
>
>rsDeleteEntry = strSQL
>rsDeleteEntry.Delete
>
>Response.Write("your record has been deleted!")
>
>conn.execute(strSQL)
>end if
>
>Here's the error:
>
>Object required: 'SELECT * FROM tblList


_________________________________________________________________
Add photos to your messages with MSN 8. Get 2 months FREE*. 
http://join.msn.com/?page=features/featuredemail