Performance of GetProfileString()

[Teng-Yan Loke]

Hi

I have a UDF that uses GetProfileString to find name-value pairs and this
UDF is called very often in my application. On the average, each page calls
the UDF about 5 times.

Does anyone have any idea how intensive this function is? Does it compare
with CFFILE read, as in loading the entire file into memory? If so, can I
modify my UDF so that the INI file that GetProfileString reads is cached and
then searched against?

Thanks for any help.


Teng-Yan Loke | [EMAIL PROTECTED] | +65-62169727
Developer | novaHEALTH (S) Pte Ltd

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

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

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

RE: alternatives to cfhttp

[Teng-Yan Loke]

If you're on Windows, try the ServerXMLHTTP object.

See:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/xmlsdk30/ht
m/xmobjxmldomserverxmlhttp.asp


Teng-Yan Loke | [EMAIL PROTECTED] | +65-62169727
Developer | novaHEALTH (S) Pte Ltd

> > >>> [EMAIL PROTECTED] 06/03/03 11:23AM >>>
> > anyone know of any reliable alternatives to cfhttp? I am tyring
> to send a
> pretty good sized csv file and it tends to bonk out often..
> (success rate of
> about 60%)...

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com

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

RE: When CFHTTP fails, use WGET

[Teng-Yan Loke]

Hi

> Instead,  I resorted to using WGET from http://www.wget.org
> <http://www.wget.org/> .  This utility has a million parameters and I
> have put the description at the bottom of this report.

I too have been having problems with cfhttp. I downloaded wget and started
tinkering with it.

Windows 2000 commandline invocation works well, but I can't get it to work
in CF code. My code is like this:





The page waits longer than if I were to run wget commandline, and a
zero-byte output file is created. What gives?

Thanx.


Teng-Yan Loke | [EMAIL PROTECTED] | +65-62169727
Developer | novaSPRINT Systems Pte Ltd

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

RE: CFMX and unicode

[Teng-Yan Loke]

Dear folks

My customer requires display of his entire site in simplified chinese.
Currently, the application is running on CF5 and is filled with CFGRID and
CFTREE code, which must display Chinese characters from the Oracle database
too.

Will CFMX satisfy my requirements completely? Thanx.


Teng-Yan Loke | [EMAIL PROTECTED] | +65-62169727
Developer | novaSPRINT Systems Pte Ltd

__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
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

RE: Retrieving most recent record from db

[Teng-Yan Loke]

> 
> SELECT Top 1 * FROM T_EMAIL
> ORDER BY Eid DESC
> 

Assuming this has the same output as:


select * from t_email
order by eid desc


Will the former example yield less load from the DB server than the latter?

----
Teng-Yan Loke | [EMAIL PROTECTED]
Developer | novaSPRINT Systems Pte Ltd
tel: +65-2169727 | fax: +65-3390279
__
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
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

Clustering Performance Experiences

[Teng-Yan Loke]

Hi

I've been cracking my head to improve the performance of certain sections of
my client's site, especially the search page and sitemap page.

The search page uses CF4's Verity, which indexes Spectra 1.0 objects. The
COAPI tags are already slow, compared to custom SQL queries, so updating of
the collection is affected as well.

The sitemap page uses the same COAPI tags and recursive custom tag calling
to build the sitemap tree with .

One possible way to bring down the page executation times of 2 minutes is to
increase the number of CF servers from just one. Has anyone tried clustering
with CF? Any performance measurements to share?

Thanks for any comments.

----
Teng-Yan Loke | [EMAIL PROTECTED]
E-Developer | novaSPRINT Systems Pte Ltd
tel: +65-2169727 | fax: +65-3390279
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.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

RE: Upgrading Windows NT to 2000 CF Effects

[Teng-Yan Loke]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

> I did it on our dev server, had to reinstall CF, which sorted the IIS
> plug in fine.

Since I also have Spectra, this will spell more trouble if I install Win2K,
isn't it?

- 
Loke, Teng-Yan | [EMAIL PROTECTED] | +65-8313547
E-Developer | novaSPRINT.com (S) Pte Ltd

-BEGIN PGP SIGNATURE-
Version: PGPfreeware 6.5.8 for non-commercial use 

iQA/AwUBOx/jdxQsl2B8K+e4EQLsqACfXo7LrRp1TCxK/FKyOjNncf35wAIAoOZD
NPdWDQhjFuvyZrqMrHgUqJXq
=tDrc
-END PGP SIGNATURE-


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Upgrading Windows NT to 2000 CF Effects

[Teng-Yan Loke]

Dear all

Has anyone tried upgrading from NT4 Workstation to 2KPro with CF4.5 and PWS?

I'm concerned with possible problems relating to PWS: IIS may not be
installed; if it is installed, the CF plug-in for PWS will probably be lost.

Any ideas? TIA.


Loke, Teng-Yan | [EMAIL PROTECTED] | +65-8313547
E-Developer | novaSPRINT.com (S) Pte Ltd


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: how do i send an attachment?

[Teng-Yan Loke]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Suppose I want to attach some HTML code that was obtained either from a
database or using CFHTTP, how do I attach it to CFMAIL without having to
save it to a local file first?

Can I pass CFHTTP's CFHTTP.FileContent as the MIMEATTACH parameter value
for CFMAIL?

TIA.

- 
Loke, Teng-Yan | [EMAIL PROTECTED] | +65-8313547
E-Developer | novaSPRINT.com (S) Pte Ltd

-BEGIN PGP SIGNATURE-
Version: PGPfreeware 6.5.8 for non-commercial use 

iQA/AwUBOxV+kxQsl2B8K+e4EQI+dACgqch4ndBLggOrI+teadTl6tIXBnkAn3Gx
6Dm7mgJkJ/gCLi0YvEDQSCTH
=h7Xf
-END PGP SIGNATURE-


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Is it possible to send attach with cfmail ?

[Teng-Yan Loke]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

> Is it possible to send attach with cfmail ?
> for example send email with PDF file, Image file , Word files , Text
> files  

Can I attach a web page?

Maybe I have to do a CFHTTP to save it to a file first, then use MIMEATTACH
to include into the CFMAIL tag.

- 
Loke, Teng-Yan | [EMAIL PROTECTED] | +65-8313547
E-Developer | novaSPRINT.com (S) Pte Ltd

-BEGIN PGP SIGNATURE-
Version: PGPfreeware 6.5.8 for non-commercial use 

iQA/AwUBOwmQuhQsl2B8K+e4EQIk+wCfcM4JmQcA7dBF5/7k+e77hegKkEIAn0iK
UiemZfEbiMnKd1aGv8OTKkxq
=O1Um
-END PGP SIGNATURE-


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Escaping Characters in a SQL Statement

[Teng-Yan Loke]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Dear all

I'm running NT 4 SP5 with CF 4.5.1 SP2, Spectra 1.0.1 and PWS.

If I upgrade to Windows 2000 Professional with IIS 5, are there any
precautions I should be aware of? I tried searching thru this list and
Allaire KB, but found nothing.

Thanx.

- 
Loke, Teng-Yan | [EMAIL PROTECTED] | +65-8313547
E-Developer | novaSPRINT.com (S) Pte Ltd

-BEGIN PGP SIGNATURE-
Version: PGPfreeware 6.5.8 for non-commercial use 

iQA/AwUBOwHLrRQsl2B8K+e4EQI2JQCcDqQYrK7VnZbiOSP+jGQFnMty5n8An2Ey
q8RekWXQPwv+GYRRg9M4nehQ
=UBvw
-END PGP SIGNATURE-


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Escaping Characters in a SQL Statement

[Teng-Yan Loke]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Dear all

I have a column in a table which is of type long. After filtering for a set
of records from this table, I want to write back this column into the
table. This column is known to store HTML code (i.e. web pages). I only
know the following characters have to be escaped: '"/\. How do I write my
SQL update statement such that all the possible nasty characters are
escaped?

Thanx.

- 
Loke, Teng-Yan | [EMAIL PROTECTED] | +65-8313547
E-Developer | novaSPRINT.com (S) Pte Ltd

-BEGIN PGP SIGNATURE-
Version: PGPfreeware 6.5.8 for non-commercial use 

iQA/AwUBOv800RQsl2B8K+e4EQJESwCfZ2SI8q+08PB+uyc0NupPobAqFtMAni1E
ubb4VP+NoPkiASiPK31PhpjD
=WN/5
-END PGP SIGNATURE-


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

REMOTEPATH not read in Distributed CF Mode

[Teng-Yan Loke]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Dear all

I have a web server where the document root is in c:\netscape\server4\docs.
Then, I have the CF server where the document root is in
f:\netscape\server4\docs\www. So, I configured my cfremote.ini on the web
server with these settings:

LOCALPATH="c:\netscape\server4\docs\"
REMOTEPATH="f:\netscape\server4\docs\www"

When I tried to access the site from the web server, it returns a object
not found error. Checking the webserver.log file on the CF server, I found
that CF is trying to look for the CF files in c:\netscape\server4\docs,
when it should be f:\netscape\server4\docs\www.

It seems like the REMOTEPATH setting is not read at all. Instead, the web
server's CF plug-in module just tells the CF server to look for files in
the LOCALPATH.

Any help please? Thanx.

- 
Loke, Teng-Yan | [EMAIL PROTECTED] | +65-8313547
E-Developer | novaSPRINT.com (S) Pte Ltd

-BEGIN PGP SIGNATURE-
Version: PGPfreeware 6.5.8 for non-commercial use 

iQA/AwUBOt31+hQsl2B8K+e4EQKNrgCg5A1ifFpxbiauwcG70Pus/xKF3eQAoIzd
1D18u1iJf9PmrYcAiOyQ5J7m
=K1RF
-END PGP SIGNATURE-


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Concurrent users and client certificates

[Teng-Yan Loke]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Try this:

http://www.cfvault.com/index.cfm/mode/DisplayTutorial/TuUUID/7F4D0522-EC4C-1
1D3-85030050DABEAE1B/Tutorial_Page/1

- 
Loke, Teng-Yan | [EMAIL PROTECTED] | +65-8313547
E-Developer | novaSPRINT.com (S) Pte Ltd

-BEGIN PGP SIGNATURE-
Version: PGPfreeware 6.5.8 for non-commercial use 

iQA/AwUBOstxpRQsl2B8K+e4EQKxnwCeLYN5+KuQcCxOF9tJZpy24Qpzhr0AoKWr
PzJy7lg5fq4GfM+F/Mrbb7th
=R2Wn
-END PGP SIGNATURE-


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

ColdFusion General Forum in Delphi.com

[Teng-Yan Loke]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

I've created an online community called "ColdFusion General Forum". It's
for folks who prefer to use a web-based interface for discussions. Please
join the discussion!

With the message board, you can view discussion folders quickly in the
left-hand column and read up to 20 messages at a time. You can even attach
files (such as pictures and programs) directly to messages -- just like
e-mail. It's fast, easy, and efficient. 

The best way into the forum is at the following URL:
http://www.delphi.com/coldfusion_gen 

You can use the personalized "My Forums" feature at http://myforums.com to
keep track of new messages in this Forum and any others you may enjoy. 

In order to provide personalized services and access control, you'll need
to go through a quick registration if you've never participated in a Delphi
Forums online community before. It only takes a minute and it's free! 

- 
Loke, Teng-Yan | [EMAIL PROTECTED] | +65-8313547
E-Developer | novaSPRINT.com (S) Pte Ltd

-BEGIN PGP SIGNATURE-
Version: PGPfreeware 6.5.8 for non-commercial use 

iQA/AwUBOqWJ8xQsl2B8K+e4EQK8ZwCg19my0YG85oo5Yqig6xWbKTeNPE4AoMRD
ow1i+6sK4r9c4UCbZlYuYs1p
=/Zpz
-END PGP SIGNATURE-


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CFMail - Sending a link in an email

[Teng-Yan Loke]

Well, for me I found that the problem seems to be with the MIME type that is
set by ColdFusion. If memory serves me right, it was "text/html". Somehow,
MS Outlook is not able to treat the e-mail as HTML code, so it displays all
the code. As for most other mail clients that can view HTML mail, they have
no problems displaying mail sent by CF.

Has anyone else seen this?


Loke, Teng-Yan | [EMAIL PROTECTED] | +65-8313547
E-Developer | novaSPRINT.com (S) Pte Ltd


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Encryption of CFML

[Teng-Yan Loke]

Thanks Roger.


Loke, Teng-Yan | [EMAIL PROTECTED] | +65-2169725
E-commerce | novaSPRINT.com (S) Pte Ltd

> -Original Message-
> From: Roger Lim [mailto:[EMAIL PROTECTED]]
> Sent: Monday, February 12, 2001 16:07
> To: CF-Talk
> Subject: Re: Encryption of CFML
> 
> 
> Of course it's possible. Try using CFENCODE, located under the 
> directory of
> ColdFusion/bin
> 
> Regards,
> Roger Lim
> Senior Engineer, Technology
> X-media Pte Ltd
> Tel: (65)796-9500 (Ext. 666)
> Fax: (65)796-9533
> 
> - Original Message -
> From: Teng-Yan Loke <[EMAIL PROTECTED]>
> To: CF-Talk <[EMAIL PROTECTED]>
> Sent: Monday, February 12, 2001 3:48 PM
> Subject: Encryption of CFML
> 
> 
> > Dear all
> >
> > I would like to secure my CF code after deployment on the live 
> server but
> I
> > do not wish to have my code to be vulnerable to copying. Is it 
> possible to
> > encrypt or compile CF code so that it can't be read by humans?
> >
> > Thanks.
> >
> > 
> > Loke, Teng-Yan | [EMAIL PROTECTED] | +65-2169725
> > E-commerce | novaSPRINT.com (S) Pte Ltd
> >
> >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Encryption of CFML

[Teng-Yan Loke]

Dear all

I would like to secure my CF code after deployment on the live server but I
do not wish to have my code to be vulnerable to copying. Is it possible to
encrypt or compile CF code so that it can't be read by humans?

Thanks.


Loke, Teng-Yan | [EMAIL PROTECTED] | +65-2169725
E-commerce | novaSPRINT.com (S) Pte Ltd


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Remoting and Location of CFML Files

[Teng-Yan Loke]

Suppose I have set up a web server (dog) with the CF plug-in for remote CF
processing, and a CF server (cat) with the network listener module running.
LOCALPATH and REMOTEPATH are both set to "c:\inetpub\wwwroot".

Which machine should I place my CFM files? As of now, it seems like they
have to reside on cat, but my HTML and image files can be on the web server.
If this is true, wouldn't it seem confusing when it comes to specifying
paths?


Loke, Teng-Yan | [EMAIL PROTECTED] | +65-2169725
E-commerce | novaSPRINT.com (S) Pte Ltd


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Objects Not Found After Migration of Application

[Teng-Yan Loke]

I've been using Webtop to create objects. Using cfa_contentobjectfind and
setting typeid, stproperties, lpropertiesprecedence, bactiveonly="false",
I'm able to retrieve objects. See code below.

However, when I migrate the application to another Spectra machine, the same
code will not return any objects. I found out that by saving/updating EACH
object of that typeid, I'm able to solve the problem temporarily. Recreating
the objects and migrating to the second machine does not help.

So, will installing the new cfa_objectgetmultiple.cfm help me here?





#StructCount(findUser)#


Loke, Teng-Yan | [EMAIL PROTECTED] | +65-2169725
E-commerce | novaSPRINT.com (S) Pte Ltd


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

URLToken Algorithm

[Teng-Yan Loke]

My client would like to know the algorithm used to generate unique values
and the ranges for CFID and CFTOKEN for session management.

Any help please? Thanx.


Loke, Teng-Yan | [EMAIL PROTECTED] | +65-2169725
E-commerce | novaSPRINT.com (S) Pte Ltd


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists