WinXP, SQL Server MSDE, CFMX ... did fine with a 31k file. Did you set up the table for the client variables storage yourself? Or did you let the CF admin page do it? I let the admin page do it and here is the DDL for the CDATA table ... maybe you can verify that the table is set up correctly? Not a SQL Server user so I have no clue what most of it means .. ;^)
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CDATA]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[CDATA] GO CREATE TABLE [dbo].[CDATA] ( [cfid] [char] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [app] [char] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [data] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO Dan -----Original Message----- From: Brook Davies [mailto:[EMAIL PROTECTED]] Sent: Friday, August 09, 2002 12:17 PM To: CF-Talk Subject: CFMX and client variables Can somebody/anybody please try this on a CFMX installation within an application which is defined to use a MSSQL7.0 datasource for client variables storage. If some one can confirm that this works for them, then I can continue to look for other reasons other than a MX related issue. <!--- set this to a file that weighs approx 20k ---> <cfset myfile="f:\inetpub\wwwroot\development\mlmsites.txt"> <cffile action="read" file="#myfile#" variable="tempVar"> Setting client variable myTestVar.. <cfset client.myTestVar=tempVar> ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
