Thanks for the tip Bertrand, I understand SQLResultRow better now. I will try that
Regards, On Saturday, 23 July 2011, Bertrand Guay-Paquet <[email protected]> wrote: > Hi, > > SQLResultRow is a type I made up. I didn't know what type you received from your SQL query, so I used that. I assumed that your result set is composed of rows where each row can be used as a "map" with key=column name and value=column value. > > With that in hand, you could iterate over the keys to build the list of datatable columns. Each column would hold its key value and would use it to access the proper column value from a result row. > > > On 23/07/2011 10:12 AM, davut uysal wrote: >> >> Hi Bertrand, >> >> What is SQLResultRow, is it a Wicket Type? Or should I create a custom class >> named "SQLResultRow"? >> >> The problem is, I can't create a custom "SQLResultRow" because I can't be >> sure of its member fields. >> >> User can run any SQL, so the type must be compatible with any result. For >> example: >> 1) select firstname, lastname from employees; => Returns<Employee> >> 2) select locationcode, locationname from locations; => Returns<Location> >> ... (any SQL can return any unpredictable object) >> So it is impossible to create a custom "SQLResultRow" >> >> Anyway, I have solved the problem in the complex, hard way which is about to >> use 2 nested repeaters (ListView). 1 for table column names loop, 1 for >> table rows loop. >> >> And, I got the answer: There is no easy way in wicket to do that kind of >> dynamic thing. >> >> Thanks, >> >> >> On 22 July 2011 18:03, Bertrand Guay-Paquet<[email protected]> wrote: >> >>> Hi, >>> >>> Here is the outline of a possible implementation : >>> >>> Execute SQL String >>> Create a List<IColumn<SQLResultRow>> >>> for each SQL result column: >>> add a column to the list that displays one column of a SQLResultRow >>> Create a very simple ISortableDataProvider that returns the SQL result from >>> above >>> (make it more complex to implement sorting) >>> Create a DataTable using the column list and the data provider >>> >>> >>> On 22/07/2011 2:05 AM, davut uysal wrote: >>> >>>> Someone in another forum advised me this: >>>> >>>> *** >>>> Maybe in latest Wicket something changed but in 1.4.16 you can't change >>>> Columns in DataTable. So it's immutable in some sense. >>>> >>>> But you may replace whole DataTable component instead when your sql >>>> statement changes: >>>> >>>> form.add(new Button("sqlSubmit") { >>>> void onSubmit() { >>>> String sql = ...; >>>> form.replace(createDataTable("**myDataTable", sql)); >>>> } >>>> }) >>>> form.add(createDataTable("**myDataTable", null)); >>>> >>>> Where createDataTable() creates DataTable using provided id and sql >>>> string. >>>> Also there is a convenient method Component.replaceWith(). Maybe it'll fit >>>> better to your coding style. >>>> >>>> *** >>>> >>>> I think this is what I need, but I dont know how to do. Can someone please >>>> help me to create below method? >>>> >>>> *createDataTable("wicketId", "SQL")* >>>> >>>> Thanks, >>>> >>>> On 21 July 2011 21:05, Andrew Fielden<andrew.fielden@power-**oasis.com< [email protected]> >>>>> >>>>> wrote: >>>> >>>> I see your problem Davut, but I really don't think Wicket can solve it in >>>>> >>>>> the >>>>> way you want it to. As Martin said, you need an<entity> to populate the >>>>> models used by the various Wicket components. >>>>> Could you somehow parse the SQL statement to extract the table name, and >>>>> find its meta data? >>>>> >>>>> >>>>> -- >>>>> View this message in context: >>>>> http://apache-wicket.1842946. <http://apache-wicket.1842946.>** n4.nabble.com/dynamic-** >>>>> DataTable-tp3683514p3684513.**html< http://apache-wicket.1842946.n4.nabble.com/dynamic-DataTable-tp3683514p3684513.html > >>>>> Sent from the Users forum mailing list archive at Nabble.com. >>>>> >>>>> ------------------------------**------------------------------** >>>>> --------- >>>>> To unsubscribe, e-mail: users-unsubscribe@wicket.**apache.org< [email protected]> >>>>> For additional commands, e-mail: [email protected] >>>>> >>>>> >>>>> >>> ------------------------------**------------------------------**--------- >>> To unsubscribe, e-mail: users-unsubscribe@wicket.**apache.org< [email protected]> >>> For additional commands, e-mail: [email protected] >>> >>> > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > >
