[KCFusion] ColdFusion and SQL Developer Opportunities

2003-10-08 Thread Kory Bakken
FYI: Nations Holding Company currently has an openings for ColdFusion and SQL developer positions. Please see the attached posting. If you are interested, please reply to Jerry Siscoe (mailto:[EMAIL PROTECTED]). Please do not post replies to this list.

RE: [KCFusion] Wednesday Meeting - 2nd location available, in Ove rland Park!

2003-08-29 Thread Kory Bakken
As annoying as the RSVPs are (people should know how to reply directly to the sender), I do not believe it would not be a good idea to reply only to the original sender. Everybody on here has learned a few things from reading the responses to other people's issues. That is why we subscribe to

RE: [KCFusion] security question

2003-08-14 Thread Kory Bakken
Are you asking how this can be done, or just whether this can be done?Are you trying to alter your data, or just assure a customer that their data is safe? -Original Message-From: Bruce Dunwiddie [mailto:[EMAIL PROTECTED]Sent: Tuesday, August 12, 2003 11:34 AMTo: [EMAIL

RE: [KCFusion] security question

2003-08-14 Thread Kory Bakken
Adaryl: Yes,if a person has IEBoster (http://www.paessler.com/IEB)running on their machine, hidden form fields are just a right-click away. You'd be better off putting a "ACTIVE" field in any table that you are going to allow users to delete from. That could inactivate the record, then you

RE: [KCFusion] ColdFusion File Security

2003-08-04 Thread Kory Bakken
Bruce: I am just guessing, but is it maybe that the files that you need to protect are the *.class files that MX produces and not the *.cfm files? Kory Bakken -Original Message- From: Bruce Phillips [mailto:[EMAIL PROTECTED] Sent: Friday, August 01, 2003 8:11 PM To: [EMAIL PROTECTED

RE: [KCFusion] DateDiff in SQL Query

2003-08-04 Thread Kory Bakken
You cannot treat CustomerEnrollmentDateas a CF Variable until you are outside of that query. The following where clause should get you what you need: WHERE CustomerRefer = #Affiliate_ID#AND CustomerEnrollmentDate between '#DateAdd('d',-7,createODBCDate(now()))#' and

RE: [KCFusion]

2003-07-30 Thread Kory Bakken
If you do not use stored procedures, you could do this: UPDATE blah SET thisAttribute =cfif isdefined('var')#var#cfelseNULL/cfif WHERE someStuff = someOtherStuff The problem you had is that it reads: cfset var = "" as and empty string and cfset var = "NULL" as the actual string

[KCFusion] Version Control Evaluation

2003-06-18 Thread Kory Bakken
Has anybody out there ever done a formal evaluation of version control products for use with Coldfusion? If so would you care to share your results? Kory Bakken Nations Technical Services Prairie Village, KS [EMAIL PROTECTED

RE: [KCFusion] Version Control Evaluation

2003-06-18 Thread Kory Bakken
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Kory Bakken Sent: Wednesday, June 18, 2003 9:57 AM To: [EMAIL PROTECTED] Subject: [KCFusion] Version Control EvaluationHas anybody out there ever done a formal

RE: [KCFusion] Unexpected Loss of Session Variables

2003-06-17 Thread Kory Bakken
This may be completely useless but... I do not remember howour web administratorresolved this, but in my last job we had this problem. It stemmed from users that use the same proxy server in an intranet environment. A new user would reset the session variables of any user previously

RE: [KCFusion] Cold Fusion

2003-05-27 Thread Kory Bakken
#right(trim(variablename),2)# -Original Message-From: lance [mailto:[EMAIL PROTECTED]Sent: Tuesday, May 27, 2003 4:07 PMTo: [EMAIL PROTECTED]Subject: [KCFusion] Cold Fusion What is the best way to get the last 2 char. in a variable? Lance W. BoykinCentralized

RE: [KCFusion] Rendering large HTML tables

2003-04-04 Thread Kory Bakken
Instead of breaking the output into infinite multiple tables, you could pull the first 50 records into one table, cfflush, then pull all other records into the next, regardless of size. The first table could use relative sizing on the columns, but use JavaScript to resize the second table to

RE: [KCFusion] query output (OT)

2003-03-28 Thread Kory Bakken
Try this... cfquery datasource="dsn" name="qry_categories" SELECTCategory FROM Table WHERE ... /cfquery cfset listCategories = QuotedValueList(qry_categories.Category) cfloop list="listCategories" index="i" cfoutput #i#br /cfoutput cfquery datasource="dsn" name="qry_people" SELECT

RE: [KCFusion] query output (OT)

2003-03-28 Thread Kory Bakken
Sorry, you need to make sure that the qry_categories specifies a DISTINCT category. -Original Message-From: Kory Bakken Sent: Friday, March 28, 2003 12:56 PMTo: [EMAIL PROTECTED]Subject: RE: [KCFusion] query output (OT) Try this... cfquery datasource=&quo

RE: [KCFusion] Database issue on development laptop

2003-03-21 Thread Kory Bakken
You can use SQL Server 2000 Personal edition to duplicate your DB structure on your desktop. For more info, see: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_sa2_9gz4.asp -Original Message- From: Keith Purtell [mailto:[EMAIL PROTECTED] Sent: Friday,