RE: Left Outer Join Question

Kamie, The results you are getting make perfect sense. The LEFT JOINS return NULL values where there is no match in the right-side table. COUNT is treating NULL as a value and incrementing your output column for each and every row. Instead of using COUNT, redo this using SUM with CASE

RE: MS SQL 7/2k File Size

One way: execute the stored procedure 'master.sp_databases'--returns database_size as total of both database and transaction log in KB for each database--on SQL 2000. Glenn -Original Message- From: Chris Sinkwitz [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 11:36 AM To:

RE: accessing Cf session variables on same server from another vi rtual domain

Right. Didn't look at his urls closely enough. I guess he could: 1) Use www.thevirtualcompany.com and secure.thevirtualcompany.com; or 2) Pass CFID/CFTOKEN along as url variables as suggested by another reply, if the two urls are on the same box. -Original Message- From: Dave Watts

RE: Regexp

What about something like this: cfset invalidchars = [!@`;:'%,##\*\?\$\^\] !--- invalidate certain characters --- CFSET tempstring = REReplace(tempstring,invalidchars,,ALL) Glenn Olsen Doceus -Original Message- From: Bruce, Rodney [mailto:[EMAIL

RE: Casting Object in CF

(objGregCal.getTime()); // and now I have a Date object to work with, etc. /cfscript HTH, Glenn Olsen Doceus -Original Message- From: Michael S. Kimmett [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 15, 2001 4:19 PM To: CF-Talk Subject: Re: Casting Object in CF Thanks

cfobject question

be desirable. Maybe this isn't possible in any simple sense, but maybe someone has done something like this with CF Schedule or something. Any ideas are appreciated. Thanks, Glenn Olsen www.doceus.com ~~ Structure your ColdFusion code with Fusebox

RE: SQL SERVER 7

Since you want to send data back and forth at the db level (sproc), look in SQL Server Books OnLine, 'linked servers, configuring'. You can setup a linked server via Enterprise Manager or the system sproc sp_addlinkedservers. Since these are 2 SQL boxes, that part is relatively straightfoward.

RE: SQL help

Try ... DECLARE @MRID int SET @MRID = (SELECT MIN(ID) AS MRID FROM HomePageReleases) DELETE HomePageReleases WHERE ID = @MRID -Original Message- From: S R [mailto:[EMAIL PROTECTED]] Sent: Monday, July 30, 2001 5:02 PM To: CF-Talk Subject: SQL help I'm trying to get this sql