Marking first portalrow

[Saucepan]

hi

im trying to create a searchengine that searches a through some portalrows in my contacts table. it suppose to search the portal at the first contact, then go to the next contact, search that portal, next contact, search, and so on. when ever it hit the right value it suppose to stick it in another table.

the problem is that i cant get it to find the first portalrow in my contacts table. i use the gotoportalrow[first] but i doesn´t seem to find it, it only highlights the contact_id, which happend to be the first field i have. the really funny thing is that if i manually highlight the portalrow (clicking on it) everything works fine... i cant stickt the button with the script in the portal either cause i need a better overall look of things.

whats happening? has anybody else encountered this problem?

Edited July 14, 2006 by Guest

[Søren Dyhr]

. it suppose to search the portal at the first contact, then go to the next contact, search that portal, next contact, search, and so on. when ever it hit the right value it suppose to stick it in another table.

No where near I'm afraid, as a rule go to a layout tied to the portal records, and make the search there, when a found set is established make a GTRR(FS) to get the found set of parent records holding the values matching your request. But it's not quite what you're after here...

In my humble opinion is there no need to neither mark anything nor searching, instead make a selfjoin with the portal records ID and make the local RecordID compare it with the lowest related value from the selfjoin.

I have made a template where the portal sorts on the contents of the entered value, but where eyeballing of the earliest created record in the portal is a point as well.

So all in all isn't it really a scripted matter, but instead a function...

--sd

plingMark.zip

[Saucepan]

thanks buddy...

this gives me some to work from, quick q thoguh? whats the marker for? just to mark the current record in the other table?