ReadMe for Soundings

License:
Licensed under the Apache License, Version 2.0 (the "License"); you may not use this
file except in compliance with the License. You may obtain a copy of the License at
http://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing, software distributed under the
License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR
CONDITIONS OF ANY KIND, either express or implied. See the License for the
specific language governing permissions and limitations under the License.


This readme file only contains release notes and changes. For more information, read the Welcome to Soundings document included
with the zip. If you find this application useful, please consider visitng my Amazon 
wishlist: http://www.amazon.com/o/registry/2TCL1D08EZEYE

Last Update: August 22, 2007 (Version 2.003)
/includes/udf.cfm - added a new udf
/tags/surveydisplay.cfm - fix for broken Arrays

Last Update: August 16, 2007 (Version 2.002)
Updated MySQL install script by Jared Raddigan

Last Update: August 7, 2007 (Version 2.001)
Updated MySQL install script by Lola Beno
Changed title of admin/password.cfm

Last Update: August 3, 2007 (Version 2)
Most files were updated. I didn't correctly log them all, so just consider
everything updated.

John Ramon did the new design.
Logo by Alex McKinney.

Major new features:

Pagination is supported in surveys now. Currently set to soundings.ini perpage value.
Next version will allow per survey page setting.

Reports updated to include PDF.
Reports now let you filter out questions using Spry.

Admin has new look and feel.

True user manager for admin. Right now all users can do anything they want in admin. You need to add the users table to your database.

Last Update: April 10, 2006 (Version 1.6)
I haven't tracked particular files, but this update includes a fix for CF8 compatability and some
minor layout updates. More updates coming soon.

Last Update: April 10, 2006 (Version 1.5.2)
/cfcs/question.cfc and survey.cfc: Fixes for a bug that occurs when you delete a question and don't correct rank.
/handlers/text/display.cfm
/handlers/truefalse/display.cfm
/pagetemplates/admin_header.cfm
/pagetemplates/main_header.cfm
/pagetemplates/main_footer.cfm
/pagetemplates/plain_header.cfm
/stylesheets/style.css

All of the above: Minor layout changes by John Paul Ashenfelter. Less use of tables. More CSS. good++;

/tags/surveydisplay.cfm - show name of survey in survey display

/handlers/matrix/display.cfm - wasn't working when you went backwards.


Last Update: March 30, 2006 (Version 1.5.1)
/admin/stats.cfm - tableprefix fix
/admin/surveys_edit.cfm - support for Clear Results action
/cfcs/question.cfc - tableprefix fix
/cfcs/survey.cfc - support for Clear Results action
/handlers/matrix/save.cfm and stats.cfm - tableprefix fix
/handlers/muptiplechoice/ Ditto the above
/handlers/textbox/ Ditto the above
/handlers/truefalse/ DItto the abofe

Last Update: March 22, 2006 (Version 1.5.003)
/cfcs/survey.cfm - Forgot one thing for CFMX6 support.

Last Update: March 22, 2006 (Version 1.5.002)
/admin/stat.cfm - Forgot one thing for CFMX6 support.

Last Update: March 22, 2006 (Version 1.5.001)
/cfcs/survey.cfc for a table prefix fix.
/cfcs/question.cfc - Make getAnswers order by rank

Last Update: March 10, 2006
Update: 3/10/06 (Version 1.5)
/admin/* - All files in admin touched as part of 'Remove Mapping' update. Note that I didn't bother updating the headers for some pages.
/admin/stats* - Support for CFMX6 brought back in. Charts now all have a set height. Kinda big - but simpler.
/cfc/* - Support for table prefix. Removed mapping setting from ini file.
/pagetemplates/main_header and plain_header - Modded to work w/o mapping
/tags/layout.cfm, surveycomplete.cfm, surveydisplay.cfm - ditto
/Application.cfm, ditto, plus IE fix for hitting Enter in logon form
/index.cfm, /survey.cfm - removed mapping need
Docs updated to reflect no mapping and tableprefix feature.

Update: 2/11/06 (Version 1.4)
/admin/index.cfm - I just changed the text a bit.
/admin/stats.cfm - Fixed an ordering bug in matrix reports.
/cfcs/survey.cfc - Caching to help excel reporting. 
/handlers/matrix/stats.cfm - Helps fix ordering issue in matrix reports.
/install/ - Word doc updated with license and PDF added.

12/19/05
MySQL file had a bug. It marked answers.rank as unsigned. It needs to be signed for Matrix support.

11/22/05
/handlers/matrix/edit.cfm - error when deleting item - Thanks to Mal Brisbane

11/2/05
/admin/index.cfm - just changed the date
/handlers/multiplechoice/stats.cfm - major fix
handlers/matrix/display.cfm - fix for UUIDs with #s in them

10/28/05
admin/stats - forgot to remove debug code, fix in matrix stat colors
handlers/multiplechoice/edit and display - limits to field size
handlers/textbox/ditto
install/mysql.sql - typo fix

10/8/05
Many files changed, so I recommend copying all of them over.
Added support for Matrix style questions. This requires 1-2 database changes.
The first change you must make. Edit the results table and add a itemidfk column. Type should be nvarchar (or equivalent) with size=35. Null ok.
The second change is to add support for Matrix style questions. You can either copy the insert from the db script, or use the Soundings admin
to add it yourself. Name should be Matrix, and handler root should be matrix.