deleteing a specific page

[danjapro]

This is the url and the page id

I would like to delte just this page specifically how would i rite the cod eto the page in this url

http://axis.staging.cox.com/cci/eth...asp?ID=4&SID=18

my delete statment.

if len(ssid) => 1 then
strSQL = "Delete* from tblPageContent where MainMenuLinkID = " 4" and MenuLinkID = " 18 " and SubmenuLinkID = " 18
else
if len(sid) => 1 then
strSQL = "Delete * from tblPageContent where MainMenuLinkID = " 4" and MenuLinkID = " 18
end if

 

[mrpro]

there are few things to point out before giving solution to this one..

you haven't mentioned what is ssid doing there

you are using incorrect syntax at => supposed to be >= if you want to check Greater than equal

no point in having same condition for both if any else statemetns..

 

[Genimuse]

Generally, with lots of guessing about your page, it should look something like this:

If Request.QueryString("ssid") <> "" Then
    strSQL = "DELETE * FROM tblPageContent WHERE MainMenuLinkID = " & Request.Querystring("sid") & " AND MenuLinkID = " & Request.QueryString("ssid") & " AND SubmenuLinkID = " & Request.Querystring("sid")
End If

with some other stuff for your else condition... frankly, I'm not understanding the difference between sid and ssid and id and which ones match up with which field names, nor why your SQL changes based on the existence of one or the other (where the logic you have now doesn't really work)... maybe you could explain some more about what is what.

 

[danjapro]

I got it fixed ............Thanks for your support however.