Re: Creating a variable to store information on the fly
try this: cfset SESSION.consumerProductExtraImg[Img i] = filename Fawzi Amadu ha scritto: I am trying to code an application to capture the name of multiple images that are being upload at once. I have created session variables to hold the values, but because I am using a loop to do the process I want to create the set the session variable to store current information on the fly, but I get an error that I suspect is generated because of my assignment code (cfset SESSION.consumerProductExtraImg.Img #i# = #filename#) in my code below: cfset SESSION.consumerProductExtraImg =structNew() !--- collect consumer product details --- !---cfset SESSION.consumerProductExtraImg.userID = --- cfset SESSION.consumerProductExtraImg.Img1 = cfset SESSION.consumerProductExtraImg.Img2 = cfset SESSION.consumerProductExtraImg.Img3 = cfset SESSION.consumerProductExtraImg.Img4 = cfset SESSION.consumerProductExtraImg.Img5 = cfset SESSION.consumerProductExtraImg.Img6 = cfset SESSION.consumerProductExtraImg.Img7 = cfset SESSION.consumerProductExtraImg.Img8 = /cfif !--- if user submits consumer product details, remember it --- !---create variable to hold number of form fields to create--- cfset numberoffields = 8 cfform action=process_UpLoadExtraConsumerProductImages.cfm enctype=multipart/form-data cfloop index=i from=1 to=#variables.numberoffields# step=1 cfset filename = #SESSION.consumerProduct.Cnsmr_ProductID# #i# cfinput type=File name=cfoutput#variables.filename#/cfoutput /br / !--- Set the respective file name for the uploaded image --- cfset SESSION.consumerProductExtraImg.Img #i# = #filename# /cfloop cfinput type=Submit name=upload value=upload / /cfform The error generated is: Invalid CFML construct found on line 45 at column 58. ColdFusion was looking at the following text: = The CFML compiler was processing: A cfset tag beginning on line 45, column 10. A cfset tag beginning on line 45, column 10. A cfset tag beginning on line 45, column 10. The error occurred in C:\ColdFusion8\wwwroot\e-Ghana\uploadExtraConsumerProductImages.cfm: line 45 43 : cfinput type=File name=cfoutput#variables.filename#/cfoutput /br / 44 : !--- Set the respective file name for the uploaded image --- 45 : cfset SESSION.consumerProductExtraImg.Img #i# = #filename# 46 : /cfloop 47 : cfinput type=Submit name=upload value=upload / TIA ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319679 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
(ot) AIR question
Looked at the air list and it doesn't seem to get much in the way of posts so I figured I would throw it out here. I am just getting started with AIR and wanted to see anyone's thoughts on which road to go down in regards to air for the following. I wanted to make a simple app that would let you search through a list of people when online, save out a contact sheet of up to 5 that you can see when offline and remove them if you wish. Any changes to the persons info would update automatically when you next connected. All I am really looking for at this point is for someone to say yes that can be done in AIR and the best approach would be AIR w/flex, AIR w/ajax or AIR w/flash. Thanks, Scott ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319680 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: (ot) AIR question
On Monday 23 Feb 2009, Scott Mulholland wrote: Looked at the air list and it doesn't seem to get much in the way of posts so I figured I would throw it out here. You mean apollocoders ? The lack if traffic is a good thing :-) You might want to try flexcoders instead. All I am really looking for at this point is for someone to say yes that can be done in AIR and the best approach would be AIR w/flex, AIR w/ajax or AIR w/flash. Yes, and whichever of the three you currently know. -- Tom Chiverton Helping to carefully supply innovative clicks-and-mortar error-free markets This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office together with a list of those non members who are referred to as partners. We use the word partner to refer to a member of the LLP, or an employee or consultant with equivalent standing and qualifications. Regulated by the Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.co ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319681 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: (ot) AIR question
This could totally be done in AIR. As for which method you should use, it really comes down to which you're most comfortable with. I've written one Flex app, and one HTML/JS app, and I'm in the middle of writing a 3rd app done in HTML/JS. For me, it's easier since I'm far more familiar with HTML/CSS/JavaScript. But it's really personal preference. The API is about 95% the same between Flex/Flash and JavaScript. -Original Message- From: Scott Mulholland [mailto:smulholl...@aimg.com] Sent: Monday, February 23, 2009 7:57 AM To: cf-talk Subject: (ot) AIR question Looked at the air list and it doesn't seem to get much in the way of posts so I figured I would throw it out here. I am just getting started with AIR and wanted to see anyone's thoughts on which road to go down in regards to air for the following. I wanted to make a simple app that would let you search through a list of people when online, save out a contact sheet of up to 5 that you can see when offline and remove them if you wish. Any changes to the persons info would update automatically when you next connected. All I am really looking for at this point is for someone to say yes that can be done in AIR and the best approach would be AIR w/flex, AIR w/ajax or AIR w/flash. Thanks, Scott ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319682 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: (ot) AIR question
I 2nd the flexcoders list. I get over a hundred posts a day on that list. AIR will work the same either way you go. I've always liked the flex approach because there ends up being a lot of things that you might want on a website AND on the desktop so it makes it very FLEXible that way...ha ha. Like Tom said, use whatever's most familiar to you, just keep in mind most of the people who do AIR do it with Flex so if someone else comes in and has to do any updates, that's probably what they will already know. -Jake Scott Mulholland wrote: Looked at the air list and it doesn't seem to get much in the way of posts so I figured I would throw it out here. I am just getting started with AIR and wanted to see anyone's thoughts on which road to go down in regards to air for the following. I wanted to make a simple app that would let you search through a list of people when online, save out a contact sheet of up to 5 that you can see when offline and remove them if you wish. Any changes to the persons info would update automatically when you next connected. All I am really looking for at this point is for someone to say yes that can be done in AIR and the best approach would be AIR w/flex, AIR w/ajax or AIR w/flash. Thanks, Scott ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319683 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFHTTP and SSL v3
I got the same email from Authorize.net. We are using CFMX7 and from what I have read it doesn't support ssl 3.0 via cfhttp. If anyone has a quick solution I'd appreciate it. Likewise if I find one I'll let everyone know. Thanks Mike ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319684 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFHTTP and SSL v3
Michael, I had about concluded that 6 and 7 actually DO support 3.0. Can you tell me what docs indicated otherwise? -mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Michael Kotuba [mailto:michael.kot...@entrust.com] Sent: Monday, February 23, 2009 8:42 AM To: cf-talk Subject: Re: CFHTTP and SSL v3 I got the same email from Authorize.net. We are using CFMX7 and from what I have read it doesn't support ssl 3.0 via cfhttp. If anyone has a quick solution I'd appreciate it. Likewise if I find one I'll let everyone know. Thanks Mike ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319685 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CFFTP connection problems
Hello All, I am sure this is something simple, but I am attempting to use CFFTP to put a file on our web server. I can access this web server using any FTP software I want (i.e. Core FTP) but when I try to connect using CFFTP I get an error stating the connection has timed out. To be exact: Error: Connection timed out: connect. Verify your connection attributes: username, password, server, port, connection, proxyServer, secure (as applicable). Figuring it was something that I was doing wrong I went to adobe and used their FTP test code (basically it connects, reports status, disconnects, etc..). Same error. Something is blocking the CFFTP but I am not sure what or how. I know the server has a firewall protecting it, but ftp is allowed to pass through. Other ideas? Server options that I might have turned off or coldfusion admin options I need to turn on? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319686 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFHTTP and SSL v3
I had read it in several blog postings but nothing definitive from Adobe. I've done some more checking and it appears you are right about it working for CF7. Now if only the authorize.net test site was up to date I could test my apps. Cheers Mike Michael, I had about concluded that 6 and 7 actually DO support 3.0. Can you tell me what docs indicated otherwise? -mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com I got the same email from Authorize.net. We are using CFMX7 and from what I have read it doesn't support ssl 3.0 via cfhttp. If anyone has a quick solution I'd appreciate it. Likewise if I find one I'll let everyone know. Thanks Mike ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319687 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Mailing Label Solutions
Anyone came across anything really handy there? Last time I did that I blundered through just having them print the HTML which was a bit inconsistent at times. This time I'm considering a small 3rd party app or creating a pdf or something. Any clever suggestions? Dan ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319688 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
The command code was 0 ... What's best Priactice around this?
Getting an error from a specific query: The DBMS returned an unspecified error. The command code was 0 Here's the problem: WHERE ml_id IN ( cfqueryparam value=#ValueList(GetGROUP.ml_id)#,0 cfsqltype=CF_SQL_INTEGER list=yes / ) After some research, the ValueList is returning over 3000 records for the particular query that's causing problems. Seems that over 2100 (param) in a list will throw a Command Code Was 0 error. OK - trying to be sure I adhere to best practice at all times. What would you consider best practice if you know using cfqueryparam is going to have a problem with a large list containing over 2100 items? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319689 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Mappings
Hi My client is using a dedicated web server to host around five sites, to which I have full control over the cf administrator. These entire sites utilise a shopping cart and all secure payments will be directed to one secure server i.e. climbingframes.net.au payments to https://secure.selwoodproducts.com climbingframesuk.com payments to https://secure.selwoodproducts.co.uk etc. On the secure server (which resides on the same server) I will set up individual folders for each site to process the payments and customer info. These pages design wise, will have to mirror the referring site. Which is where my question comes, if I set up mappings can I use include files from say climbingframesuk.com on the secure.selwoodproducts.co.uk/cfuk address. As stated above all these domains will all be on the same server. Any pointer would be greatly appreciated, never really needed to get involved with the cf admin thing before. Many thanks Jason Jason ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319690 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Googlebot got me good last night...
I see you got a bunch of answers already and hopefully have solved your problem. However, I wanted to share with everyone a problem we had. We had a site that appended CFID and CFTOKEN on an older site that was using CF5 or 6 (I honestly can't remember at this point). A user had the google toolbar installed that reported links they visited back to Google. Well, the link it reported included CFID and CFTOKEN. Typically, this would timeout before the googlebot started crawling but in this instance it happened before the timeout. What screwed up royally was that the developer did NOT use buttons for deleting records but instead used links. My understanding in talking with some Google reps is that the google-bot does not click submit buttons, but it does follow all links. Needless to say, the google-bot deleted all of the records where that was the case in this app. So, as an added precaution, use input type=button or input type=image but do not use a href=... on any links that you wouldn't want a bot or something to follow. Obviously, a robots.txt should also be added to limit what you want bots to crawl but I figured I'd share that frustrating story to possibly help others. John -Original Message- From: Les Mizzell [mailto:lesm...@bellsouth.net] Sent: Thursday, February 19, 2009 3:10 PM To: cf-talk Subject: Googlebot got me good last night... This happened on a small site with a user admin system that's password protected. Seems Googlebot managed to get into the admin system last night, started crawling admin pages, and ended up munging half the database: 1. Clicking archive or mark inactive buttons on admin area index pages 2. In a few cases, actually seemed to SUBMIT a form, updating data. I'm still scratching my head over how Googlebot got into the admin system to start with. It looks legit from the logs. The IP address, user-agent and everything else checks out. Luckily, this isn't a mission-critical site, and database backups are done nightly, but now it's got me worried for other sites. Googlebot has *never* caused any problems with password protected admin systems before, my robots.txt file usually excludes the admin folder (and you can be sure I'm checking the ones I'm not sure about right now) and the login stuff I use I thought was pretty standard. My login code is below. Tell me I'm a complete idiot. So, 1. Anybody else have this problem recently? 2. I'm an idiot I guess, how *should* I be doing my login systems? (One site on CF8, others still CF7) 4. If you're doing anything like I am, then maybe we're *all* idiots at this point and need to redo our login pages to use whatever somebody much smarter than I says to do in #2 above. - Application.cfm page for the admin folder: - !--- Define that this user is logged out by default --- CFPARAM NAME=session.allowin DEFAULT=false !--- Define this user id to zero by default --- CFPARAM NAME=session.user_id DEFAULT=0 !--- If the variable session.allowin does not equal true, send user to the login page --- cfif session.allowin neq true cfif ListLast(CGI.SCRIPT_NAME, /) EQ ../admin_login.cfm cfelseif ListLast(CGI.SCRIPT_NAME, /) EQ login_process.cfm cfelse !--- Not logged in, alert user and redirect --- script !---alert(You must login to access this area!);--- self.location=../admin_login.cfm; /script /cfif /cfif - login_process page: - **QUERY TO CHECK USER/PASS HERE cfif Verify.RecordCount !--- logged in ... set the value of the session.allowin value --- cfset session.allowin = True / cfset session.user_id = Verify.id / script self.location=idx_admin.cfm; /script cfelse !--- not logged in, redirect to the login page --- script alert(Your credentials could not be verified, please try again!!!); self.location=../admin_login.cfm; /script /cfif ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319691 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFFTP connection problems
Hello All, I am sure this is something simple, but I am attempting to use CFFTP to put a file on our web server. I can access this web server using any FTP software I want (i.e. Core FTP) but when I try to connect using CFFTP I get an error stating the connection has timed out. To be exact: Error: Connection timed out: connect. Verify your connection attributes: username, password, server, port, connection, proxyServer, secure (as applicable). Figuring it was something that I was doing wrong I went to adobe and used their FTP test code (basically it connects, reports status, disconnects, etc..). Same error. Something is blocking the CFFTP but I am not sure what or how. I know the server has a firewall protecting it, but ftp is allowed to pass through. Other ideas? Server options that I might have turned off or coldfusion admin options I need to turn on? UPDATE: I have been able to use CFFTP to connect to ftp.mozilla.org. Here is the file that I used: cfftp connection=Myftp server=ftp.mozilla.org username=anonymous password= action=Open stoponerror=Yes cfftp action=close connection=Myftp pDid the connection close successfully? cfoutput#cfftp.succeeded#/cfoutput/p So the question is now, what is stopping my FTP connection to webserver? Again, using FTP software it works, but using CFFTP it does not. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319692 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: The command code was 0 ... What's best Priactice around this?
Les Mizzell wrote: OK - trying to be sure I adhere to best practice at all times. What would you consider best practice if you know using cfqueryparam is going to have a problem with a large list containing over 2100 items? Just to make sure that you understand that cfqueryparam... is not having a problem with a list of over 2100 items. Your database is having a problem with a parametrized list of over 2100 items. I.E. If you where to manually send the database a parameterized sql statement with the same sized list, you would get the same error. If the query successfully runs without a cfqueryparam... it just means that the DBMS can handle longer unparameterized lists. But databases still have maximum sizes they can handle for an 'IN' clause. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319693 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: The command code was 0 ... What's best Priactice around this?
Can you change the query to use joins instead? Adrian -Original Message- From: Les Mizzell [mailto:lesm...@bellsouth.net] Sent: 23 February 2009 18:48 To: cf-talk Subject: The command code was 0 ... What's best Priactice around this? Getting an error from a specific query: The DBMS returned an unspecified error. The command code was 0 Here's the problem: WHERE ml_id IN ( cfqueryparam value=#ValueList(GetGROUP.ml_id)#,0 cfsqltype=CF_SQL_INTEGER list=yes / ) After some research, the ValueList is returning over 3000 records for the particular query that's causing problems. Seems that over 2100 (param) in a list will throw a Command Code Was 0 error. OK - trying to be sure I adhere to best practice at all times. What would you consider best practice if you know using cfqueryparam is going to have a problem with a large list containing over 2100 items? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319694 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Mappings
Yes you can... You can create a mapping and then use it for includes anywhere on the server. Just keep in mind that the included code needs to be generic enough to be used on multiple sites. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Jason Congerton [mailto:ja...@jasoncongerton.co.uk] Sent: Monday, February 23, 2009 12:50 PM To: cf-talk Subject: Mappings Hi My client is using a dedicated web server to host around five sites, to which I have full control over the cf administrator. These entire sites utilise a shopping cart and all secure payments will be directed to one secure server i.e. climbingframes.net.au payments to https://secure.selwoodproducts.com climbingframesuk.com payments to https://secure.selwoodproducts.co.uk etc. On the secure server (which resides on the same server) I will set up individual folders for each site to process the payments and customer info. These pages design wise, will have to mirror the referring site. Which is where my question comes, if I set up mappings can I use include files from say climbingframesuk.com on the secure.selwoodproducts.co.uk/cfuk address. As stated above all these domains will all be on the same server. Any pointer would be greatly appreciated, never really needed to get involved with the cf admin thing before. Many thanks Jason Jason ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319695 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Mappings
Yup, but be careful of any pages you intend to include with mappings which rely on data created in its original app. You also don't have to use mappings, you could use ExpandPath() to dot dot slash your way to the files you need. If you do find you have app specific vars in the included pages, consider changing how you call them to customtag calls (cfmodule), then pass in the data. Adrian -Original Message- From: Jason Congerton [mailto:ja...@jasoncongerton.co.uk] Sent: 23 February 2009 18:50 To: cf-talk Subject: Mappings Hi My client is using a dedicated web server to host around five sites, to which I have full control over the cf administrator. These entire sites utilise a shopping cart and all secure payments will be directed to one secure server i.e. climbingframes.net.au payments to https://secure.selwoodproducts.com climbingframesuk.com payments to https://secure.selwoodproducts.co.uk etc. On the secure server (which resides on the same server) I will set up individual folders for each site to process the payments and customer info. These pages design wise, will have to mirror the referring site. Which is where my question comes, if I set up mappings can I use include files from say climbingframesuk.com on the secure.selwoodproducts.co.uk/cfuk address. As stated above all these domains will all be on the same server. Any pointer would be greatly appreciated, never really needed to get involved with the cf admin thing before. Many thanks Jason Jason ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319696 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFFTP connection problems
Are you FTP'ing from your web server back to the same server? Or from 2 servers on the same network? What IP address does it resolve to? Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Will Blake [mailto:willbl...@printelect.com] Sent: Monday, February 23, 2009 1:00 PM To: cf-talk Subject: Re: CFFTP connection problems Hello All, I am sure this is something simple, but I am attempting to use CFFTP to put a file on our web server. I can access this web server using any FTP software I want (i.e. Core FTP) but when I try to connect using CFFTP I get an error stating the connection has timed out. To be exact: Error: Connection timed out: connect. Verify your connection attributes: username, password, server, port, connection, proxyServer, secure (as applicable). Figuring it was something that I was doing wrong I went to adobe and used their FTP test code (basically it connects, reports status, disconnects, etc..). Same error. Something is blocking the CFFTP but I am not sure what or how. I know the server has a firewall protecting it, but ftp is allowed to pass through. Other ideas? Server options that I might have turned off or coldfusion admin options I need to turn on? UPDATE: I have been able to use CFFTP to connect to ftp.mozilla.org. Here is the file that I used: cfftp connection=Myftp server=ftp.mozilla.org username=anonymous password= action=Open stoponerror=Yes cfftp action=close connection=Myftp pDid the connection close successfully? cfoutput#cfftp.succeeded#/cfoutput/p So the question is now, what is stopping my FTP connection to webserver? Again, using FTP software it works, but using CFFTP it does not. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319697 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFFTP connection problems
Can you telnet from the coldfusion to the remote host? telnet remote.myserver.com 21 If you get something like this: Escape character is '^]'. 220 (vsFTPd 2.0.1) Then there is nothing blocking communication to the remote FTP server. That way, you can remove that from the list of problems, and check your CFFTP configuration. speeves On Mon, Feb 23, 2009 at 1:10 PM, Mark Kruger mkru...@cfwebtools.com wrote: Are you FTP'ing from your web server back to the same server? Or from 2 servers on the same network? What IP address does it resolve to? Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Will Blake [mailto:willbl...@printelect.com] Sent: Monday, February 23, 2009 1:00 PM To: cf-talk Subject: Re: CFFTP connection problems Hello All, I am sure this is something simple, but I am attempting to use CFFTP to put a file on our web server. I can access this web server using any FTP software I want (i.e. Core FTP) but when I try to connect using CFFTP I get an error stating the connection has timed out. To be exact: Error: Connection timed out: connect. Verify your connection attributes: username, password, server, port, connection, proxyServer, secure (as applicable). Figuring it was something that I was doing wrong I went to adobe and used their FTP test code (basically it connects, reports status, disconnects, etc..). Same error. Something is blocking the CFFTP but I am not sure what or how. I know the server has a firewall protecting it, but ftp is allowed to pass through. Other ideas? Server options that I might have turned off or coldfusion admin options I need to turn on? UPDATE: I have been able to use CFFTP to connect to ftp.mozilla.org. Here is the file that I used: cfftp connection=Myftp server=ftp.mozilla.org username=anonymous password= action=Open stoponerror=Yes cfftp action=close connection=Myftp pDid the connection close successfully? cfoutput#cfftp.succeeded#/cfoutput/p So the question is now, what is stopping my FTP connection to webserver? Again, using FTP software it works, but using CFFTP it does not. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319698 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: The command code was 0 ... What's best Priactice around this?
Adrian Lynch wrote: Can you change the query to use joins instead? I haven't quite worked that out yet because of the way the two queries were originally set up: --- QUERY ONE: --- SELECT DISTINCT groups_id, ml_id FROM nl_catREL WHERE groups_id = #form.sendGROUP# AND ml_id IS NOT NULL --- QUERY TWO: --- SELECT max(ml_id) as ml_id, max(ml_firstname) as ml_firstname, max(ml_lastname) as ml_lastname, max(other) as other, ml_email FROM nl_mailgroups WHERE ml_id IN ( cfqueryparam value=#ValueList(GetGROUP.ml_id)#,0 cfsqltype=CF_SQL_INTEGER list=yes / ) GROUP BY ml_email ORDER BY ml_email ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319699 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Mailing Label Solutions
Highly recommend the Dymo LabelWriter printers. (No, there is no commercial relationship here, I just use their printers.) I've got a CF app pushing labels through from the browser to the local machine using the ActiveX that comes installed with the printer driver for the LabelWriter 400 Turbo (http://global.dymo.com/enUS/Products/LabelWriter_400_Turbo.html). The installation includes the label designer, and the code to make the call to the ActiveX, setting dynamic variables in the label as it goes. Slick and pretty easy to implement. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319700 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: The command code was 0 ... What's best Priactice around this?
WHERE ml_id IN ( cfqueryparam value=#ValueList(GetGROUP.ml_id)#,0 cfsqltype=CF_SQL_INTEGER list=yes / ) This works of course: WHERE ml_id IN ( #ValueList(GetGROUP.ml_id)# ) But not sure if it's the best way... ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319701 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFFTP connection problems
s/the coldfusion/the coldfusion server/ On Mon, Feb 23, 2009 at 1:19 PM, Shannon Peevey spee...@stolaf.edu wrote: Can you telnet from the coldfusion to the remote host? telnet remote.myserver.com 21 If you get something like this: Escape character is '^]'. 220 (vsFTPd 2.0.1) Then there is nothing blocking communication to the remote FTP server. That way, you can remove that from the list of problems, and check your CFFTP configuration. speeves On Mon, Feb 23, 2009 at 1:10 PM, Mark Kruger mkru...@cfwebtools.comwrote: Are you FTP'ing from your web server back to the same server? Or from 2 servers on the same network? What IP address does it resolve to? Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Will Blake [mailto:willbl...@printelect.com] Sent: Monday, February 23, 2009 1:00 PM To: cf-talk Subject: Re: CFFTP connection problems Hello All, I am sure this is something simple, but I am attempting to use CFFTP to put a file on our web server. I can access this web server using any FTP software I want (i.e. Core FTP) but when I try to connect using CFFTP I get an error stating the connection has timed out. To be exact: Error: Connection timed out: connect. Verify your connection attributes: username, password, server, port, connection, proxyServer, secure (as applicable). Figuring it was something that I was doing wrong I went to adobe and used their FTP test code (basically it connects, reports status, disconnects, etc..). Same error. Something is blocking the CFFTP but I am not sure what or how. I know the server has a firewall protecting it, but ftp is allowed to pass through. Other ideas? Server options that I might have turned off or coldfusion admin options I need to turn on? UPDATE: I have been able to use CFFTP to connect to ftp.mozilla.org. Here is the file that I used: cfftp connection=Myftp server=ftp.mozilla.org username=anonymous password= action=Open stoponerror=Yes cfftp action=close connection=Myftp pDid the connection close successfully? cfoutput#cfftp.succeeded#/cfoutput/p So the question is now, what is stopping my FTP connection to webserver? Again, using FTP software it works, but using CFFTP it does not. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319702 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Spam Assassin is assassinating my server!
Hi, I have a couple of sites which send some news letters to subscribers. A couple of them are blocked by Spam Assassin. I'm looking for some service I could send messages to and that will return the Spam Assassin report and scoring, so I can make sure my news letters are correct. Any hint ? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319703 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Spam Assassin is assassinating my server!
Setup a local Spam Assassin server? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319704 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Mailing Label Solutions
Unfortunately in this case the client specifies the label sheets and I just build the reports and they are full sheet stuff.. probably from an ink printer. I've the Dymo's before though. I used CSS and print features to get them to come out alright.. but not great. I happened across this REALLY old tool for label printing that looks fantastic and uber-simple so far: http://www.ghidinelli.com/2003/07/03/cf_averyrtf-12-available It seems to build avery labels based on the model # of the page and in so abstracts the futzing with margins etc by exporting the prepared doc via RTF to word. I haven't implemented yet but the example looked stellar and even includes bar codes for mass mailing compliance with the USPS. I'll let ya know later today if it works as good as it sounds. Dan On Mon, Feb 23, 2009 at 12:14 PM, Jason Fisher ja...@wanax.com wrote: Highly recommend the Dymo LabelWriter printers. (No, there is no commercial relationship here, I just use their printers.) I've got a CF app pushing labels through from the browser to the local machine using the ActiveX that comes installed with the printer driver for the LabelWriter 400 Turbo (http://global.dymo.com/enUS/Products/LabelWriter_400_Turbo.html). The installation includes the label designer, and the code to make the call to the ActiveX, setting dynamic variables in the label as it goes. Slick and pretty easy to implement. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319705 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: The command code was 0 ... What's best Priactice around this?
Try doing something along the lines of this: SELECT max(ml_id) as ml_id, max(ml_firstname) as ml_firstname, max(ml_lastname) as ml_lastname, max(other) as other, ml_email FROM nl_mailgroups WHERE ml_id = 0 OR EXISTS ( SELECT 1 FROM nl_catREL WHERE nl_catREL.groups_id = cfqueryparam value=#form.sendGROUP# cfsqltype=cf_sql_integer/ AND (nl_catREL.ml_id = nl_mailgroups.ml_id) ) GROUP BY ml_email ORDER BY ml_email ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319706 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Spam Assassin is assassinating my server!
The easiest is to install spamassassin on your local machine and run your messages through them. The issues are: 1. spamassassin auto-learns, so other sites are not going to have the same results as you will. 2. spamassassin also checks headers, so they will play a role in the remote scoring, but will not in your tests. lycka til, speeves On Mon, Feb 23, 2009 at 1:38 PM, Claude Schneegans schneeg...@internetique.com wrote: Hi, I have a couple of sites which send some news letters to subscribers. A couple of them are blocked by Spam Assassin. I'm looking for some service I could send messages to and that will return the Spam Assassin report and scoring, so I can make sure my news letters are correct. Any hint ? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319707 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: The command code was 0 ... What's best Priactice around this?
This should do it: SELECT max(nl_mailgroups.ml_id) as ml_id, max(nl_mailgroups.ml_firstname) as ml_firstname, max(nl_mailgroups.ml_lastname) as ml_lastname, max(nl_mailgroups.other) as other, nl_mailgroups.ml_email FROM nl_mailgroups INNER JOIN nl_catREL ON nl_mailgroups.ml_id = nl_catREL.ml_id WHERE nl_catREL.groups_id = cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#form.sendGROUP# / AND nl_catREL.ml_id IS NOT NULL GROUP BY nl_mailgroups.ml_email ORDER BY nl_mailgroups.ml_email ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319708 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Spam Assassin is assassinating my server!
The easiest is to install spamassassin on your local machine and run your messages through them. I was hoping this service was provided by spamassassin.org ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319709 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Spam Assassin is assassinating my server!
Setup a local Spam Assassin server? I don't use Apache... ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319710 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Mailing Label Solutions
Definitely more difficult if you're limited on the printer side. What I like about the Dymo's isn't just the printer, but the label software, which reads the label type and didn't require any use of HTML or CSS ... I literally set the label template up in Dymo's own software and then just fed in dynamic values, so I can see on screen exactly what it will look like when printed. Good luck with the Avery connector, though, hope that works for you! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319711 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Spam Assassin is assassinating my server!
Spam Assassin has nothing to do with apache. And you wouldn't have to run SA on the local server, either. There is a java implementation of spamc (the SA client), you can use that to run the message through a SA server, wherever it may be. -Ryan Claude Schneegans wrote: Setup a local Spam Assassin server? I don't use Apache... ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319712 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Spam Assassin is assassinating my server!
We tried this, and it didn't work very well. The scoring doesn't range much. It could be an issue with what's in our auto-learn database, but I think it has more to do with the missing message headers. We even tacked on basic headers (to, from, subject), but its still missing the headers from traversing through various mail servers. -Ryan Shannon Peevey wrote: The easiest is to install spamassassin on your local machine and run your messages through them. The issues are: 1. spamassassin auto-learns, so other sites are not going to have the same results as you will. 2. spamassassin also checks headers, so they will play a role in the remote scoring, but will not in your tests. lycka til, speeves On Mon, Feb 23, 2009 at 1:38 PM, Claude Schneegans schneeg...@internetique.com wrote: Hi, I have a couple of sites which send some news letters to subscribers. A couple of them are blocked by Spam Assassin. I'm looking for some service I could send messages to and that will return the Spam Assassin report and scoring, so I can make sure my news letters are correct. Any hint ? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319714 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Mappings
Hi Thanks for your replies! The main reason for this is to include navigation files, so the page template stays intact on the secure part of the server, and am not intending using any cf code within these files. It's mainly so i have one point of update for navigation links. I suppose i could use an iframe on the standard site and serve the forms to it, but people would have no way of knowing this was secure, and i will also need to share session variables between the two pages/sites? So creating the secure bits on the secure server is the best option i think? Any thoughts? If only my client would pay for individual secure certs! Jason Yup, but be careful of any pages you intend to include with mappings which rely on data created in its original app. You also don't have to use mappings, you could use ExpandPath() to dot dot slash your way to the files you need. If you do find you have app specific vars in the included pages, consider changing how you call them to customtag calls (cfmodule), then pass in the data. Adrian ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319713 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFFTP connection problems
Can you telnet from the coldfusion to the remote host? telnet remote.myserver.com 21 If you get something like this: Escape character is '^]'. 220 (vsFTPd 2.0.1) Then there is nothing blocking communication to the remote FTP server. That way, you can remove that from the list of problems, and check your CFFTP configuration. speeves I can telnet from my computer (client) to the coldfusion webserver if I type telnet myserver.com 21. Typing remote.myserver.com 21 I get a connection refused error. Just to make sure we are all clear. The coldfusion server is our webserver. So when I test the cfftp action=open technically it is trying to open an ftp connection to the same server it is on, which I can see that would be a problem. If not using ftp, how would I move a file from my computer to the coldfusion server? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319715 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFFTP connection problems
I can telnet from my computer (client) to the coldfusion webserver if I type telnet myserver.com 21. Typing remote.myserver.com 21 I get a connection refused error. Just to make sure we are all clear. The coldfusion server is our webserver. So when I test the cfftp action=open technically it is trying to open an ftp connection to the same server it is on, which I can see that would be a problem. Just for kicks, (from the webserver command-line), can you telnet localhost 21? (or ftp localhost, in case telnet isn't installed). if that works, then try the IP address. This is just a basic connectivity test. What is your full config for cfftp? speeves ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319716 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFFTP connection problems
Will, Ah... Your problem could be networking. On our network (for example) we have both internal and external IP addresses running through cisco pix. We have to run an internal DNS server to dole out interal IP addresses for the reason you describe below. A web server could not (for example) connect to it's external address through the same pix. To troubleshoot this, RDP to the server and then ping the address (the host you are using ... Remote.myserver.com etc) and see what IP is returned. Check with your networking folks on how the server is set up. You will have to log on to the server desktop to be able to troubleshoot effectively. Nothing you do from your workstation to the server will give you sufficient information. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Will Blake [mailto:willbl...@printelect.com] Sent: Monday, February 23, 2009 2:03 PM To: cf-talk Subject: Re: CFFTP connection problems Can you telnet from the coldfusion to the remote host? telnet remote.myserver.com 21 If you get something like this: Escape character is '^]'. 220 (vsFTPd 2.0.1) Then there is nothing blocking communication to the remote FTP server. That way, you can remove that from the list of problems, and check your CFFTP configuration. speeves I can telnet from my computer (client) to the coldfusion webserver if I type telnet myserver.com 21. Typing remote.myserver.com 21 I get a connection refused error. Just to make sure we are all clear. The coldfusion server is our webserver. So when I test the cfftp action=open technically it is trying to open an ftp connection to the same server it is on, which I can see that would be a problem. If not using ftp, how would I move a file from my computer to the coldfusion server? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319717 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Spam Assassin is assassinating my server!
As someone that administers an email server that uses Spam Assassin I can tell you that it checks many things including but not limited to: Real Time Blacklists (RBLs):Make sure your sending ip address is not on any RBLs. invalid reverse DNS common spam words or phrases in the subject or body All HTML body (ie no equivalent text portion) invalid date date in the future SPF_FAIL and the list goes on and on and on. I included a few SA headers below so you can see what kinds of things I'm talking about. All SA servers are different because they use auto learning and thus some learn things not learned by others. If every single email is being rejected as spam by a certain SA sever or many SA servers I'm willing to bet your on an RBL. Use this as a start to check if your in and RBL. http://www.spamhaus.org/lookup.lasso If at all possible get one of the emails blocked by SA and inspect the headers. Wil Genovese Example SA header outputs. pts rule name description -- -- 0.7 URG_BIZBODY: Contains urgent matter 2.7 DEAR_FRIENDBODY: Dear Friend? That's not very dear! 1.1 NA_DOLLARS BODY: Talks about a million North American dollars 2.0 ADVANCE_FEE_2 Appears to be advance fee fraud (Nigerian 419) 1.4 ADVANCE_FEE_3 Appears to be advance fee fraud (Nigerian 419) 1.5 ADVANCE_FEE_4 Appears to be advance fee fraud (Nigerian 419) 0.1 RDNS_NONE Delivered to trusted network by a host with no rDNS pts rule name description -- -- 0.7 SPF_SOFTFAIL SPF: sender does not match SPF record (softfail) 2.2 RCVD_IN_BL_SPAMCOP_NET RBL: Received via a relay in bl.spamcop.net [Blocked - see http://www.spamcop.net/bl.shtml?62.140.137.157 ] 1.1 RCVD_IN_SORBS_WEB RBL: SORBS: sender is a abuseable web server [62.140.137.157 listed in dnsbl.sorbs.net] 1.2 US_DOLLARS_3 BODY: Mentions millions of $ ($NN,NNN,NNN.NN) 0.7 MSOE_MID_WRONG_CASEMSOE_MID_WRONG_CASE 2.0 ADVANCE_FEE_2 Appears to be advance fee fraud (Nigerian 419) 0.1 RDNS_NONE Delivered to trusted network by a host with no rDNS 4.2 FORGED_MUA_OUTLOOK Forged mail pretending to be from MS Outlook pts rule name description -- -- 1.6 URIBL_AB_SURBL Contains an URL listed in the AB SURBL blocklist [URIs: fillfeel.com] 2.1 URIBL_WS_SURBL Contains an URL listed in the WS SURBL blocklist [URIs: fillfeel.com] 2.9 URIBL_JP_SURBL Contains an URL listed in the JP SURBL blocklist [URIs: fillfeel.com] 2.1 URIBL_OB_SURBL Contains an URL listed in the OB SURBL blocklist [URIs: fillfeel.com] 2.5 URIBL_SC_SURBL Contains an URL listed in the SC SURBL blocklist [URIs: fillfeel.com] 2.0 URIBL_BLACKContains an URL listed in the URIBL blacklist [URIs: fillfeel.com] 0.9 URIBL_RHS_DOB Contains an URI of a new domain (Day Old Bread) [URIs: fillfeel.com] 0.5 FH_HELO_EQ_D_D_D_D Helo is d-d-d-d 1.7 INVALID_DATE Invalid Date: header (not RFC 2822) 1.6 TVD_RCVD_IPTVD_RCVD_IP 3.9 DATE_IN_FUTURE_96_XX Date: is 96 hours or more after Received: date 1.0 SPF_FAIL SPF: sender does not match SPF record (fail) [SPF failed: Please see http://www.openspf.org/why.html?sender=theresax%40info.gamanetwork.comip=200.2.159.214receiver=xbox.christianmp3.com ] 2.9 MSGID_OUTLOOK_INVALID Message-Id is fake (in Outlook Express format) 0.5 RCVD_IN_PBLRBL: Received via a relay in Spamhaus PBL [200.2.159.214 listed in zen.spamhaus.org] 3.4 REPLICA_WATCH BODY: Message talks about a replica watch 0.0 HTML_MESSAGE BODY: HTML included in message 2.5 URIBL_SBL Contains an URL listed in the SBL blocklist [URIs: fillfeel.com] 2.0 FROM_EXCESS_BASE64 From: base64 encoded unnecessarily 0.1 RDNS_NONE Delivered to trusted network by a host with no rDNS On Mon, Feb 23, 2009 at 1:38 PM, Claude Schneegans schneeg...@internetique.com wrote: Hi, I have a couple of sites which send some news letters to subscribers. A couple of them are blocked by Spam Assassin. I'm looking for some service I could send messages to and that will return the Spam Assassin report and scoring, so I can make sure my news letters are correct. Any hint ? ~| Adobe® ColdFusion® 8 software 8 is the most important and
RE: The command code was 0 ... What's best Priactice around this?
In addition to the other JOIN solutions provided (my preference), it can be noted that other solutions would be to replace your value list with a sub-select containing the first query like so: SELECT max(ml_id) as ml_id, max(ml_firstname) as ml_firstname, max(ml_lastname) as ml_lastname, max(other) as other, ml_email FROM nl_mailgroups WHERE ml_id IN ( SELECT ml_id FROM nl_catREL WHERE groups_id = #form.sendGROUP# AND ml_id IS NOT NULL GROUP BY groups_id, ml_id) GROUP BY ml_email ORDER BY ml_email Another option in MS SQL Server would be to declare a table variable @tmp and populate it with the first select or use a Common Table Expression and then join on it in the second query. I can even think of other ways-- but I guess that's neither here nor there. The main reason I replied was to point out a couple potential problems with your SQL for what it's worth. (I know-- I hate being that guy...) Firstly, the un-paramaterized form.sendGROUP variable in your first select is begging to be exploited via SQL injection. Second, I don't know everything about your data structure, but you may get unexpected results from your second select with the group by and the max. It appears you are dealing with dupe E-mails addresses and only which to return one record per distinct E-mail. The problem with using max though is you might get an ID that doesn't match the name. Or worse, a first name that doesn't match the last name. For example, consider the following three possible records: ml_emailms_firstnamems_lastname ml_id t...@test.com AndyZellar 1 t...@test.com Steve Andrews 2 t...@test.com JohnDoe 3 Grouping on E-mail and taking the max names and id will return you this: ml_emailms_firstnamems_lastname ml_id t...@test.com Steve Zellar 3 If you can guarantee that any instance of a given E-mail in your nl_mailgroups table will always have the same name and id, then you will be ok. Un-normalized, but ok. :) ~Brad ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319719 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Adding new CF instances and apache VirtualHosts to our Solaris Unix server.
What are the proper steps to connect a new Apache VirturHost to a newly created ColdFusion instance on the server. I'm a little confused about the current VirturalHosts as there does not seem to be much rhyme or reason to the modules that I presume connect the hosts to the CF instances. I previously only had the default 'cfusion' instance that should not have been connected to any web hosts and a 'general' instance that should have ran the existing virtual hosts. I just added a 'calpip' instance that I want to connect to some new virtual hosts I plan to add to the server. So looking at my existing virturalHosts... directive in the current httpd.conf file I find these relevant lines of code. I was expecting to see /wsconfig/1/... but I am getting other combinations that I did not expect. Also how do I determine what port to put into the Bootstrap line for a new instance? IfModule mod_jrun20.c JRunConfig Verbose true JRunConfig Serverstore /opt/jrun4/lib/wsconfig/calpip-devsite/jrunserver.store JRunConfig Bootstrap 127.0.0.1:51000 /IfModule IfModule mod_jrun20.c JRunConfig Verbose true JRunConfig Serverstore /opt/jrun4/lib/wsconfig/site/jrunserver.store JRunConfig Bootstrap 127.0.0.1:51000 /IfModule IfModule mod_jrun20.c JRunConfig Verbose true JRunConfig Serverstore /opt/jrun4/lib/wsconfig/1/jrunserver.store JRunConfig Bootstrap 127.0.0.1:51020 /IfModule IfModule mod_jrun20.c JRunConfig Verbose true JRunConfig Serverstore /opt/jrun4/lib/wsconfig/site/jrunserver.store JRunConfig Bootstrap 127.0.0.1:51000 /IfModule ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319720 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Spam Assassin is assassinating my server!
In my case, I think the problem is related to 8bits bytes subject and addresses. So spam Assassin is forcing applications to use middle age technologies. I know it is the standard, but it's about time to change it. And SpamAss is about the only soft that refuses 8 bit subjects. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319721 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Spam Assassin is assassinating my server!
Are you sure that it is spamassassin? Could it be Greylisting? On Mon, Feb 23, 2009 at 3:38 PM, Claude Schneegans schneeg...@internetique.com wrote: In my case, I think the problem is related to 8bits bytes subject and addresses. So spam Assassin is forcing applications to use middle age technologies. I know it is the standard, but it's about time to change it. And SpamAss is about the only soft that refuses 8 bit subjects. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319722 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Spam Assassin is assassinating my server!
Are you sure that it is spamassassin? Yes, this was confirmed by the administrator of the server. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319723 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFC performance
I went with option 2, and will be able to test to see if the previous startup issues are resolved later tonight or tomorrow. Thanks, Pete On Sun, Feb 22, 2009 at 6:48 PM, Matt Quackenbush quackfu...@gmail.com wrote: +1 On Sun, Feb 22, 2009 at 7:33 AM, Peter Boughton wrote: Do this one: 2) Move each family of SQL functionality (i.e. all news functions -- between 3 and 10 CFC's per family, on average) into its own separate CFC. This would entail touching every page on the site and creating about 18 new CFC files. I'm assuming you mean between 3 and 10 /functions/ per family - each category of functions should sit in a single component. Remove the original sql.cfc once you're done, so you can confirm it is not in use. But before all that, make sure you have regression tests of all important functionality (preferably all functionality) before even starting, so you can check if you've missed or broken anything. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319724 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CF8: CFChart (FLASH) to PDF issue.
I am trying to put chart being generated in Flash into a PDF file, but all I am getting is blank PDF, just with the watermark saying that its a developer edition. This problem is persistent for Flash only. My PNG chart looks great in PDF. Any thoughts? Am I missing something??? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319725 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF8: CFChart (FLASH) to PDF issue.
I am trying to put chart being generated in Flash into a PDF file, but all I am getting is blank PDF, just with the watermark saying that its a developer edition. This problem is persistent for Flash only. My PNG chart looks great in PDF. Any thoughts? Am I missing something??? I don't think you can embed any Flash content in CF-generated PDFs. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319726 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF8: CFChart (FLASH) to PDF issue.
Dave, I was thinking the same thing, till I read documentation about CF8-- CFChart tag, From CF8 live docs:- ColdFusion 8: Added support for embedding Flash charts within the cfdocument tag. http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=Tags_c_05.html So I think there is something else going on, some mapping or something I am missing. I am trying to put chart being generated in Flash into a PDF file, but all I am getting is blank PDF, just with the watermark saying that its a developer edition. This problem is persistent for Flash only. My PNG chart looks great in PDF. Any thoughts? Am I missing something??? I don't think you can embed any Flash content in CF-generated PDFs. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319727 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF8: CFChart (FLASH) to PDF issue.
Varun Dixit wrote: I was thinking the same thing, till I read documentation about CF8-- CFChart tag, no, the docs are wrong in this case. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319728 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF8: CFChart (FLASH) to PDF issue.
ouch There goes my 2 days of research into finding fix for this problem. I should have posted it right away on the listg Well, if that's the case than someone from CF team at Adobe should update the live docs so that it's not misleading. Varun Dixit wrote: I was thinking the same thing, till I read documentation about CF8-- CFChart tag, no, the docs are wrong in this case. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319729 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF8: CFChart (FLASH) to PDF issue.
Varun Dixit wrote: There goes my 2 days of research into finding fix for this problem. I should have posted it right away on the listg well if you *really* need to do this don't mind getting your hands dirty w/iText (the java lib that powers cfdocument, etc.) you can probably handle this with some dipping down into java. have a look at the PdfFileSpecification PdfAnnotation classes (there's a simple example in bruno's book to embed an MPEG file, same principle applies to SWF). ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319730 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF8 new install an COM issue
We just set up a new development server and some of our com objects are failing. (This is old code) The error I'm getting is this Can not use native code: Initialisation failed or see partial dump below: java.lang.RuntimeException: Can not use native code: Initialisation failed at com.linar.jintegra.NativeObjRef.init(Unknown Source) at com.linar.jintegra.Dispatch.createDispatch(Unknown Source) at com.linar.jintegra.Dispatch.init(Unknown Source) at com.intrinsyc.typeInfo.IMacroViewerProxy.init(IMacroViewerProxy. java:32) at com.intrinsyc.typeInfo.MacroViewer.init(MacroViewer.java:90) at com.intrinsyc.typeInfo.MacroViewer.init(MacroViewer.java:69) at com.intrinsyc.typeInfo.InterfaceInfoFactory. getInfoGivenPROGID(InterfaceInfoFactory.java:50) at coldfusion.runtime.com.ComProxy.init(ComProxy.java:114) Researching this I get this information: http://j-integra.intrinsyc.com/support/kb/article.aspx?id==75790 But staring at our class paths they all seem fine mapped to {application.home}jre/bin Any thoughts as to why this is breaking. Also, could it just be that we upgraded our servers to 64bit and the COM dlls are years old. thanks in advance for any help you can offer -- Joshua O'Connor-Rose -All is Good Joshua, This is being caused by the fact you are running 64 bit now. Com can only run in 32 bit. I would either run your app in 32 bit, or replace with a library that can run in 64 bit. David Fekke ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319731 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4