Hi everybody, and Merry Xmas.
I've got a problem building up a search engine for a forum.
It actually queries the db (a MsAccess Db) (where all the tables of all 
forums are contained in), making several SQL strings merged up through an 
"Union All" command.

The querying process works pretty good, and it doesn't affect too much 
resources (it seems so.., and I need to keep this point low), but when I 
gonna print out the results of the query I do need to know the name (or the 
cardinal number) of the table the current result is coming from, in order 
to make the link to the showing-message-page.

In other words what I would like to know is how to call a "method" like the 
following one:

(considering "rs" being a record-set object, --after a query--)

rs.get-current-table-name()

But actually I haven't found anything like that after two weeks of search 
on google and in other places and books.

Please help me, if you can.

Thank you
/salpe 

Hi again..
Can someone just suggest me a place a book or whatever where I can 
straighten out that problem?
Thank you.


At 19:53 28-12-2002 +0100, you wrote:
>Hi everybody, and Merry Xmas.
>I've got a problem building up a search engine for a forum.
>It actually queries the db (a MsAccess Db) (where all the tables of all 
>forums are contained in), making several SQL strings merged up through an 
>"Union All" command.
>
>The querying process works pretty good, and it doesn't affect too much 
>resources (it seems so.., and I need to keep this point low), but when I 
>gonna print out the results of the query I do need to know the name (or 
>the cardinal number) of the table the current result is coming from, in 
>order to make the link to the showing-message-page.
>
>In other words what I would like to know is how to call a "method" like 
>the following one:
>
>(considering "rs" being a record-set object, --after a query--)
>
>rs.get-current-table-name()
>
>But actually I haven't found anything like that after two weeks of search 
>on google and in other places and books.
>
>Please help me, if you can.
>
>Thank you
>/salpe
>
>---
>Change your mail options at http://p2p.wrox.com/manager.asp or to 
>unsubscribe send a blank email to