Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3

Thread: Pesky code

  1. #1
    New to the CF scene
    Join Date
    Jan 2007
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Pesky code

    Every time I think I figure something out, I get tangled up.

    I was first helped with overcoming the error, "Either EOF or BOF..." error by adding an if/then/esle/end if statement.

    I no longer get an error when there isn't a matching record, but now when a record matches I get this.

    Wrong number of arguments or invalid property assignment: 'Fields.Item(...).Value'

    Please let me know what to do next

    <%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
    <!--#include file="Connections/ProjexDB.asp" -->
    <%
    Dim Recordset1
    Dim Recordset1_cmd
    Dim Recordset1_numRows

    Set Recordset1_cmd = Server.CreateObject ("ADODB.Command")
    Recordset1_cmd.ActiveConnection = MM_ProjexDB_STRING
    Recordset1_cmd.CommandText = "SELECT * FROM Status WHERE Customer = 'asd'"
    Recordset1_cmd.Prepared = true

    Set Recordset1 = Recordset1_cmd.Execute
    Recordset1_numRows = 0
    %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <html xmlns="http://www.w3.org/1999/xhtml">
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
    <title>Untitled Document</title>
    </head>

    <body>
    <%
    if Recordset1.EOF and Recordset1.BOF then
    response.Write ("Empty")
    else
    Recordset1.Fields.Item("Customer").Value
    end if
    %>
    </body>
    </html>
    <%
    Recordset1.Close()
    Set Recordset1 = Nothing
    %>

  • #2
    Smokes a Lot
    Join Date
    Jul 2003
    Location
    CA, USA
    Posts
    1,594
    Thanks
    5
    Thanked 20 Times in 20 Posts
    Try:
    Code:
    Recordset1.Fields("Customer").Value
    Basscyst
    Helping to build a bigger box. - Adam Matthews

  • #3
    Senior Coder
    Join Date
    Nov 2002
    Location
    North-East, UK
    Posts
    1,265
    Thanks
    0
    Thanked 0 Times in 0 Posts
    You are not assigning the recordset variable to anything.
    You need to do something with it

    e.g.
    Code:
    if Recordset1.EOF and Recordset1.BOF then
    response.Write ("Empty")
    else
    Response.Write Recordset1.Fields.Item("Customer").Value
    end if


  •  

    Posting Permissions

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