Visualizzazione dei risultati da 1 a 3 su 3
  1. #1

    Errore ADODB.Field (0x800A0BCD)

    Salve a tutti,
    ho creato con Dreaweaver una pagina di ricerca e una di dettaglio in cui visualizzo i risultati della query su un database.
    L'errore che ottengo in caso di recordest vuoto è:

    Tipo di errore:
    ADODB.Field (0x800A0BCD)
    Il record corrente corrisponde all'inizio o alla fine del file oppure è stato eliminato. Per eseguire l'operazione richiesta è necessario disporre di un record corrente.
    /helpdesk/find_ente.asp, line 241

    Ho inserito nella pagina anche un comportameto server "visualizza se il recordset è vuoto" con un messaggio che indica la mancanza di risultati, però ho comunque questo errore.

    Come posso far visualizzare il corretto messaggio in questo caso, ad esempio facendo ignorare l'errore?
    Grazie

  2. #2
    codice:
    If Recordset.eof Then
        Response.write "Nessun record trovato" ' o quello che ti pare
    End If

  3. #3
    Grazie mille, però (scusa l'ignoranza), dove devo inserire questa stringa? Riporto il codice generato da Dreamweaver MX:

    <%
    var find_ente__MMColParam = "1";
    if (String(Request.QueryString("ente_selected")) != "undefined" &&
    String(Request.QueryString("ente_selected")) != "") {
    find_ente__MMColParam = String(Request.QueryString("ente_selected"));
    }
    %>
    <%
    var find_ente = Server.CreateObject("ADODB.Recordset");
    find_ente.ActiveConnection = MM_Helpdesk_ASP_STRING;
    find_ente.Source = "SELECT * FROM questions WHERE ente_appartenenza = '"+ find_ente__MMColParam.replace(/'/g, "''") + "'";
    find_ente.CursorType = 0;
    find_ente.CursorLocation = 2;
    find_ente.LockType = 1;
    find_ente.Open();
    var find_ente_numRows = 0;
    %>
    <%
    var Repeat1__numRows = 1;
    var Repeat1__index = 0;
    find_ente_numRows += Repeat1__numRows;
    %>
    <%
    // *** Recordset Stats, Move To Record, and Go To Record: declare stats variables

    // set the record count
    var find_ente_total = find_ente.RecordCount;

    // set the number of rows displayed on this page
    if (find_ente_numRows < 0) { // if repeat region set to all records
    find_ente_numRows = find_ente_total;
    } else if (find_ente_numRows == 0) { // if no repeat regions
    find_ente_numRows = 1;
    }

    // set the first and last displayed record
    var find_ente_first = 1;
    var find_ente_last = find_ente_first + find_ente_numRows - 1;

    // if we have the correct record count, check the other stats
    if (find_ente_total != -1) {
    find_ente_numRows = Math.min(find_ente_numRows, find_ente_total);
    find_ente_first = Math.min(find_ente_first, find_ente_total);
    find_ente_last = Math.min(find_ente_last, find_ente_total);
    }
    %>
    <% var MM_paramName = ""; %>
    <%
    // *** Move To Record and Go To Record: declare variables

    var MM_rs = find_ente;
    var MM_rsCount = find_ente_total;
    var MM_size = find_ente_numRows;
    var MM_uniqueCol = "";
    MM_paramName = "";
    var MM_offset = 0;
    var MM_atTotal = false;
    var MM_paramIsDefined = (MM_paramName != "" && String(Request(MM_paramName)) != "undefined");
    %>
    <%
    // *** Move To Record: handle 'index' or 'offset' parameter

    if (!MM_paramIsDefined && MM_rsCount != 0) {

    // use index parameter if defined, otherwise use offset parameter
    r = String(Request("index"));
    if (r == "undefined") r = String(Request("offset"));
    if (r && r != "undefined") MM_offset = parseInt(r);

    // if we have a record count, check if we are past the end of the recordset
    if (MM_rsCount != -1) {
    if (MM_offset >= MM_rsCount || MM_offset == -1) { // past end or move last
    if ((MM_rsCount % MM_size) != 0) { // last page not a full repeat region
    MM_offset = MM_rsCount - (MM_rsCount % MM_size);
    } else {
    MM_offset = MM_rsCount - MM_size;
    }
    }
    }

    // move the cursor to the selected record
    for (var i=0; !MM_rs.EOF && (i < MM_offset || MM_offset == -1); i++) {
    MM_rs.MoveNext();
    }
    if (MM_rs.EOF) MM_offset = i; // set MM_offset to the last possible record
    }
    %>
    <%
    // *** Move To Record: if we dont know the record count, check the display range

    if (MM_rsCount == -1) {

    // walk to the end of the display range for this page
    for (var i=MM_offset; !MM_rs.EOF && (MM_size < 0 || i < MM_offset + MM_size); i++) {
    MM_rs.MoveNext();
    }

    // if we walked off the end of the recordset, set MM_rsCount and MM_size
    if (MM_rs.EOF) {
    MM_rsCount = i;
    if (MM_size < 0 || MM_size > MM_rsCount) MM_size = MM_rsCount;
    }

    // if we walked off the end, set the offset based on page size
    if (MM_rs.EOF && !MM_paramIsDefined) {
    if ((MM_rsCount % MM_size) != 0) { // last page not a full repeat region
    MM_offset = MM_rsCount - (MM_rsCount % MM_size);
    } else {
    MM_offset = MM_rsCount - MM_size;
    }
    }

    // reset the cursor to the beginning
    if (MM_rs.CursorType > 0) {
    if (!MM_rs.BOF) MM_rs.MoveFirst();
    } else {
    MM_rs.Requery();
    }

    // move the cursor to the selected record
    for (var i=0; !MM_rs.EOF && i < MM_offset; i++) {
    MM_rs.MoveNext();
    }
    }
    %>
    <%
    // *** Move To Record: update recordset stats

    // set the first and last displayed record
    find_ente_first = MM_offset + 1;
    find_ente_last = MM_offset + MM_size;
    if (MM_rsCount != -1) {
    find_ente_first = Math.min(find_ente_first, MM_rsCount);
    find_ente_last = Math.min(find_ente_last, MM_rsCount);
    }

    // set the boolean used by hide region to check if we are on the last record
    MM_atTotal = (MM_rsCount != -1 && MM_offset + MM_size >= MM_rsCount);
    %>
    <%
    // *** Go To Record and Move To Record: create strings for maintaining URL and Form parameters

    // create the list of parameters which should not be maintained
    var MM_removeList = "&index=";
    if (MM_paramName != "") MM_removeList += "&" + MM_paramName.toLowerCase() + "=";
    var MM_keepURL="",MM_keepForm="",MM_keepBoth="",MM_kee pNone="";

    // add the URL parameters to the MM_keepURL string
    for (var items=new Enumerator(Request.QueryString); !items.atEnd(); items.moveNext()) {
    var nextItem = "&" + items.item().toLowerCase() + "=";
    if (MM_removeList.indexOf(nextItem) == -1) {
    MM_keepURL += "&" + items.item() + "=" + Server.URLencode(Request.QueryString(items.item()) );
    }
    }

    // add the Form variables to the MM_keepForm string
    for (var items=new Enumerator(Request.Form); !items.atEnd(); items.moveNext()) {
    var nextItem = "&" + items.item().toLowerCase() + "=";
    if (MM_removeList.indexOf(nextItem) == -1) {
    MM_keepForm += "&" + items.item() + "=" + Server.URLencode(Request.Form(items.item()));
    }
    }

    // create the Form + URL string and remove the intial '&' from each of the strings
    MM_keepBoth = MM_keepURL + MM_keepForm;
    if (MM_keepBoth.length > 0) MM_keepBoth = MM_keepBoth.substring(1);
    if (MM_keepURL.length > 0) MM_keepURL = MM_keepURL.substring(1);
    if (MM_keepForm.length > 0) MM_keepForm = MM_keepForm.substring(1);
    %>
    <%
    // *** Move To Record: set the strings for the first, last, next, and previous links

    var MM_moveFirst="",MM_moveLast="",MM_moveNext="",MM_m ovePrev="";
    var MM_keepMove = MM_keepBoth; // keep both Form and URL parameters for moves
    var MM_moveParam = "index";

    // if the page has a repeated region, remove 'offset' from the maintained parameters
    if (MM_size > 1) {
    MM_moveParam = "offset";
    if (MM_keepMove.length > 0) {
    params = MM_keepMove.split("&");
    MM_keepMove = "";
    for (var i=0; i < params.length; i++) {
    var nextItem = params[i].substring(0,params[i].indexOf("="));
    if (nextItem.toLowerCase() != MM_moveParam) {
    MM_keepMove += "&" + params[i];
    }
    }
    if (MM_keepMove.length > 0) MM_keepMove = MM_keepMove.substring(1);
    }
    }

    // set the strings for the move to links
    if (MM_keepMove.length > 0) MM_keepMove += "&";
    var urlStr = Request.ServerVariables("URL") + "?" + MM_keepMove + MM_moveParam + "=";
    MM_moveFirst = urlStr + "0";
    MM_moveLast = urlStr + "-1";
    MM_moveNext = urlStr + (MM_offset + MM_size);
    MM_movePrev = urlStr + Math.max(MM_offset - MM_size,0);
    %>

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.