RE: Witango-Talk: Creating an index

[WebDude]

Okay,   I obviously need a break and I am now sheepishly banging my head against the wall. I finally got it to work and the answer was sooooooo stupid. The data was not in any order from the search. I took the search and ordered it by category and BINGO - it works just fine. Sorry for the posts and my idiotic mistake.   From: Ben Johansen [mailto:[EMAIL PROTECTED] Sent: Thursday, October 12, 2006 12:40 PM To: witango-talk@witango.com Subject: Re: Witango-Talk: Creating an index well for one thing are your sure of the sort of the data coming in. i mean your going to need to do a order by col1 asc, col2 asc in the seach so that this technique works. you also might want to try quoting the values in the @IF <@if expr="'<@col num=1>' != '<@VAR header>'"> I prefer the method Robert G suggested where you create a index on col1 and then look up col2 within that just MHO and 1.92323 cents Ben On Oct 12, 2006, at 10:30 AM, WebDude wrote: Sorry, but I still need help! Don't know why, but for some reason I cannot get this to work. What is really ticking me off is that I have done this before and I just can't find my snip. In fact, I used this method to show a list of authors in alpha order using the first letter of the last name as the header and skipping all letters with no authors - ie... A John Anderson Jim Albert Frank Alpha B John Bart Jim Burt Frank Bub etc. etc. I am doing a db call and searching Category and Title (in that order)... This is what I have so far using Win2k Witango 2000 (could this be an issue?).. <@assign header value=""> <@rows array=test> <@if expr="<@col num=1>!=<@VAR header>"> <@assign header value="<@col num=1>"> <b><@VAR header></b><br> </@if> <@col num=2><br> </@rows Should be simple but I am just not seeing... I need a fresh set of eyes... From: Alan Wolfe [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 11, 2006 2:20 PM To: witango-talk@witango.com Subject: Re: Witango-Talk: Creating an index Sure, this uses h1's for categories and h3's for subjects just to keep things simple (: <@assign local$header value=""> <@rows array=local$MyArray> <@if expr="<@col num=1>!=@@local$header"> <@assign local$header value="<@col num=1>"> <h1>@@local$header</h1> </@if> <h3><@col num=2></h3> </@rows> On 10/11/06, WebDude <[EMAIL PROTECTED]> wrote: mmmm I have been trying to do this with an array... I like your method, you have an actual snip? From: Alan Wolfe [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 11, 2006 2:03 PM To: witango-talk@witango.com Subject: Re: Witango-Talk: Creating an index I'm not sure if it's the most efficient way to do it but here's what i do (in pseudocode) set local$header to "" (blank) loop through the table and for each row: { if column 1 is diferent than local$header { write out the header set local$header to column 1 } write out column #2, indented } hope that helps! Alan On 10/11/06, WebDude <[EMAIL PROTECTED]> wrote: Sorry if this seems so elementary... I have a table that lists categories and subjects - ie... category1 subject1 category1 subject2 category1 subject3 category2 subject4 category2 subject5 category2 subject6 category3 subject7 category3 subject8 category3 subject9 How do I display... category1 subject1 subject2 subject3 category2 subject4 subject5 subject6 category3 subject7 subject8 subject9 ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf