RE: Looping....again
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 quotes > > probably use the replace function [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Looping....again
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 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 with your columns and the CSV will be invalid. You need those quotes. cfhttp should take care of the quotes for you automatically. The next step is to use query of queries to re-sort the data, then cfoutput to loop through the data as Stephen has already described. 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]
RE: Looping....again
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 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. Brant _ From: dave [mailto:[EMAIL PROTECTED] 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 listgetat? 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]
RE: print output
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 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]
RE: Looping....again
> I am still unsure what will happen if a comma turns up > in a description field Then your data will be out of line with your columns and the CSV will be invalid. You need those quotes. cfhttp should take care of the quotes for you automatically. The next step is to use query of queries 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: Loopingagain 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 ARE,PMEDICDATE,PCONCTYPE,PCONCNO,PCONCVDATE,PSAFENTNO,PREPATNO,SDOCPRESNO,SD OCNAME,SDRUGDESC,SALTDESC,SQTY,SRPTS,SAUTHORITY,SSIGS,SWARDNO 977669,22/12/2003,MR,ROBERT,ROBBERY,1 CITIZEN COURT,BRISBANE,4000,1234567890,31/07/2008,,714718,Dr Bob Jones,SODIUM CHLORIDE IV 0.9% VFLEX 1L,SODIUM CHLORIDE,5,0,0,Use,CLIN 46470,3/03/2004,MRS,PATRICIA,JOHNSON,2 CITIZEN COURT,BRISBANE,4000,1098765432,30/09/2007,C,406930987B,30/09/2004,,,714718,D r Bob Jones,TAXOL VL 300mg/50mL C'trate,PACLITAXEL,1,0,-1,,CLIN 940528,18/11/2003,MR,BARRY,SMITH,3 CITIZEN COURT,BRISBANE,4000,2468101214,30/04/2010,C,405091751V823793,Dr Bob Jones,NEULASTA PFS INJ 6mg/0.6mL,PEGFILGRASTIM PFS,1,0,-1,administer 6mg (0.6ml) from one prefilled syringe by subcutaneous injection the day after chemotherapy as directed,CLIN 941320,18/11/2003,MR,GLENN,BRETT,4 CITIZEN COURT,BRISBANE,4000,5672453678,31/03/2009,,823793,Dr Bob Jones,ETOPOPHOS VL 113.6mg,ETOPOS,IDE PHOSPHATE,5,0,0,,CLIN 108923,4/05/2004,MRS,DOROTHY,REES,5 CITIZEN COURT,BRISBANE,4000,66,30/09/2007,C,406003520C823793,Dr Bob Jones,PROMETHAZINE AMP 50mg,PROMETHAZINE,10,0,0,,CLIN 109139,4/05/2004,MRS,DOROTHY,REES,5 CITIZEN COURT,BRISBANE,4000,66,30/09/2007,C,406003520C823793,Dr Bob Jones,SODIUM CHLORIDE IV 0.9% VFLEX 1L,SODIUM CHLORIDE,5,0,0,Use,CLIN 108923,4/05/2004,MRS,DOROTHY,REES,5 CITIZEN COURT,BRISBANE,4000,66,30/09/2007,C,406003520C823793,Dr Bob Jones,ETOPOPHOS VL 113.6mg,ETOPOSIDE PHOSPHATE,10,0,0,,CLIN 109139,4/05/2004,MRS,DOROTHY,REES,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 run a script to get rid of all the quotes probably use the replace function 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]
RE: Looping....again
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 listgetat? -- Original Message -- From: "Brant Winter" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Wed, 22 Sep 2004 12:52:14 +1000 >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 >ARE,PMEDICDATE,PCONCTYPE,PCONCNO,PCONCVDATE,PSAFENTNO,PREPATNO,SDOCPRESNO,SD >OCNAME,SDRUGDESC,SALTDESC,SQTY,SRPTS,SAUTHORITY,SSIGS,SWARDNO > >977669,22/12/2003,MR,ROBERT,ROBBERY,1 CITIZEN >COURT,BRISBANE,4000,1234567890,31/07/2008,,714718,Dr Bob Jones,SODIUM >CHLORIDE IV 0.9% VFLEX 1L,SODIUM CHLORIDE,5,0,0,Use,CLIN > >46470,3/03/2004,MRS,PATRICIA,JOHNSON,2 CITIZEN >COURT,BRISBANE,4000,1098765432,30/09/2007,C,406930987B,30/09/2004,,,714718,D >r Bob Jones,TAXOL VL 300mg/50mL C'trate,PACLITAXEL,1,0,-1,,CLIN > >940528,18/11/2003,MR,BARRY,SMITH,3 CITIZEN >COURT,BRISBANE,4000,2468101214,30/04/2010,C,405091751V823793,Dr Bob >Jones,NEULASTA PFS INJ 6mg/0.6mL,PEGFILGRASTIM PFS,1,0,-1,administer 6mg >(0.6ml) from one prefilled syringe by subcutaneous injection the day after >chemotherapy as directed,CLIN > >941320,18/11/2003,MR,GLENN,BRETT,4 CITIZEN >COURT,BRISBANE,4000,5672453678,31/03/2009,,823793,Dr Bob Jones,ETOPOPHOS >VL 113.6mg,ETOPOS,IDE PHOSPHATE,5,0,0,,CLIN > >108923,4/05/2004,MRS,DOROTHY,REES,5 CITIZEN >COURT,BRISBANE,4000,66,30/09/2007,C,406003520C823793,Dr Bob >Jones,PROMETHAZINE AMP 50mg,PROMETHAZINE,10,0,0,,CLIN > >109139,4/05/2004,MRS,DOROTHY,REES,5 CITIZEN >COURT,BRISBANE,4000,66,30/09/2007,C,406003520C823793,Dr Bob >Jones,SODIUM CHLORIDE IV 0.9% VFLEX 1L,SODIUM CHLORIDE,5,0,0,Use,CLIN > >108923,4/05/2004,MRS,DOROTHY,REES,5 CITIZEN >COURT,BRISBANE,4000,66,30/09/2007,C,406003520C823793,Dr Bob >Jones,ETOPOPHOS VL 113.6mg,ETOPOSIDE PHOSPHATE,10,0,0,,CLIN > >109139,4/05/2004,MRS,DOROTHY,REES,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 run a script to get rid of all the quotes > >probably use the replace function > > > > > > >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]
Re: print output
whats the time frame? i hear that the new blackstone has some great new printing tags -- Original Message -- From: "Brant Winter" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Wed, 22 Sep 2004 13:24:15 +1000 >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 statements. Is there any other >way ?? I have considered using a Crystal Reports file, but then I need to >install CR on my Coldfusion server. > > > >Just looking for ideas for something to generate print output from a web >page. Thanks > > > > > > >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]
RE: Looping....again
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 ARE,PMEDICDATE,PCONCTYPE,PCONCNO,PCONCVDATE,PSAFENTNO,PREPATNO,SDOCPRESNO,SD OCNAME,SDRUGDESC,SALTDESC,SQTY,SRPTS,SAUTHORITY,SSIGS,SWARDNO 977669,22/12/2003,MR,ROBERT,ROBBERY,1 CITIZEN COURT,BRISBANE,4000,1234567890,31/07/2008,,714718,Dr Bob Jones,SODIUM CHLORIDE IV 0.9% VFLEX 1L,SODIUM CHLORIDE,5,0,0,Use,CLIN 46470,3/03/2004,MRS,PATRICIA,JOHNSON,2 CITIZEN COURT,BRISBANE,4000,1098765432,30/09/2007,C,406930987B,30/09/2004,,,714718,D r Bob Jones,TAXOL VL 300mg/50mL C'trate,PACLITAXEL,1,0,-1,,CLIN 940528,18/11/2003,MR,BARRY,SMITH,3 CITIZEN COURT,BRISBANE,4000,2468101214,30/04/2010,C,405091751V823793,Dr Bob Jones,NEULASTA PFS INJ 6mg/0.6mL,PEGFILGRASTIM PFS,1,0,-1,administer 6mg (0.6ml) from one prefilled syringe by subcutaneous injection the day after chemotherapy as directed,CLIN 941320,18/11/2003,MR,GLENN,BRETT,4 CITIZEN COURT,BRISBANE,4000,5672453678,31/03/2009,,823793,Dr Bob Jones,ETOPOPHOS VL 113.6mg,ETOPOS,IDE PHOSPHATE,5,0,0,,CLIN 108923,4/05/2004,MRS,DOROTHY,REES,5 CITIZEN COURT,BRISBANE,4000,66,30/09/2007,C,406003520C823793,Dr Bob Jones,PROMETHAZINE AMP 50mg,PROMETHAZINE,10,0,0,,CLIN 109139,4/05/2004,MRS,DOROTHY,REES,5 CITIZEN COURT,BRISBANE,4000,66,30/09/2007,C,406003520C823793,Dr Bob Jones,SODIUM CHLORIDE IV 0.9% VFLEX 1L,SODIUM CHLORIDE,5,0,0,Use,CLIN 108923,4/05/2004,MRS,DOROTHY,REES,5 CITIZEN COURT,BRISBANE,4000,66,30/09/2007,C,406003520C823793,Dr Bob Jones,ETOPOPHOS VL 113.6mg,ETOPOSIDE PHOSPHATE,10,0,0,,CLIN 109139,4/05/2004,MRS,DOROTHY,REES,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 run a script to get rid of all the quotes probably use the replace function 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]
print output
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 statements. Is there any other way ?? I have considered using a Crystal Reports file, but then I need to install CR on my Coldfusion server. Just looking for ideas for something to generate print output from a web page. Thanks 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]
RE: Prepared Statements in CFMX
Yes, i have looked at . I dont think it works the same as below. http://java.sun.com/j2se/1.4.2/docs/api/java/sql/PreparedStatement.html Joe Eugene -Original Message- From: Matthew Fusfield [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 21, 2004 9:28 PM To: CF-Talk Subject: Re: Prepared Statements in CFMX Have you looked into ? It allows you to do parameterized queries and does type checking. Matt On Tue, 21 Sep 2004 21:03:42 -0400, Joe Eugene <[EMAIL PROTECTED]> wrote: > Is there an easy way to execute a Prepared Statements directly in CFMX? > i.e Using the API via , just like java prepared statements? > > Thanks, > Joe Eugene > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFX Tag no longer working - help!
>Is there a reason that you do not use CFREPORT tag? My understanding is that CFREPORT displays the output in the browser. I need the reports printed on various printers. Can CFREPORT address a printer for output via IP printing? If not, any ideas on my original question? Thanks, Julian [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
dynamic maps (GIS and other acronyms)
I need the ability to present maps dynamically as images. These maps would be of US cities that have vector graphics layered on top of them. I need to programmatically create these vector graphics on the fly using only GPS coordinates and/or street address. I am perfectly capable of writing the code for this in Java, but I am not really sure where to start. What library do I use to create the vector graphics? Where do I get the maps I am layering the graphics on? I have found many Java-based open source projects that seem to do what I want, but without knowing much about this space it is hard to get started. If a few pointers are all I need then I would appreciate them. Otherwise, I could use a consultant to get me started. -Matt [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Looping....again
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] 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 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]
RE: Looping....again
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 - 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,PREPATNO,SDOCPRESNO,SD >OCNAME,SDRUGDESC,SALTDESC,SQTY,SRPTS,SAUTHORITY,SSIGS,SWARDNO > > > >"977669","22/12/2003","MR","ROBERT","ROBBERY","1 CITIZEN >COURT","BRISBANE","4000","1234567890","31/07/2008","","","","","","714718"," >Dr Bob Jones","SODIUM CHLORIDE IV 0.9% VFLEX 1L","SODIUM >CHLORIDE","5","0","0","Use","CLIN" > > > >"46470","3/03/2004","MRS","PATRICIA","JOHNSON","2 CITIZEN >COURT","BRISBANE","4000","1098765432","30/09/2007","C","406930987B","30/09/2 >004","","","714718","Dr Bob Jones","TAXOL VL 300mg/50mL >C'trate","PACLITAXEL","1","0","-1","","CLIN" > > > >"940528","18/11/2003","MR","BARRY","SMITH","3 CITIZEN >COURT","BRISBANE","4000","2468101214","30/04/2010","C","405091751V","","","" >,"823793","Dr Bob Jones","NEULASTA PFS INJ 6mg/0.6mL","PEGFILGRASTIM >PFS","1","0","-1","administer 6mg (0.6ml) from one prefilled syringe by >subcutaneous injection the day after chemotherapy as directed","CLIN" > > > >"941320","18/11/2003","MR","GLENN","BRETT","4 CITIZEN >COURT","BRISBANE","4000","5672453678","31/03/2009","","","","","","823793"," >Dr Bob Jones","ETOPOPHOS VL 113.6mg","ETOPOSIDE >PHOSPHATE","5","0","0","","CLIN" > > > >"108923","4/05/2004","MRS","DOROTHY","REES","5 CITIZEN >COURT","BRISBANE","4000","66","30/09/2007","C","406003520C","","","" >,"823793","Dr Bob Jones","PROMETHAZINE AMP >50mg","PROMETHAZINE","10","0","0","","CLIN" > > > >"109139","4/05/2004","MRS","DOROTHY","REES","5 CITIZEN >COURT","BRISBANE","4000","66","30/09/2007","C","406003520C","","","" >,"823793","Dr Bob Jones","SODIUM CHLORIDE IV 0.9% VFLEX 1L","SODIUM >CHLORIDE","5","0","0","Use","CLIN" > > > >"108923","4/05/2004","MRS","DOROTHY","REES","5 CITIZEN >COURT","BRISBANE","4000","66","30/09/2007","C","406003520C","","","" >,"823793","Dr Bob Jones","ETOPOPHOS VL 113.6mg","ETOPOSIDE >PHOSPHATE","10","0","0","","CLIN" > > > >"109139","4/05/2004","MRS","DOROTHY","REES","5 CITIZEN >COURT","BRISBANE","4000","66","30/09/2007","C","406003520C","","","" >,"823793","Dr Bob Jones","PANADOL TABLET >200mg","PANADOL","5","0","0","Use","CLIN" > > > > > > > > >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]
Re: CFC - Web service error handling
Ian, ALL of my web services return a CFC object, which at the very least contains two items - ERRORCODE and ERRORMESSAGE .. plus whatever else is expected to be returned. I usually populate ERRORCODE with 0 or 1, and ERRORMESSAGE with some appropriate error message.. which is sometimes cfcatch.message or something like that, and other times it's things like "The username you provided was not valid".. ie, not an actual exception. - Rick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Looping....again
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 (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 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. > > but his problem is that this csv file is a friggin mess (i think) and > hes trying to get to clever with the code. But the csv file is > generated by a pharmacys software program which means he probably has > no control over how its made. Doesn't really matter as long as each row is in the same format you can load the csv into a query using cfhttp. ie. each row is : medicareno, firstname,lastname,medication,quantity,description Once you've loaded the CSV into a query, you can then use Query of Query to reorder etc etc without the overhead of having to insert everything into a DB and then requery everything out of the DB. > > i'd say get the csv & rip it out 1 line at a time, get the info for 1 > line (1 record), break the line down & insert it to the db then delete > the line and loop it. Don't need to. CFHTTP will take the first line as the column names for the query it generates and insert the rest of the CSV data into the query, as long as there are no data errors of course. If there are errors in the data, its not going to matter if you load it into a query using cfhttp or parse the contents of the csv into a database, it will still fail. Stephen _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Prepared Statements in CFMX
Have you looked into ? It allows you to do parameterized queries and does type checking. Matt On Tue, 21 Sep 2004 21:03:42 -0400, Joe Eugene <[EMAIL PROTECTED]> wrote: > Is there an easy way to execute a Prepared Statements directly in CFMX? > i.e Using the API via , just like java prepared statements? > > Thanks, > Joe Eugene > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Prepared Statements in CFMX
Is there an easy way to execute a Prepared Statements directly in CFMX? i.e Using the API via , just like java prepared statements? Thanks, Joe Eugene [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: ;amp in my URL's?
If you are using FB4, then chances are that these are coming from relocates
in the circuit.xml. & is actually the way that they should be written
both in FB's circuit files and in HTML.
Ampersands (&'s) in URLs
Another common error occurs when including a URL which contains an ampersand
("&"):
This example generates an error for "unknown entity section" because the "&"
is assumed to begin an entity
. In many cases,
browsers will recover safely from the error, but the example used here will
cause the link to fail in Netscape 3.x (but not other versions of Netscape)
since it will assume that the author intended to write §ion, which is
equivalent to §ion.
To avoid problems with both validators and browsers, always use & in
place of &:
Sandy Clark
http://www.shayna.com
CF Pretty Accessible at http://www.shayna.com/blog
Now offering 4 days Hands on CSS training October 11-14th. Rockville, MD.
For more information go to:
http://www.teratech.com/training/oc_classes.cfm#css
_
From: Casey C Cook [mailto:[EMAIL PROTECTED]
Sent: Monday, September 20, 2004 9:40 PM
To: CF-Talk
Subject: ;amp in my URL's?
Im trapping a few errors per day which means probably 1-1000 users (or
more) is experiencing this problem, and not sure what could be causing it.
Basically if I look at the cgi.query_string it shows
fuseaction=DisplayNews&ContextID=MSA&ID=4324&GBT=Main
vs. what it should be
fuseaction=DisplayNews&ContextID=MSA&ID=4324&GBT=Main
What would be placing amp; in my URL strings? I simulated the exact steps
as the user but did not throw an error message. We are both clicking the
link from same version of lotus notes, launching the same version internet
explorer external from lotus notes. Im almost sure this is some sort of
setting in the broswer or on the computer, unrelated to the application
itself. Any insight would be appreciated.
Thanks,
Casey Cook
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
RE: ;amp in my URL's?
--- AAARGH! That foul beast dares rear its head again!?!! (read with pirate voice and one eye squinted shut) I had/have this exact same problem. The site I work on has two sides: one that I manage, using CF, and the other that someone else manages, using any number of technologies, including Lotus Notes. The sign-in/registration system that I designed runs over the entire site, so the two sides have to play nice together. Because the other side doesn't use CF, I had to do some trickery. This trickery involves (among other things) _javascript_ code that sits on that other side, and which bounces users who aren't signed in over to my side. Of course, in doing this, I want to be sure that I can route users to their desired location after the sign-in. To do this, I place their desired URL into a URL variable. Here's where things fall apart. I can't remember exactly which part causes the error, but the idea is that some bit of it all (the browser, the _javascript_ code, something) converts those nice & characters to their HTML equivalents (&) and all hell breaks loose. As I remember it, the problem was even more complicated in that even if I got it through the first step, it might get fouled up at the second step (when I send the user back). Bottom line (ugly bottom line): my solution was to stop trusting the various bits that were converting the ampersand character into its equivalent and back. At the very start of the process, I replace all ampersands with the lovely string QQQampQQQ. At the very end of the process, I reverse the process, replacing QQQampQQQ with ampersands, and redirect to that address. I readily admit that there must be a better way. That said, I caution you against spending too much time finding it. As I remember it, the reason I went this way was that--while I could get it to work in one scenario--the various possible cases got rapidly complicated, and it was much easier to convert the string immediately into something that would be preserved regardless of which automatic conversion it was going through. All that said, can I help you at all? I would make sure I know the process from end to end: where does the URL begin its life as a variable, and where does it end that life. If you can't figure out an easy way to fix it, do the ugly trick above. HTH, Matthieu -- Thanks for the responses, we are still looking into the issue. So far we have potentially found a workaround with the code below. In the event I cant find the exact cause the work around should work, I guess I will find out soon enough. Hopefully the error reports disappear when I come in tomorrow morning. I still have some users to talk to tomorrow, hopefully our discussions narrow the search. url[urlField]> Thanks, CC x56927 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Looping....again
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,PREPATNO,SDOCPRESNO,SD OCNAME,SDRUGDESC,SALTDESC,SQTY,SRPTS,SAUTHORITY,SSIGS,SWARDNO "977669","22/12/2003","MR","ROBERT","ROBBERY","1 CITIZEN COURT","BRISBANE","4000","1234567890","31/07/2008","","","","","","714718"," Dr Bob Jones","SODIUM CHLORIDE IV 0.9% VFLEX 1L","SODIUM CHLORIDE","5","0","0","Use","CLIN" "46470","3/03/2004","MRS","PATRICIA","JOHNSON","2 CITIZEN COURT","BRISBANE","4000","1098765432","30/09/2007","C","406930987B","30/09/2 004","","","714718","Dr Bob Jones","TAXOL VL 300mg/50mL C'trate","PACLITAXEL","1","0","-1","","CLIN" "940528","18/11/2003","MR","BARRY","SMITH","3 CITIZEN COURT","BRISBANE","4000","2468101214","30/04/2010","C","405091751V","","","" ,"823793","Dr Bob Jones","NEULASTA PFS INJ 6mg/0.6mL","PEGFILGRASTIM PFS","1","0","-1","administer 6mg (0.6ml) from one prefilled syringe by subcutaneous injection the day after chemotherapy as directed","CLIN" "941320","18/11/2003","MR","GLENN","BRETT","4 CITIZEN COURT","BRISBANE","4000","5672453678","31/03/2009","","","","","","823793"," Dr Bob Jones","ETOPOPHOS VL 113.6mg","ETOPOSIDE PHOSPHATE","5","0","0","","CLIN" "108923","4/05/2004","MRS","DOROTHY","REES","5 CITIZEN COURT","BRISBANE","4000","66","30/09/2007","C","406003520C","","","" ,"823793","Dr Bob Jones","PROMETHAZINE AMP 50mg","PROMETHAZINE","10","0","0","","CLIN" "109139","4/05/2004","MRS","DOROTHY","REES","5 CITIZEN COURT","BRISBANE","4000","66","30/09/2007","C","406003520C","","","" ,"823793","Dr Bob Jones","SODIUM CHLORIDE IV 0.9% VFLEX 1L","SODIUM CHLORIDE","5","0","0","Use","CLIN" "108923","4/05/2004","MRS","DOROTHY","REES","5 CITIZEN COURT","BRISBANE","4000","66","30/09/2007","C","406003520C","","","" ,"823793","Dr Bob Jones","ETOPOPHOS VL 113.6mg","ETOPOSIDE PHOSPHATE","10","0","0","","CLIN" "109139","4/05/2004","MRS","DOROTHY","REES","5 CITIZEN COURT","BRISBANE","4000","66","30/09/2007","C","406003520C","","","" ,"823793","Dr Bob Jones","PANADOL TABLET 200mg","PANADOL","5","0","0","Use","CLIN" 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]
RE: cfexecute iexplore
You shouldn't be getting an Access Denied message unless you're not allowing anonymous users. (If the other website is open to the public, then anonymous access should be allowed). If you do need to login with a domain username and password, then use the username and password parameters in the cfhttp tag. Russ _ From: Patrick Whittingham [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 21, 2004 4:39 PM To: CF-Talk Subject: Re: cfexecute iexplore Actually when I use cfhttp, I get an 'Access Denied' on the 'other-box' ? Why? how do you do the command-line HTTP client? TIA, Patrick >> This doesn't seem to work, get no eror just doesn't 'perform' cfm > >I would strongly recommend that you use a command-line HTTP client if CFHTTP >doesn't work for you, rather than trying to automate IE. > >Dave Watts, CTO, Fig Leaf Software >http://www.figleaf.com/ >phone: 202-797-5496 >fax: 202-797-5444 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: cfexecute iexplore
> Actually when I use cfhttp, I get an 'Access Denied' on the > 'other-box' ? Why? My guess is that the other box doesn't allow anonymous access to the URL in question. Have you tried accessing it using USERNAME and PASSWORD attributes within CFHTTP? CFHTTP supports Basic Authentication. > how do you do the command-line HTTP client? I like to use wget, but there are lots of these things out there. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFCONTENT
> Can anyone explain how the tag works? > Does the tag create a temp file and tell IIS to return that file? > (creating more drive access overhead and longer CF execution > time) is the data to be returned piped to IIS instead? > (creating memory usage overhead and longer CF execution time) > or, does CF point IIS to the file that I want returned? > (which should be the same resource wise as just directly > linking to the file in the first place) I'm not absolutely sure about the internals of CF, but I can tell you that CF doesn't just point IIS to the file. There is significant overhead to using CFCONTENT to return files, beyond the overhead of a web server returning those files. > I had looked at Apache as an option for the server to use the > .htaccess files to prevent hotlinking, however the server > also needs to run several ASP applications which I've had > difficulty getting going under Apache. > Of course if anyone knows of another way to prevent > hotlinking, I would be grateful to hear it :) There are all sorts of approaches you might consider, such as the use of non-anonymous logins in IIS combined with filesystem permissions on the files in question which can be set from your CF program in various ways, or the use of temporary symbolic links to directories that aren't usually web-accessible. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: hosting ?
no problems here, have used them for years and never had trouble that long with anything, you might want to check & make sure account is still active? - Original Message - From: Simeon Bateman <[EMAIL PROTECTED]> Date: Tue, 21 Sep 2004 15:38:44 -0700 Subject: Re: hosting ? To: CF-Talk <[EMAIL PROTECTED]> speaking of crystaltech, my mail server has been down most of the day. Any other CrystalTechers having and issue? On Tue, 21 Sep 2004 15:57:19 -0500, Donna French <[EMAIL PROTECTED]> wrote: > sorry - CrystalTech.com junkie here > > had to put my 2 cents in somehow... > > > > > - Original Message - > From: Tim Laureska <[EMAIL PROTECTED]> > Date: Tue, 21 Sep 2004 16:58:54 -0400 > Subject: hosting ? > To: CF-Talk <[EMAIL PROTECTED]> > > Anyone have experience with hostmysite.com ... particularly the Ultra > Developer plan (SQL server)? > > Tim > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cfexecute iexplore
Patrick Whittingham wrote: > Actually when I use cfhttp, I get an 'Access Denied' on the 'other-box' ? Why? Because the directory is password protected? > how do you do the command-line HTTP client? Google for "wget". Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: hosting ?
speaking of crystaltech, my mail server has been down most of the day. Any other CrystalTechers having and issue? On Tue, 21 Sep 2004 15:57:19 -0500, Donna French <[EMAIL PROTECTED]> wrote: > sorry - CrystalTech.com junkie here > > had to put my 2 cents in somehow... > > > > > - Original Message - > From: Tim Laureska <[EMAIL PROTECTED]> > Date: Tue, 21 Sep 2004 16:58:54 -0400 > Subject: hosting ? > To: CF-Talk <[EMAIL PROTECTED]> > > Anyone have experience with hostmysite.com ... particularly the Ultra > Developer plan (SQL server)? > > Tim > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Coding question ?
This is not exactly what you are looking for, but it may work better, Build a data base to hold a local temp version of the data from the remote server. Then have a Scheduled Task run every minute or so to update your local version of the data. This should greatly speed up any page that relies on a query that could take 5 seconds. You could also could also cache the data from the remote database in a session var. Or look into query caching. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 _ From: applemicro [mailto:[EMAIL PROTECTED] Sent: Monday, September 20, 2004 8:54 AM To: CF-Talk Subject: Coding question ? I have a page that will display infromation from a remote database. What i want to do is display the information from the remote database but if the query to the remote database takes long then 5 sec I want to abort the current query and query my local database which contains a versions of the data but is 24 hours old Thanks Kurt _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
OT: JS Gateway Question
I am still in search of a solution to a problem I had a few weeks back.
This is OT for the CF list, but I am hoping someone here has used the JS
Gateway from www.pengoworks.com.
I have a form with a bunch of select boxes on it that I use qForms to
populate, etc (from a DB.. use ColdFusion to loop etc...). I also use
the JS Gateway for two of the select boxes; lets call them "A" and "B".
When the page initially loads everything works fine.. "A" populates fine
and when a user selects something in "A", "B" populates fine (using
Gateway). The issue I have is that when the user comes back into the
form after saving the form, how can I get "A" and "B" populated since
they rely on the Gateway for initial population as well as obtaining the
values for "B" from "A"?
I have tried everything from setting the value for the "A" select after
the loadOptions() method loads the options etc, but I keep finding
myself in this infinite loop or getting out of memory errors etc. Do you
know how I could accomplish getting "A" populated and set with the value
from the DB then get "B" set based on "A", finally setting the value of
"B" set with the value from that comes from the DB (if there is one of
course). I have come back to this problem many times, always failing to
find a solution.
Anyone using the Gateway and have some suggestions? In case it helps,
the following are the Gateway functions that are used:
Thanks!
-Mike
// Gateway Init() function
function init(){
objGateway.>
document.basicDataForm.strAgency.length = 1;
document.basicDataForm.strBureau.length = 1;
loadOptions("strAgency");
}
// Gateway populate() function
function populate(f, a){
var oField = document.basicDataForm[f];
oField.options.length = 0;
for( var i=0; i < a.length; i++ ) oField.options[oField.options.length]
= new Option(a[i][0], a[i][1]);
}
// Gateway loadOptions() function
function loadOptions(f){
var d = {}, oForm = document.basicDataForm;
if( f == "strAgency" ){
document.basicDataForm.strAgency.length = 1;
}
var sAgency =
oForm.strAgency.options[oForm.strAgency.options.selectedIndex].value;
displayLoadMsg(f);
objGateway.sendPacket({field: f, strAgency: sAgency});
}
// Gateway updateOptins() function
function updateOptions(){
if( this.received == null ) return false;
populate(this.received[0], this.received[1]);
return true;
}
// Gatewaye displayLoadMsg() function
function displayLoadMsg(f){
var oField = document.basicDataForm[f];
oField.options.length = 0;
oField.options[oField.options.length] = new Option("Loading data...",
"");
}
// Create the gateway object
objGateway.create();
// Initialize the gateway object
init();
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
RE: hosting ?
Thanks Michael for the feedback... I was also particularly interested in them because of the number of email accounts they provide with the ultra developer 250 -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 21, 2004 5:20 PM To: CF-Talk Subject: RE: hosting ? > From: Tim Laureska [mailto:[EMAIL PROTECTED] > Anyone have experience with hostmysite.com ... particularly > the Ultra Developer plan (SQL server)? I have a reseller account with HostMySite and my initial account is the Ultra Developer. Their support is awesome (24/7 phone and live chat). Their servers are nice as well and I have never had any problems with up time. Their DB servers are limited to the number of DBs on them, etc... Which is good! The prices are good, not the best, but their support makes up for the couple dollar difference when compared to their competitors. I highly recommend them, although I am eager to try out cfdynamics after speaking with them at the FB 4 conference. Michael T. Tangorre [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: hosting ?
> From: Tim Laureska [mailto:[EMAIL PROTECTED] > Anyone have experience with hostmysite.com ... particularly > the Ultra Developer plan (SQL server)? I have a reseller account with HostMySite and my initial account is the Ultra Developer. Their support is awesome (24/7 phone and live chat). Their servers are nice as well and I have never had any problems with up time. Their DB servers are limited to the number of DBs on them, etc... Which is good! The prices are good, not the best, but their support makes up for the couple dollar difference when compared to their competitors. I highly recommend them, although I am eager to try out cfdynamics after speaking with them at the FB 4 conference. Michael T. Tangorre [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: hosting ?
I use them sometimes, but their SQL server access seems really slow -Original Message- From: Donna French [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 21, 2004 4:57 PM To: CF-Talk Subject: Re: hosting ? sorry - CrystalTech.com junkie here had to put my 2 cents in somehow... - Original Message - From: Tim Laureska <[EMAIL PROTECTED]> Date: Tue, 21 Sep 2004 16:58:54 -0400 Subject: hosting ? To: CF-Talk <[EMAIL PROTECTED]> Anyone have experience with hostmysite.com ... particularly the Ultra Developer plan (SQL server)? Tim [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: hosting ?
sorry - CrystalTech.com junkie here had to put my 2 cents in somehow... - Original Message - From: Tim Laureska <[EMAIL PROTECTED]> Date: Tue, 21 Sep 2004 16:58:54 -0400 Subject: hosting ? To: CF-Talk <[EMAIL PROTECTED]> Anyone have experience with hostmysite.com ... particularly the Ultra Developer plan (SQL server)? Tim [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Coding question ?
Maybe a bit more complex a solution then you are looking for. But you can simulate a forked thread by putting the query in a separate page that runs the query and stores it as wddx packet, then call the page using cfhttp from another ColdFusion page. The calling page can wait a give amount of time to see if the cfhttp.filecontent returns I could go into more detail if you really wanted to try something like that. Patrick McGeehan Applications Developer DIT #mcg# -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: Monday, September 20, 2004 10:51 AM To: CF-Talk Subject: Re: Coding question ? On Monday 20 Sep 2004 14:53 pm, applemicro wrote: > I have a page that will display infromation from a remote database. > What i want to do is display the information from the remote database > but if the query to the remote database takes long then 5 sec I want > to abort the current query and query my local database which contains > a versions of the data but is 24 hours old [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
hosting ?
Anyone have experience with hostmysite.com ... particularly the Ultra Developer plan (SQL server)? Tim [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFCONTENT
Hi. I believe, but I might be wrong, that it simply changes the HTTP Header to make the returned CF page appear to be an attached file instead of a HTML page and then pipes the files to the browser a binary object. I don't believe any temporary file is returned, but neither is the actually location of the file. Andrew. - Original Message - From: Steven Wojciechowski <[EMAIL PROTECTED]> Date: Tue, 21 Sep 2004 21:39:04 +0100 Subject: CFCONTENT To: CF-Talk <[EMAIL PROTECTED]> I'm looking to use CFCONTENT to provide the various files on my website as I am finding hotlinking a bit of a problem at the moment and want to stop it. I'm hosting on a Windows 2000 Server with IIS5 and CFMX (6.1) and plan on using CFCONTENT to check the referring page to make sure it came from my own site, the implementation of the code is not a problem, I know how I'm going to do that, however my questions concerns how the CFCONTENT tag actually works at a low level. The files I have on my site vary from 0.5MB to 20 or 30MB so I want to be able to estimate what kind of extra overhead I will create when I have 20 to 30 files being downloaded at any one time. Can anyone explain how the tag works? Does the tag create a temp file and tell IIS to return that file? (creating more drive access overhead and longer CF execution time) is the data to be returned piped to IIS instead? (creating memory usage overhead and longer CF execution time) or, does CF point IIS to the file that I want returned? (which should be the same resource wise as just directly linking to the file in the first place) Any help on this would be very useful. I had looked at Apache as an option for the server to use the .htaccess files to prevent hotlinking, however the server also needs to run several ASP applications which I've had difficulty getting going under Apache. Of course if anyone knows of another way to prevent hotlinking, I would be grateful to hear it :) thanks in advance, Stevie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CFCONTENT
I'm looking to use CFCONTENT to provide the various files on my website as I am finding hotlinking a bit of a problem at the moment and want to stop it. I'm hosting on a Windows 2000 Server with IIS5 and CFMX (6.1) and plan on using CFCONTENT to check the referring page to make sure it came from my own site, the implementation of the code is not a problem, I know how I'm going to do that, however my questions concerns how the CFCONTENT tag actually works at a low level. The files I have on my site vary from 0.5MB to 20 or 30MB so I want to be able to estimate what kind of extra overhead I will create when I have 20 to 30 files being downloaded at any one time. Can anyone explain how the tag works? Does the tag create a temp file and tell IIS to return that file? (creating more drive access overhead and longer CF execution time) is the data to be returned piped to IIS instead? (creating memory usage overhead and longer CF execution time) or, does CF point IIS to the file that I want returned? (which should be the same resource wise as just directly linking to the file in the first place) Any help on this would be very useful. I had looked at Apache as an option for the server to use the .htaccess files to prevent hotlinking, however the server also needs to run several ASP applications which I've had difficulty getting going under Apache. Of course if anyone knows of another way to prevent hotlinking, I would be grateful to hear it :) thanks in advance, Stevie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CFC - Web service error handling
I have recently written my first, simple webservice and once I learned the importance of white space, ie have none; in any application.cfm file located in the same dirctory with the webservice CFC, all went well. My question is what is the best pratice to handling errors in a webservice? Other then have none, of course! It seems to me, on first glance, to be a bit of a tricky subject? What information, if any, about an error do you provide to a consumer of the webservice. And if you do provide information, how do you do this, if you are specifing the return type to be something incompatable with returning useful error information? -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA "C code. C code run. Run code run. Please!" - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cfexecute iexplore
Actually when I use cfhttp, I get an 'Access Denied' on the 'other-box' ? Why? how do you do the command-line HTTP client? TIA, Patrick >> This doesn't seem to work, get no eror just doesn't 'perform' cfm > >I would strongly recommend that you use a command-line HTTP client if CFHTTP >doesn't work for you, rather than trying to automate IE. > >Dave Watts, CTO, Fig Leaf Software >http://www.figleaf.com/ >phone: 202-797-5496 >fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cfexecute iexplore
Actually when I use cfhttp, I get an 'Access Denied' on the 'other-box' ? Why? how do you do the command-line HTTP client? TIA, Patrick >> This doesn't seem to work, get no eror just doesn't 'perform' cfm > >I would strongly recommend that you use a command-line HTTP client if CFHTTP >doesn't work for you, rather than trying to automate IE. > >Dave Watts, CTO, Fig Leaf Software >http://www.figleaf.com/ >phone: 202-797-5496 >fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Test (ignore)
Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 100 Chantilly, VA 20151 Phone: (703) 471-8400 Fax: (703) 834-5527 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Creating a unique ID from a Query Insert for use in an Update
I hear these guys ship! http://www.beeramerica.com/ Andy -Original Message- From: Steve Kahn [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 21, 2004 12:45 PM To: CF-Talk Subject: Re: Creating a unique ID from a Query Insert for use in an Update The primary key needed to be set. Thank you Andy, Dave and Paul I owe you all all round of drinks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Bug in CFMAILPART?
CFMAILPART (and the wrap()) function have always worked that way. I've submitted it as a bug at least twice (immediately after 6.1 was released, and some time later), and never heard anything back. cheers, barneyb On Tue, 21 Sep 2004 12:19:52 -0400, Damien McKenna <[EMAIL PROTECTED]> wrote: > I think I just noticed a bug in 6.1 (with the updater in place). The > CFMAILPART tag has an attribute called "wraptext" which allows you to > set the column at which text is wrapped. The problem is that it doesn't > work as it should. A text-wrap function should wrap text when the line > gets to a certain length. Currently (OSX WWW and mail client, Windows > server) it appears to wrap every X characters rather than if a line gets > beyond X characters (notice the difference?). > > An example... > > > 123456789 123456789 123456789 123456789 123456789 123456789 123456789 > > > Results in... > -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com Got GMail? I can help. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: cfexecute iexplore
> This doesn't seem to work, get no eror just doesn't 'perform' cfm > template. Why? > > > > > > type="READONLY"> > > timeOut="2" > outputfile="d:\apps\adam_webPCASSVerity\test.txt" > > I would strongly recommend that you use a command-line HTTP client if CFHTTP doesn't work for you, rather than trying to automate IE. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: FB4.1 ETA?
The UDF-based parser (and consequently custom lexicon verbs) was my project. Related was exposing the info from the fb_ struct required for custom lexicon verbs in a defined way, using a fb_.verbInfo struct. That'll let us change the way the fb_ structure works without affecting custom verbs. CVS is the way we're going. I've been running a server internally for a few weeks, but before we actually start using it as a team, some changes need to be made. And, of course, the process of coalescing all the changes that were made this weekend. I'm hoping to have that up and running today, though it will be controlled access for everything, no anonymous access, at least initially. I need to stress that 4.1 does NOT include custom lexicons in any supported fashion. The code to allow it is include in the cores as a preview of things to come in 4.2 (or whatever). So expect that your custom lexicons will occasionally need slight modifications until 4.2 (yes 4.2) is officially released. One problem with BD was it's different handling of variable names, in particular 'return'. CFMX will let you name a struct member "return", but BD won't. We renamed the attribute (on the INVOKE verb) to 'returnVariable'. The other was that BD won't let you assign a structure to one a key of a nested structure, even though this is a perfectly valid thing to do conceptually: Hopefully we'll get the new core files with the BD fixes out this week (as Beta 2, most likely). The UDF-based parser will most likely not be included, as we need to do some further testing on it to make sure nothing changed in terms of functionality. cheers, barneyb On Tue, 21 Sep 2004 07:42:39 -0700, Sean Corfield <[EMAIL PROTECTED]> wrote: > On Tue, 21 Sep 2004 15:37:48 +0100, John Beynon <[EMAIL PROTECTED]> wrote: > > we're going to have a new beta version later this week I'd suspect. > > Will it include the UDFs to generate parts of the parse file so the > lexicon stuff will be easier? I can't remember who was working on > that... you? Barney? > > > There were loads of us working on the core files over the weekend on > > different laptops so it's taking some time to merge all the changes > > back into a releasable set of cores. > > Use CVS!!! > > > Most changes hinge around > > bluedragon and changes we needed to make to enable 4.1 to run on BD, > > I'm surprised it needs so many changes - I thought 4.0 needed only a > one-line change in order to run on BD? > -- > Sean A Corfield -- http://www.corfield.org/blog/ -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com Got GMail? I can help. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
cfexecute iexplore
Hi All, This doesn't seem to work, get no eror just doesn't 'perform' cfm template. Why? Patrick Whittingham timeOut="2" outputfile="d:\apps\adam_webPCASSVerity\test.txt" > === pat_test2.cfm status==#v_textfile# [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: ;amp in my URL's?
>Im trapping a few errors per day which means probably 1-1000 users (or >more) is experiencing this problem, and not sure what could be causing it. AAARGH! That foul beast dares rear its head again!?!! (read with pirate voice and one eye squinted shut) I had/have this exact same problem. The site I work on has two sides: one that I manage, using CF, and the other that someone else manages, using any number of technologies, including Lotus Notes. The sign-in/registration system that I designed runs over the entire site, so the two sides have to play nice together. Because the other side doesn't use CF, I had to do some trickery. This trickery involves (among other things) _javascript_ code that sits on that other side, and which bounces users who aren't signed in over to my side. Of course, in doing this, I want to be sure that I can route users to their desired location after the sign-in. To do this, I place their desired URL into a URL variable. Here's where things fall apart. I can't remember exactly which part causes the error, but the idea is that some bit of it all (the browser, the _javascript_ code, something) converts those nice & characters to their HTML equivalents (&) and all hell breaks loose. As I remember it, the problem was even more complicated in that even if I got it through the first step, it might get fouled up at the second step (when I send the user back). Bottom line (ugly bottom line): my solution was to stop trusting the various bits that were converting the ampersand character into its equivalent and back. At the very start of the process, I replace all ampersands with the lovely string QQQampQQQ. At the very end of the process, I reverse the process, replacing QQQampQQQ with ampersands, and redirect to that address. I readily admit that there must be a better way. That said, I caution you against spending too much time finding it. As I remember it, the reason I went this way was that--while I could get it to work in one scenario--the various possible cases got rapidly complicated, and it was much easier to convert the string immediately into something that would be preserved regardless of which automatic conversion it was going through. All that said, can I help you at all? I would make sure I know the process from end to end: where does the URL begin its life as a variable, and where does it end that life. If you can't figure out an easy way to fix it, do the ugly trick above. HTH, Matthieu [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Anyone know any good J2EE or Java mail lists?
Hello all, Basically the subject says it all. Does any one know of any quality, high volume J2EE and/or Java mailing lists like this one? -- chris johnston www.fuzzylizard.com "For millions of years, mankind lived just like the animals and something happened which unleashed the power of our imagination, we learned to talk." Pink Floyd [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: MM deprecates ODBC on CF5? was: OT- Hosting Recommendation
> I checked the registry and it says the MDAC is 2.53, which I would > assume is 2.5 sp1 or 2.5 sp2. Should I upgrade it? Haven't had to > mess with this on any server for quite some time, but 2.53 doesn't > seem too far out of date. That is pretty old, actually. You might want to upgrade to the latest version, which is 2.8 I think. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Site-wide Error Handler Template for CFMX
part or all of this might be what you want. Its a handler and a viewer as well (If data is marked sensitive it doesn't email it). http://mysecretbase.com/Building_A_ColdFusion_Error_Handler.cfm -- --Matt Robertson-- MSB Designs, Inc. mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFX Tag no longer working - help!
Is there a reason that you do not use CFREPORT tag? - Original Message - From: julian @ b-ravestudio. com julian @ b-ravestudio. com <[EMAIL PROTECTED]> Date: Tue, 21 Sep 2004 13:01:31 -0400 Subject: CFX Tag no longer working - help! To: CF-Talk <[EMAIL PROTECTED]> Gretings all, I have been using the CFX_Printreport tag to launch the Crystal Report engine and print highly formatted reports for many years now. It has worked really well but recently the servers were upgraded to W2003 and now the tag does not work on the production machine but does on the backup machine. Both are running CFMX 6.1 and Windows 2003 Server, both have the same version of Crystal Reports installed. One works, the other doesn't, the appliation code is identical. I believe it must be something to do with permissions, authority or perhaps availability of ports but I don't know how to confirm or investigate these things. Does anyone have any ideas about how I can figure this out. Thanks in advance for any help Regards, Julian [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: MM deprecates ODBC on CF5? was: OT- Hosting Recommendation
Just ran the MS component checker. Its 2.5 sp3. On Tue, 21 Sep 2004 11:06:53 -0700, Matt Robertson <[EMAIL PROTECTED]> wrote: > Thanks very much for the info Sean. > > I checked the registry and it says the MDAC is 2.53, which I would > assume is 2.5 sp1 or 2.5 sp2. Should I upgrade it? Haven't had to > mess with this on any server for quite some time, but 2.53 doesn't > seem too far out of date. > > > > -- > --Matt Robertson-- > MSB Designs, Inc. > mysecretbase.com > -- --Matt Robertson-- MSB Designs, Inc. mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: replacing characters
http://www.cflib.org/udf.cfm?ID=725 Pascal > -Original Message- > From: Eric Creese [mailto:[EMAIL PROTECTED] > Sent: 21 September 2004 19:48 > To: CF-Talk > Subject: replacing characters > > I have some apps that let's user input data intoa databases. Users ofter > write a document in word then paste it's contents into a form field and > submit to the website. Problem I am seeing are characters such as ', ", - > from Word get inputed as bizare symbols so when the test is displayed on > the web don't looks somethikes this don^^?'t. any ideas > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: MM deprecates ODBC on CF5? was: OT- Hosting Recommendation
Thanks very much for the info Sean. I checked the registry and it says the MDAC is 2.53, which I would assume is 2.5 sp1 or 2.5 sp2. Should I upgrade it? Haven't had to mess with this on any server for quite some time, but 2.53 doesn't seem too far out of date. -- --Matt Robertson-- MSB Designs, Inc. mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: replacing characters
http://www.cflib.org/udf.cfm?ID=725 On Tue, 21 Sep 2004 12:47:52 -0500, Eric Creese <[EMAIL PROTECTED]> wrote: > I have some apps that let's user input data intoa databases. Users ofter write a document in word then paste it's contents into a form field and submit to the website. Problem I am seeing are characters such as ', ", - from Word get inputed as bizare symbols so when the test is displayed on the web don't looks somethikes this don^^?'t. any ideas > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: replacing characters
Eric Creese wrote: > I have some apps that let's user input data intoa databases. Users ofter > write a document in word then paste it's contents into a form field and > submit to the website. Problem I am seeing are characters such as ', ", > - from Word get inputed as bizare symbols so when the test is displayed > on the web don't looks somethikes this don^^?'t. any ideas Found out what those characters ascii codes are, and replace them with more acceptable substitutes using the Replace() function and the Chr() function. - Rick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Web Application Development using Cold Fusion in a Team Environment (Draft)
DC, "An open mind" would imply to keep on learning (including learning from others), the word, mind, may imply selective learning. Your comments have turned into contribution, thanks. Don >Hi Don > >I wasn't been cheeky, just pointing to the resources that I have seen >that seemed to fit in with your question. You should have a look at the >book and the coding guidelines, I got a lot from them anyway :) > >A few times I've found it heartening that what I kinda taught myself has >been what the pro's on the list advocate (still, it's a small drop in >the ocean compared to the new stuff I've learned :) > >Anyways, cheers and good luck with the doc > >-- >dc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
replacing characters
I have some apps that let's user input data intoa databases. Users ofter write a document in word then paste it's contents into a form field and submit to the website. Problem I am seeing are characters such as ', ", - from Word get inputed as bizare symbols so when the test is displayed on the web don't looks somethikes this don^^?'t. any ideas [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Creating a unique ID from a Query Insert for use in an Update
The primary key needed to be set. Thank you Andy, Dave and Paul I owe you all all round of drinks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Creating a unique ID from a Query Insert for use in an Update
1. Which version of MS SQL?
2. Do you have a field in TrackUsers that is set as the Identity field?
3. Try setting NoCount OFF
-Original Message-
From: Steve Kahn [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 21, 2004 12:28 PM
To: CF-Talk
Subject: Re: Creating a unique ID from a Query Insert for use in an Update
Code didnt pass the ID, fields came up with - what was missed?
SELECT *
FROM users
Where username = '#username#' and pwd = '#pwd#'
SET nocount on
INSERT INTO trackusers (username,pwd)
VALUES('#username#','#pwd#')
SELECT @@identity as myID
SET nocount on
UPDATE trackusers
SET Logindate=#login_datetime#, IP='#remote_addr#',
browser='#http_user_agent#', remote_host='#remote_host#',
remote_referer='#http_referer#'
WHERE userID = #key#
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
Re: Creating a unique ID from a Query Insert for use in an Update
Code didnt pass the ID, fields came up with - what was missed?
SELECT *
FROM users
Where username = '#username#' and pwd = '#pwd#'
SET nocount on
INSERT INTO trackusers (username,pwd)
VALUES('#username#','#pwd#')
SELECT @@identity as myID
SET nocount on
UPDATE trackusers
SET Logindate=#login_datetime#, IP='#remote_addr#', browser='#http_user_agent#', remote_host='#remote_host#', remote_referer='#http_referer#'
WHERE userID = #key#
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
RE: ;amp in my URL's?
This is a link clicked from lotus notes, the URL string is the link itself in the email. (there is not a cflocation) Also, its not a spider, these are actual users I talked to on the phone and walked through all the steps to reproduce the error. They throw the error when clicking the link and I do not. There is something different about their browser settings or computer settings that places the ;amp in the URL string, Im not sure what it could be. Thanks, Casey Cook [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFMX - XP SP2 and SQL Server
> Recently I installed XP SP2 on my machine and suddenly ColdFusion MX > is unable to connect to my SQL server present on the same machine. I > tried opening the port on Windows firewall and even disabling firewall > but it just won't connect. Can you connect from ODBC on the appropriate port? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: BLOB
I have been able to insert a file into an image field in a SQL 2000 database. I found that I had to use the built-in (Merant?) SQL Server driver rather than the Microsoft JDBC driver. Does anyone know of a reason why I can't use the built-in SQL Server driver? Are the performance/stability/features any worse/better than the JDBC driver? A coworker built a similar page in ASP and his pages insert a binary value into the SQL database much faster than my CF page does. Thanks M!ke [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CMS
As far as implimenting it as a PORTION on a site, that might be a question for the farcry list. But it's really not that hard to set up a new site for a competent developer. As for going in and modifying the code, I would say it's advanced coding. But there isn't that much reason to go under the hood. - Original Message - From: Phill B <[EMAIL PROTECTED]> Date: Tue, 21 Sep 2004 10:00:53 -0500 Subject: Re: CMS To: CF-Talk <[EMAIL PROTECTED]> I'm taking a look at Farcry and it looks pretty cool. One question. How easy is it to implement Farcry in small portions on a web site? Phillip B [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Bug in CFMAILPART?
Damien McKenna wrote: > >123456789 123456789 123456789 123456789 123456789 123456789 123456789 > > >results in... > > 123456789 123456789 123456789 123456789 123456789 123456789 123456789 However... 123456789 123456789 123456789 123456789 123456789 123456789 123456789 results in... 123456789 123456789 123456789 123456789 123456789 123456789 123456789 HOF guys, please fix your mailing list system... -- *Damien McKenna* - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 "Nothing endures but change." - Heraclitus [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Bug in CFMAILPART?
Damien McKenna wrote: >I think I just noticed a bug in 6.1 (with the updater in place). > There was a whole load more to the example that what came through. Odd. Here's example #1: 123456789 123456789 123456789 123456789 123456789 123456789 123456789 results in... [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CMS
Hard Farcry is very hard to install for beginners CFers... You need to learn before this is my impression... Cheers On Tue, 21 Sep 2004 10:00:53 -0500, Phill B <[EMAIL PROTECTED]> wrote: > I'm taking a look at Farcry and it looks pretty cool. One question. > How easy is it to implement Farcry in small portions on a web site? > > Phillip B > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: RDS, multiple instances, and DWMX2004
ah, i saw it here http://www.macromedia.com/support/coldfusion/ts/documents/tn18314.htm "Open the JRun_root\servers\server_name directory and delete the default-ear and rds directories; for example, delete C:\JRun4\servers\techsupp\rds and C:\JRun4\servers\techsupp\default-ear. This step removes the unneeded JRun default web application and disables RDS support. Macromedia Dreamweaver and HomeSite do not work properly with RDS when you have multiple ColdFusion servers on a single web server. " of course this doc is dated 10/2002 Guess I'll fire 'em up and see what happens! - Original Message - From: Dave Watts <[EMAIL PROTECTED]> Date: Tue, 21 Sep 2004 12:38:46 -0400 Subject: RE: RDS, multiple instances, and DWMX2004 To: CF-Talk <[EMAIL PROTECTED]> > Ok, I got a box with multiple CF instances running. Per the docs, I > have disabled RDS on all but the default CFusion server. DW can hook > up and all except I can't get it to see the DSNs on the other > instances! No RDS! a conundrum. Now, is it really best practise to > disable the RDS servers in multiple server instances? I've only seen > this mentioned on MACR site somewheres. It's a best practice to disable RDS on production servers for obvious reasons. I've never heard anything about disabling it in multiple-instance configurations beyond that, though. You can run RDS on each instance, and in fact, that's the default I think. However, you can't install ODBC services for additional instances beyond the first installed. That might be what you're thinking of. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CFX Tag no longer working - help!
Gretings all, I have been using the CFX_Printreport tag to launch the Crystal Report engine and print highly formatted reports for many years now. It has worked really well but recently the servers were upgraded to W2003 and now the tag does not work on the production machine but does on the backup machine. Both are running CFMX 6.1 and Windows 2003 Server, both have the same version of Crystal Reports installed. One works, the other doesn't, the appliation code is identical. I believe it must be something to do with permissions, authority or perhaps availability of ports but I don't know how to confirm or investigate these things. Does anyone have any ideas about how I can figure this out. Thanks in advance for any help Regards, Julian [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Bug in CFMAILPART?
Wow - that's completely against RFC. - Original Message - From: Sparrow-Hood, Walter To: CF-Talk Sent: Tuesday, September 21, 2004 12:40 PM Subject: RE: Bug in CFMAILPART? I just finished wrestling with what sounds like the same problem. Some mail servers (in my case, Exchange Server) have their own internal setting for word wrap and it will take whatever you generate from CF and apply it's own word wrapping rules - a real PITA. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: WWOT: OS X for Intel?
I fully agree with you (Jim). Your comments on linux and Firefox are very accurate as well. Anyway, as I see that this has gone way off the original topic of this thread, I would at least like to ask if any of you have any good books or resources involving User Interface Development/Design that you would recommend. I have read a book called "Inmates are Running the Asylum", which was very good, but I would like to see some more applied examples, etc. If you would like, e-mail them to me off-list or let's start another thread as I think this discussion is very valuable to all programmers and on par with discussions that we have on this list. Thanks again Jim and Rob. - Original Message - From: Jim Davis <[EMAIL PROTECTED]> Date: Mon, 20 Sep 2004 21:20:34 -0400 Subject: RE: WWOT: OS X for Intel? To: CF-Talk <[EMAIL PROTECTED]> I still say that overall they seem about the same to me. There are so many aspects to working with the OS's that you spend months coming up with lists of "good and bad" for each. For a brand new user my only suggestion is always to just pick the one that your friends already use so that you can hit them up for free support. ;^) As an aside this is exactly where I think that Linux is failing: so far we simply don't have any Linux Distros that even approach the consistency and usability of the big two. To a lesser extent I see the same problem with FireFox - it's a gem wrapped in brown paper and that's a shame. Jim Davis From: Rob [mailto:[EMAIL PROTECTED] Sent: Monday, September 20, 2004 8:05 PM To: CF-Talk Subject: Re: WWOT: OS X for Intel? On Mon, 20 Sep 2004 19:42:11 -0400, Jim Davis <[EMAIL PROTECTED]> wrote: > As a professional human factors person my personal opinion is that both OX X > and XP score about even (overall) on usability. I think that mac osx is a bit higher scoring on the UI because things seem to be more readily available. Quite the opposite of the cd burner icon complaint. With windows you have to drill down for everything - from the start menu to the open file dialog everything is hidden (the exception being the actual desktop). While mac has that too, the launching docker and the 4 pane file opening dialog make it seem easier to find / organize things - it just seems more fluid, less hidden, and better organized. > Both have frustrations, > neither is completely immediately intuitive and both show that we've miles > to go before the holy grail of the "invisible interface". ;^) Yeah true that - and we probably wont get there if there is only one way forced on everyone ;-) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Creating a unique ID from a Query Insert for use in an Update
> What does SET NOCOUNT do? it tells sql server not to return info about how many rows were processed. saves a bit of time & in the past was the only way to stuff cfquery w/more than one SELECT/INSERT/etc. statement. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Duplicate(cfcatch)
> Yesterday, I was able to reliably reproduce a nice, juicy "You are > attempting to dereference a scalar..." error with the Duplicate(cfcatch) > statement - a known issue with the 6.1 updater. However, upon logging > into my system today, MX seems to have forgiven the issue and now happily > accepts the statement. > > Now, since magic unfortunately doesn't exists and the jury's still out > on whether our computers actually mess with us on purpose, there's > obviously a key in the CFCATCH structure that's a string that was being > referenced yesterday that isn't being referenced today. Computers are way too stupid to do anything on purpose, so you can count that out. If you catch different exception types, they may contain different things. This is especially true in CFMX, where the exception object is essentially a wrapper of some Java object. There are some articles about this on Sean Corfield's and/or Brandon Purcell's blogs, I think. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: ot: jrun ?
On Tue, 21 Sep 2004 11:35:05 -0500, Ben Frame <[EMAIL PROTECTED]> wrote: > Neil, > > Why set the initial and max heap size the same? Is that > recommendation documented from Macromedia anywhere or is that from > your own experiences? > Setting the two values to be the same increases performance in so far as it eliminates the need for the JVM to resize itself based on the resources being used. This can be an expensive process, which might cause a degradation with regard to your application performance. Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Bug in CFMAILPART?
I just finished wrestling with what sounds like the same problem. Some mail servers (in my case, Exchange Server) have their own internal setting for word wrap and it will take whatever you generate from CF and apply it's own word wrapping rules - a real PITA. -Original Message- From: Damien McKenna [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 21, 2004 12:20 PM To: CF-Talk Subject: Bug in CFMAILPART? I think I just noticed a bug in 6.1 (with the updater in place). The CFMAILPART tag has an attribute called "wraptext" which allows you to set the column at which text is wrapped. The problem is that it doesn't work as it should. A text-wrap function should wrap text when the line gets to a certain length. Currently (OSX WWW and mail client, Windows server) it appears to wrap every X characters rather than if a line gets beyond X characters (notice the difference?). An example... 123456789 123456789 123456789 123456789 123456789 123456789 123456789 Results in... [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: ot: jrun ?
Neil, Why set the initial and max heap size the same? Is that recommendation documented from Macromedia anywhere or is that from your own experiences? -Ben - Original Message - From: Robertson-Ravo, Neil (RX) <[EMAIL PROTECTED]> Date: Tue, 21 Sep 2004 10:59:04 +0100 Subject: RE: ot: jrun ? To: CF-Talk <[EMAIL PROTECTED]> Yep, the CFMX default setting is 512 which for your machine is way to high...set it down to 128 or something (always ensure its in 64mb chunks). You may have a problem with memory though ...you may get Java out of Memory errors. Oh, and always set you initial heap size and your max heap size to be the same. N _ From: Andrew Dixon [mailto:[EMAIL PROTECTED] Sent: 21 September 2004 10:06 To: CF-Talk Subject: Re: ot: jrun ? Change the max memory variable in CFAdmin. Andrew. - Original Message - From: dave <[EMAIL PROTECTED]> Date: Tue, 21 Sep 2004 04:49:10 -0400 Subject: ot: jrun ? To: CF-Talk <[EMAIL PROTECTED]> is there anyway to setup jrun not to use so many resources on a dev machine? friggin killin my machine, and i need to run jrun so i can also run flex right now its taking up 130,152 kbs running 768mb ram, but sheesh _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Creating a unique ID from a Query Insert for use in an Update
> Scope_identity threw an error. > > [Microsoft][ODBC SQL Server Driver][SQL Server]'scope_identity' is not > a recognized function name. I think that was introduced in SQL Server 2000. If you're using an older version, it won't be available. Use @@IDENTITY instead in that case. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: RDS, multiple instances, and DWMX2004
> Ok, I got a box with multiple CF instances running. Per the docs, I > have disabled RDS on all but the default CFusion server. DW can hook > up and all except I can't get it to see the DSNs on the other > instances! No RDS! a conundrum. Now, is it really best practise to > disable the RDS servers in multiple server instances? I've only seen > this mentioned on MACR site somewheres. It's a best practice to disable RDS on production servers for obvious reasons. I've never heard anything about disabling it in multiple-instance configurations beyond that, though. You can run RDS on each instance, and in fact, that's the default I think. However, you can't install ODBC services for additional instances beyond the first installed. That might be what you're thinking of. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Creating a unique ID from a Query Insert for use in an Update
What does SET NOCOUNT do? Andy -Original Message- From: Paul Hastings [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 21, 2004 11:14 AM To: CF-Talk Subject: Re: Creating a unique ID from a Query Insert for use in an Update > > set nocount on > Insert into trackusers(username,pwd) > values(#username#,#pwd#); > Select scope_identity() as myID > Set nocount on > SET NOCOUNT OFF actually... [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Bug in CFMAILPART?
I think I just noticed a bug in 6.1 (with the updater in place). The CFMAILPART tag has an attribute called "wraptext" which allows you to set the column at which text is wrapped. The problem is that it doesn't work as it should. A text-wrap function should wrap text when the line gets to a certain length. Currently (OSX WWW and mail client, Windows server) it appears to wrap every X characters rather than if a line gets beyond X characters (notice the difference?). An example... 123456789 123456789 123456789 123456789 123456789 123456789 123456789 Results in... [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RDS, multiple instances, and DWMX2004
Ok, I got a box with multiple CF instances running. Per the docs, I have disabled RDS on all but the default CFusion server. DW can hook up and all except I can't get it to see the DSNs on the other instances! No RDS! a conundrum. Now, is it really best practise to disable the RDS servers in multiple server instances? I've only seen this mentioned on MACR site somewheres. -- Douglas Knudsen http://www.cubicleman.com this is my signature, like it? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Creating a unique ID from a Query Insert for use in an Update
Scope_identity threw an error.
[Microsoft][ODBC SQL Server Driver][SQL Server]'scope_identity' is not a recognized function name.
SQL = "set nocount on Insert into trackusers (username,pwd) values('admin','admin'); Select scope_identity() as myID Set nocount on"
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
Re: Creating a unique ID from a Query Insert for use in an Update
> values(#username#,#pwd#);
forgot the single quotes.
values('#username#','#pwd#')
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
RE: BLOB
Says the DB minx ;-) if you have the RAM, the processing power and the file space to run with BLOBs then go for it...I personally and have always been warned off using them from various sources...they are not user friendly true that may be changing but in essence there really should be a need for them ..if you can use a pointer to a physical object). There is a saber to everones foil on this issuelike someone mentioned and maybe I was a tad strong and single minded but I do think BLOB's are a just not good for such things as Web Apps...and using with CF _ From: Paul Hastings [mailto:[EMAIL PROTECTED] Sent: 21 September 2004 17:01 To: CF-Talk Subject: Re: BLOB > Well yes and no, it's not just my opinion its also good SQL practice, > Storing data in BLOB's and CLOB's is not good full stop. It leads to says who? > If you can give me a valid business case of storing data in this matter > which overrides the fact its bad practice then I am all ears. multiuser, continuous data, data integrity, transactions, business rule implementation, centralized storage and management, not having to manage millions of files, etc. pretty much every reason why you'd use a db in the first place. the whole GIS industry is running its enterprise databases on modern BLOB (spatial) technology. ibm, oracle, ms, esri, mapinfo, etc. have all spent a bundle on this technology. even freebies like postgres (postGIS is actually pretty slick) & mySQL are on the bandwagon. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Creating a unique ID from a Query Insert for use in an Update
> > set nocount on > Insert into trackusers(username,pwd) > values(#username#,#pwd#); > Select scope_identity() as myID > Set nocount on > SET NOCOUNT OFF actually... [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Creating a unique ID from a Query Insert for use in an Update
Yes UserID is an AutoIncrement, however it threw an error. ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]The name 'admin' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted. SQL = "set nocount on Insert into trackusers(username,pwd) values(admin,admin); Select scope_identity() as myID Set nocount on" [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: BLOB
> Well yes and no, it's not just my opinion its also good SQL practice, > Storing data in BLOB's and CLOB's is not good full stop. It leads to says who? > If you can give me a valid business case of storing data in this matter > which overrides the fact its bad practice then I am all ears. multiuser, continuous data, data integrity, transactions, business rule implementation, centralized storage and management, not having to manage millions of files, etc. pretty much every reason why you'd use a db in the first place. the whole GIS industry is running its enterprise databases on modern BLOB (spatial) technology. ibm, oracle, ms, esri, mapinfo, etc. have all spent a bundle on this technology. even freebies like postgres (postGIS is actually pretty slick) & mySQL are on the bandwagon. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: ot: jrun ?
yeah, but I wouldn't use JRun to manage that. There was a bug in the JMC that mucked up saves, dunno if it was fixed in the JRun updater. Anyhoo, this only mods teh default jvm.config, so it effects all instances. Doug - Original Message - From: John Beynon <[EMAIL PROTECTED]> Date: Tue, 21 Sep 2004 16:40:46 +0100 Subject: Re: ot: jrun ? To: CF-Talk <[EMAIL PROTECTED]> is that the same as in the 'settings' on a jrun instance from the jrun admin or not? I'm kinda new to Jrun stuff too and it's good stuff to know, jb. On Tue, 21 Sep 2004 08:56:56 -0400, Douglas Knudsen <[EMAIL PROTECTED]> wrote: > and if you want your service to automagically start with this config > file look at bin/jrunsvc...an example > > jrunsvc -install cfusion "Macromedia JRun CFusion Server" "Macromedia > JRun CFusion Server" -config jvm.config_cfusion > > Doug > > > - Original Message - > From: [EMAIL PROTECTED] <[EMAIL PROTECTED]> > Date: Tue, 21 Sep 2004 05:02:15 -0500 > Subject: Re: ot: jrun ? > To: CF-Talk <[EMAIL PROTECTED]> > > You can set the amount of memory available to the JVM in your jvm.config file > in the "bin" directory beneath wherever JRun is installed. If you want to > change the amount of memory available to specific servers, create a copy of > jvm.config for whatever server(s) should have their own start-up parameters, > change the server specific config file parameters to whatever you want them set > to, and make sure that whenever you start that server you do so from a command > line with the "-config" argument. The start-up command should something like > this: jrun -config thisServerConfFileName -start "thisServerName" obviously, > replace "thisServerName" with the name of the server and > replace "thisServerConfFileName" with the name of the config file that the > server in question should use. > > ~Simon > > > > > is there anyway to setup jrun not to use so many resources on a dev machine? > > friggin killin my machine, and i need to run jrun so i can also run flex > > right now its taking up 130,152 kbs > > > > running 768mb ram, but sheesh > > > > > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Web Application Development using Cold Fusion in a Team Environment (Draft)
Hi Don I wasn't been cheeky, just pointing to the resources that I have seen that seemed to fit in with your question. You should have a look at the book and the coding guidelines, I got a lot from them anyway :) A few times I've found it heartening that what I kinda taught myself has been what the pro's on the list advocate (still, it's a small drop in the ocean compared to the new stuff I've learned :) Anyways, cheers and good luck with the doc -- dc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Creating a unique ID from a Query Insert for use in an Update
Note that this issues that trackusers.UserId is Auto Increment field. -Original Message- From: Steve Kahn [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 21, 2004 10:33 AM To: CF-Talk Subject: Re: Creating a unique ID from a Query Insert for use in an Update Yes Microsoft SQL: Is this correct usage? set nocount on Insert into trackusers(username,pwd) values(#username#,#pwd#); Select scope_identity() as myID Set nocount on Then: Would the Update be ... UPDATE trackusers SET Logindate=#login_datetime#, IP='#remote_addr#', browser='#http_user_agent#', remote_host='#remote_host#', remote_referer='#http_referer#' WHERE userID = #key# [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Creating a unique ID from a Query Insert for use in an Update
yes. -Original Message- From: Steve Kahn [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 21, 2004 10:33 AM To: CF-Talk Subject: Re: Creating a unique ID from a Query Insert for use in an Update Yes Microsoft SQL: Is this correct usage? set nocount on Insert into trackusers(username,pwd) values(#username#,#pwd#); Select scope_identity() as myID Set nocount on Then: Would the Update be ... UPDATE trackusers SET Logindate=#login_datetime#, IP='#remote_addr#', browser='#http_user_agent#', remote_host='#remote_host#', remote_referer='#http_referer#' WHERE userID = #key# [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: BLOB
>Storing data of this type in a database is not good practice, it should be >avoided at all costs... That reads anti-BLOB to me. But reardless, I'm just saying its not as clear cut as that. There are legit reasons to storing large objects in databases. I also forgot another benefit, full-text searching. -Adam - Original Message - From: Robertson-Ravo, Neil (RX) <[EMAIL PROTECTED]> Date: Tue, 21 Sep 2004 16:15:48 +0100 Subject: RE: BLOB To: CF-Talk <[EMAIL PROTECTED]> Not at all, I am not anti-BLOB...just storing file objects etc is not goodWhat if your DB is taken down.? _ From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: 21 September 2004 16:10 To: CF-Talk Subject: Re: BLOB Clustering and data integrity to name a couple reasons. If I have say 6 clusters worldwide supporting my application. A record in an application can have multiple files associated with it. I can piggy-back the database replication to move the files rather than create and/or use a seperate system for replication. Now I don't endorse putting every little thing into a database, and I don't recommend it should be used as the primary storage. I belive it was Jim Davis who wrote about a hybrid solution between database and file-system. In the application I mentioned above, the files are replicated across all the databases and CF pulls down new and/or updated versions to store in file system. The application uses the file-system for primary storage and retrival. As for bloating the database size, it's pretty insignificant in the grand scheme of things. (Of course I recommend you cap file sizes regardless) Plus we now have the ability to perform a full database backup without having to run backups on the file-system. At any point, the database and source can be deployed as fully operational version, without losing the files associated with the data. I'm sorry if I was a bit blunt before, but like clockwork, if anyone asks anything about BLOBs on this list, there is the immediate criticism of "You shouldn't do that", rather than offering assitance. -Adam - Original Message - From: Robertson-Ravo, Neil (RX) <[EMAIL PROTECTED]> Date: Tue, 21 Sep 2004 15:42:06 +0100 Subject: RE: BLOB To: CF-Talk <[EMAIL PROTECTED]> Well yes and no, it's not just my opinion its also good SQL practice, Storing data in BLOB's and CLOB's is not good full stop. It leads to overgrown database systems and unnecessary storage of binary data. You have to see it from this point of view, SQL and Databases per say are a data manipulation language/design when you have data in a BLOB what are you doing to do with it? It can't be modified or altered via SQL, so in essence its pointless. If you have the file to insert into a BLOB then just store a reference to that file object. If you can give me a valid business case of storing data in this matter which overrides the fact its bad practice then I am all ears. N _ From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: 21 September 2004 14:57 To: CF-Talk Subject: Re: BLOB >Storing data of this type in a database is not good practice, it should be >avoided at all costs... Your opinion doesn't necessarily = good practice. -Adam - Original Message - From: Robertson-Ravo, Neil (RX) <[EMAIL PROTECTED]> Date: Tue, 21 Sep 2004 14:29:23 +0100 Subject: RE: BLOB To: CF-Talk <[EMAIL PROTECTED]> Storing data of this type in a database is not good practice, it should be avoided at all costs... _ From: Dawson, Michael [mailto:[EMAIL PROTECTED] Sent: 21 September 2004 13:50 To: CF-Talk Subject: RE: BLOB Read this thread http://www.macromedia.com/cfusion/webforums/forum/messageview.cfm?catid= 2&threadid=795052 I'm trying to do the same thing, with little success. I can't get the binary data inserted into SQL, however, I can use ToBase64() and insert it, but that's not really what I want to do. I am able to get binary data (jpgs) from a database, but I'm not able to insert a binary file. I hope someone can shed some light on this for us all. Thanks From: Parker, Kevin [mailto:[EMAIL PROTECTED] Sent: Monday, September 20, 2004 11:23 PM To: CF-Talk Subject: BLOB How do you add a file (e.g. PDF) to SQL Server as opposed to creating a row that you convert to a URL that links to it. I want to create an application that includes student dossiers so I don't want them to be locatable or downloadable by anyone or anything other than application users. Security is at application level and managed by the application, not directory level. Is this the best or recommended approach. _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: ot: jrun ?
is that the same as in the 'settings' on a jrun instance from the jrun admin or not? I'm kinda new to Jrun stuff too and it's good stuff to know, jb. On Tue, 21 Sep 2004 08:56:56 -0400, Douglas Knudsen <[EMAIL PROTECTED]> wrote: > and if you want your service to automagically start with this config > file look at bin/jrunsvc...an example > > jrunsvc -install cfusion "Macromedia JRun CFusion Server" "Macromedia > JRun CFusion Server" -config jvm.config_cfusion > > Doug > > > - Original Message - > From: [EMAIL PROTECTED] <[EMAIL PROTECTED]> > Date: Tue, 21 Sep 2004 05:02:15 -0500 > Subject: Re: ot: jrun ? > To: CF-Talk <[EMAIL PROTECTED]> > > You can set the amount of memory available to the JVM in your jvm.config file > in the "bin" directory beneath wherever JRun is installed. If you want to > change the amount of memory available to specific servers, create a copy of > jvm.config for whatever server(s) should have their own start-up parameters, > change the server specific config file parameters to whatever you want them set > to, and make sure that whenever you start that server you do so from a command > line with the "-config" argument. The start-up command should something like > this: jrun -config thisServerConfFileName -start "thisServerName" obviously, > replace "thisServerName" with the name of the server and > replace "thisServerConfFileName" with the name of the config file that the > server in question should use. > > ~Simon > > > > > is there anyway to setup jrun not to use so many resources on a dev machine? > > friggin killin my machine, and i need to run jrun so i can also run flex > > right now its taking up 130,152 kbs > > > > running 768mb ram, but sheesh > > > > > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Web Application Development using Cold Fusion in a Team Environment (Draft)
DC, It seems that my "quickie" write-up of my understanding of Web application development with Cold Fusion in a team environment is the "natural" (logical, might be a bit self-congratulating) outcome based on my years and years of CF experience (way before ASP etc. came along) and a relatively open mind (the point is along that line). FYI, I haven't even browsed BF's certication book (not that I shouldn't), as for MM Coding Guidelines, maybe I've read that long time ago. Thanks for the comment. >>> Each of these would be discussed in some detail below. > >That list kinda looks like the index of Ben's Cold Fusion MX >Certification book :) >http://forta.com/books/0321180585/ > >And the Macromedia Coding Guidelines >http://livedocs.macromedia.com/wtg/public/coding_standards/ > >And a bit of teamwork psychology thrown in... how about Belbin or Myers >Briggs :) > >(On a side note somebody called me 'empire building' in my last Belbin >and I was a blue surprisingly in Myers Briggs... hehehehe) > >-- >dc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Creating a unique ID from a Query Insert for use in an Update
Yes Microsoft SQL: Is this correct usage? set nocount on Insert into trackusers(username,pwd) values(#username#,#pwd#); Select scope_identity() as myID Set nocount on Then: Would the Update be ... UPDATE trackusers SET Logindate=#login_datetime#, IP='#remote_addr#', browser='#http_user_agent#', remote_host='#remote_host#', remote_referer='#http_referer#' WHERE userID = #key# [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Creating a unique ID from a Query Insert for use in an Update
What database? For MS SQL: set nocount on Insert into Select scope_identity() as myID Set nocount on Then: Andy -Original Message- From: Steve Kahn [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 21, 2004 10:12 AM To: CF-Talk Subject: Creating a unique ID from a Query Insert for use in an Update I have a login that I want to capture user stats with. However, I am having trouble identifing the QUERY INSERT with the UPDATE. In this case I am attempting to identify the userID and pass it to the Update. This is probably not the best method - any suggestions. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: FB4.1 ETA?
yes, both Vince are Charlie have been involved in our discussions, jb. On Tue, 21 Sep 2004 08:12:28 -0700, Sean Corfield <[EMAIL PROTECTED]> wrote: > On Tue, 21 Sep 2004 15:49:28 +0100, John Beynon <[EMAIL PROTECTED]> wrote: > > 4.1 barfed on BD with the following line: > > > > > > > > it's been replaced and the references to fb_.appPathVarScope ammended. > > There was also another issue found where the invoke verb used return= > > which barfed on BD so was amended to returnvariable= > > I hope all these are being logged as bugs in BD and that Vince and > crew will fix them as part of 6.2? Vince? > > > The UDFs should make it into a 4.1 beta release I'd hope. It certainly > > made the parser easier to read > > Cool. Good to know. I'm looking forward to using the lexicon feature! > -- > Sean A Corfield -- http://www.corfield.org/blog/ > > "If you're not annoying somebody, you're not really alive." > -- Margaret Atwood > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: BLOB
>It can't be modified or altered via SQL, so in essence its >pointless. If you have the file to insert into a BLOB then just store a >reference to that file object. It should also be noted that DBs have come a _long_ way in handling binary data. I'm not talking about Access here. For instance in Oracle you can use PL/SQL or Java to modify the files within the database. Another note about the size, again I'm speaking about Oracle, only small files are actually stored in a table. Usually only pointers are stored into the tables. -Adam On Tue, 21 Sep 2004 11:09:48 -0400, Adrocknaphobia <[EMAIL PROTECTED]> wrote: > Clustering and data integrity to name a couple reasons. If I have say > 6 clusters worldwide supporting my application. A record in an > application can have multiple files associated with it. I can > piggy-back the database replication to move the files rather than > create and/or use a seperate system for replication. > > Now I don't endorse putting every little thing into a database, and I > don't recommend it should be used as the primary storage. I belive it > was Jim Davis who wrote about a hybrid solution between database and > file-system. In the application I mentioned above, the files are > replicated across all the databases and CF pulls down new and/or > updated versions to store in file system. The application uses the > file-system for primary storage and retrival. > > As for bloating the database size, it's pretty insignificant in the > grand scheme of things. (Of course I recommend you cap file sizes > regardless) Plus we now have the ability to perform a full database > backup without having to run backups on the file-system. At any point, > the database and source can be deployed as fully operational version, > without losing the files associated with the data. > > I'm sorry if I was a bit blunt before, but like clockwork, if anyone > asks anything about BLOBs on this list, there is the immediate > criticism of "You shouldn't do that", rather than offering assitance. > > -Adam > > > > - Original Message - > From: Robertson-Ravo, Neil (RX) <[EMAIL PROTECTED]> > Date: Tue, 21 Sep 2004 15:42:06 +0100 > Subject: RE: BLOB > To: CF-Talk <[EMAIL PROTECTED]> > > Well yes and no, it's not just my opinion its also good SQL practice, > Storing data in BLOB's and CLOB's is not good full stop. It leads to > overgrown database systems and unnecessary storage of binary data. You have > to see it from this point of view, SQL and Databases per say are a data > manipulation language/design when you have data in a BLOB what are you doing > to do with it? It can't be modified or altered via SQL, so in essence its > pointless. If you have the file to insert into a BLOB then just store a > reference to that file object. > > If you can give me a valid business case of storing data in this matter > which overrides the fact its bad practice then I am all ears. > > N > > _ > > From: Adrocknaphobia [mailto:[EMAIL PROTECTED] > Sent: 21 September 2004 14:57 > To: CF-Talk > Subject: Re: BLOB > > >Storing data of this type in a database is not good practice, it should be > >avoided at all costs... > > Your opinion doesn't necessarily = good practice. > > -Adam > > - Original Message - > From: Robertson-Ravo, Neil (RX) <[EMAIL PROTECTED]> > Date: Tue, 21 Sep 2004 14:29:23 +0100 > Subject: RE: BLOB > To: CF-Talk <[EMAIL PROTECTED]> > > Storing data of this type in a database is not good practice, it should be > avoided at all costs... > > _ > > From: Dawson, Michael [mailto:[EMAIL PROTECTED] > Sent: 21 September 2004 13:50 > To: CF-Talk > Subject: RE: BLOB > > Read this thread > > http://www.macromedia.com/cfusion/webforums/forum/messageview.cfm?catid= > 2&threadid=795052 > > I'm trying to do the same thing, with little success. I can't get the > binary data inserted into SQL, however, I can use ToBase64() and insert > it, but that's not really what I want to do. > > I am able to get binary data (jpgs) from a database, but I'm not able to > insert a binary file. > > I hope someone can shed some light on this for us all. > > Thanks > > > > From: Parker, Kevin [mailto:[EMAIL PROTECTED] > Sent: Monday, September 20, 2004 11:23 PM > To: CF-Talk > Subject: BLOB > > How do you add a file (e.g. PDF) to SQL Server as opposed to > creating a row that you convert to a URL that links to it. > > I want to create an application that includes student dossiers > so I don't want them to be locatable or downloadable by anyone or > anything other than application users. Security is at application level > and managed by the application, not directory level. > > Is this the best or recommended approach. > > _ > > _ > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: BLOB
Not at all, I am not anti-BLOB...just storing file objects etc is not goodWhat if your DB is taken down.? _ From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: 21 September 2004 16:10 To: CF-Talk Subject: Re: BLOB Clustering and data integrity to name a couple reasons. If I have say 6 clusters worldwide supporting my application. A record in an application can have multiple files associated with it. I can piggy-back the database replication to move the files rather than create and/or use a seperate system for replication. Now I don't endorse putting every little thing into a database, and I don't recommend it should be used as the primary storage. I belive it was Jim Davis who wrote about a hybrid solution between database and file-system. In the application I mentioned above, the files are replicated across all the databases and CF pulls down new and/or updated versions to store in file system. The application uses the file-system for primary storage and retrival. As for bloating the database size, it's pretty insignificant in the grand scheme of things. (Of course I recommend you cap file sizes regardless) Plus we now have the ability to perform a full database backup without having to run backups on the file-system. At any point, the database and source can be deployed as fully operational version, without losing the files associated with the data. I'm sorry if I was a bit blunt before, but like clockwork, if anyone asks anything about BLOBs on this list, there is the immediate criticism of "You shouldn't do that", rather than offering assitance. -Adam - Original Message - From: Robertson-Ravo, Neil (RX) <[EMAIL PROTECTED]> Date: Tue, 21 Sep 2004 15:42:06 +0100 Subject: RE: BLOB To: CF-Talk <[EMAIL PROTECTED]> Well yes and no, it's not just my opinion its also good SQL practice, Storing data in BLOB's and CLOB's is not good full stop. It leads to overgrown database systems and unnecessary storage of binary data. You have to see it from this point of view, SQL and Databases per say are a data manipulation language/design when you have data in a BLOB what are you doing to do with it? It can't be modified or altered via SQL, so in essence its pointless. If you have the file to insert into a BLOB then just store a reference to that file object. If you can give me a valid business case of storing data in this matter which overrides the fact its bad practice then I am all ears. N _ From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: 21 September 2004 14:57 To: CF-Talk Subject: Re: BLOB >Storing data of this type in a database is not good practice, it should be >avoided at all costs... Your opinion doesn't necessarily = good practice. -Adam - Original Message - From: Robertson-Ravo, Neil (RX) <[EMAIL PROTECTED]> Date: Tue, 21 Sep 2004 14:29:23 +0100 Subject: RE: BLOB To: CF-Talk <[EMAIL PROTECTED]> Storing data of this type in a database is not good practice, it should be avoided at all costs... _ From: Dawson, Michael [mailto:[EMAIL PROTECTED] Sent: 21 September 2004 13:50 To: CF-Talk Subject: RE: BLOB Read this thread http://www.macromedia.com/cfusion/webforums/forum/messageview.cfm?catid= 2&threadid=795052 I'm trying to do the same thing, with little success. I can't get the binary data inserted into SQL, however, I can use ToBase64() and insert it, but that's not really what I want to do. I am able to get binary data (jpgs) from a database, but I'm not able to insert a binary file. I hope someone can shed some light on this for us all. Thanks From: Parker, Kevin [mailto:[EMAIL PROTECTED] Sent: Monday, September 20, 2004 11:23 PM To: CF-Talk Subject: BLOB How do you add a file (e.g. PDF) to SQL Server as opposed to creating a row that you convert to a URL that links to it. I want to create an application that includes student dossiers so I don't want them to be locatable or downloadable by anyone or anything other than application users. Security is at application level and managed by the application, not directory level. Is this the best or recommended approach. _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
