I discovered some strange behaviour with the Query Designer.
I was designing a report.
I picked some tables using the query designer tab and then went in and modified the SQL using the SQL tab
This is the SQL
[codebox]SELECT
smf_members.memberName,
kr_smf_saletype.st_desc,
kr_smf_salevalue.sv_desc,
count(smf_feedback.saletype)
FROM smf_feedback
INNER JOIN smf_members ON smf_feedback.ID_MEMBER = smf_members.ID_MEMBER
INNER JOIN kr_smf_saletype ON smf_feedback.saletype = kr_smf_saletype.saletype
INNER JOIN kr_smf_salevalue ON smf_feedback.salevalue = kr_smf_salevalue.salevalue
GROUP BY smf_members.memberName, kr_smf_saletype.st_desc, kr_smf_salevalue.sv_desc, smf_feedback.saletype
ORDER BY kr_smf_saletype.st_desc, kr_smf_salevalue.sv_desc DESC[/codebox]
Saved the project, built the output and uploaded....ALL is well.
I came out of PHPRUNNER
Later I made some other changes to another part of the project ans saved and rebuilt etc etc and when I went back to chack the site the report had changed. I went back in to look at the query and I found it had taken out the count statement. it now looked like this
[codebox]SELECT
smf_members.memberName,
kr_smf_saletype.st_desc,
kr_smf_salevalue.sv_desc,
smf_feedback.saletype
FROM smf_feedback
INNER JOIN smf_members ON smf_feedback.ID_MEMBER = smf_members.ID_MEMBER
INNER JOIN kr_smf_saletype ON smf_feedback.saletype = kr_smf_saletype.saletype
INNER JOIN kr_smf_salevalue ON smf_feedback.salevalue = kr_smf_salevalue.salevalue
GROUP BY smf_members.memberName, kr_smf_saletype.st_desc, kr_smf_salevalue.sv_desc, smf_feedback.saletype
ORDER BY kr_smf_saletype.st_desc, kr_smf_salevalue.sv_desc DESC[/codebox]
I am positive I have saved the project and I have tried this a few times.
I am using phprunner 4.2 build 360
thanks
Kenny