On 4/12/02 2:36 AM, "Ken Glover" <[EMAIL PROTECTED]> wrote:
> You did not say what database you are using. As someone else mentioned,
> some DB products have this capability built in. If you are using
> Oracle, you can use the 'START WITH... CONNECT BY...' clause as part of
> the select statem
Nevermind! Must remember <@CALC> does alla sortsa stuff. :)
> -Original Message-
> From: Wilcox, Jamileh
> Sent: Tuesday, December 03, 2002 3:44 PM
> To: Multiple recipients of list witango-talk
> Subject: Witango-Talk: RE: Array to String
>
>
> Or, alternatively, is there a way to se
this is a good solution for the false positives issue i was talking about in
my last email as well (as long as you arent searching for something with a
comma in it hehe).
- Original Message -
From: "Ben Johansen" <[EMAIL PROTECTED]>
To: "Multiple recipients of list witango-talk" <[EMAIL P
if you are searching for a value in an array...converting to a string and
then searching for that string may have a few properties you might not
want...
first of all, converting the array to a string does take some extra time to
process.
Secondly there is a difference in how a computer checks for
In most cases you wouldn't want to delete the records then insert the ones
that were checked. That would require 1 delete action and a number of insert
actions in a loop instead of 2 update actions. And there may be more data in
the table than just the checked status.
You could set all the records
Why not use JavaScript via a script action?
>Is there anything in Witango that acts like the Javascript JOIN method
>(i.e., just converts an array to a delimited string)? It sure would
>make life easier sometimes.
>
>Thanks. j
>_
A comma in CSuffix=','
Would put the comma between the values :-)
Ben Johansen - http://www.pcforge.com
Authorized Witango Reseller http://www.pcforge.com/WitangoGoodies.htm
Latest downloads & List Archives @ http://www.witango.ws
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAI
To convert an array to a string you can use the <@var> tag.
<@var yourArray aprefix='' asuffix='' rprefix='' rsuffix='' cprefix=''
csuffix=''>
This will append all the values together in one string.
To check if a value is in the array use
<@if expr="@@yourArray contains @@yourString">
The contains
You can use the demo version of WebSTAR 4.5. It should be available somewhere on the
web
>Was woundering if there was a there was a apache server for classic mac
>os for running tango? It for someone I know looking to learn witango on
>the mac
_
well you can always do this to take an array of text and turn it into a
string...
<@VAR local$MyArray type=text APrefix='' ASuffix='' RPrefix='' RSuffix=''
CPrefix='' CSuffix=''>
you can also use the <@filter> tag to find values your looking for in arrays
without having to loop through them a row
Is there anything in Witango that acts like the Javascript JOIN method
(i.e., just converts an array to a delimited string)? It sure would
make life easier sometimes.
Thanks. j
TO UNSUBSCRIBE: send a plain text/US ASCII
Or, alternatively, is there a way to see if something is in an array,
without having to loop through the rows?
> -Original Message-
> From: Wilcox, Jamileh
> Sent: Tuesday, December 03, 2002 3:41 PM
> To: 'Witango-Talk'
> Subject: Array to String
>
> Is there anything in
Easier: just delete them all for that item, and write back the ones that ARE
checked.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of David Shelley
Sent: Tuesday, December 03, 2002 3:42 PM
To: Multiple recipients of list witango-talk
Subject: RE: RE: Witan
Oops. That second input tag should be type=checkbox. Oh the perils of cut
and paste.
-Original Message-
From: David Shelley [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 03, 2002 3:42 PM
To: [EMAIL PROTECTED]
Subject: RE: RE: Witango-Talk: updating multiple records
Unchecks aren't t
Unchecks aren't that hard. Make a group of hidden input fields called
unCheckList with the id of all the records in the resultset, and a group of
checkboxes called checkedList, also with the id's.
<@rows>
Then create an array of all the id's in the unCheckedList that are not in
I've been doing it the other way and just figured this one out (hence my
email yesterday). Pretty cool!
So, speaking of un-checks...got any suggestions? I'll be trying to set
up some of those later this afternoon.
Thanks. j
> -Original Message-
> From: Simon Boddy [mailto:[EMAIL PR
You did not say what database you are using. As someone else mentioned,
some DB products have this capability built in. If you are using
Oracle, you can use the 'START WITH... CONNECT BY...' clause as part of
the select statement.
Ken
Eric Scheid wrote:
My knowledge of SQL is scant, so my
Hi Rick,
There is no need to loop to achieve this. You should give all your checkboxes the same
name, say myBoxes, then set the value attribute of each checkbox to the database id of
the corresponding record. You can then use <@arg myBoxes type="array"> to retrieve an
array of database ids of c
Hello Eric,
What you want to do is certainly sane, a perfectly reasonable request of a data
retrieval language. You can most certainly join a table to itself, using an alias join
on id = parentId. If you require arbitrary levels of nesting of topics, then you will
need a proper recursive query.
Direct DBMS is not required. Once you get this, it's pretty easy. The
form fields end up with different names for each row.
<@ARG ID_1>
<@ARG Paid_1>
<@ARG ID_2>
<@ARG Paid_2>
<@ARG ID_3>
<@ARG Paid_3>
<@ARG ID_4>
<@ARG Paid_4>
I use a hidden field to store the number of rows.
<@ARG Record_Numbe
It's understandable. We all pretty much started with the tools and it's
difficult to visualize something from a text description.
Looking at it from the builder's way of doing things, you'll have a set of
IF/ELSEIF actions (IF Form, ElseIF Update, etc.). Drag a FOR Loop action
(which looks like '[
Thanks Steve...I understand...to a point...sorry to be so thick, but how
do you loop and update or insert? - I am still using the tools... do I
need to use Direct DBMS?
Rick Haden
Director - IS/IT
Trident Communications
3 Selsdon Way
City Harbour
London
E14 9GL
U
Doh! I knew I was being stupid! Thanks.
> -Original Message-
> From: Ben Johansen [mailto:[EMAIL PROTECTED]]
> Sent: Monday, December 02, 2002 6:31 PM
> To: Multiple recipients of list witango-talk
> Subject: RE: Witango-Talk: Looping through multiple CHECKBOX answers
>
>
> <@ROWS ARR
On 3/12/02 8:02 PM, "Atrix Wolfe" <[EMAIL PROTECTED]> wrote:
> it sounds like you should search for "joe celko's nested sets"
Bingo:
http://www.intelligententerprise.com/001020/celko1_1.shtml
> 1. Find an employee and all his/her supervisors, no matter how deep the tree.
>
>
> SELECT P2.*
>
The one word answer is ... loops.
What you need to do is create loops both on the form and in the processing
of the update action. The first loop is easy because it already exists in
the form of the <@ROWS> loop. You need to add something to uniquely identify
each field. Inside the <@ROWS> loop, i
Wish I knew this program better...is there a way of updating a list of
records all at once...ok...I do a search and get a resultset...I need to
go down the list and tick a checkbox on a few of them then click a
button to update all those checked. But when I click the button all I
get is the first o
it sounds like you should search for "joe celko's nested sets"
i dont know the details but you should check it out...try google or
something (:
- Original Message -
From: "Eric Scheid" <[EMAIL PROTECTED]>
To: "Multiple recipients of list witango-talk" <[EMAIL PROTECTED]>
Sent: Tuesday, De
My knowledge of SQL is scant, so my first question is "is this possible with
a single SQL command, or do I need to do lots of loops and recursion in my
code?" The actual SQL is moot until I know that.
The situation:
I have a table of Topics with fields TopicID, name, description, and
ParentID. By
28 matches
Mail list logo