hi - just wondering of I can include server specific SQL in a cfquery tag? I
want to use some of MySQL's row locking features with an InnoDB table.
Can I include the MySQL lock commands in the cfquery tag before an update
statement ?
Hi again - A while ago I found a piece of code ( CFC ? ) that generated a nice
piece of code that generated the page navigation for sorting through a large
list a records returned by a cfquery. I have no idea where it was, and I am
having trouble finding something else !
Does anyone else have any issues with the cfdump tag not formating right? I
have found that sometimes my cfdump will lose all its formattin, colour etc.
It seems to be using the div id's of other areas on my pages, but I am sure I
am not calling the cfdump from within a div
I was just
hi - just wondering what people prefer to use in their login code in the
Application.cfm file and its associated form template. The Developing
Coldfusion MX Applications book , pp.363, states that the form action should
be: form action=#CGI.script_name#?#CGI.query_string# method=post
It does
Oh SH!T, it must be late,i'm now going to bed. Thanks for the answer.
You are missing a cfoutput around the form
Pascal
-Original Message-
From: Brant Winter [mailto:[EMAIL PROTECTED]
Sent: 08 December 2004 12:28
To: CF-Talk
Subject: form action=???
hi - just wondering
Thanks mate, it was late last night embarrassed look on face
~|
Special thanks to the CF Community Suite Silver Sponsor - New Atlanta
http://www.newatlanta.com
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186728
Hi all - I have read in a stack of CSV data via the code:
cfhttp url=20041202_4.csv name=qGetCSV method=GET timeout=40
delimiter=, textqualifier=/cfhttp
I am already sorting this data and getting it into DB tables etc etc, I would
just like to knwo the best way to validate the data. I want to
I have spent hours trying to write a function for error checking a csv file. In
my function I want to check each field, and if there is an error put the
errored text in a structure in an array, the array index will be relevant to
the current row id of the query i am looping, and there will be a
The structure should initially be empty, or it may contain a value for anyone
of 24 different errored fields.
~|
Special thanks to the CF Community Suite Silver Sponsor - CFDynamics
http://www.cfdynamics.com
Message:
that makes sense? or did i misunderstand what you're doing?
Cheers
Bert
On Thu, 02 Dec 2004 08:31:16 -0400, Brant Winter [EMAIL PROTECTED] wrote:
if there is an error put the errored text in a structure in
an array, the array index will be relevant to the current row id of
the query i am looping
The following code is pretty much doing what I need, but I am not sure how to
call it from my code. Basically I read in a CSV file using the following line
of code:
cfhttp url=20041202_4.csv name=qGetScripts method=GET timeout=40
delimiter=, textqualifier=/cfhttp
The following code is pretty much doing what I need, but I am not sure how to
call it from my code. Basically I read in a CSV file using the following line
of code:
cfhttp url=20041202_4.csv name=qGetScripts method=GET timeout=40
delimiter=, textqualifier=/cfhttp
My example code is being truncated from this list somehow.
~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185925
That is how I have ended up doing it.
I created a function to check each field in each row, and create an array of
structures. Each array element represents a row in the CSV, if there is an
error it populates the structure in the array element that corresponds to the
curren trow of the CSV
Hi again - how do I force hte use of HTTPS pages ? I can force the flow of
pages with cflocation tags, but I want to stop a user just typing in the URL
as HTTP ? Thanks
~|
Special thanks to the CF Community Suite Gold Sponsor -
Thanks heaps - It never ceases to amaze me how smart some of you guys are !
~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message:
hi - I have now spent 1 whole day trying to import a whole stack of CSV data
into a MSSQL table. My insert query keeps falling over when it hits an empty
date field.
The MSDE table has a datetime field to enter this particular date into, but
some of my CSV fields have empty dates, and will
hi - i can't seem to find a definitive naswer on this one. I have a MSSQL (
MSDE ) tbale with a field set to type timestamp.
How on earth do I get coldfusion to insert a current datetimestamp into this
field ?
I have tried:
cfquery datasource=scripts name=insDTS
INSERT INTO tblFeeds
hi again, i am trying to incorporate some sort of hardcore encryption in my web
app that we are writing. has anyone had any experience with lightcrypto ?
Would a web server cert be enough ?
~|
Special thanks to the CF Community
Thanks for that -works a treat !
~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184975
Archives:
Thanks for the ongoing help - I am now mapping out the loops and queries,
and hope to get started writing the real one soon. I have played with your
looping code a little to include a couple of other conditions, mainly being
you need a separate piece of paper ( ie a new script ) for Authority
Does anyone have a link for theCF_HTML2PDF3 tag I cant seem to find
anything through Google.
Brant
_
From: Larry Lyons [mailto:[EMAIL PROTECTED]
Sent: Friday, 24 September 2004 1:30 AM
To: CF-Talk
Subject: Re: print output
I am looking at using CFX_PDF to generate the output for my
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
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
I will try and get the Query of Query working like you showed, I still have
to get it into another table though, as these hundreds of scripts come in
for numerour doctors, so I have to provide them with a web interface to
connect and query only their scripts.
_
From: Stephen Moretti
Damm - I was told on this list that I should be using a text qualifier as
the drug descriptions have commas in them, thus ruining the delimiter comma.
I can get the data without the quotes, it just took me ages to get them to
supply it with the quotes!
_
From: dave [mailto:[EMAIL PROTECTED]
I am looking at using CFX_PDF to generate the output for my prescription
application as I can use it to accurately place text element on the page,
and generate new pages etc based on cfif statements. Is there any other
way ?? I have considered using a Crystal Reports file, but then I need to
Ok - same data no quotes, and I have checked that it still returns a query
object with cfhttp - I am still unsure what will happen if a comma turns up
in a description field
SRXNO,SDISPDATE,PTITLE,PFIRSTNAME,PSURNAME,PADDRESS,PSUBURB,PPOSTCODE,PMEDIC
Timeframe : 6 months ago - like everything else round here.
_
From: dave [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 22 September 2004 2:41 PM
To: CF-Talk
Subject: Re: print output
whats the time frame?
i hear that the new blackstone has some great new printing tags
Dave - I didn't quite understand your code, but I played round with steves,
and I got the Query of Query working, and I can run all of the loops over
the data.
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
Yep I have done all of that, and thanks to Stephens code I am a lot further
ahead. Thank you Stephen.
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
--
From: Brant Winter [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Date:Mon, 20 Sep 2004 15:54:09 +1000
If you do indeed have 3 medical degrees ( not sure how one can have 3 but
anyway ) you may be aware of the situation of the dispensation of drugs
from
a pharmacy in an oncology
Check your DNS settings, your server may have been using cached DNS queries
??
-Original Message-
From: Ryan Duckworth [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Date: Mon, 20 Sep 2004 10:15:15 -0500
Subject: Help!!CFHTTP failing
Please help!
I am getting a timeout on a CFHTTP
I don't really know how to explain this, but I am still really struggling
with writing the looping logic for my app.
My app is basically going to run through a CSV file, produce a query object,
parse this query object and build arrays or structures that represent a
prescription. Each prescription
Hi - for whatever reason I cannot seem to access livedocs at present.
I am having problems parsing a csv file using cfhttp - I am not sure what I
am doing wrong here:
My Code:
cfhttp url="" name=qGetData
delimiter=, resolveurl=no timeout=20/cfhttp
CF Error:
The column name !DOCTYPE HTML
Just never seem to see responses anymore ?
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,
ct: Re: Are my posts hitting the cf-talk lists ???
ayup.
maybe you're just not asking the right questions? :D
On Mon, 20 Sep 2004 13:03:20 +1000, Brant Winter [EMAIL PROTECTED]
wrote:
Just never seem to see responses anymore ?
The inf
Well there was more code, but I have gradually deleted it all in anger...
I now simply have:
cfhttp
method=get
name=qGetData
delimiter=,
textqualifier=
url="">
timeout=20
/cfhttp
The Book1.csv file is as below, but with about 200 lines, all with different
patient names and drug names.
Its just a plain old text file - I have added the column names in with and
without quotes around them. No matter what I have tried, I end up with the
same error. I have even made a new text file as below:
A,B,C,D,E,F
something,goes,in,here,to,test
You get the picture, no matter what I have
The 200 - 300 lines of data change daily - by the way, what does PIA mean
?
_
From: dave [mailto:[EMAIL PROTECTED]
Sent: Monday, 20 September 2004 1:41 PM
To: CF-Talk
Subject: Re: CFHTTP error
is this a non changing (non dynamic) list? if so why dont u just import it
into say mysql and
Yes I have.
_
From: Matthew Walker [mailto:[EMAIL PROTECTED]
Sent: Monday, 20 September 2004 1:50 PM
To: CF-Talk
Subject: RE: CFHTTP error
looks like it's using the wrong page e.g. a server error page. Have you
tried a fully qualifyed URL?
_
From: Brant Winter [mailto:[EMAIL
I don't understand this, I get a 404 in the header output on that page:
Not sure if you can see that screen shot ?
_
From: Matthew Walker [mailto:[EMAIL PROTECTED]
Sent: Monday, 20 September 2004 2:01 PM
To: CF-Talk
Subject: RE: CFHTTP error
OK. Have you tried ...
cfhttp url="" url
I cant share the URL, but yes I have amended the URL line in the code you
sent. I have tried both FQDN and relative URL's
_
From: Matthew Walker [mailto:[EMAIL PROTECTED]
Sent: Monday, 20 September 2004 2:25 PM
To: CF-Talk
Subject: RE: CFHTTP error
I'm assuming you pasted your URL into
: Matthew Walker [mailto:[EMAIL PROTECTED]
Sent: Monday, 20 September 2004 2:25 PM
To: CF-Talk
Subject: RE: CFHTTP error
I'm assuming you pasted your URL into those two lines, right? Can you share
the URL of your CSV?
_
From: Brant Winter [mailto:[EMAIL PROTECTED]
Sent: Monday, 20 September
Now that I have gotten myself to the point I needed to be at this morning
when I started on this again, I can ask the question I needed to ask 6 hours
ago !
I have all of this data, each row has patient details, doctors details, and
a drug type, qty, dosage etc. I need to generate electronic
my ass to a csv file!!
i would start thinking but writing this to a db with every error catcher u
can find. Cause if there is a prob, its u they come after and they dont mess
around
-- Original Message --
From: Brant Winter [EMAIL PROTECTED]
Reply-To: [EMAIL
Once I have the query object from the cfhttp tag, can I then query this data
within a cfloop sort of a query of a query I guess
_
From: Matthew Walker [mailto:[EMAIL PROTECTED]
Sent: Monday, 20 September 2004 2:34 PM
To: CF-Talk
Subject: RE: CFHTTP error
right and you got a 404
Hi - does anyone know of a coldfusion helpdesk app in existence. I need to
be able to track IT issues in a database, have people log jobs for helpdesk
staff etc ? I have used a php app called Perldesk in the past, but I would
like to get things across onto a coldfusion box.
I was wanting to blow away the redhat 8 box running perldesk. I just don't
have the resources anymore to maintain another OS.
Hey brant,
I don't know if any CF helpdesk apps...
We use Perldesk.Why not just tap into the perldesk db via a DSN if you
need to access the data?
-Josh
Can somebody please some help ??
cfset scriptNO = 1
cfset scriptrun=StructNew()
cfset scriptrun.script #scriptNO# = StructNew()
What am I doing wrong ?? I am trying to make this string look like cfset
scriptrun.script1=StructNew()
Ahahahhaa it humors me to no end. These doctors are just used to getting
what they want - and unfortunately, if I want my job I have to deliver !
The information transmitted is intended only for the person or entity to which it is
Works great thanks
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
sounds complicated ... im not sure how you can create a new page in a
pdf
not really ! I have purchased the cfx_pdf custom tag - it really makes it a breeze !
www.easel2.com
i will try your method later tonight.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User
Just wondering if anyone knows how to automatically display the print box on
a pdf I generate with cfx_pdf ?
I basically generating a 100 - 200 page print job as a pdf with cfx_pdf (
don't know of any other way of doing it ) from CSV data.
The app is going to be used to generate a daily backlog
I will give it a go !
_
From: Larry Lyons [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 8 September 2004 11:42 PM
To: CF-Talk
Subject: Re: generate print dialogue box
Just wondering if anyone knows how to automatically display the print
box on
a pdf I generate with cfx_pdf ?
If
Hi again - I just cant get my head around this looping statement I have to
write !
The test data I have limited to say five rows as below:
** All patient data is de-identified below **
Name
MedicareNo
Surname
Title
DispenseDate
DrugDescription
Qty
SRXNO
1
John
12345678910
Smith
No one is answering any of my questions so I have to assume that I am making
them too long
The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or
Can some please tell me how to concatenate a string on CF ?
cfquery datasource=obscript name=qGetDrugs maxrows=10
SELECT SDISPDATE,PTITLE,PFIRSTNAME,PSURNAME,PMEDICARE,SDRUGDESC,SQTY,SRXNO
from scripts
ORDER BY PSURNAME DESC,PMEDICARE DESC
/cfquery
cfset scriptNO = 1
cfset
the appropriate cfsqltype
Pascal
-Original Message-
From: Brant Winter [mailto:[EMAIL PROTECTED]
Sent: 06 September 2004 13:26
To: CF-Talk
Subject: RE: escaping character
What am i doing wrong here ? Sorry about the huge post, but I just
cant
see
what I am missing now ? The error in line
OK great - I will give this a go, it seems a bit painstaking though
Kind Regards,
Brant Winter
_
From: Matthew Walker [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 8 September 2004 1:54 PM
To: CF-Talk
Subject: RE: escaping character
VALUES ( #qData.SRXNO#, #qData.SDISPDATE
really not sure how/why to use it.
Use CFQUERYPARAM !! put the #qData.xxx# in the value attribute and
use the appropriate cfsqltype
Pascal
-Original Message-
From: Brant Winter [mailto:[EMAIL PROTECTED]
Sent: 06 September 2004 13:26
To: CF-Talk
Subject: RE: escaping character
----
From: Brant Winter [mailto:[EMAIL PROTECTED]
Sent: 06 September 2004 05:55
To: CF-Talk
Subject: RE: escaping character
Actually - I have just found the issue. I am using the listfix udf :-
http://www.cflib.org/udf.cfm/listfix
The problem is that, the string I was trying to inser
Ok - I've Googled me a text qualifier definition, so I have that under
control. Has anyone had experience with Flash Remoting ? Is it possible to
start to learn the basics via web tutorials ??? Any book suggestions ? I am
writing a small app to handle a group of doctors having to write scripts
So when you say to read the csv as a query object what exactly do you mean
?Do you mean treat the data as if it came straight out of a cfquery
statement ? I am confused !
The information transmitted is intended only for the person
It will be a regular transfer, almost on a daily basis. I am not sure if I
am going to be able to get the other party to supply the data with double
quotes and commas as in a text qualifier.
The information transmitted is intended
Wo - why does that work ? I specify the delimiter only ( as the
data didn't have a text qualifier ) and the query output is spot on now ???
cfhttp url="" name=qData delimiter=,
resolveurl=no timeout=20/cfhttp
The
What am i doing wrong here ? Sorry about the huge post, but I just cant see
what I am missing now ? The error in line 57 refers to a different field
than the exception message showing an address Syntax error (missing
operator) in query _expression_ '2 HOLBOURN CRES'.
Error Executing
Just for testing I made a simple access db and made all the fields text
fields. I tried putting single quotes around all of the #qData.xxx# and all
I ended up with was qData.xxx in the resulting error message.
The information
Hi - I am trying to insert a string as text into an access db, but I having
trouble, as the string includes a character. The query in my debug screen
looks like this:
INSERT INTO scripts (
SRXNO,
SDISPDATE,
PTITLE,
PFIRSTNAME,
PSURNAME,
PADDRESS,
PSUBURB,
PPOSTCODE,
PMEDICARE,
PMEDICDATE,
Actually - I have just found the issue. I am using the listfix udf :-
http://www.cflib.org/udf.cfm/listfix
The problem is that, the string I was trying to insert actually has a single
comma in the csv file:-
BLEOMYCIN (BL) INJ 15,000 i.u.
Is there anyway to exclude listfix from picking this up
Hi - just wondering how to go about looping over a list generated from a csv
file that has empty fields, ie, 1,2,3,4,,6,7
My code is as follows:
cfset CRLF = Chr(13) Chr(10)!--- Linefeed carriage return ---
cffile action="" file=#ExpandPath('/pharma/uploads')#/Book1.csv
variable=csvData
Sorry - I don't understand how to include thin in my code, I have found
something similar on the net, but I don't know how to incorporate a while
statement in my code as below:
while(find(,,,csvRecord)) csvRecord = Replace(csvRecord, ,,, , ,,
ALL)
this is what I need to use I think but I don't
-
From: Brant Winter [mailto:[EMAIL PROTECTED]
Sent: 01 September 2004 11:41
To: CF-Talk
Subject: cfloop over csv not working with empty fields
Hi - just wondering how to go about looping over a list generated from
a
csv
file that has empty fields, ie, 1,2,3,4,,6,7
My code
Hi - I am trying to use the listfix.cfm udf, and I am not quit sure how to
use it. I have placed the udf in the customtags path under my cfusionmx
folder, but I am not qquite sure how to call the function on my cfm page. Do
I need to use a cfinclude - thanks again
Thanks heaps - its late and im not thinking all that clearly !
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,
Just wondering how I can go about building a dynamic insert query ???
I need to loop over a structure and insert the items into another
database based on the type of item in the query column.
The requirement for the looping, is that I don't know how many items
will ever be in this
I feel so stupid ! Once I wrote it down on paper, I realise that in
insert query only affects one row of a table, therefore I need to
include the whole insert statement in each iteration of the loop.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Does anyone have any experience with the use of the bouncycastle.org api's
??
The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material.
Hi - Maybe I should be addressing this question to the CF-Newbies list, but
I will try here anyway!
I need to create a form to submit patient data to another health company be
email. I was thinking I could easily write the app in CF to do this, but I
want to secure the actual email with a digital
79 matches
Mail list logo