Okay, so I created a getdates.asp page which the code is below. How would I populate a select list with it using javascript.
<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%> <% response.expires = -1 sql="SELECT ([EOCS_Date] + ' - ' + [EOCS_Start_Time] + ' - ' + [EOCS_End_Time]), [IsAvailable] As AvailableTimes FROM [TimeDate] WHERE IsAvailable=True"
set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open(Server.Mappath("/App_Data/EOCS.mdb")) set rs=Server.CreateObject("ADODB.recordset") rs.Open sql,conn
do until rs.EOF for each x in rs.Fields response.write("<option id='" & x.TimeDate_ID & "' value='" & x.AvailableTimes & "'>"x.AvailableTimes"</option>" next rs.MoveNext loop %>
<% response.expires = -1 sql="SELECT [TimeDate_ID],([EOCS_Date] + ' - ' + [EOCS_Start_Time] + ' - ' + [EOCS_End_Time]) As AvailableTimes, [IsAvailable] FROM [TimeDate] WHERE IsAvailable=True"
set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open(Server.Mappath("EOCS.mdb")) set rs=Server.CreateObject("ADODB.recordset") rs.Open sql,conn
JS isn't a secret so I don't see a security issue.