[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.

**

Cold Fusion Web Developer/Programmer:

Nations is a rapidly growing private company based in Kansas City (Prairie Village), 
with 66 locations nationwide.  Primary business focuses on serving local and national 
lending institutions through title, closing, and related services.

Nations has a significant infrastructure of custom web-based applications for internal 
(employee) and external (customer/vendor) operations and continues to evolve in that 
direction.  Web development utilizes ColdFusion MX and FuseBox in conjunction with SQL 
Server 2000.

Our growth has resulted in additional needs in the areas of ColdFusion and SQL 
development.  Qualified individuals will have 2+ years experience developing 
ColdFusion applications and/or complex SQL development.  FuseBox experience is a plus.

Please send resume and salary history to [EMAIL PROTECTED]


Jerry Siscoe
Nations Technical Services
Prairie Village, KS
[EMAIL PROTECTED]



__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/[EMAIL PROTECTED]
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]



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 this list.  If you really don't want all 
the emails, you can go to the web log of this list.


-Original Message-
From: Fatino, Henry K [ITS] [mailto:[EMAIL PROTECTED]
Sent: Friday, August 29, 2003 2:37 PM
To: [EMAIL PROTECTED]
Subject: RE: [KCFusion] Wednesday Meeting - 2nd location available, in
Ove rland Park!


SECOND THAT


-Original Message-
From: Glenn Crocker [mailto:[EMAIL PROTECTED]
Sent: Friday, August 29, 2003 1:26 PM
To: [EMAIL PROTECTED]
Subject: RE: [KCFusion] Wednesday Meeting - 2nd location available, in
Ove rland Park!



Okay, the RSVP emails have officially gotten annoying.  Can this list be reconfigured 
so responses go to the sender instead of the whole list?

-glenn


 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
 Behalf Of Schappaugh, Cheri
 Sent: Friday, August 29, 2003 12:37 PM
 To: '[EMAIL PROTECTED]'
 Subject: RE: [KCFusion] Wednesday Meeting - 2nd location available, in
 Ove rland Park!
 
 
 Cheri Schappaugh
 attending Overland Park location..rsvp
 
 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
 Sent: Friday, August 29, 2003 12:20 PM
 To: [EMAIL PROTECTED]
 Subject: [KCFusion] Wednesday Meeting - 2nd location available, in
 Overland Park!
 
 
 
 Due to popular demand, we are making a 2nd location available for
 Wednesday's meeting.
 
 Centriq Solutions (centriq.com) and Thinq Digital (www.thinqdigital, an MM
 Authorized Trainer) will be hosting the Overland Park meeting at 7950
 College Boulevard.  
 
 Our first location at UMKC will still be used (5150 Oak).
 
 
 You should plan on arriving between 5:30 and 5:45.  The big presentation
 starts at 6pm and is scheduled for 90 minutes with QA to follow (then the
 raffle for a copy of Studio MX 2004!).  Pizza  coke will be available at
 both locations.
 
 
 Please RSVP (even if you have done so already) and let us know which
 location you plan on attending.  We have capacity for a little about 45 in
 OP and 55 at UMKC.  We have close to 50 reservations so far.  RSVP to
 [EMAIL PROTECTED]  or  [EMAIL PROTECTED]
 
 Please check www.kcfusion.com on Saturday and AGAIN on Wednesday for
 directions and additional information.  The site will be updated 
 tonight to
 reflect the 2nd location.
 
 
 We are in need of the following: 
 
 2 projectors as backups (1 per location)
 large speakers or sound system for OP
 volunteers to man the registration tables at both locations
 corporate sponsors are always welcome
 speakers for future meetings for each user group
 
 Please let me know if you can assist.
 
 Thanks,
 Ryan, [EMAIL PROTECTED]
 
 
 --
 This meeting is being sponsored and brought to you by:
 
 KC ColdFusion User Group  Ryan Hartwich
 KC Macromedia Multimedia User Group  Charmaine Keller-Hodges
 Ron Ramphal with UMKC
 Centriq Solutions
 Michael Faulkner with Thinq Digital
 Printing by Russell Walker @ StudioXS
 Software Donations by Macromedia
 Prior assistance  hosting by
   DistributorCentral
   Greensoft Solutions
   Humankind Systems
   Sprint
 
 
 
 
  
  
 __
 The KCFusion.org list and website is hosted by Humankind Systems, Inc.
 List Archives http://www.mail-archive.com/[EMAIL PROTECTED]
 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 7800 College Boulevard,
 2nd Floor, Overland Park, Kansas, 66210, USA. 
 
 
  
  
 __
 The KCFusion.org list and website is hosted by Humankind Systems, Inc.
 List Archives http://www.mail-archive.com/[EMAIL PROTECTED]
 Questions, Comments or Glowing Praise.. 

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 PROTECTED]Subject: 
RE: [KCFusion] security question

  I 
  don't know of a way to say make IE send different request headers, but if 
  you're trying to test something, wouldn't cfpost work?
  
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]On Behalf Of Adaryl 
WakefieldSent: Monday, August 11, 2003 1:44 PMTo: 
[EMAIL PROTECTED]Subject: [KCFusion] security 
question
Is is possible to alter the information that is 
sent in the headers of a POST request?
A.


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 could 
manually review the deletes before committing any of them. That's my 2 
cents.

Kory

  -Original Message-From: Adaryl Wakefield 
  [mailto:[EMAIL PROTECTED]Sent: Tuesday, August 12, 2003 10:48 
  AMTo: [EMAIL PROTECTED]Subject: Re: [KCFusion] 
  security question
  Im sorry I was in a hurry and should have 
  explained this better. For the first time I am faced with allowing users to 
  delete info from a database. I am trying to come up with a save method for 
  doing that. In other words I don't want people to just type random numbers in 
  a query string and start erasing stuff. Most of the measures I have come up 
  with so far are easily defeated. I had considered putting the primary key of 
  the tuple to be deleted ina hidden form field but if you can alter the 
  info sent in a post request (and I think I read somewhere that you could) then 
  that measure is kinda lame too. the best I've got so far is that the user can 
  only delete those tuples that are related to their login.
  A.
  
- Original Message - 
From: 
Bruce Dunwiddie 
To: [EMAIL PROTECTED] 
Sent: Tuesday, August 12, 2003 11:33 
AM
Subject: RE: [KCFusion] security 
question

I 
don't know of a way to say make IE send different request headers, but if 
you're trying to test something, wouldn't cfpost work?

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On 
  Behalf Of Adaryl WakefieldSent: Monday, August 11, 2003 
  1:44 PMTo: [EMAIL PROTECTED]Subject: 
  [KCFusion] security question
  Is is possible to alter the information that 
  is sent in the headers of a POST request?
  A.


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]
Cc: [EMAIL PROTECTED]
Subject: [KCFusion] ColdFusion File Security


All:

   I hope you can provide me some guidance on the following issue and
especially if my web host tech support is incorrect.

   I've run into an interesting security problem with ColdFusion.  I am
the web master for STFM.org
 
   We have protected various directories using our web hosts file
permission interface on the control panel for our web site.  For several
directories we have set the user Everyone access to none for that
directory and any files/sub directories in the directory.
 
   However, after moving to our new CF MX server, I noticed that the CF
files in our protected directories are being served up even though the
directory is protected (I checked to ensure it was still protected after
the move).  If you try to load a non-CF file (for example test.htm) that
is located in the same protected directory, the server requests you
provide a user name and password before it returns the file to your
computer.  The server does not do this with the CF file, it just returns
the file.
 
   According to a phone conversation I had with one of our web host's
tech support personnel late on 1 August, CF files are not protected by
the file permissions settings on the Windows server since the CF MX
server bypasses the web server to return the files to the browser.  

   However, after consulting another very experienced ColdFusion
Developer and checking the ColdFusion MX documentation (see
http://download.macromedia.com/pub/coldfusion/documentation/cfmx_dev_cf_apps.pdf
page 353) I've learned that basic HTTP authentication should protect CF
files.  I believe that the information I was given by the support
technician to be incorrect.  Removing the user Everyone's access in some
of our sub-directories should also protect the CF files in those sub
directories.  

Any information on your experience in using basic http authentication to
protect CF files in a directory from being served up with the user
entering a password and username would be appreciated.  I really think
the tech support is incorrect and there is some other problem on the web
server.

I don't want to use CFLOGIN or some other application login script if I
don't have to.


 
Thank You,
 
Bruce
 





Bruce Phillips
Society of Teachers of Family Medicine
913-906-6000 ext 5405
[EMAIL PROTECTED]

 
 
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/[EMAIL PROTECTED]
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/[EMAIL PROTECTED]
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[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 '#DateAdd('d',7,createODBCDate(now()))#'

  -Original Message-From: Robert 
  [mailto:[EMAIL PROTECTED]Sent: Friday, August 01, 2003 11:03 
  PMTo: [EMAIL PROTECTED]Subject: [KCFusion] DateDiff 
  in SQL Query
  I am running into a problem and I can't figure 
  out why. I know i've had this problem before with using CF functions 
  inside of SQL queries, but I can never remember what it was the last time that 
  fixed it, so I wanted to post this query:
  
  CFQUERY name="getcustomers" 
  DATASOURCE="x"SELECT CustomerName, CustomerPin, 
  CustomerRefer,CustomerEnrollmentDateFROM 
  CustomersWHERE CustomerRefer = 
  #Affiliate_ID#AND 
  #DateDiff("w",'#CreateODBCDate(CustomerEnrollmentDate)#','#CreateODBCDate(now())#')# 
  = 0/CFQUERY
  I'm needing to run stats for affiliate programs 
  and so I want a daily, weekly, monthly view. Datediff in T-SQL didn't 
  seem to be able to do anything other than generic day, month, etc. 
  Anyhow, I get the following error:
  
  Error 
  resolving parameter CUSTOMERENROLLMENTDATE
  
  Obviously I 
  have the right name, but it bombs right there...if I change around my quotes 
  and my pound signs, it'll say it's Missing a parameter, Expected 1 or Expected 
  2. Anyone easily point out what i've got in the wrong place or what I am 
  messing up because i'm at a loss. BTW, Affiliate_ID is from another 
  CFOUTPUT from a query that this is all running inside of.
  
  Thanks,
  Robert


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 "NULL"

  -Original Message-From: Adaryl Wakefield 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, July 30, 2003 10:40 
  AMTo: [EMAIL PROTECTED]Subject: [KCFusion] 
  
  I have need to update a table and set a value to 
  NULL like
  
  UPDATE blah
  SET thisAttribute = nullValueHere
  WHERE someStuff = someOtherStuff
  
  so far I've tried 
  cfset var = ""
  and
  cfset var = "NULL"
  
  and some other things but so far nothing. Anybody 
  know right off the bat where I'm going wrong?
  A.


[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]



__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/[EMAIL PROTECTED]
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]



RE: [KCFusion] Version Control Evaluation

2003-06-18 Thread Kory Bakken
Title: RE: [KCFusion] Version Control Evaluation



From 
what I understood from the CVS documentation, each developer would check out a 
version of their site before development began. I assume this would mean 
that each developer would have to havea web server,CF server, 
andaccess to each of his datasources on his client. Additionally, 
like Glenn stated, a developer could have a document checked out for long 
periods of time before checking it back in, causing problems with parallel 
development. I am correct in these assumptions?

-Kory

-Original Message-From: 
Glenn Crocker [mailto:[EMAIL PROTECTED]Sent: Wednesday, June 18, 2003 
1:27 PMTo: [EMAIL PROTECTED]Subject: RE: [KCFusion] 
Version Control Evaluation

  It 
  doesn't seamlessly integrate with CF Studio (or with DW MX, to my 
  knowledge). It just manages the files externally using a separate 
  check-in/check-out application.
  
  CVS 
  doesn't use a file locking model. Instead, it does a very very good job 
  of merging changes made in parallel. If folks check their changes in 
  regularly, CVS does very well. (If people go for months without 
  committing their changes, their checkin process will take a while and they may 
  have to manually handle merge conflicts.)
  
  Visual SourceSafe may be a better option for what you 
  want.
  
  -glenn
  
  
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]On Behalf Of Bryan 
LaPlanteSent: Wednesday, June 18, 2003 10:45 AMTo: 
[EMAIL PROTECTED]Subject: Re: [KCFusion] Version Control 
Evaluation
Does CVS integrate with CFStudio? Also CVS is 
version control but there does not seem to be the concept of check out where 
the file is locked by the current owner.

  - Original Message - 
  From: 
  Boles, Mark E 
  To: [EMAIL PROTECTED] 
  Sent: Wednesday, June 18, 2003 10:35 
  AM
  Subject: RE: [KCFusion] Version 
  Control Evaluation
  
  I have also been very pleased with CVS. 
  -Original Message- From: 
  Glenn Crocker [mailto:[EMAIL PROTECTED]] 
  Sent: Wednesday, June 18, 2003 10:44 AM To: [EMAIL PROTECTED] 
  Subject: RE: [KCFusion] Version Control Evaluation 
  
  I use CVS and like it. Works well for distributed 
  projects where team members aren't on a 
  LAN. 
  -glenn 
   -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 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] 
  __ 
   The KCFusion.org list and website is hosted by 
  Humankind Systems, Inc.  List Archives 
  http://www.mail-archive.com/[EMAIL PROTECTED] 
   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/[EMAIL PROTECTED] 
  Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] 
  To Subscribe mailto:[EMAIL PROTECTED] 
  To Unsubscribe mailto:[EMAIL PROTECTED] 
   



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 logged in. This would cause sessions to timeout after very 
short periods of time.

So, my point is...if your users are 
utilizing the same proxy server, check those settings.

-Original 
Message-From: Bruce Phillips 
[mailto:[EMAIL PROTECTED]Sent: Tuesday, June 17, 2003 1:36 
PMTo: [EMAIL PROTECTED]Subject: RE: [KCFusion] 
Unexpected Loss of Session Variables

  Thanks for the quick reply. We are on a shared host. The 
  hosting company has the timeout set to 20 minutes and we cannot adjust 
  that. However, session variables are being lost before the 20 minute 
  period (sometimes very quickly 1-2 minutes).
  
  bruce
  
  Bruce PhillipsSociety of Teachers of Family Medicine913-906-6000 
  ext 5405[EMAIL PROTECTED] 
  [EMAIL PROTECTED] 06/17/03 01:25PM 
  If you're using IIS on your server, take a 
  look at the timeout on it. That has bit me before. Also make sure the time out 
  on the cf server is what you want it to be.
  
-Original 
Message-From: Bruce Phillips 
[mailto:[EMAIL PROTECTED]Sent: Tuesday, June 17, 2003 1:11 
PMTo: [EMAIL PROTECTED]Subject: [KCFusion] 
Unexpected Loss of Session Variables
Hello. I'm the new webmaster for stfm.org. Our website uses 
ColdFusion5.0 as its web programming language. I'm originally a 
Java Programmer(JavaServerPages), so I've had to learn CFML quickly 
(thanks to BenForte's books).Our web site is hosted on a 
shared server (crystaltech.com).We are experiencing unexpected 
loss of some or all session variablesfor about 20% of our users. 
The session variables are lost well beforethe 20 minute timeout 
limit.We use session variables to maintain user input across 
approximately3-4 data entry pages (page numbers vary based upon specific 
category). Our session variables are set and read inside of cflock tags 
perColdFusion best practices.The problem appears to worsen 
when we have more users on our site, butthe number of users is not that 
significant (less than 20-30 per hour). This is a shared server, but I 
don't know the overall load on theserver.I've reseached 
your listserver but did not find any material on 
thissubject.
From my research on Macromedia's forum, the loss of session 
variablesappears to be a problem with ColdFusion 5. We are 
considering changing our host plan to ColdFusion MX, though some of our 
applications will need recoding since they use attributes no longer 
supported in ColdFusion MX.

I'd certainly appreciate any advice from more experienced ColdFusion 
developers who may have encountered and solved this problem.

Thank You,

Bruce


Bruce PhillipsSociety of Teachers of Family 
Medicine913-906-6000 ext 5405[EMAIL PROTECTED]


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 Showing 
  Service(913) 754-1023 [EMAIL PROTECTED]


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 match the column widths of the first table 
absolutely.  This should solve both of your problems by rendering enough content 
quickly while matching the bottom records up format-wise with the top.

Kory

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: Thursday, April 03, 2003 11:28 PM
To: [EMAIL PROTECTED]
Subject: RE: [KCFusion] Rendering large HTML tables



I think that IE  Netscape both wait until an entire table is loaded in
html to render it.  One way around this, assuming you need to have your
data in a table, is to come up with a way to start and stop your table.  If
you can use a counter in your loop that generates the table, for each tr,
add one to the counter, then, have an if statement in the loop that does a
cfif counter mod 50 eq 0/tabletable/cfif.  This will make multiple
tables on your page, but I believe the first one will render while the rest
are loading into the browser.

Also, if you are using CFMX (and CF5?), you can use the cfflow or similar
tag to dump your server process to the client.  You may be able to do this
if the server side generation takes a long time too.


Ryan




mail2web - Check your email from the web at
http://mail2web.com/ .


 
 
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/[EMAIL PROTECTED]
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/[EMAIL PROTECTED]
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]



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 
Person
 FROM 
Table
 WHERE 
Category = #i#
 
/cfquery
 cfoutput 
query="qry_people"
 
#qry_people.Person#
 
/cfoutput
/cfloop

  -Original Message-From: Adaryl Wakefield 
  [mailto:[EMAIL PROTECTED]Sent: Friday, March 28, 2003 11:57 
  AMTo: [EMAIL PROTECTED]Subject: [KCFusion] query 
  output (OT)
  Is this even possible? I need to display data 
  from a query thusly:
  Category1
  Person1
  Person2
  Person3
  Category2
  Person1
  Person2
  Person3
  I used the group attribute of the output tag but 
  that only spit out 1 record.
  Without the group attribute I get
  Category1
  Person1
  Category1
  Person2
  ...
  Which is what I expect, just not what I 
  need.
  A.


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="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 
  Person
   FROM 
  Table
   WHERE 
  Category = #i#
   
  /cfquery
   cfoutput 
  query="qry_people"
   
  #qry_people.Person#
   
  /cfoutput
  /cfloop
  
-Original Message-From: Adaryl Wakefield 
[mailto:[EMAIL PROTECTED]Sent: Friday, March 28, 2003 11:57 
AMTo: [EMAIL PROTECTED]Subject: [KCFusion] query 
output (OT)
Is this even possible? I need to display data 
from a query thusly:
Category1
Person1
Person2
Person3
Category2
Person1
Person2
Person3
I used the group attribute of the output tag 
but that only spit out 1 record.
Without the group attribute I get
Category1
Person1
Category1
Person2
...
Which is what I expect, just not what I 
need.
A.


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, March 21, 2003 11:10 AM
To: KCFusion (E-mail)
Subject: [KCFusion] Database issue on development laptop


I'm setting up a Windows2000 laptop with CF developer version to work on a project 
while at home.
The problem is, this project normally interacts with an MSSQL database only available 
inside our
network. I need it to work at home without being connected to the internet, and it 
doesn't matter if
I'm using the real data. The only changes I'm planning are in the CF application 
templates. Is there
some quick way to duplicate the database setup without installing MSSQL on the laptop? 
Maybe have
MSSQL output the relevant databases in some other format that I can load on the 
laptop? I've never
attempted this before, so I'm open to suggestions.

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.

---
[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/[EMAIL PROTECTED]
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/[EMAIL PROTECTED]
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]