Well, my little reporting engine turned out quite nice! Starting to finally hit home how much easier it is to work with OO in regards to modifying/extending in later stages of development.
My last obstacle is adding a persistence layer. I've come up with the "poor man's" version but it involves adding a property to my dataset object which is then used to set the cachedwithin parameter on the query itself. While this would work, it doesn't feel right...and I would no longer be able to use bind variables...which is a serious negative side effect. At the moment the reporting framework hasn't a clue about its environment, including the user's session. Essentially there's a Report object which holds an array of Dataset objects. (a single report object may have multiple dataset objects) Each dataset object contains a query resultset as one of it's properties. If I were to toss the Report instance into the session scope I guess I'd need another method in my dataset object which would query the original recordset by means of a QofQ with start and end rows. This would enable me to offer "paging" for larger reports for html output. If anyone can offer any criticism or advice on this approach, I'd be much obliged! ;) Thanks, Stace AVIS IMPORTANT: ------------------------------- Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme. WARNING: ------------------------------- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the word 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). An archive of the CFCDev list is available at www.mail-archive.com/[EMAIL PROTECTED]
