[ic] [table-editor] question set values (Nested Query Tags)

[Duane Hinkley]

Michael wrote:

>
>
> On Sat, 11 Jun 2005, Duane Hinkley wrote:
>
>>>
>> Michael,
>>
>> I use the default option.  I would do it something like this:
>>
>> [table-editor auto-secure=1 table=child key="[cgi userid]"
>> ui_hide_key=1*
>> default.hosp="[sql-param hosp]"
>> default.econtactn="[sql-param econtactn]"
>> default.doctor="[sql-param doctor]"
>> mv_nextpage="cs.html" ]
>>
>> If you don't want the user changing them add the hidden widget like 
>> this:
>>
>> widget.hosp=hidden
>>
>
>
> That works but would require me to have two nested queries, can I do 
> that? One query for table-editor the other for default values.  How do 
> I say which [sql-param] from which query I want to use?
>
> Thanks,
> Michael
> _______________________________________________
> interchange-users mailing list
> interchange-users at icdevgroup.org
> http://www.icdevgroup.org/mailman/listinfo/interchange-users
>
Michael,

There's two ways.  You can store the first query results in a scratch 
variable like this:

[query list=1 sql="select * from table where variable = 'foo'"]
[seti varname][sql-param somefield][/set]
[/query]

Or you can nest queries using the prefix option.  Like this:

[query list=1 prefix=foo sql="select * from first_table where variable = 
'foo'"]
    [query list=1 prefix=detail sql="select * from another_table where 
detail = 'good'"]

        This is   from first_table: [foo-param variable]

        This is from  another_table: [detail-param detail]
  
    [/query]
[/query]


-- 

Sincerely,

Duane Hinkley
Down Home Web Design, Inc.
(208) 424-0572 Fax(208) 587-0738

duane at downhomewebdesign.com
www.downhomewebdesign.com