Dave - I assumed it would involve some complex looping to work out which
drugs below to the same patient on the same day etc etc.

I am using the following code to generate a query object from the CSV file:

<cfhttp url="" name="qGetData" method="GET"
timeout="20" delimiter="," textqualifier=""""></cfhttp>



The CSV file is attached - the only identifier for each patient is a name
and medicare card number in combination.

Four the first 4 entries I would generate 4 separate structures, as each one
represents a separate physical prescription on a separate piece of paper.

The next 4 are for the one patient on the same day, now we need two separate
structure, as each prescription can only have 3 drugs.

After I build up the structures for all of the prescriptions, I planned to
dump all the data into another db table, but all separated into their
respective prescriptions for later retrieval.

I was then going to generate PDF print jobs to print out the data using
CFX_PDF.

I hope the attachment sticks to the post, if not I will repost the actual
data.





----------------------------------------------------------------
The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. It is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. Please carry out such virus and other checks, as you consider appropriate. To the fullest extent allowed by law, no responsibility is accepted by Haematology & Oncology Clinics of Australasia for any virus damage caused by this message.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Reply via email to