[ic] [table-editor] question set values (Nested Query Tags)
Duane Hinkley
duane at downhomewebdesign.com
Sun Jun 12 08:56:55 EDT 2005
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
More information about the interchange-users
mailing list