RE: CFMX is crashing daily with no hints in the log
But still, Macromedia needs to give this issue attention. Microsoft SQL Server doesn't crash either when it does not have enough memory to do it's job (it is even possible to run with 4MB ram). In fact I am a bit astonished because since the first beta versions of ColdFusion, there were problems keeping it stable under load, and still these issues arise. These issues should never arise imo :-) Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 ALAmersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Releasing client to do another process?
nah... not the only way... mine and jim's both work. :) Open a new window, then bring your main window to the front, via _javascript_.If you want to allow the user to navigate away from your page, this would be the only way to do so and allow the long running process to continue. Shawn -Original Message- From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 13, 2004 4:50 PM To: CF-Talk Subject: RE: Releasing client to do another process? You could call another CF page in an image tag - it'll run, but the rest of your page should download fine (although the browser won't consider it done). Something like this: img src=""> height=1 width=1 Jim Davis From: Dave Phillips [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 13, 2004 2:10 PM To: CF-Talk Subject: Releasing client to do another process? Hi folks, Okay, here's my situation.I have a process that I want to run whenever a user registers for my system.The problem is, this process can take some time and I don't want to make the user wait for it to complete.Is there any way in CF that I can, in a sense, 'fire off a process' but release the client to continue on to the next page so they don't have to wait for it to finish? Any ideas are welcomed and appreciated.Thanks! s. isaac dealey954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.sys-con.com/story/?storyid=44477DE=1 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Releasing client to do another process?
This is actually very simple, 1: Create a page, and within create an iframe 100% high and wide. Call, parent.doSomething() from the iframe to call the _javascript_ function in the page where the iframe is. This does not complete the process if the user closes the window! Only if it browses to another place. 2: Create a scheduled task, and run this task immediately. When the task is finished remove it. This task is not dependant on the browser window clientside. If you need session vars etc. in your task, pass them to the task as parameters, or find a way to overcome this. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 ALAmersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Releasing client to do another process?
This is actually very simple, 1: Create a page, and within create an iframe 100% high and wide. Call, parent.doSomething() from the iframe to call the _javascript_ function in the page where the iframe is. This does not complete the process if the user closes the window! Only if it browses to another place. 2: Create a scheduled task, and run this task immediately. When the task is finished remove it. This task is not dependant on the browser window clientside. If you need session vars etc. in your task, pass them to the task as parameters, or find a way to overcome this. Micha Schopman Software Engineer [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CFCs - more smaller or fewer bigger ones?
I am laying out the CFCs I need for a new site, and wondered if there was a 'best practice' for the way to assign the methods to CFCs. For example when I think about users for the site,there are a number of methods I needrelated to logging in and logging out, maintaining user details, sending e-newsletters, listing users.Is there any advantage or disadvantage to having all those functions in one 'Users cfc or is it better to have smaller, more specialised CFCs.Perhaps in this example a UserMaintenance CFC and another UserLogin CFC? I understand about the re-use opportunities, so I think methods related to this site alone should be on their own, but in general terms, is it better to have fewer, larger CFCs or more but smaller and more specialised ones? Cheers Mike Kear AFP Webworks Windsor, NSW, Australia http://afpwebworks.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Webservice returning CFC in a different directory
* Have you tried downing your instance and blowing away the contents of both your cfclasses and cfc-skeletons directories. Yup - tried it many times, no luck... [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cf-based discussion board
sorry too waste your precious time mr perfecto,geezo i had dl'd stuff from both of those links less than 2 wks prior -- Original Message -- From: Rick Root [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date:Thu, 08 Jul 2004 07:39:19 -0400 dave wrote: http://www.cfboards.com Interesting family site, seems to have nothing to do with message boards in cold fusion. www.stickshitsolutions.com/openForums DNS error for me. Maybe you should visit links before posting them to the list. - Rick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Tuning DB connections?
Does anyone have good references on tuning DB connections between CF Server and MSSQL 2000? I run a couple of stored procedures and I am noticing that execution times of a specific stored procedure are at one time 0ms and at another time 16ms with exact the same recordset. I also ran the stored procedure in Query Analyzer in it says 0ms for each of the 150 itterations I've done. I want to bring all requests down to 0ms, so I am wondering where that 16ms delay is coming from? It must be between the connection of CF Server and MSSQL 2000. What is weird, is that it is always 16ms, not 1ms or 5ms, but it is either 0ms or 16ms (which is a quite big delay). I am using CF5 Ent. as testing environment. Anyone have good practices on this one? Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 ALAmersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Advice for CF Query and Schema
I am trying to design two databases that share a relationship that contains information for online training courses. So in the first table courseoutline they would use a html form to add the course information to the db such as ID = 1 Course Title =i.e. Windows 2000 Course Summary = Summary of Course in this field Owner = automatically populated through session name variables. Coursepath - contains word doc containing course contents uploaded via cffile In the second table iteccourse they would use a form to add the course dates and availability to the db such as CourseID = 1 Course Title = Selected from form select field populated using CFwith entries from the course title field in the courseoutline db. Coursedate = 17 July 2004 Duration = 3 Days Availability = Yes/ Full Owner = automatically populated through session name variables. Then in the detail page of the training site what coldfusion query would be needed so that if I just wanted to view upcoming Windows 2000 courses it would bring back the related coursepath for that course?? Any ideas on the best way to achieve this - or could my table schema be improved ?? I appreciate your views and help [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFMX is crashing daily with no hints in the log
Is the server in question an upgraded server from CF5? _ From: Micha Schopman [mailto:[EMAIL PROTECTED] Sent: 14 July 2004 07:23 To: CF-Talk Subject: RE: CFMX is crashing daily with no hints in the log But still, Macromedia needs to give this issue attention. Microsoft SQL Server doesn't crash either when it does not have enough memory to do it's job (it is even possible to run with 4MB ram). In fact I am a bit astonished because since the first beta versions of ColdFusion, there were problems keeping it stable under load, and still these issues arise. These issues should never arise imo :-) Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 ALAmersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Cfschedule tasks list
On Tue, 13 Jul 2004 14:35:32 -0700 (PDT), John Elder [EMAIL PROTECTED] wrote: Is there any way to display the list of scheduled tasks on a page without using the administrator? Does this help? http://www.anticlue.net/archives/000303.htm -- Kay Smoljak http://kay.smoljak.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Tuning DB connections?
Well you may not get them down to 0ms across the board!What is the name of the SP you are running?How are you running it in CF CFQUERY or CFSTOREDPROC? _ From: Micha Schopman [mailto:[EMAIL PROTECTED] Sent: 14 July 2004 10:07 To: CF-Talk Subject: Tuning DB connections? Does anyone have good references on tuning DB connections between CF Server and MSSQL 2000? I run a couple of stored procedures and I am noticing that execution times of a specific stored procedure are at one time 0ms and at another time 16ms with exact the same recordset. I also ran the stored procedure in Query Analyzer in it says 0ms for each of the 150 itterations I've done. I want to bring all requests down to 0ms, so I am wondering where that 16ms delay is coming from? It must be between the connection of CF Server and MSSQL 2000. What is weird, is that it is always 16ms, not 1ms or 5ms, but it is either 0ms or 16ms (which is a quite big delay). I am using CF5 Ent. as testing environment. Anyone have good practices on this one? Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 ALAmersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: StructKeyExists() vs IsDefined()
Sean Corfield wrote: isDefined() uses the standard CF scope lookup rules that have been around for a long, long time. Yes, but the one of the reasons used to in persuading people to scope their variables properly other than good practice was so that isDefined() only checked a specific variable in a specific scope, not every possible conotation of that variable and scope.This is something that was touted a long long time ago, before I remember your good self being around. Knowing that as CTO you will know better than me the inner workings of CF, are you saying that CFMX does not do this? and in general when you scope a variable, you know the variable exists in that scope. Thats just not true.There will always be situation where variables do not exist.Its simply not practicable or sensible to define every single variable that an application will ever use at any point in its entire lifetime, plus there are 3 scopes that you cannot and must not assume existance of your application's required variables.The easiest way to tell ifthe user has been this way before is to check to see if required, persistent variables are already in existance. In fact, come to think of it, there are only 2 scopes that you can safely assume exist in the first line of your code. These are SERVER and CGI.All other scopes and, therefore, those structures may not exist. This would means that scoping is not really taken into account by coldfusion, other by pure luck that functions like isDefined() look in the null scope first. Sure, scoping is taken into account - and there is no null scope. I think you misunderstand what I mean by null scope.The lookup rules must be looking at a variable _without a scope_ before it starts looking through the other scopes. This is what I mean by a null scope. Everything lives in a scope. Total aside - I did find in CF5 that a number of the scopes were actually available via the variables scope as well directly through their own scope. I did find this little fact useful on a couple of occasions, though it now escapes me why. The lookup rules are a convenience so that you (mostly) don't have to specify variables. everywhere. Grrr, but that is why I do specify scopes everywhere, unless I slip and get lazy (variables scope only), so that CF does what its told and doesn't decide to trundle off through all the scopes.Maybe I'm still stuck in CF3/4/5 land too much. If isDefined() is not taking scopes into account, does it keep going until its checked all scopes or does it stop searching when it hits the first occurance? First off, it *is* taking scopes into account - according to the variable lookup rules - See comment about null scopes to realise that, no, it is not taking scopes into account, only *appearing* to take scopes into account. If it was taking scopes into account, then it would check variables.myvariable and stop, not trundle through all the scopes looking for variables.variables.myvariable, form.variables.myvariable, etc and secondly, yes, it stops as soon as it finds a defined path to a variable. That's why I said the difference is only visible for *un*defined variables (or where a variable is defined in a scope other than the 'closest' scope). Thought it was - I was just being inflammatory... (I think thats the right word) Sorry... one of those days... cfif IsDefined(variables) AND StructKeyExists(variables.variables,test) That's wrong on two levels: 1. variables is *always* defined because it is a scope 2. if variables.variables doesn't exist you'll get an exception! ok - the whole using a variable called variables was just way too confusing, but I was trying to follow on with the examples that had previously been given and it all got a bit out of hand. No, that's the whole point - you *don't* need to use isDefined() because you *know* the built-in scopes exist. So are you saying that every scope all ready exists in CFMX as a structure, even if that scope is empty? Does this hold true for previous versions of CF?I'm still mostly on CF5. Don't fix what ain't broke, particularly if the client is happy. I understand what is happening here, but it means that variables.foo.bar doesn't exist either, that foo.bar can only be referenced by variables['foo.bar'] and CF is letting people create variables with invalid characters in their names. CF has always allowed variables with . in them. In fact that was one of the specific differences between CF5 and CFMX: CF5: cfset foo.bar = 42 Creates a variable called foo.bar CFMX: cfset foo.bar = 42 Creates a variable called foo as a struct with a key called bar Gah! I hate being on the fence between CF5 and CFMX.My brain does both versions at the same time.I write for CF5, but take into CFMX and vice versa. I can't remember what I can and can't do going back to CF5 sometime! In this case I was thinking specifically of CFMX for exactly the
RE: Tuning DB connections?
They are run with cfquery, cfstoredprocedure is much slower than the plain old cfquery. The queries executed are highly optimized and extremely fast but it is like the pipe between CF Server, and MSSQL 2000 isn't always optimal. The queries are not cached, and the execution plan for the query is not important in this scenario :-) Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 ALAmersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Tuning DB connections?
Hey, Well I have seen no proof myself that cfquery is faster than cfstoredprocedureWhat are you classing as highly optimised?For example its gonna be difficult to say that a SELECT list is highly optimised as the Query Plan engine decides what's gonna be the best plan (best guess) you can increase speed but to the degree I would say entitles them to be 'highly optijmised'.A fast query is usually down to the RDBMS schema and how good it is. Are you using EXEC to run the Prodedures?Are your Stored Procedures named in the following (incorrect way) : sp_X N From: Micha Schopman [mailto:[EMAIL PROTECTED] Sent: 14 July 2004 11:52 To: CF-Talk Subject: RE: Tuning DB connections? They are run with cfquery, cfstoredprocedure is much slower than the plain old cfquery. The queries executed are highly optimized and extremely fast but it is like the pipe between CF Server, and MSSQL 2000 isn't always optimal. The queries are not cached, and the execution plan for the query is not important in this scenario :-) Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Checking if cookies are disabled in the browser
I decided to go with the request scope if the cookies are disabled. cfif IsDefined(cookie.user) and cookie.user NEQ cfset fromEmail = cookie.user cfelseif IsDefined(request.user) and request.user NEQ cfset fromEmail = request.user /cfif Regards, cfcoder [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Checking if cookies are disabled in the browser
I decided to go with the request scope if the cookies are disabled. cfif IsDefined(cookie.user) and cookie.user NEQ cfset fromEmail = cookie.user cfelseif IsDefined(request.user) and request.user NEQ cfset fromEmail = request.user /cfif Regards, cfcoder [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Tuning DB connections?
The queries are optimized icw execution plans, etc. Every requests also turns out to take 0ms in Query Analyzer. The only slow part is after that, .. when the package is send to ColdFusion Server as the return value for the cfquery :-) Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 ALAmersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Tuning DB connections?
Note: QA cannot be used as a performance benchmark against ColdFusion. Yes of course a query will be slightly slower than running direct in QA but not by a huge amount - certainly nothing to worry about. Also, are you saying that the execution of the SP is taking 0ms in QA or just its component parts?If you have named your SP with a prefix of sp_ then this will also have a detrimental effect on performance. _ From: Micha Schopman [mailto:[EMAIL PROTECTED] Sent: 14 July 2004 12:34 To: CF-Talk Subject: RE: Tuning DB connections? The queries are optimized icw execution plans, etc. Every requests also turns out to take 0ms in Query Analyzer. The only slow part is after that, .. when the package is send to ColdFusion Server as the return value for the cfquery :-) Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 ALAmersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Advice for CF Query and Schema
Ian, You need to have a field (a foreign key) in your second table that corresponds to the info in your first table. So, your courseoutline table looks like so: ID (primary key) Title Summary Owner Coursepath Then, your iteccource looks like so: ID (primary key) courseoutlineID (foreign key to courseoutline) coursedate duration availability owner To join them, it'd be a simple query: SELECT o.title, o.summary, o.coursepath, i.coursedate, i.duration, i.availability FROM outlinecourse o, iteccourse i WHERE o.id = i.courseoutlineid ANDcoursedate sysdate (That last line is going to vary depending on your database platform, so consider that pseudocode. Also, if you're using something that supports the standard inner join syntax, you might want to use that instead of my version, which works in Oracle.) You don't need to repeat the title in the iteccourse table, as it's available in the courseoutline table. - Original Message - From: Ian Vaughan I am trying to design two databases that share a relationship that contains information for online training courses. So in the first table courseoutline they would use a html form to add the course information to the db such as ID = 1 Course Title =i.e. Windows 2000 Course Summary = Summary of Course in this field Owner = automatically populated through session name variables. Coursepath - contains word doc containing course contents uploaded via cffile In the second table iteccourse they would use a form to add the course dates and availability to the db such as CourseID = 1 Course Title = Selected from form select field populated using CFwith entries from the course title field in the courseoutline db. Coursedate = 17 July 2004 Duration = 3 Days Availability = Yes/ Full Owner = automatically populated through session name variables. Then in the detail page of the training site what coldfusion query would be needed so that if I just wanted to view upcoming Windows 2000 courses it would bring back the related coursepath for that course?? Any ideas on the best way to achieve this - or could my table schema be improved ?? I appreciate your views and help [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Tuning DB connections?
I am aware it cannot be used as a performance benchmark against ColdFusion, but it is a performance benchmark of the query and the way it is executed within SQL Server. The stored procedure call is : cfquery name=qrySubSubPages datasource=#Request.Application.DSN# EXEC dbo.upu_Instance_GetChildren @ParentID = #request.application.domainid#, @ObjectType = #request.object.object_page.type#, /cfquery This stored procedure is taking 0ms in QA (Also profiler states it has a low cpu hit). It is also taking 0ms in #cfquery.executiontime# ... when it likes to. So I am wondering, what is in the way which could cause such big big performance decrease on some occasions. If it was 0-5 ms, I would say.. well okay could be latency. But in 50% of the cases cfquery.executiontime returns 16ms, and I am wondering why. :-) Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 ALAmersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Tuning DB connections?
I am also sure that ColdFusion measures in 16ms intervals so it could be that your query is actually taking 0ms but CF is polling every 16msI don't think I have seen a request which wasn't in a x16 based value range. Don't worry about itits all good. _ From: Micha Schopman [mailto:[EMAIL PROTECTED] Sent: 14 July 2004 10:07 To: CF-Talk Subject: Tuning DB connections? Does anyone have good references on tuning DB connections between CF Server and MSSQL 2000? I run a couple of stored procedures and I am noticing that execution times of a specific stored procedure are at one time 0ms and at another time 16ms with exact the same recordset. I also ran the stored procedure in Query Analyzer in it says 0ms for each of the 150 itterations I've done. I want to bring all requests down to 0ms, so I am wondering where that 16ms delay is coming from? It must be between the connection of CF Server and MSSQL 2000. What is weird, is that it is always 16ms, not 1ms or 5ms, but it is either 0ms or 16ms (which is a quite big delay). I am using CF5 Ent. as testing environment. Anyone have good practices on this one? Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 ALAmersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Tuning DB connections?
It seems to me that there are too many unknowns in your question and 16ms is a very small amount of time to worry about... Is your DB connection from Cold Fusion using OLE DB, ODBC, JDBC etc, is CF on the same server as SQL Server, is Query Analyzer taking into account network response time or is SQL returning the time of execution directly? I'm certainly not sure... If you are running over a network, 16ms is trivial and could be caused by all manner of things including TCP/IP errors/retries, general network load, and a whole heap of other factors. I really don't think you are every going to reduce these sorts of times down when you look at the system as a whole. Comparing Query Analyzer directly against Cold Fusion is fatal. You would be better off writing an ASP or PHP version of the code and comparingthe results you would get from them as the way in which they work is analogous to the way CF works... Paul [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Tuning DB connections?
Try running it as a cfstoredproc and see what it returns...the 16ms lag is sure to be a false positive. cfstoredproc procedure=upu_Instance_GetChildren datasource=#Request.Application.DSN# cfprocparam dbvarname=@ParentID value=#request.application.domainid# type=In cfsqltype=CF_SQL_INTEGER null=No cfprocparam dbvarname=@ObjectType value=#request.object.object_page.type# type=In cfsqltype=CF_SQL_INTEGER null=No cfprocresult name=rsYourResultsSet resultset=1 /cfstoredproc From: Micha Schopman [mailto:[EMAIL PROTECTED] Sent: 14 July 2004 12:51 To: CF-Talk Subject: RE: Tuning DB connections? I am aware it cannot be used as a performance benchmark against ColdFusion, but it is a performance benchmark of the query and the way it is executed within SQL Server. The stored procedure call is : cfquery name=qrySubSubPages datasource=#Request.Application.DSN# EXEC dbo.upu_Instance_GetChildren @ParentID = #request.application.domainid#, @ObjectType = #request.object.object_page.type#, /cfquery This stored procedure is taking 0ms in QA (Also profiler states it has a low cpu hit). It is also taking 0ms in #cfquery.executiontime# ... when it likes to. So I am wondering, what is in the way which could cause such big big performance decrease on some occasions. If it was 0-5 ms, I would say.. well okay could be latency. But in 50% of the cases cfquery.executiontime returns 16ms, and I am wondering why. :-) Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Which code to indicate a space?
Tim, Couldn't you just use the LJustify() function to pad the string with spaces? Ie... #LJustify(PreviousEncounterReferenceNumber, 15)# will pad the string with spaces to a total length of 15. In your HTML output, if you need to display the spaces, then simply do this: #Replace(LJustify(PreviousEncounterReferenceNumber, 15), ,nbsp;,ALL)# - Rick Claremont, Timothy wrote: I am using CFMX to loop through a query, manipulate each field in the query, display the field in a table on screen, and then append each manipulated field to the end of a text file. The text file is then handed off to a COBOL(?) file processing system run by the good old State of New York. The output must be in a very specific format, such as this field must start at position 14 and consist of 15 characters, and be space filled etc. There are NO delimiters in the desired output file. My question is, when I fill a field so that it contains the appropriate number of spaces, what should I use for a blank space? It appears that does not do the trick. It also appears that chr(32) works fine for screen view, but the resultant text file contains literally a bunch of chr(32). Here is a sample of my code, in this example I am assigning ' ' as my BlankSpaceVariable: !--- Previous Encounter Reference Number, Position 14-28, Field Size 15 --- CFSET BlankSpaceVariable = ' ' CFSET BlankSpace = (15 - #Len(PreviousEncounterReferenceNumber)#) cfloop index=#Len(PreviousEncounterReferenceNumber)# from=1 to=#BlankSpace# CFSET #PreviousEncounterReferenceNumber# = '#BlankSpaceVariable#' '#CurrentVariable#' /CFLOOP !--- Display this part of the table on screen --- td font face=Fixedsys #PreviousEncounterReferenceNumber# /font /td !--- Append this variable to the end of the current text file --- cffile action=""> file=C:\Inetpub\wwwroot\MEDS\MEDSPharmOutput\#OutputFile# output=#PreviousEncounterReferenceNumber# addnewline=No Everything appears to be working as desired with the exception of the blank space assignments. What is the preferred character to indicate a space? TIA, Tim [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Tuning DB connections?
When you only have to execute one query on a page then latencies of 16ms are no problem, but this is the case where you have pages with for ex. 10 calls to stored procedure, checking childs, checking access, checking poll results, checking latest news, etc. The sum of all those latencies is at my point 110ms, while each query executes with 0ms in QA. This means ColdFusion Server is adding a latency of 110ms on each request, no mather how fast your server will be. The only thing I can do is putting the results in memory resident variables to speed up the process (either session, application or just a cachedwith timespan) and that is a pitty, especially while we use ColdFusion for Enterprise purposes and not for honkietonkie hobby stuff. :-) Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 ALAmersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Tuning DB connections?
I'll run a test, one moment plz.. :P Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 ALAmersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Tuning DB connections?
No change when using the cfstoredproc method. Still the same odd latency changes. With both the cfquery and the cfstoredproc method I saw a 15ms requesttime passing by. This would mean there is no 16ms hartbeat signal. Interesting. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 ALAmersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CFForm, CFInput, etc not xhtml compatible!
Hi all, I was just trying to make some of my pages xhtml 1.0 transitional compatible and when I tested through the W3C testing page I noticed that cfform and the others capitalize the tags and don't self close them. Anyone else notice this? I would hate to have to recode all of my pages when the directive comes down to be xhtml compatible (I know it's coming just don't know when). Steve [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Tuning DB connections?
Run a SQL profiler and see what happens in the SQL server regarding processing/execution time with the two methods. _ From: Micha Schopman [mailto:[EMAIL PROTECTED] Sent: 14 July 2004 13:22 To: CF-Talk Subject: RE: Tuning DB connections? No change when using the cfstoredproc method. Still the same odd latency changes. With both the cfquery and the cfstoredproc method I saw a 15ms requesttime passing by. This would mean there is no 16ms hartbeat signal. Interesting. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 ALAmersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Tuning DB connections?
SQL Server is picking her nose, .. both requests are handled with ease and both are returned with a 0ms execution time. Load is at a minimum. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 ALAmersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CFMX and MySQL Text field
Is there any special thing I need to do in order to read data from text data type column in MySQL table? I have used simple select statement, but it didn't work. It is not bringing the Text data where as other columns data is fine. Any help will be appreciated. Regards Asif [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFMX and MySQL Text field
Asif Rashid wrote: Is there any special thing I need to do in order to read data from text data type column in MySQL table? For what it's worth, I use MySQL a lot, and I've never had a problem retrieving data from columns of type textAnd I've done this in both Windows and Linux environments. - Rick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFMX and MySQL Text field
I don't know mysql, but if it is a long data type you have to check Enable long text retrieval in the advanced settings of the data source in the CF Administrator Pascal -Original Message- From: Asif Rashid [mailto:[EMAIL PROTECTED] Sent: 14 July 2004 14:39 To: CF-Talk Subject: CFMX and MySQL Text field Is there any special thing I need to do in order to read data from text data type column in MySQL table? I have used simple select statement, but it didn't work. It is not bringing the Text data where as other columns data is fine. Any help will be appreciated. Regards Asif [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Baffled by DirectoryExists
I am baffled why one will return true and the other false. In this first one, I am specifying the path. The second one, I am using the expand path. Why would one say no it does not exists when the second one will. The *.* should have no affect on a directory exists function. Please tell me it is something simple and I just have not seen it yet due to lack of caffeine. CFOUTPUT cfset thisDir = c:\inetpub\wwwrooot\ First Path: #thisDir#BR Directory Exists: #DirectoryExists(thisDir)#BR BR cfset thisPath = ExpandPath(*.*) Second Path: #thispath#BR cfset thisDirectory = GetDirectoryFromPath(thisPath) Directory Exists: #DirectoryExists(thisDirectory)# /CFOUTPUT [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: evaluate
It waas a direct cut-paste.Good catch Ian. form. contact If that was a direct cut and paste from your error message there is an errant space character in you variable name making its syntax incorrect. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Baffled by DirectoryExists
c:\inetpub\wwwrooot\? Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 ALAmersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Baffled by DirectoryExists
You have a typo rooot I think coffee is a requirement here Paul [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Baffled by DirectoryExists
yes that is a directory on my C Drive It produces the same results using either of the following: C:\inetpub\wwwroot OR C:\inetpub\wwwroot BTW:CF5.0 / Windows 2000 IIS _ From: Micha Schopman [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 14, 2004 9:10 AM To: CF-Talk Subject: RE: Baffled by DirectoryExists c:\inetpub\wwwrooot\? Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 ALAmersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Baffled by DirectoryExists
ARGG Told ya ... damn don't you hate that... Not enough Caffeine My apologies.. It is always the little things. _ From: Paul Vernon [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 14, 2004 9:12 AM To: CF-Talk Subject: RE: Baffled by DirectoryExists You have a typo rooot I think coffee is a requirement here Paul _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: evaluate
Now that you've said it's set to one if it exists, just do: cfloop list=plan_to_attend,contact,alumnimember index=i cfparam name=form.#i# default=0 / /cfloop -joe [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Advice for CF Query and Schema
Deanna Ok thanks, when adding a new course to the iteccourse database, how would I get the correct value to place into the courseoutlineID (foreign key to courseoutline) field Because when adding a new course to the iteccourse database, the user would have to select the course titlefrom a form select list otherwise the admin user would not know what course they are adding ??? From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: 14 July 2004 12:45 To: CF-Talk Subject: Re: Advice for CF Query and Schema Ian, You need to have a field (a foreign key) in your second table that corresponds to the info in your first table. So, your courseoutline table looks like so: ID (primary key) Title Summary Owner Coursepath Then, your iteccource looks like so: ID (primary key) courseoutlineID (foreign key to courseoutline) coursedate duration availability owner To join them, it'd be a simple query: SELECT o.title, o.summary, o.coursepath, i.coursedate, i.duration, i.availability FROM outlinecourse o, iteccourse i WHERE o.id = i.courseoutlineid ANDcoursedate sysdate (That last line is going to vary depending on your database platform, so consider that pseudocode. Also, if you're using something that supports the standard inner join syntax, you might want to use that instead of my version, which works in Oracle.) You don't need to repeat the title in the iteccourse table, as it's available in the courseoutline table. - Original Message - From: Ian Vaughan I am trying to design two databases that share a relationship that contains information for online training courses. So in the first table courseoutline they would use a html form to add the course information to the db such as ID = 1 Course Title =i.e. Windows 2000 Course Summary = Summary of Course in this field Owner = automatically populated through session name variables. Coursepath - contains word doc containing course contents uploaded via cffile In the second table iteccourse they would use a form to add the course dates and availability to the db such as CourseID = 1 Course Title = Selected from form select field populated using CF with entries from the course title field in the courseoutline db. Coursedate = 17 July 2004 Duration = 3 Days Availability = Yes/ Full Owner = automatically populated through session name variables. Then in the detail page of the training site what coldfusion query would be needed so that if I just wanted to view upcoming Windows 2000 courses it would bring back the related coursepath for that course?? Any ideas on the best way to achieve this - or could my table schema be improved ?? I appreciate your views and help [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Baffled by DirectoryExists
Do you get the same directory in the output?? ExpandPath will start from the file called in the request, NOT the file where the function is called. It is not necessarily the same file (or even in the same directory). Also, you can do ExpandPath(./) to get the directory directly. Pascal -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED] Sent: 14 July 2004 14:56 To: CF-Talk Subject: Baffled by DirectoryExists I am baffled why one will return true and the other false. In this first one, I am specifying the path. The second one, I am using the expand path. Why would one say no it does not exists when the second one will. The *.* should have no affect on a directory exists function. Please tell me it is something simple and I just have not seen it yet due to lack of caffeine. CFOUTPUT cfset thisDir = c:\inetpub\wwwrooot\ First Path: #thisDir#BR Directory Exists: #DirectoryExists(thisDir)#BR BR cfset thisPath = ExpandPath(*.*) Second Path: #thispath#BR cfset thisDirectory = GetDirectoryFromPath(thisPath) Directory Exists: #DirectoryExists(thisDirectory)# /CFOUTPUT [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: GRRRRR Session problems
Yes, there was a typo... but it was yours my friend cfset session['stcFormFields'] = StructNew() cfset form['one'] = 1 cfset form['two'] = 2 cfset StructAppend(session['atcFormFields'],form) cfdump var=#session['stcFormFields']# Does the above work for you? and no, my main problem was not bigger than I thought since I repeatedly said that there are other session dependent apps running on this same server. it HAD to be in the code somewhere. I do appreciate your help, but your starting to seem a little grumpy to me. Glad it's fixed. Ewok - Original Message - From: Michael T. Tangorre To: CF-Talk Sent: Tuesday, July 13, 2004 11:10 PM Subject: RE: GR Session problems First off, you have a typo. Look at the key name in the session structure; you have atcFormFields. My posted code has stcFormFields. Secondly, just run this to see if it works on your box: !--- BEGIN WORKING CODE --- cfset form['one'] = 1 cfset form['two'] = 2 cfset session['stcFormFields'] = StructNew() cfset StructAppend(session['stcFormFields'],form) cfdump var=#session['stcFormFields']# !--- END WORKING CODE --- The code works, I just ran it and copied it into this email. Thirdly, your main problem is a lot bigger than you think if the above code does not work (assuming you are on CFMX 6.1.. Which you already noted you were on). Hit me up in the AM and we can continue... Or perhaps someone is seeing something we are not. Mike Element atcFormFields is undefined in a Java object of type class coldfusion.runtime.MemorySessionScope referenced as 6 : cfset StructAppend(session['atcFormFields'],form) the code was ran exactly as you posted it. Im more worried about my main issue right now. I will work on gettin your code to work though, but not until i resolve the session issue thats holding me up on this app. Thanks for your help, im going to bed and will look at it fresh tommorrow [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Advice for CF Query and Schema
You'd pass the id instead of the title select name=courseid size=1 option value=1Some Course Title/option option value=2Some Other Course Title/option /select - Original Message - From: Ian Vaughan [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, July 14, 2004 8:20 AM Subject: RE: Advice for CF Query and Schema Deanna Ok thanks, when adding a new course to the iteccourse database, how would I get the correct value to place into the courseoutlineID (foreign key to courseoutline) field Because when adding a new course to the iteccourse database, the user would have to select the course titlefrom a form select list otherwise the admin user would not know what course they are adding ??? From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: 14 July 2004 12:45 To: CF-Talk Subject: Re: Advice for CF Query and Schema Ian, You need to have a field (a foreign key) in your second table that corresponds to the info in your first table. So, your courseoutline table looks like so: ID (primary key) Title Summary Owner Coursepath Then, your iteccource looks like so: ID (primary key) courseoutlineID (foreign key to courseoutline) coursedate duration availability owner To join them, it'd be a simple query: SELECT o.title, o.summary, o.coursepath, i.coursedate, i.duration, i.availability FROM outlinecourse o, iteccourse i WHERE o.id = i.courseoutlineid ANDcoursedate sysdate (That last line is going to vary depending on your database platform, so consider that pseudocode. Also, if you're using something that supports the standard inner join syntax, you might want to use that instead of my version, which works in Oracle.) You don't need to repeat the title in the iteccourse table, as it's available in the courseoutline table. - Original Message - From: Ian Vaughan I am trying to design two databases that share a relationship that contains information for online training courses. So in the first table courseoutline they would use a html form to add the course information to the db such as ID = 1 Course Title =i.e. Windows 2000 Course Summary = Summary of Course in this field Owner = automatically populated through session name variables. Coursepath - contains word doc containing course contents uploaded via cffile In the second table iteccourse they would use a form to add the course dates and availability to the db such as CourseID = 1 Course Title = Selected from form select field populated using CF with entries from the course title field in the courseoutline db. Coursedate = 17 July 2004 Duration = 3 Days Availability = Yes/ Full Owner = automatically populated through session name variables. Then in the detail page of the training site what coldfusion query would be needed so that if I just wanted to view upcoming Windows 2000 courses it would bring back the related coursepath for that course?? Any ideas on the best way to achieve this - or could my table schema be improved ?? I appreciate your views and help [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: GRRRRR Session problems
Yes, there was a typo... but it was yours my friend Yup, sure was. Sorry about that. I do appreciate your help, but your starting to seem a little grumpy to me. Glad it's fixed. I'm not grumpy at all; just trying to help. Later. -Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFForm, CFInput, etc not xhtml compatible!
I pesonally have never used the CFFORM tags, but the xHTML directive is one of the reason's I have built up a form CFC so that I can cut down a little on my form building and amke sure I don't forget any of the attributes for xHTML/accessible forms... You can find them here: http://gregs.tcias.co.uk/cold_fusion/two_cfcs_released.php I'd really appreciate any kind of feedback... Cheers G On Wed, 14 Jul 2004 08:28:57 -0400, DURETTE, STEVEN J (AIT) [EMAIL PROTECTED] wrote: Hi all, I was just trying to make some of my pages xhtml 1.0 transitional compatible and when I tested through the W3C testing page I noticed that cfform and the others capitalize the tags and don't self close them. Anyone else notice this? I would hate to have to recode all of my pages when the directive comes down to be xhtml compatible (I know it's coming just don't know when). Steve [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Anyone ever seen this error?
ERROR DESCRIPTION: Error Occurred at 7:29:47.047 AM originating from /pe/basket/purchase.cfm The Error Was: %3g null The error occurred on line 1. in We get errors that occur on the website via email. Every now and then we get this error, maybe once a day if that. It is completely (as far as I can see) random, happening in all different templates and different times . Any ideas? Its not always %3g null but it is usually some weird charters followed by null. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: GRRRRR Session problems
My apologies then... maybe I'M the one who needs a nap heh thanks again - Original Message - From: Tangorre, Michael To: CF-Talk Sent: Wednesday, July 14, 2004 9:51 AM Subject: RE: GR Session problems Yes, there was a typo... but it was yours my friend Yup, sure was. Sorry about that. I do appreciate your help, but your starting to seem a little grumpy to me. Glad it's fixed. I'm not grumpy at all; just trying to help. Later. -Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFForm, CFInput, etc not xhtml compatible!
I would hate to have to recode all of my pages when the directive comes down to be xhtml compatible Just curious, what's the big advantage of XHTML compatible? -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Replacing broken image with a CFM file
Hi All, This is more of an IIS question but does anyone know how to redirect a broken image file to a CFM template? TIA, Duane [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Replacing broken image with a CFM file
img src="" > Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 ALAmersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
extra space : or spacey
I have some display code that's inserting an extra space and I can't figure out the reason.Before every variable output, but after the delimeter there's a space #del# cfset outputVars = dateFormat(dateAdded,'short')|plan_to_attend|firstname|middlename|lastname|degree|year1|employer|workaddress !--- items cut --- cfset outputVars = listtoArray(outputVars,|) cfloop index=i from=1 to=#arrayLen(outputVars)# cfset theVar = #outputVars[i]# #evaluate(theVar)##del# /cfloop From this, I get: | 7/14/04| 1| supah| e| dupah| 1| superhero| girlieboy| 1966| 10472 outter_space ct| suite 204| scaggsville| md| 20723| 301-405-| [EMAIL PROTECTED]| If I just output year1 before the listtoarray: #del##year1##del#, then I get the proper |1991| without the extra space. Can someone please explain to me how these spaces are being added? It seems very odd to me. thanks. -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD20742-2611 301-405-2545 Phone www.phi.umd.edu [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: extra space : or spacey
Perform a Trim and CFSETTING around so the cfset doesn't grab any space. _ From: Daniel Kessler [mailto:[EMAIL PROTECTED] Sent: 14 July 2004 15:07 To: CF-Talk Subject: extra space : or spacey I have some display code that's inserting an extra space and I can't figure out the reason.Before every variable output, but after the delimeter there's a space #del# cfset outputVars = dateFormat(dateAdded,'short')|plan_to_attend|firstname|middlename|lastname| degree|year1|employer|workaddress !--- items cut --- cfset outputVars = listtoArray(outputVars,|) cfloop index=i from=1 to=#arrayLen(outputVars)# cfset theVar = #outputVars[i]# #evaluate(theVar)##del# /cfloop >From this, I get: | 7/14/04| 1| supah| e| dupah| 1| superhero| girlieboy| 1966| 10472 outter_space ct| suite 204| scaggsville| md| 20723| 301-405-| [EMAIL PROTECTED]| If I just output year1 before the listtoarray: #del##year1##del#, then I get the proper |1991| without the extra space. Can someone please explain to me how these spaces are being added? It seems very odd to me. thanks. -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD20742-2611 301-405-2545 Phone www.phi.umd.edu _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFCs - more smaller or fewer bigger ones?
It depends.But generally, small specialized CFCs will be easier to maintain and reuse than large generalized ones.In OO terms, this is called cohesion, and it's a Good Thing.It means an object has a specific and well-defined purpose and isn't trying to do a lot of unrelated things. HTH, Brian - Original Message - From: Michael Kear [EMAIL PROTECTED] Date: Wed, 14 Jul 2004 17:36:59 +1000 Subject: CFCs - more smaller or fewer bigger ones? To: CF-Talk [EMAIL PROTECTED] I am laying out the CFCs I need for a new site, and wondered if there was a 'best practice' for the way to assign the methods to CFCs. For example when I think about users for the site,there are a number of methods I needrelated to logging in and logging out, maintaining user details, sending e-newsletters, listing users.Is there any advantage or disadvantage to having all those functions in one 'Users cfc or is it better to have smaller, more specialised CFCs.Perhaps in this example a UserMaintenance CFC and another UserLogin CFC? I understand about the re-use opportunities, so I think methods related to this site alone should be on their own, but in general terms, is it better to have fewer, larger CFCs or more but smaller and more specialised ones? Cheers Mike Kear AFP Webworks Windsor, NSW, Australia http://afpwebworks.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFForm, CFInput, etc not xhtml compatible!
Just curious, what's the big advantage of XHTML compatible? That's a good question, I think. Right now, the advantage is minimal if not completely illusory. There aren't any devices out there which take advantage of XHTML specifically, to my knowledge. So, in current browsers, XHTML is functionally identical to HTML for most of us. However, in the future, I expect that XHTML will be very widely supported by all sorts of browsing devices. Because XHTML is an XML language, it can be parsed by any XML parser. XML parsers are a lot smaller (and stricter) than HTML parsers, which typically have all sorts of error handling for malformed HTML. So, XHTML documents can conceivably be used by many devices other than desktop browsers. In addition, it's a lot easier to ensure that your documents aren't malformed or invalid with any XML language, compared to HTML. So, rather than rewriting everything in XHTML later, it makes a lot of sense to use XHTML now, since it works with today's browsers. It's kind of tedious and painful to rewrite existing HTML as XHTML, but it's easy to write new XHTML. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Replacing broken image with a CFM file
I believe you'd have to have the CFM set up in IIS as the 404 handler or something like that. John -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 14, 2004 10:03 AM To: CF-Talk Subject: Replacing broken image with a CFM file Hi All, This is more of an IIS question but does anyone know how to redirect a broken image file to a CFM template? TIA, Duane [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFForm, CFInput, etc not xhtml compatible!
I was just trying to make some of my pages xhtml 1.0 transitional compatible and when I tested through the W3C testing page I noticed that cfform and the others capitalize the tags and don't self close them. Anyone else notice this? I would hate to have to recode all of my pages when the directive comes down to be xhtml compatible (I know it's coming just don't know when). Yes, this is a known issue with the current version of CFMX. However, based on what has been demonstrated about Blackstone at user groups, I strongly suspect this will be resolved (and then some) in the upcoming version of CF. Beyond that, though, I'd recommend that you use something like qForms, or build your own form validation mechanism, rather than using CFFORM. While it's very easy to use CFFORM, it's a bit harder to customize it to your liking. I strongly recommend you look at qForms. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFCs - more smaller or fewer bigger ones?
But this means you have to document your CFC's carefully. When you modify a CFC later on, you want to make sure you are not breaking other code in the system, so it is a good behavior to document dependencies of the CFC in a document, so you can easily see CFC 2 and CFC 3 are used by CFC 1. Or even better document it via UML :-) Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 ALAmersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFForm, CFInput, etc not xhtml compatible!
Just curious, what's the big advantage of XHTML compatible? You can perform XSLT on xhtml pages... which according to the XSLT cookbook (O'Reilly) for more details on how this is going to be very handy in the future Some examples off the top of my head - XSL template to change specific XHTML elements - Prefilling XHTML forms without server side intervention - Will make future programming tasks easier Can't do any of it myself yet, but trying though ;-) -- David Collie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFForm, CFInput, etc not xhtml compatible!
Just curious, what's the big advantage of XHTML compatible? You can perform XSLT on xhtml pages... which according to the XSLT cookbook (O'Reilly) for more details on how this is going to be very handy in the future Some examples off the top of my head - XSL template to change specific XHTML elements - Prefilling XHTML forms without server side intervention - Will make future programming tasks easier Of course, if you're using server-side processing, these things aren't especially useful, I suspect. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Tuning DB connections?
When you only have to execute one query on a page then latencies of 16ms are no problem, but this is the case where you have pages with for ex. 10 calls to stored procedure, checking childs, checking access, checking poll results, checking latest news, etc. The sum of all those latencies is at my point 110ms, while each query executes with 0ms in QA. This means ColdFusion Server is adding a latency of 110ms on each request, no mather how fast your server will be. The only thing I can do is putting the results in memory resident variables to speed up the process (either session, application or just a cachedwith timespan) and that is a pitty, especially while we use ColdFusion for Enterprise purposes and not for honkietonkie hobby stuff. You shouldn't be seeing that latency if you're running multiple queries within the same page that use the same database connection. Do you have the maintain database connection option enabled within the datasource settings? Are you using the most recent JDBC drivers from the MM site? As an alternative, you might also try MS's own JDBC driver too. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Tuning DB connections?
This stored procedure is taking 0ms in QA (Also profiler states it has a low cpu hit). It is also taking 0ms in #cfquery.executiontime# ... when it likes to. So I am wondering, what is in the way which could cause such big big performance decrease on some occasions. If it was 0-5 ms, I would say.. well okay could be latency. But in 50% of the cases cfquery.executiontime returns 16ms, and I am wondering why. :-) Unfortunately, CF isn't the most accurate timekeeper. At least with previous versions, there was a margin of error of +/-10 milliseconds. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Tuning DB connections?
Well I have seen no proof myself that cfquery is faster than cfstoredprocedure In some cases it is, in others it isn't. In many cases, CFQUERY with CFQUERYPARAM will be about the same as CFSTOREDPROC. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Tuning DB connections?
Does anyone have good references on tuning DB connections between CF Server and MSSQL 2000? I run a couple of stored procedures and I am noticing that execution times of a specific stored procedure are at one time 0ms and at another time 16ms with exact the same recordset. I also ran the stored procedure in Query Analyzer in it says 0ms for each of the 150 itterations I've done. I want to bring all requests down to 0ms, so I am wondering where that 16ms delay is coming from? It must be between the connection of CF Server and MSSQL 2000. What is weird, is that it is always 16ms, not 1ms or 5ms, but it is either 0ms or 16ms (which is a quite big delay). I am using CF5 Ent. as testing environment. Anyone have good practices on this one? Unfortunately, my earlier response to this was based on the assumption you were using CFMX. I apologize. With CF 5, there isn't all that much you can do to tune the database connection from within CF itself. Make sure that you maintain database connections. I would recommend that you test your queries by running them through another ODBC client from the web server's console. I suspect you'll see the same delay no matter what ODBC client you use. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFMX is crashing daily with no hints in the log
But still, Macromedia needs to give this issue attention. Microsoft SQL Server doesn't crash either when it does not have enough memory to do it's job (it is even possible to run with 4MB ram). In fact I am a bit astonished because since the first beta versions of ColdFusion, there were problems keeping it stable under load, and still these issues arise. These issues should never arise imo :-) Unfortunately, application servers are always more likely to crash than database servers. In my experience, database servers tend to be very stable and robust. Application servers don't. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: StructKeyExists() vs IsDefined()
Yes, but the one of the reasons used to in persuading people to scope their variables properly other than good practice was so that isDefined() only checked a specific variable in a specific scope Not sure who was saying that (as you say it was before my time) but scoping variables is worthwhile in general to control lookup. My recommendation is simply: - don't use isDefined() - always scope your variables Knowing that as CTO you will know better than me the inner workings of CF, are you saying that CFMX does not do this? I'm not CTO (I'm not actually sure who is - it was Jer when he was still around and he was my boss). Anyways, CFMX is backward compatible with this behavior - so the recommendations still apply. Thats just not true.There will always be situation where variables do not exist. But if you know which scope they might / should be in you can always use structKeyExists() and avoid this issue... Grrr, but that is why I do specify scopes everywhere, unless I slip and get lazy (variables scope only), so that CF does what its told and doesn't decide to trundle off through all the scopes.Maybe I'm still stuck in CF3/4/5 land too much. No, that's still good practice for CFMX. Thought it was - I was just being inflammatory... (I think thats the right word) Sorry... one of those days... Not a problem - it's certainly surprising behavior no matter that it can be explained using existing language rules :( So are you saying that every scope all ready exists in CFMX as a structure, even if that scope is empty? Yes. Does this hold true for previous versions of CF?I'm still mostly on CF5. Don't fix what ain't broke, particularly if the client is happy. No, that's one of the big differences: CF5 treated scope names as sort of magic reserved words whereas CFMX treats them as real variables of type struct. I think that CF5 might return false for isDefined() on some of the scope names (haven't tried it... isDefined(server) anyone?). Gah! I hate being on the fence between CF5 and CFMX.My brain does both versions at the same time.I write for CF5, but take into CFMX and vice versa. I can't remember what I can and can't do going back to CF5 sometime! I agree. I started with CFMX but I've had to go back and learn CF5 as well (if only so I can understand the pain expressed on the mailing lists!). What you're saying here is that not only does isDefined() not take into account scopes (as argued above), it also has an added layer where having checked for the structure foo and the key bar in all the scopes and not found it, it now looks for the variablefoo.bar in all the scopes too? Whilst I will disagree with the first part of that, the second part is correct - isDefined() will go looking for foo.bar because - in CF5 - it could have been a valid variable name. Sorry to bang on about this, but isDefined() appears not to be working the way I have, perhaps mistakenly, understood in the past from the various book writing luminaries of the mailing lists. I think this is just a corner case that most people tried to ignore ;) Also as a mainly CF5 developer I have to be sure that isDefined() is doing the right thing and that structKeyExists is _only_ a CFMX short cut. It's true that you can't use structKeyExists() everywhere in CF5 (since not all scopes behaved like structs). The right thing in CF5 is debatable however since CF5 specifically allowed dots in variable names which is why isDefined() has such funky behavior! :) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: extra space : or spacey
Dan, I suspect that if you view source you'll see that it isn't a space but a linefeed generated by ColdFusion.You may want to try this approach: cfset thisRow = / cfloop index=i from=1 to=#arrayLen(outputVars)# cfset theVar = #outputVars[i]# cfset thisRow = thisRow evaluate(theVar) del / /cfloop #thisRow# -joe [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SQL Server 2000 developer edition?
No mention of any sort of concurrent user limit, and no mention of thread limits.Does anyone know if these restrictions are lifted and the published performance limits are all there are? A 4gb database limit is no big deal to me, and the single-processor limit isn't an issue as I can't afford a dual-processor license unless I win the lottery. And it has some sort of lightweight management tool?How cool is that?! Kinda looks like a mySQL killer, on Windows boxes, at least.Reminds me of how MS murdered the desktop db market, way back when.It worked splendidly then and I bet it'll do the same again. -- --Matt Robertson-- MSB Designs, Inc. mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFCs - more smaller or fewer bigger ones?
Agreed, UML is excellent for this purpose.The day an IDE (maybe He3?) can take my CFCs and automagically generate a UML diagram, or take UML and generate CFC stubs, I'll be a very happy camper! - Original Message - From: Micha Schopman [EMAIL PROTECTED] Date: Wed, 14 Jul 2004 16:19:24 +0200 Subject: RE: CFCs - more smaller or fewer bigger ones? To: CF-Talk [EMAIL PROTECTED] But this means you have to document your CFC's carefully. When you modify a CFC later on, you want to make sure you are not breaking other code in the system, so it is a good behavior to document dependencies of the CFC in a document, so you can easily see CFC 2 and CFC 3 are used by CFC 1. Or even better document it via UML :-) Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 ALAmersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Tuning DB connections?
I know, ColdFusion never was accurate with timings, not even the beta's, but... in this case timings are returned with a similar pattern in delays which makes me think hey something is holding it. I have also tried some other options ( I know I must be glad with that occasionally 16ms delay ... but still it must be possible to get it better ..:P ), and switch the datasource from a ODBC connection to a OLEDB connection. The OLEDB connection seems to act slower than the ODBC. I have the latest drivers, and the latest mdac. For people just tuning in, the server used is CF5 Ent. Management is to shitty to step to CFMX6.1 so I will try the same app on a CFMX6.1 box later to see the differences. I expect the CFMX6.1 box to be slower in DB access because of the java translation layers NOTE: One reason also, why most people do not like to use cfstoredproc is the lack of caching options. The only reason why I would use cfstoredproc, is to handle multiple returned datasets. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 ALAmersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFForm, CFInput, etc not xhtml compatible!
Dave, Ok, I have to say that I agree with not using the cfform, cfinput, etc.but I have a lot of legacy code.Some I wrote when I was just starting with cf and a lot of it that I inherited.We also have some programmers in our group who still aren't _javascript_ proficient yet. I personally write all of my own js for validation now. rant My issue is that a couple of hours of work on Macromedias part to fix the tags (the released a hot fix for the form tags a while ago and could have done it then) could save hundreds to thousands of hours of work for their customers who may need to make the switch but not be able to get Blackstone. One of my pet peeves is when people say oh just wait a little while and it will be fixed in the next version in this case Blackstone.There is no guarantee that I will get budget approval for Blackstone and I'm sure that other Macromedia customers are in the same boat.Or the other issue that can happen (and it did to me with mx and mx 6.1) is that the IT decision makers probably won't make Blackstone a company standard for a while and we can't install it on our production servers until they do, so fixes in a new version can't help the problem now. /rant Sorry for the rant, but I had to get it out. Steve -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 14, 2004 10:27 AM To: CF-Talk Subject: RE: CFForm, CFInput, etc not xhtml compatible! I was just trying to make some of my pages xhtml 1.0 transitional compatible and when I tested through the W3C testing page I noticed that cfform and the others capitalize the tags and don't self close them. Anyone else notice this? I would hate to have to recode all of my pages when the directive comes down to be xhtml compatible (I know it's coming just don't know when). Yes, this is a known issue with the current version of CFMX. However, based on what has been demonstrated about Blackstone at user groups, I strongly suspect this will be resolved (and then some) in the upcoming version of CF. Beyond that, though, I'd recommend that you use something like qForms, or build your own form validation mechanism, rather than using CFFORM. While it's very easy to use CFFORM, it's a bit harder to customize it to your liking. I strongly recommend you look at qForms. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Tuning DB connections?
I expect the CFMX6.1 box to be slower in DB access because of the java translation layers You may be pleasantly surprised, then. There don't appear to be a whole lot of additional translation layers; you don't use ODBC or OLEDB at all with the pure Java JDBC drivers from MM/DataDirect or MS. NOTE: One reason also, why most people do not like to use cfstoredproc is the lack of caching options. The only reason why I would use cfstoredproc, is to handle multiple returned datasets. If you're using MS SQL Server, you can call stored procedures from within CFQUERY and still use CACHEDWITHIN/CACHEDAFTER. Conversely, if you were using passthrough SQL and CFQUERYPARAM within a CFQUERY, you can't cache that either. In general, I'd recommend that you use Session, Application or Server variables to cache recordsets, instead of using CACHEDWITHIN/CACHEDAFTER. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFMX and MySQL Text field
Pascal Peters wrote: if it is a long data type you have to check Enable long text retrieval in the advanced settings of the data source in the CF Administrator Not quite.If you leave those unchecked (I do) then CF will retrieve only up to what the long text buffer setting is. The default is 64k which typically is plenty for a web page.However a mySQL text type field can handle significantly more than this, so bear this in mind. http://dev.mysql.com/doc/mysql/en/Storage_requirements.html -- --Matt Robertson-- MSB Designs, Inc. mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFForm, CFInput, etc not xhtml compatible!
Ok, I have to say that I agree with not using the cfform, cfinput, etc. but I have a lot of legacy code. Some I wrote when I was just starting with cf and a lot of it that I inherited. I suspect that this code isn't XHTML-compliant anyway, though, right? I know the legacy code I've left laying around hasn't always been XHTML-compliant. rant My issue is that a couple of hours of work on Macromedias part to fix the tags (the released a hot fix for the form tags a while ago and could have done it then) could save hundreds to thousands of hours of work for their customers who may need to make the switch but not be able to get Blackstone. One of my pet peeves is when people say oh just wait a little while and it will be fixed in the next version in this case Blackstone.There is no guarantee that I will get budget approval for Blackstone and I'm sure that other Macromedia customers are in the same boat.Or the other issue that can happen (and it did to me with mx and mx 6.1) is that the IT decision makers probably won't make Blackstone a company standard for a while and we can't install it on our production servers until they do, so fixes in a new version can't help the problem now. /rant Perhaps, as a paying Macromedia customer, you should complain to them directly. I sympathize with you, but I can't solve the problem, beyond noting that there is an encrypted file named form.cfm in my \WEB-INF\cftags directory. However, realistically, how soon will XHTML be important to you? I don't know if it'll be important in a general sense during the lifespan of the Blackstone release. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFForm, CFInput, etc not xhtml compatible!
So, I looked at your code and I have some questions/comments (nifty concept, though) 1. Why do use spans instead of just classing the elements? 2. You're using the label tag improperly, if you want to use it to associate the label with the element. Either the form element has to be nested in the label tag: label title=Enter Your Name Here Your Name: input type=text name=name value= /label ORyou have to use the for attribute combined with the id attribute: label title=Enter Your Name Here id=nameYour Name:/label input type=text name=name value= id=name - Original Message - From: Greg Stewart Subject: Re: CFForm, CFInput, etc not xhtml compatible! I pesonally have never used the CFFORM tags, but the xHTML directive is one of the reason's I have built up a form CFC so that I can cut down a little on my form building and amke sure I don't forget any of the attributes for xHTML/accessible forms... You can find them here: http://gregs.tcias.co.uk/cold_fusion/two_cfcs_released.php I'd really appreciate any kind of feedback... [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Tuning DB connections?
I run a couple of stored procedures and I am noticing that execution times of a specific stored procedure are at one time 0ms and at another time 16ms with exact the same recordset. Have you tried any sort of load testing? I mean at 16ms you can run about 60 queries and you are only loosing a second...I think your bigger concern should be if 500 people are using the system is that 16ms spiking or staying consistent. Adam H [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: extra space : or spacey
Perform a Trim and CFSETTING around so the cfset doesn't grab any space. I put the Trim around the cfset but it still showed the space. It's suggested that it's a line feed.I've not used cfsetting before.I put it just before the cfoutput query.I'd think that cfsetting would get rid of that too. _ From: Daniel Kessler [mailto:[EMAIL PROTECTED] Sent: 14 July 2004 15:07 To: CF-Talk Subject: extra space : or spacey I have some display code that's inserting an extra space and I can't figure out the reason.Before every variable output, but after the delimeter there's a space #del# cfset outputVars = dateFormat(dateAdded,'short')|plan_to_attend|firstname|middlename|lastname| degree|year1|employer|workaddress !--- items cut --- cfset outputVars = listtoArray(outputVars,|) cfloop index=i from=1 to=#arrayLen(outputVars)# cfset theVar = #outputVars[i]# #evaluate(theVar)##del# /cfloop From this, I get: | 7/14/04| 1| supah| e| dupah| 1| superhero| girlieboy| 1966| 10472 outter_space ct| suite 204| scaggsville| md| 20723| 301-405-| [EMAIL PROTECTED]| If I just output year1 before the listtoarray: #del##year1##del#, then I get the proper |1991| without the extra space. Can someone please explain to me how these spaces are being added? It seems very odd to me. thanks. -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD20742-2611 301-405-2545 Phone www.phi.umd.edu _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: extra space : or spacey
Dan, I suspect that if you view source you'll see that it isn't a space but a linefeed generated by ColdFusion. It appears as a space in the source, but I didn't output it's ascii value so I'm not sure.There's no line-break but I'm not sure how a line-feed displays. You may want to try this approach: cfset thisRow = thisRow evaluate(theVar) del / #thisRow# This worked.I guess it's cause it's all put together before it's output.Yay! Though I still don't understand why there's a line-feed in there and I'd like to understand better. thanks joe and everyone else. daniel [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Releasing client to do another process?
Actually your first option would, indeed, complete the process - it just couldn't return information to the browser when done. A CF Process keeps going until it ends or times out - only then does it return back to the web server which in turn tries to return to the browser. If the browser isn't waiting any longer then you get an error in your logs, but the process did complete. Jim Davis From: Micha Schopman [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 14, 2004 3:27 AM To: CF-Talk Subject: RE: Releasing client to do another process? This is actually very simple, 1: Create a page, and within create an iframe 100% high and wide. Call, parent.doSomething() from the iframe to call the _javascript_ function in the page where the iframe is. This does not complete the process if the user closes the window! Only if it browses to another place. 2: Create a scheduled task, and run this task immediately. When the task is finished remove it. This task is not dependant on the browser window clientside. If you need session vars etc. in your task, pass them to the task as parameters, or find a way to overcome this. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: StructKeyExists() vs IsDefined()
Sean Corfield wrote: Yes, but the one of the reasons used to in persuading people to scope their variables properly other than good practice was so that isDefined() only checked a specific variable in a specific scope Not sure who was saying that (as you say it was before my time) but scoping variables is worthwhile in general to control lookup. My recommendation is simply: - don't use isDefined() - always scope your variables Sorry to bang on about this, but isDefined() appears not to be working the way I have, perhaps mistakenly, understood in the past from the various book writing luminaries of the mailing lists. I think this is just a corner case that most people tried to ignore ;) Knowing that as CTO you will know better than me the inner workings of CF, are you saying that CFMX does not do this? I'm not CTO (I'm not actually sure who is - it was Jer when he was still around and he was my boss). Opps... No idea where I got that from, probably cos Jer was your boss and senile dementia is setting in early According to the MM site the CTO is apparent a chap by the name of Jonathon Gay. So are you saying that every scope all ready exists in CFMX as a structure, even if that scope is empty? Yes. Interesting to know. I'll store that one away Does this hold true for previous versions of CF?I'm still mostly on CF5. Don't fix what ain't broke, particularly if the client is happy. No, that's one of the big differences: CF5 treated scope names as sort of magic reserved words whereas CFMX treats them as real variables of type struct. I think that CF5 might return false for isDefined() on some of the scope names (haven't tried it... isDefined(server) anyone?). You certainly can't cfdump some of the scopes. What you're saying here is that not only does isDefined() not take into account scopes (as argued above), it also has an added layer where having checked for the structure foo and the key bar in all the scopes and not found it, it now looks for the variablefoo.bar in all the scopes too? Whilst I will disagree with the first part of that, the second part is correct - isDefined() will go looking for foo.bar because - in CF5 - it could have been a valid variable name. ... in the name of backward compatibility. Also as a mainly CF5 developer I have to be sure that isDefined() is doing the right thing and that structKeyExists is _only_ a CFMX short cut. It's true that you can't use structKeyExists() everywhere in CF5 (since not all scopes behaved like structs). The right thing in CF5 is debatable however since CF5 specifically allowed dots in variable names which is why isDefined() has such funky behavior! :) What nutter let that one through?! Particular when we had structs in CF4.x :-) Its a shame that isDefined() doesn't say : you've given me a variable with a known scope - I'll look for that variable in that scope only or you've given me a variable with no scope or no known scope, so I'll scan all the scopes for it. Really this is only an issue for me on CF5 and not even much of an issue at that. In CFMX, now that I know that the scope structs are always there, I can just use structKeyExists(). Mind you, why shouldn't isDefined() work like this on CFMX? It might make it useful again hmmm now where did I put that url for the feature request form???;) Thanks for your time and putting up with me Regards Stephen Moretti [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFMX and MySQL Text field
Thanks for reply, now I am getting this error message, ByteArray Objects cannot be converted to strings. And this is happening when I am moving that column value into one local variable, i.e., cfset temp = qryPart.Desc Asif - Original Message - From: Matt Robertson [EMAIL PROTECTED] Date: Wed, 14 Jul 2004 07:52:15 -0700 Subject: Re: CFMX and MySQL Text field To: CF-Talk [EMAIL PROTECTED] Pascal Peters wrote: if it is a long data type you have to check Enable long text retrieval in the advanced settings of the data source in the CF Administrator Not quite.If you leave those unchecked (I do) then CF will retrieve only up to what the long text buffer setting is. The default is 64k which typically is plenty for a web page.However a mySQL text type field can handle significantly more than this, so bear this in mind. http://dev.mysql.com/doc/mysql/en/Storage_requirements.html -- --Matt Robertson-- MSB Designs, Inc. mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: extra space : or spacey
No problem. -joe - Original Message - From: daniel kessler [EMAIL PROTECTED] Date: Wed, 14 Jul 2004 11:35:11 -0400 Subject: Re: extra space : or spacey To: CF-Talk [EMAIL PROTECTED] Dan, I suspect that if you view source you'll see that it isn't a space but a linefeed generated by ColdFusion. It appears as a space in the source, but I didn't output it's ascii value so I'm not sure.There's no line-break but I'm not sure how a line-feed displays. You may want to try this approach: cfset thisRow = thisRow evaluate(theVar) del / #thisRow# This worked.I guess it's cause it's all put together before it's output.Yay! Though I still don't understand why there's a line-feed in there and I'd like to understand better. thanks joe and everyone else. daniel [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFForm, CFInput, etc not xhtml compatible!
I think the simplest, quickest and dirtiest solution would be to write a tag which you wrap round all calls to CFFORM, then use the tag to parse thistag.generatedcontent, lowercasing this, and end tagging that - should be fairly simple to write... Global search and replace cfform with cf_yourTagcfform And /cfform with /cfform/cf_yourTag So, now you have a quick frix if you need to be xmtml in a hurry (i.e. if/when the directive comes down), and if you have time you can look into qForms, or hang around waiting for Blackstone. Cheers Bert From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: 14 July 2004 15:27 To: CF-Talk Subject: RE: CFForm, CFInput, etc not xhtml compatible! I was just trying to make some of my pages xhtml 1.0 transitional compatible and when I tested through the W3C testing page I noticed that cfform and the others capitalize the tags and don't self close them. Anyone else notice this? I would hate to have to recode all of my pages when the directive comes down to be xhtml compatible (I know it's coming just don't know when). Yes, this is a known issue with the current version of CFMX. However, based on what has been demonstrated about Blackstone at user groups, I strongly suspect this will be resolved (and then some) in the upcoming version of CF. Beyond that, though, I'd recommend that you use something like qForms, or build your own form validation mechanism, rather than using CFFORM. While it's very easy to use CFFORM, it's a bit harder to customize it to your liking. I strongly recommend you look at qForms. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
SOT - DWMX error
Anyone seen past this error? While executing receiveArguments in File_Save.htm, the following _javascript_ errors occured: At line 45 of C:\Program Files\Macromedia\Dreamweaver MX\Configuration\Menus\MM\File_Save.js exception throw in native function all the google stuffs give me nada http://www.google.com/search?hl=enlr=ie=UTF-8q=%22while+executing+receivearguments%22btnG=Search have DWMX 2004 with the updater installed.No extensions installe.Tried reinstall, nada.Only get this error when working in 'local view' and i 'get' the site.Try to save edits and whammo! Cheers! -- Douglas Knudsen Alltel ACI Rapid Response Team To fear love is to fear life, and those who fear life are already three parts dead. Bertrand Russell ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
QofQ and javacast
Hello all, I am seeing a problem when I am running a QofQ union with two cfsearch results. It looks like CF is typing based on the first row of data in the cfsearch query. I need to make CF type a column of the CFsearch query as a varchar rather then a number. I have heard that a javacast may be able to help me out. Can anyone show me how that would be done? cfsearch collection=get_Products name=getSearchResults1 type=explicit criteria=CF_KEY SUBSTRING #trim(form.criteria)# cfsearch collection=get_Products name=getSearchResults2 type=simple criteria=#trim(form.criteria)# cfquery name=getSearchResults dbtype=query Select CUSTOM1,CUSTOM2,RECORDSSEARCHED,SUMMARY,TITLE,URL from getSearchResults1 union Select CUSTOM1,CUSTOM2,RECORDSSEARCHED,SUMMARY,TITLE,URL from getSearchResults2 /cfquery Thanks Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com http://www.vividmedia.com/ 608.270.9770 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFMX and MySQL Text field
Use the built-in toString() function around the column: cfset temp = toString(qryPart.Desc) / This can also happen when you're using MySQL to format something (i.e. a date or number) into a string in the database.ByteArrays can generally be converted to strings, it's just the conversion won't happen automatically, so you have to do it explicitly. Cheers, barneyb -Original Message- From: Asif Rashid [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 14, 2004 8:47 AM To: CF-Talk Subject: Re: CFMX and MySQL Text field Thanks for reply, now I am getting this error message, ByteArray Objects cannot be converted to strings. And this is happening when I am moving that column value into one local variable, i.e., cfset temp = qryPart.Desc Asif [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
attribute value...
I've got a piece of code... 195 :cfloop query=market 196 :option value=#market.c_marketid# cfif tmp1 IS market.market selected/cfif#market.market#/option 197 : /cfloop this is generating the CF error.. The value of the attribute query, which is currently market, is invalid. the query SELECT market, c_marketid, isactive, actionuser, actiondate FROM C_MARKET ORDER BY market returns ALBANY 2100702367/13/20041:41:15 PM LITTLEROCK1100702367/13/20041:41:00 PM I'm not entirely understanding this error, can someone explain? Greg Morphis Rapid Response Team Client Server Dev/Analyst I ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: attribute value...
whats the name of your query Lets see the complete cfquery tag - Original Message - From: [EMAIL PROTECTED] To: CF-Talk Sent: Wednesday, July 14, 2004 9:44 AM Subject: attribute value... I've got a piece of code... 195 :cfloop query=market 196 :option value=#market.c_marketid# cfif tmp1 IS market.market selected/cfif#market.market#/option 197 : /cfloop this is generating the CF error.. The value of the attribute query, which is currently market, is invalid. the query SELECT market, c_marketid, isactive, actionuser, actiondate FROM C_MARKET ORDER BY market returns ALBANY 2100702367/13/20041:41:15 PM LITTLEROCK1100702367/13/20041:41:00 PM I'm not entirely understanding this error, can someone explain? Greg Morphis Rapid Response Team Client Server Dev/Analyst I ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: attribute value...
What is the name of your query? Is it market? e.g. cfquery name=market datasource=#dsn# select marketStuff ... -mike [EMAIL PROTECTED] 07/14/2004 12:44 PM Please respond to cf-talk To:CF-Talk [EMAIL PROTECTED] cc: Subject:attribute value... I've got a piece of code... 195 :cfloop query=market 196 :option value=#market.c_marketid# cfif tmp1 IS market.market selected/cfif#market.market#/option 197 : /cfloop this is generating the CF error.. The value of the attribute query, which is currently market, is invalid. the query SELECT market, c_marketid, isactive, actionuser, actiondate FROM C_MARKET ORDER BY market returns ALBANY 2100702367/13/2004 1:41:15 PM LITTLEROCK1100702367/13/20041:41:00 PM I'm not entirely understanding this error, can someone explain? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: attribute value...
never mind, I renamed my query to markets and changed that throughout the code and it worked.. name collision was my issue? -Original Message- From: JT [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 14, 2004 11:51 AM To: CF-Talk Subject: Re: attribute value... whats the name of your query Lets see the complete cfquery tag - Original Message - From: [EMAIL PROTECTED] To: CF-Talk Sent: Wednesday, July 14, 2004 9:44 AM Subject: attribute value... I've got a piece of code... 195 :cfloop query=market 196 :option value=#market.c_marketid# cfif tmp1 IS market.market selected/cfif#market.market#/option 197 : /cfloop this is generating the CF error.. The value of the attribute query, which is currently market, is invalid. the query SELECT market, c_marketid, isactive, actionuser, actiondate FROM C_MARKET ORDER BY market returns ALBANY 2100702367/13/20041:41:15 PM LITTLEROCK1100702367/13/20041:41:00 PM I'm not entirely understanding this error, can someone explain? Greg Morphis Rapid Response Team Client Server Dev/Analyst I ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: StructKeyExists() vs IsDefined()
Interesting discussion. So whats the best thing to do when the same code has to run on both platforms?Sounds like I'm stuck with isdefined. -- --Matt Robertson-- MSB Designs, Inc. mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: attribute value...
yes it was -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 14, 2004 11:51 AM To: CF-Talk Subject: Re: attribute value... What is the name of your query? Is it market? e.g. cfquery name=market datasource=#dsn# select marketStuff ... -mike [EMAIL PROTECTED] 07/14/2004 12:44 PM Please respond to cf-talk To:CF-Talk [EMAIL PROTECTED] cc: Subject:attribute value... I've got a piece of code... 195 :cfloop query=market 196 :option value=#market.c_marketid# cfif tmp1 IS market.market selected/cfif#market.market#/option 197 : /cfloop this is generating the CF error.. The value of the attribute query, which is currently market, is invalid. the query SELECT market, c_marketid, isactive, actionuser, actiondate FROM C_MARKET ORDER BY market returns ALBANY 2100702367/13/2004 1:41:15 PM LITTLEROCK1100702367/13/20041:41:00 PM I'm not entirely understanding this error, can someone explain? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: attribute value...
You're looping over that query so try removing market.market and just use market. 195 :cfloop query=market 196 :option value=#market.c_marketid# cfif tmp1 IS market.market selected/cfif#market.market#/option 197 :/cfloop [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: attribute value...
You're looping over that query so try removing market.market and just use market. 195 :cfloop query=market 196 :option value=#market.c_marketid# cfif tmp1 IS market.market selected/cfif#market.market#/option 197 :/cfloop [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: attribute value...
Sorry, that was a lazy way to answer. Here's what I meant. cfloop query=market option value=#c_marketid# cfif tmp1 IS market selected/cfif#market#/option /cfloop [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: attribute value...
Sorry, that was a lazy way to answer. Here's what I meant. cfloop query=market option value=#c_marketid# cfif tmp1 IS market selected/cfif#market#/option /cfloop [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: attribute value...
did you change the table deffor rmarket at some point?CFMX has some strange table def caching that could throw this sort of error. Doug -Original Message- From: Ken Ferguson [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 14, 2004 12:53 PM To: CF-Talk Subject: RE: attribute value... You're looping over that query so try removing market.market and just use market. 195 :cfloop query=market 196 :option value=#market.c_marketid# cfif tmp1 IS market.market selected/cfif#market.market#/option 197 :/cfloop _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
double posts???
Sorry for the double ups! I have no idea what happened there. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: attribute value...
No.. the table existed since yesterday, I changed the name of the query from market to markets and did this throughout the code from market.c_marketid to markets.c_marketid and market.market to markets.market. This corrected the problem, so I'm happy. Thanks -Original Message- From: Knudsen, Douglas Sent: Wednesday, July 14, 2004 12:02 PM To: CF-Talk Subject: RE: attribute value... did you change the table deffor rmarket at some point?CFMX has some strange table def caching that could throw this sort of error. Doug -Original Message- From: Ken Ferguson [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 14, 2004 12:53 PM To: CF-Talk Subject: RE: attribute value... You're looping over that query so try removing market.market and just use market. 195 :cfloop query=market 196 :option value=#market.c_marketid# cfif tmp1 IS market.market selected/cfif#market.market#/option 197 :/cfloop _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]