Re: CFFM 1.20 Released
Hey Rick, I was overjoyed to discover the ImageCFC library through your CFFM package. I'm doing a project that's on a CFMX 6.1 server, and needed an image editing solution badly. Thanks! Edward Sonny Savage On Sun, Aug 16, 2009 at 4:25 PM, Rick Root rick.r...@webworksllc.comwrote: On Sat, Aug 15, 2009 at 3:24 AM, Kevin Peppermanchorno...@gmail.com wrote: Great work Rick! No setup other than 2 paths, and its up and running on BlueDragon. Very nice. Thanks Kevin. I'm hoping to find some time to work on a cool 2.0 version that uses a lot of jQuery, and works with CFIMAGE instead of (or in addition to) ImageCFC) Rick On Sat, Aug 15, 2009 at 12:48 AM, Rick Root rick.r...@webworksllc.com wrote: So I finally got around to fixing up CFFM www.opensourcecf.com/cffm -- Rick Root New Brian Vander Ark Album, songs in the music player and cool behind the scenes video at www.myspace.com/brianvanderark ~| 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:325492 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Compare Two MySQL Databases?
I've used SQLyog and found it to be pretty impressive. It's around $100, but there's a 30-day trial that might get you through this issue: http://www.webyog.com/en/downloads.php#sqlyog Edward Sonny Savage On Tue, Jul 14, 2009 at 7:24 PM, Marie Taylore mt4yl...@yahoo.com wrote: What's the easiest quickest way to compare two MySQL Schemas (databases)? I don't need to compare the *data*... just the tables and their field definitions. My production instance is getting an error that my test instance is not. The code is identical, so I figure I must have left something out of the database updates, but going through all those tables and fields by hand will take forever. Just thought I'd see if anyone here has any tips. Thanks! MarieT ~| 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:324500 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Dynamic Form Field Validation
I'd recommend qForms for stuff like this: http://www.pengoworks.com/index.cfm?action=get:qforms On Tue, Dec 16, 2008 at 1:46 PM, Torrent Girl torrentg...@gmail.com wrote: Hello All. I need a sample of a form that validates dymnically created form fields. Specifically checkboxes and text fields all in one form. On the form a user chooses a product by selecting a checkbox. I have the syntax for this and it is working propery. I need to add another function to make sure the users enters a quantity. Here is my script: script language=javascript function checkForm() { var el = document.forms[0].elements; for(var i = 0 ; i el.length ; ++i) { if(el[i].type == checkbox) { var checkboxgroup = el[el[i].name]; var itemchecked = false; for(var j = 0 ; j checkboxgroup.length ; ++j) { if(checkboxgroup[j].checked) { itemchecked = true; break; } } if(!itemchecked) { alert(Please select a product); if(el[i].focus) el[i].focus(); return false; } } } return true; } } /script ~| 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:316815 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Dreamweaver Locking
It was my impression that Dreamweaver creates an .lck file or something... If you were using Eclipse/CFEclipse is seems like you could write an Ant script to replicate this behavior. On Thu, Dec 11, 2008 at 12:59 PM, Rob Parkhill [EMAIL PROTECTED]wrote: well Tortise SVN has a lock and release lock function, however, being the only one developing here, I just use it for Version Control. However you could look into it, I am sure that there are docs on it. HTH Rob On Thu, Dec 11, 2008 at 12:51 PM, Casey Dougall [EMAIL PROTECTED] wrote: On Thu, Dec 11, 2008 at 12:46 PM, Phillip M. Vector [EMAIL PROTECTED] wrote: What I'm asking is.. Does anyone know of any program that allows me to check in and out files on the server, but not actually use dreamweaver. I don't personally know of anyway to do that except to use Dreamweaver. ~| 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:316625 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: To anyone at UPS.com
I'd be surprised if anyone at the UPS was on this list. They don't use CF for their site. Also, if you were bringing ups.com down for minutes at a time, wouldn't it have made the news? I'm guessing that you're doing something they see as malicious and they block you for minutes at a time. On Tue, Nov 18, 2008 at 4:14 PM, Adam Churvis [EMAIL PROTECTED] wrote: Please contact me offlist at 678-361-7933. I believe I have discovered a repeatable way to bring ups.com down for minutes at a time. I will be happy to work with you to help resolve this issue. Respectfully, Adam Phillip Churvis President Productivity Enhancement ~| 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:315462 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) Flash Displaying Different in Firefox
From here: http://kb.adobe.com/selfservice/viewContent.do?externalId=tn_15523 Use the WMODE parameter to allow layering of Flash content with DHTML layers. The WMODE parameter can be 'window' (default), 'opaque', or 'transparent'. Using a WMODE value of 'opaque' or 'transparent' will prevent a Flash movie from playing in the topmost layer and allow you to adjust the layering of the movie within other layers of the HTML document. On Mon, Nov 10, 2008 at 1:01 PM, Steve LaBadie [EMAIL PROTECTED]wrote: Firefox is not displaying flash slideshow the same as IE. The flash movie is 552 x 294 and doesn't fill the space properly. My code for IE: object classid=clsid:D27CDB6E-AE6D-11cf-96B8-44455354 codebase=http://download.macromedia.com/pub/shockwave/cabs/flash/swflas h.cab#version=7,0,19,0http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0 width=552 height=294 param name=movie value=slide.swf param name=quality value=high param name=wmode value=opaque embed src=slide.swf quality=high wmode=opaque pluginspage=http://www.macromedia.com/go/getflashplayer; type=application/x-shockwave-flash width=552 height=294/embed /object If I use the entire code that flash puts in the slideshow, it fills the space properly but the dropdown navigation appears behind the slideshow. Any ideas?? script type=text/javascript AC_FL_RunContent( 'codebase','http://download.macromedia.com/pub/shockwave/cabs/flash/swfl ash.cab#version=9,0,28,0http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,28,0 ','width','552','height','294','src','slide','qu ality','high','pluginspage','http://www.adobe.com/shockwave/download/dow nload.cgi?P1_Prod_Version=ShockwaveFlashhttp://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash','movie','slide' ); //end AC code /scriptnoscriptobject classid=clsid:D27CDB6E-AE6D-11cf-96B8-44455354 codebase=http://download.macromedia.com/pub/shockwave/cabs/flash/swflas h.cab#version=9,0,28,0http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,28,0 width=552 height=294 param name=movie value=slide.swf param name=quality value=high param name=wmode value=opaque embed src=slide.swf quality=high wmode=opaque pluginspage=http://www.macromedia.com/go/getflashplayer; type=application/x-shockwave-flash width=552 height=294/embed /object /noscript Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 http://www.esu.edu [EMAIL PROTECTED] ~| 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:315037 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Regular Expression help
Typo: cfif REFindnocase(((^|\W)#badword#(\W|$)),clean_skills) On Fri, Oct 31, 2008 at 1:09 PM, Sonny Savage [EMAIL PROTECTED] wrote: cfif REFindnocase(((^|\W)#badword#(\W|$),clean_skills) On Fri, Oct 31, 2008 at 1:04 PM, Matthew Friedman [EMAIL PROTECTED]wrote: I just found an issue with this regexp cfif REFindnocase(([^a-zA-Z0-9_]#badword#[^a-zA-Z0-9_]),clean_skills) this works great if it is not the first word or only word in the string. what do I need to do to update the regexp to pick up the bad word it is the first last or only word in the string also. Thank you again for all of your help. Matt ~| 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:314687 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Regular Expression help
cfif REFindnocase(((^|\W)#badword#(\W|$),clean_skills) On Fri, Oct 31, 2008 at 1:04 PM, Matthew Friedman [EMAIL PROTECTED] wrote: I just found an issue with this regexp cfif REFindnocase(([^a-zA-Z0-9_]#badword#[^a-zA-Z0-9_]),clean_skills) this works great if it is not the first word or only word in the string. what do I need to do to update the regexp to pick up the bad word it is the first last or only word in the string also. Thank you again for all of your help. Matt ~| 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:314689 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Lines of credit or credit account online
I work in the Merchant side of the industry. You'll need a bank that backs the line of credit. Each bank is going to have its own underwriting rules. Your online app would have to do whatever it takes to satisfy those guidelines, and then give an approval based on that. Edward A Savage Jr - Sonny Senior Software Engineer Creditdiscovery, LLC I believe in getting into hot water; it keeps you clean. ~ GK Chesterton On Tue, Oct 28, 2008 at 11:25 AM, ColdFusion Developer [EMAIL PROTECTED]wrote: Hi all, I had an interesting request from a client and I'm not finding much info out there on what the client needs. Without going into too much detail (love those NDAs!), the client wants to offer instant-approval lines of credit to Web site visitors. In essence, the thinking is: visitor goes to the site, enters info on a credit app, and either gets approval for a set amount of credit or doesn't. My question: What service does the client need to approve those credit apps? A regular merchant account or something else? I've helped set up regular merchant accounts for e-commerce but have never dealt with this area before. Thanks in advance for any and all input! ~| 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:314431 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: regex and options
Cool, I wasn't aware of the \A \Z - I've always used ^ $ Like this: cfset var titleRegEx = ^(Dr|Prof|Mr|Mrs|Ms|Miss)(\.)?$ / Edward A Savage Jr - Sonny Senior Software Engineer Creditdiscovery, LLC I believe in getting into hot water; it keeps you clean. ~ GK Chesterton On Wed, Oct 15, 2008 at 2:58 PM, Richard White [EMAIL PROTECTED] wrote: Thanks Matt, i didn't think to use the \A and \Z as this was where i was getting lost, i couldn't understand how to constrain it just to those options, but your example works perfectly and i have learned something new :) thanks again richard \b is an escape sequence that, as taken from the docs: Specifies a boundary defined by a transition from an alphanumeric character to a nonalphanumeric character, or from a nonalphanumeric character to an alphanumeric character. Since you're passing in Dr|, the pipe character matches, as it is a transition from an alphanumeric character to a non-alphanumeric character. Assuming that you're wanting the title to be the only thing in the field, with the exception of a possible period at the end, try something like this: cfset var titleRegEx = \A(Dr|Prof|Mr|Mrs|Ms|Miss)(\.)?\Z / ~| 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:313955 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Solution to xmlFormat() and Restricting String Length
I have a project where I'm sending an XML string to an interface, and I'm performing xmlFormat() on the XML text values that I'm sending up. The XML elements have maximum field lengths so I'm using the left() function to constrain the values. My concern was that the left() function may cut my string in the middle of an XML entity, and thus make the text value invalid. I've written a simple solution and wanted to share it in case someone else ever ran into the same problem: reReplace(left(xmlFormat(Test '' text), 34), [^;]*$, ) This will only modify the string in the situation that there's an incomplete XML entity at the end of it. This same solution should work for htmlEditFormat() as well. Edward A Savage Jr - Sonny Senior Software Engineer Creditdiscovery, LLC I believe in getting into hot water; it keeps you clean. ~ GK Chesterton ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311639 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Connect/Create com opbject to MS Word Viewer
My guess is that the Viewer would have a different com object name. I'd recommend installing the viewer on your workstation and invoking it there. Otherwise, you'll need to install the full version of Word on the server. You can't expect consistent results otherwise. On Fri, Aug 22, 2008 at 10:58 AM, Chuck Weidler [EMAIL PROTECTED]wrote: I want to open a MS Word Document (.doc) file and get the contents of the file. The issue that I'm having is that on our server we have MS Word Viewer 2003 installed and I cannot figure out how to create or connect to this com object. The code I have works perfectly on the workstation, but I have the regular MS Office 2003 installed. So locally the creation and connection to winword.exe is great, but on the server I get the following error. The code that creates the object or connects to the existing object is below the error. Thanks in advance for any help on this issue. ERROR - Details: The cause of this exception was that: java.lang.Exception: Invalid COM object. Message: An exception occurred when instantiating a COM object. CODE - cflock name=ObjectConnectionCreation type=exclusive timeout=120 cftry cfobject type=com action=connect class=Word.application name=MyWordobj context=local cfcatch cfobject type=com action=Create class=Word.application name=MyWordobj context=local /cfcatch /cftry cfset mywordobj.visible = False /cflock ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311411 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Flummoxed bya simple query
I've seen issues surrounding ColdFusion caching table structures. To fix the problem, go into CF administrator, turn off caching for that datasource, execute your query again, and turn caching back on. On Thu, Aug 21, 2008 at 11:24 AM, Tim Claremont [EMAIL PROTECTED] wrote: The following queries all return the same recordcount (1161 Records): SELECT * FROM BASICINFO SELECT * FROM BasicInfo SELECT * FROM BaSICINFO It could be an issue with table names, since tables are actually files, but not for columns. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311376 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Creating a database with repeated information
It's generally a bad idea to specify identity values into your code, especially for ones that are auto-incrementing. If you have to move your code to another server or even re-create your data, the identity values could change which would force you to edit your code. You could just pass the State ID in the URL string when a person wants to view that page. Another method would be to have a another column in the table that holds the state abbreviation, and use that in your where clause: WHERE state_abbr = cfqueryparam value=#url.state_abbr# cfsqltype=cf_sql_varchar Using the state abbreviation would only be when you're querying for display. I would manually create records for each state and only allow editing in the administrative portion of your application. For editing purposes, your administration app could dynamically create a list of links for each state record which would pass the State ID in the url. On Mon, Aug 18, 2008 at 11:05 AM, Melissa Cope [EMAIL PROTECTED] wrote: Thanks for the welcoming answers. :) I am relatively new to ColdFusion, but I may have misstated my question; it's not the pulling information from the database I'm not sure how to do, it's the setting the database up (efficiently) in the first place. I figure each record will need five fields: the ubiquitous auto-incremented ID, the page title, the page content, then the state and the page name (to call in from the URL, like index.cfm?page=aboutstate=VA). Since all the states will have the same set of ten pages to start, it seems that one should be able to use a cfloop of insert statements. Where I get jammed up is figuring out how to tell it what state to insert in the state field. Would it need to be a long cfswitch saying if i=1 the state is AL, if i=2 the state is AK, etc.? Thanks again! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311190 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Using CFLoop to Define Variables
I know... six of one, but here's how I like to do it: cfset variables['SC x] = listElement On Mon, Aug 11, 2008 at 3:42 PM, Brian Kotek [EMAIL PROTECTED] wrote: cfset variables['SC#x#'] = listElement / will also work. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310765 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: (ot) Eclipse Question
1. Work with the code locally. 2. Synchronize to the shared folder, excluding the .project file. On Wed, Jul 30, 2008 at 10:48 AM, Dave Phillips [EMAIL PROTECTED] wrote: For those of you who use Eclipse (and I know a lot of you do) I have a simple question that I can't seem to find an answer for, and I'm hoping someone here has already dealt with it. I need to find a way to keep the .project file in a different location than where the project is pointing to. I know this sounds strange, but, unfortunately, in the environment I'm working in, we access code in a shared folder and the powers that be don't want the .project file showing up there all the time. So much so that I'm being pushed to give up Eclipse for a 'simpler' editor that doesn't do that. Any ideas? Thanks! Dave ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309934 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Client Validation + Management
In my experience, the conditions you're describing are mutually exclusive. Even requiring registration doesn't ensure that a person only answers a question once because they could create multiple accounts. It really comes down to balancing how important it is for a single answer for a single user. The more important that condition is, the more hoops you'll have to make the end-user jump through. A cookie can be deleted/rejected as you already have realized. This is also the situation where more than one user uses the same computer and browser, the second person would not be able to answer the question without clearing cookies. On Wed, Jul 23, 2008 at 10:37 AM, Simon Bailey [EMAIL PROTECTED] wrote: Hi, I have a simple scenario to tackle where a user hits a cfm page and has to answer a question, the same user must not be able to repeat this process though. (would like to avoid the user having to register any information i.e. user name or email address etc for identification). I have tried IP checks but delving deeper resulted in a heap of problems related to ensure I got the users local ip and not proxy, then HTTP_X_FORWARDED_FOR is a no no ant REMOTE_ADDR returns the same ip on different machines within a company network. I have also tried the storing a cookie on the users computer but obvious problems occur there with browsers refusing cookies or deleting them. I finally tried ClientManagement using a database and enabling in CFAdmin, but realised that this checks a users client variables in the database against cookies which once again means failure. So, is there any methods to identify a user and reject them if they have previously accessed that particular application, or accept and store that they have visited if they have not accessed the application? Thanks in advance, Simon... ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309527 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Does cfc filesize make a performance hit?
Are you storing the XML as a string or using a the native CF XML object? When working with large strings, I've obtained big speed increases by using a Java String Buffer object. On Tue, Jul 22, 2008 at 8:32 AM, Mike Kear [EMAIL PROTECTED] wrote: The logic has 3 or 4 major branches, so the total number of methods called is about a third or a quarter of the total. So the choice is to instantiate one 3000 line cfc with 107 methods only some fo which get used, against 2 or 3 smaller cfcs where al the methods get used. So does anyone have an feel for whether there is a performance hit from instantiating methods that never end up being used? On this machine JRun is bloating up to 500MB or more so the technique i'd normally use of putting the cfc into a shared scope isnt an option. We have to reduce things in memory as much as possible.On my test machine, I run this cfc on 250 records in quick succession and it brings the machine to its knees. Jrun bloats to the point where nothing else will run.I hate to think what would happen if i released this thing into the wild 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 On Tue, Jul 22, 2008 at 10:11 PM, Aaron Rouse [EMAIL PROTECTED] wrote: Even if you split it out, would the processing page not still end up calling the same amount of methods unless you could redesign the build process somehow? I sometimes wonder if speed is the ultimate goal and at any cost if it might just be better to use included files with UDFs when needed over CFCs. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309446 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: (ot) SQL 2005 Studio Express - find and replace with newline character
CHAR(13) + CHAR(10) On Fri, Jul 18, 2008 at 2:15 PM, C S [EMAIL PROTECTED] wrote: OT: SQL 2005 Studio Express - find and replace with newline character Does anyone know how to find and a character and replace it _with_ a newline using SQL Server 2005 Studio Express? For example, I would like to replace all |'s in the following string one|two|three|four|five|six So it becomes: one two three four five six There must be some special way to represent a newline in a find+replace. I just do not know the magical character(s). ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309283 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) SQL 2005 Studio Express - find and replace with newline character
You're doing a code search? I assumed you were trying to format data being returned by a query. On Fri, Jul 18, 2008 at 4:06 PM, C S [EMAIL PROTECTED] wrote: CHAR(13) + CHAR(10) Thanks, but I mean using Studio Express's find + replace option. It is such a simple thing, but it has me stumped. I have tried every combination I can think of. No joy. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309285 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: (ot) SQL 2005 Studio Express - find and replace with newline character
If you're wanting to change the formatting of existing data in a column, it could be done this way: UPDATE my_table SET list_column = replace(list_column, '|', CHAR(13) + CHAR(10)) WHERE list_column LIKE '%|%' On Fri, Jul 18, 2008 at 4:22 PM, Sonny Savage [EMAIL PROTECTED] wrote: You're doing a code search? I assumed you were trying to format data being returned by a query. On Fri, Jul 18, 2008 at 4:06 PM, C S [EMAIL PROTECTED] wrote: CHAR(13) + CHAR(10) Thanks, but I mean using Studio Express's find + replace option. It is such a simple thing, but it has me stumped. I have tried every combination I can think of. No joy. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309286 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Regex question
I, for one, am having trouble understanding what you're trying to accomplish. I could probably help you if I understood the purpose/goal of your regular expression. Assuming that you have this content loaded into a variable, you're not reading a line at a time from a file, and you're wanting to find new lines and leading white-space I'd search like this (also matches white-space at the beginning and end of the file and at the end of a line): ((^|\s*[\r\n]+)\s|\s+$) Disclaimer: I haven't tested the regex, but it should work as advertised. On Thu, Jul 17, 2008 at 11:18 AM, Will Tomlinson [EMAIL PROTECTED] wrote: Let's say I've got a chunk of source code like so: form name=frmLogin action=index.cfm?action=tomlinson.setTestForm method=post table width=45% align=left border=0 cellpadding=5 cellspacing=1 class=subHeader tr valign=middle bgcolor=ff td width=20% align=rightUsername/td td width=20% align=leftinput class=req type=text name=usrID size=20 value=#variables.frmData.usrID# //td /tr etc... So it can have almost any kind of character in it. Now, let's say I want to check the beginning for whatever, in this case, I want a match if it has a newline or carriage return at the beginning. (?i)^[\r\s]+[.\r\s\S]* With this regex i'm trying to say, look for the newline/tab/c.return at the start of the text, and allow ANYthing afterwards. I don't care what comes after, allow it. My problem is understanding the \S (non whitespace) in the 2nd []. If I remove it, I don't have a match. if I include it,I DO have a match. What is in that chunk of text that isn't being matched, that .\r\s won't match. What's the best way to say look, I don't care what comes AFTER this specific piece of the regex that matches. Allow EVERYthing. Make sense? Thanks, Will ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309239 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Regex question
If I understand correctly, this should do what you want: ^\s+ On Thu, Jul 17, 2008 at 2:56 PM, Will Tomlinson [EMAIL PROTECTED] wrote: I, for one, am having trouble understanding what you're trying to accomplish. I could probably help you if I understood the purpose/goal of your regular expression. Sonny, thanks for the help! I could't make that regex work for my particular problem. Probably because I didn't explain it well enough. It looks like it's matching if there's any spacing before characters on any line. I need to check a chunk of text and make sure it contains SOME kinda characters on the first line. There cannot be any empty spacing on the first line (c.returns,linefeeds, spaces, tabs, etc. The rest of the chunk can contain whatever, I don't care. My regex works, I just don't understand why I have to stick a \S in that 2nd range []. Thanks! Will ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309255 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) javascript problem
I use this: http://tredosoft.com/Multiple_IE You can install 3.0 through 6.0 as stand-alone. I then have IE 7 as my system install. On Fri, Jul 11, 2008 at 6:30 PM, Claude Schneegans [EMAIL PROTECTED] wrote: You might want to take a look at IE7 stand alone. I will sure do. Thanks. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308979 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: TimeOut Problems
http://www.asfusion.com/blog/entry/file-upload-with-coldfusion-flash-forms The source is even available for download. On Fri, Jul 11, 2008 at 11:24 AM, Sonny Savage [EMAIL PROTECTED] wrote: There are some flash-based upload forms out there that are suitable for larger files. I believe there are even some free ones. They solve the time-out issues and show a nice progress display. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308935 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: TimeOut Problems
There are some flash-based upload forms out there that are suitable for larger files. I believe there are even some free ones. They solve the time-out issues and show a nice progress display. On Fri, Jul 11, 2008 at 11:19 AM, Robert Harrison [EMAIL PROTECTED] wrote: OK. I think the browser may be timing out. Is there a way I can just keep refreshing the page or keep send something to the browser until the file upload completes? I looked at CFFLUSH but I can't see a way to execute it in conjunction with CFFILE. Robert B. Harrison Director of Interactive services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be . -Original Message- From: Dawson, Michael [mailto:[EMAIL PROTECTED] Sent: Thursday, July 10, 2008 10:32 PM To: CF-Talk Subject: RE: TimeOut Problems Did you try a different browser? _ From: Robert Harrison [mailto:[EMAIL PROTECTED] Sent: Thu 7/10/2008 3:43 PM To: CF-Talk Subject: RE: TimeOut Problems Not on CF8. Tried adding cfsetting requesttimeout=, but it still times out right at two minutes. Any other ideas where this may be coming from or how I can override it? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308938 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Code Scan Tool Released!
Out of curiosity, why aren't tabs allowed? I personally prefer tabs because their width can be adjusted by settings. On Thu, Jul 3, 2008 at 10:08 AM, Will Tomlinson [EMAIL PROTECTED] wrote: Hi, Will... I read your blog on your code review tool. Looks interesting. I've never used a tool like this and was wondering if you would explain exactly what it does. What does it scan for? I was basically building a pre-scan code review tool. lol Once your code is submitted here at work, the errors are emailed to the project managers. Errors don't look good. But once you submit it, it's done. There's no turning back. So why not build my own code review tool? Well I did. And it seems to work well. I tested it on a directory with 256 pages (A MG site), and it spit out 15,000 errors according to my company's standards. Yes, it took it about 5 minutes to run on my local machine, but that's fine. Will ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308521 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Code Scan Tool Released!
That's fine, I wasn't trying to start a flame war! On Thu, Jul 3, 2008 at 10:40 AM, Will Tomlinson [EMAIL PROTECTED] wrote: Out of curiosity, why aren't tabs allowed? I personally prefer tabs because their width can be adjusted by settings. On Thu, Jul 3, 2008 at 10:08 AM, Will Tomlinson [EMAIL PROTECTED] wrote: I was afraid this would become a topic of discussion. :) Ok, they just don't allow them. Can we leave it at that? lol! Will ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308528 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Code Scan Tool Released!
I use Eclipse and CFEclipse. Eclipse uses an XML-based build engine called Ant. It seems that Ant would be a perfect fit for something like what you're describing. You would be able to code however you like and then run the Ant script before committing the code. On Thu, Jul 3, 2008 at 11:10 AM, Will Tomlinson [EMAIL PROTECTED] wrote: That's fine, I wasn't trying to start a flame war! heehee... yeah, I've never started any of those on here myself AHEMMM. My company has over 150 standards we must adhere to. No tabs, no carriage returns This: if (someVar EQ 0) { Do this } Must be: if(someVar EQ 0){ Do this } That's why I've been asking these RegEx questions on the list lately. I've gotten a much better handle on them BTW. They're kind of addictive. :) Thanks sonny, Will ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308540 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) Image Rollovers
I think you've run into an infamous layout bug in IE. Try setting the width of the absolutely positioned div (class=weather). Edward A Savage Jr - Sonny Senior Software Engineer Creditdiscovery, LLC An appeaser is one who feeds a crocodile, hoping it will eat him last. ~ Sir Winston Churchill On Tue, Jul 1, 2008 at 9:19 AM, Steve LaBadie [EMAIL PROTECTED] wrote: I don't recall this being a problem in the past, but my image rollovers do not appear in IE 6 7, on or off. They work perfect in Firefox. I am using the standard code and Javascript. Any thoughts from the group. a href=# onMouseOut=MM_swapImgRestore() onMouseOver=MM_swapImage('Image28','','images/weather_on.jpg',1)img src=images/weather.jpg name=Image28 width=80 height=20 border=0/a Steve LaBadie, Web Manager East Stroudsburg University 200 Prospect St. East Stroudsburg, Pa 18301 570-422-3999 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.esu.edu http://www.esu.edu ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308367 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) Image Rollovers
My reply is in reference to what is called the IE hasLayout() rendering bug... have you tried it? On Tue, Jul 1, 2008 at 10:04 AM, Sonny Savage [EMAIL PROTECTED] wrote: I think you've run into an infamous layout bug in IE. Try setting the width of the absolutely positioned div (class=weather). ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308377 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Regex help
This RegEx will tell you if there are any spaces between the parenthesis: if\s*\(.*\s+.*\)\s*\{ Edward A Savage Jr - Sonny Senior Software Engineer Creditdiscovery, LLC An appeaser is one who feeds a crocodile, hoping it will eat him last. ~ Sir Winston Churchill On Mon, Jun 30, 2008 at 2:58 PM, Will Tomlinson [EMAIL PROTECTED] wrote: I can do just one part, but if I try to make it an either/or with a pipe, it throws me off. This works. cfset str = 'if (someKey in struct){' cfset re = 'if\s+\(' cfoutput#reFindNoCase(re, str)#/cfoutput How do I add the brackets and so it'll catch one or the other? Thanks much, Will ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308328 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Regex help
It just occurred to me that the any pattern matches should be non-greedy for matching accuracy: if\s*\(.*?\s+.*?\)\s*\{ On Mon, Jun 30, 2008 at 3:10 PM, Sonny Savage [EMAIL PROTECTED] wrote: This RegEx will tell you if there are any spaces between the parenthesis: if\s*\(.*\s+.*\)\s*\{ Edward A Savage Jr - Sonny Senior Software Engineer Creditdiscovery, LLC An appeaser is one who feeds a crocodile, hoping it will eat him last. ~ Sir Winston Churchill On Mon, Jun 30, 2008 at 2:58 PM, Will Tomlinson [EMAIL PROTECTED] wrote: I can do just one part, but if I try to make it an either/or with a pipe, it throws me off. This works. cfset str = 'if (someKey in struct){' cfset re = 'if\s+\(' cfoutput#reFindNoCase(re, str)#/cfoutput How do I add the brackets and so it'll catch one or the other? Thanks much, Will ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308330 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Regex help
Yeah... my solution has a '+' match on the space. Glad you solved it! On Mon, Jun 30, 2008 at 3:20 PM, Will Tomlinson [EMAIL PROTECTED] wrote: This RegEx will tell you if there are any spaces between the parenthesis: if\s*\(.*\s+.*\)\s*\{ I posted a solved post but don't see it yet. I can't use * because that flags it even if there's 0 spaces. I used + and it works. Thanks sonny! Will ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308335 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: submitting a form
Maybe there's an issue with the JS? Have you tried submitting the form with the same values? Same browser/OS? Edward A Savage Jr - Sonny Senior Software Engineer Creditdiscovery, LLC An appeaser is one who feeds a crocodile, hoping it will eat him last. ~ Sir Winston Churchill On Fri, Jun 27, 2008 at 2:51 PM, Claude Schneegans [EMAIL PROTECTED] wrote: A bot? No way, the form was filled by a real person, all the rest of the information in the field make sense, including the mail address of the submitter. It is a membership registration form in an association. It is possible to spoof anything in an HTTP request to your server. Of course, but not in this case. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308250 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Where Do You Put Your Error Checking Code?
I recently wrote some form validation. I the validation was done in CF but was done through an AJAX call when JS was available. I feel this is the best of both worlds. The end-user gets nice JS interaction when available and the validation is written only ONE time on the server-side where it can't be circumvented. Edward A Savage Jr - Sonny Senior Software Engineer Creditdiscovery, LLC An appeaser is one who feeds a crocodile, hoping it will eat him last. ~ Sir Winston Churchill On Fri, Jun 27, 2008 at 4:09 PM, Dominic Watson [EMAIL PROTECTED] wrote: I personally never use js for validation; I always do it server side. I make sure the database has its own validation checking (using constraints, etc) and I also check the submitted data with ColdFusion before sending it to the database. Dominic 2008/6/27 Jerry Johnson [EMAIL PROTECTED]: All of the above. The more user-friendly code and descriptions happen on the same page via js checks. The sql code typically throws a generic error. And the stuff in between is somewhere in the middle. On Fri, Jun 27, 2008 at 3:20 PM, Ian Rutherford [EMAIL PROTECTED] wrote: When you are writing your code, where do you handle error checking? Do you handle it with Javascript on the front end? With code before you hand the data to a CFC, in CFCs, in your T-SQL code? Or do you duplicate the error checking at each step along the way? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308258 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Where Do You Put Your Error Checking Code?
If the data is valid it is saved and the client is redirected. Without JS the form is submitted normally and goes through the same validation. Edward A Savage Jr - Sonny Senior Software Engineer Creditdiscovery, LLC An appeaser is one who feeds a crocodile, hoping it will eat him last. ~ Sir Winston Churchill On Fri, Jun 27, 2008 at 4:41 PM, Brad Wood [EMAIL PROTECTED] wrote: Only if you call that server-side validation a second time after the form is submitted to the server. ~Brad -Original Message- From: Sonny Savage [mailto:[EMAIL PROTECTED] I recently wrote some form validation. I the validation was done in CF but was done through an AJAX call when JS was available. I feel this is the best of both worlds. The end-user gets nice JS interaction when available and the validation is written only ONE time on the server-side where it can't be circumvented. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308260 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Case Sensitive Form Field Names
I just wanted to chime in with a related issue with CF and struct nodes. I was writing an AJAX form handler that used JSON when I discovered that case was not preserved when using dot notation on struct elements. The solution is to use quoted node names like this: structName[caseSensitiveNode] Edward A Savage Jr - Sonny Senior Software Engineer Creditdiscovery, LLC An appeaser is one who feeds a crocodile, hoping it will eat him last. ~ Sir Winston Churchill On Sun, Jun 15, 2008 at 9:44 PM, Barney Boisvert [EMAIL PROTECTED] wrote: You'd have to parse the request body manually to get the info from getHttpRequestData, as it returns a struct of headers and the raw request body. The ServletRequest object has the already-parsed data from the body, which makes it a lot simpler. cheers, barneyb On Sun, Jun 15, 2008 at 2:23 PM, Dave Watts [EMAIL PROTECTED] wrote: Probably a lost cause but does anyone know of any method(s) to preserve the case of form field names through a POST? I know you already got a useful answer, but you can probably do this using the CF function GetHttpRequestData. Dave Watts, CTO, Fig Leaf Software ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307559 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Case Sensitive Form Field Names
I just realized that my example wasn't very clear. Hope this is a little better: cfset structName = structNew() cfset structName[caseSensitiveNode] = Node name will retain case cfset structName.caseInsensitiveNode = Node name will be all uppercase ul cfloop collection=structName item=nodeName cfoutputlistrong#nodeName#:/strong #structName[nodeName]#/li/cfoutput /cfloop /ul On Mon, Jun 16, 2008 at 12:37 PM, Sonny Savage [EMAIL PROTECTED] wrote: I just wanted to chime in with a related issue with CF and struct nodes. I was writing an AJAX form handler that used JSON when I discovered that case was not preserved when using dot notation on struct elements. The solution is to use quoted node names like this: structName[caseSensitiveNode] Edward A Savage Jr - Sonny Senior Software Engineer Creditdiscovery, LLC An appeaser is one who feeds a crocodile, hoping it will eat him last. ~ Sir Winston Churchill ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307560 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Comparing 2 different chunks of text
Since your are adept with Java, have you done anything like that in Java? It's pretty trivial to use Java objects in CF. On Thu, May 29, 2008 at 5:46 AM, Abigail Coker [EMAIL PROTECTED] wrote: Also, I should clarify... Below I stated that it didn't perform to well when doing thousands of long string compares. That is only half true. It is slower in CF7, but when I ran it on CF8 it KICKED BUTT. I'm talking, a 3 minute page load reduced down to 13 seconds on a SLOWER server. Go CF8! ~Brad Thanks a million Brad...and guys I didn't mean to start the 3rd world war :-)..I'm really new to the CF world (8 months) having coded in Java for the past 3 years altogether I'm a new programmer, as far as web apps goes I think CF rocks and this community has to be the best for CF, it was recommended by a colleague and I'm glad he did... ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306234 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Checking for duplicates in list being imported
You you using a data loader native to the db, or are you inserting the records one at a time? Native loaders generally have a way to prevent duplicates. If you're inserting one at a time, just do a query first to see if it exists. You'll definitely want an index on that column, possibly even a unique index. On Thu, May 22, 2008 at 4:10 PM, Les Mizzell [EMAIL PROTECTED] wrote: I've got an application that a client uses to import email list from Excel spreadsheets into a database for use to send e-newsletters to specific groups. The database has grown quite large, and when importing list to specific group at this point, they're forgetting if a particular email address had already been added, and needs something that prevents duplicates from being added to the list. I can think of a couple of clumsy (resource intensive) ways to check the addresses being imported against what's already in the database, but there must be an optimal way to do it. cf_check_duplicates_before_insert ?? Suggestions? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305947 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: two lists - matching any element
cffunction name=listsHaveMatch returntype=boolean output=false description=Returns true if an item in list one matches an item in list two. cfargument name=list1 type=string required=true cfargument name=list2 type=string required=true cfargument name=delimiters type=string default=, cfargument name=isCaseSensitive type=boolean default=false cfset var lcv = cfif NOT arguments.isCaseSensitive cfloop list=#arguments.list1# delimiters=#arguments.delimiters# index=lcv cfif listFindNoCase(arguments.list2, lcv, arguments.delimiters) GT 0 cfreturn true /cfif /cfloop cfelse cfloop list=#arguments.list1# delimiters=#arguments.delimiters# index=lcv cfif listFind(arguments.list2, lcv, arguments.delimiters) GT 0 cfreturn true /cfif /cfloop /cfif cfreturn false /cffunction On Thu, May 22, 2008 at 12:14 PM, Dominic Watson [EMAIL PROTECTED] wrote: Hey Larry, had the same thought as me ;) However, containsAll() isn't what he's after - he needs containsAny() which doesn't exist. Shame really. Dominic 2008/5/22 Larry Lyons [EMAIL PROTECTED]: Jeff, Take advantage of CF sitting on top of Java. Convert the lists to arrays using listToArray. Then use the containsAll() method of java list to see if all the elements of one array are present in another array. Using your example, cfset list1 = listToArray(700,300,400,1100,2200) / cfset list2 = listToArray(300,400) / cfset foo = list1.containsAll(list2) / !--- reset dump variable in request scope --- cfset request.cfdumpinited = false / cfdump expand=true label=foo var=#foo# / cfabort / hth, larry Hi folks, I'm not 100% sure on all the list functions in CF.. so I'm hoping this group can give me a little guidance. Ideally, I'm looking for a UDF that takes in two LISTS and returns a BOOLEAN. True if ANY element in list 2 is in list 1. False if NO element in list 2 is in list 1. I tried to search cflib.org and also looked at the avail functions for lists. It needs to be optimized, so ideally breaking out of the UDF once the first match is found. EXAMPLES: list1 = 5,8,2,20 list2 = 4,6 result = FALSE list1 = 700,300,400,1100,2200 list2 = 300,400 result = TRUE, but breaking out of comparisions after first find (300) list1 = 1 list2 = 3,4,6,1,2,11,100,101,102,103,104 result = TRUE, but breaking out of comparisions after element 4 = (1) appreciate any guidance! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305906 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: ms sql's enum
MS SQL has a BIT datatype that is good for using as booleans. While the ENUM type in MySQL is cool, the real (normalized) way to do enumerated types is by using another table and storing a foreign key. On Wed, May 21, 2008 at 10:59 AM, Chad Gray [EMAIL PROTECTED] wrote: MySQL has the enum datatype that you can set to Yes/No, True/False etc. What is MS SQL's version of this datatype? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305823 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) Radio Button Matrix
Hmmm seems like a sorter might be the way to go there. I could probably figure out the JavaScript, but it's not a familiar UI element. Familiarity in the UI makes them feel more user friendly. Have you looked at any of the YUI controls? On Thu, May 15, 2008 at 6:25 PM, Les Mizzell [EMAIL PROTECTED] wrote: Can somebody point me to a good tutorial to build a small radio button matrix (just 3 x 3) What I need is a matrix like: 1st 2nd 3rd Tom O O O Bob O O O Mom O O O where you can have only one button checked in a row *or* column. How's that? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305528 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) Radio Button Matrix
Your request is kinda' light on the details... maybe links to the javascript ones so we can see what you mean? On Thu, May 15, 2008 at 3:59 PM, Les Mizzell [EMAIL PROTECTED] wrote: Can somebody point me to a good tutorial to build a small radio button matrix (just 3 x 3) So far, I've not turned up anything that seems to work well cross browser (all javascript so far...) TIA ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305370 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Distinct on just ONE column in a CFQUERY
If you don't care about the case where first and last names differ, I'm not sure why you're including them in the query, but you can try this: SELECT atty_id, MAX(first_name) AS first_name, MAX(last_name) AS last_name, MIN(COALESCE(atty_rank, )) AS atty_rank FROM get_attypa WHERE isACTIVE = 'y' GROUP BY atty_id ORDER BY atty_rank, last_name, first_name On Wed, May 14, 2008 at 3:52 PM, Dave Watts [EMAIL PROTECTED] wrote: DISTINCT works across all the columns, so if first names are different you'll get two rows back for a given atty_id. OK - how to force only *one* unique ID per returned results? You can't. How would it show the additional results? You can, however, use the GROUP attribute of the CFOUTPUT tag so that you don't show the ID multiple times. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305275 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: or in a cfcase statement
cfcase value=X,Y' On Tue, May 6, 2008 at 12:08 PM, Brad Wood [EMAIL PROTECTED] wrote: You can compare the value being switched upon to multiple case values. Syntax cfcase value = value|delimited set of values delimiters = delimiter characters If you want some sort of additional Boolean logic then cfswitch is not the tool for that... cfif and cfelseif is what you need. ~Brad -Original Message- From: Scott Stewart [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 06, 2008 11:09 AM To: CF-Talk Subject: or in a cfcase statement Hey All, Can an or be used in a CFCase statement IE: cfcase value=X or Y or something like this. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304801 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 XML and CF isDefined
cfloop from=1 to=#ArrayLen(XMLContent.GSP.RES.R)# index=idx cfif structKeyExists(XMLContent.GSP.RES.R[idx], T) On Thu, May 1, 2008 at 2:44 PM, Dave Watts [EMAIL PROTECTED] wrote: howdy all, so I've got a little bug I'm having a tough time with. I'm new to manipulating XML in CF. It's pretty easy however, but I've run into a problem I'm not sure how to solve. The Google box returns an XML structure that I've processed. But from time to time, I find that the 'T' element (Title) is not returned. And it errors out. I tried: cfloop from=1 to=#ArrayLen(XMLContent.GSP.RES.R)# index=idx cfif isDefined(XMLContent.GSP.RES.R[idx].T) But I get error: Element T is undefined in a Java object of type class coldfusion.xml.XmlNodeMap referenced as If I do: cfif isDefined(XMLContent.GSP.RES.R) It works fine but that's not what I need. Thoughts? Should I place the current index node into a var and then test? First, I'm very surprised that you're seeing R elements that don't have a child T. Can you confirm that these are actually what you're getting back from your GSA or Mini? Second, you can't test for the existence of array elements with IsDefined. But you can store the array element within a variable, then test for the existence of members of that variable: cfloop ... cfset thisR = XMLContent.GSP.RES.R[idx] cfif IsDefined(thisR.T) /cfloop Don't forget, you can also use XPath expressions from within CF. You might find that an easy alternative to accessing elements directly, although to be honest I haven't tried that myself from within CF while using Google search result XML. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304609 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfqueryparam issue
This might be one for Adobe support, that's certainly odd. On Wed, Apr 30, 2008 at 1:52 PM, Leitch, Oblio [EMAIL PROTECTED] wrote: Oh yeah, that would help, wouldn't it? It states: java.lang.Short cannot be cast to java.lang.Byte -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 30, 2008 1:44 PM To: CF-Talk Subject: Re: cfqueryparam issue What's the error message? On Wed, Apr 30, 2008 at 10:41 AM, Leitch, Oblio [EMAIL PROTECTED] wrote: I have a list of small numbers in a variable that I'm passing as an IN () statement to a query-of-a-query. When I cast it as a TINYINT, it fails. Any idea why? This works: WHERE [id] IN (cfqueryparam value=7,0,5,6 cfsqltype=CF_SQL_SMALLINT list=Yes) This fails: WHERE [id] IN (cfqueryparam value=7,0,5,6 cfsqltype=CF_SQL_TINYINT list=Yes) -- Barney Boisvert [EMAIL PROTECTED] http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304533 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Compare digits as strings not integers.
Using compare() and compareNoCase() is really the right way. My only gripe is that the returned value isn't very intuitive. On Mon, Apr 28, 2008 at 5:57 PM, Bobby Hartsfield [EMAIL PROTECTED] wrote: Just stick an alpha character in front of them when comparing or compare len AND value. ..:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Monday, April 28, 2008 4:08 PM To: CF-Talk Subject: Compare digits as strings not integers. CFSET oldcompany = '033' CFSET newcompany = '0033' How would one compare these as strings and get a NOT equal result rather then integers resulting in an equal result? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304390 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfobject and components best practices
Only the functions you explicitly call are executed. Creating an object is copying and instance of that component to memory. This is useful for maintaining the object's state. When I write CFCs that are actually intended for use as objects and aren't simply collections of functions, I create an init() function and call that when creating an object. Using CreateObject() instead of cfobject makes it easy to call the init in one line. To extend your example, I'd do it this way: cfset reviews = CreateObject(component, #application.cfcpath#reviews).init() cfset qGetTopTenTitle = reviews.getTopTenTitle(url.Campus) On Thu, Apr 24, 2008 at 3:25 PM, John Ahlen [EMAIL PROTECTED] wrote: Hello All, I've gotten into the habit of beginning a page by creating an object: cfobject component=#application.cfcpath#reviews name=reviews Below that, I use any number of cfinvokes thusly: cfinvoke component=#reviews# method=getTopTenTitle campus = #URL.Campus# returnvariable=qGetTopTenTitle In the component I'll have functions that are not called by the page. They are used by other pages. When I turn a component into an object am I needlessly calling all the functions inside that component and is this not a good idea? Thanks in advance, John ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304204 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfobject and components best practices
Two things I left out: 1. The init() function needs to have cfreturn this at the end. 2. When calling functions, you can used named arguments. The last line could be rewritten as: cfset qGetTopTenTitle = reviews.getTopTenTitle(campus=url.Campus) or cfset qGetTopTenTitle = reviews.getTopTenTitle(campus:url.Campus) On Thu, Apr 24, 2008 at 4:36 PM, Sonny Savage [EMAIL PROTECTED] wrote: Only the functions you explicitly call are executed. Creating an object is copying and instance of that component to memory. This is useful for maintaining the object's state. When I write CFCs that are actually intended for use as objects and aren't simply collections of functions, I create an init() function and call that when creating an object. Using CreateObject() instead of cfobject makes it easy to call the init in one line. To extend your example, I'd do it this way: cfset reviews = CreateObject(component, #application.cfcpath#reviews).init() cfset qGetTopTenTitle = reviews.getTopTenTitle(url.Campus) -- Edward A Savage Jr - Sonny Senior Software Engineer Creditdiscovery, LLC I was gratified to be able to answer promptly. I said I don't know. ~ Mark Twain ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304209 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Parse phone number characters - almost there ...
I'd recommend removing everything but the digits, and regex is perfect for that: cfset phone = reReplace(phone, [^0-9], , all) Store the resulting value, and then format it as you desire when displaying. On Tue, Apr 22, 2008 at 3:34 AM, Azadi Saryev [EMAIL PROTECTED] wrote: rereplace() is looking for a regexp, while you are giving it a literal string to find and replace... either use replace() function, or give rereplce() a regexp to match the characters you want to remove. something like rereplace(phone, [\(\)\.-], , all) Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ [EMAIL PROTECTED] wrote: I've got different phone number formats due to an csv import. I'm trying to remove phone number formating from the database and just have the numbers. As I parse through my phone numbers from a query, this code is throwing errors. I'm trying to get rid of ')', '(', '.' and '-' cfset phone = rereplace(phone, (, , all) / cfset phone = rereplace(phone, ), , all) / cfset phone = rereplace(phone, ., , all) / cfset phone = rereplace(phone, -, , all) / Thanks D ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303962 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfmail... and fonts.
Your last question is the answer. Plain text cannot specify fonts. It's completely up to the mail client. On Fri, Apr 18, 2008 at 1:46 PM, Ian Skinner [EMAIL PROTECTED] wrote: Is is possible to designate a specific font, such as Courier or a generic mono-space font, for plain messages sent with cfmail..., or any mailer for that matter? Or does this concept only apply for HTML formated messages? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303767 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: default font size for a page
I don't use cf8 'cause my company doesn't want to buy it. Most of our servers are still 6.1. On Wed, Apr 16, 2008 at 6:59 PM, Don L [EMAIL PROTECTED] wrote: I haven't used CF8 and all the new goodness that uses the YUI libraries. I've simply included the libraries explicitly as needed by downloading their package. On Wed, Apr 16, 2008 at 4:37 PM, D Out of curiosity, you didn't use cf8, to wait till 'dust' is over? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303713 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: default font size for a page
One thing I've found extremely useful is CSS reset templates. They essentially create a level playing field for the main browsers. Yahoo! has one in their YUI package, and there are some available from others as well. The Yahoo! one sets a default size and then recommends using percentages to specify font sizes of other elements. On Wed, Apr 16, 2008 at 3:14 PM, Don L [EMAIL PROTECTED] wrote: Should be font-size:smaller; rather than small Not too sure if I understand you. Can't you just wrap the home page content in a div? div style=font-size:smaller;Or 80%, or 8pt;/div This does work in IE6, IE7 and FF. I've put up a really trivial page at http://www.itworldcanada.info/test/t2.htm to show this. Yeah, thanks, I used 10pt works all right as well. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303594 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: default font size for a page
I haven't used CF8 and all the new goodness that uses the YUI libraries. I've simply included the libraries explicitly as needed by downloading their package. On Wed, Apr 16, 2008 at 4:37 PM, Don L [EMAIL PROTECTED] wrote: One thing I've found extremely useful is CSS reset templates. They essentially create a level playing field for the main browsers. Yahoo! has one in their YUI package, and there are some available from others as well. The Yahoo! one sets a default size and then recommends using percentages to specify font sizes of other elements. On Wed, Apr 16, 2008 at 3:14 PM, D Well, first of all, good to know and thanks. I used quite a bit of the new ajax related tags/functions, which uses YUI, Ext libraries and from Firebug, I seem to remember, they uses CSS from these libraries as well, but not including reset templates? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303623 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Pagination CFC: How to pass search parameters?
Is it possible to append a string to the URL with the search params? On Sun, Apr 13, 2008 at 11:22 PM, Rick Faircloth [EMAIL PROTECTED] wrote: Hi, all (and Nathan in particular)... I've moved from using a typical Previous / Next pagination to using Nathan Strutz' Pagination.cfc http://www.dopefly.com/projects/pagination/pagination_cfc_documentation.cfm It works very well! However, I've realized a problem, not with the cfc, but with not using my Previous / Next images, which were actually form submit buttons and would submit my form fields both visible and hidden when they were clicked. Now that I'm using the Pagination.cfc, I have the text links that are created, but no buttons to use for submitted the form search parameter fields. How can I pass search parameters when the links of the pagination are clicked? I'm sure I'm just not seeing something that's a simple solution. Suggestions, anyone? Thanks, Rick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303281 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Pagination CFC: How to pass search parameters?
What I've done is loop over all the search form fields (that have been param'ed) and create a url string variable that gets used by links. One thing that simplified it was that I was using fusebox and all the form and url variables end up in the attributes scope. On Mon, Apr 14, 2008 at 2:05 PM, Rick Faircloth [EMAIL PROTECTED] wrote: I thought about that, but I usually integrate the search parameter form into the results page. In this case, the user would intuitively select an option from, say a dropdown to select a location, then click the a pagination link. The only way it would work would be to separate my search parameter form from the results page, which I'd like to avoid. However, I'm keeping that as an option if the links should fail. As I think about it, I would probably still have to separate my search parameter form from the search results whichever approach I take. Perhaps I can utilize some javascript to grab the form variables upon change and then either use form variables or URL variables. Thoughts? Rick -Original Message- From: Josh Nathanson [mailto:[EMAIL PROTECTED] Sent: Monday, April 14, 2008 12:25 PM To: CF-Talk Subject: Re: Pagination CFC: How to pass search parameters? Rick, Why not create a session variable to hold the search parameters? Then if the form is re-submitted, i.e. the search parameters are changed, you can re-assign the new form values to the session variables. Then you would reference the session variables rather than the form variables in your query. This way you don't have to mess with the paging links' url params at all. -- Josh ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303337 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Tutorial on creating this pagination?
Have you looked at this? http://paginationcfc.riaforge.org/ On Thu, Apr 10, 2008 at 5:15 PM, Rick Faircloth [EMAIL PROTECTED] wrote: Anyone know of a tutorial that would teach me how to setup pagination that would work like this: Previous 1 2 ... 8 9 [10] 11 12 ... 39 40 Next - Previous Link - Next Link - First one or two pages - Last one or two pages - Current Page (represented by the [10]) - Several links surrounding the current page I've always used the basic Previous Next pagination, but I'd like to advance that. I looked online, but haven't found anything with all the specs, or with enough of a start that I could figure the rest out. I checked into a javascript approach, but dumping all the records, perhaps thousands, would be a little much for the client, I think. I'd be pulling records from a MySQL database. Thanks, Rick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303142 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfForm binding text field, visible to checkbox
Just a guess... {ul3R_SSsp.text + ul4_SSsp.text + ul3r4x_SSsp.text + q4_0_SSsp.text} On Fri, Apr 4, 2008 at 1:37 PM, Paul Ihrig [EMAIL PROTECTED] wrote: sweet cfinput type=checkbox name=vm_O label=Others / cfinput type=text name=vm_Other label=Please specify visible={vm_O.selected}/ from: http://www.asfusion.com/blog/entry/binding-checkboxes-in-flash-forms now... how do i calculate results of text field on the fly? cfinput type=text name=StainlessSteel_totalsp bind={ul3R_SSsp.text}+{ul4_SSsp.text}{ul3r4x_SSsp.text}+{q4_0_SSsp.text} / that just puts + between returned results.. like 3+2+5+1 not 11 i have tried ++ '++' ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302743 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfForm binding text field, visible to checkbox
OK, it was an issue of value typing. This works: cfform format=flash width=500 cfinput name=FieldOne type=text label=Field One width=60 / cfinput name=FieldTwo type=text label=Field Two width=60 / cfinput name=FieldTotal type=text label=Field Total bind={(FieldOne.text * 1) + (FieldTwo.text * 1)} width=60 / /cfform I don't know ActionScript very well, so there may be a better way of casting the values. The total field with show 'NaN' if the other fields are empty or not numeric. On Fri, Apr 4, 2008 at 1:47 PM, Paul Ihrig [EMAIL PROTECTED] wrote: i tried that too man.. On Fri, Apr 4, 2008 at 1:44 PM, Sonny Savage [EMAIL PROTECTED] wrote: Just a guess... {ul3R_SSsp.text + ul4_SSsp.text + ul3r4x_SSsp.text + q4_0_SSsp.text} On Fri, Apr 4, 2008 at 1:37 PM, Paul Ihrig [EMAIL PROTECTED] wrote: sweet cfinput type=checkbox name=vm_O label=Others / cfinput type=text name=vm_Other label=Please specify visible={vm_O.selected}/ from: http://www.asfusion.com/blog/entry/binding-checkboxes-in-flash-forms now... how do i calculate results of text field on the fly? cfinput type=text name=StainlessSteel_totalsp bind={ul3R_SSsp.text}+{ul4_SSsp.text}{ul3r4x_SSsp.text}+{q4_0_SSsp.text} / that just puts + between returned results.. like 3+2+5+1 not 11 i have tried ++ '++' ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302751 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfForm binding text field, visible to checkbox
Hello Paul, turns out that ActionScript has a Number() function which does what you needed. I've never used flash forms before, so this may seem like a silly question, but when I display this form the first two fields are empty rather than having the value of zero. Why is that? cfform format=flash width=500 cfinput name=FieldOne type=text label=Field One validate=float value=0 width=60 cfinput name=FieldTwo type=text label=Field Two validate=float value=0 width=60 cfinput name=FieldTotal type=text label=Field Total enabled=false bind={Number(FieldOne.text) + Number(FieldTwo.text)} width=60 /cfform On Fri, Apr 4, 2008 at 3:08 PM, Paul Ihrig [EMAIL PROTECTED] wrote: NM. just put in default value to 0 that fixed it... sw33t! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302765 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: qforms: transferring values from one select to another
objForm.products_selected.setValue('#valueList(getRelated.product_idfk)#'); On Fri, Apr 4, 2008 at 5:47 PM, Mike Little [EMAIL PROTECTED] wrote: dan i think i have found my problem!!! in the script, the following is not being recognised... objForm.products_selected.setValue(valueList(getRelated.product_idfk)); however if i put in some test values... objForm.products_selected.setValue('1,2'); it works! very sweet. i have tried wrapping the line above in cfoutputs but nothing. (almost there - woohoo !!) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302767 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFDIRECTORY NUL bug
I read about certain names that can't be used for windows directories and file names but I can't seem to locate the information right now. I had to do with legacy DOS commands or something. On Wed, Apr 2, 2008 at 4:22 PM, Dave Francis [EMAIL PROTECTED] wrote: It seems to be a Windows problem: at least on XP I can't create/rename a folder to NUL doing it manually -Original Message- From: Sung Woo [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 02, 2008 2:49 PM To: CF-Talk Subject: CFDIRECTORY NUL bug Is it just me or does this produce an error for everyone? cfdirectory action=create directory=C:\NUL\ It's the word NUL that's giving CF 7.0.2 the heebie-jeebies. It's not able to create it. Any workarounds? - Sung ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302529 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFDIRECTORY NUL bug
Found it! http://rohit11.blogspot.com/2006/04/con-prn-aux-nul.html On Wed, Apr 2, 2008 at 4:18 PM, Sonny Savage [EMAIL PROTECTED] wrote: I read about certain names that can't be used for windows directories and file names but I can't seem to locate the information right now. I had to do with legacy DOS commands or something. On Wed, Apr 2, 2008 at 4:22 PM, Dave Francis [EMAIL PROTECTED] wrote: It seems to be a Windows problem: at least on XP I can't create/rename a folder to NUL doing it manually -Original Message- From: Sung Woo [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 02, 2008 2:49 PM To: CF-Talk Subject: CFDIRECTORY NUL bug Is it just me or does this produce an error for everyone? cfdirectory action=create directory=C:\NUL\ It's the word NUL that's giving CF 7.0.2 the heebie-jeebies. It's not able to create it. Any workarounds? - Sung ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302530 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Determining The Server's IP
I was wondering if there are some values I can look at that reliably hold the server's IP address. The CGI variables seem to show the same thing as what's in the address bar. Thanks! -- Edward A Savage Jr - Sonny Senior Software Engineer Creditdiscovery, LLC I was gratified to be able to answer promptly. I said I don't know. ~ Mark Twain ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302120 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: page footer in onrequestend and cfpod
Are the pods floated in a containing div? If so, do you set a width on that div? If so, add overflow: hidden; to the style for the container div. Alternately, try adding clear: both; to the style declaration for the footer. On Wed, Mar 26, 2008 at 8:38 AM, Will Swain [EMAIL PROTECTED] wrote: Hi Dave, I've never used this approach before. Normally I would do this with css, but I'm having problems getting the footer to appear correctly cross browser with the dynamically extending pods - it tends to sit behind them if the pod content is too high. I'd be open to any css based solutions for handling this instead. We don't have any cfcontent generated pages in the site - and nothing else that could cause problems that I can think of, other the use of cfpod as I mentioned and I've found a work around for that - all my pods are in a single subfolder and the templates all have a -pod suffix, so I'm looking for the existence of that and not displaying the footer if it's there. Thanks Will -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: 26 March 2008 12:35 To: CF-Talk Subject: RE: page footer in onrequestend and cfpod I'm trying to include a page footer in onRequestEnd in my Application.cfc. This is generally a bad idea. You generally shouldn't generate HTML page output from Application.cfc/cfm. You're typically going to run into at least one case in your app where you don't want to automatically generate page content - non-HTML content generated with CFCONTENT, for example. I would recommend that you implement an alternate approach. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302099 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Date Range Search Problem - when it's integers stored and not dates
Lez, this has been asked, but not answered. What do the zeros mean? Do they indicate a date range? Does 2007.0.0 mean the entire year of 2007? Does 2007.10.0 mean the entire month of October in 2007? Does 0.0.0 mean always? If so, I'd create two date columns, begin_dt and end_dt. I'd then write SQL scripts to populate those columns. On Tue, Mar 25, 2008 at 9:51 AM, Claude Schneegans [EMAIL PROTECTED] wrote: Ok, how about this, a bit ugly, but should work on any database: WHERE (YEAR #form.from_y# OR (YEAR = #form.from_y# AND (MONTH = 0 OR (MONTH = #form.from_m# AND (DAY = 0 OR DAY = #form.from_d#) AND (YEAR #form.to_y# OR (YEAR = #form.to_y# AND (MONTH = 0 OR (MONTH = #form.to_m# AND (DAY = 0 OR DAY = #form.to_d#) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302012 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Aptana / css issue
It's a Microsoft-only, non-standard, style declaration. It will never be a css standard because it's dependent on DirectX. I'd personally prefer the errors to remain because they are real errors. If that error is breaking the parser for the rest of your style sheet, Aptana might want to know so they can make their parser more robust. A solution that many people take is to put all the non-standard IE style into a separate style sheet and have CF decide when to use the style sheet based on the User Agent. On Fri, Mar 21, 2008 at 6:42 AM, ColdFusion [EMAIL PROTECTED] wrote: I have the following within a CSS declaration but Aptana displays the following validation issue: filter: progid:DXImageTransform.Microsoft.Shadow (color=gray,direction=135); Aptana error: attempt to find a semi-colon before the property name. add it Property progid doesn't exist unrecognized:DXImageTransform.Microsoft.Shadow(color=gray,direction=135); Parse error - Unrecognized Any ideas on how to solve this besides not using the declaration? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301745 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: many JS libraries are out there, which one for CF8 is the question.
I'm surprised how little love the YUI project is getting. I've used it extensively for production sites and found it to be very good. The BSD license allows you to use it any way you like without worry. For the same reason I don't worry about a MS buyout, I believe the project will continue regardless. YUI also has documentation on using their libraries in an ARIA compliant fashion. http://search.yahoo.com/search?vs=developer.yahoo.comfr=ush-mywebva=aria On Thu, Mar 20, 2008 at 12:24 PM, Sandra Clark [EMAIL PROTECTED] wrote: If accessibility is at all an issue for you, only two libraries implement the ARIA spec right now that I am aware of: Dojo and Google-axsjax are the only ones that I have been able to find. There used to be a plugin for Jquery (JARIA) and while I understand that the plugin will be incorporated into JQUERY at some point, it isn't yet (so far as I can determine). Sandra Clark = http://www.shayna.com Training and Consulting in CSS and Accessibility Team Fusebox -Original Message- From: Ali [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 19, 2008 10:50 PM To: CF-Talk Subject: many JS libraries are out there, which one for CF8 is the question. Hi: I decided to use a JS library/framework to enhance the UI of my sites. I googled a lot and found out that there are many of them. I make a short list here:(thanks to google and wikipedia) Google Web Toolkit, AJILE, Backbase, CssQuery, Dojo, Toolkit, mootools, Ext, JQuery, MochiKit, Moo.fx, OpenLink AJAX Toolkit, Prototype, Qooxdoo, Rialto Toolkit, Rico, script.aculo.us, SmilScript, Spry framework, Yahoo! UI Library These where what I found. I believe there are some more out there that I couldn't find. My question is: Which one will help me as a beginner in using such libraries/frameworks plus has a future plus has good compatibility with Coldfusion. I know that CF8 has some EXT 1.0 integrations and YUI and I heard a lot about Jquery. But I really appreciate it if you write you opinions about each of the libraies I listed. What I really need is a simple, light and powerful one that gives me better client-side effects and form options(for example validation). Thanks Ali ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301656 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: many JS libraries are out there, which one for CF8 is the question.
Also, Yahoo! uses the YUI libraries for their own sites. On Thu, Mar 20, 2008 at 1:00 PM, Sonny Savage [EMAIL PROTECTED] wrote: I'm surprised how little love the YUI project is getting. I've used it extensively for production sites and found it to be very good. The BSD license allows you to use it any way you like without worry. For the same reason I don't worry about a MS buyout, I believe the project will continue regardless. YUI also has documentation on using their libraries in an ARIA compliant fashion. http://search.yahoo.com/search?vs=developer.yahoo.comfr=ush-mywebva=aria On Thu, Mar 20, 2008 at 12:24 PM, Sandra Clark [EMAIL PROTECTED] wrote: If accessibility is at all an issue for you, only two libraries implement the ARIA spec right now that I am aware of: Dojo and Google-axsjax are the only ones that I have been able to find. There used to be a plugin for Jquery (JARIA) and while I understand that the plugin will be incorporated into JQUERY at some point, it isn't yet (so far as I can determine). Sandra Clark = http://www.shayna.com Training and Consulting in CSS and Accessibility Team Fusebox -Original Message- From: Ali [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 19, 2008 10:50 PM To: CF-Talk Subject: many JS libraries are out there, which one for CF8 is the question. Hi: I decided to use a JS library/framework to enhance the UI of my sites. I googled a lot and found out that there are many of them. I make a short list here:(thanks to google and wikipedia) Google Web Toolkit, AJILE, Backbase, CssQuery, Dojo, Toolkit, mootools, Ext, JQuery, MochiKit, Moo.fx, OpenLink AJAX Toolkit, Prototype, Qooxdoo, Rialto Toolkit, Rico, script.aculo.us, SmilScript, Spry framework, Yahoo! UI Library These where what I found. I believe there are some more out there that I couldn't find. My question is: Which one will help me as a beginner in using such libraries/frameworks plus has a future plus has good compatibility with Coldfusion. I know that CF8 has some EXT 1.0 integrations and YUI and I heard a lot about Jquery. But I really appreciate it if you write you opinions about each of the libraies I listed. What I really need is a simple, light and powerful one that gives me better client-side effects and form options(for example validation). Thanks Ali ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301657 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Visual Ajax IDE?
Aptana += 1; On Thu, Mar 20, 2008 at 2:21 PM, Chris Jordan [EMAIL PROTECTED] wrote: Aptana = Aptana + 1 ;o) Chris Steve Brownlee wrote: +1 for Aptana. -Original Message- From: Joel Watson [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 19, 2008 4:14 PM To: CF-Talk Subject: Re: Visual Ajax IDE? Hi: Dreamweaver is the best html/cfm editor I have ever used. I wonder if there is a good one for AJAX? Do you know one? If it has some visual tools like the ones in DW. Thanks Ali For my money (well, actually, it's absolutely free), you can't beat Aptana. Joel ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301670 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
XML Node Traversal
Hello, I apologize if this is a dumb question, but I'm a bit a n00b when it comes to XML in CF. I have XML that looks something like this: testElements testElementtext 1/testElement testElementtext 2/testElement /testElements What I want to know is how I get the values from both sub-nodes, even though they have the same name. -- Edward A Savage Jr - Sonny Senior Software Engineer Creditdiscovery, LLC I was gratified to be able to answer promptly. I said I don't know. ~ Mark Twain ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301583 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: XML Node Traversal
Thanks Charlie! cfdump was not revealing that I could access the elements as an array. On Wed, Mar 19, 2008 at 12:44 PM, Charlie Griefer [EMAIL PROTECTED] wrote: On Wed, Mar 19, 2008 at 9:40 AM, Charlie Griefer [EMAIL PROTECTED] wrote: On Wed, Mar 19, 2008 at 9:33 AM, Sonny Savage [EMAIL PROTECTED] wrote: Hello, I apologize if this is a dumb question, but I'm a bit a n00b when it comes to XML in CF. I have XML that looks something like this: testElements testElementtext 1/testElement testElementtext 2/testElement /testElements What I want to know is how I get the values from both sub-nodes, even though they have the same name. cfsavecontent variable=myXML testElements testElementtext 1/testElement testElementtext 2/testElement /testElements /cfsavecontent cfset parsedXML = xmlParse(myXML) cfdump var=#parsedXML# cfoutput Text 1: #parsedXML.testElements.testElement[1].XmlText#br / Text 2: #parsedXML.testElements.testElement[2].XmlText#br / /cfoutput you can also get a little more dynamic and loop over testElements.testElement as an array: cfoutput cfloop from=1 to=#arrayLen(parsedXML.testElements.testElement )# index=idx #parsedXML.testElements.testElement[idx].xmlText#br / /cfloop /cfoutput -- Evelyn the dog, having undergone further modification pondered the significance of short-person behaviour in pedal depressed, pan-chromatic resonance, and other highly ambient domains. Arf, she said. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301587 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: UDF function inside cffunction?
Using cffunction and cfargument tags provide information to CF about the cfc. Once you've used those tags in the cfc, the rest of the function/method can be written inside cfscript tags. Is that sufficient to your needs? On Mon, Mar 17, 2008 at 6:57 PM, Leitch, Oblio [EMAIL PROTECTED] wrote: It seems you cannot define a cfscript-based udf inside a cffunction. Can anyone confirm/deny? Has anyone encountered this? If you *can*, how? Needs to be cast as a particular Java type? And, if not, why not? Is this convention? TIA This email message may contain privileged and/or confidential information. If you are not the intended recipient(s), you are hereby notified that any dissemination, distribution, or copying of this email message is strictly prohibited. If you have received this message in error, please immediately notify the sender and delete this email message from your computer. CAUTION: The Agency of Human Services cannot ensure the confidentiality or security of email transmissions. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301492 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: error on rename of...
All RDBMS platforms I've used provide a data dictionary. These are special tables that you can query against to get structural information. MySQL has a data dictionary and it's documented here: http://dev.mysql.com/doc/refman/5.0/en/information-schema.html You may want to create a CFC that queries these tables and provides you an easy-to-use data dictionary (a quick Googling didn't produce an already available item). On Tue, Mar 18, 2008 at 4:03 PM, Richard White [EMAIL PROTECTED] wrote: thanks for this - is there any way to get the constraint name for a particular column, for example the constraint name in the above example is qu_41_tb_24_ibfk2. but i wont know the name unless there is a way to get it from the database. if i get this then i can delete this first then remove the foreign key and it will remove fine thanks very much cfdbinfo type=columns table=yourtable datasource=yourDSN name=dbdata cfquery name=getfk dbtype=query SELECT REFERENCED_PRIMARYKEY, REFERENCED_PRIMARYKEY_TABLE FROM dbdata WHERE IS_FOREIGNKEY = 'YES' /cfquery cfdump var=dbdata cfdump var=getfk On Tue, Mar 18, 2008 at 11:11 AM, Richard White [EMAIL PROTECTED] wrote: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301539 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Back button and Ajax
The YUI package has a browser history manager which does exactly that: http://developer.yahoo.com/yui/history/ On Mon, Mar 17, 2008 at 2:45 PM, Claude Schneegans [EMAIL PROTECTED] wrote: Hi, Ajax is a nice feature, for instance when only some part of a page must be changed, one can populate some internal DIV instead of reloading the entire page. But the problem is when the visitor hits the back button: he then doesn't get back to the previous sub page, but to the page he opened the current page from. Has any one implemented some feature that would allow to 1. check if the back button is hit, 2. go back to the previous sub-page instead of the previous page? -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301437 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: first time mySQL - couple of quick questions
MySQL has varied licensing, and their web site has all the details. The short of it is this: 1) You can use it for development for free, and 2) the host should be paying for server licensing (if any). MySQL isn't that much different than SQL server. There should be a resource that compares the two with descriptions of how to accomplish the same results. On Mon, Mar 17, 2008 at 4:53 PM, Mike Little [EMAIL PROTECTED] wrote: hi guys, my client does not wish to pay for utilising an SQL Server db. access will not suffice for the applications they are requesting eg. concurrent usage and security. mySQL. my webhost offers this connection with their basic plans. 1. is mySQL free to use? 2. how different is it from SQL Server eg. will i need much upskilling to use? thanks heaps. mike ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301446 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfqueryparam
As I understand it, cfqueryparam enhances performance by using bind variables. My question is whether it helps to use cfqueryparam for constants in a query. Example SELECT * FROM myTable WHERE code = 'X' -vs- SELECT * FROM myTable WHERE code = cfqueryparam value=X cfsqltype=cf_sql_char maxlength=1 -- Edward A Savage Jr - Sonny Senior Software Engineer Creditdiscovery, LLC I was gratified to be able to answer promptly. I said I don't know. ~ Mark Twain ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301264 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfqueryparam
Thanks Mark! I have recently started using cfqueryparam, I learned the bad habit of not using them during my first CF job. I had the suspicion that things worked as you've elaborated, but I wanted to confirm. The doubts in my mind came about because I've done some PL/SQL programming and I've only seen bind variables used when the value is actually variable. On Fri, Mar 14, 2008 at 10:43 AM, Mark Kruger [EMAIL PROTECTED] wrote: Sonny, These constants are not constants to the SQL server. To the SQL server these are still unbound variables... So yes, you need to use cfqueryparam if you want to hit the cache pool and execution plan cache. Otherewise the driver hands off the prepare operation to the SQL server - meaning no cache hit is possible. As a point of interest ... Why would you ask this question? Why not just use cfqueryparam as a matter of standard practice for all input variables? -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Sonny Savage [mailto:[EMAIL PROTECTED] Sent: Friday, March 14, 2008 9:36 AM To: CF-Talk Subject: cfqueryparam As I understand it, cfqueryparam enhances performance by using bind variables. My question is whether it helps to use cfqueryparam for constants in a query. Example SELECT * FROM myTable WHERE code = 'X' -vs- SELECT * FROM myTable WHERE code = cfqueryparam value=X cfsqltype=cf_sql_char maxlength=1 -- Edward A Savage Jr - Sonny Senior Software Engineer Creditdiscovery, LLC I was gratified to be able to answer promptly. I said I don't know. ~ Mark Twain ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301269 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Using Var scope?
var should be done for all user-defined functions, not just ones in CFCs On Fri, Mar 14, 2008 at 5:57 PM, Ian Skinner [EMAIL PROTECTED] wrote: D Simcik wrote: I'm using it to declare variables at the top of my CFC's, but I am wondering really when/why this should scope be used as a best practice. Not at the top of your CFC's but at the top of each function in the CFC for all variables you want to be local to that function. The VAR declaration creates private variables for the function so that they do not get mixed up with variables of the same name in other functions and|or the variables scope. The variables scope is basically the global private scope of the entire CFC and is shared by all functions of the component. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301351 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Join one concatenated field to four fields
Ouch... doing conversions in the where clause is gonna' kill your performance. I'm not sure concatenations work in the where clause, but something like this might have better performance: WHERE ( pur.chemical_code LIKE '%185' OR pur.chemical_code LIKE '%573' ) AND ( pur.epa_registration_num = prod.mfg_firmno || prod.label_seq_no || prod.revision_no || prod.reg_firmno OR ( prod.reg_firmno = prod.mfg_firmno AND pur.epa_registration_num = prod.mfg_firmno || prod.label_seq_no || prod.revision_no || '0' ) ) On Wed, Mar 12, 2008 at 5:14 PM, Ian Skinner [EMAIL PROTECTED] wrote: With much blood, sweat and tears and finally finding a source of help. I know of this: SELECT pur.epa_registration_num, prod.mfg_firmno, prod.label_seq_no, prod.revision_no, prod.reg_firmno FROM pur89raw pur, product prod WHERE (pur.chemical_code LIKE '%185' OR pur.chemical_code LIKE '%573') AND cast(substr(pur.epa_registration_num,0,7) AS number(7)) = prod.mfg_firmno AND cast(substr(pur.epa_registration_num,8,5) AS number(5)) = prod.label_seq_no AND cast(substr(pur.epa_registration_num,13,2) AS char(2)) = prod.revision_no AND cast(decode(rtrim(substr(pur.epa_registration_num,15,7)),0, substr(pur.epa_registration_num,0,7), substr(pur.epa_registration_num,15,7)) AS number(7)) = prod.reg_firmno ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301109 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Help Adobe plan the future of ColdFusion (along that line)
That should be the job of a server-side virus scanner. I don't think it's reasonable to expect Adobe to provide that kind of service (unless they go into the anti-virus business, I suppose). On Wed, Mar 12, 2008 at 7:09 PM, Don L [EMAIL PROTECTED] wrote: A Word document may have Trojan Horse embedded, other type of file, PPT, JPG/JPEG, GIF... are all subject to destructive intention... You should have heard of them... Service like Yahoo email embeds this kind of file security into it, for instance, when you receive an attachment, yahoo would check that attachment for you before download... No, I'm not a security maniac but it's now part of life... what exactly do you mean by security check? check for what? Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Don L wrote: I think File Upload is an important feature. Non-intranet apps (and maybe even intranet apps as well) would definitely need security check for uploaded file, so, if Adobe could build such security check upon file upload capability I think it would be a great service. Also it's very desirable to have lean design, if that's already there, I miss it... my apology. Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301110 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Best way to order appearance of database content...
Use and indexed loop, multiply the loop count by 10 and use that value for record insertion... On Wed, Mar 12, 2008 at 11:05 PM, Rick Faircloth [EMAIL PROTECTED] wrote: I know that doesn't sound like it's CF-related, but the solution probably will be in CF, I'll bet. Anyway.I want to be able to determine the appearance order of Real Estate agents on a page, other than by last name, etc. I want a user to be able to specify the appearance, say, by number. I could have an display-order column and use a number. I would also want to have the numbers round up to the nearest 10 whenever a new agent is entered or when an agent's display order is updated. Say, I've got two agents in the db. First has display-order 10, second has display-order 20. A third agent is added who is to be displayed second, so is given the display-order number 15 in the form. When the form is submitted, the first agent retains number 10, the new second agent's number is rounded up from 15 to 20, and the agent whose number was 20 now has the number 30. That way there are always values between the agents' display-order numbers to add new agents. Make any sense? Would this be the best way to do this? Other ways? Thanks, Rick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301138 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Best way to order appearance of database content...
That should work great... 1) Query Real Estate Agent IDs, ordered by sort value 2) cfloop over the query 3) Use queryName.currentRow *10 as the new sort value for each record On Thu, Mar 13, 2008 at 12:13 AM, Rick Faircloth [EMAIL PROTECTED] wrote: I think this might work... - to start, in db, 2 records, display-order values 10 and 20 - form submitted with display-order value of 15 - run insert query using value of 15 - now three records, display-order values 10, 15, 20 - run query to retrieve total recordcount - loop query with index and run internal update query setting each display-order value to index*10 Am I missing anything? Any gotcha's in that approach? Rick -Original Message- From: Sonny Savage [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 12, 2008 11:12 PM To: CF-Talk Subject: Re: Best way to order appearance of database content... Use and indexed loop, multiply the loop count by 10 and use that value for record insertion... On Wed, Mar 12, 2008 at 11:05 PM, Rick Faircloth [EMAIL PROTECTED] wrote: I know that doesn't sound like it's CF-related, but the solution probably will be in CF, I'll bet. Anyway.I want to be able to determine the appearance order of Real Estate agents on a page, other than by last name, etc. I want a user to be able to specify the appearance, say, by number. I could have an display-order column and use a number. I would also want to have the numbers round up to the nearest 10 whenever a new agent is entered or when an agent's display order is updated. Say, I've got two agents in the db. First has display-order 10, second has display-order 20. A third agent is added who is to be displayed second, so is given the display-order number 15 in the form. When the form is submitted, the first agent retains number 10, the new second agent's number is rounded up from 15 to 20, and the agent whose number was 20 now has the number 30. That way there are always values between the agents' display-order numbers to add new agents. Make any sense? Would this be the best way to do this? Other ways? Thanks, Rick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301145 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 help
Did that work for you? On Mon, Mar 10, 2008 at 12:25 PM, Sonny Savage [EMAIL PROTECTED] wrote: Now that I understand your data structures, I understand how to solve the problem. I hope this works on MySQL. I tested it using OpenOffice.orgBase. SELECT users.user_id , users.user_name , docs.doc_id , docs.doc_name , user_docs.signoff_id FROM users, docs LEFT OUTER JOIN user_docs ON users.user_id = user_docs.user_id AND docs.doc_id = user_docs.doc_id WHERE user_docs.signoff_id IS NULL On Mon, Mar 10, 2008 at 10:01 AM, Josh McKinley [EMAIL PROTECTED] wrote: I think you've made a bit of an error there. With inner joins, the query returns no results. This is what I expected. Using a left outer join also returns no rows. This makes sense as you're maintaining the rows from the wrong table. Changing it to a right outer join creates a cross dependency error. The user table has all of the users. The doc table has all of the docs. The user_doc table has one entry for each time a user has signed off on having read a document. A row is inserted with the user id and the doc id. What I'm trying to return is the users who have not signed off on viewing one or more documents and the documents on which they've failed to sign off. Subject: query help From: Sonny Savage Date: Mon, 10 Mar 2008 08:39:57 -0400 Thread: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:55471#300843 Question: Do you also want a result in the case where there is no USER_DOCS record for a given USER and DOC record (FULL OUTER JOIN)? On Sat, Mar 8, 2008 at 12:12 AM, Josh McKinley [EMAIL PROTECTED] wrote: - Excess quoted text cut - see Original Post for more - ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300928 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: QofQ Date Comparison Problem...
IIRC: '-MM-DD' On Tue, Mar 11, 2008 at 3:37 PM, Che Vilnonis [EMAIL PROTECTED] wrote: How can I compare dates in a QofQ date comparison? See code snippet below. Thanks, Che cfset threeMonthsAgo = dateformat(dateAdd(m, -3, now()), m/d/) cfset dirArt = ExpandPath(../) emailblast cfdirectory action=LIST directory=#dirArt# name=getArt filter=*.jpg cfquery name=filteredArt dbtype=query select name from getArt where type = 'file' and datelastmodified cfqueryparam value=#threeMonthsAgo# cfsqltype=CF_SQL_DATE /cfquery cfdump var=#filteredArt# ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300994 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: QofQ Date Comparison Problem...
Did you try '-MM-DD'? cfquery name=filteredArt dbtype=query select name from getArt where type = 'file' and datelastmodified '#dateFormat(threeMonthsAgo, -MM-DD)#' /cfquery On Tue, Mar 11, 2008 at 3:54 PM, Che Vilnonis [EMAIL PROTECTED] wrote: Point #1. True. I guess I thought it was obvious. Points #23... I've tried that. I get the following... Error Executing Database Query. brbQuery Of Queries syntax error./bbr Encountered 2007 at line 0, column 0. -Original Message- On Tue, Mar 11, 2008 at 12:37 PM, Che Vilnonis [EMAIL PROTECTED] wrote: How can I compare dates in a QofQ date comparison? See code snippet below. Thanks, Che cfset threeMonthsAgo = dateformat(dateAdd(m, -3, now()), m/d/) cfset dirArt = ExpandPath(../) emailblast cfdirectory action=LIST directory=#dirArt# name=getArt filter=*.jpg cfquery name=filteredArt dbtype=query select name from getArt where type = 'file' and datelastmodified cfqueryparam value=#threeMonthsAgo# cfsqltype=CF_SQL_DATE /cfquery cfdump var=#filteredArt# couple of suggestions: 1) if something isn't working, explain what's not working about it :) 2) cfset threeMonthsAgo = dateAdd('m', -3, now()) / -- no need for dateFormat() there. only format a date if you're displaying it. 3) i don't believe there's any benefit to using cfqueryparam in a query of queries. it's not like there's the possibility of SQL injection, nor do i think there'd be any inherent performance benefits. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300998 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: QofQ Date Comparison Problem...
Darn it... I'm pretty sure I did this while working for a previous employer, if only I could remember how... Is simply hitting the DB again out of the question? On Tue, Mar 11, 2008 at 4:00 PM, Che Vilnonis [EMAIL PROTECTED] wrote: Yes, I did. I even tried using the CAST function. No luck either way. -Original Message- From: Sonny Savage [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 11, 2008 3:56 PM To: CF-Talk Subject: Re: QofQ Date Comparison Problem... Did you try '-MM-DD'? cfquery name=filteredArt dbtype=query select name from getArt where type = 'file' and datelastmodified '#dateFormat(threeMonthsAgo, -MM-DD)#' /cfquery On Tue, Mar 11, 2008 at 3:54 PM, Che Vilnonis [EMAIL PROTECTED] wrote: Point #1. True. I guess I thought it was obvious. Points #23... I've tried that. I get the following... Error Executing Database Query. brbQuery Of Queries syntax error./bbr Encountered 2007 at line 0, column 0. -Original Message- On Tue, Mar 11, 2008 at 12:37 PM, Che Vilnonis [EMAIL PROTECTED] wrote: How can I compare dates in a QofQ date comparison? See code snippet below. Thanks, Che cfset threeMonthsAgo = dateformat(dateAdd(m, -3, now()), m/d/) cfset dirArt = ExpandPath(../) emailblast cfdirectory action=LIST directory=#dirArt# name=getArt filter=*.jpg cfquery name=filteredArt dbtype=query select name from getArt where type = 'file' and datelastmodified cfqueryparam value=#threeMonthsAgo# cfsqltype=CF_SQL_DATE /cfquery cfdump var=#filteredArt# couple of suggestions: 1) if something isn't working, explain what's not working about it :) 2) cfset threeMonthsAgo = dateAdd('m', -3, now()) / -- no need for dateFormat() there. only format a date if you're displaying it. 3) i don't believe there's any benefit to using cfqueryparam in a query of queries. it's not like there's the possibility of SQL injection, nor do i think there'd be any inherent performance benefits. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301003 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 help
Question: Do you also want a result in the case where there is no USER_DOCS record for a given USER and DOC record (FULL OUTER JOIN)? On Sat, Mar 8, 2008 at 12:12 AM, Josh McKinley [EMAIL PROTECTED] wrote: I've got three tables like this (simplified): USERS user_id user_name DOCS doc_id doc_name USER_DOCS signoff_id user_id doc_id I need all user names and doc names where the combination doesn't exist in the signoff table USER_DOCS. For example, user 12 hasn't signed of on doc 9 and user 6 hasn't signed off on doc 44, I need to know that. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300843 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 help
This query will return all users and docs that have a relationship established but don't have a sign-off record: SELECT u.user_name , d.doc_name FROM user_docs ud INNER JOIN users u ON ud.user_id = u.user_id INNER JOIN docs d ON ud.doc_id = d.doc_id WHERE ud.signoff_id IS NULL It will not return records that have non-matching foreign keys (non-existent user or doc). Converting the INNER JOINS to LEFT OUTER JOINS would change that behavior. On Mon, Mar 10, 2008 at 8:39 AM, Sonny Savage [EMAIL PROTECTED] wrote: Question: Do you also want a result in the case where there is no USER_DOCS record for a given USER and DOC record (FULL OUTER JOIN)? On Sat, Mar 8, 2008 at 12:12 AM, Josh McKinley [EMAIL PROTECTED] wrote: I've got three tables like this (simplified): USERS user_id user_name DOCS doc_id doc_name USER_DOCS signoff_id user_id doc_id I need all user names and doc names where the combination doesn't exist in the signoff table USER_DOCS. For example, user 12 hasn't signed of on doc 9 and user 6 hasn't signed off on doc 44, I need to know that. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300844 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 help
Now that I understand your data structures, I understand how to solve the problem. I hope this works on MySQL. I tested it using OpenOffice.orgBase. SELECT users.user_id , users.user_name , docs.doc_id , docs.doc_name , user_docs.signoff_id FROM users, docs LEFT OUTER JOIN user_docs ON users.user_id = user_docs.user_id AND docs.doc_id = user_docs.doc_id WHERE user_docs.signoff_id IS NULL On Mon, Mar 10, 2008 at 10:01 AM, Josh McKinley [EMAIL PROTECTED] wrote: I think you've made a bit of an error there. With inner joins, the query returns no results. This is what I expected. Using a left outer join also returns no rows. This makes sense as you're maintaining the rows from the wrong table. Changing it to a right outer join creates a cross dependency error. The user table has all of the users. The doc table has all of the docs. The user_doc table has one entry for each time a user has signed off on having read a document. A row is inserted with the user id and the doc id. What I'm trying to return is the users who have not signed off on viewing one or more documents and the documents on which they've failed to sign off. Subject: query help From: Sonny Savage Date: Mon, 10 Mar 2008 08:39:57 -0400 Thread: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:55471#300843 Question: Do you also want a result in the case where there is no USER_DOCS record for a given USER and DOC record (FULL OUTER JOIN)? On Sat, Mar 8, 2008 at 12:12 AM, Josh McKinley [EMAIL PROTECTED] wrote: - Excess quoted text cut - see Original Post for more - ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300859 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: adding query results
arraySum(queryName[columnName]) On Mon, Mar 10, 2008 at 1:43 PM, Chad Gray [EMAIL PROTECTED] wrote: I swear I remember a CF function that would total a query's results. Like if my query returns 10 rows of grandTotal and grandTotal is a field that contains numbers. You could run a function and it would add the 10 rows together so you get one number. Am I dreaming this? I cant find the function. Maybe it was a SQL function... ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300869 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Bluedragon = open source
Dang it, you stole my comment! On Mon, Mar 10, 2008 at 1:46 PM, Aaron Rouse [EMAIL PROTECTED] wrote: Whats even more interesting is that announcement is from the future ;) On Mon, Mar 10, 2008 at 12:38 PM, Brad Wood [EMAIL PROTECTED] wrote: Interesting: http://www.newatlanta.com/corporate/news/bluedragon_opensource_announce. jsp http://www.newatlanta.com/corporate/news/bluedragon_opensource_announce.jsp ~Brad ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300870 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: adding query results
One of the beautiful aspects of the Query response object is that you can access it like a struct of arrays. Because of CF's dynamic nature, you do have to give hints. This will work: arraySum(queryName[columnName]) This win NOT: arraySum(queryName.columnName) On Mon, Mar 10, 2008 at 1:53 PM, Charlie Griefer [EMAIL PROTECTED] wrote: SQL function would be SUM() you could do it in CF via a few functions... arraySum(listToArray(valueList(queryname.columnName))) i think... but SUM in SQL would probably be the way to go in most cases. On Mon, Mar 10, 2008 at 10:43 AM, Chad Gray [EMAIL PROTECTED] wrote: I swear I remember a CF function that would total a query's results. Like if my query returns 10 rows of grandTotal and grandTotal is a field that contains numbers. You could run a function and it would add the 10 rows together so you get one number. Am I dreaming this? I cant find the function. Maybe it was a SQL function... ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300874 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: adding query results
http://www.bennadel.com/blog/167-Calling-Array-Functions-on-ColdFusion-Query-Columns.htm On Mon, Mar 10, 2008 at 2:01 PM, Sonny Savage [EMAIL PROTECTED] wrote: One of the beautiful aspects of the Query response object is that you can access it like a struct of arrays. Because of CF's dynamic nature, you do have to give hints. This will work: arraySum(queryName[columnName]) This win NOT: arraySum(queryName.columnName) On Mon, Mar 10, 2008 at 1:53 PM, Charlie Griefer [EMAIL PROTECTED] wrote: SQL function would be SUM() you could do it in CF via a few functions... arraySum(listToArray(valueList(queryname.columnName))) i think... but SUM in SQL would probably be the way to go in most cases. On Mon, Mar 10, 2008 at 10:43 AM, Chad Gray [EMAIL PROTECTED] wrote: I swear I remember a CF function that would total a query's results. Like if my query returns 10 rows of grandTotal and grandTotal is a field that contains numbers. You could run a function and it would add the 10 rows together so you get one number. Am I dreaming this? I cant find the function. Maybe it was a SQL function... ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300875 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 treeview navigation refresh problem
I am also a YUI guy, and not jQuery, but here goes... To this element: ul id=navLeft class=treeview-blue treeview Add: style=display: none; In the JavaScript that turns the list into a pretty tree view, set the display of that element to block. jQuery has special functions for that I believe, but I'm not familiar with it. Straight JS would be: document.getElementById(navLeft).style.display = block; On Fri, Mar 7, 2008 at 9:59 AM, Paul Ihrig [EMAIL PROTECTED] wrote: adam. thats way over my head man... if you can explain how i could do this better, i would so appreciate it. heck maybe there is a better solution. its just a bunch of nested lists. with cfif checking location on what to show. On Thu, Mar 6, 2008 at 11:10 PM, Adam Haskell [EMAIL PROTECTED] wrote: That post render jump is pretty typical of the majority of AJAX frameworks. I am a big advocate of YUI so my experiences may be different. Generally the way I deal with this is set my containing element to dsiplay: none next I get a handle on that container (navTree = getElementByXX();). Then render the content correctly with my framework, in this case jQuery, and finally set my original containing element display to block or blank or something other than none. Hope that helps. Adam On Thu, Mar 6, 2008 at 12:18 PM, Paul Ihrig [EMAIL PROTECTED] wrote: hey guys. not sure if this is due to massive amount of cfif's or some thing with jquery... i am trying to use tree view on a test/stage site http://63.144.103.199/industrial/enclosures/wallmount/index.cfm its slow.. i am using cfif statements to open close tree branches byt setting the class of the li. my problem so far is that i get a weird refresh thing going on where it expands entire tree with no style. with bkg repeat. then once loaded it looks fine. it is sporadic, and i don't know what to look into... the nav is being called by a cfinclude. not sure if there is a better way to do this. i wanted to do a accordion nav, but i am going to have like 5 levels deep, once i flush this out... any pointers would be great! -paul ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300734 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 treeview navigation refresh problem
I've used YUI alot, it's very different from jQuery. YUI has a flyout-style menu system that I really like: http://developer.yahoo.com/yui/menu/ Your question about once per session could be done, but you'd have to do all your page loads through ajax and content replacement or by using frames. The first one is probably more trouble than the performance you'd gain, but that's up to you to decide. The second, well, who actually likes frames anymore? ;) On Fri, Mar 7, 2008 at 11:16 AM, Paul Ihrig [EMAIL PROTECTED] wrote: Sonny! awsome! that looks to have worked. but now i have a menu shows up blank for a bit while page loads. not sure how to get the menu to render before every thing else.. would YUI be a better route to go? i have never used it. some other questions.. 1. i have all my pages which call cfinclude nav/index.cfm index.cfm calls the js every time the page loads. should/how could i put the js in an include that is called only once per session? i tried doing an iclude in application.cfm, but it would still call it on every page. maybe that doesnt make sense. again thanks. just trying to get me head wrapped around how to do a navingation with 5 levels deep. jquery/treeview looked like an ok solution, i would rather do an accordian, but i cant get one to work with more then 1 level.. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300748 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: subquery help
I'm looking over the query to see if I can optimize it. Is it only supposed to return one record or the most recent score for every quiz that a user has taken? On Thu, Mar 6, 2008 at 8:31 AM, [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: thank you sonny ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300629 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4