thanks jason, i have looked at this in the past and will again now.as for sades re the Qub, i found it quite difficult to work the QUB, maybe i was not understanding properly but i could not do a simple join with it could you?
the rest of the addt was great but i am getting my head around WA extensions now thanks to the support.
cheers
Yes it very simple you select the databases you wish to join then select on each the fields to display on the query and you drag and drop the fields you want to join, on the bottum it displays the code, and a preview of the join from there u can right click over the links of each join to configure to left join, right join etc... you can select distinct also, add sum coun min max also, do the where from there with a menu very similiar to the dreamweaver add query for filtering, then you just click save go to dreamweaver hit the refresh button on the Qub and it places all the code there and from there you can go to the advance of recordset to edit any stuff like add some RAND or orders etc... in other words you can join hundreds of tables (going crazy lol) in just a few seconds, the best part is the visual part of how to do it with its preview, check the pictures i uploaded playing with a test database.
Im to also managing my self around with webassist now that adobed killed addt, but webassist lacks on some parts to make life easy, im sad that the new anounced frame works seems to only come with the nice server include functions, just hope webassist some day makes more extensions to avoid the time consuming wich is why most of us use these extensions.
