Ajax DataGrid Support Product Page

QUESTIONS

This topic was archived

Questions for buying decision

Jerry Smith

Asked 23 Sep 2008 11:32:11

has this question

I also have this question

23 Sep 2008 11:32:11 Jerry Smith posted:

I have looked at your movie and I am curious:

1. Can I select data from multiple tables (one column from one table and one from another) or somehow join the tables? I mean, can I show in one your table cells from more than one table in DB? Your demo shows only data from one table, so this is unclear to me...

2. Can I modify (without GUI of course) your looks of the table? Is everything in CSS and can be modified by "experts"? <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

3. If I have in database 10.000 records and I use pagination, does your module load only the 20 records at a time (AJAX way) or is 10.000 records converted to XML file and then showed 20 at a time? I would need that the records are dynamically pulled out of a database, not on a client side, because I have 10.000 records with quite a lot data, it would take 30 seconds to pull all out of the database at once.

4. Have you implemented the functionality so that when I click on page 2 in URL the hash also changes to reflect the change? I need this for bookmarking the page one is on at the time of the bookmark. Yes, i thought this was impossible but Yahoo YUI table script (which is not very programmer friendly as one has to make a JSON data souce first) showed me this is possible.

Thank you for your answers.

Jerry

Replies

George Petrov

Replied 23 Sep 2008 15:05:22

23 Sep 2008 15:05:22 George Petrov replied:

Hi Jerry,

<BLOCKQUOTE id=quote>quote:<hr height=1 noshade id=quote>
1. Can I select data from multiple tables (one column from one table and one from another) or somehow join the tables? I mean, can I show in one your table cells from more than one table in DB? Your demo shows only data from one table, so this is unclear to me...
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote>
Our interface allows to select a single table or view from your database that contains all the data. So if you need complicated join - just make a View out of it (or Query in MS Access). Then you will be able to use that view and its columns.

<BLOCKQUOTE id=quote>quote:<hr height=1 noshade id=quote>
2. Can I modify (without GUI of course) your looks of the table? Is everything in CSS and can be modified by "experts"? <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote>
Yes - everything is fully CSS based. It even is so smart that if you save your css files under new names - it will pick them as existing design for future grids.

If you do make some great looking design you can always send it to us if you wish - then we can integrate is as build in choice

<BLOCKQUOTE id=quote>quote:<hr height=1 noshade id=quote>
3. If I have in database 10.000 records and I use pagination, does your module load only the 20 records at a time (AJAX way) or is 10.000 records converted to XML file and then showed 20 at a time? I would need that the records are dynamically pulled out of a database, not on a client side, because I have 10.000 records with quite a lot data, it would take 30 seconds to pull all out of the database at once.
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote>

Yes - we use completely the Ajax way! Only 20 records as in your example are sed over in JSON format. Also server side only 20 records are extracted from your database - so even server side it is mighty fast!

<BLOCKQUOTE id=quote>quote:<hr height=1 noshade id=quote>
4. Have you implemented the functionality so that when I click on page 2 in URL the hash also changes to reflect the change? I need this for bookmarking the page one is on at the time of the bookmark. Yes, i thought this was impossible but Yahoo YUI table script (which is not very programmer friendly as one has to make a JSON data souce first) showed me this is possible.
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote>
No we haven't got this - it is a good idea however. Will see if we can implement it in the next updates.

Greetings,
George

--------------------------------------------------
George Petrov - Founder of the Dynamic Zones
DMXzone.com, FWzone.net, FLzone.net, CFzone.net,
DNzone.com, FlashFiles.nl
--------------------------------------------------

Jerry Smith

Replied 23 Sep 2008 16:51:40

23 Sep 2008 16:51:40 Jerry Smith replied:

<BLOCKQUOTE id=quote>quote:<hr height=1 noshade id=quote>
Our interface allows to select a single table or view from your database that contains all the data. So if you need complicated join - just make a View out of it (or Query in MS Access). Then you will be able to use that view and its columns.
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote>

Are view available in mySql 5.0? Is it possible to change the SQL query simply in code view (with breaking your GUI of course)?
<BLOCKQUOTE id=quote>quote:<hr height=1 noshade id=quote>
<BLOCKQUOTE id=quote>quote:<hr height=1 noshade id=quote>
4. Have you implemented the functionality so that when I click on page 2 in URL the hash also changes to reflect the change? I need this for bookmarking the page one is on at the time of the bookmark. Yes, i thought this was impossible but Yahoo YUI table script (which is not very programmer friendly as one has to make a JSON data souce first) showed me this is possible.
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote>
No we haven't got this - it is a good idea however. Will see if we can implement it in the next updates.
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote>

That is a major thing. See, I have a long list of items and sending bookmark to other people seems a smart thing. Without this, you are limited to tables that don't need to be bookmarked. For example, I use a system that link to the point where there is something new in a table. For that reason I couldn't use AJAX till now. At least with YUI and I hope with your extension since YUI is very hard to work by. If you want to see what I mean, please take a look at:

developer.yahoo.com/yui/examples/datatable/dt_server_pag_sort.html

If you could implement the history manager in it, you would have a killer application.

George Petrov

Replied 23 Sep 2008 21:33:37

23 Sep 2008 21:33:37 George Petrov replied:

<BLOCKQUOTE id=quote>quote:<hr height=1 noshade id=quote>
Are view available in mySql 5.0? Is it possible to change the SQL query simply in code view (with breaking your GUI of course)?
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote>
Yes views are very common in mySQL 5, See dev.mysql.com/doc/refman/5.0/en/create-view.html

You can not change the generated SQl as we use a separate generated php file that builds the SQL on the fly runtime based on the query parameters and paging needs.

<BLOCKQUOTE id=quote>quote:<hr height=1 noshade id=quote>
4. Have you implemented the functionality so that when I click on page 2 in URL the hash also changes to reflect the change? I need this for bookmarking the page one is on at the time of the bookmark. Yes, i thought this was impossible but Yahoo YUI table script (which is not very programmer friendly as one has to make a JSON data souce first) showed me this is possible.

No we haven't got this - it is a good idea however. Will see if we can implement it in the next updates.

That is a major thing. See, I have a long list of items and sending bookmark to other people seems a smart thing. Without this, you are limited to tables that don't need to be bookmarked. For example, I use a system that link to the point where there is something new in a table. For that reason I couldn't use AJAX till now. At least with YUI and I hope with your extension since YUI is very hard to work by. If you want to see what I mean, please take a look at:

developer.yahoo.com/yui/examples/datatable/dt_server_pag_sort.html

If you could implement the history manager in it, you would have a killer application.
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote>

Yes you are absolute right - I'm sure we will implement this very soon.

In the update that will come out tomorrow we also have some very fancy things like dynamically refresh grids, parent and child grid (dependent grids), refresh and filter grid from any other form field etc.
We will publish some more demos to show off all this.

Greetings,
George

--------------------------------------------------
George Petrov - Founder of the Dynamic Zones
DMXzone.com, FWzone.net, FLzone.net, CFzone.net,
DNzone.com, FlashFiles.nl
--------------------------------------------------

Jerry Smith

Replied 23 Sep 2008 21:42:29

23 Sep 2008 21:42:29 Jerry Smith replied:

I am sorry I can not change the SQl myself, I can try using views, so does your module support views because I am not sure if Dreamweaver supports them in the recordset?

I am using ASP, not PHP, but from the spec I see you also have a ASP module, right?

I am eager to see new functionality and new movies, as you don't have any demo to try it out.

Jerry Smith

Replied 23 Sep 2008 21:50:10

23 Sep 2008 21:50:10 Jerry Smith replied:

Is there any time limited or somehow limited demo? I bought Pure ASP UPload that was supposed to work on Opera, but it doesn't. Nothing personal, but the module is not so cheap and I can not even try it. I live in Eastern Europe speaking country, so many times there are some problems with characters that do not work (we use čšžČŠ&#381<img src=../images/dmxzone/forum/icon_smile_wink.gif border=0 align=middle>. Anyway, I allways have some problems with extensions <img src=../images/dmxzone/forum/icon_smile_sad.gif border=0 align=middle> That's why I got offers to test them. If it works for me it works for anybody usually :-/

So is there any way to see if I am in better luck this time before I buy?

George Petrov

Replied 24 Sep 2008 00:02:54

24 Sep 2008 00:02:54 George Petrov replied:

<BLOCKQUOTE id=quote>quote:<hr height=1 noshade id=quote>
I am sorry I can not change the SQl myself, I can try using views, so does your module support views because I am not sure if Dreamweaver supports them in the recordset?
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote>

yes Views are supported in DW as well in our upcoming update of the Ajax Datagrid

<BLOCKQUOTE id=quote>quote:<hr height=1 noshade id=quote>
I am using ASP, not PHP, but from the spec I see you also have a ASP module, right?
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote>

Yes we offer both ASP and PHP functionality build in.

Do you use ASP with MySQL? As this is a bad combination in DW .... in ASP land stick with MS SQL/Acces and use PHP for MySQL

Greetings,
George

--------------------------------------------------
George Petrov - Founder of the Dynamic Zones
DMXzone.com, FWzone.net, FLzone.net, CFzone.net,
DNzone.com, FlashFiles.nl
--------------------------------------------------

George Petrov

Replied 24 Sep 2008 00:05:35

24 Sep 2008 00:05:35 George Petrov replied:

<BLOCKQUOTE id=quote>quote:<hr height=1 noshade id=quote>
Is there any time limited or somehow limited demo? I bought Pure ASP UPload that was supposed to work on Opera, but it doesn't. Nothing personal, but the module is not so cheap and I can not even try it. I live in Eastern Europe speaking country, so many times there are some problems with characters that do not work (we use čšžČŠŽ

. Anyway, I allways have some problems with extensions <img src=../images/dmxzone/forum/icon_smile_sad.gif border=0 align=middle> That's why I got offers to test them. If it works for me it works for anybody usually :-/

So is there any way to see if I am in better luck this time before I buy?
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote>

We already offer live demo on the site that shows most functionalities and more to come!

In the latest update we have full unicode support - so all special characters come just fine! We have tested all accent characters and also Cyrillic letters and such and it works all fine in both filters and display.

Greetings,
George

--------------------------------------------------
George Petrov - Founder of the Dynamic Zones
DMXzone.com, FWzone.net, FLzone.net, CFzone.net,
DNzone.com, FlashFiles.nl
--------------------------------------------------

Jerry Smith

Replied 24 Sep 2008 00:09:49

24 Sep 2008 00:09:49 Jerry Smith replied:

<BLOCKQUOTE id=quote>quote:<hr height=1 noshade id=quote>
<BLOCKQUOTE id=quote>quote:<hr height=1 noshade id=quote>
Is there any time limited or somehow limited demo? I bought Pure ASP UPload that was supposed to work on Opera, but it doesn't. Nothing personal, but the module is not so cheap and I can not even try it. I live in Eastern Europe speaking country, so many times there are some problems with characters that do not work (we use čšžČŠ&#381<img src=../images/dmxzone/forum/icon_smile_wink.gif border=0 align=middle>. Anyway, I allways have some problems with extensions <img src=../images/dmxzone/forum/icon_smile_sad.gif border=0 align=middle> That's why I got offers to test them. If it works for me it works for anybody usually :-/

So is there any way to see if I am in better luck this time before I buy?
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote>

We already offer live demo on the site that shows most functionalities and more to come!

In the latest update we have full unicode support - so all special characters come just fine! We have tested all accent characters and also Cyrillic letters and such and it works all fine in both filters and display.

Greetings,
George

--------------------------------------------------
George Petrov - Founder of the Dynamic Zones
DMXzone.com, FWzone.net, FLzone.net, CFzone.net,
DNzone.com, FlashFiles.nl
--------------------------------------------------
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote>

Great, that is nice to know. As Pure ASP upload 3 has problems with Unicode characters. PUA2 filtered them and PUA3 doesn't. I modified the code so I have some kind of filter...

Jerry Smith

Replied 24 Sep 2008 00:15:58

24 Sep 2008 00:15:58 Jerry Smith replied:

<BLOCKQUOTE id=quote>quote:<hr height=1 noshade id=quote>
<BLOCKQUOTE id=quote>quote:<hr height=1 noshade id=quote>
I am sorry I can not change the SQl myself, I can try using views, so does your module support views because I am not sure if Dreamweaver supports them in the recordset?
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote>

yes Views are supported in DW as well in our upcoming update of the Ajax Datagrid

<BLOCKQUOTE id=quote>quote:<hr height=1 noshade id=quote>
I am using ASP, not PHP, but from the spec I see you also have a ASP module, right?
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote>

Yes we offer both ASP and PHP functionality build in.

Do you use ASP with MySQL? As this is a bad combination in DW .... in ASP land stick with MS SQL/Acces and use PHP for MySQL

<hr height=1 noshade id=quote></BLOCKQUOTE id=quote>

Hi

I don't share your worries here. ASP + mySQL is a great combination <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle> But I know many people are scared of it <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle> I use it all the time, I bought many WebAssist modules also and apart for some minor problems everything works. I have never found a DW problem with ASP + mySQL. MyODBC is mature and version 5 works with Unicode 100% so I can use my pages, my data and everything in pure Unicode without conversion.

I have learnt ASP a long time ago and I like it, but I grew over Access database and couldn't afford the MS SQL so I ended up where I did. I have a site with 100.000 users (5 milion open pages monthly) all in ASP with your Pure upload, jmail as server component, and some other components and it works like a charm. Until now, there is no function that PHP has and I miss it. It is a stable and mature system alshough I know I'll have to migrate somewhere someday. But why break something that works.

The previous paragraph is all possible also because you support ASP so good, without guys like you I would miss functionality. I hope you don't stop supporting it in the near future.

Jerry Smith

Replied 25 Sep 2008 15:48:48

25 Sep 2008 15:48:48 Jerry Smith replied:

I have my finall 3 questions I think:

1. My sorting page is very complex, your table sorting is OK, but nothing near complex join sorting. I am wondering if I am able to still pass my sorting filter through querystring or is your table made for something as "show all data only"? I mean except basic filtering you have inside. From the GUI it seems I can only select whole table or View as you said, but am I able to pass some filtering parameters from querystring also? I don't need GUI for that, I want to know if your code is structured so I can "hack" into the generating of SQL and include my querystring parameters on the table it shows. Example: I have a recipes page. I want that the table shows only recipes with 5 pictures or more that have a cooking time of more than 1 hour. Cooking time is a field in 1 table, pictures in another. I make the needed SQL using Querystring. Can I make it to the table somehow? I am not sure if you will understand my question though <img src=../images/dmxzone/forum/icon_smile_sad.gif border=0 align=middle> It is complex.

2. I don't like the demo makes it's own slider, I'd like the table to expand so it accomodates all the rows that are set to be displayed (5, 10, 20 at once). Can this be changed as simple as setting the height of a table to none and removing overflow to no in CSS or is there some more complex problem with it?

3. Are anchors supported (like #10)? That means I can jump to any row within querystring? I jump to the comment that is new so I need this functionality.

Yours

Jerry

Edited by - jerry2000 on 25 Sep 2008 17:16:16

Edited by - jerry2000 on 25 Sep 2008 20:32:25

George Petrov

Replied 25 Sep 2008 22:46:19

25 Sep 2008 22:46:19 George Petrov replied:

<BLOCKQUOTE id=quote>quote:<hr height=1 noshade id=quote>
1. My sorting page is very complex, your table sorting is OK, but nothing near complex join sorting. I am wondering if I am able to still pass my sorting filter through querystring or is your table made for something as "show all data only"? I mean except basic filtering you have inside. From the GUI it seems I can only select whole table or View as you said, but am I able to pass some filtering parameters from querystring also? I don't need GUI for that, I want to know if your code is structured so I can "hack" into the generating of SQL and include my querystring parameters on the table it shows. Example: I have a recipes page. I want that the table shows only recipes with 5 pictures or more that have a cooking time of more than 1 hour. Cooking time is a field in 1 table, pictures in another. I make the needed SQL using Querystring. Can I make it to the table somehow? I am not sure if you will understand my question though <img src=../images/dmxzone/forum/icon_smile_sad.gif border=0 align=middle> It is complex.
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote>

The grid currently accepts one user defined filter - it can be bound however with a value from the query string, cookies, session or application variable. Its like the default recordset behavior.
I definately suggest to use multiple views for more complicated joins with more filters.

<BLOCKQUOTE id=quote>quote:<hr height=1 noshade id=quote>
2. I don't like the demo makes it's own slider, I'd like the table to expand so it accomodates all the rows that are set to be displayed (5, 10, 20 at once). Can this be changed as simple as setting the height of a table to none and removing overflow to no in CSS or is there some more complex problem with it?
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote>

We currently have auto width - the height is fixed. I will put this as requested feature for future updates.

<BLOCKQUOTE id=quote>quote:<hr height=1 noshade id=quote>
3. Are anchors supported (like #10)? That means I can jump to any row within querystring? I jump to the comment that is new so I need this functionality.
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote>

We are considering anchors for pagine - so you can jump to specific page. Jumping to specific rows is also interesting. Will see what we can do.

Greetings,
George

--------------------------------------------------
George Petrov - Founder of the Dynamic Zones
DMXzone.com, FWzone.net, FLzone.net, CFzone.net,
DNzone.com, FlashFiles.nl
--------------------------------------------------

Jerry Smith

Replied 25 Sep 2008 22:49:10

25 Sep 2008 22:49:10 Jerry Smith replied:

Can I somehow make the height auto, so there are no scrollbars on the right but the table is as big as the data in it? Is that possible for me to easily "hack"?

Can I make multiple views and use many filters on your module then?

George Petrov

Replied 25 Sep 2008 23:21:17

25 Sep 2008 23:21:17 George Petrov replied:

<BLOCKQUOTE id=quote>quote:<hr height=1 noshade id=quote>
Can I somehow make the height auto, so there are no scrollbars on the right but the table is as big as the data in it? Is that possible for me to easily "hack"?
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote>

Yes you can calculate the need height yourself and enter the number

<BLOCKQUOTE id=quote>quote:<hr height=1 noshade id=quote>
Can I make multiple views and use many filters on your module then?
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote>

You can define the filters in your views and then just call the views. Like for example one view can be called LastMonthSales - and it will return just the sales from the last month which is a ready query with its own filter.

George

--------------------------------------------------
George Petrov - Founder of the Dynamic Zones
DMXzone.com, FWzone.net, FLzone.net, CFzone.net,
DNzone.com, FlashFiles.nl
--------------------------------------------------

Jerry Smith

Replied 25 Sep 2008 23:24:18

25 Sep 2008 23:24:18 Jerry Smith replied:

I understand about the views <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle> Thanx.

I don't understand the height. I'd like the height of the window to be as long as the data in it. Data of course change when going forward / next page, so the height varies. Is that possible or must I use the fixed height? I don't like to have a scrollbar on the right for the data to scroll, I'd like the data to be shown all on the page without scrollbar.

Jerry Smith

Replied 25 Sep 2008 23:34:14

25 Sep 2008 23:34:14 Jerry Smith replied:

But using the views I can only filter on one parameter, right?

I see the best thing is to buy the module and see if I can use it, if not try to "hack" it and give you some ideas to improve it.

Ajax DataGrid Support Product Page

QUESTIONS

Questions for buying decision

Replies

Reply to this topic