RE: Adobe hacked
The second link below mentions applying available security updates. Does anyone know what specific updates are available related to this incident? Nathan -Original Message- From: Billy Cravens [mailto:bdcrav...@gmail.com] Sent: Thursday, October 03, 2013 4:02 PM To: cf-talk Subject: Adobe hacked Kinda surprised no one else here has said anything, but with the Adobe breach, change your Adobe.com password immediately. http://blogs.adobe.com/conversations/2013/10/important-customer-security-announcement.html http://blogs.adobe.com/asset/2013/10/illegal-access-to-adobe-source-code.html Billy Cravens bdcrav...@gmail.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356893 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
data source in CF 9 via jdbc
All: I upgraded cf8 to cf 9 and now the previous data source on jdbc broke. It said no suitable driver. I downloaded ojdbc6.jar from Oracle and placed in here: C:\ColdFusion9\runtime\jre\lib\ext\, and also set the class path on CF Admin page(Sever Settings - Java and JVM) like this: C:\ColdFusion9\runtime\jre\lib\ext\ojdbc6.jar And Now it says "java.sql.SQLException: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor". But I don't use SID as my DBA gave me Oracle service name. The string works fine in Oracle SQL Developer command line. Has anyone seen this and know how to fix it? I am on Oracle 11g. and the entry on jdbc is: JDBC URL: jdbc:oracle:thin:@[my host name]:1521:[my service name] Driver Class: oracle:jdbc.OracleDriver Thanks in advance. Nathan Chen ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356680 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: how to detect null value from QoQ result
I have found the problem and was able to fix it. It wasn't the if statement; it was because the query and the output was inside a loop and I was supposed to place the if statement outside of the output, logical error. Sorry guys to cause the grief, and thanks Raymond and AJ for your time. Nathan -Original Message- From: AJ Mercer [mailto:ajmer...@gmail.com] Sent: Monday, July 01, 2013 10:35 PM To: cf-talk Subject: Re: how to detect null value from QoQ result what do you see when you dump 'myAnotherQuery'? is it NULL?? On 2 July 2013 12:03, Nathan Chen wrote: > > I tried it but for some reason it just wouldn't work. > > Nathan > > -Original Message- > From: AJ Mercer [mailto:ajmer...@gmail.com] > Sent: Monday, July 01, 2013 9:45 PM > To: cf-talk > Subject: Re: how to detect null value from QoQ result > > > try > > Select id from myAnotherQuery > Where [some where clause] > > myQuery.RecordCount EQ 0 > > > > On 2 July 2013 11:38, Nathan Chen wrote: > > > > > All: > > > > I have a simple query of query as follow: > > Select count(*) as r_count > > from myAnotherQuery Where [some where clause] > > > > I want the result to be dislayed as zero If it returns no records, > > So I use val() function #val(myQuery.r_count)#, > > but it doesn't work; it returns an empty string, not zero when no > > records are returned. Is there a quick way to detect the null and return 0? > > > > Nathan > > > > > > > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356113 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: how to detect null value from QoQ result
I did try that before but wouldn't work. Yes, it drives me crazy. Nathan -Original Message- From: Raymond Camden [mailto:raymondcam...@gmail.com] Sent: Monday, July 01, 2013 9:46 PM To: cf-talk Subject: Re: how to detect null value from QoQ result Maybe I'm crazy, but can't you just do Nothing returned, dude! On Mon, Jul 1, 2013 at 10:38 PM, Nathan Chen wrote: > > All: > > I have a simple query of query as follow: > Select count(*) as r_count > from myAnotherQuery Where [some where clause] > > I want the result to be dislayed as zero If it returns no records, So > I use val() function #val(myQuery.r_count)#, but > it doesn't work; it returns an empty string, not zero when no records > are returned. Is there a quick way to detect the null and return 0? > > Nathan > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356097 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: how to detect null value from QoQ result
I tried it but for some reason it just wouldn't work. Nathan -Original Message- From: AJ Mercer [mailto:ajmer...@gmail.com] Sent: Monday, July 01, 2013 9:45 PM To: cf-talk Subject: Re: how to detect null value from QoQ result try Select id from myAnotherQuery Where [some where clause] myQuery.RecordCount EQ 0 On 2 July 2013 11:38, Nathan Chen wrote: > > All: > > I have a simple query of query as follow: > Select count(*) as r_count > from myAnotherQuery Where [some where clause] > > I want the result to be dislayed as zero If it returns no records, So > I use val() function #val(myQuery.r_count)#, but > it doesn't work; it returns an empty string, not zero when no records > are returned. Is there a quick way to detect the null and return 0? > > Nathan > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356096 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
how to detect null value from QoQ result
All: I have a simple query of query as follow: Select count(*) as r_count from myAnotherQuery Where [some where clause] I want the result to be dislayed as zero If it returns no records, So I use val() function #val(myQuery.r_count)#, but it doesn't work; it returns an empty string, not zero when no records are returned. Is there a quick way to detect the null and return 0? Nathan ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356093 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Case statement inside cached query
Matt, sorry I wasn't clear. I got a query of queries syntax error like this: Query Of Queries syntax error. Encountered "sum ( case. Incorrect Select List, Nathan -Original Message- From: Matt Quackenbush [mailto:quackfu...@gmail.com] Sent: Wednesday, November 07, 2012 4:27 PM To: cf-talk Subject: Re: Case statement inside cached query What does "wouldn't work" mean? Get results you didn't expect? If yes, what did you get and what did you expect? Get an exception? If yes, where's the stack trace? On Wed, Nov 7, 2012 at 5:22 PM, Nathan Chen wrote: > > All: > > Do cached queries allow SQL case statement at all or is there a way to > get around it? I am trying to put this inside a cached query such as : > Sum( case when A = 'B' then C else 0 end) as D ( C is numeric field). > It wouldn't work. I am on CF 8 and Oracle 11g. > > Thanks. > > Nathan Chen > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353089 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Case statement inside cached query
All: Do cached queries allow SQL case statement at all or is there a way to get around it? I am trying to put this inside a cached query such as : Sum( case when A = 'B' then C else 0 end) as D ( C is numeric field). It wouldn't work. I am on CF 8 and Oracle 11g. Thanks. Nathan Chen ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353084 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
AD domain login passes to CF App.
All: I am creating an application that requires user login. Users are all the employees within my organization, but not every user would use it; only some would. I would like to take advantage of the users' existing AD domain network logins so they don't have to keep track of another account. What they do is to login our organization's AD domain (different sever, different language) and AD would verify it and pass some kind of ID/token to my CF app. Is this possible and how can this be done? Any pointer is really appreciated. Thanks. Nathan Chen ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352020 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: runing CF and ASP.NET on the same web server (IIS 6)
Russ, it was the same error 404.17 even though I tried several things. Nathan -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: Monday, October 31, 2011 3:58 PM To: cf-talk Subject: RE: runing CF and ASP.NET on the same web server (IIS 6) Then it can't be anything to do with cf, what is the actual error you get. Regards Russ Michaels >From my mobile On 31 Oct 2011 21:45, "Nathan Chen" wrote: > > Russ, no, it still didn't work after disabled CF. > > Nathan > > -Original Message- > From: Russ Michaels [mailto:r...@michaels.me.uk] > Sent: Saturday, October 29, 2011 5:33 AM > To: cf-talk > Subject: Re: runing CF and ASP.NET on the same web server (IIS 6) > > > does the ASP pages work if you disable CF on that site ? > > On Sat, Oct 29, 2011 at 2:21 AM, Nathan Chen wrote: > > > > Thank you, Russ, Lincoln, and Ben, for the replies. > > > > I thought it might have to do with the mapping handler but wasn't sure. > > I did according to Russ' solution on his site, and it didn't work so > > I also added *.aspx handler by pointing to this file > > C:\Windows\Microsoft.NET\Framework\v4.0.30319\aspnet_isapi.dll > > > > but that didn't work either, still getting the same error. What else > > do I need to do? > > > > Nathan > > > > > > > > > > > > From: Ben Conner [mailto:b...@webworldinc.com] > > Sent: Wed 10/26/2011 8:48 PM > > To: cf-talk@houseoffusion.com > > Cc: Nathan Chen > > Subject: Re: runing CF and ASP.NET on the same web server (IIS 6) > > > > > > > > Gosh. I guess the mission-critical ASP sites I've been running on > > the > same > > server as CF for years don't work then. Good thing I found out. > > ;-) > > > > Seriously, when properly configured, IIS will call the ASP engine > > just > as it > > calls the CF engine at the appropriate time. In fact, a single site > > can > have > > both technologies deployed on it, intermixing pages from both. It > > isn't > pretty, > > but it will work. > > > > --Ben > > > > On 10/26/2011 3:03 PM, Nathan Chen wrote: > >> Dave, > >> > >> Thank you. Have you run both CF and ASP.NET on the same sever? > >> > >> I am trying to install a web program that we bought from a > >> vendor(written in ASP.NET). After installation I encountered "http > error > >> 404.17 - not found". I contacted the vendor and they said it would > >> not work if both are on the same web server. Here is what they said: > >> > >> > >> Cold Fusion is a web application framework that is installed on a > >> web server. It allows a developer to build web sites using a > >> simple set of tools and those websites, instead of running directly > >> on the web server, run on top of the Cold Fusion components installed on the server. > >> ASP.NET is the basic web application framework built into Windows > >> 2003 and Windows 2008 servers. In IIS, there is a configuration > >> file that defines the basic settings of ASP.NET. This > >> configuration file (called the "machine.config") is not to be tampered with generally. > >> Unfortunately, when Cold Fusion is installed, this configuration > >> file is altered drastically. Several core sections in the file are > >> removed or changed and some new sections are added. This renders > >> most newer ASP.NET web applications unable to run on the same > >> server. If these sections in this machine.config file are put back > >> to their default state, then the ASP.NET applications will run just > >> fine but Cold Fusion will no longer function. > >> - > >> > >> Nathan > >> > >> -Original Message- > >> > >> From: Dave Watts [mailto:dwa...@figleaf.com] > >> Sent: Wednesday, October 26, 2011 2:52 PM > >> To: cf-talk > >> Subject: Re: runing CF and ASP.NET on the same web server (IIS 6) > >> > >> > >>> If I set up a ASP.NET site along with my CF site under wwwroot, do > >>> I need to do anything special, or on separate port? > >> No, as long as CF is configured to use IIS. Of course, if either > >> application has resource contention issues, you might see them > >> earlier with both applications active. > >> > >> Dave Watts, CTO, Fig Leaf Software > >> http://www.figleaf.com/ > >> http://training.figleaf.com/ > >> > >> Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA > >> Schedule, and provides the highest caliber vendor-authorized > >> instruction at our training centers, online, or onsite. > >> > >> > >> > >> > > > > > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348411 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: runing CF and ASP.NET on the same web server (IIS 6)
Russ, no, it still didn't work after disabled CF. Nathan -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: Saturday, October 29, 2011 5:33 AM To: cf-talk Subject: Re: runing CF and ASP.NET on the same web server (IIS 6) does the ASP pages work if you disable CF on that site ? On Sat, Oct 29, 2011 at 2:21 AM, Nathan Chen wrote: > > Thank you, Russ, Lincoln, and Ben, for the replies. > > I thought it might have to do with the mapping handler but wasn't sure. > I did according to Russ' solution on his site, and it didn't work so I > also added *.aspx handler by pointing to this file > C:\Windows\Microsoft.NET\Framework\v4.0.30319\aspnet_isapi.dll > > but that didn't work either, still getting the same error. What else do > I need to do? > > Nathan > > > > > > From: Ben Conner [mailto:b...@webworldinc.com] > Sent: Wed 10/26/2011 8:48 PM > To: cf-talk@houseoffusion.com > Cc: Nathan Chen > Subject: Re: runing CF and ASP.NET on the same web server (IIS 6) > > > > Gosh. I guess the mission-critical ASP sites I've been running on the same > server as CF for years don't work then. Good thing I found out. ;-) > > Seriously, when properly configured, IIS will call the ASP engine just as it > calls the CF engine at the appropriate time. In fact, a single site can have > both technologies deployed on it, intermixing pages from both. It isn't > pretty, > but it will work. > > --Ben > > On 10/26/2011 3:03 PM, Nathan Chen wrote: >> Dave, >> >> Thank you. Have you run both CF and ASP.NET on the same sever? >> >> I am trying to install a web program that we bought from a >> vendor(written in ASP.NET). After installation I encountered "http error >> 404.17 - not found". I contacted the vendor and they said it would not >> work if both are on the same web server. Here is what they said: >> >> >> Cold Fusion is a web application framework that is installed on a web >> server. It allows a developer to build web sites using a simple set of >> tools and those websites, instead of running directly on the web server, >> run on top of the Cold Fusion components installed on the server. >> ASP.NET is the basic web application framework built into Windows 2003 >> and Windows 2008 servers. In IIS, there is a configuration file that >> defines the basic settings of ASP.NET. This configuration file (called >> the "machine.config") is not to be tampered with generally. >> Unfortunately, when Cold Fusion is installed, this configuration file is >> altered drastically. Several core sections in the file are removed or >> changed and some new sections are added. This renders most newer >> ASP.NET web applications unable to run on the same server. If these >> sections in this machine.config file are put back to their default >> state, then the ASP.NET applications will run just fine but Cold Fusion >> will no longer function. >> - >> >> Nathan >> >> -Original Message- >> >> From: Dave Watts [mailto:dwa...@figleaf.com] >> Sent: Wednesday, October 26, 2011 2:52 PM >> To: cf-talk >> Subject: Re: runing CF and ASP.NET on the same web server (IIS 6) >> >> >>> If I set up a ASP.NET site along with my CF site under wwwroot, do I >>> need to do anything special, or on separate port? >> No, as long as CF is configured to use IIS. Of course, if either >> application has resource contention issues, you might see them earlier >> with both applications active. >> >> Dave Watts, CTO, Fig Leaf Software >> http://www.figleaf.com/ >> http://training.figleaf.com/ >> >> Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on >> GSA Schedule, and provides the highest caliber vendor-authorized >> instruction at our training centers, online, or onsite. >> >> >> >> > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348379 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: runing CF and ASP.NET on the same web server (IIS 6)
Thank you, Russ, Lincoln, and Ben, for the replies. I thought it might have to do with the mapping handler but wasn't sure. I did according to Russ' solution on his site, and it didn't work so I also added *.aspx handler by pointing to this file C:\Windows\Microsoft.NET\Framework\v4.0.30319\aspnet_isapi.dll but that didn't work either, still getting the same error. What else do I need to do? Nathan From: Ben Conner [mailto:b...@webworldinc.com] Sent: Wed 10/26/2011 8:48 PM To: cf-talk@houseoffusion.com Cc: Nathan Chen Subject: Re: runing CF and ASP.NET on the same web server (IIS 6) Gosh. I guess the mission-critical ASP sites I've been running on the same server as CF for years don't work then. Good thing I found out. ;-) Seriously, when properly configured, IIS will call the ASP engine just as it calls the CF engine at the appropriate time. In fact, a single site can have both technologies deployed on it, intermixing pages from both. It isn't pretty, but it will work. --Ben On 10/26/2011 3:03 PM, Nathan Chen wrote: > Dave, > > Thank you. Have you run both CF and ASP.NET on the same sever? > > I am trying to install a web program that we bought from a > vendor(written in ASP.NET). After installation I encountered "http error > 404.17 - not found". I contacted the vendor and they said it would not > work if both are on the same web server. Here is what they said: > > > Cold Fusion is a web application framework that is installed on a web > server. It allows a developer to build web sites using a simple set of > tools and those websites, instead of running directly on the web server, > run on top of the Cold Fusion components installed on the server. > ASP.NET is the basic web application framework built into Windows 2003 > and Windows 2008 servers. In IIS, there is a configuration file that > defines the basic settings of ASP.NET. This configuration file (called > the "machine.config") is not to be tampered with generally. > Unfortunately, when Cold Fusion is installed, this configuration file is > altered drastically. Several core sections in the file are removed or > changed and some new sections are added. This renders most newer > ASP.NET web applications unable to run on the same server. If these > sections in this machine.config file are put back to their default > state, then the ASP.NET applications will run just fine but Cold Fusion > will no longer function. > - > > Nathan > > -Original Message- > > From: Dave Watts [mailto:dwa...@figleaf.com] > Sent: Wednesday, October 26, 2011 2:52 PM > To: cf-talk > Subject: Re: runing CF and ASP.NET on the same web server (IIS 6) > > >> If I set up a ASP.NET site along with my CF site under wwwroot, do I >> need to do anything special, or on separate port? > No, as long as CF is configured to use IIS. Of course, if either > application has resource contention issues, you might see them earlier > with both applications active. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > http://training.figleaf.com/ > > Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on > GSA Schedule, and provides the highest caliber vendor-authorized > instruction at our training centers, online, or onsite. > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348366 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: runing CF and ASP.NET on the same web server (IIS 6)
Thank you, Russ, Lincoln, and Ben, for the replies. I thought it might have to do with the mapping handler but wasn't sure. I did according to Russ' solution on his site, and it didn't work so I also added *.aspx handler by pointing to this file C:\Windows\Microsoft.NET\Framework\v4.0.30319\aspnet_isapi.dll but that didn't work either, still getting the same error. What else do I need to do? Nathan -Original Message- From: Ben Conner [mailto:b...@webworldinc.com] Sent: Wednesday, October 26, 2011 8:48 PM To: cf-talk@houseoffusion.com Cc: Nathan Chen Subject: Re: runing CF and ASP.NET on the same web server (IIS 6) Gosh. I guess the mission-critical ASP sites I've been running on the same server as CF for years don't work then. Good thing I found out. ;-) Seriously, when properly configured, IIS will call the ASP engine just as it calls the CF engine at the appropriate time. In fact, a single site can have both technologies deployed on it, intermixing pages from both. It isn't pretty, but it will work. --Ben On 10/26/2011 3:03 PM, Nathan Chen wrote: > Dave, > > Thank you. Have you run both CF and ASP.NET on the same sever? > > I am trying to install a web program that we bought from a > vendor(written in ASP.NET). After installation I encountered "http error > 404.17 - not found". I contacted the vendor and they said it would not > work if both are on the same web server. Here is what they said: > > > Cold Fusion is a web application framework that is installed on a web > server. It allows a developer to build web sites using a simple set of > tools and those websites, instead of running directly on the web server, > run on top of the Cold Fusion components installed on the server. > ASP.NET is the basic web application framework built into Windows 2003 > and Windows 2008 servers. In IIS, there is a configuration file that > defines the basic settings of ASP.NET. This configuration file (called > the "machine.config") is not to be tampered with generally. > Unfortunately, when Cold Fusion is installed, this configuration file is > altered drastically. Several core sections in the file are removed or > changed and some new sections are added. This renders most newer > ASP.NET web applications unable to run on the same server. If these > sections in this machine.config file are put back to their default > state, then the ASP.NET applications will run just fine but Cold Fusion > will no longer function. > - > > Nathan > > -Original Message- > > From: Dave Watts [mailto:dwa...@figleaf.com] > Sent: Wednesday, October 26, 2011 2:52 PM > To: cf-talk > Subject: Re: runing CF and ASP.NET on the same web server (IIS 6) > > >> If I set up a ASP.NET site along with my CF site under wwwroot, do I >> need to do anything special, or on separate port? > No, as long as CF is configured to use IIS. Of course, if either > application has resource contention issues, you might see them earlier > with both applications active. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > http://training.figleaf.com/ > > Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on > GSA Schedule, and provides the highest caliber vendor-authorized > instruction at our training centers, online, or onsite. > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348365 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: runing CF and ASP.NET on the same web server (IIS 6)
Dave, Thank you. Have you run both CF and ASP.NET on the same sever? I am trying to install a web program that we bought from a vendor(written in ASP.NET). After installation I encountered "http error 404.17 - not found". I contacted the vendor and they said it would not work if both are on the same web server. Here is what they said: Cold Fusion is a web application framework that is installed on a web server. It allows a developer to build web sites using a simple set of tools and those websites, instead of running directly on the web server, run on top of the Cold Fusion components installed on the server. ASP.NET is the basic web application framework built into Windows 2003 and Windows 2008 servers. In IIS, there is a configuration file that defines the basic settings of ASP.NET. This configuration file (called the "machine.config") is not to be tampered with generally. Unfortunately, when Cold Fusion is installed, this configuration file is altered drastically. Several core sections in the file are removed or changed and some new sections are added. This renders most newer ASP.NET web applications unable to run on the same server. If these sections in this machine.config file are put back to their default state, then the ASP.NET applications will run just fine but Cold Fusion will no longer function. - Nathan -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Wednesday, October 26, 2011 2:52 PM To: cf-talk Subject: Re: runing CF and ASP.NET on the same web server (IIS 6) > If I set up a ASP.NET site along with my CF site under wwwroot, do I > need to do anything special, or on separate port? No, as long as CF is configured to use IIS. Of course, if either application has resource contention issues, you might see them earlier with both applications active. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348356 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
runing CF and ASP.NET on the same web server (IIS 6)
All: If I set up a ASP.NET site along with my CF site under wwwroot, do I need to do anything special, or on separate port? Nathan Chen ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348354 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Why works in CF 8 , but not CF 9
Dave, thank you for the help. I copied /cfide/ directory to my site directory and pointed my pages to it, and it worked. Thanks. Nathan -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Wednesday, October 19, 2011 1:59 PM To: cf-talk Subject: Re: Why works in CF 8 , but not CF 9 > Yes, Dave, that's exactly what happened after I worked with my server > folks on this issue. What happened was that the site is being hosted in > a third party hosting company. Our server hits their server(some kind of > proxy) but that server doesn't have \cfide\ folder. I changed my around > and even copied the javascripts that puts in behind the > scene and changed the directories to make the hosting server come back > to it, but it wouldn't work. Have you had such problem before? Has > anyone seen this before? Use the SCRIPTSRC attribute of CFAJAXPROXY, and put the scripts in an accessible directory. http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=Tags_a -b_2.html http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=ajaxda ta_08.html Of course, I'm assuming that this is on a server that you control - I'm not sure what's being proxied where exactly. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348296 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Why works in CF 8 , but not CF 9
Yes, Dave, that's exactly what happened after I worked with my server folks on this issue. What happened was that the site is being hosted in a third party hosting company. Our server hits their server(some kind of proxy) but that server doesn't have \cfide\ folder. I changed my around and even copied the javascripts that puts in behind the scene and changed the directories to make the hosting server come back to it, but it wouldn't work. Have you had such problem before? Has anyone seen this before? Nathan -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Friday, October 14, 2011 5:40 PM To: cf-talk Subject: Re: Why works in CF 8 , but not CF 9 > I have a html table that lists people's names and the around the > name will open up a pop-up showing their bio. I use tags="cfwindow"> to make this happen. It works perfectly in CF 8 but > won't work in CF 9. Did I miss anything? The following code is just a > sample from the data pool. Your code worked for me as-is on CF 9. I suspect you have a /CFIDE mapping error in your web server. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348247 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Why works in CF 8 , but not CF 9
All: I have a html table that lists people's names and the around the name will open up a pop-up showing their bio. I use to make this happen. It works perfectly in CF 8 but won't work in CF 9. Did I miss anything? The following code is just a sample from the data pool. Has anyone experienced this? Nathan Chen -- Nathan Chen [some text here] 333-333- mailto:nathan.c...@cu.edu";>nathan.c...@cu.edu ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348072 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: How to fix the wrong time of the scheduled task on Admin
Wil and Robert, Thank you very much. It is a time zone issue although I didn't know what caused it. Someone posted a solution on web, and it worked. I changed the time zone to other time zone, restarted the server, reset the time zone to the correct one, restarted the server again, then it worked. It looks like restarting caused CF to recognize the server internal clock. Those who are more knowledgeable in CF can explain it better than I. Nathan -Original Message- From: Wil Genovese [mailto:jugg...@trunkful.com] Sent: Thursday, September 08, 2011 12:37 PM To: cf-talk Subject: Re: How to fix the wrong time of the scheduled task on Admin 1. do #now()# to get the time. 2. when was the last time the CF server was restarted? 3. when was the last time the server itself was restarted? 4. have you tried to delete and recreate the scheduled task? 5. has the server timezone setting changed at all? Wil Genovese Sr. Web Application Developer/ Systems Administrator CF Webtools www.cfwebtools.com wilg...@trunkful.com www.trunkful.com On Sep 8, 2011, at 1:33 PM, Nathan Chen wrote: > > All: > > > > First, I am not talking about tag; I am talking about the > scheduled task on CF Admin page under "Debugging & Logging" area. I have > a simple scheduled task, which used to run correctly based on the time I > defined(e.g. 12pm daily). But now it runs at 6am daily. I checked with > the server clock and it is correct. Does CF use another clock to do the > scheduling? If so, where can I find? If not, how to fix such error? (I > am on CF 8, IIS 6, Win 2008). > > > > Nathan Chen > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347348 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
How to fix the wrong time of the scheduled task on Admin
All: First, I am not talking about tag; I am talking about the scheduled task on CF Admin page under "Debugging & Logging" area. I have a simple scheduled task, which used to run correctly based on the time I defined(e.g. 12pm daily). But now it runs at 6am daily. I checked with the server clock and it is correct. Does CF use another clock to do the scheduling? If so, where can I find? If not, how to fix such error? (I am on CF 8, IIS 6, Win 2008). Nathan Chen ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:347337 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: cfmail doesn't work for cferror tag
Russ, Thanks for taking time to reply. The only thing I see on Admin (under Settings) is Missing Template Handler and Side-wide Error Handler. I am not sure if this is the right place that you were referring to? Or were you talking about another area I don't know? Nathan -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: Tuesday, August 16, 2011 2:44 PM To: cf-talk Subject: Re: cfmail doesn't work for cferror tag I think cferror may be limited as to what you can put in the error template, my memory is quite rusty but I think this is to avoid you causing an error in the error template. how about if you set error.cfm as the default error template in the cfadmin, does it work then ? I know this method has no restrictions and you can do whatever you like in the error template. On Tue, Aug 16, 2011 at 7:51 PM, Nathan Chen wrote: > > Hi, > > > > In my application.cfm I have: > > > template="error.cfm" > > type="exception" > > exception="any"> > > > > In my error.cfm page I have some friendly text for end users and plus > this: > > > > Text for myself here. > > > > > > I haven't even placed any #error.variable# insde the cfmail yet but the > result is that error.cfm gets displayed but wouldn't send out email to > me, and the mail.log on Admin doesn't record it. There is nothing in the > mail spool folder either. If I take the above cfmail portion and place > them in a separate cfm and run it, it does send out email. That means > the connection between this CF server(CF 8) and my organization's mail > server is ok. > > > Can anyone tell me if there is a syntax error here? > > > > > > Nathan > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346804 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfmail doesn't work for cferror tag
Hi, In my application.cfm I have: In my error.cfm page I have some friendly text for end users and plus this: Text for myself here. I haven't even placed any #error.variable# insde the cfmail yet but the result is that error.cfm gets displayed but wouldn't send out email to me, and the mail.log on Admin doesn't record it. There is nothing in the mail spool folder either. If I take the above cfmail portion and place them in a separate cfm and run it, it does send out email. That means the connection between this CF server(CF 8) and my organization's mail server is ok. Can anyone tell me if there is a syntax error here? Nathan ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346792 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CF 9 ODBC data source with Windows 2008 64-bit
Dave, I tried Oracle jdbc and it worked. Thank you very much for your time. Nathan -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Saturday, August 06, 2011 4:55 PM To: cf-talk Subject: Re: CF 9 ODBC data source with Windows 2008 64-bit > Actually what I am trying to do is to use JDBC by choosing "Other" > rather than "ODBC Socket" on CF Admin data source setup page, and what I > need are the values/syntax for these entries: > > JDBC URL: > Driver Class: > Driver Name: > > I looked the documentation but still don't know what to enter. Has > anyone done this before? The driver and class name will be drawn directly from the documentation. The documentation will contain examples of the JDBC URL, which you'll then have to change for your specifics (server name, port, username/password). Here's what I found from a Google search of "datadirect jdbc oracle example": http://media.datadirect.com/download/docs/connectsqlxml/jdbcug/jquiksta. htm JDBC URL: jdbc:datadirect:oracle://server_name:1521 Driver class: com.ddtek.jdbc.oracle.OracleDriver I don't think it matters what you enter for driver name, but I could be wrong there. Now, in addition to installing the driver, you have to actually set it up in the classpath for CF to be able to use it as well. And the DataDirect drivers aren't free - if you're using CF Standard, I recommend that you use Oracle's own JDBC driver instead. http://blog.razuna.com/2008/01/25/configure-the-jdbc-driver-for-oracle-o n-coldfusion-8-standard-edition/ Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346572 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CF 9 ODBC data source with Windows 2008 64-bit
Actually what I am trying to do is to use JDBC by choosing "Other" rather than "ODBC Socket" on CF Admin data source setup page, and what I need are the values/syntax for these entries: JDBC URL: Driver Class: Driver Name: I looked the documentation but still don't know what to enter. Has anyone done this before? Nathan Chen -Original Message- From: Nathan Chen [mailto:nathan.c...@cu.edu] Sent: Thursday, August 04, 2011 1:08 PM To: cf-talk Subject: RE: CF 9 ODBC data source with Windows 2008 64-bit Dave and All: I downloaded and installed JDBC 4.2 from DataDirect site. Now I am not sure what the strings on the CF Admin data source setup page should look like. I select "Other" on the driver drop-down and on the second page: should I enter these? JDBC URL: jdbc:oracle:@myDBServer.myDomain.com:ORCL Driver Class: oralce.jbdc.OracleDriver Driver Name: oracle.jar How about the connection string field in the advanced settings section? Can someone who has done this before help me out? I am using Oracle 10g and Win 2008 R2 64-bit. Nathan -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Monday, July 25, 2011 11:20 AM To: cf-talk Subject: Re: CF 9 ODBC data source with Windows 2008 64-bit > I am guessing this issue has been discussed but I just haven't followed > it. In my production server(Windows 2008 R2 64-bit), I installed Oracle > 11g client and I was able to connect to my Oracle 10g DB via the odbc > DSN I created. But when I went to CF Admin and tried to create a DSN > using ODBC Socket driver, it gives me this mismatch error. Is it possible for you to use the JDBC driver instead - either CF (DataDirect) or Oracle? If not, you'll need to download and install a 64-bit Oracle ODBC driver, if such a thing exists. But I'd recommend using JDBC if at all possible. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346557 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CF 9 ODBC data source with Windows 2008 64-bit
Dave, I am using Standard. Nathan -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Thursday, August 04, 2011 1:19 PM To: cf-talk Subject: Re: CF 9 ODBC data source with Windows 2008 64-bit > > Is it possible for you to use the JDBC driver instead - either CF > > (DataDirect) or Oracle? > > I downloaded and installed JDBC 4.2 from DataDirect site. Are you using CF Enterprise or Standard? If you're using Enterprise, you don't have to download anything - it's included with CF. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346536 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CF 9 ODBC data source with Windows 2008 64-bit
Dave and All: I downloaded and installed JDBC 4.2 from DataDirect site. Now I am not sure what the strings on the CF Admin data source setup page should look like. I select "Other" on the driver drop-down and on the second page: should I enter these? JDBC URL: jdbc:oracle:@myDBServer.myDomain.com:ORCL Driver Class: oralce.jbdc.OracleDriver Driver Name: oracle.jar How about the connection string field in the advanced settings section? Can someone who has done this before help me out? I am using Oracle 10g and Win 2008 R2 64-bit. Nathan -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Monday, July 25, 2011 11:20 AM To: cf-talk Subject: Re: CF 9 ODBC data source with Windows 2008 64-bit > I am guessing this issue has been discussed but I just haven't followed > it. In my production server(Windows 2008 R2 64-bit), I installed Oracle > 11g client and I was able to connect to my Oracle 10g DB via the odbc > DSN I created. But when I went to CF Admin and tried to create a DSN > using ODBC Socket driver, it gives me this mismatch error. Is it possible for you to use the JDBC driver instead - either CF (DataDirect) or Oracle? If not, you'll need to download and install a 64-bit Oracle ODBC driver, if such a thing exists. But I'd recommend using JDBC if at all possible. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346529 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF 9 ODBC data source with Windows 2008 64-bit
All: I am guessing this issue has been discussed but I just haven't followed it. In my production server(Windows 2008 R2 64-bit), I installed Oracle 11g client and I was able to connect to my Oracle 10g DB via the odbc DSN I created. But when I went to CF Admin and tried to create a DSN using ODBC Socket driver, it gives me this mismatch error. java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket]internal error: The specified DSN contains an architecture mismatch between the Driver and Application The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket]internal error: The specified DSN contains an architecture mismatch between the Driver and Application -- I also tried running odbcad32 under SysWow64 folder on Windows using Microsoft ODBC for Oracle, but it gave me an error saying The Oracle client and networking components were not found. Anybody has solved this before? Nathan ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346322 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
(ot) IIS doesn't display html
All: I have a site that runs on Win 2008, IIS 6 with CF 8. I upgraded it to CF 9. On that site there are html and cfm pages mixed together. After the upgrade, cfm pages are fine but none of the html pages get displayed; it simply said page not found. Can someone give me some pointers on how to trouble shoot IIS 6? What are the possible causes? Thanks a lot. Nathan Chen ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343896 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
left outer join in query of query
All: I am on CF 8 now. Does anyone know if CF 9 supports left outer join in query of query? CF 8 doesn't allow left outer join. Nathan Chen ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338524 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: (ot) IIS 7 renders htm but not html
Never mind, I found the problem. It was the permission under Handler Mappings that wasn't set to script. Thank you. Nathan Chen -Original Message- From: Nathan Chen [mailto:nathan.c...@cu.edu] Sent: Tuesday, September 14, 2010 11:24 AM To: cf-talk Subject: (ot) IIS 7 renders htm but not html All: Sorry for the OT but I have been researching this very simple issue: I upgraded from IIS 6 with Windows 2003 to IIS 7on Windows 2008 and the new IIS 7 renders cfm, asp, htm files, but not html files. I went to the places on IIS 7 I know to make sure .html extension, MIME type, handler mapping all associated with html. But it just won't work. What else do I need to look? Nathan Chen ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337008 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
(ot) IIS 7 renders htm but not html
All: Sorry for the OT but I have been researching this very simple issue: I upgraded from IIS 6 with Windows 2003 to IIS 7on Windows 2008 and the new IIS 7 renders cfm, asp, htm files, but not html files. I went to the places on IIS 7 I know to make sure .html extension, MIME type, handler mapping all associated with html. But it just won't work. What else do I need to look? Nathan Chen ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337001 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Upgrade to Windows 2008 server with IIS 7 while still running CF 8
All: Has anyone experienced any problem when upgrading the server to Windows 2008 with IIS 7 while keeping CF 8? My IT is planning the upgrade but I am still running CF 8 and would like to know any issue so I can be prepared. Nathan Chen ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336733 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Has anyone experienced a blank screen created by ColdFusion.Window.Create?
All: I have a page that has a href like this: Count I do haveand before it. On the MyTestPage.cfm, it has a simple and a to display the query result. When the is clicked, the window shows up but displays a blank page. If I resize the window a little bit by clicking the edge of the window, then the query result shows up perfectly. Has anyone seen this before? What's the solution? Nathan Chen ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334970 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Has anyone experienced a blank screen created by ColdFusion.Window.Create?
I forgot to mention an important thing. This doesn't happen in FireFox, just in IE 8.0. Most my users use IE. Is this just an IE thing? Nathan From: Nathan Chen Sent: Wednesday, June 30, 2010 12:11 PM To: cf-talk@houseoffusion.com Subject: Has anyone experienced a blank screen created by ColdFusion.Window.Create? All: I have a page that has a href like this: Count I do haveand before it. On the MyTestPage.cfm, it has a simple and a to display the query result. When the is clicked, the window shows up but displays a blank page. If I resize the window a little bit by clicking the edge of the window, then the query result shows up perfectly. Has anyone seen this before? What's the solution? Nathan Chen ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334968 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
What is the version of Java SDK CF should use?
All: I am using CF 8 and the System Info page shows the Java Version is 1.6.0_01 and Java VM Version is 1.6.0_01b-06. Is that the latest java CF should use? If not, what's the latest one? Is it the Version 6 Update 20 on java.com? Nathan Chen ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333624 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: How to query encrypted password
Yes, and it is in Oracle 11g. Nathan -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Tuesday, January 05, 2010 9:05 PM To: cf-talk Subject: Re: How to query encrypted password > I need to query an Oracle user table where username and encrypted > password are stored. I need to compare the user input password with the > encrypted password in the table. Can the CF Decrypt function do the > work? Can someone give me a pointer? How was the password encrypted in the first place? 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! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329438 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
How to query encrypted password
All: I need to query an Oracle user table where username and encrypted password are stored. I need to compare the user input password with the encrypted password in the table. Can the CF Decrypt function do the work? Can someone give me a pointer? Nathan ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329427 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
how to detect user login attempts
Hi, All: This might have been asked but I am not experienced CF programmer so I need help. I am building a login module that requires detecting user login attempts. After the user fails after three tries, the acct will be suspended. Has anything been done, e.g, tags, components, custom tag? Can anyone point me to the right direction? Thanks. Nathan ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327404 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
How to clear local cache when users logout
All: How do you clear users' local cache after they log out and the session variable is cleared? I can clear the session on the server, but if users click the Back button, they can still get back and that's not what I want. This must have been discussed but I guess I missed. Nathan Chen ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326613 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Is this possible with component methods in cf8?
Dave, you mentioned about checking virus on the uploaded files on No.4 below. How do you do that, via virus program on the server? Nathan -Original Message- From: Dave l [mailto:cfl...@jamwerx.com] Sent: Monday, September 14, 2009 2:37 PM To: cf-talk Subject: Re: Is this possible with component methods in cf8? oh no! swfupload is ok but has some issues and limitations and it's not jquery which makes interacting with it a bit more difficult. I'm making a fairly sweet uploader in jquery and ended up using uploadify as the base uploader but I alter the source code. As far as the original question as to reporting back.. sure you can do it but use writeoutput to send data back to js script but you need the js script to update on change or look for change in intervals. The one i'm making does: 1. uploads 2. checks mime 3. checks size 4. runs a virus check 5. renames to a uuid 6. if image converts to png to remove excess exif data without losing quality 7. stops and returns to script to add description 8. then does an ajax submit with info on resizing and thumbs, final output format 9. checks destination folders to see if they exist, if not creates them 10. converts image to output desired 11. makes large web size and moves it to destination folder 12. makes thumb and moves it 13. deletes originals 14. checks upload folders (on separate hd) and looks for stay files and deletes them if found each step is reported back here is an example from cfc on it /* *** CHECK MIME TYPE check uploads mime type and error if not accepted or continue procesing *** */ ckMimeTypeObj = createObject("component","img_util").ckMimeType( ckFile = locFile, allowedMimeTypes = variables.attributes.allowedMimeTypes ); /* *** MIME RESULTS check upload mime results, show error and stop processing or set var's and continue processing *** */ if(ckMimeTypeObj.status == 0){ result.status = ckMimeTypeObj.status; result.message = ckMimeTypeObj.message; writeOutput(SerializeJSON(result)); abortObj = createObject("component", "cfc.utilities").abort(); } else { var uploadedFileSize = variables.attributes.maxUploadSize; result.status = ckMimeTypeObj.status; result.message = ckMimeTypeObj.message; } ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326318 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF validation working with JS validation
Charlie, Thank you so much. It works! Nathan From: Charlie Griefer [mailto:charlie.grie...@gmail.com] Sent: Wed 7/8/2009 4:15 PM To: cf-talk Subject: Re: CF validation working with JS validation On Wed, Jul 8, 2009 at 3:08 PM, Nathan Chen wrote: > > I wonder if I missed something when I mixed JavaScript code with CFInput > tag. Please see my code below. I placed the "required" and "message" in > cfinput. It works fine. But I need to search the user input string and > find if certain value exists, e.g "something". Since I don't know how to > do it in CF, I created a JS. The problem is that it rolls to the next > page(meaning submits the form) rather than return false. > > > > > function check () > { > > var e = document.forms[0].s.value.toLowerCase(); > > if (e.match("something") == null) >{ >alert("You have to type the word SOMETHING.") >document.forms[0].s.focus(); >return false; >} > } > > > > > > > One of the reasons I stopped using cfform many many years ago is that it often interfered with my own JS. With that disclaimer out of the way... remove the 'onclick' from your submit. change your tag to this: you might also want to add an "else" into your check() function to return true. -- I have failed as much as I have succeeded. But I love my life. I love my wife. And I wish you my kind of success. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324374 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF validation working with JS validation
Hi, All: I wonder if I missed something when I mixed JavaScript code with CFInput tag. Please see my code below. I placed the "required" and "message" in cfinput. It works fine. But I need to search the user input string and find if certain value exists, e.g "something". Since I don't know how to do it in CF, I created a JS. The problem is that it rolls to the next page(meaning submits the form) rather than return false. Has anyone seen such issue or just me missing something? Nathan Chen function check () { var e = document.forms[0].s.value.toLowerCase(); if (e.match("something") == null) { alert("You have to type the word SOMETHING.") document.forms[0].s.focus(); return false; } } -- ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324359 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Detect data change in cfform
Maybe I wasn't clear. Sometimes users would make some changes and then click the cancel button by mistake and find out they lose the changes. I need a routine that detects if data have been altered. Nathan -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Friday, June 26, 2009 11:09 AM To: cf-talk Subject: Re: Detect data change in cfform > I am building a form that allows users to edit data retrieved from > multiple tables. There are many fields in the form. If the users don't > change anything and hit the cancel button, then I don't need to do the > update, otherwise several sql update statements will be executed. Is > there an easy way to detect if users have made changes to the data in > cfform rather than comparing each field to the original data? Not really, but why would your cancel button submit the form? Simply have it do something else, like redirect the user to the previous screen. 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! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324003 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Detect data change in cfform
Hi, All: I am building a form that allows users to edit data retrieved from multiple tables. There are many fields in the form. If the users don't change anything and hit the cancel button, then I don't need to do the update, otherwise several sql update statements will be executed. Is there an easy way to detect if users have made changes to the data in cfform rather than comparing each field to the original data? Nathan ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323984 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: convert doc file to html file
Gerald, Thank you very much! The COM object example works really well for me. Nathan -Original Message- From: Gerald Guido [mailto:gerald.gu...@gmail.com] Sent: Wednesday, April 01, 2009 3:58 PM To: cf-talk Subject: Re: convert doc file to html file In theory you can use a COM object to do this if word is installed on the server. http://livedocs.adobe.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/ht ml/wwhelp.htm?context=ColdFusion_Documentation&file=1585.htm If not I would look for a Java alternative like POI http://poi.apache.org/ or a third party COM object if you are on Windows. G! On Mon, Mar 30, 2009 at 12:56 AM, Nathan Chen wrote: > > Hi, Everyone: > > > > Is there a tag or tool that can convert a Word file to an html file? > Let's say, the end user uploads a doc file, the tag/scripts/tool reads > the file, converts it to html, and saves it in a pre-defined directory > on the server. I need a tool like this to complete one of my projects. > Thanks. > > > > Nathan > > > > ~| 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:321317 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: convert doc file to html file
Scott, That's the step the end users try to avoid. They want something on the fly, letting CF to do the trick automatically after the file is uploaded. Nathan -Original Message- From: Scott Stewart [mailto:sstwebwo...@bellsouth.net] Sent: Wednesday, April 01, 2009 2:49 PM To: cf-talk Subject: RE: convert doc file to html file 1) Open in MS Word and save as html 2) Open in Dreamweaver and use the cleanup tool Commands => Cleanup Word HTML -- Scott Stewart ColdFusion Developer http://www.sstwebworks.com 4405 Oakshyre Way Raleigh, NC 27616 Phone: 919-874-6229 Cell: 703-220-2835 -Original Message- From: Nathan Chen [mailto:nathan.c...@cu.edu] Sent: Wednesday, April 01, 2009 3:20 PM To: cf-talk Subject: RE: convert doc file to html file So does anyone know this or is this something not available? Nathan -Original Message- From: Nathan Chen [mailto:nathan.c...@cu.edu] Sent: Sunday, March 29, 2009 10:56 PM To: cf-talk Subject: convert doc file to html file Hi, Everyone: Is there a tag or tool that can convert a Word file to an html file? Let's say, the end user uploads a doc file, the tag/scripts/tool reads the file, converts it to html, and saves it in a pre-defined directory on the server. I need a tool like this to complete one of my projects. Thanks. Nathan ~| 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:321198 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: convert doc file to html file
So does anyone know this or is this something not available? Nathan -Original Message- From: Nathan Chen [mailto:nathan.c...@cu.edu] Sent: Sunday, March 29, 2009 10:56 PM To: cf-talk Subject: convert doc file to html file Hi, Everyone: Is there a tag or tool that can convert a Word file to an html file? Let's say, the end user uploads a doc file, the tag/scripts/tool reads the file, converts it to html, and saves it in a pre-defined directory on the server. I need a tool like this to complete one of my projects. Thanks. Nathan ~| 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:321195 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
convert doc file to html file
Hi, Everyone: Is there a tag or tool that can convert a Word file to an html file? Let's say, the end user uploads a doc file, the tag/scripts/tool reads the file, converts it to html, and saves it in a pre-defined directory on the server. I need a tool like this to complete one of my projects. Thanks. Nathan ~| 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:321086 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
populate cfselect based on onClick of a radio button
Hi, All: This might be a simple issue but my knowledge just runs out. I have 3 Select MyField from mytable where myID = 'B' Select Myfiled from mytable where myID= 'C' What I need is to pass the value "A", "B", or "C" from one of the to so that the "query" inside would be query="A", or query="B", or query="C". I know I have to do a onClick inside but how do I pass the value? Is there any CF tag that does this? Any pointer is appreciated. Nathan Chen ~| 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:318898 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFContent tag
That's it. I can't believe I forgot to turn "enable BlOB" when I updated the dsn today. Thank you! Nathan -Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: Saturday, August 16, 2008 9:47 PM To: CF-Talk Subject: Re: CFContent tag First, check that your datasource has the "enable BLOB" checkbox ticked. On Sun, Aug 17, 2008 at 11:44 AM, Nathan Chen wrote: > Hi, All: > > I have a query that selects a BLOB field (embedded file) from a table. > Then I use cfcontent to output the string to the browser. The code has > running fine until today all of a sudden it won't display the files. All > the files in that BLOB field are pdf files. The code looks like this: > > > > SELECT contents > > FROM DOCUMENT > > where Document.PrimaryKey=#url.DocPK# > > > > reset="yes"> > > When the page is run, Adobe Reader is open but with an error message > saying "The file is damaged and could not be repaired." When things like > this happen, where should I look into it? Thanks. -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311140 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFContent tag
Hi, All: I have a query that selects a BLOB field (embedded file) from a table. Then I use cfcontent to output the string to the browser. The code has running fine until today all of a sudden it won't display the files. All the files in that BLOB field are pdf files. The code looks like this: SELECT contents FROM DOCUMENT where Document.PrimaryKey=#url.DocPK# When the page is run, Adobe Reader is open but with an error message saying "The file is damaged and could not be repaired." When things like this happen, where should I look into it? Thanks. Nathan ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311136 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
upgrade java in CF
Hi, All: Does anyone know if it is ok to upgrade the current Java version(1.4.2_09) to the newest java 1.5.0_06? My network security guys found a vulnerability on my CF server and would like to upgrade to 1.5.0_06. Does anyone know the upgrade will affect anything? Nathan Chen ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273043 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Storing Documents
Hi, All: Has anyone successfully outputted blob field to a CF template? How did you do it? Nathan -Original Message- From: Zaphod Beeblebrox [mailto:[EMAIL PROTECTED] Sent: Friday, February 10, 2006 12:53 PM To: CF-Talk Subject: Re: Storing Documents I'm currently working on a real estate done in RubyOnRails that stores property photos in tables. So far it doesn't seem too terribly different than mssql. On 2/10/06, Ryan Guill <[EMAIL PROTECTED]> wrote: > Has anyone done this in MySql? > > On 2/10/06, Zaphod Beeblebrox <[EMAIL PROTECTED]> wrote: > > We just recently set up a document management system using MS > > SqlServer. We ended up storing the documents inside the db. The way > > we structured it was to set up a table that had all of the meta data > > about the document along with a file id (int) that linked up with a > > file storage table that consisted of an id and a blob column. This > > way, we can run queries against the meta data without slowing down the > > system with large blob columns. > > > > So far, the performance has been suprisingly snappy. Also, security > > has been a lot easier to work into as we only have to secure one > > resource instead of both a database and a file system. Another > > additional benefit is that we've been able to share some documents on > > our extranet site without having to open another port for file sharing > > as all documents come from the db. > > > > > > > > On 2/10/06, Michael T. Tangorre <[EMAIL PROTECTED]> wrote: > > > I have never stored actual documents in SQL Server. I have stored the name > > > and location and put the document into a directory on the file server. > > > However, a new "contracts" application I am working on is very document > > > heavy, mainly for storage... not much retrieval will be done. > > > > > > Currently when a new contract comes to be, a directory is created for the > > > contract and a slew of sub directories are also created over the life of the > > > contract. Sometimes the sub directories are standard across contracts and > > > some times they are not. Sub directories can get pretty deep in terms of > > > nesting. > > > > > > It seems it would be much easier (conceptually) to store the documents > > > directly in the database and let the structure of the database dictate the > > > "hierarchy" and relationships instead of creating a new directory for each > > > contract and trying to figure out which subdirectories are needed or already > > > exist, etc. > > > > > > When needed, the documents would be accessed via the application... however > > > this would restrict direct access to the document outside the system. > > > Anyway, has anyone taken the approach of storing documents directly in a SQL > > > DB, and if so, how was performance etc... > > > > > > Thanks! > > > > > > Tango > > > > > > > > > > > > > > > > > > ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272250 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Storing Documents
Hi, All: I have an application that requires storing documents inside Oracle 10g. I am having hard time knowing how to output the blob field to a CF template. Has anyone done this before? Say, I have records: ID Title Content (Content is the blob field that stores the document, e.g. pdf file) How do I output Content field directly to CF template? Any pointer is appreciated. Nathan Chen -Original Message- From: Zaphod Beeblebrox [mailto:[EMAIL PROTECTED] Sent: Friday, February 10, 2006 12:53 PM To: CF-Talk Subject: Re: Storing Documents I'm currently working on a real estate done in RubyOnRails that stores property photos in tables. So far it doesn't seem too terribly different than mssql. On 2/10/06, Ryan Guill <[EMAIL PROTECTED]> wrote: > Has anyone done this in MySql? > > On 2/10/06, Zaphod Beeblebrox <[EMAIL PROTECTED]> wrote: > > We just recently set up a document management system using MS > > SqlServer. We ended up storing the documents inside the db. The way > > we structured it was to set up a table that had all of the meta data > > about the document along with a file id (int) that linked up with a > > file storage table that consisted of an id and a blob column. This > > way, we can run queries against the meta data without slowing down the > > system with large blob columns. > > > > So far, the performance has been suprisingly snappy. Also, security > > has been a lot easier to work into as we only have to secure one > > resource instead of both a database and a file system. Another > > additional benefit is that we've been able to share some documents on > > our extranet site without having to open another port for file sharing > > as all documents come from the db. > > > > > > > > On 2/10/06, Michael T. Tangorre <[EMAIL PROTECTED]> wrote: > > > I have never stored actual documents in SQL Server. I have stored the name > > > and location and put the document into a directory on the file server. > > > However, a new "contracts" application I am working on is very document > > > heavy, mainly for storage... not much retrieval will be done. > > > > > > Currently when a new contract comes to be, a directory is created for the > > > contract and a slew of sub directories are also created over the life of the > > > contract. Sometimes the sub directories are standard across contracts and > > > some times they are not. Sub directories can get pretty deep in terms of > > > nesting. > > > > > > It seems it would be much easier (conceptually) to store the documents > > > directly in the database and let the structure of the database dictate the > > > "hierarchy" and relationships instead of creating a new directory for each > > > contract and trying to figure out which subdirectories are needed or already > > > exist, etc. > > > > > > When needed, the documents would be accessed via the application... however > > > this would restrict direct access to the document outside the system. > > > Anyway, has anyone taken the approach of storing documents directly in a SQL > > > DB, and if so, how was performance etc... > > > > > > Thanks! > > > > > > Tango > > > > > > > > > > > > > > > > > > ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272248 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
display Blob field
Hi, All: If I store files in Blob field in Oracle(10g), is there a way to output the entire file(e.g. pdf, Word) to the browser using ? If so, can someone give me an example? I was told that it is possible but am having hard time figuring it out. Nathan Chen ~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272204 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
file download in cfm file
Hi, All: I have a simple in a cfm file. It works on my local machine but won't work on the server(Windows 2003, with IIS 6). I got this message that many of you probably have seen before. == Internet Explorer cannot download from Internet Explorer was not able to open this Internet site. The requested site is either unavailable or cannot be found. Please try again later. == I did check the file name and path and they are all correct. I even placed it in html file and it works in html. Do I need to change some setting to make it work? Nathan Chen ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269864 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Is there a way to maintain formated text
Yes, Aaron was right. I didn't state clearly. I pasted the text into the field and the html and formatted stuff went away. The FCKeditor Ray pointed to will be helpful. --Nathan -Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 08, 2006 9:49 PM To: CF-Talk Subject: Re: Is there a way to maintain formated text I'd think that it was maybe bold in a Word doc and then copy n pasted into a text area at which point it lost its formating. On 2/8/06, Claude Schneegans <[EMAIL PROTECTED]> wrote: > > >>Sometimes the original text contains formated > text such as words in bold, with bullet points, and even with url behind > it. When the text goes to the database, they are stripped away. > > How come? HTML is pure texte, database fields that can take text can > take HTML. > Who strips the code away? > > -- > ___ > REUSE CODE! Use custom tags; > See http://www.contentbox.com/claude/customtags/tagstore.cfm > (Please send any spam to this address: [EMAIL PROTECTED]) > Thanks. > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231736 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Is there a way to maintain formated text
Hi, Ray, Thank you! This looks very powerful. I'll have to play with it and might have more questions. Nathan Chen -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 08, 2006 5:16 PM To: CF-Talk Subject: Re: Is there a way to maintain formated text Hi Nathan: Check out FCKEditor. http://www.sourceforge.net http://sourceforge.net/projects/fckeditor/ Nathan Chen wrote: > Hi, > > > > I am trying to build a program that allows end users to submit short > news articles to a database field. The program would serve the text in > the field to a cfm page. Sometimes the original text contains formated > text such as words in bold, with bullet points, and even with url behind > it. When the text goes to the database, they are stripped away. Is there > a way to maintain those format and the cfm page can display them well? > > > > Any help is appreciated. > > > > Nathan Chen > > > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231700 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Is there a way to maintain formated text
Hi, I am trying to build a program that allows end users to submit short news articles to a database field. The program would serve the text in the field to a cfm page. Sometimes the original text contains formated text such as words in bold, with bullet points, and even with url behind it. When the text goes to the database, they are stripped away. Is there a way to maintain those format and the cfm page can display them well? Any help is appreciated. Nathan Chen ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231693 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
OT: Foxpro issue
Hi, All: Sorry for this OT, but I really need to know if there is an ODBC driver available for Foxpro 2.6 database(I know it is very old). I am trying to convert Foxpro 2.6 to SQL 7.0 and I can't find anything on Microsoft web site. Nathan FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Using XML as data source
Hi, Everyone: I have a client who is very concerned about the security of his database. He needs an application that involves with customers' bank accounts and credit card numbers. He wants to use XML files generated from his database and make them available for downloading every time my application runs. When the application is done with updating the data, the application sends the XML files back to the server. Besides the security reason, are there benefits of taking this approach? How can CF application read XML and do the data processing such as update, delete, and then output the result to an XML file? Can WDDX do the entire process for me? Thanks for any tip. Nathan __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: How to make CFFTP work
Will, No, but I put the full path for the "localfile" and it worked. What is passive connection anyway? caching? Nathan - Original Message - From: "W Luke" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, March 22, 2002 2:41 PM Subject: Re: How to make CFFTP work > Nathan, > > Have you tried using Passive connections? > > Will > > > I have the following codes that are not working. I am trying to > > send a file to a ftp server. The codes run but the file doesn't get > > moved to the ftp server. This is the first time I used and I > > must have missed something basic. Can anyone spot the problem? Thanks. > > > > > action="open" > > username="myusername" > > password="mypassword" > > server="111.111.111.111" > > > > > > action="putfile" > > localfile="Test.cfm" > > remotefile="test.cfm" > > server="111.111.111.111" > > directory="mydirectory" > > stoponerror="yes" > > > > > > > > > > > Nathan Chen > > > > > > FAQ: http://www.thenetprofits.co.uk/coldfusion/faq > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists > > > > __ > > LocalBounty.com - Advanced Advertising Solutions for the home and business > > Why not Pingo your photos for free? > > http://www.localbounty.com/pingo > __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
How to make CFFTP work
Hi, Everyone: I have the following codes that are not working. I am trying to send a file to a ftp server. The codes run but the file doesn't get moved to the ftp server. This is the first time I used and I must have missed something basic. Can anyone spot the problem? Thanks. Nathan Chen FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL help please
I think if you have to group by all the fields you select. try select ... count(paycatid) as samepaycatid group by paycatid,employeeid, startdate, enddate - Original Message - From: <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, March 13, 2002 4:10 PM Subject: Re: SQL help please > Nope, that doesn't work. > > - Original Message - > From: laszlo <[EMAIL PROTECTED]> > Date: Wednesday, March 13, 2002 4:06 pm > Subject: Re: SQL help please > > > select ... count(paycatid) as samepaycatid group by paycatid > > > > laszlo > > > > > > [EMAIL PROTECTED] wrote: > > > > > Anyone? > > > > > > Bueller? Bueller? > > > > > > - Original Message - > > > From: [EMAIL PROTECTED] > > > Date: Wednesday, March 13, 2002 2:51 pm > > > Subject: SQL help please > > > > > > > Brain not working Must help... > > > > > > > > Here's my data set: > > > > > > > > employeeid startdate enddate paycatid > > > > --- --- --- --- > > > > 936 2002-02-08 2002-02-08 1 > > > > 936 2002-02-11 2002-02-11 1 > > > > 936 2002-02-12 2002-02-12 1 > > > > 936 2002-02-13 2002-02-13 11 > > > > 936 2002-02-14 2002-02-14 1 > > > > 936 2002-02-15 2002-02-15 1 > > > > 936 2002-02-18 2002-02-18 11 > > > > 936 2002-02-19 2002-02-19 11 > > > > 936 2002-02-20 2002-02-20 11 > > > > 936 2002-02-21 2002-02-21 11 > > > > 936 2002-02-22 2002-02-22 11 > > > > 936 2002-02-25 2002-02-25 7 > > > > 936 2002-02-27 2002-02-27 7 > > > > > > > > What I'm wondering is how do I get something like: > > > > > > > > employeeid startdate enddate same paycatid in a row paycatid > > > > --- --- --- --- -- > > > > 936 2002-02-08 2002-02-12 3 1 > > > > 936 2002-02-13 2002-02-13 1 11 > > > > 936 2002-02-14 2002-02-15 2 1 > > > > 936 2002-02-18 2002-02-22 5 11 > > > > 936 2002-02-25 2002-02-27 2 7 > > > > > > > > I'm using SQL Server 7. > > > > > > > > > > > > > > > > > > __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
basics about how CF works with XML
Hi, Can anyone give me an idea or a site that describes how CF server reads XML files that contain data and how CF updates the data in those XML files? Nathan __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: is there a way to get a count of elements in a list??
Do you need to count the how many items in a list? If so, use function ListLen. Nathan Chen - Original Message - From: "Jeff Fongemie" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, March 10, 2002 5:37 PM Subject: is there a way to get a count of elements in a list?? > Hello everyone, > > I have a list that is populated by a form sumbit and it looks like > this, but will have more names. > > > > Is there a way to count the elements in that list? > > I have a form with 10 name textboxes. A user may only submit 2. So > my namelist will be jo, bob,,. > > What I would like is something like, and the existing functions do > not seem to help with this: > > CFSET numberofelelents =numberofelents(namelist) > > > Best regards, > Jeff Fongemie mailto:[EMAIL PROTECTED] > > __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
ODBC for Interbase
Hi, All: Does anyone has experience working with Interbase database? I assume you need an ODBC driver for CF Server to talk to Interbase. Where can I get the driver? Any hint is appreciated. Nathan Chen __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: e-commerce package
Hi, All: Can you anyone suggest a good, off-shelf e-commerce package? Someone told me that Mr Ben Forta has "quick store". Is that right? Where can I find it? Nathan __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Current URL?
Try Nathan - Original Message - From: "Cornillon, Matthieu" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, February 18, 2002 11:50 AM Subject: Current URL? > Hi, everyone. I feel silly for asking such a simple question, but I can't > find the definitive answer. Is there a sure-fire way to pull the URL of the > currently displayed page? I can hack it out using CGI variables, but I was > thinking that there is probably a CF reserved variable that I'm just missing > that gives me the whole thing, from "http://"; right out the the last > character of the query string. Anyone know what that is? > > Thanks, > __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Session variable vs. other variables
Joseph, Thank you so much! nathan - Original Message - From: "Joseph Thompson" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, February 17, 2002 11:40 PM Subject: Re: Session variable vs. other variables > Extending the sessions can be done a number of ways... You can use > JavaScript embeded in a page to connect to the server every now and then. > The end result is that a user stays "logged in" until they close thier > browser. > > I found depressedpress.com's "gif as a data pipe" an excellent method. If > you want to extend your session using that technique I put a "custom" tag > together that you can download from here: > > Intro: > http://cfhub.com/forum//index.cfm?FuseAction=Thread&TopicID=2445 > Download: > http://cfhub.com/forum/attachments/KeepAlive.zip > > > Hi, All: > >I don't have the control over the setting of session variable expiration > time on CF server > >Any idea is appreciated. > > > > Nathan Chen > > __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Session variable vs. other variables
Jim, Thank you very much for the information. nathan - Original Message - From: "Jim McAtee" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, February 17, 2002 11:16 PM Subject: Re: Session variable vs. other variables > Nathan, > > You can override the server's default session timeout value by using > cfapplication and the tag's sessiontimeout attribute. Besides the server > default timeout, there's also a maximum timeout value set at the server > level. If you want to set it much higher than 20 minutes, you probably want > to find out from the server's administrators what the maximum value is. > > You _could_ control how long a user can stay on the site, though. Just set > a session variable with the login time. As part of your authentication > security, compare the current time against the login time and kick the user > off if they've overstayed. If that was was what you had in mind. > > "If the session expires, then the users can't go anywhere." > > Usually, you display a message telling the user that they're not logged in > and direct them back to the login screen, allowing them to login again. The > only time I can see a problem with that is if you were to set a relatively > low session timeout, and the session times out while the user is filling in > a form. > > Jim > > > - Original Message - > From: "Nathan Chen" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Sunday, February 17, 2002 10:50 PM > Subject: Session variable vs. other variables > > > > Hi, All: > > > > I have a program that requires user login(username, password). After > > the users log in the system, I use a session variable to store the users > > IDs and other users' data to determine whether they are allowed to visit > > certain pages. I don't have the control over how long the users can > > stay in the site, and I don't have the control over the setting of > > session variable expiration time on CF server(I don't host the system). > > As you know the session variable expires after certain period of time, > > e.g. 20 minutes set by CF server as default. If the session expires, > > then the users can't go anywhere. I don't want them to experience such > > situation either. I suspect I shouldn't use session variable at all. > > Is cookie a better choice in this case? How do you guys do when dealing > > with such situation? Any idea is appreciated. > > > > Nathan Chen > __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Calculations in Query?
Steve is right. You can't have zero as the denominator. I totally forgot about that. Sorry. Ann, it is very likely that some of your fields contain zero values. nathan - Original Message - From: "Steven Durette" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, February 17, 2002 10:34 PM Subject: Re: Calculations in Query? > Ann, > > This might not have worked if you have any zeros in the D_Goal column. > > This would work for SQL Server, and should work for Access, but I'm not > sure. > > SELECT D_ID, D_Name, > (CASE D_Goal WHERE 0 THEN 0 > ELSE D_Loss/D_Goal*100) as MyValue > FROM diet > > Steve > > - Original Message - > From: "Ann Harrell" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Sunday, February 17, 2002 11:25 PM > Subject: RE: Calculations in Query? > > > > Thanks, Nathan. I didn't work for me, but that probably has more to do > wi > > th > > the lateness of the hour than anything. I'll start fresh in the morning. > > > > Ann Harrell > > > > -Original Message- > > From: Nathan Chen [mailto:[EMAIL PROTECTED]] > > Sent: Sunday, February 17, 2002 11:01 PM > > To: CF-Talk > > Subject: Re: Calculations in Query? > > > > > > Of course it is possible. Try > > SELECT D_ID, D_Name, D_Loss/D_Goal*100 as MyValue > > FROM diet > > > > Then put a % after the output value. e.g. #MyValue# >% > > > > - Original Message - > > From: "Ann Harrell" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Sunday, February 17, 2002 8:41 PM > > Subject: Calculations in Query? > > > > > > > I'm trying to figure a percentage in a query. I don't know if it's > > possible. > > > I would like to D_Loss / D_Goal and then output the percentage. I'm u > si > > ng > > an > > > Access database if that helps. > > > > > > > > > SELECT D_ID, D_Name, D_Loss, D_Goal > > > FROM diet > > > ORDER BY diet.D_Name > > > > > > > > > Thanks! > > > > > > Ann Harrell > > > > > > > > __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Session variable vs. other variables
Hi, All: I have a program that requires user login(username, password). After the users log in the system, I use a session variable to store the users IDs and other users' data to determine whether they are allowed to visit certain pages. I don't have the control over how long the users can stay in the site, and I don't have the control over the setting of session variable expiration time on CF server(I don't host the system). As you know the session variable expires after certain period of time, e.g. 20 minutes set by CF server as default. If the session expires, then the users can't go anywhere. I don't want them to experience such situation either. I suspect I shouldn't use session variable at all. Is cookie a better choice in this case? How do you guys do when dealing with such situation? Any idea is appreciated. Nathan Chen __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Calculations in Query?
Of course it is possible. Try SELECT D_ID, D_Name, D_Loss/D_Goal*100 as MyValue FROM diet Then put a % after the output value. e.g. #MyValue#% - Original Message - From: "Ann Harrell" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, February 17, 2002 8:41 PM Subject: Calculations in Query? > I'm trying to figure a percentage in a query. I don't know if it's possible. > I would like to D_Loss / D_Goal and then output the percentage. I'm using an > Access database if that helps. > > > SELECT D_ID, D_Name, D_Loss, D_Goal > FROM diet > ORDER BY diet.D_Name > > > Thanks! > > Ann Harrell > __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Suppressing CFID & CFTOKEN
How about using frames, put the pages inside a frame. just a thought. Nathan - Original Message - From: "Smith, Daron [PA]" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, February 15, 2002 11:28 AM Subject: Suppressing CFID & CFTOKEN > I have CFID and CFTOKEN showing up in the url string of my url's > occasionally. This occurs selectively, one time it will occur and another > time it will not. Is there a way to suppress this information? I would > like the URL's to appear 'clean'. The problem occurs on the same page but is > not consistent. I am not using session variables or client variables so I > don't know what is causing them to appear. > > Any ideas? > > Daron J. Smith > Web Developer > PSEA > > [EMAIL PROTECTED] > 717-255-7141 > 1-800-944-PSEA (7732) x 7141 > Please note new email address (old one with 'mail' will soon expire) > > > FAQ: http://www.thenetprofits.co.uk/coldfusion/faq > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: simple question - how do you manually time out a session variable
Steve, I got it. It works. Thank you so much. Nathan - Original Message - From: "Steve Oliver" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, February 14, 2002 11:55 PM Subject: RE: simple question - how do you manually time out a session variable > Well, do you have a logout.cfm page? > > If so, do something like this. > > > > > > document.location.href="index.cfm"> > > > > Then if they click the back button, it sends them right back to > index.cfm > > That way you could also clear your cookies if needed, since your not > using a cflocation > > __ > steve oliver > atnet solutions, inc. > http://www.atnetsolutions.com > > > -Original Message- > From: Nathan Chen [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 15, 2002 1:50 AM > To: CF-Talk > Subject: Re: simple question - how do you manually time out a session > variable > > > Steve, > Thanks for the posts. But I tried your codes and still haven't got it to > worked. If you have time, can you give me a little detail? My JS level > is > pretty junior. > > nathan > > - Original Message - > From: "Steve Oliver" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Thursday, February 14, 2002 11:43 PM > Subject: RE: simple question - how do you manually time out a session > variable > > > > >>The only way I can think of is to include something like: > > >>window.history.forward(20); > > > > > > Disregard that, I went looking around and found that IE only supports > > -1, 0, or 1 in the history function. > > > > __ > > steve oliver > > atnet solutions, inc. > > http://www.atnetsolutions.com > > > > > > __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: simple question - how do you manually time out a session variable
Steve, Thanks for the posts. But I tried your codes and still haven't got it to worked. If you have time, can you give me a little detail? My JS level is pretty junior. nathan - Original Message - From: "Steve Oliver" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, February 14, 2002 11:43 PM Subject: RE: simple question - how do you manually time out a session variable > >>The only way I can think of is to include something like: > >>window.history.forward(20); > > > Disregard that, I went looking around and found that IE only supports > -1, 0, or 1 in the history function. > > __ > steve oliver > atnet solutions, inc. > http://www.atnetsolutions.com > > __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: simple question - how do you manually time out a session variable
I guess, after solving the killing session issue, my next problem is how to prevent or stop users from clicking the "Back" button in the browser and getting back to the system after they logout. I know this is an old issue and someone has mentioned this before, but I didn't keep those messages. Can someone give me a pointer on how to disable the "Back" button? Thans a lot. Nathan - Original Message - From: "Steve Oliver" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, February 14, 2002 10:15 PM Subject: RE: simple question - how do you manually time out a session variable > Why keep the session if there's nothing in it :) > > Dropping the session will log them out. > > If he's tracking loggedin status by isDefined("SESSION.loggedin"), he'd > have to go through and add AND len(SESSION.loggedin) since your way just > sets them to "". > > __ > steve oliver > atnet solutions, inc. > http://www.atnetsolutions.com > > > -Original Message- > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] > Sent: Thursday, February 14, 2002 11:51 PM > To: CF-Talk > Subject: Re: simple question - how do you manually time out a session > variable > > > Steve's dumps the session totally and my example keeps the session, but > drops anything in it. > > Paul Giesenhagen > QuillDesign > http://www.quilldesign.com > SiteDirector - Commerce Builder > - Original Message - > From: "Nathan Chen" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Thursday, February 14, 2002 10:48 PM > Subject: Re: simple question - how do you manually time out a session > variable > > > > Thank you, Paul and Steve, for your help. > > > > > > - Original Message - > > From: "Paul Giesenhagen" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Thursday, February 14, 2002 9:31 PM > > Subject: Re: simple question - how do you manually time out a session > > variable > > > > > > > If you are wanting the session to END, just > > > > > > > > > > > > (Wrap it in cflock EXCLUSIVE) > > > > > > Paul Giesenhagen > > > QuillDesign > > > http://www.quilldesign.com > > > SiteDirector - Commerce Builder > > > > > > > > > > Hi,All: > > > > > > > > I know you can set time out for a session variable by changing the > > > > default value in CF administration, but can you time out a session > > > > variable manually? For example, if the user clicks a button > called > > > > "logout", then the next page sets the session expire or time out. > > > > > > > > > > > > Nathan > > > > > > > > > > > > > > > __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: simple question - how do you manually time out a session variable
Thank you, Paul and Steve, for your help. - Original Message - From: "Paul Giesenhagen" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, February 14, 2002 9:31 PM Subject: Re: simple question - how do you manually time out a session variable > If you are wanting the session to END, just > > > > (Wrap it in cflock EXCLUSIVE) > > Paul Giesenhagen > QuillDesign > http://www.quilldesign.com > SiteDirector - Commerce Builder > > > > Hi,All: > > > > I know you can set time out for a session variable by changing the > > default value in CF administration, but can you time out a session > > variable manually? For example, if the user clicks a button called > > "logout", then the next page sets the session expire or time out. > > > > > > Nathan > > > > > __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
simple question - how do you manually time out a session variable
Hi,All: I know you can set time out for a session variable by changing the default value in CF administration, but can you time out a session variable manually? For example, if the user clicks a button called "logout", then the next page sets the session expire or time out. Nathan __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re:
Thank you, Jim, Scott, and Howard, for the help. #message# does work. Jim McAtee wrote: > The scope of the variable you've specified would be variables, so use: > > #variables.message# > > or just: > > #message# > > Jim > > - Original Message - > From: "Nathan Chen" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Monday, September 24, 2001 5:12 PM > Subject: > > > Hi, Everyone, > > > > I am having a problem with tag trying to read > > a text file and display the file content. I basically copied the syntax > > from CFML Language Reference book as follow: > > > > > > When I did #file.message#, I got > > "Error resolving parameter FILE.MESSAGE > > Before you can access any file status variables you must execute at > > least one CFFILE tag." > > > > I put and in the same page. I thought I already > > executed the tag. Does anyone have any idea? I am using CF 4.5. > > Thanks. > ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cf-talk@houseoffusion.com
Hi, Everyone, I am having a problem with tag trying to read a text file and display the file content. I basically copied the syntax from CFML Language Reference book as follow: When I did #file.message#, I got "Error resolving parameter FILE.MESSAGE Before you can access any file status variables you must execute at least one CFFILE tag." I put and in the same page. I thought I already executed the tag. Does anyone have any idea? I am using CF 4.5. Thanks. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: another sql syntax
Thank you so much, Dick and Marius. It works. Dick Applebaum wrote: > Try: > >insert into address > (name,phone,address) > > select name, phone,address from prod_address > > HTH > > Dick > > At 11:36 PM -0600 8/17/01, Nathan Chen wrote: > >Hi, There, > >Can someone show me how do this simple task? I need to copy data from > >one table to another. The SQL Server book I have gives me an example > >that doesn't work. It says > >insert into address > > (name,phone,address) > > values (select name, phone,address from prod_address) > >I run it but the error message points to the select query. > > > > I know you can declare variables and store the result of the select > >query in them, then insert into the table. > >Does anyone know this? I am using SQL Server 7.0 and I want to run it > >from Query Analyzer, not cfm page. > >Thanks a lot. > > > > > >Nathan Chen > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: another sql syntax
Hi, There, Can someone show me how do this simple task? I need to copy data from one table to another. The SQL Server book I have gives me an example that doesn't work. It says insert into address (name,phone,address) values (select name, phone,address from prod_address) I run it but the error message points to the select query. I know you can declare variables and store the result of the select query in them, then insert into the table. Does anyone know this? I am using SQL Server 7.0 and I want to run it from Query Analyzer, not cfm page. Thanks a lot. Nathan Chen ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL Syntax
Thank you very much, Tom. I'll give it a try. tom muck wrote: > DBTYPE="dynamic" > CONNECTSTRING= > "Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=c:\mydirectory\; > Extensions=asc,csv,tab,txt;Persist Security Info=False;" > > > SELECT first,last from testnames.csv > > > > Insert into employees (firstname,lastname) values ('#rs.first#','#rs.last#') > > > > This works in CF 5 using a dynamic connection to the directory where the > text file is located. You can do it in CF 4.5 by setting a dsn to the > directory using the MS text driver. > > I have some info on dynamic connections at > http://www.basic-ultradev.com/articles/dsnlesscoldfusion > > tom > > "Nathan Chen" <[EMAIL PROTECTED]> wrote in message > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > Thank you, David, that's my next best option. My goal is to execute the > select and insert query from a cfm page > > without any manual work. > > > > > > David Baskin wrote: > > > > > Nathan, if you have a comma delimited file with the data you want to > import > > > into a table you can do an import in Enterprise Mgr. right click on the > > > table that you want the data in and go to all tasks > import data. point > to > > > the text file and follow the steps to import. HTH. > > > > > > d > > > > > > -Original Message- > > > From: Nathan Chen [mailto:[EMAIL PROTECTED]] > > > Sent: Thursday, August 16, 2001 8:57 AM > > > To: CF-Talk > > > Subject: OT: SQL Syntax > > > > > > Hi, Everyone: > > > > > > Does anyone know how the syntax of selecting data from a text delimited > > > file and inserting into an exiting table? I kind of remember Oracle > > > database provides this kind of tool but not sure how. I am now using MS > > > SQL Server 7.0 > > > > > > The simplied situation will something like this: a text file that > > > consists of two columns, first_name, last_name.(tab delimited or space > > > delimited). I need to select data in these columns and then insert them > > > into a table that consists of two columns, first_name, last_name. I > > > thought this would be a simple task but can't find any syntax in the SQL > > > server books. Any help is appreciated. > > > > > > Nathan Chen > > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL Syntax
Thank you, David, that's my next best option. My goal is to execute the select and insert query from a cfm page without any manual work. David Baskin wrote: > Nathan, if you have a comma delimited file with the data you want to import > into a table you can do an import in Enterprise Mgr. right click on the > table that you want the data in and go to all tasks > import data. point to > the text file and follow the steps to import. HTH. > > d > > -----Original Message- > From: Nathan Chen [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 16, 2001 8:57 AM > To: CF-Talk > Subject: OT: SQL Syntax > > Hi, Everyone: > > Does anyone know how the syntax of selecting data from a text delimited > file and inserting into an exiting table? I kind of remember Oracle > database provides this kind of tool but not sure how. I am now using MS > SQL Server 7.0 > > The simplied situation will something like this: a text file that > consists of two columns, first_name, last_name.(tab delimited or space > delimited). I need to select data in these columns and then insert them > into a table that consists of two columns, first_name, last_name. I > thought this would be a simple task but can't find any syntax in the SQL > server books. Any help is appreciated. > > Nathan Chen > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Print without bringing print dialogue?
Stephen, Thank you so much for your help! Since this is pretty new to me, I will need to spend time playing with the code to make it fit into my program. Again thanks a lot!--Nathan Stephen Kellogg wrote: > Here's my .02cents worth. I will point out that (at least in IE 5.5 not sure > about NS or lower versions of IE) you can print directly to someone's > printer when a page loads, without popping up a dialog box and without them > having to click on anything. I have been doing this now for sometime > internally for printing reports. Keep in mind that formatting using an HTML > printed document can be difficult to control with such a wide range of > systems and setups but... I think if it's kept simple it can be done. PS you > can print anything that prints normally with an HTML page, logos included. > ;-) Keep reading if your interested. > > My situation was as follows: > What I needed was to query a db (using CF) and have results printed > automatically. I only needed it to work with IE 5.5 and I didn't care if it > displayed on screen. > > I found some code here > http://www.javascriptcity.com/forums/index.php3?action=faq#qj6 > but had to modify it... > > This code still popped up the print dialog box and I can do that by putting > onload="window.print();" in the tag. > What I wanted was to print the cfm (htm) file when it loaded, without > popping up the print dialog box. > > I tweaked the code a little and ended up with this: > > > <!-- > function printit(){ > if (document.all) { > var WebBrowser = '<OBJECT ID="WebBrowser1" WIDTH=0 HEIGHT=0 > CLASSID="CLSID:8856F961-340A-11D0-A96B-00C04FD705A2"></OBJECT>'; > document.body.insertAdjacentHTML('beforeEnd', WebBrowser); > WebBrowser1.ExecWB(6, 6); //Use a 1 vs. a 6 for a prompting dialog box > WebBrowser1.outerHTML = ""; > } > } > //--> > > > You also have to put onload="printit();" in the tag for it to print > when the page loads or you could associate it with a print button etc (just > set whatever you click on to call the printit() function). > > The modified code prints the cfm (htm) file to the users default printer > using default settings without putting up any dialog boxes but it still > displays the cfm (htm) file onscreen. Again, I know it works in IE 5.5 not > sure about anything else. I haven't tested it in NS. I didn't have a need to > support NS or any browser other than IE 5.5. > > One thing to "get around" displaying onscreen would be to use a hidden frame > for the "printing" htm page and put up a generic display page. > > Hope this helps > > Stephen > > -Original Message- > From: Christopher Olive, CIO [mailto:[EMAIL PROTECTED]] > Sent: Monday, July 09, 2001 9:38 PM > To: CF-Talk > Subject: RE: Print without bringing print dialogue? > > actually, you can't. it's a JS security feature. > > chris olive, cio > cresco technologies > [EMAIL PROTECTED] > http://www.crescotech.com > > -Original Message- > From: Nathan Chen [mailto:[EMAIL PROTECTED]] > Sent: Monday, July 09, 2001 12:46 PM > To: CF-Talk > Subject: Print without bringing print dialogue? > > Hi, All: > > I posted this before the list went down a few weeks ago. I don't know if > it went though so I re-post it. > > I need to know how to print a cfm page without bringing up the print > dialogue from the browser. If I use window. print() method, the print > dialogue will popup. But what I need is to send the displayed > information to the printer directly without bringing this print dialogue > box. Is this possible? Any hint or suggestion will be appreciated. > > Nathan Chen > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Print without bringing print dialogue?
Hi, All: I posted this before the list went down a few weeks ago. I don't know if it went though so I re-post it. I need to know how to print a cfm page without bringing up the print dialogue from the browser. If I use window. print() method, the print dialogue will popup. But what I need is to send the displayed information to the printer directly without bringing this print dialogue box. Is this possible? Any hint or suggestion will be appreciated. Nathan Chen ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF-talk (Michael Dinowitz)
I finally got 7 posts today. The last post I received was on June 18. --Nathan "Bruce, Rodney" wrote: > Mike > > I am still not getting emails and was wondering if there was a way > to search the archives for a subject and if there was a way to download old > postings? > > I am using the web pages to see postings. > > Thanks for your help > Rodney > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: is this list dead?
looks like it is working now, thanks a lot for fixing it! Michael Dinowitz wrote: > We finally found the problem. It's fixed and a full report will be > forthcoming. > > > This is the first one i've had in over a week!!! > > > > I thought the list was Dead!! > > > > Jason Lees > > National Express > > Email : [EMAIL PROTECTED] > > > > > > -Original Message- > > From: Erika L. Walker [mailto:[EMAIL PROTECTED]] > > Sent: 02 July 2001 16:53 > > To: CF-Talk > > Subject: RE: is this list dead? > > > > > > I'm getting posts, but not as many as we used to get. > > > > :( > > > > Erika > > (with a *K*) > > > > "Those who love deeply never grow old; they may die of old age, but they > die > > young." - Sir Arthur Wing Pinero > > - > > Macromedia ColdFusion 5.0 Certified Developer - < Just passed!! > > WooHoo > > - > > > > -Original Message- > > From: Mike Sullivan [mailto:[EMAIL PROTECTED]] > > Sent: Monday, July 02, 2001 10:57 AM > > To: CF-Talk > > Subject: is this list dead? > > > > > > I haven't seen a post in quite some time now. > > Mike > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
what's going on?
Is it just me or something is wrong with this list? I haven't received posts for several days. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: Coldfusion vs. ASP
I can see the Chinese with my NJ Star Chinese viewer except the second character under the column SQL LEFT 5 and CF LEFT 5 becomes ?? mark. It might be because my viewer doesn't work well, but give you an feedback. Nathan Chen Paul Hastings wrote: > > I've had to learn ASP to compliment my CF skills, mainly for > multi-language > > projects due to CF's lack of unicode support. > > not to start any religious wars, but even cf's unicode support, while > not as good as ASP, isn't completely hopeless. workarounds exist > for most stuff http://www.tei.or.th/misc/unicodeSplit.cfm > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Automatic Printing
Hi, Everyone: I need a some kind of custom tag or script that does an automatic printing. I have a form in cfm page that allows the end user to enter data. When the end users finishes(clicking on the submit button), the tab/script will print the information entered in the database directly to the default printer rather than bringing up the print dialogue box from the borwser. I know "window.print()" method, but it brings up the dialogue box and that's not what I want. Plus, "widnow.print()" print the form itself. That's not what I want either; I want to print the data in a pre-defined format(e.g. a report). Has anyone done this before? Any pointer will be appreciated. Nathan Chen ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: What does OT mean?
I believe it is Off Topic, something that is not related to CF topics directly. Phoeun Pha wrote: > Other things?? > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: deleting cookie
Thank you Joby for your help. Thank you Ethan, Dylan, and Min too. It does delete the cookie if I don't use . I totaly forgot about the problem of using on the same page where there is a .--Nathan Joby Bednar wrote: > It does delete the cookie if no other call for the cookie is made. If you > tell it to delete and then send to a template that looks for it, it won't > delete the cookie. Just make sure it sends it to a static page. > > Joby Bednar > Director of Internet Design > iNEOgroup.com > http://www.ineogroup.com <http://www.ineogroup.com> > Fusing your Dreams and the Web, Together as One > [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > Cell: 949-283-5138 > Personal Fax: 208-485-1170 > > -Original Message- > From: Nathan Chen [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, February 21, 2001 4:30 PM > To: CF-Talk > Subject: deleting cookie > > Hi All: > > Does anybody know how to delete a cookie without closing the browser? > The method mentioned in ColdFusion manual( value="..." expires="now">) doesn't do the work; it deletes the cookie > only when the user closes the browser, but I want to delete it without > closing it. Any idea? Thanks. > > Nathan > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
deleting cookie
Hi All: Does anybody know how to delete a cookie without closing the browser? The method mentioned in ColdFusion manual() doesn't do the work; it deletes the cookie only when the user closes the browser, but I want to delete it without closing it. Any idea? Thanks. Nathan ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
How to disable "Back" function on browser
Hi All: Is there a way to disable the "Back" function when the user right click the mouse? What I am trying to do is to prevent the user from going back to the previous page. Nathan Chen ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: data in columns
First, try using where cbi like 'CBI%' Second, you can just use #Get.recordcount# to return the number of records you query finds. --Nathan Robert Orlini wrote: > Hello, > > I'm still a newbie with this one though I've tried. How can I count data in > certain columns of a table for each record. Some records have no data in > this field of the column so of course I don't want that counted. I kept it > VERY VERY simple below. I've tried different configurations, but #cbicount# > always returns a blank. > > Any help is always appreciated. Thank you. > > Robert O. > -- > > Below I'm trying to count how many times CBI appears in the cbi column and > display the total tally in the #cbicount# variable: > > >SELECT id, cbi >FROM wweb >Where cbi like 'CBI' > > > > > > > > > #cbiCount# > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
multi variables in stored procedures
Hi, All: This is supposed to be a simple, but how do you pass multiple variables using tag inside tag? I used two lines as below and didn't pass the values I wanted: --- - I guess I must have missed something. Any pointer is appreciated. Nathan Chen ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: IsNumeric Function
I agree with Joel. Using JavaScript to process on the client side is fast and doesn't need to hit the CF server. I always use this to check numeric value: ( I am sure many of you already know how to do this, but I am posting it for those who might not know.) === function checkfield() { if (isNaN(document.forms[0].phone.value)) {alert ("Sorry, but you must enter a numeric value.") document.forms[0].phone.focus(); return false; } } === Joel Firestone wrote: > One way I found useful was to use JavaScript on the client-side > to test if they were numbers or not. Then you know only numbers > are being submitted. > > J > > : I am trying to do some server side validation for a phone number, but I am > running into an odd problem. I split the phone number entry form into three > textboxes the first one for area code (ie must be 3 numbers) and then the > two parts of the phone number (ie must be 3 numbers and then must be 4 > numbers). I check to make sure the length of each textbox is correct and > then I try to check if they are numeric, however it will throw an error. > : > : My code looks something like this: > : > : IsNumeric("attributes.custPhone2") or not > IsNumeric("attributes.custPhone3")> > : phone number."> > : > : > : The strange part is that when I take out the not IsNumeric() statements > for the first two form variables it works fine. Ideas??? > : > : -Greg > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists