[KCFusion] ColdFusion and SQL Developer Opportunities
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!
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
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
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
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
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]
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
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
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
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
#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
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)
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)
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
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]