OT - SQL Help
Hi all, Sorry for the OT but this should be a quick answer. This is in ASP (sorry). If I have the following: sql = SELECT * FROM SomeTable sql = sql WHERE Email = ' Request(un) ' sql = sql OR SEmail = ' Request(un) ' sql = sql AND IsDeleted = 0 sql = sql AND Password = ' Request(pw) ' sql = sql AND Approved = 1 sql = sql AND Registered = 1 Where Email is the primary email and SEmail is a secondary email address (both are different addresses). If the submission doesn't match the first then it matches the second, how do I account for that? Right now, I am getting an error because the record doesn't match. Any ideas? Thanks, Tony ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: OT - SQL Help
No scope. It is written in ASP. -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 11:46 AM To: CF-Talk Subject: RE: OT - SQL Help I'm a bit confused - I'm not sure what you mean by the error you are getting. What scope are you trying to request the variable un from? Is it a form variable or url? Normally you'd access these using Request.Form(un) (for form vars) If they are local vars then just reference them as un. Not saying that what you have will cause errors - just not seen it written like that b4. -Original Message- From: Tony Carcieri [mailto:[EMAIL PROTECTED]] Sent: 02 December 2002 16:31 To: CF-Talk Subject: OT - SQL Help Hi all, Sorry for the OT but this should be a quick answer. This is in ASP (sorry). If I have the following: sql = SELECT * FROM SomeTable sql = sql WHERE Email = ' Request(un) ' sql = sql OR SEmail = ' Request(un) ' sql = sql AND IsDeleted = 0 sql = sql AND Password = ' Request(pw) ' sql = sql AND Approved = 1 sql = sql AND Registered = 1 Where Email is the primary email and SEmail is a secondary email address (both are different addresses). If the submission doesn't match the first then it matches the second, how do I account for that? Right now, I am getting an error because the record doesn't match. Any ideas? Thanks, Tony ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: OT - SQL Help
This and CFDJList are the only good lists that are out there where everyone is more than helpful and help/answers are extrememly quick. -Original Message- From: Rob Rohan [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 12:38 PM To: CF-Talk Subject: RE: OT - SQL Help That is pretty funny, posting an SQL question wrapped in ASP on a Cold Fusion list. I have a question about using linked lists and malloc in C :) Rob http://treebeard.sourceforge.net http://ruinworld.sourceforge.net Scientia Est Potentia -Original Message- From: Tony Carcieri [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 9:25 AM To: CF-Talk Subject: RE: OT - SQL Help No scope. It is written in ASP. -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 11:46 AM To: CF-Talk Subject: RE: OT - SQL Help I'm a bit confused - I'm not sure what you mean by the error you are getting. What scope are you trying to request the variable un from? Is it a form variable or url? Normally you'd access these using Request.Form(un) (for form vars) If they are local vars then just reference them as un. Not saying that what you have will cause errors - just not seen it written like that b4. -Original Message- From: Tony Carcieri [mailto:[EMAIL PROTECTED]] Sent: 02 December 2002 16:31 To: CF-Talk Subject: OT - SQL Help Hi all, Sorry for the OT but this should be a quick answer. This is in ASP (sorry). If I have the following: sql = SELECT * FROM SomeTable sql = sql WHERE Email = ' Request(un) ' sql = sql OR SEmail = ' Request(un) ' sql = sql AND IsDeleted = 0 sql = sql AND Password = ' Request(pw) ' sql = sql AND Approved = 1 sql = sql AND Registered = 1 Where Email is the primary email and SEmail is a secondary email address (both are different addresses). If the submission doesn't match the first then it matches the second, how do I account for that? Right now, I am getting an error because the record doesn't match. Any ideas? Thanks, Tony ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: OT - SQL Help
Dave's absolutely right. I am a lil' lazy. The less typing the better! 8^) -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 12:56 PM To: CF-Talk Subject: RE: OT - SQL Help Sorry - I wasn't particularly clear. What I meant to say was that the request object has a number of collections associated with it (form, querystring, etc...). When I have used the request object I have always referenced an element of one of these collections e,g, request.form(un). Not seen it as you had it but not to say it doesn't work! You can use either syntax in ASP. I've generally used the more explicit syntax, myself. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: OT - SQL Help
No it did not. It's very bizarre. -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 1:04 PM To: CF-Talk Subject: RE: OT - SQL Help my ASP's not what it used to be! - so did Randells post sort it? -Original Message- From: Tony Carcieri [mailto:[EMAIL PROTECTED]] Sent: 02 December 2002 17:59 To: CF-Talk Subject: RE: OT - SQL Help Dave's absolutely right. I am a lil' lazy. The less typing the better! 8^) -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 12:56 PM To: CF-Talk Subject: RE: OT - SQL Help Sorry - I wasn't particularly clear. What I meant to say was that the request object has a number of collections associated with it (form, querystring, etc...). When I have used the request object I have always referenced an element of one of these collections e,g, request.form(un). Not seen it as you had it but not to say it doesn't work! You can use either syntax in ASP. I've generally used the more explicit syntax, myself. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: OT - SQL Help
I guess I must have not been clear in my initial email. I am not getting an error. The problem is I have 2 different email addresses that can be used to log into an extranet. If the primary email doesn't match the primary email address then it should check to see if it matches the secondary email address and log in otherwise it is not found. For example, let's say these fields are in the DB: PEmail,SEmail and let's say these are the email addresses respectively: [EMAIL PROTECTED],[EMAIL PROTECTED] And in the form I input [EMAIL PROTECTED] I should be able to log in but the problem is that it only accepts the primary email address. Hope this clears it up. Thanks, Tony -Original Message- From: Matthew Small [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 2:22 PM To: CF-Talk Subject: RE: OT - SQL Help What error are you getting? Matthew Small IT Supervisor Showstopper National Dance Competitions 3660 Old Kings Hwy Murrells Inlet, SC 29576 843-357-1847 http://www.showstopperonline.com -Original Message- From: Tony Carcieri [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 2:14 PM To: CF-Talk Subject: RE: OT - SQL Help No it did not. It's very bizarre. -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 1:04 PM To: CF-Talk Subject: RE: OT - SQL Help my ASP's not what it used to be! - so did Randells post sort it? -Original Message- From: Tony Carcieri [mailto:[EMAIL PROTECTED]] Sent: 02 December 2002 17:59 To: CF-Talk Subject: RE: OT - SQL Help Dave's absolutely right. I am a lil' lazy. The less typing the better! 8^) -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 12:56 PM To: CF-Talk Subject: RE: OT - SQL Help Sorry - I wasn't particularly clear. What I meant to say was that the request object has a number of collections associated with it (form, querystring, etc...). When I have used the request object I have always referenced an element of one of these collections e,g, request.form(un). Not seen it as you had it but not to say it doesn't work! You can use either syntax in ASP. I've generally used the more explicit syntax, myself. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: OT - SQL Help
Exactly!!! But it is not working that way. I just sent a previous email explaining this. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 2:36 PM To: CF-Talk Subject: RE: OT - SQL Help Sorry for the OT but this should be a quick answer. This is in ASP (sorry). If I have the following: sql = SELECT * FROM SomeTable sql = sql WHERE Email = ' Request(un) ' sql = sql OR SEmail = ' Request(un) ' sql = sql AND IsDeleted = 0 sql = sql AND Password = ' Request(pw) ' sql = sql AND Approved = 1 sql = sql AND Registered = 1 Where Email is the primary email and SEmail is a secondary email address (both are different addresses). If the submission doesn't match the first then it matches the second, how do I account for that? Right now, I am getting an error because the record doesn't match. You shouldn't be getting an error if the record doesn't match, you should just not get any records back if none match. Randall's suggestion about using parentheses should take care of your stated problem (you want to compare the value to both fields, and if it matches either, you want to select the record, right?) Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: OT - SQL Help
I just removed all the asp stuff and this is what gets sent. SELECT * FROM SomeTable WHERE (Email = '[EMAIL PROTECTED]') OR (SEmail = '[EMAIL PROTECTED]') AND (IsDeleted = 0) AND (Password = 'somepassword') AND (Approved = 1) AND (Registered = 1) -Original Message- From: Matthew Small [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 2:48 PM To: CF-Talk Subject: RE: OT - SQL Help You to see exactly what SQL Statement being sent to the db. How about displaying the sql string before it is processed and send that to the list. Matthew Small IT Supervisor Showstopper National Dance Competitions 3660 Old Kings Hwy Murrells Inlet, SC 29576 843-357-1847 http://www.showstopperonline.com -Original Message- From: Tony Carcieri [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 2:38 PM To: CF-Talk Subject: RE: OT - SQL Help Exactly!!! But it is not working that way. I just sent a previous email explaining this. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 2:36 PM To: CF-Talk Subject: RE: OT - SQL Help Sorry for the OT but this should be a quick answer. This is in ASP (sorry). If I have the following: sql = SELECT * FROM SomeTable sql = sql WHERE Email = ' Request(un) ' sql = sql OR SEmail = ' Request(un) ' sql = sql AND IsDeleted = 0 sql = sql AND Password = ' Request(pw) ' sql = sql AND Approved = 1 sql = sql AND Registered = 1 Where Email is the primary email and SEmail is a secondary email address (both are different addresses). If the submission doesn't match the first then it matches the second, how do I account for that? Right now, I am getting an error because the record doesn't match. You shouldn't be getting an error if the record doesn't match, you should just not get any records back if none match. Randall's suggestion about using parentheses should take care of your stated problem (you want to compare the value to both fields, and if it matches either, you want to select the record, right?) Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: OT - SQL Help
ARGH! I figured it out... *lowering head* I forgot to change some code on an include page. DOH! Sorry folks! Thanks to everyone who helped. -Original Message- From: Tony Carcieri [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 2:56 PM To: CF-Talk Subject: RE: OT - SQL Help I just removed all the asp stuff and this is what gets sent. SELECT * FROM SomeTable WHERE (Email = '[EMAIL PROTECTED]') OR (SEmail = '[EMAIL PROTECTED]') AND (IsDeleted = 0) AND (Password = 'somepassword') AND (Approved = 1) AND (Registered = 1) -Original Message- From: Matthew Small [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 2:48 PM To: CF-Talk Subject: RE: OT - SQL Help You to see exactly what SQL Statement being sent to the db. How about displaying the sql string before it is processed and send that to the list. Matthew Small IT Supervisor Showstopper National Dance Competitions 3660 Old Kings Hwy Murrells Inlet, SC 29576 843-357-1847 http://www.showstopperonline.com -Original Message- From: Tony Carcieri [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 2:38 PM To: CF-Talk Subject: RE: OT - SQL Help Exactly!!! But it is not working that way. I just sent a previous email explaining this. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 2:36 PM To: CF-Talk Subject: RE: OT - SQL Help Sorry for the OT but this should be a quick answer. This is in ASP (sorry). If I have the following: sql = SELECT * FROM SomeTable sql = sql WHERE Email = ' Request(un) ' sql = sql OR SEmail = ' Request(un) ' sql = sql AND IsDeleted = 0 sql = sql AND Password = ' Request(pw) ' sql = sql AND Approved = 1 sql = sql AND Registered = 1 Where Email is the primary email and SEmail is a secondary email address (both are different addresses). If the submission doesn't match the first then it matches the second, how do I account for that? Right now, I am getting an error because the record doesn't match. You shouldn't be getting an error if the record doesn't match, you should just not get any records back if none match. Randall's suggestion about using parentheses should take care of your stated problem (you want to compare the value to both fields, and if it matches either, you want to select the record, right?) Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
OT: Contract agreement
Hi all, Sorry for the OT but I know this has been discussed before. Where is the best place to get a general contract agreement? I appreciate it very much. And PLEASE email off list. Thanks, Tony ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: SOT: Sad Day
No matter what the situation is Verne, one thing is for sure: its MM's loss. You (and Ray) are a TREMENDOUS asset to the community and I for one, think they made a huge mistake. I have been laid off twice and it truly sucks. Yea, it's nice to lounge around naked with beer and pretzels for breakfast, watching cartoons..errr...looking for jobs but after a while, the crumbs add up and and the beer runs out Best of Luck man! Big T -Original Message- From: Vernon Viehe [mailto:vernviehe;yahoo.com] Sent: Tuesday, November 12, 2002 4:01 PM To: CF-Talk Subject: RE: SOT: Sad Day I'm not going to comment on the situation, other than to clarify that it wasn't my decision to leave the CFCM position. What I can tell you is that I really enjoyed working with the CF Community, and the comments I've seen on and off the lists have been very uplifting to me right now. You guys are great! I'll continue to be around, mostly just lurking for a while. -Vern Andrew Tyrone [EMAIL PROTECTED] wrote:I don't understand why everyone jumps to the conclusion that MM is cutting back. Maybe Vernon left because he wanted to, who knows. As with the Contribute thread (I'm glad I made an OT sub-folder for cf-talk), people start assuming and making stuff up before they know the whole story! On that note, I am glad that Vernon will be around as he's a good voice of reason to this list, at least in my opinion. -Original Message- From: Joe Eugene [mailto:Jebebox;earthlink.net] Sent: Monday, November 11, 2002 10:35 PM To: CF-Talk Subject: RE: SOT: Sad Day Yeah.. really.. what happened? Vernon has been very resourceful to this community.. i mean.. i got several post replies from Vernon quite late at night. Vern keep good track of issues and problems So whats the deal MM cutting back? Joe -Original Message- From: Jeffry Houser [mailto:jeff;farcryfly.com] Sent: Monday, November 11, 2002 9:15 PM To: CF-Talk Subject: Re: SOT: Sad Day I'm sure the question on everyone's mind is What happened? Wasn't it about a year ago where they actually added this position? At 03:50 PM 11/11/2002 -0800, you wrote: Hey Sandy, You can reach me at [EMAIL PROTECTED] I'll be taking some time to relax, but you'll be seeing me around. I'll be able to spend more time working with CF and the other MX software, so I'll be here and in the forums participating as a member of the community! -Vern Sandy Clark wrote:Just heard that Vernon is no longer CF Community Manager at Macromedia and that in fact, he isn't at Macromedia any longer. Anyone knowing his personal email address. Please let him know that Sandy would like to continue emailing with him ([EMAIL PROTECTED]). Thanks Sandra Clark Shayna Productions http://www.shayna.com [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: SOT: Sad Day
WAY to much work for me! ;^) -Original Message- From: Mosh Teitelbaum [mailto:mosh.teitelbaum;evoch.com] Sent: Tuesday, November 12, 2002 4:27 PM To: CF-Talk Subject: RE: SOT: Sad Day The trick is to brew your own beer. 8^) -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Tony Carcieri [mailto:tony;mediaweave.com] Sent: Tuesday, November 12, 2002 4:16 PM To: CF-Talk Subject: RE: SOT: Sad Day No matter what the situation is Verne, one thing is for sure: its MM's loss. You (and Ray) are a TREMENDOUS asset to the community and I for one, think they made a huge mistake. I have been laid off twice and it truly sucks. Yea, it's nice to lounge around naked with beer and pretzels for breakfast, watching cartoons..errr...looking for jobs but after a while, the crumbs add up and and the beer runs out Best of Luck man! Big T -Original Message- From: Vernon Viehe [mailto:vernviehe;yahoo.com] Sent: Tuesday, November 12, 2002 4:01 PM To: CF-Talk Subject: RE: SOT: Sad Day I'm not going to comment on the situation, other than to clarify that it wasn't my decision to leave the CFCM position. What I can tell you is that I really enjoyed working with the CF Community, and the comments I've seen on and off the lists have been very uplifting to me right now. You guys are great! I'll continue to be around, mostly just lurking for a while. -Vern Andrew Tyrone [EMAIL PROTECTED] wrote:I don't understand why everyone jumps to the conclusion that MM is cutting back. Maybe Vernon left because he wanted to, who knows. As with the Contribute thread (I'm glad I made an OT sub-folder for cf-talk), people start assuming and making stuff up before they know the whole story! On that note, I am glad that Vernon will be around as he's a good voice of reason to this list, at least in my opinion. -Original Message- From: Joe Eugene [mailto:Jebebox;earthlink.net] Sent: Monday, November 11, 2002 10:35 PM To: CF-Talk Subject: RE: SOT: Sad Day Yeah.. really.. what happened? Vernon has been very resourceful to this community.. i mean.. i got several post replies from Vernon quite late at night. Vern keep good track of issues and problems So whats the deal MM cutting back? Joe -Original Message- From: Jeffry Houser [mailto:jeff;farcryfly.com] Sent: Monday, November 11, 2002 9:15 PM To: CF-Talk Subject: Re: SOT: Sad Day I'm sure the question on everyone's mind is What happened? Wasn't it about a year ago where they actually added this position? At 03:50 PM 11/11/2002 -0800, you wrote: Hey Sandy, You can reach me at [EMAIL PROTECTED] I'll be taking some time to relax, but you'll be seeing me around. I'll be able to spend more time working with CF and the other MX software, so I'll be here and in the forums participating as a member of the community! -Vern Sandy Clark wrote:Just heard that Vernon is no longer CF Community Manager at Macromedia and that in fact, he isn't at Macromedia any longer. Anyone knowing his personal email address. Please let him know that Sandy would like to continue emailing with him ([EMAIL PROTECTED]). Thanks Sandra Clark Shayna Productions http://www.shayna.com [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: SOT: Sad Day
Obviously i do not expect an answer but I think some of us are wondering: if you are dedicating more resources to the coldfusion community and that we will be announcing a new community manager position very soon then why lose Verne? I think I can safely state that Verne was constantly standing up for MM and was a HUGE asset in the community. I also would be likely to believe that he was as qualified as the next person. So, why lose that type of asset? Sorry, Mike, but I just think it wasn't the most beneficial move that MM has done. And i don't mean to sound like a jerk or want an answer and it's just my opinion. Likewise, Verne could have had his own personal reasons for leaving and that is totally understandable as could MM. -Original Message- From: Mike Chambers [mailto:mchamber;macromedia.com] Sent: Tuesday, November 12, 2002 3:33 PM To: CF-Talk Subject: RE: SOT: Sad Day that is correct. we are not cutting back. in fact, we will be dedicating more resources to the coldfusion community. mike chambers [EMAIL PROTECTED] -Original Message- From: Andrew Tyrone [mailto:atyrone;optonline.net] Sent: Tuesday, November 12, 2002 3:19 PM To: CF-Talk Subject: RE: SOT: Sad Day I don't understand why everyone jumps to the conclusion that MM is cutting back. Maybe Vernon left because he wanted to, who knows. As with the Contribute thread (I'm glad I made an OT sub-folder for cf-talk), people start assuming and making stuff up before they know the whole story! On that note, I am glad that Vernon will be around as he's a good voice of reason to this list, at least in my opinion. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: How Good is the Job Market for ColdFusion?
Gotta agree man. The freaks I knew who drove the exotic cars, basked with the babes, and threw the Ben's around are now in the local quickie mart with a 1980 Toyota, can't get a date, and live check to check. Ahhh, can't wait to tell my kid about the times when*grin* -Original Message- From: Paris Lundis [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 15, 2002 5:06 PM To: CF-Talk Subject: RE: How Good is the Job Market for ColdFusion? actually totally not bitter.. I use to sit around and laugh at the insanity... Herman Miller pay day baby... those little funny cars... the denial... Oh the jet set wannabes :) she likes, ahh you money ... I was always the black cloud of death reminder... Paris Lundis Founder Areaindex, L.L.C. http://www.areaindex.com http://www.pubcrawler.com 412-292-3135 [finding the future in the past, passing the future in the present] [connecting people, places and things] -Original Message- From: Mosh Teitelbaum [EMAIL PROTECTED] Date: Tue, 15 Oct 2002 16:10:29 -0400 Subject: RE: How Good is the Job Market for ColdFusion? LOL - Mr. Know It All but Knows Nothing Web Dork -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Rob Rohan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 15, 2002 3:54 PM To: CF-Talk Subject: RE: How Good is the Job Market for ColdFusion? At least you're not bitter. -Original Message- From: Paris Lundis [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 15, 2002 12:37 PM To: CF-Talk Subject: RE: How Good is the Job Market for ColdFusion? It's an economy and burnout thing... I mean how many people need software built? How many people are throwing hard cash at a software based business concept? Not many. Couple that with the reduced budgets everyone is facing across the board and bingo! Hiring isn't what is in, firing is... The whole view that the web was where you had to be, is a has been idea... Now its trivilized greatly (after the cafe mocha brewer turned web dude turned 20something CEO phase)... The margins are razor thin in general and clients expect tons of functionality at little or no cost.. Companies with payrolls are feeling the lashings, even if they are selling box software... Retainers, once the staple of entitlement have evaporated and lots of people owe for development across the board... Times are tough and leaner... Better and different... At least now I can laugh that Mr. Know It All but Knows Nothing Web Dorks and the idiot business school wanks with their bullshit $800 chairs and stupid gimmicks are back at their mostly trivial jobs for mostly someone else... Paris Lundis Founder Areaindex, L.L.C. http://www.areaindex.com http://www.pubcrawler.com 412-292-3135 [finding the future in the past, passing the future in the present] [connecting people, places and things] -Original Message- From: Trey Rouse [EMAIL PROTECTED] Date: Tue, 15 Oct 2002 12:45:38 -0500 Subject: RE: How Good is the Job Market for ColdFusion? I have to agree with Casey on this one. There are practically no CF postings in the Texas market. Dallas has by far the most of any other regional market. I'm no longer a developer and have moved up past the architect tear, and honestly, I here 5x as many stories of people ditching CF than ramping up. The enterprise penetration of MX has been weak. MM would blame this on the marketplace, but I'm not sold on this. We honestly are seriously considering dumping the product and retraining our CF team for native j2ee. MM's failure to support Oracles j2ee server is killing them in the education and corporate marketplaces. Too many large schools and corporations have purchased 'site' licensure of oracle products that comes bundled with oracle's j2ee server. Fiscally we can not justify purchasing another party j2ee server just to continue using the CF toolset. We are moving forward with what we already own. Talking with industry piers, we are by no means the only large shop doing this. My advice, if you want to maintain your marketability, you better ramp up on other application server languages. Trey Rouse Rice University -Original Message- From: Casey C Cook [mailto:[EMAIL PROTECTED]] Sent: Saturday, October 12, 2002 9:54 AM To: CF-Talk Subject: RE: How Good is the Job Market for ColdFusion? Well, heres my 2 cents. When the economy was booming I noticed about a 1 to 5 ratio (roughly 100 CF 500 ASP) for coldfusion to ASP jobs on monster.com for the Dallas/Ft. Worth Texas Area, now that the economy is down I see a 1 to 12 ratio (roughly 10 CF 120 ASP) for coldfusion to ASP
RE: OT: SQL Question
Thanks Everyone! I appreciate the help! Thanks, Tony -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 09, 2002 7:26 PM To: CF-Talk Subject: Re: OT: SQL Question Tony Carcieri wrote: Hi all, Here's what I want to do: UPDATE tablename SET column = 0 WHERE ID = ??? I want to specify a range of numbers (like 100-200) and increment it by 2. So, 100, 102,104etc would only be updated and the rest wouldn't. WHERE ID BETWEEN 100 AND 200 AND MOD(ID, 2) = 0 Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: LONG time CF Supporter - About ready to dump CF!
Vernon, You're one hell of a class act! Someone who cares enough to actually speak to someone and not go to automated phone support. I applaud you! It's nice to see that some people care about us lil guys! Thanks, T -Original Message- From: Vernon Viehe [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 08, 2002 5:46 PM To: CF-Talk Subject: RE: LONG time CF Supporter - About ready to dump CF! Lee, I appreciate your need TODAY, and I sympathize with your plight. However, there are a couple of things to keep in mind...This problem didn't just crop up today, and from the sound of it, it doesn't sound like it can be solved today. I strongly urge you to contact support, possibly become a Gold Support customer. That program was designed for this kind of urgent service. If I've read this thread correctly, you've said you don't want to call support because you're afraid you'll be charged unfairly for something that is a CFMX bug, yet I've not seen anyone on this list say that they have been charged in such a situation, but they have reiterated just the opposite. I'll repeat my earlier reassurance, if anyone, including you, are charged for a support incident, and you don't think the charge is fair, I will thoroughly look into it. Trust me, I'm not unsympathetic, but unfortunately, this list is not an official, one-to-one support venue. It's not where one turns for direct, urgent one-to-one contact. I strongly urge you to work with our support department instead of relying upon community lists/forums for urgent situations where you need direct assistance from Macromedia. The kind of simple information you seek simply isn't simple - but we are always in an ongoing effort to get this information to our customers, and will continue to do so. If you'd like to speak with me personally, e-mail me your contact info off-list, and I'll give you a call. Vernon Viehe ColdFusion Community Manager Developer Relations Macromedia, Inc. Online diary: http://vvmx.blogspot.com/ Macromedia DevCon 2002, October 27-30, Orlando, Florida Architecting a New Internet Experience Register today at www.macromedia.com/go/devcon2002 -Original Message- From: Lee Fuller [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 08, 2002 1:01 PM To: CF-Talk Subject: RE: LONG time CF Supporter - About ready to dump CF! Vernon, I completely understand. However, looking at it from my vantage point (and I'm pretty sure I'm not alone here on this mountain top - or at the bottom of this pit.. depending upon your viewpoint), I have a problem TODAY. One that is causing me serious trouble TODAY. I know that things like this take time, and I truly believe that this is not an MM thing. That's not my view of it at all. My view is simple (and I won't repeat it and bore everyone to death). Reality is that I need a solution TODAY. Sometime to keep my people from throwing the baby out with the bath water. Maybe it would help for MM to post a simple, clean and concise, page-by-page setting list of how you (MM) suggest we setup our servers (using gulp IIS5, of course) to make sure that CFMX works properly. Specifically -- - Page-by-page settings with the Administrator - Specific IIS changes/additions/amendments - Specific changes to CFMX setup files (similar to the XML file changes for multi-homing) - Some traps and tricks (simply put) I know that you have the best practices and performance tuning white papers. However, a checklist would be far more helpful -- so that people like me that are experiencing a problem can turn to this checklist (knowing that it's not a cure-all) to make certain we have things set to MM's recommendations. Thoughts? | -Original Message- | From: Vernon Viehe [mailto:[EMAIL PROTECTED]] | Sent: Tuesday, October 08, 2002 11:44 AM | To: CF-Talk | Subject: RE: LONG time CF Supporter - About ready to dump CF! | | | Lee, Cameron, I'm mulling over thoughtful responses to your | thoughtful posts... | | But I couldn't resist a quick reply here: | | Macromedia's merger with Allaire was very expensive, and as | is the case with any merger, it's not been totally without | merger pains, which has been felt internally by most every employee. | | Please don't mistake the challenges presented from a merger | and also the challenges of a ground-up rewrite as lack of | full backing from Macromedia. I can assure you, we didn't go | through the expense and pains of such a challenging merger, | just to back-burner CF. CF is an extremely important part of | Macromedia's product line. | | There are folks running CFMX quite successfully - that's not | to say that there's no work to be done, but it's not all | blood gore. We've made it through other rough spots, and | we'll make it through this one as well. It's as important to | our livelihood as it is to your livelihoods. | | Vernon Viehe | ColdFusion
RE: The Myth of Bugs (Was Huge Ungainly thread of Doom)
See below... -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 09, 2002 12:47 PM To: CF-Talk Subject: RE: The Myth of Bugs (Was Huge Ungainly thread of Doom) How can we catch on when they do not contact us via the proper manner? It seems participation in the community would do it. The way we have it now may not be the proper way in your eyes, but as that is the *currently supported method* it doesn't leave any room for argument, now does it? It isn't a matter of what I personally think. It is a matter of what the general sentiment in the community is. It is clear to me that the community prefers open and public interaction with their peers over calling technical support and giving a credit card number. It doesn't matter what Macromedia's policy is in this regard if the community doesn't agree. People will continue to avoid the route suggested by Macromedia until Macromedia changes its policy to one the community likes better. Saying that x sucks is fine, but it does not change x. Sure it does if enough people are saying it. -Matt I think Matt is right in stating this. For example, the voting system in Florida (it sucked, they changed it), rights of homosexuals (let's not get into a debate on this, please), the founding of America, abortion, women voting, African-American rights...etc. Now what I mean by these examples, is that x sucked and people changed it. Is it the same as the discussion at hand, yes, more or less. If the community feels strongly and can make a difference, then MM (with the help of Vern, Lee, Sean, Ben, etc) will eventually come to change their policy. Just my thoughts! T ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: The Myth of Bugs (Was Huge Ungainly thread of Doom)
Nah, maybe some chopped up filet mignon! ;-) -Original Message- From: Vernon Viehe [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 09, 2002 2:32 PM To: CF-Talk Subject: RE: The Myth of Bugs (Was Huge Ungainly thread of Doom) Thanks Michael! I was about to wave my hands and ask What am I, chopped liver? Rick, maybe it was Jesse's comment including me when he said monitoring this list in not our fulltime job - that was (inadvertantly) not perfectly accurate regarding my duties, though admittedly, I do have to spread myself out amongst the various lists and forums for CF, as well as actually work to make progress internally on community issues. I also have other community responsibilities such as arranging Designer Developer content, organizing Team Macromedia volunteers for ColdFusion, and other less visible activities that support the community. Nevertheless, I take it as valuable criticism that you didn't realize that I'm supposed to be fulfilling this role, and try to act upon that (well, for the most part, respective of the comments Sean made regarding direct support in these venues). I hope my note here gives more visibility to how we can work together on those things which support the community. Thanks, Vernon Viehe ColdFusion Community Manager Developer Relations Macromedia, Inc. Online diary: http://vvmx.blogspot.com/ Macromedia DevCon 2002, October 27-30, Orlando, Florida Architecting a New Internet Experience Register today at www.macromedia.com/go/devcon2002 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 09, 2002 9:57 AM To: CF-Talk Subject: Re: The Myth of Bugs (Was Huge Ungainly thread of Doom) That person is Vernon, basically. He's the CF community manager for MM. Of course, there are others from MM on the list that do monitor and answer questions such as Sean, but when the internal responsibility comes around, Vernon's the guy. And personally, I think he's doing a great job. I've just been monitoring the thread, but from what I've read earlier, this and maybe other CF-lists and other software lists might be worth assigning someone to, to monitor and respond to as their day job. Public relations and perception can make or break a company these days and it seems to me, especially with a company the size of MM, that there would be funds to hire a Mailing List / Forum Troubleshooter who is an expert in the software AND its use in production who could provide a first response technical support to users, free of charge...public relations people who are not experts in the software and its use are really not always helpful, except to soothe the frayed nerves of customers whose businesses are falling apart because they can't get things working. And sometimes you need an answer in minutes, not hours or days. After providing first response, let the Troubleshooter then decide which issues should be taken into the formal chain of technical support. One of the great benefits of public lists like this and the support one can get is that the support is public and not isolated in a support network. Solve it for one, you solve it for many. Cuts down on MM's formal support requirements. I believe this Troubleshooter position should be formal, paid, and full-time, because it's in MM's and the CF (et al) community's best interest. Would that work? Rick Rick Faircloth, Prism Productions -Original Message- From: Jesse Noller [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 09, 2002 9:52 AM To: CF-Talk Subject: RE: The Myth of Bugs (Was Huge Ungainly thread of Doom) Whilst I agree with your general point that there's possibly a misintepretation of doom and gloom for CFMX within the recent threads, I'd like to also point out that from what I can see, the developers highlighting the problems are actually seeking help from Macromedia in order to continue using CFMX - NOT in order to give up on it altogether. Threads like the one yesterday, if you go back and read them, degenerated into a series of throw it out the door and I won't be buying it etc, etc, etc. People need to realize that yes while software might have issues, and they do want help publicly, there are other people who are reading these mediums who are directly making decisions based off of the words of the people within this community. If I was a new CFMX customer, and I read the threads from the past few days(weeks) I would send my boxed copy back to macromedia saying that was fun, no? New users, and on the fence users are strongly influenced by the posts here and on the forums by you, the cf luminaries. I have in fact advised a few people either within the Long time CF supporter thread and also outside of it during the last couple of days, to go ahead
OT: SQL Question
Hi all, Here's what I want to do: UPDATE tablename SET column = 0 WHERE ID = ??? I want to specify a range of numbers (like 100-200) and increment it by 2. So, 100, 102,104etc would only be updated and the rest wouldn't. Any ideas? Thanks, T ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: LONG time CF Supporter - About ready to dump CF!
-Original Message- From: Ben Johnson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 08, 2002 3:04 PM To: CF-Talk Subject: RE: LONG time CF Supporter - About ready to dump CF! In Matt's defense, unpopularity is not a sign of poor communication skills. Mike, Agreed. I did not mean to say that he is unpopular but that many of his posts come across as... well... less than tactful. I think Matt's a smart guy but I just think that there are better ways to communicate what he's saying. I personally like the striaght out approach. I am so sick of politically correct or tactfulness. It's time to move to point blank answers. Does a pot calling a kettle black make the kettle any less black? Matt, No, however it questions the validity of the statement. Also, if you do in fact agree that you have communication problems, I haven't seen you publicly apologize for any poor communication you've had with anybody on any list. You seem to expect Macromedia to change its ways but you still maintain your same ways. Is that fair? Ben Johnson Information Architect www.architekture.com [p] 720.934.2179 I don't think it's fair to say he must publicly apologize for his communication problems. That's absurd to even contemplate that. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
I lost my brain - checkboxes
Hi all, Sorry for the stupid post today but I cannot think. I have an input field on a form: input type=checkbox name=hotlead value=cfoutput#SID#/cfoutput (SID is the primary key in the SQL 2K DB). then on the page: cfloop query=GetInfo tr tdinput type=checkbox name=hotlead value=cfoutput#SID#/cfoutput cfif Hot EQ 1checked/cfif/td /tr /cfloop So here is my problem. When a checkbox (or more) is checked, I do this SQL statement: UPDATE survey SET Hot = 1 WHERE SID IN (10,17) and this works great. However, if I deselect the checkbox I no longer have the SID: UPDATE survey SET Hot = 1 WHERE SID IN 0 (makes sense the value is the SID). So how do I do this? I want to set the Hot field to 1 on only the SID when checked and if i deselect it, then i want the field to be set to 0 on the SID i deselect. The default value in the Hot (bit) field is 0. Thanks, Tony ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: I lost my brain - checkboxes
Thanks everyone for your help! I appreciate it! -Original Message- From: Everett, Al [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 2:00 PM To: CF-Talk Subject: RE: I lost my brain - checkboxes I've done stuff where I also pass the universe of values as a hidden tag. So if you have: cfloop query=qry input type=checkbox name=hotlead value=cfoutput#SID#/cfoutput /cfloop I would also put: input type=hidden name=listofleads value=cfoutput#ValueList(qry.SID)#/cfoutput Now on your next page you'll have the SIDs that are checked as well as all the SIDs. Some simple list manipulation (and there are some good UDFs at cflib.org for that) and you'll have all you need. -Original Message- From: Tony Carcieri [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 1:39 PM To: CF-Talk Subject: I lost my brain - checkboxes Hi all, Sorry for the stupid post today but I cannot think. I have an input field on a form: input type=checkbox name=hotlead value=cfoutput#SID#/cfoutput (SID is the primary key in the SQL 2K DB). then on the page: cfloop query=GetInfo tr tdinput type=checkbox name=hotlead value=cfoutput#SID#/cfoutput cfif Hot EQ 1checked/cfif/td /tr /cfloop So here is my problem. When a checkbox (or more) is checked, I do this SQL statement: UPDATE survey SET Hot = 1 WHERE SID IN (10,17) and this works great. However, if I deselect the checkbox I no longer have the SID: UPDATE survey SET Hot = 1 WHERE SID IN 0 (makes sense the value is the SID). So how do I do this? I want to set the Hot field to 1 on only the SID when checked and if i deselect it, then i want the field to be set to 0 on the SID i deselect. The default value in the Hot (bit) field is 0. Thanks, Tony ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Flash FLA cross platform?
Possibly and embedded font or other Windows only file formats that you may have imported into the library. -Original Message- From: Joshua Miller [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 26, 2002 1:42 PM To: CF-Talk Subject: Flash FLA cross platform? I started a Flash file on a Windows machine at the office ... I need to take it home on my Mac, when I try to open the file on the Mac I get the message: This document contains embedded objects that were created with the Micrsoft Windows version of Flash. These embedded objects must be deleted before opening on the Macintosh. Anyone know what that's all about? I thought Flash files were cross-platform from Mac to PC. Thanks, Joshua Miller [EMAIL PROTECTED] __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Array Help
Hi everyone, I am developing a sales thing for our reps and I got yanked off a project to do it and my brain is fuzzy. I have a column that gets returned that is titled Hot (a bit field in a SQL 2K DB). This column has checkboxes that can be checked so that the DB will flag them for future contact. The check box contains a dual value: 1, and the PK. So what I would like to do is when the check box is checked, set the Hot field to 1 for that particular record. My problem is that both values are numbers and not text. I am also unsure of how to accomplish this if someone selects like 20 checkboxes. I would need to update all associated records. Thanks! Tony Here is my VERY feabile attempt thus far. I just wanted to make sure the records were coming back correctly. I haven't started the update to the DB yet. So advice there would be greatly appreciated as well. cfset x = ListToArray(hot, ,) CFLOOP From = 1 TO = #ArrayLen(x)# INDEX = Counter cfoutputLI #Counter#: #ListGetAt(x, Counter)#/cfoutput /CFLOOP The error I get: Error Diagnostic Information An error occurred while evaluating the expression: #ListGetAt(x, Counter, ,)# Error near line 54, column 29. __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Array Help - SOLVED
I figured it out. Just FYI: cfset x = ListToArray(hot, ,) cfset y = ArrayToList(x,,) CFLOOP From = 1 TO = #ArrayLen(x)# INDEX = Counter cfoutputLI #Counter#: #ListGetAt(y, Counter)#/cfoutput /CFLOOP -Original Message- From: Tony Carcieri [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 2:28 PM To: CF-Talk Subject: Array Help Hi everyone, I am developing a sales thing for our reps and I got yanked off a project to do it and my brain is fuzzy. I have a column that gets returned that is titled Hot (a bit field in a SQL 2K DB). This column has checkboxes that can be checked so that the DB will flag them for future contact. The check box contains a dual value: 1, and the PK. So what I would like to do is when the check box is checked, set the Hot field to 1 for that particular record. My problem is that both values are numbers and not text. I am also unsure of how to accomplish this if someone selects like 20 checkboxes. I would need to update all associated records. Thanks! Tony Here is my VERY feabile attempt thus far. I just wanted to make sure the records were coming back correctly. I haven't started the update to the DB yet. So advice there would be greatly appreciated as well. cfset x = ListToArray(hot, ,) CFLOOP From = 1 TO = #ArrayLen(x)# INDEX = Counter cfoutputLI #Counter#: #ListGetAt(x, Counter)#/cfoutput /CFLOOP The error I get: Error Diagnostic Information An error occurred while evaluating the expression: #ListGetAt(x, Counter, ,)# Error near line 54, column 29. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Array Help - SOLVED
Yea, it was a stupid mistake. Not enough caffeine today. -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 4:10 PM To: CF-Talk Subject: RE: Array Help - SOLVED I lost this thread half way through, but why do you need hot as a list and an array? Ade -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: 25 September 2002 20:53 To: CF-Talk Subject: RE: Array Help - SOLVED You'll probably get better performance ( if only slightly ) from putting your cfoutput outside your loop ... just because the cfml parser then only has to initiate and drop the cfoutput once instead of once for each iteration of your loop. Just 2c... I figured it out. Just FYI: cfset x = ListToArray(hot, ,) cfset y = ArrayToList(x,,) CFLOOP From = 1 TO = #ArrayLen(x)# INDEX = Counter cfoutputLI #Counter#: #ListGetAt(y, Counter)#/cfoutput /CFLOOP -Original Message- From: Tony Carcieri [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 2:28 PM To: CF-Talk Subject: Array Help Hi everyone, I am developing a sales thing for our reps and I got yanked off a project to do it and my brain is fuzzy. I have a column that gets returned that is titled Hot (a bit field in a SQL 2K DB). This column has checkboxes that can be checked so that the DB will flag them for future contact. The check box contains a dual value: 1, and the PK. So what I would like to do is when the check box is checked, set the Hot field to 1 for that particular record. My problem is that both values are numbers and not text. I am also unsure of how to accomplish this if someone selects like 20 checkboxes. I would need to update all associated records. Thanks! Tony Here is my VERY feabile attempt thus far. I just wanted to make sure the records were coming back correctly. I haven't started the update to the DB yet. So advice there would be greatly appreciated as well. cfset x = ListToArray(hot, ,) CFLOOP From = 1 TO = #ArrayLen(x)# INDEX = Counter cfoutputLI #Counter#: #ListGetAt(x, Counter)#/cfoutput /CFLOOP The error I get: Error Diagnostic Information An error occurred while evaluating the expression: #ListGetAt(x, Counter, ,)# Error near line 54, column 29. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT - How do you feel about...
G'morning everyone! Sorry for the OT Cross post! I have registered cfdeveloper.com and what I would like to do is have an area where some of the questions posed and answered would be available there as well in an edited version. I realize that we have the archives available but I thought this as another resource. My question/concern is this: would you be willing to have your questions and responses posted there in an edited version? By edited, I mean that the question would be posed and the various answers would be listed that solved the problem. I just don't want to post anything that someone would not like posted or be accused of anything. Just would like your feelings, opinions, concerns, or whatever. Please reply to me off list. Thanks very much! Tony Big T Carcieri PS I am in the EARLY stages of designing this so it wouldn't be for a bit! __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT - How do you feel about...
Hi all, Last OT post on this subject. Michael raised some issues/concerns to me that I haven't thought to hard about yet. As I explained to him, here is a paraphrase as to what I was thinking. Again, please email me off list. Excerpt: I would obviously give credit to where and whom answered the question(s). As far as technical writer and/or content editory, perhaps I could do both? (A challenge in and of itself). What I was thinking is this: Question: Can someone explain structs to me? Answer: blah blah blah. or blah blah and blah. Source: cftalk Contributors: Michael D, Matt S, Tony W, Tony C. The answer would be a combined paraphrase of the answers. Does anyone have issues with this? Thanks, Big T __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT - How do you feel about...
Awesome! Thanks a million. I am not taking everything just topics that seem to come up very frequently. Although I would LOVE to be the be all end all if you will, I don't have the time nor money to do it. Once again, this project is in its pre-infancy stage. I just wanted to cover my butt and get the opinions of my fellow CF fanatics. *grin* Thanks! Tony -Original Message- From: Perez, Jimmy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 17, 2002 3:31 PM To: CF-Talk Subject: RE: OT - How do you feel about... I think something like a central repository would be very useful, and you can quote me. (the preceeding is copyright 2002 respective owner all rights reserved) ;=) -Original Message- From: Massimo, Tiziana e Federica [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 17, 2002 2:01 PM To: CF-Talk Subject: Re: OT - How do you feel about... What I was thinking is this: Question: Can someone explain structs to me? Answer: blah blah blah. or blah blah and blah. Source: cftalk Contributors: Michael D, Matt S, Tony W, Tony C. The answer would be a combined paraphrase of the answers. Does anyone have issues with this? I, at least, would prefer to give explicit permission on a case by case basis. But maybe it's just me Massimo Foti Team Macromedia Volunteer for Dreamweaver http://www.macromedia.com/go/team __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT - How do you feel about...
Sorry that wasn't supposed to go to CF Talk!!! My humblest apologies! -Original Message- From: Tony Carcieri [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 17, 2002 3:36 PM To: CF-Talk Subject: RE: OT - How do you feel about... Awesome! Thanks a million. I am not taking everything just topics that seem to come up very frequently. Although I would LOVE to be the be all end all if you will, I don't have the time nor money to do it. Once again, this project is in its pre-infancy stage. I just wanted to cover my butt and get the opinions of my fellow CF fanatics. *grin* Thanks! Tony -Original Message- From: Perez, Jimmy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 17, 2002 3:31 PM To: CF-Talk Subject: RE: OT - How do you feel about... I think something like a central repository would be very useful, and you can quote me. (the preceeding is copyright 2002 respective owner all rights reserved) ;=) -Original Message- From: Massimo, Tiziana e Federica [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 17, 2002 2:01 PM To: CF-Talk Subject: Re: OT - How do you feel about... What I was thinking is this: Question: Can someone explain structs to me? Answer: blah blah blah. or blah blah and blah. Source: cftalk Contributors: Michael D, Matt S, Tony W, Tony C. The answer would be a combined paraphrase of the answers. Does anyone have issues with this? I, at least, would prefer to give explicit permission on a case by case basis. But maybe it's just me Massimo Foti Team Macromedia Volunteer for Dreamweaver http://www.macromedia.com/go/team __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: CF 5 books
Hey all, Sorry for the OT post. I am wondering which CF 5 book to get. I know Ben Forta's books are awesome and well done. However, I also know that Simon (from my CFDJList) is an invaluable contributor and has done the worx series on CF 5. So, question is this: which book (out of those 2) do you find more informative on UDF's, CFSCRIPT, Arrays, Structs, etc? Thanks for the recommendations! Oh, and email me off list . Thanks, Tony __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Developer Platform suggestions was Re: Nice
I haven't had a Dimension, but can speak VERY highly for their Optiplex and Inspiron lines. I used to have a VERY sweet system at a previous job: Dell Optiplex Dual P3 800 1 GB RAM CD Burner 60 GB HD Dual 21 inch monitors Ahh, I miss that computer. Blazingly fast. -Original Message- From: Kreig Zimmerman [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 11, 2002 11:19 AM To: CF-Talk Subject: Re: Developer Platform suggestions was Re: Nice I have to say as regards Dell... I've found the OptiPlex (business line) to be rock-solid Dimension (consumer-line)... always some weird problem. Any similar experience? Point is if Dell, I would HIGHLY recommend you go for their business-line system. Tony Carcieri wrote: Damn, I didn't know they were doing that! I have always had a Dell at work and have never had problems. i tried to talk my father-in-law into it, but nope, he liked his Gateway...he's wishing he had a Dell now ;-) -- Kreig Zimmerman : Chief Information Architect : [EMAIL PROTECTED] Four Eyes Productions : Brooklyn, NY __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Nice
Ok, I tried it and didn't see anything different...does this work on DWMX version? -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 10, 2002 11:40 AM To: CF-Talk Subject: Re: Nice Its not even Easter!! Be patient... ;o) - Original Message - From: Dick Applebaum [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, September 10, 2002 4:17 PM Subject: Re: Nice I'll bite -- where? On Tuesday, September 10, 2002, at 08:10 AM, Bryan F. Hogan wrote: I like the CF Easter Egg __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Nice
Sorry, shoulda been more specific...I have the eval version from the DWMX cd. As far as the settings in IE, I did it. Including throwing the language da top. Thanks, Big T -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 10, 2002 12:23 PM To: CF-Talk Subject: RE: Nice DWMX? *eyes Tony* No, they meant to do that in IE and .. you have to make sure that CFMX is 1st in the list, highlight it and move it up. ~Todd On Tue, 10 Sep 2002, Tony Carcieri wrote: Ok, I tried it and didn't see anything different...does this work on DWMX version? -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 10, 2002 11:40 AM To: CF-Talk Subject: Re: Nice Its not even Easter!! Be patient... ;o) - Original Message - From: Dick Applebaum [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, September 10, 2002 4:17 PM Subject: Re: Nice I'll bite -- where? On Tuesday, September 10, 2002, at 08:10 AM, Bryan F. Hogan wrote: I like the CF Easter Egg __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Developer Platform suggestions was Re: Nice
Ditto. I have used it since it first came out. The only suggestion/concern I have is this: my father-in-law has a Gateway System (about 2 years old now) and when he installed SP3, it crashed his computer HARD! All he got was a blue screen. Me, personally, have not had any trouble on both Dell machines and I am running SP3 with all sec. patches. HTH, Big T -Original Message- From: Jeffry Houser [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 10, 2002 1:23 PM To: CF-Talk Subject: Re: Developer Platform suggestions was Re: Nice I've used Windows 9x and they worked okay as long as you rebooted at least once a day (preferably twice). I use Windows 2000 now. I've had few problems and the system is very stable, even if I don't reboot it for 3-4 days. At 10:12 AM 9/10/2002 -0700, you wrote: Ya' know, it gets pretty old... I am beginning to accept the fact that as a Mac/CF developer, I will always be a second-class citizen, and not have equal resources with the competition. So, I am open to suggestions: If you could chose a platform today, with no baggage, what would it be? I am seriously looking for suggestions! TIA Dick On Tuesday, September 10, 2002, at 09:56 AM, Stephen Moretti wrote: It doesn't work on a Mac -- why doesn't that surprise me? Dick On Tuesday, September 10, 2002, at 08:18 AM, Bryan F. Hogan wrote: http://cfm.blogspot.com/ What easter egg? At 11:10 AM 9/10/2002 -0400, you wrote: I like the CF Easter Egg Ok I shouldn't really do this on CF-Talk, but I can't resist. Sorry Michael. Does anything work on a Mac??? Sorry Dick Only joking! Stephen __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Developer Platform suggestions was Re: Nice
Damn, I didn't know they were doing that! I have always had a Dell at work and have never had problems. i tried to talk my father-in-law into it, but nope, he liked his Gateway...he's wishing he had a Dell now ;-) I am actually pricing out a new system: P4 2.8 GHZ 1 GIG O RAM 128MB Video Dual 15in flat mon 120 GB HD CDRW DVD ROM Should be enough power to run all the crap on my poor P3 450 256 Ram Dell Inspiron... That thing is running: SQL 2K CFMX CF5 DWMX HS + Flash5 Flash MX NET SDK Java2 and a SLEW of other crap. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 10, 2002 2:38 PM To: CF-Talk Subject: RE: Developer Platform suggestions was Re: Nice See Dick, there is something worst than a Mac. A Gateway! *cringes* I refuse to touch a gateway, especially since years ago when I heard they were recycling refurbished parts as 'real parts' and ... well, my parents had a gateway and that was a war story itself. :P ~Todd On Tue, 10 Sep 2002, Tony Carcieri wrote: Ditto. I have used it since it first came out. The only suggestion/concern I have is this: my father-in-law has a Gateway System (about 2 years old now) and when he installed SP3, it crashed his computer HARD! All he got was a blue screen. Me, personally, have not had any trouble on both Dell machines and I am running SP3 with all sec. patches. HTH, Big T -- Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ | Team Macromedia Volunteer for ColdFusion | http://www.macromedia.com/support/forums/team_macromedia/ | http://www.flashCFM.com/ - webRat (Moderator)| http://www.ultrashock.com/ - webRat (Back-end Moderator) | __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: VB
Dim only declares the var.. Try this: Dim x x = -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Monday, September 09, 2002 4:17 PM To: CF-Talk Subject: RE: VB Isn't it DIM Robert Everland III Web Developer Extraordinaire Dixon Ticonderoga Company http://www.dixonusa.com -Original Message- From: Scott Mulholland [mailto:[EMAIL PROTECTED]] Sent: Monday, September 09, 2002 4:15 PM To: CF-Talk Subject: OT: VB Anyone know if there is an equivalent of what cfparam in VB. I need to set a default for a variable in case it does not exist. Thanks, Scott __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Preventing User from Re-submitting Add Record Form
couldn't you use recordcount? cfif #somevalue.recordcount GT 1 !---go back a page or some other piece of code--- cfelse !---do something else--- /cfif i know in ASP this is done (I am doing that right now for a client). HTH, T -Original Message- From: Everett, Al [mailto:[EMAIL PROTECTED]] Sent: Monday, September 09, 2002 4:46 PM To: CF-Talk Subject: RE: Preventing User from Re-submitting Add Record Form There's a couple of ways to handle that. One is to set a session variable or cookie at the time they reach the confirmation page. The idea being that your form template would check for the existence of that session variable or cookie and, if found, stop them from submitting the form. Another way would be to put a timestamp on all your database records. Then, before inserting, check to see if an identical record was submitted within, say, the last half hour. This is more labor-intensive, but removes any issues with blocked cookies, proxy servers, browser caching, et. al. Obviously, if an identical record is allowed you'll need to account for that. To expand on this, you may present the user with a message that the record appears to already have been submitted and ask if they're sure they want to submit it again. There are other ways to handle it as well. (Stay tuned for the history.forward() trick.) -Original Message- From: Bob Haroche [mailto:[EMAIL PROTECTED]] Sent: Monday, September 09, 2002 4:32 PM To: CF-Talk Subject: Preventing User from Re-submitting Add Record Form I've a simple membership app which allows a user to add a new member record. Once the record is added, the user is sent to a page displaying the results of the data provided. If the user has inputted incorrect data, this confirmation page has a link to update the newly added record. That's all fine. But here's the problem: if the user instead uses the browser back button, they're returned to the Add New Record page where they can change the information previously provided. Once they re-submit that form, of course, the original record is not updated but instead a second, new record is created. How do I best prevent the user from re-submitting the Add New Member form when what they really need to do is use the Edit Member record form. A google search reveals the existence of a Submit Once CF custom tag, which might help(?), but it's no longer available on the MM site. TIA. Regards, Bob Haroche O n P o i n t S o l u t i o n s www.OnPointSolutions.com __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: VB
Hmm, maybe I am having a brainfart. If I do: cfparam name=foo default= doesn't that set the value to ? If so, then doing what I suggested in VB should work the same. Again, my brain ain't working today. HTH, T -Original Message- From: Benoit Martin [mailto:[EMAIL PROTECTED]] Sent: Monday, September 09, 2002 4:48 PM To: CF-Talk Subject: RE: VB Unfortunately I don't know the answer but I don't think that what you proposed would work. This will initialize the var to no matter what. In my understanding Scott is looking for code that would declare the var only if it's not already defined Ben -Original Message- From: Tony Carcieri [mailto:[EMAIL PROTECTED]] Sent: Monday, September 09, 2002 10:24 AM To: CF-Talk Subject: RE: VB Dim only declares the var.. Try this: Dim x x = -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Monday, September 09, 2002 4:17 PM To: CF-Talk Subject: RE: VB Isn't it DIM Robert Everland III Web Developer Extraordinaire Dixon Ticonderoga Company http://www.dixonusa.com -Original Message- From: Scott Mulholland [mailto:[EMAIL PROTECTED]] Sent: Monday, September 09, 2002 4:15 PM To: CF-Talk Subject: OT: VB Anyone know if there is an equivalent of what cfparam in VB. I need to set a default for a variable in case it does not exist. Thanks, Scott __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: VB
Yup...wasn't thinking. Well, how about: % If x Then 'do something Else 'x = End If % -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Monday, September 09, 2002 5:07 PM To: CF-Talk Subject: Re: VB That only sets the value to if the parameter does not exist. If it does exist, then it is ignored and uses the current value Douglas Brown Email: [EMAIL PROTECTED] - Original Message - From: Tony Carcieri [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, September 09, 2002 1:55 PM Subject: RE: VB Hmm, maybe I am having a brainfart. If I do: cfparam name=foo default= doesn't that set the value to ? If so, then doing what I suggested in VB should work the same. Again, my brain ain't working today. HTH, T -Original Message- From: Benoit Martin [mailto:[EMAIL PROTECTED]] Sent: Monday, September 09, 2002 4:48 PM To: CF-Talk Subject: RE: VB Unfortunately I don't know the answer but I don't think that what you proposed would work. This will initialize the var to no matter what. In my understanding Scott is looking for code that would declare the var only if it's not already defined Ben -Original Message- From: Tony Carcieri [mailto:[EMAIL PROTECTED]] Sent: Monday, September 09, 2002 10:24 AM To: CF-Talk Subject: RE: VB Dim only declares the var.. Try this: Dim x x = -Original Message- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: Monday, September 09, 2002 4:17 PM To: CF-Talk Subject: RE: VB Isn't it DIM Robert Everland III Web Developer Extraordinaire Dixon Ticonderoga Company http://www.dixonusa.com -Original Message- From: Scott Mulholland [mailto:[EMAIL PROTECTED]] Sent: Monday, September 09, 2002 4:15 PM To: CF-Talk Subject: OT: VB Anyone know if there is an equivalent of what cfparam in VB. I need to set a default for a variable in case it does not exist. Thanks, Scott __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Structures
http://www.macromedia.com/v1/handlers/index.cfm?id=18894method=full -Original Message- From: chris.alvarado [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 04, 2002 4:59 PM To: CF-Talk Subject: CF Structures I am a bit limited in my dealings with Cold Fusion structures. And as such, I was wondering if anyone has any links to good reference onlive dealing with CF Structures? Thanks a ton for any and all help, -chris.alvarado [ application developer ] 4 Guys Interactive, Inc. http://www.4guys.com -- I can picture in my mind a world without war, a world without hate. And I can picture us attacking that world, because they'd never expect it. -- Jack Handy __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: programmer vs. developer
Uh I think you forgot the Architect label at the end! ;-) -Original Message- From: Lee Fuller [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 6:34 PM To: CF-Talk Subject: RE: programmer vs. developer Nono.. It's Senior Programming Development Applications Design Analyst | -Original Message- | From: Tony Carcieri [mailto:[EMAIL PROTECTED]] | Sent: Wednesday, August 28, 2002 1:06 PM | To: CF-Talk | Subject: RE: programmer vs. developer | | | and now I am applying for the position of Senior Applications | Programmer Analyst | | -Original Message- | From: Tony Carcieri [mailto:[EMAIL PROTECTED]] | Sent: Wednesday, August 28, 2002 2:30 PM | To: CF-Talk | Subject: RE: programmer vs. developer | | | ok so what happens in this case: | | Web Designer | Web Developer | Web Application Designer | Web Application Developer | | imho: | designer = graphic intensive training (ps, fw, flash (no | actionscript), director (no lingo), etc) programmer = coder | but more along the lines of c++, c, vb and web technologies | developer = more web languages (cf, asp, sql, vb, java, | swing, js, jscript, html, dhtml, xml, wap/wml etc) | | And then you get a title like Web Application Engineer and | that is where i stop trying to figure it out! ;-) | | Big T | | -Original Message- | From: Tony Weeg [mailto:[EMAIL PROTECTED]] | Sent: Wednesday, August 28, 2002 1:56 PM | To: CF-Talk | Subject: RE: programmer vs. developer | | | imho: | | developer has these as his/her strong suit: | 50/50 on graphical interface/programming work | | photoshop/fireworks | flash | cf | sql | javascript | dhtml | | a programmer is a language guru: | | all ecma based scripts | cf | maybe some vbscript/asp (if that be their flavor of | choice) | sql (cant get too far without this guy) | | | | tony | | Tony Weeg | Senior Web Developer | Information System Design | Navtrak, Inc. | Fleet Management Solutions | www.navtrak.net | 410.548.2337 | | -Original Message- | From: Phoeun Pha [mailto:[EMAIL PROTECTED]] | Sent: Wednesday, August 28, 2002 1:42 PM | To: CF-Talk | Subject: programmer vs. developer | | | whats the difference? | | | | __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: programmer vs. developer
ok so what happens in this case: Web Designer Web Developer Web Application Designer Web Application Developer imho: designer = graphic intensive training (ps, fw, flash (no actionscript), director (no lingo), etc) programmer = coder but more along the lines of c++, c, vb and web technologies developer = more web languages (cf, asp, sql, vb, java, swing, js, jscript, html, dhtml, xml, wap/wml etc) And then you get a title like Web Application Engineer and that is where i stop trying to figure it out! ;-) Big T -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 1:56 PM To: CF-Talk Subject: RE: programmer vs. developer imho: developer has these as his/her strong suit: 50/50 on graphical interface/programming work photoshop/fireworks flash cf sql javascript dhtml a programmer is a language guru: all ecma based scripts cf maybe some vbscript/asp (if that be their flavor of choice) sql (cant get too far without this guy) .tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Phoeun Pha [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 1:42 PM To: CF-Talk Subject: programmer vs. developer whats the difference? __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: programmer vs. developer
and now I am applying for the position of Senior Applications Programmer Analyst -Original Message- From: Tony Carcieri [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 2:30 PM To: CF-Talk Subject: RE: programmer vs. developer ok so what happens in this case: Web Designer Web Developer Web Application Designer Web Application Developer imho: designer = graphic intensive training (ps, fw, flash (no actionscript), director (no lingo), etc) programmer = coder but more along the lines of c++, c, vb and web technologies developer = more web languages (cf, asp, sql, vb, java, swing, js, jscript, html, dhtml, xml, wap/wml etc) And then you get a title like Web Application Engineer and that is where i stop trying to figure it out! ;-) Big T -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 1:56 PM To: CF-Talk Subject: RE: programmer vs. developer imho: developer has these as his/her strong suit: 50/50 on graphical interface/programming work photoshop/fireworks flash cf sql javascript dhtml a programmer is a language guru: all ecma based scripts cf maybe some vbscript/asp (if that be their flavor of choice) sql (cant get too far without this guy) tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Phoeun Pha [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 1:42 PM To: CF-Talk Subject: programmer vs. developer whats the difference? __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF vs. ASP
Just another tidbit as well. Don't go for ASP 3.0 look into the whole .NET architecture. Yes, I love my CF but variety is the spice of life. Not too mention that ASP support is going to dwindle with the whole .NET (ASP included) push. Big T -Original Message- From: Jillian Carroll [mailto:[EMAIL PROTECTED]] Sent: Monday, August 26, 2002 4:15 PM To: CF-Talk Subject: RE: CF vs. ASP My .02 is: If you 'put all your eggs in one basket' you lock yourself out of another potentially rewarding market: the website/application UPGRADE. People may have existing sites in .asp, .php, etc that are perfectly usable and functional... and they want to add functionality. If you only know CF, you may be limiting yourself quite a lot. -- Jillian On Mon, 26 Aug 2002, Perez, Jimmy wrote: Hello all, I am a CF certified developer (missed advanced by three points) but am thinking of expanding my horizons/marketability. I have started getting up to speed in ASP/VBScript but the question keeps coming up: should I even spend any time doing this or should I just concentrate on CF? The more e-mails I read in this list, the more I realize how powerful CF is, but should I keep all my eggs in one basket so to speak? Any good advice? TIA Jimmy __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Way Off Topic - Need help sending email with ASP
Dim objmail Dim vbody Set objmail = CreateObject(CDONTS.Newmail) vbody = vbody Name: Request(requiredName) vbcrlf vbody = vbody Title: Request(requiredTitle) vbcrlf vbody = vbody Company: Request(requiredCompany) vbcrlf vbody = vbody Address: Request(requiredAddress1) vbcrlf vbody = vbody City: Request(requiredCity) vbcrlf vbody = vbody State / Province: Request(requiredStateProvince) vbcrlf vbody = vbody Zip: Request(requiredZip) vbcrlf vbody = vbody Country: Request(requiredCountry) vbcrlf vbody = vbody Phone: Request(requiredPhone) vbcrlf vbody = vbody Fax: Request(Fax) vbcrlf vbody = vbody Email: Request(requiredEmail) vbcrlf objmail.From = Request(requiredEmail) objmail.To = [EMAIL PROTECTED] objmail.Subject = Here's some help objmail.Body = vbody objmail.send Set objmail = Nothing -Original Message- From: James Johnson [mailto:[EMAIL PROTECTED]] Sent: Monday, August 26, 2002 4:23 PM To: CF-Talk Subject: Way Off Topic - Need help sending email with ASP Hi, I know this is way off topic, but really need some help quickly. I can do this easily with CF, but ASP is a way different beast. Has anyone had any experience sending email via ASP/VBScript? I can format the mail headers, to, from, subject, and, can send the mail, but can't get a variable containing a string of other info to show up in the subject. I know the CDONTS mailer is working, or else no mail would be sent or received. I can't debug this in Dreamweaver, as there's no JavaScript. I can't easily figure out how to debug HTML/ASP code in Visual Studio .NET. Here's the code: Dim MyMail Dim MsgText Set MsgText = Request.Form(FirstName) + + Request.Form(LastName) + has requested more information. Set MsgText = MsgText + Please contact them at + Request.Form(Phone) Set MsgText = MsgText + VBCrLf Set MsgText = MsgText + Request.Form(FirstName) + VBCrLf Set MsgText = MsgText + Request.Form(LastName) + VBCrLf Set MsgText = MsgText + Request.Form(Addr1) + VBCrLf Set MsgText = MsgText + Request.Form(Addr2) + VBCrLf Set MsgText = MsgText + Request.Form(City) + VBCrLf Set MsgText = MsgText + Request.Form(State) + VBCrLf Set MsgText = MsgText + Request.Form(ZIP) + VBCrLf Set MsgText = MsgText + Request.Form(Email) + VBCrLf Set MsgText = MsgText + Request.Form(Phone) + VBCrLf Set MsgText = MsgText + Request.Form(Comments) + VBCrLf Set MsgText = MsgText + Request.Form(NoMkt) + VBCrLf Set MyMail = CreateObject(CDONTS.NewMail) MyMail.From = [EMAIL PROTECTED] MyMail.To = [EMAIL PROTECTED] MyMail.Subject = Information Request MyMail.BodyFormat = 1 'plain text MyMail.MailFormat = 1 'plain text MyMail.Body = MsgText MyMail.Send Set MyMail = Nothing Again, sorry for the off topic, but if there was a House of ASP mailing list :) Thanks, *** James Johnson SMB-Studios Innovative Online Learning for Spirit, Mind and Body www.smb-studios.com [EMAIL PROTECTED] __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT but Important Amber alert missing child should I post here?
As a new parent, a developer, and a subscriber to this list, I think it is a good idea. Just one post and maybe a link to the child's picture. As Isaac said, they can and do go across the country. What if you are alerted on this list one day, take note, and that same day, you go out to grab a bite for lunch and lo and behold, you see this abducted child? Yes, it may be a 1 in 10+ chance but it's still a chance. I say post it. Thanks, Big T -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 14, 2002 11:15 AM To: CF-Talk Subject: Re: OT but Important Amber alert missing child should I post here? Sorry, but I'm inclined to disagree. First, this is the internet. Mike is in California, where I would assume the Amber Alert is, I am not. Thus, the Amber Alert notification would not be for the region where the vast majority of people on this list live (which would be everywhere but California). Second, the SNR is high enough here anyway. Let the Amber Alert work in its standard channels (highway signs, TV, Radio) and let this list focus on CF. I know this sounds callous, I'm a parent, but it's how I feel. You have a valid opinion. The only comment I would make ( and I don't say this to argue with you or invalidate your opinion ) is that afaik the police and so forth who are looking for the missing child may not know where that child is. Sure, the child may have lived in CA, but kidnappers have been known ( though it may not be the most common behavior ) to drive all the way accross the country with their victims... or given circumstances, to Canada or Mexico, maybe even get a flight overseas. Who's to say where they'll go, though I will admit I'd expect the odds to be slim that they'd find their way out of nearby or neighboring states. Isaac Dealey Certified Advanced ColdFusion Developer www.turnkey.to 954-776-0046 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
DWMX and .nst?
Hi all, I remember, and I think it was on this list, something about DWMX and changing a file with an extension of .nst or .nsf or something similiar to don't change this code. Does anyone remember this or have that message? Please send it to me when you get a chance! Thanks, Big T __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: HELP!!
i believe it is .name instead of .value -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 2:15 PM To: CF-Talk Subject: HELP!! Last part of my appp... Need a quick answer I need to know how to reference the name of a select box (javascript) I can grab the ID and do everything I want to do But I need the displayed name of the selected index also... Please help -Original Message- From: Michael Wilson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 10:37 AM To: CF-Talk Subject: RE: Totally OT JavaScript Q I don't believe this can be done. Are you just seeking to hide the field Contents when focused? Hi, Exactly. The design of the site I am working on calls for a couple of form fields with initial values of UserName and PassWord. As you no doubt are aware, setting the initial value is normally no problem, however we need to mask the user's input to the password field; i.e. *. Obviously if the form element is of type password, the initial value is masked when the form loads. It's not a big deal really; I was just curious to see if a way existed to alter the type of the field, onClick or onFocus, so that I could meet both requirements. Thanks allot! Mike __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
tracking payments
Hi all, It's Monday, caffeine intake is low and I am having a brainfreeze. I need to keep track of payments made by the client (amount and date), as well as the commissions paid to the sales reps. The reps get paid each time a client makes a payment; ie if the client pays 1000 of his 2000 balance the rep gets a percent of the 1000 not the 2000. That being said, I am on a SQL 2K DB. I thought about having a couple of columns like: Total Cost Invoice Date Invoice Amount Balance Commissions However, I don't want to overwrite the existing data (as this is going to be available for tracking and allowing the reps to print out an intemized view). I am having trouble of thinking about the best way to do this. I don't want to put in a ton of colums (in case they are not used but likewist don't want to put too few). Anyone got any ideas? Thanks! T __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: tracking payments
Douglas, Yea something like that. I originally thought about normalizing it and then thought better of it. But now, it seems like it makes more sense to do it this way. The only forseeable problem is that this could be a many to one relationship. What I mean is this: Project Cost: 10,000 Project Name: Test Invoice Date: 1/1/2002 Invoice Amount: 1000 (commissions go to sales reps/mgr for % on 1000) Invoice Date: 2/4/2002 Invoice Amt: 3000 (commissions go to sales reps/mgr for % on 3000) so on and so forth till balance is 0 Is that possible to do? Thanks, T -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 2:17 PM To: CF-Talk Subject: Re: tracking payments hmmm I would say more like... [invoice] id sales_person_id Total Cost Invoice Date Invoice Amount Balance [commissions] id invoice_id sales_person_id commission_amount then do a SP to calculate the difference in the invoice amount and amount paid. Once this is done, then you can calculate the pay % for each sales person and insert it into the commissions table. Douglas Brown Email: [EMAIL PROTECTED] - Original Message - From: Tony Carcieri [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, July 22, 2002 10:57 AM Subject: tracking payments Hi all, It's Monday, caffeine intake is low and I am having a brainfreeze. I need to keep track of payments made by the client (amount and date), as well as the commissions paid to the sales reps. The reps get paid each time a client makes a payment; ie if the client pays 1000 of his 2000 balance the rep gets a percent of the 1000 not the 2000. That being said, I am on a SQL 2K DB. I thought about having a couple of columns like: Total Cost Invoice Date Invoice Amount Balance Commissions However, I don't want to overwrite the existing data (as this is going to be available for tracking and allowing the reps to print out an intemized view). I am having trouble of thinking about the best way to do this. I don't want to put in a ton of colums (in case they are not used but likewist don't want to put too few). Anyone got any ideas? Thanks! T __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
country codes and names
Morning Everyone, I was wondering if anyone has/knows of a place where I can get a table of country codes/names that would be compatible with sql 2K; ie CountryID CountryCode Country 1USUSA 2UKEngland etc. Thanks, T __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: country codes and names
AND TOBAGO TT TTO 780 TUNISIA TN TUN 788 TURKEY TR TUR 792 TURKMENISTANTM TKM 795 TURKS AND CAICOS ISLANDSTC TCA 796 TUVALU TV TUV 798 UGANDA UG UGA 800 UKRAINE UA UKR 804 UNITED ARAB EMIRATESAE ARE 784 UNITED KINGDOM GB GBR 826 UNITED STATES US USA 840 UNITED STATES MINOR OUTLYING ISLANDSUM UMI 581 URUGUAY UY URY 858 UZBEKISTAN UZ UZB 860 VANUATU VU VUT 548 VENEZUELA VE VEN 862 VIET NAMVN VNM 704 VIRGIN ISLANDS (BRITISH)VG VGB 092 VIRGIN ISLANDS (U.S.) VI VIR 850 WALLIS AND FUTUNA ISLANDS WF WLF 876 WESTERN SAHARA EH ESH 732 YEMEN YE YEM 887 YUGOSLAVIA YU YUG 891 ZAMBIA ZM ZMB 894 ZIMBABWEZW ZWE 716 -Original Message- From: Tony Carcieri [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 16, 2002 4:13 PM To: CF-Talk Subject: country codes and names Morning Everyone, I was wondering if anyone has/knows of a place where I can get a table of country codes/names that would be compatible with sql 2K; ie CountryID CountryCode Country 1USUSA 2UKEngland etc. Thanks, T __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFCookie?
Dave, Can't you also block 3rd party cookies from being set in your browser settings? -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 11, 2002 2:53 PM To: CF-Talk Subject: RE: CFCookie? Yea that's what I thought ;) SO I was wondering what these ASP boneheads are smoking thinking they are going to be able to read an ediets.com Cookie from their site. No, they won't be able to read the cookie that you set on your server. However, you could reference an image or other file on their server, and send the value that you want as a URL attribute. Then, they could set a cookie when the browser requests that file. That's how shared ad servers track people across multiple sites. Newer browser may display a warning when this is done, though, about the use of a third-party cookie. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: What's wrong here?
try True -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 27, 2002 4:16 PM To: CF-Talk Subject: What's wrong here? I must be brain dead, I cant figure out why this dont work. Right now the value of this field in the DB is 1 and when I run this, the checkbox does not even show up. If I take the cfelse portion out, then it works ok. cfif (get_inventory_for_update.power_brakes) EQ 1 cfset check = CHECKED cfelse cfset check = cfoutput input type=checkbox name=power_brakes value=#get_inventory_for_update.power_brakes# #check# /cfoutput /cfif Douglas Brown Email: [EMAIL PROTECTED] __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
security issues
Hi all, Sorry for the cross post but last week there was a discussion about the old hacks of cfsnippets or cfdocs or something. I don't remember exactly and don't remember which forum it was on. Could you please email me off list and refresh my memory of what they were and if it is possible that these hacks could bring down a site? We are getting some SERIOUS hits and the cfserver crashes. It ends up queueing so much that it just quits. Thanks very much for the speedy reply! Tony [EMAIL PROTECTED] __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Java for beginners?
I have found the Teach Yourself Java 2 in 21 days to be indispensible. It is by Sams and the authors are Lemay and Cadenhead. I have the second edition. It also included a bonus week where it looks at Swing. -Original Message- From: chris.alvarado [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 20, 2002 10:29 AM To: CF-Talk Subject: OT: Java for beginners? Hello all, Just wondering if anyone has any good Java book reccomends for beginners? My background is in CF, ASP, VB, SQL type stuff if that helps. Thanks for any and all help, -chris.alvarado [ application developer ] 4 Guys Interactive, Inc. http://www.4guys.com -- I can picture in my mind a world without war, a world without hate. And I can picture us attacking that world, because they'd never expect it. -- Jack Handy __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Creating Images Question
couldn't you do something like: cfset textToImage = #form.fieldname# cfif IsDefined(textToImage) cfset imagename = #textToImage#.jpg /cfif -Original Message- From: Brian Simmons [mailto:[EMAIL PROTECTED]] Sent: Friday, June 14, 2002 2:22 PM To: CF-Talk Subject: Creating Images Question I have a simple request and I'm sure there must be a custom tag (free or not, doesn't matter) to do it. I have some text, for example: Hello World I would like to be able to pass that text into the custom tag and have it create a JPG/GIF file that contains Hello World. Nothing fancy (image size, background color, text color, text font, that's all I need). Any suggestions, Brian -- Brian Simmons [EMAIL PROTECTED] The ultimate CF 5.0 Certification Exam testing tool: Check out CF_Buster at: http://www.centrasoft.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Creating Images Question
Yea ok I am suffering from a lack of sleep. I misread your message. Forget what i said totally. *gets up walks to coffee pot and chugs* -Original Message- From: Brian Simmons [mailto:[EMAIL PROTECTED]] Sent: Friday, June 14, 2002 2:22 PM To: CF-Talk Subject: Creating Images Question I have a simple request and I'm sure there must be a custom tag (free or not, doesn't matter) to do it. I have some text, for example: Hello World I would like to be able to pass that text into the custom tag and have it create a JPG/GIF file that contains Hello World. Nothing fancy (image size, background color, text color, text font, that's all I need). Any suggestions, Brian -- Brian Simmons [EMAIL PROTECTED] The ultimate CF 5.0 Certification Exam testing tool: Check out CF_Buster at: http://www.centrasoft.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Creating Images Question
Yup...sorry for my stupidity...the lil one kept me up till some ungodly hour this AM. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, June 14, 2002 2:37 PM To: CF-Talk Subject: RE: Creating Images Question Tony, I think he's talking about making a REAL image.. not a name for an image. Like Ming can for PHP developers. ~Todd On Fri, 14 Jun 2002, Tony Carcieri wrote: couldn't you do something like: cfset textToImage = #form.fieldname# cfif IsDefined(textToImage) cfset imagename = #textToImage#.jpg /cfif -Original Message- From: Brian Simmons [mailto:[EMAIL PROTECTED]] Sent: Friday, June 14, 2002 2:22 PM To: CF-Talk Subject: Creating Images Question I have a simple request and I'm sure there must be a custom tag (free or not, doesn't matter) to do it. I have some text, for example: Hello World I would like to be able to pass that text into the custom tag and have it create a JPG/GIF file that contains Hello World. Nothing fancy (image size, background color, text color, text font, that's all I need). Any suggestions, Brian -- Brian Simmons [EMAIL PROTECTED] The ultimate CF 5.0 Certification Exam testing tool: Check out CF_Buster at: http://www.centrasoft.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Database layout advice?
Personally, I always do option 2. I like having very specific and detailed breakdown of what I am doing. It is easier for me to do on a whiteboard and observe the flow and relationship. Just my 2cents -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 11, 2002 2:20 PM To: CF-Talk Subject: OT: Database layout advice? I am creating a database for the sale of autos online. I have mulled over how I should lay this out to function properly and decided to post this to the group for advice. Forgive me if this is a little long. Please keep in mind that I do not like setting anything static if I can help it. The 2 ways I have envisioned this is as follows and any input would help greatly (option 1) I though of placing all inventory into one table and just using the other tables to populate fields. [inventory] This table would hold all the details about the car. IE: make, model, year, vin, options, price etc... etc... [make] list of all makes to dynamically populate fields in application back-end [model] list of all models to dynamically populate fields in application back-end [options] list of all options to dynamically populate fields in application back-end (option 2) I thought of seperating all the colums in the inventory into seperate tables, but I would also have to make seperate tables for the populating of fields in the back-end IE: [details] id vin price [make] id detail_id make [model] id make_id detail_id model [options] id make_id model_id detail_id option1 option2 option3 [makeList] list of all makes to dynamically populate fields in application back-end [modelList] list of all models to dynamically populate fields in application back-end [optionsList] list of all options to dynamically populate fields in application back-end Douglas Brown Email: [EMAIL PROTECTED] __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Database layout advice?
Yup, Andy's right. Just makes your SQL statements easier to code as well, I think. -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 11, 2002 2:21 PM To: CF-Talk Subject: RE: Database layout advice? If you go for option 2 and Normalise the structure some of your fields are redundant - i.e. you do not need detailid in table Model as you can get it through the foreign key makeid to the Make table and then use the detailid foreign key back to the detail table -Original Message- From: Tony Carcieri [mailto:[EMAIL PROTECTED]] Sent: 11 June 2002 19:14 To: CF-Talk Subject: RE: Database layout advice? Personally, I always do option 2. I like having very specific and detailed breakdown of what I am doing. It is easier for me to do on a whiteboard and observe the flow and relationship. Just my 2cents -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 11, 2002 2:20 PM To: CF-Talk Subject: OT: Database layout advice? I am creating a database for the sale of autos online. I have mulled over how I should lay this out to function properly and decided to post this to the group for advice. Forgive me if this is a little long. Please keep in mind that I do not like setting anything static if I can help it. The 2 ways I have envisioned this is as follows and any input would help greatly (option 1) I though of placing all inventory into one table and just using the other tables to populate fields. [inventory] This table would hold all the details about the car. IE: make, model, year, vin, options, price etc... etc... [make] list of all makes to dynamically populate fields in application back-end [model] list of all models to dynamically populate fields in application back-end [options] list of all options to dynamically populate fields in application back-end (option 2) I thought of seperating all the colums in the inventory into seperate tables, but I would also have to make seperate tables for the populating of fields in the back-end IE: [details] id vin price [make] id detail_id make [model] id make_id detail_id model [options] id make_id model_id detail_id option1 option2 option3 [makeList] list of all makes to dynamically populate fields in application back-end [modelList] list of all models to dynamically populate fields in application back-end [optionsList] list of all options to dynamically populate fields in application back-end Douglas Brown Email: [EMAIL PROTECTED] __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
FW: Warning: i-eorder.com
on another list, it was just discovered that the great software deals at i-eorder.com have a few hidden costs, including having your credit card used to purchase websites, and other stuff without your permission. just a note of warning so no one gets suckered by this scam-site. [Tony Carcieri] THanks to: Jolly Green Giant __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Hacking a shared SQL server
Tony is right. If permissions are set properly on SQL, no matter what you put in cf admin, it won't access sql. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 2:09 PM To: CF-Talk Subject: RE: Hacking a shared SQL server you're wrong on this billy. by doing it this way, the only thin a person can execute is the stored procedures that you allow them to. they will not be able to use cfquery to do queries directly against the database. i have been doing this for around a year now, and have been trying to find a hack it for a year now too. I haven't been able to do so yet. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Cravens, Billy [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 2:02 PM To: CF-Talk Subject: RE: Hacking a shared SQL server This has nothing to do with securing the database. It's a matter of how datasources are defined in the CF administrator. Usually, the username and password are defined and saved in the CF administrator, so the code only has to specify the datasource name. No matter how strong you lock down your SQL Server, when you save the username/password in the Administrator, it has the same effect as having no security (if someone can write code on the box and knows the datasource name). --- Billy Cravens -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 12:50 PM To: CF-Talk Subject: RE: Hacking a shared SQL server that's because you didn't secure your database like your suppose to. I'm actually doing a presentation tonight for our CFUG about securing your SQL database. In a nut shell what you should do is create a user for the database (let's say the DB name is TEST) and give them DENYDATAREADER and DENYDATAWRITER access to the database. yes that is correct, it isn't a mistype. Then what you do is with the sa account, create your tables and your stored procedures. you can use another account that has db owner previledges, you just have to make sure that the same user owns both the tables and the storedprocedures. You can use the stored procedure sp_changeobjectowner to change the owner of an object if need be. Then after you created your stored procedures for your database, you give the user only EXEC permissions for that stored procedure. Now even if they get the username and password, what can they access. nothing. they can't even see what tables you have. all they can do is execute the stored procedures that you allow them to. this is a very rough example. if your in the south florida area tonight (don't know where you are), go to the CFUG meeting at the Hillsboro Compusa in Deerfield beach at 7:30pm. I will go into detail about this tonight. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Ken Wilson [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 1:33 PM To: CF-Talk Subject: RE: Hacking a shared SQL server let me know of any coldfusion hacks Hmmm, you acknowledge pulling data from a very desirable table on a site you don't manage and now you want us to send you CF hacks? :) But anyway, does your host not setup username/password on the databases? Ken -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 1:11 PM To: CF-Talk Subject: Hacking a shared SQL server hey guys, i just thought about this, and it's making me feel uneasy about using shared SQL server. ok, i did a test hack on a live server. As you know in SQL Enterprise, you're able to see the database names of other people sharing the SQL server. and by looking at the names you can probably guess what they named their DSN. I got lucky, and nabbed one. I pulled out the table names from sysobjects. Then pulled out the field names from a very desirable table using columnlist, then was able to pull out data! I was appalled! Because my DSNs are named after my site and anyone could have just done with I've done, but with a different intent. But the only way they will get that far is if they know the DSN. And to prevent that would be to never us an obvious DSN. name it something like Hys72hs! I had that fear in my mind way from the beginning, but I had thought that the DSN only works if it is being requested from a certain site!!! and also, can someone tell me how many webHosts turn off the CFREGISTRY tag? Or if any host even have it on at all? I attempted to retrieve the DATAsource names from using that tag, but good thing this host turned it off. Also, please let me know of any coldfusion hacks you guys might know. This is, of course, so you and I can have better security! __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ:
RE: Hacking a shared SQL server
Also if you're the type of person that likes to use integers for primary keys instead of unique identifiers, then I can see you getting at anything in the database from a stored procedure. woah woahcall me dumb here, but by unique identifiers what do you mean? I ALWAYS though integers were the method of choice be cause of access time. please fill me in as ints were the way i was taught and if i should be doing something different, by all means stick my head to a monitor with a railroad spike! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 3:09 PM To: CF-Talk Subject: RE: Hacking a shared SQL server granted that that is true. however doesn't CF or any other programming language do the same thing. and if the way your getting at the data is by using form and url parameter, then it's very easy for me to do from the website and not even bother to try hack the database. using client variables and session variables make this a little harder but not impossible. Also if you're the type of person that likes to use integers for primary keys instead of unique identifiers, then I can see you getting at anything in the database from a stored procedure. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 3:00 PM To: CF-Talk Subject: RE: Hacking a shared SQL server Suppose you stored all your customer information in your database. Your application only used stored procedures to read and write data about these customers. I could just use those stored procedures to read your customer data and steal it. So the fact that I could only execute stored procedures doesn't stop me from accessing your data. -Matt -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 11:52 AM To: CF-Talk Subject: RE: Hacking a shared SQL server elaborate Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 2:47 PM To: CF-Talk Subject: RE: Hacking a shared SQL server If I only have access to run your stored procedures then I could still access you data through the stored procedures. That IS a security problem. -Matt -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 11:39 AM To: CF-Talk Subject: RE: Hacking a shared SQL server well them let me ask you this. if i locked down my database to the point where they can only access the stored procedures that I want them to, then what do I care if they get ahold of the password to the DSN. They would only be able to do anything that I didn't allow them to anyways. I'm NOT trying to start a fight here. I just don't understand why I would care about someone hacking or stealing passwords to a DSN that is totally locked down. Plus I don't get what you mean when you said even being able to call those stored procedures is a serious security issue, as I'm sure you're aware. If I let them have access to something and they run it, then it isn't a security risk. Now if they were able to run something that I didn't give them access to, then we have a problem. However, since I gave them access to run the stored procedures, I don't see a security risk. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 2:25 PM To: CF-Talk Subject: RE: Hacking a shared SQL server you're wrong on this billy. by doing it this way, the only thin a person can execute is the stored procedures that you allow them to. they will not be able to use cfquery to do queries directly against the database. i have been doing this for around a year now, and have been trying to find a hack it for a year now too. I haven't been able to do so yet. Either you're not trying very hard, or you misunderstood Billy's argument. Basically, if you've got a shared CF server, and the usernames and passwords for each individual datasource are stored persistently on that server, then the key to being able to access another database is to retrieve those usernames and passwords. By default, they're usually in the registry. So, if a developer can write code on the server, and that code can read the values from the registry, then they can gain the same level of access to the database that the other application can. Now, admittedly, by properly securing the SQL server you can limit what any CF applications can do (just calling the allowed stored procedures), but even being able to call those stored procedures is a serious security
RE: Hacking a shared SQL server
so how do you prevent that from happening? -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 3:27 PM To: CF-Talk Subject: RE: Hacking a shared SQL server Actually there is nothing wrong with using an integer for a primary key. The trick is to make sure they aren't in sequence, so that people can't guess other keys. -Matt -Original Message- From: Tony Carcieri [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 12:21 PM To: CF-Talk Subject: RE: Hacking a shared SQL server Also if you're the type of person that likes to use integers for primary keys instead of unique identifiers, then I can see you getting at anything in the database from a stored procedure. woah woahcall me dumb here, but by unique identifiers what do you mean? I ALWAYS though integers were the method of choice be cause of access time. please fill me in as ints were the way i was taught and if i should be doing something different, by all means stick my head to a monitor with a railroad spike! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 3:09 PM To: CF-Talk Subject: RE: Hacking a shared SQL server granted that that is true. however doesn't CF or any other programming language do the same thing. and if the way your getting at the data is by using form and url parameter, then it's very easy for me to do from the website and not even bother to try hack the database. using client variables and session variables make this a little harder but not impossible. Also if you're the type of person that likes to use integers for primary keys instead of unique identifiers, then I can see you getting at anything in the database from a stored procedure. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 3:00 PM To: CF-Talk Subject: RE: Hacking a shared SQL server Suppose you stored all your customer information in your database. Your application only used stored procedures to read and write data about these customers. I could just use those stored procedures to read your customer data and steal it. So the fact that I could only execute stored procedures doesn't stop me from accessing your data. -Matt -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 11:52 AM To: CF-Talk Subject: RE: Hacking a shared SQL server elaborate Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Matt Liotta [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 2:47 PM To: CF-Talk Subject: RE: Hacking a shared SQL server If I only have access to run your stored procedures then I could still access you data through the stored procedures. That IS a security problem. -Matt -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 11:39 AM To: CF-Talk Subject: RE: Hacking a shared SQL server well them let me ask you this. if i locked down my database to the point where they can only access the stored procedures that I want them to, then what do I care if they get ahold of the password to the DSN. They would only be able to do anything that I didn't allow them to anyways. I'm NOT trying to start a fight here. I just don't understand why I would care about someone hacking or stealing passwords to a DSN that is totally locked down. Plus I don't get what you mean when you said even being able to call those stored procedures is a serious security issue, as I'm sure you're aware. If I let them have access to something and they run it, then it isn't a security risk. Now if they were able to run something that I didn't give them access to, then we have a problem. However, since I gave them access to run the stored procedures, I don't see a security risk. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 2:25 PM To: CF-Talk Subject: RE: Hacking a shared SQL server you're wrong on this billy. by doing it this way, the only thin a person can execute is the stored procedures that you allow them to. they will not be able to use cfquery to do queries directly against the database. i have been doing this for around a year now, and have been trying to find a hack it for a year now too. I haven't been able to do so yet. Either you're not trying very hard, or you misunderstood Billy's argument. Basically, if you've got a shared CF server
how to increment this
Hi all, I have developed an app that evenly distributes leads based on the next sales rep in the db (we have 2 of them). when the page loads, it queries the db to see who is next in the distribution list. if the number of entries exceeds the recordcount of the reps, it gets set back to 1. my problem is that i am getting unique submissions to the same rep every so often. let's take 10 recs for example: repid 1 2 1 2 1 2 2 1 1 2 there is no pattern to it and I am wondering if i need to lock the the query. here it is: !--- Retrieve Survey ID from new record --- cfquery datasource=mydatasource name=getr maxrows=1 SELECT TOP 1 ID FROM table1 ORDER BY SubmitDate DESC /cfquery cfif getr.Recordcount LT 1 cfset IncID = 1 cfelse cfset ID = Int(getr.ID) cfset IncID = IncrementValue(ID) cfif IncID GT GetReps.Recordcount (just general query here. no biggie.) cfset IncID = 1 /cfif /cfif !--- Create New Array --- cfset EmailArray = ArrayNew(2) !--- Counter --- cfset loopcount = 1 !--- Begin Loop --- cfloop query=GetReps !--- Set elements in array --- cfset EmailArray[loopcount][1] = #GetReps.ID# cfset EmailArray[loopcount][2] = #GetReps.RepFirstName# cfset EmailArray[loopcount][3] = #GetReps.Email# I submit to another page which inserts the info into the db. should i put this code on that page? Thanks, Tony cfset loopcount = loopcount + 1 !--- End Loop --- /cfloop __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Is this possible to do?
Hi gang, Here's my situation. Let's say I have a query that returns...5 records. In my last column I have a header called delete and a column which displays checkboxes. The name is the same but the values are that of the ID in the SQL 2K DB. When I check them I want to deletes them from the DB. My question is this: let's say I check 3 of them, can I do something like: cfquery datasource=mydatasource name=deletethese UPDATE mytable SET IsDeleted = 1 cfloop query=deletethese WHERE ID = '#form.ID#' /cfloop /cfquery If not, how would I go about doing it? Thanks a million! Tony __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Is this possible to do?
That might do it. When I select more than one, the value then becomes 1,2,4,5. By using IN, it should work? Thanks Critz! -Original Message- From: Critz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 04, 2002 11:02 AM To: CF-Talk Subject: Re: Is this possible to do? oi Tony!! where id in (#form.id#) ? that what yer talkin bout? -- Critz Certified Adv. ColdFusion Developer Crit[s2k] - CF_ChannelOP Network=Efnet Channel=ColdFusion Tuesday, June 4, 2002, 10:57:01 AM, you wrote: TC Hi gang, TC Here's my situation. Let's say I have a query that returns...5 records. In TC my last column I have a header called delete and a column which displays TC checkboxes. The name is the same but the values are that of the ID in the TC SQL 2K DB. When I check them I want to deletes them from the DB. My TC question is this: let's say I check 3 of them, can I do something like: TC cfquery datasource=mydatasource name=deletethese TCUPDATE mytable TCSET IsDeleted = 1 TCcfloop query=deletethese TCWHERE ID = '#form.ID#' TC/cfloop TC /cfquery TC If not, how would I go about doing it? TC Thanks a million! TC Tony TC __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Is this possible to do?
But this would also include the form field SUBMIT which, obviously, isn't part of the DB. Right? -Original Message- From: Gyrus [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 04, 2002 11:18 AM To: CF-Talk Subject: Re: Is this possible to do? - Original Message - From: Tony Carcieri [EMAIL PROTECTED] --snip-- cfquery datasource=mydatasource name=deletethese UPDATE mytable SET IsDeleted = 1 cfloop query=deletethese WHERE ID = '#form.ID#' /cfloop /cfquery --- You're submitting a form with one or more checkboxes checked to delete, yeah? Try using the 'form.fieldnames' value and the SQL 'IN' operator. Form.fieldnames should contain a list of all form fields defined in the submission. Checkboxes that aren't checked aren't even defined, so... cfquery datasource=mydatasource name=deletethese UPDATE mytable SET IsDeleted = 1 WHERE ID IN (#form.fieldnames#) /cfquery HTH, - Gyrus - [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net - PGP key available __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Re[2]: Is this possible to do?
Critz and Gyrus, I think I need more caffeine. I STUPIDLY forgot to do: WHERE ID IN (#form.ID#). Yup, those damn parens do it all the time. ARGH! *gets up, smashes head on monitor, and stomps off to get more coffee* Thanks, T -Original Message- From: Critz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 04, 2002 11:58 AM To: CF-Talk Subject: Re[2]: Is this possible to do? oi Tony!! si Tony is correct. all you would need would be the one fieldname, since if there are more than one, their values are passed thru in a list. And even if there is only one. the [IN(#form.id#)] will still work -- Critz Certified Adv. ColdFusion Developer Crit[s2k] - CF_ChannelOP Network=Efnet Channel=ColdFusion Tuesday, June 4, 2002, 11:28:40 AM, you wrote: TC But this would also include the form field SUBMIT which, obviously, isn't TC part of the DB. Right? TC -Original Message- TC From: Gyrus [mailto:[EMAIL PROTECTED]] TC Sent: Tuesday, June 04, 2002 11:18 AM TC To: CF-Talk TC Subject: Re: Is this possible to do? TC - Original Message - TC From: Tony Carcieri [EMAIL PROTECTED] TC --snip-- TC cfquery datasource=mydatasource name=deletethese TCUPDATE mytable TCSET IsDeleted = 1 TCcfloop query=deletethese TCWHERE ID = '#form.ID#' TC/cfloop TC /cfquery TC --- TC You're submitting a form with one or more checkboxes checked to delete, TC yeah? TC Try using the 'form.fieldnames' value and the SQL 'IN' operator. TC Form.fieldnames should contain a list of all form fields defined in the TC submission. Checkboxes that aren't checked aren't even defined, so... TC cfquery datasource=mydatasource name=deletethese TC UPDATE mytable TC SET IsDeleted = 1 TC WHERE ID IN (#form.fieldnames#) TC /cfquery TC HTH, TC - Gyrus TC TC - [EMAIL PROTECTED] TC work: http://www.tengai.co.uk TC play: http://www.norlonto.net TC - PGP key available TC TC __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Re[2]: Is this possible to do?
Chad, No. I am not treating the values as a string. -Original Message- From: chad [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 04, 2002 1:30 PM To: CF-Talk Subject: RE: Re[2]: Is this possible to do? Isnt this because you need single quotes around your list items? At 01:15 PM 6/4/2002 -0400, you wrote: just to throw a tidbit out there. Remember that if you use MSSQL server you cannot use IN inside a stored procedure that you are passign the list in. such that Store Procedure === CREATE PROCEDURE ProcessList @myList varchar(255) As SELECT * FROM MyTable WHERE myColumn IN (@myList) cfset variables.mylist = me, myself, and i cfstoredproc procedure=ProcessList datasource=#request.dsn# username=#request.username# password=#request.password# cfprocparam type=In cfsqltype=CF_SQL_VARCHAR dbvarname=@mylist value=#variables.mylist# maxlength=255 null=No cfprocresult name=ProcessList /cfstoredproc This would fail. There are somework arounds. Use can use dynamic sql: EXEC 'SELECT * FROM MyTable WHERE myColumn IN (' + @myList + ')' this stinks because you have to give the user access to the table and not just stored procedure access, so this is a little bit of a security risk in your application. OR if you are using SQL Server 2000 you can write list functions. http://www.xcreation.com/downloads/ListGetAt.sql Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Tony Carcieri [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 04, 2002 12:52 PM To: CF-Talk Subject: RE: Re[2]: Is this possible to do? Critz and Gyrus, I think I need more caffeine. I STUPIDLY forgot to do: WHERE ID IN (#form.ID#). Yup, those damn parens do it all the time. ARGH! *gets up, smashes head on monitor, and stomps off to get more coffee* Thanks, T -Original Message- From: Critz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 04, 2002 11:58 AM To: CF-Talk Subject: Re[2]: Is this possible to do? oi Tony!! si Tony is correct. all you would need would be the one fieldname, since if there are more than one, their values are passed thru in a list. And even if there is only one. the [IN(#form.id#)] will still work -- Critz Certified Adv. ColdFusion Developer Crit[s2k] - CF_ChannelOP Network=Efnet Channel=ColdFusion Tuesday, June 4, 2002, 11:28:40 AM, you wrote: TC But this would also include the form field SUBMIT which, obviously, isn't TC part of the DB. Right? TC -Original Message- TC From: Gyrus [mailto:[EMAIL PROTECTED]] TC Sent: Tuesday, June 04, 2002 11:18 AM TC To: CF-Talk TC Subject: Re: Is this possible to do? TC - Original Message - TC From: Tony Carcieri [EMAIL PROTECTED] TC --snip-- TC cfquery datasource=mydatasource name=deletethese TCUPDATE mytable TCSET IsDeleted = 1 TCcfloop query=deletethese TCWHERE ID = '#form.ID#' TC/cfloop TC /cfquery TC --- TC You're submitting a form with one or more checkboxes checked to delete, TC yeah? TC Try using the 'form.fieldnames' value and the SQL 'IN' operator. TC Form.fieldnames should contain a list of all form fields defined in the TC submission. Checkboxes that aren't checked aren't even defined, so... TC cfquery datasource=mydatasource name=deletethese TC UPDATE mytable TC SET IsDeleted = 1 TC WHERE ID IN (#form.fieldnames#) TC /cfquery TC HTH, TC - Gyrus TC TC - [EMAIL PROTECTED] TC work: http://www.tengai.co.uk TC play: http://www.norlonto.net TC - PGP key available TC TC __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: datetime formatting
If you are using Access you could specify NOW() in the format section other wise I would do this: cfset SubmitDate = CreateODBCDateTime(Now()) and then insert it into your DB -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 2:33 PM To: CF-Talk Subject: datetime formatting I need to insert the current date and time into a table whenever a record is created. How would I format the current date and time in the following format using ASP? -MM-DD HH:MM:SS I'm not sure of the proper function in ASP to accomplish this task. Thanks, Dave __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: datetime formatting
Tony, Doesn't getDate() consistently return the same date/time no matter how many recs are inserted? I found that in SQL. If I used getdate() and I inserted 10 records, each had the same date/time even though I submitted them at different intervals. Just need a clarification on this. Thanks, Tony -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 2:45 PM To: CF-Talk Subject: RE: datetime formatting I'm using mySQL with a datetime field. Thanks, Dave Bosky -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 2:39 PM To: CF-Talk Subject: RE: datetime formatting forget ASP! do it right from the database with a default on the column. in access use now() in the default field and in MSSQL, use getdate(). Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 2:33 PM To: CF-Talk Subject: datetime formatting I need to insert the current date and time into a table whenever a record is created. How would I format the current date and time in the following format using ASP? -MM-DD HH:MM:SS I'm not sure of the proper function in ASP to accomplish this task. Thanks, Dave __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: datetime formatting
Just a note Dave, VBScript only lets you use US English date format (ie mm/dd/) even if your locale settings are different. I also believe you need ## signs around the date. Thanks, Tony -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 2:45 PM To: CF-Talk Subject: RE: datetime formatting I'm using mySQL with a datetime field. Thanks, Dave Bosky -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 2:39 PM To: CF-Talk Subject: RE: datetime formatting forget ASP! do it right from the database with a default on the column. in access use now() in the default field and in MSSQL, use getdate(). Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 2:33 PM To: CF-Talk Subject: datetime formatting I need to insert the current date and time into a table whenever a record is created. How would I format the current date and time in the following format using ASP? -MM-DD HH:MM:SS I'm not sure of the proper function in ASP to accomplish this task. Thanks, Dave __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: datetime formatting
thanks for the clarification. Thanks, Tony -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 3:10 PM To: CF-Talk Subject: RE: datetime formatting might be inserting the value yourself from a storedprocedure then. The default will only be used when the user hasn't specified a value. example: you are insert the datetime yourself DECLARE @mytime datetime, @title varchar(50) SET @mytime = getdate() SET @title = 'this is a test' INSERT INTO table1 (CreationDate, title) VALUES (@mytime, @title) SQL Server does it for you DECLARE @title varchar(50) SET @title = 'this is a test' INSERT INTO table1 (title) VALUES (@title) What you probably are doing is assigning the getdate() to a local variables. and then doing an insert using this variables. If this is what are you doing then you are correct. SQL Server will insert the exact time for all records in the insert. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Tony Carcieri [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 2:50 PM To: CF-Talk Subject: RE: datetime formatting Tony, Doesn't getDate() consistently return the same date/time no matter how many recs are inserted? I found that in SQL. If I used getdate() and I inserted 10 records, each had the same date/time even though I submitted them at different intervals. Just need a clarification on this. Thanks, Tony -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 2:45 PM To: CF-Talk Subject: RE: datetime formatting I'm using mySQL with a datetime field. Thanks, Dave Bosky -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 2:39 PM To: CF-Talk Subject: RE: datetime formatting forget ASP! do it right from the database with a default on the column. in access use now() in the default field and in MSSQL, use getdate(). Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 2:33 PM To: CF-Talk Subject: datetime formatting I need to insert the current date and time into a table whenever a record is created. How would I format the current date and time in the following format using ASP? -MM-DD HH:MM:SS I'm not sure of the proper function in ASP to accomplish this task. Thanks, Dave __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Preventing user from going back
!--- Client side cache prevention --- meta http-equiv=Expires content=0 !--- Setup our expire times for Netscape and Internet Explorer --- cfoutput !--- Internet Explorer Date Formate: (Fri, 30 Oct 1998 14:19:41 GMT) --- cfset MSIEtimestamp='#dateformat(now(),DDD)#,#dateformat(now(),DD)# #dateformat(now(),Mmm)# #timeformat(now(),HH:MM:SS)#' !--- Netscape Date Formate: Netscape (Wednesday, Apr 26 2000 17:45:25 PM) --- cfset NETSCAPEtimestamp='#dateformat(now(),)#,#dateformat(now(),MMM)# #dateformat(now(),dd)# #dateformat(now(),YYY)# #timeformat(now(),HH:MM:SS tt)#' /cfoutput !--- Tell HTTP Header to force expire of page - nocache --- cfif HTTP_USER_AGENT contains MSIE cfheader name=Expires value=cfoutput#MSIEtimestamp#/cfoutput cfheader name=Pragma value=no-cache cfheader name=cache-control value=no-cache, no-store, must-revalidate cfelse cfheader name=Expires value=cfoutput#NETSCAPEtimestamp#/cfoutput cfheader name=Pragma value=no-cache cfheader name=cache-control value=no-cache, no-store, must-revalidate /cfif -Original Message- From: Mark Smeets [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 30, 2002 1:19 PM To: CF-Talk Subject: Preventing user from going back Hey all, Does anyone have an easy way to prevent the user from going back to the previous page? -- Mark Smeets / stranger0 / ICQ: 1062196 [EMAIL PROTECTED] http://www.prowerks.com/stranger Life is a series of small victories - Gene Simmons FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
new member w/ what should be easy to do but can't figure out.
Hi all, I am a new member to this list and was wondering if I could ask for some help. Here is what i need to do: I have a survey that is on the web (duh) and when someone fills it out, i want to insert into an access 2k db (no prob here) and then evenly distribute (ie email) to sales reps. so, for the first survey filled out, it goes to rep 1, second survey goes to rep 2, so on and so forth and when the amount of surveys exceed the reps, then i go back to the first rep. i will send code if someone knows how to do this. Thanks a million! Big T __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists