<% ' FP_ASP ASP Automatically generated by a Frontpage Component. Do not Edit. On Error Resume Next Session("FP_OldCodePage") = Session.CodePage Session("FP_OldLCID") = Session.LCID Session.CodePage = 1252 Err.Clear strErrorUrl = "" If Request.ServerVariables("REQUEST_METHOD") = "POST" Then If Request.Form("VTI-GROUP") = "0" Then Err.Clear Set fp_conn = Server.CreateObject("ADODB.Connection") FP_DumpError strErrorUrl, "Cannot create connection" Set fp_rs = Server.CreateObject("ADODB.Recordset") FP_DumpError strErrorUrl, "Cannot create record set" fp_conn.Open Application("scanning_ConnectionString") FP_DumpError strErrorUrl, "Cannot open database" fp_rs.Open "Results", fp_conn, 1, 3, 2 ' adOpenKeySet, adLockOptimistic, adCmdTable FP_DumpError strErrorUrl, "Cannot open record set" fp_rs.AddNew FP_DumpError strErrorUrl, "Cannot add new record set to the database" Dim arFormFields0(8) Dim arFormDBFields0(8) Dim arFormValues0(8) arFormFields0(0) = "Agency" arFormDBFields0(0) = "Agency" arFormValues0(0) = Request("Agency") arFormFields0(1) = "Use" arFormDBFields0(1) = "Use" arFormValues0(1) = Request("Use") arFormFields0(2) = "TG" arFormDBFields0(2) = "TG" arFormValues0(2) = Request("TG") arFormFields0(3) = "Freq" arFormDBFields0(3) = "Freq" arFormValues0(3) = Request("Freq") arFormFields0(4) = "Type" arFormDBFields0(4) = "Type" arFormValues0(4) = Request("Type") arFormFields0(5) = "Source" arFormDBFields0(5) = "Source" arFormValues0(5) = Request("Source") arFormFields0(6) = "Notes" arFormDBFields0(6) = "Notes" arFormValues0(6) = Request("Notes") arFormFields0(7) = "PL" arFormDBFields0(7) = "PL" arFormValues0(7) = Request("PL") FP_SaveFormFields fp_rs, arFormFields0, arFormDBFields0 If Request.ServerVariables("HTTP_USER_AGENT") <> "" Then FP_SaveFieldToDB fp_rs, Request.ServerVariables("HTTP_USER_AGENT"), "Browser_type" End If If Request.ServerVariables("REMOTE_HOST") <> "" Then FP_SaveFieldToDB fp_rs, Request.ServerVariables("REMOTE_HOST"), "Remote_computer_name" End If FP_SaveFieldToDB fp_rs, Now, "Timestamp" If Request.ServerVariables("REMOTE_USER") <> "" Then FP_SaveFieldToDB fp_rs, Request.ServerVariables("REMOTE_USER"), "User_name" End If fp_rs.Update FP_DumpError strErrorUrl, "Cannot update the database" fp_rs.Close fp_conn.Close FP_FormConfirmation "text/html; charset=windows-1252",_ "Form Confirmation",_ "Thank you for submitting the following information:",_ "scanning.asp",_ "Return to the form." End If End If Session.CodePage = Session("FP_OldCodePage") Session.LCID = Session("FP_OldLCID") %> Scanning


Please help us build a database of active radio frequencies in use in South Florida.   For more information about this Scanner Database project, please contact Adam, KG4PSN

Frequency in MHz        PL/CTCSS/DPL

Agency/Company        Your name/callsign 

System Type                  Talk Group Code (if Trunked)

Use or Channel Name

Notes

Conventional Systems:

 <% fp_sQry="SELECT * FROM Results WHERE (Type = 'Conventional') ORDER BY Agency ASC,Use ASC,Freq ASC" fp_sDefault="" fp_sNoRecords="" fp_sDataConn="scanning" fp_iMaxRecords=0 fp_iCommandType=1 fp_iPageSize=0 fp_fTableFormat=True fp_fMenuFormat=False fp_sMenuChoice="Agency" fp_sMenuValue="Agency" fp_iDisplayCols=7 fp_fCustomQuery=False BOTID=1 fp_iRegion=BOTID %>
Agency Use Freq PL Notes Source Timestamp ID
No records returned.
<%=FP_FieldVal(fp_rs,"Agency")%> <%=FP_FieldVal(fp_rs,"Use")%> <%=FP_FieldVal(fp_rs,"Freq")%> <%=FP_FieldVal(fp_rs,"PL")%> <%=FP_FieldVal(fp_rs,"Notes")%> <%=FP_FieldVal(fp_rs,"Source")%> <%=FP_FieldVal(fp_rs,"Timestamp")%> <%=FP_FieldVal(fp_rs,"ID")%>

Trunk Groups: <% fp_sQry="SELECT * FROM Results WHERE (Type <> 'Conventional') ORDER BY Agency ASC,Use ASC,TG ASC" fp_sDefault="" fp_sNoRecords="" fp_sDataConn="scanning" fp_iMaxRecords=0 fp_iCommandType=1 fp_iPageSize=0 fp_fTableFormat=True fp_fMenuFormat=False fp_sMenuChoice="" fp_sMenuValue="" fp_iDisplayCols=8 fp_fCustomQuery=False BOTID=2 fp_iRegion=BOTID %>
Agency Use TG Type Notes Source Timestamp ID
No records returned.
<%=FP_FieldVal(fp_rs,"Agency")%> <%=FP_FieldVal(fp_rs,"Use")%> <%=FP_FieldVal(fp_rs,"TG")%> <%=FP_FieldVal(fp_rs,"Type")%> <%=FP_FieldVal(fp_rs,"Notes")%> <%=FP_FieldVal(fp_rs,"Source")%> <%=FP_FieldVal(fp_rs,"Timestamp")%> <%=FP_FieldVal(fp_rs,"ID")%>

07/19/03

    © South Florida FM Association, 2003   
   

National Homeland Security Knowledgebase