ColdFusion - Long Running Processes - Garbage Collection - structDelete
We used a trick in *ColdFusion 8* that does not seem to work in *ColdFusion 9*. Inside of loops in heavy lifting / long running processes ( scheduled pages ), we would use: structDelete( variables, foo ); This would, in theory, remove the pointer to the location in memory and allow for garbage collection. I have tried moving the processing inside of a cffunction and using a similar trick on the local scope. var objOrder = structDelete( local, foo ); structDelete on variables and local do *not work* in *ColdFusion 9*. Another trick, that is less than ideal, and would require re-writing a significant amount of code is to have 2 pages: The 1st page would contain the loop and use cfhttp to call the 2nd page that actually does the processing. This, in theory, would be a solution if ColdFusion 9 only allows Garbage Collection at the *end of each request*. ( I sure hope this isn't true ) Any Ideas? Maybe cfthread? I know that others out there must have encountered this same problem and come up with a solid solution. Please share your tricks. Best, Ryan ~| 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:349204 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
ColdFusion Builder 2 - File - Open - Path with Forward Slashes from Stack Trace
Does anyone know how to copy one of the paths below and open in ColdFusion Builder 2 In ColdFusion Builder 1 File Open Paste Path Enter would open the file. I am not sure what caused paths in stack traces to change from back slashes to forward slashes. Or, is there a way in the Local ColdFusion Admin to specify back slashes instead of forward slashes in stack traces? http://localhost/CFIDE/administrator/index.cfm Example Paths in Stack Trace: The error occurred in *G:/www/scripts/globalFunctions.cfm*: line 449 Called from *G:/www/com/server/Example.cfc*: line 5268 Thanks, Ryan Running ColdFusion 9 Developer Edition - 64 bit - Windo ~| 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:348530 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion Builder 2 - File - Open - Path with Forward Slashes from Stack Trace
Jedi,
Thanks for the quick reply. I don't quite have the back slash change
working yet.
I also wanted to say thanks for the free CFWACK book at CFUNITED a few
years ago. I was the one who won your blog tat contest.
*I think you are referring to this file*:
F:\ColdFusion9\wwwroot\WEB-INF\exception\java\lang\Exception.cfm
cfimport taglib=../.. prefix=ex
ex:detail error=#error#
/ex:detail
Editing this file doesn't seem to change anything.
Any ideas?
*I also looked at this file*:
F:\ColdFusion9\wwwroot\WEB-INF\exception\errorcontext.cfm
!---
errorcontext.cfm reads the file specified by a TAGCONTEXT-type struct
and returns an array of structures which contain the text of the failing
line,and lines near it, along with their line numbers.
@param errorLocation - the TAGCONTEXT entry for the failed template/line.
@param showcontext- number of additional lines before/after failure
displayed.
@param resultVariable - the name of the caller's var where the resulting
---
cfparam name=attributes.errorLocation
cfparam name=attributes.showcontext
cfparam name=attributes.resultVariable
cfif thistag.executionmode is start
!--- localization ---
cfset locale = createObject(java,
java.util.Locale).getDefault().getLanguage()
cfset l10n_caller = detail
cftry
cfif FileExists(exception_#locale#.xml)
cfinclude template=exception_#locale#.xml
cfelse
cfinclude template=exception_en.xml
/cfif
cfcatch
cfinclude template=exception_en.xml
/cfcatch
/cftry
cfset result = ArrayNew(1)
cfscript
try
{
firstLine = attributes.errorLocation.line - attributes.showcontext;
lastLine = attributes.errorLocation.line + attributes.showcontext;
//create an instance of VFSFileFactory to fetch the intputstream
vfsfilefactory = createObject(java, coldfusion.vfs.VFSFileFactory);
//get the input stream for the file
inputStream =
vfsfilefactory.getInputStream(attributes.errorLocation.Template);
// Wrap a InputStreamReader in a LineNumberReader to read the CFML
template as text.
inputStreamReaderClass = createObject(java,
java.io.InputStreamReader);
inputStreamReader = inputStreamReaderClass.init(inputStream);
lineReaderClass = createObject(java, java.io.LineNumberReader );
lineReader = lineReaderClass.init(inputStreamReader);
currentLine = lineReader.readLine();
while ( isDefined(currentLine) and lineReader.getLineNumber() lte
lastLine )
{
if ( lineReader.getLineNumber() gte firstLine )
{
lineInfoStruct= structNew();
lineInfoStruct.line = currentLine;
lineInfoStruct.lineNumber = lineReader.getLineNumber();
ArrayAppend(result, lineInfoStruct);
}
currentLine = lineReader.readLine();
}
} catch ( Any ex) {
lineInfoStruct = structNew();
lineInfoStruct.line = s_unable;
lineInfoStruct.lineNumber = -1;
lineInfoStruct.diagnostic = ex;
ArrayAppend(result, lineInfoStruct);
}
finally
{
if(isDefined(lineReader))
{
lineReader.close();
}
}
/cfscript
cfset setVariable(caller.#attributes.resultVariable#, result )
/cfif
On Wed, Nov 9, 2011 at 9:42 AM, Raymond Camden raymondcam...@gmail.comwrote:
The exception you see when an error occurs is actually driven by a CFM
file, exception.cfm. In theory you can just edit that yourself.
On Wed, Nov 9, 2011 at 9:04 AM, Ryan Duckworth
ryanduckworth...@gmail.com wrote:
Does anyone know how to copy one of the paths below and open in
ColdFusion
Builder 2
In ColdFusion Builder 1
File Open Paste Path Enter
would open
the
file.
I am not sure what caused paths in stack traces to change from back
slashes
to forward slashes.
Or, is there a way in the Local ColdFusion Admin to specify back slashes
instead of forward slashes in stack traces?
http://localhost/CFIDE/administrator/index.cfm
Example Paths in Stack Trace:
The error occurred in *G:/www/scripts/globalFunctions.cfm*: line 449
Called from *G:/www/com/server/Example.cfc*: line 5268
Thanks,
Ryan
--
===
Raymond Camden, Adobe Developer Evangelist
Email : raymondcam...@gmail.com
Blog : www.coldfusionjedi.com
Twitter: cfjed
~|
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:348538
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion Builder 2 - File - Open - Path with Forward Slashes from Stack Trace
You are the man. Thanks!
I think we have the backward slashes because we are using virtual drives.
If anyone else wants the solution:
Edit this file: F:\ColdFusion9\wwwroot\WEB-INF\exception\detail.cfm
line 142:
#s_error_in# b#encodeForError(vcfml[1])#/bbr
#s_error_in# b#replaceNoCase( encodeForError(vcfml[1] ), ##x2f;, \,
all )#/bbr/
line 146:
b#s_called_from#/b #encodeForError(vcfml[i])#br
b#s_called_from#/b #replaceNoCase( encodeForError( vcfml[i] ),
##x2f;, \, all )#br/
line 294:
#encodeForError(vjava[i])#
#replaceNoCase( encodeForError( vjava[i] ), ##x2f;, \, all )#
Best,
Ryan Duckworth
Software Project Manager
Uhlig LLC
8455 Lenexa Drive
Overland Park, KS 66214
rduckwo...@uhlig.com
www.uhlig.com
On Wed, Nov 9, 2011 at 11:15 AM, Raymond Camden raymondcam...@gmail.comwrote:
Btw -when I get an error on my WIn7 box, the slashes are right:
Attribute validation error for tag CFSAVECONTENT.
It does not allow the attribute(s) ARIABLE. The valid attribute(s) are
VARIABLE.
The error occurred in C:\websites\webroot\test.cfm: line 2
1 :
2 : cfsavecontent ariable=f
3 : {D:[{D: screen that }]}
4 : /cfsavecontent
On Wed, Nov 9, 2011 at 9:04 AM, Ryan Duckworth
ryanduckworth...@gmail.com wrote:
Does anyone know how to copy one of the paths below and open in
ColdFusion
Builder 2
In ColdFusion Builder 1
File Open Paste Path Enter
would open
the
file.
I am not sure what caused paths in stack traces to change from back
slashes
to forward slashes.
Or, is there a way in the Local ColdFusion Admin to specify back slashes
instead of forward slashes in stack traces?
http://localhost/CFIDE/administrator/index.cfm
Example Paths in Stack Trace:
The error occurred in *G:/www/scripts/globalFunctions.cfm*: line 449
Called from *G:/www/com/server/Example.cfc*: line 5268
Thanks,
Ryan
Running ColdFusion 9 Developer Edition - 64 bit - Windo
~|
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:348552
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SAML Response to Google Apps
This is the Enterprise edition of version 8. When testing the response, I'm taking the actual header values that go to Google (using LiveHTTPHeaders in Firefox). That is able to be decoded from the Base 64 encoding using that SimpleSAML debug page. Details on the Google Dev forum link if you want to see. ~ Ryan Are you running in the Dev version of CF? if so, it can add some HTML to the output stream that will corrupt any XML output. Are you sure the the code Google is seeing isn't getting altered? -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:346647 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
SAML Response to Google Apps
Has anyone successfully created a ColdFusion project that sends a SAML Response to Google Apps? I have nearly completed a project that decodes the SAML Request from Google, authenticates with the local directory, and submits a SAML Response back. However, Google Apps states that it could not parse the response. Using the SimpleSAML debug Web page [1], I am able to successfully decode my response. Since that works, I suspected the certificate signing. As per directions from other sources [2-4] I use the Apache Santuario Java libraries. From what I can tell, it seems to be working fine. I've even signed the response several ways, such as just the Response, just the Assertion, and both. I've been discussing this on the Google Dev forums [5] but the official Googlers don't seem to have access to the logs that say exactly why it can't parse the Response. Wish Google would say what specifically it doesn't like... Thanks for any help/feedback! ~ Ryan [1] https://rnd.feide.no/simplesaml/module.php/saml2debug/debug.php [2] http://dragonsaber.blogspot.com/2009/09/coldfusion-saml-part-1.html [3] http://dragonsaber.blogspot.com/2010/01/coldfusion-saml-part-2.html [4] http://dragonsaber.blogspot.com/2010/04/coldfusion-saml-part-3.html [5] http://code.google.com/googleapps/domain/sso/saml_sso_support.html?place =topic%2Fgoogle-apps-saml-sso%2Fixx23lPnlKY%2Fdiscussion ~| 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:346619 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Can you bind to a subquery result?
Ok, I could use some help on this as I can't seem to make it work and cannot find any topics on this either. I have a cfquery that I am using to populate a cfgrid. I also have 3 cfinputs that I am using to bind and filter that cfgrid. The problem is, that 2 of the fields I am trying to filter through are gotten using a subquery to return names. But when I try to filter via text, it pulls no values, and when I type in the numeric id value instead it is filtering. So is there any way to bind results based on the subquery result? Thanks in advance ~| 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:345111 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Trapping entityDelete() errors
Working with ColdFusion 9 ORM, is there a way to trap entityDelete() errors
when there's a constraint violation. I have my delete setup like so:
try {
entityDelete(local.objSongCategory);
// report success
} catch (Any e) {
transaction action=rollback;
// report fail
}
However, if I attempt to delete a record in use (a song assigned to category
being deleted), CF throws an error:
coldfusion.orm.hibernate.HibernateSessionException: Cannot delete or update a
parent row: a foreign key constraint fails (`databasename`.`songs`, CONSTRAINT
`songs_ibfk_3` FOREIGN KEY (`SongCategoryID`) REFERENCES `songcategories`
(`SongCategoryID`)). (Database)
I'm a little puzzled why the error isn't being caught since the delete is
occurring inside a try/catch. Any thoughts?
~|
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:340211
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Weird problem with CFPDF addheader/image
Ok, so I am hoping someone out there has some kind of insight on this issue as I cannot find anything on this. We are having an issue with CF9 with images not printing. We do a ton of pdf generation each day, and right now have a clients code updated to cf9. Its very simple code, and below is what is used: cfpdf action=addheader source=#ID# destination=#path#/#doc_id#.pdf pages=1 overwrite=yes image=images/thelogo.jpg align=right topmargin=1.25 The problem is that it is in fact inserting the header image into the pdf file, but when you randomly print some of these pdfs the image will not print. This doesn't happen to ever one, but maybe 50%. I cannot find any rhyme or reason to this, nor can I find anything over the internetz. If anyone has seen this issue or has any insight, it would be GREATLY appreciate! Thanks, Ryan ~| 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:338767 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Problems with SpreadSheetFormat Columns??
Hi all,
I could use a little help with this one as I can't seem to find a solution for
this anywhere, and I have definitely been wasting too much of my time on
something so small! Anyways, I am wondering if there are any known issues with
the SpreadsheetFormatColumns function in regards to formatting datetime fields
from sql? I have searched and searched, and tried every variation I could think
of with the following code, but cannot get it to format the dates. I would
definitely appreciate any feedback on this one, or if anyone knows of any
issues with this.
Here is one of my code versions:
cfset sObj=SpreadsheetNew()
cfset SpreadsheetAddRow(sObj, Client,Leave Owner,Leave Number,Request
Date,Leave Reason,Elig Confirmed Date,Packet Mailed Date)
cfset SpreadsheetAddRows(sObj, drilldowns)cfset
SpreadsheetFormatColumns(sObj, {dataformat=mm/dd/}, 4,6-7)cfset
SpreadsheetFormatRow(sObj, {bold=TRUE, alignment=center}, 1)
cfspreadsheet action=write name=sObj
filename=filename#dateformat(now(), 'mmdd')#.xls overwrite=true
I could very easily write this differently, or convert the fields in sql, but
since I started this to try out some of the CFSpreadsheet stuff, I wanted to
see if there was a solution while still using it this way.
Th
~|
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:334724
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfchart - cfchartseries - cfchartdata
I would like to change my cfchart to only show the label in my cfchartseries for the first and last data point. I can turn on/off the labels for the entire cfchartseries using on: datalabelstyle=value off: datalabelstyle=none How can I turn it on for the first and last data point, but off for all those in the middle? The reason that I want to do this is I have several cfchartseries that overlap each other and the labels are not readable. I believe that cfchartdata only has 2 attributes: item and value. It would be nice if cfchartdata had a 3rd attribute displayLabel = true or false. Anyone know how to do 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:330152 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: New CF8 vulnerability
A hotfix was just released for this: http://www.adobe.com/support/security/bulletins/apsb09-09.html -Ryan ~| 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:324352 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Restricted access to non cf files using cf
Store them outside of the webroot and use cfcontent to serve them to the browse when necessary. -Ryan Anastassios Hadjicrystallis wrote: I have a question that its answer may be interesting and usefull for many CF developers. Here it is. I have a site, and I have a folder where access is restricted and I have a login page asking for user name and password. As usually I chech these access data in my database and I give or give not access to the content of this folder. Nothing special until now. Let's suppose The root folder of my site isC:\MySite The restricted access folder isC:\MySite\MembersFolder In the root folder I have the login page C:\MySite\login.cfm In the restricted access folder and its subfolders I have various CF pages e.g. -- C:\MySite\MembersFolder\page1.cfm , -- C:\MySite\MembersFolder\folder2\page2.cfm etc Whenever someone logs in successfully I keep a session variable with his name, userid etc blah blah. So whenever someone tries to access a restricted access page e.g C:\MySite\MembersFolder\page1.cfm I check if there is or there is not the session variable of his access. If the session variable exists I give access, otherwise I send him to the login page. Again nothing special. Just typical proccess. My question is. All the above can restrict access to any CF page in the folder C:\MySite\MembersFolder BUT what about any other content in this folder e.g PDF, jpg, doc files etc ? Because someone not logged in can just write in his browser: http://www.MySite.com/MembersFolder/MyBook.pdf and can get the PDF file without loggin!!! Any idea how can I restrict access to any kind of content (htm, cfm, pdf, jpg, doc xls etc) using coldfusion ? (Well I know I can store these kind of files in binary fields of the database instead of storing them as files, but I don't think it's realistic. These files pdf, doc, tiff, xls can be many Mb and it's not realistic to read these huge files from the database in middle or high traffic site.) So any other idea? Thanks in advance for your response. ~| 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:324239 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Coldfusion Sport Software
With Railo gaining more momentum now, I think we'll see some cheaper ColdFusion hosting options. And you get your own administrator! Alurium has Railo hosting starting at $6.75/month (200MB storage, 5GB bandwidth). And a 60 day free trial. http://alurium.com -Ryan Paul Alkema wrote: I love ColdFusion, but when people talk shared hosting there's no comparative to between CF shared hosting and php shared hosting. Here is Mike Kear's Offer of CF Hosting According to his website. CF Shared Hosting afpwebworks.com - Advertised Hosting Plan Monthly price - $15/M Disk Space - 20mb Bandwidth - 500mb/mo MySQL Databases - None PHP Shared Hosting alkemadesigns.com/hosting - Advertised Hosting Plan Monthly price - $4.95/M Disk Space - UNLIMITED Bandwidth - UNLIMITED MySQL Databases - UNLIMITED I'm not insulting Mike Kear's offer.. at all, I actually think this is low for coldfusion hosting. The matter of the fact is, is that good CF shared hosting costs more than good PHP hosting. If I can get my clients to get a dedicated CF server I always encourage them to do so, but if they can't afford it there is no comparison between PHP shared hosting and CF shared hosting. Also, I think another downside to CF shared hosting is the lack of control, between Cpanel, php.ini file and your .htaccess file you have so much control of your hosting, but with CF hosting in order to get things changed many times you have to call the hosting company ask them to change IIS setting etc... My recommendation is, if you're looking for shared hosting, use a PHP server and learn PHP. If your company can afford it, go with a dedicated CF server because CF is so much easier to write, easier to read and development time is so much faster. :) Paul Alkema http://www.AlkemaDesigns.com ~| 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:324108 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ColdFusion and RSS
XMLFormat() does NOT clean up all invalid XML characters, it still leaves in a lot of bar chars that will mess up XML readers. I think there is a function on cflib that does a better job, I wrote one too a while back: http://www.stillnetstudios.com/2008/09/14/cleaning-up-non-ascii-characters/ -Ryan Dominic Watson wrote: You may like to try: description![CDATA[#post#]]/description However, the xmlformat will definately be cleaning up any invalid xml characters; are you using it in the title, etc? Perhaps it could be an encoding issue. Dominic 2009/6/26 bill turner bill.tur...@selectcomfort.com: description#xmlFormat(post)#/description ~| 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:323976 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: captcha
Phillip I haven't followed this whole thread, but can you really not set mappings or do you just not have access to the Administrator? In CF8, Railo and OpenBD you can set mappings in your Application.cfc file. -Ryan Phillip Vector wrote: Ah.. That would explain it. My hosting plan can't set mapping. Though, I wouldn't think it would be a mapping issue, but *shrugs* On Thu, Jun 18, 2009 at 1:49 PM, Dave Wattsdwa...@figleaf.com wrote: Can you tell me what file sets this? It's controlled by mappings in the CF Administrator. 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! ~| 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:323675 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
URL Rewriting
I saw the topic of url rewriting come up here recently which peeked my interest so here I go with my first newb issue: Installed IIRF on Win 2003 IIS 6 and have run a test to confirm it is behaving nicely. I have a site with all pages physically located inside a subfolder (ie /pages) directly off the root. I was asked to remove the pages folder from the location that shows in the web browser (ie change http://www.mydomain.com/pages/events/ to http://www.mydomain.com/events). I just want to hide the pages folder from view. Is this possible? -- Ryan LeTulle ~| 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:323585 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: URL Rewriting
Thanks Dave. Unfortunately, everything is not in that folder. I toyed with Virtual Directories earlier. I am thinking of creating multiple virtual directories like: /about , /about/staff ... , /visitors , /visitors/attractions Does this make sense to you? The client just doesn't want the pages folder to ever show in the path. Was told by SEO experts this is bad for Google and looks ugly. Maybe it is bad but the pages they are referencing are their highest ranking pages in Google so go figure. -- Ryan LeTulle On Wed, Jun 17, 2009 at 2:32 PM, Dave Watts dwa...@figleaf.com wrote: I saw the topic of url rewriting come up here recently which peeked my interest so here I go with my first newb issue: Installed IIRF on Win 2003 IIS 6 and have run a test to confirm it is behaving nicely. I have a site with all pages physically located inside a subfolder (ie /pages) directly off the root. I was asked to remove the pages folder from the location that shows in the web browser (ie change http://www.mydomain.com/pages/events/ to http://www.mydomain.com/events). I just want to hide the pages folder from view. Is this possible? If all your pages are in fact in that one folder, you can just configure IIS to use that as the root folder. If you then want to serve other files, like images, from a parallel folder, just create a virtual directory pointing to that folder. There's no need to do URL rewriting for this. 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! ~| 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:323602 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: URL Rewriting
This is what I'm gonna do: 1. Create Virtual Directories in IIS: (ie /public/about will be /about) 2. Incoming links such as http://www.mydomain.com/public/about will be redirected to http://www.mydomain.com/about as such with IIRF RedirectRule ^/public/about /about [R=301] Am I missing anything that anyone can see? Eventually Google should start pointing to the virtual directories and I won't lose anything now or then. -- Ryan LeTulle On Wed, Jun 17, 2009 at 2:48 PM, Dave Watts dwa...@figleaf.com wrote: Unfortunately, everything is not in that folder. I toyed with Virtual Directories earlier. I am thinking of creating multiple virtual directories like: /about , /about/staff ... , /visitors , /visitors/attractions Does this make sense to you? Sure, assuming that these folders are parallel to the pages folder. The client just doesn't want the pages folder to ever show in the path. Was told by SEO experts this is bad for Google and looks ugly. Maybe it is bad but the pages they are referencing are their highest ranking pages in Google so go figure. Well, I wouldn't want /pages in the path either, since it doesn't add any meaningful value. Here's how I like my URLs: http://www.w3.org/Provider/Style/URI That said, if their current pages rank highly with /pages in the URL, they will be throwing that away (at least temporarily) if they discard those URLs in favor of, well, anything else. And as far as SEO goes, it doesn't make any difference. But nowadays, anybody can claim to be an SEO expert; it doesn't count for much. Here's a decent SEO presentation by my coworker, Steve Drucker (who isn't an SEO expert, but doesn't claim to be - and who has as good or better a working knowledge of SEO as many of these so-called experts): http://figleaf.mmalliance.acrobat.com/seo/ 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 inf ~| 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:323606 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: email and encrypt
haha I love you guys. -- Ryan LeTulle On Tue, Jun 16, 2009 at 3:11 PM, Barney Boisvert bboisv...@gmail.comwrote: The MD5 gamut is 2^128 or 16^32 or 340,282,366,920,938,463,463,374,607,431,768,211,456. Your database will run out of integer keys long before it's an issue with almost complete certainty. But yes, it is a potential problem. Easy to make fail-fast with a constraint on your DB though. cheers, barneyb On Tue, Jun 16, 2009 at 1:03 PM, Alan Rotheralan.rot...@gmail.com wrote: One catch with a hash, it is possible, however highly unlikely, that two different email addresses will produce the same hash. Just be aware of it. =] -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org ~| 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:323557 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: google style paging navigation
NP NathanI was impressed when I was turned on to it last week. Nice work. -- Ryan LeTulle On Mon, Jun 15, 2009 at 11:03 AM, Nathan Strutz str...@gmail.com wrote: Thanks, Ryan. I would have replied earlier if I had seen it. Mike P, check out my Pagination.cfc project: http://paginationcfc.riaforge.org/ I have an example of how to emulate the google paging here: http://www.dopefly.com/projects/pagination/examples/index.cfm?style=google The examples app, including images and css, are included in the download from riaforge. nathan strutz [Blog and Family @ http://www.dopefly.com/] [AZCFUG Manager @ http://www.azcfug.org/] [Twitter @nathanstrutz] On Sun, Jun 14, 2009 at 3:34 PM, Ryan Letulle bayous...@gmail.com wrote: Nathan Strutz at http://www.dopefly.com/projects/pagination/examples/ -- Ryan LeTulle On Sun, Jun 14, 2009 at 5:25 PM, mike pop mikepoplaw...@gmail.com wrote: does anybody have snippets for creating google style like paging navigation. First Rec - Previous Rec 31 32 33 34 35 36 37 38 39 40 Next Rec - Last Rec The current page should not display a link The Next Rec will increment the page link by one (e.g. if the user in this case clicks Next Rec, the links displayed will be 32..41) google is a bit different but I want to display the page numbers sequentially and only 10 items or whatever cfparam is set to. I've found the most basic tutorials on navigation but nothing like google style navigation. I can't find code snippets from a previous project. Please help me Thank you for your help ~| 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:323519 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: google style paging navigation
Nathan Strutz at http://www.dopefly.com/projects/pagination/examples/ -- Ryan LeTulle On Sun, Jun 14, 2009 at 5:25 PM, mike pop mikepoplaw...@gmail.com wrote: does anybody have snippets for creating google style like paging navigation. First Rec - Previous Rec 31 32 33 34 35 36 37 38 39 40 Next Rec - Last Rec The current page should not display a link The Next Rec will increment the page link by one (e.g. if the user in this case clicks Next Rec, the links displayed will be 32..41) google is a bit different but I want to display the page numbers sequentially and only 10 items or whatever cfparam is set to. I've found the most basic tutorials on navigation but nothing like google style navigation. I can't find code snippets from a previous project. Please help me Thank you for your help ~| 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:323495 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Product ID - enterprise level application
Are you guys saying that I should force my client to require their client to create a user account? Or am I missing something here in the symantics. Because I don't see another solution. BTW I am not talking about guarding Fort Knox here. -- Ryan LeTulle On Fri, Jun 12, 2009 at 4:21 AM, Tom Chiverton tom.chiver...@halliwells.com wrote: On Friday 12 Jun 2009, Ryan Letulle wrote: An example would be for an emailed order confirmation with a link back to their order details. ... By using an integer it would be extremely easy for someone to view other order details but not so with a uuid. But surely your getOrderFromOrderId() method checks that the id number it is given belongs to the currently logged in user... oh... ummm ?:-) -- Helping to paradigmatically seize B2B professional dot-com convergence as part of the IT team of the year, '09 and '08 Tom Chiverton Developer Tel: +44 0161 618 5032 Fax: +44 0161 618 5099 tom.chiver...@halliwells.com 3 Hardman Square, Manchester, M3 3EB www.Halliwells.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office together with a list of those non members who are referred to as partners. We use the word partner to refer to a member of the LLP, or an employee or consultant with equivalent standing and qualifications. Regulated by the Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.Halliwells.com. ~| 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:323443 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Product ID - enterprise level application
Doesn't require a UUID as the PK, just something unique and unpredictable for that piece of functionality, which could be derived/hashed from any static column(s). Peter, Are you saying that a uuid is inherently insecure? I thought part of the uuid was created randomly and for the purposes where I was using it felt comfortable. Maybe that sense was false. Are you saying to hash something else like the person's name and use that and it would be more secure? or Are you saying don't do anything like this at all? -- Ryan LeTulle On Fri, Jun 12, 2009 at 6:33 AM, Ryan Letulle bayous...@gmail.com wrote: Are you guys saying that I should force my client to require their client to create a user account? Or am I missing something here in the symantics. Because I don't see another solution. BTW I am not talking about guarding Fort Knox here. -- Ryan LeTulle On Fri, Jun 12, 2009 at 4:21 AM, Tom Chiverton tom.chiver...@halliwells.com wrote: On Friday 12 Jun 2009, Ryan Letulle wrote: An example would be for an emailed order confirmation with a link back to their order details. ... By using an integer it would be extremely easy for someone to view other order details but not so with a uuid. But surely your getOrderFromOrderId() method checks that the id number it is given belongs to the currently logged in user... oh... ummm ?:-) -- Helping to paradigmatically seize B2B professional dot-com convergence as part of the IT team of the year, '09 and '08 Tom Chiverton Developer Tel: +44 0161 618 5032 Fax: +44 0161 618 5099 tom.chiver...@halliwells.com 3 Hardman Square, Manchester, M3 3EB www.Halliwells.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office together with a list of those non members who are referred to as partners. We use the word partner to refer to a member of the LLP, or an employee or consultant with equivalent standing and qualifications. Regulated by the Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.Halliwells.com. ~| 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:323444 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Product ID - enterprise level application
OK, I guess. :) -- Ryan LeTulle On Fri, Jun 12, 2009 at 7:01 AM, Jochem van Dieten joch...@gmail.comwrote: On Fri, Jun 12, 2009 at 1:38 PM, Ryan Letulle wrote: Are you saying that a uuid is inherently insecure? Depends on how you use them. I thought part of the uuid was created randomly and for the purposes where I was using it felt comfortable. Some UUIDs are random, some are completely predictable. The ones created with the CreateUUID() function are predictable. Maybe that sense was false. Are you saying to hash something else like the person's name and use that and it would be more secure? A primary key is just a primary key, it does not have any security semantics. Even when people know a primary key of a record your code should check whether the user is allowed to see that record. Every user has a username and password to authenticate the user, and you have some sort of permissions system to check whether the user has permissions to access a record. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| 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:323446 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Product ID - enterprise level application
Thank you all. A long habit of not thinking a thing wrong gives it a superficial appearance of being right. Thomas Painehttp://www.brainyquote.com/quotes/quotes/t/thomaspain161749.html * *-- Ryan LeTulle On Fri, Jun 12, 2009 at 7:12 AM, Peter Boughton bought...@gmail.com wrote: Are you saying that a uuid is inherently insecure? UUIDs are guaranteed to be unique, but not (afaik) to be unpredictable. I don't know *how* predictable they might be, but for any secure string I wouldn't want to rely entirely on something with potentially knowable/guessable sources - I would want something derived from both secret information and data that is related to the original record. So, I would most likely use some form of double salted hash that incorporates data that relates to that person - but not necessarily name, since that might be changable. Make sense? ~| 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:323448 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Product ID - enterprise level application
One note I don't use the uuid as the primary key in these instances. I know that's how this post started. :) -- Ryan LeTulle On Fri, Jun 12, 2009 at 9:07 AM, Mary Jo Sminkey mary...@cfwebstore.comwrote: Are you guys saying that I should force my client to require their client to create a user account? Or am I missing something here in the symantics. Because I don't see another solution. If they want to view order history, yes, that's the easiest way to ensure security for viewing the information. If you want to allow users to check out without creating an account, then they either cannot view order information online, or you need to create some kind of random access code for them to use to view the order. Or you can use something else to validate the user, such as entering their Order ID and the email associated with the order. There's a variety of ways you can do it, that don't have anything to do with how you assign the primary key. --- Mary Jo ~| 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:323452 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Proper returntype of a cfc
Is it a common/best practice to return multiple variables from a cfc? Like if I wanted perform some processing in a cfc and return several variables. For the most part I have always returned either a query or 1 variable. If so, what would be the best return type for this? Does that make sense? I'd like to do this in the most popular way. I feel like I can really consolidate some code on a certain project. -- Ryan LeTulle ~| 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:323466 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Proper returntype of a cfc
That's what I thought but I've been wrong before. :) -- Ryan LeTulle On Fri, Jun 12, 2009 at 7:30 PM, Rob Parkhill robert.parkh...@gmail.comwrote: You would need to return it as a struct. then just reference any parts of the struct that contain the data you want. I have one cfc that returns a struct of arrays... Rob On Fri, Jun 12, 2009 at 8:25 PM, Ryan Letulle bayous...@gmail.com wrote: Is it a common/best practice to return multiple variables from a cfc? Like if I wanted perform some processing in a cfc and return several variables. For the most part I have always returned either a query or 1 variable. If so, what would be the best return type for this? Does that make sense? I'd like to do this in the most popular way. I feel like I can really consolidate some code on a certain project. -- Ryan LeTulle ~| 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:323469 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Proper returntype of a cfc
Understand, I guess the proper terminology should be multiple values ? -- Ryan LeTulle On Fri, Jun 12, 2009 at 7:35 PM, Dave Watts dwa...@figleaf.com wrote: Is it a common/best practice to return multiple variables from a cfc? Like if I wanted perform some processing in a cfc and return several variables. For the most part I have always returned either a query or 1 variable. If so, what would be the best return type for this? Does that make sense? I'd like to do this in the most popular way. I feel like I can really consolidate some code on a certain project. You can't return multiple variables from a function call. You can only return one variable. Of course, that variable can contain other variables, multiple values, recordsets, etc. 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 informat ~| 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:323471 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Proper returntype of a cfc
Only odd to you because you are all knowing. For the most part I have always returned either a query or 1 variable. I have never done this before in a cfc. -- Ryan LeTulle On Fri, Jun 12, 2009 at 7:43 PM, Dave Watts dwa...@figleaf.com wrote: Understand, I guess the proper terminology should be multiple values ? Well then, it seems an odd question to ask. Return whatever data type reflects the best possible output for your function. If that's a query, return a query. If it's an array, return an array. If it's a structure, return a structure. There's nothing wrong with returning any of these, if that's what you want to get back. 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! ~| 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:323473 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Proper returntype of a cfc
BTW I always appreciate the guidance. -- Ryan LeTulle On Fri, Jun 12, 2009 at 7:45 PM, Ryan Letulle bayous...@gmail.com wrote: Only odd to you because you are all knowing. For the most part I have always returned either a query or 1 variable. I have never done this before in a cfc. -- Ryan LeTulle On Fri, Jun 12, 2009 at 7:43 PM, Dave Watts dwa...@figleaf.com wrote: Understand, I guess the proper terminology should be multiple values ? Well then, it seems an odd question to ask. Return whatever data type reflects the best possible output for your function. If that's a query, return a query. If it's an array, return an array. If it's a structure, return a structure. There's nothing wrong with returning any of these, if that's what you want to get back. 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! ~| 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:323474 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Proper returntype of a cfc
@dave I started using cfcs after reading a Ben Forta article a couple of years ago where he said at least use cfcs for querys and you should never output to the screen from cfcs. For the most part that is what I have used them for. Unfortunately, I never really advanced further than that with cfcs. Otherwise, I get it done without 'em. I want to do better. :) -- Ryan LeTulle On Fri, Jun 12, 2009 at 7:57 PM, Dave Watts dwa...@figleaf.com wrote: Only odd to you because you are all knowing. I wish! But calling functions in CF is basically the same as calling functions in other languages. You provide a list of inputs, and get a single return value. 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! ~| 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:323476 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Product ID - enterprise level application
The tradeoff will be between a user not being able to play around with the querystring (i.e change id=1 to id=2) and performance. How much performance I can't say. A million a day I would think you would start to see it. I personally haven't hit the performance issue with uuid but I also haven't created nearly 1 million a day. -- Ryan LeTulle On Thu, Jun 11, 2009 at 7:03 AM, Fawzi Amadu abd...@gmail.com wrote: I am wondering the best way to create an ID for an online advertising site that I anticipate could have about a million products uploaded a day. I had considered using create UUID I read the following from Christian Cantrell If you want the convenience of generating your own primary key without the performance degradation of selecting from a table with a 35 character primary key, you can let your database create a normal auto-incrementing ID field as you normally would to use as your primary key, and insert a UUID at the same time. Then, just select the ID of the row that has the UUID that you just generated, and you are guaranteed (statistically) to have selected the right ID without having to use vendor specific SQL Now I am wondering if I should add the auto-incrementing ID or just use and auto- generated number concatenated with the a string representing the day, month and year of the transaction. I'll appreciate any insight on 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:323388 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Product ID - enterprise level application
Nothing to do with security measures for me. Many times I simply don't want anyone accessing another record in the database. I am sure that you can imagine that type of scenario, in case not An example would be for an emailed order confirmation with a link back to their order details.(in this case the client does not want someone to fill out user details and create an account for their own reasons) By using an integer it would be extremely easy for someone to view other order details but not so with a uuid. Sometimes you just have to use your imagination Peter. :) -- Ryan LeTulle On Thu, Jun 11, 2009 at 3:55 PM, Peter Boughton bought...@gmail.com wrote: The tradeoff will be between a user not being able to play around with the querystring (i.e change id=1 to id=2) Huh!? Please tell me you don't use UUIDs as an alternative to having proper security/permissions in place? Because if you do have proper security there is no playing around that can happen with incremental ints, and if you don't have security, regardless of method, all it takes is an uneducated/sloppy user to [accidentily] reveal a URL/ID in public... :/ ~| 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:323435 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Looking for advice on how to do this - remote printing
How many daily tickets on average? -- Ryan LeTulle On Wed, Jun 10, 2009 at 2:28 AM, Mike Kear afpwebwo...@gmail.com wrote: I am working on a project where I am going to have to print up a job ticket in a remote location. An event happens on the web site, and it causes this job ticket to print out in one of perhaps thousands of locations unattended.The people who are going to fill the job will have no interaction with teh system except to take the job ticket off the printer and do the task. We've specced out the whole application except for the part where we connect all these remote locations to the web site.What i want is to be able to push a xml packet to this remote location and get back an ack so i know its been received and executed. Since there will be minimal training of the staff at the remote locations and they wont necessarily have access to IT staff or other specialists, we were hoping to be able to keep it as simple as the EFTPOS terminals they have in retail stores. The main difference is that with a EFTPOS terminal the store clerk starts the transaction - we're going to start this transaction at the other end and push it down to the remote location. Daily running cost is a factor, so we dont want to have the remote devices making calls to our system by modem every few minutes - we want to have it all run from our web site. Any ideas on how this could be done? The environment as far as we have it: We have a CF8 Enterprise/Win2003/SQLServer web site, and think the remote sites will need a small low-cost self-contained Linux box with a little thermal printer or something but exactly how they're connected we havent worked out yet. Anyone have experience with this kind of scenario? Perhaps a factory job ticket or a retail point of sale system maybe? -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month ~| 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:323337 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Looking for advice on how to do this - remote printing
Something like Mike's printer solution sounds promising to me. You might need to look into some special formatting/pl for the output so the printer can understand it natively though. I did some work in labs with Zebra printers that required that to print out barcodes. -- Ryan LeTulle On Wed, Jun 10, 2009 at 9:44 AM, Dawson, Michael m...@evansville.eduwrote: In my earlier reply, I mentioned that we are using an Epson POS printer with USB. This same printer can be used with a built-in NIC. That means it would not need a host computer to which it is attached. Thanks, Mike ~| 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:323349 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: How would you approach this? Shared Calender? Any volunteers?
How about pushing your data in to Google Calendar. They have a nice API, and you can easily embed the calendar with a snippet of html/js. Additionally end users can embed your events into their own personal Google Calendar to easily keep track of events. If you don't want to go that route, just give them a snippet of html/js or an iframe that pulls the calendar in from your site. Then you have full control over it and will never have an issue of getting all the other sites to update to the latest calendar code or whatever. -Ryan Al Musella, DPM wrote: I created a group of 50 brain tumor organizations and need to create a calender that each member can insert into their own website, but takes the data from my website.. I see a lot of sample code out there for creating the actual calander, but I am thinking about how to actually implement it to make it easy for people to put into their own websites.. what would be best and easiest for the members? Maybe use an iframe with the source being the calander on my website? maybe a flash or flex applet? I could do the iframe with a standard cf page myself.. but I never used flex and just basic stuff with flash. Anyone want to volunteer to help on this? Contact me privately muse...@virtualtrials.com Al ~| 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:323271 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFLOOP inside a CFQuery
I agree with NK pay attention to the evaluate function. It works like a charm for dynamically created form variables. I use it often. :) -- Ryan LeTulle On Tue, Jun 9, 2009 at 6:30 PM, N K neetukais...@gmail.com wrote: Check the following link might help... http://tutorial431.easycfm.com/ Hello all, I have a dynamically generated form that I need to figure out how to get the data from that form in to our database. Here is the way it works. First the client types in the number of machines they have and the form generates the correct number of rows so that the info about each machine is located on a separate row. That all works well until they hit submit (or will hit submit if I figure out the next part). How do I create a cfquery that has the correct number of values so that each machines data is stored correctly? For example I will have row one with lets say three fields (Type, number, issue). Lets say a client has a problem with 10 machines. The form now has 10 rows with 3 columns in each. Each field in row one is named type1, number1, issue1 and row two is type2, number2, issue2, etc.. The number next to the name is placed there by putting the index of the loop in the name field. So this is where I was going to use a CFLOOP inside a CFquery to create field names dynamically. I can get it to repeate the information correctly, however the problem is the index of the loop does not seem to get attached to the form value I am putting into the database. I am doing something like: cfquery datasource=#request.datasource# INSERT into tbl_ballotOrder (type, number, issue) Values ( cfloop from=1 to=#rows# step=1 index=LoopCount '#FORM.type##LoopCount#', '#FORM.number##LoopCount#', '#FORM. issue##LoopCount#' /cfloop ) /cfquery /cfif ~| 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:323301 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFLOOP inside a CFQuery
Interesting I've never seen any noticeable hit using evaluate but I have heard it should be avoided. (chose to ignore) I'll look into your suggestion though. I guess the question why even make evaluate available comes to mind if you should never use it? -- Ryan LeTulle On Tue, Jun 9, 2009 at 7:58 PM, Gabriel coldfus...@evolution7.com wrote: You don't need evaluate for dynamically created form variables, in almost all cases the struct syntax #form['type'idx]# will suffice and is more efficient. For this particular scenario, evaluate is an unnecessary overhead and should be avoided. cfquery datasource=#request.datasource# cfloop from=1 to=#rows# index=idx INSERT INTO tbl_ballotOrder ( type, number, issue ) VALUES ( cfqueryparam value=#form['type'idx]# cfsqltype=cf_sql_varchar /, cfqueryparam value=#form['number'idx]# cfsqltype=cf_sql_integer /, cfqueryparam value=#form['issue'idx]# cfsqltype=cf_sql_varchar / ) /cfloop /cfquery May I also point out the use of CFQUERYPARAM. It's basic principles; unless you've got a damn fine reason not to, always use cfqueryparam. Protect yourself from SQL injection attacks, make your life easier. No offence intended, but Will I urge you to ignore the 'evaluate' based advice. Cheers, Gabriel -Original Message- From: Ryan Letulle [mailto:bayous...@gmail.com] Sent: Wednesday, 10 June 2009 10:25 AM To: cf-talk Subject: Re: CFLOOP inside a CFQuery I agree with NK pay attention to the evaluate function. It works like a charm for dynamically created form variables. I use it often. :) -- Ryan LeTulle On Tue, Jun 9, 2009 at 6:30 PM, N K neetukais...@gmail.com wrote: Check the following link might help... http://tutorial431.easycfm.com/ Hello all, I have a dynamically generated form that I need to figure out how to get the data from that form in to our database. Here is the way it works. First the client types in the number of machines they have and the form generates the correct number of rows so that the info about each machine is located on a separate row. That all works well until they hit submit (or will hit submit if I figure out the next part). How do I create a cfquery that has the correct number of values so that each machines data is stored correctly? For example I will have row one with lets say three fields (Type, number, issue). Lets say a client has a problem with 10 machines. The form now has 10 rows with 3 columns in each. Each field in row one is named type1, number1, issue1 and row two is type2, number2, issue2, etc.. The number next to the name is placed there by putting the index of the loop in the name field. So this is where I was going to use a CFLOOP inside a CFquery to create field names dynamically. I can get it to repeate the information correctly, however the problem is the index of the loop does not seem to get attached to the form value I am putting into the database. I am doing something like: cfquery datasource=#request.datasource# INSERT into tbl_ballotOrder (type, number, issue) Values ( cfloop from=1 to=#rows# step=1 index=LoopCount '#FORM.type##LoopCount#', '#FORM.number##LoopCount#', '#FORM. issue##LoopCount#' /cfloop ) /cfquery /cfif ~| 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:323303 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFLOOP inside a CFQuery
@gabrieldoes the cfqueryparam matter or can you just use #form['type'idx]# in any way? -- Ryan LeTulle On Tue, Jun 9, 2009 at 7:58 PM, Gabriel coldfus...@evolution7.com wrote: You don't need evaluate for dynamically created form variables, in almost all cases the struct syntax #form['type'idx]# will suffice and is more efficient. For this particular scenario, evaluate is an unnecessary overhead and should be avoided. cfquery datasource=#request.datasource# cfloop from=1 to=#rows# index=idx INSERT INTO tbl_ballotOrder ( type, number, issue ) VALUES ( cfqueryparam value=#form['type'idx]# cfsqltype=cf_sql_varchar /, cfqueryparam value=#form['number'idx]# cfsqltype=cf_sql_integer /, cfqueryparam value=#form['issue'idx]# cfsqltype=cf_sql_varchar / ) /cfloop /cfquery May I also point out the use of CFQUERYPARAM. It's basic principles; unless you've got a damn fine reason not to, always use cfqueryparam. Protect yourself from SQL injection attacks, make your life easier. No offence intended, but Will I urge you to ignore the 'evaluate' based advice. Cheers, Gabriel -Original Message- From: Ryan Letulle [mailto:bayous...@gmail.com] Sent: Wednesday, 10 June 2009 10:25 AM To: cf-talk Subject: Re: CFLOOP inside a CFQuery I agree with NK pay attention to the evaluate function. It works like a charm for dynamically created form variables. I use it often. :) -- Ryan LeTulle On Tue, Jun 9, 2009 at 6:30 PM, N K neetukais...@gmail.com wrote: Check the following link might help... http://tutorial431.easycfm.com/ Hello all, I have a dynamically generated form that I need to figure out how to get the data from that form in to our database. Here is the way it works. First the client types in the number of machines they have and the form generates the correct number of rows so that the info about each machine is located on a separate row. That all works well until they hit submit (or will hit submit if I figure out the next part). How do I create a cfquery that has the correct number of values so that each machines data is stored correctly? For example I will have row one with lets say three fields (Type, number, issue). Lets say a client has a problem with 10 machines. The form now has 10 rows with 3 columns in each. Each field in row one is named type1, number1, issue1 and row two is type2, number2, issue2, etc.. The number next to the name is placed there by putting the index of the loop in the name field. So this is where I was going to use a CFLOOP inside a CFquery to create field names dynamically. I can get it to repeate the information correctly, however the problem is the index of the loop does not seem to get attached to the form value I am putting into the database. I am doing something like: cfquery datasource=#request.datasource# INSERT into tbl_ballotOrder (type, number, issue) Values ( cfloop from=1 to=#rows# step=1 index=LoopCount '#FORM.type##LoopCount#', '#FORM.number##LoopCount#', '#FORM. issue##LoopCount#' /cfloop ) /cfquery /cfif ~| 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:323304 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFLOOP inside a CFQuery
I tend to agree if that syntax works in all situations for dynamic form variables and I'm not doing something that works sometimes and I'm not sure exactly when. -- Ryan LeTulle On Tue, Jun 9, 2009 at 8:14 PM, Gabriel coldfus...@evolution7.com wrote: Repost/Edit: apparently msoft forefront exchange server thinks I was being profane. You don't need evaluate for dynamically created form variables, in almost all cases the struct syntax #form['type'idx]# will suffice and is more efficient. For this particular scenario, evaluate is an unnecessary overhead and should be avoided. cfquery datasource=#request.datasource# cfloop from=1 to=#rows# index=idx INSERT INTO tbl_ballotOrder ( type, number, issue ) VALUES ( cfqueryparam value=#form['type'idx]# cfsqltype=cf_sql_varchar /, cfqueryparam value=#form['number'idx]# cfsqltype=cf_sql_integer /, cfqueryparam value=#form['issue'idx]# cfsqltype=cf_sql_varchar / ) /cfloop /cfquery May I also point out the use of CFQUERYPARAM. It's basic principles; unless you've got a *very* fine reason not to, always use cfqueryparam. Protect yourself from SQL injection attacks, make your life easier. No offence intended, but Will I urge you to ignore the 'evaluate' based advice. Cheers, Gabriel -Original Message- From: Ryan Letulle [mailto:bayous...@gmail.com] Sent: Wednesday, 10 June 2009 10:25 AM To: cf-talk Subject: Re: CFLOOP inside a CFQuery I agree with NK pay attention to the evaluate function. It works like a charm for dynamically created form variables. I use it often. :) -- Ryan LeTulle On Tue, Jun 9, 2009 at 6:30 PM, N K neetukais...@gmail.com wrote: Check the following link might help... http://tutorial431.easycfm.com/ Hello all, I have a dynamically generated form that I need to figure out how to get the data from that form in to our database. Here is the way it works. First the client types in the number of machines they have and the form generates the correct number of rows so that the info about each machine is located on a separate row. That all works well until they hit submit (or will hit submit if I figure out the next part). How do I create a cfquery that has the correct number of values so that each machines data is stored correctly? For example I will have row one with lets say three fields (Type, number, issue). Lets say a client has a problem with 10 machines. The form now has 10 rows with 3 columns in each. Each field in row one is named type1, number1, issue1 and row two is type2, number2, issue2, etc.. The number next to the name is placed there by putting the index of the loop in the name field. So this is where I was going to use a CFLOOP inside a CFquery to create field names dynamically. I can get it to repeate the information correctly, however the problem is the index of the loop does not seem to get attached to the form value I am putting into the database. I am doing something like: cfquery datasource=#request.datasource# INSERT into tbl_ballotOrder (type, number, issue) Values ( cfloop from=1 to=#rows# step=1 index=LoopCount '#FORM.type##LoopCount#', '#FORM.number##LoopCount#', '#FORM. issue##LoopCount#' /cfloop ) /cfquery /cfif ~| 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:323308 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFLOOP inside a CFQuery
thx for the form info, on a side note: became very aware of the value of cfqueryparam last year during the chinese et al sql injection attacks -- Ryan LeTulle On Tue, Jun 9, 2009 at 8:17 PM, Gabriel coldfus...@evolution7.com wrote: Ryan, You can use #form['string'var]# anywhere, including form['string'var] = x. CfQueryParam is a separate issue relating purely to Will's SQL and it's vulnerability to SQL injection attack. Cheers, Gabriel -Original Message- From: Ryan Letulle [mailto:bayous...@gmail.com] Sent: Wednesday, 10 June 2009 11:11 AM To: cf-talk Subject: Re: CFLOOP inside a CFQuery @gabrieldoes the cfqueryparam matter or can you just use #form['type'idx]# in any way? -- Ryan LeTulle On Tue, Jun 9, 2009 at 7:58 PM, Gabriel coldfus...@evolution7.com wrote: You don't need evaluate for dynamically created form variables, in almost all cases the struct syntax #form['type'idx]# will suffice and is more efficient. For this particular scenario, evaluate is an unnecessary overhead and should be avoided. cfquery datasource=#request.datasource# cfloop from=1 to=#rows# index=idx INSERT INTO tbl_ballotOrder ( type, number, issue ) VALUES ( cfqueryparam value=#form['type'idx]# cfsqltype=cf_sql_varchar /, cfqueryparam value=#form['number'idx]# cfsqltype=cf_sql_integer /, cfqueryparam value=#form['issue'idx]# cfsqltype=cf_sql_varchar / ) /cfloop /cfquery May I also point out the use of CFQUERYPARAM. It's basic principles; unless you've got a *very* fine reason not to, always use cfqueryparam. Protect yourself from SQL injection attacks, make your life easier. No offence intended, but Will I urge you to ignore the 'evaluate' based advice. Cheers, Gabriel -Original Message- From: Ryan Letulle [mailto:bayous...@gmail.com] Sent: Wednesday, 10 June 2009 10:25 AM To: cf-talk Subject: Re: CFLOOP inside a CFQuery I agree with NK pay attention to the evaluate function. It works like a charm for dynamically created form variables. I use it often. :) -- Ryan LeTulle On Tue, Jun 9, 2009 at 6:30 PM, N K neetukais...@gmail.com wrote: Check the following link might help... http://tutorial431.easycfm.com/ Hello all, I have a dynamically generated form that I need to figure out how to get the data from that form in to our database. Here is the way it works. First the client types in the number of machines they have and the form generates the correct number of rows so that the info about each machine is located on a separate row. That all works well until they hit submit (or will hit submit if I figure out the next part). How do I create a cfquery that has the correct number of values so that each machines data is stored correctly? For example I will have row one with lets say three fields (Type, number, issue). Lets say a client has a problem with 10 machines. The form now has 10 rows with 3 columns in each. Each field in row one is named type1, number1, issue1 and row two is type2, number2, issue2, etc.. The number next to the name is placed there by putting the index of the loop in the name field. So this is where I was going to use a CFLOOP inside a CFquery to create field names dynamically. I can get it to repeate the information correctly, however the problem is the index of the loop does not seem to get attached to the form value I am putting into the database. I am doing something like: cfquery datasource=#request.datasource# INSERT into tbl_ballotOrder (type, number, issue) Values ( cfloop from=1 to=#rows# step=1 index=LoopCount '#FORM.type##LoopCount#', '#FORM.number##LoopCount#', '#FORM. issue##LoopCount#' /cfloop ) /cfquery /cfif ~| 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:323309 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFLOOP inside a CFQuery
After seeing how malicious and how effective hackers were with automated sql injection last year I vowed to never leave an integer field unturned without using cfqueryparameters it's just too easy to use it and the benefit is unquestionable especially for integer fields. I am also seeing some addtl benefits with other field types now as well but integers are required. -- Ryan LeTulle On Tue, Jun 9, 2009 at 9:51 PM, Gabriel coldfus...@evolution7.com wrote: Will, Justin is right, just because your form is behind a username/password it by no means guarantees that the people accessing that form aren't malicious. As for whether there are scenarios where you shouldn't use queryparam? That's probably open for debate (it's certainly been debated before), however I've not come across a situation (except the caching issue as mentioned) where it's been of any benefit to NOT use queryparam. - Gabriel -Original Message- From: Justin Scott [mailto:jscott-li...@gravityfree.com] Sent: Wednesday, 10 June 2009 12:42 PM To: cf-talk Subject: RE: CFLOOP inside a CFQuery WOW! Thanks for all the feedback! One question about CFQUERYPARAM, I use this when I accept anything that is available to the general public, but is it necessary to use this when the form is only accessible via username/password? I would use it regardless of who is going to be hitting those queries. You never know when some nefarious person is going to break into an admin account and start probing around. Is there ever a reason not to use CFQUERYPARAM? Before ColdFusion 8 was released, you could not use CFQUERYPARAM in conjunction with a cached query. CF8 now allows that (yea!). -Justin ~| 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:323313 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Sitewide Error Handler and IFrames
In my experience it has. -- Ryan LeTulle On Mon, Jun 8, 2009 at 4:33 PM, Eric Roberts ow...@threeravensconsulting.com wrote: We have ample use of Iframes on our site (something I cannot change) and we would like to use the sitewide error handler to manage errors. If an error is thrown in an iframe, the error is only going to be shown in that Iframe and the rest of the page will display as normal...right? I just wanted to verify this before we spend any more time spinning out wheels here. Thanks! Eric ~| 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:323244 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SOA Coldfusion best practices
ha ha -- Ryan LeTulle On Mon, Jun 8, 2009 at 5:27 PM, David McGuigan davidmcgui...@gmail.comwrote: Who are you kidding, you loved doing that. On Mon, Jun 8, 2009 at 4:14 PM, Nathan Strutz str...@gmail.com wrote: I hate to do this, but, did you try http://tinyurl.com/nx44fe ? nathan strutz [Blog and Family @ http://www.dopefly.com/] [AZCFUG Manager @ http://www.azcfug.org/] [Twitter @nathanstrutz] On Mon, Jun 8, 2009 at 2:49 PM, Tim Oommen toom...@playboy.com wrote: Are there any good sites or presentations that people can recommend for best practices when implementing a SOA architecture using ColdFusion? ~| 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:323252 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Moving from CF to Java - redirecting old pages to new ones
I know someone knows a better way but I have done it in the application.cfm using cfheader statuscode=301, statustext=Moved Permanently then another cfheader name=Location value=new url. First detecting whether it's the page in question of course. -- Ryan LeTulle On Fri, Jun 5, 2009 at 12:22 PM, coldfusion.develo...@att.net wrote: All, We have over 100 cfm pages that we'll need to redirect to a reduced number of new, few jsp pages. Is the best way to do this at the server, IIS level or through the webpage level. I'm thinking, detect all requests globally and if they have a .cfm extension, look up that page in a db and serve up the replacment page. Thoughts? Thanks D ~| 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:323210 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Generating appopriate transaction IDs
I've been using createuuid() for a little while now and I haven't encountered any issues. I like it because you don't have as many smart asses trying to go in and change the id in the querystring. :) -- Ryan On Thu, Jun 4, 2009 at 6:28 AM, Peter Boughton bought...@gmail.com wrote: getTickcount() or createUuid() ~| 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:323156 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: reducing a query result
All I can say is wow! -- Ryan On Thu, Jun 4, 2009 at 10:24 AM, Alan Rother alan.rot...@gmail.com wrote: Coolio... If you ever need my good friend Nathan Strutz wrote a great tool for pagination http://www.dopefly.com/projects/pagination/ Sure saves a lot of time... http://www.dopefly.com/projects/pagination/=] -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org ~| 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:323172 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: reducing a query result
You can do something similar with SQL Server 2005 http://www.stillnetstudios.com/2008/11/12/pagination-mssql-2005/ -Ryan Andy Matthews wrote: If you're using mySQL, then look into the LIMIT keyword: SELECT [columns] FROM [tableName] LIMIT [totalRecords], [startingRow] This way you ONLY get the data you want. You could easily tie this into a data grid via Ext (or jQuery) so that new pages call only the data for that page. Here's one of the preeminent jQuery versions: http://www.flexigrid.info/ And a tutorial written by a coworker of mine on Ext data grids: http://blog.cutterscrossing.com/index.cfm/2007/4/24/My-First-ExtJS-DataGrid- Pt-1 andy -Original Message- From: Chad Gray [mailto:cg...@careyweb.com] Sent: Thursday, June 04, 2009 10:07 AM To: cf-talk Subject: reducing a query result Say I have a query returned with 500 records. Is there a way in CF (not SQL) to reduce the query to only rows 1-50, 51-100 etc? I talking physically reducing the query object. ~| 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:323176 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Generating appopriate transaction IDs
I just fired up Tomcat and tried getTickCount() on all 3 CFML engines within a second or two of each other. OpenBD: 276282Railo: 1244157288529cfusion: 1244157287685 Running date +%s on my linux box gives me 1244157286 so it looks like cfusion and Railo do indeed return milliseconds since the epoch. This may not have always been the case, hence the fuzzy documentation. -Ryan From: Peter Boughton bought...@gmail.com Sent: Thursday, June 04, 2009 4:43 PM To: cf-talk cf-talk@houseoffusion.com Subject: Re: Generating appopriate transaction IDs it resets back to 1 every time the server restarts. Huh? I was under the impression it was number of milliseconds since the unix epoch (1-Jan-1970). Certainly that's what Railo is returning, and no resetting after restart there. I'm 99% certain that CF7 acts in the same way. The CF docs are a bit vague/contradictory on it though: Description - Returns the current value of an internal millisecond timer. Returns - A string representation of the system time, in milliseconds. Usage - The value of the counter has no meaning. ~| 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:323188 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Generating appopriate transaction IDs
Eh sorry my webmail sucks, lets see if this one comes through formatted better. __ I just fired up Tomcat and tried getTickCount() on all 3 CFML engines within a second or two of each other. OpenBD: 276282 Railo: 1244157288529 cfusion: 1244157287685 Running date +%s on my linux box gives me 1244157286 so it looks like cfusion and Railo do indeed return milliseconds since the epoch. This may not have always been the case, hence the fuzzy documentation. -Ryan From: Peter Boughton Sent: Thursday, June 04, 2009 4:43 PM To: cf-talk Subject: Re: Generating appopriate transaction IDs it resets back to 1 every time the server restarts. Huh? I was under the impression it was number of milliseconds since the unix epoch (1-Jan-1970). Certainly that's what Railo is returning, and no resetting after restart there. I'm 99% certain that CF7 acts in the same way. The CF docs are a bit vague/contradictory on it though: Description - Returns the current value of an internal millisecond timer. Returns - A string representation of the system time, in milliseconds. Usage - The value of the counter has no meaning. ~| 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:323189 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: jquery question
Shouldn't be hard at all to have a hidden div prepared. After the text area is changed put the script in the div (getelementbyid) and show the div. I don't think you need ajax for that. You could certainly write it in jQuery syntax but any old javascript should do that. I've never tested it but I think it should work unless there is some issue with the script you are pasting. -- Ryan On Wed, Jun 3, 2009 at 5:42 PM, Mike Little m...@nzsolutions.co.nz wrote: sorry, could not think of a better subject! i have a form which an admin enters a embed script such as a youtube video. what i would like to achieve is to have a preview button which takes the contents of the textarea (ultimately filters the content with my clever param filter) and displays the output in a popup similar to... http://yensdesign.com/tutorials/popupjquery/ (or alternatively the output displays in a div below the textarea?) i am very new to jquery/ajax and really would like to get into it. unfortunately we have issues with using cf8's ajax features on my hosts shared server and would like to use native jquery/ajax. any help/pointers in the right direction would be really appreciated. mike ~| 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:323136 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: jquery question
I usually choose Thickbox for a lightbox feature. Not the best looking out of the box but very functional and you can always style it. -- Ryan On Wed, Jun 3, 2009 at 5:54 PM, Charlie Griefer charlie.grie...@gmail.comwrote: check out one of the many jquery lightbox clones. http://www.no-margin-for-errors.com/projects/prettyPhoto-jquery-lightbox-clone/ http://www.stickmanlabs.com/lightwindow/ On Wed, Jun 3, 2009 at 3:42 PM, Mike Little m...@nzsolutions.co.nz wrote: sorry, could not think of a better subject! i have a form which an admin enters a embed script such as a youtube video. what i would like to achieve is to have a preview button which takes the contents of the textarea (ultimately filters the content with my clever param filter) and displays the output in a popup similar to... http://yensdesign.com/tutorials/popupjquery/ (or alternatively the output displays in a div below the textarea?) i am very new to jquery/ajax and really would like to get into it. unfortunately we have issues with using cf8's ajax features on my hosts shared server and would like to use native jquery/ajax. any help/pointers in the right direction would be really appreciated. mike ~| 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:323138 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Dreaded cfform issue
Working with a cfform here in CF7 and I'm getting a javascript error and
none of the validation is happening. Wondering if anyone has seen this one
lately?
Firefox Javascript Console Error Message:
obj.value is undefined
http://mydomainhere.com/js/cfform.js
Points to this line in the cfform.js:
function _CF_hasValue(obj, obj_type, obj_trim)
{
if (obj_type == TEXT || obj_type == FILE ||obj_type == PASSWORD
|| obj_type == CFTEXTAREA || obj_type == TEXTAREA || obj_type ==
CFTEXTINPUT)
{
if (obj.value.length == 0)
return false;
else
if( obj_trim )
{
//trim whitespace - for backward compatability this
is optional
str =
obj.value.replace(/^\s+/,'').replace(/\s+$/,'');
if (str.length == 0)
{ return false; }
}
return true;
Scratching my head. Think it's time to go home. Been a long day.
--
Ryan
~|
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:323139
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Dreaded cfform issue
Stripped it down to nothing, still didn't work. Needed something real quick
and burned again by cfform.
Sigh, I'll do it in jQuery tomorrow.
thx
--
Ryan
On Wed, Jun 3, 2009 at 6:44 PM, Gerald Guido gerald.gu...@gmail.com wrote:
My bad skimmed the original post. Most often it due to js files not
getting loaded or hand rolled js conflicting with CF form.
G!
On Wed, Jun 3, 2009 at 7:38 PM, Gerald Guido gerald.gu...@gmail.com
wrote:
It looks like cfform.js is not being loaded. Make sure that the cfform JS
files are being included. The fastest way to fix this (in case of an
emergency) is to copy the /CFIDE/scripts/ directory to the root of your
site or create that dir and copy over cfform.js and other related js
files.
It is a mapping issue IIRC.
HTH
G!
On Wed, Jun 3, 2009 at 7:22 PM, Ryan Letulle bayous...@gmail.com
wrote:
Working with a cfform here in CF7 and I'm getting a javascript error and
none of the validation is happening. Wondering if anyone has seen this
one
lately?
Firefox Javascript Console Error Message:
obj.value is undefined
http://mydomainhere.com/js/cfform.js
Points to this line in the cfform.js:
function _CF_hasValue(obj, obj_type, obj_trim)
{
if (obj_type == TEXT || obj_type == FILE ||obj_type ==
PASSWORD
|| obj_type == CFTEXTAREA || obj_type == TEXTAREA || obj_type ==
CFTEXTINPUT)
{
if (obj.value.length == 0)
return false;
else
if( obj_trim )
{
//trim whitespace - for backward
compatability
this is optional
str =
obj.value.replace(/^\s+/,'').replace(/\s+$/,'');
if (str.length == 0)
{ return false; }
}
return true;
Scratching my head. Think it's time to go home. Been a long day.
--
Ryan
~|
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:323142
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: jquery question
Sorry Mike. I guess I'm not fully understanding where your problem is if you are going to submit form data. Do you want the lightbox to appear automatically after the form is submitted? Why can't you process the submission normally? or are you looking to just submit the script through jquery (i.e load or ajax) to another page and make something happen on your page after it is tweeked? I was not aware that jQuery could communicate directly with a cfc but I am sure someone hear could get that going. I have always communicated with a cfm page which might invoke a cfc. -- Ryan On Wed, Jun 3, 2009 at 7:03 PM, Mike Little m...@nzsolutions.co.nz wrote: thanks guys, my question is though - how to pass formatted content from my textarea to the div upon form submission (or another button submit). ultimately i would like to pass the content to a cfc first to check and amend data as required so this is why i thought jquery would be the way to go. mike ~| 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:323146 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: captcha
Looks nice. I'll try it to. :) -- Ryan On Tue, Jun 2, 2009 at 8:51 AM, Scott Weikert li...@alphageek.com wrote: Rob Parkhill wrote: Awesome form protection http://cfformprotect.riaforge.org/ I second that. I've been using CFFormProtect for a while now with good results. ~| 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:323077 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: IUM Re: IUM Re: Google Map API
This what I do. Hope it helps:
!DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Strict//EN
http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd;
html xmlns=http://www.w3.org/1999/xhtml;
xmlns:v=urn:schemas-microsoft-com:vml
head
meta http-equiv=content-type content=text/html; charset=UTF-8/
script
src=http://maps.google.com/maps?file=apiamp;v=2.xamp;key=cfoutput#request.gmapkey#/cfoutput
type=text/javascript/script
script type=text/javascript
var map = null;
var geocoder = null;
function initialize() {
if (GBrowserIsCompatible()) {
map = new GMap2(document.getElementById(map_canvas));
map.setCenter(new GLatLng(40.78704, -73.965797), 13);
map.setUIToDefault()
geocoder = new GClientGeocoder();
}
}
function showAddress(address) {
if (geocoder) {
geocoder.getLatLng(
address,
function(point) {
if (!point) {
alert(address + not found);
} else {
map.setCenter(point, 13);
var marker = new GMarker(point);
map.addOverlay(marker);
marker.openInfoWindowHtml(address);
}
}
);
}
}
/script
/head
body
onload=initialize();showAddress(document.getElementById('geo').address.value);
return false onunload=GUnload()
cftry
form id=geo action=# onsubmit=showAddress(this.address.value);
return false
p
cfparam name=url.address default=414 East 88th Street, New York
input type=hidden size=50 name=address
value=cfoutput#listfirst(url.address)#, New York/cfoutput /
!---
input type=submit value=Show Map /
---
/p
div id=map_canvas style=width: 400px; height: 500px/div
/form
cfcatch/cfcatch
/cftry
/body
/html
--
Ryan
On Sat, May 30, 2009 at 7:50 AM, Jenny Gavin-Wear
jenn...@fasttrackonline.co.uk wrote:
Hi Ryan,
I looked at the page again in firefox using the Javascript error console
script
src=
http://maps.google.com/maps?file=apiamp;v=2amp;key=#session.GoogleKey
#
type=text/javascript/script
script type=text/javascript
//![CDATA[
function load() {
if (GBrowserIsCompatible()) {
var map = new GMap2(document.getElementById(map));
map.setCenter(new GLatLng(#dLatitude#, #dLongitude#), 14);
map.addControl(new GLargeMapControl());
map.centerAndZoom(new GPoint(#dLatitude#, #dLongitude#), 3);
var point = new GPoint(#dLatitude#, #dLongitude#);
var marker = new GMarker(point);
map.addOverlay(marker);
}
}
//]]
/script
The line:
map.centerAndZoom(new GPoint(#dLatitude#, #dLongitude#), 3);
gives the error:
map.centerAndZoom is not a function
I removed this line assuming if it was bad the script would stop processing
at this point, but still no marker.
Jenny
-Original Message-
From: Ryan Letulle [mailto:bayous...@gmail.com]
Sent: 28 May 2009 14:06
To: cf-talk
Subject: SPAM-MEDIUM Re: IUM Re: Google Map API
I assume you are not getting any javascript errors?
--
Ryan
~|
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:323004
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Need help with dynamic form fields
Not sure of what you are trying to do, but I usually use getelementbyid when I need to work with form fields. Very straightforward and lots of examples, just Google. w3schools etc -- Ryan On Sat, May 30, 2009 at 8:02 PM, Torrent Girl torrentg...@gmail.com wrote: hello I have an issue that I am stuck on. I need to check the value of dynamic form fields with javascript and don't know how. Here is what the form fields look like: compensationType_userID (this is the field name) The userID will be the dynamic part. How do I check for the value in javascript on the form submission? If compensation type = salary, then do this... Thank you. ~| 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:323007 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Autosuggest truncating long result strings
That might be a setting in the autocomplete js. There are some default settings in the middle of the js. You are using the one from bassistance right? -- Ryan On Fri, May 29, 2009 at 7:11 AM, Torrent Girl torrentg...@gmail.com wrote: Is there anyway for me change this? possibly in CFIDE somewhere? ~| 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:322947 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Autosuggest truncating long result strings
Sorry, no experience there. I use the one you started with. -- Ryan On Fri, May 29, 2009 at 7:50 AM, Torrent Girl torrentg...@gmail.com wrote: Now I am using the coldfusion autosuggest. I nver got that other one to work. That might be a setting in the autocomplete js. There are some default settings in the middle of the js. You are using the one from bassistance right? -- Ryan Is there anyway for me change this? possibly in CFIDE somewhere? ~| 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:322951 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: query question
what db -- Ryan On Fri, May 29, 2009 at 9:41 AM, Chad Gray cg...@careyweb.com wrote: I have two tables that are joined one to many. I would like to write a query to get the one from the first table and only one from the many table. TABLE1 AlbumID, AlbumTitle 1, MyPictures TABLE2 PictureID, AlbumID, PictureName 1, 1, test.jpg 2, 1, test2.jpg How do I write the query to only get one record from TABLE2 when I join? SELECT * FROM TABLE1 JOIN TABLE2 ON TABLE2.AlbumID = TABLE1.AlbumID WHERE TABLE1.AlbumID = 1 This query returns 2 records because there are two matches in TABLE2. ~| 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:322966 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: query question
add LIMIT 0,1 add the end of the query to only grab the first match -- Ryan On Fri, May 29, 2009 at 9:50 AM, Chad Gray cg...@careyweb.com wrote: Sorry should have mentioned that MySQL -Original Message- From: Ryan Letulle [mailto:bayous...@gmail.com] Sent: Friday, May 29, 2009 10:48 AM To: cf-talk Subject: Re: query question what db -- Ryan On Fri, May 29, 2009 at 9:41 AM, Chad Gray cg...@careyweb.com wrote: I have two tables that are joined one to many. I would like to write a query to get the one from the first table and only one from the many table. TABLE1 AlbumID, AlbumTitle 1, MyPictures TABLE2 PictureID, AlbumID, PictureName 1, 1, test.jpg 2, 1, test2.jpg How do I write the query to only get one record from TABLE2 when I join? SELECT * FROM TABLE1 JOIN TABLE2 ON TABLE2.AlbumID = TABLE1.AlbumID WHERE TABLE1.AlbumID = 1 This query returns 2 records because there are two matches in TABLE2. ~| 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:322970 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CF7 Unzip an encrypted, password protected .zip
Can anyone point me to a resource to unzip a 256 AES .zip with a password in CF 7? -- Ryan ~| 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:322993 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: IUM Re: Google Map API
I assume you are not getting any javascript errors?
--
Ryan
On Thu, May 28, 2009 at 7:54 AM, Jenny Gavin-Wear
jenn...@fasttrackonline.co.uk wrote:
Umm .. no .. it's in there ..
-Original Message-
From: Paul Ihrig [mailto:pih...@gmail.com]
Sent: 15 May 2009 13:55
To: cf-talk
Subject: SPAM-MEDIUM Re: Google Map API
map.addOverlay(marker);
missing ;
maybe
On Fri, May 15, 2009 at 8:04 AM, Jenny Gavin-Wear
jenn...@fasttrackonline.co.uk wrote:
(message bumped with corrected subject ... help !!!)
hi all .. trying to get a marker to show on the google map api ...
extract
of code below ..
anyone have any ideas as to why my marker isn't visible, please?
tia, jenny
cfoutput
script
src=
http://maps.google.com/maps?file=apiamp;v=2amp;key=#session.GoogleKey
#
type=text/javascript/script
script type=text/javascript
//![CDATA[
function load() {
if (GBrowserIsCompatible()) {
var map = new GMap2(document.getElementById(map));
map.setCenter(new GLatLng(#dLatitude#, #dLongitude#), 14);
map.addControl(new GSmallMapControl());
map.centerAndZoom(new GPoint(#dLatitude#, #dLongitude#),
3);
var point = new GPoint(#dLatitude#, #dLongitude#);
var marker = new GMarker(point);
map.addOverlay(marker)
}
}
//]]
/script
/cfoutput
~|
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:322868
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: (ot) Hacked by Fatal Error
How difficult was your ftp user/password? -- Ryan On Thu, May 28, 2009 at 8:47 AM, Scott Mulholland smulholl...@aimg.comwrote: It's a demo server we use to show clients works in progress, its behind our firewall but is open on 80 for this purpose. -Original Message- From: Tom Chiverton [mailto:tom.chiver...@halliwells.com] Sent: Thursday, May 28, 2009 4:24 AM To: cf-talk Subject: Re: (ot) Hacked by Fatal Error of hey admin take care of server. We saw it on one internal dev server How did The World get access to your internal systems ? -- Helping to evangelistically orchestrate granular edge-of-your-seat architectures as part of the IT team of the year, '09 and '08 Tom Chiverton Developer Tel: +44 0161 618 5032 Fax: +44 0161 618 5099 tom.chiver...@halliwells.com 3 Hardman Square, Manchester, M3 3EB www.Halliwells.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office together with a list of those non members who are referred to as partners. We use the word partner to refer to a member of the LLP, or an employee or consultant with equivalent standing and qualifications. Regulated by the Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.Halliwells.com. ~| 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:322874 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: question on jquery..need answer pretty quickly if possible
Nice Stephane.
I did one like this: (Way too much code obviously but it works)
cfparam name=city_list default=
cfloop query=getCities
cfif getcities.recordcount NEQ getcities.currentrow
cfset city_list = city_list '' getcities.city ','
cfelse
cfset city_list = city_list '' getcities.city ''
/cfif
/cfloop
$(document).ready(function(){
// City dropdowns
$(#city).autocompleteArray([cfoutput#city_list#/cfoutput]);
});
/script
--
Ryan
On Thu, May 28, 2009 at 9:08 AM, Stephane Vantroyen s...@emakina.com wrote:
I would suggest doing this way :
cfquery name=myQueryyour query here/cfquery
cfset myList = [
ListQualify(ValueList(myQuery.NameofField),'',',','all') ]
So you have a list in the same format as your example here below;
Then you just replace the list (with [ and ]) by
cfoutput#myList#/cfoutput in the script
Theer are other ways of doing this I'm sure, but that's the one I would use
to go faster
Stéphane
I am trying to use jquery code provided by one of the online samples.
The code is below. As you can see the city list is hard coded. I am
wondering if I can create my own searchable list from query results
and replace the list below with my new list.
Thanks for any suggestions.
script type=text/javascript
$(document).ready(function() {
$(#country).autocomplete(
data/country.cfm,
{
minChars:2,
delay:200,
autoFill:false,
matchSubset:false,
matchContains:1,
cacheLength:10,
selectOnly:1
}
);
$(#city).autocompleteArray(
[1,2,3,Brighton and Hove,Bristol,
Cambridge,Canterbury,Carlisle,Chester,Chichester,
Coventry,Derby,Durham,Ely,Exeter,Gloucester,Hereford,
Kingston upon
Hull,Lancaster,Leeds,Leicester,Lichfield,
Lincoln,Liverpool,London,Manchester,Newcastle-upon-Tyne,
Norwich,Nottingham,Oxford,Peterborough,Plymouth,
Portsmouth,
Preston,Ripon,Salford,Salisbury,Sheffield,Southampton,
St
Albans,Stoke-on-Trent,Sunderland,Truro,Wakefield,
Wells,
Westminster,Winchester,Wolverhampton,Worcester,York],
{
minChars:1,
delay:10,
autoFill:true,
matchSubset:1,
matchContains:1,
selectOnly:1
}
);
});
/script
~|
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:322877
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: question on jquery..need answer pretty quickly if possible
How does your source look?
--
Ryan
On Thu, May 28, 2009 at 9:25 AM, Torrent Girl torrentg...@gmail.com wrote:
Thanks
The list creation does exactly what I need it to but the cfoutput... does
work.
It's not giving an error but the autocomplete does nothing.
I would suggest doing this way :
cfquery name=myQueryyour query here/cfquery
cfset myList = [ ListQualify(ValueList(myQuery.NameofField),'',',
','all') ]
So you have a list in the same format as your example here below;
Then you just replace the list (with [ and ]) by
cfoutput#myList#/cfoutput in the script
Theer are other ways of doing this I'm sure, but that's the one I
would use to go faster
Stéphane
I am trying to use jquery code provided by one of the online samples.
The code is below. As you can see the city list is hard coded. I am
wondering if I can create my own searchable list from query results
and replace the list below with my new list.
Thanks for any suggestions.
script type=text/javascript
$(document).ready(function() {
$(#country).autocomplete(
data/country.cfm,
{
minChars:2,
delay:200,
autoFill:false,
matchSubset:false,
matchContains:1,
cacheLength:10,
selectOnly:1
}
);
$(#city).autocompleteArray(
[1,2,3,Brighton and Hove,Bristol,
Cambridge,Canterbury,Carlisle,Chester,Chichester,
Coventry,Derby,Durham,Ely,Exeter,Gloucester,
Hereford,
Kingston upon
Hull,Lancaster,Leeds,Leicester,Lichfield,
Lincoln,Liverpool,London,Manchester,
Newcastle-upon-Tyne,
Norwich,Nottingham,Oxford,Peterborough,Plymouth,
Portsmouth,
Preston,Ripon,Salford,Salisbury,Sheffield,
Southampton,
St
Albans,Stoke-on-Trent,Sunderland,Truro,Wakefield,
Wells,
Westminster,Winchester,Wolverhampton,Worcester,York],
{
minChars:1,
delay:10,
autoFill:true,
matchSubset:1,
matchContains:1,
selectOnly:1
}
);
});
/script
~|
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:322883
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: (ot) Hacked by Fatal Error
Any chance they were an old employee etc that knew the password? -- Ryan On Thu, May 28, 2009 at 9:34 AM, Scott Mulholland smulholl...@aimg.comwrote: I would have considered it strong - 9 chars, letters/numbers/other chars mixed case. The ftp logs don't show anything though. I looked into turning off webDav on it since its IIS 5.0. I just wish I felt better about knowing how they got in. -Original Message- From: Ryan Letulle [mailto:bayous...@gmail.com] Sent: Thursday, May 28, 2009 10:12 AM To: cf-talk Subject: Re: (ot) Hacked by Fatal Error How difficult was your ftp user/password? -- Ryan On Thu, May 28, 2009 at 8:47 AM, Scott Mulholland smulholl...@aimg.comwrote: It's a demo server we use to show clients works in progress, its behind our firewall but is open on 80 for this purpose. -Original Message- From: Tom Chiverton [mailto:tom.chiver...@halliwells.com] Sent: Thursday, May 28, 2009 4:24 AM To: cf-talk Subject: Re: (ot) Hacked by Fatal Error of hey admin take care of server. We saw it on one internal dev server How did The World get access to your internal systems ? -- Helping to evangelistically orchestrate granular edge-of-your-seat architectures as part of the IT team of the year, '09 and '08 Tom Chiverton Developer Tel: +44 0161 618 5032 Fax: +44 0161 618 5099 tom.chiver...@halliwells.com 3 Hardman Square, Manchester, M3 3EB www.Halliwells.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office together with a list of those non members who are referred to as partners. We use the word partner to refer to a member of the LLP, or an employee or consultant with equivalent standing and qualifications. Regulated by the Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.Halliwells.com. ~| 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:322884 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: question on jquery..need answer pretty quickly if possible
So everything works until you change the list? Something must be wrong with
the list format. Extra or missing comma.
--
Ryan
On Thu, May 28, 2009 at 9:39 AM, Torrent Girl torrentg...@gmail.com wrote:
Would it look like this?
cfoutput
script type=text/javascript
var scriptList = '#myList#';
$(document).ready(function() {
$(##country).autocomplete(
data/country.cfm,
{
minChars:2,
delay:200,
autoFill:false,
matchSubset:false,
matchContains:1,
cacheLength:10,
selectOnly:1
}
);
$(##city).autocompleteArray(
scriptList,
{
minChars:1,
delay:10,
autoFill:false,
matchSubset:10,
matchContains:10,
selectOnly:10
}
);
});
/script
/cfoutput
Have you tried to dump the value of the list to see if it matches the
format of the list in the jquery script?
You also may wanna try to put the list in a script var and use it :
script type=text/javascript
var scriptList = cfoutput'#myCFgeneratedlist#'/cfoutput;
$(document).ready(function() {
$(#country).autocomplete(
data/country.cfm,
{
minChars:2,
delay:200,
autoFill:false,
matchSubset:false,
matchContains:1,
cacheLength:10,
selectOnly:1
}
);
$(#city).autocompleteArray(scriptList),
{
minChars:1,
delay:10,
autoFill:true,
matchSubset:1,
matchContains:1,
selectOnly:1
}
);
});
/script
Thanks
The list creation does exactly what I need it to but the cfoutput...
does work.
It's not giving an error but the autocomplete does nothing.
~|
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:322890
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: question on jquery..need answer pretty quickly if possible
After you open the page in your browser look at the source for the list. Make sure it doesn't say something like #mylist# :). There must be something off there. -- Ryan On Thu, May 28, 2009 at 10:01 AM, Torrent Girl torrentg...@gmail.comwrote: Yes, this is how I am formatting the list cfset myList = [ ListQualify(ValueList(myQuery.NameofField),'',',','all') ] So everything works until you change the list? Something must be wrong with the list format. Extra or missing comma. -- Ryan On Thu, May 28, 2009 at 9:39 AM, Torrent Girl torrentg...@gmail.com wrote: ~| 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:322893 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: What's the best way to handle returning two queries from a component for looping?
Don't feel bad. I never used it either. So at least there's 2 of us. -- Ryan On Thu, May 28, 2009 at 10:51 AM, Rick Faircloth r...@whitestonemedia.comwrote: Wow! That is a great function that I didn't even know existed! And how many times have a simply resorted to looping one query over another unnecessarily! And to be able to nest this multiple levels deep is great! Finally crawling out from under my rock and into the light of day! Doh! On Thu, May 28, 2009 at 11:21 AM, Jason Fisher ja...@wanax.com wrote: It's actually been there since 4.0, I believe. I know they added the groupCaseSensitive attribute in 4.5, so the group option was in place by that point. Essentially it's a way to get your output to follow your SQL groupings, when that sort of thing is necessary. So like doing a blotter style calendar, if you ORDER or GROUP the query by eventDate, you can then cfoutput group=eventDate to get your day-by-day headings, for example, and then cfoutput group=eventStartTime or whatever to do a little block for each event on the blotter ... etc. They can also be nested deeper: Company, Department, Individual Employee, for example. Jason ~| 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:322903 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: What's the best way to handle returning two queries from a component for looping?
Always lookin to save keystrokes. :) -- Ryan On Thu, May 28, 2009 at 11:50 AM, Jason Fisher ja...@wanax.com wrote: LOL, don't you just love finding something new that makes life (or at least coding) easier? ~| 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:322911 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SOT, looking for an affordable SMTP/POP3 solution
I second Google Apps. You don't want the spam traffic headache. I am slowly moving everyone off of a mail server that I manage because of spam. -- Ryan On Thu, May 28, 2009 at 7:20 PM, Casey Dougall ca...@uberwebsitesolutions.com wrote: On Thu, May 28, 2009 at 7:18 PM, Claude Schneegans schneeg...@internetique.com wrote: Hi, I'm moving my CF applications to a new dedicated server, and I need to both send messages and receive, for several users under several domains. Any suggestion ? Or SmarterMail http://www.smartertools.com/ SmarterMail Professional Edition 5.x - 50 Domains - 250 Users $299.00 ~| 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:322929 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Email via cfmail tag goes to junk folder
Can you get the email users to put your from address in their contact list? -- Ryan On Thu, May 28, 2009 at 7:56 PM, Vineetha Varghese vvargh...@pace.eduwrote: I am using cfmail to send out emails. For some users it goes to the junk mail folder. The email content has a link. When I remove the link it goes to the Inbox. From address is a valid address. Thanks, ~| 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:322933 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Could this be related to the fact that I can't delete or rename files that have been uploaded?
Someone reported the exact same problem either here or on the Railo Group yesterday. Apparently it's a new window's feature. :) -- Ryan On Thu, May 28, 2009 at 9:36 PM, Rick Faircloth r...@whitestonemedia.comwrote: I've run into this curious problem recently, since switching to Windows 7 RC, concerning deleting or renaming uploaded files. I was trying to sort out this problem through a development site when I decided to delete all the files that I had uploaded to my local system and couldn't delete through the browser. Various errors during deleting or renaming keep occuring, such as e:\images\blah.jpg can't be deleted for some unknown reason...and yes, CF says, for some unknown reason. However, after an error was thrown in the browser, I did decide to just delete all the files building up through Windows Explorer. I deleted all but one successfully, and that one I couldn't delete was the last one I uploaded. Windows Explorer threw an error stating, The action can't be completed because the file is open in jrun.exe ??? What does that mean? Is CF ( meaning jrun.exe?) hanging onto the file somehow, which would explain why I can't delete it or rename it as I normally can with CF? Is there a way to force jrun.exe to not keep the file open? Incidentally, after waiting a couple of minutes, I can delete the file normally. Anyone have any ideas or suggestions? If I can't solve this, I've got to rewrite a ton of code and develop workarounds. Thanks, Rick -- -- Ninety percent of the politicians give the other ten percent a bad reputation. Henry Kissinger ~| 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:322937 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Can I not use the name variable in cfftp getFile action?
Can't comment on using name but I do use localfile and remotefile for my variable names. I cfset them with the entire path before using the cfftp tag. (i.e cfftp localfile=#localfile# ... I was just doing this about 10 minutes ago. -- Ryan On Wed, May 27, 2009 at 8:34 PM, Rick Faircloth r...@whitestonemedia.comwrote: Why do I get the error, the system cannot find the file specified when I used this line: localFile = f:\inetpub\webroot\real_estate_data\smlc\daily_downloads\zip_files\#name# as part of this code: cfftp connection = lskdjf action = getFile passive= yes remoteFile = #name# localFile = f:\inetpub\webroot\real_estate_data\smlc\daily_downloads\zip_files\#name# failIfExists= yes timeout= 60 stopOnError = yes It seems, based on the documentation, that localFile ought to be a file that exists already on the local system. However, that doesn't make a lot of sense. There no way to know what the file name will be. And other uses of cfftp getFile have allowed a variable...just name the same name as the remoteFile. I gave it a different name. Can the localFile filename not be #name# ? Rick -- -- Ninety percent of the politicians give the other ten percent a bad reputation. Henry Kissinger ~| 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:322850 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Image Manipulation Problems with CF8/Win7
Rick, Out of curiosity: you were running production cf on xp and now you are trying to do the same on win 7? -- Ryan On Tue, May 26, 2009 at 6:37 PM, Rick Faircloth r...@whitestonemedia.comwrote: Just let me start with saying that I'm loving using Windows 7...stable, slick, *all* my software runs so much better than in XP (never did used Vista...skipped that party)...however... One issue is really getting on my nerds...whenever I try to run the same code that I've used for years and just recently before switching over to Windows 7 for uploading a new image, creating the various version I need, then deleting the original image, I get errors that CF can't delete the image for some unknown reason. Someone using Win 7 came up with a workaround...putting the image name in a database then running a scheduled task to delete later. It works, but that is a lot of extra coding, processing, etc. I was willing to go that route, if necessary, but... Now, I run into the fact that I can't immediately rename a file I just uploaded. I'm thinking this is the same basic issue as with deleting...Windows 7, perhaps with CF 8, is somehow locking down the file for a period of time (it usually with release control after a little time passes...seconds to minutes) until it allows the file to be deleted or changed. Saving an original, *unused* file's name to a db for scheduled deletion would work...a lot of trouble, but it would work. Preventing me from renaming a file immediately is a no-go. (Perhaps I can copy the file and then rename the copy) Is there anyone testing or working on Windows 7 that has run into these issues (basically one issue) and figured out what's going on and if there is a solution? It's not a problem with the code code...it's the same exact code I was previously running on XP and CF 8...only the OS has changed. I couldn't find anything on Google or other search engines, etc., that addresses this. Anyone have any ideas? Thanks, Rick -- -- Ninety percent of the politicians give the other ten percent a bad reputation. Henry Kissinger ~| 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:322810 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Image Manipulation Problems with CF8/Win7
cool, i also have a win 2003 vps but cf7 also a centos railo setup. -- Ryan On Tue, May 26, 2009 at 8:45 PM, Rick Faircloth r...@whitestonemedia.comwrote: Hi, Ryan... No my production server is a VPS with Win 2003 Server and CF 8. In my previous post, I'm referring to my dev setup. On Tue, May 26, 2009 at 7:41 PM, Ryan Letulle bayous...@gmail.com wrote: Rick, Out of curiosity: you were running production cf on xp and now you are trying to do the same on win 7? -- Ryan On Tue, May 26, 2009 at 6:37 PM, Rick Faircloth r...@whitestonemedia.com wrote: Just let me start with saying that I'm loving using Windows 7...stable, slick, *all* my software runs so much better than in XP (never did used Vista...skipped that party)...however... One issue is really getting on my nerds...whenever I try to run the same code that I've used for years and just recently before switching over to Windows 7 for uploading a new image, creating the various version I need, then deleting the original image, I get errors that CF can't delete the image for some unknown reason. Someone using Win 7 came up with a workaround...putting the image name in a database then running a scheduled task to delete later. It works, but that is a lot of extra coding, processing, etc. I was willing to go that route, if necessary, but... Now, I run into the fact that I can't immediately rename a file I just uploaded. I'm thinking this is the same basic issue as with deleting...Windows 7, perhaps with CF 8, is somehow locking down the file for a period of time (it usually with release control after a little time passes...seconds to minutes) until it allows the file to be deleted or changed. Saving an original, *unused* file's name to a db for scheduled deletion would work...a lot of trouble, but it would work. Preventing me from renaming a file immediately is a no-go. (Perhaps I can copy the file and then rename the copy) Is there anyone testing or working on Windows 7 that has run into these issues (basically one issue) and figured out what's going on and if there is a solution? It's not a problem with the code code...it's the same exact code I was previously running on XP and CF 8...only the OS has changed. I couldn't find anything on Google or other search engines, etc., that addresses this. Anyone have any ideas? Thanks, Rick -- -- Ninety percent of the politicians give the other ten percent a bad reputation. Henry Kissinger ~| 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:322813 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MySQL - How to create a category tree in a store
@will Good deal. Haven't used below but it seems the author has written a nice book about it on his site. Good luck. -- Ryan On Sat, May 23, 2009 at 2:27 AM, Will Tomlinson w...@wtomlinson.com wrote: I think I'm going to use this tool: http://nstree.riaforge.org/ I've been playing around with it. Seems fairly straightforward and does everything I need. I'm just working on what the admin interface would look like to display the entire tree so you could select multiple categories for a given product. Thanks for everyone's input. Will ~| 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:322756 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Anyone see a problem with this code? Won't execute...
You might try putting the f:\inetpub ... in double quotes. -- Ryan On Sat, May 23, 2009 at 6:27 PM, Rick Faircloth r...@whitestonemedia.comwrote: I can run this code, and see cmd.exe open in the list of services in the Task Manager, but cmd.exe closes rather quickly and there are no results from the batch file. Just wondering if anyone sees any problem with the code, itself. This was running fine on XP, but now I'm executing it on Windows 7 RC, CF 8.0.1... cfexecute name = C:\WINDOWS\system32\cmd.exe arguments = /c f:\inetpub\webroot\real_estate_data\hmls\10_hmls_batch files\load_hmls_active_photos.bat timeout = 0 /cfexecute Thanks for any feedback. Rick Ninety percent of the politicians give the other ten percent a bad reputation. Henry Kissinger ~| 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:322758 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Anyone see a problem with this code? Won't execute...
You'd have to escape them or change the outer quotes to single quotes of course. :) -- Ryan On Sat, May 23, 2009 at 7:03 PM, Ryan Letulle bayous...@gmail.com wrote: You might try putting the f:\inetpub ... in double quotes. -- Ryan On Sat, May 23, 2009 at 6:27 PM, Rick Faircloth r...@whitestonemedia.comwrote: I can run this code, and see cmd.exe open in the list of services in the Task Manager, but cmd.exe closes rather quickly and there are no results from the batch file. Just wondering if anyone sees any problem with the code, itself. This was running fine on XP, but now I'm executing it on Windows 7 RC, CF 8.0.1... cfexecute name = C:\WINDOWS\system32\cmd.exe arguments = /c f:\inetpub\webroot\real_estate_data\hmls\10_hmls_batch files\load_hmls_active_photos.bat timeout = 0 /cfexecute Thanks for any feedback. Rick Ninety percent of the politicians give the other ten percent a bad reputation. Henry Kissinger ~| 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:322759 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Anyone see a problem with this code? Won't execute...
I know for vb scripts you have to run cscript.exe and pass the path to the vbs in the arguments. -- Ryan On Sat, May 23, 2009 at 8:43 PM, Jason Fisher ja...@wanax.com wrote: Correct. cmd.exe simply opens the window which allows you to run batch files ... that's what CFEXECUTE is already doing for you. So just run this: cfexecute name=f:\inetpub\webroot\real_estate_data\hmls\10_hmls_batch files\load_hmls_active_photos.bat / Execute the batch file directly, rather than trying to go via cmd.exe ? ~| 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:322762 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: PayPal Custom Tag
I've got sample code Ryan P LeTulle On May 21, 2009, at 8:09 PM, Torrent Girl torrentg...@gmail.com wrote: That's ok thanks :) I looked and they never posted anything. Sorry about that. Slowly walks away tail tucked. G! On Thu, May 21, 2009 at 8:51 PM, Gerald Guido gerald.gu...@gmail.comwrote: ~| 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:322706 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: PayPal Custom Tag
@torrent girlDo you still need it? -- Ryan On Fri, May 22, 2009 at 8:00 AM, Ryan LeTulle bayous...@gmail.com wrote: I've got sample code Ryan P LeTulle On May 21, 2009, at 8:09 PM, Torrent Girl torrentg...@gmail.com wrote: That's ok thanks :) I looked and they never posted anything. Sorry about that. Slowly walks away tail tucked. G! On Thu, May 21, 2009 at 8:51 PM, Gerald Guido gerald.gu...@gmail.com wrote: ~| 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:322707 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: MySQL - How to create a category tree in a store
@willr u ok with setting a maximum number of levels? -- Ryan On Fri, May 22, 2009 at 10:14 AM, Will Tomlinson w...@wtomlinson.comwrote: This might be useful: http://dev.mysql.com/tech-resources/articles/hierarchical-data.html Cheers, Dave Yes, there's a lot of great info there. But it looks like a nightmare if I want to add a node under the parent. Products -baseball --gloves --bats --shin guards -golf --gloves --bags ---nike ---titleist ---ping --shoes If I want to add lacrosse between baseball and golf, that'd be a pain. Wish I could find something easier for this. Thanks, Will ~| 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:322710 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MySQL - How to create a category tree in a store
I am assuming you at least have product_id and category_id in your linking table. I think if you added a parent_id accounting for the root level you could build out your tree. Not sure of how you want to go about it but thinking out loud: 1. Query all categories at root level 2. Loop through root level and pull children (all those with a parent as that category) 3. Repeat this for the max levels 4. Pull products at each level (1,2,3,4) Basically you are only assigning one sub/category but you have the hierarchical relationship stored in the db. You would have to account for that when searching on the front end. Front end I would suggest jQuery for an accordion like effect(slidedown/up and/or fadein/out) and pull the products using the ajax or load method. -- Ryan On Fri, May 22, 2009 at 10:41 AM, Will Tomlinson w...@wtomlinson.comwrote: @willr u ok with setting a maximum number of levels? -- Ryan Yep. I could max it out at 4 levels. I had thought about building related tables, 4 of them. Thanks, Will ~| 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:322714 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MySQL - How to create a category tree in a store
Also depending on your traffic versus how often the products will get updated versus your hosting plan etc you may want to output the entire tree at the time of it being maintained on the back end rather than every time someone visits the site. Don't know your situation, just an idea if you need to limit hits on the database. -- Ryan On Fri, May 22, 2009 at 11:11 AM, Ryan Letulle bayous...@gmail.com wrote: I am assuming you at least have product_id and category_id in your linking table. I think if you added a parent_id accounting for the root level you could build out your tree. Not sure of how you want to go about it but thinking out loud: 1. Query all categories at root level 2. Loop through root level and pull children (all those with a parent as that category) 3. Repeat this for the max levels 4. Pull products at each level (1,2,3,4) Basically you are only assigning one sub/category but you have the hierarchical relationship stored in the db. You would have to account for that when searching on the front end. Front end I would suggest jQuery for an accordion like effect(slidedown/up and/or fadein/out) and pull the products using the ajax or load method. -- Ryan On Fri, May 22, 2009 at 10:41 AM, Will Tomlinson w...@wtomlinson.comwrote: @willr u ok with setting a maximum number of levels? -- Ryan Yep. I could max it out at 4 levels. I had thought about building related tables, 4 of them. Thanks, Will ~| 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:322715 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: redirect page
I always start my path(s) from the webroot. (i.e. /) In your case it appears that would be /index.cfm FYI Depending on your situation you might want to create a way to set the root path in your app in case you ever install it in a folder other than a webroot.. -- Ryan On Fri, May 22, 2009 at 11:48 AM, Pranathi Reddy rk.prana...@gmail.comwrote: Hi , I am trying to move back one directory and redirect the page to another page. eg: I am at page http:/localhost/Extradirectory/newfile.cfm and I want to redirect to the index.cfm at http:/localhost/newfile.cfm if condition satisfies. I am using cflocation to direct to another page but I am at path /inetpub/project1/Extradirectory/newfile.cfm and my .cfm file is in path /inetpub/project1/index.cfm cfif name ='David' cflocation url=index.cfm /cfif -- it throws an error says file not found. Can any one have any suggestions fro me. Thanks in Advance, Pranathi. ~| 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:322718 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: redirect page
r u sure this will work the same in all doctypes? -- Ryan On Fri, May 22, 2009 at 12:10 PM, Gonzo Rock gonzor...@gmail.com wrote: back up one directory using ../ or ../../ takes you back two directories etc. On Fri, May 22, 2009 at 9:48 AM, Pranathi Reddy rk.prana...@gmail.com wrote: Hi , I am trying to move back one directory and redirect the page to another page. eg: I am at page http:/localhost/Extradirectory/newfile.cfm and I want to redirect to the index.cfm at http:/localhost/newfile.cfm if condition satisfies. I am using cflocation to direct to another page but I am at path /inetpub/project1/Extradirectory/newfile.cfm and my .cfm file is in path /inetpub/project1/index.cfm cfif name ='David' cflocation url=index.cfm /cfif -- it throws an error says file not found. Can any one have any suggestions fro me. Thanks in Advance, Pranathi. ~| 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:322725 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Perhaps I shouldn't have done this???
Try replacing 127.0.0.1 with the external ip Ryan P LeTulle On May 22, 2009, at 11:37 AM, Rick Faircloth r...@whitestonemedia.com wrote: I was trying to set up CF for FTP operations and, following the instructions in the CFDocs, I went to Security and checked the box to enable Sandbox. (Or whatever it said...I can't get in to read it now!) And there's the problem. Since I enabled the Sandbox setting, I can't even get the CF Administator login page to show up. Going to http://127.0.0.1/cfide/administrator/index.cfm just gets me a blank page. Is that due to the Sandbox setting? And do I need to Enable Sandboxing to use CFFtp? What to do? Thanks, Rick --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- -- Ninety percent of the politicians give the other ten percent a bad reputation. Henry Kissinger ~| 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:322729 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Perhaps I shouldn't have done this???
@jochem Nice to know -- Ryan On Fri, May 22, 2009 at 12:31 PM, Jochem van Dieten joch...@gmail.comwrote: Set the sandbox security entry in neo-security.xml to false and restart cf. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| 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:322732 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: redirect page
where is ur application.cfm? -- Ryan On Fri, May 22, 2009 at 12:54 PM, Pranathi Reddy rk.prana...@gmail.comwrote: I can redirect it but have a new problem now ... I am unable to access the session variables.. I have to access the session varaibles declared in newfile.cfm. If I browse separately then I can but if I redirect and work on it it doesnt. Any ideas.. r u sure this will work the same in all doctypes? -- Ryan ~| 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:322736 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Weird query behavior
I know this doesn't solve ur issue but ... I have had a few really bad problems similar to this with text fields in the past. I almost rather store a file on my own than use a text data type. Similar to storing an image link. -- Ryan On Fri, May 22, 2009 at 3:00 PM, Justin Scott jscott-li...@gravityfree.comwrote: Exactly the same configuration? With the same settings for Unicode for query parameters and CLOB buffer? Yes, the data source configuration has all of the same settings. The really strange part is that everything has been working fine for weeks since the last code updates that we deployed, and this morning this one server just started having issues. I'll be restarting the entire server later tonight to see if that clears it up (you know, Windows...) or not. -Justin ~| 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:322744 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: redirect page
Hmmm, try cfheader instead of cflocation. Did you say which version of cf u r using? -- Ryan On Fri, May 22, 2009 at 1:17 PM, Pranathi Reddy rk.prana...@gmail.comwrote: /inetpub/project1/application.cfc /inetpub/project1/index.cfm /inetpub/project1/Extradirectory/newfile.cfm Moving from newfile.cfm to index.cfm where is ur application.cfm? -- Ryan On Fri, May 22, 2009 at 12:54 PM, Pranathi Reddy rk.prana...@gmail.com wrote: ~| 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:322745 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Nested loop problems
Has anyone else seen problems with nested loops in CF7? Outer cfloop query=blah ---Inner cfloop query =blahblah Try to use a variable from the outer query here and it is empty. I have to cfset it to another variable before entering this cfloop and then it is good 2 go. ---Inner /cfloop Outer /cfloop -- Ryan ~| 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:322748 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Nested loop problems
thx, nice post -- Ryan On Fri, May 22, 2009 at 4:44 PM, Ben Nadel b...@bennadel.com wrote: Ryan, To do that, you have to refer to the outer loop's explicit row: http://www.bennadel.com/blog/546-Referring-To-The-Proper-Row-Of-The-Outer-CFLoop-With-Nested-CFLoops-.htm This has been fixed in ColdFusion 8. -Ben -- Ben Nadel Adobe Community Expert Adobe Certified Advanced ColdFusion Developer Manager New York ColdFusion User Group http://www.bennadel.com Need ColdFusion Help? http://www.bennadel.com/Ask-Ben ~| 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:322750 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: redirect page
show me ur application.cfc -- Ryan On Fri, May 22, 2009 at 8:35 PM, Priya Koya priya23...@gmail.com wrote: I tried but it dont know ... wats wrong .. I am sing coldfusion8. On Fri, May 22, 2009 at 4:37 PM, Ryan Letulle bayous...@gmail.com wrote: Hmmm, try cfheader instead of cflocation. Did you say which version of cf u r using? -- Ryan On Fri, May 22, 2009 at 1:17 PM, Pranathi Reddy rk.prana...@gmail.com wrote: /inetpub/project1/application.cfc /inetpub/project1/index.cfm /inetpub/project1/Extradirectory/newfile.cfm Moving from newfile.cfm to index.cfm where is ur application.cfm? -- Ryan On Fri, May 22, 2009 at 12:54 PM, Pranathi Reddy rk.prana...@gmail.com wrote: ~| 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:322753 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: New Topic: Custom content based on environment.
I think it would easiest to do this within ColdFusion, like body bgcolor=#DetermineCorrectBGColor()# Or something similar with CSS: body id=#DetermineCorrectBodyID()# That function could then look at the hostname, perhaps compare it to a list of ones that should be displayed specially, and return the proper ID value. But it can be done with Apache as well. Look at the mod_ext_filter module. It looks like you could do something similar to this in the virtual hosts you want to appear differently: # this changes the body id from normal to special in this virtual host ExtFilterDefine fixtext mode=output intype=text/html cmd=/bin/sed s/body id=\normal\/body id=\special\/ Location / SetOutputFilter fixtext /Location http://httpd.apache.org/docs/2.0/mod/mod_ext_filter.html -Ryan Ian Skinner wrote: Is it possible, and if so any links to help/hints/tutorials, to have Apache server modify content before it is sent to a browser. We would like to be able to tell some virtual hosts, but not others to change the background color style. The idea being to visually distinguish the staging virtual host form the production host. Some challenges for this is that both hosts actually get there styles from the same source and much of the content is plain HTML files so the usual CF tricks are not available. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321888 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
