www.webdeveloper.com
Results 1 to 13 of 13

Thread: ASP Database forms

  1. #1
    Join Date
    Jul 2012
    Posts
    8

    ASP Database forms

    I am developing a site in dreaweaver cs4 that searches for business by state using an MS Access data base and a connection string. I cannot get the forms to connect.

    <%@LANGUAGE="JavaScript"%>
    <!--#include virtual="/Connections/avdsmmber.asp" -->
    <%
    var states_cmd = Server.CreateObject ("ADODB.Command");

    states_cmd.ActiveConnection = MM_avdsmmber_STRING;
    states_cmd.CommandText = "SELECT businessname, business_address, businesscity, businessstate, businesszip, businesscountry, businessphone, businessfax, website, email FROM Results ORDER BY businessstate ASC";
    states_cmd.Prepared = true;

    var states = states_cmd.Execute();
    var states_numRows = 0;
    %>
    <%
    var Repeat1__numRows = -1;
    var Repeat1__index = 0;
    states_numRows += Repeat1__numRows;
    %>

    here is the error I get -
    Microsoft JScript compilation error '800a03ec'

    Expected ';'

    /TMP7gglz7tv3j.asp, line 475

    Set statesearch = Nothing
    ----^

  2. #2
    Join Date
    Jan 2008
    Location
    Florida
    Posts
    1,227
    Read your error again. It tells you EXACTLY what you need to do.

  3. #3
    Join Date
    Jul 2012
    Posts
    8

    ASP Help

    There is no line 475 in my code. Not sure what you mean.

  4. #4
    Join Date
    Jun 2012
    Location
    Dark Side of the Moon
    Posts
    70
    I would have to bet money you do, you just aren't understanding. The code line is part of the entire output for the response, so that line includes every line of code you put into the return. So the code lines start at the top of the page and the more and more you write to the response, you are adding new lines. The compiler is being told, "this is my response", and your code is telling it pull a little from here, then a little from here, and in the end it all gets sent as one chunk.

    As far as your error, you specified you are using Javascript in the coding, as per the tag you gave us. Again, I would have to put down cash that you just accidentally forgot to close a statement with the ";", semicolon. So doubt check your code, line by line, especially in the part that has the statesearch var, since that was mentioned in the error, and make sure you closed out your statement. Let us know if you need more help, and the only way we can help would be with more info, like more code, you have some things declared we can see, so we are making guesses for you.
    I love how people get an attitude when THEY asked for help.

  5. #5
    Join Date
    Jul 2012
    Posts
    8
    Here is my code - for the search results page -
    <&#37;@LANGUAGE="JavaScript"%>
    <!--#include virtual="/Connections/avdsmmber.asp" -->
    <%
    var statesearch__MMColParam = "1";
    if (String(Request.QueryString("businessstate")) != "undefined" &&
    String(Request.QueryString("businessstate")) != "") {
    statesearch__MMColParam = String(Request.QueryString("businessstate"));
    }
    %>
    <%
    var statesearch_cmd = Server.CreateObject ("ADODB.Command");
    statesearch_cmd.ActiveConnection = MM_avdsmmber_STRING;
    statesearch_cmd.CommandText = "SELECT businessname, business_address, businesscity, businessstate, businesszip, businesscountry, businessphone, businessfax, website, email FROM Results WHERE businessstate = ? ORDER BY businessstate ASC";
    statesearch_cmd.Prepared = true;
    statesearch_cmd.Parameters.Append(statesearch_cmd.CreateParameter("param1", 200, 1, 255, statesearch__MMColParam)); // adVarChar

    var statesearch = statesearch_cmd.Execute();
    var statesearch_numRows = 0;
    %>
    <%
    var Repeat1__numRows = -1;
    var Repeat1__index = 0;
    states_numRows += Repeat1__numRows;
    %>
    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <!-- saved from url=(0014)about:internet -->
    <html xmlns="http://www.w3.org/1999/xhtml"><!-- InstanceBegin template="/Templates/index1.dwt" codeOutsideHTMLIsLocked="false" -->
    <head>
    <link rel="stylesheet" type="text/css" href="/ddsmoothmenu.css" />
    <link rel="stylesheet" type="text/css" href="/ddsmoothmenu-v.css" />

    <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js"></script>
    <script type="text/javascript" src="/ddsmoothmenu.js">

    /***********************************************
    * Smooth Navigational Menu- (c) Dynamic Drive DHTML code library (www.dynamicdrive.com)
    * This notice MUST stay intact for legal use
    * Visit Dynamic Drive at http://www.dynamicdrive.com/ for full source code
    ***********************************************/

    </script>

    <script type="text/javascript">

    ddsmoothmenu.init({
    mainmenuid: "smoothmenu1", //menu DIV id
    orientation: 'h', //Horizontal or vertical menu: Set to "h" or "v"
    classname: 'ddsmoothmenu', //class added to menu's outer DIV
    //customtheme: ["#1c5a80", "#18374a"],
    contentsource: ["smoothcontainer", "navigations-avds.html"] //"markup" or ["container_id", "path_to_menu_file"]
    })

    ddsmoothmenu.init({
    mainmenuid: "smoothmenu2", //Menu DIV id
    orientation: 'v', //Horizontal or vertical menu: Set to "h" or "v"
    classname: 'ddsmoothmenu-v', //class added to menu's outer DIV
    //customtheme: ["#804000", "#482400"],
    contentsource: "markup" //"markup" or ["container_id", "path_to_menu_file"]
    })

    </script>
    <!-- InstanceBeginEditable name="doctitle" -->
    <title>AVDS | Rescources</title>
    <!-- InstanceEndEditable -->
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <style type="text/css">
    td img {display: block;}body,td,th {
    font: 14px Arial, Helvetica, sans-serif;
    text-decoration: none;
    }
    </style>
    <!--Fireworks CS3 Dreamweaver CS3 target. Created Thu Mar 08 10:11:48 GMT-0600 (Central Standard Time) 2012-->
    <link href="/nav.css" rel="stylesheet" type="text/css" />
    <link href="/Avds.css" rel="stylesheet" type="text/css" />
    <style type="text/css">
    <!--
    #leftSidebar {
    position:absolute;
    width:227px;
    height:839px;
    z-index:1;
    overflow: hidden;
    font: normal 14px/normal Arial, Helvetica, sans-serif;
    text-transform: none;
    text-decoration: none;
    }
    #apDiv1 {
    position:absolute;
    width:586px;
    height:887px;
    overflow: auto;
    }
    body {
    background-image: url(/images/background.jpg);
    }
    a:link {
    text-decoration: none;
    color: #00F;
    font: bold 14px/normal Arial, Helvetica, sans-serif;

    }
    a:visited {
    text-decoration: none;
    color: #000;
    font: normal 14px/normal Arial, Helvetica, sans-serif;
    }
    a:hover {
    text-decoration: none;
    color: #000;
    font: inherit 14px/normal Arial, Helvetica, sans-serif;
    }
    a:active {
    text-decoration: none;
    color: #FFF;
    font: bold 14px/normal Arial, Helvetica, sans-serif;
    }
    -->
    </style>
    <!-- InstanceBeginEditable name="head" -->
    <!-- InstanceEndEditable -->
    <link href="/sm_title.css" rel="stylesheet" type="text/css" />
    <link href="/quick_links.css" rel="stylesheet" type="text/css" />
    <style type="text/css">
    <!--
    a {
    font-family: Arial, Helvetica, sans-serif;
    font-size: 14px;
    font-weight: bold;
    }
    -->
    </style></head>
    <body bgcolor="#ffffff">
    <table width="1052" border="0" align="center" cellpadding="0" cellspacing="0">
    <!-- fwtable fwsrc="index1.png" fwpage="Page 1" fwbase="index1.jpg" fwstyle="Dreamweaver" fwdocid = "1939860397" fwnested="0" -->
    <tr>
    <td><img src="/images/spacer.gif" width="68" height="1" border="0" alt="" /></td>
    <td><img src="/images/spacer.gif" width="32" height="1" border="0" alt="" /></td>
    <td><img src="/images/spacer.gif" width="229" height="1" border="0" alt="" /></td>
    <td><img src="/images/spacer.gif" width="28" height="1" border="0" alt="" /></td>
    <td><img src="/images/spacer.gif" width="586" height="1" border="0" alt="" /></td>
    <td><img src="/images/spacer.gif" width="31" height="1" border="0" alt="" /></td>
    <td><img src="/images/spacer.gif" width="78" height="1" border="0" alt="" /></td>
    <td><img src="/images/spacer.gif" width="1" height="1" border="0" alt="" /></td>
    </tr>

    <tr>
    <td colspan="7"><img name="index1_r1_c1" src="/images/index1_r1_c1.jpg" width="1052" height="21" border="0" id="index1_r1_c1" alt="" /></td>
    <td><img src="/images/spacer.gif" width="1" height="21" border="0" alt="" /></td>
    </tr>
    <tr>
    <td rowspan="5"><img name="index1_r2_c1" src="/images/index1_r2_c1.jpg" width="68" height="1217" border="0" id="index1_r2_c1" alt="" /></td>
    <td colspan="5"><img name="banner" src="/images/banner.jpg" width="906" height="192" border="0" id="banner" alt="" /></td>
    <td rowspan="5"><img name="index1_r2_c7" src="/images/index1_r2_c7.jpg" width="78" height="1217" border="0" id="index1_r2_c7" alt="" /></td>
    <td><img src="/images/spacer.gif" width="1" height="192" border="0" alt="" /></td>
    </tr>
    <tr>
    <td colspan="5" background="/images/nav.jpg"><div align="center" class="sm_title" id="smoothcontainer">
    <noscript>
    <a href="navigations-avds.html"></a>
    </noscript>
    </div></td>
    <td><img src="/images/spacer.gif" width="1" height="37" border="0" alt="" /></td>
    </tr>
    <tr>
    <td colspan="5"><img name="index1_r4_c2" src="/images/index1_r4_c2.jpg" width="906" height="17" border="0" id="index1_r4_c2" alt="" /></td>
    <td><img src="/images/spacer.gif" width="1" height="17" border="0" alt="" /></td>
    </tr>
    <tr>
    <td rowspan="2"><img name="index1_r5_c2" src="/images/index1_r5_c2.jpg" width="32" height="971" border="0" id="index1_r5_c2" alt="" /></td>
    <td align="left" valign="top" background="/images/left_sidebar.jpg"><div id="leftSidebar"><!-- InstanceBeginEditable name="left_sidebar" -->
    <!-- InstanceEndEditable --></div></td>
    <td><img name="index1_r5_c4" src="/images/index1_r5_c4.jpg" width="28" height="888" border="0" id="index1_r5_c4" alt="" /></td>
    <td align="left" valign="top" background="/images/Body.jpg"><div id="apDiv1"><!-- InstanceBeginEditable name="Main" -->
    <table border="1" cellpadding="0" cellspacing="0">
    <tr>
    <td>businessname</td>
    <td><%=(statesearch.Fields.Item("businessname").Value)%></td>
    </tr>
    <% while ((Repeat1__numRows-- != 0) && (!states.EOF)) { %>
    <tr>
    <td>business_address</td>
    <td><%=(statesearch.Fields.Item("business_address").Value)%></td>
    </tr>
    <tr>
    <td>businesscity</td>
    <td><%=(statesearch.Fields.Item("businesscity").Value)%></td>
    </tr>
    <tr>
    <td>businessstate</td>
    <td><%=(statesearch.Fields.Item("businessstate").Value)%></td>
    </tr>
    <tr>
    <td>businesszip</td>
    <td><%=(statesearch.Fields.Item("businesszip").Value)%></td>
    </tr>
    <tr>
    <td>businesscountry</td>
    <td><%=(statesearch.Fields.Item("businesscountry").Value)%></td>
    </tr>
    <tr>
    <td>businessphone</td>
    <td><%=(statesearch.Fields.Item("businessphone").Value)%></td>
    </tr>
    <tr>
    <td>businessfax</td>
    <td><%=(statesearch.Fields.Item("businessfax").Value)%></td>
    </tr>
    <tr>
    <td>website</td>
    <td><%=(statesearch.Fields.Item("website").Value)%></td>
    </tr>
    <tr>
    <td>email</td>
    <td><%=(statesearch.Fields.Item("email").Value)%></td>
    </tr>
    <%
    Repeat1__index++;
    statesearch.MoveNext();
    }
    %>
    </table>
    <!-- InstanceEndEditable --></div></td>
    <td rowspan="2"><img name="index1_r5_c6" src="/images/index1_r5_c6.jpg" width="31" height="971" border="0" id="index1_r5_c6" alt="" /></td>
    <td><img src="/images/spacer.gif" width="1" height="888" border="0" alt="" /></td>
    </tr>
    <tr>
    <td colspan="3"><img src="/images/footer.jpg" alt="" name="footer" width="843" height="83" border="0" usemap="#footerMap" id="footer" /></td>
    <td><img src="/images/spacer.gif" width="1" height="83" border="0" alt="" /></td>
    </tr>
    </table>

    <map name="footerMap" id="footerMap">
    <area shape="rect" coords="71,13,194,25" href="emailto:avds@avds-online.org" />
    </map>
    </body>
    <!-- InstanceEnd --></html>
    <%
    statesearch.Close();
    Set statesearch = Nothing;
    %>

    Any help would be greatly appreciated.

  6. #6
    Join Date
    Jan 2008
    Location
    Florida
    Posts
    1,227
    Looks like you fixed it.

  7. #7
    Join Date
    Jul 2012
    Posts
    8
    Unfortunately not, it still errors out...

  8. #8
    Join Date
    Jan 2008
    Location
    Florida
    Posts
    1,227
    This was your error:


    Expected ';'

    /TMP7gglz7tv3j.asp, line 475

    Set statesearch = Nothing

    But the code you just posted had the semicolon on that line as far as I can tell. Post your code for line 475

  9. #9
    Join Date
    Jul 2012
    Posts
    8
    There is no line for 475....the code stops at 275

  10. #10
    Join Date
    Jan 2008
    Location
    Florida
    Posts
    1,227
    If your error is:

    /TMP7gglz7tv3j.asp, line 475

    Than there most definitely is a line 475 in TMP7gglz7tv3j.asp

  11. #11
    Join Date
    Jul 2012
    Posts
    8
    Here is the new error...Microsoft JScript compilation error '800a03ea'

    Syntax error

    /TMP2id398hrpu.asp, line 473

    }
    ^
    Here is the code it end at line 242...
    <%@LANGUAGE="JavaScript"%>
    <!--#include virtual="/Connections/avdsmmber.asp" -->
    <%
    var statesearch_cmd = Server.CreateObject ("ADODB.Command");
    statesearch_cmd.ActiveConnection = MM_avdsmmber_STRING;
    statesearch_cmd.CommandText = "SELECT businessname, business_address, businesscity, businessstate, businesszip, businesscountry, businessphone, businessfax, website, email FROM Publicinfo ORDER BY businessstate ASC";
    statesearch_cmd.Prepared = true;

    var statesearch = statesearch_cmd.Execute();
    var statesearch_numRows = 0;
    %>
    <%
    var Repeat2__numRows = 10;
    var Repeat2__index = 0;
    statesearch_numRows += Repeat2__numRows;
    %>
    <%
    var Repeat2__numRows = -1;
    var Repeat2__index = 0;
    statesearch_numRows += Repeat2__numRows;
    %>
    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <!-- saved from url=(0014)about:internet -->
    <html xmlns="http://www.w3.org/1999/xhtml"><!-- InstanceBegin template="/Templates/index1.dwt" codeOutsideHTMLIsLocked="false" -->
    <head>
    <link rel="stylesheet" type="text/css" href="/ddsmoothmenu.css" />
    <link rel="stylesheet" type="text/css" href="/ddsmoothmenu-v.css" />

    <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js"></script>
    <script type="text/javascript" src="/ddsmoothmenu.js">

    /***********************************************
    * Smooth Navigational Menu- (c) Dynamic Drive DHTML code library (www.dynamicdrive.com)
    * This notice MUST stay intact for legal use
    * Visit Dynamic Drive at http://www.dynamicdrive.com/ for full source code
    ***********************************************/

    </script>

    <script type="text/javascript">

    ddsmoothmenu.init({
    mainmenuid: "smoothmenu1", //menu DIV id
    orientation: 'h', //Horizontal or vertical menu: Set to "h" or "v"
    classname: 'ddsmoothmenu', //class added to menu's outer DIV
    //customtheme: ["#1c5a80", "#18374a"],
    contentsource: ["smoothcontainer", "navigations-avds.html"] //"markup" or ["container_id", "path_to_menu_file"]
    })

    ddsmoothmenu.init({
    mainmenuid: "smoothmenu2", //Menu DIV id
    orientation: 'v', //Horizontal or vertical menu: Set to "h" or "v"
    classname: 'ddsmoothmenu-v', //class added to menu's outer DIV
    //customtheme: ["#804000", "#482400"],
    contentsource: "markup" //"markup" or ["container_id", "path_to_menu_file"]
    })

    </script>
    <!-- InstanceBeginEditable name="doctitle" -->
    <title>AVDS | Rescources</title>
    <!-- InstanceEndEditable -->
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <style type="text/css">
    td img {display: block;}body,td,th {
    font: 14px Arial, Helvetica, sans-serif;
    text-decoration: none;
    }
    </style>
    <!--Fireworks CS3 Dreamweaver CS3 target. Created Thu Mar 08 10:11:48 GMT-0600 (Central Standard Time) 2012-->
    <link href="/nav.css" rel="stylesheet" type="text/css" />
    <link href="/Avds.css" rel="stylesheet" type="text/css" />
    <style type="text/css">
    <!--
    #leftSidebar {
    position:absolute;
    width:227px;
    height:839px;
    z-index:1;
    overflow: hidden;
    font: normal 14px/normal Arial, Helvetica, sans-serif;
    text-transform: none;
    text-decoration: none;
    }
    #apDiv1 {
    position:absolute;
    width:586px;
    height:887px;
    overflow: auto;
    }
    body {
    background-image: url(/images/background.jpg);
    }
    a:link {
    text-decoration: none;
    color: #00F;
    font: bold 14px/normal Arial, Helvetica, sans-serif;

    }
    a:visited {
    text-decoration: none;
    color: #000;
    font: normal 14px/normal Arial, Helvetica, sans-serif;
    }
    a:hover {
    text-decoration: none;
    color: #000;
    font: inherit 14px/normal Arial, Helvetica, sans-serif;
    }
    a:active {
    text-decoration: none;
    color: #FFF;
    font: bold 14px/normal Arial, Helvetica, sans-serif;
    }
    -->
    </style>
    <!-- InstanceBeginEditable name="head" -->
    <!-- InstanceEndEditable -->
    <link href="/sm_title.css" rel="stylesheet" type="text/css" />
    <link href="/quick_links.css" rel="stylesheet" type="text/css" />
    <style type="text/css">
    <!--
    a {
    font-family: Arial, Helvetica, sans-serif;
    font-size: 14px;
    font-weight: bold;
    }
    -->
    </style></head>
    <body bgcolor="#ffffff">
    <table width="1052" border="0" align="center" cellpadding="0" cellspacing="0">
    <!-- fwtable fwsrc="index1.png" fwpage="Page 1" fwbase="index1.jpg" fwstyle="Dreamweaver" fwdocid = "1939860397" fwnested="0" -->
    <tr>
    <td><img src="/images/spacer.gif" width="68" height="1" border="0" alt="" /></td>
    <td><img src="/images/spacer.gif" width="32" height="1" border="0" alt="" /></td>
    <td><img src="/images/spacer.gif" width="229" height="1" border="0" alt="" /></td>
    <td><img src="/images/spacer.gif" width="28" height="1" border="0" alt="" /></td>
    <td><img src="/images/spacer.gif" width="586" height="1" border="0" alt="" /></td>
    <td><img src="/images/spacer.gif" width="31" height="1" border="0" alt="" /></td>
    <td><img src="/images/spacer.gif" width="78" height="1" border="0" alt="" /></td>
    <td><img src="/images/spacer.gif" width="1" height="1" border="0" alt="" /></td>
    </tr>

    <tr>
    <td colspan="7"><img name="index1_r1_c1" src="/images/index1_r1_c1.jpg" width="1052" height="21" border="0" id="index1_r1_c1" alt="" /></td>
    <td><img src="/images/spacer.gif" width="1" height="21" border="0" alt="" /></td>
    </tr>
    <tr>
    <td rowspan="5"><img name="index1_r2_c1" src="/images/index1_r2_c1.jpg" width="68" height="1217" border="0" id="index1_r2_c1" alt="" /></td>
    <td colspan="5"><img name="banner" src="/images/banner.jpg" width="906" height="192" border="0" id="banner" alt="" /></td>
    <td rowspan="5"><img name="index1_r2_c7" src="/images/index1_r2_c7.jpg" width="78" height="1217" border="0" id="index1_r2_c7" alt="" /></td>
    <td><img src="/images/spacer.gif" width="1" height="192" border="0" alt="" /></td>
    </tr>
    <tr>
    <td colspan="5" background="/images/nav.jpg"><div align="center" class="sm_title" id="smoothcontainer">
    <noscript>
    <a href="navigations-avds.html"></a>
    </noscript>
    </div></td>
    <td><img src="/images/spacer.gif" width="1" height="37" border="0" alt="" /></td>
    </tr>
    <tr>
    <td colspan="5"><img name="index1_r4_c2" src="/images/index1_r4_c2.jpg" width="906" height="17" border="0" id="index1_r4_c2" alt="" /></td>
    <td><img src="/images/spacer.gif" width="1" height="17" border="0" alt="" /></td>
    </tr>
    <tr>
    <td rowspan="2"><img name="index1_r5_c2" src="/images/index1_r5_c2.jpg" width="32" height="971" border="0" id="index1_r5_c2" alt="" /></td>
    <td align="left" valign="top" background="/images/left_sidebar.jpg"><div id="leftSidebar"><!-- InstanceBeginEditable name="left_sidebar" -->
    <!-- InstanceEndEditable --></div></td>
    <td><img name="index1_r5_c4" src="/images/index1_r5_c4.jpg" width="28" height="888" border="0" id="index1_r5_c4" alt="" /></td>
    <td align="left" valign="top" background="/images/Body.jpg"><div id="apDiv1"><!-- InstanceBeginEditable name="Main" -->
    <p>&nbsp;</p>
    <table border="1" cellpadding="0" cellspacing="0">
    <tr>
    <td>businessname</td>
    <td><%=(statesearch.Fields.Item("businessname").Value)%></td>
    </tr>
    <tr>
    <td>business_address</td>
    <td><%=(statesearch.Fields.Item("business_address").Value)%></td>
    </tr>
    <tr>
    <td>businesscity</td>
    <td><%=(statesearch.Fields.Item("businesscity").Value)%></td>
    </tr>
    <tr>
    <td>businessstate</td>
    <td><%=(statesearch.Fields.Item("businessstate").Value)%></td>
    </tr>
    <tr>
    <td>businesszip</td>
    <td><%=(statesearch.Fields.Item("businesszip").Value)%></td>
    </tr>
    <tr>
    <td>businesscountry</td>
    <td><%=(statesearch.Fields.Item("businesscountry").Value)%></td>
    </tr>
    <tr>
    <td>businessphone</td>
    <td><%=(statesearch.Fields.Item("businessphone").Value)%></td>
    </tr>
    <tr>
    <td>businessfax</td>
    <td><%=(statesearch.Fields.Item("businessfax").Value)%></td>
    </tr>
    <tr>
    <td>website</td>
    <td><%=(statesearch.Fields.Item("website").Value)%></td>
    </tr>
    <tr>
    <td>email</td>
    <td><%=(statesearch.Fields.Item("email").Value)%></td>
    </tr>
    <%
    Repeat1__index++;
    statesearch.MoveNext();
    }
    %>
    </table>
    <p>&nbsp;</p>
    <!-- InstanceEndEditable --></div></td>
    <td rowspan="2"><img name="index1_r5_c6" src="/images/index1_r5_c6.jpg" width="31" height="971" border="0" id="index1_r5_c6" alt="" /></td>
    <td><img src="/images/spacer.gif" width="1" height="888" border="0" alt="" /></td>
    </tr>
    <tr>
    <td colspan="3"><img src="/images/footer.jpg" alt="" name="footer" width="843" height="83" border="0" usemap="#footerMap" id="footer" /></td>
    <td><img src="/images/spacer.gif" width="1" height="83" border="0" alt="" /></td>
    </tr>
    </table>

    <map name="footerMap" id="footerMap">
    <area shape="rect" coords="71,13,194,25" href="emailto:avds@avds-online.org" />
    </map>
    </body>
    <!-- InstanceEnd --></html>
    <%
    statesearch.Close();
    %>
    <%
    statesearch.Close();
    "delete statesearch;"
    %>

  12. #12
    Join Date
    Jan 2008
    Location
    Florida
    Posts
    1,227
    Looks like you have an ambiguous bracket here:

    <&#37;
    Repeat1__index++;
    statesearch.MoveNext();
    }
    %>

  13. #13
    Join Date
    Jul 2012
    Posts
    8
    Thank you, looks so obvious after you point it out......now a new error....

    Microsoft OLE DB Provider for ODBC Drivers error '80004005'

    [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xd98 Thread 0x19fc DBC 0x1954f94 Jet'.

    /TMPladfs8ig1w.asp, line 5

    code from line 5..
    statesearch_cmd.ActiveConnection = MM_avdsmmber_STRING;

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles