Very slow JDBC/mySQL query - what's responsible?

Hello! I have got two simple SQL statements in my CFMX - application: SELECT companyname, uidnumber, description, telephone FROM companies WHERE entrykey = ? ; Query Parameter Value(s) - Parameter #1(cf_sql_varchar) = 2405961E-FE08-E3BE-059C648DC01198A9 SELECT LEFT(companyname, 250) AS companyn

CFMX 7 & JRockit

Hello! I installed the upgrade to ColdFusion MX 7 but now I can't start the server because ColdFusion MX 7 seems not to support the BEA JRockit JVM. I also tried to install the 1.5 JVM (aka Java 5) but I still receive an error: "error coldfusion/filter/RequestMonitorFilter java.lang.NoClassDefFo

Add locales to JVM

Hello! I am outputting data using LSDateFormat(). Now we've added a polish version to out webservice ... and the JVM seems to have no locale settings installed for this language. Can these locales be added/downloaded from somewhere? How do you work with LS in an i18n sourrounding? Best reg

JVM crash - autorestart?

Hello! Is it possible to configure the JVM/ColdFusion to auto-restart the JVM if it crashes with an JVM hotspot error? Best regards, Peter ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfh

"Cannot create cookie" error message in cfserver.log

Hello! I've got the following error messages from time to time in my cfserver.log logfile - what could be the reason? Best regards, Peter 07/06 22:16:40 error Cannot create cookie: expires = Wed 07/06 22:16:40 error Cannot create cookie: path = /CFTOKEN=18863495 07/06 22:16:40 error Cannot crea

coldfusion, apache and mod_rewrite

Hello! Using the popular mod_rewrite module I would like to offer simple "entry points" to our website like http://www.somewhere.com/go/customer1/ Internally, these requests should be redirected to http://www.somewhere.com/gocustomer.cfm?customer=customer1 Using mod_rewrite I have declared th

Set metadata of query created with QueryNew

Hello! I am creating queries on runtime using QueryNew() and performing some query of queries on them. Sometimes I (respectivly the users) receive errors like "Error Executing Database Query. Query Of Queries runtime error. Unsupported type comparison.". Also NULL errors occur (maybe because I

=?ISO-8859-1?Q?Clear_directory_runtime/servers/default/SERVER-INF/temp/wwwroot-tmp??Clear_directory_runtime/servers/default/SERVER-INF/temp/wwwroot-tmp

Hello! The size of the directory has gone up to 1.2 GB within the last few months - can I safely empty this directory? Best regards, Peter ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: ht

=?ISO-8859-1?Q?Clear_directory_runtime/servers/default/SERVER-INF/temp/wwwroot-tmp??Clear_directory_runtime/servers/default/SERVER-INF/temp/wwwroot-tmp

Hello! The size of the directory has gone up to 1.2 GB within the last few months - can I safely empty this directory? Best regards, Peter ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: ht

Permission_system_(role/user/level_based)

Hello! I'm currently working on a concept of a permission system for a large coldfusion based website. The requirements: - Provide general role based permissions ("admins" can do everything, "managers" almost everything, "guests" are just allowed to take a look) - Provide object based permis

Parse cfm templates stored in a variable?

Hello! I am reading files using cffile and storing them in a application variable (because they are very often accessed). If the file is a cfm template I would like to "execute" it - is there a simple way to do that? The only solution I've seen so far would be to save the application variable

List of all running applications?

Hello! Is there a simple way to find out which applications are currently running and access their application variables structure? The server scope does not seem to provide such information. A solution/workaround I've been thinking about would be to add the following stuff to each Application

Called as module or include?

Hello! Is there a possibility to get to know if a template is called either via cfmodule or cfinclude? I can see the difference between standalone and cfinclude/cfmodule by executing a check with GetBaseTemplatePath but no difference between the cfmodule and cfinclude methods. Best regards, P

Re:_Recurring_Billing_Systems

Hello! Worldpay offers something that might fullfill your needs: http://www.worldpay.com/usa/products_services/billing.shtml Best regards, Peter Originale Nachricht Von: "Duane Boudreau" Betreff: Recurring Billing Systems Datum/Zeit: Dienstag, 17. Juni 2003 20:29:07 > Hi All, >

Abort long running requests

Hello! For a quite long period of time, coldfusion MX (+Updater three) has been using a lot of CPU resources on our server - the top command shows the following data: CPU: 50.4% running: 702:32 task name: cfusion The whole server is working properly (also coldfusion is serving pages as expect

Re:_Big_troubles_with_memory_usage/linux

something else I've found now in the apache error.log: [Sun Jun 1 17:10:04 2003] [notice] jrApache[34165] returning error page for 111 Connection refused [Sun Jun 1 17:10:04 2003] [notice] jrApache[26816] command error: 0 Success Betreff: Big_troubles_with_memory_usage/linux Datum/Zeit: Sonnt

Big_troubles_with_memory_usage/linux

Hello! We're running cfmx on linux and some strange problems are occuring from time to time: After minutes, sometimes after hours, coldfusion occupies too much memory and is restarted by the linux kernel: "May 31 12:28:06 www kernel: Out of Memory: Killed process 6814 (cfusion)." The problems

?ISO-8859-1?Q?Release_date_for_coldfusion_mx_II/changes/fixes??Release_date_for_coldfusion_mx_II/changes/fixes

Hello! Has there already been set a deadline when the new version of ColdFusion will be relased? Will there be any important changes (except the very important bug fixes for several bugs and configuration issues)? What JVM will be the default one? Best regards, Peter ~

Query of query and order by date

Hello! I am trying to order a dynamically created query (query of query) by a date column. That does not work. Now I've tried the following line in order to try to sort by a string: shows me that the values are set correctly but a SELECT * FROM query1 ORDER BY dt_new; still orders the

Re: sql2k vs mySQL vs postgresql (for win2k)

Hello! mysql has a very good performance but if you need certain features like views or subselect this database is out of the game. Postgresql fullfills almost all standard criterias for a "real" database engine but it is a little bit more complex. Running Postgresql on Windows isn't that funn

Bug? java.lang.StringIndexOutOfBoundsException: String index out of range: -3

Hello! I load a text/plain document via cfHTTP and the size is about one MegaByte. Now I have the following problem: ", chr(9), "ALL")> If the http content is smaller (f.e. only 300kb) this works well, but if the file is bigger I receive the following error message: "java.lang.StringIndexOu

OT: software documentation tutorials/templates/websites

Hello! Can anyone recommend good websites, turorials or templates for standarized software documentation? Currently, I am writing a kind of "documentation" just in the code (describe functions and variables) but for a new huge project a "real" documentation is needed. Best regards, Peter ~

RE: cfoutput + cfloop: bug or

> #query2.whatever# #q1whatever# > > > > I've had to do perform similar workarounds in the past for these goofy > situations. I am also of the school that says output and loop iteration > should be separate, i rarely use cfouput to iterate through

RE: cfoutput + cfloop: bug or

uch as the first loop having more or less loop iterations than the > second... what are you trying to do? what are your goals... > > N > > -Original Message- > From: Peter Mayer [mailto:[EMAIL PROTECTED]] > Sent: 11 February 2003 14:26 > To: CF-Talk > Subjec

cfoutput + cfloop: bug or

Hello! I have two queries - the output of the first one is handled by a cfoutput tag, the second one is handled by a cfloop (nested construction): bla bla #query1.name#: bla bla #query1.name#: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.

Re: CFFORM vs FORM

I suggest you to use simple form tags instead of CFFORM. CFFORM blackboxes a lot of things and does not always lead to the desired results. Furthermore, in very simple forms it's overkill because it adds javascript to each call. My prefered method is it to create forms with the standard form

Re: Function parameter question

Every cfargument item has a "required" (true/false) property ... it is important that this only works within coldfusion - if you call the function as a webservice, the parameter has to be supplied (is always required). Best regards, Peter Orginale Nachricht Von: Robert Everland <

Re: Recommended Apache version for W2K, CF5?

You can use Apache 2 - the modules for the current apache versions can be found here: http://home.nextron.ch/coldfusion/ Best regards, Peter Orginale Nachricht Von: "Stephen Hait" <[EMAIL PROTECTED]> Betreff: Recommended Apache version for W2K, CF5? Datum/Zeit: Freitag, 24. Jänner

Re: Create DSNless connection to mySQL

you can create DSNless connections in CFMX. You could in > CF5 but not in MX. If I'm wrong, someone please let me know. > > -Novak > > - Original Message - > From: "Peter Mayer" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]&

Create DSNless connection to mySQL

Hello! Can anyone show me a short example of how to create a DSNless connection to a mysql server (I only know the hostname, username and password but cannot create a datasource in the coldfusion mx administrator). Best regards, Peter

Logfile Analyzer

Hello! Does anyone know a good logfile analyzer for the coldfusion logfiles? The program should extract informations like "where do most errors occur", "which pages are taking too long to serve several times?" and so on. Best regards, Peter ~

Re: CFserver Timesout when uploading a 13mb file

As far as I know the file upload is handled by the web server, not the application server (coldfusion). The control is just handled over to the application server when the upload is finished. Therefore you have to set such a limit in your web server configuration (maximimum post size). In apac

CF and IMAP

Hello! Are there any native tags out there or has anybody tried f.e. JavaMail from Sun in order to access e-mails stored on an IMAP server? Someone has recommended http://advancedwebmail.com but the software seems to be quite unrealiable and also slow (regarding to the comments in the forum)

Fw: Coldfusion Monitoring Service + IIS

Hello! We have switched from the IIS to Apache and now we have the problem that every time we restart the Apache webserver, the coldfusion monitoring service automatically starts the IIS (despite of the fact that the services IIS admin, publishing service, ftp and smtp are set to disabled). As f

Re: Randomization of a cfquery

http://www.cflib.org/udf.cfm?ID=524 Returns a query object with a specified number of random records from the passed query. Some code based on QuerySlice() by Kevin Bridges ([EMAIL PROTECTED]) Best regards, Peter Orginale Nachricht Von: "David Jones" <[EMAIL PROTECTED]> Betreff

RE: Problem Tracking Systems

Hello! I can just recommend this one: http://www.bestpractical.com/rt/ license: GNU 2 It's not CF but CGI. Database is mysql. Best regards, Peter Orginale Nachricht Von: "Trey Rouse" <[EMAIL PROTECTED]> Betreff: RE: Problem Tracking Systems Datum/Zeit: Friday, 20. December 2002

RE: Sessions Not working?

Have you played around with the cfapplication settings (setdomaincookie)? Best regards, Peter Orginale Nachricht Von: Costas Piliotis <[EMAIL PROTECTED]> Betreff: RE: Sessions Not working? Datum/Zeit: Friday, 13. December 2002 23:09:35 > Anybody? > > -Original Message- >

WAP best practices

Hello! I am using CF to generate some WAP frontends. I now have some problems with a Nokia gatway of a mobile network provider - sessions do not seem to work properly (are lost when move from page A to B). Has anyone seen such a behaviour? Is it necessary to pass on CFID and CFTOKEN on every

Loosing form variables

Hello! I have some entries in my application.log file that form variables are missing ... (f.e. .Error resolving parameter FORM.TESTFIELDThe specified form field cannot be found. This problem is very likely due to the fact that you have misspelled the form field name.). Of course this error

Re: logging calls to CFM templates?

Hello! I would suggest the following solution: a) create a file called mod_log.cfm with some properties (f.e. attributes.pagename, attributes.parameter, ...) b) create a database with fields like "sitesection", "hitcount" ... c) write some sql statements for updating hitcount ... maybe you wan

RE: Space is removed - unwanted

hricht Von: "Robertson-Ravo, Neil (RX)" <[EMAIL PROTECTED]> Betreff: RE: Space is removed - unwanted Datum/Zeit: Monday, 02. December 2002 11:12:48 > not sure, but try using a   > > -Original Message- > From: Peter Mayer [mailto:[EMAIL PROTECTED]] > Sent: 02 December

Space is removed - unwanted

Hello! If I use the following statement I receive the following output: SirSmith SirMadame #q_select.surname# The space between the cfif statement and the output is removed. Is this a bug? Best regards, Peter ~| Archives:

Re: comparing with memofields in CF

Uwe, you might want to add a trim to both strings so that additional spaces are excluded. On the other hand I think "is" or "compare" are working correctly, so I suggest you to both strings in order to check out their content (maybe value_a is empty or such a thing). Best regards, Peter --

cfmail and html encoding

Hello! I am sending out an email with cfmail and the message type "html". I have encoded the "special" chars like ü, ö, ä, & and so on in the body part with the correspondending html elements (f.e. ö) but when the email gets out the recipient all changes are undone and in the email is written

Re: What is this???

Have you turned on http compression in the IIS settings? If I remember correctly there are many problems with the built-in-http-compression (including just some header as output). Peter > I have debugging turned off in the cf admin, but I keep getting this at the > top of a page from time to