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.
-----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
