Problems with mysql data queryies RRS feed

  • Question

  • User-1559208661 posted

    Need this to select all with 1 in online which works.
    need it to post all with 1 online by name sort by level

    currently i cant ewen get it to response.write.

    as you may notice ive been playing with Dreamweaver 4 which is the reason of the MM formatting of the names in conn.

     ******** UPDATED CODE

    <% MM_wowevi_STRING = "Driver={MySQL ODBC 3.51 Driver}; Server=localhost; Database=HIDDEN; Uid=HIDDEN; Pwd=HIDDEN"

    Dim Recordset1__MMColParam
    Recordset1__MMColParam = "1"
    if (Request.Form("0") <> "") then Recordset1__MMColParam = Request.Form("0")

    set Recordset1 = Server.CreateObject("ADODB.Recordset")
    Recordset1.Source = "SELECT name FROM logon.characters WHERE online = 1 + Replace(Recordset1__MMColParam, "'", "''") + ""


          <% Response.Write Now %>

     <% response.write (name) %>



    P.S I just removed ALL HTML formating.
    wondering if i can use something like

    <% do while not eof %>

    funktion such as response.write the list of players with 1 in online sorted by level

    <% wend %>

    or how would i go about that. ?

    Saturday, January 19, 2008 5:21 PM


  • User1073881637 posted

    For debugging purposes. I would write out the sql queries to ensure your statements are formatted correctly.  You can use a reponse.write SQLStatement then copy and paste that into MySQL to ensure it's correct.  If you get an error, then you know something is up with the sql formatting.  I'm not sure how much assistance you'll get debugging an MySQL / DreamWeaver app.

    • Marked as answer by Anonymous Tuesday, September 28, 2021 12:00 AM
    Saturday, January 19, 2008 7:45 PM