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

[Duane Hinkley <suppressed>]

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

suppressed
www.downhomewebdesign.com

_______________________________________________
interchange-users mailing list
suppressed
http://www.icdevgroup.org/mailman/listinfo/interchange-users