spam scoring
I have a newsletter blast out system for my clients... and I'd like to build in a spam-scoring system so that the clients can check their newsletters before they send them. A support organisation had an interesting time recently when they mentioned breast cancer month. Does anyone know of any code that's available to do this? Maybe a custom tag or CFC or something? Thanks! -- Kay Smoljak http://kay.zombiecoder.com/ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222544 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
FW: MySQL DSN
Anyone know this would happen. ?? CFMX6.1 on win2k Create a MySQL DSN, put the username password into the DSN and it works fine. Pass the username/password in the code and it doesn't work. The DSN also appears to randomly timeout after a certain period, and you need to re-reverify it in the cfadmin for it to start working again (with the username/password). Setting the timeout values in the DSN to 0 does appear to resolve this mostly, but they still seem to stop working eventuaslly. This happens with both the default MySQL driver and the connector/J driver. -- Russ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222545 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Big Honking Queries Make Me Want To Scream
From: Les Mizzell [mailto:[EMAIL PROTECTED] Les, without knowing the relationships between the tables (one-to-one, one-to-many, many-to-many) this may or may not produce your desired output, but lets start with the following: SELECT p.FName, p.LName, s.Title, s.Network, c.CreditType FROM Shows s INNER JOIN SubjectMatter sm ON (s.ShowID = sm.ShowID) INNER JOIN Credits c ON (s.ShowID = c.ShowID) INNER JOIN Players p ON (sShowID = p.ShowID) WHERE s.Network = cfqueryparam cfsqltype=CF_SQL_VARCHAR null=false value=#trim(form.network)# / AND c.CreditType = cfqueryparam cfsqltype=CF_SQL_VARCHAR null=false value=#trim(form.credittype)# / AND s.Logline LIKE cfqueryparam cfsqltype=CF_SQL_VARCHAR null=false value=%#trim(form.logline)#% / ORDER BY p.LName ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222546 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Big Honking Complex Queries Make Me Want To Scream
best advice might be to build up the sql slowly - table at a time - that way you will see at what point it goes pear shaped. Mike ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222547 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Inline frames a good alternative for creating web applications?
The Javascript Cookbook from O'Reilly. It gets you right into the meat of the matter with very little fuss. -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Thursday, October 27, 2005 11:07 PM To: CF-Talk Subject: RE: Inline frames a good alternative for creating web applications? Gotcha...I guess sooner or later I'm gonna have to break down and find a Javascript for Dummies and subdue this gorilla. If you were about to start a JS-learning journey, where would you turn first? Rick -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Thursday, October 27, 2005 10:23 PM To: CF-Talk Subject: Re: Inline frames a good alternative for creating web applications? If you mean I can't climb very high up a corporate ladder, No no, what I mean is that dynamic HTML on the server side is pretty good, but there are also things that just can't be done efficiently on server side. Take dynamic menus, online editing, just to name a few. All these take Javascript. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222548 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: email code in cfc
Who decides if it is right or wrong? Go with what works best for you, that should be right On 10/27/05, John C. Bland II [EMAIL PROTECTED] wrote: I've been doing it for years but it doesn't mean its right. :-) It definitely works and I don't seen any reason why you wouldn't/shouldn't. On 10/27/05, dave [EMAIL PROTECTED] wrote: what the limitations of running cfmail in a cfc? any? at all? ~Dave the disruptor~ Some people just don't appreciate how difficult it is to dispense wisdom and abuse at the same time. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222549 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
FlashForm
Hi all, A quick question. I have a flash form and on cfinput type=checkbox I have a function call with a value on onClick event. on that function I can alert(var) and its displaying the value. The problem I am having is I need to run the query there with this var. i.e. WHERE ID = var its not working in this way, how can I do that. Regards, Asim Manzur ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222550 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Big Honking Complex Queries Make Me Want To Scream
I find it more useful for debugging purposes to build complex queries in a SQL ide such as SQLyog or MySQL Front, in the case of SQL Server I use Query Analyzer. You will get better information and it will take less time to debug. Stan Winchester Aftershock Web Design, Inc. President/Developer [EMAIL PROTECTED] http://www.aftershockweb.com/ Phone 503-244-3440 Fax 503-244-3454 best advice might be to build up the sql slowly - table at a time - that way you will see at what point it goes pear shaped. Mike ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222551 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Inline frames a good alternative for creating web applications?
Thanks for the tip, Calvin... Rick -Original Message- From: Calvin Ward [mailto:[EMAIL PROTECTED] Sent: Friday, October 28, 2005 7:39 AM To: CF-Talk Subject: RE: Inline frames a good alternative for creating web applications? The Javascript Cookbook from O'Reilly. It gets you right into the meat of the matter with very little fuss. -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Thursday, October 27, 2005 11:07 PM To: CF-Talk Subject: RE: Inline frames a good alternative for creating web applications? Gotcha...I guess sooner or later I'm gonna have to break down and find a Javascript for Dummies and subdue this gorilla. If you were about to start a JS-learning journey, where would you turn first? Rick -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Thursday, October 27, 2005 10:23 PM To: CF-Talk Subject: Re: Inline frames a good alternative for creating web applications? If you mean I can't climb very high up a corporate ladder, No no, what I mean is that dynamic HTML on the server side is pretty good, but there are also things that just can't be done efficiently on server side. Take dynamic menus, online editing, just to name a few. All these take Javascript. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222552 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Big Honking Complex Queries Make Me Want To Scream
Ditto to what the others said, but you also haven't told us if all those tables will always have matching records - which will make the difference between using inner joins and outer joins. I think the main thing that you're not understanding is how to build up the inner join syntax. Here's an example of a from statement with multiple tables joined. FROM ((recipe INNER JOIN (course INNER JOIN recipecourse ON course.courseid= recipecourse.courseid) ON recipe.recipeid = recipecourse.recipeid) INNER JOIN (cuisine INNER JOIN recipecuisine ON cuisine.cuisineid = recipecuisine.cuisineid) ON recipe.recipeid = recipecuisine.recipeid) INNER JOIN (ingredient INNER JOIN recipeingredient ON ingredient.ingredientid = recipeingredient.ingredientid) ON recipe.recipeid= recipeingredient.recipeid See how they're nested? This is one area where I think that joining in the where clause instead of the from clause is easier and less confusing. The same thing could be done as: FROM recipe r, recipecourse rc, course c, cuisine cu, recipecuisine rcu, ingredient i, recipeingredient ri WHERE r.recipeid = rc.recipeid AND rc.courseid = c.courseid AND r.recipeid = rcu.recipeid AND rcu.cuisineid = cu.cuisineid AND r.recipeid = ri.recipeid AND ri.ingredientid = i.ingredientid ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222553 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: FlashForm
I assume that actionscript function will run on the client but subsequent query has to run on the server. if I could run the query in advance, turn the query into arrays, and make them available to my actionscript. then how can I filter that query later based on the Situation above? Can somebody provide some sample codes? -- Regards, ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222554 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: FlashForm
If this is HTML you will have to post back to your page so that ColdFusion knows what (var) is , if it's a self contained flash form then you just need to grab the var and do a flash remoting call since flash already knows what (var) is. ColdFusion has no idea what (var) is because you're on the client machine. Bob ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222555 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
MINUS and INTERSECT support for query of queries
Hi, It looks like you can do an UNION in a query of queries with ColdFusion MX 6.1, while MINUS and INTERSECT are not supported. Is this a known limitation? What about ColdFusion MX 7? Thanks. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222556 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: FlashForm
With remoting your function will submit a call back to coldfusion which will then send your query back into a structure that actionscipt can read. You then would have your values available in Flash and when you would need to go back and do another query could just do another remoting call. I don't have any sample code to send, but if you do a google search shouldn't take you more than 5 minutes to find some useful code. Bob ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222557 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
printing
HI, I'm looking to develop an intranet app, that will print a browser page without the number of prints etc window appearing. I have access to client browser if that helps anyone done anything similar ?? ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222558 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: MINUS and INTERSECT support for query of queries
From: wolf2k5 [mailto:[EMAIL PROTECTED] It looks like you can do an UNION in a query of queries with ColdFusion MX 6.1, while MINUS and INTERSECT are not supported. Is this a known limitation? What about ColdFusion MX 7? QoQ doesn't support all the operators http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/h tml/wwhelp.htm?context=ColdFusion_Documentationfile=1265.htm ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222559 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: FlashForm
thanks for your help, I have a strong concept of remoting. so, I can write something up. What I was wondering that I was using the following cfgrid name=tracking height=250 visible=no Now that not gonna work becuase that query will generate dynamically from remoting call. How can I assign the query object which is received by the Flash Remoting? I tried myGrid.query = myService.getCRM(id.text); Didn't work Does anybody?? -- Regards, Asim Manzur ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222560 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Inline frames a good alternative for creating web applications?
If you are going to do AJAX or DHTML stuff, there really is no point to using IFRAMEs. You can pretty much stick to DIVs. M!ke -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Thursday, October 27, 2005 11:01 PM To: CF-Talk Subject: RE: Inline frames a good alternative for creating web applications? So...use an iframe instead of a div or place the iframe in the div? Rick ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222561 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: email code in cfc
It would probably make better sense to have an emailer-type CFC that you pass into another CFC. Not that I always make sense, but that would keep the details of CFMAIL from the other CFCs. M!ke -Original Message- From: John C. Bland II [mailto:[EMAIL PROTECTED] Sent: Thursday, October 27, 2005 11:28 PM To: CF-Talk Subject: Re: email code in cfc I've been doing it for years but it doesn't mean its right. :-) It definitely works and I don't seen any reason why you wouldn't/shouldn't. On 10/27/05, dave [EMAIL PROTECTED] wrote: what the limitations of running cfmail in a cfc? any? at all? ~Dave the disruptor~ Some people just don't appreciate how difficult it is to dispense wisdom and abuse at the same time. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222562 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: spam scoring
If you want a free solution then you can install perl and spamassassin and use cfexecute to call spamassassin (I've done this in the past and it does work). If you want an easier solution and are running on Windows then you could try PrismAS - http://www.coolfusion.com/Products/PrismAS/index.cfm PrismAS (which is based on spamassassin) runs as a service that can be queried via tcp/ip and is far quicker and far easier to set up than using the cfexecute method mentioned above. Regards, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server PrismAV - Virus scanning for ColdFusion and BlueDragon applications Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm iMS-Lite - the completely free mail server solution for applications and application servers http://www.coolfusion.com/iMSLite --- On Friday, October 28, 2005 2:50 AM, Kay Smoljak scribed: --- I have a newsletter blast out system for my clients... and I'd like to build in a spam-scoring system so that the clients can check their newsletters before they send them. A support organisation had an interesting time recently when they mentioned breast cancer month. Does anyone know of any code that's available to do this? Maybe a custom tag or CFC or something? Thanks! ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222563 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: printing
From: Simon Smith [mailto:[EMAIL PROTECTED] I'm looking to develop an intranet app, that will print a browser page without the number of prints etc window appearing. I have access to client browser if that helps Luckily it is not possible to print something without the printer dialogue, that is, user interaction. If it were your, printer tray would have more spam than your email inbox. I do recall some vbscript that you could use to do this, but that was awhile back and limits you to IE ActiveX. Mike ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222564 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: printing
Can't be done. If you are printing via the web it will always popup the Printer Dialog. -Original Message- From: Simon Smith [mailto:[EMAIL PROTECTED] Sent: 28 October 2005 14:39 To: CF-Talk Subject: printing HI, I'm looking to develop an intranet app, that will print a browser page without the number of prints etc window appearing. I have access to client browser if that helps anyone done anything similar ?? ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222565 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Inline frames a good alternative for creating web applications?
Thanks for the tip, Michael... Rick -Original Message- From: Dawson, Michael [mailto:[EMAIL PROTECTED] Sent: Friday, October 28, 2005 9:47 AM To: CF-Talk Subject: RE: Inline frames a good alternative for creating web applications? If you are going to do AJAX or DHTML stuff, there really is no point to using IFRAMEs. You can pretty much stick to DIVs. M!ke -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Thursday, October 27, 2005 11:01 PM To: CF-Talk Subject: RE: Inline frames a good alternative for creating web applications? So...use an iframe instead of a div or place the iframe in the div? Rick ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222566 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: formatting a date in cfgrid
Upgrade to 7.0.1, we fixed some bugs in cfgrid in the updater. I think this was fixed as well. ---nimer -Original Message- From: Jean-Baptiste Emanuel Zorg [mailto:[EMAIL PROTECTED] Sent: Monday, October 24, 2005 8:48 AM To: CF-Talk Subject: Re: formatting a date in cfgrid thanks for the examples.. by backend.. i meant the sql.. i consider front end my display.. as for the code.. i am populating a grid via flash remoting. cfgridcolumn name=feedDate header=Feed Date mask=, MMM. D, at H:NN A/ that is all there is... On 10/24/05, Bobby Hartsfield [EMAIL PROTECTED] wrote: Well it is still front end really. Alan doesn't mean insert the date into the database already formatted in any special way; He means SELECT it in the desired format so you don't need to format it anywhere else. In MySql for example... SELECT DATE_FORMAT(DateField, '%W, %M %D, %Y'); Would give you the date formatted like this straight from your query and all you'd need to do was output it... 'Sunday, October 24th, 2005' You could use datepart() or convert() to get 'basically' the same thing from SQL Server (I'm not sure SQL server has anything for Nth day though) Believe it or not, even MS Access comes equipped with some date functions :^O That's probably enough to fix you up but if you have any trouble just let us know the date/time format you are looking for and what database you are using. Ps... In CF, the mask is the last option in the function like... Dateformat(mydate, mm dd ) And not the first like... Dateformat(mm dd , mydate) When I started writing .NET apps I was very used to CF's XFormat() functions where the mask was always last. The mask comes first in VB's date formatter and when I put it last, the mask was actually displayed like you're descriing. I THINK CF would throw an error if it were backwards but it's worth checking. Just seems very odd that it displays the mask. You might also consider posting the bit of code that is displaying the mask so everyone can take a look. ..:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Jean-Baptiste Emanuel Zorg [mailto:[EMAIL PROTECTED] Sent: Sunday, October 23, 2005 11:32 PM To: CF-Talk Subject: Re: formatting a date in cfgrid it's just a regular date/time field always figured i could do it on the front end somehow.. i'll give that a lookig into though.. thanks On 10/23/05, Alan Rother [EMAIL PROTECTED] wrote: This is just totally off the cuff here... But if you can't get CF to do it right off, you could have your DB do it. Just apply a date mask to it in the query. Most DB systems allow you to do this. HTH Alan Rother Macromedia Certified Advanced ColdFusion MX 7 Developer On 10/23/05, Jean-Baptiste Emanuel Zorg [EMAIL PROTECTED] wrote: i have a date that is populating a field in a grid like this: Tue Oct 18 21:25:48 GMT-0400 2005 i have attempted to use mask= D, but all it does is output the mask to the field.. any ideas how to mask this? thanks ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222567 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: printing
From: Simon Smith [mailto:[EMAIL PROTECTED] I'm looking to develop an intranet app, that will print a browser page without the number of prints etc window appearing. I have access to client browser if that helps Luckily it is not possible to print something without the printer dialogue, that is, user interaction. If it were your, printer tray would have more spam than your email inbox. I do recall some vbscript that you could use to do this, but that was awhile back and limits you to IE ActiveX. Mike IE ActiveX sound like the right combo, thanks will look into it Cheers Simon ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222568 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: formatting a date in cfgrid
Upgrade to 7.0.1, we fixed some bugs in cfgrid in the updater. I think this was fixed as well. ---nimer ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222569 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: printing
I have successfully used an ActiveX object called ScriptX (just Google it). They have a limited freeby and a more robust one for cost. This was using CF5 for an internal Work Order app where getting a quality printed Work Order was a pain in the butt. In this case it really needed to be printed in Landscape, which, of course, is never the default for any user. In my case, the page will print upon loading in a hidden iframe and I control Orientation, Margins, Header, and Footer. It has worked great, but I'm in an environment where IE is the standard. Now that I have CF 7, I will use cfdocument and spit out pdf's instead. Terry HI, I'm looking to develop an intranet app, that will print a browser page without the number of prints etc window appearing. I have access to client browser if that helps anyone done anything similar ?? ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222570 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CF based Flash Detection
AM in a super tight pinchI know how to detect flash via javascript...and then output the results in document.write method...but it seems not to be working for huge amounts of text. Is there a tag somewhere or a cf based routine to help with this? Thanks! Eric ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222571 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: MySQL DSN
-Original Message- From: Snake [mailto:[EMAIL PROTECTED] Create a MySQL DSN, put the username password into the DSN and it works fine. Pass the username/password in the code and it doesn't work. Which version of MySQL? What was the GRANT statement used to give permissions to the user? -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 #include stdjoke.h ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222572 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF based Flash Detection
http://www.macromedia.com/software/flashplayer/download/detection_kit/ HTH, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server PrismAV - Virus scanning for ColdFusion and BlueDragon applications Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm iMS-Lite - the completely free mail server solution for applications and application servers http://www.coolfusion.com/iMSLite --- On Friday, October 28, 2005 11:05 AM, Eric Hoffman scribed: --- AM in a super tight pinchI know how to detect flash via javascript...and then output the results in document.write method...but it seems not to be working for huge amounts of text. Is there a tag somewhere or a cf based routine to help with this? Thanks! Eric ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222573 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CF Session vars timing out at different times
hi anyone have experience of session variables timing out at different times? for example, session.currUserID is defined and set, but session.currUserName has become undefined in session also, this only causes and error if we are using a cfexeption to catch errors and politely inform the user that an email has been sent to the tech team - when we turn this error trap off, the pages load with no exception (this is the bit that is really freaking us out) i realise that one way round this is to only store the currUserID and get the rest of the info from a Db but i would like to understand it rather than just evade it many thanks best regards howard -- Web Designer Accent Design Group Ltd The Studio, Adam Eve Yard 94B St Benedicts Street Norwich Norfolk NR2 4AB +44 (0) 1603 766062 http://www.accentdesign.co.uk ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222574 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF based Flash Detection
cf is in the wrong place...cf is server remember, not client...flash is client :) AM in a super tight pinchI know how to detect flash via javascript...and then output the results in document.write method...but it seems not to be working for huge amounts of text. Is there a tag somewhere or a cf based routine to help with this? Thanks! Eric ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222575 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
cfhttp timeout
So I know I need to set a timeout for a cfhttp, but I'm not sure what to do if a timeout does occur. Here's what I've got now: cfhttp url=#feedUrl# method=get timeout=3/ cfif cfhttp.errorDetail eq /cfif Do I need to have the cfif to make sure I don't have a timeout, or do I just use the cfhttp results assuming they're there (and the CF server takes care of the missing data cases)? All of the examples I found online didn't have a cfif after the cfhttp. TIA This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A1. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222576 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cfhttp timeout
Wrap it with a CFTRY and then CFCATCH the error. In CFHTTP set THROWONERROR=YES. I'm not sure what type of exception is thrown, but you can find that easily by CFDUMPing the CFCATCH structure. M!ke -Original Message- From: Munson, Jacob [mailto:[EMAIL PROTECTED] Sent: Friday, October 28, 2005 11:05 AM To: CF-Talk Subject: cfhttp timeout So I know I need to set a timeout for a cfhttp, but I'm not sure what to do if a timeout does occur. Here's what I've got now: cfhttp url=#feedUrl# method=get timeout=3/ cfif cfhttp.errorDetail eq /cfif Do I need to have the cfif to make sure I don't have a timeout, or do I just use the cfhttp results assuming they're there (and the CF server takes care of the missing data cases)? All of the examples I found online didn't have a cfif after the cfhttp. TIA ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222577 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cfhttp timeout
That's a good idea. The problem I'm having is actually getting a timeout for testing. I spent a long time last night trying to find a URL that would timeout, and wouldn't you know it if the Internet works PERFECTLY the one time I actually want it to fail. :) -Original Message- From: Dawson, Michael [mailto:[EMAIL PROTECTED] Sent: Friday, October 28, 2005 10:12 AM To: CF-Talk Subject: RE: cfhttp timeout Wrap it with a CFTRY and then CFCATCH the error. In CFHTTP set THROWONERROR=YES. I'm not sure what type of exception is thrown, but you can find that easily by CFDUMPing the CFCATCH structure. M!ke -Original Message- From: Munson, Jacob [mailto:[EMAIL PROTECTED] Sent: Friday, October 28, 2005 11:05 AM To: CF-Talk Subject: cfhttp timeout So I know I need to set a timeout for a cfhttp, but I'm not sure what to do if a timeout does occur. Here's what I've got now: cfhttp url=#feedUrl# method=get timeout=3/ cfif cfhttp.errorDetail eq /cfif Do I need to have the cfif to make sure I don't have a timeout, or do I just use the cfhttp results assuming they're there (and the CF server takes care of the missing data cases)? All of the examples I found online didn't have a cfif after the cfhttp. TIA [INFO] -- Access Manager: This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A2 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222578 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Time Block
Hi. I trying create a function in this format: IsBlockedTime(startdayofweek,starthour, startminute, enddayofweek, endhour,endminute) This will compare the current date and time to the parameters passed through the function, and return a boolean. Basically, I am trying to stop my users from accessing certain pages between Friday 10 am to Monday 8 am. I want to create a function so that in future I can change those start and end timings. A CFC can do it. Any ideas? - Ken ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222579 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
File Upload Tool
Hi, My memory has failed but I seem to recall a comprehensive upload tool being made available by one generous contributor here a while ago - file type restrictions, overwrites + much more good functionality. I had thought that it was set up as a project on CFLIB but I can't find any sign there. Can any one help with a pointer? Thanks ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222580 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: File Upload Tool
Is this what you are looking for? http://cfopen.org/projects/cffm/ Steve Bryant. Bryant Web Consulting LLC http://www.BryantWebConsulting.com/ http://steve.coldfusionjournal.com/ Hi, My memory has failed but I seem to recall a comprehensive upload tool being made available by one generous contributor here a while ago - file type restrictions, overwrites + much more good functionality. I had thought that it was set up as a project on CFLIB but I can't find any sign there. Can any one help with a pointer? Thanks ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222581 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: FlashForm
http://www.asfusion.com/blog/entry/consuming-a-web-service-through-flash Take also a look at some other posts from them, they got everything you need to work with cfform and flash remoting On 10/28/05, Asim Manzur [EMAIL PROTECTED] wrote: thanks for your help, I have a strong concept of remoting. so, I can write something up. What I was wondering that I was using the following cfgrid name=tracking height=250 visible=no Now that not gonna work becuase that query will generate dynamically from remoting call. How can I assign the query object which is received by the Flash Remoting? I tried myGrid.query = myService.getCRM(id.text); Didn't work Does anybody?? -- Regards, Asim Manzur ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222582 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Unusual Image Rotation Request
I see that many of the image manipulation tools can rotate images 90, 180 degrees etc. I am looking to rotate an image an arbitrary amount, perhaps 35 or 68 degrees for example. This would give me a larger rectangular image than the one that I started off from, with the corners of rotated image defining the boundaries. Alternatively. Does anyone have any suggestion how I might achieve this 'angled image' on a web page without manipulating the image file? Many thanks, ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222583 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: File Upload Tool
Is this what you are looking for? Yes, that's the one. Thanks ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222584 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: spam scoring
Since the majority of mail is caught through non pattern based filtering you'll have a difficult time with this. Very few filters weigh out of the box on keywords. It's just not effective past pharm, enlargement, mortgage and cheap software. The easiest way to avoid spam is to have a proper server sending the mail. This means valid headers, reverse DNS, resolving HELO back to the server IP and not using a smarthost/gateway setup. On pattern matching. Avoid Base64! ;) Avoid a space count past 5 in the subject, no html comments, no % symbols within the html itself. Effective spam setups are also weighing the time sent now. Friday-Sunday and mail not sent between 8:00AM and 6:00PM. Our servers receive well over 100,000 emails a day with a 98% catch rate and less than 1/10th of 1% false positive rate. We do all of this without keyword rating and very few pattern matches. Emmet -Original Message- From: Kay Smoljak [mailto:[EMAIL PROTECTED] Sent: Friday, October 28, 2005 2:50 AM To: CF-Talk Subject: spam scoring I have a newsletter blast out system for my clients... and I'd like to build in a spam-scoring system so that the clients can check their newsletters before they send them. A support organisation had an interesting time recently when they mentioned breast cancer month. Does anyone know of any code that's available to do this? Maybe a custom tag or CFC or something? Thanks! -- Kay Smoljak http://kay.zombiecoder.com/ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222585 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Unusual Image Rotation Request
I'd wager that adding arbitrary rotation angles would be pretty trvial to your choice of image manipulators, as long as you can get the source. Even if you can't get the source, a wrapper/extension should be able to package the functionality pretty easily. The trick is that you'll have to explicitly do the resize before you do the rotation (i.e. do some math to figure out the new dimensions, and call resize), but that's simple stuff. cheers, barneyb On 10/28/05, Peter Shaw [EMAIL PROTECTED] wrote: I see that many of the image manipulation tools can rotate images 90, 180 degrees etc. I am looking to rotate an image an arbitrary amount, perhaps 35 or 68 degrees for example. This would give me a larger rectangular image than the one that I started off from, with the corners of rotated image defining the boundaries. Alternatively. Does anyone have any suggestion how I might achieve this 'angled image' on a web page without manipulating the image file? Many thanks, -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222586 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Create XML for download
I need to create an XML file version of the contents of a report which a user can choose to download. How do I provide a link for that date/file? Will a normal WEB link work? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222587 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Unusual Image Rotation Request
You could also do it Flash. !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Friday, October 28, 2005 11:59 AM To: CF-Talk Subject: Re: Unusual Image Rotation Request I'd wager that adding arbitrary rotation angles would be pretty trvial to your choice of image manipulators, as long as you can get the source. Even if you can't get the source, a wrapper/extension should be able to package the functionality pretty easily. The trick is that you'll have to explicitly do the resize before you do the rotation (i.e. do some math to figure out the new dimensions, and call resize), but that's simple stuff. cheers, barneyb On 10/28/05, Peter Shaw [EMAIL PROTECTED] wrote: I see that many of the image manipulation tools can rotate images 90, 180 degrees etc. I am looking to rotate an image an arbitrary amount, perhaps 35 or 68 degrees for example. This would give me a larger rectangular image than the one that I started off from, with the corners of rotated image defining the boundaries. Alternatively. Does anyone have any suggestion how I might achieve this 'angled image' on a web page without manipulating the image file? Many thanks, -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222588 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Create XML for download
You'll need to use cfheader/content to force the download otherwise it will display in the browser. e -Original Message- From: Wally Randall [mailto:[EMAIL PROTECTED] Sent: Friday, October 28, 2005 1:05 PM To: CF-Talk Subject: Create XML for download I need to create an XML file version of the contents of a report which a user can choose to download. How do I provide a link for that date/file? Will a normal WEB link work? ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222589 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Create XML for download
No, it will be viewed in the browser, not prompt for download. You could zip it and link to that or look into forced downloads with cfcontent. ..:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Wally Randall [mailto:[EMAIL PROTECTED] Sent: Friday, October 28, 2005 1:05 PM To: CF-Talk Subject: Create XML for download I need to create an XML file version of the contents of a report which a user can choose to download. How do I provide a link for that date/file? Will a normal WEB link work? ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222590 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cfhttp timeout
Create a broken-page simulator by creating a new CF page, then adding the Sleep() function (link below) to make your page unavailable for a lengthy amount of time. Call this page with CFHTTP and then catch the timeout errors. You can then simulate a failure of any time period you choose. http://www.cflib.org/udf.cfm?ID=959 M!ke -Original Message- From: Munson, Jacob [mailto:[EMAIL PROTECTED] Sent: Friday, October 28, 2005 11:21 AM To: CF-Talk Subject: RE: cfhttp timeout That's a good idea. The problem I'm having is actually getting a timeout for testing. I spent a long time last night trying to find a URL that would timeout, and wouldn't you know it if the Internet works PERFECTLY the one time I actually want it to fail. :) -Original Message- From: Dawson, Michael [mailto:[EMAIL PROTECTED] Sent: Friday, October 28, 2005 10:12 AM To: CF-Talk Subject: RE: cfhttp timeout Wrap it with a CFTRY and then CFCATCH the error. In CFHTTP set THROWONERROR=YES. I'm not sure what type of exception is thrown, but you can find that easily by CFDUMPing the CFCATCH structure. M!ke -Original Message- From: Munson, Jacob [mailto:[EMAIL PROTECTED] Sent: Friday, October 28, 2005 11:05 AM To: CF-Talk Subject: cfhttp timeout So I know I need to set a timeout for a cfhttp, but I'm not sure what to do if a timeout does occur. Here's what I've got now: cfhttp url=#feedUrl# method=get timeout=3/ cfif cfhttp.errorDetail eq /cfif Do I need to have the cfif to make sure I don't have a timeout, or do I just use the cfhttp results assuming they're there (and the CF server takes care of the missing data cases)? All of the examples I found online didn't have a cfif after the cfhttp. TIA ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222591 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Time Block
Hi. I trying create a function in this format: IsBlockedTime(startdayofweek,starthour, startminute, enddayofweek, endhour,endminute) This should be simple... Once you have the values, create datetime objects using createDateTime() and then use the DateDiff() function against those and now() to determine if it is in range. Return value as needed. -Justin Scott ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222592 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
WAY OT: Configuring FCKEditor
I need to configure FCKEditor to upload images into a non-default folder, but I have no idea where to change this setting. I've looked on the support website, but I can't find it. Might anybody here know where I can do this? (sorry for the OT and the cross post) Thanks Matt Small ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222593 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
debugging complaint
Hey All, You know it just hit me that CF debugging could be so much more informative in certain situations...and I wonder if anyone can tell me why it isn't?? ;-) Here's a great example to do with CFCs Pass an argument of type numeric to a method (but the value passed is not numeric). So we get the standard argument XYZ passed to method ABC is not of type numeric. OK...so at least we know we've passed something inappropriate...but what the heck is so hard about stating what was actually passed!!!??? ;-) In the above situation you then have to go and add a cfdump to see what exactly is getting passed to the method...yet another time waster that on the surface seems pretty dang easy to add to debugging output. OK...rant's over...thanks for listening...and if anyone can explain whyy this would be hard to add...lemme know ;-) Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222594 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: WAY OT: Configuring FCKEditor
(for versiion 2.1.1) /FCKEditor/editor/filemanager/browser/default/connectors/cfm/config.cfm Lines 9 11 Good Luck! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222595 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: debugging complaint
I don't know if it's the answer you seek... but have you looked at Ray's Starfish? (there's a question i never pictured myself asking). http://ray.camdenfamily.com/index.cfm/2005/10/24/Starfish-ColdFusion-Debugger-Version-0-Released On 10/28/05, Bryan Stevenson [EMAIL PROTECTED] wrote: Hey All, You know it just hit me that CF debugging could be so much more informative in certain situations...and I wonder if anyone can tell me why it isn't?? ;-) Here's a great example to do with CFCs Pass an argument of type numeric to a method (but the value passed is not numeric). So we get the standard argument XYZ passed to method ABC is not of type numeric. OK...so at least we know we've passed something inappropriate...but what the heck is so hard about stating what was actually passed!!!??? ;-) In the above situation you then have to go and add a cfdump to see what exactly is getting passed to the method...yet another time waster that on the surface seems pretty dang easy to add to debugging output. OK...rant's over...thanks for listening...and if anyone can explain whyy this would be hard to add...lemme know ;-) Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222596 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: debugging complaint
Tried, but couldn't get the mirror in the right position to see anything. :) Ray Charlie Griefer wrote: I don't know if it's the answer you seek... but have you looked at Ray's Starfish? (there's a question i never pictured myself asking). http://ray.camdenfamily.com/index.cfm/2005/10/24/Starfish-ColdFusion-Debugger-Version-0-Released On 10/28/05, Bryan Stevenson [EMAIL PROTECTED] wrote: Hey All, You know it just hit me that CF debugging could be so much more informative in certain situations...and I wonder if anyone can tell me why it isn't?? ;-) Here's a great example to do with CFCs Pass an argument of type numeric to a method (but the value passed is not numeric). So we get the standard argument XYZ passed to method ABC is not of type numeric. OK...so at least we know we've passed something inappropriate...but what the heck is so hard about stating what was actually passed!!!??? ;-) In the above situation you then have to go and add a cfdump to see what exactly is getting passed to the method...yet another time waster that on the surface seems pretty dang easy to add to debugging output. OK...rant's over...thanks for listening...and if anyone can explain whyy this would be hard to add...lemme know ;-) Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222597 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: debugging complaint
Yeah I'll have to sneek a peak at Ray's Starfish ;-) but I guess I'm really wondering why MM doesn't add something that seems so simple? Thanks Charlie Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222598 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: debugging complaint
Tried, but couldn't get the mirror in the right position to see anything. :) Ray Yep it's Friday alright ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222599 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: debugging complaint
From: Ray Champagne [mailto:[EMAIL PROTECTED] Tried, but couldn't get the mirror in the right position to see anything. :) LOL. That's because you are too busy watching your neighbor try on her new purchases (head over to cf-community for the rest of the story) :-) ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222600 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: WAY OT: Configuring FCKEditor
Thanks man I figured a solution to my problem. I needed to have image upload on one domain, but the files displayed on another. I ended up mapping virtual directory and that solved my problem. Thanks for your help, Matt Small -Original Message- From: Jay Greer [mailto:[EMAIL PROTECTED] Sent: Friday, October 28, 2005 2:39 PM To: CF-Talk Subject: Re: WAY OT: Configuring FCKEditor (for versiion 2.1.1) /FCKEditor/editor/filemanager/browser/default/connectors/cfm/config.cfm Lines 9 11 Good Luck! ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222601 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
mutliple instance installation tutorial
Anyone know of a good step by step tutorial on installing CF muliple instances? -mark Mark A. Kruger, CFG, MCSE www.cfwebtools.com www.necfug.com http://mkruger.cfwebtools.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222602 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: debugging complaint
Should it also look at the code in question and try to fix it for you? Should it suggest a page in the CFWACK where you can read about this particular error? How about if it included a quick-link which would automatically send a message to the HOF message board to ask others how to fix it? Maybe it should try and console you at the same time to make sure that you know it's really not your fault and you really are a good person... I am, of course, only messing with you here Bryan. However, I do think that this is one of those sort of, just how much IS enough type of things. CF's error messages and debugging, in my opinion, are infinitely better than most languages/software. --Ferg Bryan Stevenson wrote: Hey All, You know it just hit me that CF debugging could be so much more informative in certain situations...and I wonder if anyone can tell me why it isn't?? ;-) Here's a great example to do with CFCs Pass an argument of type numeric to a method (but the value passed is not numeric). So we get the standard argument XYZ passed to method ABC is not of type numeric. OK...so at least we know we've passed something inappropriate...but what the heck is so hard about stating what was actually passed!!!??? ;-) In the above situation you then have to go and add a cfdump to see what exactly is getting passed to the method...yet another time waster that on the surface seems pretty dang easy to add to debugging output. OK...rant's over...thanks for listening...and if anyone can explain whyy this would be hard to add...lemme know ;-) Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222603 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: mutliple instance installation tutorial
The documentation on CF Admin has an installing pdf, as well as a configuring cf pdf. I found these to have wonderful information in them. I suspect that the step by step instructions in them will be exactly what you need. simeon On 10/28/05, Mark A Kruger [EMAIL PROTECTED] wrote: Anyone know of a good step by step tutorial on installing CF muliple instances? -mark Mark A. Kruger, CFG, MCSE www.cfwebtools.com http://www.cfwebtools.com www.necfug.com http://www.necfug.com http://mkruger.cfwebtools.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222604 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
java equivalent of cffile
I know this has been covered but I don't know what phrase to search for exactly so here we are. How can I do CFFILE-like actions (create, overwrite, delete) within cfscript? I'm sure I can use the built-in Java functionality but I don't know what that is. TIA Paul ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222605 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: debugging complaint
CF's error messages and debugging, in my opinion, are infinitely better than most languages/software. amen. We dont often realise how good we have it. -- Ryan Guill BlueEyesDevelopment [EMAIL PROTECTED] www.ryanguill.com (270) 217.2399 got google talk? Chat me at [EMAIL PROTECTED] The Coldfusion Open Application Library - COAL - http://coal.ryanguill.com www.ryanguill.com/ The Roman Empire: www.ryanguill.com/blog/ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222606 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: debugging complaint
I am, of course, only messing with you here Bryan. However, I do think that this is one of those sort of, just how much IS enough type of things. CF's error messages and debugging, in my opinion, are infinitely better than most languages/software. --Ferg It's Friday...I'd expect nothing less ;-) Yeah...with the example I gave it just seems like a no-brainer to add...if ya know it's not the right data type...you must know what the value passed was...so just tell me!! ;-) Certainly not looking to open the how far should we go thread... I like this idea though How about if it included a quick-link which would automatically send a message to the HOF message board to ask others how to fix it? Now that would be sweet!! Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222607 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: debugging complaint
yep...so much better...it makes me laugh everytime I see a .NET error...like reading a foreign language Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222608 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: java equivalent of cffile
The stupid simple answer I came up with in seeing your questions, was why not just write a couple cffunctions to wrap cffile so you can access it from script? I am probably missing something, but thats where I would look first. simeon On 10/28/05, Paul [EMAIL PROTECTED] wrote: I know this has been covered but I don't know what phrase to search for exactly so here we are. How can I do CFFILE-like actions (create, overwrite, delete) within cfscript? I'm sure I can use the built-in Java functionality but I don't know what that is. TIA Paul ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222609 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: debugging complaint
-Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Friday, October 28, 2005 2:36 PM To: CF-Talk Subject: debugging complaint Hey All, You know it just hit me that CF debugging could be so much more informative in certain situations...and I wonder if anyone can tell me why it isn't?? ;-) Here's a great example to do with CFCs Pass an argument of type numeric to a method (but the value passed is not numeric). So we get the standard argument XYZ passed to method ABC is not of type numeric. OK...so at least we know we've passed something inappropriate...but what the heck is so hard about stating what was actually passed!!!??? ;-) I think the simple answer is that it's harder than it appears. What if the value is confidential - you'd really need an option to display values or not (some people still dump errors to the page or to comments). There are already issues like this with some error cases (SQL errors for example) that people have complained about in the past (which is one reason that the debugging settings have continually gotten more complex). What if the value passed isn't a simple value? Do you dump a potentially huge amount of information to the screen? What if the value is a simple value but is, say, several pages of text? Do you dump the whole thing? Just some of it? How much of it? There's also the simple fact that the more complex you make error reporting the more likely it is that the error reporting itself will encounter errors... and then things just go straight to hell. ;^) I'm not saying that things can't be better... but I also can see how they may be harder than they appear to be. Jim Davis ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222610 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: debugging complaint
and what's even better is a gool ole Oracle error Error ORA-00060 What, that's it? Really? Are you serious? I can't get ANY more insight than that? I mean, you had to notice that it was a deadlock and then look up the code in the internal database. So it was actually MORE difficult to show me the useless error message than it would have been to say, deadlock. CF is really great in this area. --Ferg Bryan Stevenson wrote: yep...so much better...it makes me laugh everytime I see a .NET error...like reading a foreign language Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222611 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: debugging complaint
Some good points Jim,...thanks...good points to ponder for sure.. Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222612 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: java equivalent of cffile
I had the same thought, but was curious to learn a little more about how Java works. But I did find the wrapper functions already written on cflib.org so maybe I'll just do that... -Original Message- From: Simeon Bateman [mailto:[EMAIL PROTECTED] Sent: Friday, October 28, 2005 1:39 PM To: CF-Talk Subject: Re: java equivalent of cffile The stupid simple answer I came up with in seeing your questions, was why not just write a couple cffunctions to wrap cffile so you can access it from script? I am probably missing something, but thats where I would look first. simeon On 10/28/05, Paul [EMAIL PROTECTED] wrote: I know this has been covered but I don't know what phrase to search for exactly so here we are. How can I do CFFILE-like actions (create, overwrite, delete) within cfscript? I'm sure I can use the built-in Java functionality but I don't know what that is. TIA Paul ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222613 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: MySQL DSN
MySQL 4.1.13 I dunno what the grant statement was as I use HELM or MySQL Administrator to create the databases. But I have the same MySQL 4.1.13 on another server which works fine with CFMX7. Russ -Original Message- From: Damien McKenna [mailto:[EMAIL PROTECTED] Sent: 28 October 2005 16:14 To: CF-Talk Subject: RE: MySQL DSN -Original Message- From: Snake [mailto:[EMAIL PROTECTED] Create a MySQL DSN, put the username password into the DSN and it works fine. Pass the username/password in the code and it doesn't work. Which version of MySQL? What was the GRANT statement used to give permissions to the user? -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 #include stdjoke.h ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222614 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: java equivalent of cffile
If you want to check out the java way, you can browse through java.IO.*, which has a lot of IO general classes including working with the file system, and when in doubt, google it. Generally speaking, you do something sort of like this: myFile = createObject(java,java.IO.File).init(c:\myfile.txt); myFile.createNewFile(); myFile.renameTo(createObject(java,java.IO.File).init(c:\myfile2.txt)); myFile.delete(); that's totally untested code, btw. Here's the javadoc link: http://java.sun.com/j2se/1.5.0/docs/api/java/io/File.html -nathan strutz http://www.dopefly.com/ On 10/28/05, Paul [EMAIL PROTECTED] wrote: I had the same thought, but was curious to learn a little more about how Java works. But I did find the wrapper functions already written on cflib.org so maybe I'll just do that... -Original Message- From: Simeon Bateman [mailto:[EMAIL PROTECTED] Sent: Friday, October 28, 2005 1:39 PM To: CF-Talk Subject: Re: java equivalent of cffile The stupid simple answer I came up with in seeing your questions, was why not just write a couple cffunctions to wrap cffile so you can access it from script? I am probably missing something, but thats where I would look first. simeon On 10/28/05, Paul [EMAIL PROTECTED] wrote: I know this has been covered but I don't know what phrase to search for exactly so here we are. How can I do CFFILE-like actions (create, overwrite, delete) within cfscript? I'm sure I can use the built-in Java functionality but I don't know what that is. TIA Paul ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222615 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
(Admin) Site move
AHPHosting (www.ahphosting.net), who has been providing hosting to House of Fusion and all related sites for the last number of years will be moving all of the House of Fusion hardware over to a new network center. This move will occur late tonight (Friday night). As I will not be on at the time due to religious observances, I will not be able to oversee everything. There should be no problems but if there are, I've asked a member of the community to 'look in' to make sure all is good. The disruption of service will not last very long as we have planned out all of the steps to get everything running again with no problems. Just a heads up. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222616 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Time Block
Even easier, once you have the dates just check to see if now() is A) GTE EndDateTime OR LTE StartDateTime B) GTE StartDateTime AND LTE EndDateTime A being true means grant access B being true means deny access StartDateTime being the time on Friday that you want to close out access and the EndDateTime being the time on Monday that you want to start granting access again. Of course you could just write a couple batch files (one to start the CF or IIS service(s) and one to stop them) then just use scheduled tasks to run them at your desired days/times. ..:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Justin D. Scott [mailto:[EMAIL PROTECTED] Sent: Friday, October 28, 2005 1:52 PM To: CF-Talk Subject: RE: Time Block Hi. I trying create a function in this format: IsBlockedTime(startdayofweek,starthour, startminute, enddayofweek, endhour,endminute) This should be simple... Once you have the values, create datetime objects using createDateTime() and then use the DateDiff() function against those and now() to determine if it is in range. Return value as needed. -Justin Scott ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222617 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: java equivalent of cffile
Yeah,
That will create a file, rename it and delete it.
File read and write operations are somewhat more involved.
You'll definitely be better off wrapping up the file operations in a
cffunction block, but if you really do want to find out some more about it,
here's some java code to read the contents of a file:
public String readFile(File input) {
BufferedReader in = null;
try {
StringBuffer buffer = new StringBuffer();
in = new BufferedReader(new FileReader(input));
String str;
while ((str = in.readLine()) != null) {
buffer.append(str + System.getProperty(line.separator));
}
in.close();
return buffer.toString();
} catch (FileNotFoundException e) {
System.out.println(Error! The file + input + could not be found.);
} catch (IOException e) {
System.out.println(Error! An IO Exception occurred.);
System.out.println(e.getMessage());
} finally {
try {
in.close();
} catch (IOException e) {
e.printStackTrace();
} catch (NullPointerException e) {
// something wasn't initialized, just ignore this error
}
}
return null;
}
Converting that lot to CF should keep you busy for a while ;-)
Spike
On 10/28/05, Nathan Strutz [EMAIL PROTECTED] wrote:
If you want to check out the java way, you can browse through
java.IO.*, which has a lot of IO general classes including working
with the file system, and when in doubt, google it. Generally
speaking, you do something sort of like this:
myFile = createObject(java,java.IO.File).init(c:\myfile.txt);
myFile.createNewFile();
myFile.renameTo(createObject(java,java.IO.File
).init(c:\myfile2.txt));
myFile.delete();
that's totally untested code, btw.
Here's the javadoc link:
http://java.sun.com/j2se/1.5.0/docs/api/java/io/File.html
-nathan strutz
http://www.dopefly.com/
On 10/28/05, Paul [EMAIL PROTECTED] wrote:
I had the same thought, but was curious to learn a little more about how
Java works. But I did find the wrapper functions already written on
cflib.org http://cflib.org so maybe I'll just do that...
-Original Message-
From: Simeon Bateman [mailto:[EMAIL PROTECTED]
Sent: Friday, October 28, 2005 1:39 PM
To: CF-Talk
Subject: Re: java equivalent of cffile
The stupid simple answer I came up with in seeing your questions, was
why
not just write a couple cffunctions to wrap cffile so you can access it
from
script?
I am probably missing something, but thats where I would look first.
simeon
On 10/28/05, Paul [EMAIL PROTECTED] wrote:
I know this has been covered but I don't know what phrase to search
for
exactly so here we are.
How can I do CFFILE-like actions (create, overwrite, delete) within
cfscript? I'm sure I can use the built-in Java functionality but I
don't
know what that is.
TIA
Paul
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222618
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cfhttp timeout
Another good idea! :) I just made a page with a cfloop that runs for a long time, and I was able to test my try/catch around cfhttp. -Original Message- From: Dawson, Michael [mailto:[EMAIL PROTECTED] Sent: Friday, October 28, 2005 11:16 AM To: CF-Talk Subject: RE: cfhttp timeout Create a broken-page simulator by creating a new CF page, then adding the Sleep() function (link below) to make your page unavailable for a lengthy amount of time. Call this page with CFHTTP and then catch the timeout errors. You can then simulate a failure of any time period you choose. http://www.cflib.org/udf.cfm?ID=959 M!ke This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A1. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222619 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: debugging complaint
Something else to consider. My starfish project handles debugging info, stuff like the time it took to do X. It does NOT handle erorrs. However... It IS possible to modify error behaviour. I've written to blog entries on this. This entry: http://ray.camdenfamily.com/index.cfm/2005/7/14/More-CFMX-Error-Modifications Tells you how ot make stack traces collapse in Firefox, like they do in IE. This entry: http://ray.camdenfamily.com/index.cfm/2005/10/4/Modifying-Exception-Templates-in-CFMX-701 Will make it so if you use a struct key that doesn't exist, the error will tell you which keys _do_ exist in the struct, which is VERY helpful. Ie, instead of, you can't do foo.goo, you get, you can't do foo.goo, but moo and zoo are valid keys. This is ALL something you do NOT want to do on a production server, but it may be of use to you. On 10/28/05, Bryan Stevenson [EMAIL PROTECTED] wrote: Some good points Jim,...thanks...good points to ponder for sure.. Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222620 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: debugging complaint
Thanks for the clarification and the tips Ray...much appreciated (one part of CF I've never really looked under the hood) ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222621 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: mutliple instance installation tutorial
I sort of just wrote one yesterday since the available resources are lacking or are written for CFMX 6.1. I would be glad to share what I did. I even installed CF7 Standard alongside CF7 Developer/Multiserver. M!ke -Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: Friday, October 28, 2005 2:20 PM To: CF-Talk Subject: mutliple instance installation tutorial Anyone know of a good step by step tutorial on installing CF muliple instances? -mark ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222622 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
OT - Complex SQL
Okay, I think it's because it is Friday at 4... can somebody help me
out?
SELECT table_1.expiry_date,
table_3.expiry_date
FROMtable_3
JOIN table_2 ON table_2.table2_key = table_3.tablel2_key
JOIN table_1 ON table_1.table1_key = table_2.table1_key
WHERE table_1.expiry_date = 'Dec 31, 2005'
AND table_3.expiry_date = 'Dec 31, 2005'
AND table_1.table_id IN ('value1,value2,value3')
This isn't returning results, and it should... where is my syntax
incorrect?
--
Jillian
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222623
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Problem in a Simple webservice: 1D array works 2D fails
Hi, Thanks to everyone for their help. Robert, I tried the settings suggested in the Axis Docs, but still No luck with the 2D Arrays. You were able to duplicated the problem on CFMX 6.1, Did you make the changes to server-config.wsdd and get 2DArrays to work? Thanks to everyone else for suggesting other data structures that work. I did some testing and there is no problem with Structs of Structs and other combinations, but the designer wants as simple and portable a solution as possible, so it's back to see what I can do to make the 2D Array work. Has anyone successfully build a webservice in Coldfusion that sends back a 2DArray, if so how did you get it to work? Thanks again Mackenzie Cosens -Original Message- From: Robert Munn [mailto:[EMAIL PROTECTED] Sent: Thursday, October 27, 2005 3:42 PM To: CF-Talk Subject: Re: Problem in a Simple webservice: 1D array works 2D fails I was able to replicate this error on CFMX 6.1. According to the Apache Axis documentation, 2D array support needs to be enabled through the global Axis config. See this document: http://ws.apache.org/axis/java/reference.html Note that 2d array support is disabled by default. Here is the relevant info: Global Axis Configuration The server is configured (by default) by values in the server-config.wsdd file, though a dedicated Axis user can write their own configuration handler, and so store configuration data in an LDAP server, database, remote web service, etc. Consult the source on details as to how to do that. You can also add options to the web.xml file and have them picked up automatically. We don't encourage that as it is nice to keep configuration stuff in one place. In the server-config file, there is a global configuration section, which supports parameter name/value pairs as nested elements. Here are the options that we currently document, though there may be more (consult the source, as usual). globalConfiguration parameter name=adminPassword value=admin/ parameter name=attachments.Directory value=c:\temp\attachments/ parameter name=sendMultiRefs value=true/ parameter name=sendXsiTypes value=true/ parameter name=attachments.implementation value=org.apache.axis.attachments.AttachmentsImpl/ parameter name=sendXMLDeclaration value=true/ parameter name=enable2DArrayEncoding value=true/ parameter name=dotNetSoapEncFix value=false/ /globalConfiguration ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222624 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT - Complex SQL
You need single quotes around each of your values in the IN clause.
snip
AND table_1.table_id IN ('value1','value2','value3')
/snip
The date formats may be wrong, too. Check the actual data in the
database and/or use createODBCDateTime() and definitely use
CFQUERYPARAM. It will make your job a bit eaiser.
Either way, I would remove the dates from your WHERE claus, fix the IN
clause, then run the query. See if you get any results with very
limited filtering, first.
Then, go from there and add more filtering as needed.
M!ke
-Original Message-
From: Jillian Koskie [mailto:[EMAIL PROTECTED]
Sent: Friday, October 28, 2005 5:12 PM
To: CF-Talk
Subject: OT - Complex SQL
Okay, I think it's because it is Friday at 4... can somebody help me
out?
SELECT table_1.expiry_date,
table_3.expiry_date
FROMtable_3
JOIN table_2 ON table_2.table2_key = table_3.tablel2_key
JOIN table_1 ON table_1.table1_key = table_2.table1_key
WHERE table_1.expiry_date = 'Dec 31, 2005'
AND table_3.expiry_date = 'Dec 31, 2005'
AND table_1.table_id IN ('value1,value2,value3')
This isn't returning results, and it should... where is my syntax
incorrect?
--
Jillian
~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222625
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT - Complex SQL
I don't know what DBMS you are using, but should you have quotes around
all of the values in your IN clause, like so:
AND table_1.table_id IN ('value1','value2','value3')
-Original Message-
From: Jillian Koskie [mailto:[EMAIL PROTECTED]
Sent: Friday, October 28, 2005 4:12 PM
To: CF-Talk
Subject: OT - Complex SQL
Okay, I think it's because it is Friday at 4... can somebody help me
out?
SELECTtable_1.expiry_date,
table_3.expiry_date
FROM table_3
JOIN table_2 ON table_2.table2_key = table_3.tablel2_key
JOIN table_1 ON table_1.table1_key = table_2.table1_key
WHERE table_1.expiry_date = 'Dec 31, 2005'
AND table_3.expiry_date = 'Dec 31, 2005'
AND table_1.table_id IN ('value1,value2,value3')
This isn't returning results, and it should... where is my syntax
incorrect?
[INFO] -- Access Manager:
This transmission may contain information that is privileged, confidential
and/or exempt from disclosure under applicable law. If you are not the
intended recipient, you are hereby notified that any disclosure, copying,
distribution, or use of the information contained herein (including any
reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in
error, please immediately contact the sender and destroy the material in its
entirety, whether in electronic or hard copy format. Thank you. A2
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222626
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT - Complex SQL
AND table_1.table_id IN ('value1','value2','value3')
try that
On 10/28/05, Jillian Koskie [EMAIL PROTECTED] wrote:
Okay, I think it's because it is Friday at 4... can somebody help me
out?
SELECT table_1.expiry_date,
table_3.expiry_date
FROMtable_3
JOIN table_2 ON table_2.table2_key = table_3.tablel2_key
JOIN table_1 ON table_1.table1_key = table_2.table1_key
WHERE table_1.expiry_date = 'Dec 31, 2005'
AND table_3.expiry_date = 'Dec 31, 2005'
AND table_1.table_id IN ('value1,value2,value3')
This isn't returning results, and it should... where is my syntax
incorrect?
--
Jillian
~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222627
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT - Complex SQL
You're so right... Anybody happen to now offhand (I'm off to search
after I send this message) what the date format is for DB2?
I'm just running this at the command line, so no need for any CF
stuffs... But unfortuantely also can't take advantage of CF stuffs.
-Original Message-
From: Dawson, Michael [mailto:[EMAIL PROTECTED]
Sent: Friday, October 28, 2005 4:16 PM
To: CF-Talk
Subject: RE: OT - Complex SQL
You need single quotes around each of your values in the IN clause.
snip
AND table_1.table_id IN ('value1','value2','value3')
/snip
The date formats may be wrong, too. Check the actual data in the
database and/or use createODBCDateTime() and definitely use
CFQUERYPARAM. It will make your job a bit eaiser.
Either way, I would remove the dates from your WHERE claus, fix the IN
clause, then run the query. See if you get any results with very
limited filtering, first.
Then, go from there and add more filtering as needed.
M!ke
-Original Message-
From: Jillian Koskie [mailto:[EMAIL PROTECTED]
Sent: Friday, October 28, 2005 5:12 PM
To: CF-Talk
Subject: OT - Complex SQL
Okay, I think it's because it is Friday at 4... can somebody help me
out?
SELECT table_1.expiry_date,
table_3.expiry_date
FROMtable_3
JOIN table_2 ON table_2.table2_key = table_3.tablel2_key
JOIN table_1 ON table_1.table1_key = table_2.table1_key
WHERE table_1.expiry_date = 'Dec 31, 2005'
AND table_3.expiry_date = 'Dec 31, 2005'
AND table_1.table_id IN ('value1,value2,value3')
This isn't returning results, and it should... where is my syntax
incorrect?
--
Jillian
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222628
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: mutliple instance installation tutorial
There was one on macromedia.com that I found useful awhile ago, but I can't find it at the moment. I googled j2ee CFMX multiple instances and was surprised by how many on target hits I got, and just how much discussion there is around the Web on this subject. You'll see big name resources like forta.com, but there are plenty of small blog sites and other resources out there that have useful info. Anyone know of a good step by step tutorial on installing CF muliple instances? -mark Mark A. Kruger, CFG, MCSE www.cfwebtools.com www.necfug.com http://mkruger.cfwebtools.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222629 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: debugging complaint
hey ray, somewhat on and off topic, do you know if it is possible to modify the cfdump structure? particularly the stylesheet. I had a developer ping me the other day about the cfdump stylesheet color specifications did not use pound signs, something like color: 336633; He said it was using a browser that wasn't liking it or something. As far as I can tell there is no way, thats an innerds of cf thing, but just wondered if you knew if it was possible. On 10/28/05, Raymond Camden [EMAIL PROTECTED] wrote: Something else to consider. My starfish project handles debugging info, stuff like the time it took to do X. It does NOT handle erorrs. However... It IS possible to modify error behaviour. I've written to blog entries on this. This entry: http://ray.camdenfamily.com/index.cfm/2005/7/14/More-CFMX-Error-Modifications Tells you how ot make stack traces collapse in Firefox, like they do in IE. This entry: http://ray.camdenfamily.com/index.cfm/2005/10/4/Modifying-Exception-Templates-in-CFMX-701 Will make it so if you use a struct key that doesn't exist, the error will tell you which keys _do_ exist in the struct, which is VERY helpful. Ie, instead of, you can't do foo.goo, you get, you can't do foo.goo, but moo and zoo are valid keys. This is ALL something you do NOT want to do on a production server, but it may be of use to you. On 10/28/05, Bryan Stevenson [EMAIL PROTECTED] wrote: Some good points Jim,...thanks...good points to ponder for sure.. Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222630 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Big Honking Queries Make Me Want To Scream
Les, without knowing the relationships between the tables (one-to-one, one-to-many, many-to-many) this may or may not produce your desired output, but lets start with the following: Thanks, the below is a good start. What's got me buggered is that: 1. Any of the relationships *could* be a. one to many (Lots of horror movies on one network) b. many to many (all horror movies on all networks) 2. There may or may not be a value for some inputs. So, you could search for: 1. all the directors of all the horror movies 2. all the directors of all the horror movies on CBS 3. all the directors of all the horror movies on CBS with the word blood in the title. 4. all the directors of all the horror movies on CBS with the word blood in the title. and that are MUSICALS 5. ...and even more I'm slowly getting there. Is there a damned good book/tutorial somewhere on writing these things? As I previously stated, I can get it to work if I write 14 little queries and use a bunch of and PlayerID in (#valuelist(players.PlayerID)#) statements. Luckily, trim isn't needed on a lot of variables, as they're drop down boxes on the forms. Thanks to all that have replied so far. SELECT p.FName, p.LName, s.Title, s.Network, c.CreditType FROM Shows s INNER JOIN SubjectMatter sm ON (s.ShowID = sm.ShowID) INNER JOIN Credits c ON (s.ShowID = c.ShowID) INNER JOIN Players p ON (sShowID = p.ShowID) WHERE s.Network = cfqueryparam cfsqltype=CF_SQL_VARCHAR null=false value=#trim(form.network)# / AND c.CreditType = cfqueryparam cfsqltype=CF_SQL_VARCHAR null=false value=#trim(form.credittype)# / AND s.Logline LIKE cfqueryparam cfsqltype=CF_SQL_VARCHAR null=false value=%#trim(form.logline)#% / ORDER BY p.LName -- --- Les Mizzell ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222631 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: debugging complaint
i've seen where doctypes will remove all colors from a cfdump (border colors and background colors), rendering it highly ineffective. removing the doctype declaration normally fixes this for me. (of course, it goes back in prior to going to production) :) On 10/28/05, Ryan Guill [EMAIL PROTECTED] wrote: hey ray, somewhat on and off topic, do you know if it is possible to modify the cfdump structure? particularly the stylesheet. I had a developer ping me the other day about the cfdump stylesheet color specifications did not use pound signs, something like color: 336633; He said it was using a browser that wasn't liking it or something. As far as I can tell there is no way, thats an innerds of cf thing, but just wondered if you knew if it was possible. On 10/28/05, Raymond Camden [EMAIL PROTECTED] wrote: Something else to consider. My starfish project handles debugging info, stuff like the time it took to do X. It does NOT handle erorrs. However... It IS possible to modify error behaviour. I've written to blog entries on this. This entry: http://ray.camdenfamily.com/index.cfm/2005/7/14/More-CFMX-Error-Modifications Tells you how ot make stack traces collapse in Firefox, like they do in IE. This entry: http://ray.camdenfamily.com/index.cfm/2005/10/4/Modifying-Exception-Templates-in-CFMX-701 Will make it so if you use a struct key that doesn't exist, the error will tell you which keys _do_ exist in the struct, which is VERY helpful. Ie, instead of, you can't do foo.goo, you get, you can't do foo.goo, but moo and zoo are valid keys. This is ALL something you do NOT want to do on a production server, but it may be of use to you. On 10/28/05, Bryan Stevenson [EMAIL PROTECTED] wrote: Some good points Jim,...thanks...good points to ponder for sure.. Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222632 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Big Honking Queries Make Me Want To Scream
Is there a damned good book/tutorial somewhere on writing these things? Using Complex SQL Statements in Coldfusion for Idiots ?? -- --- Les Mizzell ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222633 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: debugging complaint
Thanks charlie, thats good to know. On 10/28/05, Charlie Griefer [EMAIL PROTECTED] wrote: i've seen where doctypes will remove all colors from a cfdump (border colors and background colors), rendering it highly ineffective. removing the doctype declaration normally fixes this for me. (of course, it goes back in prior to going to production) :) On 10/28/05, Ryan Guill [EMAIL PROTECTED] wrote: hey ray, somewhat on and off topic, do you know if it is possible to modify the cfdump structure? particularly the stylesheet. I had a developer ping me the other day about the cfdump stylesheet color specifications did not use pound signs, something like color: 336633; He said it was using a browser that wasn't liking it or something. As far as I can tell there is no way, thats an innerds of cf thing, but just wondered if you knew if it was possible. On 10/28/05, Raymond Camden [EMAIL PROTECTED] wrote: Something else to consider. My starfish project handles debugging info, stuff like the time it took to do X. It does NOT handle erorrs. However... It IS possible to modify error behaviour. I've written to blog entries on this. This entry: http://ray.camdenfamily.com/index.cfm/2005/7/14/More-CFMX-Error-Modifications Tells you how ot make stack traces collapse in Firefox, like they do in IE. This entry: http://ray.camdenfamily.com/index.cfm/2005/10/4/Modifying-Exception-Templates-in-CFMX-701 Will make it so if you use a struct key that doesn't exist, the error will tell you which keys _do_ exist in the struct, which is VERY helpful. Ie, instead of, you can't do foo.goo, you get, you can't do foo.goo, but moo and zoo are valid keys. This is ALL something you do NOT want to do on a production server, but it may be of use to you. On 10/28/05, Bryan Stevenson [EMAIL PROTECTED] wrote: Some good points Jim,...thanks...good points to ponder for sure.. Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222634 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Big Honking Queries Make Me Want To Scream
Try the ColdFusion MX Bible it has some very good chapters SQL Is there a damned good book/tutorial somewhere on writing these things? Using Complex SQL Statements in Coldfusion for Idiots ?? -- --- Les Mizzell ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222635 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT - Complex SQL
You might try SELECTing the date column and see what it returns.
You might also ask the DBA what the date datatype is.
I know, from sad experience, that DB2 DBA's tended to use non-date
datatypes because they are somewhat new in the last decade.
We have DB2 on our AS400 and NO ONE uses a date/time datatype. Instead,
we have a mix of char- and numeric-based datatypes.
For example, we may have dates stored as: 20051031 or '20051031'.
What you want is to see an output like: {2005-10-31 15:31:59.000}
Or something similar to that. If you do see that format, then you have
a good date/time datatype. These date/time values are pretty standard
and most languages can parse them correctly.
If you have a canonical format like 20051031, then you will need to
manually parse it before using any of CF's date/time functions, if
desired.
M!ke
-Original Message-
From: Jillian Koskie [mailto:[EMAIL PROTECTED]
Sent: Friday, October 28, 2005 5:41 PM
To: CF-Talk
Subject: RE: OT - Complex SQL
You're so right... Anybody happen to now offhand (I'm off to search
after I send this message) what the date format is for DB2?
I'm just running this at the command line, so no need for any CF
stuffs... But unfortuantely also can't take advantage of CF stuffs.
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222636
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT - Complex SQL
Along these lines, you might want to look into DB2's data dictionary.
On our AS400, you can find the data dictionary in the qsys2 libraries.
Look for a table named syscolumns. That table will give you the
details on any column in the database.
I created a simple DB2 datadictionary view a few years ago and it comes
in quite handy.
M!ke
-Original Message-
From: Jillian Koskie [mailto:[EMAIL PROTECTED]
Sent: Friday, October 28, 2005 5:41 PM
To: CF-Talk
Subject: RE: OT - Complex SQL
You're so right... Anybody happen to now offhand (I'm off to search
after I send this message) what the date format is for DB2?
I'm just running this at the command line, so no need for any CF
stuffs... But unfortuantely also can't take advantage of CF stuffs.
-Original Message-
From: Dawson, Michael [mailto:[EMAIL PROTECTED]
Sent: Friday, October 28, 2005 4:16 PM
To: CF-Talk
Subject: RE: OT - Complex SQL
You need single quotes around each of your values in the IN clause.
snip
AND table_1.table_id IN ('value1','value2','value3') /snip
The date formats may be wrong, too. Check the actual data in the
database and/or use createODBCDateTime() and definitely use
CFQUERYPARAM. It will make your job a bit eaiser.
Either way, I would remove the dates from your WHERE claus, fix the IN
clause, then run the query. See if you get any results with very
limited filtering, first.
Then, go from there and add more filtering as needed.
M!ke
-Original Message-
From: Jillian Koskie [mailto:[EMAIL PROTECTED]
Sent: Friday, October 28, 2005 5:12 PM
To: CF-Talk
Subject: OT - Complex SQL
Okay, I think it's because it is Friday at 4... can somebody help me
out?
SELECT table_1.expiry_date,
table_3.expiry_date
FROMtable_3
JOIN table_2 ON table_2.table2_key = table_3.tablel2_key
JOIN table_1 ON table_1.table1_key = table_2.table1_key
WHERE table_1.expiry_date = 'Dec 31, 2005'
AND table_3.expiry_date = 'Dec 31, 2005'
AND table_1.table_id IN ('value1,value2,value3')
This isn't returning results, and it should... where is my syntax
incorrect?
--
Jillian
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222637
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Problem in a Simple webservice: 1D array works 2D fails
Thanks to everyone else for suggesting other data structures that work. I did some testing and there is no problem with Structs of Structs and other combinations, but the designer wants as simple and portable a solution as possible, so it's back to see what I can do to make the 2D Array work. I don't know how it can get any simpler than a struct of structs. Will ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222638 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Blog API for Myspace.com
I am trying to figure out if Myspace.com, which is built in CF, has an API, similar to what Blogger, Wordpress, and LJ has. I know that there are quite a few APIs out there already, Atom, BloggerAPI, etc. Myspace.com has no details on anything, nor does Googling offer any answers. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222639 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
re: Blog API for Myspace.com
if they catch you using any scripts they will delete you but then again they are pretty bad codes themselfs.. better read there rules and regulations. ~Dave the disruptor~ Some people just don't appreciate how difficult it is to dispense wisdom and abuse at the same time. From: Abinidi Web Services [EMAIL PROTECTED] Sent: Friday, October 28, 2005 10:49 PM To: CF-Talk cf-talk@houseoffusion.com Subject: Blog API for Myspace.com I am trying to figure out if Myspace.com, which is built in CF, has an API, similar to what Blogger, Wordpress, and LJ has. I know that there are quite a few APIs out there already, Atom, BloggerAPI, etc. Myspace.com has no details on anything, nor does Googling offer any answers. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222640 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
re: Blog API for Myspace.com
I'm not trying to run scripts on my blog. What I am trying to do is build a 3rd party app that users can post topics to thier blog. Just about every other Blog app has the ability to do it, mainly via XMLRPC. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222641 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
