RE: CFID/CFTOKEN

2000-03-28 Thread Ron Anderson

In the CF Admin section, you can "reap" the CFID/CFTOKENS after a select
number of days.

-Original Message-
From: Pete Freitag [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 27, 2000 11:55 PM
To: [EMAIL PROTECTED]
Subject: RE: CFID/CFTOKEN


have you tried cfregistry

_
Pete Freitag
CFDEV.COM
Cold Fusion Developer Resources
http://www.cfdev.com/

-Original Message-
From: paul smith [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 27, 2000 10:05 PM
To: [EMAIL PROTECTED]
Subject: CFID/CFTOKEN


Is there an easy way to remove *many* CFID/CFTOKEN
entries from the Registry?

best,  paul


--
Archives: http://www.eGroups.com/list/cf-talk
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.eGroups.com/list/cf-talk
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.eGroups.com/list/cf-talk
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.



Add New Table In SQL Server

2000-03-28 Thread Gary Kam

Hello everyone,

I would like to add a new table in the DataSource of SQL Server. and the
DataSource is currently Online. How can I do it remotely by ColdFusion? Is
there any CREATE functions which I can use to create a Table?

Thanks In Advance,
Gary Kam


__
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://im.yahoo.com
--
Archives: http://www.eGroups.com/list/cf-talk
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: Add New Table In SQL Server

2000-03-28 Thread Pete Freitag

You use CREATE TABLE tablename (data-type column-name, etc)

___
Pete Freitag
CFDEV.COM
Cold Fusion Developer Resources
http://www.cfdev.com/

-Original Message-
From: Gary Kam [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 28, 2000 3:19 AM
To: [EMAIL PROTECTED]
Subject: Add New Table In SQL Server


Hello everyone,

I would like to add a new table in the DataSource of SQL Server. and the
DataSource is currently Online. How can I do it remotely by ColdFusion? Is
there any CREATE functions which I can use to create a Table?

Thanks In Advance,
Gary Kam


__
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://im.yahoo.com

--
Archives: http://www.eGroups.com/list/cf-talk
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.eGroups.com/list/cf-talk
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.



Quick Q...

2000-03-28 Thread Aidan Whitehall

Easy one for y'all (sorry, but cerebro non functione today).  If on a
template

CGI.SCRIPT_NAME returns
/internet/templates/TestCFTemplates/SystemFunctions/index.cfm

and

ListLast(CGI.SCRIPT_NAME, "/") returns
index.cfm

how can I obtain CGI.SCRIPT_NAME minus the index.cfm, like...
/internet/templates/TestCFTemplates/SystemFunctions/




Thanks in advance

-- 
Aidan Whitehall [EMAIL PROTECTED]
Netshopper UK Ltd
Advanced Web Solutions  Services

http://www.netshopperuk.co.uk/
Telephone +44 (01744) 648650
Fax +44 (01744) 648651
--
Archives: http://www.eGroups.com/list/cf-talk
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: Quick Q...

2000-03-28 Thread Chris Tazewell

How about:

cfset remove_str = ListLast(#CGI.SCRIPT_NAME#, "/")
cfset current_dir = Replace(#CGI.SCRIPT_NAME#, remove_str, "")

Taz


- Original Message -
From: "Aidan Whitehall" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, March 28, 2000 10:20 AM
Subject: Quick Q...


 Easy one for y'all (sorry, but cerebro non functione today).  If on a
 template

 CGI.SCRIPT_NAME returns
 /internet/templates/TestCFTemplates/SystemFunctions/index.cfm

 and

 ListLast(CGI.SCRIPT_NAME, "/") returns
 index.cfm

 how can I obtain CGI.SCRIPT_NAME minus the index.cfm, like...
 /internet/templates/TestCFTemplates/SystemFunctions/




 Thanks in advance

 --
 Aidan Whitehall [EMAIL PROTECTED]
 Netshopper UK Ltd
 Advanced Web Solutions  Services

 http://www.netshopperuk.co.uk/
 Telephone +44 (01744) 648650
 Fax +44 (01744) 648651
 --

 Archives: http://www.eGroups.com/list/cf-talk
 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.eGroups.com/list/cf-talk
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: Quick Q...

2000-03-28 Thread Aidan Whitehall

Great... thanks both.




-- 
Aidan Whitehall [EMAIL PROTECTED]
Netshopper UK Ltd
Advanced Web Solutions  Services

http://www.netshopperuk.co.uk/
Telephone +44 (01744) 648650
Fax +44 (01744) 648651
--
Archives: http://www.eGroups.com/list/cf-talk
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: Uploading and IE 5

2000-03-28 Thread James Sleeman

---Reply to mail from Ric Smith about Uploading and IE 5
 Has anyone noticed any odd behavior when using CFFILE
 to do file uploads with IE 5? Everything works fine with Netscape
 but I get a CF error stating:

Are you using a Mac ?  I have found Macs using IE ar broken when it comes
to uploading files.  I don't have a Mac (yet) so I can't test first hand,
but when a Mac using client had a problem with this I got her using NS and
everything worked fine.  Search the allaire developer forums, I found a
few people had similar problems there.



--
Archives: http://www.eGroups.com/list/cf-talk
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 V1 #25

2000-03-28 Thread Bill Grover

Our shop has used FoxPro exclusively, until 6 months ago, for about 5 years.
We have switched to SQL Server because our primary job tracking application
(3rd Party) switched.

We have found FoxPro (especially since v5.0) to be very stable and robust.
If you design the database properly, use referential integrity and
transactions (the most important item!) it is very robust.  While our FoxPro
databases will sometimes get a "corrupt index", or an index that points to
the wrong record, they are easily fixed.  As long as you can get exclusive
use of the tables (which we do by getting in early and locking people out) a
simple reindex command against the offending table will fix the index.  We
have had to reindex tables with 700,000 records and 10 indexes and it takes
about 2 minutes across a 100bt network (doing it local on the server would
be faster).

Basically if I had a choice of using Access 2000 or FoxPro I would pick
FoxPro every time.  Hope this helps, if you have any questions feel free to
ask.

__
Bill Grover
Supervisor IS DepartmentPhone:  301.424.3300 x396
EU Services, Inc.   FAX:  301.424.3300 x1396#
649 North Horners Lane  E-Mail: mailto:[EMAIL PROTECTED]
Rockville, MD 20850-1299WWW:  www.euservices.com
__


 -Original Message-
 Date: Mon, 27 Mar 2000 09:55:40 -0600
 From: "Dave Hannum" [EMAIL PROTECTED]
 To: "[EMAIL PROTECTED]" [EMAIL PROTECTED]
 Subject: FoxPro and Access 2000
 Message-ID: 00fd01bf9804$e6a92880$[EMAIL PROTECTED]
 
 Good Morning,
 
 Any thoughts on using Access 2000 or FoxPro for production 
 databases.  Now, I know previous versions of Access have not been
 recommended for web production, but it seems there has bee 
 some discussion about Access 2000 being more robust than 
 Access 97.  I've
 never used FoxPro, but the host where my next project is to 
 be hosted supports Access 2000 and FoxPro for the account my 
 client has.
 Just looking for input.  Also, what about mySQL.  The next 
 level account the host offers supports mySQL.  Should I 
 encourage them to
 upgrade?  How hearty is mySQL?  I use Oracle for most of my 
 work, and only have experience with Access for a very small 
 site.  I've
 never used FoxPro or mySQL.  I know that none of these three 
 (especially Access) even come close to Oracle, but we'll be developing
 on a shared host server.  Marketing says potential for this 
 site is $3M annually - gotta be robust!
 
 Thanks,
 Dave
 
 
 =
 "Technology" is stuff that was invented after
 you were born.
 
 David Hannum
 
 --
--
Archives: http://www.eGroups.com/list/cf-talk
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.



Connecting to ACTS 2000

2000-03-28 Thread Jeff Green


Hi all,

One of my clients asked me if I could interact with his ACTS 2000 database.

So naturally, Im asking you all is it possible to interact with ACTS 2000
through CF?

Im not familar with ACTS 2000 (contact management software) at all , Im
kinda thinking not if ACTS is a desktop app.

Thanks in advance,
jeff


--
Archives: http://www.eGroups.com/list/cf-talk
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.



Excel Workbook/Worksheet as Datasource

2000-03-28 Thread David E. Crawford

I realize this may have already been discussed, but as usual, I didn't need
to know how to do it then, because we weren't using.  Flashforward to today.
Can someone give me a short explanation of the steps required to setup an
Excel workbook/worksheet as a datasource, specifically in terms of the
format that the spreadsheet must be in?

Thanks.

Dave
---
David E. Crawford
Director, Internet Development
Yale Security Group, Inc.
www.yalesecurity.com

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



CFCONTENT

2000-03-28 Thread Jeff Green


Hi,

Im a bit confused on what cfcontent does?

Im hoping it can deliver a file to be downloaded to the user, I would like
the file to come from a DIR that web-users dont have access to and CFserver
does.  I hope to restrict access to download the file.

Any Ideas?

Any cfcontent examples would be cool )


Thanks in advance,
Jeff


--
Archives: http://www.eGroups.com/list/cf-talk
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: CFID/CFTOKEN

2000-03-28 Thread paul smith

Where is that?  I have timeout set to 20 minutes.
But that doesn't delete the registry entry.

best,  paul

At 12:17 AM 3/28/2000 -0800, you wrote:
In the CF Admin section, you can "reap" the CFID/CFTOKENS after a select
number of days.

-Original Message-
From: Pete Freitag [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 27, 2000 11:55 PM
To: [EMAIL PROTECTED]
Subject: RE: CFID/CFTOKEN


have you tried cfregistry

_
Pete Freitag
CFDEV.COM
Cold Fusion Developer Resources
http://www.cfdev.com/

-Original Message-
From: paul smith [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 27, 2000 10:05 PM
To: [EMAIL PROTECTED]
Subject: CFID/CFTOKEN


Is there an easy way to remove *many* CFID/CFTOKEN
entries from the Registry?

best,  paul


--
Archives: http://www.eGroups.com/list/cf-talk
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.eGroups.com/list/cf-talk
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.eGroups.com/list/cf-talk
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.eGroups.com/list/cf-talk
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: some high trafic cf websites please

2000-03-28 Thread Tim Maxwell

I'm reading Ben Forte's Cold Server Application book and he mentions Amazon
and FedEx in the first chapter as examples of high volume CF sites.  I
believe Ben is one of the original developers of CF.

Tim

- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, March 27, 2000 3:20 PM
Subject: RE: some high trafic cf websites please


 Are you sure Amazone.com is Cold Fusion I know for a fact that
 Toys-R-Us.com, Nike.com, and my company Autobytel.com is all CF.

 -Original Message-
 From: Tim Maxwell [mailto:[EMAIL PROTECTED]]
 Sent: Monday, March 27, 2000 1:28 PM
 To: [EMAIL PROTECTED]
 Subject: Re: some high trafic cf websites please


 amazon.com and fedex.com are both CF sites.  Hope this helps

 Tim

 - Original Message -
 From: Interent Gold Coast Properties
 [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Monday, March 27, 2000 7:07 AM
 Subject: some high trafic cf websites please


  Hi,
 
  i am wondering if anyone could direct me to some very high traffic cf
  websites so that i can get some idea as to what cf server firms provide
 high
  quality cf hosting for high traffic sites
 
  Kind Regards
 
  Claude Raiola
  E-Mail: [EMAIL PROTECTED]
  Website: www.internetgoldcoastproperties.com.au
 
 

 --
 
  Archives: http://www.eGroups.com/list/cf-talk
  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.eGroups.com/list/cf-talk
 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.eGroups.com/list/cf-talk
 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.eGroups.com/list/cf-talk
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: Excel Workbook/Worksheet as Datasource

2000-03-28 Thread David E. Crawford

Thanks.  I think I have figured it out.  I would do it in access, but the
bean counters love spreadsheets, so I am forced to go along with them on
this.

Dave

- Original Message -
From: Steve Robson [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, March 28, 2000 13:45
Subject: RE: Excel Workbook/Worksheet as Datasource


 This is based on my experience, and so may not be the best way to do
 this:

 you need to create named ranges in the workbook, these ranges become
 tables
 and the first row becomes the field names.  That's pretty much about it,
 set
 up a datasource to point to the file and Bob's your uncle!

 I found it to be a total pain, and so ended up converting the
 spreadsheet
 into an access database and just used that instead!!

 Steve Robson

 -Original Message-
 From: David E. Crawford [mailto:[EMAIL PROTECTED]]
 Sent: 28 March 2000 14:24
 To: CF-Talk
 Subject: Excel Workbook/Worksheet as Datasource


 I realize this may have already been discussed, but as usual, I didn't
 need
 to know how to do it then, because we weren't using.  Flashforward to
 today.
 Can someone give me a short explanation of the steps required to setup
 an
 Excel workbook/worksheet as a datasource, specifically in terms of the
 format that the spreadsheet must be in?

 Thanks.

 Dave
 ---
 David E. Crawford
 Director, Internet Development
 Yale Security Group, Inc.
 www.yalesecurity.com

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


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



RE: some high trafic cf websites please

2000-03-28 Thread Jeff Fongemie

I remember that section as just a list of sites that successfully interact
with a database. I'm pretty sure each does not use CF.

Jeff Fongemie

-Original Message-
From: Tim Maxwell [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 28, 2000 9:06 AM
To: [EMAIL PROTECTED]
Subject: Re: some high trafic cf websites please


I'm reading Ben Forte's Cold Server Application book and he mentions Amazon
and FedEx in the first chapter as examples of high volume CF sites.  I
believe Ben is one of the original developers of CF.

Tim

- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, March 27, 2000 3:20 PM
Subject: RE: some high trafic cf websites please


 Are you sure Amazone.com is Cold Fusion I know for a fact that
 Toys-R-Us.com, Nike.com, and my company Autobytel.com is all CF.

 -Original Message-
 From: Tim Maxwell [mailto:[EMAIL PROTECTED]]
 Sent: Monday, March 27, 2000 1:28 PM
 To: [EMAIL PROTECTED]
 Subject: Re: some high trafic cf websites please


 amazon.com and fedex.com are both CF sites.  Hope this helps

 Tim

 - Original Message -
 From: Interent Gold Coast Properties
 [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Monday, March 27, 2000 7:07 AM
 Subject: some high trafic cf websites please


  Hi,
 
  i am wondering if anyone could direct me to some very high traffic cf
  websites so that i can get some idea as to what cf server firms provide
 high
  quality cf hosting for high traffic sites
 
  Kind Regards
 
  Claude Raiola
  E-Mail: [EMAIL PROTECTED]
  Website: www.internetgoldcoastproperties.com.au
 
 

 --
 
  Archives: http://www.eGroups.com/list/cf-talk
  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.eGroups.com/list/cf-talk
 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.eGroups.com/list/cf-talk
 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.eGroups.com/list/cf-talk
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.eGroups.com/list/cf-talk
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: Crystal Problems

2000-03-28 Thread Todd Ashworth

We are having the same problem.

According to someone at allaire, Crystal Reports doesn't play well with CF
anymore.  The only solutions they offered were other, non-Crystal Reports
solutions.

If anyone out there has found a work around for this problem, please let us
know :)

Thanks,

Todd Ashworth

- Original Message -
From: "Eric Bradburn" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, March 27, 2000 5:56 PM
Subject: Crystal Problems


 We are running ColdFusion Server 4.5 and trying to use the cfreport
 tag. Our server is running Crystal Reports version 8.0.  When we
 reference a report with the cfreport tag we are getting this error...



 Error Diagnostic Information


 Error occurred while processing CFREPORT



 An unexpected error occurred while using the Crystal Engine.


 Error number 692 ocurred (Error in File C:\Inetpub\wwwroot\working.rpt:
 Invalid export DLL or export format.).


 Crystal Library = C:\WINNT\system32\CRPE32.DLL (1/28/2000 15:16)
 DLL Version = 8.0, Engine Version = 8.0



 The error occurred while processing an element with a general identifier

 of (CFREPORT), occupying document position (9:1) to (9:70).


--
Archives: http://www.eGroups.com/list/cf-talk
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: DSNless connections

2000-03-28 Thread jstiefel

You could create a "wrapper" in Java or C++ (or even VB for that matter) and
use it to pass your SQL to the db. I'm curious- what's the need for a
dsnless connection?

-Original Message-
From: Todd Ashworth [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 29, 2000 9:18 AM
To: [EMAIL PROTECTED]
Subject: DSNless connections


I'm sure this has been covered before, but I cannot find a satisfactory
(read, unconfusing) answer in any of the discussion boards.  Hopefully
someone here will have some ideas.

Is there ANY way to create a DSNless connection to a database in Cold
Fusion?
I am using Cold Fusion 4.5 and a Sybase 6.03 database.

Can this be done purely in CF?
Would it require a mixture of CF and ASP?
Is it even possible at all?

Thanks,

Todd



--
Archives: http://www.eGroups.com/list/cf-talk
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.eGroups.com/list/cf-talk
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: Javascript Navigation Bar - I need one.

2000-03-28 Thread Len Conrad

www.BrainJar.com has a nice floating DHTML horizontal menu bar with pulldowns.

Len

==


Check this site, there are many there:
http://dynamicdrive.com/

 
 I've tried a couple different Javascript navigation bars, but none of =
 them seem to work with my CF pages. The one that looked most =
 eye-pleasing had some kind of repositioning thing going on when the =
 browser window changed size and it completely blew away all form =
 variables passed to the template.
 
 I'm not schooled in JS, so something plug-n-chug would be
 great.  I want =
 something VERY much like what www.microsoft.com uses.
 



**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**
--
Archives: http://www.eGroups.com/list/cf-talk
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.eGroups.com/list/cf-talk
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: CFIF Problem with OR

2000-03-28 Thread Olive, Christopher M Mr USACHPPM

um...not really.  read it a bit closer.  only one has to be true for the
whole thing to be true.  therefore, if ANY ONE of they is NOT true in his
original condition, it will fail.  ergo, we need ANDs.

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-Original Message-
From: Andrew Scott [mailto:[EMAIL PROTECTED]]
Sent: Sunday, March 26, 2000 7:03 PM
To: [EMAIL PROTECTED]
Subject: RE: CFIF Problem with OR


Chris I can't believe you made that statement:-)

If the ID needs to be either 1,13,4, or 43 as you have said then the cfif
needs or to be either of these conditions. And means that all conditions
needs to be meet before it becomes true Or means only one needs to be meet
for the condition to be true:-)




Andrew Scott - Internet Development

Totalnet Presence Pty. Ltd.
Level 1-361 City Road
SouthBank Vic 3006
Phone: 9690 4100 Mobile: 0412 777 958
www.totalnet.com.au


 -Original Message-
 From: Olive, Christopher M Mr USACHPPM
 [mailto:[EMAIL PROTECTED]]
 Sent: Saturday, March 25, 2000 6:54 AM
 To: '[EMAIL PROTECTED]'
 Subject: RE: CFIF Problem with OR


 so the ID has to be either 1, 13, 4, or 43?  is that what you're trying to
 do?

 if so, the ORs should be ANDs.  what you are saying is this:

 say you have an ID of 13.
 the first case is tried: ID IS NOT 1.
 the ID is NOT 1, factually.  so the IF returns TRUE, even though
 the second
 statement would return the opposite answer.

 Chris Olive
 DOHRS Website Administrator
 [EMAIL PROTECTED]


 -Original Message-
 From: Michel Gagnon [mailto:[EMAIL PROTECTED]]
 Sent: Friday, March 24, 2000 2:48 PM
 To: [EMAIL PROTECTED]
 Subject: CFIF Problem with OR


 Hi there!

 What is wrong with this statement?

 CFIF (ID IS NOT "1") OR (ID IS NOT "13") OR (ID IS NOT "4") OR (ID IS NOT
 "43")

 I also tried:

 CFIF ID IS NOT "1,13,4,43"

 It executes what's inside even if ID is 43

 Any ideas?

 --
 --
 --
 Archives: http://www.eGroups.com/list/cf-talk
 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.eGroups.com/list/cf-talk
 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.eGroups.com/list/cf-talk
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.eGroups.com/list/cf-talk
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 Based Real Estate App

2000-03-28 Thread KungFusion

does yours port to Realtor.com???

Brian Silvers
[EMAIL PROTECTED]

X-Net Web Systems   ColdFusion, CGI's, Dynamic Content
http://www.x-net.com Flash, Database Integration,  and more!
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, March 27, 2000 11:07 AM
Subject: RE: CF Based Real Estate App


 I've done one for the local MLS here (http://www.carolinahome.com). I
don't
 think there are any prepackaged apps for this, it's a DIY.

 Charlie

 -Original Message-
 From: cf kaizen [mailto:[EMAIL PROTECTED]]
 Sent: Monday, March 27, 2000 11:39 AM
 To: [EMAIL PROTECTED]
 Subject: CF Based Real Estate App


 Howdy,

 A client wants to re-create a realtors.com-type app
 for a particular region. They want a site where
 realtors can enter real-estate information, and buyers
 can view local real estate. Any pre-packaged CF apps
 out there with this type of functionality? Probably
 fairly straightforward, but no sense re-inventing the
 wheel!

 Thanks!


 __
 Do You Yahoo!?
 Talk to your friends online with Yahoo! Messenger.
 http://im.yahoo.com
 --
--
 --
 Archives: http://www.eGroups.com/list/cf-talk
 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.eGroups.com/list/cf-talk
 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.eGroups.com/list/cf-talk
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: Search Engine Friendly Variables (?)

2000-03-28 Thread Mack, Chris R

There's an article about the entire process in the January 2000 issue of
Cold Fusion Developers Journal.  The code can be found at
www.coldfusionjournal.com.  Here is the link to the forum thread:
http://forums1.allaire.com/DevConf/index.cfm?Message_ID=18401  For those of
you that don't read it, I have found every issue of CFDJ to be very
informative and well written.

Chris R. Mack
Manager, Internet Strategies
Lockheed Martin Technology Services


-Original Message-
From: Jay Sudowski [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 27, 2000 6:45 PM
To: [EMAIL PROTECTED]
Subject: Re: Search Engine Friendly Variables (?)


Allen,

I'm not sure about the internetsoccer link you have there, but the first
link is from a Vignette StoryServer.  I've actaully got a friend who just
landed a job at sportal, and they're teaching him TCL, the lanague that
StoryServer is based upon.  Each set of numbers between the comma's mean
something to Story Server, but I don't have a clue ;-).

The major problem, as I understand it, with search engines not indexing
ColdFusion based urls is that they don't visit and URLs that have a question
mark in them.   IE, Altavista wouldn't spider something like
www.yoursite.com/order.com?a=1234b=5345867.   Many moons ago, there was a
long thread about how to create search engine friendly links on the Allaire
Forums.  The gist of it was to create a link using /'s rather than question
marks,  equal signs and ampersands.  IE, to make that URL above search
engine friendly, you link to www.yoursite.com/order.cfm/a/1234/b/5345867.  A
URL like this will still get executed by the CF server, you just have to
create a list, using the / as a delimiter, and then set your vars using the
list.

Sorry I don't have any specific code examples.  This topic was discusssed
long ago and I never go around to implementing it into any of my sites.

- Jay


 Hello,

 I've noticed some URL's set up in ways like these two.  Could someone
please
 explain them for me?  The little understading I have it is so that the
 search engines will index the pages.  Is that correct?

 How the commas function?  As "="?

 ( http://www.sportal.co.uk/football/news/article/0,5081,47198,00.html )

 http://www.internetsoccer.com/handler.cfm/article,display/Con_ID,2/Locatio
 nCode,NAmerica/ID,26307/At_ID, )


 Thank you.
 ==  -  ==   ==  -  ====  -  ==
 Allen Graetz
 USI - Web Application Programmer
 1-800-USINTERNET x241
 612-253-3241


 --

 Archives: http://www.eGroups.com/list/cf-talk
 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.eGroups.com/list/cf-talk
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.eGroups.com/list/cf-talk
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: CFID/CFTOKEN

2000-03-28 Thread Stephen Moretti



 Where is that?  I have timeout set to 20 minutes.
 But that doesn't delete the registry entry.


If you look on the same variables page you'll see the setting for storage of
client variables.
You should already have an entry for the Registry.
Click on this and you'll get a page that allows you to set how often unused
client variables are purged from the registry.  The default is 90 days.

Hope this helps.

Regards

Stephen

--
Archives: http://www.eGroups.com/list/cf-talk
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: Inline html editor

2000-03-28 Thread Levi Wallach

There is also a Java Applet which has a limited set of tools, but I don't
have the name of it in memory at the moment.  As far as Word to html,
Andrew, you have gotten me thinking - despite word 2000 putting in all that
xml when you save "as html" couldn't you save to RFT and then use a custom
tag to covert it - I thought there were more than one out there which dealt
with RTF?  Or perhaps they are perl scripts?

Levi


| Levi Wallach - [EMAIL PROTECTED]  P:(703) 237-0443 F: 703-237-3490|
| Senior Webmaster, Tran Interactive Design Group - http://www.tidg.com |

| Creator, DVDMON.com - http://www.dvdmon.com - [EMAIL PROTECTED] |
| DVD News, Views  Reviews, Music  Book Reviews, PDA Channel Content, |
| Contests, DVD Buying Guide and more!  |
-


 -Original Message-
 From: Andrew Scott [mailto:[EMAIL PROTECTED]]
 Sent: Monday, March 27, 2000 10:10 PM
 To: [EMAIL PROTECTED]
 Subject: RE: Inline html editor


 There are plenty of tags out there that will do the job, however the main
 problem is that most use functions that will only owrk under Internet
 Explorer. The method I find the best and I haven't been able to tidy it up
 to make it into a tag as yet, is to use word and convert it into a html
 file.

 Now the major problem here is that Word converts it into xml format so you
 get a lot of junk that doesn't need to be there as well as not
 being bale to
 control the font size etc. So the best method here is to tag what is not
 needed using regexp. And using the regexp to change the font to friendly
 fonts and sizes before saving it to the hard drive. At least this way you
 can overcome the bigger corporations that have departments that
 dictate what
 browser you must use.

 Otherwise I would also suggest ActiveEdit:-)



 Andrew Scott - Internet Development

 Totalnet Presence Pty. Ltd.
 Level 1-361 City Road
 SouthBank Vic 3006
 Phone: 9690 4100 Mobile: 0412 777 958
 www.totalnet.com.au


  -Original Message-
  From: Chris Tazewell [mailto:[EMAIL PROTECTED]]
  Sent: Monday, March 27, 2000 9:25 PM
  To: [EMAIL PROTECTED]
  Subject: Inline html editor
 
 
 
  OK, here's a stupid idea. We've got a section on one of our sites where
  people can update the content... sounds bad already yeah?
 
  So this is for blocks of text etc. which is good because we don't
  have to do
  all of the site content so we can dedicate our time to design
 etc. But the
  content involves html, including fonts and breaks. So at the moment they
  have to either write raw html, or use word to convert edited text
  to html -
  then paste it into the textarea on an admin tool. Not good.
 
  Question: does anyone know of a usefull 'inline' html editor that
  I can use
  in a CF template?Whether it be a CF custom tag, or an applet or
  whatever...
 
  Otherwise, suggestions please?
 
  Cheers
 
  Taz
 
  --
  
  Archives: http://www.eGroups.com/list/cf-talk
  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.eGroups.com/list/cf-talk
 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.eGroups.com/list/cf-talk
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: Seeing this?

2000-03-28 Thread Olive, Christopher M Mr USACHPPM

why sum?  why not count(*)?

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-Original Message-
From: Don Vawter [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 27, 2000 9:09 PM
To: [EMAIL PROTECTED]
Subject: Re: Seeing this?


This should do it.

 CFQUERY DATASOURCE="userdb"
 SELECT username, SUM(username) FROM users
GROUP BY username
HAVING sum(username)  1
 /CFQUERY

- Original Message -
From: "John N Westerlund" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, March 27, 2000 5:28 PM
Subject: Re: Seeing this?


 At my wits end. Im trying to find duplicate users in a database...
 The closest I can find to in the Forta book is:

 CFQUERY DATASOURCE="userdb"
 SELECT SUM(username) FROM users GROUP BY username
 /CFQUERY

 But I tried that last week and it doesnt work.
 I'd like it just to do

 cfif num_user_records GT 1
 #username#br
 /cfif

 Should I use a cfloop, list, array?


 -Original Message-
 From: Chris Farrugia [EMAIL PROTECTED]
 To: [EMAIL PROTECTED] [EMAIL PROTECTED]
 Date: Monday, March 27, 2000 7:17 PM
 Subject: Seeing this?


 I can't seem to get my messages to post on the list.  Lets see if this one
 works.

 --
--
 --
 Archives: http://www.eGroups.com/list/cf-talk
 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.eGroups.com/list/cf-talk
 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.eGroups.com/list/cf-talk
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.eGroups.com/list/cf-talk
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: SSL to secure your Web Server?

2000-03-28 Thread Olive, Christopher M Mr USACHPPM

you could try going to www.verisign.com and read the information about
server certificates.

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-Original Message-
From: Mark Shen [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 04, 2000 10:58 PM
To: [EMAIL PROTECTED]
Subject: SSL to secure your Web Server?


This is a multi-part message in MIME format.

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

Can you tell you how to use SSL to secure your Web Server? can you tell =
me some web site have the information about that.

thanks

Mark=20

--=_NextPart_000_0009_01BF56ED.F7A53320
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.2314.1000" name=3DGENERATOR
STYLE/STYLE
/HEAD
BODY bgColor=3D#ff
DIVFONT face=3DArial size=3D2Can you tell you how to use SSL to =
secure your Web=20
Server? cannbsp;you tell me some web site have the =
informationnbsp;about=20
that./FONT/DIV
DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV
DIVFONT face=3DArial size=3D2thanks/FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial size=3D2Mark/FONTnbsp;/DIV/BODY/HTML

--=_NextPart_000_0009_01BF56ED.F7A53320--


--
Archives: http://www.eGroups.com/list/cf-talk
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.eGroups.com/list/cf-talk
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: Mac CF studio?

2000-03-28 Thread Aidan Whitehall

A UK Allaire rep said there might be an add-on for BBEdit that gave you the
ColdFusion tags on a floating bar.

Has anyone heard of anything like that?




-- 
Aidan Whitehall [EMAIL PROTECTED]
Netshopper UK Ltd
Advanced Web Solutions  Services

http://www.netshopperuk.co.uk/
Telephone +44 (01744) 648650
Fax +44 (01744) 648651
--
Archives: http://www.eGroups.com/list/cf-talk
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.



implementation of CFPARAM for CFSCRIPT?

2000-03-28 Thread Ben Wilson

All,

Is their an implementation of CFPARAM for CFSCRIPT and if so, what is the
syntax? If not, how would I do this in CFSCRIPT if at all?

TIA

Ben Wilson
CEO
Polix, LLC

--
Archives: http://www.eGroups.com/list/cf-talk
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: populating dynamic radio boxes

2000-03-28 Thread Steve Robson

when you submit the form, a list of fields included with the form is
included as a list variable:

#form.fieldnames# (or something like that), the radio button will be in
there.

Steve

P.S. it seems a little strange that they both have the same value though

-Original Message-
From: Sophie Kwong [mailto:[EMAIL PROTECTED]]
Sent: 28 March 2000 16:00
To: [EMAIL PROTECTED]
Subject: populating dynamic radio boxes


I have created a dynamic form
--
---
cfquery name="questqy" datasource="questdsn"
select * from question where typeq = '#Form.typeq#'
/cfquery

cfform name="quests" action="update.cfm" method="post"

table border="1"

cfoutput query="questqy"
tr
td#questqy.testq#/td/tr
trtd
cfinput type="radio" name="#questqy.num#"
value="#questqy.num#"#questqy.option1#br
cfinput type="radio" name="#questqy.num#"
value="#questqy.num#"#questqy.option2#br
/td
/tr
/cfoutput

trtd
input type="submit" value="submit" 
/td/tr

/cfform


Now at the update page, how do I call the radio button in order to
save the value into a database?

Thank you for any help
SK



--
Archives: http://www.eGroups.com/list/cf-talk
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.eGroups.com/list/cf-talk
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: Crystal Problems

2000-03-28 Thread Mark Jones

Look for a product called Re-Crystalise and you might be very impressed.  It
produces its reports from crystal reports but puts them in a form readable
from the web - the only problem being that it produces it in asp page format
- I am sure you guys are intelligent enough to cope with this.

Mark

-Original Message-
From:   Brian Grant [SMTP:[EMAIL PROTECTED]]
Sent:   Tue, 28 Mar 2000 15:42
To: [EMAIL PROTECTED]
Subject:Re: Crystal Problems

Crystal Reports never has played very well with CF in my opinion.
You'll be
better off looking for other reporting options besides Crystal
Reports.
We've had to go to a mix of HTML, Excel, and VB Scripted reporting
methods.

Good luck.

brian

 - Original Message -
 From: "Eric Bradburn" [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Monday, March 27, 2000 5:56 PM
 Subject: Crystal Problems


  We are running ColdFusion Server 4.5 and trying to use the
cfreport
  tag. Our server is running Crystal Reports version 8.0.  When we
  reference a report with the cfreport tag we are getting this
error...
 
 
 
  Error Diagnostic Information
 
 
  Error occurred while processing CFREPORT
 
 
 
  An unexpected error occurred while using the Crystal Engine.
 
 
  Error number 692 ocurred (Error in File
C:\Inetpub\wwwroot\working.rpt:
  Invalid export DLL or export format.).
 
 
  Crystal Library = C:\WINNT\system32\CRPE32.DLL (1/28/2000 15:16)
  DLL Version = 8.0, Engine Version = 8.0
 
 
 
  The error occurred while processing an element with a general
identifier
 
  of (CFREPORT), occupying document position (9:1) to (9:70).



--

 Archives: http://www.eGroups.com/list/cf-talk
 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.eGroups.com/list/cf-talk
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.eGroups.com/list/cf-talk
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.



Forums and Attachments

2000-03-28 Thread Ian Lurie

Hi,

I've got a Forum set up where architects can upload dwf files, and then
hopefully use the WHIP! viewer to view those files in IE.

However, this doesn't work in Forums, because the system creates a link to
'attachment.cfm' instead of the file itself.

Help?

Ian

Portent Interactive
Process, Design and Content
http://www.portentinteractive.com
--
Archives: http://www.eGroups.com/list/cf-talk
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: A Great Free CFML editor

2000-03-28 Thread Chris Evans

Homesite doesn't come with RDS, Datasource integration, or the debugger  -
all of which are included with Studio.  Homesite is designed to write HTML,
Studio is designed to write CF.

However, if Studio is too pricey, you can get by quite well with Homesite,
and many people do.

Chris Evans
[EMAIL PROTECTED]
http://www.fuseware.com



-Original Message-
From: Owens, Howard [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 27, 2000 7:59 PM
To: '[EMAIL PROTECTED]'
Subject: RE: A Great Free CFML editor




When you buy Studio, you're buying more than a tag editor ... you're buyinga
single-server license for the CF server and all of the Cold Fusion
documentation.  To me, it's worth it.

But there is a cheaper alternative:  Buy HomeSite. You don't get the CF
docs. You don't get the server. But you did get all of the CF tag support,
all of the functionality of CF Studio.  Coding wise, you can do anything in
HomeSite that you can do in Studio.  With RDS and Remote FTP, you can pretty
easily work on documents on a remote server for development, if you have
access to one.  And you can download CF Express and do much of your coding
locally.

As for this freebie ... interesting comments on some of its problems.  It's
obviously not a perfect tool, but I will be recommending it to my students
and a no-cost alternative to Studio/HomeSite.  For somebody first starting
out, it's not a bad tool from what I can see.

H.


=
Howard Owens
Web Producer
InsideVC.com
mailto:[EMAIL PROTECTED]
=

 -Original Message-
 From: George Loch [SMTP:[EMAIL PROTECTED]]
 Sent: Monday, March 27, 2000 2:15 PM
 To:   [EMAIL PROTECTED]
 Subject:  Re: A Great Free CFML editor

 Is CFStudio the only other alternative? I would be happy to see something
 less than $500. Maybe studio does more than I think but, $500 seems pretty
 steep for a tag editor.



--
Archives: http://www.eGroups.com/list/cf-talk
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.eGroups.com/list/cf-talk
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: Quality Assuarance for Post to Intranet

2000-03-28 Thread Paul Ihrig

Hello All!
My manager has given me a new task.
He wants me to put together a guideline for posting new sections for our
intranet  internet sites.
A staging place for content review.
Spelling, grammar, consistent look  feel as well as strong content.

At the moment I just through it out there as [well designed] quickly 
efficiently as possible

I am sure there are a lot of resources on what other companies have in place
for consistent quality.
If you know of these resources, please let me know.
I would appreciate it.
Thanks

-paul

Web Developer, NBBJ
Work:   [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 
614 241-3534
Home:   [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 
614 449-1681
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 
icq: 4765835
--
Archives: http://www.eGroups.com/list/cf-talk
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.



Sports League Management solution

2000-03-28 Thread Eric Dawson

Sports League Management solution
variety of sports.
Features:
Teams
Team Pages
Schedules.
Schedule generation.
Standings.
Player Profiles.
Leaders.
Player stats.
Security model. variety of people to login and access online data.
News publishing.
Event Calendar.
Store.

Etc. Etc.

Does anyone have a mittful of open source code I can tap into?

Snippets, whatever.

Please. Please. Please.

Eric
__
Get Your Private, Free Email at http://www.hotmail.com

--
Archives: http://www.eGroups.com/list/cf-talk
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: Custom Configure a PC page for my site

2000-03-28 Thread Won Lee

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_01BF98D7.6745F880
Content-Type: text/plain;
charset="windows-1252"

Well your 2/3 of the way there cause of the 2 of the 3 sentences you wrote
were declerative sentences, not questions.  heh

ok i'll get serious now

1) a quick guess is to use cfparams for default values

2) have each item/component be priced...not the full system

3) session variables!  This will work well with the cfparams

PS I recommend that you get someone a bit more experienced and re-evaluate
the project from the ground up, including your DB design/architecture.

-Original Message-
From: Chris Farrugia [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 27, 2000 5:45 PM
To: [EMAIL PROTECTED]
Subject: Custom Configure a PC page for my site


I am making a page on my site where users can custom configure a new PC.
There is a form with drop down boxes where they choose the processor, RAM,
hard drive, etc, and then hit a submit type button.  For processor, the
choices might be:

Pentium III 700mhz
Pentium III 600mhz (subtract $100)
Pentium III 500mhz (subtract $175)

Once all of the choices are made, they click on a "submit" type of button
and it takes them to a page that shows them their choices and gives them a
price.  All of the products and prices used to populate the form are coming
out of a database of products.  Now, lets say that they don't like the price
they get...  they can hit a button "Re-Configure" and go change the form and
resubmit it.  When the system is exactly the way they want it, they can
click an order button and the system is theirs.  With this overview, here
are my questions:

1.  When they click on a machine to custom configure (such as an office
machine), there will be certain products already chosen in the form as a
standard.  For instance, an office machine might start iwth a Pentium III
600 with 64mb of ram, but they'll be able to increase or decrease these
specs to make it better suite their needs and budget.

2.  I don't know how I am going to have the database calculate the
difference in price between the default product (the one that is preselected
in the form), and the others that they can choose from.

3.  If they hit reconfigure, how will I have it now show the products they
chose the first time around as the new default options in the drop down box?

If I could get answers to these three questions, I would be able to finish
my site.  Thank you for all of your help.


--
Archives: http://www.eGroups.com/list/cf-talk
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.

--_=_NextPart_001_01BF98D7.6745F880
Content-Type: text/html;
charset="windows-1252"
Content-Transfer-Encoding: quoted-printable

!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"
HTML
HEAD
META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dwindows-1252"
META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2448.0"
TITLERE: Custom Configure a PC page for my site/TITLE
/HEAD
BODY

PFONT SIZE=3D2Well your 2/3 of the way there cause of the 2 of the =
3 sentences you wrote were declerative sentences, not questions.nbsp; =
heh/FONT/P

PFONT SIZE=3D2ok i'll get serious now/FONT
/P

PFONT SIZE=3D21) a quick guess is to use cfparams for default =
values/FONT
/P

PFONT SIZE=3D22) have each item/component be priced...not the full =
system/FONT
/P

PFONT SIZE=3D23) session variables!nbsp; This will work well with =
the cfparams/FONT
/P

PFONT SIZE=3D2PS I recommend that you get someone a bit more =
experienced and re-evaluate the project from the ground up, including =
your DB design/architecture./FONT/P

PFONT SIZE=3D2-Original Message-/FONT
BRFONT SIZE=3D2From: Chris Farrugia [A =
HREF=3D"mailto:[EMAIL PROTECTED]"mailto:coldfusion@bluewaterpc=
.com/A]/FONT
BRFONT SIZE=3D2Sent: Monday, March 27, 2000 5:45 PM/FONT
BRFONT SIZE=3D2To: [EMAIL PROTECTED]/FONT
BRFONT SIZE=3D2Subject: Custom Configure a PC page for my =
site/FONT
/P
BR

PFONT SIZE=3D2I am making a page on my site where users can custom =
configure a new PC./FONT
BRFONT SIZE=3D2There is a form with drop down boxes where they =
choose the processor, RAM,/FONT
BRFONT SIZE=3D2hard drive, etc, and then hit a submit type =
button.nbsp; For processor, the/FONT
BRFONT SIZE=3D2choices might be:/FONT
/P

PFONT SIZE=3D2Pentium III 700mhz/FONT
BRFONT SIZE=3D2Pentium III 600mhz (subtract $100)/FONT
BRFONT SIZE=3D2Pentium III 500mhz (subtract $175)/FONT
/P

PFONT SIZE=3D2Once all of the choices are made, they click on a =
quot;submitquot; type of button/FONT
BRFONT SIZE=3D2and it takes them to a page that shows them their =
choices and gives them a/FONT
BRFONT SIZE=3D2price.nbsp; All of the products and 

RE: Easiest way to get a text file into a List?

2000-03-28 Thread Chris Evans

Andrea,

  Lucky you!  It is already a list, only it is delimited by carriage returns
rather than commas.  You can loop over it just like any other list, you'll
just need to specify the delimiter to be a carriage return (#chr(10)#)
rather than a comma.  OR, if you want to change it to be a standard comma
separated list, you can use the ListChangeDelims(list, new_delimiter [,
delimiters ]) function.

CFFILE ACTION="Read"
 FILE="full_path_name"
 VARIABLE="email_list"
CFSET lEmailList = ListChangeDelims(email_list,",",CHR(10))


Chris Evans
[EMAIL PROTECTED]
http://www.fuseware.com



-Original Message-
From: Andrea Wasik [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 28, 2000 10:50 AM
To: [EMAIL PROTECTED]
Subject: Easiest way to get a text file into a List?


I have a text file that I need to get into a list or an array so I can
compare it to the results of a query. Anyhow how can I read in that file and
turn it into a list? The file is made up of email addresses, one per line,
no comma delimiters, just carriage returns.

Thanks

Andrea


.
iWon.com http://www.iwon.com why wouldn't you?

.


--
Archives: http://www.eGroups.com/list/cf-talk
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.eGroups.com/list/cf-talk
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.



ns woes...

2000-03-28 Thread Jason Egan

why on earth do we even have compatibility standards??

I have created a simple fusebox cart... it works great in ie, but in ns
nothing is added to the cart I am using formURL2attributes.cfm and '/'
attributes in the url rather than '' ...

so a url might look like cart.cfm/fuseaction/basket/add2cart/23

Also, once I have added to the cart I have a cflocation that puts the user
back into the cart - something like this:

cflocation url="../../../../../../cart.cfm/fuseaction/basket"

again in ie the item 23 is added, in ns it just goes to the empty cart..
always.
any ideas what is happening here??

thanks!
je


--
Archives: http://www.eGroups.com/list/cf-talk
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: Crystal Problems

2000-03-28 Thread Robyn Follen

nevermind, i actually found it -
http://download.cnet.com/downloads/0-10092-100-1429663.html?tag=st.cn.sr.dl.
2



-
OutletTown.com!
Real Store Quality, Online Prices.
http://www.outlettown.com

 -Original Message-
 From: Mark Jones 
 Sent: Tuesday, March 28, 2000 10:44 AM
 To:   '[EMAIL PROTECTED]'
 Subject:  RE: Crystal Problems
 
 Look for a product called Re-Crystalise and you might be very impressed.
 It
 produces its reports from crystal reports but puts them in a form readable
 from the web - the only problem being that it produces it in asp page
 format
 - I am sure you guys are intelligent enough to cope with this.
 
 Mark
 
   -Original Message-
   From:   Brian Grant [SMTP:[EMAIL PROTECTED]]
   Sent:   Tue, 28 Mar 2000 15:42
   To: [EMAIL PROTECTED]
   Subject:Re: Crystal Problems
 
   Crystal Reports never has played very well with CF in my opinion.
 You'll be
   better off looking for other reporting options besides Crystal
 Reports.
   We've had to go to a mix of HTML, Excel, and VB Scripted reporting
 methods.
 
   Good luck.
 
   brian
   
- Original Message -
From: "Eric Bradburn" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, March 27, 2000 5:56 PM
Subject: Crystal Problems
   
   
 We are running ColdFusion Server 4.5 and trying to use the
 cfreport
 tag. Our server is running Crystal Reports version 8.0.  When we
 reference a report with the cfreport tag we are getting this
 error...



 Error Diagnostic Information


 Error occurred while processing CFREPORT



 An unexpected error occurred while using the Crystal Engine.


 Error number 692 ocurred (Error in File
 C:\Inetpub\wwwroot\working.rpt:
 Invalid export DLL or export format.).


 Crystal Library = C:\WINNT\system32\CRPE32.DLL (1/28/2000 15:16)
 DLL Version = 8.0, Engine Version = 8.0



 The error occurred while processing an element with a general
 identifier

 of (CFREPORT), occupying document position (9:1) to (9:70).
   
   
   
 --
   
Archives: http://www.eGroups.com/list/cf-talk
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.eGroups.com/list/cf-talk
   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.eGroups.com/list/cf-talk
 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.eGroups.com/list/cf-talk
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: CFX_PGP

2000-03-28 Thread Cam Wilson

I am also looking into this. If anyone is using it can you let me what it is
like?

Thanks
Cam

- Original Message -
From: Steve DuPerrieu [EMAIL PROTECTED]
To: cf-talk [EMAIL PROTECTED]
Sent: Monday, March 27, 2000 5:03 PM
Subject: CFX_PGP


 Anyone using this custom tag?  If so, how is it?

 Thanks,
 Steve
 --

 Archives: http://www.eGroups.com/list/cf-talk
 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.eGroups.com/list/cf-talk
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.



Populating 'window.opener' select box

2000-03-28 Thread Chris Wells

Hi list,

Using javascript, I am trying to populate a select box from a window that I
pop up (child window), but am receiving an error.

Here is the offending function:

script language="JavaScript"
function add2options(optText,optVal)

var opts;
opts = window.opener.document.forms[0].list2.options;
opts[opts.length] = new Option(optText,optVal, 0, 0);
}
/script


In the body of my pop-up page, I call the above function with something
like:

cfoutput
input type="checkbox" name="B2" value="Populate"
onClick="javascript:add2options('#query.name#','query.#value#');"
/cfoutput


Does anyone know how to do this, or have an example that could help me?

I would appreciate any help you can give me.

TIA,



 /_)
   (8_))}-  .
 \_)  '.
.--..  Chris Wells
   :'. .'  Enterprise Internet Solutions
'---'`;
 . Syntegra (USA), Inc.
  _.'  [EMAIL PROTECTED]
   .'  651/415-4087
   '._
   ` ' ' '   '  '

--
Archives: http://www.eGroups.com/list/cf-talk
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.



CF hosting

2000-03-28 Thread YungChih Chen

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_01BF98D9.BC9A52BE
Content-Type: text/plain;
charset="windows-1252"

Hi,

I am looking for CF hosing provider, can anyone suggestion some providers?

Thank you very much!

Yungchih

--_=_NextPart_001_01BF98D9.BC9A52BE
Content-Type: text/html;
charset="windows-1252"

!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"
HTML
HEAD
META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=windows-1252"
META NAME="Generator" CONTENT="MS Exchange Server version 5.0.1461.43"
TITLECF hosting/TITLE
/HEAD
BODY

PFONT SIZE=2Hi,/FONT
/P

PFONT SIZE=2I am looking for CF hosing provider, can anyone suggestion some 
providers?/FONT
/P

PFONT SIZE=2Thank you very much!/FONT
/P

PFONT SIZE=2Yungchih/FONT
/P

/BODY
/HTML
--_=_NextPart_001_01BF98D9.BC9A52BE--
--
Archives: http://www.eGroups.com/list/cf-talk
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.



Query Help, Sort by Subquery results?

2000-03-28 Thread Avi Flax

Hello, I am having problems with this query, and I'm hoping someone can help me out. 
(You may need to maximize your mail client window in order to read these queries 
properly, sorry.)

SELECT j.JobID, j.Active, j.JobCode, j.JobName, j.PullDate,
j.PostDate, j.Archived, d.Department, Count(c.ApplicantID) AS ApplicantCount
FROM (T_Jobs j LEFT OUTER JOIN T_Candidates c ON j.JobID = c.JobID)
LEFT OUTER JOIN T_Departments d ON j.DepartmentID = d.DepartmentID
WHERE 1 = 1
CFIF NOT ArchivedAND j.Archived = 0/CFIF
CFIF Len(KeyWords)
CFLOOP LIST="#KeyWords#" INDEX="Word"
AND (j.JobName LIKE '%#Word#%' OR FullDesc LIKE '%#Word#%' OR 
j.JobCode LIKE '%#Word#%')
/CFLOOP
/CFIF
CFIF Len(JobCode)AND j.JobCode LIKE '%#JobCode#%'/CFIF
CFIF DepartmentIDAND j.DepartmentID = #DepartmentID#/CFIF
CFIF JobLevelIDAND j.JobLevelID = #JobLevelID#/CFIF
GROUP BY j.JobID, j.Active, j.JobCode, j.JobName, j.PullDate, j.PostDate, j.Archived, 
d.Department
ORDER BY COUNT(c.ApplicantID) DESC, JobName

This query actually works fine, the problem is that I need to pull out Applicants from 
T_Candidates ONLY when Archived = 0 in that table. I tried adding AND c.Archived = 0 
to the WHERE clause but that seems to cancel out the outer join - so I don't get the 
jobs with no candidates! That's no good.

Then, I tried calculating the value with a subquery:

SELECT j.JobID, j.Active, j.JobCode, j.JobName, j.PullDate, j.PostDate, j.Archived, 
d.Department,
( SELECT Count(ApplicantID) FROM T_Candidates WHERE JobID = j.JobID AND 
Archived = 0 ) AS ApplicantCount
FROM ( T_Jobs j LEFT OUTER JOIN T_Candidates c ON j.JobID = c.JobID )
LEFT OUTER JOIN T_Departments d ON j.DepartmentID = d.DepartmentID
WHERE 1 = 1
CFIF NOT ArchivedAND j.Archived = 0/CFIF
CFIF Len(KeyWords)
CFLOOP LIST="#KeyWords#" INDEX="Word"
AND (j.JobName LIKE '%#Word#%' OR FullDesc LIKE '%#Word#%' OR 
j.JobCode LIKE '%#Word#%')
/CFLOOP
/CFIF
CFIF Len(JobCode)AND j.JobCode LIKE '%#JobCode#%'/CFIF
CFIF DepartmentIDAND j.DepartmentID = #DepartmentID#/CFIF
CFIF JobLevelIDAND j.JobLevelID = #JobLevelID#/CFIF
GROUP BY j.JobID, j.Active, j.JobCode, j.JobName, j.PullDate, j.PostDate, j.Archived, 
d.Department
ORDER BY #OrderBy#

That query gives me the correct results, but then I can't sort by the ApplicantCount! 
I tried sorting by the subquery, but it seems that that does not work (it returned a 
syntax error). As a fluke, I got this query working, where I use the subquery and the 
outer join together:

SELECT j.JobID, j.Active, j.JobCode, j.JobName, j.PullDate, j.PostDate, j.Archived, 
d.Department,
( SELECT Count(ApplicantID) FROM T_Candidates WHERE JobID = j.JobID AND 
Archived = 0 ) AS ApplicantCount
FROM ( T_Jobs j LEFT OUTER JOIN T_Candidates c ON j.JobID = c.JobID )
LEFT OUTER JOIN T_Departments d ON j.DepartmentID = d.DepartmentID
WHERE 1 = 1
CFIF NOT ArchivedAND j.Archived = 0/CFIF
CFIF Len(KeyWords)
CFLOOP LIST="#KeyWords#" INDEX="Word"
AND (j.JobName LIKE '%#Word#%' OR FullDesc LIKE '%#Word#%' OR 
j.JobCode LIKE '%#Word#%')
/CFLOOP
/CFIF
CFIF Len(JobCode)AND j.JobCode LIKE '%#JobCode#%'/CFIF
CFIF DepartmentIDAND j.DepartmentID = #DepartmentID#/CFIF
CFIF JobLevelIDAND j.JobLevelID = #JobLevelID#/CFIF
GROUP BY j.JobID, j.Active, j.JobCode, j.JobName, j.PullDate, j.PostDate, j.Archived, 
d.Department
ORDER BY COUNT(c.ApplicantID) DESC, JobName

This seems to return the correct results, at first glance. But really the count it's 
sorting by isn't accurate, and there could be a job with 20 archived applicants listed 
above a job with 20 non-archived applicants - no good.

If you've gotten this far, thanks for reading! And here's what I think I need: Either: 
a way to sort by a subquery, if that's possible, OR, some way to specify a WHERE 
condition on ONLY the records from the T_Candidates table, without compromising the 
outer join.

My platform is NT4SP5/IIS4/CF4.01/Access97.

Thanks in advance for any help!

Avi


-
Avi Flax
Web Applications Developer
Words In Progress, Inc.
[EMAIL PROTECTED]
http://www.wordsinprogress.com

--
Archives: http://www.eGroups.com/list/cf-talk
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: Javascript Navigation Bar - I need one.

2000-03-28 Thread Erika Foster

No,  the menu is on a page with now frames.

The script and DHTML run PERFECT - until I resize the browser window.

Thanks for the idea!
Erika

- Original Message -
From: Eddie Shipman [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, March 28, 2000 8:36 AM
Subject: RE: Javascript Navigation Bar - I need one.


 You wouldn't, by chance, have that menu in a top frame, would you?
 DHTM elements can't span frames and that includes the dropdown!

 
 Thanks, that's the one I tried.  But if you resize the browser
 window while
 viewing a .cfm page, it blows away the form variables it was
 passed.  Maybe
 I can modify it to take away the "reposition" function.  I did
 really like
 it otherwise.
 
 Thanks,
 



 **
 This email and any files transmitted with it are confidential and
 intended solely for the use of the individual or entity to whom they
 are addressed. If you have received this email in error please notify
 the system manager.

 This footnote also confirms that this email message has been swept by
 MIMEsweeper for the presence of computer viruses.

 www.mimesweeper.com
 **
 --

 Archives: http://www.eGroups.com/list/cf-talk
 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.eGroups.com/list/cf-talk
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: Javascript Navigation Bar - I need one.

2000-03-28 Thread Erika Foster

I found a good one that doesn't mess with my form variables:

http://www.dynamicdrive.com/dynamicindex1/sm/index.htm

I just need to dress it up a bit, but its easy to configure and run on my CF
pages.

Thanks for the suggestions.

Erika

- Original Message -
From: Len Conrad [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, March 28, 2000 7:34 AM
Subject: Re: Fw: Javascript Navigation Bar - I need one.


 Another pb we had, was just the nature of the DHTML. You have to make sure
 the pulldowns don't coincide with a form field, because the form field
 wins, can't see the pulldown.

 Len

 


 Thanks, that's the one I tried.  But if you resize the browser window
while
 viewing a .cfm page, it blows away the form variables it was passed.
Maybe
 I can modify it to take away the "reposition" function.  I did really
like
 it otherwise.
 
 Thanks,
 
 Erika
 
   - Original Message -
   From: Len Conrad [EMAIL PROTECTED]
   To: [EMAIL PROTECTED]
   Sent: Tuesday, March 28, 2000 6:28 AM
   Subject: RE: Javascript Navigation Bar - I need one.
  
  
www.BrainJar.com has a nice floating DHTML horizontal menu bar with
   pulldowns.
   
Len
   
==
   
   
Check this site, there are many there:
http://dynamicdrive.com/

 
 I've tried a couple different Javascript navigation bars, but
none of
 =
 them seem to work with my CF pages. The one that looked most =
 eye-pleasing had some kind of repositioning thing going on when
the =
 browser window changed size and it completely blew away all form
=
 variables passed to the template.
 
 I'm not schooled in JS, so something plug-n-chug would be
 great.  I want =
 something VERY much like what www.microsoft.com uses.
 



   
**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom
they
are addressed. If you have received this email in error please
notify
the system manager.

This footnote also confirms that this email message has been swept
by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
   
**
   
  
 
---
   ---
Archives: http://www.eGroups.com/list/cf-talk
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.eGroups.com/list/cf-talk
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.eGroups.com/list/cf-talk
 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.eGroups.com/list/cf-talk
 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.eGroups.com/list/cf-talk
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: More SSL questions

2000-03-28 Thread sbernard

The major browsers are pre-configured to recognize certificate 
authorities like Verisign. If you roll your own, all clients will have 
to add your certificate server to their list of acceptable authorities 
before being able to interact with servers that use certificates issued 
locally. I'm not sure how servers react to clients that use 
certificates from unrecognized authorities.

Steve

- Original Message -
From: "Larry Meadors" [EMAIL PROTECTED]
Date: Tuesday, March 28, 2000 11:40 am
Subject: OT: More SSL questions

 What (if anything) is the advantage of buying a certificate from 
 verisign vs serving up your own with M$ certificate server?
 
 Larry
 
 
 ---
 ---
 Archives: http://www.eGroups.com/list/cf-talk
 To Unsubscribe visit 
 http://www.houseoffusion.com/index.cfm?sidebarbstsbodybsts/cf_talk 
or send a message to [EMAIL PROTECTED] with 
'unsubscribe' in the body.
 

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



Re: Mark and Re-Crystalise

2000-03-28 Thread Todd Ashworth

Do you know who the creators of this software might be?  So far, I haven't
been able to find anything about it.

Todd Ashworth

- Original Message -
From: "Mark Jones" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, March 28, 2000 10:43 AM
Subject: RE: Crystal Problems


 Look for a product called Re-Crystalise and you might be very impressed.
It
 produces its reports from crystal reports but puts them in a form readable
 from the web - the only problem being that it produces it in asp page
format
 - I am sure you guys are intelligent enough to cope with this.

 Mark


--
Archives: http://www.eGroups.com/list/cf-talk
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: CFX_PGP

2000-03-28 Thread Cam Wilson

I am trying to install it now and I am having no luck. I get an error that
tells me the the library associated with the custom tag is not present. I
saw that there was some issue with self extracting zip file not unzipping
the .dll, but I opened the self-extracting file in winzip and extracted the
file myself - Still no luck. Will this work on a system running Person Web
Server? Any other thoughts?

Thanks
Cam


- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, March 28, 2000 1:17 PM
Subject: RE: CFX_PGP


 It's a great tag. Available at www.digitaloutlook.com, very easy to
 implement once you've got pgp installed on the server.

 -Original Message-
 From: Cam Wilson [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, March 28, 2000 12:01 PM
 To: [EMAIL PROTECTED]
 Subject: Re: CFX_PGP


 I am also looking into this. If anyone is using it can you let me what it
is
 like?

 Thanks
 Cam

 - Original Message -
 From: Steve DuPerrieu [EMAIL PROTECTED]
 To: cf-talk [EMAIL PROTECTED]
 Sent: Monday, March 27, 2000 5:03 PM
 Subject: CFX_PGP


  Anyone using this custom tag?  If so, how is it?
 
  Thanks,
  Steve

 --
 
  Archives: http://www.eGroups.com/list/cf-talk
  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.eGroups.com/list/cf-talk
 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.eGroups.com/list/cf-talk
 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.eGroups.com/list/cf-talk
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 hosting

2000-03-28 Thread Kevin Miller


Wow, the prices seem to good to be true.  How is there response when
registering databases ans such?

Thanks!

Kevin Miller
IT Systems Resource Manager
Medtronic Vascular
[EMAIL PROTECTED]
(707) 566-1200

 [EMAIL PROTECTED] 03/29/00 10:44AM 
I use www.prizmweb.com.  Lots of features, not lots of price.  Had
nothing
but good experiences so far.

Todd Ashworth

- Original Message -
From: "YungChih Chen" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, March 28, 2000 12:14 PM
Subject: CF hosting



 Hi,

 I am looking for CF hosing provider, can anyone suggestion some
providers?

 Thank you very much!

 Yungchih


--
Archives: http://www.eGroups.com/list/cf-talk 
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.eGroups.com/list/cf-talk
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.



Alteon Load Balancer's

2000-03-28 Thread Tracy Smith



Has anyone here had any experience with Alteon Load Balancers
(http://www.alteonwebsystems.com)
and Cold Fusion 4.5 together?

We are considering implementing a Load Balancing solution use the Alteon
Balancer.  The
company is only about 4 years old with about 210 Employees.

Please let me know.

Thanks
___
Tracy Smith
Senior Programmer/Cold Fusion Developer
Prize Central Networks, Inc.
Play For Fun! Win For Real!
http://www.prizecentral.com

--
Archives: http://www.eGroups.com/list/cf-talk
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.



looping through a mailing list

2000-03-28 Thread Chris Giminez

This is for a real estate web site where the realtor will add their own property. When 
new property
is added, I want it to check a data table of subscribers who are interested in a 
property fitting
certain criteria, such as price, number of bedrooms, bathrooms, etc.

I thought I had this figured out, but am not getting the desired results.

Here's my code:
**
!--- Get the list of subscribers who wich to be notified. ---
CFQUERY NAME="notify_list" DATASOURCE="kane"
SELECT  *
FROM notify
ORDER BY  date_subscribed
/CFQUERY

!--- Loop through the subscribers ---
cfloop QUERY="notify_list"

!--- Check the desires of the subscriber against the actual values of the property. 
---
cfif
form.bed gte notify_list.des_bed
AND
form.bath gte notify_list.des_bed
AND
form.garage gte notify_list.des_garage
AND
form.price gte notify_list.gt_price
AND
form.price lte notify_list.lt_price
AND
form.sq_ft gte notify_list.des_sq_ft
AND
notify_list.des_city CONTAINS form.city
AND
form.display eq 1
AND
form.status eq "for sale"

!--- Send email if the cfif evaluates true cfmail block will go here when it's 
working right. ---
Send email to cfoutput query="notify_list"#notify_list.first_name#
#notify_list.last_name#/cfoutputbr
cfelse

!--- Don't send email if cfif evaluates to false. cfelse is only here for testing 
now. ---


Don't send email cfoutput query="notify_list"#notify_list.first_name#
#notify_list.last_name#/cfoutputbr

/cfif

/cfloop
**

I currently have just 3 subscrbers in the notify table for testing and the above code 
gives me this
result.

*
Send email to joe testerTest PersonChris Giminez
Don't send email joe testerTest PersonChris Giminez
Don't send email joe testerTest PersonChris Giminez
*
It's somehow evaluating to true and false for each person.

I know I'm close to getting this. If someone could enlighten me I would be most 
grateful.

Thanks!

Chris Giminez
Owner - Cyber Scriber Web Site Design
831-728-4469
ICQ# 2628000





--
Archives: http://www.eGroups.com/list/cf-talk
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: looping through a mailing list

2000-03-28 Thread Allen

what's the record count for teh query notify_list?  Is it 3 also?

- Original Message -
From: "Chris Giminez" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, March 28, 2000 2:13 PM
Subject: looping through a mailing list


 This is for a real estate web site where the realtor will add their own
property. When new property
 is added, I want it to check a data table of subscribers who are
interested in a property fitting
 certain criteria, such as price, number of bedrooms, bathrooms, etc.

 I thought I had this figured out, but am not getting the desired results.

 Here's my code:
 **
 !--- Get the list of subscribers who wich to be notified. ---
 CFQUERY NAME="notify_list" DATASOURCE="kane"
 SELECT  *
 FROM notify
 ORDER BY  date_subscribed
 /CFQUERY

 !--- Loop through the subscribers ---
 cfloop QUERY="notify_list"

 !--- Check the desires of the subscriber against the actual values of the
property. ---
 cfif
 form.bed gte notify_list.des_bed
 AND
 form.bath gte notify_list.des_bed
 AND
 form.garage gte notify_list.des_garage
 AND
 form.price gte notify_list.gt_price
 AND
 form.price lte notify_list.lt_price
 AND
 form.sq_ft gte notify_list.des_sq_ft
 AND
 notify_list.des_city CONTAINS form.city
 AND
 form.display eq 1
 AND
 form.status eq "for sale"
 
 !--- Send email if the cfif evaluates true cfmail block will go here
when it's working right. ---
 Send email to cfoutput query="notify_list"#notify_list.first_name#
 #notify_list.last_name#/cfoutputbr
 cfelse

 !--- Don't send email if cfif evaluates to false. cfelse is only here for
testing now. ---


 Don't send email cfoutput query="notify_list"#notify_list.first_name#
 #notify_list.last_name#/cfoutputbr

 /cfif

 /cfloop
 **

 I currently have just 3 subscrbers in the notify table for testing and the
above code gives me this
 result.

 *
 Send email to joe testerTest PersonChris Giminez
 Don't send email joe testerTest PersonChris Giminez
 Don't send email joe testerTest PersonChris Giminez
 *
 It's somehow evaluating to true and false for each person.

 I know I'm close to getting this. If someone could enlighten me I would be
most grateful.

 Thanks!

 Chris Giminez
 Owner - Cyber Scriber Web Site Design
 831-728-4469
 ICQ# 2628000



 --

 Archives: http://www.eGroups.com/list/cf-talk
 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.eGroups.com/list/cf-talk
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: A Great Free CFML editor

2000-03-28 Thread Owens, Howard


I don't know if it's "RDS" so much as just plain FTP.  But the main thing
you want to be able to do, I would think, is be able to open a page in
HomeSite off the server, make changes and save the changes to the server,
just as if the page was on your local disk.  You can do this in HomeSite.
RDS, as I understand it, would only be useful if you needed to access the
database in HomeSite (to build queries, say).  While a nice feature, it's
far from essential.  And, if you're trying to save money, it's likely that
you're hosting your site on a server that may not (for security reasons)
have RDS turned on (again I've never used RDS, so I'm only speaking from how
I understand the docs).

The bottom line is, HomeSite is a good substitute for beginning CFers who
can't afford Studio.  This is the solution I recommend to all of my students
(if they get HomeSite through journeyed.com, it's only $70, which is a
trivial cost for most of my students).  It gives the students a chance to
learn CF and make sure this is really something they want to invest more
time and money in, and if they do, I always recommend the full Studio
version.  It's just a great tool.

H.



=
Howard Owens
Web Producer
InsideVC.com
mailto:[EMAIL PROTECTED]
=

 -Original Message-
 From: Avi Flax [SMTP:[EMAIL PROTECTED]]
 Sent: Tuesday, March 28, 2000 11:53 AM
 To:   [EMAIL PROTECTED]
 Subject:  RE: A Great Free CFML editor
 
 A little tip for those using Homesite, if you want RDS, just install the
 CF4.5 evaluation trial copy. Even though it expires after a month, RDS
 keeps working, and it's integrated with Windows. Obviously with Homesite
 this will only give you file access, not debugging, but it may help
 someone. I believe the same applies to the new improved style editor
 bundled with 4.5.
 
 HTH,
 Avi
 
 At 11:21 AM 3/28/00 , you wrote:
 Homesite doesn't come with RDS, Datasource integration, or the debugger
 -
 all of which are included with Studio.  Homesite is designed to write
 HTML,
 Studio is designed to write CF.
 
 However, if Studio is too pricey, you can get by quite well with
 Homesite,
 and many people do.
 
 Chris Evans
 
 
--
Archives: http://www.eGroups.com/list/cf-talk
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: DSNless connections

2000-03-28 Thread Todd Ashworth

Eddie:  That looks like it just might do the trick .. thanks :)

Nick:  Yes, that makes sense, I think, except our database structure isn't
quite work that way .. I don't think.  Hmm .. I'm doing too much thinking ..
I'll have to look into that a bit more just be be sure.

Thanks,

Todd Ashworth

- Original Message -
From: "Eddie Shipman" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, March 28, 2000 3:20 PM
Subject: RE: DSNless connections


 I've seen a tip on how to do this with ADO.

http://forums1.allaire.com/DevConf/Index.cfm?CFID=194029CFTOKEN=13562140M
essa
 ge_ID=232685

 And here's some source posted a couple weeks ago:

 !--- COM to ADO to OLEDB ---
 CFOBJECT TYPE="COM" NAME="MyConnection" CLASS="ADODB.Connection"
 ACTION="CREATE"
 cfset isopen =
 MyConnection.Open("Provider=Microsoft.Jet.OLEDB.4.0;Persist Security
 Info=False;Data Source=d:\web\acacia\acacia.mdb","","",-1)
 CFOBJECT TYPE="COM" NAME="MyRS" CLASS="ADODB.Recordset"
 ACTION="CREATE"
 cfset tmp = MyRS.Open("select * from groups", MyConnection,1,1,1)
 cfoutput#myrs.recordcount#/cfoutput
 CFSET MyRS = ""
 CFSET MyConnection = ""


--
Archives: http://www.eGroups.com/list/cf-talk
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: kill the session variables when browser is close.

2000-03-28 Thread Alexander Lamon

To kill session vars upon browser close:

cfif IsDefined("Cookie.CFID") AND IsDefined("Cookie.CFTOKEN")
  cfset cfid_local = Cookie.CFID
  cfset cftoken_local = Cookie.CFTOKEN
  cfcookie name="CFID" value="#cfid_local#"
  cfcookie name="CFTOKEN" value="#cftoken_local#"
/cfif

Just put it in your application.cfm file.



Hi,

there was a post to show how to kill the session variables when user close
browser.
I can not find it, does any one know how to kill the session variables when
user close browser.
The post was show how to kill the session variables in application.cfm

Thank you very much


Yungchih
--
Archives: http://www.eGroups.com/list/cf-talk
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.



linux vs NT (1.5% percent load capacity increase)

2000-03-28 Thread Brook Davies

--=_268809657==_.ALT
Content-Type: text/plain; charset="us-ascii"; format=flowed


Interesting article:

http://www.newsalert.com/bin/story?StoryId=Cooa8ubWbtKvuvtaYmGFQ=LinuxNav= 
na-search-StoryTitle=Linux

These guys upgraded from NT to Linux and report a 1.5 percent load capacity 
per server!

In this article they report a 1.5 percent increase in capacity per server 
but do not mention what platform they were coming from. If you have a look 
at this older article it says that they were running on NT

http://www.techweb.com/wire/story/TWB2328S0004


mmm



At 04:19 PM 28/03/00 -0600, you wrote:
Mcd is starting to move to CF from Lotus Notes.
Although right now CF is only used in their private intranets. It looks 
like they might take CF to the public side in the near future...

w00t,
Aymeric.

[EMAIL PROTECTED] wrote:

  Are you sure Amazone.com is Cold Fusion I know for a fact that
  Toys-R-Us.com, Nike.com, and my company Autobytel.com is all CF.
 
  -Original Message-
  From: Tim Maxwell [mailto:[EMAIL PROTECTED]]
  Sent: Monday, March 27, 2000 1:28 PM
  To: [EMAIL PROTECTED]
  Subject: Re: some high trafic cf websites please
 
  amazon.com and fedex.com are both CF sites.  Hope this helps
 
  Tim
 
  - Original Message -
  From: Interent Gold Coast Properties
  [EMAIL PROTECTED]
  To: [EMAIL PROTECTED]
  Sent: Monday, March 27, 2000 7:07 AM
  Subject: some high trafic cf websites please
 
   Hi,
  
   i am wondering if anyone could direct me to some very high traffic cf
   websites so that i can get some idea as to what cf server firms provide
  high
   quality cf hosting for high traffic sites
  
   Kind Regards
  
   Claude Raiola
   E-Mail: [EMAIL PROTECTED]
   Website: www.internetgoldcoastproperties.com.au
  
  
   
 --
  
   Archives: http://www.eGroups.com/list/cf-talk
   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.eGroups.com/list/cf-talk
  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.eGroups.com/list/cf-talk
  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.eGroups.com/list/cf-talk
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.

--=_268809657==_.ALT
Content-Type: text/html; charset="us-ascii"

html
br
Interesting article:br
br
font color="#FF"ua 
href="http://www.newsalert.com/bin/story?StoryId=Cooa8ubWbtKvuvtaYmGamp;FQ=Linuxamp;Nav=na-search-amp;StoryTitle=Linux"
 
eudora="autourl"http://www.newsalert.com/bin/story?StoryId=Cooa8ubWbtKvuvtaYmGamp;FQ=Linuxamp;Nav=na-search-amp;StoryTitle=Linuxbr
br
/a/font/uThese guys upgraded from NT to Linux and report a 1.5
percent load capacity per server! br
br
In this article they report a 1.5 percent increase in capacity per server
but do not mention what platform they were coming from. If you have a
look at this older article it says that they iwere/i running on
NTbr
br
font color="#FF"ua href="http://www.techweb.com/wire/story/TWB2328S0004" 
eudora="autourl"http://www.techweb.com/wire/story/TWB2328S0004br
br
br
/a/font/ummmbr
br
nbsp;br
br
At 04:19 PM 28/03/00 -0600, you wrote:br
blockquote type=cite citeMcd is starting to move to CF from Lotus
Notes.br
Although right now CF is only used in their private intranets. It looks
like they might take CF to the public side in the near future...br
br
w00t,br
Aymeric.br
br
[EMAIL PROTECTED] wrote:br
br
gt; Are you sure Amazone.com is Cold Fusion I know for a fact
thatbr
gt; Toys-R-Us.com, Nike.com, and my company Autobytel.com is all
CF.br
gt;br
gt; -Original Message-br
gt; From: Tim Maxwell
[a href="mailto:[EMAIL PROTECTED]" 
eudora="autourl"mailto:[EMAIL PROTECTED]/a]br
gt; Sent: Monday, March 27, 2000 1:28 PMbr
gt; To: [EMAIL PROTECTED]br
gt; Subject: Re: some high trafic cf websites pleasebr
gt;br
gt; amazon.com and fedex.com are both CF sites.nbsp; Hope this
helpsbr
gt;br
gt; Timbr
gt;br
gt; - Original Message -br
gt; From: Interent Gold Coast Propertiesbr
gt; lt;[EMAIL PROTECTED]gt;br
gt; To: lt;[EMAIL PROTECTED]gt;br
gt; Sent: Monday, March 27, 2000 7:07 AMbr
gt; Subject: some high trafic cf websites pleasebr

RE: looping through a mailing list

2000-03-28 Thread Jordon Saardchit

Yer wasting a lot of processing power in coldfusion unnecessarily.  You
should build a where clause that replicates the conditions you are searchinf
for in your CFIF, that way you just loop over the result set and send the
email to every single record.  SQL Will handle that much faster than Cold
Fusion will.

Jordon


-Original Message-
From: Chris Giminez [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 28, 2000 1:40 PM
To: [EMAIL PROTECTED]
Subject: looping through a mailing list


This is for a real estate web site where the realtor will add their own
property. When new property
is added, I want it to check a data table of subscribers who are interested
in a property fitting
certain criteria, such as price, number of bedrooms, bathrooms, etc.

I thought I had this figured out, but am not getting the desired results.

Here's my code:
**
!--- Get the list of subscribers who wich to be notified. ---
CFQUERY NAME="notify_list" DATASOURCE="kane"
SELECT  *
FROM notify
ORDER BY  date_subscribed
/CFQUERY

!--- Loop through the subscribers ---
cfloop QUERY="notify_list"

!--- Check the desires of the subscriber against the actual values of the
property. ---
cfif
form.bed gte notify_list.des_bed
AND
form.bath gte notify_list.des_bed
AND
form.garage gte notify_list.des_garage
AND
form.price gte notify_list.gt_price
AND
form.price lte notify_list.lt_price
AND
form.sq_ft gte notify_list.des_sq_ft
AND
notify_list.des_city CONTAINS form.city
AND
form.display eq 1
AND
form.status eq "for sale"

!--- Send email if the cfif evaluates true cfmail block will go here when
it's working right. ---
Send email to cfoutput query="notify_list"#notify_list.first_name#
#notify_list.last_name#/cfoutputbr
cfelse

!--- Don't send email if cfif evaluates to false. cfelse is only here for
testing now. ---


Don't send email cfoutput query="notify_list"#notify_list.first_name#
#notify_list.last_name#/cfoutputbr

/cfif

/cfloop
**

I currently have just 3 subscrbers in the notify table for testing and the
above code gives me this
result.

*
Send email to joe testerTest PersonChris Giminez
Don't send email joe testerTest PersonChris Giminez
Don't send email joe testerTest PersonChris Giminez
*
It's somehow evaluating to true and false for each person.

I know I'm close to getting this. If someone could enlighten me I would be
most grateful.

Thanks!

Chris Giminez
Owner - Cyber Scriber Web Site Design
831-728-4469
ICQ# 2628000






--
Archives: http://www.eGroups.com/list/cf-talk
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.eGroups.com/list/cf-talk
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.



search a database

2000-03-28 Thread Ryan Shrout

This is a multi-part message in MIME format.

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

I know this is probably a really dumb question, but how can I make CF =
search a database field using more than a single word typed into a =
search box?

E.G.; Search: intel ghz

The title of a news entry in my database is "Intel Pentium III 1 GHz Now =
Available" but it won't find and return this entry.  However if the =
search is like this:=20

E.G.; Search: intel

It DOES find the word intel and returns the correct results.  Here is =
the CFQUERY code:

CFQUERY Datasource=3D"Athlonmb" Name=3D"NewsResults"
 SELECT Title, NewsID, Date
 FROM News
 WHERE (Title LIKE '%#SearchText#%')
 ORDER BY Date DESC
/cfquery

Thanks for any help.

-Ryan Shrout
Power Gamerz; K7M.COM
[EMAIL PROTECTED]

--=_NextPart_000_0157_01BF98E6.A3149B80
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.3013.2600" name=3DGENERATOR
STYLE/STYLE
/HEAD
BODY bgColor=3D#ff
DIVFONT face=3DArial size=3D2I know this is probably a really dumb =
question, but=20
how can I make CF search a database field using more than a single word =
typed=20
into a search box?/FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial size=3D2E.G.; Search: intel ghz/FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial size=3D2The title of a news entry in my =
database is "Intel=20
Pentium III 1 GHz Now Available" but it won't find and return this =
entry.nbsp;=20
However if the search is like this: /FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial size=3D2FONT face=3DArial size=3D2E.G.; =
Search:=20
intel/FONT/FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial size=3D2It DOES find the word intel and returns =
the correct=20
results.nbsp; Here is the CFQUERY code:/FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial size=3D2lt;CFQUERY Datasource=3D"Athlonmb"=20
Name=3D"NewsResults"gt;BRnbsp;SELECT Title, NewsID, =
DateBRnbsp;FROM=20
NewsBRnbsp;WHERE (Title LIKE '%#SearchText#%')BRnbsp;ORDER BY Date =

DESCBRlt;/cfquerygt;/FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial size=3D2Thanks for any help./FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial size=3D2-Ryan ShroutBRPower Gamerz; =
K7M.COMBRA=20
href=3D"mailto:[EMAIL PROTECTED]"[EMAIL PROTECTED]/A/FONT/DIV/BODY/HTML

--=_NextPart_000_0157_01BF98E6.A3149B80--

--
Archives: http://www.eGroups.com/list/cf-talk
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: search a database

2000-03-28 Thread Pete Freitag

It's not a dumb question at all, people have PhD's in doing what you just
asked...
Here's one way to do it, keep in mind that I don't have a PHD in searching
algorithms...
cfquery
SELECT whatever FROM table
WHERE
field_name LIKE '%#Replace(search_string, " ", "%' OR field_name  LIKE '%",
"ALL")#%'
/cfquery


The above query will search each word (separated by a space) against the
field.

_
Pete Freitag
CFDEV.COM
Cold Fusion Developer Resources
http://www.cfdev.com/

-Original Message-
From: Ryan Shrout [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 28, 2000 6:49 PM
To: [EMAIL PROTECTED]
Subject: search a database


This is a multi-part message in MIME format.

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

I know this is probably a really dumb question, but how can I make CF =
search a database field using more than a single word typed into a =
search box?

E.G.; Search: intel ghz

The title of a news entry in my database is "Intel Pentium III 1 GHz Now =
Available" but it won't find and return this entry.  However if the =
search is like this:=20

E.G.; Search: intel

It DOES find the word intel and returns the correct results.  Here is =
the CFQUERY code:

CFQUERY Datasource=3D"Athlonmb" Name=3D"NewsResults"
 SELECT Title, NewsID, Date
 FROM News
 WHERE (Title LIKE '%#SearchText#%')
 ORDER BY Date DESC
/cfquery

Thanks for any help.

-Ryan Shrout
Power Gamerz; K7M.COM
[EMAIL PROTECTED]

--=_NextPart_000_0157_01BF98E6.A3149B80
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.3013.2600" name=3DGENERATOR
STYLE/STYLE
/HEAD
BODY bgColor=3D#ff
DIVFONT face=3DArial size=3D2I know this is probably a really dumb =
question, but=20
how can I make CF search a database field using more than a single word =
typed=20
into a search box?/FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial size=3D2E.G.; Search: intel ghz/FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial size=3D2The title of a news entry in my =
database is "Intel=20
Pentium III 1 GHz Now Available" but it won't find and return this =
entry.nbsp;=20
However if the search is like this: /FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial size=3D2FONT face=3DArial size=3D2E.G.; =
Search:=20
intel/FONT/FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial size=3D2It DOES find the word intel and returns =
the correct=20
results.nbsp; Here is the CFQUERY code:/FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial size=3D2lt;CFQUERY Datasource=3D"Athlonmb"=20
Name=3D"NewsResults"gt;BRnbsp;SELECT Title, NewsID, =
DateBRnbsp;FROM=20
NewsBRnbsp;WHERE (Title LIKE '%#SearchText#%')BRnbsp;ORDER BY Date =

DESCBRlt;/cfquerygt;/FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial size=3D2Thanks for any help./FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial size=3D2-Ryan ShroutBRPower Gamerz; =
K7M.COMBRA=20
href=3D"mailto:[EMAIL PROTECTED]"[EMAIL PROTECTED]/A/FONT/DIV/BODY/HTML

--=_NextPart_000_0157_01BF98E6.A3149B80--


--
Archives: http://www.eGroups.com/list/cf-talk
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.eGroups.com/list/cf-talk
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 Query

2000-03-28 Thread David Clay

I am looking to query based on a range of dates.

Could anyone lend a hand with the form and query code for this ?

Thank you 



Dave Clay
Internet Facilitator
Trus Joist, A Weyerhaeuser Business

--
Archives: http://www.eGroups.com/list/cf-talk
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: search a database

2000-03-28 Thread Brook Davies

--=_1016101==_.ALT
Content-Type: text/plain; charset="us-ascii"; format=flowed

You could use a list function and a space delim " " to get each word from a 
text box. then you can do any kind of search you like with each word if you 
are not looking for an exact phrase.

Does that make sense?


At 06:49 PM 28/03/00 -0500, you wrote:
This is a multi-part message in MIME format.

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

I know this is probably a really dumb question, but how can I make CF =
search a database field using more than a single word typed into a =
search box?

E.G.; Search: intel ghz

The title of a news entry in my database is "Intel Pentium III 1 GHz Now =
Available" but it won't find and return this entry.  However if the =
search is like this:=20

E.G.; Search: intel

It DOES find the word intel and returns the correct results.  Here is =
the CFQUERY code:

CFQUERY Datasource=3D"Athlonmb" Name=3D"NewsResults"
  SELECT Title, NewsID, Date
  FROM News
  WHERE (Title LIKE '%#SearchText#%')
  ORDER BY Date DESC
/cfquery

Thanks for any help.

-Ryan Shrout
Power Gamerz; K7M.COM
[EMAIL PROTECTED]

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

!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
I know this is probably a really dumb = question, but=20 how can I make CF 
search a database field using more than a single word = typed=20 into a 
search box?

E.G.; Search: intel ghz

The title of a news entry in my = database is "Intel=20 Pentium III 1 GHz 
Now Available" but it won't find and return this = entry. =20 However if 
the search is like this:

E.G.; = Search:=20 intel

It DOES find the word intel and returns = the correct=20 results.  Here is 
the CFQUERY code:

CFQUERY Datasource=3D"Athlonmb"=20 Name=3D"NewsResults"
  SELECT Title, NewsID, = Date
  FROM=20 News
  WHERE (Title LIKE '%#SearchText#%')
  ORDER BY Date = DESC
/cfquery

Thanks for any help.

-Ryan Shrout
Power Gamerz; = K7M.COM
3d.htm[EMAIL PROTECTED]

--=_NextPart_000_0157_01BF98E6.A3149B80--

--
Archives: http://www.eGroups.com/list/cf-talk
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.

--=_1016101==_.ALT
Content-Type: text/html; charset="us-ascii"

html
You could use a list function and a space delim quot; quot; to get each
word from a text box. then you can do any kind of search you like with
each word if you are not looking for an exact phrase.br
br
Does that make sense?br
br
br
At 06:49 PM 28/03/00 -0500, you wrote:br
blockquote type=cite citeThis is a multi-part message in MIME
format.br
br
--=_NextPart_000_0157_01BF98E6.A3149B80br
Content-Type: text/plain;br
x-tabnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;/x-tabcharset=quot;iso-8859-1quot;br
Content-Transfer-Encoding: quoted-printablebr
br
I know this is probably a really dumb question, but how can I make CF
=br
search a database field using more than a single word typed into a 
=br
search box?br
br
E.G.; Search: intel ghzbr
br
The title of a news entry in my database is quot;Intel Pentium III 1 GHz
Now =br
Availablequot; but it won't find and return this entry.nbsp; However if
the =br
search is like this:=20br
br
E.G.; Search: intelbr
br
It DOES find the word intel and returns the correct results.nbsp; Here
is =br
the CFQUERY code:br
br
lt;CFQUERY Datasource=3Dquot;Athlonmbquot;
Name=3Dquot;NewsResultsquot;gt;br
nbsp;SELECT Title, NewsID, Datebr
nbsp;FROM Newsbr
nbsp;WHERE (Title LIKE '%#SearchText#%')br
nbsp;ORDER BY Date DESCbr
lt;/cfquerygt;br
br
Thanks for any help.br
br
-Ryan Shroutbr
Power Gamerz; K7M.COMbr
[EMAIL PROTECTED]br
br
--=_NextPart_000_0157_01BF98E6.A3149B80br
Content-Type: text/html;br
x-tabnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;/x-tabcharset=quot;iso-8859-1quot;br
Content-Transfer-Encoding: quoted-printablebr
br
lt;!DOCTYPE HTML PUBLIC quot;-//W3C//DTD HTML 4.0
Transitional//ENquot;gt;br
I know this is probably a really dumb = question, but=20 how can I make
CF search a database field using more than a single word = typed=20 into
a search box?br
nbsp;br
E.G.; Search: intel ghzbr
nbsp;br
The title of a news entry in my = database is quot;Intel=20 Pentium III
1 GHz Now Availablequot; but it won't find and return this = entry. =20
However if the search is like this: br
nbsp;br
E.G.; = Search:=20 intelbr
nbsp;br
It DOES find the word intel and returns = the correct=20 results.nbsp;
Here is the CFQUERY code:br
nbsp;br
lt;CFQUERY Datasource=3Dquot;Athlonmbquot;=20
Name=3Dquot;NewsResultsquot;gt;br
nbsp;SELECT Title, NewsID, = Datebr
nbsp;FROM=20 Newsbr
nbsp;WHERE (Title LIKE '%#SearchText#%')br
nbsp;ORDER BY 

SQL question

2000-03-28 Thread Chris Porter

hey guys, here's what i'm trying to do.. maybe some of you sql guru's out
there can help. basically, i've got a field in a record that states the
number of records in another table that i want to view  i need a sql query
to gather those rows.

heres the schema

tblSomeInfo tblData

| uid   |   value  ||- uid  -|-- value -|
|--||---3|---out|
---1|-5||---1|---test---|
---2|-3||---2|--- me ---|
---3|-7||---3|---out|
|---4|--- i |
|---5|--need|
|---6|---help---|


the idea is that after this query, depending on which uid in some info,
only the number of records stored in value will be returned. for instance,
assuming it's uid=1, only 5 records would be returned from tblData. or if
uid=2, only 3 records would be returned.

any ideas on how this can be done?
thnx
-chris



--
Archives: http://www.eGroups.com/list/cf-talk
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 Query

2000-03-28 Thread Pete Freitag

SELECT whatever FROM table
WHERE datefield  #mydate#
AND datefield  #myotherdate#

You may consider using the CreateODBCDateTime() function in there.


Pete Freitag
CFDEV.COM
Cold Fusion Developer Resources
http://www.cfdev.com/

-Original Message-
From: David Clay [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 28, 2000 7:20 PM
To: [EMAIL PROTECTED]
Subject: Date Query


I am looking to query based on a range of dates.

Could anyone lend a hand with the form and query code for this ?

Thank you



Dave Clay
Internet Facilitator
Trus Joist, A Weyerhaeuser Business


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar

--
Archives: http://www.eGroups.com/list/cf-talk
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 Query

2000-03-28 Thread David Clay

Thanks

Dave Clay
Internet Facilitator
Trus Joist, A Weyerhaeuser Business

 [EMAIL PROTECTED] 03/28/00 05:32PM 
SELECT whatever FROM table
WHERE datefield  #mydate#
AND datefield  #myotherdate#

You may consider using the CreateODBCDateTime() function in there.


Pete Freitag
CFDEV.COM
Cold Fusion Developer Resources
http://www.cfdev.com/ 

-Original Message-
From: David Clay [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, March 28, 2000 7:20 PM
To: [EMAIL PROTECTED] 
Subject: Date Query


I am looking to query based on a range of dates.

Could anyone lend a hand with the form and query code for this ?

Thank you



Dave Clay
Internet Facilitator
Trus Joist, A Weyerhaeuser Business


--
Archives: http://www.eGroups.com/list/cf-talk 
To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar 

--
Archives: http://www.eGroups.com/list/cf-talk 
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.eGroups.com/list/cf-talk
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: Populating 'window.opener' select box

2000-03-28 Thread Josh Petrin

checking out the M$ site, i found that they disabled cross-frame (and
apparently cross-window) form option updating in ie 5/win (the article
specifically mentions select boxes, but it appears to be the same problem
you are having).  you can get around this by putting the option adding
function in the parent window and then calling the function and passing the
variables to it from the child window (i tested it in ie 5/win, just to be
sure)...

hope that's more helpful.



Nope,  I still get the error:  'the server threw an exception' (in MSIE
5.01).  The error usually proceeds to take the browser down with it.

It happens when I try to set the variable 'opts'.  Could I be setting up the
object variable (opts) incorrectly?  That's my guess, anyway.  I can read
'opts'

For example:

opts.length  (returns the length)
opts[1].text (returns the name of the first option in the list)

It's just when I try to make a 'new' one that it gets upset.


Bugger.


:: josh.petrin
:: applications.developer
:: cardinal.communications
:: [EMAIL PROTECTED]
:: 510.647.1400.x221
:: fax.510.647.1401
--
Archives: http://www.eGroups.com/list/cf-talk
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.



Announce: ACTCFUG Meeting - 20 April 2000

2000-03-28 Thread Stephen Collins

A N N O U N C E M E N T

ACT ColdFusion User Group Meeting

When:   5:15-6:45PM, Thursday 20 April 2000
Where:  Level 2 Training Centre
Defence Housing Authority
26 Brisbane Avenue
BARTON
ACT 2600
Agenda:
* Welcome to new people
* OO CF Development - Fusebox
Stephen Collins (Senior Business Consultant, PowerLAN)
* Open QA

Light refreshments will be provided.

NOTE: Changed date and start time!
RSVP: Stephen Collins ([EMAIL PROTECTED]) by replying to this
message.  Your response is necessary to estimate catering requirements.

Please circulate this message to your friends and workmates in the developer
community.

Stephen Collins
 
| Stephen Collins|
|  Senior Business Consultant - PowerLAN |
|12/90 Barrier Street FYSHWICK ACT 2609 Australia|
| Ph +61 2 62800370 Fax +61 2 62800380 Cel +61 410 680722|
| [EMAIL PROTECTED]   [EMAIL PROTECTED] |
|   http://www.powerlan.com.au   |
|~~~oOo~~|
|   Before I got into triathlon, I was a normal person.  |
||

--
Archives: http://www.eGroups.com/list/cf-talk
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: Using Visual Source Safe with MACS on an NT network?

2000-03-28 Thread stephen holland chang

does anyone know if you can check out files with a MAC using visual source
safe if the macs are connected through an NT server network?

thanks
stephen

 stephen.holland.chang
 chief.technology.officer
 cardinal.communications
 http://www.cardinalweb.com/
 [EMAIL PROTECTED]
 [EMAIL PROTECTED]
 vox:  (510)647-1400 x.202

--
Archives: http://www.eGroups.com/list/cf-talk
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: IP Tracing

2000-03-28 Thread Steve Pierce

Even this won't work. I host sites from the UK (.uk) and Israel (.il) here
in Michigan, USA. So the computer is in the US, the IP address is here, the
DNS points to the Middle East. Then PSI has a global network. Their IP
address block is registered in the States, but their dial-in POPs in Italy
use that same IP block. Is the IP address US or Italian?

 - Steve


-Original Message-
From: Pete Freitag [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 28, 2000 4:07 PM
To: [EMAIL PROTECTED]
Subject: RE: IP Tracing


There isn't a sure fire way to do this.  An IP address might not always
resolve to a DNS name.  There are some CFX tags in the tag gallery that will
resolve an IP address to a host name.  Figuring out how to find the
geographic location is another issue, that isn't always very accurate.  One
way to do it, is use the top level domain .com, .ca, .us, .uk, etc. You
could build a database relating the top level domain to a Country .ca -
Canada
.com - US
this isn't always very accurate because people outside the US can buy .com
domains, etc.

You could also use the whois database, and the find out where the get the
address of the company from that database, this might be more accurate, but
it requires more processing.


Pete Freitag
CFDEV.COM
Cold Fusion Developer Resources
http://www.cfdev.com/

-Original Message-
From: Scott P. Heffron [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 28, 2000 1:42 PM
To: Cf-Talk
Subject: IP Tracing


Is there a way by getting the requestors IP Address.  Find out which country
or area, they are from.  Part of the application we are working on is asking
for this.

TIA,
Scott Heffron


--
Archives: http://www.eGroups.com/list/cf-talk
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.eGroups.com/list/cf-talk
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.eGroups.com/list/cf-talk
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.



Form not passing variables

2000-03-28 Thread Carter Development

This is a multi-part message in MIME format.

--=_NextPart_000_0093_01BF98FA.43C393C0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I have an odd situation - so simple that I cannot believe that it is =
giving me trouble: =20

I have an upload an image type of form:

!---snip---

form action=3D"imageupload2.cfm?imgpath=3D#imgpath#" =
enctype=3D"multipart/form-data" method=3D"post"
input type=3D"file" name=3D"image" size=3D"30"brinput =
type=3D"submit" value=3D"upload"
/form

!---end snip---

The action portion isn't working so I backtracked to the most basic =
level:  Is the form data getting through . . .  So I changed my action =
page to a simple:

cfoutput#form.image#/cfoutput

Cannot resolve.

Any thoughts? =20

Now this is a script that has worked on NUMEROUS other servers.=20

TIA

Sincerely,
Shawnea Carter

--=_NextPart_000_0093_01BF98FA.43C393C0
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.2614.3500" name=3DGENERATOR
STYLE/STYLE
/HEAD
BODY bgColor=3D#ff
DIVFONT face=3DArial size=3D2I have an odd situation - so simple =
that I cannot=20
believe that it is giving me trouble:nbsp; /FONT/DIV
DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV
DIVFONT face=3DArial size=3D2I have an upload an image type of=20
form:/FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial size=3D2lt;!---snip---gt;/FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial size=3D2lt;form=20
action=3D"imageupload2.cfm?imgpath=3D#imgpath#" =
enctype=3D"multipart/form-data"=20
method=3D"post"gt;BRlt;input type=3D"file" name=3D"image"=20
size=3D"30"gt;lt;brgt;lt;input type=3D"submit" =
value=3D"upload"gt;/FONT/DIV
DIVFONT face=3DArial size=3D2lt;/formgt;/FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial size=3D2lt;!---end snip---gt;/FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial size=3D2The action portion isn't working so I =
backtracked=20
to the most basic level:nbsp; Is the form data getting through . . =
.nbsp; So I=20
changed my action page to a simple:/FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial=20
size=3D2lt;cfoutputgt;#form.image#lt;/cfoutputgt;/FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial size=3D2Cannot resolve./FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial size=3D2Any thoughts?nbsp; /FONT/DIV
DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV
DIVFONT face=3DArial size=3D2Now this is a script that has worked on =
NUMEROUS=20
other servers.nbsp;/FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial size=3D2TIA/FONT/DIV
DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV
DIVFONT face=3DArial size=3D2Sincerely,BRShawnea=20
Carter/FONT/DIV/BODY/HTML

--=_NextPart_000_0093_01BF98FA.43C393C0--

--
Archives: http://www.eGroups.com/list/cf-talk
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.



Multi-Part email! YIPES!

2000-03-28 Thread Carter Development

Apologies for the multi-part - I am using Outlook Express and sent my
message as plain text.  How do I fix that?

Sincerely,
Shawnea Carter
- Original Message -
From: Carter Development [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, March 28, 2000 9:12 PM
Subject: Form not passing variables


 This is a multi-part message in MIME format.

 --=_NextPart_000_0093_01BF98FA.43C393C0
 Content-Type: text/plain;
 charset="iso-8859-1"
 Content-Transfer-Encoding: quoted-printable

 I have an odd situation - so simple that I cannot believe that it is =
 giving me trouble: =20

 I have an upload an image type of form:

 !---snip---

 form action=3D"imageupload2.cfm?imgpath=3D#imgpath#" =
 enctype=3D"multipart/form-data" method=3D"post"
 input type=3D"file" name=3D"image" size=3D"30"brinput =
 type=3D"submit" value=3D"upload"
 /form

 !---end snip---

 The action portion isn't working so I backtracked to the most basic =
 level:  Is the form data getting through . . .  So I changed my action =
 page to a simple:

 cfoutput#form.image#/cfoutput

 Cannot resolve.

 Any thoughts? =20

 Now this is a script that has worked on NUMEROUS other servers.=20

 TIA

 Sincerely,
 Shawnea Carter

 --=_NextPart_000_0093_01BF98FA.43C393C0
 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.2614.3500" name=3DGENERATOR
 STYLE/STYLE
 /HEAD
 BODY bgColor=3D#ff
 DIVFONT face=3DArial size=3D2I have an odd situation - so simple =
 that I cannot=20
 believe that it is giving me trouble:nbsp; /FONT/DIV
 DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV
 DIVFONT face=3DArial size=3D2I have an upload an image type of=20
 form:/FONT/DIV
 DIVnbsp;/DIV
 DIVFONT face=3DArial size=3D2lt;!---snip---gt;/FONT/DIV
 DIVnbsp;/DIV
 DIVFONT face=3DArial size=3D2lt;form=20
 action=3D"imageupload2.cfm?imgpath=3D#imgpath#" =
 enctype=3D"multipart/form-data"=20
 method=3D"post"gt;BRlt;input type=3D"file" name=3D"image"=20
 size=3D"30"gt;lt;brgt;lt;input type=3D"submit" =
 value=3D"upload"gt;/FONT/DIV
 DIVFONT face=3DArial size=3D2lt;/formgt;/FONT/DIV
 DIVnbsp;/DIV
 DIVFONT face=3DArial size=3D2lt;!---end snip---gt;/FONT/DIV
 DIVnbsp;/DIV
 DIVFONT face=3DArial size=3D2The action portion isn't working so I =
 backtracked=20
 to the most basic level:nbsp; Is the form data getting through . . =
 .nbsp; So I=20
 changed my action page to a simple:/FONT/DIV
 DIVnbsp;/DIV
 DIVFONT face=3DArial=20
 size=3D2lt;cfoutputgt;#form.image#lt;/cfoutputgt;/FONT/DIV
 DIVnbsp;/DIV
 DIVFONT face=3DArial size=3D2Cannot resolve./FONT/DIV
 DIVnbsp;/DIV
 DIVFONT face=3DArial size=3D2Any thoughts?nbsp; /FONT/DIV
 DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV
 DIVFONT face=3DArial size=3D2Now this is a script that has worked on =
 NUMEROUS=20
 other servers.nbsp;/FONT/DIV
 DIVnbsp;/DIV
 DIVFONT face=3DArial size=3D2TIA/FONT/DIV
 DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV
 DIVFONT face=3DArial size=3D2Sincerely,BRShawnea=20
 Carter/FONT/DIV/BODY/HTML

 --=_NextPart_000_0093_01BF98FA.43C393C0--

 --

 Archives: http://www.eGroups.com/list/cf-talk
 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.eGroups.com/list/cf-talk
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: linux vs NT (1.5% percent load capacity increase)

2000-03-28 Thread Tim Hoffman

Brook/All-

See my comments below the inline original post:

Original Posting:

_SNIP
Interesting article:

http://www.newsalert.com/bin/story?StoryId=Cooa8ubWbtKvuvtaYmGFQ=LinuxNav
=
na-search-StoryTitle=Linux

These guys upgraded from NT to Linux and report a 1.5 percent load capacity
per server!
_SNIP


Just to clarify quite a bit :o), the article mentions a performance increase
of 50% ("1 1/2 times the performance from each server") over their previous
platform, not 1.5%. Much more in line with what I'd expect (or hope for!)

Tim Hoffman

--
Archives: http://www.eGroups.com/list/cf-talk
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.



Form not passing variables - better format.

2000-03-28 Thread Carter Development

I have an odd situation - so simple that I cannot believe that it is giving
me trouble:

I have an upload an image type of form:

!---snip---

form action="imageupload2.cfm?imgpath=#imgpath#"
enctype="multipart/form-data" method="post"
input type="file" name="image" size="30"brinput type="submit"
value="upload"
/form

!---end snip---

The action portion isn't working so I backtracked to the most basic level:
Is the form data getting through . . .  So I changed my action page to a
simple:

cfoutput#form.image#/cfoutput

Cannot resolve.

Any thoughts?

Now this is a script that has worked on NUMEROUS other servers.

TIA

Sincerely,
Shawnea Carter



--
Archives: http://www.eGroups.com/list/cf-talk
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: linux vs NT (1.5% percent load capacity increase)

2000-03-28 Thread Brook Davies

Right, sorry.. thats what I meant.


At 06:28 PM 28/03/00 -0800, you wrote:
Brook/All-

See my comments below the inline original post:

Original Posting:

_SNIP
 Interesting article:
 
 http://www.newsalert.com/bin/story?StoryId=Cooa8ubWbtKvuvtaYmGFQ=LinuxNav
=
na-search-StoryTitle=Linux
 
 These guys upgraded from NT to Linux and report a 1.5 percent load capacity
 per server!
_SNIP


Just to clarify quite a bit :o), the article mentions a performance increase
of 50% ("1 1/2 times the performance from each server") over their previous
platform, not 1.5%. Much more in line with what I'd expect (or hope for!)

Tim Hoffman

--
Archives: http://www.eGroups.com/list/cf-talk
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.eGroups.com/list/cf-talk
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: Sorting on data in an ARRAY

2000-03-28 Thread Pete Freitag

Sorting a two dimensional array in CF is quite a tricky task, I once wrote
an algorithm that did this it was rather obtuse. I don't where the code is,
it never was used because I let my database do some of the work.  If your
using a database, it's very likely that you can let the database do most of
the work here.  The people who make database engines are smart dudes, so I
have no problem with pushing the load to it db.

Let's get some more details of what you are doing, there is a good chance
you can do this more efficiently.

__
Pete Freitag
CFDEV.COM
Cold Fusion Developer Resources
http://www.cfdev.com/

-Original Message-
From: stephen holland chang [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 28, 2000 9:48 PM
To: [EMAIL PROTECTED]
Subject: Sorting on data in an ARRAY


Hello

anyone know how ArraySort works? If i have  two dimensional array... is
there any way i can specify how the array is sorted based on the data in a
particular column?

thanks!
stephen

 stephen.holland.chang
 chief.technology.officer
 cardinal.communications
 http://www.cardinalweb.com/
 [EMAIL PROTECTED]
 [EMAIL PROTECTED]
 vox:  (510)647-1400 x.202


--
Archives: http://www.eGroups.com/list/cf-talk
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.eGroups.com/list/cf-talk
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: 404 checking

2000-03-28 Thread Pete Freitag

Yes, you would have to use a CFX tag, like CFX_HTTP
(http://www.fsc.follett.com/cf/cfx_http/) it returns Headers

__
Pete Freitag
CFDEV.COM
Cold Fusion Developer Resources
http://www.cfdev.com/

-Original Message-
From: Seth Petry-Johnson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 29, 2000 2:35 AM
To: [EMAIL PROTECTED]
Subject: Re: 404 checking


In the HTTP protocol a 404 Error is returned in the header, your return
might look like this...


Yes, but is that information available through the CFHTTP variables?  I
didn't think it was... but I haven't done much with CFHTTP besides passing
around WDDX stuff, so I'm sure I could be mistaken.

Regards,
Seth Petry-Johnson
Argo Enterprise and Associates


--
Archives: http://www.eGroups.com/list/cf-talk
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.eGroups.com/list/cf-talk
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: Quick Q...

2000-03-28 Thread Kym Kovan

Hi Aidan,

how can I obtain CGI.SCRIPT_NAME minus the index.cfm, like...
/internet/templates/TestCFTemplates/SystemFunctions/

GetDirectoryFromPath() is a nice function but following on from some of the
other posts one way to get everything except the back of a list is to
reverse it, do a ListRest() and flip it back again. Like
Reverse(ListRest(Reverse(path), "delim")), works like a charm is is very
fast. :-)



--

Yours,

Kym
--
Archives: http://www.eGroups.com/list/cf-talk
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: Populating 'window.opener' select box

2000-03-28 Thread David Shadovitz

On Tue, 28 Mar 2000 17:08:43 -0800 Josh Petrin [EMAIL PROTECTED]
writes:
 you can get around this by putting the option 
 adding function in the parent window and then calling the function and 
 passing the variables to it from the child window

That's how I do it.  That way also better adheres to the object-oriented
idea of encapsulation.
-David

YOU'RE PAYING TOO MUCH FOR THE INTERNET!
Juno now offers FREE Internet Access!
Try it today - there's no risk!  For your FREE software, visit:
http://dl.www.juno.com/get/tagj.
--
Archives: http://www.eGroups.com/list/cf-talk
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.