RE: Dynamic Form Selects and Posting Troubles
Hi Mark, Sorry for replying late. I just got a chance to go over the CF-Talk posts. I don't know whether I understand your problem right or not. But probably using Arrays (or Structs) might solve your problem? I would do something like this when calling CFC: cfset userValue = ArrayNew(2) cfset count = 0 cfloop query=qUsers cfset userValue[count][1] = A#moduleID# !--- I don't know you still want to pad A in front --- cfset userValue[count][2] = FORM[moduleID] cfinvokeargument name=#userValue[count][1]# value=#userValue[count][2]# /cfloop It would look like A155 = 3 (moduleID) = (permissionID) cfset count = count + 1 --- I think you get my drift. And I would do the appropriate in CFC as well. Please let me know if that helps at all. Thanks Regards, Pine -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 15, 2006 2:24 PM To: CF-Talk Subject: Dynamic Form Selects and Posting Troubles Hi all, I've been pulling out my hair on this one over the last two days and I'm stumped. On a form page I have a series of drop down select boxes, dynamically produced and named. The name of each select (moduleID) is a three-digit number. So I could have FORM.133, FORM.147, FORM.155 and so on. The permission ID value is numeric 1 thru 5. I pull the recordset from a db and create the fieldnames and drop downs, like so (which works): cfloop query=qUsers cfset FORM[moduleID] = qUsers.permissionID /cfloop It would look like FORM.155 = 3 (moduleID) = (permissionID) table border=0 cellspacing=0 cellpadding=3 cfloop query=qUsers tr tdstrong#moduleName#/strong/td td select name=#moduleID# option value=1 cfif FORM[moduleID] EQ 1selected/cfif (1) No Access/option cfif qUsers.moduleID NEQ 133 option value=2 cfif FORM[moduleID] EQ 2selected/cfif (2) View Only/option option value=3 cfif FORM[moduleID] EQ 3selected/cfif (3) View-Edit/option option value=4 cfif FORM[moduleID] EQ 4selected/cfif (4) View-Add-Edit/option /cfif option value=5 cfif FORM[moduleID] EQ 5selected/cfif (5) Complete Access/option /select /td /tr /cfloop /table Next I want to send the form fields to a cfc for db posting. So in my cfinvoke I loop through the FORM vars, like so: (Notice that I'm forced to prepend an A in front of the cfinvokeargument name - the cfc throws an error if arguments have names beginning with numbers) cfloop query=qUsers cfinvokeargument name=A#moduleID# value=#FORM[moduleID]# /cfloop It would look like A155 = 3 (moduleID) = (permissionID) Here's the real problem, trying to update an existing table with this data. In the CFC, the qPermissionCount gives me a count of how many rows have unique module numbers (in this case 3). cfquery name=qPermissionCount datasource=#REQUEST.dsnSQL# username=#REQUEST.dsnUID# password=#REQUEST.dsnPWD# SELECT U.userID, P.* FROM #SESSION.companyInfo.companyTablePrefix#_Users_List U, #SESSION.companyInfo.companyTablePrefix#_Users_List_UserModulesPermissio ns P WHERE U.userID = cfqueryparam cfsqltype=cf_sql_char value=#ARGUMENTS.userID# AND U.userID = P.userID /cfquery Now, I can't seem to figure out how to loop for 3 records, and match up the FORM.A155 with the db record of 155 in order to update the permission level (1 thru 5). It's the SET that's the problem. Notice that the ARGUMENTS.a101 could be any number from A101 to A160. I can find which three numbers are being updated from the qPermissionCount recordset. cfquery name=updOBJ2 datasource=#REQUEST.dsnSQL# username=#REQUEST.dsnUID# password=#REQUEST.dsnPWD# UPDATE #SESSION.companyInfo.companyTablePrefix#_Users_List_UserModulesPermissio ns SET permissionID = cfqueryparam cfsqltype=cf_sql_integer value=#ARGUMENTS.A101# WHERE userID = cfqueryparam cfsqltype=cf_sql_char value=#ARGUMENTS.userID# AND moduleID = cfqueryparam cfsqltype=cf_sql_integer value=#qPermissionCount.moduleID# /cfif /cfquery Thanks, Mark ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235650 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Createquery and numbers that are strings
May be I am over-simplifying your problem but adding empty string () might solve?? Just curious what data type is SSN being returned from the query (number ,integer , string)? Pine -Original Message- From: Robert Everland III [mailto:[EMAIL PROTECTED] Sent: Friday, March 10, 2006 10:01 AM To: CF-Talk Subject: Createquery and numbers that are strings I am creating a huge structure so that I can get data from many different tables that I can't join (don't ask long story). The key of my structure is a SSN, now I need to order the records to be in alphabetical on the name, i can't use the name as the key since some people could potentially have the same name. So I came up with a way to loop through the key and get the name and put them into a query I create (you still with me). Now I do a dump of that query and it loses any 0's in front and treats it as a number. Even when I use javacast. The only way I have found to get by this is to put a letter in front of the SSN. Anyone have another solution to this? Bob ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235076 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Createquery and numbers that are strings
The obvious work around will be assign a new variable and put the empty string + SSN. In that way, you don't need to take out the empty space from your structure. But depending on how you are going to use it, maintaining two variables instead of one might drive your mad. So, the other option that I can think of right now is find out which table or query give you back the SSN as number and when you get the value use the NumberFormat(SSN, 0) and padded the zeros.. Regards, Pine -Original Message- From: Robert Everland III [mailto:[EMAIL PROTECTED] Sent: Friday, March 10, 2006 10:40 AM To: CF-Talk Subject: Re: Createquery and numbers that are strings I could try putting an empty string in front, but even if that works I would still have to take out the empty space later because I still need the ssn for the primary key of the structure. The SSN is returned as a string. Bob ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235084 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Updating Application.cfc without the restart
Hi all, Is there a way to update the application.cfc (onApplicationStart function in particular) without restarting the CF server or services? Thanks in advance. Pine ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235098 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Updating Application.cfc without the restart
Thanks a lot, Nick. I tested it and it works really great.. Pine -Original Message- From: Nick Han [mailto:[EMAIL PROTECTED] Sent: Friday, March 10, 2006 4:00 PM To: CF-Talk Subject: RE: Updating Application.cfc without the restart cfset this.applicationTimeout = createTimeSpan(1,0,0,0) cfif isDefined(url.restartApp) cfset this.applicationTimeout=createTimeSpan(0,0,0,0) /cfif -Original Message- From: PINE Phyo Z [mailto:[EMAIL PROTECTED] Sent: Friday, March 10, 2006 3:58 PM To: CF-Talk Subject: Updating Application.cfc without the restart Hi all, Is there a way to update the application.cfc (onApplicationStart function in particular) without restarting the CF server or services? Thanks in advance. Pine ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235101 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cfajax vs ajaxCFC Question.
I haven't tried CFAJAX, so I don't know the answer to your question. But may be you might want to have a look at : JSMX (http://www.lalabird.com/) (or is it too late for you to consider another API) ?? I found it much easier to set up and use than ajaxCFC. May be it is just my preference. Regards, Pine -Original Message- From: Nick Han [mailto:[EMAIL PROTECTED] Sent: Thursday, March 09, 2006 10:56 AM To: CF-Talk Subject: cfajax vs ajaxCFC Question. I have used both of these APIs in my test environment. I think they both work well. There are pros and cons in choosing one over the other, and most of these issues I encountered were minor. For instance, ajaxCFC is easier to set up, but the thing I don't like about it is the passed parameters are transformed and received as array arguments by the CFCs. As for CFAJAX it is more work to set up, I like the fact that arguments are received by functions the way there have been passed by the calling page. So you keep variable naming in tact for self-documenting and easy debugging. Also with CFAJAX you can't use it within CFC framework. So there's a mixed bag of good and bad between the two. I am about to pick one of these APIs and use it in my production environment and I want to hear your opinions from those of you who have used it extensively. I would like to hear your advice on what to watch out for under each and which one would you recommend if you have worked with both. Thanks. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234894 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: PDF Upload Problems
I remembered reading something like it in Ben Forta's book (CFMX7 Web Application Construction Kit) and I went back and searched. This is what I found: ...illustrates one of Internet Explorer 6's policies. Unlike most other browsers, it thinks the file extension-and the format of the actual content itself-is more important than the specified content type. The content type considered only if the file extension doesn't have an associated program, or when there is no file extension. To get consistent behavior with IE, add a content-disposition header to the page request, using a cfheader tag, such as the following. The cfheader tag is the way ColdFusion enables you to send custom HTTP headers back to the browser, along with the content your template generates. You would add this line right before the cfcontent line in Listing 33.3: cfheader name=Content-Disposition value=filename=films So, I guess you can use Content-Disposition tag somewhere? I am not exactly sure though..Just a thought. Regards, Pine -Original Message- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Monday, March 06, 2006 1:13 PM To: CF-Talk Subject: Re: PDF Upload Problems I don't personally have a pdf generator, but I can reproduce it with an excel file, for example. It only happens with IE, though - Firefox correctly figures out the mime type. But, if you open an excel file with Microsoft Excel, and then try to upload it via your web page and IE, you'll discover that it thinks it's an application/octet-stream. On 3/6/06, Mike Chabot [EMAIL PROTECTED] wrote: Deanna, Thank you for the information. Is there a way to reproduce this problem, since I cannot seem to do so? I did some further testing and it appears that CFMX, for the most part, is determining the MIME-type from the file extension, since I am able to add .pdf to any file type to get it past the application/pdf mime type restriction. Thank you, Mike Chabot On 3/6/06, Deanna Schneider [EMAIL PROTECTED] wrote: Application/octet-stream is what you'll get if the pdf is open on their system when they try to upload it. I don't know of a really great work around, other than catching that particular error and telling them to be sure to close it before uploading it. On 3/6/06, Mike Chabot [EMAIL PROTECTED] wrote: We have a file upload form that only accepts PDF files. A very small percentage of people have tried to upload files that end in .pdf, but CFMX 6.1 rejects them because they have MIME types of application/octet-stream or application/unknown. Since these files could not be uploaded, I am not sure if these files are legitimate PDFs, so I would like to know if anyone else has experience with this, or if there is some advice I can give to the people experiencing these problems? At what stage of the upload process does the MIME-type get associated with the file? Thank you, Mike Chabot ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234491 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OOP, why me?
Hi Gareth, As long as you are the only one developer who codes and maintain the application till its sunset and the code reuser is only you (you are using your own code so you know where to find one), then you do not need the OOP. As long as your code is modular (not OOP) and you don't forget what you have coded or done, you are pretty well on your way without OOP. Otherwise, OOP will benefit you. Thanks Regards, Pine -Original Message- From: Gareth [mailto:[EMAIL PROTECTED] Sent: Monday, March 06, 2006 8:40 AM To: CF-Talk Subject: OOP, why me? I'm the sort of person who likes to understand why I'm doing something rather than just do it. If I download a UDF I analyse it and try to learn rather than just stick it into my app and smile because it's worked. With that in mind, I wonder if someone could explain to me in super simple, beginer speak, layman terms what Object Oriented Programming means in terms of CF and why I should use it? My very basic understanding is that you have different 'layers' to perform different tasks, so when someone visits mygroovyform.cfm the processing behind the form is not done on the form page itself but passed to another page which then passes back the results. The back end processing is then done using components (cfc's). I know that's a very simplified explanation but hopefully it's true in principle. I've written a few very simple CFC's more for the sake of it than because I understood the need. The main arguments I've heard for using this approach is that it's good for code re-use and promotes clean coding. But what I can't get my head around is why? I mean, code isn't necessarily unclean because it's not built using this approach and can't code just as easily be reused using a cfmodule or even a cfinclude? I've also heard it's good in a multi-developer environment, but I'm only me so perhaps there isn't a practical reason for me to learn it at all? I've read a lot on the subject and I'd like to read more but it's difficult to enthuse myself without understanding what the real end benefit is. scratches_headModel glue, mach ii, fusebox, etc. I'm sure there's a bloody good reason for 'em but what is it?/scratches_head Words of wisdom / good reading (including book recommendations) most appreciated. Many thanks Gareth ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234512 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OOP, why me?
[quote = Mike] CFCs are simply magic. Whoever thought of them deserves a nobel prize. [/quote] Well, Mike that depends on who you are talking to. (Personally, I like CFCs and I think they are really great.) But when CF start coming out, it boasts as (and it is true) simple yet powerful server side language. With a line or two in CF can accomplish the same thing with more lines of codes in other programming language (like Java for example). Anyway, that was the reason I started learning CF in CF 4 days. But with CFCs and OO introduced into CF, CF is starting to sound like Java (more like J2EE actually). And people who shams from OO languages because of their complexity choose ColdFusion in the first place, but not they face the somewhat similar complexities that is introduced into CF. That confuses a lot of old-timers of CF. In a way, there will always be push and pull with OO paradigm. Who wins and who lose, only time will tell I guess. Meanwhile, I think we mere mortal developers have to choose what is the best for our own situation. Thanks Regards, Pine -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED] Sent: Monday, March 06, 2006 4:25 PM To: CF-Talk Subject: Re: OOP, why me? Now you have a reason, Rick. CFCs are simply magic. Whoever thought of them deserves a nobel prize. CFMX is a whole 'nother world of excitement and thrills.Well ok . ..maybe it's not exactly Disney World but it's a lot better than the older versions. I had to do a job on CF5 not so long ago and there were SO many things I missed that have become second nature to me now. Cheers Mike Kear Windsor, NSW, Australia Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On 3/7/06, Rick Faircloth [EMAIL PROTECTED] wrote: Guess I'll have to wait...still using 4.5.2...I still haven't found a compelling reason to upgrade. Rick ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234517 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CF Round Behavior
Hi all, I have a question on Round() function behavior of CF. When I do #Round(35.5)#, it will give me 36 but when I do #Round(-35.5)#, it will give me -35. But when I give #Round(-35.6)#, it will give me -36. So I am just wondering is it a bug or is that suppose to be that way? Thanks Regards, Pine ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232225 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cftry and cfcatch
I'm guessing here but I think your two queries are using stored procedures. So, use cfstoredproc to check the return values. Then, your first issue will be resolved. Then use nested cftry and cfcatch for each stored proc to resolve the second issue. So probably something like this: cftry !--- Set the variable for your second issue here. --- cfset notRunQuery = 0 cfset problemQueryNumber = 0 cftry cfstoredproc name=checksrv datasource=master returnCode=YES result=storedProc1Return SELECT @@SERVICENAME; /cfstoredproc cfcatch type = database cfset notRunQuery = notRunQuery + 1 cfset problemQueryNumber = 1 cfthrow type = yourOwnError /cfcatch /cftry cftry cfstoredproc name=checkage datasource=master returnCode=YES result=storedProc2Return SELECT count (program_name) FROM master.dbo.sysprocesses WITH (NOLOCK) WHERE program_name LIKE '%Agent%' /cfstoredproc cfcatch type = database cfset notRunQuery = notRunQuery + 1 cfset problemQueryNumber = 2 !--- Throw your own error for the outermost cfcatch to catch --- cfthrow type = yourOwnError /cfcatch /cftry cfcatch type =yourOwnError cfif notRunQuery is 2 !--- Send MSSQLSERVER Not Avail and Agent Not Avail in cfmail. --- cfelseif notRunQuery is 1 cfif problemQueryNumber = 1 !--- Send MSSQLSERVER Not Avail in cfmail. --- cfelseif problemQueryNumber = 2 !--- Send Agent Not Avail in cfmail. --- /cfif /cfif /cfcatch /cftry !--- Check the errors(return values) with from two stored procedures. Do CFMail here by checking two return structs (storedProc1Return and storedProc2Return) --- HTH, Pine -Original Message- From: John Lucania [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 07, 2006 6:00 PM To: CF-Talk Subject: cftry and cfcatch I have two queries: cfquery name=checksrv datasource=master SELECT @@SERVICENAME; /cfquery cfquery name=checkage datasource=master SELECT count (program_name) FROM master.dbo.sysprocesses WITH (NOLOCK) WHERE program_name LIKE '%Agent%' /cfquery I want to be notified through cfmail if 1) query checksrv doesn't return MSSQLSERVER then, MSSQLSERVER not returned in cfmail or query checkage doesn't return 2 then, Agent not returned 2 in cfmail or both of checksrv and checkage don't return then, MSSQLSERVER not returned and Agent not returned 2 in cfmail or 2) query checksrv cannot be run then, MSSQLSERVER Not Avail in cfmail or query checkage cannot be run then, Agent Not Avail in cfmail or both of checksrv and checkage cannot be run then, MSSQLSERVER Not Avail and Agent Not Avail in cfmail. Any ideas? tia, jl ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231649 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cftry and cfcatch
I was in a hurry when I typed the previous response and found a glitch in the logic. In the inner cfcatch blocks, I am throwing the errors. So, whenever there is a problem, the yourOwnError exception will be thrown. That means you will never see Send MSSQLSERVER Not Avail and Agent Not Avail in cfmail. To resolve that, at the top of my head, just remove the cfthrow tags in the cfcatch blocks. Handle it outside the cftry and cfcatch. I don't think you would even need to nest the cftry anymore. So, the revised version will be like this: !--- Set the variable for your second issue here. --- cfset notRunQuery = 0 cfset problemQueryNumber = 0 cftry cfstoredproc name=checksrv datasource=master returnCode=YES result=storedProc1Return SELECT @@SERVICENAME; /cfstoredproc cfcatch type = database cfset notRunQuery = notRunQuery + 1 cfset problemQueryNumber = 1 /cfcatch /cftry cftry cfstoredproc name=checkage datasource=master returnCode=YES result=storedProc2Return SELECT count (program_name) FROM master.dbo.sysprocesses WITH (NOLOCK) WHERE program_name LIKE '%Agent%' /cfstoredproc cfcatch type = database cfset notRunQuery = notRunQuery + 1 cfset problemQueryNumber = 2 /cfcatch /cftry cfif notRunQuery is 2 !--- Send MSSQLSERVER Not Avail and Agent Not Avail in cfmail. --- cfelseif notRunQuery is 1 cfif problemQueryNumber = 1 !--- Send MSSQLSERVER Not Avail in cfmail. --- cfelseif problemQueryNumber = 2 !--- Send Agent Not Avail in cfmail. --- /cfif /cfif !--- Check the errors(return values) with from two stored procedures. Do CFMail here by checking two return structs (storedProc1Return and storedProc2Return) --- -Original Message- From: PINE Phyo Z Sent: Wednesday, February 08, 2006 8:53 AM To: 'cf-talk@houseoffusion.com' Subject: RE: cftry and cfcatch I'm guessing here but I think your two queries are using stored procedures. So, use cfstoredproc to check the return values. Then, your first issue will be resolved. Then use nested cftry and cfcatch for each stored proc to resolve the second issue. So probably something like this: cftry !--- Set the variable for your second issue here. --- cfset notRunQuery = 0 cfset problemQueryNumber = 0 cftry cfstoredproc name=checksrv datasource=master returnCode=YES result=storedProc1Return SELECT @@SERVICENAME; /cfstoredproc cfcatch type = database cfset notRunQuery = notRunQuery + 1 cfset problemQueryNumber = 1 cfthrow type = yourOwnError /cfcatch /cftry cftry cfstoredproc name=checkage datasource=master returnCode=YES result=storedProc2Return SELECT count (program_name) FROM master.dbo.sysprocesses WITH (NOLOCK) WHERE program_name LIKE '%Agent%' /cfstoredproc cfcatch type = database cfset notRunQuery = notRunQuery + 1 cfset problemQueryNumber = 2 !--- Throw your own error for the outermost cfcatch to catch --- cfthrow type = yourOwnError /cfcatch /cftry cfcatch type =yourOwnError cfif notRunQuery is 2 !--- Send MSSQLSERVER Not Avail and Agent Not Avail in cfmail. --- cfelseif notRunQuery is 1 cfif problemQueryNumber = 1 !--- Send MSSQLSERVER Not Avail in cfmail. --- cfelseif problemQueryNumber = 2 !--- Send Agent Not Avail in cfmail. --- /cfif /cfif /cfcatch /cftry !--- Check the errors(return values) with from two stored procedures. Do CFMail here by checking two return structs (storedProc1Return and storedProc2Return) --- HTH, Pine -Original Message- From: John Lucania [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 07, 2006 6:00 PM To: CF-Talk Subject: cftry and cfcatch I have two queries: cfquery name=checksrv datasource=master SELECT @@SERVICENAME; /cfquery cfquery name=checkage datasource=master SELECT count (program_name) FROM master.dbo.sysprocesses WITH (NOLOCK) WHERE program_name LIKE '%Agent%' /cfquery I want to be notified through cfmail if 1) query checksrv doesn't return MSSQLSERVER then, MSSQLSERVER not returned in cfmail or query checkage doesn't return 2 then, Agent not returned 2 in cfmail or both of checksrv
RE: input box selection
Yep. And I tested it and it seems like your div Layer4 is giving the problem. If you comment out the following portion in your code, it all seems well. You might want to re-code that part. div id=Layer4 style=position:absolute; left:350px; top:200px; width:300px; height:330px; z-index:8 a href=aboutus.cfmfont color=ffbAbout us/b/font/a nbsp;nbsp;a href=newsHome.cfmfont color=ffbNews/b/font/a nbsp;nbsp;a href=calendarHome.cfmfont color=ffbCalendar/b/font/a nbsp;nbsp;a href=DirectoryHome.cfmfont color=ffbDirectory/b/font/a /div HTH, Pine -Original Message- From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 07, 2006 2:21 PM To: CF-Talk Subject: RE: input box selection Nothing jumps right out at me... try validating and cleaning up your html and CSS first. ...:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Jason Herbolsheimer [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 07, 2006 5:09 PM To: CF-Talk Subject: FW: input box selection OK. I promise this one is the right one. http://oil.cfwebtools.com/newshome.cfm?news_id=51action=emailstory -Original Message- From: Jason Herbolsheimer [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 07, 2006 4:07 PM To: CF-Talk Subject: FW: input box selection Sorry that isn't the correct url. Please try this one instead. http://oil.cfwebtools.com/newshome.cfm?news_id=51action=showstory -Original Message- From: Jason Herbolsheimer [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 07, 2006 4:05 PM To: cf-talk@houseoffusion.com Subject: input box selection I'm currently developing a site that has a very simple form(2 email addresses, Name and comments). The problem I'm having is that I'm unable to click on any of the text boxes to place the cursor inside of it, unless you hover exactly over the top portion of the text box (your arrow will go to a cursor). Below is a url to the page I'm having this issue on. If someone out there has encountered this problem before and found has a solution I would greatly appreciate your help, or if someone knows what might be wrong I would also appreciate your help as well. http://oil.cfwebtools.com/newsHome.cfm?news_id=51 Thanks in advance, Jason Herbolsheimer ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231618 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Log analyzer software.
Ok, may be I'm jumping the gun but Port is such a notorious port. I wouldn't want to give that to my customers if I were you. Here is some info on port : http://www.auditmypc.com/port/tcp-port-.asp And if you google with the word port , there might be more info. Thanks Regards, Pine -Original Message- From: Jennifer Gavin-Wear [mailto:[EMAIL PROTECTED] Sent: Monday, February 06, 2006 2:07 PM To: CF-Talk Subject: RE: Log analyzer software. Hi Che, I've just installed Smarterstats on IE 6. Took 10 mins to install, and it appears the trial version will run one site for free. It runs off port so you can give customer you host www.theirdomaim.com: and a login to see their stats. Maintenance, from what I can see, is zero. The stats are good and very adaptable. I've used Weblog Expert, which I'd say is better for Apache, and I looked at AWstats which is a pain to set up (loads of command line, just what you don't want). Jenny -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: 06 February 2006 18:34 To: CF-Talk Subject: OT: Log analyzer software. I'm sure this has been re-hashed before. I did a search at HofF and found not many pertinent results. I'd like some recommendations on web log analyzer software. I'd like it to be easy to configure (no command line), work with IIS 6 and not cause too much overhead. Automated monthly report generation is my main concern for several domains. I don't require real time, roi, pay per click or even daily/hourly reports, etc. I've used WebTrends in the past and found it limited. Perhaps their latest version would be better? Deepmetrix? Urchin? AWStats? Let me know... Any thoughts or ideas would be great. Thanks, Che. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231522 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Log analyzer software.
May be I need to re-phrase my response but the point I want to make is still the same. It is pretty well-known that many trojans and back-doors make use of the port . Many firewalls and companies block that port as well. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Monday, February 06, 2006 3:38 PM To: CF-Talk Subject: RE: Log analyzer software. Ok, may be I'm jumping the gun but Port is such a notorious port. I wouldn't want to give that to my customers if I were you. Here is some info on port : http://www.auditmypc.com/port/tcp-port-.asp And if you google with the word port , there might be more info. That's kind of silly. Ports aren't notorious. It's what listens on a port that you have to worry about, not the port itself. High ports (greater than 1024) are used by all sorts of TCP clients and servers all the time. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231528 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: RJustify Question
Table and div solutions are good. For some reasons if they don't work, using the tag below will solve the issue. cfprocessingDirective suppressWhitespace=No pre !--- Align nicely without CF codes here --- /pre /cfprocessingDirective HTH Pine -Original Message- From: Eric Roberts [mailto:[EMAIL PROTECTED] Sent: Thursday, February 02, 2006 8:54 PM To: CF-Talk Subject: RE: RJustify Question Use a table and right align the columns... Eric -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Thursday, 02 February 2006 19:03 To: CF-Talk Subject: RJustify Question Trying to align a column of integers 9 11 999 77 3 So, the below does nothing: #RJustify(9, 3)# #RJustify(11, 3)# #RJustify(999, 3)# Suggestions? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231256 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: ValueList and Dynamic Query and Column
Just using another String variable and not returning the valueList directly might solve? Like cfparam someVar type=string default= cfset someVar = valueList(query.column) and return the someVar at the end of the function with cfreturn someVar? -Original Message- From: Dawson, Michael [mailto:[EMAIL PROTECTED] Sent: Thursday, February 02, 2006 12:57 PM To: CF-Talk Subject: ValueList and Dynamic Query and Column I think I remember this being a problem, but I'm trying to create a value list from a dynamic query and column. Something like this: function(query, column) { return valueList(query.column); } That's the gist of it, but it doesn't work. Any suggestions? Thanks M!chael A Dawson Manager of Web Applications Office of Technology Services University of Evansville 1800 Lincoln Avenue Evansville, IN 47722 812-488-2581 MSN Messenger ID: [EMAIL PROTECTED] There are 10 types of people in the world: Those who understand binary numbers and those who don't. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231208 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Capture CF Admin settings
May be cfdump the settings into the file might solve the problem? Depending on what you want, you can do something like this, CFOBJECT ACTION=CREATE TYPE=JAVA CLASS=coldfusion.server.ServiceFactory NAME=factory !--- Get datasource service --- CFSET dsService=factory.getDataSourceService() CFSET datasources=factory.getDataSourceService().getDataSources() CFDUMP VAR=#datasources# You can display the whole factory with the above code. That might be something that you want to do? HTH, Pine -Original Message- From: Cameron Johnson [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 01, 2006 7:33 AM To: CF-Talk Subject: Capture CF Admin settings Hi, all. Rather than taking screen shots or saving each page as an HTML file, is there a way to capture and store all of the CF Admin settings? Doing a CF reinstall without properly document settings is a pain and I'm looking for some pain relief. Thanks, Cameron ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230973 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Capture CF Admin settings
Oh, yes, you are right. You can export the settings as a CAR file if you can access to the CF Admin page. (or if you are CF Admin). -Original Message- From: Mark Drew [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 01, 2006 8:41 AM To: CF-Talk Subject: Re: Capture CF Admin settings I belive you could export it as a CAR file Hope that helps MD On 01/02/06, Cameron Johnson [EMAIL PROTECTED] wrote: Hi, all. Rather than taking screen shots or saving each page as an HTML file, is there a way to capture and store all of the CF Admin settings? Doing a CF reinstall without properly document settings is a pain and I'm looking for some pain relief. Thanks, Cameron ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230975 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Set session variables in JS?
Hi Dan, Can you elaborate a bit on point 3 - Use Image()object in JS to post to a fixed URL. I know how to do the other 3 (Form, Hidden fields/iframe and AJAX) but not sure how to do on point 3 that you mentioned. Apart from all those you mentioned, you can pass the values in the URL or Attributes via query string by using window.location to itself (with different URL or Attributes variables). Thanks in advance. Pine -Original Message- From: Dan G. Switzer, II [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 01, 2006 7:10 AM To: CF-Talk Subject: RE: Set session variables in JS? Eric, Is there a specific or easy way to set session variables while in the middle of a javascript routine? I can't seem to recall...thanks. JavaScript executes on the client where as CF executes on the server. You can't have JavaScript directly affect the outcome of the current running template. That means you can't do: var aJSVariable = prompt(Your name:); cfset session.name = aJSVariable / Now that's not to say that you can't use JavaScript to change the value of a session variable for sequential requests. There are a couple of ways to accomplish this, but they are revolve having the browser talk back to the server: 1) Update a form variable and then submit the form back to the server. 2) Use a hidden iframe to post back to a fixed URL to update the server. 3) Use the Image() object in JS to post to a fixed URL to update the server. 4) Use AJAX to update the server. -Dan ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230977 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Set session variables in JS?
Thanks Jim, that article is really informative!! -Original Message- From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 01, 2006 9:25 AM To: CF-Talk Subject: RE: Set session variables in JS? -Original Message- From: PINE Phyo Z [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 01, 2006 11:51 AM To: CF-Talk Subject: RE: Set session variables in JS? Hi Dan, Can you elaborate a bit on point 3 - Use Image()object in JS to post to a fixed URL. I know how to do the other 3 (Form, Hidden fields/iframe and AJAX) but not sure how to do on point 3 that you mentioned. Here's my method for that: http://www.depressedpress.com/Content/Development/JavaScript/Articles/GI FAsP ipe/Index.cfm It's old (about 6 years old now) but still works a treat. Jim Davis ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231030 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Set session variables in JS?
Thanks a lot for the pointer, Dan. Regards, Pine -Original Message- From: Dan G. Switzer, II [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 01, 2006 9:43 AM To: CF-Talk Subject: RE: Set session variables in JS? Pine, Hi Dan, Can you elaborate a bit on point 3 - Use Image()object in JS to post to a fixed URL. I know how to do the other 3 (Form, Hidden fields/iframe and AJAX) but not sure how to do on point 3 that you mentioned. Here's my method for that: http://www.depressedpress.com/Content/Development/JavaScript/Articles/G IFAs P ipe/Index.cfm It's old (about 6 years old now) but still works a treat. Jim's technique is crutch of it, but instead of actually putting an img / tag in your code, you can use something like: var oImgGateway = new Image(); oImgGateway.src = someurl.cfm?passParam=here; This will create an async event that will load the URL in the src property to the server. The caveat with this approach is that you have no way to really interact with the server--basically you can only use it to pass information to the server, you won't be able to retrieve information from the server using that technique. -Dan ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231031 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFEclipse Vs Dreamweaver
Thanks Steven. That is really helpful. I am going to try CSS Editor, Javascript Editor and probably colorer. Regards, Pine -Original Message- From: Steven Brownlee [mailto:[EMAIL PROTECTED] Sent: Friday, January 27, 2006 9:39 PM To: CF-Talk Subject: RE: CFEclipse Vs Dreamweaver Sure, here's my list of essentials. Takes about 15 minutes to install these. - CFeclipse (http://www.cfeclipse.org/) - Subclipse (http://subclipse.tigris.org/) - QuickREx (http://www.bastian-bergerhoff.com/eclipse/features/web/QuickREx/toc.htm l) - DBEdit* (http://sourceforge.net/projects/dbedit) - CSS Editor (http://csseditor.sourceforge.net/) - Javascript editor (http://www.interaktonline.com/Products/Eclipse/JSEclipse/Overview/) Other I have installed but aren't essential for CF development. - PHP Editor (http://www.phpeclipse.de/tiki-view_articles.php) - Flex 2 plugin (http://labs.macromedia.com/technologies/flexframework2/) - Colorer (http://colorer.sourceforge.net/eclipsecolorer/index.html) *Note about DBEdit plugin. The auto-install site installs the tool buggy. Best to download the zip and install it manually (just unzip directly to eclipse directory). I'm familiar with all the new features in DW8. I really do like the CSS editor... a lot. However, the one in Eclipse suits my needs so I never think to open up DW for it. -Original Message- From: Greg Hamer [mailto:[EMAIL PROTECTED] Sent: Saturday, January 28, 2006 12:15 AM To: CF-Talk Subject: Re: CFEclipse Vs Dreamweaver Steve, I have Eclipse 3.1 with CFEclipse 1.2.0. Obviously Eclipse gives me the Java code editor, and CFEclipse the CF code editor. Am I correct that for me to have a config that matches yours, I have to install a few more plugins? e.g for DB tool, stylesheet editor, Subversion view and regular expression builder? Would you be so kind as to share with me which plugins you are using? I currently am not in a team environment. Your sharing how you have rolled up your configuration would be greatly appreciated :) I anticipate I will be spending alot of time in Flex 2 starting next month, so there is some Eclipse in my future one way or another. Thank you for sharing how you are using Eclipse. btw ... Lynda.com has a great 17 part (1 hour), online video training title on Dreamweaver 8 New Features with Garrick Chow. The first 2 on CSS are free. Link here: http://movielibrary.lynda.com/html/modPage.asp?ID=173 Best regards, g ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230869 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT: Need Site Reviewers Please
I went through it too. But just looking at them from end user's perspective. -Original Message- From: Dana [mailto:[EMAIL PROTECTED] Sent: Friday, January 27, 2006 10:00 PM To: CF-Talk Subject: Re: OT: Need Site Reviewers Please I went through the sites. Mainly looking at the layout/color perspective On 1/27/06, C. Hatton Humphrey [EMAIL PROTECTED] wrote: I'm teaching Web Scripting Authoring and have about 10 sites that need reviewing folks that are in the web industry. Last time I sent out a word doc via email and sincerely appreciate the time everyone took to review the sites. This time I have an easier method that will take less time for anyone willing to fill out a small survey on the sites that have been submitted. I have built a small application that wraps the student site, survey and assignment description in one page. In addition the application remmebers the last site you filled out a survey on and takes you to the next site, so if you don't have time to go through all the sites you can come back later. If you're interested in participating simply go to http://chumphrey.guardian-web.com/index.cfm and sign in using your email address and putting in your name (if you feel like it). All surveys are reported to the students confidentially and names are optional. Please drop me an email and let me know so I can have an idea of a participation count. The current asignment is to build a static business website. These students are multimedia students so they've been spending a lot of time working with flash, director, 3D Studio max but not much with HTML. The sites being presented with this assignment have been built using Notepad to hammer in HTML tag concepts. They were told that an element of wow would be incorperated into the surveys. I know that there are a few that are text only... and their surveys need to reflect the fact that they did not take any graphics into account. I'll be closing out this assignment's surveys on Thursday, February 2 by 1 or 2 pm. There are more assignments coming soon! Thanks for your time! Hatton ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230870 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Viewing Cflog files
Hi all, I'm just wondering whether there is a way to view the log files that are created in the application using cflog to be able to view programmatically. For my case, the ColdFusion servers and logfiles directories are out of bounds for developers, so I would like to know whether I can access back the log files I have written in the application something like this: cflog file=#APPLICATION.myAppLog# text=Some log messages here! So, from another part of my application (admin's portion), I would like to run some code to view my log files contents. Is there a way to do this? Thanks in advance. Regards, Pine ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230901 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Encrypt Decrypt
Hi Larry, Your immediate problem can be solved by escaping it (##) AND assigning it to another variable. Use this: cfset encryptString = 2:GR4G5_,3++Q]##9:N+?)N4 br#Decrypt(encryptString,7xxT533zrt3d9in)# I have tried and it worked. But just a suggestion, you might want to work with GenerateSecretKey or hash. (For more info, consult the livedocs). Thanks Regards, Phyo Pine Information Systems Specialist DMV - ODOT -Original Message- From: Stephens, Larry V [mailto:[EMAIL PROTECTED] Sent: Friday, January 27, 2006 1:51 PM To: CF-Talk Subject: Encrypt Decrypt I'm using a simple encrypt statement to store info: #Encrypt(SESSION.Customer.xxx, GetX.Item)#', (this is from my INSERT statement) GetX.Item is the key loaded from a table. (I don't profess to be an expert in encryption (obviously) but, other than being a little obtuse in the code, I don't know how to hide the key any better on a server I don't control. I'm certainly open to suggestion.) Hiding the key aside, my decryption routine looks like (I'm moving it to another table that is secure): FieldX = '#Decrypt(FieldSaved, GetX.Item)#', where aaa is the data retrieved from the table and GetX.Item is the same key. And it works, (e.g., decrypting 0Z[ STK6_,;)*!I+!/ )until the encrypted data looks like 3JG$P5[0];!/QM#!O So, I played with it a bit and it became obvious that the problem is the # imbedded in the encrypted data. What now? I can't escape it (##) because that throws an error, too. To illustrate what seems to be happening: !--- this works --- cfset x=Encrypt(730072022000SerNum,7xxT533zrt3d9in) cfoutput #x# !--- this will be: 2:GR4G5_,3++Q]#9:N+?)N4 --- br /#Decrypt(x,7xxT533zrt3d9in)# !--- run routine then uncomment next line and run again --- !---br /#Decrypt(2:GR4G5_,3++Q]#9:N+?)N4 ,7xxT533zrt3d9in)#--- /cfoutput Larry Stephens [EMAIL PROTECTED] ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230637 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Geting a list of query column names unsorted.
Wow, thanks Oleg. -Original Message- From: Oleg Gunkin [mailto:[EMAIL PROTECTED] Sent: Friday, January 27, 2006 2:22 PM To: CF-Talk Subject: RE: Geting a list of query column names unsorted. Phyo Pine, just use the following: cffunction name=getColumns access=public returntype=string cfargument name=query required=yes type=query cfreturn ArrayToList(query.getMetaData().getColumnLabels()) /cffunction -- Oleg Gunkin Email: [EMAIL PROTECTED] Phone: (604) 666-9392 Emerging Technologies / Pacific Web Services Information Technology Services Public Works and Government Services Canada (Pacific) -Original Message- From: Phyo Pine [mailto:[EMAIL PROTECTED] Sent: Friday, January 27, 2006 13:15 To: CF-Talk Subject: Re: Geting a list of query column names unsorted. I am interested in the solution too. I was having the same trouble when I was using cfdump var=#queryname# as well. So the work-around I did was instead of SELECT c,a,b FROM someTable, I used SELECT c as 1c, a as 2a, b as 3b FROM someTable. Hope this helps... Regards, Phyo Pine Information Systems Specialist DMV - ODOT 'query_name.columnlist' returns a sorted list of column names, but I really need it to be unsorted because for the query 'select c, a, b from t' I need 'c,a,b' list, NOT 'a,b,c'. How do I get an unsorted list of columns? -- Oleg Gunkin Email: [EMAIL PROTECTED] Phone: (604) 666-9392 Emerging Technologies / Pacific Web Services Information Technology Services Public Works and Government Services Canada (Pacific) ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230642 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CFEclipse Vs Dreamweaver
Hi all, What IDE do you normally use for CF? I heard a lot of raves about CFEclipse so I downloaded it and use at home. I normally use Dreamweaver at work. Apart from CFEclipse being free, I do not find any considerable edge or advantage over Dreamweaver. (Any CFEclipse developers, no offence please.) Any thoughts on this? May be I am not using it right but CFEclipse lacks mainly, IMHO, in graphical representation. In Dreamweaver, I can go back and fort on Design view and Code view and most of the HTML component creation is a snap. (May be CFEclipse is more geared for pure ColdFusion.) But in CFEclipse I need to type everything in. Well, may be I am not geek enough but just typing everything in for complex UI seem like really a chore to me. Thanks Regards, Phyo Pine Information Systems Specialist DMV - ODOT ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230643 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFEclipse Vs Dreamweaver
Hi Barney, yes, you are right. When it comes to version control with CVS et al., CFEclipse is best suited. Thanks for pointing that out. Apart from being the CF developer, I am also a Java developer and working on Eclipse platform too. So, I can see the benefits that you describe. Within one tool, you can move from Java to CF to XML to anything else Eclipse is supporting. In that aspect, CFEclipse is cool. May be I should find another Eclipse plug-ins for HTML and CSS for design aspects. Thanks Regards, Pine -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Friday, January 27, 2006 2:53 PM To: CF-Talk Subject: Re: CFEclipse Vs Dreamweaver CFE is definitely targeted at code-centric developers, while DW is essentially an HTML design tool that has had a lot code-centric stuff bolted on. Neither approach is better or worse, just suited to different people. The most important difference, however, has nothing to do with that. CFE is built upon Eclipse, which brings with it more tools that you could hope to learn about this year. You install Eclipse, and then you can start building the dev environment that you need, not the one that company X thought you needed. For example, DW doesn't integrate with version control, but Eclipse plugins exist for CVS, SVN, Perforce, VSS, and probably others. Want XML editing? There are choices there too: XmlBuddy, oXygen, MyEclipse's XML stuff, and others. That's the best reason I see to use CFE over DW. In all honesty, I still think CFE is lacking compared to DW in some areas (like snippet usability), but the external tools support make it WAY better overall. I might lose 10-15 minutes a day because of stuff DW would make easier, but I'll save an hour or more with all the other integrated tools I can use in it. cheers, barneyb On 1/27/06, PINE Phyo Z [EMAIL PROTECTED] wrote: Hi all, What IDE do you normally use for CF? I heard a lot of raves about CFEclipse so I downloaded it and use at home. I normally use Dreamweaver at work. Apart from CFEclipse being free, I do not find any considerable edge or advantage over Dreamweaver. (Any CFEclipse developers, no offence please.) Any thoughts on this? May be I am not using it right but CFEclipse lacks mainly, IMHO, in graphical representation. In Dreamweaver, I can go back and fort on Design view and Code view and most of the HTML component creation is a snap. (May be CFEclipse is more geared for pure ColdFusion.) But in CFEclipse I need to type everything in. Well, may be I am not geek enough but just typing everything in for complex UI seem like really a chore to me. Thanks Regards, Phyo Pine -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230647 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFEclipse Vs Dreamweaver
Hi Spike, You are probably right. While I want to code tons of CFCs or UDFs I might use CFEclipse and while I have many UI elements to develop, I might switch to Dreamweaver. Nonetheless, I can see CFEclipse has the potential and would like to see some design elements considerations in future version. Anyway, that is just my view. A little bit OT but just curious since I am also using WSAD (WebSphere Application Developer) which is on Eclipse platform, is there any way that I can use CFEclipse inside WSAD? Thanks Regards, Pine -Original Message- From: Spike [mailto:[EMAIL PROTECTED] Sent: Friday, January 27, 2006 2:53 PM To: CF-Talk Subject: Re: CFEclipse Vs Dreamweaver If you find that the design view part of DreamWeaver is important to you, it is probably best to stick with that rather than CFEclipse. One of the goals of CFEclipse is to be a code centric tool, which means that we have pretty much no intention of adding design view support. Spike On 1/27/06, PINE Phyo Z [EMAIL PROTECTED] wrote: Hi all, What IDE do you normally use for CF? I heard a lot of raves about CFEclipse so I downloaded it and use at home. I normally use Dreamweaver at work. Apart from CFEclipse being free, I do not find any considerable edge or advantage over Dreamweaver. (Any CFEclipse developers, no offence please.) Any thoughts on this? May be I am not using it right but CFEclipse lacks mainly, IMHO, in graphical representation. In Dreamweaver, I can go back and fort on Design view and Code view and most of the HTML component creation is a snap. (May be CFEclipse is more geared for pure ColdFusion.) But in CFEclipse I need to type everything in. Well, may be I am not geek enough but just typing everything in for complex UI seem like really a chore to me. Thanks Regards, Phyo Pine Information Systems Specialist DMV - ODOT ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230649 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFEclipse Vs Dreamweaver
Heh heh... You are right on about the tag closing feature. Now-a-days, after I typed an opening tag, I almost expect the closing tag to be appeared automatically.. -Original Message- From: John Wilker [mailto:[EMAIL PROTECTED] Sent: Friday, January 27, 2006 3:02 PM To: CF-Talk Subject: Re: CFEclipse Vs Dreamweaver Just to clarify DW does integrate with source control. VSS, out of the box, others with some tweaking. I've used Seapine and VSS with DW That said. I like both. THere are some lazy programmer things DW offers (tag closing) that I really have gotten used to. Both are great in their own ways. On 1/27/06, Barney Boisvert [EMAIL PROTECTED] wrote: CFE is definitely targeted at code-centric developers, while DW is essentially an HTML design tool that has had a lot code-centric stuff bolted on. Neither approach is better or worse, just suited to different people. The most important difference, however, has nothing to do with that. CFE is built upon Eclipse, which brings with it more tools that you could hope to learn about this year. You install Eclipse, and then you can start building the dev environment that you need, not the one that company X thought you needed. For example, DW doesn't integrate with version control, but Eclipse plugins exist for CVS, SVN, Perforce, VSS, and probably others. Want XML editing? There are choices there too: XmlBuddy, oXygen, MyEclipse's XML stuff, and others. That's the best reason I see to use CFE over DW. In all honesty, I still think CFE is lacking compared to DW in some areas (like snippet usability), but the external tools support make it WAY better overall. I might lose 10-15 minutes a day because of stuff DW would make easier, but I'll save an hour or more with all the other integrated tools I can use in it. cheers, barneyb On 1/27/06, PINE Phyo Z [EMAIL PROTECTED] wrote: Hi all, What IDE do you normally use for CF? I heard a lot of raves about CFEclipse so I downloaded it and use at home. I normally use Dreamweaver at work. Apart from CFEclipse being free, I do not find any considerable edge or advantage over Dreamweaver. (Any CFEclipse developers, no offence please.) Any thoughts on this? May be I am not using it right but CFEclipse lacks mainly, IMHO, in graphical representation. In Dreamweaver, I can go back and fort on Design view and Code view and most of the HTML component creation is a snap. (May be CFEclipse is more geared for pure ColdFusion.) But in CFEclipse I need to type everything in. Well, may be I am not geek enough but just typing everything in for complex UI seem like really a chore to me. Thanks Regards, Phyo Pine -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230650 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54