Re: Witango-Talk: Creating an index

Thu, 12 Oct 2006 11:10:20 -0700

The best part about painful mistakes - I BET YOU WONT MAKE THAT ONE AGAIN!
 
hehe good to hear you got it working

 
On 10/12/06, WebDude <[EMAIL PROTECTED]> wrote:
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: [email protected]
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: [email protected]
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>
<h3><@col num=2></h3>


 
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: [email protected]
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




________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Reply via email to