RE: Securing CF Apps against SQL Injection Cross Site Scripting
good ideas, all.Thanks for sharing! Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc.http://mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Firebird DBMS with CFMX
I just found a decent resource for this, in case anyone is interested. Should be able to work it out from here: http://forums.devshed.com/archive/t-65588 -Original Message- From: Nando [mailto:[EMAIL PROTECTED] Sent: Friday, May 07, 2004 5:45 AM To: CF-Talk Subject: RE: Firebird DBMS with CFMX Steven, I'm staring at the Data Source setup screen, and i have choices for JDBC URL, Driver Class, and Driver Name. I looked in the docs and fond nothing very specific how to set these up. Any advice here? Thanx, n. -Original Message- From: Steven Erat [mailto:[EMAIL PROTECTED] Sent: Friday, May 07, 2004 5:28 AM To: CF-Talk Subject: RE: Firebird DBMS with CFMX I've set up FIrebirdSQL with CFMX using the Jaybird JDBC driver, but haven't done too much with it beyond a few queries.However, I have worked with a few people that use it reguarly with CFMX. About a year ago there was a bug in the driver where it would hang on inserts/updates, so we reported it to the project team and they fixed it within a couple days. _ From: Nando [mailto:[EMAIL PROTECTED] Sent: Thursday, May 06, 2004 10:03 PM To: CF-Talk Subject: Firebird DBMS with CFMX Has anyone set up Firebird DBMS to work with ColdFusion? http://firebird.sourceforge.net/ If so, any pointers on getting it working? I thought i'd ask before messing around. I've never tried to use an alternate driver ... _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: grouping output
Use level to determine the output SELECT *, LEVEL FROM NAVMENU START WITH MNUPARENT = 0 CONNECT BY PRIOR MNUPARENT=MNUCHILD cfoutput query=qMenu... #RepeatString(- ,qMenu.level)# #qMenu.MNUDISP#br /cfoutput This is simple, but you can do more complicated things by using level -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: vrijdag 7 mei 2004 0:45 To: CF-Talk Subject: grouping output I'm wanting to dynamically create a menu. My table has 6 columns. MNUITEMNUM (primary key - increments on insert), MNUPARENT (the parent menu id), MNUCHILD (the child menu id), MNUURL (the link associated with the menu item), MNUDISP (what's displayed as the menu item), MNUWIN (determines whether to open in new or same window) So here's a sample menu... MNUITEMNUM MNUPARENT MNUCHILD MNUURL MNUDISP MNUWIN 21 1 0 _javascript_:; Equipment 22 21 1 Assets/Documents/handset_matrix.xls Handset Profiles new 23 22 1 index.cfm?template=htmHandset Training Materials same 24 103 1 _javascript_:; Rebates 25 21 103 Assets/Documents/T720 Rebate spiff 4-1-04.c2.doc Current Rebates new 26 22 103 Assets/Documents/T720 rebate procedures.doc Rebate Procedures new 27 23 103 mailto:[EMAIL PROTECTED] Rebate Support 28 25 1 Assets/Documents/roam_indicators.doc Roam Indicators new This creates a menu that looks like Equipment Handset Profiles Handset Training Materials Rebates Current Rebates Rebate Procedures Rebate Support Roam Indicators now I can get this to output with SQL.. SELECT * FROM NAVMENU START WITH MNUPARENT = 0 CONNECT BY PRIOR MNUPARENT=MNUCHILD But I want to output this using Cold Fusion to show a visual of the menu.. I've tried using group and output but I'm coming up with nothing.. Maybe see something like I demonstrated above... IE Equipment -Handset Profiles -Handset Training Materials -Rebates --Current Rebates --Rebate Procedures --Rebate Support -Roam Indicators How can this be done? ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: grouping output
If you have a level field in your table, that is. Very handy to include. You could also define a style based on the level, dynamically set the class in a div tag for instance, and then do whatever is necessary in your style sheet for each level. div class=menu#LEVEL# ... /div -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: Friday, May 07, 2004 9:14 AM To: CF-Talk Subject: RE: grouping output Use level to determine the output SELECT *, LEVEL FROM NAVMENU START WITH MNUPARENT = 0 CONNECT BY PRIOR MNUPARENT=MNUCHILD cfoutput query=qMenu... #RepeatString(- ,qMenu.level)# #qMenu.MNUDISP#br /cfoutput This is simple, but you can do more complicated things by using level -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: vrijdag 7 mei 2004 0:45 To: CF-Talk Subject: grouping output I'm wanting to dynamically create a menu. My table has 6 columns. MNUITEMNUM (primary key - increments on insert), MNUPARENT (the parent menu id), MNUCHILD (the child menu id), MNUURL (the link associated with the menu item), MNUDISP (what's displayed as the menu item), MNUWIN (determines whether to open in new or same window) So here's a sample menu... MNUITEMNUM MNUPARENT MNUCHILD MNUURL MNUDISP MNUWIN 21 1 0 _javascript_:; Equipment 22 21 1 Assets/Documents/handset_matrix.xls Handset Profiles new 23 22 1 index.cfm?template=htmHandset Training Materials same 24 103 1 _javascript_:; Rebates 25 21 103 Assets/Documents/T720 Rebate spiff 4-1-04.c2.doc Current Rebates new 26 22 103 Assets/Documents/T720 rebate procedures.doc Rebate Procedures new 27 23 103 mailto:[EMAIL PROTECTED] Rebate Support 28 25 1 Assets/Documents/roam_indicators.doc Roam Indicators new This creates a menu that looks like Equipment Handset Profiles Handset Training Materials Rebates Current Rebates Rebate Procedures Rebate Support Roam Indicators now I can get this to output with SQL.. SELECT * FROM NAVMENU START WITH MNUPARENT = 0 CONNECT BY PRIOR MNUPARENT=MNUCHILD But I want to output this using Cold Fusion to show a visual of the menu.. I've tried using group and output but I'm coming up with nothing.. Maybe see something like I demonstrated above... IE Equipment -Handset Profiles -Handset Training Materials -Rebates --Current Rebates --Rebate Procedures --Rebate Support -Roam Indicators How can this be done? ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Securing CF Apps against SQL Injection Cross Site Scripting
On Friday 07 May 2004 00:01 am, Andrew Grosset wrote: Works great in IE, but Mozilla Firebird ignores cfheader and displays the *Really* ?!? :tests Bonkers. I'd stick a cfabort in after the cfheader, just to be sure anyway. -- 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: disable back button when using div's
thank you guys for your help. I decided to go with the server option. I'm checking to see if the record already exists in the database. If he does, I'm just alerting/displaying a message. Thanks again for your help. cf coder said: I want to disable the 'back' button when the user sees the confimation message. Is this possible, if yes can somebody please show me. You can kludge some workarounds that will fool most browsers, but you can't reliably disable the back button. In *my* browser *I* decide whether *my* back button will work. You can do whatever you want on the server, like ignoring the second/third etc. submission of the form, because you control the server, but the client controls the browser. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: grouping output
Actually, he is using oracle and LEVEL is a system column when using CONNECT BY. It doesn't have to exist in the table. -Original Message- From: Nando [mailto:[EMAIL PROTECTED] Sent: vrijdag 7 mei 2004 10:13 To: CF-Talk Subject: RE: grouping output If you have a level field in your table, that is. Very handy to include. You could also define a style based on the level, dynamically set the class in a div tag for instance, and then do whatever is necessary in your style sheet for each level. div class=menu#LEVEL# ... /div -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: Friday, May 07, 2004 9:14 AM To: CF-Talk Subject: RE: grouping output Use level to determine the output [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: http compression
Have you tried that? That would, in practice, mean running the CF server on a different port, have the proxy listening on port 80 and compressing the requests? How much would that impact the server load? -- Hugo Ahlenius - 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: Thomas Chiverton [mailto:[EMAIL PROTECTED] | Sent: Thursday, May 06, 2004 16:11 | To: CF-Talk | Subject: Re: http compression | | On Wednesday 05 May 2004 17:16 pm, Hugo Ahlenius wrote: | this purpose... Are anyone using that? I guess the only | other option | is to use a compression proxy (not a very attractive solution). | | What about Apache's mod_proxy ? | | -- | 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]
ANNOUNCE: CFUN-04 interviews 13,14,15 - J2EE by Charlie Arehart, CMS by Bogdan Ripa, Variables by Hal Helms
In these CFUN-04 Interviews * Charlie Arehart talks about his CFUN-04 session on Deploying CFML on J2EE: Opportunities and Challenges. * Bogdan Ripa talks about Building a ColdFusion CMS with MX Kollection * Hal Helms talks about Variables and Conditions at the CF Bootcamp * Conference and training news * More CFUN spaces are available - we increased the session rooms at CFUN so that we can fit 500 people at the event (we originally planned for 400) Currently 383 people are registered for CFUN. Don't miss out! * Two CFUN hotels are fully booked - for alternatives see http://www.cfconf.org/CFUN-04/directions.cfm * Macromedia Community Week is May 17-21 - see sneak new product peaks http://www.cfconf.org/CommunityWeek/ * Fusebox training FB101 5/25/04 and FB201 6/1/04 ColdFusion security and performance CF201 5/11/04 http://www.teratech.com/training/ * Richpalette will be releasing the beta of their new CF IDE He3 to all CFUN attendees at CFUN-04. The editor provides support for XML, HTML, CSS, SQL, regular expressions, XPaths, Fusebox 4 and Mach-II. http://www.richpalette.com/ * Methodology BOF being planned for Saturday lunchtime, more soon * CFUN quotes: There is nothing like the interaction and dynamics of a gathering of those seeking answers and experts ready to provide it -- the sheer hands-on how-to expertise is like the fountain of knowledge -- if you're thirsty, you gotta be there. - Donna Casey Its fast (1 weekend time commitment), cheap (under $200 if you sign up before 3/31), and out of control (sessions cover everything from CSS to Flash remoting to integrating Java). - Amy Neymeyr * Now back to the interviews *** Charlie Arehart *** In his first CFUN interview with Charlie Arehart, Michael Smith queries Charlie about his presentation, Deploying CFML on J2EE: Opportunities and Challenges. Michael Smith: Charlie, why should someone care about J2EE? Charlie Arehart: That's a great question, because I'm sure some looking at the title may yawn since they don't use J2EE, don't want to, or just don't see any relevance in their environment. They use ColdFusion (or CFMX or BlueDragon) as a standalone server and are happy with it. But guess what: this talk is really addressed toward them, to explain why it's worth considering running your CFML on J2EE. MS: What does J2EE mean? Is it just another word for Java? [rest of interview at http://www.cfconf.org/CFUN-04/news.cfm ] Bogdan Ripa ** Michael Smith: Why should programmers be interesting in building a CMS with MX Kollection? Bogdan Ripa: As the web is developing, the need for dynamic websites increases and everybody wants to edit their own content without paying expensive maintenance costs. Building a CMS from scratch is not easy. MX Kollection adds a set of powerful features to Dreamweaver, making Dynamic Web Development easy for everybody. MS: What exactly is a CMS anyway? BR: Now this is a good question. CMS stands for Content Management System. So a CMS is software that enables you to ... [rest of interview at http://www.cfconf.org/CFUN-04/news.cfm ] *** Hal Helms *** In Michael Smith's third interview with Hal Helms, they discuss Hal's talk on Variables and Conditions at the CF Bootcamp track at CFUN-04. Michael Smith: Why should a new CF programmer care about variables? Hal Helms: Variables allow our programs to adapt to changes, to conditions that the programmer cannot know about precisely. They do so by providing a layer of adaptable abstraction rather than a hard-coded value. MS: Hmmm...what exactly does that mean? [rest of interview at http://www.cfconf.org/CFUN-04/news.cfm ] You can see more interviews at http://www.cfconf.org/CFUN-04/news.cfm and in Fusion Authority, the House of Fusion Technical Magazine (http://www.fusionauthority.com). CFUN- 04 is Saturday 6/26/04 - Sunday 6/27/04 in the Washington DC area. It costs $269 after 3/31/04. For more information on CFUN see http://www.cfconf.org/cfun-04/. --- CFUN is organized by TeraTech who received four CFDJ awards. If you need ColdFusion project help, mentoring or training then ask the experts at http://www.teratech.com/ Best Consulting - TeraTech Finalist Training - TeraTech Finalist Community site - CFConf Finalist Web Dev Tool - CFXGraphicsServer --- This year's conference has 32 nationally known speakers including Charlie Arehart, Steve Drucker, Raymond Camden, Hal Helms, Michael Smith, Michael Dinowitz, Simon Horwith and Shlomy Gantz. CFUN-04 Washington DC area 6/26 - 6/27/04: * Learn CF MX, Flash and more! * Network with your peers and top national speakers * Have fun exploring what is new from Macromedia Tracks: * Advanced Topics - for gurus, XML, CFCs, SQL * MX Integration - Flash, Java, Flex, .Net, Webservices * Empowered Programming - OO, Fusebox, PM, Testing, Debug * CF Bootcamp - for
RE: query question
did you mean or operators? I have ands in there... tony Tony Weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] 410.548.2337 www.navtrak.net -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED] Sent: Friday, May 07, 2004 12:46 AM To: CF-Talk Subject: Re: query question On May 6, 2004, at 9:25 PM, Tony Weeg wrote: am using sql server, I have aqua data studio, im using query analyzer right now... I don't have any other way of getting to the count, that's the problem there isnt anything else in the vehicle table that links back to the company table that has the guid that links back to the crm system, and its guid for the company, and then the order based on the account number, and the sales order details, based on the sales order number. maybe I just cant do it with the current table layout. its like, the first part of the query is locking the result set in regardless of what else matches... heck...ill try your plan, its how I built the thing in the first placetho'causethat's how I trouble shoot too :( so maybe again might work, ill try it again. is there any reason that the first join would be sooo commanding in regard to its relentless match regardless of the where clause? That's an interesting question -- an inner join is supposed to return something if both side of the join are present - so what happens if the first joins matches and the others don't -- do you have a match or not--- hmmm Unfortunately I don't have a db handy with enough relationships that I can experiment with -- I have Sybase_ASE running on my Mac for complex dbs -- common ancestry with SQL-Server. Another option is to put the tests in the where clause with AND operators Dick tony -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED] Sent: Friday, May 07, 2004 12:22 AM To: CF-Talk Subject: Re: query question What usually helps me in a case like this is to simplify the query (if you can). 1) Take out all the joins 2) add them back one at a time Kinda' build the complex query in a series of simple steps.. Do you have a interactive SQL client that you can use to do this? It looks like you are using SQL-Server, No? Dick On May 6, 2004, at 8:59 PM, Tony Weeg wrote: ok, I did this. I get everything different, but the id number from the table where the count comes from, the id number of the 1 vehicle that is in there...it has a different productId, I see the two different productId's, it has a different salesOrderDEtailId, they both have the same salesOrderId...this isnt making sense hmmm tony [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
UDF in Component?
I'm having trouble.I have a component with a method (addEmail).In that method, I receive an email address, check to make sure it's not already in the database and then add it.I also want to add functionality for checking to make sure it's a valid email address.I'm using the UDF IsEmail on CFLib.org in some other places so I decided to drop it into that method as well.When I do, I get an error saying: Unable to complete CFML to Java translation. Error information unsupported statement: class coldfusion.compiler.ASTfunctionDefinition Am I not allowed to use UDFs in components?Or am I doing something else wrong?Let me know if you have insight.Thanks. John Burns [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: DeMoronize for MX?
Not sure about the demoronize, but I use this function to convert the extended characters to their corresponding html entities. Our CFMX is set up as unicode, so YMMV. That was one of the issues I saw with the conversion from 5.0 to MX - the way in which extended characters were interpreted by the MX server changed. !--- Note - you need to use the escapequotes() function in your forms instead of htmleditformat --- cfscript function unicodeToHTML(textin) { var textout = ; textout = replacelist(textin, #chr(8216)#,#chr(8217)#,#chr(8218)#,#chr(8220)#,#chr(8221)#,#chr(8212)#,#ch r(8211)# ,#chr(8230)#,#chr(8226)#,#chr(732)#,#chr(8482)#,#chr(8364)#,#chr(402)#,#chr( 8222)#,#chr(8224)#,#chr(8225)#,#chr(8249)#,#chr(8250)#,#chr(169)#,#chr(176)# ,#chr(162)#,#chr(163)#,lsquo;,rsquo;,##130;,ldquo;,rdquo;,mdash;,nd ash;,hellip;,bull;,tilde;,trade;,euro;,##131;,##132;,##134;,##135;, ##139;,##155;,copy;,deg;,cent;,##163;); return textout; } function escapequotes (textin) { var textout = ; textout = replacelist(textin, '#chr(148)#,#chr(147)#,', 'rdquo;,ldquo;,ldquo;' ); return textout; } /cfscript - Original Message - From: Jake Does anyone know if the DeMoronize() UDF works with MX? I'm having troubles getting it to work correctly, and I seem to remember reading somewhere that there were issues with it with MX. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: UDF in Component?
You can place a UDF in the component, but it will be treated like a method. Tell me - how are you calling the function? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Coldfusion and XML
Forgive me if this is a very stupid question or in some way wrong, However, I think I need to send an XML feed back to a client from the server, the client machine is a touch screen that will remotely make a call to, I think, a file on our webserver that will run a query on the database and return the results - which I believe have to be in the form of an XML Feed. Is this possible, can someone give me some pointers? Thanks, Dave [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: UDF in Component?
I would guess you would need to take the code from the UDF and make it a method of the Component.Should be fairly straight forward, but I've never tried it. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
repost from last night: query question
ok, in the two queries below, the salesOrderDetailId and the productId are different for each. the only thing in common is that they have the same companyIDNumber. however since that's not in the where clause, how can this return that both have a count of 1, where I know that the only one that has a count of one, for real, is the top one? select count(ipAddressNumber) as vehicles from vehicleTable v inner join companyTable c on c.companyIdNumber = v.companyIdNumber inner join account a on a.accountId = c.crmGUID inner join salesOrder so on a.accountId = so.accountId inner join salesOrderDetail sod on sod.salesOrderId = so.salesOrderId inner join product p on p.productId = sod.ProductId where (sod.salesOrderDetailId = 'b25513c8-22e3-405e-9b2a-917c606e5149' and p.productId = '9829daef-84ce-4248-9696-fa6686411b94') select count(ipAddressNumber) as vehicles from vehicleTable v inner join companyTable c on c.companyIdNumber = v.companyIdNumber inner join account a on a.accountId = c.crmGUID inner join salesOrder so on a.accountId = so.accountId inner join salesOrderDetail sod on sod.salesOrderId = so.salesOrderId inner join product p on p.productId = sod.ProductId where (sod.salesOrderDetailId = '0568f951-29ef-4881-a786-d50e0d75e3f1' and p.productId = 'e08c80b4-fd57-482e-93b9-213aef2ba83d') sorry for the repost, this is odd, and im not sure I understand why?? thanks! ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Coldfusion and XML
look @ cfsavecontent to create the xml. maybe look @ cfhttp to make the call to the server to get the xml generated? maybe look @ using a cfmx webservice, and have the browser on the touch screen make a request to the webservice. some ideas? tony -Original Message- From: David Ashworth [mailto:[EMAIL PROTECTED] Sent: Friday, May 07, 2004 9:27 AM To: CF-Talk Subject: Coldfusion and XML Forgive me if this is a very stupid question or in some way wrong, However, I think I need to send an XML feed back to a client from the server, the client machine is a touch screen that will remotely make a call to, I think, a file on our webserver that will run a query on the database and return the results - which I believe have to be in the form of an XML Feed. Is this possible, can someone give me some pointers? Thanks, Dave [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Coldfusion and XML
Dave I think I need to send an XML feed back to a client from the server, the client machine is a touch screen that will remotely make a call to, I think, a file on our webserver that will run a query on the database and return the results - which I believe have to be in the form of an XML Feed. Not stupid or wrong but certainly possible - the touch screen can contain a link to a ColdFusion template which generates an XML document. Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: UDF in Component?
My code looks like this (simplified version): cfcomponent cffunction name=addEmail access=remote returntype=string cfargument name=emailAddress required=yes type=string default= cfscript function IsEmail(str) { //supports new top level tlds if (REFindNoCase(^['_a-z0-9-]+(\.['_a-z0-9-]+)[EMAIL PROTECTED](\.[a-z0-9-]+) \.(([a-]{2,3})|(aero|coop|info|museum|name))$,str)) return TRUE; else return FALSE; } /cfscript cfif IsEmail(arguments.emailAddress) cftry cfquery... /cfquery cfcatch/cfcatch /cftry /cfif cfreturn returnVar /cffunction /cfcomponent Is that incorrect?Let me know. John Burns -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Friday, May 07, 2004 9:21 AM To: CF-Talk Subject: RE: UDF in Component? You can place a UDF in the component, but it will be treated like a method. Tell me - how are you calling the function? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: query question
No, I mean something like: select count(ipAddressNumber) as vehicles from vehicleTable v WHERE 0=0 AND vehicleTable.companyIdNumber = companyTable.companyIdNumber AND companyTable.crmGUID = account.accountId AND account.accountId = salesOrder.accountId AND salesOrder.salesOrderId = salesOrderDetail.salesOrderId AND salesOrderDetail.ProductId = product.productId AND ( salesOrderDetail.salesOrderDetailId = 'b25513c8-22e3-405e-9b2a-917c606e5149' AND product.productId = '9829daef-84ce-4248-9696-fa6686411b94' ) Note: I rearranged the order of the test fields so I could follow the logic the 0=0 test allows you to selectively turn of any real test by enclosing it within cfif 0 NE 0/cfif tags. instead of select count(ipAddressNumber) as vehicles from vehicleTable v inner join companyTable c on c.companyIdNumber = v.companyIdNumber inner join account a on a.accountId = c.crmGUID inner join salesOrder so on a.accountId = so.accountId inner join salesOrderDetail sod on sod.salesOrderId = so.salesOrderId inner join product p on p.productId = sod.ProductId where (sod.salesOrderDetailId = 'b25513c8-22e3-405e-9b2a-917c606e5149' and p.productId = '9829daef-84ce-4248-9696-fa6686411b94') Dick P.S. Let me know if this resolves the prob-- the only db's I have handy would allow 2 inner joins On May 7, 2004, at 4:53 AM, Tony Weeg wrote: did you mean or operators? I have ands in there... tony Tony Weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] 410.548.2337 www.navtrak.net -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED] Sent: Friday, May 07, 2004 12:46 AM To: CF-Talk Subject: Re: query question On May 6, 2004, at 9:25 PM, Tony Weeg wrote: am using sql server, I have aqua data studio, im using query analyzer right now... I don't have any other way of getting to the count, that's the problem there isnt anything else in the vehicle table that links back to the company table that has the guid that links back to the crm system, and its guid for the company, and then the order based on the account number, and the sales order details, based on the sales order number. maybe I just cant do it with the current table layout. its like, the first part of the query is locking the result set in regardless of what else matches... heck...ill try your plan, its how I built the thing in the first place tho'cause that's how I trouble shoot too :( so maybe again might work, ill try it again. is there any reason that the first join would be sooo commanding in regard to its relentless match regardless of the where clause? That's an interesting question -- an inner join is supposed to return something if both side of the join are present - so what happens if the first joins matches and the others don't -- do you have a match or not--- hmmm Unfortunately I don't have a db handy with enough relationships that I can experiment with -- I have Sybase_ASE running on my Mac for complex dbs -- common ancestry with SQL-Server. Another option is to put the tests in the where clause with AND operators Dick tony -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED] Sent: Friday, May 07, 2004 12:22 AM To: CF-Talk Subject: Re: query question What usually helps me in a case like this is to simplify the query (if you can). 1) Take out all the joins 2) add them back one at a time Kinda' build the complex query in a series of simple steps.. Do you have a interactive SQL client that you can use to do this? It looks like you are using SQL-Server, No? Dick On May 6, 2004, at 8:59 PM, Tony Weeg wrote: ok, I did this. I get everything different, but the id number from the table where the count comes from, the id number of the 1 vehicle that is in there...it has a different productId, I see the two different productId's, it has a different salesOrderDEtailId, they both have the same salesOrderId...this isnt making sense hmmm tony [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: UDF in Component?
Oh - no - that's wrong. :) You can't define a UDF in a UDF, or method in a method, or etc. Simply move the cfscript block outside the cffunction declaration. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Pages not showing in mx
I just set up a test mx box with a FB3 application. Used the analyzer to check my cf5 pages- all came up clean However, the browser is blank when I call the pages. Any ideas of what I missed when I did the setup? Thanks, J [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
cffile upload question
Hello Everybody, I am working on a application to upload attachments/files to the server using cffile. The interface is designed to allow the user to select one or more files to attach through a pop-up window. I am passing the list of files along with the complete file path the user has selected back to the parent window. To explain this further, the pop-up window has a form with the input type 'file' formfield and hidden variable that stores a comma separted list of all the file paths the user wishes to upload. On the parent window, I'm looping through this list and trying to upload the files one by one. I get an error. Here is the code: cfset MimeTypes = text/html,application/vnd.ms-powerpoint,application/vnd.ms-project,application/pdf,application/msword,application/vnd.ms-excel,application/x-zip-compressed,image/jpeg,image/gif,application/x-visio,application/drafting,model/vnd.dwf,image/x-dwg,application/dxf,application/x-excel,application/rtf,text/plain cfloop list=lFilesToUpload index=fUpload cffile action=""> filefield=#fUpload# destination=#request.BlobDir# nameconflict=MAKEUNIQUE accept=#MimeTypes# /cfloop This is the error I get. Invalid content type: application/x-www-form-urlencoded. I don't have that mime type in my code I think the error is caused because the filefield cffile attribute expects a form input variable? Can I not pass this attribute any variable name or in this case list item name? Can someone please show me how to get round this problem Best Regards, cfcoder __ Do you Yahoo!? Win a $20,000 Career Makeover at Yahoo! HotJobs http://hotjobs.sweepstakes.yahoo.com/careermakeover [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Pages not showing in mx
Is there anything in the source? John -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED] Sent: Friday, May 07, 2004 9:57 AM To: CF-Talk Subject: Pages not showing in mx I just set up a test mx box with a FB3 application. Used the analyzer to check my cf5 pages- all came up clean However, the browser is blank when I call the pages. Any ideas of what I missed when I did the setup? Thanks, J [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: cffile upload question
I addedenctype=multipart/form-data on the parent form window, I now get a different error. The form field C:\Documents and Settings\assets.txt did not contain a file Hello Everybody, I am working on a application to upload attachments/files to the server using cffile. The interface is designed to allow the user to select one or more files to attach through a pop-up window. I am passing the list of files along with the complete file path the user has selected back to the parent window. To explain this further, the pop-up window has a form with the input type 'file' formfield and hidden variable that stores a comma separted list of all the file paths the user wishes to upload. On the parent window, I'm looping through this list and trying to upload the files one by one. I get an error. Here is the code: cfset MimeTypes = text/html,application/vnd.ms-powerpoint,application/vnd.ms-project, application/pdf,application/msword,application/vnd.ms-excel, application/x-zip-compressed,image/jpeg,image/gif,application/x-visio, application/drafting,model/vnd.dwf,image/x-dwg,application/dxf, application/x-excel,application/rtf,text/plain cfloop list=lFilesToUpload index=fUpload cffile action=""> filefield=#fUpload# destination=#request.BlobDir# nameconflict=MAKEUNIQUE accept=#MimeTypes# /cfloop This is the error I get. Invalid content type: application/x-www-form-urlencoded. I don't have that mime type in my code I think the error is caused because the filefield cffile attribute expects a form input variable? Can I not pass this attribute any variable name or in this case list item name? Can someone please show me how to get round this problem Best Regards, cfcoder __ Do you Yahoo!? Win a $20,000 Career Makeover at Yahoo! HotJobs http://hotjobs.sweepstakes.yahoo.com/careermakeover [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: UDF in Component?
Ray, Thanks for the info.That fixed it. :-) John -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Friday, May 07, 2004 9:50 AM To: CF-Talk Subject: RE: UDF in Component? Oh - no - that's wrong. :) You can't define a UDF in a UDF, or method in a method, or etc. Simply move the cfscript block outside the cffunction declaration. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Pages not showing in mx
From: Janine Jakim I just set up a test mx box with a FB3 application. Used the analyzer to check my cf5 pages- all came up clean However, the browser is blank when I call the pages. Any ideas of what I missed when I did the setup? Thanks, J When you View Source, is it completely blank? If you turn on debugging, what does it give you? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Email Problem
John, I just spoke the email support guys here and this is what they told me: Our Exchange IMC's Strip it.. Only email sent directly from Outlook and do it - Email from apps cannotThere is a way to do it but they will not tell. Mario -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Thursday, May 06, 2004 5:35 PM To: CF-Talk Subject: RE: Email Problem Essentially set the X-Mailer using cfmailparamLook at the headers on an email that works correctly.Whatever headers you see in there that are different from the one you send using CF, set (or change) the params using cfmailparam.Now, some spam filters or mail clients are smart enough to ignore certain headers that exist without other headers. That's why I recommend trying to create an email sent from CF that looks exactly the same as the email sent from outlook (minus the message ID and other unique features) John Burns -Original Message- From: Ciliotta, Mario [mailto:[EMAIL PROTECTED] Sent: Thursday, May 06, 2004 4:19 PM To: CF-Talk Subject: RE: Email Problem How do you trick it to think Outlook was the sender??? Mario -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Thursday, May 06, 2004 3:19 PM To: CF-Talk Subject: RE: Email Problem You can change it so that outlook thinks that the sender was outlook and not CF.That would fix that.That's why I suggested to try to set all of the mail params that you see in a normal outlook message that works properly. John -Original Message- From: Ciliotta, Mario [mailto:[EMAIL PROTECTED] Sent: Thursday, May 06, 2004 2:56 PM To: CF-Talk Subject: RE: Email Problem Mine seems to be the same. Could it be an Outlook setting:If I send the email thru Outlook to myself, I will receive all the receipts but if I send it thru CF, I only get the delivered receipt, no read or deleted receipt. We do not get read receipts automatically.We must manually ask for one when sending messages via Outlook. Mario -Original Message- From: Lofback, Chris [mailto:[EMAIL PROTECTED] Sent: Thursday, May 06, 2004 2:48 PM To: CF-Talk Subject: RE: Email Problem Were you prompted for a return receipt or by chance do you have return receipts automatically generated? There was no prompt.We do not get read receipts automatically.We must manually ask for one when sending messages via Outlook. Chris _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Pages not showing in mx
the view source comes up blank.So I'm missing what? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Email Problem
napoleon complex. mr small penis man... mr nazi sysadmin wow...arent geeks with ego issues GREAT! -Original Message- From: Ciliotta, Mario [mailto:[EMAIL PROTECTED] Sent: Friday, May 07, 2004 10:52 AM To: CF-Talk Subject: RE: Email Problem John, I just spoke the email support guys here and this is what they told me: Our Exchange IMC's Strip it.. Only email sent directly from Outlook and do it - Email from apps cannotThere is a way to do it but they will not tell. Mario -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Thursday, May 06, 2004 5:35 PM To: CF-Talk Subject: RE: Email Problem Essentially set the X-Mailer using cfmailparamLook at the headers on an email that works correctly.Whatever headers you see in there that are different from the one you send using CF, set (or change) the params using cfmailparam.Now, some spam filters or mail clients are smart enough to ignore certain headers that exist without other headers. That's why I recommend trying to create an email sent from CF that looks exactly the same as the email sent from outlook (minus the message ID and other unique features) John Burns -Original Message- From: Ciliotta, Mario [mailto:[EMAIL PROTECTED] Sent: Thursday, May 06, 2004 4:19 PM To: CF-Talk Subject: RE: Email Problem How do you trick it to think Outlook was the sender??? Mario -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Thursday, May 06, 2004 3:19 PM To: CF-Talk Subject: RE: Email Problem You can change it so that outlook thinks that the sender was outlook and not CF.That would fix that.That's why I suggested to try to set all of the mail params that you see in a normal outlook message that works properly. John -Original Message- From: Ciliotta, Mario [mailto:[EMAIL PROTECTED] Sent: Thursday, May 06, 2004 2:56 PM To: CF-Talk Subject: RE: Email Problem Mine seems to be the same. Could it be an Outlook setting:If I send the email thru Outlook to myself, I will receive all the receipts but if I send it thru CF, I only get the delivered receipt, no read or deleted receipt. We do not get read receipts automatically.We must manually ask for one when sending messages via Outlook. Mario -Original Message- From: Lofback, Chris [mailto:[EMAIL PROTECTED] Sent: Thursday, May 06, 2004 2:48 PM To: CF-Talk Subject: RE: Email Problem Were you prompted for a return receipt or by chance do you have return receipts automatically generated? There was no prompt.We do not get read receipts automatically.We must manually ask for one when sending messages via Outlook. Chris _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Coldfusion and XML
On Friday 07 May 2004 14:37 pm, Tony Weeg wrote: look @ cfsavecontent to create the xml. Why not use the proper XML types and functions CF gives you ? -- 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: Email Problem
Are you saying Exchange strips the X-Mailer attribute?If you set the X-Mailer attribute to spoof outlook, then wouldn't it allow it? John -Original Message- From: Ciliotta, Mario [mailto:[EMAIL PROTECTED] Sent: Friday, May 07, 2004 10:52 AM To: CF-Talk Subject: RE: Email Problem John, I just spoke the email support guys here and this is what they told me: Our Exchange IMC's Strip it.. Only email sent directly from Outlook and do it - Email from apps cannotThere is a way to do it but they will not tell. Mario -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Thursday, May 06, 2004 5:35 PM To: CF-Talk Subject: RE: Email Problem Essentially set the X-Mailer using cfmailparamLook at the headers on an email that works correctly.Whatever headers you see in there that are different from the one you send using CF, set (or change) the params using cfmailparam.Now, some spam filters or mail clients are smart enough to ignore certain headers that exist without other headers. That's why I recommend trying to create an email sent from CF that looks exactly the same as the email sent from outlook (minus the message ID and other unique features) John Burns -Original Message- From: Ciliotta, Mario [mailto:[EMAIL PROTECTED] Sent: Thursday, May 06, 2004 4:19 PM To: CF-Talk Subject: RE: Email Problem How do you trick it to think Outlook was the sender??? Mario -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Thursday, May 06, 2004 3:19 PM To: CF-Talk Subject: RE: Email Problem You can change it so that outlook thinks that the sender was outlook and not CF.That would fix that.That's why I suggested to try to set all of the mail params that you see in a normal outlook message that works properly. John -Original Message- From: Ciliotta, Mario [mailto:[EMAIL PROTECTED] Sent: Thursday, May 06, 2004 2:56 PM To: CF-Talk Subject: RE: Email Problem Mine seems to be the same. Could it be an Outlook setting:If I send the email thru Outlook to myself, I will receive all the receipts but if I send it thru CF, I only get the delivered receipt, no read or deleted receipt. We do not get read receipts automatically.We must manually ask for one when sending messages via Outlook. Mario -Original Message- From: Lofback, Chris [mailto:[EMAIL PROTECTED] Sent: Thursday, May 06, 2004 2:48 PM To: CF-Talk Subject: RE: Email Problem Were you prompted for a return receipt or by chance do you have return receipts automatically generated? There was no prompt.We do not get read receipts automatically.We must manually ask for one when sending messages via Outlook. Chris _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Pages not showing in mx
Sounds like you're missing code. :-)Sorry, not sure what would cause that.Have you tried setting up a simple test.cfm to see if that would pull down? John -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, May 07, 2004 10:55 AM To: CF-Talk Subject: Re: Pages not showing in mx the view source comes up blank.So I'm missing what? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Email Problem
I just spoke the email support guys here and this is what they told me: Our Exchange IMC's Strip it.. Only email sent directly from Outlook and do it - Email from apps cannotThere is a way to do it but they will not tell. napoleon complex. mr small penis man... mr nazi sysadmin wow...arent geeks with ego issues GREAT! Or, maybe, they're just doing their jobs. It's not that uncommon to configure mail servers this way, actually. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Email Problem
I just spoke the email support guys here and this is what they told me: Our Exchange IMC's Strip it.. Only email sent directly from Outlook and do it - Email from apps cannotThere is a way to do it but they will not tell. If they're stripping out these headers at the IMC, this wouldn't affect Outlook clients connecting directly to Exchange. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: http compression
On Friday 07 May 2004 12:33 pm, Hugo Ahlenius wrote: How much would that impact the server load? Not alot. Maybe some more memory will be used, but your CPU usage will be about the same. You may even benifit by having Apache serve your none CFML files. -- 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: http compression
Thanks for the input, I might give it a try (later, when I have more time). Interesting that no-one on this list seems interested in this (very few comments on my inquiry!). My other option that I was looking at was servlet filters: http://www.onjava.com/pub/a/onjava/2003/11/19/filters.html -- Hugo Ahlenius - 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: Thomas Chiverton [mailto:[EMAIL PROTECTED] | Sent: Friday, May 07, 2004 17:04 | To: CF-Talk | Subject: Re: http compression | | On Friday 07 May 2004 12:33 pm, Hugo Ahlenius wrote: | How much would that impact the server load? | | Not alot. | Maybe some more memory will be used, but your CPU usage will | be about the same. | You may even benifit by having Apache serve your none CFML files. | | -- | 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: Email Problem
It tried to change the X-Mailer ID but if I look at the headers I see this: X-Mailer: ColdFusion MX Application Server X-Mailer: Microsoft Outlook 8.5, Build 4.71.2377.0 X-Mailer: Microsoft Outlook 8.5, Build 4.71.2377.0 I was able to change it but it still sets the Xmailer as CFMX application server first - so it is stripped.THe Outlook version is just a guess we use 9.0 (2000).Is there anyway to force the CFMX Application Server not to show? Here is my code used: cfmail to= [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] from=Mario [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] subject=RE: Question about email headers SERVER=x cfmailParam name=Reply-To value= [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] cfmailparam name=Read-Receipt-To value= [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] cfmailparam name=Disposition-Notification-To value= [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] cfmailParam name=X-Priority value=1 cfmailParam name=X-Mailer value=Microsoft Outlook 8.5, Build 4.71.2377.0 cfmailParam name=Mailerid value=Microsoft Outlook 8.5, Build 4.71.2377.0 cfmailparam name=Return-Receipt-To value= [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] I tried all the code but I still not read or delete receipt, but I did get the delievered receipt. I'll try researching more on the web and ask a few other programmers that I know if they can try it on the systems. I sent this to you from Cold Fusion, just to see if maybe it might be that I am trying to send everything to myself. Thanks for the help. Mario /cfmail -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Friday, May 07, 2004 11:08 AM To: CF-Talk Subject: RE: Email Problem I just spoke the email support guys here and this is what they told me: Our Exchange IMC's Strip it.. Only email sent directly from Outlook and do it - Email from apps cannotThere is a way to do it but they will not tell. If they're stripping out these headers at the IMC, this wouldn't affect Outlook clients connecting directly to Exchange. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Pages not showing in mx
Check your root index.cfm, the index.cfm included in demo apps and downloads attempted to determine what version of CF you're using - CF600 didn't exist when fb3 was first released. Cfinclude the CF5 corefile directly and you should see something, John. -Original Message- From: Janine Jakim [mailto:[EMAIL PROTECTED] Sent: 07 May 2004 14:57 To: CF-Talk Subject: Pages not showing in mx I just set up a test mx box with a FB3 application. Used the analyzer to check my cf5 pages- all came up clean However, the browser is blank when I call the pages. Any ideas of what I missed when I did the setup? Thanks, J [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Pages not showing in mx-Is there a new FB pg?
When I run the debug I see that it goes through the pages and then says startup, parsing, compiling, loading shutdown That happens right after it goes through my page that holds the fb logic on which pages to use. This is the last page that's processed.Has this page been changed for mx? is that the prob? cflock type=READONLY name=#server.coldfusion.productVersion# timeout=10 cfset variables.fuseboxVersion=Replace(Replace(ListDeleteAt(server.coldfusion.productVersion,4)all), ,,all) cfset variables.fuseboxOSName=server.os.name /cflock cfif variables.fuseboxVersion lt 450 cfinclude template=fbx_fusebox30_CF40.cfm cfelseif variables.fuseboxVersion lt 500 cfif variables.fuseboxOSName contains Windows cfinclude template=fbx_fusebox30_CF45.cfm cfelse cfinclude template=fbx_fusebox30_CF45_nix.cfm /cfif cfelseif variables.fuseboxVersion lt 600 cfif variables.fuseboxOSName contains Windows cfinclude template=fbx_fusebox30_CF50.cfm cfelse cfinclude template=fbx_fusebox30_CF50_nix.cfm /cfif /cfif [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: cffile upload question
can somebody please help! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Pages not showing in mx-Is there a new FB pg?
As per my reply in your other thread, you need to either change the cfelseif to (notice LESS THAN EQUAL 600): cfelseif variables.fuseboxVersion lte 600 cfif variables.fuseboxOSName contains Windows cfinclude template=fbx_fusebox30_CF50.cfm cfelse cfinclude template=fbx_fusebox30_CF50_nix.cfm /cfif /cfif Or cfinclude the corefile directly, John. -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 07 May 2004 16:31 To: CF-Talk Subject: Re: Pages not showing in mx-Is there a new FB pg? When I run the debug I see that it goes through the pages and then says startup, parsing, compiling, loading shutdown That happens right after it goes through my page that holds the fb logic on which pages to use. This is the last page that's processed.Has this page been changed for mx? is that the prob? cflock type=READONLY name=#server.coldfusion.productVersion# timeout=10 cfset variables.fuseboxVersion=Replace(Replace(ListDeleteAt(server.coldfusion.prod uctVersion,4)all), ,,all) cfset variables.fuseboxOSName=server.os.name /cflock cfif variables.fuseboxVersion lt 450 cfinclude template=fbx_fusebox30_CF40.cfm cfelseif variables.fuseboxVersion lt 500 cfif variables.fuseboxOSName contains Windows cfinclude template=fbx_fusebox30_CF45.cfm cfelse cfinclude template=fbx_fusebox30_CF45_nix.cfm /cfif cfelseif variables.fuseboxVersion lt 600 cfif variables.fuseboxOSName contains Windows cfinclude template=fbx_fusebox30_CF50.cfm cfelse cfinclude template=fbx_fusebox30_CF50_nix.cfm /cfif /cfif [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Having a problem using cfstoredproc
Hi all...This is my first time using a stored procedure.I am getting this error [Macromedia][Oracle JDBC Driver]Incorrect parameter bindings for stored procedure call. Check your bindings against the stored procedure's parameters. Here is my code cfstoredproc procedure=class_user_maint.in_grace datasource=#dsn# returncode=yes cfprocparam type=In cfsqltype=CF_SQL_VARCHAR value=#session.user# null=no cfprocparam type=Out cfsqltype=CF_SQL_VARCHAR variable=Grace null=no cfprocparam type=Out cfsqltype=CF_SQL_INTEGER variable=TheDays null=no /cfstoredproc And here is the SQL package with the stored procedure (it is the in_grace one) /* Formatted on 2004/05/06 14:59 (Formatter Plus v4.8.0) */ CREATE OR REPLACE PACKAGE class_user_maint IS PROCEDURE change_password ( i_user IN VARCHAR2, i_passwordIN VARCHAR2, o_msgOUTVARCHAR2 ); PROCEDURE in_grace ( i_user IN VARCHAR2, o_graceOUTVARCHAR2, o_days OUTNUMBER ); FUNCTION session_exists (i_user IN VARCHAR2) RETURN VARCHAR2; END class_user_maint; / Can someone please help me figure out what I need to do to get this to work? Thank you very much. Brian Yager [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
ColdFusion TechNote Notification: ColdFusion MX 6.1: Hot Fix for duplicate, GetHTTPRequestData and DateDiff functions
Check out theupdatedTechNote at: http://www.macromedia.com/support/coldfusion/ts/documents/duplicate_hotfix.htm * http://www.macromedia.com/support/coldfusion/ts/documents/tn17883.htm *Added bugs 55054 and 55306 to list, and replaced download with new version of hot fix [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Pages not showing in mx
Have a look at what the index.cfm says - some example FB3 applications had checks on the version of CF running, and included the relevant core file, but if it was written before MX (version 6) then it might not bother to include anything. AFAIK, the CF5 version core (fbx_fusebox30_CF50[_nix].cfm) will work fine on MX, so unless you're planning on flipping your code between CF versions i'd dump the conditional stuff and just: cfinclude template=fbx_fusebox30_CF50.cfm (or cfinclude template=fbx_fusebox30_CF50_nix.cfm) HTH Bert From: Janine Jakim [mailto:[EMAIL PROTECTED] Sent: 07 May 2004 14:57 To: CF-Talk Subject: Pages not showing in mx I just set up a test mx box with a FB3 application. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Verity options
Another question I'm wrestling with. The robots.txt should solve one of my issues, I'll test that today. What about modifying the collection? Vspider has to spider localhost so I need to modify the keys to reflect our production server address. I can't seem to get it to do it. Do I need to stop the K2 to modify as well? J. _ From: John Wilker [mailto:[EMAIL PROTECTED] Sent: Thursday, May 06, 2004 1:54 PM To: CF-Talk Subject: RE: Verity options mmm I'm not sure. I would suppose it would respect robots.txtI hadn't even thought of that. Thanks! I'll try that. _ From: Jerry Johnson [mailto:[EMAIL PROTECTED] Sent: Thursday, May 06, 2004 1:52 PM To: CF-Talk Subject: Re: Verity options I know very little about the vspider, but... Doesn't it respect robots.txt files? If you properly build your robots.txt files, you should be able to automatically exclude the files and folders you don't want indexed. Just a thought, Jerry Johnson _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Pages not showing in mx
Ok I'm getting closerNow I have an error tag for the cfswitch tag in my fbx_switch file.Where I start the switch cfswitch _expression_=#fusebox.fuseaction# I've looked in all the fbx files/application/etc looking for some variable that needs changed, but no luck. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Verity options
I am not sure if it is better to modify the keys in the collection, or just adjust them while outputting to the screen. I have been handling final tweaks to the URL on the display page after getting the results but before displaying them. I also handle sorting and grouping in this step. Jerry Johnson [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: ColdFusion TechNote Notification: ColdFusion MX 6.1: Hot Fix for duplicate, GetHTTPRequestData and DateDiff functions
Hey Mike, did you make this automatic? That would be neeto! ;-) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Email Problem
Mario, Instead of setting the X-Mailer header via cfmailparam, just use the mailerID attribute of the cfmail tag.That should stop the X-Mailer as showing up as ColdFusion Application Server. On another note, I did a quick test and my firewall is in fact set to strip out a LOT of mail headers by default, one of which is Disposition-Notification-To.Sending through my home email account, the read receipt came through fine (just tested in Outlook, not in CFMX). Outlook never specified a header in regards to the return receipt other than the one I just mentioned.Return-Receipt-To was never placed in the header. Andy -Original Message- From: Ciliotta, Mario [mailto:[EMAIL PROTECTED] Sent: Friday, May 07, 2004 11:12 AM To: CF-Talk Subject: RE: Email Problem It tried to change the X-Mailer ID but if I look at the headers I see this: X-Mailer: ColdFusion MX Application Server X-Mailer: Microsoft Outlook 8.5, Build 4.71.2377.0 X-Mailer: Microsoft Outlook 8.5, Build 4.71.2377.0 I was able to change it but it still sets the Xmailer as CFMX application server first - so it is stripped.THe Outlook version is just a guess we use 9.0 (2000).Is there anyway to force the CFMX Application Server not to show? Here is my code used: cfmail to= [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] from=Mario [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] subject=RE: Question about email headers SERVER=x cfmailParam name=Reply-To value= [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] cfmailparam name=Read-Receipt-To value= [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] cfmailparam name=Disposition-Notification-To value= [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] cfmailParam name=X-Priority value=1 cfmailParam name=X-Mailer value=Microsoft Outlook 8.5, Build 4.71.2377.0 cfmailParam name=Mailerid value=Microsoft Outlook 8.5, Build 4.71.2377.0 cfmailparam name=Return-Receipt-To value= [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] I tried all the code but I still not read or delete receipt, but I did get the delievered receipt. I'll try researching more on the web and ask a few other programmers that I know if they can try it on the systems. I sent this to you from Cold Fusion, just to see if maybe it might be that I am trying to send everything to myself. Thanks for the help. Mario /cfmail [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
How to initiate download dialog when downloading .jpg files?
I¹m sure there¹s an easy way to do this, but I don¹t know what it is. I want the ³Save As² dialog box to open when a link to an image file is clicked on. Right now (as I¹m sure you are familiar with) it displays the image in the browser window rather than opening the ³Save As² dialog. Any help would be much appreciated. BZaccheo [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: How to initiate download dialog when downloading .jpg files?
http://www.cfm-applications.com/expressive_v1_b2/index.cfm?entryID=2055 I want the ³Save As² dialog box to open when a link to an image file is clicked on. Right now (as I¹m sure you are familiar with) it displays the image in the browser window rather than opening the ³Save As² dialog. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Pages not showing in mx
hmm and when I add a simple ending to the default page ie: index.cfm?fa=con.Main the page comes up blank but all the source code is there. No errors on the debugging page. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
schedule admin and SSL
Hi All, I try to schedule a cfm page in cfadmin on a web server which has ssl. I even use port 443 with no success. Any help would be appreciated. TIA, Patrick Whittingham United Space Alliance AES - Data Warehouse _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: ColdFusion TechNote Notification: ColdFusion MX 6.1: Hot Fix for duplicate, GetHTTPRequestData and DateDiff functions
I'll do it. I'll set up an announcements list and have the tech notes, security fixes and such posted to it automatically. This will allow people to get the important stuff without having it buried under other CF-Talk posts. Hey Mike, did you make this automatic? That would be neeto! ;-) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Coldfusion and XML
Thanks for the tips so far Can this be done using CF5 as opposed to MX? Thanks, Dave -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: 07 May 2004 15:55 To: CF-Talk Subject: Re: Coldfusion and XML On Friday 07 May 2004 14:37 pm, Tony Weeg wrote: look @ cfsavecontent to create the xml. Why not use the proper XML types and functions CF gives you ? -- 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: Coldfusion and XML
Can this be done using CF5 as opposed to MX? You can generate XML with CF 5 by either generating raw text that happens to be well-formed XML, or by using a third-party XML parser to generate XML for you. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: cffile upload question
I'll try and explain this better. I have a form on the main page. The form has a button that opens up a pop-up window. The pop-up window has the input type 'file' field. I have added code to allow users add more than one file at a time. I am not uploading the file to the server at this stage. Instead I am passing the list of files selected along with the complete file path back to the parent window. The parent window has a submit button. When the user hits on submit. I am looping through the list containing the file paths and want to upload them one by one to the server using the cffile tag. Here is the code cfif isDefined(form.submit) cfparam name=finalFilePathList default= cfloop list=#form.hid_attachedFilesPath# index=lFilePath cfset lFilesToUpload = ListAppend(lFilesToUpload,lFilePath) /cfif cfloop list=#lFilesToUpload# index=fUpload cffile action="" filefield=#fUpload# destination=#request.BlobDir# nameconflict=MAKEUNIQUE accept=#MimeTypes# /cfloop Hope this gives you a better idea. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: ColdFusion TechNote Notification: ColdFusion MX 6.1: Hot Fix for duplicate, GetHTTPRequestData and DateDiff functions
Who da man? Mike? Yep! Michael Dinowitz wrote: I'll do it. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: ColdFusion TechNote Notification: ColdFusion MX 6.1: Hot Fix for duplicate, GetHTTPRequestData and DateDiff functions
Mike that would be awesome!!! Would that list work just like any other semi - open list on HOF?Or would you be the only one to post to it? Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 _ From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: Friday, May 07, 2004 11:32 AM To: CF-Talk Subject: Re: ColdFusion TechNote Notification: ColdFusion MX 6.1: Hot Fix for duplicate, GetHTTPRequestData and DateDiff functions I'll do it. I'll set up an announcements list and have the tech notes, security fixes and such posted to it automatically. This will allow people to get the important stuff without having it buried under other CF-Talk posts. Hey Mike, did you make this automatic? That would be neeto! ;-) _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: cffile upload question
can I create form field on the server? something like this. cfif isDefined(form.submit) cfparam name=finalFilePathList default= cfset count = 1 cfloop list=#form.hid_attachedFilesPath# index=lFilePath cfset lFilesToUpload = ListAppend(lFilesToUpload,lFilePath) ! SOMETHING LIKE THIS cfoutputinput type=file id=fileToUpload_#count# name=fileToUpload_#count# value=#lFilePath#/cfoutput cfset count = count + 1 /cfloop cfset posn = 1 cfloop list=#lFilesToUpload# index=fUpload cffile action=""> filefield=form.fileToUpload_#posn# destination=#request.BlobsDir# nameconflict=MAKEUNIQUE accept=#fileMimeTypes# cfset posn = posn + 1 /cfloop Is this possible? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: ColdFusion TechNote Notification: ColdFusion MX 6.1: Hot Fix for duplicate, GetHTTPRequestData and DateDiff functions
Can you set it up to send to CF-Talk as well?Seems like that's definitely on-topic. Cheers, barneyb -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: Friday, May 07, 2004 9:32 AM To: CF-Talk Subject: Re: ColdFusion TechNote Notification: ColdFusion MX 6.1: Hot Fix for duplicate, GetHTTPRequestData and DateDiff functions I'll do it. I'll set up an announcements list and have the tech notes, security fixes and such posted to it automatically. This will allow people to get the important stuff without having it buried under other CF-Talk posts. Hey Mike, did you make this automatic? That would be neeto! ;-) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: ColdFusion TechNote Notification: ColdFusion MX 6.1: Hot Fix for duplicate, GetHTTPRequestData and DateDiff functions
I would think that having it read only with a limited range of posters would be best. If you have a reason for something different, let me know. -- Michael Dinowitz House of Fusion http://www.houseoffusion.com Finding technical solutions to the problems you didn't know you had yet Mike that would be awesome!!! Would that list work just like any other semi - open list on HOF?Or would you be the only one to post to it? I'll do it. I'll set up an announcements list and have the tech notes, security fixes and such posted to it automatically. This will allow people to get the important stuff without having it buried under other CF-Talk posts. Hey Mike, did you make this automatic? That would be neeto! ;-) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: ColdFusion TechNote Notification: ColdFusion MX 6.1: Hot Fix for duplicate, GetHTTPRequestData and DateDiff functions
I assume that the announcements would be CF only and not M$ or *nix related security / technotes. (I would love to see a list for server and all security / technote issues related to CF server,IIS, apache, SQL, Win OS, *nix OS. ) Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 _ From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: Friday, May 07, 2004 11:48 AM To: CF-Talk Subject: RE: ColdFusion TechNote Notification: ColdFusion MX 6.1: Hot Fix for duplicate, GetHTTPRequestData and DateDiff functions Mike that would be awesome!!! Would that list work just like any other semi - open list on HOF?Or would you be the only one to post to it? Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 _ From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: Friday, May 07, 2004 11:32 AM To: CF-Talk Subject: Re: ColdFusion TechNote Notification: ColdFusion MX 6.1: Hot Fix for duplicate, GetHTTPRequestData and DateDiff functions I'll do it. I'll set up an announcements list and have the tech notes, security fixes and such posted to it automatically. This will allow people to get the important stuff without having it buried under other CF-Talk posts. Hey Mike, did you make this automatic? That would be neeto! ;-) _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Verity options
that's not a bad idea. Thanks Jerry, much obliged! _ From: Jerry Johnson [mailto:[EMAIL PROTECTED] Sent: Friday, May 07, 2004 9:04 AM To: CF-Talk Subject: RE: Verity options I am not sure if it is better to modify the keys in the collection, or just adjust them while outputting to the screen. I have been handling final tweaks to the URL on the display page after getting the results but before displaying them. I also handle sorting and grouping in this step. Jerry Johnson _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: ColdFusion TechNote Notification: ColdFusion MX 6.1: Hot Fix for duplicate, GetHTTPRequestData and DateDiff functions
Let me rephrase that a little bit. I would love to see a list for security / technote issues *directly* related to CF servers. i.e.IIS, apache, SQL, Win OS, *nix OS. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 _ From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: Friday, May 07, 2004 12:04 PM To: CF-Talk Subject: RE: ColdFusion TechNote Notification: ColdFusion MX 6.1: Hot Fix for duplicate, GetHTTPRequestData and DateDiff functions I assume that the announcements would be CF only and not M$ or *nix related security / technotes. (I would love to see a list for server and all security / technote issues related to CF server,IIS, apache, SQL, Win OS, *nix OS. ) Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 _ From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: Friday, May 07, 2004 11:48 AM To: CF-Talk Subject: RE: ColdFusion TechNote Notification: ColdFusion MX 6.1: Hot Fix for duplicate, GetHTTPRequestData and DateDiff functions Mike that would be awesome!!! Would that list work just like any other semi - open list on HOF?Or would you be the only one to post to it? Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 _ From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: Friday, May 07, 2004 11:32 AM To: CF-Talk Subject: Re: ColdFusion TechNote Notification: ColdFusion MX 6.1: Hot Fix for duplicate, GetHTTPRequestData and DateDiff functions I'll do it. I'll set up an announcements list and have the tech notes, security fixes and such posted to it automatically. This will allow people to get the important stuff without having it buried under other CF-Talk posts. Hey Mike, did you make this automatic? That would be neeto! ;-) _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: ColdFusion TechNote Notification: ColdFusion MX 6.1: Hot Fix for duplicate, GetHTTPRequestData and DateDiff functions
It's funny how many people are looking for an easy way to be notified about Technotes! Too bad MM is not interested in provided a mechanism for us to do so. It would be beyond cool if MM would provide the Technotes and Security Updates via RSS IMHO. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: ColdFusion TechNote Notification: ColdFusion MX 6.1: Hot Fix for duplicate, GetHTTPRequestData and DateDiff functions
It's funny how many people are looking for an easy way to be notified about Technotes! Too bad MM is not interested in provided a mechanism for us to do so. It would be beyond cool if MM would provide the Technotes and Security Updates via RSS IMHO. Um: http://www.markme.com/mxna/blogview.cfm?blogid=23 The problem with the feed is that it doesn't get re-published if a TechNote is updated (such as this Duplicate() note). Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: ColdFusion TechNote Notification: ColdFusion MX 6.1: Hot Fix for duplicate, GetHTTPRequestData and DateDiff functions
Hi Bryan, We've had discussions about this internally and I'll be sure to pass on this request for you! Christine -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] Sent: Friday, May 07, 2004 1:11 PM To: CF-Talk Subject: Re: ColdFusion TechNote Notification: ColdFusion MX 6.1: Hot Fix for duplicate, GetHTTPRequestData and DateDiff functions It's funny how many people are looking for an easy way to be notified about Technotes! Too bad MM is not interested in provided a mechanism for us to do so. It would be beyond cool if MM would provide the Technotes and Security Updates via RSS IMHO. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: ColdFusion TechNote Notification: ColdFusion MX 6.1: Hot Fix for duplicate, GetHTTPRequestData and DateDiff functions
Sean just said that MM's MXNA blog aggregator probably has the tech notes and security updates on it. As I really don't do the blog thing much, I missed it. -- Michael Dinowitz House of Fusion http://www.houseoffusion.com Finding technical solutions to the problems you didn't know you had yet It's funny how many people are looking for an easy way to be notified about Technotes! Too bad MM is not interested in provided a mechanism for us to do so. It would be beyond cool if MM would provide the Technotes and Security Updates via RSS IMHO. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
cfscript question
If the declaration of variables using var within cfscript isn't necessary, what kind of variables are being created?Are they in the variables scope? For example, the variables 'sdatefmt' and 'edatefmt' in the cf function shown below: function DateRangeFormat(sdate, edate, mask, divider) { if (IsDate(sdate)) sdatefmt = DateFormat(sdate, mask); else sdate = ; if (IsDate(edate)) edatefmt = DateFormat(edate, mask); else edate = ; if (Len(sdatefmt) and Len(edatefmt) and (sdatefmt is not edatefmt)) return sdatefmt divider edatefmt; else if (Len(sdatefmt)) return sdatefmt; else if (Len(edatefmt)) return edatefmt; else return ; } [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: ColdFusion TechNote Notification: ColdFusion MX 6.1: Hot Fix for duplicate, GetHTTPRequestData and DateDiff functions
That's not our problem is it? That's an implementation problem with the their aggregator. By the way, having it on MXNA is ok, but I want the RSS. And I also want the Security Patches to be included. MM thinks the security patches and the technote patches are like the Red Sea when Moses crossed through it for some reason. Dave Carabetta wrote: The problem with the feed is that it doesn't get re-published if a TechNote is updated (such as this Duplicate() note). [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: How to initiate download dialog when downloading .jpg files?
Hey Bryan... I get this error when I try and use the code you provided? I¹m not sure what the problem is... BZaccheo Invalid token apos; apos; found on line 5 at column 1. The CFML compiler was processing: * a cfheader tag beginning on line 4, column 7. * a cfheader tag beginning on line 4, column 7. The error occurred in C:\Domains\edirolextra.com\wwwroot\sitedirector\site\details.cfm: line 5 3 : cftry 4 : cfheader name=content-disposition 5 : value=attachment;filename=#url.image# 6 : cfcontent type=application/unknown 7 : file=#request.siteDirectory##request.delimiter#images#request.del imiter#site_images#request.delimiter##url.image# deletefile=no On 5/7/04 9:09 AM, Bryan F. Hogan [EMAIL PROTECTED] wrote: http://www.cfm-applications.com/expressive_v1_b2/index.cfm?entryID=2055 I want the ³Save As² dialog box to open when a link to an image file is clicked on. Right now (as I¹m sure you are familiar with) it displays the image in the browser window rather than opening the ³Save As² dialog. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: ColdFusion TechNote Notification: ColdFusion MX 6.1: Hot Fix for duplicate, GetHTTPRequestData and DateDiff functions
Thank you! Christine Lawson wrote: We've had discussions about this internally and I'll be sure to pass on this request for you! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: ColdFusion TechNote Notification: ColdFusion MX 6.1: Hot Fix for duplicate, GetHTTPRequestData and DateDiff functions
FYI, MXNA has a web service API that will allow you to do whatever you want with the data. http://www.markme.com/mxna/tools.cfm mike chambers [EMAIL PROTECTED] - Original Message - From: Bryan F. Hogan [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 07, 2004 10:32 AM Subject: Re: ColdFusion TechNote Notification: ColdFusion MX 6.1: Hot Fix for duplicate, GetHTTPRequestData and DateDiff functions That's not our problem is it? That's an implementation problem with the their aggregator. By the way, having it on MXNA is ok, but I want the RSS. And I also want the Security Patches to be included. MM thinks the security patches and the technote patches are like the Red Sea when Moses crossed through it for some reason. Dave Carabetta wrote: The problem with the feed is that it doesn't get re-published if a TechNote is updated (such as this Duplicate() note). _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: cfscript question
Yeah, they're in the VARIABLES scope.There's really no difference between a CFSCRIPT function and a CFFUNCTION one, except that you can use tags, declare named optional arguments and do typechecking with CFFUNCTION.Other than that, I believe the two are 100% equivalent. Cheers, barneyb -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED] Sent: Friday, May 07, 2004 10:33 AM To: CF-Talk Subject: cfscript question If the declaration of variables using var within cfscript isn't necessary, what kind of variables are being created?Are they in the variables scope? For example, the variables 'sdatefmt' and 'edatefmt' in the cf function shown below: function DateRangeFormat(sdate, edate, mask, divider) { if (IsDate(sdate)) sdatefmt = DateFormat(sdate, mask); else sdate = ; if (IsDate(edate)) edatefmt = DateFormat(edate, mask); else edate = ; if (Len(sdatefmt) and Len(edatefmt) and (sdatefmt is not edatefmt)) return sdatefmt divider edatefmt; else if (Len(sdatefmt)) return sdatefmt; else if (Len(edatefmt)) return edatefmt; else return ; } [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: ColdFusion TechNote Notification: ColdFusion MX 6.1: Hot Fix for duplicate, GetHTTPRequestData and DateDiff functions
Great! Now all we need is for it to include the Security Patches and notifications when a previous technote has been updated. Thank You! Mike Chambers wrote: FYI, MXNA has a web service API that will allow you to do whatever you want with the data. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: cfscript question
Yes, the variables are in the variables scope. While it is not necessary to use the var statement, you probably want to for such things as loop counters and other local variables. http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/udfs12.htm http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/udfs12.htm HTH --Nathan From: Jim McAtee [mailto:[EMAIL PROTECTED] Sent: Friday, May 07, 2004 1:33 PM To: CF-Talk Subject: cfscript question If the declaration of variables using var within cfscript isn't necessary, what kind of variables are being created?Are they in the variables scope? For example, the variables 'sdatefmt' and 'edatefmt' in the cf function shown below: function DateRangeFormat(sdate, edate, mask, divider) { if (IsDate(sdate)) sdatefmt = DateFormat(sdate, mask); else sdate = ; if (IsDate(edate)) edatefmt = DateFormat(edate, mask); else edate = ; if (Len(sdatefmt) and Len(edatefmt) and (sdatefmt is not edatefmt)) return sdatefmt divider edatefmt; else if (Len(sdatefmt)) return sdatefmt; else if (Len(edatefmt)) return edatefmt; else return ; } [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: cffile upload question
You can't just pass the full file path in a hidden field then upload the file. I think this is something to do with security... :) If you want to upload multiple files then you'll either need mutliple file fields, or you'll need to upload them sequentially. HTH Bert From: cf coder [mailto:[EMAIL PROTECTED] Sent: 07 May 2004 17:48 To: CF-Talk Subject: Re: cffile upload question I'll try and explain this better. I have a form on the main page. The form has a button that opens up a pop-up window. The pop-up window has the input type 'file' field. I have added code to allow users add more than one file at a time. I am not uploading the file to the server at this stage. Instead I am passing the list of files selected along with the complete file path back to the parent window. The parent window has a submit button. When the user hits on submit. I am looping through the list containing the file paths and want to upload them one by one to the server using the cffile tag. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: ColdFusion TechNote Notification: ColdFusion MX 6.1: Hot Fix for duplicate, GetHTTPRequestData and DateDiff functions
Technotes, technote changes, security released, the tag gallery, new article names/summaries. RSS feeds for these would be a nice start. An RSS feed for the MM forums would be great. As is, I have an agent collecting all the new CF posts and sending them out to TMM members. RSS would save time and energy for all. -- Michael Dinowitz House of Fusion http://www.houseoffusion.com Finding technical solutions to the problems you didn't know you had yet Hi Bryan, We've had discussions about this internally and I'll be sure to pass on this request for you! Christine It's funny how many people are looking for an easy way to be notified about Technotes! Too bad MM is not interested in provided a mechanism for us to do so. It would be beyond cool if MM would provide the Technotes and Security Updates via RSS IMHO. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: cfscript question
What makes you think it is isn't necessary? Any variable created inside a cfscript based function, or a cffunction based function, must be var scoped. Period. (Well, ok, yea, it works w/o the var scope, but leaving them off is very risky.) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: cffile upload question
You don't actually have the files in a file upload formfield if you're just passing the string with the file location to the parent window. You'll need to actually upload the file when you submit the pop-up window. At least upload it somewhere to a temp directory. Then if you want to move them enmasse to another location when you submit the main form you can use cffile or cfftp. Make sense? The 'file' only exists in the form with the file upload formfield. When you submit that form you have the file available to the server (CF). If you don't take advantage of it on that transaction, you lose it. Greg -Original Message- From: cf coder [mailto:[EMAIL PROTECTED] Sent: Friday, May 07, 2004 12:53 PM To: CF-Talk Subject: Re: cffile upload question can I create form field on the server? something like this. cfif isDefined(form.submit) cfparam name=finalFilePathList default= cfset count = 1 cfloop list=#form.hid_attachedFilesPath# index=lFilePath cfset lFilesToUpload = ListAppend(lFilesToUpload,lFilePath) ! SOMETHING LIKE THIS cfoutputinput type=file id=fileToUpload_#count# name=fileToUpload_#count# value=#lFilePath#/cfoutput cfset count = count + 1 /cfloop cfset posn = 1 cfloop list=#lFilesToUpload# index=fUpload cffile action=""> filefield=form.fileToUpload_#posn# destination=#request.BlobsDir# nameconflict=MAKEUNIQUE accept=#fileMimeTypes# cfset posn = posn + 1 /cfloop Is this possible? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: How to initiate download dialog when downloading .jpg files?
What is the value of url.image? Butch Zaccheo wrote: Hey Bryan... I get this error when I try and use the code you provided? I¹m not sure what the problem is... [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: cfscript question
- Original Message - From: Raymond Camden [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 07, 2004 11:49 AM Subject: RE: cfscript question What makes you think it is isn't necessary? Because it isn't.Period. Any variable created inside a cfscript based function, or a cffunction based function, must be var scoped. Period. (Well, ok, yea, it works w/o the var scope, but leaving them off is very risky.) You have to understand _why_ it's risky.Not just it's risky and leave it at that. But it was a simple question.If not declared, in which scope are the variables created? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: How to initiate download dialog when downloading .jpg files?
Actually I figured out the syntax error (strange characters when I pasted content) ... and it seems to be running fine now... but... when I run the script, it just loads the image in the browser window without initiating the dialog box. On 5/7/04 10:59 AM, Bryan F. Hogan [EMAIL PROTECTED] wrote: What is the value of url.image? Butch Zaccheo wrote: Hey Bryan... I get this error when I try and use the code you provided? I¹m not sure what the problem is... [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: cfscript question
What makes you think it is isn't necessary? Because it isn't.Period. I think I was very clear just a few words later that this was just my opinion. Any variable created inside a cfscript based function, or a cffunction based function, must be var scoped. Period. (Well, ok, yea, it works w/o the var scope, but leaving them off is very risky.) You have to understand _why_ it's risky.Not just it's risky and leave it at that. Others had already answered where the variables get declared. I didn't think I had to speak down to him. ;) Point is - as the admin at cflib - I still see many submissions from folks who do not properly scope variables. I have no issue telling people they MUST var scope. Some things are worth being anal/overly strict/etc about. :) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: How to initiate download dialog when downloading .jpg files?
Doing it like below returns the image in the browser? test.cfm a href="" test.jpg/a download.cfm cftry cfheader name=content-disposition value=attachment;filename=#url.image# cfcontent type=application/unknown file=#expandPath('..')'\documents\'url.image# deletefile=no cflocation url="" addtoken=no cfcatch type=any /cfcatch /cftry Butch Zaccheo wrote: when I run the script, it just loads the image in the browser window without initiating the dialog box. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: cfscript question
What makes you think it is isn't necessary? Because it isn't.Period. Required and necessary are two different things.Using 'var' isn't required, but it is definitely necessary, at least in anything approaching normal circumstances. Cheers, barneyb [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: How to initiate download dialog when downloading .jpg files?
I probably should give you a little more info I¹m testing this in IE 5 OSX... It works fine on the pc side but not on the mac side... is there another way of doing this.. maybe with a _javascript_? On 5/7/04 11:11 AM, Bryan F. Hogan [EMAIL PROTECTED] wrote: Doing it like below returns the image in the browser? test.cfm a href="" test.jpg/a download.cfm cftry cfheader name=content-disposition value=attachment;filename=#url.image# cfcontent type=application/unknown file=#expandPath('..')'\documents\'url.image# deletefile=no cflocation url="" addtoken=no cfcatch type=any /cfcatch /cftry Butch Zaccheo wrote: when I run the script, it just loads the image in the browser window without initiating the dialog box. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
createUUID() into sql server uniqueidentifier field
do our cfmx createUUID() uuid's jive with the mssql field/datatype? thanks! ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: createUUID() into sql server uniqueidentifier field
never mind. I figured it out. wasn't the problem. later. its Friday. almost time. later. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Friday, May 07, 2004 2:18 PM To: CF-Talk Subject: createUUID() into sql server uniqueidentifier field do our cfmx createUUID() uuid's jive with the mssql field/datatype? thanks! ...tony tony weeg senior web applications architect navtrak, inc. www.navtrak.net [EMAIL PROTECTED] 410.548.2337 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: How to initiate download dialog when downloading .jpg files?
I don't know of another way. What is needed for this to work is to trick the browser into thinking it is not a known document type. Try this content-type application/x-msdownload or do the google (c) by me ;-) http://www.google.com/search?hl=enie=UTF-8oe=UTF-8q=content-type%2Bmac%2Bie Butch Zaccheo wrote: I probably should give you a little more info I¹m testing this in IE 5 OSX... It works fine on the pc side but not on the mac side... is there another way of doing this.. maybe with a _javascript_? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: createUUID() into sql server uniqueidentifier field
From: Tony Weeg do our cfmx createUUID() uuid's jive with the mssql field/datatype? The UUID and GUID formats are different There are minor changes in the layout and length, enough to make them look completely different [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: createUUID() into sql server uniqueidentifier field
oh. really. so, If I generate one, using createUUID() and try to insert into that type of column in sql server its not going to go in ok? that sucks...no wonder, oh, its micro$oft -Original Message- From: Philip Arnold [mailto:[EMAIL PROTECTED] Sent: Friday, May 07, 2004 2:41 PM To: CF-Talk Subject: RE: createUUID() into sql server uniqueidentifier field From: Tony Weeg do our cfmx createUUID() uuid's jive with the mssql field/datatype? The UUID and GUID formats are different There are minor changes in the layout and length, enough to make them look completely different [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: [cf-talk] Digest Number 84
This is a test.For some reason I can get the CF-TALK emails but my emails never get through so I can't participate.If this is the first one that does get through, my apologies to everyone, but I'm trying to find out where this message goes. Karl S. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: cfscript question
Required and necessary are two different things. In logic terms, they are not. Using 'var' isn't required, but it is definitely necessary, Let's say it's recommended, not required nor necessary, but highly recommended. -- ___ See some cool custom tags here: http://www.contentbox.com/claude/customtags/tagstore.cfm Please send any spam to this address: [EMAIL PROTECTED] Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: createUUID() into sql server uniqueidentifier field
so I guess, now ill use createGUID() from cflib, and that'll reformat it for me thanks! tony -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Friday, May 07, 2004 2:38 PM To: CF-Talk Subject: RE: createUUID() into sql server uniqueidentifier field oh. really. so, If I generate one, using createUUID() and try to insert into that type of column in sql server its not going to go in ok? that sucks...no wonder, oh, its micro$oft -Original Message- From: Philip Arnold [mailto:[EMAIL PROTECTED] Sent: Friday, May 07, 2004 2:41 PM To: CF-Talk Subject: RE: createUUID() into sql server uniqueidentifier field From: Tony Weeg do our cfmx createUUID() uuid's jive with the mssql field/datatype? The UUID and GUID formats are different There are minor changes in the layout and length, enough to make them look completely different [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: createUUID() into sql server uniqueidentifier field
so I guess, now ill use createGUID() from cflib, and that'll reformat it for me You could let the database generate the UUIDs for you, using the NEWID function. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: How to initiate download dialog when downloading .jpg files?
thanx again for the help bryan... I don¹t think there is a clear way to make it work for mac browsers... I¹ll have to try a different route... On 5/7/04 11:24 AM, Bryan F. Hogan [EMAIL PROTECTED] wrote: I don't know of another way. What is needed for this to work is to trick the browser into thinking it is not a known document type. Try this content-type application/x-msdownload or do the google (c) by me ;-) http://www.google.com/search?hl=enie=UTF-8oe=UTF-8q=content-type%2Bmac%2Bie Butch Zaccheo wrote: I probably should give you a little more info I¹m testing this in IE 5 OSX... It works fine on the pc side but not on the mac side... is there another way of doing this.. maybe with a _javascript_? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: ColdFusion TechNote Notification:
An RSS feed for the MM forums would be great. I've got a set of feeds for the CF part of Macromedia's forums, but like my Fusebox forum feeds, they're just titles and links... no content. So they're super-handy if you just want to keep a casual eye on the flow of conversation, but completely useless if you're wanting to read things offline. http://admin.mxblogspace.journurl.com/?mode=articleentry=1741 -- Roger Benningfield work: http://journurl.com/ blog: http://admin.support.journurl.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]