var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: INNER JOIN problem
I´m using INNER JOIN to join 2 tables that have a column named "id". After I get the recordset I need to use both ids, so I thought I could write:
but i get an error saying the column doesn´t exist in the recordset.
if I write
I get the wrong one in some cases.
What can I do?
I´m using ASP with MySQL by the way.
You probably want to post this in te MySQL section instead of the ASP section. However, you should able to rename your fields in your select query.
I don't know how MySQL does it but in MS SQL it would be something like...
Select table1.id as 'ID1', table2.id as 'ID2' etc.....
Then you can use myRecordset("ID1") or myRecordset("ID2")
Having said that, if you are joining on this field then they will always be the same.... won't they?????