<% Response.Buffer =true%> <% if session("AdminLogin")="" then Response.Redirect "default.asp" %> <% dim hid hid=Request.Form("hid") 'if request.form.count=0 then if hid="" then %> Janahitha Ads - New Registration

 

Home     Logout  

"> Hoarding Reservation

HoardId
Client Name
Reserved From
TO
TotalAmount RS.
<% else name = replace(trim(request.form("name")), "'", "''") hid = replace(trim(request.form("hid")), "'", "''") fromdate = replace(trim(request.form("fromdd")), "'", "''")+"/"+replace(trim(request.form("frommm")), "'", "''")+"/"+replace(trim(request.form("fromyyyy")), "'", "''") todate = replace(trim(request.form("todd")), "'", "''")+"/"+replace(trim(request.form("tomm")), "'", "''")+"/"+replace(trim(request.form("toyyyy")), "'", "''") tamount = replace(trim(request.form("tamount")), "'", "''") sql1 = "insert into AccBookingHoard(accid,Hoardid,Reservedfrom, Reservedto,TotalAmount)values(" & name & "," & hid & ", '" & fromdate & "', '" & todate + "', " & tamount&")" Response.Write sql1 con.execute sql1 sql1="update hoardingmaster set HoardingStatus=0" con.execute sql1 response.redirect "AdsAdminAccBookingHoard.asp" end if %>