RE: Proxy Authentication with Oracle - Does ColdFusion Support th is?
Is there a workaround? Speaking of .NET/C#, to discern the identity of the actual user while keeping the benefits of pooling, the following two approaches can be used: Proxy Authentication using C#: String oradb = Data Source=OraDb;User Id=ActualUser;Password=secret; Proxy User Id=scott;Proxy Password=tiger; ; OR Client Identifier using C#/Oracle: conn.ClientId = SomeUser; Is there a similar method in ColdFusion? Thanks Regards, Joseph. -Original Message- From: Joseph Bugeja [mailto:[EMAIL PROTECTED] Sent: Saturday, April 19, 2008 2:35 PM To: CF-Talk Subject: Re: Proxy Authentication with Oracle - Does ColdFusion Support th is? Hi Dave, Thanks for your immediate reply. This is a bit problematic. I think there are workarounds to this but do you happen to know how this problem can be dealt with? Speaking from a security perspective, we need to find a way to identify the users that are actually connected to the database whilst preserving the advantages of connection pooling. .NET does not have this problem because in the connection string we can specify both the proxy user and the real users. I know that Oracle has something that is called the client id, and this could be a possible solution, but again we need to know what Adobe or CF users recommend. Regards, Joseph. In order to have proper auditing and for other benefits like No, I don't think so. 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:303842 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CF8.0.1 - GC overhead limit exceeded?
CF Proâs, I recently upgraded to 8.0.1 and had no issues but oddly I got a first time error for a big scheduled job which runs every morning, I havenât seen this one before. Any ideas? Message GC overhead limit exceeded StackTrace java.lang.OutOfMemoryError: GC overhead limit exceeded My thought it to disable the OutOfMemoryError. CF is running on Java 1.6.0_04 http://java.sun.com/javase/technologies/hotspot/gc/gc_tuning_6.html#par_gc.oom -Jim ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303843 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: [BULK] Re: args arg collections
Yes, you get two dumps. However, you'll notice that the output from
testMe2 dumps a structure of two keys, both containing undefined
struct element. If you remove the cfargument from testMe2, the
dumps are identical. My question is, why?
-Original Message-
From: Azadi Saryev [mailto:[EMAIL PROTECTED]
Sent: Friday, April 18, 2008 10:21 PM
To: CF-Talk
Subject: [BULK] Re: args arg collections
Importance: Low
i ran your code on cf8.1 and got 2 dumps back:
dump 1: struct 1 sample string
dump 2: struct ONE sample string
this code ran fine as well, outputting 2 dumps:
cffunction name=testMe2 output=1
cfdump var=#arguments# label=testMe2 args
/cffunction
cffunction name=testMe output=1
cfdump var=#arguments# label=testMe1args
cfinvoke method=testMe2 argumentcollection=#arguments# /
/cffunction
cfoutput
#testMe(sample string)#
/cfoutput
i have also put the above 2 funcs in a cfc and called it with cfset t =
createobject('component', 'test').testMe('hello there!') and still got
2 dumps back...
which version of cf are you running? how is this not working in your
case (errors? no output?)? am i missing something here?
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/
Leitch, Oblio wrote:
Yes, I could *always* use the names, but I'm trying to run the
function
with unnamed arguments. Additionally, I explicitly want to pass
arguments from one to the next.
-Original Message-
From: Leitch, Oblio [mailto:[EMAIL PROTECTED]
Sent: Friday, April 18, 2008 4:55 PM
To: CF-Talk
Subject: args arg collections
Can someone explain why I can't pass an unnamed argument set from one
function to another?
cffunction name=testMe2 output=1
cfargument name=one type=string
cfdump var=#arguments#
/cffunction
cffunction name=testMe output=1
cfdump var=#arguments#
cfinvoke method=testMe2 argumentcollection=#arguments# /
/cffunction
cfoutput
#testMe(sample string)#
/ 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:303844
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: [BULK] Re: args arg collections
ArgumentCollection passes named arguments; this is why the arguments are
undefined (the 'one' argument is not supplied and the other argument is
unnamed). I agree that the second argument being undefined is odd; not
entirely sure why but I think the above is the jist of it.
If you call the function as below you will get the results you expect:
cfoutput
#testMe(two = sample string)#
/cfoutput
Or like this:
cfoutput
#testMe(one = sample string)#
/cfoutput
However, if you really must take the order of arguments and pass them to the
second function then this will work (though it will ignore any named
arguments passed to the function and only work with the order):
cffunction name=testMe output=1
cfscript
var argString = ;
var keys = StructKeyArray(arguments);
var testMe2Result = ;
var i = 0;
for(i=1; i LTE ArrayLen(keys); i=i+1)
argString = ListAppend(argString, '#arguments[keys[i]]#');
testMe2Result = Evaluate('testMe2(#argString#)');
/cfscript
/cffunction
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:303845
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: [BULK] Re: args arg collections
I should mention that the workaround will only work with simple values - which is somewhat of a downside. 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:303846 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: args arg collections
Well then you shouldn't be surprised that it doesn't work! One way or the other you need the make the keys in the arguments struct match up. -Original Message- From: Leitch, Oblio [mailto:[EMAIL PROTECTED] Sent: Friday, April 18, 2008 5:11 PM To: CF-Talk Subject: RE: args arg collections Yes, I could *always* use the names, but I'm trying to run the function with unnamed arguments. Additionally, I explicitly want to pass arguments from one to the next. -Original Message- From: Gaulin, Mark [mailto:[EMAIL PROTECTED] Sent: Friday, April 18, 2008 5:06 PM To: CF-Talk Subject: RE: args arg collections Try this (below) and you'll see why... The arguments collection is key value and testMe assigns a key of 1 to the first argument, which doesn't match any of the arguments to testMe2. cffunction name=testMe2 output=1 cfargument name=one type=string cfdump var=#arguments# /cffunction cffunction name=testMe output=1 cfdump var=#arguments# !--- cfinvoke method=testMe2 argumentcollection=#arguments# / --- /cffunction cfoutput #testMe2(sample string)# #testMe(sample string)# /cfoutput -Original Message- From: Leitch, Oblio [mailto:[EMAIL PROTECTED] Sent: Friday, April 18, 2008 4:55 PM To: CF-Talk Subject: args arg collections Can someone explain why I can't pass an unnamed argument set from one function to another? cffunction name=testMe2 output=1 cfargument name=one type=string cfdump var=#arguments# /cffunction cffunction name=testMe output=1 cfdump var=#arguments# cfinvoke method=testMe2 argumentcollection=#arguments# / /cffunction cfoutput #testMe(sample string)# / cfoutput v--- ignore this ---v This email message may contain privileged and/or confidential information. If you are not the intended recipient(s), you are hereby notified that any dissemination, distribution, or copying of this email message is strictly prohibited. If you have received this message in error, please immediately notify the sender and delete this email message from your computer. CAUTION: The Agency of Human Services cannot ensure the confidentiality or security of email transmissions. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303847 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.0.1 - GC overhead limit exceeded?
Jim, Have you tried to move back to the 1.5 JVM? I found many references on improved performance, even with 8.0.1, and it's been really good for us. Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer _ http://blog.cutterscrossing.com James Blaha wrote: CF Proâs, I recently upgraded to 8.0.1 and had no issues but oddly I got a first time error for a big scheduled job which runs every morning, I havenât seen this one before. Any ideas? Message GC overhead limit exceeded StackTracejava.lang.OutOfMemoryError: GC overhead limit exceeded My thought it to disable the OutOfMemoryError. CF is running on Java 1.6.0_04 http://java.sun.com/javase/technologies/hotspot/gc/gc_tuning_6.html#par_gc.oom -Jim ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303848 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: [BULK] Re: args arg collections
Actually, they *are* technically named; the keys in the structure are numeric. You can't evaluate 'struct.1', but you _can_ evaluate 'struct[1]'. Further, what I'm saying is you *can* pass arguments through using an argumentCollection attribute. What you *can't* do is name the arguments in the receiving function if they are unnamed when passed through. This is not true when the data is sent directly. Here are the test samples: This works; each dump shows a struct with a key one, containing the original string: cffunction name=testMe2 output=1 cfargument name=one cfdump var=#arguments# label=testMe 2 output=browser / /cffunction cffunction name=testMe output=1 cfargument name=one cfdump var=#arguments# label=testMe output=browser / cfinvoke method=testMe2 argumentcollection=#arguments# / /cffunction This works; each dump shows a struct with a key 1, containing the original string: cffunction name=testMe2 output=1 cfdump var=#arguments# label=testMe 2 output=browser / /cffunction cffunction name=testMe output=1 cfdump var=#arguments# label=testMe output=browser / cfinvoke method=testMe2 argumentcollection=#arguments# / /cffunction This works; each dump shows a struct with a key one, containing the original string: cffunction name=testMe2 output=1 cfdump var=#arguments# label=testMe 2 output=browser / /cffunction cffunction name=testMe output=1 cfargument name=one cfdump var=#arguments# label=testMe output=browser / cfinvoke method=testMe2 argumentcollection=#arguments# / /cffunction This FAILS; second dump shows a struct with keys 1 and ONE, both of which are empty: cffunction name=testMe2 output=1 cfargument name=one cfdump var=#arguments# label=testMe 2 output=browser / /cffunction cffunction name=testMe output=1 cfdump var=#arguments# label=testMe output=browser / cfinvoke method=testMe2 argumentcollection=#arguments# / /cffunction Hopefully this clarifies where things seem to be going wrong. Does this seem illogical to anyone else, or is it just me? This email message may contain privileged and/or confidential information. If you are not the intended recipient(s), you are hereby notified that any dissemination, distribution, or copying of this email message is strictly prohibited. If you have received this message in error, please immediately notify the sender and delete this email message from your computer. CAUTION: The Agency of Human Services cannot ensure the confidentiality or security of email transmissions. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303849 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Remove everything but numbers and letters from a string
You need to add a caret just after the opening bracket. It inverts the selected items and says everything BUT these. -Original Message- From: Steve Sequenzia [mailto:[EMAIL PROTECTED] Sent: Sunday, April 20, 2008 8:52 PM To: CF-Talk Subject: Re: Remove everything but numbers and letters from a string Thanks for the help. I am trying to do it like this: cfset d2 = rereplace(lcase(d1) , '[A-Za-z0-9 ]', '','all') / but (understandably) it is doing the reverse of what I want. It is replacing all the numbers and letters. How do I change it so it only picks characters that are not numbers and letters? Thanks The regex to use would look like this [A-Za-z0-9 ] -Mike Chabot On Sun, Apr 20, 2008 at 5:17 PM, Mike Chabot [EMAIL PROTECTED] wrote: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303850 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFFile append with a source file?
Hi, i'm looking for a custom tag (cfx or anything else) that would allow me to use cffile action=append with a source file: the purpose here is to merge several documents (xml files) into another one without having to read them in a variable (too large amount of data for the server's RAM). Thanks in advance ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303851 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Ajax: Who's into Ajax and Business Cases
Don: If you want to ask questions about AJAX, there are a vast number of other resources available to you. Each of the major libraries has their own message board or Google group. Here's some URLs to get you started... http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid=72catid =602 http://groups.google.com/group/jquery-en/ http://forum.mootools.net/ http://extjs.com/forum/ http://tech.groups.yahoo.com/group/ydn-javascript/ http://www.prototypejs.org/discuss -Original Message- From: Don L [mailto:[EMAIL PROTECTED] Sent: Friday, April 18, 2008 5:35 PM To: CF-Talk Subject: Ajax: Who's into Ajax and Business Cases First of all, the Ajax list activitity is not high, hence, I'm posting it to this one for more readership (it's also cf-related). The main purpose of this post to find out who in this community are Much Into Ajax (I wish I could make them bold, to stand out), and equally important, you know how to make business cases with ajax features and functions. Secondly, about Ajax resource (even cf-specific ajax resources) sharing. Let me start with one, I find www.ajaxian.com useful. Thanks. P.S. 1) It would be nice if people post Ajax related topic with prefix of Ajax: for future reference. P.S. 2) I propose to the list owner, to consider to expand the ColdFusion Talk to Web App Development Talk centered on ColdFusion, I know a bit long ... ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303852 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.0.1 - GC overhead limit exceeded?
This is definitely worth a try, as there are other good reasons to move back to 1.5. For example, the JRun web server can't serve pages via SSL on Java 6 but it works fine on Java 1.5. On Mon, Apr 21, 2008 at 9:08 PM, Cutter (CFRelated) [EMAIL PROTECTED] wrote: Jim, Have you tried to move back to the 1.5 JVM? I found many references on improved performance, even with 8.0.1, and it's been really good for us. -- 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:303853 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFFile append with a source file?
You could use cfexecute to `type` (or `cat`... depending on your platform) the files into 1 file Example... type file1.xml file2.xml combined.xml ..:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Stephane Vantroyen [mailto:[EMAIL PROTECTED] Sent: Monday, April 21, 2008 9:41 AM To: CF-Talk Subject: CFFile append with a source file? Hi, i'm looking for a custom tag (cfx or anything else) that would allow me to use cffile action=append with a source file: the purpose here is to merge several documents (xml files) into another one without having to read them in a variable (too large amount of data for the server's RAM). Thanks in advance ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303854 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: [BULK] Re: args arg collections
Yes, this is exactly as I said. The 'one' argument is undefined because it has not been passed to the function - that is clear enough. I also said that I wasn't 100% sure why the '1' argument was undefined but that I suspect that ColdFusion knows it is an unnamed argument even though it has assigned it with a number as its key. This may be a bug or intentional behaviour. A little testing reveals why: cffunction name=testMe output=1 cfset var args = StructNew() cfset var arg = cfloop collection=#arguments# item=arg cfset args[arg] = Duplicate(arguments[arg]) /cfloop cfdump var=#args# cfset testMe2(argumentCollection = args) /cffunction This should product the same results as you are getting now. If you change the name's slightly however, it will work: cfloop collection=#arguments# item=arg cfset args['a' arg] = arguments[arg] /cfloop The reason it is failing is that '1' is an invalid named argument name (even though CF assigns it to unnamed variables). Looping through the unnamed arguments and prepending 'a' to them in a new struct and then passing that as the argument collection should solve your problem. You could even make sure you only rename unnamed arguments so: cffunction name=testMe output=1 cfset var args = StructNew() cfset var arg = cfloop collection=#arguments# item=arg cfif IsNumeric(arg) cfset args['a' arg] = arguments[arg] /cfif /cfloop cfdump var=#arguments# cfset testMe2(argumentCollection = args) /cffunction You most likely still have a problem though, 'one' is still undefined because no argument named 'one' has been passed to the second function. Dominic On 21/04/2008, Leitch, Oblio [EMAIL PROTECTED] wrote: Actually, they *are* technically named; the keys in the structure are numeric. You can't evaluate 'struct.1', but you _can_ evaluate 'struct[1]'. Further, what I'm saying is you *can* pass arguments through using an argumentCollection attribute. What you *can't* do is name the arguments in the receiving function if they are unnamed when passed through. This is not true when the data is sent directly. Here are the test samples: This works; each dump shows a struct with a key one, containing the original string: cffunction name=testMe2 output=1 cfargument name=one cfdump var=#arguments# label=testMe 2 output=browser / /cffunction cffunction name=testMe output=1 cfargument name=one cfdump var=#arguments# label=testMe output=browser / cfinvoke method=testMe2 argumentcollection=#arguments# / /cffunction This works; each dump shows a struct with a key 1, containing the original string: cffunction name=testMe2 output=1 cfdump var=#arguments# label=testMe 2 output=browser / /cffunction cffunction name=testMe output=1 cfdump var=#arguments# label=testMe output=browser / cfinvoke method=testMe2 argumentcollection=#arguments# / /cffunction This works; each dump shows a struct with a key one, containing the original string: cffunction name=testMe2 output=1 cfdump var=#arguments# label=testMe 2 output=browser / /cffunction cffunction name=testMe output=1 cfargument name=one cfdump var=#arguments# label=testMe output=browser / cfinvoke method=testMe2 argumentcollection=#arguments# / /cffunction This FAILS; second dump shows a struct with keys 1 and ONE, both of which are empty: cffunction name=testMe2 output=1 cfargument name=one cfdump var=#arguments# label=testMe 2 output=browser / /cffunction cffunction name=testMe output=1 cfdump var=#arguments# label=testMe output=browser / cfinvoke method=testMe2 argumentcollection=#arguments# / /cffunction Hopefully this clarifies where things seem to be going wrong. Does this seem illogical to anyone else, or is it just me? This email message may contain privileged and/or confidential information. If you are not the intended recipient(s), you are hereby notified that any dissemination, distribution, or copying of this email message is strictly prohibited. If you have received this message in error, please immediately notify the sender and delete this email message from your computer. CAUTION: The Agency of Human Services cannot ensure the confidentiality or security of email transmissions. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303856 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: output column average using coldfusion
I have to point out that this approach is terribly inefficient. Calculations like this should be in at the database level using SQL, that's exactly what it's supposed to do. Any time you're looping over queries to run more queries, or to total things up, it should be a big red flag, because in almost every situation the same thing can be done in SQL more easily and far more quickly. On Fri, Apr 18, 2008 at 3:36 PM, erik tom [EMAIL PROTECTED] wrote: How can i accomplish this ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303855 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Accessing SSIS package
Another option is to call the sp_start_job stored procedure. http://technet.microsoft.com/en-us/library/ms186757.aspx -Phil You should be able to run it using CFEXECUTE to run an app called DTEXEC.exe. Check out the docs here: http://msdn2.microsoft.com/en-us/library/ms162810.aspx --Bob Happy Saturday! I created an SSIS package and deployed it to my SQL Server, but what I am trying to figure out is how to trigger it using ColdFusion. Do I need to create an SP or a trigger to do this? I know in the past with DTS packages we would use the CFOBJECT tag to invoke it. Thanks, Bruce ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303857 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfgrid flash formating questions
ok, have googled, but no luck. Q1. how do i align the submit button, to the insert button within the cfgrid? or remove the insertButton and make a button that does the same thing... Q2. how do i remove the column that is thrown in for id.. i have my own id column i am using, but cfgrid inserts its own, in front.. thanks -paul ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303860 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: output column average using coldfusion
Select avg(columnname) as whatever from table ..:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: erik tom [mailto:[EMAIL PROTECTED] Sent: Monday, April 21, 2008 10:01 AM To: CF-Talk Subject: Re: output column average using coldfusion I have to point out that this approach is terribly inefficient. Calculations like this should be in at the database level using SQL, that's exactly what it's supposed to do. Any time you're looping over queries to run more queries, or to total things up, it should be a big red flag, because in almost every situation the same thing can be done in SQL more easily and far more quickly. On Fri, Apr 18, 2008 at 3:36 PM, erik tom [EMAIL PROTECTED] wrote: How can i accomplish this ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303861 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Adobe Spry Menu and Flash - Last Try
I know this is a bit OT, but it's still a problem maybe someone on list has seen. In CS3 Adobe provides a new function for generating fly out menus called Spry menus. The work well, but they don't seem to play very nicely with flash animation files (swfs). The flash animation and Spry menus seem to be interfering with each other. Here's an example: http://www.austin-williams.com/clients/Danfords/sprytest/index_testing4.html Spry does work OK if you convert the flash to an .flv, but you can't always do that. Here's an example of how they are supposed to work: http://danfords.com . Does anyone have any familiarity with this issue or have more insight they can provide? Thanks, Robert B. Harrison Director of Interactive services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be . ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303859 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: [BULK] Re: args arg collections
I just realised what an eejit I was with my first solution (close but no
cigar). The following 'TestMe' function will work when either named OR
unnamed arguments are passed to it:
cffunction name=testMe output=1
cfset var arg =
cfset var argList =
cfset var aKeys = StructKeyArray(arguments)
cfdump var=#arguments#
!--- named or no arguments ---
cfif not ArrayLen(aKeys) or not IsNumeric(aKeys[1])
cfinvoke method=testMe2 argumentCollection=#arguments#
!--- unnamed arguments ---
cfelse
cfloop collection=#arguments# item=arg
cfset argList = ListAppend(argList, 'arguments[#arg#]')
/cfloop
cfset Evaluate('testMe2(#argList#)')
/cfif
/cffunction
cfoutput
p No arguments:/p
#testMe()#
p One unnamed argument:/p
#testMe(hello)#
p Two named arguments:/p
#testMe(foo=hello, one=foo)#
/cfoutput
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:303858
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Embedded YouTube movies
Hi All. I would like to allow site visitors to post a link to their youtube video to a database and then I output the link as a variable. It is not working. Has any successfully done this before? See my code below. object width=425 height=355 param name=movie value=#video#/param param name=wmode value=transparent/param embed src=#video# type=application/x-shockwave-flash wmode=transparent width=425 height=355/embed /object ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303863 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Adobe Spry Menu and Flash - Last Try
In CS3 Adobe provides a new function for generating fly out menus called Spry menus. The work well, but they don't seem to play very nicely with flash animation files (swfs). The flash animation and Spry menus seem to be interfering with each other. Here's an example: http://www.austin-williams.com/clients/Danfords/sprytest/index_testing4.html Check these technotes: http://kb.adobe.com/selfservice/viewContent.do?externalId=tn_15523sliceId=2 http://kb.adobe.com/selfservice/viewContent.do?externalId=tn_14201sliceId=1 Hope it will help Massimo Foti, web-programmer for hire Tools for ColdFusion and Dreamweaver developers: http://www.massimocorner.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303864 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Embedded YouTube movies
It's not working I think we've been down this road before, but how exactly is it *not* working? Error messages? What *does* happen? Help us help you... On Mon, Apr 21, 2008 at 9:35 AM, Torrent Girl [EMAIL PROTECTED] wrote: Hi All. I would like to allow site visitors to post a link to their youtube video to a database and then I output the link as a variable. It is not working. Has any successfully done this before? See my code below. object width=425 height=355 param name=movie value=#video#/param param name=wmode value=transparent/param embed src=#video# type=application/x-shockwave-flash wmode=transparent width=425 height=355/embed /object ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303865 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Adobe Spry Menu and Flash - Last Try
Doesn't Flash have a z-index property for the embed tags (to be clear, thats an HTML feature, not Flash). In the past when I've had DHTML and Flash issues, it was fixed by simply setting the zindex... no wait - I think it might wmode. One of those things. ;) I think it was wmode :-) Massimo Foti, web-programmer for hire Tools for ColdFusion and Dreamweaver developers: http://www.massimocorner.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303866 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Proxy Authentication with Oracle - Does ColdFusion Support th is?
If the proxy user supports using a password, you could always override the values supplied in the ColdFusion datasource at runtime. CFQUERY takes an optional setting of username and password. If you plug the proxy user information into those optional values, it will use those credentials for authentication. Or, at least, so sayeth the documentation. Matthew Williams Geodesic GraFX www.geodesicgrafx.com/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:303867 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Embedded YouTube movies
Sorry. The movie looks as if it is loading but never comes up. It's not working I think we've been down this road before, but how exactly is it *not* working? Error messages? What *does* happen? Help us help you... On Mon, Apr 21, 2008 at 9:35 AM, Torrent Girl [EMAIL PROTECTED] wrote: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303868 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfgrid flash formating questions
Q2: remove column, rowheaders=no colheaders=yes ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303869 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Embedded YouTube movies
And still the crowd yells for more. What exactly is the value for video? Can you go to that link in your browser (and it comes up?) On Mon, Apr 21, 2008 at 10:54 AM, Torrent Girl [EMAIL PROTECTED] wrote: Sorry. The movie looks as if it is loading but never comes up. It's not working I think we've been down this road before, but how exactly is it *not* working? Error messages? What *does* happen? Help us help you... On Mon, Apr 21, 2008 at 9:35 AM, Torrent Girl [EMAIL PROTECTED] wrote: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303870 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Adobe Spry Menu and Flash - Last Try
Doesn't Flash have a z-index property for the embed tags (to be clear, thats an HTML feature, not Flash). In the past when I've had DHTML and Flash issues, it was fixed by simply setting the zindex... no wait - I think it might wmode. One of those things. ;) On Mon, Apr 21, 2008 at 9:10 AM, Robert Harrison [EMAIL PROTECTED] wrote: I know this is a bit OT, but it's still a problem maybe someone on list has seen. In CS3 Adobe provides a new function for generating fly out menus called Spry menus. The work well, but they don't seem to play very nicely with flash animation files (swfs). The flash animation and Spry menus seem to be interfering with each other. Here's an example: http://www.austin-williams.com/clients/Danfords/sprytest/index_testing4.html Spry does work OK if you convert the flash to an .flv, but you can't always do that. Here's an example of how they are supposed to work: http://danfords.com . Does anyone have any familiarity with this issue or have more insight they can provide? Thanks, Robert B. Harrison Director of Interactive services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be . ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303862 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Adobe Spry Menu and Flash - Last Try
Yeah, wmode ..:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Monday, April 21, 2008 10:34 AM To: CF-Talk Subject: Re: Adobe Spry Menu and Flash - Last Try Doesn't Flash have a z-index property for the embed tags (to be clear, thats an HTML feature, not Flash). In the past when I've had DHTML and Flash issues, it was fixed by simply setting the zindex... no wait - I think it might wmode. One of those things. ;) On Mon, Apr 21, 2008 at 9:10 AM, Robert Harrison [EMAIL PROTECTED] wrote: I know this is a bit OT, but it's still a problem maybe someone on list has seen. In CS3 Adobe provides a new function for generating fly out menus called Spry menus. The work well, but they don't seem to play very nicely with flash animation files (swfs). The flash animation and Spry menus seem to be interfering with each other. Here's an example: http://www.austin-williams.com/clients/Danfords/sprytest/index_testing4.html Spry does work OK if you convert the flash to an .flv, but you can't always do that. Here's an example of how they are supposed to work: http://danfords.com . Does anyone have any familiarity with this issue or have more insight they can provide? Thanks, Robert B. Harrison Director of Interactive services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 T : 631.231.6600 Ext. 119 F : 631.434.7022 www.austin-williams.com Great advertising can't be either/or... It must be . ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303871 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Embedded YouTube movies
And still the crowd yells for more. What exactly is the value for video? Can you go to that link in your browser (and it comes up?) On Mon, Apr 21, 2008 at 10:54 AM, Torrent Girl [EMAIL PROTECTED] wrote: Yes the movie comes up in the browser when i go directly to it. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303873 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Embedded YouTube movies
What is the url? On Mon, Apr 21, 2008 at 11:12 AM, Torrent Girl [EMAIL PROTECTED] wrote: And still the crowd yells for more. What exactly is the value for video? Can you go to that link in your browser (and it comes up?) On Mon, Apr 21, 2008 at 10:54 AM, Torrent Girl [EMAIL PROTECTED] wrote: Yes the movie comes up in the browser when i go directly to it. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303874 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.0.1 - GC overhead limit exceeded?
I raised the Max JVM Heap Size on my cf8 ent server from 1024 to 1236 and was able to get to the root cause. I have a scheduled job that opens a SFTP connection and looks at a directory. cfftp action = LISTDIR stopOnError = Yes name = ListFiles timeout=300 directory = /myFiles/ connection = mySFTPConnection The are about 100*2.5 MB files in the directory that choked the directory listing and caused CF to error out. My quick fix I was to clean out some of the files in the directory and all works fine again. Do you think this is a bug in cfftp 8.0.1 and or the new JVM? -Jim ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303875 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Embedded YouTube movies
I find this works for me. I've actually embedded it into the ActivateURL() by
Joel Mueller, updated by Lucas Sherwood.
/* thisURL = {youtube url} */
object width=425 height=350
param name=movie value=http://www.youtube.com/v/'
listFirst(listrest(thisURL,=),) '/param
param name=wmode value=transparent/param
embed src=http://www.youtube.com/v/' listFirst(listrest(thisURL,=),)
' type=application/x-shockwave-flash wmode=transparent width=425
height=350/embed
/object
You can't just put the browser URL in... the Flash Movie needs a slightly
different URL, thus the string manipulation shown above.
Mik
At 10:35 AM 4/21/2008, Torrent Girl wrote:
Hi All.
I would like to allow site visitors to post a link to their youtube video to a
database and then I output the link as a variable.
It is not working.
Has any successfully done this before? See my code below.
object width=425 height=355
param name=movie value=#video#/param
param name=wmode value=transparent/param
embed src=#video# type=application/x-shockwave-flash wmode=transparent
width=425 height=355/embed
/object
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303876
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Embedded YouTube movies
On Mon, Apr 21, 2008 at 10:35 AM, Torrent Girl [EMAIL PROTECTED] wrote: Hi All. I would like to allow site visitors to post a link to their youtube video to a database and then I output the link as a variable. It is not working. Has any successfully done this before? See my code below. The links for embedding a youtube video and viewing the page for that video are different. If your users are putting in the URL that links to the main video page, it will not work...you will need to parse out the unique id for that video, and then use the correct URL... The main video link looks something like... http://www.youtube.com/watch?v=eBGIQ7ZuuiU; The embedding video link looks something like... http://www.youtube.com/v/eBGIQ7ZuuiU; ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303872 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
having issues populating information to a new window
hello,
I am working on a custom form for a cms system in coldfusion. what i am doing
is attempting to set a new option in a dropdown list to be 5 custom.
when you click on the edit button a new window pops up which gives you the
course.edit.cfm. within this window is the dropdown list i am working on. i
have gotten it to load the new page but it is loading in the same window as the
first popup. i need it to load in a new window so that once i complete the
selection of members it will allow me to complete the course editing and select
update.
this is the function code:
function customMembers(objAccess) {
if (objAccess.options[objAccess.selectedIndex].value == 5){
window.open('members.custom.cfm?course=cfoutput#url.course#/cfoutput',
'CMS','width=750,height=600,scrollbars=1,resizable=1,status=1,toolbars=1')
}
}
this is where it is being referenced in the page:
td
select class=fieldElement name=accessLevelID onChange=showCategory(this,
this.form.memberCategoryID); customMembers(this);
option value=1cfif qryCourse.accessLevelID eq 1 selected/cfifAll
Learners
option value=2cfif qryCourse.accessLevelID eq 2 selected/cfifNon-USAID
Learners Only
option value=3cfif qryCourse.accessLevelID eq 3 selected/cfifUSAID
Learners Only
option value=4cfif qryCourse.accessLevelID eq 4 selected/cfifCMS Users
option value=5cfif qryCourse.accessLevelID eq 5selected/cfifCustom Users
/select
/td
any help or suggestions would be greatly appreciated
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303877
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Adobe Spry Menu and Flash - Last Try
Doesn't Flash have a z-index property for the embed tags ... I think it was wmode :-) Yes, but layering is not the problem. It's more like the Spry menus and Flash animation are using the same resources on the video card or the same locations in memory. We can make it work fine with flash that has no animation, but the moment you put animation in the flash, the Spry menu performance goes out the window. It's not layering or WMODE, it looks more like there is a resource conflict between flash animation and Spry menus. We think maybe it's an Adobe bug, but sometimes there is a work for such bugs. 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:303878 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfquery and mysql help
Hi, im sure there must be a better way of doing the following code, and much quicker. i have a query which is built up from data in excel - so i used a excel2query function on it i want to check through the database to see if any of the items within my query exist in the database. so i am looping through the first query checking each row to see if it exists and then doing a cfif statement that then goes on to do further processing if a record does not exist in the database i am sure there must be a better way than this. alot of my code is structured in this way so i think i will benefit hugely by any suggestions that you have about a more efficient way of doing this i was thinking that it could be possible to combine the 2 queries on certain columns and then get it to give me a result of only the rows which are not found in both sides. im not too sure how to achieve this though i would appreciate your feedback thanks richard ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303879 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Embedded YouTube movies
What is the url? On Mon, Apr 21, 2008 at 11:12 AM, Torrent Girl [EMAIL PROTECTED] wrote: I am testing random youTube videos so i don't have a specific one yet try this one http://www.youtube.com/watch?v=Dzr32OqGlOA ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303880 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: cfquery and mysql help
Do you have the query? -Original Message- From: Richard White [mailto:[EMAIL PROTECTED] Sent: Monday, April 21, 2008 10:53 AM To: CF-Talk Subject: cfquery and mysql help Hi, im sure there must be a better way of doing the following code, and much quicker. i have a query which is built up from data in excel - so i used a excel2query function on it i want to check through the database to see if any of the items within my query exist in the database. so i am looping through the first query checking each row to see if it exists and then doing a cfif statement that then goes on to do further processing if a record does not exist in the database i am sure there must be a better way than this. alot of my code is structured in this way so i think i will benefit hugely by any suggestions that you have about a more efficient way of doing this i was thinking that it could be possible to combine the 2 queries on certain columns and then get it to give me a result of only the rows which are not found in both sides. im not too sure how to achieve this though i would appreciate your feedback thanks richard ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303881 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: URL re-write SEO friendly
Hi All, First off...the question was how to do it the way this SEO company is aksing. So let's clarify shall we 1) We currently transform this: http://www.domainname.com/index.cfm?pg=listing_detailsid=83hit=1popup=0 into this: http://www.domainname.com/index.cfm/pg/listing_details/id/83/hit/1/popup/0 So the ? and = are gone and it now looks like directories instead of variable to bots for example /pg/listing details equates to pg=listing details. 2) THE QUESTION (for those that couldn't find it..hehe) An SEO company would prefer to see http://www.domainname.com/furry The BIG difference here is furry must equate to ?pg=listing_detailsid=83hit=1popup=0 I think we can all see the differenceit's quite different than what we do now in # 1 above. The first example still plainly shows the key/value pairs. What the SEO comapnmy is asking for does NOT. So how does one go about doing this WITHOUT an Apache mod rewrite (as this is hosted on Windows for better or for worse) BTWthat was the question ;-) Thanks in advance Cheers - Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. On Fri, 2008-04-18 at 20:27 -0400, Russ wrote: I think he would probably want it to be something like http://www.domain.com/garden_tools/83 Then all you have to do is ignore the first directory and pass the second directory to CF. You can have a generic rewrite done in Apache Something like RewriteRule ^/([^/]+)/([0-9]+)/* http://www.domainname.com/index.cfm?pg=listing_detailsid=$2hit=1popup=0p review=1 Russ -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Friday, April 18, 2008 7:06 PM To: CF-Talk Subject: RE: URL re-write SEO friendly You haven't really asked a question but... if it's a choice between /83/ or /gardentools/ and your page isn't about the number 83, go with the later. Adrian -Original Message- From: Bryan Stevenson Sent: 18 April 2008 23:44 To: CF-Talk Subject: URL re-write SEO friendly Hey Allpassing this along for a co-worker. Hello All -- I am working on a database driven website that can access individual records with a URL like this: http://www.domainname.com/index.cfm?pg=listing_detailsid=83hit=1popup=0 p review=1 In order to make the URL more SEO friendly, we are using a URL handler that lets us structure the URL this way: http://www.domainname.com/index.cfm/pg/listing_details/id/83/hit/1/popup/0 /p review/1 By removing the ? and symbols, we make the URL easier for search engines to navigate. Now, the SEO company is suggesting that we shorten the URL right down to the following: http://www.domainname.com/83/ I've seen many sites use more human readable URLs like the above or like so: http://www.domainname.com/gardentools Which would take you to the garden tool category of a data driven web catalogue (instead of explicitly passing the category ID via the URL). TIA Cheers -- Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303882 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: URL re-write SEO friendly
Does google find this http://www.domainname.com/index.cfm/pg/listing_details/id/83/hit/1/popup/0 more friendly than this http://www.domainname.com/index.cfm?pg=listing_detailsid=83hit=1popup=0 Bryan Stevenson wrote: Hi All, First off...the question was how to do it the way this SEO company is aksing. So let's clarify shall we 1) We currently transform this: http://www.domainname.com/index.cfm?pg=listing_detailsid=83hit=1popup=0 into this: http://www.domainname.com/index.cfm/pg/listing_details/id/83/hit/1/popup/0 So the ? and = are gone and it now looks like directories instead of variable to bots for example /pg/listing details equates to pg=listing details. 2) THE QUESTION (for those that couldn't find it..hehe) An SEO company would prefer to see http://www.domainname.com/furry The BIG difference here is furry must equate to ?pg=listing_detailsid=83hit=1popup=0 I think we can all see the differenceit's quite different than what we do now in # 1 above. The first example still plainly shows the key/value pairs. What the SEO comapnmy is asking for does NOT. So how does one go about doing this WITHOUT an Apache mod rewrite (as this is hosted on Windows for better or for worse) BTWthat was the question ;-) Thanks in advance Cheers - Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. On Fri, 2008-04-18 at 20:27 -0400, Russ wrote: I think he would probably want it to be something like http://www.domain.com/garden_tools/83 Then all you have to do is ignore the first directory and pass the second directory to CF. You can have a generic rewrite done in Apache Something like RewriteRule ^/([^/]+)/([0-9]+)/* http://www.domainname.com/index.cfm?pg=listing_detailsid=$2hit=1popup=0p review=1 Russ -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Friday, April 18, 2008 7:06 PM To: CF-Talk Subject: RE: URL re-write SEO friendly You haven't really asked a question but... if it's a choice between /83/ or /gardentools/ and your page isn't about the number 83, go with the later. Adrian -Original Message- From: Bryan Stevenson Sent: 18 April 2008 23:44 To: CF-Talk Subject: URL re-write SEO friendly Hey Allpassing this along for a co-worker. Hello All -- I am working on a database driven website that can access individual records with a URL like this: http://www.domainname.com/index.cfm?pg=listing_detailsid=83hit=1popup=0 p review=1 In order to make the URL more SEO friendly, we are using a URL handler that lets us structure the URL this way: http://www.domainname.com/index.cfm/pg/listing_details/id/83/hit/1/popup/0 /p review/1 By removing the ? and symbols, we make the URL easier for search engines to navigate. Now, the SEO company is suggesting that we shorten the URL right down to the following: http://www.domainname.com/83/ I've seen many sites use more human readable URLs like the above or like so: http://www.domainname.com/gardentools Which would take you to the garden tool category of a data driven web catalogue (instead of explicitly passing the category ID via the URL). TIA Cheers -- Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303883 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Embedded YouTube movies
http://www.youtube.com/watch?v=Dzr32OqGlOA would convert to http://www.youtube.com/v/Dzr32OqGlOA for embedding the video just try doing this to your URLs to get them ready for the embed portion #rereplace(theurl, '\?|=', '/', 'all')# ..:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Torrent Girl [mailto:[EMAIL PROTECTED] Sent: Monday, April 21, 2008 11:59 AM To: CF-Talk Subject: Re: Embedded YouTube movies What is the url? On Mon, Apr 21, 2008 at 11:12 AM, Torrent Girl [EMAIL PROTECTED] wrote: I am testing random youTube videos so i don't have a specific one yet try this one http://www.youtube.com/watch?v=Dzr32OqGlOA ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303884 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Proxy Authentication with Oracle - Does ColdFusion Support th is?
If the proxy user supports using a password, you could always override the values supplied in the ColdFusion datasource at runtime. CFQUERY takes an optional setting of username and password. If you plug the proxy user information into those optional values, it will use those credentials for authentication. Or, at least, so sayeth the documentation. That will, however, prevent the query from using an existing connection from the pool unless that connection was opened using the user's credentials also. 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:303885 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Proxy Authentication with Oracle - Does ColdFusion Support th is?
Is there a workaround? Speaking of .NET/C#, to discern the identity of the actual user while keeping the benefits of pooling, the following two approaches can be used: Proxy Authentication using C#: String oradb = Data Source=OraDb;User Id=ActualUser;Password=secret;Proxy User Id=scott;Proxy Password=tiger; ; OR Client Identifier using C#/Oracle: conn.ClientId = SomeUser; Is there a similar method in ColdFusion? I'm not aware of any workaround (although that doesn't mean there isn't one). The problem is that CF doesn't let you build your connection string dynamically. You create a datasource, which builds your connection string for you. I'm not aware of any way to inject variables in that string at runtime, or to build a connection string at runtime, while continuing to use CF datasources. You might be able to create a JNDI datasource in JRun or whatever J2EE app server you're using, and reference that from within CF, and set/use the variables with that. That's the approach I'd investigate, I think. 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:303886 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: URL re-write SEO friendly
So how does one go about doing this WITHOUT an Apache mod rewrite (as this is hosted on Windows for better or for worse) There are mod_rewrite analogues for Windows/IIS, such as ISAPI_Rewrite. Alternatively, you could use CF to rewrite URLs for you, although I doubt that would perform as well. 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:303887 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: URL re-write SEO friendly
Does google find this http://www.domainname.com/index.cfm/pg/listing_details/id/83/hit/1/popup/0 more friendly than this http://www.domainname.com/index.cfm?pg=listing_detailsid=83hit=1popup=0 Sorry if I seem frustrated Paul, but so far I've been told I didn't ask a question...so now I've been explicit...now you're asking if Google will care. I didn't ask if anyone thought Google would care (and I doubt highly that it would). I asked a question and am only looking for answers to that question!!! ;-) Thanks all for keeping the useless bandwidth usage down ;-) Cheers - Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303888 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfquery and mysql help
hi andy query 1 has 2 columns firstName and lastName then i want to query the database to ensure that each firstName and lastName combination exists in the database, if not then i want it to return me a list of those that dont. i have achieved this through a loop but i am thinking there must be a quicker way of doing this directly in a cfquery, as it is taking too long when there are thousands of names it has to check 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:303889 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: URL re-write SEO friendly
Thanks all for keeping the useless bandwidth usage down ;-) We all live out 'californeeway' and have plenty of 'internets' to spare so we waste it all day long ;-) Besides... you started it :-) THE QUESTION (for those that couldn't find it..hehe) There was no question until your second post... now whos wasting bandwidth? ;-) So how does one go about doing this WITHOUT an Apache mod rewrite (as this is hosted on Windows for better or for worse) Use an IIS one? Being on windows does't mean you don't have access to asapi URL rewriting methods. I suggest you check the HoF archives (it's been asked plenty of times) or search Google for an IIS solution. You could also officially ask the question Does anyone know of or use an asapi filter for rewriting URLs in IIS that they would recommend? I haven't used one for IIS or I'd offer a more specific suggestion but a simple google search turned up a ton of options. This one seems popular http://www.isapirewrite.com/ ..:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Monday, April 21, 2008 12:42 PM To: CF-Talk Subject: Re: URL re-write SEO friendly Does google find this http://www.domainname.com/index.cfm/pg/listing_details/id/83/hit/1/popup/0 more friendly than this http://www.domainname.com/index.cfm?pg=listing_detailsid=83hit=1popup=0 Sorry if I seem frustrated Paul, but so far I've been told I didn't ask a question...so now I've been explicit...now you're asking if Google will care. I didn't ask if anyone thought Google would care (and I doubt highly that it would). I asked a question and am only looking for answers to that question!!! ;-) Thanks all for keeping the useless bandwidth usage down ;-) Cheers - Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303890 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: URL re-write SEO friendly
I have used ISAPI_Rewrite for IIS, excellent and only $99 per server. http://www.isapirewrite.com/ You'll probably need help setting up the regex rules and the like - but help is always at hand it seems (not from me tho) 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:303891 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: URL re-write SEO friendly
Dominic, There is one called IsapiRewrite4 by Phil Hazel from the uk. It is open source and free And it seems to perform well - with no difference between it and the commercial verison referenced below. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Dominic Watson [mailto:[EMAIL PROTECTED] Sent: Monday, April 21, 2008 12:24 PM To: CF-Talk Subject: Re: URL re-write SEO friendly I have used ISAPI_Rewrite for IIS, excellent and only $99 per server. http://www.isapirewrite.com/ You'll probably need help setting up the regex rules and the like - but help is always at hand it seems (not from me tho) 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:303892 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Reading sessiontimeout dynamically
Does anyone know of a way (or if it's even possible) to programmatically read the sessiontimeout value of a CF app? ..:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.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:303893 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: URL re-write SEO friendly
There is one called IsapiRewrite4 by Phil Hazel from the uk. It is open source and free :) Good news thanks - opensource AND uk! I have only used ISAPI_rewrite within a company who inherited a project that used it; never bought it for myself, though I have been on the verge of doing so. You saved me 50 quid ta! 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:303894 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfquery options and connection pooling
I am trying to figure out the technical ramifications of defining the username and password for a specific DSN in a separate text file and how it may relate to connection pooling v. supplying the user/pass directly in the DSN. Once the file is loaded, user and password are passed to cfqueries using application variables. If the user/pass is defined externally, can connections in the same pool be re-used? If the user/pass is added to the DSN, the user/pass removed from the external text file and the cfquery strings still contain the Application variables for them, what happens to the connection pool? The reason I am trying to wrap my head around this is that our datasource (Oracle) has an increasing number of connections that are never released. Over time, the application becomes sluggish. It also uses stored procs. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303895 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: URL re-write SEO friendly
Thanks Dominic and Mark...straight answersI like that ;-) Cheers - Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. On Mon, 2008-04-21 at 12:34 -0500, Mark Kruger wrote: Dominic, There is one called IsapiRewrite4 by Phil Hazel from the uk. It is open source and free And it seems to perform well - with no difference between it and the commercial verison referenced below. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Dominic Watson [mailto:[EMAIL PROTECTED] Sent: Monday, April 21, 2008 12:24 PM To: CF-Talk Subject: Re: URL re-write SEO friendly I have used ISAPI_Rewrite for IIS, excellent and only $99 per server. http://www.isapirewrite.com/ You'll probably need help setting up the regex rules and the like - but help is always at hand it seems (not from me tho) 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:303896 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: URL re-write SEO friendly
Thanks Dominic and Mark...straight answersI like that ;-) Lol, my favourite responses: 'Why would you want to do that? (fool)' or 'Why don't you just...???' (fool) ;) -- 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:303897 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfquery options and connection pooling
I am trying to figure out the technical ramifications of defining the username and password for a specific DSN in a separate text file and how it may relate to connection pooling v. supplying the user/pass directly in the DSN. Once the file is loaded, user and password are passed to cfqueries using application variables. If the user/pass is defined externally, can connections in the same pool be re-used? Yes. If the user/pass is added to the DSN, the user/pass removed from the external text file and the cfquery strings still contain the Application variables for them, what happens to the connection pool? I'm pretty sure that if you define username and password parameters for CFQUERY, and don't provide useful values, the query will fail. If that doesn't happen, then you can safely assume that CF is using the DSN values for authentication, and those will be in a single connection pool. The reason I am trying to wrap my head around this is that our datasource (Oracle) has an increasing number of connections that are never released. Over time, the application becomes sluggish. It also uses stored procs. If you're using a single username and password for all your CFQUERY tags, it doesn't matter whether this originally came from a text file or from the datasource. They'll all share the same connection pool. It's certainly possible that connections are never being closed. You might check for a newer version of database drivers - if you're using CF Enterprise, you'd get those from http://www.adobe.com/support/coldfusion/, otherwise, you'd get them from your database vendor. You might also set a connection limit, which might help force CF to reuse connections rather than creating new ones. 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:303898 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: URL re-write SEO friendly
Lol, my favourite responses: 'Why would you want to do that? (fool)' or 'Why don't you just...???' (fool) Sometimes - very often, actually - that is the correct response. 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:303899 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Proxy Authentication with Oracle - Does ColdFusion Support th is?
Is the pooling not smart enough to go looking for a connection that already uses those credentials? If it is smart enough, how would this be a bad thing? Unless you have a really high traffic site? Not looking to be a wise ass here, just expressing curiosity as this is bound to come up here (at work) in the future. I've not really kept track of how many sessions the system maintains across our various applications. Matthew Williams Geodesic GraFX www.geodesicgrafx.com/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:303900 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Reading sessiontimeout dynamically
You can read the request timeout from the internal Java singletons underlying CF: http://www.barneyb.com/barneyblog/2007/08/17/requestmonitorgetrequesttimeout/ I'd imagine that reading the session timeout would be similarly accomplished, though you'd need to find the session monitor, not the request monitor. cheers, barneyb On Mon, Apr 21, 2008 at 10:37 AM, Bobby Hartsfield [EMAIL PROTECTED] wrote: Does anyone know of a way (or if it's even possible) to programmatically read the sessiontimeout value of a CF app? ..:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.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:303901 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfquery options and connection pooling
thanks, we are using Oracle driver provided in the macromedia.jar, 3.5 since Oracle's own driver does not support stored procedures. On Mon, Apr 21, 2008 at 1:56 PM, Dave Watts [EMAIL PROTECTED] wrote: I am trying to figure out the technical ramifications of defining the username and password for a specific DSN in a separate text file and how it may relate to connection pooling v. supplying the user/pass directly in the DSN. Once the file is loaded, user and password are passed to cfqueries using application variables. If the user/pass is defined externally, can connections in the same pool be re-used? Yes. If the user/pass is added to the DSN, the user/pass removed from the external text file and the cfquery strings still contain the Application variables for them, what happens to the connection pool? I'm pretty sure that if you define username and password parameters for CFQUERY, and don't provide useful values, the query will fail. If that doesn't happen, then you can safely assume that CF is using the DSN values for authentication, and those will be in a single connection pool. The reason I am trying to wrap my head around this is that our datasource (Oracle) has an increasing number of connections that are never released. Over time, the application becomes sluggish. It also uses stored procs. If you're using a single username and password for all your CFQUERY tags, it doesn't matter whether this originally came from a text file or from the datasource. They'll all share the same connection pool. It's certainly possible that connections are never being closed. You might check for a newer version of database drivers - if you're using CF Enterprise, you'd get those from http://www.adobe.com/support/coldfusion/, otherwise, you'd get them from your database vendor. You might also set a connection limit, which might help force CF to reuse connections rather than creating new ones. 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:303902 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: URL re-write SEO friendly
Sometimes - very often, actually - that is the correct response. ;) agreed, but when written in that way the subtext is very obviously just 'fool', especially the second one (used all the time). 'Why don't you just...' can usually be replaced with 'This is how... and look this up in google to find out why / more (or some such)'. 'Why would you want to do that?!' can usually be replaced with 'If you're doing [x] I'd advise against it because... consider doing [y] instead'. Anyways, now I'm the one wasting bandwidth! Dom -- 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:303903 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Proxy Authentication with Oracle - Does ColdFusion Support th is?
Is the pooling not smart enough to go looking for a connection that already uses those credentials? If it is smart enough, how would this be a bad thing? Unless you have a really high traffic site? Not looking to be a wise ass here, just expressing curiosity as this is bound to come up here (at work) in the future. I've not really kept track of how many sessions the system maintains across our various applications. Yes, it will reuse connections that have the same username and password. However, that's a lot less efficient if everyone has their own username and password than if there's a single username and password for all queries. There will be more connections, since each user will end up with his or her own connection pool, and there'll be less reuse for a given single connection. 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:303904 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: URL re-write SEO friendly
I'll second ISAPI_REWRITE... -Original Message- From: Dominic Watson [mailto:[EMAIL PROTECTED] Sent: Monday, April 21, 2008 12:24 PM To: CF-Talk Subject: Re: URL re-write SEO friendly I have used ISAPI_Rewrite for IIS, excellent and only $99 per server. http://www.isapirewrite.com/ You'll probably need help setting up the regex rules and the like - but help is always at hand it seems (not from me tho) 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:303905 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Reading sessiontimeout dynamically
Hey thanks Barney. Good stuff. Even if I don't find what I'm looking for in there, I'm sure I'll find something useful! ..:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Monday, April 21, 2008 2:01 PM To: CF-Talk Subject: Re: Reading sessiontimeout dynamically You can read the request timeout from the internal Java singletons underlying CF: http://www.barneyb.com/barneyblog/2007/08/17/requestmonitorgetrequesttimeout / I'd imagine that reading the session timeout would be similarly accomplished, though you'd need to find the session monitor, not the request monitor. cheers, barneyb On Mon, Apr 21, 2008 at 10:37 AM, Bobby Hartsfield [EMAIL PROTECTED] wrote: Does anyone know of a way (or if it's even possible) to programmatically read the sessiontimeout value of a CF app? ..:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.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:303906 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Embedded YouTube movies
Also, don't forget to escape/replace the tag parameter double quotes with single quotes. Example: object width=425 into object width='425' ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303907 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfquery and mysql help
You could try something like cfquery name=combined dbtype=query SELECT firstName, lastName FROM query1 WHERE NOT EXISTS ( SELECT firstName, lastName FROM query2 WHERE firstName = query1.firstName AND lastName = query1.lastName ) /cfquery No guarantees - this is standard SQL and would work with MySQL, but I'm not sure it will work with a query-of-queries. Matt hi andy query 1 has 2 columns firstName and lastName then i want to query the database to ensure that each firstName and lastName combination exists in the database, if not then i want it to return me a list of those that dont. i have achieved this through a loop but i am thinking there must be a quicker way of doing this directly in a cfquery, as it is taking too long when there are thousands of names it has to check 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:303908 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Embedded YouTube movies
Just curious but why? ..:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Mike Francisco [mailto:[EMAIL PROTECTED] Sent: Monday, April 21, 2008 2:25 PM To: CF-Talk Subject: RE: Embedded YouTube movies Also, don't forget to escape/replace the tag parameter double quotes with single quotes. Example: object width=425 into object width='425' ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303909 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Proxy Authentication with Oracle - Does ColdFusion Support th is?
But isn't that what the OP wanted? The ability to have auditing based on user authentication over the datasource and the session it creates (not just as a login to a table)? Wouldn't a datasource created at the J2EE server behave the same way? I would assume that the ASP pool would work the same way. I'd be curious to see how it would run under load testing. Matthew Williams Geodesic GraFX www.geodesicgrafx.com/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:303911 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Strange Behavior - stumped
working fine here .. IE and FF -Original Message- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: 16 April 2008 22:39 To: CF-Talk Subject: RE: Strange Behavior - stumped Nevermind. Must have been a server restart. It works fine for me now. IE 7, 4:38 pm. ~Brad -Original Message- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 16, 2008 4:36 PM To: CF-Talk Subject: RE: Strange Behavior - stumped I get a 500 servlet error. 4:35 pm CST ~Brad ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303912 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Proxy Authentication with Oracle - Does ColdFusion Support th is?
But isn't that what the OP wanted? The ability to have auditing based on user authentication over the datasource and the session it creates (not just as a login to a table)? Wouldn't a datasource created at the J2EE server behave the same way? I would assume that the ASP pool would work the same way. I'd be curious to see how it would run under load testing. No, the OP wanted to use proxy authentication, which would let you have a single connection pool with a single username and password, but would also let you track the Oracle account using a specific connection from that pool by its own specific username and password. This is an Oracle-specific feature, which requires manipulation of the connection string at runtime to include the proxy authentication attributes. 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:303913 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Embedded YouTube movies
Ooops, my bad... I did not read the original problem correctly. -Original Message- From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] Sent: Monday, April 21, 2008 11:34 AM To: CF-Talk Subject: RE: Embedded YouTube movies Just curious but why? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303914 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Strange Behavior - stumped
On some browser this page shows up fine, on other the page is garbled. Can you see this page ok? No problems here: IE7 FF2 Windows XP Pro, SP2 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:303915 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: URL re-write SEO friendly
I confess to not having a clue as to what is going on here.. A pop culture inside joke is my best guess :) Mark -Original Message- From: Dominic Watson [mailto:[EMAIL PROTECTED] Sent: Monday, April 21, 2008 1:03 PM To: CF-Talk Subject: Re: URL re-write SEO friendly Sometimes - very often, actually - that is the correct response. ;) agreed, but when written in that way the subtext is very obviously just 'fool', especially the second one (used all the time). 'Why don't you just...' can usually be replaced with 'This is how... and look this up in google to find out why / more (or some such)'. 'Why would you want to do that?!' can usually be replaced with 'If you're doing [x] I'd advise against it because... consider doing [y] instead'. Anyways, now I'm the one wasting bandwidth! Dom -- 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:303916 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Embedded YouTube movies
You can't just put the browser URL in... the Flash Movie needs a slightly different URL, thus the string manipulation shown above. Mik I am using the code provided by youtube: object width=425 height=355param name=movie value=http://www.youtube.com/v/61_UIFQHLv8hl=enrel=0;/paramparam name=wmode value=transparent/paramembed src=http://www.youtube.com/v/61_UIFQHLv8hl=enrel=0; type=application/x-shockwave-flash wmode=transparent width=425 height=355/embed/object ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303917 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Embedded YouTube movies
On Mon, Apr 21, 2008 at 10:35 AM, Torrent Girl [EMAIL PROTECTED] wrote: Hi All. I would like to allow site visitors to post a link to their youtube video to a database and then I output the link as a variable. It is not working. Has any successfully done this before? See my code below. The links for embedding a youtube video and viewing the page for that video are different. If your users are putting in the URL that links to the main video page, it will not work...you will need to parse out the unique id for that video, and then use the correct URL... The main video link looks something like... http://www.youtube.com/watch?v=eBGIQ7ZuuiU; The embedding video link looks something like... http://www.youtube. com/v/eBGIQ7ZuuiU Is that all of your code? If not would you mind posting it all. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303910 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Embedded YouTube movies
Plz send me teh codez -Original Message- From: Torrent Girl [mailto:[EMAIL PROTECTED] Sent: Monday, April 21, 2008 1:35 PM To: CF-Talk Subject: Re: Embedded YouTube movies On Mon, Apr 21, 2008 at 10:35 AM, Torrent Girl [EMAIL PROTECTED] wrote: Hi All. I would like to allow site visitors to post a link to their youtube video to a database and then I output the link as a variable. It is not working. Has any successfully done this before? See my code below. The links for embedding a youtube video and viewing the page for that video are different. If your users are putting in the URL that links to the main video page, it will not work...you will need to parse out the unique id for that video, and then use the correct URL... The main video link looks something like... http://www.youtube.com/watch?v=eBGIQ7ZuuiU; The embedding video link looks something like... http://www.youtube. com/v/eBGIQ7ZuuiU Is that all of your code? If not would you mind posting it all. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303918 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Embedded YouTube movies
Please do my work for me...again. On Mon, Apr 21, 2008 at 2:10 PM, Steve Brownlee [EMAIL PROTECTED] wrote: Plz send me teh codez -Original Message- From: Torrent Girl [mailto:[EMAIL PROTECTED] Sent: Monday, April 21, 2008 1:35 PM To: CF-Talk Subject: Re: Embedded YouTube movies On Mon, Apr 21, 2008 at 10:35 AM, Torrent Girl [EMAIL PROTECTED] wrote: Hi All. I would like to allow site visitors to post a link to their youtube video to a database and then I output the link as a variable. It is not working. Has any successfully done this before? See my code below. The links for embedding a youtube video and viewing the page for that video are different. If your users are putting in the URL that links to the main video page, it will not work...you will need to parse out the unique id for that video, and then use the correct URL... The main video link looks something like... http://www.youtube.com/watch?v=eBGIQ7ZuuiU; The embedding video link looks something like... http://www.youtube. com/v/eBGIQ7ZuuiU Is that all of your code? If not would you mind posting it all. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303919 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfquery and mysql help
thanks Matt, i will see if this works in query on query You could try something like cfquery name=combined dbtype=query SELECT firstName, lastName FROM query1 WHERE NOT EXISTS ( SELECT firstName, lastName FROM query2 WHERE firstName = query1.firstName AND lastName = query1.lastName ) /cfquery No guarantees - this is standard SQL and would work with MySQL, but I'm not sure it will work with a query-of-queries. Matt hi andy query 1 has 2 columns firstName and lastName then i want to query the database to ensure that each firstName and lastName combination exists in the database, if not then i want it to return me a list of those that dont. i have achieved this through a loop but i am thinking there must be a quicker way of doing this directly in a cfquery, as it is taking too long when there are thousands of names it has to check 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:303920 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Embedded YouTube movies
You have too much stuff in there. Lose the hl=enrel=0 embed src=http://www.youtube.com/v/fmACYY3_LXo; Mik At 03:02 PM 4/21/2008, Torrent Girl wrote: You can't just put the browser URL in... the Flash Movie needs a slightly different URL, thus the string manipulation shown above. Mik I am using the code provided by youtube: object width=425 height=355param name=movie value=http://www.youtube.com/v/61_UIFQHLv8hl=enrel=0;/paramparam name=wmode value=transparent/paramembed src=http://www.youtube.com/v/61_UIFQHLv8hl=enrel=0; type=application/x-shockwave-flash wmode=transparent width=425 height=355/embed/object ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303921 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Ajax: Who's into Ajax and Business Cases
Don: If you want to ask questions about AJAX, there are a vast number of other resources available to you. Each of the major libraries has their own message board or Google group. Here's some URLs to get you started... http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid=72catid =602 http://groups.google.com/group/jquery-en/ http://forum.mootools.net/ http://extjs.com/forum/ http://tech.groups.yahoo.com/group/ydn-javascript/ http://www.prototypejs.org/discuss Great, Steve, thank you very much. Don ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303923 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Embedded YouTube movies
On Mon, Apr 21, 2008 at 2:34 PM, Torrent Girl [EMAIL PROTECTED] wrote: Is that all of your code? If not would you mind posting it all. The code that I am using is very similar to the code you postedit just makes sure to use the correct URL. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303924 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Reading sessiontimeout dynamically
Thanks again barney, your suggestion lead me down the right path. I'm just
posting what I came up with for the sake of the archives.
The only place I could find to use getMaxInactiveInterval() was on an actual
node inside the returned structure of getSessionCollection().
I don't like the loop but it works. I don't guess I've ever had the need to
traverse a collection without a loop. Is it even possible to access the
nodes of a collection without looping over it? It would be nice to lose the
loop in this function:
cfscript
function getSessionTimeout(appName)
{
var i = 1;
var sessionTiemOutValue = 'Unkown';
var tracker =
createObject(java,coldfusion.runtime.SessionTracker);
var sessions = tracker.getSessionCollection(appName);
for (i in sessions){
sessionTimeoutValue =
sessions[i].getMaxInactiveInterval();
break;
}
return sessionTimeoutValue;
}
/cfscript
cfdump var=#getSessionTimeOut(application.applicationName)#
Cheers
..:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com
-Original Message-
From: Bobby Hartsfield [mailto:[EMAIL PROTECTED]
Sent: Monday, April 21, 2008 2:21 PM
To: CF-Talk
Subject: RE: Reading sessiontimeout dynamically
Hey thanks Barney. Good stuff. Even if I don't find what I'm looking for in
there, I'm sure I'll find something useful!
...:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com
-Original Message-
From: Barney Boisvert [mailto:[EMAIL PROTECTED]
Sent: Monday, April 21, 2008 2:01 PM
To: CF-Talk
Subject: Re: Reading sessiontimeout dynamically
You can read the request timeout from the internal Java singletons
underlying CF:
http://www.barneyb.com/barneyblog/2007/08/17/requestmonitorgetrequesttimeout
/
I'd imagine that reading the session timeout would be similarly
accomplished, though you'd need to find the session monitor, not the
request monitor.
cheers,
barneyb
On Mon, Apr 21, 2008 at 10:37 AM, Bobby Hartsfield
[EMAIL PROTECTED] wrote:
Does anyone know of a way (or if it's even possible) to programmatically
read the sessiontimeout value of a CF app?
..:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.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:303925
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
NEED HELP ASAP-meta.cfc
I am having to update the metadata(just the title) in a ton of documents. I am trying to use the meta.cfc and I keep getting an object instantiation error on line 158 of meta.cfc dsi = createobject(java, org.apache.poi.hpsf.DocumentSummaryInformation).init(ps); It works fine for pdf files. I installed the newer jar files for the poi and have restarted the server (quite a few times actually). I have NO idea what is going on here. Has anyone used this cfc before or have any idea of another way to update the metadata for pdf, doc, xls, ppt files? -Lori ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303926 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Grouping emails by domain
Anybody have any advice? Not looking for code samples, just advice on grouping email blasts by domain to minimize the number of SMTP connections. Would the CFMAIL GROUP attribute help? Should I loop over my userbase by top level domain and chunk it out that way? Mik At 03:37 PM 4/20/2008, Michael Muller wrote: I've been having trouble sending opt-in posts to a local university. They cite that each post on my website results in 250 unique smtp sessions to their mail server, and that they'd prefer one session per post. This is a reasonable request, and would probably help with Yahoo and AOL, as well as possibly even ease the burden on my mailserver. So, what would the best way be to accomplish this? How can I create a single email per domain and BCC all users there? Currently I run a query that pulls all the email addresses destined for delivery, and use the QUERY attribute of CFMAIL to deliver individual emails. Should I create a new field in the [USER] table that contains the TLD of each user's email address, and then either do a GROUP BY in my SQL query, or a GROUP in the CFMAIL tag on that column? If I do a query GROUP BY that'll essentially create a sub-list of email addresses to send BCC: within a single email. I think. If I do an email GROUP that'll ... hmmm... send everyone a mutiple-layered email based on the number of addresses at the grouped domain? ie; if there are ten people with an AOL.com address, and I used CFMAIL GROUP=tld then the resulting email will go TO: all AOL.com addresses, with a stacked email showing the same thing ten times? Any advice? Is there a better way? Mik - From LiveDocs: Group Optional CurrentRow Query column to use when you group sets of records to send as a message. For example, to send a set of billing statements to a customer, group on Customer_ID. Case-sensitive. Eliminates adjacent duplicates when data is sorted by the specified field. Michael Muller Muller Technologies 24 3rd Street Turners Falls, MA 01376 work: (413) 863-0030 cell: (413) 320-5336 skype: michaelBmuller http://support.MullerTech.com Information is not knowledge Knowlege is not wisdom Eschew Obfuscation ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303922 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Accessibility tools
Any thoughts on section 508 compliance tools? Pro's and Con's of tools used would be greatly appreciated! Thanks!!! -Lori ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303928 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Grouping emails by domain
Michael Muller wrote: I've been having trouble sending opt-in posts to a local university. They cite that each post on my website results in 250 unique smtp sessions to their mail server, and that they'd prefer one session per post. This is a reasonable request, and would probably help with Yahoo and AOL, as well as possibly even ease the burden on my mailserver. So, what would the best way be to accomplish this? Configure your mailserver to do this for you. Most mailservers allow you to tune their queuing so reduce the number of connections and increase the number of messages delivered over each connection. 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:303929 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: URL re-write SEO friendly
-Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Monday, April 21, 2008 12:14 PM To: CF-Talk Subject: RE: URL re-write SEO friendly Hi All, First off...the question was how to do it the way this SEO company is aksing. So let's clarify shall we --snipped-- So how does one go about doing this WITHOUT an Apache mod rewrite (as this is hosted on Windows for better or for worse) Don't let the fact that you're running on Windows keep you from enjoying the awesomeness that is Apache. 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:303927 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Reading sessiontimeout dynamically
Glad that got you going. You can ask for the key list of a structure
using structKeyList, and then just pull out the first key using
listFirst.
cheers,
barneyb
On Mon, Apr 21, 2008 at 12:42 PM, Bobby Hartsfield
[EMAIL PROTECTED] wrote:
Thanks again barney, your suggestion lead me down the right path. I'm just
posting what I came up with for the sake of the archives.
The only place I could find to use getMaxInactiveInterval() was on an actual
node inside the returned structure of getSessionCollection().
I don't like the loop but it works. I don't guess I've ever had the need to
traverse a collection without a loop. Is it even possible to access the
nodes of a collection without looping over it? It would be nice to lose the
loop in this function:
cfscript
function getSessionTimeout(appName)
{
var i = 1;
var sessionTiemOutValue = 'Unkown';
var tracker =
createObject(java,coldfusion.runtime.SessionTracker);
var sessions = tracker.getSessionCollection(appName);
for (i in sessions){
sessionTimeoutValue =
sessions[i].getMaxInactiveInterval();
break;
}
return sessionTimeoutValue;
}
/cfscript
cfdump var=#getSessionTimeOut(application.applicationName)#
Cheers
..:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
--
Barney Boisvert
[EMAIL PROTECTED]
http://www.barneyb.com/
Got Gmail? I have 100 invites.
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303930
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Reading sessiontimeout dynamically
Ha! Of course you can... *blush*
Thanks :-)
..:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com
-Original Message-
From: Barney Boisvert [mailto:[EMAIL PROTECTED]
Sent: Monday, April 21, 2008 4:38 PM
To: CF-Talk
Subject: Re: Reading sessiontimeout dynamically
Glad that got you going. You can ask for the key list of a structure
using structKeyList, and then just pull out the first key using
listFirst.
cheers,
barneyb
On Mon, Apr 21, 2008 at 12:42 PM, Bobby Hartsfield
[EMAIL PROTECTED] wrote:
Thanks again barney, your suggestion lead me down the right path. I'm just
posting what I came up with for the sake of the archives.
The only place I could find to use getMaxInactiveInterval() was on an
actual
node inside the returned structure of getSessionCollection().
I don't like the loop but it works. I don't guess I've ever had the need
to
traverse a collection without a loop. Is it even possible to access the
nodes of a collection without looping over it? It would be nice to lose
the
loop in this function:
cfscript
function getSessionTimeout(appName)
{
var i = 1;
var sessionTiemOutValue = 'Unkown';
var tracker =
createObject(java,coldfusion.runtime.SessionTracker);
var sessions = tracker.getSessionCollection(appName);
for (i in sessions){
sessionTimeoutValue =
sessions[i].getMaxInactiveInterval();
break;
}
return sessionTimeoutValue;
}
/cfscript
cfdump var=#getSessionTimeOut(application.applicationName)#
Cheers
..:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
--
Barney Boisvert
[EMAIL PROTECTED]
http://www.barneyb.com/
Got Gmail? I have 100 invites.
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303931
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: output column average using coldfusion
Use the AVG aggregate function. I think you really need to take a step back from what you're doing and spend some time learning basic SQL, because a huge number of the issues you've been posting about would be immediately solved if you had an understanding of joins and aggregate functions. There are literally thousands of web sites and books that will explain SQL so I'd start there. On Mon, Apr 21, 2008 at 10:00 AM, erik tom [EMAIL PROTECTED] wrote: I have to point out that this approach is terribly inefficient. Calculations like this should be in at the database level using SQL, that's exactly what it's supposed to do. Any time you're looping over queries to run more queries, or to total things up, it should be a big red flag, because in almost every situation the same thing can be done in SQL more easily and far more quickly. On Fri, Apr 18, 2008 at 3:36 PM, erik tom [EMAIL PROTECTED] wrote: How can i accomplish this ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303932 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Embedded YouTube movies
cffunction name=embedYouToobVideo access=public hint=EMbeds a youtube
video for lazy people
cfargument name=theurl required=true hint=Either the YouToob
page url or the actual video url /
cfargument name=width required=false default=425 hint=Width
of the video /
cfargument name=height required=false default=355
hint=Height of the video /
cfsavecontent variable=embedCode
object width=#val(arguments.width)#
height=#val(arguments.height)#
param name=movie value=#rereplace(arguments.theurl,
'\?|=', '/', 'all')#/param
param name=wmode value=transparent/param
embed src=#rereplace(arguments.theurl, '\?|=', '/',
'all')# type=application/x-shockwave-flash wmode=transparent
width=#val(arguments.width)# height=#val(arguments.height)#/embed
/object
/cfsavecontent
cfreturn embedCode /
/cffunction
#embedYouToobVideo('http://www.youtube.com/watch?v=0ONJfp95yoE')#br /
#embedYouToobVideo('http://www.youtube.com/watch/v/0ONJfp95yoE')#br /
#embedYouToobVideo('http://www.youtube.com/watch?v=0ONJfp95yoEfeature=relat
edhl=en')#br /
..:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.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:303933
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Reading data from a website
Good day, I have been tasked to get temperature data on a daily basis from a website. I thought that I had seen something about this from somewhere, but can't seem to put my finger on it, so, Is there a way that I can automatically get data from another website that is stored in a table, by calling a function...? I want to get two values from specific days. I would like to be able to take all the data that is stored in a table and put it into a structure then I can parse out what I need. so A) Is this possible? B) a Few pointers if you don't mind? Thanks, Rob ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303934 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Reading sessiontimeout dynamically
Here it is again without the loop just for the sake of archive searches.
cfscript
function getSessionTimeout(appName)
{
var i = 1;
var sessionTiemOutValue = 'Unkown';
var tracker =
createObject(java,coldfusion.runtime.SessionTracker);
var sessions = tracker.getSessionCollection(appName);
if (listlen(structKeyList(sessions)))
{
sessionTimeoutValue =
sessions[listFirst(structKeyList(sessions))].getMaxInactiveInterval();
}
return sessionTimeoutValue;
}
/cfscript
cfdump var=#getSessionTimeOut(application.applicationName)#
PS... The returned value is either 'Unkonw' or the number of seconds.
Thanks again for your input barney.
Cheers
..:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.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:303935
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Reading data from a website
I have been tasked to get temperature data on a daily basis from a website Good evening, This very much depends on a couple of factors: * If you own the application that is publishing the temperatures - You could create a webservice that other applications can access, - You could publish rss feeds that other applications can access * If you do not own the application that is publishing the temperatures: - If by table you mean HTML table, then it *should* be possible to parse the html and extract the data you need though this depends on the html source. Post a link and I'll let you know ;) - If by table you mean database table, then unless the application formally publishes the data through a feed or webservice then you won't be able to access it. 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:303936 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Reading data from a website
On Mon, Apr 21, 2008 at 1:57 PM, Rob Parkhill [EMAIL PROTECTED] wrote: Good day, I have been tasked to get temperature data on a daily basis from a website. I thought that I had seen something about this from somewhere, but can't seem to put my finger on it, so, Is there a way that I can automatically get data from another website that is stored in a table, by calling a function...? I want to get two values from specific days. I would like to be able to take all the data that is stored in a table and put it into a structure then I can parse out what I need. http://www.google.com/search?q=weather+webservice that'd be a place to start. find the web service that suits your needs. depending on which one you choose, there may even be docs available that show how to integrate it into your site. -- Evelyn the dog, having undergone further modification pondered the significance of short-person behaviour in pedal depressed, pan-chromatic resonance, and other highly ambient domains. Arf, she said. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303937 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Reading data from a website
I have been tasked to get temperature data on a daily basis from a website. I thought that I had seen something about this from somewhere, but can't seem to put my finger on it, so, Is there a way that I can automatically get data from another website that is stored in a table, by calling a function...? I want to get two values from specific days. I would like to be able to take all the data that is stored in a table and put it into a structure then I can parse out what I need. so A) Is this possible? B) a Few pointers if you don't mind? If the web site has a web service - a program you can call directly via a HTTP URL - then, yes, you can easily get whatever data that web service publishes. Web services typically publish data using XML, which is easily parsed. Otherwise, you will have to use CFHTTP to fetch the web page in question, and you will have to use string functions to parse out the bits you need, and the process of building and maintaining this functionality will suck, to put it bluntly. If the formatting of the web page changes later, you'll probably have to edit your code accordingly. This process is generally referred to as screen scraping. I would go for the web service approach. There are probably plenty of web sites that offer a daily temperature web service, although they might want you to pay for it. 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:303938 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Reading data from a website
http://tutorial451.easycfm.com/ :) On 4/21/08, Dave Watts [EMAIL PROTECTED] wrote: I have been tasked to get temperature data on a daily basis from a website. I thought that I had seen something about this from somewhere, but can't seem to put my finger on it, so, Is there a way that I can automatically get data from another website that is stored in a table, by calling a function...? I want to get two values from specific days. I would like to be able to take all the data that is stored in a table and put it into a structure then I can parse out what I need. so A) Is this possible? B) a Few pointers if you don't mind? If the web site has a web service - a program you can call directly via a HTTP URL - then, yes, you can easily get whatever data that web service publishes. Web services typically publish data using XML, which is easily parsed. Otherwise, you will have to use CFHTTP to fetch the web page in question, and you will have to use string functions to parse out the bits you need, and the process of building and maintaining this functionality will suck, to put it bluntly. If the formatting of the web page changes later, you'll probably have to edit your code accordingly. This process is generally referred to as screen scraping. I would go for the web service approach. There are probably plenty of web sites that offer a daily temperature web service, although they might want you to pay for it. 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:303939 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFLAYOUTAREA - Attaching an ONRESIZE event
Any ideas? I need to run some Javascript whenever the center cflayoutarea's size changes. This might be from: a) The browser window being resized b) An adjoining splitter is moved c) An adjoining sliding panel is collapsed It seems I should be able to attach an event to that center DIV. The window.resize event appears to fire only before the cflayout DIVs are redrawn, and not after, which is no help at all. Paul Cormier ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303940 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: URL re-write SEO friendly
Don't let the fact that you're running on Windows keep you from enjoying the awesomeness that is Apache. Russ Shared server Russ Cheers - Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303941 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
