1 answer
- 10-1
Hi, calling DB stored procedures are possible using the Database SQL tools or binders such as in the example Call Stored Procedure - MySQL. You can use this in conjunction with an AJAX Subform to load the data dynamically.
- Nik
Thank you for your response. But I don't think that the answer has to do with my question. Let me explain. Call Stored Procedure - MySQL and "Database SQL tool" has to do with how to run SP in process! How does this relate to what I asked? Am I missing something? Also AJAX Subform has to do with subform inside a form. Not a List. I am really struggle to find any relation but I don't want to be absolute because I'm not a joget expert. The text box in which the date is given as a parameter for SP does not need to be in a form. In fact, it shouldn't, since there is no reason for it to be stored anywhere. It exists only to set the sp parameter by the user. Thank you anyway for your time.
Add your comment...
I need a page that I set a date in a text input then click on a button that runs a Sql Server stored procedure to external database with this date as parameter. The SP returns a list of one column data. Then this data must be shown with some way (datalist?). Also you should be able to take row based action with hyperlink button that calls URL with url parameter the returned row data. If I use datalist I can figure out the creation of the hyperlink based on the data column (using hyperlink action) but there is not an obvious way to use a date search input box and a button that uses this input date as a parameter to the srored procedure, execute the SP, and then use the returned data to fill out the datalist.