Re: Control Download File List
Hi Mark As far as I know, you'd need to do this use cfcontent/cfheader to deliver a file, that itself sits outside of the web root but still accessible to the CF server. If the file is within the web root, and someone has the url, CF (as far as i know) cant control access to it if the file-url is requested directly. On Fri, Oct 21, 2011 at 7:29 PM, Mark Rogers wrote: > > I am trying to create a CF template that will allow users to download files > that that have names matching a specific criteria. > > > > For example, > > > > Sample File Names in directory > > > > 133555_xyz > > 133600_abc > > 223450_abc > > 340126_oop > > 349888_abc > > > > If id code ='349234' > > allow download of any file name like '34%' > > > > In this example should only allow files 340126_oop 349888_abc > > > > for download list. > > > > Any help would be greatly appreciated > > Mark Rogers > Vice President- Information Services > National Association of Insurance and Financial Advisors > 2901 Telestar Court > Falls Church, VA 22042 > > (703) 770-8130 > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348300 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Its ColdFusion's Fault
"Myspace failed because it was full of ugly sites with content no-one wanted to read." Absolutely. And to add to it - then came along an alternative, facebook, which was not "full of ugly sites with content no-one wanted to read." So myspace failed. On Tue, Jul 26, 2011 at 6:16 AM, James Holmes wrote: > > I guess when Google+ finally destroys Facebook, the same open source tools > he's glorifying will have caused that failure. Regardless, Myspace hasn't > run on CF for a long time (as suggested, they migrated to .NET via > BlueDragon ages ago). > > Myspace failed because it was full of ugly sites with content no-one wanted > to read. > > -- > WSS4CF - WS-Security framework for CF > http://wss4cf.riaforge.org/ > > > On 26 July 2011 18:00, Kevin Pepperman wrote: > > > > > Just to add to that-- ColdFusion is responsible for the success of Bank > of > > America as well as many other successful websites (well one of the > reasons > > anyway ;-) > > > > Didn't MySpace convert to .NET at some point? > > > > -- > > /Kevin Pepperman > > > > "*Never memorize what you can look up in books*." > > --Albert_Einstein > > > > > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346329 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Odd issue with DB "pausing"
If the cache filling up is the cause - the following should provide a useful look at whats feeling it up - SELECT total_worker_time/execution_count AS [Avg CPU Time], SUBSTRING(st.text, (qs.statement_start_offset/2)+1, ((CASE qs.statement_end_offset WHEN -1 THEN DATALENGTH(st.text) ELSE qs.statement_end_offset END - qs.statement_start_offset)/2) + 1) AS statement_text,qs.creation_time,last_execution_time,execution_count FROM sys.dm_exec_query_stats AS qs CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) AS st ORDER BY qs.creation_time desc Your looking for the "same" query listed many times in the above's output - by "same" I mean queries that only differ by the values that would be parameterized... Your wanting to see as few rows as possible with execution_count = 1. According to my notes, on the system I had this happen, before adding cfqueryparam, the average(execution_count) was 1.2 - afterwards the average was in the thousands. On Mon, May 16, 2011 at 1:13 PM, Scott Weikert wrote: > > What I'm finding now, in the last little bit, is that in the case of a > content-save triggering the hang, the content *does* seem to save - the > queries being the "larger" ones as far as raw data being moved around. > > I'm in the process of poking about some older code that executes after > those queries and param-ing them up, to see that helps. > > Errors: When a hang hits, I don't seem to get any SQL errors - no > timeouts and the like - just running a simple query in the query > analyzer tool, it just spins until it finally resolves, however long it > takes. > > As far as the sql logs, my server guy hasn't indicated anything special > showing up. > > On 5/16/11 10:48 AM, Charlie Stell wrote: > > Other than an eventual timeout thrown by CF - are you getting any SQL > errors > > when this situation arises? (from either cf trying to run a query or when > > trying to execute a query via analyzer) Do any errors show up in the SQL > > logs? > > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344550 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Odd issue with DB "pausing"
Other than an eventual timeout thrown by CF - are you getting any SQL errors when this situation arises? (from either cf trying to run a query or when trying to execute a query via analyzer) Do any errors show up in the SQL logs? On Mon, May 16, 2011 at 12:37 PM, Charlie Stell wrote: > An increase of the number of queries being executed via cfquery > where queryparam isn't being used - regardless of it being from a user > request or a scheduled process... > > > On Mon, May 16, 2011 at 12:13 PM, Scott Weikert wrote: > >> >> No, no recent updates (that I'm aware of), no increase in traffic. >> >> When you say "request increase" are you talking about behind-the-scenes >> DB requests? Or an increase in usage by people with a corresponding >> increase in DB traffic? >> >> On 5/16/11 10:06 AM, Charlie Stell wrote: >> > Have you recently upgraded versions of MS-SQL? And/or recently had a >> > significant increase in requests? >> > >> > In the system I was referring to, it had been running for 3 years >> without >> > this being an issue - then we upgraded to SQL 2005 and had a request >> > increase of about 25% - at this point we started having DB hangs about >> every >> > other day. I don't know if it was the load increase or a change in >> execution >> > plan handling by SQL... but the db hangs stopped as soon as we >> incorporated >> > cfqueryparam. >> > >> > >> >> >> ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344545 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Odd issue with DB "pausing"
An increase of the number of queries being executed via cfquery where queryparam isn't being used - regardless of it being from a user request or a scheduled process... On Mon, May 16, 2011 at 12:13 PM, Scott Weikert wrote: > > No, no recent updates (that I'm aware of), no increase in traffic. > > When you say "request increase" are you talking about behind-the-scenes > DB requests? Or an increase in usage by people with a corresponding > increase in DB traffic? > > On 5/16/11 10:06 AM, Charlie Stell wrote: > > Have you recently upgraded versions of MS-SQL? And/or recently had a > > significant increase in requests? > > > > In the system I was referring to, it had been running for 3 years without > > this being an issue - then we upgraded to SQL 2005 and had a request > > increase of about 25% - at this point we started having DB hangs about > every > > other day. I don't know if it was the load increase or a change in > execution > > plan handling by SQL... but the db hangs stopped as soon as we > incorporated > > cfqueryparam. > > > > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344544 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Odd issue with DB "pausing"
Have you recently upgraded versions of MS-SQL? And/or recently had a significant increase in requests? In the system I was referring to, it had been running for 3 years without this being an issue - then we upgraded to SQL 2005 and had a request increase of about 25% - at this point we started having DB hangs about every other day. I don't know if it was the load increase or a change in execution plan handling by SQL... but the db hangs stopped as soon as we incorporated cfqueryparam. On Mon, May 16, 2011 at 11:53 AM, Scott Weikert wrote: > > Yep, there's quite a few queries without cfqueryparam - but again, this > is behavior that has popped up of late - this is code that's been around > for years that hasn't had this sort of issue. So I don't know that this > is a problem. > > I'm unsure as to recovery model - we have a hosting guy who maintains > the DB box. > > On 5/16/11 9:50 AM, Charlie Stell wrote: > > Do you have many queries (especially queries ran very often) that do not > use > > cfqueryparam? Those symptoms remind me of system I worked in once where > most > > of the queries were not using queryparam or any other form of binding - > and > > as a result sql's query cache was filling up too often... though I'm sure > > many other things could be the culprit : ) > > > > What recovery model is your db using? > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344539 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Odd issue with DB "pausing"
Do you have many queries (especially queries ran very often) that do not use cfqueryparam? Those symptoms remind me of system I worked in once where most of the queries were not using queryparam or any other form of binding - and as a result sql's query cache was filling up too often... though I'm sure many other things could be the culprit : ) What recovery model is your db using? On Mon, May 16, 2011 at 11:30 AM, Mark A. Kruger wrote: > > Scott, > > It might pay to eliminate networking as a possible issue. For example - are > the ports on the switch trying to "scale up" to 1000/mbs from 100? This > could cause what looks like a temporary "hang". (try statically setting > ports end to end between the server and db). > > Or perhaps you have a mixed environment with XP, Linux, Windows server 00 > or 03 along with 2008r2 in it... the 08 OS defaults to larger packet sizes > on the network and this can cause detrimental effects in mixed networks > when > it kicks in. > > -Mark > > > Mark A. Kruger, MCSE, CFG > (402) 408-3733 ext 105 > www.cfwebtools.com > www.coldfusionmuse.com > www.necfug.com > > > -Original Message- > From: Scott Weikert [mailto:li...@alphageek.cc] > Sent: Monday, May 16, 2011 9:58 AM > To: cf-talk > Subject: Odd issue with DB "pausing" > > > Ok I've got a headscratcher here, would love some input from some other > brains out there. Sometimes it sucks to be the lone gunman developer. :( > > Got CF8 running using MSSQL. Lately, every now and again (too often) the > DB appears to hang, anywhere from a minute or so to several minutes. As > best I can tell (from previous times when it's happened, and I was > remoting our DB box at the time) the CPU isn't spiking during these > hangs. It seems to just be connections from our webservers to the > database that is affected. > > Based on comments from one of my employers working in the system at the > time, and from a few clients, it seems these hangs are triggered by a > specific action in our system - a content-save to a particular table, > that holds the lion's share of client content (webpage content). > > I've tried making changes to said script a couple of times - adjusting > the query, storedproc-ing it up. There seems to be no rhyme or reason to > it - different times it hangs, there's different amounts of content > being saved. One client tends to stuff the most in there - another, not > nearly so much - and both seem to trigger the hang. > > This behavior is pretty recent - just the last few weeks. And I can't > for the life of me puzzle out what's different. We had an issue recently > with an old bug, the "corrupt table" issue, and there was a little bit > of fiddling with the datasource settings before this issue was somewhat > resolved, so I have to wonder if something adjusted during that episode > isn't the cause of this behavior. Nothing in the datasource settings > screams "ME ME ME I'M THE ONE". > > When the hangs occur, triggered by whatever use on our main webserver, > it affects the DB connections on the other servers as well - even a web > environment that is using other databases (dev env) but said other DBs > are on the same DB server. All servers just sit on "waiting on..." in > the browser status 'til the hang passes, then all is well again. > > I'm about at my wit's end trying to puzzle this one out - I sure could > use some nudging in the right direction. > > Thanks in advance - > --Scott > > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344534 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: "Corrput Table" error with queries with cachedwithin
Are you using any *s in your select statement? On Mon, Apr 25, 2011 at 2:05 PM, Scott Weikert wrote: > > I've done some digging on this and everything I'm finding is ancient > (circa 2007). > > Today I started getting a "corrupt table" error with every query that > has a "cachedwithin" set on it on one of my servers. > > On another server, a backup for the main server, with (as best I can > tell) the same CF admin settings and codebase - no problems. > > This is a codebase with a bunch of cachedwithins set up, some that have > been around for years. > > The error pops even with a little one-off test script. > > The CF version shows the same on both server's info page - 8,0,0,176276. > I'm unsure whether the old hotfix that is supposed to handle this issue > was ever applied. (I'm not the server admin in this case) > > I'm furiously running through my code, commenting out the cachedwithins > and posting, but this is a temp thing - need to figure out what's up. > > Thoughts? > > Thanks much in advance - > > --Scott > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343979 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: IIS Question
You'd likely want to defined two iis sites, one for dev and one for prod. For each site, the home directory should be the respective code base for each, and you'd want to add a virtual directory pointing to cfide on each. The differing drives should be no problem. Hope that helps! Charlie On Apr 23, 2011, at 1:15 PM, fun and learning wrote: > > Hi All - > > I have a IIS/coldfusion question. I am working with a client, who has both > production and development stuff on the same machine. He has two drives, C > and E. C drive has development files and E drive has production. The IIS > configuration points to E drive. > > C drive the has the following structure: > > C:/ > - Coldfusion 9 > - Inetpub > - coldfusion files > > E:/ > - Web >- coldfusion files > > But confused if IIS can point to two different drives? How to find out which > drive the IIS point out to.. I hope I am not vague with my question > > Thanks a lot. > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343913 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Odd issue with Query
So this was a weird one... the error is resolved, but I was wondering if anyone could explain what was causing my error. I had a query that was timing out (its one of those nice long monster queries - so I'm not pasting it in its entirety) - but when I copied/pasted out of the cfcatch.sql (from error thrown on timeout) into SQL Query Analyzer - or another template, it completed in under a second. In the query there was a join that looked like this - LEFT JOIN tableA on ColX = ColY = ColZ Changing it to either of the following resolved the issue Solution 1: LEFT JOIN tableA on ColX = ColY = ColZ Solution 2: LEFT JOIN tableA on ColX = ColY LEFT JOIN tableA on ColX = ColZ So I'm assuming there was something going on related to the carriage return following "ColX " - and in addition to the two solutions above, the process of copy-pasting also must have resolved it. If it makes any difference - I'm using SeeFusion for monitoring and so all my datasources use: JDBC URL: jdbc:seefusion:jdbcwrapper:{jdbc:macromedia:sqlserver://server1:1433; databaseName=dbname; SelectMethod=direct; sendStringParametersAsUnicode=false; MaxPooledStatements=1000}; Driver Class: com.seefusion.Driver Anyone have any idea on the root problem? Thanks! charlie ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343607 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQL query question
This might be an issue I've had to deal with before. Do something to change the "fingerprint" (no idea what the correct term would be) of the query - or restart cf. By change the "fingerprint", it could be something as simple ad swapping p.* and pt.* (swapping as in their ordinal position in the select clause). In the past, what has happened is I'll have some query with at least one * in the select statement followed by one or more columns and I add a column to whatever I was selecting * from. If the query stays the same, it uses the same result-set template (again, im making up words - no idea what its really called) It doesn't know to check the underlying structure of the table. But the newly added column gets returned by the db - offsetting all the columns in the rest of the result set. So as crazy as it sounds - just change something in the sql, and give it a try. It doesn't have to actually change anything about what the query does - adding ,getdate() as helloworld will fix it - and then you can undo the change after one successful run. I assume this is something on CF's side - as restarting the CF service also fixes it. On Tue, Feb 1, 2011 at 4:23 PM, Debbie Morris wrote: > > Since everyone should be in a SQL Join state of mind...here's another one. > > I have a weird issue that I haven't been able to narrow down yet. I'm > trying to add a new field to one of my tables to store some additional > information, but once I add the column, my previously working query breaks. > > Here's the query (obviously the person that originally wrote it is in the > 'the fewer characters, the better' camp): > > SELECT p.*, pt.*, pm.Type AS mtype, s.fname AS sfname, s.lname AS slname, > pa.DateActive AS PenAmountDate, pa.MonthlyAmount AS PenAmt, pa.Note AS > PenAmtNote, s.SSN AS sssn, s.DOB AS sdob, spm.Type AS smt > > FROM PensionerMedicalType spm > INNER JOIN PensionerSpouse s ON spm.MedicalID = s.MedicalType > RIGHT OUTER JOIN PensionersActive p > INNER JOIN PensionerType pt ON p.PensionerType = pt.PensionerTID > LEFT OUTER JOIN PensionAmounts pa ON p.PenActID = pa.PenID > LEFT OUTER JOIN PensionerMedicalType pm ON p.MedicalType = pm.MedicalID ON > s.SpouseID = p.Spouse > WHERE (p.PenActID = > AND pa.active = 1) > > > As soon as I add a column named 'lifeInsType' to the PensionersActive (p) > table, I get the following error when the same query runs: > > Error Executing Database Query. > [Macromedia][SQLServer JDBC Driver]Value can not be converted to requested > type. > > What am I overlooking? > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341803 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Diagnosing DB / CF problem
I ran into a problem in the past where queries were getting hung - queries that usually executed all the time without issue (and queries that I could copy and paste into analyzer and run just fine). It turned out to be SQL running out of memory and not being able to compile an execution plan. The root cause was us not using cfqueryparam in our queries - making SQL not use its cache effectively. No idea if your problem is similar - but theres my two cents! On Sun, Nov 28, 2010 at 9:12 PM, Russ Michaels wrote: > > well I can tell you one of the causes for hung requests, it is visitors > closing your page before the request is complete which leaves it in a hung > state as there is no where to send the response back to. Not sure if this > could cause a hung db request though, I wouldn't have thought so as that is > between cf and the db not the client, but I spose it is possible that CF > may > also hang the db request if it know sthe client request has been terminated > prematurely. > > Russ > > On Mon, Nov 29, 2010 at 1:42 AM, Dan Crouch wrote: > > > > > I see similar things like that happen sometimes and SeeFusion won't kill > > them either. In those cases, many times what I can do is run an sp_who on > > the database and look for the offending query, use a dbcc > > inputbuffer(processid) if need be and then kill that process id. Most of > the > > time, that will allow me to kill the hung thread in SeeFusion so that no > > restart is needed. I haven't tried FusionReactor so I am not sure it > works > > the same way, but the problem is very similar to what I have seen, just > > viewed it through SeeFusion instead. I dont know why it happens, > something > > just seems to temporarily have gotten stuck on stupid. > > > > Dan > > > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339565 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Output newest one item from each category
If your using MS SQL 2005 or newer, you could use the row_number() feature- one query using a funciton: with f(catg, nltitle, nldate, nth) as ( Select catg, nltitle, nldate, row_number() over (partition by catg order by catg, nldate desc) as nth from newsletters) select * from f where nth = 1 or create a view: Select catg, nltitle, nldate, row_number() over (partition by catg order by catg, nldate desc) as nth from newsletters select * from view where nth = 1 On Mon, Aug 2, 2010 at 2:12 PM, UXB Internet wrote: > > I was actually thinking about this and like yourself have not found a way > to > do it in one query. I have a crude solution. This assumes you only have > the one table. In either case you need to get a unique list of the > categories then loop over it to create a dynamic query. > > > Select Distinct catg as 'thecategory' > From newsletters > Order by catg > > > > > > Select top 1 nldate, catg, nltitle > From newsletter > Where catg = '#thecategory#' > Order by nldate desc > UNION > > Select top 1 nldate, catg nltitle > From newsletter > Where 0=1 > > Order by {column number} > > > > It may be crude but this approach at least puts all your date into one > query > object. > > > > Dennis Powers > UXB Internet - A Website Design & Hosting Company > P.O. Box 6028 > Wolcott, CT 06716 > 203-879-2844 > http://www.uxbinternet.com > > > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335928 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Comma delimited list
In the long run - your best option is to create third table that will link listsings to multiple feature codes. This is true for many many reasons. If your looking for a quick solution that doesnt involve changing tables - you could use a sql split function (good ex. http://geekswithblogs.net/AngelEyes/archive/2007/04/12/111504.aspx), this will serve as a psuedo table for what i described above. On Fri, May 28, 2010 at 10:37 PM, Bill Hartley wrote: > > I am trying to display feature codes from a comma delimited list inside a > database. Here is my setup: > > Table: Listings has a column called FEATURE_CODES and example of the data > in this column is "B01,E09,E20,G12,J07" > > Then I have another table inside the same database called FeatureCodes the > data inside this table is arranged > FEATURE_CODE FEATURE_DESCRIPTION > B01 Sold As Is > E09 Frame and Stucco > and so on > I need to display the feature description from the FeatureCodes table on > the display page by reading the feature_codes from the listing table > > Any Suggestions?? Please!! > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334103 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cflock and cfloop question
How are #current_ListingID# and #currentow# getting set? My guess would be that within your loop over allimages, these are never being changed, so all these copies are to the same destination file... resulting in only the last file in the source directory being in the destination directory. Also, Im not sure what the second cffile-copy is trying to do, but I dont remember being able to copy a directory with cffile (not sure though) On Wed, May 26, 2010 at 4:23 PM, cfcom wrote: > > Am having some un predictable results with a loop. > My code is supposed to copy upload jpegs from a temp folder to the images > Folder. But only one jpeg is being moved from temp folder to images > folder and the loop isn't grabbing any additional pictures. > When the cflock was removed, it grabbed a second image but no more. > Any help would be most appreciated - thank you again in advance. > > > directory="#house_dir#\temp\#client.userID#" name="allimages" > filter="*.jpg"> > > source="#house_dir#\temp\#client.userID#\#name#" > destination="E:\webs\xyz\images_houses_new\#current_ListingID#_#currentr > ow#.jpg" nameconflict="overwrite"> > > destination="E:\webs\xyz\images_houses\#current_ListingID#_#currentrow#. > jpg" nameconflict="overwrite"> > > > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334023 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Retrive query cell value by key/value pair instead of row number?
When I've had to deal with the same situation previously, I usually created a "lookup" structure based on the column ill use as a handle - mystruct[value I want to ref by]=row index from query (this struct would get populated by looping over whole query) . This index then can be used to get at that row... I do seem to remember however that there's now a cfscript verion of cfquery (I don't remember if it supports query of querys). If that doesn't work, you could write a function that takes a colname, col value and query name, and perform a qoq- assuming the function will have access to the original query... Hope that helps! On 5/26/10, Jon Sala wrote: > > Is it possible to retreive from a query in memory a cell value by a key > value pair, ie other than the usual row number: myquery.columname[i]? > Something like myquery.columname[myquery.keyval:thisquery.Id] > For example, in a block I'm looping through a query, and under > certain conditions I need to retrieve a cell value from a previous query > using a current keyval. > > I guess the real problem is I'm looking for a simple equivalent to > usable inside . Is coldfusion.server.ServiceFactory the only way > out? > > Don't even know if any of this makes sense... I think I need to get some > sleep. > > -- > Jon > > This message and any attached documents are only for the use of the intended > recipient(s), are confidential and may contain privileged information. Any > unauthorized review, use, retransmission, or other disclosure is strictly > prohibited. If you have received this message in error, please notify the > sender immediately, and then delete the original message. Thank you. > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334004 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Strange form field behavior based on its name
Ive had a similar issue when working with a form with a field named "action". On Thu, Apr 1, 2010 at 11:53 AM, Mark A. Kruger wrote: > > Yes I don't know anyone who really used that feature since CF 4.x ... > it > was actually pretty crude. Useful for intranets or whatever - but that's > about it. > > -mark > > > Mark A. Kruger, MCSE, CFG > (402) 408-3733 ext 105 > www.cfwebtools.com > www.coldfusionmuse.com > www.necfug.com > > > -Original Message- > From: Raymond Camden [mailto:rcam...@gmail.com] > Sent: Thursday, April 01, 2010 10:32 AM > To: cf-talk > Subject: Re: Strange form field behavior based on its name > > > Which, thankfully, CF9 finally gave us a way to turn off. > > On Thu, Apr 1, 2010 at 9:51 AM, Dave Watts wrote: > > > >> Are out_start and out_end reserved keywords for form fields? I looked > for > >> documentation found no references. When I output their value after > submission, they're > >> get translated to {t '00:00:00'}. If name them out_xstart and out_xend, > the proper date > >> values show. Just an oddity to share. > > > > Yes, they're used for server-side validation of CFINPUT with range > > attributes, I think. > > > > Dave Watts, CTO, Fig Leaf Software > > http://www.figleaf.com/ > > http://training.figleaf.com/ > > > > Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on > > GSA Schedule, and provides the highest caliber vendor-authorized > > instruction at our training centers, online, or ons > > > > > > > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332531 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Code Review?
Id put my money on it somtimes not finding "/" - so your end is 0, your start is >0, and your getting a negative with mid On Wed, Feb 10, 2010 at 1:23 PM, wrote: > > CGI scoped variables always exist. > > #cgi.I_like_cheese_burgers# should return an empty string-- unless of > course, there is a web server out there that implements that variable. > :) > > ~Brad > > Original Message > Subject: re: Code Review? > From: "Al Musella, DPM" > Date: Wed, February 10, 2010 12:17 pm > To: cf-talk > > > Does it always cause an error or just sometimes? If it is sometimes, > it might be the browser not sending the http_referer.. > try using cfparam on it. > > > > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330560 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: EntityLoadByExample
Man... I was getting excited at the prospect that CF would read the DB structure, see the unique constraints on a table, realizes all the needed properties were defined and try to identify it. Afterall, I just realized the docs say "ColdFusion automatically tries to find if a new record should be inserted or an existing record be updated for the given entity..." But it looks like that means it just checks to see if the object has a value for the pk or not? So in the scenario that I don't already have a variable handle to the object, or know its PK, but I do have the "real world" defining elements, it looks like I'll have to search for it. This is why the mentioned pattern (entitynew -> loadbyexample -> [user returned or create new]) seemed so appetizing - if an existing entity is not found, I already have the un-persisted entity I used for loadbyexample with the bare essentials specified, and just have to use entitySave() on it. I need to look at the debug stack to see which search-mechanism (loadbyexample, load('',...criteria...),hql) is most efficient. Also, it'll be interesting to see if running loadbyexample(a) twice right after each other would cause to DB pulls, or if the second run will use the ORM cache (not because theres any good reason to run them twice - but just to see how the affect). For any process having to do this type of task, doing anymore than 2 DB calls per object is unacceptable - 1 to try to identify and 1 to do the save if it doesn't already exist. thanks for talking through this with me! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329208 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: EntityLoadByExample
Maybe ORM will do more than I originally thought... If I start with two empty tables - domain and email, and get an email from x...@gmail.com(curDomain-gmail.com, curUser-xyz), and the code below runs, two records will be inserted (one in each table). And then later on, I get an email form a...@gmail.com, I can run this exact same code and it will know not to insert a new record into domain? domain = entityNew("domain"); > domain.setName(curDomain) > email = entityNew("email") > email.setDomain(domain); > email.setUser(curUser); > domain.save(); > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329205 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: EntityLoadByExample
> > First I used your example posted, so your eample has that IsNULL error to > begin with. > My example: if(isNUll(EntityLoadByExample(x))) x.save() //If it's not found, save it - this will cause an insert without problem else x = EntityLoadByExample(x) //if it was found, use it I think I see what you were meaning though - I could use: y = EntityLoadByExample(x,true) if(isNull(y)) x.save()// you don't want x to be null here. else x = y -This would avoid asking the system the same thing twice... a little better on processing. > Secondly, I am not sure why you need to retrieve the record again? When you > create an Entity, and then populate it and after saving there is no need to > retrieve it again as everything that is in the DB is populated in the > Entity. > > This is to retrieve the record in subsequent requests where you have neither the PK or the entity already identified. > If you are needing something more, then I suggest looking into optimistic > locking. ColdFusion 9 ORM allows a developer to define 2 more fields for > this exact behaviour. One is called version, and the other is timestamp. > You > can either use one of the other, or both depending on how tight you want to > make this. > > But at the end of the day reloading an Entity that has been saved is only > actually just wasting a DB call, as it will always be the same in this > situation you describe regardless. > > There maybe more to what you are doing, but from what you have mentioned > your work flow process is overkill. > Here's an example - say I wan't to store email addresses as they come into my mailbox - I have the properties set up like (and this is very rough pseudo code): component email property - id fieldtype: id property - user - fieldtype: column property - domain - fieldtype:many-to-one cfc: domain unique constraint on user and fkcolumn component domain property - fieldtype: id property - name fieldtype:column unique constraint on name An email comes in, a scheduled task picks it up, and separates the email-address into curUser and curDomain (both of which are just string) This is the pattern I've been using: domain = entityNew("domain"); domain.setName(curDomain) check = entityLoadByExample(domain,true) if(isNUll(check)) domain.save() else domain = check email = entityNew("email") email.setDomain(domain); email.setUser(curUser); check = entityLoadByExample(email,true) if(isNUll(check)) email.save() else email = check I know I could override the setDomain method for email here - but wouldn't it essentially be have the domain-retrieve-or-create code in it? Or am I missing something all together? Thanks for the feedback! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329203 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: EntityLoadByExample
Thanks for the reply Andrew, I'm not sure I follow where your going with your suggestion of :" x = EntityLoadByExample(x) if(isNUll(x)) x.save()" "x.save()" would throw in error in the case that x is null. In the majority of cases where this check is needed, it's a case of "create if needed, retrieve the instance either way" - so with a try/catch I would still need to retrieve the existing record. However, even in cases where I want to enforce uniqueness, relying only on a try-catch here requires that the unique constraint *actually* exist in the database (which it certainly should - but even if it doesn't, it represents a requirement to have "clean" clean ) and would likely end up leaving that portion of the business logic separate from whats in the application layer (I'm looking into how much of this can be housed solely in the ORM mapping files via uniquekey). But regardless of why EntityLoadByExample is being called, I still would expect it to to only return instances matching all defined properties - both data and object properties - still cannot nail down why it's not behaving this way. -Charlie On Wed, Dec 16, 2009 at 5:39 PM, Andrew Scott wrote: > > Wouldn't throwing it in a try catch block be better than what your doing > here? > > And I would refactor this > > if(isNUll(EntityLoadByExample(x))) > x.save() > else > x = EntityLoadByExample(x) > > as > > x = EntityLoadByExample(x) > if(isNUll(x)) > x.save() > But I think for better understanding to what the code is doing placing it > in > a try catch block, and checking for the exception of a constraint error > would be better and easier to read and understand in 6-12 months time. > > On Thu, Dec 17, 2009 at 6:06 AM, Charlie Stell >wrote: > > > > > I was using EntityLoadByExample today and the behavior wasn't what I was > > expecting. > > > > I expected it would be able to replace the query I always do right before > > insert (the "check" query) - to make sure that the insert wont conflict > > with > > unique constraints. > > > > Ive bee using it like this: > > > > x = entityNew("a") > > > > x.setP1("...") > > x.setP2("...") > > [...n] > > > > if(isNUll(EntityLoadByExample(x))) > > x.save() > > else > > x = EntityLoadByExample(x) > > > > This works great whenever all the properties for "a" are simple > > (fieldtype=column). > > > > But when I tried this with an object that has a many-to-one defined, it > > ignores this difference. > > > > I've dumped x and EntityLoadByExample(x) right next to each other and see > > that the "parent" object in the two dumps are different (different data, > to > > include pks). > > > > Right now Im using > > > > arrayLen(EntityLoad("a",{p1='#p1#',p2='#p2#',p3='#parent#'})) eq 0 in > place > > of isNUll(EntityLoadByExample(x)). > > > > This seems to do the trick. But does anyone know if I know > > if EntityLoadByExample should be able to handle this? > > > > > > > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329201 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
EntityLoadByExample
I was using EntityLoadByExample today and the behavior wasn't what I was expecting. I expected it would be able to replace the query I always do right before insert (the "check" query) - to make sure that the insert wont conflict with unique constraints. Ive bee using it like this: x = entityNew("a") x.setP1("...") x.setP2("...") [...n] if(isNUll(EntityLoadByExample(x))) x.save() else x = EntityLoadByExample(x) This works great whenever all the properties for "a" are simple (fieldtype=column). But when I tried this with an object that has a many-to-one defined, it ignores this difference. I've dumped x and EntityLoadByExample(x) right next to each other and see that the "parent" object in the two dumps are different (different data, to include pks). Right now Im using arrayLen(EntityLoad("a",{p1='#p1#',p2='#p2#',p3='#parent#'})) eq 0 in place of isNUll(EntityLoadByExample(x)). This seems to do the trick. But does anyone know if I know if EntityLoadByExample should be able to handle this? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329191 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Methods not found.
Try the following - Add a function to your cfc that will return variables.X - X being whatever instantiated cfc you cant call the function of. Dump the results of new function - this should help you debug. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328710 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Methods not found.
Id check the following: That your referring to the CFC in the same way you are defining them. (since you say it works when defining with teh functions, I think this is most likely) See if there is any difference made by instantiating them within the init function. The method-access on the other CFCs. That the init function of external CFCs are returning "this". You could also instantiate them into the application scope, as long as they are thread-safe, and then refer to them via the application scope. Hope this helps! >Gah, sorry. The sample is wrong. The psuedo constructor would look >like this and in the cffunction would be called by the variables scope. >variables.errorMsg.addErrorMsg() > >Sorry. was copy/pasting. > > > > variables.errorMsg = createObject("component", >"com.util.errorMessages").init(); > variables.iManager = createObject("component", >"com.util.imageManager").init(); > variables.instGateway = createObject("component", >"FeedsGateway").init(application.global); > > >> On Wed, Nov 25, 2009 at 4:00 PM, Chung Chow wrote: > > Gah, sorry. The sample is wrong. The psuedo constructor would look > like this and in the cffunction would be called by the variables scope. > variables.errorMsg.addErrorMsg() > > Sorry. was copy/pasting. > > > > variables.errorMsg = createObject("component", > "com.util.errorMessages").init(); > variables.iManager = createObject("component", > "com.util.imageManager").init(); >variables.instGateway = createObject("component", > "FeedsGateway").init(application.global); > > > > -Original Message- > > From: Chung Chow [mailto:cyc...@annex.net] > > Sent: Wednesday, November 25, 2009 12:37 PM > > To: cf-talk > > Subject: Methods not found. > > > > > > Hi all, > > > > I'm trying to instantiate an object either in the > > psuedo-contructor or init of my cfc as a variable so I can > > use it within all my method inside that cfc. For some reason > > when I call a method from that object I get a Method not > > found error. I'm not sure if this is the best way of going > > about it so if anyone has a better idea, I'd like to hear > > about it. :) If I istantiate it WITHIN the cffunction, it > > works fine. Any ideas? > > > > Here's a sample of how I'm doing it. When I try to call > > addErrorMsg(); or isSuccess() or any methods in errorMsg or > > Imanage or instGateway it throws a Method not found error. > > > > > > > > var errorMsg = createObject("component", > > "com.util.errorMessages").init(); > > var iManager = createObject("component", > > "com.util.imageManager").init(); > > var instGateway = createObject("component", > > "FeedsGateway").init(application.global); > > > > > >> hint="Constructor"> > > > > > > > > > > > hint="Passed Dataset" /> > > > > > > var feedsBean = ""; > > var newFileName = ""; > > var instGatway = ""; > > var results = structNew(); > > > > feedsBean = createObject("component", > > "feedsBean").init(argumentCollection=dataset); > > > > // Validate the required fields and do an image upload > > if (not len(trim( feedsBean.getFeedName() ))) > > errorMsg.addErrorMsg("...Blah"); > > if (not len(trim( feedsBean.getFeedDescription() ))) > > errorMsg.addErrorMsg("...Blah"); > > if (not len(trim( feedsBean.getAuthorName() ))) > > errorMsg.addErrorMsg("...Blah"); > > > > if (errorMsg.isSuccess()) { > >results.success = instGateway.create(feedsBean, errorMsg); > >results.errors = errorMsg.getErrors(); > > } > > else { > >results.success = 0; > >results.errors = errorMsg.getErrors(); > > } > > > > > > > > > > > > > > > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328707 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Methods not found.
Id check the following: That your referring to the CFC in the same way you are defining them. (since you say it works when defining with teh functions, I think this is most likely) The method-access on the other CFCs. That the init function of external CFCs are returning "this". You could also instantiate them into the application scope, as long as they are thread-safe, and then refer to them via the application scope. Hope this helps! >Gah, sorry. The sample is wrong. The psuedo constructor would look >like this and in the cffunction would be called by the variables scope. >variables.errorMsg.addErrorMsg() > >Sorry. was copy/pasting. > > > >variables.errorMsg = createObject("component", >"com.util.errorMessages").init(); >variables.iManager = createObject("component", >"com.util.imageManager").init(); >variables.instGateway = createObject("component", >"FeedsGateway").init(application.global); > > >> ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328706 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Methods not found.
I believe you would want : variables.errorMsg = createObject("component", "com.util.errorMessages").init(); On Wed, Nov 25, 2009 at 3:36 PM, Chung Chow wrote: > > Hi all, > > I'm trying to instantiate an object either in the psuedo-contructor or > init of my cfc as a variable so I can use it within all my method inside > that cfc. For some reason when I call a method from that object I get a > Method not found error. I'm not sure if this is the best way of going > about it so if anyone has a better idea, I'd like to hear about it. :) > If I istantiate it WITHIN the cffunction, it works fine. Any ideas? > > Here's a sample of how I'm doing it. When I try to call addErrorMsg(); > or isSuccess() or any methods in errorMsg or Imanage or instGateway it > throws a Method not found error. > > > >var errorMsg = createObject("component", > "com.util.errorMessages").init(); >var iManager = createObject("component", > "com.util.imageManager").init(); >var instGateway = createObject("component", > "FeedsGateway").init(application.global); > > > hint="Constructor"> > > > > > hint="Passed Dataset" /> > > > var feedsBean = ""; > var newFileName = ""; > var instGatway = ""; > var results = structNew(); > > feedsBean = createObject("component", > "feedsBean").init(argumentCollection=dataset); > > // Validate the required fields and do an image upload > if (not len(trim( feedsBean.getFeedName() ))) > errorMsg.addErrorMsg("...Blah"); > if (not len(trim( feedsBean.getFeedDescription() ))) > errorMsg.addErrorMsg("...Blah"); > if (not len(trim( feedsBean.getAuthorName() ))) > errorMsg.addErrorMsg("...Blah"); > > if (errorMsg.isSuccess()) { > results.success = instGateway.create(feedsBean, errorMsg); > results.errors = errorMsg.getErrors(); > } > else { > results.success = 0; > results.errors = errorMsg.getErrors(); > } > > > > > > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328699 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
ORM Error - "No discriminator found"
I have the following tables: ---Hierarchy 1: Table per subclass without discriminator--- T1,T2,T3 T1 PK-Identity T2 PK- is FK from T1 T3 PK- is FK from T1 ---END: Hierarchy 1--- ---Hierarchy 2: Table per hierarchy--- T3 T3 PK- is FK from T1 is_simple, type = bit. (not mentioned in Hierarchy 1 - but same table, just trying to only mention the essential fields per context) ---END: Hierarchy 2--- CFCs: c1 table=t1 c2 extends=c1, table=t2, joincolumn=t2.pk c3 extends=c1, table=t3, joincolumn=t3.pk, discriminatorColumn=is_simple c4 extends=c3, table=t3, discriminatorValue=1 I get know errors when C1,C2,C3 exists only. But when I put c4 in my cfc location, and try to re-load the app I get: No discriminator found for C4. Discriminator is needed when 'single-table-per-hierarchy' is used and a class has subclasses. Anyone have any idea where Im going wrong here? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328497 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4