Re: global module call
reference it from a cfmapping, cfmodule template=/cfmappingname/blah/blah/tag.cfm john. On 5/23/05, dave [EMAIL PROTECTED] wrote: i wish but at the moment i have a work around ~Dave the disruptor~ From: James Holmes [EMAIL PROTECTED] Sent: Monday, May 23, 2005 12:01 AM To: CF-Talk cf-talk@houseoffusion.com Subject: RE: global module call A CF custom tag path would do the trick if it's a custom tag. -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Monday, 23 May 2005 11:48 To: CF-Talk Subject: global module call is there anyway to make this call a global call? meaning accessable from any page, since you cant put the actual path in/ ~Dave the disruptor~ ~| 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:207403 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: CFPROCPARAM Help Needed
You should also avoid using sp_ as a prefix to Stored Procedures - if it's a custom SP you should rename them - maybe something like usp_ as if you name an SP with sp_ SQL Server will look at the master DB for the SP first and can create unnecessary load. -Original Message- From: G L [mailto:[EMAIL PROTECTED] Sent: 20 May 2005 18:05 To: CF-Talk Subject: Re: CFPROCPARAM Help Needed Yeah, I was responding to Kevin saying Use dbvarname when you wish to match up the database variable with the value you are passing in - sort of like a name/value pair @xyz = #url.xyz# etc. It sounded like he was saying the dbvarname had something to do with a column name in the db. On 5/20/05, S. Isaac Dealey [EMAIL PROTECTED] wrote: DBVarName doesn't sound right either then, because I'm not trying to match anything in the database. Just trying to pass a variable which is declared in the sp. The variable I declare doesn't have to be the same as any column name in the db. Yes... though that's not what dbvarname was designed to match... dbvarname was designed to match the name of the stored procedure parameter. Actually, I think you are both saying the same thing, although parameter is the correct term, not variable. My interpretation from reading it was that he was thinking dbvarname would take say... cfprocparam dbvarname=contractid value=#cid# and match that value against a contractid column in a table somewhere... so that's why I thought it needed clarification -- though I could certainly have misread it. :) s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| 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:207404 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: Verity and Security
Yes, tried CONTAINS as well, same result - no records found ? -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: 20 May 2005 17:10 To: CF-Talk Subject: Re: Verity and Security Did you try CONTAINS as well? On 5/20/05, Ian Vaughan [EMAIL PROTECTED] wrote: Nope even with the quotes shown in the results page I sent in the last post, the search is returning no results ? . What is strange though is if I remove the and CF_CUSTOM2 IN #session.groupname# ~| 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:207405 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
CF Tag for Next and Previous searching (like Google)
Hi guys, I remember in the past seeing a next/previous CFTag which would create NEXT and PREV buttons like Google does as well as other search engines. Does anyone know what it is called off hand? Thanks, Saturday ~| 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:207406 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 Tag for Next and Previous searching (like Google)
It's called cf_break_recordset Copy on its way off list Allan -Original Message- From: Stuart Kidd [mailto:[EMAIL PROTECTED] Sent: 23 May 2005 12:34 To: CF-Talk Subject: CF Tag for Next and Previous searching (like Google) Hi guys, I remember in the past seeing a next/previous CFTag which would create NEXT and PREV buttons like Google does as well as other search engines. Does anyone know what it is called off hand? Thanks, Saturday ~| 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:207407 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-LOW: RE: CF Tag for Next and Previous searching (like Google)
Hi Allan, That's fantastic, thanks! :) Saturday On 23/5/05 11:37, Allan Cliff [EMAIL PROTECTED] wrote: It's called cf_break_recordset Copy on its way off list Allan -Original Message- From: Stuart Kidd [mailto:[EMAIL PROTECTED] Sent: 23 May 2005 12:34 To: CF-Talk Subject: CF Tag for Next and Previous searching (like Google) Hi guys, I remember in the past seeing a next/previous CFTag which would create NEXT and PREV buttons like Google does as well as other search engines. Does anyone know what it is called off hand? Thanks, Saturday ~| 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:207408 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 Enterprise Edition vs. CF Standard Edition
Isn't it also appropriate to define and communicate the value that is possible (or not) with the additional features/performance of one product over another to the business? In other words, aside from features that 'developers want to play with', there are features and benefits that may be realized if the business is aware that they are options. 'Business needs' is an interesting conundrum, I would opine that 10 years ago, almost no business needed an IM solution, and currently many companies consider that a need. Technology influences business needs, is I guess what I'm getting to. - Calvin On 5/20/05 8:37 AM, Micha Schopman [EMAIL PROTECTED] wrote: It might be useful to determine your business needs as opposite to what features developers want to play with. If you have no use for the additional features in your project(s) it might be a decision based on emotions instead of rational arguments and the extra investment might never pay itself back. Is this still on topic? Micha Schopman Project Manager Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 ~| 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:207409 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: adding subtotals
Also, if you're using MS SQL server, try doing ewok's query using the WITH ROLLUP option...by using it with proper grouping, you can have the server get the by-purchaser and overall totals in the query itself. May have to add a column or two to control ordering of NULL values, but, hey, it's MS... SELECT purchaserid, itemid, sum(itemPrice) as TheTotal FROM itemsPurchased GROUP BY purchaserid, itemid WITH ROLLUP -Joe On 5/20/05, Ewok [EMAIL PROTECTED] wrote: I didn't mean to send that just yet :) I assumed you meant adding it in a query versus CF... This will get distinct purchaserIDs and their total dollars spent on any all together SELECT purchaserid, sum(itemPrice) as TheTotal FROM itemsPurchased group by purchaserid This will break the previous results down by items and the total amounts purchaserID spent on them. SELECT purchaserid, itemid, sum(itemPrice) as TheTotal FROM itemsPurchased group by purchaserid, itemid just add your 'where purchaserid = #purchaserid#' to get a specific one. -Original Message- From: Ewok [mailto:[EMAIL PROTECTED] Sent: Friday, May 20, 2005 10:47 PM To: CF-Talk Subject: RE: adding subtotals SELECT sum(itemPrice) as TheTotal FROM itemsPurchased WHERE purchaserID = '#purchaserID#' -Original Message- From: mayo [mailto:[EMAIL PROTECTED] Sent: Friday, May 20, 2005 9:15 PM To: CF-Talk Subject: adding subtotals I'm completely blanking on how to add subtotals. I'll explain clearer below: I have a table of itemsPurchased that includes itemID itemQty and itemPrice. !--- simplified --- SELECT itemID, itemQty, itemPrice FROM itemsPurchased WHERE purchaserID = '#purchaserID#' Say person A bought 3 items at $10 and 2 items at $20 I have no trouble arriving at the subtotals (30 and 40 in this example) but now I want to add these for 70. I can't get this . getting . tired . not thinking straight . Thx, gil ~| 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:207410 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: Enable Robust Exception Information - Tradeoff
Morning everyone, thanks very much for all the information regarding this subject. Leonardo. -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Sunday, May 22, 2005 7:28 PM To: CF-Talk Subject: Re: Enable Robust Exception Information - Tradeoff Array of structs actually... :P Just to be nit-picky. :) yeah yeah... sheesh. :P I'd accept the performance hit to turn it on for a day or so at a time in order to help debug and fix the application and then when the application was reasonably stable I'd turn it off again. If the code doesn't produce lots of exceptions during normal operation I don't see a real issue. Unfortunately I can seldom count on that, so my comments are colored by this and I'd forgotten some people can actually stick one application on a server and pretty much forget about it. I only have a very few clients with their own servers. The rest share mine, although the way server prices are going that will change. -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.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:207411 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
OT: MSSQL sp4
OK, I just patched up a dev machine to MSSQL sp4. Seems ok so far. The announcement mentioned Refreshed, more secure Visual Database Tools (Table Designer, Database Diagrams, and Query Designer) -- does anyone have any ideas on what these can be? I kind of expected an improved enterprise manager or some new applications, but I didn't see any changes really there (at least not any major changes). /Hugo -- Hugo Ahlenius - Hugo Ahlenius E-Mail: [EMAIL PROTECTED] Project OfficerPhone:+46 8 230460 UNEP GRID-Arendal Fax: +46 8 230441 Stockholm Office Mobile: +46 733 467111 WWW: http://www.grida.no - ### This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange. For more information, connect to http://www.f-secure.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:207412 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 Tag for Next and Previous searching (like Google)
Good morning. Could I get a copy of this as well? :) -Original Message- From: Allan Cliff [mailto:[EMAIL PROTECTED] Sent: Monday, May 23, 2005 6:38 AM To: CF-Talk Subject: RE: CF Tag for Next and Previous searching (like Google) It's called cf_break_recordset Copy on its way off list Allan -Original Message- From: Stuart Kidd [mailto:[EMAIL PROTECTED] Sent: 23 May 2005 12:34 To: CF-Talk Subject: CF Tag for Next and Previous searching (like Google) Hi guys, I remember in the past seeing a next/previous CFTag which would create NEXT and PREV buttons like Google does as well as other search engines. Does anyone know what it is called off hand? Thanks, Saturday ~| 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:207413 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: Verity and Security
Sorry then - I'm at a lost. As I mentioned, when I tried a local version, it worked just fine. You could consider using query of query to filter the results. On 5/23/05, Ian Vaughan [EMAIL PROTECTED] wrote: Yes, tried CONTAINS as well, same result - no records found ? -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: 20 May 2005 17:10 To: CF-Talk Subject: Re: Verity and Security Did you try CONTAINS as well? On 5/20/05, Ian Vaughan [EMAIL PROTECTED] wrote: Nope even with the quotes shown in the results page I sent in the last post, the search is returning no results ? . What is strange though is if I remove the and CF_CUSTOM2 IN #session.groupname# ~| 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:207414 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 Tag for Next and Previous searching (like Google)
Allan, would it be possible if I could also get a copy of it. Thanks Mario -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: Monday, May 23, 2005 9:05 AM To: CF-Talk Subject: RE: CF Tag for Next and Previous searching (like Google) Good morning. Could I get a copy of this as well? :) -Original Message- From: Allan Cliff [mailto:[EMAIL PROTECTED] Sent: Monday, May 23, 2005 6:38 AM To: CF-Talk Subject: RE: CF Tag for Next and Previous searching (like Google) It's called cf_break_recordset Copy on its way off list Allan -Original Message- From: Stuart Kidd [mailto:[EMAIL PROTECTED] Sent: 23 May 2005 12:34 To: CF-Talk Subject: CF Tag for Next and Previous searching (like Google) Hi guys, I remember in the past seeing a next/previous CFTag which would create NEXT and PREV buttons like Google does as well as other search engines. Does anyone know what it is called off hand? Thanks, Saturday ~| 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:207415 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: adding subtotals
On 5/23/05, Joe Rinehart [EMAIL PROTECTED] wrote: Also, if you're using MS SQL server, try doing ewok's query using the WITH ROLLUP option...by using it with proper grouping, you can have the server get the by-purchaser and overall totals in the query itself. May have to add a column or two to control ordering of NULL values, but, hey, it's MS... SELECT purchaserid, itemid, sum(itemPrice) as TheTotal FROM itemsPurchased GROUP BY purchaserid, itemid WITH ROLLUP And Oracle has the equivalent analytical functions (which have saved me tons of coding/hacking). SELECT purchaserid, itemid, sum(itemPrice) as TheTotal FROM itemsPurchased GROUP BY ROLLUP ( purchaserid, itemid ) Regards, Dave. ~| 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:207416 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 Tag for Next and Previous searching (like Google)
I'd like it as well. Patrick -Original Message- From: Allan Cliff [mailto:[EMAIL PROTECTED] Sent: May 23, 2005 06:38 To: CF-Talk Subject: RE: CF Tag for Next and Previous searching (like Google) It's called cf_break_recordset Copy on its way off list Allan -Original Message- From: Stuart Kidd [mailto:[EMAIL PROTECTED] Sent: 23 May 2005 12:34 To: CF-Talk Subject: CF Tag for Next and Previous searching (like Google) Hi guys, I remember in the past seeing a next/previous CFTag which would create NEXT and PREV buttons like Google does as well as other search engines. Does anyone know what it is called off hand? Thanks, Saturday ~| 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:207417 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: adding subtotals
Thanks, Dave - I barely use Oracle, but knowing that is bound to save me some research next time I do! -Joe On 5/23/05, Dave Carabetta [EMAIL PROTECTED] wrote: On 5/23/05, Joe Rinehart [EMAIL PROTECTED] wrote: Also, if you're using MS SQL server, try doing ewok's query using the WITH ROLLUP option...by using it with proper grouping, you can have the server get the by-purchaser and overall totals in the query itself. May have to add a column or two to control ordering of NULL values, but, hey, it's MS... SELECT purchaserid, itemid, sum(itemPrice) as TheTotal FROM itemsPurchased GROUP BY purchaserid, itemid WITH ROLLUP And Oracle has the equivalent analytical functions (which have saved me tons of coding/hacking). SELECT purchaserid, itemid, sum(itemPrice) as TheTotal FROM itemsPurchased GROUP BY ROLLUP ( purchaserid, itemid ) Regards, Dave. ~| 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:207418 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 Tag for Next and Previous searching (like Google)
For the rest of you its at http://www.cfugspain.org/breakrecordset.zip Allan -Original Message- From: CFDEV [mailto:[EMAIL PROTECTED] Sent: 23 May 2005 16:21 To: CF-Talk Subject: RE: CF Tag for Next and Previous searching (like Google) I'd like it as well. Patrick -Original Message- From: Allan Cliff [mailto:[EMAIL PROTECTED] Sent: May 23, 2005 06:38 To: CF-Talk Subject: RE: CF Tag for Next and Previous searching (like Google) It's called cf_break_recordset Copy on its way off list Allan -Original Message- From: Stuart Kidd [mailto:[EMAIL PROTECTED] Sent: 23 May 2005 12:34 To: CF-Talk Subject: CF Tag for Next and Previous searching (like Google) Hi guys, I remember in the past seeing a next/previous CFTag which would create NEXT and PREV buttons like Google does as well as other search engines. Does anyone know what it is called off hand? Thanks, Saturday ~| 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:207419 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 Tag for Next and Previous searching (like Google)
thanks much... -Original Message- From: Allan Cliff [mailto:[EMAIL PROTECTED] Sent: Monday, May 23, 2005 10:34 AM To: CF-Talk Subject: RE: CF Tag for Next and Previous searching (like Google) For the rest of you its at http://www.cfugspain.org/breakrecordset.zip Allan -Original Message- From: CFDEV [mailto:[EMAIL PROTECTED] Sent: 23 May 2005 16:21 To: CF-Talk Subject: RE: CF Tag for Next and Previous searching (like Google) I'd like it as well. Patrick -Original Message- From: Allan Cliff [mailto:[EMAIL PROTECTED] Sent: May 23, 2005 06:38 To: CF-Talk Subject: RE: CF Tag for Next and Previous searching (like Google) It's called cf_break_recordset Copy on its way off list Allan -Original Message- From: Stuart Kidd [mailto:[EMAIL PROTECTED] Sent: 23 May 2005 12:34 To: CF-Talk Subject: CF Tag for Next and Previous searching (like Google) Hi guys, I remember in the past seeing a next/previous CFTag which would create NEXT and PREV buttons like Google does as well as other search engines. Does anyone know what it is called off hand? Thanks, Saturday ~| 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:207420 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
Viewing files in another server/directory outside CF server
Hi all I can upload files to CA_LA_Fresno server using CF user. CF user haves administrator properties. But my user don't have permission to access that server/directory. It's possible to my users see that file in your browser or Word? How? Thanks in advance ~| 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:207421 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: Verity and Security
Seems very strange how it does not work ? Do you have an example of a query of query I could use to test please, -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: 23 May 2005 14:32 To: CF-Talk Subject: Re: Verity and Security Sorry then - I'm at a lost. As I mentioned, when I tried a local version, it worked just fine. You could consider using query of query to filter the results. On 5/23/05, Ian Vaughan [EMAIL PROTECTED] wrote: Yes, tried CONTAINS as well, same result - no records found ? -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: 20 May 2005 17:10 To: CF-Talk Subject: Re: Verity and Security Did you try CONTAINS as well? On 5/20/05, Ian Vaughan [EMAIL PROTECTED] wrote: Nope even with the quotes shown in the results page I sent in the last post, the search is returning no results ? . What is strange though is if I remove the and CF_CUSTOM2 IN #session.groupname# ~| 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:207422 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: Viewing files in another server/directory outside CF server
Use cfcontent to do that cfheader name=Content-Disposition value=attachment; filename=#attributes.filename# cfcontent type=#attributes.mimetype# file=#attributes.file# deletefile=No Pascal -Original Message- From: Michel Deloux [mailto:[EMAIL PROTECTED] Sent: 23 May 2005 16:54 To: CF-Talk Subject: Viewing files in another server/directory outside CF server Hi all I can upload files to CA_LA_Fresno server using CF user. CF user haves administrator properties. But my user don't have permission to access that server/directory. It's possible to my users see that file in your browser or Word? How? Thanks in advance ~| 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:207423 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 Tag for Next and Previous searching (like Google)
I made one quite a while back called CF_PageList. It behaves in much the same way as google by moving through the records and pages. You can see it in action and download it at http://www.cornfeed.com. Cedric Subject: CF Tag for Next and Previous searching (like Google) From: Stuart Kidd [EMAIL PROTECTED] Date: Mon, 23 May 2005 11:33:34 +0100 Thread: http://www.houseoffusion.com/cf_lists/index.cfm/method=messagesthreadid=40329forumid=4#207406 Hi guys, I remember in the past seeing a next/previous CFTag which would create NEXT and PREV buttons like Google does as well as other search engines. Does anyone know what it is called off hand? Thanks, Saturday ~| 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:207424 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: Sessions dropping in CF5
Ryan, Here's the CFApplication tag from my application cfm. After that I just set some application vars. CFAPPLICATION NAME=Portal clientmanagement=Yes sessionmanagement=Yes setclientcookies=Yes sessiontimeout=#CreateTimespan(0,0,220,0)# clientstorage=CFvariables Like I said, this happens very rarely. To answer Jochem's question, it is one specific session variable so far that seems to be getting dropped, or not set at all. Basically I run a query and then set one of the results to a session variable, that in most cases gets set. But in one case, a user reported a cf error which said the session variable is either undefined, misspelled, or timed out. Thanks again, Ali ~| 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:207425 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: global module call
Or if you don't have access to the cf administrator to create a mapping, there's a function on cflib (2 of them I think actually) that will generate a relative path to a specified file, so you can use that function to generate paths for custom tags or cfincludes. Here's mine (getRelative()): http://www.cflib.org/udf.cfm?ID=837 Which I renamed getPathTo() in my framework because the original function name wasn't descriptive enough. and here's the other (relativeFilePath()): http://www.cflib.org/udf.cfm?ID=841 What I didn't like about this one personally was that it handled the file paths one character at a time instead of one directory at a time, which could cause problems if you had two similarly named directories or somehow had a combination of forward-and-back slashes. /myfiles/ /myfiles_x/ /myfiles_y/ If you were trying to get a path from something in /myfiles/ to something in /myfiles_x/ or vice versa it might cause a problem. I hadn't tested it, but it looked to me like that might be an issue. reference it from a cfmapping, cfmodule template=/cfmappingname/blah/blah/tag.cfm john. On 5/23/05, dave [EMAIL PROTECTED] wrote: i wish but at the moment i have a work around ~Dave the disruptor~ From: James Holmes [EMAIL PROTECTED] Sent: Monday, May 23, 2005 12:01 AM To: CF-Talk cf-talk@houseoffusion.com Subject: RE: global module call A CF custom tag path would do the trick if it's a custom tag. -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Monday, 23 May 2005 11:48 To: CF-Talk Subject: global module call is there anyway to make this call a global call? meaning accessable from any page, since you cant put the actual path in/ ~Dave the disruptor~ s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| 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:207426 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: REGEX parse a datetime string
how's this? cfset mydate = listchangedelims(mylist,',',' ') cfset mydate = evaluate(createdatetime(#mydate#)) I was going to put it all on one line but then I realized my mail cilent would cut it in half. Any REGEX afficiandoes out there wish to tell how to parse: 2005 5 20 14 48 33 into its component parts: 2005 (year) 5(month) 20 (etc) 14 48 33 so I can build a CF datetime object? Yes, I know I should do it myself. Yes, I know it is relatively simple. WHINE But, I only need to do one of these REGEX things about every three months, and, I swear, I simply forget everything about REGEX in the interim. It just leaks out of my brain faster than I can remember it ... /WHINE Richard Colman s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| 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:207427 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: global module call
http://www.cflib.org/udf.cfm?ID=841 What I didn't like about this one personally was that it handled the file paths one character at a time instead of one directory at a time, which could cause problems if you had two similarly named directories or somehow had a combination of forward-and-back slashes. /myfiles/ /myfiles_x/ /myfiles_y/ If you were trying to get a path from something in /myfiles/ to something in /myfiles_x/ or vice versa it might cause a problem. I hadn't tested it, but it looked to me like that might be an issue. No, this isn't an issue. You can try it by yourself :-) Massimo Foti Tools for ColdFusion and Dreamweaver developers: http://www.massimocorner.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:207428 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
CF7 taking forever to load initial request
I built a little test application to try and isolate the problem. I ran it on
our development and production machines with similar results. Machine specs:
Dev:
P3 600mhz
512mb ram
Win2k fully patched
CF7 multiserver config on JRun 4 with latest updater
JRun config for dev machine:
256 max heap size
args: -server -Xmx256m -Xms224m -XX:NewSize=64m -XX:PermSize=32m
-XX:+UseConcMarkSweepGC -Dsun.io.useCanonCaches=false -XX:MaxPermSize=256m
-DJINTEGRA_NATIVE_MODE -DJINTEGRA_PREFETCH_ENUMS
-Dcoldfusion.rootDir={application.home}/
Prod:
Dual Xeon 2.2Ghz
2Gb ram
Win2k fully patched
CF7 multiserver config on JRun 4 with latest updater
JRun config for prod machine:
1024 max heap size
args: -server -Xmx1024m -Xms512m -XX:NewSize=64m -XX:PermSize=32m
-XX:+UseConcMarkSweepGC -Dsun.io.useCanonCaches=false -XX:MaxPermSize=512m
-DJINTEGRA_NATIVE_MODE -DJINTEGRA_PREFETCH_ENUMS
-Dcoldfusion.rootDir={application.home}/
On these servers I set up this small app:
application.cfm:
cfmodule name=corporate.machine.machine_init
cfapplication
name=myTestApp
clientmanagement=yes
sessionmanagement=yes
setclientcookies=yes
sessiontimeout=3
clientstorage=testDSN
setdomaincookies=yes
index.cfm:
does not contain any CF code, just the string app loaded.
The machine_init tag contains about 7 cfset statements, nothing else.
I then applied some load to the site using Microsoft's Web Application Stress
Tool, using 5 users. While the load was being applied, I restarted the JRun
service for this app to simulate a restart on a live production system.
I'm still waiting for the server to come back up, it's been 30 minutes so far.
The Jrun.exe process is pegging at around 90-95% cpu usage, and I can't get
anything to come back in a browser.
With no load applied, it seems to come up within a few minutes.
If I remove the cfmodule tag, it still takes a long time, but does eventually
begin serving pages.
I have no idea what's wrong here, any advice you can give is greatly
appreciated.
~|
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:207429
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
Queryparam flush
I have an issue anytime I update my db structure. The queries im using with queryparams that reference the modified table toss data type mismatch errors. I assume this is because the prepared statement is no longer is in sync with the table. I have only been able to correct by restarting cf or the db. I have tried refresh the cf odbc services to no avail. Anyone know a sql command to purge all prepared statements? Gabe Ps. Using ms sql 2000 ~| 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:207430 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
Installing CF7 on Windows 2003
Hi, I was installing CF7 on Windows 2003 sp1 and noticed a replicable install issue directories were not written inside the inetpub directory. There was also a java error. However, I was able to install CF7 prior to installing sp1 and that worked. CF also continued to work after sp1 was applied. I am just interested if anyone has installed CF7 on Windows 2003 with SP1 on it, and if so what special steps are involved? Or if the install went to plan I would be interested in knowing that too. Thanks, John Interested in Hiking in Washington State? Check out http://www.attrition.ws ~| 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:207431 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: String to SHA1 to Base 64 Encryption Help!
Hello Jochem, Thanks for the response! Here is the VB.net code the provides the encryption: Imports System.Security.Cryptography Private Function ComputeHash(ByVal Key As String) As String Dim objSHA1 As New SHA1CryptoServiceProvider objSHA1.ComputeHash(System.Text.Encoding.UTF8.GetBytes(Key.ToCharArray)) Dim buffer() As Byte = objSHA1.Hash Dim HashValue As String = System.Convert.ToBase64String(buffer) Return HashValue End Function CFlib.org UDF: View the actual function: http://www.cflib.org/udf.cfm?ID=34 CFSET message=This is a test CFOUTPUT Given message=#message# The SHA-1 message digest is: #sha1(message)# /CFOUTPUT -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Sunday, May 22, 2005 3:27 AM To: CF-Talk Subject: Re: String to SHA1 to Base 64 Encryption Help! Aldon Moore wrote: I am completing the integration of a payment processora and the processor requires me to convert a string to SHA1 then to BASE64. I used a SHA1 UDF script from Cflib.org for the conversion but in comparison to the string created by the dotnet SHA1CryptoServiceProvider its different. Can you show the code and the two strings? Jochem ~| 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:207432 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: Installing CF7 on Windows 2003
Hi, I was installing CF7 on Windows 2003 sp1 and noticed a replicable install issue directories were not written inside the inetpub directory. There was also a java error. However, I was able to install CF7 prior to installing sp1 and that worked. CF also continued to work after sp1 was applied. I am just interested if anyone has installed CF7 on Windows 2003 with SP1 on it, and if so what special steps are involved? Or if the install went to plan I would be interested in knowing that too. There's a specific issue with installing some MM products on Windows Server 2003 SP1: http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=b39c1803 However, this isn't supposed to affect CFMX 7 (and hasn't, for me). Can you provide more specific information about the errors that you encountered? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:207433 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: Installing CF7 on Windows 2003
I don't have the logs in front of me - I will repro it this evening and post the setup log. Don't think the included error is the one I received, but I think the problem is with DEP. I will also try disabling DEP to see if that allows the installation to go through. Thanks, John Interested in Hiking in Washington State? Check out http://www.attrition.ws From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Mon 5/23/2005 9:41 AM To: CF-Talk Subject: RE: Installing CF7 on Windows 2003 Hi, I was installing CF7 on Windows 2003 sp1 and noticed a replicable install issue directories were not written inside the inetpub directory. There was also a java error. However, I was able to install CF7 prior to installing sp1 and that worked. CF also continued to work after sp1 was applied. I am just interested if anyone has installed CF7 on Windows 2003 with SP1 on it, and if so what special steps are involved? Or if the install went to plan I would be interested in knowing that too. There's a specific issue with installing some MM products on Windows Server 2003 SP1: http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=b39c1803 However, this isn't supposed to affect CFMX 7 (and hasn't, for me). Can you provide more specific information about the errors that you encountered? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:207434 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
CFLDAP Dynimic Query
I'm using the CFLDAP with the attributes parameter as a dynimic variable set by a user. cfldap server=#LDAPserver# action=query name=results username=#LDAPuser# password=#ldappass# start=#ou_string# attributes=#at2# delimiter=, My problem is; how do I output this record set returned by the query if I don't know the column names of the query? Is there any way to ouput this record set directly to a text file? Any suggestions? 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:207435 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: CFLDAP Dynimic Query
cfoutput#results.columnList#/cfoutput HTH -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning -Original Message- From: Scott Sylvester [mailto:[EMAIL PROTECTED] Sent: Monday, May 23, 2005 9:56 AM To: CF-Talk Subject: CFLDAP Dynimic Query I'm using the CFLDAP with the attributes parameter as a dynimic variable set by a user. cfldap server=#LDAPserver# action=query name=results username=#LDAPuser# password=#ldappass# start=#ou_string# attributes=#at2# delimiter=, My problem is; how do I output this record set returned by the query if I don't know the column names of the query? Is there any way to ouput this record set directly to a text file? Any suggestions? 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:207436 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: Verity and Security
Not handy - but check the docs. Basically - assuming data is your info from cfsearch, you can do (pseudo-code) cfquery name=filteredData dbtype=query select * from data where cf_custom2 = put your session var here /cfquery On 5/23/05, Ian Vaughan [EMAIL PROTECTED] wrote: Seems very strange how it does not work ? Do you have an example of a query of query I could use to test please, -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: 23 May 2005 14:32 To: CF-Talk Subject: Re: Verity and Security Sorry then - I'm at a lost. As I mentioned, when I tried a local version, it worked just fine. You could consider using query of query to filter the results. On 5/23/05, Ian Vaughan [EMAIL PROTECTED] wrote: Yes, tried CONTAINS as well, same result - no records found ? -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: 20 May 2005 17:10 To: CF-Talk Subject: Re: Verity and Security Did you try CONTAINS as well? On 5/20/05, Ian Vaughan [EMAIL PROTECTED] wrote: Nope even with the quotes shown in the results page I sent in the last post, the search is returning no results ? . What is strange though is if I remove the and CF_CUSTOM2 IN #session.groupname# ~| 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:207437 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: CFLDAP Dynimic Query
I understand that #results.columnList# will give me the colmn Names from the query, but how do I tell the cfoutput tag to ouput the data in those columns? Thanks! cfoutput#results.columnList#/cfoutput HTH -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning ...-Original Message- ...From: Scott Sylvester [mailto:[EMAIL PROTECTED] ...Sent: Monday, May 23, 2005 9:56 AM ...To: CF-Talk ...Subject: CFLDAP Dynimic Query ... ...I'm using the CFLDAP with the attributes parameter as a dynimic variable ...set by a user. ... ...cfldap server=#LDAPserver# action=query name=results ...username=#LDAPuser# password=#ldappass# start=#ou_string# ...attributes=#at2# delimiter=, ... ...My problem is; how do I output this record set returned by the query if I ...don't know the column names of the query? Is there any way to ouput this ...record set directly to a text file? ... ...Any suggestions? ... ...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:207438 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: CFLDAP Dynimic Query
cfoutput query=results# cfloop list=#results.columnList# index=col #results[col]# /cfloop br/ cfoutput This will give you a basic dump of the results (If I typed everything correctly). More effort will be required if you care about the order or other formatting. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning -Original Message- From: Scott Sylvester [mailto:[EMAIL PROTECTED] Sent: Monday, May 23, 2005 10:10 AM To: CF-Talk Subject: RE: CFLDAP Dynimic Query I understand that #results.columnList# will give me the colmn Names from the query, but how do I tell the cfoutput tag to ouput the data in those columns? Thanks! cfoutput#results.columnList#/cfoutput HTH -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning ...-Original Message- ...From: Scott Sylvester [mailto:[EMAIL PROTECTED] ...Sent: Monday, May 23, 2005 9:56 AM ...To: CF-Talk ...Subject: CFLDAP Dynimic Query ... ...I'm using the CFLDAP with the attributes parameter as a dynimic variable ...set by a user. ... ...cfldap server=#LDAPserver# action=query name=results ...username=#LDAPuser# password=#ldappass# start=#ou_string# ...attributes=#at2# delimiter=, ... ...My problem is; how do I output this record set returned by the query if I ...don't know the column names of the query? Is there any way to ouput this ...record set directly to a text file? ... ...Any suggestions? ... ...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:207439 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
Adding variables to the CFLOGIN scope
Simple question. Is it possible to add variables to the CFLOGIN scope? I simply want to store both a login username (cflogin.name) and a login id (numeric value to use for logging, etc., i.e. cflogin.userid). I tried to simply do this cfset cflogin.userid = loginquery.id but I was returned a variable is undefined error. I'm using MX7 Thanks, Pete ~| 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:207440 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: CFLDAP Dynimic Query
Thanks for the replys. When I use that code I get the following error message: Complex object types cannot be converted to simple values. The expression has requested a variable or an intermediate expression result as a simple value, however, the result cannot be converted to a simple value. Simple values are strings, numbers, boolean values, and date/time values. Queries, arrays, and COM objects are examples of complex values. The most likely cause of the error is that you are trying to use a complex value as a simple one. For example, you might be trying to use a query variable in a CFIF tag. This was possible in ColdFusion 2.0 but creates an error in later versions. The error occurred in I:\WEBDEV\SASDev\SISTest1\Query_AD.cfm: line 47 45 :cfoutput query=results 46 :cfloop list=#results.columnList# index=col 47 :#results[col]# 48 : /cfloop 49 : br/ cfoutput query=results# cfloop list=#results.columnList# index=col #results[col]# /cfloop br/ cfoutput This will give you a basic dump of the results (If I typed everything correctly). More effort will be required if you care about the order or other formatting. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning . -Original Message- . From: Scott Sylvester [mailto:[EMAIL PROTECTED] . Sent: Monday, May 23, 2005 10:10 AM . To: CF-Talk . Subject: RE: CFLDAP Dynimic Query . . I understand that #results.columnList# will give me the colmn Names from . the query, but how do I tell the cfoutput tag to ouput the data in . those columns? . . Thanks! . . . cfoutput#results.columnList#/cfoutput . . HTH . . -- . Ian Skinner . Web Programmer . BloodSource . www.BloodSource.org . Sacramento, CA . . C code. C code run. Run code run. Please! . - Cynthia Dunning . . ...-Original Message- . ...From: Scott Sylvester [mailto:[EMAIL PROTECTED] . ...Sent: Monday, May 23, 2005 9:56 AM . ...To: CF-Talk . ...Subject: CFLDAP Dynimic Query . ... . ...I'm using the CFLDAP with the attributes parameter as a dynimic . variable . ...set by a user. . ... . ...cfldap server=#LDAPserver# action=query name=results . ...username=#LDAPuser# password=#ldappass# start=#ou_string# . ...attributes=#at2# delimiter=, . ... . ...My problem is; how do I output this record set returned by the query . if I . ...don't know the column names of the query? Is there any way to ouput . this . ...record set directly to a text file? . ... . ...Any suggestions? . ... . ...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:207441 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: REGEX parse a datetime string
how's this? cfset mydate = listchangedelims(mylist,',',' ') cfset mydate = evaluate(createdatetime(#mydate#)) I was going to put it all on one line but then I realized my mail cilent would cut it in half. This works great if all the fields are in the proper order to begin with - if not then this will give bad results (it may still seem to work however). Also this is one very few remaining times that evaluate is still useful in CF. ;^) 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:207442 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: CFLDAP Dynimic Query
Ok, you aren't returning a simple query from your ldap. That makes things trickier. cfoutput query=results# cfloop list=#results.columnList# index=col cfif IsSimpleValue(results[col]) #results[col]# cfelse #col# is a complex value such as a structure, array or object, and needs special handling. /cfif /cfloop br/ cfoutput Depending on what you are trying to accomplish, you can add appropiate code to the else clause. Also, cfdump var=#results# will do all this and give you a good idea of the sturcture, but I presume you want prettier output for users. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| 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:207443 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
CFMX 6.1, WSDL, and JSessionID's
Hello! I'm currently attempting to make use of a web service that supports paging. For example, I can pass on a search to a web service, and then (presumably) hit the next page button to get the next page of results from the web service. The problem I'm running into (I think) is that CF is not passing on the same session id that it used to make the previous request, so the nextPage method fails. Is there any way that I can have cold fusion use the same session ID for every invocation of this web service? I have a workaround, but I'd prefer not to use it as it requires that I grab ALL the results in one call and then page through them manually. If I was able to use the NextPage method calls to this web service would require much less bandwidth. Thanks in advance! -- Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ [EMAIL PROTECTED] ~| 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:207444 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: CFLDAP Dynimic Query
hmm, the values I'm returning from the LDAP query are simple values. When I use your code below, it lists out each field names I'm querying, followed by the message that it's a complex query and needs special handeling per the if statement for all 783 records. But, since I know the field names in this test case I use: cfouput query=results #company# #st# #employeeID# /cfoutput and it returns the values just fine for all 783 records. What I ultimatley want to do is write all the values to .txt file seperated by commas so I can import them into another table. I don't need the records to be displayed on the screen at all. ~| 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:207445 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: Adding variables to the CFLOGIN scope
Nope, not possible. On 5/23/05, Pete Ruckelshaus [EMAIL PROTECTED] wrote: Simple question. Is it possible to add variables to the CFLOGIN scope? I simply want to store both a login username (cflogin.name) and a login id (numeric value to use for logging, etc., i.e. cflogin.userid). I tried to simply do this cfset cflogin.userid = loginquery.id but I was returned a variable is undefined error. I'm using MX7 Thanks, Pete ~| 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:207446 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: CFLDAP Dynimic Query
1. As previously mentioned, cfdump the query and look for any non-string (non-simple) values. Also, what are the ldap attributes you are outputting when this errors? 2. If you want to export data from ldap to a database, there may be a better way. What is your ldap server and database server make and model? M!ke -Original Message- From: Scott Sylvester [mailto:[EMAIL PROTECTED] Sent: Monday, May 23, 2005 1:06 PM To: CF-Talk Subject: RE: CFLDAP Dynimic Query hmm, the values I'm returning from the LDAP query are simple values. When I use your code below, it lists out each field names I'm querying, followed by the message that it's a complex query and needs special handeling per the if statement for all 783 records. But, since I know the field names in this test case I use: cfouput query=results #company# #st# #employeeID# /cfoutput and it returns the values just fine for all 783 records. What I ultimatley want to do is write all the values to .txt file seperated by commas so I can import them into another table. I don't need the records to be displayed on the screen at all. ~| 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:207447 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
Migrate Settings from 6.1 to 7
Is there any easy way to migrate mappings and datasources from CF6.1 to CF 7 when they are on two differant servers? Can i just copy the .xml files from one to the other? jonese ~| 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:207448 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
Query of Query max column length
I'm running a QofQ on a cold fusion query, and it is cutting off a column at 11875 chars. Is this expected behavior? Is there anything I can do to stop this behavior? Thanks for any hint, Jerry Johnson Web Developer ~| 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:207449 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: CFMX 6.1, WSDL, and JSessionID's
Jordan, For ever session, CF creates cfid and cftoken, url_token, and Jrun (if using J2EE sessions) adds a jsessionid as well. Those are going to always be the same IDs across that single session provided that you have setclientcookies=true in your Application.cfm/.cfc or you're correctly passing url_token around in your links and relocates. So you could use #cfid#_#cftoken# or #jsessionid# (just cfdump the session scope to see its exact contents) to accomplish this. If it's not maintaining your sessions, then you have a different problem and I'd study up on the particulars of the cfapplication tag or application.cfc to make this work. Laterz, J On 5/23/05, Jordan Michaels [EMAIL PROTECTED] wrote: Hello! I'm currently attempting to make use of a web service that supports paging. For example, I can pass on a search to a web service, and then (presumably) hit the next page button to get the next page of results from the web service. The problem I'm running into (I think) is that CF is not passing on the same session id that it used to make the previous request, so the nextPage method fails. Is there any way that I can have cold fusion use the same session ID for every invocation of this web service? I have a workaround, but I'd prefer not to use it as it requires that I grab ALL the results in one call and then page through them manually. If I was able to use the NextPage method calls to this web service would require much less bandwidth. Thanks in advance! -- Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ [EMAIL PROTECTED] -- --- - Buy SQLSurveyor! http://www.web-relevant.com/sqlsurveyor Never make your developers open Enterprise Manager again. ~| 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:207450 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
Grouping content in a cfmail
I'm trying to group my content in a cfmail tag. I don't need to group the emails (it's only being sent to one person, but I need to group the queried content within the email. Like Group 1 blah blah blah Group 2 blah blah blah And so on. I've been using CFMAIL GROUP=fieldname query=queryName CFOUTPUTfieldname/CFOUTPUT CFMAIL Which is grouping properly, but it sends out a new email for each group as well. I just want one email with everything grouped within in. Has anyone done this? Thanks, Randy __ Do you Yahoo!? Yahoo! Small Business - Try our new Resources site http://smallbusiness.yahoo.com/resources/ ~| 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:207451 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: Migrate Settings from 6.1 to 7
You'd be better off to copy the CFusionMX folder to the new server and install 7 to let it handle its own upgrade process than to try migrating settings after the fact. If you do that, 7 will self-integrate all the settings from 6.1 the first time you run CFAdmin. Laterz, J On 5/23/05, jonese [EMAIL PROTECTED] wrote: Is there any easy way to migrate mappings and datasources from CF6.1 to CF 7 when they are on two differant servers? Can i just copy the .xml files from one to the other? jonese -- --- - Buy SQLSurveyor! http://www.web-relevant.com/sqlsurveyor Never make your developers open Enterprise Manager again. ~| 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:207452 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: Grouping content in a cfmail
Then just do a regularly grouped cfoutput inside the e-mail, just as you would on a HTML page. It works the same in both places. As you noticed the query properties in the cfmail tag are for generating separate emails from a query object, not creating the content of the email. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning -Original Message- From: Randy [mailto:[EMAIL PROTECTED] Sent: Monday, May 23, 2005 11:27 AM To: CF-Talk Subject: Grouping content in a cfmail I'm trying to group my content in a cfmail tag. I don't need to group the emails (it's only being sent to one person, but I need to group the queried content within the email. Like Group 1 blah blah blah Group 2 blah blah blah And so on. I've been using CFMAIL GROUP=fieldname query=queryName CFOUTPUTfieldname/CFOUTPUT CFMAIL Which is grouping properly, but it sends out a new email for each group as well. I just want one email with everything grouped within in. Has anyone done this? Thanks, Randy __ Do you Yahoo!? Yahoo! Small Business - Try our new Resources site http://smallbusiness.yahoo.com/resources/ ~| 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:207453 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
Include Question
Here's my directory structure for example: E:\webs\client1 E:\webs\yeehaa I have a CF mapping called /yeehaa pointed to E:\webs\yeehaa as it should. Inside of the client1 folder I have some files that need to reach back outside the website to read some shared files in yeehaa. I have used Cfinclude and cfmodule with the /yeehaa/file.cfm to no avail. I thought CF could recurse back up through and grabs files from somewhere that was outside the website root. IN IIS, I even have a virtual directory pointing back to those files so it knows how to find it. Any thoughts? CF 6.1 on Win2003 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:207454 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: Moving records up or down.
I'm very interested in using your move records algorithm in JSP, can you help me out post a little sample code if this is possible in JSP Stuart Kidd wrote: On my website i have 23 articles on the front page, i'd like to be able to position them. Say the article which pulls out the database in position 18, i'd like to move up a notch to 17, what is the cleanest way to do this. I have all my articles on this front page (http://www.020.com/). I have a CMS i created. I have thought of ideas of having a field called Position or something but can't find an easy solution. Stuart, in my community publishing software, each page is made of multiple postings, which appear vertically on the page. In order to accomplish the ability to control the order in which they appear, I added a POSTING_ORDER numeric field... this allows me to move things up and down on the page, and also allows me to insert new postings at the top, bottom, or in between existing postings. The tricky part was figuring out the math! In pseudo code get posting order of current posting get posting order of the bottom post if action = up and posting order 1 moveto = posting order - 1 swap two postings by running the queries: query: set posting_order += 1 where posting_order = moveto query: set posting_order = moveto where posting_order=original posting_order if action = down and posting order bottom moveto = posting order + 1 swap two postings by running the queries: query: set posting_order -= 1 where posting_order = moveto query: set posting_order = moveto where posting_order=original posting_order It gets a little more complicated if you also want move to top and move to bottom - 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:207455 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: Include Question (cancel)
Too much frickin Dew today. Sorry. -Original Message- From: Eric J. Hoffman [mailto:[EMAIL PROTECTED] Sent: Monday, May 23, 2005 1:37 PM To: CF-Talk Subject: Include Question Here's my directory structure for example: E:\webs\client1 E:\webs\yeehaa I have a CF mapping called /yeehaa pointed to E:\webs\yeehaa as it should. Inside of the client1 folder I have some files that need to reach back outside the website to read some shared files in yeehaa. I have used Cfinclude and cfmodule with the /yeehaa/file.cfm to no avail. I thought CF could recurse back up through and grabs files from somewhere that was outside the website root. IN IIS, I even have a virtual directory pointing back to those files so it knows how to find it. Any thoughts? CF 6.1 on Win2003 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:207456 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
CF Certification
If one had a chance to have one's company pay for a CF Developer Certification. But wasn't 100% sure one would pass. Where could one go for a realistic trial? -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| 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:207457 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 Certification
CF Exam Buster was what I was told to look up. I have downloaded it, but haven't played with it - yet. Hey, it's only been about 1.5 years, I'll get to it. :) Ray Ian Skinner wrote: If one had a chance to have one's company pay for a CF Developer Certification. But wasn't 100% sure one would pass. Where could one go for a realistic trial? -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| 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:207458 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: Include Question (cancel)
Blasphemy! Repent you filthy heathen. There can never be too much Dew! On 5/23/05, Eric J. Hoffman [EMAIL PROTECTED] wrote: Too much frickin Dew today. Sorry. ~| 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:207459 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 Certification
That's what I used as a prep. It was pretty good at pointing out a lot of the changes between CF5 and CFMX- I had never used CFMX before the test, so that was important. Good mix of questions, and a large enough list of questions that it took awhile before I got to the point where I was doing well simply because I'd seen the questions a few times before... ;) I think the actual test was noticeably harder though, but maybe I just test badly. Matt Osbun Web Developer Health Systems, International -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Monday, May 23, 2005 1:55 PM To: CF-Talk Subject: Re: CF Certification CF Exam Buster was what I was told to look up. I have downloaded it, but haven't played with it - yet. Hey, it's only been about 1.5 years, I'll get to it. :) Ray Ian Skinner wrote: If one had a chance to have one's company pay for a CF Developer Certification. But wasn't 100% sure one would pass. Where could one go for a realistic trial? -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| 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:207460 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: Grouping content in a cfmail
It bombs when trying to do a normal grouped output inside a cfmail tag. It doesn't like have a cfoutput query= inside a mail tag. And when leaving the query on the cfmail, it sends several emails, 1 for each grouping. Thanks, Randy Then just do a regularly grouped cfoutput inside the e-mail, just as you would on a HTML page. It works the same in both places. As you noticed the query properties in the cfmail tag are for generating separate emails from a query object, not creating the content of the email. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning . -Original Message- . From: Randy [mailto:[EMAIL PROTECTED] . Sent: Monday, May 23, 2005 11:27 AM . To: CF-Talk . Subject: Grouping content in a cfmail . . I'm trying to group my content in a cfmail tag. . . I don't need to group the emails (it's only being sent . to one person, but I need to group the queried content . within the email. . Like . Group 1 . blah blah blah . Group 2 . blah blah blah . . And so on. . . I've been using . CFMAIL GROUP=fieldname query=queryName . CFOUTPUTfieldname/CFOUTPUT . CFMAIL . . Which is grouping properly, but it sends out a new . email for each group as well. I just want one email . with everything grouped within in. . . Has anyone done this? . Thanks, . Randy . . . . . __ . Do you Yahoo!? . Yahoo! Small Business - Try our new Resources site . http://smallbusiness.yahoo.com/resources/ . . ~| 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:207461 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 Certification
how often must we re-up our cert? also, i used exam buster, and passed. now, im a special case as i only got 850 on my sat's and basically 1.6'd my way through high school :) i test horribly, and i passed the cfmx test. tw On 5/23/05, Matt Osbun [EMAIL PROTECTED] wrote: That's what I used as a prep. It was pretty good at pointing out a lot of the changes between CF5 and CFMX- I had never used CFMX before the test, so that was important. Good mix of questions, and a large enough list of questions that it took awhile before I got to the point where I was doing well simply because I'd seen the questions a few times before... ;) I think the actual test was noticeably harder though, but maybe I just test badly. Matt Osbun Web Developer Health Systems, International -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Monday, May 23, 2005 1:55 PM To: CF-Talk Subject: Re: CF Certification CF Exam Buster was what I was told to look up. I have downloaded it, but haven't played with it - yet. Hey, it's only been about 1.5 years, I'll get to it. :) Ray Ian Skinner wrote: If one had a chance to have one's company pay for a CF Developer Certification. But wasn't 100% sure one would pass. Where could one go for a realistic trial? -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| 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:207462 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: CFLDAP Dynimic Query
CFDUMP returns all the records and everything looks goods. It displays all the data and puts [empty string] for nulls. These are the field names it returns: COMPANY EMPLOYEEID FACSIMILETELEPHONENUMBER GIVENNAME HOMEPHONE INITIALS L MAIL MOBILE OTHERTELEPHONE PAGER PHYSICALDELIVERYOFFICENAME SAMACCOUNTNAME SN ST TELEPHONENUMBER TITLE Nothing complex about any of these values. What do you suggest as other ideas for exporting LDAP data. CSVDE? Using SQL Server 2000. 1. As previously mentioned, cfdump the query and look for any non-string (non-simple) values. Also, what are the ldap attributes you are outputting when this errors? 2. If you want to export data from ldap to a database, there may be a better way. What is your ldap server and database server make and model? M!ke -Original Message- From: Scott Sylvester [mailto:[EMAIL PROTECTED] Sent: Monday, May 23, 2005 1:06 PM To: CF-Talk Subject: RE: CFLDAP Dynimic Query hmm, the values I'm returning from the LDAP query are simple values. When I use your code below, it lists out each field names I'm querying, followed by the message that it's a complex query and needs special handeling per the if statement for all 783 records. But, since I know the field names in this test case I use: cfouput query=results #company# #st# #employeeID# /cfoutput and it returns the values just fine for all 783 records. What I ultimatley want to do is write all the values to .txt file seperated by commas so I can import them into another table. I don't need the records to be displayed on the screen at all. ~| 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:207463 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 Certification
/aol on Weeg's comment. I'm a terrible tester, but still managed to do respectably well on the cert test on my first shot. I know I tripped up on some of the more, shall we say, circuitously presented problems, and there's a lot of questions asking if ArrayNew or NewArray is the correct syntax, etc., but it's not a killer. I found the Brain Bench Oracle admin tests to be a lot harder, personally. Basically, if you use CF in your everyday work and know what you're doing, you'll at least get a basic certification. And definitely try the exam buster - it'll clue you into how the test is presented and you'll be a little more comfortable with the whole thing when you take it (YMMV). - Jim Tony Weeg wrote: how often must we re-up our cert? also, i used exam buster, and passed. now, im a special case as i only got 850 on my sat's and basically 1.6'd my way through high school :) i test horribly, and i passed the cfmx test. tw On 5/23/05, Matt Osbun [EMAIL PROTECTED] wrote: That's what I used as a prep. It was pretty good at pointing out a lot of the changes between CF5 and CFMX- I had never used CFMX before the test, so that was important. Good mix of questions, and a large enough list of questions that it took awhile before I got to the point where I was doing well simply because I'd seen the questions a few times before... ;) I think the actual test was noticeably harder though, but maybe I just test badly. Matt Osbun Web Developer Health Systems, International -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Monday, May 23, 2005 1:55 PM To: CF-Talk Subject: Re: CF Certification CF Exam Buster was what I was told to look up. I have downloaded it, but haven't played with it - yet. Hey, it's only been about 1.5 years, I'll get to it. :) Ray Ian Skinner wrote: If one had a chance to have one's company pay for a CF Developer Certification. But wasn't 100% sure one would pass. Where could one go for a realistic trial? -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| 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:207464 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
cffile without path
my cffile tag isn't bombing when written this way cffile action=append file=Presentations.txt output=blah any thoughts what file is being updated? (access to server is restricted to me so I want to communicate clearly with sysadmin) -Joshua O'Connor-Rose -All is Good __ Do you Yahoo!? Yahoo! Small Business - Try our new Resources site http://smallbusiness.yahoo.com/resources/ ~| 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:207465 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: CFLDAP Dynimic Query
These look like Windows Active Directory attributes. So, I will assume you are using AD and SQL 2000 on the same domain. If so, you can use ADSI in a custom ActiveX task in a DTS package to pull the data from AD and insert it into SQL Server. It will be much faster than putting a web server between the two. If you would like to see some code, I'd be happy to post it. As far as this problem, I would start with outputting only a single attribute and running the page. If there are no errors, I would swap out another attribute and continue until I pinpointed the offending attribute. I would agree with you that these are simple-value attributes. These cannot hold binary information and I don't think any of these hold multi-values either. Although multi-values won't cause an error to be thrown. It could very well be another issue in unrelated code on the same page. M!ke -Original Message- From: Scott Sylvester [mailto:[EMAIL PROTECTED] Sent: Monday, May 23, 2005 2:41 PM To: CF-Talk Subject: RE: CFLDAP Dynimic Query CFDUMP returns all the records and everything looks goods. It displays all the data and puts [empty string] for nulls. These are the field names it returns: COMPANY EMPLOYEEID FACSIMILETELEPHONENUMBER GIVENNAME HOMEPHONE INITIALS L MAIL MOBILE OTHERTELEPHONE PAGER PHYSICALDELIVERYOFFICENAME SAMACCOUNTNAME SN ST TELEPHONENUMBER TITLE Nothing complex about any of these values. What do you suggest as other ideas for exporting LDAP data. CSVDE? Using SQL Server 2000. ~| 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:207466 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: CFLDAP Dynimic Query
Sorry, forgot the row part of the array notation. This is tested and should work, change query name Entity as appropriate. cfoutput query=Entity cfloop list=#entity.columnList# index=col cfif isSimpleValue(entity[col][entity.currentRow]) strong#col#/strong #entity[col][entity.currentRow]#br/ cfelse #col# is not a simple value.br/ /cfif /cfloop /cfoutput -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning -Original Message- From: Scott Sylvester [mailto:[EMAIL PROTECTED] Sent: Monday, May 23, 2005 11:06 AM To: CF-Talk Subject: RE: CFLDAP Dynimic Query hmm, the values I'm returning from the LDAP query are simple values. When I use your code below, it lists out each field names I'm querying, followed by the message that it's a complex query and needs special handeling per the if statement for all 783 records. But, since I know the field names in this test case I use: cfouput query=results #company# #st# #employeeID# /cfoutput and it returns the values just fine for all 783 records. What I ultimatley want to do is write all the values to .txt file seperated by commas so I can import them into another table. I don't need the records to be displayed on the screen at all. ~| 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:207467 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: CFLDAP Dynimic Query
Thanks. Randy --- Ian Skinner [EMAIL PROTECTED] wrote: Sorry, forgot the row part of the array notation. This is tested and should work, change query name Entity as appropriate. cfoutput query=Entity cfloop list=#entity.columnList# index=col cfif isSimpleValue(entity[col][entity.currentRow]) strong#col#/strong #entity[col][entity.currentRow]#br/ cfelse #col# is not a simple value.br/ /cfif /cfloop /cfoutput -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning -Original Message- From: Scott Sylvester [mailto:[EMAIL PROTECTED] Sent: Monday, May 23, 2005 11:06 AM To: CF-Talk Subject: RE: CFLDAP Dynimic Query hmm, the values I'm returning from the LDAP query are simple values. When I use your code below, it lists out each field names I'm querying, followed by the message that it's a complex query and needs special handeling per the if statement for all 783 records. But, since I know the field names in this test case I use: cfouput query=results #company# #st# #employeeID# /cfoutput and it returns the values just fine for all 783 records. What I ultimatley want to do is write all the values to .txt file seperated by commas so I can import them into another table. I don't need the records to be displayed on the screen at all. ~| 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:207468 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
Grouping content in a cfmail
You can save the grouped output to a variable using cfsavecontent. I'm trying to group my content in a cfmail tag. I don't need to group the emails (it's only being sent to one person, but I need to group the queried content within the email. Like Group 1 blah blah blah Group 2 blah blah blah And so on. I've been using CFMAIL GROUP=fieldname query=queryName CFOUTPUTfieldname/CFOUTPUT CFMAIL Which is grouping properly, but it sends out a new email for each group as well. I just want one email with everything grouped within in. Has anyone done this? Thanks, Randy __ Do you Yahoo!? Yahoo! Small Business - Try our new Resources site http://smallbusiness.yahoo.com/resources/ ~| 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:207469 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
cfc caching?
I am inheriting a project that uses CFC's and have essentially no experience with them. I am trying to make some edits to a particular method (a new optional argument) with some new functionality if the argument exists. The next time I invoke the CFC with the new argument the new functionality does not execute. I've looked around to see if the CFC is being cached or if it has something to do with class reloading but I've rebooted the CF service and nothing seemed to change. I've also added: reloadtrue/reload compiletrue/compile to jrun-web.xml but did not seem to solve my problem either. Any direction would be much appreciated. Thanks in advance. - Tim ~| 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:207470 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: Migrate Settings from 6.1 to 7
J, We are moving hosting companies so we don't have this ability. jonese On 5/23/05, Jared Rypka-Hauer - CMG, LLC [EMAIL PROTECTED] wrote: You'd be better off to copy the CFusionMX folder to the new server and install 7 to let it handle its own upgrade process than to try migrating settings after the fact. If you do that, 7 will self-integrate all the settings from 6.1 the first time you run CFAdmin. Laterz, J On 5/23/05, jonese [EMAIL PROTECTED] wrote: Is there any easy way to migrate mappings and datasources from CF6.1 to CF 7 when they are on two differant servers? Can i just copy the .xml files from one to the other? jonese -- --- - Buy SQLSurveyor! http://www.web-relevant.com/sqlsurveyor Never make your developers open Enterprise Manager again. ~| 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:207471 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: CFLDAP Dynimic Query
I would like to see some code if you think it will be able to address the issue of the Active Directory fields being unkown and coming from a user input screen. Thanks for your replys!! These look like Windows Active Directory attributes. So, I will assume you are using AD and SQL 2000 on the same domain. If so, you can use ADSI in a custom ActiveX task in a DTS package to pull the data from AD and insert it into SQL Server. It will be much faster than putting a web server between the two. If you would like to see some code, I'd be happy to post it. As far as this problem, I would start with outputting only a single attribute and running the page. If there are no errors, I would swap out another attribute and continue until I pinpointed the offending attribute. I would agree with you that these are simple-value attributes. These cannot hold binary information and I don't think any of these hold multi-values either. Although multi-values won't cause an error to be thrown. It could very well be another issue in unrelated code on the same page. M!ke -Original Message- From: Scott Sylvester [mailto:[EMAIL PROTECTED] Sent: Monday, May 23, 2005 2:41 PM To: CF-Talk Subject: RE: CFLDAP Dynimic Query CFDUMP returns all the records and everything looks goods. It displays all the data and puts [empty string] for nulls. These are the field names it returns: COMPANY EMPLOYEEID FACSIMILETELEPHONENUMBER GIVENNAME HOMEPHONE INITIALS L MAIL MOBILE OTHERTELEPHONE PAGER PHYSICALDELIVERYOFFICENAME SAMACCOUNTNAME SN ST TELEPHONENUMBER TITLE Nothing complex about any of these values. What do you suggest as other ideas for exporting LDAP data. CSVDE? Using SQL Server 2000. ~| 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:207472 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: CFLDAP Dynimic Query
Ian, This snippet of code is outputing all the records perfectly without the simple data error. Thank you! ~| 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:207473 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: CFLDAP Dynimic Query
My code expects the attributes to be there always. I guess you could run the DTS package from CF if you need it to be dynamic. My question is why can't you specify all attributes all the time? Why the need to select specific ones? That would clarify it for me. M!ke -Original Message- From: Scott Sylvester [mailto:[EMAIL PROTECTED] Sent: Monday, May 23, 2005 3:29 PM To: CF-Talk Subject: RE: CFLDAP Dynimic Query I would like to see some code if you think it will be able to address the issue of the Active Directory fields being unkown and coming from a user input screen. Thanks for your replys!! ~| 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:207474 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: Migrate Settings from 6.1 to 7
Jonese, Hmmm... that being the case, how would you get access to the server's config files at all? I don't think you can just copy the XML files across because CFMX 7 has enough differences that it probably won't work. You could save the XML files, create a developer edition of 6.1, upgrade that to 7, and then deploy with the resulting XML files, except they contain pathing information and so on that would make this a very touchy issue. You might be better off to just take notes and deploy by hand. Hopefully, one of the Macromedia CFMX product people (Tim? Oh, Tim?) will stop in and see this question. Sorry to be unhelpful, you're in a sticky spot... I don't think there's an easy answer. Laterz, J On 5/23/05, jonese [EMAIL PROTECTED] wrote: J, We are moving hosting companies so we don't have this ability. jonese -- --- - Buy SQLSurveyor! http://www.web-relevant.com/sqlsurveyor Never make your developers open Enterprise Manager again. ~| 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:207475 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
New to CFMX - session problem
I upgraded a server from CF 4.5 to MX 6.1. Previously, when a user closed their browser (without 'logging off'), the session expired. This is no longer happening. From what I can find, MX uses session variables differently, but I can't find anything that tells me what I need to do to get sessions to expire when the browser closes. I have tried to enable/disable J2EE Session variables from within the administrator, which did not solve this problem. Anything further I need to do? Thanks for your help. 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:207476 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: cfc caching?
I don't suppose it would be possible to see some code? This sort of thing is hard to troubleshoot without some specifics... the one thing that comes to mind is this: Is it possible that you're editing a different copy of the file that's actually executing? I've had this happen when I'm editing /site/test/my.cfc and trying to run /site/cfc/my.cfc... just a thought. You might try CFDUMPing the page context's getBuiltinScopes() results (cfdump var=#getPageContext().getBuiltinScopes()# /) to see what's going on in the page. I'd also recommend something like a test.cfm that calls the CFC in question. Do something to provoke an error, maybe... like temporarily change the name of the CFC file, just to see what happens. It's entirely possible that an error message like that would give you enough information to figure out what's going on. Laterz, J On 5/23/05, Tim McGovern [EMAIL PROTECTED] wrote: I am inheriting a project that uses CFC's and have essentially no experience with them. I am trying to make some edits to a particular method (a new optional argument) with some new functionality if the argument exists. The next time I invoke the CFC with the new argument the new functionality does not execute. I've looked around to see if the CFC is being cached or if it has something to do with class reloading but I've rebooted the CF service and nothing seemed to change. I've also added: reloadtrue/reload compiletrue/compile to jrun-web.xml but did not seem to solve my problem either. Any direction would be much appreciated. Thanks in advance. - Tim -- --- - Buy SQLSurveyor! http://www.web-relevant.com/sqlsurveyor Never make your developers open Enterprise Manager again. ~| 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:207477 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: New to CFMX - session problem - CANCEL
Sorry, using J2EE Sessions variables does fix the problem. -Original Message- From: Mike Klostermeyer [mailto:[EMAIL PROTECTED] Sent: Monday, May 23, 2005 3:53 PM To: CF-Talk Subject: New to CFMX - session problem I upgraded a server from CF 4.5 to MX 6.1. Previously, when a user closed their browser (without 'logging off'), the session expired. This is no longer happening. From what I can find, MX uses session variables differently, but I can't find anything that tells me what I need to do to get sessions to expire when the browser closes. I have tried to enable/disable J2EE Session variables from within the administrator, which did not solve this problem. Anything further I need to do? Thanks for your help. Mike ~| 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:207478 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: Migrate Settings from 6.1 to 7
One other option is to see if the hosting company will create a .car archive for you although to deploy it you may need CF enterprise. Kola -Original Message- From: jonese [mailto:[EMAIL PROTECTED] Sent: 23 May 2005 20:16 To: CF-Talk Subject: Re: Migrate Settings from 6.1 to 7 J, We are moving hosting companies so we don't have this ability. jonese On 5/23/05, Jared Rypka-Hauer - CMG, LLC [EMAIL PROTECTED] wrote: You'd be better off to copy the CFusionMX folder to the new server and install 7 to let it handle its own upgrade process than to try migrating settings after the fact. If you do that, 7 will self-integrate all the settings from 6.1 the first time you run CFAdmin. Laterz, J On 5/23/05, jonese [EMAIL PROTECTED] wrote: Is there any easy way to migrate mappings and datasources from CF6.1 to CF 7 when they are on two differant servers? Can i just copy the .xml files from one to the other? jonese -- --- - Buy SQLSurveyor! http://www.web-relevant.com/sqlsurveyor Never make your developers open Enterprise Manager again. ~| 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:207479 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: cffile without path
I read in the docs (for action=upload) that relative paths are calculated relative to some directory (windows temp or something??) but you can look that up. What does #ExpandPath(Presentations.txt)# return? Aaron - Original Message - From: Joshua OConnor-Rose [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, May 24, 2005 5:48 AM Subject: cffile without path my cffile tag isn't bombing when written this way cffile action=append file=Presentations.txt output=blah any thoughts what file is being updated? (access to server is restricted to me so I want to communicate clearly with sysadmin) -Joshua O'Connor-Rose -All is Good __ Do you Yahoo!? Yahoo! Small Business - Try our new Resources site http://smallbusiness.yahoo.com/resources/ ~| 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:207480 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
anyone have statistex?
Does anyone have a working copy of statistex for site stats? Please contact me off list. 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:207481 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 Certification
/aol ? dont get it? tw On 5/23/05, Jim Campbell [EMAIL PROTECTED] wrote: /aol on Weeg's comment. I'm a terrible tester, but still managed to do respectably well on the cert test on my first shot. I know I tripped up on some of the more, shall we say, circuitously presented problems, and there's a lot of questions asking if ArrayNew or NewArray is the correct syntax, etc., but it's not a killer. I found the Brain Bench Oracle admin tests to be a lot harder, personally. Basically, if you use CF in your everyday work and know what you're doing, you'll at least get a basic certification. And definitely try the exam buster - it'll clue you into how the test is presented and you'll be a little more comfortable with the whole thing when you take it (YMMV). - Jim Tony Weeg wrote: how often must we re-up our cert? also, i used exam buster, and passed. now, im a special case as i only got 850 on my sat's and basically 1.6'd my way through high school :) i test horribly, and i passed the cfmx test. tw On 5/23/05, Matt Osbun [EMAIL PROTECTED] wrote: That's what I used as a prep. It was pretty good at pointing out a lot of the changes between CF5 and CFMX- I had never used CFMX before the test, so that was important. Good mix of questions, and a large enough list of questions that it took awhile before I got to the point where I was doing well simply because I'd seen the questions a few times before... ;) I think the actual test was noticeably harder though, but maybe I just test badly. Matt Osbun Web Developer Health Systems, International -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Monday, May 23, 2005 1:55 PM To: CF-Talk Subject: Re: CF Certification CF Exam Buster was what I was told to look up. I have downloaded it, but haven't played with it - yet. Hey, it's only been about 1.5 years, I'll get to it. :) Ray Ian Skinner wrote: If one had a chance to have one's company pay for a CF Developer Certification. But wasn't 100% sure one would pass. Where could one go for a realistic trial? -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| 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:207482 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 Certification
http://catb.org/~esr/jargon/html/A/AOL-.html :) - Jim Tony Weeg wrote: /aol ? dont get it? tw On 5/23/05, Jim Campbell [EMAIL PROTECTED] wrote: /aol on Weeg's comment. I'm a terrible tester, but still managed to do respectably well on the cert test on my first shot. I know I tripped up on some of the more, shall we say, circuitously presented problems, and there's a lot of questions asking if ArrayNew or NewArray is the correct syntax, etc., but it's not a killer. I found the Brain Bench Oracle admin tests to be a lot harder, personally. Basically, if you use CF in your everyday work and know what you're doing, you'll at least get a basic certification. And definitely try the exam buster - it'll clue you into how the test is presented and you'll be a little more comfortable with the whole thing when you take it (YMMV). - Jim Tony Weeg wrote: how often must we re-up our cert? also, i used exam buster, and passed. now, im a special case as i only got 850 on my sat's and basically 1.6'd my way through high school :) i test horribly, and i passed the cfmx test. tw On 5/23/05, Matt Osbun [EMAIL PROTECTED] wrote: That's what I used as a prep. It was pretty good at pointing out a lot of the changes between CF5 and CFMX- I had never used CFMX before the test, so that was important. Good mix of questions, and a large enough list of questions that it took awhile before I got to the point where I was doing well simply because I'd seen the questions a few times before... ;) I think the actual test was noticeably harder though, but maybe I just test badly. Matt Osbun Web Developer Health Systems, International -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Monday, May 23, 2005 1:55 PM To: CF-Talk Subject: Re: CF Certification CF Exam Buster was what I was told to look up. I have downloaded it, but haven't played with it - yet. Hey, it's only been about 1.5 years, I'll get to it. :) Ray Ian Skinner wrote: If one had a chance to have one's company pay for a CF Developer Certification. But wasn't 100% sure one would pass. Where could one go for a realistic trial? -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| 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:207483 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: cfc caching?
reloadtrue/reload compiletrue/compile does not apply to CFCs at all as Jared mentiond, show me the code! :) Check out the application.cfm file, possibly the CFC is stored in the application or session scope. DK On 5/23/05, Jared Rypka-Hauer - CMG, LLC [EMAIL PROTECTED] wrote: I don't suppose it would be possible to see some code? This sort of thing is hard to troubleshoot without some specifics... the one thing that comes to mind is this: Is it possible that you're editing a different copy of the file that's actually executing? I've had this happen when I'm editing /site/test/my.cfc and trying to run /site/cfc/my.cfc... just a thought. You might try CFDUMPing the page context's getBuiltinScopes() results (cfdump var=#getPageContext().getBuiltinScopes()# /) to see what's going on in the page. I'd also recommend something like a test.cfm that calls the CFC in question. Do something to provoke an error, maybe... like temporarily change the name of the CFC file, just to see what happens. It's entirely possible that an error message like that would give you enough information to figure out what's going on. Laterz, J On 5/23/05, Tim McGovern [EMAIL PROTECTED] wrote: I am inheriting a project that uses CFC's and have essentially no experience with them. I am trying to make some edits to a particular method (a new optional argument) with some new functionality if the argument exists. The next time I invoke the CFC with the new argument the new functionality does not execute. I've looked around to see if the CFC is being cached or if it has something to do with class reloading but I've rebooted the CF service and nothing seemed to change. I've also added: reloadtrue/reload compiletrue/compile to jrun-web.xml but did not seem to solve my problem either. Any direction would be much appreciated. Thanks in advance. - Tim -- --- - Buy SQLSurveyor! http://www.web-relevant.com/sqlsurveyor Never make your developers open Enterprise Manager again. ~| 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:207484 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: CFMX 6.1, WSDL, and JSessionID's
I guess the part that I'm trying to verify here is that CFMX passes on this jsessionid along with the web service request? I've got jsessionID's enabled via the CFMX administrator, so is there any way to verify that the jsessionid is passed along with the WSDL request? Thanks for the help! -JM Jared Rypka-Hauer - CMG, LLC wrote: Jordan, For ever session, CF creates cfid and cftoken, url_token, and Jrun (if using J2EE sessions) adds a jsessionid as well. Those are going to always be the same IDs across that single session provided that you have setclientcookies=true in your Application.cfm/.cfc or you're correctly passing url_token around in your links and relocates. So you could use #cfid#_#cftoken# or #jsessionid# (just cfdump the session scope to see its exact contents) to accomplish this. If it's not maintaining your sessions, then you have a different problem and I'd study up on the particulars of the cfapplication tag or application.cfc to make this work. Laterz, J On 5/23/05, Jordan Michaels [EMAIL PROTECTED] wrote: Hello! I'm currently attempting to make use of a web service that supports paging. For example, I can pass on a search to a web service, and then (presumably) hit the next page button to get the next page of results from the web service. The problem I'm running into (I think) is that CF is not passing on the same session id that it used to make the previous request, so the nextPage method fails. Is there any way that I can have cold fusion use the same session ID for every invocation of this web service? I have a workaround, but I'd prefer not to use it as it requires that I grab ALL the results in one call and then page through them manually. If I was able to use the NextPage method calls to this web service would require much less bandwidth. Thanks in advance! -- Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ [EMAIL PROTECTED] -- Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ [EMAIL PROTECTED] ~| 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:207485 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: New to CFMX - session problem
Actually CF's sessioning has always been via cookies which have a 20-minute lifespan (or as configured via sessiontimeout or the CFAdmin). Since 3.1.1, anyway, sessions have outlasted the browser being closed by the value of the timeout... that is, the session will die 20 minutes or sooner after shutting the browser down, depending on how long it's been since the last activity on the site. Afaik, when using J2EE sessions they should expire when the browser closes because J2EE sessions are in-memory cookies. You could also try using cfapplication's setclientcookies=false attribute to prevent them being set at all, but that'll mean you need to append url_token to your links and includes to keep the sessions intact as the user navigates your site. Hitting a link with no ID/Token will kill the session and cause a new one to be created. Hth, J On 5/23/05, Mike Klostermeyer [EMAIL PROTECTED] wrote: I upgraded a server from CF 4.5 to MX 6.1. Previously, when a user closed their browser (without 'logging off'), the session expired. This is no longer happening. From what I can find, MX uses session variables differently, but I can't find anything that tells me what I need to do to get sessions to expire when the browser closes. I have tried to enable/disable J2EE Session variables from within the administrator, which did not solve this problem. Anything further I need to do? Thanks for your help. 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:207486 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: CFMX 6.1, WSDL, and JSessionID's
No, session variables are not passed along autmatically as part of a webservice call. If you want to do that, you're going to need to make sure that session.jsessionid is passed to the webservice as part of an argument structure. We just had this discussion at our CFUG a while back... you have to manually pass the session info to the webservice. Laterz, J On 5/23/05, Jordan Michaels [EMAIL PROTECTED] wrote: I guess the part that I'm trying to verify here is that CFMX passes on this jsessionid along with the web service request? I've got jsessionID's enabled via the CFMX administrator, so is there any way to verify that the jsessionid is passed along with the WSDL request? Thanks for the help! -JM -- --- - Buy SQLSurveyor! http://www.web-relevant.com/sqlsurveyor Never make your developers open Enterprise Manager again. ~| 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:207487 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: global module call
http://www.cflib.org/udf.cfm?ID=841 What I didn't like about this one personally was that it handled the file paths one character at a time instead of one directory at a time, which could cause problems if you had two similarly named directories or somehow had a combination of forward-and-back slashes. /myfiles/ /myfiles_x/ /myfiles_y/ If you were trying to get a path from something in /myfiles/ to something in /myfiles_x/ or vice versa it might cause a problem. I hadn't tested it, but it looked to me like that might be an issue. No, this isn't an issue. You can try it by yourself :-) Yeah, I just noticed the replace() at the top to handle the slashes and the regular expression below that removes the last directory name or portion from the shared path (which resolves what I just described above)... there were a few other things I didn't care for - nothing really huge. The function requires the source path to be provided instead of using a default of the current directory, there are two loops which could be replaced with listlen() or repeatString() respectively. The listlen() loop in particular is probably fairly inefficient as it involves an indeterminate number of find() calls. s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| 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:207488 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: CFMX 6.1, WSDL, and JSessionID's
Hmm... after attempting to manually send the jsessionid I took a closer look at the web service specs, and it appears as though it's the web service itself attempts to set the jsessionid. It does this by attempting to set a jsessionid cookie on the first search request, then, if the web service is invoked again using the NextPage method it tries to access that jsessionid cookie. I guess it boils down to how CFMX processes its invokes. If a web service attempts to set a cookie like that, does CFMX retain the cookie? Or is cookie data ignored? Thanks again! -JM Jared Rypka-Hauer - CMG, LLC wrote: No, session variables are not passed along autmatically as part of a webservice call. If you want to do that, you're going to need to make sure that session.jsessionid is passed to the webservice as part of an argument structure. We just had this discussion at our CFUG a while back... you have to manually pass the session info to the webservice. Laterz, J On 5/23/05, Jordan Michaels [EMAIL PROTECTED] wrote: I guess the part that I'm trying to verify here is that CFMX passes on this jsessionid along with the web service request? I've got jsessionID's enabled via the CFMX administrator, so is there any way to verify that the jsessionid is passed along with the WSDL request? Thanks for the help! -JM -- Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ [EMAIL PROTECTED] ~| 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:207489 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: CFMX 6.1, WSDL, and JSessionID's
Jordan... That's kinda strange. My first thought would be that the webservice would be setting that cookie to a namespace in CFMX, not at the browser where it needs to be to stay connected to that user... if that's even possible. Um... you could try CFDUMPing the results of the first webservice call to see if you see a jsessionid, and then set it to a cookie yourself. I'm just not sure how you'd pass that back into the webservice. Is this a CF webservice or some other technology? It would probably work like a cookie being set as a result of a cfhttp call... it would exist in the headers immediately after the call, but would be discarded once that cfhttp struct was destroyed (like... on the next request). You might want to try cfdumping getHttpRequestData(). You might be able to get by with trapping that jsessionid into a different variable and then setting it into a header for the webservice call. I'd have to mess with it to tell you exactly how. Laterz, J On 5/23/05, Jordan Michaels [EMAIL PROTECTED] wrote: Hmm... after attempting to manually send the jsessionid I took a closer look at the web service specs, and it appears as though it's the web service itself attempts to set the jsessionid. It does this by attempting to set a jsessionid cookie on the first search request, then, if the web service is invoked again using the NextPage method it tries to access that jsessionid cookie. I guess it boils down to how CFMX processes its invokes. If a web service attempts to set a cookie like that, does CFMX retain the cookie? Or is cookie data ignored? Thanks again! -JM -- --- - Buy SQLSurveyor! http://www.web-relevant.com/sqlsurveyor Never make your developers open Enterprise Manager again. ~| 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:207490 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: anyone have statistex?
I have a copy of the trial version. Would love to get the full version but the wellman website is no longer. Steve Kahn wrote: Does anyone have a working copy of statistex for site stats? Please contact me off list. 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:207491 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 Certification
:) a im s not a geek. On 5/23/05, Jim Campbell [EMAIL PROTECTED] wrote: http://catb.org/~esr/jargon/html/A/AOL-.html :) - Jim Tony Weeg wrote: /aol ? dont get it? tw On 5/23/05, Jim Campbell [EMAIL PROTECTED] wrote: /aol on Weeg's comment. I'm a terrible tester, but still managed to do respectably well on the cert test on my first shot. I know I tripped up on some of the more, shall we say, circuitously presented problems, and there's a lot of questions asking if ArrayNew or NewArray is the correct syntax, etc., but it's not a killer. I found the Brain Bench Oracle admin tests to be a lot harder, personally. Basically, if you use CF in your everyday work and know what you're doing, you'll at least get a basic certification. And definitely try the exam buster - it'll clue you into how the test is presented and you'll be a little more comfortable with the whole thing when you take it (YMMV). - Jim Tony Weeg wrote: how often must we re-up our cert? also, i used exam buster, and passed. now, im a special case as i only got 850 on my sat's and basically 1.6'd my way through high school :) i test horribly, and i passed the cfmx test. tw On 5/23/05, Matt Osbun [EMAIL PROTECTED] wrote: That's what I used as a prep. It was pretty good at pointing out a lot of the changes between CF5 and CFMX- I had never used CFMX before the test, so that was important. Good mix of questions, and a large enough list of questions that it took awhile before I got to the point where I was doing well simply because I'd seen the questions a few times before... ;) I think the actual test was noticeably harder though, but maybe I just test badly. Matt Osbun Web Developer Health Systems, International -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Monday, May 23, 2005 1:55 PM To: CF-Talk Subject: Re: CF Certification CF Exam Buster was what I was told to look up. I have downloaded it, but haven't played with it - yet. Hey, it's only been about 1.5 years, I'll get to it. :) Ray Ian Skinner wrote: If one had a chance to have one's company pay for a CF Developer Certification. But wasn't 100% sure one would pass. Where could one go for a realistic trial? -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| 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:207492 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) Object tag - text/html in IE Cross Domain
-Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: Sunday, May 22, 2005 12:44 PM To: CF-Talk Subject: RE: (OT) Object tag - text/html in IE Cross Domain It works in NS 7 and Opera 7.5 too. What are they're published security parameters for this? Again - I'm not saying that it doesn't work in other browsers. I'm saying that it's potentially a security issue and may go away - I would write to the browser vendors and ask about it point blank: is this a supported feature or an oversight that you'll be eliminating. Jim Davis ~| 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:207493 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) Object tag - text/html in IE Cross Domain
Damn - I'll go to the grave still typing They're when I mean Their. ;^) Jim Davis -Original Message- From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: Monday, May 23, 2005 8:26 PM To: CF-Talk Subject: RE: (OT) Object tag - text/html in IE Cross Domain -Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: Sunday, May 22, 2005 12:44 PM To: CF-Talk Subject: RE: (OT) Object tag - text/html in IE Cross Domain It works in NS 7 and Opera 7.5 too. What are they're published security parameters for this? Again - I'm not saying that it doesn't work in other browsers. I'm saying that it's potentially a security issue and may go away - I would write to the browser vendors and ask about it point blank: is this a supported feature or an oversight that you'll be eliminating. 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:207494 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
There's got to be a way around this
It seems that on every Cold Fusion page that processes variables from a previous page -- say a form and the page that processes the form -- every variable on the form must be accounted for. This is fine if the form is unchanging, but if the form is dynamic and might change every time it's loaded, the number and name of the variables that it passes to the processing page may change. In PHP you can cope with this quite nicely by directly accessing the HTTP_POST[] array, casting it to an object and looping through the properties, but I can't find a similar way to do that in Cold Fusion. In Cold Fusion, it looks like I have to use CFPARAM var=value for every single possible variable that might come from the form page. Is there a way around that? -- Richard S. Crawford Programmer III UC Davis Extension Distance Education Group 2901 K Street Sacramento, CA 95816 (916)327-7793 http://unexdlc.ucdavis.edu ~| 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:207495 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: cffile without path
I read in the docs (for action=upload) that relative paths are calculated relative to some directory (windows temp or something??) but you can look that up. What does #ExpandPath(Presentations.txt)# return? An absolute path to the specified relative path from the directory containing the current base template (this is silly). So for instance, if you look at http://www.mysite.com/store/index.cfm and this file contains #expandPath(file.txt)# the path returned will be an absolute path to a file.txt file located in the store directory, i.e. url to file = http://www.mysite.com/store/file.txt theoretical value of expantpath() = c:\inetpub\wwwroot\store\file.txt If /store/index.cfm includes another file located elsewhere, for instance /wwwroot/snarfle/the/garthak.cfm and this other garthak.cfm template then contains #expandPath(file.txt)# the value of expandpath() will be the same... which is why I say it's silly, and I never use it, because I never care what the location of the base template is, because nothing else in ColdFusion uses relative paths from the base template, and since the base template directory can change it can also modify (read gum-up) an absolute file path. It would have made a lot more sense for it to expand from the current template path, since the relative path from the current template to the target file won't change, but that's not what we got. s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| 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:207496 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: There's got to be a way around this
FORM is a structure that contains all HTTP POST fields, and you can loop through it easily. --- Ben -Original Message- From: Richard Crawford [mailto:[EMAIL PROTECTED] Sent: Monday, May 23, 2005 9:15 PM To: CF-Talk Subject: There's got to be a way around this It seems that on every Cold Fusion page that processes variables from a previous page -- say a form and the page that processes the form -- every variable on the form must be accounted for. This is fine if the form is unchanging, but if the form is dynamic and might change every time it's loaded, the number and name of the variables that it passes to the processing page may change. In PHP you can cope with this quite nicely by directly accessing the HTTP_POST[] array, casting it to an object and looping through the properties, but I can't find a similar way to do that in Cold Fusion. In Cold Fusion, it looks like I have to use CFPARAM var=value for every single possible variable that might come from the form page. Is there a way around that? -- Richard S. Crawford Programmer III UC Davis Extension Distance Education Group 2901 K Street Sacramento, CA 95816 (916)327-7793 http://unexdlc.ucdavis.edu ~| 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:207497 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) Object tag - text/html in IE Cross Domain
ROFL. It's similar to an iframe in the way it works (and that's how I ended up doing it) but there is one small difference - an iframe's navigation is self-contained (i.e. links open inside the iframe) whereas the object tag's links (by default) target the browser containing the tag like any other. This difference may be more of a security hassle, I guess. Luckily in this instance the code I included had no links so the end result was anlomst identical using the iframe. -Original Message- From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: Tuesday, 24 May 2005 8:37 To: CF-Talk Subject: RE: (OT) Object tag - text/html in IE Cross Domain Damn - I'll go to the grave still typing They're when I mean Their. ;^) Jim Davis -Original Message- From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: Monday, May 23, 2005 8:26 PM To: CF-Talk Subject: RE: (OT) Object tag - text/html in IE Cross Domain -Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: Sunday, May 22, 2005 12:44 PM To: CF-Talk Subject: RE: (OT) Object tag - text/html in IE Cross Domain It works in NS 7 and Opera 7.5 too. What are they're published security parameters for this? Again - I'm not saying that it doesn't work in other browsers. I'm saying that it's potentially a security issue and may go away - I would write to the browser vendors and ask about it point blank: is this a supported feature or an oversight that you'll be eliminating. ~| 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:207498 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: CFMX 6.1, WSDL, and JSessionID's
Jared Rypka-Hauer - CMG, LLC wrote: Jordan... That's kinda strange. My thoughts exactly. ;) My first thought would be that the webservice would be setting that cookie to a namespace in CFMX, not at the browser where it needs to be to stay connected to that user... if that's even possible. Yeah, that's the question that I'm asking too! Unfortunately, this web service wasn't programmed by me, otherwise I'd change that. Dumping the results of the original process was my first thought as well, but unfortunately it doesn't look like the developer who created the service added a function to return the session id. Um... you could try CFDUMPing the results of the first webservice call to see if you see a jsessionid, and then set it to a cookie yourself. I'm just not sure how you'd pass that back into the webservice. Is this a CF webservice or some other technology? It's some other technology. I'm not sure which. The extension is .svc, but that really doesn't say much to me. And even if it did, it could be changed so... no telling. It would probably work like a cookie being set as a result of a cfhttp call... it would exist in the headers immediately after the call, but would be discarded once that cfhttp struct was destroyed (like... on the next request). Again, this was my thought as well. I just thought there was maybe something I was missing... I was hoping there was anyway... You might want to try cfdumping getHttpRequestData(). You might be able to get by with trapping that jsessionid into a different variable and then setting it into a header for the webservice call. I'd have to mess with it to tell you exactly how. ::sigh:: You know what the worst part is? This is a flat rate contract, and I've already lost money on it. So I'm about to throw up my hands and say screw it rather then attempt to find some funky work-around that may or may not work in the end. Knowing me though, I won't rest until I've figured out how to get this bugger to work - funky or not. Laterz, J Thanks for all your help Jared. It's nice to have a second opinion on stuff like this. ;) -JM On 5/23/05, Jordan Michaels [EMAIL PROTECTED] wrote: Hmm... after attempting to manually send the jsessionid I took a closer look at the web service specs, and it appears as though it's the web service itself attempts to set the jsessionid. It does this by attempting to set a jsessionid cookie on the first search request, then, if the web service is invoked again using the NextPage method it tries to access that jsessionid cookie. I guess it boils down to how CFMX processes its invokes. If a web service attempts to set a cookie like that, does CFMX retain the cookie? Or is cookie data ignored? Thanks again! -JM -- Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ [EMAIL PROTECTED] ~| 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:207499 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: There's got to be a way around this
It seems that on every Cold Fusion page that processes variables from a previous page -- say a form and the page that processes the form -- every variable on the form must be accounted for. This is fine if the form is unchanging, but if the form is dynamic and might change every time it's loaded, the number and name of the variables that it passes to the processing page may change. In PHP you can cope with this quite nicely by directly accessing the HTTP_POST[] array, casting it to an object and looping through the properties, but I can't find a similar way to do that in Cold Fusion. In Cold Fusion, it looks like I have to use CFPARAM var=value for every single possible variable that might come from the form page. Is there a way around that? Several... cfloop index=field list=#strutkeylist(form)#.../cfloop cfif structkeyexists(form,fieldname).../cfif cfloop index=field list=fielda,fieldb,fieldc cfparam name=form.#field# type=string default=/cfloop cfset structappend(form,url,false) (puts all url variables in the form scope without overwriting) s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| 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:207500 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: There's got to be a way around this
I forgot this one: cfloop item=field collection=#form#.../cfloop s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| 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:207501 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) Object tag - text/html in IE Cross Domain
-Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: Monday, May 23, 2005 9:25 PM To: CF-Talk Subject: RE: (OT) Object tag - text/html in IE Cross Domain ROFL. It's similar to an iframe in the way it works (and that's how I ended up doing it) but there is one small difference - an iframe's navigation is self-contained (i.e. links open inside the iframe) whereas the object tag's links (by default) target the browser containing the tag like any other. This difference may be more of a security hassle, I guess. Luckily in this instance the code I included had no links so the end result was anlomst identical using the iframe. The only reason I'm being such a prick about this is that I've been through it. Our company was bought out and we wanted to combine our websites - content from both servers in the same frame. But we had all sorts of cross-site scripting issues. I spent some time and figured out an inelegant, but perfectly usable system for passing information across sites using the status bar. This was because it turned out that browsers from different domains could still both read and write to the status bar (at the time it worked in everything but IE 5.5 - although oddly it did work in IE 6). The code essentially created asynchronous messaging queues between two sites - it was actually pretty slick. (I've still got it if anybody wants to take a look.) It allowed scripts from different domains to share text data. (As an aside I still think that's something that should be allowed via some specialized code. There should be some standardized location - something like a public object which is accessible to all scripts in the instance - that way different sites that choose to share data would have the ability too, but the default behavior would be safe.) I made the mistake of posting a question about how to fix the IE 5.5 issue to a public forum which started a whole tirade about cross-site browser security. Several people sent messages to the various vendors - now my code doesn't work in any of the new browsers. Because of that I'm just overly wary of taking advantage of anything that even has shades of that. I just don't want to get used to something only to have the capability disabled just when I've gotten used to relying on it. ;^) 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:207502 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
