Re: Bugged by an easy problem for someone


"Stephen Howe" <sjhoweATdialDOTpipexDOTcom> wrote in message
news:O7uz$uFzFHA.2516@xxxxxxxxxxxxxxxxxxxxxxx
>
>> Question is why cannot I refer to the field in question useing
>> oData.fields("Products.Name").value?
>
> Because "Products" is the Table Name and I imagine that is stripped as
> part of the name for the field of the Recordset as are all other table
> names.
>
> I wonder if both "Products.Name", "DrinkType.Name" wind up being called
> Name or whether ADO attaches a suffix?
>
> Stephen Howe
>

I also grabbed the field names from the recordset as a test and the field
was correctly named Products.Name.
If I use oData.fields("Name").value it returns the DrinkType and not product
name.

Confused :/


.

Relevant Pages

  • Bugged by an easy problem for someone
    ... Set oData = Server.CreateObject ... Ok this part of the code is all working fine and returns the recordset ... If I change the SQL statement to sSQL = "SELECT Products.ProdID, ... Question is why cannot I refer to the field in question useing ...
    (microsoft.public.data.ado)
  • Re: Bugged by an easy problem for someone
    ... > Question is why cannot I refer to the field in question useing ... Because "Products" is the Table Name and I imagine that is stripped as part ... Prev by Date: ...
    (microsoft.public.data.ado)