under a separate prescriber number.
Thanks again. Brant
_
From: Stephen Moretti (cfmaster) [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 22 September 2004 6:59 PM
To: CF-Talk
Subject: Re: Loopingagain
Brant,
> My CFX_PDF tag don't work inside the loops though :-( so I think I am
Brant,
> 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 script
dave wrote:
> i think 1st thing to do is run a script to get rid of all the quotes
>
> probably use the replace function
Not neccessary Thats what the textdelimiter attribute of CFHTTP is for.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donatio
I'm coming in late, so maybe you already have a solution. This should
help you create your prescriptions. I would create an array of
prescriptions (not in the code). Each prescription should be a structure
of patient info, doc info and an array of drug info.
name="q1"
textqualifier="""
You need the quotes. CFHTTP should take care of them!
Pascal
> -Original Message-
> From: dave [mailto:[EMAIL PROTECTED]
> Sent: 22 September 2004 04:04
> To: CF-Talk
> Subject: RE: Loopingagain
>
> i think 1st thing to do is run a script to get rid of all the
to get the
data out.
_
From: Matthew Walker [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 22 September 2004 2:46 PM
To: CF-Talk
Subject: RE: Loopingagain
> I am still unsure what will happen if a comma turns up
> in a description field
Then your data will be out of line wit
TED]
Sent: Wednesday, 22 September 2004 2:43 PM
To: CF-Talk
Subject: RE: Loopingagain
yeah that could be a problem and if u think it might happen then maybe
change out the comma with sumptin else
ok now u have that do u still have the code i sent u last night with the
ueries to re-sort the
data, then cfoutput to loop through the data as Stephen has already
described.
_
From: Brant Winter [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 22 September 2004 2:52 p.m.
To: CF-Talk
Subject: RE: Looping....again
Ok - same data no quotes, and I have checked that it
E,4000,66,30/09/2007,C,406003520C823793,Dr Bob
>Jones,PANADOL TABLET 200mg,PANADOL,5,0,0,Use,CLIN
>
>
>
>
>
>
>
> _
>
>From: dave [mailto:[EMAIL PROTECTED]
>Sent:
EES,5 CITIZEN
COURT,BRISBANE,4000,66,30/09/2007,C,406003520C823793,Dr Bob
Jones,PANADOL TABLET 200mg,PANADOL,5,0,0,Use,CLIN
_
From: dave [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 22 September 2004 12:04 PM
To: CF-Talk
Subject: RE: Loopingagain
i think 1st thing to do is
PROTECTED]
Sent: Wednesday, 22 September 2004 12:04 PM
To: CF-Talk
Subject: RE: Loopingagain
i think 1st thing to do is run a script to get rid of all the quotes
probably use the replace function
The information transmitted is
i think 1st thing to do is run a script to get rid of all the quotes
probably use the replace function
-- Original Message --
From: "Brant Winter" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date: Wed, 22 Sep 2004 10:22:48 +1000
>The CSV is as below -
(cfmaster) [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 21 September 2004 7:26 PM
To: CF-Talk
Subject: Re: Loopingagain
dave wrote:
> actually Stephen he doesnt have this in a db yet, hes getting it from
> a csv file then trying to do all that.
Doesn't matter He's loading the
The CSV is as below - not sure how it will wrap though if I just paste it in
here ( I have put an extra line break at the end of each record to make it
clearer ) :
SRXNO,SDISPDATE,PTITLE,PFIRSTNAME,PSURNAME,PADDRESS,PSUBURB,PPOSTCODE,PMEDIC
ARE,PMEDICDATE,PCONCTYPE,PCONCNO,PCONCVDATE,PSAFENTNO,PRE
dave wrote:
> i didnt know it loaded into a query, see i told ya i dont know jack
> (least im tryin)
> we havent seen the csv yet though, if i recall it looked like
>
> "name" "blaha" "lala"
>
> are u sure? doesnt seem right to me
Yep - sure...
method="GET"
timeout="20"
url="" gets
i didnt know it loaded into a query, see i told ya i dont know jack (least im tryin)
we havent seen the csv yet though, if i recall it looked like
"name" "blaha" "lala"
are u sure? doesnt seem right to me
-- Original Message --
From: "Stephen Moretti (cfma
dave wrote:
> actually Stephen he doesnt have this in a db yet, hes getting it from
> a csv file then trying to do all that.
Doesn't matter He's loading the CSV into a query using CFHTTP. ;)
>
> personally, i think he should break it down, put it in the db then do
> just like u showed.
>
>
ok brant
heres what i am doing (so far)
look at this website (watch the wrap)
http://waterdata.usgs.gov/co/nwis/uv?dd_cd=01&dd_cd=18&format=rdb&period=1&site_no=09085000&01_00060
ok, that gives me a csv file that i need but i only need the very last line, so i do the code below which basically ge
actually Stephen he doesnt have this in a db yet, hes getting it from a csv file then trying to do all that.
personally, i think he should break it down, put it in the db then do just like u showed.
but his problem is that this csv file is a friggin mess (i think) and hes trying to get to clever
Brant Winter wrote:
> 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:
>
>
> timeout="20" delimiter="," textqualifier=>
Brant,
it doesnt pass on attatchments
either post it or directly email me
dave
-- Original Message --
From: "Brant Winter" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date: Tue, 21 Sep 2004 16:51:10 +1000
>Dave - I assumed it would involve some complex loopi
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:
timeout="20" delimiter="," textqualifier=>
The CSV file is attached - the only iden
i think nobody is helping cause ur going BAB (back ass backwards) and to me it seems you are only making more problems for yourself this way.
the looping part isnt your problem, the problem is breaking apart what you got and sorting and if'ing everything
think about what ur doing?
its insane
no
23 matches
Mail list logo