Skip to main content
S
silviasalsa
Known Participant
April 24, 2006
Answered

arrays,structures for reports

  • April 24, 2006
  • 1 reply
  • 471 views
I am about to start some reporting projects
For querying from the DB and outputting to a display page,
I was told that arrays, structures are useful for these projects.

I am white belt in CF and Web stuff.
Someone in the meeting has mentioned to me to use
Arrays
Structures
In my reports.


ARRAYS
· How can I use arrays to out put HTML records from an oracle query?

· How is it useful for displaying output (database)?

Also,

· What is the difference between 1 dimensional vs. 2 dimensional arrays?

· Cfdump? Do I need to use this?
STRUCTURES
How can I use Structures to these kinds of projects? With arrays

Thank you very much
This topic is closed to new replies. Start a new post to keep the conversation going.
Correct answer TedJ
At first you might try using the KISS principal (Keep It Simple S__).

Most reports can be done using straight forward SQL selects and fields listed in either the report builder or a typical page.

Also since reports are usually printed for later review the number of fields needed are minimal. A report printed in landscape can display only about 8 fields without over lap occuring.

HTH

1 reply

T
TedJCorrect answer
Inspiring
April 25, 2006
At first you might try using the KISS principal (Keep It Simple S__).

Most reports can be done using straight forward SQL selects and fields listed in either the report builder or a typical page.

Also since reports are usually printed for later review the number of fields needed are minimal. A report printed in landscape can display only about 8 fields without over lap occuring.

HTH

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices