Re: AMF call problem, CF returning no response
What is the access modifier on the gateway functions? If public you may need to change to remote. --Nathan On Thu, Mar 7, 2013 at 9:04 PM, Rick Root rick.r...@gmail.com wrote: I'm trying this again so I can explain everything in one fell swoop... I have an old Flash app (last compiled with CS3 probably, but originally written with Flash MX 2004), and of course it makes flash remoting calls to /flashservices/gateway. By default, this is not mapped in CF 10, they changed the mapping to /flashservices/gateway/* - I figured this out and got coldfusion to respond. There are no errors logged, and I have cflog statements at the top and bottom of both function calls being called in this request. All of the logging occurs as expected. However, the server responses with a blank 200 response that looks like this - an AMF content type but no actual data in the response. I can see all this by using an http proxy (Fiddler, in this case). Here's what the response looks like: HTTP/1.1 200 OK Date: Wed, 06 Mar 2013 20:22:56 GMT Server: Apache/2.2.23 (Win64) mod_ssl/2.2.23 OpenSSL/1.0.1c mod_jk/1.2.32 Content-Length: 0 Keep-Alive: timeout=5, max=99 Connection: Keep-Alive Content-Type: application/x-amf I have scoured all the CF log files including the coldfusion-out and coldfusion-error logs to no avail. I am running Coldfusion 10.0.8 on Windows Server 2008 R2 x64 and Apache 2.2.current. The flash swf is loaded over https from the same domain the the /flashservices/gateway call is being made (also over https). Flash Remoting is enabled in the coldfusion administrator. Is there some configuration option I'm missing? Rick -- *The beatings will continue until morale improves.* ~| 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:354902 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SAML and ColdFusion - struggling.
Mark, I'm pretty well versed in Shibboleth. You say you are setting up a Shibboleth server, do you mean the IdP product? If so I don't think that is what you want. You need to set up the Shibboleth SP software on your web server in order to consume assertions. Are you receiving these assertions as part of SSO? --Nathan On Tue, Sep 13, 2011 at 2:52 PM, Mark A. Kruger mkru...@cfwebtools.com wrote: Russ... all right - I'll see if anything else turns up. I have a Java guy helping me at the moment with some samples that Ben sent me... I'll keep poking at it. -Mark Mark Kruger - CFG CF Webtools www.cfwebtools.com www.coldfusionmuse.com O: 402.408.3733 x105 E: mkru...@cfwebtools.com Skype: markakruger -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: Tuesday, September 13, 2011 1:50 PM To: cf-talk Subject: Re: SAML and ColdFusion - struggling. Free time is something I don't have in abundance, If you send me over the details I will happily take a look for you when I get a chance and see if I can make sense of it. But Shibboleth and SAML is new ground for me as well, however I have been looking into the google Single Singon service, which may be similar. On Tue, Sep 13, 2011 at 6:17 PM, Mark A. Kruger mkru...@cfwebtools.com wrote: Russ, Thanks... are you volunteering to help? -Mark Mark Kruger - CFG CF Webtools www.cfwebtools.com www.coldfusionmuse.com O: 402.408.3733 x105 E: mkru...@cfwebtools.com Skype: markakruger -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: Tuesday, September 13, 2011 11:55 AM To: cf-talk Subject: Re: SAML and ColdFusion - struggling. hey Mark, perhaps it would be best to start with the SAML portion first and get that working, it may be that you don't need Shibboleth in order to get the data you need. This seems a good place to start http://webdevwork.blogspot.com/2008/09/single-sign-on-with-saml-and-coldfusi on.html HTH Russ On Tue, Sep 13, 2011 at 5:04 PM, Mark A. Kruger mkru...@cfwebtools.com wrote: I'm in over my head trying to figure out SAML using Shibboleth server. I thought I had a grip on this but apparently not. I've installed Shibboleth and configured the XML files to point to the meta data provided by my customer. My problem is that I don't know what to DO with it? As I understand it: . AMD posts an assertion to me which I pass somehow (not clear how) to the shibboleth server. . Which knows what to do with it and gives back.. What?? There are no readable samples or turorials anywhere. I have a nice check for someone who can do this and/or educate me and help me get going on this. All I want to do is get this packet which is posted to me from the customer, unpack it so I can read the employeeID or whatever, and then create a session for that employee. The SAML requirement is the customers. If you have advice post to the list - if you want to help me directly send me a note off-list. Thanks. Mark Kruger - CFG CF Webtools www.cfwebtools.com www.coldfusionmuse.com O: 402.408.3733 x105 E: mkru...@cfwebtools.com Skype: markakruger ~| 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:347461 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Debugging SOAP
On Tuesday, May 24, 2011, Robert Rhodes rrhode...@gmail.com wrote: I don't need to monitor between my computer and the application server. I need to monitor between the application server and a remote server across the web that hosts the web service. Adding the proxyserver and proxyport attributes to you cfinvoke call will proxy the request from the application server to the remote server through your local instance of Charles, allowing you to see the traffic. To simply things you may want to install Charles on your development server. Then you can set cfinvoke's proxyserver attribute to 127.0.0.1 and the proxyport to . If using SSL you will still need to configure the remote server in Charles and add the Chalres CA to ColdFusion key store. I have no control over the remote server and the folks that do are only marginally helpful. Worse, they are taking the position that this is a Coldfusion problem. All very frustrating. It can be a bit tricky to craft SOAP requests from CF, particularly if the remote service expects complex input. You may want to check out my chapter on web services and complex types in the ColdFusion Anthology, available on Google books: http://bit.ly/cfwebservices --Na ~| 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:344886 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Debugging SOAP
You can use a proxy to do this. I use Charles. For example, assume your local computer is running Charles and has an IP address of 192.168.1.1 and the development server can reach your local computer at that address. In your cfinvoke tag, set the proxyServer attribute to 192.168.1.1 and the proxyPort to , or whatever port Charles is running on. (The default is but you can find this info in Charles under Proxy Settings...) Run your application and watch the traffic. If you are making SSL requests you will need to to configure Charles. See http://www.charlesproxy.com/documentation/proxying/ssl-proxying/. You will also need to add the Charles CA Certificate to ColdFusion's root certificate trust store. For more info on this see the Java Applications section here: http://www.charlesproxy.com/documentation/using-charles/ssl-certificates/and http://kb2.adobe.com/cps/400/kb400977.html. --Nathan On Tue, May 24, 2011 at 9:41 PM, Robert Rhodes rrhode...@gmail.com wrote: Yes they are willing to do quick non-ssl tests. But even non-secure I have had no luck getting any of the recommended monitors/proxies to capture the soap exchange between a cf9 server and their server. They tell me there is nothing specific showing up in their logs. I really just want to see the xml going out and the response. That should tell me everything I need. It is really frustrating I have had so much trouble with this. RR On Tue, May 24, 2011 at 6:39 PM, Russ Michaels r...@michaels.me.uk wrote: can you speak to the people who run the web service and ask them if you can access it without ssl or ask them if have any kind of debugging/testing interface or perhaps simply give you access to logs.. Russ On Tue, May 24, 2011 at 10:43 PM, Robert Rhodes rrhode...@gmail.com wrote: No problem Brook. Thanks for the replies. :) It seems I must have an unusual need here. RR On Tue, May 24, 2011 at 2:25 PM, Brook Davies cft...@logiforms.com wrote: Sorry Robert, I haven't used it in that context.. ~| 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:344883 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CM?
Love the Farcry!! A bit scattered on the learning curve, but it's a great program at a great price!! Geoff Bowers recently posted a FarCry Getting Started Guide to help get users up to speed with FarCry: http://blog.daemon.com.au/index.cfm?objectid=7E8FA9A1-EA69-0EC7-F2DD9803CB1F37D0 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241880 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT Checking for video plugins
Have you looked at BrowserHawk? http://www.cyscape.com/ ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207898 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Encrypting JDBC
Is it possible to encrypt the JDBC connection between ColdFusion and the database server? I'm using CFMX 7 Standard and MS SQL Server 2000. Thanks, --Nathan ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205569 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: Encrypting JDBC
Thanks everyone for the suggestions. --Nathan On 5/4/05, Dave Watts [EMAIL PROTECTED] wrote: Is it possible to encrypt the JDBC connection between ColdFusion and the database server? I'm using CFMX 7 Standard and MS SQL Server 2000. Yes. Microsoft recommends using SSL for encrypting database connections; this is supported within MS SQL Server 2000. However, I don't think the DataDirect driver supports SSL - most JDBC Type 4 drivers don't, for various reasons. At least, according to the DataDirect site, they don't support it yet: http://knowledgebase2.datadirect.com/kbase.nsf/26536a530e20a22b85256e550079a fc2/b3be2051e6ca6cdb85256ec100500d22?OpenDocumentHighlight=0,ssl The free jTDS driver (http://jtds.sourceforge.net/) does, according to its documentation, but I haven't worked much with jTDS yet. Alternatively, you might use a VPN or IPSec tunnel, as Damien suggested. 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! ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205599 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: CFMX 6.1 Standard Questions
With CFMX Standard, the context root is /, so every request is routed through the CF module for your web server to determine whether CF should handle it. Thanks Dave, I'm basing my question on an article I read on the Macromedia site, Implementing Multitier Hardware Load Balancing with ColdFusion MX for J2EE or JRun, by Frank DeRienzo and Brandon Purcell. That article states: ...put all HTML files in a /html folder and place all images underneath the web server root. In a site with a significant amount of static content you will see a significant improvement in throughput and pages/sec by separating the content; in some cases, the performance improves 200-300%. We have a decent amount of static content and was just wondering if it is something to investigate further. --Nathan ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196441 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CFMX 6.1 Standard Questions
Hello, I've recently changed jobs and have gone from working on CFMX 6.1 Enterprise (J2EE on JRun) with Oracle to CFMX 6.1 Standard with SQL Server 2000. I have a few questions relating to the differences in these environments. First, what database driver does CFMX standard use for SQL Server? Second, I know that in the J2EE config a significant performance increase may be seen by placing static content outside of the cfusion context root. Does this apply to the CFMX Standard as well? Thanks in advance for any feedback. --Nathan ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196264 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: CFMX 6.1 Standard Questions
Thanks James... On Thu, 24 Feb 2005 12:02:13 +0800, James Holmes [EMAIL PROTECTED] wrote: CFMX standard doesn't get involved in static content at all (i.e. anything not parsed as a CF file) so the location should make no difference. The driver would be DataDirect v.(whatever shipped with 6.1), unless you replace it with jDTS or the MS driver. -Original Message- From: Nathan Mische [mailto:[EMAIL PROTECTED] Sent: Thursday, 24 February 2005 10:59 To: CF-Talk Subject: CFMX 6.1 Standard Questions Hello, I've recently changed jobs and have gone from working on CFMX 6.1 Enterprise (J2EE on JRun) with Oracle to CFMX 6.1 Standard with SQL Server 2000. I have a few questions relating to the differences in these environments. First, what database driver does CFMX standard use for SQL Server? Second, I know that in the J2EE config a significant performance increase may be seen by placing static content outside of the cfusion context root. Does this apply to the CFMX Standard as well? Thanks in advance for any feedback. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196267 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: Limiting SQL Results
If you are using MySQL 4.1 you may be able to do something like: SELECT i1.ID, i1.ISBN FROM ISBN i1 WHERE i1.ID IN ( SELECT i2.ID FROM ISBN i2 WHERE i2.ISBN = i1.ISBN LIMIT 2 ) I don't use MySQL so your mileage may vary. --Nathan -Original Message- From: James Smith [mailto:[EMAIL PROTECTED] Sent: Monday, December 13, 2004 9:00 AM To: CF-Talk Subject: Limiting SQL Results Ok, heres the thing. I have a table (actually multiple tables joined but for simplicity here we will call it one table) that looks something like... ID ISBN -- 1 1 2 1 3 1 4 1 5 2 6 2 7 2 8 3 9 4 10 4 11 4 12 1 13 5 In the results I need no more than 2 of any ISBN, so for the above data I need the results of the query to look like... ID ISBN -- 1 1 2 1 5 2 6 2 8 3 9 4 10 4 13 5 The rest of thae data is irelevent, I don't care which two are returned. I am using MySQL on 2k3 server. Any help on the SQL here? -- Jay ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187474 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: String question...
There are a few ways you could do this, the easiest probably being REFind(). REFind(^AUDIT/,AUDIT/Systems) --Nathan -Original Message- From: Charles Heizer [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 08, 2004 12:37 PM To: CF-Talk Subject: String question... Hello, I was wondering if someone has a way or something to determine if a string starts with or begins with. I can do contains but what I'm looking for is if I have a string like AUDIT/Systems I want to know if the string begins with AUDIT/. Thanks, - Charles ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186657 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: An exception occurred when instantiating a Com object.
You may need to use the com2java utility. You can find more info here: http://www.macromedia.com/support/coldfusion/ts/documents/tn18211.htm -Original Message- From: Jonathan Bigelow [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 23, 2004 11:41 AM To: CF-Talk Subject: Re: An exception occurred when instantiating a Com object. I don't have any idea what dll to register. The custom tag is trying to create a connection to MS Word using the code below: CFOBJECT ACTION=CREATE CLASS=Word.Application NAME=objWord TYPE=COM How would I determine what dll needs to be registered? Shouldn't installing Word register everything that it needs? ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185209 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
/WEB-INF/cfclasses location
Before applying the 6.1 updater my CF classes were all stored in the Jrun directory (ie. C:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\WEB-INF\cfclasses). After applying the updater my classes are now being placed under the IIS webroot (ie. C:\Inetpub\wwwroot\WEB-INF\cfclasses). Is there anyway to have my classes saved in the Jrun directory like they were before I applied the updater? I see there is coldfusion.compiler.outputDir context parameter in both the j2ee-web.xml and web.xml files. The description states This is the directory where we will place compiled pages. It must be relative to the webapp root. and the value is currently /WEB-INF/cfclasses, but I'm not sure what the value should be to have the classes compiled to the Jrun directory. Any help would be greatly appreciated. Thanks, --Nathan ~| Sams Teach Yourself Regular Expressions in 10 Minutes by Ben Forta http://www.houseoffusion.com/banners/view.cfm?bannerid=40 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182003 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Bug in CFMX's arithmetic functions
Any reason you are not using CFMX 6.1? I just ran the following in CFMX 6.1 and got the expected result, 0.123. cfscript DecryptedData = 123.123; x = Evaluate(Val(#DecryptedData#) - Fix(Val(#DecryptedData#))); writeOutput(x); /cfscript Also, there is no need for the Evaluate function, Val function or pound signs in the above _expression_. You should be able to just use cfset x = DecryptedData - Fix(DecryptedData) Or cfscript x = DecryptedData - Fix(DecryptedData); /cfscript HTH, --Nathan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CFMX Enterprise, JRun and Flash Remoting
We recently upgraded our ColdFusion server from Pro to Enterprise and now we can't seem to get Flash Remoting working. When Ibrowse to flashservices/gateway I get a blank page, but when I try to connect to a service from the Flash Service Browser I get the following error: Service threw an exception during method invocation: No service named myservice is known to Flash Remoting MX. This is a multihomed Windows 2003 server. JRun is connected to IIS and ColdFusion is deployed as an .ear. I've seen a few items in the archives and on the MM site that deal with Flash Remoting on multihomed ColdFusion Pro, but I can't seem to find anything on Enterprise. I've gone through this checklist in this Flash Remoting TechNote (http://www.macromedia.com/support/flash_remoting/ts/documents/cfmx_fr_c hecklist.htm) and noticed I didn't have the flashgateway.ear deployed. I tried deploying that ear and I still get a blank page when I browse to flashservices/gateway, but I still can't find my services. Any help would be greatly appreciated. Thanks, --Nathan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFMX Enterprise, JRun and Flash Remoting
I've been working on this off and on all day, and this is what my investigation has uncovered so far. I tried accessing the service in question as a web service (http://www.mysite.com/myservice.cfc?wsdl) and this was causing a HTTP 500 Internal server error. I looked at the Jrun log (C:/Jrun4/logs/cfusion-out.log) for the server in question and noticed that two classes are not loading, coldfusion.xml.rpc.CFCServlet and org.apache.axis.transport.http.AxisServlet. (I've attached relevant portions of my log below.) This server had all hot fixes listed at http://www.macromedia.com/support/coldfusion/ts/documents/tn17883.htm applied when it was first setup. I noticed that the Web Service Headers with ColdFusion MX hot fix (http://www.macromedia.com/support/coldfusion/ts/documents/webservices_h eader.htm) replaced the axis class in question so I uninstalled that hot fix. This fixed the errors in my log file but I still get an Internal server error when trying to access the .cfc as a web service. Any ideas? Thanks, --Nathan Below is my part of my cfusion-out.log with the hotfix applied: - Starting logging... 06/23 14:17:16 user ColdFusionStartUpServlet: ColdFusion MX: Starting application services 0 [scheduler-1] INFO coldfusion.server- Starting logging... 06/23 14:17:16 user ColdFusionStartUpServlet: ColdFusion MX: VM version = 1.4.2-b28 06/23 14:17:19 user ColdFusionStartUpServlet: ColdFusion MX: application services are now available 06/23 14:17:19 user CFCServlet: init 06/23 14:17:20 user CFCServlet: failed to load: coldfusion.xml.rpc.CFCServlet 06/23 14:17:20 user AdminServlet: init 06/23 14:17:20 user AdminServlet: failed to load: org.apache.axis.transport.http.AxisServlet 06/23 14:17:34 user CFCServlet: init 06/23 14:17:34 user CFCServlet: failed to load: coldfusion.xml.rpc.CFCServlet And without the hotfix applied: - Starting logging... 06/23 14:34:44 user ColdFusionStartUpServlet: init 0 [scheduler-1] INFO coldfusion.server- Starting logging... 06/23 14:34:44 user ColdFusionStartUpServlet: ColdFusion MX: Starting application services 06/23 14:34:44 user ColdFusionStartUpServlet: ColdFusion MX: VM version = 1.4.2-b28 06/23 14:34:47 user ColdFusionStartUpServlet: ColdFusion MX: application services are now available 06/23 14:34:47 user CFCServlet: init 06/23 14:34:47 user CFCServlet: init 06/23 14:34:47 user AdminServlet: init 06/23 14:34:47 user AdminServlet: init From: Nathan Mische [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 23, 2004 10:04 AM To: CF-Talk Subject: CFMX Enterprise, JRun and Flash Remoting We recently upgraded our ColdFusion server from Pro to Enterprise and now we can't seem to get Flash Remoting working. When Ibrowse to flashservices/gateway I get a blank page, but when I try to connect to a service from the Flash Service Browser I get the following error: Service threw an exception during method invocation: No service named myservice is known to Flash Remoting MX. This is a multihomed Windows 2003 server. JRun is connected to IIS and ColdFusion is deployed as an .ear. I've seen a few items in the archives and on the MM site that deal with Flash Remoting on multihomed ColdFusion Pro, but I can't seem to find anything on Enterprise. I've gone through this checklist in this Flash Remoting TechNote (http://www.macromedia.com/support/flash_remoting/ts/documents/cfmx_fr_c hecklist.htm) and noticed I didn't have the flashgateway.ear deployed. I tried deploying that ear and I still get a blank page when I browse to flashservices/gateway, but I still can't find my services. Any help would be greatly appreciated. Thanks, --Nathan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFMX Enterprise, JRun and Flash Remoting (Update)
I've been working on this off and on all day and this is what my investigation has uncovered so far. I tried accessing the service in question as a web service (http://www.mysite.com/myservice.cfc?wsdl) and this was causing a HTTP 500 Internal server error. I looked at the Jrun log (C:/Jrun4/logs/cfusion-out.log) for the server in question and noticed that two classes are not loading, coldfusion.xml.rpc.CFCServlet and org.apache.axis.transport.http.AxisServlet. (I've attached relevant portions of my log below.) This server had all hot fixes listed at http://www.macromedia.com/support/coldfusion/ts/documents/tn17883.htm applied when it was first setup. I noticed that the Web Service Headers with ColdFusion MX hot fix (http://www.macromedia.com/support/coldfusion/ts/documents/webservices_h eader.htm) replaced the axis class in question so I uninstalled that hot fix. This fixed the errors in my log file but I still get an Internal server error when trying to access the .cfc as a web service. I imagine the cfc has to be accessible as a web service for Flash Remoting to work. Am I correct? I'm new to Jrun, so if anyone can give me some pointers as to where I should be looking to fix this I'm all ears. (No pun intended.) Thanks, --Nathan Below is my part of my cfusion-out.log with the hotfix applied: - Starting logging... 06/23 14:17:16 user ColdFusionStartUpServlet: ColdFusion MX: Starting application services 0 [scheduler-1] INFO coldfusion.server- Starting logging... 06/23 14:17:16 user ColdFusionStartUpServlet: ColdFusion MX: VM version = 1.4.2-b28 06/23 14:17:19 user ColdFusionStartUpServlet: ColdFusion MX: application services are now available 06/23 14:17:19 user CFCServlet: init 06/23 14:17:20 user CFCServlet: failed to load: coldfusion.xml.rpc.CFCServlet 06/23 14:17:20 user AdminServlet: init 06/23 14:17:20 user AdminServlet: failed to load: org.apache.axis.transport.http.AxisServlet 06/23 14:17:34 user CFCServlet: init 06/23 14:17:34 user CFCServlet: failed to load: coldfusion.xml.rpc.CFCServlet And without the hotfix applied: - Starting logging... 06/23 14:34:44 user ColdFusionStartUpServlet: init 0 [scheduler-1] INFO coldfusion.server- Starting logging... 06/23 14:34:44 user ColdFusionStartUpServlet: ColdFusion MX: Starting application services 06/23 14:34:44 user ColdFusionStartUpServlet: ColdFusion MX: VM version = 1.4.2-b28 06/23 14:34:47 user ColdFusionStartUpServlet: ColdFusion MX: application services are now available 06/23 14:34:47 user CFCServlet: init 06/23 14:34:47 user CFCServlet: init 06/23 14:34:47 user AdminServlet: init 06/23 14:34:47 user AdminServlet: init [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: cfscript question
Yes, the variables are in the variables scope. While it is not necessary to use the var statement, you probably want to for such things as loop counters and other local variables. http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/udfs12.htm http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/udfs12.htm HTH --Nathan From: Jim McAtee [mailto:[EMAIL PROTECTED] Sent: Friday, May 07, 2004 1:33 PM To: CF-Talk Subject: cfscript question If the declaration of variables using var within cfscript isn't necessary, what kind of variables are being created?Are they in the variables scope? For example, the variables 'sdatefmt' and 'edatefmt' in the cf function shown below: function DateRangeFormat(sdate, edate, mask, divider) { if (IsDate(sdate)) sdatefmt = DateFormat(sdate, mask); else sdate = ; if (IsDate(edate)) edatefmt = DateFormat(edate, mask); else edate = ; if (Len(sdatefmt) and Len(edatefmt) and (sdatefmt is not edatefmt)) return sdatefmt divider edatefmt; else if (Len(sdatefmt)) return sdatefmt; else if (Len(edatefmt)) return edatefmt; else return ; } [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Oracle, CLOBs and the Oracle Thin Driver
Does anyone know if it is possible to work with CLOBs using Oracle's Thin Driver? It is my understanding that to work with CLOBs in Oracle you must use bind parameters. However if I attempt to update a CLOB field using cfqueryparam with a cfsqltype of CF_SQL_CLOB, the update does not work. The query does not throw an error, and if the CLOB column contained any data it is cleared. I can update the column using cfqueryparam and a cfsqltype of CF_SQL_LONGVARCHAR, but if the update is larger that 4000 characters it fails with the following error: Data size bigger than max size for this type. I did notice that Oracle has its own CLOB class, oracle.sql.CLOB. Could this class be conflicting with the standard java.sql.CLOB class, and if so, is there any way to work around this? I'm using CFMX 6.1 Standard, Oracle 9i 9.2.0.1 JDBC Drivers (odbc14.jar, ocrs12.zip), and my java version is 1.4.2. Thanks, --Nathan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF Portal...
You may want to look into FarCry. http://farcry.daemon.com.au Also, Macromedia's Spectra has gone open-source. http://spectrasource.macromedia.com/active/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Spell Check custom tag needed
Darron Schall has an article in the latest CFDJ about using the Java open source spell checker Jazzy (http://sourceforge.net/projects/jazzy) with ColdFusion. You may want to check that out. --Nathan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Simple UPDATE Stuff Driving Me Insane...
I would also recommend using CFQUERYPARAM. cfquery name=AgentDetails datasource=020 UPDATE PropertyAgent SET PropertyAgentCompanyName = cfqueryparam value=#Form.PropertyAgentCompanyName# cfsqltype=CF_SQL_VARCHAR /, PropertyAgentFlatNumberHouseName = cfqueryparam value=#Form.PropertyAgentFlatNumberHouseName# cfsqltype=CF_SQL_VARCHAR /, PropertyAgentStreetNumber = cfqueryparam value=#Form.PropertyAgentStreetNumber# cfsqltype=CF_SQL_NUMERIC /, . . . WHERE PropertyAgentID = cfqueryparam value=#Client.PropertyAgentID# cfsqltype=CF_SQL_NUMERIC / /cfquery HTH, --Nathan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Simple UPDATE Stuff Driving Me Insane...
I agree you should use CFQUERYPARAM, but not during debugging Interesting. I find using CFQUERYPARAM makes debugging easier as it generates very clear error messages such as: Error Executing Database Query. Invalid data 123-456-7890 for CFSQLTYPE CF_SQL_NUMERIC. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF Eclipse plug-in sourceforge
Awesome, I've been looking for an Eclipse plug-in for CFML. Thanks Rob. --Nathan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: PayflowPro and CFMX
You can use the Java cfx_payflowpro tag, you just have to make sure you pass in all attributes. See the VeriSign knowledge base article vs12273. http://kb.verisign.com/esupport/esupport/consumer/esupport.asp?id=vs1227 3 HTH, Nathan From: chad [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 1:53 PM To: CF-Talk Subject: PayflowPro and CFMX I noticed a discussion on this board about PayFlowPro not working with CFMX. But I think the solution was handled by sending the person who was having the problem a .dll version of PayFlowPro. Does anyone have this or have another solution to get this to work? Thanks, Chad [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: PayflowPro and CFMX
Hmm... I have it working on CFMX 6.1, and had it working on CFMX 6.0 before that. Which version of CFMX are you using? --Nathan From: Eric Hoffman [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 2:25 PM To: CF-Talk Subject: RE: PayflowPro and CFMX We are passing all, but still get this error: (CFX_PayflowPro and CFX_CFXPayflowPro are registered on the server.) Error processing CFX custom tag CFX_CFXPayFlowPro. on /hzc/contacts/cc_process.cfm DIAGNOSTIC: Error processing CFX custom tag CFX_CFXPayFlowPro. The CFX custom tag CFX_CFXPayFlowPro was not found in the custom tag database. Please be sure to add custom tags to the database before using them. If you have added your tag to the database then you should check the spelling of the tag within your template to insure that it matches the database entry. The error occurred on line 14. I believe it is in the class there is an error, wasn't this verified by Verisign? _ From: Nathan Mische [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 1:07 PM To: CF-Talk Subject: RE: PayflowPro and CFMX You can use the Java cfx_payflowpro tag, you just have to make sure you pass in all attributes. See the VeriSign knowledge base article vs12273. http://kb.verisign.com/esupport/esupport/consumer/esupport.asp?id=vs1227 3 HTH, Nathan From: chad [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 1:53 PM To: CF-Talk Subject: PayflowPro and CFMX I noticed a discussion on this board about PayFlowPro not working with CFMX. But I think the solution was handled by sending the person who was having the problem a .dll version of PayFlowPro. Does anyone have this or have another solution to get this to work? Thanks, Chad _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: PayflowPro and CFMX
Try changing your class path to D:\CFusionMX\Java\classes\CFX_JSpellCheck\CFX_JSpellCheckjar,D:\CFUSIONM X\Java\classes, In 6.0 you had to point your class path to the Verisign.jar file, but I don't think this is necessary in 6.1. Also, make sure the CFXPayFlowPro.class file is in the D:\CFUSIONMX\Java\classes folder as well. HTH, --Nathan From: chad [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 3:29 PM To: CF-Talk Subject: Re: PayflowPro and CFMX I am using CFMX 6.1 and have the same setup I had on CFMX 5.0. I have followed the VeriSign document to the T and still can't get it to work.My class path is as follows. D:\CFusionMX\Java\classes\CFX_JSpellCheck\CFX_JSpellCheckjar,D:\CFUSIONM X\Java\classes\Verisign.jar, And I have the following CFX tag set up: Tag Name: CFX_PAYFLOWPRO Class Name: CFXPayFlowPro Description: CFXPayFlowPro Thanks for the help Chad - Original Message - From: Nathan Mische To: CF-Talk Sent: Wednesday, January 07, 2004 2:42 PM Subject: RE: PayflowPro and CFMX Hmm... I have it working on CFMX 6.1, and had it working on CFMX 6.0 before that. Which version of CFMX are you using? --Nathan From: Eric Hoffman [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 2:25 PM To: CF-Talk Subject: RE: PayflowPro and CFMX We are passing all, but still get this error: (CFX_PayflowPro and CFX_CFXPayflowPro are registered on the server.) Error processing CFX custom tag CFX_CFXPayFlowPro. on /hzc/contacts/cc_process.cfm DIAGNOSTIC: Error processing CFX custom tag CFX_CFXPayFlowPro. The CFX custom tag CFX_CFXPayFlowPro was not found in the custom tag database. Please be sure to add custom tags to the database before using them. If you have added your tag to the database then you should check the spelling of the tag within your template to insure that it matches the database entry. The error occurred on line 14. I believe it is in the class there is an error, wasn't this verified by Verisign? _ From: Nathan Mische [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 1:07 PM To: CF-Talk Subject: RE: PayflowPro and CFMX You can use the Java cfx_payflowpro tag, you just have to make sure you pass in all attributes. See the VeriSign knowledge base article vs12273. http://kb.verisign.com/esupport/esupport/consumer/esupport.asp?id=vs1227 3 HTH, Nathan From: chad [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 1:53 PM To: CF-Talk Subject: PayflowPro and CFMX I noticed a discussion on this board about PayFlowPro not working with CFMX. But I think the solution was handled by sending the person who was having the problem a .dll version of PayFlowPro. Does anyone have this or have another solution to get this to work? Thanks, Chad _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: First foray into COM - getting an error
Are you running CFMX. If so make sure you have the proper Java stubs for Outlook. See Macromedia TechNote 22922, Accessing Complex COM Objects in ColdFusion MX using Java Stubs, for more info. http://www.macromedia.com/support/coldfusion/ts/documents/tn18211.htm --Nathan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, December 15, 2003 5:17 AM To: CF-Talk Subject: First foray into COM - getting an error Why am I getting An exception occurred when instantiating a Com object. The cause of this exception was that: coldfusion.runtime.com.ComObjectInstantiationException: An exception occurred when instantiating a Com object.. >From the following code ? cftry !--- try to open a connection--- cfobject type=COM name=objOutlook class=Outlook.Application action=""> cfcatch !--- if it doesn't exist then create a new connection --- cfobject type=COM name=objOutlook class=Outlook.Applicaton action=""> /cfcatch /cftry Any COM folks shed some light onto this ? Cheers, Darren [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Server-side redirects, jsessionID and IIS
I'm doing a server side redirect using getPageContext().forward(). With J2EE sessions enabled I think the redirect ends up being to something like http://www.myserver.com/index.cfm;jsessionID=123456789?param1=whatever. Am I correct in this thinking? Anyway, using getPageContext().forward() with J2EE sessions is causing IIS to return 404 - file not found. Does anyone know how to work around this? Thanks. --Nathan ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137723 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: cgi.auth_password
I don't think it is possible. It would be a huge security risk if it were... --Nathan -Original Message- From: Suyer, Ed [PRD Non-JJ] [mailto:[EMAIL PROTECTED] Sent: Friday, September 19, 2003 4:29 PM To: CF-Talk Subject: cgi.auth_password Is it possible to retrieve an authenticated user's password? Basic authentication is on. ~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137759 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: Word Com Problems
I think \page is the control word for a required page break in RTF. HTH --Nathan -Original Message- From: Den Melton [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 2:47 PM To: CF-Talk Subject: Word Com Problems The solution at: http://tech.irt.org/articles/js154/index.htm worked very well. Does anyone know how to put a page break in after each record is returned so each one displays on a seperate page in the document? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: DRK4 - pollster
Do you have authenticated access enabled on the pollster directory? I ran into a similar problem because I have integrated Windows authentication enabled on my development server and that was causing a problem with the cflogin. The cflogin structure was being populated with my credentials, needed to access the secured directory, rather than the macromedia/pollster username and password the cflogin tag expects. I had to enable anonymous access on the pollster directory to get the login to work. I'm guessing you could also modify the cflogin code to get it to work with your login credentials, but I didn't bother to try that out... HTH, Nathan -Original Message- From: Critz [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 12:15 PM To: CF-Talk Subject: Re: DRK4 - pollster oi Mike!! ie/win2k/iis the path is correct, but I don't think it even gets to any point where it is using the FR, it's stuck in the login section crit Tuesday, July 29, 2003, 10:25:34 AM, you wrote: MC - Original Message - MC From: Critz [EMAIL PROTECTED] server 2: installed files. went to login to admin, but everytime I login MC to the challenge/response dialogit just keeps popping up like i have entered the wrong MC info. any ideas? MC What browser / OS are you using? MC Make sure that you use an absolute path to specify the Flash MC Remoting gateway (which is set in the Application.cfm) file. MC Does that help? MC mike chambers MC [EMAIL PROTECTED] MC ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Application Security using cflogin and cfloginuser
This sounds like the exact same issue I was having trying to use cflogin with integrated windows authentication on IIS 5. The issue seemed to be resolved in updater 2. --Nathan ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFX_PayFlowPro and CFMX
Ali, For CFX_PayFlowPro to work on CFMX you must pass all attributes into the tag, including PARMLIST,PROXYADDRESS,PROXYPORT,PROXYLOGON, and PROXYPASSWORD. These attributes will usually be left blank, like this: CFX_PAYFLOWPRO QUERY=RESULT HOSTADDRESS=test-payflow.verisign.com HOSTPORT=443 TIMEOUT=30 USER=YourUser PWD=YourPassword PARTNER=YourPartner TRXTYPE=S TENDER=C ACCT=5105105105105100 EXPDATE=0403 AMT=1.50 COMMENT1=test COMMENT2=test STREET=123 test ZIP=95404 PARMLIST= PROXYADDRESS= PROXYPORT= PROXYLOGON= PROXYPASSWORD= You can find this solution in the VeriSign KB: http://kb.verisign.com/esupport/esupport/payments/esupport.asp?selected= solutionlistuser=strCurrentSymptom=strDisplaySymptom= Search for soulution ID: vs12273 That said, I'm currently using CFX_PAYMENTNET, the C++ CFX tag that was distributed before the Java based CFX_PayFlowPro tag. I was using CFX_PayFlowPro on CF5, but VeriSign had me switch back to CFX_PAYMENTNET when I migrated to MX, before this issue was resolved. HTH, --Nathan ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
3 Cells Wide
Hey Guy, This is what I came up with: cfquery name=queryName datasource=datasourceName SELECT c.categoryName, s.subCategoryName FROM tblCategory c, tblSubCategory s WHERE c.categoryid = s.categoryid ORDER BY c.categoryName /cfquery cfset categoryCount=1 table tr cfoutput query=queryName group=categoryName cfif not categoryCount mod 4/trtr/cfif td valign=top b#queryName.categoryName#/bbr cfset subCategoryCount=1 cfoutput cfif subCategoryCount lte 3 #queryName.subCategoryName#br cfelseif subCategoryCount eq 4 More... /cfif cfset subCategoryCount=subCategoryCount+1 /cfoutput /td cfset categoryCount=categoryCount+1 /cfoutput /tr /table There may be a more efficient way of doing what you proposed, but this gets the job done. Best, Nathan -Original Message- From: Guy McDowell [mailto:[EMAIL PROTECTED]] Sent: Friday, February 21, 2003 11:26 AM To: CF-Talk Subject: Re: 3 Cells Wide Hi Dave (and everyone else), I've got the grouping and ordering down, it's the formatting of the output that's the challenge. The trick is to get my HTML table only 3 cols wide and then only have the first 3 results of the query on the Subcategory table displayed under the appropriate Category heading. I have a straight HTML version on the index of my site to illustrate where I am trying to go with this. It's at http://www.guymcdowell.com TIA, Truly, Guy J. McDowell, M.M.C.P. (705) 324-9144 ex 3422 [EMAIL PROTECTED] Sir Sandford Fleming College Frost Campus P.O. Box 8000 Lindsay, Ontario K9V 5E6 [EMAIL PROTECTED] 02/21/03 10:33am This is a borderline newbie question. Perhaps we should have a CF-Brainfart list. Anyway Challenge: To have out put from two tables put into a three column wide, n-rows deep HTML table a la Yahoo! Each column's formatted output would look something like this: Category Name Subcategory Name 1, Subcategory Name 2, Subcategory Name 3, more... Given: CF 5, MS Access 2000, tblCategory, tblSubcategory, one rusty CF developer. I'm pretty sure this is a job for query-a-query and loop list while n=3 type logic, but I just can't get it to jive. Help? Nah. Look into the group attribute of the cfoutput query... tag. Just group your query results by the category name and you should be good to go. The key is the ORDER BY clause in your SQL statement. You want to make sure you order by the category name so that CF can properly group the data. Here's a brief sample: cfquery name=queryName datasource=myDSN SELECT c.categoryName, s.subcategory FROM tblCategory c, tblSubcategory s WHERE c.categoryid = s.categoryid ORDER BY c.categoryName /cfquery Then in your output, you'd do something like: cfoutput query=queryName group=categoryid #queryName.categoryName#br/ cfoutput#queryName.subcategory#/cfoutput /cfoutput The nested cfoutput is necessary because you need to tell CF which fields to group. Something like that should take care of your issue. Haven't tested that code, but it looks Kosher. Regards, Dave. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: 3 Cells Wide
Sorry, I posted that without testing. To get a new row every three cells, the output code should be: cfset categoryCount=1 table tr cfoutput query=queryName group=categoryName td valign=top b#queryName.categoryName#/bbr cfset subCategoryCount =1 cfoutput cfif subCategoryCount lte 3 #queryName.subCategoryName# br cfelseif subCategoryCount eq 4 More... /cfif cfset subCategoryCount = subCategoryCount+1 /cfoutput /td cfif categoryCount mod 3 eq 0/trtr/cfif cfset categoryCount=categoryCount +1 /cfoutput /tr /table --Nathan -Original Message- From: Nathan Mische Sent: Friday, February 21, 2003 12:23 PM To: CF-Talk Subject: 3 Cells Wide Hey Guy, This is what I came up with: cfquery name=queryName datasource=datasourceName SELECT c.categoryName, s.subCategoryName FROM tblCategory c, tblSubCategory s WHERE c.categoryid = s.categoryid ORDER BY c.categoryName /cfquery cfset categoryCount=1 table tr cfoutput query=queryName group=categoryName cfif not categoryCount mod 4/trtr/cfif td valign=top b#queryName.categoryName#/bbr cfset subCategoryCount=1 cfoutput cfif subCategoryCount lte 3 #queryName.subCategoryName#br cfelseif subCategoryCount eq 4 More... /cfif cfset subCategoryCount=subCategoryCount+1 /cfoutput /td cfset categoryCount=categoryCount+1 /cfoutput /tr /table There may be a more efficient way of doing what you proposed, but this gets the job done. Best, Nathan -Original Message- From: Guy McDowell [mailto:[EMAIL PROTECTED]] Sent: Friday, February 21, 2003 11:26 AM To: CF-Talk Subject: Re: 3 Cells Wide Hi Dave (and everyone else), I've got the grouping and ordering down, it's the formatting of the output that's the challenge. The trick is to get my HTML table only 3 cols wide and then only have the first 3 results of the query on the Subcategory table displayed under the appropriate Category heading. I have a straight HTML version on the index of my site to illustrate where I am trying to go with this. It's at http://www.guymcdowell.com TIA, Truly, Guy J. McDowell, M.M.C.P. (705) 324-9144 ex 3422 [EMAIL PROTECTED] Sir Sandford Fleming College Frost Campus P.O. Box 8000 Lindsay, Ontario K9V 5E6 [EMAIL PROTECTED] 02/21/03 10:33am This is a borderline newbie question. Perhaps we should have a CF-Brainfart list. Anyway Challenge: To have out put from two tables put into a three column wide, n-rows deep HTML table a la Yahoo! Each column's formatted output would look something like this: Category Name Subcategory Name 1, Subcategory Name 2, Subcategory Name 3, more... Given: CF 5, MS Access 2000, tblCategory, tblSubcategory, one rusty CF developer. I'm pretty sure this is a job for query-a-query and loop list while n=3 type logic, but I just can't get it to jive. Help? Nah. Look into the group attribute of the cfoutput query... tag. Just group your query results by the category name and you should be good to go. The key is the ORDER BY clause in your SQL statement. You want to make sure you order by the category name so that CF can properly group the data. Here's a brief sample: cfquery name=queryName datasource=myDSN SELECT c.categoryName, s.subcategory FROM tblCategory c, tblSubcategory s WHERE c.categoryid = s.categoryid ORDER BY c.categoryName /cfquery Then in your output, you'd do something like: cfoutput query=queryName group=categoryid #queryName.categoryName#br/ cfoutput#queryName.subcategory#/cfoutput /cfoutput The nested cfoutput is necessary because you need to tell CF which fields to group. Something like that should take care of your issue. Haven't tested that code, but it looks Kosher. Regards, Dave. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq