Unable to find item

Results 1 to 2 of 2

Thread: Unable to find item

  1. #1
    Join Date
    Dec 1969

    Default Unable to find item

    Why would I get an error message that reads. " Item cannot be found in the collection corresponding to the requested name or ordinal." <BR>When the data item is being displayed on the page in the begining?<BR><BR>I have a column that is being displayed at the top of the page, at the bottom of the page I want to write out again, but when I put the table name and column I get the error message. (tblename.columnname), when I just put the column name it&#039;s displayed but both tables have the same column name, and I only want to display only the certain table column.<BR><BR>thanks

  2. #2
    Join Date
    Dec 1969

    Default RE: Unable to find item

    When you do the query use an alias for each of the duplicated names, then you can be sure which one you are referencing i.e.:<BR><BR>&#060;%<BR>strSQL = "SELECT table1.colname AS TableCol1, table2.colname AS TableCol2.."<BR>...<BR>Response.write rs("TableCol1") & rs("TableCol2") <BR>%&#062;<BR><BR>

Posting Permissions

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