Re: OT: C# equivalent of CFDUMP
On Thursday 08 Jan 2004 20:20 pm, Mauricio Giraldo wrote: printf :-) isn't printf kind of more like cfoutput? I dunno. I write CFML :-) -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFC Constructor Question
On Thursday 08 Jan 2004 21:38 pm, Paul Hastings wrote: oh my. i hope you're not using dw to handle your i81n text. We're not even thinking about i18n *yet* - it's almost certain to become more important in the future though. Gonna be fun tearing our app apart to seperate the presentation and data access layers, oh yes :-) -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFDJ isn't exactly kicking bootay
my apologies.I thought we were talking about the merits of CFDJ Content in comparison to book content. ~Simon Simon Horwith CTO, Etrilogy Ltd. Member of Team Macromedia Macromedia Certified Instructor Certified Advanced ColdFusion MX Developer Certified Flash MX Developer CFDJList - List Administrator http://www.how2cf.com/ -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED] Sent: 09 January 2004 02:12 To: CF-Talk Subject: Re: CFDJ isn't exactly kicking bootay You might have missed an email or something. I wasn't comparing the content at all. I was disagreeing with you suggesting that someone should write for CFDJ. See my emails for why I believe writing CFML content for an online publication would be better. -Matt On Jan 8, 2004, at 6:41 PM, Simon Horwith wrote: we were comparing CFDJ to other publications... things in print... you know, paper.There was no discussion of a comparison between the content in CFDJ and online resources before your post, nor should there be one now.Hell, if you want to compare the content in CFDJ or any other CFML reference to the content in one outstanding resource, why would it be builder.com I'd say that builder.com doesn't even compare with macromedia.com's online documentation, devnet, etc.I think the point was that CFDJ was being compared with books and periodicals in print.Some people stated that they didn't think that it was worth it's price for a year's subscription compared to the price of some of the books that are out there.I'm not sure what that has to do with websites?There are a lot of great resources out there. I don't think CFDJ is the best CFML resource in the world, but I do personally think that what you get for the cost of receiving the magazine for a year as opposed to one or two of the books on the market is much more worth the money.That's just me... and that's what (I thought) we were debating.Anyway - this is begining to sound like a thread that belongs on the CF Community list. ~Simon Simon Horwith CTO, Etrilogy Ltd. Member of Team Macromedia Macromedia Certified Instructor Certified Advanced ColdFusion MX Developer Certified Flash MX Developer CFDJList - List Administrator http://www.how2cf.com/ -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED] Sent: 08 January 2004 23:29 To: CF-Talk Subject: Re: CFDJ isn't exactly kicking bootay Where did you get this fact that Builder is not a publication. Are you suggesting that Internet sites can't be publications? What is the difference between an online magazine and offline one? CFDJ makes content available online in addition to print. Does that make it less of a publication? I don't see any facts in your statement at all. What I do see is bias towards to the online publication industry. And it is an industry, that is growing, which the offline publishing industry certainly can't say. -Matt On Jan 8, 2004, at 5:30 PM, Simon Horwith wrote: first of all, Fusebox and Mach II are not CFML - they're frameworks that are written in CFML.In the interest of conserving bandwidth, ignore that I said that - I don't feel like getting into (nor will I) a discussion about whether or not a forum that talks primaily about FB and MACH II is a CFML forum or not.What I welcome dialog about is the fact that builder.com is not a publication. ~Simon Simon Horwith CTO, Etrilogy Ltd. Member of Team Macromedia Macromedia Certified Instructor Certified Advanced ColdFusion MX Developer Certified Flash MX Developer CFDJList - List Administrator http://www.how2cf.com/ -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED] Sent: 08 January 2004 18:19 To: CF-Talk Subject: Re: CFDJ isn't exactly kicking bootay Got any examples? :O) Of publications? Builder.com will pay for content and they have published quite a bit of CFML related content. In fact, I have even seen articles related to Fusebox and Mach-II. -Matt [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFDJ isn't exactly kicking bootay
I wouldn't consider builder.com more reputable... in fact most, not all, websites are less reputable in my opnion.Anyone can create a site, where as a publication in print requires more organization and support.I don't know what their subscription numbers are, so I can't comment on that.I think this thread should be moved to the Community list now. ~Simon Simon Horwith CTO, Etrilogy Ltd. Member of Team Macromedia Macromedia Certified Instructor Certified Advanced ColdFusion MX Developer Certified Flash MX Developer CFDJList - List Administrator http://www.how2cf.com/ -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED] Sent: 09 January 2004 02:15 To: CF-Talk Subject: Re: CFDJ isn't exactly kicking bootay I posted a link - why don't you write an article?Personally, I'd love to see one from you. When Sys-con starts compensating authors for content and is able to actually find a significant number of real subscribers instead of lying about their readership just to support ad sales then I might be interested. In the mean time, I will continue to write for reputable publishers. -Matt [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFDJ isn't exactly kicking bootay
On Friday 09 Jan 2004 10:17 am, Simon Horwith wrote: websites are less reputable in my opnion.Anyone can create a site, where But only some web sites will attract the 'names' in the community - either as writers, reviewers or just plain members. Those will be the reputable ones. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Map with Co-ordinates
ESRI http://www.esri.com Runs a commercial web-service (pay per use) that you can use for this. http://www.esri.com/software/arcwebservices/index.html - Hugo AhleniusE-Mail: [EMAIL PROTECTED] Project Officer Phone:+46 8 230460 UNEP GRID-ArendalFax:+46 8 230441 Stockholm OfficeMobile:+46 733 467111 WWW: http://www.grida.no - | -Original Message- | From: Mickael [mailto:[EMAIL PROTECTED] | Sent: Thursday, January 08, 2004 16:52 | To: CF-Talk | Subject: Map with Co-ordinates | | Hello All, | | I am hoping someone on the list has experience, (preferably a | low cost experience) with a request from my client.They | have a real estate business and would like to display their | listings on a map with a Dot near the intersection of the | listing.What they are doing today is taking a map of the | city and adding a layer with the dots.Is there a service | that I could use?I ideally would like the entries to come | out of a database instead of manually being plotted with | every listing. | | Thanks in advance for any suggestions. | | Mickael | | | [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Creating a Word.Application COM object needs a new instance o f WI NWORD.EXE?
you havnt mentioned which version of CF you are using...If you are using 6.1 then there is a new function ReleaseObject() that may be of use to you. HTH -Original Message- From: Shawn Grover [mailto:[EMAIL PROTECTED] Sent: Friday, January 9, 2004 01:15 To: CF-Talk Subject: RE: Creating a Word.Application COM object needs a new instance o f WI NWORD.EXE? Well, the server has been restarted, and the Quit command does indeed clean up the instance.However, if I run into any errors at all before the Quit command (and I'm expecting a few while I'm developing the page), I run into the same situation again - the instance of word is not cleaned up, I cannot remove it, and a new instance is created when the page is loaded again. I'm sure someone has created word documents on the fly using the office automation tools before (server-side that is), so can someone point me to a resource that would help me through this process?Thanks. Shawn -Original Message- From: Philip Arnold [mailto:[EMAIL PROTECTED] Sent: Thursday, January 08, 2004 4:22 PM To: CF-Talk Subject: RE: Creating a Word.Application COM object needs a new instance of WI NWORD.EXE? I'm using the following code: CFTRY !--- If it exists, connect to it --- brTrying to connect to Word Object CFOBJECT ACTION=""> CLASS=Word.Application NAME=oWord TYPE=COM CFCATCH !--- The object doesn't exist, so create it --- brWord Object not found, trying to create one CFOBJECT ACTION=""> CLASS=Word.Application NAME=oWord TYPE=COM /CFCATCH /CFTRY I don't see the catch section running, so I'm apparently connecting to an existing instance of a Word Object. However, I am getting a new WINWORD.EXE process running whenever I run this code.The moment I have a second instance (or more), my processing begins to bog down badly. Is there any way to prevent this situation? Are you closing off the COM object once you've finished your work? If not, then you're leaving the connection active, which can sap resources badly _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Get URL
How can I get the current URL (from browser)? e.g. I type in http://abc.com/myTest/test.cfm I need to save this URL in a variable inside test.cfm... Thanks Shaz [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Get URL
Dump CGI to see what's available to use. cfdump var=#CGI# / Ade :O) -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: 09 January 2004 12:15 To: CF-Talk Subject: Get URL How can I get the current URL (from browser)? e.g. I type in http://abc.com/myTest/test.cfm http://abc.com/myTest/test.cfmI need to save this URL in a variable inside test.cfm... Thanks Shaz _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Get URL
Try cfdump var=#cgi# The variables you want is in there somewhere. -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: 09 January 2004 12:15 To: CF-Talk Subject: Get URL How can I get the current URL (from browser)? e.g. I type in http://abc.com/myTest/test.cfm I need to save this URL in a variable inside test.cfm... Thanks Shaz _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Get URL
theres a nifty little UDF on cflib called GetCurrentURL() which should do the job HTH -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: Friday, January 9, 2004 12:15 To: CF-Talk Subject: Get URL How can I get the current URL (from browser)? e.g. I type in http://abc.com/myTest/test.cfm I need to save this URL in a variable inside test.cfm... Thanks Shaz _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Selecting TOP N
I can't seem to get SELECT TOP 10 to work when the query below has a DISTINCT clause in it... Can anyone shed some light into my confusion. SELECT DISTINCT(T.opportunityId), O.title, O.createDate, U.firstName, U.lastName, U.emailAddress FROM tbl_ta T INNER JOIN tbl_opportunity O ON (T.opportunityId = O.opportunityId) INNER JOIN tbl_user U ON (O.createUserId = U.userId) WHERE EXISTS ( SELECT O.title FROM tbl_opportunity O ) ORDER BY O.title ASC Thanks! Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Selecting TOP N
Which way round are you putting it in? This works: SELECT DISTINCT TOP 10 fields -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 8:00 AM To: CF-Talk Subject: Selecting TOP N I can't seem to get SELECT TOP 10 to work when the query below has a DISTINCT clause in it... Can anyone shed some light into my confusion. SELECT DISTINCT(T.opportunityId), O.title, O.createDate, U.firstName, U.lastName, U.emailAddress FROM tbl_ta T INNER JOIN tbl_opportunity O ON (T.opportunityId = O.opportunityId) INNER JOIN tbl_user U ON (O.createUserId = U.userId) WHERE EXISTS ( SELECT O.title FROM tbl_opportunity O ) ORDER BY O.title ASC Thanks! Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Selecting TOP N
Thanks! I just had it backwards Mike -Original Message- From: Philip Arnold [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 8:10 AM To: CF-Talk Subject: RE: Selecting TOP N Which way round are you putting it in? This works: SELECT DISTINCT TOP 10 fields -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 8:00 AM To: CF-Talk Subject: Selecting TOP N I can't seem to get SELECT TOP 10 to work when the query below has a DISTINCT clause in it... Can anyone shed some light into my confusion. SELECT DISTINCT(T.opportunityId), O.title, O.createDate, U.firstName, U.lastName, U.emailAddress FROM tbl_ta T INNER JOIN tbl_opportunity O ON (T.opportunityId = O.opportunityId) INNER JOIN tbl_user U ON (O.createUserId = U.userId) WHERE EXISTS ( SELECT O.title FROM tbl_opportunity O ) ORDER BY O.title ASC Thanks! Mike _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Selecting TOP N
If MySQL SELECT yourfieds FROM yourtable LIMIT 10 Cheers - Original Message - From: Philip Arnold [EMAIL PROTECTED] Date: Fri, 9 Jan 2004 08:09:43 -0500 To: CF-Talk [EMAIL PROTECTED] Subject: RE: Selecting TOP N Which way round are you putting it in? This works: SELECT DISTINCT TOP 10 fields -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 8:00 AM To: CF-Talk Subject: Selecting TOP N I can't seem to get SELECT TOP 10 to work when the query below has a DISTINCT clause in it... Can anyone shed some light into my confusion. SELECT DISTINCT(T.opportunityId), O.title, O.createDate, U.firstName, U.lastName, U.emailAddress FROM tbl_ta T INNER JOIN tbl_opportunity O ON (T.opportunityId = O.opportunityId) INNER JOIN tbl_user U ON (O.createUserId = U.userId) WHERE EXISTS ( SELECT O.title FROM tbl_opportunity O ) ORDER BY O.title ASC Thanks! Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFLAP Record Limit?
I have had no problems with queries in excess of 10,000.Occasionally, the LDAP server is slow and can cause a time-out problem, so I increase the time-out to accommodate these times. Chris Stoner wrote: I am accessing our active directory via cfldap and it currently only returns 1000 records at a time.I cannot find anything about cfldap having a 1000 record limitation anywhere and my active directory admin is suggesting the limit is not on his side.Does anyone know if there is a 1000 record limit?(BTW before someone asks I am most definitely not using the maxrows attribute) Any help would be great, thanks! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:Generating PDFs in CF
After test this example IE show me the error: if (year 1000) --^ Blank spaces don't permitted. Maybe !DOCTYPE ITEXT SYSTEM http://www.lowagie.com/iText/itext.dtd There is a sweet Java-based open source project that generates PDF based on an XML input format.The project is called IText and can be found here: http://www.lowagie.com/iText/ If you install the PDF jars from this project into the CFMX classpath (itext.jar and itextIXML.jar) and then use the following custom tag, you can generate PDF documents. -pdf.cfm (custom tag)-- CFIF ThisTag.ExecutionMode is 'end' CFSETTING ENABLECFOUTPUTONLY=YES CFHEADER NAME=content-type VALUE=application/xml cfif not isDefined(attributes.fileName) cfset attributes.deleteOnEndTag=true CFELSE cfset attributes.deleteOnEndTag=false /CFIF CFPARAM NAME=attributes.filename DEFAULT=c:\temp\pdf_#createUUID()#.pdf CFSCRIPT document = createObject(java, com.lowagie.text.Document). init(); pdfFile = createObject(java, java.io.FileOutputStream); pdfFile.init(attributes.fileName); createObject(java, com.lowagie.text.pdf.PdfWriter). getInstance(document, pdfFile); stringReader = createObject(java, java.io.StringReader). init(thisTag.generatedContent); inputSource = createObject(java, org.xml.sax.InputSource). init(stringReader); saxHandler = createObject(java, com.lowagie.text.xml. SAXiTextHandler).init(document); parser = createObject(java, javax.xml.parsers.SAXParserFactory). newInstance().newSAXParser(); parser.parse(inputSource, saxHandler); pdfFile.close(); thisTag.generatedContent = itext; /cfscript CFCONTENT FILE=#attributes.fileName# TYPE=application/pdf cfif attributes.deleteOnEndTag CFFILE ACTION="" FILE=#attributes.filename# /CFIF /CFIF -Example page that outputs PDF-- cf_pdf?xml version=1.0 encoding=UTF-8 ? !DOCTYPE ITEXT SYSTEM http://www.lowagie.com/iText/itext.dtd itext creationdate=Wed Nov 20 13:28:18 CET 2002 producer=iTextXML by lowagie.com paragraph leading=18.0 font=unknown align=Default Please visit my anchor leading=18.0 font=Helvetica size=12.0 fontstyle=normal, underline red=0 green=0 blue=255 name=top reference=http://www.lowagie.com/iText/ chunk font=Helvetica size=12.0 fontstyle=normal, underline red=0 green=0 blue=255website (external reference)/chunk /anchor /paragraph paragraph leading=18.0 font=unknown align=Default These are some special characters: , , , and apos; /paragraph paragraph leading=18.0 font=unknown align=Default some books I really like: /paragraph /itext /cf_pdf [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT Automated FTP Account Creation
I'm trying to find a way to programmatically create FTP accounts in apache. Anyone have any experience with this? Greg [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Get URL
Try cfset lcFullURL = Trim(CGI.path_info) cfif CGI.query_string NEQ cfset lcFullURL = lcFullURL ? CGI.query_string /cfif This is the code I use in a my login page.Basically I do it so a user can bookmark any page on the site (i.e. www.euservices.com/myeu/somepage.cfm?parm=somevalue) and if they select their bookmark the system will try to go there, switch to my login page, log them in then continue to the page they requested. __ file:///E:/EUColor.gif Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail: mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] Rockville, MD 20850-1299 WWW: http://www.euservices.com/ http://www.euservices.com __ -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 7:15 AM To: CF-Talk Subject: Get URL How can I get the current URL (from browser)? e.g. I type in http://abc.com/myTest/test.cfm I need to save this URL in a variable inside test.cfm... Thanks Shaz _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
insert multiple drop down list selects into access
Is it possible to insert into one access database number field, a comma delimited list of numbers, received from a form template thusly (is not working now ... only can one number to show in the database when multiples are selected on the form drop down): FORM CODE: select name=cat_no multiple cfoutput query=client_catoption value=#cat_no##work_cat#/cfoutput /select TEMPLATE WHERE DATABASE INSERT IS HAPPENING: cfquery datasource=todo dbtype=odbc INSERT into clients (category) VALUES (#cat_no#) /cfquery TIA Tim [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: insert multiple drop down list selects into access
I don't think access would handle a comma delimited list as a number. You'd have to change the field type to some sort of string, or loop over the form input and insert each one individually (depending on your database design). John Burns -Original Message- From: Tim Laureska [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 9:15 AM To: CF-Talk Subject: insert multiple drop down list selects into access Is it possible to insert into one access database number field, a comma delimited list of numbers, received from a form template thusly (is not working now ... only can one number to show in the database when multiples are selected on the form drop down): FORM CODE: select name=cat_no multiple cfoutput query=client_catoption value=#cat_no##work_cat#/cfoutput /select TEMPLATE WHERE DATABASE INSERT IS HAPPENING: cfquery datasource=todo dbtype=odbc INSERT into clients (category) VALUES (#cat_no#) /cfquery TIA Tim [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
java.lang.IllegalStateException: Session is invalid at jrun.servlet.session.JRunSession.checkSessionValidity(JRunSession.java:379)
I know very little about Java but can't this function have a try/catch block and if invalid just recreate the session? I'm getting Session is invalid null errors. The tagcontext is the application tag on line 5. Here is a copy of it. cfapplication name=thename clientmanagement=yes sessionmanagement=yes setclientcookies=yes setdomaincookies=no sessiontimeout=#createTimeSpan(0,0,60,0)# applicationtimeout=#createTimeSpan(0,0,60,0)# loginstorage=session Anyone know how to correct the problem? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: OT Automated FTP Account Creation
On Friday 09 Jan 2004 13:49 pm, Greg Luce wrote: FTP accounts in apache. Anyone have any experience with this? Apache is a web server, it doesn't know anything about FTP services. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CFContent Excel design woes
Hatton, Did you miss the post where someone said that Office 97 ignores stylesheets? -d - Original Message - From: C. Hatton Humphrey [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, January 08, 2004 8:08 AM Subject: RE: CFContent Excel design woes I still have not been able to figure out the source of the difference. Anyone have any ideas why Office 97 wouldn't read a stylesheet file right? Thanks! Hatton _ From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 4:28 PM To: CF-Talk Subject: SOT: CFContent Excel design woes Okay, this is only slightly off topic but I don't know where else to look for answers. I built a spreadsheet export that uses CFContent to create an Excel spreadsheet.I'm using CSS in that file to border some of the cells to create a cleaner output look to the sheet.We've been testing it on Excel 2000 and everything works perfectly.Today the client looks at it and asks for lines.Turns out they're running Excel 97, and a screenshot confirmed their comment, there are no lines (cell borders) in the file. Anyone hear anything like this before?Any suggestions to correct the issue? --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.555 / Virus Database: 347 - Release Date: 12/23/2003 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: insert multiple drop down list selects into access
You'll have to loop over that field and do multiple inserts.Something like: cfloop list=#FORM.cat_no# cfquery to insert /cfloop Pete Tim Laureska wrote: Is it possible to insert into one access database number field, a comma delimited list of numbers, received from a form template thusly (is not working now ... only can one number to show in the database when multiples are selected on the form drop down): FORM CODE: select name=cat_no multiple cfoutput query=client_catoption value=#cat_no##work_cat#/cfoutput /select TEMPLATE WHERE DATABASE INSERT IS HAPPENING: cfquery datasource=todo dbtype=odbc INSERT into clients (category) VALUES (#cat_no#) /cfquery TIA Tim [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: insert multiple drop down list selects into access
Looks like you want a one-to many relationship. Create a second table for that (with a FK to the existing table). Then loop over the list and insert in the second table within the loop (using the PK from the record in the first table as FK in the second table) -Oorspronkelijk bericht- Van: Tim Laureska [mailto:[EMAIL PROTECTED] Verzonden: vr 9/01/2004 15:15 Aan: CF-Talk CC: Onderwerp: insert multiple drop down list selects into access Is it possible to insert into one access database number field, a comma delimited list of numbers, received from a form template thusly (is not working now ... only can one number to show in the database when multiples are selected on the form drop down): FORM CODE: select name=cat_no multiple cfoutput query=client_catoption value=#cat_no##work_cat#/cfoutput /select TEMPLATE WHERE DATABASE INSERT IS HAPPENING: cfquery datasource=todo dbtype=odbc INSERT into clients (category) VALUES (#cat_no#) /cfquery TIA Tim _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Images - store in DB or filesystem?
What's the in/out for image storage? Bynary in BLOB database fields or file system or path in text fields? - Original Message - From: Pascal Peters [EMAIL PROTECTED] Date: Fri, 9 Jan 2004 15:40:16 +0100 To: CF-Talk [EMAIL PROTECTED] Subject: RE: insert multiple drop down list selects into access Looks like you want a one-to many relationship. Create a second table for that (with a FK to the existing table). Then loop over the list and insert in the second table within the loop (using the PK from the record in the first table as FK in the second table) -Oorspronkelijk bericht- Van: Tim Laureska [mailto:[EMAIL PROTECTED] Verzonden: vr 9/01/2004 15:15 Aan: CF-Talk CC: Onderwerp: insert multiple drop down list selects into access Is it possible to insert into one access database number field, a comma delimited list of numbers, received from a form template thusly (is not working now ... only can one number to show in the database when multiples are selected on the form drop down): FORM CODE: select name=cat_no multiple cfoutput query=client_catoption value=#cat_no##work_cat#/cfoutput /select TEMPLATE WHERE DATABASE INSERT IS HAPPENING: cfquery datasource=todo dbtype=odbc INSERT into clients (category) VALUES (#cat_no#) /cfquery TIA Tim _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Images - store in DB or filesystem?
Change the datatype from number to text. From: Spectrum WebDesign [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Images - store in DB or filesystem? Date: Fri, 09 Jan 2004 12:15:21 -0300 What's the in/out for image storage? Bynary in BLOB database fields or file system or path in text fields? - Original Message - From: Pascal Peters [EMAIL PROTECTED] Date: Fri, 9 Jan 2004 15:40:16 +0100 To: CF-Talk [EMAIL PROTECTED] Subject: RE: insert multiple drop down list selects into access Looks like you want a one-to many relationship. Create a second table for that (with a FK to the existing table). Then loop over the list and insert in the second table within the loop (using the PK from the record in the first table as FK in the second table) -Oorspronkelijk bericht- Van: Tim Laureska [mailto:[EMAIL PROTECTED] Verzonden: vr 9/01/2004 15:15 Aan: CF-Talk CC: Onderwerp: insert multiple drop down list selects into access Is it possible to insert into one access database number field, a comma delimited list of numbers, received from a form template thusly (is not working now ... only can one number to show in the database when multiples are selected on the form drop down): FORM CODE: select name=cat_no multiple cfoutput query=client_catoption value=#cat_no##work_cat#/cfoutput /select TEMPLATE WHERE DATABASE INSERT IS HAPPENING: cfquery datasource=todo dbtype=odbc INSERT into clients (category) VALUES (#cat_no#) /cfquery TIA Tim _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Images - store in DB or filesystem?
I've always heard path in text fields.From what I understand, storing as BLOBs will bloat the db, and it's rather slow. - Original Message - From: Spectrum WebDesign To: CF-Talk Sent: Friday, January 09, 2004 8:15 AM Subject: Images - store in DB or filesystem? What's the in/out for image storage? Bynary in BLOB database fields or file system or path in text fields? - Original Message - From: Pascal Peters [EMAIL PROTECTED] Date: Fri, 9 Jan 2004 15:40:16 +0100 To: CF-Talk [EMAIL PROTECTED] Subject: RE: insert multiple drop down list selects into access Looks like you want a one-to many relationship. Create a second table for that (with a FK to the existing table). Then loop over the list and insert in the second table within the loop (using the PK from the record in the first table as FK in the second table) -Oorspronkelijk bericht- Van: Tim Laureska [mailto:[EMAIL PROTECTED] Verzonden: vr 9/01/2004 15:15 Aan: CF-Talk CC: Onderwerp: insert multiple drop down list selects into access Is it possible to insert into one access database number field, a comma delimited list of numbers, received from a form template thusly (is not working now ... only can one number to show in the database when multiples are selected on the form drop down): FORM CODE: select name=cat_no multiple cfoutput query=client_catoption value=#cat_no##work_cat#/cfoutput /select TEMPLATE WHERE DATABASE INSERT IS HAPPENING: cfquery datasource=todo dbtype=odbc INSERT into clients (category) VALUES (#cat_no#) /cfquery TIA Tim _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: iText (was Re: CFDJ isn't exactly kicking bootay)
Thanks Matt...I was starting to think that might be the problem. BTWwhat did you mean by this line??: Be aware that there are only solutions besides iText for PDF generation. Did you mean other solutions? Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Matt Liotta To: CF-Talk Sent: Thursday, January 08, 2004 6:17 PM Subject: iText (was Re: CFDJ isn't exactly kicking bootay) Why don't you immensely bright opinionated people help us out.I've got a hell of a problem with trying to get the iText library working on Linux with CFMX Standardplease see Re: iText.jar/CFMX 6.1 Std/Linuxany insight would be greatly appreciated...and hey...mabye you could all write an article about it when you're done ;-) The errors you are getting can only come from malformed class files. I suggest you retry your download and/or get support for the author(s). Be aware that there are only solutions besides iText for PDF generation. Additionally, there are resources --such as myself-- that are available on a contract basis to take care of these sorts of things for you. -Matt [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Images - store in DB or filesystem?
I can assure you that storing images in BLOB does not bloat a database. They are designed for this very thing. Though I will admit that Oracle is far better than SQL Server at doing it. I have never really dealt with mySQL and it's been years since I used Informix so I can't tell you much on those products. We do this for our fax apps. We store all types of data in Oracle BLOBS and it is actually faster than file writes. We use a JSP page to do the pulls and puts. In fact we even integrated it into our PeopleSoft product so that our remote locations can now just fax in new hire documents, the faxes go directly to the database and are available for viewing through the Job panel in PS. Stephen E. Schuster PeopleSoft Administrator 2000 Ashland Drive Ashland, KY 41101 Office Phone 606.920.7447 Cell Phone 606.831.4590 _ From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 10:42 AM To: CF-Talk Subject: Re: Images - store in DB or filesystem? I've always heard path in text fields.From what I understand, storing as BLOBs will bloat the db, and it's rather slow. - Original Message - From: Spectrum WebDesign To: CF-Talk Sent: Friday, January 09, 2004 8:15 AM Subject: Images - store in DB or filesystem? What's the in/out for image storage? Bynary in BLOB database fields or file system or path in text fields? - Original Message - From: Pascal Peters [EMAIL PROTECTED] Date: Fri, 9 Jan 2004 15:40:16 +0100 To: CF-Talk [EMAIL PROTECTED] Subject: RE: insert multiple drop down list selects into access Looks like you want a one-to many relationship. Create a second table for that (with a FK to the existing table). Then loop over the list and insert in the second table within the loop (using the PK from the record in the first table as FK in the second table) -Oorspronkelijk bericht- Van: Tim Laureska [mailto:[EMAIL PROTECTED] Verzonden: vr 9/01/2004 15:15 Aan: CF-Talk CC: Onderwerp: insert multiple drop down list selects into access Is it possible to insert into one access database number field, a comma delimited list of numbers, received from a form template thusly (is not working now ... only can one number to show in the database when multiples are selected on the form drop down): FORM CODE: select name=cat_no multiple cfoutput query=client_catoption value=#cat_no##work_cat#/cfoutput /select TEMPLATE WHERE DATABASE INSERT IS HAPPENING: cfquery datasource=todo dbtype=odbc INSERT into clients (category) VALUES (#cat_no#) /cfquery TIA Tim _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: iText (was Re: CFDJ isn't exactly kicking bootay)
Another good point.The Secure FTP app was set to auto, but I'll try again with binary forced Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Matt Liotta To: CF-Talk Sent: Thursday, January 08, 2004 6:23 PM Subject: Re: iText (was Re: CFDJ isn't exactly kicking bootay) Oh yeah, possibly you were uploading the JAR/class files via FTP and didn't transfer them as binary if they work on Windows and not on Linux. Of course, if you are using FTP; stop right now and move over to SCP. You life will be easier and your machines will be more secure. -Matt On Jan 8, 2004, at 9:17 PM, Matt Liotta wrote: Why don't you immensely bright opinionated people help us out.I've got a hell of a problem with trying to get the iText library working on Linux with CFMX Standardplease see Re: iText.jar/CFMX 6.1 Std/Linuxany insight would be greatly appreciated...and hey...mabye you could all write an article about it when you're done ;-) The errors you are getting can only come from malformed class files. I suggest you retry your download and/or get support for the author(s). Be aware that there are only solutions besides iText for PDF generation. Additionally, there are resources --such as myself-- that are available on a contract basis to take care of these sorts of things for you. -Matt [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: java.lang.IllegalStateException: Session is invalid at jrun.servlet.session.JRunSession.checkSessionValidity(JRunSession.java:379)
You can put a try/catch around your cfapplication tag. There's a good chance it will pick up these error conditions, then send yourself an html email with cfdumps of #session#, #variables# and #getpagecontext().getcfscopes()# to find out what's going on. -nathan strutz -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 7:21 AM To: CF-Talk Subject: java.lang.IllegalStateException: Session is invalid at jrun.servlet.session.JRunSession.checkSessionValidity(JRunSession.java:379) I know very little about Java but can't this function have a try/catch block and if invalid just recreate the session? I'm getting Session is invalid null errors. The tagcontext is the application tag on line 5. Here is a copy of it. cfapplication name=thename clientmanagement=yes sessionmanagement=yes setclientcookies=yes setdomaincookies=no sessiontimeout=#createTimeSpan(0,0,60,0)# applicationtimeout=#createTimeSpan(0,0,60,0)# loginstorage=session Anyone know how to correct the problem? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: OT Automated FTP Account Creation
OK, thanks. I'm not a sys-admin. I do know that IIS is a webserver and it know's something about FTP Services. I guess by your reply Apache is different? Greg -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 9:22 AM To: CF-Talk Subject: Re: OT Automated FTP Account Creation On Friday 09 Jan 2004 13:49 pm, Greg Luce wrote: FTP accounts in apache. Anyone have any experience with this? Apache is a web server, it doesn't know anything about FTP services. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: iText (was Re: CFDJ isn't exactly kicking bootay)
Did you mean other solutions? I did mean other, sorry for the typo. -Matt [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
single IP issue
Hey All, I hadatrial copy of CFMX Enterprise installed...it expired and reverted to the Developer versionthen I registered it as Standard, but it's stuck only allowing 1 IP!! I know I've seen this one discussed here beforeany thoughts? BTW this is on Linux with Apache...latest versions TIA Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Images - store in DB or filesystem?
Spectrum WebDesign wrote: What's the in/out for image storage? Bynary in BLOB database fields or file system or path in text fields? Depends on usage pattern. What do you intend to do with your images? Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: OT Automated FTP Account Creation
OK, thanks. I'm not a sys-admin. I do know that IIS is a webserver and it know's something about FTP Services. I guess by your reply Apache is different? IIS is quite a bit more than a web server. It consists of web, FTP and mail servers, depending on what you choose to install. Apache, on the other hand, is just a web server. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: java.lang.IllegalStateException: Session is invalid at jrun.servlet.session.JRunSession.checkSessionValidity(JRunSession.java:379)
I haven't added the try/catch around the cfapplication tag. But my error reporting has all of this information already. All I know is the the checkSessionValidity() should have a try/catch around it if possible. Everything else is fine. There is no explanation in the scopes about why. Just that the IllegalStateException exception was returned as far as I can tell. -Original Message- From: Nathan Strutz [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 10:49 AM To: CF-Talk Subject: RE: java.lang.IllegalStateException: Session is invalid at jrun.servlet.session.JRunSession.checkSessionValidity(JRunSession.java:3 79) You can put a try/catch around your cfapplication tag. There's a good chance it will pick up these error conditions, then send yourself an html email with cfdumps of #session#, #variables# and #getpagecontext().getcfscopes()# to find out what's going on. -nathan strutz [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: OT Automated FTP Account Creation
On Friday 09 Jan 2004 15:49 pm, Greg Luce wrote: OK, thanks. I'm not a sys-admin. I do know that IIS is a webserver and it know's something about FTP Services. | don't think it does, though on Windows they may share a control panel or two. I guess by your reply Apache is different? It's a web server. If you want to add or remove FTP accounts, you'll have to figure out how to automate (cfexecute, COM object ... ?) whatever your FTP server users to create users. If you can be specifc about what O/S all this is for, and the make of your FTP server / Apache version, someone may be able to help more :-) -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: single IP issue
On Friday 09 Jan 2004 15:49 pm, Bryan Stevenson wrote: I know I've seen this one discussed here beforeany thoughts? Run Squid as a front-end proxy ? Sorry, I'm in a not-being-very-helpful-in-fact-slightly-silly mood 'cause it's nearly the weekend ;-) -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Images - store in DB or filesystem?
I can assure you that storing images in BLOB does not bloat a database. They are designed for this very thing. Though I will admit that Oracle is far better than SQL Server at doing it. I have never really dealt with mySQL and it's been years since I used Informix so I can't tell you much on those products. Bloat may not be the best way to term it. However, storing BLOBs and CLOBs in a relational database leads to spatial issues since the database has to pull data from multiple parts of the disk when returning each row. Generally, the database keeps data in a table all in the same part of a disk such that pulling it is efficient. Thus, as more and more of these objects are added to the database things start to slow down. Depending on the application the slow down may not be even noticed; it all depends. Relational databases were never designed to store these types of objects, they only put them in because that is what customers want and it was a good way to fight back against the OO databases. The truth is that relational databases have become the silver bullet for long term persistence even if they aren't the most appropriate solution. -Matt [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: iText (was Re: CFDJ isn't exactly kicking bootay)
Another good point. The Secure FTP app was set to auto, but I'll try again with binary forced Again, I would check out SCP as it is much nicer for transferring files and more secure too. -Matt [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Images - store in DB or filesystem?
Web sites but i'm looking for up-to-date technology... If stored images in BLOB fields is very slow why Oracle/SQL Server/Informix/MySQL companies agrees with that technology?? - Original Message - From: Jochem van Dieten [EMAIL PROTECTED] Date: Fri, 09 Jan 2004 16:53:55 +0100 To: CF-Talk [EMAIL PROTECTED] Subject: Re: Images - store in DB or filesystem? Spectrum WebDesign wrote: What's the in/out for image storage? Bynary in BLOB database fields or file system or path in text fields? Depends on usage pattern. What do you intend to do with your images? Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Images - store in DB or filesystem?
Hi Steven: I'll have to defer to your experience here, as my answer was based only on a response I got from an instructor when asking him this same question...so I've always done it the text datatype/file path method. Maybe 'bloat' was too strong of a word?Maybe he just meant that storing the images as files would take up -less- space than storing them as BLOBs? Charlie - Original Message - From: Schuster, Steven To: CF-Talk Sent: Friday, January 09, 2004 8:47 AM Subject: RE: Images - store in DB or filesystem? I can assure you that storing images in BLOB does not bloat a database. They are designed for this very thing. Though I will admit that Oracle is far better than SQL Server at doing it. I have never really dealt with mySQL and it's been years since I used Informix so I can't tell you much on those products. We do this for our fax apps. We store all types of data in Oracle BLOBS and it is actually faster than file writes. We use a JSP page to do the pulls and puts. In fact we even integrated it into our PeopleSoft product so that our remote locations can now just fax in new hire documents, the faxes go directly to the database and are available for viewing through the Job panel in PS. Stephen E. Schuster PeopleSoft Administrator 2000 Ashland Drive Ashland, KY 41101 Office Phone 606.920.7447 Cell Phone 606.831.4590 _ From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 10:42 AM To: CF-Talk Subject: Re: Images - store in DB or filesystem? I've always heard path in text fields.From what I understand, storing as BLOBs will bloat the db, and it's rather slow. - Original Message - From: Spectrum WebDesign To: CF-Talk Sent: Friday, January 09, 2004 8:15 AM Subject: Images - store in DB or filesystem? What's the in/out for image storage? Bynary in BLOB database fields or file system or path in text fields? - Original Message - From: Pascal Peters [EMAIL PROTECTED] Date: Fri, 9 Jan 2004 15:40:16 +0100 To: CF-Talk [EMAIL PROTECTED] Subject: RE: insert multiple drop down list selects into access Looks like you want a one-to many relationship. Create a second table for that (with a FK to the existing table). Then loop over the list and insert in the second table within the loop (using the PK from the record in the first table as FK in the second table) -Oorspronkelijk bericht- Van: Tim Laureska [mailto:[EMAIL PROTECTED] Verzonden: vr 9/01/2004 15:15 Aan: CF-Talk CC: Onderwerp: insert multiple drop down list selects into access Is it possible to insert into one access database number field, a comma delimited list of numbers, received from a form template thusly (is not working now ... only can one number to show in the database when multiples are selected on the form drop down): FORM CODE: select name=cat_no multiple cfoutput query=client_catoption value=#cat_no##work_cat#/cfoutput /select TEMPLATE WHERE DATABASE INSERT IS HAPPENING: cfquery datasource=todo dbtype=odbc INSERT into clients (category) VALUES (#cat_no#) /cfquery TIA Tim _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: single IP issue
I had a trial copy of CFMX Enterprise installed...it expired and reverted to the Developer versionthen I registered it as Standard, but it's stuck only allowing 1 IP!! I know I've seen this one discussed here beforeany thoughts? BTW this is on Linux with Apache...latest versions I think you have to remove the entry with the IP address from the file license.properties, which should be in your CFusionMX\lib directory. If that doesn't do it, you should Google for license.properties to find the exact fix. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: iText (was Re: CFDJ isn't exactly kicking bootay)
Yeah I have Putty and use it for root level access (nice and secure)still learning my Linux commands...but scp is a command right?secure copy? Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Matt Liotta To: CF-Talk Sent: Friday, January 09, 2004 8:01 AM Subject: Re: iText (was Re: CFDJ isn't exactly kicking bootay) Another good point.The Secure FTP app was set to auto, but I'll try again with binary forced Again, I would check out SCP as it is much nicer for transferring files and more secure too. -Matt [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: java.lang.IllegalStateException: Session is invalid at jrun.servlet.session.JRunSession.checkSessionValidity(JRunSession.java:379)
Bryan, On 1/9/2004 at 10:53, you wrote: BFH There is no explanation in the scopes about BFH why. Just that the IllegalStateException exception was returned as far BFH as I can tell. I was getting a similar error (session is invalid) on an MX6.1/Linux server. The only thing that made it go away was disabling Use J2EE session variables in CF Administrator. I have no idea if that's the actual cause or just a coincidence, but I haven't seen the error since. ~ Ubqtous ~ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: iText (was Re: CFDJ isn't exactly kicking bootay)
ooo...hey...if you can fire me the command to grab an entire local dir and scp it up I'd be one happy camper ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Matt Liotta To: CF-Talk Sent: Friday, January 09, 2004 8:01 AM Subject: Re: iText (was Re: CFDJ isn't exactly kicking bootay) Another good point.The Secure FTP app was set to auto, but I'll try again with binary forced Again, I would check out SCP as it is much nicer for transferring files and more secure too. -Matt [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Images - store in DB or filesystem?
I can assure you that storing images in BLOB does not bloat a database. They are designed for this very thing. I would agree with you about the choice of the word bloat, but relational databases are hardly designed for storing binary data - it's purely an afterthought at most. Relational databases are very good at storing and retrieving character strings, and SQL is appropriate for searching character strings. Neither is especially adept for working with binary data. In most cases, I've found little or no benefit in storing binary data in a database instead of just storing it on the filesystem, and in some cases, I've found that filesystem storage performs a lot better and is easier to implement. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: java.lang.IllegalStateException: Session is invalid at jrun.servlet.session.JRunSession.checkSessionValidity(JRunSession.java:379)
You know it may be. I do have that checked. I'll uncheck it and see if I get the errors again. When they popup mysteriously. Thanks -Original Message- From: Ubqtous [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 11:06 AM To: CF-Talk Subject: Re: java.lang.IllegalStateException: Session is invalid at jrun.servlet.session.JRunSession.checkSessionValidity(JRunSession.java:3 79) I was getting a similar error (session is invalid) on an MX6.1/Linux server. The only thing that made it go away was disabling Use J2EE session variables in CF Administrator. I have no idea if that's the actual cause or just a coincidence, but I haven't seen the error since. ~ Ubqtous ~ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: iText (was Re: CFDJ isn't exactly kicking bootay)
SCP is secure copy or the cp command over SSH. Putty has a program named pscp or Putty SCP that will allow you to do SCP from the command-line on Windows. For example, transferring a file is as follows. prompt pscp somefile.txt [EMAIL PROTECTED]:/home/username/somefile.txt -Matt On Jan 9, 2004, at 11:03 AM, Bryan Stevenson wrote: Yeah I have Putty and use it for root level access (nice and secure)still learning my Linux commands...but scp is a command right? secure copy? Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Matt Liotta To: CF-Talk Sent: Friday, January 09, 2004 8:01 AM Subject: Re: iText (was Re: CFDJ isn't exactly kicking bootay) Another good point. The Secure FTP app was set to auto, but I'll try again with binary forced Again, I would check out SCP as it is much nicer for transferring files and more secure too. -Matt [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: iText (was Re: CFDJ isn't exactly kicking bootay)
prompt pscp -r somedir [EMAIL PROTECTED]:/home/username/somedir -Matt On Jan 9, 2004, at 11:04 AM, Bryan Stevenson wrote: ooo...hey...if you can fire me the command to grab an entire local dir and scp it up I'd be one happy camper ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Matt Liotta To: CF-Talk Sent: Friday, January 09, 2004 8:01 AM Subject: Re: iText (was Re: CFDJ isn't exactly kicking bootay) Another good point. The Secure FTP app was set to auto, but I'll try again with binary forced Again, I would check out SCP as it is much nicer for transferring files and more secure too. -Matt [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: iText (was Re: CFDJ isn't exactly kicking bootay)
Yeah I have Putty and use it for root level access (nice and secure)still learning my Linux commands...but scp is a command right? secure copy? scp usage: scp -v localfile.txt [EMAIL PROTECTED]:localfile.txt You will then be prompted for a password and it will copy the file out there for you with the name localfile.txt. (The -v option is for verbose so that you can see exactly what's going on. Not necessary, but sometimes useful.) If you're talking about directories, you should just be able to do scp -vr localdir [EMAIL PROTECTED]:localdir Note that the -r option makes it recursive such that sub-directories are copied out as well. Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: single IP issue
Thanks Dave...on it now ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Dave Watts To: CF-Talk Sent: Friday, January 09, 2004 8:11 AM Subject: RE: single IP issue I had a trial copy of CFMX Enterprise installed...it expired and reverted to the Developer versionthen I registered it as Standard, but it's stuck only allowing 1 IP!! I know I've seen this one discussed here beforeany thoughts? BTW this is on Linux with Apache...latest versions I think you have to remove the entry with the IP address from the file license.properties, which should be in your CFusionMX\lib directory. If that doesn't do it, you should Google for license.properties to find the exact fix. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFFTP - file transferred is 0 bytes?
I'm using CFFTP on CFMX to transfer a text file from one server to another. The file gets created on the remote machine but contains no data and is 0 bytes in length. Anything I can check out that might be causing this to happen? CFFTP action="" connection=#CONN1# stoponerror=no username=#FTPUSERNAME# password=#FTPPASSWORD# server=#FTPSERVERIP# CFFTP action="" stoponerror=no transfermode=binary connection=#CONN1# localfile=#FILEINLOCATION##TRIM(ListFiles.Name)# remotefile=#TRIM(ListFiles.Name)# timeout=60 CFFTP action="" connection=#CONN1# stoponerror=no Thanks, Dave HTC Disclaimer:The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited.If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer.Thank you. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Images - store in DB or filesystem?
Spectrum WebDesign wrote: Web sites That is not exactly what I would call a usage pattern. What *xactly* do you intent to do with the images? Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: OT Automated FTP Account Creation
Well, I'm not sure what version of Redhat exactly we're running. I know it's different from our dev server and production servers. I'm not able to find out right now what FTP server we're using. Perhaps we can just talk theoretically. Is it something CF can call with a COM object? Are there FTP servers that have this functionality built-in? -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 10:56 AM To: CF-Talk Subject: Re: OT Automated FTP Account Creation On Friday 09 Jan 2004 15:49 pm, Greg Luce wrote: OK, thanks. I'm not a sys-admin. I do know that IIS is a webserver and it know's something about FTP Services. | don't think it does, though on Windows they may share a control panel or two. I guess by your reply Apache is different? It's a web server. If you want to add or remove FTP accounts, you'll have to figure out how to automate (cfexecute, COM object ... ?) whatever your FTP server users to create users. If you can be specifc about what O/S all this is for, and the make of your FTP server / Apache version, someone may be able to help more :-) -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Images - store in DB or filesystem?
Jochem web page display... img src=""> - Original Message - From: Jochem van Dieten [EMAIL PROTECTED] Date: Fri, 09 Jan 2004 17:19:20 +0100 To: CF-Talk [EMAIL PROTECTED] Subject: Re: Images - store in DB or filesystem? Spectrum WebDesign wrote: Web sites That is not exactly what I would call a usage pattern. What *xactly* do you intent to do with the images? Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Images - store in DB or filesystem?
Spectrum WebDesign wrote: web page display... img src=""> How many images? How big are the images? How often will they be displayed? Will they be cached somewhere? How often will there be images inserted/updated? Do you intent to use the images in relational queries? Do you want to search your images? Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: OT Automated FTP Account Creation
It depends on the ftp server.Some FTP servers keep the users and permissions in text files.If that's the case, you can automate user creation by modifying that text file.There may be ways to add users other ways through calling functions of the FTP server software but you'd have to rely on the documentation on that ftp server for that. There is no set way of adding users.Everything goes back to which ftp server you're running. John Burns -Original Message- From: Greg Luce [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 11:31 AM To: CF-Talk Subject: RE: OT Automated FTP Account Creation Well, I'm not sure what version of Redhat exactly we're running. I know it's different from our dev server and production servers. I'm not able to find out right now what FTP server we're using. Perhaps we can just talk theoretically. Is it something CF can call with a COM object? Are there FTP servers that have this functionality built-in? -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 10:56 AM To: CF-Talk Subject: Re: OT Automated FTP Account Creation On Friday 09 Jan 2004 15:49 pm, Greg Luce wrote: OK, thanks. I'm not a sys-admin. I do know that IIS is a webserver and it know's something about FTP Services. | don't think it does, though on Windows they may share a control panel or two. I guess by your reply Apache is different? It's a web server. If you want to add or remove FTP accounts, you'll have to figure out how to automate (cfexecute, COM object ... ?) whatever your FTP server users to create users. If you can be specifc about what O/S all this is for, and the make of your FTP server / Apache version, someone may be able to help more :-) -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: OT Automated FTP Account Creation
Well, I'm not sure what version of Redhat exactly we're running. I know it's different from our dev server and production servers. I'm not able to find out right now what FTP server we're using. Perhaps we can just talk theoretically. Is it something CF can call with a COM object? Are there FTP servers that have this functionality built-in? You won't be able to call it with a COM interface, as that's a Windows thing. On the other hand, most things that you'd want to do in Unix can be automated one way or another. You can probably find out what FTP server you're using by connecting to it with a command-line FTP client. Most provide a banner explaining what they are. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: java.lang.IllegalStateException: Session is invalid at jrun.s ervlet.session.JRunSession.checkSessionValidity(JRunSession.java:379)
I was getting a similar error (session is invalid) on an MX6.1/Linux server. The only thing that made it go away was disabling Use J2EE session variables in CF Administrator. I have no idea if that's the actual cause or just a coincidence, but I haven't seen the error since. You should be able to make that error go away by limiting the duration of J2EE session variables within web.xml: http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=10threadid =669435#2598160 Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
TSQL problem
I know its coldfusion group but I wonder if someone can help me with this query. What the alternative of Evaluate() in TSQL? SELECT 09/01/2004 + 'CAST(..)' AS myDateTime FROM myTest [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: single IP issue
hmmm...the 2 license.properties files (JRun and CFMX) do not have an allowedIP setting. The issue acts like CFMX is allowing only our office IP to connect to this server (anybody outside our office cannot connectand the server is outside our office).The error the rest of the world gets is: Server Error The server encountered an internal error and was unable to complete your request. JRun closed connection. and yes...if I reboot the server and have someone outside the office connect first, they can connect and we in the office cannot Any thoughts? Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Dave Watts To: CF-Talk Sent: Friday, January 09, 2004 8:11 AM Subject: RE: single IP issue I had a trial copy of CFMX Enterprise installed...it expired and reverted to the Developer versionthen I registered it as Standard, but it's stuck only allowing 1 IP!! I know I've seen this one discussed here beforeany thoughts? BTW this is on Linux with Apache...latest versions I think you have to remove the entry with the IP address from the file license.properties, which should be in your CFusionMX\lib directory. If that doesn't do it, you should Google for license.properties to find the exact fix. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: TSQL problem
Why not use DateAdd()? What's in the . - that could make a big difference -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 11:45 AM To: CF-Talk Subject: TSQL problem I know its coldfusion group but I wonder if someone can help me with this query. What the alternative of Evaluate() in TSQL? SELECT 09/01/2004 + 'CAST(..)' AS myDateTime FROM myTest [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Login Roles
When using the CFlogin function of MX 6.x is there a way to get all the roles of a given user outside of the cflogin/cflogin block?I know you can use IsUserInRole() to get a Boolean of if a user is in a given role, but, especially when debugging, it would often be useful to see the all roles to which a given user has been assigned. Thank You -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA 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]
RE: verity search
The query returns 10 more than the cfsearch did. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Thursday, January 08, 2004 9:16 PM To: CF-Talk Subject: RE: verity search thanks Dave... I removed the extensions and double checked the query.. it does return correctly.Anything else? When you search the collection, does the RecordsSearched variable within your CFSEARCH recordset match the number of records from your original query? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: OT Automated FTP Account Creation
Thanks John. Hopefully it's the case of the text file. Sounds painless. -Original Message- From: Burns, John [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 11:36 AM To: CF-Talk Subject: RE: OT Automated FTP Account Creation It depends on the ftp server.Some FTP servers keep the users and permissions in text files.If that's the case, you can automate user creation by modifying that text file.There may be ways to add users other ways through calling functions of the FTP server software but you'd have to rely on the documentation on that ftp server for that. There is no set way of adding users.Everything goes back to which ftp server you're running. John Burns -Original Message- From: Greg Luce [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 11:31 AM To: CF-Talk Subject: RE: OT Automated FTP Account Creation Well, I'm not sure what version of Redhat exactly we're running. I know it's different from our dev server and production servers. I'm not able to find out right now what FTP server we're using. Perhaps we can just talk theoretically. Is it something CF can call with a COM object? Are there FTP servers that have this functionality built-in? -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 10:56 AM To: CF-Talk Subject: Re: OT Automated FTP Account Creation On Friday 09 Jan 2004 15:49 pm, Greg Luce wrote: OK, thanks. I'm not a sys-admin. I do know that IIS is a webserver and it know's something about FTP Services. | don't think it does, though on Windows they may share a control panel or two. I guess by your reply Apache is different? It's a web server. If you want to add or remove FTP accounts, you'll have to figure out how to automate (cfexecute, COM object ... ?) whatever your FTP server users to create users. If you can be specifc about what O/S all this is for, and the make of your FTP server / Apache version, someone may be able to help more :-) -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Login Roles
There is no way of doing this. However, if your roles come from a UDF or CFC, you can just call it again. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Creating a Word.Application COM object needs a new instance o f WI NWORD.EXE?
Unfortunately, my client hasn't updated his server yet, and likely won't for some time.So, we are stuck running CFMX 6.0. Further research indicates I have two choices left to me - either do the work client-side or remove the Office 2000 objects, and use the Office XP objects.Both cases leave a lot of unknowns, but at least I have a couple of options to explore.I just wish this task wasn't due today Thanks for the input. Shawn Grover -Original Message- From: Mike Townend [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 4:23 AM To: CF-Talk Subject: RE: Creating a Word.Application COM object needs a new instance o f WI NWORD.EXE? you havnt mentioned which version of CF you are using...If you are using 6.1 then there is a new function ReleaseObject() that may be of use to you. HTH -Original Message- From: Shawn Grover [mailto:[EMAIL PROTECTED] Sent: Friday, January 9, 2004 01:15 To: CF-Talk Subject: RE: Creating a Word.Application COM object needs a new instance o f WI NWORD.EXE? Well, the server has been restarted, and the Quit command does indeed clean up the instance.However, if I run into any errors at all before the Quit command (and I'm expecting a few while I'm developing the page), I run into the same situation again - the instance of word is not cleaned up, I cannot remove it, and a new instance is created when the page is loaded again. I'm sure someone has created word documents on the fly using the office automation tools before (server-side that is), so can someone point me to a resource that would help me through this process?Thanks. Shawn -Original Message- From: Philip Arnold [mailto:[EMAIL PROTECTED] Sent: Thursday, January 08, 2004 4:22 PM To: CF-Talk Subject: RE: Creating a Word.Application COM object needs a new instance of WI NWORD.EXE? I'm using the following code: CFTRY !--- If it exists, connect to it --- brTrying to connect to Word Object CFOBJECT ACTION=""> CLASS=Word.Application NAME=oWord TYPE=COM CFCATCH !--- The object doesn't exist, so create it --- brWord Object not found, trying to create one CFOBJECT ACTION=""> CLASS=Word.Application NAME=oWord TYPE=COM /CFCATCH /CFTRY I don't see the catch section running, so I'm apparently connecting to an existing instance of a Word Object. However, I am getting a new WINWORD.EXE process running whenever I run this code.The moment I have a second instance (or more), my processing begins to bog down badly. Is there any way to prevent this situation? Are you closing off the COM object once you've finished your work? If not, then you're leaving the connection active, which can sap resources badly _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: TSQL problem
Following is the query
SELECT
DateAdd(Day, CAST(LEFT(CAST(PanelLocalDT AS Decimal(10,5)),
CHARINDEX('.', CAST(PanelLocalDT AS Decimal(10,5)))-1) AS INT),
'1899-12-30')
+ ' '
+ 'CAST(((CaST(RIGHT(CONVERT(decimal(10,4),PanelLocalDT),
LEN(CONVERT(decimal(10,4),PanelLocalDT)) -
charindex(''.'',CONVERT(decimal(10,4),PanelLocalDT))) AS Float(8)) / 100
* 1440 / 100) / 60 ) AS int(4))
:
CAST(((CaST(RIGHT(CONVERT(decimal(10,4),((CaST(RIGHT(CONVERT(decimal(10,
4),PanelLocalDT), LEN(CONVERT(decimal(10,4),PanelLocalDT)) -
charindex(''.'',CONVERT(decimal(10,4),PanelLocalDT))) AS Float(8)) / 100
* 1440 / 100) / 60 )),
LEN(CONVERT(decimal(10,4),((CaST(RIGHT(CONVERT(decimal
(10,4),PanelLocalDT), LEN(CONVERT(decimal(10,4),PanelLocalDT)) -
charindex(''.'',CONVERT(decimal(10,4),PanelLocalDT))) AS Float(8)) / 100
* 1440 / 100) / 60 ))) -
charindex(''.'',CONVERT(decimal(10,4),((CaST(RIGHT(CONVERT(decimal(10,4)
,PanelLocalDT), LEN(CONVERT(decimal(10,4),PanelLocalDT)) -
charindex(''.'',CONVERT(decimal(10,4),PanelLocalDT))) AS
Float(8)) / 100 * 1440 / 100) / 60 AS Float(8)) / 100 * 60 / 100)
) AS Int(4))
: 00' myDate
>From dbo.AFxEvents
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: java.lang.IllegalStateException: Session is invalid at jrun.s ervlet.session.JRunSession.checkSessionValidity(JRunSession.java:379)
Thanks Dave! I wonder why they have the web.xml configuration for the timeout set to automatically discover the max timeout set in the administrator. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 11:51 AM To: CF-Talk Subject: RE: java.lang.IllegalStateException: Session is invalid at jrun.s ervlet.session.JRunSession.checkSessionValidity(JRunSession.java:379) You should be able to make that error go away by limiting the duration of J2EE session variables within web.xml: http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=10 http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=10thr eadid threadid =669435#2598160 Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CF_HTML2PDF3
I am using this tag to create pdfs. A user enters how many cards they want to print, it then goes to a page that outputs some user information and a graphic. My problem is is that sometimes the graphic appears and sometimes it doesn't. Very random. It seems to work if I completely close acrobat before I attempt to create another pdf. Has anyone experienced this before. Any advice? Here is my code: CF_HTML2PDF3 myHTMLDOC=D:\Program Files\HTMLDOC\htmldoc.exe myOPTIONS=--portrait --fontsize 11pt --bodyfont typeface Arial --top 0.20in --left .5in --right .5in --bottom 0.00in --size 8.5x11in --footer ... mySTATPATH=d:\users\tdlabs\tdlabs.com\beta\nta\pdf mySTATFILE=static.html myPDFPath=d:\users\tdlabs\tdlabs.com\beta\nta\pdf TABLE width=100% border=0 cfset newrow = true cfloop index=getcode from=1 to=#form.number# step=1 cfset firstcodeid = #variables.newcodeid# + #getcode# cfset codeid = NTA#variables.firstcodeid##cookie.ntauser#cfoutput#getcode#/cfoutput cfif #variables.newrow# IS truetrTD height=187 valign=bottom align=leftcfelse TD height=187 valign=bottom align=right/cfifTABLE width=330 height=182 border=0 cellpadding=1 cellspacing=0TRTD align=center valign=middleTABLE cellpadding=0 cellspacing=0 border=0TRTD valign=bottomcfoutputimg src=""> align=left valign=bottomhttp://www.tacticaldesignlabs.comBR cfoutput#form.name#/cfoutputBR Discount Code: cfoutput#variables.codeid#/cfoutputBR/TD /TR/TABLE/TD/TR/TABLE/TDcfif #getcode# MOD 2 EQ 0/trcfset variables.newrow = truecfelse cfset variables.newrow = false/cfif /cfloop /TABLE/TD/TR/TABLE/CF_HTML2PDF3 Also, I can't seem to align the cards. It does not print the cards evenly spaced like I have coded. The margins in the tag don't seem to hold true. Thanks, Kelly [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: java.lang.IllegalStateException: Session is invalid at jrun.s ervlet.session.JRunSession.checkSessionValidity(JRunSession.java:379)
Don't have. -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 12:03 PM To: CF-Talk Subject: RE: java.lang.IllegalStateException: Session is invalid at jrun.s ervlet.session.JRunSession.checkSessionValidity(JRunSession.java:379) Thanks Dave! I wonder why they have the web.xml configuration for the timeout set to automatically discover the max timeout set in the administrator. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: verity search
Is the value for the key attribute unique? Ade -Original Message- From: Tim Do [mailto:[EMAIL PROTECTED] Sent: 09 January 2004 16:47 To: CF-Talk Subject: RE: verity search The query returns 10 more than the cfsearch did. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Thursday, January 08, 2004 9:16 PM To: CF-Talk Subject: RE: verity search thanks Dave... I removed the extensions and double checked the query.. it does return correctly.Anything else? When you search the collection, does the RecordsSearched variable within your CFSEARCH recordset match the number of records from your original query? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://www.figleaf.com/http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: single IP issue
it's definately the single IP issue...confirmed it in the logsbut no allowedIP settng in the license.properties files.now the fun beginswhere oh where is the dang setting ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Bryan Stevenson To: CF-Talk Sent: Friday, January 09, 2004 8:44 AM Subject: Re: single IP issue hmmm...the 2 license.properties files (JRun and CFMX) do not have an allowedIP setting. The issue acts like CFMX is allowing only our office IP to connect to this server (anybody outside our office cannot connectand the server is outside our office).The error the rest of the world gets is: Server Error The server encountered an internal error and was unable to complete your request. JRun closed connection. and yes...if I reboot the server and have someone outside the office connect first, they can connect and we in the office cannot Any thoughts? Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Dave Watts To: CF-Talk Sent: Friday, January 09, 2004 8:11 AM Subject: RE: single IP issue I had a trial copy of CFMX Enterprise installed...it expired and reverted to the Developer versionthen I registered it as Standard, but it's stuck only allowing 1 IP!! I know I've seen this one discussed here beforeany thoughts? BTW this is on Linux with Apache...latest versions I think you have to remove the entry with the IP address from the file license.properties, which should be in your CFusionMX\lib directory. If that doesn't do it, you should Google for license.properties to find the exact fix. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Images - store in DB or filesystem?
cases, I've found little or no benefit in storing binary data in a database instead of just storing it on the filesystem, and in some cases, I've found that filesystem storage performs a lot better and is easier to implement. well the GIS industry builds uses huge monster thumping databases. the current data (spatial primitives) storage trends there are towards relational databases (you might actually say they are running screaming away from file system storage). in enterprise apps, give me the db method everytime (thanks but i've done my time in file system purgatory). just a for instance: http://www.esri.com/software/arcgis/arcinfo/arcsde/index.html [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: verity search
that was it!I changed the cfindex key to the primary key in the table .. purged and updated the verity.. works great!Thanks so much! -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 9:18 AM To: CF-Talk Subject: RE: verity search Is the value for the key attribute unique? Ade -Original Message- From: Tim Do [mailto:[EMAIL PROTECTED] Sent: 09 January 2004 16:47 To: CF-Talk Subject: RE: verity search The query returns 10 more than the cfsearch did. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Thursday, January 08, 2004 9:16 PM To: CF-Talk Subject: RE: verity search thanks Dave... I removed the extensions and double checked the query.. it does return correctly.Anything else? When you search the collection, does the RecordsSearched variable within your CFSEARCH recordset match the number of records from your original query? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://www.figleaf.com/http://www.figleaf.com/ http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Images - store in DB or filesystem?
Hmm, that's odd I thought that was what InterMedia from Oracle was all about? Of course they just scratched the surface in 8i but in 9i it's all about that. I can search binary data, both clob and blob. They can be stored within the database structure itself or in separate files associated with the db structure. They have little or nothing to do at all with relational modeling. We currently have functionality that allows us to store PDF in Oracle and search the BLOB for content. Now, of course, that won't work with images and more proprietary formats that are not conducive to text searching but it works perfect for us. We even ran comparisons against retrieval and write vs. write/read. So long as you stream output using JSPwe find that the DB is faster than the filesystem most always. Granted our Oracle environment runs on Digital UNIX so I haven't tried this on NT running UNIX. Also If you are on SQL server I am sure the differences may be somewhat less desirable as well. But that's just IMHO regardless. Stephen E. Schuster PeopleSoft Administrator 2000 Ashland Drive Ashland, KY 41101 Office Phone 606.920.7447 Cell Phone 606.831.4590 _ From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 11:15 AM To: CF-Talk Subject: RE: Images - store in DB or filesystem? I can assure you that storing images in BLOB does not bloat a database. They are designed for this very thing. I would agree with you about the choice of the word bloat, but relational databases are hardly designed for storing binary data - it's purely an afterthought at most. Relational databases are very good at storing and retrieving character strings, and SQL is appropriate for searching character strings. Neither is especially adept for working with binary data. In most cases, I've found little or no benefit in storing binary data in a database instead of just storing it on the filesystem, and in some cases, I've found that filesystem storage performs a lot better and is easier to implement. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: TSQL problem
Why is the second one in quotes?
You shouldn't need to do that as long as you convert things right
There's too much there for me to break out easily without seeing the
data, but if I'm right, you're trying to make a date/time calculated out
of a date/time field, right?
-Original Message-
From: Shahzad.Butt [mailto:[EMAIL PROTECTED]
Sent: Friday, January 09, 2004 12:04 PM
To: CF-Talk
Subject: RE: TSQL problem
Following is the query
SELECT
DateAdd(Day, CAST(LEFT(CAST(PanelLocalDT AS Decimal(10,5)),
CHARINDEX('.', CAST(PanelLocalDT AS Decimal(10,5)))-1) AS INT),
'1899-12-30')
+ ' '
+ 'CAST(((CaST(RIGHT(CONVERT(decimal(10,4),PanelLocalDT),
LEN(CONVERT(decimal(10,4),PanelLocalDT)) -
charindex(''.'',CONVERT(decimal(10,4),PanelLocalDT))) AS
Float(8)) / 100
* 1440 / 100) / 60 ) AS int(4))
:
CAST(((CaST(RIGHT(CONVERT(decimal(10,4),((CaST(RIGHT(CONVERT(d
ecimal(10,
4),PanelLocalDT), LEN(CONVERT(decimal(10,4),PanelLocalDT)) -
charindex(''.'',CONVERT(decimal(10,4),PanelLocalDT))) AS
Float(8)) / 100
* 1440 / 100) / 60 )),
LEN(CONVERT(decimal(10,4),((CaST(RIGHT(CONVERT(decimal
(10,4),PanelLocalDT),
LEN(CONVERT(decimal(10,4),PanelLocalDT)) -
charindex(''.'',CONVERT(decimal(10,4),PanelLocalDT))) AS
Float(8)) / 100
* 1440 / 100) / 60 ))) -
charindex(''.'',CONVERT(decimal(10,4),((CaST(RIGHT(CONVERT(dec
imal(10,4)
,PanelLocalDT), LEN(CONVERT(decimal(10,4),PanelLocalDT)) -
charindex(''.'',CONVERT(decimal(10,4),PanelLocalDT))) AS
Float(8)) / 100 * 1440 / 100) / 60 AS Float(8)) / 100 * 60 / 100)
) AS Int(4))
: 00' myDate
From dbo.AFxEvents
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: Images - store in DB or filesystem?
Well I'm not sure about taking up less size at all. Now given you will have to create an initial database but minus that it's just data. Regardless if you go this route the space differences would be minimal. If you want I can post the JSP code we use for retrieval? Stephen E. Schuster PeopleSoft Administrator 2000 Ashland Drive Ashland, KY 41101 Office Phone 606.920.7447 Cell Phone 606.831.4590 _ From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 11:04 AM To: CF-Talk Subject: Re: Images - store in DB or filesystem? Hi Steven: I'll have to defer to your experience here, as my answer was based only on a response I got from an instructor when asking him this same question...so I've always done it the text datatype/file path method. Maybe 'bloat' was too strong of a word?Maybe he just meant that storing the images as files would take up -less- space than storing them as BLOBs? Charlie - Original Message - From: Schuster, Steven To: CF-Talk Sent: Friday, January 09, 2004 8:47 AM Subject: RE: Images - store in DB or filesystem? I can assure you that storing images in BLOB does not bloat a database. They are designed for this very thing. Though I will admit that Oracle is far better than SQL Server at doing it. I have never really dealt with mySQL and it's been years since I used Informix so I can't tell you much on those products. We do this for our fax apps. We store all types of data in Oracle BLOBS and it is actually faster than file writes. We use a JSP page to do the pulls and puts. In fact we even integrated it into our PeopleSoft product so that our remote locations can now just fax in new hire documents, the faxes go directly to the database and are available for viewing through the Job panel in PS. Stephen E. Schuster PeopleSoft Administrator 2000 Ashland Drive Ashland, KY 41101 Office Phone 606.920.7447 Cell Phone 606.831.4590 _ From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 10:42 AM To: CF-Talk Subject: Re: Images - store in DB or filesystem? I've always heard path in text fields.From what I understand, storing as BLOBs will bloat the db, and it's rather slow. - Original Message - From: Spectrum WebDesign To: CF-Talk Sent: Friday, January 09, 2004 8:15 AM Subject: Images - store in DB or filesystem? What's the in/out for image storage? Bynary in BLOB database fields or file system or path in text fields? - Original Message - From: Pascal Peters [EMAIL PROTECTED] Date: Fri, 9 Jan 2004 15:40:16 +0100 To: CF-Talk [EMAIL PROTECTED] Subject: RE: insert multiple drop down list selects into access Looks like you want a one-to many relationship. Create a second table for that (with a FK to the existing table). Then loop over the list and insert in the second table within the loop (using the PK from the record in the first table as FK in the second table) -Oorspronkelijk bericht- Van: Tim Laureska [mailto:[EMAIL PROTECTED] Verzonden: vr 9/01/2004 15:15 Aan: CF-Talk CC: Onderwerp: insert multiple drop down list selects into access Is it possible to insert into one access database number field, a comma delimited list of numbers, received from a form template thusly (is not working now ... only can one number to show in the database when multiples are selected on the form drop down): FORM CODE: select name=cat_no multiple cfoutput query=client_catoption value=#cat_no##work_cat#/cfoutput /select TEMPLATE WHERE DATABASE INSERT IS HAPPENING: cfquery datasource=todo dbtype=odbc INSERT into clients (category) VALUES (#cat_no#) /cfquery TIA Tim _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: TSQL problem
I know its coldfusion group but I wonder if someone can help me with this query. What the alternative of Evaluate() in TSQL? SELECT 09/01/2004 + 'CAST(..)' AS myDateTime FROM myTest You can use sp_executesql, EXECUTE, or EXEC, depending on which version of SQL Server you're using. You should try to avoid this when possible, though, as it's usually inefficient. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Images - store in DB or filesystem?
For Inserts we just use the cf_blob type in MX 6.1 and do a direct insert
into the blob.
To retrieve we have this JSP page. This allows a direct stream read to the
browser and does not write the file to the system and then attempt to read
it. But we have code that does that as well if you need to look at it also.
This is a JSP page so you must be running MX for this to work (or a JSP
alternative)
%@ page import=java.sql.*%
%
String strId=request.getParameter(id);
String strTable=request.getParameter(table);
String strUidField=request.getParameter(uidfield);
String strUsername=request.getParameter(username);
String strPassword=request.getParameter(password);
String strHost=request.getParameter(host);
String strPort=request.getParameter(port);
String strSid=request.getParameter(sid);
if (strUidField==null | strUidField.equals())
{
response.setContentType(text/html);
out.println(URL UidField does notexist or is blank.);
return;
}
if (strId==null | strId.equals())
{
response.setContentType(text/html);
out.println(URL ID does notexist or is blank.);
return;
}
if (strTable==null | strTable.equals())
{
response.setContentType(text/html);
out.println(Table name does not exist or is blank.);
return;
}
if (strUsername==null | strUsername.equals())
{
response.setContentType(text/html);
out.println(Username does not exist or is blank.);
return;
}
if (strPassword==null | strPassword.equals())
{
response.setContentType(text/html);
out.println(Password does not exist or is blank.);
return;
}
if (strHost==null | strHost.equals())
{
response.setContentType(text/html);
out.println(Host does not exist or is blank.);
return;
}
if (strPort==null | strPort.equals())
{
response.setContentType(text/html);
out.println(Port does not exist or is blank.);
return;
}
if (strSid==null | strSid.equals())
{
response.setContentType(text/html);
out.println(Sid does not exist or is blank.);
return;
}
Class.forName(oracle.jdbc.driver.OracleDriver);
//String str_url = jdbc oracle:thin:@gops_test:1521:GOPS;
//String strUsername=blah;
//String strPassword=blah;
//String strHost=Host name;
//String strPort=Port Number;
//String strSid=SID Name;
//String strTable=Table Name;
String str_url =
jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=+ strHost +
)(PORT =+ strPort + ))(CONNECT_DATA=(SID= + strSid + )));
Connection con =
DriverManager.getConnection(str_url,strUsername,strPassword);
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(SELECT * FROM + strTable +
where +strUidField + = + strId);
int isGood=0;
boolean isText=false;
if (rs.next())
{
String dim_image = rs.getString(EXT);
if (dim_image==null)
{
response.setContentType(text/html);
out.println(Media for this ID is
empty.);
return;
}
dim_image = dim_image.toUpperCase();
if( dim_image.equals(JPG) )
{ isGood=1;
response.setContentType(image/jpeg);}
else if ( dim_image.equals(TIF))
{ isGood=1;
response.setContentType(image/tiff);}
else if ( dim_image.equals(GIF))
{ isGood=1;
response.setContentType(image/gif);}
else if ( dim_image.equals(BMP))
{ isGood=1;
response.setContentType(image/bmp);}
else if ( dim_image.equals(PDF))
{ isGood=1;
response.setContentType(application/pdf);
response.addHeader(Content-disposition, inline;filename=\file.pdf\);
}
else if ( dim_image.equals(MAX))
{ isGood=1;
response.setContentType(application/max);
response.addHeader(Content-disposition, inline;filename=\file.max\);
}
else if ( dim_image.equals(XLS) |
dim_image.equals(CSV))
{ isGood=1;
response.setContentType(application/vnd.ms-excel);
response.addHeader(Content-disposition, inline;filename=\file.xls\);
}
else if ( dim_image.equals(XLS) |
dim_image.equals(DOC))
{ isGood=1;
response.setContentType(application/msword);
response.addHeader(Content-disposition, inline;filename=\file.doc\);
}
else if ( dim_image.equals(MP3))
{ isGood=1;
response.setContentType(audio/x-mpeg3);
response.addHeader(Content-disposition, inline;filename=\file.mp3\);
}
else if ( dim_image.equals(HTM) |
dim_image.equals(HTML)| dim_image.equals(TXT) )
{
isGood=1;
isText=true;
response.setContentType(text/html);
}
else
{
response.setContentType(text/html);out.println(No attached media to
display or unsupported format.);}
if (isGood==1)
{
if (!isText)
{
ServletOutputStream op = response.getOutputStream();
Blob
blob;
blob
= rs.getBlob( PICTURE );
System.out.println(PICTURE);
int
iLength = (int)(blob.length());
op.write(blob.getBytes( 1, iLength ));
}
else
{
java.io.PrintWriter op=response.getWriter();
//
op.write(hi);
//out.println(hi);
Blob
blob;
blob
= rs.getBlob( PICTURE );
int
iLength = (int)(blob.length());
byte
[] data = "" iLength);
for
(int i = 0; i iLength; i++)
{
byte
b = data[i];
//out.println(b);
op.write(b);
}
}
}
}
else
{
response.setContentType(text/html);
out.println(No attached media to display.);
}
rs.close();
stmt.close();
con.close();
%
Stephen E. Schuster
PeopleSoft
Re: single IP issue
Now, I could be wrong, but if you have installed the enterprise version as the on top of jrun4 option (as 2 licence files makes me think u have) then I don¹t imagine u can revert to the CFMX standard stand alone version, I would imagine you have to do a fresh install? On 9/1/04 5:21 pm, Bryan Stevenson [EMAIL PROTECTED] wrote: it's definately the single IP issue...confirmed it in the logsbut no allowedIP settng in the license.properties files.now the fun beginswhere oh where is the dang setting ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: java.lang.IllegalStateException: Session is invalid at jrun.s ervlet.session.JRunSession.checkSessionValidity(JRunSession.java:379)
Dave, On 1/9/2004 at 11:51, you wrote: DW You should be able to make that error go away by limiting the DW duration of J2EE session variables within web.xml: DW http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=10threadid DW =669435#2598160 Thanks! I had stopped checking that thread... Are there any specific advantages to using J2EE sessions? Are there any changes to standard CF session code required when changing to J2EE sessions? ~ Ubqtous ~ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: single IP issue
chatting with MM nowwe'll see ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Ryan Mitchell To: CF-Talk Sent: Friday, January 09, 2004 9:46 AM Subject: Re: single IP issue Now, I could be wrong, but if you have installed the enterprise version as the on top of jrun4 option (as 2 licence files makes me think u have) then I don¹t imagine u can revert to the CFMX standard stand alone version, I would imagine you have to do a fresh install? On 9/1/04 5:21 pm, Bryan Stevenson [EMAIL PROTECTED] wrote: it's definately the single IP issue...confirmed it in the logsbut no allowedIP settng in the license.properties files.now the fun beginswhere oh where is the dang setting ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: single IP issue
Now, I could be wrong, but if you have installed the enterprise version as the on top of jrun4 option (as 2 licence files makes me think u have) then I don¹t imagine u can revert to the CFMX standard stand alone version, I would imagine you have to do a fresh install? I think you're right about that. CFMX for J2EE is significantly different from CFMX Enterprise or Standard. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Need help with MS Word Automation
I am having problems finding information on using Word Automation.What I am trying to do is use CFMX (6.0) to open a MS Word template (.dot file), find the bookmarks in the file, insert data from our database at the bookmark locations, and then save the document as a new file on the server. Once the file has been saved, I need to push it to the client browser (via a UNC path). I think I have the information I need to work with the bookmarks, and know how to push the resulting file to the client.But I'm having problems reliably opening the word.application object. I'm sure this has been done before but am finding very little references in how to do it.Am I just misreading what I have found?Is there some trick that I don't know about? Thanks for any tips. Shawn [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Need help with MS Word Automation
You are opening a can of worms...I don't recommend this.. But try www.cfcomet.com http://www.cfcomet.com/ And use OWA or whatever it is called. It is for Office and makes '00 and '03 automation much easier. Stephen E. Schuster PeopleSoft Administrator 2000 Ashland Drive Ashland, KY 41101 Office Phone 606.920.7447 Cell Phone 606.831.4590 _ From: Shawn Grover [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 1:06 PM To: CF-Talk Subject: Need help with MS Word Automation I am having problems finding information on using Word Automation.What I am trying to do is use CFMX (6.0) to open a MS Word template (.dot file), find the bookmarks in the file, insert data from our database at the bookmark locations, and then save the document as a new file on the server. Once the file has been saved, I need to push it to the client browser (via a UNC path). I think I have the information I need to work with the bookmarks, and know how to push the resulting file to the client.But I'm having problems reliably opening the word.application object. I'm sure this has been done before but am finding very little references in how to do it.Am I just misreading what I have found?Is there some trick that I don't know about? Thanks for any tips. Shawn _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Images - store in DB or filesystem?
Stephen, I'd be interested in seeing the JSP code, particularly the part about streaming the output. Thanks, Dave Jones NetEffect At 12:39 PM 1/9/04 -0500, you wrote: Well I'm not sure about taking up less size at all. Now given you will have to create an initial database but minus that it's just data. Regardless if you go this route the space differences would be minimal. If you want I can post the JSP code we use for retrieval? Stephen E. Schuster PeopleSoft Administrator 2000 Ashland Drive Ashland, KY 41101 Office Phone 606.920.7447 Cell Phone 606.831.4590 _ From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 11:04 AM To: CF-Talk Subject: Re: Images - store in DB or filesystem? Hi Steven: I'll have to defer to your experience here, as my answer was based only on a response I got from an instructor when asking him this same question...so I've always done it the text datatype/file path method. Maybe 'bloat' was too strong of a word?Maybe he just meant that storing the images as files would take up -less- space than storing them as BLOBs? Charlie - Original Message - From: Schuster, Steven To: CF-Talk Sent: Friday, January 09, 2004 8:47 AM Subject: RE: Images - store in DB or filesystem? I can assure you that storing images in BLOB does not bloat a database. They are designed for this very thing. Though I will admit that Oracle is far better than SQL Server at doing it. I have never really dealt with mySQL and it's been years since I used Informix so I can't tell you much on those products. We do this for our fax apps. We store all types of data in Oracle BLOBS and it is actually faster than file writes. We use a JSP page to do the pulls and puts. In fact we even integrated it into our PeopleSoft product so that our remote locations can now just fax in new hire documents, the faxes go directly to the database and are available for viewing through the Job panel in PS. Stephen E. Schuster PeopleSoft Administrator 2000 Ashland Drive Ashland, KY 41101 Office Phone 606.920.7447 Cell Phone 606.831.4590 _ From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 10:42 AM To: CF-Talk Subject: Re: Images - store in DB or filesystem? I've always heard path in text fields.From what I understand, storing as BLOBs will bloat the db, and it's rather slow. - Original Message - From: Spectrum WebDesign To: CF-Talk Sent: Friday, January 09, 2004 8:15 AM Subject: Images - store in DB or filesystem? What's the in/out for image storage? Bynary in BLOB database fields or file system or path in text fields? - Original Message - From: Pascal Peters [EMAIL PROTECTED] Date: Fri, 9 Jan 2004 15:40:16 +0100 To: CF-Talk [EMAIL PROTECTED] Subject: RE: insert multiple drop down list selects into access Looks like you want a one-to many relationship. Create a second table for that (with a FK to the existing table). Then loop over the list and insert in the second table within the loop (using the PK from the record in the first table as FK in the second table) -Oorspronkelijk bericht- Van: Tim Laureska [mailto:[EMAIL PROTECTED] Verzonden: vr 9/01/2004 15:15 Aan: CF-Talk CC: Onderwerp: insert multiple drop down list selects into access Is it possible to insert into one access database number field, a comma delimited list of numbers, received from a form template thusly (is not working now ... only can one number to show in the database when multiples are selected on the form drop down): FORM CODE: select name=cat_no multiple cfoutput query=client_catoption value=#cat_no##work_cat#/cfoutput /select TEMPLATE WHERE DATABASE INSERT IS HAPPENING: cfquery datasource=todo dbtype=odbc INSERT into clients (category) VALUES (#cat_no#) /cfquery TIA Tim _ _ _ -- [ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: single IP issue
Hmmm...and when I asked this list before everybody thought it wouldn't be a problemg. Well I'll ask this...if it's the Standard versioncan I still access and use Java like so? cfscript pdfFile = createObject(java, java.io.FileOutputStream).init(attributes.save_as); /cfscript Thanks Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Dave Watts To: CF-Talk Sent: Friday, January 09, 2004 10:07 AM Subject: RE: single IP issue Now, I could be wrong, but if you have installed the enterprise version as the on top of jrun4 option (as 2 licence files makes me think u have) then I don¹t imagine u can revert to the CFMX standard stand alone version, I would imagine you have to do a fresh install? I think you're right about that. CFMX for J2EE is significantly different from CFMX Enterprise or Standard. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: single IP issue
Is it possible to format pdf EXACTLY as you have formatted it in the html/cd tag? As the code loops, the images/text don't align evenly in each row. I am trying to format pdf for Avery business card paper. Here is my code: CF_HTML2PDF3 myHTMLDOC=D:\Program Files\HTMLDOC\htmldoc.exe myOPTIONS=--portrait --fontsize 11pt --bodyfont typeface Arial --top 0.20in --left .5in --right .5in --bottom 0.00in --size 8.5x11in --footer ... mySTATPATH=d:\users\tdlabs\tdlabs.com\beta\nta\pdf mySTATFILE=static.html myPDFPath=d:\users\tdlabs\tdlabs.com\beta\nta\pdf TABLE width=100% border=0 cfset newrow = true cfloop index=getcode from=1 to=#form.number# step=1 cfset firstcodeid = #variables.newcodeid# + #getcode# cfset codeid = NTA#variables.firstcodeid##cookie.ntauser#cfoutput#getcode#/cfoutput cfif #variables.newrow# IS truetrTD height=187 valign=bottom align=leftcfelse TD height=187 valign=bottom align=right/cfifTABLE width=330 height=182 border=0 cellpadding=1 cellspacing=0TRTD align=center valign=middleTABLE cellpadding=0 cellspacing=0 border=0TRTD valign=bottomcfoutputimg src=""> align=left valign=bottomhttp://www.tacticaldesignlabs.comBR cfoutput#form.name#/cfoutputBR Discount Code: cfoutput#variables.codeid#/cfoutputBR/TD /TR/TABLE/TD/TR/TABLE/TDcfif #getcode# MOD 2 EQ 0/trcfset variables.newrow = truecfelse cfset variables.newrow = false/cfif /cfloop /TABLE/TD/TR/TABLE/CF_HTML2PDF3 Thanks, Kelly [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
oops...cf_html2pdf question.
sorry about my last post. Is it possible to format pdf EXACTLY as you have formatted it in the html/cd tag? As the code loops, the images/text don't align evenly in each row. I am trying to format pdf for Avery business card paper. Here is my code: CF_HTML2PDF3 myHTMLDOC=D:\Program Files\HTMLDOC\htmldoc.exe myOPTIONS=--portrait --fontsize 11pt --bodyfont typeface Arial --top 0.20in --left .5in --right .5in --bottom 0.00in --size 8.5x11in --footer ... mySTATPATH=d:\users\tdlabs\tdlabs.com\beta\nta\pdf mySTATFILE=static.html myPDFPath=d:\users\tdlabs\tdlabs.com\beta\nta\pdf TABLE width=100% border=0 cfset newrow = true cfloop index=getcode from=1 to=#form.number# step=1 cfset firstcodeid = #variables.newcodeid# + #getcode# cfset codeid = NTA#variables.firstcodeid##cookie.ntauser#cfoutput#getcode#/cfoutput cfif #variables.newrow# IS truetrTD height=187 valign=bottom align=leftcfelse TD height=187 valign=bottom align=right/cfifTABLE width=330 height=182 border=0 cellpadding=1 cellspacing=0TRTD align=center valign=middleTABLE cellpadding=0 cellspacing=0 border=0TRTD valign=bottomcfoutputimg src=""> align=left valign=bottomhttp://www.tacticaldesignlabs.comBR cfoutput#form.name#/cfoutputBR Discount Code: cfoutput#variables.codeid#/cfoutputBR/TD /TR/TABLE/TD/TR/TABLE/TDcfif #getcode# MOD 2 EQ 0/trcfset variables.newrow = truecfelse cfset variables.newrow = false/cfif /cfloop /TABLE/TD/TR/TABLE/CF_HTML2PDF3 Thanks, Kelly [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Need help with MS Word Automation
If you're open to options other than automation, take a look at these links: Integrating ColdFusion with Microsoft Office: Breezo and examples http://www.rewindlife.com/archives/000118.cfm Serving Word http://www.rewindlife.com/archives/32.cfm HTH, Sam --- Blog: http://www.rewindlife.com Charts: http://www.blinex.com/products/charting --- -Original Message- From: Shawn Grover [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 1:06 PM To: CF-Talk Subject: Need help with MS Word Automation I am having problems finding information on using Word Automation.What I am trying to do is use CFMX (6.0) to open a MS Word template (.dot file), find the bookmarks in the file, insert data from our database at the bookmark locations, and then save the document as a new file on the server. Once the file has been saved, I need to push it to the client browser (via a UNC path). I think I have the information I need to work with the bookmarks, and know how to push the resulting file to the client.But I'm having problems reliably opening the word.application object. I'm sure this has been done before but am finding very little references in how to do it.Am I just misreading what I have found?Is there some trick that I don't know about? Thanks for any tips. Shawn [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: single IP issue
Hmmm...and when I asked this list before everybody thought it wouldn't be a problemg. When you asked before, you said you'd installed CFMX Enterprise, without saying you'd installed CFMX on J2EE, I think. Well I'll ask this...if it's the Standard versioncan I still access and use Java like so? cfscript pdfFile = createObject(java, java.io.FileOutputStream).init(attributes.save_as); /cfscript You should be able to do this. You can't use JSPs and servlets from Standard, though. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: single IP issue
Thanks Dave, Yeah you may be right about what I said I installed.There was some confusion at the time because the ISP installed CF on a colo box and wasn't 100% sure which option was selected ;-) Oh well...as long as I can run that code I'm laughin Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder Director www.cfug-vancouverisland.com - Original Message - From: Dave Watts To: CF-Talk Sent: Friday, January 09, 2004 10:39 AM Subject: RE: single IP issue Hmmm...and when I asked this list before everybody thought it wouldn't be a problemg. When you asked before, you said you'd installed CFMX Enterprise, without saying you'd installed CFMX on J2EE, I think. Well I'll ask this...if it's the Standard versioncan I still access and use Java like so? cfscript pdfFile = createObject(java, java.io.FileOutputStream).init(attributes.save_as); /cfscript You should be able to do this. You can't use JSPs and servlets from Standard, though. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: java.lang.IllegalStateException: Session is invalid at jrun.s ervlet.session.JRunSession.checkSessionValidity(JRunSession.java:379)
Are there any specific advantages to using J2EE sessions? Yes, although for most CF developers they probably aren't significant. By default, J2EE session cookies are a bit more obtuse than those used by traditional CF session management, and they're actually session cookies - they don't persist after the browser is closed, for example. You can also use the same session data between CF and JSP/servlet applications using J2EE sessions, and you can take advantage of JRun's clustering if you want to share session data across multiple instances, assuming you're using the full version of JRun. Are there any changes to standard CF session code required when changing to J2EE sessions? Not to my knowledge, as long as your code doesn't refer to CFID or CFTOKEN values directly. You may potentially run into other wacky problems, such as when you redirect to a static HTML page using CFLOCATION and your web server doesn't know how to parse the generated URL with the session token embedded within it. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Images - store in DB or filesystem?
Do you have a rough estimate of the performance difference of using this streamed output via JSP compared to just doing a standard CF query? -Kevin - Original Message - From: Schuster, Steven [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, January 09, 2004 11:45 AM Subject: RE: Images - store in DB or filesystem? For Inserts we just use the cf_blob type in MX 6.1 and do a direct insert into the blob. To retrieve we have this JSP page. This allows a direct stream read to the browser and does not write the file to the system and then attempt to read it. But we have code that does that as well if you need to look at it also. This is a JSP page so you must be running MX for this to work (or a JSP alternative) [snip [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Images - store in DB or filesystem?
I did, let me dig around and see if I can find them. I already posted the JSP code, here is the CF equivalent that writes the file to disk and lets you view them. This doesn't take any more space either as the cfcontent tag simply deletes the file after it has streamed to the browser. cfparam name=SID default=None cfparam name=ID default=0 cfparam name=Table default=None cfparam name=Extn default=ext cfparam name=UidField default=ID cfparam name=MediaField default=Media cfparam name=DirectorySet default=c:\inetpub\wwwroot\Faxed\viewacts\ cfif #ID# IS 0 p General Error Occured /p cfabort cfelse cftry CFQUERY name=qryGetCV datasource=#SID# SELECT * FROM #Table# WHERE #uidfield# = #ID# /CFQUERY cfcatch type=Database A general database error has occured trying to run the specified query! p SELECT * FROM #Table# WHERE #uidfield# = #ID# /p cfabort /cfcatch /cftry !--- Create the Temp Files --- cfdirectory directory=#DirectorySet# name=qryFindIt cfset temp = ValueList(qryFindIt.Name) cfoutput query=qryGetCV cfset FileVal = #Evaluate(qryGetCV. #uidfield#)# . #Evaluate(qryGetCV. #Extn#)# cfset myCount = ListValueCount(temp, FileVal) cfif #myCount# IS 1 !--- Skip For Now --- cfelse cffile action=""> file=#DirectorySet##FileVal# output=#toBinary(Evaluate(qryGetCV. #mediafield#))# addnewline=No /cfif /cfoutput cfset Ext =#Evaluate(qryGetCV. #Extn#)# !--- Display File in Browser --- !--- Also deleted the file after it has been written to conserve space --- cfif Ext IS PDF cfcontent file=#DirectorySet##Evaluate(FileVal)# type=application/pdf deletefile cfelseif Ext IS TIFF or Ext IS TIF cfcontent file=#DirectorySet##Evaluate(FileVal)# type=image/tiff deletefile cfelseif Ext IS GIF cfcontent file=#DirectorySet##Evaluate(FileVal)# type=image/gif deletefile cfelseif Ext IS BMP cfcontent file=#DirectorySet##Evaluate(FileVal)# type=image/bmp deletefile cfelseif ucase(Ext) IS MAX cfcontent file=#DirectorySet##Evaluate(FileVal)# type=application/max deletefile cfelseif Ext IS CSV cfcontent file=#DirectorySet##Evaluate(FileVal)# type=application/vnd.ms-excel deletefile cfelseif Ext IS XLS cfcontent file=#DirectorySet##Evaluate(FileVal)# type=application/vnd.ms-excel deletefile cfelseif Ext IS DOC cfcontent file=#DirectorySet##Evaluate(FileVal)# type=application/msword deletefile cfelseif Ext IS MP3 cfcontent file=#DirectorySet##Evaluate(FileVal)# type=audio/x-mpeg3 deletefile cfelseif Ext IS TXT cfcontent file=#DirectorySet##Evaluate(FileVal)# type=text/html deletefile cfelseif Ext IS HTM cfcontent file=#DirectorySet##Evaluate(FileVal)# type=text/html deletefile cfelse cfcontent file=#DirectorySet##Evaluate(FileVal)# type=text/html deletefile /cfif /cfif Stephen E. Schuster PeopleSoft Administrator 2000 Ashland Drive Ashland, KY 41101 Office Phone 606.920.7447 Cell Phone 606.831.4590 _ From: Kevin Graeme [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 1:51 PM To: CF-Talk Subject: Re: Images - store in DB or filesystem? Do you have a rough estimate of the performance difference of using this streamed output via JSP compared to just doing a standard CF query? -Kevin - Original Message - From: Schuster, Steven [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, January 09, 2004 11:45 AM Subject: RE: Images - store in DB or filesystem? For Inserts we just use the cf_blob type in MX 6.1 and do a direct insert into the blob. To retrieve we have this JSP page. This allows a direct stream read to the browser and does not write the file to the system and then attempt to read it. But we have code that does that as well if you need to look at it also. This is a JSP page so you must be running MX for this to work (or a JSP alternative) [snip _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
