Item cannot be found in the collection corresponding to the requested name or ordinal.

23 Feb 2005 8:20 PM

Dthmtl

I know what this error is, all fieldnames have been verified and reverified.
Not sure why it is happening.

Here is the SQL statement

strSQL = "SELECT Problems.TicketNumber, Activity, ActDate FROM Problems LEFT
JOIN Resolutions ON Problems.TicketNumber = Resolutions.TicketNumber WHERE
Problems.TicketNumber = " & Ticket & " ORDER BY ActDate DESC;"

<td><% = rs("Problems.TicketNumber") %></td>

23 Feb 2005 10:30 AM

Vinod

Show quote

"Dthmtl" <s***@usa.com> wrote in message
news:ukk1nUeGFHA.1740@TK2MSFTNGP09.phx.gbl...
> I know what this error is, all fieldnames have been verified and
reverified.
> Not sure why it is happening.
>
> Here is the SQL statement
>
> strSQL = "SELECT Problems.TicketNumber, Activity, ActDate FROM Problems
LEFT
> JOIN Resolutions ON Problems.TicketNumber = Resolutions.TicketNumber WHERE
> Problems.TicketNumber = " & Ticket & " ORDER BY ActDate DESC;"
>
> <td><% = rs("Problems.TicketNumber") %></td>
>
>
>
>

Hi,

enclose Problems.TicketNumber like this [Problems.TicketNumber] in the sql
statement.
Also try <%=rs(0)%>

regards
vinod

23 Feb 2005 8:34 PM

Ray Costanzo [MVP]

It'd just be called TicketNumber. Or better, use:

<td><%=rs.Fields.Item(0).Value%></td>

Ray at work

Show quote

"Dthmtl" <s***@usa.com> wrote in message
news:ukk1nUeGFHA.1740@TK2MSFTNGP09.phx.gbl...
> I know what this error is, all fieldnames have been verified and
reverified.
> Not sure why it is happening.
>
> Here is the SQL statement
>
> strSQL = "SELECT Problems.TicketNumber, Activity, ActDate FROM Problems
LEFT
> JOIN Resolutions ON Problems.TicketNumber = Resolutions.TicketNumber WHERE
> Problems.TicketNumber = " & Ticket & " ORDER BY ActDate DESC;"
>
> <td><% = rs("Problems.TicketNumber") %></td>
>
>
>
>

24 Feb 2005 11:59 AM

Iain Norman

Show quote

On Wed, 23 Feb 2005 15:20:44 -0500, "Dthmtl" <s***@usa.com> wrote:

>I know what this error is, all fieldnames have been verified and reverified.
>Not sure why it is happening.
>
>Here is the SQL statement
>
>strSQL = "SELECT Problems.TicketNumber, Activity, ActDate FROM Problems LEFT
>JOIN Resolutions ON Problems.TicketNumber = Resolutions.TicketNumber WHERE
>Problems.TicketNumber = " & Ticket & " ORDER BY ActDate DESC;"
>
><td><% = rs("Problems.TicketNumber") %></td>
>
>
>

Response.Write the resulting strSQL to make sure there's nothing silly
about it, usually that makes the mistake apparent in my experience.

--
Iain Norman | http://www.eliteforum.org

24 Feb 2005 4:40 PM

Patrice

You forgot to check field names by dumping rs(i).Name for each field.

Actually ADO uses the Table.Name notation only if there is a conflict. Else
it uses just the field name i..e. TicketNumber...

Patrice

--

Show quote

"Dthmtl" <s***@usa.com> a écrit dans le message de
news:ukk1nUeGFHA.1740@TK2MSFTNGP09.phx.gbl...
> I know what this error is, all fieldnames have been verified and
reverified.
> Not sure why it is happening.
>
> Here is the SQL statement
>
> strSQL = "SELECT Problems.TicketNumber, Activity, ActDate FROM Problems
LEFT
> JOIN Resolutions ON Problems.TicketNumber = Resolutions.TicketNumber WHERE
> Problems.TicketNumber = " & Ticket & " ORDER BY ActDate DESC;"
>
> <td><% = rs("Problems.TicketNumber") %></td>
>
>
>
>