Re: How well does CF run with mySQL?

2000-04-11 Thread pardeep

How well does CF run with mySQL?

Is it better to go with SQL7 or Oracle 8i?

I am doing a prototype app with Access but now need to port to a stronger 
database program.

Any suggestions?

I understand Cold Fusion 4.5 still does not have direct native support for 
mySQL, true or false?

Thanks for 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.



Re: Oracle 8i and WebDB

2000-04-11 Thread pardeep

Does anyone know what WebDB is all about?

Is it the visual equivalent of Cold Fusion Enterprise and the Cold Fusion 
Studio?

Anyone have any good working experience with that tool, would appreciate 
any working experience feedback.

Thanks in advance,
Pardee.
--
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: Can CF be run on a Cobalt RAQ 3?

2000-04-11 Thread pardeep

Can a Linux version of Cold Fusion be run on a Cobalt RAQ 3 (512 megs of RAM)?

Is it advisable?

Are there advantages going this route vs. an NT machine?

Thanks for 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.



Re: javaScripts And ColdFusion

2000-04-11 Thread Jeff

shai  pete,

:~~
: From: Pete Freitag [EMAIL PROTECTED]
:
: You would have to use javascript to post the information
: to another page, you could do this with a hidden frame,
: or an iFrame so the use wouldn't notice it.
: 
: script
: hiddenfrm.document.location = "logmyvars.cfm?colorDepth=" +
: window.screen.colorDepth "whatever=" + whatever;
: /script
:~~

or you could call a cf template in an IMG tag too.

SCRIPT LANGUAGE="JavaScript" TYPE="text/javascript"
  !--
var tracker = 'colordepth=' + screen.colordepth
   + 'height=' + screen.height;
document.write('IMG SRC="tracker.cfm?' + stats
  + '" HEIGHT="1" WIDTH="1" BORDER="0"');
  // --
/SCRIPT

good luck,

.jeff

name://jeff.howden
game://web.development
http://www.evolt.org/
mailto:[EMAIL PROTECTED]

--
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.



really slow website

2000-04-11 Thread Russ Michaels

I have just added another site to my server (running IIS4 on NT4) and for 
some strange reason this site takes ages to load. The site is just basic 
html pages, NO CF yet, not even large graphics.
I have deleted it, re-made it, used different IP's, ports, swapped a 
working site with this ones home directory, nothing I try will get this 
site to behave correctly.
The server is not under any stress, there are 10 odd sites, most of which 
have minimal traffic, I even tried shutting some of them down to see if it 
made a difference.
Yet viewed from any other server it works fine.


Here is a temporary URL on the live serrver, see how slow it is. 
http://212.36.131.132:8080

here it is redirected to my development machine, and it loads fine: 
www.9to5cafe.com

Any light that you can shed on this would be great.






  Satachi Internet Development
--
 Tel/Fax: 0870 787 3610
 Mobile: 07050 648684
 http://www.satachi.com
 email: [EMAIL PROTECTED]

--
 To join the Satachi-news mailing list
 send a blank e-mail to
 mailto:[EMAIL PROTECTED][EMAIL PROTECTED]
 or visit http://www.satachi.listbot.comsatachi.listbot.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: Session Variables

2000-04-11 Thread David E. Crawford

Use an application.cfm file on both virtual sites, with the same name in the
cfapplication tag and the variables will be visible to both.  Maybe not
the most elegant solution, but it works.

DC

- Original Message -
From: Aaron Rouse [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, April 11, 2000 05:02
Subject: Session Variables



 Is there a way to pass a session variable from one domain name to
 another
 when on the same physical server?  I have a session variable that is
 made
 via the QueryNew function and need to use the info contained in that
 variable on a processing page that my user gets to via a form.  The
 processing page however is on a different domain name.  Currently the
 best
 solution I can come up with would be to insert the information into the
 db
 and then pull/view it from my processing page.

 Please cc me on any replies.

 
 --
 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: Stock ticker

2000-04-11 Thread jstiefel

if the owner of the content does not specifically allow syndication, then
it's theft!

-Original Message-
From: Steve Reich [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 10, 2000 4:13 PM
To: [EMAIL PROTECTED]
Subject: RE: Stock ticker 


Also illegal if it grabs from yahoo or something.

Why is this illegal? I didn't write the tag, but I just wondered. Are all
tags that syndicate content via CFHTTP illegal (ie. accuweather, Dilbert,
etc...)??


--
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: Stock ticker

2000-04-11 Thread jstiefel

Yahoo PAYED for their stock market feed. By stealing the content from their
site, you're taking money from both their pockets, and whoever they get
their feed from..

-Original Message-
From: Steve Reich [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 10, 2000 4:30 PM
To: [EMAIL PROTECTED]
Subject: RE: Stock ticker 


Yes, but in the case of Stock Quotes, they are not Yahoo's content. Yahoo is
syndicating this information from the stock market. I understand the line of
thinking here, but I just want to play devil's advocate for a minute. Who
owns the rights to stock market quotes? In the end, all sights are
syndicating the data. If I pulled Yahoo's financial forecast for the future
of a particular stock, I could see how that might be an infringement, but
just the latest stock prices? I'd be interested in the legal argument
here...

-Original Message-
From: Raymond K. Camden [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 10, 2000 4:21 PM
To: [EMAIL PROTECTED]
Subject: RE: Stock ticker


I would assume that any tag that takes content and repurposes for another
web site w/o permission of the original web site would be illegal. Of
course, this reminds of the conversation about discovering someone stealing
your graphics by using IMG SRC="http://www.yourserver.com" and replacing
the graphic with something a bit embarassing. You could do the same thing
here if you find that someone is syndicating your content w/o your approval.

CF_Disclaimer
Of course, I'm not a lawyer.
/CF_Disclaimer

===
Raymond Camden, Cold Fusion Jedi Master for Syntegra (www.syntegra.com)
Allaire Certified Instructor and Member of Team Allaire

Email   : [EMAIL PROTECTED]
ICQ UIN : 3679482

"My ally is the Force, and a powerful ally it is." - Yoda


 -Original Message-
 From: Steve Reich [mailto:[EMAIL PROTECTED]]
 Sent: Monday, April 10, 2000 4:13 PM
 To: [EMAIL PROTECTED]
 Subject: RE: Stock ticker


 Also illegal if it grabs from yahoo or something.

 Why is this illegal? I didn't write the tag, but I just wondered. Are all
 tags that syndicate content via CFHTTP illegal (ie. accuweather, Dilbert,
 etc...)??

 --
 
 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: WDDX , prefilling forms

2000-04-11 Thread Dan G. Switzer, II

Justin,

That's me. Here's the URL:
http://www.oacfug.org/users/dswitzer/forms/

-Dan
++---+
|   name | Dan G. Switzer, II|
|company | PengoWorks.com|
|www | http://www.pengoworks.com |
| mailto | [EMAIL PROTECTED]   |
++---+


-Original Message-
From: Justin MacCarthy [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 11, 2000 6:42 AM
To: [EMAIL PROTECTED]
Subject: WDDX , prefilling forms

Hi people, a vague question 

I remember someone on the list has done a tag, which allows users to go
forward / back in a series of forms, by saving the contents in a wddx
packet, I think it is on one of the CFUG sites ...

Can anyone point me in the right direction???

TIA

~Justin


--
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: Oracle 8i and WebDB

2000-04-11 Thread Janssen Dolores Y (Contractor)

WebDB is an Oracle product.  We are just starting to evaluate it here - so
far it seems to be good for oracle table creation and rapid prototyping but
we already know we won't be switching from coldfusion as my boss thought
last month.  it will probably have certain uses for us, but oracle also has
a m$$ type licensing scheme stuck to it regarding having a license for each
end user of an ap built with it.


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 11, 2000 3:17 AM
To: [EMAIL PROTECTED]
Subject: Re: Oracle 8i and WebDB


Does anyone know what WebDB is all about?

Is it the visual equivalent of Cold Fusion Enterprise and the Cold Fusion 
Studio?

Anyone have any good working experience with that tool, would appreciate 
any working experience feedback.

Thanks in advance,
Pardee.

--
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: really slow website

2000-04-11 Thread Bud

On 4/11/00, Russ Michaels penned:
Here is a temporary URL on the live serrver, see how slow it is.
http://212.36.131.132:8080

here it is redirected to my development machine, and it loads fine:
www.9to5cafe.com

Any light that you can shed on this would be great.

Dismal. I take it this is your own server? Do the other sites load OK?

I don't know if and/or why this would make a difference, but the 
image shim.gif which is called several times doesn't appear to be on 
the server. Could IIS be taking an inordinate amount of time trying 
to find it?


Bud Schneehagen - Tropical Web Creations

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



RE: really slow website

2000-04-11 Thread david

Check your graphic http://212.36.131.132:8080/shim.gif  this image ends in
error. Your server is having problems serving this image.

Note: the background html code is different on each domain.  try posting the
www.9to5cafe.com html code on your live server



david

-Original Message-
From: Russ Michaels [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 11, 2000 5:19 AM
To: [EMAIL PROTECTED]
Subject: really slow website


I have just added another site to my server (running IIS4 on NT4) and for
some strange reason this site takes ages to load. The site is just basic
html pages, NO CF yet, not even large graphics.
I have deleted it, re-made it, used different IP's, ports, swapped a
working site with this ones home directory, nothing I try will get this
site to behave correctly.
The server is not under any stress, there are 10 odd sites, most of which
have minimal traffic, I even tried shutting some of them down to see if it
made a difference.
Yet viewed from any other server it works fine.


Here is a temporary URL on the live serrver, see how slow it is.
http://212.36.131.132:8080

here it is redirected to my development machine, and it loads fine:
www.9to5cafe.com

Any light that you can shed on this would be great.






  Satachi Internet Development
--
 Tel/Fax: 0870 787 3610
 Mobile: 07050 648684
 http://www.satachi.com
 email: [EMAIL PROTECTED]

--
 To join the Satachi-news mailing list
 send a blank e-mail to
 mailto:[EMAIL PROTECTED][EMAIL PROTECTED]
 or visit http://www.satachi.listbot.comsatachi.listbot.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.



pre-selecting items in a multiple list box

2000-04-11 Thread Ricq Pattay

I'm using a CF template that attempts to pre-select several items in a list
box based on values returned from 2 queries. If a match occurs, that entry
in the list box should be selected. There will almost always be more than
one match. Specifically, the list box should list all possible delivery
locations (from the get_del_locn query) and highlight/pre-select those
locations that a user has a record returned for in get_usr_del_locn. What
the code below produces *almost* works - all possible delivery locations are
in the list box, but only *one* of the user's specific locations is selected
even though they might have 4 or 5 locations tied to their usr_id.

So... Why doesn't this code work?

!--- get a user's specific delivery locations ---
  cfquery datasource="centsup_dev" name="get_user_del_locn" debug="yes"
  select user_del.dlo_id
  from del_locn, user_del
  where del_locn.dlo_id = user_del.dlo_id
   and user_del.usr_id = #usr_id#
  /cfquery

!--- get all possible delivery locations ---
  cfquery datasource="centsup_dev" name="get_del_locn" debug="yes"
  select dlo_id, dlo_locn
  from del_locn
  order by dlo_locn
  /cfquery

!--- create the list box; attempt to pre-select user's location(s) ---
  select name="dlo_id" size =5 width=150 multiple
  cfoutput query="get_del_locn"
   cfif #get_user_del_locn.dlo_id# is #get_del_locn.dlo_id#
option value=#get_del_locn.dlo_id# selected#get_del_locn.dlo_locn#
   cfelse
option value=#get_del_locn.dlo_id##get_del_locn.dlo_locn#
   /cfif
  /cfoutput
  /select



Ricq Pattay [EMAIL PROTECTED]
Univ of MN College of Veterinary Medicine




--
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: About changing the oldest one

2000-04-11 Thread Francisco Montes

Supposing that there are no problems with the code itself...

Why don't you use CreateODBCDateTime instead of CreateODBCDate in your code?
At least in that way you will store date information with greater detail...
if the DB is prepared to accept a date/time object for that field.

Also... i had lots of problems once because i used "Date" as the name for
one of my fields in a table. I would recommend you to change it. It could be
reserved and/or confuse the database manager.

Francisco J. Montes-Mantero
Web Developer
QSP Financial Information Systems
[EMAIL PROTECTED]
ICQ: 23816813

- Original Message -
From: "Juan Manuel Tapiola" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, April 11, 2000 2:12 PM
Subject: About changing the oldest one


Hello, I have a database composed of 4 items per category which I want to
replace from the oldest one with new products.  I do this instruction then:

!--- I FIND THE OLDEST ITEM ---
CFQUERY DATASOURCE="principal" QUERY="oldest"
SELECT
MIN(date) AS oldest
FROM recomendadas
WHERE category = #form.category#
/CFQUERY

!--- I REPLACE ---
CFQUERY DATASOURCE="principal"
UPDATE recomendadas
SET cod = #form.cod#
titulo = #form.titulo#
WHERE category = #form.category#
CFOUTPUT QUERY="oldest"
AND date = #createODBCdate(oldest)#
/CFOUTPUT
/CFQUERY

The problem with this is that it just replaces the item if it is 2 days old.
What should I do if I just want to replace the oldest one, no matter if it
is older by a minute?

As an additional data, I made a DB with one minute difference between items
an isolates perfectly the oldest item with this function:

CreateODBCdateTime(oldest)

But I don't know why it does not do it in the above query.

Could anybody help me in this?

I appretiate it a lot

Manuel Tapiola
www.ciudadvideo.com


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=stsbody=sts/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: DISPLAY QUESTION

2000-04-11 Thread Sean Daniels

snip

 however, the looping seems to be more accurate. when i specify 400, for
 instance, the looping returns 399 words while the other way returns just
 370. i'm not sure why that is (btw, i just took the resultant output and
 did a word count on them in word) but you should  be aware of it.
 
 ...just thought it was interesting -emily

That is interesting indeed. Thanks for the research! 


- Sean


Sean Daniels
Manager, Engineering
DealStream.com
[EMAIL PROTECTED]
http://www.dealstream.com

tel: 207.439.6030
cel: 978.764.0779
 


--
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: how well does CF run with mySQL

2000-04-11 Thread Roy Rim

How well does CF run with mySQL?

Is it better to go with SQL7 or Oracle 8i?

I use mySQL and SQL Server 7 with Cold Fusion 4 on NT and they both run
fine.  The thing you need to be aware about mySQL is that it does not
enforce Foreign Keys.  This means you cannot have the database itself
enforce data integrity.  For example, you might have a person table and a
phone table like so:

Person Table
PersonID
Name
Age

Phone Table
PhoneTypeID ( work, home, day, night, mobile )
PersonID
Number

In SQL Server, Oracle and other relational databases, you can have it setup
so that you cannot insert a PersonID into the Phone table unless it exists
in the Person Table.  In mySQL, there is no way to enforce this except by
first checking the Person table with your application, then inserting into
the Phone table.

mySQL also does not have stored procedures.

But mySQL is very, very *fast* because it is missing these features.  It was
made this way on purpose.  There are some surprisingly large sites that use
mySQL, none of which I can remember at the moment.  I know several start ups
that are using mySQL and are very happy.  Eventually they'll make the move
to SQL Server or Oracle, but for now mySQL does the job well.

Roy.

--
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.



Slightly OT: DHTML and z-index

2000-04-11 Thread Mark Jones

Can anyone tell me how I can make a div go ontop of a form element using
z-indexs.  I don't seem to be able to do this.

Cheers

Mark
[EMAIL PROTECTED]
--
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: Tue, 11 Apr 2000 09:46:39 -0400

2000-04-11 Thread Steve Bernard

WebDB is a framework of Oracle Packages written in PL/SQL which allows for
the construction of web-based applications using your existing Oracle DB's
and PL/SQL Packages that you create. It can supposedly leverage Java code
stored in the Oracle DB and run via the internal JVM. As stated before, it
seems best for quick prototyping of query/report apps but, does not provide
anywhere near the available functionality in CF/ASP/JSP. Also, it only works
with Oracle. To make full use of the product you need to have a development
team that knows how to "program" in PL/SQL.

Steve

-Original Message-
From: Janssen Dolores Y (Contractor)
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 11, 2000 8:34 AM
To: '[EMAIL PROTECTED]'
Subject: RE: Oracle 8i and WebDB


WebDB is an Oracle product.  We are just starting to evaluate it here - so
far it seems to be good for oracle table creation and rapid prototyping but
we already know we won't be switching from coldfusion as my boss thought
last month.  it will probably have certain uses for us, but oracle also has
a m$$ type licensing scheme stuck to it regarding having a license for each
end user of an ap built with it.


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 11, 2000 3:17 AM
To: [EMAIL PROTECTED]
Subject: Re: Oracle 8i and WebDB


Does anyone know what WebDB is all about?

Is it the visual equivalent of Cold Fusion Enterprise and the Cold Fusion
Studio?

Anyone have any good working experience with that tool, would appreciate
any working experience feedback.

Thanks in advance,
Pardee.

--
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: Determining Efficency.

2000-04-11 Thread Sharon DiOrio

A great way to determine the actual efficiency of a piece of code is to put
it in a loop.  Looping over the code multiple times makes the actual
numbers more meaningful by ruling out time associated with connections and
CF administrative overhead.

Specific things to look for include using CFSWITCH for anything more than 3
comparisons, using CFSCRIPT for multiple cfsets (but not loops or
comparisons), caching queries and/or creating customized structures for
commonly accessed information.  More efficient code is more of an art than
a series of recipes.  Good luck!

Sharon

At 02:12 PM 4/11/2000 +0100, Ben Lowndes wrote:
Hi,

I'm trying to make some of my scripts as efficent as possible. The script
contains quite a few conditions and nests down to about 4 levels in most
places.

I've tried swapping if-else statements for nested sitch-case. Then
repeatedly running the same query a number of times. Watching the Execution
time useing switch-case averages about 250milliseconds where as if-else
averages about 270milliseconds.

Is there a more "scientific" way of evaluating code efficeny and are there
any resources with tips about writing the most efficent code? For example
would it be better for me not to cfinclude pages if I'm more concerned about
efficency than code reusability or readability??

Thanks
Ben

--
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: cfmail question (sorry about no subject before)

2000-04-11 Thread Roy Rim

is there any way for cfusion to detect failed email, and automatically
remove that address from a database?

from what I understand mail servers generally queue mails before sending
them out, so they only error you can possible receive is a connection error
if the mail server is down.  We're facing similar problems here and I do
believe we're going to handle it by mailing any failed mails to a user we
create and parse those emails for errors.

I believe you should do similar thing, parse the emails for bad users and
delete from your database.

Roy.

--
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: pre-selecting items in a multiple list box

2000-04-11 Thread Francisco Montes

Hi Ricq

Your code is comparing only the first value returned from the
"get_user_del_locn" query with all the others from "get_del_locn" and
thus... only one match can happen... if that.

I didn't think much of a solution though but... how about building only one
query that intersects user locations with all avaliable locations? That will
give you a list of only the locations you really need.

Francisco J. Montes-Mantero
Web Developer
QSP Financial Information Systems
[EMAIL PROTECTED]
(0191) 4023491
ICQ: 23816813

- Original Message -
From: "Ricq Pattay" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, April 11, 2000 2:33 PM
Subject: pre-selecting items in a multiple list box


 I'm using a CF template that attempts to pre-select several items in a
list
 box based on values returned from 2 queries. If a match occurs, that entry
 in the list box should be selected. There will almost always be more than
 one match. Specifically, the list box should list all possible delivery
 locations (from the get_del_locn query) and highlight/pre-select those
 locations that a user has a record returned for in get_usr_del_locn. What
 the code below produces *almost* works - all possible delivery locations
are
 in the list box, but only *one* of the user's specific locations is
selected
 even though they might have 4 or 5 locations tied to their usr_id.

 So... Why doesn't this code work?

 !--- get a user's specific delivery locations ---
   cfquery datasource="centsup_dev" name="get_user_del_locn" debug="yes"
   select user_del.dlo_id
   from del_locn, user_del
   where del_locn.dlo_id = user_del.dlo_id
and user_del.usr_id = #usr_id#
   /cfquery

 !--- get all possible delivery locations ---
   cfquery datasource="centsup_dev" name="get_del_locn" debug="yes"
   select dlo_id, dlo_locn
   from del_locn
   order by dlo_locn
   /cfquery

 !--- create the list box; attempt to pre-select user's location(s) ---
   select name="dlo_id" size =5 width=150 multiple
   cfoutput query="get_del_locn"
cfif #get_user_del_locn.dlo_id# is #get_del_locn.dlo_id#
 option value=#get_del_locn.dlo_id# selected#get_del_locn.dlo_locn#
cfelse
 option value=#get_del_locn.dlo_id##get_del_locn.dlo_locn#
/cfif
   /cfoutput
   /select


 
 Ricq Pattay [EMAIL PROTECTED]
 Univ of MN College of Veterinary Medicine




 --

 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.



Integer?

2000-04-11 Thread jstiefel

Hopefully someone can shed some light on this. I've got a field where I'm
looking for an integer. I then need to verify that this field is in an
increment of 100:

cfif form.myField Mod 100
It's not an increment of 100!
/cfif

Alrighty, that works fine, unless I enter a non-integer in the field (i.e.
"01234567890", even though CFFORM validates this as an integer!) 

My first thought here is to use the Int() function to round this to the
nearest integer:

cfif Int(form.myField) Mod 100
It's not an increment of 100!
/cfif

BUT NO! This does not work as advertised. I'm still getting a "Cannot
convert to integer" from the Mod operator. Is anyone out there dealing with
validating a user's input as an integer? Suggestions?


Jason Stiefel
Applications Developer
iXL, Inc.
1930 Camden Road, Suite 2070
Charlotte, NC 28203
tel. 704.943.7000
fax. 704.943.7001
[EMAIL PROTECTED]
 
--
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: REM out CF codes

2000-04-11 Thread Mike Murry

Use this:

!--- cftag ---

Notice the three dashes on each side (as opposed to the html comment tag
which uses 2 dashes).

Mike Murry
Web Developer
[EMAIL PROTECTED]
214.599.5290 




-Original Message-
From: Michel Gagnon [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 11, 2000 8:43 AM
To: [EMAIL PROTECTED]
Subject: REM out CF codes


This is a multi-part message in MIME format.

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

Hi!

Is there a way to temporarily REM out CF tags=20
so that the server doesn't execute them?



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

!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
HTMLHEAD
META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type
META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR
STYLE/STYLE
/HEAD
BODY bgColor=3D#ff
DIVFONT face=3DArial size=3D2Hi!/FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial size=3D2Is there a way to temporarily REM out =
CF tags=20
/FONT/DIV
DIVFONT face=3DArial size=3D2so that the server doesn't execute=20
them?/FONT/DIV
DIVnbsp;/DIV
DIVnbsp;/DIV/BODY/HTML

--=_NextPart_000_00AB_01BFA3A2.C5C2F160--


--
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/Javascript

2000-04-11 Thread Roy Rim

HI, I'm a cf newbie (about 3 months) and I was given the task of putting a
link on the bottom of every page in a cf site to a) pull the url off the
page they are on b) send the user
and the url to a form to email that url to a friend. My first impulse was
to
use the onrequestend.cfm and use the cgi variable to pull the url off the
page. The problem is that half
the pages in the site are static html pages so the onrequestend.cfm won't
work for the site. So now I think I need a way to do this in Javascript
(pull the url off the page) and then
send them and the url to the email form which will be a cf template. Any
suggestions on how to do this (example code)?

You really should ask the question on a javascript group, but here's the
answer.  Use the location object.
A HREF="#" ONCLICK="self.location.href = 'emailform.cfm?MyURL=' +
scape( location.href )"go to my email form/A

There you go.

Of course you still face the issue of no javascript on the person's browser.
In that case you would print out the above in javascript too.  This way
people without javascript or who have it turned off won't even see the
option.

Of course if you're using something like IIS or Netscape, you can use the
other server-side scripting available to you.

Roy.

--
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: Slightly OT: DHTML and z-index

2000-04-11 Thread Dan G. Switzer, II

Mark,

The odds are you can't. Netscape doesn't like to display any layers on top
of the form fields. IE will place a layer on top of everything but an IFRAME
or TEXTAREA box (I believe that's all, there may be others.)

Supposedly IE v5.5 will fix the layer over IFRAMEs and form fields issue.
Not sure how Netscape 6 will deal with it. It's definitely an annoying
"feature." :)

-Dan
++---+
|   name | Dan G. Switzer, II|
|company | PengoWorks.com|
|www | http://www.pengoworks.com |
| mailto | [EMAIL PROTECTED]   |
++---+


-Original Message-
From: Mark Jones [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 11, 2000 9:27 AM
To: '[EMAIL PROTECTED]'
Subject: Slightly OT: DHTML and z-index

Can anyone tell me how I can make a div go ontop of a form element using
z-indexs.  I don't seem to be able to do this.

Cheers

Mark
[EMAIL PROTECTED]

--
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: REM out CF codes

2000-04-11 Thread Todd Ashworth

!--- cf_tag ---

That?

Todd Ashworth

 
 Hi!
 
 Is there a way to temporarily REM out CF tags=20
 so that the server doesn't execute them?


--
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: REM out CF codes

2000-04-11 Thread jstiefel

Use the C/Java style "//" to comment a line in CFSCRIPT.

-Original Message-
From: David E. Crawford [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 11, 2000 9:53 AM
To: [EMAIL PROTECTED]
Subject: Re: REM out CF codes


similar to HTML remarks, however, they are slightly different

!--- (opens a CF comment)  --- (closes a Cf comment).  Note the 3 dashes.
Note that these style comments do not work in CFSCRIPT, unless you comment
out the whole CFSCRIPT block.

Dc

- Original Message -
From: Michel Gagnon [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, April 11, 2000 13:43
Subject: REM out CF codes


 This is a multi-part message in MIME format.

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

 Hi!

 Is there a way to temporarily REM out CF tags=20
 so that the server doesn't execute them?



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

 !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
 HTMLHEAD
 META content=3D"text/html; charset=3Diso-8859-1" =
 http-equiv=3DContent-Type
 META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR
 STYLE/STYLE
 /HEAD
 BODY bgColor=3D#ff
 DIVFONT face=3DArial size=3D2Hi!/FONT/DIV
 DIVnbsp;/DIV
 DIVFONT face=3DArial size=3D2Is there a way to temporarily REM out =
 CF tags=20
 /FONT/DIV
 DIVFONT face=3DArial size=3D2so that the server doesn't execute=20
 them?/FONT/DIV
 DIVnbsp;/DIV
 DIVnbsp;/DIV/BODY/HTML

 --=_NextPart_000_00AB_01BFA3A2.C5C2F160--

 
 --
 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.



Problem populating certain fields thru update template

2000-04-11 Thread Hubert Earl

This is a multi-part message in MIME format.

--=_NextPart_000_0051_01BFA398.27FB4B80
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi,

I've made an update template which needs to be populated with data =
previously entered into the database.  However, fields referenced by the =
following code are turning up empty:

1. TEXTAREA COLS=3D25 ROWS=3D4 NAME=3D"PartDescription"
 REQUIRED=3D"Yes" MESSAGE=3D"Please enter a description of the part =
you require"
VALUE=3D"#Trim(PartDescription)#"
/TEXTAREA

2. SELECT NAME=3D"make"option =
value=3D"Make"OPTIONNissanOPTIONFiat/SELECT

Please advise me what changes to make.  Thanks.


Sincerely,
---
Hubert Earl
ICQ#:  16199853

I develop  maintain web sites internationally.  I also build web =
applications using CGI scripts written in Perl.  I accept subcontracting =
work.

**Personal web site:  http://www.geocities.com/SiliconValley/Peaks/8702/
(please remember to view this with a sense of humour!)

**Business web page:  http://home.talkcity.com/MigrationPath/hearl/

--=_NextPart_000_0051_01BFA398.27FB4B80
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=3D2Hi,/FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial size=3D2I've made an update template which =
needs to be=20
populated with data previously entered into the database.nbsp; However, =
fields=20
referenced by the following code are turning up empty:/FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial size=3D21.nbsp;lt;TEXTAREA COLS=3D25 ROWS=3D4 =

NAME=3D"PartDescription"BRnbsp;nbsp;nbsp;nbsp;nbsp;REQUIRED=3D"Yes=
"=20
MESSAGE=3D"Please enter a description of the part you=20
require"BRnbsp;nbsp;nbsp;=20
VALUE=3D"#Trim(PartDescription)#"gt;BRnbsp;nbsp;nbsp;=20
lt;/TEXTAREAgt;/FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial size=3D22. lt;SELECT =
NAME=3D"make"gt;lt;option=20
value=3D"Make"gt;lt;OPTIONgt;Nissanlt;OPTIONgt;Fiatlt;/SELECTgt;/=
FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial size=3D2Please advise me what changes to =
make.nbsp;=20
Thanks./FONT/DIV
DIVnbsp;/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial size=3D2Sincerely,/FONT/DIV
DIVFONT face=3DArial size=3D2---BRHubert EarlBRICQ#:nbsp;=20
16199853/FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial size=3D2I develop amp; maintain web sites=20
internationally.nbsp; I also build web applications using CGI scripts =
written=20
in Perl.nbsp; I accept subcontracting work./FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial size=3D2**Personal web site:nbsp; A=20
href=3D"http://www.geocities.com/SiliconValley/Peaks/8702/"http://www.ge=
ocities.com/SiliconValley/Peaks/8702//ABR(please=20
remember to view this with a sense of humour!)/FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial size=3D2**Business web page:nbsp; A=20
href=3D"http://home.talkcity.com/MigrationPath/hearl/"http://home.talkci=
ty.com/MigrationPath/hearl//A/FONT/DIV/BODY/HTML

--=_NextPart_000_0051_01BFA398.27FB4B80--

--
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: Integer?

2000-04-11 Thread mherbene

Well, "01234567890" _is_ an integer, unless the rules have changed.  Maybe
it's  too big for the mod function, though; CF can't handle large numbers (I
don't remember exactly what "large" is).  How about either

val(form.myField) MOD 100

or 

cfif len(form.myfield) LT 6  !---maybe not six, try yourself ---
  cfif form.myfield MOD 100 
...
/cfif

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 11, 2000 9:56 AM
To: [EMAIL PROTECTED]
Subject: Integer?


Hopefully someone can shed some light on this. I've got a field where I'm
looking for an integer. I then need to verify that this field is in an
increment of 100:

cfif form.myField Mod 100
It's not an increment of 100!
/cfif

Alrighty, that works fine, unless I enter a non-integer in the field (i.e.
"01234567890", even though CFFORM validates this as an integer!) 
--
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.



AW: cfmail question (sorry about no subject before)

2000-04-11 Thread lorenz

If you use cfmail you can go to \cfusion\mail\Log\errors.log. Check it for
"550" Or "User unknown". Between these two texts is the wrong email stored.

Armin

-Ursprüngliche Nachricht-
Von: Roy Rim [mailto:[EMAIL PROTECTED]]
Gesendet am: Dienstag, 11. April 2000 18:48
An: [EMAIL PROTECTED]
Betreff: RE: cfmail question (sorry about no subject before)

is there any way for cfusion to detect failed email, and automatically
remove that address from a database?

from what I understand mail servers generally queue mails before sending
them out, so they only error you can possible receive is a connection error
if the mail server is down.  We're facing similar problems here and I do
believe we're going to handle it by mailing any failed mails to a user we
create and parse those emails for errors.

I believe you should do similar thing, parse the emails for bad users and
delete from your database.

Roy.


--
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: Slightly OT: DHTML and z-index

2000-04-11 Thread Tim Bahlke

The 'higher' the index, the 'closer' the element is to the users' eyes.  If
you are simply using on 'layer' to place on top of your document, a z-index
of 1 should suffice.  If you need another element to 'layer' on that, move
up 2, 3, 4, ...

Hope this helps/


Tim

-Original Message-
From: Mark Jones [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 11, 2000 9:27 AM
To: '[EMAIL PROTECTED]'
Subject: Slightly OT: DHTML and z-index

Can anyone tell me how I can make a div go ontop of a form element using
z-indexs.  I don't seem to be able to do this.

Cheers

Mark
[EMAIL PROTECTED]

--
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: Integer?

2000-04-11 Thread Alexander Lamon

Use the IsNumeric function to test for a number value, then perform your 
MOD stuff


Hopefully someone can shed some light on this. I've got a field where I'm
looking for an integer. I then need to verify that this field is in an
increment of 100:

cfif form.myField Mod 100
   It's not an increment of 100!
/cfif

Alrighty, that works fine, unless I enter a non-integer in the field (i.e.
"01234567890", even though CFFORM validates this as an integer!) 

My first thought here is to use the Int() function to round this to the
nearest integer:

cfif Int(form.myField) Mod 100
   It's not an increment of 100!
/cfif

BUT NO! This does not work as advertised. I'm still getting a "Cannot
convert to integer" from the Mod operator. Is anyone out there dealing with
validating a user's input as an integer? Suggestions?


Jason Stiefel
Applications Developer
iXL, Inc.
1930 Camden Road, Suite 2070
Charlotte, NC 28203
tel. 704.943.7000
fax. 704.943.7001
[EMAIL PROTECTED]
 
--

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.



Custom DELL tag???

2000-04-11 Thread Steve Reich

I'm writing a custom tag to retrieve the status of open orders from DELL.
Has anyone written something like this that they would like to share. My tag
seems to be working OK and I still need to handle the errors, but I'd like
to see what else is out there.

Thanks,
Steve


~~
Steve Reich
Backsoft™ Corporation
6960 Professional Parkway East
Suite 100
Sarasota, Florida 34240
Toll Free: (888) 222-6047
Phone: (941) 907-6655 - Ext.1038
Fax: (941) 907-6643

email: [EMAIL PROTECTED]
web: http://www.backsoft.com

"Any sufficiently advanced technology
 is indistinguishable from magic."

  - Arthur C. Clarke
~~

--
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: Integer?

2000-04-11 Thread Chris Tazewell

Try this:

CFIF IsNumeric(myformfield)
 CFSET newint = Int(myformfield)

 CFIF newint MOD 100
  not an integer
 /CFIF
/CFIF

Taz

- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, April 11, 2000 2:55 PM
Subject: Integer?


 Hopefully someone can shed some light on this. I've got a field where I'm
 looking for an integer. I then need to verify that this field is in an
 increment of 100:

 cfif form.myField Mod 100
 It's not an increment of 100!
 /cfif

 Alrighty, that works fine, unless I enter a non-integer in the field (i.e.
 "01234567890", even though CFFORM validates this as an integer!)

 My first thought here is to use the Int() function to round this to the
 nearest integer:

 cfif Int(form.myField) Mod 100
 It's not an increment of 100!
 /cfif

 BUT NO! This does not work as advertised. I'm still getting a "Cannot
 convert to integer" from the Mod operator. Is anyone out there dealing
with
 validating a user's input as an integer? Suggestions?


 Jason Stiefel
 Applications Developer
 iXL, Inc.
 1930 Camden Road, Suite 2070
 Charlotte, NC 28203
 tel. 704.943.7000
 fax. 704.943.7001
 [EMAIL PROTECTED]

 --

 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.



Starting the CF service on Solaris

2000-04-11 Thread Steve Robson

All

A Collegue of mine is attempting to restart cold fusion after the machine
crashed and is getting this error message, can anyone shed some light as to
the cause of the problem or likely solutions:

It's running CF4 on Solaris 2.6

===
ERROR: Unable to start the ColdFusion processes.
Cause: The ColdFusion registry does not appear to be initialized.
You can execute the following command to initialize the registry:
  cfexec -install cfdir -docroot docdir -register id
===

This is the error message that is being generated in the browser:

===
Error Occurred While Processing Request
Error Diagnostic Information
An error occurred while attempting to establish a connection to the server.

The most likely cause of this problem is that the server is not currently
running. Verify that the server is running and restart it if necessary. 

Unix error number 2 occurred: No such file or directory
===

TIA

Steve Robson
Consultant
Planet Online
T. 0113 207 6164
M. 07967 048865
F. 0113 207 6360
ICQ. 23832755

--
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: Slightly OT: DHTML and z-index

2000-04-11 Thread jstiefel

In IE form elements will ALWAYS appear above your other div, regardless of
z-index... Everyone chant with me now: "It's a feature, not a bug."

-Original Message-
From: Mike Murry [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 11, 2000 8:53 AM
To: '[EMAIL PROTECTED]'
Subject: RE: Slightly OT: DHTML and z-index


Just make sure that your div's z-index number is higher than the block
element containing the form.

Example:
style
.formbox {position: absolute; z-index: 2}
.otherdiv {position: absolute; z-index: 3}
/style

div class="formbox"
form
...form elements...
/form
/div
div class="otherdiv"
..blah, blah...
/div

Mike Murry
Web Developer
[EMAIL PROTECTED]
214.599.5290 




-Original Message-
From: Mark Jones [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 11, 2000 8:27 AM
To: '[EMAIL PROTECTED]'
Subject: Slightly OT: DHTML and z-index


Can anyone tell me how I can make a div go ontop of a form element using
z-indexs.  I don't seem to be able to do this.

Cheers

Mark
[EMAIL PROTECTED]

--
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/Javascript

2000-04-11 Thread sherry.zeiss

Is anyone familiar with a Javascript group?

Sherry Zeiss
Infrastructure Support Services

 -Original Message-
 From: Roy Rim [SMTP:[EMAIL PROTECTED]]
 
 You really should ask the question on a javascript group, but here's the
--
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: Integer?

2000-04-11 Thread jstiefel

How could a number "01234567890" be an integer? It's not even a real number!


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 11, 2000 10:28 AM
To: [EMAIL PROTECTED]
Subject: RE: Integer?


Well, "01234567890" _is_ an integer, unless the rules have changed.  Maybe
it's  too big for the mod function, though; CF can't handle large numbers (I
don't remember exactly what "large" is).  How about either

val(form.myField) MOD 100

or 

cfif len(form.myfield) LT 6  !---maybe not six, try yourself ---
  cfif form.myfield MOD 100 
...
/cfif

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 11, 2000 9:56 AM
To: [EMAIL PROTECTED]
Subject: Integer?


Hopefully someone can shed some light on this. I've got a field where I'm
looking for an integer. I then need to verify that this field is in an
increment of 100:

cfif form.myField Mod 100
It's not an increment of 100!
/cfif

Alrighty, that works fine, unless I enter a non-integer in the field (i.e.
"01234567890", even though CFFORM validates this as an integer!) 

--
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.



HTML Form Submit button troubles

2000-04-11 Thread SPENCER, Chris

Hi

I'm new to ColdFusion and although I'm finding it generally easy going I'm
having some troubles using CFINSERT to populate an Access database table.
The trouble is that ColdFusion seems to be interpreting my Submit button as
another form field in which it should be entering a value in the database
table. Since I don't have a column in my database called 'SubmitForm' I'm
getting the following error:

Field name not found in the specified table.  Table = 'DETAILS' Field =
'SUBMITFORM'  The error occurred while processing an element with a general
identifier of (CFINSERT).

When I create a column for the sumbit button the actionpage works just fine.
Does anyone know what I'm doing wrong?

Chris Spencer   




Chris Spencer
Learning Support Technician
Cheltenham  Gloucester College of H.E
Pallas Villa, Park Campus
Cheltenham, UK
01242 532967.
--
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: Starting the CF service on Solaris

2000-04-11 Thread mherbene

From other postings I've seen, the problem is exactly what the error message
says.  The "registry" file in which CF stores config info (basically
everything you set through CF admin) has gotten corrupted.  He could look in
/opt/coldfusion/registry for a backup version of cf.registry that might have
been created by a text editor, etc.  I believe all the "initialization"
process does is copy cf.registry.template (in same dir) to cf.registry, but
following the error message's instructions would be safer.

This would be a good file to make backups of regularly :-).

-Original Message-
From: Steve Robson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 11, 2000 10:45 AM
To: House of Fusion (E-mail)
Subject: Starting the CF service on Solaris


All

A Collegue of mine is attempting to restart cold fusion after the machine
crashed and is getting this error message, can anyone shed some light as to
the cause of the problem or likely solutions:

It's running CF4 on Solaris 2.6

===
ERROR: Unable to start the ColdFusion processes.
Cause: The ColdFusion registry does not appear to be initialized.
You can execute the following command to initialize the registry:
  cfexec -install cfdir -docroot docdir -register id
===

--
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/Javascript

2000-04-11 Thread B.Cravens

 Is anyone familiar with a Javascript group

js-jive.. by the same folks that run this list.. go to houseoffusion.com for
info

Billy Cravens
[EMAIL PROTECTED]


--
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: Starting the CF service on Solaris

2000-04-11 Thread Chris Evans

Try running ./stop -force to kill the registry daemon first.  Then running
./start should work.


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


-Original Message-
From: Steve Robson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 11, 2000 10:45 AM
To: House of Fusion (E-mail)
Subject: Starting the CF service on Solaris


All

A Collegue of mine is attempting to restart cold fusion after the machine
crashed and is getting this error message, can anyone shed some light as to
the cause of the problem or likely solutions:

It's running CF4 on Solaris 2.6

===
ERROR: Unable to start the ColdFusion processes.
Cause: The ColdFusion registry does not appear to be initialized.
You can execute the following command to initialize the registry:
  cfexec -install cfdir -docroot docdir -register id
===

This is the error message that is being generated in the browser:

===
Error Occurred While Processing Request
Error Diagnostic Information
An error occurred while attempting to establish a connection to the server.

The most likely cause of this problem is that the server is not currently
running. Verify that the server is running and restart it if necessary.

Unix error number 2 occurred: No such file or directory
===

TIA

Steve Robson
Consultant
Planet Online
T. 0113 207 6164
M. 07967 048865
F. 0113 207 6360
ICQ. 23832755


--
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.



Is there a CFUG in SE Wisconsin?

2000-04-11 Thread Scott J. Brader

As a new developer in ColdFusion, I was wondering if there is a users group
in Southeast Wisconsin?

Thanks,
Scott


Scott Brader
USAV Group
5485 South Westridge Drive
PO Box 510620
New Berlin, WI 53151-0620
Phone: 262.814.2000
Fax: 262.814.2006

Amateurs Practice Until They Get It Right,
Experts Practice Until They Can't Get It Wrong

Any opinions expressed herein are mine and are not representative of USAV
Communications Group.

--
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 empty list items aren't counted?

2000-04-11 Thread jstiefel

One might ask why this is a problem? If you've got a need for null values,
then use an array. A good developer knows when to use different datatypes.
;-)

-Original Message-
From: Douglas Blocker [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 11, 2000 11:55 AM
To: [EMAIL PROTECTED]
Subject: RE: OT empty list items aren't counted?


From CFML Language Reference 4.0, under CFLOOP, "Looping over a List": "Note
that consecutive delimiters are treated as a single delimiter." What a
feature!
Douglas Blocker
Web Applications Developer
icma.org

 -Original Message-
 From: Jeff Johnson [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, April 11, 2000 9:01 AM
 To: [EMAIL PROTECTED]
 Subject: OT empty list items aren't counted?


 Sorry for the OT post but CF-Talk says I'm not allowed to post for some
 reason... I'm working to get that fixed but in the meantime I
 thought maybe
 you'd have a response for this one...


 I'm stunned to see that in CF, lists like ",1,,2,3,,5" are equal to
 "1,2,3,5"!!

 Is this a bug, poor parsing code or intended behavior?  Forgive
 me for being
 inflamatory but this is the dumbest thing I've seen in a while.  Just in
 case this is a bug, I'm running CF 4.5 on Win 2000 for my development
 server.  Has anyone else been bitten by this?

 CODE:
 cfset list=",1,,2,3,,5"
 cfoutput
   List="#list#"br
   ListLen=#ListLen(list)#br
   cfloop list="#list#" index="item"
   Item = #item#br
   /cfloop
 /cfoutput

 OUTPUTS:
 List=",1,,2,3,,5"
 ListLen=4
 Item = 1
 Item = 2
 Item = 3
 Item = 5


 Thanks and again I'm sorry for the flame but this is really annoying,
 Jeff

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


--
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/fusebox 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: Word document client-side

2000-04-11 Thread Tom Langer

This is a multi-part message in MIME format.

--=_NextPart_000_00A6_01BFA3A3.74F281F0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I'm attempting to create a client-side only web-app to create proposals.

I am going to use javascript array to hold data, and the goal is to =
create word documents.

We can require that the user runs IE 4 + if we'd like - but I need to =
figure out how to create word documents using COM objects.  I've tried =
some stuff using VBScript without success. =20

No server will be used (CF or otherwise), so I must rely on current =
client-side technology.

Help someone?

thx

Tom Langer

--=_NextPart_000_00A6_01BFA3A3.74F281F0
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 size=3D2I'm attempting to create a client-side only web-app =
to create=20
proposals./FONT/DIV
DIVnbsp;/DIV
DIVFONT size=3D2I am going to use javascript array to hold data, and =
the goal=20
is to create word documents./FONT/DIV
DIVnbsp;/DIV
DIVFONT size=3D2We can require that the user runs IE 4 + if we'd =
like - but I=20
need to figure out how to create word documents using COM objects.nbsp; =
I've=20
tried some stuff using VBScript without success.nbsp; /FONT/DIV
DIVnbsp;/DIV
DIVFONT size=3D2No server will be used (CF or otherwise), so I must =
rely=20
onnbsp;current client-side technology./FONT/DIV
DIVnbsp;/DIV
DIVFONT size=3D2Help someone?/FONT/DIV
DIVnbsp;/DIV
DIVFONT size=3D2thx/FONT/DIV
DIVnbsp;/DIV
DIVFONT size=3D2Tom Langer/FONT/DIV/BODY/HTML

--=_NextPart_000_00A6_01BFA3A3.74F281F0--

--
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.



Debugger across multiple templates

2000-04-11 Thread Dan O'Keefe

Does anyone know if the debugger is capable of moving across multiple
templates? For example I have form a that gathers user input and posts to
form b. Form b is where I want to debug. I set my breakpoints there and
start the debugging session from form a. When I post, template flow never
stops at the breakpoints. This is being done in the internal Studio browser.

Dan

--
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: Any good way to maintain server variables?

2000-04-11 Thread Reuben King

In 4EC96B864C1CD211BBC500805FE6FDBC02B48B9E@TCEXCH1, Thompson, Ryan K 
(James Tower) ([EMAIL PROTECTED]) in a fit of unbridled passion, 
wrote:
 We are implementing a clustering solution that can do sticky session but it
 needs a unique value 
 it either a cookie variable or URL variable per server. Rather that changing
 the code on each server I'd like to use 
 a variable that would be unique on each server. Does anyone know of a good
 way to set and maintain a 
 server or cgi variable to do this?

Fine, so create a unique cookie for each server and have a many-to-many 
setup in your database reconciling those unique keys to whatever session 
settings you'd like to store.  I suggest you make your unique server 
cookies very unique and not just an incrementing serial number.

 The domain name will not change in the HTTP header so we can't use that. I
 thought of putting a browser in the startup 
 of each server to hit a page but when CF restarts that is gone. A scheduled
 task every minute but that may not be fast enough.

You can't create a unique cookie name for each server?  What about a 
single cookie that stores each of the server's unique keys in a text 
block that is parsed out by each server programmatically?  

 
 Ryan Thompson
 James Tower Media Design 
 Websites, Multimedia, Videos, Catalogs, e-Catalogs and more.
 http://www.jtmd.com
 mailto:[EMAIL PROTECTED]
 
 --
 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.
 
r
--
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.



HELP!! How to force Word Document to download?

2000-04-11 Thread Scott Becker

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

--_=_NextPart_001_01BFA3CF.381F7B50
Content-Type: text/plain;
charset="iso-8859-1"

Hi, Does anyone know how to force a Word document (or any office
document for that matter) to download in Internet Explorer?? If
I use an CFM file that sends the file to the browser, it always
opens Word in the browser.

I want to force it to download, with the correct filename, as 
in "whatever.doc" instead of "download.cfm". I've seen other 
sites that can do this, such as www.hotoffice.com and 
www.xdrive.com, www.freedrive.com, etc...

Any help would be greatly appreciated!

Scott


--_=_NextPart_001_01BFA3CF.381F7B50
Content-Type: text/html;
charset="iso-8859-1"

!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"
HTML
HEAD
META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"
META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2650.12"
TITLEHELP!! How to force Word Document to download?/TITLE
/HEAD
BODY

PFONT COLOR="#80" SIZE=2 FACE="Tahoma"Hi, Does anyone know how to force a Word 
document (or any officeBR
document for that matter) to download in Internet Explorer?? IfBR
I use an CFM file that sends the file to the browser, it alwaysBR
opens Word in the browser.BR
BR
I want to force it to download, with the correct filename, asBR
in quot;whatever.docquot; instead of quot;download.cfmquot;. I've seen otherBR
sites that can do this, such as www.hotoffice.com andBR
www.xdrive.com, www.freedrive.com, etc...BR
BR
Any help would be greatly appreciated!BR
/FONT
BRBFONT COLOR="#80" SIZE=2 FACE="Verdana"Scott/FONT/BI/II/I
/P

/BODY
/HTML
--_=_NextPart_001_01BFA3CF.381F7B50--
--
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.



Performance and CFEXIT

2000-04-11 Thread Dave Carabetta

I have been doing some testing with the performance time of CFEXIT in my 
applications and have found that it takes .25 seconds just to process the 
tag. While it doesn't look like much by itself, under load, this is a 
tremendous amount of time for a simple tag to execute. Can anybody give me 
insight as to why this tag would be so slow? By the way, I have stripped 
down the code in the custom tag I tested it with, which makes the overhead 
almost negligible.

Thanks,
Dave.
__
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: Any good way to maintain server variables?

2000-04-11 Thread Al Musella, DPM

You could also just test in the application.cfm.. if the server 
variables are not defined, make one up!  If you rely on a scheduled task, 
there will always be a chance that a page could execute before the variable 
is declared and trigger an error.
Al



he domain name will not change in the HTTP header so we can't use that. I
thought of putting a browser in the startup
of each server to hit a page but when CF restarts that is gone. A scheduled
task every minute but that may not be fast enough.


--
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/Javascript

2000-04-11 Thread Steve Reich

Yes... JS-Jive! Filled with lots of CFers too!

Community email addresses:
  Post message: [EMAIL PROTECTED]
  Subscribe:[EMAIL PROTECTED]
  Unsubscribe:  [EMAIL PROTECTED]
  List owner:   [EMAIL PROTECTED]

Shortcut URL to this page:
  http://www.onelist.com/community/JS-Jive

HTH,
Steve Reich

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 11, 2000 10:55 AM
To: [EMAIL PROTECTED]
Subject: RE: CF/Javascript


Is anyone familiar with a Javascript group?

Sherry Zeiss
Infrastructure Support Services

 -Original Message-
 From: Roy Rim [SMTP:[EMAIL PROTECTED]]

 You really should ask the question on a javascript group, but here's the

--
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: Integer?

2000-04-11 Thread mherbene

Huh?  Do you mean because of the leading zero?  Most of the time computers
can ignore that.  What else makes it not an integer?  If I write it as
1,234,567,890 is it an integer?

Not wanting to fight, but curious..



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 11, 2000 11:21 AM
To: [EMAIL PROTECTED]
Subject: RE: Integer?


How could a number "01234567890" be an integer? It's not even a real number!


--
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: CFMAIL Question

2000-04-11 Thread Len Conrad


I have heard horror stories of CFMAIL overloading mail servers.

The pb seems to be more that the CFMAIL SMTP client tends to pile up msgs 
in the CF send mail queue when there is a hiccup and has to be kicked to 
start sending again, or at least that seemed to be a frequently reported pb.

It is possible for an SMTP client to look like a "thundering herd" to one 
SMTP server when delivering tons of mail to a one given server (assuming 
you sort destination address so all msgs for a destination can be delivered 
in one SMTP session, avoiding DNS lookups and session overheads), but if 
your CFMAIL delivery is sprayed over an assortment of SMTP servers, I 
wouldn't worry about that herd pb.  The net tends to govern mail deliver 
speeds more than CFMAIL's sending capacity.

But if your CFMAIL usage is going to dump all mail on a local SMTP server's 
ip address that will relay the mail to the net, then the pb might 
arise.  This is a good approach that offloads delivery from CFMAIL quickly 
and reliably.

2000 mails a day is really peanuts, only 3 per minute per 10 hour day. yawn

Len

--
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 results produce everything in the table...

2000-04-11 Thread Richard Hart

Hi,

I have a simple search form on which you can search on three criteria.
However when I type nothing in the form and hit submit it gives me
everything in
the table. I have tried to over-ride this to no effect. Can anyone point me
in the right direction?

Thanks,

Richard

..

In the results page I have something like:


CFQUERY NAME="blahblah" DATASOURCE="blahblah"

   blahblah

CFIF Trim(VariableOne) IS NOT ""
AND FieldOne LIKE '%#Trim(Form.VariableOne)#%'
/CFIF

CFIF Trim(VariableTwo) IS NOT ""
AND FieldTwo LIKE '%#Trim(Form.VariableTwo)#%'
/CFIF

CFIF Trim(VariableThree) IS NOT ""
AND FieldThree LIKE '%#Trim(Form.VariableThree)#%'
/CFIF

   balhblah

/CFQUERY


--
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: HTML Form Submit button troubles

2000-04-11 Thread David E. Crawford

You can specify the list of formfields to be processed by the CFINSERT tag,
using the FORMFIELDS attribute.  However, in my opinion, reliance on
CFINSERT can have unintended consequences.  I recommend that you use a
CFQUERY with the appropriate SQL statements instead.  This gives you more
flexibility and control in the long run.

DC

- Original Message -
From: SPENCER, Chris [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, April 11, 2000 15:40
Subject: HTML Form Submit button troubles


 Hi

 I'm new to ColdFusion and although I'm finding it generally easy going
 I'm
 having some troubles using CFINSERT to populate an Access database
 table.
 The trouble is that ColdFusion seems to be interpreting my Submit button
 as
 another form field in which it should be entering a value in the
 database
 table. Since I don't have a column in my database called 'SubmitForm'
 I'm
 getting the following error:

 Field name not found in the specified table.  Table = 'DETAILS' Field =
 'SUBMITFORM'  The error occurred while processing an element with a
 general
 identifier of (CFINSERT).

 When I create a column for the sumbit button the actionpage works just
 fine.
 Does anyone know what I'm doing wrong?

 Chris Spencer




 Chris Spencer
 Learning Support Technician
 Cheltenham  Gloucester College of H.E
 Pallas Villa, Park Campus
 Cheltenham, UK
 01242 532967.
 
 --
 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: HTML Form Submit button troubles

2000-04-11 Thread Sean Daniels

 When I create a column for the sumbit button the actionpage works
 just fine.
 Does anyone know what I'm doing wrong?

Do you have a "name" attribute specified for the submit button? If so, so
you need it? This might be the problem although I haven't tested it out.

Other than that, you could use a standard cfquery with the insert
statement instead of using cfinsert. While cfinsert is somewhat useful,
it's kind of clunky and generally I prefer cfquery (as do many others on
this list I suspect). The latter also has the advantage of forcing you to
learn SQL, which beleive me you'll end up having to do anyway.

Good luck.

- Sean


Sean Daniels
Manager, Engineering
DealStream.com
[EMAIL PROTECTED]
http://www.dealstream.com

tel: 207.439.6030
cel: 978.764.0779



--
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/Javascript

2000-04-11 Thread Steve Reich

js-jive.. by the same folks that run this list.. go to houseoffusion.com
for
info

Billy Cravens
[EMAIL PROTECTED]


Just to clarify, JS-Jive is not affiliated in any way to the House of Fusion
or the CF-Talk list. It was started by one of the members of CF-Talk (me)
and does have a large CF community population. Here is the current
information for subscribing (a real home page will be in place shortly):

Community email addresses:
  Post message: [EMAIL PROTECTED]
  Subscribe:[EMAIL PROTECTED]
  Unsubscribe:  [EMAIL PROTECTED]
  List owner:   [EMAIL PROTECTED]

Shortcut URL to this page:
  http://www.onelist.com/community/JS-Jive

Thanks,
Steve Reich

--
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: HTML Form Submit button troubles

2000-04-11 Thread Emily B. Kim

I'm new to ColdFusion and although I'm finding it generally easy going I'm
having some troubles using CFINSERT to populate an Access database table.
The trouble is that ColdFusion seems to be interpreting my Submit button as
another form field in which it should be entering a value in the database
table. Since I don't have a column in my database called 'SubmitForm' I'm
getting the following error:

that's one of the limitations of using CFINSERT...all the fields in the
form will be used in the insert statement. however, you could use the
CFINSERT field's FORMFIELD attribute to explicitly name each field you want
to insert.

the general recommendation, however, is to use a CFQUERY tag with a SQL
insert statement rather than using CFINSERT because the former is much much
more flexible and is quicker.

CFQUERY DATASOURCE="YourDSN"
INSERT INTO TableName (field1, field2, field3)
VALUES (#FORM.field1#, #Form.Field2#, #Form.Field3#)
/CFQUERY

just remember that string fields must have single quotes around them in the
values. -emily

--
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: HTML Form Submit button troubles

2000-04-11 Thread Joy Bedell

Chris,

Leave out "NAME="SubmitForm" in your INPUT TYPE="submit" tag.  Or, better 
yet, don't use CFINSERT at all... write your own CFQUERY to add records to 
the database.

Joy

At 04:40 PM 4/11/00 +0100, you wrote:
Hi

I'm new to ColdFusion and although I'm finding it generally easy going I'm
having some troubles using CFINSERT to populate an Access database table.
The trouble is that ColdFusion seems to be interpreting my Submit button as
another form field in which it should be entering a value in the database
table. Since I don't have a column in my database called 'SubmitForm' I'm
getting the following error:

Field name not found in the specified table.  Table = 'DETAILS' Field =
'SUBMITFORM'  The error occurred while processing an element with a general
identifier of (CFINSERT).

When I create a column for the sumbit button the actionpage works just fine.
Does anyone know what I'm doing wrong?

Chris Spencer




Chris Spencer
Learning Support Technician
Cheltenham  Gloucester College of H.E
Pallas Villa, Park Campus
Cheltenham, UK
01242 532967.
--
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: HTML Form Submit button troubles

2000-04-11 Thread Shawn Regan

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_01BFA3D5.099BFC60
Content-Type: text/plain;
charset="iso-8859-1"

Just don't use the attribute NAME in your INPUT submit tag.

Shawn Regan

-Original Message-
From: SPENCER, Chris [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 11, 2000 8:40 AM
To: '[EMAIL PROTECTED]'
Subject: HTML Form Submit button troubles


Hi

I'm new to ColdFusion and although I'm finding it generally easy going I'm
having some troubles using CFINSERT to populate an Access database table.
The trouble is that ColdFusion seems to be interpreting my Submit button as
another form field in which it should be entering a value in the database
table. Since I don't have a column in my database called 'SubmitForm' I'm
getting the following error:

Field name not found in the specified table.  Table = 'DETAILS' Field =
'SUBMITFORM'  The error occurred while processing an element with a general
identifier of (CFINSERT).

When I create a column for the sumbit button the actionpage works just fine.
Does anyone know what I'm doing wrong?

Chris Spencer   




Chris Spencer
Learning Support Technician
Cheltenham  Gloucester College of H.E
Pallas Villa, Park Campus
Cheltenham, UK
01242 532967.

--
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_01BFA3D5.099BFC60
Content-Type: text/html;
charset="iso-8859-1"
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=3Diso-8859-1"
META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2650.12"
TITLERE: HTML Form Submit button troubles/TITLE
/HEAD
BODY

PFONT SIZE=3D2Just don't use the attribute NAME in your =
lt;INPUTgt; submit tag./FONT
/P

PFONT SIZE=3D2Shawn Regan/FONT
/P

PFONT SIZE=3D2-Original Message-/FONT
BRFONT SIZE=3D2From: SPENCER, Chris [A =
HREF=3D"mailto:[EMAIL PROTECTED]"mailto:[EMAIL PROTECTED]/A]/F=
ONT
BRFONT SIZE=3D2Sent: Tuesday, April 11, 2000 8:40 AM/FONT
BRFONT SIZE=3D2To: '[EMAIL PROTECTED]'/FONT
BRFONT SIZE=3D2Subject: HTML Form Submit button troubles/FONT
/P
BR

PFONT SIZE=3D2Hi/FONT
/P

PFONT SIZE=3D2I'm new to ColdFusion and although I'm finding it =
generally easy going I'm/FONT
BRFONT SIZE=3D2having some troubles using CFINSERT to populate an =
Access database table./FONT
BRFONT SIZE=3D2The trouble is that ColdFusion seems to be =
interpreting my Submit button as/FONT
BRFONT SIZE=3D2another form field in which it should be entering a =
value in the database/FONT
BRFONT SIZE=3D2table. Since I don't have a column in my database =
called 'SubmitForm' I'm/FONT
BRFONT SIZE=3D2getting the following error:/FONT
/P

PFONT SIZE=3D2Field name not found in the specified table.nbsp; =
Table =3D 'DETAILS' Field =3D/FONT
BRFONT SIZE=3D2'SUBMITFORM'nbsp; The error occurred while =
processing an element with a general/FONT
BRFONT SIZE=3D2identifier of (CFINSERT)./FONT
/P

PFONT SIZE=3D2When I create a column for the sumbit button the =
actionpage works just fine./FONT
BRFONT SIZE=3D2Does anyone know what I'm doing wrong?/FONT
/P

PFONT SIZE=3D2Chris Spencernbsp;nbsp; /FONT
/P
BR
BR
BR

PFONT SIZE=3D2Chris Spencer/FONT
BRFONT SIZE=3D2Learning Support Technician/FONT
BRFONT SIZE=3D2Cheltenham amp; Gloucester College of H.E/FONT
BRFONT SIZE=3D2Pallas Villa, Park Campus/FONT
BRFONT SIZE=3D2Cheltenham, UK/FONT
BRFONT SIZE=3D201242 532967./FONT
BRFONT =
SIZE=3D2---=
---/FONT
BRFONT SIZE=3D2Archives: A =
HREF=3D"http://www.eGroups.com/list/cf-talk" =
TARGET=3D"_blank"http://www.eGroups.com/list/cf-talk/A/FONT
BRFONT SIZE=3D2To Unsubscribe visit A =
HREF=3D"http://www.houseoffusion.com/index.cfm?sidebar=3Dlistsbody=3Dli=
sts/cf_talk" =
TARGET=3D"_blank"http://www.houseoffusion.com/index.cfm?sidebar=3Dlists=
body=3Dlists/cf_talk/A or send a message to =
[EMAIL PROTECTED] with 'unsubscribe' in the =
body./FONT/P

/BODY
/HTML
--_=_NextPart_001_01BFA3D5.099BFC60--
--
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 tags for SAS

2000-04-11 Thread Lisa Greenberg


--F87DB1634D05711533B0B307
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

I am very interested in this topic!

Randy Hogg wrote:

 Does anyone know of any custom tags to work with SAS datasets, call SAS
 routines realtime, or any other interaction?  Many thanks.  Randy
 BTW  Great list, I'm learning TONS!

 --
 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.

--F87DB1634D05711533B0B307
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

!doctype html public "-//w3c//dtd html 4.0 transitional//en"
html
I am very interested in this topic!
pRandy Hogg wrote:
blockquote TYPE=CITEDoes anyone know of any custom tags to work with
SAS datasets, call SAS
brroutines realtime, or any other interaction?nbsp; Many thanks.nbsp;
Randy
brBTWnbsp; Great list, I'm learning TONS!
p--
brArchives: a 
href="http://www.eGroups.com/list/cf-talk"http://www.eGroups.com/list/cf-talk/a
brTo Unsubscribe visit a 
href="http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk"http://www.houseoffusion.com/index.cfm?sidebar=listsamp;body=lists/cf_talk/a
or send a message to [EMAIL PROTECTED] with 'unsubscribe'
in the body./blockquote
/html

--F87DB1634D05711533B0B307--

--
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.



sending and waiting for a file - COM object poss?

2000-04-11 Thread Ben Lowndes

Hi,

I'm looking for a bit of advice here. I need to send a file across a that
contains the contents of a CF query network and then wait for a return file
and present the contents of this file to the users browser.

No problem with writing the file, simply use CFFILE. The thing is how can I
get it to send it across the network, then wait for the response. My first
instinct is that CF probably isn't the appropriate tool for this kind of a
job as it would have to sit in a loop waiting for a file to read whilst
maintaining a browser connection. So I thought maybe a COM object which CF
can communicate with would be better, but I know nothing about COM objects -
any advice.

Alternatively I thought about writing a file which refreshes itself every 5
seconds, displaying a please wait message to the user and checks the
directory for the file, if it does this 10 times it displays an error to the
user. Is there a better way to do this??

Thanks
Ben,

--
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: Protecting email links on web pages from spam bots?

2000-04-11 Thread Larry C. Lyons

Simple instead of using [EMAIL PROTECTED], use the Character entity for
it So in this case you'd use whatever#64;company#046;com

HTH,
larry

--
Larry C. Lyons
EBStor.com
8870 Rixlew Lane, Suite 201
Manassas, Virginia 20109-3795
tel: (703) 393-7930 x253
fax: (703) 393-2659
http://www.ebstor.com
http://www.pacel.com
email: [EMAIL PROTECTED]

Chaos, panic, and disorder - my work here is done.
--
"Reuben King" [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
 Some time ago, I heard of a way to thwart spam bots from extracting
 email addresses from web pages but I forgot.  Anyone know?

 Thanks,
 -RK

 --

 Reuben King mailto:[EMAIL PROTECTED]
 Senior Web Consultant
 Stonebridge Technologies http://www.sbti.com/
 Phone: (512) 488-8885 x3332


--
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: Integer?

2000-04-11 Thread Jim Vu

it appears that coldFusion can't handle very large integer. one work around
solution is to check for the last two digits being "00". if they are, the
integer is divisible (or increment of) by 100. here's the fix:
cfif isNumeric(form.myField)
cfset rightTwoDigits = right(form.myField, 2)
cfif rightTwoDigits IS NOT "00"
It's not an increment of 100!
cfelse
yes, it is
/cfif
/cfif

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 11, 2000 6:56 AM
To: [EMAIL PROTECTED]
Subject: Integer?


Hopefully someone can shed some light on this. I've got a field where I'm
looking for an integer. I then need to verify that this field is in an
increment of 100:

cfif form.myField Mod 100
It's not an increment of 100!
/cfif

Alrighty, that works fine, unless I enter a non-integer in the field (i.e.
"01234567890", even though CFFORM validates this as an integer!) 

My first thought here is to use the Int() function to round this to the
nearest integer:

cfif Int(form.myField) Mod 100
It's not an increment of 100!
/cfif

BUT NO! This does not work as advertised. I'm still getting a "Cannot
convert to integer" from the Mod operator. Is anyone out there dealing with
validating a user's input as an integer? Suggestions?


Jason Stiefel
Applications Developer
iXL, Inc.
1930 Camden Road, Suite 2070
Charlotte, NC 28203
tel. 704.943.7000
fax. 704.943.7001
[EMAIL PROTECTED]
 

--
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: Protecting email links on web pages from spam bots?

2000-04-11 Thread Reuben King

Will this work for the mailto: url inside an a href as well as the 
display?

In [EMAIL PROTECTED], Larry C. Lyons ([EMAIL PROTECTED]) in a fit 
of unbridled passion, wrote:
 Simple instead of using [EMAIL PROTECTED], use the Character entity for
 it So in this case you'd use whatever#64;company#046;com
 
 HTH,
 larry
 
 --
 Larry C. Lyons
 EBStor.com
 8870 Rixlew Lane, Suite 201
 Manassas, Virginia 20109-3795
 tel: (703) 393-7930 x253
 fax: (703) 393-2659
 http://www.ebstor.com
 http://www.pacel.com
 email: [EMAIL PROTECTED]
 
 Chaos, panic, and disorder - my work here is done.
 --
 "Reuben King" [EMAIL PROTECTED] wrote in message
 [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
  Some time ago, I heard of a way to thwart spam bots from extracting
  email addresses from web pages but I forgot.  Anyone know?
 
  Thanks,
  -RK
 
  --
 
  Reuben King mailto:[EMAIL PROTECTED]
  Senior Web Consultant
  Stonebridge Technologies http://www.sbti.com/
  Phone: (512) 488-8885 x3332
 
 
 

-- 

Reuben King mailto:[EMAIL PROTECTED]
Senior Web Consultant
Stonebridge Technologies http://www.sbti.com/
Phone: (512) 488-8885 x3332
--
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: Integer?

2000-04-11 Thread Reuben King

In [EMAIL PROTECTED], 
[EMAIL PROTECTED] ([EMAIL PROTECTED]) in a fit of 
unbridled passion, wrote:
 Huh?  Do you mean because of the leading zero?  Most of the time computers
 can ignore that.  What else makes it not an integer?  If I write it as
 1,234,567,890 is it an integer?
 
 Not wanting to fight, but curious..

The previous poster is incorrect. "01234567890" is indeed an integer.  
The computer of course ignores the leading 0. CF's precision will only 
go up to  (12 digits) and then it starts using scientific 
notation.. (1.23456789012E+012).  So, if you want to handle numbers over 
a trillion precisely, you'll have to do some creative programming.

Also, beware the commas.  Strip them out before using val() or integer
().


 
 
 
 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, April 11, 2000 11:21 AM
 To: [EMAIL PROTECTED]
 Subject: RE: Integer?
 
 
 How could a number "01234567890" be an integer? It's not even a real number!
 
 
 --
 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.
 

-- 

Reuben King mailto:[EMAIL PROTECTED]
Senior Web Consultant
Stonebridge Technologies http://www.sbti.com/
Phone: (512) 488-8885 x3332
--
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.



No Subject

2000-04-11 Thread Tim Bahlke

I have a field with numbers ranging from 1-5 that I would like my users to
be able to use as a search criteria.  If the user wishes to search by 3, for
example, I would like to return anything that was 3 or greater.

Can this be done?

Thanks,

Tim


--
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: Is 4.5.1 Solid

2000-04-11 Thread Jennifer

At 09:02 AM 4/10/00 -0700, you wrote:
Hi Dick,

We upgraded to 4.51 and it seemed to cure quite a few ills. So far no
damage. We had previously installed the hot fixes for CFHTTP and CFMAIL and
had switched some CFMAIL calls off to another machine so we didn't have many
problems there. It now does allow the 20,000,000 AOL users that couldn't
complete our pages do so...seems really strange to me that they would allow
such crap to be issued as a release in the first place as an 'upgrade' ;)

You can't really mean that. The problem is on AOL's end. CF Server now 
accommodates the problems on AOL's end. Do you honestly want Allaire to get 
accounts with every major ISP so they can check to see if the ISP's stupid 
procedures mess up the sites? I used to work at a hosting company and the 
focus was on video hosting. Every time we had a broadcast, we would get 
inundated with tech support calls from AOL users asking us why our site was 
broken. You can't imagine how many times I had to explain to people exactly 
why they needed to get a real ISP. AOL uses cached proxy servers and it is 
bad bad bad.

The really funny calls were the AOL users who said "What do you mean you 
don't do tech support for AOL? You're the Internet, right?"


  The ISP who hosts many of my client's sites is considering switching
  to 4.5.1 as the active CF platform.
 
  There have been lots of threads re problems with various 4.5 versions...
 
  I am especially concerned with:
 
  CFHTTP
 
  regexps
 
  CFMAIL
 
  Anyone know of outstanding problems with 4.5.1?
 
  Any killer incompatibilities between 4.0  4.5 1?
 
 
  TIA
 
  Dick
  --

  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 results produce everything in the table...

2000-04-11 Thread Jeff Shepler

Since the search is only restricted to what you type in, if you leave it
blank the search is not restricted. Hence the entire table is returned. What
would you like to have happen instead?

-Original Message-
From: Richard Hart [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 11, 2000 12:23 PM
To: House of Fusion
Subject: search results produce everything in the table...


Hi,

I have a simple search form on which you can search on three criteria.
However when I type nothing in the form and hit submit it gives me
everything in
the table. I have tried to over-ride this to no effect. Can anyone point me
in the right direction?

Thanks,

Richard

..

In the results page I have something like:


CFQUERY NAME="blahblah" DATASOURCE="blahblah"

   blahblah

CFIF Trim(VariableOne) IS NOT ""
AND FieldOne LIKE '%#Trim(Form.VariableOne)#%'
/CFIF

CFIF Trim(VariableTwo) IS NOT ""
AND FieldTwo LIKE '%#Trim(Form.VariableTwo)#%'
/CFIF

CFIF Trim(VariableThree) IS NOT ""
AND FieldThree LIKE '%#Trim(Form.VariableThree)#%'
/CFIF

   balhblah

/CFQUERY



--
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: Can CF be run on a Cobalt RAQ 3?

2000-04-11 Thread pardeep

Can a Linux version of Cold Fusion be run on a Cobalt RAQ 3 (512 megs of RAM)?

Is it advisable?

Are there advantages going this route vs. an NT machine?

Thanks for 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.



Re: Oracle 8i and WebDB

2000-04-11 Thread pardeep

Does anyone know what WebDB is all about?

Is it the visual equivalent of Cold Fusion Enterprise and the Cold Fusion 
Studio?

Anyone have any good working experience with that tool, would appreciate 
any working experience feedback.

Thanks in advance,
Pardee. 
--
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.



CFmail and CRLF!!!

2000-04-11 Thread Brook Davies

I am using Que Mail and Cf 4.5 for linux. If I send a mail message with 
more than one line my mail server will not send it because it is sending 
bare LF.

read: http://cr.yp.to/docs/smtplf.html

After an attempt to send a message with a bare LF, Cfmail will no longer 
even try to send mail until the service is restated. Has anyone experienced 
this before? Is there a fix?? Grr

--
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: Protecting email links on web pages from spam bots?

2000-04-11 Thread Steve Reich

Will this work for the mailto: url inside an a href as well as the 
display?

If you just try it, you'll see that it does. Great tip, Larry!

--
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: Performance Question

2000-04-11 Thread Brook Davies

cfinclude

At 10:29 AM 11/04/00 -0700, you wrote:
Hi Folks,

I was wondering about something when it comes to performance:

Which is faster, a custom tag (CF_mytag not CFX_mytag) or using a
CFINCLUDE to include the code that is being called?

Thanks,

Doug
--
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 in New Zealand

2000-04-11 Thread Cabbage Tree Creative Ltd

Hi

Try www.2day.com based in Auckland - automated online setups and good CF 
knowledge.  We have had sites with them for around 18mths with few hiccups.

cheers
Lawrence Smith
The Chief Cabbage

See a profile of our work at: http://www.cabbagetree.co.nz/

--
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: about updating with CFSCHEDULE

2000-04-11 Thread Scott M. Berry

I am not sure what the original message is about exactly, but it kicked my
mind into a question:

I output the result of the scheduled tasks to a file. Say I want to keep a
log (either appending to that file or in a database preferred).. how would
I go about that? Right now it simply overwrites the last file in there, so I
get one week's worth of results. My only thoughts were to make another
schedule item to rename the file according to the date it was last done (to
keep a list of files with results) but that is no ideal.

Scott M. Berry
--
College of the Canyons Web Design
661.259.7800 x3630
http://www.coc.cc.ca.us

- Original Message -
From: "Sharon DiOrio" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; "CF-Talk-HouseOfFusion"
[EMAIL PROTECTED]
Sent: Tuesday, April 11, 2000 8:33 AM
Subject: Re: about updating with CFSCHEDULE


Well, if you are going to update a template, you will need something to
update it with.  Usually, people store this in a database, and it will need
to be retrieved with a query.  Could you explain more what you are trying
to do?

Sharon

At 11:05 AM 4/11/2000 -0300, Juan Manuel Tapiola wrote:
Hello, I want to keep updated every day a template but I don't want this to
depend on a query.  Instead of that, I want to have a scheduling task to
update this template every day.  How do I do it?  Is it a way to create
application variables?  Is it the best way?

Thank you a lot in advance,

Manuel Tapiola
www.ciudadvideo.com

---
---
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebarstsbodysts/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=stsbody=sts/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: Is 4.5.1 Solid

2000-04-11 Thread Scott M. Berry

Not only do they use cached proxy servers, but they severely filter content.
Wise words: "bad bad bad" =)

Scott M. Berry
--
College of the Canyons Web Design
661.259.7800 x3630
http://www.coc.cc.ca.us


- Original Message -
From: "Jennifer" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, April 11, 2000 10:59 AM
Subject: Re: Is 4.5.1 Solid


 At 09:02 AM 4/10/00 -0700, you wrote:
 Hi Dick,
 
 We upgraded to 4.51 and it seemed to cure quite a few ills. So far no
 damage. We had previously installed the hot fixes for CFHTTP and CFMAIL
and
 had switched some CFMAIL calls off to another machine so we didn't have
many
 problems there. It now does allow the 20,000,000 AOL users that couldn't
 complete our pages do so...seems really strange to me that they would
allow
 such crap to be issued as a release in the first place as an 'upgrade' ;)

 You can't really mean that. The problem is on AOL's end. CF Server now
 accommodates the problems on AOL's end. Do you honestly want Allaire to
get
 accounts with every major ISP so they can check to see if the ISP's stupid
 procedures mess up the sites? I used to work at a hosting company and the
 focus was on video hosting. Every time we had a broadcast, we would get
 inundated with tech support calls from AOL users asking us why our site
was
 broken. You can't imagine how many times I had to explain to people
exactly
 why they needed to get a real ISP. AOL uses cached proxy servers and it is
 bad bad bad.

 The really funny calls were the AOL users who said "What do you mean you
 don't do tech support for AOL? You're the Internet, right?"


   The ISP who hosts many of my client's sites is considering switching
   to 4.5.1 as the active CF platform.
  
   There have been lots of threads re problems with various 4.5
versions...
  
   I am especially concerned with:
  
   CFHTTP
  
   regexps
  
   CFMAIL
  
   Anyone know of outstanding problems with 4.5.1?
  
   Any killer incompatibilities between 4.0  4.5 1?
  
  
   TIA
  
   Dick
 
 --
 
   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 RDS and WINDOWS 2000 Permissions

2000-04-11 Thread Steve Bernard

I can't speak for configuring FTP services using MS FTP under Win2k, I
haven't tried it. As you say, all the FTP servers I have experience with
allow for default directories to be stipulated on a per user or group basis.
I am guessing that this is the same for Win2k otherwise no one will use the
product.

As for CF/RDS, yes, you can configure default directories per user but, you
have to enable and configure Advanced Security to do so. It's a little thick
for me to explain here, I'd say start by reading up on Advanced Security and
RDS in the CF docs and KB (knowledge base).

Regards,

Steve


-Original Message-
From: Sean Renet [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 11, 2000 2:06 PM
To: [EMAIL PROTECTED]
Subject: CF RDS and WINDOWS 2000 Permissions


I hope someone can help me, because I have goten no response from the NT
lists.

All I want to do is be able to assign directories that users are routed
to when they ftp into my box.
In NT 4.0 there was a setting in the actual user configuration where you
specified the folder they log in to.
I am guessing this is Home Folders in 2000, but I cannot seem to get it to
work.

I can ftp into my box using the admin username and password, and
anonomously, but cannot get a user to ftp in.  Can someone explain to me how
to:
a) set a user up in 2000 so they can ftp in using thier user name and
password
b) are directed to the assigned folder when they ftp in.

Also is there a way in CF Server to allow someone to only RDS into specific
folders?  Right now it seems you just need the admin password and that gives
you everything.



--
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:

2000-04-11 Thread Dave Hannum

In your SQL WHERE statement you handle that:

WHERE someField = '#FORM.fieldNumber#'


Dave

=
"Always Drink Upstream From The Herd!"

David Hannum
Web Analyst/Programmer
Ohio University
[EMAIL PROTECTED]
(740) 597-2524



- Original Message -
From: Tim Bahlke [EMAIL PROTECTED]
To: CFTalk [EMAIL PROTECTED]
Sent: Tuesday, April 11, 2000 12:46 PM


I have a field with numbers ranging from 1-5 that I would like my users to
be able to use as a search criteria.  If the user wishes to search by 3, for
example, I would like to return anything that was 3 or greater.

Can this be done?

Thanks,

Tim


--
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: Is 4.5.1 Solid

2000-04-11 Thread Jeff Shepler



-Original Message-
From: Jennifer [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 11, 2000 1:59 PM
To: [EMAIL PROTECTED]
Subject: Re: Is 4.5.1 Solid


At 09:02 AM 4/10/00 -0700, you wrote:
snip

The really funny calls were the AOL users who said "What do you mean you 
don't do tech support for AOL? You're the Internet, right?"
/snip

Our users are always asking us to speed up the internet for them. Like we
have a speed knob back here. Heh.. If we did, you can bet we'd have it
cranked all the way up.

--
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 RDS and WINDOWS 2000 Permissions

2000-04-11 Thread Aaron Johnson

Sean,

In NT 4.0, you didn't actually deal with User Manager for the FTP stuff you
are talking about.  I haven't tried this on 2000, but this is what you do on
NT 4.

1) Create an FTP root.  Set no access for all users to this folder.
2) Create a folder for each user that you want to have FTP access to using
Windows Explorer.
3) Create a virtual FTP directory for each user using the MMC.
4) Assign read/change whatever permissions to each user's directory
depending on what you want them to do

When people login to ftp.yourdomain.com they'll be automatically routed to
the folder you set up for them.  They won't be able to CDUP because they
don't have permissions any where else. That should work.

Aaron

-Original Message-
From: Sean Renet [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 11, 2000 11:06 AM
To: [EMAIL PROTECTED]
Subject: CF RDS and WINDOWS 2000 Permissions


I hope someone can help me, because I have goten no response from the NT
lists.

All I want to do is be able to assign directories that users are routed
to when they ftp into my box.
In NT 4.0 there was a setting in the actual user configuration where you
specified the folder they log in to.
I am guessing this is Home Folders in 2000, but I cannot seem to get it to
work.

I can ftp into my box using the admin username and password, and
anonomously, but cannot get a user to ftp in.  Can someone explain to me how
to:
a) set a user up in 2000 so they can ftp in using thier user name and
password
b) are directed to the assigned folder when they ftp in.

Also is there a way in CF Server to allow someone to only RDS into specific
folders?  Right now it seems you just need the admin password and that gives
you everything.



--
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 results produce everything in the table...

2000-04-11 Thread Dave Hannum

Try this:

Check to see if your form fields are submitted: if not, then stop them and give an 
error message.

CFIF NOT IsDefined("FORM.FieldNames")
STOP AND GO BACK!
CFABORT
/CFIF


=
"Always Drink Upstream From The Herd!"

David Hannum
Web Analyst/Programmer
Ohio University
[EMAIL PROTECTED]
(740) 597-2524



- Original Message -
From: Jeff Shepler [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, April 11, 2000 1:14 PM
Subject: RE: search results produce everything in the table...


Since the search is only restricted to what you type in, if you leave it
blank the search is not restricted. Hence the entire table is returned. What
would you like to have happen instead?

-Original Message-
From: Richard Hart [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 11, 2000 12:23 PM
To: House of Fusion
Subject: search results produce everything in the table...


Hi,

I have a simple search form on which you can search on three criteria.
However when I type nothing in the form and hit submit it gives me
everything in
the table. I have tried to over-ride this to no effect. Can anyone point me
in the right direction?

Thanks,

Richard

...

In the results page I have something like:


CFQUERY NAME="blahblah" DATASOURCE="blahblah"

   blahblah

CFIF Trim(VariableOne) IS NOT ""
AND FieldOne LIKE '%#Trim(Form.VariableOne)#%'
/CFIF

CFIF Trim(VariableTwo) IS NOT ""
AND FieldTwo LIKE '%#Trim(Form.VariableTwo)#%'
/CFIF

CFIF Trim(VariableThree) IS NOT ""
AND FieldThree LIKE '%#Trim(Form.VariableThree)#%'
/CFIF

   balhblah

/CFQUERY



--
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:

2000-04-11 Thread Jeff Shepler

[search.cfm]
...
input type=text name=someField
...
[/search.cfm]


[results.cfm]
...
cfquery bla bla bla
select yada yada yada
fromwhatever
WHERE   someField = #FORM.someField#
/cfquery
...
[/results.cfm]

Something like that??

-Original Message-
From: Tim Bahlke [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 11, 2000 1:46 PM
To: CFTalk
Subject: 


I have a field with numbers ranging from 1-5 that I would like my users to
be able to use as a search criteria.  If the user wishes to search by 3, for
example, I would like to return anything that was 3 or greater.

Can this be done?

Thanks,

Tim



--
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: Integer?

2000-04-11 Thread Grainne E. O'Neill

I'm going to lay out what numbers are what.  For programming purposes these
definitions vary.




All Numbers
Imaginary: Numbers that do not exist for practical purposes.  They have real
value in some engineering fields, and in mathematics.  What number, when
multiplied with itself gives you a negative result.  That would be an
imaginary number.
Real: All numbers that are either negative or positive.  No imaginary
numbers are real numbers.
Rational: All numbers that can be put in fraction form.
Irrational All numbers that cannot be put in fraction form.
Integers: All numbers that do not contain a decimal point
Whole: All numbers that are integers and are not negative
Natural: All numbers that are integers and are not negative and are not
zero.



--
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: Is 4.5.1 Solid

2000-04-11 Thread WBB

Hi Jennifer,


 At 09:02 AM 4/10/00 -0700, you wrote:
 Hi Dick,
 
 We upgraded to 4.51 and it seemed to cure quite a few ills. So far no
 damage. We had previously installed the hot fixes for CFHTTP and CFMAIL
and
 had switched some CFMAIL calls off to another machine so we didn't have
many
 problems there. It now does allow the 20,000,000 AOL users that couldn't
 complete our pages do so...seems really strange to me that they would
allow
 such crap to be issued as a release in the first place as an 'upgrade' ;)

 You can't really mean that. The problem is on AOL's end. CF Server now

Oh yes...I really can mean it ;)...and the problem was with CFServer with
O'Reilly's Website

OR

AOL fixed the problem as we were installing 4.51 ;)

 accommodates the problems on AOL's end. Do you honestly want Allaire to
get
 accounts with every major ISP so they can check to see if the ISP's stupid
 procedures mess up the sites? I used to work at a hosting company and the

Of course not...but I would think that they would test it on the LARGEST
modem community in the world...duh!

 focus was on video hosting. Every time we had a broadcast, we would get
 inundated with tech support calls from AOL users asking us why our site
was
 broken. You can't imagine how many times I had to explain to people
exactly
 why they needed to get a real ISP. AOL uses cached proxy servers and it is
 bad bad bad.

I also do tech support and know just how lame AOL users can be and have used
that same explaination as you did ;), however, that doesn't cover the fact
that submit buttons or graphics buttons or verity searches wouldn't work
using an AOL account until we upgraded to 4.51 (they worked fine with 1.5,
2.0, 2.5, 3.0, 3.1, 4.0 and 4.1) from 4.5

 The really funny calls were the AOL users who said "What do you mean you
 don't do tech support for AOL? You're the Internet, right?"


I understand...we have several hundred customers that use our lines to
connect to their AOL accounts and it's tough to explain to them why their
AOL mail doesn't work ;)

--
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: How to do

2000-04-11 Thread Miriam Hirschman

I did this with java script:
function chkData()
{ 

if((document.frmname.radiobuttonname.checked)(document.frmName.RadioButtonName.value.length
 = 0))
{ 
alert("If you checked 'Other' for question 8, please describe."); 
return false; 
}

else 
{
return true; 
} 
}

I called this function in the form tag:
form name="frmName" action="Page4.cfm" method="POST" onSubmit="return chkData()"

hth

miriam
-Original Message-
From: Sumeet Khanna [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 11, 2000 2:34 PM
To: '[EMAIL PROTECTED]'
Subject: How to do


Can anyone please tell me how to do radio
button validation ,if I want to use 
the check "if radio button "Other" is clicked then only 
enter Other option text in text box"

Sumee
--
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 Talk, calculating elapsed time

2000-04-11 Thread Jeff Shepler

Unfortunately, you cannot tell when a client leaves your site. This makes it
hard to know when to stop timing. Unless you have them click a logoff
button, of course, but you are not guaranteed that they will do so (we all
know how users are).

Couple of different ways you can try to do this.

1. Hidden Frame
You can have a hidden frame that refreshes itself every minute. Each
refresh, you update the database. Once the user leaves your site, that frame
will (hopefully) stop refreshing itself. Problem with this is Netscape
doesn't like hidden frames.

2. Weird things in application.cfm
In your application.cfm file, you have a client variable - we'll call it
HOLDTIME for lack of something else. Every time application.cfm is loaded,
set a TEMP variable to Now(), calculate the difference between TEMP and
HOLDTIME and update the database, set HOLDTIME to TEMP, finish the page. The
problem here is at the end of the client's visit. Since application.cfm will
not be loaded after they leave, you lose whatever time they spent on the
last page.

3. If you want to use a logoff button, you can just take a timestamp when
they login and compare it to the timestamp when they logoff and update the
database. Again, you are not guaranteed that they will use the logoff
button.

Check the archives. The topic of knowing when a client leaves your site
comes up every so often. I don't remember anything off hand, but you should
be able to find it in the archives.

-Original Message-
From: rkern - Prolynx [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 10, 2000 1:55 PM
To: CF-Talk
Subject: CF Talk, calculating elapsed time


To all,
I'm looking for some ideas on how to implement a timer that tracks
customer time on site.

Situation - customer logs in, goes to study pages, at the point of login
I start the timer.  After a ten minute increment the 10 minutes are
added to the totaltime in the user database.  posting may be automatic
or through submit button.  if user leaves during the next 10 minute
increment, nothing is posted to the database.

approaches to date include:
serveral forms of
cfset  Client.ETHours = Abs(DateDiff("h",Client.TimeCreated,
Client.LastVisit)) 
 the problem is that 'timecreated' gives a start date but is a static
value that will allow for total time from when the account is
generated.  'lastvisit' appears to be updated everytime the user comes
back to the page rather than just at login.

Have also considered client session variable storage.  The variables
appear in the database but are all in one field separated by # signs.  I
am looking for something cleaner.

Need - idea that allows a timer function to kick off at login and then
continue to run as long as they are on site in ten minute increments.
The timer is not the issue (I can use a simple loop ), where to
establish it is and how to use it accross the entire session and site
is.

any comments would be appreciated
Thanks
Richard
--
The Prince - Niccollo Machiavelli (1532)
Has some advice to his prince on engaging mercenaries.
Mercenaries are into it for the money and will run at the first sign of
trouble.  Hire men who will die for 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.



Re: CFmail and CRLF!!!

2000-04-11 Thread Jennifer

At 11:29 AM 4/11/00 -0700, you wrote:
I am using Que Mail and Cf 4.5 for linux. If I send a mail message with
more than one line my mail server will not send it because it is sending
bare LF.

read: http://cr.yp.to/docs/smtplf.html

After an attempt to send a message with a bare LF, Cfmail will no longer
even try to send mail until the service is restated. Has anyone experienced
this before? Is there a fix?? Grr

I'm not familiar with the problem, but if you are really running 4.5, you 
might want to upgrade to 4.5.1, which was released late last week. If there 
is a fix, it would probably be included.

Evaluation download: http://www.allaire.com/download


--
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: How to do

2000-04-11 Thread Jeff Shepler

Ok, let's assume that your radio button field is named FOO and your text box
is named BAR. Instead of doing a cfinsert, you will have to do this one
"by hand":

cfquery name="doInsert" datasource="whatever"
INSERT INTO someTable (Answer) VALUES ('#iif(FORM.FOO EQ "Other",
DE("#FORM.BAR#"), DE("#FORM.FOO#"))#')
/cfquery

It might be DE(FORM.FOO) and DE(FORM.BAR), but I always get confused with
the DE() function. Try both forms and see which one works. I'll probably get
flamed for using nested pounds.. *shrug*

-Original Message-
From: Sumeet Khanna [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 11, 2000 2:34 PM
To: '[EMAIL PROTECTED]'
Subject: How to do


Can anyone please tell me how to do radio
button validation ,if I want to use 
the check "if radio button "Other" is clicked then only 
enter Other option text in text box"

Sumee

--
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 tags for SAS

2000-04-11 Thread Gerard T. Pauline

Randy:

You might also try posting to [EMAIL PROTECTED], the SAS
programming list. The people at Trilogy Consulting have done some
work with SAS  CF.

-Gerry

Gerard T. Pauline
Mgt, Internet/DB Applications
Computer Systems, DoIT
Pace University

Randy Hogg wrote:
 
 Does anyone know of any custom tags to work with SAS datasets, call SAS
 routines realtime, or any other interaction?  Many thanks.  Randy
 BTW  Great list, I'm learning TONS!
 
 --
 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: Source Control

2000-04-11 Thread Reuben King

In 058501bfa3e4$872b8330$[EMAIL PROTECTED], Greg Czechowicz 
([EMAIL PROTECTED]) in a fit of unbridled passion, wrote:
 We are currently using Visual Source Safe to implement source control on our
 site. Could someone please email me their prior experiences regarding source
 control. We currently use Sourcesafe and frankly it stinks.

I've used PVCS in the past.. I think SourceSafe is cool in the fact that 
it integrates well with CF Studio.  I've yet to see a killer source 
control system.. they all have crappy interfaces, imo.


-- 

Reuben King mailto:[EMAIL PROTECTED]
Senior Web Consultant
Stonebridge Technologies http://www.sbti.com/
Phone: (512) 502-3332
--
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: Integer?

2000-04-11 Thread Reuben King

I have CF 4.5.1 and this statement simply isn't true.  IsNumeric() 
returns a true no matter how many 0's prepend a number, as long as the 
number is a number.  Maybe in earlier versions of CF it returned a 
false, but if it did I am not aware of it.


In D09A1A0FB7FDD211A92D00805FBBD8A1A578A3@CLTNTSXCHANGE, 
[EMAIL PROTECTED] ([EMAIL PROTECTED]) in a fit of unbridled passion, 
wrote:
 An integer is a range of "real numbers", usually with a limit around 999
 million or so (depends on the language, C defines a smallint as 1-37,000 for
 example.) I can't find any documentation stating ColdFusion's limits with
 integers. ColdFusion doesn't see a number with a leading 0 as a number, thus
 it can't be an integer...
 
 Anyone know what the maximum size for an integer in CF is?
 
 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, April 11, 2000 12:15 PM
 To: [EMAIL PROTECTED]
 Subject: RE: Integer?
 
 
 Huh?  Do you mean because of the leading zero?  Most of the time computers
 can ignore that.  What else makes it not an integer?  If I write it as
 1,234,567,890 is it an integer?
 
 Not wanting to fight, but curious..
 
 
 
 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, April 11, 2000 11:21 AM
 To: [EMAIL PROTECTED]
 Subject: RE: Integer?
 
 
 How could a number "01234567890" be an integer? It's not even a real number!
 
 
 
 --
 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.
 

-- 

Reuben King mailto:[EMAIL PROTECTED]
Senior Web Consultant
Stonebridge Technologies http://www.sbti.com/
Phone: (512) 502-3332
--
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.



File Archive Application

2000-04-11 Thread Jeffrey G. Brown

Our intranet needs a file archive application, where items such as PDF files, 
Excel spreadsheets, Powerpoint presentations, Word documents, and just about 
anything else imaginable can be stored and retrieved. In some cases, access 
to certain files and groups of files must be limited to specific groups of 
users. We'd like to maintain a parallel database file that would allow file 
creators to upload their files, as well as enter descriptions or comments 
about the file.

I'm concerned about allowing this to get out of hand, in terms of the number 
of users and groups of users for which security permissions must be tracked. 
I'd like to solicit the mailing list's reactions on how best to set up and 
administer such a system, and what security model might be workable.

JGB



===
Jeffrey G. Brown Intranet Webmaster
Milacron, Inc.  Voice: 513-841-8655   Fax: 513-841-7345
--
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: Can CF be run on a Cobalt RAQ 3?

2000-04-11 Thread Adrian Cooper


- Original Message - 
From: "Mike Sheldon" [EMAIL PROTECTED]
Sent: Tuesday, April 11, 2000 8:34 PM

 Given the choice right now, I'd prefer to run the Linux version of CF. I've
 tested CF Linux and have been very happy with its behavior. 

What database are you using?  Anyone using "mySQL"?

How well does an NT CF application port to Linux?

Thanks as always.

Adrian Cooper.




--
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: Is there a CFUG in SE Wisconsin?

2000-04-11 Thread WorldNet

!-- From: [EMAIL PROTECTED] (Scott J. Brader)
!-- Subject: Is there a CFUG in SE Wisconsin?

Nothing has been formalized but myself and another individual
working at WEPCO have met and discussed the issue and have
remained in touch every now and then. 

I've offered to host the group's website but there is
nothing to host. Yet.

Contact [EMAIL PROTECTED] and Amy Brooks of Allaire
via [EMAIL PROTECTED] to get in the loop.

!--- Clinton Gallagher
  http://home.att.net/~csgallagher/
  http://www.metromilwaukee.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: How well does CF run with mySQL?

2000-04-11 Thread pardeep

How well does CF run with mySQL?

Is it better to go with SQL7 or Oracle 8i?

I am doing a prototype app with Access but now need to port to a stronger
database program.

Any suggestions?

I understand Cold Fusion 4.5 still does not have direct native support for
mySQL, true or false?
--
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: Is 4.5.1 Solid

2000-04-11 Thread Reuben King

WBB,

Your trashing of AOL rather bothers me.  AOL is just an ISP like any 
other and if your application breaks when someone from AOL attempts to 
use it, then I would suggest the problem lies flatly on your end for 
your failure to support even the most basic of cross-browser 
compatibilities.

Furthermore, your insinuation that AOL'ers are all stupid, silly, 
ignorant, and what-not is way off base.  AOL has its share of newbies, 
but lots of professionals use it too.  

AOL has millions of users.  This is quite a large target customer base.  
I suggest you show them a bit more respect.

Specific notes on your post follow:

In 036c01bfa3f1$e3fcbae0$[EMAIL PROTECTED], WBB ([EMAIL PROTECTED]) in a 
fit of unbridled passion, wrote:
[snip]
 
 OR
 
 AOL fixed the problem as we were installing 4.51 ;)

CFMAIL is an SMTP interface for CF on the server side.  How does it have 
anything to do whatsoever with AOL?

  accommodates the problems on AOL's end. Do you honestly want Allaire to
 get
  accounts with every major ISP so they can check to see if the ISP's stupid
  procedures mess up the sites? I used to work at a hosting company and the
 
 Of course not...but I would think that they would test it on the LARGEST
 modem community in the world...duh!

Why?  CF is a server-extension and has nothing to do with browsers or 
ISP's.


  focus was on video hosting. Every time we had a broadcast, we would get
  inundated with tech support calls from AOL users asking us why our site
 was
  broken. You can't imagine how many times I had to explain to people
 exactly
  why they needed to get a real ISP. AOL uses cached proxy servers and it is
  bad bad bad.
 
 I also do tech support and know just how lame AOL users can be and have used
 that same explaination as you did ;), however, that doesn't cover the fact
 that submit buttons or graphics buttons or verity searches wouldn't work
 using an AOL account until we upgraded to 4.51 (they worked fine with 1.5,
 2.0, 2.5, 3.0, 3.1, 4.0 and 4.1) from 4.5

Sounds to me like a problem with your developer's skillset or lack 
thereof.  


  The really funny calls were the AOL users who said "What do you mean you
  don't do tech support for AOL? You're the Internet, right?"
 
 
 I understand...we have several hundred customers that use our lines to
 connect to their AOL accounts and it's tough to explain to them why their
 AOL mail doesn't work ;)

AOL works fine over TCP/IP.  

-- 

Reuben King mailto:[EMAIL PROTECTED]
Senior Web Consultant
Stonebridge Technologies http://www.sbti.com/
Phone: (512) 502-3332
--
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.



Does anyone have a CFMAIL problem where '=' are added to message

2000-04-11 Thread Steve Nelson



Hi everyone!

We just applied the hot fix from allaire that addresses the CFMAIL problem.
This was for the smtp.dll.  With the hot fix, I see an '=' character added to
the end of certain lines in the body of an email sent with cfmail.  The equals
sign only appears when there are spaces just before a carriage return/newline.

When I back out the hot fix, and go back to the "official" 4.5 version of
smtp.dll, the problem goes away.   Has anyone seen this before?   Is there a fix
for it?

Thanks!

--steve nelson
[EMAIL PROTECTED]
www.mercurymarine.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.



Missing primary key error message

2000-04-11 Thread Hubert Earl

This is a multi-part message in MIME format.

--=_NextPart_000_0121_01BFA3D7.0EE44400
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi,

I'm working on an application which should allow data to be added to a =
database, and afterwards updated.  The application works up to the point =
where I try to submit the updated data, at which point I get the =
following error message:

"Primary key field CustomerID not found.=20

The field CustomerID was not found in the Form input. This field is =
required in order to do an UPDATE because it is part of the primary key =
for the Parts table.

The error occurred while processing an element with a general identifier =
of (CFUPDATE), occupying document position (1:1) to (1:51)."=20
=20
When I checked the database, the primary key was there.  The CFUPDATE =
tag in the update template appears to be normal, and had worked prior to =
some changes I made to the update form. Could it be possible that =
changes to display tags on the update form could affect the functioning =
of the update template? I'm quite puzzled, and I'd appreciate some =
advice.

Sincerely,
---
Hubert Earl
ICQ#:  16199853

I develop  maintain web sites internationally.  I also build web =
applications using CGI scripts written in Perl.  I accept subcontracting =
work.

**Personal web site:  http://www.geocities.com/SiliconValley/Peaks/8702/
(please remember to view this with a sense of humour!)

**Business web page:  http://home.talkcity.com/MigrationPath/hearl/

--=_NextPart_000_0121_01BFA3D7.0EE44400
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=3D2
DIVFONT face=3DArial size=3D2Hi,/FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial size=3D2I'm working on an application which =
should allow=20
data to be added to a database, and afterwards updated.nbsp; The =
application=20
works up to the point where I try to submit the updated data, at which =
point I=20
get the following error message:/FONT/DIV
DIVnbsp;/DIVFONT face=3DArial size=3D2
DIV"Primary key field CustomerID not found. /DIV
DIVnbsp;/DIV
DIVThe field CustomerID was not found in the Form input. This field is =

required in order to do an UPDATE because it is part of the primary key =
for the=20
Parts table./DIV
DIVnbsp;/DIV
DIVThe error occurred while processing an element with a general =
identifier of=20
(CFUPDATE), occupying document position (1:1) to (1:51)." /DIV
DIV/FONTnbsp;/DIV
DIVFONT face=3DArial size=3D2When I checked the database, the =
primary key was=20
there.nbsp; The CFUPDATE tag in the update template appears to be =
normal, and=20
had worked prior to some changes I made to the update form.nbsp;Could =
it be=20
possible that changes to display tags on the update form could affect =
the=20
functioning of thenbsp;update template? I'm quite puzzled, and I'd =
appreciate=20
some advice./FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial size=3D2Sincerely,/FONT/DIV/FONT/DIV
DIVFONT face=3DArial size=3D2---BRHubert EarlBRICQ#:nbsp;=20
16199853/FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial size=3D2I develop amp; maintain web sites=20
internationally.nbsp; I also build web applications using CGI scripts =
written=20
in Perl.nbsp; I accept subcontracting work./FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial size=3D2**Personal web site:nbsp; A=20
href=3D"http://www.geocities.com/SiliconValley/Peaks/8702/"http://www.ge=
ocities.com/SiliconValley/Peaks/8702//ABR(please=20
remember to view this with a sense of humour!)/FONT/DIV
DIVnbsp;/DIV
DIVFONT face=3DArial size=3D2**Business web page:nbsp; A=20
href=3D"http://home.talkcity.com/MigrationPath/hearl/"http://home.talkci=
ty.com/MigrationPath/hearl//A/FONT/DIV/BODY/HTML

--=_NextPart_000_0121_01BFA3D7.0EE44400--

--
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: CFmail and CRLF!!!

2000-04-11 Thread Reuben King

In [EMAIL PROTECTED], Jennifer 
([EMAIL PROTECTED]) in a fit of unbridled passion, wrote:
 At 11:29 AM 4/11/00 -0700, you wrote:
 I am using Que Mail and Cf 4.5 for linux. If I send a mail message with
 more than one line my mail server will not send it because it is sending
 bare LF.
 
 read: http://cr.yp.to/docs/smtplf.html
 
 After an attempt to send a message with a bare LF, Cfmail will no longer
 even try to send mail until the service is restated. Has anyone experienced
 this before? Is there a fix?? Grr
 
 I'm not familiar with the problem, but if you are really running 4.5, you 
 might want to upgrade to 4.5.1, which was released late last week. If there 
 is a fix, it would probably be included.

I don't have a solution for this fellow's problem, but I should mention 
that there is no 4.5.1 update for Linux available.


-- 

Reuben King mailto:[EMAIL PROTECTED]
Senior Web Consultant
Stonebridge Technologies http://www.sbti.com/
Phone: (512) 502-3332
--
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.



  1   2   >