australian e-com

2000-10-02 Thread avex

Hi australian guys out there...

I want to do a real time Credit Card processing e-com site.

Can you guys suggest any that will easily integrate with Cold Fusion to
accept australian dollars?

thanks
chad


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



Re: australian e-com

2000-10-02 Thread Rob Keniger

on 2000-10-02 5:52 PM, avex at [EMAIL PROTECTED] wrote:

 Hi australian guys out there...
 
 I want to do a real time Credit Card processing e-com site.
 
 Can you guys suggest any that will easily integrate with Cold Fusion to
 accept australian dollars?

You might want to try http://www.xilo.com.au/ - they get a good rap, can
organise Camtech services and have a CFX tag that you can use. It's not
particularly cheap, though.

-- 
 
Rob Keniger

big bang solutions

mailto:[EMAIL PROTECTED]
http://www.bigbang.net.au



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



RE: Getting Outlook information - Success

2000-10-02 Thread seth ward

www.microsoft.com/digitaldashboard

once you've set it up, there are loads of links to provided apps
including the outlook stuff

-Original Message-
From: Jeff Beer [mailto:[EMAIL PROTECTED]]
Sent: 01 October 2000 15:28
To: CF-Talk
Subject: RE: Getting Outlook information - Success


Hi Seth,

I would love to see that code!

Thanks,

Jeff

-Original Message-
From: seth ward [mailto:[EMAIL PROTECTED]]
Sent: Sunday, October 01, 2000 10:23 AM
To: CF-Talk
Subject: RE: Getting Outlook information - Success


If two people share a computer, then using the Outlook code in your web
page will do exactly the same as opening outlook.

i.e. if the people log into windows on different accounts, and therefore
have different outlook setups, then no problem. Outlook should load
straight up with their account, in the Digital Dashboard. Or, if they
share one windows account and use different Outlook profiles, then the
prompt will appear every time the page is loaded - this can be a pain,
as it means choosing the correct profile every time you close and open
the web page.


Seth Ward

-Original Message-
From: Claremont, Timothy S [mailto:[EMAIL PROTECTED]]
Sent: 29 September 2000 15:10
To: CF-Talk
Subject: RE: Getting Outlook information - Success


Thanks for the help so far. I downloaded digital dashboard, but I am not
running NT2K yet, so I can't implement it to the general populace.

HOWEVER, there is a page of code in the digital dashboard that will
retrieve
your Outlook email. I just copied the code onto a ColdFusion page and it
worked instantly. I did not change 1 single line of the code.

What the code does is query the system for the Outlook mail information,
and
use that to open the mailbox.

Security is my next investigation. If two people share a computer I am
not
sure what will happen.

If anyone wants the code to do this, just email me. It is very short.

Tim


Tim Claremont
Xerox Corporation
800 Phillips Road 111-06J
Webster, NY 14580

Phone: 716-265-8573
Pager: 716-239-3514



-Original Message-
From: seth ward [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 29, 2000 3:52 AM
To: CF-Talk
Subject: RE: Getting Outlook information


FWIW, you can do this stuff in ASP - there's something called a Digital
Dashboard, with pre-developed applications to access the Inbox,
Calendar, COntacts etc. You could combine ASP pages with Coldfusion if
that's possible in your case.

http://www.microsoft.com/solutions/km/digitaldashboard.htm

Seth Ward



-Original Message-
From: Claremont, Timothy S [mailto:[EMAIL PROTECTED]]
Sent: 27 September 2000 18:13
To: CF-Talk
Subject: Getting Outlook information


My company uses Microsoft Outlook as the mail client.

I am wondering if I can grab information from outlook and put it on my
customized intranet home page.

For instance, can I put a link in my coldfusion page that calls the
user's
Outlook calendar and shows it on the page? What about the number of new
messages, etc? Basically I want to grab the features of the "Outlook
Today"
tools in outlook.

Tim

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


This message has been checked for all known viruses, by Star Internet,
delivered through the MessageLabs Virus Control Centre.
For further information visit:
http://www.star.net.uk/stats.asp



This message has been checked for all known viruses, by Star Internet,
delivered through the MessageLabs Virus Control Centre.
For further information visit:
http://www.star.net.uk/stats.asp



--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebarlistsbodylists/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=listsbody=lists/cf_talk
or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.


This message has been checked for all known viruses, by Star Internet,
delivered through the MessageLabs Virus Control Centre.
For further information visit:
http://www.star.net.uk/stats.asp



This message has been checked for all 

Re: Date fields in SQL

2000-10-02 Thread James Smith

you could probably drop it to

WHERE expiry_date = #CreateODBCDateTime(now())#

if you wanted.

 I used to #createodbcdate# function as shown below which has worked great.

 WHERE expiry_date = #createodbcdate(DateFormat(now(), "DD-MMM-YY"))#

 Cheers

 Will

 - Original Message -
 From: "James Smith" [EMAIL PROTECTED]
 Newsgroups: cf-talk
 Sent: Sunday, October 01, 2000 2:28 PM
 Subject: Re: Date fields in SQL


  Shouldn't you use cfset today = DateFormat(now(), "DD-MMM-YY") and
also
 I
  think ID is a reserved word in access, try using AdvertID instead (or
  something similar).
 
  --
  James Smith
  [EMAIL PROTECTED]
 
  - Original Message -
  From: "W Luke" [EMAIL PROTECTED]
  To: "CF-Talk" [EMAIL PROTECTED]
  Sent: Sunday, October 01, 2000 2:24 PM
  Subject: Date fields in SQL
 
 
   Hi,
  
   Well it's another Query problem for Will today - the error message is
   telling me it can't find expiry_date field - in Access I've set the
   date/time format to a custom dd-mmm-yy - is this the problem?  Here's
 the
   code:
  
   Cfset today = #DateFormat(Now())#
  
   cfquery name="adverts" datasource=#ds#
SELECT id FROM advert_details
WHERE expiry_date = #today#
   /cfquery
  
   ODBC Error Code = 07001 (Wrong number of parameters)
  
  
   [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected
 1.
  
  
  
   Any ideas?
  
   Thanks, again all.
  
  
  
   Will
  
  
 

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



Re: Protecting Content / content leeching... A CF method?

2000-10-02 Thread James Smith

I would imagine there is some slowdown as the server is doing more work than
it would otherwise do.  However I just created a test page with 5 unique
images on it all called in this way, and it was processed in 0ms, so the
processor hit can't be huge.

--
James Smith
[EMAIL PROTECTED]

- Original Message -
From: "Jake Hileman" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Sunday, October 01, 2000 4:35 PM
Subject: Re: Protecting Content / content leeching... A CF method?


 Does doing this part of what you said:
 " img
 

src="picture.cfm?picture=#URLEncodedFormat(encrypt('C:\WINNT\Help\iis\htm\tu
  torial\rock.jpg', mykey))#""

 slow down things considerably?  Using the encrypt and then using the
decrypt
 later.

 Thanks,

 Jake

 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
 DivineWEB - Web Hosting
 Cold Fusion / ASP / mySQL
 Http://www.divineweb.com
 Design: http://www.18go.com

 - Original Message -
 From: "James Smith" [EMAIL PROTECTED]
 To: "CF-Talk" [EMAIL PROTECTED]
 Sent: Sunday, October 01, 2000 9:23 AM
 Subject: Re: Protecting Content / content leeching... A CF method?


  To expand on this a little further, you could use the following code...
 
  index.cfm
  
  cffile action="READ"
  file="c:\key.txt"
  variable="mykey"
  img
 

src="picture.cfm?picture=#URLEncodedFormat(encrypt('C:\WINNT\Help\iis\htm\tu
  torial\rock.jpg', mykey))#"
 
  picture.cfm
  
  cffile action="READ"
  file="c:\key.txt"
  variable="mykey"
  cfset image = #decrypt(picture, mykey)#
  cfset imagetype = iif(listlast(picture, '.') EQ 'gif',
de('image/gif'),
  de('image/jpeg'))
  cfcontent file="#image#" type="#imagetype#"
 
  key.txt
  
  anythingyoulikeasanencryptionkey
 
  As you can see in this example the encryption key is stored in a file
 called
  key.txt but could just as easily come from a database, either way you
can
  change it with ease.  You could even set up a scheduled task to
randomise
  the key on an hourly basis if you wanted (depending on just how secure
you
  want it).
 
  The file name is also URLEncoded to avoid html characters from messing
up
  the string.
 
  If you are running NT4 you probably have the image I used as an example
on
  your system, and it is not in the web servers path anywhere, yet will
  display correctly.  You will also be able to see (by viewing source)
that
  the chance of anyone guessing a correct sequence is remote at best.
Using
  "anythingyoulikeasanencryptionkey" as the key the img tag becomes...
 
  img
 

src="picture.cfm?picture=G6%205OOB%29RHZN%5B5%3FOPH%5E%5C%26E%5BF%2AITD1P%2D
  N2BZ%29%257A%2A%23N%28WP%3D8%3EW6%3AF%3B%0A"
 
  and if that isn't secure enough for you, then nothing is!
 
  The supplied code will work fine for .gif, .jpg and .jpeg images, but
you
  will have to modify it slightly if you use png or other formats.
 
  Have fun.
 
  --
  James Smith
  [EMAIL PROTECTED]
 
 

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



RE: Date fields in SQL

2000-10-02 Thread Steve Martin

Or even WHERE expiry_date = #now()#
as Now() returns an ODBC compliant date/time stamp.


 -Original Message-
 From: James Smith [mailto:[EMAIL PROTECTED]]
 Sent: Sunday, October 01, 2000 14:49
 To: CF-Talk
 Subject: Re: Date fields in SQL


 you could probably drop it to

 WHERE expiry_date = #CreateODBCDateTime(now())#

 if you wanted.

  I used to #createodbcdate# function as shown below which has
 worked great.
 
  WHERE expiry_date = #createodbcdate(DateFormat(now(), "DD-MMM-YY"))#
 
  Cheers
 
  Will
 
  - Original Message -
  From: "James Smith" [EMAIL PROTECTED]
  Newsgroups: cf-talk
  Sent: Sunday, October 01, 2000 2:28 PM
  Subject: Re: Date fields in SQL
 
 
   Shouldn't you use cfset today = DateFormat(now(), "DD-MMM-YY") and
 also
  I
   think ID is a reserved word in access, try using AdvertID instead (or
   something similar).
  
   --
   James Smith
   [EMAIL PROTECTED]
  
   - Original Message -
   From: "W Luke" [EMAIL PROTECTED]
   To: "CF-Talk" [EMAIL PROTECTED]
   Sent: Sunday, October 01, 2000 2:24 PM
   Subject: Date fields in SQL
  
  
Hi,
   
Well it's another Query problem for Will today - the error
 message is
telling me it can't find expiry_date field - in Access I've set the
date/time format to a custom dd-mmm-yy - is this the
 problem?  Here's
  the
code:
   
Cfset today = #DateFormat(Now())#
   
cfquery name="adverts" datasource=#ds#
 SELECT id FROM advert_details
 WHERE expiry_date = #today#
/cfquery
   
ODBC Error Code = 07001 (Wrong number of parameters)
   
   
[Microsoft][ODBC Microsoft Access Driver] Too few
 parameters. Expected
  1.
   
   
   
Any ideas?
   
Thanks, again all.
   
   
   
Will
   
   
  
 
 
 --
   
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
  
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=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=listsbody=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=listsbody=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=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



OT: Cookie Filtering programs

2000-10-02 Thread Paul Johnston

Does anyone know of any decent (preferably free) cookie filtering programs?
I basically am disabling cookies but want to allow some sites to use them
(ie those in which the client has asked for them to be used and development
servers) whilst blocking all others.

Any ideas?  It can't be a difficult program to write, but I have had no
success with any programs I've tried (they all seem to be out of date).

Thanks

Paul

PS Please no "have you seen this list of 400 I found doing a search on
google?" answers.  I've been there and done that and it's not v. helpful.


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



Unknown CF Error

2000-10-02 Thread Randy Adkins

Can anyone explain this?:

unknown exception condition PCodeRuntimeContextImp::executeSQLTagCFQuery


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



Graphic Rollovers without Javascript

2000-10-02 Thread Powers, Bonnie

I would like to do graphic rollovers on my website without using javascript.
Does anyone know of any ColdFusion applications and/or custom tags which can
help me do this.  I have visited the Allaire Developers Gallery, but most of
those apps use Javascript with ColdFusion.

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



RE: Scope of Cached Query

2000-10-02 Thread Bob Silverberg

I realize that there's already been a lot of talk on the subject, but here's
what I think:

If the query is actually going to be cached (using the CACHEDWITHIN or
CACHEDAFTER attributes), then there is no reason to add it to either the
request or application scope.  CFAS will handle the caching for you, and
will serve the cached query to anyone who requests it.  The only issue I see
is that the query may be pushed out of the cache if the cache runs out of
room.  In that case, the next execution of the CFQUERY tag will add it back
to the cache, so I don't see this as a big issue.

Comments?

Bob

-Original Message-
From: paul smith [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 02, 2000 12:28 AM
To: CF-Talk
Subject: Scope of Cached Query


What advantage is there for a cached query
to have Application vs Request scope?

best,  paul


==
Paul Smith, Web/Database Droid
A: SupportNet, Inc, 3871 Piedmont Ave, Oakland, CA 94611
(There, there, there; there's, there, there)
P: (510) 763-2358
C: (510) 205-6755
F: (510) 763-2370
E: [EMAIL PROTECTED]
W: http://www.support.net


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



Re: Graphic Rollovers without Javascript

2000-10-02 Thread JustinMacCarthy


 I would like to do graphic rollovers on my website without using
javascript.

It is impossible to do client side image swapping without using a clientside
scripting language, such as JavaScript or VBScript , or a Java Applet.

Justin


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



RE: query caching?

2000-10-02 Thread Larry Juncker

Have you tried adding CachedWithin=#CreateTimeStamp(0,0,10,0)#

Add this to your query and then it will cache the query when it runs so it
does not have to requery again.

Larry Juncker
Senior Cold Fusion Programmer
Heartland Internet

-Original Message-
From: Jon Hall [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 29, 2000 5:39 PM
To: CF-Talk
Subject: query caching?


This is a multi-part message in MIME format.

--=_NextPart_000_03AA_01C02A44.87489EC0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Ok, maybe someone could point me in the right direction here. I am =
working with a database with 750,000 diferent products (yes 750,000). =
The database has been tweaked so that even the most complicated search =
only takes 10 seconds to return data on the development server.This wil =
lspeed up when it is live. That is fairly acceptable...
The problem is that each page takes 10 seconds...so when someone hits =
clicks "Next" to go to the next page, it has to requery.
Is there a way to optimize this? Perhaps some sort of read ahead =
caching? Any suggestions would be helpful. I am including the query code =
below.

cfquery name=3D"productsearch" datasource=3D"#dsn#" maxrows=3D500 =
dbtype=3D"ODBC"
SELECT  cLinesID, cProductsNo, cProductsStyleNumber, cProductsName, =
cDescription, cProductsCategorys,cProductimage,cProductsPriceRange
FROM dbo.tProducts=20
WHERE   0=3D0=20
and (cProductimage  '')=20

CFIF #user_category# IS NOT ""
and (cProductsCategorys like '%#user_category#%')
/CFIF

CFIF #user_style# IS NOT ""
and (cProductsStyleNumber LIKE '%#user_style#%')
/CFIF

CFIF #user_keyword# IS NOT ""
and (cProductsKeyWords LIKE '%#user_keyword#%')
/CFIF

CFIF #user_min# IS NOT ""
and (cProductspricerange =3D #user_min#)
/CFIF

CFIF #user_max# IS NOT ""
and (cProductspricerange =3D #user_max#)
/CFIF

/cfquery

cfoutput query=3D"productsearch" startrow=3D#startr# =
maxrows=3D#maxdisplay#

--=_NextPart_000_03AA_01C02A44.87489EC0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
HTMLHEAD
META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type
META content=3D"MSHTML 5.00.3018.900" name=3DGENERATOR
STYLE/STYLE
/HEAD
BODY bgColor=3D#ff
DIVFONT face=3DArial size=3D2Ok, maybe someone could point me in the =
right=20
direction here. I am working with a database with 750,000 diferent =
products (yes=20
750,000). The database has been tweaked so that even the most =
complicated search=20
only takes 10 seconds to return data on the development server.This wil =
lspeed=20
up when it is live. That is fairly acceptable.../FONT/DIV
DIVFONT face=3DArial size=3D2The problem is that each page takes 10 =
seconds...so=20
when someone hits clicks "Next" to go to the next page, it has to=20
requery./FONT/DIV
DIVFONT face=3DArial size=3D2Is there a way to optimize this? =
Perhaps some sort=20
of read ahead caching? Any suggestions would be helpful. I am including =
the=20
query code below./FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial size=3D2lt;cfquery name=3D"productsearch" =
datasource=3D"#dsn#"=20
maxrows=3D500 =
dbtype=3D"ODBC"gt;BRSELECTnbsp;nbsp;nbsp;nbsp;nbsp; cLinesID,=20
cProductsNo, cProductsStyleNumber, cProductsName, cDescription,=20
cProductsCategorys,cProductimage,cProductsPriceRangeBRFROMnbsp;nbsp;=
nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;=20
dbo.tProducts BRWHEREnbsp;nbsp;nbsp;nbsp;nbsp;nbsp; 0=3D0 =
BRand=20
(cProductimage gt; '') /FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial size=3D2lt;CFIF #user_category# IS NOT=20
""gt;BRnbsp;nbsp;nbsp; and (cProductsCategorys like=20
'%#user_category#%')BRlt;/CFIFgt;/FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial size=3D2lt;CFIF #user_style# IS NOT=20
""gt;BRnbsp;nbsp;nbsp; and (cProductsStyleNumber LIKE=20
'%#user_style#%')BRlt;/CFIFgt;/FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial size=3D2lt;CFIF #user_keyword# IS NOT=20
""gt;BRnbsp;nbsp;nbsp; and (cProductsKeyWords LIKE=20
'%#user_keyword#%')BRlt;/CFIFgt;/FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial size=3D2lt;CFIF #user_min# IS NOT=20
""gt;BRnbsp;nbsp;nbsp; and (cProductspricerange gt;=3D=20
#user_min#)BRlt;/CFIFgt;/FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial size=3D2lt;CFIF #user_max# IS NOT=20
""gt;BRnbsp;nbsp;nbsp; and (cProductspricerange lt;=3D=20
#user_max#)BRlt;/CFIFgt;/FONT/DIV
DIVFONT face=3DArial size=3D2BRlt;/cfquerygt;/FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial size=3D2lt;cfoutput query=3D"productsearch"=20
startrow=3D#startr# =
maxrows=3D#maxdisplay#gt;/FONT/DIV/BODY/HTML

--=_NextPart_000_03AA_01C02A44.87489EC0--


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

Bugged Out CFERROR : CFMLInterpreterImp::process

2000-10-02 Thread Jerry Tolentino


I got the following error when making a call to a custom tag.

Here are the facts:
  1. I know the tag works. Its been tested and other applications use.
  2. I have tried several methods of calling the tag including the
following:
 - calling from the same directory using both CFMODULE and
CF_customTag
 - calling from a subdirectory using CFMODULE
 - calling from coldfusions custom tag directory using CF_customTag
  3. Heres the strange one. A query is passed to the Custom Tag. The tag
works with the following query (its from of the applications using it):

  CFQUERY NAME="NodeListQuery" DATASOURCE="Datasource1"
SELECT Identifier AS ID, ParentNode AS
ParentID, Name AS Label
FROM Node
ORDER BY ParentNode, SortOrder
  /CFQUERY

  when I change the query to pull data from another table and
datasource it chokes. I know the data is pulling I tested it. Here is that
query:

  CFQUERY NAME="NodeListQuery" DATASOURCE="GenericHelp"
SELECTIdentifier AS ID, Parent AS ParentID,
Name AS Label
FROMTopic
ORDER BY ParentID, SortOrder
  /CFQUERY

  4. Here is the error:

 Error Diagnostic Information
 unknown exception condition

 CFMLInterpreterImp::process

Any help on this one will be greatly appreciated. Thanks in advance.

Jerry T.


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



RE: query caching?

2000-10-02 Thread paul smith

Well, er, yes.  That's what I mean by a cached query.
In there another way to cache a query?

best,  paul

At 08:09 AM 10/2/00 -0500, you wrote:
Have you tried adding CachedWithin=#CreateTimeStamp(0,0,10,0)#

Add this to your query and then it will cache the query when it runs so it
does not have to requery again.

Larry Juncker
Senior Cold Fusion Programmer
Heartland Internet

-Original Message-
From: Jon Hall [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 29, 2000 5:39 PM
To: CF-Talk
Subject: query caching?


This is a multi-part message in MIME format.

--=_NextPart_000_03AA_01C02A44.87489EC0
Content-Type: text/plain;
 charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Ok, maybe someone could point me in the right direction here. I am =
working with a database with 750,000 diferent products (yes 750,000). =
The database has been tweaked so that even the most complicated search =
only takes 10 seconds to return data on the development server.This wil =
lspeed up when it is live. That is fairly acceptable...
The problem is that each page takes 10 seconds...so when someone hits =
clicks "Next" to go to the next page, it has to requery.
Is there a way to optimize this? Perhaps some sort of read ahead =
caching? Any suggestions would be helpful. I am including the query code =
below.

cfquery name=3D"productsearch" datasource=3D"#dsn#" maxrows=3D500 =
dbtype=3D"ODBC"
SELECT  cLinesID, cProductsNo, cProductsStyleNumber, cProductsName, =
cDescription, cProductsCategorys,cProductimage,cProductsPriceRange
FROM dbo.tProducts=20
WHERE   0=3D0=20
and (cProductimage  '')=20

CFIF #user_category# IS NOT ""
 and (cProductsCategorys like '%#user_category#%')
/CFIF

CFIF #user_style# IS NOT ""
 and (cProductsStyleNumber LIKE '%#user_style#%')
/CFIF

CFIF #user_keyword# IS NOT ""
 and (cProductsKeyWords LIKE '%#user_keyword#%')
/CFIF

CFIF #user_min# IS NOT ""
 and (cProductspricerange =3D #user_min#)
/CFIF

CFIF #user_max# IS NOT ""
 and (cProductspricerange =3D #user_max#)
/CFIF

/cfquery

cfoutput query=3D"productsearch" startrow=3D#startr# =
maxrows=3D#maxdisplay#

--=_NextPart_000_03AA_01C02A44.87489EC0
Content-Type: text/html;
 charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
Ok, maybe someone could point me in the = right=20 direction here. I am 
working with a database with 750,000 diferent = products (yes=20 750,000). 
The database has been tweaked so that even the most = complicated 
search=20 only takes 10 seconds to return data on the development 
server.This wil = lspeed=20 up when it is live. That is fairly acceptable...
The problem is that each page takes 10 = seconds...so=20 when someone hits 
clicks "Next" to go to the next page, it has to=20 requery.
Is there a way to optimize this? = Perhaps some sort=20 of read ahead 
caching? Any suggestions would be helpful. I am including = the=20 query 
code below.

cfquery name=3D"productsearch" = datasource=3D"#dsn#"=20 maxrows=3D500 = 
dbtype=3D"ODBC"
SELECT  cLinesID,=20 cProductsNo, cProductsStyleNumber, cProductsName, 
cDescription,=20 cProductsCategorys,cProductimage,cProductsPriceRange
FROM  =
nbsp; =20 dbo.tProducts
WHERE   0=3D0 =
and=20 (cProductimage  '')

CFIF #user_category# IS NOT=20 ""
 and (cProductsCategorys like=20 '%#user_category#%')
/CFIF

CFIF #user_style# IS NOT=20 ""
 and (cProductsStyleNumber LIKE=20 '%#user_style#%')
/CFIF

CFIF #user_keyword# IS NOT=20 ""
 and (cProductsKeyWords LIKE=20 '%#user_keyword#%')
/CFIF

CFIF #user_min# IS NOT=20 ""
 and (cProductspricerange =3D=20 #user_min#)
/CFIF

CFIF #user_max# IS NOT=20 ""
 and (cProductspricerange =3D=20 #user_max#)
/CFIF

/cfquery

cfoutput query=3D"productsearch"=20 startrow=3D#startr# = 
maxrows=3D#maxdisplay#

--=_NextPart_000_03AA_01C02A44.87489EC0--


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



Re: creating word docs and excel sheets on the fly...

2000-10-02 Thread Tobe Goldfinger

When we want to build easy-to-download 'Word' documents in CF, we create 
RTF files.

If you don't need a lot of really complex formatting, RTF syntax is no 
harder than HTML. lots of start/end tags.

The easiest way to see what kind of RTF file you need is to save a sample 
file from Wordpad in RTF format. (If you save it from Word in RTF format, 
you get a lot of junk you don't really need.) Y

hth,
Tobe Goldfinger
jdt technologies, ltd.


At 03:14 PM 9/30/2000 , you wrote:
I asked this question a couple days ago and received no responses, so I'm 
beginning to believe this is not possible.

I need to create a word doc or excel spreadsheet based upon a set of 
queries.  I know how to pass raw data into these new documents, that's no 
problem.  The problem is that I'd also like to pass along formatting codes 
for things like creating tables in Word and shading certain rows.

Does anyone know if this is even possible?

---mark

--
Mark Warrick

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



Bugged Out CFERROR - CFMLInterpreterImp::process

2000-10-02 Thread Jerry Tolentino

I got the following error when making a call to a custom tag.

Here are the facts:
  1. I know the tag works. Its been tested and other applications use.
  2. I have tried several methods of calling the tag including the
following:
 - calling from the same directory using both CFMODULE and
CF_customTag
 - calling from a subdirectory using CFMODULE
 - calling from coldfusions custom tag directory using CF_customTag
  3. Heres the strange one. A query is passed to the Custom Tag. The tag
works with the following query (its from of the applications using it):

  CFQUERY NAME="NodeListQuery" DATASOURCE="Datasource1"
SELECT Identifier AS ID, ParentNode AS
ParentID, Name AS Label
FROM Node
ORDER BY ParentNode, SortOrder
  /CFQUERY

  when I change the query to pull data from another table and
datasource it chokes. I know the data is pulling I tested it. Here is that
query:

  CFQUERY NAME="NodeListQuery" DATASOURCE="GenericHelp"
SELECTIdentifier AS ID, Parent AS ParentID,
Name AS Label
FROMTopic
ORDER BY ParentID, SortOrder
  /CFQUERY

  4. Here is the error:

 Error Diagnostic Information
 unknown exception condition

 CFMLInterpreterImp::process

Any help on this one will be greatly appreciated. Thanks in advance.

Jerry


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



Re: Bugged Out CFERROR - CFMLInterpreterImp::process

2000-10-02 Thread Fred T. Sanders

get rid of the ,sortorder  it should just be a space and either ASC or DES
- Original Message -
From: "Jerry Tolentino" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Monday, October 02, 2000 9:54 AM
Subject: Bugged Out CFERROR - CFMLInterpreterImp::process


 I got the following error when making a call to a custom tag.

 Here are the facts:
   1. I know the tag works. Its been tested and other applications use.
   2. I have tried several methods of calling the tag including the
 following:
  - calling from the same directory using both CFMODULE and
 CF_customTag
  - calling from a subdirectory using CFMODULE
  - calling from coldfusions custom tag directory using
CF_customTag
   3. Heres the strange one. A query is passed to the Custom Tag. The tag
 works with the following query (its from of the applications using it):

   CFQUERY NAME="NodeListQuery" DATASOURCE="Datasource1"
 SELECT Identifier AS ID, ParentNode AS
 ParentID, Name AS Label
 FROM Node
 ORDER BY ParentNode, SortOrder
   /CFQUERY

   when I change the query to pull data from another table and
 datasource it chokes. I know the data is pulling I tested it. Here is that
 query:

   CFQUERY NAME="NodeListQuery" DATASOURCE="GenericHelp"
 SELECTIdentifier AS ID, Parent AS ParentID,
 Name AS Label
 FROMTopic
 ORDER BY ParentID, SortOrder
   /CFQUERY

   4. Here is the error:

  Error Diagnostic Information
  unknown exception condition

  CFMLInterpreterImp::process

 Any help on this one will be greatly appreciated. Thanks in advance.

 Jerry


 --

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



Re: Bugged Out CFERROR - CFMLInterpreterImp::process

2000-10-02 Thread Fred T. Sanders

and they don't always like you ordering by the alias, do it by the original
name instead.

- Original Message -
From: "Jerry Tolentino" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Monday, October 02, 2000 9:54 AM
Subject: Bugged Out CFERROR - CFMLInterpreterImp::process


 I got the following error when making a call to a custom tag.

 Here are the facts:
   1. I know the tag works. Its been tested and other applications use.
   2. I have tried several methods of calling the tag including the
 following:
  - calling from the same directory using both CFMODULE and
 CF_customTag
  - calling from a subdirectory using CFMODULE
  - calling from coldfusions custom tag directory using
CF_customTag
   3. Heres the strange one. A query is passed to the Custom Tag. The tag
 works with the following query (its from of the applications using it):

   CFQUERY NAME="NodeListQuery" DATASOURCE="Datasource1"
 SELECT Identifier AS ID, ParentNode AS
 ParentID, Name AS Label
 FROM Node
 ORDER BY ParentNode, SortOrder
   /CFQUERY

   when I change the query to pull data from another table and
 datasource it chokes. I know the data is pulling I tested it. Here is that
 query:

   CFQUERY NAME="NodeListQuery" DATASOURCE="GenericHelp"
 SELECTIdentifier AS ID, Parent AS ParentID,
 Name AS Label
 FROMTopic
 ORDER BY ParentID, SortOrder
   /CFQUERY

   4. Here is the error:

  Error Diagnostic Information
  unknown exception condition

  CFMLInterpreterImp::process

 Any help on this one will be greatly appreciated. Thanks in advance.

 Jerry


 --

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



Time Zone Select

2000-10-02 Thread Sean Daniels

Anyone out there have a custom tag or data table that would allow me to
easily include a select box for choosing time zone?

TIA


- Sean

~~
  Sean Daniels
  Manager, Engineering
  (T): 207.439.6030
  (C): 978.764.0799
~~
  http://www.dealforce.com
  http://www.mergernetwork.com



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



Re: Bugged Out CFERROR - CFMLInterpreterImp::process

2000-10-02 Thread Jerry Tolentino

That has nothing to do with this error. ASC is the default sort type on
SQL. And just for the record I tried what you suggested and nothing
happened.

Jerry T.




"Fred T. Sanders" [EMAIL PROTECTED] on 10/02/2000 09:59:45 AM

Please respond to [EMAIL PROTECTED]

To:   CF-Talk [EMAIL PROTECTED]
cc:(bcc: Jerry Tolentino/SIAC)
Subject:  Re: Bugged Out CFERROR - CFMLInterpreterImp::process




get rid of the ,sortorder  it should just be a space and either ASC or DES
- Original Message -
From: "Jerry Tolentino" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Monday, October 02, 2000 9:54 AM
Subject: Bugged Out CFERROR - CFMLInterpreterImp::process


 I got the following error when making a call to a custom tag.

 Here are the facts:
   1. I know the tag works. Its been tested and other applications use.
   2. I have tried several methods of calling the tag including the
 following:
  - calling from the same directory using both CFMODULE and
 CF_customTag
  - calling from a subdirectory using CFMODULE
  - calling from coldfusions custom tag directory using
CF_customTag
   3. Heres the strange one. A query is passed to the Custom Tag. The tag
 works with the following query (its from of the applications using it):

   CFQUERY NAME="NodeListQuery" DATASOURCE="Datasource1"
 SELECT Identifier AS ID, ParentNode AS
 ParentID, Name AS Label
 FROM Node
 ORDER BY ParentNode, SortOrder
   /CFQUERY

   when I change the query to pull data from another table and
 datasource it chokes. I know the data is pulling I tested it. Here is
that
 query:

   CFQUERY NAME="NodeListQuery" DATASOURCE="GenericHelp"
 SELECTIdentifier AS ID, Parent AS ParentID,
 Name AS Label
 FROMTopic
 ORDER BY ParentID, SortOrder
   /CFQUERY

   4. Here is the error:

  Error Diagnostic Information
  unknown exception condition

  CFMLInterpreterImp::process

 Any help on this one will be greatly appreciated. Thanks in advance.

 Jerry



--

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



RE: query caching?

2000-10-02 Thread Bill Killillay

 Well, er, yes.  That's what I mean by a cached query.
 In there another way to cache a query?
Well you could scope it into a session, or application scope and then wrap
your query in an isdefined statement, and then you could control when that
query is refreshed a little better.



 At 08:09 AM 10/2/00 -0500, you wrote:
 Have you tried adding CachedWithin=#CreateTimeStamp(0,0,10,0)#
 
 Add this to your query and then it will cache the query when it
 runs so it
 does not have to requery again.

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



Page output

2000-10-02 Thread Scott Becker

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

--_=_NextPart_001_01C02C83.0830D1E0
Content-Type: text/plain;
charset="iso-8859-1"

I believe Cold Fusion withholds page output until the entire
page is completed. Is there anyway to make it flush out, like
Response.flush in ASP?

Scott Becker
Web Developer : ConnectWise, Inc.
www.ConnectWise.com

--_=_NextPart_001_01C02C83.0830D1E0
Content-Type: text/html;
charset="iso-8859-1"

!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"
HTML
HEAD
META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"
META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2650.12"
TITLEPage output/TITLE
/HEAD
BODY

PFONT SIZE=2I believe Cold Fusion withholds page output until the entire/FONT
BRFONT SIZE=2page is completed. Is there anyway to make it flush out, like/FONT
BRFONT SIZE=2Response.flush in ASP?/FONT
/P

PFONT SIZE=2Scott Becker/FONT
BRFONT SIZE=2Web Developer : ConnectWise, Inc./FONT
BRFONT SIZE=2www.ConnectWise.com/FONT
/P

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



Re: creating word docs and excel sheets on the fly...

2000-10-02 Thread Billy Cravens

There's some excellent (the best, and about the only info on doing this
is CF) at http://www.cfm-resources.com/members/comet.  

-- 
Billy Cravens
[EMAIL PROTECTED]



"Warrick, Mark" wrote:
 
 I asked this question a couple days ago and received no responses, so I'm beginning 
to believe this is not possible.
 
 I need to create a word doc or excel spreadsheet based upon a set of queries.  I 
know how to pass raw data into these new documents, that's no problem.  The problem 
is that I'd also like to pass along formatting codes for things like creating tables 
in Word and shading certain rows.
 
 Does anyone know if this is even possible?
 
 ---mark
 
 --
 Mark Warrick
 Phone: (714) 547-5386
 Efax.com Fax: (801) 730-7289
 Personal Email: [EMAIL PROTECTED]
 Personal URL: http://www.warrick.net
 Business Email: [EMAIL PROTECTED]
 Business URL: http://www.fusioneers.com
 ICQ: 346566
 --
 
 --
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



OT: Bind problems

2000-10-02 Thread W Luke

Hi all,

[caution - beginner learning how to use Bind]

I don't know if I'm using Bind correctly.  I'm trying to create a "fake"
test Domain as part of a project. For example I just created
www.wluke-testing.co.uk - the Bind file was called db.wluke-testing.co.uk
and obviously I entered the entry into named.boot.

But I can't get it to resolve.  Do I have to wait a set period of minutes
until it'll resolve?

Hope someone can advise.

Thanks

Will

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



Help? CF Error

2000-10-02 Thread Randy Adkins

Can anyone explain this?:

unknown exception condition PCodeRuntimeContextImp::executeSQLTagCFQuery

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



Re: cutting edge or what ???

2000-10-02 Thread Billy Cravens

I don't know how this works on an upgrade, but anything pre-4.5 (maybe
pre-4.5.1, since that's the only version that Allaire supports for
Win2k) will screw up the MDAC on a Win2k box.  However, since you're
upgrading the OS, with CF already on the box, it might the other way
around, so you might be safe.  As in any situation where you're
upgrading a production machine, you've gotta test the setup on a test
box before you touch production.

-- 
Billy Cravens
[EMAIL PROTECTED]



Jim McAtee wrote:
 
 Anybody successfully running CF 4.0.1 on Win2K?  I'm not ready to move to CF
 4.5.1, but the OS upgrade is starting to look good.
 
 Jim
 
 - Original Message -
 From: "Simon Horwith" [EMAIL PROTECTED]
 To: "CF-Talk" [EMAIL PROTECTED]
 Sent: Friday, September 29, 2000 11:10 AM
 Subject: RE: cutting edge or what ???
 
  runs fine for me on Win 2K.  IIS functions pretty much the same.  It's a
 bit
  more robust and offers new interfaces (like the watered down personal web
  server interface, for one), but all in all, if you got it working on NT
 4.0,
  you should be fine on Win 2K.
 
  ~Simon
 
  -Original Message-
  From: Russell Jones [mailto:[EMAIL PROTECTED]]
  Sent: Friday, September 29, 2000 12:07 PM
  To: CF-Talk
  Subject: cutting edge or what ???
 
 
  Is it? ...
 
  ... or does Cold fusion even function at all under Windows 2000?
 
  Are there big issues I should know about before replacing my CF4.5/NT4.0
  installation with Win2000?
 
  Does IIS work the same as it does under NT4.0?
 
  -Russ
 
  --
  Russell Jones
  Webmaster
  ImproveNow.com
  Phone: 207.236.0146
  e-mail: [EMAIL PROTECTED]
 
 --
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



CFQUERY BLOCKFACTOR

2000-10-02 Thread paul smith

CF Docs on the Subject are as follows:

"Optional. Specifies the maximum number of rows to fetch at a time from the 
server. The range is 1 (default) to 100. This parameter applies to ORACLE 
native database drivers and to ODBC drivers. Certain ODBC drivers may 
dynamically reduce the block factor at runtime."

A recent article in SQL Server Magazine (October 2000, p 75) discusses 
"BLOCKING FACTOR"

"BLOCKING FACTOR" bears some resemblance to "BLOCKFACTOR," but I'm not sure 
how close it is.

BLOCKING FACTOR appears to be determined by the width of a RECORD, as it 
exists in the DB (that is, it includes all columns).

I've assumed BLOCKFACTOR to be determined by the width of the RETURNED DATA 
in each record, which does not have to include all columns.

I further assumed a CFQUERY that returned a single column of integers could 
have BLOCKFACTOR set at the maximum of 100, without fear of loss of 
efficiency as in those cases where 100 happened to be too large and CF 
would then have to try 99, then 98, etc.

So the question is: Is 100 ALWAYS OK when CFQUERY returns a single column 
of integers?

best,  paul

PS Keeping in mind that CF4.01 Administrator (but not 4.51 Administrator) 
is now known to have incorrectly stated there to be limit of 100 cached 
queries, whereas there really is no fixed limit, is BLOCKFACTOR _really_ 
limited to 100?

==
Paul Smith, Web/Database Droid
A: SupportNet, Inc, 3871 Piedmont Ave, Oakland, CA 94611
(There, there, there; there's, there, there)
P: (510) 763-2358
C: (510) 205-6755
F: (510) 763-2370
E: [EMAIL PROTECTED]
W: http://www.support.net

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



RE: Help? CF Error

2000-10-02 Thread Andy Ewings

possibly.

Are you querying a database using a CFQUERY or CFSTOREDPROC?  If so are you
selecting a field that is of type ntext.  If so here is your problem.  Go
into the database and change the field type to text and all should be fine.
for some reason CF does not like the Unicode type of ntext.  It copes with
nvarchar ok.

--
Andrew Ewings
Project Manager
Thoughtbubble Ltd
--


-Original Message-
From: Randy Adkins [mailto:[EMAIL PROTECTED]]
Sent: 02 October 2000 16:25
To: CF-Talk
Subject: Help? CF Error


Can anyone explain this?:

unknown exception condition PCodeRuntimeContextImp::executeSQLTagCFQuery


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



RE: ...list...array

2000-10-02 Thread Reynolds, Adam

Just a clarification

lists are just string variables. Everytime you use a list CF has to parse
the list variable to locate all the elements of the list.

Where possible use arrays (particularly with large sets) as these are
significantly faster. 

Adam
**
 This email and any attachments are confidential and solely
 for the use of the intended recipient.  They may contain
 material protected by legal professional or other privilege.
 If you are not the intended recipient or the person responsible
 for delivering to the intended recipient, you are not authorised
 to and must not disclose, copy, distribute or retain this email
 or its attachments.  Although this email and its attachments
 are believed to be free of any virus or other defect, it is the
 responsibility of the recipient to ensure that they are virus free
 and no responsibility is accepted by the company for any
 loss or damage arising from receipt or use thereof.

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



Re: OT: Bind problems

2000-10-02 Thread Len Conrad


   I'm trying to create a "fake"
test Domain as part of a project. For example I just created
www.wluke-testing.co.uk - the Bind file was called db.wluke-testing.co.uk
and obviously I entered the entry into named.boot.

But I can't get it to resolve.  Do I have to wait a set period of minutes
until it'll resolve?

Yes, like a woman, it has warm up for best results.

If your machine's "DNS client" aka "resolver" is pointing at that 
DNS, the zone's records are availailable immediately after you 
stop/start BIND (this smells like a BIND4 vintage) to re-parse the 
named.boot and any changes in the zone files or new zone files.

Len


http://BIND8NT.MEIway.com: ISC BIND 8.2.2 p5  installable binary for NT4
http://IMGate.MEIway.com:  Build free, hi-perf, anti-spam mail gateways

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



vb script in .cfm templates?

2000-10-02 Thread Eric Hoffman

showing my M$ VB ignorance hereif we are on a IIS/M$ platform, can we run VB 
script in a .cfm template?  Or is there a better way to force a table of data to a 
fixed-width text file?

Thanks for any pointers.

Eric

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



Re: Bind problems

2000-10-02 Thread Timothy C. Hill

Make sure you updated the serial number in the file. If you don't do that,
it won't update.

Tim Hill

- Original Message -
From: "W Luke" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Monday, October 02, 2000 11:25 AM
Subject: OT: Bind problems


 Hi all,

 [caution - beginner learning how to use Bind]

 I don't know if I'm using Bind correctly.  I'm trying to create a "fake"
 test Domain as part of a project. For example I just created
 www.wluke-testing.co.uk - the Bind file was called db.wluke-testing.co.uk
 and obviously I entered the entry into named.boot.

 But I can't get it to resolve.  Do I have to wait a set period of minutes
 until it'll resolve?

 Hope someone can advise.

 Thanks

 Will

 --

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



Re: Bugged Out CFERROR - CFMLInterpreterImp::process

2000-10-02 Thread Fred T. Sanders

Fair enough, I didn't read it thoroughly, no coffee yet.

Okay need more info.

OS on the server
version of CFAS running
version and brand of database.

Also is that the complete error or are there other sorid details being
displayed that you didn't cut and paste for us.

Fred

- Original Message -
From: "Jerry Tolentino" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Monday, October 02, 2000 10:55 AM
Subject: Re: Bugged Out CFERROR - CFMLInterpreterImp::process


 That has nothing to do with this error. ASC is the default sort type on
 SQL. And just for the record I tried what you suggested and nothing
 happened.

 Jerry T.




 "Fred T. Sanders" [EMAIL PROTECTED] on 10/02/2000 09:59:45 AM

 Please respond to [EMAIL PROTECTED]

 To:   CF-Talk [EMAIL PROTECTED]
 cc:(bcc: Jerry Tolentino/SIAC)
 Subject:  Re: Bugged Out CFERROR - CFMLInterpreterImp::process




 get rid of the ,sortorder  it should just be a space and either ASC or DES
 - Original Message -
 From: "Jerry Tolentino" [EMAIL PROTECTED]
 To: "CF-Talk" [EMAIL PROTECTED]
 Sent: Monday, October 02, 2000 9:54 AM
 Subject: Bugged Out CFERROR - CFMLInterpreterImp::process


  I got the following error when making a call to a custom tag.
 
  Here are the facts:
1. I know the tag works. Its been tested and other applications use.
2. I have tried several methods of calling the tag including the
  following:
   - calling from the same directory using both CFMODULE and
  CF_customTag
   - calling from a subdirectory using CFMODULE
   - calling from coldfusions custom tag directory using
 CF_customTag
3. Heres the strange one. A query is passed to the Custom Tag. The tag
  works with the following query (its from of the applications using it):
 
CFQUERY NAME="NodeListQuery" DATASOURCE="Datasource1"
  SELECT Identifier AS ID, ParentNode AS
  ParentID, Name AS Label
  FROM Node
  ORDER BY ParentNode, SortOrder
/CFQUERY
 
when I change the query to pull data from another table and
  datasource it chokes. I know the data is pulling I tested it. Here is
 that
  query:
 
CFQUERY NAME="NodeListQuery" DATASOURCE="GenericHelp"
  SELECTIdentifier AS ID, Parent AS ParentID,
  Name AS Label
  FROMTopic
  ORDER BY ParentID, SortOrder
/CFQUERY
 
4. Here is the error:
 
   Error Diagnostic Information
   unknown exception condition
 
   CFMLInterpreterImp::process
 
  Any help on this one will be greatly appreciated. Thanks in advance.
 
  Jerry
 
 
 
 --
 
  Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
  To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=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=listsbody=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=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: Bind problems

2000-10-02 Thread Jim McAtee

Has that domain been registered?

What most developers do is create subdomains beneath a domain that they
already own.  For example, a web development company named 'Bob's
Development' might have as their main domain name 'bobdev.co.uk'.  Then, if
needed, they create subdomains for client test sites, as in
'flowerpot.bobdev.co.uk' or 'smithmortuary.bobdev.co.uk'.

Jim

- Original Message -
From: "W Luke" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Monday, October 02, 2000 9:25 AM
Subject: OT: Bind problems


 Hi all,

 [caution - beginner learning how to use Bind]

 I don't know if I'm using Bind correctly.  I'm trying to create a "fake"
 test Domain as part of a project. For example I just created
 www.wluke-testing.co.uk - the Bind file was called db.wluke-testing.co.uk
 and obviously I entered the entry into named.boot.

 But I can't get it to resolve.  Do I have to wait a set period of minutes
 until it'll resolve?

 Hope someone can advise.

 Thanks

 Will


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



Re: Bind problems

2000-10-02 Thread W Luke

Just realised...I had to reload the DNS database :)  Oops.

Thanks

Will
- Original Message -
From: "Jim McAtee" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: "W Luke" [EMAIL PROTECTED]
Sent: Monday, October 02, 2000 4:49 PM
Subject: Re: Bind problems


 Has that domain been registered?

 What most developers do is create subdomains beneath a domain that they
 already own.  For example, a web development company named 'Bob's
 Development' might have as their main domain name 'bobdev.co.uk'.  Then,
if
 needed, they create subdomains for client test sites, as in
 'flowerpot.bobdev.co.uk' or 'smithmortuary.bobdev.co.uk'.

 Jim

 - Original Message -
 From: "W Luke" [EMAIL PROTECTED]
 To: "CF-Talk" [EMAIL PROTECTED]
 Sent: Monday, October 02, 2000 9:25 AM
 Subject: OT: Bind problems


  Hi all,
 
  [caution - beginner learning how to use Bind]
 
  I don't know if I'm using Bind correctly.  I'm trying to create a "fake"
  test Domain as part of a project. For example I just created
  www.wluke-testing.co.uk - the Bind file was called
db.wluke-testing.co.uk
  and obviously I entered the entry into named.boot.
 
  But I can't get it to resolve.  Do I have to wait a set period of
minutes
  until it'll resolve?
 
  Hope someone can advise.
 
  Thanks
 
  Will




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



RE: vb script in .cfm templates?

2000-10-02 Thread Andy Ewings

Do you mean client side VB script (like Java Script) or server side VB
Script (ASP)?  If it's the former then no probs.  If it's the latter then I
don't think so.  As far as I understand it (someone please correct me if I'm
wrong) IIS knows that it has to execute some ASP code before sending the
page to the browser by looking at the file extension (.asp).  If you embed
it in a .cfm file it won't work.  I guess you can extract the asp into a
separate page and then use CFINCLUDE to include it in your cfm template.

--
Andrew Ewings
Project Manager
Thoughtbubble Ltd
--


-Original Message-
From: Eric Hoffman [mailto:[EMAIL PROTECTED]]
Sent: 02 October 2000 16:35
To: CF-Talk
Subject: vb script in .cfm templates?


showing my M$ VB ignorance hereif we are on a IIS/M$ platform, can we
run VB script in a .cfm template?  Or is there a better way to force a table
of data to a fixed-width text file?

Thanks for any pointers.

Eric


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



FW: CFFILE troubles ... multiple unique filenames

2000-10-02 Thread Joshua Miller

Here's my problem, I'm trying to upload 2 photos with a user signup 
form, but I need to allow for the fact that some people will have 
the same filenames, I used the following lines of code for the photos:

cfif picold gt 0
cffile action="UPLOAD" filefield="picold" 
destination="c:/My Documents/Websites/rhs.org/pics/" 
nameconflict="MakeUnique"
cfset FORM.picold = "#FILE.ServerFile#"
/cfif

cfif picnew gt 0
cffile action="UPLOAD" filefield="picnew" 
destination="c:/My Documents/Websites/rhs.org/pics/" 
nameconflict="MakeUnique"
cfset FORM.picnew = "#FILE.ServerFile#"
/cfif

Then the second is the same, except the filefield is "picnew" ... 
however, I get an "Unspecified Error" when I try to upload 2 photos 
that are already in the directory. The first one gets a unique 
filename, but the second throws and error.

Any help greatly appreciated!

Joshua Miller
Web Site Development
Eagle Technologies Group
Business Solutions for the Next Generation
www.eagletgi.com
[EMAIL PROTECTED] 
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



CFServer a memory leaker?

2000-10-02 Thread Claremont, Timothy S

At home I have installed CFSERVER running on Personal Web Server, using RDS.

Since I have installed both server and studio, my system is very unstable
and totally locks up many times a day. This is on Windows 98 with only 64
meg of RAM.

Is this simply a memory issue, or is this configuration giving everyone else
fits as well???




Tim Claremont
Xerox Corporation

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



RE: vb script in .cfm templates?

2000-10-02 Thread Dave Watts

 showing my M$ VB ignorance hereif we are on a IIS/M$ 
 platform, can we run VB script in a .cfm template?

No, you can't directly run VBScript from within a cfm file. You can,
however, write a Windows Script Host file in VBScript, and run that through
CFOBJECT (if your script file is a Windows Script Component) or via the
command line with CFEXECUTE.

 Or is there a better way to force a table of data to a 
 fixed-width text file?

I'm not sure what you mean by this, but if you're simply trying to generate
comma- or tab-delimited text, you can do this very easily from within CF.
Here's an example:

http://www.figleaf.com/demo/mimetest/

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: (Admin) Delays and doubles

2000-10-02 Thread Carol Chandler

Have you considered Lsoft (www.lsoft.com)?  They are the original Listserv people, and 
have not only the fastest and best ($$$) service around, but also economical versions 
as well.  I ran a list hosted there, with their "Home Ease" service, and there was 
just no comparison between it and the free lists around.  Pricing starts at $8/month, 
and 300 people on a list costs $34/month.  They also have spiffy archives available 
for 25 cents/MB/month, and more spam fighting features than any other list I've seen.  
You can get a free version of ListServ Lite to host on your own server, too.

(I don't work for them and have no connection... just a satisfied customer wishing 
that all of the lists I'm on were hosted at Lsoft.)

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



File Compare

2000-10-02 Thread j p

Dose anyone have a good way to do a file compare??? (via CF)

_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at 
http://profiles.msn.com.

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



RE: Examples of upload interfaces

2000-10-02 Thread Steven Katz

Hmm, I hope this isn't a one-or-the-other situation. I guess examples 
of both would be the most useful in creating my own.

Thanks,
Steven


-Original Message-
From: Steve Bernard [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 28, 2000 1:22 PM
To: CF-Talk
Subject: RE: Examples of upload interfaces


Do you mean nice looking or nice functionality?

Steve


-Original Message-
From: Steven Katz [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 28, 2000 1:32 PM
To: CF-Talk
Subject: Examples of upload interfaces


Hi,

Could anyone refer me to sites with nice examples of upload 
interfaces (for allowing uploading documents or imagery to the 
server)?

Thanks.

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



RE: Page output

2000-10-02 Thread Dave Watts

 I believe Cold Fusion withholds page output until the entire
 page is completed. Is there anyway to make it flush out, like
 Response.flush in ASP?

Unfortunately, no. There's no analog to the page buffering control
functionality found in ASP.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: CFLOCK Cached Query

2000-10-02 Thread Dave Watts

 Should I CFLOCK the following query?
 
 CFQUERY NAME="Request.GetListings" DATASOURCE="#request.DSN#" 
 USERNAME="#request.USER#" PASSWORD="#request.PASS#"  
 cachedwithin="#createtimespan(0,0,15,0)#"
 SELECT ID,org_name,contact,city,website_bt,email_bt,classified_bt,
 fax_bt,TList
 FROM Orgs (nolock)
 WHERE Class = #VAL(request.hdg_id)#
 CFIF "#CLIENT.CITY#" IS NOT "All Cities" AND City = 
 '#CLIENT.CITY#'/CFIF
 ORDER BY org_name
 /CFQUERY
 
 For different values of request.hdg_id or CLIENT.CITY, CF 
 will cache the correct dataset for NEXT/PREVIOUS display of 
 results on a page (since CF caches reference the SQL too, and 
 not just the cfquery name). There are potentially many DIFFERENT 
 datasets, ALL titled Request.GetListings (in the CF template, that 
 is). For example, CF will cache one dataset where CLIENT.CITY is 
 New York, and another dataset where CLIENT.CITY is Chicago, 
 and they apparently happily co-exist.
 
 But what happens if we followed Allaire's best practices (in 
 CF4.5 syntax):
 
 cflock scope="application" timeout="2" type="exclusive"
  cfset application.GetListings = Request.GetListings
 /cflock
 
 Would the potentially several queries/datasets all named 
 Request.GetListings (in the CF template) be kept distinct 
 when they are named application.GetListings?

First, you shouldn't CFLOCK the query. All CFLOCK does is limit who can
execute the code at a given time. You don't have any memory variables within
the query that need to be protected from concurrent accesses, so you don't
need to use CFLOCK.

Second, cached queries aren't stored the same way as persistent memory
variables are stored. That is, they're not simply identified by name. You're
only going to have one variable called Request.GetListings (or
Application.GetListings) and that variable will contain whatever you put
into it. Query caching only comes into play when you execute a CFQUERY tag
with a caching attribute - CF looks to see whether there's a matching
recordset already cached.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Date Timestamp??

2000-10-02 Thread Dave Watts

 If you are wanting to put the current date and time try this:
 
 #CreateODBCDateTime(Now())#
 
 That will insert the current date and time as a timestamp

Actually, the CreateODBCDateTime function isn't required here, as the Now
function creates an ODBC date/time stamp.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Any Security Concerns Here? Passing Token in URL [CF-Talk]

2000-10-02 Thread Dave Watts

  So if I think this out logically, the ONLY way to ensure 
  absolute security is if the user has their cookies turned on.
 
 Well...  That's not 100% secure either.  It *is* possible for a
 malicious user to share his cookies with others.  A malicious user
 could ALSO manually add ?CFID=XXXCFTOKEN=XXX to any URL on their
 site  assume someone else's session.

I'd like to second that. Cookies, like anything else sent from the browser
to the server, can be manipulated by the end user. It's pretty trivial to
see what cookies you've received, then send back different cookies.

 And speaking of cookies...  I am inclined to wonder what the big deal
 about cookies is.  All of our CF sites require cookies, and I've yet
 to get any complaints about them.

The big deal about cookies is the way that they can be used by ad providers
like DoubleClick. Since lots of sites use ads, you might have something like
this happen:

1. User goes to http://www.imagoodperson.com.
2. Ad banner on that site is drawn from http://evilads.com.
3. The evilads server sets a cookie, and records that the cookie was set for
a visitor to imagoodperson.com.
4. User later goes to http://www.pornyoudbeashamedof.com/.
5. Ad banner on that site is also drawn from http://evilads.com.
6. The evilads server receives the cookie back, and records that the cookie
was received.

As a result, evilads.com now has recorded that somebody visited
imagoodperson.com and pornyoudbeashamedof.com. In addition, if
imagoodperson.com had an affiliation with evilads.com, it's possible that
imagoodperson.com has revealed any personal info you provided to them to
evilads.com, which could then correlate that info with the other info
they've already recorded.

This is what's happening right now - this is what ad providers do. Given
that this practice actually occurs, it's easy to see why the mainstream
press says "cookies bad" - it's pretty hard to differentiate between "good"
and "bad" uses of cookies.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Line count of 1600 files?

2000-10-02 Thread Dave Watts

 Many years ago I worked for a large Japanese Multinational 
 and my manager, who was (is) very respected there actually 
 told us once "a good programmer is known by the quantity of 
 code he generates."
 They had all kinds of source code line-counts and even put up 
 graphs showing which programmer is "best" at any given time. 
 It got so ridiculous that when talk of bonuses tied to these 
 metrics started floating, we all were in a race to see who 
 could generate the most bloated code. None of us hid this 
 fact from the manager, we laughed about it thinking finally 
 they would see how silly this metric was. Nope. He loved it 
 and reported back to Tokyo that we were really getting into 
 the company policies.
 
 Needless to say, no decent programmers stayed there long.

If a good programmer is known by the quantity of generated code, a great
programmer writes code generators!

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Ok, What is Fusebox?-- Reply to Peter

2000-10-02 Thread Dave Watts

(re: Fusebox as security provider)

 First off this is mis-stated. One of the appealing points of 
 fusebox is that you can lock down all of those function and 
 object tags (whoops did I say objects?) with only 3 lines of 
 code in your application.cfm. That is, if the request is not 
 coming from index.cfm, then send them to index.cfm. So you can 
 htr or ::DATA$ me all you want and all you are going to see is 
 an index page which paths to a bunch of templates/modules that 
 you are never going to access unless you do it the way my logic 
 provides. By this, I mean if you see a tag call or path to some 
 template, you are never going to be able to call that template 
 by itself. So if you figure out that my order processing is done 
 on act_process_order.cfm, and you try calling that template by 
 itself through the browser with a .htr or ::DATA$, application.cfm 
 is going to see that the request is not coming from index.cfm and 
 send you to the front of my website or wherever it is that I
 choose to send you. So its not "You can call any template 
 from a browser", rather it prohibits this. This, is in fact a 
 different means of your current goal. Its just easier to implement.  

Without getting into another discussion of the merits of Fusebox as an
application development methodology, I have to point out that it doesn't
provide any additional security for your application.

The two exploits that you list above, both IIS-specific, rely on the
behavior of the web server to retrieve files before those files are
processed by the CF server. This happens before any CF code is run, so
application.cfm won't redirect the user. So, on a server with either of
those two security holes, if I specifically request the appropriate CF file,
no matter where it's buried withing the document root of the web server, IIS
will retrieve the file and show me the source code. If I wanted to
compromise the source code on a site using Fusebox, I could simply view the
source code of the index page, read the CFINCLUDE tags, then request to view
the source code of those included files. Trust me on this - or better yet,
test it yourself.

A better security solution is to make sure that source code can't be viewed
from the browser. There are several ways you can make this happen:

1. Close all known security holes (a leap into the obvious).

2. Remove unnecessary functionality.
As an example, the .htr exploit can only be used against a server if that
server is still configured to map .htr to an ISAPI extension. On the servers
that we administer (thankfully, very few servers), we'd removed that mapping
before the exploit was public knowledge, since we didn't want to use the
functionality that it provided. This is a standard part of IIS configuration
best practices as described by Microsoft - don't leave it on if you aren't
going to use it.

3. Use NT security.
The CF server needs execute permissions. The IIS user needs to be able to
check file permissions. That's really all you need to enable. Note the lack
of "read" permissions for the IIS user. If you configure your server with a
minimal set of permissions, source code reading exploits will fail.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: O'Reilly Website

2000-10-02 Thread Dave Watts

 Know of anything like this that runs on IIS ???

You can manipulate IIS through the ADSI interface, which is what's used by
the HTML Administrator that comes with IIS. You can call ADSI through
Windows Script Host; there are a bunch of sample WSH files for administering
IIS that get installed by default with IIS. I think they're in the
"adminscripts" directory.

In addition, there are third-party products which make this a little easier.
I believe Lewis Sellers has a CFX for this at
http://www.intrafoundation.org/.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: access to SQL server woes

2000-10-02 Thread Dave Watts

 One other thing that tripped me up recently is that even if 
 you've enter a username and password for the ODBC datasource 
 within the control panel applet, you still have to enter them 
 in CF's ODBC setup.

The username and password you enter in the ODBC control panel are only used
to test the datasource and connect for the purpose of setting further
options. They're not stored in the registry, and aren't used by applications
using the DSN. So, if you're not using a trusted connection (which uses the
rights of the NT user running the connection - typically the Local System
security context), you'll have to specify a username and password, which
you'd do from CF's datasource setup as you've noticed.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Template not found. Which template?

2000-10-02 Thread Dave Watts

 You could AND SHOULD secure NON-Fusebox sub-templates with 
 something like the following:
 
 cfif http_referrer does not contain "#server_name#"
   
   cfabort
 
 /cfif

If you're concerned about security, you can't rely on HTTP_REFERER, which is
provided by the browser. Any data from the browser is subject to tampering.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: CFTRANSACTION only works in same page?

2000-10-02 Thread Dave Watts

 i have a complex transaction that i have grouped into 
 multiple includes. i am trying to wrap them into a transaction 
 so that if any part fails, i can rollback.
 
 cftransaction action="begin"
cfinclude template="part1.cfm" (if exception, rollback)
cfinclude template="part2.cfm" (if exception, rollback)
cfinclude template="part3.cfm" (if exception, rollback)
 /cftransaction
 
 however, if i have an error in part2, everything in part1 is still
 committed. AND, if i try to set cftransaction action="rollback"/ 
 to any included file, it gives me an error saying that it's not 
 wrapped in a cftransaction.
 
 am i to assume from this that i can't use cftransaction to group
 includes? seriously?

Your assumption is correct.

CFTRANSACTION tags must be contained within the same script. This isn't
listed within the documentation, as far as I can tell, but it is known by
Allaire (it's discussed within the Advanced CF Development class). This
behavior is intentional, and there's a pretty strong logical justification
underlying it - you want transactions to be as short and atomic as possible,
and you don't want to start a transaction with the possibility that you
won't declare an end to that transaction.

In any case, you're much better off migrating your transactional logic to
your database using stored procedures.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Fusebox [CF-Talk]

2000-10-02 Thread Dave Watts

 Why are people so hell bent on OO, lets face it OO seems to 
 be a good idea. But good ideas cost us in the long run. Lets 
 look at c++ for instance, before c++ was introduced programs 
 where smaller memeory wasn't and issue and hard drive space 
 either was not an issue. Then somwhere along the lines we began 
 coding with OO, then we needed 10 times as much memory and now 
 we need thousands more hardrive space.

People are "hell bent" on OO because it solves quite a few problems, and in
cases where it's the appropriate answer, the fact that OO code is less
efficient from a performance standpoint is outweighed by its advantages.

 Ask a games developer what the prefer and you will find that 
 they opt out of oo big time, remember that when you inheret a 
 class you inherit everything about that class everytime you 
 need it. So this means that the code runs slower becuase it 
 has more work to do, it becomes larger because it has more
 code that is compiled that is maybe not needed.

While I respect game developers as much as anyone else does, asking a game
developer what they prefer is relevant if you want to develop games, but not
necessarily if you want to develop business applications.

Game developers build applications which fit within a specific niche - where
performance and efficiency count more than anything else. They can't afford
to waste resources in storage or calculation.

Business developers, on the other hand, build applications within a
different niche - where maintenance and extensibility count more than
anything else. They can't afford to build applications that are so low-level
and tightly written that they can't be maintained.

I'm a big fan of Quake, but I don't think people will be playing it twenty
years from now. A successful business application may well be in existence
that long, or longer - just ask all the COBOL developers who were patching
applications last year!

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: CF and Apache on Windows NT

2000-10-02 Thread Dave Watts

 Does anyone have a production-level application running on 
 Apache using CF (and Spectra)? I am investigating using it, 
 but the warnings for Win32 have me concerned. Switching to 
 UNIX is not an option unfortunately, although I wish we
 could -- politics you know.

Although I'm a fan of Apache, and use it frequently for personal
development, I'd recommend against using it on NT if you expect any serious
traffic. In my (admittedly limited, non-production) experience, you'll start
getting Winsock connection errors under heavy load.

I'd recommend using IIS on NT or Win2K.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: TO ALL: Request for ColdFusion SP2 Input

2000-10-02 Thread Dave Watts

 i know one of the items that makes me very uncomfortable is 
 the apparent code incompatibility on the locking issues. i.e. 
 code written for CF server 4.5.1 locking doesn't easily work 
 on 4.0 and vice versa..

This isn't really the case. Code using CFLOCK under CF 4.0.1 will work on a
4.5.1 server. Code using the SCOPE attribute of CFLOCK under 4.5.1 won't
work in 4.0.1, since 4.0.1 doesn't have a SCOPE attribute, but that kind of
thing happens anytime you use the latest features of the language.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: CF and Python

2000-10-02 Thread Dave Watts

 Not sure if proper to ask this question. How can I integrate 
 Python into CF?

If you're building COM interfaces with Python, you might be able to use
CFOBJECT. Alternatively, you could use CFEXECUTE to call your script from
the command line.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: CF and Apache on Windows NT

2000-10-02 Thread Dave Watts

 Apache Runs pretty well with CF on NT.  Apache uses less 
 memory than IIS, that's for sure.

Actually, this isn't necessarily so. Under heavier load, IIS has both worked
better and consumed less memory, in my experience. I've used both to teach
the Allaire Performance Tuning class, and Apache would break under load much
more quickly.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: OT: Bind problems

2000-10-02 Thread Bob Silverberg

Although I am loathe to start a flame war, I just have to say that I find
the following post extremely offensive.  Please try to refrain from
broadcasting your personal prejudices when posting to a public listserve.

Thanks,
Bob


-Original Message-
From: Len Conrad [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 02, 2000 11:36 AM
To: CF-Talk
Subject: Re: OT: Bind problems



   I'm trying to create a "fake"
test Domain as part of a project. For example I just created
www.wluke-testing.co.uk - the Bind file was called db.wluke-testing.co.uk
and obviously I entered the entry into named.boot.

But I can't get it to resolve.  Do I have to wait a set period of minutes
until it'll resolve?

Yes, like a woman, it has warm up for best results.

If your machine's "DNS client" aka "resolver" is pointing at that
DNS, the zone's records are availailable immediately after you
stop/start BIND (this smells like a BIND4 vintage) to re-parse the
named.boot and any changes in the zone files or new zone files.

Len


http://BIND8NT.MEIway.com: ISC BIND 8.2.2 p5  installable binary for NT4
http://IMGate.MEIway.com:  Build free, hi-perf, anti-spam mail gateways


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



Re: Bugged Out CFERROR - CFMLInterpreterImp::process

2000-10-02 Thread Jerry Tolentino


I found out what the problem was and it almost freaks me out. I don't know
if ColdFusion or SQL is to blame yet.

The problem seems to occurr when you pull data from a table whose column
identity seed is 0. Don't ask me why (at least not yet)? I just know that
did for me.

I changed the identity seed to 1 and it worked perferctly.





"Fred T. Sanders" [EMAIL PROTECTED] on 10/02/2000 11:46:19 AM

Please respond to [EMAIL PROTECTED]

To:   CF-Talk [EMAIL PROTECTED]
cc:(bcc: Jerry Tolentino/SIAC)
Subject:  Re: Bugged Out CFERROR - CFMLInterpreterImp::process




Fair enough, I didn't read it thoroughly, no coffee yet.

Okay need more info.

OS on the server
version of CFAS running
version and brand of database.

Also is that the complete error or are there other sorid details being
displayed that you didn't cut and paste for us.

Fred

- Original Message -
From: "Jerry Tolentino" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Monday, October 02, 2000 10:55 AM
Subject: Re: Bugged Out CFERROR - CFMLInterpreterImp::process


 That has nothing to do with this error. ASC is the default sort type on
 SQL. And just for the record I tried what you suggested and nothing
 happened.

 Jerry T.




 "Fred T. Sanders" [EMAIL PROTECTED] on 10/02/2000 09:59:45 AM

 Please respond to [EMAIL PROTECTED]

 To:   CF-Talk [EMAIL PROTECTED]
 cc:(bcc: Jerry Tolentino/SIAC)
 Subject:  Re: Bugged Out CFERROR - CFMLInterpreterImp::process




 get rid of the ,sortorder  it should just be a space and either ASC or
DES
 - Original Message -
 From: "Jerry Tolentino" [EMAIL PROTECTED]
 To: "CF-Talk" [EMAIL PROTECTED]
 Sent: Monday, October 02, 2000 9:54 AM
 Subject: Bugged Out CFERROR - CFMLInterpreterImp::process


  I got the following error when making a call to a custom tag.
 
  Here are the facts:
1. I know the tag works. Its been tested and other applications use.
2. I have tried several methods of calling the tag including the
  following:
   - calling from the same directory using both CFMODULE and
  CF_customTag
   - calling from a subdirectory using CFMODULE
   - calling from coldfusions custom tag directory using
 CF_customTag
3. Heres the strange one. A query is passed to the Custom Tag. The
tag
  works with the following query (its from of the applications using it):
 
CFQUERY NAME="NodeListQuery" DATASOURCE="Datasource1"
  SELECT Identifier AS ID, ParentNode AS
  ParentID, Name AS Label
  FROM Node
  ORDER BY ParentNode, SortOrder
/CFQUERY
 
when I change the query to pull data from another table and
  datasource it chokes. I know the data is pulling I tested it. Here is
 that
  query:
 
CFQUERY NAME="NodeListQuery" DATASOURCE="GenericHelp"
  SELECTIdentifier AS ID, Parent AS ParentID,
  Name AS Label
  FROMTopic
  ORDER BY ParentID, SortOrder
/CFQUERY
 
4. Here is the error:
 
   Error Diagnostic Information
   unknown exception condition
 
   CFMLInterpreterImp::process
 
  Any help on this one will be greatly appreciated. Thanks in advance.
 
  Jerry
 
 
 

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



Restarting DNS (Was Re: OT: Bind problems)

2000-10-02 Thread W Luke

Thanks for everyone's reply - naturally it was a typically small problem -
hitting a button on another machine to reload the DNS.

However...how could I do this in CF?

Will
- Original Message -
From: "Len Conrad" [EMAIL PROTECTED]
Newsgroups: cf-talk
Sent: Monday, October 02, 2000 4:35 PM
Subject: Re: OT: Bind problems



I'm trying to create a "fake"
 test Domain as part of a project. For example I just created
 www.wluke-testing.co.uk - the Bind file was called db.wluke-testing.co.uk
 and obviously I entered the entry into named.boot.
 
 But I can't get it to resolve.  Do I have to wait a set period of minutes
 until it'll resolve?

 Yes, like a woman, it has warm up for best results.

 If your machine's "DNS client" aka "resolver" is pointing at that
 DNS, the zone's records are availailable immediately after you
 stop/start BIND (this smells like a BIND4 vintage) to re-parse the
 named.boot and any changes in the zone files or new zone files.

 Len


 http://BIND8NT.MEIway.com: ISC BIND 8.2.2 p5  installable binary for NT4
 http://IMGate.MEIway.com:  Build free, hi-perf, anti-spam mail gateways

 --

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



RE: Time Zone Select

2000-10-02 Thread lsellers



 Anyone out there have a custom tag or data table that would allow me to
 easily include a select box for choosing time zone?

Make a 24-piece rollover of the earth. Then just let them click where they
are. Easire than choosing by text -- no one knows what the hell time zone
they're in. :)

--min

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



Re: CFServer a memory leaker?

2000-10-02 Thread Todd Ashworth

When I upgraded studio to 4.5.1, my computer died a horrible, agonizing,
low-memory death many times a day, even with 160 megs of RAM.  I switched
back to 4.5a and the problem wen away.  I think there is a definite issue
with Studio 4.5.1, Win98, and memory leaks.

Todd Ashworth

- Original Message -
From: "Claremont, Timothy S" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Monday, October 02, 2000 11:54 AM
Subject: CFServer a memory leaker?


| At home I have installed CFSERVER running on Personal Web Server, using
RDS.
|
| Since I have installed both server and studio, my system is very unstable
| and totally locks up many times a day. This is on Windows 98 with only 64
| meg of RAM.
|
| Is this simply a memory issue, or is this configuration giving everyone
else
| fits as well???


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



maxlength on text area

2000-10-02 Thread Robert Everland

Is there a way to set a maxlength on a textarea using javascript or any
other method.

Robert Everland III
Web Developer
Dixon Ticonderoga

-- eGroups Sponsor -~-~
Restaurants, Movies, Weather, Traffic  More!
Call 1-800-555-TELL.  For more info visit:
http://click.egroups.com/1/9533/5/_/702756/_/970508758/
-_-

To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]






Windows 2000??

2000-10-02 Thread HappyToad.com

How many of you are using Windows 2000 on your pc?  I am getting really
tired of win98 problems and are wondering how much better win 2000 is.

Thanks,
Rich

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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.

2000-10-02 Thread Hoffman, Joe (CIT)

Mine just started to flake out also ... but CFAS451sp1 Pro on Win2k and 
WSP2.4.9.  Last relevant modification was the installation of CFAS451sp1 
last Wednesday I think.

Any clues anybody ?

-
Error Diagnostic Information
Just in time compilation error

SSRef0001e: Reference count less than zeroAn unexpected parser error has
occurred during the evaluation of the expression.
The error is usually caused by the ColdFusion server running low on memory
and/or system resources. However, in rare cases, the error may be caused by
invalid expression syntax. Check the syntax of the expression against the
ColdFusion manual.

The last successfully parsed CFML construct was the CFML template beginning
occupying document position (1:1) to (1:1).
-
What is 'SSRef0001e Reference count less than zero'?  What reference?

Joe Hoffman mailto:[EMAIL PROTECTED]
National Institutes of Health 
Center for Information Technology 
Division of Computer System Services

-Original Message-
From: Dave Wilson [mailto:[EMAIL PROTECTED]]
Sent: Saturday, September 30, 2000 12:55 PM
To: CF-Talk
Subject: URgent CFServer maxing CPU and JIT error on Production Server.


Hi all,

We've recently moved a number of production sites onto a new server and are
now experiencing instances where the CPU is maxing out and lots of instances
of the following error throughout the different sites at seemingly random
places and times.

Error Diagnostic Information
Just in time compilation error

unknown parser error

The last successfully parsed CFML construct was the CFML template beginning
occupying document position (1:1) to (1:1).

Can anyone shed any light on what might be causing this?

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
Co-Founder CFUG Ireland

BizNet Solutions
Allaire Premier Partner
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=listsbody=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=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: CFServer a memory leaker?

2000-10-02 Thread Stewart, Mark

Tim,

I'm basically running the same thing: Win98, CFServer, CFStudio, PWS, Intel
Celeron 300 (overclocked to 450) and 128 RAM. I've had a few problems, but
nothing major. This configuration works quite well for what I use it for.
Now, I wouldn't use this for any type of production scenario, but it works
well for just playing around at home. I also run many other programs on this
machine as well: MS Office, numerous games, mem turbo and Zone Alarm.

I would definitely beef-up the RAM on your machine and it should act a
little better.

For what it's worth,

~Mark

-Original Message-
From: Claremont, Timothy S [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 02, 2000 11:54 AM
To: CF-Talk
Subject: CFServer a memory leaker?


At home I have installed CFSERVER running on Personal Web Server, using RDS.

Since I have installed both server and studio, my system is very unstable
and totally locks up many times a day. This is on Windows 98 with only 64
meg of RAM.

Is this simply a memory issue, or is this configuration giving everyone else
fits as well???




Tim Claremont
Xerox Corporation


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



RE: File Compare

2000-10-02 Thread Larry Juncker

YES - ARAXIS 2000

Super program - goto

http://www.araxis.com


Larry Juncker
Senior Cold Fusion Programmer
Heartland Internet

-Original Message-
From: j p [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 02, 2000 10:59 AM
To: CF-Talk
Subject: File Compare


Dose anyone have a good way to do a file compare??? (via CF)

_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at
http://profiles.msn.com.


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



Re: vb script in .cfm templates?

2000-10-02 Thread Dick Applebaum

You can't use VBS and CF in the same template, but a CF template can 
transfer to a ASP template  vice versa.

Each can also invoke the other (CFHTTP).

That said, you can easily go from db to text file using CFQUERY and CFFILE.

HTH

Dick

At 10:34 AM -0500 10/2/00, Eric Hoffman wrote:
showing my M$ VB ignorance hereif we are on a IIS/M$ platform, 
can we run VB script in a .cfm template?  Or is there a better way 
to force a table of data to a fixed-width text file?

Thanks for any pointers.

Eric

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



Dave Watt's Alive well.....

2000-10-02 Thread JustinMacCarthy

Ah Dave, you ARE still with us :-)   I was beginning to wonder ...

~Justin MacCarthy


- Original Message - 
From: "Dave Watts" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Monday, October 02, 2000 5:04 PM
Subject: RE: Date Timestamp??



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



RE: Protecting Content / content leeching... A CF method?

2000-10-02 Thread lsellers


As anyone who's ever worked with HTTP at the protocol level (or with CFHTTP)
can tell you, the way it works is you fetch the html (or cfm) document in
question, then parse through it looking for all the img url, then fetch them
BASED ON THIER URL.

Thus it's impossible to protect them. You can use cfcontent with a cfm to
obsure their actual physical location. But whether the image is at
"images\bob.gif" or "images.cfm?image=bob.gif" they still retrieve the
content for display (or to save).

You could do additional cgi user agent and refer(r)er checking to stop
casual direct grabs from the browser command line, but it won't stop
anything else.

Since it's a relative url based the wwwroot of the domain I'm not sure why
it would matter anyway unless the images are to be password protected..

--min

 The issue is not to make a document not available to someone who
 can see it
 but to someone who cannot see it...

 Case in point...  the img src="..." tag will let you know that a file is
 located at /a/b/file.jpg
 so you could go to the location bar and look for that image.  You
 could get
 tricky and try to view other files located at that location...
 /a/b/anotherfile.jpg.  For us, that is a problem.  The img tag reveals a
 little too much information.

 So the concern is not so much the document itself, but rather the
 ability to
 figure out where it is located.  It's been recommended to me to use CF
 mappings to substitue for that, problem is that CF mappings, as far as I
 know, do not work with the IMG tag, let alone the EMBED tag.

 So I am left with the CFCONTENT tag, problem with the content tag
 is that it
 takes over the entire screen.  I've tried to embed it in a layer
 or IFRAME,
 but it still takes over the whole window.

 There are a few PERL scripts out there that "mask" the path to
 the file.  So
 by typing www.mydomain.com/getstuff.cgi?image.jpg, the script
 would display
 the image but masking it's location (which in reality is not a
 web location,
 but a physical location on the web server [c:\...]) This works well except
 that all the scripts that I have tried choke (by that I mean render only
 part of) the file.  regardless of the MIME type.  I think the problem is
 that those scripts were written on UNIX, and we are on WIN2K.

 So that is where we are.

 Note that the last option (the PERL option) is still not exactly
 what we are
 looking for because of
 1. security problems with CGI scripts in general
 2. it does not work with the IMG tag.

 Nadir

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



RE: CFQUERY BLOCKFACTOR

2000-10-02 Thread Dave Watts

 CF Docs on the Subject are as follows:
 
 "Optional. Specifies the maximum number of rows to fetch at a 
 time from the server. The range is 1 (default) to 100. This 
 parameter applies to ORACLE native database drivers and to ODBC 
 drivers. Certain ODBC drivers may dynamically reduce the block 
 factor at runtime."
 
 A recent article in SQL Server Magazine (October 2000, p 75) 
 discusses "BLOCKING FACTOR"
 
 "BLOCKING FACTOR" bears some resemblance to "BLOCKFACTOR," 
 but I'm not sure how close it is.
 
 BLOCKING FACTOR appears to be determined by the width of a 
 RECORD, as it exists in the DB (that is, it includes all columns).
 
 I've assumed BLOCKFACTOR to be determined by the width of the 
 RETURNED DATA in each record, which does not have to include 
 all columns.
 
 I further assumed a CFQUERY that returned a single column of 
 integers could have BLOCKFACTOR set at the maximum of 100, 
 without fear of loss of efficiency as in those cases where 
 100 happened to be too large and CF would then have to try 
 99, then 98, etc.
 
 So the question is: Is 100 ALWAYS OK when CFQUERY returns a 
 single column of integers?

Your assumptions about how BLOCKFACTOR works are correct. There's a formula
for determining the appropriate BLOCKFACTOR value for a given query:

1. The size of the buffer used by BLOCKFACTOR is 32k.
2. You can store the number of rows that will fit within the buffer.

So, the formula is:

32768 bytes / row size in bytes

Of course, in many cases, you might only have a rough number (when using
varchar columns, for example).
 
 PS Keeping in mind that CF4.01 Administrator (but not 4.51 
 Administrator) is now known to have incorrectly stated there 
 to be limit of 100 cached queries, whereas there really is no 
 fixed limit, is BLOCKFACTOR _really_ limited to 100?

I don't know. I haven't tested this. However, in real-life use, it's
unlikely that you'd even get to 100 using most queries.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



vb script solved, now DUN

2000-10-02 Thread Eric Hoffman

Ok, found the custom tag to dump my queries to a comma delimited file which is good 
enough...

now, I know cfexecute works code on the server...I need to force a specific Dial-Up 
Networking connection to start at the user's machineis that possible?  Something 
similar to cfexecute? Any more guidance would be appreciated.

Thanks!

Eric


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



Sharing sessions between CFM ASP

2000-10-02 Thread Geoffrey V. Brown


Hi,
I have a session var that needs to be shared between a CFM script and an ASP
script on the same server (same domain, etc).

Is this possible?  How?

- Geoff B


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



RE: CFLOCK Cached Query

2000-10-02 Thread paul smith

So are you saying we don't need to follow Allaire's Best Practices 
recommendation?  (This is where the cflock example below came from.)

Or, is your statement "First, you..." referring to something else?

best,  paul

At 12:04 PM 10/2/00 -0400, you wrote:

  cflock scope="application" timeout="2" type="exclusive"
   cfset application.GetListings = Request.GetListings
  /cflock

First, you shouldn't CFLOCK the query. All CFLOCK does is limit who can
execute the code at a given time. You don't have any memory variables within
the query that need to be protected from concurrent accesses, so you don't
need to use CFLOCK.

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



RE: CFLOCK Cached Query

2000-10-02 Thread Dave Watts

   cflock scope="application" timeout="2" type="exclusive"
cfset application.GetListings = Request.GetListings
   /cflock
 
  First, you shouldn't CFLOCK the query. All CFLOCK does is 
  limit who can execute the code at a given time. You don't 
  have any memory variables within the query that need to be 
  protected from concurrent accesses, so you don't need to use 
  CFLOCK.
...
 So are you saying we don't need to follow Allaire's Best Practices 
 recommendation?  (This is where the cflock example below came from.)
 
 Or, is your statement "First, you..." referring to something else?

I was saying that you shouldn't place the CFQUERY tag within a CFLOCK, which
was your original question, as I understood it:

 Should I CFLOCK the following query?
 
 CFQUERY NAME="Request.GetListings" DATASOURCE="#request.DSN#" 
 USERNAME="#request.USER#" PASSWORD="#request.PASS#"  
 cachedwithin="#createtimespan(0,0,15,0)#"
 SELECT ID,org_name,contact,city,website_bt,email_bt,classified_bt,
 fax_bt,TList
 FROM Orgs (nolock)
 WHERE Class = #VAL(request.hdg_id)#
 CFIF "#CLIENT.CITY#" IS NOT "All Cities" AND City = 
 '#CLIENT.CITY#'/CFIF
 ORDER BY org_name
 /CFQUERY

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Need help for getting more than 64K text out from Oracle

2000-10-02 Thread Chen, Yung-Chih (CIT)

Hi,
Does any one know how to get out text (more than 64k) from Oracle?
We have a column which contains more than 64k text in there. When I do the
cfquery to get
that column out, it will only display 64K text if the column value is great
than 64K.

Any suggestion is very helpful!

Thank you.

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



RE: Fusebox [CF-Talk]

2000-10-02 Thread Gavin Myers

I thought more game developers prefer OO...

To bring it back (way back) take a look at moocode (who here programmed in a
MU*)
Or to bring it up, look at director lingo script

I recently made a game in director, you were a guy who walked around a maze
with a laser rifle trying to explode these buzz saws before they killed you.
I am familair to OO (thanks to moocode) and I knew that director supported
programming in OO, but since I didn't know how to script it in director I
was forced to build the game non-oo.

So my buzz saws all did the same action, they would approach the person.
Once that person intersected them they would kill it. And one laser shot
killed it.

Had I developed it in OO, i could create a list of things like:
$generic_buzzsaw
verbs:
hit
die
move
properties:
buzz_saw_delay_factor: 4
buzz_saw_speed: 2
buzz_saw_strength: 5
buzz_saw_image: 3

Therefore I could re-use the one parent ($generic_buzzsaw) and create the
children that had different effects to them... without having to cut and
paste the code and changing a few variables around for each difference. 

*shrug*

oh, if anyone wants the game i can put it out on my web site, (its pretty
cheesy)


-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 02, 2000 11:07 AM
To: CF-Talk
Subject: RE: Fusebox [CF-Talk]


 Why are people so hell bent on OO, lets face it OO seems to 
 be a good idea. But good ideas cost us in the long run. Lets 
 look at c++ for instance, before c++ was introduced programs 
 where smaller memeory wasn't and issue and hard drive space 
 either was not an issue. Then somwhere along the lines we began 
 coding with OO, then we needed 10 times as much memory and now 
 we need thousands more hardrive space.

People are "hell bent" on OO because it solves quite a few problems, and in
cases where it's the appropriate answer, the fact that OO code is less
efficient from a performance standpoint is outweighed by its advantages.

 Ask a games developer what the prefer and you will find that 
 they opt out of oo big time, remember that when you inheret a 
 class you inherit everything about that class everytime you 
 need it. So this means that the code runs slower becuase it 
 has more work to do, it becomes larger because it has more
 code that is compiled that is maybe not needed.

While I respect game developers as much as anyone else does, asking a game
developer what they prefer is relevant if you want to develop games, but not
necessarily if you want to develop business applications.

Game developers build applications which fit within a specific niche - where
performance and efficiency count more than anything else. They can't afford
to waste resources in storage or calculation.

Business developers, on the other hand, build applications within a
different niche - where maintenance and extensibility count more than
anything else. They can't afford to build applications that are so low-level
and tightly written that they can't be maintained.

I'm a big fan of Quake, but I don't think people will be playing it twenty
years from now. A successful business application may well be in existence
that long, or longer - just ask all the COBOL developers who were patching
applications last year!

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444

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



RE: Fusebox [CF-Talk]

2000-10-02 Thread Jeremy Allen

Just to add a little to the "hell bent on OO"

Actually the statement "OO is slower than procedural"
is a murky one to make at best and flat outright WRONG
at worst.

C++ is a poor implementation of an Object Oriented language.

Java is better, Javas implementation also has its drawbacks.
However combining a natively compiled language as a standard
with a native executable compiler and I feel real sure that
C++ applications can run as fast as a procedural counterpart.

The problem is a language such as C has had over 20 years to
mature and there is so much out there and so much practical
use and experience with C compilers that they are very highly
optimized, especially on x86 platforms (MSVC++ is the fastest
on windows).

The point is OO in theory can be just as quick if not quicker
than a procedural compiled language. The programs dont take
up any more memory or more "processing" power to run, that
entire line of thinking seems a bit asanine to me. Like
saying this marble rolls faster than that one because
it is red.

Even given that most implementations all have their problems
give them time to mature, in the mean time enjoy the ease
of use of OO.

As far as game developers, I feel games fall into one of
those special categories that the rest of the world doesnt
really apply to (kind of like dave said :)))

Example: Just yesterday I had to hand optimize my graphics
drawing routine in assembler to gain that edge in performance
on my CF app... *NOT* hehe.

Of course game developers arent going to want OO, if you
downloaded the source to QuakeI (which is GPL'd) you would
see that it is all written entirely in C and it cuts corners
using the forbidden "goto" keyword ;), and several as low as it
gets graphics drawing routines in assembler. Business
apps dont need the speed.. period.  And a lot of the code is
sped up and when you optimize things you tend to make things
a little scarier, like reading assembler is harder than
reading C, and using two or three goto's even well commented
can obscure the purpose of the code even more. I just
dont see how writing reusable components with (currently) a
minor performance hit that can be easily negated with
proper configuration and a little more hardware, makes
OO a suddenly invalid method. I always have seen this
debate and my question at the end of it is, what SHOULD
we use if OO is so crapy? Go back to writing strictly
procedural code so that that financial record loaded
a half a second quicker but now the code is more complex
and prone to contain errors, is that a "solution" to the
"problem" that is OO programming?

Jeremy Allen
[EMAIL PROTECTED]

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 02, 2000 12:07 PM
To: CF-Talk
Subject: RE: Fusebox [CF-Talk]


 Why are people so hell bent on OO, lets face it OO seems to
 be a good idea. But good ideas cost us in the long run. Lets
 look at c++ for instance, before c++ was introduced programs
 where smaller memeory wasn't and issue and hard drive space
 either was not an issue. Then somwhere along the lines we began
 coding with OO, then we needed 10 times as much memory and now
 we need thousands more hardrive space.

People are "hell bent" on OO because it solves quite a few problems, and in
cases where it's the appropriate answer, the fact that OO code is less
efficient from a performance standpoint is outweighed by its advantages.

 Ask a games developer what the prefer and you will find that
 they opt out of oo big time, remember that when you inheret a
 class you inherit everything about that class everytime you
 need it. So this means that the code runs slower becuase it
 has more work to do, it becomes larger because it has more
 code that is compiled that is maybe not needed.

While I respect game developers as much as anyone else does, asking a game
developer what they prefer is relevant if you want to develop games, but not
necessarily if you want to develop business applications.

Game developers build applications which fit within a specific niche - where
performance and efficiency count more than anything else. They can't afford
to waste resources in storage or calculation.

Business developers, on the other hand, build applications within a
different niche - where maintenance and extensibility count more than
anything else. They can't afford to build applications that are so low-level
and tightly written that they can't be maintained.

I'm a big fan of Quake, but I don't think people will be playing it twenty
years from now. A successful business application may well be in existence
that long, or longer - just ask all the COBOL developers who were patching
applications last year!

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit

Date last modified (Access 2000)

2000-10-02 Thread seth ward

Is it possible to get the date that an Access 2000 database (linked via
ODBC) was last modified, regardless of whether it was done manually or
through CF???


Seth Ward


This message has been checked for all known viruses, by Star Internet,
delivered through the MessageLabs Virus Control Centre.
For further information visit:
http://www.star.net.uk/stats.asp

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



RE: CFQUERY BLOCKFACTOR

2000-10-02 Thread paul smith

I get to 100 all the time.  For example, I use Verity to get
a list of Record IDs whose data matches my search term, and
then use SQL with CFQUERY and BLOCKFACTOR = 100 to filter
the VERITY result set.

Of course, in this case any savings in having BLOCKFACTOR greater
than 100 is probably in the noise level compared to VERITY
inefficiencies.

BTW, are there any good resources on speeding up VERITY?

best,  paul

At 01:17 PM 10/2/00 -0400, you wrote:
  PS Keeping in mind that CF4.01 Administrator (but not 4.51
  Administrator) is now known to have incorrectly stated there
  to be limit of 100 cached queries, whereas there really is no
  fixed limit, is BLOCKFACTOR _really_ limited to 100?

I don't know. I haven't tested this. However, in real-life use, it's
unlikely that you'd even get to 100 using most queries.

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



RE: Ok, What is Fusebox?-- Reply to Peter

2000-10-02 Thread mherbene

What permission combination allows a user to check permissions, but not
read, a file?  And what tool do I use to set that perm?

thanks

 much snipped 
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 02, 2000 12:05 PM
To: CF-Talk
Cc: '[EMAIL PROTECTED]'
Subject: RE: Ok, What is Fusebox?-- Reply to Peter


(re: Fusebox as security provider)

 First off this is mis-stated. One of the appealing points of 
 fusebox is that you can lock down all of those function and 
Without getting into another discussion of the merits of Fusebox as an
application development methodology, I have to point out that it doesn't
provide any additional security for your application.

going to use it.

3. Use NT security.
The CF server needs execute permissions. The IIS user needs to be able to
check file permissions. That's really all you need to enable. Note the lack
of "read" permissions for the IIS user. If you configure your server with a
minimal set of permissions, source code reading exploits will fail.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444

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



RE: Windows 2000??

2000-10-02 Thread Simon Horwith

win2K is more stable than 98, that's for sure.  Personally, I still like NT
more, even if it doesn't support USB and all that other fun stuff.  I
recommend W2K if it's a choice between that and 98, though.
~Simon

-Original Message-
From: HappyToad.com [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 02, 2000 12:44 PM
To: CF-Talk
Subject: Windows 2000??


How many of you are using Windows 2000 on your pc?  I am getting really
tired of win98 problems and are wondering how much better win 2000 is.

Thanks,
Rich


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



RE: Windows 2000??

2000-10-02 Thread Alan Wolf

I've been running Win2K Professional on my laptop and it hasn't crashed
once. The apps may hang but the OS stays up.

-Original Message-
From: HappyToad.com [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 02, 2000 12:44 PM
To: CF-Talk
Subject: Windows 2000??


How many of you are using Windows 2000 on your pc?  I am getting really
tired of win98 problems and are wondering how much better win 2000 is.

Thanks,
Rich


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



RE: Time Zone Select

2000-10-02 Thread Jaime Garza

Long one, but here it goes.  SQL server compliant.  Missing Daylight Saving
Times.

CREATE TABLE DirTimeZone (
TimeZoneID int IDENTITY (1, 1) NOT NULL ,
Name varchar (50) NULL ,
Offset varchar (50) NULL
)
GO

insert into DirTimeZone (Name, Offset)
values ('ACT', 'GMT+09:30')
go

insert into DirTimeZone (Name, Offset)
values ('AET', 'GMT+10:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Abidjan', 'GMT+00:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Accra', 'GMT+00:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Addis_Ababa', 'GMT+03:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Algiers', 'GMT+01:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Asmera', 'GMT+03:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Bangui', 'GMT+01:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Banjul', 'GMT+00:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Bissau', 'GMT+00:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Blantyre', 'GMT+02:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Bujumbura', 'GMT+02:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Cairo', 'GMT+02:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Casablanca', 'Greenwich Mean Time')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Conakry', 'GMT+00:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Dakar', 'GMT+00:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Dar_es_Salaam', 'GMT+03:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Djibouti', 'GMT+03:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Douala', 'GMT+01:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Freetown', 'GMT+00:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Gaborone', 'GMT+02:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Harare', 'GMT+02:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Johannesburg', 'GMT+02:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Kampala', 'GMT+03:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Khartoum', 'GMT+02:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Kigali', 'GMT+02:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Kinshasa', 'GMT+01:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Lagos', 'GMT+01:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Libreville', 'GMT+01:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Lome', 'GMT+00:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Luanda', 'GMT+01:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Lubumbashi', 'GMT+02:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Lusaka', 'GMT+02:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Malabo', 'GMT+01:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Maputo', 'GMT+02:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Maseru', 'GMT+02:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Mbabane', 'GMT+02:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Mogadishu', 'GMT+03:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Monrovia', 'GMT+00:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Nairobi', 'GMT+03:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Ndjamena', 'GMT+01:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Niamey', 'GMT+01:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Nouakchott', 'GMT+00:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Ouagadougou', 'GMT+00:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Porto-Novo', 'GMT+01:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Sao_Tome', 'GMT+00:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Timbuktu', 'GMT+00:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Tripoli', 'GMT+01:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Tunis', 'GMT+01:00')
go

insert into DirTimeZone (Name, Offset)
values ('Africa/Windhoek', 'GMT+01:00')
go

insert into DirTimeZone (Name, Offset)
values ('AGT', 'GMT-03:00')
go

insert into DirTimeZone (Name, Offset)
values ('America/Adak', 'GMT-10:00')
go

insert into DirTimeZone (Name, Offset)
values ('America/Anchorage', 'Alaska Standard Time')
go

insert into DirTimeZone (Name, Offset)
values ('America/Anguilla', 'GMT-04:00')
go

insert into DirTimeZone (Name, Offset)
values ('America/Antigua', 'GMT-04:00')
go

insert into DirTimeZone (Name, Offset)
values ('America/Aruba', 'GMT-04:00')
go

insert into DirTimeZone (Name, Offset)
values ('America/Asuncion', 'GMT-04:00')
go

insert into DirTimeZone (Name, Offset)
values ('America/Barbados', 

Editing data with CFGRID

2000-10-02 Thread Michael Gagnon

Hi!

I created a spreadsheet style grid with CFGRID
(my first time) and I don't seem to be able to edit
the information in the table.  What am I doing wrong?

CFFORM method="POST" action="secteurs_submit.cfm"
CFGRID 
 name="Secteurs" 
 query="Secteurs" 
 SELECTMODE="SINGLE"
 width="100%" 
 height="100%"
/cfgrid
brinput type="Submit" value="Envoie"
/cfform

Thanks!

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



_date fields

2000-10-02 Thread Karl Simanonok

I've also experienced problems with form fields named 'something_date',
they don't get properly passed as form fields.  I think it has something
to do with CF's data input validation algorithm getting confused when it
doesn't find a 'something' field to do the validation on.  I've learned
(the hard way) to never name a form field with a _date suffix, except
for validating a date field.

Regards,

Karl Simanonok

Original message:
===
Date: Sun, 1 Oct 2000 11:13:17 -0400
From: Bud [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Re: Date fields in SQL
Message-ID: p0432040fb5fd043d4afa@[192.168.0.2]

On 10/1/00, W Luke penned:
Hi,

Well it's another Query problem for Will today - the error message is
telling me it can't find expiry_date field - in Access I've set the
date/time format to a custom dd-mmm-yy - is this the problem?  Here's
the
code:

For some reason, every now and again I have problems if I name
something underscore date. Try naming expirydate and see if that
helps.

And it wouldn't hurt to refer to today as #createodbcdate(today)#.
But that's probably not the problem.
--


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



Re: Windows 2000??

2000-10-02 Thread Howie Hamlin

WIN2K kicks righteous butt :-)

Seriously, though - it is stable as heck and great for a development
environment (it even runs games :-)

Regards,

Howie

- Original Message -
From: "HappyToad.com" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Monday, October 02, 2000 12:44 PM
Subject: Windows 2000??


 How many of you are using Windows 2000 on your pc?  I am getting really
 tired of win98 problems and are wondering how much better win 2000 is.

 Thanks,
 Rich

 --

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



RE: Windows 2000??

2000-10-02 Thread Jaime Garza

Change now!  That is, if you have lots of memory (256K?)  My last reboot: 2
weeks ago...  CF studio is a charm, except for the Alt+Tab bug.

Jaime/



-Original Message-
From: HappyToad.com [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 02, 2000 9:44 AM
To: CF-Talk
Subject: Windows 2000??


How many of you are using Windows 2000 on your pc?  I am getting really
tired of win98 problems and are wondering how much better win 2000 is.

Thanks,
Rich


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



RE: CFServer a memory leaker?

2000-10-02 Thread HappyToad.com

From what I have heard its not the RAM it the RESOURCES.  I have 256megs of
RAM and still have problems with CF Studio.
Rich

-Original Message-
From: Stewart, Mark [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 02, 2000 12:44 PM
To: CF-Talk
Subject: RE: CFServer a memory leaker?


Tim,

I'm basically running the same thing: Win98, CFServer, CFStudio, PWS, Intel
Celeron 300 (overclocked to 450) and 128 RAM. I've had a few problems, but
nothing major. This configuration works quite well for what I use it for.
Now, I wouldn't use this for any type of production scenario, but it works
well for just playing around at home. I also run many other programs on this
machine as well: MS Office, numerous games, mem turbo and Zone Alarm.

I would definitely beef-up the RAM on your machine and it should act a
little better.

For what it's worth,

~Mark

-Original Message-
From: Claremont, Timothy S [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 02, 2000 11:54 AM
To: CF-Talk
Subject: CFServer a memory leaker?


At home I have installed CFSERVER running on Personal Web Server, using RDS.

Since I have installed both server and studio, my system is very unstable
and totally locks up many times a day. This is on Windows 98 with only 64
meg of RAM.

Is this simply a memory issue, or is this configuration giving everyone else
fits as well???




Tim Claremont
Xerox Corporation


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



Re: Windows 2000??

2000-10-02 Thread Kevin Schmidt

I use win2K Server on my laptop and desktop and haven't had any problems
yet.  I like that fact of not having to reboot everytime I make a change to
my network settings.

Kevin Schmidt
Internet Services Director
PWB Integrated Marketing and Communications
Office: 734.995.5000
Mobile: 734.649.4843

- Original Message -
From: "HappyToad.com" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Monday, October 02, 2000 11:44 AM
Subject: Windows 2000??


 How many of you are using Windows 2000 on your pc?  I am getting really
 tired of win98 problems and are wondering how much better win 2000 is.

 Thanks,
 Rich

 --

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



Javascript string search question...

2000-10-02 Thread Kevin Langevin

Anyone know how to do a text string search in Javascript?  I've used
substring before, but I'm looking for some way to do something akin to
find() in CF, where it finds the substring ANYWHERE in the string to be
searched.  Is it necessary to do a character by character search, or is
there a javascript command to find any instance of the search string in the
string to be searched?

CFUG-SFL Manager
-Kev
/CFUG-SFL Manager

 -Original Message-
 From: Stewart, Mark [mailto:[EMAIL PROTECTED]]
 Sent: Monday, October 02, 2000 12:44 PM
 To: CF-Talk
 Subject: RE: CFServer a memory leaker?


 Tim,

 I'm basically running the same thing: Win98, CFServer, CFStudio,
 PWS, Intel
 Celeron 300 (overclocked to 450) and 128 RAM. I've had a few problems, but
 nothing major. This configuration works quite well for what I use it for.
 Now, I wouldn't use this for any type of production scenario, but it works
 well for just playing around at home. I also run many other
 programs on this
 machine as well: MS Office, numerous games, mem turbo and Zone Alarm.

 I would definitely beef-up the RAM on your machine and it should act a
 little better.

 For what it's worth,

 ~Mark

 -Original Message-
 From: Claremont, Timothy S [mailto:[EMAIL PROTECTED]]
 Sent: Monday, October 02, 2000 11:54 AM
 To: CF-Talk
 Subject: CFServer a memory leaker?


 At home I have installed CFSERVER running on Personal Web Server,
 using RDS.

 Since I have installed both server and studio, my system is very unstable
 and totally locks up many times a day. This is on Windows 98 with only 64
 meg of RAM.

 Is this simply a memory issue, or is this configuration giving
 everyone else
 fits as well???



 
 Tim Claremont
 Xerox Corporation
 
 --
 --
 --
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 To Unsubscribe visit
 http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=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=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Uploads to database

2000-10-02 Thread Jaime Garza

This is a multi-part message in MIME format.

--=_NextPart_000_000B_01C02C62.2A96FFD0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

I am wondering if anyone has succeeded uploading attached files (INPUT
TYPE="FILE") to database blobs.  I tried before, but only CFFILE seems to
be able to get to the field contents, making necessary two file accesses:
one to write and the other to read.  Has anyone seen anything better?


Jaime/



--=_NextPart_000_000B_01C02C62.2A96FFD0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
HTMLHEAD
META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type
META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR/HEAD
BODY
DIVFONT face=3DArial size=3D2SPAN class=3D005030418-02102000I am =
wondering if=20
anyone hasnbsp;succeeded uploading attached files (lt;INPUT =
TYPE=3D"FILE"gt;)=20
to database blobs.nbsp; I tried before, but only CFFILE seems to be =
able to get=20
to the field contents, making necessarynbsp;two file accesses: one to =
write and=20
the other to read.nbsp; Has anyone seen anything =
better?/SPAN/FONT/DIV
DIVFONT face=3DArial size=3D2SPAN=20
class=3D005030418-02102000/SPAN/FONTnbsp;/DIV
DIVFONT face=3DArial size=3D2SPAN=20
class=3D005030418-02102000/SPAN/FONTnbsp;/DIV
DIVFONT face=3DArial size=3D2lt;Jaime/gt;/FONT/DIV
DIVnbsp;/DIV
DIVnbsp;/DIV/BODY/HTML

--=_NextPart_000_000B_01C02C62.2A96FFD0--

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



Re: Windows 2000??

2000-10-02 Thread Ken Wilson

I use Win2k Pro for my development machine and couldn't be happier.

Ken


- Original Message -
From: HappyToad.com [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, October 02, 2000 12:44 PM
Subject: Windows 2000??


 How many of you are using Windows 2000 on your pc?  I am getting really
 tired of win98 problems and are wondering how much better win 2000 is.

 Thanks,
 Rich

 --

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



RE: Dave Watts Alive well.....

2000-10-02 Thread Dave Watts

 Ah Dave, you ARE still with us :-)  I was beginning to wonder ...

I just took a little vacation. Nothing like coming back to 1500 or so
cf-talk messages.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: Dave Watt's Alive well.....

2000-10-02 Thread Todd Ashworth

... and in the first ever cf_olympics, he takes the gold in the
most-questions-answered-in-one-sitting event.

Todd Ashworth

- Original Message -
From: "JustinMacCarthy" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Monday, October 02, 2000 12:55 PM
Subject: Dave Watt's Alive  well.


| Ah Dave, you ARE still with us :-)   I was beginning to wonder ...
|
| ~Justin MacCarthy


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



RE: Protecting Content / content leeching... A CF method?

2000-10-02 Thread Larry W. Virden

Re: knowing the path to a image tells the user too much...

Then don't give them a path to your images.  Instead, give them a 
path to some sort of cgi, with arguments which, which processed 
along with a page name or some other argument, lead one to only 
one image.  That way, guessing other image names fails.  Think of 
it as a 2 argument hash - the first argument is the page name and 
the second is some kind of unique image identifier not trivially 
guessed.  

Basically, it works the same way things would look if you were 
storing your images in a database and then using ColdFusion to do 
a SQL search for the page text and the images associated with the 
pages, then sending all of these to the user without storing them 
in a directory on your site...

-- 
Larry W. Virden URL: mailto:[EMAIL PROTECTED] 
URL: http://www.purl.org/net/lvirden/
Even if explicitly stated to the contrary, nothing in this 
posting
should be construed as representing my employer's opinions.


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



Error attempting to write location redirection to web server

2000-10-02 Thread Eron Cohen

I am asking this again.  Someone out there MUST know what this error is
about and what to do about/how to trap it:

Does anyone know what this error is referring to?  Its not in the Allaire KB
and others on the forums.allaire.com have asked, but nobody seems to know
what exactly it means.

"ERROR","TID=492","09/19/00","18:48:13","Error attempting to write location
redirection to web server (Windows NT error number 16389 occurred)"

I really wish there was a good resource that has a list of all the various
errors you could get in your ColdFusion logs and what they mean.

Thank You,

Eron Cohen


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



Need help for getting more than 64K text out from Oracle

2000-10-02 Thread Chen, Yung-Chih (CIT)


Hi,
Does any one know how to get out text (more than 64k) from Oracle?
We have a column which contains more than 64k text in there. When I do the
cfquery to get
that column out, it will only display 64K text if the column value is great
than 64K.

Any suggestion is very helpful!

Thank you.

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



Checking STMP (FTP?) server status.

2000-10-02 Thread Daive

This is a multi-part message in MIME format.

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

Hi everybody,

i've made a website that allow to a user (if they are registred) to =
enter some address (http) and port to check his status. (if site is =
down, or slow etc. ) That was easy, i'm just using CFHTTP tag and =
verifying cfhttp.values .. And if an error is occured, the user receive =
an email.

Now one of my client want to check the status of other kind of address. =
By example, an STMP server or FTP server. I don't really know which tags =
or tools i need to work on .. Is there someone that can suggest the best =
way to do it?=20

Thanks!

Daive
[EMAIL PROTECTED]

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

!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
HTMLHEAD
META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1"
META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR
STYLE/STYLE
/HEAD
BODY bgColor=3D#ff
DIV
DIVFONT face=3DArial size=3D2Hi everybody,/FONT/DIV
DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV
DIVFONT face=3DArial size=3D2i've made a website that allow to a =
user (if they=20
are registred) to enter some address (http) and port to check his =
status. (if=20
site is down, or slow etc. ) That was easy, i'm just using CFHTTP tag =
and=20
verifying cfhttp.values .. And if an error is occured, the user receive =
an=20
email./FONT/DIV
DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV
DIVFONT face=3DArial size=3D2Now one of my client want to check the =
status of=20
other kind of address. By example, an STMP server or FTP server. I don't =
really=20
know which tags or tools i need to work on .. Is there someone that can =
suggest=20
the best way to do it? /FONT/DIV
DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV
DIVFONT face=3DArial size=3D2Thanks!/FONT/DIV
DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV
DIVFONT face=3DArial size=3D2Daive/FONT/DIV
DIVFONT face=3DArial size=3D2A=20
href=3D"mailto:[EMAIL PROTECTED]"[EMAIL PROTECTED]/A/FONT=
/DIV/DIV/BODY/HTML

--=_NextPart_000_0077_01C02C7E.D55590F0--

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



RE: [CF-Talk] RE: Ben Forta, I call on thee (was: What is Fusebox)

2000-10-02 Thread lsellers


 Actually it turns me off for specifically because it does use this
 old
   outmoded monolithic view of the things. I prefer a more
  encapsulated object-based way of coding.

 I'd be quite interested to hear how you are doing this. If you had
 time to post a few, even nonworking samples, that would be great too.
 Many of us are always looking for new, better ways to do things. I'd
 be interested in how you are achieving an object oriented structure
 (though I have looked at cfobjects.com, I presume you are doing
 something different)...

Before I respond to that perhaps I should revisit fusebox.org and refresh
myself on who's behind it. :)

In short I simply meant encapsulating each major functional unit, generally
in it's own folder. Last time I read up on fusebox it had a monolithic
aproach to things (one big functional block). Maybe it's changed though.
(Reminds me a bit of a rack mount in some ways.)

I prefer to split things up into logical functional units (forums, products,
etc) with a well known entry/exit points and interface states. BUT calling
on css's (and header/footer cfms) from thier parent folders to maintain a
constant look and feel.

That's all I meant. More organic. Less mechanical. :)

--min


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



  1   2   >