re: Controlling the Number of Inputs with a Dropdown
You can do this all with JavaScript, it works really slick. I just did this a few weeks ago and wrote a blog post about it:http://www.stillnetstudios.com/2009/01/05/dynamically-adding-and-removing-form-elements/ Or you can go the route you are heading, where you ask for how many, then submit the form, then in CF loop through 1 to N, writing out form elements and naming them as you describe. (firstName_1, etc.). Also embed the "how many" number as a hidden element. Regardless of which method you use to setup the form, on the form processing page you look for that hidden "how many" number and loop 1 to it, processing elements along the way. Look in the comments of that blog post, there is a mention in there about how to do this form processing also. -Ryan From: Les Mizzell Sent: Friday, January 16, 2009 5:48 PM To: cf-talk Subject: Controlling the Number of Inputs with a Dropdown Basically, I'm looking how to do the below: In the middle of an existing form, there's a dropdown with 1 to 10 as possibe values. "How Many guests do you wish to bring?" If I select "5", I then need "firstNAME_1", "lastNAME_1" through "firstNAME_5", "lastNAME_5" input boxes to appear in place underneath. There's multiple places on the form where this needs to happen. I'm just getting started with Ajax and CF8, but don't even know exactly what I'm looking for to get this to happen and need a pointer in the right direction to figure this out. Been googling for a couple of hours, but haven't found the right place to start yet. Ideas please? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318123 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Writing xml
it should have a root element. you really dont use it but this is how you write. On Fri, Jan 16, 2009 at 7:28 PM, Les Irvin wrote: > I'm trying to have CF write a painfully simple xml file, basically > just a list of sequentially numbered image tags. I keep getting this > error: > "The markup in the document following the root element must be > well-formed." > Can anyone help? > Thanks, > Les > > > > > > > > > > > > output="#ToString(GalDoc)#"> > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318122 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Writing xml
You don't have a root element in your XML document. The output will be something like this: XML documents can only have a single top-level tag, so you'll need to wrap your tags with a container of some sort. cheers, barneyb On Fri, Jan 16, 2009 at 4:28 PM, Les Irvin wrote: > I'm trying to have CF write a painfully simple xml file, basically > just a list of sequentially numbered image tags. I keep getting this > error: > "The markup in the document following the root element must be well-formed." > Can anyone help? > Thanks, > Les > > > > > > > > > > > > output="#ToString(GalDoc)#"> > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318121 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Writing xml
I'm trying to have CF write a painfully simple xml file, basically just a list of sequentially numbered image tags. I keep getting this error: "The markup in the document following the root element must be well-formed." Can anyone help? Thanks, Les ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318120 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Creating Web Connector to QuickBooks
On Sun, Jan 4, 2009 at 11:36 AM, Andy wrote: > Updating my wife's business from Peachtree to QB. Have any of you written a > Web Connector for QB? They use SOAP. Are they examples out there that I > can use to short-cut the development? I've had a lot of fun compiling the WSDL into a jar and then just calling classes from it using a classloader. You can do the whole deal from within CF, and I think there's a way to just have it keep what it compiles when it does the webservice, although I was too nutty to use some existing solution. Plus, I already had a compiler, a jar-er, and calling the generator class was as easy as... well, calling the generator class. I can do up a little blog entry on it, but it would probably be better to use the existing methods of saving/using the java classes... but I didn't see any info on that anywhere, really ('sides a couple of comments on this list). Anyways, long story short, I've really enjoyed using the generated classes vs. using cfinvoke and whatnot. YMMV, etc.. -- Choose the life that is most useful, and habit will make it the most agreeable. Francis Bacon ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318119 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Controlling the Number of Inputs with a Dropdown
Basically, I'm looking how to do the below: In the middle of an existing form, there's a dropdown with 1 to 10 as possibe values. "How Many guests do you wish to bring?" If I select "5", I then need "firstNAME_1", "lastNAME_1" through "firstNAME_5", "lastNAME_5" input boxes to appear in place underneath. There's multiple places on the form where this needs to happen. I'm just getting started with Ajax and CF8, but don't even know exactly what I'm looking for to get this to happen and need a pointer in the right direction to figure this out. Been googling for a couple of hours, but haven't found the right place to start yet. Ideas please? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318118 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SOT Oracle query OR problem
>SELECT passport_attendance_id >FROM passport_attendance >WHERE > >people_id = cfsqltype="CF_SQL_INTEGER"> > >student_id = cfsqltype="CF_SQL_INTEGER"> > > > >Last one did not work because syntax should be "IS NULL" not "= NULL" That one worked fine and is very straight-forward. Makes total sense. thank you very much and have a good weekend. daniel ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318117 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: (OT) - DNS misbehavior?
> I have a host(a) record called 'report' that points to an internal IP > address corresponding to the intranet server. Server software is Windows > Server 2003. The web browser on the thin client (Win Xpe) points to > http://report and that occasionally sends them to the public website. If you only have the one machine, just add the appropriate entry to the hosts file. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318116 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: (OT) - DNS misbehavior?
I have a host(a) record called 'report' that points to an internal IP address corresponding to the intranet server. Server software is Windows Server 2003. The web browser on the thin client (Win Xpe) points to http://report and that occasionally sends them to the public website. -Original Message- From: Ben Conner [mailto:b...@webworldinc.com] Sent: Friday, January 16, 2009 4:31 PM To: cf-talk Subject: Re: (OT) - DNS misbehavior? Hi Billy, Are the two sites pointing to the same IP address or different ones? The first thing you need to narrow down is whether the problem is a DNS issue, a web server issue, or a thin client issue. What type of server software are the two sites on? Are they assigned to specific IP addresses, or also using the domain header included in the HTTP request? --Ben Billy Cox wrote: > I have an intranet server named 'report' that serves up an app to a > touchscreen thin client. Every now and then a user on the thin client > will put in the address for the intranet app, but get our public > website instead. I have them restart the thin client and then all is > well. I'm assuming this is a DNS issue, but I haven't been able to > track down the root cause. > > What would cause this and how do I fix it? I'm mainly a programmer so > I'm learning network admin as needed. > > > Thanks, > > Billy Cox > Old World Spices > bi...@oldworldspices.com > > > > > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318115 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: (OT) - DNS misbehavior?
Hi Billy, Are the two sites pointing to the same IP address or different ones? The first thing you need to narrow down is whether the problem is a DNS issue, a web server issue, or a thin client issue. What type of server software are the two sites on? Are they assigned to specific IP addresses, or also using the domain header included in the HTTP request? --Ben Billy Cox wrote: > I have an intranet server named 'report' that serves up an app to a > touchscreen thin client. Every now and then a user on the thin client will > put in the address for the intranet app, but get our public website instead. > I have them restart the thin client and then all is well. I'm assuming this > is a DNS issue, but I haven't been able to track down the root cause. > > What would cause this and how do I fix it? I'm mainly a programmer so I'm > learning network admin as needed. > > > Thanks, > > Billy Cox > Old World Spices > bi...@oldworldspices.com > > > > > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318114 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SOT Oracle query OR problem
Oops. Try this: SELECT passport_attendance_id FROM passport_attendance WHERE people_id = student_id = Last one did not work because syntax should be "IS NULL" not "= NULL" On Fri, Jan 16, 2009 at 4:14 PM, daniel kessler wrote: > > > >SELECT passport_attendance_id > >FROM passport_attendance > >WHERE student_id = >value="#passport_registration.student_id[pr]#" cfsqltype="CF_SQL_INTEGER" > >null="#YesNoFormat(passport_registration.student_id[pr] is '')#"> > >OR people_id = >cfsqltype="CF_SQL_INTEGER" > >null="#YesNoFormat(passport_registration.people_id[pr] is '')#"> > > > > That's interesting. I believe that I understand it fine. However, I am > still getting an error. Here's the whole error: > > Query Of Queries syntax error. > Encountered "student_id = NULL. Incorrect conditional expression, Expected > one of [like|null|between|in|comparison] condition, > > The error occurred in /afs/. > glue.umd.edu/department/oit/eis/webhosting/sph/htdocs/home/passport/attendance/attendance2.cfm: > line 129 > 127 : student_id = value="#passport_registration.student_id[pr]#" cfsqltype="CF_SQL_INTEGER" > null="#YesNoFormat(passport_registration.student_id[pr] is '')#"> > 128 : OR > 129 : people_id = value="#passport_registration.people_id[pr]#"cfsqltype="CF_SQL_INTEGER"null="#YesNoFormat(passport_registration.people_id[pr] > is '')#"> > 130 : > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318113 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFWINDOW location coordinates question
Yep, just capture the mouse clicks page X, Y: function makeWin(x,y) { ColdFusion.Window.create('mywin','Windows Rules','win.cfm',{x:x,y:y}); } Content to push stuff down More content to push stuff down the page vertically... This is the test link. On Fri, Jan 16, 2009 at 1:07 PM, Les Mizzell wrote: > One more CFWINDOW question... > > If it possible to specify the coordinates where the window appears in > relation to the link that opened the window, and not the browser upper > left window? > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318112 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SOT Oracle query OR problem
> >SELECT passport_attendance_id >FROM passport_attendance >WHERE student_id = value="#passport_registration.student_id[pr]#" cfsqltype="CF_SQL_INTEGER" >null="#YesNoFormat(passport_registration.student_id[pr] is '')#"> >OR people_id = cfsqltype="CF_SQL_INTEGER" >null="#YesNoFormat(passport_registration.people_id[pr] is '')#"> > That's interesting. I believe that I understand it fine. However, I am still getting an error. Here's the whole error: Query Of Queries syntax error. Encountered "student_id = NULL. Incorrect conditional expression, Expected one of [like|null|between|in|comparison] condition, The error occurred in /afs/.glue.umd.edu/department/oit/eis/webhosting/sph/htdocs/home/passport/attendance/attendance2.cfm: line 129 127 : student_id = 128 : OR 129 : people_id = 130 : ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318111 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: (OT) - DNS misbehavior?
What are the respective URLs? Are they different domains? Is one just a sub-domain? ~Brad Original Message Subject: (OT) - DNS misbehavior? From: "Billy Cox" Date: Fri, January 16, 2009 3:50 pm To: cf-talk I have an intranet server named 'report' that serves up an app to a touchscreen thin client. Every now and then a user on the thin client will put in the address for the intranet app, but get our public website instead. I have them restart the thin client and then all is well. I'm assuming this is a DNS issue, but I haven't been able to track down the root cause. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318110 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
(OT) - DNS misbehavior?
I have an intranet server named 'report' that serves up an app to a touchscreen thin client. Every now and then a user on the thin client will put in the address for the intranet app, but get our public website instead. I have them restart the thin client and then all is well. I'm assuming this is a DNS issue, but I haven't been able to track down the root cause. What would cause this and how do I fix it? I'm mainly a programmer so I'm learning network admin as needed. Thanks, Billy Cox Old World Spices bi...@oldworldspices.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318109 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Optimal version of java for CF8?
Well I just upgraded the JVM on a few of our servers and saw some really nice speed improvements. Upto 20% in some cases. Win 2k3 32 bit. Paul Kukiel http://blog.kukiel.net/2009/01/coldfusion-and-jvm-16011.html On Fri, Jan 16, 2009 at 2:29 PM, Judah McAuley wrote: > I cant' seem to find the current recommendation on java version for > CF8. I just installed 8.0.1 and it is using 1.6.0_04 The machine I'm > running it on is 32-bit W2K3 and has 1.6.0_11-b03 installed (from > Sun). Any good reason to point CF8 at the machine-installed version > instead of the one included with JRun? Any good reason not to? > > Thanks > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318108 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: webservice failure in cf 8
Wonderful. Thanks > >I have a client site that was working great. The machine got a worm > and the > >CF was reinstalled as CF 8.01. Now the webservice on the site fails > with an > >error of: > >java.lang.ClassNotFoundException: _.redirect.RemotenumbersService > > > >The webservice is: > >http://sitename/remote. > cfc?wsdl" > >name="ws" refreshwsdl="Yes"> > > > >Anyone ever see this or know what's up? > >Thanks > > > Sounds like the generated class files got whacked.. > > clean them up by deleting in webapps/cfusion/web-inf/cfusion/stubs > then the next time the page is run the ws stubs will be recreated. > > Sam ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318107 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Error CFUPDATE using formfields parameter
Would probably help if you could post some abbreviated code. Make sure the attribute is set as "formfields" (note it's plural). If the attribute is "formfield" (singular), it will be ignored, and will attempt to update with whatever it finds in the form collection. Note that the table's primary key must be included in the formfields list, and must be passed in the form collection (it can be hidden). Cheers, Kris >> Error CFUPDATE using formfields parameter. I have a CFM page for >> sending a form with 7 input type fields. The action page update a >> table with 3 columns by CFUPDATE. CFMX 8.0.1 send me next error: >> >> The NAMEORG fieldname cannot be found in the ait table >> >> The form field NAMEORG is in the FORM, but it is not in the table, nor >> in CFUPDATE formfield parameter. > > Sorry, let me clarify, the fieldname NAMEORG is not part of the database, i > sent by submit in FORM for other operations, but CFUPDATE is trying to use it > as a formfield parameter ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318106 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SOT Oracle query OR problem
SELECT passport_attendance_id FROM passport_attendance WHERE student_id = OR people_id = On Fri, Jan 16, 2009 at 2:13 PM, daniel kessler wrote: > I'm doing this query in Oracle and am encountering the error: > > Encountered "student_id = OR. Incorrect conditional expression, Expected > one of [like|null|between|in|comparison] condition, > > > SELECT passport_attendance_id > FROM passport_attendance > WHERE student_id = #passport_registration.student_id[pr]# > OR people_id = #passport_registration.people_id[pr]# > > > The problem appears to be that sometimes > passport_registration.student_id[pr] is empty. It's a numeric, so when I > wrapped it in quotes, it didn't like that either cause it was comparing > different types. > > How do I handle that sort of situation? One of the two is always gonna be > empty. > > daniel > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318105 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Error CFUPDATE using formfields parameter
> Error CFUPDATE using formfields parameter. I have a CFM page for > sending a form with 7 input type fields. The action page update a > table with 3 columns by CFUPDATE. CFMX 8.0.1 send me next error: > > The NAMEORG fieldname cannot be found in the ait table > > The form field NAMEORG is in the FORM, but it is not in the table, nor > in CFUPDATE formfield parameter. Sorry, let me clarify, the fieldname NAMEORG is not part of the database, i sent by submit in FORM for other operations, but CFUPDATE is trying to use it as a formfield parameter ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318104 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
SOT Oracle query OR problem
I'm doing this query in Oracle and am encountering the error: Encountered "student_id = OR. Incorrect conditional expression, Expected one of [like|null|between|in|comparison] condition, SELECT passport_attendance_id FROM passport_attendance WHERE student_id = #passport_registration.student_id[pr]# OR people_id = #passport_registration.people_id[pr]# The problem appears to be that sometimes passport_registration.student_id[pr] is empty. It's a numeric, so when I wrapped it in quotes, it didn't like that either cause it was comparing different types. How do I handle that sort of situation? One of the two is always gonna be empty. daniel ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318103 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Dynamically set required attribute in cfform flash field
I have a cfform flash in an application. I want to be able to set the required="yes" on a form field after a user checks the checkbox above it. SO for example, if the user checks the "I have my keys" box, then the "keydate" form field becomes required. I've tried it the same way for the enable attribute, but I get error that required attribute is not boolean like the enable attribute. (enabled="{haskeys.selected ? true : false}"). I was using this for enable the field, but then I wasn't sure how to use this code if the form is being prepopulated from a query and the checkbox is already checked? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318102 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Optimal version of java for CF8?
> I personally like install the JVM I am using under my CF install/bin > directory. That's mostly because I don't trust some automatic Windows > or Sun update to jack with it. You don't have to worry about that. JDK installs are not updated automatically by anything. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318101 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Optimal version of java for CF8?
To be fair, here is Adobe's list of supported JVM's. http://www.adobe.com/products/coldfusion/pdfs/cf8_systemsupportmatrix.pdf Technically, updater 10 isn't on the list, but it wasn't released when CF8 came out. I'm not sure if Adobe has made any official addendums to the interoperability. I guess it could be safe to say, In general I wouldn't bother changing your JVM unless you are experiencing a specific problem with it. The two times I have ever bothered to change it was when the daylight savings times changed (required Sun change to Java), and to avoid the class loader bug in 1.6. ~Brad Original Message Subject: RE: Optimal version of java for CF8? From: b...@bradwood.com Date: Fri, January 16, 2009 1:41 pm To: cf-talk In general, you want to make sure you are using an Adobe-approved JVM for that version of CF. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318100 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Optimal version of java for CF8?
In general, you want to make sure you are using an Adobe-approved JVM for that version of CF. In your case, I would recommend using at least updater 10 due to the class loader bug fixes. (The updater, is the number immediately after the underscore) I personally like install the JVM I am using under my CF install/bin directory. That's mostly because I don't trust some automatic Windows or Sun update to jack with it. ~Brad Original Message Subject: Optimal version of java for CF8? From: Judah McAuley Date: Fri, January 16, 2009 1:29 pm To: cf-talk I cant' seem to find the current recommendation on java version for CF8. I just installed 8.0.1 and it is using 1.6.0_04 The machine I'm running it on is 32-bit W2K3 and has 1.6.0_11-b03 installed (from Sun). Any good reason to point CF8 at the machine-installed version instead of the one included with JRun? Any good reason not to? Thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318099 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Optimal version of java for CF8?
I cant' seem to find the current recommendation on java version for CF8. I just installed 8.0.1 and it is using 1.6.0_04 The machine I'm running it on is 32-bit W2K3 and has 1.6.0_11-b03 installed (from Sun). Any good reason to point CF8 at the machine-installed version instead of the one included with JRun? Any good reason not to? Thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318098 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CFWINDOW location coordinates question
One more CFWINDOW question... If it possible to specify the coordinates where the window appears in relation to the link that opened the window, and not the browser upper left window? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318097 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Coldfusion + FFmpeg
INSERT INTO dbo.video (video) VALUES ('#VideoFileName#') Ok so uploads then takes that file and then converts it. Im then trying to insert the name into the db. Well kinda. Suggestions on cleaning up the code? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318096 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: webservice failure in cf 8
>I have a client site that was working great. The machine got a worm and the >CF was reinstalled as CF 8.01. Now the webservice on the site fails with an >error of: >java.lang.ClassNotFoundException: _.redirect.RemotenumbersService > >The webservice is: >http://sitename/remote.cfc?wsdl"; >name="ws" refreshwsdl="Yes"> > >Anyone ever see this or know what's up? >Thanks > Sounds like the generated class files got whacked.. clean them up by deleting in webapps/cfusion/web-inf/cfusion/stubs then the next time the page is run the ws stubs will be recreated. Sam ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318095 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Error CFUPDATE using formfields parameter
Error CFUPDATE using formfields parameter. I have a CFM page for sending a form with 7 input type fields. The action page update a table with 3 columns by CFUPDATE. CFMX 8.0.1 send me next error: The NAMEORG fieldname cannot be found in the ait table The form field NAMEORG is in the FORM, but it is not in the table, nor in CFUPDATE formfield parameter. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318094 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Recognizing spyders
Of course. All I meant was that my apps are all behind a login and have a smaller number of users than a public facing web app that could be spidered would. Demands on sessions and web server resources are just different for the different types of apps. Judah On Fri, Jan 16, 2009 at 8:48 AM, Cutter (CFRelated) wrote: > We track backend user activity as well, to see which apps are getting > the most usage, which helps us target priority areas and allows us to > customize user experience. > > Steve "Cutter" Blades > Adobe Certified Professional > Advanced Macromedia ColdFusion MX 7 Developer > > Co-Author of "Learning Ext JS" > http://www.packtpub.com/learning-ext-js/book > _ > http://blog.cutterscrossing.com > > Judah McAuley wrote: >> That's the sort of thing I was thinking of. I've always done that sort >> of thing via cookies with a db recording page atctivity until the user >> logs in. And, obviously, you could make a user id part of the cookie >> so as to track individual user behavior even prior to a login. Just >> cuts down on the number of sessions created. I like the idea of >> transient 2-second sessions though for bots. I'll have to give the >> topic some more though next time I create a site of that sort. These >> days I'm doing mostly back end business programming so session >> creation overhead isn't an issue. Good topic to think on anyway. >> >> Cheers, >> Judah >> >> On Fri, Jan 16, 2009 at 6:09 AM, Cutter (CFRelated) >> wrote: >>> We maintain sessions for a variety of reasons. Our sites contain >>> multiple user facing applications, typically dealing with product detail >>> or directly reviewing client inventory. Sessions are used to track a >>> site user's full path through a site. Page views, lead submissions, app >>> level review (some of our front-end apps are Flash based). So, we get >>> full activity reporting, plus are able to differentiate (in our stats >>> review) multiple site sessions by the same user, seeing if return >>> sessions might be more productive, and tying together the session's >>> activity for complete user action overview. >>> >>> Steve "Cutter" Blades >>> Adobe Certified Professional >>> Advanced Macromedia ColdFusion MX 7 Developer >>> >>> Co-Author of "Learning Ext JS" >>> http://www.packtpub.com/learning-ext-js/book >>> _ >>> http://blog.cutterscrossing.com >>> >>> Judah McAuley wrote: Out of curiosity, what are the primary business objectives for maintaining session on pages that are not user-specific? I typically have divided my site into two parts, a public part that doesn't maintain session and then an area behind a login form. Once you have logged in and identified yourself as a user, I keep track of the user through the whole site, public and private. But I don't generally see a need to maintain session info for a visitor unless they have done something user-specific, which would require a login. That eliminates bots right there. Judah On Thu, Jan 15, 2009 at 8:43 PM, Cutter (CFRelated) wrote: > We found this post from Ben Nadel to be extremely helpful in detecting > bot traffic. We have a highly customized statistical tracking system in > place for our web traffic, and wanted to accomplish two primary > objectives: a) not record page views of bots, and b) not maintain a > separate session on every page view (this is accomplished by identifying > the visit as a bot and setting the session timeout to 2 sec). We have > found Ben's work here to be highly effective. > > http://www.bennadel.com/blog/1083-ColdFusion-Session-Management-And-Spiders-Bots.htm > > Steve "Cutter" Blades > Adobe Certified Professional > Advanced Macromedia ColdFusion MX 7 Developer > > Co-Author of "Learning Ext JS" > http://www.packtpub.com/learning-ext-js/book > _ > http://blog.cutterscrossing.com > > Jim McAtee wrote: >> We keep our own page view stats in a database and want to avoid counting >> page views by visiting spyders. What's a good method for recognizing >> spyders without throwing away valid visitor page views? >> >> Something using cgi.user_agent, no doubt, but how can we keep a fairly >> comprehensive list up to date, and do we try to do exact string matches, >> partial matches, or what? >> >> >> >>> >> >> > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318093 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Using Ray's RSS.cfc and getting invalid feed
Just keep in mind that CFFEED has a few... um... issues. Search my blog for cffeed and you will see me ranting a bit. On Fri, Jan 16, 2009 at 11:33 AM, Andy Matthews wrote: > Sure enough it does, and it was super easy to convert over to cffeed. Thanks > for the tip Ray! > > -Original Message- > From: Andy Matthews [mailto:li...@commadelimited.com] > Sent: Friday, January 16, 2009 11:16 AM > To: cf-talk > Subject: RE: Using Ray's RSS.cfc and getting invalid feed > > Yep... > -- === Raymond Camden, VP of Software Dev, Broadchoice Email: r...@camdenfamily.com Blog : www.coldfusionjedi.com AOL IM : cfjedimaster Keep up to date with the community: http://www.coldfusionbloggers.org ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318092 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
webservice failure in cf 8
I have a client site that was working great. The machine got a worm and the CF was reinstalled as CF 8.01. Now the webservice on the site fails with an error of: java.lang.ClassNotFoundException: _.redirect.RemotenumbersService The webservice is: http://sitename/remote.cfc?wsdl"; name="ws" refreshwsdl="Yes"> Anyone ever see this or know what's up? Thanks If I don't reply to a reply with my thanks its because I'm running to pick up Judith and the new baby before Shabbos. One day old and home. Fun!! :) -- Michael Dinowitz (http://www.linkedin.com/in/mdinowitz) President: House of Fusion(http://www.houseoffusion.com) Publisher: Fusion Authority(http://www.fusionauthority.com) Adobe Community Expert / Advanced Certified ColdFusion Professional Si, soy el senor "chico malo" para todos ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318091 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Coldfusion + FFmpeg
Start at the beginning by doing the upload. Then write a function that takes the path to the file you wish to convert a path for the newly converted file to be saved. Just because the first example has the file name hardcoded, doesn't mean you can't just replace it with a variable. Don't combine the process of upload with the process of converting, do two bits of code and then use them together. I've been all over ffmpeg for the last few months so shout back with any more questions. I'm no expert (have a look at FFmpeg-user for people that know a ton about it) but I like to get stuck in :O) Adrian > -Original Message- > From: Sin Tec [mailto:tooles...@gmail.com] > Sent: 16 January 2009 17:36 > To: cf-talk > Subject: Coldfusion + FFmpeg > > I am trying to set up a kinda on the fly page for converting video to > flash via coldfusion and ffmpeg. > > cfsearch has a cfexacute that converts the video but you have to put > the file name in the code. > http://cfsearching.blogspot.com/2008/01/cfexecute-ffmpeg-and-mencoder- > mystery.html > > name="c:\winnt\system32\cmd.exe" arguments="#argString#" > outputFile="d:\bin\results14.log" timeout="120" /> > > > > > - > > This blog has kinda the same thing but it doesnt work as well as well > at converting as cfsearch but has it to where you can use a upload > page. > http://johnfallen.instantspot.com/blog/YouTube > > enctype="multipart/form-data"> > VideoFile (best to keep under 100 meg) sad > ... :( > > > > > displayname="Upload Video" access="public" returntype="any" > output="false"> > > > > > > action="upload" > destination = "[your directory for origional video here]" > nameconflict="overwrite" > filefield="VideoFile" /> > > arguments = "-i [your directory here]#cffile.SERVERFILE# -s > 400x300 -r 15 -b 1280k -ar 44100 -ab 64 -ac 2 [your directory for > converted video here]#replace(cffile.SERVERFILE, ".", "")#.flv" > outputFile = "C:\" > timeout = "9000"> > > > /> > > > > --- > > I am trying to combine the two to get something where I can use a > upload page and then send the file name to the database so it can be > called later on a page. > > This is alittle over my head but am trying my best to figure it out and > learning alot as I do it but still need somehelp. When done will save > me a bunch of time on my vblog and not have to use Youtube or something > like that. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318090 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Coldfusion + FFmpeg
I am trying to set up a kinda on the fly page for converting video to flash via coldfusion and ffmpeg. cfsearch has a cfexacute that converts the video but you have to put the file name in the code. http://cfsearching.blogspot.com/2008/01/cfexecute-ffmpeg-and-mencoder-mystery.html - This blog has kinda the same thing but it doesnt work as well as well at converting as cfsearch but has it to where you can use a upload page. http://johnfallen.instantspot.com/blog/YouTube VideoFile (best to keep under 100 meg) sad ... :( --- I am trying to combine the two to get something where I can use a upload page and then send the file name to the database so it can be called later on a page. This is alittle over my head but am trying my best to figure it out and learning alot as I do it but still need somehelp. When done will save me a bunch of time on my vblog and not have to use Youtube or something like that. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318089 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Using Ray's RSS.cfc and getting invalid feed
Sure enough it does, and it was super easy to convert over to cffeed. Thanks for the tip Ray! -Original Message- From: Andy Matthews [mailto:li...@commadelimited.com] Sent: Friday, January 16, 2009 11:16 AM To: cf-talk Subject: RE: Using Ray's RSS.cfc and getting invalid feed Yep... I ended up pasting the post in question into EditPlus and saw the problem immediately. I have no clue where that character came from. Thanks all. Ray, I'll look into using cffeed, I thought it was only for reading in feeds, not generating them. Thanks for the pointer. -Original Message- From: Raymond Camden [mailto:rcam...@gmail.com] Sent: Friday, January 16, 2009 11:07 AM To: cf-talk Subject: Re: Using Ray's RSS.cfc and getting invalid feed Ah yep, that's the issue:Who's the guy who got tboned? What happened to his daughter? ... See the crap after &apos? rss.cfc tries to clean input as much as possible, but it missed this one. Just edit and remove the bad char. On Fri, Jan 16, 2009 at 10:32 AM, Andy Matthews wrote: > I'm in the process of finalizing my blog and working on setting up the > RSS > feed: > > http://www.andymatthews.net/rss/ > > I'm getting an error when I try to validate the feed: > http://feedvalidator.org/check.cgi?url=http://www.andymatthews.net/rss > / > > I've gone through and added cdata nodes where applicable but that > doesn't seem to be helping. Anyone have any idea what's wrong? > > > > andy > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318088 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Using Ray's RSS.cfc and getting invalid feed
Yeah ditto Dave. It's the funky char. I bet its a long dash or somesuch. On Fri, Jan 16, 2009 at 11:06 AM, Dave Watts wrote: >> This was typed straight in. If you look at the second link, it's a >> validation attempt at my feed. It dies on ' which is straight out of >> XMLFormat. > > It looked like it was dying on the unknown character immediately after > that, actually. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > -- === Raymond Camden, VP of Software Dev, Broadchoice Email: r...@camdenfamily.com Blog : www.coldfusionjedi.com AOL IM : cfjedimaster Keep up to date with the community: http://www.coldfusionbloggers.org ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318087 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Using Ray's RSS.cfc and getting invalid feed
Yep... I ended up pasting the post in question into EditPlus and saw the problem immediately. I have no clue where that character came from. Thanks all. Ray, I'll look into using cffeed, I thought it was only for reading in feeds, not generating them. Thanks for the pointer. -Original Message- From: Raymond Camden [mailto:rcam...@gmail.com] Sent: Friday, January 16, 2009 11:07 AM To: cf-talk Subject: Re: Using Ray's RSS.cfc and getting invalid feed Ah yep, that's the issue:Who's the guy who got tboned? What happened to his daughter? .. See the crap after &apos? rss.cfc tries to clean input as much as possible, but it missed this one. Just edit and remove the bad char. On Fri, Jan 16, 2009 at 10:32 AM, Andy Matthews wrote: > I'm in the process of finalizing my blog and working on setting up the > RSS > feed: > > http://www.andymatthews.net/rss/ > > I'm getting an error when I try to validate the feed: > http://feedvalidator.org/check.cgi?url=http://www.andymatthews.net/rss > / > > I've gone through and added cdata nodes where applicable but that > doesn't seem to be helping. Anyone have any idea what's wrong? > > > > andy > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318086 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Using Ray's RSS.cfc and getting invalid feed
Ah yep, that's the issue:Who's the guy who got tboned? What happened to his daughter? . See the crap after &apos? rss.cfc tries to clean input as much as possible, but it missed this one. Just edit and remove the bad char. On Fri, Jan 16, 2009 at 10:32 AM, Andy Matthews wrote: > I'm in the process of finalizing my blog and working on setting up the RSS > feed: > > http://www.andymatthews.net/rss/ > > I'm getting an error when I try to validate the feed: > http://feedvalidator.org/check.cgi?url=http://www.andymatthews.net/rss/ > > I've gone through and added cdata nodes where applicable but that doesn't > seem to be helping. Anyone have any idea what's wrong? > > > > andy > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318085 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Styling CFWINDOW
The Ext site (http://www.extjs.com) has additional 'skins' for their apps listed in the 'Learning Center' area of the site. You'll want to make sure you look at the items in their 1.1 version area, as that's what Adobe's using under the hood. It's all stylesheet controlled. Steve "Cutter" Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer Co-Author of "Learning Ext JS" http://www.packtpub.com/learning-ext-js/book _ http://blog.cutterscrossing.com Les Mizzell wrote: > I've been looking for a good while now, and so far haven't found > anything great... > > Is there a good guide out there on styling CFWINDOW? Not the window > contents - the window itself... > > Or is there a better way I need to be looking at to start with? > > Window(s) in question my contain query objects, graphics, and links to > other stuff... > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318084 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Using Ray's RSS.cfc and getting invalid feed
> This was typed straight in. If you look at the second link, it's a > validation attempt at my feed. It dies on ' which is straight out of > XMLFormat. It looked like it was dying on the unknown character immediately after that, actually. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318083 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Using Ray's RSS.cfc and getting invalid feed
If you are on CF8, you should probably use the builtin CFFEED instead of my CFC. Not saying my CFC is broken (it happens), but it may be simpler. I'll take a look at your feed validation results next. Cutter definitely has a point too about watching out for 'bad' chars. On Fri, Jan 16, 2009 at 10:32 AM, Andy Matthews wrote: > I'm in the process of finalizing my blog and working on setting up the RSS > feed: > > http://www.andymatthews.net/rss/ > > I'm getting an error when I try to validate the feed: > http://feedvalidator.org/check.cgi?url=http://www.andymatthews.net/rss/ > > I've gone through and added cdata nodes where applicable but that doesn't > seem to be helping. Anyone have any idea what's wrong? > > > > andy > -- === Raymond Camden, VP of Software Dev, Broadchoice Email: r...@camdenfamily.com Blog : www.coldfusionjedi.com AOL IM : cfjedimaster Keep up to date with the community: http://www.coldfusionbloggers.org ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318082 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Using Ray's RSS.cfc and getting invalid feed
This was typed straight in. If you look at the second link, it's a validation attempt at my feed. It dies on ' which is straight out of XMLFormat. andy -Original Message- From: Cutter (CFRelated) [mailto:cold.fus...@cutterscrossing.com] Sent: Friday, January 16, 2009 10:54 AM To: cf-talk Subject: Re: Using Ray's RSS.cfc and getting invalid feed I had issue at one time with my feed. Turned out to be an invalid, non-display character appearing in the feed. Something from copy and pasting something into the backend editor. C & P from direct from some code editors might do this... Steve "Cutter" Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer Co-Author of "Learning Ext JS" http://www.packtpub.com/learning-ext-js/book _ http://blog.cutterscrossing.com Andy Matthews wrote: > I'm in the process of finalizing my blog and working on setting up the > RSS > feed: > > http://www.andymatthews.net/rss/ > > I'm getting an error when I try to validate the feed: > http://feedvalidator.org/check.cgi?url=http://www.andymatthews.net/rss > / > > I've gone through and added cdata nodes where applicable but that > doesn't seem to be helping. Anyone have any idea what's wrong? > > > > andy > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318081 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Using Ray's RSS.cfc and getting invalid feed
I had issue at one time with my feed. Turned out to be an invalid, non-display character appearing in the feed. Something from copy and pasting something into the backend editor. C & P from direct from some code editors might do this... Steve "Cutter" Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer Co-Author of "Learning Ext JS" http://www.packtpub.com/learning-ext-js/book _ http://blog.cutterscrossing.com Andy Matthews wrote: > I'm in the process of finalizing my blog and working on setting up the RSS > feed: > > http://www.andymatthews.net/rss/ > > I'm getting an error when I try to validate the feed: > http://feedvalidator.org/check.cgi?url=http://www.andymatthews.net/rss/ > > I've gone through and added cdata nodes where applicable but that doesn't > seem to be helping. Anyone have any idea what's wrong? > > > > andy > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318080 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Recognizing spyders
We track backend user activity as well, to see which apps are getting the most usage, which helps us target priority areas and allows us to customize user experience. Steve "Cutter" Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer Co-Author of "Learning Ext JS" http://www.packtpub.com/learning-ext-js/book _ http://blog.cutterscrossing.com Judah McAuley wrote: > That's the sort of thing I was thinking of. I've always done that sort > of thing via cookies with a db recording page atctivity until the user > logs in. And, obviously, you could make a user id part of the cookie > so as to track individual user behavior even prior to a login. Just > cuts down on the number of sessions created. I like the idea of > transient 2-second sessions though for bots. I'll have to give the > topic some more though next time I create a site of that sort. These > days I'm doing mostly back end business programming so session > creation overhead isn't an issue. Good topic to think on anyway. > > Cheers, > Judah > > On Fri, Jan 16, 2009 at 6:09 AM, Cutter (CFRelated) > wrote: >> We maintain sessions for a variety of reasons. Our sites contain >> multiple user facing applications, typically dealing with product detail >> or directly reviewing client inventory. Sessions are used to track a >> site user's full path through a site. Page views, lead submissions, app >> level review (some of our front-end apps are Flash based). So, we get >> full activity reporting, plus are able to differentiate (in our stats >> review) multiple site sessions by the same user, seeing if return >> sessions might be more productive, and tying together the session's >> activity for complete user action overview. >> >> Steve "Cutter" Blades >> Adobe Certified Professional >> Advanced Macromedia ColdFusion MX 7 Developer >> >> Co-Author of "Learning Ext JS" >> http://www.packtpub.com/learning-ext-js/book >> _ >> http://blog.cutterscrossing.com >> >> Judah McAuley wrote: >>> Out of curiosity, what are the primary business objectives for >>> maintaining session on pages that are not user-specific? I typically >>> have divided my site into two parts, a public part that doesn't >>> maintain session and then an area behind a login form. Once you have >>> logged in and identified yourself as a user, I keep track of the user >>> through the whole site, public and private. But I don't generally see >>> a need to maintain session info for a visitor unless they have done >>> something user-specific, which would require a login. That eliminates >>> bots right there. >>> >>> Judah >>> >>> On Thu, Jan 15, 2009 at 8:43 PM, Cutter (CFRelated) >>> wrote: We found this post from Ben Nadel to be extremely helpful in detecting bot traffic. We have a highly customized statistical tracking system in place for our web traffic, and wanted to accomplish two primary objectives: a) not record page views of bots, and b) not maintain a separate session on every page view (this is accomplished by identifying the visit as a bot and setting the session timeout to 2 sec). We have found Ben's work here to be highly effective. http://www.bennadel.com/blog/1083-ColdFusion-Session-Management-And-Spiders-Bots.htm Steve "Cutter" Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer Co-Author of "Learning Ext JS" http://www.packtpub.com/learning-ext-js/book _ http://blog.cutterscrossing.com Jim McAtee wrote: > We keep our own page view stats in a database and want to avoid counting > page views by visiting spyders. What's a good method for recognizing > spyders without throwing away valid visitor page views? > > Something using cgi.user_agent, no doubt, but how can we keep a fairly > comprehensive list up to date, and do we try to do exact string matches, > partial matches, or what? > > > >>> >> > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318079 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Styling CFWINDOW
I've been looking for a good while now, and so far haven't found anything great... Is there a good guide out there on styling CFWINDOW? Not the window contents - the window itself... Or is there a better way I need to be looking at to start with? Window(s) in question my contain query objects, graphics, and links to other stuff... ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318078 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Using Ray's RSS.cfc and getting invalid feed
I'm in the process of finalizing my blog and working on setting up the RSS feed: http://www.andymatthews.net/rss/ I'm getting an error when I try to validate the feed: http://feedvalidator.org/check.cgi?url=http://www.andymatthews.net/rss/ I've gone through and added cdata nodes where applicable but that doesn't seem to be helping. Anyone have any idea what's wrong? andy ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318077 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Recognizing spyders
That's the sort of thing I was thinking of. I've always done that sort of thing via cookies with a db recording page atctivity until the user logs in. And, obviously, you could make a user id part of the cookie so as to track individual user behavior even prior to a login. Just cuts down on the number of sessions created. I like the idea of transient 2-second sessions though for bots. I'll have to give the topic some more though next time I create a site of that sort. These days I'm doing mostly back end business programming so session creation overhead isn't an issue. Good topic to think on anyway. Cheers, Judah On Fri, Jan 16, 2009 at 6:09 AM, Cutter (CFRelated) wrote: > We maintain sessions for a variety of reasons. Our sites contain > multiple user facing applications, typically dealing with product detail > or directly reviewing client inventory. Sessions are used to track a > site user's full path through a site. Page views, lead submissions, app > level review (some of our front-end apps are Flash based). So, we get > full activity reporting, plus are able to differentiate (in our stats > review) multiple site sessions by the same user, seeing if return > sessions might be more productive, and tying together the session's > activity for complete user action overview. > > Steve "Cutter" Blades > Adobe Certified Professional > Advanced Macromedia ColdFusion MX 7 Developer > > Co-Author of "Learning Ext JS" > http://www.packtpub.com/learning-ext-js/book > _ > http://blog.cutterscrossing.com > > Judah McAuley wrote: >> Out of curiosity, what are the primary business objectives for >> maintaining session on pages that are not user-specific? I typically >> have divided my site into two parts, a public part that doesn't >> maintain session and then an area behind a login form. Once you have >> logged in and identified yourself as a user, I keep track of the user >> through the whole site, public and private. But I don't generally see >> a need to maintain session info for a visitor unless they have done >> something user-specific, which would require a login. That eliminates >> bots right there. >> >> Judah >> >> On Thu, Jan 15, 2009 at 8:43 PM, Cutter (CFRelated) >> wrote: >>> We found this post from Ben Nadel to be extremely helpful in detecting >>> bot traffic. We have a highly customized statistical tracking system in >>> place for our web traffic, and wanted to accomplish two primary >>> objectives: a) not record page views of bots, and b) not maintain a >>> separate session on every page view (this is accomplished by identifying >>> the visit as a bot and setting the session timeout to 2 sec). We have >>> found Ben's work here to be highly effective. >>> >>> http://www.bennadel.com/blog/1083-ColdFusion-Session-Management-And-Spiders-Bots.htm >>> >>> Steve "Cutter" Blades >>> Adobe Certified Professional >>> Advanced Macromedia ColdFusion MX 7 Developer >>> >>> Co-Author of "Learning Ext JS" >>> http://www.packtpub.com/learning-ext-js/book >>> _ >>> http://blog.cutterscrossing.com >>> >>> Jim McAtee wrote: We keep our own page view stats in a database and want to avoid counting page views by visiting spyders. What's a good method for recognizing spyders without throwing away valid visitor page views? Something using cgi.user_agent, no doubt, but how can we keep a fairly comprehensive list up to date, and do we try to do exact string matches, partial matches, or what? >>> >> >> > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318076 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Error trying to use CFSlider in CF7
We are running CF7.0.2 Enterprise on a Windows 2003 Server. We are trying to use CFSlider on one of our pages and some of our support staff is getting the following error: The application's digital signature has an error. Do you want to run this application?Name: coldfusion.applets.CFSliderApplet. We have CFIDE mapped to the correct folder on the web server and not everyone gets this error, mainly in IE. Can anyone point us in the right direction on where to look to fix this error? Thanks, Dave Hatz ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318075 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: 500 Event Handler Exception error when I try to create a java object
> "500 Event Handler Exception." That's all it says. I've turned on > debugging but it doesn't display any debugging information either. What do your log files say? Leigh ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318074 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Possible to get NT domain user without cfntauthenticate?
Thanks, Michael, that put me on the right track. However, I also had to disable the anonymous user access in order for it to work as expected. Thanks again, Pete On Thu, Jan 15, 2009 at 2:12 PM, Dawson, Michael wrote: > I forget the actual option, but it's not Basic Authentication or Digest > Authentication. It's the other one. ;-) > > Turn that on and IE should, by default, send the user's credentials to > the web server. As mentioned in a recent, similar post, it sends the > hash, not the password. > > However, you can assume that, by that point, the user has already been > authenticated by the workstation. > > I don't like this method because I like to sit down at another user's > computer and log in with my credentials. > > I'm not sure of your sysadmin's reasons, but they seem quite > narrow-minded. If they won't let your web app interact with the DCs, I > bet they hate having workstations connect to the DCs, as well. Seems > kinda silly. > > They won't even allow LDAP access? > > mike > > -Original Message- > From: Pete Ruckelshaus [mailto:pruckelsh...@gmail.com] > Sent: Thursday, January 15, 2009 12:17 PM > To: cf-talk > Subject: Possible to get NT domain user without cfntauthenticate? > > I'm building an intranet application. Users will not necessarily be > logged in, but there are things that I need to track; all users are > logged into the NT domain on their computers, is it possible to get the > username that the person is logged into their PC as? Using > cfntauthenticate isn't an option, the sysadmins won't allow this app to > interface with the domain controller in any way. > > Thanks > > Pete > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318073 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: join two databases
Here is something else fer ya. If you are linking a 64-bit version of SQL to a 32-bit, you will need to run a script on the 32-bit server that updates the system stored procedures. http://support.microsoft.com/?id=906954 mike -Original Message- From: C. Hatton Humphrey [mailto:chumph...@gmail.com] Sent: Friday, January 16, 2009 8:25 AM To: cf-talk Subject: Re: join two databases > You need to link your SQL Server instances. Google "SQL Server Linked". > > You can link the servers both directions, if needed. > > With the server linked in SQL, you can create cross-server queries in > the Query Analyzer/New Query editor. Well would ya look at that! Learn something new every day, thanks for the education! Hatton ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318072 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: join two databases
You first link your server and give it a name. The name is arbitrary, but should be meaningful. Then, a query would look like SELECT * FROM Database.dbo.Table A JOIN MyLinkedServer.Database.dbo.Table B ON A.id = B.id No need to specify the linked server name for the "local" server or the server that is referenced in your datasource. mike -Original Message- From: Chad Gray [mailto:cg...@careyweb.com] Sent: Friday, January 16, 2009 8:23 AM To: cf-talk Subject: RE: join two databases Ah.. so there is a way in MS SQL to link two servers together. Then I would just add one DSN in CF Admin. How do you write your SQL in CFQuery? SELECT * FROM server1.database1.table1 AS a JOIN server2.database2.table2 AS b on b.index = a.index Thanks, I will go read up on linking two servers. Chad ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318071 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: join two databases
Yes you can do it in oracle too and it works in both directions. In fact you can even do the link with non-oracle databases. * Use the CREATE DATABASE LINK statement to create a database link. A database link is a schema object in one database that enables you to access objects on another database. The other database need not be an Oracle Database system. However, to access non-Oracle systems you must use Oracle Heterogeneous Services. Once you have created a database link, you can use it to refer to tables and views on the other database. In SQL statements, you can refer to a table or view on the other database by appending @dblink to the table or view name. You can query a table or view on the other database with the SELECT statement. You can also access remote tables and views using any INSERT, UPDATE, DELETE, or LOCK TABLE statement. * brad -Original Message- From: C. Hatton Humphrey [mailto:chumph...@gmail.com] Sent: Friday, January 16, 2009 9:25 AM To: cf-talk Subject: Re: join two databases > You need to link your SQL Server instances. Google "SQL Server > Linked". > > You can link the servers both directions, if needed. > > With the server linked in SQL, you can create cross-server queries in > the Query Analyzer/New Query editor. Well would ya look at that! Learn something new every day, thanks for the education! Hatton ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318070 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: join two databases
You can join different tables that are both in the same db in a query (through a union or join). You can't, through a query, join tables from two entirely different databases. That will require some back-end DBA re-architecting. I'm not familiar with ms-sql (I do oracle) but somebody mentioned that "SQL Server Linked" stuff. That's interesting. I'll have to see if that's possible with oracle. brad -Original Message- From: Chad Gray [mailto:cg...@careyweb.com] Sent: Friday, January 16, 2009 9:18 AM To: cf-talk Subject: RE: join two databases I can see this working when you have two databases on the same server. I have two databases on completely different servers. Can you preface the database name with the server name/IP? Server1.database1.dbo.table1? I would think you would need login credentials stored somewhere to do this. Or can you preface the database name with the dns name in CF Admin? Dsn1.database1.dbo.table1? > -Original Message- > From: Duane Boudreau [mailto:du...@sandybaynetworks.com] > Sent: Friday, January 16, 2009 9:09 AM > To: cf-talk > Subject: RE: join two databases > > You can reference the database by name in the query > Ex: > > selectt1.Field1, t2.Field2, t2.Field3 > from database1.dbo.Table1 t1 > inner join database2.dbo.Table2 t2 on t1.Field = t2.Field > > you might need to put that into a stored procedure or use a dsnless > connection > > > > -Original Message- > From: Chad Gray [mailto:cg...@careyweb.com] > Sent: Friday, January 16, 2009 10:05 AM > To: cf-talk > Subject: join two databases > > What is the best way to join tables across two databases servers? > > Say I have one MS SQL server that has a database that stores ERP > product data. I have our website MS SQL server that stores extra data > about the product records in the ERP database. > > Is it possible to hook each datasource up in CF Admin and use both > DSN's in the same CFQuery? > > Or should you do something on the MS SQL servers to join them then > hook up one datasource in CF Admin? > > Chad > > > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318069 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: join two databases
> You need to link your SQL Server instances. Google "SQL Server Linked". > > You can link the servers both directions, if needed. > > With the server linked in SQL, you can create cross-server queries in > the Query Analyzer/New Query editor. Well would ya look at that! Learn something new every day, thanks for the education! Hatton ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318068 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: join two databases
Ah.. so there is a way in MS SQL to link two servers together. Then I would just add one DSN in CF Admin. How do you write your SQL in CFQuery? SELECT * FROM server1.database1.table1 AS a JOIN server2.database2.table2 AS b on b.index = a.index Thanks, I will go read up on linking two servers. Chad > -Original Message- > From: Dawson, Michael [mailto:m...@evansville.edu] > Sent: Friday, January 16, 2009 9:13 AM > To: cf-talk > Subject: RE: join two databases > > You need to link your SQL Server instances. Google "SQL Server Linked". > > You can link the servers both directions, if needed. > > With the server linked in SQL, you can create cross-server queries in > the Query Analyzer/New Query editor. > > mike > > -Original Message- > From: Chad Gray [mailto:cg...@careyweb.com] > Sent: Friday, January 16, 2009 8:05 AM > To: cf-talk > Subject: join two databases > > What is the best way to join tables across two databases servers? > > Say I have one MS SQL server that has a database that stores ERP product > data. I have our website MS SQL server that stores extra data about the > product records in the ERP database. > > Is it possible to hook each datasource up in CF Admin and use both DSN's > in the same CFQuery? > > Or should you do something on the MS SQL servers to join them then hook > up one datasource in CF Admin? > > Chad > > > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318067 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: join two databases
I can see this working when you have two databases on the same server. I have two databases on completely different servers. Can you preface the database name with the server name/IP? Server1.database1.dbo.table1? I would think you would need login credentials stored somewhere to do this. Or can you preface the database name with the dns name in CF Admin? Dsn1.database1.dbo.table1? > -Original Message- > From: Duane Boudreau [mailto:du...@sandybaynetworks.com] > Sent: Friday, January 16, 2009 9:09 AM > To: cf-talk > Subject: RE: join two databases > > You can reference the database by name in the query > Ex: > > selectt1.Field1, t2.Field2, t2.Field3 > from database1.dbo.Table1 t1 > inner join database2.dbo.Table2 t2 on t1.Field = t2.Field > > you might need to put that into a stored procedure or use a dsnless > connection > > > > -Original Message- > From: Chad Gray [mailto:cg...@careyweb.com] > Sent: Friday, January 16, 2009 10:05 AM > To: cf-talk > Subject: join two databases > > What is the best way to join tables across two databases servers? > > Say I have one MS SQL server that has a database that stores ERP product > data. I have our website MS SQL server that stores extra data about the > product records in the ERP database. > > Is it possible to hook each datasource up in CF Admin and use both DSN's > in > the same CFQuery? > > Or should you do something on the MS SQL servers to join them then hook up > one datasource in CF Admin? > > Chad > > > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318066 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: ColdFusion method to fade hex color a specific % or amount
Thanks for everyone who commented. Love the community here at HoF! -Original Message- From: Andy Matthews [mailto:andymatth...@comcast.net] Sent: Thursday, January 15, 2009 4:21 PM To: cf-talk Subject: ColdFusion method to fade hex color a specific % or amount Does anyone have a CFC which will return a tint of a specified hex color? In other words I provide a dark blue, and get the hex color for a little lighter blue, or darker blue. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318065 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: join two databases
You need to link your SQL Server instances. Google "SQL Server Linked". You can link the servers both directions, if needed. With the server linked in SQL, you can create cross-server queries in the Query Analyzer/New Query editor. mike -Original Message- From: Chad Gray [mailto:cg...@careyweb.com] Sent: Friday, January 16, 2009 8:05 AM To: cf-talk Subject: join two databases What is the best way to join tables across two databases servers? Say I have one MS SQL server that has a database that stores ERP product data. I have our website MS SQL server that stores extra data about the product records in the ERP database. Is it possible to hook each datasource up in CF Admin and use both DSN's in the same CFQuery? Or should you do something on the MS SQL servers to join them then hook up one datasource in CF Admin? Chad ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318064 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: join two databases
> What is the best way to join tables across two databases servers? > > Say I have one MS SQL server that has a database that stores ERP product > data. I have our website MS SQL server that stores extra data about the > product records in the ERP database. > > Is it possible to hook each datasource up in CF Admin and use both DSN's in > the same CFQuery? > > Or should you do something on the MS SQL servers to join them then hook up > one datasource in CF Admin? I'm pretty sure you're going to have to do two separate queries and the do a Query of Queries to tie the two together. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318063 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: join two databases
You can reference the database by name in the query Ex: select t1.Field1, t2.Field2, t2.Field3 fromdatabase1.dbo.Table1 t1 inner join database2.dbo.Table2 t2 on t1.Field = t2.Field you might need to put that into a stored procedure or use a dsnless connection -Original Message- From: Chad Gray [mailto:cg...@careyweb.com] Sent: Friday, January 16, 2009 10:05 AM To: cf-talk Subject: join two databases What is the best way to join tables across two databases servers? Say I have one MS SQL server that has a database that stores ERP product data. I have our website MS SQL server that stores extra data about the product records in the ERP database. Is it possible to hook each datasource up in CF Admin and use both DSN's in the same CFQuery? Or should you do something on the MS SQL servers to join them then hook up one datasource in CF Admin? Chad ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318062 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Recognizing spyders
We maintain sessions for a variety of reasons. Our sites contain multiple user facing applications, typically dealing with product detail or directly reviewing client inventory. Sessions are used to track a site user's full path through a site. Page views, lead submissions, app level review (some of our front-end apps are Flash based). So, we get full activity reporting, plus are able to differentiate (in our stats review) multiple site sessions by the same user, seeing if return sessions might be more productive, and tying together the session's activity for complete user action overview. Steve "Cutter" Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer Co-Author of "Learning Ext JS" http://www.packtpub.com/learning-ext-js/book _ http://blog.cutterscrossing.com Judah McAuley wrote: > Out of curiosity, what are the primary business objectives for > maintaining session on pages that are not user-specific? I typically > have divided my site into two parts, a public part that doesn't > maintain session and then an area behind a login form. Once you have > logged in and identified yourself as a user, I keep track of the user > through the whole site, public and private. But I don't generally see > a need to maintain session info for a visitor unless they have done > something user-specific, which would require a login. That eliminates > bots right there. > > Judah > > On Thu, Jan 15, 2009 at 8:43 PM, Cutter (CFRelated) > wrote: >> We found this post from Ben Nadel to be extremely helpful in detecting >> bot traffic. We have a highly customized statistical tracking system in >> place for our web traffic, and wanted to accomplish two primary >> objectives: a) not record page views of bots, and b) not maintain a >> separate session on every page view (this is accomplished by identifying >> the visit as a bot and setting the session timeout to 2 sec). We have >> found Ben's work here to be highly effective. >> >> http://www.bennadel.com/blog/1083-ColdFusion-Session-Management-And-Spiders-Bots.htm >> >> Steve "Cutter" Blades >> Adobe Certified Professional >> Advanced Macromedia ColdFusion MX 7 Developer >> >> Co-Author of "Learning Ext JS" >> http://www.packtpub.com/learning-ext-js/book >> _ >> http://blog.cutterscrossing.com >> >> Jim McAtee wrote: >>> We keep our own page view stats in a database and want to avoid counting >>> page views by visiting spyders. What's a good method for recognizing >>> spyders without throwing away valid visitor page views? >>> >>> Something using cgi.user_agent, no doubt, but how can we keep a fairly >>> comprehensive list up to date, and do we try to do exact string matches, >>> partial matches, or what? >>> >>> >>> >> > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318061 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
join two databases
What is the best way to join tables across two databases servers? Say I have one MS SQL server that has a database that stores ERP product data. I have our website MS SQL server that stores extra data about the product records in the ERP database. Is it possible to hook each datasource up in CF Admin and use both DSN's in the same CFQuery? Or should you do something on the MS SQL servers to join them then hook up one datasource in CF Admin? Chad ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318060 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: 500 Event Handler Exception error when I try to create a java object
> Can someone please show me how to load a class file in ColdFusion. > I've tried everything from copying the .class file to the > C:\CFusionMX7\lib directory to copying it to the > C:\CFusionMX7\wwwroot\WEB-INF\classes directory. I don't even know if > just by dropping the file to a specific directory is sufficient or if > there is something else to do on top of that? Kindly help! > I built the Employee class from the text, put the class file in webapps/cfusion/web-inf/classes and then used the sample cfm code, and it worked as documented. (I am running cf on tomcat) Sam ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318059 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: 500 Event Handler Exception error when I try to create a java object
> Can someone please show me how to load a class file in ColdFusion. > I've tried everything from copying the .class file to the > C:\CFusionMX7\lib directory to copying it to the > C:\CFusionMX7\wwwroot\WEB-INF\classes directory. I don't even know if > just by dropping the file to a specific directory is sufficient or if > there is something else to do on top of that? Kindly help! > > Regards, > John > jClass = createobject("java", classname); (for example from one of my apps, the class is in a jar file, located in tomcat/webapps/cfusion/web-inf/lib) jClass = createobject("java", "com.ca.dsm.webservice.UnitPropertyFilter"); Sam ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318058 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: call a cfm page from cfc
This: Or this: http://www.adrianlynch.co.uk/";> Adrian > -Original Message- > From: dev losh [mailto:devl...@gmail.com] > Sent: 16 January 2009 12:16 > To: cf-talk > Subject: call a cfm page from cfc > > hi all, > > Is it possible to call a cfm page from cfc? > > i.e, My requirement is to call a cfm page and store the output in a > variable all inside cfc. > > Please help me if this is possible. > Thanks, > Dev ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318057 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: 500 Event Handler Exception error when I try to create a java object
Can someone please show me how to load a class file in ColdFusion. I've tried everything from copying the .class file to the C:\CFusionMX7\lib directory to copying it to the C:\CFusionMX7\wwwroot\WEB-INF\classes directory. I don't even know if just by dropping the file to a specific directory is sufficient or if there is something else to do on top of that? Kindly help! Regards, John > "500 Event Handler Exception." That's all it says. I've turned on > debugging but it doesn't display any debugging information either. > > > On Thursday 15 Jan 2009, cf coder wrote: > > > This is when it throws the exception. > > > > What exception ? > > > > -- > > Tom Chiverton > > Helping to appropriately transform market-growth > > > > > > > > This email is sent for and on behalf of Halliwells LLP. > > > > Halliwells LLP is a limited liability partnership registered in > > England and Wales under registered number OC307980 whose registered > > > office address is at Halliwells LLP, 3 Hardman Square, > Spinningfields, > > Manchester, M3 3EB. A list of members is available for inspection > at > > the registered office together with a list of those non members who > > > are referred to as partners. We use the word partner to refer to > a > > member of the LLP, or an employee or consultant with equivalent > > standing and qualifications. Regulated by the Solicitors Regulation > > > Authority. > > > > CONFIDENTIALITY > > > > This email is intended only for the use of the addressee named above > > > and may be confidential or legally privileged. If you are not the > > addressee you must not read it and must not use any information > > contained in nor copy it nor inform any person other than Halliwells > > > LLP or the addressee of its existence or contents. If you have > > received this email in error please delete it and notify Halliwells > > > LLP IT Department on 0870 365 2500. > > > > For more information about Halliwells LLP visit www.halliwells.com. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318056 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: 500 Event Handler Exception error when I try to create a java object
Can someone please show me how to load a class file in ColdFusion. I've tried everything from copying the .class file to the C:\CFusionMX7\lib directory to copying it to the C:\CFusionMX7\wwwroot\WEB-INF\classes directory. I don't even know if just by dropping the file to a specific directory is sufficient or if there is something else to do on top of that? Kindly help! Regards, John > "500 Event Handler Exception." That's all it says. I've turned on > debugging but it doesn't display any debugging information either. > > > On Thursday 15 Jan 2009, cf coder wrote: > > > This is when it throws the exception. > > > > What exception ? > > > > -- > > Tom Chiverton > > Helping to appropriately transform market-growth > > > > > > > > This email is sent for and on behalf of Halliwells LLP. > > > > Halliwells LLP is a limited liability partnership registered in > > England and Wales under registered number OC307980 whose registered > > > office address is at Halliwells LLP, 3 Hardman Square, > Spinningfields, > > Manchester, M3 3EB. A list of members is available for inspection > at > > the registered office together with a list of those non members who > > > are referred to as partners. We use the word partner to refer to > a > > member of the LLP, or an employee or consultant with equivalent > > standing and qualifications. Regulated by the Solicitors Regulation > > > Authority. > > > > CONFIDENTIALITY > > > > This email is intended only for the use of the addressee named above > > > and may be confidential or legally privileged. If you are not the > > addressee you must not read it and must not use any information > > contained in nor copy it nor inform any person other than Halliwells > > > LLP or the addressee of its existence or contents. If you have > > received this email in error please delete it and notify Halliwells > > > LLP IT Department on 0870 365 2500. > > > > For more information about Halliwells LLP visit www.halliwells.com. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318055 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
call a cfm page from cfc
hi all, Is it possible to call a cfm page from cfc? i.e, My requirement is to call a cfm page and store the output in a variable all inside cfc. Please help me if this is possible. Thanks, Dev ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318054 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
call a cfm page from cfc
hi all, Is it possible to call a cfm page from cfc? i.e, My requirement is to call a cfm page and store the output in a variable all inside cfc. Please help me if this is possible. Thanks, Dev ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318053 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: JRUN and Sockets
On Fri, Jan 16, 2009 at 2:11 AM, Craigsell wrote: > We are working on one of our CF webservers and noticed something strange. A > user was running a very long query which subsequently displays on the browser > (10+ minutes, tons of data - don't ask it's a mess). It was chewing up huge > amounts of memory and CPU. We contacted the user and found that they had > gotten tired of waiting and quit the browser -- closed it right down. What may be the easiest way to improve the situation is to put in a few calls to cfflush. That should allow CF to start flushing the output buffer to the webserver and reduce the memory consumption by 'tons of bytes'. Jochem ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318052 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4