[KCFusion] Jobs from the inbox
Hi all, I got this in my inbox and I am passing it on to anyone who can use it. Looking for a SQL Server DBA for a 3 to 6 month contract for hire opportunity in Kansas City. Description is below. To speed the process up, please answer the questions and send a copy of your resume. Thanks, 1. Do you have a Bachelor's degree in Computer Science? 2. How much professional experience do you have with Relational Database Management Systems including database implementation, tuning, troubleshooting and maintenance. 3. How many years of DBA experience with Microsoft SQL Server do you have? 4. Do you have experience with NT or Windows 2000 operating systems? 5. Do you understand networking concepts to include the ability to know how to hook up more than one machine? 6. Do you have experience with Relational Database Management Systems logical and physical design, business analysis and security procedure?. 7. Do you have experience with Unix operating systems. 8. What are your salary expectations for perm. ? What is your hourly rate expectations while on contract? I. JOB SUMMARY - Manage the requirements of assigned database(s). Maintain DB software servers and perform day-to-day monitoring, optimizing, maintenance, and developer support. Develop backup and recovery procedures both from an applications viewpoint as well as disaster recovery for assigned project(s). Work with the Technical Services group, Applications Development group and other members of the DBA group to provide consistency in all areas provided servers. Research, identify and plan for how assigned project(s) will fit into the corporate model. Provide regular reporting to the backup DBA and Technical Team Lead for assigned projects. II. ESSENTIAL DUTIES AND RESPONSIBILITIES - 1. Work with the DBA team lead to understand the requirements and scope of responsibility of the assigned project(s). 2. Manage the storage requirements for databases. Monitor space used and develop thresholds to signal a need to increase space. 3. Understand company and project data and how that data fits together to construct tool recommendations, data strategies, naming conventions, data growth patterns, data availability, security of data, etc. Help identify data that meets specific business requirements for inclusion in the data warehouse and data marts. 4. Design and implement physical data models used by application teams as applicable. 5. Keep secondary support DBA up to date on all pertinent issues regarding assigned project(s). 6. Provide utilities and reports to application team to assist in system monitoring efforts. This includes space utilization reports, key/index usage reports and other reports to assist in a joint effort to predict points of failure or the need to optimize. 7. Serve as backup for those projects assigned secondary responsibility. IV. QUALIFICATIONS - Minimum Requirements 6. Bachelor's degree in Computer Science or related field or the equivalent through a combination of education and work experience. 7. Three years experience with Relational Database Management Systems including database implementation, tuning, troubleshooting and maintenance. 8. Three years DBA experience with Microsoft SQL Server. 9. Experience with NT or Windows 2000 operating systems. 10. Understand networking concepts to include the ability to know how to hook up more than one machine. 11. Effective oral, written and interpersonal communication skills. Preferred Qualifications 1. Five years experience with Microsoft SQL Server. 2. Experience with Relational Database Management Systems logical and physical design, business analysis and security procedures. 3. Experience with Unix operating systems. Paul Smith Solutions Point 913-338-2515 Office 913-486-8295 PCS 888-522-1167 Toll Free [EMAIL PROTECTED] www.solutionspoint.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]
RE: [KCFusion] Encrypted URL and JS
I may have to attempt Bryan's idea or something else. Here's why. The actual source code of this dynamic page contains no quote marks in the encrypted link. However IE is interpreting the URLEncodedFormat and then finding characters that generate a JavaScript error. Ron if I want to use your idea I'll need to use JavaScript to escape the quote marks. Not too difficult but more complicated that I originally planned. 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 Ron Hornbaker Sent: Wednesday, January 22, 2003 7:19 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] Encrypted URL and JS Check for embedded single quotes - since that's your JS delimiter, you'll need to escape them by replacing all of them with \' couplets. -Ron -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Keith Purtell Sent: Wednesday, January 22, 2003 5:48 PM To: KCFusion (E-mail) Subject: [KCFusion] Encrypted URL and JS I'm trying to encrypt a URL. The problem is I keep getting JS error Unterminated String Constant when I click the hyperlink that is supposed to call the window. This worked fine before I started trying to protect the file path by encrypting. Here is a snippet of my code ... cfset string = /dirone/dirtwo/filename.pdf cfset key = alpha123 cfset encrypted = URLEncodedFormat(Encrypt(string, key)) CFOUTPUT A HREF=javascript:openWindow('download.cfm?FilePath=#encrypted#') Click here/A /CFOUTPUT Did some research and only found one vague reference at the Macromedia web forums. That person supposedly solved this problem by using an obsolete CF function. --- [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]
RE: [KCFusion] Encrypted URL and JS
Title: RE: [KCFusion] Encrypted URL and JS this would be the result using ron's advice. A HREF="" ', \', all)#') Click here/A -Original Message- From: Keith Purtell [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 23, 2003 10:12 AM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] Encrypted URL and JS I may have to attempt Bryan's idea or something else. Here's why. The actual source code of this dynamic page contains no quote marks in the encrypted link. However IE is interpreting the URLEncodedFormat and then finding characters that generate a _javascript_ error. Ron if I want to use your idea I'll need to use _javascript_ to escape the quote marks. Not too difficult but more complicated that I originally planned. 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 Ron Hornbaker Sent: Wednesday, January 22, 2003 7:19 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] Encrypted URL and JS Check for embedded single quotes - since that's your JS delimiter, you'll need to escape them by replacing all of them with \' couplets. -Ron -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Keith Purtell Sent: Wednesday, January 22, 2003 5:48 PM To: KCFusion (E-mail) Subject: [KCFusion] Encrypted URL and JS I'm trying to encrypt a URL. The problem is I keep getting JS error Unterminated String Constant when I click the hyperlink that is supposed to call the window. This worked fine before I started trying to protect the file path by encrypting. Here is a snippet of my code ... cfset string = /dirone/dirtwo/filename.pdf cfset key = alpha123 cfset encrypted = URLEncodedFormat(Encrypt(string, key)) CFOUTPUT A HREF=""> Click here/A /CFOUTPUT Did some research and only found one vague reference at the Macromedia web forums. That person supposedly solved this problem by using an obsolete CF function. --- [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]
RE: [KCFusion] Encrypted URL and JS
Yes, and the replace function happens on the server. I tested this; it goes to the browser at client side and malfunctions. (See attached gif screen capture of what IE is doing.) This is why I would have to use a JavaScript replace if I were to continue down this path. Thanks anyway. 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 Dunwiddie, Bruce Sent: Thursday, January 23, 2003 10:30 AM To: '[EMAIL PROTECTED]' Subject: RE: [KCFusion] Encrypted URL and JS this would be the result using ron's advice. A HREF=javascript:openWindow('download.cfm?FilePath=#replace(encrypted, ', \', all)#')Click here/A -Original Message- From: Keith Purtell [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 23, 2003 10:12 AM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] Encrypted URL and JS I may have to attempt Bryan's idea or something else. Here's why. The actual source code of this dynamic page contains no quote marks in the encrypted link. However IE is interpreting the URLEncodedFormat and then finding characters that generate a JavaScript error. Ron if I want to use your idea I'll need to use JavaScript to escape the quote marks. Not too difficult but more complicated that I originally planned. 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 Ron Hornbaker Sent: Wednesday, January 22, 2003 7:19 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] Encrypted URL and JS Check for embedded single quotes - since that's your JS delimiter, you'll need to escape them by replacing all of them with \' couplets. -Ron -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Keith Purtell Sent: Wednesday, January 22, 2003 5:48 PM To: KCFusion (E-mail) Subject: [KCFusion] Encrypted URL and JS I'm trying to encrypt a URL. The problem is I keep getting JS error Unterminated String Constant when I click the hyperlink that is supposed to call the window. This worked fine before I started trying to protect the file path by encrypting. Here is a snippet of my code ... cfset string = /dirone/dirtwo/filename.pdf cfset key = alpha123 cfset encrypted = URLEncodedFormat(Encrypt(string, key)) CFOUTPUT A HREF=javascript:openWindow('download.cfm?FilePath=#encrypted#') Click here/A /CFOUTPUT Did some research and only found one vague reference at the Macromedia web forums. That person supposedly solved this problem by using an obsolete CF function. attachment: js.gif
RE: [KCFusion] Encrypted URL and JS
Title: RE: [KCFusion] Encrypted URL and JS The error to me looks like it calling an escape sequence that doesn't exist, like \E or whatever. We can just keep having fun with this like this... only problem is that I know from experience that encrypt in cf puts a chr(10) at the end of the encrypted value, and I can't currently think of a way to pass that through the url, but maybe someone else can. A HREF="" \, \\, all), ', \', all)#')Click here/A -Original Message- From: Keith Purtell [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 23, 2003 10:58 AM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] Encrypted URL and JS Yes, and the replace function happens on the server. I tested this; it goes to the browser at client side and malfunctions. (See attached gif screen capture of what IE is doing.) This is why I would have to use a _javascript_ replace if I were to continue down this path. Thanks anyway. 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 Dunwiddie, Bruce Sent: Thursday, January 23, 2003 10:30 AM To: '[EMAIL PROTECTED]' Subject: RE: [KCFusion] Encrypted URL and JS this would be the result using ron's advice. A HREF="" ', \', all)#')Click here/A -Original Message- From: Keith Purtell [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 23, 2003 10:12 AM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] Encrypted URL and JS I may have to attempt Bryan's idea or something else. Here's why. The actual source code of this dynamic page contains no quote marks in the encrypted link. However IE is interpreting the URLEncodedFormat and then finding characters that generate a _javascript_ error. Ron if I want to use your idea I'll need to use _javascript_ to escape the quote marks. Not too difficult but more complicated that I originally planned. 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 Ron Hornbaker Sent: Wednesday, January 22, 2003 7:19 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] Encrypted URL and JS Check for embedded single quotes - since that's your JS delimiter, you'll need to escape them by replacing all of them with \' couplets. -Ron -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Keith Purtell Sent: Wednesday, January 22, 2003 5:48 PM To: KCFusion (E-mail) Subject: [KCFusion] Encrypted URL and JS I'm trying to encrypt a URL. The problem is I keep getting JS error Unterminated String Constant when I click the hyperlink that is supposed to call the window. This worked fine before I started trying to protect the file path by encrypting. Here is a snippet of my code ... cfset string = /dirone/dirtwo/filename.pdf cfset key = alpha123 cfset encrypted = URLEncodedFormat(Encrypt(string, key)) CFOUTPUT A HREF=""> Click here/A /CFOUTPUT Did some research and only found one vague reference at the Macromedia web forums. That person supposedly solved this problem by using an obsolete CF function.
[KCFusion] way off topic
If I wanted to set an environment variable in UNIX called JAVA_HOME to jakarta-tomcat-4.0 what would that look like. I keep getting told that im not using the setenv command correctly. A.