Annoying SequeLink JDBC Driver failure
I have a CF8 app which gets updates from an ancient ODBC datasource at 15 min intervals. Generally it works fine, but once or twice a week it gets the error: Error Type: Database Message: Error Executing Database Query. Detail: [Macromedia][SequeLink JDBC Driver][ODBC Socket][TSODBC]FrameRead:NetRead header This is unavoidable and could be caused by any number of reasons, primarily because the datasource is the other side of London, but what happens next is the problem; from then onwards CF8 seems to get 'stuck' with the error: Error Type: Database Message: Error Executing Database Query. Detail: [Macromedia][SequeLink JDBC Driver]An internal error occurred. And it seems at least a CF8 service restart and sometimes a complete server reboot is the only thing which will fix it. Has anyone any ideas how to reset the SequeLink JDBC Driver in a more graceful fashion? Preferably automatically Regards Richard ~| 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:306874 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Annoying SequeLink JDBC Driver failure
Richard Meredith-Hardy wrote: I have a CF8 app which gets updates from an ancient ODBC datasource at 15 min intervals. Generally it works fine, but once or twice a week it gets the error: Error Type: Database Message: Error Executing Database Query. Detail: [Macromedia][SequeLink JDBC Driver][ODBC Socket][TSODBC]FrameRead:NetRead header Looks like this error is actually in the ODBC network driver. And it seems at least a CF8 service restart and sometimes a complete server reboot is the only thing which will fix it. Has anyone any ideas how to reset the SequeLink JDBC Driver in a more graceful fashion? Preferably automatically Since the ODBC network driver is loaded in the ODBC Server process I would expect a restart of the ODBC Service to fix any problems between the ODBC Service and the remote database. Just uncheck the maintain connection checkbox for the connection between CF and the ODBC Service to make sure that connection gets reset every time (I don't think that will have significant performance impact compared to talking to a remote database). Jochem ~| 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:306875 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Recommendations for a Knowledgebase written in CFML?
Not quite. I was looking for a CFML version of something similar to www.kbpublisher.com Thanks! I also experienced a bit of slowness when the search was Loading However, the reason for this reply is I did see Context-based Help tag on RiaForge. Does this do what you want? Cheers, Wil Genovese One man with courage makes a majority. -Andrew Jackson A fine is a tax for doing wrong. A tax is a fine for doing well. On Jun 5, 2008, at 12:26 AM, Alex Sherwood 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:306876 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF Studio 5
Sounds like it's time to move to another editor. -Original Message- From: Dave Long [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 04, 2008 5:02 PM To: CF-Talk Subject: CF Studio 5 I've had to reformat my computer after 5years of faithful service. After re-installing Macromedia Studio MX, I realized it only has Homesite 5.0+. Does anyone know where I can download a copy of ColdFusion Studio 5.0? Of course, they are very similar but there seem to be some features that are different. Adobe has insulated itself rather well from users who don't upgrade so I'm hoping someone here knows of a safe download site. Dave Long NorthGoods Merchant Services 103 E. Wisconsin Avenue Tomahawk, WI 54487-1471 (715) 453-7414 -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ~| 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:306877 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
listtoarray?
Hi we have various string values like the following: qu_45_tb_45_split_0_split_q_67 we need to break this string down into 3 array elements and split it based on the string '_split_' if the listtoarray function used this actual sequence to break the string up then we would be given an array: elem[1] = qu_45_tb_45 elem[2] = 0 elem[3] = q_67 which is how we need it. but of course the listtoarray uses each string charaacter as a delimeter to break the string down and therefore doesnt produce what we need is there an alternative that we can use that will break this down based on the entire sequence '_split_' we have looked through the livedocs and are sure this is achievable through the uses of 2 or 3 functions but cannot worj out quiet how to do it thanks for your help richard ~| 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:306878 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: listtoarray?
cfset myList = Replace('qu_45_tb_45_split_0_split_q_67', '_split', ',') cfset aMyList = ListToArray(myList) On Thu, Jun 5, 2008 at 5:01 PM, Richard White [EMAIL PROTECTED] wrote: Hi we have various string values like the following: qu_45_tb_45_split_0_split_q_67 we need to break this string down into 3 array elements and split it based on the string '_split_' if the listtoarray function used this actual sequence to break the string up then we would be given an array: elem[1] = qu_45_tb_45 elem[2] = 0 elem[3] = q_67 which is how we need it. but of course the listtoarray uses each string charaacter as a delimeter to break the string down and therefore doesnt produce what we need is there an alternative that we can use that will break this down based on the entire sequence '_split_' we have looked through the livedocs and are sure this is achievable through the uses of 2 or 3 functions but cannot worj out quiet how to do it thanks for your help richard ~| 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:306879 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: listtoarray?
Sorry, should be cfset myList = Replace('qu_45_tb_45_split_0_split_q_67', '_split_', ',') (forgot an underscore after split) On Thu, Jun 5, 2008 at 5:08 PM, Didgiman [EMAIL PROTECTED] wrote: cfset myList = Replace('qu_45_tb_45_split_0_split_q_67', '_split', ',') cfset aMyList = ListToArray(myList) On Thu, Jun 5, 2008 at 5:01 PM, Richard White [EMAIL PROTECTED] wrote: Hi we have various string values like the following: qu_45_tb_45_split_0_split_q_67 we need to break this string down into 3 array elements and split it based on the string '_split_' if the listtoarray function used this actual sequence to break the string up then we would be given an array: elem[1] = qu_45_tb_45 elem[2] = 0 elem[3] = q_67 which is how we need it. but of course the listtoarray uses each string charaacter as a delimeter to break the string down and therefore doesnt produce what we need is there an alternative that we can use that will break this down based on the entire sequence '_split_' we have looked through the livedocs and are sure this is achievable through the uses of 2 or 3 functions but cannot worj out quiet how to do it thanks for your help richard ~| 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:306880 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: listtoarray?
Sorry, one more mistake... cfset myList = Replace('qu_45_tb_45_split_0_split_q_67', '_split_', ',', 'ALL') On Thu, Jun 5, 2008 at 5:09 PM, Didgiman [EMAIL PROTECTED] wrote: Sorry, should be cfset myList = Replace('qu_45_tb_45_split_0_split_q_67', '_split_', ',') (forgot an underscore after split) On Thu, Jun 5, 2008 at 5:08 PM, Didgiman [EMAIL PROTECTED] wrote: cfset myList = Replace('qu_45_tb_45_split_0_split_q_67', '_split', ',') cfset aMyList = ListToArray(myList) On Thu, Jun 5, 2008 at 5:01 PM, Richard White [EMAIL PROTECTED] wrote: Hi we have various string values like the following: qu_45_tb_45_split_0_split_q_67 we need to break this string down into 3 array elements and split it based on the string '_split_' if the listtoarray function used this actual sequence to break the string up then we would be given an array: elem[1] = qu_45_tb_45 elem[2] = 0 elem[3] = q_67 which is how we need it. but of course the listtoarray uses each string charaacter as a delimeter to break the string down and therefore doesnt produce what we need is there an alternative that we can use that will break this down based on the entire sequence '_split_' we have looked through the livedocs and are sure this is achievable through the uses of 2 or 3 functions but cannot worj out quiet how to do it thanks for your help richard ~| 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:306881 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: listtoarray?
So let me get this right. You looked at the manuals / cfdocs, and you couldn't work out this: cfset myArray = listToArray(myList, '_split_') / Seems to me that what you have described, is the way to go... Is it not? On Fri, Jun 6, 2008 at 1:01 AM, Richard White [EMAIL PROTECTED] wrote: Hi we have various string values like the following: qu_45_tb_45_split_0_split_q_67 we need to break this string down into 3 array elements and split it based on the string '_split_' if the listtoarray function used this actual sequence to break the string up then we would be given an array: elem[1] = qu_45_tb_45 elem[2] = 0 elem[3] = q_67 which is how we need it. but of course the listtoarray uses each string charaacter as a delimeter to break the string down and therefore doesnt produce what we need is there an alternative that we can use that will break this down based on the entire sequence '_split_' we have looked through the livedocs and are sure this is achievable through the uses of 2 or 3 functions but cannot worj out quiet how to do it thanks for your help richard ~| 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:306882 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: listtoarray?
cfset myList = Replace('qu_45_tb_45_split_0_split_q_67', '_split', ',') cfset aMyList = ListToArray(myList) On Thu, Jun 5, 2008 at 5:01 PM, Richard White [EMAIL PROTECTED] wrote: excellent thanks very much :) ~| 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:306883 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: listtoarray?
Easy now... list delimiters are only a single character. When you specify a delimiter of multiple characters is uses ANY of them to split the list. Your example below would yield the following array: array 1 qu 2 45 3 b 4 45 5 0 6 q 7 67 Not quite what the original poster was asking for. ~Brad -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED] Sent: Thursday, June 05, 2008 10:16 AM To: CF-Talk Subject: Re: listtoarray? So let me get this right. You looked at the manuals / cfdocs, and you couldn't work out this: cfset myArray = listToArray(myList, '_split_') / Seems to me that what you have described, is the way to go... Is it not? ~| 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:306884 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: listtoarray?
The delimiter' parameter is not used as a literal string, but as a group of individual delimiters. Run this sample code, and you'll clearly see that is does not do what you might expext of it. cfset variables.TestList = qu_45_tb_45_split_0_split_q_67 cfset variables.SplitTest = ListToArray(variables.TestList,_split_) cfdump var=#variables.SplitTest# On Thu, Jun 5, 2008 at 10:15 AM, Andrew Scott [EMAIL PROTECTED] wrote: So let me get this right. You looked at the manuals / cfdocs, and you couldn't work out this: cfset myArray = listToArray(myList, '_split_') / Seems to me that what you have described, is the way to go... Is it not? ~| 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:306885 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Recommendations for a Knowledgebase written in CFML?
Why not just use a Wiki? !k -Original Message- From: Alex Sherwood [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 04, 2008 8:53 PM To: CF-Talk Subject: Recommendations for a Knowledgebase written in CFML? Greetings, I've searched high and low and have yet to find a knowledgebase application written in CFML. Project Management/Time Entry apps seem to be plenty - KB apps, not so much! Places I've searched: Google upteen ways, Charlie Aerhart, Adobe.com Developer Forums, etc. If anyone has experience with a pre-built KB app. written in CFML, it would be greatly appreciated. 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:306886 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: listtoarray?
Then here is what I would do, it doesn't solve your problem. But it is a bug with Coldfusion. Report this as a bug, it allows for a string. That should mean any amount of chars, and not just one. On Fri, Jun 6, 2008 at 1:24 AM, Brad Wood [EMAIL PROTECTED] wrote: Easy now... list delimiters are only a single character. When you specify a delimiter of multiple characters is uses ANY of them to split the list. Your example below would yield the following array: array 1 qu 2 45 3 b 4 45 5 0 6 q 7 67 Not quite what the original poster was asking for. ~Brad -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED] Sent: Thursday, June 05, 2008 10:16 AM To: CF-Talk Subject: Re: listtoarray? So let me get this right. You looked at the manuals / cfdocs, and you couldn't work out this: cfset myArray = listToArray(myList, '_split_') / Seems to me that what you have described, is the way to go... Is it not? ~| 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:306887 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: listtoarray?
no need for the scope variables if not in a function. Point taken, but it is a bug as far as I am concerned. On Fri, Jun 6, 2008 at 1:33 AM, morgan l [EMAIL PROTECTED] wrote: The delimiter' parameter is not used as a literal string, but as a group of individual delimiters. Run this sample code, and you'll clearly see that is does not do what you might expext of it. cfset variables.TestList = qu_45_tb_45_split_0_split_q_67 cfset variables.SplitTest = ListToArray(variables.TestList,_split_) cfdump var=#variables.SplitTest# On Thu, Jun 5, 2008 at 10:15 AM, Andrew Scott [EMAIL PROTECTED] wrote: So let me get this right. You looked at the manuals / cfdocs, and you couldn't work out this: cfset myArray = listToArray(myList, '_split_') / Seems to me that what you have described, is the way to go... Is it not? ~| 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:306888 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: listtoarray?
It's always been like this. Since CF 4.5 or earlier afaik. What makes you think it's a bug? On Thu, Jun 5, 2008 at 5:35 PM, Andrew Scott [EMAIL PROTECTED] wrote: no need for the scope variables if not in a function. Point taken, but it is a bug as far as I am concerned. On Fri, Jun 6, 2008 at 1:33 AM, morgan l [EMAIL PROTECTED] wrote: The delimiter' parameter is not used as a literal string, but as a group of individual delimiters. Run this sample code, and you'll clearly see that is does not do what you might expext of it. cfset variables.TestList = qu_45_tb_45_split_0_split_q_67 cfset variables.SplitTest = ListToArray(variables.TestList,_split_) cfdump var=#variables.SplitTest# On Thu, Jun 5, 2008 at 10:15 AM, Andrew Scott [EMAIL PROTECTED] wrote: So let me get this right. You looked at the manuals / cfdocs, and you couldn't work out this: cfset myArray = listToArray(myList, '_split_') / Seems to me that what you have described, is the way to go... Is it not? ~| 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:306889 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Anything wrong with this code?
(Simplified version... MySQL 5) cfloop query='get_hmls_commercial_data' cfquery name='insert_data' datasource='x' insert into properties (mls_number) values (cfqueryparam cfsqltype='cf_sql_varchar' value='#get_hmls_commercial_data.mls_number#_h' null='#not len(trim(mls_number))#') where '#get_hmls_commercial_data.mls_number#_h' not in (select mls_number from properties) /cfquery /cfloop I'm getting this error upon execution of the template... Error Executing Database Query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where '39438_h' not exists in (select mls_number from prope' at line 32 ??? 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:306890 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: listtoarray?
This is from ColdFusion 8's documentation: delimiters A string or a variable that contains one. ColdFusion treats each character in the string as a delimiter. The default value is comma. Emphasis: *ColdFusion treats each character in the string as a delimiter.* Tricky I know, but not a bug. ~Brad -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED] Sent: Thursday, June 05, 2008 10:35 AM To: CF-Talk Subject: Re: listtoarray? Then here is what I would do, it doesn't solve your problem. But it is a bug with Coldfusion. Report this as a bug, it allows for a string. That should mean any amount of chars, and not just one. ~| 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:306891 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: listtoarray?
You got to this before me. I think by simple definition, a list is a single character delimited string. If something delimited by _split_ is more complex and a simple replace as suggested would be in order. Or you could write a nifty UDF using other String functions such as Find and REFind. -- Jake Churchill Team Leader CF Webtools 11204 Davenport, Ste. 100 Omaha, NE 68154 http://www.cfwebtools.com 402-408-3733 x103 Didgiman wrote: It's always been like this. Since CF 4.5 or earlier afaik. What makes you think it's a bug? On Thu, Jun 5, 2008 at 5:35 PM, Andrew Scott [EMAIL PROTECTED] wrote: no need for the scope variables if not in a function. Point taken, but it is a bug as far as I am concerned. On Fri, Jun 6, 2008 at 1:33 AM, morgan l [EMAIL PROTECTED] wrote: The delimiter' parameter is not used as a literal string, but as a group of individual delimiters. Run this sample code, and you'll clearly see that is does not do what you might expext of it. cfset variables.TestList = qu_45_tb_45_split_0_split_q_67 cfset variables.SplitTest = ListToArray(variables.TestList,_split_) cfdump var=#variables.SplitTest# On Thu, Jun 5, 2008 at 10:15 AM, Andrew Scott [EMAIL PROTECTED] wrote: So let me get this right. You looked at the manuals / cfdocs, and you couldn't work out this: cfset myArray = listToArray(myList, '_split_') / Seems to me that what you have described, is the way to go... Is it not? ~| 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:306892 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: listtoarray?
Yeah I realise that it is or has been that way for a long time. Just because it has, does it mean it is not a bug? The thing is that we live in a world of comma deliminated files. The point is who says that this has to be one character? Allaire/Macromedia/Adobe? This is the first time I have seen more than one character used, and I will have to say that the ENGINE (that means smith, openBD, railo and Adobe) needs to adopt the changing market. On Fri, Jun 6, 2008 at 1:39 AM, Didgiman [EMAIL PROTECTED] wrote: It's always been like this. Since CF 4.5 or earlier afaik. What makes you think it's a bug? On Thu, Jun 5, 2008 at 5:35 PM, Andrew Scott [EMAIL PROTECTED] wrote: no need for the scope variables if not in a function. Point taken, but it is a bug as far as I am concerned. On Fri, Jun 6, 2008 at 1:33 AM, morgan l [EMAIL PROTECTED] wrote: The delimiter' parameter is not used as a literal string, but as a group of individual delimiters. Run this sample code, and you'll clearly see that is does not do what you might expext of it. cfset variables.TestList = qu_45_tb_45_split_0_split_q_67 cfset variables.SplitTest = ListToArray(variables.TestList,_split_) cfdump var=#variables.SplitTest# On Thu, Jun 5, 2008 at 10:15 AM, Andrew Scott [EMAIL PROTECTED] wrote: So let me get this right. You looked at the manuals / cfdocs, and you couldn't work out this: cfset myArray = listToArray(myList, '_split_') / Seems to me that what you have described, is the way to go... Is it not? ~| 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:306893 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Anything wrong with this code?
Kind of a dumb thing I'm trying to do...trying to combine an insert statement with a where clause. I think I need another approach. Back to the drawing board... Rick -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Thursday, June 05, 2008 11:40 AM To: CF-Talk Subject: Anything wrong with this code? (Simplified version... MySQL 5) cfloop query='get_hmls_commercial_data' cfquery name='insert_data' datasource='x' insert into properties (mls_number) values (cfqueryparam cfsqltype='cf_sql_varchar' value='#get_hmls_commercial_data.mls_number#_h' null='#not len(trim(mls_number))#') where '#get_hmls_commercial_data.mls_number#_h' not in (select mls_number from properties) /cfquery /cfloop I'm getting this error upon execution of the template... Error Executing Database Query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where '39438_h' not exists in (select mls_number from prope' at line 32 ??? 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:306894 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: listtoarray?
Wow. Sure, it could be done differently as in the java/javascript split() methods but: a) it was done this way for a reason, it has its use - it was *deliberate* (not a bug) b) changing it could/would have serious backward compatibility implications c) creating a custom UDF to handle this is extremely simple d) if adobe should do anything, it might be to supply the above UDF as a built in function My tuppence, Dominic 2008/6/5 Andrew Scott [EMAIL PROTECTED]: Yeah I realise that it is or has been that way for a long time. Just because it has, does it mean it is not a bug? The thing is that we live in a world of comma deliminated files. The point is who says that this has to be one character? Allaire/Macromedia/Adobe? This is the first time I have seen more than one character used, and I will have to say that the ENGINE (that means smith, openBD, railo and Adobe) needs to adopt the changing market. On Fri, Jun 6, 2008 at 1:39 AM, Didgiman [EMAIL PROTECTED] wrote: It's always been like this. Since CF 4.5 or earlier afaik. What makes you think it's a bug? On Thu, Jun 5, 2008 at 5:35 PM, Andrew Scott [EMAIL PROTECTED] wrote: no need for the scope variables if not in a function. Point taken, but it is a bug as far as I am concerned. On Fri, Jun 6, 2008 at 1:33 AM, morgan l [EMAIL PROTECTED] wrote: The delimiter' parameter is not used as a literal string, but as a group of individual delimiters. Run this sample code, and you'll clearly see that is does not do what you might expext of it. cfset variables.TestList = qu_45_tb_45_split_0_split_q_67 cfset variables.SplitTest = ListToArray(variables.TestList,_split_) cfdump var=#variables.SplitTest# On Thu, Jun 5, 2008 at 10:15 AM, Andrew Scott [EMAIL PROTECTED] wrote: So let me get this right. You looked at the manuals / cfdocs, and you couldn't work out this: cfset myArray = listToArray(myList, '_split_') / Seems to me that what you have described, is the way to go... Is it not? ~| 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:306895 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Anything wrong with this code?
:-) it sounds like version of mysql doesn't support where '#get_hmls_commercial_data.mls_number#_h' not in (select mls_number from properties) On Fri, Jun 6, 2008 at 1:56 AM, Rick Faircloth [EMAIL PROTECTED] wrote: Kind of a dumb thing I'm trying to do...trying to combine an insert statement with a where clause. I think I need another approach. Back to the drawing board... Rick -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Thursday, June 05, 2008 11:40 AM To: CF-Talk Subject: Anything wrong with this code? (Simplified version... MySQL 5) cfloop query='get_hmls_commercial_data' cfquery name='insert_data' datasource='x' insert into properties (mls_number) values (cfqueryparam cfsqltype='cf_sql_varchar' value='#get_hmls_commercial_data.mls_number#_h' null='#not len(trim(mls_number))#') where '#get_hmls_commercial_data.mls_number#_h' not in (select mls_number from properties) /cfquery /cfloop I'm getting this error upon execution of the template... Error Executing Database Query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where '39438_h' not exists in (select mls_number from prope' at line 32 ??? 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:306896 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Anything wrong with this code?
Just a quick glance but could you do something like: Insert into properties(mls_number) Values(select mls_number from table where whatever) I think that's the syntac but you may not need the values piece. I can't remember off hand but I've done combined insert/select statements like that before and it basically inserts a row for each row it selects. Does that make sense? The other thing you could do is a Query of a query before you do the loop and weed it out so you only have the criteria you want coming into the loop. Hope that helps. John -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Thursday, June 05, 2008 11:57 AM To: CF-Talk Subject: RE: Anything wrong with this code? Kind of a dumb thing I'm trying to do...trying to combine an insert statement with a where clause. I think I need another approach. Back to the drawing board... Rick -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Thursday, June 05, 2008 11:40 AM To: CF-Talk Subject: Anything wrong with this code? (Simplified version... MySQL 5) cfloop query='get_hmls_commercial_data' cfquery name='insert_data' datasource='x' insert into properties (mls_number) values (cfqueryparam cfsqltype='cf_sql_varchar' value='#get_hmls_commercial_data.mls_number#_h' null='#not len(trim(mls_number))#') where '#get_hmls_commercial_data.mls_number#_h' not in (select mls_number from properties) /cfquery /cfloop I'm getting this error upon execution of the template... Error Executing Database Query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where '39438_h' not exists in (select mls_number from prope' at line 32 ??? 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:306897 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Anything wrong with this code?
What are you trying to do. I may be able to suggest an idea. On Thu, Jun 5, 2008 at 8:56 AM, Rick Faircloth [EMAIL PROTECTED] wrote: Kind of a dumb thing I'm trying to do...trying to combine an insert statement with a where clause. I think I need another approach. Back to the drawing board... Rick -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Thursday, June 05, 2008 11:40 AM To: CF-Talk Subject: Anything wrong with this code? (Simplified version... MySQL 5) cfloop query='get_hmls_commercial_data' cfquery name='insert_data' datasource='x' insert into properties (mls_number) values (cfqueryparam cfsqltype='cf_sql_varchar' value='#get_hmls_commercial_data.mls_number#_h' null='#not len(trim(mls_number))#') where '#get_hmls_commercial_data.mls_number#_h' not in (select mls_number from properties) /cfquery /cfloop I'm getting this error upon execution of the template... Error Executing Database Query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where '39438_h' not exists in (select mls_number from prope' at line 32 ??? 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:306898 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CFLDAP groups
I have run into a big problem setting and searching dynamic groups and was told static groups are the most supported and most understood. I created a static group and added some members; now I am trying to search for members of this group and am facing difficulties. This is the code I am using and its on Windows 2003 Will appreciate your help as always. cfldap action=QUERY name=GetLDAP3 attributes=uid start=ou=new group, ou=groups,dc=example,dc=com Scope=subtree filter=((objectclass=groupOfUniqueNames)(cn=New Group)(uniqueMember=*)) server=xxx.xxx.x.xxx Port=1389 username=cn=ldapforwindows password=sunforwindows ~| 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:306899 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Anything wrong with this code?
Not sure about MySQL but this would work in MSSql IF (NOT EXISTS ( select * from properties where mls_number = cfqueryparam cfsqltype='cf_sql_varchar' value='#get_hmls_commercial_data.mls_number#_h' ) BEGIN insert into properties (mls_number) values (cfqueryparam cfsqltype='cf_sql_varchar' value='#get_hmls_commercial_data.mls_number#_h' null='#not len(trim(mls_number))#') END Also, I suspect you don't really want the NULL in that cfqueryparam, but I may be wrong (?) HTH Dominic 2008/6/5 Rick Faircloth [EMAIL PROTECTED]: Kind of a dumb thing I'm trying to do...trying to combine an insert statement with a where clause. I think I need another approach. Back to the drawing board... Rick -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Thursday, June 05, 2008 11:40 AM To: CF-Talk Subject: Anything wrong with this code? (Simplified version... MySQL 5) cfloop query='get_hmls_commercial_data' cfquery name='insert_data' datasource='x' insert into properties (mls_number) values (cfqueryparam cfsqltype='cf_sql_varchar' value='#get_hmls_commercial_data.mls_number#_h' null='#not len(trim(mls_number))#') where '#get_hmls_commercial_data.mls_number#_h' not in (select mls_number from properties) /cfquery /cfloop I'm getting this error upon execution of the template... Error Executing Database Query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where '39438_h' not exists in (select mls_number from prope' at line 32 ??? 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:306900 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: listtoarray?
Just because a company tells us that it should work this way, doesn't mean it is the way it should be:-) Look at all the enhancements, and bug fixes since the days of Allaire. It is upto us, the community to decide whether we belive it is a bug or not. I belive it is, and I would petiton for it to change to a string. What if I wanted to do it on a chr(10) chr(13) I can't and that is a valid 2 character delimination. We need to adopt, not stay behind. And let me say this, if Adobe / Macromedia / Allaire where ever worried about backward compatabilit Then there would be no and I will repeat myself, there would be no obsolete functions or tags It is upto you as a developer to voice your opinion, if you accept the dfault behaviour means you are willing to remain in th past. Your choice not mine. On Fri, Jun 6, 2008 at 1:59 AM, Dominic Watson [EMAIL PROTECTED] wrote: Wow. Sure, it could be done differently as in the java/javascript split() methods but: a) it was done this way for a reason, it has its use - it was *deliberate* (not a bug) b) changing it could/would have serious backward compatibility implications c) creating a custom UDF to handle this is extremely simple d) if adobe should do anything, it might be to supply the above UDF as a built in function My tuppence, Dominic 2008/6/5 Andrew Scott [EMAIL PROTECTED]: Yeah I realise that it is or has been that way for a long time. Just because it has, does it mean it is not a bug? The thing is that we live in a world of comma deliminated files. The point is who says that this has to be one character? Allaire/Macromedia/Adobe? This is the first time I have seen more than one character used, and I will have to say that the ENGINE (that means smith, openBD, railo and Adobe) needs to adopt the changing market. On Fri, Jun 6, 2008 at 1:39 AM, Didgiman [EMAIL PROTECTED] wrote: It's always been like this. Since CF 4.5 or earlier afaik. What makes you think it's a bug? On Thu, Jun 5, 2008 at 5:35 PM, Andrew Scott [EMAIL PROTECTED] wrote: no need for the scope variables if not in a function. Point taken, but it is a bug as far as I am concerned. On Fri, Jun 6, 2008 at 1:33 AM, morgan l [EMAIL PROTECTED] wrote: The delimiter' parameter is not used as a literal string, but as a group of individual delimiters. Run this sample code, and you'll clearly see that is does not do what you might expext of it. cfset variables.TestList = qu_45_tb_45_split_0_split_q_67 cfset variables.SplitTest = ListToArray(variables.TestList,_split_) cfdump var=#variables.SplitTest# On Thu, Jun 5, 2008 at 10:15 AM, Andrew Scott [EMAIL PROTECTED] wrote: So let me get this right. You looked at the manuals / cfdocs, and you couldn't work out this: cfset myArray = listToArray(myList, '_split_') / Seems to me that what you have described, is the way to go... Is it not? ~| 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:306901 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: listtoarray?
What if I wanted to do it on a chr(10) chr(13) I can't and that is a valid 2 character delimination. We need to adopt, not stay behind. Try it, it works. Consider the string: this is chr(10) chr(13) my string. Delimiting the string by either chr(10) or chr(13) will create two items (as will using a delimiter of chr(13) chr(10). Indeed, if delimiters did not work this way in ColdFusion, using a delimiter of chr(13) chr(10) would have undesirable results - it would only work for a text file created in an operating system that uses both chr(13) chr(10) (in that order) to indicate a newline - whereas this is not always the case. That is a darn good reason for it to work this way. It may be undesirable functionality to some, but by *no means* does that make it a bug! Dominic -- Blog it up: http://fusion.dominicwatson.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:306902 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: listtoarray?
If used as a delimiter, how should CF interpret the following: _split_ Should it be _split_ as a complete sequence of characters or should it allow any of the characters to be an individual delimiter? How would you choose with method that CF should interpret the delimiter? We do not have the extra argument to instruct CF how to interpert such as: listToArray(myList, _split_, match) where _split_ equates to a single delimiter. or listToArray(myList, _split_, any) where the delimiter could be any of the following: _ s p l i t I don't think it's a bug. I just think it's something to know. m!ke -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED] Sent: Thursday, June 05, 2008 10:48 AM To: CF-Talk Subject: Re: listtoarray? Yeah I realise that it is or has been that way for a long time. Just because it has, does it mean it is not a bug? The thing is that we live in a world of comma deliminated files. The point is who says that this has to be one character? Allaire/Macromedia/Adobe? This is the first time I have seen more than one character used, and I will have to say that the ENGINE (that means smith, openBD, railo and Adobe) needs to adopt the changing market. ~| 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:306903 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: listtoarray?
It is upto us, the community to decide whether we belive it is a bug or not. No, it isn't. The word bug has a pretty specific meaning as a term of art. Whether Adobe should change the current behavior is an open question, but either way this isn't a bug. And let me say this, if Adobe / Macromedia / Allaire where ever worried about backward compatabilit Then there would be no and I will repeat myself, there would be no obsolete functions or tags That's absurd on its face. The CF team has done a great job with backward compatibility overall. The vast bulk of code written with CF 3 works with CF 8. But what makes this really absurd is the binary nature of your statement. If you were ever worried about your health, you would have no and I will repeat myself, you would have no alcohol or fatty foods, etc. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:306905 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: listtoarray?
Just because it has, does it mean it is not a bug? No. What makes it not a bug is that it conforms to what the documentation says it does. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306906 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: listtoarray?
Ok maybe bug is strong. Not that it is more than right as far as I am concerned. Sure backward compatability has to be the foremost and utmost. But let me say this. Who is right the developer who said whe only need to deliminate one one characater. Or the develepors 12 years later saying we need it fixed to accomodate what we need? Bug or not, it seems more and more look and see it as a bug or would it be safe to say an unwanted unrealistic expectation? On Fri, Jun 6, 2008 at 2:32 AM, Dave Watts [EMAIL PROTECTED] wrote: It is upto us, the community to decide whether we belive it is a bug or not. No, it isn't. The word bug has a pretty specific meaning as a term of art. Whether Adobe should change the current behavior is an open question, but either way this isn't a bug. And let me say this, if Adobe / Macromedia / Allaire where ever worried about backward compatabilit Then there would be no and I will repeat myself, there would be no obsolete functions or tags That's absurd on its face. The CF team has done a great job with backward compatibility overall. The vast bulk of code written with CF 3 works with CF 8. But what makes this really absurd is the binary nature of your statement. If you were ever worried about your health, you would have no and I will repeat myself, you would have no alcohol or fatty foods, etc. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:306907 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: listtoarray?
It should be the entire sequence. One has to remember that this function is now nearly 12 years since it was introduced this way. Does it still make it the right decision by Allaire? No it doesn't, I would like to do one / two or even three or more characters for seperation. Does that mean that Allaire, 12 years ago could invision that we only ever wanted the one char? Or does it mean that we are prepaired to put up with the fact wer are willing to told what we should do? Me, well I will complain. If it works in my favour it works. Otherwise I will continue to harp on the fact it needs to be changed to adopt the change of technology or methodology or even progress. On Fri, Jun 6, 2008 at 2:16 AM, Dawson, Michael [EMAIL PROTECTED] wrote: If used as a delimiter, how should CF interpret the following: _split_ Should it be _split_ as a complete sequence of characters or should it allow any of the characters to be an individual delimiter? How would you choose with method that CF should interpret the delimiter? We do not have the extra argument to instruct CF how to interpert such as: listToArray(myList, _split_, match) where _split_ equates to a single delimiter. or listToArray(myList, _split_, any) where the delimiter could be any of the following: _ s p l i t I don't think it's a bug. I just think it's something to know. m!ke -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED] Sent: Thursday, June 05, 2008 10:48 AM To: CF-Talk Subject: Re: listtoarray? Yeah I realise that it is or has been that way for a long time. Just because it has, does it mean it is not a bug? The thing is that we live in a world of comma deliminated files. The point is who says that this has to be one character? Allaire/Macromedia/Adobe? This is the first time I have seen more than one character used, and I will have to say that the ENGINE (that means smith, openBD, railo and Adobe) needs to adopt the changing market. ~| 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:306904 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: listtoarray?
You can't have multi-character delimiters...thanks for trying. -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED] Sent: Thursday, June 05, 2008 10:16 AM To: CF-Talk Subject: Re: listtoarray? So let me get this right. You looked at the manuals / cfdocs, and you couldn't work out this: cfset myArray = listToArray(myList, '_split_') / Seems to me that what you have described, is the way to go... Is it not? On Fri, Jun 6, 2008 at 1:01 AM, Richard White [EMAIL PROTECTED] wrote: Hi we have various string values like the following: qu_45_tb_45_split_0_split_q_67 we need to break this string down into 3 array elements and split it based on the string '_split_' if the listtoarray function used this actual sequence to break the string up then we would be given an array: elem[1] = qu_45_tb_45 elem[2] = 0 elem[3] = q_67 which is how we need it. but of course the listtoarray uses each string charaacter as a delimeter to break the string down and therefore doesnt produce what we need is there an alternative that we can use that will break this down based on the entire sequence '_split_' we have looked through the livedocs and are sure this is achievable through the uses of 2 or 3 functions but cannot worj out quiet how to do it thanks for your help richard ~| 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:306908 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: listtoarray?
I agree that you should be able to pass in a single string and not have it treated as multiple characters, but it's NOT a bug if the method behaves as stated in the docs. -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED] Sent: Thursday, June 05, 2008 10:48 AM To: CF-Talk Subject: Re: listtoarray? Yeah I realise that it is or has been that way for a long time. Just because it has, does it mean it is not a bug? The thing is that we live in a world of comma deliminated files. The point is who says that this has to be one character? Allaire/Macromedia/Adobe? This is the first time I have seen more than one character used, and I will have to say that the ENGINE (that means smith, openBD, railo and Adobe) needs to adopt the changing market. On Fri, Jun 6, 2008 at 1:39 AM, Didgiman [EMAIL PROTECTED] wrote: It's always been like this. Since CF 4.5 or earlier afaik. What makes you think it's a bug? On Thu, Jun 5, 2008 at 5:35 PM, Andrew Scott [EMAIL PROTECTED] wrote: no need for the scope variables if not in a function. Point taken, but it is a bug as far as I am concerned. On Fri, Jun 6, 2008 at 1:33 AM, morgan l [EMAIL PROTECTED] wrote: The delimiter' parameter is not used as a literal string, but as a group of individual delimiters. Run this sample code, and you'll clearly see that is does not do what you might expext of it. cfset variables.TestList = qu_45_tb_45_split_0_split_q_67 cfset variables.SplitTest = ListToArray(variables.TestList,_split_) cfdump var=#variables.SplitTest# On Thu, Jun 5, 2008 at 10:15 AM, Andrew Scott [EMAIL PROTECTED] wrote: So let me get this right. You looked at the manuals / cfdocs, and you couldn't work out this: cfset myArray = listToArray(myList, '_split_') / Seems to me that what you have described, is the way to go... Is it not? ~| 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:306909 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Anything wrong with this code?
That would be a cool feature if they added that to SQL so you could do that. You could test to see if the mls number already exists, if not, then insert it...I am not a DBA, but I am sure there is also a SQL solution to doing this as well. I would just check using CF personally. Eric /*-Original Message- /*From: Rick Faircloth [mailto:[EMAIL PROTECTED] /*Sent: Thursday, June 05, 2008 10:57 AM /*To: CF-Talk /*Subject: RE: Anything wrong with this code? /* /*Kind of a dumb thing I'm trying to do...trying to combine /*an insert statement with a where clause. /* /*I think I need another approach. /* /*Back to the drawing board... /* /*Rick /* /* /* -Original Message- /* From: Rick Faircloth [mailto:[EMAIL PROTECTED] /* Sent: Thursday, June 05, 2008 11:40 AM /* To: CF-Talk /* Subject: Anything wrong with this code? /* /* (Simplified version... MySQL 5) /* /* cfloop query='get_hmls_commercial_data' /* /* cfquery name='insert_data' datasource='x' /* /* insert into properties /* /* (mls_number) /* /* values (cfqueryparam cfsqltype='cf_sql_varchar' /* value='#get_hmls_commercial_data.mls_number#_h' null='#not /*len(trim(mls_number))#') /* /* where '#get_hmls_commercial_data.mls_number#_h' not in /* (select mls_number from properties) /* /* /cfquery /* /* /cfloop /* /* I'm getting this error upon execution of the template... /* /* Error Executing Database Query. /* You have an error in your SQL syntax; /* check the manual that corresponds to your MySQL server version /* for the right syntax to use near /* 'where '39438_h' not exists in (select mls_number from prope' at line 32 /* /* ??? /* /* 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:306910 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: listtoarray?
Ok maybe bug is strong. Not that it is more than right as far as I am concerned. Sure backward compatability has to be the foremost and utmost. But let me say this. Who is right the developer who said whe only need to deliminate one one characater. Or the develepors 12 years later saying we need it fixed to accomodate what we need? Bug or not, it seems more and more look and see it as a bug or would it be safe to say an unwanted unrealistic expectation? I don't know, and as a consultant who gets paid to fix others' code, I don't really even care that much. What I do care about, in this instance, is the usage of the word bug. As a software developer, I have a strong interest in this word being defined as clearly and unambiguously as possible. I've had to deal with enough users in my time who would complain about this bug or that bug, even though the application conformed exactly to the specification provided. If the term bug is watered down to mean simply something that doesn't do what I want it to, specifications lose their value to the development process. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306911 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Anything wrong with this code?
I gave that syntax a try, but MySQL didn't like even the if at the beginning. Thanks anyway... Rick -Original Message- From: Dominic Watson [mailto:[EMAIL PROTECTED] Sent: Thursday, June 05, 2008 12:05 PM To: CF-Talk Subject: Re: Anything wrong with this code? Not sure about MySQL but this would work in MSSql IF (NOT EXISTS ( select * from properties where mls_number = cfqueryparam cfsqltype='cf_sql_varchar' value='#get_hmls_commercial_data.mls_number#_h' ) BEGIN insert into properties (mls_number) values (cfqueryparam cfsqltype='cf_sql_varchar' value='#get_hmls_commercial_data.mls_number#_h' null='#not len(trim(mls_number))#') END Also, I suspect you don't really want the NULL in that cfqueryparam, but I may be wrong (?) HTH Dominic 2008/6/5 Rick Faircloth [EMAIL PROTECTED]: Kind of a dumb thing I'm trying to do...trying to combine an insert statement with a where clause. I think I need another approach. Back to the drawing board... Rick -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Thursday, June 05, 2008 11:40 AM To: CF-Talk Subject: Anything wrong with this code? (Simplified version... MySQL 5) cfloop query='get_hmls_commercial_data' cfquery name='insert_data' datasource='x' insert into properties (mls_number) values (cfqueryparam cfsqltype='cf_sql_varchar' value='#get_hmls_commercial_data.mls_number#_h' null='#not len(trim(mls_number))#') where '#get_hmls_commercial_data.mls_number#_h' not in (select mls_number from properties) /cfquery /cfloop I'm getting this error upon execution of the template... Error Executing Database Query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where '39438_h' not exists in (select mls_number from prope' at line 32 ??? 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:306912 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CF 7 Certification Exam
I'm wanting to take the CF 7 Certification exam. I wasn't able to find any reference to the CF 7 exam on Adobe's website, only CF 8. However, when I log in to the VUE website to see what exams are available, they have both the CF 7 and CF 8 exams listed. Whenever I try to schedule the CF 7 exam, it tells me the exam is not available, but I don't have any problem when I try to schedule the CF 8 exam. So, obviously VUE is not offering the CF 7 exam anymore (at least in my area), even though it's still listed on their site. After Ray Camden's recent post about the CF 8 exam (http://www.coldfusionjedi.com/index.cfm/2008/6/3/Open-Letter-to-Adobe-on-Certification), I'm really not interested in taking it at this time, I'd rather take CF 7, if for no other reason than my own personal satisfaction. My question is, is this the official word from Adobe and no one is offering CF 7 anymore, or is there a chance I can still take the CF 7 Certification exam somewhere? Thanks! Eric ~| 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:306913 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Anything wrong with this code?
Isn't it supposed to be WHERE [COLUMN] not in (select mls_number from properties)... Joe Velez Rick Faircloth wrote: (Simplified version... MySQL 5) cfloop query='get_hmls_commercial_data' cfquery name='insert_data' datasource='x' insert into properties (mls_number) values (cfqueryparam cfsqltype='cf_sql_varchar' value='#get_hmls_commercial_data.mls_number#_h' null='#not len(trim(mls_number))#') where '#get_hmls_commercial_data.mls_number#_h' not in (select mls_number from properties) /cfquery /cfloop I'm getting this error upon execution of the template... Error Executing Database Query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where '39438_h' not exists in (select mls_number from prope' at line 32 ??? 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:306914 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: listtoarray?
Yep, you should be able to use any string as a delimiter. I thought I read someone say do a replace. Since you know the delimiter is _split_ why not do something like: cfset original_var = 'qu_45_tb_45_split_0_split_q_67' cfset new_var=replace(original_var, '_split_', '|', 'ALL') cfset newarray=listtoarray(new_var,'|') cfdump var='#newarray#' I think this is what the guy wanted to do. Correct? Joe Velez Dave Watts wrote: Ok maybe bug is strong. Not that it is more than right as far as I am concerned. Sure backward compatability has to be the foremost and utmost. But let me say this. Who is right the developer who said whe only need to deliminate one one characater. Or the develepors 12 years later saying we need it fixed to accomodate what we need? Bug or not, it seems more and more look and see it as a bug or would it be safe to say an unwanted unrealistic expectation? I don't know, and as a consultant who gets paid to fix others' code, I don't really even care that much. What I do care about, in this instance, is the usage of the word bug. As a software developer, I have a strong interest in this word being defined as clearly and unambiguously as possible. I've had to deal with enough users in my time who would complain about this bug or that bug, even though the application conformed exactly to the specification provided. If the term bug is watered down to mean simply something that doesn't do what I want it to, specifications lose their value to the development process. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306915 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: listtoarray?
The word bug, as already mentioned elsewhere is thrown around too greatly to describe too many problems. I have heard all levels of users utilize the word to describe anything that isn't the way they want it right now. Everything from query sorting to simple static text changes. As a programmer, the word 'bug' gets my attention, and I have become less inclined to react quickly now that the word is abused. The word should mean 'error in results'. The program runs but gives the incorrect data. If the page breaks, it is 'broken'. If the text doesn't sound right, it is a 'change request'. If the user wants the program to do more, it is an 'update' or an 'upgrade'. The arraytolist function is old enough to be set in stone as to how it reacts to the delimiters. However, if you wanted to request an upgrade, I wouldn't be adverse to Adobe adding a new parameter like was mentioned here by someone else, which indicates the entire string as a single 'match', but the default should and must be the way the function is now. Calling it a bug doesn't make it a bug. There is an easy work around in order to get the functionality that you desire by nesting the replace function inside the arraylist function. We are programmers who constantly have to translate data received into what we need in order to work with it and then export it back to what the receiver wanted. This is what we do and we have the perfect tool for doing it. There isn't much that ColdFusion can't do that we may want it to do. If you can't figure out what you need to have done, done, that is what this board is for; finding help to the questions you have. Which is exactly what the original poster did, and they got the perfect response, an answer to their question that works. I have fallen in love with the idea that I can create a UDF and do ANYTHING that I want in coldfusion. Recently I have talked some of the developers that I am consulting with into creating a centralized email function using a CFC. The simple reason is that they found a flaw in their previous method which required them to go to every cfmail tag and make a change in it. Loving CF, William Point taken, but it is a bug as far as I am concerned. ~| 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:306916 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: listtoarray?
-- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306917 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: listtoarray?
Just because it has, does it mean it is not a bug? No, it doesn't. But in this case, it is just the way Allaire has defined it: look at all list functions, the parameter is delimiters, not delimiter, and the description says Set of delimiters used in list, not string used as delimiter The thing is that we live in a world of comma deliminated files. The point is who says that this has to be one character? Allaire/Macromedia/Adobe? As far as CF is concerned, absolutely. For other languages it is up to their creators. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306918 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: listtoarray?
Well said, Claude. I'll throw in that in my opinion, most definitely not a bug. It may not work the way some of us want, but it's documented to work a certain way, and it works that way. Can I say that if I prefer arrays to start at zero then CF arrays are inherently filled with bugs? Now, somewhat more on topic... Rupesh Kumar wrote a UDF that accomodates multi-character delimiters using Java's underlying split() method. http://coldfused.blogspot.com/2007/06/listtoarray-with-empty-elements-part-ii.html So write yourself a quick UDF and bug resolved :) On Thu, Jun 5, 2008 at 10:34 AM, Claude Schneegans [EMAIL PROTECTED] wrote: -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306919 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: listtoarray?
One has to remember that this function is now nearly 12 years since it was introduced this way. Does it still make it the right decision by Allaire? No it doesn't, but it is definitely not a bug. One could see it as a flaw in design, at a pinch, but not a bug. A bug is when something does not performed as specified. The delimiters in CF lists do perform as specified. Take the way empty elements are ignored in lists, this IMHO is a flaw in design, plus a PITA, but definitely not a bug either. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306920 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFLDAP groups
You did not specify what your exact difficulties are, so I will just respond with a general message regarding LDAP and groups. I am more experienced with Active Directory, but it appears that you are using Sun's LDAP server. (I assumed this by your example's LDAP attributes and your password.) Even if my suggestions don't work, verbatim, you should still be able to use the concept. Normally, you have two options for getting a group's members. 1. Query the group and return the members. 2. Query all users who are a member of the group. I prefer the second method because I can also return other attributes, such as the user's name, email and telephone number. The filter, for my second suggestion, would be something like: ((objectClass=user)(memberOf=CN=MyGroup, DC=domain, DC=com)) This filter will return all user accounts who are a member of the MyGroup domain group. (Edit the attributes as needed for your LDAP server.) If you post your exact issue, I can try to help more. m!ke -Original Message- From: Den Made [mailto:[EMAIL PROTECTED] Sent: Thursday, June 05, 2008 11:03 AM To: CF-Talk Subject: CFLDAP groups I have run into a big problem setting and searching dynamic groups and was told static groups are the most supported and most understood. I created a static group and added some members; now I am trying to search for members of this group and am facing difficulties. This is the code I am using and its on Windows 2003 Will appreciate your help as always. cfldap action=QUERY name=GetLDAP3 attributes=uid start=ou=new group, ou=groups,dc=example,dc=com Scope=subtree filter=((objectclass=groupOfUniqueNames)(cn=New Group)(uniqueMember=*)) server=xxx.xxx.x.xxx Port=1389 username=cn=ldapforwindows password=sunforwindows ~| 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:306921 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Anything wrong with this code?
Here's what I'm trying to accomplish...it's relatively simple, or so I thought. Got a temp table of data (hmls_commercial_temp). I want to transfer that data to the table, hmls_commercial. Before I transfer the records, I want to check and make sure a record for each row in hmls_commercial_temp doesn't already exist in the hmls_commercial table. This is a better approach than doing complete wipe of the data in the receiving table and just replacing all the records. That seems like a waste of time and resources. Suggestions? Thanks, Rick -Original Message- From: Phillip Vector [mailto:[EMAIL PROTECTED] Sent: Thursday, June 05, 2008 12:03 PM To: CF-Talk Subject: Re: Anything wrong with this code? What are you trying to do. I may be able to suggest an idea. On Thu, Jun 5, 2008 at 8:56 AM, Rick Faircloth [EMAIL PROTECTED] wrote: Kind of a dumb thing I'm trying to do...trying to combine an insert statement with a where clause. I think I need another approach. Back to the drawing board... Rick -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Thursday, June 05, 2008 11:40 AM To: CF-Talk Subject: Anything wrong with this code? (Simplified version... MySQL 5) cfloop query='get_hmls_commercial_data' cfquery name='insert_data' datasource='x' insert into properties (mls_number) values (cfqueryparam cfsqltype='cf_sql_varchar' value='#get_hmls_commercial_data.mls_number#_h' null='#not len(trim(mls_number))#') where '#get_hmls_commercial_data.mls_number#_h' not in (select mls_number from properties) /cfquery /cfloop I'm getting this error upon execution of the template... Error Executing Database Query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where '39438_h' not exists in (select mls_number from prope' at line 32 ??? 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:306923 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Anything wrong with this code?
Rick Faircloth wrote: (Simplified version... MySQL 5) cfloop query='get_hmls_commercial_data' cfquery name='insert_data' datasource='x' Do get_hmls_commercial_data and insert_data query the same database? In that case you should do: INSERT INTO properties (mls_number) SELECT ... FROM ... WHERE mls_number NOT IN ( SELECT mls_number FROM properties ) Jochem ~| 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:306922 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Anything wrong with this code? - Shameless Plug
[ADVERT] Or, simply purchase a ready to go MLS search solution from the company I work for. We have the MLS data for over 200 MLS markets. http://www.wolfnet.com http://www.mlsfinder.com [/ADVERT] Wil Genovese Sr. Web Application Developer One man with courage makes a majority. -Andrew Jackson A fine is a tax for doing wrong. A tax is a fine for doing well. On Jun 5, 2008, at 12:58 PM, Jochem van Dieten wrote: Rick Faircloth wrote: (Simplified version... MySQL 5) cfloop query='get_hmls_commercial_data' cfquery name='insert_data' datasource='x' Do get_hmls_commercial_data and insert_data query the same database? In that case you should do: INSERT INTO properties (mls_number) SELECT ... FROM ... WHERE mls_number NOT IN ( SELECT mls_number FROM properties ) Jochem ~| 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:306924 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Railo 3 - Open Source with JBoss
Railo announced today that they are joining JBoss.org and going Open Source. The license will be LGPL2. More information is available on jboss.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:306925 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFLDAP groups
Thanks Michael, I am using Sun Directory Server 6.0 on Windows 2003. I created a static group and Added users from different Organizational Units (Group Member (uniqueMember) Now I want to Query the group to find all Members of this group: i.e. cn=New Group,ou=Groups,dc=example,dc=comin using the CFLDAP tag below but I am not finding the members, what am I doing wrong? cfldap action=QUERY name=GetLDAP3 attributes=uid start=dc=example,dc=com Scope=subtree filter=((objectClass=groupOfUniqueNames)(memberOf=cn=New Group, dc=example, dc=com)) server=xxx.xxx.x.xxx Port=1389 username=cn=ldapwindowsmanager password=windows2008 ~| 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:306926 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Railo 3 - Open Source with JBoss
Now with cfvideo and cfvideoplayer No really. http://www.railo-technologies.com/en/index.cfm?treeID=354 On Thu, Jun 5, 2008 at 2:09 PM, Peter Boughton [EMAIL PROTECTED] wrote: Railo announced today that they are joining JBoss.org and going Open Source. The license will be LGPL2. More information is available on jboss.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:306927 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Anything wrong with this code?
Ok, that's working (using a different table for the insert, 'hmls_commercial' rather than the 'properties' table for testing) with this code insert into hmls_commercial ( mls_number ) select mls_number from hmls_commercial_temp where mls_number not in ( select substring_index(mls_number, '_', 1 ) as mls_num from hmls_commercial ) I had to use 'substring_index...' because the mls_number in the final table is tagged with _h or _s depending on which MLS the property data is from. The final issue with this query, however, is how do I insert values that are not in the table supplying the data. What I mean is, when I run the query, I need to insert extra data into the target table, such as: values ( cfqueryparam cfsqltype='cf_sql_varchar' value='hmls', cfqueryparam cfsqltype='cf_sql_varchar' value='#mls_number#_h' ) How would I write the query so I can specify other values to be inserted? I had this same problem using the 'dual' function in mysql... it checked for the duplicates, but I couldn't insert additional values because the column count didn't match. At least I couldn't figure out a way to do it. But is it possible to modify your query for the additional values, Jochem? Thanks, Rick -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Thursday, June 05, 2008 1:58 PM To: CF-Talk Subject: Re: Anything wrong with this code? Rick Faircloth wrote: (Simplified version... MySQL 5) cfloop query='get_hmls_commercial_data' cfquery name='insert_data' datasource='x' Do get_hmls_commercial_data and insert_data query the same database? In that case you should do: INSERT INTO properties (mls_number) SELECT ... FROM ... WHERE mls_number NOT IN ( SELECT mls_number FROM properties ) Jochem ~| 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:306928 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Railo 3 - Open Source with JBoss
Railo announced today that they are joining JBoss.org and going Open Source. The license will be LGPL2. More information is available on jboss.org :) Very interesting, especially with the integration with messaging and JBoss caching. I wonder if this has any anything to do with open BlueDragon's release? ~| 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:306929 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
HTTP Servlet Request
I'm working with some java classes provided by a third party. The class requires an HTTP servlet request object be sent. Within that request, the class looks for url parameters via the HTTP Servlet Request. The following code is what I'm using currently... cfscript SearchLogic = createobject(java,com.web.SearchLogic); REQ = createObject(Java,javax.servlet.http.HttpServletRequest); REQ = GetPageContext().getRequest(); SearchLogic.search(REQ); /cfscript The problem is that I cannot have url variables on the page sending the request and we would rather not have to do some sort of redirect or cfhttp to get the url variables for load time reasons. Does anybody know if the request parameters can be set somehow? ~| 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:306930 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: HTTP Servlet Request
You cannot set paramters on a request, the parameters are immutable. So you'll have to synthesize your own request if you want do do it that way. However, a better approach would probably be to split the search engine into it's own tier and access it that way. cheers, barneyb On Thu, Jun 5, 2008 at 1:05 PM, Marcus Goedeker [EMAIL PROTECTED] wrote: I'm working with some java classes provided by a third party. The class requires an HTTP servlet request object be sent. Within that request, the class looks for url parameters via the HTTP Servlet Request. The following code is what I'm using currently... cfscript SearchLogic = createobject(java,com.web.SearchLogic); REQ = createObject(Java,javax.servlet.http.HttpServletRequest); REQ = GetPageContext().getRequest(); SearchLogic.search(REQ); /cfscript The problem is that I cannot have url variables on the page sending the request and we would rather not have to do some sort of redirect or cfhttp to get the url variables for load time reasons. Does anybody know if the request parameters can be set somehow? ~| 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:306931 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Railo 3 - Open Source with JBoss
I'd say that's a strong certainty. Maybe they think that if BD has to go open source, Railo won't have a chance? I'm pretty sure that the lead developer for Railo is on this list...Gert I think is his name? -Original Message- From: Larry Lyons [mailto:[EMAIL PROTECTED] Sent: Thursday, June 05, 2008 2:42 PM To: CF-Talk Subject: Re: Railo 3 - Open Source with JBoss Railo announced today that they are joining JBoss.org and going Open Source. The license will be LGPL2. More information is available on jboss.org :) Very interesting, especially with the integration with messaging and JBoss caching. I wonder if this has any anything to do with open BlueDragon's release? ~| 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:306932 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFLDAP groups
You only need half of your filter. You are requesting LDAP to return objects of class = groupOfUniqueNames that is also a member of that group. The only way this will return any records is if you have a group nested within that other group. Get rid of the first part of the filter and only search on the memberOf attribute. filter=memberOf=CN=New Group, dc=example, dc=com If you want to tidy it up and return only users, then change your current filter from groupOfUniqueNames to user or whatever the Sun attribute is for a user. m!ke -Original Message- From: Den Made [mailto:[EMAIL PROTECTED] Sent: Thursday, June 05, 2008 1:30 PM To: CF-Talk Subject: Re: CFLDAP groups Thanks Michael, I am using Sun Directory Server 6.0 on Windows 2003. I created a static group and Added users from different Organizational Units (Group Member (uniqueMember) Now I want to Query the group to find all Members of this group: i.e. cn=New Group,ou=Groups,dc=example,dc=comin using the CFLDAP tag below but I am not finding the members, what am I doing wrong? cfldap action=QUERY name=GetLDAP3 attributes=uid start=dc=example,dc=com Scope=subtree filter=((objectClass=groupOfUniqueNames)(memberOf=cn=New Group, dc=example, dc=com)) server=xxx.xxx.x.xxx Port=1389 username=cn=ldapwindowsmanager password=windows2008 ~| 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:306933 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Anything wrong with this code?
Ok... it works like this: insert into hmls_commercial ( mls_number, listing_office ) select mls_number, 'hmls' as listing_office from hmls_commercial_temp where mls_number not in ( select substring_index(mls_number, '_', 1 ) as mls_num from hmls_commercial ) -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Thursday, June 05, 2008 2:42 PM To: CF-Talk Subject: RE: Anything wrong with this code? ~| 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:306934 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Railo 3 - Open Source with JBoss
Adam Lehman (Adobe) has a great blog entry http://www.adrocknaphobia.com/post.cfm/breaking-railo-partners-with-jbossorg-to-open-source-cfml On Fri, Jun 6, 2008 at 4:24 AM, Andy Matthews [EMAIL PROTECTED] wrote: I'd say that's a strong certainty. Maybe they think that if BD has to go open source, Railo won't have a chance? I'm pretty sure that the lead developer for Railo is on this list...Gert I think is his name? -Original Message- From: Larry Lyons [mailto:[EMAIL PROTECTED] Sent: Thursday, June 05, 2008 2:42 PM To: CF-Talk Subject: Re: Railo 3 - Open Source with JBoss Railo announced today that they are joining JBoss.org and going Open Source. The license will be LGPL2. More information is available on jboss.org :) Very interesting, especially with the integration with messaging and JBoss caching. I wonder if this has any anything to do with open BlueDragon's release? ~| 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:306935 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Railo 3 - Open Source with JBoss
I think (and know) you are wrong. Do you think it takes a week for a company like Railo to turn open source with someone like Red Hat? Two weeks? ok.. a month? Its a big business decision, that was taken before BD even announced their intentions. Gert Franz is the guy that runs Railo. MD On 5 Jun 2008, at 21:24, Andy Matthews wrote: I'd say that's a strong certainty. Maybe they think that if BD has to go open source, Railo won't have a chance? I'm pretty sure that the lead developer for Railo is on this list...Gert I think is his name? -Original Message- From: Larry Lyons [mailto:[EMAIL PROTECTED] Sent: Thursday, June 05, 2008 2:42 PM To: CF-Talk Subject: Re: Railo 3 - Open Source with JBoss Railo announced today that they are joining JBoss.org and going Open Source. The license will be LGPL2. More information is available on jboss.org :) Very interesting, especially with the integration with messaging and JBoss caching. I wonder if this has any anything to do with open BlueDragon's release? ~| 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:306936 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Bug / Issue tracking
I'd like to subscribe to a service (free would be great, but I'm more then happy to pay for it) where my clients can post bugs, request features, submit new tasks, etc. What are other small time developers using? Is basecamp a good choice for this? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306937 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Bug / Issue tracking
I love lighthouse. Love it, love it, love it. We also use basecamp, but more for project knowledge sharing. If you need a hosted solution, find a small cf hosting shop, and see if they will install it for you, and charge you a monthly fee. On Thu, Jun 5, 2008 at 7:52 PM, Jeff Gladnick [EMAIL PROTECTED] wrote: I'd like to subscribe to a service (free would be great, but I'm more then happy to pay for it) where my clients can post bugs, request features, submit new tasks, etc. What are other small time developers using? Is basecamp a good choice for this? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306938 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Railo 3 - Open Source with JBoss
The LGPL2 license is much more attractive than a straight GPL license. I am really not up on the nuances of OS licenses but from what I understand you can package an app with the Railo runtime and not have to release the code of your app as OS. The GPL license for Open BD was a deal breaker for us. Having a cf runtime rolled into a major java app server like JBoss is awesome. Railo's cf offering is very impressive. The thought of getting the JBoss developer community getting behind a cf runtime makes me giddy. God I love CF. There is no better time to be a CF developer. Indeed G$ On Thu, Jun 5, 2008 at 2:09 PM, Peter Boughton [EMAIL PROTECTED] wrote: Railo announced today that they are joining JBoss.org and going Open Source. The license will be LGPL2. More information is available on jboss.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:306939 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
cfwindow refreshOnShow
Hi gang, I'm creating a cfwindow through a JS function. I can declare the width, height, whether it's modal or not, etc through the function. However when i try to define refreshOnShow:true The cfwindow doesn't actually refresh. Here's the JS I'm using: function makeWindow(client,campID) { ColdFusion.Window.create( campID,Campaign + campID,onlineMarketing_campDetail.cfm?client= + client + campID= + campID, {refreshOnShow:true,center:true,modal:true,width:500,height:400}); } Anyone know how I can get this to work? Steve Good http://lanctr.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:306940 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfwindow refreshOnShow
Hey Steve, What do you mean by 'refresh'? My understanding is that if you 'close' the window and then 'reopen' it, that is when it would 'refresh'. Also, After you run the function, does the window automatically show up, or do you need to navigate to it first? -- William Seiter ColdFusion Web Developer / Consultant http://william.seiter.com Free Website Trade Publication Website Magazine http://www.websitemagazine.com/referrals/?id=51344f=text2 Don't forget to answer the survey questions, it's a 10 second task , a very small request for access to this incredible resource. Have you ever read a book that changed your life? Go to: http://www.winninginthemargins.com Use PassKey: GoldenGrove You'll be glad you did. ::-Original Message- ::From: Steve Good [mailto:[EMAIL PROTECTED] ::Sent: Thursday, June 05, 2008 6:00 PM ::To: CF-Talk ::Subject: cfwindow refreshOnShow :: :: ::Hi gang, :: ::I'm creating a cfwindow through a JS function. I can declare the ::width, height, whether it's modal or not, etc through the function. ::However when i try to define refreshOnShow:true The cfwindow doesn't ::actually refresh. Here's the JS I'm using: :: ::function makeWindow(client,campID) { :: ColdFusion.Window.create( campID,Campaign + ::campID,onlineMarketing_campDetail.cfm?client= + client + campID= ::+ campID, :: {refreshOnShow:true,center:true,modal:true,width:500,height:400}); ::} :: ::Anyone know how I can get this to work? :: ::Steve Good ::http://lanctr.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:306941 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfwindow refreshOnShow
I mean that each time the window is opened the content is loaded fresh rather than using the cached page. One of the attributes of the cfwindow tag is refreshOnShow. It forces the window's content to be loaded fresh each time to window is opened. However, since I am not using the tag directly and instead using cfajaximport and a javascript to create unique windows I can't declare the attribute the same way as with the tag. in my example you can see where I am assigning attributes to the created window. On a whim I tried to create the window with showInit equal to false then using another line of script in my function to show the window. This didn't make any difference. When the window has been opened once the content will never change no matter how many times I open and close the window. I may just turn to javascript to create a random window name. This would be a hack, but it would force CF to see the window as unique each time it was opened. Steve Good http://lanctr.com On Jun 5, 2008, at 10:28 PM, William Seiter wrote: Hey Steve, What do you mean by 'refresh'? My understanding is that if you 'close' the window and then 'reopen' it, that is when it would 'refresh'. Also, After you run the function, does the window automatically show up, or do you need to navigate to it first? -- William Seiter ColdFusion Web Developer / Consultant http://william.seiter.com Free Website Trade Publication Website Magazine http://www.websitemagazine.com/referrals/?id=51344f=text2 Don't forget to answer the survey questions, it's a 10 second task , a very small request for access to this incredible resource. Have you ever read a book that changed your life? Go to: http://www.winninginthemargins.com Use PassKey: GoldenGrove You'll be glad you did. ::-Original Message- ::From: Steve Good [mailto:[EMAIL PROTECTED] ::Sent: Thursday, June 05, 2008 6:00 PM ::To: CF-Talk ::Subject: cfwindow refreshOnShow :: :: ::Hi gang, :: ::I'm creating a cfwindow through a JS function. I can declare the ::width, height, whether it's modal or not, etc through the function. ::However when i try to define refreshOnShow:true The cfwindow doesn't ::actually refresh. Here's the JS I'm using: :: ::function makeWindow(client,campID) { ::ColdFusion.Window.create( campID,Campaign + ::campID,onlineMarketing_campDetail.cfm?client= + client + campID= ::+ campID, ::{refreshOnShow:true,center:true,modal:true,width:500,height:400}); ::} :: ::Anyone know how I can get this to work? :: ::Steve Good ::http://lanctr.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:306942 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfwindow refreshOnShow
On Fri, Jun 6, 2008 at 11:42 AM, Steve Good [EMAIL PROTECTED] wrote: I mean that each time the window is opened the content is loaded fresh rather than using the cached page. One of the attributes of the cfwindow tag is refreshOnShow. It forces the window's content to be loaded fresh each time to window is opened. However, since I am not using the tag directly and instead using cfajaximport and a javascript to create unique windows I can't declare the attribute the same way as with the tag. Support refreshOnShow was added in 8.0.1 I believe... you're running that, right? Prior to that you had to create the window and then immediately (in js) do a ColdFusion.navigate('the same url') to force a refresh. -- Kay Smoljak business: www.cleverstarfish.com coldfusion: kay.smoljak.com personal: enterthegoatlady.com | heapsbad.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:306943 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfhttp resolving base urls to wrong path on redirect
OK, so here's an interesting behavior. I'm not saying it's a bug -- that's fightin' words on this list. :) The cfhttp tag has the resolveurl attribute which will attempt to fully qualify image paths etc in the HTML you are getting. cfhttp also has the redirect attribute that will follow 301 and 302 redirects. Here's the thing though-- Even if ColdFusion follows a redirect, it still uses the original url for the base path to resolve images etc. To show what I mean, create a test file with the following line of code: cflocation url=http://www.adobe.com; Then create a second file with the following code: cfhttp url=HTTP://www.yoursite.com/first_test_file.cfm method=GET resolveurl=true timeout=10/cfhttp cfoutput#cfhttp.filecontent#/cfoutput When you visit the second test file in your browser you will see adobie's site, but most of the images are all broken. View the source and you will see that CF resolved all the images, but instead of resolving them to adobe.com it put your website in there since that was the original URL even though it redirected. What do you guys say? Should it do that? I don't think so, but I haven't thought it all the way through yet. ~Brad ~| 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:306944 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfwindow refreshOnShow
Ahh ok, that's the problem. We haven't upgraded yet. Thanks! Steve Good http://lanctr.com On Jun 5, 2008, at 11:03 PM, Kay Smoljak wrote: On Fri, Jun 6, 2008 at 11:42 AM, Steve Good [EMAIL PROTECTED] wrote: I mean that each time the window is opened the content is loaded fresh rather than using the cached page. One of the attributes of the cfwindow tag is refreshOnShow. It forces the window's content to be loaded fresh each time to window is opened. However, since I am not using the tag directly and instead using cfajaximport and a javascript to create unique windows I can't declare the attribute the same way as with the tag. Support refreshOnShow was added in 8.0.1 I believe... you're running that, right? Prior to that you had to create the window and then immediately (in js) do a ColdFusion.navigate('the same url') to force a refresh. -- Kay Smoljak business: www.cleverstarfish.com coldfusion: kay.smoljak.com personal: enterthegoatlady.com | heapsbad.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:306945 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4