|
D
daviesgh author
Hi,
I rasied some issues in the PHPRunner 4.2 beta 2 (build 349) topic, posts 58 & 60(See below). Have these been addressed yet?
Regards
Gordon
Post 58:
Just a few questions on Dynamic Security:
- The generated _ugrights and _ugmembers tables have no primary key in mysql. Should they not have autoincrement primary key?
- If a User is assigned to more than one group, what security rights do they get?
- Can you add access to the Events for the new permissions pages?
- I would like to be able to change 'manage group members' page and add extra information about the user (Name/Job Title/Dept/Location etc) and also change 'manage group rights' page and add extra information about the page (Page Type - Admin/Enquiry/Lookup/Report etc). Ideally I would like to be able to change the SQL easily to add in these extra fields. Is this possible?
Post 60:
Thanks for fixing the bug that was crashing PHPRunner in Query Designer. I have now had a chance to have a play and have found some more issues with the Query Designer and MySQL 4.1.16
- Group By. Select a Table and press the Group By Button. For each field, change the Group By Column to Blank. Go back to the same field and try and change the Blank Group By to anything and the PC hangs with PHPRunner trying to use 100% CPU.
- Can Comments be retained. If you create a comment in SQL, then go to Query Designer and back to SQL, the Comment has been deleted
- Joins. Can the Graphics be changed to indicate what sort of join is involved (i.e. 1 to many) and also which fields are being linked (like MS Access)
- The default view in Query Designer is to lay all tables in one row with a grey line linking them together. However it is not immediately obvious which tables are linked to which without moving the tables around. The tables can be moved around, but the new layout is not saved. So can you either make it clearer which tables are linked to which, or allow the layout to be saved, or even better both! Also would be nice to have a zoom and show/hide fields.
- Can the Query Designer be changed to allow for variables to be included in SQL Statements? The variables could then be given a value in the appropriate PHPRunner event
- Will there be any support for UNION or LIMIT?
- Can a Table be given an Alias in Query Designer? Also the longest table name that can be shown in the Table Box on my PC is 22 characters.
- The popup box to add a table should have a title. What is the system tab on the popup box?
- In Query Designer, in the top half of the screen, if I go into a table where there are more fields than will fit into the table box, if I click on the scroll bar to scroll down (not move scroll pointer with mouse, or click to scroll up), then extra separation lines appear over each field in the box (maybe this is just my graphics card!)
- Query Designer does not recognise brackets on joins. Example: This query is recognised:
SELECT
questions.question,
category.cc_desc
FROM questions
INNER JOIN category ON questions.qu_cat = category.cc_id
This query is not recognised and get error message:
PHPRunner was unable to parse your SQL query. Designer tab is not available
SELECT
questions.question,
category.cc_desc
FROM questions
INNER JOIN category ON (questions.qu_cat = category.cc_id)
- Join Problems, when there are more complex joins between different tables. The following query is accepted by the Query Designer and runs in Results. The Query Designer shows all the links:
SELECT
questions.qu_ref,
questions.question,
questions.qu_report_order
FROM bu_survey_grade
INNER JOIN questions ON bu_survey_grade.bg_sid = questions.sid
INNER JOIN bu_survey_summary ON bu_survey_grade.bg_no = bu_survey_summary.ss_bg_no AND bu_survey_summary.ss_qid = questions.qid
However when you go from the Query designer to SQL, the SQL Statement has been changed to:
SELECT
questions.qu_ref,
questions.question,
questions.qu_report_order
FROM bu_survey_grade
INNER JOIN questions ON bu_survey_grade.bg_sid = questions.sid
INNER JOIN bu_survey_summary ON bu_survey_grade.bg_no = bu_survey_summary.ss_bg_no
If you go back into Query Designer it allows you to add the missing join, but it disappears as soon as you go into SQL
- BETWEEN in WHERE Statement - If there is a BETWEEN clause in the WHERE Statement, then the Query Designer does not show any of the WHERE conditions under Filters (All Filter, Or, Having Columns are now greyed out)
SELECT
sid,
qu_ref,
question
FROM questions
WHERE (sid between 11 AND 21) and qu_ref like '%CF%'
Also similar effect if AND & OR is mixed
SELECT
qu_ref,
question
FROM questions
WHERE ( qu_ref like '%CF%' and sid = 11) or ( qu_ref like '%RV%' and sid = 12)
|
|