Anyone seen this or know what it means?
A user got this message after completing one of the forms in our application. W2k server/CFMX/SQL Server 200. I did notice they were using a MAC for what it's worth. I pasted the SQL displayed in the error msg directly into the SQL Server and it executed without a problem. Any clues? tia Julian [MERANT][SequeLink JDBC Driver]Statement did not generate a result set. ~| 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Sun One Webserver and CGI variables
Hi all, I'm testing the Sun One Web Server with CFMX and finding that it does not return all the CGI variables I'm used to seeing with Apache, IIS or even Website. Sun tech support sent me a JSP that appears to reference things like USER_AGENT etc, stuff that I'm interested in for browser detection. However, CFMX threw the following error when I ran the snoop.jsp page supplied by SUN. Is it possible that I need the Enterprise version of CFMX to access variables from the SUN ONE web server that I can access with CFMX pro using Apache, IIS or Website.? Thanks in advance for any ideas on this. Julian McNamara CFMX Error Msg A License Exception has been thrown You tried to access a restricted feature for the Professional edition: JSP Please Try The Following: ·Check the ·CFML Reference Manual to verify that you are using the correct syntax. ·Search the ·Knowledge Base to find a solution to your problem. Browser Remote Address 129.85.135.101 Referer Date/Time 08-Aug-02 06:07 PM Stack Trace coldfusion.license.LicenseManager$LicenseIllegalAccessException: A License Exception has been thrownat coldfusion.license.LicenseManager._checkJSP(Unknown Source)at coldfusion.license.LicenseManager.checkJSP(Unknown Source)at coldfusion.license.JspLicenseServlet.service(Unknown Source)at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:241)at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:198)at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:348)at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451)at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:294)at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFX tag not working with CFMX?
Greetings all, We've been using the CFX_PRINTREPORT tag to print crystal reports using selection criteria from a CF application since version 3. On a development machine (Win2k server, SQL Server, Sun One Web Server, CFMX) the tag no longer works. It's correctly registered in the administrator, but the template that references the tag stops with an error Unable to load library Does anyone know where to start looking for the cause of this problem? Thanks in advance, julian FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Does file upload work with MAC clients?
Hi, We're having trouble with file uploads when a MAC client is being used. Running NT4.0 SP6, CF5.0, and either Website or Apache The templates work fine with PC clients in any browser but with IE5.1 on the MAC, the upload box appears, you can select a file and hit upload and the browser progress bar will commence as if an upload is occurring but no file is ever uploaded. We have enctype=multipart/form-data etc, and this fails only on the MAC. Anyone have any clues. Thanks, Julian FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Spurious mail.log entries
Greetings all, Were using CF5 to enable multiple attachments to generated emails. I'm getting what appear to be spurious entires in mail.log - spurious because there's a corresponding entry in the mail_sent.log and it appears as if the email and attachments have indeed been sent. There are some occasions on which the emails are not sent but there is no information in the file referred to in the log entry - it's completely blank. The message in the log is : Failed to send the spooled mail file, E:\CFUSION\Mail\spool\4EB.cfmail. SMTP server replied Cannot attach 'E:\CFUSION\Mail\spool\4EB.cfmail' to the mail message. The file does not exist. Moved file to E:\CFUSION\Mail\undelivr\4EC.cfmail. In this case the file 4ec.cfmail is a blank file. Any help greatly appreciated. Cheers, julian mcnamara FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFX Tags and CF5
Greetings all, I recently upgraded a server to CF5.0 and a CFX tag immediately stopped working. I read another post about problems with the EXCEL tag and CF5.0 I re-registered the tag I'm using in the CF administrator but it didn't solve the problem. The tag appears to execute, there are no errors, but there are also no results. I'm using the CFX_PRINTREPORT tag to call a Crystal report from within the browser. Does anyone have any idea where to start solving this one? Thanks in advance, julian ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Linking tables across multiple datasources
It depends on your database to some extent. If you're using Access the simplest solution would be to link the emp_course table in PQR to emp_details in XYZ using the file/get external data/link tables menu. You can write SQL statements specifying XYZ as the datasource and reference the emp_course table that is linked. If you're using SQL Server or need to maintain a migration path from Access to SQL Server the SQL syntax is SELECT * FROM emp_details INNER JOIN db_name.dbo.emp_course ON whatever. I have found that to allow the same set of templates to be used for Access and SQL server in this situation I had to specify a db_prefix variable which was set to "db_name.dbo." in a SQL Server environment and to "" for Access. The SQL syntax that would execute on both platforms was: SELECT * FROM emp_details INNER JOIN #db_prefix#emp_course ON whatever Hope this helps Julian -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Access linked tables upsized to SQL Server??
Greetings, Aside from re-writing the code, is there any way to deal with tables that were linked in an Access database but which has been upsized to SQL Server? The upsizing wizard creates an empty table with the same name in the new SQL Server database. Is there a way to relink to the data in a separate database. Linked servers seems like a possibility but it also seems like it's meant to run distributed queries over heterogeneous servers. Any thoughts on a more simple way to do this? TIA, Julian -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CFFILE in multiserver setup?
Greetings all, Briefly, does the destination attribute of CFFILE have to be a directory on the same server that is running Cold Fusion? Less briefly, can I specify that a file upload, the template for which is served by the CF server on machine A, occurs to a directory on machine B (which is not running CF). Further, if this can be done, can machine A be an NT box and machine B a unix box? Further still, if machine B which is a unix box, has 100Mb/sec upload bandwidth available to it, and machine A which is connected to machine B by a 10 Mb/sec radio link, (and has no other way to connect to the outside) what is the bandwidth available to users from the internet at large, wanting to upload files using a template served by the CF server on Machine A. Ie because the page is served from machine A,(10Mb/sec pipe) even though the destination is on machine B(100Mb/sec pipe), does this mean the 10Mb/sec bandwidth applies? My reading of the description of running distributed CF leads me to understand that CF must be installed on all servers involved, even if only one of them will actually be the cf server. Am I correct in this reading? As you can see from this question I'm trying to determine whether I would need to purchase CF for both the machines mentioned above. Any thoughts much appreciated, Julian B-rave STUDIO -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CFX_PRINTREPORT tag problems...
Greetings all, I'm using a CFX tag to print Crystal Reports on a designated network printer from a CF application. I've had the original tag modified to accept a "landscape" orientation for the printer. The tag basically calls the Crystal reports engine supplying the report name, printer, port, any record selection criteria and the new orientation parameter. I'm getting an error when calling the tag but there's no discernible pattern as to when the error occurs. Sometimes it will work perfectly, many times in a row. Sometimes it will fail with the same msg many times in a row and then start working again with no intervening changes to anything on the system. The error is simply "Error occurred in tag CFX_PRINTREPORT" followed by "unexpected error occurred while processing tag" Does anyone have any suggestions as to where to start in identifying the cause of this problem?. I have found locally that if I stop and re-start the CF server that I don't get the error ( ie I do get the error if the CF server is started as part of boot up, but not after I stop and re-start it) but this is not the case on the server where the application is running. It's extremely frustrating as I don't know C++ an can't go into the tag to figure out what might be causing the problem in there. Any suggestions would be greatly appreciated. TIA Julian -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.