Marco
Currently *all* form elements (fields) are used for the query string.
Using one of them just for defining the depending field values but
excluding them from the query string composition is not foreseen
currently. This will require additional settings predefined in XML
that is read by PHP and then passed over to Javascript. So nothing
done in 5 minutes.
You can add a ticket in the Trac system (svn.pmapper.net/trac) of type
'enhancement'. Use the 'Register' link to create an account. I know
people practically never do that, so most enhancement proposals via
the mailing list will be discarded because I'm usually not going to
follow them up any more if not added in Trac.
For a quick and dirty solution:
I'm currently not sure how the [search] place holder is substiuted for
SQL queries, I guess it replaces them in the order how the fields are
defined in the XML. A quick solution could be to try to 'hide' the
value of the first [search] in the query string so that it is not
executed, e.g. by putting them inside a comment, like
<sql>SELECT DISTINCT [dependfldval] FROM
[7 HOSPITAL] WHERE /* [search] */ [dependfldval] LIKE '%[search]%'</sql>
armin
On Wed, Nov 25, 2009 at 10:34 AM, Marco <marc...@katamail.com> wrote:
> 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
> pmapper-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/pmapper-users
>
------------------------------------------------------------------------------
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
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users
