Re: CF Novice

[kishore]

Hi Brian,

Try this URL.

http://www.allaire.com/documents/cf4/cfml_language_reference/contents.html -

I have downloaded this tutorial & is very fine. After downloading, just
notify me.

Regards
kishore

- Original Message -
From: <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 11, 2001 9:46 PM
Subject: CF Novice


> I have recently been learning ColdFusion through maintenance of websites
> that use ColdFusion. I have the basics down but really would like to
expand
> on my knowledge of ColdFusion. Do any of you, have a good recommendation
for
> book, study guide or tutorial web site?
>
> Thanks!
> Brian Hasselback
> [EMAIL PROTECTED]
> http://www.intent.net
> Web Hosting & Development
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

No Subject

[Lord Skulbite]

Could anyone tell me why I'm getting this error connecting to the mail 
server? It's happening all the time and I do not understand why.

"Error","TID=688","04/12/01","02:13:52","Error occurred while attempting to 
connect to mail server. - [PT_NOTCONNECTED] Attempt made to use a session 
that is not the PT_CONNECTED state (Send attempted with closed 
connection)  - Server = 'mail.cmfc.net'"
"Error","TID=688","04/12/01","02:13:52","Message not delivered due to error 
in establishing connection - Undelivered message file archived to 
'C:\CFUSION\MAIL\UNDELIVR\CFM46B.TMP'"

The CFMAIL tags as follows:



SELECT * FROM EmailList



#Form.Message#


Thanks.

Richard


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

RE: TOP function not performing

[David Shadovitz]

Let me add some notes on the TOP predicate as implemented in MS Access.

1. If you don't include an ORDER BY clause, a TOP N query will return an 
arbitrary set of N records that satisfy the WHERE clause.

2. You may get more than N rows from a TOP N query, since TOP does not choose 
between equal values.

-David

On Tuesday, April 10, 2001 3:41 PM, W Luke [SMTP:[EMAIL PROTECTED]] 
wrote:
>
> > Your ORDER BY field(s) should determine which records are returned; it
> your
> > example, you should be getting the 2 records with the highest end_date
> > value.
> >
> > If you order by ID, you'll get 2 records with the lowest (sorted
> ascending)
> > or highest (sorted descending) ID.
>
> So my code is correct then?
>
> I did see this mentioned a few weeks ago, but couldn't find it in the
> archives.
>
> > Is end_date in fact a date field?  Or is it perhaps text?
>
> Yes, it's a proper date field.
>
> Will

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

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

RE: Procedure and Function (Rambling thought)

[Javier Woodhouse]

I agree! I dont know what the big fuss is about... CF Tags are functions as
far as anyone should be concerned - just because they're not implemented in
exactly the same way VB, Java, etc implements functions means didley
squat... I'll be the first to admit that I'am sometimes frustrated by how CF
Tags are carried out but more often then not i thank god that they work as
they do, it makes life so much easier when your output is HTML.

As for objects - Anyone thinking of using a scripting language to create a
program that requires objects should be taken out and given a good talking
to. CF is great as the glue that holds together all the objects that we need
to create effective websites (DB connections, Email, Files, Forms, etc) but
by no means would i use CF to create something as complicated as a credit
card transaction gateway - Java is much more nicely designed to do this.

In short, i think CF has been brilliantly written to create websites
quickly, effectively and under budget - an equivilent website could take as
long as 3 times longer if written in C++ or Java... The right tool for the
right job - you dont complain when your drill doesnt perform well as a
hammer.

Regards,
Javier

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, April 12, 2001 2:29 PM
> To: CF-Talk
> Subject: RE: Procedure and Function (Rambling thought)
> 
> 
> Sorry, but my wandering mind's gotten the better of me and I've got a
> concept to throw out for those who might want to chew on an idea (no
> spitting, please... we just washed the floors).
> 
> From what I remember from my CS classes (my degree is in 
> Electronics, not
> CS) functions and procedures are devices that use either an 
> individual or
> multiple attributes to perform some computation.  In the case 
> of a function,
> at least one value is returned to the calling process.  
> Forgive me if I'm
> reaching a bit here, but doesn't that remind anyone else of a 
> custom tag or
> CFX tag?  A procedure doesn't return a value, but simply 
> performs an action
> or actions on attributes passed to it.  Taking a bigger 
> stretch, doesn't
> that sound a bit like an include?
> 
> Now I know, this is getting abstract, but it seems to my 
> thought process
> that Allair actually did provide us with a mechanism for 
> performing external
> functions that can be used repetively across a wide array of 
> applications
> and scopes.  So to throw a kink into the wheel, yes, Cold 
> Fusion does have
> functions.  We simply call them something different: Custom Tags.
> 
> As for implementing Object Oriented programming concepts, 
> that may be a bit
> outside the bounds of what can be done.  In all honesty, 
> that's okay.  I
> personally hated OOP... especially when I had a PhD that was 
> more interested
> in researching multiprocessor programming concepts than 
> teaching, but I
> digress.
> 
> Sorry for the rant and the ramble... 19 days nicotine free, 
> living with
> in-laws and looking at buying my first house.  All this and I 
> haven't had a
> drop of alcohol (yet)!
> 
> Enjoy!
> C. Hatton Humphrey
> Cold Fusion Developer
> Fisher, Towne & Associates
> http://www.fishertowne.com
> [EMAIL PROTECTED]
> 
> -Original Message-
> Hi Haryono,
> 
> if you refer to your previous posts on this issue, and other peoples
> subsequent replies ...
> I'm sure you will notice that CF isn't OOP and we do not make any
> Your post :
> http://www.mail-archive.com/cf-talk@houseoffusion.com/msg49020.html
> My reply :
> http://www.mail-archive.com/cf-talk@houseoffusion.com/msg49023.html
> Please take notice of answers when you post a question.
> 
> > Hallo,
> > How can i use procedure and function in ColdFusion?
> > Is this possible to use OOP in ColdFusion?
> 
> 
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Procedure and Function (Rambling thought)

[Jared Clinton]

Another rambling thought follows:

Haryono my apologies, your question wasn't exactly the same as the original
one.

You can USE procedures and functions THROUGH any of the extensability that
CF offers,

CORBA
COM
Java
C++
Delphi

Although cf has no concept of a 'procedure' or 'function'. 

It does have an equivalent, 'tags', it is a tag based scripting language,
making it easy for people to not think to hard about things if they dont
want to. 

Jared Clinton.
(I've got tooo many 2cents!)


> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, 12 April 2001 14:29
> To: CF-Talk
> Subject: RE: Procedure and Function (Rambling thought)
> 
> 
> Sorry, but my wandering mind's gotten the better of me and I've got a
> concept to throw out for those who might want to chew on an idea (no
> spitting, please... we just washed the floors).
> 
> From what I remember from my CS classes (my degree is in 
> Electronics, not
> CS) functions and procedures are devices that use either an 
> individual or
> multiple attributes to perform some computation.  In the case 
> of a function,
> at least one value is returned to the calling process.  
> Forgive me if I'm
> reaching a bit here, but doesn't that remind anyone else of a 
> custom tag or
> CFX tag?  A procedure doesn't return a value, but simply 
> performs an action
> or actions on attributes passed to it.  Taking a bigger 
> stretch, doesn't
> that sound a bit like an include?
> 
> Now I know, this is getting abstract, but it seems to my 
> thought process
> that Allair actually did provide us with a mechanism for 
> performing external
> functions that can be used repetively across a wide array of 
> applications
> and scopes.  So to throw a kink into the wheel, yes, Cold 
> Fusion does have
> functions.  We simply call them something different: Custom Tags.
> 
> As for implementing Object Oriented programming concepts, 
> that may be a bit
> outside the bounds of what can be done.  In all honesty, 
> that's okay.  I
> personally hated OOP... especially when I had a PhD that was 
> more interested
> in researching multiprocessor programming concepts than 
> teaching, but I
> digress.
> 
> Sorry for the rant and the ramble... 19 days nicotine free, 
> living with
> in-laws and looking at buying my first house.  All this and I 
> haven't had a
> drop of alcohol (yet)!
> 
> Enjoy!
> C. Hatton Humphrey
> Cold Fusion Developer
> Fisher, Towne & Associates
> http://www.fishertowne.com
> [EMAIL PROTECTED]
> 
> -Original Message-
> Hi Haryono,
> 
> if you refer to your previous posts on this issue, and other peoples
> subsequent replies ...
> I'm sure you will notice that CF isn't OOP and we do not make any
> Your post :
> http://www.mail-archive.com/cf-talk@houseoffusion.com/msg49020.html
> My reply :
> http://www.mail-archive.com/cf-talk@houseoffusion.com/msg49023.html
> Please take notice of answers when you post a question.
> 
> > Hallo,
> > How can i use procedure and function in ColdFusion?
> > Is this possible to use OOP in ColdFusion?
> 
> 
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Procedure and Function (Rambling thought)

[C. Hatton Humphrey]

Sorry, but my wandering mind's gotten the better of me and I've got a
concept to throw out for those who might want to chew on an idea (no
spitting, please... we just washed the floors).

>From what I remember from my CS classes (my degree is in Electronics, not
CS) functions and procedures are devices that use either an individual or
multiple attributes to perform some computation.  In the case of a function,
at least one value is returned to the calling process.  Forgive me if I'm
reaching a bit here, but doesn't that remind anyone else of a custom tag or
CFX tag?  A procedure doesn't return a value, but simply performs an action
or actions on attributes passed to it.  Taking a bigger stretch, doesn't
that sound a bit like an include?

Now I know, this is getting abstract, but it seems to my thought process
that Allair actually did provide us with a mechanism for performing external
functions that can be used repetively across a wide array of applications
and scopes.  So to throw a kink into the wheel, yes, Cold Fusion does have
functions.  We simply call them something different: Custom Tags.

As for implementing Object Oriented programming concepts, that may be a bit
outside the bounds of what can be done.  In all honesty, that's okay.  I
personally hated OOP... especially when I had a PhD that was more interested
in researching multiprocessor programming concepts than teaching, but I
digress.

Sorry for the rant and the ramble... 19 days nicotine free, living with
in-laws and looking at buying my first house.  All this and I haven't had a
drop of alcohol (yet)!

Enjoy!
C. Hatton Humphrey
Cold Fusion Developer
Fisher, Towne & Associates
http://www.fishertowne.com
[EMAIL PROTECTED]

-Original Message-
Hi Haryono,

if you refer to your previous posts on this issue, and other peoples
subsequent replies ...
I'm sure you will notice that CF isn't OOP and we do not make any
Your post :
http://www.mail-archive.com/cf-talk@houseoffusion.com/msg49020.html
My reply :
http://www.mail-archive.com/cf-talk@houseoffusion.com/msg49023.html
Please take notice of answers when you post a question.

> Hallo,
> How can i use procedure and function in ColdFusion?
> Is this possible to use OOP in ColdFusion?


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

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

Link to download .jpg or gif

[scottw]

I am looking for a solution to a downloading problem i am having with a
link.  I am thumbnailing images, and am wanting to have a "download" link
next to the thumbnail that will automatically open up the 'save to' window.
Obvioulsy if i just link directly to the .jpg file, the download window will
not pop up, and it just redirects me to a blank page in my default browser
and shows the full size image.  Any suggestions??

Thanks,

Scott


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

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

Re: when is CF5 release? (a little OT)

[Xing Li]

Allaire claims that the latest CF builds are dramatically faster and
especially on linux. I have not done any formal tests so I can't say it is
true or not. But I can safely say that CF is now finally on a bit of diet.
Memory usage has been down significantly across the board on 24/7 servers
pumping out loads of pages...

I would personally invest in CF 5.0's features based on how stable the betas
have been.

xing

- Original Message -
From: "Todd Ashworth" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 11, 2001 7:12 PM
Subject: Re: when is CF5 release? (a little OT)


> OK .. as a diversion from the current topic, is anyone developing stuff
for
> CF 5 based on what they have seen so far?  We are building an app that
could
> benifit from some of CF 5's features. We would like to 'build for' CF 5 if
> it will be released within the next 3 months.  Otherwise, we will have to
> make do with 4.5 and worry about a later version release, well, later. :)
>
> Todd Ashworth
> Certified ColdFusion Developer
> Network Administrator
>
> Saber Corporation
> 314 Oakland Ave.
> Rock Hill, SC 29730
> (803) 327-0137 [111] (p)
> (803) 328-2868 (f)
>
> - Original Message -
> From: "Peter Tilbrook" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, April 11, 2001 9:44 PM
> Subject: RE: when is CF5 release?
>
>
> > >>It's still in beta (version 3.0 at last check).
> >
> > Allaire usually release a couple of "Release Candidates" before shipping
> > final code so it will probably be a few months yet.
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: CF Website

[Parker, Kevin]

Thanks Peter - I remember the site and had a look at it. Naturally its a fee
for service facility (which I don't have a problem with of course) and you
can do a tour to have a play and look. I was looking for something to run
myself.




Kevin Parker
Web Services Manager
WorkCover Corporation

[EMAIL PROTECTED]

www.workcover.com

p: +61 8 82332548
f: +61 8 82332000
m: 0418 800 287




-Original Message-
From: Peter Tilbrook [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 12 April 2001 11:33:AM
To: CF-Talk
Subject: RE: CF Website


I remember someone posting a message in this group about such a site -
onlinewebsitecreator.com. or something.

Can't find it now - try a web search for it or try searching the
www.cfextras.com archive of this group.

-Original Message-
From: Parker, Kevin [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 12 April 2001 10:55
To: CF-Talk
Subject: CF Website



Does anyone now of any CF based systems/products that create a website
purely and entirely from a backend e.g. www.phpnuke.org



Kevin Parker
Web Services Manager
WorkCover Corporation

[EMAIL PROTECTED]

www.workcover.com

p: +61 8 82332548
f: +61 8 82332000
m: 0418 800 287






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.

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

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

Re: when is CF5 release? (a little OT)

[Todd Ashworth]

OK .. as a diversion from the current topic, is anyone developing stuff for
CF 5 based on what they have seen so far?  We are building an app that could
benifit from some of CF 5's features. We would like to 'build for' CF 5 if
it will be released within the next 3 months.  Otherwise, we will have to
make do with 4.5 and worry about a later version release, well, later. :)

Todd Ashworth
Certified ColdFusion Developer
Network Administrator

Saber Corporation
314 Oakland Ave.
Rock Hill, SC 29730
(803) 327-0137 [111] (p)
(803) 328-2868 (f)

- Original Message -
From: "Peter Tilbrook" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 11, 2001 9:44 PM
Subject: RE: when is CF5 release?


> >>It's still in beta (version 3.0 at last check).
>
> Allaire usually release a couple of "Release Candidates" before shipping
> final code so it will probably be a few months yet.



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

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

RE: CF Website

[Peter Tilbrook]

I remember someone posting a message in this group about such a site -
onlinewebsitecreator.com. or something.

Can't find it now - try a web search for it or try searching the
www.cfextras.com archive of this group.

-Original Message-
From: Parker, Kevin [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 12 April 2001 10:55
To: CF-Talk
Subject: CF Website



Does anyone now of any CF based systems/products that create a website
purely and entirely from a backend e.g. www.phpnuke.org



Kevin Parker
Web Services Manager
WorkCover Corporation

[EMAIL PROTECTED]

www.workcover.com

p: +61 8 82332548
f: +61 8 82332000
m: 0418 800 287






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.

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

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

Re: Studio 4.5.2

[Tariq Ahmed]

I think Studio 4.0 is much better then 4.5.x. The online help has
LESS information.

On Wed, 11 Apr 2001, sebastian palmigiani wrote:

> 
> I upgraded to CF Studio 4.5.2 with Win98. It kept repeatedly crashing my
> system. I had to go back to Studio 4.0.
> 
> Is this just an issue with Win98 or would it be the same story with Win2000?
> 
> I am disspointed in this 'improvement.'
> 
> Sebastian
> 
> 
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Viewing PDFs

[Adrian Cesana]

I just went thru the same thing, I had to change my CFLOCATION's to a meta
redirect.

-Adrian

-Original Message-
From: Bruce Holm [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 11, 2001 6:27 PM
To: CF-Talk
Subject: Viewing PDFs


I'm new to this list so if this has been beat to death already, please
forgive...

For viewing a .pdf file, we store the URL in a db table.  When someone
clicks on the document url to view the file, it hits the db table, retrieves
the PDF's real URL and then CFLOCATIONs to that path.  It works most of the
time but for some strange reason, on IE5.0 it's flakey.  Sometimes it just
launches Acrobat Reader (of the full version) and just displays an empty
Acrobat Reader window.

It obviously recognizes that it is a PDF but not sure why the content is not
displayed.  It also typically fails to display after the following sequence
pretty consistently...

Click on PDF link to view doc
Read Db table to get access permission and URL to PDF
Permission requires user login...display login page
Login successful...cflocate to the URL
Acrobat launches (if not already) but displays empty contents in window

If I now go back around (view the list of PDFs, click on the same one, no
login required this time because I'm already logged in, cflocate to the PDF)
it works fine this time.
But if I log out, then go through the above sequence, it fails every
time...only on IE5.0.  IE5.5 works.  Netscape 4.7 works.

Any ideas on this one

-
Bruce Holm - Web Programmer
Lattice Semiconductor Corp.
[EMAIL PROTECTED]
-
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: when is CF5 release?

[Peter Tilbrook]

>>It's still in beta (version 3.0 at last check).

Allaire usually release a couple of "Release Candidates" before shipping
final code so it will probably be a few months yet.



when is version 5.0 to be released?

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

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

RE: Studio 4.5.2

[Peter Tilbrook]

I always found 4.5.2 to be very good on Win98 (especially compared to 4.5
and 4.5a with their zero byte file saving).

Admittedly I am back to 4.0 at the moment but not because 4.5.2 wasn't good.

-Original Message-
From: sebastian palmigiani [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 12 April 2001 03:00
To: CF-Talk
Subject: Studio 4.5.2



I upgraded to CF Studio 4.5.2 with Win98. It kept repeatedly crashing my
system. I had to go back to Studio 4.0.

Is this just an issue with Win98 or would it be the same story with Win2000?

I am disspointed in this 'improvement.'

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

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

Re: CF Website

[David Hannum]

Spectra IS ColdFusion - it's and application written in CF.  It's a tool
that allows for content management, personalization, profiling, ecommerce,
syndication and more.  If you know CF, you can know Spectra.

Dave


- Original Message -
From: Javier Woodhouse <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Wednesday, April 11, 2001 9:17 PM
Subject: RE: CF Website


> Just a quick question on spectra - how hard is it to pick up if you have
> farily strong CF skills?
>
> > -Original Message-
> > From: David Hannum [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, April 12, 2001 11:18 AM
> > To: CF-Talk
> > Subject: Re: CF Website
> >
> >
> > Spectra (but it ain't FREE)
> >
> > Dave
> >
> >
> > - Original Message -
> > From: Parker, Kevin <[EMAIL PROTECTED]>
> > To: CF-Talk <[EMAIL PROTECTED]>
> > Sent: Wednesday, April 11, 2001 8:55 PM
> > Subject: CF Website
> >
> >
> > >
> > > Does anyone now of any CF based systems/products that
> > create a website
> > > purely and entirely from a backend e.g. www.phpnuke.org
> > >
> > > 
> > >
> > > Kevin Parker
> > > Web Services Manager
> > > WorkCover Corporation
> > >
> > > [EMAIL PROTECTED]
> > >
> > > www.workcover.com
> > >
> > > p: +61 8 82332548
> > > f: +61 8 82332000
> > > m: 0418 800 287
> > >
> > >
> > >
> > >
> > >
> > >
> > **
> > **
> > > 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.
> > >
> > **
> > **
> > >
> > >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: She's got HUGE...... Recordsets

[Michael Caulfield]

>So what is an easy, intuitive way for the client to manage these large
>recordsets and perform updates/deletes?

For the average user, the answer usually is a drill-down interface with
intuitive groupings. At least that's been my experience.

Michael Caulfield


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

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

Re: SQL Query Headache...

[Steve Reich]

> Try to use PreserveSingleQuotes function:
> 
> .
> WHERE messages.parent = 0 AND messages.active = 1
> #PreserveSingleQuotes(KeyWords)#
> .
> 
> Marian


That was it! Thank you very much! 

Steve

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

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

Viewing PDFs

[Bruce Holm]

I'm new to this list so if this has been beat to death already, please forgive...

For viewing a .pdf file, we store the URL in a db table.  When someone clicks on the 
document url to view the file, it hits the db table, retrieves the PDF's real URL and 
then CFLOCATIONs to that path.  It works most of the time but for some strange reason, 
on IE5.0 it's flakey.  Sometimes it just launches Acrobat Reader (of the full version) 
and just displays an empty Acrobat Reader window.

It obviously recognizes that it is a PDF but not sure why the content is not 
displayed.  It also typically fails to display after the following sequence pretty 
consistently...

Click on PDF link to view doc
Read Db table to get access permission and URL to PDF
Permission requires user login...display login page
Login successful...cflocate to the URL
Acrobat launches (if not already) but displays empty contents in window

If I now go back around (view the list of PDFs, click on the same one, no login 
required this time because I'm already logged in, cflocate to the PDF) it works fine 
this time.
But if I log out, then go through the above sequence, it fails every time...only on 
IE5.0.  IE5.5 works.  Netscape 4.7 works.

Any ideas on this one

-
Bruce Holm - Web Programmer
Lattice Semiconductor Corp.
[EMAIL PROTECTED]
-



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

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

RE: CF Website

[Javier Woodhouse]

Just a quick question on spectra - how hard is it to pick up if you have
farily strong CF skills?

> -Original Message-
> From: David Hannum [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, April 12, 2001 11:18 AM
> To: CF-Talk
> Subject: Re: CF Website
> 
> 
> Spectra (but it ain't FREE)
> 
> Dave
> 
> 
> - Original Message -
> From: Parker, Kevin <[EMAIL PROTECTED]>
> To: CF-Talk <[EMAIL PROTECTED]>
> Sent: Wednesday, April 11, 2001 8:55 PM
> Subject: CF Website
> 
> 
> >
> > Does anyone now of any CF based systems/products that 
> create a website
> > purely and entirely from a backend e.g. www.phpnuke.org
> >
> > 
> >
> > Kevin Parker
> > Web Services Manager
> > WorkCover Corporation
> >
> > [EMAIL PROTECTED]
> >
> > www.workcover.com
> >
> > p: +61 8 82332548
> > f: +61 8 82332000
> > m: 0418 800 287
> >
> >
> >
> >
> >
> >
> **
> **
> > 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.
> >
> **
> **
> >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Procedure and Function

[Jared Clinton]

Hi Haryono,

if you refer to your previous posts on this issue, and other peoples
subsequent replies ...

I'm sure you will notice that CF isn't OOP and we do not make any 

Your post :
http://www.mail-archive.com/cf-talk@houseoffusion.com/msg49020.html

My reply :
http://www.mail-archive.com/cf-talk@houseoffusion.com/msg49023.html


Please take notice of answers when you post a question.

Thank you, 
Jared Clinton,
Maxi Multimedia.

> -Original Message-
> From: Haryono ... [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, 12 April 2001 10:28
> To: CF-Talk
> Subject: Procedure and Function
> 
> 
> Hallo,
> How can i use procedure and function in ColdFusion?
> Is this possible to use OOP in ColdFusion?
> 
> Thank You!!
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: CF Website

[David Hannum]

Spectra (but it ain't FREE)

Dave


- Original Message -
From: Parker, Kevin <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Wednesday, April 11, 2001 8:55 PM
Subject: CF Website


>
> Does anyone now of any CF based systems/products that create a website
> purely and entirely from a backend e.g. www.phpnuke.org
>
> 
>
> Kevin Parker
> Web Services Manager
> WorkCover Corporation
>
> [EMAIL PROTECTED]
>
> www.workcover.com
>
> p: +61 8 82332548
> f: +61 8 82332000
> m: 0418 800 287
>
>
>
>
>
>

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

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

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

CF Website

[Parker, Kevin]

Does anyone now of any CF based systems/products that create a website
purely and entirely from a backend e.g. www.phpnuke.org



Kevin Parker
Web Services Manager
WorkCover Corporation

[EMAIL PROTECTED]

www.workcover.com

p: +61 8 82332548
f: +61 8 82332000
m: 0418 800 287






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.


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

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

RE: SQL Query Headache...

[Marian Dumitrascu]

Try to use PreserveSingleQuotes function:

.
WHERE messages.parent = 0 AND messages.active = 1
#PreserveSingleQuotes(KeyWords)#
.

Marian



> -Original Message-
> From: Steve Reich [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 11, 2001 8:27 PM
> To: CF-Talk
> Subject: SQL Query Headache...
> 
> 
> This works...
> 
> 
> SELECT messages.messageid, messages.title AS mesTitle,
> messages.userid, messages.body, messages.datestamp,
> users.userid, users.fname, users.lname, users.company,
> users.copyReplies
> FROM messages JOIN
> users ON (users.userid = messages.userid)
> WHERE messages.parent = 0 AND messages.active = 1
> AND messages.body LIKE '%roar%' OR messages.body LIKE '%boby%'
> ORDER BY messages.datestamp desc
> 
> 
> 
> This doesn't... (Return error: [Microsoft][ODBC SQL Server Driver][SQL
> Server]Invalid column name 'roar'.) I don't understand why it is seeing
> 'roar' as a db column
> 
> 
> 
> SELECT messages.messageid, messages.title AS mesTitle,
> messages.userid, messages.body, messages.datestamp,
> users.userid, users.fname, users.lname, users.company,
> users.copyReplies
> FROM messages JOIN
> users ON (users.userid = messages.userid)
> WHERE messages.parent = 0 AND messages.active = 1
> #KeyWords#
> ORDER BY messages.datestamp desc
> 
> 
> 
> What am I missing here?
> 
> 
> 
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

cfmail w/ attachments effect on cfserver memory usage

[Ian MacFadyen]

While sending multiple cfmail messages with attachments I have realized
cfserver memory allocation problems. Has anybody else?

WinNT CF Application Server 4.5 acquires large volumes of RAM each time when
sending large volumes of cfmails(near 1000 email messages per time, using
the query attribute - each having an attachment ranging in size from 30K to
300K).

I understand that if CF needs more memory resources the service will claim
that what it needs. According to the heaping protocol, it will not release
the additionally acquired RAM, since the benefit of keeping the memory
in-hand far out weighs the costs of releasing and re-acquiring it; assuming
that more than likely it will be needed in the near future.

I suppose this is reasonable, but why once the cfmails are sent is the
memory not accounted for as available for use? Upon subsequent cfmailings
with attachments, more memory is heaped in addition to that previously
acquired. It seems inevitable that, with every batch of cfmails with
attachments, this will happen again, end-on-end until the server runs out of
available memory and crashes.

I hypothesize that something is wrong here. Any other encounters of this
kind out there? Is the cfmail spooler module flawed when it comes to
attachments? Can you offer any alternatives and/or sugestions?

Thanks,

Ian MacFadyen
Sr. Application Developer
Cardinal Communications
www.cardinalweb.com
[EMAIL PROTECTED]






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

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

SQL Query Headache...

[Steve Reich]

This works...


SELECT messages.messageid, messages.title AS mesTitle,
messages.userid, messages.body, messages.datestamp,
users.userid, users.fname, users.lname, users.company,
users.copyReplies
FROM messages JOIN
users ON (users.userid = messages.userid)
WHERE messages.parent = 0 AND messages.active = 1
AND messages.body LIKE '%roar%' OR messages.body LIKE '%boby%'
ORDER BY messages.datestamp desc



This doesn't... (Return error: [Microsoft][ODBC SQL Server Driver][SQL
Server]Invalid column name 'roar'.) I don't understand why it is seeing
'roar' as a db column



SELECT messages.messageid, messages.title AS mesTitle,
messages.userid, messages.body, messages.datestamp,
users.userid, users.fname, users.lname, users.company,
users.copyReplies
FROM messages JOIN
users ON (users.userid = messages.userid)
WHERE messages.parent = 0 AND messages.active = 1
#KeyWords#
ORDER BY messages.datestamp desc



What am I missing here?



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

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

Procedure and Function

[Haryono ...]

Hallo,
How can i use procedure and function in ColdFusion?
Is this possible to use OOP in ColdFusion?

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

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

Re: What and why are these errors happening?

[Todd Ashworth]

Naa .. the quotes don't matter :)  Being forced to use one type of quotes
over another would cause problems in many situations.  For example:



could cause problems, but



would be fine :)

Todd Ashworth
Certified ColdFusion Developer
Network Administrator

Saber Corporation
314 Oakland Ave.
Rock Hill, SC 29730
(803) 327-0137 [111] (p)
(803) 328-2868 (f)

- Original Message -
From: "Peter J. MacDonald" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 11, 2001 7:42 PM
Subject: RE: What and why are these errors happening?


> Bud,
>
> I think the single quotes need to be double quotes.
>
>  changed to
>
> 
>
> Thank You,
> Peter
>
> Peter J. MacDonald II
> Creative Computing, Inc.
> 100 Middle Street
> Lincoln, RI 02865
> Phone: 401.727.0183 x123
> Fax: 401.727.4998
> Portable: 401.965.3661
> E-MAIL: [EMAIL PROTECTED]
> Web Page: www.creatcomp.com
>
>
>
> -Original Message-
> From: Bud [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 11, 2001 6:10 PM
> To: CF-Talk
> Subject: What and why are these errors happening?
>
>
> I get this error in my application.log file. All on the same site:
>
> "Error resolving parameter SESSION.ID The session variable ID does not
> exist.
>
> In my application.cfm I have:
>
> 
>
> So how can that happen? CFAS doesn't show a restart at the time of the
> errors.
>
> Also. What is this and how do I fix it? :-D
>
> "Error","TID=140","04/11/01","17:25:37","Unable to write reply --
> timed out writing data back to web server."
> "Error","TID=140","04/11/01","17:25:37","Windows NT error number 1460
> occurred."
>
> Thanks!
> --
>
> Bud Schneehagen - Tropical Web Creations
>
> _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
> ColdFusion Solutions / eCommerce Development
> [EMAIL PROTECTED]
> http://www.twcreations.com/
> 954.721.3452
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: She's got HUGE...... Recordsets

[Dick Applebaum]

You could download 1000 or 5000 records to the browser... but then 
someone has to go through them... no one will...  As someone said 
(Jeffery) it's just a big pile of records on the floor.

You need to instill a little discipline (with the users) and a 
implement good search/drill-down so that the users can quickly locate 
a subset of records that they can browse through (next prev)

Sites that barf [specifically chosen term] thousands of records in 
response to a query are an insult to the user and an affront to the 
web (total waste of bandwidth) IMO.

If you want to see one way to do it, email me off line.

Dick... pissed, but still smiling!

At 6:18 PM -0500 4/11/01, Craig Bowes wrote:
>I wanted to get everyoneís input on this as Iím sure this is a pretty common
>scenario.  I have plenty of clients that have e-commerce sites or intranet
>sites that need to pull large recordsets.  For Example, they might need to
>view their inventory so they can edit or delete one record.  The problem is,
>once the inventory gets to 1000 or 5000 records or more, downloading this as
>one big list is unrealistic.  I have done the whole NEXT--> 10 records or
>whatever (which I hate), and I could also do a search so they can search by
>product name or ID.  But is there a better way to pull this kind of data and
>how do you manage the updates/inserts?  Could you use a java/wddx thing to
>download the recordset once and then browse it on the client side (I think
>Ben Fortaís Advanced CF Construction Kit has something like this) and Iíve
>also seen an ActiveX/VBScript version of this.
>
>So what is an easy, intuitive way for the client to manage these large
>recordsets and perform updates/deletes?
>
>Please reply to [EMAIL PROTECTED]  .  Any code or
>examples would be appreciated.
>
>Thanks,
>-Craig
>

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

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

Re[2]: Email software

[Kym Kovan]

Hi YC,

>  Thank you for those suggestion, actually, we are looking for an email
>  server software whcih will support mutilple domain and List Server

In that case I would go for iMS, from coolfusion, as that can do anything 
you want, just write the code yourself for anything it doesn't do out of 
the box as it uses CF for its intelligence :-)

We have been using it here for all sorts of things for over a year, with 
little hassle.


--

Yours,

Kym


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

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

RE: She's got HUGE...... Recordsets

[Welham Jason]

Just off the top of my head.

If you are running a specific query to do this I would set up a scheduled
task to run the query and then cache it 

-Original Message-
From: Craig Bowes [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 12 April 2001 11:18 AM
To: CF-Talk
Subject: She's got HUGE.. Recordsets


I wanted to get everyone's input on this as I'm sure this is a pretty common
scenario.  I have plenty of clients that have e-commerce sites or intranet
sites that need to pull large recordsets.  For Example, they might need to
view their inventory so they can edit or delete one record.  The problem is,
once the inventory gets to 1000 or 5000 records or more, downloading this as
one big list is unrealistic.  I have done the whole NEXT--> 10 records or
whatever (which I hate), and I could also do a search so they can search by
product name or ID.  But is there a better way to pull this kind of data and
how do you manage the updates/inserts?  Could you use a java/wddx thing to
download the recordset once and then browse it on the client side (I think
Ben Forta's Advanced CF Construction Kit has something like this) and I've
also seen an ActiveX/VBScript version of this.

So what is an easy, intuitive way for the client to manage these large
recordsets and perform updates/deletes?

Please reply to [EMAIL PROTECTED]  .  Any code or
examples would be appreciated.

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

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

RE: What and why are these errors happening?

[Peter J. MacDonald]

Bud,

I think the single quotes need to be double quotes.

 changed to



Thank You,
Peter

Peter J. MacDonald II
Creative Computing, Inc.
100 Middle Street
Lincoln, RI 02865
Phone: 401.727.0183 x123
Fax: 401.727.4998
Portable: 401.965.3661
E-MAIL: [EMAIL PROTECTED]
Web Page: www.creatcomp.com



-Original Message-
From: Bud [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 11, 2001 6:10 PM
To: CF-Talk
Subject: What and why are these errors happening?


I get this error in my application.log file. All on the same site:

"Error resolving parameter SESSION.ID The session variable ID does not
exist.

In my application.cfm I have:



So how can that happen? CFAS doesn't show a restart at the time of the
errors.

Also. What is this and how do I fix it? :-D

"Error","TID=140","04/11/01","17:25:37","Unable to write reply -- 
timed out writing data back to web server."
"Error","TID=140","04/11/01","17:25:37","Windows NT error number 1460 
occurred."

Thanks!
-- 

Bud Schneehagen - Tropical Web Creations

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: She's got HUGE...... Recordsets

[Jeffry Houser]

   I there a way to break it up the list?  Some form of categories, perhaps?

   For instance, if a bookstore just put books in one big pile on the 
floor, they would never sell anything because they wouldn't be able to find 
it.  Typically they are categorized (Fiction, non-fiction at the most basic 
level, then other categories.. fiction is general fiction, mystery sci-fi.. 
non-fiction is health, self-help.., then by author's last name underneath 
that).

   Other businesses have similar forms of categorization.  Just an idea.  I 
imagine that if the client has that much inventory it must already be 
categorized in some way.


At 06:18 PM 04/11/2001 -0500, you wrote:
>I wanted to get everyones input on this as Im sure this is a pretty common
>scenario.  I have plenty of clients that have e-commerce sites or intranet
>sites that need to pull large recordsets.  For Example, they might need to
>view their inventory so they can edit or delete one record.  The problem is,
>once the inventory gets to 1000 or 5000 records or more, downloading this as
>one big list is unrealistic.  I have done the whole NEXT--> 10 records or
>whatever (which I hate), and I could also do a search so they can search by
>product name or ID.  But is there a better way to pull this kind of data and
>how do you manage the updates/inserts?  Could you use a java/wddx thing to
>download the recordset once and then browse it on the client side (I think
>Ben Fortas Advanced CF Construction Kit has something like this) and Ive
>also seen an ActiveX/VBScript version of this.
>
>So what is an easy, intuitive way for the client to manage these large
>recordsets and perform updates/deletes?
>
>Please reply to [EMAIL PROTECTED]  .  Any code or
>examples would be appreciated.
>
>Thanks,
>-Craig
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

She's got HUGE...... Recordsets

[Craig Bowes]

I wanted to get everyone’s input on this as I’m sure this is a pretty common
scenario.  I have plenty of clients that have e-commerce sites or intranet
sites that need to pull large recordsets.  For Example, they might need to
view their inventory so they can edit or delete one record.  The problem is,
once the inventory gets to 1000 or 5000 records or more, downloading this as
one big list is unrealistic.  I have done the whole NEXT--> 10 records or
whatever (which I hate), and I could also do a search so they can search by
product name or ID.  But is there a better way to pull this kind of data and
how do you manage the updates/inserts?  Could you use a java/wddx thing to
download the recordset once and then browse it on the client side (I think
Ben Forta’s Advanced CF Construction Kit has something like this) and I’ve
also seen an ActiveX/VBScript version of this.

So what is an easy, intuitive way for the client to manage these large
recordsets and perform updates/deletes?

Please reply to [EMAIL PROTECTED]  .  Any code or
examples would be appreciated.

Thanks,
-Craig


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

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

RE: multiple select

[Jones, Becky]

thank you so much.  that worked great.


-Original Message-
From: Garza, Jeff [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 11, 2001 5:49 PM
To: CF-Talk
Subject: RE: multiple select


It would be passed as a comma separated list

e.g., form.assignedEmps = "23,45,123,533,2"

So,



INSERT INTO yourtable (ProductID, EmpID)
VALUES (#form.ProductID#, #i#)



Assuming that you want a different row for each employeeid...

HTH,

Jeff Garza
Web Developer/Webmaster
Spectrum Astro, Inc.
480.892.8200

[EMAIL PROTECTED]
http://www.spectrumastro.com



-Original Message-
From: Jones, Becky [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, April 11, 2001 1:45 PM
To: CF-Talk
Subject: multiple select


how would the insert statement look if i had a select box that allowed the
user to select multiple people to assign to a product?  it would be the same
product id each time...just different empid's.  


*
This e-mail, including any attachments, is intended for the 
receipt and use by the intended addressee(s), and may contain 
confidential and privileged information.  If you are not an intended 
recipient of this e-mail, you are hereby notified that any unauthorized 
use or distribution of this e-mail is strictly prohibited.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: What and why are these errors happening?

[ron]

> "Error resolving parameter SESSION.ID The session variable ID 
> does not exist.
> 
> In my application.cfm I have:
> 
> 
> 
> So how can that happen? 

Not sure, but I'd use  instead.

-ron

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

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

RE: CFSELECT - SOLUTION

[Erika L Walker]

Right after I posted this, I got the solution.so thank you, never mind,
and sorry for the extra post..and here is the code for the curious:

SELECT SPRFNBR, (SPFNAME + ' ' + SPLNAME) as FullName from SPEAKERS



Works Great!



Erika

"Age is in the mind of the beholder." - Unknown

-Original Message-
From: Erika L Walker [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 11, 2001 5:41 PM
To: CF-Talk
Subject: CFSELECT


brain melt-down... please assist! :-)

Here's my SQL: SELECT SPRFNBR, SPFNAME, SPLNAME as Name from SPEAKERS

Here's my CFSELECT: 

Works great!

However, I would like to add the first and last names togetherand I know
this can be done inside the SQL statement, and this is where I would like to
do it. I know there are other solutions, but does anybody know how to
concatenate the two inside a SQL statement? I've done it before but for the
life of me, can't get it to work.

Any feedback is of course, highly regarded and much appreciated!

Erika

"Age is in the mind of the beholder." - Unknown
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: CFSELECT

[Garza, Jeff]

SELECT SPRFNBR, SPFNAME +' '+ SPLNAME AS FULLNAME
FROM SPEAKERS

Should do the trick.

Jeff Garza
Web Developer/Webmaster
Spectrum Astro, Inc.
480.892.8200

[EMAIL PROTECTED]
http://www.spectrumastro.com



-Original Message-
From: Erika L Walker [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, April 11, 2001 2:41 PM
To: CF-Talk
Subject: CFSELECT


brain melt-down... please assist! :-)

Here's my SQL: SELECT SPRFNBR, SPFNAME, SPLNAME as Name from SPEAKERS

Here's my CFSELECT: 

Works great!

However, I would like to add the first and last names togetherand I know
this can be done inside the SQL statement, and this is where I would like to
do it. I know there are other solutions, but does anybody know how to
concatenate the two inside a SQL statement? I've done it before but for the
life of me, can't get it to work.

Any feedback is of course, highly regarded and much appreciated!

Erika

"Age is in the mind of the beholder." - Unknown
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

What and why are these errors happening?

[Bud]

I get this error in my application.log file. All on the same site:

"Error resolving parameter SESSION.ID The session variable ID does not exist.

In my application.cfm I have:



So how can that happen? CFAS doesn't show a restart at the time of the errors.

Also. What is this and how do I fix it? :-D

"Error","TID=140","04/11/01","17:25:37","Unable to write reply -- 
timed out writing data back to web server."
"Error","TID=140","04/11/01","17:25:37","Windows NT error number 1460 
occurred."

Thanks!
-- 

Bud Schneehagen - Tropical Web Creations

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452

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

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

Email Server Hosting

[polyphoton]

Hi,

I have web sites hosted at a hosting company.

And I want to have my email server hosted on another company.

Any recommendation on good email server hosting companies?

THanks!

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

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

RE: multiple select

[Garza, Jeff]

It would be passed as a comma separated list

e.g., form.assignedEmps = "23,45,123,533,2"

So,



INSERT INTO yourtable (ProductID, EmpID)
VALUES (#form.ProductID#, #i#)



Assuming that you want a different row for each employeeid...

HTH,

Jeff Garza
Web Developer/Webmaster
Spectrum Astro, Inc.
480.892.8200

[EMAIL PROTECTED]
http://www.spectrumastro.com



-Original Message-
From: Jones, Becky [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, April 11, 2001 1:45 PM
To: CF-Talk
Subject: multiple select


how would the insert statement look if i had a select box that allowed the
user to select multiple people to assign to a product?  it would be the same
product id each time...just different empid's.  


*
This e-mail, including any attachments, is intended for the 
receipt and use by the intended addressee(s), and may contain 
confidential and privileged information.  If you are not an intended 
recipient of this e-mail, you are hereby notified that any unauthorized 
use or distribution of this e-mail is strictly prohibited.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: OT: Scheduled File Transfers

[Paul Smith]

That's how we had planned to do it.
But we got "NorthPointed" and that interrupted testing our FTP script.

I created the following batch file (ftpcmd.bat):

%windir%\ftp.exe -s:%f0
goto done
open ***Host name omitted***
***User name omitted***
***Password omitted***
lcd d:\website\htdocs\stockgolf\htdocs\data
ascii
get eod.txt
bye
:done
@echo off
cls
exit

I *believe* (but have not tested) the AT is something like:

AT 02:00 /every:M,T,W,Th,F,S,Su "ftpcmd.bat"

I'd appreciate any corrections to my plan

best,  paul

At 04:41 PM 4/11/01 -0700, you wrote:
>We need to automate a daily file transfer process between another company's
>computer with dialup Internet access but no Cold Fusion or Web server 
>software, and
>our Web/CF server (from the company's computer TO our server.)
>
>Is this typically done by setting up a command line version of a standard 
>FTP client,
>and then firing that daily by using the NT scheduler, or are there better 
>ways?


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

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

Re: Re[2]: Email software

[Joseph Thompson]

I'll toss in a vote for Imail.  Of course, I have always used Imail so this
is not very objective :)

It is very easy to set up and the ODBC mail users database is easy to
manipulate through CF


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

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

RE: How to get Julian Date

[Adrian Cesana]

This should do it,
Adrian


-Original Message-
From: Paul Sizemore [mailto:[EMAIL PROTECTED]]

How would I get the julian date for today, besides using the CF_Julian tag?

Paul



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

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

CFSELECT

[Erika L Walker]

brain melt-down... please assist! :-)

Here's my SQL: SELECT SPRFNBR, SPFNAME, SPLNAME as Name from SPEAKERS

Here's my CFSELECT: 

Works great!

However, I would like to add the first and last names togetherand I know
this can be done inside the SQL statement, and this is where I would like to
do it. I know there are other solutions, but does anybody know how to
concatenate the two inside a SQL statement? I've done it before but for the
life of me, can't get it to work.

Any feedback is of course, highly regarded and much appreciated!

Erika

"Age is in the mind of the beholder." - Unknown




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

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

Re: How to get Julian Date

[Marc Garrett]

I suppose you could ask him, but he might not be that sort of fellow.

Regards,

Marc Garrett

- Original Message -
From: "Paul Sizemore" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 11, 2001 4:40 PM
Subject: How to get Julian Date


> How would I get the julian date for today, besides using the CF_Julian
tag?



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

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

Re: [OT: Scheduled File Transfers]

[Alex]

most ftp clients have wizards that will setup automation for you.
also the receiving server needs an FTP daemon running.

"Gene Kraybill" <[EMAIL PROTECTED]> wrote:
We need to automate a daily file transfer process between another company's 
computer with dialup Internet access but no Cold Fusion or Web server
software, and 
our Web/CF server (from the company's computer TO our server.)

Is this typically done by setting up a command line version of a standard FTP
client, 
and then firing that daily by using the NT scheduler, or are there better
ways? 

Gene Kraybill
-
Gene Kraybill
LPW & Associates LLC
www.lpw.net
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: Problem writing file

[Richard Ramos]

Try making the layout of the page using Word, placing in the CF variables
#'s and all.  Save it as RTF and open it in Notepad.  Then just add in the
CFFILE code from below for each section between the CF variables and then
save the file in a directory on the server.  Add some code to force a
download or open it in the browser window using CFContent.  This is how we
do our invoices here.

Richard Ramos
Network Administrator
Softitler Net, Inc.
www.softitler.com
[EMAIL PROTECTED]

- Original Message -
From: "Greg Creedon" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 11, 2001 1:54 PM
Subject: Problem writing file


> I have a contract in Microsoft Word format. There are terms in the
contract
> which need to be variables (name, address, etc etc). The file needs to be
> updated by technically challenged users and still be able to output to
> people signing the contract on line.
>
> The way I'm currently doing it is to save the .doc file as an Rich Text
> Format Document, which makes it all ascii, then use cffile to write out
> another .rtf file. The trouble is, it's wicked unwieldy. Here's the first
> couple of lines of the cffile tag. It works, but sheesh... Any ideas?
>
> Greg Creedon
> Developer - Available now in NYC!
>
>  FILE="d:\icp\documents\#newfilename#"
> OUTPUT="{\rtf1\ansi\ansicpg1252\uc1
>
\deff0\deflang1033\deflangfe1033{\fonttbl{\f0\froman\fcharset0\fprq2{\*\pano
> se 02020603050405020304}Times New
> Roman;}{\f2\fmodern\fcharset0\fprq1{\*\panose 02070309020205020404}Courier
> New;}
> {\f23\froman\fcharset128\fprq1{\*\panose }MS
> Mincho{\*\falt MS ??};}{\f28\froman\fcharset128\fprq1{\*\panose
> }@MS Mincho;}{\f29\fswiss\fcharset0\fprq2{\*\panose
> 020b0604030504040204}Verdana;}
> {\f34\froman\fcharset238\fprq2 Times New Roman
> CE;}{\f35\froman\fcharset204\fprq2 Times
> (about 70K of stuff deleted) ...
> \par \hich\af29\dbch\af23\loch\f29 Contract #session.contract_id#
> \par }}">
>
>
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: Runtime session var error.

[Kevin Gilchrist]

I've gone back over my code and made sure that locking is working OK.
There are no nested locks, I only work with session vars in this small app
so have limited it all to the session scope with exclusive locks for
anything that does a CFSET and READONLY for anything that tests the vars.

Just to make sure, I configured the Administrator to do full checking for
the session scope on my dev box and it didn't complain about a thing.

No users have logged on since this morning so I can't know for sure if the
problem is nailed.
I'm going to ask the client to send out the invtation emails to users to try
the survey again.
Fingers crossed.


The page that complains is the survey form's action page, below.
The Application.cfm is below that again.

















UPDATE tbl_vng SET SurveyCompleted = True
WHERE password = #session.password#;










A ton of of diagnostic code.  Works fine.




alert('There was a problem updating the database, click OK
to to re-submit.');
history.go(-1);


  

  


  Application.cfm ***









 











































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

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

RE: How to get Julian Date

[kmansel]

~
Kevin Mansel
Web Developer
Fox Communications
[EMAIL PROTECTED]
DL : 425-649-1321
C : 425-346-7221



-Original Message-
From: Paul Sizemore [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 11, 2001 1:40 PM
To: CF-Talk
Subject: How to get Julian Date


How would I get the julian date for today, besides using the CF_Julian tag?

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

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

RE: Scheduled File Transfers

[Dylan Bromby]

if the remote system runs a FTP server, you can use CFFTP to connect to it
and transfer files back and forth.

you can use the AT scheduler (BIG improvements over the scheduling interface
in WIN2K over NT but both will work) or you can use CFSCHEDULE.

or you could just write batch files to do it.


-Original Message-
From: Gene Kraybill [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 11, 2001 4:41 PM
To: CF-Talk
Subject: OT: Scheduled File Transfers


We need to automate a daily file transfer process between another company's
computer with dialup Internet access but no Cold Fusion or Web server
software, and
our Web/CF server (from the company's computer TO our server.)

Is this typically done by setting up a command line version of a standard
FTP client,
and then firing that daily by using the NT scheduler, or are there better
ways?

Gene Kraybill
-
Gene Kraybill
LPW & Associates LLC
www.lpw.net
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: Studio 4.5.2

[sebastian palmigiani]

I got Windows 2000 installed now. I install the CF Server from the CF Studio
4.5.2. I restart and I get all kinds of error messages such as:

userinit.exe failed to initialize properly

Service - AuthSrv.exe generated errors and will be closed

Service - AzSrv.exe generated errors and will be closed

I can't even get to the desktop and just get an empty screen.

I went into safe mode and uninstalled the CF server and I was able to get to
my desktop without any errors.

Does this many sense to anyone?

Sebastian



on 4/11/01 3:19 PM, Sandra Clark at [EMAIL PROTECTED] wrote:

> Sebastian
> 
> I had a lot of problems running 4.5.x on my Win2k computer until I did the
> following:
> 
> I removed Studio 4.0 completely from my system.  Moved my snippets and other
> customizations (like Help, etc.) to a temporary directory.
> Deleted the 4.0 directory and all subdirectories from my system
> Went through my registry with RegEdit and deleted anything to do with
> CFStudio or Homesite completely.
> Rebooted machine
> 
> Did clean install.
> 
> It cleaned up a lot of problems.  Of course I still have problems (who
> doesn't with this crapola release), but it is markedly more stable than what
> I was working with before.
> 
> Hope this helps
> 
> Sandy Clark
> Shayna Productions
> http://www.shayna.com
> 
> 
> -Original Message-
> From: sebastian palmigiani [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 11, 2001 10:00 AM
> To: CF-Talk
> Subject: Studio 4.5.2
> 
> 
> 
> I upgraded to CF Studio 4.5.2 with Win98. It kept repeatedly crashing my
> system. I had to go back to Studio 4.0.
> 
> Is this just an issue with Win98 or would it be the same story with Win2000?
> 
> I am disspointed in this 'improvement.'
> 
> Sebastian
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: IsDefined('') v.

[Bill Davies]

So would  be cheaper than just doing a  anyway - say for an
Application variable whose value is constant?

-Original Message-
From: Will Swain [mailto:[EMAIL PROTECTED]]
Sent: 11 April 2001 17:27
To: CF-Talk
Subject: RE: IsDefined('') v. 


Yup, CFPARAMs in your application.cfm file will 'set' empty variables, which
you can fill later.

That way, you don't need to check for their existence, just see what they
are.

Cheers

Will

-Original Message-
From: Bob Silverberg [mailto:[EMAIL PROTECTED]]
Sent: 11 April 2001 15:29
To: CF-Talk
Subject: RE: IsDefined('') v. 


This doesn't answer your question directly, but if you are really going to
test for the existence of a variable, and create it if it doesn't exist, I'd
suggest using  which will accomplish both of those things in one
step.  I only used IsDefined if I want to check for the existence of a
variable, and I'm NOT going to create it if it doesn't exist.

Bob

-Original Message-
From: Bill Davies [mailto:[EMAIL PROTECTED]]
Sent: April 11, 2001 10:12 AM
To: CF-Talk
Subject: IsDefined('') v. 


Anyone have any idea whether an IsDefined('') 'costs' more than a ?

i.e. Which is more work for the server - to test for the existence of a
variable (and create it if it doesn't exist) or create or overwrite it
anyhow?

Thanks.


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

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

Re[2]: Email software

[ychen]

Additional Header Information:
Received: from www.houseoffusion.com ([207.31.122.140]) by inside.pgi.com (Lotus
SMTP MTA v4.6.6  (890.1 7-16-1999)) with SMTP id 85256A2B.006CCC2F; Wed, 11 Apr
2001 15:48:21 -0400
Received: from houseoffusion.com ([207.31.122.140])
  by www.houseoffusion.com (Post.Office MTA v3.5.3
release 223
  ID# 0-54969U100L100S0V35) with ESMTP id com
  for <[EMAIL PROTECTED]>;
  Wed, 11 Apr 2001 15:30:53 -0400
Date: Wed, 11 Apr 2001 15:11:19 -0400
From: "Benjamin S. Rogers" <[EMAIL PROTECTED]>
Message-id: <[EMAIL PROTECTED]>
References: <[EMAIL PROTECTED]>
Subject: RE: Email software
Reply-To: [EMAIL PROTECTED]
To: CF-Talk <[EMAIL PROTECTED]>
Content-Type: text/plain


-




 Thank you for those suggestion, actually, we are looking for an email
 server software whcih will support mutilple domain and List Server

 What will you guys recommend between Sendmail, imail and VOP mail?

 Thank you


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

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

Problem writing file

[Greg Creedon]

I have a contract in Microsoft Word format. There are terms in the contract
which need to be variables (name, address, etc etc). The file needs to be
updated by technically challenged users and still be able to output to
people signing the contract on line.

The way I'm currently doing it is to save the .doc file as an Rich Text
Format Document, which makes it all ascii, then use cffile to write out
another .rtf file. The trouble is, it's wicked unwieldy. Here's the first
couple of lines of the cffile tag. It works, but sheesh... Any ideas?

Greg Creedon
Developer - Available now in NYC!







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

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

multiple select

[Jones, Becky]

how would the insert statement look if i had a select box that allowed the
user to select multiple people to assign to a product?  it would be the same
product id each time...just different empid's.  


*
This e-mail, including any attachments, is intended for the 
receipt and use by the intended addressee(s), and may contain 
confidential and privileged information.  If you are not an intended 
recipient of this e-mail, you are hereby notified that any unauthorized 
use or distribution of this e-mail is strictly prohibited. 



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

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

Re: insert help

[Bryan LaPlante]

wow I don't believe it, I just went though this nightmare. The field name
date needs to be changed to some other word like upLoadDate or something. I
like to never figured that one out.

Bryan

- Original Message -
From: <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 11, 2001 3:02 PM
Subject: RE: insert help


> > does anyone see anything wrong w/ this insert statement?
> >  >  datasource="catlingalleries"
> >  dbtype="ODBC">
> > INSERT INTO OtherImages (SmallImage, ArtistID, TypeID, ArtName,
> > Price, Size, Date)
> > VALUES ('#fileName#', #ArtistID#, #TypeID#, '#RealName#',
> > '#Price#', '#Size#', '#Date#')
> > 
>
> Assuming you've got your text vs. number datatypes straight, then you
> might consider that "Date" is a reserved word in most dbs, so you could
> either put brackets around it ("[Date]") when calling it by name, or
> rename that column to "myDate" or something.
>
> Also, unless your users are entering the date in perfect ODBC format, or
> your date field is just a text field, you're probably going to want to
> insert the date as #CreateODBCDate(Date)# (no ticks).
>
>
> Ron Allen Hornbaker
> President/CTO
> Humankind Systems, Inc.
> http://humankindsystems.com
> mailto:[EMAIL PROTECTED]
>
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

How to get Julian Date

[Paul Sizemore]

How would I get the julian date for today, besides using the CF_Julian tag?

Paul

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

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

Re: insert help

[Jay Patton]

it is and i overlooked that,

thanks,

Jay Patton
Web Design / Application Design
Web Pro USA
p. 406.549.3337 ext. 203
p. 1.888.5WEBPRO ext. 203
e. [EMAIL PROTECTED]
url. www.webpro-usa.com
- Original Message -
From: "Garza, Jeff" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 11, 2001 2:00 PM
Subject: RE: insert help


> I think that Date is a reserved word...  Try changing that to myDate or
> something else.
>
> Jeff Garza
> Web Developer/Webmaster
> Spectrum Astro, Inc.
> 480.892.8200
>
> [EMAIL PROTECTED]
> http://www.spectrumastro.com
>
>
>
> -Original Message-
> From: Jay Patton [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 11, 2001 12:33 PM
> To: CF-Talk
> Subject: insert help
>
>
> .quick question...
>
> does anyone see anything wrong w/ this insert statement?
>
> 
> 
> 
> 
> 
> 
>
>   datasource="catlingalleries"
>  dbtype="ODBC">
> INSERT INTO OtherImages (SmallImage, ArtistID, TypeID, ArtName, Price,
Size,
> Date)
> VALUES ('#fileName#', #ArtistID#, #TypeID#, '#RealName#', '#Price#',
> '#Size#', '#Date#')
> 
>
>
> this is the error i get:
>
> Error Diagnostic Information
> ODBC Error Code = 37000 (Syntax error or access violation)
>
>
> [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO
> statement.
>
>
>
> The error occurred while processing an element with a general identifier
of
> (CFQUERY), occupying document position (41:1) to (43:23).
>
>
> Date/Time: 04/11/01 13:29:49
> Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0)
>
>
> Thanks in advance,
>
> Jay Patton
> Web Design / Application Design
> Web Pro USA
> p. 406.549.3337 ext. 203
> p. 1.888.5WEBPRO ext. 203
> e. [EMAIL PROTECTED]
> url. www.webpro-usa.com
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

OT: Scheduled File Transfers

[Gene Kraybill]

We need to automate a daily file transfer process between another company's 
computer with dialup Internet access but no Cold Fusion or Web server software, and 
our Web/CF server (from the company's computer TO our server.)

Is this typically done by setting up a command line version of a standard FTP client, 
and then firing that daily by using the NT scheduler, or are there better ways? 

Gene Kraybill
-
Gene Kraybill
LPW & Associates LLC
www.lpw.net

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

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

CFLDAP problem

[Melissa Fraher]

Hello.
I get the following error when trying to use CFLDAP to connect to our
LDAP server:

---
Error Occurred While Processing Request

 Error Diagnostic Information

 CFLDAP

 No such object
---

Here is the code:






DN: Root DSE
Subschemasubentry: #subschemasubentry#



Does anyone have any advice on this?  I read in past postings that
removing the password would work, but not in this case.  Also, I was
able to get the example using ldap.bigfoot.com in the CFDOCS 4.5 to
work.

Thank you for any help.

Melissa


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

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

RE: Email software

[Dylan Bromby]

i've used IMail by Ipswitch for the past 4 years. i've never found a reason
to swap it out, and it sends/receives well over a million messages a month
on a single box which houses about 50,000 accounts.

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 11, 2001 11:05 AM
To: CF-Talk
Subject: Email software





Additional Header Information:
Received: from www.houseoffusion.com ([207.31.122.140]) by inside.pgi.com
(Lotus
SMTP MTA v4.6.6  (890.1 7-16-1999)) with SMTP id 85256A2B.0060A2E4; Wed, 11
Apr
2001 13:35:31 -0400
Received: from houseoffusion.com ([207.31.122.140])
  by www.houseoffusion.com (Post.Office MTA v3.5.3
release 223
  ID# 0-54969U100L100S0V35) with ESMTP id com
  for <[EMAIL PROTECTED]>;
  Wed, 11 Apr 2001 13:34:22 -0400
Date: Wed, 11 Apr 2001 12:30:53 -0500
From: "Marcus" <[EMAIL PROTECTED]>
Message-id: <[EMAIL PROTECTED]>
References:
<3312CFEA8474D411BAB600508B9587B2482FDF@S0001EXC0007>
Subject: RE: CF5 Beta Program
Reply-To: [EMAIL PROTECTED]
To: CF-Talk <[EMAIL PROTECTED]>
Content-Type: text/plain


-




Hi,
I am looking for an email software which include SMTP and POP server. Do you
guys have any suggestion which product is good?

Thank you for any suggestion.

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

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

RE: Studio 4.5.2

[Sandra Clark]

Sebastian

I had a lot of problems running 4.5.x on my Win2k computer until I did the
following:

I removed Studio 4.0 completely from my system.  Moved my snippets and other
customizations (like Help, etc.) to a temporary directory.
Deleted the 4.0 directory and all subdirectories from my system
Went through my registry with RegEdit and deleted anything to do with
CFStudio or Homesite completely.
Rebooted machine

Did clean install.

It cleaned up a lot of problems.  Of course I still have problems (who
doesn't with this crapola release), but it is markedly more stable than what
I was working with before.

Hope this helps

Sandy Clark
Shayna Productions
http://www.shayna.com


-Original Message-
From: sebastian palmigiani [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 11, 2001 10:00 AM
To: CF-Talk
Subject: Studio 4.5.2



I upgraded to CF Studio 4.5.2 with Win98. It kept repeatedly crashing my
system. I had to go back to Studio 4.0.

Is this just an issue with Win98 or would it be the same story with Win2000?

I am disspointed in this 'improvement.'

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

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

RE: insert help

[Bruce, Rodney]

your insert statement looks ok by itself,  you may want to look at the data
being passed.
How are the fields in your table set up,  do you allow zero length strings,
if not are you checking for validation before passing the data? you could
look at the date field,  in the code you are not formatting the date,  what
type of field is it in the database table?   date or text,  if its date,
will need to make sure the formatting matches.
Are your two id fields text or number? If they are text then you could add
the single quotes around the variables.

If any of the fields are index,  make sure Duplicates are OK.
Hope this helps

-Original Message-
From: Jay Patton [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 11, 2001 12:33 PM
To: CF-Talk
Subject: insert help


.quick question...

does anyone see anything wrong w/ this insert statement?







  

INSERT INTO OtherImages (SmallImage, ArtistID, TypeID, ArtName, Price, Size,
Date)
VALUES ('#fileName#', #ArtistID#, #TypeID#, '#RealName#', '#Price#',
'#Size#', '#Date#')



this is the error i get:

Error Diagnostic Information
ODBC Error Code = 37000 (Syntax error or access violation) 


[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO
statement. 



The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (41:1) to (43:23).


Date/Time: 04/11/01 13:29:49
Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0)


Thanks in advance,

Jay Patton
Web Design / Application Design
Web Pro USA
p. 406.549.3337 ext. 203
p. 1.888.5WEBPRO ext. 203
e. [EMAIL PROTECTED]
url. www.webpro-usa.com
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: regular expressions, anyone?

[Tony Schreiber]

Badtags = "B|P|HR|PRE";
Expression = "<[[:space:]]?/?[[:space:]]?(#Badtags#)[^>]*>";
Message = REReplaceNoCase(Message, Expression, '', 'ALL');

> i'm completely new to regular expressions, but my understanding is that
> they can be used to perform multiple find/replace all in one exception.
> i have a string that i must filter for several HTML tags before
> continuing. the code follows. how would i write a regular expression to
> perform all?
> 
> 
>   newStr = ReplaceNoCase(newStr,"","","ALL");
>   newStr = ReplaceNoCase(newStr,"",".","ALL");
>   newStr = ReplaceNoCase(newStr,"","","ALL");
>   newStr = ReplaceNoCase(newStr,"","","ALL");
>   newStr = ReplaceNoCase(newStr,""," ","ALL");
>   newStr = ReplaceNoCase(newStr,"","","ALL");
>   newStr = ReplaceNoCase(newStr,"","","ALL");
>   newStr = ReplaceNoCase(newStr,""," ","ALL");
> 
> 
> -mike
> 
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

4.5.1 and NT

[Kevin Schmidt]

I read somewhere that Allaire recommends running 4.5.1 SP2 on WIN2k only.
Can anyone remind me where I saw that? Link?

Thanks,

Kevin Schmidt, Web Technology Manager
Allaire Certified ColdFusion Developer
pwb inc.
integrated marketing communications
350 S. Main St., Suite 350
Ann Arbor, MI 48104
734.995.5000 (tel)
734.995.5002 (fax)
www.pwb.com




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

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

Re: HELP REQUIRED!

[Tony Schreiber]

I didn't see any replies and I don't have a complete answer, but I think
you're looking for  and/or .

> Guys, I have a wee problem that you may be able to answer... if you're free,
> obviously (!)
> 
> I'm working with dynamic encryption of web pages using a DLL on a web
> server. I've got it working by writing the binary output (encrypted HTML) to
> file, that's not a problem, I've done that in ASP and CF.
> 
> What I can't work out is on-the-fly delivery of the binary contents of a
> memory buffer.
> In ASP, the code looks thus:
> 
> Response.ContentType = "application/vnd.sealedmedia.softseal.html"
> Response.AddHeader "Content-Length", UBound(outBuf)
> Response.AddHeader "Cache-control", "no-cache"
> Response.BinaryWrite outBuf
> 
> NOW - is there any equivalent in ColdFusion for this?
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: insert help

[ron]

> does anyone see anything wrong w/ this insert statement?
>   datasource="catlingalleries"
>  dbtype="ODBC">
> INSERT INTO OtherImages (SmallImage, ArtistID, TypeID, ArtName,
> Price, Size, Date)
> VALUES ('#fileName#', #ArtistID#, #TypeID#, '#RealName#',
> '#Price#', '#Size#', '#Date#')
> 

Assuming you've got your text vs. number datatypes straight, then you
might consider that "Date" is a reserved word in most dbs, so you could
either put brackets around it ("[Date]") when calling it by name, or
rename that column to "myDate" or something.

Also, unless your users are entering the date in perfect ODBC format, or
your date field is just a text field, you're probably going to want to
insert the date as #CreateODBCDate(Date)# (no ticks).


Ron Allen Hornbaker
President/CTO
Humankind Systems, Inc.
http://humankindsystems.com
mailto:[EMAIL PROTECTED]




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

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

RE: Cookie problem: Expires, IsDefined, etc....

[Aaron Johnson]

Hi Evan,

When you use a cfcookie, the server (IIS or whatever you're using) sends an
HTTP header to the client... and then sends your CF page.  So, when you set
a cookie and then immediately test for it, ColdFusion thinks it exists
whether or not the browser accepts it.  You have to do something like this:

a) set cookie on page a
b) do a redirect (not using cflocation) to page b
c) test for cookie page b

You can test for a cookie on page b because the browser will request page b,
thus sending any cookies it has accepted.

Hope that helps. If not, you might want to dig into some discussions of
cookies (http://www.netscape.com/newsref/std/cookie_spec.html) and HTTP
headers.

Aaron Johnson, MCSE, MCP+I
Allaire Certified ColdFusion Developer
MINDSEYE, Inc.
617.350.0339
617.350.8884
66172567
[EMAIL PROTECTED]

> -Original Message-
> From: Evan Lavidor [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 11, 2001 3:26 PM
> To: CF-Talk
> Subject: Cookie problem: Expires, IsDefined, etc
>
>
> I'm using CFCOOKIE to set a non-expiring cookie on my users' machines.  My
> code in my application.cfm file is as follows:
>
> 
>   
>   
> 
>
>
> On a subsequent pages (not the first page where the cookie is
> set) I'm doing
> the following:
>
> 
>   
> 
>   
> 
>
> so that if they have cookies disabled that I can use their IP instead.
>
> However (and here's the problem), even on a browser with cookies disabled
> that's never been to this site (and I've checked the cookies on
> the machine
> to make sure) I'm still getting a page-based cookie set (i.e. one that
> changes with every reload of the page).
>
> How can I check if the cookie is defined or not if every time CF thinks it
> is?  I thought that if users had cookies disabled cfcookie simply wouldn't
> do anything.  Why is it setting this temporary value?  I am specifying an
> EXPIRES attribute, so I know it's not that...
>
> Thanks for any insight.
>
> Evan
>
> --
> -=-=-=-=-=-=-=-=-=-
> Evan Lavidor
> Circle.com Boston
> Tel: 617-585-3107
> Fax: 617-585-3091
> -=-=-=-=-=-=-=-=-=-
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: LOCKING

[Terry Bader]

looks good.. thanks...


Terry Bader
IT/Web Specialist
EDO Corp - Combat Systems
(757) 424-1004 ext 361 - Work
[EMAIL PROTECTED]   


(757)581-5981 - Mobile
[EMAIL PROTECTED]
icq: 5202487   aim: lv2bounce
http://www.cs.odu.edu/~bader






> -Original Message-
> From: Andrew Tyrone [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 11, 2001 3:11 PM
> To: CF-Talk
> Subject: RE: LOCKING
> 
> 
> > -Original Message-
> > From: Terry Bader [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, April 11, 2001 2:32 PM
> > To: CF-Talk
> > Subject: LOCKING
> > 
> > 
> > ok, question about locking
> > 
> > let's say I have code like this:
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > And somecfml.cfm might possible need to write to the session scope.
> > 
> > Now, my question is, does the Lock in the calling cfm page follow 
> > down into
> > the included page?
> > 
> 
> The file somecfml.cfm will get included before the page is 
> processed, so basically when using an include it is as if you 
> are executing the whole template as one file.
> 
> > 
> > just wondering because with a complex Conditional statement 
> > checking against
> > session variables, though you may be only reading from the 
> session scope
> > while running the checks, you might just have to write to the 
> > session scope
> > somewhere inside
> > so if the lock does follow the INCLUDES then I guess the 
> whole thing will
> > have to be EXECLUSIVELY locked...
> 
> Depending on how much code you are talking about running in 
> the included file, you might want to set local variables 
> wherever possible that hold the data from session variables 
> you will be reading from or writing to.  Once you have these 
> all set you could do another lock at the end of your page and 
> write them back to the appropriate session variables.
> 
> - Andy
> 
> 
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: insert help

[Garza, Jeff]

I think that Date is a reserved word...  Try changing that to myDate or
something else.

Jeff Garza
Web Developer/Webmaster
Spectrum Astro, Inc.
480.892.8200

[EMAIL PROTECTED]
http://www.spectrumastro.com



-Original Message-
From: Jay Patton [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, April 11, 2001 12:33 PM
To: CF-Talk
Subject: insert help


.quick question...

does anyone see anything wrong w/ this insert statement?







  

INSERT INTO OtherImages (SmallImage, ArtistID, TypeID, ArtName, Price, Size,
Date)
VALUES ('#fileName#', #ArtistID#, #TypeID#, '#RealName#', '#Price#',
'#Size#', '#Date#')



this is the error i get:

Error Diagnostic Information
ODBC Error Code = 37000 (Syntax error or access violation) 


[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO
statement. 



The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (41:1) to (43:23).


Date/Time: 04/11/01 13:29:49
Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0)


Thanks in advance,

Jay Patton
Web Design / Application Design
Web Pro USA
p. 406.549.3337 ext. 203
p. 1.888.5WEBPRO ext. 203
e. [EMAIL PROTECTED]
url. www.webpro-usa.com
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: insert help

[Brian Simmons]

Shot in the dark here, but try this as your insert statement:

INSERT INTO OtherImages (SmallImage, ArtistID, TypeID, ArtName, Price, Size, Date) 
VALUES ('#fileName#', #ArtistID#, #TypeID#, '#RealName#', '#Price#', '#Size#', 
###Date###) 

hth,
Brian Simmons
[EMAIL PROTECTED]
ColdFusion 4.5 Certification testing tool, CF_Buster:
http://www.centrasoft.com

-- Original Message --
From: "Jay Patton" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date: Wed, 11 Apr 2001 13:32:50 -0600

>quick question...
>
>does anyone see anything wrong w/ this insert statement?
>
>
>
>
>
>
>
>  
> datasource="catlingalleries"
> dbtype="ODBC">
>INSERT INTO OtherImages (SmallImage, ArtistID, TypeID, ArtName, Price, Size, Date)
>VALUES ('#fileName#', #ArtistID#, #TypeID#, '#RealName#', '#Price#', '#Size#', 
>'#Date#')
>
>
>
>this is the error i get:
>
>Error Diagnostic Information
>ODBC Error Code = 37000 (Syntax error or access violation) 
>
>
>[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. 
 







 
   

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

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

RE: insert help

[Aaron Johnson]

Hi Jay,

Date is a reserverd word in SQL.  Change your column name.

Aaron Johnson, MCSE, MCP+I
Allaire Certified ColdFusion Developer
MINDSEYE, Inc.
617.350.0339
617.350.8884
66172567
[EMAIL PROTECTED] 

> -Original Message-
> From: Jay Patton [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 11, 2001 3:33 PM
> To: CF-Talk
> Subject: insert help
> 
> 
> quick question...
> 
> does anyone see anything wrong w/ this insert statement?
> 
> 
> 
> 
> 
> 
> 
>   
>   datasource="catlingalleries"
>  dbtype="ODBC">
> INSERT INTO OtherImages (SmallImage, ArtistID, TypeID, ArtName, 
> Price, Size, Date)
> VALUES ('#fileName#', #ArtistID#, #TypeID#, '#RealName#', 
> '#Price#', '#Size#', '#Date#')
> 
> 
> 
> this is the error i get:
> 
> Error Diagnostic Information
> ODBC Error Code = 37000 (Syntax error or access violation) 
> 
> 
> [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT 
> INTO statement. 
> 
> 
> 
> The error occurred while processing an element with a general 
> identifier of (CFQUERY), occupying document position (41:1) to (43:23).
> 
> 
> Date/Time: 04/11/01 13:29:49
> Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0)
> 
> 
> Thanks in advance,
> 
> Jay Patton
> Web Design / Application Design
> Web Pro USA
> p. 406.549.3337 ext. 203
> p. 1.888.5WEBPRO ext. 203
> e. [EMAIL PROTECTED]
> url. www.webpro-usa.com
> 
> 
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: insert help

[Hayes, David]

Double check your data types; for example, are Price, Size and Date really
text fields? (Its value is surrounded by single quotes in the statement.)

FYI - Try to name your date fields something other than "date".

-Original Message-
From: Jay Patton [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 11, 2001 2:33 PM
To: CF-Talk
Subject: insert help


.quick question...

does anyone see anything wrong w/ this insert statement?







  

INSERT INTO OtherImages (SmallImage, ArtistID, TypeID, ArtName, Price, Size,
Date)
VALUES ('#fileName#', #ArtistID#, #TypeID#, '#RealName#', '#Price#',
'#Size#', '#Date#')



this is the error i get:

Error Diagnostic Information
ODBC Error Code = 37000 (Syntax error or access violation) 


[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO
statement. 



The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (41:1) to (43:23).


Date/Time: 04/11/01 13:29:49
Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0)


Thanks in advance,

Jay Patton
Web Design / Application Design
Web Pro USA
p. 406.549.3337 ext. 203
p. 1.888.5WEBPRO ext. 203
e. [EMAIL PROTECTED]
url. www.webpro-usa.com
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Email software

[cassady]

When I needed to find a mail server product I could quick set up (I didn't need to be 
"Super Techie"), easily prevent from being a spam relay, and I thought I could trust - 
I also went with Imail.

I'm not biased except in the fact I've been using it for 9 months, I keep hitting at 
higher levels, and it keeps responding.
IMail by http://www.ipswitch.com/

Stephen R. Cassady
runs with Imail ---> http://www.tallylist.com



>> I am looking for an email software which include SMTP and POP > server. Do you > 
>guys have any suggestion which product is good? 
> We're partial (and biased) towards IMail by http://www.ipswitch.com/. Very easy for 
>a non-mail-admin to setup and configure. 




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

RE: Printing, page breaks, and heading info

[Paul Sizemore]

I did an ASP project a while back that required page breaks on print. After
head banging by a lot of people, I came up with the following code. 

When printed from "most" browsers, it prints in what looks like page breaks
because of the way browsers try to not break images. If you tie your text
content to an image (that is around 80% of the page height) with a table,
the browser will print what looks to the user as page breaks.

You might need to adjust the height of the spacer, but I think this is the
number that worked in Netscape and IE 3 up. 


  

Page One Content
  



  

Page Two Content
  
 


Paul Sizemore

Finish Line
3308 N Mitthoeffer Rd
Indianapolis, IN 46235
W: 317-899-1022 ext 3516


-Original Message-
From: Terri Stocke [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 09, 2001 2:15 PM
To: CF-Talk
Subject: Re:Printing, page breaks, and heading info

Okay, I moved it and tried it in the body, and then in a paragraph tag. Both
instances caused the blue screen when I tried to print (it still printed,
but killed my PC).

So, I guess I either need to find a way to print the top info I want on
every page, or if that is not possible with just CF and the browser, dump
the info to PDF per Adrian's suggestion and see if I can manipulate it that
way...

Thanks for the help!


Original Message Follows
From: [EMAIL PROTECTED] (Carol Bluestein)
Reply-To: [EMAIL PROTECTED]
To: CF-Talk <[EMAIL PROTECTED]>
Subject: Re:Printing, page breaks, and heading info
Date: Mon, 09 Apr 2001 09:42:02 -0400

Believe you can't use the style=page-break etc. inside a table.
So you have to count rows and end your table, put in the
break, and start a new table for each page.


Carol L. Bluestein
Senior Programmer
NYS Office of Real Property
518-486-6335
[EMAIL PROTECTED]


Reply Separator
Subject:Printing, page breaks, and heading info
Author: [EMAIL PROTECTED]
Date:   4/9/01 12:48 PM

Hey all,

I have a shipping and receiving application that allows employees to
generate a shipping request via the web. The shipping dept. would like that
form to be printed out by the user, but they want one of two things when
this happens:

1) Either only allow the maximum number of items that will print on one
page, and prompt the user to fill out a second form for additional items; OR

2) Automatically have the app insert a break between the item in the last
row of the table and the next table row on the next page, but ALSO make sure
that the shipping address and other info is ALSO printed on each subsequent
page.

I favor the second method, since it is less hassle for the user, and it
would be easier to just insert a break in the table than to try to guess how
many characters a user might enter onto the page (virtually impossible to
determine how many pages they will need).

After searching the archives, I found the snippet I thought would work:
. I tried this in both the body tag
and in my table tag, but each time I used it I got the dreaded blue screen
o' death. I then found and tried a variation: http://www.fusionauthority.com/bkinfo.cfm

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

RE: LOCKING

[Brian Simmons]

The way I usually do it, is to quickly CFLOCK (as readonly) the session variables and 
copy them into local variables.

Then use the local variables later on the page (in IF statements and what not).

That way as little as code as possible is inside the CFLOCK tag block.

hth,
Brian Simmons
[EMAIL PROTECTED]
ColdFusion 4.5 Certification testing tool, CF_Buster:
http://www.centrasoft.com

-- Original Message --
From: "Hayes, David" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date: Wed, 11 Apr 2001 13:54:05 -0500

>I think you want to handle it more like this:
>
>
>
>   
>   
>   
>
>
>
>   
>
>
>
>-Original Message-
>From: Terry Bader [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, April 11, 2001 1:32 PM
>To: CF-Talk
>Subject: LOCKING
>
>
>ok, question about locking
>
>let's say I have code like this:
>
>
>   
>   
>   
>
>
>And somecfml.cfm might possible need to write to the session scope.
>
>Now, my question is, does the Lock in the calling cfm page follow down into
>the included page?
>
>
>just wondering because with a complex Conditional statement checking against
>session variables, though you may be only reading from the session scope
>while running the checks, you might just have to write to the session scope
>somewhere inside
>so if the lock does follow the INCLUDES then I guess the whole thing will
>have to be EXECLUSIVELY locked...
>
>
>   Terry Bader
>   IT/Web Specialist
>   EDO Corp - Combat Systems
>   (757) 424-1004 ext 361 - Work
>   [EMAIL PROTECTED]   
>
>
>   (757)581-5981 - Mobile
>   [EMAIL PROTECTED]
>   icq: 5202487   aim: lv2bounce
>   http://www.cs.odu.edu/~bader

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

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

regular expressions, anyone?

[Mike Amburn]

i'm completely new to regular expressions, but my understanding is that
they can be used to perform multiple find/replace all in one exception.
i have a string that i must filter for several HTML tags before
continuing. the code follows. how would i write a regular expression to
perform all?


  newStr = ReplaceNoCase(newStr,"","","ALL");
  newStr = ReplaceNoCase(newStr,"",".","ALL");
  newStr = ReplaceNoCase(newStr,"","","ALL");
  newStr = ReplaceNoCase(newStr,"","","ALL");
  newStr = ReplaceNoCase(newStr,""," ","ALL");
  newStr = ReplaceNoCase(newStr,"","","ALL");
  newStr = ReplaceNoCase(newStr,"","","ALL");
  newStr = ReplaceNoCase(newStr,""," ","ALL");


-mike

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

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

RE: pull numbers from a string...

[Garza, Jeff]

This will strip out all letters, spaces and punctuation.

Jeff Garza
Web Developer/Webmaster
Spectrum Astro, Inc.
480.892.8200

[EMAIL PROTECTED]
http://www.spectrumastro.com



-Original Message-
From: Ethan Rosch [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, April 11, 2001 11:26 AM
To: CF-Talk
Subject: pull numbers from a string...


Hi all..

is there a funcion that wil strip everything out of a string except numbers?

ie.  The width of the box is 54"

and I want to set



something like



#width# = 54

thanks in advance,

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

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

Cookie problem: Expires, IsDefined, etc....

[Evan Lavidor]

I'm using CFCOOKIE to set a non-expiring cookie on my users' machines.  My
code in my application.cfm file is as follows:







On a subsequent pages (not the first page where the cookie is set) I'm doing
the following:







so that if they have cookies disabled that I can use their IP instead.

However (and here's the problem), even on a browser with cookies disabled
that's never been to this site (and I've checked the cookies on the machine
to make sure) I'm still getting a page-based cookie set (i.e. one that
changes with every reload of the page).

How can I check if the cookie is defined or not if every time CF thinks it
is?  I thought that if users had cookies disabled cfcookie simply wouldn't
do anything.  Why is it setting this temporary value?  I am specifying an
EXPIRES attribute, so I know it's not that...

Thanks for any insight.

Evan

--
-=-=-=-=-=-=-=-=-=-
Evan Lavidor
Circle.com Boston
Tel: 617-585-3107
Fax: 617-585-3091
-=-=-=-=-=-=-=-=-=-


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

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

RE: pull numbers from a string...

[Evan Lavidor]

The Val() function will give you the first number that appears in the
string, so:

Val("The width of the box is 54") = 54

but

Val("I have 124 boxes of width 54") = 124


HTH,

Evan

> -Original Message-
> From: Ethan Rosch [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 11, 2001 2:26 PM
> To: CF-Talk
> Subject: pull numbers from a string...
>
>
> Hi all..
>
> is there a funcion that wil strip everything out of a string
> except numbers?
>
> ie.  The width of the box is 54"
>
> and I want to set
>
> 
>
> something like
>
> 
>
> #width# = 54
>
> thanks in advance,
>
> ethan
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

insert help

[Jay Patton]

quick question...

does anyone see anything wrong w/ this insert statement?







  

INSERT INTO OtherImages (SmallImage, ArtistID, TypeID, ArtName, Price, Size, Date)
VALUES ('#fileName#', #ArtistID#, #TypeID#, '#RealName#', '#Price#', '#Size#', 
'#Date#')



this is the error i get:

Error Diagnostic Information
ODBC Error Code = 37000 (Syntax error or access violation) 


[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. 



The error occurred while processing an element with a general identifier of (CFQUERY), 
occupying document position (41:1) to (43:23).


Date/Time: 04/11/01 13:29:49
Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0)


Thanks in advance,

Jay Patton
Web Design / Application Design
Web Pro USA
p. 406.549.3337 ext. 203
p. 1.888.5WEBPRO ext. 203
e. [EMAIL PROTECTED]
url. www.webpro-usa.com


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

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

RE: LOCKING

[Andrew Tyrone]

> -Original Message-
> From: Terry Bader [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 11, 2001 2:32 PM
> To: CF-Talk
> Subject: LOCKING
> 
> 
> ok, question about locking
> 
> let's say I have code like this:
> 
> 
>   
>   
>   
> 
> 
> And somecfml.cfm might possible need to write to the session scope.
> 
> Now, my question is, does the Lock in the calling cfm page follow 
> down into
> the included page?
> 

The file somecfml.cfm will get included before the page is processed, so basically 
when using an include it is as if you are executing the whole template as one file.

> 
> just wondering because with a complex Conditional statement 
> checking against
> session variables, though you may be only reading from the session scope
> while running the checks, you might just have to write to the 
> session scope
> somewhere inside
> so if the lock does follow the INCLUDES then I guess the whole thing will
> have to be EXECLUSIVELY locked...

Depending on how much code you are talking about running in the included file, you 
might want to set local variables wherever possible that hold the data from session 
variables you will be reading from or writing to.  Once you have these all set you 
could do another lock at the end of your page and write them back to the appropriate 
session variables.

- Andy


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

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

RE: LOCKING

[Terry Bader]

yeah, that looks good...  

but does anyone know if it follows down the include??


Terry Bader
IT/Web Specialist
EDO Corp - Combat Systems
(757) 424-1004 ext 361 - Work
[EMAIL PROTECTED]   


(757)581-5981 - Mobile
[EMAIL PROTECTED]
icq: 5202487   aim: lv2bounce
http://www.cs.odu.edu/~bader






> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 11, 2001 2:52 PM
> To: CF-Talk
> Subject: RE: LOCKING
> 
> 
> this would be better
> 
> 
>   
> 
> 
> 
>   
> 
> 
> -Original Message-
> From: Terry Bader [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 11, 2001 1:32 PM
> To: CF-Talk
> Subject: LOCKING
> 
> 
> ok, question about locking
> 
> let's say I have code like this:
> 
> 
>   
>   
>   
> 
> 
> And somecfml.cfm might possible need to write to the session scope.
> 
> Now, my question is, does the Lock in the calling cfm page 
> follow down into
> the included page?
> 
> 
> just wondering because with a complex Conditional statement 
> checking against
> session variables, though you may be only reading from the 
> session scope
> while running the checks, you might just have to write to the 
> session scope
> somewhere inside
> so if the lock does follow the INCLUDES then I guess the 
> whole thing will
> have to be EXECLUSIVELY locked...
> 
> 
>   Terry Bader
>   IT/Web Specialist
>   EDO Corp - Combat Systems
>   (757) 424-1004 ext 361 - Work
>   [EMAIL PROTECTED]   
> 
> 
>   (757)581-5981 - Mobile
>   [EMAIL PROTECTED]
>   icq: 5202487   aim: lv2bounce
>   http://www.cs.odu.edu/~bader
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: LOCKING

[Terry Bader]

that would be way too much work you are putting on yourself...

looks at the email from mjones

Terry Bader
IT/Web Specialist
EDO Corp - Combat Systems
(757) 424-1004 ext 361 - Work
[EMAIL PROTECTED]   


(757)581-5981 - Mobile
[EMAIL PROTECTED]
icq: 5202487   aim: lv2bounce
http://www.cs.odu.edu/~bader






> -Original Message-
> From: Hayes, David [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 11, 2001 2:54 PM
> To: CF-Talk
> Subject: RE: LOCKING
> 
> 
> I think you want to handle it more like this:
> 
> 
> 
>   
>   
>   
> 
> 
> 
>   
> 
> 
> 
> -Original Message-
> From: Terry Bader [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 11, 2001 1:32 PM
> To: CF-Talk
> Subject: LOCKING
> 
> 
> ok, question about locking
> 
> let's say I have code like this:
> 
> 
>   
>   
>   
> 
> 
> And somecfml.cfm might possible need to write to the session scope.
> 
> Now, my question is, does the Lock in the calling cfm page 
> follow down into
> the included page?
> 
> 
> just wondering because with a complex Conditional statement 
> checking against
> session variables, though you may be only reading from the 
> session scope
> while running the checks, you might just have to write to the 
> session scope
> somewhere inside
> so if the lock does follow the INCLUDES then I guess the 
> whole thing will
> have to be EXECLUSIVELY locked...
> 
> 
>   Terry Bader
>   IT/Web Specialist
>   EDO Corp - Combat Systems
>   (757) 424-1004 ext 361 - Work
>   [EMAIL PROTECTED]   
> 
> 
>   (757)581-5981 - Mobile
>   [EMAIL PROTECTED]
>   icq: 5202487   aim: lv2bounce
>   http://www.cs.odu.edu/~bader
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Email software

[Benjamin S. Rogers]

We've used several of the popular ones out there. Without knowing what your
specific needs are, I can only recommend Vircom's VOPMail
(http://www.vircom.com).

The product is solid and full featured. We've found it to be the easiest to
secure against spam. The interface is straight forward and, generally
intuitive.

VOPMail rates extremely well in a price/features comparisons with other
products. They also boast one of the best support teams I've ever dealt
with.

Benjamin S. Rogers
Web Developer, c4.net
Voice: (508) 240-0051
Fax: (508) 240-0057

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 11, 2001 2:05 PM
To: CF-Talk
Subject: Email software





Additional Header Information:
Received: from www.houseoffusion.com ([207.31.122.140]) by inside.pgi.com
(Lotus
SMTP MTA v4.6.6  (890.1 7-16-1999)) with SMTP id 85256A2B.0060A2E4; Wed, 11
Apr
2001 13:35:31 -0400
Received: from houseoffusion.com ([207.31.122.140])
  by www.houseoffusion.com (Post.Office MTA v3.5.3
release 223
  ID# 0-54969U100L100S0V35) with ESMTP id com
  for <[EMAIL PROTECTED]>;
  Wed, 11 Apr 2001 13:34:22 -0400
Date: Wed, 11 Apr 2001 12:30:53 -0500
From: "Marcus" <[EMAIL PROTECTED]>
Message-id: <[EMAIL PROTECTED]>
References:
<3312CFEA8474D411BAB600508B9587B2482FDF@S0001EXC0007>
Subject: RE: CF5 Beta Program
Reply-To: [EMAIL PROTECTED]
To: CF-Talk <[EMAIL PROTECTED]>
Content-Type: text/plain


-




Hi,
I am looking for an email software which include SMTP and POP server. Do you
guys have any suggestion which product is good?

Thank you for any suggestion.

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

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

RE: pull numbers from a string...

[Diana Nichols]

-Original Message-
From: Ethan Rosch [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 11, 2001 2:26 PM
To: CF-Talk
Subject: pull numbers from a string...


Hi all..

is there a funcion that wil strip everything out of a string except numbers?

ie.  The width of the box is 54"

and I want to set



something like



#width# = 54

thanks in advance,

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

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

RE: pull numbers from a string...

[Hayes, David]

 OK, or you could do this:
#REReplaceNoCase("The width of the box is 54 ","[^0-9]","","ALL")#

-Original Message-
From: Ethan Rosch [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 11, 2001 1:26 PM
To: CF-Talk
Subject: pull numbers from a string...


Hi all..

is there a funcion that wil strip everything out of a string except numbers?

ie.  The width of the box is 54"

and I want to set



something like



#width# = 54

thanks in advance,

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

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

RE: pull numbers from a string...

[Hayes, David]

Well, you should be able to do this using REFind.

For example, REFind("[0-9]*",  , 1, true)>

Look at the Help for REFind for handling the returned position and length of
the found item(s).  You'll have to figure out how to handle multiple numbers
in your string.


-Original Message-
From: Ethan Rosch [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 11, 2001 1:26 PM
To: CF-Talk
Subject: pull numbers from a string...


Hi all..

is there a funcion that wil strip everything out of a string except numbers?

ie.  The width of the box is 54"

and I want to set



something like



#width# = 54

thanks in advance,

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

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

Progress: update numeric SubString?

[Adrian Cesana]

I created another test table and it works finesoo now I just need to
figure out why the Numeric fields in my production table is different than
the Numeric in my test table

Thanks for all the help/suggestions..

Adrian



-Original Message-
From: Caulfield, Michael [mailto:[EMAIL PROTECTED]]

I've actually run the query successfully from 4.5 and 5.0b1 -- I'm thinking
we might be in bug territory.

Rename the column from switch to something else, in case there is some CF
confusion regarding switch-case (i.e. a bug in 4.01). I know that sounds
implausible, but I can't replicate the error here with later versions, and
I'm out of ideas.

And I would also run Dave's example, (SELECT LEFT(123456,3) + '1' +
right(123456, len(123456) -4) as test) to see if the problem is specific to
your table, or if it's the syntax that's bombing.

HTH,

Michael Caulfield



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

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

Re: OT - CFLDAP

[Michael Ross]

Do use cfldap a lot, just starting with SSL and ldap not sure about 512?  Its a pretty 
unused tag because its a pain...good luck!

>>> [EMAIL PROTECTED] 04/10/01 03:52PM >>>

Didn't get any response before, so I'm trying again.  I too have hit
every major list/forum about this.  Has anyone here even worked with CFLDAP?
Scott helped me out briefly last time, but it was nothing I hadn't tried.
I'm having difficulty getting to a certificate through the tag.  It's an
older LDAP server so I know I can not modify records, but I can't even see
the cert.  It's an SSL server running a 512 bit key, not 128.  Does anyone
know of any issues CFLDAP may have supporting a legacy system with a 512 bit
key? Does the SECURE attribute of CFLDAP support anything other than 128?
Anyone...anytime...ever worked with CFLDAP?  I'll even take a "No, go away
you're pissing us off".  I'm not proud...  Help!!! 


> Frank T. Gragnano
>   IS/Web Specialist
>   EDO Corporation - Combat Systems
>   (757) 424 - 1004 ext. 321
>   [EMAIL PROTECTED]
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: LOCKING

[Hayes, David]

I think you want to handle it more like this:













-Original Message-
From: Terry Bader [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 11, 2001 1:32 PM
To: CF-Talk
Subject: LOCKING


ok, question about locking

let's say I have code like this:







And somecfml.cfm might possible need to write to the session scope.

Now, my question is, does the Lock in the calling cfm page follow down into
the included page?


just wondering because with a complex Conditional statement checking against
session variables, though you may be only reading from the session scope
while running the checks, you might just have to write to the session scope
somewhere inside
so if the lock does follow the INCLUDES then I guess the whole thing will
have to be EXECLUSIVELY locked...


Terry Bader
IT/Web Specialist
EDO Corp - Combat Systems
(757) 424-1004 ext 361 - Work
[EMAIL PROTECTED]   


(757)581-5981 - Mobile
[EMAIL PROTECTED]
icq: 5202487   aim: lv2bounce
http://www.cs.odu.edu/~bader
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: LOCKING

[mjones]

this would be better









-Original Message-
From: Terry Bader [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 11, 2001 1:32 PM
To: CF-Talk
Subject: LOCKING


ok, question about locking

let's say I have code like this:







And somecfml.cfm might possible need to write to the session scope.

Now, my question is, does the Lock in the calling cfm page follow down into
the included page?


just wondering because with a complex Conditional statement checking against
session variables, though you may be only reading from the session scope
while running the checks, you might just have to write to the session scope
somewhere inside
so if the lock does follow the INCLUDES then I guess the whole thing will
have to be EXECLUSIVELY locked...


Terry Bader
IT/Web Specialist
EDO Corp - Combat Systems
(757) 424-1004 ext 361 - Work
[EMAIL PROTECTED]   


(757)581-5981 - Mobile
[EMAIL PROTECTED]
icq: 5202487   aim: lv2bounce
http://www.cs.odu.edu/~bader
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Email software

[ron]

> I am looking for an email software which include SMTP and POP
> server. Do you
> guys have any suggestion which product is good?

We're partial (and biased) towards IMail by http://www.ipswitch.com/. Very
easy for a non-mail-admin to setup and configure.

With it's web messaging service, you can create rich webmail interfaces
like http://killerwebmail.com/ (one of our products), with full domain and
system admin functionality built-in.

Ron Allen Hornbaker
President/CTO
Humankind Systems, Inc.
http://humankindsystems.com
mailto:[EMAIL PROTECTED]




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

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

RE: Runtime session var error.

[Semrau, Steven L Mr SRA]

Regarding the timeout value not being specifically set (within the
application.cfm) should be fine as the server to use what is defined in the
Admin section (20 mins I believe).  Again though, I don't know if this may
be part of the cause if the customer(s) with the problem were actually
'inactive' for that amount of time.  But if so, you would think that any
other session vars you have set would be 'timed out' as well.

As far as session vars overwriting themselves, you don't have to be in a
framed environment for this to happen.  I've read through way to many
threads on Allaire's site regarding session variables coming up as missing
or overwritten.  The bottom line on that one, any time you read or
write/update a session, (server or application) variable, lock it.

Possibly sharing (even pieces) of the code might help someone on CF-Talk, to
include myself, with resolving this problem.

Steven Semrau
SRA International, Inc.
Senior Member, Professional Staff
[EMAIL PROTECTED]
[EMAIL PROTECTED]
Com:  (703) 805-1095
DSN:  (703) 655-1095


-Original Message-
From: Kevin Gilchrist [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 11, 2001 2:12 PM
To: CF-Talk
Subject: Re: Runtime session var error.


Timeout wasn't specifically set, set it to an hour now.

I have locks around each session var modification.
This doesn't even have any frames so it'd be surprising if session vars were
overwriting each other anyway right?

What's strange is that the error description to me was that a user tried to
submit, encountered an error (the error catcher at the time redirected them
to the login page).  

They maintain that even when they logged in again abd submitted
straightaway, they came across the error again.  This smacks of a
programmatic error but I can't reproduce the problem, I've blown away
cookies, used different browsers and logged in as different users to no
avail. 


"Semrau, Steven L Mr SRA" <[EMAIL PROTECTED]> wrote in
message
news:<[EMAIL PROTECTED]
>...
> Some quick thoughts, what is the timeout value for your session variables?
> And are these customers exceeding that amount of time when the error
occurs?
> Are you ing your reads and writes with regards to your session
> variables?

> Steven Semrau
> SRA International, Inc.
> Senior Member, Professional Staff
> [EMAIL PROTECTED]
> [EMAIL PROTECTED]
> Com:  (703) 805-1095
> DSN:  (703) 655-1095
> 
> 
> -Original Message-
> From: Kevin Gilchrist [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 11, 2001 1:12 PM
> To: CF-Talk
> Subject: Runtime session var error.
> 
> 
> Hi all,
> 
> I have a really annoying intermittent problem out on a customer's live
site
> where they submit a form and they get an error that says that a session
var
> is nonexistent.  This is a real pain because I can't reproduce the problem
> on either the customer's website or my development box.  Only some of the
> customer's users have a problem , I checked the DB and saw that a good
> number of people have submitted without problems.
> 
> I had an issue last night where session vars were lost because the CF
cookie
> wasn't written because I had done some CFLOCATION's in the login handler
> page which was also the very first of the app.  I replaced all of these
with
> JavaScript redirects and it worked fine.
> 
> This login page directs the user to a survey form which then posts to an
> action page.
> The action page is the page that reports non-existent session vars.  I
know
> that the survey form can get at the session vars because I use some as
> hidden vars.
> 
> Only one application.cfm page, and there are no cflocation tags on the
form
> page.
> I've configured an error handler to email me details for any error on the
> action page.
> I've modifed the error handler to send me a dump of all form and session
> vars the next time  an error occurs.
> 
> Any ideas?  The customer is about to have a hemorrhage.
> 
> Thanks a million Kev
> 
> See error email below.
> Error occured at: 11-Apr-01
>   
> Location: 128.2.88.201
> Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)
> Referer: http://www.hillgroupinc.com/surveys/vng/Survey_Form.cfm
> Username: 
>   
> Message: An error occurred while evaluating the expression:
>  session.username is "vng1001" and session.password is "vng"
> Error near line 9, column 37.Error resolving
parameter
> SESSION.PASSWORDThe session variable PASSWORD does not exist.
> The cause of this error is very likely one of the following
> things:The name of the session variable has been
> misspelled.The session variable has not yet been created.The
session
> variable has timed out.
> Exception Type: EXPRESSION 
> Specific Details on Exception Type Expression:
> ErrNumber: 16396
>   
>  
>   
> General Details:
> 
>   No Detail available.
> 
> Kevin Gilchrist
> Senior Consultant
> RedSiren Technologies Inc.
> (412) 281 4427 ext 466
>
~~~

LOCKING

[Terry Bader]

ok, question about locking

let's say I have code like this:







And somecfml.cfm might possible need to write to the session scope.

Now, my question is, does the Lock in the calling cfm page follow down into
the included page?


just wondering because with a complex Conditional statement checking against
session variables, though you may be only reading from the session scope
while running the checks, you might just have to write to the session scope
somewhere inside
so if the lock does follow the INCLUDES then I guess the whole thing will
have to be EXECLUSIVELY locked...


Terry Bader
IT/Web Specialist
EDO Corp - Combat Systems
(757) 424-1004 ext 361 - Work
[EMAIL PROTECTED]   


(757)581-5981 - Mobile
[EMAIL PROTECTED]
icq: 5202487   aim: lv2bounce
http://www.cs.odu.edu/~bader






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

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

pull numbers from a string...

[Ethan Rosch]

Hi all..

is there a funcion that wil strip everything out of a string except numbers?

ie.  The width of the box is 54"

and I want to set



something like



#width# = 54

thanks in advance,

ethan


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

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

when is CF5 release?

[ychen]

Additional Header Information:
Received: from www.houseoffusion.com ([207.31.122.140]) by inside.pgi.com (Lotus
SMTP MTA v4.6.6  (890.1 7-16-1999)) with SMTP id 85256A2B.0060A2E4; Wed, 11 Apr
2001 13:35:31 -0400
Received: from houseoffusion.com ([207.31.122.140])
  by www.houseoffusion.com (Post.Office MTA v3.5.3
release 223
  ID# 0-54969U100L100S0V35) with ESMTP id com
  for <[EMAIL PROTECTED]>;
  Wed, 11 Apr 2001 13:34:22 -0400
Date: Wed, 11 Apr 2001 12:30:53 -0500
From: "Marcus" <[EMAIL PROTECTED]>
Message-id: <[EMAIL PROTECTED]>
References:
<3312CFEA8474D411BAB600508B9587B2482FDF@S0001EXC0007>
Subject: RE: CF5 Beta Program
Reply-To: [EMAIL PROTECTED]
To: CF-Talk <[EMAIL PROTECTED]>
Content-Type: text/plain


-




when is version 5.0 to be released?

YC





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

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

Email software

[ychen]

Additional Header Information:
Received: from www.houseoffusion.com ([207.31.122.140]) by inside.pgi.com (Lotus
SMTP MTA v4.6.6  (890.1 7-16-1999)) with SMTP id 85256A2B.0060A2E4; Wed, 11 Apr
2001 13:35:31 -0400
Received: from houseoffusion.com ([207.31.122.140])
  by www.houseoffusion.com (Post.Office MTA v3.5.3
release 223
  ID# 0-54969U100L100S0V35) with ESMTP id com
  for <[EMAIL PROTECTED]>;
  Wed, 11 Apr 2001 13:34:22 -0400
Date: Wed, 11 Apr 2001 12:30:53 -0500
From: "Marcus" <[EMAIL PROTECTED]>
Message-id: <[EMAIL PROTECTED]>
References:
<3312CFEA8474D411BAB600508B9587B2482FDF@S0001EXC0007>
Subject: RE: CF5 Beta Program
Reply-To: [EMAIL PROTECTED]
To: CF-Talk <[EMAIL PROTECTED]>
Content-Type: text/plain


-




Hi,
I am looking for an email software which include SMTP and POP server. Do you
guys have any suggestion which product is good?

Thank you for any suggestion.

YC



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

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

Re: Re:Runtime session var error.

[Kevin Gilchrist]

I've added a cfparam to deal with that in Application.cfm  but I'm still
going to encounter the problem when I do an update query further down the
page which uses the password field.

I still want to try and figure out why it seems to have disappeared

"Carol Bluestein" <[EMAIL PROTECTED]> wrote in message
news:<[EMAIL PROTECTED]>...
> It would seem to me, that if the program is not finding session.password,
that
> you might use cfparam to set it (so it will always be there) and check
your code
> for a structClear(session) or structDelete command -- you may have
inadvertantly
> cleared the session.password variable.
> 
> Carol L. Bluestein
> Senior Programmer
> NYS Office of Real Property
> 518-486-6335
> [EMAIL PROTECTED]
> 
> 
> Reply Separator
> Subject:Runtime session var error.
> Author: [EMAIL PROTECTED]
> Date:   4/11/01 1:11 PM
> 
> Hi all,
> 
> I have a really annoying intermittent problem out on a customer's live
site
> where they submit a form and they get an error that says that a session
var
> is nonexistent.  This is a real pain because I can't reproduce the problem
> on either the customer's website or my development box.  Only some of the
> customer's users have a problem , I checked the DB and saw that a good
> number of people have submitted without problems.
> 
> I had an issue last night where session vars were lost because the CF
cookie
> wasn't written because I had done some CFLOCATION's in the login handler
> page which was also the very first of the app.  I replaced all of these
with
> JavaScript redirects and it worked fine.
> 
> This login page directs the user to a survey form which then posts to an
> action page.
> The action page is the page that reports non-existent session vars.  I
know
> that the survey form can get at the session vars because I use some as
> hidden vars.
> 
> Only one application.cfm page, and there are no cflocation tags on the
form
> page.
> I've configured an error handler to email me details for any error on the
> action page.
> I've modifed the error handler to send me a dump of all form and session
> vars the next time  an error occurs.
> 
> Any ideas?  The customer is about to have a hemorrhage.
> 
> Thanks a million Kev
> 
> See error email below.
> Error occured at: 11-Apr-01
> 
> Location: 128.2.88.201
> Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)
> Referer: http://www.hillgroupinc.com/surveys/vng/Survey_Form.cfm
> Username: 
> 
> Message: An error occurred while evaluating the expression:
>  session.username is "vng1001" and session.password is "vng"
> Error near line 9, column 37.Error resolving
parameter
> SESSION.PASSWORDThe session variable PASSWORD does not exist.
> The cause of this error is very likely one of the following
> things:The name of the session variable has been
> misspelled.The session variable has not yet been created.The
session
> variable has timed out.
> Exception Type: EXPRESSION 
> Specific Details on Exception Type Expression:
> ErrNumber: 16396
> 
>  
> 
> General Details:
> 
>   No Detail available.
> 
> Kevin Gilchrist
> Senior Consultant
> RedSiren Technologies Inc.
> (412) 281 4427 ext 466
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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