RE: Get String Byte Size
Try this: http://martin.nobilitas.com/java/sizeof.html The empirical formula derived there indicates that string memory is 38+/-2 + 2*(string length) bytes. In my own tests on JDK 1.4.2_09 I got something similar: 40 + 2*(string length) bytes when length2. For length 0 to 2, the size works out to just 40 bytes. That said, as Nick mentions, if all that you're trying to do is get an idea of the relative memory occupied by different strings, rather than the actual physical memory (which, as discussed in the link above, can be determined only empirically, not precisely), you might be best off just checking the length. -Original Message- From: Nick de Voil [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 19, 2006 9:47 PM To: CF-Talk Subject: Re: Get String Byte Size Anyone have any quick code to retrieve the number of bytes in a string /without/ writing the string to a file first? I'm trying to do a little debugging and I'd like to know the size of a string that is being returned to the browser. The number of bytes occupied in the application's memory by the Java String object is probably not the same as the number of bytes occupied by the same string in the HTTP response. I could be wrong on some points below but I'm sure others will correct me if so (Paul?) As I understand it, a Java program such as CF always stores characters internally using UCS-2 encoding, i.e. 2 bytes per character. In addition, the String object will include 20 or 30 extra bytes for storing the length of the string etc. I believe that CF's default behaviour is to encode HTTP responses using UTF-8 encoding, i.e. 1 byte per character if you're only using ASCII characters, and of course the extra bytes used by the String object won't be there either. So let's say your string is Rob. - In CF the Len() function gives you 3. - The size of the Java object - even if you could work it out, which is next to impossible in Java - would be 6 + the extra bytes, maybe 40 or more. - But in the HTTP response it would probably be 3. So, if I've understood your question correctly and it's the HTTP response you're interested in, just using Len() in CF will give you the best answer. Nick ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238247 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: Evaluate vs ?
if you generate the content files and save them as static files, you can just cfinclude them into your cfmail then you won't need to evaluate them. BTW, if your sending out that much mail, I hope you have a dedicated SMTP server and are not using the SMTP on IIS. Russ -Original Message- From: Charles Sheehan-Miles [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Date: Wed, 19 Apr 2006 23:19:13 -0400 Subject: Re: Evaluate vs ? I'm going to have to do some serious thinking about this. Performance on the mailer is a lot slower than I'd like, and I suspect its because I'm using evaluate. Here's what happens: 1) Customer saves their message content, which might look something like: Dear #firstname# #lastname#: Blah blah blah 2) When they approve the message for sending, I queue the messages as: MessageID (referencing the previous message) MemberID (referencing the member tables which contain all the information) It then cfloops through each memberid, using evaluate to put in the correct member information, and generates personalized emails. I'm not the strongest programmer in the world, so this took some time to work out. Biggest issue is I'm shortly taking on a much larger customer than I've dealt with before, so mailing sizes will increase from 20-30k per mailing to upwards of 200-300k messages. Problem is, I have no way of knowing what the message content will be before its sent, nor which variables the customer will choose to use in a particular mailing (they have about 45 fields to choose from). Hmm. On 4/19/06 4:20 AM, Russ Michaels [EMAIL PROTECTED] wrote: the variable must exist or you cannot evaluate it. In my example I specified saving the content to a file and cfincluding it, which is not what you have done below. This works fine for what you want below. cfset content = this is some dynamic content cfset foo = This is static content. #content# cfoutput #foo# /cfoutput Here is an example of evaluating an external file. cfset content = this is some dynamic content cfsavecontent variable=contentfile cfinclude template=content.cfm /cfsavecontent content from file:br br cfoutput #evaluate(de(contentfile))# /cfoutput -- Russ (snake) Michaels -Original Message- From: Bruce, Rodney S C-E LCMC HQISEC/Signal Solutions [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Date: Tue, 18 Apr 2006 13:30:08 -0700 Subject: RE: Evaluate vs ? Ok, guess I am missing something here: cfset foo = fee fi fo fum #variable# this is dynamic content If #variable# is not set CF errors, If #variable# is set puts value into foo. CFOUTPUT #foo#---foo would output to be fee fi fo fum #variable# this is dynamic content is what was wanted?? /CFOUTPUT -not necessarily outputted, but to still contains the #variable# unresolved? This will set that up: cfset foo = fee fi fo fum ##variable## this is dynamic content But even using evaluate, this errors with (Invalid CFML construct found): cfset variable = fub cfoutput #evaluate(foo)# /cfoutput And just to test, this errors if #variable# is not set cfset foo = Evaluate(fee fi fo fum #variable# this is dynamic content) Can you show were this would work and be used, with evaluate? Have me curious now. -Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 18, 2006 12:24 PM To: CF-Talk Subject: Re: Evaluate vs ? This does the same thing as his: cfset foo = fee fi fo fum #variable# this is dynamic content My guess is he was saying for the value of variable to not be put into foo until the time that it was outputed instead of when set. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238248 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: RSS Aggregation?
That could be. I vaguely remember that the spec wasn't final, but was very, very close. This was probably 6 months ago or so. Maybe that timeline will tell you something. And I did use the wiki several times so who knows what insanity I mixed in. :-) I'll go back and take a look at my code to see what I did or whether my memory is just bad and I'll post back to this thread in case anyone's interested. On 4/20/06, Roger Benningfield [EMAIL PROTECTED] wrote: I surely thought I remembered one from when I built my reader. Rob: Could it have been one of the interim specs you were looking at? 'Cause there was all kinds of odd stuff in there at certain points... particularly in the pre-IETF drafts. In addition, there was (and is) a lotta stuff on the wiki that is foreign to the spec as well, which can be pretty confusing to implementors. -- Roger ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238249 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 String Byte Size
Thanks, all. These suggestions will get me close enough for what I need. Fortunately, this data isn't required for anything essential. I appreciate all the help. On 4/20/06, Ashwin Mathew [EMAIL PROTECTED] wrote: Try this: http://martin.nobilitas.com/java/sizeof.html The empirical formula derived there indicates that string memory is 38+/-2 + 2*(string length) bytes. In my own tests on JDK 1.4.2_09 I got something similar: 40 + 2*(string length) bytes when length2. For length 0 to 2, the size works out to just 40 bytes. That said, as Nick mentions, if all that you're trying to do is get an idea of the relative memory occupied by different strings, rather than the actual physical memory (which, as discussed in the link above, can be determined only empirically, not precisely), you might be best off just checking the length. -Original Message- From: Nick de Voil [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 19, 2006 9:47 PM To: CF-Talk Subject: Re: Get String Byte Size Anyone have any quick code to retrieve the number of bytes in a string /without/ writing the string to a file first? I'm trying to do a little debugging and I'd like to know the size of a string that is being returned to the browser. The number of bytes occupied in the application's memory by the Java String object is probably not the same as the number of bytes occupied by the same string in the HTTP response. I could be wrong on some points below but I'm sure others will correct me if so (Paul?) As I understand it, a Java program such as CF always stores characters internally using UCS-2 encoding, i.e. 2 bytes per character. In addition, the String object will include 20 or 30 extra bytes for storing the length of the string etc. I believe that CF's default behaviour is to encode HTTP responses using UTF-8 encoding, i.e. 1 byte per character if you're only using ASCII characters, and of course the extra bytes used by the String object won't be there either. So let's say your string is Rob. - In CF the Len() function gives you 3. - The size of the Java object - even if you could work it out, which is next to impossible in Java - would be 6 + the extra bytes, maybe 40 or more. - But in the HTTP response it would probably be 3. So, if I've understood your question correctly and it's the HTTP response you're interested in, just using Len() in CF will give you the best answer. Nick ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238250 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: StructFindKey Path and evaluate
On Wednesday 19 April 2006 17:24, Bruce, Rodney S C-E LCMC HQISEC/Signal Solutions wrote: If there is a better way to do this, please let me know. I don't really like the way I am doing it, but unfortunetly I havent come up with anything better and I do seem to do things the hard way. Getting the DB to do the maths ? -- Tom Chiverton Advanced ColdFusion Programmer ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238251 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: BEA licenses BlueDragon for WebLogic
On Wednesday 19 April 2006 16:26, Russ Michaels wrote: I have seen several benefits. Don't get me wrong, I think it's a Good Thing. I'm not going to be writting anything that uses BD only tags though - look where doing that with IE got us a few years back :-) -- Tom Chiverton Advanced ColdFusion Programmer ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238252 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: StructFindKey Path and evaluate
Yes, I was thinking that a cube of this would probably provide most of the desired info in a query (although I haven't looked closely enough to be sure). Does your DB do cube and rollup? On 4/20/06, Thomas Chiverton [EMAIL PROTECTED] wrote: On Wednesday 19 April 2006 17:24, Bruce, Rodney S C-E LCMC HQISEC/Signal Solutions wrote: If there is a better way to do this, please let me know. I don't really like the way I am doing it, but unfortunetly I havent come up with anything better and I do seem to do things the hard way. Getting the DB to do the maths ? -- CFAJAX docs and other useful articles: http://jr-holmes.coldfusionjournal.com/ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238253 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: RSS Aggregation?
On Wednesday 19 April 2006 15:43, Neil Middleton wrote: Currently the site is aggregating ~500 RSS feeds, but checking these feeds is growing to be a pain in the butt. Having to get CF to check each of these feeds regulary (ideally every 15 minutes) is more difficult than it sounds. Why not: Give each feed a 'last check time' Once every 5 minutes, pick the oldest and retrieve it, then update last check time to now. Also: I doubt most of your users check every 15 mins, so why does your site need to ? -- Tom Chiverton Advanced ColdFusion Programmer ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238254 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: CFMX JNDI datasources in BEA Weblogic 9.1
On Wednesday 19 April 2006 21:55, Andy Allan wrote: The crap, though official answer will most likely be that CFMX7.01 isn't supported on 9.1 - only 7 and 8.1 And all I can add is that we have it on 7 and running fine :-} -- Tom Chiverton Advanced ColdFusion Programmer ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238255 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: RSS Aggregation?
Well, what I have gone for as an interim is something similar. Every feed has a lastCheck time, and every minute, the app checks the oldest 10 feeds. Therefore each feed should get checked roughly hourly. Seems to be working well at the moment, I'll consider dropping the frequency once I know how this behaves.. Neil Why not: Give each feed a 'last check time' Once every 5 minutes, pick the oldest and retrieve it, then update last check time to now. Also: I doubt most of your users check every 15 mins, so why does your site need to ? -- Tom Chiverton Advanced ColdFusion Programmer ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238256 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: SOLVED Re: Query works MySQL 4 but not 5
Subqueries aren't even allowed in versions lower than 4.1.3. !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Josh Nathanson [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 19, 2006 7:07 PM To: CF-Talk Subject: SOLVED Re: Query works MySQL 4 but not 5 My host is actually using MySQL 3, not 5 as I thought, and subqueries are not allowed on MySQL 3. Crap. -- Josh ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238257 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: Using first CFC wih 6.1 (TRYING AGAIN)
Somebody cut that guy off! He's had too much to drink. !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Denny Valliant [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 19, 2006 8:03 PM To: CF-Talk Subject: Re: Using first CFC wih 6.1 (TRYING AGAIN) I was thinking more along the lines as any freaking coding system that doesn't have a single line comment is retarded. But I'm a retarded coder, so... :-) Heh. Seriously tho, the time I save isn't too related to the (apparently) old everything runs faster in cfscript, but more along the lines of being able to set vars fast and comment/uncomment with //. That alone saves so much freaking time. For me. Probably not for you if you don't code like I do- lots of commenting and uncommenting and setting of stuff. Even so, I don't use it everywhere. Also note that I don't like the whitespace... cfscript doesn't have any. Or whatever. That probably doesn't make too much sense. Eh. Yeah, I'd seen that blog a while back, thought it was sorta interesting, the comments moreso than the actual post. Guess I overlooked the bit about how it all compiles down to the same bytecode now. Filters, filters... I hear the FBI trains people in anti-filters. Search and Rescue as well- Seems when you're looking for something, people have a tendency to filter the other stuff. Bad habit. I keep trying to be more observant, less oblivious... I obviously need more practice. Thanks for pointing that one out again, when I was in a state of mind to pick up on some relevant info. Hard to purge the cfloop is not slow idea. nnnugh! Ok, purged. Still like the // comments. :dEn On 4/18/06, Munson, Jacob [EMAIL PROTECTED] wrote: Getting into cfscript will save you time too This is debatable. Check out Joe Rinehart's blog entry on the subject, and the subsequent debate in the comments: http://clearsoftware.net/index.cfm?mode=entryentry=99555B13-E081-2BAC-6 978E64EF78CE668 --- This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A1. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238258 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: Ruby (on Rails) vs Coldfusion
That's pretty cool. !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 19, 2006 8:29 PM To: CF-Talk Subject: Re: Ruby (on Rails) vs Coldfusion On 4/19/06, Andy Matthews [EMAIL PROTECTED] wrote: I don't want to use the command prompt. It's clunky, outdated and a pain to get around. I'm enough of a visual person that it makes FAR more sense (to ME) to use a visual interface to do things. Then use RadRails in Eclipse and click the button that launches the generate script. I don't understand how that's a lot more visual, but it's just as easy. Why can't they just code it so that you load up a page in localhost/ruby and type in the same things you'd type into the command line? You mean like this? :) http://tryruby.hobix.com/ -- John Paul Ashenfelter CTO/Transitionpoint (blog) http://www.ashenfelter.com (email) [EMAIL PROTECTED] ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238259 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: Ruby (on Rails) vs Coldfusion
Thanks again John...appreciated! !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 19, 2006 8:33 PM To: CF-Talk Subject: Re: Ruby (on Rails) vs Coldfusion On 4/19/06, Andy Matthews [EMAIL PROTECTED] wrote: Wow... What a great conversation! Here's what I want to accomplish in my testing of RoR. I want to be able to view the parsed files in my local dev setup, currently using XAMPP. Not sure what you mean by parsed files. Ruby is interpreted if you mean the files that are _generated_ by the command lines scripts in Ruby (or the RadRails GUI or what have you), then they're right there in your app directory. Running Ruby in a server environment requires cgi, fastcgi, scgi or the like. If you're comfortable with XAMPP, then you might want to look at InstantRails -- it's based on the XAMPP distro (and even includes PHP4 and MySQL) and gives you, well, and Instant Rails environment that does not interact with the rest of your system. I really would prefer NOT having to start the Ruby server, just a preference there I guess. The whole point of me wanting to learn a new language/structure is to try and save time, not spend it. No problem, but it's *far* easier when you're learning to use the webbrick server (Ruby server) instead of dealing with fastcgi/etc (*especially* on Windows). If you're on Windows, InstantRails is your fastest path while Locomotive gets you running quickly on OSX. -- John Paul Ashenfelter CTO/Transitionpoint (blog) http://www.ashenfelter.com (email) [EMAIL PROTECTED] ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238260 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: RSS Aggregation?
So, based on Roger's comments, I checked my code and, in fact, there is no Atom 1.0 element analogous to TTL. And I didn't make one up for inclusion in my code. :-) Thanks for the clarification. On 4/20/06, Roger Benningfield [EMAIL PROTECTED] wrote: I surely thought I remembered one from when I built my reader. Rob: Could it have been one of the interim specs you were looking at? 'Cause there was all kinds of odd stuff in there at certain points... particularly in the pre-IETF drafts. In addition, there was (and is) a lotta stuff on the wiki that is foreign to the spec as well, which can be pretty confusing to implementors. -- Roger ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238261 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
CFC documentation not being displayed
I'm breaking all of my SQL out into a CFC library as a first step towards supporting multiple database types. It's a pretyt sizeable task, and, obviously, I'd like to be able to reference the self-documenting features of CFC's. The problem is, when browsing directly to the CFC in the hopes of seeing the generated documentation (http://localhost/lib/cfc/mssql.cfc in my case) I get a blank page. Here's a snippet of my cfc: cfcomponent displayname=Microsoft SQL Server Component hint=This component contains all Microsoft SQL Server database access code. style=RPC output=Yes cfset msg = !--- Security Authentication --- cffunction name=login access=public description=Logs in user. output=No returntype=query cfargument name=username required=Yes type=string default= cfargument name=password required=no type=string default= cfstoredproc procedure=spAuthenticateUser datasource=#request.app.dsname# returncode=Yes cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbvarname=username value=#arguments.username# null=No cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbvarname=password value=#arguments.password# null=No cfprocresult name=loginQuery resultset=1 /cfstoredproc cfreturn loginQuery /cffunction /cfcomponent Anything obvious that I'm doing wrong? The methods all work perfectly, so I'm pretty sure it's not my code. I'm using MX7 on WinXP/IIS. Thanks, Pete ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238262 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
OT: Javascript help
Not really for CF, but though someone here could lend some insight
There is one problem in Javascript that I cannot seem to get a handle on and
it is killling me! I can't seem to get variables to pass by value as I would
hope. Take the following example:
for (var intI = 0 ; intI 10 ; intI++){
var objA = document.createElement( div );
// Set the click for the link.
objA.onclick = function(){ alert( intI ); };
// Set the link into the body div.
objDiv.appendChild( objA );
}
Now, in my head, each one of those links, when clicked should alert the
appropriate intI value (0, 1, 2, 3, etc.); however, each of them will alert
10 which is the value that broke the FOR loop. It's like they all point to
one variable and then get updated for each loop of the FOR iteration.
I can't seem to find a good solution to this. One method that seems to work,
but is poop is something along the lines of:
// Define a function INSIDE this function.
function GetI( intX ){
return(
function(){ alert(intX); };
);
}
for (var intI = 0 ; intI 10 ; intI++){
var objA = document.createElement( div );
// Set the click for the link.
objA.onclick = GetI( intX );
// Set the link into the body div.
objDiv.appendChild( objA );
}
This method works as would be expected, though I seem to think that it is
doing the exact same thing. It must be something to do with the scoping.
Since the intI value is getting passed to a local scope (int GetI()), and
then getting passed back, it must be unique (since the local scope of the
GetI() method is created unique of each FOR iteration.
This solution seems truly ganky to me. There has to be a better way. And
this is just a simple example. I have many places where I want to be doing
this with object reference and dynamic event handling. This one simple bumb
is really holding me back!
Please help!!!
...
Ben Nadel
www.bennadel.com
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238263
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: CFC documentation not being displayed
Do you have access to the cfide? In other words, can you get to the administrator? You must have the cfide available to get to that documentation I believe. On 4/20/06, Pete Ruckelshaus [EMAIL PROTECTED] wrote: I'm breaking all of my SQL out into a CFC library as a first step towards supporting multiple database types. It's a pretyt sizeable task, and, obviously, I'd like to be able to reference the self-documenting features of CFC's. The problem is, when browsing directly to the CFC in the hopes of seeing the generated documentation (http://localhost/lib/cfc/mssql.cfc in my case) I get a blank page. Here's a snippet of my cfc: cfcomponent displayname=Microsoft SQL Server Component hint=This component contains all Microsoft SQL Server database access code. style=RPC output=Yes cfset msg = !--- Security Authentication --- cffunction name=login access=public description=Logs in user. output=No returntype=query cfargument name=username required=Yes type=string default= cfargument name=password required=no type=string default= cfstoredproc procedure=spAuthenticateUser datasource=#request.app.dsname# returncode=Yes cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbvarname=username value=#arguments.username# null=No cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbvarname=password value=#arguments.password# null=No cfprocresult name=loginQuery resultset=1 /cfstoredproc cfreturn loginQuery /cffunction /cfcomponent Anything obvious that I'm doing wrong? The methods all work perfectly, so I'm pretty sure it's not my code. I'm using MX7 on WinXP/IIS. Thanks, Pete ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238264 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: CFC documentation not being displayed
Yes, it's on my local workstation. On 4/20/06, Ryan Guill [EMAIL PROTECTED] wrote: Do you have access to the cfide? In other words, can you get to the administrator? You must have the cfide available to get to that documentation I believe. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238265 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: CFC documentation not being displayed
I am not very familiar with the CFC doc viewer, but I believe it runs through CF Administrator. Try logging into CFAdmin first, then view the CFC. See if that helps. ... Ben Nadel www.bennadel.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238266 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: Evaluate vs ?
Performance on the mailer is a lot slower than I'd like, and I suspect its because I'm using evaluate. Here is a test I made on my develop system (3000 MHz): CFSET myStruct = structNew () CFSET myStruct.myvar = test CFSET start = GetTickCount() CFLOOP INDEX=i FROM=1 TO=10 CFSET test = evaluate (mystruct.myvar ) /CFLOOP CFOUTPUTTime = #numberFormat(GetTickCount()-start, 999)#BR/CFOUTPUT CFSET start = GetTickCount() CFLOOP INDEX=i FROM=1 TO=10 CFSET test = mystruct['myvar' ] /CFLOOP CFOUTPUTTime = #numberFormat(GetTickCount()-start, 999)#BR/CFOUTPUT The results are (in avarage): Time = 530 msec Time = 200 msec This show that 1. evaluate takes more than twice the double than struct notation; 2. the difference is about 1/3 sec for 10 iteration, then, unless you really use evaluate in some million iterations loop, the difference is not really significant. There are many other places to look for optimization, the first being queries and correct indexes in the database. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238267 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: Why is there query.recordcount with non-SELECT queries?
Well I have been using JDBC Statement call from CF and it will return you number of records effected for updated, inserts or deletes. Really? Then CF has no excuse anymore. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238268 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: CFC documentation not being displayed
I logged in to cfadmin and then browsed to the CFC, still no dice. On 4/20/06, Ben Nadel [EMAIL PROTECTED] wrote: I am not very familiar with the CFC doc viewer, but I believe it runs through CF Administrator. Try logging into CFAdmin first, then view the CFC. See if that helps. ... Ben Nadel www.bennadel.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238269 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 String Byte Size
Wouldn't that just be len(string) ? ..:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Rob Wilkerson [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 19, 2006 9:28 AM To: CF-Talk Subject: Get String Byte Size Anyone have any quick code to retrieve the number of bytes in a string /without/ writing the string to a file first? I'm trying to do a little debugging and I'd like to know the size of a string that is being returned to the browser. Thanks. -- Rob Wilkerson ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238270 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: Get String Byte Size
Or len(string) * 8? Isn't each ascii character one byte? Or is it one bit? And it it is wouldn't just be len(string) / 8? -- Timothy Heald Analyst, Architect, Developer [EMAIL PROTECTED] W: 202-228-8372 C: 703-300-3911 -Original Message- From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] Sent: Thursday, April 20, 2006 10:00 AM To: CF-Talk Subject: RE: Get String Byte Size Wouldn't that just be len(string) ? ...:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Rob Wilkerson [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 19, 2006 9:28 AM To: CF-Talk Subject: Get String Byte Size Anyone have any quick code to retrieve the number of bytes in a string /without/ writing the string to a file first? I'm trying to do a little debugging and I'd like to know the size of a string that is being returned to the browser. Thanks. -- Rob Wilkerson ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238271 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: Javascript help
The onclicks are outside of the loop
..:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
-Original Message-
From: Ben Nadel [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 20, 2006 9:35 AM
To: CF-Talk
Subject: OT: Javascript help
Not really for CF, but though someone here could lend some insight
There is one problem in Javascript that I cannot seem to get a handle on and
it is killling me! I can't seem to get variables to pass by value as I would
hope. Take the following example:
for (var intI = 0 ; intI 10 ; intI++){
var objA = document.createElement( div );
// Set the click for the link.
objA.onclick = function(){ alert( intI ); };
// Set the link into the body div.
objDiv.appendChild( objA );
}
Now, in my head, each one of those links, when clicked should alert the
appropriate intI value (0, 1, 2, 3, etc.); however, each of them will alert
10 which is the value that broke the FOR loop. It's like they all point to
one variable and then get updated for each loop of the FOR iteration.
I can't seem to find a good solution to this. One method that seems to work,
but is poop is something along the lines of:
// Define a function INSIDE this function.
function GetI( intX ){
return(
function(){ alert(intX); };
);
}
for (var intI = 0 ; intI 10 ; intI++){
var objA = document.createElement( div );
// Set the click for the link.
objA.onclick = GetI( intX );
// Set the link into the body div.
objDiv.appendChild( objA );
}
This method works as would be expected, though I seem to think that it is
doing the exact same thing. It must be something to do with the scoping.
Since the intI value is getting passed to a local scope (int GetI()), and
then getting passed back, it must be unique (since the local scope of the
GetI() method is created unique of each FOR iteration.
This solution seems truly ganky to me. There has to be a better way. And
this is just a simple example. I have many places where I want to be doing
this with object reference and dynamic event handling. This one simple bumb
is really holding me back!
Please help!!!
Ben Nadel
www.bennadel.com
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238272
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 String Byte Size
That just returns the number of characters, not the file size those characters would have. !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] Sent: Thursday, April 20, 2006 9:00 AM To: CF-Talk Subject: RE: Get String Byte Size Wouldn't that just be len(string) ? ...:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Rob Wilkerson [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 19, 2006 9:28 AM To: CF-Talk Subject: Get String Byte Size Anyone have any quick code to retrieve the number of bytes in a string /without/ writing the string to a file first? I'm trying to do a little debugging and I'd like to know the size of a string that is being returned to the browser. Thanks. -- Rob Wilkerson ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238273 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: Javascript help
Bobby,
I don't think they are, it might just parse weird for CFTalk... However,
this is just sample code that I wrote in the email, so it might not be 100%
accurate. But, in real test cases, when I do put the onclick I nthe FOR
loop, they still all alert the same number.
...
Ben Nadel
www.bennadel.com
-Original Message-
From: Bobby Hartsfield [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 20, 2006 10:06 AM
To: CF-Talk
Subject: RE: Javascript help
The onclicks are outside of the loop
...:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
-Original Message-
From: Ben Nadel [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 20, 2006 9:35 AM
To: CF-Talk
Subject: OT: Javascript help
Not really for CF, but though someone here could lend some insight
There is one problem in Javascript that I cannot seem to get a handle on and
it is killling me! I can't seem to get variables to pass by value as I would
hope. Take the following example:
for (var intI = 0 ; intI 10 ; intI++){ var objA = document.createElement(
div );
// Set the click for the link.
objA.onclick = function(){ alert( intI ); };
// Set the link into the body div.
objDiv.appendChild( objA );
}
Now, in my head, each one of those links, when clicked should alert the
appropriate intI value (0, 1, 2, 3, etc.); however, each of them will alert
10 which is the value that broke the FOR loop. It's like they all point to
one variable and then get updated for each loop of the FOR iteration.
I can't seem to find a good solution to this. One method that seems to work,
but is poop is something along the lines of:
// Define a function INSIDE this function.
function GetI( intX ){
return(
function(){ alert(intX); };
);
}
for (var intI = 0 ; intI 10 ; intI++){ var objA = document.createElement(
div );
// Set the click for the link.
objA.onclick = GetI( intX );
// Set the link into the body div.
objDiv.appendChild( objA );
}
This method works as would be expected, though I seem to think that it is
doing the exact same thing. It must be something to do with the scoping.
Since the intI value is getting passed to a local scope (int GetI()), and
then getting passed back, it must be unique (since the local scope of the
GetI() method is created unique of each FOR iteration.
This solution seems truly ganky to me. There has to be a better way. And
this is just a simple example. I have many places where I want to be doing
this with object reference and dynamic event handling. This one simple bumb
is really holding me back!
Please help!!!
.
Ben Nadel
www.bennadel.com
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238274
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: Javascript help
Maybe I'll get caffeine in me before I answer the next one. I'll take a
closer look ;-)
..:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
-Original Message-
From: Ben Nadel [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 20, 2006 9:35 AM
To: CF-Talk
Subject: OT: Javascript help
Not really for CF, but though someone here could lend some insight
There is one problem in Javascript that I cannot seem to get a handle on and
it is killling me! I can't seem to get variables to pass by value as I would
hope. Take the following example:
for (var intI = 0 ; intI 10 ; intI++){
var objA = document.createElement( div );
// Set the click for the link.
objA.onclick = function(){ alert( intI ); };
// Set the link into the body div.
objDiv.appendChild( objA );
}
Now, in my head, each one of those links, when clicked should alert the
appropriate intI value (0, 1, 2, 3, etc.); however, each of them will alert
10 which is the value that broke the FOR loop. It's like they all point to
one variable and then get updated for each loop of the FOR iteration.
I can't seem to find a good solution to this. One method that seems to work,
but is poop is something along the lines of:
// Define a function INSIDE this function.
function GetI( intX ){
return(
function(){ alert(intX); };
);
}
for (var intI = 0 ; intI 10 ; intI++){
var objA = document.createElement( div );
// Set the click for the link.
objA.onclick = GetI( intX );
// Set the link into the body div.
objDiv.appendChild( objA );
}
This method works as would be expected, though I seem to think that it is
doing the exact same thing. It must be something to do with the scoping.
Since the intI value is getting passed to a local scope (int GetI()), and
then getting passed back, it must be unique (since the local scope of the
GetI() method is created unique of each FOR iteration.
This solution seems truly ganky to me. There has to be a better way. And
this is just a simple example. I have many places where I want to be doing
this with object reference and dynamic event handling. This one simple bumb
is really holding me back!
Please help!!!
Ben Nadel
www.bennadel.com
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238275
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
grouping by date
I have an event table that I need to output the data in a specific fashion, based on dates, like so: April 19th event1 event2 event3 26th event4 event5 30th event6 event7 event8 May 1st event10 event11 17th event12 June etc I have the date stored as a date type in the DB. What's the best way to go about outputting the events, grouped as above? I've come up with some elaborate workarounds, but they seem clunky and not very maintenance-friendly. For argument's sake, let's say the current select statement looks like this: SELECT startdate, event_title FROM events WHERE active=1 ORDER BY startdate ASC Thanks, Ray ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238276 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 String Byte Size
Oops yes, / 8 The OS and cluster sizes may also make a difference ;-) ..:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Loathe [mailto:[EMAIL PROTECTED] Sent: Thursday, April 20, 2006 10:05 AM To: CF-Talk Subject: RE: Get String Byte Size Or len(string) * 8? Isn't each ascii character one byte? Or is it one bit? And it it is wouldn't just be len(string) / 8? -- Timothy Heald Analyst, Architect, Developer [EMAIL PROTECTED] W: 202-228-8372 C: 703-300-3911 -Original Message- From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] Sent: Thursday, April 20, 2006 10:00 AM To: CF-Talk Subject: RE: Get String Byte Size Wouldn't that just be len(string) ? :.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Rob Wilkerson [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 19, 2006 9:28 AM To: CF-Talk Subject: Get String Byte Size Anyone have any quick code to retrieve the number of bytes in a string /without/ writing the string to a file first? I'm trying to do a little debugging and I'd like to know the size of a string that is being returned to the browser. Thanks. -- Rob Wilkerson ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238277 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: Javascript help
The loop is fine. It's difficult to see the braces in the text, but
they're correct. Maybe you can't pass objects by value? You would
think that, if it were possible, using the var keyword would ensure a
new variable.
On 4/20/06, Ben Nadel [EMAIL PROTECTED] wrote:
Bobby,
I don't think they are, it might just parse weird for CFTalk... However,
this is just sample code that I wrote in the email, so it might not be 100%
accurate. But, in real test cases, when I do put the onclick I nthe FOR
loop, they still all alert the same number.
...
Ben Nadel
www.bennadel.com
-Original Message-
From: Bobby Hartsfield [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 20, 2006 10:06 AM
To: CF-Talk
Subject: RE: Javascript help
The onclicks are outside of the loop
...:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
-Original Message-
From: Ben Nadel [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 20, 2006 9:35 AM
To: CF-Talk
Subject: OT: Javascript help
Not really for CF, but though someone here could lend some insight
There is one problem in Javascript that I cannot seem to get a handle on and
it is killling me! I can't seem to get variables to pass by value as I would
hope. Take the following example:
for (var intI = 0 ; intI 10 ; intI++){ var objA = document.createElement(
div );
// Set the click for the link.
objA.onclick = function(){ alert( intI ); };
// Set the link into the body div.
objDiv.appendChild( objA );
}
Now, in my head, each one of those links, when clicked should alert the
appropriate intI value (0, 1, 2, 3, etc.); however, each of them will alert
10 which is the value that broke the FOR loop. It's like they all point to
one variable and then get updated for each loop of the FOR iteration.
I can't seem to find a good solution to this. One method that seems to work,
but is poop is something along the lines of:
// Define a function INSIDE this function.
function GetI( intX ){
return(
function(){ alert(intX); };
);
}
for (var intI = 0 ; intI 10 ; intI++){ var objA = document.createElement(
div );
// Set the click for the link.
objA.onclick = GetI( intX );
// Set the link into the body div.
objDiv.appendChild( objA );
}
This method works as would be expected, though I seem to think that it is
doing the exact same thing. It must be something to do with the scoping.
Since the intI value is getting passed to a local scope (int GetI()), and
then getting passed back, it must be unique (since the local scope of the
GetI() method is created unique of each FOR iteration.
This solution seems truly ganky to me. There has to be a better way. And
this is just a simple example. I have many places where I want to be doing
this with object reference and dynamic event handling. This one simple bumb
is really holding me back!
Please help!!!
.
Ben Nadel
www.bennadel.com
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238278
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: Gzip content from a variable
Thanks dan this is just what I was looking for! gabe -Original Message- From: Dan G. Switzer, II [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 19, 2006 10:41 AM To: CF-Talk Subject: RE: Gzip content from a variable Gabe, I have been using cf_gzip for a while but would like to improve performance. Right now it reads a file, then writes a gzip'd file. Then I have to read that file and dish back to user. I would like to just pass in the content as a variable, then get back a variable with the gzip'd data. Ignore all the file business. Anyone know of anything pre built or up for a challenge? I worked up a solution a few months ago: http://blog.pengoworks.com/blogger/index.cfm?action=blog:501 I was working on a Windows app where we were sending large XML packets to the server and decided we'd GZip the XML before sending. The UDF in my blog entry should take a GZipped string and unzip back to a string. I did not test this w/any binary data--only w/XML files. -Dan ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238279 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: CFC documentation not being displayed
you should get either the admin password screen or if no password on localhost it should change the url to something like http://localhost/CFIDE/componentutils/cfcexplorer.cfc?method=getcfcinhtmlname=yourdotnotation.yourcfcpath=/yourpath/yourcfc.cfc On 4/20/06, Pete Ruckelshaus [EMAIL PROTECTED] wrote: I logged in to cfadmin and then browsed to the CFC, still no dice. On 4/20/06, Ben Nadel [EMAIL PROTECTED] wrote: I am not very familiar with the CFC doc viewer, but I believe it runs through CF Administrator. Try logging into CFAdmin first, then view the CFC. See if that helps. ... Ben Nadel www.bennadel.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238280 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: grouping by date
This might not be the best solutions, but what if you did: SELECT startdate, event_title, ( YEAR(startdate) ) AS event_year, ( MONTH(startdate) ) AS event_month, ( DAY(startdate) ) AS event_day FROM events WHERE active=1 ORDER BY startdate ASC Then, on the output you could do a CFOutput and GroupBy the event year, then month, then day? I rarely use the group by in Cfoutput, so not exactly sure of the best methodology. ... Ben Nadel www.bennadel.com -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Thursday, April 20, 2006 10:13 AM To: CF-Talk Subject: grouping by date I have an event table that I need to output the data in a specific fashion, based on dates, like so: April 19th event1 event2 event3 26th event4 event5 30th event6 event7 event8 May 1st event10 event11 17th event12 June etc I have the date stored as a date type in the DB. What's the best way to go about outputting the events, grouped as above? I've come up with some elaborate workarounds, but they seem clunky and not very maintenance-friendly. For argument's sake, let's say the current select statement looks like this: SELECT startdate, event_title FROM events WHERE active=1 ORDER BY startdate ASC Thanks, Ray ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238281 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: grouping by date
I typically do my own groupings cfset curMonth= cfset curDay= cfloop query= cfif month(date) neq curMonth #month# cfset curmonth=month(date) cfset curDate= /cfif cfif day(date) neq curDay #day# cfset curDay=day(date) /cfif #date line# /cfloop On 4/20/06, Ray Champagne [EMAIL PROTECTED] wrote: I have an event table that I need to output the data in a specific fashion, based on dates, like so: April 19th event1 event2 event3 26th event4 event5 30th event6 event7 event8 May 1st event10 event11 17th event12 June etc I have the date stored as a date type in the DB. What's the best way to go about outputting the events, grouped as above? I've come up with some elaborate workarounds, but they seem clunky and not very maintenance-friendly. For argument's sake, let's say the current select statement looks like this: SELECT startdate, event_title FROM events WHERE active=1 ORDER BY startdate ASC Thanks, Ray ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238282 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: grouping by date
What RDBMS? In Oracle you can do something like this: SELECT extract(month from startdate) as event_month, extract(day from startdate) as event_day, event_title FROM events WHERE active=1 ORDER BY startdate ASC -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Thursday, April 20, 2006 10:13 AM To: CF-Talk Subject: grouping by date I have an event table that I need to output the data in a specific fashion, based on dates, like so: April 19th event1 event2 event3 26th event4 event5 30th event6 event7 event8 May 1st event10 event11 17th event12 June etc I have the date stored as a date type in the DB. What's the best way to go about outputting the events, grouped as above? I've come up with some elaborate workarounds, but they seem clunky and not very maintenance-friendly. For argument's sake, let's say the current select statement looks like this: SELECT startdate, event_title FROM events WHERE active=1 ORDER BY startdate ASC Thanks, Ray ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238283 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: grouping by date
SQL Server 2K, sorry. Everett, Al (NIH/NIGMS) [C] wrote: What RDBMS? In Oracle you can do something like this: SELECT extract(month from startdate) as event_month, extract(day from startdate) as event_day, event_title FROM events WHERE active=1 ORDER BY startdate ASC -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Thursday, April 20, 2006 10:13 AM To: CF-Talk Subject: grouping by date I have an event table that I need to output the data in a specific fashion, based on dates, like so: April 19th event1 event2 event3 26th event4 event5 30th event6 event7 event8 May 1st event10 event11 17th event12 June etc I have the date stored as a date type in the DB. What's the best way to go about outputting the events, grouped as above? I've come up with some elaborate workarounds, but they seem clunky and not very maintenance-friendly. For argument's sake, let's say the current select statement looks like this: SELECT startdate, event_title FROM events WHERE active=1 ORDER BY startdate ASC Thanks, Ray ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238284 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: grouping by date
SELECT year(date) as year, Month(date) as month, Day(date) as day FROM yourtable ORDER BY year, month, day then simply use the group attribute of cfoutput. !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Thursday, April 20, 2006 9:13 AM To: CF-Talk Subject: grouping by date I have an event table that I need to output the data in a specific fashion, based on dates, like so: April 19th event1 event2 event3 26th event4 event5 30th event6 event7 event8 May 1st event10 event11 17th event12 June etc I have the date stored as a date type in the DB. What's the best way to go about outputting the events, grouped as above? I've come up with some elaborate workarounds, but they seem clunky and not very maintenance-friendly. For argument's sake, let's say the current select statement looks like this: SELECT startdate, event_title FROM events WHERE active=1 ORDER BY startdate ASC Thanks, Ray ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238285 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: OT: Javascript help
the most I can think of is to evaluate the value right at the function
declaration:
objA.onclick = eval ('function(){ alert( ' + intI + ' ); };');
On 4/20/06, Ben Nadel [EMAIL PROTECTED] wrote:
Not really for CF, but though someone here could lend some insight
There is one problem in Javascript that I cannot seem to get a handle on
and
it is killling me! I can't seem to get variables to pass by value as I
would
hope. Take the following example:
for (var intI = 0 ; intI 10 ; intI++){
var objA = document.createElement( div );
// Set the click for the link.
objA.onclick = function(){ alert( intI ); };
// Set the link into the body div.
objDiv.appendChild( objA );
}
Now, in my head, each one of those links, when clicked should alert the
appropriate intI value (0, 1, 2, 3, etc.); however, each of them will
alert
10 which is the value that broke the FOR loop. It's like they all point to
one variable and then get updated for each loop of the FOR iteration.
I can't seem to find a good solution to this. One method that seems to
work,
but is poop is something along the lines of:
// Define a function INSIDE this function.
function GetI( intX ){
return(
function(){ alert(intX); };
);
}
for (var intI = 0 ; intI 10 ; intI++){
var objA = document.createElement( div );
// Set the click for the link.
objA.onclick = GetI( intX );
// Set the link into the body div.
objDiv.appendChild( objA );
}
This method works as would be expected, though I seem to think that it is
doing the exact same thing. It must be something to do with the scoping.
Since the intI value is getting passed to a local scope (int GetI()), and
then getting passed back, it must be unique (since the local scope of the
GetI() method is created unique of each FOR iteration.
This solution seems truly ganky to me. There has to be a better way. And
this is just a simple example. I have many places where I want to be doing
this with object reference and dynamic event handling. This one simple
bumb
is really holding me back!
Please help!!!
...
Ben Nadel
www.bennadel.com
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238286
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: grouping by date
Hi Ray Add the date parts to your select using date functions e.g. startdate_year, startdate_month and startdate_day. add a 'group by startdate_year, startdate_month, startdate_day' clause to your query and then take a look at the 'group' attribute on cfoutput. (I've added in year so that spanning a long period will not be ambiguous) Mike T On 4/20/06, Ray Champagne [EMAIL PROTECTED] wrote: I have an event table that I need to output the data in a specific fashion, based on dates, like so: April 19th event1 event2 event3 26th event4 event5 30th event6 event7 event8 May 1st event10 event11 17th event12 June etc I have the date stored as a date type in the DB. What's the best way to go about outputting the events, grouped as above? I've come up with some elaborate workarounds, but they seem clunky and not very maintenance-friendly. For argument's sake, let's say the current select statement looks like this: SELECT startdate, event_title FROM events WHERE active=1 ORDER BY startdate ASC Thanks, Ray ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238287 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: OT: Javascript help
Zaphod,
I think that solution works for strings/numbers, but I would also like this
to work with object refrences ... Something like:
objMenu.onmouseover = function(){
objMenuSystem.Show(this);
}
The problem here is the same... When the mouse over fires, objMenuSystem
is no undefined since it tries to find it reference to the Menu, not the
varaible reference. But then again, if I wanted it to work my way, this
would be off too, since it would point to the housing method... Not the
objMenu... Hmmm .. .and ... Dangy!
...
Ben Nadel
www.bennadel.com
-Original Message-
From: Zaphod Beeblebrox [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 20, 2006 10:31 AM
To: CF-Talk
Subject: Re: OT: Javascript help
the most I can think of is to evaluate the value right at the function
declaration:
objA.onclick = eval ('function(){ alert( ' + intI + ' ); };');
On 4/20/06, Ben Nadel [EMAIL PROTECTED] wrote:
Not really for CF, but though someone here could lend some insight
There is one problem in Javascript that I cannot seem to get a handle
on and it is killling me! I can't seem to get variables to pass by
value as I would hope. Take the following example:
for (var intI = 0 ; intI 10 ; intI++){ var objA =
document.createElement( div );
// Set the click for the link.
objA.onclick = function(){ alert( intI ); };
// Set the link into the body div.
objDiv.appendChild( objA );
}
Now, in my head, each one of those links, when clicked should alert
the appropriate intI value (0, 1, 2, 3, etc.); however, each of them
will alert 10 which is the value that broke the FOR loop. It's like
they all point to one variable and then get updated for each loop of
the FOR iteration.
I can't seem to find a good solution to this. One method that seems to
work, but is poop is something along the lines of:
// Define a function INSIDE this function.
function GetI( intX ){
return(
function(){ alert(intX); };
);
}
for (var intI = 0 ; intI 10 ; intI++){ var objA =
document.createElement( div );
// Set the click for the link.
objA.onclick = GetI( intX );
// Set the link into the body div.
objDiv.appendChild( objA );
}
This method works as would be expected, though I seem to think that it
is doing the exact same thing. It must be something to do with the
scoping.
Since the intI value is getting passed to a local scope (int GetI()),
and then getting passed back, it must be unique (since the local scope
of the
GetI() method is created unique of each FOR iteration.
This solution seems truly ganky to me. There has to be a better way.
And this is just a simple example. I have many places where I want to
be doing this with object reference and dynamic event handling. This
one simple bumb is really holding me back!
Please help!!!
...
Ben Nadel
www.bennadel.com
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238288
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: Javascript help
Is this what you were going for?
html
body
div id=mainContainer/div
/body
/html
script
for (IntI = 0; IntI 10; IntI++)
{
divCont = document.createElement('DIV');
divCont.id = 'div' + IntI;
divCont.appendChild(document.createElement('BR'));
divCont.style.background='ececec';
divCont.style.borderColor = '00';
divCont.style.borderStyle = 'solid';
divCont.style.borderWidth = '1px';
divCont.setAttribute('onClick', 'alert(' + IntI + ')');
document.getElementById('mainContainer').appendChild(divCont);
document.getElementById('mainContainer').appendChild(document.createElement(
'BR'));
}
/script
The onclick of the divs wont work in IE 6-
..:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
-Original Message-
From: Ben Nadel [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 20, 2006 9:35 AM
To: CF-Talk
Subject: OT: Javascript help
Not really for CF, but though someone here could lend some insight
There is one problem in Javascript that I cannot seem to get a handle on and
it is killling me! I can't seem to get variables to pass by value as I would
hope. Take the following example:
for (var intI = 0 ; intI 10 ; intI++){
var objA = document.createElement( div );
// Set the click for the link.
objA.onclick = function(){ alert( intI ); };
// Set the link into the body div.
objDiv.appendChild( objA );
}
Now, in my head, each one of those links, when clicked should alert the
appropriate intI value (0, 1, 2, 3, etc.); however, each of them will alert
10 which is the value that broke the FOR loop. It's like they all point to
one variable and then get updated for each loop of the FOR iteration.
I can't seem to find a good solution to this. One method that seems to work,
but is poop is something along the lines of:
// Define a function INSIDE this function.
function GetI( intX ){
return(
function(){ alert(intX); };
);
}
for (var intI = 0 ; intI 10 ; intI++){
var objA = document.createElement( div );
// Set the click for the link.
objA.onclick = GetI( intX );
// Set the link into the body div.
objDiv.appendChild( objA );
}
This method works as would be expected, though I seem to think that it is
doing the exact same thing. It must be something to do with the scoping.
Since the intI value is getting passed to a local scope (int GetI()), and
then getting passed back, it must be unique (since the local scope of the
GetI() method is created unique of each FOR iteration.
This solution seems truly ganky to me. There has to be a better way. And
this is just a simple example. I have many places where I want to be doing
this with object reference and dynamic event handling. This one simple bumb
is really holding me back!
Please help!!!
Ben Nadel
www.bennadel.com
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238289
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: Javascript help
PS... in your original code
It's like they all point to
one variable and then get
updated for each loop of the FOR iteration
They do. Each of your onclicks triggered the same function that alerted the
same variable. The last time the variable was set, it was 10. So they are
all 10.
..:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
-Original Message-
From: Ben Nadel [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 20, 2006 9:35 AM
To: CF-Talk
Subject: OT: Javascript help
Not really for CF, but though someone here could lend some insight
There is one problem in Javascript that I cannot seem to get a handle on and
it is killling me! I can't seem to get variables to pass by value as I would
hope. Take the following example:
for (var intI = 0 ; intI 10 ; intI++){
var objA = document.createElement( div );
// Set the click for the link.
objA.onclick = function(){ alert( intI ); };
// Set the link into the body div.
objDiv.appendChild( objA );
}
Now, in my head, each one of those links, when clicked should alert the
appropriate intI value (0, 1, 2, 3, etc.); however, each of them will alert
10 which is the value that broke the FOR loop. It's like they all point to
one variable and then get updated for each loop of the FOR iteration.
I can't seem to find a good solution to this. One method that seems to work,
but is poop is something along the lines of:
// Define a function INSIDE this function.
function GetI( intX ){
return(
function(){ alert(intX); };
);
}
for (var intI = 0 ; intI 10 ; intI++){
var objA = document.createElement( div );
// Set the click for the link.
objA.onclick = GetI( intX );
// Set the link into the body div.
objDiv.appendChild( objA );
}
This method works as would be expected, though I seem to think that it is
doing the exact same thing. It must be something to do with the scoping.
Since the intI value is getting passed to a local scope (int GetI()), and
then getting passed back, it must be unique (since the local scope of the
GetI() method is created unique of each FOR iteration.
This solution seems truly ganky to me. There has to be a better way. And
this is just a simple example. I have many places where I want to be doing
this with object reference and dynamic event handling. This one simple bumb
is really holding me back!
Please help!!!
Ben Nadel
www.bennadel.com
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238290
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
Comma added
Every since I switched to CF 7 my code seems to add a comma in front of some fields when it does a search. See my code below. I don't have this in the Access dbase nor in my script. Is there an issue with CF 7? Are there any fixes or updates that address this? This problem cause searches to fail because its looking for ,NJ, for example, and not just NJ. Any workaround? Thanks Robert O. HWW My query displayed in debug: Getcustomer (Datasource=wweb, Time=0ms, Records=0) in D:\Inetpub\Intranet\Searchforms\wwebsearch\getwwebsearch.cfm @ 10:54:02.002 SELECT * FROM wweb where 0 = 0 And customer LIKE '%' And Institution LIKE '%' And State = ',AL' And country = ',0' ORDER BY ID DESC Code in script: CFIF IsDefined(FORM.customer) And customer LIKE '#FORM.customer#%' /CFIF CFIF IsDefined(FORM.Institution) And Institution LIKE '#FORM.Institution#%' /CFIF CFIF FORM.State NEQ 0 And State = '#FORM.State#' /CFIF CFIF FORM.country NEQ 0 And country = '#FORM.country#' /CFIF ORDER BY ID DESC /cfquery ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238291 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: Javascript help
Bobby,
I cannot seem to get the onCLick to fire in my browser. Granted I am using
IE in Homesite. But, my concern with this solution is that I feel (without
testing) that it is string dependent.
divCont.setAttribute('onClick', 'alert(' + IntI + ')');
That line is going to try to force intI to a string, which works for simple
values, but will not work with complex values.
...
Ben Nadel
www.bennadel.com
-Original Message-
From: Bobby Hartsfield [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 20, 2006 10:49 AM
To: CF-Talk
Subject: RE: Javascript help
Is this what you were going for?
html
body
div id=mainContainer/div
/body
/html
script
for (IntI = 0; IntI 10; IntI++)
{
divCont = document.createElement('DIV');
divCont.id = 'div' + IntI;
divCont.appendChild(document.createElement('BR'));
divCont.style.background='ececec';
divCont.style.borderColor = '00';
divCont.style.borderStyle = 'solid';
divCont.style.borderWidth = '1px';
divCont.setAttribute('onClick', 'alert(' + IntI + ')');
document.getElementById('mainContainer').appendChild(divCont);
document.getElementById('mainContainer').appendChild(document.createElement(
'BR'));
}
/script
The onclick of the divs wont work in IE 6-
...:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
-Original Message-
From: Ben Nadel [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 20, 2006 9:35 AM
To: CF-Talk
Subject: OT: Javascript help
Not really for CF, but though someone here could lend some insight
There is one problem in Javascript that I cannot seem to get a handle on and
it is killling me! I can't seem to get variables to pass by value as I would
hope. Take the following example:
for (var intI = 0 ; intI 10 ; intI++){ var objA = document.createElement(
div );
// Set the click for the link.
objA.onclick = function(){ alert( intI ); };
// Set the link into the body div.
objDiv.appendChild( objA );
}
Now, in my head, each one of those links, when clicked should alert the
appropriate intI value (0, 1, 2, 3, etc.); however, each of them will alert
10 which is the value that broke the FOR loop. It's like they all point to
one variable and then get updated for each loop of the FOR iteration.
I can't seem to find a good solution to this. One method that seems to work,
but is poop is something along the lines of:
// Define a function INSIDE this function.
function GetI( intX ){
return(
function(){ alert(intX); };
);
}
for (var intI = 0 ; intI 10 ; intI++){ var objA = document.createElement(
div );
// Set the click for the link.
objA.onclick = GetI( intX );
// Set the link into the body div.
objDiv.appendChild( objA );
}
This method works as would be expected, though I seem to think that it is
doing the exact same thing. It must be something to do with the scoping.
Since the intI value is getting passed to a local scope (int GetI()), and
then getting passed back, it must be unique (since the local scope of the
GetI() method is created unique of each FOR iteration.
This solution seems truly ganky to me. There has to be a better way. And
this is just a simple example. I have many places where I want to be doing
this with object reference and dynamic event handling. This one simple bumb
is really holding me back!
Please help!!!
.
Ben Nadel
www.bennadel.com
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238292
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: Comma added
Robert, This might happen if you were submitting the form field in two different places (like a hidden value as well)... The comma would be CF's attempt to pass the two values in as a list (comma delimited). Also, are you doing any sort of pre-page processing that might alter form fields?? Try putting in a CFDump on the FORM at the top of the processing page, see what is actually passed via the FORM. ... Ben Nadel www.bennadel.com -Original Message- From: Orlini, Robert [mailto:[EMAIL PROTECTED] Sent: Thursday, April 20, 2006 11:01 AM To: CF-Talk Subject: Comma added Every since I switched to CF 7 my code seems to add a comma in front of some fields when it does a search. See my code below. I don't have this in the Access dbase nor in my script. Is there an issue with CF 7? Are there any fixes or updates that address this? This problem cause searches to fail because its looking for ,NJ, for example, and not just NJ. Any workaround? Thanks Robert O. HWW My query displayed in debug: Getcustomer (Datasource=wweb, Time=0ms, Records=0) in D:\Inetpub\Intranet\Searchforms\wwebsearch\getwwebsearch.cfm @ 10:54:02.002 SELECT * FROM wweb where 0 = 0 And customer LIKE '%' And Institution LIKE '%' And State = ',AL' And country = ',0' ORDER BY ID DESC Code in script: CFIF IsDefined(FORM.customer) And customer LIKE '#FORM.customer#%' /CFIF CFIF IsDefined(FORM.Institution) And Institution LIKE '#FORM.Institution#%' /CFIF CFIF FORM.State NEQ 0 And State = '#FORM.State#' /CFIF CFIF FORM.country NEQ 0 And country = '#FORM.country#' /CFIF ORDER BY ID DESC /cfquery ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238293 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: Comma added
Check for multiple form fields with the same name being submitted. They will be appended into a comma delimited list. ~Brad -Original Message- From: Orlini, Robert [mailto:[EMAIL PROTECTED] Sent: Thursday, April 20, 2006 10:01 AM To: CF-Talk Subject: Comma added Every since I switched to CF 7 my code seems to add a comma in front of some fields when it does a search. See my code below. I don't have this in the Access dbase nor in my script. Is there an issue with CF 7? Are there any fixes or updates that address this? This problem cause searches to fail because its looking for ,NJ, for example, and not just NJ. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238294 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: Comma added
Are you using any list functions anywhere? !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Orlini, Robert [mailto:[EMAIL PROTECTED] Sent: Thursday, April 20, 2006 10:01 AM To: CF-Talk Subject: Comma added Every since I switched to CF 7 my code seems to add a comma in front of some fields when it does a search. See my code below. I don't have this in the Access dbase nor in my script. Is there an issue with CF 7? Are there any fixes or updates that address this? This problem cause searches to fail because its looking for ,NJ, for example, and not just NJ. Any workaround? Thanks Robert O. HWW My query displayed in debug: Getcustomer (Datasource=wweb, Time=0ms, Records=0) in D:\Inetpub\Intranet\Searchforms\wwebsearch\getwwebsearch.cfm @ 10:54:02.002 SELECT * FROM wweb where 0 = 0 And customer LIKE '%' And Institution LIKE '%' And State = ',AL' And country = ',0' ORDER BY ID DESC Code in script: CFIF IsDefined(FORM.customer) And customer LIKE '#FORM.customer#%' /CFIF CFIF IsDefined(FORM.Institution) And Institution LIKE '#FORM.Institution#%' /CFIF CFIF FORM.State NEQ 0 And State = '#FORM.State#' /CFIF CFIF FORM.country NEQ 0 And country = '#FORM.country#' /CFIF ORDER BY ID DESC /cfquery ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238295 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: grouping by date
Thanks everyone for the various solutions. My favorite was Andy's. Nice and clean, and minimal impact on the code I had already written. Andy, you win your choice of prizes from our infamous prize closet! :) Andy Matthews wrote: SELECT year(date) as year, Month(date) as month, Day(date) as day FROM yourtable ORDER BY year, month, day then simply use the group attribute of cfoutput. !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Thursday, April 20, 2006 9:13 AM To: CF-Talk Subject: grouping by date I have an event table that I need to output the data in a specific fashion, based on dates, like so: April 19th event1 event2 event3 26th event4 event5 30th event6 event7 event8 May 1st event10 event11 17th event12 June etc I have the date stored as a date type in the DB. What's the best way to go about outputting the events, grouped as above? I've come up with some elaborate workarounds, but they seem clunky and not very maintenance-friendly. For argument's sake, let's say the current select statement looks like this: SELECT startdate, event_title FROM events WHERE active=1 ORDER BY startdate ASC Thanks, Ray ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238296 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
OT: finding uk developers
I'm looking to find a UK CF developer for a 3(ish) month contract. Besides the cf-jobs list, can anyone recommend some popular places where people look for job postings or where potential employers can find developers? Thanks Gareth ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238297 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: Comma added
You're right Ben. That fixed it!. It was an old script I wrote many moons ago. Robert O. -Original Message- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: Thursday, April 20, 2006 11:04 AM To: CF-Talk Subject:RE: Comma added Robert, This might happen if you were submitting the form field in two different places (like a hidden value as well)... The comma would be CF's attempt to pass the two values in as a list (comma delimited). Also, are you doing any sort of pre-page processing that might alter form fields?? Try putting in a CFDump on the FORM at the top of the processing page, see what is actually passed via the FORM. Ben Nadel www.bennadel.com -Original Message- From: Orlini, Robert [mailto:[EMAIL PROTECTED] Sent: Thursday, April 20, 2006 11:01 AM To: CF-Talk Subject: Comma added Every since I switched to CF 7 my code seems to add a comma in front of some fields when it does a search. See my code below. I don't have this in the Access dbase nor in my script. Is there an issue with CF 7? Are there any fixes or updates that address this? This problem cause searches to fail because its looking for ,NJ, for example, and not just NJ. Any workaround? Thanks Robert O. HWW My query displayed in debug: Getcustomer (Datasource=wweb, Time=0ms, Records=0) in D:\Inetpub\Intranet\Searchforms\wwebsearch\getwwebsearch.cfm @ 10:54:02.002 SELECT * FROM wweb where 0 = 0 And customer LIKE '%' And Institution LIKE '%' And State = ',AL' And country = ',0' ORDER BY ID DESC Code in script: CFIF IsDefined(FORM.customer) And customer LIKE '#FORM.customer#%' /CFIF CFIF IsDefined(FORM.Institution) And Institution LIKE '#FORM.Institution#%' /CFIF CFIF FORM.State NEQ 0 And State = '#FORM.State#' /CFIF CFIF FORM.country NEQ 0 And country = '#FORM.country#' /CFIF ORDER BY ID DESC /cfquery ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238298 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: Comma added
Thanks -Original Message- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: Thursday, April 20, 2006 11:06 AM To: CF-Talk Subject:RE: Comma added Check for multiple form fields with the same name being submitted. They will be appended into a comma delimited list. ~Brad -Original Message- From: Orlini, Robert [mailto:[EMAIL PROTECTED] Sent: Thursday, April 20, 2006 10:01 AM To: CF-Talk Subject: Comma added Every since I switched to CF 7 my code seems to add a comma in front of some fields when it does a search. See my code below. I don't have this in the Access dbase nor in my script. Is there an issue with CF 7? Are there any fixes or updates that address this? This problem cause searches to fail because its looking for ,NJ, for example, and not just NJ. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238299 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: finding uk developers
www.scottishcfug.com Paul Stewart Site Developer [EMAIL PROTECTED] www.whichfranchise.com - Original Message - From: Gareth [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, April 20, 2006 4:09 PM Subject: OT: finding uk developers I'm looking to find a UK CF developer for a 3(ish) month contract. Besides the cf-jobs list, can anyone recommend some popular places where people look for job postings or where potential employers can find developers? Thanks Gareth ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238300 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: CFC documentation not being displayed
Michael, I just tried that, but no dice. Threw an error, looked like it was trying to pass me to the componentexplorer and told me that my method doesn't exist. However, after poking around a bit, I was able to see it listed in http://localhost/CFIDE/componentutils/componentdetail.cfm and was able to link to my CFC, which worked fine. Go figure. Thanks Pete On 4/20/06, Michael Traher [EMAIL PROTECTED] wrote: you should get either the admin password screen or if no password on localhost it should change the url to something like http://localhost/CFIDE/componentutils/cfcexplorer.cfc?method=getcfcinhtmlname=yourdotnotation.yourcfcpath=/yourpath/yourcfc.cfc On 4/20/06, Pete Ruckelshaus [EMAIL PROTECTED] wrote: I logged in to cfadmin and then browsed to the CFC, still no dice. On 4/20/06, Ben Nadel [EMAIL PROTECTED] wrote: I am not very familiar with the CFC doc viewer, but I believe it runs through CF Administrator. Try logging into CFAdmin first, then view the CFC. See if that helps. ... Ben Nadel www.bennadel.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238301 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: finding uk developers
Try getting the 2 UK based CF User Group managers to post something. One of them being Nik Richardson and the other being me :) www.scottishcfug.com www.ukcfug.org Andy On 20/04/06, Gareth [EMAIL PROTECTED] wrote: I'm looking to find a UK CF developer for a 3(ish) month contract. Besides the cf-jobs list, can anyone recommend some popular places where people look for job postings or where potential employers can find developers? Thanks Gareth ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238302 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: grouping by date
Wow... This list has given me so much, I'm just glad I could help out someone else. Got any chocolate or firearms in that closet? !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Thursday, April 20, 2006 10:09 AM To: CF-Talk Subject: Re: grouping by date Thanks everyone for the various solutions. My favorite was Andy's. Nice and clean, and minimal impact on the code I had already written. Andy, you win your choice of prizes from our infamous prize closet! :) Andy Matthews wrote: SELECT year(date) as year, Month(date) as month, Day(date) as day FROM yourtable ORDER BY year, month, day then simply use the group attribute of cfoutput. !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Thursday, April 20, 2006 9:13 AM To: CF-Talk Subject: grouping by date I have an event table that I need to output the data in a specific fashion, based on dates, like so: April 19th event1 event2 event3 26th event4 event5 30th event6 event7 event8 May 1st event10 event11 17th event12 June etc I have the date stored as a date type in the DB. What's the best way to go about outputting the events, grouped as above? I've come up with some elaborate workarounds, but they seem clunky and not very maintenance-friendly. For argument's sake, let's say the current select statement looks like this: SELECT startdate, event_title FROM events WHERE active=1 ORDER BY startdate ASC Thanks, Ray ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238303 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: grouping by date
Better. Firearms that shoot chocolate. m.chocolate shooting firearms.arh Andy Matthews wrote: Wow... This list has given me so much, I'm just glad I could help out someone else. Got any chocolate or firearms in that closet? !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Thursday, April 20, 2006 10:09 AM To: CF-Talk Subject: Re: grouping by date Thanks everyone for the various solutions. My favorite was Andy's. Nice and clean, and minimal impact on the code I had already written. Andy, you win your choice of prizes from our infamous prize closet! :) Andy Matthews wrote: SELECT year(date) as year, Month(date) as month, Day(date) as day FROM yourtable ORDER BY year, month, day then simply use the group attribute of cfoutput. !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Thursday, April 20, 2006 9:13 AM To: CF-Talk Subject: grouping by date I have an event table that I need to output the data in a specific fashion, based on dates, like so: April 19th event1 event2 event3 26th event4 event5 30th event6 event7 event8 May 1st event10 event11 17th event12 June etc I have the date stored as a date type in the DB. What's the best way to go about outputting the events, grouped as above? I've come up with some elaborate workarounds, but they seem clunky and not very maintenance-friendly. For argument's sake, let's say the current select statement looks like this: SELECT startdate, event_title FROM events WHERE active=1 ORDER BY startdate ASC Thanks, Ray ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238304 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: Ruby (on Rails) vs Coldfusion
Remember our class that provides this looks like this class Order ActiveRecord::Base end I could also do this Order.find_by_state(Virginia) Note that I'm not adding that method to the code. It just gets figured out. I can do this too Order.find_by_state_and_firstname(Virginia,Bob) Well John I'll have to investigate further. If you are saying that Ruby has built in methods in a buiult-in class called order, then that is pretty interesting. I may also have completely missed what you were saying ;-) I must say this line scares me: Note that I'm not adding that method to the code. It just gets figured out. I can do this too How the hell does it just know what to do with it if the method isn't even defined??? 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 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238305 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: grouping by date
And now it's time for Deep Thoughts with Jack Handy: I think a good gift for the President would be a chocolate revolver. And since he's so busy, you'd probably have to run up to him real quick and hand it to him. !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Thursday, April 20, 2006 10:44 AM To: CF-Talk Subject: Re: grouping by date Better. Firearms that shoot chocolate. m.chocolate shooting firearms.arh Andy Matthews wrote: Wow... This list has given me so much, I'm just glad I could help out someone else. Got any chocolate or firearms in that closet? !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Thursday, April 20, 2006 10:09 AM To: CF-Talk Subject: Re: grouping by date Thanks everyone for the various solutions. My favorite was Andy's. Nice and clean, and minimal impact on the code I had already written. Andy, you win your choice of prizes from our infamous prize closet! :) Andy Matthews wrote: SELECT year(date) as year, Month(date) as month, Day(date) as day FROM yourtable ORDER BY year, month, day then simply use the group attribute of cfoutput. !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Thursday, April 20, 2006 9:13 AM To: CF-Talk Subject: grouping by date I have an event table that I need to output the data in a specific fashion, based on dates, like so: April 19th event1 event2 event3 26th event4 event5 30th event6 event7 event8 May 1st event10 event11 17th event12 June etc I have the date stored as a date type in the DB. What's the best way to go about outputting the events, grouped as above? I've come up with some elaborate workarounds, but they seem clunky and not very maintenance-friendly. For argument's sake, let's say the current select statement looks like this: SELECT startdate, event_title FROM events WHERE active=1 ORDER BY startdate ASC Thanks, Ray ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238306 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: Ruby (on Rails) vs Coldfusion
The method IS defined, but in the background is what I guess he means. That does sound pretty cool. !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Thursday, April 20, 2006 10:53 AM To: CF-Talk Subject: Re: Ruby (on Rails) vs Coldfusion Remember our class that provides this looks like this class Order ActiveRecord::Base end I could also do this Order.find_by_state(Virginia) Note that I'm not adding that method to the code. It just gets figured out. I can do this too Order.find_by_state_and_firstname(Virginia,Bob) Well John I'll have to investigate further. If you are saying that Ruby has built in methods in a buiult-in class called order, then that is pretty interesting. I may also have completely missed what you were saying ;-) I must say this line scares me: Note that I'm not adding that method to the code. It just gets figured out. I can do this too How the hell does it just know what to do with it if the method isn't even defined??? 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 ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238307 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: grouping by date
:) Andy Matthews wrote: And now it's time for Deep Thoughts with Jack Handy: I think a good gift for the President would be a chocolate revolver. And since he's so busy, you'd probably have to run up to him real quick and hand it to him. !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Thursday, April 20, 2006 10:44 AM To: CF-Talk Subject: Re: grouping by date Better. Firearms that shoot chocolate. m.chocolate shooting firearms.arh Andy Matthews wrote: Wow... This list has given me so much, I'm just glad I could help out someone else. Got any chocolate or firearms in that closet? !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Thursday, April 20, 2006 10:09 AM To: CF-Talk Subject: Re: grouping by date Thanks everyone for the various solutions. My favorite was Andy's. Nice and clean, and minimal impact on the code I had already written. Andy, you win your choice of prizes from our infamous prize closet! :) Andy Matthews wrote: SELECT year(date) as year, Month(date) as month, Day(date) as day FROM yourtable ORDER BY year, month, day then simply use the group attribute of cfoutput. !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Thursday, April 20, 2006 9:13 AM To: CF-Talk Subject: grouping by date I have an event table that I need to output the data in a specific fashion, based on dates, like so: April 19th event1 event2 event3 26th event4 event5 30th event6 event7 event8 May 1st event10 event11 17th event12 June etc I have the date stored as a date type in the DB. What's the best way to go about outputting the events, grouped as above? I've come up with some elaborate workarounds, but they seem clunky and not very maintenance-friendly. For argument's sake, let's say the current select statement looks like this: SELECT startdate, event_title FROM events WHERE active=1 ORDER BY startdate ASC Thanks, Ray ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238308 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: Evaluate vs ?
I think that bites more people than not in regards to optimization. On 4/20/06, Claude Schneegans [EMAIL PROTECTED] wrote: There are many other places to look for optimization, the first being queries and correct indexes in the database. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238309 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: Javascript help
Asking your question of my javascipt list, the responses were as follows:
Repsonse 1
Have you tried this?
objA.onclick = new Function (alert( + intI + ) );
Response 2
for (var intI = 0 ; intI 10 ; intI++){
var objA = document.createElement( div );
Place one var objA; before the loop then remove the var inside.
Redeclaring a variable is a bad practice that will bite you in other
languages.
objA.onclick = function(){ alert( intI ); };
It's doing its job, it's alerting the value of intI, which is what you left
it. The easiest solution is to add a custom property to the object to hold
the current value of intI:
objA.currentI = intI;
objA.onclick = function(){ alert( this.currentI ); };
Response 3
objA.onclick = new Function (alert( + intI + ) );
This should work, but from what I understand new Function (like eval) must
be compiled on the spot, so there's a (however slight) performance hit.
http://userjs.org/help/tutorials/efficient-code
Hope some of this helps
Cutter
Ben Nadel wrote:
Not really for CF, but though someone here could lend some insight
There is one problem in Javascript that I cannot seem to get a handle on and
it is killling me! I can't seem to get variables to pass by value as I would
hope. Take the following example:
for (var intI = 0 ; intI 10 ; intI++){
var objA = document.createElement( div );
// Set the click for the link.
objA.onclick = function(){ alert( intI ); };
// Set the link into the body div.
objDiv.appendChild( objA );
}
Now, in my head, each one of those links, when clicked should alert the
appropriate intI value (0, 1, 2, 3, etc.); however, each of them will alert
10 which is the value that broke the FOR loop. It's like they all point to
one variable and then get updated for each loop of the FOR iteration.
I can't seem to find a good solution to this. One method that seems to work,
but is poop is something along the lines of:
// Define a function INSIDE this function.
function GetI( intX ){
return(
function(){ alert(intX); };
);
}
for (var intI = 0 ; intI 10 ; intI++){
var objA = document.createElement( div );
// Set the click for the link.
objA.onclick = GetI( intX );
// Set the link into the body div.
objDiv.appendChild( objA );
}
This method works as would be expected, though I seem to think that it is
doing the exact same thing. It must be something to do with the scoping.
Since the intI value is getting passed to a local scope (int GetI()), and
then getting passed back, it must be unique (since the local scope of the
GetI() method is created unique of each FOR iteration.
This solution seems truly ganky to me. There has to be a better way. And
this is just a simple example. I have many places where I want to be doing
this with object reference and dynamic event handling. This one simple bumb
is really holding me back!
Please help!!!
...
Ben Nadel
www.bennadel.com
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238310
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: Javascript help
Gotcha, I just saw a couple other posts that got separated into another
thread that explained that. I'll try it again in a few.
..:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
-Original Message-
From: Ben Nadel [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 20, 2006 11:01 AM
To: CF-Talk
Subject: RE: Javascript help
Bobby,
I cannot seem to get the onCLick to fire in my browser. Granted I am using
IE in Homesite. But, my concern with this solution is that I feel (without
testing) that it is string dependent.
divCont.setAttribute('onClick', 'alert(' + IntI + ')');
That line is going to try to force intI to a string, which works for simple
values, but will not work with complex values.
Ben Nadel
www.bennadel.com
-Original Message-
From: Bobby Hartsfield [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 20, 2006 10:49 AM
To: CF-Talk
Subject: RE: Javascript help
Is this what you were going for?
html
body
div id=mainContainer/div
/body
/html
script
for (IntI = 0; IntI 10; IntI++)
{
divCont = document.createElement('DIV');
divCont.id = 'div' + IntI;
divCont.appendChild(document.createElement('BR'));
divCont.style.background='ececec';
divCont.style.borderColor = '00';
divCont.style.borderStyle = 'solid';
divCont.style.borderWidth = '1px';
divCont.setAttribute('onClick', 'alert(' + IntI + ')');
document.getElementById('mainContainer').appendChild(divCont);
document.getElementById('mainContainer').appendChild(document.createElement(
'BR'));
}
/script
The onclick of the divs wont work in IE 6-
:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
-Original Message-
From: Ben Nadel [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 20, 2006 9:35 AM
To: CF-Talk
Subject: OT: Javascript help
Not really for CF, but though someone here could lend some insight
There is one problem in Javascript that I cannot seem to get a handle on and
it is killling me! I can't seem to get variables to pass by value as I would
hope. Take the following example:
for (var intI = 0 ; intI 10 ; intI++){ var objA = document.createElement(
div );
// Set the click for the link.
objA.onclick = function(){ alert( intI ); };
// Set the link into the body div.
objDiv.appendChild( objA );
}
Now, in my head, each one of those links, when clicked should alert the
appropriate intI value (0, 1, 2, 3, etc.); however, each of them will alert
10 which is the value that broke the FOR loop. It's like they all point to
one variable and then get updated for each loop of the FOR iteration.
I can't seem to find a good solution to this. One method that seems to work,
but is poop is something along the lines of:
// Define a function INSIDE this function.
function GetI( intX ){
return(
function(){ alert(intX); };
);
}
for (var intI = 0 ; intI 10 ; intI++){ var objA = document.createElement(
div );
// Set the click for the link.
objA.onclick = GetI( intX );
// Set the link into the body div.
objDiv.appendChild( objA );
}
This method works as would be expected, though I seem to think that it is
doing the exact same thing. It must be something to do with the scoping.
Since the intI value is getting passed to a local scope (int GetI()), and
then getting passed back, it must be unique (since the local scope of the
GetI() method is created unique of each FOR iteration.
This solution seems truly ganky to me. There has to be a better way. And
this is just a simple example. I have many places where I want to be doing
this with object reference and dynamic event handling. This one simple bumb
is really holding me back!
Please help!!!
..
Ben Nadel
www.bennadel.com
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238311
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: Javascript help
Hi Ben, I ran into this problem recently - these really helped me out: http://joust.kano.net/weblog/archive/2005/08/08/a-huge-gotcha-with-javascript-closures and http://jibbering.com/faq/faq_notes/closures.html /t ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238312 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: Why is there query.recordcount with non-SELECT queries?
How do you do that? -Original Message- From: Qasim Rasheed [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 19, 2006 6:40 PM Well I have been using JDBC Statement call from CF and it will return you number of records effected for updated, inserts or deletes. - This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A1. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238313 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
CFUNITED-06 interview 16: Tom Link - Flex 2.0 Event Model
In this issue of ColdFusion conference and training news: * Order a DVD copy of CFUNITED 2005 recordings and materials/laptop bag * Adobe Press offers attendees 35% off a selection of books! * Win a FREE extravagant lunch with your favorite speaker! * Fusetalk Forum on CFUNITED! Talk to other Attendees. * CFLive - Simeon Bateman Thursday 12:30pm * Coming Soon - NEW scheduler program * Interview with Tom Link on Flex 2.0 Event Model - 202 CFUNITED is the premier ColdFusion Conference near Washington DC 6/28-7/1/06 (Four whole days!) Check out speakers and topics at http://www.cfunited.com/ - Michael Smith TeraTech, Inc It is, by far, the single best conference for ColdFusion Developers and JRun/ColdFusion server Administrators. Not only do you get to meet and greet all of the top names in the field, you get to see where ColdFusion stands today, and see where it is going tomorrow. - Attendee from CFUNITED 2005 Have 3 years of CF and love helping other developers? http://www.teratech.com/index.cfm?go=About.JobDetailJobID=7 Conference and training news * Upcoming TeraTech classes Cost $59 - $349 see http://www.teratech.com/training/ for more details and registration CF101 - Welcome to ColdFusion May 2 2006 CF102 - Intro to ColdFusion May 9 2006 CF201 - Intermediate ColdFusion May 16 2006 FB101 - Intro to FuseboxMay 23 2006 FB201 - Intermediate FuseboxJun 6 2006 * Pre-conference classes Cost $449 see http://www.cfunited.com/classes06.cfm for more details and registration Location: Bethesda North Marriott and Conference Center CU210 Leader of the Pack (strategies for building better software) - Simon Horwith - Monday 6/26 CU211 Fundamentals of Relational Database - Kurtis D. Leatham - Monday 6/26 CU212 ColdFusion Server Administration: JRun J2EE Deployment - Adam Wayne Lehman - Monday 6/26 CU213 Testing ColdFusion - John Paul Ashenfelter - Monday 6/26 CU214 Ajax intensive for ColdFusion Developers - Rob Gonda - Tuesday 6/27 CU215 XML, XPath, and XSLT for ColdFusion Developers - Jeff Peters - Tuesday 6/27 CU216 Domain Modeling - Hal Helms - Tuesday 6/27 CU217 Beyond Basic SQL for CF - Nate Nelson - Tuesday 6/27 CFUNITED NEWS! * Order a DVD copy of CFUNITED 2005's recordings on MP3 http://www.cfunited.com/dvd_recordings.cfm All sessions were recorded at CFUNITED-05, but there were technical problems that left a portion of the session's MP3 recordings inaudible. This disc includes all the audible recordings. We apologize if any of your favorite sessions are not available for your listening. Also, you can order your own copy plus the 2005 bookbag and materials! -Limited Supply- * Adobe Press offers CFUNITED attendees 35% off books! Register for CFUNITED and use your login to receive benefits. http://www.cfunited.com/attendeepage.cfm Develop your ColdFusion chops with the best books for the web development community! Adobe Press is a world leader in high-quality books for visual communicators and the official source of training materials for Adobe and Macromedia software. Adobe Press books are published, marketed, and distributed by Peachpit Press. With top-notch books for both developers and designers covering the latest in Web technology, Adobe Press offers expert training, straight from the source. Choose from Macromedia Official Documentation titles, books by noted ColdFusion and Dreamweaver experts, such as Ben Forta and Joseph Lowery, as well as step-by-step project-based tutorials in the Training from the Source series. www.adobepress.com * CFUNITED SPECIAL EVENTS ColdFusion Celebration Hosted by Adobe, TeraTech, and Hostmysite Drinks, games, raffles. Join us for another year of ColdFusion Fun. Location: Bethesda North Marriott Terrace Starting time: 7:15pm Thursday, June 29th MiniMAX 4 http://www.minimaxconference.com/ Can't go to CFUNITED? Come to this FREE event! Hosted by Adam Bell Location: Brookside Room, Bethesda North Marriott Conference Center, Lower Level Starting Time: 8:00pm Attendee Get Together http://www.cfunited.com/attendee_dinner.cfm See old CFUNITED buddies before the big show! Make new friends! Hosted by CFDynamics Location: Dave and Busters, Approximately 3 blocks from Bethesda North Marriott Time: 5:30pm-7:30pm * Win a free extravagant lunch with your favorite speaker! Anyone who has registered before May 1st is eligible to win a lunch with his/her speaker of choice. Pick their brains while you enjoy a delicious meal and dessert. HURRY and REGISTER NOW! Speakers currently participating: Glenda Vigoreaux Sandy Clark Sean Corfield Selene Banium Ray Camden Joe Rinehart Simon Howrith Jeff Houser * 22% of our Pre-Conference Classes are full. Be sure to reserve your seat today! http://www.cfunited.com/classes06.cfm * The First 750 registrations will get our cool new laptop book bag, courtesy of our platinum and gold sponsors! Don't settle for the tote, register today! See photo at
RE: OT: Javascript help
Cutter,
I like this suggestion:
objA.currentI = intI;
objA.onclick = function(){ alert( this.currentI ); };
This is actually how I deal with this same problem in Flash Action Script
sometimes. However, in Flash I do it on objects, and in JS it always makes
me nervous to try adding data to an object that doesn't inherently have that
attribute.
...
Ben Nadel
www.bennadel.com
-Original Message-
From: Cutter (CFRelated) [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 20, 2006 1:00 PM
To: CF-Talk
Subject: Re: OT: Javascript help
Asking your question of my javascipt list, the responses were as follows:
Repsonse 1
Have you tried this?
objA.onclick = new Function (alert( + intI + ) );
Response 2
for (var intI = 0 ; intI 10 ; intI++){ var objA =
document.createElement( div );
Place one var objA; before the loop then remove the var inside.
Redeclaring a variable is a bad practice that will bite you in other
languages.
objA.onclick = function(){ alert( intI ); };
It's doing its job, it's alerting the value of intI, which is what you left
it. The easiest solution is to add a custom property to the object to hold
the current value of intI:
objA.currentI = intI;
objA.onclick = function(){ alert( this.currentI ); };
Response 3
objA.onclick = new Function (alert( + intI + ) );
This should work, but from what I understand new Function (like eval) must
be compiled on the spot, so there's a (however slight) performance hit.
http://userjs.org/help/tutorials/efficient-code
Hope some of this helps
Cutter
Ben Nadel wrote:
Not really for CF, but though someone here could lend some insight
There is one problem in Javascript that I cannot seem to get a handle
on and it is killling me! I can't seem to get variables to pass by
value as I would hope. Take the following example:
for (var intI = 0 ; intI 10 ; intI++){ var objA =
document.createElement( div );
// Set the click for the link.
objA.onclick = function(){ alert( intI ); };
// Set the link into the body div.
objDiv.appendChild( objA );
}
Now, in my head, each one of those links, when clicked should alert
the appropriate intI value (0, 1, 2, 3, etc.); however, each of them
will alert 10 which is the value that broke the FOR loop. It's like
they all point to one variable and then get updated for each loop of the
FOR iteration.
I can't seem to find a good solution to this. One method that seems to
work, but is poop is something along the lines of:
// Define a function INSIDE this function.
function GetI( intX ){
return(
function(){ alert(intX); };
);
}
for (var intI = 0 ; intI 10 ; intI++){ var objA =
document.createElement( div );
// Set the click for the link.
objA.onclick = GetI( intX );
// Set the link into the body div.
objDiv.appendChild( objA );
}
This method works as would be expected, though I seem to think that it
is doing the exact same thing. It must be something to do with the
scoping.
Since the intI value is getting passed to a local scope (int GetI()),
and then getting passed back, it must be unique (since the local scope
of the
GetI() method is created unique of each FOR iteration.
This solution seems truly ganky to me. There has to be a better way.
And this is just a simple example. I have many places where I want to
be doing this with object reference and dynamic event handling. This
one simple bumb is really holding me back!
Please help!!!
...
Ben Nadel
www.bennadel.com
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238315
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: OT: Javascript help
TanGuy,
Thanks, I think that first link helped a lot. I see what the guy is saying
(and I forgot that var's all get moved up to the highest scope - its sad
that I used to aide a web-dev class).
So now, I have something that works in terms of passing around variables
that make sense:
!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN
html
head
titleJavascript Dynamic Variables/title
script type=text/javascript
function TestClass( strName ){
this.Name = strName;
}
TestClass.prototype.AlertValue = function( anyValue ){
alert( this.Name + is alerting: + anyValue );
}
function Init(){
var objContentDiv = document.getElementById( content );
var objA = null;
var objTest = new TestClass( Tester );
// This runs the for loop using a LOCAL scope for each iteration.
(function loop( intI ){
var intX = intI;
if (intI 10){
// Create new A element.
objA = document.createElement( a );
// Set A display properties.
objA.style.display = block;
objA.style.backgroundColor = #F8F8F8;
objA.style.border = 1px solid #33;
objA.style.padding = 10px 10px 10px 10px;
objA.style.color = #33;
objA.style.marginBottom = 15px;
// Create text for the link.
objA.appendChild( document.createTextNode( I should alert +
intX + when clicked ) );
// Set the href.
objA.setAttribute( href, ## );
// Set the onclick method.
objA.onclick = function(){ objTest.AlertValue( intX ) };
// Attach the A to the content.
objContentDiv.appendChild( objA );
loop(intI + 1);
}
})(0);
}
// Is the tester class available here (just testing).
alert( objTest is of type: + typeof(objTest));
/script
/head
body onload=Init();
div id=content/div
/body
/html
Thanks for everyone's help. I think I now see the local scoping issue that I
was dealing with before. I will try to return with a better example.
...
Ben Nadel
www.bennadel.com
-Original Message-
From: Tanguy Rademakers [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 20, 2006 1:19 PM
To: CF-Talk
Subject: Re: OT: Javascript help
Hi Ben,
I ran into this problem recently - these really helped me out:
http://joust.kano.net/weblog/archive/2005/08/08/a-huge-gotcha-with-javascrip
t-closures
and
http://jibbering.com/faq/faq_notes/closures.html
/t
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238316
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: Why is there query.recordcount with non-SELECT queries?
Jacob,
Here is an example implementation for Oracle. You can definitely modify it
for any other database.
cfscript
//connection url
connURL = jdbc:macromedia:oracle://..;
jclass = createobject('java','java.lang.Class');
jclass.forName('macromedia.jdbc.oracle.OracleDriver');
driverManager = CreateObject('java', 'java.sql.DriverManager');
//user name and passwword
conn = driverManager.getConnection( connURL, 'USER', 'PASSWORD' );
sql = delete from atable where id = ?;
ps = conn.prepareStatement(sql);
ps.setString(1,'2');
n = ps.executeUpdate();
/cfscript
cfoutput
Records Affected: #n#
/cfoutput
HTH
Qasim
On 4/20/06, Munson, Jacob [EMAIL PROTECTED] wrote:
How do you do that?
-Original Message-
From: Qasim Rasheed [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 19, 2006 6:40 PM
Well I have been using JDBC Statement call from CF and it
will return you
number of records effected for updated, inserts or deletes.
-
This transmission may contain information that is privileged, confidential
and/or exempt from disclosure under applicable law. If you are not the
intended recipient, you are hereby notified that any disclosure, copying,
distribution, or use of the information contained herein (including any
reliance thereon) is STRICTLY PROHIBITED. If you received this transmission
in error, please immediately contact the sender and destroy the material in
its entirety, whether in electronic or hard copy format. Thank you. A1.
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238317
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: Why is there query.recordcount with non-SELECT queries?
On 4/18/06, Mike Klostermeyer [EMAIL PROTECTED] wrote: I wouldn't say that. Sometimes it is helpful to know how many records were updated or deleted without having to do a select query beforehand. Is there a Java service factory way of getting at this information? CF7 has a result attribute on the query tag. It returns a structure of information including the SQL, number of records affected, time and some other stuff. Cheers, Sam ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238318 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: Why is there query.recordcount with non-SELECT queries?
Sam, AFAIK the result attribute doesn't return records affected from insert/delete/updates. Please correct me if I am wrong. Thanks Qasim On 4/20/06, Sam Farmer [EMAIL PROTECTED] wrote: On 4/18/06, Mike Klostermeyer [EMAIL PROTECTED] wrote: I wouldn't say that. Sometimes it is helpful to know how many records were updated or deleted without having to do a select query beforehand. Is there a Java service factory way of getting at this information? CF7 has a result attribute on the query tag. It returns a structure of information including the SQL, number of records affected, time and some other stuff. Cheers, Sam ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238319 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: Why is there query.recordcount with non-SELECT queries?
AFAIK the result attribute doesn't return records affected from insert/delete/updates. Please correct me if I am wrong. You are right, I just tried it and it says recordcount: 0, and the only other data returned is cached, executiontime, and sql code. --- This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A1. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238320 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: Why is there query.recordcount with non-SELECT queries?
I got this working for MS SQL, here's the code:
cfscript
//connection url
connURL = jdbc:macromedia:sqlserver://server:1433;
jclass = createobject('java','java.lang.Class');
jclass.forName('macromedia.jdbc.sqlserver.SQLServerDriver');
driverManager = CreateObject('java', 'java.sql.DriverManager');
//user name and password
conn = driverManager.getConnection( connURL, 'USER', 'PASSWORD' );
sql = update budgets.dbo.budgetids set CC = ? where budgetid like ?;
ps = conn.prepareStatement(sql);
ps.setString(1,'400');
ps.setString(2,'B007%');
n = ps.executeUpdate();
/cfscript
cfoutput
Records Affected: #n#
/cfoutput
Notice that I had to give a fully qualified path to the table in my SQL
statement.
-Original Message-
From: Qasim Rasheed [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 20, 2006 12:06 PM
Jacob,
Here is an example implementation for Oracle. You can
definitely modify it
for any other database.
cfscript
//connection url
connURL = jdbc:macromedia:oracle://..;
jclass = createobject('java','java.lang.Class');
jclass.forName('macromedia.jdbc.oracle.OracleDriver');
driverManager = CreateObject('java', 'java.sql.DriverManager');
//user name and passwword
conn = driverManager.getConnection( connURL, 'USER', 'PASSWORD' );
sql = delete from atable where id = ?;
ps = conn.prepareStatement(sql);
ps.setString(1,'2');
n = ps.executeUpdate();
/cfscript
cfoutput
Records Affected: #n#
/cfoutput
[INFO] -- Access Manager:
This transmission may contain information that is privileged, confidential
and/or exempt from disclosure under applicable law. If you are not the
intended recipient, you are hereby notified that any disclosure, copying,
distribution, or use of the information contained herein (including any
reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in
error, please immediately contact the sender and destroy the material in its
entirety, whether in electronic or hard copy format. Thank you. A2
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238321
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: CFUNITED-06 interview 16: Tom Link - Flex 2.0 Event Model
On 4/20/06, Michael Smith [EMAIL PROTECTED] wrote: * Order a DVD copy of CFUNITED 2005 recordings and materials/laptop bag Can't believe I didnt' see this earlier, aka when it was still 2005. At this point, I would probably wait until the 2006 disc comes out. Will there be video recordings this year? Now that would sell some copies :) How about the PPT files from the presentations? -nathan strutz ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238322 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: CFUNITED-06 interview 16: Tom Link - Flex 2.0 Event Model
I think they just recently released it, if I remember right. -Original Message- From: Nathan Strutz [mailto:[EMAIL PROTECTED] Sent: Thursday, April 20, 2006 1:56 PM On 4/20/06, Michael Smith [EMAIL PROTECTED] wrote: * Order a DVD copy of CFUNITED 2005 recordings and materials/laptop bag Can't believe I didnt' see this earlier, aka when it was still 2005. At this point, I would probably wait until the 2006 disc comes out. Will there be video recordings this year? Now that would sell some copies :) How about the PPT files from the presentations? This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A1. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238323 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
protect downloaded files?
Anyone know if there is a surefire way to make all downloaded files read-only? We have a client that wants to have files available to download, but the original author doesn't want to have them be able to be edited. We're talking PowerPoint, Word, PDF files here, BTW. Any advice on how to make this happen would be appreciated. We've found that even using the Read Only attribute in the file properties doesn't persist once a copy has been downloaded to the client. TIA Ray ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238324 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: protect downloaded files?
Once a client downloads the file, they can easily change the attributes of the file From read-only to Normal and modify them anyway. Just can not do that on the files on the server. But to answer your question, sorry I do not know a way other than making them all PDF files however there are ways to convert a PDF file to another type and then be Able to make changes. -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Thursday, April 20, 2006 4:42 PM To: CF-Talk Subject: protect downloaded files? Anyone know if there is a surefire way to make all downloaded files read-only? We have a client that wants to have files available to download, but the original author doesn't want to have them be able to be edited. We're talking PowerPoint, Word, PDF files here, BTW. Any advice on how to make this happen would be appreciated. We've found that even using the Read Only attribute in the file properties doesn't persist once a copy has been downloaded to the client. TIA Ray ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238325 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: protect downloaded files?
Um, no. And even if you could force a downloaded file to be read-only, they are still easily edited, by changing the file properties or saving it as another name. Unless you can force the users to buy and install DRM software (and use it), you are out of luck. On 4/20/06, Ray Champagne [EMAIL PROTECTED] wrote: Anyone know if there is a surefire way to make all downloaded files read-only? We have a client that wants to have files available to download, but the original author doesn't want to have them be able to be edited. We're talking PowerPoint, Word, PDF files here, BTW. Any advice on how to make this happen would be appreciated. We've found that even using the Read Only attribute in the file properties doesn't persist once a copy has been downloaded to the client. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238326 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: protect downloaded files?
I don't think you can unless you use the embedded features to protect the documents. However, as with all items, anytime there's security there's usually some way around it. Setting the file Read only attribute would not really do much if someone knew how to turn it off, or they could just save it as a different filename. For things like Powerpoint, you could save it as a .pps file which is just the show without editing capabilities. However, I'd imagine there's some sort of utility to make it editable again. Same thing with PDFs. You can set a password on it but there's probably a way around it. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Thursday, April 20, 2006 4:42 PM To: CF-Talk Subject: protect downloaded files? Anyone know if there is a surefire way to make all downloaded files read-only? We have a client that wants to have files available to download, but the original author doesn't want to have them be able to be edited. We're talking PowerPoint, Word, PDF files here, BTW. Any advice on how to make this happen would be appreciated. We've found that even using the Read Only attribute in the file properties doesn't persist once a copy has been downloaded to the client. TIA Ray ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238327 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: protect downloaded files?
That's not possible for most files. PDF does have the option of password protecting files to provide varying levels of access, I suspect that Powerpoint might offer the same thing. For most files, though, once the user has it they can do anything they want with it. !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Thursday, April 20, 2006 3:42 PM To: CF-Talk Subject: protect downloaded files? Anyone know if there is a surefire way to make all downloaded files read-only? We have a client that wants to have files available to download, but the original author doesn't want to have them be able to be edited. We're talking PowerPoint, Word, PDF files here, BTW. Any advice on how to make this happen would be appreciated. We've found that even using the Read Only attribute in the file properties doesn't persist once a copy has been downloaded to the client. TIA Ray ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238328 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: protect downloaded files?
Isn't there a way to password lock a PDF file where it can still be viewed but not exported into something else? No matter what though there will always be a way around anything done just depends on how motivated someone is. On 4/20/06, Adkins, Randy [EMAIL PROTECTED] wrote: But to answer your question, sorry I do not know a way other than making them all PDF files however there are ways to convert a PDF file to another type and then be Able to make changes. -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Thursday, April 20, 2006 4:42 PM To: CF-Talk Subject: protect downloaded files? Anyone know if there is a surefire way to make all downloaded files read-only? We have a client that wants to have files available to download, but the original author doesn't want to have them be able to be edited. We're talking PowerPoint, Word, PDF files here, BTW. Any advice on how to make this happen would be appreciated. We've found that even using the Read Only attribute in the file properties doesn't persist once a copy has been downloaded to the client. TIA Ray ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238329 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: protect downloaded files?
Thanks Randy: FYI, just for future knowledge, we found that even if you change the attributes to Read Only on the server copy, it gets changed to Normal once downloaded. One doesn't even have to touch the attributes to get it back to normal. Seems a little silly to even have that option if it doesn't work, or is extremely easy to alter when not dealing with server/client relationships. Ray Adkins, Randy wrote: Once a client downloads the file, they can easily change the attributes of the file From read-only to Normal and modify them anyway. Just can not do that on the files on the server. But to answer your question, sorry I do not know a way other than making them all PDF files however there are ways to convert a PDF file to another type and then be Able to make changes. -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Thursday, April 20, 2006 4:42 PM To: CF-Talk Subject: protect downloaded files? Anyone know if there is a surefire way to make all downloaded files read-only? We have a client that wants to have files available to download, but the original author doesn't want to have them be able to be edited. We're talking PowerPoint, Word, PDF files here, BTW. Any advice on how to make this happen would be appreciated. We've found that even using the Read Only attribute in the file properties doesn't persist once a copy has been downloaded to the client. TIA Ray ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238330 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: protect downloaded files?
Anyone know if there is a surefire way to make all downloaded files read-only? Surefire --- no, but more difficult yes. Both word and PDF have internal locking capabilities that should get you what you want. I'm sure they are not perfect, but should prevent all but the most dedicated hacker from accessing and modifying the files. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238331 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: protect downloaded files?
For Word, are you talking about the Read Only attribute? Ian Skinner wrote: Anyone know if there is a surefire way to make all downloaded files read-only? Surefire --- no, but more difficult yes. Both word and PDF have internal locking capabilities that should get you what you want. I'm sure they are not perfect, but should prevent all but the most dedicated hacker from accessing and modifying the files. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238332 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: protect downloaded files?
Anyone know if there is a surefire way to make all downloaded files read-only? You could convert everything to image files. Of course that would still only slow them down, and bloat the download size. But at least they couldn't copy and past or Save As another type. Some good OCR software might even hack that easily I guess... ~Brad ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238333 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: StructFindKey Path and evaluate
We are using MS SQL 2000. I do some of the math in the db. I am very weak with rollup, so maybe you can see what I am missing. Example: Project: Task1 --Task1.1 --Task1.2 -- Has hours --Task1.2.1 --Task1.2.2 -- Has hours --Task1.2.3 --Task1.3 Task2 Task3---Has hours The rollup can get me the totals for a Project, CostArea and each individual task, but not the roll ups for tasks like Task1.2 or Task1. Here's a query I am playing with:(limiting to one project for faster testing :o). SELECT P.PROJ_NAME, TF.TEXT_VALUE AS CostArea, T.TASK_UID, T.TASK_NAME, GA.res_name, SUM(GA.Cost) AS cost, SUM(GA.HOURS) AS hours FROM TBLAllProjects P INNER JOIN ProjectServer_2003.dbo.MSP_TASKS T ON P.PROJ_ID = T.PROJ_ID LEFT OUTER JOIN TBLGovActuals GA ON P.PROJ_ID = GA.proj_id AND T.TASK_UID = GA.TASK_UID LEFT OUTER JOIN ProjectServer_2003.dbo.MSP_TEXT_FIELDS TF ON T.TASK_UID = TF.TEXT_REF_UID WHERE (TF.TEXT_FIELD_ID = 188744479) AND (TF.TEXT_VALUE IS NOT NULL) AND (T.TASK_UID 0) AND (P.PROJ_ID = 840) GROUP BY P.PROJ_NAME, TF.TEXT_VALUE, T.TASK_UID, T.TASK_NAME, GA.res_name, T.TASK_NAME WITH ROLLUP The only fields that tell you were a Task is, are: Task_lvl(1,2,3, etc) and Task_number(1, 1.1, 1.2, 1.1.1, ext). The Query doesn't know that 1.1, 1.1.1 and 1.2 get rolled up into 1. So I don't see were it's possible to do the roll ups for the top lvl tasks. Thanks Rodney -Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: Thursday, April 20, 2006 5:22 AM To: CF-Talk Subject: Re: StructFindKey Path and evaluate Yes, I was thinking that a cube of this would probably provide most of the desired info in a query (although I haven't looked closely enough to be sure). Does your DB do cube and rollup? On 4/20/06, Thomas Chiverton [EMAIL PROTECTED] wrote: On Wednesday 19 April 2006 17:24, Bruce, Rodney S C-E LCMC HQISEC/Signal Solutions wrote: If there is a better way to do this, please let me know. I don't really like the way I am doing it, but unfortunetly I havent come up with anything better and I do seem to do things the hard way. Getting the DB to do the maths ? -- CFAJAX docs and other useful articles: http://jr-holmes.coldfusionjournal.com/ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238334 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: protect downloaded files?
From a quick glance at Word's help. Protect a document from unauthorized changes OPTION ONE Seal your document with a digital certificate You digitally sign a file or a macro project by using a digital certificate. If you don't already have a digital certificate, you must obtain one. How? You can obtain a digital certificate from a commercial certification authority, such as VeriSign, Inc., or from your internal security administrator or Information Technology (IT) professional. Or, you can create a digital signature yourself using the Selfcert.exe tool. To learn more about certification authorities that offer services for Microsoft products, see the Microsoft Security Advisor Web site. Notes The hyperlink in this topic goes to the Web. You can switch back to Help at any time. Because a digital certificate you create yourself isn't issued by a formal certification authority, macro projects signed by using such a certificate are referred to as self-signed projects. Depending on how Microsoft Office digital-signature features are being used in your organization, you might be prevented from using such a certificate, and other users might not be able to run self-signed macros for security reasons. On the Tools menu, click Options, and click the Security tab. Click Digital signatures. Click Add. Select the certificate you want to add, and then click OK. OPTION TWO Require a password to open or modify a document When you create a password, write it down and keep it in a secure place. If you lose the password, you cannot open or gain access to the password-protected document. Open the file. On the Tools menu, click Options, and then click Security. Do one of the following: Create a password to open In the Password to open box, type a password, and then click OK. In the Reenter password to open box, type the password again, and then click OK. Create a password to modify In the Password to modify box, type a password, and then click OK. In the Reenter password to modify box, type the password again, and then click OK. Tip To create a long password â up to 255 characters â click Advanced, and select an RC4 encryption type. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238335 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: protect downloaded files?
For Word, are you talking about the Read Only attribute? I'm not sure. I am not talking about the file system Read Only, but an internal Word feature, something like Protect Document. That can be set with a password. So only those who know the password can modify the document. I know that PDF has a similar feature. Nether are perfect, but they do require some effort to get around. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238336 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: protect downloaded files?
Well maybe that doesn't do much for word. It will prevent someone from changing the original file, but one can save as to a new file at will. So you might be left with coverting everything to PDF which has somewhat more extensive internal protections. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238337 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
cfc/sql strange behavior
I'm essentially creating a glorified import process to join data from two of our systems and I'm seeing some strange things from CF/SQL Server 2000. It's fairly simple - I'm looping over one query and inserting data into a second database, calling private functions within the same CFC to retrieve some of the values. Here is the code that results in invalid object database error: cfoutput query=q cfquery name=qq datasource=mas500_orders INSERT INTO tecSOLine(ItemKey) VALUES(cfqueryparam value=#getItemKey(sku)# cfsqltype=cf_sql_integer) /cfquery /cfoutput I get the same error when I try #getItemKey(sku)# without the cfqueryparam. The following code, wherein I retrieve the key ahead of the insert query and then use cfqueryparam, does NOT produce the error. cfoutput query=q cfset myKey=getItemKey(sku) cfquery name=qq datasource=mas500_orders INSERT INTO tecSOLine(ItemKey) VALUES(cfqueryparam value=#myKey# cfsqltype=cf_sql_integer) /cfquery /cfoutput I'm stumped. Any clues? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238338 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: cfc/sql strange behavior
Paul,
I ran into this same issue the other day. It seems that ColdFusion is
adding line breaks before the value returned by your function, which
generates an error on your DB. So calling the function from within
cfquery would result in the following SQL being sent to the DB.
INSERT INTO myTable(some_field)
VALUES('
value_returned_by_function_directly')
But setting a variable to the value returned by the function (which is
the way that I had to setup my query) would send this.
INSERT INTO myTable(some_field)
VALUES('value_returned_by_variable_calling_function')
Not sure why. Has anyone else come across this?
Robert
-Original Message-
From: Paul [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 20, 2006 4:24 PM
To: CF-Talk
Subject: cfc/sql strange behavior
I'm essentially creating a glorified import process to join data from
two of
our systems and I'm seeing some strange things from CF/SQL Server 2000.
It's fairly simple - I'm looping over one query and inserting data into
a
second database, calling private functions within the same CFC to
retrieve
some of the values.
Here is the code that results in invalid object database error:
cfoutput query=q
cfquery name=qq datasource=mas500_orders
INSERT INTO tecSOLine(ItemKey)
VALUES(cfqueryparam value=#getItemKey(sku)#
cfsqltype=cf_sql_integer)
/cfquery
/cfoutput
I get the same error when I try #getItemKey(sku)# without the
cfqueryparam.
The following code, wherein I retrieve the key ahead of the insert query
and
then use cfqueryparam, does NOT produce the error.
cfoutput query=q
cfset myKey=getItemKey(sku)
cfquery name=qq datasource=mas500_orders
INSERT INTO tecSOLine(ItemKey)
VALUES(cfqueryparam value=#myKey#
cfsqltype=cf_sql_integer)
/cfquery
/cfoutput
I'm stumped. Any clues?
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238339
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: cfc/sql strange behavior
Well it must be true, misery does love company. It's comforting I'm not the
only one!
Incidentally I suspected it might be something about the value returned by
the function so I added output=false to the function definition but it was
of no consequence - same funky error.
I'll be interested to see how this ends up. Thanks for the info, Robert.
-Original Message-
From: FROEHLING, ROBERT (ASI-AIT) [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 20, 2006 3:58 PM
To: CF-Talk
Subject: RE: cfc/sql strange behavior
Paul,
I ran into this same issue the other day. It seems that ColdFusion is
adding line breaks before the value returned by your function, which
generates an error on your DB. So calling the function from within
cfquery would result in the following SQL being sent to the DB.
INSERT INTO myTable(some_field)
VALUES('
value_returned_by_function_directly')
But setting a variable to the value returned by the function (which is
the way that I had to setup my query) would send this.
INSERT INTO myTable(some_field)
VALUES('value_returned_by_variable_calling_function')
Not sure why. Has anyone else come across this?
Robert
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238340
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: cfc/sql strange behavior
If you are using CFFUNCTION, are you also using OUTPUT=NO?
If this is a CFSCRIPT-type function, just trim the return value.
M!ke
-Original Message-
From: Paul [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 20, 2006 5:19 PM
To: CF-Talk
Subject: RE: cfc/sql strange behavior
Well it must be true, misery does love company. It's comforting I'm not
the only one!
Incidentally I suspected it might be something about the value returned
by the function so I added output=false to the function definition but
it was of no consequence - same funky error.
I'll be interested to see how this ends up. Thanks for the info,
Robert.
-Original Message-
From: FROEHLING, ROBERT (ASI-AIT) [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 20, 2006 3:58 PM
To: CF-Talk
Subject: RE: cfc/sql strange behavior
Paul,
I ran into this same issue the other day. It seems that ColdFusion is
adding line breaks before the value returned by your function, which
generates an error on your DB. So calling the function from within
cfquery would result in the following SQL being sent to the DB.
INSERT INTO myTable(some_field)
VALUES('
value_returned_by_function_directly')
But setting a variable to the value returned by the function (which is
the way that I had to setup my query) would send this.
INSERT INTO myTable(some_field)
VALUES('value_returned_by_variable_calling_function')
Not sure why. Has anyone else come across this?
Robert
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238341
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: protect downloaded files?
Isn't there a way to password lock a PDF file where it can still be viewed but not exported into something else? No matter what though there will always be a way around anything done just depends on how motivated someone is. Yes, you can apply granular controls to limit what someone can do with a PDF, and you can protect those settings using encryption. You can digitally sign PDFs to guarantee that documents haven't been changed, and you can apply digital signatures to allow specific types of changes but guarantee the overall validity of the document. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238342 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: Evaluate vs ?
Thanks will give it a try. And yes, we do have a dedicated smtp server. Charles On 4/20/06 4:05 AM, Russ Michaels [EMAIL PROTECTED] wrote: if you generate the content files and save them as static files, you can just cfinclude them into your cfmail then you won't need to evaluate them. BTW, if your sending out that much mail, I hope you have a dedicated SMTP server and are not using the SMTP on IIS. Russ -Original Message- From: Charles Sheehan-Miles [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Date: Wed, 19 Apr 2006 23:19:13 -0400 Subject: Re: Evaluate vs ? I'm going to have to do some serious thinking about this. Performance ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238343 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
