Text File to Database Custom Tag.

[Chapman, Katrina]

I know that this has been discussed several times on the list but I'm in
need of a Custom Tag that will take a tab delimited Text file and import it
into a SQL 7.0 database.  Does anyone know of a tag that does this?  I can't
find one in the tag gallery.

--K

---
Thank you,
Katrina Chapman
ColdFusion Web Developer
System Development
"Programming today is a race between software engineers striving to build
bigger and better idiot-proof programs, and the Universe trying to produce
bigger and better idiots. So far, the Universe is winning.
--Rich Cook"



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

RE: padding a variable

[Chapman, Katrina]

That's not the queston boys.  He's not asking how to limit it to 30 but how
to force it up to 30.  IE I have a string that's only 22 chars long I need
it to be thirty.

Try this



#foo# - #len(foo)#











#foo# - #len(foo)#


Of course you can replace the @ with whatever char you want to use.

--K

-Original Message-
From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 03, 2000 5:23 AM
To: CF-Talk
Subject: RE: padding a variable


> how do you pad a variable in CF.
> for example how can I force a query.columnname to take up exactly 30
> characters?

Just using Left() won't work if you're using variable length fields
(varchar)

You could use Left(myColumn & RepeatString(" ", 30), 30)

HTH

Philip Arnold
ASP Multimedia Limited
T: +44 (0)20 8680 1133

"Websites for the real world"

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




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

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

RE: Killing a variable

[Chapman, Katrina]

Actually StructIsEmpty() will always return false on the session structure.
There are 4 vars that CF includes by default in that structure.  Can anyone
guess what they are.

--K

-Original Message-
From: Simon Horwith [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 02, 2000 8:47 AM
To: CF-Talk
Subject: RE: Killing a variable


my understanding is that structClear leaves an empty structure in memory.
You'd probably want to test with StructIsEmpty() after that.

~Simon

-Original Message-
From: Chen, Yung-Chih (CIT) [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 02, 2000 11:37 AM
To: CF-Talk
Subject: RE: Killing a variable


so, once you Clear the all session variables, does that mean session
variable
does not exist?
or session variable still exists but without any values!

If I do this 
right after that statement can I use isdefined() to find out see if session
variable is exist or not?



-Original Message-
From: Bob Silverberg [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 02, 2000 11:22 AM
To: CF-Talk
Subject: RE: Killing a variable



 will clear all session variables.  Don't
forget to CFLOCK it.

Bob

-Original Message-
From: Jon Gage [mailto:[EMAIL PROTECTED]]
Sent: November 2, 2000 11:03 AM
To: CF-Talk
Subject: Killing a variable


I'm setting a session variable when people log into our site.  I was
wondering if there's a way to "kill" the variable when they log out, so an
isDefined("SESSION.LOGGEDIN") will return as false.  Is this possible?

Thanks,
Jon



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



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


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


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

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

RE: Displaying decimal part as a fraction...

[Chapman, Katrina]

Look at the function Max provided you with again.  It will do exactly what
you're asking for.

--K

-Original Message-
From: Rice, David [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 01, 2000 1:20 PM
To: CF-Talk
Subject: RE: Displaying decimal part as a fraction...


Not really, Max. However, thanks for trying.

We can get the decimal part, no problem. We can also perform various
rounding schemes, of course. What we actually need is for the decimal part
to be "displayed" as a fraction for the user, as in: 10 over 100, or 10/100,
in other words.

I once saw a function, or custom tag, or something someone had done that
accomplished this fraction display. I was hoping someone might remember that
and know where it could be found, who had authored it, etc.

David
--

-Original Message-
From: Max Paperno [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 01, 2000 2:06 PM
To: CF-Talk
Subject: Re: Displaying decimal part as a fraction...


David,  

Would something like this work?  Just off the top of my head...

#ListLast( DollarFormat(myAmount), "." )#/100

Not sure if that's really what you (or your fellow) are after

HTH,
-Max


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

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

RE: CFFile ERROR

[Chapman, Katrina]

Can we see the tag in question?  It should look like this.



--K

-Original Message-
From: AustralianAccommodation.com Pty. Ltd.
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 01, 2000 9:35 AM
To: CF-Talk
Subject: CFFile ERROR


the following error occurs and i am a little confused as i have 2 copies one
copy on each of 2 totally different cf hosting services

on one of the cf hosts this error does not occur whislt on the other cf host
the error occurs and the code is 100% identical on both sites

your comments please

Error Diagnostic Information
Attribute set validation error in tag CFFILE

The tag has an invalid attribute combination: the value of the tag switch
attribute 'ACTION' which is now 'RENAME' requires a different combination of
attributes. For the same switch attribute value the following unknown
attributes have been provided: (NAMECONFLICT).

The error occurred while processing an element with a general identifier of
(CFFILE), occupying document position (30:1) to (33:26).

The specific sequence of files included or processed is:
D:\FTP\austaccomm\Htdocs\austonline\admin1\admin\updatepropertyformresults.c
fm



Kind Regards

Claude Raiola (Director)
AustralianAccommodation.com Pty. Ltd.
Website: www.AustralianAccommodation.com
Email: [EMAIL PROTECTED]



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

RE: DateTime Stamp Problem

[Chapman, Katrina]

I'm not going to answer the question about the best way to store your data.
But can we see the original query?  

--K

-Original Message-
From: Chris Johnson [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 27, 2000 3:10 PM
To: CF-Talk
Subject: DateTime Stamp Problem


I have a access database and I can't get the value of ,
'#CreateODBCDateTime(Now())#', in my Insert statement to work. I get the
error:

[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing
operator) in query expression ''{ts '2000-10-27 14:49:50'}''.

The field type is text and a length of 100.

Is this the best way because long term I will search DateDiff of these
fields...

Any help?

-Chris
www.chris.com


_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com



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

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

RE: processing umlaut characters

[Chapman, Katrina]

My guess is you're doing something like this



 Selected>bar

Selected>bar2

Selected>bar3



Am I right?  If so you shouldn't be storing the data this way.  You should
be using some sort of id number and that way you don't have to worry about
what is in the text, all you have to worry about is a number.  

Can we see some code?  That would help us to help you.

--K

-Original Message-
From: Steve Ray [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 26, 2000 3:44 PM
To: CF-Talk
Subject: processing umlaut characters


This is a multi-part message in MIME format.
--1B56CACAC542608BA32EBF87
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hi.

One of our developers here is having a problem with , and I'm wondering if
any of you have come across this and found a solution.

It's on a edit form which has a dropdown select box; the item in the
dropdown which matches the value in the database table should be selected
when the record is brought into the
form.

One of the values (name of a company) has an umlaut (double dots, like a
colon turned on it's side) above an "o". We're running a "nocase" -type
statement on it for the comparison,
and CF is not seeing the umlaut.

The only mention I can find in Allaire's forums re: umlauts has to do with
Verity and the german language module. That obviously wouldn't help here.

If any of you have any suggestions or workarounds, I'd love to hear 'em.

Thanks a lot.


Steve Ray
Matrix Group


CF-Talk wrote:

> CF-TalkSat, 14 Oct 2000   Volume 1 :
Number 58
>
> In this issue:
>
> Re: CF-Talk V1 #57
> Re: Wierd CFLOCATION error
> Re: OT: Thawte/ SSL provider help - soln
> RE: CFX Tags
> Registering virtual hosts in IIS
>
> --
>
> Date: Fri, 13 Oct 2000 19:33:46 -0700
> From: "Michelle Plahmer" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Subject: Re: CF-Talk V1 #57
> Message-ID: 
>
> I will be out of the office Monday, October 16 through Friday, October 20.
=
>  I will be checking my voicemail and e-mail.
>
> --
>
> Date: Fri, 13 Oct 2000 22:53:35 -0400
> From: "David Hannum" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Subject: Re: Wierd CFLOCATION error
> Message-ID: <006a01c03589$f3769340$[EMAIL PROTECTED]>
>
> There is a custom tag that is called CFMAGICCOOKIE that allows you to use
a
> cookie and a cflocation together.  I've used it in a very limited basis
with
> success.  I have no idea how robust it would be.
>
> Dave
>
> - Original Message -
> From: Bill Killillay <[EMAIL PROTECTED]>
> To: CF-Talk <[EMAIL PROTECTED]>
> Sent: Friday, October 13, 2000 4:51 PM
> Subject: RE: Wierd CFLOCATION error
>
> > Sure ya can, the cookie just won't be set *grin*
> > >
> > > You cannot use  in the same template as  ..
> > >
> >
> >
> >
--
> 
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
>
> --
>
> Date: Fri, 13 Oct 2000 20:44:35 -0700 (PDT)
> From: cf kaizen <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Cc: paul smith <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
> Subject: Re: OT: Thawte/ SSL provider help - soln
> Message-ID: <[EMAIL PROTECTED]>
>
> Thanks everyone for your replies. My oversight was
> that I had to start off first with my ISP - in my case
> Virtualscape, to get the CSR to deliver to Thawte in
> THEIR step 1. My apoligies for the mixup.
>
> Tx again,
> Andy
>
> --- paul smith <[EMAIL PROTECTED]> wrote:
> > The link is on the page at the URL below.
> > Right above the big "ENROLL" gif ;-)
> >
> > best,  paul
> >
>
> __
> Do You Yahoo!?
> Yahoo! Messenger - Talk while you surf!  It's FREE.
> http://im.yahoo.com/
>
> --
>
> Date: Sat, 14 Oct 2000 02:01:04 -0400
> From: [EMAIL PROTECTED] (lsellers)
> To: <[EMAIL PROTECTED]>
> Subject: RE: CFX Tags
> Message-ID: <[EMAIL PROTECTED]>
>
> >
> > There is a tag in the Developer's Exchange at Allaire called
> > Auto_Add_CFX... I've used it to add CFX on my virtual server.
>
> I wrote it. It requires CFREGISTRY to be turned on. It directly adds the
> required entires to the registry to "register" a CFX tag.
>
> So... if you can use CFREGISTRY, you can add them yourself. Of course...
you
> should probably be expected to be kicked off their systems if they find
out
> you've done that. :-) But it might be possible.
>
> --min
>
> --
>
> Date: Sat, 14 Oct 2000 11:45:48 +0200
> From: WebSite CFTalk <[EMAIL PROTECTED]>
> To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
> Subject: Registering vi

RE: Capitalize First Letter of Each Word

[Chapman, Katrina]

No offense Jeff, but, I love it when people make things more complicated
than they need to be.










#newstring#

That works like a charm, gives me "Now Is The Time For All Good Men And
Women.".  Just replace the var "TargetString" with your form field.  If you
need to do it for multiple fields let me know.  I can build that loop for
you as well.

--K

-Original Message-
From: Jeff Bevill [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 26, 2000 6:50 AM
To: CF-Talk
Subject: RE: Capitalize First Letter of Each Word


John McKown,

Here ya go man.  I only had about 10 mins to write this, hope it works. :)


































#Variable#

Jeff Bevill

-Original Message-
From: John McKown [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 26, 2000 6:35 AM
To: CF-Talk
Subject: Capitalize First Letter of Each Word


Can someone share a script that will capitalize the
first letter of every word entered into a form field?

John McKown, VP Business Services
Delaware.Net, Inc.
30 Old Rudnick Lane, Suite 200 Dover, DE 19901
email: [EMAIL PROTECTED]
phone: 302-736-5515
fax: 302-736-5945
icq: 1495432





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



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

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

RE:

[Chapman, Katrina]

I forgot to include this.

This is an example of how I use cfscript.



  

session.dsn = 'cfchick';
session.JSEnabled = 'No';
session.root_path = '';
session.path_to_images = '#session.root_path#images/';
session.bgcolor = '##FF';
session.fontcolor = '##00';
session.fontface = 'Verdana';
session.fontsize = '2';
session.linkcolor = '##ff';
session.alinkcolor = '##ff';
session.vlinkcolor = '##993399';
session.tableborder = '0';

  

 

It's useful if you have a lot of sets.  If I didn't use cfscript I'd have to
type out  for all of those vars above.  It's easier this
way.  I'm sure that it's useful for other things as well but I've not had
the need.

--K

-Original Message-
From: Chapman, Katrina [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 25, 2000 3:36 PM
To: CF-Talk
Subject: RE: 


You can also try the docs.

http://127.0.0.1/CFDOCS/CFML_Language_Reference/2_ColdFusion_Tags/lr2_073.ht
m

--K

-Original Message-
From: Brad Roberts [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 25, 2000 1:53 PM
To: CF-Talk
Subject: RE: 


The Advanced web application construction kit has a lot on the subject.

Brad

-Original Message-
From: Peter Benoit [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 25, 2000 4:38 PM
To: CF-Talk
Subject: RE: 


Well unless I'm looking in all the wrong spots, the QUE book of CF4.0 web
application construction kit doesn't show but a one liner about CFSCRIPT.
Which books might you be referring to?

*  -Original Message-
*  From: Simon Horwith [mailto:[EMAIL PROTECTED]]
*  Sent: Wednesday, October 25, 2000 4:14 PM
*  To: CF-Talk
*  Subject: RE: 
*
*
*  any 4.x book, or cfstudio 4.x help files
*  ~Simon
*
*  -Original Message-
*  From: Peter Benoit [mailto:[EMAIL PROTECTED]]
*  Sent: Wednesday, October 25, 2000 4:04 PM
*  To: CF-Talk
*  Subject: 
*
*
*  I see people using cfscript, but my cold fusion book shows
*  no functions
*  keywords or anything!  Where can I find help on this tag and
*  it's uses?
*
*  -Pete
*
*  -
*  ---
*  
*  Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
*  Unsubscribe:
*  http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
*  message with 'unsubscribe' in the body to
*  [EMAIL PROTECTED]
*  -
*  ---
*  Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
*  Unsubscribe:
*  http://www.houseoffusion.com/index.cfm?sidebar=lists or send
*  a message with 'unsubscribe' in the body to
*  [EMAIL PROTECTED]
*



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



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


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

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

RE:

[Chapman, Katrina]

You can also try the docs.

http://127.0.0.1/CFDOCS/CFML_Language_Reference/2_ColdFusion_Tags/lr2_073.ht
m

--K

-Original Message-
From: Brad Roberts [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 25, 2000 1:53 PM
To: CF-Talk
Subject: RE: 


The Advanced web application construction kit has a lot on the subject.

Brad

-Original Message-
From: Peter Benoit [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 25, 2000 4:38 PM
To: CF-Talk
Subject: RE: 


Well unless I'm looking in all the wrong spots, the QUE book of CF4.0 web
application construction kit doesn't show but a one liner about CFSCRIPT.
Which books might you be referring to?

*  -Original Message-
*  From: Simon Horwith [mailto:[EMAIL PROTECTED]]
*  Sent: Wednesday, October 25, 2000 4:14 PM
*  To: CF-Talk
*  Subject: RE: 
*
*
*  any 4.x book, or cfstudio 4.x help files
*  ~Simon
*
*  -Original Message-
*  From: Peter Benoit [mailto:[EMAIL PROTECTED]]
*  Sent: Wednesday, October 25, 2000 4:04 PM
*  To: CF-Talk
*  Subject: 
*
*
*  I see people using cfscript, but my cold fusion book shows
*  no functions
*  keywords or anything!  Where can I find help on this tag and
*  it's uses?
*
*  -Pete
*
*  -
*  ---
*  
*  Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
*  Unsubscribe:
*  http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
*  message with 'unsubscribe' in the body to
*  [EMAIL PROTECTED]
*  -
*  ---
*  Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
*  Unsubscribe:
*  http://www.houseoffusion.com/index.cfm?sidebar=lists or send
*  a message with 'unsubscribe' in the body to
*  [EMAIL PROTECTED]
*



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



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

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

RE: looping through queries

[Chapman, Katrina]

You can do this with two queries.


Select catID, Name
>From ArticleCats



SELECT catID
FROM ArticleCats
WHERE catid NOT IN (Select Distinct catID 
from Articles)


Then when you're outputting





HTH,
--K

-Original Message-
From: Cyrill Vatomsky [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 24, 2000 12:50 PM
To: CF-Talk
Subject: looping through queries


I have two tables: Articles, ArticleCat(egorie)s. At some point I want to
list all categories and allow checkboxes for multiple deletes, but only when
a category is empty (no articles).

I want to loop through a query of ArticleCats and test if there are articles
under that category. The only thing I can think of is to  run query each
iteration of the loop, which does not sound right.:


Select ID, Name
>From ArticleCats




Select ID from Articles
Where A_Cat=#getArticleCats.ID#





This sounds like a  huge burden. Is there another way to do it?



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

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

RE: how to prevent link from using IE window

[Chapman, Katrina]

Christopher,

You answered your own question.  "I cannot configure user computers."  There
is, therefore, no way to control that machine.

--K

-Original Message-
From: Warrick, Mark [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 24, 2000 11:07 AM
To: CF-Talk
Subject: RE: how to prevent link from using IE window


Don't use mailto.  Use a form instead.   That way, you won't be launching
any other programs.


> -Original Message-
> From: Christopher P. Maher [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, October 22, 2000 4:45 PM
> To: CF-Talk
> Subject: how to prevent link from using IE window
> 
> 
> I have a CF application that uses various statements to prevent browser
> caching. This works well except when a user clicks on a link in, say, an
> e-mail. Then that link opens in the instance of IE my application 
> is using.
> Because of the browser anti-caching when the user hits the back button to
> return to my page, they are told that the page has expired. 
> Refresh and they
> loose their work.
> 
> Is there some way to prevent this from happening (short of making Netscape
> the default browser)? The only solution that is practical would 
> be something
> I can put into the HTML. I cannot configure user computers.
> 
> Basically I want only MY application to run in that particular instance of
> IE. Hope that makes sense.
> 
> Thanks


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

RE: write var into txt file and save

[Chapman, Katrina]

You don't need a custom tag to do this.  You need to use the Append action
of the cffile tag.

--K

-Original Message-
From: Neil Clark [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 23, 2000 7:17 AM
To: CF-Talk
Subject: RE: write var into txt file and save


This is a multi-part message in MIME format.

--=_NextPart_000_0005_01C03D04.54B3B1C0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

you can do this by using the this Custom Tag - 


 


hope this helps.

Neil

http://www.mcbdigital.com
--->



--=_NextPart_000_0005_01C03D04.54B3B1C0
Content-Type: application/octet-stream;
name="CF_FileWriteText.cfm"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment;
filename="CF_FileWriteText.cfm"





Error Occurred in CF_FileWriteText =
Tag.">



  






  
 =20





  
  

  




  

   =20


  

  
 =20
  
  
  




--=_NextPart_000_0005_01C03D04.54B3B1C0--



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

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

RE: Weirdest Access problem ever

[Chapman, Katrina]

You should rename the field desc as that is a reserved word and your ODBC
connection may be choking on it.  Try naming it something like description.
I know it's more typing but you'll have fewer headaches.  BTW this should
also fix your problem.

--K

-Original Message-
From: Robert Everland [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 20, 2000 10:05 AM
To: CF-Talk
Subject: Wierdest Access problem ever


Alright here is what happened. I had a query that was working
perfectly for sometime. It basically did this
Select left(desc,40)
>From Here
Where 1=1

What happened was the left function completely screwed the query. Has anyone
had this problem before? I thought access supported this function, was it a
fluke as to why it was working before? I took it out and put it in CF to do
it, but I am sure it would be just a little faster if Access was doing it.

Robert Everland III
Web Developer
Dixon Ticonderoga


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

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

RE: Email a check???

[Chapman, Katrina]

That is if they even accept the check in the first place.

--K

-Original Message-
From: Braver, Ben: [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 19, 2000 4:09 PM
To: CF-Talk
Subject: RE: Email a check???


Hmmm, how ya gonna get the MICR characters (magnetic ink character
recognition)?
Banks just gonna LOVE getting check images they can't run through their
automated equipment ;-)

> -Original Message-
> From: Michael Smith [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, October 19, 2000 3:29 PM
> To:   CF-Talk
> Subject:  Email a check???
> 
> 
> --C1BAEA1E803462B1772F4A5B
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
> 
> Whoa -  now you can email a check to some one. Pretty creepy but I guess
> no more so than paypal... And I guess no less secure than snail mailing
> a check Still ... weird. ;-) And better make sure I don't send to
> the list instead of an individual!
> - Michael Smith, TeraTech, Inc http://www.teratech.com/
> 
> http://www.qchex.com
> 
>  Qchex.com is a new financial service for consumers and
>  businesses. It allows users with internet access and
>  an existing bank account to instantly send bankable checks to
>  anybody's email address both domestically and
>  internationally, thus by-passing all handling, postage and
>  banking fees associated with pre-printed checks.
>  Upon receipt, Qchex are printed out on the recipient's desktop
>  printer including all characteristics of a regular check.
> 
> 
> 
> --
> Michael Smith, TeraTech Inc
> VB, CF , SQL, Math programming
> 100 Park Ave Ste 360, Rockville MD 20850 USA
> Voice: +1-301-424-3903, 800-447-9120  Fax:301-762-8185
> Web: http://www.teratech.com/sig/
> Email:  mailto:[EMAIL PROTECTED] ICQ: 66057682
> 
> 
> --C1BAEA1E803462B1772F4A5B
> Content-Type: text/html; charset=us-ascii
> Content-Transfer-Encoding: 7bit
> 
> 
> 
> Whoa -  now you can email a check to some one. Pretty creepy but I
> guess no more so than paypal... And I guess no less secure than snail
> mailing
> a check Still ... weird. ;-) And better make sure I don't send to the
> list instead of an individual!
> - Michael Smith, TeraTech, Inc  HREF="http://www.teratech.com/">http://www.teratech.com/
> http://www.qchex.com">http://www.qchex.com
> Qchex.com is a new financial service for consumers and
> businesses.
> It allows users with internet access and
> an existing bank account to instantly send bankable checks to
> anybody's
> email address both domestically and
> internationally, thus by-passing all handling, postage and banking
> fees associated with pre-printed checks.
> Upon receipt, Qchex are printed out on the recipient's desktop printer
> including all characteristics of a regular check.
> 
>  
> --
> Michael Smith, TeraTech Inc
> VB, CF , SQL, Math programming
> 100 Park Ave Ste 360, Rockville MD 20850 USA
> Voice: +1-301-424-3903, 800-447-9120  Fax:301-762-8185
> Web:  HREF="http://www.teratech.com/sig/">http://www.teratech.com/sig/
> Email:   HREF="mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED] ICQ:
> 66057682
>  
> 
> --C1BAEA1E803462B1772F4A5B--
> 
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
> a message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]


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

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

RE: disappearing form variables

[Chapman, Katrina]

Jordie do you have a url where we can see this happening.  I copied your
code exactly and it works fine for me.

--K

-Original Message-
From: Jann VanOver [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 19, 2000 12:57 PM
To: CF-Talk
Subject: RE: disappearing form variables


If you have cookies turned off, you must pass #session.urltoken# to each new
page.

So your form would look like:
  

You must remember to add this to ANY link () or form that moves to a new
page.


> -Original Message-
> From: Jordie Fike [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, October 19, 2000 11:46 AM
> To:   CF-Talk
> Subject:  disappearing form variables
> 
> working on my first project that really makes use of CFAPPlication, making
> 
> use of Clientmanagement and Sessionmanagement .. which may or may not have
> 
> something to do with my dilemma, which is that I'm handing in a couple of 
> variables from a log in screen
> 
> ~~~
> 
> 
> Name: 
> 
> Password: 
> 
> 
> 
> ~~~
> 
> but then login.cfm was acting like it wasn't getting the values for the 
> variables, so I put
> 
> ~~~
> FORM.login_form - 
> #FORM.log_in_type#
> no
> 
> 
> 
> 
> FORM.email_form - 
> #FORM.name#
> no
> 
> 
> 
> 
> FORM.password_form - 
> #FORM.password#
> no
> 
> ~~~
> at the top of the login.cfm (and later at the top of application.cfm) and 
> sure enough it came back;
> 
> FORM.log_in_type - no
> FORM.name - no
> FORM.password - no
> 
> can't say I've ever run into anything like this before and I'm very 
> confused with a little bit of frustration thrown in.
> 
> 
> 
> Jordie Fike
> Tech Admin
> [EMAIL PROTECTED]
> http://www.outer-banks.nc.us
> phone - 1.252.441.6698
> fax - 1.252.480.2259
> 
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
> a message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]


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

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

RE: CFCase - Number in range of values

[Chapman, Katrina]

No.  You cannot do this.  Cfswitch/cfcase tags check for equality.  You
can't do a GT or LT comparasion with cfcase.  For this kind of conditional
logic you have to use a set of if/elseif/else statements, or list all of the
numbers between 400 and 499 comme ca.


  
Women's Footwear/Walking
  
  
Women's Footwear/Running
  
  
Baseball/Softball
  
  
Wrestling
  
  
Kid's Footwear/Infant Boy's
  
  
Kid's Footwear/Infant Girl's
  
  
Kid's Apparel/Boy's Apparel
  
  
Other Category
  


--K


-Original Message-
From: Paul Sizemore [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 18, 2000 11:39 AM
To: CF-Talk
Subject: RE: CFCase - Number in range of values


Let me expand to better represent my code:




Women's
Footwear/Walking
Women's
Footwear/Running


Baseball/Softball
Wrestling
Kid's Footwear/Infant Boy's
Kid's Footwear/Infant Girl's

Kid's Apparel/Boy's Apparel

Other Category


-Original Message-
From: Hayes, David [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 18, 2000 11:01 AM
To: CF-Talk
Subject: RE: CFCase - Number in range of values

You can use .

-Original Message-
From: Paul Sizemore [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 18, 2000 10:10 AM
To: CF-Talk
Subject: CFCase - Number in range of values


Is there any way to do the following?  (I know case values must be
constants). Will I need to test for this possibility before it goes into the
CF switch?


My Code


pbs



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


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


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

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

RE: I know we have gone over this a million times.

[Chapman, Katrina]

#Chr(10)# and #Chr(13)# should do the trick.  One is a CR and one is a LF.
I don't remember which is which though.

--K

-Original Message-
From: Nick Call [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 18, 2000 9:44 AM
To: CF-Talk
Subject: I know we have gone over this a million times.


I am populating a list that will eventually be written to a text file.  I
want to put a carriage return after each entry.  I cannot remember the
syntax.  Can someone kindly email that to me.

Thanks in advance.

Nick




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

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

RE: Awards

[Chapman, Katrina]

Are we going to vote or is this one of those things that every nominee is a
winner?  And if so what do we get? :) (j/k)

I'd like to nominate Fred Sanders.  Not sure if he's on this list but he's
helped me several times before and I see him responding to lots of posts.

--K

P.S. I'm cross posting this to community as that's where it really belongs.

-Original Message-
From: Warrick, Mark [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 17, 2000 5:14 PM
To: CF-Talk
Subject: RE:  Awards


What the heck.  I'll nominate her as well.  She's a sweetie.

---mark

--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: Jaime Garza [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, October 17, 2000 4:27 PM
> To: CF-Talk
> Subject: RE:  Awards
> 
> 
> I'll nominate Katrina Chapman.  Always there, specially for the novice.
> 
> 
> 
> > -Original Message-
> > From: Adam Phillip Churvis [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, October 17, 2000 3:45 PM
> > To: CF-Talk
> > Subject:  Awards
> >
> >
> > FusionFolks,
> >
> > I would like to propose an annual award for the most helpful 
> people in the
> > CF community.  The name I picked for this award is , 
> because a
> > "Mensch" is a really caring person who treats others with respect, who
> > performs acts of kindness, and who tries to make the community a
> > better place.
> >
> > The people I would like to nominate are:
> >
> > Michael Dinowitz
> > Dave Watts
> > Cameron Childress
> >
> > I see some really outstanding advice and help coming from these 
> folks (any
> > many others, to be sure), so I think we ought to "brand" them 
> accordingly!
> >
> > There are so many who help, and my list contains only those who 
> stick out
> > in my mind most prominently, so I hope others will add their
> > nominations, too.
> >
> > What do you think, folks?
> >
> > Respectfully,
> >
> > Adam Phillip Churvis
> > President
> > Productivity Enhancement, Inc.
> >
> > **
> > **
> > *  PRODUCTIVITY ENHANCEMENT, INC.
> >  *
> > *
> >  *
> > *Publishers of the CommerceBlocks line of modular development
> > tools*
> > *  for ColdFusion
> >  *
> > *
> >  *
> > * Website: http://www.commerceblocks.com   E-mail:
> > [EMAIL PROTECTED] *
> > * Phone:   770-446-8866Fax:770-242-0410
> >  *
> > *
> >  *
> > **
> > **
> >
> > --
> > --
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
> > or send a message with 'unsubscribe' in the body to
> > [EMAIL PROTECTED]
> 
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists 
> or send a message with 'unsubscribe' in the body to 
> [EMAIL PROTECTED]



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

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

RE: Storing passwords in database as one way hash

[Chapman, Katrina]

The purpose is to keep people from peeking in the db and getting pw's they
shouldn't have.  

Hash() works great.  We used it on a project that I worked on before.
Unfortunately you have to have CF Server 4.5.1 to use it the way that I
believe it was intended.

--K

-Original Message-
From: Robert Everland III [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 17, 2000 2:55 PM
To: CF-Talk
Subject: RE: Storing passwords in database as one way hash


But if it's a one way hash, why do you need to store it, you can't decrypt
it. What is the purpose?


Bob Everland

-Original Message-
From: Jon Tillman [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 17, 2000 4:39 PM
To: CF-Talk
Subject: RE: Storing passwords in database as one way hash


Who ever said it is going to be used one time?
I need to securely store the passwords for several dozen competing users

On Tue, 17 Oct 2000, Robert Everland spake thusly:
> Why even bother storing a password in a one way hash if it's only gonna be
> used one time?
>
> Robert Everland III
> Web Developer
> Dixon Ticonderoga
>
>
> -Original Message-
> From: Cameron Childress [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, October 17, 2000 2:32 PM
> To: CF-Talk
> Subject: RE: Storing passwords in database as one way hash
>
>
> > anybody know of anything that does such?
> > I am looking for pretty much the same functionality as a standard
> > *NIX login
>
> Look up the function Hash().  I think it was introduced in CF 4.5.
> Actually, I just looks at the online cfdocs and don't see it in there, but
> it is... maybe introduced in 4.5.1?
>
> There's also a CFX_HASH in the tag gallery that give many more options of
> hash types.
>
> -Cameron
>
> 
> Cameron Childress
> ElliptIQ Inc.
> p.770.460.7277.232
> f.770.460.0963
>
> --
--
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> --

> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
***
 Jon Tillman
 LINUX USER: #141163
 ICQ: 4015362
 http://www.eruditum.org
 [EMAIL PROTECTED]
 JAPH
***
Be alert, the world needs more lerts
***


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


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

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

RE: outputting data in a matrix

[Chapman, Katrina]

No Prob.

--K

-Original Message-
From: Richard Colman [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 17, 2000 10:55 AM
To: CF-Talk
Subject: RE: outputting data in a matrix


This worked just great. Thank you.

Richard Colman

-Original Message-
From: Chapman, Katrina [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 17, 2000 9:55 AM
To: CF-Talk
Subject: RE: outputting data in a matrix


No offence to anyone but your all making this much more difficult than it
is.

With a little creative HTML you can do this.


SELECT bookcat.Name, book.title
FROM bookcat, book
WHERE book.catid = bookcat.id
ORDER BY bookcat.name







#name#




#title#









This is just an example but you don't need to make it more difficult than it
is.  Of course you can modify this so that you only go three across or pull
a certain number of records at a time.  If you'd like to see this in action
go to www.katrinachapman.com/test_group.cfm and if you need any help please
feel free to contact me off list.

--K


-Original Message-
From: Stewart, Mark [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 17, 2000 6:57 AM
To: CF-Talk
Subject: RE: outputting data in a matrix


Richard,

If you're comfortable with using Crystal Reports, give that a try.

~Mark

-Original Message-
From: Richard Colman [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 16, 2000 6:28 PM
To: CF-Talk
Subject: outputting data in a matrix


Can someone suggest how to do this:

category1  category2category3
   --   ---
item 1  item 1   item 1
item 2  item 2   item 2
item 3  item 3
item 4


where the data table looks like:

category, item, etc.

there will be an unequal number of items per category.

ideas for an approach appreciated. Thank you.

Richard Colman

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


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

RE: What's with all the space?

[Chapman, Katrina]

Look at the cfsetting tag.  The white space is caused by the cf tags taking
up space but not appearing in the source code.

--K

-Original Message-
From: Peter Benoit [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 17, 2000 10:04 AM
To: CF-Talk
Subject: What's with all the space?


Viewing the source code of my CF apps, I see lots of white space.  Space
that isn't there in other server side programming languages.  

Why is this, and is there something I can do about it?



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

RE: CFContent Weirdness

[Chapman, Katrina]

What we do here is a cfhttp call to the template that creates the HTML for
the report passing through the file attribute. Then cfcontent the file that
was created in the cfhttp.  That way you don't lose anything.

Let me know if you need anymore help with this.

--K

-Original Message-
From: Warrick, Mark [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 17, 2000 9:20 AM
To: CF-Talk
Subject: CFContent Weirdness


I have a report which works fine as HTML output.

As soon as I add in the following CFCONTENT tag, the report somehow looses
all the variables from the form previous to it which passes information into
it.

Here's the tag I'm using:


Now, If I change the tag to:


It works fine and I can download the generated report, name it as a doc
file, and then open it up in Word.

What's the problem here?  First of all, I'd really like my browser to launch
Word (we're all using MSIE 5.0) and secondly, if I'm forced to download the
file instead, I'd like to pass a doc name through to the download prompt of
the browser.  (It currently names it as the name of the CFML template by
default.)

I've tried this trick:
http://servername/cfdocs/index.cfm/xyz.doc?fuseaction=showWordDoc

But it doesn't work on my server.  Gives me a 405 error.

What am I doing wrong?

---mark

--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


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

RE: outputting data in a matrix

[Chapman, Katrina]

No offence to anyone but your all making this much more difficult than it
is.

With a little creative HTML you can do this.


SELECT bookcat.Name, book.title
FROM bookcat, book
WHERE book.catid = bookcat.id
ORDER BY bookcat.name







#name#




#title#









This is just an example but you don't need to make it more difficult than it
is.  Of course you can modify this so that you only go three across or pull
a certain number of records at a time.  If you'd like to see this in action
go to www.katrinachapman.com/test_group.cfm and if you need any help please
feel free to contact me off list.

--K


-Original Message-
From: Stewart, Mark [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 17, 2000 6:57 AM
To: CF-Talk
Subject: RE: outputting data in a matrix


Richard,

If you're comfortable with using Crystal Reports, give that a try. 

~Mark

-Original Message-
From: Richard Colman [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 16, 2000 6:28 PM
To: CF-Talk
Subject: outputting data in a matrix


Can someone suggest how to do this:

category1  category2category3
   --   ---
item 1  item 1   item 1
item 2  item 2   item 2
item 3  item 3
item 4 
  

where the data table looks like:

category, item, etc. 

there will be an unequal number of items per category.
   
ideas for an approach appreciated. Thank you.

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

RE: Coldfusion FreeLance Work websites?

[Chapman, Katrina]

I think that Fred means fusioneers.com.  Note the "s". Fusioneers not
Fusioneer. Am I right Fred?

--K

-Original Message-
From: Fred T. Sanders [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 13, 2000 4:21 PM
To: CF-Talk
Subject: Re: FreeLance Work websites?

fusioneer.com
fieldworks.net

Fred T. Sanders
Charlottesville, VA
---
There's no such thing as idiot-proof software.
Idiots are just too clever for that.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: acess <>=

[Chapman, Katrina]

Yeah.  Send the message again so that we don't have to spend time decoding
your mime formatted message.

--K

-Original Message-
From: wpdd [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 16, 2000 9:47 AM
To: CF-Talk
Subject: acess <>=


This is a multi-part message in MIME format.

--=_NextPart_000_0064_01C0376F.2C6B7030
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

 
  Delete from DealerAuditTable
  Where (UserIP =3D '#session.IP#') or DateRecordAdded =3D now()-2=20
 

DateRecordAdded is a date/time
=3D  works

< does not work=20

also tried createODBCdate it seem that acees does not like the lt sign

any ideas
thanks mike=20

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








   Delete from=20
DealerAuditTable  Where (UserIP =3D '#session.IP#') or=20
DateRecordAdded =3D now()-2  
 
DateRecordAdded is a =
date/time
=3D  works
 
< does not work 
 
also tried createODBCdate it seem that =
acees does=20
not like the lt sign
 
any ideas
thanks mike 

--=_NextPart_000_0064_01C0376F.2C6B7030--

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

RE: Weird CFLOCATION error

[Chapman, Katrina]

This is a known "feature".  You cannot set a cookie and then cflocation in
the same template.  You need to use an alternate method of sending the user
on to where you want them.

--K

-Original Message-
From: Paul Johnston [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 13, 2000 9:42 AM
To: CF-Talk
Subject: Wierd CFLOCATION error


An email is sent out with a url on it.  THe url sets a cookie and then
redirects the user with a cflocation tag.

For some reason, the cflocation tag is run before the cfcookie tag is
complete thus not allowing the cookie to be set.

Any ideas?

Paul

PS Code:


SELECT
refid,
formrefid,
nextpage,
campaignenddate
FROM
qb_referral
WHERE
refid='#URL.refid#'
































http://www.blurgh.co.uk#REReplace(CGI.SCRIPT_NAME,"
referral.cfm","","all")#order.cfm">

If this page doesn't redirect you click here








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

RE: slightly ot: math question, needed for cold fusion programming

[Chapman, Katrina]

But that's not what he asked for.  This is of course an average.

--K

-Original Message-
From: Jeremy Allen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 12, 2000 4:34 PM
To: CF-Talk
Subject: RE: slightly ot: math question, needed for cold fusion
programming


Yes but you have to factor in the frequency of visitors by time as well, the
chance increases at a certain time and decreases at another time, unless you
are absolutely certain the time distrobution of visitors to your site is
exact and a user comes ever 5 minutes on the nose...

Jeremy

-Original Message-
From: Chapman, Katrina [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 12, 2000 2:44 PM
To: CF-Talk
Subject: RE: slightly ot: math question, needed for cold fusion
programming


That would be 1/2592:1 or 3.85802e-4:1 or .000385802:1

That's the chance that two people will hit at the same exact millisecond.

--K

-Original Message-
From: Warrick, Mark [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 12, 2000 11:33 AM
To: CF-Talk
Subject: RE: slightly ot: math question, needed for cold fusion
programming


Interesting math problem.  Perhaps there's a statistical math mailing list
that could help you out somewhere?

I'd check your local college's web site.

Here's my guess:

1,000 ms = 1 second
1,000 sec * 60 = 60 seconds = 60,000 ms
60,000 ms * 60 = 1 hour = 3,600,000 ms
3,600,000 * 24 = 1 day = 86,400,000 ms
86,400,000 * 30 = 1 month (approx) = 2,592,000,000

1,000,000 hits / 2,592,000,000 ms = a number my calculator won't even reach.

How's that for a chance?  Let's put it this way - it's most likely not going
to happen.

---mark


--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: Gavin Myers [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, October 11, 2000 10:02 AM
> To: CF-Talk
> Subject: slightly ot: math question, needed for cold fusion programming
>
>
> Lets say you have 1 page that scores 1,000,000 unique visitors a month
>
> here's what I came up with:
>
> 1,000,000/30/24/60/60/1000 = 0.000385
>
> So that means that 0.0003 people a milisecond hit the sight, correct?
> what is the % chance of 2 people hitting on the same milisecond (and math
> equation for that?)
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
> _talk or send a message to [EMAIL PROTECTED] with
> 'unsubscribe' in the body.


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

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


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

RE: slightly ot: math question, needed for cold fusion programming

[Chapman, Katrina]

That would be 1/2592:1 or 3.85802e-4:1 or .000385802:1 

That's the chance that two people will hit at the same exact millisecond.

--K

-Original Message-
From: Warrick, Mark [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 12, 2000 11:33 AM
To: CF-Talk
Subject: RE: slightly ot: math question, needed for cold fusion
programming


Interesting math problem.  Perhaps there's a statistical math mailing list
that could help you out somewhere?

I'd check your local college's web site.

Here's my guess:

1,000 ms = 1 second
1,000 sec * 60 = 60 seconds = 60,000 ms
60,000 ms * 60 = 1 hour = 3,600,000 ms
3,600,000 * 24 = 1 day = 86,400,000 ms
86,400,000 * 30 = 1 month (approx) = 2,592,000,000

1,000,000 hits / 2,592,000,000 ms = a number my calculator won't even reach.

How's that for a chance?  Let's put it this way - it's most likely not going
to happen.

---mark


--
Mark Warrick
Phone: (714) 547-5386
Efax.com Fax: (801) 730-7289
Personal Email: [EMAIL PROTECTED]
Personal URL: http://www.warrick.net 
Business Email: [EMAIL PROTECTED]
Business URL: http://www.fusioneers.com
ICQ: 346566
--


> -Original Message-
> From: Gavin Myers [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, October 11, 2000 10:02 AM
> To: CF-Talk
> Subject: slightly ot: math question, needed for cold fusion programming
> 
> 
> Lets say you have 1 page that scores 1,000,000 unique visitors a month
> 
> here's what I came up with:
> 
> 1,000,000/30/24/60/60/1000 = 0.000385
> 
> So that means that 0.0003 people a milisecond hit the sight, correct?
> what is the % chance of 2 people hitting on the same milisecond (and math
> equation for that?)
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit 
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
> _talk or send a message to [EMAIL PROTECTED] with 
> 'unsubscribe' in the body.


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

RE: Allaire trips over itself - flame warning

[Chapman, Katrina]

Funny.  I never seem to have a problem finding what I'm looking for on
Allaire.  Perhaps you're not using the correct search criteria.

--K

> -Original Message-
> From: JustinMacCarthy [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, October 12, 2000 9:24 AM
> To: CF-Talk
> Subject: Re: Allaire trips over itself - flame warning
> 
> 
> I agree. MS's site was bad but now it's pretty good.
> Allaire site is awful to find anything, even when you know 
> what you are
> looking for!!!  I always end up "listing all"  when looking for stuff.
> 
> Justin
> 
> 
> 
> > > I've complained before, to no effect. Does anyone have 
> the *correct*
> links
> > > to the performance tuning papers?
> >
> > No. They're almost as bad as Microsoft's site aren't they? Actually
> they're
> > even worse now that I think about it. Frustrating to find anything.
> > --min
> >
> > 

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

RE: Developer Directory?

[Chapman, Katrina]

We're not spamming the list.  You choose to receive these messages.

--K

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, October 11, 2000 2:51 PM
> To: CF-Talk
> Subject: RE: Developer Directory?
> 
> 
> I find it curious that those who are so sensitive about
> SPAM express it by SPAMMING this list with OT messages ;-)
> 
> best,  paul
> 
> At 05:36 PM 10/11/00 -0400, you wrote:
> >However, if you send a reply email stating that any further 
> mail will be
> >assessed a "reading fee" and that further email is 
> acceptance of the contract,
> >it should hold up anywhere in the Us under contract law.
> >This is based on a rudimentary knowledge of contract law, 
> and has, to my
> >knowledge, not been tested.
> >might be fun though
> >
> >On Wed, 11 Oct 2000, Chapman, Katrina spake thusly:
> > > Actually you're both wrong.
> > >
> > > The bill reads
> > >
> > > "Under the bill, California electronic mail service 
> providers may publish a
> > > notice forbidding the use of their equipment to send or 
> deliver spam. They
> > > may sue anyone who violates this for $50 per message up 
> to $25,000 per day
> > > in which the spamming takes place, or actual damages. 
> Attorneys' fees are
> > > also recoverable."
> > >
> > > That means that you're ISP get's the money not the end user.
> > >
> > > Also, according to m-w.com spam is "unsolicited usually 
> commercial E-mail
> > > sent to a large number of addresses".  That means any 
> message that you send
> > > me that i didn't explicitly ask for is spam as long as 
> you send it to
> > > several differen't people at once.  And, yes, doing loop 
> so that only one
> > > address goes out at a time is still spam.
> > >
> > > If I'm on the list remove me please.
> > >
> > > --K
> > >
> > > > -Original Message-
> > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> > > > Sent: Wednesday, October 11, 2000 1:44 PM
> > > > To: CF-Talk
> > > > Subject: Re: Developer Directory?
> > > >
> > > >
> > > > Only if you opted never to receive a mailing from our Company
> > > > is that law
> > > > applicable. ... We get our names from Internet related
> > > > companies that have
> > > > strict privacy policies that only give us names of those who
> > > > are internet
> > > > development related and want other information... FYI all
> > > > outbound emails
> > > > have a opt out completely link and we send that through XML
> > > > to the partner
> > > > who gave it to us... That way 2 birds with one stone... The
> > > > business we have
> > > > built is the prism of incorporation to individuals who want
> > > > to focus on
> > > > their own technologies. Not learning and keeping up 
> with every type of
> > > > technology. This conclusively makes each persons experience
> > > > rise in worth.
> > > > The purpose of the Original posting was to open valid 
> conversation
> > > > concerning opt in procedures... Is preferences enough? 
> I think that no
> > > > matter what solution the FTC and the Senate decides, it 
> will be one of
> > > > solidarity... But to be clear if it happened continually to a
> > > > recipient
> > > > who's ISP resides in CA; the fee is only $50.
> > > >
> > > > http://seclab.cs.ucdavis.edu/~zerkle/ab1629/
> > > >
> > > > -brian
> > > >
> > > > - Original Message -
> > > > From: Ed Toon <[EMAIL PROTECTED]>
> > > > To: CF-Talk <[EMAIL PROTECTED]>
> > > > Sent: Wednesday, October 11, 2000 2:33 PM
> > > > Subject: RE: Developer Directory?
> > > >
> > > >
> > > > > So you're building a business off of this list? 
> Great. Go ahead and
> > > > include
> > > > > me, but be aware that according to California law I can and
> > > > will charge
> > > > you
> > > > > $500 per email. :P
> > > > >
> > > > > Ed
> > > > >
> > > > > -Original Message-
> > > > > From: Brian bouldernet [mailto:[EMAIL PROTECTED]]
> &

RE: Developer Directory?

[Chapman, Katrina]

The equipment has to be in CA.  For the full text of the bill check this
out.

http://www.leginfo.ca.gov/pub/97-98/bill/asm/ab_1601-1650/ab_1629_bill_19980
928_chaptered.html

> -Original Message-
> From: Michael Dinowitz [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, October 11, 2000 2:46 PM
> To: CF-Talk
> Subject: Re: Developer Directory?
> 
> 
> Hm. So if I move HoF to California, every piece of spam sent 
> through it or
> to people on it would net me $50? Wy cool. I've been 
> battling those spam
> b*stards for a while now and would love to get some cash for 
> my effort. Any
> other states with this type of law? How about if the company 
> is registered
> in California but the server is in Georgia?
> 
> > Whoops. Too many 0's. The $50 goes to the electronic mail service
> provider,
> > which means whoever own the mail server. Which in this case 
> would mean
> > either my employer or myself, depending on the email address...
> >
> > At any rate, I think the point is that your service sounds 
> intrusive and
> > probably won't win you and points with the community. That 
> said, $25,000 a
> > day couldn't hurt. If we could report it as revenue...
> >
> > Ed
> >
> > 
> --
> 
> 
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list
s/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>


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

RE: Developer Directory?

[Chapman, Katrina]

And I have just stated that I don't wish to receive them from your company.
I will ask you again to please remove my name from your list.  Since it's
obviously on it.  Be forwarned if I receive any messages, of a marketing
nature, from you in the future I'll make sure that my ISP gets his money.  

Stick that in your pipe and smoke it.

--K

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, October 11, 2000 1:57 PM
> To: CF-Talk
> Subject: Re: Developer Directory?
> 
> 
> Customization As in Dear Katrina,
> Dice.com is a partner of ours and they have stated that you 
> wish to receive
> these types of mailings.
> 
> Talk about a 
> 
> - Original Message -
> From: Chapman, Katrina <[EMAIL PROTECTED]>
> To: CF-Talk <[EMAIL PROTECTED]>
> Sent: Wednesday, October 11, 2000 3:00 PM
> Subject: RE: Developer Directory?
> 
> 
> > Actually you're both wrong.
> >
> > The bill reads
> >
> > "Under the bill, California electronic mail service 
> providers may publish
> a
> > notice forbidding the use of their equipment to send or 
> deliver spam. They
> > may sue anyone who violates this for $50 per message up to 
> $25,000 per day
> > in which the spamming takes place, or actual damages. 
> Attorneys' fees are
> > also recoverable."
> >
> > That means that you're ISP get's the money not the end user.
> >
> > Also, according to m-w.com spam is "unsolicited usually 
> commercial E-mail
> > sent to a large number of addresses".  That means any 
> message that you
> send
> > me that i didn't explicitly ask for is spam as long as you 
> send it to
> > several differen't people at once.  And, yes, doing loop so 
> that only one
> > address goes out at a time is still spam.
> >
> > If I'm on the list remove me please.
> >
> > --K
> >
> > > -Original Message-
> > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> > > Sent: Wednesday, October 11, 2000 1:44 PM
> > > To: CF-Talk
> > > Subject: Re: Developer Directory?
> > >
> > >
> > > Only if you opted never to receive a mailing from our Company
> > > is that law
> > > applicable. ... We get our names from Internet related
> > > companies that have
> > > strict privacy policies that only give us names of those who
> > > are internet
> > > development related and want other information... FYI all
> > > outbound emails
> > > have a opt out completely link and we send that through XML
> > > to the partner
> > > who gave it to us... That way 2 birds with one stone... The
> > > business we have
> > > built is the prism of incorporation to individuals who want
> > > to focus on
> > > their own technologies. Not learning and keeping up with 
> every type of
> > > technology. This conclusively makes each persons experience
> > > rise in worth.
> > > The purpose of the Original posting was to open valid conversation
> > > concerning opt in procedures... Is preferences enough? I 
> think that no
> > > matter what solution the FTC and the Senate decides, it 
> will be one of
> > > solidarity... But to be clear if it happened continually to a
> > > recipient
> > > who's ISP resides in CA; the fee is only $50.
> > >
> > > http://seclab.cs.ucdavis.edu/~zerkle/ab1629/
> > >
> > > -brian
> > >
> > > - Original Message -
> > > From: Ed Toon <[EMAIL PROTECTED]>
> > > To: CF-Talk <[EMAIL PROTECTED]>
> > > Sent: Wednesday, October 11, 2000 2:33 PM
> > > Subject: RE: Developer Directory?
> > >
> > >
> > > > So you're building a business off of this list? Great. 
> Go ahead and
> > > include
> > > > me, but be aware that according to California law I can and
> > > will charge
> > > you
> > > > $500 per email. :P
> > > >
> > > > Ed
> > > >
> > > > -Original Message-
> > > > From: Brian bouldernet [mailto:[EMAIL PROTECTED]]
> > > > Sent: Wednesday, October 11, 2000 1:00 PM
> > > > To: CF-Talk
> > > > Subject: Re: Developer Directory?
> > > >
> > > >
> > > > All great things are realized great until the "flack" is at
> > > it's worst
> > > > Most Recently.
> &g

RE: Developer Directory?

[Chapman, Katrina]

Actually you're both wrong.

The bill reads 

"Under the bill, California electronic mail service providers may publish a
notice forbidding the use of their equipment to send or deliver spam. They
may sue anyone who violates this for $50 per message up to $25,000 per day
in which the spamming takes place, or actual damages. Attorneys' fees are
also recoverable."

That means that you're ISP get's the money not the end user.

Also, according to m-w.com spam is "unsolicited usually commercial E-mail
sent to a large number of addresses".  That means any message that you send
me that i didn't explicitly ask for is spam as long as you send it to
several differen't people at once.  And, yes, doing loop so that only one
address goes out at a time is still spam.

If I'm on the list remove me please.

--K

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, October 11, 2000 1:44 PM
> To: CF-Talk
> Subject: Re: Developer Directory?
> 
> 
> Only if you opted never to receive a mailing from our Company 
> is that law
> applicable. ... We get our names from Internet related 
> companies that have
> strict privacy policies that only give us names of those who 
> are internet
> development related and want other information... FYI all 
> outbound emails
> have a opt out completely link and we send that through XML 
> to the partner
> who gave it to us... That way 2 birds with one stone... The 
> business we have
> built is the prism of incorporation to individuals who want 
> to focus on
> their own technologies. Not learning and keeping up with every type of
> technology. This conclusively makes each persons experience 
> rise in worth.
> The purpose of the Original posting was to open valid conversation
> concerning opt in procedures... Is preferences enough? I think that no
> matter what solution the FTC and the Senate decides, it will be one of
> solidarity... But to be clear if it happened continually to a 
> recipient
> who's ISP resides in CA; the fee is only $50.
> 
> http://seclab.cs.ucdavis.edu/~zerkle/ab1629/
> 
> -brian
> 
> - Original Message -
> From: Ed Toon <[EMAIL PROTECTED]>
> To: CF-Talk <[EMAIL PROTECTED]>
> Sent: Wednesday, October 11, 2000 2:33 PM
> Subject: RE: Developer Directory?
> 
> 
> > So you're building a business off of this list? Great. Go ahead and
> include
> > me, but be aware that according to California law I can and 
> will charge
> you
> > $500 per email. :P
> >
> > Ed
> >
> > -Original Message-
> > From: Brian bouldernet [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, October 11, 2000 1:00 PM
> > To: CF-Talk
> > Subject: Re: Developer Directory?
> >
> >
> > All great things are realized great until the "flack" is at 
> it's worst
> > Most Recently.
> > Napster, NetAppliance, WAP, Cicso, NDS..
> >
> >
> > We'll see guys... I promise no spam... Our group came from a email
> marketing
> > company we sold out to double click. optinemail.com...
> >
> > We inatied the AOL hell thread because of the way AOL reparses
> doublequoted
> > links in all email so they have exclusive linking in emails.
> >
> > Our goal. To be directory for other developers doing there 
> own thing to
> > focus on their expertise.. Cold Fusion, Spectra whatever. 
> The lets say a
> > flash developer need function There you go
> >
> > Later,
> > Talk to you later...
> > -brian
> >
> > - Original Message -
> > From: Michael Dinowitz <[EMAIL PROTECTED]>
> > To: CF-Talk <[EMAIL PROTECTED]>
> > Sent: Wednesday, October 11, 2000 2:02 PM
> > Subject: Re: Developer Directory?
> >
> >
> > > I think there's one active already. I've got one in beta 
> at FA but it
> > isn't
> > > up yet.
> > > Personally, I feel that the approach your taking is not 
> the best as many
> > > feel like they're being dragged into something they 
> didn't want to be
> part
> > > of. Posting a request to a public place and saying for 
> people to come
> > visit
> > > is one thing, but scanning their email addresses and then 
> emailing them
> > > directly to do so doesn't feel right. Someone else did 
> something very
> > > similar and got a LOT of flack for it.
> > >
> > >
> > > > We've created a directory of about 1200 developers from 
> talk graoups,
> > > > confrences, and what not, does anyone see any major 
> issues emailing
> > > everyone
> > > > to ask to modify a profile we have setup and make live 
> on a site that
> > > rates
> > > > each one based on customer satisifaction and developer 
> strengths like
> > > > Spectra, CF, Database skills. All on a opt in procedure 
> currently.
> > > >
> > > > Are there any existing directories?
> > > >
> > > >
> > > > Thanks,
> > > > Brian
> > > >
> > >
> >
> > 
> --
> 
> > > 
> > > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > > > To Unsubscribe visit
> > > 
> http://www.houseoffusion.com/index.cfm?sidebar=lists&b

FW: Undeliverable: RE: [RE: CGI Referrer variable]

[Chapman, Katrina]

Is anyone else getting these messages about 30 seconds before the message
shows up on the list?

--K

> -Original Message-
> From: System Administrator [mailto:[EMAIL PROTECTED]]
> Sent: Monday, October 09, 2000 4:01 PM
> To: [EMAIL PROTECTED]
> Subject: Undeliverable: RE: [RE: CGI Referrer variable]
> 
> 
> Your message
> 
>   To:  CF-Talk
>   Subject: RE: [RE: CGI Referrer variable]
>   Sent:Mon, 9 Oct 2000 18:59:48 -0400
> 
> did not reach the following recipient(s):
> 
> CF-Talk on Mon, 9 Oct 2000 19:00:57 -0400
> The recipient name is not recognized
>   The MTS-ID of the original message is: c=US;a=
> ;p=TAMPA;l=MOJO00100923004SNJTYCH
> MSEXCH:IMS:TAMPA:MOJO:MOJO 0 (000C05A6) Unknown Recipient
> 
> 
> 


-
Message-ID: <[EMAIL PROTECTED]>
From: "Chapman, Katrina" <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Subject: RE: [RE: CGI Referrer variable]
Date: Mon, 9 Oct 2000 15:59:48 -0700 
X-Mailer: Internet Mail Service (5.5.2650.21)

Yes.

--K

> -Original Message-
> From: Jared Clinton [mailto:[EMAIL PROTECTED]]
> Sent: Monday, October 09, 2000 4:58 PM
> To: CF-Talk
> Subject: RE: [RE: CGI Referrer variable]
> 
> 
> Does anybody know if it is possible for 
> 
> CGI.REMOTE_ADDR 
> 
>   or 
> 
> CGI.REMOTE_HOST 
> 
> to be supplied with fake values?
> 
> Thanks in advance, Jared Clinton.
> 
> > -Original Message-
> > From: JL [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, October 10, 2000 8:52 AM
> > To: CF-Talk
> > Subject: Re: [RE: CGI Referrer variable]
> > 
> > 
> > do you guys check this cgi.http_referer to see whether it's 
> > the correct ip?
> > 
> > J
> > 
> > [EMAIL PROTECTED] wrote:
> > > 
> > > I was wondering how long someone would take to bring it up.
> > > 
> > > Yep, it's mis-spelled.  The person writing the standard 
> > mis-spelled it and
> > > it became a standard before it was caught... or so the 
> > story goes.  So
> > we're
> > > stuck with it.
> > > 
> > > --Doug
> > > 
> > > -Original Message-
> > > From: Warrick, Mark [mailto:[EMAIL PROTECTED]]
> > > Sent: Monday, October 09, 2000 2:41 PM
> > > To: CF-Talk
> > > Subject: RE: CGI Referrer variable
> > > 
> > > 
> > > Interestingly enough, that variable name is spelled incorrectly.
> > > 
> > > It is HTTP_REFERER.
> > > 
> > > More variables like it can be found in the docs:
> > > 
> > >
> > cfdocs/Developing_Web_Applications_with_ColdFusion/03_Creating
> > _and_Manipulat
> > > ing_Variables/dwa03_12.htm
> > > 
> > > ---mark
> > > 
> > > --
> > > Mark Warrick
> > > Phone: (714) 547-5386
> > > Efax.com Fax: (801) 730-7289
> > > Personal Email: [EMAIL PROTECTED]
> > > Personal URL: http://www.warrick.net 
> > > Business Email: [EMAIL PROTECTED]
> > > Business URL: http://www.fusioneers.com
> > > ICQ: 346566
> > > --
> > > 
> > > 
> > > > -Original Message-
> > > > From: Brian bouldernet [mailto:[EMAIL PROTECTED]]
> > > > Sent: Monday, October 09, 2000 12:47 PM
> > > > To: CF-Talk
> > > > Subject: CGI Referrer variable
> > > > 
> > > > 
> > > > Does anyone know the variable name for refferer? I forgot 
> > ofhand...
> > > > 
> > > > Thnaks,
> > > > Brian
> > > > 
> > > > 
> --
> > > > 
> > > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > > > To Unsubscribe visit 
> > > > 
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
> > > > _talk or send a message to 
> [EMAIL PROTECTED] with 
> > > > 'unsubscribe' in the body.
> > > 
> > >
> > --
> > --
> > > --
> > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > > To Unsubscribe visit
> > > 
> > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list
> s/cf_talk or
> > send a message to [EMAIL PROTECTED] with 
> 'unsubs

RE: [RE: CGI Referrer variable]

[Chapman, Katrina]

Yes.

--K

> -Original Message-
> From: Jared Clinton [mailto:[EMAIL PROTECTED]]
> Sent: Monday, October 09, 2000 4:58 PM
> To: CF-Talk
> Subject: RE: [RE: CGI Referrer variable]
> 
> 
> Does anybody know if it is possible for 
> 
> CGI.REMOTE_ADDR 
> 
>   or 
> 
> CGI.REMOTE_HOST 
> 
> to be supplied with fake values?
> 
> Thanks in advance, Jared Clinton.
> 
> > -Original Message-
> > From: JL [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, October 10, 2000 8:52 AM
> > To: CF-Talk
> > Subject: Re: [RE: CGI Referrer variable]
> > 
> > 
> > do you guys check this cgi.http_referer to see whether it's 
> > the correct ip?
> > 
> > J
> > 
> > [EMAIL PROTECTED] wrote:
> > > 
> > > I was wondering how long someone would take to bring it up.
> > > 
> > > Yep, it's mis-spelled.  The person writing the standard 
> > mis-spelled it and
> > > it became a standard before it was caught... or so the 
> > story goes.  So
> > we're
> > > stuck with it.
> > > 
> > > --Doug
> > > 
> > > -Original Message-
> > > From: Warrick, Mark [mailto:[EMAIL PROTECTED]]
> > > Sent: Monday, October 09, 2000 2:41 PM
> > > To: CF-Talk
> > > Subject: RE: CGI Referrer variable
> > > 
> > > 
> > > Interestingly enough, that variable name is spelled incorrectly.
> > > 
> > > It is HTTP_REFERER.
> > > 
> > > More variables like it can be found in the docs:
> > > 
> > >
> > cfdocs/Developing_Web_Applications_with_ColdFusion/03_Creating
> > _and_Manipulat
> > > ing_Variables/dwa03_12.htm
> > > 
> > > ---mark
> > > 
> > > --
> > > Mark Warrick
> > > Phone: (714) 547-5386
> > > Efax.com Fax: (801) 730-7289
> > > Personal Email: [EMAIL PROTECTED]
> > > Personal URL: http://www.warrick.net 
> > > Business Email: [EMAIL PROTECTED]
> > > Business URL: http://www.fusioneers.com
> > > ICQ: 346566
> > > --
> > > 
> > > 
> > > > -Original Message-
> > > > From: Brian bouldernet [mailto:[EMAIL PROTECTED]]
> > > > Sent: Monday, October 09, 2000 12:47 PM
> > > > To: CF-Talk
> > > > Subject: CGI Referrer variable
> > > > 
> > > > 
> > > > Does anyone know the variable name for refferer? I forgot 
> > ofhand...
> > > > 
> > > > Thnaks,
> > > > Brian
> > > > 
> > > > 
> --
> > > > 
> > > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > > > To Unsubscribe visit 
> > > > 
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
> > > > _talk or send a message to 
> [EMAIL PROTECTED] with 
> > > > 'unsubscribe' in the body.
> > > 
> > >
> > --
> > --
> > > --
> > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > > To Unsubscribe visit
> > > 
> > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list
> s/cf_talk or
> > send a message to [EMAIL PROTECTED] with 
> 'unsubscribe' in
> > the body.
> >
> --
> --
> --
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list
s/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the
body.



Get free email and a permanent address at http://www.netaddress.com/?N=1

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

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

RE: Cookie Detector

[Chapman, Katrina]

I thought that you couldn't test for a cookie on the same page that sets it.
Is this wrong?

Because this:



#IsDefined("cookie.test")#

Generates a Yes.

--K

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Monday, October 09, 2000 6:49 AM
> To: CF-Talk
> Cc: [EMAIL PROTECTED]
> Subject: Re: Cookie Detector
> 
> 
> Sure it can.  It just can't do it on the same page
> that attempts to set the cookie.
> 
> best,  paul
> 
> At 12:42 PM 10/9/00 +0100, you wrote:
> >But isdefined alone can't
> >determine whether they have cookies enabled or not.
> 
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit 
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list
> s/cf_talk or send a message to 
> [EMAIL PROTECTED] with 'unsubscribe' in the body.
> 
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: #Timeformat(Now())#

[Chapman, Katrina]

It's not a typo.  #TimeFormat(Now())# works, I get "01:22 PM".  He just
forgot his cfoutput's.

--K

> -Original Message-
> From: Warrick, Mark [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, October 05, 2000 11:17 AM
> To: CF-Talk
> Subject: RE: #Timeformat(Now())#
> 
> 
> That's a typo in whatever book you're reading.  Look it up in 
> the CFDOCS directory.
> 
> --
> Mark Warrick
> Phone: (714) 547-5386
> Efax.com Fax: (801) 730-7289
> Personal Email: [EMAIL PROTECTED]
> Personal URL: http://www.warrick.net 
> Business Email: [EMAIL PROTECTED]
> Business URL: http://www.fusioneers.com
> ICQ: 346566
> --
> 
> 
> > -Original Message-
> > From: Richard Colman [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, October 03, 2000 2:17 PM
> > To: CF-Talk
> > Subject: #Timeformat(Now())#
> > 
> > 
> > why doesn't this work:
> > 
> >  value="#Timeformat(Now())#" size="8">
> > 
> > It does not display the time, but displays #Timeformat(Now())#
> > It's in the book! The date version works! 
> > 
> > ?
> > 
> > Richard Colman
> > 
> > --
> > 
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > To Unsubscribe visit 
> > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
> > _talk or send a message to [EMAIL PROTECTED] with 
> > 'unsubscribe' in the body.
> 
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit 
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list
s/cf_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: NOT A MATH QUESTION, NumberFormat

[Chapman, Katrina]

He actually subscribes to the list so I'm sure when the next digest comes
out he'll get it.

--K

> -Original Message-
> From: Jaime Garza [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, October 05, 2000 10:51 AM
> To: CF-Talk
> Subject: RE: NOT A MATH QUESTION, NumberFormat
> 
> 
> The "36," means OK, and an "11," means incorrect date.
> 
> It works from 1/1 to 12/3 or "1,1" to "12,31"
> 
> OK, OK, I'll stop now!
> 
> Hey K, you can go now and explain this to *your fellow*
> 
> 
> 
> 
> 
> 
> 
> > -Original Message-
> > From: Chapman, Katrina [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, October 05, 2000 9:59 AM
> > To: CF-Talk
> > Subject: RE: NOT A MATH QUESTION, NumberFormat
> >
> >
> > *I'm* not trying to do this.  A fellow developer here at 
> Volt is and *I'm*
> > trying to help him find a reason why it does this.  
> Interesting that it's
> > not a number however.
> >
> > --K
> >
> > > -Original Message-
> > > From: Mark Johnson [mailto:[EMAIL PROTECTED]]
> > > Sent: Thursday, October 05, 2000 1:22 AM
> > > To: CF-Talk
> > > Subject: RE: NOT A MATH QUESTION, NumberFormat
> > >
> > >
> > > Maybe like Al Gore Allaire is practicing "Fuzy Number 
> Formatting". =)
> > >
> > > Mark
> > >
> > > -Original Message-
> > > From: Dan Haley [mailto:[EMAIL PROTECTED]]
> > > Sent: Thursday, October 05, 2000 5:06 PM
> > > To: CF-Talk
> > > Subject: RE: NOT A MATH QUESTION, NumberFormat
> > >
> > >
> > > And the result isn't a number!  Try this  . . .
> > >
> > > 
> > > 
> > >   
> > >   i - #x2# - #evaluate(x2 - x1)#
> > >   
> > > 
> > >
> > > It bombs on the evaluate(x2 - x1) saying that 36,526 is not a
> > > number.  Hmmm.
> > > Like the doctor says to the man who complains "it hurts when
> > > I do this",
> > > Katrina, don't do this. :)
> > >
> > > Dan
> > >
> > > -Original Message-
> > > From: Jaime Garza [mailto:[EMAIL PROTECTED]]
> > > Sent: Wednesday, October 04, 2000 5:28 PM
> > > To: CF-Talk
> > > Subject: RE: NOT A MATH QUESTION, NumberFormat
> > >
> > >
> > > Not so fast
> > >
> > > Hex 0x4000 => 16384.
> > > Octal 4000 2048.
> > >
> > > 36617 in bin => 10001001 which does not look at all
> > > like a 4000 in
> > > any numerical system.
> > >
> > > With more tests, 4,000, 4,00 4,0 and 4, return the same number.
> > > But 3,0 returns 36586
> > > And 2,0 returns 36557
> > > And 1,0 returns 36526
> > >
> > > 36,617 - 36586 = 31
> > > 36586 - 36557 = 29
> > > 36557 - 36526 =  31
> > >
> > >
> > > And it does not take "0,0"
> > >
> > > So there is no pattern...  Interesting bug.  Random is not.
> > >
> > > 
> > >
> > >
> > >
> > > > -Original Message-
> > > > From: Russel Madere [mailto:[EMAIL PROTECTED]]
> > > > Sent: Wednesday, October 04, 2000 5:21 PM
> > > > To: CF-Talk
> > > > Subject: RE: NOT A MATH QUESTION, NumberFormat
> > > >
> > > >
> > > > It is the comma.  I get the same result on my box.
> > > >
> > > > Maybe one of the CF Gurus.  hint hint, Dave Watts or Ben
> > > > Forta. can
> > > > give us an explanation.
> > > >
> > > > When I take out the comma, I get the right number.  
> What I think is
> > > > happening is that the sting is converted into binary by the
> > > > function.  Then
> > > > it is formatted.
> > > >
> > > > Russel
> > > >
> > > > 
> > > >   Russel Madere, Jr. Senior Web Developer
> > > >   ICQ: 5446158   http://www.TurboSquid.com
> > > >
> > > > Some days you eat the bear; some days the bear eats you.
> > > > ============
> > > >
> > > >
> > > > -Original Message-
> > > > From: Chapman, Katrina [mailto:[EMAIL PROTECTED]]
> > > > S

RE: NOT A MATH QUESTION, NumberFormat

[Chapman, Katrina]

*I'm* not trying to do this.  A fellow developer here at Volt is and *I'm*
trying to help him find a reason why it does this.  Interesting that it's
not a number however.

--K

> -Original Message-
> From: Mark Johnson [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, October 05, 2000 1:22 AM
> To: CF-Talk
> Subject: RE: NOT A MATH QUESTION, NumberFormat
> 
> 
> Maybe like Al Gore Allaire is practicing "Fuzy Number Formatting". =)
> 
> Mark
> 
> -Original Message-
> From: Dan Haley [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, October 05, 2000 5:06 PM
> To: CF-Talk
> Subject: RE: NOT A MATH QUESTION, NumberFormat
> 
> 
> And the result isn't a number!  Try this  . . .
> 
> 
> 
>   
>   i - #x2# - #evaluate(x2 - x1)#
>   
> 
> 
> It bombs on the evaluate(x2 - x1) saying that 36,526 is not a 
> number.  Hmmm.
> Like the doctor says to the man who complains "it hurts when 
> I do this",
> Katrina, don't do this. :)
> 
> Dan
> 
> -Original Message-
> From: Jaime Garza [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, October 04, 2000 5:28 PM
> To: CF-Talk
> Subject: RE: NOT A MATH QUESTION, NumberFormat
> 
> 
> Not so fast
> 
> Hex 0x4000 => 16384.
> Octal 4000 2048.
> 
> 36617 in bin => 10001001 which does not look at all 
> like a 4000 in
> any numerical system.
> 
> With more tests, 4,000, 4,00 4,0 and 4, return the same number.
> But 3,0 returns 36586
> And 2,0 returns 36557
> And 1,0 returns 36526
> 
> 36,617 - 36586 = 31
> 36586 - 36557 = 29
> 36557 - 36526 =  31
> 
> 
> And it does not take "0,0"
> 
> So there is no pattern...  Interesting bug.  Random is not.
> 
> 
> 
> 
> 
> > -Original Message-
> > From: Russel Madere [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, October 04, 2000 5:21 PM
> > To: CF-Talk
> > Subject: RE: NOT A MATH QUESTION, NumberFormat
> >
> >
> > It is the comma.  I get the same result on my box.
> >
> > Maybe one of the CF Gurus.  hint hint, Dave Watts or Ben
> > Forta. can
> > give us an explanation.
> >
> > When I take out the comma, I get the right number.  What I think is
> > happening is that the sting is converted into binary by the
> > function.  Then
> > it is formatted.
> >
> > Russel
> >
> > 
> >   Russel Madere, Jr. Senior Web Developer
> >   ICQ: 5446158   http://www.TurboSquid.com
> >
> > Some days you eat the bear; some days the bear eats you.
> > 
> >
> >
> > -Original Message-
> > From: Chapman, Katrina [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, October 04, 2000 19:01
> > To: CF-Talk
> > Subject: RE: NOT A MATH QUESTION, NumberFormat
> >
> >
> > MM,
> >
> > The " say's this is a string.
> >
> > It comes out at, at least on my machine, 36,617.  Any ideas why?
> >
> > BB,
> > --K
> >
> > > -Original Message-
> > > From: Mark Adams [mailto:[EMAIL PROTECTED]]
> > > Sent: Wednesday, October 04, 2000 4:32 PM
> > > To: CF-Talk
> > > Subject: Re: NOT A MATH QUESTION, NumberFormat
> > >
> > >
> > > Ok, I can't find reference to the " in NumberFormat what 
> does that do?
> > >
> > >
> > > - Original Message -
> > > From: Mark Adams <[EMAIL PROTECTED]>
> > > To: CF-Talk <[EMAIL PROTECTED]>
> > > Sent: Wednesday, October 04, 2000 3:55 PM
> > > Subject: Re: NOT A MATH QUESTION, NumberFormat
> > >
> > >
> > > > can i look now?
> > > >
> > > >
> > > > - Original Message -
> > > > From: Chapman, Katrina <[EMAIL PROTECTED]>
> > > > To: CF-Talk <[EMAIL PROTECTED]>
> > > > Sent: Wednesday, October 04, 2000 3:59 PM
> > > > Subject: RE: NOT A MATH QUESTION, NumberFormat
> > > >
> > > >
> > > > > Nope.
> > > > >
> > > > > > -Original Message-
> > > > > > From: Mark Adams [mailto:[EMAIL PROTECTED]]
> > > > > > Sent: Wednesday, October 04, 2000 3:44 PM
> > > > > > To: CF-Talk
&

RE: NOT A MATH QUESTION, NumberFormat

[Chapman, Katrina]

MM,   

The " say's this is a string.

It comes out at, at least on my machine, 36,617.  Any ideas why?

BB,
--K

> -Original Message-
> From: Mark Adams [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, October 04, 2000 4:32 PM
> To: CF-Talk
> Subject: Re: NOT A MATH QUESTION, NumberFormat
> 
> 
> Ok, I can't find reference to the " in NumberFormat what does that do?
> 
> 
> - Original Message -
> From: Mark Adams <[EMAIL PROTECTED]>
> To: CF-Talk <[EMAIL PROTECTED]>
> Sent: Wednesday, October 04, 2000 3:55 PM
> Subject: Re: NOT A MATH QUESTION, NumberFormat
> 
> 
> > can i look now?
> >
> >
> > - Original Message -
> > From: Chapman, Katrina <[EMAIL PROTECTED]>
> > To: CF-Talk <[EMAIL PROTECTED]>
> > Sent: Wednesday, October 04, 2000 3:59 PM
> > Subject: RE: NOT A MATH QUESTION, NumberFormat
> >
> >
> > > Nope.
> > >
> > > > -Original Message-
> > > > From: Mark Adams [mailto:[EMAIL PROTECTED]]
> > > > Sent: Wednesday, October 04, 2000 3:44 PM
> > > > To: CF-Talk
> > > > Subject: Re: NOT A MATH QUESTION, NumberFormat
> > > >
> > > >
> > > > -4,000
> > > >
> > > > Just guessing
> > > >
> > > > -Mark :o)
> > > >
> > > >
> > > > - Original Message -
> > > > From: Chapman, Katrina <[EMAIL PROTECTED]>
> > > > To: CF-Talk <[EMAIL PROTECTED]>
> > > > Sent: Wednesday, October 04, 2000 3:49 PM
> > > > Subject: NOT A MATH QUESTION, NumberFormat
> > > >
> > > >
> > > > > MM,
> > > > >
> > > > > Here's a question for y'all.  It's not math. It's cf.
> > > > >
> > > > > What will  
> #NumberFormat("4,000")# give you?
> > > > >
> > > > > Try to answer before you test it.
> > > > >
> > > > > BB,
> > > > > --K
> > > > >
> > > > > ---
> > > > > Thank you,
> > > > > Katrina Chapman
> > > > > ColdFusion Web Developer
> > > > > System Development
> > > > >
> > > > >
> > > > >
> > > > >
> > > > --
> > > > 
> > > > 
> > > > > Archives: 
> http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > > > > To Unsubscribe visit
> > > > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list
> > > s/cf_talk or
> > > send a message to [EMAIL PROTECTED] with 
> 'unsubscribe'
> in
> > > the body.
> > > >
> > >
> >
> > 
> --
> 
> > --
> > > --
> > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > > To Unsubscribe visit
> > > 
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list
s/cf_talk
or
> > send a message to [EMAIL PROTECTED] with 'unsubscribe'
in
> > the body.
>
> --
> 
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> >
>
> --

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


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

RE: NOT A MATH QUESTION, NumberFormat

[Chapman, Katrina]

Nope.

> -Original Message-
> From: Mark Adams [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, October 04, 2000 3:44 PM
> To: CF-Talk
> Subject: Re: NOT A MATH QUESTION, NumberFormat
> 
> 
> -4,000
> 
> Just guessing
> 
> -Mark :o)
> 
> 
> - Original Message -
> From: Chapman, Katrina <[EMAIL PROTECTED]>
> To: CF-Talk <[EMAIL PROTECTED]>
> Sent: Wednesday, October 04, 2000 3:49 PM
> Subject: NOT A MATH QUESTION, NumberFormat
> 
> 
> > MM,
> >
> > Here's a question for y'all.  It's not math. It's cf.
> >
> > What will  #NumberFormat("4,000")# give you?
> >
> > Try to answer before you test it.
> >
> > BB,
> > --K
> >
> > ---
> > Thank you,
> > Katrina Chapman
> > ColdFusion Web Developer
> > System Development
> >
> >
> >
> > 
> --
> 
> 
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list
s/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>


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

NOT A MATH QUESTION, NumberFormat

[Chapman, Katrina]

MM, 

Here's a question for y'all.  It's not math. It's cf.

What will  #NumberFormat("4,000")# give you?

Try to answer before you test it.

BB,
--K

---
Thank you,
Katrina Chapman
ColdFusion Web Developer
System Development



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

RE: _date fields

[Chapman, Katrina]

I've had this problem using standard input tags.  I even knew not to use it
but forgot.  Couldn't figure out why my start_date field wasn't being
passed.  Silly me.

--K

> -Original Message-
> From: Scott, Andrew [mailto:[EMAIL PROTECTED]]
> Sent: Monday, October 02, 2000 3:55 PM
> To: CF-Talk
> Subject: RE: _date fields
> 
> 
> Can I ask this is using the cfinput/cfform tgas I guess. The 
> sites that you
> guys use this on, are these commercial public sites or 
> intranet systems.
> 
> regards
> 
> Andrew Scott
> ANZ eCommerce Centre
> * Ph 9273 0693  
> * [EMAIL PROTECTED]
> 
> 
> -Original Message-
> From: Jamie Keane [mailto:[EMAIL PROTECTED]]
> Sent: 03 October 2000 07:38
> To: CF-Talk
> Subject: Re: _date fields
> 
> 
> I've experienced that on a few occasions, and it is because 
> CF reserves the
> "_date" suffix for validating fields.  The way around this is 
> to not name
> your form fields with _date or _required or whatnot.  I wish 
> there was a way
> to turn this off!
> 
> --
> Jamie Keane
> Programmer
> SolutionMasters, Inc.
> 9111 Monroe Rd., Suite 100
> Charlotte, NC  28270
> www.solutionmasters.com
> 704.563.5559 x 228  Voice
> 704.849.9291  Fax
> -Original Message-
> From: Karl Simanonok <[EMAIL PROTECTED]>
> To: CF-Talk <[EMAIL PROTECTED]>
> Date: Monday, October 02, 2000 3:44 PM
> Subject: _date fields
> 
> 
> >I've also experienced problems with form fields named 
> 'something_date',
> >they don't get properly passed as form fields.  I think it 
> has something
> >to do with CF's data input validation algorithm getting 
> confused when it
> >doesn't find a 'something' field to do the validation on.  
> I've learned
> >(the hard way) to never name a form field with a _date suffix, except
> >for validating a date field.
> >
> >Regards,
> >
> >Karl Simanonok
> >
> >Original message:
> >===
> >Date: Sun, 1 Oct 2000 11:13:17 -0400
> >From: Bud <[EMAIL PROTECTED]>
> >To: [EMAIL PROTECTED]
> >Subject: Re: Date fields in SQL
> >Message-ID: 
> >
> >On 10/1/00, W Luke penned:
> >>Hi,
> >>
> >>Well it's another Query problem for Will today - the error 
> message is
> >>telling me it can't find expiry_date field - in Access I've set the
> >>date/time format to a custom dd-mmm-yy - is this the 
> problem?  Here's
> >the
> >>code:
> >
> >For some reason, every now and again I have problems if I name
> >something underscore date. Try naming expirydate and see if that
> >helps.
> >
> >And it wouldn't hurt to refer to today as #createodbcdate(today)#.
> >But that's probably not the problem.
> >--
> >
> >
> >-
> --
> ---
> >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> >To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list
s/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


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

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

RE: JS does not work in Netscape but does in IE

[Chapman, Katrina]

I'm sorry I didn't realise till I sent this that I read your message
backwards.

--K

> -Original Message-
> From: Chapman, Katrina [mailto:[EMAIL PROTECTED]]
> Sent: Friday, September 29, 2000 1:44 PM
> To: CF-Talk
> Subject: RE: JS does not work in Netscape but does in IE
> 
> 
> function ValidateForm() {
> var valCurrentLoanInfo=document.Mailme.CurrentLoanInfo.value;
> var valNewMortinfo=document.Mailme.NewMortinfo.value;
> 
> //validate required fields
>   if
>   ((valCurrentLoanInfo=="")&&(valNewMortinfo==""))
>   {
>   alert("You must select a 
> Current Loan and/or
> a New Mortgage option.");
>   return false;   
>   }
> document.Mailme.action="actionpage.cfm";
> Mailme.submit()}
> 
> I know for a fact that this workis in IE cause it's what we 
> use here.  I
> haven't tested it in NS however.
> 
> --K
> 
> > -Original Message-
> > From: Brown, David D. [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, September 29, 2000 8:58 AM
> > To: CF-Talk
> > Subject: JS does not work in Netscape but does in IE
> > 
> > 
> > Could you someone tell me what is wrong with this code.?  It 
> > works fine in
> > IE, but not in Netscape.
> > 
> > 
> > What I have is two select boxes and want at least one to be 
> > something other
> > then null.
> > 
> > The form name is Mailme and the two select names are 
> > CurrentLoanInfo and
> > NewMortinfo
> > 
> > Thank you
> > 
> > David
> > 
> > 
> > function Validate() 
> > { var bIsValid = true; 
> > if (bIsValid && (!ValidCurrentLoanInfo() && !ValidNewMortInfo()))
> > { error(document.mailme.CurrentLoanInfo,"You must select a 
> > Current Loan
> > and/or a New Mortgage option.");
> >  bIsValid = false;
> >  }
> > 
> > --
> > 
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > To Unsubscribe visit 
> > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list
> s/cf_talk or send a message to [EMAIL PROTECTED] with
> 'unsubscribe' in the body.
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit 
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list
s/cf_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: JS does not work in Netscape but does in IE

[Chapman, Katrina]

function ValidateForm() {
var valCurrentLoanInfo=document.Mailme.CurrentLoanInfo.value;
var valNewMortinfo=document.Mailme.NewMortinfo.value;

//validate required fields
if
((valCurrentLoanInfo=="")&&(valNewMortinfo==""))
{
alert("You must select a Current Loan and/or
a New Mortgage option.");
return false;   
}
document.Mailme.action="actionpage.cfm";
Mailme.submit()}

I know for a fact that this workis in IE cause it's what we use here.  I
haven't tested it in NS however.

--K

> -Original Message-
> From: Brown, David D. [mailto:[EMAIL PROTECTED]]
> Sent: Friday, September 29, 2000 8:58 AM
> To: CF-Talk
> Subject: JS does not work in Netscape but does in IE
> 
> 
> Could you someone tell me what is wrong with this code.?  It 
> works fine in
> IE, but not in Netscape.
> 
> 
> What I have is two select boxes and want at least one to be 
> something other
> then null.
> 
> The form name is Mailme and the two select names are 
> CurrentLoanInfo and
> NewMortinfo
> 
> Thank you
> 
> David
> 
> 
> function Validate() 
> { var bIsValid = true; 
> if (bIsValid && (!ValidCurrentLoanInfo() && !ValidNewMortInfo()))
> { error(document.mailme.CurrentLoanInfo,"You must select a 
> Current Loan
> and/or a New Mortgage option.");
>  bIsValid = false;
>  }
> 
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit 
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list
s/cf_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: sql question

[Chapman, Katrina]

You can't do it without one other row that has a UNIQUE identifier.

--K

> -Original Message-
> From: Gavin Myers [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, September 27, 2000 11:59 AM
> To: CF-Talk
> Subject: ot: sql question
> 
> 
> here's what i'm doing
> 
> delete from class_registration
> where users_id='123123'
> and class_id='4242424'
> 
> here's what the table looks like
> 
> name  users_idclass_id
> gavin 123123  4242424
> gavin 123123  4242424
> gavin 123123  4242424
> gavin 123123  4242424
> 
> what i want to do is delete only 1 of those rows
> 
> suggestions?
> 
> thanks,
> Gavin
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit 
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list
> s/cf_talk or send a message to 
> [EMAIL PROTECTED] with 'unsubscribe' in the body.
> 
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: cfsqltype / StoredProc

[Chapman, Katrina]

MM Neil,

BTW I forgot you need to make sure that the cfprocparam tags are in the same
order as they are in the sp.

BB,
--K

> -Original Message-
> From: Neil H. [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, September 26, 2000 1:30 PM
> To: CF-Talk
> Subject: cfsqltype / StoredProc
> 
> 
> If I have a type TEXT what would I use for cfsqltype?
> 
> Thanks,
> 
> Neil
> 
> p.s. I am getting some crazy COUNT error when I know for a 
> fact that I am
> passing the correct number of parameteres.  I have confirmed 
> the names fo
> the parameters and the SP has been tested.
> 
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit 
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list
s/cf_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: cfsqltype / StoredProc

[Chapman, Katrina]

MM Neil,

VARCHAR

BB,
--K

> -Original Message-
> From: Neil H. [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, September 26, 2000 1:30 PM
> To: CF-Talk
> Subject: cfsqltype / StoredProc
> 
> 
> If I have a type TEXT what would I use for cfsqltype?
> 
> Thanks,
> 
> Neil
> 
> p.s. I am getting some crazy COUNT error when I know for a 
> fact that I am
> passing the correct number of parameteres.  I have confirmed 
> the names fo
> the parameters and the SP has been tested.
> 
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit 
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list
s/cf_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Cheap CF Hosting FOUND

[Chapman, Katrina]

You can use www.tio.com for $25 a month.  I'm not sure about all the details
but I know I have my own IP for both of my sites hosted there.  I can
adminstrate my own email accounts.  I have full FTP access.  Never had a
problem connecting unless I forgot my password.  And Adolph, the owner, is
very easy to work with.

--K

> -Original Message-
> From: Zachary Bedell [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, September 26, 2000 8:30 AM
> To: CF-Talk
> Subject: RE: Cheap CF Hosting FOUND
> 
> 
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
> 
> > >http://www.v-domains.com/
> > >9.95 per month includes CF.
> > Did you notice that if you want a database at all you have to go up
> > to $19.95 a month though.
> 
> Ugh! Says who?  Just use direct OLEDB access, and you don't need them
> to setup a DSN at all.  Just upload your Access DB and use a CFQuery
> line like this:
> 
> 
>  datasource="#DBPath#" 
> dbtype="OLEDB" 
> provider="Microsoft.Jet.OLEDB.4.0" 
> providerdsn="#DBPath#" 
> username="Admin" 
> password="">
> SQL...
> 
> 
> I know this might be a little off the edge of the list charter, and I
> hate to blow my own horn, but...
> 
> We host for $29.95 a month if anyone's interested.  That includes FTP
> access, 5 email accounts, unlimited email forwarding, MS FrontPage 2k
> support, ASP, CFM, your own IP address (none of that host header
> garbage I've seen a lot of other hosts using lately), and some
> assorted other goodies.  We don't charge extra for DB access unless
> you need a DSN or SQL server or something.  
> 
> AND, if you email me, I get back to you within the day if at all
> possible.  And you can even call me on the telephone & get a live
> person (namely me) if you need it.
> 
> I won't post contact info on the list, but if you wanted to email
> directly, I can give info to anyone who's interested.
> 
> My apologies in advance if anyone's offended by the more or less
> blatant commercial plug, but...  It seems relevant to this thread.
> 
> Best regards,
> Zac Bedell
> <[EMAIL PROTECTED]>
> http://www.adirondack.net
> 
> -BEGIN PGP SIGNATURE-
> Version: PGPfreeware 6.5.8 for non-commercial use 
> 
> iQA/AwUBOdDA8QraVoMWBwRBEQLyjQCfRtmEWbCqxmSe3ocN9vYP5z8dF2sAnjN9
> UC4zhlx5Mug12Ht6Du0alg/Z
> =Agzq
> -END PGP SIGNATURE-
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: What's wrong with this script?

[Chapman, Katrina]

MM Michael,

Okay then have you tried reseting the var "txt" to a null string at the end
of your inner loop?

Comme ça?


   
   
  #ID#
  
  
  #txt#

  
   


BB,
--K

> -Original Message-
> From: Michael Gagnon [mailto:[EMAIL PROTECTED]]
> Sent: Monday, September 25, 2000 5:29 PM
> To: CF-Talk
> Subject: Re: What's wrong with this script?
> 
> 
> Same results.  I get the following:
> 
> (ID Français English Español)
> 1 Producteur Producer Productor
> 2 Producteur Producer Productor
> 3 Producteur Producer Productor
> 
> I should get:
> 
> (ID   Français   English   Español)
> 1  Producteur   Producer   Productor
> 2  Commercialisation   Marketing   Comercialización
> 3  Sous-traitant   Subcontractor
> 
> Thanks!
> 
> - Original Message -
> From: "Chapman, Katrina" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Monday, September 25, 2000 9:16 PM
> Subject: RE: What's wrong with this script?
> 
> 
> > You need to remove the languages.
> >
> > Try This
> >
> > 
> >
> >
> >   #ID#
> >
> >   
> >   
> >   #txt#
> >   
> >
> > 
> >
> >
> > > -Original Message-
> > > From: Michael Gagnon [mailto:[EMAIL PROTECTED]]
> > > Sent: Monday, September 25, 2000 5:07 PM
> > > To: CF-Talk
> > > Subject: What's wrong with this script?
> > >
> > >
> > > Hi!
> > >
> > > I can't see what's wrong with this script.  I use the same thing
> > > on another page and it works fine.  It gives me the same answers
> > > on each row (the answers for the 1st row).
> > >
> > > 
> > >
> > >
> > >   #ID#
> > >
> > >   
> > >> > evaluate("table.#FORM.hlang##Languages.Abrev#")>
> > >   #txt#
> > >   
> > >
> > > 
> > >
> > >
> > >
> > >
> > > Here's the one that works:
> > >
> > > 
> > > action="sectors_submit.cfm?lang=#URL.lang#">
> > >
> > >
> > > 
> > > 
> > > 
> > > #Data.a3##Abrev#
> > >  > > name="Sector#Abrev#"
> > > value="#Val#" size="50" maxlength="100">
> > > 
> > > 
> > > 
> > > 
> > >
> > > --
> > > 
> > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > > To Unsubscribe visit
> > > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list
> > s/cf_talk or send a message to 
> [EMAIL PROTECTED] with
> > 'unsubscribe' in the body.
> > 
> --
> 
> 
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list
s/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


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

RE: What's wrong with this script?

[Chapman, Katrina]

You need to remove the languages.

Try This


   
   
  #ID#
  
  
  
  #txt#
  
   



> -Original Message-
> From: Michael Gagnon [mailto:[EMAIL PROTECTED]]
> Sent: Monday, September 25, 2000 5:07 PM
> To: CF-Talk
> Subject: What's wrong with this script?
> 
> 
> Hi!
> 
> I can't see what's wrong with this script.  I use the same thing
> on another page and it works fine.  It gives me the same answers
> on each row (the answers for the 1st row).
> 
> 
>
>
>   #ID#
>   
>   
>evaluate("table.#FORM.hlang##Languages.Abrev#")>
>   #txt#
>   
>
> 
> 
> 
> 
> 
> Here's the one that works:
> 
> 
>
>
>  
> 
> 
> 
> #Data.a3##Abrev#
>  name="Sector#Abrev#" 
> value="#Val#" size="50" maxlength="100">
> 
> 
> 
> 
> 
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit 
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list
s/cf_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Law Suit

[Chapman, Katrina]

It soo silly.  If you go to

http://www.milberg.com/allaire/complaint.html

And try to right click or make any keystroke while in the window you'll get
a message that says:

"This document may not be downloaded.
It may be viewed by clicking on the scroll bar, on the right side of your
screen.
If you would like a hard copy of this complaint, please contact Milberg
Weiss at (800) 320-5081."

Silly, silly fool developer.  They don't know about turning off JS or
clicking on View/Source to get it.  

Think someone should tell them?

--K 

> -Original Message-
> From: Parker, Kevin [mailto:[EMAIL PROTECTED]]
> Sent: Monday, September 25, 2000 5:05 PM
> To: CF-Talk
> Subject: RE: Law Suit
> 
> 
> (Could' resit the temptation.)
> 
> Should that be Explain this to the 
> shareholders
> 
> 
> 
> Kevin Parker
> Service and Communication
> WorkCover Corporation
> 
> [EMAIL PROTECTED]
> 
> ph:  +61 8 82332548
> fax: +61 8 82332000
> 
> 
> 
> -Original Message-
> From: John Morgan [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, 26 September 2000 7:14:AM
> To: CF-Talk
> Subject: Law Suit
> 
> 
> Looks like Allaire has a new freshly pressed suit...
> 
> a law suit!
> 
> http://biz.yahoo.com/bw/000925/ny_milberg.html
> 
> 
> --
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list
s/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.




This e-mail is intended for the use of the addressee only. It may contain
information that is protected by legislated confidentiality and/or is
legally privileged. If you are not the intended recipient you are prohibited
from disseminating, distributing or copying this e-mail. Any opinion
expressed in this e-mail may not necessarily be that of the WorkCover
Corporation of South Australia. Although precautions have been taken, the
sender cannot warrant that this e-mail or any files transmitted with it are
free of viruses or any other defect.
If you have received this e-mail in error, please notify the sender
immediately by return e-mail and destroy the original e-mail and any copies.


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

RE: Link that submits form

[Chapman, Katrina]

MM Derek,

Curious.  Why is it that you believe that you need the ()'s?  I tried my
code and it works perfectly.

BB,
--K

> -Original Message-
> From: Baker, Derek [mailto:[EMAIL PROTECTED]]
> Sent: Monday, September 25, 2000 2:55 PM
> To: CF-Talk
> Subject: RE: Link that submits form
> 
> 
> Add parentheses around the whole javascript function call.
> 
> 
> > -----Original Message-
> > From:   Chapman, Katrina [SMTP:[EMAIL PROTECTED]]
> > Sent:   Monday, September 25, 2000 1:47 PM
> > To: CF-Talk
> > Subject:FW: Link that submits form
> > 
> > I tried posting this on Friday but it apparently didn't go 
> through.  So
> > here
> > it is again.
> > 
> > 
> >  > WIDTH="16" HEIGHT="16" BORDER="0">
> > 
> > 
> > 
> > --K
> > 
> > >  -Original Message-
> > > From: System Administrator  
> > > Sent: Saturday, September 23, 2000 4:59 PM
> > > To:   [EMAIL PROTECTED]
> > > Subject:  Undeliverable: RE: Link that submits form
> > > 
> > > Your message did not reach some or all of the intended recipients.
> > > 
> > >   Subject:RE: Link that submits form
> > >   Sent:   9/22/00 4:58 PM
> > > 
> > > The following recipient(s) could not be reached:
> > > 
> > >   [EMAIL PROTECTED] on 9/23/00 4:59 PM
> > > The recipient was unavailable to take delivery of 
> > > the message
> > >   The MTS-ID of the original message is: c=US;a= ;p=Volt 
> > > Information;l=CA_EXCHANGE1-000922235809Z-79020
> > > MSEXCH:IMS:Volt Information 
> > > Sciences:Orange:CA_EXCHANGE1 3499 (000B099C) Host unreachable
> > > 
> > 
> --
> 
> > 
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > To Unsubscribe visit
> > 
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list
s/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.

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

FW: Link that submits form

[Chapman, Katrina]

I tried posting this on Friday but it apparently didn't go through.  So here
it is again.






--K

>  -Original Message-
> From: System Administrator  
> Sent: Saturday, September 23, 2000 4:59 PM
> To:   [EMAIL PROTECTED]
> Subject:  Undeliverable: RE: Link that submits form
> 
> Your message did not reach some or all of the intended recipients.
> 
>   Subject:RE: Link that submits form
>   Sent:   9/22/00 4:58 PM
> 
> The following recipient(s) could not be reached:
> 
>   [EMAIL PROTECTED] on 9/23/00 4:59 PM
> The recipient was unavailable to take delivery of 
> the message
>   The MTS-ID of the original message is: c=US;a= ;p=Volt 
> Information;l=CA_EXCHANGE1-000922235809Z-79020
> MSEXCH:IMS:Volt Information 
> Sciences:Orange:CA_EXCHANGE1 3499 (000B099C) Host unreachable
> 
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Another CFSPOT question

[Chapman, Katrina]

"What is the name of the ColdFusion function used to check for the existance
of a variable or parameter?"

I answered IsDefined("") and got it wrong?  What are they looking for here.
ParameterExists?  Or maybe I just didn't put it in the perfect format.

--K

---
Thank you,
Katrina Chapman
ColdFusion Web Developer
System Development
"Programming today is a race between software engineers striving to build
bigger and better idiot-proof programs, and the Universe trying to produce
bigger and better idiots. So far, the Universe is winning.
--Rich Cook"


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

RE: Reason for Alliare Stocks

[Chapman, Katrina]

No offense but honestly this isn't the place for this kind of letter.  You
should be writing to Allaire directly about how upset you were with the
service you received.  Something will be done about it.  Trust me I used to
be in Customer Service, before CF of course, and if you screw up and insult
one of the customers or make them feel anything less than God you are sure
to hear about it.  The opposite is also true.  If you make the customer
happy then you'll hear about that.

Anyway the point is we can't do anything about your experience here.
Allaire would be a much better place to vent.

--K

> -Original Message-
> From: William J Wheatley [mailto:[EMAIL PROTECTED]]
> Sent: Friday, September 22, 2000 8:06 AM
> To: CF-Talk
> Subject: OT: Reason for Alliare Stocks
> 
> 
> Ok let me say first that I LOVE COLDFUSION and i've used it 
> for 4 years
> now.
> 
> but i will say that i'm starting to become disilliusioned (sp) by the
> service i've recieved
> from allaire, it seems like everytime i try to buy one of 
> there products not
> only do i have to wait on hold for 20-50 minutes but i get 
> crappy help, i
> tell the sales guy want i want and he tells me what HE wants 
> me to buy and
> since i tell him no i dont want to buy 7 Licenses right now and spend
> 30,000, and the words where not right now, i would have 
> bought them from
> this guy Mark B. in a few months but he said OH no i want 
> them by the end of
> this month. And i had to just stop and say WAIT a second,
> you are the Sales guy i am the customer that wants to give 
> you money. I know
> to him 5000 is not alot of cash but we're going to have to 
> spend upwards of
> 30,000 in licenses eventually and he does not think that is 
> good enough. So
> he sends me a quote and then i answer via email saying OK 
> we're just going
> to do 1 copy of CF ENT for Linux and i mean he was so 
> unhelpfull he did not
> answer his email for several hours he was upset i asked for 
> the fax # he
> told me wrong ifnormation just to shut me up because we 
> called 5 minutes
> after his hours ended so he did not want to help.
> 
> Now i'm a very easy going guy but when a person that is supposed to be
> working for a company to ENHANCE its reputation and marketshare by
> developing a special sense of loyalty. By making the customer 
> feel that you
> actually give a damn about him and are not just in this for 
> your commission
> check. I know people are trying to make a living but dont do it at the
> expense of making your customers feel like you dont have 
> enough time in the
> day for them.
> 
> Luckily enough John with Customer Relations really saved the 
> day by being
> helpful, understanding and actually taking a damn minute to 
> listen to my
> problems and make me feel like i was important.
> So possibly the problem with allaires stock is that people 
> are getting the
> same trouble that i am.
> And one thing i would recommend allaire to do is get MORE 
> people to answer
> the darn phone so you dont have to sit on hold forever, but 
> if you cant do
> that at least get sales people that dont make me feel like 
> crap. We may be
> no microsoft or IBM, but we've referred our fair share of 
> people to use CF
> and we've given our fair share of money to Allaire when they 
> were nobodies
> still making CGI code, and for that type of loyalty they have 
> hired sales
> people that dont make us feel like we mean anything to them.
> 
> Thanks for Letting me Vent
> 
> 
> 
> Bill Wheatley
> IT DIRECTOR
> AEPS INC
> http://www.aeps.com
> ICQ: 417645
> http://www.aeps2000.com
> 954-472-6684 X303
> 
> 
> 
> Bill Wheatley
> IT Director
> AEPS INC
> http://www.aeps.com
> ICQ: 417645
> http://www.aeps2000.com
> 954-472-6684 X303
> 
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit 
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list
s/cf_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: SQL Select Max + a column

[Chapman, Katrina]

How about 

SELECT TOP 1 ID_ENC_TOY_IMAGE, ENC_TOY_IMAGE_LINK_TEXT
FROM ENC_TOY_IMAGE
WHERE ID_ENC_TOY = #ID_ENC_TOY#
ORDER BY ID_ENC_TOY_IMAGE DESC

--K

> -Original Message-
> From: Mark Warrick [mailto:[EMAIL PROTECTED]]
> Sent: Friday, September 22, 2000 1:28 AM
> To: CF-Talk
> Subject: SQL Select Max + a column
> 
> 
> I'm trying to do this:
> 
>   SELECT ID_ENC_TOY_IMAGE, ENC_TOY_IMAGE_LINK_TEXT
>   FROM ENC_TOY_IMAGE
>   WHERE ID_ENC_TOY = #ID_ENC_TOY#
> 
> But I want the max ID_ENC_TOY_IMAGE row.
> 
> I've tried:
> 
>   SELECT max (ID_ENC_TOY_IMAGE) as maxid, ENC_TOY_IMAGE_LINK_TEXT
>   FROM ENC_TOY_IMAGE
>   WHERE ID_ENC_TOY = #ID_ENC_TOY#
> 
> But I get an aggregate error.
> 
> If I leave off the extra column it works fine, but of course 
> then I'd have to run another query to get the remaining info I need.
> 
> I could also select all records and then order them in 
> descending order by ID_ENC_TOY_IMAGE, but that seems like an 
> awful waste of processor power.
> 
> Anyone know how to do this the right way?
> 
> --
> Mark Warrick
> Phone: (714) 547-5386
> Efax.com Fax: (801) 730-7289
> Personal Email: [EMAIL PROTECTED]
> Personal URL: http://www.warrick.net 
> Business Email: [EMAIL PROTECTED]
> Business URL: http://www.fusioneers.com
> ICQ: 346566
> --
> 
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit 
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list
s/cf_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Current Row in SQL as opposed to CF? [CF-Talk]

[Chapman, Katrina]

I spoke with our DBA and this is what he came up with.

SELECT  RowNo = 'Category ' + convert(varchar(10), (select count(*)
from category c2
where c2.category_title
<= c1.category_title)),
 category_title
FROM Category c1
order by category_title

Then you would output it using RowNo as the variable name.  The order by and
the where of the sub query MUST be the same column.  Let me know if you have
any more questions.

HTH,
--K

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, September 20, 2000 4:21 PM
> To: CF-Talk
> Subject: RE: Current Row in SQL as opposed to CF? [CF-Talk]
> 
> 
> I see two choices:
> 
> 1. CFLOOP over the query
> 
> 
> #Category_Title#>
> 
> You said you couldn't use CFLOOP in your script, but I'm not 
> sure why not.
> 
> 2. Use SQL Temp tables.  Where you do a SELECT, change it to 
> a SELECT INTO
> #tempTable and in that table definition, create an IDENTITY 
> field as the
> first column.  If your SELECT is ordered properly, the 
> Identity field will
> have an incremental numeric value 1..2..3..  This requires a stored
> procedure, but if you're good at writing sp's, it should work for you.
> 
> Given the two choices, I prefer #1.  But if you can't do it 
> in CF and must
> do it in SQL, #2 is probably your only other alternative.
> 
> --Doug
> 
> -Original Message-
> From: PC [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, September 20, 2000 7:40 AM
> To: [EMAIL PROTECTED]
> Subject: Re: Current Row in SQL as opposed to CF? [CF-Talk]
> 
> 
> I am using SQL Server 7.
> 
> I can use CFOUTPUT I suppose. What I need to do is set the 
> results to a
> variable and write that as part of a file.
> 
> I am a little unclear on how I would even use CFOUTPUT in 
> this fashion --
> can I somehow
> set the output to a variable?
> 
> 
> "Category"  #currentrow#  #Category_Title#
> 
> 
> I need this in a variable that is part of a few variables 
> concatenated and
> written to a file using CFFILE write 
> 
> Thanks for anymore insight... :)
> 
> 
> 
> > Not in standard SQL. This operation would be at odds with
> > the relational view of data, in which data is intrinsically
> > not ordered.
> >
> > So if there is a way of doing it that would work in a single
> > CFQUERY, it's going to be be DBMS-specific. If you happen
> > to be using PostgreSQL you might be able to to create a
> > user-defined function in 'C' to do it, but that would be
> > crazy.
> >
> > But if you can't use CFOUTPUT, why does it matter what the
> > results look like? What exactly are you trying to do?
> >
> > Nick
> >
> > -Original Message-
> > From: PC [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, September 20, 2000 2:07 PM
> > To: [EMAIL PROTECTED]
> > Subject: Current Row in SQL as opposed to CF? [CF-Talk]
> >
> >
> > IS there a way to do get the current row as part of a 
> select statement in
> a
> > similar fashion as the coldfusion #queryname.currentrow# property
> functions
> > in a CFOUTPUT context?
> >
> > What I need are results that look like:
> >
> > Category  1   Sports
> > Category  2   Languages
> > Category  3   Reference
> > Category  4   Politics
> >
> > from a query looking something like:
> >
> > SELECT TOP 4 Category + ?currentrow? + Category_title
> >
> > So what property exists, or technique for generating the 
> ?currentrow? part
> > of the statement  above
> >
> > Now, I cannot use the indentity field .. I don't want values like
> > Category 2  ...
> > Category 19  ...
> >
> > And ... I cannot use a CFOUTPUT or CFLOOP -- I want to do 
> it all in the
> SQL
> > statement if possible!!
> >
> >
> > 
> --
> 
> --
> > --
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > To Unsubscribe visit
> > 
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list
s/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
>
>
> **
> Information in this email is confidential and may be privileged.
> It is intended for the addressee only. If you have received it in error,
> please notify the sender immediately and delete it from your system.
> You should not otherwise copy it, retransmit it or use or disclose its
> contents to anyone.
> Thank you for your co-operation.
> **
> --

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


--
Ar

RE: Strange behavior in message body: no hard returns [CF-Talk] [CF-Talk]

[Chapman, Katrina]

You can try



Thank you for submitting your information.

Regards,
Paul Sinclair

-  Your form was as follows  -
#Form.Comments##chr(10)#
#Form.Name##chr(10)#
#Form.City#, #Form.State#  #Form.Country# - #DateFormat(Now(),',  d,
')##chr(10)#


> -Original Message-
> From: Paul Sinclair [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, September 20, 2000 4:39 AM
> To: [EMAIL PROTECTED]
> Subject: Strange behavior in  message body: no hard returns
> [CF-Talk]
> 
> 
> I'm using CF 4.5.1 Enterprise Edition. I have a form that 
> sends out a reply
> to the person submitting it using . It just spits out 
> the contents
> of the form so the person has confirmation of what was submitted.
> 
> The cfmail goes out okay, but for some reason it is ignoring 
> hard returns in
> the block of the message where I am regurgitating the form's 
> contents. Here
> is the code.
> 
>  TO="#FORM.email#"
> SUBJECT="Your submission#SpanExcluding(FORM.Name," ")#,
> 
> Thank you for submitting your information.
> 
> Regards,
> Paul Sinclair
> 
> -  Your form was as follows  -
> #Form.Comments#
> #Form.Name#
> #Form.City#, #Form.State#  #Form.Country# - 
> #DateFormat(Now(),',  d,
> ')#
> 
> 
> When the email is sent out, it puts the proper hard returns 
> in the part that
> is above "  Your form was as follows -" but the part 
> after it goes
> out as one long line. So it would be something like this in the email
> message:
> 
> I enjoyed the seminar. Think it was great. I would make this 
> suggestion.
> blah, blah, blah. John Doe. Springfield, VA US - September 20, 2000
> 
> I can't figure out why it is doing this. If I put in  
> after the lines,
> it puts a line break in but the  shows up (as expected) 
> in the contents
> of the email.
> 
> Any ideas what's causing this?
> 
> Paul Sinclair
> 
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit 
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list
s/cf_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: [CF-Talk] Random Images-Resources for Information?

[Chapman, Katrina]

This wouldn't really be random.  It would ensure that the same number
doesn't come up two times in a row, but that's not random.

According to m-w.com random (as an adjective, which is how we're using it)
is "being or relating to a set or to an element of a set each of whose
elements has equal probability of occurrence"

The key words here being "equal probability of occurrence".  By putting that
number in a list you make that numbers chance of beign used 0.  Therefore
the next number is no longer random.  

I'm not saying that your solution isn't what this person needs but the
number isn't completely random.  Just like Jim McAtee said you have the
chance of one number coming up ten, a hundred, even a thousand times in a
row.  Is it likely that will happen?  No, but it could.  The smaller the set
of numbers to choose from the more likely that is to happen.  It's the same
as you were taught in school when you learned averages.  Just because you
flip a quarter 100 times doesn't mean you'll get 50 heads and 50 tails.  Try
it.

--K

> -Original Message-
> From: Mark Warrick [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, September 20, 2000 4:14 AM
> To: [EMAIL PROTECTED]
> Subject: RE: [CF-Talk] Random Images-Resources for Information?
> 
> 
> Les,
> 
> There's no reason why it would not other than the law of 
> averages itself.  Perhaps the gods don't like all the numbers 
> on your machine.
> 
> Forget about it.  You've got a solution.
> 
> ---mark
> 
> --
> Mark Warrick
> Phone: (714) 547-5386
> Efax.com Fax: (801) 730-7289
> Personal Email: [EMAIL PROTECTED]
> Personal URL: http://www.warrick.net 
> Business Email: [EMAIL PROTECTED]
> Business URL: http://www.fusioneers.com
> ICQ: 346566
> --
> 
> 
> > -Original Message-
> > From: Les Mizzell [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, September 20, 2000 2:28 AM
> > To: [EMAIL PROTECTED]
> > Subject: RE: [CF-Talk] Random Images-Resources for Information?
> > 
> > 
> > Thanks - will try this and see what happens.
> > 
> > What nobody has told me yet though...is WHY *DOESN'T* " > name="imageswap" default="#randrange(1,7)#">" return 1 
> through 7 randomly?
> > 
> > Les Mizzell
> > ***
> > Some people say I'm too apathetic.
> > But why should I care?
> > 
> > > -Original Message-
> > > From: Mark Warrick [mailto:[EMAIL PROTECTED]]
> > > Sent: Wednesday, September 20, 2000 2:26 AM
> > > To: [EMAIL PROTECTED]
> > > Cc: [EMAIL PROTECTED]
> > > Subject: RE: [CF-Talk] Random Images-Resources for Information?
> > >
> > >
> > > Les,
> > >
> > > Forget what you've heard about randrange not really being random.
> > >  The following piece of code GUARANTEES that the number 
> WILL be random.
> > >
> > >
> > > 
> > >
> > >  > > sessionmanagement="Yes" setclientcookies="Yes" 
> clientstorage="Registry">
> > >
> > > 
> > >
> > > 
> > >
> > > 
> > >   
> > > 
> > >
> > >  > > "#ListAppend(session.randrangelist, newnum)#">
> > >
> > > 
> > > List: #session.randrangelist#
> > > Current Random Number: #newnum#
> > > 
> > >
> > > 
> > >   
> > > 
> > > 
> > >
> > > --
> > > Mark Warrick
> > > Phone: (714) 547-5386
> > > Efax.com Fax: (801) 730-7289
> > > Personal Email: [EMAIL PROTECTED]
> > > Personal URL: http://www.warrick.net
> > > Business Email: [EMAIL PROTECTED]
> > > Business URL: http://www.fusioneers.com
> > > ICQ: 346566
> > > --
> > >
> > >
> > > > -Original Message-
> > > > From: Les Mizzell [mailto:[EMAIL PROTECTED]]
> > > > Sent: Tuesday, September 19, 2000 9:14 PM
> > > > To: [EMAIL PROTECTED]
> > > > Subject: RE: [CF-Talk] Random Images-Resources for Information?
> > > >
> > > >
> > > > Well, in the process of trying to further understand 
> the random image
> > > > question, I've haven't been able to find much 
> information on random
> > > > functions at all.
> > > >
> > > > "Mastering Cold Fusion 4" doesn't even mention it
> > > > "Cold Fusion 4.0" Web Application Construction Kit (Forta) 
> > mentions the
> > > > tags, but doesn't really give any insight into the use
> > > > Nothing on the Allaire site except the product documentation
> > > >
> > > > anybody want to point me towards a good source?
> > > > Why isn't "randrange(1,7)" really all that random?
> > > >
> > > > Les Mizzell
> > > > ***
> > > > Some people say I'm too apathetic.
> > > > But why should I care?
> > > >
> > > > 
> --
> > > > 
> > > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > > > To Unsubscribe visit
> > > > 
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
> > > > _talk or send a message to 
> [EMAIL PROTECTED] with
> > > > 'unsubscribe' in the body.
> > >
> > > 

RE: [CF-Talk] Incorrect use of CFPARAM?

[Chapman, Katrina]

Can we see the template that has the query?

--K

> -Original Message-
> From: Jim McAtee [mailto:[EMAIL PROTECTED]]
> Sent: Monday, September 18, 2000 12:11 PM
> To: [EMAIL PROTECTED]
> Cc: Christopher S Martin
> Subject: Re: [CF-Talk] Incorrect use of CFPARAM?
> 
> 
> That's the way it should work.  You shouldn't really need to 
> set default
> values passed in from a select box, since a value will always 
> be passed.
> By default, the browser will preselect the first one, unless told
> otherwise, and that value will be passed if the user doesn't 
> change it.
> 
> I'd guess that if you're running into a problem with cfparam 
> seeming to
> overwrite values that should be passed from a form then you've either
> got a problem in your logic that handles the form submission, 
> or else in
> the form itself.
> 
> Jim
> 
> 
> -Original Message-
> From: Christopher S Martin <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
> Date: Monday, September 18, 2000 12:39 PM
> Subject: [CF-Talk] Incorrect use of CFPARAM?
> 
> 
> >Hello everyone.  I have a page that has a bunch of pull down 
> menus that
> a
> >user can use to search a database.
> >
> >At the beginning of the template, I have a bunch of CFPARAMS:
> >
> >
> >
> >
> >
> >
> >the actual selects look like:
> >
> >  
> >Northeast
> >Southeast
> >Southwest
> >Midwest
> >Western
> >Mid-Atlantic
> >Northwest
> >
> >
> >The actual action of the search is on the page itself.  
> Anyway, when I
> >select a region and hit submit, the cfparam statement overwrites the
> >variable I am trying to search by.  Shouldn't the cfparam only
> overwrite the
> >statement if it is not defined?
> >
> >Thanks in advance
> >
> >Chris Martin
> >[EMAIL PROTECTED]
> >www.fsenablers.com
> >www.fslink.com
> 
> 
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit 
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list
s/cf_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Newbie: Refreshing screen after update

[Chapman, Katrina]

You can also append a random number to the end of all of your urls

a la







--K

> -Original Message-
> From: Jason Green [mailto:[EMAIL PROTECTED]]
> Sent: Friday, September 15, 2000 8:40 AM
> To: [EMAIL PROTECTED]
> Subject: Re: Newbie: Refreshing screen after update
> 
> 
> I have had the problem with changing client variables and the 
> page would 
> load from cache and show the old values.  What I did was 
> instead of using 
> , I created a form with a hidden bogus field in 
> it and submited 
> the page back to the page I was wanting to show.  Here is an 
> example of the 
> code:
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> You have to have the hidden bogus field so Netscape will 
> process the page 
> correctly.  Hope this helps.
> 
> Jason Green
> Maxim Group
> St. Louis, MO
> 
> 
> 
> 
> >From: [EMAIL PROTECTED] (Olson, Kelly)
> >Reply-To: [EMAIL PROTECTED]
> >To: [EMAIL PROTECTED]
> >Subject: Newbie: Refreshing screen after update
> >Date: Thu, 14 Sep 2000 10:54:33 -0400
> >
> >I have a form that allows one to update company informaion. Upon
> >submitting the data it reloads the same page and updates changed
> >information. ( no big deal so far )
> >
> >There is also a HTML link back to the main menu. (CLICK - 
> this appears
> >to work fine.)
> >
> >The problem is if I select the menu item that goes back to the edit
> >company info screen the data is not displaying as the 
> updated version.
> >The database has been updated.  If I reload that screen it 
> displays the
> >updated version or if i go into anotherpart of the program 
> and come back
> >to the edit screen it is updated.  It is almost like the screen is
> >loading from a cached copy.
> >
> >Has anyone heard of this or know of a way to solve this?
> >
> >-
> -
> >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> >To Unsubscribe visit 
> >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lis
ts/cf_talk or 
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in 
>the body.

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

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


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

RE: Comparing values in 2 queries

[Chapman, Katrina]

You're right this can be done with a simple query


SELECT field_a
FROM table
WHERE field_a NOT IN (SELECT field_b FROM table)


This is bad = #field_a#

> -Original Message-
> From: Bud [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, September 14, 2000 3:57 AM
> To: [EMAIL PROTECTED]
> Subject: Re: Comparing values in 2 queries
> 
> 
> On 9/14/00, Roger Lim penned:
> >Hi,
> >
> >Wanna ask for help here. Let's say that I have 2 queries which have a
> >similar field column name. I wish to do a comparision and it's a AND
> >critieria.
> >
> >For example,
> >
> >Field_a Field_b
> >1   1
> >2   2
> >3   4
> >  5
> >
> >I wish to compare field_a with field_b and everything that's 
> in field_a has
> >to be found in field_b, else it'll fail. How do I go about 
> doing that ?
> 
> I'm absolutely certain that someone else will come up with a simpler 
> solution, but here's mine. :)
> 
> 
> 
> 
>  row>
> 
> 
> 
> 
> There were non matching values in row #badrow#!
> 
> All records match!
> 
> 
> The neat thing is, you could also pass a form to continue testing and 
> come up with the next bad row.
> 
> 
> 
> There were non matching values in row 
> #badrow#!
> 
> 
> 
> 
> 
> 
> 
> 
> All records match!
> 
> 
> Of course, rather than using cfbreak, you could set an empty list 
> before the loop.
> 
> The in lieu of cfbreak:
> 
> 
> Then after the loop.
> 
> 
> These rows did not match!
> 
> 
> #thisrow#
> 
> 
> 
> All records match!
> 
> -- 
> 
> Bud Schneehagen - Tropical Web Creations
> 
> _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
> ColdFusion Solutions / eCommerce Development
> [EMAIL PROTECTED]
> http://www.twcreations.com/
> 954.721.3452
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit 
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list
s/cf_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

FW: Comparing values in 2 queries

[Chapman, Katrina]

Sorry made a mistake and sent before I was done last time

That should have read.


SELECT field_a
FROM table
WHERE field_a NOT IN (SELECT field_b FROM table)



This is bad = #field_a#


The only prob with this is when either field has thousands of entries.

--K


 > -Original Message-
 > From: Chapman, Katrina 
 > Sent: Thursday, September 14, 2000 1:56 PM
 > To: '[EMAIL PROTECTED]'
 > Subject: RE: Comparing values in 2 queries
 > 
 > 
 > You're right this can be done with a simple query
 > 
 > 
 > SELECT field_a
 > FROM table
 > WHERE field_a NOT IN (SELECT field_b FROM table)
 > 
 > 
 > This is bad = #field_a#
 > 
 > > -Original Message-
 > > From: Bud [mailto:[EMAIL PROTECTED]]
 > > Sent: Thursday, September 14, 2000 3:57 AM
 > > To: [EMAIL PROTECTED]
 > > Subject: Re: Comparing values in 2 queries
 > > 
 > > 
 > > On 9/14/00, Roger Lim penned:
 > > >Hi,
 > > >
 > > >Wanna ask for help here. Let's say that I have 2 queries 
 > which have a
 > > >similar field column name. I wish to do a comparision and 
 > it's a AND
 > > >critieria.
 > > >
 > > >For example,
 > > >
 > > >Field_a Field_b
 > > >1   1
 > > >2   2
 > > >3   4
 > > >  5
 > > >
 > > >I wish to compare field_a with field_b and everything that's 
 > > in field_a has
 > > >to be found in field_b, else it'll fail. How do I go about 
 > > doing that ?

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

RE: Ok, What is Fusebox?

[Chapman, Katrina]

check out fusebox.org

> -Original Message-
> From: Mark Adams [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, September 12, 2000 11:48 AM
> To: [EMAIL PROTECTED]
> Subject: Ok, What is Fusebox?
> 
> 
> What is Fusebox? I keep hearing about it. 
> 
> 
> 
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit 
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list
> s/cf_talk or send a message to 
> [EMAIL PROTECTED] with 'unsubscribe' in the body.
> 
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Hah! I'm an idiot!

[Chapman, Katrina]

Sounds like a candidate for a verity search.  Don't ask me how though cause
I've never built one.  Although I'm sure someone else on this list can help
you.

--K

> -Original Message-
> From: Gavin Myers [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, September 12, 2000 6:25 AM
> To: '[EMAIL PROTECTED]'
> Subject: Hah! I'm an idiot!
> 
> 
> So i'm the only cold fusion programmer here at work. And I'm 
> designing the
> new site look, well one of the features they wanted was to be 
> able to have a
> search box wich will search the site and return results.
> 
> So, being the big dummy I am, I was like "hey no problem!"
> 
> Now that I think about it, I have no idea on where to even begin.
> This is what they want:
> 
> The website is about 60 pages, all of them CFM pages (even 
> though some of
> them don't have any cold fusion code in them, I made them cfm 
> on the sheer
> chance that i'd have to put something in them). 
> 
> The search box would search through those 60 pages and return 
> the results
> that closest match what you were looking for in the manner of 
> hyperlinks.
> 
> Gah!
> 
> Any suggestions would be greatly appreciated
> 
> Gavin
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit 
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list
s/cf_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: REGEX for everything but numbers

[Chapman, Katrina]

You're right it doesn't.  Major cranial flatulence on my part.

--K

> -Original Message-
> From: Russel Madere [mailto:[EMAIL PROTECTED]]
> Sent: Monday, September 11, 2000 12:57 PM
> To: [EMAIL PROTECTED]
> Subject: RE: REGEX for everything but numbers
> 
> 
> But that doesn't include whitespace and control characters.
> 
> -Original Message-
> From: Chapman, Katrina [mailto:[EMAIL PROTECTED]]
> Sent: Monday, September 11, 2000 14:24
> To: [EMAIL PROTECTED]
> Subject: RE: REGEX for everything but numbers
> 
> 
> There's also
> 
> ReReplaceNoCase(string, "[a-z]", "", "ALL")
> 
> --K
> 
> > -Original Message-
> > From: Justin Kidman [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, September 11, 2000 11:26 AM
> > To: '[EMAIL PROTECTED]'
> > Subject: RE: REGEX for everything but numbers
> >
> >
> > Try [^[:digit:]]
> >
> > Justin Kidman
> >
> > -Original Message-
> > From: Russel Madere [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, September 11, 2000 11:27 AM
> > To: CF Talk Mailing List
> > Subject: REGEX for everything but numbers
> >
> >
> > I'm trying to remove in a string that is NOT a number.  I 
> want to use
> > regular expression and the REReplaceNoCase() function to do
> > this.  Is there
> > a way to say everything except numbers?  I know [[:digit:]]
> > will give me the
> > digits, but I can't find a way to negate it.
> >
> > Any help is appreciated
> >
> > --
> > --
> > --
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > To Unsubscribe visit
> > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list
> s/cf_talk or
> send a message to [EMAIL PROTECTED] with 
> 'unsubscribe' in
> the body.
> --
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list
s/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

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


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

RE: REGEX for everything but numbers

[Chapman, Katrina]

There's also

ReReplaceNoCase(string, "[a-z]", "", "ALL")

--K

> -Original Message-
> From: Justin Kidman [mailto:[EMAIL PROTECTED]]
> Sent: Monday, September 11, 2000 11:26 AM
> To: '[EMAIL PROTECTED]'
> Subject: RE: REGEX for everything but numbers
> 
> 
> Try [^[:digit:]]
> 
> Justin Kidman
> 
> -Original Message-
> From: Russel Madere [mailto:[EMAIL PROTECTED]]
> Sent: Monday, September 11, 2000 11:27 AM
> To: CF Talk Mailing List
> Subject: REGEX for everything but numbers
> 
> 
> I'm trying to remove in a string that is NOT a number.  I want to use
> regular expression and the REReplaceNoCase() function to do 
> this.  Is there
> a way to say everything except numbers?  I know [[:digit:]] 
> will give me the
> digits, but I can't find a way to negate it.
> 
> Any help is appreciated
> 
> --
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list
s/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

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

RE: Importing a text file

[Chapman, Katrina]

Like this

#Replace("#f1_element#","Chr(34)"," ","ALL")#>


--K


-Original Message-
From: Ray, James A [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 08, 2000 12:05 PM
To: [EMAIL PROTECTED]
Subject: Importing a text file


I have a file that I need to import that looks something like this.

"A3","BOOSTER_TANK_ASSY","1B89037","Serial
Number",#2000-09-09#,100,75,"Visual Good","No"  

Now, I know how to import the, what I am having problems is that the data is
surrounded by "'s. This is my Replace statement

#Replace("#f1_element#"," "," ","ALL")#>

The question is, how do I stip out the "'s when "'s are part of the
statement?

Thank you for your help

Jim Ray



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

RE: MS Access CFUPDATE question

[Chapman, Katrina]

No you can't insert data into categories.groupid UNLESS that value that you
are inserting is in group.groupid.

For example:

+Group table
++Groupid   ++group
1   fruits
2   veges
3   meats
4   breads

+categories table
++groupid   ++categoryid++category
1   1   berries
1   2   all others
5   3   cooking oils
5   4   butter

Those last two entries into the categories table are invalid because there
is no group with an id of 5.  The fats/sugars group was never added to the
group table so you can't start adding categories yet.

HTH,
--K 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 06, 2000 10:11 AM
To: [EMAIL PROTECTED]
Subject: RE: MS Access CFUPDATE question



I am not quite clear what you are recommending. Do you mean that I can't
insert data in a column Categories.GroupID  of table Categories if that
Column is tied to Group.GroupID in table Group by using CFUPDATE.

Sorry if I come across stupid...

Thanks,

Nehal
-Original Message-
From: Shawn Regan [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 06, 2000 12:34 PM
To: '[EMAIL PROTECTED]'
Subject: RE: MS Access CFUPDATE question


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_01C01820.3D0E0070
Content-Type: text/plain;
charset="iso-8859-1"

You have a relationship with that table, that requires you to have a record
in it that is related with the table your updating.

Shawn Regan

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 06, 2000 9:20 AM
To: [EMAIL PROTECTED]
Subject: RE: MS Access CFUPDATE question


Anyone have an idea why the following error occurs when I use two tables in
MS Access that have one-to-many relationship with referencial integrity
applied. I am trying to update a record in Categories table which has one
column called GroupID.  The GroupID comes from Table called Group. I have
established one-to-many relationship between Group -to- Categories. I have
turned off the lookup column (combo box) option and changed it to text box.
I still get this error.



Error Diagnostic Information
ODBC Error Code = 23000 (Integrity constraint violation)


[Microsoft][ODBC Microsoft Access Driver] You cannot add or change a record
because a related record is required in table 'Group'.



The error occurred while processing an element with a general identifier of
(CFUPDATE), occupying document position (6:2) to (6:124).

Any suggestions are very welcome

Thanks,

Nehal



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

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


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

--_=_NextPart_001_01C01820.3D0E0070
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable






RE: MS Access CFUPDATE question



You have a relationship with that table, that =
requires you to have a record in it that is related with the table your =
updating.

Shawn Regan


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]">mailto:fleming@forteinterac=
tive.com]
Sent: Wednesday, September 06, 2000 9:20 AM
To: [EMAIL PROTECTED]
Subject: RE: MS Access CFUPDATE question



Anyone have an idea why the following error occurs =
when I use two tables in
MS Access that have one-to-many relationship with =
referencial integrity
applied. I am trying to update a record in =
Categories table which has one
column called GroupID.  The GroupID comes from =
Table called Group. I have
established one-to-many relationship between Group =
-to- Categories. I have
turned off the lookup column (combo box) option and =
changed it to text box.
I still get this error.




Error Diagnostic Information
ODBC Error Code =3D 23000 (Integrity constraint =
violation)



[Microsoft][ODBC Microsoft Access Driver] You cannot =
add or change a record
because a related record is required 

RE: ODBC Date errors

[Chapman, Katrina]

The DaysInMonth function needs a date not just the month number but also the
year.  Try this.

Good!!





#today# - #endday#


Bad!!





#today# - #endday#



The second loop will bomb out on the second pass through because the
DaysInMonth function isn't working properly.

--K

-Original Message-
From: Kevin Queen [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 05, 2000 10:35 AM
To: Cold Fusion
Subject: ODBC Date errors


List,
I have a template that creates a query to get information for the month
selected.  I am doing this by constructing a query like this :





SELECT Location, Name, Time, Event_Date, Event_Number, Location
FROM Tbl_Events
WHERE Event_Date >= #Today#
AND Event_Date <= #EndDay#


ByYear is passed as the year selected from a form.
ByMonth is the numerical month passed from a form.

Now the issue is that when I pass September as "9" then the above cfset for
EndDay returns 2000- 9-31 (obviously wrong) and November as "11" returns
2000-11-31 (also wrong).

What is the problem with these two months??

TIA,
Kevin


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

RE: Rounding to the nearest nickel?

[Chapman, Katrina]

This would round to the nearest penny.  It should b



--K

-Original Message-
From: !jeff! [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 30, 2000 5:22 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Rounding to the nearest nickel?







At 06:53 PM 8/30/2000 -0500, [EMAIL PROTECTED] wrote:
> > I seem to have a dilema and I would hope that someone on this
> > list could
> > help me. I need to round a number to the nearest nickel for
> > instance 10.225
> > should go to 10.20 and so on. With the round function I can
> > only round to
> > the nearest whole number. I have no idea what to do and would really
> > appreciate any help in pointing me in the right direction.
>
>Try this:
>
>
>
>Ron Allen Hornbaker
>President/CTO
>Humankind Systems, Inc.
>http://humankindsystems.com
>mailto:[EMAIL PROTECTED]
>
>
>---
---
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>To Unsubscribe visit 
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or 
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in 
>the body.

!j!

The mark of mediocrity is searching for the precedent.

!jeff! sherwood Director of BIGWORDS.com Web Site Design / JEDI
   BIGWORDS.com worker#2
[EMAIL PROTECTED]   [EMAIL PROTECTED]
.r.e.c.o.v.e.r.e.d.n.e.t.s.c.a.p.e.u.s.e.r. . . . 415.543.1400.x300


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

RE: SQL

[Chapman, Katrina]

You can do it the old fanshioned way with cfquery and statements.

--K

-Original Message-
From: Chad [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 30, 2000 10:53 AM
To: [EMAIL PROTECTED]
Subject: SQL


Im doing a quote for a company that has a current SQL database for their 
existing web page.  We will be adding a section to their web page.

Is there a way i can edit this SQL database remotely?  I have never worked 
with a SQL database or server, and im wondering what kind of investment i 
have to make to edit their existing database?

Thanks
Chad



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

RE: IsDefined help

[Chapman, Katrina]

That only works however if the user hasn't turned off JavaScript.  

--K

-Original Message-
From: Peter Tilbrook [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 29, 2000 8:00 PM
To: '[EMAIL PROTECTED]'
Subject: RE: IsDefined help


If you use "CFFORM" with "CFINPUT" you can ensure that they at least enter
something. eg:


Retrieve Password
Email Address: 

 


Peter Tilbrook
Internet Applications Developer
Aspect Computing Pty. Ltd.
19-25 Moore Street
Turner, ACT, 2612
AUSTRALIA

http://www.aspect.com.au

Phone: (02) 6247 7677
Fax: (02) 6249 1620
Mobile: 0428 765 020

ACT ColdFusion Users Group - http://203.37.24.198


-Original Message-
From: Joel Blanchette [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 30 August 2000 12:33
To: [EMAIL PROTECTED]
Subject: IsDefined help


This is a multi-part message in MIME format.

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

Hello everyoneI am having some stupid problems with a simple =
command.  I am to make a check on a form field and if it is not defined =
to write something.  i tried the following with no success...Hope =
someone can help.


You forgot your name


I also tried


You forgot your name


but still with no success...Hope someone can help me out!!!

Thanks...

Joel

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








Hello everyoneI am having some stupid problems =
with a=20
simple command.  I am to make a check on a form field and if it is =
not=20
defined to write something.  i tried the following with no =
success...Hope=20
someone can help.
 

    You forgot your name

 
I also tried
 


    You forgot your name

 
but still with no success...Hope someone can help me out!!!
 
Thanks...
 
Joel

--=_NextPart_000_0005_01C01200.C3750520--


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

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

RE: IsDefined help

[Chapman, Katrina]

Try

You forgot your name.


-Original Message-
From: Joel Blanchette [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 29, 2000 7:33 PM
To: [EMAIL PROTECTED]
Subject: IsDefined help


This is a multi-part message in MIME format.

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

Hello everyoneI am having some stupid problems with a simple =
command.  I am to make a check on a form field and if it is not defined =
to write something.  i tried the following with no success...Hope =
someone can help.


You forgot your name


I also tried


You forgot your name


but still with no success...Hope someone can help me out!!!

Thanks...

Joel

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








Hello everyoneI am having some stupid problems =
with a=20
simple command.  I am to make a check on a form field and if it is =
not=20
defined to write something.  i tried the following with no =
success...Hope=20
someone can help.
 

    You forgot your name

 
I also tried
 


    You forgot your name

 
but still with no success...Hope someone can help me out!!!
 
Thanks...
 
Joel

--=_NextPart_000_0005_01C01200.C3750520--


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

RE: Query Help - Using 'GROUP'

[Chapman, Katrina]

that's all good except the r.

It should be


  
Agent
Territories
  
  
  
#firstname# #lastname#
#territory#,
  
  



--K

-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 29, 2000 5:29 PM
To: [EMAIL PROTECTED]
Subject: Re: Query Help - Using 'GROUP'


Well, I dug into the CF docs and figured this out (mostly).  You just
nest another set of  tags within the outer looping
cfoutput.  The question I have now is how can I conditionally produce
the comma separators?  Is there anything I can test to tell me I'm
outputting the last item of a group (so I don't append a comma)?  Here's
what I have:


  
Agent
Territories
  
  
  
#r.firstname# #r.lastname#
#r.territory#,
  
  


Jim


-Original Message-
From: Jim McAtee <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Tuesday, August 29, 2000 6:17 PM
Subject: Query Help - Using 'GROUP'


>I've got a one to many relationship linking tables A -> B -> C.  For
>each item in A (sales reps), I've got multiple records in B (linking
>reps to territories) and C contains the territories - say North, South,
>East and West.  I want to output a table something like
>
>Reps   Territories
>-  
>Bill   S,W
>Mike   N,S,E
>JoeE,W
>
>The question is: Can I use CF's GROUP="AgentID"> to easily create this table?  If so, how do I produce
>the lists of territories?  Grouping on the RepID essentially throws out
>the 2nd, 3rd, 4th etc. territory and I can only display the first one.
>If it can't be done easily in CF, can it be done in SQL (MS SQL)?  My
>last resort would be to just get all the reps, loop through that query
>and do a query on B & C each time through the loop.  That's what I'm
>trying to avoid.
>
>Thanks,
>Jim
>
>---
---
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.


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

RE: Can't work out IIF/IsDefined quirk

[Chapman, Katrina]

Paul,

You're right you can use IsDefined in an IIf.  I do it all the time.  BTW
you should probably also trim the form.fieldname.

IE:


The form fieldname equals something.


Bud,

>From the docs.

"The function evaluates its condition as a Boolean. If the result is TRUE,
it returns the value of Evaluate(string_expression1); otherwise, it returns
the value of Evaluate(string_expression2)."

The syntax is "IIf(condition, string_expression1, string_expression2)".

So in this case if the variable does in fact exist then it will evaluate
String1.  Otherwise it does string2.

HTH,
--K



-Original Message-
From: Paul Johnston [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 29, 2000 7:42 AM
To: [EMAIL PROTECTED]
Subject: RE: Can't work out IIF/IsDefined quirk


If I can't use IsDefined with IIF, how come the code I was given works then?
;)

As far as I am aware, IIF will work with any boolean expression, and
IsDefined is probably the most useful boolean function around in CF.

Paul

> -Original Message-
> From: Bud [mailto:[EMAIL PROTECTED]]
> Sent: 29 August 2000 15:26
> To: [EMAIL PROTECTED]
> Subject: RE: Can't work out IIF/IsDefined quirk
>
>
> On 8/29/00, Geoffrey V. Brown penned:
> >Hi,
> >Use this:
> >
> >#IIF(isdefined("form.categories"), "form.categories", de(''))#
>
> Sorry. You can't use isdefined in an IIF. If it's not defined it will
> still try and reference the variable and return an error. If you must
> use isdefined, you'll need to use a real cfif.
>
> What you can do is this:
>
> 
> 
> 
> 
> 
>
> IIf(variables.categories is "", DE(''), DE(variables.categories))#
>
> Or:
>
> IIf(variables.categories is "", DE(''), DE('#variables.categories#'))#
> --
>
> Bud Schneehagen - Tropical Web Creations
>
> _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
> ColdFusion Solutions / eCommerce Development
> [EMAIL PROTECTED]
> http://www.twcreations.com/
> 954.721.3452
> --
> 
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.



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

RE: Sorting Query results

[Chapman, Katrina]

You need to add an order by clause to your SQL statement, and order by
company name.

--K

-Original Message-
From: Lisa Hamlin [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 28, 2000 11:39 AM
To: [EMAIL PROTECTED]
Subject: Sorting Query results


This is a multi-part message in MIME format.

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

We have a customer who wants to take the results of a query and sort =
them by a specific column. The intial query did a UNION on several =
tables (one table for each month). The resulting output looked something =
like this:

COMPANY1
 PRODUCT A  - totals
 PRODUCT B  - totals
COMPANY2
 PRODUCT C  - totals
 PRODUCT D  - totals
 COMPANY3
 PRODUCT 3   - totals
COMPANY1
 PRODUCT B  - totals


The customer wants to re-sort so that all of COMPANY1's information is =
consecutive (for grand totals). How can this be done?

Thanks in advance,
Lisa
 =20

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








We have a customer who wants to take =
the results of=20
a query and sort them by a specific column. The intial query did a =
UNION on=20
several tables (one table for each month). The resulting output looked =
something=20
like this:
 
COMPANY1
 PRODUCT =
A  -=20
totals
 PRODUCT =
B  -=20
totals
COMPANY2
 PRODUCT =
C  -=20
totals
 PRODUCT =
D  -=20
totals
 COMPANY3
 PRODUCT =
3   -=20
totals
COMPANY1
 PRODUCT =
B  -=20
totals
 
 
The customer wants to re-sort so that =
all of=20
COMPANY1's information is consecutive (for grand totals). How can this =
be=20
done?
 
Thanks in advance,
Lisa
=20
 

--=_NextPart_000_0187_01C010FD.C35A9E00--


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

RE: Concatenate Strings

[Chapman, Katrina]

If your strings aren't variables



--K

-Original Message-
From: Peter Benoit [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 24, 2000 10:57 AM
To: '[EMAIL PROTECTED]'
Subject: Concatenate Strings


How can I concatenate 2 strings in CF?



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

RE: How do I get my Current URL

[Chapman, Katrina]

Don't know of one off the top of my head but you could build it using three
CGI variables.  Server_name, Script_name, and query_string

Just concatenate those in that order and you'll have it.

--K

-Original Message-
From: Mark Armendariz [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 24, 2000 8:58 AM
To: Cf-Talk
Subject: How do I get my Current URL


I've done this 100's of times, and I've drawn a blank. How do I get the
current URL of the page I'm working on (full URL with parameters) within a
variable? I'm trying to do a "Print This Page" button which will, with an
additional parameter of &Print=1, kill the menus and titles and print the
page. I have all the javascript and other functionality in place, I just
need the link that refers to the currentpage with the added parameter.

Thanks...



Mark Armendariz
Righteous Design

www.sorighteous.com



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

RE: Dates

[Chapman, Katrina]

Yes they will.

BTW

This would be faster



--K

-Original Message-
From: Peter Benoit [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 24, 2000 8:22 AM
To: '[EMAIL PROTECTED]'
Subject: Dates


If I use this?




Will months with 2 digits appear with 2 digits?  IE 10/10/00?

thanks,
Pete


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

RE: IsDefined() Problem

[Chapman, Katrina]

The reason you don't put quotes in most of the other functions is because
you want those functions to work with the value of the variable.  This one
you just want it to make sure that exists.  If you don't put the "'s and the
parameter isn't defined you'll get an error.

--K

-Original Message-
From: Paul Johnston [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 24, 2000 8:02 AM
To: Cf-Talk
Subject: RE: IsDefined() Problem


Figured it out (taken me months!)

I need to put quotes in, which seems a bit irish to me as all other
functions (those I can think of off the top of my head) you don't put the
quotes in when putting in a variable.

Sorry to bother you!

Paul



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

RE: Select Query

[Chapman, Katrina]

That's almost it you need to add %'s around the string passed.

IE


SELECT  *
FROM Customerdoclist 
WHERE   (Customerdoclist.keywords LIKE '%#url.page#%')
 

-Original Message-
From: Peter Benoit [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 23, 2000 1:31 PM
To: '[EMAIL PROTECTED]'
Subject: Select Query


I have set a url string to a page, and I want to perform a query from a DB
using that as a keyword.

Can I set a field in a DB with a bunch of keywords to compare against a
string?

Lets say I pass the word "Peter" is #url.page#

And the field in the DB named Keyword has - John Mary Peter Bill - in it.
Is it possible to build a query that will find Peter in that list of words,
and presents the results?

My code so far:


SELECT  *
FROM Customerdoclist 
WHERE   (Customerdoclist.keywords LIKE '#url.page#')
  


Peter


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

RE: How can I get around this?

[Chapman, Katrina]

You can reload the left hand nav bar after the user logs in to include that
value on that particular link.

--K

-Original Message-
From: Terri Stocke [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 23, 2000 12:00 PM
To: [EMAIL PROTECTED]
Subject: How can I get around this?


Hi All,

I have a login screen that passes the userid to a query:


SELECT  suggestion_id,
suggestion_name,
status_code,
actual_evaluator_userid
FROM SUG_SUGGESTIONS
WHERE status_code IN ('I', 'E', 'F', 'S')  AND
actual_evaluator_userid='#url.userid#'
  

Basically, whenever the user comes back to this page (eval.cfm), I want only

those records that pertain to that userid to be displayed.  Seems simple 
enough.

The problem is that I have an included template for my left-hand navigation.

This left-hand navigation has no idea what userid was passed from the form, 
so every time someone clicks on the link to go back to eval.cfm from the 
navigation bar, an error is thrown that the parameter "url.userid" cannot be

resolved.  I really don't want to go back through and take out all of my 
included pages.  Is there any other way I can get around this?

Thanks!

T

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


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

RE: Newbie Cold Fusion Studio Question

[Chapman, Katrina]

"I am not running Cold Fusion Server but am using the Microsoft Personal
Server for Windows 95."

There's your problem  You can't expect CF templates to process as CF unless
you have the server.

--K

-Original Message-
From: Olive, Christopher M Mr NMR
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 23, 2000 11:48 AM
To: '[EMAIL PROTECTED]'
Subject: RE: Newbie Cold Fusion Studio Question


what is your test file's extension?  if it isn't .cfm, CF server won't pick
it up and do anything with it.

Chris Olive,
DOEHRS Website Administrator 



-Original Message-
From: Kim Woodbridge [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 23, 2000 2:44 PM
To: [EMAIL PROTECTED]
Subject: Newbie Cold Fusion Studio Question


Hello,

I am trying to set up Cold Fusion Studio in order to view and alter
.cfm files created by our main IS department.  I have set up the
Developmental Mappings properly and have created a very simple file from
an example in the Studio documentation.



Call Department


Call Department





I'd like to talk to someone in #Department# in #city# who earns at 
least #Salary#.




When I view this in my browser it shows #Department# etc. rather than
filling in the variables.  Does anyone know what I may have not
configured properly or what I am missing here.

I am not running Cold Fusion Server but am using the Microsoft Personal
Server for Windows 95.

Thanks in advance.



Kim A. Woodbridge
Web Developer
Children's Hospital of Philadelphia
215-590-1197
[EMAIL PROTECTED]

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

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

RE: Division in Cold Fusion?

[Chapman, Katrina]

Just like you did but you're using the wrong slash it should be.



BTW you also don't need #'s in set's unless the variable name is in ""'s.

HTH,
--K

-Original Message-
From: Peter Benoit [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 23, 2000 11:33 AM
To: '[EMAIL PROTECTED]'
Subject: Division in Cold Fusion?


I must be looking at all the wrong stuff... but I want to take 2 values and
divide them.

like:



Is there a correct way to do this?

Thanks,
Pete


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

RE: nested

[Chapman, Katrina]

That's not entirely true.  You can do a plain vanilla cfoutput inside of a
grouped query driven output.  What are you trying to do.

--K

-Original Message-
From: Dana Larose [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 22, 2000 3:29 PM
To: [EMAIL PROTECTED]
Subject: RE: nested 


>
> Hi All,
> I am curious to know when to use nested 
>

You can't do nested 's.  CFServer will throw up an error message
if you try.

Dana Larose
ColdFusion Monkey
Canadian Web Design & Consulting Inc.

A: 701-281 McDermot Avenue (McDermot & King)
P: 204.946.5155
C: 204.228.0477
F: 204.946.5156
E: [EMAIL PROTECTED]
W: http://www.cdnwebdesign.com


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

custom functions

[Chapman, Katrina]

Was the article on custom functions ever published on FusionAuthority?  If
so where is it?  I can't seem to find it.  Then again I can't open a bag of
cookies without scissor's but that's something else entirely.

--K

Thank you,
Katrina Chapman
ColdFusion Web Developer
Systems Development



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

RE: CF2DOC

[Chapman, Katrina]

Is what possible?

--K

-Original Message-
From: Iztok Polanic [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 18, 2000 9:19 AM
To: [EMAIL PROTECTED]
Subject: CF2DOC


 Hi!
  
 Is this possible?
  
 Bye,
  
  Iztok
  
  
 
 


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

RE: CF's Redheaded Stepchild

[Chapman, Katrina]

The "redheaded stepchild" is a joke.

--K

-Original Message-
From: Rey Bango [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 18, 2000 9:24 AM
To: [EMAIL PROTECTED]
Subject: Re: CF's Redheaded Stepchild


Not sure what you mean by "Redheaded Stepchild". It just looks to me like
they're realizing that e-biz is a lot harder to deal with than just having
people walk into a store and carry out there goods.

Toys 'R Us' issues specifically dealt w/ their architecture and order
fulfillment.

Rey Bango
Team Allaire...
Certified Allaire Instructor

- Original Message -
From: "dolliedish" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, August 18, 2000 11:14 AM
Subject: CF's Redheaded Stepchild


> http://news.cnet.com/news/0-1007-200-2553231.html?tag=st.ne.1002.thed.ni
>
> --
> - * - p i p p a - * -
> - * - T h e  D o l l s ,  T h e  D i s h ,  - * -
> - * - a n d  T h e  D o l l a r s   - * -
> - * -   http://www.dolliedish.com/barbie- * -
> --

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


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

RE: SQL query problem...

[Chapman, Katrina]

What's a TB303?

--K

-Original Message-
From: Rich Wild [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 17, 2000 10:57 AM
To: [EMAIL PROTECTED]
Subject: RE: SQL query problem...



OK, this is probably wrong, but its all I can glean from SQL BOL

ALTER TABLE table_name NOCHECK CONSTRAINT your_primary_key

...do your stuff...

ALTER TABLE table_name CHECK CONSTRAINT your_primary_key



If I'm right, you owe me a mint condition TB303!

*me sits down and crosses fingers in hope*

--
Rich Wild
Senior Web Designer

---
e-mango.com ltd  Tel: 01202 587 400
Lansdowne Place  Fax: 01202 587 401
17 Holdenhurst Road
Bournemouth   Mailto:[EMAIL PROTECTED]
BH8 8EW, UK  http://www.e-mango.com
---
This message may contain information which is legally
privileged and/or confidential.  If you are not the
intended recipient, you are hereby notified that any
unauthorised disclosure, copying, distribution or use
of this information is strictly prohibited. Such
notification notwithstanding, any comments, opinions,
information or conclusions expressed in this message
are those of the originator, not of e-mango.com ltd,
unless otherwise explicitly and independently indicated
by an authorised representative of e-mango.com ltd.
---
 

-Original Message-
From: Ryan Williams [mailto:[EMAIL PROTECTED]]
Sent: 17 August 2000 18:15
To: [EMAIL PROTECTED]
Subject: Re: SQL query problem...





 Oops.  I just stumbled onto the answer by accident.  I just removed the
"-2"
 and
 associated parentheses from the sub-query and I got my results.  My
 sub-query
 now looks like:
 select max(right(wire_id,len(wire_id))) from wire_list)
 and it works too !! :-)

 My sincerest apologies to everyone in the list.

 Ryan Williams
 [EMAIL PROTECTED]



> - Original Message -
> From: "Ryan Williams" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, August 17, 2000 12:45 PM
> Subject: SQL query problem...
>
>
> > I have a SQL problem.  I know what information I want to retrieve
from
> > the DB,
> > however, I do not know what precisely is the proper SQL syntax/function
> is
> > in order to
> > achieve it.
> >
> >The query as it is currently  written in my CF template is:
> > select wl.*,p.*,wlg.*,wb.*,wsnd.*,wrcvd.*,ws.*
> > from wire_list wl
> > left join P_officers p on wl.reg_by = p.off_id
> > left join wire_status ws on wl.status_code = ws.status_code
> > left join wire_log wlg on wl.wire_id = wlg.wire_id
> > left join wire_senders wsnd on wl.sender_id = wsnd.sender_id
> > left join wire_rcv_modes wrcvd on wl.rcv_mode = wrcvd.rcv_mode
> > left join wire_banks wb on wl.bank_id = wb.bank_id
> > where wl.wire_id = (
> >  select max(right(wire_id,(len(wire_id)-2)))
> >  from wire_list)
> >
> > The error this code generates when I attempt to run it in SQL query
> > analyzer:
> > Server: Msg 536, Level 16, State 1, Line 1
> > Invalid length parameter passed to the substring function.
> >
> > The content of the wire_id column looks like this format:
> > ab999 and is of varchar datatype.
> >
> > I did not code these tables and I am in the middle of re-coding the
> > entire site to be FuseBox compliant.  I am trying to select the top
(max)
> > wire_id from the wire_list table, and display all records related
> > to the returned value of the max function, but the result that
> areretrieved
> > to date,
> > with the code "Select max(wire_id)" and no WHERE clause,
> > is ab99 when I know there are wire_id's in the table that have values
> > of ab999, etc.  It seems that SQL does not recognize that ab999 is the
> > larger value when compared to ab99.
> >
> > The solution I am trying to apply with the code at the top of this email
> is
> > to "get"
> > the "number" part of the wire_id column, minus the two letters, and then
> use
> > the max function on
> > the remainder to get the ab999 wire_id i know is in the table.  I looked
> > through the
> > SQL books online and it seems that SQL Sever does not have the ability
to
> > convert
> > the varchar datatype (of the wire_id) column to the int data type that
> > the max function seems to need in order to work properly.
> >
> > Does anyone know of a work around for this problem?  Or am I going
totally
> > in  the wrong
> > direction with this logic?
> >
> > Any help/ideas/comments would be greatly appreciated.  Thanks.
> >
> > Ryan Williams
> > [EMAIL PROTECTED]
> >
>
  -
> --
> > ---
> >  Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> >  To Unsubscribe visit
> > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
or
> > send a message to [EMAIL PROTECTED] with 'unsubscribe'
in
> > the body.
> >
> >
>
>

--

RE: Query a Query

[Chapman, Katrina]

There are three possible solutions to this that I can think of off the top
of my head.

1. Re-run the query every time prev/next is pressed passing through startrow
as a variable.

2. Create a temp table that stores the users search results and run your
second query every time prev/next is pressed passing through startrow as a
variable.

3. Make your query a varible a la mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 17, 2000 6:22 AM
To: [EMAIL PROTECTED]
Subject: RE: Query a Query


You are correct.

Jim Ray




-Original Message-
From: Chapman, Katrina [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 16, 2000 1:50 PM
To: [EMAIL PROTECTED]
Subject: RE: Query a Query


I assume you are trying to do a previous/next function.  Am I right?

--K

-Original Message-
From: Ray, James A [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 16, 2000 1:42 PM
To: [EMAIL PROTECTED]
Subject: RE: Query a Query


Here is some more background.  Here is what I need to do.

You are record number 1

1. Grab like Fields 1 & 2 (this would include records 1 thru 3)
2. Advance to the next record and display the information (should be record
2)

That's why I have the Query doing a =,=, >=, >, but it does work.  I have
looked at Bens books and haven't seen a query that meets my needes.  

Thanks again for the help.

Example data

Field 1 Field 2 Field 3 Field 4

1   ABCDABCD1234ABCD
2   ABCDABCD1234BCDE
3   ABCDABCD12345   DESF
4   ABCDE   ABCDE   ABCDABCD


Jim Ray

-Original Message-
From: Brad Roberts [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 16, 2000 8:32 AM
To: [EMAIL PROTECTED]
Subject: RE: Query a Query


I don't know exactly what you are trying to do, but would a subquery work?

If you've got the Web Application Construction Book by Ben Forta (or any sql
book), it will explain subqueries.

Hope this helps,

Brad

-Original Message-
From: Ray, James A [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 16, 2000 10:54 AM
To: [EMAIL PROTECTED]
Subject: Query a Query


This is a wierd question, but I need to ask it.

Is there a way to query the results of a query?  There is a really reason
whey I need to do this.

Example


SELECT  *
FROMDSTS.LLISTORAGE
WHERE (ENDITEMPN = '#FORM.ENDITEMPN#') AND (ENDITEMSN =
'#FORM.ENDITEMSN#')
ORDER BY  ENDITEMPN ASC,ENDITEMSN ASC


Next one


SELECT  *
FROMgetRecord
WHERE (LLIPN >= '#FORM.LLIPN#') AND (LLISN > '#FORM.LLISN#')
ORDER BY  LLIPN ASC,LLISN ASC



Thanks all

Jim Ray




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


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

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

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

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

RE: Query a Query

[Chapman, Katrina]

I assume you are trying to do a previous/next function.  Am I right?

--K

-Original Message-
From: Ray, James A [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 16, 2000 1:42 PM
To: [EMAIL PROTECTED]
Subject: RE: Query a Query


Here is some more background.  Here is what I need to do.

You are record number 1

1. Grab like Fields 1 & 2 (this would include records 1 thru 3)
2. Advance to the next record and display the information (should be record
2)

That's why I have the Query doing a =,=, >=, >, but it does work.  I have
looked at Bens books and haven't seen a query that meets my needes.  

Thanks again for the help.

Example data

Field 1 Field 2 Field 3 Field 4

1   ABCDABCD1234ABCD
2   ABCDABCD1234BCDE
3   ABCDABCD12345   DESF
4   ABCDE   ABCDE   ABCDABCD


Jim Ray

-Original Message-
From: Brad Roberts [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 16, 2000 8:32 AM
To: [EMAIL PROTECTED]
Subject: RE: Query a Query


I don't know exactly what you are trying to do, but would a subquery work?

If you've got the Web Application Construction Book by Ben Forta (or any sql
book), it will explain subqueries.

Hope this helps,

Brad

-Original Message-
From: Ray, James A [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 16, 2000 10:54 AM
To: [EMAIL PROTECTED]
Subject: Query a Query


This is a wierd question, but I need to ask it.

Is there a way to query the results of a query?  There is a really reason
whey I need to do this.

Example


SELECT  *
FROMDSTS.LLISTORAGE
WHERE (ENDITEMPN = '#FORM.ENDITEMPN#') AND (ENDITEMSN =
'#FORM.ENDITEMSN#')
ORDER BY  ENDITEMPN ASC,ENDITEMSN ASC


Next one


SELECT  *
FROMgetRecord
WHERE (LLIPN >= '#FORM.LLIPN#') AND (LLISN > '#FORM.LLISN#')
ORDER BY  LLIPN ASC,LLISN ASC



Thanks all

Jim Ray




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


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

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

RE: replace function

[Chapman, Katrina]

Look at cf_highlight in the tag gallery.  

--K

-Original Message-
From: Eli Shechter [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 16, 2000 11:08 AM
To: [EMAIL PROTECTED]
Subject: replace function


Hi

i am using the replace function with a search interface,

that when the results come out, if the search word is within the results, to
turn that word "red"

However,
it replaces the word with a Red version of the search_word
#ReplaceNoCase(Description, Search_Word, theReplacedWord , 'ALL')#

the problem with this is that it replaces the Case of the word with the case
of the Search_word, Meaning if i search "pens" it will replace a instance of
the word "Pens" (uppercase) with the search_word version.

is there a way to search for the word and just replace the color without
replacing the word??

Thanx
-Eli-


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

RE: Ben Forta's Quick Store Application

[Chapman, Katrina]

Sorry I can't help you there.   I haven't looked at that application.

--K

-Original Message-
From: Chad [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 16, 2000 9:52 AM
To: [EMAIL PROTECTED]
Subject: RE: Ben Forta's Quick Store Application


Actually i got Ben Fortas application working last week.  Brad was right, 
it is to restrictive.  But i was able to pick the code apart, and create my 
own shopping basket.

Im looking at the CF Store that is in the 
D:\Inetpub\wwwroot\CFDOCS\exampleapp\store  directory now.  I would like to 
examine this code and make sure the shopping basket i created is the best 
way to code it.  Where is the database for this application?  I just found 
this example, so im probably not reading something. :)

Thanks
Chad

At 09:40 AM 8/16/00 -0700, you wrote:
>Can we see the code and the exact error message?  Also have you tried
>putting the template not in the C:\CFUSION\CustomTags directory but in the
>directory that you're calling it from?
>
>--K
>
>-Original Message-
>From: Brad Roberts [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, August 16, 2000 8:53 AM
>To: [EMAIL PROTECTED]
>Subject: RE: Ben Forta's Quick Store Application
>
>
>Chad,
>
>You might learn a little from the code, but you may not want to use it in a
>real working application (if you're planning on it).  Use the sample store
>that came with CF along with your other resources and create your own store
>(if you've got time).  Yours will be a lot better than the Quick Store
>anyway.
>
>My $0.02,
>
>Brad
>
>-Original Message-
>From: Chad [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, August 01, 2000 9:16 AM
>To: [EMAIL PROTECTED]
>Subject: Ben Forta's Quick Store Application
>
>
>I can't get this program to work!  It is driving me nuts!  It is the Quick
>Store Application in Ben Forta's CF book.
>
>Exactly how am i suppose to setup the custom tags?  Because that must be
>what is wrong.  I am copying the entire CF file into the
>C:\CFUSION\CustomTags folder.
>
>When i goto load the store.cfm in my browser is just sits there and spins,
>then about a few minutes i get an cant connect error.
>
>Has anyone else tried using this code, and have they gotten it to work?
>
>Thanks
>Chad
>---
-
>--
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
>
>---
-
>--
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
>---
---
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>To Unsubscribe visit 
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or 
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in 
>the body.


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

RE: Ben Forta's Quick Store Application

[Chapman, Katrina]

Can we see the code and the exact error message?  Also have you tried
putting the template not in the C:\CFUSION\CustomTags directory but in the
directory that you're calling it from?

--K

-Original Message-
From: Brad Roberts [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 16, 2000 8:53 AM
To: [EMAIL PROTECTED]
Subject: RE: Ben Forta's Quick Store Application


Chad,

You might learn a little from the code, but you may not want to use it in a
real working application (if you're planning on it).  Use the sample store
that came with CF along with your other resources and create your own store
(if you've got time).  Yours will be a lot better than the Quick Store
anyway.

My $0.02,

Brad

-Original Message-
From: Chad [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 01, 2000 9:16 AM
To: [EMAIL PROTECTED]
Subject: Ben Forta's Quick Store Application


I can't get this program to work!  It is driving me nuts!  It is the Quick
Store Application in Ben Forta's CF book.

Exactly how am i suppose to setup the custom tags?  Because that must be
what is wrong.  I am copying the entire CF file into the
C:\CFUSION\CustomTags folder.

When i goto load the store.cfm in my browser is just sits there and spins,
then about a few minutes i get an cant connect error.

Has anyone else tried using this code, and have they gotten it to work?

Thanks
Chad

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


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

RE: Query a Query

[Chapman, Katrina]

Andy,

Why can't you combine where clauses when they reference two seperate tables?
I'm also curious as to why you think they reference two tables?

Jim, 

You can use the second query provided by Chad and it should work.

--K

-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 16, 2000 8:16 AM
To: '[EMAIL PROTECTED]'
Subject: RE: Query a Query


Can't combine the where clause as they are different tables.  You could do a
number of things:

1)  As Chad suggested you could have to CFQueries and deal with them
together in your template or
2)  If you don't want to deal with the result sets seperately you could
write a query/SP that deals with them before returning to your template

...it all depends what you want to do with it.

-Original Message-
From: Chad [mailto:[EMAIL PROTECTED]]
Sent: 16 August 2000 16:08
To: [EMAIL PROTECTED]
Subject: Re: Query a Query


Why cant you just query the database twice?  Then CFOUTPUT each query where 
you need it.  Or combine your WHERE from each query into one.

 
 SELECT  *
 FROMDSTS.LLISTORAGE
 WHERE (ENDITEMPN = '#FORM.ENDITEMPN#') AND (ENDITEMSN =
'#FORM.ENDITEMSN#')
 ORDER BY  ENDITEMPN ASC,ENDITEMSN ASC
 



 
 SELECT  *
 FROM   DSTS.LLISTORAGE
 WHERE (ENDITEMPN = '#FORM.ENDITEMPN#') AND (ENDITEMSN =
'#FORM.ENDITEMSN#') AND (LLIPN >= '#FORM.LLIPN#') AND (LLISN >
'#FORM.LLISN#')
 ORDER BY  LLIPN ASC,LLISN ASC
 



At 07:54 AM 8/16/00 -0700, you wrote:
>This is a wierd question, but I need to ask it.
>
>Is there a way to query the results of a query?  There is a really reason
>whey I need to do this.
>
>Example
>
> 
> SELECT  *
> FROMDSTS.LLISTORAGE
> WHERE (ENDITEMPN = '#FORM.ENDITEMPN#') AND (ENDITEMSN =
>'#FORM.ENDITEMSN#')
> ORDER BY  ENDITEMPN ASC,ENDITEMSN ASC
> 
>
>Next one
>
> 
> SELECT  *
> FROMgetRecord
> WHERE (LLIPN >= '#FORM.LLIPN#') AND (LLISN >
'#FORM.LLISN#')
> ORDER BY  LLIPN ASC,LLISN ASC
> 
>
>
>Thanks all
>
>Jim Ray
>
>
>
>---
---
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>To Unsubscribe visit 
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or 
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in 
>the body.


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

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

RE: session.basket URL

[Chapman, Katrina]

Well then can we see the offending code?  Both the posting page and the
processing pages please.

--K

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 14, 2000 3:57 PM
To: [EMAIL PROTECTED]
Subject: RE: session.basket URL


Well, there's no CFLOCATION.

best,  paul


At 03:07 PM 8/14/00 -0700, you wrote:
>Actually Paul it's when you don't specify "addtoken="no""
>
>If you just have
>
>
>
>you'll get the cfid and cftoken in the URL.
>
>If you
>
>
>
>You won't.
>
>--K
>
>-Original Message-
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
>Sent: Monday, August 14, 2000 2:10 PM
>To: [EMAIL PROTECTED]
>Subject: RE: session.basket URL
>
>
>Nope.
>
>I have "Accept all cookies" checked in NetScrape 4.51.
>
>best,  paul
>
>At 01:14 PM 8/14/00 -0700, you wrote:
>
> >When the client has cookies disabled.
> >
> > > -Original Message-
> > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> > > Sent: Monday, August 14, 2000 1:09 PM
> > > To: [EMAIL PROTECTED]
> > > Subject: RE: session.basket URL
> > >
> > >
> > > What causes appending when there's no CFLOCATION?
> > >
> > > best,  paul
> > >
> > > At 03:32 PM 8/14/00 -0400, you wrote:
> > > >Client variables with CFLOCATION behavior:
> > > >When using CFLOCATION to redirect to a path that contains
> > > .DBM or .CFM, the
> > > >Client.URLToken is automatically appended to the URL.
> > >
> > > --
> > > 
> > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > > To Unsubscribe visit
> > > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list
> >s/cf_talk or send a message to [EMAIL PROTECTED] with
> >'unsubscribe' in the body.
>
>---
>---
> >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> >To Unsubscribe visit
> >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
or
> >send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> >the body.
>
>---
-
>--
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
>---
---
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>To Unsubscribe visit 
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or 
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in 
>the body.


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

RE: Help with SQL

[Chapman, Katrina]

You use the SQL DatePart function

select DatePart(mm, columnname) as month
from foo


--K

-Original Message-
From: sebastian palmigiani [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 14, 2000 3:52 PM
To: [EMAIL PROTECTED]
Subject: Help with SQL



I have a date and time field in the form of 8/14/00 in an Access database. I
want to be able to select out the distinct months in all the fields. It
seems that I can't do that.

Do I have to redo the database and separate the month? Or do I have to
process the query with some kind of CF code?

Sebastian


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