> My CFX_PDF tag don't work inside the loops though :-( so I think I am
> gonna
> have to go back to trying to build this data into another set of DB
> tables,
> but each drug given a script number so that I can then query the data
> based
> on the doctors name, and then build the scripts again, but with a less
> complex looping structure, so as to be able to include the cfx_pdf tags.
OK - Here's a suggestion.... You'll have to have a play to work out the
best way to do this...
Use CFSAVECONTENT to save the output from the cfloop through the data
and then pass the contents of the cfsavecontent variable to your CFX_PDF
tag after the end of the loop.
> As I have stated, I think I need to get this data back into a DB
> table, and
> mark each drug to belong to a unique script number?
>
> The doctors can then logon, and I can again run a query of querys to
> get the
> data out.
If thats the case, then you need only do a simple loop through the
query generated from the CSV file and insert each record in turn into
the database. When you insert each record you are going to want to
split the data into multiple tables, one for the patient, one for the
medication and one to link the paitent to the medication along with the
other information specific to that item on this patients script. ie.
pdocpresno, sqty, srpts etc. NOTE. It may not be feasible to spilt
the medications out into a seperate table, so one table for patient and
one for script rows will suffice.
When a doctor logs in, give him a means to search for and select a
patient, then you need only query the database for that one patient and
their script records. When you output the data for cfx_pdf you will
still need a loop much like the one I or Pascal created for you, to make
sure you only get 3 lots of medication on a script.
Which ever way you do this, don't bother inserting everything into a
struct/array and then inserting it into a database or outputing it to
cfx_pgp. Its just another brain drain and loop that isn't really required.
As a total aside: Remember that you are storing personal information in
a database. You will need to make sure that the practice's Data
Protection subscription allows you to do this. If you are, then
security of this data is of absolute paramount.
Hope this all helps
Regards
Stephen
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
