Dreamweaver - DW Recordsets names ar not unique

Author

DW Recordsets names ar not unique

_fbecker

2005-09-30, 6:19 pm

hi,

I am using DWMX 2004 and I have a question about Recordsets.
I want to join 3 Tables and the table fields in different tables have some
similar names.

table 1
RecordID
name
shortcut

table2
RecordID
name
shortcut

main table
RecordID
text1
table2ID
table1ID

when I join all the tables and create a recordset for that I have the issue
with table1.name and table2.name they are all displayed as name and I cannot
access them uniquly in a dynamic field...

Any help or solution on this topic would be great and very much appriciated...

regards

Felix

Nancy Gill

2005-09-30, 6:20 pm

Change the names? Or if you can't .. try adding this to your SQL:

SELECT table1.name AS Name1

etc. That way, the display would be Name1, etc.

--
Nancy Gill
Team Macromedia Member: Dreamweaver MX/UltraDev
http://www.macromedia.com/go/team/
Co-Author: Dreamweaver MX: Instant Troubleshooter (August, 2003)
Technical Editor: DMX 2004: The Complete Reference, DMX 2004: A Beginner's
Guide, Mastering Macromedia Contribute
Technical Reviewer: Dynamic Dreamweaver MX/DMX: Advanced PHP Web Development

"_fbecker" <webforumsuser@macromedia.com> wrote in message
news:dhj49t$pt1$1@forums.macromedia.com...
> hi,
>
> I am using DWMX 2004 and I have a question about Recordsets.
> I want to join 3 Tables and the table fields in different tables have
some
> similar names.
>
> table 1
> RecordID
> name
> shortcut
>
> table2
> RecordID
> name
> shortcut
>
> main table
> RecordID
> text1
> table2ID
> table1ID
>
> when I join all the tables and create a recordset for that I have the
issue
> with table1.name and table2.name they are all displayed as name and I
cannot
> access them uniquly in a dynamic field...
>
> Any help or solution on this topic would be great and very much
appriciated...
>
> regards
>
> Felix
>

Lionstone

2005-09-30, 6:20 pm

Use the keyword 'AS'

SELECT T1.Name AS OrderName, T2.Name AS ProductName
FROM ...

"_fbecker" <webforumsuser@macromedia.com> wrote in message
news:dhj49t$pt1$1@forums.macromedia.com...
> hi,
>
> I am using DWMX 2004 and I have a question about Recordsets.
> I want to join 3 Tables and the table fields in different tables have some
> similar names.
>
> table 1
> RecordID
> name
> shortcut
>
> table2
> RecordID
> name
> shortcut
>
> main table
> RecordID
> text1
> table2ID
> table1ID
>
> when I join all the tables and create a recordset for that I have the
> issue
> with table1.name and table2.name they are all displayed as name and I
> cannot
> access them uniquly in a dynamic field...
>
> Any help or solution on this topic would be great and very much
> appriciated...
>
> regards
>
> Felix
>