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

[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>

[Ray Costanzo [MVP]]

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

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

Ray at work

"Dthmtl" <sr**@usa.com> wrote in message
news:uk**************@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>

[Vinod]

"Dthmtl" <sr**@usa.com> wrote in message
news:uk**************@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

[Iain Norman]

On Wed, 23 Feb 2005 15:20:44 -0500, "Dthmtl" <sr**@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

[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

--

"Dthmtl" <sr**@usa.com> a écrit dans le message de
news:uk**************@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>