[ic] Improving my search form
Marty Tennison
marty at dripdepot.com
Mon Feb 8 19:05:58 UTC 2010
Paul Jordan wrote:
>
>> DB wrote:
>>>> [snip]
>>>
>>> Thanks - that looks pretty slick and I see that many other plugins
>>> exist. Can you provide any hints/examples about how to pass info back
>>> and forth between the plugin and IC?
>>>
>>> DB
>>>
>>>
>>
>> In its simplest form..... (not tested, most certainly has bugs)
>>
>>
>> 1) Include jquery and the double select plugin in the html head
>>
>> <script type="text/javascript" src="/js/jquery-1.3.2.min.js"></script>
>> <script type="text/javascript"
>> src="/js/jquery.doubleselect.js"></script>
>>
>> 2) Create the options array from ITL [query] statements
>>
>>
>> [query
>> type=list
>> prefix=brand
>> sql=|
>> SELECT distinct brand
>> FROM brandmodel
>> ORDER BY brand
>> |]
>> [list]
>>
>> [tmp ds_options][scratch ds_options]
>> "[brand-code]": {
>> "key" : [brand-increment],
>> "defaultvalue" : "",
>> "values" : {
>> [query
>> type=list
>> prefix=model
>> sql=|
>> SELECT distinct brand
>> FROM brandmodel
>> WHERE brand = [brand-code]
>> ORDER BY model
>> |]
>> [list]
>> "[model-code]": [model-code],
>> [/list]
>> [/query]
>> }
>> },
>> [/tmp]
>>
>> [/list]
>> [/query]
>
> I'm not paying much attention to this thread (so there may be more
> bugs), but I did glance at it and Marty is right, one bug I see is
> that you'd need to use the prefix alternate "except_last" parameters
> to suppress the trailing "," in your:
>
> "[model-code]": [model-code],
>
> That will highly likely Bork in IE. This is better:
>
> "[model-code]": [model-code][model-alternate
> except_last],[/model-alternate]
>
> Paul
Thanks, Paul. Yep, that would definitely bork IE I think. Also, this....
WHERE brand = [brand-code]
should probably be this...
WHERE brand = "[brand-code] "
--
- - -- ---- ---------------------------- --- -- - -
Marty Tennison DripDepot.com
email: marty at dripdepot.com
web: www.dripdepot.com
- -- --- --------------------------------------- --- --
More information about the interchange-users
mailing list