Re: How to Get Around the Eolas Patent—Automati ca lly
Matt Liotta wrote: It was requested that I share the article link when it was published, so here you go. Unless it's overturned, the Eolas ruling means tens of thousands of Web pages that use embedded plugins are infringing on the patent. The pages themselves are not infringent. Executing embedded content might be infringent in some jurisdictions, but execution is done on the client, not the server. Jochem -- When you don't want to be surprised by the revolution organize one yourself - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: How to Get Around the Eolas Patent— Automati ca lly
PHP dns_get_record() works getting dns name from hosting. See description from http://www.php.net/manual/en/function.dns-get-record.php: dns_get_record --Fetch DNS Resource Records associated with a hostname How to do this in CF? Is possible? -- ___ Sign-up for Ads Free at Mail.com http://promo.mail.com/adsfreejump.htm [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CF x PHP dns-get-record
PHP dns_get_record() works getting dns name from hosting. See description from http://www.php.net/manual/en/function.dns-get-record.php: dns_get_record --Fetch DNS Resource Records associated with a hostname How to do this in CF? Is possible? -- ___ Sign-up for Ads Free at Mail.com http://promo.mail.com/adsfreejump.htm [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFFTP problem.. anyone see how to get around this?
I'm trying to write a template to retrieve a file from a remote location and process it.The problem is that CFFTP cant find the correct directory on the remote site because the directory name has a space in it.Anyone know how to get around this? I'm wanting it to change to directory /Custom Extractsbut I keep getting a message saying that directory /Custom cannot be found. I've tried replacing the space with %20, and using double quotes - is there anything else I can try? Cheers Mike Kear Windsor, NSW, Australia AFP Webworks http://afpwebworks.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX installation problems, datasource
Thanks for the suggestions Michael, I dumped the files inC:\CFusionMX\db\slserver52\tracing. Restarted CFMX, CFMX ODBC Agent and CFMX ODBC Server.(Had to stop them to remove the .trc files. It didn't work CF created new .trc files. Removed them as well as dumping the file in C:\CFusionMX\db\slserver52\logging. This time I went to the page with ODBC Agent and ODBC Server shut down. Expected a different error msg and got it. Error Executing Database Query. SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. Restarted ODBC Agent and ODBC Server and got the same error msg as before cannot find input table or query Rebooted and got the same error. Any other suggestions?Remove and reinstall CF? This is getting frustrating. -- gil == == For others that may have the same problem in the future: I was getting a Cannot delete Cold Fusion MX ODBC Server.trc: There has been a sharing violation. The source or destination file may be in use. I stopped CFMX, same error. Stopped CFMX ODBC Agent and ODBC Server and was able to delete them both. (Made back-ups of the folders before). == == -- gil -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Sunday, December 21, 2003 1:22 AM To: CF-Talk Subject: RE: CFMX installation problems, datasource Try this.. go to: C:\CFusionMX\db\slserver52\ There should be two folders: tracing and logging. Dump the contents of tracing to start, then logging if it still does not resolve your issue. Back these folders up first, in case the reuslts are not what you expect. _ From: mayo [mailto:[EMAIL PROTECTED] Sent: Sunday, December 21, 2003 1:13 AM To: CF-Talk Subject: RE: CFMX installation problems, datasource yes, same script, same databases. I can access the databases via php. I reinstalled IIS. Reinstalled CFMX. CF is working fine. What's not working is accessing databases. Went to CF administrator, added the datasource, verified it, verified it again, rebooted my laptop, restarted CF, restarted IIS. Same problem. It gives that weird cannot find table or query error. I even made a brand new database, set up an ODBC connection and ... still the sam error. Using Windows 2000, IS 5, CFMX 6 Any ideas on what errors to look for? The Cold Fusion logs aren't telling me anything. IIS logs have the following errors event viewer systems: MSFTPSVC SMPTSVC W3VC Service Control Manager (The WrKPoET2000 service failed to start due to the following error: A device attached to the system is not functioning. ) event viewer applications: WrNetworkDriver Error: WR_::KERNEL_DRIVER_STUB::Start(WrKPoET2000) failed. Error = A device attached to the system is not functioning. -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Sunday, December 21, 2003 12:53 AM To: CF-Talk Subject: RE: CFMX installation problems, datasource Sounds like it can not find a query or a table, did you verify that the DB was still the same and that all the tables that were initially there were in fact still there? _ From: mayo [mailto:[EMAIL PROTECTED] Sent: Sunday, December 21, 2003 12:00 AM To: CF-Talk Subject: CFMX installation problems, datasource After IIS and CFMX crashed last week I had to reinstall both. IIS works as does CFMX EXCEPT for the fact that CFMX there is a problem accessing the database. The ODBC connection seems to be working. If I don't put in the datasource it gives the Data Source x cannot be found error. However after adding the datasource it give an error that it cannot find the table. Of course I verified and reverified the datasource. I bounced CFMX. I rebooted the box. I made a test db and a test page calling it and got the same error msg as before: Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'whocares'. Make sure it exists and that its name is spelled correctly. Gil Midonnet _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX installation problems, datasource
I'm wondering about the error msg. Should there be a reference to a JDBC Driver? I'm trying to troubleshoot and a .pdf in the C:\CFusionMX\db\slserver52 directory indicates that I should be able to do a JDBC Test with a JDBC Configuration file which is not installed. (did a search for the directory jdbctest and the file config.txt) -- gil Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'sale'. Make sure it exists and that its name is spelled correctly. -- gil -Original Message- From: mayo [mailto:[EMAIL PROTECTED] Sent: Sunday, December 21, 2003 12:43 PM To: CF-Talk Subject: RE: CFMX installation problems, datasource Thanks for the suggestions Michael, I dumped the files inC:\CFusionMX\db\slserver52\tracing. Restarted CFMX, CFMX ODBC Agent and CFMX ODBC Server.(Had to stop them to remove the .trc files. It didn't work CF created new .trc files. Removed them as well as dumping the file in C:\CFusionMX\db\slserver52\logging. This time I went to the page with ODBC Agent and ODBC Server shut down. Expected a different error msg and got it. Error Executing Database Query. SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. Restarted ODBC Agent and ODBC Server and got the same error msg as before cannot find input table or query Rebooted and got the same error. Any other suggestions?Remove and reinstall CF? This is getting frustrating. -- gil == == For others that may have the same problem in the future: I was getting a Cannot delete Cold Fusion MX ODBC Server.trc: There has been a sharing violation. The source or destination file may be in use. I stopped CFMX, same error. Stopped CFMX ODBC Agent and ODBC Server and was able to delete them both. (Made back-ups of the folders before). == == -- gil -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Sunday, December 21, 2003 1:22 AM To: CF-Talk Subject: RE: CFMX installation problems, datasource Try this.. go to: C:\CFusionMX\db\slserver52\ There should be two folders: tracing and logging. Dump the contents of tracing to start, then logging if it still does not resolve your issue. Back these folders up first, in case the reuslts are not what you expect. _ From: mayo [mailto:[EMAIL PROTECTED] Sent: Sunday, December 21, 2003 1:13 AM To: CF-Talk Subject: RE: CFMX installation problems, datasource yes, same script, same databases. I can access the databases via php. I reinstalled IIS. Reinstalled CFMX. CF is working fine. What's not working is accessing databases. Went to CF administrator, added the datasource, verified it, verified it again, rebooted my laptop, restarted CF, restarted IIS. Same problem. It gives that weird cannot find table or query error. I even made a brand new database, set up an ODBC connection and ... still the sam error. Using Windows 2000, IS 5, CFMX 6 Any ideas on what errors to look for? The Cold Fusion logs aren't telling me anything. IIS logs have the following errors event viewer systems: MSFTPSVC SMPTSVC W3VC Service Control Manager (The WrKPoET2000 service failed to start due to the following error: A device attached to the system is not functioning. ) event viewer applications: WrNetworkDriver Error: WR_::KERNEL_DRIVER_STUB::Start(WrKPoET2000) failed. Error = A device attached to the system is not functioning. -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Sunday, December 21, 2003 12:53 AM To: CF-Talk Subject: RE: CFMX installation problems, datasource Sounds like it can not find a query or a table, did you verify that the DB was still the same and that all the tables that were initially there were in fact still there? _ From: mayo [mailto:[EMAIL PROTECTED] Sent: Sunday, December 21, 2003 12:00 AM To: CF-Talk Subject: CFMX installation problems, datasource After IIS and CFMX crashed last week I had to reinstall both. IIS works as does CFMX EXCEPT for the fact that CFMX there is a problem accessing the database. The ODBC connection seems to be working. If I don't put in the datasource it gives the Data Source x cannot be found error. However after adding the datasource it give an error that it cannot find the table. Of course I verified and reverified the datasource. I bounced CFMX. I rebooted the box. I made a test db and a test page calling it and got the same error msg as before: Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] The
RE: CF x PHP dns-get-record
One quick and dirty solution might be to use CFEXECUTE and NSLOOKUP. -Novak -Original Message- From: Spectrum WebDesign [mailto:[EMAIL PROTECTED] Sent: Sunday, December 21, 2003 5:40 AM To: CF-Talk Subject: CF x PHP dns-get-record PHP dns_get_record() works getting dns name from hosting. See description from http://www.php.net/manual/en/function.dns-get-record.php: dns_get_record --Fetch DNS Resource Records associated with a hostname How to do this in CF? Is possible? -- ___ Sign-up for Ads Free at Mail.com http://promo.mail.com/adsfreejump.htm _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX installation problems, datasource
OK, maybe I'm grasping at straws here. A macromedia.com tech note Troubleshooting data sources and database connectivity for Windows platforms says to check the username and password for your datasources. I checked and there is no username and password listed. I added my username and password. Still no go. A general question -- in your admin sections do you have a username and password listed? CFIDE administrator data sources : click on a datasource select Show Advanced Settings username and password should be listed there. -- glm -Original Message- From: mayo [mailto:[EMAIL PROTECTED] Sent: Sunday, December 21, 2003 12:43 PM To: CF-Talk Subject: RE: CFMX installation problems, datasource Thanks for the suggestions Michael, I dumped the files inC:\CFusionMX\db\slserver52\tracing. Restarted CFMX, CFMX ODBC Agent and CFMX ODBC Server.(Had to stop them to remove the .trc files. It didn't work CF created new .trc files. Removed them as well as dumping the file in C:\CFusionMX\db\slserver52\logging. This time I went to the page with ODBC Agent and ODBC Server shut down. Expected a different error msg and got it. Error Executing Database Query. SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. Restarted ODBC Agent and ODBC Server and got the same error msg as before cannot find input table or query Rebooted and got the same error. Any other suggestions?Remove and reinstall CF? This is getting frustrating. -- gil == == For others that may have the same problem in the future: I was getting a Cannot delete Cold Fusion MX ODBC Server.trc: There has been a sharing violation. The source or destination file may be in use. I stopped CFMX, same error. Stopped CFMX ODBC Agent and ODBC Server and was able to delete them both. (Made back-ups of the folders before). == == -- gil -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Sunday, December 21, 2003 1:22 AM To: CF-Talk Subject: RE: CFMX installation problems, datasource Try this.. go to: C:\CFusionMX\db\slserver52\ There should be two folders: tracing and logging. Dump the contents of tracing to start, then logging if it still does not resolve your issue. Back these folders up first, in case the reuslts are not what you expect. _ From: mayo [mailto:[EMAIL PROTECTED] Sent: Sunday, December 21, 2003 1:13 AM To: CF-Talk Subject: RE: CFMX installation problems, datasource yes, same script, same databases. I can access the databases via php. I reinstalled IIS. Reinstalled CFMX. CF is working fine. What's not working is accessing databases. Went to CF administrator, added the datasource, verified it, verified it again, rebooted my laptop, restarted CF, restarted IIS. Same problem. It gives that weird cannot find table or query error. I even made a brand new database, set up an ODBC connection and ... still the sam error. Using Windows 2000, IS 5, CFMX 6 Any ideas on what errors to look for? The Cold Fusion logs aren't telling me anything. IIS logs have the following errors event viewer systems: MSFTPSVC SMPTSVC W3VC Service Control Manager (The WrKPoET2000 service failed to start due to the following error: A device attached to the system is not functioning. ) event viewer applications: WrNetworkDriver Error: WR_::KERNEL_DRIVER_STUB::Start(WrKPoET2000) failed. Error = A device attached to the system is not functioning. -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Sunday, December 21, 2003 12:53 AM To: CF-Talk Subject: RE: CFMX installation problems, datasource Sounds like it can not find a query or a table, did you verify that the DB was still the same and that all the tables that were initially there were in fact still there? _ From: mayo [mailto:[EMAIL PROTECTED] Sent: Sunday, December 21, 2003 12:00 AM To: CF-Talk Subject: CFMX installation problems, datasource After IIS and CFMX crashed last week I had to reinstall both. IIS works as does CFMX EXCEPT for the fact that CFMX there is a problem accessing the database. The ODBC connection seems to be working. If I don't put in the datasource it gives the Data Source x cannot be found error. However after adding the datasource it give an error that it cannot find the table. Of course I verified and reverified the datasource. I bounced CFMX. I rebooted the box. I made a test db and a test page calling it and got the same error msg as before: Error Executing Database Query. [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query
a query
This will probably be simple, but I'm no sql master. I have three columns ID, TYPE, PAGENAME I want to select all items, group by type and order by id. ~~ Daniel Farmer Coldfusion Developer / Producer http://www.bernardclark.com/danfarmer.ca/ 613.284.1684 ~~ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: a query
Do you want to see all the items, ie their IDs and Pagename? Or do you actually want to group all the same types together? - Original Message - From: Daniel Farmer To: CF-Talk Sent: Sunday, December 21, 2003 2:43 PM Subject: a query This will probably be simple, but I'm no sql master. I have three columns ID, TYPE, PAGENAME I want to select all items, group by type and order by id. ~~ Daniel Farmer Coldfusion Developer / Producer http://www.bernardclark.com/danfarmer.ca/ 613.284.1684 ~~ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OSX - Starting UP JRun/CF Automatically
I've got CF and JRun installed on my powerbook.To start these up I go into Terminal and changeto the directory where JRun is located, and then type ./jrun.Getting tired of typing this in all the time. I want to have JRun load automatically whenever I boot up my PB.Has anyone wrote a script to do this? -- Lola - mailto:[EMAIL PROTECTED] http://www.lolajl.net | Blog at http://www.lolajl.net/blog/ Check out this blog:http://www.denbeste.nu I'm in Bowie, MD, USA, halfway between DC and Annapolis. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: a query
select id, type from yourTable group by type, id order by id hth tony tony weeg [EMAIL PROTECTED] www.revolutionwebdesign.com rEvOlUtIoN wEb DeSiGn 410.334.6331 -Original Message- From: Daniel Farmer [mailto:[EMAIL PROTECTED] Sent: Sunday, December 21, 2003 2:43 PM To: CF-Talk Subject: a query This will probably be simple, but I'm no sql master. I have three columns ID, TYPE, PAGENAME I want to select all items, group by type and order by id. ~~ Daniel Farmer Coldfusion Developer / Producer http://www.bernardclark.com/danfarmer.ca/ 613.284.1684 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Joining the dark side - using DWMX
You can't anyway as MM no longer sell Studio. In fact the only way to get HomeSite+ is tor purchase Dreamweaver MX/Studio MX. Peter Tilbrook Transitional Services - Enterprise eSolutions Centrelink (http://www.centrelink.gov.au) 2 Faulding Street Symonston ACT 2609 Tel: (02) 62115927 Daniel Farmer [EMAIL PROTECTED]To: CF-Talk [EMAIL PROTECTED] l.com cc: Subject:Re: Joining the dark side - using DWMX 20/12/2003 01:58 Please respond to cf-talk| [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: PERL on a CF Page? Solved
Les Mizzell wrote: CFHTTP maybe?Haven't gotten to try it yet... Shouldn't have gone to the list so quick! Yep, CFHTTP works great! You can also CFEXECUTE perl scripts... or at least the perl executable and pass it the perl script as an argument. I was bored a few years back and wrote a cusotm tag that would let you do: cf_perl real perl code here /cf_perl It would then simply pass the code as one line to the perl exe. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Joining the dark side - using DWMX
Of course this isn't really something you can complain about since the price is less than what CFS used to be by itself. Even if you absolutely hate Dreamweaver, you can't argue with spending less money. I consider myself a devout Studio/HS+ user, but DWMX 2004 was _darn_ nice and was almost enough to make me switch. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Joining the dark side - using DWMX
Huh? You can't even copy/paste code examples into your templates, at least not in MX 2004. Peter Tilbrook Transitional Services - Enterprise eSolutions Centrelink (http://www.centrelink.gov.au) 2 Faulding Street Symonston ACT 2609 Tel: (02) 62115927 Daniel Farmer [EMAIL PROTECTED]To: CF-Talk [EMAIL PROTECTED] l.com cc: Subject:Re: Joining the dark side - using DWMX 20/12/2003 04:11 Please respond to cf-talk| [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Windows 2003 Web Edition ColdFusion
so what i hear from this is, cf4.5 won't install and work on w2k3 - but... you can do all of the hooks into iis 6 that are required manually. and the really is just the isapi reference. are there any other issues? Eric - Original Message - From: Calvin Ward To: CF-Talk Sent: Friday, December 19, 2003 12:16 PM Subject: Re: Windows 2003 Web Edition ColdFusion Maybe this will help: http://www.macromedia.com/support/coldfusion/ts/documents/install_cf_win2003.htm - Calvin - Original Message - From: Marc van den Dikkenberg To: CF-Talk Sent: Friday, December 19, 2003 1:02 PM Subject: Re: Windows 2003 Web Edition ColdFusion You won't be able to install CF 4.5.x and have it work with the version of IIS that comes with Windows Server 2003. You may be able to select Other Server during the CF install when it asks you what web server you're running. You may also be able to get the CF installer to think that you have IIS 5 instead of IIS 6 - I remember reading about doing something like that with CF 5 (you might search for CF 5 and W2K3, instead of searching for CF 4.5.x). Thanks - I haven't found this yet, but will keep looking. That does make me wonder about one thing though: Since it does work OK with IIS5 on Windows 2000... If one does a Win2000 install first, install CF4.5, and then upgrades it to 2003 Would it inherit the Cold Fusion ties in IIS as well if I do so? Anyone ever tried this? -- Marc van den Dikkenberg [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
re: dsn get record() was (Re: How to Get Around the Eolas Patent— Automati ca lly)
There's no native feature to accomplish this in CF, you'll have to find or make a Java solution or a CFX tag that can be implemented in CF to do this. You'll get more responses if you change the subject of the email. PHP dns_get_record() works getting dns name from hosting. See description from http://www.php.net/manual/en/function.dns-get-record.php: dns_get_record --Fetch DNS Resource Records associated with a hostname How to do this in CF? Is possible? s. isaac dealey 214-823-9345 team macromedia volunteerhttp://www.macromedia.com/go/team chief architect, tapestry cmshttp://products.turnkey.to onTap is open sourcehttp://www.turnkey.to/ontap [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Joining the dark side - using DWMX
Actually, you can buy HS by itself, it costs you something like $99 and $29 for upgrade. It is version 5.5 which comes with DWMX2004. http://shop.macromedia.com/dr/v2/ec_MAIN.Entry17c?CID=0PN=5SP=10007SID=46165PID=582404DSP=CUR=840PGRP=0CACHE_ID=0 TK - Original Message - From: [EMAIL PROTECTED] To: CF-Talk Sent: Sunday, December 21, 2003 4:15 PM Subject: Re: Joining the dark side - using DWMX You can't anyway as MM no longer sell Studio. In fact the only way to get HomeSite+ is tor purchase Dreamweaver MX/Studio MX. Peter Tilbrook Transitional Services - Enterprise eSolutions Centrelink (http://www.centrelink.gov.au) 2 Faulding Street Symonston ACT 2609 Tel: (02) 62115927 Daniel Farmer [EMAIL PROTECTED]To: CF-Talk [EMAIL PROTECTED] l.com cc: Subject:Re: Joining the dark side - using DWMX 20/12/2003 01:58 Please respond to cf-talk| [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Joining the dark side - using DWMX
Tom Kitta wrote: Actually, you can buy HS by itself, it costs you something like $99 and $29 for upgrade. It is version 5.5 which comes with DWMX2004. http://shop.macromedia.com/dr/v2/ec_MAIN.Entry17c?CID=0PN=5SP=10007SID=46165PID=582404DSP=CUR=840PGRP=0CACHE_ID=0 http://shop.macromedia.com/dr/v2/ec_MAIN.Entry17c?CID=0PN=5SP=10007SID=46165PID=582404DSP=CUR=840PGRP=0CACHE_ID=0 Actually, the version that comes with DWMX2004 is HS+ 5.5, which is different from Homesite 5.5.HS 5.5 doesn't have all of the CF Studio features that are in HS+ 5.5. Scott -- --- Scott Brady http://www.scottbrady.net/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: a query
Tony, here is my code: CODE cfset thesql=select id, type, pagename from navigation where type 'o' group by type, id order by id ERROR [Microsoft][ODBC Microsoft Access Driver] You tried to execute a query that does not include the specified _expression_ 'pagename' as part of an aggregate function. - Original Message - From: Tony Weeg To: CF-Talk Sent: Sunday, December 21, 2003 3:51 PM Subject: RE: a query select id, type from yourTable group by type, id order by id hth tony tony weeg [EMAIL PROTECTED] www.revolutionwebdesign.com rEvOlUtIoN wEb DeSiGn 410.334.6331 -Original Message- From: Daniel Farmer [mailto:[EMAIL PROTECTED] Sent: Sunday, December 21, 2003 2:43 PM To: CF-Talk Subject: a query This will probably be simple, but I'm no sql master. I have three columns ID, TYPE, PAGENAME I want to select all items, group by type and order by id. ~~ Daniel Farmer Coldfusion Developer / Producer http://www.bernardclark.com/danfarmer.ca/ 613.284.1684 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX installation problems, datasource - SOLVED !?!
So, after all this what was the solution? Reinstalling CFMX! But here's the rub. I reinstalled CFMX and I got the same errors.I reinstalled it again - different errors. Reinstalled again and VOILA, it works Why? No idea. gil thx everybody for your suggestions and help -Original Message- From: mayo [mailto:[EMAIL PROTECTED] Sent: Sunday, December 21, 2003 1:57 PM To: CF-Talk Subject: RE: CFMX installation problems, datasource OK, maybe I'm grasping at straws here. A macromedia.com tech note Troubleshooting data sources and database connectivity for Windows platforms says to check the username and password for your datasources. I checked and there is no username and password listed. I added my username and password. Still no go. A general question -- in your admin sections do you have a username and password listed? CFIDE administrator data sources : click on a datasource select Show Advanced Settings username and password should be listed there. -- glm -Original Message- From: mayo [mailto:[EMAIL PROTECTED] Sent: Sunday, December 21, 2003 12:43 PM To: CF-Talk Subject: RE: CFMX installation problems, datasource Thanks for the suggestions Michael, I dumped the files inC:\CFusionMX\db\slserver52\tracing. Restarted CFMX, CFMX ODBC Agent and CFMX ODBC Server.(Had to stop them to remove the .trc files. It didn't work CF created new .trc files. Removed them as well as dumping the file in C:\CFusionMX\db\slserver52\logging. This time I went to the page with ODBC Agent and ODBC Server shut down. Expected a different error msg and got it. Error Executing Database Query. SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. Restarted ODBC Agent and ODBC Server and got the same error msg as before cannot find input table or query Rebooted and got the same error. Any other suggestions?Remove and reinstall CF? This is getting frustrating. -- gil == == For others that may have the same problem in the future: I was getting a Cannot delete Cold Fusion MX ODBC Server.trc: There has been a sharing violation. The source or destination file may be in use. I stopped CFMX, same error. Stopped CFMX ODBC Agent and ODBC Server and was able to delete them both. (Made back-ups of the folders before). == == -- gil -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Sunday, December 21, 2003 1:22 AM To: CF-Talk Subject: RE: CFMX installation problems, datasource Try this.. go to: C:\CFusionMX\db\slserver52\ There should be two folders: tracing and logging. Dump the contents of tracing to start, then logging if it still does not resolve your issue. Back these folders up first, in case the reuslts are not what you expect. _ From: mayo [mailto:[EMAIL PROTECTED] Sent: Sunday, December 21, 2003 1:13 AM To: CF-Talk Subject: RE: CFMX installation problems, datasource yes, same script, same databases. I can access the databases via php. I reinstalled IIS. Reinstalled CFMX. CF is working fine. What's not working is accessing databases. Went to CF administrator, added the datasource, verified it, verified it again, rebooted my laptop, restarted CF, restarted IIS. Same problem. It gives that weird cannot find table or query error. I even made a brand new database, set up an ODBC connection and ... still the sam error. Using Windows 2000, IS 5, CFMX 6 Any ideas on what errors to look for? The Cold Fusion logs aren't telling me anything. IIS logs have the following errors event viewer systems: MSFTPSVC SMPTSVC W3VC Service Control Manager (The WrKPoET2000 service failed to start due to the following error: A device attached to the system is not functioning. ) event viewer applications: WrNetworkDriver Error: WR_::KERNEL_DRIVER_STUB::Start(WrKPoET2000) failed. Error = A device attached to the system is not functioning. -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Sunday, December 21, 2003 12:53 AM To: CF-Talk Subject: RE: CFMX installation problems, datasource Sounds like it can not find a query or a table, did you verify that the DB was still the same and that all the tables that were initially there were in fact still there? _ From: mayo [mailto:[EMAIL PROTECTED] Sent: Sunday, December 21, 2003 12:00 AM To: CF-Talk Subject: CFMX installation problems, datasource After IIS and CFMX crashed last week I had to reinstall both. IIS works as does CFMX EXCEPT for the fact that CFMX there is a problem accessing the database. The ODBC connection seems to be working. If I don't put in the datasource it gives the Data Source x cannot be found error.
Re: a query
select id, type, pagename from navigation group by type, id having type 'o' order by id From: Daniel Farmer [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: a query Date: Sun, 21 Dec 2003 17:46:46 -0500 Tony, here is my code: CODE cfset thesql=select id, type, pagename from navigation where type 'o' group by type, id order by id ERROR [Microsoft][ODBC Microsoft Access Driver] You tried to execute a query that does not include the specified _expression_ 'pagename' as part of an aggregate function. - Original Message - From: Tony Weeg To: CF-Talk Sent: Sunday, December 21, 2003 3:51 PM Subject: RE: a query select id, type from yourTable group by type, id order by id hth tony tony weeg [EMAIL PROTECTED] www.revolutionwebdesign.com rEvOlUtIoN wEb DeSiGn 410.334.6331 -Original Message- From: Daniel Farmer [mailto:[EMAIL PROTECTED] Sent: Sunday, December 21, 2003 2:43 PM To: CF-Talk Subject: a query This will probably be simple, but I'm no sql master. I have three columns ID, TYPE, PAGENAME I want to select all items, group by type and order by id. ~~ Daniel Farmer Coldfusion Developer / Producer http://www.bernardclark.com/danfarmer.ca/ 613.284.1684 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: a query
like this cfquery select id, type, pagename from navigation where type 'o' group by type, id, pagename order by id /cfquery tony tony weeg [EMAIL PROTECTED] www.revolutionwebdesign.com rEvOlUtIoN wEb DeSiGn 410.334.6331 -Original Message- From: Daniel Farmer [mailto:[EMAIL PROTECTED] Sent: Sunday, December 21, 2003 5:47 PM To: CF-Talk Subject: Re: a query Tony, here is my code: CODE cfset thesql=select id, type, pagename from navigation where type 'o' group by type, id order by id ERROR [Microsoft][ODBC Microsoft Access Driver] You tried to execute a query that does not include the specified _expression_ 'pagename' as part of an aggregate function. - Original Message - From: Tony Weeg To: CF-Talk Sent: Sunday, December 21, 2003 3:51 PM Subject: RE: a query select id, type from yourTable group by type, id order by id hth tony tony weeg [EMAIL PROTECTED] www.revolutionwebdesign.com rEvOlUtIoN wEb DeSiGn 410.334.6331 -Original Message- From: Daniel Farmer [mailto:[EMAIL PROTECTED] Sent: Sunday, December 21, 2003 2:43 PM To: CF-Talk Subject: a query This will probably be simple, but I'm no sql master. I have three columns ID, TYPE, PAGENAME I want to select all items, group by type and order by id. ~~ Daniel Farmer Coldfusion Developer / Producer http://www.bernardclark.com/danfarmer.ca/ 613.284.1684 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: a query
anything in the select statement that is part of a query with an aggregate function, group by, requires it be in the group by list. tony tony weeg [EMAIL PROTECTED] www.revolutionwebdesign.com rEvOlUtIoN wEb DeSiGn 410.334.6331 -Original Message- From: Daniel Farmer [mailto:[EMAIL PROTECTED] Sent: Sunday, December 21, 2003 5:47 PM To: CF-Talk Subject: Re: a query Tony, here is my code: CODE cfset thesql=select id, type, pagename from navigation where type 'o' group by type, id order by id ERROR [Microsoft][ODBC Microsoft Access Driver] You tried to execute a query that does not include the specified _expression_ 'pagename' as part of an aggregate function. - Original Message - From: Tony Weeg To: CF-Talk Sent: Sunday, December 21, 2003 3:51 PM Subject: RE: a query select id, type from yourTable group by type, id order by id hth tony tony weeg [EMAIL PROTECTED] www.revolutionwebdesign.com rEvOlUtIoN wEb DeSiGn 410.334.6331 -Original Message- From: Daniel Farmer [mailto:[EMAIL PROTECTED] Sent: Sunday, December 21, 2003 2:43 PM To: CF-Talk Subject: a query This will probably be simple, but I'm no sql master. I have three columns ID, TYPE, PAGENAME I want to select all items, group by type and order by id. ~~ Daniel Farmer Coldfusion Developer / Producer http://www.bernardclark.com/danfarmer.ca/ 613.284.1684 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: a query
that did it, thanks T. - Original Message - From: Tony Weeg To: CF-Talk Sent: Sunday, December 21, 2003 7:48 PM Subject: RE: a query anything in the select statement that is part of a query with an aggregate function, group by, requires it be in the group by list. tony tony weeg [EMAIL PROTECTED] www.revolutionwebdesign.com rEvOlUtIoN wEb DeSiGn 410.334.6331 -Original Message- From: Daniel Farmer [mailto:[EMAIL PROTECTED] Sent: Sunday, December 21, 2003 5:47 PM To: CF-Talk Subject: Re: a query Tony, here is my code: CODE cfset thesql=select id, type, pagename from navigation where type 'o' group by type, id order by id ERROR [Microsoft][ODBC Microsoft Access Driver] You tried to execute a query that does not include the specified _expression_ 'pagename' as part of an aggregate function. - Original Message - From: Tony Weeg To: CF-Talk Sent: Sunday, December 21, 2003 3:51 PM Subject: RE: a query select id, type from yourTable group by type, id order by id hth tony tony weeg [EMAIL PROTECTED] www.revolutionwebdesign.com rEvOlUtIoN wEb DeSiGn 410.334.6331 -Original Message- From: Daniel Farmer [mailto:[EMAIL PROTECTED] Sent: Sunday, December 21, 2003 2:43 PM To: CF-Talk Subject: a query This will probably be simple, but I'm no sql master. I have three columns ID, TYPE, PAGENAME I want to select all items, group by type and order by id. ~~ Daniel Farmer Coldfusion Developer / Producer http://www.bernardclark.com/danfarmer.ca/ 613.284.1684 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Joining the dark side - using DWMX
Exactly, HomeSite is just HomeSite, which is the html editor... HomeSite+ is ColdFusion Studio, which is the cfml editor. There are differences. Also of note, ColdFusion Studio listed at $499, whereas DWMX 2004 lists at $399 and includes HomeSite+ (ColdFusion Studio). - Calvin - Original Message - From: Scott Brady To: CF-Talk Sent: Sunday, December 21, 2003 5:19 PM Subject: Re: Joining the dark side - using DWMX Tom Kitta wrote: Actually, you can buy HS by itself, it costs you something like $99 and $29 for upgrade. It is version 5.5 which comes with DWMX2004. http://shop.macromedia.com/dr/v2/ec_MAIN.Entry17c?CID=0PN=5SP=10007SID=46165PID=582404DSP=CUR=840PGRP=0CACHE_ID=0 http://shop.macromedia.com/dr/v2/ec_MAIN.Entry17c?CID=0PN=5SP=10007SID=46165PID=582404DSP=CUR=840PGRP=0CACHE_ID=0 Actually, the version that comes with DWMX2004 is HS+ 5.5, which is different from Homesite 5.5.HS 5.5 doesn't have all of the CF Studio features that are in HS+ 5.5. Scott -- --- Scott Brady http://www.scottbrady.net/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Joining the dark side - using DWMX
Go buy PrimalScript for $169 and use an editor that beats DWMX and HS+/CF Studio(in my opinion because PrimalScript is more stable) and be happier and spend less money. also, since I coe in multiple languages PrimalScript fits me better than DW or HS+/CF Studio. Clint Tredway www.digital12studios.com Original Message: From: Calvin Ward [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: Joining the dark side - using DWMX Date: Sun, 21 Dec 2003 21:32:32 -0500 Exactly, HomeSite is just HomeSite, which is the html editor... HomeSite+ is ColdFusion Studio, which is the cfml editor. There are differences. Also of note, ColdFusion Studio listed at $499, whereas DWMX 2004 lists at $399 and includes HomeSite+ (ColdFusion Studio). - Calvin - Original Message - From: Scott Brady To: CF-Talk Sent: Sunday, December 21, 2003 5:19 PM Subject: Re: Joining the dark side - using DWMX Tom Kitta wrote: Actually, you can buy HS by itself, it costs you something like $99 and $29 for upgrade. It is version 5.5 which comes with DWMX2004. http://shop.macromedia.com/dr/v2/ec_MAIN.Entry17c?CID=0PN=5SP=10007SID=46165PID=582404DSP=CUR=840PGRP=0CACHE_ID=0 http://shop.macromedia.com/dr/v2/ec_MAIN.Entry17c?CID=0PN=5SP=10007SID=46165PID=582404DSP=CUR=840PGRP=0CACHE_ID=0 Actually, the version that comes with DWMX2004 is HS+ 5.5, which is different from Homesite 5.5.HS 5.5 doesn't have all of the CF Studio features that are in HS+ 5.5. Scott -- --- Scott Brady http://www.scottbrady.net/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Joining the dark side - using DWMX
Calvin Ward wrote: Exactly, HomeSite is just HomeSite, which is the html editor... HomeSite+ is ColdFusion Studio, which is the cfml editor. There are differences. Well... HomeSite works fine as a CFML editor as well, it's got the tag chooser and such... it knows full well how to handle CFML tags... however it has fewer CFML-oriented toolbars, and doesn't support RDS and stuff... HomeSite+ has all the lovely CFML toolbars, RDS, etc.. - Rick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFFTP problem.. anyone see how to get around this?
I'm trying to write a template to retrieve a file from a remote location and process it.The problem is that CFFTP cant find the correct directory on the remote site because the directory name has a space in it.Anyone know how to get around this? I'm wanting it to change to directory /Custom Extractsbut I keep getting a message saying that directory /Custom cannot be found. I've tried replacing the space with %20, and using double quotes - is there anything else I can try? Cheers Mike Kear Windsor, NSW, Australia AFP Webworks http://afpwebworks.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: OSX - Starting UP JRun/CF Automatically
Lola One way to do this is explained at: http://www.projectomega.org/article.php?lg=enphp=tuts_howtos4 You can place the resulting file in the dock or in startup items to activate at login. HTH Dick On Dec 21, 2003, at 12:44 PM, Lola Lee wrote: I've got CF and JRun installed on my powerbook. To start these up I go into Terminal and change to the directory where JRun is located, and then type ./jrun. Getting tired of typing this in all the time. I want to have JRun load automatically whenever I boot up my PB. Has anyone wrote a script to do this? -- Lola - mailto:[EMAIL PROTECTED] http://www.lolajl.net| Blog athttp://www.lolajl.net/blog/ Check out this blog: http://www.denbeste.nu I'm in Bowie, MD, USA, halfway between DC and Annapolis. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]