RE: [KCFusion] same field names
I would just use an alias when calling the field name using the AS keyword. Misty -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Adaryl WakefieldSent: Tuesday, January 28, 2003 4:01 PMTo: [EMAIL PROTECTED]Subject: [KCFusion] same field names It does not happen too often but every blue moon or so I have a field that is named the same in two related tables. Usually I just rename a field and go about my day. Nobody but me here really knows what I'm up to anyway. Today I was making some tables and wound up with this: parentTable.state childTable.state In the parent table the state is stored in full. In the child table the state is stored as the two letter abbreviation for addresses. The problem that I usually go right around is the fact that to reference a result in a query you say: queryName.state but you can't specify which state you want. I preparation for the day when I may have to answer to someone and can't just rename a field, I was wondering if there was a way to actually reference a field in cfoutput query that I was not privy to. A.
Re: [KCFusion] error var
Im fairly certain the error.template is correct but for some reason its just not catching it. It may be the scope that you are calling it for is just not available for the variable. Misty -- Original Message -- From: "Adaryl Wakefield" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Tue, 26 Nov 2002 15:01:18 -0600 >No I get an error. Here is the output of the email: > >An error has occurred. >Date and Time of Error: 11/26/02 14:31:43 >IP Address of Client: 129.130.205.159 >Query String Parameters were: >Template that caused error: >Client Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; YComp >5.0.0.0; .NET CLR 1.0.3705) >Error Diagnostics: Just in time compilation error Invalid parser construct >found on line 15 at position 23. ColdFusion was looking at the following >text: >" >Invalid expression format. The usual cause is an error in the expression >structure. >The last successfully parsed CFML construct was static text occupying >document position (12:61) to (15:15). > >The specific sequence of files included or processed is: >C:\Inetpub\wwwroot\\\doGoEmail.cfm > >I can pretty much glean what went wrong where from the last line but it >still kinda bothers me that that variable does not appear to be right. You >can see up where it says "Template that caused error" is empty. > >A. > > >- Original Message - >From: "Misty Woodward" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Tuesday, November 26, 2002 2:59 PM >Subject: Re: [KCFusion] error var > > >> Are you getting an error of some sort? Or is it just not sending? >> >> -- Original Message -- >> From: "Adaryl Wakefield" <[EMAIL PROTECTED]> >> Reply-To: [EMAIL PROTECTED] >> Date: Tue, 26 Nov 2002 14:40:32 -0600 >> >> >I set it up so I get an email when ever one of my apps tosses an error. >Except it seems that #error.template# is not working. I got that variable >from a WROX professional book . Before I go digging around the discussion >boards anybody know off the top of their head what the right variable is >supposed to be? Im using CF 5. >> >A. >> > >> > >> > >> >> >> __ >> The KCFusion.org list and website is hosted by Humankind Systems, Inc. >> List Archives http://www.mail-archive.com/cf-list@kcfusion.org >> Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] >> To Subscribe mailto:[EMAIL PROTECTED] >> To Unsubscribe mailto:[EMAIL PROTECTED] >> > > > >__ >The KCFusion.org list and website is hosted by Humankind Systems, Inc. >List Archives http://www.mail-archive.com/cf-list@kcfusion.org >Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] >To Subscribe mailto:[EMAIL PROTECTED] >To Unsubscribe mailto:[EMAIL PROTECTED] > > __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
Re: [KCFusion] error var
Are you getting an error of some sort? Or is it just not sending? -- Original Message -- From: "Adaryl Wakefield" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Tue, 26 Nov 2002 14:40:32 -0600 >I set it up so I get an email when ever one of my apps tosses an error. Except it >seems that #error.template# is not working. I got that variable from a WROX >professional book . Before I go digging around the discussion boards anybody know off >the top of their head what the right variable is supposed to be? Im using CF 5. >A. > > > __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] Impossible Candidate
In all seriousness, for those of you who might have done something similar to this (hiring I mean) are we talking unrealistic expectations from employers or are we talking recruiters who don't know the different between java and javascript and between VB and VBScript and CF from ASP, etc. is it just an educational thing? If anyone actually did research on these positions to get them filled surely they must know it is almost unattainable. Either unatainable or when they find someone they won't pay em the gold they are worth. -- Original Message -- From: "Matt Jones" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Thu, 3 Oct 2002 13:41:01 -0500 >They could have the candidates interview themselves to determine if they >are qualified and skilled in those areas. Then the HR department merely >has to take those candidates that deem themselves qualified and skilled, >and determine who is the most honest out of the group, and hire that >person. > >-Original Message- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] >Sent: Thursday, October 03, 2002 1:36 PM >To: [EMAIL PROTECTED] >Subject: RE: [KCFusion] Impossible Candidate > >Who would be qualified to interview this candidate and determine that >they >are truly skilled in all of those areas? > >-Original Message- >From: Keith Purtell [mailto:[EMAIL PROTECTED]] >Sent: Thursday, October 03, 2002 1:29 PM >To: [EMAIL PROTECTED] >Subject: RE: [KCFusion] Impossible Candidate > > >In addition to the wildly unrealistic nature of their wish list, there's >another problem. No human >being in existence could pack all those activities into a normal work >day. >Someone in their HR >department is smoking banana peelings. > >Keith Purtell, Web/Network Administrator >VantageMed Operations (Kansas City) >Email: [EMAIL PROTECTED] > > >CONFIDENTIALITY NOTICE: This email message, including any attachments, >is >for the sole use of the >intended recipient(s) and may contain confidential and privileged >information. Any unauthorized >review, use, disclosure or distribution is prohibited. If you are not >the >intended recipient, please >contact the sender by reply email and destroy all copies of the original >message. > > >-Original Message- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On >Behalf Of Misty Woodward >Sent: Thursday, October 03, 2002 1:21 PM >To: [EMAIL PROTECTED] >Subject: [KCFusion] Impossible Candidate > > >I know last week we had the discussion about how employers were wanting >candidates with CF >experience plus maybe some C or VB. Even the skills required in that >post I >was quite surprised. >UNTIL > >(Landed in my inbox today) >The candidate should have all these skills: > >1. Computer Science undergraduate degree is big plus >2. Minimum of 5 years of web development experience >3. ColdFusion >4. Java >a. Classes, Servlets >b. JMS >c. JBOSS, WebLogic, TogetherJ >d. Javascripting >5. Oracle 8i and/or 9i >a. DBA >b. PL/SQL >6. XML/DTD - Using, parsing, developing in CF and Java >7. BizTalk with IWay or any similar tools / ETL tools knowledge is a >plus >8. Extremely good understanding of development cycles and needs in each >cycle >a. Development, Test, Q/A, Product >b. Unit testing >c. Scripted deployment / deployment scripting (nightly builds, etc.) >d. Bug tracking >e. Documentation >9. Visual Basic >10. Very comfortable with CF Studio, MS Visial Studio 6.x (esp. VB), >CVS,MS VSS, Rapid SQL, Adobe Web Development tools, Macromedia Web >Development >tools >11. Windows 2000 O/S knowledge >12. Unix/Linux O/S knowledge is a plus >13. Very good in tranlating business requirements into programming >14. Extremely good team player >15. EDI knowledge is a plus >16. ASP and VB scripting is a plus >17. DHTML knowledge >18. Very comfortable in O/S, application, etc. software installation >19. Very comfortable in TCP/IP Networking, esp. VPN > >How much you wanna bet they only wanna pay about $50k for this >super-geek >lol > >Misty > > > > >--- >[This E-mail scanned for viruses by Declude Virus] > > > >__ >The KCFusion.org list and website is hosted by Humankind Systems, Inc. >List Archives http://www.mail-archive.com/cf-list@kcfusion.org >Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] >To Subscribe mailto:[EMAIL PROTECTED] >To Unsubscribe mailto:[EMAIL PROTECTED] > > > >* >This emai
RE: [KCFusion] Impossible Candidate
HAHA That is exactly what I was thinking! -- Original Message -- From: "Matt Jones" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Thu, 3 Oct 2002 13:41:01 -0500 >They could have the candidates interview themselves to determine if they >are qualified and skilled in those areas. Then the HR department merely >has to take those candidates that deem themselves qualified and skilled, >and determine who is the most honest out of the group, and hire that >person. > >-Original Message- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] >Sent: Thursday, October 03, 2002 1:36 PM >To: [EMAIL PROTECTED] >Subject: RE: [KCFusion] Impossible Candidate > >Who would be qualified to interview this candidate and determine that >they >are truly skilled in all of those areas? > >-Original Message- >From: Keith Purtell [mailto:[EMAIL PROTECTED]] >Sent: Thursday, October 03, 2002 1:29 PM >To: [EMAIL PROTECTED] >Subject: RE: [KCFusion] Impossible Candidate > > >In addition to the wildly unrealistic nature of their wish list, there's >another problem. No human >being in existence could pack all those activities into a normal work >day. >Someone in their HR >department is smoking banana peelings. > >Keith Purtell, Web/Network Administrator >VantageMed Operations (Kansas City) >Email: [EMAIL PROTECTED] > > >CONFIDENTIALITY NOTICE: This email message, including any attachments, >is >for the sole use of the >intended recipient(s) and may contain confidential and privileged >information. Any unauthorized >review, use, disclosure or distribution is prohibited. If you are not >the >intended recipient, please >contact the sender by reply email and destroy all copies of the original >message. > > >-Original Message- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On >Behalf Of Misty Woodward >Sent: Thursday, October 03, 2002 1:21 PM >To: [EMAIL PROTECTED] >Subject: [KCFusion] Impossible Candidate > > >I know last week we had the discussion about how employers were wanting >candidates with CF >experience plus maybe some C or VB. Even the skills required in that >post I >was quite surprised. >UNTIL > >(Landed in my inbox today) >The candidate should have all these skills: > >1. Computer Science undergraduate degree is big plus >2. Minimum of 5 years of web development experience >3. ColdFusion >4. Java >a. Classes, Servlets >b. JMS >c. JBOSS, WebLogic, TogetherJ >d. Javascripting >5. Oracle 8i and/or 9i >a. DBA >b. PL/SQL >6. XML/DTD - Using, parsing, developing in CF and Java >7. BizTalk with IWay or any similar tools / ETL tools knowledge is a >plus >8. Extremely good understanding of development cycles and needs in each >cycle >a. Development, Test, Q/A, Product >b. Unit testing >c. Scripted deployment / deployment scripting (nightly builds, etc.) >d. Bug tracking >e. Documentation >9. Visual Basic >10. Very comfortable with CF Studio, MS Visial Studio 6.x (esp. VB), >CVS,MS VSS, Rapid SQL, Adobe Web Development tools, Macromedia Web >Development >tools >11. Windows 2000 O/S knowledge >12. Unix/Linux O/S knowledge is a plus >13. Very good in tranlating business requirements into programming >14. Extremely good team player >15. EDI knowledge is a plus >16. ASP and VB scripting is a plus >17. DHTML knowledge >18. Very comfortable in O/S, application, etc. software installation >19. Very comfortable in TCP/IP Networking, esp. VPN > >How much you wanna bet they only wanna pay about $50k for this >super-geek >lol > >Misty > > > > >--- >[This E-mail scanned for viruses by Declude Virus] > > > >__ >The KCFusion.org list and website is hosted by Humankind Systems, Inc. >List Archives http://www.mail-archive.com/cf-list@kcfusion.org >Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] >To Subscribe mailto:[EMAIL PROTECTED] >To Unsubscribe mailto:[EMAIL PROTECTED] > > > >* >This email and any files transmitted with it are confidential >and intended solely for the use of the individual or entity >to whom they are addressed. If you have received this email >in error please notify [EMAIL PROTECTED] >* > > > >__ >The KCFusion.org list and website is hosted by Humankind Systems, Inc. >List Archives http://www.ma
RE: [KCFusion] Impossible Candidate
Thats what went through my head. What they seem to be needing is a CF programmer, a java programmer, a DBA, QA Specialist and a technical writer. Lets see, CF-80k, Java-80k, DBA-80k, QA-60k, Writer-50k. Hot damn I could be making $350k if I was that smart. LOL -- Original Message -- From: "Keith Purtell" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Thu, 3 Oct 2002 13:28:46 -0500 >In addition to the wildly unrealistic nature of their wish list, there's another >problem. No human >being in existence could pack all those activities into a normal work day. Someone in >their HR >department is smoking banana peelings. > >Keith Purtell, Web/Network Administrator >VantageMed Operations (Kansas City) >Email: [EMAIL PROTECTED] > > >CONFIDENTIALITY NOTICE: This email message, including any attachments, is for the >sole use of the >intended recipient(s) and may contain confidential and privileged information. Any >unauthorized >review, use, disclosure or distribution is prohibited. If you are not the intended >recipient, please >contact the sender by reply email and destroy all copies of the original message. > > >-Original Message- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On >Behalf Of Misty Woodward >Sent: Thursday, October 03, 2002 1:21 PM >To: [EMAIL PROTECTED] >Subject: [KCFusion] Impossible Candidate > > >I know last week we had the discussion about how employers were wanting candidates >with CF >experience plus maybe some C or VB. Even the skills required in that post I was quite >surprised. >UNTIL > >(Landed in my inbox today) >The candidate should have all these skills: > >1. Computer Science undergraduate degree is big plus >2. Minimum of 5 years of web development experience >3. ColdFusion >4. Java >a. Classes, Servlets >b. JMS >c. JBOSS, WebLogic, TogetherJ >d. Javascripting >5. Oracle 8i and/or 9i >a. DBA >b. PL/SQL >6. XML/DTD - Using, parsing, developing in CF and Java >7. BizTalk with IWay or any similar tools / ETL tools knowledge is a >plus >8. Extremely good understanding of development cycles and needs in each >cycle >a. Development, Test, Q/A, Product >b. Unit testing >c. Scripted deployment / deployment scripting (nightly builds, etc.) >d. Bug tracking >e. Documentation >9. Visual Basic >10. Very comfortable with CF Studio, MS Visial Studio 6.x (esp. VB), >CVS,MS VSS, Rapid SQL, Adobe Web Development tools, Macromedia Web >Development >tools >11. Windows 2000 O/S knowledge >12. Unix/Linux O/S knowledge is a plus >13. Very good in tranlating business requirements into programming >14. Extremely good team player >15. EDI knowledge is a plus >16. ASP and VB scripting is a plus >17. DHTML knowledge >18. Very comfortable in O/S, application, etc. software installation >19. Very comfortable in TCP/IP Networking, esp. VPN > >How much you wanna bet they only wanna pay about $50k for this super-geek lol > >Misty > > > > >--- >[This E-mail scanned for viruses by Declude Virus] > > > >__ >The KCFusion.org list and website is hosted by Humankind Systems, Inc. >List Archives http://www.mail-archive.com/cf-list@kcfusion.org >Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] >To Subscribe mailto:[EMAIL PROTECTED] >To Unsubscribe mailto:[EMAIL PROTECTED] > > __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
[KCFusion] Impossible Candidate
I know last week we had the discussion about how employers were wanting candidates with CF experience plus maybe some C or VB. Even the skills required in that post I was quite surprised. UNTIL (Landed in my inbox today) The candidate should have all these skills: 1. Computer Science undergraduate degree is big plus 2. Minimum of 5 years of web development experience 3. ColdFusion 4. Java a. Classes, Servlets b. JMS c. JBOSS, WebLogic, TogetherJ d. Javascripting 5. Oracle 8i and/or 9i a. DBA b. PL/SQL 6. XML/DTD - Using, parsing, developing in CF and Java 7. BizTalk with IWay or any similar tools / ETL tools knowledge is a plus 8. Extremely good understanding of development cycles and needs in each cycle a. Development, Test, Q/A, Product b. Unit testing c. Scripted deployment / deployment scripting (nightly builds, etc.) d. Bug tracking e. Documentation 9. Visual Basic 10. Very comfortable with CF Studio, MS Visial Studio 6.x (esp. VB), CVS,MS VSS, Rapid SQL, Adobe Web Development tools, Macromedia Web Development tools 11. Windows 2000 O/S knowledge 12. Unix/Linux O/S knowledge is a plus 13. Very good in tranlating business requirements into programming 14. Extremely good team player 15. EDI knowledge is a plus 16. ASP and VB scripting is a plus 17. DHTML knowledge 18. Very comfortable in O/S, application, etc. software installation 19. Very comfortable in TCP/IP Networking, esp. VPN How much you wanna bet they only wanna pay about $50k for this super-geek lol Misty __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] Need ColdFusion webhosting provider
Try Crystaltech.com. For 19.95 you get ODBC datasources as needed and CF. Misty -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Eric Lehti Sent: Monday, September 23, 2002 5:04 PM To: '[EMAIL PROTECTED]' Subject: [KCFusion] Need ColdFusion webhosting provider Hi y'all, I would appreciate knowing of a low-cost (perhaps $20 a month) ColdFusion webhosting provider. I want to publish some test CF websites. Eric Lehti 913.341.3434 ext. 433100 mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] MM Meeting is CANCELLED! - possible reschedule
Just now figuring that out huh? haha you guys crack me up. Misty -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Keith Purtell Sent: Monday, September 23, 2002 4:16 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] MM Meeting is CANCELLED! - possible reschedule Hey I'm starting to suspect some of you guys are nerds. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Ryan Hartwich Sent: Monday, September 23, 2002 4:05 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] MM Meeting is CANCELLED! - possible reschedule -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Justin Hansen Sent: Monday, September 23, 2002 4:00 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] MM Meeting is CANCELLED! - possible reschedule Error: Please check the number and try again. Just trying to lighten' your day ;) __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
Re: [KCFusion] changes between cold fusion server 4.5 and 5.0
I tried to look this up on Macromedia but I couldnt find any pricing on 5.0 on their site anymore but I did find version 5.0 on available on another web site for 4,975.55 and on Macromedia.com they have MX at $4999 so its really more expensive for MX. Plus if they are moving from 4.5 to 5.0 they are probably either getting a free copy through their subscription or paying the upgrade price which is even cheaper. Misty -- Original Message -- From: "Adaryl Wakefield" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Wed, 18 Sep 2002 12:30:46 -0500 >Well that does not make much sense. I could have sworn MX was cheaper, no? >A. >- Original Message - >From: "Johnson, Michael" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Wednesday, September 18, 2002 12:22 PM >Subject: RE: [KCFusion] changes between cold fusion server 4.5 and 5.0 > > >> funding i guess... i'm a gov't contractor. >> >> -Original Message- >> From: Adaryl Wakefield [mailto:[EMAIL PROTECTED]] >> Sent: Wednesday, September 18, 2002 1:25 PM >> To: [EMAIL PROTECTED] >> Subject: Re: [KCFusion] changes between cold fusion server 4.5 and 5.0 >> >> >> Out of curiosity why did you go to 5.0 insted of MX? >> A. >> - Original Message - >> From: "Johnson, Michael" <[EMAIL PROTECTED]> >> To: "CF-List (E-mail)" <[EMAIL PROTECTED]> >> Sent: Wednesday, September 18, 2002 12:09 PM >> Subject: [KCFusion] changes between cold fusion server 4.5 and 5.0 >> >> >> > can anyone tell me of any know problems found when upgrading from cold >> > fusion server 4.5 to 5.0? we've currently upgrade from 4.5 to 5.0. i >> > have'nt seen any thing as of yet. but i need to test the application >> running >> > under the newer server upgrade. >> > >> > or does anyone know of a "white paper" on the issues of upgrading from >> cold >> > fusion server 4.5 to 5.0? >> > >> > >> > thanx. >> > >> > Mike Johnson >> > Science Application International Corporation >> > (757) 870-9165 >> > Emai: [EMAIL PROTECTED] >> > >> > >> > >> > >> > __ >> > The KCFusion.org list and website is hosted by Humankind Systems, Inc. >> > List Archives http://www.mail-archive.com/cf-list@kcfusion.org >> > Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] >> > To Subscribe mailto:[EMAIL PROTECTED] >> > To Unsubscribe mailto:[EMAIL PROTECTED] >> > >> >> >> >> __ >> The KCFusion.org list and website is hosted by Humankind Systems, Inc. >> List Archives http://www.mail-archive.com/cf-list@kcfusion.org >> Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] >> To Subscribe mailto:[EMAIL PROTECTED] >> To Unsubscribe mailto:[EMAIL PROTECTED] >> >> >> >> __ >> The KCFusion.org list and website is hosted by Humankind Systems, Inc. >> List Archives http://www.mail-archive.com/cf-list@kcfusion.org >> Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] >> To Subscribe mailto:[EMAIL PROTECTED] >> To Unsubscribe mailto:[EMAIL PROTECTED] >> > > > >__ >The KCFusion.org list and website is hosted by Humankind Systems, Inc. >List Archives http://www.mail-archive.com/cf-list@kcfusion.org >Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] >To Subscribe mailto:[EMAIL PROTECTED] >To Unsubscribe mailto:[EMAIL PROTECTED] > > __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
Re: [KCFusion] deletes on database?
Well I know some that use stored procedures for everything. For me, I try to use them only when things get complex. For instance, Im writing an application that goes into the database checks who a shipper is based on a mailstop, based on that it does another query, takes the result of that query and goes into another database pulls out the next tracking number then calls another Oracle function within it. So you can see the more jumping around i have do, the more it makes sense to do it on the Oracle box instead. The other reason regardless of what makes sense, is some companies force you to put everything into stored procedures or functions no matter what. There are a lot of companies now moving to not letting CF programmers write SQL statements and instead having database guys do it because they are more efficient in writing SQL (ya I dont buy that either) but it is thought to be better. Make the database better by letting the people who specialize in it write the queries. This makes sense I suppose but its a big increaser of development time. Ive literally sat here twiddling my thumbs for hours waiting on my DB guy to come back and load my oracle function for me to test it. it sucks. But thats company processes at work! :) Misty -- Original Message -- From: "Adaryl Wakefield" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Thu, 12 Sep 2002 12:58:32 -0500 >Hey why is it every time I post something it generates an avalanche of >activity. :-) Its like you guys forget this thing exist. >So (and anybody can field this one) I was studying how to write stored >procedures in SQL Server last night I was like..gee. thats a lot of freaking >work. So what would you say was the most appropriate time to use stored >procedures vs. just putting it on the page. >A. >P.S. As a matter of fact Misty, no, I don't have a jobI'm a consultant! > >- Original Message - >From: "Misty Woodward" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Thursday, September 12, 2002 10:59 AM >Subject: RE: [KCFusion] deletes on database? > > >> In one of the projects I am working on now, they use Oracle stored >functions only for database calls. When I first started doing it, I hated >it. Honestly, I still hate it. From a development standpoint, as far as time >goes, i would say it takes longer than just writing it directly into CF. >When Im coding in CF I just write out my CF query and move on. When writing >Stored Functions your 8 line query turns into a huge function where you have >to declare varaibles, check for variabls, create the function, create your >IN Variables, write in your return values, etc. The part that Stored >Functions shine in, is with code re-use. The function I wrote is to be used >across 3 systems. Which means, I only have to change it in one place and I >can manage all 3 sites with it. >> >> Misty >> >> -- Original Message -- >> From: "Glenn Crocker" <[EMAIL PROTECTED]> >> Reply-To: [EMAIL PROTECTED] >> Date: Thu, 12 Sep 2002 10:50:12 -0500 >> >> >MessageI generally don't do any JOINs in my CF code, instead using >> >queries/views to accomplish them. (Sometimes, when a parameter needs to >be >> >way inside a JOIN, I'll put one in CF.) I haven't done the full-on >stored >> >procedure architecture, but most of my projects are just one or two >> >developers, so it's not a big team thing with lots of turnover. >> > >> >-glenn >> > >> > -Original Message- >> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On >> >Behalf Of Ryan Hartwich >> > Sent: Wednesday, September 11, 2002 10:28 PM >> > To: [EMAIL PROTECTED] >> > Subject: RE: [KCFusion] deletes on database? >> > >> > >> > Adaryl, >> > >> > Somewhere I interviewed or spoke with someone about this topic. It was >my >> >understanding that the individual coders being employed were generally >not >> >allowed to do any form of insert/update/delete into the database through >> >their code. They were however permitted to write Select statements to >> >tables and/or views. The coders were given a set of API calls utilizing >> >XML services internally to do the direct DB manipulation. The idea was >to >> >force data integrity and consistency by only allowing data to be modified >> >through approved prebuilt modules. >> > >> > A permutation of this would be to not permit inline DB calls in your CF >> >code and to call all DB statements via stored pro
RE: [KCFusion] Changing the subject
Ok way to many emails asking why I didnt take it, so let me just say this once. The pay was not great. Even Sprint's bill rate is higher than this and we all know what they have done to their bill rate lately. Misty -- Original Message -- From: "Justin Hansen" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Thu, 12 Sep 2002 12:12:32 -0500 >I heard about that job a few months ago guess they are still looking. Too bad I >like this job so much. My top secret project rocks! Can't tell you more than that or >I would have to kill ya. Time for lunch. > >btw... Yes, we are all freaking genious's! ;) > >Justin Hansen >-- >Uhlig Communications >Systems Engineer >-- >[EMAIL PROTECTED] >913-754-4273 >-- > >-Original Message- >From: Misty Woodward [mailto:[EMAIL PROTECTED]] >Sent: Thursday, September 12, 2002 11:56 AM >To: [EMAIL PROTECTED] >Subject: RE: [KCFusion] Changing the subject > > >Don't you people have jobs?!!! Ya know with all this activity I think Ryan is going >to be expecting each and everyone of us at the next meeting. > >Just the other day I was thinking: everyone in Kansas City who programs ColdFusion >must be freaking genious's since no one was posting for help. haha Well I am anyway >;) > >On a more serious note, I recently came across a CF opportunity that I passed up, but >if anyone is interested it was a work from home CF position. It was a salaried >position but plan on working about 60 hours a week from the sounds of it. >Unfortunately, Ive got 3 kids and really, would you want to stay home all day with >that? (Actually if you email me, Ill tell you why I didnt take it and you can pursue >it or not) > >Misty > >-- Original Message -- >From: "Justin Hansen" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >Date: Thu, 12 Sep 2002 11:41:27 -0500 > >> >> Oh, well fine then... shall we keep the NULL conversation going? >> 1. Um, it was a CF question. (see original post) >> 2. What solution did Mike use? Come on, we all want to know. >> >> >> >> 3. I agree with Misty. >> 4. UDFs are cool. >> 5. Just having some fun here >> >> >>Hey Misty, >>Did you know I can throw stuff at Matt for you from where I sit? >>We are working together again but, Matt is still Mr. Fusebox. >> >> >>-Original Message- >>From: Misty Woodward [mailto:[EMAIL PROTECTED]] >>Sent: Thursday, September 12, 2002 11:33 AM >>To: [EMAIL PROTECTED] >>Subject: RE: [KCFusion] checking for nulls... >> >> >>LOL I think its great! Was getting a little dusty in my KCFusion inbox. >> >>Misty >> >>-- Original Message -- >>From: "Glenn Crocker" <[EMAIL PROTECTED]> >>Reply-To: [EMAIL PROTECTED] >>Date: Thu, 12 Sep 2002 11:23:20 -0500 >> >>> >>>> Geez, do you think this thread has gone on way to long or is it just me? >>> >>>Honestly, I think the original question may have been a SQL question, not a >>>CF question. ;-) >>> >>>-glenn >>> >>> >>> >>> >>>__ >>>The KCFusion.org list and website is hosted by Humankind Systems, Inc. >>>List Archives http://www.mail-archive.com/cf-list@kcfusion.org >>>Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] >>>To Subscribe mailto:[EMAIL PROTECTED] >>>To Unsubscribe mailto:[EMAIL PROTECTED] >>> >>> >> >> >>__ >>The KCFusion.org list and website is hosted by Humankind Systems, Inc. >>List Archives http://www.mail-archive.com/cf-list@kcfusion.org >>Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] >>To Subscribe mailto:[EMAIL PROTECTED] >>To Unsubscribe mailto:[EMAIL PROTECTED] >> >> >> >>__ >>The KCFusion.org list and website is hosted by Humankind Systems, Inc. >>List Archives http://www.mail-archive.com/cf-list@kcfusion.org >>Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] >>To Subscribe mailto:[EMAIL PROTECTED] >&
RE: [KCFusion] Changing the subject
Don't you people have jobs?!!! Ya know with all this activity I think Ryan is going to be expecting each and everyone of us at the next meeting. Just the other day I was thinking: everyone in Kansas City who programs ColdFusion must be freaking genious's since no one was posting for help. haha Well I am anyway ;) On a more serious note, I recently came across a CF opportunity that I passed up, but if anyone is interested it was a work from home CF position. It was a salaried position but plan on working about 60 hours a week from the sounds of it. Unfortunately, Ive got 3 kids and really, would you want to stay home all day with that? (Actually if you email me, Ill tell you why I didnt take it and you can pursue it or not) Misty -- Original Message -- From: "Justin Hansen" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Thu, 12 Sep 2002 11:41:27 -0500 > > Oh, well fine then... shall we keep the NULL conversation going? > 1. Um, it was a CF question. (see original post) > 2. What solution did Mike use? Come on, we all want to know. > > > > 3. I agree with Misty. > 4. UDFs are cool. > 5. Just having some fun here > > >Hey Misty, >Did you know I can throw stuff at Matt for you from where I sit? >We are working together again but, Matt is still Mr. Fusebox. > > >-Original Message- >From: Misty Woodward [mailto:[EMAIL PROTECTED]] >Sent: Thursday, September 12, 2002 11:33 AM >To: [EMAIL PROTECTED] >Subject: RE: [KCFusion] checking for nulls... > > >LOL I think its great! Was getting a little dusty in my KCFusion inbox. > >Misty > >-- Original Message -- >From: "Glenn Crocker" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >Date: Thu, 12 Sep 2002 11:23:20 -0500 > >> >>> Geez, do you think this thread has gone on way to long or is it just me? >> >>Honestly, I think the original question may have been a SQL question, not a >>CF question. ;-) >> >>-glenn >> >> >> >> >>__ >>The KCFusion.org list and website is hosted by Humankind Systems, Inc. >>List Archives http://www.mail-archive.com/cf-list@kcfusion.org >>Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] >>To Subscribe mailto:[EMAIL PROTECTED] >>To Unsubscribe mailto:[EMAIL PROTECTED] >> >> > > >__ >The KCFusion.org list and website is hosted by Humankind Systems, Inc. >List Archives http://www.mail-archive.com/cf-list@kcfusion.org >Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] >To Subscribe mailto:[EMAIL PROTECTED] >To Unsubscribe mailto:[EMAIL PROTECTED] > > > >__ >The KCFusion.org list and website is hosted by Humankind Systems, Inc. >List Archives http://www.mail-archive.com/cf-list@kcfusion.org >Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] >To Subscribe mailto:[EMAIL PROTECTED] >To Unsubscribe mailto:[EMAIL PROTECTED] > > __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] checking for nulls...
LOL I think its great! Was getting a little dusty in my KCFusion inbox. Misty -- Original Message -- From: "Glenn Crocker" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Thu, 12 Sep 2002 11:23:20 -0500 > >> Geez, do you think this thread has gone on way to long or is it just me? > >Honestly, I think the original question may have been a SQL question, not a >CF question. ;-) > >-glenn > > > > >__ >The KCFusion.org list and website is hosted by Humankind Systems, Inc. >List Archives http://www.mail-archive.com/cf-list@kcfusion.org >Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] >To Subscribe mailto:[EMAIL PROTECTED] >To Unsubscribe mailto:[EMAIL PROTECTED] > > __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] deletes on database?
In one of the projects I am working on now, they use Oracle stored functions only for database calls. When I first started doing it, I hated it. Honestly, I still hate it. From a development standpoint, as far as time goes, i would say it takes longer than just writing it directly into CF. When Im coding in CF I just write out my CF query and move on. When writing Stored Functions your 8 line query turns into a huge function where you have to declare varaibles, check for variabls, create the function, create your IN Variables, write in your return values, etc. The part that Stored Functions shine in, is with code re-use. The function I wrote is to be used across 3 systems. Which means, I only have to change it in one place and I can manage all 3 sites with it. Misty -- Original Message -- From: "Glenn Crocker" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Thu, 12 Sep 2002 10:50:12 -0500 >MessageI generally don't do any JOINs in my CF code, instead using >queries/views to accomplish them. (Sometimes, when a parameter needs to be >way inside a JOIN, I'll put one in CF.) I haven't done the full-on stored >procedure architecture, but most of my projects are just one or two >developers, so it's not a big team thing with lots of turnover. > >-glenn > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On >Behalf Of Ryan Hartwich > Sent: Wednesday, September 11, 2002 10:28 PM > To: [EMAIL PROTECTED] > Subject: RE: [KCFusion] deletes on database? > > > Adaryl, > > Somewhere I interviewed or spoke with someone about this topic. It was my >understanding that the individual coders being employed were generally not >allowed to do any form of insert/update/delete into the database through >their code. They were however permitted to write Select statements to >tables and/or views. The coders were given a set of API calls utilizing >XML services internally to do the direct DB manipulation. The idea was to >force data integrity and consistency by only allowing data to be modified >through approved prebuilt modules. > > A permutation of this would be to not permit inline DB calls in your CF >code and to call all DB statements via stored procedures. I have heard this >speeds up development, improves reusability, and quality. I'm a bit >skeptical of this however. I have spent a few years writing code as the >primary developer and write my SQL code directly inside of my CF pages. At >least for small development teams with ad-hoc design standards that change >frequently I think the extra overhead of standardizing and separating the >layers adds significant complexity. However, I would love to hear from >those who have used this method in large, formal design groups. It may be >the way to go. > > Ryan >-Original Message- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On >Behalf Of Adaryl Wakefield >Sent: Wednesday, September 11, 2002 10:10 PM >To: [EMAIL PROTECTED] >Subject: [KCFusion] deletes on database? > > >I once saw a job announcement that said something to the effect. "..no >deletes on the database will be allowed. All deletes are done via XML..." At >the time I just raised my eyebrow and went on but now I'm kinda curious if >anybody can shed some light on what exactly they meant. I only have an >academic understanding of XML and a small one at that. >A. > > __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] Lookup Table
Thats one way. I saw on a site where there was 2 radio buttons. The first one was defaulted to checked and the select box was enabled to choose from a list. The other radio box, when it was checked, disabled the drop down box and enabled the other text box to enter data in. I guess the point of it was so that if you selected something from the drop down box and that radio button was checked it would disable the text box and put an empty string in it, so it wouldnt be necessary to even check for its existance. Misty Woodward Oleani Technologies www.oleani.com -- Original Message -- From: "James K Tieman" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Thu, 12 Sep 2002 09:29:59 -0500 >How would you arrange the fields on the form? Would you stack them with the >select box on top and update the text box after a selection is made? Could >one of the choices could be "other" and if you clicked it, an empty string >and the focus (cusor) would go into the text box? Does that make any sense? > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On >Behalf Of Nate Rightmire > Sent: Thursday, September 12, 2002 8:58 AM > To: [EMAIL PROTECTED] > Subject: RE: [KCFusion] Lookup Table > > > I would create a select list from the values in the table, and then also >create a text input (with a slightly different name) for someone to enter a >new value. Then, just check the form fields on your processing page... I >would say that anything in the text input field overrides a value from the >select list... so if the text input is populated, do an insert, then do your >normal processing. If they just chose something from the select list, then >just do your normal processing. >-Original Message- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On >Behalf Of James K Tieman >Sent: Thursday, September 12, 2002 8:48 AM >To: KCFusion >Subject: [KCFusion] Lookup Table > > >On a form, one of the fields is, let's say, "Things We Love". It is >populated by an "TWL" table. >TWL Table: >1Grandchildren >2Children >3Sunsets >How can I choose from the list OR add a new TWL to the table? > >James K "Jamie" Tieman >Allied, Inc >P.O. Box 422 >Harrisonville, MO 64701 >Phone 816.380.6274 > > __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] checking for nulls...
The only problem I see with this, is he says checking if a variable is NULL, which probably means it does exist, hes just checking the value of it. I do this alot with datbase queries where I loop through a recordset, set some variables to the values that were in the database and then check if it contains data or is null. I guess what might be helpful to decide which is the best route to take would be to know what the intention of the code is to be used for. Checking if it exists or checking if the value exists but is null. Misty Woodward Oleani Technologies www.oleani.com -- Original Message -- From: "Ryan Hartwich" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Thu, 12 Sep 2002 09:26:51 -0500 >You probably want to perform an IsDefined check, for instance >your statement > >IF you have a form submission with check boxes, boxes that are not >checked are not submitted and hence are effectively null and you can't >perform a value check on them because they don't exist. CF does NOT >support null values. The closest it comes is having a few methods of >checking on the existence of a variable. > >Everyone else's replies about checking the length of the variable and >potentially trimming white space seems accurate...assuming the variable >exists. > >-Original Message- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On >Behalf Of Johnson, Michael >Sent: Thursday, September 12, 2002 7:46 AM >To: CF-List (E-mail) >Subject: [KCFusion] checking for nulls... > > >what's the syntax to check if a variable is "null"... > > >i.e. > > > > > > > >Mike Johnson >Science Application International Corporation >(757) 870-9165 >Emai: [EMAIL PROTECTED] > > > > >__ >The KCFusion.org list and website is hosted by Humankind Systems, Inc. >List Archives http://www.mail-archive.com/cf-list@kcfusion.org >Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] >To Subscribe mailto:[EMAIL PROTECTED] >To Unsubscribe mailto:[EMAIL PROTECTED] > > > > > >__ >The KCFusion.org list and website is hosted by Humankind Systems, Inc. >List Archives http://www.mail-archive.com/cf-list@kcfusion.org >Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] >To Subscribe mailto:[EMAIL PROTECTED] >To Unsubscribe mailto:[EMAIL PROTECTED] > > __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
Re: [KCFusion] off topic
Try www.aspin.com Cool site with a ton of ASP apps. Misty -- Original Message -- From: "Adaryl Wakefield" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Thu, 5 Sep 2002 12:38:09 -0500 >Does anyone know if there is a Microsoft equivalent of Macromedia's Developer >Exchange for ASP.net. >A. > > __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
Re: [KCFusion] Numeric Check in PL/SQL
This doesnt work in a block of code. Here is what I am going for, FN_ISNUMERIC is a function I am working in now having not found a standard Numeric check type function.So if you know of something a little easier to work with I would greatly appreciate it BEGIN SELECT SF_INTRANSIT(TRIM(V_DEST), TRIM(V_ORIG), TRIM(V_SHIPPER), TRIM(V_TRACKNUMBER), TRIM(V_TICKETNUM), TRIM(V_CONTACT)) AS V_SYSTEM_RESULT FROM DUAL; IF FN_ISNUMERIC(LEFT(V_SYSTEM_RESULT, 2)) THEN -- IF NUMERIC THEN THERE IS AN ERROR CODE V_RETURN := V_SYSTEM_RESULT; GOTO RETURN_VALUE; ELSE -- GOOD TO GO AND GOT A SYSTEM BACK V_RETURN := 'Finally!' EXCEPTION END; -- Original Message -- From: "Solution Hatch" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Tue, 3 Sep 2002 12:16:27 -0500 >LIKE >Any single character within the specified range ([a-f]) or set ([abcdef]). >WHERE foo LIKE '[abcdefghijklf]' > >Determines whether or not a given character string matches a specified >pattern. A pattern can include regular characters and wildcard characters. >During pattern matching, regular characters must exactly match the >characters specified in the character string; wildcard characters, however, >can be matched with arbitrary fragments of the character string. Using >wildcard characters makes the LIKE operator more flexible than using the = >and != string comparison operators. If any of the arguments are not of >character string data type, Microsoft® SQL ServerT converts them to >character string data type, if possible. > >Syntax >match_expression [NOT] LIKE pattern [ESCAPE escape_character] > >Arguments > match_expression > Is any valid SQL Server expression of character string data type. > pattern > Is the pattern to search for in match_expression, and can include these >valid SQL Server wildcard characters. > \ >Not sure if it will work within Oracle > > >- Original Message - >From: "Misty Woodward" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Tuesday, September 03, 2002 12:06 PM >Subject: [KCFusion] Numeric Check in PL/SQL > > >> Does anyone know of a function using PL/SQL that checks the value of a >variable to see if it contains all numbers or number and alpha. I originally >planned on doing this in CF with the IsNumeric check but just got shot down >to do it the oracle Function Im writing. >> >> Thanks, >> Misty >> >> >> __ >> The KCFusion.org list and website is hosted by Humankind Systems, Inc. >> List Archives http://www.mail-archive.com/cf-list@kcfusion.org >> Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] >> To Subscribe mailto:[EMAIL PROTECTED] >> To Unsubscribe mailto:[EMAIL PROTECTED] >> > > > >__ >The KCFusion.org list and website is hosted by Humankind Systems, Inc. >List Archives http://www.mail-archive.com/cf-list@kcfusion.org >Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] >To Subscribe mailto:[EMAIL PROTECTED] >To Unsubscribe mailto:[EMAIL PROTECTED] > > __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
[KCFusion] Numeric Check in PL/SQL
Does anyone know of a function using PL/SQL that checks the value of a variable to see if it contains all numbers or number and alpha. I originally planned on doing this in CF with the IsNumeric check but just got shot down to do it the oracle Function Im writing. Thanks, Misty __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] Affordable Co-location in Kansas City?
Just to add a thing or two about Communitech. We use to host with them and were extremely happy until they moved to Interland. I remember when it hit the news papers that Communitech was being taken over by Interland and even with the news paper right in front of them they lied to me and told me it wasn't happening. I was never real impressed with the customer service but when they did that, I pulled all of our customers from them immediately. Not to mention that I've been with Interland before and that was just an absolute nightmare so I would have pulled later anyway. Misty -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Schappaugh, Cheri Sent: Wednesday, August 21, 2002 2:19 PM To: '[EMAIL PROTECTED]' Subject: RE: [KCFusion] Affordable Co-location in Kansas City? I've had a bad time with www.Communitech.net. They seem to offer everything. Unfortunately the customer service is very poor. fyi only.. -Original Message- From: Josen Ruiseco [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 21, 2002 2:12 PM To: [EMAIL PROTECTED] Subject: [KCFusion] Affordable Co-location in Kansas City? I am looking for a co-location facility in Kansas City that allows a lot of bandwidth (full T-1 or better) and has a good up time status. Also, someone who doesn't charge through the roof. Anybody know of any? Josen Ruiseco Motorsport Marketing http://www.gomotorsports.com __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] This message and any attachments are confidential to the intended recipient at the e-mail address to which it has been addressed. If you are not the intended recipient you may not copy, forward, disclose or use any part of this message or its attachments. If you received in error please notify the sender immediately by e-mail or contact The Innovation Group, US, at 800-669-9689 and then delete this message from your system. Neither the sender nor any office or company in The Innovation Group plc group will be liable for any viruses. Any opinions contained in this message are those of the author and are not given or endorsed by any company in The Innovation Group plc group through which this message was sent unless otherwise expressly stated in this message and the authority of the author in so stating is verified. The Innovation Group, US, at 8345 Lenexa Drive, Suite 100, Lenexa, Kansas, 66214, USA. __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] ASP vs CF
One of the biggest arguements I have seen is the cost issue. Most of the time it starts with "well CF is more expensive to start with, but you save in development time so the cost really isnt a concern". Im sorry but that is a load. Sure, you take a CF expert who also happens to know a little ASP and yes they are going to develop their app faster in CF. But if you take someone who has been using ASP for years and knows all there is to know, there really isn't a significant difference in development time. I have been on both sides and both technologies are good. Each is just good for different things. As for cost though, I still havent seen any real evidence of CF being cheaper than ASP. For the record, I would still choose CF over ASP on most apps, but I still think ASP is awesome. Misty -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 07, 2002 10:41 AM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] ASP vs CF Robin, you're right, but your remarks are based on logic. My reason for gathering ASP vs CF information is to deal with the mentality that says "Microsoft has most of the desktop OS market, so all their software must be the best in the world". It's amazing how many people think like this. Like you, I prefer an informed decision. Which is why I'm trying to gather rational information to counter irrational assumptions. Not disagreeing with you :-) Keith Purtell, Web/Network Administrator VantageMed Operations (Kansas City) Email: [EMAIL PROTECTED] CONFIDENTIALITY NOTICE: This email message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Greenhagen, Robin Sent: Tuesday, May 07, 2002 10:20 AM To: [EMAIL PROTECTED] Subject: [KCFusion] ASP vs CF In advance, sorry about the long drivel below :-)... I think that it is important to realize that the ASP vs. CF argument is a bit misleading when trying to build up the feature by feature comparison. We have been CF centric for 5+ years, but still write ASP apps for people if their environment, their staff, and their needs dictate it. Once you have technique in either tool set, there is less of difference in productivity than either group claims. I think comparing on a feature by feature basis is like looking at WordPad (ASP) vs. MS Word (CF). When was the last time you used CFAUTHENTICATE or CFLDAP? But your server loads that code up every time you start the CF services. One advantage to the ASP model of components (3rd party controls to do mail, encryption, credit cards, etc...) is that if we don't like one, we can pitch it and use one of the other 10 vendors out there. We have had to do this in the past when a CF component (CFPOP or CFHTTP) failed to meet our needs. So either way we incur the expense of buying the control that we like, but with CF, now I have two solutions loaded on the box, and I have to use CFOBJECT, which has had it's own issues. In the past we have felt like Alliare was the 3rd camp (ASP and J2EE were the two most visible, widely used tools). Now CF truly has an alliance with the Java camp in CFMX, and great interoperability with the .NET (formerly ASP, COM, ActiveX) camp. But if a company is deploying desktop applications in VB.NET, it will be a hard argument that they shouldn't deploy the web interfaces for that app in ASP.NET. There is no definitive right/wrong decision matrix that can account for all project variations, etc... What I believe was the biggest single accomplishment in CFMX won't be mentioned by Macromedia. They have essentially ensured that CFML will live for the next 10 years by implementing it on the J2EE platform. As a standalone, single vendor, propriety language, app server solution, someone could have easily said "we are shelving CF and pursuing JSP/J2EE" as about 10 - 20 other app server vendors have done. Now even large organizations that have $xxx,xxx,xxx worth of BEA Weblogic and IBM Webshpere can use CFML to get the job done. These development groups that have been implementing CF as an "unsupported" application on their networks can now take the approach that this is the CFMX tool for Weblogic/Websphere and run it in a fully supported production environment. Cheers! Robin Greenhagen President GSI http://www.gsi-kc.com/ winmail.dat Description: application/ms-tnef
RE: [KCFusion] Query Problem
Returns about 2k records. The whole database is only 430k rows. We are using Oracle native drivers. The application is currently written in server side javascript and runs so fast its like lightening. I just find it very odd to be such a difference. I checked on the macromedia boards and Im not the first to see this happen, of course no one ever seems to get an answer on the boards. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Ryan Hartwich Sent: Wednesday, March 27, 2002 11:14 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] Query Problem If it's a big query and uses lots of ram, and your machine is out of ram it would have to page the info to the hard drive. But if your run time is consistent then that's not it. Are you using the correct odbc drivers? __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
[KCFusion] Query Problem
I have been having a problem with huge differences in queries being run through a CF page and those run directly in an Oracle client. I understand there might be some difference in time because of the overhead of CF but I can't imagine why it would be so great. When I run this particular query through the Oracle client it takes just over 2 seconds. However when I put it in a CF page it is taking 28 seconds. This is a plain CF page with just the cfquery on it. I dont even display the results. The debugging code shows the query alone is taking 28 seconds. Any ideas on why this would be happening and what I can do to fix it? Thanks, Misty __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] CFHTTP-uploading comma delimited format to a database,(16,000+Records)
What exactly is the error you are getting when you say it isn't working? Do you have any sample code we could see? Misty -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Richard Morrison Sent: Monday, March 25, 2002 11:43 PM To: [EMAIL PROTECTED] Subject: [KCFusion] CFHTTP-uploading comma delimited format to a database,(16,000+Records) Ok, heres the problem i'm having, I made a custom tag to convert an excel spreedsheet to comma delimited format, works perfect, then i'm trying to make another custom tag using CFHTTP GET to upload the contents of this file to a query, for some reason I can't get it to work, also would the size of the text file be a problem? I've been working on this for a day know, hope someone can help? __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] CFContent Issues
LOL howard you're evil! See my ex-bosses just love me! But ya I guess I am kinda cute ;) Misty...The cute one -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED] Sent: Friday, February 22, 2002 3:35 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] CFContent Issues Hi cutie! How are you doing? Howard Thanks, Misty Woodward BigOSoftware [EMAIL PROTECTED] www.BigOSoftware.com Contact us about our Developer Discount Program 6709 W 119th Street Suite 422 Overland Park, KS 66209 913-219-2210 __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] CFContent Issues
I think that was a similar thread to the one that gave me the idea to put the filenam at the end of the extension like getfile.cfm/myfile.xls and it seems to be working from my testing today. Now if I could just get rid of that stupid second dialog box. I swear you gotta tell Microsoft everything twice! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Keith Purtell Sent: Thursday, February 21, 2002 3:52 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] CFContent Issues Misty: If I correctly understand what you are trying to do, the attached HTML file may contain relevant information. It's just a thread from an Allaire forum that I saved locally to read. Keith Purtell, Web/Network Administrator VantageMed Operations (Kansas City) Email: [EMAIL PROTECTED] CONFIDENTIALITY NOTICE: This email message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Misty Woodward Sent: Thursday, February 21, 2002 2:36 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] CFContent Issues ya I have about 3 different options I can offer them that would make things a whole lot easier. But the look of the way this works has to replicate what they currently have in Server Side Javascript (which I hav begun to hate after this project). So I can do anything cool with Excel 2000, link directly to the file or anything else that would make my life easier. Misty -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Darin Spence Sent: Thursday, February 21, 2002 2:27 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] CFContent Issues If the client is using Excel 2000, you might consider creating an Excel file for them that uses the "Web Query" feature. We've started doing this as opposed to creating Excel files "on-the-fly." Create a "raw data" page (simple table with the data in it) then from Excel use a Web Query and point to that page. What's cool is in Excel you can just have a sheet called "Raw Data," then other sheets that build graphs based on the data on the fly. When they want to update their graphs, they just refresh the web query. Good luck! -Darin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Misty Woodward Sent: Thursday, February 21, 2002 1:19 PM To: [EMAIL PROTECTED] Subject: [KCFusion] CFContent Issues Hi all. Hopefully someone here has ran into this problem... I have an excel exporter type deal. Now before I get alternative suggestions for how I can do this let me explain how it has to "look" to the client. I am on a page that shows a table format of query results. There is a little Excel Icon that I click on to export my results to an XLS file (not csv). A small window about 2 inches wide, 1 inch across pops up and says "Building Excel FilePlease wait" so I CFFLUSH that much to the page while it builds the file and writes it to the server using CFFILE. Once that file is completely written I then display "Retrieving Data". This is where I then through Javascript submit the page to another file called getfile.cfm. In getfile.cfm I am using CFCONTENT to retrieve that file back out of the server and then delete it. The problem is two things... 1. When I get the pop up box it says I am trying to download a file "getfile.cfm" Why is it naming the file in the pop up box the name of my CFM template? But when I click save as it saves it with the correct name "myfile.xls". Someone on the macromedia board suggested I put the filename after the getfile.cfm page as you can see in the code below, and it seems to fix this problem, but I dont know how stable this is. 2. When I click open instead of save as, it doesnt open. Instead, I get a second dialog box asking me once again if I want to open or save as. This time, if I choose open, it does open Excel and I can read the file. Why would it give me this pop up twice? After the file downloads I close the window that originally popped up. Which also isn't working, but I think that is because CF isn't letting me process the page anymore after I use CFCONTENT or submit to a new page. Here is the code I am using... gen_excel.cfm 2. Retrieving Data document.TheForm.submit(); getfile.cfm Any help would be greatly appreciated. The poeple at Macromedia and the boards and such either don't know or just aren't helpful. Thanks, Misty Woodward BigOSoftware [EMAIL PROTECTED] www.BigOSo
RE: [KCFusion] CFContent Issues
ya I have about 3 different options I can offer them that would make things a whole lot easier. But the look of the way this works has to replicate what they currently have in Server Side Javascript (which I hav begun to hate after this project). So I can do anything cool with Excel 2000, link directly to the file or anything else that would make my life easier. Misty -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Darin Spence Sent: Thursday, February 21, 2002 2:27 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] CFContent Issues If the client is using Excel 2000, you might consider creating an Excel file for them that uses the "Web Query" feature. We've started doing this as opposed to creating Excel files "on-the-fly." Create a "raw data" page (simple table with the data in it) then from Excel use a Web Query and point to that page. What's cool is in Excel you can just have a sheet called "Raw Data," then other sheets that build graphs based on the data on the fly. When they want to update their graphs, they just refresh the web query. Good luck! -Darin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Misty Woodward Sent: Thursday, February 21, 2002 1:19 PM To: [EMAIL PROTECTED] Subject: [KCFusion] CFContent Issues Hi all. Hopefully someone here has ran into this problem... I have an excel exporter type deal. Now before I get alternative suggestions for how I can do this let me explain how it has to "look" to the client. I am on a page that shows a table format of query results. There is a little Excel Icon that I click on to export my results to an XLS file (not csv). A small window about 2 inches wide, 1 inch across pops up and says "Building Excel FilePlease wait" so I CFFLUSH that much to the page while it builds the file and writes it to the server using CFFILE. Once that file is completely written I then display "Retrieving Data". This is where I then through Javascript submit the page to another file called getfile.cfm. In getfile.cfm I am using CFCONTENT to retrieve that file back out of the server and then delete it. The problem is two things... 1. When I get the pop up box it says I am trying to download a file "getfile.cfm" Why is it naming the file in the pop up box the name of my CFM template? But when I click save as it saves it with the correct name "myfile.xls". Someone on the macromedia board suggested I put the filename after the getfile.cfm page as you can see in the code below, and it seems to fix this problem, but I dont know how stable this is. 2. When I click open instead of save as, it doesnt open. Instead, I get a second dialog box asking me once again if I want to open or save as. This time, if I choose open, it does open Excel and I can read the file. Why would it give me this pop up twice? After the file downloads I close the window that originally popped up. Which also isn't working, but I think that is because CF isn't letting me process the page anymore after I use CFCONTENT or submit to a new page. Here is the code I am using... gen_excel.cfm 2. Retrieving Data document.TheForm.submit(); getfile.cfm Any help would be greatly appreciated. The poeple at Macromedia and the boards and such either don't know or just aren't helpful. Thanks, Misty Woodward BigOSoftware [EMAIL PROTECTED] www.BigOSoftware.com Contact us about our Developer Discount Program 6709 W 119th Street Suite 422 Overland Park, KS 66209 913-219-2210 __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
[KCFusion] CFContent Issues
Hi all. Hopefully someone here has ran into this problem... I have an excel exporter type deal. Now before I get alternative suggestions for how I can do this let me explain how it has to "look" to the client. I am on a page that shows a table format of query results. There is a little Excel Icon that I click on to export my results to an XLS file (not csv). A small window about 2 inches wide, 1 inch across pops up and says "Building Excel FilePlease wait" so I CFFLUSH that much to the page while it builds the file and writes it to the server using CFFILE. Once that file is completely written I then display "Retrieving Data". This is where I then through Javascript submit the page to another file called getfile.cfm. In getfile.cfm I am using CFCONTENT to retrieve that file back out of the server and then delete it. The problem is two things... 1. When I get the pop up box it says I am trying to download a file "getfile.cfm" Why is it naming the file in the pop up box the name of my CFM template? But when I click save as it saves it with the correct name "myfile.xls". Someone on the macromedia board suggested I put the filename after the getfile.cfm page as you can see in the code below, and it seems to fix this problem, but I dont know how stable this is. 2. When I click open instead of save as, it doesnt open. Instead, I get a second dialog box asking me once again if I want to open or save as. This time, if I choose open, it does open Excel and I can read the file. Why would it give me this pop up twice? After the file downloads I close the window that originally popped up. Which also isn't working, but I think that is because CF isn't letting me process the page anymore after I use CFCONTENT or submit to a new page. Here is the code I am using... gen_excel.cfm 2. Retrieving Data document.TheForm.submit(); getfile.cfm Any help would be greatly appreciated. The poeple at Macromedia and the boards and such either don't know or just aren't helpful. Thanks, Misty Woodward BigOSoftware [EMAIL PROTECTED] www.BigOSoftware.com Contact us about our Developer Discount Program 6709 W 119th Street Suite 422 Overland Park, KS 66209 913-219-2210 __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] OT - Software Marketing
We have had some great experience with selling apps through our site www.bigosoftware.com (no pun intended :) ) We do mostly ColdFusion but are working on about 4 ASP based apps that are similar in functionality to some of our CF apps. As far as marketing goes, I would say the best success we have had is with our AuthorizeNet gateway interface tag. Its been on the market for about a year now and we get so much exposure for it through AuthorizeNet and also the other site I developed at CFCustomTags.com. The other really good experience I have had is with the CF Linkmanager product we have. With web directories being on the rise you could target basically any web site owner with CF and make a sale. Everyone wants directories, be it web sites, addresses, emails, etc. As for pricing, well its kind of a hit or miss. When I started selling CF Authorize over a year ago, I started it off at $39 I think it was. After watching the market and its sales I know I can now get $125 from the same tag that sold for $39 last year. We have actually had increase in sales for that one since the price increase. I think it has a lot to do with perceived value: more expensive it is, the better it is. The other thing we are trying is a developer discount program. Lots of web developers, both firms and freelancers, buy our software at a discounted price and resell it at whatever price they want to their customers. Besides who wants to reinvent the wheel if its already there. Also you wouldn't believe with a name like Big O Software how many other programmers out there are always emailing and asking me the meaning behind it. So with a name like that, programmers might just click on the name just to see what it is (If you don't get this never mind). Thanks, Misty Woodward BigOSoftware [EMAIL PROTECTED] www.BigOSoftware.com Contact us about our Developer Discount Program 6709 W 119th Street Suite 422 Overland Park, KS 66209 913-219-2210 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of James K Tieman Sent: Tuesday, February 19, 2002 3:32 PM To: KCFusion Subject: [KCFusion] OT - Software Marketing We have all created the better mousetrap, but let's be real, we're programmers. Has anyone had any positive experiences trying to market a software package. If you would like, contact me off list. Thanks for the vine, fellow listers. James K. (Jamie) Tieman [EMAIL PROTECTED] Allied, Inc. 3455 W 40 Hwy Blue Springs, MO 64015 (816)229-5610 __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] The Lord of The Rings
Title: The Lord of The Rings Gee Rick id love to! ;) Misty -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Rick EidsonSent: Thursday, December 20, 2001 8:54 AMTo: CF-List (E-mail); Scott Strange (E-mail); Vaughn. E. Rupp (E-mail); Monty (E-mail)Subject: [KCFusion] The Lord of The Rings Hey are we going Saturday to See Lord of the Rings? Rick
RE: [KCFusion] NT Authentication on Unix
ok guys, another related question. Instead of NT, does anyone know of a variable I could call to get the novell login id of a user. Basically they are already logged on to the network so when they access the web site I want to capture their novell login name and compare that to our permissions table on Oracle, but first I need their login. auth_user, remote_user do not work. Thanks, Misty -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Dave Gammage Sent: Thursday, November 29, 2001 2:54 PM To: [EMAIL PROTECTED] Subject: Re: [KCFusion] NT Authentication on Unix It would require another server to authenticate the NT Users. NT would then have to authenticate with the UNIX server through IIS. A different web would probably have to be set up for the NT users to access, since Unix doesn't use NTFS permissions. Create a UNIX account that IIS can utilize to authenticate requests. I haven't really explored LDAP options...can NT authenticate through LDAP instead of NTFS security somehow? Don't really know if that would all work...but it seems logical to me. Any other thoughts? Dave Gammage Digital Prairie Communications Original Message: > I have a client who is using an LDAP system to authenticate their users on a > secured area on their Unix web site. They are now wanting to change their > system to do NT Authentication for their users who are on NT desktops. But > they want their web server to stay on Unix. Is this possible? Anyone wanna > shed some light if you have done this before? > > > Thanks, > Misty > > > > __ > The KCFusion.org list and website is hosted by Humankind Systems, Inc. > List Archives http://www.mail-archive.com/cf-list@kcfusion.org > Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] > To Subscribe mailto:[EMAIL PROTECTED] > To Unsubscribe mailto:[EMAIL PROTECTED] > > __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
[KCFusion] NT Authentication on Unix
I have a client who is using an LDAP system to authenticate their users on a secured area on their Unix web site. They are now wanting to change their system to do NT Authentication for their users who are on NT desktops. But they want their web server to stay on Unix. Is this possible? Anyone wanna shed some light if you have done this before? Thanks, Misty __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] IP pricing
That should have been 4$ oops -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Misty Woodward Sent: Friday, November 16, 2001 2:41 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] IP pricing I am paying $ per statis IP address through my hosting provider. Thanks, Misty Woodward Oleani Technologies, LLC [EMAIL PROTECTED] www.oleani.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mark Kirkbride Sent: Friday, November 16, 2001 12:48 PM To: '[EMAIL PROTECTED]' Subject: [KCFusion] IP pricing I have a client that is requesting a customized web page. Does anyone have any idea what a dedicated IP address is worth? Thanks in advance, Mark Kirkbride Information System Specialist FBD Consulting, Inc. (913) 319-8836 [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] IP pricing
I am paying $ per statis IP address through my hosting provider. Thanks, Misty Woodward Oleani Technologies, LLC [EMAIL PROTECTED] www.oleani.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mark Kirkbride Sent: Friday, November 16, 2001 12:48 PM To: '[EMAIL PROTECTED]' Subject: [KCFusion] IP pricing I have a client that is requesting a customized web page. Does anyone have any idea what a dedicated IP address is worth? Thanks in advance, Mark Kirkbride Information System Specialist FBD Consulting, Inc. (913) 319-8836 [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] Yesterday's meeting
I used Fusebox when it was Fusebox 1.0 and they have made some great improvements, but even back then I thought it was very cool. It can really help you organize your code and makes everything so much easier for code reuse. I reuse queries quite often so it would come in quite handy. Also it does make things more organized and for some reason it really makes your code look cleaner. The only drawback I would say that there is to Fusebox is it can be a chore in large applications to keep track of your files. I could have 5 queries, 4 displays, 5 actions, 2 forms, and whatever else in a fuse which means for just that fuse that is atleast 16 pages I now have to manage. Having said that, I dont think that is a major drawback, I just think it takes the time to get used to doing it that way. Misty -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Smith, Jim Sent: Thursday, November 15, 2001 8:58 AM To: '[EMAIL PROTECTED]' Subject: RE: [KCFusion] Yesterday's meeting Would you folks recommend using Fusebox? -Original Message- From: Matthew W Jones [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 14, 2001 12:58 PM To: '[EMAIL PROTECTED]' Subject: [KCFusion] Yesterday's meeting Thank you for allowing me to share 5 minutes :o) of fusebox stuff, if you have any questions about what we talked about, feel free to ask. If I didn't specifically address the questions you had, I apologize, and will help in any way I can. Here again are the links that I gave you, if you are interested. http://www.fusebox.org Fusebox home http://www.secretagents.com 24/48 hour coding http://www.halhelms.com great resource for training/sample code (also has a link to the fusebox mailing list on topica) __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] Application Server service terminated unexpectedly
Were there any other noticeable errors in the error logs around the same time this is happening? Misty WoodwardOleani Technologies, LLC[EMAIL PROTECTED]www.oleani.com -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Rick EidsonSent: Wednesday, November 14, 2001 10:01 AMTo: CF-List (E-mail)Subject: [KCFusion] Application Server service terminated unexpectedlyImportance: High The Cold Fusion Application Server service terminated unexpectedly. It has done this 1 time(s). The following corrective action will be taken in 0 milliseconds: No action. This keeps happening on our CF5 server. Anyone seen this before? Rick
RE: [KCFusion] Meeting tomorrow
::cough:: Just the boys huh? I should be there! Misty Woodward Oleani Technologies, LLC [EMAIL PROTECTED] www.oleani.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Keith Purtell Sent: Monday, November 12, 2001 10:45 AM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] Meeting tomorrow Yeah, there's always the remote possibility she would have gotten irate if you ran off to hang with the boys. Keith Purtell, Web/Network Administrator VantageMed Operations (Kansas City) Email: [EMAIL PROTECTED] CONFIDENTIALITY NOTICE: This email message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Don Buck Sent: Monday, November 12, 2001 10:41 AM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] Meeting tomorrow I should also. Last month, my wife had just given birth that day; so I didn't think it was a good idea. Don Buck (816) 767-9681 Chief Information Officer ShareValue Inc. http://www.sharevalue.com __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
Re: [KCFusion] ColdFusion Certification
I took it last year and honestly for me it was more of a personal goal more than anything else. Certification was also important to me to take up some of the slack of no college. As far as my employer goes, they were like "oh hey good job" but thats about it. Skills and competence in your programming can more than make up for a certification if cost is an issue. As far the test goes, if you have the $150 its a good investment in yourself. I did it on a whim one morning on my way to work so I was rushed with about 25 minutes to take it but passed it first time through. If you know CF fairly well, then you'll do fine but preparation may have made it a little easier. :) Misty Woodward [EMAIL PROTECTED] www.oleani.com -- Original Message -- From: "Sheeran, Jean" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Tue, 15 May 2001 11:50:06 -0500 >Has anyone taken the Allaire CF exam? Has anyone passed it? At a price of >$150 it is not very expensive compared to some other 'certifications' out >there, but I am still curious about whether or not this exam has any impact. >Does it really mean enough for it to be worth preparing for it? > >Jean Sheeran >remel Laboratory Products >EDI Analyst/Web Designer >913-895-4242 >- >If Microsoft has enough clout to get their own Windows Key on every new >keyboard, isn't it about time for them to condense CTRL, ALT, and DELETE >into one easy key? > > > >__ >The KCFusion.org list and website is hosted by Humankind Systems, Inc. >List Archives http://www.mail-archive.com/cf-list@kcfusion.org >Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] >To Subscribe mailto:[EMAIL PROTECTED] >To Unsubscribe mailto:[EMAIL PROTECTED] > > __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] Dynamically Creating AND Populating Radio Buttons
Ya it is checked, sorry about that copied that from one I did with a select box. -- Original Message -- From: <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Tue, 17 Apr 2001 14:32:54 -0500 >> >> > selected> >> > >That's how you do it, but I believe that "selected" should be "checked". >"Selected" is used for tags, and "checked" is used for radio >buttons and checkboxes. > > >Ron Allen Hornbaker >President/CTO >Humankind Systems, Inc. >http://humankindsystems.com >mailto:[EMAIL PROTECTED] > > > > > >__ >The KCFusion.org list and website is hosted by Humankind Systems, Inc. >List Archives http://www.mail-archive.com/cf-list@kcfusion.org >Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] >To Subscribe mailto:[EMAIL PROTECTED] >To Unsubscribe mailto:[EMAIL PROTECTED] > > __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
Re: [KCFusion] Dynamically Creating AND Populating Radio Buttons
Run your query to pull the user info and set a variable for the department id then run the query to pull the list of departments and select if it its chosen. Something like this ... select * from users where userid = #userid# select * from tblDepartments selected> -- Original Message -- From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Tue, 17 Apr 2001 14:19:01 -0500 >Hey, all. Here's my latest dilemma. I am working on an employee database. I want >to create a form for updating employee information. One of the fields I want to >update is the Department field, which is represented by radio buttons. I have no >problem dynamically creating the radio buttons based on the values from a related >table (tblDepartments) but I am having trouble defaulting which radio button is >selected. I want the user to see the employee's department represented by a group >of radio buttons and be able to select a different department if the wrong one is >chosen. The problem as I see it exists because I want the selected button to be the >value stored in the tblEmployees table, but I have to query the tblDepartments table >to dynamically create my radio buttons. I understand that I cannot nest >tags and I essentially want to query two different tables, so how do I 1)dynamically >CREATE the radio buttons and 2)dynamically select the appropriate radio button, based >on the employee's existi> I know that you can put a subquery in your SQL statement, >but I am having trouble getting this to work. I wonder if Access doesn't handle >subqueries... > Thank you for any help you can give me!! You have already been such a tremendous >resource. I really appreciate it. > Jered > > >__ >The KCFusion.org list and website is hosted by Humankind Systems, Inc. >List Archives http://www.mail-archive.com/cf-list@kcfusion.org >Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] >To Subscribe mailto:[EMAIL PROTECTED] >To Unsubscribe mailto:[EMAIL PROTECTED] > > __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
