this.mappings bug ??
So I've got this mapping in my Application.cfc and I know the mapping works because in my onRequestStart function, I'm dumping an expanded path using that mapping cffunction name=onRequestStart output=true ... cfdump var=#expandPath('/inc/galleon/udf.cfm')# / cfinclude template=_components/_prerequest.cfm /cffunction It then includes another template and the mapping suddenly fails / breaks because I copy and paste that same cfdump line into the included template and abort the request cfdump var=#expandPath('/inc/galleon/udf.cfm')# /cfabort And the returned paths are different... C:\apache\htdocs\galleon\ontap\_components\_includes\galleon\udf.cfm C:\apache\htdocs\inc\galleon\udf.cfm Which means my mapping is only working inside my CFC. What's especially maddening about this is that I know I have at least one other copy of the framework in an alternate directory that's using that /inc mapping without any problems. Has anyone else seen this? Thanks, -- s. isaac dealey ^ new epoch isn't it time for a change? ph: 617.365.5732 http://onTap.riaforge.org/blog ~| 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:305790 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: this.mappings bug ??
I would say it is more an issue with ExpandPath(). Remember how it actually works? If you are in C:\apache\htdocs then that is where it will be expanded. if you are in C:\apache\htdocs\galleon\ontap\_components\_includes\galleon\udf.cfm then that is what will be expanded. If you have a mapping for /inc, then why the hell are you doing an ExpandPath()? On Wed, May 21, 2008 at 4:04 PM, s. isaac dealey [EMAIL PROTECTED] wrote: So I've got this mapping in my Application.cfc and I know the mapping works because in my onRequestStart function, I'm dumping an expanded path using that mapping cffunction name=onRequestStart output=true ... cfdump var=#expandPath('/inc/galleon/udf.cfm')# / cfinclude template=_components/_prerequest.cfm /cffunction It then includes another template and the mapping suddenly fails / breaks because I copy and paste that same cfdump line into the included template and abort the request cfdump var=#expandPath('/inc/galleon/udf.cfm')# /cfabort And the returned paths are different... C:\apache\htdocs\galleon\ontap\_components\_includes\galleon\udf.cfm C:\apache\htdocs\inc\galleon\udf.cfm Which means my mapping is only working inside my CFC. What's especially maddening about this is that I know I have at least one other copy of the framework in an alternate directory that's using that /inc mapping without any problems. Has anyone else seen this? Thanks, -- s. isaac dealey ^ new epoch isn't it time for a change? ph: 617.365.5732 http://onTap.riaforge.org/blog ~| 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:305791 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: this.mappings bug ??
Nevermind my last post... I found the problem and no it's not a bug... was making me wonder tho. :) I've been converting Ray Camden's Galleon into several popular frameworks -- Luis Majano had already done Galleon 1.7 (though I was surprised how many changes there were between 1.7 and 2.0 -- the CFCs and views were really incompatible between versions and I ended up doing a lot of revising there because I want them both to use the same database and I'm going to be converting the other frameworks from Galleon 2.2). Anyway... it turns out that I'd accidentally left a cfapplication tag in from the original Galleon code and it was pushing the request off into a different application, which of course didn't share the mappings. So once I removed that like I thought I had, then everything works fine. So I've got ColdBox and I'm thinking I'm nearly done with onTap and then hopefully I'll be porting it to Fusebox 5, Model-Glue and Mach-II. Once I'm done I plan to post some side-by-sides that show what the controllers look like in each version (models and views don't change all that much between frameworks). Thanks, -- s. isaac dealey ^ new epoch isn't it time for a change? ph: 617.365.5732 http://onTap.riaforge.org/blog ~| 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:305792 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: this.mappings bug ??
Coldbox, have been playing with that for awhile now. And I love it. On Wed, May 21, 2008 at 4:18 PM, s. isaac dealey [EMAIL PROTECTED] wrote: Nevermind my last post... I found the problem and no it's not a bug... was making me wonder tho. :) I've been converting Ray Camden's Galleon into several popular frameworks -- Luis Majano had already done Galleon 1.7 (though I was surprised how many changes there were between 1.7 and 2.0 -- the CFCs and views were really incompatible between versions and I ended up doing a lot of revising there because I want them both to use the same database and I'm going to be converting the other frameworks from Galleon 2.2). Anyway... it turns out that I'd accidentally left a cfapplication tag in from the original Galleon code and it was pushing the request off into a different application, which of course didn't share the mappings. So once I removed that like I thought I had, then everything works fine. So I've got ColdBox and I'm thinking I'm nearly done with onTap and then hopefully I'll be porting it to Fusebox 5, Model-Glue and Mach-II. Once I'm done I plan to post some side-by-sides that show what the controllers look like in each version (models and views don't change all that much between frameworks). Thanks, -- s. isaac dealey ^ new epoch isn't it time for a change? ph: 617.365.5732 http://onTap.riaforge.org/blog ~| 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:305793 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Possible to use value statement and dual in mysql 5?
I think you will find 'dual' is an oracle only thing On Wed, May 21, 2008 at 3:39 AM, Rick Faircloth [EMAIL PROTECTED] wrote: Hi, all... Does anyone know if it's possible to use a value statement in this query that uses dual? I need to insert a value of hmls for the field mls in the property_photos table when this query is run... insert into property_photos ( photo_filename, photo_mls_number ) select '#photolist.name#', '#listfirst(photolist.name, '_')#' from dual where not exists (select photo_filename from property_photos where photo_filename = '#photolist.name#') Thanks, Rick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305794 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Coldfusion 8.0.1 Application.cfc issue
Hello Larry, Are you using the Adobe ColdFusion engine? Others (such as Railo) can have optimizations enabled to prevent looking up the structure for application files? If you're still having problems with this then Intergral (the makers of FusionReactor) can help. Check out our ColdFusion services here: http://www.fusion-reactor.com/services/cfservices.cfm Best regards, David I am quite lost on this one as I have not experienced this yet. We have an outside application that was built and I am trying to use 1 Application.cfc versus an Application.cfm. The application uses client variables so in the main cfc off the root, I have: cfapplication name=NameHere clientmanagement=yes sessionmanagement=yes sessiontimeout=#createtimespan(0,24,0,0)# but in any directory I go to, if I do not have an application file in it, it gives an error that the client management must be enabled. Once I drop the file in that directory, the error goes away and the page loads fine. It appears as though CF is not looking in the above directory (root directory) for the application file. Assistance would be really appreciated. ~| 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:305795 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ColdFusion 8 Ajax questions
I would think it's an issue of pathing. If your primary template, with the cfdiv, is page A, and exists in one directory, and your secondary template, page B, exists in another, then your action attribute's template, page C, would have to be called in relation to page A, since page A is where it's actually being rendered. Unlike an iframe, you're calling this content to directly render as part of page A. It's a shot in the dark, but it's hit me in the past. Hope it helps. Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer _ http://blog.cutterscrossing.com William Seiter wrote: Hey all, I am currently embroiled with my first full coldfusion ajax system for a client. I am running into a problem, which is probably elementary for those who have had some prior success with the cf ajax controls, but this has become a stumbling block for me. Can anyone please give me their advice? I have a page with a cfdiv area on it. When the user selects a name from a list, the cfdiv is populated by a form that contains the details for that name. This is accomplished by an inline url bind parameter in the cfdiv tag. this part seems to work properly. Once the user sees the detail form, I want them to be able to enter new data in the form and submit it. When I use a simple html form (FORM), The entire application is reloaded and the new form appears in its place. When I use a cold fusion form (CFFORM) I get a 'page cannot be found' error. I have tried leaving the action parameter in the cfform tag blank (defaults to same page). I have tried setting the action parameter using cgi.script_name, (the location of the subpage from the root). I have tried setting the action parameter hardcoded as the same name as the sub-direcotry filename. All of these solutions have the same effect, 'The page cannot be found'. The only change that produced a different result was changing the CFFORM to a FORM tag, which allows the page to be called correctly, however, it replaces the entire appication, not just inside the cfdiv. Please let me know if there is any details you might need to help me troubleshoot this issue. All help will be greatly appreciated. William ~| 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:305796 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Includes not found
Hey all. I have two apps(on two different servers), where I'm seeing errors stating that CF can't find a given include. The set-up is CF 8.0 on Windows 2003 with IIS 6 and SQL Server 2005 on both. In both cases I am using a mapping defined in App.cfc: cfset THIS.mappings[/includes] = path\to\includes On one app the page looks like this: cfinclude template=/includes/my-include.cfm Some basic CF and HTML cfinclude template=/includes/my-other-include.cfm and the error comes from either of the include lines. 'Could not find the included template /includes/my-include.cfm.' or 'Could not find the included template /includes/my-other-include.cfm.'. I put this down to CF being under load and was willing to put up with it, but now on another app on a much better server with even less intensive code, I'm getting the same error. Has anyone else come across this before? Is it a known issue? Are there any solutions? Thanks. Adrian Lynch http://www.adrianlynch.co.uk/ ~| 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:305797 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Includes not found
I ran into a similar issue a while back, and my problem was that the primary template I was calling was not within the same template as the Application.cfc. When Application.cfc runs on a page load it runs within the same directory space as the template originally called, thereby breaking your pathing. I got around this by referencing all of that pathing from the webroot of the site /somefolder/anotherfolder/etc. Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer _ http://blog.cutterscrossing.com Adrian Lynch wrote: Hey all. I have two apps(on two different servers), where I'm seeing errors stating that CF can't find a given include. The set-up is CF 8.0 on Windows 2003 with IIS 6 and SQL Server 2005 on both. In both cases I am using a mapping defined in App.cfc: cfset THIS.mappings[/includes] = path\to\includes On one app the page looks like this: cfinclude template=/includes/my-include.cfm Some basic CF and HTML cfinclude template=/includes/my-other-include.cfm and the error comes from either of the include lines. 'Could not find the included template /includes/my-include.cfm.' or 'Could not find the included template /includes/my-other-include.cfm.'. I put this down to CF being under load and was willing to put up with it, but now on another app on a much better server with even less intensive code, I'm getting the same error. Has anyone else come across this before? Is it a known issue? Are there any solutions? Thanks. Adrian Lynch http://www.adrianlynch.co.uk/ ~| 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:305798 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Includes not found
Are you saying my pathing is likely to be wrong? That was my first thought, but the page will error and a refresh will not show the error. If the pathing was wrong wouldn't it error on the same page all the time? I'm not sure where to go from here. -Original Message- From: Cutter (CFRelated) [mailto:[EMAIL PROTECTED] Sent: 21 May 2008 11:37 To: CF-Talk Subject: Re: Includes not found I ran into a similar issue a while back, and my problem was that the primary template I was calling was not within the same template as the Application.cfc. When Application.cfc runs on a page load it runs within the same directory space as the template originally called, thereby breaking your pathing. I got around this by referencing all of that pathing from the webroot of the site /somefolder/anotherfolder/etc. Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer _ http://blog.cutterscrossing.com Adrian Lynch wrote: Hey all. I have two apps(on two different servers), where I'm seeing errors stating that CF can't find a given include. The set-up is CF 8.0 on Windows 2003 with IIS 6 and SQL Server 2005 on both. In both cases I am using a mapping defined in App.cfc: cfset THIS.mappings[/includes] = path\to\includes On one app the page looks like this: cfinclude template=/includes/my-include.cfm Some basic CF and HTML cfinclude template=/includes/my-other-include.cfm and the error comes from either of the include lines. 'Could not find the included template /includes/my-include.cfm.' or 'Could not find the included template /includes/my-other-include.cfm.'. I put this down to CF being under load and was willing to put up with it, but now on another app on a much better server with even less intensive code, I'm getting the same error. Has anyone else come across this before? Is it a known issue? Are there any solutions? Thanks. Adrian Lynch http://www.adrianlynch.co.uk/ ~| 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:305799 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Coldfusion 8.0.1 Application.cfc issue
I figured it out on my way into work. I can't believe I missed it, but there are no files off the web root and the root of this application is in sub directories for some reason. Thank you all for trying to help me resolve it and informing me I was building the CFC incorrectly. Thanks, Larry It does not display. It does on the pages that are in the same directory, but the subdirectories do not have the h1 displaying. If you place an H1 tag above the cfapplication tag with test text after it, does it display on the pages? This will at least help solidify if the page is being called correctly (but not processed correctly). William Seiter (mobile) Have you ever read a book that changed your life? go to: http://www.winninginthemargins.com and use passcode: GoldenGrove ~| 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:305800 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFMail Problem
I am using CF 8 server on Windows 2003 server. When I use CFMail in my scripts and run the same, it says that mails have been sent successfully, however, it never reaches the destination. There are no errors in the mail logs. Than I checked C:\ColdFusion8\Mail\Spool and found all the messages were there in the spool folder. This happened a few days ago also and at that time I restarted the Mail server and it fixed the issues but I want to fix this problem on the permanent basis. Any ideas? ~| 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:305801 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFMail Problem
You could try with cfmail spoolenable=no ... That way the message will be sent immediately, without using the spool. Might also help for debugging... Wim. On Wed, May 21, 2008 at 1:46 PM, Meghna Chopra [EMAIL PROTECTED] wrote: I am using CF 8 server on Windows 2003 server. When I use CFMail in my scripts and run the same, it says that mails have been sent successfully, however, it never reaches the destination. There are no errors in the mail logs. Than I checked C:\ColdFusion8\Mail\Spool and found all the messages were there in the spool folder. This happened a few days ago also and at that time I restarted the Mail server and it fixed the issues but I want to fix this problem on the permanent basis. Any ideas? ~| 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:305802 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFMail Problem
Thanks Wim. I will try this for one of the scripts but the problem is that I will have to modify my 100s of scripts. Actually, the problem is not with the scripts. It is ColdFusion server giving this issue but I have no ideas how to fix it. While restarting CF Server is the temp solution but I need it to fix permanently. Thanks. You could try with cfmail spoolenable=no ... That way the message will be sent immediately, without using the spool. Might also help for debugging... Wim. On Wed, May 21, 2008 at 1:46 PM, Meghna Chopra [EMAIL PROTECTED] wrote: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305803 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFFORM in Spry Panels validation problem
Why not just make it one big form? You can still use panels to separate form fields. The forms are all related - but many are updating separate database tables and performing unrelated functions from each other. I have done Spry panels inside a single form before, and it worked great, but unfortunately isn't going to work in this application. Each panel needs to be it's own form. ~| 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:305804 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFMail Problem
Meghana, We found this issue a few days back with 8.0.1. This happens when you spool any email with attachments. You must be getting coldfusion.mail.MailSpooler$InvalidSpoolFileException. As a workaround you can disable spooling as suggested earlier cfmail spoolenable=no . Anyways it has been fixed and will be available as hotfix at earliest. If you are getting a different exception, could you please post the log message ~Chandan Adobe CF Team ~| 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:305805 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFFORM in Spry Panels validation problem
Why not just make it one big form? You can still use panels to separate form fields. The forms are all related - but many are updating separate database tables and performing unrelated functions from each other. I have done Spry panels inside a single form before, and it worked great, but unfortunately isn't going to work in this application. Each panel needs to be it's own form. There's no reason you can't build one form that can post different data to different URLs for different functions, or a form that can post different data to a single URL which can then figure out what to do with the data. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305806 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Possible to use value statement and dual in mysql 5?
No, dual is a MySQL function, also. I just haven't found a way to use value statements as part of the dual select statement involved. The dual method seems to be limited to the specific function of catching duplicates. Rick -Original Message- From: AJ Mercer [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 21, 2008 3:25 AM To: CF-Talk Subject: Re: Possible to use value statement and dual in mysql 5? I think you will find 'dual' is an oracle only thing On Wed, May 21, 2008 at 3:39 AM, Rick Faircloth [EMAIL PROTECTED] wrote: Hi, all... Does anyone know if it's possible to use a value statement in this query that uses dual? I need to insert a value of hmls for the field mls in the property_photos table when this query is run... insert into property_photos ( photo_filename, photo_mls_number ) select '#photolist.name#', '#listfirst(photolist.name, '_')#' from dual where not exists (select photo_filename from property_photos where photo_filename = '#photolist.name#') Thanks, Rick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305807 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Possible to use value statement and dual in mysql 5?
I worked around the problem by just running a separate update query to change the 'mls' field value after the photos are processed. -Original Message- From: AJ Mercer [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 21, 2008 3:25 AM To: CF-Talk Subject: Re: Possible to use value statement and dual in mysql 5? I think you will find 'dual' is an oracle only thing On Wed, May 21, 2008 at 3:39 AM, Rick Faircloth [EMAIL PROTECTED] wrote: Hi, all... Does anyone know if it's possible to use a value statement in this query that uses dual? I need to insert a value of hmls for the field mls in the property_photos table when this query is run... insert into property_photos ( photo_filename, photo_mls_number ) select '#photolist.name#', '#listfirst(photolist.name, '_')#' from dual where not exists (select photo_filename from property_photos where photo_filename = '#photolist.name#') Thanks, Rick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305808 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
queryparam for xml datatype?
I want to pass an xml doc to my query. What queryparam type should I use? I assumed cf_sql_longvarchar, and toString(myXML), but it complained about swithing encoding. Any suggestions? This email message may contain privileged and/or confidential information. If you are not the intended recipient(s), you are hereby notified that any dissemination, distribution, or copying of this email message is strictly prohibited. If you have received this message in error, please immediately notify the sender and delete this email message from your computer. CAUTION: The Agency of Human Services cannot ensure the confidentiality or security of email transmissions. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305809 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFMail Problem
Thanks Chandan. You must be getting coldfusion.mail.MailSpooler$InvalidSpoolFileException. Could you please let me know where I can see this error message? I looked in the CF Admin - Mail Logs and I don't see any such errors Meghana, We found this issue a few days back with 8.0.1. This happens when you spool any email with attachments. You must be getting coldfusion.mail. MailSpooler$InvalidSpoolFileException. As a workaround you can disable spooling as suggested earlier cfmail spoolenable=no . Anyways it has been fixed and will be available as hotfix at earliest. If you are getting a different exception, could you please post the log message ~Chandan Adobe CF Team ~| 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:305810 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFFORM in Spry Panels validation problem
You may take a look at version TMT Validator 2.0, it's a release candidate, I am polishing the documentation right now: http://www.massimocorner.com/libraries/validator/ See it in action here: http://www.massimocorner.com/libraries/validator/samples/index.htm Massimo Foti, web-programmer for hire Tools for ColdFusion, JavaScript and Dreamweaver: http://www.massimocorner.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:305811 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFMail Problem
The fix that Chandan describes below will post in the next few days as a technote titled, Patch for CFMail error in ColdFusion 8.01. http://www.adobe.com/go/kb403683 ~| 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:305812 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: queryparam for xml datatype?
Ok, looks like I'm answering my own question. Turns out that cfxml inserts a UTF-8 encoding in the xml header. When you declare a variable as XML in SQL, it uses the system-default encoding of UTF-16. My solution was to pass in the data as text, then CAST( AS XML) before using it. -Original Message- From: Leitch, Oblio [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 21, 2008 8:57 AM To: CF-Talk Subject: queryparam for xml datatype? I want to pass an xml doc to my query. What queryparam type should I use? I assumed cf_sql_longvarchar, and toString(myXML), but it complained about swithing encoding. Any suggestions? This email message may contain privileged and/or confidential information. If you are not the intended recipient(s), you are hereby notified that any dissemination, distribution, or copying of this email message is strictly prohibited. If you have received this message in error, please immediately notify the sender and delete this email message from your computer. CAUTION: The Agency of Human Services cannot ensure the confidentiality or security of email transmissions. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305813 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: queryparam for xml datatype?
Assuming this is MS SQL Server, I just use cf_sql_clob and don't have to do any CASTing afterwards in order to use it as XML. Scott On Wed, May 21, 2008 at 7:25 AM, Leitch, Oblio [EMAIL PROTECTED] wrote: I want to pass an xml doc to my query. What queryparam type should I use? I assumed cf_sql_longvarchar, and toString(myXML), but it complained about swithing encoding. Any suggestions? -- - Scott Brady http://www.scottbrady.net/ ~| 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:305814 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Default value in cfparam being used, even though variable exi sts
On Tue, May 20, 2008 at 4:35 PM, Dave Watts [EMAIL PROTECTED] wrote: Try taking TYPE=ANY out. I had tried that, and the same thing happened. Good idea, though. (I was thinking that if you don't use a type, CF assumes a string [or simple object] and would have thrown an error. I guess not.) -- - Scott Brady http://www.scottbrady.net/ ~| 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:305815 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cf8 directory watcher event gateway
i dont believe that its a timer. that would be weird... here is the 1st email i get... for a file that just changed a few minutes ago... A file has been changed. struct CFCMETHODonChange CFCPATH S:\reports\version4.0\cfc\root_productionCodeMover.cfc DATA struct FILENAME s:\reports\version4.0\shorty.txt LASTMODIFIED {ts '2008-05-20 15:30:26'} TYPE CHANGE GATEWAYIDProductionCodeMover_root GATEWAYTYPE FileWatcher ORIGINATORID [empty string] and here is the 2nd email that i get... A file has been changed. struct CFCMETHODonChange CFCPATH S:\reports\version4.0\cfc\root_productionCodeMover.cfc DATA struct FILENAME s:\reports\version4.0\shorty.txt LASTMODIFIED {ts '2008-05-21 09:53:39'} TYPE CHANGE GATEWAYIDProductionCodeMover_root GATEWAYTYPE FileWatcher ORIGINATORID [empty string] what the eff/ thanks for any insight! tony On Wed, May 21, 2008 at 12:38 AM, Andrew Scott [EMAIL PROTECTED] wrote: Well, thats weird. I am going to assume that there is a timer for the watching of the directory then, not sure on that. But your problem is a weird one, I suggested the delete event because I got caught in .Net for that once before so was curious if this was the case here. On Wed, May 21, 2008 at 12:00 PM, Tony [EMAIL PROTECTED] wrote: exsqueeze me :) im watching the onChange event. and having it send me an email. so, what you are saying is that i need to turn the onDelete event off and that will stop the behaviour i am seeing? because the ACT of editing a file in system speak is a deletion then a re-creation from memory? wow, i figured it was something odd like that. and even more odd. if i put more time between the editing of the file, it sometimes WOULDNT do two events, and only would do one event. wonder why? thanks tony On Tue, May 20, 2008 at 7:55 PM, Andrew Scott [EMAIL PROTECTED] wrote: What events are you watching? Editing a file, deletes then recreates from memory. So you will get two emails if you are watching both these events. On Wed, May 21, 2008 at 5:48 AM, Tony [EMAIL PROTECTED] wrote: hi all. i have an event gateway test app using the directory watcher and its working, i have it setup to send me an email everytime a file changes.. problem is, is that im testing with a simple text file, and when i make a change and save the file, i get two emails :( one email for the previous change, and one email for the current change. if i do it again, same thing. one email that matches the previous email, and one new one. ideas? thanks! tony -- 'Never have anything in your life that you can't walk out on in thirty seconds flat, if you spot the heat coming around the corner' robert deniro - heat (1995) ~| 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:305816 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Default value in cfparam being used, even though variable exists
On Tue, May 20, 2008 at 9:21 PM, James Holmes [EMAIL PROTECTED] wrote: The sessionGateway is being called because cfparam evaluates the default argument whether or not it needs to assign it to something. Isn't that kind of dumb? Everything I've thought about cfparam since I first learned of it was that it essentially was the same as doing an if this doesn't exist, then set it to this default without it actually evaluating the default if it wasn't necessary. My whole world view has been turned upside down. Thanks, though. I'll have to keep that mind in the future. Does your sessionGateway's getById() method automatically assign session.userBean or does it only return a value? Is it perhaps writing over a value passed by reference instead of value? It returns a bean object. But, if the passed in value is 0 [as it is with the default in the cfparam], the bean gets init-ed and returned. The init is what's setting all the default values. (that init was one of the things that was changed as part of the rollout last week -- it was part of a process to try to help performance by only instantiating our CFCs once, instead of every time it was called.) For now, I guess I'll stick with my workaround. -- - Scott Brady http://www.scottbrady.net/ ~| 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:305817 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Default value in cfparam being used, even though variable exists
On Tue, May 20, 2008 at 9:21 PM, James Holmes [EMAIL PROTECTED] wrote: The sessionGateway is being called because cfparam evaluates the default argument whether or not it needs to assign it to something. Oh, I guess it helps to RTFM, since right there in the livedocs for cfparam it says exactly what you said. -- - Scott Brady http://www.scottbrady.net/ ~| 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:305818 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
limit file upload size in fckeditor
How can I limit the size of a file that a user can upload using the file uploader built into fckeditor? Thanks in advance. ~| 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:305819 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: limit file upload size in fckeditor
We use this code in the filemanager's upload.cfm template: cfelseif cffile.FileSize gt 1048576!--- Disallow files over 1MB --- cfset errorNumber = 1 cfset customMsg = An error occured. The file uploaded has a size of #(NumberFormat((cffile.FileSize / 1048576), '9.99'))#MB which is larger than the allowed size of 1MB cffile action=delete file= #cffile.ServerDirectory##fs##cffile.ServerFile# ~| 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:305820 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cf8 directory watcher event gateway
ok, i figured it out :) i think. basically i had the timer set for 10 milliseconds ... way too much and too fast. so, ive set it to 5 seconds and all is working as expected! thanks! tony On Wed, May 21, 2008 at 9:56 AM, Tony [EMAIL PROTECTED] wrote: i dont believe that its a timer. that would be weird... here is the 1st email i get... for a file that just changed a few minutes ago... A file has been changed. struct CFCMETHODonChange CFCPATH S:\reports\version4.0\cfc\root_productionCodeMover.cfc DATA struct FILENAME s:\reports\version4.0\shorty.txt LASTMODIFIED {ts '2008-05-20 15:30:26'} TYPE CHANGE GATEWAYIDProductionCodeMover_root GATEWAYTYPE FileWatcher ORIGINATORID [empty string] and here is the 2nd email that i get... A file has been changed. struct CFCMETHODonChange CFCPATH S:\reports\version4.0\cfc\root_productionCodeMover.cfc DATA struct FILENAME s:\reports\version4.0\shorty.txt LASTMODIFIED {ts '2008-05-21 09:53:39'} TYPE CHANGE GATEWAYIDProductionCodeMover_root GATEWAYTYPE FileWatcher ORIGINATORID [empty string] what the eff/ thanks for any insight! tony On Wed, May 21, 2008 at 12:38 AM, Andrew Scott [EMAIL PROTECTED] wrote: Well, thats weird. I am going to assume that there is a timer for the watching of the directory then, not sure on that. But your problem is a weird one, I suggested the delete event because I got caught in .Net for that once before so was curious if this was the case here. On Wed, May 21, 2008 at 12:00 PM, Tony [EMAIL PROTECTED] wrote: exsqueeze me :) im watching the onChange event. and having it send me an email. so, what you are saying is that i need to turn the onDelete event off and that will stop the behaviour i am seeing? because the ACT of editing a file in system speak is a deletion then a re-creation from memory? wow, i figured it was something odd like that. and even more odd. if i put more time between the editing of the file, it sometimes WOULDNT do two events, and only would do one event. wonder why? thanks tony On Tue, May 20, 2008 at 7:55 PM, Andrew Scott [EMAIL PROTECTED] wrote: What events are you watching? Editing a file, deletes then recreates from memory. So you will get two emails if you are watching both these events. On Wed, May 21, 2008 at 5:48 AM, Tony [EMAIL PROTECTED] wrote: hi all. i have an event gateway test app using the directory watcher and its working, i have it setup to send me an email everytime a file changes.. problem is, is that im testing with a simple text file, and when i make a change and save the file, i get two emails :( one email for the previous change, and one email for the current change. if i do it again, same thing. one email that matches the previous email, and one new one. ideas? thanks! tony -- 'Never have anything in your life that you can't walk out on in thirty seconds flat, if you spot the heat coming around the corner' robert deniro - heat (1995) ~| 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:305821 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
ms sql's enum
MySQL has the enum datatype that you can set to Yes/No, True/False etc. What is MS SQL's version of this datatype? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305822 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ms sql's enum
MS SQL has a BIT datatype that is good for using as booleans. While the ENUM type in MySQL is cool, the real (normalized) way to do enumerated types is by using another table and storing a foreign key. On Wed, May 21, 2008 at 10:59 AM, Chad Gray [EMAIL PROTECTED] wrote: MySQL has the enum datatype that you can set to Yes/No, True/False etc. What is MS SQL's version of this datatype? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305823 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFMail Problem
Depends on your configuration. Did you try server.log? Thanks Chandan. You must be getting coldfusion.mail.MailSpooler$InvalidSpoolFileException. Could you please let me know where I can see this error message? I looked in the CF Admin - Mail Logs and I don't see any such errors ~| 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:305824 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Default value in cfparam being used, even though variable exi sts
On Wednesday 21 May 2008, Scott Brady wrote: I had tried that, and the same thing happened. Good idea, though. (I was thinking that if you don't use a type, CF assumes a string [or simple object] and would have thrown an error. I guess not.) No, it means CF will accept anything, as opposed to trying to validate it's of the correct CF_SQL_ type. -- 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:305825 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
What relationship am I missing in this query?
Hi, all... I'm trying to return each property from the properties table, along with the *first* photo in the property_photos table for each property with this query: select p.property_id, (select pp.photo_filename from property_photos pp, properties p where pp.photo_mls_number = substring_index(p.mls_number, '_', 1) limit 1) as prop_photo_filename from properties p, property_photos pp where substring_index(p.mls_number, '_', 1) = pp.photo_mls_number However, the query only return the first photo it finds and attaches it to every property instead of different photos for each property. I tried it without the limit 1 qualification, but then every photo for every property is returned. (Which is actually closer to the result I'm after...but I only want the first photo for each property) I just can't see the relationship qualification I'm missing? Suggestions, anyone? Thanks, Rick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305826 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
ListGetAt problem distinct
http://63.144.103.199/products/index.cfm?n1ID=5n2ID=43n3ID=133 if you click the accessories tab you can see i have repeating accesories in the Fans works fine if i pull out numbers that are repeated and add them to a new category.. which i am probably going to make the data entry guys do... sure this isnt making any sense.. -paul 939969938, 9969639, 9969936Fans _ Split Rear Door 7035 24 cab 220V 9969938 959969942, 9969639, 9969940Fans _ Split Rear Door 7035 28 cab 220V 9969942 279969937, 9969639, 9969939Fans _ Split Rear Door 9005 24 cab 110V 9969937 cfoutput query=getAscList2 group=title cfloop From = 1 To = #ListLen(getAscList2.specs_partnum)# index = Counter cfoutput group=specs_partnum tr align=left valign=top td #ListGetAt(getAscList2.specs_partnum,Counter)# /td cfquery name=prodDesc datasource=XX SELECT DISTINCT specs_partnum, prod_description FROM riprod_specs WHERE specs_partnum = #ListGetAt(getAscList2.specs_partnum,Counter)# /cfquery td#prodDesc.prod_description#/td /tr /cfoutput /cfloop tr align=left valign=top td colspan=2/td /tr /tbody /cfoutput ~| 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:305827 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFDIRECTORY / CFFILE
This seems like it should be easy but I must be missing something. I have a known directory with a bunch of unknown subdirectories, and possibly more unknown subdirectories in them. I want to recurse the known directory and get the name of every file and the FULL PATH to each file. How do I get the FULL PATH returned to me? cfdirectory action=list name=dlist directory=#mypath# recurse=yes I get back all the file names, but I can't tell what directories they are in. Any thoughts? Thanks Robert B. Harrison Director of Interactive services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be . ~| 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:305828 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE:_What_relationship_am_I_missing_in_this_query ?
I think you need to move your second query out of the select statement and into the join section of the query. This chunk of SQL goes and gets the most recent ElementStatusHistoryID by using a GROUP BY and uses it to join in the table at that one row that it finds with the GROUP BY. Hope it helps. SELECT c.CatalogID, c.CatalogName, c.currentStatus, ct.*, e.*, es.ElementStatus, es.ElementStatusDate, es.UserName FROM Catalogs as c LEFT JOIN Elements as e ON c.CatalogID = e.CatalogID JOIN CatalogTypes as ct ON c.CatalogTypeID = ct.CatalogTypeID LEFT JOIN ( SELECT MAX(ElementStatusHistoryID) as MaxESHID, ElementID FROM ElementStatusHistory GROUP BY ElementID ) as maxESH ON (e.ElementID = maxESH.ElementID) LEFT JOIN ( SELECT ElementStatusHistoryID, ElementStatus, ElementStatusDate, UserName FROM ElementStatusHistory ) as es ON (es.ElementStatusHistoryID = maxESH.MaxESHID) WHERE c.CatalogID = #val(URL.CatalogID)# -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 21, 2008 11:58 AM To: CF-Talk Subject: What relationship am I missing in this query? Hi, all... I'm trying to return each property from the properties table, along with the *first* photo in the property_photos table for each property with this query: select p.property_id, (select pp.photo_filename from property_photos pp, properties p where pp.photo_mls_number = substring_index(p.mls_number, '_', 1) limit 1) as prop_photo_filename from properties p, property_photos pp where substring_index(p.mls_number, '_', 1) = pp.photo_mls_number However, the query only return the first photo it finds and attaches it to every property instead of different photos for each property. I tried it without the limit 1 qualification, but then every photo for every property is returned. (Which is actually closer to the result I'm after...but I only want the first photo for each property) I just can't see the relationship qualification I'm missing? Suggestions, anyone? Thanks, Rick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305829 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFMail Problem
The fix that Chandan described is posted in a technote titled, Patch for CFMail error in ColdFusion 8.01 - http://www.adobe.com/go/kb403683. Ken Smith ColdFusion Support Adobe ~| 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:305830 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SOT: MSSQL Query help - Finding an exact word in a field
We are trying to tease out the following: SELECT ProjNum, ClientName, tblProj.Title, StartDate FROM tblProj WHERE (tblProj.Title LIKE '%Cost Plan%') OR(tblProj.Title LIKE '%Cost Allocation Plan%') OR (tblProj.Title LIKE '%CAP%') The problem is that OR (tblProj.Title LIKE '%CAP%') pulls out everything with CAP in it, like captital, captain etc. (as it should). What we want is to get everything with just the word CAP in it and not word that contains CAP. I know it can be done using Full-Text Search but we don't have it enabled on the DB and installing it is not going to happen any time soon. And this is some what time urgent. Does anyone know how to do that with out enabling Full-Text Search on SQL Server? TIA G We learn something every day, and lots of times it's that what we learned the day before was wrong. - Bill Vaughan ~| 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:305831 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFDIRECTORY / CFFILE
This seems like it should be easy but I must be missing something. I have a known directory with a bunch of unknown subdirectories and possibly more unknown subdirectories in them. I want to recurse the known directory and get the name of every file and the FULL PATH to each file. How do I get the FULL PATH returned to me? cfdirectory action=list name=dlist directory=#mypath# recurse=yes I get back all the file names, but I can't tell what directories they are in. Any thoughts? Thanks Robert B. Harrison Director of Interactive services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be . ~| 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:305832 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ColdFusion 8 Ajax questions
Well, I wasn't able to figure it out. I was able to learn alot about some things that are listed as 'should' work. I will have to do some gradual testing in the future. Make everything on one template and then start putting them into includes and then see how this effects the ajax system (I can't imagine it should, but who knows) I did get the data to submit to the database in a different manner, which will work for now. I used a cfajaxproxy bind command which is activated by the click on the submit button. To get the user interaction, I have a onMouseDown event that sets the button to show as 'being submitted' and then I use the same event to show the 'updated' text at the top of the cfdiv in span. this mimicks most of the behavior that i needed, but I will have to track back to this issue later to find out what the real issue was. thank you all for your assistance. I was able to find some great resources of infomation on this topic. Hey all, ~| 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:305833 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFDIRECTORY / CFFILE
Robert Harrison wrote: This seems like it should be easy but I must be missing something. I have a known directory with a bunch of unknown subdirectories, and possibly more unknown subdirectories in them. I want to recurse the known directory and get the name of every file and the FULL PATH to each file. How do I get the FULL PATH returned to me? Did you try dumping the query i.e. cfdump var=dlist. Does the directory column in the query not get you where you need to do. Yes it is not the full path, but combined with the known path it should get your there. ~| 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:305834 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: MSSQL Query help - Finding an exact word in a field
Are there a fixed set of delimiters in use in your title field? If so then you could look for: (Title = 'CAP' OR Title like 'CAP %' OR Title like '% CAP %' OR Title like '% CAP') -Original Message- From: Gerald Guido [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 21, 2008 1:43 PM To: CF-Talk Subject: SOT: MSSQL Query help - Finding an exact word in a field We are trying to tease out the following: SELECT ProjNum, ClientName, tblProj.Title, StartDate FROM tblProj WHERE (tblProj.Title LIKE '%Cost Plan%') OR(tblProj.Title LIKE '%Cost Allocation Plan%') OR (tblProj.Title LIKE '%CAP%') The problem is that OR (tblProj.Title LIKE '%CAP%') pulls out everything with CAP in it, like captital, captain etc. (as it should). What we want is to get everything with just the word CAP in it and not word that contains CAP. I know it can be done using Full-Text Search but we don't have it enabled on the DB and installing it is not going to happen any time soon. And this is some what time urgent. Does anyone know how to do that with out enabling Full-Text Search on SQL Server? TIA G We learn something every day, and lots of times it's that what we learned the day before was wrong. - Bill Vaughan ~| 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:305835 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: MSSQL Query help - Finding an exact word in a field
I know you can use square brackets and the carrot symbol to exclude characters. LIKE 'CAP[^T]%' Will give you everything that does not begin with CAPT So I _think_ you can do this. Try it and let me know. LIKE '%[^abcdefghijklmnopqrstuvwxyz]CAP[^abcdefghijklmnopqrstuvwxyz]%' You are probably going to have to look at the records as you are outputting them and toss out the bad ones so they don't display. Are you sure you cant turn FTS on? It is sooo much faster than LIKE. -Original Message- From: Gerald Guido [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 21, 2008 1:43 PM To: CF-Talk Subject: SOT: MSSQL Query help - Finding an exact word in a field We are trying to tease out the following: SELECT ProjNum, ClientName, tblProj.Title, StartDate FROM tblProj WHERE (tblProj.Title LIKE '%Cost Plan%') OR(tblProj.Title LIKE '%Cost Allocation Plan%') OR (tblProj.Title LIKE '%CAP%') The problem is that OR (tblProj.Title LIKE '%CAP%') pulls out everything with CAP in it, like captital, captain etc. (as it should). What we want is to get everything with just the word CAP in it and not word that contains CAP. I know it can be done using Full-Text Search but we don't have it enabled on the DB and installing it is not going to happen any time soon. And this is some what time urgent. Does anyone know how to do that with out enabling Full-Text Search on SQL Server? TIA G We learn something every day, and lots of times it's that what we learned the day before was wrong. - Bill Vaughan ~| 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:305836 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: MSSQL Query help - Finding an exact word in a field
In MySQL... '%CAP %' works. -Original Message- From: Gerald Guido [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 21, 2008 12:43 PM To: CF-Talk Subject: SOT: MSSQL Query help - Finding an exact word in a field We are trying to tease out the following: SELECT ProjNum, ClientName, tblProj.Title, StartDate FROM tblProj WHERE (tblProj.Title LIKE '%Cost Plan%') OR(tblProj.Title LIKE '%Cost Allocation Plan%') OR (tblProj.Title LIKE '%CAP%') The problem is that OR (tblProj.Title LIKE '%CAP%') pulls out everything with CAP in it, like captital, captain etc. (as it should). What we want is to get everything with just the word CAP in it and not word that contains CAP. I know it can be done using Full-Text Search but we don't have it enabled on the DB and installing it is not going to happen any time soon. And this is some what time urgent. Does anyone know how to do that with out enabling Full-Text Search on SQL Server? TIA G We learn something every day, and lots of times it's that what we learned the day before was wrong. - Bill Vaughan ~| 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:305837 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFDIRECTORY / CFFILE
I want to recurse the known directory and get the name of every file and the FULL PATH to each file. How do I get the FULL PATH returned to me? You could try this CFC: http://www.massimocorner.com/coldfusion/cfc/tmt_file_io.zip You can use this method: getFileList(directoryPath, true) Hope it will help Massimo Foti, web-programmer for hire Tools for ColdFusion, JavaScript and Dreamweaver: http://www.massimocorner.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:305838 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: MSSQL Query help - Finding an exact word in a field
I re-read my post and I don't make any sense. I think I was typing faster than my brain was working. :) LIKE 'CAP[^T]%' Will not return records with CAPT at the beginning. So LIKE '%[^abcdefghijklmnopqrstuvwxyz]CAP[^abcdefghijklmnopqrstuvwxyz]%' Will return records with CAP or 8CAP9, but won't return records with CAPTAIN or CAPITAL. At least I think it will. Try it out. I am not in front of a MS SQL server. -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 21, 2008 2:17 PM To: CF-Talk Subject: RE: MSSQL Query help - Finding an exact word in a field I know you can use square brackets and the carrot symbol to exclude characters. LIKE 'CAP[^T]%' Will give you everything that does not begin with CAPT So I _think_ you can do this. Try it and let me know. LIKE '%[^abcdefghijklmnopqrstuvwxyz]CAP[^abcdefghijklmnopqrstuvwxyz]%' You are probably going to have to look at the records as you are outputting them and toss out the bad ones so they don't display. Are you sure you cant turn FTS on? It is sooo much faster than LIKE. -Original Message- From: Gerald Guido [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 21, 2008 1:43 PM To: CF-Talk Subject: SOT: MSSQL Query help - Finding an exact word in a field We are trying to tease out the following: SELECT ProjNum, ClientName, tblProj.Title, StartDate FROM tblProj WHERE (tblProj.Title LIKE '%Cost Plan%') OR(tblProj.Title LIKE '%Cost Allocation Plan%') OR (tblProj.Title LIKE '%CAP%') The problem is that OR (tblProj.Title LIKE '%CAP%') pulls out everything with CAP in it, like captital, captain etc. (as it should). What we want is to get everything with just the word CAP in it and not word that contains CAP. I know it can be done using Full-Text Search but we don't have it enabled on the DB and installing it is not going to happen any time soon. And this is some what time urgent. Does anyone know how to do that with out enabling Full-Text Search on SQL Server? TIA G We learn something every day, and lots of times it's that what we learned the day before was wrong. - Bill Vaughan ~| 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:305839 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: MSSQL Query help - Finding an exact word in a field
I am full of incomplete thoughts. I _think_ you can abbreviate with a-z and 1-9 instead of typing out the characters. -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 21, 2008 2:27 PM To: CF-Talk Subject: RE: MSSQL Query help - Finding an exact word in a field I re-read my post and I don't make any sense. I think I was typing faster than my brain was working. :) LIKE 'CAP[^T]%' Will not return records with CAPT at the beginning. So LIKE '%[^abcdefghijklmnopqrstuvwxyz]CAP[^abcdefghijklmnopqrstuvwxyz]%' Will return records with CAP or 8CAP9, but won't return records with CAPTAIN or CAPITAL. At least I think it will. Try it out. I am not in front of a MS SQL server. -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 21, 2008 2:17 PM To: CF-Talk Subject: RE: MSSQL Query help - Finding an exact word in a field I know you can use square brackets and the carrot symbol to exclude characters. LIKE 'CAP[^T]%' Will give you everything that does not begin with CAPT So I _think_ you can do this. Try it and let me know. LIKE '%[^abcdefghijklmnopqrstuvwxyz]CAP[^abcdefghijklmnopqrstuvwxyz]%' You are probably going to have to look at the records as you are outputting them and toss out the bad ones so they don't display. Are you sure you cant turn FTS on? It is sooo much faster than LIKE. -Original Message- From: Gerald Guido [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 21, 2008 1:43 PM To: CF-Talk Subject: SOT: MSSQL Query help - Finding an exact word in a field We are trying to tease out the following: SELECT ProjNum, ClientName, tblProj.Title, StartDate FROM tblProj WHERE (tblProj.Title LIKE '%Cost Plan%') OR(tblProj.Title LIKE '%Cost Allocation Plan%') OR (tblProj.Title LIKE '%CAP%') The problem is that OR (tblProj.Title LIKE '%CAP%') pulls out everything with CAP in it, like captital, captain etc. (as it should). What we want is to get everything with just the word CAP in it and not word that contains CAP. I know it can be done using Full-Text Search but we don't have it enabled on the DB and installing it is not going to happen any time soon. And this is some what time urgent. Does anyone know how to do that with out enabling Full-Text Search on SQL Server? TIA G We learn something every day, and lots of times it's that what we learned the day before was wrong. - Bill Vaughan ~| 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:305840 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MSSQL Query help - Finding an exact word in a field
Chad, we got that to work with some tweaks. It was skipping stuff where CAP as the first word or last word. But yeah that did the trick. Thanx to everyone that helped! You helped save the day. G$ On Wed, May 21, 2008 at 2:29 PM, Chad Gray [EMAIL PROTECTED] wrote: I am full of incomplete thoughts. I _think_ you can abbreviate with a-z and 1-9 instead of typing out the characters. -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 21, 2008 2:27 PM To: CF-Talk Subject: RE: MSSQL Query help - Finding an exact word in a field I re-read my post and I don't make any sense. I think I was typing faster than my brain was working. :) LIKE 'CAP[^T]%' Will not return records with CAPT at the beginning. So LIKE '%[^abcdefghijklmnopqrstuvwxyz]CAP[^abcdefghijklmnopqrstuvwxyz]%' Will return records with CAP or 8CAP9, but won't return records with CAPTAIN or CAPITAL. At least I think it will. Try it out. I am not in front of a MS SQL server. -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 21, 2008 2:17 PM To: CF-Talk Subject: RE: MSSQL Query help - Finding an exact word in a field I know you can use square brackets and the carrot symbol to exclude characters. LIKE 'CAP[^T]%' Will give you everything that does not begin with CAPT So I _think_ you can do this. Try it and let me know. LIKE '%[^abcdefghijklmnopqrstuvwxyz]CAP[^abcdefghijklmnopqrstuvwxyz]%' You are probably going to have to look at the records as you are outputting them and toss out the bad ones so they don't display. Are you sure you cant turn FTS on? It is sooo much faster than LIKE. -Original Message- From: Gerald Guido [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 21, 2008 1:43 PM To: CF-Talk Subject: SOT: MSSQL Query help - Finding an exact word in a field We are trying to tease out the following: SELECT ProjNum, ClientName, tblProj.Title, StartDate FROM tblProj WHERE (tblProj.Title LIKE '%Cost Plan%') OR(tblProj.Title LIKE '%Cost Allocation Plan%') OR (tblProj.Title LIKE '%CAP%') The problem is that OR (tblProj.Title LIKE '%CAP%') pulls out everything with CAP in it, like captital, captain etc. (as it should). What we want is to get everything with just the word CAP in it and not word that contains CAP. I know it can be done using Full-Text Search but we don't have it enabled on the DB and installing it is not going to happen any time soon. And this is some what time urgent. Does anyone know how to do that with out enabling Full-Text Search on SQL Server? TIA G We learn something every day, and lots of times it's that what we learned the day before was wrong. - Bill Vaughan ~| 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:305841 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
delete duplicates.
i have some duplicates in a list i need to delete but am not getting it once again. cfloop From = 1 To = #ListLen(getAce.specs_partnum)# index = Counter cfoutput group=specs_partnum cfset acccL = #ListGetAt(getAce.specs_partnum,Counter)# cfset acccL = ListSort(#acccL#,text, ASC) #acccL# /cfoutput/cfloop br /br / /cfoutput spits out: Cable Management 9969593 9969593 9969599 9969599 9969594 9969594 9969600 9969600 9969599 9969599 9969601 9969601 9969600 9969600 9969928 9969928 9969601 9969601 9969927 9969927 9969928 9969928 9969597 9969597 9969927 9969927 9969736 9969736 9969597 9969597 9969595 9969595 9969736 9969736 9969598 9969598 9970253 9970254 9970255 9970256 9970263 9970264 9970265 9970266 9970271 9970271 9970271 9970271 thanks guys. ~| 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:305842 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: delete duplicates.
I am sure there are few udf on cflib.org that can be used. Have you looked there? HTH On Wed, May 21, 2008 at 3:08 PM, morchella [EMAIL PROTECTED] wrote: i have some duplicates in a list i need to delete but am not getting it once again. cfloop From = 1 To = #ListLen(getAce.specs_partnum)# index = Counter cfoutput group=specs_partnum cfset acccL = #ListGetAt(getAce.specs_partnum,Counter)# cfset acccL = ListSort(#acccL#,text, ASC) #acccL# /cfoutput/cfloop br /br / /cfoutput spits out: Cable Management 9969593 9969593 9969599 9969599 9969594 9969594 9969600 9969600 9969599 9969599 9969601 9969601 9969600 9969600 9969928 9969928 9969601 9969601 9969927 9969927 9969928 9969928 9969597 9969597 9969927 9969927 9969736 9969736 9969597 9969597 9969595 9969595 9969736 9969736 9969598 9969598 9970253 9970254 9970255 9970256 9970263 9970264 9970265 9970266 9970271 9970271 9970271 9970271 thanks guys. ~| 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:305843 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Can't figure out this query! Aaargh!
Seems like this should be so easy!! This is complicated by the fact that I have to use the second select because of the way the data is structured from the vendors who are supplying it. Ok... deep breath... Properties table. Property_Photos table. One property in the properties table with many photos for that property in the Property_Photos table. Just trying to run a query that returns each property with the first matching photo in the Property_Photos table (or just returns the property if no photos is present) Property - First Property Photo Property - First Property Photo Property - No Photo Property - First Property Photo etc. I tried this: select p.property_id from properties p, property_photos pp left join (select pp.photo_filename from property_photos pp, properties p where pp.photo_mls_number = substring_index(p.mls_number, '_', 1) limit 1) as photos on pp.photo_mls_number = substring_index(p.mls_number, '_', 1) but in my query builder I get the error 1054 - Unknown column 'p.mls_number' in 'on clause' and I can't figure out how to help MySQL 5 know the 'p.mls_number' column. Suggestions? Thanks, Rick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305844 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: delete duplicates.
http://www.cflib.org/udf.cfm?id=532 /** * Case-sensitive function for removing duplicate entries in a list. * @param list The list to be modified. * @return Returns a list. */ function ListDeleteDuplicates(list) { var i = 1; var delimiter = ','; var returnValue = ''; if(ArrayLen(arguments) GTE 2) delimiter = arguments[2]; list = ListToArray(list, delimiter); for(i = 1; i LTE ArrayLen(list); i = i + 1) if(NOT ListFind(returnValue, list[i], delimiter)) returnValue = ListAppend(returnValue, list[i], delimiter); return returnValue; } /** * Case-INsensitive function for removing duplicate entries in a list. * @param list List to be modified. * @return Returns a list. */ function ListDeleteDuplicatesNoCase(list) { var i = 1; var delimiter = ','; var returnValue = ''; if(ArrayLen(arguments) GTE 2) delimiter = arguments[2]; list = ListToArray(list, delimiter); for(i = 1; i LTE ArrayLen(list); i = i + 1) if(NOT ListFindNoCase(returnValue, list[i], delimiter)) returnValue = ListAppend(returnValue, list[i], delimiter); return returnValue; } On Wed, May 21, 2008 at 3:08 PM, morchella [EMAIL PROTECTED] wrote: i have some duplicates in a list i need to delete but am not getting it once again. cfloop From = 1 To = #ListLen(getAce.specs_partnum)# index = Counter cfoutput group=specs_partnum cfset acccL = #ListGetAt(getAce.specs_partnum,Counter)# cfset acccL = ListSort(#acccL#,text, ASC) #acccL# /cfoutput/cfloop br /br / /cfoutput spits out: Cable Management 9969593 9969593 9969599 9969599 9969594 9969594 9969600 9969600 9969599 9969599 9969601 9969601 9969600 9969600 9969928 9969928 9969601 9969601 9969927 9969927 9969928 9969928 9969597 9969597 9969927 9969927 9969736 9969736 9969597 9969597 9969595 9969595 9969736 9969736 9969598 9969598 9970253 9970254 9970255 9970256 9970263 9970264 9970265 9970266 9970271 9970271 9970271 9970271 thanks guys. ~| 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:305845 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: delete duplicates.
all that seems to do is to remove the commas? cfoutput query=getAce group=title #title# xbr / cfloop From = 1 To = #ListLen(getAce.specs_partnum)# index = Counter cfoutput group=specs_partnum cfset acccL = #ListGetAt(getAce.specs_partnum,Counter)# cfset acccL = '#acccL#,' #ListDeleteDuplicates(acccL)# /cfoutput/cfloop br /br / /cfoutput Cable Management x 9969593, 9969593, 9969599, 9969599, 9969594, 9969594, 9969600, 9969600, 9969599, 9969599, 9969601, 9969601, 9969600, 9969600, 9969928, 9969928, 9969601, 9969601, 9969927, 9969927, 9969928, 9969928, 9969597, 9969597, 9969927, 9969927, 9969736, 9969736, 9969597, 9969597, 9969595, 9969595, 9969736, 9969736, 9969598, 9969598, 9970253, 9970254, 9970255, 9970256, 9970263, 9970264, 9970265, 9970266, 9970271, 9970271, 9970271, 9970271, Cable Management x 9969593 9969593 9969599 9969599 9969594 9969594 9969600 9969600 9969599 9969599 9969601 9969601 9969600 9969600 9969928 9969928 9969601 9969601 9969927 9969927 9969928 9969928 9969597 9969597 9969927 9969927 9969736 9969736 9969597 9969597 9969595 9969595 9969736 9969736 9969598 9969598 9970253 9970254 9970255 9970256 9970263 9970264 9970265 9970266 9970271 9970271 9970271 9970271 ~| 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:305846 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Can ColdFusion detect if Flash is available?
I'd like to be able to detect if a user's browser will support Flash, and ideally be able to tell if the version is up to date enough to handle my Flash application. Is this possible? TIA ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305847 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Can ColdFusion detect if Flash is available?
Not directly. You can render a page that uses JavaScript to detect the flash player and version and then send the user to the appropriate (flash / non-flash) page. This is what the default wrapper of most Flash-producing environments (Flash IDE, FlexBuilder, etc.) does for you. cheers. barneyb On Wed, May 21, 2008 at 1:24 PM, K Simanonok [EMAIL PROTECTED] wrote: I'd like to be able to detect if a user's browser will support Flash, and ideally be able to tell if the version is up to date enough to handle my Flash application. Is this possible? TIA -- Barney Boisvert [EMAIL PROTECTED] http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305848 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Can ColdFusion detect if Flash is available?
CF = server.. Flash is client.. so I wouldn't think so.. if I was wrong it wouldn't be the first time On Wed, May 21, 2008 at 3:24 PM, K Simanonok [EMAIL PROTECTED] wrote: I'd like to be able to detect if a user's browser will support Flash, and ideally be able to tell if the version is up to date enough to handle my Flash application. Is this possible? TIA ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305849 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfajaxproxy
I am trying to use cfajaxproxy to call a cfc. This work on my local machine, but not in our testing environment. I get an error: JSON parsing failure: Expected '' at character 2:'' in {quot;encPolnumquot;:quot;5061800quot;} If I remove the arguments the function works fine. Any idea why the html encoded quot; is used instead of? cfajaxproxy cfc=webroot.#Request.SiteDir#.invservices.riskinfo jsclassname=myproxy script type=text/javascript p = new myproxy(); p.setCallbackHandler(handleResult); function handleResult(r) { alert(r); } function saveRiskObjective(obj){ var sPolnum = obj.id; p.saveRiskInfo(sPolnum); } /script cffunction name=saveRiskInfo access=remote cfargument name=encPolnum type=string required=Yes / cfset var local = #encPolnum# / cfstoredproc procedure=#Request.sSchema#.pkg_riskinfo.saveRiskInfo datasource=#Request.sDSN# returncode=No cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbvarname=sPolnum value=5061800 null=No / cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbvarname=sType value=risktolerence null=No / cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbvarname=sValue value=2 null=No / /cfstoredproc cfreturn local / /cffunction Frank Wheatley ~| 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:305850 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Can ColdFusion detect if Flash is available?
This is my favorite Flash detection JavaScript http://code.google.com/p/swfobject/ =] -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org ~| 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:305851 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: delete duplicates.
You have to remove the dupes before you loop over the list On Wed, May 21, 2008 at 3:57 PM, morchella [EMAIL PROTECTED] wrote: all that seems to do is to remove the commas? cfoutput query=getAce group=title #title# xbr / cfloop From = 1 To = #ListLen(getAce.specs_partnum)# index = Counter cfoutput group=specs_partnum cfset acccL = #ListGetAt(getAce.specs_partnum,Counter)# cfset acccL = '#acccL#,' #ListDeleteDuplicates(acccL)# /cfoutput/cfloop br /br / /cfoutput Cable Management x 9969593, 9969593, 9969599, 9969599, 9969594, 9969594, 9969600, 9969600, 9969599, 9969599, 9969601, 9969601, 9969600, 9969600, 9969928, 9969928, 9969601, 9969601, 9969927, 9969927, 9969928, 9969928, 9969597, 9969597, 9969927, 9969927, 9969736, 9969736, 9969597, 9969597, 9969595, 9969595, 9969736, 9969736, 9969598, 9969598, 9970253, 9970254, 9970255, 9970256, 9970263, 9970264, 9970265, 9970266, 9970271, 9970271, 9970271, 9970271, Cable Management x 9969593 9969593 9969599 9969599 9969594 9969594 9969600 9969600 9969599 9969599 9969601 9969601 9969600 9969600 9969928 9969928 9969601 9969601 9969927 9969927 9969928 9969928 9969597 9969597 9969927 9969927 9969736 9969736 9969597 9969597 9969595 9969595 9969736 9969736 9969598 9969598 9970253 9970254 9970255 9970256 9970263 9970264 9970265 9970266 9970271 9970271 9970271 9970271 ~| 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:305852 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: delete duplicates.
An easy way to delete duplicates form a list is to loop the list into a structure using the list item as the key then use structKeyList() to get the cleaned list back out I don't know what your initial list looks like but here is an example with a space delimited list... cfset theList = 9969593 9969593 9969599 9969599 9969594 9969594 9969600 9969600 9969599 9969599 / cfset uniqueListItems = structNew() / cfloop list=#theList# delimiters= index=i cfset uniqueListItems[i] = i / /cfloop cfset cleanedList = structKeyList(uniqueListItems) / ..:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: morchella [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 21, 2008 3:57 PM To: CF-Talk Subject: Re: delete duplicates. all that seems to do is to remove the commas? cfoutput query=getAce group=title #title# xbr / cfloop From = 1 To = #ListLen(getAce.specs_partnum)# index = Counter cfoutput group=specs_partnum cfset acccL = #ListGetAt(getAce.specs_partnum,Counter)# cfset acccL = '#acccL#,' #ListDeleteDuplicates(acccL)# /cfoutput/cfloop br /br / /cfoutput Cable Management x 9969593, 9969593, 9969599, 9969599, 9969594, 9969594, 9969600, 9969600, 9969599, 9969599, 9969601, 9969601, 9969600, 9969600, 9969928, 9969928, 9969601, 9969601, 9969927, 9969927, 9969928, 9969928, 9969597, 9969597, 9969927, 9969927, 9969736, 9969736, 9969597, 9969597, 9969595, 9969595, 9969736, 9969736, 9969598, 9969598, 9970253, 9970254, 9970255, 9970256, 9970263, 9970264, 9970265, 9970266, 9970271, 9970271, 9970271, 9970271, Cable Management x 9969593 9969593 9969599 9969599 9969594 9969594 9969600 9969600 9969599 9969599 9969601 9969601 9969600 9969600 9969928 9969928 9969601 9969601 9969927 9969927 9969928 9969928 9969597 9969597 9969927 9969927 9969736 9969736 9969597 9969597 9969595 9969595 9969736 9969736 9969598 9969598 9970253 9970254 9970255 9970256 9970263 9970264 9970265 9970266 9970271 9970271 9970271 9970271 ~| 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:305853 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Can't figure out this query! Aaargh!
I've been searching everywhere for this solution...but nothing has worked. Anyone? -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 21, 2008 3:28 PM To: CF-Talk Subject: Can't figure out this query! Aaargh! Seems like this should be so easy!! This is complicated by the fact that I have to use the second select because of the way the data is structured from the vendors who are supplying it. Ok... deep breath... Properties table. Property_Photos table. One property in the properties table with many photos for that property in the Property_Photos table. Just trying to run a query that returns each property with the first matching photo in the Property_Photos table (or just returns the property if no photos is present) Property - First Property Photo Property - First Property Photo Property - No Photo Property - First Property Photo etc. I tried this: select p.property_id from properties p, property_photos pp left join (select pp.photo_filename from property_photos pp, properties p where pp.photo_mls_number = substring_index(p.mls_number, '_', 1) limit 1) as photos on pp.photo_mls_number = substring_index(p.mls_number, '_', 1) but in my query builder I get the error 1054 - Unknown column 'p.mls_number' in 'on clause' and I can't figure out how to help MySQL 5 know the 'p.mls_number' column. Suggestions? Thanks, Rick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305854 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: delete duplicates.
thanks guys. will try that in the morning. such a beautiful day! ~| 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:305855 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Can't figure out this query! Aaargh!
I was going to reply earlier, but I am not that familiar with MySQL syntax. There are several ways to accomplish this in MS SQL at least. Hopefully they work in MySQL as well. I'm not 100% following your SQL below... 1) You could place a nested limit 1 select from the photos table in the select list from the properties table. 2) Does your photos table have an item sort column to denote which picture is first, second, third? If so join the tables something like mls number and sort_order = 1 3) If you wanted to left join the photos table as a derived table, you would need to group the sub select by MLS number, outputting the MLS number and use some aggregate function like max() to get a random photo for that MLS. Make sure when you join your derived table, you use the proper alias. 4) Even simpler than option three would be to join the two tables on MLS and then group by everything in the properries table, and use an aggregate function to get the max photo. 4) You could do an initial insert into a temp table of just MLS listings. Then do an update to that table from the photos table joining on MLS number. If there are multiple photos, only one will get put in the temp table. (This is probably my favorite, because it is verbose, and probably performs best) 5) If you are dealing with millions of records and the select really needs to scream, place a denormalized column in the properties table which holds the first photo. If any changes to the photo table were made, the properties table would need to be updated obviously. This becomes a problem only if updates/inserts reads. 6) And my absolute worst idea yet-- join the tables on MLS and return ALL photos to CF ordered by MLS. cfoutput with a group attribute on MLS and place some code in the inner cfoutput to ignore repeated photos for a given MLS. Hope that gives you something. I can't guarantee each of those will work in MySQL, but they should in MSSQL. ~Brad -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 21, 2008 4:44 PM To: CF-Talk Subject: RE: Can't figure out this query! Aaargh! I've been searching everywhere for this solution...but nothing has worked. Anyone? ~| 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:305856 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Can't figure out this query! Aaargh!
This is just a pseudo code example based on my Oracle experience but I think you have an extra 'table' in there. I think you are working too hard, this idea came to me when I was trying to work you sub select out. SELECT p.property_id, FIRST(pp.photo_filename) FROM properties p LEFT JOIN property_photos pp ON (pp.mls_number = p.mls_number) GROUP BY p.property_id P.S. I left out the substring() function for brevity and general sympathy for such a convoluted relationship key. P.P.S I am assuming your database management system (mysql) supports the FIRST() SQL aggregate function. It is not one I have used before and I do not know how universal it is. If it does not work min(pp.photo_filename) would probably work but this could be a different image then you want when more then one is available. ~| 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:305857 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
(ot) Simple Tool
I 'accidentally' designed and developed a super simple survey tool (yeah, I know zillions of the same type out there). Got two questions here: a) is it all right to post its beta URL here for opinion/feedback? b) someone may have done something similar (not the functional side but on the simplicity side), care to share some thoughts, better, insights, on marketing (not some quick Internet search digging). 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:305858 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Can't figure out this query! Aaargh!
It's probably because it looks like your join syntax is wrong. You're telling the database: property_photos pp left join (select pp.photo_filename from property_photos pp, properties p where pp.photo_mls_number = substring_index(p.mls_number, '_', 1) limit 1) as photos on pp.photo_mls_number = substring_index(p.mls_number, '_', 1) and your ON statement is not doing anything with the photos subquery. You might try something like: select p.property_id, photos.photofilename from properties p left join property_photos pp on pp.photo_mls_number = substring_index(p.mls_number, '_', 1) left join (select pp2.photo_mls_number, pp2.photo_filename from property_photos pp2 where pp2.photo_mls_number = pp.photo_mls_number limit 1 ) photo on photo.photo_mls_number = pp.photo_mls_number On Wed, May 21, 2008 at 3:28 PM, Rick Faircloth [EMAIL PROTECTED] wrote: Seems like this should be so easy!! This is complicated by the fact that I have to use the second select because of the way the data is structured from the vendors who are supplying it. Ok... deep breath... Properties table. Property_Photos table. One property in the properties table with many photos for that property in the Property_Photos table. Just trying to run a query that returns each property with the first matching photo in the Property_Photos table (or just returns the property if no photos is present) Property - First Property Photo Property - First Property Photo Property - No Photo Property - First Property Photo etc. I tried this: select p.property_id from properties p, property_photos pp left join (select pp.photo_filename from property_photos pp, properties p where pp.photo_mls_number = substring_index(p.mls_number, '_', 1) limit 1) as photos on pp.photo_mls_number = substring_index(p.mls_number, '_', 1) but in my query builder I get the error 1054 - Unknown column 'p.mls_number' in 'on clause' and I can't figure out how to help MySQL 5 know the 'p.mls_number' column. Suggestions? Thanks, Rick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305859 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: (ot) Simple Tool
Just my opinion... but... By all means, share away! =] -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org ~| 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:305860 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: (ot) Simple Tool
a) is it all right to post its beta URL here for opinion/feedback? b) someone may have done something similar (not the functional side but on the simplicity side), care to share some thoughts, better, insights, on marketing (not some quick Internet search digging). Thanks. oh, sorry... i thought this was a thread where we describe ourselves in 2 words or less...nevermind. Will ~| 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:305861 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: (ot) Simple Tool
best ever reply to an email ive seen in my entire life. pnwed cg style. On Wed, May 21, 2008 at 7:24 PM, Will Tomlinson [EMAIL PROTECTED] wrote: a) is it all right to post its beta URL here for opinion/feedback? b) someone may have done something similar (not the functional side but on the simplicity side), care to share some thoughts, better, insights, on marketing (not some quick Internet search digging). Thanks. oh, sorry... i thought this was a thread where we describe ourselves in 2 words or less...nevermind. Will ~| 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:305862 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Can't figure out this query! Aaargh!
Brad Ian... Thanks so much for your replies. I'm going to keep them handy for reference if the solution I've worked out doesn't stand up through all the testing, but I think I've got a solution. Here's what I've worked up: select properties.property_id, properties.mls_number, min( property_photos.photo_filename) as prop_photo_filename from properties left join property_photos on substring_index(properties.mls_number, '_', 1) = property_photos.photo_mls_number and properties.mls = property_photos.mls group by properties.mls_number The min function works because the photos are always in numerical order and (I hope) the first photo should be the primary photo for the property when only one is show. I've got a lot more data that needs to be processed by this query, but I wanted to get something that works in a limited scope before making it even more complex. Also, I would normally use the table abbreviations, such as p.property_id, but something about this particular syntax is rejected all attempts at abbreviation. Thanks, again, for all you help! Rick -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 21, 2008 6:08 PM To: CF-Talk Subject: Re: Can't figure out this query! Aaargh! This is just a pseudo code example based on my Oracle experience but I think you have an extra 'table' in there. I think you are working too hard, this idea came to me when I was trying to work you sub select out. SELECT p.property_id, FIRST(pp.photo_filename) FROM properties p LEFT JOIN property_photos pp ON (pp.mls_number = p.mls_number) GROUP BY p.property_id P.S. I left out the substring() function for brevity and general sympathy for such a convoluted relationship key. P.P.S I am assuming your database management system (mysql) supports the FIRST() SQL aggregate function. It is not one I have used before and I do not know how universal it is. If it does not work min(pp.photo_filename) would probably work but this could be a different image then you want when more then one is available. ~| 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:305863 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Can't figure out this query! Aaargh!
Thanks for the tips and code, Brian! I finally did work up a solution that (hopefully) will hold up under testing. I will keep your solution handy, however! Here's what's working in my preliminary tests: select properties.property_id, properties.mls_number, min( property_photos.photo_filename) as prop_photo_filename from properties left join property_photos on substring_index(properties.mls_number, '_', 1) = property_photos.photo_mls_number and properties.mls = property_photos.mls group by properties.mls_number Rick -Original Message- From: Brian Kotek [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 21, 2008 6:23 PM To: CF-Talk Subject: Re: Can't figure out this query! Aaargh! It's probably because it looks like your join syntax is wrong. You're telling the database: property_photos pp left join (select pp.photo_filename from property_photos pp, properties p where pp.photo_mls_number = substring_index(p.mls_number, '_', 1) limit 1) as photos on pp.photo_mls_number = substring_index(p.mls_number, '_', 1) and your ON statement is not doing anything with the photos subquery. You might try something like: select p.property_id, photos.photofilename from properties p left join property_photos pp on pp.photo_mls_number = substring_index(p.mls_number, '_', 1) left join (select pp2.photo_mls_number, pp2.photo_filename from property_photos pp2 where pp2.photo_mls_number = pp.photo_mls_number limit 1 ) photo on photo.photo_mls_number = pp.photo_mls_number On Wed, May 21, 2008 at 3:28 PM, Rick Faircloth [EMAIL PROTECTED] wrote: Seems like this should be so easy!! This is complicated by the fact that I have to use the second select because of the way the data is structured from the vendors who are supplying it. Ok... deep breath... Properties table. Property_Photos table. One property in the properties table with many photos for that property in the Property_Photos table. Just trying to run a query that returns each property with the first matching photo in the Property_Photos table (or just returns the property if no photos is present) Property - First Property Photo Property - First Property Photo Property - No Photo Property - First Property Photo etc. I tried this: select p.property_id from properties p, property_photos pp left join (select pp.photo_filename from property_photos pp, properties p where pp.photo_mls_number = substring_index(p.mls_number, '_', 1) limit 1) as photos on pp.photo_mls_number = substring_index(p.mls_number, '_', 1) but in my query builder I get the error 1054 - Unknown column 'p.mls_number' in 'on clause' and I can't figure out how to help MySQL 5 know the 'p.mls_number' column. Suggestions? Thanks, Rick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305864 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: (ot) Simple Tool
Or Cj style even ;-) ..:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Rastafari [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 21, 2008 7:29 PM To: CF-Talk Subject: Re: (ot) Simple Tool best ever reply to an email ive seen in my entire life. pnwed cg style. On Wed, May 21, 2008 at 7:24 PM, Will Tomlinson [EMAIL PROTECTED] wrote: a) is it all right to post its beta URL here for opinion/feedback? b) someone may have done something similar (not the functional side but on the simplicity side), care to share some thoughts, better, insights, on marketing (not some quick Internet search digging). Thanks. oh, sorry... i thought this was a thread where we describe ourselves in 2 words or less...nevermind. Will ~| 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:305865 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_relationship_am_I_missing_in_this_query ?
Thanks for the tips, Chad! Rick -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 21, 2008 1:10 PM To: CF-Talk Subject: RE:_What_relationship_am_I_missing_in_this_query ? I think you need to move your second query out of the select statement and into the join section of the query. This chunk of SQL goes and gets the most recent ElementStatusHistoryID by using a GROUP BY and uses it to join in the table at that one row that it finds with the GROUP BY. Hope it helps. SELECT c.CatalogID, c.CatalogName, c.currentStatus, ct.*, e.*, es.ElementStatus, es.ElementStatusDate, es.UserName FROM Catalogs as c LEFT JOIN Elements as e ON c.CatalogID = e.CatalogID JOIN CatalogTypes as ct ON c.CatalogTypeID = ct.CatalogTypeID LEFT JOIN ( SELECT MAX(ElementStatusHistoryID) as MaxESHID, ElementID FROM ElementStatusHistory GROUP BY ElementID ) as maxESH ON (e.ElementID = maxESH.ElementID) LEFT JOIN ( SELECT ElementStatusHistoryID, ElementStatus, ElementStatusDate, UserName FROM ElementStatusHistory ) as es ON (es.ElementStatusHistoryID = maxESH.MaxESHID) WHERE c.CatalogID = #val(URL.CatalogID)# -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 21, 2008 11:58 AM To: CF-Talk Subject: What relationship am I missing in this query? Hi, all... I'm trying to return each property from the properties table, along with the *first* photo in the property_photos table for each property with this query: select p.property_id, (select pp.photo_filename from property_photos pp, properties p where pp.photo_mls_number = substring_index(p.mls_number, '_', 1) limit 1) as prop_photo_filename from properties p, property_photos pp where substring_index(p.mls_number, '_', 1) = pp.photo_mls_number However, the query only return the first photo it finds and attaches it to every property instead of different photos for each property. I tried it without the limit 1 qualification, but then every photo for every property is returned. (Which is actually closer to the result I'm after...but I only want the first photo for each property) I just can't see the relationship qualification I'm missing? Suggestions, anyone? Thanks, Rick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305866 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: ASSISTANCE
Would someone just ban this guy already? Because either he's participating in crap like this or his computer is infected with an email trojan. Either way, I think it's time to cut him off. On Fri, May 16, 2008 at 1:08 PM, Phillip Vector [EMAIL PROTECTED] wrote: Because people respond. That's why. On Fri, May 16, 2008 at 10:07 AM, Gerald Guido [EMAIL PROTECTED] wrote: Why? On Fri, May 16, 2008 at 12:56 PM, erik tom [EMAIL PROTECTED] wrote: FROM THE DESK OF DR YUSUF KAZEEM, THE BANK MANAGER, STANDARD TRUST BANK LIMITED. -- The pursuit of truth and beauty is a sphere of activity in which we are permitted to remain children all our lives. - Albert Einstein ~| 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:305867 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Can ColdFusion detect if Flash is available?
Not wrong in this case but it is important to note that the browser does send a wealth of information about itself with each request. So just b/c something is client side does not preclude CF from knowing something about it. Adam On Wed, May 21, 2008 at 4:31 PM, Greg Morphis [EMAIL PROTECTED] wrote: CF = server.. Flash is client.. so I wouldn't think so.. if I was wrong it wouldn't be the first time On Wed, May 21, 2008 at 3:24 PM, K Simanonok [EMAIL PROTECTED] wrote: I'd like to be able to detect if a user's browser will support Flash, and ideally be able to tell if the version is up to date enough to handle my Flash application. Is this possible? TIA ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305868 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: this.mappings bug ??
I would say it is more an issue with ExpandPath(). Remember how it actually works? If you are in C:\apache\htdocs then that is where it will be expanded. if you are in C:\apache\htdocs\galleon\ontap\_components\_includes\galleon\udf.cfm then that is what will be expanded. If you have a mapping for /inc, then why the hell are you doing an ExpandPath()? Well you'r information about ExpandPath is almost correct. ExpandPath uses the directory containing the base template (not the current template, which would be far more useful but isn't provided anywhere in the server). What this means is that if you go to http://localhost/index.cfm and inside index.cfm you include say /some/sub/directory/thing.cfm and output ExpandPath(else.cfm) inside of thing.cfm, you'll get C:\apache\htdocs\else.cfm instead of C:\apache\htdocs\some\sub\directory\else.cfm However... that's not the whole story. Mappings always begin with a forward slash, i.e. the mapping is /inc not inc. If your path argument to the ExpandPath() function begins with a forward slash then, the server will attempt to match the path to any available mappings and expand from the mapping instead of the base template. So if you have a mapping of /inc to C:\foo and the mapping is working, then when you ExpandPath(/inc/something.zip) you'll get C:\foo\something.zip instead of C:\apache\htdocs\something.zip ... That's why in my first post I mentioned that I knew the mapping was working because the first ExpandPath call in the Application.cfc was expanding the mapping instead of the base template directory that was being expanded the 2nd time. So the same ExpandPath() call either before or after the cfapplication tag was producing 2 different paths. In htdocs\galleon\ontap\application.cfc I was getting: - C:\apache\htdocs\galleon\ontap\_components\_includes\galleon\udf.cfm (what I wanted) and in htdocs\galleon\ontap\index.cfm I was getting: - C:\apache\htdocs\galleon\ontap\inc\galleon\udf.cfm (not what I wanted) So... long and short the answer to why the hell are you using expandpath()? is because it works with mappings. I was actually only using it to test the mapping, I wasn't even using it because I needed the full path, I just needed to test the mapping. -- s. isaac dealey ^ new epoch isn't it time for a change? ph: 617.365.5732 http://onTap.riaforge.org/blog ~| 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:305869 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: What is it with telecommuting?
2008/5/20 C. Hatton Humphrey [EMAIL PROTECTED]: Understandably, most places want people on-site. As a coder, I've never understood this obsession. As a geek, the location of my colleagues and/or computer are irrelevant. -- Tom ~| 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-Jobs-Talk/message.cfm/messageid:3806 Subscription: http://www.houseoffusion.com/groups/CF-Jobs-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11
Re: What is it with telecommuting?
2008/5/21 Adam Haskell [EMAIL PROTECTED]: bad but employers have 100% valid reasons for wanting staff on site. *for some activities* you should have gone on to say. Unless someone is code reviewing 100% of the time, whats the point ? -- Tom ~| 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-Jobs-Talk/message.cfm/messageid:3807 Subscription: http://www.houseoffusion.com/groups/CF-Jobs-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11
Re: What is it with telecommuting?
You are right for some activities, I did not mean to say a company has a good reason to *never* allow telecommuting. That being said in our enterprise our mentoring program calls for an average of 55 hours/year and a tech lead will usually average about 110 hours/year doing code reviews many of these activities are informal and happen throughout a normal day at the office. Its reasons like this that telecommuting is allowed but its not viable to telecommute from a different region. Adam Haskell On Wed, May 21, 2008 at 8:34 AM, Tom Chiverton [EMAIL PROTECTED] wrote: 2008/5/21 Adam Haskell [EMAIL PROTECTED]: bad but employers have 100% valid reasons for wanting staff on site. *for some activities* you should have gone on to say. Unless someone is code reviewing 100% of the time, whats the point ? -- Tom ~| 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-Jobs-Talk/message.cfm/messageid:3808 Subscription: http://www.houseoffusion.com/groups/CF-Jobs-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11
Re: What is it with telecommuting?
Understandably, most places want people on-site. As a coder, I've never understood this obsession. As a geek, the location of my colleagues and/or computer are irrelevant. But see, there's the problem - we (geeks and coders) are a HUGE minority when it comes to employees and needed work resources. Not every one of us works for a web shop! When I have taught programming, I tell my students that programmers are wired differently; we see the world from a different point of view than most others... even others that embrace and encourage technology. Put another way, unless our manager was a coder at some time, they will never understand how we can operate given the right conditions. Hatton ~| 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-Jobs-Talk/message.cfm/messageid:3809 Subscription: http://www.houseoffusion.com/groups/CF-Jobs-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11
RE: What is it with telecommuting?
Given the current market, that wouldn't be acceptable. You're still asking someone to carry two mortgages for up to 120 days, and Kroger would need to buy the house at fair market value, as determined by an independent appraiser. PS: I'm really not interested in relocating, we've (my wife and I) have been in Raleigh for less than a year and we really kind of like it here :) -- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (919) 874-6229 (home) (703) 220-2835 (cell) -Original Message- From: Adam Haskell [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 20, 2008 8:54 PM To: CF-Jobs-Talk Subject: Re: What is it with telecommuting? When/if Kroger relocates someone they valuate the house and buy it out after 90 or 120 days (something like that, at least they used to do this). Oh and did I mention we are hiring right now if anyone is interested in relocating to a city that is actually flat in housing values instead of declining ;) Seriously if you are interested we are hiring Cincinnati Ohio, anyone? anyone? Adam Haskell On Tue, May 20, 2008 at 3:51 PM, Scott Stewart [EMAIL PROTECTED] wrote: When proper life cycle development processes are followed, there are deadlines and milestones built in, if your consistently not meeting your deadlines, then the employer can look elsewhere. It's going to come to a point where employers will have to trust their telecommuters, the daily commute is going to become too expensive for even highly paid knowledge workers. Or employers are going to have to subsidize actual commuting, and buy the houses of folks that they want to relocate. -- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (919) 874-6229 (home) (703) 220-2835 (cell) -Original Message- From: Jeffry Houser [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 20, 2008 3:08 PM To: CF-Jobs-Talk Subject: Re: What is it with telecommuting? Communication is easier for many people if it is done in person. I expect this to change in a generation or two, but that is the way it is for many people now. There is also a trust issue. If you're at home and I am paying you hourly, how do I know that you're really doing work for me for all the time I am paying you? How do I even know that you're working at all and are going to meet deadlines? Phillip Vector wrote: On Tue, May 20, 2008 at 11:44 AM, C. Hatton Humphrey [EMAIL PROTECTED] wrote: Understandably, most places want people on-site. The best tele opportunity I was was one where you went on-site for a month on the company dime and then came in for meetings every quarter. That way there was the possibility of meeting and interfacing with people and the remote aspect. Why is this understandable? I mean, What purpose could it serve to require someone to be on site when security of data is not an issue (through access to resources)? ~| 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-Jobs-Talk/message.cfm/messageid:3812 Subscription: http://www.houseoffusion.com/groups/CF-Jobs-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11
RE: What is it with telecommuting?
I should probably clarify something, I'm not adverse to dropping into the office on occasion, on the company's dime, when it's necessary to push progress forward. -- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (919) 874-6229 (home) (703) 220-2835 (cell) -Original Message- From: Adam Haskell [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 20, 2008 8:54 PM To: CF-Jobs-Talk Subject: Re: What is it with telecommuting? When/if Kroger relocates someone they valuate the house and buy it out after 90 or 120 days (something like that, at least they used to do this). Oh and did I mention we are hiring right now if anyone is interested in relocating to a city that is actually flat in housing values instead of declining ;) Seriously if you are interested we are hiring Cincinnati Ohio, anyone? anyone? Adam Haskell On Tue, May 20, 2008 at 3:51 PM, Scott Stewart [EMAIL PROTECTED] wrote: When proper life cycle development processes are followed, there are deadlines and milestones built in, if your consistently not meeting your deadlines, then the employer can look elsewhere. It's going to come to a point where employers will have to trust their telecommuters, the daily commute is going to become too expensive for even highly paid knowledge workers. Or employers are going to have to subsidize actual commuting, and buy the houses of folks that they want to relocate. -- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (919) 874-6229 (home) (703) 220-2835 (cell) -Original Message- From: Jeffry Houser [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 20, 2008 3:08 PM To: CF-Jobs-Talk Subject: Re: What is it with telecommuting? Communication is easier for many people if it is done in person. I expect this to change in a generation or two, but that is the way it is for many people now. There is also a trust issue. If you're at home and I am paying you hourly, how do I know that you're really doing work for me for all the time I am paying you? How do I even know that you're working at all and are going to meet deadlines? Phillip Vector wrote: On Tue, May 20, 2008 at 11:44 AM, C. Hatton Humphrey [EMAIL PROTECTED] wrote: Understandably, most places want people on-site. The best tele opportunity I was was one where you went on-site for a month on the company dime and then came in for meetings every quarter. That way there was the possibility of meeting and interfacing with people and the remote aspect. Why is this understandable? I mean, What purpose could it serve to require someone to be on site when security of data is not an issue (through access to resources)? ~| 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-Jobs-Talk/message.cfm/messageid:3813 Subscription: http://www.houseoffusion.com/groups/CF-Jobs-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11
Re: What is it with telecommuting?
Scott there are all sorts of loans you can refinance into that will let you go without paying double mortgage for upto XXX days. A lot of folks do not know about these programs but they do exist and most of these loans are not predatory lending most Realtors know about the good ones(my wife is a Realtor). On the aspect of the fair market value that is absolutely correct, and in my case my fair market value is below my mortgage and I would be screwed. I made the mistake of building a house RIGHT before the market went stale and I am stuck. I'm not trying to convince anyone that relocating is easy or an company can make it painless. Its a pain regardless even if a company does pay to relocate that is taxable income which will bite you in the butt at the end of the year :) Adam Haskell On Wed, May 21, 2008 at 9:54 AM, Scott Stewart [EMAIL PROTECTED] wrote: Given the current market, that wouldn't be acceptable. You're still asking someone to carry two mortgages for up to 120 days, and Kroger would need to buy the house at fair market value, as determined by an independent appraiser. PS: I'm really not interested in relocating, we've (my wife and I) have been in Raleigh for less than a year and we really kind of like it here :) -- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (919) 874-6229 (home) (703) 220-2835 (cell) -Original Message- From: Adam Haskell [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 20, 2008 8:54 PM To: CF-Jobs-Talk Subject: Re: What is it with telecommuting? When/if Kroger relocates someone they valuate the house and buy it out after 90 or 120 days (something like that, at least they used to do this). Oh and did I mention we are hiring right now if anyone is interested in relocating to a city that is actually flat in housing values instead of declining ;) Seriously if you are interested we are hiring Cincinnati Ohio, anyone? anyone? Adam Haskell On Tue, May 20, 2008 at 3:51 PM, Scott Stewart [EMAIL PROTECTED] wrote: When proper life cycle development processes are followed, there are deadlines and milestones built in, if your consistently not meeting your deadlines, then the employer can look elsewhere. It's going to come to a point where employers will have to trust their telecommuters, the daily commute is going to become too expensive for even highly paid knowledge workers. Or employers are going to have to subsidize actual commuting, and buy the houses of folks that they want to relocate. -- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (919) 874-6229 (home) (703) 220-2835 (cell) -Original Message- From: Jeffry Houser [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 20, 2008 3:08 PM To: CF-Jobs-Talk Subject: Re: What is it with telecommuting? Communication is easier for many people if it is done in person. I expect this to change in a generation or two, but that is the way it is for many people now. There is also a trust issue. If you're at home and I am paying you hourly, how do I know that you're really doing work for me for all the time I am paying you? How do I even know that you're working at all and are going to meet deadlines? Phillip Vector wrote: On Tue, May 20, 2008 at 11:44 AM, C. Hatton Humphrey [EMAIL PROTECTED] wrote: Understandably, most places want people on-site. The best tele opportunity I was was one where you went on-site for a month on the company dime and then came in for meetings every quarter. That way there was the possibility of meeting and interfacing with people and the remote aspect. Why is this understandable? I mean, What purpose could it serve to require someone to be on site when security of data is not an issue (through access to resources)? ~| 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-Jobs-Talk/message.cfm/messageid:3815 Subscription: http://www.houseoffusion.com/groups/CF-Jobs-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11
RE: What is it with telecommuting?
In the broader scope, asking anyone to relocate, is really a stretch right now, if they're a homeowner. A company needs to step up and make it as painless as possible. -- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (919) 874-6229 (home) (703) 220-2835 (cell) -Original Message- From: Adam Haskell [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 21, 2008 10:57 AM To: CF-Jobs-Talk Subject: Re: What is it with telecommuting? Scott there are all sorts of loans you can refinance into that will let you go without paying double mortgage for upto XXX days. A lot of folks do not know about these programs but they do exist and most of these loans are not predatory lending most Realtors know about the good ones(my wife is a Realtor). On the aspect of the fair market value that is absolutely correct, and in my case my fair market value is below my mortgage and I would be screwed. I made the mistake of building a house RIGHT before the market went stale and I am stuck. I'm not trying to convince anyone that relocating is easy or an company can make it painless. Its a pain regardless even if a company does pay to relocate that is taxable income which will bite you in the butt at the end of the year :) Adam Haskell On Wed, May 21, 2008 at 9:54 AM, Scott Stewart [EMAIL PROTECTED] wrote: Given the current market, that wouldn't be acceptable. You're still asking someone to carry two mortgages for up to 120 days, and Kroger would need to buy the house at fair market value, as determined by an independent appraiser. PS: I'm really not interested in relocating, we've (my wife and I) have been in Raleigh for less than a year and we really kind of like it here :) -- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (919) 874-6229 (home) (703) 220-2835 (cell) -Original Message- From: Adam Haskell [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 20, 2008 8:54 PM To: CF-Jobs-Talk Subject: Re: What is it with telecommuting? When/if Kroger relocates someone they valuate the house and buy it out after 90 or 120 days (something like that, at least they used to do this). Oh and did I mention we are hiring right now if anyone is interested in relocating to a city that is actually flat in housing values instead of declining ;) Seriously if you are interested we are hiring Cincinnati Ohio, anyone? anyone? Adam Haskell On Tue, May 20, 2008 at 3:51 PM, Scott Stewart [EMAIL PROTECTED] wrote: When proper life cycle development processes are followed, there are deadlines and milestones built in, if your consistently not meeting your deadlines, then the employer can look elsewhere. It's going to come to a point where employers will have to trust their telecommuters, the daily commute is going to become too expensive for even highly paid knowledge workers. Or employers are going to have to subsidize actual commuting, and buy the houses of folks that they want to relocate. -- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (919) 874-6229 (home) (703) 220-2835 (cell) -Original Message- From: Jeffry Houser [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 20, 2008 3:08 PM To: CF-Jobs-Talk Subject: Re: What is it with telecommuting? Communication is easier for many people if it is done in person. I expect this to change in a generation or two, but that is the way it is for many people now. There is also a trust issue. If you're at home and I am paying you hourly, how do I know that you're really doing work for me for all the time I am paying you? How do I even know that you're working at all and are going to meet deadlines? Phillip Vector wrote: On Tue, May 20, 2008 at 11:44 AM, C. Hatton Humphrey [EMAIL PROTECTED] wrote: Understandably, most places want people on-site. The best tele opportunity I was was one where you went on-site for a month on the company dime and then came in for meetings every quarter. That way there was the possibility of meeting and interfacing with people and the remote aspect. Why is this understandable? I mean, What purpose could it serve to require someone to be on site when security of data is not an issue (through access to resources)? ~| 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-Jobs-Talk/message.cfm/messageid:3816 Subscription: http://www.houseoffusion.com/groups/CF-Jobs-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11
RE: What is it with telecommuting?
can this thread die now please? Mobile email powered by Nokia Intellisync Original Message From: Scott Stewart [EMAIL PROTECTED] Date: 5/21/08 9:54 am To: CFJobsTalk cf-jobs-talk@houseoffusion.com Subj: RE: What is it with telecommuting? Given the current market, that wouldn't be acceptable. You're still asking someone to carry two mortgages for up to 120 days, and Kroger would need to buy the house at fair market value, as determined by an independent appraiser. PS: I'm really not interested in relocating, we've (my wife and I) have been in Raleigh for less than a year and we really kind of like it here :) -- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (919) 874-6229 (home) (703) 220-2835 (cell) -Original Message- From: Adam Haskell [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 20, 2008 8:54 PM To: CF-Jobs-Talk Subject: Re: What is it with telecommuting? When/if Kroger relocates someone they valuate the house and buy it out after 90 or 120 days (something like that, at least they used to do this). Oh and did I mention we are hiring right now if anyone is interested in relocating to a city that is actually flat in housing values instead of declining ;) Seriously if you are interested we are hiring Cincinnati Ohio, anyone? anyone? Adam Haskell On Tue, May 20, 2008 at 3:51 PM, Scott Stewart wrote: When proper life cycle development processes are followed, there are deadlines and milestones built in, if your consistently not meeting your deadlines, then the employer can look elsewhere. It's going to come to a point where employers will have to trust their telecommuters, the daily commute is going to become too expensive for even highly paid knowledge workers. Or employers are going to have to subsidize actual commuting, and buy the houses of folks that they want to relocate. -- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (919) 874-6229 (home) (703) 220-2835 (cell) -Original Message- From: Jeffry Houser [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 20, 2008 3:08 PM To: CF-Jobs-Talk Subject: Re: What is it with telecommuting? Communication is easier for many people if it is done in person. I expect this to change in a generation or two, but that is the way it is for many people now. There is also a trust issue. If you're at home and I am paying you hourly, how do I know that you're really doing work for me for all the time I am paying you? How do I even know that you're working at all and are going to meet deadlines? Phillip Vector wrote: On Tue, May 20, 2008 at 11:44 AM, C. Hatton Humphrey wrote: Understandably, most places want people on-site. The best tele opportunity I was was one where you went on-site for a month on the company dime and then came in for meetings every quarter. That way there was the possibility of meeting and interfacing with people and the remote aspect. Why is this understandable? I mean, What purpose could it serve to require someone to be on site when security of data is not an issue (through access to resources)? ~| 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-Jobs-Talk/message.cfm/messageid:3817 Subscription: http://www.houseoffusion.com/groups/CF-Jobs-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11
RE: What is it with telecommuting?
So have I, if for no other reason than for me to vent and get some understanding of the situation. -- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (919) 874-6229 (home) (703) 220-2835 (cell) -Original Message- From: Jeffry Houser [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 21, 2008 11:55 AM To: CF-Jobs-Talk Subject: Re: What is it with telecommuting? I've found this to be an interesting thread myself; and is a talk list. I haven't seen Michael's post more than once yet. Scott Stewart wrote: Why? PS: didja have to post this twice? -- Jeffry Houser Flex, ColdFusion, AIR AIM: Reboog711 | Phone: 1-203-379-0773 -- Adobe Community Expert http://www.adobe.com/communities/experts/members/JeffryHouser.html My Company: http://www.dot-com-it.com My Podcast: http://www.theflexshow.com My Blog: http://www.jeffryhouser.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-Jobs-Talk/message.cfm/messageid:3821 Subscription: http://www.houseoffusion.com/groups/CF-Jobs-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11
Re: What is it with telecommuting?
I think the debate on the benefits and disadvantages of telecommuting is fascinating. I think it's important, whether you work onsite or from your home office remotely, to keep up clear and effective communication. At one point, when I had just had my first child, I tried to work remotely for a company from my house. It didn't work because my boss at the time (they had transferred me to a new department) was so busy that she couldn't communicate effectively with me. I would call her and she would never return my calls. My emails went unanswered. It was very frustrating. Eventually, I quit - but I imagine that if I had a more responsive boss, I might have stayed on. And with a different company, it might have worked. So I guess it very much depends on who the players are, and how communicative they are - how effectively do they work when working remotely? Some people just need to be there in the office. And some bosses seem to need that face time. Judith ~| 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-Jobs-Talk/message.cfm/messageid:3822 Subscription: http://www.houseoffusion.com/groups/CF-Jobs-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11
Re: What is it with telecommuting?
On Wed, May 21, 2008 at 11:03 AM, Judith Dinowitz [EMAIL PROTECTED] wrote: I think the debate on the benefits and disadvantages of telecommuting is fascinating. I think it's important, whether you work onsite or from your home office remotely, to keep up clear and effective communication. It is a good discussion. I've been telecommuting for about 1.5 years now. My home is in Kentucky, my employer is in Los Angeles area. The 5 other team members and I use IM, email and phone to keep in touch. Our development is structured with assigned tasks and continual status updates. I know I miss out on some discussions and decisions, but that is okay with me. Last year I visited the office about once a quarter, but this year I have not yet been out. I would guess that from the employer point-of-view the ideal situation is to have all employees in the office. But when they start having problems finding and keeping employees with the desired qualifications, they should consider remote employees. -- Matt Williams It's the question that drives us. ~| 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-Jobs-Talk/message.cfm/messageid:3823 Subscription: http://www.houseoffusion.com/groups/CF-Jobs-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11
Re: What is it with telecommuting?
Why? This is a legitimate discussion topic for CF-Jobs-Talk. If you don't like the threat, just hit the delete button. On Wed, May 21, 2008 at 11:44 AM, Michael Perlstein [EMAIL PROTECTED] wrote: can this thread die now please? ~| 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-Jobs-Talk/message.cfm/messageid:3824 Subscription: http://www.houseoffusion.com/groups/CF-Jobs-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11
Re: Achieve Masters that you deserve of Established Skilled Institution.
Kill what? Your inner demons yearning to spam your hard-won list of emails? LOL. Even if the email came with a couple of lines that said This really, really is from Michael, it would take me a while to believe it. I am always amazed at how clean this list is, in regards to spam. Even valid self-promotion is self-policed to a wonderful extent. Of course, I would love to know which member of the community causes these, as it is obvious it is a member who understands the community who is spamming us with lies. I'd would chip in to pay for a ticket for you and Loathe to go visit them, and explain why it is a bad idea. On Wed, May 21, 2008 at 2:11 PM, Michael Dinowitz [EMAIL PROTECTED] wrote: Please ignore while I kill this. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Jobs-Talk/message.cfm/messageid:3827 Subscription: http://www.houseoffusion.com/groups/CF-Jobs-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11
RE: What is it with telecommuting?
Tack on a fuel surcharge fee to your contracting fee. Airlines and UPS do it... -Original Message- From: Scott Stewart [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 20, 2008 11:39 AM To: CF-Jobs-Talk Subject: What is it with telecommuting? I get contacted by recruiters almost daily.. Why is it that in a depressed housing market, many employers won't even consider telecommuters? I do understand the reasoning behind TSI and above clearance contracts, but non secure and private employers really don't have a valid reason not to. The chances of people, especially homeowners, considering relocation right now is almost non existant. Just my $.02. discuss. -- Scott Stewart ColdFusion Developer SSTWebworks 4405 Oakshyre Way Raleigh, NC. 27616 (919) 874-6229 (home) (703) 220-2835 (cell) ~| 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-Jobs-Talk/message.cfm/messageid:3830 Subscription: http://www.houseoffusion.com/groups/CF-Jobs-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11