Forum Replies Created
-
AuthorPosts
-
elliotonehouse
MemberHey, that's a huge help! Sweet. Thanks again for the info, Shadow.
MemberAbout # 7: HTML export templates
I currently have three clients that I do quick database reports like this for with some regularity. Ideally, I would like to be able to set up a template for each of these clients. Nothing too terribly fancy, just some basic color scheming, the client’s logo (images, of course, would be referenced absolutely to a live server on the net), a place for a page header, and a place for the current date. In practice, this could work much like a SMARTY template file, with the html template containing certain “place content here” variables in the appropriate places. (e.g. {$date}, {$heading}, {$records}, etc.). Once the template is complete and placed in the appropriate directory, SQLyog will offer it up as a template option during the export as html process. Once the template is chosen, and the export button clicked, SQLyog will take the HTML produced by MySQL and parse it into the chosen template file.
About # 6: Forms Toolset
Fair enough. However, just as a thought: It occurred to me that this might be a good feature to offer as a separately sold plug in, maybe offered in the $30-50 price point. I’d certainly pay as high as $50 to have an integrated forms toolset.
About # 5: Ordering Table Columns
Right on! Thanks, Ritesh. I didn't realize this feature existed.
About # 4: Functional Reference
Thanks, Shadow! I didn’t know MySQL 4.1 offered that feature. That will help. However, I often find myself in a situation where I am looking to format or operate on field, and while I assume there is a function or set of functions that can help me out, I don’t know their names. So, if I am trying to work on a string value, I go to the MySQL ref manual online and do a search for “string”. Usually this does the trick, and I am able to find what I am looking for. But, the cool thing about the functional reference in PHPed is that the functions are organized into categories in a functional browser with headings like “string”, “integer”, etc. So, if I don’t know the name of the function, I can just click on “string” and read all of the possibilities.
MemberHi CalEvans,
About #3:
I think you get what I mean. Currently, when I want to view the row numbers for a recordset, I do something like the following:
SET @rowNum = 0;
SELECT @rowNum := @rowNum+1 as “#”, colOne, colTwo FROM myTable;
While I don't find the readout of the rownum useful all the time, it does come in handy frequently, and it is something I like about other database gui's. It doesn't take up very much space in the results screen. Do your misgivings about this feature involve screen real estate, or something else?
In any case, perhaps this would be good as an option, as you suggest, which you could activate by clicking a checkbox in the preferences panel.
About #4:
I know. And you can also just go to the MySQL website and use their wonderful search feature to find what your looking for in their extensive documentation. At face value this feature doesn't sound terribly necessary. That's what I thought about the php functional reference in phped, but, as it turns out, I find that I use it all of the time. There is something really useful about having the information available in the same active window. At least it has helped my workflow quite a bit.
-
AuthorPosts
