CF Default Mapping

2001-12-23 Thread Jim McAtee
What is the CF-created mapping of \ used for? I generally move CFIDE and, if installed, CFDOCS, to a directory other than the root web directory. Should this mapping then be changed point to the parent directory of CFIDE? On a production server that I've been running for about a month, I hadn't

Re: CF Default Mapping

2001-12-23 Thread Jennifer Larkin
At 01:23 AM 12/23/01 -0700, you wrote: What is the CF-created mapping of \ used for? I generally move CFIDE and, if installed, CFDOCS, to a directory other than the root web directory. Should this mapping then be changed point to the parent directory of CFIDE? On a production server that I've

Re: How do I handle Large Record Sets from the DB? (o8i)

2001-12-23 Thread Jennifer Larkin
At 07:34 PM 12/21/01 -0500, you wrote: All, This is what our environment looks like: Microsoft IIS5 on Windows2000 ColdFusion (4.5.1 SP2) Enterprise Edition Oracle8i (8.1.7) Utilizing the Oracle Native Driver. The Task at hand: Users will be quering the database and in some cases receiving back

RE: OT: VNC vs PC Anywhere

2001-12-23 Thread Mike Kear
I am in the process of migrating some of my sites from a host using SQLServer 7 to another hosting company that has SQL2000.I still need to keep the SQL7 going till everything's moved and tested, but I also need to set up on the SQL2000 and do development work there. But my SQL7 EM

Re: CF Default Mapping

2001-12-23 Thread Jim McAtee
I did a search through the CFIDE and CFDOCS directories for use of the mapping (which is usually a cfinclude template=/...) and found a couple of instances in CFDOCS, but none in the CFIDE. It appears that CF expects / to be mapped to the parent directory of CFDOCS and CFIDE. On a machine

SQL7 and SQL2000 on the same machine - how?

2001-12-23 Thread Mike Kear
Oops! Forgot to put a proper subject line in my last message .. here's the same one again I am in the process of migrating some of my sites from a host using SQLServer 7 to another hosting company that has SQL2000.I still need to keep the SQL7 going till everything's moved and

Re: OT: VNC vs PC Anywhere

2001-12-23 Thread Wjreichard
You should be able to do all your work with query analyzer. EM is nice and easy, but you should be able to enter all SQL/TSQL you need ... and the 2000 variant of QA has a nice view objects function. Cheers, Bill __ Get Your

Re: Stored procedures for queries

2001-12-23 Thread Wjreichard
MS-SQL Stored procedures are stored with their 'compiled' execution plan. If you issue a query from an application, SQL Server has to determine the execution plan before running ... determine which indices there are and which one(s) would be the best to use. So if you use SPs you could gain

re: SQL7 and SQL2000 on the same machine - how?

2001-12-23 Thread Mike Kear
The trouble with query analyser is you can't see what is set up. If something doesn't work, you cant see what the table names are and what th e field names and descriptions are. You're working in the dark all the tim e You can't set up users, permissions, views, only pass SQL queries. But I

Re: Dynamic Site Map

2001-12-23 Thread Matt Robertson
For the site map, are you looking to create a map based on content thats dynamic in the first place? Is it a tree-type structure where all the files have a stored ID and a ParentID field (of some kind) in each record? If yes, I have a couple of ways to do that. 1: build it on the fly,

Re: general question about naming conventions

2001-12-23 Thread Dick Applebaum
Mark You'll get a lot of differing opinions on this subject... here are my preferences: 1) Name the table, itself, as singular - makes the SQL statements more readable (English-like) Event instead of Events, Category instead of Categories, etc. 3) Make the column names as concise and

Re: What datasources does CF5 need?

2001-12-23 Thread Douglas Brown
No they are not part of the documentation, they are mearly example applications and unless you plan on studying those example apps, they are not neded. Doug - Original Message - From: Jim McAtee [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, December 22, 2001 11:55 PM

RE: SQL7 and SQL2000 on the same machine - how?

2001-12-23 Thread Dave Watts
But my SQL7 EM (enterprise manager) doesn't work with SQL2000. I can install MSDE from my Office2000 CD, but when I do it says I have EM installed and it is not allowed. I could use Access, but that has different table structures and datatype names and the SQL is different. I'd rather

RE: Allaire Partner upgrades...

2001-12-23 Thread Dave Watts
Honestly my goal was not to get the software, my goal has been met actually, got people talking about it. That goal seems unworthy of your time and effort. What consensus have we all reached about the Partner program? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202)

Re: Allaire Partner upgrades...

2001-12-23 Thread Bryan Stevenson
Well the goal was sort of worthythe squeaky wheel gets the oil and all that ;-) I still think the program is worth the money even though nobody ever likes to get less stuff for more money. I'm sure it's just MM's way of trying to stop everybody from using NFR software for development

RE: SQL7 and SQL2000 on the same machine - how?

2001-12-23 Thread Mike Kear
The problem here is that I'm moving 20 domains from a SQL7 machine to a SQL2000 machine on a different hosting company. I have 20 domains to mov e and I can't move them all instantly. For some weeks I'm going to have to work with both. And my major client has SQL7 and isn't going to upgrade

Re: Stored procedures for queries

2001-12-23 Thread Freddy
I agree with this in most cases. However it is not currently possible to cache oracle stored procs in cf (except by assigning the results to session or application variables). Also on most simple selects I found that the time for processing was faster using embedded cf queries that calling a

RE: SQL7 and SQL2000 on the same machine - how?

2001-12-23 Thread Bud
On 12/24/01, Mike Kear penned: The problem here is that I'm moving 20 domains from a SQL7 machine to a SQL2000 machine on a different hosting company. I have 20 domains to mov e and I can't move them all instantly. For some weeks I'm going to have to work with both. And my major client has

Re: SQL Question

2001-12-23 Thread Bud
On 12/22/01, Gonzo Rock penned: You are SOOO Right... It did NOT put it in my example... BUT... It is in my table design. (I hate when I screw up in email like that! It really complicates this process.) My delima is given a TravH_ID, create a list of all the OP Records related to the related