Duplicate fieldnames in Datareader

[Beren]

Hello,

I have an sproc to query a couple of tables, that have the same fieldnames,
for example DateCreated.

-------------------------------------
Select a.* , b.* From tablea a
Join table b On b.keyfield = a.keyfield
-------------------------------------

Now table A and B both have a field called "DateCreated", and I need both
values in my application.

-------------------------------------
.....-- New DataReader dr --....
.....-- query --....
DateCreatedA = dr.Item("a.DateCreated")
DateCreatedB = dr.Item("b.DateCreated")
-------------------------------------

Doesn't seem to work, but

-------------------------------------
SomeVariable = dr.Item("DateCreated")
-------------------------------------

does work, but only for one value...

When I check the resultset in Query Analyzer, it shows duplicate fieldnames,
so that's probably why the DR doesn't swallow my brave attempts with
"a.DateCreated" and "b.Da..."

Can someone help me out getting both values ?

Beren.

[William F. Robertson, Jr.]

Beren,

It really isn't good design to have * pulled from a table. You should also
give each returning column a unique name. Otherwise it will pull the first
occurrece when you use dr.Item("DateCreated").

All the columns are in there.

for i = 0 to dr.FieldCount
Response.Write( dr.GetName( i ) )
next

it will list all the field names and show two for DateCreated.

So you could reference each of the DateCreated columns by using the ordinal.

HTH,

bill

"Beren" <be***@angband.me> wrote in message
news:xb*********************@phobos.telenet-ops.be...

Hello,

I have an sproc to query a couple of tables, that have the same fieldnames, for example DateCreated.

-------------------------------------
Select a.* , b.* From tablea a
Join table b On b.keyfield = a.keyfield
-------------------------------------

Now table A and B both have a field called "DateCreated", and I need both
values in my application.

-------------------------------------
....-- New DataReader dr --....
....-- query --....
DateCreatedA = dr.Item("a.DateCreated")
DateCreatedB = dr.Item("b.DateCreated")
-------------------------------------

Doesn't seem to work, but

-------------------------------------
SomeVariable = dr.Item("DateCreated")
-------------------------------------

does work, but only for one value...

When I check the resultset in Query Analyzer, it shows duplicate fieldnames, so that's probably why the DR doesn't swallow my brave attempts with
"a.DateCreated" and "b.Da..."

Can someone help me out getting both values ?

Beren.

[Elton Wang]

The simplest way is to access these fields (especially the
second DateCreated) by index.

Elton Wang
el********@hotmail.com

-----Original Message-----
Hello,

I have an sproc to query a couple of tables, that have the same fieldnames,for example DateCreated.

-------------------------------------
Select a.* , b.* From tablea a
Join table b On b.keyfield = a.keyfield
-------------------------------------

Now table A and B both have a field called "DateCreated", and I need bothvalues in my application.

-------------------------------------
.....-- New DataReader dr --....
.....-- query --....
DateCreatedA = dr.Item("a.DateCreated")
DateCreatedB = dr.Item("b.DateCreated")
-------------------------------------

Doesn't seem to work, but

-------------------------------------
SomeVariable = dr.Item("DateCreated")
-------------------------------------

does work, but only for one value...

When I check the resultset in Query Analyzer, it shows duplicate fieldnames,so that's probably why the DR doesn't swallow my brave attempts with"a.DateCreated" and "b.Da..."

Can someone help me out getting both values ?

Beren.
.

[Beren]

Thanks for the suggestions.
it's solved.

Thanks,

Beren
"Beren" <be***@angband.me> wrote in message
news:xb*********************@phobos.telenet-ops.be...

Hello,

I have an sproc to query a couple of tables, that have the same
fieldnames, for example DateCreated.

-------------------------------------
Select a.* , b.* From tablea a
Join table b On b.keyfield = a.keyfield
-------------------------------------

Now table A and B both have a field called "DateCreated", and I need both
values in my application.

-------------------------------------
....-- New DataReader dr --....
....-- query --....
DateCreatedA = dr.Item("a.DateCreated")
DateCreatedB = dr.Item("b.DateCreated")
-------------------------------------

Doesn't seem to work, but

-------------------------------------
SomeVariable = dr.Item("DateCreated")
-------------------------------------

does work, but only for one value...

When I check the resultset in Query Analyzer, it shows duplicate
fieldnames, so that's probably why the DR doesn't swallow my brave
attempts with "a.DateCreated" and "b.Da..."

Can someone help me out getting both values ?

Beren.