Page 1 of 1

select help needed

Posted: Mon Mar 22, 2004 1:54 pm
by pelegk2
althugh the code is in asp but the answer i think is the same
the problem is :
i am trying to do this :
i have 2 tables
where i read data from 1 table->page****s
and from the second->TitlesDb
and what i want to do is to read the item number (i) from the second table where is marked (***)
but it isnt working !
what to do/
thanks in advance
pelg

SQL = "Select *,TitlesDb.* as myTitle From page****s,TitlesDb ORDER BY date1 ASC"

RS.Open SQL,Conn,1,2


Response.Write "<TR>"
for i = 0 to CInt(RS.Fields.Count)-1
response.Write RS.myTitle.item(i).name (***)