JOINS, Same field name, how to refer?

shagaset · April 16th, 2004, 04:54 AM

I'm joining to tables which have filds with the same name.

<%
...
Set rsCustomer = Server.CreateObject("ADODB.Recordset")
sql = "SELECT Cu.Name, Co.Name FROM Customer Cu, Contact Co;"
rsCustomer.Open sql, db, adOpenForwardOnly, adLockOptimistic, adCmdText
....
....
Response.Write rsCustomer("Name")
...
%>

What can I do in order to response.write either the Customer name or the Contact name

Imar · April 16th, 2004, 05:02 AM

Hi there,

You can alias your column names and then use the alias to refer to them. E.g.:

Code:

Set rsCustomer = Server.CreateObject("ADODB.Recordset")
sql = "SELECT Cu.Name AS CustomerName, Co.Name AS ContactName FROM Customer Cu, Contact Co;"
rsCustomer.Open sql, db, adOpenForwardOnly, adLockOptimistic, adCmdText
....
....
Response.Write("Customer: " & rsCustomer("CustomerName")
Response.Write("Contact: " & rsCustomer("ContactName")

HtH,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: B.L.U.R.E.M.I. by Blur (Track 6 from the album: 13)

shagaset · April 16th, 2004, 05:49 AM

Thanks! That one solved the problem! Now, I'm happy!

Best regards
Sigbjorn

Quote:

quote:Originally posted by Imar
Hi there,

You can alias your column names and then use the alias to refer to them. E.g.:

Code:

Set rsCustomer = Server.CreateObject("ADODB.Recordset")
sql = "SELECT Cu.Name AS CustomerName, Co.Name AS ContactName FROM Customer Cu, Contact Co;"
rsCustomer.Open sql, db, adOpenForwardOnly, adLockOptimistic, adCmdText
....
....
Response.Write("Customer: " & rsCustomer("CustomerName")
Response.Write("Contact: " & rsCustomer("ContactName")

HtH,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: B.L.U.R.E.M.I. by Blur (Track 6 from the album: 13)