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 (***)
select help needed
Moderator: General Moderators