RE: defining variables in a new loop from an old loop
#evaluate('Songs#k#.name')# -- William Seiter ColdFusion Web Developer / Consultant http://william.seiter.com 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: travis mitchell [mailto:[EMAIL PROTECTED] ::Sent: Monday, May 12, 2008 10:56 PM ::To: CF-Talk ::Subject: defining variables in a new loop from an old loop :: ::cfdirectory directory=F:\MP3Music name=Artists sort=name ASC, size ::DESC ::cfset artistList = valueList(Artists.name) ::cfset length=listlen(artistList) ::cfloop index=i from=1 to=#length# :: cfset Artist[i]=Artists.name[i] ::/cfloop ::cfloop index=j from=1 to=#length# :: cfdirectory directory=F:\MP3Music\#Artist[j]# name=Songs#j# ::sort=name ASC ::/cfloop ::cfloop index=k from=1 to=#length# :: cfoutput ::h1#Artists.name[k]#/h1 ::br / ::cfloop query=Songs#k# :: !-- right here I am needing to call a variable sort of like ::#Songs#k#.name#, but I have not found anything to work !-- ::/cfloop :: /cfoutput ::/cfloop :: :: :: ::ANY HELP WOULD BE APPRECIATED!!! you can e-mail me at ::[EMAIL PROTECTED] i will appreciate any help! :: :: ~| 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:305148 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: defining variables in a new loop from an old loop
Eww. There's no need for evaluate(): cfset tempQuery = VARIABLES[Songs k] cfloop query=tempQuery cfoutput#tempQuery.name#/cfoutput /cfloop or of course just use the column name, since we're inside a loop: cfloop query=Songs#k# cfoutput#name#/cfoutput /cfloop On Tue, May 13, 2008 at 3:16 PM, William Seiter wrote: #evaluate('Songs#k#.name')# -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305149 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Latency after COLDFUSION 8 upgrade
On Monday 12 May 2008, Peterson, Chris wrote: Be sure server monitoring / memory profiling / debugging are disabled on the new server ;) I believe the advice is to enable the latter, providing your using the alerts features of course. There isn't much impact. -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305150 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CFLOCK issues in CF8
Hi all, We recently upgraded our test server from CFMX 6.1 to ColdFusion 8, which causes our application much problems. Because of the nature of our application and the way it is build, we use cflockextensively. It seems that ColdFusion 8 has some serious issues with CFLOCK. After the upgrade, we found requests to be blocked for no obvious reason, while the CF monitor always shows that the process is waiting for a lock (cflock is the final element in the stack trace). We are using nested locks, but there are no deadlocks (believe me, I checked). Anyways, the CF documentation says that a deadlock would end when a timeout is reached. I'm now looking at a request that has been blocked for over 3 days (lock timeout = 30 seconds). Here's the stack trace of the request: ** /opt/bea/wls_sp6/user_projects/domains/domaineistc/extend7010/stage/cfusion-ear/cfusion-war/eistc/components/SharedDirectoryListing.cfc cflock at /opt/bea/wls_sp6/user_projects/domains/domaineistc/extend7010/stage/cfusion-ear/cfusion-war/eistc/components/SharedDirectoryListing.cfc getNextItem() : 138 at /opt/bea/wls_sp6/user_projects/domains/domaineistc/extend7010/stage/cfusion-ear/cfusion-war/eistc/components/SharedDirectoryListing.cfc check() : 116 at /opt/bea/wls_sp6/user_projects/domains/domaineistc/extend7010/stage/cfusion-ear/cfusion-war/eistc/tasks/archiving/setExpirydates.cfm cflock : 51 at /opt/bea/wls_sp6/user_projects/domains/domaineistc/extend7010/stage/cfusion-ear/cfusion-war/eistc/tasks/archiving/setExpirydates.cfm : 3 at /opt/bea/wls_sp6/user_projects/domains/domaineistc/extend7010/stage/cfusion-ear/cfusion-war/eistc/tasks/archiving/setExpirydates.cfm ** This is the only active request. No other requests are running. When I start a new request that waits for the same lock, it waits for the lock for 30 seconds and then times out, which leads me to believe that the long running request has obtained the lock. This code worked without any issues on CFMX6, so there has to be something different in the way CF8 handles the locks. Is there anybody out there that had similar issues after upgrading to CF8? Is there a way to see all active locks on an application? The CF monitor does not seem to be able to give me the information I need to solve this issue. Any help would be much appreciated! Thank you, Wim Belgium ~| 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:305151 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFLOCK issues in CF8
Hi all, We recently upgraded our test server from CFMX 6.1 to ColdFusion 8, which causes our application much problems. Because of the nature of our application and the way it is build, we use cflockextensively. It seems that ColdFusion 8 has some serious issues with CFLOCK. After the upgrade, we found requests to be blocked for no obvious reason, while the CF monitor always shows that the process is waiting for a lock (cflock is the final element in the stack trace). We are using nested locks, but there are no deadlocks (believe me, I checked). Anyways, the CF documentation says that a deadlock would end when a timeout is reached. I'm now looking at a request that has been blocked for over 3 days (lock timeout = 30 seconds). Here's the stack trace of the request: ** /opt/bea/wls_sp6/user_projects/domains/domaineistc/extend7010/stage/cfusion-ear/cfusion-war/eistc/components/SharedDirectoryListing.cfc cflock at /opt/bea/wls_sp6/user_projects/domains/domaineistc/extend7010/stage/cfusion-ear/cfusion-war/eistc/components/SharedDirectoryListing.cfc getNextItem() : 138 at /opt/bea/wls_sp6/user_projects/domains/domaineistc/extend7010/stage/cfusion-ear/cfusion-war/eistc/components/SharedDirectoryListing.cfc check() : 116 at /opt/bea/wls_sp6/user_projects/domains/domaineistc/extend7010/stage/cfusion-ear/cfusion-war/eistc/tasks/archiving/setExpirydates.cfm cflock : 51 at /opt/bea/wls_sp6/user_projects/domains/domaineistc/extend7010/stage/cfusion-ear/cfusion-war/eistc/tasks/archiving/setExpirydates.cfm : 3 at /opt/bea/wls_sp6/user_projects/domains/domaineistc/extend7010/stage/cfusion-ear/cfusion-war/eistc/tasks/archiving/setExpirydates.cfm ** This is the only active request. No other requests are running. When I start a new request that waits for the same lock, it waits for the lock for 30 seconds and then times out, which leads me to believe that the long running request has obtained the lock. This code worked without any issues on CFMX6, so there has to be something different in the way CF8 handles the locks. Is there anybody out there that had similar issues after upgrading to CF8? Is there a way to see all active locks on an application? The CF monitor does not seem to be able to give me the information I need to solve this issue. Any help would be much appreciated! Thank you, Wim Belgium ~| 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:305152 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Help! Can't I set a specific time zone for a CF App? [heur SPAMTRAP]
If you know of a bandage that doesn't need changing, please do share. ..:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: William Seiter [mailto:[EMAIL PROTECTED] Sent: Monday, May 12, 2008 10:00 PM To: CF-Talk Subject: RE: Help! Can't I set a specific time zone for a CF App? [heur SPAMTRAP] When applying a bandage over a 'wound' (beware, analogy here), you must be prepared to need change the bandage from time to time -- William Seiter ColdFusion Web Developer / Consultant http://william.seiter.com 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: Paul Hastings [mailto:[EMAIL PROTECTED] ::Sent: Monday, May 12, 2008 4:32 PM ::To: CF-Talk ::Subject: Re: Help! Can't I set a specific time zone for a CF App? [heur ::SPAMTRAP] :: ::Bobby Hartsfield wrote: :: You could store the time offset within an application variable then use ::that :: along with dateadd() within all of your dateformat and tiemformat calls :: throughout the application. :: ::what about DST changes? :: :: :: ~| 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:305153 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF8 / CFXML
Does anyone have an example on creating an xml file based on data being pulled from a query? I have found a few examples (google) but not quite there yet. ~| 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:305154 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF8 / CFXML
The easiest way... cfxml variable=myXML things cfoutput query=myQuery thing#myQuery.myColumn#/thing /cfoutput /things /cfxml There's no real trick to creating the XML. If you're looking for something that turns a query into XML, check cflib.org. Adrian -Original Message- From: CFDEV [mailto:[EMAIL PROTECTED] Sent: 13 May 2008 15:24 To: CF-Talk Subject: CF8 / CFXML Does anyone have an example on creating an xml file based on data being pulled from a query? I have found a few examples (google) but not quite there yet. ~| 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:305155 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: defining variables in a new loop from an old loop
Eww. There's no need for evaluate(): cfset tempQuery = VARIABLES[Songs k] cfloop query=tempQuery cfoutput#tempQuery.name#/cfoutput /cfloop or of course just use the column name, since we're inside a loop: cfloop query=Songs#k# cfoutput#name#/cfoutput /cfloop On Tue, May 13, 2008 at 3:16 PM, William Seiter wrote: #evaluate('Songs#k#.name')# -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ I LOVE YOU ALL!! I'm self taught, and I'm still trying to get the hang of programming. THANKS SO 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:305156 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF, XML, XSLT, XPath and XHTML.
I am attempting to use the CF xml functionality to parse up an xhtml document and I can not seem to get any results. Is there something about this world I am not getting? No matter how I try to reference any xml nodes I just get a blank result. spb.cfm cfsilent cfsetting showdebugoutput=no cfhttp url=http://www.spb.ca.gov/jobs/exams/exam_start.htm; resolveurl=yes/ cfset xmlObj = xmlParse(cfhttp.FileContent) cffile action=read file=#getDirectoryFromPath(getCurrentTemplatePath())#spb.xsl variable=xslt /cfsilent!DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Strict//EN http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd; html xmlns=http://www.w3.org/1999/xhtml; head meta http-equiv=Content-Type content=text/html; charset=utf-8 / titleSPB/title /head body cfoutput#htmlCodeFormat(xmlTransform(xmlObj,xslt))#/cfoutput cfdump var=#xmlSearch(xmlObj,'//option')# hr color=#00 size=10 / cfoutput#htmlCodeFormat(cfhttp.FileContent)#/cfoutput /body /html spb.sxl --- ?xml version=1.0 encoding=utf-8?!-- DWXMLSource=http://www.spb.ca.gov/jobs/exams/exam_start.htm; --!DOCTYPE xsl:stylesheet [ !ENTITY nbsp #160; !ENTITY copy #169; !ENTITY reg#174; !ENTITY trade #8482; !ENTITY mdash #8212; !ENTITY ldquo #8220; !ENTITY rdquo #8221; !ENTITY pound #163; !ENTITY yen#165; !ENTITY euro #8364; ] xsl:stylesheet version=1.0 xmlns:xsl=http://www.w3.org/1999/XSL/Transform; xsl:output method=html encoding=utf-8/ xsl:template match=/ xsl:value-of select=//option / /xsl:template /xsl:stylesheet ~| 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:305157 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Multiple recipients in BCC via Exchange
I agree with your comment about focusing on the application over the protocol. Thanks for setting me straight. We are not using IMF and the message tracking center returns 'The tracking db on is not available or the message has left the Exchange Organization'. -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Monday, May 12, 2008 7:55 PM To: CF-Talk Subject: Re: Multiple recipients in BCC via Exchange Jason Durham wrote: Are you insinuating that I don't know how to use telnet or am otherwise incapable of managing a mail server? I'm saying that you are focusing too much on the application and not enough on the protocol. SMTP uses neither a comma nor a semi-colon so your whole premises is irrelevant. I'm unable to send mail... not receive it. Does CFMAIL not send a single message regardless as to the number of recipients? Yes it does. In any event, I searched for a way to verify that MS Exchange will accept a comma delimited list. I didn't find anything helpful. So... I called a colleague who managed 200+ Exchange servers for a large brokerage firm. He said I was SOL. I am glad your colleague doesn't manage my Exchange server. This is from a packet sniffer trace of a mail send from CF to Exchange with 1 address in the To and 2 addresses in the BCC: mgxswitch smtp [SYN] Seq=0 Win=16384 Len=0 MSS=1360 WS=0 smtp mgxswitch [SYN, ACK] Seq=0 Ack=1 Win=16384 Len=0 MSS=1460 WS=0 mgxswitch smtp [ACK] Seq=1 Ack=1 Win=17680 Len=0 Response: 220 prexchange.domain Microsoft ESMTP MAIL Service, Version: Command: EHLO PRLT004 Response: 250-prexchange.domain Hello [192.168.0.116] Command: MAIL FROM:[EMAIL PROTECTED] Response: 250 2.1.0 [EMAIL PROTECTED] OK Command: RCPT TO:[EMAIL PROTECTED] Response: 250 2.1.5 [EMAIL PROTECTED] Command: RCPT TO:[EMAIL PROTECTED] Response: 250 2.1.5 [EMAIL PROTECTED] Command: RCPT TO:[EMAIL PROTECTED] Response: 250 2.1.5 [EMAIL PROTECTED] Command: DATA Response: 354 Start mail input; end with CRLF.CRLF DATA fragment, 338 bytes Response: 250 2.6.0 [EMAIL PROTECTED] Queued mail for delivery mgxswitch smtp [ACK] Seq=491 Ack=730 Win=16951 Len=0 Like I wrote before: look in the UCE folder and if it is there change the IMF SCL threshold and if not use the message tracking service. 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:305159 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, XML, XSLT, XPath and XHTML.
Hi Ian, This line creates a default namespace for the xml which may be your problem: html xmlns=http://www.w3.org/1999/xhtml; To match any node in an xml document with a default namespace, you will need to add the default namespace to your xpath which is just a colon: xsl:value-of select=//:option / HTH 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:305160 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF, XML, XSLT, XPath and XHTML.
I found some Python discussions on XPath and XHTML that indicated I need another name space in my xslt. xsl:stylesheet version=1.0 xmlns:xsl=http://www.w3.org/1999/XSL/Transform; xmlns:xhtml=http://www.w3.org/1999/xhtml; xsl:output method=html encoding=utf-8/ xsl:template match=/ xsl:for-each select=//xhtml:option xsl:value-of select=. / /xsl:for-each /xsl:template /xsl:stylesheet This seems to be working. Is there any advice for me on this concept? How would I use this second name space in a ColdFusion xmlSearch() function? ~| 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:305161 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Query using COALESCE issue
Having a slight problem with a query using COALESCE Theres an integer column to rank the attorneys in order. Usually only a few a ranked - the others have a null in the rank column. The ranked attorneys need to appear first in the results. Some attorneys are in the table more than once, so thusly the use of distinct, which is causing the problem. If I remove it, the query works, but Bob Smith is going to show up four times... SELECT distinct(atty_id), first_name, last_name, atty_rank FROM get_attypa WHERE isACTIVE = 'y' ORDER BY COALESCE(atty_rank, ) asc, last_name, first_name ASC But - I'm getting the error below: ORDER BY items must appear in the select list if SELECT DISTINCT is specified. Suggestions? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305162 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF, XML, XSLT, XPath and XHTML.
Dominic Watson wrote: Hi Ian, This line creates a default namespace for the xml which may be your problem: html xmlns=http://www.w3.org/1999/xhtml; Yes, I did discover that this was a name space issue. To match any node in an xml document with a default namespace, you will need to add the default namespace to your xpath which is just a colon: xsl:value-of select=//:option / HTH I tried this solution and I get this error: javax.xml.transform.TransformerConfigurationException: javax.xml.transform.TransformerException: javax.xml.transform.TransformerException: Prefix must resolve to a namespace: But adding a another name space parameter to my xsl seems to work well. xsl:stylesheet version=1.0 xmlns:xsl=http://www.w3.org/1999/XSL/Transform; xmlns:xhtml=http://www.w3.org/1999/xhtml; xsl:for-each select=//xhtml:option As I asked in my other post. How does one make use of multiple name spaces like this in the ColdFusion xml functions such as xmlSearch? ~| 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:305163 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
easy one! : comma separated list from cfoutput
ok. i am having a serious brain fart... i know there is a beter way to ooutput a list the is comma seperated then this.. cfloop query=getProd cfset columns = columns#specs_partnum#, /cfloop !--- remove the last comma --- cfset columns = left(columns,evaluate(len(columns) -1)) cfoutput#columns#/cfoutput but again, i am drawing a complete blank... any help would be 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:305164 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Latency after COLDFUSION 8 upgrade
We are using DB drivers native to CF; Also to be sure that there is no impact, we have turned off debugging completely. No luck yet :( On Monday 12 May 2008, Peterson, Chris wrote: Be sure server monitoring / memory profiling / debugging are disabled on the new server ;) I believe the advice is to enable the latter, providing your using the alerts features of course. There isn't much impact. -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305158 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: easy one! : comma separated list from cfoutput
cfoutput#valueList(getProd.specs_partnum)#/cfoutput -Joe On Tue, May 13, 2008 at 11:26 AM, morchella [EMAIL PROTECTED] wrote: ok. i am having a serious brain fart... i know there is a beter way to ooutput a list the is comma seperated then this.. cfloop query=getProd cfset columns = columns#specs_partnum#, /cfloop !--- remove the last comma --- cfset columns = left(columns,evaluate(len(columns) -1)) cfoutput#columns#/cfoutput but again, i am drawing a complete blank... any help would be 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:305165 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: easy one! : comma separated list from cfoutput
ValueList(getProd.specs_partnum, ,) G On Tue, May 13, 2008 at 11:26 AM, morchella [EMAIL PROTECTED] wrote: ok. i am having a serious brain fart... i know there is a beter way to ooutput a list the is comma seperated then this.. cfloop query=getProd cfset columns = columns#specs_partnum#, /cfloop !--- remove the last comma --- cfset columns = left(columns,evaluate(len(columns) -1)) cfoutput#columns#/cfoutput but again, i am drawing a complete blank... any help would be 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:305166 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: easy one! : comma separated list from cfoutput
morchella wrote: ok. i am having a serious brain fart... i know there is a beter way to ooutput a list the is comma seperated then this.. cfloop query=getProd cfset columns = columns#specs_partnum#, /cfloop !--- remove the last comma --- cfset columns = left(columns,evaluate(len(columns) -1)) cfoutput#columns#/cfoutput but again, i am drawing a complete blank... any help would be appreciated thanks! valueList(getProd,'specs_partnum') OR quotedValueList(getProd,'specs_partnum') ~| 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:305167 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: easy one! : comma separated list from cfoutput
awsome... thank you! now.. =] how would i remove doubles? !--- List of Accessory's that are assigned to this product --- cfquery name=getAccessory datasource=listit SELECT DISTINCT ascList FROM dbo.list WHERE (specs_partnum IN (#columns#)) AND (ascList IS NOT NULL) /cfquery gives me... ascList 132 135 135,132 so my list looks like aclist: 132,135,135,132 just want 132,135 thanks again! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305168 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Query using COALESCE issue
Les, Assuming you are using MS SQL Server, try this: SELECT DISTINCT atty_id, first_name, last_name, COALESCE(atty_rank, ) as atty_rank FROM get_attypa WHERE isACTIVE = 'y' ORDER BY atty_rank, last_name, first_name HTH, Carl Les Mizzell wrote: Having a slight problem with a query using COALESCE Theres an integer column to rank the attorneys in order. Usually only a few a ranked - the others have a null in the rank column. The ranked attorneys need to appear first in the results. Some attorneys are in the table more than once, so thusly the use of distinct, which is causing the problem. If I remove it, the query works, but Bob Smith is going to show up four times... SELECT distinct(atty_id), first_name, last_name, atty_rank FROM get_attypa WHERE isACTIVE = 'y' ORDER BY COALESCE(atty_rank, ) asc, last_name, first_name ASC But - I'm getting the error below: ORDER BY items must appear in the select list if SELECT DISTINCT is specified. Suggestions? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305169 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: easy one! : comma separated list from cfoutput
also why is it not listed in my wack books under functions? also where did functions go in the 8 series of wack books.. i know its there in 4.5-7... On Tue, May 13, 2008 at 11:46 AM, morchella [EMAIL PROTECTED] wrote: awsome... thank you! now.. =] how would i remove doubles? !--- List of Accessory's that are assigned to this product --- cfquery name=getAccessory datasource=listit SELECT DISTINCT ascList FROM dbo.list WHERE (specs_partnum IN (#columns#)) AND (ascList IS NOT NULL) /cfquery gives me... ascList 132 135 135,132 so my list looks like aclist: 132,135,135,132 just want 132,135 thanks again! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305170 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Latency after COLDFUSION 8 upgrade
On Tuesday 13 May 2008, sud luthra wrote: We are using DB drivers native to CF; Also to be sure that there is no impact, we have turned off debugging completely. No luck yet :( I believe the advice is to enable the latter, providing your using the alerts features of course. There isn't much impact. I mis-typed, oops. Turn debugging off on production servers. You can enable the left most of the three monitor options in the server monitor without issue. -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305171 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: easy one! : comma separated list from cfoutput
If you're doing a distinct in your query, or a group by, then you shouldn't have any dupes. -Original Message- From: morchella [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 13, 2008 10:47 AM To: CF-Talk Subject: Re: easy one! : comma separated list from cfoutput awsome... thank you! now.. =] how would i remove doubles? !--- List of Accessory's that are assigned to this product --- cfquery name=getAccessory datasource=listit SELECT DISTINCT ascList FROM dbo.list WHERE (specs_partnum IN (#columns#)) AND (ascList IS NOT NULL) /cfquery gives me... ascList 132 135 135,132 so my list looks like aclist: 132,135,135,132 just want 132,135 thanks again! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305172 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: easy one! : comma separated list from cfoutput
You can do it using a QoQ and Select DISTINCT OR I wrote a couple of functions to do this. One day I will post them to CFLib. /** * Case-sensitive function for removing duplicate entries in a list. * @param list The list to be modified. * @return Returns a list. */ function ListDeleteDuplicates(list) { var i = 1; var delimiter = ','; var returnValue = ''; if(ArrayLen(arguments) GTE 2) delimiter = arguments[2]; list = ListToArray(list, delimiter); for(i = 1; i LTE ArrayLen(list); i = i + 1) if(NOT ListFind(returnValue, list[i], delimiter)) returnValue = ListAppend(returnValue, list[i], delimiter); return returnValue; } /** * Case-INsensitive function for removing duplicate entries in a list. * @param list List to be modified. * @return Returns a list. */ function ListDeleteDuplicatesNoCase(list) { var i = 1; var delimiter = ','; var returnValue = ''; if(ArrayLen(arguments) GTE 2) delimiter = arguments[2]; list = ListToArray(list, delimiter); for(i = 1; i LTE ArrayLen(list); i = i + 1) if(NOT ListFindNoCase(returnValue, list[i], delimiter)) returnValue = ListAppend(returnValue, list[i], delimiter); return returnValue; } On Tue, May 13, 2008 at 11:46 AM, morchella [EMAIL PROTECTED] wrote: awsome... thank you! now.. =] how would i remove doubles? !--- List of Accessory's that are assigned to this product --- cfquery name=getAccessory datasource=listit SELECT DISTINCT ascList FROM dbo.list WHERE (specs_partnum IN (#columns#)) AND (ascList IS NOT NULL) /cfquery gives me... ascList 132 135 135,132 so my list looks like aclist: 132,135,135,132 just want 132,135 thanks again! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305173 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: easy one! : comma separated list from cfoutput
Wait... I cant remember if I wrote those or not. I have a library of list functions... Some I wrote, some I got offa CFlib. Don;t want to take credit for someone else's work. G On Tue, May 13, 2008 at 12:04 PM, Gerald Guido [EMAIL PROTECTED] wrote: You can do it using a QoQ and Select DISTINCT OR I wrote a couple of functions to do this. One day I will post them to CFLib. /** * Case-sensitive function for removing duplicate entries in a list. * @param list The list to be modified. * @return Returns a list. */ function ListDeleteDuplicates(list) { var i = 1; var delimiter = ','; var returnValue = ''; if(ArrayLen(arguments) GTE 2) delimiter = arguments[2]; list = ListToArray(list, delimiter); for(i = 1; i LTE ArrayLen(list); i = i + 1) if(NOT ListFind(returnValue, list[i], delimiter)) returnValue = ListAppend(returnValue, list[i], delimiter); return returnValue; } /** * Case-INsensitive function for removing duplicate entries in a list. * @param list List to be modified. * @return Returns a list. */ function ListDeleteDuplicatesNoCase(list) { var i = 1; var delimiter = ','; var returnValue = ''; if(ArrayLen(arguments) GTE 2) delimiter = arguments[2]; list = ListToArray(list, delimiter); for(i = 1; i LTE ArrayLen(list); i = i + 1) if(NOT ListFindNoCase(returnValue, list[i], delimiter)) returnValue = ListAppend(returnValue, list[i], delimiter); return returnValue; } On Tue, May 13, 2008 at 11:46 AM, morchella [EMAIL PROTECTED] wrote: awsome... thank you! now.. =] how would i remove doubles? !--- List of Accessory's that are assigned to this product --- cfquery name=getAccessory datasource=listit SELECT DISTINCT ascList FROM dbo.list WHERE (specs_partnum IN (#columns#)) AND (ascList IS NOT NULL) /cfquery gives me... ascList 132 135 135,132 so my list looks like aclist: 132,135,135,132 just want 132,135 thanks again! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305174 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: easy one! : comma separated list from cfoutput
right but my result of the query could be 134 135 135, 134 134, 135, 2 so the result is distinct. so when it puts them into a list i get 134, 135, 135, 134, 134, 135, 2 i am going to to try to look at list to array? and then back to list? On Tue, May 13, 2008 at 11:57 AM, Andy Matthews [EMAIL PROTECTED] wrote: If you're doing a distinct in your query, or a group by, then you shouldn't have any dupes. -Original Message- From: morchella [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 13, 2008 10:47 AM To: CF-Talk Subject: Re: easy one! : comma separated list from cfoutput awsome... thank you! now.. =] how would i remove doubles? !--- List of Accessory's that are assigned to this product --- cfquery name=getAccessory datasource=listit SELECT DISTINCT ascList FROM dbo.list WHERE (specs_partnum IN (#columns#)) AND (ascList IS NOT NULL) /cfquery gives me... ascList 132 135 135,132 so my list looks like aclist: 132,135,135,132 just want 132,135 thanks again! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305175 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, XML, XSLT, XPath and XHTML.
I'm not sure if this will work for you, but it may help: http://www.talkingtree.com/blog/index.cfm/2005/11/18/XmlSearchNoNameName space Read through the comments for the xmlSearch wildcards. You may be able to skip over the namespaces with the wildcards. m!ke -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 13, 2008 10:17 AM To: CF-Talk Subject: Re: CF, XML, XSLT, XPath and XHTML. Dominic Watson wrote: Hi Ian, This line creates a default namespace for the xml which may be your problem: html xmlns=http://www.w3.org/1999/xhtml; Yes, I did discover that this was a name space issue. To match any node in an xml document with a default namespace, you will need to add the default namespace to your xpath which is just a colon: xsl:value-of select=//:option / HTH I tried this solution and I get this error: javax.xml.transform.TransformerConfigurationException: javax.xml.transform.TransformerException: javax.xml.transform.TransformerException: Prefix must resolve to a namespace: But adding a another name space parameter to my xsl seems to work well. xsl:stylesheet version=1.0 xmlns:xsl=http://www.w3.org/1999/XSL/Transform; xmlns:xhtml=http://www.w3.org/1999/xhtml; . xsl:for-each select=//xhtml:option As I asked in my other post. How does one make use of multiple name spaces like this in the ColdFusion xml functions such as xmlSearch? ~| 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:305176 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: easy one! : comma separated list from cfoutput
Try this: http://www.bennadel.com/blog/432-Using-ColdFusion-Structures-To-Remove-D uplicate-List-Values.htm m!ke -Original Message- From: morchella [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 13, 2008 11:08 AM To: CF-Talk Subject: Re: easy one! : comma separated list from cfoutput right but my result of the query could be 134 135 135, 134 134, 135, 2 so the result is distinct. so when it puts them into a list i get 134, 135, 135, 134, 134, 135, 2 i am going to to try to look at list to array? and then back to list? ~| 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:305177 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Latency after COLDFUSION 8 upgrade
Yes, debugging is completely off. thanks On Tuesday 13 May 2008, sud luthra wrote: We are using DB drivers native to CF; Also to be sure that there is no impact, we have turned off debugging completely. No luck yet :( I believe the advice is to enable the latter, providing your using the alerts features of course. There isn't much impact. I mis-typed, oops. Turn debugging off on production servers. You can enable the left most of the three monitor options in the server monitor without issue. -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305178 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFLOCK issues in CF8
Is it possible for you to take the thread dump and post it here? ~| 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:305179 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFLOCK issues in CF8
Because of the nature of our application and the way it is build, we use cflockextensively. Why, exactly? In my experience, many applications overuse locks for various reasons, such as requirements imposed by CF5 and earlier versions. There shouldn't be that many things you need to lock from within CF (as opposed to your database, which will be where most of your concurrency issues occur and which you should solve by using whatever concurrency control your database provides). We are using nested locks, but there are no deadlocks ... I've seen various problems with nested locks before. I strongly recommend that you replace them with a named lock scheme, or remove them entirely if you can. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305180 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: easy one! : comma separated list from cfoutput
Order by ascList... that should get DISTINCT to work. cfquery name=getAccessory datasource=listit SELECT DISTINCT ascList FROM dbo.list WHERE (specs_partnum IN (#columns#)) AND (ascList IS NOT NULL) ORDER BY ascList /cfquery Robert B. Harrison Director of Interactive services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be . ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305181 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: easy one! : comma separated list from cfoutput
ORDER BY ascList that still gives me ascList 132 135 135,132 On Tue, May 13, 2008 at 12:37 PM, Robert Harrison [EMAIL PROTECTED] wrote: Order by ascList... that should get DISTINCT to work. cfquery name=getAccessory datasource=listit SELECT DISTINCT ascList FROM dbo.list WHERE (specs_partnum IN (#columns#)) AND (ascList IS NOT NULL) ORDER BY ascList /cfquery Robert B. Harrison Director of Interactive services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be . ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305182 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Help! Can't I set a specific time zone for a CF App? [heur SPAMTRAP]
Thanks to all for the replies. It really shockes me that a simple mechanism to change the timezone of a particular app was never added to CF. I'm sure this has been a problem for many over the years. Dave pointed me to a simple UDF that did the trick. Thanks Dave! Regarding the question about remembering to change the offset when we go back to standard time, I don't think this that is an issue, is it? As long as timeZoneInfo.UTCtotalOffset increments to reflect the new offset, I can just use Application.TimeZone = -(timeZoneInfo.utcHourOffset+1) right? Again, thanks all for your replies. Bob If you know of a bandage that doesn't need changing, please do share. .:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com SPAMTRAP] When applying a bandage over a 'wound' (beware, analogy here), you must be prepared to need change the bandage from time to time -- William Seiter ColdFusion Web Developer / Consultant http://william.seiter.com 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- :: ::Sent: Monday, May 12, 2008 4:32 PM ::To: CF-Talk ::Subject: Re: Help! Can't I set a specific time zone for a CF App? [heur ::SPAMTRAP] :: ::Bobby Hartsfield wrote: :: You could store the time offset within an application variable then use ::that :: along with dateadd() within all of your dateformat and tiemformat calls :: throughout the application. :: ::what about DST changes? :: :: :: ~| 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:305183 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: easy one! : comma separated list from cfoutput
ian, that is exactly what i am doing. but i am storing a list inside a column to refer to user created groupings of items. ~| 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:305187 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, XML, XSLT, XPath and XHTML.
aXPathSearchResults = oXml.Search('//xHtml: Should be: aXPathSearchResults = oXml.Search('//xHtml:option'); -- 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:305186 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Issues consuming a .Net webservice.
Here is a snippet from the wsdl file for the method I am calling. That's not the snippet that matters. This snippet defines an element. It doesn't define the operation. Can you post the entire WSDL? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ Thanks Dave, Here is a link to the wsdl file: http://www.dynanetsystems.com:8080/educatesiteproxy/educatesiteproxyTest.asmx?wsdl Josh ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305188 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: easy one! : comma separated list from cfoutput
In that case you would probably either have to move the values to a look up table (normalize) or uses a function to tease out the dupes. G On Tue, May 13, 2008 at 1:11 PM, Paul Ihrig [EMAIL PROTECTED] wrote: ian, that is exactly what i am doing. but i am storing a list inside a column to refer to user created groupings of items. ~| 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:305189 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: load balancing / failover
Basically I'd like to have two IIS servers each using a separate CF instance, and have a software load balancer distribute the requests to each (maintaining sticky sessions), and if one instance stops responding (due to failure or high load), force requests onto the available instance. NLB + JRun/JBoss cluster. Last time I checked, NLB didn't provide any failover either, unless the actual system is down (or the nic is not responding). Why not use a real loadbalancer - either hardware or software like LVS? Russ ~| 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:305190 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: easy one! : comma separated list from cfoutput
If that's what you're doing then why not have a user_groupings relational table that holds the user_id and group_id? On Tue, May 13, 2008 at 12:11 PM, Paul Ihrig [EMAIL PROTECTED] wrote: ian, that is exactly what i am doing. but i am storing a list inside a column to refer to user created groupings of items. ~| 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:305191 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: easy one! : comma separated list from cfoutput
Paul Ihrig wrote: ian, that is exactly what i am doing. but i am storing a list inside a column to refer to user created groupings of items. Ok, this would be fairly easy to normalize with a join table. user_grouping -- userID groupID Then you would have records something like iskinner 135 jblow132 pIhrig135 pIhrig132 Your query would then work exactly as you want it to. Without the modification to your database you are not going to be able to get these results. You are going to have to finish the processing in your CFML. One of the easiest ways would be to convert the valueList() resutls to a structure which would consolidate all duplicates then retrieve the list again with structKeyList(). But if you have a choice, normalizing your database is much more flexible and scalable. ~| 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:305192 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: easy one! : comma separated list from cfoutput
Paul Ihrig wrote: ORDER BY ascList that still gives me ascList 132 135 135,132 It looks to me like you have a de-normalized database scheme there that stores a list of values in a column. If that case then that is the result you are going to get. '132', '135' and '135,132' are three distinct and separate values. If this is the case then you are not going to get a SQL solution. You will need to do something in ColdFusion after the fact. Or better yet, if you can, normalize your database so that you are not storing lists of values in a column. ~| 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:305184 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, XML, XSLT, XPath and XHTML.
How would I use this second name space in a ColdFusion xmlSearch() function? This is a tricky one. For xslt, what you are doing there is mapping any namespaces in the target xml with a prefix. From then on, using the prefix in your xslt will work great. For XmlSearch however, there is no ColdFusion tool for mapping namespaces to prefixes so you can only use the ':' default namespace prefix. If you have more than one default namespace in your xml, you are left without a paddle (using ':' won't work). Enter betterXml. I have made a couple of components to utilize xpath better in coldfusion (mainly for maintaining xml files but useful in other situations). The xmlReader component has a MapNamespace method that does what it says on the tin. You could do: oXml = createObject('component', 'betterXml.betterXmlReader').init(xmlFile); oXml.MapNamespace('http://www.w3.org/1999/xhtml', 'xHtml'); aXPathSearchResults = oXml.Search('//xHtml: Check out my blogpost on this: http://fusion.dominicwatson.co.uk/2008/03/xmlsearch-and-default-namespaces.html The project is on riaforge: http://betterxml.riaforge.org HTH 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:305185 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Latency after COLDFUSION 8 upgrade
OK. That makes it more interesting Next step is too look at the operating system and permissions. Are you on Linux or Windows? If Linux, what distro and is it a supported distro for CF8 (I've run into problems on SUSE, for example, that didn't occur in RHEL)? For Linux servers you should also 'chown' the cfusion logs directory to ensure there aren't any permission conflicts when attempting write, rotate, or append the log files. HTH, Jon On May 13, 2008, at 10:57 AM, sud luthra wrote: We are using DB drivers native to CF; Also to be sure that there is no impact, we have turned off debugging completely. No luck yet :( ~| 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:305193 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: easy one! : comma separated list from cfoutput
lets try this productTable pId, acList 1.3,5,7 2.2,3 accessoryTable aID, Products 2.1,2,3 3.3,4 5.2 7.12,15, et.. the user basically selects aa aid from the accessories table in the form of a check box. and ascociates as many id's containg producta [which are accesories] to what ever real product he wants.. this really does seem to work quite well. all my code seems fine now. thanks to that valueList thing... i was just trying to clean up the result sets... WHERE aId IN (#accList#) works... accList: cfoutput#ListSort(accList, Numeric)#/cfoutputbr / shows accList: 132,132,135,135,136,136,136,136 i was just trying to look through all the stabndard functions out there to remove duplicates. listToArray throws me a error converting simple something to something... ~| 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:305194 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Sandbox Security Issues since 8.01 patch
I noticed the CF Server list wasn't really linked on the site anymore, so I'm posting this here. I ran the 8.01 patch to our CF 8 install (a fresh install and a hotfix 3 install) and we are suddenly getting odd sandbox security issues. First, CF is being denied access to the CustomTags/ directory unless I explicitly add it to the files/dir tab under the webroot sandbox. This was never the case pre 8.01 patch, and I see nothing in the patch notes referring to it. The second issue is permission denied read/write to our file server on file uploads. If I add the ALL FILES wildcard everything works great, but if I just add the file server share paths I continue to get permission denied. Anyone else see anything like this? I wonder why pre 8.01 patch I've never had to add the file servers to the sandbox for uploads to work right. scary stuff? ~| 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:305195 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: spry and cf
Find any solutions Chad? I too have not had luck using cfsprydataset with JSON data. I'm binding to the CFC via the URL rather than directly to the CFC. What is up with this? If I use cfsprydataset to get the json data, the data starts off with ] {COLUMNS:[DEPT, etc. If I use javascript to get the data ie. var mydata = new Spry.Data. JSONDataSet The page works and the json data starts with ROWCOUNT. {ROWCOUNT:3,COLUMNS:[DEPT, etc. Why no ROWCOUNT when using cfsprydataset? cfsprydataset name=mydata2 type=json bind=cfc:jobNotes. getSteps() -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 09, 2008 2:56 PM To: CF-Talk Subject: spry and cf I am about to pull my hair out. What am I doing wrong? The page returns with no errors and the table is empty of data. All I have on the page is the table headers and no table rows after it. Firebug says I am returning data: {COLUMNS:[JOBNUM,EMPLOYEENUM],DATA:[[1049,3010],[1049,3160], [1049,3170],[1049,3170],[1049,3170 ],[1049,3170],[1049,3170],[1049,3170],[1049,3170],[1049,3170],[1049, 3170],[1049,3170],[1049,3170],[1049 , 3170],[1049,3170],[1049,3170],[1049,3170],[1049,3170],[1049,3170], [1049,3170],[1049,3170]]} script type=text/javascript src=SpryAssets/xpath.js/script script type=text/javascript src=SpryAssets/SpryData.js/script script type=text/javascript src=SpryAssets/SpryJSONDataSet. js/script cfsprydataset name=mydata2 type=json bind=cfc:jobNotes. getSteps() div spry:region=mydata2 table width=100% border=1 tr thJob Num/th thEmployee Num/th /tr tr spry:repeat=mydata2 td{mydata2::JOBNUM}/td td{mydata2::EMPLOYEENUM}/td /tr /table /div ~| 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:305196 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: easy one! : comma separated list from cfoutput
Paul Ihrig wrote: lets try this productTable pId, acList 1.3,5,7 2.2,3 accessoryTable aID, Products 2.1,2,3 3.3,4 5.2 7.12,15, et.. the user basically selects aa aid from the accessories table in the form of a check box. and ascociates as many id's containg producta [which are accesories] to what ever real product he wants.. Normalized Database Design Best Pratice ProductTable-Accessory Join Product ID AccessoryID 1 3 1 5 1 7 2 2 2 3 AccessoryTable_Product Join 2 1 2 2 2 3 3 3 3 4 5 2 7 12 7 15 Are these some type of recipical thing? Are are these two different relationships? this really does seem to work quite well. For now. But if you have to maintain and enhance this application it will bite you in the behind someday. There is a very good reason that 50 years of database design has been working this way and I don't see it changing any time soon. i was just trying to look through all the stabndard functions out there to remove duplicates. listToArray throws me a error converting simple something to something... Don't for an array it is not going to get you the consilidation you want. Just create a structure, loop over the valueList() result creating a node for each value then extrat the list. Structures can not have key duplicates they will get consilidated into one key. cfset something = structNew() cfloop list=#valueList(aQuery.aColumn)# index=value cfset something[value] = true /cfloop cfoutput#structKeyList(something)#/cfoutput ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305197 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Help! Can't I set a specific time zone for a CF App? [heur SPAMTRAP]
If you are getting the offset from the gettimezoneinfo(), that is the servers offset, not the remote locations offset. ..:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Bob Wright [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 13, 2008 12:53 PM To: CF-Talk Subject: Re: Help! Can't I set a specific time zone for a CF App? [heur SPAMTRAP] Thanks to all for the replies. It really shockes me that a simple mechanism to change the timezone of a particular app was never added to CF. I'm sure this has been a problem for many over the years. Dave pointed me to a simple UDF that did the trick. Thanks Dave! Regarding the question about remembering to change the offset when we go back to standard time, I don't think this that is an issue, is it? As long as timeZoneInfo.UTCtotalOffset increments to reflect the new offset, I can just use Application.TimeZone = -(timeZoneInfo.utcHourOffset+1) right? Again, thanks all for your replies. Bob If you know of a bandage that doesn't need changing, please do share. .:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com SPAMTRAP] When applying a bandage over a 'wound' (beware, analogy here), you must be prepared to need change the bandage from time to time -- William Seiter ColdFusion Web Developer / Consultant http://william.seiter.com 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- :: ::Sent: Monday, May 12, 2008 4:32 PM ::To: CF-Talk ::Subject: Re: Help! Can't I set a specific time zone for a CF App? [heur ::SPAMTRAP] :: ::Bobby Hartsfield wrote: :: You could store the time offset within an application variable then use ::that :: along with dateadd() within all of your dateformat and tiemformat calls :: throughout the application. :: ::what about DST changes? :: :: :: ~| 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:305198 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: easy one! : comma separated list from cfoutput
Ian, Thank You! http://63.144.103.199/products/index.cfm?n1ID=5n2ID=46n3ID=148 cant really even to attempt to explain the db structure... never worked with arrays or structures. i do appreciate it.. On Tue, May 13, 2008 at 2:12 PM, Ian Skinner [EMAIL PROTECTED] wrote: Paul Ihrig wrote: lets try this productTable pId, acList 1.3,5,7 2.2,3 accessoryTable aID, Products 2.1,2,3 3.3,4 5.2 7.12,15, et.. the user basically selects aa aid from the accessories table in the form of a check box. and ascociates as many id's containg producta [which are accesories] to what ever real product he wants.. Normalized Database Design Best Pratice ProductTable-Accessory Join Product ID AccessoryID 1 3 1 5 1 7 2 2 2 3 AccessoryTable_Product Join 2 1 2 2 2 3 3 3 3 4 5 2 7 12 7 15 Are these some type of recipical thing? Are are these two different relationships? this really does seem to work quite well. For now. But if you have to maintain and enhance this application it will bite you in the behind someday. There is a very good reason that 50 years of database design has been working this way and I don't see it changing any time soon. i was just trying to look through all the stabndard functions out there to remove duplicates. listToArray throws me a error converting simple something to something... Don't for an array it is not going to get you the consilidation you want. Just create a structure, loop over the valueList() result creating a node for each value then extrat the list. Structures can not have key duplicates they will get consilidated into one key. cfset something = structNew() cfloop list=#valueList(aQuery.aColumn)# index=value cfset something[value] = true /cfloop cfoutput#structKeyList(something)#/cfoutput ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305199 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Issues consuming a .Net webservice.
Here is a link to the wsdl file: http://www.dynanetsystems.com:8080/educatesiteproxy/educatesit eproxyTest.asmx?wsdl Are you able to call the service from a .NET client? Is there a test client that you've been provided with? There doesn't appear to be anything wrong with the code you have. If you use a recording proxy, does the request you're making look like the one shown here? http://www.dynanetsystems.com:8080/educatesiteproxy/educatesiteproxyTest.asm x?op=GetLogFileContent Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305200 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: spry and cf
I had the same result. I was working w/ Todd back at cfobjective and for the life of me, I couldn't get it to work. When I switched to _not_ using cfsprydataset, it worked like a charm. I'm thinking it's a bug. On Tue, May 13, 2008 at 12:57 PM, Leon Chalnick [EMAIL PROTECTED] wrote: Find any solutions Chad? I too have not had luck using cfsprydataset with JSON data. I'm binding to the CFC via the URL rather than directly to the CFC. What is up with this? If I use cfsprydataset to get the json data, the data starts off with ] {COLUMNS:[DEPT, etc. -- === Raymond Camden, VP of Software Dev, Broadchoice Email : [EMAIL PROTECTED] Blog : www.coldfusionjedi.com AOL IM : cfjedimaster Keep up to date with the community: http://www.coldfusionbloggers.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:305202 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Help! Can't I set a specific time zone for a CF App? [heur SPAMTRAP]
Right: east coast server's offset of 4+1 = 5, the offset for the mid-west client. Well, actually it's -5, but you get the point. :) If you are getting the offset from the gettimezoneinfo(), that is the servers offset, not the remote locations offset. .:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com SPAMTRAP] Thanks to all for the replies. It really shockes me that a simple mechanism to change the timezone of a particular app was never added to CF. I'm sure this has been a problem for many over the years. Dave pointed me to a simple UDF that did the trick. Thanks Dave! Regarding the question about remembering to change the offset when we go back to standard time, I don't think this that is an issue, is it? As long as timeZoneInfo.UTCtotalOffset increments to reflect the new offset, I can just use Application.TimeZone = -(timeZoneInfo.utcHourOffset+1) right? Again, thanks all for your replies. Bob ~| 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:305201 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Latency after COLDFUSION 8 upgrade
Jon, We are running on Windows 2003 Standard Edition SP2. thanks OK. That makes it more interesting Next step is too look at the operating system and permissions. Are you on Linux or Windows? If Linux, what distro and is it a supported distro for CF8 (I've run into problems on SUSE, for example, that didn't occur in RHEL)? For Linux servers you should also 'chown' the cfusion logs directory to ensure there aren't any permission conflicts when attempting write, rotate, or append the log files. HTH, Jon On May 13, 2008, at 10:57 AM, sud luthra wrote: We are using DB drivers native to CF; Also to be sure that there is no impact, we have turned off debugging completely. No luck yet :( ~| 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:305203 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
.Net integration services on Linux install question
One of our team is trying to get the .NET Integration Services working on our production server which is running Red Hat Linux. They can't seem to get it to work. It always throws this error: The assembly that contains the class must be provided to the assembly attribute. Is there anyone that you know that has successfully integrated .NET with CF on a Linux machine? Rick Mason ~| 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:305204 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Issues consuming a .Net webservice.
Joshua, I just used Dreamweaver to create a proxy to your web service. It built the CFINVOKE tag as I pasted below. Then I noticed that the proxy didn't create a return variable. I cannot explain how this works, but if you set the values as I have in this example (they equal themselves with no pound signs) you will be able to access your web service. cfinvoke webservice=http://www.dynanetsystems.com:8080/educatesiteproxy/educates iteproxyTest.asmx?wsdl method=getLogFileContent cfinvokeargument name=fileName value=/ cfinvokeargument name=getLogFileContentResult value=getLogFileContentResult/ cfinvokeargument name=text value=text/ /cfinvoke cfdump var=#getLogFileContentResult# cfdump var=#getLogFileContentResult.getReturnCode()# cfdump var=#getLogFileContentResult.ReturnCode.Value# Brian -Original Message- From: Joshua Spangler [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 13, 2008 10:12 AM To: CF-Talk Subject: Re: Issues consuming a .Net webservice. Here is a snippet from the wsdl file for the method I am calling. That's not the snippet that matters. This snippet defines an element. It doesn't define the operation. Can you post the entire WSDL? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ Thanks Dave, Here is a link to the wsdl file: http://www.dynanetsystems.com:8080/educatesiteproxy/educatesiteproxyTest ..asmx?wsdl Josh ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305205 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Issues consuming a .Net webservice.
Here is a link to the wsdl file: http://www.dynanetsystems.com:8080/educatesiteproxy/educatesit eproxyTest.asmx?wsdl Are you able to call the service from a .NET client? Is there a test client that you've been provided with? There doesn't appear to be anything wrong with the code you have. If you use a recording proxy, does the request you're making look like the one shown here? http://www.dynanetsystems.com:8080/educatesiteproxy/educatesiteproxyTest.asm x?op=GetLogFileContent Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ Thanks for your help Dave. I was able to solve my problem from the comments in this thread: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:56353 specifically the link to: http://www.mischefamily.com/nathan/index.cfm/2007/2/8/ColdFusion-and-ASPNET-Web-Service-Interoperability-Part-III Josh ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305206 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Sever-side data validation with ajax
The good news seems that one could validate server-side data using ajax call to send the form data but the down side seems to be the UI err presentation part, when there's data problem one would prompt/alert user about it, the js alert function is one way, write some sort of msg and make it VISIBLE on top of the problematic field is another (I like this approach better, btw, fairly easily done), popup is sometimes deemed annoying (alert is popup). What's your thought? 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:305207 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Spry Eclipse Plugin?
I mentioned this to Mark the other week, he thinks all that needs to be done is to build cfEclipse through 3.4. Give it a try and tell him. Adam Haskell On Sat, May 10, 2008 at 5:54 AM, denstar [EMAIL PROTECTED] wrote: 3.4 hasn't been released yet, but it's getting close. I've been using 3.4M6 ( http://phoenix.eclipse.org/packages/ ), the EE package, and it's wonderful. Some great improvements have been made in many places. I think cfeclipse needs to be installed as a drop in, which is the new way of installing plugins the old way (much cleaner). Holler if you've got any questions. There's a link for equinox somewhere around here (the new plugin update manager). denstar On Fri, May 9, 2008 at 9:01 PM, Gerald Guido [EMAIL PROTECTED] wrote: And Eclipse 3.4 has a WYSIWYG HTML editor, for those pesky table-based layouts. @denstar Could you point me to that wonderful nugget of joy? With that, CF studio will become just another text editor (though awesome). I think the only other thing I use it for is the change tag case feature... G On Fri, May 9, 2008 at 8:18 PM, denstar [EMAIL PROTECTED] wrote: On Fri, Apr 27, 2007 at 8:30 PM, Aaron Roberson [EMAIL PROTECTED] wrote: Really, are we throwing the baby (DW) out with the bathwater (commercial license)? Nope. Eclipse just plain destroys dreamweaver, from a coder's perspective. I'm liking JSDT for Eclipse javascript development. W00t3rZ! And Eclipse 3.4 has a WYSIWYG HTML editor, for those pesky table-based layouts. But, no, there is no question in my mind, Eclipse is where it's at. Even if both were free (as in beer) and open, I'd be using Eclipse. Denny ~| 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:305208 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Sever-side data validation with ajax
Messages next to and highlights of the problematic fields + general message at top of the page, i.e. 'Oops there was a problem; check out the errors highlighted in the form...' My preference 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:305209 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Sever-side data validation with ajax
The good news seems that one could validate server-side data using ajax call to send the form data but the down side seems to be the UI err presentation part, when there's data problem one would prompt/alert user about it, the js alert function is one way, write some sort of msg and make it VISIBLE on top of the problematic field is another (I like this approach better, btw, fairly easily done), popup is sometimes deemed annoying (alert is popup). What's your thought? First, this has nothing to do with AJAX or server-side validation, really. Your options for notifying the user of an error are no different with AJAX than they would be with any sort of client-side validation. That said, I don't think there's one single approach that would always be best. I think that different forms may have different optimal ways of notifying the user. Sometimes the best approach would be to simply change the appearance of the field, and perhaps set focus on that field. Other times, the best approach might be to show the user a list of errors. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305210 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Sever-side data validation with ajax
Messages next to and highlights of the problematic fields + general message at top of the page, i.e. 'Oops there was a problem; check out the errors highlighted in the form...' My preference Dominic Well, I'm torn between Messages next to and highlights of the problematic fields and Messages next to and highlights of the problematic fields + general message at top of the page. 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:305211 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Sever-side data validation with ajax
First, this has nothing to do with AJAX or server-side validation, really. Your options for notifying the user of an error are no different with AJAX than they would be with any sort of client-side validation. Disagree. Server-side validation, traditionally means to send a form to cf server and have the cf server run some code to check the data on a relational db or desktop db or whatever data source, then if there's data problem, alert user with cf type code. Here's the difference is to use ajax do js call for a cfc that does the db side data check then do alert or not. I don't enjoy writing this to refute you... That said, I don't think there's one single approach that would always be best. I think that different forms may have different optimal ways of notifying the user. Sometimes the best approach would be to simply change the appearance of the field, Similar to Dom's hightlight I think, not bad. and perhaps set focus on that field. You're talking on this one (that's what I've already did). Other times, the best approach might be to show the user a list of errors. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305212 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Sever-side data validation with ajax
First, this has nothing to do with AJAX or server-side validation, really. Your options for notifying the user of an error are no different with AJAX than they would be with any sort of client-side validation. Disagree. Server-side validation, traditionally means to send a form to cf server and have the cf server run some code to check the data on a relational db or desktop db or whatever data source, then if there's data problem, alert user with cf type code. Here's the difference is to use ajax do js call for a cfc that does the db side data check then do alert or not. I don't enjoy writing this to refute you... You may wish to reread my response - I mentioned client-side validation, not server-side validation. Your options for displaying error messages that result from AJAX calls are identical to the options for displaying error messages that result from client-side validation. In both cases, you're going to invoke JavaScript to perform some action that will validate your data, and you're going to receive a result that you will have to process within the browser using JavaScript. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305213 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
DateCompare or Diff? To determine if the Current Date is the Weekend or a Weekday
Any suggestions on how to determine on Request, if the current date/time is a weekday or weekend? 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:305214 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: DateCompare or Diff? To determine if the Current Date is the Weekend or a Weekday
http://www.cfquickdocs.com/?getDoc=DayOfWeek DayOfWeek() Description: Determines the day of the week, in a date. Returns: The ordinal for the day of the week, as an integer in the range 1 (Sunday) to 7 (Saturday). So, switch DayOfWeek(Now()) case 1,7 - weekend. On Wed, May 14, 2008 at 9:38 AM, Nate Willard [EMAIL PROTECTED] wrote: Any suggestions on how to determine on Request, if the current date/time is a weekday or weekend? 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:305215 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: DateCompare or Diff? To determine if the Current Date is the Weekend or a Weekday
Check out DayOfWeek(Now()). IIRC 1=Sun, 7=Sat -Original Message- From: Nate Willard [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 13, 2008 8:38 PM To: CF-Talk Subject: DateCompare or Diff? To determine if the Current Date is the Weekend or a Weekday Any suggestions on how to determine on Request, if the current date/time is a weekday or weekend? 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:305216 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: DateCompare or Diff? To determine if the Current Date is the Weekend or a Weekday
Dave James. This is for a time tracker tool, so I would like the weekend to start Friday at 6pm... Is there anyway to do a DateCompare for a set date range? The weekend being Fri 6pm - Sunday 10pm? Thanks! - Original Message From: Dave Francis [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, May 13, 2008 9:27:16 PM Subject: RE: DateCompare or Diff? To determine if the Current Date is the Weekend or a Weekday Check out DayOfWeek(Now()). IIRC 1=Sun, 7=Sat -Original Message- From: Nate Willard [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 13, 2008 8:38 PM To: CF-Talk Subject: DateCompare or Diff? To determine if the Current Date is the Weekend or a Weekday Any suggestions on how to determine on Request, if the current date/time is a weekday or weekend? 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:305217 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: DateCompare or Diff? To determine if the Current Date is the Weekend or a Weekday
OK, so you use DayOfWeek() along with Hour(). On Wed, May 14, 2008 at 1:47 PM, Nate Willard [EMAIL PROTECTED] wrote: Dave James. This is for a time tracker tool, so I would like the weekend to start Friday at 6pm... Is there anyway to do a DateCompare for a set date range? The weekend being Fri 6pm - Sunday 10pm? Thanks! - Original Message From: Dave Francis [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Tuesday, May 13, 2008 9:27:16 PM Subject: RE: DateCompare or Diff? To determine if the Current Date is the Weekend or a Weekday Check out DayOfWeek(Now()). IIRC 1=Sun, 7=Sat -Original Message- From: Nate Willard [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 13, 2008 8:38 PM To: CF-Talk Subject: DateCompare or Diff? To determine if the Current Date is the Weekend or a Weekday Any suggestions on how to determine on Request, if the current date/time is a weekday or weekend? 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:305218 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4