Hi!
Merry Christmas and Happy New Year to you all. For the new year I have a
new problem. The application that we are developing needs to have an
archiving part for the invoices and accounting package. So, we decided to
create archive tables that will be named the same as the current one with
the suffix "_2000". The problem is we have to make reports to view the data
in those tables, and thinking of the future, the name of the table should be
variable - if we want to see the data from year 2000 we will call the report
with the input parameter "_2000" or the whole name of the table. Somehow, I
think that this is not possible with CR 7. Can any one give me an idea for
the solution of my problem? Does anyone have this problem or did have it?
One solution is with creating temporary table which will be filled with the
correct data before issuing the report - but the tables will contain over
60000 records - and the servers are just PII400, NT4 - Oracle 8 - so this
would be very time consuming action as it shouldn't be.
Could you please, share your thoughts with me?
Thank you in advance,
Lena Trajkovska
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
