Export hidden columns to excel

[Rahul Krishna]

I'm creating a report for my company where the user has the option to expand or 
collapse the column headers and its data on their screen.

The users want to export the report to an excel spreadsheet and they want the 
spreadsheet's columns to mirror what is displayed on his/her screen.  

So if the user has certain columns collapsed or expanded on their screen they 
want those columns hidden or displayed on the spreadsheet as well.

I was wondering how difficult it would be to create a function in Coldfusion MX 
7 which will allow the users to unhide those collapsed columns in the excel 
spreadsheet without having to go back to the screen and do another export 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303213
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Installing CF4.5 SP 1

[Rahul]

Service pack is meant for overwriting the orginal files with the upgraded
one. U can go ahead we have already done it & working fine.

Rahul

- Original Message -
From: Jacob Ezzell <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Thursday, November 09, 2000 3:16 AM
Subject: Installing CF4.5 SP 1


> Has anyone installed SP1 on their server?  We were all ready to, but it
> looks like it will completly over-write the installation instead of
> upgrading it.  Any input?
>
> Jacob Ezzell
>
> --
--
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
a message with 'unsubscribe' in the body to
[EMAIL PROTECTED]
>


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

Re: RDS stopped working

[Rahul Joshi]

Seems u r using CF studio. Correct ... coz u can use RDS through CF studio
as well as through normal windows explorer. Once u install CF Studio it adds
1 option in explorer i.e. Allaire FTP & RDS. Now on CF server PC check RDS
service is started on not ? If not then pls start the service. Now open
explorer click on Allaire FTP, right click on this option. It will provide u
2 options add rds server & add ftp server, so select add RDS server. Now
give host description as anything u want, in host name field give IP address
of RDS server PC i.e.. CF Server PC, in user name field give the user name
administrator & give password which u have given for CF Studio in CF Server
administrator page.

With this settings it should work.

Rahul




>
> I can't for the life of me think how to check that it SHOULD be... the
> server handles CF pages quite happily, but since it's running all sorts of
> things, I don't want to run SQL Enterprise Manager on it, thus I'll rather
> use RDS to update databases and stuff
>
> I've been through the Administrator, but can't find anything (apart from
the
> Studio Password) regarding RDS
>
> I'm pulling my hair out - Especially since we only recently upgraded 4.0.1
> to 4.5.1, so I don't know the Administrator very well...
>
> In the words of Penelope Pitstop... "Haylp Haylp" (or however it's spelt
the
> way she says it)
>
> Philip Arnold
> ASP Multimedia Limited
> T: +44 (0)20 8680 1133
>
> "Websites for the real world"
>
> **
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the system manager.
> **
>
>
> --

> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: URgent CFServer maxing CPU and JIT error on Production Server.

[Rahul Joshi]

Just try by removing sp6a & installing sp5. Also if doesn't work remove MDAC
2.5 & install the original 2.3 which comes with CF Server.



Rahul


> The environment is NT4, SP6a, CF4.51 Enterprise, 99% Access db's, MDAC
2.5,
> IIS4.0
>
> The code was working totally error free on the previous machine before
> moving.
>
> Regards,
> Dave
> 
> Dave Wilson
> Internet Technology Manager
> 
>
> BizNet Solutions
> 
> Lisburn Road
> Belfast
>
> email: [EMAIL PROTECTED]
> web: http://www.biznet-solutions.com
>
> --

> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Problem with CF Service

[Rahul]

Login by admin & pls apply SP5 & then try.



 Main Hoon rahul
 naam To Suna Hoga 
- Original Message -
From: Stefan Gudmundsson <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 26, 2000 3:46 PM
Subject: Problem with CF Service


Hi.
We experience two problems on a NT server that are connected to the CF
server service.
- First the machine won´t shutdown properly if we don´t stop the service
first
- The other problem is that we can´t start for example a installation
program without
first stopping the service.

We run NT 4.0 (lots of RAM), CF 4.5 PRO.

Anyone has an idea?

\Stefan Gudmundsson

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=sts&body=sts/cf_talk or send
a message to [EMAIL PROTECTED] with 'unsubscribe' in the
body.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: CFMail stops processing

[Rahul]

Pls give permission to System Group from NT Security to Cfusion\mail
directory.


Rahul


 Main Hoon rahul
 naam To Suna Hoga 
- Original Message -
From: John Fix 3rd <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 25, 2000 12:53 AM
Subject: CFMail stops processing


> I recently install Allaire Forums, and the email notifications seem to be
> getting "stuck" in the cfusion/mail/spool directory about once per day.
It
> seems to occur when I get an invalid email message (address that has a bad
> domain, etc.) Once the mail moves to the /undelivr folder, I use the
> CFX_RETRY tag to resubmit the files periodically.
>
> When the file gets moved BACK into the /spool directory, CF seems to lock
on
> it.  If I try and delete the file, I get a sharing violation.  If I stop
and
> start CF, CF locks again on that mail file.  If I stop, delete the file,
and
> restart CF, then the rest of the mail file go through.
>
> Running CF 4.5 on Windows NT 4 any ideas?
>
> Thanks!
>
> John
> www.cornells.com
>
> --

> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: HELP: CF Server not working

[Rahul]

If you are using database server in backend pls check connectivity with
database server. Also check the DSN configured in CF admin , means verify
the DSN. Check the log of server in CF admin where you will come to know
which file is not responding for CF server request. Is it happening to all
files in your site to a specific page ??


rahul



> Error Diagnostic Information
> The time taken to process your request has exceeded the allowable limit of
> 1800 seconds. Please notify the server administrator (using the mail link
> below) that this error has occurred.
> Note: You can override the request time limit by adding a 'RequestTimeout'
> parameter to the URL used to request the page (e.g.
> page.cfm?RequestTimeout=500).
>
>
>
> --

> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Urgent! CF Server 4.5 Response is Very Slow

[Rahul]

lue (add if not already there):

DWORD LogFileBatchSize set to 0x0004

This specifies the batch size for writing log files. The server caches the
last LogFileBatchSize bytes of data in memory buffers before it dumps the
current buffer and moves onto the next buffer. Such batch processing reduces
the amount of disk traffic created by log files. However, if a site is
interested in getting the current-up-to-date log records flushed to disk,
the batch size can be reduced. The value range for this setting is 0 -
0x, and the default is 64*1024 (64KB) or 0x0001. Consider
increasing this value to 256*1024 (256KB) or 0x0004.

In IIS Manager:


Set IIS Performance set to handle over 100,000 hits per day
Removed all IIS mappings except .CFM
Set Logging - "Next Log Time Period" = "When file size reaches 100 MB"
Remove all unnecessary ISAPI filters


We also recommend that users place their webserver root directory and all
swap space on a separate physical disk from the core OS and other system
files if at all possible. If not, place on separate partitions on the same
disk. This will decrease system file-swapping problems on the main drive,
helping performance and stability.




ColdFusion ClusterCATS Settings

The registry settings which control CFAS load reporting are listed below. It
is recommended to set LoadRate to 1, which causes ColdFusion to report load
to BrightTiger ClusterCATS every second, reducing the lag time between when
load is experienced and when load is reported. In
\\HKLM\Software\Allaire\ColdFusion\CurrentVersion\Server:

LoadTraceFile - 0 or 1
LoadSamples - 5 is default
LoadRate - 2 is default
LoadConstant - 50 is default


3. Move pagefile from system partition to boot partition.

Try out the above settings, it will definately improve cf4.5 performance.

Rahul


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: SQL Server logins

[Rahul]

Yes u r correct, if u are trying to restore a database from one server to
other server & even if u have same logins this problem do occur. So pls use
SQL query to solve this problem. run the following query on that affected
database :

"EXEC sp_change_users_login 'Update_One', 'User_Name', 'User_Name' " ...
ok ...

Do try this, surely this will solve your problem 

Rahul

 Main Hoon rahul
 naam To Suna Hoga 

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: IIS not recognizing .cfml extension

[Rahul]

Have u reinstalled CF server after installing IIS ? If no them pls do it so
that CF server installation will add all ISAPI extentions to IIS. & if u
want to mannually add it then pls refer to the same document in allaire's
support site.

rahul

- Original Message -
From: Eric Bradburn <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, May 23, 2000 6:16 PM
Subject: IIS not recognizing .cfml extension


> Hi, All
>
> I have encountered an issue with displaying pages with the .cfml setting
> in IIS. I was able to do it previously with netscape server. I have set
> the extension type to use the same .dll as .cfm files use but I get a
> 404 when I type in search.cfml. The odd thing is if I type in
> search.cfml and I have a file in the directory named search.cfm then it
> will display. Any help would be appreciated.
>
> Thanks,
> Eric Bradburn
>
> --

> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: The right CF server setting

[Rahul]

Instead of SP6a use SP5 or sp4 .. otherwie overall config looks good. try to
increase RAM from 128 to 256 if possible.

rahul

- Original Message -
From: vincy <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, May 01, 2000 2:12 PM
Subject: The right CF server setting


> hi,
> what is the right environment to run the CF server ??
> I've got :
> CF enterprise server 4.5
> NT 4 (SP6a)
> SQL 7
>
> On an Netfinity PIII with 128MB
>
> is this ok ? are there any more patches to put in ??
>
> vince
>
> --

> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Mail spool not sending

[Rahul]

have u give system permission to the mail directory. ( if u r using NT )
coz i faced same problem with MS exchange as mail server .. mails were just
getting spooled. Then I found I have not given permission to NT system to
mail directory in cfusion.

rahul

- Original Message -
From: Webmaster <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 18, 2000 7:36 PM
Subject: Mail spool not sending


> I'm sending out a bunch of newsletters using . The mails get
dumped
> into the spool but at that point they just sit there. Every couple minutes
> about a hundred of them get sent. I've been sending newsletters for
several
> months and haven't had this problem before (the spool always emptied very
> quickly). Any ideas of what could cause this problem?
> I'm using IMail mail server and that seems to be running correctly.
>
> Neil Peaslee
> Developer
> SMTnet
>
> --

> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: "Not enough disk space"

[Rahul]

Check out u have implemented disk quota software ? or u have proper
permissions on it ...


- Original Message -
From: Ing. Luis J. Ramirez Flores <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 18, 2000 6:27 AM
Subject: "Not enough disk space"


> I'm installing ColFusion Server 4.0 Eval version, and i have a message
> during the installation, this:"Not enough disk space", but we have enough
> space on disk, could some one help to me? I'm trying to install on a
> different directory c:\cfusion , that is: d:\Program Files\Cfusion ...is
this a
> problem? I use NT 4.0
>
>
> ==
> IMPRESION EXPRESS  Tel.(8)363-0888  Fax(8) 363-7199
> Ave. Real San Agustin #222 - H3E-mail: [EMAIL PROTECTED]
> Residencial San Agustinhttp://www.avantel.net/~iexpress/
> Garza Garcia, N.L.  MEXICO
> --

> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

can anybody Pls explain the reasons for the error messages ?

[Rahul]

This is a multi-part message in MIME format.

--=_NextPart_000_0005_01BFC02F.AEDF2A00
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Below are the erros I am getting in the Server log of cf 4.5 server :

1. "Error","TID=3D191","05/06/00","10:08:38","Windows NT error number =
109 occurred."
"Error","TID=3D191","05/06/00","10:16:16","Error number 232 occurred =
while attempting to write the reply to the web server."

2. "Error","TID=3D189","05/10/00","14:26:18","Windows NT error number =
109 occurred."


Rahul

--=_NextPart_000_0005_01BFC02F.AEDF2A00
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable








Below are the erros I am getting in the =
Server log=20
of cf 4.5 server :
 
1. =
"Error","TID=3D191","05/06/00","10:08:38","Windows=20
NT error number 109 =
occurred.""Error","TID=3D191","05/06/00","10:16:16","Error=20
number 232 occurred while attempting to write the reply to the web=20
server."
 
2. =
"Error","TID=3D189","05/10/00","14:26:18","Windows=20
NT error number 109 occurred."
 
 
Rahul

--=_NextPart_000_0005_01BFC02F.AEDF2A00--

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: My Personal Machine at home.

[Rahul]

Add RDS server in studio & then check up the same 
Give user name ( by which u login ) & give password ( which is given if cf
server for cf studio ) .. it should work ...

- Original Message -
From: Stanford, Nathan <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 26, 2000 9:05 PM
Subject: My Personal Machine at home.


> I am having a problem... I hope this is not a repeat...
>
> I have my datasources working correctly but when I go into studio I am not
> able to connect to my local machine but my pages are working just fine.
It
> says that the cf server is not started.
>
> HELP I WANT MY ODBC CONNECTIONS BACK...
>
>
> Thanks to those who help!
>
> Nathan
> --

> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Tuning the webserver?

[Rahul]

which web server u are using ? also r u tring this pages on online or
offline ? coz it can be the link problem also ?

- Original Message -
From: Pete Freitag <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 26, 2000 12:43 PM
Subject: RE: Tuning the webserver?


> http://www.microsoft.com/backstage/whitepaper.htm
>
> ___
> Pete Freitag
> CFDEV.COM
> Cold Fusion Developer Resources
> http://www.cfdev.com/
>
> -Original Message-
> From: Steve Goldenberg [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 25, 2000 12:04 PM
> To: [EMAIL PROTECTED]
> Subject: Tuning the webserver?
>
>
> Dear CF-ers,
>
> My web application has been running sluggish lately, but don't see any
> problems reported with the CF or database server. The pages just take a
long
> time to download - could it be the web server? Is there a good reference
out
> there for tuning IIS on NT?
>
> -Steve Goldenberg
> Interfolio.com
> 4300 Old Dominion Dr.
> Suite 901
> Arlington, VA 22207
> p: 703.522.4004
> f: 209.315.7319
>
> --
--
> --
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
>
> --

> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Basic datasource question

[Rahul]

In case of DSN for 6.5 u have to give security information like user name &
password .. it will be user name = sa & password = whatever u have given for
sa ...
BTW u r creating this dsn in cf or through control panel -odbc  ??

- Original Message -
From: R Navaneethan <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, April 24, 2000 3:31 PM
Subject: Basic datasource question


> I am trying to create datasource for SQL Server 6.5
> database (default Master database). I try with
> following details:
> DSN Name: test
> Server  : Sales
> Database: Master
>
> Any other settings necessary to set the dsn?
>
> Also, please give the syntax for "Host string" to
> create DSN for Oracle 8.0 with native driver.
>
> Thanks,
> naveen
>
>
> __
> Do You Yahoo!?
> Send online invitations with Yahoo! Invites.
> http://invites.yahoo.com
> --

> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Windows NT error number 109 occurred

[Rahul]

My CF server's log is also full with error 109. ... As per my opinion I am
getting this request coz of Licensing problem with me NT installation or may
be coz my users are writing some stupid pages which keeps on waiting for
system reply i.e. reply from WWW server  this is what my thinking .. I
am going to try this on a proper licensed NT installation ...Then will come
to know whats the exact problem ...

- Original Message -
> following.
> example:
> "Error","TID=238","04/09/00","23:11:18","Windows NT error number 109
> occurred."
> "Error","TID=239","04/10/00","07:35:05","Unable to write reply -- client
> browser stopped waiting for request. "
>
> In conjunction with this error I noticed that one of my scripts fails when
> it needs to write like above. The page gives me this error
>
> Request canceled or ignored by serverServer busy or unable to fulfill
> request. The server is unable to fulfill your request due to extremely
high
> traffic or an unexpected internal error. Please attempt your request again
> (if you are repeatedly unsuccessful you should notify the site
> administrator). (Location Code: 26)
>
>
> Anybody experience this? I am running IIS4 and CF4.5.1 on a Dual PIII450
> w/512MB of RAM
>
> Thanks for any info you can shine on this.. I have been searching
Microsofts
> site but not turning up anything yet..
>
> Brian Silvers
> [EMAIL PROTECTED]
>
> X-Net Web Systems   ColdFusion, CGI's, Dynamic Content
> http://www.x-net.com Flash, Database Integration,  and more!
>
>
> --

> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: "Only Anonymous" Security on IIS problem

[Rahul]

R u using MSDN version of NT ? In the Instead of default Anonymous account
created by IIS use some other account which have administrator previlage.


- Original Message -
From: Mark Zukiwsky <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 20, 2000 1:17 AM
Subject: "Only Anonymous" Security on IIS problem


> Hi all,
>
> I have a CF-powered training application that runs on a company
> intranet. The company just installed CF 4.5 Pro yesterday, and we're
> having problems when accessing .cfm pages with "only anonymous"
> directory settings. Requests using .htm pages are processed.
>
> The following error is generated by the browser:
> 
> HTTP Error 401
> 401.3 Unauthorized: Unauthorized due to ACL on resource
>
> This error indicates that the credentials passed by the client do not have
> access to the particular resource on the server. This resource could be
> either the page or file listed in the address line of the client, or it
> could be another file on the server that is needed to process the file
> listed on the address line of the client.
> 
>
> FWIW, the training application is Macromedia Director based and sends
> http requests to the CF server then parses the results. Since the
> application can't authenticate, it needs "only anonymous" directory
> settings for the server.
>
> I use PWS/CF4.01 on Windows 98 and I'm not at familiar with IIS or
> NT, so I'm kind of in the dark, and CF is brand new for this
> particular company. I have the training application running
> successfully on my CF host and on intranets at other companies, but
> this is the first CF 4.5 installation, and again CF is brand new for
> the company. Usually, the people I work with are CF experts.
>
> If you reply could you cc me as I'm on digest.
>
> Thanks in advance.
>
> Mark Zukiwsky
> Edmonton, Canada
>
> --

> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: CF-SQL7 Error

[Rahul Joshi]

check up the dll file of cfquery tag .. also check up the os dlls.

- Original Message -
From: Internet Marketing Corporation <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 12, 2000 7:42 PM
Subject: OT: CF-SQL7 Error


> Hi, everybody...
>
> I get the following error message trying to run a CF (4.0) query on an
SQL7
> database. It is on our test machine which is running *both* CF and SQL7.
I've
> done several Access-SQL ports but never encountered this. It seems to
happen
> with any query that I run against this database. And, yes, the database
seems
> properly installed and verified by CF! The Access database, of course,
runs
> fine!
>
> Thanks in advance...
>
> Veronica
>
> Error Occurred While Processing Request
> Error Diagnostic InformationCMemoryException: unknown cause
> PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag The error occurred
while
> processing an element with a general identifier of (CFQUERY), occupying
> document position (20:1) to (20:37). Date/Time: 04/12/00 10:03:38
> Browser: Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt)
> Remote Address: 127.0.0.1
> HTTP Referer:
>
http://127.0.0.1//IMC001_WWWRoot/NewEroto/HTML/MENU.cfm?UID=2412100325&A
> RS=3&ARN=3&ARP=3&ARV=0
> Template: C:\Inetpub\wwwroot\IMC001_WWWRoot\NewEroto\HTML\SHOW0.cfm
> Query String:
> search_type=0&ShowID=A001S01&UID=2412100325&ARS=3&ARN=3&ARP=3&ARV=0
>
>
> --

> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: What goes on the faster machine?

[Rahul Joshi]

For cf server u will require a PIII PC with good IO system, say Raid 5 with
Ultra II SCSI controller. Coz CF requiresplenty of RAM & Pentium range
procesor to work well. SQL will also require plenty of RAM, fantastic
processor & fantastic IO system. This will improve performance of your web
application provided that u have good network bandwidth.
Also it depends what kind of  web application u have. If u have static
application which will just retreive record from SQL & show to client then u
will not require a powerfull processor for both CF as well as SQL, but if u
have dynamic site then u should have powerfull PCs. U can get better
information for hardware config on IBM or Compaq site.


- Original Message -
From: Joy Bedell <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, April 09, 2000 9:00 AM
Subject: What goes on the faster machine?


> We are finally making the move from Access to SQL Server.  Right now we
> have both Access and ColdFusion running on the same machine.  However,
with
> our upgrade we are going to put SQL Server on one machine and ColdFusion
on
> another.  My question is, which one should go on the faster machine, CF or
> SQL Server?
>
> Any other advice anyone would care to offer would be appreciated.  Thanks.
>
> Joy
>
> --

> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: nt reboot

[Rahul Joshi]

try out utilities on download.com or cnet.com . Such utilities are available
over which can reboot your PC on the scheduled time.

- Original Message -
From: Kirk Boecker <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 06, 2000 3:20 AM
Subject: nt reboot


> please help,
>
> I need some assistance with setting up a task to reboot our NT servers
once
> each day. Our internal NT admin/Network Support stinks and if they do not
> know how to do something they say it can't be done.
>
> I know many of you have this type of thing setup on your servers - any
> pointers would be greatly appreciated
>
> kirk
>
> --

> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: QUICK OT HELP - please =).

[Rahul Joshi]

Whats the os ? NT workstation or server ? whats the file system FAT or NTFS
? by which user u r logged on ? Normal user or administrator. which browser
is default on the laptop ?
Login by administrator goto explorer & try to share it for network for
administrator & everyone full control. Same for Security with subfolders.
Rahul

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Speed of CFMAIL

[Rahul Joshi]

It depends on many factors such as the mail server, speed of mail server,
network speed .. Spped of the server on which CF server as well as your mail
server is running .. but it works very well .. I am using it for internal
network .. I have received 7000 mails in an hour through my application
which is in CF 

- Original Message -
From: Chris Evans <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 05, 2000 6:37 PM
Subject: Speed of CFMAIL


> Has anybody done any speed tests to determine how many emails CFMAIL can
> send in an hour?
>
>
> Chris Evans
> [EMAIL PROTECTED]
> http://www.fuseware.com
>
>
> --

> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: dual processor

[Rahul Joshi]

In asymmetric it distributes load as per requirement ... i.e. 1st processor
will get loaded fully & then 2nd processor .. & in symmetric one processor
will take system tasks load & 2d processor application load u define ... So
its always better to have symmetric processing for cf 

- Original Message -
From: Tariq Ahmed <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 05, 2000 3:21 AM
Subject: dual processor


>
>
> I noticed someone talking about NT server being able to run in
> symetric or asymetric mode.
>
> Which would be the better for handling high CF load?
>
>
>   Tariq Ahmed - [EMAIL PROTECTED] - ICQ 6308515
>  TIBCO Finance Technology - Web Group - Senior Web Engineer
>  Work: 650-461-3472   Pager: 800-759-x1702632   Fax: 650-461-3003
>  3375 Hillview Avenue. Palo Alto, CA. 94304.
>
> --

> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Database and server on two different domains

[Rahul Joshi]

does your SQL server use NT security or SQL security ... if its using NT
security then pls establish trust relationship between both domains 

- Original Message -
From: Mark Jones <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, April 04, 2000 8:14 PM
Subject: Database and server on two different domains


> I have a database on one domain and the coldfusion server on another.  We
> are having problems getting the coldfusion server to connect to the
> database.  The ODBC link is set up fine but the coldfusion server does not
> seem to want to connect to the database.
>
> Does anyone have any suggestions?
>
> Thanks in advance,
>
> Mark Jones
> [EMAIL PROTECTED] 
>
> --

> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Increased CPUload

[Rahul Joshi]

While installing 2nd processor ,

- Original Message -
From: Holger Lockertsen <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, April 04, 2000 5:55 PM
Subject: RE: Increased CPUload


> NT.
>
> Umm... where do you select processing?
>
> HL
>
> -----Original Message-
> From: Rahul Joshi [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 04, 2000 1:29 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Increased CPUload
>
>
> Whats the OS ? If NT then what kind of processing u have selected ?
> Symmetric or Asymmetric .
>
> - Original Message -
> From: Holger Lockertsen <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, April 04, 2000 4:36 PM
> Subject: Increased CPUload
>
>
> > We are running CF on a dual processor Intel-machine.
> >
> > I finally upgraded from 4.01 to 4.5 and everything seemed to work
nicely,
> > but we have experienced a dramatic increase in CPU-load by the cfserver.
> >
> > Does anyone know of any issues with this?
> >
> > * Holger Lockertsen, Solutions Developer, Horisont Information Systems
AS
> > * Nedre Slottsgate 5, N-0157 OSLO, Noreg/Norway
> > * 23 31 03 04 / 91 83 20 51
> > * [EMAIL PROTECTED]   http://www.horisont.no/
> >
> >
>
> --
> 
> > Archives: http://www.eGroups.com/list/cf-talk
> > To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> >
>
> --
--
> --
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
>
>
> --

> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Increased CPUload

[Rahul Joshi]

Whats the OS ? If NT then what kind of processing u have selected ?
Symmetric or Asymmetric .

- Original Message -
From: Holger Lockertsen <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, April 04, 2000 4:36 PM
Subject: Increased CPUload


> We are running CF on a dual processor Intel-machine.
>
> I finally upgraded from 4.01 to 4.5 and everything seemed to work nicely,
> but we have experienced a dramatic increase in CPU-load by the cfserver.
>
> Does anyone know of any issues with this?
>
> * Holger Lockertsen, Solutions Developer, Horisont Information Systems AS
> * Nedre Slottsgate 5, N-0157 OSLO, Noreg/Norway
> * 23 31 03 04 / 91 83 20 51
> * [EMAIL PROTECTED]   http://www.horisont.no/
>
>
> --

> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Shutdown problem w/ cfexec.exe

[Rahul Joshi]

Seems some query is making cf server unresponsive  check out all the
queries ... first stop & restart CFide service & then try for cf server 

- Original Message -
From: Bud <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, March 31, 2000 7:14 AM
Subject: Shutdown problem w/ cfexec.exe


> Hi. Whenever I try and shut down or restart my new server, I get an
> error that ceexec.exe won't stop. I click End Task, and wait a couple
> minutes and try again. Same thing. I've tried to go into Services to
> Sto CF and it won't let me because it says the machine is shutting
> down. About 3 or 4 tries later, it finally goes down.
>
> CF 4.01, NT 4.0, Service Pack 5.
>
> Any clues?
>
> Thanks.
>
> Bud Schneehagen - Tropical Web Creations
>
> _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
> ColdFusion Solutions / eCommerce Development
> [EMAIL PROTECTED]
> http://www.twcreations.com/
> 954.721.3452
> --

> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Virtual Memory Errors

[Rahul Joshi]

Whats the error ? Are u using Windows NT 4.0 ? If yes then check the size of
virtual memory .. Initial size should be RAM + 12 MB & end size should be 50
to 60 MB higher side than Initial size. If pagefile.sys is on system
partition then move it to other partition than System. If this works then
fine. If not then check up the event viewer for any Service Control manager
wrror. Also check RAM of your server.  If u can afford Uninstall &
reinstalltion of CF server then pls do it. But be sure that u r giving the
location of installation other than original one.
Check whether .DLL of any tag is creating problem.

rahul
- Original Message -
From: Erik Nachbahr <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 29, 2000 7:23 PM
Subject: Virtual Memory Errors


> Greetings all:
>
> My CF (4.0) Server is getting Virtual Memory Errors. I noticed that when
> this happens, all of the CF Sites seem to crap out - it doesn't seem to be
> effecting the html sites. Another thing I noticed is that when this
happens
> (it is happening about every 2 days), the CF .exe is only using about 200K
> of memory (it usually uses about 35MB). Rebooting the server fixes all.
Has
> anyone ever heard of this???!!!
>
> Erik
> --

> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: CFMail issues

[Rahul Joshi]

Check out the dll for CFmail TAG & if needed replace it with fresh copy ..

- Original Message -
From: John Tierney <[EMAIL PROTECTED]>
To: Cf-Talk@Houseoffusion. Com <[EMAIL PROTECTED]>
Sent: Wednesday, March 29, 2000 12:30 AM
Subject: CFMail issues


> Hi,
> Im having weirdness using cfmail on our installation on NT
> I get this error:
> unknown exception condition
>
> TagCFMail::sendMessage
>
>  The error occurred while processing an element with a general identifier
of
> (CFMAIL), occupying document position (9:1) to (9:105) in the template
file
>
> Has anyone seen this?
>
>
>
>
> John J. Tierney
> Web Application Developer &
> Information Artist
> Dreamscape Online LLC.
> 315.437.4166
> http://www.dreamscape.com
>
>
> --

> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Excel Workbook/Worksheet as Datasource

[Rahul Joshi]

Here instead of selecting a prpoer version u can use Excel 8.0 which reads
all excel formats ...

> steps are as below:
> 1. In cf administration odbc option : select microsoft Excel
> driver(*.xls )driver
> 2.add datasource name
> 3. select workbook proper version and create it.
> While using this datasource it creates the tables same as the sheet name.
In
> the sheet if 1st row contains any data that is considered as column name.
> (req. don't give anything in 1st row then by default it takes f1,f2... as
> column names. this is easy to access. If column name are given in 1st row
> then it should not contain any space in name i.e required.Same as SQL
> requirement)
>
> Hope this solves your problem.
>
> - Original Message -
> From: David E. Crawford <[EMAIL PROTECTED]>
> To: CF-Talk <[EMAIL PROTECTED]>
> Sent: Tuesday, March 28, 2000 6:54 PM
> Subject: Excel Workbook/Worksheet as Datasource
>
>
> > I realize this may have already been discussed, but as usual, I didn't
> need
> > to know how to do it then, because we weren't using.  Flashforward to
> today.
> > Can someone give me a short explanation of the steps required to setup
an
> > Excel workbook/worksheet as a datasource, specifically in terms of the
> > format that the spreadsheet must be in?
> >
> > Thanks.
> >
> > Dave
> > ---
> > David E. Crawford
> > Director, Internet Development
> > Yale Security Group, Inc.
> > www.yalesecurity.com
> >
>
> --
> 
> > Archives: http://www.eGroups.com/list/cf-talk
> > To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> >
>
> --

> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.