<!--#include virtual="/includes/topofpage.asp"-->
<%
If UCase(Request.ServerVariables("REQUEST_METHOD")) = "POST" Then

	Dim SQL1, Conn, RS1, Destination_Text, Convert_Text

Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "DRIVER={SQL Server};SERVER=WEBSRV01;UID=web;pwd=w3bs1t3;DATABASE=AVANTE"

Set RS1 = Server.CreateObject("ADODB.Recordset")

Destination_Text = Server.HTMLEndcode(Request.Form("Dest_Text"))

SQL1 = "[Avante].[dbo].[Add_Destination_Text] @Dest_Id='" & Request.Form("Dest_ID") & "', @Dest_Text='" & Destination_Text & "'"
Conn.Execute (SQL1)

'Response.Write SQL1

End If

%>

<HTML>
<STYLE>
BODY {SCROLLBAR-FACE-COLOR: #5e5ebe; SCROLLBAR-HIGHLIGHT-COLOR: #5e5ebe; SCROLLBAR-SHADOW-COLOR: #5e5ebe; SCROLLBAR-3DLIGHT-COLOR: #5e5ebe; SCROLLBAR-ARROW-COLOR:  #6666CC; SCROLLBAR-TRACK-COLOR: #E3E3E3; SCROLLBAR-DARKSHADOW-COLOR: #666666; }
</STYLE>
<head>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
<TITLE>** ADMIN ONLY ** Create Destination Text</TITLE>
<script language="JavaScript">
<!--
function MM_openBrWindow(theURL,winName,features) { //v2.0
  window.open(theURL,winName,features);
}
//-->
</script>
</HEAD>
<BODY>
<FORM action="Create_Destination_Text.asp" method=post id=form1 name=form1>
<P>
<TABLE cellSpacing=0 cellPadding=1 width=525 border=0 id=TABLE1>
  
  <TR bgColor=#6699cc>
    <TD colSpan=4><B><FONT face="Verdana, Arial, Helvetica, sans-serif" 
      color=#000000 size=2>   
        &nbsp;&nbsp;&nbsp;Create&nbsp;Destination Text</FONT></B></TD></TR>
  <TR>
    <TD align=right width=121 height=24><B><FONT 
      face="Verdana, Arial, Helvetica, sans-serif" size=1>  Destination 
      ID:</FONT></B></TD>
    <TD width=166 height=24><INPUT size=27 name=Dest_ID 
      style="WIDTH: 278px; HEIGHT: 25px" maxLength=50 title=Attribute_Description> <FONT 
      face="Verdana, Arial, Helvetica, sans-serif" color=#000000 size=1><A 
      onclick="MM_openBrWindow('/db-interfaces/Feature_Type_List.asp','','width=560,resizable=yes,scrollbars=yes')" 
      href="#">Available Destination ID's List</A></FONT> </TD>
        </TR>
        
  <TR>
    <TD align=right width=121><B><FONT 
      face="Verdana, Arial, Helvetica, sans-serif" size=1> Destination Text 
      (HTML):</FONT></B></TD>
    <TD width=166>
      <P><TEXTAREA style="WIDTH: 842px; HEIGHT: 438px" tabIndex=3 name=Dest_Text rows=40 cols=120></TEXTAREA>&nbsp;</P> </TD></TR>
  <TR align=middle>
    <TD colSpan=2 height=17>
      <P><INPUT type=submit value="Create Destination Text" name=Submit style="LEFT: 235px; TOP: 1px">
      <INPUT id=CloseWindow style="LEFT: 424px; TOP: 1px" onclick=window.close(); type=button value="Close Window" name=CloseWindow> 
      </P> 
  </TD>
    <TD colSpan=2 height=17></TD></TR></TABLE></P>
</FORM>
</BODY>
</HTML>
