RE: Client vars won't go into the db....?

2004-02-05 Thread Stefan Salzbrunn
Hi Evan,

Does your cfapplication tag for this app (probably in application.cfm)
specify something else? You can ovveride the default storage there.

Stefan

 -Original Message-
 From: Evan Lavidor [mailto:[EMAIL PROTECTED] 
 Sent: Thursday, February 05, 2004 11:16
 To: CF-Talk
 Subject: Re:Client vars won't go into the db?
 
 ...and a as followup, client variables on our MX servers are 
 also showing up in the registry, even though we've got the 
 settings in CF Admin specifying the default location being a 
 datasource.
 
 Any help is greatly appreciated. 
 
 Thanks, 
 
 Evan

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: IIS Headaches

2004-02-02 Thread Stefan Salzbrunn
Also make sure that the Account used for anonymous access has the correct
rights to all directories you are using... This might include the coldfusion
dirs.

Stefan

Dr. Stefan Salzbrunn
Geschftsfhrer

InterLake - The Web Enabler
FriedrichshafenMnchenBerlinNew York

InterLake Informationssysteme GmbH
Postfach 2269
D-88012 Friedrichshafen
Tel 0800 555 1010 (Intl.+49 89 53886562)
Fax 0800 555 1011 (Intl.+49 89 53886573)
E-Mail [EMAIL PROTECTED]
www.interlake.netwww.moremx.comwww.shadomx.com


 -Original Message-
 From: David Keevil [mailto:[EMAIL PROTECTED] 
 Sent: Monday, February 02, 2004 14:20
 To: CF-Talk
 Subject: OT: IIS Headaches
 
 Just finished a routine installation of IIS under WINXP-PRO 
 but the results are anything but routine. Any attempt to 
 access anything under http://127.0.0.1/ from the local 
 machine triggers a Windows login prompt for a Username  
 Password. Any help in resolving this issue would be much 
 appreciated. TIA.

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Pause/Stop/Restart Scheduler in CFMX

2004-01-30 Thread Stefan Salzbrunn
Does anyone know how to Pause/Stop/Restart the Scheduler in CFMX on Windows
without having to Pause/Stop/Restart the CFMX Application service?

Thanks,

Stefan


Dr. Stefan Salzbrunn
Geschftsfhrer

InterLake - The Web Enabler
FriedrichshafenMnchenBerlinNew York

InterLake Informationssysteme GmbH
Postfach 2269
D-88012 Friedrichshafen
Tel 0800 555 1010 (Intl.+49 89 53886562)
Fax 0800 555 1011 (Intl.+49 89 53886573)
E-Mail [EMAIL PROTECTED]
www.interlake.netwww.moremx.comwww.shadomx.com

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Calendar query?

2004-01-29 Thread Stefan Salzbrunn
Hi Hatton,

What works is to JOIN with a table that has all the dates for your range in
it, it will just display NULLs for the days that you don’t have any matching
records.

If you do not have such a table in your database, create a temp table on the
fly...

This should work in SQL Server (notice the ## for cfquery)

cfquery datasource=#datasoruce# name=TEST
CREATE TABLE ##tc(calendar_date smalldatetime)
DECLARE @dummy smalldatetime
SET @dummy='1/1/2004'
WHILE @dummy  '3/1/2004'
BEGIN
	INSERT ##tc VALUES (@dummy)
	SET @dummy=DATEADD(day,1,@dummy)
END

SELECT ##tc.calendar_date, e.ID, e.event_name
FROM ##tc LEFT JOIN events e ON ##tc.calendar_date = e.event_date

DROP TABLE ##tc
/cfquery 

Hope that helps,

Stefan


Dr. Stefan Salzbrunn
Geschftsfhrer

InterLake - The Web Enabler
FriedrichshafenMnchenBerlinNew York

InterLake Informationssysteme GmbH
Postfach 2269
D-88012 Friedrichshafen
Tel 0800 555 1010 (Intl.+49 89 53886562)
Fax 0800 555 1011 (Intl.+49 89 53886573)
E-Mail [EMAIL PROTECTED]
www.interlake.netwww.moremx.comwww.shadomx.com
 

 -Original Message-
 From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED] 
 Sent: Thursday, January 29, 2004 11:33
 To: CF-Talk
 Subject: Calendar query?
 
 Does anyone know of a way to create a query with a range of 
 dates and any
 matching records that might match in a database in one query? 
For example,
 if I'm looking at a table that has the following:
 
 ID | Date | Event
 ---++---
1 | 01/01/2004 | New Years Day
2 | 02/14/2004 | Valentine's Day
3 | 01/26/2004 | Mom's Birthday
4 | 02/04/2004 | Doctor's Appointment
 
 Say I wanted to show all of the days between 01/15/2004 and 
 02/15/2004 along
 with any matching events in the database.Is there a way to 
 do this with
 one query?So far the only two ways that I can see doing it 
 otherwise is to
 loop through the date range and perform individual queries... 
 Which IMO is a
 little inefficient.
 
 Any ideas?
 
 Thanks!
 Hatton
 
 ---
 Outgoing mail is certified Virus Free.
 Checked by AVG anti-virus system (http://www.grisoft.com).
 Version: 6.0.572 / Virus Database: 362 - Release Date: 1/27/2004

 

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




CFMX Bug with setdomaincookie?

2003-02-17 Thread Stefan Salzbrunn
OK, we think this is a bug, but we would ike to verify:

On coldfusionmx on iis, with multiple websites. Put the following code
in a directory in the application.cfm

cfapplication name=test 
   sessionmanagement=yes
   setdomaincookies=yes
   sessiontimeout=#CreateTimeSpan(0,0,30,0)#
   clientmanagement=YES



Now, if you call the page, the domaincookie does not get set. In fact,
the server tries to set a cookie for another domain in another IIS
website? Very strange. Any insight appreciated...


Thanks,

Stefan

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4




CFMX Bug with setdomaincookie?

2003-02-17 Thread salzbrunn
By the way, this can be viewed here:
http://www.interlake.net/testdomaincookie.cfm

This page does a CFHTTP call to http://www.interlake.net/domaincookie/index.cfm and 
dumps the cfhttp

strange...look at the cookie
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4




Running ColdFusion MX as specific user

2002-09-30 Thread Stefan Salzbrunn

This is a multi-part message in MIME format.

--_=_NextPart_001_01C2688A.86A48660
Content-Type: text/plain;
charset=US-ASCII
Content-Transfer-Encoding: quoted-printable

I am trying to get ColdFusion MX to run under a specifi user account. As
long as that user is a memeber of the administrator group, it seems to
run fine. In CF5 you had to set specific access rights on the registry
and the file system as described in KB 11859, however we cannot find out
how to set those rights in MX.
=20
Does anyone have any idea which specific rights on registry and/or user
rights for the Win2K user account are necessary to run the service under
non-administrative user account? Are there any drawbacks with this
approach? Generally we like to run services with as little rights as
necessary under secure live-environments.
=20
Thanks,
=20
Stefan
=20
=20

--_=_NextPart_001_01C2688A.86A48660
Content-Type: text/html;
charset=US-ASCII
Content-Transfer-Encoding: quoted-printable

!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN
HTMLHEADTITLEMessage/TITLE
META http-equiv=3DContent-Type content=3Dtext/html; =
charset=3Dus-ascii
META content=3DMSHTML 6.00.2800.1106 name=3DGENERATOR/HEAD
BODY
DIVSPAN class=3D022234813-30092002FONT face=3DArial size=3D2I am =
trying to get=20
ColdFusion MX to run under a specifi user account. As long as that user =
is a=20
memeber of the administrator group, it seems to run fine. In CF5 you had =
to set=20
specific access rights on the registry and the file system as described =
in KB=20
11859, however we cannot find out how to set those rights in=20
MX./FONT/SPAN/DIV
DIVSPAN class=3D022234813-30092002FONT face=3DArial=20
size=3D2/FONT/SPANnbsp;/DIV
DIVSPAN class=3D022234813-30092002FONT face=3DArial size=3D2Does =
anyone have any=20
idea which specific rights on registry and/or user rights for the Win2K =
user=20
account are necessary to run the service under non-administrative user =
account?=20
Are there any drawbacks with this approach? Generally we like to run =
services=20
with as little rights as necessary under secure=20
live-environments./FONT/SPAN/DIV
DIVSPAN class=3D022234813-30092002FONT face=3DArial=20
size=3D2/FONT/SPANnbsp;/DIV
DIVSPAN class=3D022234813-30092002FONT face=3DArial=20
size=3D2Thanks,/FONT/SPAN/DIV
DIVSPAN class=3D022234813-30092002FONT face=3DArial=20
size=3D2/FONT/SPANnbsp;/DIV
DIVSPAN class=3D022234813-30092002FONT face=3DArial=20
size=3D2Stefan/FONT/SPAN/DIV
DIVSPAN class=3D022234813-30092002FONT face=3DArial=20
size=3D2/FONT/SPANnbsp;/DIV
DIVSPAN class=3D022234813-30092002/SPANnbsp;/DIV/BODY/HTML
=00
--_=_NextPart_001_01C2688A.86A48660--
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



copy verity collections

2002-07-21 Thread Stefan Salzbrunn

Hello list,
 
is it possible to index verity collections on a WIN2K box and then copy
them to a linux machine and use them?
 
Thanks,
 
Stefan

__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists