Oops... forgot the "from dual" part.
Select 'Company','Active','Current','Special','Procedure',0 from dual
UNION
...
Thad Esser
Remedy Developer
| From: | Thad K Esser <[email protected]> |
| To: | [email protected] |
| Date: | 05/20/2010 12:55 PM |
| Subject: | Re: SQL Active Link Question |
| Sent by: | "Action Request System discussion list(ARSList)" <[email protected]> |
**
1. Use a union.
2. Add a 0/1 on the end of your select so you can put your header at the top via an "order by" clause
Something like:
Select 'Company','Active','Current','Special','Procedure',0
UNION
select <your selection list to match the above>, 1
<any other bit of SQL>
order by 6,<any other sort criteria you need>
Thad Esser
Remedy Developer
| From: | "Brittain, Mark" <[email protected]> |
| To: | [email protected] |
| Date: | 05/20/2010 12:48 PM |
| Subject: | SQL Active Link Question |
| Sent by: | "Action Request System discussion list(ARSList)" <[email protected]> |
**
Hi All
I have an active link that fires on Return that does a SQL search based on the information in the field. The list will display the information like this:
XYZ Company Y Y N
Is there a way to put a column heading on the Selection List so the end user knows what the values are about? Something like
Company Active Current Special Procedure
XYZ Company Y Y N
ARS 6.3 patch 20
Oracle 9.2
Thanks
Mark
____________________________________________
Mark Brittain
Remedy Developer
NaviSite
[email protected]
(315) 453-2912 x5335 (Phone)
(315) 317.2897 (Cell)
________________________________
This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited.
_attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_
*IMPORTANT NOTICE: This communication, including any attachment, contains information that may be confidential or privileged, and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message is strictly prohibited. Nothing in this email, including any attachment, is intended to be a legally binding signature. *
_attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_
*IMPORTANT NOTICE: This communication, including any attachment, contains information that may be confidential or privileged, and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message is strictly prohibited. Nothing in this email, including any attachment, is intended to be a legally binding signature. *
_attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_
