datepicker form reload xml

Hello, I want to use a jquery UI datepicker to choose a range of dates and reload my XML accordingly. How do I send the values of the datepicker back to the sql query and reload the XML? I am using dynamic loading from a coldfusion file using sqlserver 2005. The datepicker is this one ui.jquery.com/demos/datepicker/



Seems like I need to attach an event, and then call the loadxml with ?val1&val2(the range of dates)


Hello,


Which dhtmlx component your question concerns ?

Sorry it is the dhtmlxgrid
I want to use a jquery UI datepicker to choose a range of dates and
reload my XML accordingly.

    <input type=“text” name=“startDate” id=“startDate” value= “#DateFormat(”# Now()#", “mm/dd/yyyy”)#" />   to   <input type=“text” name=“endDate” id=“endDate” value= “#DateFormat(”# Now()#", “mm/dd/yyyy”)#" />



How do I send the values of the datepicker
back to the sql query and reload the XML?

 I am using dynamic loading
from a coldfusion file using sqlserver 2005. The datepicker is this one
http://ui.jquery.com/demos/datepicker/


The grid can be reloaded using the following approach:


grid.clearAll();


grid.loadXML(…);


In order to send data to the server you can try to use our dhtmlxAjax component.

Yep I got it, works really nice, just use the onclose event and then what you suggested, makes sense. What do you guys suggest when a person is using a MS SQL database and wants to use dynamic loading. I was reading  the big grid documentation and it looks as though  the database in the tutorial was mysql, using the LIMIT function. Just curious what you have found to work best

What do you guys suggest when a person is using a MS SQL database
There are few solutions which can mimic LIMIT usage in case of MS SQL
planet-source-code.com/vb/sc … 0&lngWId=5
or you can use DB cursors to process only necessary rows ( the implementation depends on used server side platform )


Thanks for the tips, I am sure you have articles or questions on here to address paging too for limited data sets, in fact I think I saw one. Seems like you can use this system you made here for a complete database interface, its like crystal reports and excel wrapped into one.

paging too for limited data sets
The paging uses the same server side as SmartRendering code ( the only difference is usage of enablePaging instead of enableSmartRendering in client side code )