Re: ListLast equivalent in MS SQL
SELECT substring(email, charindex('@', email)+1, 255) as Domain FROM users Should get you there. On Fri, May 29, 2009 at 3:47 PM, Barney Boisvert bboisv...@gmail.comwrote: check the reverse, locate, and left functions. reverse it, find the delimiter, and then use left to strip off the prefix. cheers, barneyb On Fri, May 29, 2009 at 12:44 PM, Paul Ihrig pih...@gmail.com wrote: how can i do ListLast(your_email,@) in a sql statement ~| 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:325408 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFBuilder Code Coloring
You can do some color changes in the prefrences. select Window then prefrences +HTML+Editors+CSS+Colors +HTML+Editors+HTML+Colors +HTML+Editors+JavaScript+Colors +HTML+Editors+ScriptDoc+Colors +HTML+Editors+SQL+Colors +HTML+Editors+XML+Colors +ColdFusion+Editor Profiles+Editor+Colors On Wed, Jul 29, 2009 at 2:53 PM, Jason Fisher ja...@wanax.com wrote: Recent blog post about colorizing CFB was linked from the CFB blog. Looks like his notes would allow you to colorize any tag the way you wanted. Haven't played with it myself yet. http://sandeepp.org/blog/?p=84 ~| 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:325098 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
scrolling thumbnails delema
I need to add an image up loader to a clients site. I need to create thumbnails during the upload. I need an auto scrolling container to hold all the thumbnails. Pagination is optional. I need to plan on having 300+ products at any one time in this scroller. I cannot dictate to the photographer what shape to make the image, so I will have both portrate landscape and Square. (this is where i run into problems) I have available MS SQL 2005, Coldfusion 8, and whatever Ajax I want, altho i have not used much Ajax yet. What suggestions would you all make? -- -- Richard Dillman rdill...@gmail.com There are painters who transform the sun to a yellow spot, but there are others who with the help of their art and their intelligence, transform a yellow spot into the sun. - Pablo Picasso ~| 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:324816 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Any Denver/Boulder events??
I and the wife have some family obligations in Denver Co from March 23rd Through April 4nd. That being said we should have lots of free time in the evening/weekend and are hoping to hop into some conferences, seminars, classes or even a meet-up group or two. I am big into ColdFusion, CSS, SEO, OOPâ¦; she is more into growing the business and making some forays into web design so we run the gamut. Iâve been googling but most events are either upcoming or will have just passed, so please if you know of any event during that time in the Denver/Boulder area we would love to hear about it! ~| 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:320546 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFWindow Javascript errors
In the parent page I have my CFwindow and cfajaximport tags. The cfajaximport tag is NOT included in any of the source windows for the cfwindow tag. cfajaximport tags = cfwindow, cfform, cfdiv / cfwindow name=mywindow title=#County_Name# County Details draggable=false modal=true resizable=false initshow=false height=350 width=350 center=true refreshOnShow=true source=WinCountyRegion.cfm?ID=#url.ID# / Later on in the page I have a couple links to POP this window up, each link has its own source file. a href=javascript:void(0) onclick=ColdFusion.Window.show('mywindow');ColdFusion.navigate('WinCountyRegion.cfm?ID=#url.ID#','mywindow')#Region_Name#/a Inside that page I use a self submitting Cfform and pull some data from some CFC's So far everything is GREAT! But at the bottom of that page I have a link that replaces the source of the window with a new admin window to perform CRUD operations. I've tried it both this way: a href=cfoutput#AjaxLink('WinRegion.cfm')#/cfoutputEdit Regions/a And this way: a href=javascript:ColdFusion.navigate('WinRegion.cfm','mywindow');Edit Regions/a But I always wind up with a Javascript error. Error processing JavaScript in markup for element mywindow_body: [Enable debugging by adding 'cfdebug' to your URL parameters to see more information] I have tested all these pages independently and they work fine outside the CFwindow. I might note this does not happen in my Developer version(windows XP) in my Test environment(Windows '03). Only on my VPS at HostMySite. But I cant seem to find a difference between the environments. Both have the latest patches. Any Thoughts what I'm doing wrong here? -- -- Richard Dillman [EMAIL PROTECTED] There are painters who transform the sun to a yellow spot, but there are others who with the help of their art and their intelligence, transform a yellow spot into the sun. - Pablo Picasso ~| 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:315314 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
Have you checked that the field name does NOT have a trailing Space? FoxPro and access allow spaces in field names. [BasicInfo].[mcaidrecda ] isnt the same as [BasicInfo].[mcaidrecda] On Thu, Aug 21, 2008 at 5:39 PM, Andy Matthews [EMAIL PROTECTED]wrote: That's not a bad idea. Have you tried aliasing the column to something else then referencing the aliased column? -Original Message- From: Dan Crouch [mailto:[EMAIL PROTECTED] Sent: Thursday, August 21, 2008 4:19 PM To: CF-Talk Subject: Re: Flummoxed bya simple query I had a problem once where an CFLDAP query returned an invalid column name. It was a similar issue where I could see it there, but I could not access it because it had an invalid column name. I found however that I could rename it using a method that I found on Ben Nadel's site. While your column name may not be invalid, perhaps you could try renaming it to something else to see if you can access it. Worth a try maybe. http://www.bennadel.com/index.cfm?dax=blog:357.view Dan ~| 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:311404 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: LinkedIn CF group
Just another way for headhunters to find more information about you. Actually works well in that regard. On Thu, Jun 12, 2008 at 4:41 PM, AJ Mercer [EMAIL PROTECTED] wrote: Theis is a Railo group too ***http://www.linkedin.com/e/gis/71368/0CF7D323BBC1 * On Thu, Mar 6, 2008 at 11:54 PM, Ben Forta [EMAIL PROTECTED] wrote: And here's a Flex group, just coz ;-) http://www.linkedin.com/e/gis/65596/7DF3445D30E0 --- Ben -Original Message- From: James Wolfe [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 04, 2008 6:01 PM To: CF-Talk Subject: LinkedIn CF group I'm not sure what purpose it serves, but I created a LinkedIn CF group if anyone cares http://www.linkedin.com/groupInvitation?groupID=63526sharedKey=59CB6255962F ~| 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:307415 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Protecting images
Not that I have ever had need to do this... but there are tools to remove passwords from PDF's via Brute Force, Key Search, Dictionary Attack... - PDF Password Remover - Advanced PDF Password Recovery - GuaPDF - gsview - Brava Reader - pdffactory - or just print to a file and then create a new PDF. The long and short of it is nothing gets around that [print screen] button. *All your images Are belong to me! lol* On Fri, Jun 13, 2008 at 8:10 AM, Bobby Hartsfield [EMAIL PROTECTED] wrote: Not to nitpick again but if you take out my comments... take out my signature ;-) I didn't say any of that. ..:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED] Sent: Friday, June 13, 2008 4:19 AM To: CF-Talk Subject: Re: Protecting images On Thu, Jun 12, 2008 at 8:20 AM, ColdFusion Developer [EMAIL PROTECTED] wrote: ... I personally think if they HAVE to display these images, watermarking then converting to flash is their best option (as well as copyrighting the images so if the images are stolen the client has a bit of recourse in the end). ... .:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com Not to nitpick, because it doesnt change the basic point of the discussion, but your images are already copyrighted. All works are automatically copyrighted the moment they are created. There is no registration required to copyright anything like you have to with a patent or a trademark. There is a copyright registration process, and that is set up to make it easy to PROVE your entitelements, thats all. Your entitlements under the copyright law exist the moment you create the images. There are some differences in what happens if you try to enforce your rights if you have registered your copyright, so its definitely a good thing to complete the copyright registration process, but its important to understand that your rights exist in any work you create, images and text and code and any other thing (including this email) simply by creating the work. In short, if you create an image, you automatically own the copyright until such time as you assign the right to someone else, or if you created it .under an arrangement that means it is already owned by someone else (e.g. if you are working as an employee at the time). -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET http://asp.net/ hosting from AUD$15/month ~| 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:307418 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Guide for reviewing a website
Oh Yea, The absolute first thing I do with any newly inherited site is to view it via Firefox with a few plug ins: - Cold Fire - Firebug - Firefox accessibility extension - HTML Validator - Kgen - Load time Validator - SE Open - Window Resizer - YSlow Not to hijack a topic but any other add ins you guys find useful? On Mon, Jun 2, 2008 at 5:42 PM, Dave Francis [EMAIL PROTECTED] wrote: This might point out areas where load times could be improved: http://developer.yahoo.com/performance/index.html#rules along with the YSlow plugin for firebug. -Original Message- From: Richard Dillman [mailto:[EMAIL PROTECTED] Sent: Monday, June 02, 2008 1:51 PM To: CF-Talk Subject: Re: Guide for reviewing a website Lets not forget: Branding Logo Compatibility (IE,NS,FF,O...)(win,Mac,Lynux...) Load Time (10 sec) SEO There is a LOT that goes into a good website. On Mon, Jun 2, 2008 at 11:59 AM, Tom Chiverton [EMAIL PROTECTED] wrote: On Monday 02 Jun 2008, Toby King wrote: looking at include overall look and feel,navigation, content, ease of use. You might want to have standards compliance, graceful degradation or accessibility in there. -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| 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:306694 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 Coldfusion Formatters or Coldfusion Beautifiers
There is a pretty good thread about this over at Ray Camden's site http://www.coldfusionjedi.com/index.cfm/2007/10/11/ColdFusion-Code-Beautifiers There is also a wonderful thread on formatting preferences. http://www.coldfusionjedi.com/index.cfm/2008/4/22/What-makes-a-code-diva I'd go with dreamweaver or CFEclipse. They are not perfect, but they will get you a good starting point. On Sun, Jun 1, 2008 at 1:19 PM, Gerald Guido [EMAIL PROTECTED] wrote: Yeah, but *GREAT* indenting :)) Oddly enough both of those came from the same script. By far the highest wtfpm ratio I have seen to date. http://www.osnews.com/story/19266/WTFs_m On Sat, May 31, 2008 at 12:19 AM, Dave Francis [EMAIL PROTECTED] wrote: He also did not grasp the concept of variable scopes: http://www.nomorepasting.com/getpaste.php?pasteid=16315 Yeah, but *GREAT* indenting :)) ~| 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:306559 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Guide for reviewing a website
Lets not forget: Branding Logo Compatibility (IE,NS,FF,O...)(win,Mac,Lynux...) Load Time (10 sec) SEO There is a LOT that goes into a good website. On Mon, Jun 2, 2008 at 11:59 AM, Tom Chiverton [EMAIL PROTECTED] wrote: On Monday 02 Jun 2008, Toby King wrote: looking at include overall look and feel,navigation, content, ease of use. You might want to have standards compliance, graceful degradation or accessibility in there. -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| 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:306625 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: What's wrong with this query?
Wouldnt you put an IF at the begining of the statement? cfquery name=insert_photo datasource=c21ar IF NOT EXISTS (SELECT PHOTO_FILENAME FROM HMLS_PHOTOS WHERE PHOTO_FILENAME = cfqueryparam cfsqltype=cf_sql_varchar value=#photolist.name#) INSERT INTO HMLS_PHOTOS (PHOTO_FILENAME, PHOTO_MLS_NUMBER) VALUES (cfqueryparam cfsqltype=cf_sql_varchar value=# photolist.name#, cfqueryparam cfsqltype=cf_sql_varchar value=#listfirst( photolist.name,'_')#) /cfquery -- -- Richard Dillman [EMAIL PROTECTED] There are painters who transform the sun to a yellow spot, but there are others who with the help of their art and their intelligence, transform a yellow spot into the sun. - Pablo Picasso ~| 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:305464 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SSN
There is a service at SSA that allows you to validate Employees via a web interface 10 at a time. I wonder if it could be consumed. *http://www.ssa.gov/employer/ssnv.htm*http://www.ssa.gov/employer/ssnv.htm While the service is available to all employers and third-party submitters, it can only be used to verify current or former employees and only for wage reporting (Form W-2) purposes. additional info... 000-xx- will never be used. 666-xx-, and 900-xx- through 999-xx- are not planned to be used at this time. Numbers above 772-xx- have not been assigned to any area as of yet. 700-xx--728-xx- were issued to Rail Road employees and have been discontinued There are also multiple numbers that were invalidated that were part of add campaigns. 078-05-1120 (Woolworth wallet) 219-09- (SSA Pamphlet) 987-65-4320 - 987-65-4329 (officially assigned to advertising campaigns) On Thu, May 15, 2008 at 10:17 AM, morgan l [EMAIL PROTECTED] wrote: Looks like CF's IsValid() will accept a type of SSN ( http://www.houseoffusion.com/documentation/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.htm?context=ColdFusion_Documentationfile=0534.htm ), which would suggest that there is some sort of check-sum or other algorithm available, which will give better results than the 111-11- mask would. It won't verify that the number has ever been issued, or that the number does not belong to a deceased person, or that it belongs to the person claiming it. On Thu, May 15, 2008 at 8:33 AM, Rick Root [EMAIL PROTECTED] wrote: Honestly, I don't think there is any other validator, and I'd be quite surprised if there was any kind of service that validated SSNs as real or otherwise. On Thu, May 15, 2008 at 8:06 AM, Greg Edmonds [EMAIL PROTECTED] wrote: Hello All, I know there are many ways to validate a US social security number, but is there any way to verify that it is actually a real ssn number? For example, the current validation used for cfinput would return 111-11- as a valid ssn. I guess it could be valid, but I don't think it is. I need something that would verify if this is an ACTUAL ssn. Kind of like we do for credit cards. Any ideas? Thanks! Greg ~| 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:305342 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Dynamically prepolate the select box
I thought it was Give a man a fish and you have fed him for today. Teach a man to fish, and he will sit in the boat and drink beer all day. -- -- Richard Dillman [EMAIL PROTECTED] There are painters who transform the sun to a yellow spot, but there are others who with the help of their art and their intelligence, transform a yellow spot into the sun. - Pablo Picasso ~| 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:305094 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Fancy auto-suggest
I would really caution against doing this. My rule of thumb is that IF i have to explain the page to someone. I didn't do my job designing it. Your not going to be there to hold your users hand every time they come to your page. Build your page and give it to the most non techie person you know and don't say a word. Bring duct tape if you need to. Let them discover whats supposed to be done. You will be amazed at what they will click on and what order they fill in forms. I found this out with an application I wrote recently. I had several pieces of information iIneed and first, last name were not the first things on the list. In fact they were auto populated from other data bits (employee ID) they filled out early on in the form. BUT nearly all of them noticed those empty *first last name fields* in the middle of the screen they all tried to fill those out first. Kinda blew me away, the whole coolness of my form was lost on them cuz they didn't care about 'auto fill' or 'tab order' they just knew the answer to those fields so went there first. /rant On 5/9/08, Don L [EMAIL PROTECTED] wrote: I think there was a thread talking about two connected levels of auto-suggest or auto-suggest chain. A quick search did not yield it. Does anyone happen to recall something to the effect of that thread title? The flow would be like something like the following: (Instruction: a) first type an alphabetic letter in the box below to select categry; b) press [space bar] after category select, then type the first digit of a zipcode. - a) pick a category of interest; b) upon selection + space bar + auto-suggest zipcode - It shouldn't be difficult to do but am lazy (if someone has done just 'borrow' it...)... Also, equally importantly, for public-facing app, how would you write the instruction above the Select box to ensure smart or dumb users can all understand and use it? Another approach to solve the above problem would be to use two auto-suggest ajax control with two Select boxes, which might be clearer to users (especially for the public-facing app), however, personally I prefer the first/top approach, which seems more efficient... Thanks. ~| 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:304977 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 - Google Hosted Email (New Question)
there are only 2 reasons i use googles email. *Storage Space* 6.7 GB *Key Words* What I find very annoying with outlook is when client emails me about 3 different contracts, what folder do I put it in? Gmail lets me put it in as many as I want by letting me add multiple Key words or Labels to them. CF-talk always gets labeled *CF-TALK* and Skips the inbox, if the mail has a response from me it also gets a Gold Star. I only wish i could have sub-labels of label groups. On 5/9/08, ColdFusion [EMAIL PROTECTED] wrote: OK with all the talk of using Google Hosted Email and such poses a question or so since I do not use it: I have my own domain and it is hosted by a provider in California (Been of great service and very happy with). They use SmarterMail 3.x (not yet upgraded to 4 or the latest 5 yet). Now I use Outlook 2007 and like to keep using it rather than the web interface from SmarterMail. Could I route all mail from my domain into Google and then use Outlook to send/receive mail from Google? Besides the great filtering capability provided by Google, what other benefits would it give me? Trying to determine if it is worth moving all my accounts over? -Original Message- From: James Smith [mailto:[EMAIL PROTECTED] Sent: Friday, May 09, 2008 6:23 AM To: CF-Talk Subject: Re: OT - Google Hosted Email Google apps rules, we use it for about a dozen domains and about 25 users and it works like a dream, even for those older staff members who insist on keeping with outlook! I still haven't got around to re-purposing the old linux mail server though! -- Jay ~| 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:304980 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Avoid multiple form submits.
cfinput id=submit name=submit type=submit validate=submitonce / On 5/9/08, Robert Rawlins [EMAIL PROTECTED] wrote: Hello Guys, I've got an issue with a form which is sometimes a little slow to process. Seems that some of the users are clicking the submit button a whole bunch of times and we're getting a few problems arise as a result of it. How are you tackling this problem? presumably something with jQuery would be nice but I wanted to get your thoughts. Any ideas and code examples welcome :-D Robert ~| 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:304985 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Country/City/Province List for DB import
theirs an sql script at http://forums.asp.net/t/1045550.aspx appears to have all countries and provinces/states for Canada, US, and UK On 4/30/08, [STS] Ravi Gehlot [EMAIL PROTECTED] wrote: I know this question has already been asked and I unfortunately I lost my bookmarks and now I am here asking it again. What's that website with the list of country/cities to import to the database? Someone had passed through a FREE site with a complete list of countries/cities with link to download it. I had used that to add it to one of my databases. Ravi. -- Ravi Gehlot Web Programmer IT Specialist Sunshine Tech Solutions, LLC http://www.sunshinetechsolutions.com [EMAIL PROTECTED] President ~| 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:304517 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cgi.http user agent (OSâs and web browsers)
http://www.user-agents.org/ On 4/28/08, James Blaha [EMAIL PROTECTED] wrote: All, Does anyone know where I can get a updated list of web browser and OS's that might be associated with data being returned from cgi.http_user_agent? I'm trying to break down visitor stats for users OS's and web browsers being used to access a CF application. -Jim ~| 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:304348 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
autosuggest and 508 Compliance
Im going to be building a few pages that might be accessed useing assistave technology such as a text reader or suck straw. I would prefer to stay in CF7 (the clients arent ready for an upgrade yet) What is everyones experiance with the various autosuggests out there? I'm not tied to any one Ajax implamentation yet, but will rapidly need to pick one. -- -- Richard Dillman [EMAIL PROTECTED] There are painters who transform the sun to a yellow spot, but there are others who with the help of their art and their intelligence, transform a yellow spot into the sun. - Pablo Picasso ~| 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:302931 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SOUNDEX() in MSSQL
Maybe a Quick removal of stoplist words from your search string before matching? stoplist = a, an, and, are, as, at, be, but, by, for, if, in, into, is, it, no, not, of, on, or, s, such, t, that, the, their, then, there, these, they, this, to, was, will, with On Thu, Apr 3, 2008 at 6:56 AM, James Smith [EMAIL PROTECTED] wrote: Does any one know how to use MSSQL's SOUNDEX() functionality to get good search results? Lets say I am doing a product search by title, if the title in the DB is Blade Runner (DVD) and someone searches for Blade Runner then WHERE SOUNDEX(title) = SOUNDEX(#form.title#) will work just fine but if someone searched for the blade runner then the query would fail since SOUNDEX() only works on the first word. -- Jay ~| 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:302570 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Images in the database good or bad?
OMG! I could tell you some stories about government contracting. I actually had an IOT manager in an SSL and Site security meeting ask just how many extra guards he was gonna have to hire!! .. . . o.0 .. . . Only 1 and, he wont have to be armed... On Mon, Mar 24, 2008 at 2:33 PM, Dana Kowalski [EMAIL PROTECTED] wrote: I think the main thing in the end is the scope of the project and personal preference. If the site will maintain heavy load, especially the images section, then you may want to consider a file server for uploads and just store the filename with your record. This can take the strain off a possible i/o bottleneck on the database communication. My personal preference is: - App Server - File Server - Database Server You can argue pros and cons for all the approaches, but at the end of the day you gotta go with what gets the job done -for you-. Also no one in here has brought up the ickle of being a govt. contractor and all the -crazy- stuff that goes along with that aspect of standing gear up 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;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301945 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Images in the database good or bad?
I'm in the process of designing a site that will allow people to upload (JPG,PDF,DOC,XLS) files. I'm looking at about 1-4 mb each item. Is it better to do a file upload, or better to insert to the database? Honestly I'm looking at a long-term answer here for a government contract. The items can be re-uploaded via an admin screen. and there will probably be 10,000 new items per year with a 3-year retention schedule. Granted, I'm designing this with SQL server but I will probably want to port this to MySQL for the private sector when it's all done. Please bare that in mind. In a hosted solution where I might wind up with 20 of these apps on the same sandbox which do you see as the better option? I'd really like to get a lot of pro and con feedback on this. -- -- Richard Dillman [EMAIL PROTECTED] There are painters who transform the sun to a yellow spot, but there are others who with the help of their art and their intelligence, transform a yellow spot into the sun. - Pablo Picasso ~| 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:301793 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 Google Maps down?
I did see some flaky pages for about an hour, but it seems fine now. Also of note same problem in the same time frame at WOOT.com and the San Francisco Chronicle so could be a regional thing as they are all in the bay area. On Wed, Mar 19, 2008 at 9:25 AM, Dominic Watson [EMAIL PROTECTED] wrote: Working for me mate Dominic On 19/03/2008, Adrian Lynch [EMAIL PROTECTED] wrote: When I browse to a site at home, I can see the map, but from work Google isn't returning anything. No code has changed so I'm wondering if anyone else is having or has had problems with this? This isn't our site, but fails: http://www.nestoria.co.uk/sw11/property/buy This is our site, and also fails: http://www.propertyowl.co.uk/uk/clapham/buy/ Thanks. Adrian Lynch ~| 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:301572 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: setting up testing server for dummies...
I have a question along these lines. I've inherited a few sites before and need to clean them up. It's a long angry process. Is their an easy way to show orphaned CFM, CFC, CSS, JS and images? I know this is easy in Dream Weaver for s static site, but what about files referenced in CFC's, CFINCLUDE or pages stored in the DB... What process do you follow to find and trim the fat on your inherited sites. The one i just got has about 50 untitled-1.cfm files, and I cant be sure to delete them because some are being USED! On Jan 20, 2008 1:27 PM, Dave Watts [EMAIL PROTECTED] wrote: will it move iis settings and such. what about macros that may interact with current sql server, that i may NOT be aware of since i am no dba... VMware Converter creates a complete copy of the individual machine from which you run it. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:297051 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CRUD Creation
Sorry stepped away from the computer a couple days to get married WOOT! now back to work crackwhip / What I've come up with is: cfquery name=Insert_user_provider_services datasource=#DSN# IF NOT EXISTS (SELECT ups_id_pk,ups_provider_fk,ups_client_fk,ups_service_fk FROM user_provider_services WHERE ups_provider_fk = cfqueryparam cfsqltype=cf_sql_integer value=#form.provider / AND ups_client_fk = cfqueryparam cfsqltype=cf_sql_integer value=#form.client / AND ups_service_fk = cfqueryparam cfsqltype=cf_sql_integer value=#form.service /) INSERT INTO user_provider_services (ups_provider_fk,ups_client_fk,ups_service_fk) VALUES (cfqueryparam cfsqltype=cf_sql_integer value=#form.provider / ,cfqueryparam cfsqltype=cf_sql_integer value=#form.provider / ,cfqueryparam cfsqltype=cf_sql_integer value=#form.service /) /cfquery Thanks for the input guys. For some reason a former employer drilled it into the team that Auto incrementing PK's were dead weight if you could composite a key with existing data, and I'm finding old habits die hard. OK back to the honeymooning! On Jan 14, 2008 12:22 PM, Dave Watts [EMAIL PROTECTED] wrote: An auto Incrementing PK just makes it easier to insert a duplicate. Not if the column is marked as a PK. I think that Richard means, it's easier to insert duplicate data values with a surrogate key. This is certainly true, unless you place constraints on the natural key as well. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:296681 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CRUD Creation
ACK i was missing my # signs!!! new wife must have stolen them! cfquery name=Insert_user_provider_services datasource=#DSN# IF NOT EXISTS (SELECT ups_id_pk,ups_provider_fk,ups_client_fk,ups_service_fk FROM user_provider_services WHERE ups_provider_fk = cfqueryparam cfsqltype=cf_sql_integer value=#form.provider# / AND ups_client_fk = cfqueryparam cfsqltype=cf_sql_integer value=#form.client# / AND ups_service_fk = cfqueryparam cfsqltype=cf_sql_integer value=#form.service# /) INSERT INTO user_provider_services (ups_provider_fk,ups_client_fk,ups_service_fk) VALUES (cfqueryparam cfsqltype=cf_sql_integer value=#form.provider# / ,cfqueryparam cfsqltype=cf_sql_integer value=#form.provider# / ,cfqueryparam cfsqltype=cf_sql_integer value=#form.service# /) /cfquery ~| 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:296683 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: The CRUD thread reminds me of something I 'played' around a few years ago...
You tried to access the Developer Edition from a disallowed IP ... oops got a live server you can toss it on? On Jan 16, 2008 3:19 PM, Don L [EMAIL PROTECTED] wrote: http://24.254.1.94:8000/snap823/DataMan.cfm (Have not re-test it thoroughly) Who could use something like 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:296692 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CRUD Creation
I am time and again asked to build a cross join table with 2-3 primary keys. Also i am asked time and again to build a table that doesn't use a auto incrementing Primary key. This is usually to port an antiquated system to SQL and web enable it (think AS400). Has anyone built a Crud system that can handle either of these situations? If not what would you do to create the insert query with Catch/Throw to create the following seneraios? Currently I have a client list for a company where the person is uniqued by: *select CityCode + '-' + Left(FirstName,1) + '-' + Left(LastName,1) + '-' + Right(Social,4) Or IND-RD-* All items are in the form and concatinated together in the action page. In another table I have a cross join of ClientID, ProviderID, ServiceID all primary keys each of the 3 items can be picked from the form in drop downs. Just curious how others might handle these... -- -- Richard Dillman [EMAIL PROTECTED] There are painters who transform the sun to a yellow spot, but there are others who with the help of their art and their intelligence, transform a yellow spot into the sun. - Pablo Picasso ~| 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:296523 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CRUD Creation
Well in the first example the concatenated ID needs to be unique. In the second i would need a unique combination of ALL 3 Columns. An auto Incrementing PK just makes it easier to insert a duplicate. On Jan 14, 2008 10:39 AM, Tom Chiverton [EMAIL PROTECTED] wrote: On Monday 14 Jan 2008, Richard Dillman wrote: Has anyone built a Crud system that can handle either of these situations? Why not create a new PK column and use that ? -- Tom Chiverton Helping to paradigmatically initiate high-end partnerships on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| 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:296544 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Record Set Paging
good deal Nathan Ill have a look at the existing one for now. On Dec 28, 2007 12:06 PM, Charlie Griefer [EMAIL PROTECTED] wrote: hehe. now there's pressure :) On Dec 28, 2007 9:01 AM, Nathan Strutz [EMAIL PROTECTED] wrote: Thanks, Charlie. I'm updating the API and creating documentation on my pagination.cfc. Expect a 1.0 RC sometime in the next few weeks. -- nathan strutz http://www.dopefly.com/ On Dec 28, 2007 8:51 AM, Charlie Griefer [EMAIL PROTECTED] wrote: On Dec 28, 2007 7:23 AM, Richard Dillman [EMAIL PROTECTED] wrote: Has anyone built a CFC to create this type of navigation? *1 - 10 of 25* yes, somebody has (at least one that i know of... there are likely others) http://www.dopefly.com/techblog/entry.cfm?entry=214 -- Scientists tell us that the fastest animal on earth, with a top speed of 120 feet per second, is a cow that has been dropped out of a helicopter. - Dave Barry ~| 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:295544 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Change drop down border style in IE7?
No ya can't, better plan on something with Div's and CSS and its not planned for CSS3 either (what a pain) On 12/28/07, ismail cassiem [EMAIL PROTECTED] wrote: Hi, Can one change the drop down broder style in Internet Explorer 7. As is can't be done in IE6! Regards, ~| 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:295477 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Record Set Paging
Has anyone built a CFC to create this type of navigation? *1 - 10 of 25* ** Seems I am asked to build some output page with thousands of records all the time. I have a default page and change the query name and paste it in, but it seems you could pull the query name, number per page and the page you want into a CFC. Sadly I'm not that well versed in CFC's but it seems something you would use quite often. I just haven't found anything from googling. How do ya all go about this? -- -- Richard Dillman [EMAIL PROTECTED] I will always give you what you ask for, it's just not usually what you want ~| 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:295479 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: blocking spambots
You probably shouldn't block that stuff in a memo/comment field simply because people may have those in their signature and will copy past that into every comment, but with judicious use of validation of phone, email, URL and such on those fields that have a very specific function, you can block a lot. In those fields that are not looking for a specific type such as first name, last name, and password, you could block URL and emails. I find that 90% of my spam put their URL/Email crap in every field. Another good trick (sorry I don't remember who mentioned this in an earlier thread before, probably Ben) is to have a hidden checkbox called accept or TOS and look for it to be checked. If it is you have a bot. (insert nasty response here) I'm sure captcha is a good response to eliminate bots, but a lot of my code will be viewed by the disabled community and it needs to be 508 compliant, and to be honest most captcha is hardly readable by me! I need to code for ease of use for the most disabled client I have which would be a blind paraplegic using the suck straw to navigate, text to speech, on a 56k modem with windows 98. On 11/20/07, Tom Chiverton [EMAIL PROTECTED] wrote: On Saturday 17 Nov 2007, Richard Dillman wrote: Maybe this is a little too simple, but I simply block any non email fields from containing an @ or http://; or www. Obviously not somewhere where people post links. -- Tom Chiverton Helping to continually participate essential e-commerce on: http://thefalken.livejournal.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293622 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: blocking spambots
Maybe this is a little too simple, but I simply block any non email fields from containing an @ or http://; or www. On Nov 16, 2007 3:57 PM, Ben Doom [EMAIL PROTECTED] wrote: Which is more or less what I meant by variant. --Ben Doom Larry Lyons wrote: Always use CAPTCHA or a variant when possible. Check the referrer. nofollow links and moderate, or nofollow unmoderated links. --Ben Doom Unfortunately most captchas are not accessible, no text reader can work with them. One idea is to ask for the nth last word in this sentance (eg, What is the Fifth last word in this sentance? answer last). While not foolproof, its far more likely that a person can answer the question correctly than a bot. regards, larry ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293538 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Cfchart box-whisker charts.
Im in need of a Box-Whisker chart and im running into roadblocks with cfchart. Ive got no problem working with the XML output from Webcharts3D but it is telling me that i have an invalid chart type. Anyone successfully gotten one of these puppies to work? -- -- Richard Dillman [EMAIL PROTECTED] I will always give you what you ask for, it's just not usually what you want ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289692 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Pivot table confusion
After all my attempts i find that Cfchart actually has transpose and grouping functions built into the webcharts3d interface ARG! Thanks for all the help Heree is an example using the XML style atribute http://www.webintegrity.us/aclsatracking/Untitled-1.cfm altho id like for the mean line to be 3 connected dots across each domain so it doesnt appear to be a trend line. On 9/18/07, Chris Terrebonne [EMAIL PROTECTED] wrote: Richard, A simple way to do this is to use a Tally table. A Tally table contains one column, ID, that contains numbers from 1 to [x]. You can then do joins against this table to do what you are looking for. Here's an example: SELECT t.ID, a.Taken, a.assessment_ID FROMTally as t LEFT OUTER JOIN assessment a on YEAR(a.Taken) = YEAR(DATEADD(YEAR,-(t.ID - 1),now())) WHERE t.ID = 3 AND youth_id = 'X' That will output NULLs for years that don't exist. Let me know if you have any questions. Regards, Chris -Original Message- From: Richard Dillman [mailto:[EMAIL PROTECTED] Sent: Monday, September 17, 2007 8:13 PM To: CF-Talk Subject: Re: Pivot table confusion OK maybe I need to take a step back and give you some more detail. Or maybe I'm just not going to comprehend what you guys are telling me. I have a single table called assessment with these fields. [assessment_id] [int] IDENTITY(1,1) NOT NULL [youth_id] [varchar](26) NOT NULL [org_id] [varchar](26) NOT NULL [Taken] [datetime] NOT NULL [assessment_type] [int] NOT NULL Ive tried any number of answers from googling, and Ive been on this all day and I simply don't follow what your doing. But this is what I'm after. I'm only going to display 3 years so #Year(dateadd(,-2,now()))# Through #year(now())# but the part i get lost at is creating the empty cells for the values that Don't exist. ---2005--2006--2007--Total -- assessment_type 1-0-510-15 assessment_type 2-3-011-14 assessment_type 3-5-5-9-19 -- Grand Totals--81030-48 I really appreciate all the help but you would think their was an easy way to do this with SQL. Seems it would be something you would need rather often. What I keep coming up with is the following table with the type repeated if theirs more than one year. ---2005--2006--2007--Total -- assessment_type 1---510-15 assessment_type 2-3--11-14 assessment_type 3-5--5 assessment_type 3---55 assessment_type 3-9--9 -- Grand Totals--81030-48 Totally Confused ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289311 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Pivot table confusion
I'm trying to output a table with quantities of assessments taken over a 3 year period. Specifically the last 3 years so i wont always know what the year is until I output. cfquery name=totals datasource=#DSN# SELECT DISTINCT Count(*) as total, Type, --Varchar year(date_time) As year --Date FROM assessment Where Year(date_time) = year(DATEADD(, -3, getdate())) Group by type, year(date_time) Order by type, year(date_time) Asc /cfquery My problem is if a year had no types it has no value not even null. How would I output the following table and Include years with No value? back end is SQL 05 CFMX7 table TR td/td th2005/th th2006/th th2007/th /tr tr thType 1/th td20/td td25/td td30/td /tr tr thType 2/th td25/td td30/td td35/td /tr tr thType 3/th td30/td td35/td td40/td /tr /table -- -- Richard Dillman [EMAIL PROTECTED] ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288566 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Pivot table confusion
Do you have an example of what you mean? Maybe I've been staring at it too long but i just don't see how to populate non existent data. On 9/17/07, Brad Wood [EMAIL PROTECTED] wrote: I've always solved that problem by looping over each year I want to output, then use a query of queries to extract the data for that year (if it even exists) and output it. Then you don't have any gaps. There's probably a better way though. That's just my quick and dirty method. :) ~Brad -Original Message- From: Richard Dillman [mailto:[EMAIL PROTECTED] Sent: Monday, September 17, 2007 9:18 AM To: CF-Talk Subject: Pivot table confusion My problem is if a year had no types it has no value not even null. ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288587 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Pivot table confusion
OK maybe I need to take a step back and give you some more detail. Or maybe I'm just not going to comprehend what you guys are telling me. I have a single table called assessment with these fields. [assessment_id] [int] IDENTITY(1,1) NOT NULL [youth_id] [varchar](26) NOT NULL [org_id] [varchar](26) NOT NULL [Taken] [datetime] NOT NULL [assessment_type] [int] NOT NULL Ive tried any number of answers from googling, and Ive been on this all day and I simply don't follow what your doing. But this is what I'm after. I'm only going to display 3 years so #Year(dateadd(,-2,now()))# Through #year(now())# but the part i get lost at is creating the empty cells for the values that Don't exist. ---2005--2006--2007--Total -- assessment_type 1-0-510-15 assessment_type 2-3-011-14 assessment_type 3-5-5-9-19 -- Grand Totals--81030-48 I really appreciate all the help but you would think their was an easy way to do this with SQL. Seems it would be something you would need rather often. What I keep coming up with is the following table with the type repeated if theirs more than one year. ---2005--2006--2007--Total -- assessment_type 1---510-15 assessment_type 2-3--11-14 assessment_type 3-5--5 assessment_type 3---55 assessment_type 3-9--9 -- Grand Totals--81030-48 Totally Confused ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288668 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Directory Watcher
Its almost 3 am and Maybe that's the problem, I seem to have no problem getting Directory Watcher to work in the admin, and logging the information into with CFLog, but what I cannot do is log the information to the database with a Query. What am i forgetting here? cfcomponent cffunction access=public name=onChange output=no returntype=query cfargument name=CFEvent type=struct required=yes cfset data=CFEvent.data cfquery name=qryInsertTest datasource=#DSN# SET NOCOUNT ON INSERT INTO [eventlist] ([Updated]) VALUES (cfqueryparam cfsqltype=CF_SQL_TIMESTAMP value=#dateformat(data.lastmodified)# null=No) /cfquery /cftry cflog file=MydirWatcher application=No text= ACTION: #data.type#;FILE: #data.filename#; TIME: #timeFormat(data.lastmodified)# /cffunction /cfcomponent Their is only one file that will be updated via FTP, so I guess the next question is, Can I have Directory Watcher watch only one file? -- -- Richard Dillman [EMAIL PROTECTED] (317) 916-8341 I will always give you what you ask for, its just not usually what you want ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287136 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Directory Watcher
Doing the folowing i get the logto MydirWatcher, but nothing in the DB. cfcomponent cffunction access=public name=onChange output=no returntype=query cfargument name=CFEvent type=struct required=yes cfset var qryInsertTest = cfset data=CFEvent.data cftry cfquery name=qryInsertTest datasource=#DSN# INSERT INTO [eventlist] ([Updated]) VALUES (cfqueryparam cfsqltype=CF_SQL_TIMESTAMP value=#dateformat(data.lastmodified)# null=No) /cfquery cfcatch type=database cfset success = 'false' / /cfcatch /cftry cflog file=MydirWatcher application=No text= ACTION: #data.type#;FILE: #data.filename#; TIME: #timeFormat(data.lastmodified)# /cffunction /cfcomponent But if this is going to run int he background as a CFC then how would i ever see the error? This is my first foray into Directory Watcher... On 8/26/07, AJ Mercer [EMAIL PROTECTED] wrote: is DSN being set I do not see a open cftry does the query throw an error? On 8/26/07, Richard Dillman [EMAIL PROTECTED] wrote: Its almost 3 am and Maybe that's the problem, I seem to have no problem getting Directory Watcher to work in the admin, and logging the information into with CFLog, but what I cannot do is log the information to the database with a Query. What am i forgetting here? cfcomponent cffunction access=public name=onChange output=no returntype=query cfargument name=CFEvent type=struct required=yes cfset data=CFEvent.data cfquery name=qryInsertTest datasource=#DSN# SET NOCOUNT ON INSERT INTO [eventlist] ([Updated]) VALUES (cfqueryparam cfsqltype=CF_SQL_TIMESTAMP value=#dateformat(data.lastmodified)# null=No) /cfquery /cftry cflog file=MydirWatcher application=No text= ACTION: #data.type#;FILE: #data.filename#; TIME: #timeFormat(data.lastmodified)# /cffunction /cfcomponent Their is only one file that will be updated via FTP, so I guess the next question is, Can I have Directory Watcher watch only one file? -- -- Richard Dillman [EMAIL PROTECTED] (317) 916-8341 I will always give you what you ask for, its just not usually what you want ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287140 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Assessments and Tracking woes
','Test Group 2','9/21/06 2:02 PM',2,74.36); INSERT INTO #A ([user],[org],[date_time],[assessment],[Score]) VALUES ('3','Test Group 2','3/22/07 2:12 PM',2,84.62); INSERT INTO #A ([user],[org],[date_time],[assessment],[Score]) VALUES ('1','Test Group 2','8/29/06 9:17 AM',2,84.62); INSERT INTO #A ([user],[org],[date_time],[assessment],[Score]) VALUES ('2','Test Group 2','1/11/07 3:12 PM',2,56.41); INSERT INTO #A ([user],[org],[date_time],[assessment],[Score]) VALUES ('3','Test Group 2','5/27/05 10:58 AM',2,84.62); I know it's more SQL than CFML but it's really for a CFML page :-) -- -- Richard Dillman [EMAIL PROTECTED] (317) 916-8341 Using ColdFusion is like having extra developers locked away in the basement coding with you. ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284661 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Spider / Site Map Tool
What about finding CFINCLUDE within CFIF and CFCASE? I think the intent, if I'm not mistaken, is to find all the orphaned files that are NOT still part of the system and folders that are not being used and create a clean directory. The Site map would just be a happy byproduct. Sadly I've been looking for something like this sense i started using Coldfusion. On 7/16/07, Claude Schneegans [EMAIL PROTECTED] wrote: I have just been tasked to find/build a tool that can 1) spider / build a site map of our web site There is much simpler than this. 1) find (or develop your own) menu system which uses standard HTML UL and LI and some css and Javascript to format it as a drop down menu. 2) for your site map, just display the same menu with another css file and no Javascript, so that the list will look like a standard list, and oh yes, just add some Site map title at the top. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283838 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Vehicle mileage
Sounds like someone is doing their taxes and forgot to keep a log. On 4/17/07, Doug [EMAIL PROTECTED] wrote: Kinda do not know where to start on this one. I am doing taxes and know my mileage for each day, although I did not write it down (Yeah I know) Anyways I would like to figure a way to list all my mileage and print it out for each day of the year. Any ideas on where to start? IE: Mileage driven each way = 36 miles * 2 = 72 miles daily excluding weekends * 52 weeks in the year. I would like it to output like so through the year and not include weekend dates 01/06/06 Start miles 72569 End miles72641 01/07/06 Start Miles 72641 End Miles 72713 ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275641 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Vehicle mileage
Give this a shot. cfparam name=StartDate default=#CreateDate(2006,01,01)# / cfparam name=EndDate default=#CreateDate(2006,12,31)# / cfset miles = 72569 / cfloop from=#StartDate# to=#EndDate# index=i step=#CreateTimeSpan( 1, 0, 0, 0 )# cfoutput CFIF NOT ListFind(1,7, dayofweek(i), ,) cfset miles = miles + 72 / #dateformat(i, mm/dd/yy)#br / Start miles #miles#br / cfset miles = miles + 72 / End miles#miles#br / ===br / /CFIF /cfoutput /cfloop On 4/17/07, Doug [EMAIL PROTECTED] wrote: Err..u yeah you could say that :-/ Doug B. ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275643 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Vehicle mileage
OOps dubbled up on the milage there. cfparam name=StartDate default=#CreateDate(2006,01,01)# / cfparam name=EndDate default=#CreateDate(2006,12,31)# / cfset miles = 72569 / cfloop from=#StartDate# to=#EndDate# index=i step=#CreateTimeSpan( 1, 0, 0, 0 )# cfoutput CFIF NOT ListFind(1,7, dayofweek(i), ,) #dateformat(i, mm/dd/yy)#br / Start miles #miles#br / cfset miles = miles + 72 / End miles#miles#br / ===br / /CFIF /cfoutput /cfloop On 4/17/07, Richard Dillman [EMAIL PROTECTED] wrote: Give this a shot. cfparam name=StartDate default=#CreateDate(2006,01,01)# / cfparam name=EndDate default=#CreateDate(2006,12,31)# / cfset miles = 72569 / cfloop from=#StartDate# to=#EndDate# index=i step=#CreateTimeSpan( 1, 0, 0, 0 )# cfoutput CFIF NOT ListFind(1,7, dayofweek(i), ,) cfset miles = miles + 72 / #dateformat(i, mm/dd/yy)#br / Start miles #miles#br / cfset miles = miles + 72 / End miles#miles#br / ===br / /CFIF /cfoutput /cfloop On 4/17/07, Doug [EMAIL PROTECTED] wrote: Err..u yeah you could say that :-/ Doug B. ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275644 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: ANN: GotCFM.Com is Launched - Dedicated to CF Evangelism
Hey mark, add this to a test page and view. cfoutput #SERVER.COLDFUSION.PRODUCTNAME# #SERVER.COLDFUSION.PRODUCTVERSION# #SERVER.COLDFUSION.PRODUCTLEVEL# /cfoutput On 2/27/07, Mark Mandel [EMAIL PROTECTED] wrote: Next stupid question - What do you do if you don't know what the server is? (i.e. you can see a.cfmextension, but you don't know who runs it) Mark On 2/27/07, Rey Bango [EMAIL PROTECTED] wrote: Hi Mark, Any site. I think its extremely important to show how many people depend of CF-technologies everyday. Rey... Mark Mandel wrote: Rey, Do you only want commercial sites? or are you happy with personal blogs and the like? Love the idea, keep the site going! Mark On 2/27/07, Rey Bango [EMAIL PROTECTED] wrote: Thanks for finding those. Fixed. Rey Mik Muller wrote: Typo: http://www.gotcfm.com/about.cfm wbesites in Ok What's next? Also, no email contact below link. Michael Michael Muller Admin, MontagueMA.net Website work (413) 863-0030 cell (413) 320-5336 skype: michaelBmuller http://www.MontagueMA.net Eschew Obfuscation ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270910 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Next N Interface Recommendations
Not to throw a monkey in the wrench. But what if you wanted to do Pagination AND allow column sorting per page? On 1/29/07, Russ [EMAIL PROTECTED] wrote: Pagination should be done in the DB, IMHO. There's no need to bring in all the results to CF and then filter them there. You should be using something like this: Select top #recordPerPage# somefields from sometables where somefieldID NOT IN (select top #recordPerPage*pageNum-1# somefieldID from sometables order by someorderstring) Order by someordersomeorderstring Make sure the order by is the same, and you should only be getting back the records for the page you're asking for. Russ -Original Message- From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] Sent: Monday, January 29, 2007 11:31 AM To: CF-Talk Subject: RE: Next N Interface Recommendations If you have a ton of info to pass around, try storing it in a session structure. It may even be feasible to store the query results in the session scope so there would be no need to pass around all of the search criteria and search again for every page request. Also, this may or may not be of use for pagination http://acoderslife.com/tutorials/index.cfm?act=tcid=1tid=7 -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED] Sent: Monday, January 29, 2007 11:05 AM To: CF-Talk Subject: Next N Interface Recommendations Happy Monday all. I am doing a next-n search interface for my project. I have done these before but they usually only have one or two variables for the query, and I usually use URL parameters for these. This particular form can have up to 20 different fields that the user can use to do a search depending on what they are looking for, so of course I am passing all of the form variables into the dynamic query. problem is, when I click on the next button, or one of the page numbers on the bottom, the query is expecting the form variables. I can CFPARAM them, but then when I click on next or a page name, I get all of the record instead of the filtered ones since the form variables are not empty. I tried using query caching but that does not work either. So what would be the best practice for this? Put all of the form variables into a session variable then use the session variables for my filter on next/back clicks? I thought of using URL variables, but there is a limit to how many characters you can put into a URL so that will not work. Thanks, -- Bruce Sorge I'm a mawg: half man, half dog. I'm my own best friend! ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267969 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Sitemap or FLowchart
ahhh rats... the entire site is behind a password so im screwed atm On 1/18/07, Eric J. Hoffman [EMAIL PROTECTED] wrote: I too am in this boat. Sitemaps is an interesting take. Eric J. Hoffman Managing Partner 2081 Industrial Blvd StillwaterMN55082 mail: [EMAIL PROTECTED] www: http://www.ejhassociates.com tel: 651.717.4105 fax: 651.717.4101 mob: 651.245.2717 Adobe Solutions Partner Microsoft Certified Partner This message contains confidential information and is intended only for [EMAIL PROTECTED] If you are not cf-talk@houseoffusion.com you should not disseminate, distribute or copy this e-mail. Please notify [EMAIL PROTECTED] immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. Eric J. Hoffman therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. -Original Message- From: Larry Lyons [mailto:[EMAIL PROTECTED] Sent: Thursday, January 18, 2007 11:25 AM To: CF-Talk Subject: Re: Sitemap or FLowchart I need to some how document a site i just inherited. I'll need to visually show the flow through the site printed. Something i can refer to while cleaning the code. Any such animal out there? Google Sitemaps? ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266927 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Sitemap or FLowchart
I need to some how document a site i just inherited. I'll need to visually show the flow through the site printed. Something i can refer to while cleaning the code. Any such animal out there? -- -- Richard Dillman [EMAIL PROTECTED] (317) 916-8341 If you want happiness for an hour -- take a nap. If you want happiness for a day -- go fishing. If you want happiness for a month -- get married. If you want happiness for a year -- inherit a fortune. If you want happiness for a lifetime -- help someone else. -- Chinese proverb -- ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266740 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Multiple Published Dates
I have a table of kids [tbl_Children] ID (integer PK) Firstname (varchar 50) I have a talbe of periodicals and how often they publish [publications] ID (integer PK) Distribution (integer) (simpy weather or not they publish monthly or quarterly) Title (varchar 50) I have a table of kids to periodicals [features] ID (integer PK) Child (integer) Pub (integer) StartPub (Date) StopPub (Date) This is where it gets hard. A child could be in say the adoption monthly from01/01/2006 - 03/01/2006 then they are pulled while they intervie with a family or 2 things dont work out we put them back in. 06/01/2006 - 12/01/2006 Text wise its easy to display, but what if im doing a grid of Adoption Monthly 2006 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec no problem looping through the first series of dates but not sure how to go about getting the second series on the same row. Or am i going about storing the dates wrong? -- -- Richard Dillman [EMAIL PROTECTED] (317) 916-8341 If you want happiness for an hour -- take a nap. If you want happiness for a day -- go fishing. If you want happiness for a month -- get married. If you want happiness for a year -- inherit a fortune. If you want happiness for a lifetime -- help someone else. -- Chinese proverb -- ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266413 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Multiple Published Dates
But wouldn't this require someone to add a new date and select all the children that are in that issue every month? Maybe a further clarification is in order... Kids become available and unavailable all the time. Sometimes a child could be added to the Pub and left there for years at a time. The pub in mind is printed by the client. Other pubs are printed Daily and the child might appear once. Other pubs might be say a Monday night spot on the news. Most are Websites and therefor being updated constantly. without publication date. so I guess I'm trying to cut corners by putting it all in the same table. but seance I'm now working that backwards overtime for free I'm trying to cut as many corners as possible. On 1/12/07, Teddy Payne [EMAIL PROTECTED] wrote: I put in the ID fields on the bridge tables to give the relationships a unique key for ease of querying. I guess I am just lazy. =) Teddy On 1/12/07, Deanna Schneider [EMAIL PROTECTED] wrote: That's essentially what I was saying, Teddy just did a better job of articulating the details. (Whether or not you need periodicalissueid and periodicalChildId is a matter of style. I tend not to do that and just use the composite ID's instead.) On 1/12/07, Teddy Payne [EMAIL PROTECTED] wrote: I would agree with Deanna. That is a necessary step, but then I would suggest normalizing one step further. tbl_Children (childID, ...) tbl_Periodical (periodicalID, ...) tbl_PriodicalIssue (periodicalIssueID, month, year, periodicalID) tbl_PeriodicalChild (periodicalChildID, childID, periodicalIssueID) You want to avoid duplicate information about a Periodical, so you create a table that keeps track of every issue that has been published. Now you have a table that will avoid duplicates of periodicals and children. Teddy ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266473 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
grouped output and Mod 2
Im trying to make a table output grouped query info. Then i want to make a 2 column list of the grouped data within. Dynamically generating the Tr's in the right spots. I'm finding that using MOD wont work because i never know where ill be starting the row at after the title Any thoughts? cfquery name=Services datasource=#DSN# username=#dbusername# password=#dbpassword# Select TYPE, NAME, ID from BUSINESS Order by TYPE ASC /cfquery table cfoutput query=Services group=TYPE tr th colspan=2 class=title #TYPE# /th /tr cfoutput cfif Services.currentrow mod 2 eq 1 tr /cfif td #NAME# /td cfif Services.currentrow mod 2 eq 0 tr /cfif /cfoutput /cfoutput /table -- -- Richard Dillman [EMAIL PROTECTED] (317) 916-8341 If you want happiness for an hour -- take a nap. If you want happiness for a day -- go fishing. If you want happiness for a month -- get married. If you want happiness for a year -- inherit a fortune. If you want happiness for a lifetime -- help someone else. -- Chinese proverb -- ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264846 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: grouped output and Mod 2
geee i feel dumb now Backing away from the keyboard. On 12/21/06, Charlie Griefer [EMAIL PROTECTED] wrote: set a counter var and increment it inside the inner cfoutput cfoutput group=foo cfset counter = 0 / cfoutput !--- begin inner cfoutput --- cfset counter = counter + 1 / cfif counter MOD 2 EQ 0 do stuff cfelse do other stuff /cfif /cfoutput /cfoutput On 12/21/06, Richard Dillman [EMAIL PROTECTED] wrote: Im trying to make a table output grouped query info. Then i want to make a 2 column list of the grouped data within. Dynamically generating the Tr's in the right spots. I'm finding that using MOD wont work because i never know where ill be starting the row at after the title Any thoughts? cfquery name=Services datasource=#DSN# username=#dbusername# password=#dbpassword# Select TYPE, NAME, ID from BUSINESS Order by TYPE ASC /cfquery table cfoutput query=Services group=TYPE tr th colspan=2 class=title #TYPE# /th /tr cfoutput cfif Services.currentrow mod 2 eq 1 tr /cfif td #NAME# /td cfif Services.currentrow mod 2 eq 0 tr /cfif /cfoutput /cfoutput /table -- -- Richard Dillman [EMAIL PROTECTED] (317) 916-8341 If you want happiness for an hour -- take a nap. If you want happiness for a day -- go fishing. If you want happiness for a month -- get married. If you want happiness for a year -- inherit a fortune. If you want happiness for a lifetime -- help someone else. -- Chinese proverb -- ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264857 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
prefered framework
Ok so our benifactor wish us to learn a framework and hes not too shy on cash. What would you as the comunity suggest is the most widely used of all the ones out there. Widely used = more info = shallower learning curve. I didnt find much when searching so if its been hashed before just ping me a link. thx guys/gals -- -- Richard Dillman [EMAIL PROTECTED] (317) 916-8341 If you want happiness for an hour -- take a nap. If you want happiness for a day -- go fishing. If you want happiness for a month -- get married. If you want happiness for a year -- inherit a fortune. If you want happiness for a lifetime -- help someone else. -- Chinese proverb -- ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264685 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: prefered framework
To be honest building in a framework into this is beyond me as the app is over a year old now! but he herd the word framework and said lets buy one and experiment! Well im all for learning new stuff. But as it stainds, its just me and another guy, we went from HTML to CFML back in '02 Its mostly become a big contact management app with other specialized bits here n there. On 12/20/06, Bryan Stevenson [EMAIL PROTECTED] wrote: my own ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264690 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Cfqueryparam and a list
I have a URL value passing to a Cfquery cfquery name=CheckFam datasource=#DSN# username=#dbusername# password=#dbpassword# SELECT ID, Child, Family FROM CFX_Family_Members WHERE (Family = cfqueryparam value=#URL.ID# cfsqltype=CF_SQL_INTEGER) /cfquery then dump the ID's to a Valuelist to be used in the next query cfset kidlist = ValueList(CheckFam.Child) / cfquery name=names datasource=#DSN# username=#dbusername# password=#dbpassword# SELECT REC_ID,CHILD_ID,FIRSTNAME FROM Children where REC_ID IN(#kidlist#) /cfquery The *BIG* Question is do I need to use a cfqueryparam in the second query, and IF I do, how would I put the info into it IE what cfsqltype? -- -- Richard Dillman [EMAIL PROTECTED] (317) 916-8341 If you want happiness for an hour -- take a nap. If you want happiness for a day -- go fishing. If you want happiness for a month -- get married. If you want happiness for a year -- inherit a fortune. If you want happiness for a lifetime -- help someone else. -- Chinese proverb -- ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262488 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 and a list
WOW something new every day... never knew about LIST THANKS a ton Guys/Gals! On 12/1/06, Dave Watts [EMAIL PROTECTED] wrote: The *BIG* Question is do I need to use a cfqueryparam in the second query ... Yes, you do. Any time you take data from the browser and use it in an SQL statement, you need to use CFQUERYPARAM. and IF I do, how would I put the info into it IE what cfsqltype? You'd use whatever datatype the column value should be - in this case, REC_ID is presumably an integer. You will also need to use the LIST attribute of CFQUERYPARAM: WHERE REC_ID IN (cfqueryparam cfsqltype=cf_sql_integer value=#kidlist# list=yes Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262495 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 and a list
Yes combining the queries is the ultimate answer. i was just in the beginnings of building this when i noticed that LIST problem and assumed at some point ill need to know how to do that. Silly me never even noticed that check box. Ill most likely move it all off to a stored proc anyway. I will ultimately need to be able to create delete add too and subtract from families as children come and go from the system and or perpetrate or get perpetrated upon by other siblings. Sad but its the nature of this business. On 12/1/06, Dave Watts [EMAIL PROTECTED] wrote: However, I'd be interested to see if this reported performance gain is really that big. The answer is, it depends. That is, I've seen several specific cases where it was no faster, or where it was slower, to use CFQUERYPARAM than not to. However, in the aggregate of cases I've seen, it's usually enough faster to warrant doing it generally to improve performance (without measuring specific cases). Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262548 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: FCKEditor (Things to watch out for?)
yes the paste from word option blows. It was the primary reason i needed to use it but check CFLIB they have better functions for cleaning that up. On 11/21/06, Claude Schneegans [EMAIL PROTECTED] wrote: I am getting ready to use FCKEditor in an e-commerce application, and was wondering what pitfalls If you are ready to have the users upload images to the directory built in FCKE, then fine, but if your application is already using some other, then prepare yourself to a painful journey in WMISWICB code (why-make-it-simple-when-it-can-be-complicated) Also, there is a so called filter to clean up content pasted from MSWord, but first it could be more efficient, secondly, it should be possible to use it for standard paste, not as a special option users don't know about, don't understand and finaly don't use. (SOUDKADUAFDU ;-) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261509 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Mixing CF and JavaScript.
Heres my .02 Do an iframe with the variable in the Url of the iframe. Do an onblur event on the field to reload the iframe. Put your Query and Display element in the iframe. I say this because if your doing a query on a DB with millions of records an aray might not be a good idea.? I use that approach for my data entry people for Addresses on the Zip Code to get County Contact info. On 11/14/06, Charlie Griefer [EMAIL PROTECTED] wrote: I think for a guy who's on day 5...all that analogy is going to do is make him more confused and hungry for cake. On 11/14/06, Dan Plesse [EMAIL PROTECTED] wrote: I reviewed every one's response so far and I did like a single one. I would use a bakery analogy. For example CF is like a cake it gets baked first then the sweet buttery javascript icing goes last. The two don't mix well. To cut the layers you need a fork called AJAX bla bla bla. What you need to do is change things around and make Javascript into a cake too and CF the cake next to your new js cake of pure icing. When people eat your cake they dream of eating the CF cake. Those wishfull day dreams are called HXMLHttpRequest bla bla bla because JS longs to be a reasonable cake. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260437 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Question regarding my first consulting job
I'm in Indianapolis, IN and charge $55.00 per hour for web/database work. A big pitfall is not charging for phone time. I grant all clients a 10 min break. On the first call of the day. after that I bill in 15 min blocks at the full rate. Put it in the contract or you will get inundated with calls. Ask for a single point of contact or your gonna get 2 people with 2 viewpoints and one will be claiming you didn't build what they asked for. ABSOLUTELY ask for 1/2 up front, yes projects do get cut short. IF you put testing pages on your own server bill for the power and Internet fees. Those things are not free and the client knows it. On 11/13/06, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: Eh.. Access *is* a relational DB? Albeit a desktop one. .. This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -Original Message- From: Mark Leder To: CF-Talk Sent: Sun Nov 12 23:38:20 2006 Subject: RE: Question regarding my first consulting job Rate? I am thinking of charging $60 / hour for development Depends where you are. $60 is too low in my estimation, if you're in the US. Should I ask for 20% ahead of time, or just wait till completion for payment? Get minimum 50% up front before you move a mouse. This keeps people from pulling the plug without you getting paid for work already completed. Should I setup a visual structure first Yes, mapping the business process first is always a good idea - clarifies everyone's thinking and eliminates a bunch of rewrites. convert his access DB to SQL? Absolutely, get it out of Access and into a relational db. Thanks, Mark ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260229 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 Question
Just off hand what is the advantage of CFEclipse? I can make easy shortcuts in dreamweaver for nearly anything like *ctrl+Q* to insert: !---This is a query coment --- cfquery name= datasource=#DSN# username=#dbusername# password=#dbpassword# Select * from [Table] Where (0=0) /cfquery Or is there a conversation we've already had you all can point me too? Granted Dreamweaver outa the box is a bit of a resource hog untill you turn off some stuff. but once ya have it under controll it does everything i need so far. On 11/12/06, Rob Wilkerson [EMAIL PROTECTED] wrote: On 11/12/06, Rick Root [EMAIL PROTECTED] wrote: Rob Wilkerson wrote: I don't understand why the use of keyboard shortcuts is hindering your adoption of CFEclipse. I'm also a keyboard shortcut junkie and CF/Eclipse offers me every bit of functionality I could ask for. And it's just as configurable. There may some shortcuts that are not available and/or some that are available that weren't in Homesite+, but on the whole I've been extremely happy with those offered/available in CF/Eclipse. The keyboard shortcut issue is really just part of it. I have a problem going between the project based structure of eclipse and the file based structure of homesite. Yeah, that still bothers me from time to time. It's definitely an adjustment, but I've learned to handle it okay. And it even offers a few advantages that are occasionally helpful. I also don't like the way ctrl-tab works in cfeclipse. I find myself using Homesite's extended find and extended find/replace feature *ALL* the time. I'm not even sure cfeclipse has that kind of functionality. Ctrl+H provides that option with even more capability. Search a resource, a project or a workspace. Pretty flexible. Plus regex search and replace. Someone mentioned that HS+ offered that, but I had never realized it. I'm sure it's mostly just a learning curve thing. I know I *SHOULD* be using cfeclipse, and I'm getting closer (because I essentially *MUST* use eclipse for flex apps).. I'm not sure it's a normative question like that. Should or shouldn't isn't really an issue when you have options. Whatever works for you is what you should be using. I switched primarily because I wanted to use the same IDE in my windows, linux and mac desktop environments. Otherwise, HS+ was meeting all of my needs. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260115 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 Question
I could list a few but these guys did a great job. http://sniptools.com/tipstricks/speed-up-dreamweaver-mx-some-performance-boosting-tips On 11/12/06, Dawson, Michael [EMAIL PROTECTED] wrote: Thanks. I didn't know about the file types tip. It seems to have helped a bit when selecting large amounts of text quickly. M!ke -Original Message- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: Sunday, November 12, 2006 6:30 PM To: CF-Talk Subject: Re: Code Question Damn, I need to go back to school and learn how to spell...or type :) D.B. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260137 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Hostmysite unsupported tags, functions etc
FAQ http://hostmysite.com/support/cfusion/cf-faq/ *Question:* What tags are disabled? *Answer:* CFContent and CFObject are disabled on CF 5.0. A workaround for CFContent can be found at How do I use CFContent on a ColdFusion 5 Server?http://hostmysite.com/support/cfusion/cfcontent/. A workaround for CFOBject can be found at How do I use CFObject on a ColdFusion 5 server? http://hostmysite.com/support/cfusion/cfobject. CFRegistry and CFExecute are disabled on all of our ColdFusion servers, regardless of the version. What CFX Tags are available to me? http://hostmysite.com/support/cfusion/cftags/ I use them and they are very accomidating for CFX UDF. Just ask them what tags are enabled on the server you are asigned too. They add new tags all the time. On 11/2/06, Michael E. Carluen [EMAIL PROTECTED] wrote: cfregistry and cfexecute -Original Message- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: Thursday, November 02, 2006 11:32 AM To: CF-Talk Subject: OT: Hostmysite unsupported tags, functions etc I have looked over Hostmysite and cannot find what tags, functions that they do not allow. Could someone here that uses them let me know what limitations I would have with their hosting? Thanks Alot Doug B. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258911 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFCHART and all its goodness confused....
Im attempting a couple things so i have a coule questions 1 IS it possible to do an IIF inside the Series color? I have a chart that is a bar chart shoing children who recieved inqueries and id like to color their bars pink/blue based on gender. 2. How do i get the labels to show for EVERY item in the list. right now its showing every 10th im assuming because of lineheight. but even changing font size to 6 point i get every 4th one. Any Thoughts? here is what i get with the fololowing code http://www.webintegrity.us/GraphData.jpg cfquery name=ParentSums datasource=#DSN# username=#dbusername# password=#dbpassword# SELECT COUNT(Correspondence.CorrespondenceChildID) AS callcount, Correspondence.CorrespondenceChildID, tbl_Children.CHILD_ID, tbl_Children.FIRSTNAME, tbl_Children.SEX FROM Correspondence LEFT OUTER JOIN tbl_Children ON Correspondence.CorrespondenceChildID = tbl_Children.REC_ID WHERE (Correspondence.CorrespondenceDate = cfqueryparam value=#Startdate# cfsqltype=CF_SQL_DATE /) AND ( Correspondence.CorrespondenceDate = cfqueryparam value=#Enddate# cfsqltype=CF_SQL_DATE /) AND (Correspondence.CorrespondenceChildID IS NOT NULL) GROUP BY Correspondence.CorrespondenceChildID, tbl_Children.CHILD_ID, tbl_Children.FIRSTNAME, tbl_Children.SEX ORDER BY Correspondence.CorrespondenceChildID /cfquery cfchart format=flash chartheight=1000 chartwidth=500 showxgridlines=no showygridlines=no showborder=no fontbold=no fontitalic=no labelformat=number show3d=yes rotated=no sortxaxis=yes showlegend=yes tipstyle=MouseOver tipbgcolor=##CC showmarkers=no style=default backgroundcolor = ##37b2fb cfchartseries type=horizontalbar query=ParentSums itemcolumn=CHILD_ID valuecolumn=callcount serieslabel=CHILD_ID seriescolor=#IIF(SEX is 'Female', de('red'), de('blue'))# paintstyle=raise / /cfchart DATA Jan 01, 2005 *Through* Feb 01, 2005 Child ID Name Inqueries 1770B Mia 1 3103 Robert 1 3229 Trevia 1 3354A Precious 6 3354B Judas 1 3360 Randy 3 3404A Damar 3 3411A Keontaye 3 3030 Kyle 2 3429A Sarah 1 3442 Shawn 5 3466 Michael 2 3482 Chris 1 3489 Craig 2 3494 Keith 1 3496 Christopher 2 3498 Teleatha 2 3503 Dartangan 1 3507A Garrett 7 3510 Manny 16 3516 Nicole 3 3518 Jessica 5 3519 Christopher 3 3522D Isaac 1 3524B Jose 1 3525 Katrina 1 3527A Susie 3 3530 Jason 1 3531A Lukas 3 3531B Vincent 1 3534 Dana 1 3535A Monea 1 3535C Michelle 2 3537 Maxwell 1 3538 Adam 1 3539A Dezaraye 11 3539B Samantha 1 3541A Anita 19 3541B Mauda 7 3541C Rosa 2 3541D Oscar 2 3078 Trevor 3 3395 Melissa 6 3397 Johnathan 1 3420 Brea 1 3450A Gininia 1 3522B Shena 1 3532 Kenny 5 Grand Total 149 -- -- Richard Dillman [EMAIL PROTECTED] (317) 916-8341 ...the very powerful and the very stupid have one thing in common, they don't alter their views to fit the facts, they alter the facts to fit the views. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258061 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Reports and Creative Clients
Thanks for that heads up, and yes i could do that and probably should for this user anyway But for the most part these users are also class givers and are spread out a lot sometimes traveling with their laptops sometimes working from home. sometimes lecturing where they dont have controll over the PC. So i'd really need to do something web based. On 10/14/06, Dave Watts [EMAIL PROTECTED] wrote: I want to have a page that displays all the various tables in my clients database (sql2005) and allow them to create their own reports. the person doing this is very good with access and building reports and fairly good with a query builder so i could do linked tables to access, but i dont want to give them the option to Insert, Update or delete. Any CF options or Thoughts? If you can get them direct access to the database, you could create a user account with limited rights - in the case of SQL Server, that would be a user account with the database role db_datareader and no other rights (revoked from public, for example). Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256819 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Reports and Creative Clients
Wondering if something like this already exists. I want to have a page that displays all the various tables in my clients database (sql2005) and allow them to create their own reports. the person doing this is very good with access and building reports and fairly good with a query builder so i could do linked tables to access, but i dont want to give them the option to Insert, Update or delete. Any CF options or Thoughts? Were hosted at Hostmysite if it matters. -- -- Richard Dillman [EMAIL PROTECTED] (317) 916-8341 ...the very powerful and the very stupid have one thing in common, they don't alter their views to fit the facts, they alter the facts to fit the views. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256795 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Money no Object - Best Online Editor for dealing with cut'n p aste from Word
I once had a client that provided me a cell phone so they could have 24/7 access and then put me on a 600 / week retainer just in case...I got one call a week at most Sometimes its good sometimes its not. On 10/13/06, Andy Matthews [EMAIL PROTECTED] wrote: Is this a freelance client? I hope you're kidding about them calling you in the evenings. Sounds like you need to stomp their necks once or twice to get them in line. No client should have that sort of power over you. !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Thursday, October 12, 2006 5:58 PM To: CF-Talk Subject: Re: Money no Object - Best Online Editor for dealing with cut'n p aste from Word I can't help with your technical problem, but in my experience it is impossible to keep lawyers happy. The good thing about this client is that they have bottomless pits for pockets and don't mind paying whatever to get something they want. The bad thing about this client is that the phone can ring almost 24/7 and they want whatever it is YESTERDAY - regardless of whatever else you're working on at the moment - including other clients, meals, sleep, or any other aspect of trying to have a normal life!! LEAVE ME ALONE!!! I'M TRYING TO WATCH 'LAW AND ORDER'!! almost works, but not quite. They know it will come on again somewhere in syndication! ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256692 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Money no Object - Best Online Editor for dealing with cut'n p aste from Word
it was durring the first implamentation of their program. They were pretty stressed that things wold blow up. but nice money for a couple months. On 10/13/06, Andy Matthews [EMAIL PROTECTED] wrote: That's pretty nice money for one call a week. !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Richard Dillman [mailto:[EMAIL PROTECTED] Sent: Friday, October 13, 2006 10:56 AM To: CF-Talk Subject: Re: Money no Object - Best Online Editor for dealing with cut'n p aste from Word I once had a client that provided me a cell phone so they could have 24/7 access and then put me on a 600 / week retainer just in case...I got one call a week at most Sometimes its good sometimes its not. On 10/13/06, Andy Matthews [EMAIL PROTECTED] wrote: Is this a freelance client? I hope you're kidding about them calling you in the evenings. Sounds like you need to stomp their necks once or twice to get them in line. No client should have that sort of power over you. !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Thursday, October 12, 2006 5:58 PM To: CF-Talk Subject: Re: Money no Object - Best Online Editor for dealing with cut'n p aste from Word I can't help with your technical problem, but in my experience it is impossible to keep lawyers happy. The good thing about this client is that they have bottomless pits for pockets and don't mind paying whatever to get something they want. The bad thing about this client is that the phone can ring almost 24/7 and they want whatever it is YESTERDAY - regardless of whatever else you're working on at the moment - including other clients, meals, sleep, or any other aspect of trying to have a normal life!! LEAVE ME ALONE!!! I'M TRYING TO WATCH 'LAW AND ORDER'!! almost works, but not quite. They know it will come on again somewhere in syndication! ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256707 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Cfqueryparam use
I know that a pounded variable in a cfuery alwasy should be cfqueryparam'd And ive herd it actually makes the Query run faster. but what about non pounded variables take the folowing query: cfquery name=ListFams datasource=#dsn# username=#dbusername# password=#dbpassword# SELECT Child_ID, Firstname, sibs FROM tbl_children WHERE DispWithFamily = 1 and Availability = 1 AND sibs = cfqueryparam value=#form.sibs# cfsqltype=CF_SQL_INTEGER / ORDER BY sibs DESC /cfquery Would the query gain a speed benifit like this? cfquery name=ListFams datasource=#dsn# username=#dbusername# password=#dbpassword# SELECT Child_ID, Firstname, sibs FROM tbl_children WHERE DispWithFamily = cfqueryparam value=1 cfsqltype=CF_SQL_TINYINT / AND Availability = cfqueryparam value=1 cfsqltype=CF_SQL_TINYINT / AND sibs = cfqueryparam value=#form.sibs# cfsqltype=CF_SQL_INTEGER / ORDER BY sibs DESC /cfquery hard to tell with only 400 records,,, but in a years time this table should be upwards of 300,000 records so every bit of speed i can get... -- -- Richard Dillman [EMAIL PROTECTED] (317) 916-8341 ...the very powerful and the very stupid have one thing in common, they don't alter their views to fit the facts, they alter the facts to fit the views. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256379 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: limiting output of text
www.cflib.org has a UDF called *FullLeft(str, count) * allows you to do a left on a string and only trim at the end of whole words. Some how i see triming at the last word being the next question :-) On 10/8/06, Denny Valliant [EMAIL PROTECTED] wrote: Heh. I don't know why I don't like cfif len(something) in the same manner I don't like cfif recordcount, but anywayze... ;-] cfset dis_reward_description = Replace(Trim(reward_description), Chr(10),br / ,ALL) cfif len(dis_reward_description) gt 97 #left(dis_reward_description,97)#... cfelseif len(dis_reward_description) gt 0 #dis_reward_description# /cfif And you may consider a fixed-width font so the kerning(sp?) doesn't defeat this attempt at making things even. I left the query name off, as it maybe should be, so long as it's in the main query loop. Otherwise, you'd want someQ.someField[someQ.currentrow], I think. I don't know. I'm not the best practicer of scoping by a long shot. Hehehe, -Denny On 10/8/06, terry yee [EMAIL PROTECTED] wrote: Hi, Am calling text from datasource and need to display only a small portion of it. ie. first 100 characters etc.. my code: cfif len(getRewards.reward_description) #Replace(Trim(getRewards.reward_description), Chr(10), br , ALL)# /cfif cheers terry ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255938 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
select lists with reitred members
Heres the situation. I have a CrosJoin table to track what offices each contact holds within each county. (CFX_COUNTY_CONTACT) I have a query to pull all the current Special Needs Assessment Personel to populate a Pulldown menu. (ListSNAP) I have a Query to pull the child and all their various county associated personel. (ListChild) I have a pulldown menue to select a contact for this position from the people that are currently in office. (ListCaseworker) And last im populating the top name in the pulldown with their SNAP IF they are no longer in the Active list of personel. Is this over complicated? It seems there ought to be an easier way to do this. Granted listchild is really a stored procedure with 11 left outer joins to other information as are the other queries, so i wonder if there would be an easier way to insert this option tag into the select list. Or maybe ive just been stairing at it too long! cfquery name=ListChild datasource =#DSN# username=#dbusername# password=#dbpassword# SELECT tbl_Children.FIRSTNAME, tbl_Children.LASTNAME, tbl_Children.SNAP_INITIALS, tbl_CONTACT.FNAME, tbl_CONTACT.LNAME, tbl_CONTACT.CONT_ID FROM tbl_Children LEFT OUTER JOIN tbl_CONTACT ON tbl_Children.SNAP_INITIALS = tbl_CONTACT.CONT_ID WHERE tbl_Children.REC_ID = cfqueryparam cfsqltype=cf_sql_integer value=#url.ID# null=no / /cfquery cfquery name=ListSNAP datasource =#DSN# username=#dbusername# password=#dbpassword# cachedwithin=#CreateTimeSpan(0,2,0,0)# SELECT DISTINCT tbl_CONTACT.LNAME + ', ' + tbl_CONTACT.FNAME AS Name, tbl_CONTACT.CONT_ID FROM CFX_COUNTY_CONTACT LEFT OUTER JOIN tbl_CONTACT ON CFX_COUNTY_CONTACT.Contact = tbl_CONTACT.CONT_ID WHERE (CFX_COUNTY_CONTACT.Roll = 3) ORDER BY Name DESC /cfquery cfquery dbtype=query name=retire SELECT CONT_ID FROM ListSNAP WHERE (CONT_ID = #ListChild.SNAP_INITIALS#) /cfquery cfform labelChild: /labelcfoutput#ListChild.FirstName# #ListChild.LastName#/cfoutput br / labelSnap Coordinator: /label cfselect name=SNAP_INITIALS id=SNAP_INITIALS required=yes message=You must select a Snap from the Dropdown. multiple=no query=ListSNAP value=Cont_ID display=NAME queryPosition=below selected=#ListChild.SNAP_INITIALS# option--- New Snap ---/option cfif NOT retire.recordcount cfoutput option selected=selected value=#ListChild.SNAP_INITIALS# style=background-color:##FFCCFF; font-weight:bold; #ListChild.lname#, #ListChild.fname# - RETIRED! /option /cfoutput /cfif /cfselect /cfform -- -- Richard Dillman [EMAIL PROTECTED] (317) 916-8341 ...the very powerful and the very stupid have one thing in common, they don't alter their views to fit the facts, they alter the facts to fit the views. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255692 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Stored Procedure Cached
Im using SQL Server 2005 over at Hostmysite I have a stored procedure: cfstoredproc procedure = GetFosterFamily datasource = #DSN# username=#dbusername# password=#dbpassword# cfprocparam type=Out cfsqltype = CF_SQL_INTEGER dbvarname=@ID value=#URL.ID# null=no cfprocresult name = GetContactDetails /cfstoredproc Ive had to make a change in the way the procedure works and it resulted in removing 3 left outer joins (Snoopy Dance) now im getting an error 52=52 what the heck? from what i can tell the old procedure is being stored somewhere. Rebooting my test server cures the problem, but i cant reboot HMS's server. Any thoughts how i can fix this without renaming my procedure and also renaming it in 40 pages? -- -- Richard Dillman [EMAIL PROTECTED] (317) 916-8341 I think it's T double-E double-R double-R double-I double-F double-I double-C, C, C. - the Goose in 'Charlotte's Web' ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255473 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Stored Procedure Cached
Its Hostmysite.com's server so no. On 10/4/06, Christine Davis [EMAIL PROTECTED] wrote: Connection Pooling in the Datasource generally returns that error when it expects a different column total. Can you turn off connection pooling for that Datasource? Thanks! Christine Davis ColdFusion Lead Nations Technical Services Prairie Village, KS 913-748-8044 ext 4703 [EMAIL PROTECTED] -Original Message- From: Richard Dillman [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 04, 2006 12:43 PM To: CF-Talk Subject: Stored Procedure Cached Im using SQL Server 2005 over at Hostmysite I have a stored procedure: cfstoredproc procedure = GetFosterFamily datasource = #DSN# username=#dbusername# password=#dbpassword# cfprocparam type=Out cfsqltype = CF_SQL_INTEGER dbvarname=@ID value=#URL.ID# null=no cfprocresult name = GetContactDetails /cfstoredproc Ive had to make a change in the way the procedure works and it resulted in removing 3 left outer joins (Snoopy Dance) now im getting an error 52=52 what the heck? from what i can tell the old procedure is being stored somewhere. Rebooting my test server cures the problem, but i cant reboot HMS's server. Any thoughts how i can fix this without renaming my procedure and also renaming it in 40 pages? -- -- Richard Dillman [EMAIL PROTECTED] (317) 916-8341 I think it's T double-E double-R double-R double-I double-F double-I double-C, C, C. - the Goose in 'Charlotte's Web' ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255482 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How do I disable view source?
Now i wanna know how to disable my users Keyboard and mouse!!! Hell lets disable the user!! On 10/4/06, Dave Francis [EMAIL PROTECTED] wrote: Stop writing code that you're ashamed of ;) -Original Message- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 04, 2006 12:41 PM To: CF-Talk Subject: How do I disable view source? Hey, Now I'm tryin' to disable the view source in the browser. I don't want anyone to see my generated html. Anyone have any ideas on this one? Thanks, Will ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255483 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: open new window
Not strictly an answer but if pages are going to be refreshing and submitting and you need side by side comparrison. Why not make it a frames page? On 10/3/06, Richard White [EMAIL PROTECTED] wrote: thanks teddy ill check it out ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255303 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Negative and positive
cfquery name=name datasource=#dsn# INSERT INTO Stock VALUES (#Form.Item_ID#, '-#Form.ammount#',) /cfquery On 9/17/06, Chad Gray [EMAIL PROTECTED] wrote: I am working on an inventory system where people put in a number of items that are being taken out of inventory and put into inventory. The users are entering positive numbers. I need to store the number as a negative in the database if inventory is being removed. How do I convert the number they enter to a negative before I insert it into the database? I am sure it is something simple I am just a little burnt out. Thanks! ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253376 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Ideas please!!
place the time in an iframe with a meta refresh set at 15 seconds On 9/14/06, Che Vilnonis [EMAIL PROTECTED] wrote: Ajax or Flex might work. -Original Message- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: Thursday, September 14, 2006 9:15 AM To: CF-Talk Subject: Ideas please!! I have been trying to fugure something out that is simply eluding me. My app is an auction, and what I am trying to do is have it where when somebody bids on an item say within 2 minutes of auction close, the auction time is is increased by 5 minutes. I am pretty sure I have that part figured out by doing a scheduled task and having it run once a minute. The part I am trying to figure out, is displaying the new auction time to the browser without refreshing the page. Is this possible? How can it be done if it is? Thanks Doug ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253100 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SOT HTML Select
Correct me if im wrong but I think what chad wants to do is use the Dropdown as an Insert query,,, I see this a lot in Filemaker apps. the field is a textbox, but if you type into it the dropdown appears and jumps to the position your typeing much like a regular dropdown only allowing you to type more than one character...sorta like haveing the Dropdown in a hidden div below a textbox...and the preselection being a Where selected is like 'form.textbox% ' BUT if the final solution you type is not in the list it is ADDED via Insert... I havent seen an animal like this ,,, but now i really wanna go code something like it!! On 9/11/06, Larry Lyons [EMAIL PROTECTED] wrote: With Windows applications I have seen where select boxes or drop down boxes you can Type information into the field or use the drop down to select a record. Can this be done with the HTML select tag? This way the user could enter information that does not already exist in the select. Using a mixture of CSS and Javascript you should be able to do it. Selene Bainum has an example of the code at her webtricks.com site: http://www.webtricks.com/sourcecode/code.cfm?CodeID=14 hth, larry -- Larry C. Lyons Web Analyst BEI Resources American Type Culture Collection http://www.beiresources.org email: llyons(at)atcc(dot)org tel: 703.365.2700.2678 -- ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252792 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SOT HTML Select
ok guess i was wrong ,,, http://www.interaktonline.com/demos/MXWidgets/allwidgets/mxw3_editable_dropdown.php does exactly what i was talking about... my partner in crime pointed it out... Anyone done anything like this in CF? On 9/11/06, Richard Dillman [EMAIL PROTECTED] wrote: Correct me if im wrong but I think what chad wants to do is use the Dropdown as an Insert query,,, I see this a lot in Filemaker apps. the field is a textbox, but if you type into it the dropdown appears and jumps to the position your typeing much like a regular dropdown only allowing you to type more than one character...sorta like haveing the Dropdown in a hidden div below a textbox...and the preselection being a Where selected is like ' form.textbox%' BUT if the final solution you type is not in the list it is ADDED via Insert... I havent seen an animal like this ,,, but now i really wanna go code something like it!! On 9/11/06, Larry Lyons [EMAIL PROTECTED] wrote: With Windows applications I have seen where select boxes or drop down boxes you can Type information into the field or use the drop down to select a record. Can this be done with the HTML select tag? This way the user could enter information that does not already exist in the select. Using a mixture of CSS and Javascript you should be able to do it. Selene Bainum has an example of the code at her webtricks.com site: http://www.webtricks.com/sourcecode/code.cfm?CodeID=14 hth, larry -- Larry C. Lyons Web Analyst BEI Resources American Type Culture Collection http://www.beiresources.org email: llyons(at)atcc(dot)org tel: 703.365.2700.2678 -- ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252793 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 chat down?
yea just log out and back in. should take care of it. On 9/5/06, James Holmes [EMAIL PROTECTED] wrote: I did - I logged into gmail again and now it's ok. On 9/5/06, Matt Williams [EMAIL PROTECTED] wrote: Any other gmail users see this message where thier quick contact list should be? We're experiencing technical difficulties that may prevent your chats from being sent. I've been getting it for a day and a half or so. Just wanted to see if it was me or not. -- Matt Williams It's the question that drives us. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252171 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
could always wrap some CSS around it but it has to be lower case to begin with for CSS to work. span style=text-transform:capitalize#LCASE(FNAME)# /span im sure there are other things in UDF's out there but it always winds up in a discussion of McDonald and such type of mixed case names. And to be honest, most of my people dont care much about that. I always insert everything lower case makes formatting easier later. On 8/28/06, Andy Matthews [EMAIL PROTECTED] wrote: I'm sure there's a function on www.cflib.org that would suit your needs. !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Jenny Gavin-Wear [mailto:[EMAIL PROTECTED] Sent: Friday, August 25, 2006 9:04 PM To: CF-Talk Subject: Case I've seen the ucase and lcase functions, but is there anything to capitalize a string that is already u/l case? Thought I saw something in the list a while back, but can't find it. Thanks, Jenny -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.405 / Virus Database: 268.11.6/428 - Release Date: 25/08/2006 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251277 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Cross Joins and lists and forms oh my!
Test page is up and working great . As this is an info window for the data entry person. the Div updates onblur so just tab or click out of the text box for your info. http://www.webintegrity.us/zipcode/ Thanks for all the help guys! -- -- Richard Dillman [EMAIL PROTECTED] (317) 916-8341 I think it's T double-E double-R double-R double-I double-F double-I double-C, C, C. - the Goose in 'Charlotte's Web' ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251138 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Cross Joins and lists and forms oh my!
I usually use this Javascript but im not sure how effective it is... script language=JavaScript type=text/javascript !-- var contact = Indiana Adoption Program var email = adoption var emailHost = iquest.net document.write(a href= + mail + to: + email + @ + emailHost+ + contact + /a + .) //-- /script On 8/26/06, Denny Valliant [EMAIL PROTECTED] wrote: On 8/26/06, Richard Dillman [EMAIL PROTECTED] wrote: Test page is up and working great . As this is an info window for the data entry person. the Div updates onblur so just tab or click out of the text box for your info. That's pimping man! Nice. If it ends up on the public side anywhere, you may consider using a webform instead of listing the email addy's, as those spammers are relentless. I love the in-line-ness. Async ROCKS. /me holds up a 10 :DeN ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251172 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Cross Joins and lists and forms oh my!
All the contacts will be inside Indiana, USA so lets say Marion County will be split evenly between to people by a list of zipcodes where the zipcode range is in Indiana so 46001 - 48000 but sence they are in Marion County the list is 46107 - 46298 I definately see where a cCounty Coordinator will be county wide but a Training Coordinator could be at the city level so based on zipcode but not in every county. Does that help clear it up any? -- Richard Dillman [EMAIL PROTECTED] (317) 916-8341 I think it's T double-E double-R double-R double-I double-F double-I double-C, C, C. - the Goose in 'Charlotte's Web' ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251082 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Cross Joins and lists and forms oh my!
Oh God, I totally agree on these,,, this dang project has had so many acceptions to the rules and acceptions to their own exceptions. YEP I just found a Training Coordinator that is also the County Director, Child welfare Specialist and County Sherif!! And now some of the people im listing dont even work for the state, yep some of the training Coordinators are {{{COMPANIES}}} Ok! Ok,,, breath... breath... where's that Cuervo gold when I need it. On 8/25/06, Denny Valliant [EMAIL PROTECTED] wrote: On 8/25/06, Richard Dillman [EMAIL PROTECTED] wrote: ... I definately see where a cCounty Coordinator will be county wide but a Training Coordinator could be at the city level so based on zipcode but not in every county. Man, I love databases. Really you want to try to nail down this stuff using some ESP. If you are up on the content yourself ( internal workflow, etc.), you will be able to make some decisions that will simplify things down the road. Like, they'll say, County Coords do x and y and Training Coords do w and x, and forget to tell you that some people are both training coords AND county coords, so if you haven't thought about that possibility before-hand... it's harder. Recon. as much as possible before you even start wanking with table structs or user interfaces. Ask lots of Qs. The more you know, the less you work. Maybe. At any rate, here the zips span counties, so zips and couties are totally different, as far as a service area... e.g. zip != county nor vice versa. Sometimes it does, of course, but only sometimes. What I've done in the past is have a zip field, with a lookup button next to it that pulls the counties for that zip. You just need to be sure there is a clear difference between a county that is part of an address, and a county that is a service area or whatever. Or zipcode, if that's the service area. Bah. That paragraph made a ton of sense. Should be 3 pages or so, prolly. ;-) Stuff like this is where AJAX really shines... I used pop-up windows and JS back in the day, but I'd do it in a little DIV in a heartbeat now. Oh I love a slick UI, yes I do. But I like it all, really. Even cryptic, green-on-black... Could I make any less sense? Yeeeowzers. Well, hope it somehow helps. Can't see how, but, hey, I'll send it anywayz. :D ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251117 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SOT: Cross Joins and lists and forms oh my!
In my endevors to build this table structure for my Fostercare site we have a list of County Contacts spacific to each county. I have a cross join table to match county ID's, Contacts, County Rolls and weather they recieve emails. Of course now there is a snag and a spacific county wants to split up their county by zipcode. I do have a zipcode table with Zip, county, city, state, area code, daylight saveings time, and Time Offset. the long and short of it is i have 1032 zipcodes 93 Counties 10 Positions If i had to store a person who is over say 3 counties (which is 200+ zipcodes) how might i best go about inserting him and selecting the appropriate zipcodes? Same for someone who is over the North East Quardrant of a spacific County (just 5 zipcodes) Im leaning twards a Stored prcedure that will include all zips in a county and letting them select a whole county, and/or showing div to show checkboxes for all the zips in that county should they want a partial. What would any of you do in this case? /rant -- -- Richard Dillman [EMAIL PROTECTED] (317) 916-8341 I think it's T double-E double-R double-R double-I double-F double-I double-C, C, C. - the Goose in 'Charlotte's Web' ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251050 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Zipcodes addresses and all that jazz
So to clean up the addresses would you build an address form with: Number [ six digit textbox numeric only] Dir [ E.N.S.W. Dropdown] Street [ 30 character text box alpha only] Sufix [ Dropdown with the 25ish approved extensions] zipcode [ 5 digit numeric only] +4 [ 4 digit numeric only] What a nightmare for your data entry people. they already complain about my dropdowns for MR/Mrs Jr/Sr lol. where's the happy medium? On 8/17/06, Turetsky, Seth [EMAIL PROTECTED] wrote: Wanted to leave it open, as I may rather have driving distance in the future. But also, we want to do this for our UK offices as well. Seems at least M$'s mapping api's took postal code as well as zip. What would a table of worldwide postal/zip codes and lat/long cost? -Original Message- From: Russ [mailto:[EMAIL PROTECTED] Sent: Thursday, August 17, 2006 12:46 PM To: CF-Talk Subject: RE: Zipcodes addresses and all that jazz Why not just calculate it yourself? Get a table with lat and long, and use a function to calculate the distance. I found one fairly easy when I build something like this a while ago. -Original Message- From: Turetsky, Seth [mailto:[EMAIL PROTECTED] Sent: Thursday, August 17, 2006 9:11 AM To: CF-Talk Subject: RE: Zipcodes addresses and all that jazz Cool stuff. So with esri, can you do the routing without showing a map, ie for backend systems? I would like to get the estimated distance between two zip codes, store it in a table. And potentially do that for x number of records. -Original Message- From: Paul Hastings [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 16, 2006 10:32 PM To: CF-Talk Subject: Re: Zipcodes addresses and all that jazz Turetsky, Seth wrote: I don't know much about ESRI, but Microsoft allows to get driving directions and distance in their JS API(definitely free), google and yahoo(I believe) do not. M$'s other web service API(not sure about price), which I have not used and not sure if CF can use it, is also very extensive. To me, more impressive than google/yahoo. so does esri, though these are mostly proof-of-concept for flashforms (except the last one, we had a survey team's GPS die the backup didn't do projections): http://www.sustainablegis.com/projects/routing/ http://www.sustainablegis.com/projects/geocode/flashforms/ http://www.sustainablegis.com/projects/projection/gcs2utm.cfm esri's a *real* GIS company. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250181 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Zipcodes addresses and all that jazz
OK, to start off with I already a table with: -Zipcode, City, State, County, Country I currently do a check onblur from the zip field to see if I have a valid zip and display back in a div the city state and county info. I'd like to pass the address info to something like google Maps or Yahoo Maps and verify the address is entered correclty This is for a non proffit to check-in foster parents to training programs and such. Their volume is about 20 to 30 a day (new members). How can I go about this cheeply of even *free*? -- -- Richard Dillman [EMAIL PROTECTED] (317) 916-8341 I think it's T double-E double-R double-R double-I double-F double-I double-C, C, C. - the Goose in 'Charlotte's Web' ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250019 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Zipcodes addresses and all that jazz
we dont need a map, the Dataentry / Receptionist just needs some coaxing... to put in correct stuff like street direction sufix... If i got back a list of possible matches: I could wrap a link around it to repopulate the form. On 8/16/06, Paul Hastings [EMAIL PROTECTED] wrote: Turetsky, Seth wrote: I've been playing with Microsoft's Mappoint stuff lately, they offer a lot of stuff that Google does not. See http://dev.live.com/virtualearth/sdk/ shows some examples and the source of each. so does esri's webservices but you don't have to sell any of your children to use them. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250028 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Proper Case
Just wondering if there is an Easier way of doing these things. By default I submit all text fields to the DB: dbvalue = '#lcase(form.field)#' then with CSS Style my outputs as span style=text-transform:capitalize#dbvalue#/span for fields Like Name or Address... Is this the best way to be handling this? Or is their some way to pass the form field Value pre converted to Proper before it is inserted? I've burned by data entry ppl that suck before. -- -- Richard Dillman [EMAIL PROTECTED] (317) 916-8341 IF-THEN-ELSE its a way of life! ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:249058 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Proper Case
Joe I like your idea Ben mentioned Converting to Proper before Updating the DB SO: cfloop list=#structKeyList(form)# index=field cfset form[field] = CapFirst(Lcase(form[field]))/ /cfloop This works great. Using Lower case becuase CapFirst converts to upper but doesnt check for case in advance. This is going to be a global fix on several data entry forms. so I dont thing I care much about Mc Mac and Von in names at this point. the client didnt care about this bit, but addresses are a pet peeve of mine. thanks for all the help! Quote from this client Wouldn't the data entry go faster if the business name, address, City, State, ZIp, and Phone were just in the same field? You can parse that out later right? On 8/7/06, Joseph Lamoree [EMAIL PROTECTED] wrote: If you want to change the case of all the elements in the form structure, you could loop of them like so: cfloop list=#structKeyList(form)# index=field cfset form[field] = ucase(form[field])/ /cfloop Or, you could loop over a subset of field names just to modify the ones you want to change. -- Joseph Lamoree ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:249090 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Unofficial CF Developer Salary Survey
I think your right on the money with the Multiple Jobs. I cant think of anyone who could float as a CF developer that wasnt also a fairly decient SQL/DBA And/Or a Decient layout and Design person. And I do charge About $15 an hour more for SQL/DBA stuff than i do for the CFML, and $25 an hour more for Graphics/Photography. So im thinking $100k+/- in Indianapolis is just about right overall. pst of the designers i know are making at or just below that. On 8/1/06, Loathe [EMAIL PROTECTED] wrote: Johnny I'm not sure if your talking about yourself (one year) but you are one of best CF guys I know (man, I'm hoping this is the same Johnny I worked with for a minute over at the business center). If not, never mind :) -Original Message- From: Johnny Le [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 01, 2006 8:40 PM To: CF-Talk Subject: Re: Unofficial CF Developer Salary Survey I think it is safe to say that it is $210,000 since he owns his own business. Although that would bring the average salary and the salary of 7 years of experience up a lot. It looks like independent contractors make more money than full time people. Wonder what the average hourly rate is :-) So sad for those with 3 years of experience :-( Those with 1 year of experience rock! Johnny Johnny, Thanks for the catch. I added the 000. Not sure what to make of the 210. Should it be 210,000? I suppose it is possible if his/her hourly is $130. Matt On 8/1/06, Johnny Le [EMAIL PROTECTED] wrote: ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:248591 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Anyone see anything wrong with this code?
Definately use Cfqueryparam: CFQUERY Name=Get_Clients Datasource=#DSN# Select Client_ID, Client_First_Name, Client_Middle_Name, Client_Last_Name, Client_Name_Suffix, Client_Birthdate, Client_Street_Address, Client_City, Client_State, Client_Zip_Code from clients where Client_Birthdate = cfqueryparam cfsqltype=CF_SQL_DATE value= Form.Start_Date and Client_Birthdate = cfqueryparam cfsqltype=CF_SQL_DATE value= Form.End_Date /CFQUERY -- Richard Dillman [EMAIL PROTECTED] (317) 916-8341 IF-THEN-ELSE its a way of life! ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:248185 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: C3 page drafts
if your page is bigger than that then your not makeing good use of templates :-) On 7/28/06, Mark Drew [EMAIL PROTECTED] wrote: those 80 columns and 25 rows of goodness.. how could you go wrong?! On 7/28/06, Richard Dillman [EMAIL PROTECTED] wrote: all i can say is START - RUN - EDIT it doesnt get any betterand its available on every machine ive ever been on. On 7/28/06, Mark Drew [EMAIL PROTECTED] wrote: What is the best CF IDE? sheesh.. I think its textpad... isnt it? On 7/28/06, James Holmes [EMAIL PROTECTED] wrote: First drafts of the ColdFusion Community Consensus pages are now available for comment: http://www.bifrost.com.au/c3/ http://www.bifrost.com.au/c3/topic.cfm You can comment in-list or at the blog: http://www.bifrost.com.au/blog/index.cfm/2006/7/28/ColdFusion-Community-Consensus-page-layout-drafts -- CFAJAX docs and other useful articles: http://www.bifrost.com.au/blog/ ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:248035 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Sending Email from a valuelist.
you were right just me being over cautious and testing without sending the email yes it works fine. Odd that it doesn't display in the output tho. On 7/28/06, Ben Nadel [EMAIL PROTECTED] wrote: Check your source code after execution... I think the emails are showing up, but the HTML page is ignoring them as TAGS... If this is the case, the CFMail should work fine even if OUTPUT is not showing them??? I am not sure if you are saying the email is working already or not? ... Ben Nadel www.bennadel.com -Original Message- From: Richard Dillman [mailto:[EMAIL PROTECTED] Sent: Friday, July 28, 2006 12:00 PM To: CF-Talk Subject: Sending Email from a valuelist. to begin with I have a Query that pulls the first last names and email Addy as one field. then i pass that item to a value list for the TO field of my CFMAIL tag cfquery name=bosses datasource=#dsn# SELECT Firstname + ' ' + Lastname + ' ' + email + '' AS useremail FROM Security WHERE (access_level = 5) /cfquery cfmail To=#valueList( email.useremail, ',' )# from=#Session.useremail# Subject=#LetterID# cc= bcc= charset=utf-8 type=html mailerid=Microsoft Outlook, Build 10.0.3416 the output of this is simply a coma delimited list but its only seeing the first and last name and excluding the email portion. Bryan Anderson ,Richard Dillman Now if i do an Output of cfoutput #valueList( bosses.useremail, ',' )# /cfoutput I get Bryan Anderson ,Richard Dillman but if i do cfoutput query=bosses #useremail#br / /cfoutput I get Bryan Anderson [EMAIL PROTECTED] Richard Dillman [EMAIL PROTECTED] Any ideas how to get the value list to show the email in this format? PS: yes I could just dump email only, but the users really like seeing their names in there. -- -- Richard Dillman [EMAIL PROTECTED] (317) 916-8341 IF-THEN-ELSE its a way of life! ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:248042 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Sending Email from a valuelist.
ya know thats the way the file came to me,,,and I simply dont know why it was ever done that way. Must be an I cant see the forrest for all the trees thing. removing it now lol. On 7/28/06, Andy Matthews [EMAIL PROTECTED] wrote: Any reason you're using a value list instead of just looping over the query itself? !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: Friday, July 28, 2006 11:22 AM To: CF-Talk Subject: RE: Sending Email from a valuelist. Check your source code after execution... I think the emails are showing up, but the HTML page is ignoring them as TAGS... If this is the case, the CFMail should work fine even if OUTPUT is not showing them??? I am not sure if you are saying the email is working already or not? Ben Nadel www.bennadel.com -Original Message- From: Richard Dillman [mailto:[EMAIL PROTECTED] Sent: Friday, July 28, 2006 12:00 PM To: CF-Talk Subject: Sending Email from a valuelist. to begin with I have a Query that pulls the first last names and email Addy as one field. then i pass that item to a value list for the TO field of my CFMAIL tag cfquery name=bosses datasource=#dsn# SELECT Firstname + ' ' + Lastname + ' ' + email + '' AS useremail FROM Security WHERE (access_level = 5) /cfquery cfmail To=#valueList( email.useremail, ',' )# from=#Session.useremail# Subject=#LetterID# cc= bcc= charset=utf-8 type=html mailerid=Microsoft Outlook, Build 10.0.3416 the output of this is simply a coma delimited list but its only seeing the first and last name and excluding the email portion. Bryan Anderson ,Richard Dillman Now if i do an Output of cfoutput #valueList( bosses.useremail, ',' )# /cfoutput I get Bryan Anderson ,Richard Dillman but if i do cfoutput query=bosses #useremail#br / /cfoutput I get Bryan Anderson [EMAIL PROTECTED] Richard Dillman [EMAIL PROTECTED] Any ideas how to get the value list to show the email in this format? PS: yes I could just dump email only, but the users really like seeing their names in there. -- -- Richard Dillman [EMAIL PROTECTED] (317) 916-8341 IF-THEN-ELSE its a way of life! ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:248047 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: C3 page drafts
Mr Mackay says mac's are evil! M'kay On 7/28/06, Munson, Jacob [EMAIL PROTECTED] wrote: I guess you've never used a mac or linux machine? ;) -Original Message- From: Richard Dillman [mailto:[EMAIL PROTECTED] Sent: Friday, July 28, 2006 10:05 AM all i can say is START - RUN - EDIT it doesnt get any betterand its available on every machine ive ever been on. On 7/28/06, Mark Drew [EMAIL PROTECTED] wrote: What is the best CF IDE? sheesh.. I think its textpad... isnt it? On 7/28/06, James Holmes [EMAIL PROTECTED] wrote: First drafts of the ColdFusion Community Consensus pages are now available for comment: http://www.bifrost.com.au/c3/ http://www.bifrost.com.au/c3/topic.cfm You can comment in-list or at the blog: This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A1. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:248048 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4