Visualizzazione dei risultati da 1 a 4 su 4
  1. #1
    Utente di HTML.it
    Registrato dal
    Apr 2001
    Messaggi
    32

    errore:ADODB.Recordset error '800a0bb9'

    Ciao a tutti,
    potete aiutarmi a risolvere questo errore?
    lo script risiede su win2003 server ed è un opensource ocean12
    grazie in anticipo


    ADODB.Recordset error '800a0bb9'

    Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.

    /newsletter/send.asp, line 158


    __________________________________________________






    <html>
    <head>
    <title><%=RSBODY("List_Name")%></title>

    <script language="javascript">

    function open_Code_Heading_Text() {
    popupWin = window.open('help.asp?ID=Code_Heading_Text', 'remote', 'width=300,height=200')
    }
    function open_Code_Heading_BG() {
    popupWin = window.open('help.asp?ID=Code_Heading_BG', 'remote', 'width=300,height=200')
    }
    function open_Code_Body_Text() {
    popupWin = window.open('help.asp?ID=Code_Body_Text', 'remote', 'width=300,height=200')
    }
    function open_Code_Body_BG() {
    popupWin = window.open('help.asp?ID=Code_Body_BG', 'remote', 'width=300,height=200')
    }
    function open_Code_Border() {
    popupWin = window.open('help.asp?ID=Code_Border', 'remote', 'width=300,height=200')
    }

    </script>



    </head>
    <body bgcolor="#F0F0F0" vlink="#48576C" link="#48576C" alink="#000000">
    <table border="0" cellpadding="0" cellspacing="0" width="650" align="center">
    <tr>
    <td height="1" colspan="5" bgcolor="#000000">[img]im/clear.gif[/img]</td>
    </tr>

    <tr>
    <td width="1" bgcolor="#000000">[img]im/clear.gif[/img]</td>
    <td colspan="3" bgcolor="#52637B" height="35" width="648"><font face="Verdana" size="5" color="#FFCC00"><%=RSBODY("List_Name")%></font></td>
    <td width="1" bgcolor="#000000">[img]im/clear.gif[/img]</td>
    </tr>

    <tr>
    <td height="1" colspan="5" bgcolor="#000000">[img]im/clear.gif[/img]</td>
    </tr>

    <tr>
    <td width="1" bgcolor="#000000">[img]im/clear.gif[/img]</td>
    <td bgcolor="#8199DA" valign="top" width="130">

    <table border="0" cellpadding="0" cellspacing="0" width="130">
    <tr>
    <td bgcolor="#B0C4DE" width="130" height="15"><font face="Verdana" size="1">Home</font></td>
    </tr>
    <tr>
    <td bgcolor="#000000" height="1">[img]im/clear.gif[/img]</td>
    </tr>

    <tr>
    <td height="5">[img]im/clear.gif[/img]</td>
    </tr>
    <tr>
    <td bgcolor="#000000" height="1">[img]im/clear.gif[/img]</td>
    </tr>

    <tr>
    <td bgcolor="#B0C4DE" width="130" height="15"><font face="Verdana" size="1">SendMailing</font></td>
    </tr>
    <tr>
    <td bgcolor="#000000" height="1">[img]im/clear.gif[/img]</td>
    </tr>

    <tr>
    <td bgcolor="#B0C4DE" width="130" height="15"><font face="Verdana" size="1">View/EditSubscribers</font></td>
    </tr>
    <tr>
    <td bgcolor="#000000" height="1">[img]im/clear.gif[/img]</td>
    </tr>

    <tr>
    <td bgcolor="#B0C4DE" width="130" height="15"><font face="Verdana" size="1">GenerateHTML</font></td>
    </tr>
    <tr>
    <td bgcolor="#000000" height="1">[img]im/clear.gif[/img]</td>
    </tr>

    <tr>
    <td bgcolor="#B0C4DE" width="130" height="15"><font face="Verdana" size="1">MailArchive</font></td>
    </tr>
    <tr>
    <td bgcolor="#000000" height="1">[img]im/clear.gif[/img]</td>
    </tr>

    <tr>
    <td height="5">[img]im/clear.gif[/img]</td>
    </tr>
    <tr>
    <td bgcolor="#000000" height="1">[img]im/clear.gif[/img]</td>
    </tr>

    <tr>
    <td bgcolor="#B0C4DE" width="130" height="15"><font face="Verdana" size="1">Settings</font></td>
    </tr>
    <tr>
    <td bgcolor="#000000" height="1">[img]im/clear.gif[/img]</td>
    </tr>


    <tr>
    <td bgcolor="#B0C4DE" width="130" height="15"><font face="Verdana" size="1">Documentation</font></td>
    </tr>
    <tr>
    <td bgcolor="#000000" height="1">[img]im/clear.gif[/img]</td>
    </tr>

    <tr>
    <td height="5">[img]im/clear.gif[/img]</td>
    </tr>
    <tr>
    <td bgcolor="#000000" height="1">[img]im/clear.gif[/img]</td>
    </tr>

    <tr>
    <td bgcolor="#B0C4DE" width="130" height="15"><font face="Verdana" size="1">LogOut</font></td>
    </tr>
    <tr>
    <td bgcolor="#000000" height="1">[img]im/clear.gif[/img]</td>
    </tr>
    </table>

    </td>
    <td width="1" bgcolor="#000000">[img]im/clear.gif[/img]</td>
    <td bgcolor="#FFFFFF" width="100%" valign="top" height="200">

    <table border="0" cellpadding="0" cellspacing="0" width="100%">
    <tr>
    <td bgcolor="#B0C4DE" height="15" width="100%"><font face="Verdana" size="1" color="#000000">Send Mailing</font></td>
    </tr>
    <tr>
    <td bgcolor="#000000" height="1" width="100%">[img]im/clear.gif[/img]</td>
    </tr>
    </table>

    <table border="0" cellpadding="2" cellspacing="0" width="100%">
    <tr>
    <td width="100%">



    <%
    SQLIF = "SELECT ID FROM List"
    Set RSIF = Server.CreateObject("ADODB.Recordset")
    RSIF.Open SQLIF, Conn, 1, 3

    If NOT (RSIF.BOF AND RSIF.EOF) Then%>

    <form action="send2.asp" Method="Post">
    <table border="0" cellpadding="3" cellspacing="0" align="center">
    <%
    Set RS = Server.CreateObject("ADODB.Recordset")
    SQL = "SELECT * from Settings"
    RS.Open SQL, Conn, 1, 3
    %>
    <tr>
    <td bgcolor="#DAE3F0"><font face="Verdana" size="1">Subject:</font></td>
    <td bgcolor="#DAE3F0"><input type="text" name="Subject" class="inputbox" size="40"></td>
    </tr>
    <tr>
    <td bgcolor="#C5D3E7"><font face="Verdana" size="1">Format:</font></td>
    <td bgcolor="#C5D3E7"><select name="Format" class="inputbox">
    <option value="Text">Text</option>
    <option value="HTML">HTML</option>
    </select></td>
    </tr>
    <tr>
    <td bgcolor="#DAE3F0"><font face="Verdana" size="1">Archive Message:</font></td>
    <td bgcolor="#DAE3F0"><input type="checkbox" name="Archive" checked></td>
    </tr>
    <tr>
    <td bgcolor="#C5D3E7" colspan="2"><font face="Verdana" size="1">Body:

    <textarea name="Body" class="inputbox" cols="80" rows="25"></textarea>
    </font></td>
    </tr>
    <tr>
    <td colspan="2"><input type="submit" name="Submit" value="Send" class="inputSubmit"></td>
    </tr>
    </table>
    </form>

    <%Else%>
    <center><font face="Verdana" size="1">There are currently no subscribers.</font></center><%End If%>

    </td>
    </tr>
    </table></td>
    <td width="1" bgcolor="#000000">[img]im/clear.gif[/img]</td>
    </tr>

    <tr>
    <td height="1" colspan="5" bgcolor="#000000">[img]im/clear.gif[/img]</td>
    </tr>



    <tr>
    <td width="1" bgcolor="#000000">[img]im/clear.gif[/img]</td>
    <td colspan="3" align="center" bgcolor="#B0C4DE" height="30"><font face="Verdana" size="1">Maintained with the Ocean12 ASP Mailing List Manager v1.06
    &copy;2001-2002 Ocean12 Technologies, all rights reserved.</font></td>
    <td width="1" bgcolor="#000000">[img]im/clear.gif[/img]</td>
    </tr>


    <tr>
    <td height="1" colspan="5" bgcolor="#000000">[img]im/clear.gif[/img]</td>
    </tr>
    </table>


    </body>
    </html>

  2. #2
    metti in grassetto la linea incriminata che ci vengono gli occhi storti a forza di contare le righe, e il codice postalo tra i tag code ....
    se non è bello ciò che è bello figuriamoci ciò che è brutto!!



    fai anche tu come me: indenta il codice!!!!

  3. #3
    Utente di HTML.it
    Registrato dal
    Apr 2001
    Messaggi
    32
    Si scusa hai ragione:-)
    ti posto l'errore evidenziato in grassetto
    grazie




    <html>
    <head>
    <title><%=RSBODY("List_Name")%></title>

    <script language="javascript">

    function open_Code_Heading_Text() {
    popupWin = window.open('help.asp?ID=Code_Heading_Text', 'remote', 'width=300,height=200')
    }
    function open_Code_Heading_BG() {
    popupWin = window.open('help.asp?ID=Code_Heading_BG', 'remote', 'width=300,height=200')
    }
    function open_Code_Body_Text() {
    popupWin = window.open('help.asp?ID=Code_Body_Text', 'remote', 'width=300,height=200')
    }
    function open_Code_Body_BG() {
    popupWin = window.open('help.asp?ID=Code_Body_BG', 'remote', 'width=300,height=200')
    }
    function open_Code_Border() {
    popupWin = window.open('help.asp?ID=Code_Border', 'remote', 'width=300,height=200')
    }

    </script>



    </head>
    <body bgcolor="#F0F0F0" vlink="#48576C" link="#48576C" alink="#000000">
    <table border="0" cellpadding="0" cellspacing="0" width="650" align="center">
    <tr>
    <td height="1" colspan="5" bgcolor="#000000">[img]im/clear.gif[/img]</td>
    </tr>

    <tr>
    <td width="1" bgcolor="#000000">[img]im/clear.gif[/img]</td>
    <td colspan="3" bgcolor="#52637B" height="35" width="648"><font face="Verdana" size="5" color="#FFCC00"><%=RSBODY("List_Name")%></font></td>
    <td width="1" bgcolor="#000000">[img]im/clear.gif[/img]</td>
    </tr>

    <tr>
    <td height="1" colspan="5" bgcolor="#000000">[img]im/clear.gif[/img]</td>
    </tr>

    <tr>
    <td width="1" bgcolor="#000000">[img]im/clear.gif[/img]</td>
    <td bgcolor="#8199DA" valign="top" width="130">

    <table border="0" cellpadding="0" cellspacing="0" width="130">
    <tr>
    <td bgcolor="#B0C4DE" width="130" height="15"><font face="Verdana" size="1">Home</font></td>
    </tr>
    <tr>
    <td bgcolor="#000000" height="1">[img]im/clear.gif[/img]</td>
    </tr>

    <tr>
    <td height="5">[img]im/clear.gif[/img]</td>
    </tr>
    <tr>
    <td bgcolor="#000000" height="1">[img]im/clear.gif[/img]</td>
    </tr>

    <tr>
    <td bgcolor="#B0C4DE" width="130" height="15"><font face="Verdana" size="1">SendMailing</font></td>
    </tr>
    <tr>
    <td bgcolor="#000000" height="1">[img]im/clear.gif[/img]</td>
    </tr>

    <tr>
    <td bgcolor="#B0C4DE" width="130" height="15"><font face="Verdana" size="1">View/EditSubscribers</font></td>
    </tr>
    <tr>
    <td bgcolor="#000000" height="1">[img]im/clear.gif[/img]</td>
    </tr>

    <tr>
    <td bgcolor="#B0C4DE" width="130" height="15"><font face="Verdana" size="1">GenerateHTML</font></td>
    </tr>
    <tr>
    <td bgcolor="#000000" height="1">[img]im/clear.gif[/img]</td>
    </tr>

    <tr>
    <td bgcolor="#B0C4DE" width="130" height="15"><font face="Verdana" size="1">MailArchive</font></td>
    </tr>
    <tr>
    <td bgcolor="#000000" height="1">[img]im/clear.gif[/img]</td>
    </tr>

    <tr>
    <td height="5">[img]im/clear.gif[/img]</td>
    </tr>
    <tr>
    <td bgcolor="#000000" height="1">[img]im/clear.gif[/img]</td>
    </tr>

    <tr>
    <td bgcolor="#B0C4DE" width="130" height="15"><font face="Verdana" size="1">Settings</font></td>
    </tr>
    <tr>
    <td bgcolor="#000000" height="1">[img]im/clear.gif[/img]</td>
    </tr>

    <tr>
    <td bgcolor="#B0C4DE" width="130" height="15"><font face="Verdana" size="1">Support</font></td>
    </tr>
    <tr>
    <td bgcolor="#000000" height="1">[img]im/clear.gif[/img]</td>
    </tr>

    <tr>
    <td bgcolor="#B0C4DE" width="130" height="15"><font face="Verdana" size="1">Documentation</font></td>
    </tr>
    <tr>
    <td bgcolor="#000000" height="1">[img]im/clear.gif[/img]</td>
    </tr>

    <tr>
    <td height="5">[img]im/clear.gif[/img]</td>
    </tr>
    <tr>
    <td bgcolor="#000000" height="1">[img]im/clear.gif[/img]</td>
    </tr>

    <tr>
    <td bgcolor="#B0C4DE" width="130" height="15"><font face="Verdana" size="1">LogOut</font></td>
    </tr>
    <tr>
    <td bgcolor="#000000" height="1">[img]im/clear.gif[/img]</td>
    </tr>
    </table>

    </td>
    <td width="1" bgcolor="#000000">[img]im/clear.gif[/img]</td>
    <td bgcolor="#FFFFFF" width="100%" valign="top" height="200">

    <table border="0" cellpadding="0" cellspacing="0" width="100%">
    <tr>
    <td bgcolor="#B0C4DE" height="15" width="100%"><font face="Verdana" size="1" color="#000000">Send Mailing</font></td>
    </tr>
    <tr>
    <td bgcolor="#000000" height="1" width="100%">[img]im/clear.gif[/img]</td>
    </tr>
    </table>

    <table border="0" cellpadding="2" cellspacing="0" width="100%">
    <tr>
    <td width="100%">



    <%
    SQLIF = "SELECT ID FROM List"
    Set RSIF = Server.CreateObject("ADODB.Recordset")
    RSIF.Open SQLIF, Conn, 1, 3

    If NOT (RSIF.BOF AND RSIF.EOF) Then%>

    <form action="send2.asp" Method="Post">
    <table border="0" cellpadding="3" cellspacing="0" align="center">
    <%
    Set RS = Server.CreateObject("ADODB.Recordset")
    SQL = "SELECT * from Settings"
    RS.Open SQL, Conn, 1, 3

    %>
    <tr>
    <td bgcolor="#DAE3F0"><font face="Verdana" size="1">Subject:</font></td>
    <td bgcolor="#DAE3F0"><input type="text" name="Subject" class="inputbox" size="40"></td>
    </tr>
    <tr>
    <td bgcolor="#C5D3E7"><font face="Verdana" size="1">Format:</font></td>
    <td bgcolor="#C5D3E7"><select name="Format" class="inputbox">
    <option value="Text">Text</option>
    <option value="HTML">HTML</option>
    </select></td>
    </tr>
    <tr>
    <td bgcolor="#DAE3F0"><font face="Verdana" size="1">Archive Message:</font></td>
    <td bgcolor="#DAE3F0"><input type="checkbox" name="Archive" checked></td>
    </tr>
    <tr>
    <td bgcolor="#C5D3E7" colspan="2"><font face="Verdana" size="1">Body:

    <textarea name="Body" class="inputbox" cols="80" rows="25"></textarea>
    </font></td>
    </tr>
    <tr>
    <td colspan="2"><input type="submit" name="Submit" value="Send" class="inputSubmit"></td>
    </tr>
    </table>
    </form>

    <%Else%>
    <center><font face="Verdana" size="1">There are currently no subscribers.</font></center><%End If%>

    </td>
    </tr>
    </table></td>
    <td width="1" bgcolor="#000000">[img]im/clear.gif[/img]</td>
    </tr>

    <tr>
    <td height="1" colspan="5" bgcolor="#000000">[img]im/clear.gif[/img]</td>
    </tr>



    <tr>
    <td width="1" bgcolor="#000000">[img]im/clear.gif[/img]</td>
    <td colspan="3" align="center" bgcolor="#B0C4DE" height="30"><font face="Verdana" size="1">Maintained with the Ocean12 ASP Mailing List Manager v1.06
    &copy;2001-2002 Ocean12 Technologies, all rights reserved.</font></td>
    <td width="1" bgcolor="#000000">[img]im/clear.gif[/img]</td>
    </tr>


    <tr>
    <td height="1" colspan="5" bgcolor="#000000">[img]im/clear.gif[/img]</td>
    </tr>
    </table>


    </body>
    </html>

  4. #4
    sei sicuro che in nessuno dei tre file inclusi ad inizio pagina non ci sia un recordset che si chiami rs? ...prova anche solo per un attimo a cambiargli nome, chiamalo ciccio vediamo che succede!!!
    se non è bello ciò che è bello figuriamoci ciò che è brutto!!



    fai anche tu come me: indenta il codice!!!!

Permessi di invio

  • Non puoi inserire discussioni
  • Non puoi inserire repliche
  • Non puoi inserire allegati
  • Non puoi modificare i tuoi messaggi
  •  
Powered by vBulletin® Version 4.2.1
Copyright © 2025 vBulletin Solutions, Inc. All rights reserved.