On Friday, August 16, 2002, at 01:15 PM, Storey, Paul wrote:
> If your search is returning one record use <@ACTIONRESULT NAME=Search > NUM=1>, where search is the name of the search action and 1 is item > number > in the list of select columns. Yup, and change the name of the Search from Search to Foo and you break your if and anything else that counts on this actionresult, and you have to spend you time chasing after it. Oh yeah. move the column number to something else, by adding a column in front of it, and the same thing happens too. Just my opinion R > > -----Original Message----- > From: Robert Sfeir [mailto:[EMAIL PROTECTED]] > Sent: Friday, August 16, 2002 12:10 PM > To: Multiple recipients of list witango-talk > Subject: Re: Witango-Talk: Sorry, Dumb Syntax question > > > > >> WELL ONLY if there are no other selects between the select and the IF >> >> If there aren't then you ca do: >> >> <@VAR local$resultSet[1,fieldname]> >> >> where the fieldname is the column name you have in your select, and >> this assumed you're comparing column 1 >> >> If you do have other things happening in between, then do: >> >> <@ASSIGN NAME="selectResults" VALUE="<@VAR resultSet>" SCOPE="local"> >> >> This assigns the value of the resultSet (the search result list) to a >> variable called selectResults. You can call the variable what ever >> you want, you can also change the scope from local to user if you want >> to use that select later on in your session. >> >> To use the results in your if, you then do: >> >> <@VAR local$selectResults[1,fieldName]> >> >> There are yet other ways to do this with other tags, but I find them >> too unreliable and they hardcode things to the point where if you >> change the select action name or something like that, things will > >> fail. >> >> R >> >> On Friday, August 16, 2002, at 12:51 PM, Fogelson, Steve wrote: >> >>> Hi, >>> >>> If I read a field from a table using a "search action", do I had to >>> assign a >>> variable to that field in order to reference it from an "if action"? >>> >>> Or can I reference it some other way? >>> >>> If so, how? >>> >>> I usually do it with a variable assignment, but am I wasting code? >>> >>> Thanks >>> >>> Steve >>> Internet Commerce Solutions >>> _____________________________________________________________________ >>> _ >>> __ >>> TO UNSUBSCRIBE: send a plain text/US ASCII email to >>> [EMAIL PROTECTED] >>> with unsubscribe witango-talk in the message body >> > > _______________________________________________________________________ > _ > TO UNSUBSCRIBE: send a plain text/US ASCII email to > [EMAIL PROTECTED] > with unsubscribe witango-talk in the message body > _______________________________________________________________________ > _ > TO UNSUBSCRIBE: send a plain text/US ASCII email to > [EMAIL PROTECTED] > with unsubscribe witango-talk in the message body ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
