<% var sql = "select * from Webinar"; re.open(sql,sub,0,3); var ProductID = Request.Form("ProductId"); ProductID = ""+ProductID+""; if(ProductID=="undefined") ProductID = 101; sql = "select * from WebinarDates where WebinarId="+ProductID+" and Enabled=true"; re1.open(sql,sub,3,3); var FirstDate=0; var TotalNumebr = re1.RecordCount; var DateExpired = 0; while(!re1.EOF) { var Date1 = re1.fields("DateandTime"); var TheD = Date(); var DataBaseDate = new Date(Date1); var CurrentDate = new Date(TheD); if(Date1 != '' && TheD != '' && DataBaseDate <= CurrentDate) { DateExpired = DateExpired+1; } else { if(FirstDate==0) FirstDate = Date1; } re1.MoveNext(); } re1.MoveFirst(); if(DateExpired == TotalNumebr) { var Date1 = Date(); var DateId = re1.fields("DateId"); var d = new Date(Date1); Response.Write(d+"
"); d.setDate(d.getDate()+7); Response.Write(d+"
"); var theMonth = d.getMonth()+1; sql = "update WebinarDates set DateandTime ='"+theMonth+"/"+d.getDate()+"/"+d.getYear()+"' where DateId="+DateId+""; re3.open(sql,sub,3,3); Response.Redirect("Webinar-client.asp") ; } function GetDayName(TheDay) { var vdate; switch(TheDay) { case "Sun": vdate = "Sunday"; break; case "Mon": vdate = "Monday"; break; case "Tue": vdate = "Tuesday"; break; case "Wed": vdate = "Wednesday"; break; case "Thu": vdate = "Thursday"; break; case "Fri": vdate = "Friday"; break; case "Sat": vdate = "Saturday"; break; } return vdate; } function GetMonthName(vMonth) { switch(vMonth) { case "Jan": return "January"; break; case "Feb": return "February"; break; case "Mar": return "March"; break; case "Ap": return "April"; break; case "May" : return "May"; break; case "Jun" : return "June"; break; case "Jul": return "July"; break; case "Aug": return "August"; break; case "Sept": return "September"; break; case "Oct": return "October"; break; case "Nov": return "November"; break; case "Dec": return "December"; break; } } %>

* Webinar Name	<% while(!re.EOF){if(re.fields("WebinarID")==ProductID){%> "><%Response.Write(re.fields("Webinar Name"));%> <%}else{%> "><%Response.Write(re.fields("Webinar Name"));}%> <%re.MoveNext();}%>
* Webinar Date	<%while(!re1.EOF){ var i =0; var TimeFormat = re1.fields("TimeFormat"); if(TimeFormat == 1) TimeFormat = "am"; else TimeFormat = "pm"; TheDate = ""+Date1+""; theIndex = TheDate.indexOf(" "); TheMonth =""+ TheDate.substr(theIndex+1,TheDate.indexOf(" "))+""; TheDay = TheDate.substr(0,theIndex); TheMonthDay = TheDate.substr(TheDate.indexOf(" ")+1,(TheDate.length-TheDate.indexOf(" "))); TheMonthDay = TheMonthDay.substr(TheMonthDay.indexOf(" ")+1,2); TheDay = GetDayName(TheDay); TheMonth = GetMonthName(TheMonth); var Hour1 = re1.fields("TimeHour"); var Minute1 = re1.fields("TimeMinute"); var Date1 = re1.fields("DateandTime"); var TheD = Date(); var DataBaseDate = new Date(Date1); var CurrentDate = new Date(TheD); i=i+1; if(Date1 != '' && TheD != '' && DataBaseDate >= CurrentDate) { %> "><%Response.Write(TheDay+","+TheMonth+" "+TheMonthDay+", "+Hour1+" : "); if(Minute1<10)Response.Write("0");Response.Write(Minute1+" "+TimeFormat);} re1.MoveNext();}%>
* First Name
* Last Name
* Company
* Country
* Email
* Telephone