RE: Dual Xeon 3.06 GHz - 120 GB IDE HD - 2 GB RAM
It states that with Raid 1 (mirror) the write speed is the same I cant see where it says that? Maybe a case of temporary blindness on my part, or maybe John has just edited the encyclopedia -Original Message- From: Russ [mailto:[EMAIL PROTECTED] Sent: 19 January 2006 16:21 To: CF-Talk Subject: RE: Dual Xeon 3.06 GHz - 120 GB IDE HD - 2 GB RAM I'm not so sure about that. Check wikipedia: http://en.wikipedia.org/wiki/Redundant_array_of_independent_disks#RAID_1 It states that with Raid 1 (mirror) the write speed is the same as a single disk, and the read speed is doubled (because each disk in the mirror can be accessed individually). Seek time is also halved. Russ -Original Message- From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 18, 2006 6:23 PM To: CF-Talk Subject: Re: Dual Xeon 3.06 GHz - 120 GB IDE HD - 2 GB RAM On 1/18/06, Baz [EMAIL PROTECTED] wrote: Good call. Actually, a *mirror* RAID array is *slower*, all other things being equal. Two writes instead of 1, though certain controllers make the overhead *very* small. Reads, not so different. If you're after pure speed, you want a RAID *stripe* -- eg RAID 0, which spreads data access across 2 or more drives with a corresponding increase in speed. All that said, while YMMV, 2gb is gonna put all but the most enormous and session-variable-intensive web sites into RAM, so the HD hit is minimal. But I'd still get RAID w/o even thinking twice -- more flexibility for either redundancy (RAID 1, 5, 10) or speed (RAID 0) -Original Message- From: Russ [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 18, 2006 3:06 PM To: CF-Talk Subject: RE: Dual Xeon 3.06 GHz - 120 GB IDE HD - 2 GB RAM The hd is an obvious bottleneck. That's usually the slowest point in your system. I would use a SCSI or at least a SATA drive, and then probably for good measure set it up a mirror RAID array (that way you get better performance. Russ -Original Message- From: Baz [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 18, 2006 2:49 PM To: CF-Talk Subject: Dual Xeon 3.06 GHz - 120 GB IDE HD - 2 GB RAM If I installed: - CFMX7 Enterprise - MySQL 5.0 On the following machine: - Dual Xeon 3.06 GHz - 120 GB IDE HD - 2 GB RAM Am I making good use of the hardware? Can both technologies fully utilize the CPU and RAM? Any obvious bottlenecks, perhaps add another GB of ram? Cheers, Baz ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229989 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: Avoiding copying by value
AFAIK: I think that shows that the session pointer to the object in memory (query) is deleted, but because there is another pointer to the object - q -, then the object in memory is not deleted by the garbage collection. i.e session.qncache is not a query, its a pointer to a query object in memory. so q = session.qncache_qn means get me another pointer to the object that session.qncache_qn points to -Original Message- From: Terry Ford [mailto:[EMAIL PROTECTED] Sent: 05 January 2006 15:10 To: CF-Talk Subject: Re: Avoiding copying by value Hi Joe, That's what I used to think, too. But take the following code: cfset q = session.qncache_qn cfset structdelete(session,qncache_qn) cfdump var=#q# That cfdump works. This shows that the whole query HAS been copied to Q. Regards, Terry Hey Terry, Queries are references types in CF, so it's not an issue. Example: cfset qry1 = queryNew(column) / cfset queryAddRow(qry1) / cfset querySetCell(qry1, column, foo) / cfset qry2 = qry1 / cfset querySetCell(qry2, column, bar) / cfdump var=#qry1# / cfdump var=#qry2# / -Joe On 1/5/06, Terry Ford [EMAIL PROTECTED] wrote: ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:228481 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: Reference to undefined entity APOS;.
I seem to remember XML choking on the ampersand unless its within a CDATA block? -Original Message- From: Rob Sherman [mailto:[EMAIL PROTECTED] Sent: 05 January 2006 16:20 To: CF-Talk Subject: Reference to undefined entity APOS;. Hi, I'm running CFMX 6.1 (Standard) updater 1. I have some lengthy code that builds a valid XML structure, and even use XMLFormat() on text that I think might choke the process, but when CFMXL tries to make it into a DOM it chokes with the above error: XmlProcessException: Reference to undefined entity APOS;. I know APOS; isn't in HTML, but is valid for XML, but I've even tried stripping out any ' characters I can find replacing them with #39; as a possible workaround. Any ideas? Sincerely, Rob ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:228486 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: cfquery result=
6.1 says: Attribute validation error for tag CFQUERY. The tag does not allow the attribute(s) RESULT -Original Message- From: Ryan Guill [mailto:[EMAIL PROTECTED] Sent: 30 November 2005 14:11 To: CF-Talk Subject: cfquery result= This is probably a dumb question, but I'll ask just to make sure. Does someone have a 6.1 box they can test something on for me? I just want to know if you have a cfquery tag with a result attribute if it will fail on 6.1? Im sure it will, but it would be awesome if it didn't... cfquery name=foo datasource=yourdatasource result=variables.result /cfquery -- Ryan Guill BlueEyesDevelopment [EMAIL PROTECTED] www.ryanguill.com (270) 217.2399 got google talk? Chat me at [EMAIL PROTECTED] The Coldfusion Open Application Library - COAL - http://coal.ryanguill.com www.ryanguill.com/ The Roman Empire: www.ryanguill.com/blog/ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225671 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: pseudo-memory leak
are you saying if it takes 2 weeks to hack a website, its less hacked than if it takes 2 hours? :P -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 30 November 2005 16:09 To: CF-Talk Subject: RE: pseudo-memory leak Clocks ticking. ;-) -Original Message- From: Russ [mailto:[EMAIL PROTECTED] Sent: 30 November 2005 16:22 To: CF-Talk Subject: RE: pseudo-memory leak Well turns out that CF uses MD5, which is a little different then LM hashes used for windows passwords. I just need to get (or generate) the Rainbow tables first, and then it should be a piece of cake. -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 30, 2005 9:31 AM To: CF-Talk Subject: RE: pseudo-memory leak Seems like it is taking him a while ;-) -Original Message- From: Ryan Guill [mailto:[EMAIL PROTECTED] Sent: 29 November 2005 21:52 To: CF-Talk Subject: Re: pseudo-memory leak Ill give you another. Just to make sure its all kosher. Lets say a normal password string, could include numbers and letters, max length of 20, min length of 6. That should narrow it down some for you. No spaces either. 997DA8FE4C40296C21CE8E1EB9BDC5B6 On 11/29/05, Russ [EMAIL PROTECTED] wrote: Well what kind of string am I working with? For all I know, you could've hashed a whole book. Is there a length limit? (as there would very likely be if this was a password) -Original Message- From: Ryan Guill [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 29, 2005 4:36 PM To: CF-Talk Subject: Re: pseudo-memory leak Tell you what. See how long it takes you to brute force this hash. Post the cleartext when you get it. 6AF59B04BA48B18C15E3CB3ACB2BA75B I want to see how long it takes you. On 11/29/05, Russ [EMAIL PROTECTED] wrote: The passwords in windows are stored as hashes. They are not stored as plaintext. In order to get This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225700 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: pseudo-memory leak
FYI, hashing something doesnt mean that it cant be extracted, why just the other day my little 2Ghz workstation extracted a 5 character password from a hash in about 5 minutes... -Original Message- From: Snake [mailto:[EMAIL PROTECTED] Sent: 29 November 2005 09:43 To: CF-Talk Subject: RE: pseudo-memory leak Normally you would HASH the data so it cannot be extracted and used or changed. -Original Message- From: Russ [mailto:[EMAIL PROTECTED] Sent: 28 November 2005 23:40 To: CF-Talk Subject: RE: pseudo-memory leak Cookies are not very secure now, are they? Lets say I was going to let the user be logged in, and I wanted that to persist... So I would do.. Client.userId=123456 Now, the user has no way to change that... Now, lets say I store it in the cookie... Cfcookie name=userId value=123456 Now, the user can examine their cookies and know their userid. Worse, they can change the userid, and be logged in as a different user. Russ -Original Message- From: Ryan Guill [mailto:[EMAIL PROTECTED] Sent: Monday, November 28, 2005 2:04 PM To: CF-Talk Subject: Re: pseudo-memory leak I have never really found a need for client variables. What benefit do they really offer? The only time I could see using them is when you had something that you might think about storing in a cookie. I rarely come across a need like that where I dont really want a cookie, and if I do I usually just store it in the session. Am I missing something there? On 11/28/05, Russ [EMAIL PROTECTED] wrote: Are you still running another server on BD? How is BD handling this issue? -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: Monday, November 28, 2005 1:38 PM To: CF-Talk Subject: pseudo-memory leak I've written up my thoughts on what looks like the problem that the House of Fusion server was facing for the last few weeks. It's a problem that probably affects others but I'm not going to comment on how wide spread it is until the full write-up on Fusion Authority. These are just my notes and thoughts. http://www.blogoffusion.com/index.cfm/2005/11/28/pseudomemory-leak ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225590 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: cfinclude problem
If you cant use relative incs, what you could do in a shared environment is put all your include files in a namespace that no one else should be using... havent actually had to do it myself but I would guess something along the lines of: /com_mydomain/myappname/includes /com_mydomain/myappname/common -Original Message- From: daniel kessler [mailto:[EMAIL PROTECTED] Sent: 11 November 2005 16:04 To: CF-Talk Subject: Re: cfinclude problem ah, you are on a shared host? Chances are, someone else has a mapping of /common already set up. The mapping would take priority over the absolute mapping, so cf is looking for a file in that /common mapping, not your /common directory. rename your common folder to something like /commonFoo and change your cfinclude accordingly and see if it works. Yep that worked fiine, dangit. ok, so the solutions are to rename my dir or use relative (../) urls. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223978 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 + file append + decrypt
no one? anyway, realised my mistake as soon as I left the office - each message has to be decrypted individually. Just because they are all encrypted using the same algorithm and appended doesnt mean you can decrypt them all in one go. -Original Message- From: Kerry [mailto:[EMAIL PROTECTED] Sent: 09 November 2005 18:48 To: CF-Talk Subject: encrypt + file append + decrypt okay, been looking at this for a while now, cant see why its not working, suggestions appreciated! !--- environment: cfmx 6.1, win2K code objective: encrypt string + linebreak, append to file (repeat), read file, decrypt, display in textarea expected output: 1 2 3 4 5 6 7 8 9 10 actual output: 1 --- cfset logdir = getdirectoryfrompath(getcurrenttemplatepath()) cfset logfil = encrypted.txt cfset logpath = logdirlogfil cfif fileexists(logdirlogfil) cffile action=delete file=#logpath# /cfif cfloop from=1 to=10 index=i cfset message = encrypt(URLEncodedFormat(ichr(13)chr(10)),hash(logfil)) cfif not fileexists(logdirlogfil) cffile action=write file=#logpath# output=#message# addnewline=no cfelse cffile action=append file=#logpath# output=#message# addnewline=no /cfif /cfloop cffile action=read file=#logpath# variable=filcontents cfoutput textarea #URLDecode(decrypt(filcontents,hash(logfil)))# /textarea /cfoutput thx all. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223809 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: SESSION or not to SESSION
question: Do you have to modify the JVM settings so that CF can actually use our theoretical 1GB of RAM? -Original Message- From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED] Sent: 09 November 2005 16:02 To: CF-Talk Subject: Re: SESSION or not to SESSION On 11/9/05, Ken Ferguson [EMAIL PROTECTED] wrote: I'll go along with this sentiment. Use session variables when you need them, but put what you can into the applicaiton and request scopes. RAM is cheap. --Ferg Agreed. Actually, it's a lot easier to turn the calculation around. You have a maximal peak of a little less than 30,000 users (2000 active 27000 casual), so 1MB of RAM gives each of those 30k users 33bytes. Assuming Unicode to give a lot of overhead, that's 16 usable bytes per MB. Cut that in half to factor in a lot of overhead and you've got 8 usable bytes left. So 1 GB of RAM for session use would give you 8000 bytes per person with plenty of room left over that's assuming your box can *handle* all 30k at once, which is pretty unlikely :) Using a more realistic scenario like 1000 users with active sessions 1MB - 1000 bytes - 500 unicode characters -50%overhead- 250 usable bytes/user So 1GB yields 250,000 usable bytes of storage for that user. That's a lot of storage sidebarI'm using characters to equate to usable bytes since ColdFusion isn't really typed -- under the hood, it's converted in many cases, but using characters should be on average equal or greater than the underlying data strucuture. This is really an order of magnitude calculation so the specifics are not a big deal -- and if anything, these should be pretty conservative numbers./sidebar So the point is, you really have to put a *lot* in session scope and/or have a *lot* of users to approach any real worries about session memory. -- John Paul Ashenfelter CTO/Transitionpoint (blog) http://www.ashenfelter.com (email) [EMAIL PROTECTED] ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223680 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
encrypt + file append + decrypt
okay, been looking at this for a while now, cant see why its not working, suggestions appreciated! !--- environment: cfmx 6.1, win2K code objective: encrypt string + linebreak, append to file (repeat), read file, decrypt, display in textarea expected output: 1 2 3 4 5 6 7 8 9 10 actual output: 1 --- cfset logdir = getdirectoryfrompath(getcurrenttemplatepath()) cfset logfil = encrypted.txt cfset logpath = logdirlogfil cfif fileexists(logdirlogfil) cffile action=delete file=#logpath# /cfif cfloop from=1 to=10 index=i cfset message = encrypt(URLEncodedFormat(ichr(13)chr(10)),hash(logfil)) cfif not fileexists(logdirlogfil) cffile action=write file=#logpath# output=#message# addnewline=no cfelse cffile action=append file=#logpath# output=#message# addnewline=no /cfif /cfloop cffile action=read file=#logpath# variable=filcontents cfoutput textarea #URLDecode(decrypt(filcontents,hash(logfil)))# /textarea /cfoutput thx all. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223707 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: portable SQL queries with date and time values
dont know about best practice, but to ensure date portability I dont use date fields in the DB, I use varchar fields and put ISO dates in them e.g. 20051027T161420 Then if needed, I convert to proper dates once the value is out of the DB. Since I know the string will alway be in the same format, I can use string functions e.g. mid() to pull the data out and create a date - createdate(left(mydate,4),mid(mydate,5,2) e.t.c. -Original Message- From: wolf2k5 [mailto:[EMAIL PROTECTED] Sent: 27 October 2005 15:56 To: CF-Talk Subject: Re: portable SQL queries with date and time values On 8/17/05, wolf2k5 [EMAIL PROTECTED] wrote: Hi, I am trying to figure out what is the best way to write SQL queries including date and time values that will work across several Oracle Database installations (different versions and different regional settings). So far I am using some code similar to this: cfset myMask = MM/DD/ !--- just for testing, the real value is not the current date --- cfset myDate = DateFormat(Now(),myMask) cfquery name=myQuery datasource=myDatasource SELECT * FROM myTable WHERE TRUNC(myDate) TO_DATE(cfqueryparam value=#myDate# cfsqltype=CF_SQL_VARCHAR,cfqueryparam value=#myMask# cfsqltype=CF_SQL_VARCHAR) /cfquery It works fine and AFAIK it should be pretty portable to other Oracle Database installations. But I just figured out that simpler code also seems to work fine: cfset myDate = DateFormat(Now(),myMask) cfquery name=myQuery datasource=myDatasource SELECT * FROM myTable WHERE TRUNC(myDate) cfqueryparam value=#myDate# cfsqltype=CF_SQL_DATE /cfquery I'd like to use it since it's more compact ... Will it work fine with all Oracle Database installations? Also, I found some posts recommending to use the CreateODBCDate function. Is that a better way? Why? Thanks. Hi there, I didn't find a good reply to my previous questions yet. What is the best practice here in your opinion? Thanks a lot. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222431 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: Recursion anyone?
There are loads and loads of DHTML menus out there, e.g. http://www.dynamicdrive.com/dynamicindex1/hvmenu/ with the actual menu code taken care of, all you have to do is recurse over your database and write out the menu items. last time i checked, cftree outputs a java applet, not javascript. do you not know how to recurse? heres some pseudo code variables.inst.menuqry = getAllCategories(); function buildmenu(currentid){ var i=0; for(i=1; i lte variables.inst.menuqry.recorcount; i=i+1){ if(variables.inst.menuqry.parent_id[i] eq arguments.currentID) writeoutput(your javascript); buildmenu(variables.inst.menuqry.id[i]); } } } buildmenu(yourrootid); -Original Message- From: Stephen Whiteley [mailto:[EMAIL PROTECTED] Sent: 26 October 2005 11:15 To: CF-Talk Subject: Recursion anyone? Hi I keep returning to this problem in order to build an infinite DHTML menu (a task which has now become a quest and a matter of honour). Does anyone know how to recurse through an adjacency list model table, of the following setup ID CategoryName ParentItemID Also, I hear you can use CFTREE format=xml or format=object and then use that to make a DHTML menu? anyone have any experience Muchos Thank You's Steve ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:84 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: Recursion anyone?
1) in my original code, getallcategories is a function, not a query. change to: variables.inst.menuqry = getAllCategories; 2) note that the buildmenu function does not return anything, so this: cfset returnValue=buildmenu(10) Is going to give you null. 3) writeoutput(variables.menuqry.adcategoryname); This is just going to give you one big indecipherable string. cfscript function buildmenu(currentid,depth){ var i=0; for(i=1; i lte parentitemid.menuqry.recorcount; i=i+1){ if(variables.inst.menuqry.parentitemid[i] eq arguments.currentID) writeoutput(repeatstring(,arguments.depth)variables.menuqry.adcategoryna me[i]br); buildmenu(variables.inst.menuqry.itemid[i],arguments.depth+1); } } buildmenu(10,0) /cfscript !--- these lines dont make sense cfset returnValue=buildmenu(10) cfoutput#returnvalue#/cfoutput --- 3.2) variables.menuqry.adcategoryname This will always give you the first record's categoryname. when doing a for() loop, you _must_ use the counter variables.menuqry.adcategoryname[i] Good luck! -Original Message- From: Stephen Whiteley [mailto:[EMAIL PROTECTED] Sent: 26 October 2005 14:51 To: CF-Talk Subject: Re: Recursion anyone? Kerry I'm trying to get you code to work but will be making a real hash of it, I wonder if you take a look at this, I think getting the query in is the problem. cfquery datasource=#DSN# name=getAllCategories SELECT itemid,parentitemid,adcategoryname FROM tblAdvertTypes /cfquery cfscript variables.inst.menuqry = getAllCategories(); function buildmenu(currentid){ var i=0; for(i=1; i lte parentitemid.menuqry.recorcount; i=i+1){ if(variables.inst.menuqry.parentitemid[i] eq arguments.currentID) writeoutput(variables.menuqry.adcategoryname); buildmenu(variables.inst.menuqry.itemid[i]); } } /cfscript cfset returnValue=buildmenu(10) cfoutput#returnvalue#/cfoutput thanks Steve ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222302 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: Recursion anyone?
11 : for(i=1; i lte parentitemid.menuqry.recordcount; i=i+1){ My original post contains: variables.inst.menuqry.recordcount You changed it to: parentitemid.menuqry.recordcount Change it back. p.s. dude, I dont mind helping with the overall how do i do this, but asking me to debug simple errors in your code is pushing it. -Original Message- From: Stephen Whiteley [mailto:[EMAIL PROTECTED] Sent: 26 October 2005 15:52 To: CF-Talk Subject: Re: Recursion anyone? Thanks, missed that Still throwing an error though Variable PARENTITEMID is undefined. The error occurred in C:\Inetpub\wwwroot\bigtripper\recurse\testfunction.cfm: line 11 9 : function buildmenu(currentid,depth){ 10 : var i=0; 11 : for(i=1; i lte parentitemid.menuqry.recordcount; i=i+1){ 12 : if(variables.inst.menuqry.parentitemid[i] eq arguments.currentID) The code is below: cfquery datasource=#DSN# name=getAllCategories SELECT itemid,parentitemid,adcategoryname FROM tblAdvertTypes /cfquery cfscript variables.inst.menuqry = getAllCategories; function buildmenu(currentid,depth){ var i=0; for(i=1; i lte parentitemid.menuqry.recordcount; i=i+1){ if(variables.inst.menuqry.parentitemid[i] eq arguments.currentID) writeoutput(repeatstring(,arguments.depth)variables.menuqry.adcategoryna me[i]br); buildmenu(variables.inst.menuqry.itemid[i],arguments.depth+1); } } buildmenu(1,0); /cfscript Thanks Steve ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222329 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: Recursion anyone?
buildmenu(10,0); /cfscript -Original Message- From: Stephen Whiteley [mailto:[EMAIL PROTECTED] Sent: 26 October 2005 15:30 To: CF-Talk Subject: Re: Recursion anyone? Thanks Kerry I'm starting to understand, got no experience of cfscript but it seems a lot like actionscript. Unfortunately I've tried to run the code and I'm getting the following error. Context validation error for tag cfscript. The start tag must have a matching end tag. An explicit end tag can be provided by adding /cfscript. If the body of the tag is empty you can use the shortcut cfscript .../. This is the exact code cfquery datasource=#DSN# name=getAllCategories SELECT itemid,parentitemid,adcategoryname FROM tblAdvertTypes /cfquery cfscript variables.inst.menuqry = getAllCategories; function buildmenu(currentid,depth){ var i=0; for(i=1; i lte parentitemid.menuqry.recorcount; i=i+1){ if(variables.inst.menuqry.parentitemid[i] eq arguments.currentID) writeoutput(repeatstring(,arguments.depth)variables.menuqry.adcategoryna me[i]br); buildmenu(variables.inst.menuqry.itemid[i],arguments.depth+1); } } buildmenu(10,0) /cfscript Steve ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222342 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: ColdFusion Bug :- functions return additional spaces(!)
might i suggest output=false? cffunction name=spaceTest output=false -Original Message- From: Justin D. Scott [mailto:[EMAIL PROTECTED] Sent: 26 October 2005 16:29 To: CF-Talk Subject: RE: ColdFusion Bug :- functions return additional spaces(!) When a function is called and the result outputted directly, an extra space is prepended! It looks like the space isn't being prepended to the return value, but ColdFusion is outputting whitespace from within the CFFUNCTION tag when it is called. Even more interesting, it's only outputting whitespace AFTER the last CFARGUMENT tag. So if you put a CFSILENT within the CFFUNCTION immediately after the last CFARGUMENT tag, it will suppress the whitespace. Close the CFSILENT right after the CFRETURN is called. This appears to be a viable workaround. Plug this into your previous example... cffunction name=spaceTest cfargument name=s type=stringcfsilent cfreturn -NO MORE SPACE HERE /cfsilent /cffunction Tested in CF 7. -Justin Scott ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222345 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: Recursion anyone?
Just had a read of the code, it does 2 queries for every parent in the database? Did I read that correctly? -Original Message- From: Emmet McGovern [mailto:[EMAIL PROTECTED] Sent: 26 October 2005 15:49 To: CF-Talk Subject: RE: Recursion anyone? Here's a use of treeview.nets treeview with recursion. http://fullcitymedia.com/apps/treeview You can download the code here. http://fullcitymedia.com/apps/treeview/treeview.zip Take a look, might be similar to what you're looking for. Emmet -Original Message- From: Stephen Whiteley [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 26, 2005 10:30 AM To: CF-Talk Subject: Re: Recursion anyone? Thanks Kerry I'm starting to understand, got no experience of cfscript but it seems a lot like actionscript. Unfortunately I've tried to run the code and I'm getting the following error. Context validation error for tag cfscript. The start tag must have a matching end tag. An explicit end tag can be provided by adding /cfscript. If the body of the tag is empty you can use the shortcut cfscript .../. This is the exact code cfquery datasource=#DSN# name=getAllCategories SELECT itemid,parentitemid,adcategoryname FROM tblAdvertTypes /cfquery cfscript variables.inst.menuqry = getAllCategories; function buildmenu(currentid,depth){ var i=0; for(i=1; i lte parentitemid.menuqry.recorcount; i=i+1){ if(variables.inst.menuqry.parentitemid[i] eq arguments.currentID) writeoutput(repeatstring(,arguments.depth)variables.menuqry.adcategoryna me[i]br); buildmenu(variables.inst.menuqry.itemid[i],arguments.depth+1); } } buildmenu(10,0) /cfscript Steve ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222355 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: Recursion anyone?
make that 1 query for every parent, + 1 query for each child of each parent. -Original Message- From: Emmet McGovern [mailto:[EMAIL PROTECTED] Sent: 26 October 2005 15:49 To: CF-Talk Subject: RE: Recursion anyone? Here's a use of treeview.nets treeview with recursion. http://fullcitymedia.com/apps/treeview You can download the code here. http://fullcitymedia.com/apps/treeview/treeview.zip Take a look, might be similar to what you're looking for. Emmet -Original Message- From: Stephen Whiteley [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 26, 2005 10:30 AM To: CF-Talk Subject: Re: Recursion anyone? Thanks Kerry I'm starting to understand, got no experience of cfscript but it seems a lot like actionscript. Unfortunately I've tried to run the code and I'm getting the following error. Context validation error for tag cfscript. The start tag must have a matching end tag. An explicit end tag can be provided by adding /cfscript. If the body of the tag is empty you can use the shortcut cfscript .../. This is the exact code cfquery datasource=#DSN# name=getAllCategories SELECT itemid,parentitemid,adcategoryname FROM tblAdvertTypes /cfquery cfscript variables.inst.menuqry = getAllCategories; function buildmenu(currentid,depth){ var i=0; for(i=1; i lte parentitemid.menuqry.recorcount; i=i+1){ if(variables.inst.menuqry.parentitemid[i] eq arguments.currentID) writeoutput(repeatstring(,arguments.depth)variables.menuqry.adcategoryna me[i]br); buildmenu(variables.inst.menuqry.itemid[i],arguments.depth+1); } } buildmenu(10,0) /cfscript Steve ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222357 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: stop: SHOUTING
what about comparing number of uppercase characters to number of lowercase? cfscript str=i HAVE MY CAPS LOCK ON BY MISTAKE!; str=rereplace(str,[^a-zA-Z],,ALL); ucasecount = len(rereplace(str,[a-z],,ALL)); lcasecount = len(rereplace(str,[A-Z],,ALL)); if(ucasecount gt lcasecount){ writeoutput(More uppercase (ucasecount) than lowercase (lcasecount) characters found. you might be SHOUTING.); } /cfscript -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: 24 October 2005 19:12 To: CF-Talk Subject: Re: stop: SHOUTING cfset theWord = form.UserInput / cfif compare(form.UserInput, ucase(form.UserInput)) EQ 0 -- word is all caps might be able to build on that? On 10/24/05, Adkins, Randy [EMAIL PROTECTED] wrote: There maybe another way but you could always check the ASCII values. Lowercase and UPPERCASE have different values. However checking this for each letter in a TEXTAREA is quite a bit. Sure there is another way.. Hopefully someone has an easy answer. -Original Message- From: Saturday (Stuart Kidd) [mailto:[EMAIL PROTECTED] Sent: Monday, October 24, 2005 2:03 PM To: CF-Talk Subject: stop: SHOUTING Hi guys, Just wondering if anyone knows a good way to recognise when all the characters are capitalised? Some users love putting text in CAPS and it just looks awful when it's displayed on screen. Any help I'd be grateful. Thanks, Saturday ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222106 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: stop: SHOUTING
duh, what a backward way of doing it i just posted! better way: cfscript str=i HAVE MY CAPS LOCK ON BY MISTAKE!; ucasecount = len(rereplace(str,[^A-Z],,ALL)); lcasecount = len(rereplace(str,[^a-z],,ALL)); if(ucasecount gt lcasecount){ writeoutput(More uppercase (ucasecount) than lowercase (lcasecount) characters found. you might be SHOUTING.); } /cfscript -Original Message- From: Kerry [mailto:[EMAIL PROTECTED] Sent: 24 October 2005 19:19 To: CF-Talk Subject: RE: stop: SHOUTING what about comparing number of uppercase characters to number of lowercase? cfscript str=i HAVE MY CAPS LOCK ON BY MISTAKE!; str=rereplace(str,[^a-zA-Z],,ALL); ucasecount = len(rereplace(str,[a-z],,ALL)); lcasecount = len(rereplace(str,[A-Z],,ALL)); if(ucasecount gt lcasecount){ writeoutput(More uppercase (ucasecount) than lowercase (lcasecount) characters found. you might be SHOUTING.); } /cfscript -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: 24 October 2005 19:12 To: CF-Talk Subject: Re: stop: SHOUTING cfset theWord = form.UserInput / cfif compare(form.UserInput, ucase(form.UserInput)) EQ 0 -- word is all caps might be able to build on that? On 10/24/05, Adkins, Randy [EMAIL PROTECTED] wrote: There maybe another way but you could always check the ASCII values. Lowercase and UPPERCASE have different values. However checking this for each letter in a TEXTAREA is quite a bit. Sure there is another way.. Hopefully someone has an easy answer. -Original Message- From: Saturday (Stuart Kidd) [mailto:[EMAIL PROTECTED] Sent: Monday, October 24, 2005 2:03 PM To: CF-Talk Subject: stop: SHOUTING Hi guys, Just wondering if anyone knows a good way to recognise when all the characters are capitalised? Some users love putting text in CAPS and it just looks awful when it's displayed on screen. Any help I'd be grateful. Thanks, Saturday ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222108 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: WHAT'S WRONG WITH THIS QUERY?
I think the syntax is along the lines of UPDATEtblA SET tblA.something = tblB.something FROM tblB WHERE (tblA.something = tblB.something) -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: 20 October 2005 14:17 To: CF-Talk Subject: RE: WHAT'S WRONG WITH THIS QUERY? I was always under the impression that you couldn't join tables in anything other than a SELECT query. !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Nomad [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 19, 2005 6:04 PM To: CF-Talk Subject: WHAT'S WRONG WITH THIS QUERY? Hello, This query works fine with Access. With SQL server it creates an error. Here's the query: UPDATE NewProduct INNER JOIN OldProduct ON NewProduct.dealerpartno = OldProduct.dealerpartno SET NewProduct.details = OldProduct.details Much appreciate any help in debuging. Thanks in advance. Ben ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221631 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: more coldfusion 7.01 problems, Macromedia folks please read! I just want to cry
Anthony: One of our servers started to do this, ran fine for months, then recently it started to just stop responding, even though memory and cpu look fine. I dont know if google have modified their bot recently, but it seems that google was opening a new session for every page hit, as soon as it hit around 800 sessions, the server just stopped responding. Anyway, to fix I put the below code in my global request end include, but since you're on MX7 you have onRequestEnd.cfm? cfif findnocase(googlebot,cgi.HTTP_USER_AGENT) and isdefined(session) cftry cfset structclear(session) cfcatch /cfcatch /cftry /cfif Now google sometimes pushes the concurrent sessions to well over 1000, but the server keeps on responding no problem. Anyway, that might not be your problem, but its worth checking the server logs to see if google is in any way connected. Mark: 150Mb is lean? I have several 6.1 servers currently running at 80-160Mb JVM usage, default JVM settings. -Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: 20 October 2005 18:12 To: CF-Talk Subject: RE: more coldfusion 7.01 problems, Macromedia folks please read! I just want to cry Jillian, What are your JVM settings. JRUN is only taking 150 megs of Memory - seems pretty lean to me. Can you post the contents of your cfusionmx7/runtime/bin/jvm.config file? It might be helpful. -Mark -Original Message- From: Jillian Koskie [mailto:[EMAIL PROTECTED] Sent: Thursday, October 20, 2005 11:52 AM To: CF-Talk Subject: RE: more coldfusion 7.01 problems, Macromedia folks please read! I just want to cry Anthony, I wish I could tell you how to fix your problem, but I thought I might share some thoughts on where I would start were it me. 1. Start new CF log files so that you know which error messages are really current. 2. Have you checked your IIS logs? Is anything unusual happening at the time the server crashes? I've seen instances where CF has crashed because my server was taking a LOT of traffic from a DOS attack that had nothing to do with CF. Where is your traffic coming from? Is it primarily from one location? What pages are they hitting? This should tell you whether it is a particular script / function that might be causing your problem. 3. Has the server received any attention aside from CF? I had a Windows 2003 AS go down a few days ago because of one of the MS patches --sometimes these outside things can seem to be CF, but aren't. Barring that, I would look at turning all of the sites off in IIS --and run the server with no traffic--. Once you determine whether the server can run without any traffic and stay stable, turn the sites back on one by one and see if any of them bring the server down. If it is only one site, bring aspects of the site back piece at a time. I hope that helps. -- Jillian -Original Message- From: Anthony Prato [mailto:[EMAIL PROTECTED] Sent: Thursday, October 20, 2005 10:30 AM To: CF-Talk Subject: more coldfusion 7.01 problems, Macromedia folks please read! I just want to cry Its not a good morning when you come in and your production CF server is not taking requests again. Its even worse when you can't post to the macromedia CF forums because you get a 404 error on submit. :( GRR well its pretty close to what I posted here yesterday, but I'll give it another go since I don't know what else to do. Here's what i tried to post to the forum: Mostly a classic ASP environment, IIS W2K. I convinced them to buy CFMX7. (standard) It's been in production for a few months now. Tuesday Night I upgraded to 7.01. The next day the server stopped taking requests around noon. The jrun process was idle, taking only 150mb of memory. (it averages much higher than that when in use) A suggestion was given to check the install log and I noticed there was a problem upgrading the jrun connnector. That made sense since it didn't seam like Jrun was doing anything. I found a post on the forum here about what version the dll should be after the patch. Mine didn't match and I followed the directions provided to upgrade the connector. Bounced both CF and IIS and everything worked fine again. But now, this morning I came in to find the same problem, jrun idle, only CF not responding to the requests... I bounced the cf server and everything started working again, jrun started taking its normal amount of memory. Before restarting (and after) I noticed another problem. I can't load the CF information into performance monitor. The event viewer says: [Q]The data buffer created for the ColdFusion MX 7 Application Server service in the C:\WINNT\system32\cfperfmon_mx.dll library is not aligned on an 8-byte boundary. This may cause problems for applications that are trying to read the performance data buffer. Contact the manufacturer of this library or service to have this problem corrected or to get a newer version of
RE: cfc name introspection
er, something along the lines of: function getMyName(){ if(not structkeyexists(variables.inst,myname)){ variables.inst.myname = getMetaData(this).name; } return variables.inst.myname; } -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: 20 October 2005 18:22 To: CF-Talk Subject: cfc name introspection When dumping the THIS scope within a CFC, it will show the name of the CFC, or at least the full path to it which can be converted to the name. I'm playing with some auto caching techniques and would like for the caching method to know the cfc name automatically without having to pass it in or setting it when the cfc is instantiated. Is there a way to get the CFC name from the THIS or VARIABLES scopes? ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221706 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: A timeout alert
Sounds like a job for javascript or if you need it to work 100% of the time, when you load the form, encrypt the current time, and place a hidden field containing this value. when the form is posted, decrypt the value and compare it to the current time. if the timeout has been exceeded, give them the message, a link back to the home page, and put a meta refresh header in. -Original Message- From: Matthew Small [mailto:[EMAIL PROTECTED] Sent: 18 October 2005 18:58 To: CF-Talk Subject: RE: A timeout alert Sounds like a job for javascript. Matthew Small -Original Message- From: Ken [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 18, 2005 1:55 PM To: CF-Talk Subject: A timeout alert Hi. I am working on a forum application. There is a fixed time to respond to each posting. I want the user responding to a posting to get an alert, even if he is typing at the last minute, saying: Sorry, this posting has reached its expiration time, you are being taken to the home page now. There's a db field that holds the expiration time for each posting. That's what we will compare the current time to. Or maybe start a timer as soon as the user comes to the page, and display an alert at the end of the timer. Any ideas how to do this in CF? Code examples will help. Thanks, Ken ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221358 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: security suggestions?
what would you recommend to do this the Hash function? The hash function is efficient, but I could dehash most passwords in a couple of minutes, so I would go for some kind of salted hash / key based encryption. how do you match up the password the user enters when logging in to the encrypted version of the password stored in the database You encrypt what they entered in the form using the same algorithm, then compare that encrypted string to the encrypted string in the database. -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED] Sent: 14 October 2005 09:23 To: CF-Talk Subject: RE: security suggestions? Hi Just to come back to a few of your security points for some more information please. ---QUOTE--- You might want to encrypt the information on the database... but this is a little overkill-ish. However if you can't secure the database as much as you'd like it can be a good measure. -- Encrypt everything going into the database. --- Say for example you were going to encrypt the users password that is stored in the database, what would you recommend to do this the Hash function? If so how do you match up the password the user enters when logging in to the encrypted version of the password stored in the database? QUOTE--- Use strong passwords for all users on both systems and any applications, such as CF Admin. Use a strong password generator for this. Do you know for any good examples of a strong password generator ? ---QUOTE--- convert it to a secure (encrypted) email and send it directly the loan officer? What would you use to secure the encrypted e-mail PGP or certain code in Coldfusion? If it is PGP are any alterations needed on the Coldfusion site to convert it into encrypted format? Finally is there a script that stops the user clicking on the back button in their browser window which would stop them viewing any sensitive data, or would you recommend just turning off the browsers standard buttons i.e. back, next, refresh etc and/or a script that stops users bookmarking certain pages in their browsers ? Ian ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220998 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: security suggestions?
how would the hashed value in the db be converted back to their original password of 'Test' You dont - you have to send them a new password. -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED] Sent: 14 October 2005 09:59 To: CF-Talk Subject: RE: security suggestions? Sor for example if I used the following when the user registers their details #Hash(form.Password, SHA-512)# to store the hash of the password ( i.e. 'Test.) the user has entered in the form to be stored in the database Then when the user logs in and enters their password of 'Test' using the login check below, it fails to recognize the password? --snippet--- WHERE Password = '#Hash(form.Password, SHA-512)#' /CFQUERY Any ideas on where I am going wrong? Also if I hashed the password in the database, and offered a feature if the user forgets their password and wanted their password e-mailed to their registered e-mail addresss, how would the hashed value in the db be converted back to their original password of 'Test' ? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221001 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: CFCs and cftry/cfcatch
I thought there was a patch for this? http://www.macromedia.com/go/1a9c83c Or are you referring to another bug? -Original Message- From: Rob Richardson [mailto:[EMAIL PROTECTED] Sent: 13 October 2005 15:17 To: CF-Talk Subject: Re: CFCs and cftry/cfcatch Bryan--- I'm coming in on the tail end of this conversation, but noticed in your code sample that you were trying to cfdump the cfcatch structure. I ran into problems with cfdump/cfcatch that was ultimately confirmed by Macromedia to be a bug in CFMX6.1 that isn't corrected by one of their hot fixes and I'm having to hack around since we won't be moving to 7.0 anythime soon. See thread (http://www.houseoffusion.com/cf_lists/messages.cfm/forumid:4/threadid:42124 #217681) for details. I'll update that thread with the response from MM. Good luck with this.--- Rob ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220901 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: dynamic function call puzzle
heres what i do when I need to dynamically call functions - make all your beans inherit this: cffunction name=runFunction cfargument name=functionname type=string required=yes cfargument name=args type=struct required=no default=#structnew()# cfset var retval = cfinvoke component=#this# method=#arguments.functionname# argumentCollection=#arguments.args# returnvariable=retval cfreturn retval /cffunction Then you can: o.runfunction(setcolArray[x],q[colArray[x]]); -Original Message- From: Paul [mailto:[EMAIL PROTECTED] Sent: 12 October 2005 16:47 To: CF-Talk Subject: dynamic function call puzzle My read function returns, predictably, a query object with a single row containing all the columns needed to populate a bean. It bothers me that to use the bean I then have to write a code block full of set statements - mybean.setVariable(queryname.column) - for every property of the bean. So I'm trying to write a function that takes the result of my read function and automatically sets the bean values. I've been able to populate a struct dynamically, but not without using evaluate(), and I can't call my bean's set functions at all. How can I improve on the following code? cfquery name=q datasource=#getDSN()# select * from TEMPLATES where TEMPLATE_ID = cfqueryparam value=2 cfsqltype=cf_sql_integer /cfquery cfset o=createObject(component,com.redweb.Template).init() cfoutput query=q cfscript colArray=listToArray(q.columnlist); //test struct to see if I can get that far. s=structNew(); for (x=1; x LTE arrayLen(colArray); x=x+1) { //this test is ugly but it works s.#colArray[x]#=evaluate(colArray[x]); //this is not valid but it is essentially what I want to do... o.set#colArray[x]#(evaluate(colArray[x])); } /cfscript /cfoutput cfdump var=#s# cfdump var=#o.getSnapshot()# ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220813 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: dynamic function call puzzle
oops, with that flavour of the function you will need: args = structnew(); args[colArray[x]] = q[colArray[x]][q.currentrow]; o.runfunction(setcolArray[x],args); -Original Message- From: Kerry [mailto:[EMAIL PROTECTED] Sent: 12 October 2005 16:57 To: CF-Talk Subject: RE: dynamic function call puzzle heres what i do when I need to dynamically call functions - make all your beans inherit this: cffunction name=runFunction cfargument name=functionname type=string required=yes cfargument name=args type=struct required=no default=#structnew()# cfset var retval = cfinvoke component=#this# method=#arguments.functionname# argumentCollection=#arguments.args# returnvariable=retval cfreturn retval /cffunction Then you can: -Original Message- From: Paul [mailto:[EMAIL PROTECTED] Sent: 12 October 2005 16:47 To: CF-Talk Subject: dynamic function call puzzle My read function returns, predictably, a query object with a single row containing all the columns needed to populate a bean. It bothers me that to use the bean I then have to write a code block full of set statements - mybean.setVariable(queryname.column) - for every property of the bean. So I'm trying to write a function that takes the result of my read function and automatically sets the bean values. I've been able to populate a struct dynamically, but not without using evaluate(), and I can't call my bean's set functions at all. How can I improve on the following code? cfquery name=q datasource=#getDSN()# select * from TEMPLATES where TEMPLATE_ID = cfqueryparam value=2 cfsqltype=cf_sql_integer /cfquery cfset o=createObject(component,com.redweb.Template).init() cfoutput query=q cfscript colArray=listToArray(q.columnlist); //test struct to see if I can get that far. s=structNew(); for (x=1; x LTE arrayLen(colArray); x=x+1) { //this test is ugly but it works s.#colArray[x]#=evaluate(colArray[x]); //this is not valid but it is essentially what I want to do... o.set#colArray[x]#(evaluate(colArray[x])); } /cfscript /cfoutput cfdump var=#s# cfdump var=#o.getSnapshot()# ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220814 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: dynamic function call puzzle
probly because your sets dont return anything? 1) take the return out of the runfunction: cffunction name=runFunction cfargument name=functionname type=string required=yes cfargument name=args type=struct required=no default=#structnew()# cfset var retval = cfinvoke component=#this# method=#arguments.functionname# argumentCollection=#arguments.args# returnvariable=retval /cffunction OR 2) check it exists cffunction name=runFunction cfargument name=functionname type=string required=yes cfargument name=args type=struct required=no default=#structnew()# cfset var retval = structnew() cfinvoke component=#this# method=#arguments.functionname# argumentCollection=#arguments.args# returnvariable=retval.result cfif structkeyexists(retval,result) cfreturn retval /cfif /cffunction -Original Message- From: Paul [mailto:[EMAIL PROTECTED] Sent: 12 October 2005 17:25 To: CF-Talk Subject: RE: dynamic function call puzzle Wow, this is great, really expanding my horizons here... So in the inherited function CF throws this error: Variable RETVAL is undefined. I do have the following as you sent; CF refers to the CFINVOKE line number in the error message. Maybe I need a deeper understanding to figure out what I may have done differently to cause the error... (Something about my Setters perhaps?) cfset var retval = cfinvoke component=#this# method=#arguments.functionname# argumentCollection=#arguments.args# returnvariable=retval cfreturn retval -Original Message- From: Kerry [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 12, 2005 10:04 AM To: CF-Talk Subject: RE: dynamic function call puzzle oops, with that flavour of the function you will need: args = structnew(); args[colArray[x]] = q[colArray[x]][q.currentrow]; o.runfunction(setcolArray[x],args); ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220818 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: dynamic function call puzzle
OR 3) Customise it entirely for your beans, e.g. cffunction name=runSetter cfargument name=property type=string required=yes cfargument name=value type=string required=no default= cfinvoke component=#this# method=SET#arguments.property# value=#arguments.value# /cffunction -Original Message- From: Paul [mailto:[EMAIL PROTECTED] Sent: 12 October 2005 17:25 To: CF-Talk Subject: RE: dynamic function call puzzle Wow, this is great, really expanding my horizons here... So in the inherited function CF throws this error: Variable RETVAL is undefined. I do have the following as you sent; CF refers to the CFINVOKE line number in the error message. Maybe I need a deeper understanding to figure out what I may have done differently to cause the error... (Something about my Setters perhaps?) cfset var retval = cfinvoke component=#this# method=#arguments.functionname# argumentCollection=#arguments.args# returnvariable=retval cfreturn retval -Original Message- From: Kerry [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 12, 2005 10:04 AM To: CF-Talk Subject: RE: dynamic function call puzzle oops, with that flavour of the function you will need: args = structnew(); args[colArray[x]] = q[colArray[x]][q.currentrow]; o.runfunction(setcolArray[x],args); ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220819 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: Secure Admin Areas
quick glance, I can see this wrong with it: script alert(You must login to access this area!); self.location=login.cfm; /script oooh, javascript, REAL secure, nobody can get past that. replace with something like: You must login to access this area! cflocation url=login.cfm cfabort !--- abort not really needed, just to be sure --- -Original Message- From: Jason Manaigre [mailto:[EMAIL PROTECTED] Sent: 12 October 2005 17:58 To: CF-Talk Subject: Secure Admin Areas Hi all, a few quick questions, building a CMS (or rather learning as I go) and was going to use the following http://tutorial8.easycfm.com/ to build my Admin area, will this be enough security? What else can be done? Is there a better tut out there? This is just for my site, nothing mission critical. Thanks everyone, take it easy. Big Jay ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220823 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: Secure Admin Areas
also, you would want to use cfqueryparam in the query, not dump the form values straight to the database. -Original Message- From: Jason Manaigre [mailto:[EMAIL PROTECTED] Sent: 12 October 2005 17:58 To: CF-Talk Subject: Secure Admin Areas Hi all, a few quick questions, building a CMS (or rather learning as I go) and was going to use the following http://tutorial8.easycfm.com/ to build my Admin area, will this be enough security? What else can be done? Is there a better tut out there? This is just for my site, nothing mission critical. Thanks everyone, take it easy. Big Jay ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220824 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: Secure Admin Areas
and this line: cfif qVerify.RecordCount this only verifies that one or more users were found, assuming you have unique usernames, it should be: cfif qVerify.RecordCount eq 1 not sure if there is a better tutorial out there, but i hope so, there seems to be a few issues with this one. -Original Message- From: Jason Manaigre [mailto:[EMAIL PROTECTED] Sent: 12 October 2005 17:58 To: CF-Talk Subject: Secure Admin Areas Hi all, a few quick questions, building a CMS (or rather learning as I go) and was going to use the following http://tutorial8.easycfm.com/ to build my Admin area, will this be enough security? What else can be done? Is there a better tut out there? This is just for my site, nothing mission critical. Thanks everyone, take it easy. Big Jay ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220825 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: CFCs and cftry/cfcatch
try catch definitely works in a cfc. can you post your code? -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: 12 October 2005 18:37 To: CF-Talk Subject: CFCs and cftry/cfcatch Hey All, I'm having some issues trying to get a try/catch block to work correctly (i.e. doesn't catch a dang thing) in a method in one of my CFCs. I haven't tried this before...are there any gotchas? can it be done (don't see why not)? TIA Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220830 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: Secure Admin Areas
Sorry, in future I will just save up my posts and send a daily digest. Might risk getting body to long though... -Original Message- From: Kevin Aebig [mailto:[EMAIL PROTECTED] Sent: 12 October 2005 18:32 To: CF-Talk Subject: RE: Secure Admin Areas And you might want to think about putting all these replies into one email... =] !K -Original Message- From: Kerry [mailto:[EMAIL PROTECTED] Sent: October 12, 2005 11:16 AM To: CF-Talk Subject: RE: Secure Admin Areas and this line: cfif qVerify.RecordCount this only verifies that one or more users were found, assuming you have unique usernames, it should be: cfif qVerify.RecordCount eq 1 not sure if there is a better tutorial out there, but i hope so, there seems to be a few issues with this one. -Original Message- From: Jason Manaigre [mailto:[EMAIL PROTECTED] Sent: 12 October 2005 17:58 To: CF-Talk Subject: Secure Admin Areas Hi all, a few quick questions, building a CMS (or rather learning as I go) and was going to use the following http://tutorial8.easycfm.com/ to build my Admin area, will this be enough security? What else can be done? Is there a better tut out there? This is just for my site, nothing mission critical. Thanks everyone, take it easy. Big Jay ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220834 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: resolve a hostname
does cgi.remote_addr not give you an ip on your system? -Original Message- From: Orlini, Robert [mailto:[EMAIL PROTECTED] Sent: 11 October 2005 15:20 To: CF-Talk Subject: resolve a hostname Hello, Is there anyway to create a CF script to resolve a user or hostname into an IP address using: #CGI.REMOTE_ADDR# ? Robert HWW -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.11.14/128 - Release Date: 10/10/2005 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220685 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: Rounding...
cffunction name=roundTo cfargument name=numToRound type=numeric required=yes cfargument name=roundToNearest type=numeric default=5 cfscript var retVal = 0; retVal = round(arguments.numToRound / arguments.roundToNearest) * arguments.roundToNearest; /cfscript cfreturn retVal /cffunction -Original Message- From: J W [mailto:[EMAIL PROTECTED] Sent: 11 October 2005 15:24 To: CF-Talk Subject: Rounding... I have a whole number rounding problem that I am not sure how solve most efficiently. I'd like to take any number and round to the nearest whole 10. For example: 31 would equal 40 27 would equal 30 155 would equal 160 Any help would be appreciated... Thanks! Jeff ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220689 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: Rounding...
sending again as original post has not arrived after 30 mins cffunction name=roundTo cfargument name=numToRound type=numeric required=yes cfargument name=roundToNearest type=numeric default=10 cfscript var retVal = 0; retVal = round(arguments.numToRound / arguments.roundToNearest) * arguments.roundToNearest; /cfscript cfreturn retVal /cffunction -Original Message- From: J W [mailto:[EMAIL PROTECTED] Sent: 11 October 2005 15:24 To: CF-Talk Subject: Rounding... I have a whole number rounding problem that I am not sure how solve most efficiently. I'd like to take any number and round to the nearest whole 10. For example: 31 would equal 40 27 would equal 30 155 would equal 160 Any help would be appreciated... Thanks! Jeff ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220694 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: Rounding...
http://www.cflib.org/udf.cfm?ID=613 20 lines of code for a 1 line mathematical equation? -Original Message- From: Dave Carabetta [mailto:[EMAIL PROTECTED] Sent: 11 October 2005 15:57 To: CF-Talk Subject: Re: Rounding... On 10/11/05, J W [EMAIL PROTECTED] wrote: I have a whole number rounding problem that I am not sure how solve most efficiently. I'd like to take any number and round to the nearest whole 10. For example: 31 would equal 40 27 would equal 30 155 would equal 160 http://www.cflib.org/udf.cfm?ID=613 Regards, Dave. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220709 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: #CGI.SERVER_NAME# to display IP
what remote server? CGI.REMOTE_ADDR gives you the IP of the client, and _you_ are the server? -Original Message- From: Paul Stewart [mailto:[EMAIL PROTECTED] Sent: 10 October 2005 09:32 To: CF-Talk Subject: Re: #CGI.SERVER_NAME# to display IP How do you get the name of the remote server, rather than just the IP addr? When i used PHP to log visits it gave you this? Is there any way to do it in CF/Java? Paul Stewart Site Developer [EMAIL PROTECTED] www.whichfranchise.com - Original Message - From: Larry Juncker [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, October 06, 2005 12:11 PM Subject: RE: #CGI.SERVER_NAME# to display IP No If you want to see the IP Address you type in #CGI.REMOTE_ADDR# The following webpage will give you a list of the Cold Fusion Variables http://livedocs.macromedia.com/coldfusion/6/CFML_Reference/Expressions5.htm Hope this helps. Larry Juncker President CEO ALJ Computer Services, LLC 1445 So 27th Street Fort Dodge, IA 50501 Office 515-576-0885 Fax 515-576-8510 Cell 515-571-1826 [EMAIL PROTECTED] -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 05, 2005 6:21 PM To: CF-Talk Subject: #CGI.SERVER_NAME# to display IP Is there any way to get #CGI.SERVER_NAME# to display the IP address instead of the name (www.mysite.com) -- --- Les Mizzell ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220516 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: #CGI.SERVER_NAME# to display IP
sorry, still dont really understand what you are trying to acheive. What is confusing me is that a visitor to your website is not a server. e.g. you log on to your ISP and they give you an IP, then you visit a website which tracks that IP, and then the site admin does a look up on it, and they will get your ISP's domain. Is that what you want? -Original Message- From: Paul Stewart [mailto:[EMAIL PROTECTED] Sent: 10 October 2005 11:59 To: CF-Talk Subject: Re: #CGI.SERVER_NAME# to display IP yeah will see that remote_ip addr PHP has a function that converts that to a server name i.e. googlebot(whatever). Does coldfusion / java have a similar function / method? is that ok big man? Paul Stewart Site Developer [EMAIL PROTECTED] www.whichfranchise.com - Original Message - From: Kerry [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, October 10, 2005 10:03 AM Subject: RE: #CGI.SERVER_NAME# to display IP what remote server? CGI.REMOTE_ADDR gives you the IP of the client, and _you_ are the server? -Original Message- From: Paul Stewart [mailto:[EMAIL PROTECTED] Sent: 10 October 2005 09:32 To: CF-Talk Subject: Re: #CGI.SERVER_NAME# to display IP How do you get the name of the remote server, rather than just the IP addr? When i used PHP to log visits it gave you this? Is there any way to do it in CF/Java? Paul Stewart Site Developer [EMAIL PROTECTED] www.whichfranchise.com - Original Message - From: Larry Juncker [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, October 06, 2005 12:11 PM Subject: RE: #CGI.SERVER_NAME# to display IP No If you want to see the IP Address you type in #CGI.REMOTE_ADDR# The following webpage will give you a list of the Cold Fusion Variables http://livedocs.macromedia.com/coldfusion/6/CFML_Reference/Expressions5.htm Hope this helps. Larry Juncker President CEO ALJ Computer Services, LLC 1445 So 27th Street Fort Dodge, IA 50501 Office 515-576-0885 Fax 515-576-8510 Cell 515-571-1826 [EMAIL PROTECTED] -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 05, 2005 6:21 PM To: CF-Talk Subject: #CGI.SERVER_NAME# to display IP Is there any way to get #CGI.SERVER_NAME# to display the IP address instead of the name (www.mysite.com) -- --- Les Mizzell ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220522 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: #CGI.SERVER_NAME# to display IP
sorry, I still dont really understand what you are trying to acheive. What is confusing me is that a visitor to your website is not a server. e.g. you log on to your ISP and they give you an IP, then you visit a website which tracks that IP, and then the site admin does a look up on it, and they will get your ISP's domain. Is that what you want? -Original Message- From: Paul Stewart [mailto:[EMAIL PROTECTED] Sent: 10 October 2005 11:59 To: CF-Talk Subject: Re: #CGI.SERVER_NAME# to display IP yeah will see that remote_ip addr PHP has a function that converts that to a server name i.e. googlebot(whatever). Does coldfusion / java have a similar function / method? is that ok big man? Paul Stewart Site Developer [EMAIL PROTECTED] www.whichfranchise.com ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220523 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: #CGI.SERVER_NAME# to display IP
If the ISP is what you want to get, then this should do it. cfscript iaclass=CreateObject(java, java.net.InetAddress); addresses = iaclass.getAllByName(cgi.REMOTE_ADDR); for (i=1; i lte arraylen(addresses); i=i+1) { hostname = addresses[i].getHostName(); writeoutput( hostname br); } /cfscript -Original Message- From: Paul Stewart [mailto:[EMAIL PROTECTED] Sent: 10 October 2005 11:59 To: CF-Talk Subject: Re: #CGI.SERVER_NAME# to display IP yeah will see that remote_ip addr PHP has a function that converts that to a server name i.e. googlebot(whatever). Does coldfusion / java have a similar function / method? is that ok big man? Paul Stewart Site Developer [EMAIL PROTECTED] www.whichfranchise.com - Original Message - From: Kerry [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, October 10, 2005 10:03 AM Subject: RE: #CGI.SERVER_NAME# to display IP what remote server? CGI.REMOTE_ADDR gives you the IP of the client, and _you_ are the server? -Original Message- From: Paul Stewart [mailto:[EMAIL PROTECTED] Sent: 10 October 2005 09:32 To: CF-Talk Subject: Re: #CGI.SERVER_NAME# to display IP How do you get the name of the remote server, rather than just the IP addr? When i used PHP to log visits it gave you this? Is there any way to do it in CF/Java? Paul Stewart Site Developer [EMAIL PROTECTED] www.whichfranchise.com - Original Message - From: Larry Juncker [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, October 06, 2005 12:11 PM Subject: RE: #CGI.SERVER_NAME# to display IP No If you want to see the IP Address you type in #CGI.REMOTE_ADDR# The following webpage will give you a list of the Cold Fusion Variables http://livedocs.macromedia.com/coldfusion/6/CFML_Reference/Expressions5.htm Hope this helps. Larry Juncker President CEO ALJ Computer Services, LLC 1445 So 27th Street Fort Dodge, IA 50501 Office 515-576-0885 Fax 515-576-8510 Cell 515-571-1826 [EMAIL PROTECTED] -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 05, 2005 6:21 PM To: CF-Talk Subject: #CGI.SERVER_NAME# to display IP Is there any way to get #CGI.SERVER_NAME# to display the IP address instead of the name (www.mysite.com) -- --- Les Mizzell ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220524 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: #CGI.SERVER_NAME# to display IP
google recommends that you use the user agent property to detect their bots... http://www.google.com/webmasters/bot.html cgi.HTTP_USER_AGENT -Original Message- From: Paul Stewart [mailto:[EMAIL PROTECTED] Sent: 10 October 2005 13:31 To: CF-Talk Subject: Re: #CGI.SERVER_NAME# to display IP great thanks, and not everybody uses an isp for their net connetion. i.e. search engine robots. Paul Stewart Site Developer [EMAIL PROTECTED] www.whichfranchise.com - Original Message - From: Kerry [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, October 10, 2005 1:10 PM Subject: RE: #CGI.SERVER_NAME# to display IP If the ISP is what you want to get, then this should do it. cfscript iaclass=CreateObject(java, java.net.InetAddress); addresses = iaclass.getAllByName(cgi.REMOTE_ADDR); for (i=1; i lte arraylen(addresses); i=i+1) { hostname = addresses[i].getHostName(); writeoutput( hostname br); } /cfscript -Original Message- From: Paul Stewart [mailto:[EMAIL PROTECTED] Sent: 10 October 2005 11:59 To: CF-Talk Subject: Re: #CGI.SERVER_NAME# to display IP yeah will see that remote_ip addr PHP has a function that converts that to a server name i.e. googlebot(whatever). Does coldfusion / java have a similar function / method? is that ok big man? Paul Stewart Site Developer [EMAIL PROTECTED] www.whichfranchise.com - Original Message - From: Kerry [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, October 10, 2005 10:03 AM Subject: RE: #CGI.SERVER_NAME# to display IP what remote server? CGI.REMOTE_ADDR gives you the IP of the client, and _you_ are the server? -Original Message- From: Paul Stewart [mailto:[EMAIL PROTECTED] Sent: 10 October 2005 09:32 To: CF-Talk Subject: Re: #CGI.SERVER_NAME# to display IP How do you get the name of the remote server, rather than just the IP addr? When i used PHP to log visits it gave you this? Is there any way to do it in CF/Java? Paul Stewart Site Developer [EMAIL PROTECTED] www.whichfranchise.com - Original Message - From: Larry Juncker [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, October 06, 2005 12:11 PM Subject: RE: #CGI.SERVER_NAME# to display IP No If you want to see the IP Address you type in #CGI.REMOTE_ADDR# The following webpage will give you a list of the Cold Fusion Variables http://livedocs.macromedia.com/coldfusion/6/CFML_Reference/Expressions5.htm Hope this helps. Larry Juncker President CEO ALJ Computer Services, LLC 1445 So 27th Street Fort Dodge, IA 50501 Office 515-576-0885 Fax 515-576-8510 Cell 515-571-1826 [EMAIL PROTECTED] -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 05, 2005 6:21 PM To: CF-Talk Subject: #CGI.SERVER_NAME# to display IP Is there any way to get #CGI.SERVER_NAME# to display the IP address instead of the name (www.mysite.com) -- --- Les Mizzell ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220528 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: Idea for better hosting
some semi-ignorant questions from me: Here the really bad sites would hit each server 1/3 as hard What if I uploaded an infinite loop? wouldnt that still kill all three servers in turn? Does anyone know if setting the isolation to high in IIS will have any effect on the performance / memory of CF sites on a shared box? I guess IIS cant control the JVM, so no? -Original Message- From: DRE [mailto:[EMAIL PROTECTED] Sent: 29 September 2005 22:09 To: CF-Talk Subject: Re: Idea for better hosting Emmett, Some simple math where we're adding $ instead of things that arent addeable quantities like Coldfusion + Clustering + Affordable (WTF?). Consider x amount of sites that get y amount of hits and 3 servers to host. If youre a hosting company, you would split them across 3 servers. So, you've got 3 machines, 3 licences of coldfusion, 3 oses. Or, as I was suggesting, you have them all on 3 servers. So, you've got 3 machines, 3 licences of coldfusion, 3 oses and a load balancer. Here the really bad sites would hit each server 1/3 as hard because they are load balanced and you wouldnt get the possibility of randomly getting half of them on one server. So, the jrun error may not appear as often or very much at all and you'd generally have happier customers. I'm thinking that if this company http://powweb.com can do linux hosting like this for less than 8 dollars a month then that load balancer and the extra admin that you consider bizzare are probably quite acceptable costs. DRE On 9/29/05, Emmet McGovern [EMAIL PROTECTED] wrote: I hope I don't offend you but... We were talking about Coldfusion clustering. Take away Coldfusion and you can definitely find clustered hosting. And since were talking shared environments were also talking about affordable hosting. Coldfusion + Clustering + Affordable = Bizarre Dream World. -E -Original Message- From: DRE [mailto:[EMAIL PROTECTED] Sent: Thursday, September 29, 2005 11:01 AM To: CF-Talk Subject: Re: Idea for better hosting thought of this. So I searched for load balanced hosting and found 588000 results. Oops emmett, this bizzare dreamworld seems to occur in your world. ... . DRE On 9/29/05, DRE [EMAIL PROTECTED] wrote: Damn your insulting Emmett, Did you read my initial post? It would be a nice dreamworld if people read carefully. Have a nice day. DRE ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219738 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: SQL row select?
orig. post bounced with body too long, sending again, will probably duplicate Im not a query analyzer expert, and this wasnt a very scientific experiment, but I thought people might find these server trace results interesting. Test1: approx 10,000 row table Testing: Single Sub Select with IN clause SELECT TOP 20 * FROM objproduct WHERE product_ID not in (SELECT TOP 10020 product_id FROM objproduct ORDER BY product_id) ORDER BY product_id Results: Duration: 78 CPU: 78 Reads: 249 Testing: Triple Sub Select SELECT * FROM (SELECT TOP 20 * FROM (SELECT TOP 10020 * FROM objproduct C ORDER BY C.product_id ASC) B ORDER BY B.product_id DESC) A ORDER BY product_id Results: Duration: 175 CPU: 0 Reads: 67 So it would seem that at around 10,000 rows, the IN clause is quicker, but harder work, whereas the triple select is slower, but less work? Test 2: approx 650,000 row table The results seemed to vary more here, so I have put them in as ranges. Testing: Single Sub Select with IN clause SELECT TOP 50 * FROM logs WHERE logid not in (SELECT TOP 60 logid FROM logs ORDER BY logid ORDER BY logid Duration: 7-253 CPU: 7-253 Reads: 206 Testing: Triple Sub Select SELECT * FROM (SELECT TOP 50 * FROM (SELECT TOP 60 * FROM logs C ORDER BY C.logid ASC) B ORDER BY B.logid DESC) A ORDER BY logid Duration: 11 - 251 CPU: 0-16 Reads: 103 As the durations seemed to even out at around these numbers, while the CPU usage of the triple select was consistently very low, and the reads were consistently half that of the IN clause, the only conclusion that I can draw is that with simple sql at least, the triple select is better? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219568 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: checksum?
I use the microsoft one - fciv.exe http://support.microsoft.com/?kbid=841290 -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: 29 September 2005 10:31 To: CF-Talk Subject: Re: ot: checksum? On Wednesday 28 September 2005 19:47, Ryan Guill wrote: what about on win xp? use md5sum. You'll need to install it from Cygwin, of course. -- Tom Chiverton Advanced ColdFusion Programmer ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219572 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: Query with multiple criteria
cfquery name=myQuery Select * From Table Where 1=1 cfif IsDefined(form.lname) and lname like '%#form.lname#%' /cfif cfif IsDefined(form.category) and lname like '%#form.category#%' /cfif cfif IsDefined(form.color) and lname like '%#form.color#%' /cfif /cfquery -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: 29 September 2005 15:42 To: CF-Talk Subject: Query with multiple criteria Here's a problem that I run into a lot and have never come up with a good answer for... When building a search form that allows to search multiple criteria in a table(s) - lets say lname, category, and color for this example - the user can fill in any one of these, or all of them. So, when building the query, I always have trouble figuring out what the first item in the WHERE statement is, because you don't know which field above might or might not be filled in. So, if they fill in just category and color - see the problem? What's best practice for this? cfquery name=myQuery Select * From Table Where ??? cfif IsDefined(form.lname) and lname like '%#form.lname#%' /cfif cfif IsDefined(form.category) and lname like '%#form.category#%' /cfif cfif IsDefined(form.color) and lname like '%#form.color#%' /cfif /cfquery The form I'm working on have close to 30 possible fields, and spans several tables... ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219625 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: SQL row select?
really easy in mysql, still doable in mssql but not as straight forward or efficient as mysql select top 50 * from mytable where id not in (select top #pagesize# * #pagenumber# id from mytable) -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: 28 September 2005 13:54 To: CF-Talk Subject: SQL row select? Ok, I feel like this should be something simple but my brain just isn't working this morning. Besides using CFOUTPUT with the startrow and maxrows attributes, is there a way in my SQL itself to specify that I want it to grab 50 rows starting at the 200th row. I'm trying to make a paged approach to a query that could potentially have about 20,000 records returned. I'd much rather just have MS SQL return 50 rows at a time by telling it which row to start at rather than having it return a 20,000 recordset to CF and then only output 50. I'm hoping this is something easy and my brain just hasn't woken up yet. Any thoughts would be appreciated. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219408 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: Logging users actions - DB or Log4J?
We have an app where we log every user action, it would get to about a million rows in one week, so we log to csv file, and then have a daily schedule which compiles all the raw data into totals - which comes to about 15 rows per day, and a lot less data. Then the reporting app can quickly and easily get totals for a given time period, without trawling through an impossible amount of data. -Original Message- From: Michel Deloux [mailto:[EMAIL PROTECTED] Sent: 20 September 2005 16:58 To: CF-Talk Subject: Logging users actions - DB or Log4J? Hi all what's the best choice to store users actions in a CF application(inserts, updates and deletes)? DB or Log4J could be resolve this? Anyone use log4j? Any approaches? Cheers MD ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218720 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: Replacement for cfdirectory
Just a thought, not at all sure if it would be more performant: why not loop through the db, and copy each file into another directory, then delete or rename the original directory and rename the new directory to the same as the original? This way you could also do the queries in batches e.g. 100 batches of select top 1? -Original Message- From: Victor Moore [mailto:[EMAIL PROTECTED] Sent: 12 September 2005 23:17 To: CF-Talk Subject: Replacement for cfdirectory Is there a more scalable option than cfdirectory? we have to perform some file manipulation (read a directory and delete files that are not in a db). Some directories have a size in excess of 25GB and 1 million files. Cfdirectory dies and takes the server down too (works fine for smaller jobs). Thanks Victor ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218021 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: JPG-scraping... brainfart
cfhttp url=http://www.google.co.uk/intl/en_uk/images/logo.gif; getasbinary=yes/cfhttp cffile action=write file=#getDirectoryfromPath(getCurrentTemplatepath())#test.gif output=#cfhttp.FileContent# img src=test.gif -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: 07 September 2005 17:24 To: CF-Talk Subject: JPG-scraping... brainfart There's got to be a way to do this but its escaping me. If I am given a url to an image, how can I save that image onto my CF server's hard drive for later use? Must I use cfftp? At present I am pretty sure I will only have a url to work with. This is for a public agency that will have permission to do this as part of a paid-for service so I'm not snitching pics of playboy bunnies or somesuch :-) -- --mattRobertson-- Janitor, MSB Web Systems mysecretbase.com http://mysecretbase.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217540 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: Please help correct an assumption regarding Application.cfm
except not compiled every time, just run? unless you use cfadmin to stop cf from saving any classes? -Original Message- From: Ryan Guill [mailto:[EMAIL PROTECTED] Sent: 07 September 2005 17:30 To: CF-Talk Subject: Re: Please help correct an assumption regarding Application.cfm No, my understanding of application.cfm is more like an implicit include on every template that is requested by the browser and runs before anything else. I believe it is compiled and run every time. On 9/7/05, Damien McKenna [EMAIL PROTECTED] wrote: I have an assumption regarding Application.cfm that I'm starting to question. It was my understanding that the Application.cfm file was loaded+compiled the first time when a file in that directory was loaded, e.g. the first time someone loads index.cfm the Application.cfm file for that directory was loaded. After that the file was not loaded+compiled again until it was changed, i.e. a new version was uploaded. Further from that, it was also my understanding that the same was true for all files cfinclude'd from Application.cfm. Are my assumptions correct? The reason I ask is that today one of our sites trapped an error that suggests otherwise. The Application.cfm for all of our sites loads a shared file which sets some common variables - DSN names, common URLs, etc, all of which are stored in the Application scope. The error that was logged said that one of these variables was not set, which does not make sense based on my assumptions above. So any ideas on why this might have happened? Thanks. -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 #include stdjoke.h ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217541 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: Decryption problem.
looks like public private key encryption using a des algorithm. I think cfmx7 supports des, but not sure. You could use java, either compiled or via cfscript. Heres the first thing google gave me: http://www.orlingrabbe.com/des_java.htm -Original Message- From: Picker, Mark [mailto:[EMAIL PROTECTED] Sent: 26 August 2005 08:02 To: CF-Talk Subject: Decryption problem. Hi, This has really been bugging me and I have decided to give up and ask for help. We have an application written in .NET that is used for user management. After various problems (mostly from a lack of understanding in .NET) I decided to rewrite the front end in CF. The front end talks to a web service that is written in .NET The problem I am having is: The web service returns all expected fields, however one of the fields is encrypted and I need to decrypt it. I have the key that was used to encrypt it but can't figure out how to do it in CF. The closest I have gotten to getting it working is the following error: There has been an error while trying to encrypt or decrypt your input string: The input and output encodings are not same I have the .NET code used to decrypt the field, but having trouble working out what exactly it is doing. Private Shared Function Decrypt(ByVal strText As String, ByVal sDecrKey _ As String) As String If strText = Or strText = nbsp; Then Exit Function Dim byKey() As Byte = {} Dim IV() As Byte = {H12, H34, H56, H78, H90, HAB, HCD, HEF} Dim inputByteArray(strText.Length) As Byte Try byKey = System.Text.Encoding.UTF8.GetBytes(Left(sDecrKey, 8)) Dim des As New DESCryptoServiceProvider inputByteArray = Convert.FromBase64String(strText) Dim ms As New MemoryStream Dim cs As New CryptoStream(ms, des.CreateDecryptor(byKey, IV), CryptoStreamMode.Write) cs.Write(inputByteArray, 0, inputByteArray.Length) cs.FlushFinalBlock() Dim encoding As System.Text.Encoding = System.Text.Encoding.UTF8 Return encoding.GetString(ms.ToArray()) Catch ex As Exception 'Return ex.Message Return End Try End Function Is anyone able to point me in the right direction? Regards, Mark Picker ** This message is intended for the addressee named and may contain privileged information or confidential information or both. If you are not the intended recipient please delete it and notify the sender. ** ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216458 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: Need to share encryption between CF and ASP environments
one-way encrypts (hashs) are more secure Not disagreeing, but just so you know, I downloaded a small exe yesterday that cracked an MD5 hash in 3.5 minutes, using my old 2Ghz workstation. -Original Message- From: Fabio Terracini [mailto:[EMAIL PROTECTED] Sent: 23 August 2005 14:45 To: CF-Talk Subject: Re: Need to share encryption between CF and ASP environments Personally, I don't think storing CC numbers are a good idea. You can encrypt/decrypt data in between envoirments if they use the same algorithm. Checkout CF documentations to see avaiable algorithms. Also, if it's possible by your functional needs (not on the CC case, probably), one-way encrypts (hashs) are more secure, since you encrypt the data and compare the encrypted data (like on a login system). Fabio Terracini Matthew Friedman wrote: We are trying to marry a CF application and an ASP application that will need to process credit cards. What we wish to do is to encrypt and store the CC number in only one of the environments, but both will need to be able to decrypt the information and process payments. we have a payment system all ready to go, but the question we are struggling with is there a way to share the an encrypted credit card that can be decrypted on both the ASP server and the CF server and processed. Any help would be great. Matthew Friedman ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216050 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: REPOST: webservices and optional numeric arguments
Anyone know if this is Macromedia's decision or if they are simply complying with some web services standards? -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: 17 August 2005 17:49 To: CF-Talk Subject: Re: REPOST: webservices and optional numeric arguments Well bugger all ;-) Oh wellI'm sticking with numeric and consumers will have to pass in a zero (or neg number) if they want to skip that arg. At least I can add info about that KLUDGE in the hint attribute for each arg Man do I hate stuff like this.if yer going to have an attribute called required then it should damned well apply in all cases!!! *sigh* Thanks Rick Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215440 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: Copy record from query into structure
cffunction name=RowToStruct cfargument name=qry cfargument name=rownumber cfscript var i = 0; var retval = structnew(); for(i=1;i lte listlen(arguments.qry.columnlist);i=i+1){ retval[LCase(listgetat(arguments.qry.columnlist,i))] = arguments.qry[listgetat(arguments.qry.columnlist,i)][arguments.rownumber]; } /cfscript cfreturn retval /cffunction -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 16 August 2005 16:01 To: CF-Talk Subject: RE: Copy record from query into structure I think you will have to make it into an Array of Structs rather than a Struct itself. Where each Array node is an equivalent row number. -Original Message- From: Robert Everland III [mailto:[EMAIL PROTECTED] Sent: 16 August 2005 15:27 To: CF-Talk Subject: Copy record from query into structure Is there a way to copy an entire record from a query into a structure. I can reference the query like query[rowname][rownumber] but when you try to reference it as query[rownumber] it errors out. Bob ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215224 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: Studio 8 announced
ewww, clients with small budgets the php guys are welcome to them! -Original Message- From: Russ Michaels [mailto:[EMAIL PROTECTED] Sent: 12 August 2005 16:36 To: CF-Talk Subject: RE: Studio 8 announced simple. You have a client, they say they want a forum and point you at PHPBB as an example stating that it is FREE (don't reply saying PHPBB is not FREE, it's just an example, I forget if this is the free one). So what can oyu offer them. Only 1 free cf forum that I know of, and it looks pretty kack. Offer them the pricy and also kack Fusetalk, or charge them several grand to write one for them. Of cours ethey are gonna say, us ethe PHP forum then. Lots of cleint sonly have a small budget and cannot afford to pay for everything to be custom written, we have to cater for these type sof customers. And usually the only way to do so is to resort to using readily available apps/scripts in other lanaguages. The various comments that have been made here about may be true, but the cleint really isn't going to give a hoot about such things are they. Russ -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: 12 August 2005 14:34 To: CF-Talk Subject: RE: Studio 8 announced I don't understand why so many people go looking for free scripts and stuff in CF. If CF is touted as a rapid development language, doesn't that mean you should be able to write it yourself? I hear comments all the time that come across as people being lazy or people being cheap, but you never know people's situations. The whole point of the community is to bring people together who are different. Everyone just deal with it and quit complaining. As for the comments about not buying t-shirts, what the heck did that have to do with anything? I personally am not a fan of the shirts that were made and wouldn't put them in the category of Cool coldfusion gear in my opinion, but it's a start. I applaud Will for starting something and giving it a try. That's the beauty of the community is that everyone can do what they want, when they want. Yeah, support eachother when you feel the need, but if you don't want to, that's fine too. It's just like a living community...not everyone is involved in the same ways and not everyone wants to spend all their time in the community. It's nice to see eachother and help eachother every once in a while, but most of the time, I prefer to venture abroad. Anyway, this whole argument is kinda silly so I'll let everyone get back to work. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214778 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: Looking for very simple CMS
Also, just because the cost may change for certain clients doesnt mean they're getting ripped off, e.g. oh you have a massive project? we want the development, you can have the cms for free! oh you have a massive industry profile? we want you as a client so much that you can have the cms for free! -Original Message- From: Kevin Aebig [mailto:[EMAIL PROTECTED] Sent: 10 August 2005 17:44 To: CF-Talk Subject: RE: Looking for very simple CMS This is generally the case for any expensive, complex product with lots of different options. I agree and to be honest, if my company is going to spend thousands of dollars on software, I'd like to discuss it with the company beforehand. It also helps keep their sales staff from hand-holding window shoppers. Sincerely, Kevin -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: August 10, 2005 8:47 AM To: CF-Talk Subject: RE: Looking for very simple CMS I think that the fact is they do not even show a simple pricing scheme - it is all based on being called by a sales gimp. This is generally the case for any expensive, complex product with lots of different options. 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! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214399 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: Fck additional parameters
fckconfig.js edit the default toolbar, or make your own one and tell fckeditor to use it... -Original Message- From: gabriel l smallman [mailto:[EMAIL PROTECTED] Sent: 04 August 2005 13:33 To: CF-Talk Subject: Fck additional parameters Im trying to setup the fck editor and configure what buttons are displayed. I cannot find any documentation beyond the ... additional parameters ... I found something that ref. a default toolbar set, but cannot find any ref. to how to create your own or use another? Do you have to get medieval and go in and hack out the buttons you don't want? Thanks gabe fckEditor = createObject(component, fckEditorV2/fckeditor); fckEditor.instanceName=myEditor; fckEditor.basePath=/fckEditorV2/; fckEditor.value=This is my lt;stronggt;initiallt;/stronggt; html text.; fckEditor.width=100%; fckEditor.height=200; // ... additional parameters ... fckEditor.create(); // create instance now. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213719 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: IE not maintaining session...
use a cookie -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 28 July 2005 13:05 To: CF-Talk Subject: IE not maintaining session... Hi folks, Not sure if this is a CF issue, or regular behavior of ID and Win 2000. Here's the issue: If I open my IE and log into my application which uses session management and session variables everything works fine. If I use the Ctrl-N (or File New Window) to open a new window, my session is still maintained. If I open IE by clicking a shortcut on my computer and it opens in a new window, my session still maintains. HOWEVER, if I actually load IE again from the IE shortcut, the session is gone. I have looked at the processes on my PC and it shows 'two' instances of iexplore.exe, so I'm assuming that the session is not maintained across these two instances. My question is, can this be handled in some way or is just the way it is in regards to how the browser and OS work? Ideally, no matter how the user opens a new window, they are still 'logged in' to the system. Any way to do this, and if so, is it recommended or frowned upon? Thanks! Dave ** 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. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213068 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: Passing Values containing Special Characters
try: a href=setquotedefaults.cfm?quotefrom=#urlencodedformat(quotefrom)# -Original Message- From: Nancy Elberty [mailto:[EMAIL PROTECTED] Sent: 22 July 2005 17:49 To: CF-Talk Subject: Passing Values containing Special Characters I am a novice, self-taught CF programmer and am sure that there is an easy solution to my problem but I haven't had any luck yet. In an application I have developed I use CFFORM to collect input from users. I am using INPUT type=text name=QuoteFrom to get the input. I display it back by changing the type to hidden and ask the user to verify. Then I add the data to SQL. This part all works. After I do a CFQUERY to add the data, I want to go to another program and pass a couple of the fields. I use a href=setquotedefaults.cfm?quotefrom=#quotefrom#Quote creation successful. Click here to continue/a Now, the problem that I have is if the user entry contains any special characters like or setquotedefaults.cfm only reads up to the special character and truncates the rest. I have checked the program that is passing the info and the bottom gray bar on my IE browser shows the correct path, program and values. I have also checked my SQL tables and the data was added properly (Text with the special characters). What do I need to do to stop the truncating? Any suggestions would be much appreciated. Nancy ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212582 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: CFIF logic problem
works fine for me! Test not logged in: cfparam name=url.no default=0 cfset request.restrict = 3 cfset session.permission = notadmin cfif listfind(request.restrict,url.no) and comparenocase(session.permission,admin) neq 0 cflocation url=index.cfm /cfif Page contentbr cfoutput #session.permission#br #url.no# /cfoutput test.cfm?no=2 Result: Content displayed test.cfm?no=3 Result: Redirected Test logged in: cfparam name=url.no default=0 cfset request.restrict = 3 cfset session.permission = admin cfif listfind(request.restrict,url.no) and comparenocase(session.permission,admin) neq 0 cflocation url=index.cfm /cfif Page contentbr cfoutput #session.permission#br #url.no# /cfoutput test.cfm?no=2 Result: Content displayed test.cfm?no=3 Result: Content displayed ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212369 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: Looping over query assistance
cfreturn listtoarray(valuelist(getCourses.title)) -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: 21 July 2005 17:19 To: CF-Talk Subject: Re: Looping over query assistance Just return the whole query and skip all the other stuff...like so: cffunction name=getCourseData access=remote cfargument name=R_userName type=string required=yes cfquery name=getCourses datasource=learnline SELECT title FROM courses WHERE userid = cfqueryparam cfsqltype=CF_SQL_STRING value=#Arguments.R_userName# /cfquery cfreturn getCourses /cffunction I just don't see the point of stuffing the only column returned (title) into an array.just use the query ;-) HTH Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212417 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: CFIF logic problem
cfparam name=url.no default=0 cfset request.restrict = 3 cfif listfind(request.restrict,url.no) and comparenocase(session.permission,admin) neq 0 cflocation url=index.cfm /cfif Page content cfinclude template=pages/#url.no#.cfm -Original Message- From: Ian Vaughan [mailto:[EMAIL PROTECTED] Sent: 20 July 2005 16:05 To: CF-Talk Subject: RE: CFIF logic problem However The cfif url.no IS 3 etc displays dynamic content out of the database based on the url.no=. So for example http://sitename/test.cfm?no=3 Would bring back the content ' NEWS' While http://sitename/test.cfm?no=2 Would bring back the content 'BUSINESS' So I need the cfif statement to display the content as normal if the url.no is 1 or 2 or 4 etc.. But if it is url.no=3 then apply the logic so that if a user has not logged in and they do not have a session.permission is admin then use cflocation back to the index.cfm page -Original Message- From: Larry Lyons [mailto:[EMAIL PROTECTED] Sent: 20 July 2005 15:01 To: CF-Talk Subject: CFIF logic problem Hi Is my logic correct in the code below ? cfif url.no IS 3 cflocation url=index.cfm cfelseif (url.no IS 3) and (session.permission is admin) Page Content cfelse /cfif What I want is if the url is http://sitename/test.cfm?no=3 Then it will transfer back to the index.cfm page. However if the url is http://sitename/test.cfm?no=3 and the session.permission has been set to 'admin' from the user login then the page content displays. At present however the page keeps redirecting to the index.cfm page. You may want to break up the CFIF into something like this: cfif url.no IS 3 cfif session.permission is admin Page Content cfelse cflocation url=index.cfm /cfif /cfif hth, larry -- Larry C. Lyons Web Analyst BEI Resources American Type Culture Collection email: llyons(at)atcc(dot)org tel: 703.365.2700.2678 -- ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212318 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: CFError performance
I got: normal time = 0 milliseconds error time = 125 milliseconds division by zero error! -Original Message- From: S.Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: 19 July 2005 15:49 To: CF-Talk Subject: Re: CFError performance Minor revisions to the script: cfset starttime = getTickCount() cfloop index=x from=1 to=4000 cftrycfset y = x cfcatch/cfcatch/cftry/cfloop cfset ms = getTickCount()-starttime cfset normal = ms cfoutput div normal time = #ms# milliseconds /div /cfoutput cfset starttime = getTickCount() cfloop index=x from=1 to=4000 cftrycfset y = x/0 cfcatch/cfcatch/cftry/cfloop cfset ms = getTickCount()-starttime cfoutput div error time = #ms# milliseconds /div /cfoutput cfset m = ms / normal cfoutputdivincrease = x#int(m)#/div/cfoutput I ran this on our development server and got these results: normal time = 15 milliseconds error time = 20813 milliseconds increase = x1387 Although I think we have robust error information enabled on this server -- if robust error info is disabled I don't think the gap is nearly as wide. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212205 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: CF and Zips
http://www.cflib.org/udf.cfm?ID=744 -Original Message- From: Ken Ferguson [mailto:[EMAIL PROTECTED] Sent: 13 July 2005 15:26 To: CF-Talk Subject: CF and Zips Anybody know of a free cf utility (or asp or php for that matter) that will create a zip file of directories? The problem is that I've lost all remote access to my server except for FTP. I'm trying to pull all of my files down, but it keeps failing all over the place to the point where I can't simply grab a folder to ftp down to my machine, because I inexplicably lose up to half of the files/folders underneath. So you can imagine that if I do a get on a folder with 5 levels of subfolders, it's pretty difficult to go through each of those to find which files didn't end up making it. I've tried command-line FTP, WS-FTP and FileZilla with the same results. What I need is a way to run an app in my webroot which will create a zip fie of everything underneath. Then I can just get that zip file over FTP. I was able to find one asp utility, but you had to register a dll for it to work, which I can't do with no access and you had to create a virtual directory in IIS too. I could get my host (it's a dedicated server) to do all of this for me, but then I'd have to pay $150 -- no thanks. Thanks, Ferg ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211744 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: Coldfusion Switch Error - Hex Characters
Thats an interesting bug! heres a sorta workaround: cfscript function Hex7toStr(Char){ var newchar = ; var asciiChar = ; var i=0; for(i=1;i lte len(char);i=i+1){ asciiChar = asciiCharasc(mid(char,i,1)); } switch (asciiChar) { case asc(0)asc(0): newchar = NUL; break; case asc(0)asc(A): newchar = LF; break; } return newchar; } /cfscript cfoutput 00:#Hex7toStr(00)#br 0A:#Hex7toStr(0A)#br /cfoutput -Original Message- From: AFM [mailto:[EMAIL PROTECTED] Sent: 08 July 2005 17:39 To: CF-Talk Subject: Coldfusion Switch Error - Hex Characters Hello, I have an odd error with a piece of code I'm migrating from CF5 to MX6.1. It is a simple switch statement that takes Hex7 values as a string and spits out the ascii equivilent as a string. Problem is, it is reading hex value '00' and '0A' as the same thing, and returns a duplicate value error for 0.0. I've tried chr codes, changing it to IF statements, and more. I was hoping an expert could look at it and give me a hint to a fix. Below is a small snippet of the overall code. Thanks. cfscript function Hex7toStr(Char){ switch (Char) { case 00: newchar = NUL; break; case 0A: newchar = LF; break; case 30: newchar = 0; break; case 41: newchar = A; break; case EB: newchar = a; break; } return Trim(newchar); } /cfscript cfset hexChar1 = 00 cfset hexChar2 = 0A cfset hexChar3 = 30 cfset hexChar4 = 41 cfset hexChar5 = E1 CFSET hexStr1 = #Hex7toStr(hexChar1)# CFSET hexStr2 = #Hex7toStr(hexChar2)# CFSET hexStr3 = #Hex7toStr(hexChar3)# CFSET hexStr4 = #Hex7toStr(hexChar4)# CFSET hexStr5 = #Hex7toStr(hexChar5)# cfoutput table trtd#hexChar1#/tdtd#hexStr1#/td/tr trtd#hexChar2#/tdtd#hexStr2#/td/tr trtd#hexChar3#/tdtd#hexStr3#/td/tr trtd#hexChar4#/tdtd#hexStr4#/td/tr trtd#hexChar5#/tdtd#hexStr5#/td/tr /table /cfoutput ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211519 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: Simple Directory Listing
Right, so Im assuming the webserver does not have access to the directory and therefore you cant just use cfdirectory. Some ideas: Use frames Use javascript to popup a window with no address bar Setup a website with a home directory set to use that directory Setup a share on the server e.g. so that users cant see the real share. \\Viahealth08\Pharmacy\ -Original Message- From: Claremont, Timothy [mailto:[EMAIL PROTECTED] Sent: 11 July 2005 17:05 To: CF-Talk Subject: RE: Simple Directory Listing Thanks, Jerry, I made a couple of syntax correction to your suggestion, but I get a Connection Failure on the result page. Note that if I merely copy and paste the URL into the browser it works just fine, so I know I can see the URL. Subject: Simple Directory Listing From: Jerry Johnson [EMAIL PROTECTED] Date: Mon, 11 Jul 2005 11:37:05 -0400 Thread: http://www.houseoffusion.com/cf_lists/index.cfm/method=messagesthreadid =41104forumid=4#211540 Crude, but... form action=dirListing.cfm method=post target=_new input type=hidden name=folderURL value=\\Viahealth08\ILS\Shared\All Departments\HIM-IS\Utilization Data\Pharmacy Reports\ input type=submit value=Pharmacy Reports /form then make a dir_listing.cfm page cfparam name=folderURL default= cfhttp url=#folderURL# cfoutput#cfhttp.fileContent#/cfoutput Jerry Johnson ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please delete it from your system. This footnote also confirms that this email message has been swept for the presence of computer viruses. Thank You, Viahealth ** ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211547 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: cfxhtmlbeans: new project at cfopen.org
Interesting, want some feedback? - Not happy about your repeated use of evaluate in the base object - have you created any real world HTML pages using this? I would be interested to see how much code is required to generate a complex html page -Original Message- From: Martin Orth [mailto:[EMAIL PROTECTED] Sent: 06 July 2005 11:11 To: CF-Talk Subject: cfxhtmlbeans: new project at cfopen.org FYI The cfxhtmlbeans project basic parts are a ColdFusion code generator and a xHTML schema parser. For each xHTML elemement(html tag) within the schema the generator creates a CFC with the name of the element. eg. table.cfc for the element table. This allows seperation of business logic and display logic within normal CF templates. eg. generate an instance of the html object and place a head instance inside and a meta instance inside the the head, and so on. At the end of the page request you can still manipulate the head section and then call the render method of the html object to output fine html code. The predefined string object allows you to add non object based flat html code to your object instances. http://cfopen.org/projects/cfxhtmlbeans/ http://cfopen.org/projects/cfxhtmlbeans/ Some things still missing because it's alpha: I am not sure about the object architecture. eg. Handling object instances internaly. This still needs discussion. I plan to add javascript like DOM functions. Please spread the word. Any comments? [EMAIL PROTECTED] ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211235 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: Frigging annoying Checkbox behaviour
IIRC, unticked checkboxes should not exist in the form scope. -Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: 06 July 2005 11:40 To: CF-Talk Subject: Frigging annoying Checkbox behaviour I vaguely recall reading this somewhere before; when I submit a form full of unticked checkboxes to CF (6.1 in this case), the checkboxes are defined (along with their checked values) in the form structure when I loop through it yet they aren't listed in the FORM.FieldNames variable. This happens in IE6 and FF; of course as long as one or more boxes are ticked the form behaves as is should. I have coded around it by counting the rest of the form fileds and checking the listlength of FORM.FieldNames, so I know when the checkboxes have been left unticked. Is this the expected behaviour from a browser or is something weird going on with CF? -- Geeque - accept the geek within and get your friends off your back - http://www.cafepress.com/geeque/ ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211236 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: jar launcher crashes randomly
Hey did anyone get any further with this? I am now getting this on our W2K3 server as well. -Original Message- From: Nathan Strutz [mailto:[EMAIL PROTECTED] Sent: 13 June 2005 05:58 To: CF-Talk Subject: Re: jar launcher crashes randomly stylo stylo wrote: Anyone else? Ya, we get this all the time, once or twice a day maybe. Haven't figured out what it means. We submitted it to MM as par of a different problem in a trouble ticket, but didn't get any response on it. Seems to happen only on our W2k3 servers, but I'm not 100% sure, as now all our web servers are 2k3 (so, basically, it happens on all the busy servers). No clue though, really. -nathan strutz http://www.dopefly.com/ ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211003 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: another cfdump bug?
is this on 7? works fine for me on 6.1+updater+hotfix hf56580_611.zip -Original Message- From: Russ [mailto:[EMAIL PROTECTED] Sent: 29 June 2005 17:18 To: CF-Talk Subject: another cfdump bug? I'm running into an issue with cfdump. Here is the sample code that reproduces the issue I'm having. cftry cfset testStruct=StructNew() cfoutput#testStruct[testKey]#/cfoutput cfcatch type=any cfdump var=#cfcatch# label=cfcatch cfset myCatch=StructNew() cfloop list=#structKeyList(cfcatch)# index=x cfset StructInsert(myCatch,x,Evaluate(cfcatch.#x#),false) /cfloop cfdump var=#myCatch# label=myCatch /cfcatch /cftry The first cfdump just outputs cfcatch - object of coldfusion.runtime.UndefinedElementException. The second one outputs what I'm expecting to see. Is there a bug in the way that cfdump dumps the cfcatch struct when it's an underfinedElementException, or am I doing something wrong? I might be a bit behind in the hotfixes, are there any I should apply? Russ ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210906 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: 5th Most Trafficked Site Switches to BlueDragon
Comparing Blue Dragon to CF 5 is kind of an unfair comparison as well as better stability and performance than even CFMX -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: 28 June 2005 15:16 To: CF-Talk Subject: RE: 5th Most Trafficked Site Switches to BlueDragon My only concern with this statement is that CFMX 6.1 or 7 would probably show similar increases over CF 5. Comparing Blue Dragon to CF 5 is kind of an unfair comparison. Congrats to New Atlanta, and I hope this will boost some of their efforts and allow them to grow even more, but I just wanted to point out that the comparison seemed flawed to me. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer On 6/28/05, Rey Bango [EMAIL PROTECTED] wrote: In a huge coup, my boys at New Atlanta have won a MAJOR deal and are helping MySpace.com, the fifth most heavily trafficked web site on the Internet,make the switch from Macromedia ColdFusion 5.0 to New Atlanta's BlueDragon for .NET. MySpace is easily the largest CFML-based site on the Internet; to put things into perspective, MySpace has surpassed both Google and Hotmail in terms of total page views and currently handles more than 18 million members. Who says CFML isn't viable! Woohoo! The part that caught my eye was that in their testing, MySpace saw a 50% performance improvement over ColdFusion 5.0 as well as better stability and performance than even CFMX. This is a massive win for New Atlanta and further vindication that their BlueDragon product-line is a more-than-viable (dare I say better) alternative to Macromedia's ColdFusion server. Full details of the deal can be found on Vince Bonfanti's blog http://blog.newatlanta.com Congratulations New Atlanta! -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 50 invites. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210714 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: 5th Most Trafficked Site Switches to BlueDragon
Did they switch from 5 to BD or from MX to BD? I would assume that they setup test servers for both MX and BD Also, stability can often be based on the quality of the coding itself I agree, performance too. I *assume* that for a benchmark test they would have written some decent code and then used that, as well as testing their existing site... I have heard reports from a guy that writes very tight code that his system runs slower on bd.net than CFMX reliable performance stats are very hard to nail down... -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: 28 June 2005 15:39 To: CF-Talk Subject: RE: 5th Most Trafficked Site Switches to BlueDragon I don't understand that one either. Did they switch from 5 to BD or from MX to BD? Also, stability can often be based on the quality of the coding itself. I'm not saying that BD doesn't offer a better product than MM or that myspace isn't loving it, I'm just saying that the way it was presented seems flawed. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: Kerry [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 28, 2005 10:35 AM To: CF-Talk Subject: RE: 5th Most Trafficked Site Switches to BlueDragon Comparing Blue Dragon to CF 5 is kind of an unfair comparison as well as better stability and performance than even CFMX -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: 28 June 2005 15:16 To: CF-Talk Subject: RE: 5th Most Trafficked Site Switches to BlueDragon My only concern with this statement is that CFMX 6.1 or 7 would probably show similar increases over CF 5. Comparing Blue Dragon to CF 5 is kind of an unfair comparison. Congrats to New Atlanta, and I hope this will boost some of their efforts and allow them to grow even more, but I just wanted to point out that the comparison seemed flawed to me. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer On 6/28/05, Rey Bango [EMAIL PROTECTED] wrote: In a huge coup, my boys at New Atlanta have won a MAJOR deal and are helping MySpace.com, the fifth most heavily trafficked web site on the Internet,make the switch from Macromedia ColdFusion 5.0 to New Atlanta's BlueDragon for .NET. MySpace is easily the largest CFML-based site on the Internet; to put things into perspective, MySpace has surpassed both Google and Hotmail in terms of total page views and currently handles more than 18 million members. Who says CFML isn't viable! Woohoo! The part that caught my eye was that in their testing, MySpace saw a 50% performance improvement over ColdFusion 5.0 as well as better stability and performance than even CFMX. This is a massive win for New Atlanta and further vindication that their BlueDragon product-line is a more-than-viable (dare I say better) alternative to Macromedia's ColdFusion server. Full details of the deal can be found on Vince Bonfanti's blog http://blog.newatlanta.com Congratulations New Atlanta! -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 50 invites. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210724 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: Java InputStream = ??? in CF
why not just give it exactly what it asks for? cfset inputstr = createobject(java,java.io.InputStream) -Original Message- From: Jeff Chastain [mailto:[EMAIL PROTECTED] Sent: 28 June 2005 15:59 To: CF-Talk Subject: Java InputStream = ??? in CF I have a Java application that was purchased off the shelf that I am trying to get to interface with a custom ColdFusion application. One of the method calls in the Java application's API calls for an java.io.InputStream parameter. What would this be equal to (if anything) in ColdFusion? Is this the form field result of an input type=file field or is this the variable after a cffile upload? Any Java people out there that could make this comparison? Thanks -- Jeff Chastain ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210725 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: Java InputStream = ??? in CF
maybe trying giving it something like this: input = CreateObject(java,java.io.FileInputStream).init(pathtoyourfile); -Original Message- From: Jeff Chastain [mailto:[EMAIL PROTECTED] Sent: 28 June 2005 16:14 To: CF-Talk Subject: RE: Java InputStream = ??? in CF Well, maybe because I am not sure what it is looking for then. The documentation refers to the parameter as follows ... inStream - an InputStream from which the contents of the new document will be read. Cannot be null. So, I assumed that this meant that it wanted the actual file in some form, not just an empty InputStream object. What this is, is a CMS type system and this method call is to insert a new document in the CMS. Thanks -- Jeff From: Kerry [EMAIL PROTECTED] Sent: Tuesday, June 28, 2005 10:07 AM To: CF-Talk cf-talk@houseoffusion.com Subject: RE: Java InputStream = ??? in CF why not just give it exactly what it asks for? -Original Message- From: Jeff Chastain [mailto:[EMAIL PROTECTED] Sent: 28 June 2005 15:59 To: CF-Talk Subject: Java InputStream = ??? in CF I have a Java application that was purchased off the shelf that I am trying to get to interface with a custom ColdFusion application. One of the method calls in the Java application's API calls for an java.io.InputStream parameter. What would this be equal to (if anything) in ColdFusion? Is this the form field result of an variable after a Any Java people out there that could make this comparison? Thanks -- Jeff Chastain ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210739 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: Your recent email to us
yep every time -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: 28 June 2005 17:01 To: CF-Talk Subject: Fw: Your recent email to us Anybody else getting this? I seem to get one everytime I post to CF-TALK. Goldman Sachs JBWere's electronic mail policy prohibits the receipt or distribution of material which may be regarded as offensive or spam mail. If the message is urgent please review the content for any language or material which may be offensive and resend the message or contact the intended recipient by telephone. Message Name: B42c1723a.0001.0005.mml Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210774 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: This is crazy this is crazy this is crazy!
Just tried in IE no probs. -Original Message- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: 27 June 2005 00:25 To: CF-Talk Subject: Re: This is crazy this is crazy this is crazy! Ok, ignore that. I see you posted bout your browser now. My mind is screwed tonight after this. Someone just pointed out something wondering if I'm using a reserved IE word or something. Thanks, Will ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210580 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: CF7 Flash Remoting
I thought page not found meant that it wasnt setup right. http://www.macromedia.com/go/tn_16522 -Original Message- From: Ray Buechler [mailto:[EMAIL PROTECTED] Sent: 17 June 2005 15:00 To: CF-Talk Subject: CF7 Flash Remoting Has any one been able to connect to Flash Remoting in CFMX 7? I have never been able to connect to Flash Remoting on CFMX7 on my production server(Windows 2k server/IIS). I have gone as far as uninstalling CF and re-installing it. I've re-run the IIS connectors. I've also tried editing the gateway-config.xml file by uncommentting adaptercoldfusion.flash.adapter.CFWSAdapter/adapter BTW: I get a page not found error when I try to go to http://mysite/flashservices/gateway? and when trying to use the flash version of cfgrid the grid will not populate with data. Does anyone have any other suggestions as to how to fix this? Thanks, Ray ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209795 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: New ColdFusion shirts available...
saw one on think geek which i thought was pretty funny: No, I will not fix your computer -Original Message- From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: 15 June 2005 14:37 To: CF-Talk Subject: Re: New ColdFusion shirts available... Ooohh oooh, I want a shirt thats says All CF competitors are sh$t! -Adam On 6/15/05, Tony Weeg [EMAIL PROTECTED] wrote: ray, i do not see any shirts or links to shirts on cflib? and neil... yeah, why not? tw On 6/15/05, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: Yeah...no supsrise; would you buy a Tee with I'm A Geek? ;-) ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209547 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: odd error question
hmmm, if you try/catch it and then dump cfcatch, is there more info? -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 09 June 2005 14:45 To: CF-Talk Subject: Re: odd error question i know, apart from one thing: shared hosting cfmx server @ experthost.com :( tw On 6/9/05, Joe Rinehart [EMAIL PROTECTED] wrote: Tony, If you enable robust exception handling in the CF administrator, it'll probably give a much more meaningful error msg. -Joe On 6/8/05, Tony Weeg [EMAIL PROTECTED] wrote: hi there. anyone ever seen this error before? Error Occurred While Processing Request The filename, directory name, or volume label syntax is incorrect Please try the following: * Enable Robust Exception Information to provide greater detail about the source of errors. In the Administrator, click Debugging Logging Debugging Settings, and select the Robust Exception Information option. * Check the ColdFusion documentation to verify that you are using the correct syntax. * Search the Knowledge Base to find a solution to your problem. Browser Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.8) Gecko/20050511 Firefox/1.0.4 Remote Address 69.250.12.29 Referrer http://www.mydinnercompany.com/menu.cfm?step=approveOrderDetailsCFID=5673C FTOKEN=88435167 Date/Time 08-Jun-05 11:38 PM -- tony Tony Weeg macromedia certified coldfusion mx developer email: tonyweeg [at] gmail [dot] com blog: http://www.revolutionwebdesign.com/blog/ cool tool: http://www.antiwrap.com ...straight cash homey - randy moss, now a raider ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209090 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: a simple xml question
Function calls need brackets: cfset testxml= myCFC.simpleXml() -Original Message- From: Ida Chen [mailto:[EMAIL PROTECTED] Sent: 09 June 2005 16:05 To: CF-Talk Subject: a simple xml question I am new to cfc/xml. When I tried to create a simple cfc function that returns an xml object and tried to call it in a cfm page, the page returned some weird strings instead of the string I put in the testing xml. Can anyone help me correct errors? Thanks. The code is below: cfc: cfcomponent cffunction name=simpleXml access=public returntype=xml cfxml variable=xmlobject testthis is a test/test /cfxml cfreturn xmlobject /cffunction /cfcomponent cfm: cfobject name=myCFC component=testcfc cfset testxml= myCFC.simpleXml cfoutput#toString(testxml)#/cfoutput the weird string that is returned is something like this: textxml [EMAIL PROTECTED] thanks again ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209104 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: Mulitple FCKEditor Instances Firefox issues
hmmm, just tried it with three instances, no problems. fckeditor 2.0 firefox 1.0.4 -Original Message- From: jonese [mailto:[EMAIL PROTECTED] Sent: 09 June 2005 17:30 To: CF-Talk Subject: SOT: Mulitple FCKEditor Instances Firefox issues We have a form with two instances of the FCKeditor running. In IE everything works as expected (users can edit and add data to both WYSIWYG) but in firefox users can only manipulate the second instance and can't do anything in the first instance. Has anyone had any issues similar to this and if so how did you get around it? jonese ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209125 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: session variables or multiple pages
CF will give 2 windows from the same machine the same session, if the browser is the same. If your boss wouldnt mind using firefox for one window and IE for the other window, it should work. -Original Message- From: Daniel Kessler [mailto:[EMAIL PROTECTED] Sent: 08 June 2005 14:10 To: CF-Talk Subject: session variables or multiple pages My boss has indicated to me that he would like to open up two PC IE browser windows, log into our application under two different logins and view the data from each of those independently. I had been keeping information in cookies, but since they'd share a cookie, I migrated the information over to session variables. But it doesn't seem to be working. I log in as danielk and it shows logged in as danielk. Then I open a second browser window and log in as rsBold and it shows logged in as rsbold in the second browser window. I then refresh the first window using the refresh button and it shows logged in as rsbold instead of danielk. So they're still sharing the information. help? this is an important feature. -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD 20742-2611 301-405-2545 Phone www.phi.umd.edu ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208941 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: CFML Language History
TechNote Details ID: tn_18791 Product(s): ColdFusion Versions: 4, 4.5, 5, MX, MX 6.1 -Original Message- From: Emanuel Costa [mailto:[EMAIL PROTECTED] Sent: 08 June 2005 16:17 To: CF-Talk Subject: CFML Language History Does anyone knows if this technote has been updated to MX 7 or if it will soon? http://www.macromedia.com/go/tn_18791 Thanks -- =+=+=+=+=+=+=+=+=+=+=+=+ Emanuel Costa site: http://www.emanuelcosta.com msn: [EMAIL PROTECTED] ICQ: 8013683 Orkut: Emanuel Costa Skype: Emanweb =+=+=+=+=+=+=+=+=+=+=+=+ Every person takes the limits of their own field of vision for the limits of the world. - Arthur Schopenhauer ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208995 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: Get New Record ID in ORACLE
I have managed to get some SQL that cfquery didnt like to work perfectly using this: cfscript factory = CreateObject( java, coldfusion.server.ServiceFactory ); ds = factory.getDataSourceService().getDatasource( yourdsn ); conn = ds.getConnection(); stmt = conn.createStatement(); sql = your funky sql; stmt.execute( #sql# ); stmt.close(); conn.close(); /cfscript worth a try? -Original Message- From: RADEMAKERS Tanguy [mailto:[EMAIL PROTECTED] Sent: 07 June 2005 16:27 To: CF-Talk Subject: RE: Get New Record ID in ORACLE -Original Message- Subject: Get New Record ID in ORACLE From: Douglas Knudsen [EMAIL PROTECTED] Date: Tue, 7 Jun 2005 10:41:52 -0400 Thread: http://www.houseoffusion.com/cf_lists/index.cfm/method=messages threadid=40571forumid=4#208799 select mysequence.nextval into newid from dual You are using a sequence for your IDs, no? DK LOL. Yes i am using sequences for my IDs. I have a sequence called s. This code: cfquery name=nextval datasource=trademak select s.nextval into newid from dual /cfquery fails with error [Macromedia][Oracle JDBC Driver][Oracle]ORA-00905: missing keyword This code: cfquery name=nextval datasource=trademak select s.nextval from dual /cfquery works just fine. So i am assuming that you insert a new row like this: cfquery name=nextval datasource=trademak select s.nextval from dual /cfquery cfquery name=testinsert datasource=trademak insert into t (id,name) values(#nextval.nextval#,'this is a test') /cfquery i was just wondering whether you had found a way to make select mysequence.nextval into newid from dual work in a cfquery block (like anonymous pl/sql or something). Have you? /t ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208811 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: Currency data type in access
http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/functa27.htm -Original Message- From: Phillip Perry [mailto:[EMAIL PROTECTED] Sent: 07 June 2005 18:22 To: CF-Talk Subject: Currency data type in access Hi, When I display the dollar amount in a web page the values come with extra 0's (ex: 19.9500). How do I get rid of the extra 0's? I tried replace() but that didn't pan out. Thanks, Phil ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208850 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: Search engines and CF
best practices for search engine optimization when using coldfusion I would say that SEO best practices are development language independent. What we are currently doing is setting up a site map of sorts Heres a tip: If you can make the order of the links on the site map change dependent on, say, the number of jobs for that type, or the most recently posted job of that type, then google will see that the page has changed, keep re-indexing it, and through that, re-index your customised pages. -Original Message- From: Protoculture [mailto:[EMAIL PROTECTED] Sent: 03 June 2005 14:22 To: CF-Talk Subject: Search engines and CF Are there any best practices for search engine optimization when using coldfusion? What we are currently doing is setting up a site map of sorts that interlinks our database of job types with a customized page. Essentially what the intention here is that search engines will index these pages and thus improve our internet ranking. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208493 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: Search engines and CF
yep. -Original Message- From: Protoculture [mailto:[EMAIL PROTECTED] Sent: 03 June 2005 16:07 To: CF-Talk Subject: RE: Search engines and CF Hey Kerry, so what you are saying is that changing the order of the links on the site map will signal to google that the page has changed? Heres a tip: If you can make the order of the links on the site map change dependent on, say, the number of jobs for that type, or the most recently posted job of that type, then google will see that the page has changed, keep re-indexing it, and through that, re-index your customised pages. -Original Message- From: Protoculture [mailto:[EMAIL PROTECTED] Sent: 03 June 2005 14:22 To: CF-Talk Subject: Search engines and CF Are there any best practices for search engine optimization when using coldfusion? What we are currently doing is setting up a site map of sorts that interlinks our database of job types with a customized page. Essentially what the intention here is that search engines will index these pages and thus improve our internet ranking. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208521 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: get parent items from list?
What's the most efficient way of determining the parent of any item in the list and determining that item1 has no parent perhaps im missing something here, but: mylist = item1,item2,item3,item4; for(i=1; i lte ListLen(mylist);i=i+1){ WriteOutput(I am: ListGetAt(mylist,i)); if(i eq 1){ WriteOutput( and I am the root); }else{ WriteOutput( and my parent is: findparent(mylist,ListGetAt(mylist,i))); } WriteOutput(br); } function findparent(nlist,me){ var myparent = root; var myindex = ListFind(nlist,me); if(myindex gt 1){ myparent = ListGetAt(nlist,myindex-1); } return myparent; } -Original Message- From: Jerry Barnes [mailto:[EMAIL PROTECTED] Sent: 02 June 2005 15:36 To: CF-Talk Subject: Re: get parent items from list? Sounds like an adjaceny list model. Does the list contain the whole tree or does a list only contain a path from one node to another while other lists contain other paths? On 6/2/05, Emmet McGovern [EMAIL PROTECTED] wrote: Brain Meltdown. Maybe someone can help. I have a list such as (item1,item2,item3,item4,item5). The list can be any length. Item1 would be the parent of item2 and item2 would be the parent of item3 and so on. What's the most efficient way of determining the parent of any item in the list and determining that item1 has no parent? Thanks, Emmet ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:208383 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: cfcomponent/function inheritence issue?
If you do this: cfset var s = structNew() cfset s = mystruct Then s is not a struct, but a pointer to mystruct, so whenever you set a property of s, you are in fact setting a property of mystruct. Also, personally, theres no way i would do this: cfif NOT isDefined(mystruct)cfset this.init()/cfif I would do: cfset var s = duplicate(mystruct) if mystruct isnt defined, then the component hasnt been inited, which means the code isnt right, and an error should be thrown. -Original Message- From: Ben Mueller [mailto:[EMAIL PROTECTED] Sent: 27 May 2005 16:27 To: CF-Talk Subject: cfcomponent/function inheritence issue? I've just started learning cfcomponents as of a few days ago, and have liked what I've seen so far, but I'm having what I think is an inheritence issue. I have a component with three functions: an init, and then two other functions. The init function sets a bunch of variables that I'd like to have access to throughout the component. The other functions invoke the init function if the init variables haven't been set yet. In each function, I'd like to return the global vars returned by the init function, plus a bunch of stuff unique to each function. The trouble is that the variables from the first function call end up as part of the overall instance data, and are then somehow getting returned in subsequent function calls. I'm sure it's something silly, but here's my sample code: cfcomponent cffunction name=init access=package output=no cfset mystruct = structNew() cfset mystruct.initvar = init varvalue cfreturn this /cffunction cffunction name=func1 access=public output=no cfset var s = structNew() cfif NOT isDefined(mystruct)cfset this.init()/cfif cfset s = mystruct cfset s.func1var = value1 cfreturn s /cffunction cffunction name=func2 access=public output=no cfset var t = structNew() cfif NOT isDefined(mystruct)cfset this.init()/cfif cfset t = mystruct cfset t.func2var = value2 cfreturn t /cffunction /cfcomponent ..and here's how I'm invoking it: cfobject name=testcom component=path.to.component cfset func1output = testcom.func1() cfset func2output = testcom.func2() cfdump var=#func1output# cfdump var=#func2output# What I would expect from the first cfdump is a structure containing the initvar and func1var; and from the second cfdump a structure with initvar and func2var. However, my second cfdump call returns initvar, func1var and func2var. So, it would seem that the line of code where I declare this in my first function: cfset s = mystruct is not only setting s to the value of mystruct, but also the other way around. That is a surprise to me. Any help is appreciated. Thanks in advance, Ben Mueller ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207870 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: cfcomponent/function inheritence issue?
how can I ensure that my init function is called Well, theres a lot of answers to that question, but heres two: Way I would do it: cfscript testcom = createobject(component,path.to.component); testcom.init(); /cfscript Another way, which I wouldnt do: cfcomponent cfscript init(); /cfscript cffunction name=init access=package output=no cfset mystruct = structNew() cfset mystruct.initvar = init varvalue /cffunction /cfcomponent -Original Message- From: Ben Mueller [mailto:[EMAIL PROTECTED] Sent: 27 May 2005 17:15 To: CF-Talk Subject: RE: cfcomponent/function inheritence issue? Kerry, Thanks for your help. You're certainly right about the duplicate function...and of course I should have known that already. But I'm a little confused about your statement that I shouldn't do this: cfif NOT isDefined(mystruct)cfset this.init()/cfif I could call any function in my component at any time, so I have no way of guaranteeing that init has been called previously. If the above code is not advised, then how can I ensure that my init function is called? If you do this: cfset var s = structNew() cfset s = mystruct Then s is not a struct, but a pointer to mystruct, so whenever you set a property of s, you are in fact setting a property of mystruct. Also, personally, theres no way i would do this: cfif NOT isDefined(mystruct)cfset this.init()/cfif I would do: cfset var s = duplicate(mystruct) if mystruct isnt defined, then the component hasnt been inited, which means the code isnt right, and an error should be thrown. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207878 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: Database Schema Options
Personally, I would go for a generic attributes table, Ive seen it done in some massive enterprise databases, and it does provide flexibility for when: you realise you need another 10 attribute types, oops, now some properties dont have some attributes but they have another 10 different attributes, doh, now the marketing department wants to use it and they need 10 more attributes... For example, street is not an optional attribute This might be out of the scope of what you're doing, but I remember from my uni days that some properties spanned more than one street. Perhaps some properties need more than one street attribute... theres that flexibility coming in handy again... -Original Message- From: Dawson, Michael [mailto:[EMAIL PROTECTED] Sent: 25 May 2005 17:57 To: CF-Talk Subject: OT: Database Schema Options I am toying with a few different methods of creating a database schema that will hold information about some rental properties the university owns. My first method was to create a schema that consisted of many tables, one for each attribute, and then relate them to the properties table with FKs. This is my diagram: http://acelinkdev.evansville.edu/Temp/Method1.gif (This leads to many tables, but easy to control referential integrity.) My second method was to create a single 'attributes' table that contained, basically, all the other tables that stored attributes about a house. This is my diagram: http://acelinkdev.evansville.edu/Temp/Method2.gif (Note: Not all attributes were added to the Property table for lack of time.) (This leads to fewer tables, but harder to control referential integrity.) My third method was to add a many-to-many relation between Property and Attributes. (No diagram for this method.) With the third method, would I put *only* the options in join table or *all* of them? For example, street is not an optional attribute, however, porch may be. Can anyone give some suggestions on how best to design this schema? Eventually, we may add the capability to search and filter items based on select boxes or check boxes. Thanks M!ke ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207676 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: format XML string?
parse it into an xml object, then use: xmlobj.getDocumentElement().toString() except that will probably Unicode format it, dunno if theres a unicode2msdos() function floating around anywhere... -Original Message- From: Johnny Le [mailto:[EMAIL PROTECTED] Sent: 24 May 2005 18:36 To: CF-Talk Subject: format XML string? Hi, Is there a way to format the xml string before writing back to the file? The problem I have is when I use toString(xmlObject) to convert the xml object to string to write to a file, it becomes one long ugly string. Is there an easy to format it with indentation and all? Johnny ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207550 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: Viewing files in another server/directory outside CF server
UNC: \\servername\sharename\directory\file AFAIK, your CF service will need to login as a user with rights to the remote server -Original Message- From: Michel Deloux [mailto:[EMAIL PROTECTED] Sent: 24 May 2005 17:45 To: CF-Talk Subject: Re: Viewing files in another server/directory outside CF server Thanx Dave. .and that your clients have network logon rights to that machine and read access to the share in question... it's impossible! What's UNC? How to setup? Thanx once more again. 2005/5/24, Dave Watts [EMAIL PROTECTED]: CF lives in CA_LA_WS server and all docs lives in CA_LA_Fresno server. How to show for our users docs stored in CA_LA_Fresno server with IE? It's possible? For IE I need to store my files in CF server? You have all sorts of options. You can allow direct access via UNC path to the server in question, although you will also have to ensure that your clients can resolve the NetBIOS name correctly (via WINS, LMHOSTS or AD DNS) and that your clients have network logon rights to that machine and read access to the share in question. 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! ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207555 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: SQL Server User Problems
is the table owner dbo or {username}? -Original Message- From: Protoculture [mailto:[EMAIL PROTECTED] Sent: 18 May 2005 17:20 To: CF-Talk Subject: RE: SQL Server User Problems Manage to solve the issue with the users, but now we're finding the stored procedures we had aren't not functioning. Invalid object name -- get this error when running a stored procedure. We checked in the database and it does exist. Also have tried removing and re-creating... Make sure you have a SQL Server login with the same name under Security. Then, make sure your database's user points to that login. Moving databases from one server to another tend to break SQL Server-based logins, however, domain (Windows-based) logins will still work. M!ke -Original Message- From: Protoculture [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 18, 2005 10:15 AM To: CF-Talk Subject: SQL Server User Problems We've transferred a copy of our database to a new server and are trying to log in as a particular user. It seems that for some reason, we cannot connect to the default database. This was working fine on the old system, but since we've copied things across it seems that a particular user account does not work. I've tried removing it and recreating the user all with the same dismal results. Has anyone else experienced this or know of a possible solution? Cheers! ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207050 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: Client side include
Not the answer you want but, I would avoid DHTML menus, and recursive menus that render the whole menu in one go. -Original Message- From: Kevin Roche [mailto:[EMAIL PROTECTED] Sent: 12 May 2005 08:49 To: CF-Talk Subject: Client side include Hi, A new site I am building has a really big left hand menu. we are using some DHTML code that builds a css based hierarchical menu. It looks good but takes 'ages' to download on every page. I was just thinking that it must be possible to download it once and include it on the client side rather than at the server end to save on the download. Anyone know how to do that? I already tried: object type=text/html data=include/menu.cfm a href=include/menu.cfm Menu /a /object .but the effect of doing it that way is that when the menu jumps out the box gets bigger and disrupts the page, instead of the menu overlapping the page elements. Does anyone know if this kind of thing can be done with writeContent() ? I can't see how myself but have a hunch that there might be some way to do that. Target browsers are IE and FireFox. Kevin Roche Technical Director Objective Internet Ltd 01256 338 490 This message (including any attachments) contains information that may be confidential and/or privileged. It is intended only for the person(s) to whom it is addressed. - If you are not the intended recipient, please notify the sender by replying to this message with Received in error as the subject and then delete it from your mailbox. - If you are not the intended recipient, you are not authorized to read, print, retain, copy or disseminate this message or any part of it, and any unauthorized use may be illegal. The sender is not responsible for the accuracy or completeness of this message when it has been transmitted over a public network, as Internet communication is not secure. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206498 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: Client side include
client has this as a must have item hate it when that happens like to cache the menu on the client I have a site that I was forced to use a DHTML menu on, and I have a .js file that writes out the menu. The .js file is cached on the client independently from the page, but there is still a small delay while the js does its thing client side... -Original Message- From: Kevin Roche [mailto:[EMAIL PROTECTED] Sent: 12 May 2005 09:49 To: CF-Talk Subject: RE: Client side include Micha, Kerry, Thanks for your replys. I have no prblem with caching on the server. I would also like to cache the menu on the client. The performace hit that really worries me is that of downloading the menu with every page. Kerry said: I would avoid DHTML menus, and recursive menus that render the whole menu in one go. Unfortunarely that answer is not the solution as the client has this as a must have item! Apart from the download time CSS menu is working well so I don't need a solution for that, just for caching it in the browser. Beacuse of the page layout putting the menu and page in separate frames is not the solution. I was wondering if anyone here had ever tried using a single frame with javascript to write the output from two sources. That way I could possibly cache the menu on the browser and merge it with the rest of the page. Kevin -Original Message- From: Micha Schopman [mailto:[EMAIL PROTECTED] Sent: 12 May 2005 09:27 To: CF-Talk Subject: RE: Client side include Kerry, Could you also explain why? For Kevin, overlapping parts of the menu means you either must look at how to handle such things using scrollbars using CSS or markup, or adjust the menu to fit in the user interface. For the performance hit of the cfinclude, try looking at caching the output. Often there is no reason (besides personalized links, or information) to render navigation on each request. Render it once, reuse it many times afterwards. Caching in the application scope, of the output of the menu, offers you the ability to display that cached output to all visitors. Micha Schopman Project Manager Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 - Modern Media, Making You Interact Smarter. Onze oplossingen verbeteren de interactie met uw doelgroep. Wilt u meer omzet, lagere kosten of een beter service niveau? Voor meer informatie zie www.modernmedia.nl - -Original Message- From: Kerry [mailto:[EMAIL PROTECTED] Sent: donderdag 12 mei 2005 8:56 To: CF-Talk Subject: RE: Client side include Not the answer you want but, I would avoid DHTML menus, and recursive menus that render the whole menu in one go. -Original Message- From: Kevin Roche [mailto:[EMAIL PROTECTED] Sent: 12 May 2005 08:49 To: CF-Talk Subject: Client side include Hi, A new site I am building has a really big left hand menu. we are using some DHTML code that builds a css based hierarchical menu. It looks good but takes 'ages' to download on every page. I was just thinking that it must be possible to download it once and include it on the client side rather than at the server end to save on the download. Anyone know how to do that? I already tried: object type=text/html data=include/menu.cfm a href=include/menu.cfm Menu /a /object .but the effect of doing it that way is that when the menu jumps out the box gets bigger and disrupts the page, instead of the menu overlapping the page elements. Does anyone know if this kind of thing can be done with writeContent() ? I can't see how myself but have a hunch that there might be some way to do that. Target browsers are IE and FireFox. Kevin Roche Technical Director Objective Internet Ltd 01256 338 490 This message (including any attachments) contains information that may be confidential and/or privileged. It is intended only for the person(s) to whom it is addressed. - If you are not the intended recipient, please notify the sender by replying to this message with Received in error as the subject and then delete it from your mailbox. - If you are not the intended recipient, you are not authorized to read, print, retain, copy or disseminate this message or any part of it, and any unauthorized use may be illegal. The sender is not responsible for the accuracy or completeness of this message when it has been transmitted over a public network, as Internet communication is not secure