Re: SQL Active Link Question

[Paul Killion]

**

 using the dual function eg:

SELECT "Company  Active Current Special Procedure" FROM DUAL;
SELECT C8, C536870913, C7 from T### WHERE C536870913 = "$MY_VALUE$"

YVMW

PK

-----Original Message-----
From: mbritt...@navisite.com
Sent: Thu, 20 May 2010 15:48:06 -0400
To: arslist@arslist.org
Subject: SQL Active Link Question

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
mbritt...@navisite.com
(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.

---

Try FREE IM ToolPack at www.imtoolpack.com
Capture screenshots, upload images, edit and send them to your friends
through IMs, post on Twitter^®, Facebook^®, MySpace^™, LinkedIn^® – FAST!

_attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_