% if request.form("add") = "yes" then SQLINSERT = "INSERT INTO Forces_BabySitting (AccountID, Age, Location, TelNo, Experience, Course, BReferences, Feesph, Deleted, EntryDate, Email) " SQLINSERT = SQLINSERT & " VALUES ( '"&session("AccountID")&"','"&killchars(request.form("age"))&"', '"&killchars(request.form("location"))&"', '"&killchars(request.form("telno"))&"', " SQLINSERT = SQLINSERT & " '"&killchars(request.form("experience"))&"', '"&killchars(request.form("course"))&"', '"&killchars(request.form("references"))&"', " SQLINSERT = SQLINSERT & " '"&killchars(request.form("feesph"))&"', 'no', Convert(datetime, '"&date()&"',103), '"&killchars(request.form("email"))&"' ) " MyConn.execute(SQLINSERT) GEtLastID = "SELECT TOP 1 BabyAdID FROM Forces_BabySitting ORDER BY BabyAdID DESC" SET RSLastID = MyConn.execute(GETLastID) Response.redirect "babysitting-advert.asp?upload=done&id="&RSLastID("BabyAdID") end if %>
Thank you for posting a baby sitting advert. ">Click here to view the baby sitting listings.
<%else%>| Baby Sitting Advert |