Hi,
First I want to compliment for Pmapper's quality code, it's difficult
to find applications so well written!
Now my problem: I have to add a select when the user chooses the field
on which to search, and I wrote the XML:
<searchitem name="hospital" description="Hospital">
<layer type="ms" name="hospital">
<field type="s" name="hospfield" description="Field
to search" wildcard="2">
<definition type="options" firstoption="Select"
connectiontype="inline">
<option value="NAME" name="Name" />
<option value="ADDR" name="address" />
<option value="CITY" name="City" />
<events>onchange="$('#pmsfld_hospric').val('')"</events>
</definition>
</field>
<field type="s" name="hospric" description="Search"
wildcard="2">
<definition type="suggest" connectiontype="db"
sort="asc" minlength="2" dependfld="hospfield">
<dsn
encoding="UTF-8">odbc://'':''@localhost/datahosp</dsn>
<sql>SELECT DISTINCT [dependfldval] FROM [7
HOSPITAL] WHERE [dependfldval] LIKE '%[search]%'</sql>
</definition>
</field>
</layer>
</searchitem>
I logged the results and it working properly, except that it submit
also the field hospfield, I also tried with the xml attribute
"nosubmit" but doesn't work, what's the best way to solve it?
thanks
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
pmapper-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/pmapper-users