My co-worker Mr. Dennis Snodgrass used a simpler approach to search
character attributes using a SQL Server 2005 SDE database.
Use a oracle layer type:
<searchitem name="Manhole" description="Manhole ID">
<layer type="oracle" name="Manhole">
<field type="s" name="FACILITYID" description="Manhole ID"
wildcard="0" />
<sql>SELECT DISTINCT sql_test FROM SManhole WHERE FACILITYID
= '^[search]'</sql>
</layer>
</searchitem>
This email and any files transmitted with it are intended solely for the use of
the individual and/or entity to whom it is addressed. Unless noted otherwise
above, any distribution or copying of this email is strictly prohibited. This
email IS NOT a binding agreement on behalf of JJG. If you have received this
message in error, please immediately notify the sender and delete this message
from your computer.
Jordan, Jones and Goulding, Inc., 6801 Governors Lake Pkwy, Norcross, Ga. 30071
www.jjg.com
------------------------------------------------------------------------------
Enter the BlackBerry Developer Challenge
This is your chance to win up to $100,000 in prizes! For a limited time,
vendors submitting new applications to BlackBerry App World(TM) will have
the opportunity to enter the BlackBerry Developer Challenge. See full prize
details at: http://p.sf.net/sfu/Challenge
_______________________________________________
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users
