Gossamer Forum
(Advanced Search)
for
Home : Products : DBMan SQL : Discussion :

Re: [jai] select_options and query_sth

Mar 17, 2003, 2:46 PM
jean
Staff / Moderator (132 posts)
Mar 17, 2003, 2:46 PM
Views: 8221
Shortcut
Quote Reply
Re: [jai] select_options and query_sth In reply to
You can try with:

$self->{cgi}->{rs} = 'MIN(public_holiday_id) as min_phd, public_holiday_201,public_holiday_owner_id';


then you can use min_phd in your templates.
Let me know if it works for you,
Cheers,
Jean
Gossamer Threads Inc.
Subject Author Views Date
Thread select_options and query_sth jai 8582 Feb 24, 2003, 7:34 PM
Thread Re: [jai] select_options and query_sth 		jean 8384 Feb 26, 2003, 11:14 AM
Thread Re: [jean] select_options and query_sth 		jai 8363 Feb 27, 2003, 3:08 AM
Thread Re: [jai] select_options and query_sth 		jai 8349 Mar 3, 2003, 9:47 PM
Thread Re: [jai] select_options and query_sth 		jai 8304 Mar 7, 2003, 3:16 PM
Post Re: [jai] select_options and query_sth 		jai 8272 Mar 11, 2003, 3:58 PM
Thread Re: [jai] select_options and query_sth 		jean 8256 Mar 11, 2003, 4:39 PM
Thread Re: [jean] select_options and query_sth 		jai 8269 Mar 11, 2003, 9:32 PM
Thread Re: [jai] select_options and query_sth 		jean 8250 Mar 12, 2003, 12:05 AM
Thread Re: [jean] select_options and query_sth 		jai 8209 Mar 17, 2003, 6:08 AM
Thread Re: [jai] select_options and query_sth 		jean 8221 Mar 17, 2003, 2:46 PM
Thread Re: [jean] select_options and query_sth 		jai 8199 Mar 17, 2003, 3:15 PM
Post Re: [jai] select_options and query_sth 		rgbworld 7778 May 22, 2005, 3:44 PM