Re: Witango-Talk: any word?

No new announcements, hints or gestures. When we last heard from Phil he said that they were still working on it but was not willing to give any more details. Stefan At 03:33 PM 3/2/2010, you wrote: was a 6.0 announcement made? A hint? A gesture? =

Witango-Talk: any word?

was a 6.0 announcement made? A hint? A gesture? TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

RE: Witango-Talk: Multiple Sorts

Now that I think about it, the WHERE limits the results, ORDER BY just sorts. In Witango, I found it is faster to retrieve the limited unsorted Resultset and do the sorting in Witango. Ted From: Robert Shubert [mailto:rshub...@tronics.com] Sent: Tuesday, March 02, 2010 1:04 PM To: witan

RE: Witango-Talk: Multiple Sorts

Set Rowcount is an sql server option that limits the number of rows returned. I used date as an example. Ted From: WebDude [mailto:webd...@cipromo.com] Sent: Tuesday, March 02, 2010 1:57 PM To: witango-talk@witango.com Subject: RE: Witango-Talk: Multiple Sorts SET ROWCOUNT n? Where

RE: Witango-Talk: Multiple Sorts

SET ROWCOUNT n? Where is this? date desc;? no date here John Muldoon Corporate Incentives 3416 Nicollet Ave S Minneapolis, MN 55408-4552 612.822. webd...@cipromo.com http://cipromo.com _ From: Ted Wolfley [mailto:t...@ogdengroup.com] Sent: Tuesday, M

RE: Witango-Talk: Multiple Sorts

If you are using SQL SERVER you can actually use both. Set the number of results to be returned using the SET ROWCOUNT n option; Then use the ORDER BY SQL to retrieve the latest n records. Remember to use SET ROWCOUNT 0 to turn off the option. In DirectDBMS: SET ROWCOUNT 100; Select *

RE: Witango-Talk: Multiple Sorts

bummer... Yes... we are using an SQL server... any suggestions? _ From: Robert Shubert [mailto:rshub...@tronics.com] Sent: Tuesday, March 02, 2010 12:04 PM To: witango-talk@witango.com Subject: RE: Witango-Talk: Multiple Sorts If you are using SQL server to limit the results,

RE: Witango-Talk: Multiple Sorts

If you are using SQL server to limit the results, then you can not use the @SORT option, but must use the ORDER BY SQL clause. Ted's option of using @SORT and <@ROWS start=/stop=> only works if you initially retrieve the entire dataset from SQL and store it as a user variable as he explained. This

RE: Witango-Talk: Multiple Sorts

Put the ResultSet from the initial search in an user variable and only replace it when a new search is preformed. Sort the user$ResultSet then display pages using the start and stop attributes of the <@ROWS START=@@request$vstart STEP=1 STOP=@@request$vstop ARRAY=""> tag. Ted From

RE: Witango-Talk: Multiple Sorts

Now for the $10,000 question... If you are using a max of 100 returns and paging through the returns, is there a way of carrying the sort(s) through to the next page. John Muldoon Corporate Incentives 3416 Nicollet Ave S Minneapolis, MN 55408-4552 612.822. webd...@cipromo.com

RE: Witango-Talk: Multiple Sorts

Not very pretty, but this works great! Thanks! <@IF EXPR="<@ARG sort>= 1"> <@COMMENT>company <@IFEMPTY VALUE="<@VAR vsortorder>"> <@ASSIGN NAME="vsortorder" VALUE="1 NUM ASC" SCOPE="user"> <@else> <@ASSIGN NAME="vsortorder" VALUE="1 NUM ASC,

RE: Witango-Talk: Multiple Sorts

This would probably be slightly easier if you maintained the sort column and direction in a 2-column array (user scope) and then adjusted the array (using @FILTER and @ADDROWS) as the user requests. Then you would only need a small routine (TCF call?) to convert the array into the ORDER BY clause.

RE: Witango-Talk: Multiple Sorts

My mistake on the @@request$vsortorder should have been @@user$vsortorder. You will have to add a replace tag before assigning the new sort. Ex( sort version): if existing sort order is "1,2,3,4" and the new sort to be added is "3" to make the sort "3,1,2,4" you have to remove the existing "3" fir

RE: Witango-Talk: Multiple Sorts

Okay, I got the vsortorder to load... Pretty slick. First off, I cannot use @@request$vsortorder... It just isn't being recognized. I think I have an older version of Witango that doesn't let me use that scope. When I change it to <@VAR vsortorder> it works fine. Now that being said... I get to

RE: Witango-Talk: Multiple Sorts

One correction, delete the <@ASSIGN NAME="vsortorder" VALUE="" SCOPE="user"> line before the first if statement or the sortorder will only sort on one column. -Original Message- From: Ted Wolfley [mailto:t...@ogdengroup.com] Sent: Tuesday, March 02, 2010 8:32 AM To: witango-talk@witango.c

RE: Witango-Talk: Multiple Sorts

Here is a quick example, all in a Results Action: order of columns returned: company, lname, state, customerid build the sort: <@ASSIGN NAME="vsortorder" VALUE="" SCOPE="user"> <@IF EXPR="<@ARG sort>= 1"> <@COMMENT>company <@IFEMPTY VALUE="@@request$vsortorder"> <@

RE: Witango-Talk: Multiple Sorts

Well... That's the way I do it. But it seems that you cannot have a blank variable or multiple sorts within 1 variable... Or am I missing something here. Do you have an example? -Original Message- From: Ted Wolfley [mailto:t...@ogdengroup.com] Sent: Monday, March 01, 2010 10:13 PM To: