RE: CF wish list (was: Absolute Path Usage)

[Peter Tilbrook]

Owen, join the BETA project. Both Allaire and now Macromedia take
suggestions seriously. At the moment only Studio is in bet (or RC1 now) but
it is coming along really well - thanks to us beta users making suggestions.

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Owens,
Howard
Sent: Wednesday, 26 September 2001 03:11
To: CF-Talk
Subject: CF wish list (was: Absolute Path Usage)


Then you've got to surround these links with  tags.

I wish Macromedia would create a new CF tag ...

 (or )

This way you could include variables in HREF tags without the need to use
output tags, a la 

Which brings up another wish list item ... in Studio, if you select a file
from the resource pane and drag it onto a open template page, studio creates
a  link.  That's fine, but I would like to drag the file and have it
create a .  My suggestion for Studio is, if you drag a file while
holding down the ctl key, it puts the file in a   And, if you
hold down alt-ctl, it uses  with your cfmapping for that project.

H.


Howard Owens
Internet Operations Coordinator
www.insidevc.com
[EMAIL PROTECTED]
AIM: GoCatGo1956


> Home
> Page 1
> etc.. etc..
>
>   This makes it easy, and I do it all the time.
>   One potential problem is that you'll need different application.cfm for
> each directory.
>

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

CFInsert and 100%CPU bug

[Tristram Charnley]

I know Allaire denied it ever existed but in some circumstances
CFUPDATE and CFINSERT can cause a 100%CPU usage problem.

I'm wondering if anyone who has experienced this has solved
it by applying CF4.5 Service pack or moving to CF5.0

I'm hoping to avoid the hassle of replacing 15 lines of code
with an approx 140 lines in a CFQUERY


Tristram Charnley

~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: protecting an images dir with cfcontent

[Ben Whalley]

What is the overhead of using CFContent to squirt pictures at the client
over and above a standard img src=?

Ben

--
Ben Whalley, Radley Yeldar 
326 City Road, London, EC1V 2SP
--
0207 7130038
[EMAIL PROTECTED]
www.ry.com
--




---



* This message has been processed by MailGuard SMTP from NET-TEL
* Computer Systems Ltd. See .
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CFGRID problems in CF5 (need workaround)

[Tony Hicks]

Gonna share? :-)
--
Search the Holy Bible: http://www.bibleclicks.com
- Original Message -
From: Kwang Suh <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Tuesday, September 25, 2001 10:27 PM
Subject: RE: CFGRID problems in CF5 (need workaround)


> That's it.
>
> I'm writing a new grid.  A super grid.  A grid with every function I've
> wanted but Allaire has never put in.
>
> I now possess enough Java knowledge to do this.
>
> It shall be mine.  Oh yes, it shall be mine.
>
> And, I promise to fix it's bugs. :)
> -Original Message-
> From: Snyder, Jason [mailto:[EMAIL PROTECTED]]
> Sent: September 25, 2001 7:37 PM
> To: CF-Talk
> Subject: CFGRID problems in CF5 (need workaround)
>
>
> I have noticed that CFGRID in CF5 is very buggy.  Many of the problems
> seemed to be fixed in a 'hotfix' on Alliar's site, but it doesn't list all
> of the major problems that I was having with it.  One problem is that when
> modifying a field one has to select another field in order for those
> modifications to be saved when submitted.  (Somebody posted this on
> CFBugHunt a while back, but I didn't see the fix in the latest hot fix's
> release notes.)  A programmer like me doesn't have too many problems
> handling that, but for users it is unacceptable.  The other problem is
when
> a field is left blank and submitted and then later modified and submitted,
> CFGRIDUPDATE breaks.  I realize that you can delete the record, submit,
and
> then re-enter the record with the new value, but this is unacceptable
> for users.  (Especially when considering the previous bug, this makes a
> really bad situation for the user.)
>
>
> 
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

#cgi.?# (was Re: CFMAIL)

[Tony Hicks]

How about a complete list of cgi. params anywhere?
--
Search the Holy Bible: http://www.bibleclicks.com
- Original Message -
From: Rich Tretola <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Tuesday, September 25, 2001 3:52 PM
Subject: RE: CFMAIL


> Is there a complete list of Mail Params anywhere?
> Rich
>
> -Original Message-
> From: Howie Hamlin [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, September 25, 2001 2:30 PM
> To: CF-Talk
> Subject: Re: CFMAIL
>
>
> Sure.  Just use CFMailParam like:
>
> 
> 
> 
>
> .
>
> 
>
> HTH,
>
> Howie Hamlin - inFusion Project Manager
> On-Line Data Solutions, Inc. - www.CoolFusion.com
> 631-737-4668 x101
> inFusion Mail Server (iMS) - The Intelligent Mail Server
> >>> Find out how iMS Stacks up to the competition:
> http://www.coolfusion.com/imssecomparison.cfm
>
>
> - Original Message -
> From: "webmaster" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Tuesday, September 25, 2001 1:40 PM
> Subject: CFMAIL
>
>
> > Does anyone know how I can send nail with cfmail and flag the message as
> > "urgent" or "hi-priority" ?
> >
> > tia
> >
> > Richard
> >
> >
>
> 
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Why can't application.cfm...

[Tony Hicks]

Why can't application.cfm protect images..

like.. ?

DA = Direct Access..

Tony Hicks
--
Search the Holy Bible: http://www.bibleclicks.com

~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Why can't application.cfm...

[Kola Oyedeji]

Probably because images dont end with .cfm therefore they're not passed 
to the cf engine.

Kola Oyedeji
Web developer
Macromedia Certified Advanced ColdFusion 5 Developer
http://www.Alexandermark.com
(+44)020-8429-7300


> -Original Message-
> From: Tony Hicks [mailto:[EMAIL PROTECTED]]
> Sent: 26 September 2001 11:28
> To: CF-Talk
> Subject: Why can't application.cfm...
> 
> 
> Why can't application.cfm protect images..
> 
> like..  DAErrorRD="logipthenboothome.cfm">?
> 
> DA = Direct Access..
> 
> Tony Hicks
> --
> Search the Holy Bible: http://www.bibleclicks.com
> 
> 
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Passing the results from the

[phumes1]

Hi Bruce,

How do I retrieve the information on the file that was clicked on the 
test.cfm page and pass that to the template.cfm
to compare for a match and then pull the information from the array.

I can't seem to get the Session.stDirFileName[menuSelection] to work?

Output from test.cfm page

[3] file1.dat
[4] file2.dat
[5] file3.dat
[6] file4.dat
[7] file5.dat


Output from other template.cfm page

[1] .
[2] ..
[3] file1.dat
[4] file2.dat
[5] file3.dat
[6] file4.dat
[7] file5.dat



At 11:44 AM 9/24/01 -0700, you wrote:
>Make sure you have session management activated...then
>
>
>
>
>
>
>
>
>
> 
> 
> ...
> 
>
>
>Then on your other template page...
>
>The directory listing is:
>
>
> #stDirFileName[RecNo]# #stDirFileSize[RecNo]#
>
>
>Give that a whirl...this has not been tested, but should give you the idea
>on how to complete it.
>
>Bruce
>[EMAIL PROTECTED]
>
>- Original Message -
>From: <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Monday, September 24, 2001 10:32 AM
>Subject: Re: Passing the results from the 
>
> > At 10:28 AM 9/24/01 -0700, you wrote:
> > >There are multiple ways to pass it.  What directory info are you wanting
>to
> > >pass?
> >
> >
> > All the information from the  Name, Type etc.
> >
> > >You can pass info from one template to another via:
> > > Session vars
> > > Client vars
> > > Application vars
> > > Form fields
> > > URL parameters
> > > etc
> > >
> > >You may want to store the directory info you want into a structure or
>array,
> > >scope it as a Session variable, then reference it on the next template.
> >
> > Yikes. How do I do that?
> >
> >
> > >Bruce
> > >[EMAIL PROTECTED]
> > >
> > >- Original Message -
> > >From: <[EMAIL PROTECTED]>
> > >To: "CF-Talk" <[EMAIL PROTECTED]>
> > >Sent: Monday, September 24, 2001 10:00 AM
> > >Subject: Re: Passing the results from the template?
> > >
> > >
> > > > How can I pass the results from the  > > >
> > > > Name
> > > > Size
> > > > Type..etc
> > > >
> > >
> >
>
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Check out what Gartner is recommending. Drop IIS!

[Larry W. Virden]

from: "Rey Bango" <[EMAIL PROTECTED]>

> Replacing every IIS box makes absolutely no business sense and the cost
> would be astronomical. 

Depends on whether it is replaced with a free open source alternative like
AOLServer or Apache or with it is replaced with a commercial alternative.
-- 
Never apply a Star Trek solution to a Babylon 5 problem.
Larry W. Virden  http://www.purl.org/NET/lvirden/>
Even if explicitly stated to the contrary, nothing in this posting should 
be construed as representing my employer's opinions.
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Check out what Gartner is recommending. Drop IIS!

[Larry W. Virden]

from: Costas Piliotis <[EMAIL PROTECTED]>

> You know it's funny though.  A quick search at www.securiteam.com shows that
> Apache and iPlanet have many vulnerabilities as well.  Think perhaps that
> the research is simply political?  Hackers seem to actually target IIS boxes
> likely for their hatred of Micro$oft.  I think there's more to this than
> meets the eye...  

If this is the case, then I would expect that no rewrite is ever going to
exist to protect people using IIS.  I too would recommend that people run
as fast as possible from IIS simply because of its association with such a
'hated' company...
-- 
Never apply a Star Trek solution to a Babylon 5 problem.
Larry W. Virden  http://www.purl.org/NET/lvirden/>
Even if explicitly stated to the contrary, nothing in this posting should 
be construed as representing my employer's opinions.
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

CFPOP and Header Issue

[Guy McDowell]

Long time no inquire...

Situation:

Using CFPOP to retrieve messages, then validating the messages are from
registered users. If so, then the message is forwarded via cfmail to the
rest of the registered users.

Problem:

Using the 'header' or 'from' variable from cfpop and comparing the 'from'
field to the e-mail field in the membership db doesn't always work. This is
due to apps like MS Outlook allowing you to change the 'from' portion of
your header to a non e-mail format. ie Guy McDowell instead of
[EMAIL PROTECTED]

Attempted Solutions:

Tried using IP as unique identifier as well, however IP's often change each
time the user signs on to their ISP.

Given:

Using Spectra and CF 4.5

Bueller? Bueller? Anyone?

TIA,

Guy J. McDowell


FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Updating a multiple select box dynamically. question?

[Paul Ihrig]

Hello all.
i have a update page that has a Multiple Select box that i want to be able
to dynamically up date.
now if there has only been one prior selection, then it shows up in the
update select box.
but if there has been more then one selection made, then nothing shows up.

i hope you know what i mean!
any help would be great!
thanks
-paul

 
  
SELECTED>
 
#rs_Consultant_Types.Consultant_Types_Name#
  


-paul

~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Updating a multiple select box dynamically. question?

[Andy Ewings]

Replace multiple with multiple="yes"

-- 
Andrew Ewings
Project Manager
Thoughtbubble Ltd 
http://www.thoughtbubble.net 
-- 
United Kingdom 
http://www.thoughtbubble.co.uk/ 
Tel: +44 (0) 20 7387 8890 
-- 
New Zealand 
http://www.thoughtbubble.co.nz/ 
Tel: +64 (0) 9 488 9131 
-- 
The information in this email and in any attachments is confidential and
intended solely for the attention and use of the named addressee(s). Any
views or opinions presented are solely those of the author and do not
necessarily represent those of Thoughtbubble. This information may be
subject to legal, professional or other privilege and further distribution
of it is strictly prohibited without our authority. If you are not the
intended recipient, you are not authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890.



-Original Message-
From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
Sent: 26 September 2001 13:57
To: CF-Talk
Subject: Updating a multiple select box dynamically. question?


Hello all.
i have a update page that has a Multiple Select box that i want to be able
to dynamically up date.
now if there has only been one prior selection, then it shows up in the
update select box.
but if there has been more then one selection made, then nothing shows up.

i hope you know what i mean!
any help would be great!
thanks
-paul

 
  
SELECTED>
 
#rs_Consultant_Types.Consultant_Types_Name#
  


-paul


~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Check out what Gartner is recommending. Drop IIS!

[Rey Bango]

Larry,

I replied directly to you because we were asked to move this to
cf-community.

Rey...

- Original Message -
From: "Larry W. Virden" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, September 26, 2001 8:44 AM
Subject: Re: Check out what Gartner is recommending. Drop IIS!


> from: "Rey Bango" <[EMAIL PROTECTED]>
>
> > Replacing every IIS box makes absolutely no business sense and the cost
> > would be astronomical.
>
> Depends on whether it is replaced with a free open source alternative like
> AOLServer or Apache or with it is replaced with a commercial alternative.
> --
> Never apply a Star Trek solution to a Babylon 5 problem.
> Larry W. Virden  http://www.purl.org/NET/lvirden/>
> Even if explicitly stated to the contrary, nothing in this posting should
> be construed as representing my employer's opinions.
> 
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

CFQuery insert works on one machine and not another

[Tristram Charnley]

Why do I get the following error code on one server
(CF4.5.1 NT4 SP5 and Access 97) but not on another -
with identical software, or on my development PC
with CF5.0? both of which work a treat?

ODBC Error Code = 22005 (Error in assignment)
[Microsoft][ODBC Microsoft Access 97 Driver]Error in assignment (null)

Here's the query:


INSERT INTO DBGENERE 
(Country,
 TradeName,
 InternationalName,
 Category,
 Indications,
 RegistrationNo,
 MRPReferenceNo,
 RegistrationDate,
 RenewalDueDate,
 RenewalCycle,
 RegistrationExpiry,
 SafetyReportDueDate,
 Comments,
 ProductSizeNo,
 MarketingParticulars,
 FormulationNo,
 UnitDose,
 KindRegistration,
 MRPNo,
 RMSCMS,
 Rapp,
 CoRapp)
VALUES 
('#form.DBGENERE.Country#',
 '#form.DBGENERE.TradeName#',
 '#form.DBGENERE.InternationalName#',
 '#form.Category#',
 '#form.Indications#',
 '#form.RegistrationNo#',
 '#form.MRPReferenceNo#',
 '#form.RegistrationDate#',
 '#form.RenewalDueDate#',
 '#form.RenewalCycle#',
 '#form.RegistrationExpiry#',
 '#form.SafetyReportDueDate#',
 '#form.Comments#',
 '#form.ProductSizeNo#',
 '#form.MarketingParticulars#',
 '#form.DBGENERE.FormulationNo#',
 '#form.UnitDose#',
 '#form.KindRegistration#',
 '#form.MRPNo#',
 '#form.RMSCMS#',
 '#form.Rapp#',
 '#form.CoRapp#')


I'm baffled - any takers?


Tristram Charnley

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Determine current version

[C. Hatton Humphrey]

I've got an interesting situation that includes checking what service pack
is installed on the Cold Fusion server.  Is there a way to check this?  I
have the version and everything like that, but we don't know if the Sp has
been applied (it's running 4.5.1 pro right now)

TIA!

C. Hatton Humphrey
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CFQuery insert works on one machine and not another

[Andy Ewings]

Are any of the form values null?..check the versions of the ODBC drivers
(in control panel) on the 2 machines - I bet there is a difference.

-- 
Andrew Ewings
Project Manager
Thoughtbubble Ltd 
http://www.thoughtbubble.net 
-- 
United Kingdom 
http://www.thoughtbubble.co.uk/ 
Tel: +44 (0) 20 7387 8890 
-- 
New Zealand 
http://www.thoughtbubble.co.nz/ 
Tel: +64 (0) 9 488 9131 
-- 
The information in this email and in any attachments is confidential and
intended solely for the attention and use of the named addressee(s). Any
views or opinions presented are solely those of the author and do not
necessarily represent those of Thoughtbubble. This information may be
subject to legal, professional or other privilege and further distribution
of it is strictly prohibited without our authority. If you are not the
intended recipient, you are not authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890.



-Original Message-
From: Tristram Charnley [mailto:[EMAIL PROTECTED]]
Sent: 26 September 2001 14:26
To: CF-Talk
Subject: CFQuery insert works on one machine and not another


Why do I get the following error code on one server
(CF4.5.1 NT4 SP5 and Access 97) but not on another -
with identical software, or on my development PC
with CF5.0? both of which work a treat?

ODBC Error Code = 22005 (Error in assignment)
[Microsoft][ODBC Microsoft Access 97 Driver]Error in assignment (null)

Here's the query:


INSERT INTO DBGENERE 
(Country,
 TradeName,
 InternationalName,
 Category,
 Indications,
 RegistrationNo,
 MRPReferenceNo,
 RegistrationDate,
 RenewalDueDate,
 RenewalCycle,
 RegistrationExpiry,
 SafetyReportDueDate,
 Comments,
 ProductSizeNo,
 MarketingParticulars,
 FormulationNo,
 UnitDose,
 KindRegistration,
 MRPNo,
 RMSCMS,
 Rapp,
 CoRapp)
VALUES 
('#form.DBGENERE.Country#',
 '#form.DBGENERE.TradeName#',
 '#form.DBGENERE.InternationalName#',
 '#form.Category#',
 '#form.Indications#',
 '#form.RegistrationNo#',
 '#form.MRPReferenceNo#',
 '#form.RegistrationDate#',
 '#form.RenewalDueDate#',
 '#form.RenewalCycle#',
 '#form.RegistrationExpiry#',
 '#form.SafetyReportDueDate#',
 '#form.Comments#',
 '#form.ProductSizeNo#',
 '#form.MarketingParticulars#',
 '#form.DBGENERE.FormulationNo#',
 '#form.UnitDose#',
 '#form.KindRegistration#',
 '#form.MRPNo#',
 '#form.RMSCMS#',
 '#form.Rapp#',
 '#form.CoRapp#')


I'm baffled - any takers?


Tristram Charnley


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: AND & OR placement in SQL

[W Luke]

Thanks Deanna.  Not exactly what I wanted (my fault for not explaining
properly) but you got me on the right tracks :)

Cheers

Will
- Original Message -
From: "Deanna Schneider" <[EMAIL PROTECTED]>
Newsgroups: cf-talk
Sent: Tuesday, September 25, 2001 7:05 PM
Subject: Re: AND & OR placement in SQL


> Depends on what you want it to do. Right now, it's saying, select this
stuff
> if town is the same as the form.towny  AND category is form.category OR
> select this stuff if natpaid is yes and nationwide is yes AND category is
> form.category.
>
> My guess is that what you want is:
> select this stuff if town is the same as the form.towny OR select this
stuff
> if natpaid is yes and nationwide is yes AND category is form.category.
>
> If that's what you want, you need a little different query. Try this:
>
>  datasource="#DSN#">
> SELECT left(subject,20) as newsubject, * FROM advert_details
> WHERE town = '#form.towny#'
> 
> OR (natpaid = Yes AND nationwide = Yes
> AND category = '#form.category#')
> 
> OR (natpaid = Yes AND nationwide = Yes)
> 
> 
>
> Make sense?
> -Deanna
>
>
> Deanna Schneider
> Interactive Media Developer
> [EMAIL PROTECTED]
>
>
> 
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Updating a multiple select box dynamically. question?

[Paul Ihrig]

nope that didn't work.
it will still only show 1 select but not more then that.

could it have some thing to do with that
Consultant_Types_ID.Consultant_Types_ID is a number
where Edit.Consultant_Types_ID is text?

i needed to make that field text so i could insert multiple numbers like
43, 2, 56 et.

-paul



-Original Message-
Replace multiple with multiple="yes"

-- 
Andrew Ewings

-Original Message-

 
  
SELECTED>
 
#rs_Consultant_Types.Consultant_Types_Name#
  
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: SQL Server 2K

[Michael Ross]

Very simple. Very simple.  Take a quick backup of stuff before you upgrade and follow 
the steps.  It shouldn't take very long either.

mike


>>> [EMAIL PROTECTED] 09/25/01 09:35PM >>>
Can anyone tell me how much toruble it is to upgrade from SQL Server 7 
to SQL Server 2K.
Anything to watch for?  Anything to be aware of?

Thanks,
Mike


~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Determine current version

[Craig Fisher]

There are a series of SERVER. variables that store various information
about the Server.  Among them might be what you are looking for.

Check out Developing ColdFusion Applications ->Using the Application
Framework ->Using Server Variables.

Craig Fisher


- Original Message -
From: "C. Hatton Humphrey" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, September 26, 2001 8:26 AM
Subject: Determine current version


> I've got an interesting situation that includes checking what service pack
> is installed on the Cold Fusion server.  Is there a way to check this?  I
> have the version and everything like that, but we don't know if the Sp has
> been applied (it's running 4.5.1 pro right now)
>
> TIA!
>
> C. Hatton Humphrey
> 
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CFQuery insert works on one machine and not another

[Tristram Charnley]

Yes there are null values but the db will accept them, and
I've also set default params. 

I'll investigate the ODBC drivers, though. But doesn't the CF install
update these?

Tristram Charnley

~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Determine current version

[Stephen Galligan]

Hi there,

In Coldfusion output these:
Returns product name:   #Server.Coldfusion.ProductName#
Returns version number and if any service packs applied:
#Server.Coldfusion.ProductVersion#
Returns which type of product, either professional or enterprise:
#Server.Coldfusion.ProductLevel#


OS name:#Server.OS.Name#
OS service packs applied:   #Server.OS.AdditionalInformation#
OS version eg. 4.0 if running NT4:  #Server.OS.Version#

You can also find out your OS info in the registry:
At key HKEY_LOCAL_MACHINE\Software\Microsoft\WindowsNT\ CurrentVersion. 
Current Version key for the OS version 
CSDVersion key for the service pack version

Regards,
Stephen
-- 
Stephen Galligan 
Web Developer 
Thoughtbubble Ltd 
http://www.thoughtbubble.net 
-- 
United Kingdom 
http://www.thoughtbubble.co.uk/ 
Tel: +44 (0) 20 7387 8890 
-- 
New Zealand 
http://www.thoughtbubble.co.nz/ 
Tel: +64 (0) 9 488 9131 
-- 
The information in this email and in any attachments is confidential and
intended solely for the attention and use of the named addressee(s). Any
views or opinions presented are solely those of the author and do not
necessarily represent those of Thoughtbubble. This information may be
subject to legal, professional or other privilege and further distribution
of it is strictly prohibited without our authority. If you are not the
intended recipient, you are not authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890.
 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 26 September 2001 14:27
To: CF-Talk
Subject: Determine current version


I've got an interesting situation that includes checking what service pack
is installed on the Cold Fusion server.  Is there a way to check this?  I
have the version and everything like that, but we don't know if the Sp has
been applied (it's running 4.5.1 pro right now)

TIA!

C. Hatton Humphrey

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Why can't application.cfm...

[Trishan Singh]

That is exactly correct.
If you want to limit the access of the rest of the file you will need to do
it via the IIS Manager or MMC i believe it has a section of the allowed file
types... The reason you have to do it from there is that Colf Fusion is not
a webserver but rather a Application for the webserver.  The webserver is
the one responsible for the content and what file are transferred. I have
done this one time so if you need detailed help i can see if that project
site is still around,

Hope that helps,

Trishan Singh
ACP/CCFD
[EMAIL PROTECTED]
316-204-1097
Paracom Technologies

- Original Message -
From: "Kola Oyedeji" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, September 26, 2001 6:03 AM
Subject: RE: Why can't application.cfm...


> Probably because images dont end with .cfm therefore they're not passed
> to the cf engine.
>
> Kola Oyedeji
> Web developer
> Macromedia Certified Advanced ColdFusion 5 Developer
> http://www.Alexandermark.com
> (+44)020-8429-7300
>
>
> > -Original Message-
> > From: Tony Hicks [mailto:[EMAIL PROTECTED]]
> > Sent: 26 September 2001 11:28
> > To: CF-Talk
> > Subject: Why can't application.cfm...
> >
> >
> > Why can't application.cfm protect images..
> >
> > like..  > DAErrorRD="logipthenboothome.cfm">?
> >
> > DA = Direct Access..
> >
> > Tony Hicks
> > --
> > Search the Holy Bible: http://www.bibleclicks.com
> >
> >
> 
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Hiermenus v4.1 - http://www.dhtmlab.com/ and ColdFusion

[Nick Crossland]

Hi

I have used Hiermenus with Cold Fusion (on a dev server at the moment, not live yet).

I have made the HM_Arrays.js file dynamic by:
1) Changing its name to HM_Arrays.cfm
2) Changing the reference to it at the bottom of HM_loader.js so it says .cfm and not 
.js
3) Put a  at the top of the HM_Arrays.cfm file.

In will now let you use CFOUTPUTs, or whatever CF you like in the menu structure!

Regards

~nick~


FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CFPOP and Header Issue

[Alexis Maldonado]

download it at allaire dev-ex.


- Original Message -
From: "Guy McDowell" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, September 26, 2001 7:48 AM
Subject: CFPOP and Header Issue


> Long time no inquire...
>
> Situation:
>
> Using CFPOP to retrieve messages, then validating the messages are from
> registered users. If so, then the message is forwarded via cfmail to the
> rest of the registered users.
>
> Problem:
>
> Using the 'header' or 'from' variable from cfpop and comparing the 'from'
> field to the e-mail field in the membership db doesn't always work. This
is
> due to apps like MS Outlook allowing you to change the 'from' portion of
> your header to a non e-mail format. ie Guy McDowell instead of
> [EMAIL PROTECTED]
>
> Attempted Solutions:
>
> Tried using IP as unique identifier as well, however IP's often change
each
> time the user signs on to their ISP.
>
> Given:
>
> Using Spectra and CF 4.5
>
> Bueller? Bueller? Anyone?
>
> TIA,
>
> Guy J. McDowell
>
>
> FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
>
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Determine current version

[Stephen Galligan]

Spot on!

Regards,
Stephen

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 26 September 2001 15:07
To: CF-Talk
Subject: RE: Determine current version


Thanks for the replies, that got the information I was looking for...

I'm assuming then that 4, 5, 1, 0 means 4.5.1 with no service packs applied?

C. Hatton Humphrey

> -Original Message-
> From: Stephen Galligan [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, September 26, 2001 9:47 AM
> To: CF-Talk
> Subject: RE: Determine current version
>
>
> Hi there,
>
> In Coldfusion output these:
> Returns product name: #Server.Coldfusion.ProductName#
> Returns version number and if any service packs applied:
> #Server.Coldfusion.ProductVersion#
> Returns which type of product, either professional or enterprise:
> #Server.Coldfusion.ProductLevel#
>
>
> OS name:  #Server.OS.Name#
> OS service packs applied: #Server.OS.AdditionalInformation#
> OS version eg. 4.0 if running NT4:#Server.OS.Version#
>
> You can also find out your OS info in the registry:
> At key HKEY_LOCAL_MACHINE\Software\Microsoft\WindowsNT\ CurrentVersion.
> Current Version key for the OS version
> CSDVersion key for the service pack version
>
> Regards,
> Stephen
> --
> Stephen Galligan
> Web Developer
> Thoughtbubble Ltd
> http://www.thoughtbubble.net
> --
> United Kingdom
> http://www.thoughtbubble.co.uk/
> Tel: +44 (0) 20 7387 8890
> --
> New Zealand
> http://www.thoughtbubble.co.nz/
> Tel: +64 (0) 9 488 9131
> --
> The information in this email and in any attachments is confidential and
> intended solely for the attention and use of the named addressee(s). Any
> views or opinions presented are solely those of the author and do not
> necessarily represent those of Thoughtbubble. This information may be
> subject to legal, professional or other privilege and further distribution
> of it is strictly prohibited without our authority. If you are not the
> intended recipient, you are not authorised to disclose, copy,
> distribute, or
> retain this message. Please notify us on +44 (0)207 387 8890.
>
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: 26 September 2001 14:27
> To: CF-Talk
> Subject: Determine current version
>
>
> I've got an interesting situation that includes checking what service pack
> is installed on the Cold Fusion server.  Is there a way to check this?  I
> have the version and everything like that, but we don't know if the Sp has
> been applied (it's running 4.5.1 pro right now)
>
> TIA!
>
> C. Hatton Humphrey
>
> 

~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CFmail problem

[W Luke]

I've found it's more reliable to state your server and port (25) in CFmail.
Also, have you checked your logs?

Will
--
http://www.localbounty.com - free local and national advertising

- Original Message -
From: "Ins" <[EMAIL PROTECTED]>
Newsgroups: cf-talk
Sent: Wednesday, September 26, 2001 8:08 AM
Subject: CFmail problem


> Hi,
>
> One of my CF pages sends emails.
>
> Sometimes emails are sent, sometimes no function.
>
> Some one gave me the answer to this problem:
>
> "In regards to the email forms, it appears that they are failing
> due to the use of stray bare line feeds ("LF") in the messages being sent.
> This violates mail protocols which insist on end-of-line characters
> using a carriage-return followed by a line feed (CR\LF).
> Fixing your code to ensure that generated email uses the above character
> pairing
> on all message line endings will ensure all messages are sent correctly
> (the mailserver and CFMAIL services will only send what is sent to them
and
> no
> adjustments will be made (by design of the services). "
>
>
> But all carriage-return and line breaks have been replaced in my code:
>
> 
> ','all')#'>
>
>  subject="Thanks">
>
> #email_body#
>
> 
>
> Can any one help?
> Thank you.
> Ins
> FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: HELP!... with intranet idea

[Eric Dawson]

??digital dashboard?

Eric Dawson



From: "Mike Tangorre" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: CF-Talk <[EMAIL PROTECTED]>
Subject: Re: HELP!... with intranet idea
Date: Tue, 25 Sep 2001 19:16:56 -0400

We alreayd have exchange installed and they want me to pull the stuff form
there  :-(

Mike

- Original Message -
From: "Conrad Classen" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, September 25, 2001 6:46 PM
Subject: RE: HELP!... with intranet idea


 > Another alternative is to scrap exchange server and go with
 > Imail (www.ipswitch.com), which has the functionality built
 > in already, and a heck of a lot cheaper too.
 >
 > Conrad
 >
 >
 > -Original Message-
 > From: Mike Tangorre [mailto:[EMAIL PROTECTED]]
 > Sent: Tuesday, September 25, 2001 11:04 PM
 > To: CF-Talk
 > Subject: HELP!... with intranet idea
 >
 >
 > Hello all.
 > I have been asked to do the following:
 >
 > Design an intranet with a message board, events calendar, and a few
 > other items. The requirement I am bothered by is that of connecting to
 > an exchange server and getting schedules and stuff from peoples accounts
 >
 > to make a master schedule online for conference room meetings and what
 > not...
 >
 > I have no idea even where to begin on this in terms of the exchange
 > server thing.  Any ideas?
 > Is it even possible to access the server with CF?  Can I pull info,
 > update info, and add new info?
 >
 > Any help, tips, tricks, or recommendations would be much appreciated.
 >
 > Thanks,
 >
 > Mike Tangorre
 >
 >
 >

~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Determine current version

[C. Hatton Humphrey]

Thanks for the replies, that got the information I was looking for...

I'm assuming then that 4, 5, 1, 0 means 4.5.1 with no service packs applied?

C. Hatton Humphrey

> -Original Message-
> From: Stephen Galligan [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, September 26, 2001 9:47 AM
> To: CF-Talk
> Subject: RE: Determine current version
>
>
> Hi there,
>
> In Coldfusion output these:
> Returns product name: #Server.Coldfusion.ProductName#
> Returns version number and if any service packs applied:
> #Server.Coldfusion.ProductVersion#
> Returns which type of product, either professional or enterprise:
> #Server.Coldfusion.ProductLevel#
>
>
> OS name:  #Server.OS.Name#
> OS service packs applied: #Server.OS.AdditionalInformation#
> OS version eg. 4.0 if running NT4:#Server.OS.Version#
>
> You can also find out your OS info in the registry:
> At key HKEY_LOCAL_MACHINE\Software\Microsoft\WindowsNT\ CurrentVersion.
> Current Version key for the OS version
> CSDVersion key for the service pack version
>
> Regards,
> Stephen
> --
> Stephen Galligan
> Web Developer
> Thoughtbubble Ltd
> http://www.thoughtbubble.net
> --
> United Kingdom
> http://www.thoughtbubble.co.uk/
> Tel: +44 (0) 20 7387 8890
> --
> New Zealand
> http://www.thoughtbubble.co.nz/
> Tel: +64 (0) 9 488 9131
> --
> The information in this email and in any attachments is confidential and
> intended solely for the attention and use of the named addressee(s). Any
> views or opinions presented are solely those of the author and do not
> necessarily represent those of Thoughtbubble. This information may be
> subject to legal, professional or other privilege and further distribution
> of it is strictly prohibited without our authority. If you are not the
> intended recipient, you are not authorised to disclose, copy,
> distribute, or
> retain this message. Please notify us on +44 (0)207 387 8890.
>
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: 26 September 2001 14:27
> To: CF-Talk
> Subject: Determine current version
>
>
> I've got an interesting situation that includes checking what service pack
> is installed on the Cold Fusion server.  Is there a way to check this?  I
> have the version and everything like that, but we don't know if the Sp has
> been applied (it's running 4.5.1 pro right now)
>
> TIA!
>
> C. Hatton Humphrey
>
> 
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Check out what Gartner is recommending. Drop IIS!

[Neil Clark]

Replace IIS with whatever you want - but you have to see it this way - if
something goes tits-up; Microsoft will and can help - the Apache group will
simply lull in its little "oh we hate Microsoft world"

On a side note I really wish people would stop coming down on Microsoft (and
no I am not a MS employee...but I have just had a meeting with total anti-MS
spods and its feking p-ed me off...) They spend $ Millions on development
and these nonces simply just dismiss things as useless but the Microsoft
people are FAR FAR MORE intelligent than these Open Source chaps and
chapesses.

The truth of it is, most "New Media" work requires Windows Based software -
Apple has its place but as unstable as it is, cant be seriously considered
as an alternative...far far to unstable.

Sorry just livid at these muppets that dont understand development time over
cost price - jeex, I thank a company which spends $ millions on development
and you have to part with what oh! $1k of your dollars/pounds/whatever!...
not exactly a hard trade off

just my $0.02 and it does take peoples mind off the ongoing nonsense and
diabacle :-)

Neil





~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Converting data types

[W Luke]

Hi,

I need to add a list of currency data types outputted from a table, from a
field called #amount#.  The currency format is UK Pound.  I'm not too
familiar with the locale functions with CF, but think this is what I need
for a basic addition of currency values.  Could someone confirm this, and if
possible supply an example of how I'd go about it?

I tried the following embarassingly wrong code...






Any advice much appreciated.

Will

--
http://www.localbounty.com - free local and national advertising
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Calling Custom Tag

[saro]

i have a custom tag named textinput in custom tags
directory.I am calling the custom tag from a
default.cfm file from webroot folder.The webroot
folder also has a file named textinput.cfm.
Now which file would the default.cfm call whether the
file in webroot folder or in custom tags directory.

Or in other words what is the precedence in calling
custom tags.


Any documentation reference is highly appreciated.


-Saro



~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Calling Custom Tag

[Mike Tangorre]

I believe the local folde ris called first, then it checks the custom tags
fodler

Mike

- Original Message -
From: "saro" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, September 26, 2001 10:29 AM
Subject: Calling Custom Tag


> i have a custom tag named textinput in custom tags
> directory.I am calling the custom tag from a
> default.cfm file from webroot folder.The webroot
> folder also has a file named textinput.cfm.
> Now which file would the default.cfm call whether the
> file in webroot folder or in custom tags directory.
>
> Or in other words what is the precedence in calling
> custom tags.
>
>
> Any documentation reference is highly appreciated.
>
>
> -Saro
>
>
>
> 
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

cgi http referer from HTTPS

[Alex]

Is there a way to get cgi.http_referer to work if the referer is from
a HTTPS site?
Any alternative ways to get the referer?

Thanks.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CFQuery insert works on one machine and not another

[Tristram Charnley]

No its not the ODBC drivers.

Any other ideas?

Tristram Charnley

~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Calling Custom Tag

[Mike Tangorre]

geeesh, sorry for the typos!


- Original Message -
From: "Mike Tangorre" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, September 26, 2001 10:38 AM
Subject: Re: Calling Custom Tag


> I believe the local folde ris called first, then it checks the custom tags
> fodler
>
> Mike
>
> - Original Message -
> From: "saro" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, September 26, 2001 10:29 AM
> Subject: Calling Custom Tag
>
>
> > i have a custom tag named textinput in custom tags
> > directory.I am calling the custom tag from a
> > default.cfm file from webroot folder.The webroot
> > folder also has a file named textinput.cfm.
> > Now which file would the default.cfm call whether the
> > file in webroot folder or in custom tags directory.
> >
> > Or in other words what is the precedence in calling
> > custom tags.
> >
> >
> > Any documentation reference is highly appreciated.
> >
> >
> > -Saro
> >
> >
> >
> >
> 
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Calling Custom Tag

[Neil Clark]

CF will traverse the local DIR first then the custom tag directory.

~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

SQL Server - OT

[Mike Tangorre]

How difficult is it to go fom SQL Server 7 to SQL server 2K?
Is it easy to get the databases tranfered over?


Mike

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Cybercash WebAuthorize - Settling Batches

[Joshua Miller]

Anyone worked with Cybercash WebAuthorize and found a way to run "End of the
Day" Batch Settlement automatically? Is there a tag available, or can you
point me in the right direction to find out how to accomplish this?

Thanks!

Joshua Miller
Web Development::Programming
Eagle Technologies Group, Inc.
www.eagletgi.com
[EMAIL PROTECTED]
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: SQL Server - OT

[Neil Clark]

 Erm. I haven't found much of a problem but its one of those cases of dont
move unless you need to - otherwise stick with what works!

~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Order by....

[Janine Jakim]

I have several queries that make a pdf output and am having some problems
getting the order that I want to output.  I need for it to output by teacher
then student. The problem is my main query for this is the student query and
there's no link to the teacher in that query. How I have it set up:








So the teacher info is buried in another template.  What's the best way to
modify this?
Thanks in advance
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Calling Custom Tag

[Billy Cravens]

When you have a situation like that, you should use cfmodule instead of
the cf_ syntax

---
Billy Cravens
Web Development, EDS
[EMAIL PROTECTED]


-Original Message-
From: saro [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, September 26, 2001 9:29 AM
To: CF-Talk
Subject: Calling Custom Tag


i have a custom tag named textinput in custom tags
directory.I am calling the custom tag from a
default.cfm file from webroot folder.The webroot
folder also has a file named textinput.cfm.
Now which file would the default.cfm call whether the
file in webroot folder or in custom tags directory.

Or in other words what is the precedence in calling
custom tags.


Any documentation reference is highly appreciated.


-Saro




~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Check out what Gartner is recommending. Drop IIS!

[Richard Kuryk]

>>the Microsoft people are FAR FAR MORE intelligent than these Open Source
chaps and chapesses.

Microsoft only has so many developers when the open source world pulls from
unlimited numbers of developers all with there own backgrounds and
experience to add.  In addition to that, everyone is freely avaiable to
review the source code, so you get many more eyes catching bugs or
potentialy exploits.

>>The truth of it is, most "New Media" work requires Windows Based software 

Most of the motion picture industry in moving/moved in the linux direction.
Dreamworks and ILM are now running linux for workstations and there
rendering farms.

I think one of the main problems with IIS is that most windows systems are
easy to configure, so you get people who probably just got an MCSE from some
internet site and don't really know how to secure there a windows machine
properly.  


> -Original Message-
> From: Neil Clark [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, September 26, 2001 9:41 AM
> To: CF-Talk
> Subject: RE: Check out what Gartner is recommending. Drop IIS!
> 
> 
> Replace IIS with whatever you want - but you have to see it 
> this way - if
> something goes tits-up; Microsoft will and can help - the 
> Apache group will
> simply lull in its little "oh we hate Microsoft world"
> 
> On a side note I really wish people would stop coming down on 
> Microsoft (and
> no I am not a MS employee...but I have just had a meeting 
> with total anti-MS
> spods and its feking p-ed me off...) They spend $ Millions on 
> development
> and these nonces simply just dismiss things as useless but 
> the Microsoft
> people are FAR FAR MORE intelligent than these Open Source chaps and
> chapesses.
> 
> The truth of it is, most "New Media" work requires Windows 
> Based software -
> Apple has its place but as unstable as it is, cant be 
> seriously considered
> as an alternative...far far to unstable.
> 
> Sorry just livid at these muppets that dont understand 
> development time over
> cost price - jeex, I thank a company which spends $ millions 
> on development
> and you have to part with what oh! $1k of your 
> dollars/pounds/whatever!...
> not exactly a hard trade off
> 
> just my $0.02 and it does take peoples mind off the ongoing 
> nonsense and
> diabacle :-)
> 
> Neil
> 
> 
> 
> 
> 
> 
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Order by....

[Deanna Schneider]

You're going to need to re-think how this works. There must be some
connection between teacher and student in the database, yes? So, you'll need
to pull the teachers and students, grouped by teacher. Or, pull the teachers
and then do a subsequent query pulling all students with said teacher.

-d



Deanna Schneider
Interactive Media Developer
[EMAIL PROTECTED]


~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Protecting, a, images/pics, directory?

[Bruce Holm]

Can you explain the difference between using CFFILE and others suggesting
using CFCONTENT to display pictures in a window?

Bruce

- Original Message -
From: "Dave Hannum" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, September 25, 2001 11:03 AM
Subject: Re: Protecting, a, images/pics, directory?


> The application.cfm file does nothing to prevent directory browsing or
> calling of non .cfm files directly.  That's set up on the web server.  You
> can build a login script and then use CFDIRECTORY to list the image files
> then use CFFILE to bring them into a page to view.
>
> Dave
>
>
>
> - Original Message -
> From: "Absolute 1" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Tuesday, September 25, 2001 1:26 PM
> Subject: Protecting, a, images/pics, directory?
>
>
> > I am trying to make it so you have to "login" and be authenticated
before
> > you can view a subdirectory of images and pictures, much like I would if
I
> > used application.cfm to check authentication before .cfm files are
loaded
> in
> > a subdirectory.  But apparently application.cfm is not run before .jpg
or
> > gif files are accessed in a directory.  SO, does anyone have some
> > suggestions on how I can check authentication before someone accesses an
> > image file in a particular subdirectory?  The way it is right now, if
> anyone
> > knows the name of the image they can simply type in the URL.  Thanks in
> > advance for any suggestions.
> >
> >
> >
> 
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: SQL Server 2K

[Alex Santantonio]

Not much trouble at all.  I just recently upgraded 3 servers from various
installs of SQL 7 with many different configurations, SP's and such.  All 3
went smoothly.  When you upgrade, you will need to attach the old databases
to the new server, and any clients you upgrade will lose their registered
servers in the MMC.  You will just need to make a list of the servers you
have registered.  Also, in SQL 2K you can either leave the old database
files where they are, or you can copy them to the new location and then
attach them from there.  If you do this, then you can get rid of your entire
SQL 7 install so you have no more dormant files.  I was surprised at how
smooth it went.  One issue I had was the tendency for SQL2K to change its
default port from 1433 for TCP/IP since there was already SQL 7 on that port
(at least I think that is the reason).  I just had to go in through the
Server Network Utility and set it manually.  That was a little confusing at
first since I just couldn't connect through my firewall on the given port,
but once I realized it wasn't even connecting on that port, it was an easy
fix.  Hope this helps.

Alex Santantonio
Lead Developer
Macromedia Coldfusion 5 Certified Professional
Macromedia Certified Web Site Developer
[EMAIL PROTECTED] 
www.doceus.com


-Original Message-
From: Mike Tangorre [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 25, 2001 9:36 PM
To: CF-Talk
Subject: SQL Server 2K

Can anyone tell me how much toruble it is to upgrade from SQL Server 7
to SQL Server 2K.
Anything to watch for?  Anything to be aware of?

Thanks,
Mike


~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Absolute Path Usage

[Bruce Holm]

I did ask them to set up CFMappings for me and they did.  My comments about
they wouldn't set up mappings was focused on them setting up a "/" mapping.
That would not be possible on a shared CF server.

Anyway I had them set up some custom (for me) mappings and they work
beautifully!
Thanks to all for your help!

Bruce Holm

- Original Message -
From: "Owens, Howard" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, September 25, 2001 10:04 AM
Subject: RE: Absolute Path Usage


> If I was hosting with a company (and I've worked with many shared hosts
and
> I use mappings on all my applications) that wouldn't set up a CFMapping
for
> me -- I'd change hosts.
>
> There's no reason not to set up mappings for you.
>
> H.
>
>
> Howard Owens
> Internet Operations Coordinator
> www.insidevc.com
> [EMAIL PROTECTED]
> AIM: GoCatGo1956
>
>
> > -Original Message-
> > From: Bruce Holm [SMTP:[EMAIL PROTECTED]]
> > Sent: Tuesday, September 25, 2001 9:16 AM
> > To: CF-Talk
> > Subject: Re: Absolute Path Usage
> >
> > My hosting company controls the CF Server administration mapping.  SInce
> > they share the CF server with many other website domains, they won't be
> > creating mappings like "/" to my web root.  If my domain was the only
one
> > on
> > their server (dedicated server) then I could have them do this.
> >
> > Thanks for responding.
> >
> > Bruce
> >
> > - Original Message -
> > From: "Chad Gray" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Tuesday, September 25, 2001 8:52 AM
> > Subject: Re: Absolute Path Usage
> >
> >
> > > Im jumping into the middle also, but have to tried adding a mapping in
> > the
> > > CFadministrator?
> > >
> > > I had to use a path for some CFCINCLUDES that went 3 or 4 folders
deep,
> > and
> > > it works great!
> > >
> > >
> > >
> > > At 08:51 AM 9/25/2001 -0700, you wrote:
> > > >See below...
> > > >
> > > >- Original Message -
> > > >From: "Jeffry Houser" <[EMAIL PROTECTED]>
> > > >To: "CF-Talk" <[EMAIL PROTECTED]>
> > > >Sent: Tuesday, September 25, 2001 11:30 AM
> > > >Subject: Re: Absolute Path Usage
> > > >
> > > >
> > > > >   I didn't see the original post, so I'm jumping in the middle.
> > > >..
> > > > >   The way I do this is by setting a variable ( Either to the local
> > scope
> > > >or
> > > > > the request scope ) in the application.cfm called DirLevel:
> > > > >
> > > > > Root: Dirlevel = ""
> > > > >   Sub1Direvel = "../"
> > > > >SubSub1:Dirlevel = "../../"
> > > > >   Sub2Dirlevel = "../
> > > > >
> > > > >
> > > > >   When you create your include, make all the paths relative to the
> > root
> > > > > directory and add dirlevel in there.
> > > > >
> > > > > Home
> > > > > Page 1
> > > > > etc.. etc..
> > > > >
> > > > >   This makes it easy, and I do it all the time.
> > > > >   One potential problem is that you'll need different
> > application.cfm
> > for
> > > > > each directory.
> > > >
> > > >This technique may be useful in some cases, although I'm not sure
that
> > it's
> > > >worth it.  I'll probably just stick to hardcoding the ../../  etc
> > levels
> > in
> > > >each CFINCLUDE statement.
> > > >Thanks for the tip!
> > > >
> > > > >
> > > > > >I have tried a variety of absolute paths and find none that work.
> > If
> > > >anyone
> > > > > >can shed some light on this...my host shares the CF server so
> > asking
> > them
> > > >to
> > > > > >configure a mapping for "/" is not going to happen since it would
> > only
> > > >work
> > > > > >for my domain and not for all the other domains they host.
> > > > >
> > > > >You can always get to the exact root directory (I.E.
> > www.mysite.com/ )
> > > > > by using the slash.  So the code I wrote above could easily be
> > re-written
> > > >like:
> > > > >
> > > > > Home
> > > > > Page 1
> > > > >
> > > > >   And the browser sees the '/' and automatically adds it to the
end
> > of
> > the
> > > > > url, such as www.mysite.com/index.cfm for the first link.  Try it;
> > It
> > > > > works.  However, if the root directory of your application is not
> > the
> > root
> > > > > directory of your server, that won't work.
> > > >
> > > >It may work for  but not for  tag.  That
> > is
> > the
> > > >whole point of my discussion.  CFINCLUDE is very picky...it appears
it
> > ONLY
> > > >sees relative paths or paths specified in the server mapping file.
> > That's
> > > >IT!  How I wish it recognized "/" as the web root, meaning the
> > placeholder
> > > >or representative location for http://www.mydomain.com/.
> > > >
> > > >Bruce
> > > >
> > >
> >
> 
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

CyberCash to VeriSign

[Kamie Curfman]

One of my clients just received the below notice yesterday from
VeriSign:

"IMPORTANT CYBERCASH MIGRATION NOTICE:
Our records show that you are currently registered to process payments
through the CyberCash payment gateway.

Your account is currently scheduled for migration to VeriSign's Payflow
(SM) service on or after October 2, 2001.

As highlighted in earlier communications, VeriSign is in the process of
migrating its CyberCash customers to VeriSign's Payflow payment gateway
services. When this effort is complete, Internet credit card
transactions from your Web site will be processed through the Payflow
service. No changes are required to your merchant account, or your
credit card processor/bank and we do not anticipate any significant
changes to your Web site integration. We intend to make this transition
as simple and seamless for you as possible. When the integration is
complete, you will need to begin using VeriSign's Payflow Manager to
manage all new transactions instead of the CyberCash E-Commerce Services
Manager. We believe that you will find Payflow Manager easy to use with
comprehensive features that will meet your business requirements now and
in the future..."

The rest of the email simply instructs the customer to some of the ins
and outs of Payflow Manager.

My question to the group:  Has any developer out there had to make any
programming changes as a result of the switch?  The "we do not
anticipate any significant changes to your Web site integration" phrase
does not exactly comfort me, nor does the "on or after October 2, 2001"
part.  We currently are utilizing the CFX_CyberCash custom tag for all
of our CyberCash clients.  Will we need to change this or will this tag
continue to work after the transition?  In short, is there anything I
need to do between now and the 2nd?

Any experience anyone has had with this switch would be most
appreciated.  Thanks.

Kamie

--
Kamie B. Curfman
Macromedia Certified ColdFusion 5.0 Developer
Matrix Group International, Inc.
801 N. Fairfax Street, Suite 205
Alexandria, VA 22314
Phone: (703) 838-9777
Fax: (703) 838-9799
[EMAIL PROTECTED]
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Updating a multiple select box dynamically. question?

[Greg Luce]

I've accomplished the task by doing this, it displays the selected
values first in the list:


(First loop over the existing values for "linemaintenanceplanes" and
display them.)


#i#


(Then loop over the entire list of planes, and display them only if they
aren't in the list of "selected planes")


#misc1#

 


It seemed to fit the bill when you have a huge list also, so you don't
need to scroll through all 100 just to see what you have "selected"
already.

Greg Luce
954-763-4504


-Original Message-
From: Paul Ihrig [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, September 26, 2001 8:57 AM
To: CF-Talk
Subject: Updating a multiple select box dynamically. question?

Hello all.
i have a update page that has a Multiple Select box that i want to be
able
to dynamically up date.
now if there has only been one prior selection, then it shows up in the
update select box.
but if there has been more then one selection made, then nothing shows
up.

i hope you know what i mean!
any help would be great!
thanks
-paul

 
  
SELECTED>
 
#rs_Consultant_Types.Consultant_Types_Name#
  


-paul


~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Check out what Gartner is recommending. Drop IIS!

[Neil Clark]

You saying its hard to get a MS Cert :-) I agree that for workstations
Linux do seem a good choice - but lets be fair a nice little Server farm of
NT or Unix cant b beat and lets be fair - Linus has an awful haircut

~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Order by....

[Janine Jakim]

Thanks,
that's what I figured I'd have to do Yes there is a link-but it you have
to use a couple talbes(reference, etc). I just meant no direct link in
student table.

-Original Message-
From: Deanna Schneider [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 26, 2001 11:22 AM
To: CF-Talk
Subject: Re: Order by


You're going to need to re-think how this works. There must be some
connection between teacher and student in the database, yes? So, you'll need
to pull the teachers and students, grouped by teacher. Or, pull the teachers
and then do a subsequent query pulling all students with said teacher.

-d



Deanna Schneider
Interactive Media Developer
[EMAIL PROTECTED]



~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

OT: BLATANT ADVERTISING AND CROSS POSTING - You have been warned :-)

[Ben Forta]

Hi all,

Just wanted to let you that the new version of my Advanced ColdFusion book
is now available and shipping.

"Advanced Macromedia ColdFusion 5 Application Development" (published by
Macromedia Press in conjunction with Que, and coauthored by Dain Anderson,
Ben Elmore, Shawn Evans, Paul Hastings, Emily Kim, David Krasnove, Robert
Panico, Jeff Tapper, and Nate Weiss) covers scalability and
high-availability, security, UDF's (user defined functions, probably the
coolest new feature in CF5), Java integration, XML use, internationalization
and localization, extending and scripting Studio, and much more.

You can read more at http://www.forta.com/books/0789725851/, and can order
directly from Amazon.com at
http://www.amazon.com/exec/obidos/ISBN=0789725851/benfortascoldfusA/.

Enjoy!

--- Ben

==
Ben Forta - Macromedia Inc.
  E-Mail: [EMAIL PROTECTED]
  Phone:  (248)424-8420
  Fax:(248)424-8421
  Macromedia: http://www.macromedia.com/
  Allaire:http://www.allaire.com/
  Personal:   http://www.forta.com/
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

CFDIRECTORY replacements

[Bruce Holm]

My hosting company for my domain disables several CF tags for security 
reasons due to the server being shared.  These include CFDIRECTORY and 
CFFILE.

What replacements and workarounds do you use if you have the same type 
of limitation?

My hosting company already has "installed" the custom tags CFX_DIRECTORY 
and CFX_FILE (both version 1) and they don't work, either because they 
were installed wrong on the host server or because the tags don't 
actually work.

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


~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Passing the results from the

[Bruce Holm]

Using the session-scoped structure gives you the ability to transfer the
CFDIRECTORY results to the other template.  What you ask about now is how to
use the selection made to index into this structure.

I would have to see the code you use to create the menus.  As I recall,
those menus you pop up are done in JaveScript.  I already told you I'm not a
JS expert.  Someone else on the list may be able to help out but post your
code snippet (JS) on the list and ask the question.

What I do know about JS is that you need your JS function that manages the
menu item selection to return the value of the item selected.  I would use
an integer value and then directly use it to index into the structure key
list.

Bruce

- Original Message -
From: <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, September 26, 2001 4:13 AM
Subject: Re: Passing the results from the  Hi Bruce,
>
> How do I retrieve the information on the file that was clicked on the
> test.cfm page and pass that to the template.cfm
> to compare for a match and then pull the information from the array.
>
> I can't seem to get the Session.stDirFileName[menuSelection] to work?
>
> Output from test.cfm page
>
> [3] file1.dat
> [4] file2.dat
> [5] file3.dat
> [6] file4.dat
> [7] file5.dat
>
>
> Output from other template.cfm page
>
> [1] .
> [2] ..
> [3] file1.dat
> [4] file2.dat
> [5] file3.dat
> [6] file4.dat
> [7] file5.dat
>
>
>
> At 11:44 AM 9/24/01 -0700, you wrote:
> >Make sure you have session management activated...then
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > 
> > 
> > ...
> > 
> >
> >
> >Then on your other template page...
> >
> >The directory listing is:
> >
> >
> > #stDirFileName[RecNo]# #stDirFileSize[RecNo]#
> >
> >
> >Give that a whirl...this has not been tested, but should give you the
idea
> >on how to complete it.
> >
> >Bruce
> >[EMAIL PROTECTED]
> >
> >- Original Message -
> >From: <[EMAIL PROTECTED]>
> >To: "CF-Talk" <[EMAIL PROTECTED]>
> >Sent: Monday, September 24, 2001 10:32 AM
> >Subject: Re: Passing the results from the  >
> >
> > > At 10:28 AM 9/24/01 -0700, you wrote:
> > > >There are multiple ways to pass it.  What directory info are you
wanting
> >to
> > > >pass?
> > >
> > >
> > > All the information from the  Name, Type etc.
> > >
> > > >You can pass info from one template to another via:
> > > > Session vars
> > > > Client vars
> > > > Application vars
> > > > Form fields
> > > > URL parameters
> > > > etc
> > > >
> > > >You may want to store the directory info you want into a structure or
> >array,
> > > >scope it as a Session variable, then reference it on the next
template.
> > >
> > > Yikes. How do I do that?
> > >
> > >
> > > >Bruce
> > > >[EMAIL PROTECTED]
> > > >
> > > >- Original Message -
> > > >From: <[EMAIL PROTECTED]>
> > > >To: "CF-Talk" <[EMAIL PROTECTED]>
> > > >Sent: Monday, September 24, 2001 10:00 AM
> > > >Subject: Re: Passing the results from the  >template?
> > > >
> > > >
> > > > > How can I pass the results from the  > > > >
> > > > > Name
> > > > > Size
> > > > > Type..etc
> > > > >
> > > >
> > >
> >
> 
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Updating a multiple select box dynamically. question?

[Paul Ihrig]

any one?

-paul



-Original Message-
From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 26, 2001 9:24 AM
To: CF-Talk
Subject: RE: Updating a multiple select box dynamically. question?


nope that didn't work.
it will still only show 1 select but not more then that.

could it have some thing to do with that
Consultant_Types_ID.Consultant_Types_ID is a number
where Edit.Consultant_Types_ID is text?

i needed to make that field text so i could insert multiple numbers like
43, 2, 56 et.

-paul



-Original Message-
Replace multiple with multiple="yes"

-- 
Andrew Ewings

-Original Message-

 
  
SELECTED>
 
#rs_Consultant_Types.Consultant_Types_Name#
  

~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

ODBC error code

[Tristram Charnley]

Does anyone knows what this signifies?

ODBC Error Code = 22005 (Error in assignment)

(MS Access)

Tristram Charnley

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Highlight Script

[Duane Boudreau]

All you have to do is replace 



with



Duane

-Original Message-
From: Rich Tretola [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 26, 2001 4:35 PM
To: CF-Talk
Subject: Highlight Script


Does anyone know of a script that will work on a  tag like this one
that works on regular form tags?
http://www.dynamicdrive.com/dynamicindex11/highlightform.htm

Thansk,
Rich

~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: help with selectthreerelated

[ChristianWatt]

See if any of your data has a single quote (') or period (.).  I ran into
the same problem filling it with country, state, city.  A number of cities
had one or the other, as soon as I removed all quotes and periods, problem
solved.

Christian

-Original Message-
From: Janine Jakim [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 26, 2001 12:34 PM
To: CF-Talk
Subject: help with selectthreerelated


I'm using the custom tag  and can't get it to work
completely.  I can get the first two to drill down, but when I code in for
the 3rd box I get no results... the form comes up with all the labels etc,
but no data.  Sooo somehow I am not properly passing the variableor
somethingand I think I've been staring at it way too long.  
This is the query that makes the 3 select boxesThis is where I assume
the problem lies although I added the queries from my action page also...
Any help would be wonderful. Thanks,
j


SELECT AM.CRSTITLE, AS.GRADE,  
AS.LASTNAME, AS.FIRSTNAME, 
AS.GENDER, AC.CLASSLINK, 
AC.SCHOOLNUM, AC.TeachType, AS.PERMNUM, User.ULastName, User.UFirstName 
FROM AM INNER JOIN ((Users INNER JOIN AC
ON User.CLASSLINK = AC.CLASSLINK) INNER JOIN 
AS ON AC.PERMNUM = AS.PERMNUM)
ON (AM.SCHOOLNUM = AC.SCHOOLNUM) AND 
(AM.CLASSLINK = AC.CLASSLINK)
WHERE (((AC.TeachType) = 'H'))
AND AC.SCHOOLNUM=#CLIENT.SCHOOLNUM#
AND AM.TCHNUM=Users.TCHNUM  AND AC.CLASSLINK=AM.CLASSLINK
AND AC.PERMNUM =AS.PERMNUM
ORDER BY AS.GRADE, User.ULastName, 
AS.LASTNAME



NAME1="GRADE1"
NAME2="CLASSLINK1"
NAME3="NAME"
VALUE1="GRADE"
VALUE2="CLASSLINK"
VALUE3="PERMNUM"






SELECT cs.Skill, AS.GRADE, 
AC.CLASSLINK, AS.PERMNUM, AS.LASTNAME, 
AS.FIRSTNAME, cs.Skill, Grade.GradeForSubject, 
Grade.SkillID, Grade.GradingPeriod, AC.TeachType, 
cs.CourseID, cs.GradeLevel 
FROM ((AS INNER JOIN Grade ON 
AS.PERMNUM = Grade.PERMNUM) INNER JOIN tbl_cs ON 
Grade.SkillID = cs.SkillID) INNER JOIN AC ON 
AS.PERMNUM = AC.PERMNUM
WHERE AC.SCHOOLNUM=#CLIENT.SCHOOLNUM# AND 
 AC.TeachType='H' 
AND 
AS.GRADE='#Trim(Attributes.GRADE1)#' AND
AC.CLASSLINK=#VAL(attributes.CLASSLINK1)#
AND AS.PERM='#trim(Attributes.NAME)#'
ORDER BY AS.GRADE, AC.CLASSLINK, AS.LASTNAME, AS.FIRSTNAME, Grade.SkillID





SELECT SkillID, Skill, el.CourseID
FROM tbl_CourseSkill, el
WHERE el.CourseID =#CourseID#
AND GradeLevel='#GradeLevel#'
ORDER BY SkillID

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: double quotes

[Duane Boudreau]

When you insert/update character strings in a database the string is single
quoted:

INSERT INTO myTable(myField1, myField2)
VALUES (intValue, 'chrValue')



-Original Message-
From: Won Lee [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 26, 2001 3:27 PM
To: CF-Talk
Subject: double quotes


I have a text box.  When the user hits submit the data is either inserted
into the database or updates it.  When I input in a double quote, the insert
and update fail.

I know there is a perservesinglequotes function.  IS there something for a
double quote or do I have to parse through the whole text?

~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: ASP Vs. CF

[Carlisle, Eric]

http://www.houseoffusion.com/hof/body/asp.cfm
Try that.

EC


-Original Message-
From: Yager, Brian T Contractor/NCCIM
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 26, 2001 2:57 PM
To: CF-Talk
Subject: ASP Vs. CF


Does anyone have a presentation on ASP Vs. CF?  I have some but not enough
for
30-45 minutes.  I would like to present this for my next CFUG meeting.

Thanks,

Brian Yager
President - North AL Cold Fusion Users Group
Sr. Systems Analyst
NCCIM/CIC
[EMAIL PROTECTED]
(256) 842-8342

~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: ASP Vs. CF

[Bruce Sorge]

Go to http://www.houseoffusion.com and there is a comparison of CF and ASP.
- Original Message -
From: "Yager, Brian T Contractor/NCCIM" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, September 26, 2001 1:56 PM
Subject: ASP Vs. CF


> Does anyone have a presentation on ASP Vs. CF?  I have some but not enough
for
> 30-45 minutes.  I would like to present this for my next CFUG meeting.
>
> Thanks,
>
> Brian Yager
> President - North AL Cold Fusion Users Group
> Sr. Systems Analyst
> NCCIM/CIC
> [EMAIL PROTECTED]
> (256) 842-8342
> 
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

query/information display help

[Bruce, Rodney]

Hello all

I have a table that links when two pieces of equipment have been tested with
each other:

Equipmentid1Equipmentid2 Testid
 1  3   1
 1  4   2
 3  5   3


I need to pull this information to be displayed in a table, with the
equipment names displayed across the top and left side (same list for both).
Then the testid to be displayed within the table were the row/columns meet
of the tested equipment.

Problems:
1.  How to leave a blank were no test id goes (i.e.  equipment 1 was not
tested with equipment 2).
2.  Do display testid for both pieces of equipment.  The testid for
equipment 1 & 3 should be displayed twice,  once in equipment 1's row and
once in equipment 3's row.

Something like this:

Equip1 Equip2 Equip3 Equip4 Equip5
Equip1 1  2
Equip2
Equip3  1   3
Equip4  2 
Equip53



Right now all the tests ids are being displayed but with no blanks.
and the test for equipment 1 & 3 is only being listed on equipment 1's row.
I'm getting this:

Equip1 Equip2 Equip3 Equip4 Equip5
Equip1   1  2
Equip2
Equip3  3
Equip4 
Equip5

Can anyone help
thanks 
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Updating a multiple select box dynamically. question?

[Frank Priest]

Just noticed an extra > in my last post:-)

Try this




SELECTED>#rs_Consultant_Type
s.Consultant_Types_Name#


~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Updating a multiple select box dynamically. question?

[Frank Priest]

Try this Paul...




SELECTED>#rs_Consultant_Type
s.Consultant_Types_Name#



Frank



-Original Message-
From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 26, 2001 8:57 AM
To: CF-Talk
Subject: Updating a multiple select box dynamically. question?


Hello all.
i have a update page that has a Multiple Select box that i want to be able
to dynamically up date.
now if there has only been one prior selection, then it shows up in the
update select box.
but if there has been more then one selection made, then nothing shows up.

i hope you know what i mean!
any help would be great!
thanks
-paul


  
SELECTED>

#rs_Consultant_Types.Consultant_Types_Name#
  


-paul


~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: bug with files ending in "Application.cfm"?

[Matthew W Jones]

I have had no problems including files that end with application.cfm
such as test_application.cfm.  I haven't tried to call the files directly
though.

-Original Message-
From: Tilbrook, Peter [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 25, 2001 7:40 PM
To: CF-Talk
Subject: RE: bug with files ending in "Application.cfm"?


Found a weird bug in Coldfusion to do with files ending in
"Application.cfm". I have a file called "AccountApplication.cfm" and
when called, it produces the "Invalid Request of APPLICATION.CFM or
ONREQUESTEND.CFM File" error.

>>CF doesn't allow you to directly call application.cfm

>>Not sure about the other error - try renaming it to AccountApp.cfm.

Now, if I directly call Application.cfm thru Coldfusion I get the above
error, but I shouldn't get it with files ending in application.cfm.

Anyone seen this bug before, know of a workaround (besides renaming the
file) or something?

Thanks,
-- 

Cameron

If I cannot do great things, I can do small things in a great way. -Dr.
Martin Luther King
Violence is the last refuge of the incompetent - Isaac Asimov

FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=sts


**

This transmission is intended only for the use of the addressee(s)
and may contain confidential or legally privileged information. If you are
not the intended recipient, you are notified that any use or dissemination
of this communication is strictly prohibited. If you have received this
transmission in error, please notify the ANZFA IT helpdesk prior to deleting
all copies of this transmission together with any attachments.

ANZFA helpdesk:

E-mail:  [EMAIL PROTECTED]
This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com

~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: "disable back button"

[Critter]

Hello Todd,

on the preceding pages.

history.forward();



-- 
Critter, MMCP
Certified ColdFusion Developer

Crit[s2k] - 
---
Wednesday, September 26, 2001, 2:17:25 PM, you wrote:

TA> I have an app that I don't want people backing up in.  I've disabled the 
TA> tool bar, the right and middle mouse buttons, and all keypress 
TA> combinations on the keyboard.  The only problem is that the backspace 
TA> key will still work.  The app sees the backspace keypress event and 
TA> calls the function, but when the user clicks OK on the alert box, the 
TA> app still backs up.  Is there any way I can interrupt that process?

TA> Todd



TA> 
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

"disable back button"

[Todd Ashworth]

I have an app that I don't want people backing up in.  I've disabled the 
tool bar, the right and middle mouse buttons, and all keypress 
combinations on the keyboard.  The only problem is that the backspace 
key will still work.  The app sees the backspace keypress event and 
calls the function, but when the user clicks OK on the alert box, the 
app still backs up.  Is there any way I can interrupt that process?

Todd



~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Internet Faxing Service

[Stephen Hait]

I've used eFax since Feb, 1999. It has worked well for me.

Stephen

> Hey Gang,
> 
> Is anyone here using an internet faxing service? I've looked at eFax
> and EasyLink, but I would like to get some recommendations if there
> are any.
> 
> Thanks,
> Duane
> 
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

XML-XSL-CF_SOXML

[Timur Catakli]

Hi everybody,
my question is simple :
I have an XML and a XSL file.
XSL file is formatted in a way that it outputs HTML tags.
I am using CF_SOXML custom tag to transform the XSL file into a CF file.

But whenever I do that, the transformation returns XSL tags. I checked
http://forums.siteobjects.com for a solution but couldn't find anything. I
am using MSXML 2.0+.
So my question is (which was simple, remember) :
What are other ways to transform XML and XSL into HTML using Cold Fusion and
MSXML DOM object.
Are there other people that used SOXML and succeded ?

Thanks guys and have a great day. Bye


Timur Catakli
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CFDIRECTORY replacements

[Mark Stewart]

1. Talk to the hosting company and see if they'll rectify the problem
with the broken tags.

or

2. Do that piece of logic in another language like Perl. Perl's much
better at traversing directories and doing complex file manipulations
anyway.

Mark

-Original Message-
From: Bruce Holm [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 26, 2001 11:44 AM
To: CF-Talk
Subject: CFDIRECTORY replacements


My hosting company for my domain disables several CF tags for security 
reasons due to the server being shared.  These include CFDIRECTORY and 
CFFILE.

What replacements and workarounds do you use if you have the same type 
of limitation?

My hosting company already has "installed" the custom tags CFX_DIRECTORY

and CFX_FILE (both version 1) and they don't work, either because they 
were installed wrong on the host server or because the tags don't 
actually work.

-
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
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Updating a multiple select box dynamically. question?

[Deanna Schneider]

Try this:


  
SELECTED>

#rs_Consultant_Types.Consultant_Types_Name#
  



Deanna Schneider
Interactive Media Developer
[EMAIL PROTECTED]


~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Cold Fusion upgrade

[Mark Campbell]

Mike, I too have migrated everything over to 5.0. This has been a much needed
and welcome upgrade. I haven't had any problems with the new version.
Mark Campbell

Bruce Sorge wrote:

> I have migrated several applications that were running on CF4.0 to 5.0, and
> they all run just fine. However, you should be aware that there is no
> upgrade from 4.0 to 5. You will have to remove 4.0 from the server, then
> install 5.0. Also, if you are running the upgrade version, you will need to
> have the CD key for your 4.0 version handy.
> - Original Message -
> From: "Mike Tangorre" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Tuesday, September 25, 2001 7:28 PM
> Subject: Cold Fusion upgrade
>
> > Does anyone know of any issues that exist when upgrading from CF 4.01 to
> > CF 5.0? Unfortunately our company never got 4.5 and now they decided we
> > "need" 5.0. I wanna become familiar with any issues we might be facing.
> >
> > Thanks.
> >
> > Mike Tangorre
> >
> >
> 
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Help with CFMail

[Omar Salas Lieves]

Hello,

I'm using the following piece of code to send a notification e-mail:



xxx




For some reason, the e-mail notification is sent twice. I don't know
how. Did anybody have a similar issue?

Any help is appreciated.

Thanks in advance

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Check out what Gartner is recommending. Drop IIS!

[Jeffry Houser]

At 11:15 AM 09/26/2001 -0400, you wrote:
> >>the Microsoft people are FAR FAR MORE intelligent than these Open Source
>chaps and chapesses.
>
>Microsoft only has so many developers when the open source world pulls from
>unlimited numbers of developers all with there own backgrounds and
>experience to add.  In addition to that, everyone is freely avaiable to
>review the source code, so you get many more eyes catching bugs or
>potentialy exploits.

  My one thing to add here is that...
  I will give Microsoft credit for being a lot more organized than the open 
source chaps.  I think they both have benefits.


> >>The truth of it is, most "New Media" work requires Windows Based software
>
>Most of the motion picture industry in moving/moved in the linux direction.
>Dreamworks and ILM are now running linux for workstations and there
>rendering farms.

  I know at my last full-time job, they had an SGI (Silicon Graphics I 
forget what the I stands for) which was used for rendering 3D images. I 
seem to remember the operating system being some UNIX variant; but I never 
used the system myself.
  I thought that the BE OS was a specialized (or optimized) OS for digital 
media (such as touching up film on a movie) but once again I'm not an 
expert here.
   If by 'new media' you meant something on the web...  I think that an end 
resultant file that will run in Windows Media Player would be an ideal goal.



--
Jeffry Houser | mailto:[EMAIL PROTECTED]
AIM: Reboog711  | ICQ: 5246969 | Fax / Phone: 860-223-7946
--
I'm looking for a room-mate in the Hartford CT area, starting in October
--
DotComIt: Database Driven Web Data
My Book: Instant ColdFusion 5.0  | http://www.instantcoldfusion.com
--
Far Cry Fly, Alternative Folk Rock
http://www.farcryfly.com | http://www.mp3.com/FarCryFly
--
A friend is someone who knows how to spell your name.
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Passing the results from the

[phumes1]

Now I'm really confused.

All the javascript menu does is load different template files.

I need to pass the filename that the user clicks on from the list created 
by the ...
and your array stuff to the template that the menu loads.


Attached is my code.

Any help would be greatly appreciated.

At 08:38 AM 9/26/01 -0700, you wrote:
>Using the session-scoped structure gives you the ability to transfer the
>CFDIRECTORY results to the other template.  What you ask about now is how to
>use the selection made to index into this structure.
>
>I would have to see the code you use to create the menus.  As I recall,
>those menus you pop up are done in JaveScript.  I already told you I'm not a
>JS expert.  Someone else on the list may be able to help out but post your
>code snippet (JS) on the list and ask the question.
>
>What I do know about JS is that you need your JS function that manages the
>menu item selection to return the value of the item selected.  I would use
>an integer value and then directly use it to index into the structure key
>list.
>
>Bruce
>
>- Original Message -
>From: <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Wednesday, September 26, 2001 4:13 AM
>Subject: Re: Passing the results from the 
>
> > Hi Bruce,
> >
> > How do I retrieve the information on the file that was clicked on the
> > test.cfm page and pass that to the template.cfm
> > to compare for a match and then pull the information from the array.
> >
> > I can't seem to get the Session.stDirFileName[menuSelection] to work?
> >
> > Output from test.cfm page
> >
> > [3] file1.dat
> > [4] file2.dat
> > [5] file3.dat
> > [6] file4.dat
> > [7] file5.dat
> >
> >
> > Output from other template.cfm page
> >
> > [1] .
> > [2] ..
> > [3] file1.dat
> > [4] file2.dat
> > [5] file3.dat
> > [6] file4.dat
> > [7] file5.dat
> >
> >
> >
> > At 11:44 AM 9/24/01 -0700, you wrote:
> > >Make sure you have session management activated...then
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > 
> > > 
> > > ...
> > > 
> > >
> > >
> > >Then on your other template page...
> > >
> > >The directory listing is:
> > >
> > >
> > > #stDirFileName[RecNo]# #stDirFileSize[RecNo]#
> > >
> > >
> > >Give that a whirl...this has not been tested, but should give you the
>idea
> > >on how to complete it.
> > >
> > >Bruce
> > >[EMAIL PROTECTED]
> > >
> > >- Original Message -
> > >From: <[EMAIL PROTECTED]>
> > >To: "CF-Talk" <[EMAIL PROTECTED]>
> > >Sent: Monday, September 24, 2001 10:32 AM
> > >Subject: Re: Passing the results from the template?
> > >
> > >
> > > > At 10:28 AM 9/24/01 -0700, you wrote:
> > > > >There are multiple ways to pass it.  What directory info are you
>wanting
> > >to
> > > > >pass?
> > > >
> > > >
> > > > All the information from the  Name, Type etc.
> > > >
> > > > >You can pass info from one template to another via:
> > > > > Session vars
> > > > > Client vars
> > > > > Application vars
> > > > > Form fields
> > > > > URL parameters
> > > > > etc
> > > > >
> > > > >You may want to store the directory info you want into a structure or
> > >array,
> > > > >scope it as a Session variable, then reference it on the next
>template.
> > > >
> > > > Yikes. How do I do that?
> > > >
> > > >
> > > > >Bruce
> > > > >[EMAIL PROTECTED]
> > > > >
> > > > >- Original Message -
> > > > >From: <[EMAIL PROTECTED]>
> > > > >To: "CF-Talk" <[EMAIL PROTECTED]>
> > > > >Sent: Monday, September 24, 2001 10:00 AM
> > > > >Subject: Re: Passing the results from the  > >template?
> > > > >
> > > > >
> > > > > > How can I pass the results from the template?
> > > > > >
> > > > > > Name
> > > > > > Size
> > > > > > Type..etc
> > > > > >
> > > > >
> > > >
> > >
> >
>
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Calling Custom Tag

[Dave Watts]

> i have a custom tag named textinput in custom tags
> directory.I am calling the custom tag from a
> default.cfm file from webroot folder.The webroot
> folder also has a file named textinput.cfm.
> Now which file would the default.cfm call whether the
> file in webroot folder or in custom tags directory.
> 
> Or in other words what is the precedence in calling
> custom tags.

When you use



ColdFusion will look in the following locations in the respective order
listed:

1. The same directory as the calling page.
2. The first global custom tags directory (typically C:\CFUSION\CustomTags)
3. Any subdirectories within (2).
4. The second global custom tags directory, if there is one - CF 5 allows
you to add multiple global custom tag directories within CF Administrator,
CF 4 allows you to do this by editing the Registry directly.
5. Any subdirectories within (4).

If there are more than two global custom tag directories, repeat (4) and (5)
for each additional one.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: ODBC error code

[Pete Freitag]

Are you using any reserved words? send your query.

+++
Pete Freitag ([EMAIL PROTECTED])
CFDEV.COM
ColdFusion Developer Resources
http://www.cfdev.com/


-Original Message-
From: Tristram Charnley [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 26, 2001 12:12 PM
To: CF-Talk
Subject: ODBC error code


Does anyone knows what this signifies?

ODBC Error Code = 22005 (Error in assignment)

(MS Access)

Tristram Charnley


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Help with CFMail

[Dave Watts]

> I'm using the following piece of code to send a notification e-mail:
> 
> 
>from="#application.companyemail#">
>   xxx
>   
>   
> 
> 
> For some reason, the e-mail notification is sent twice. I don't know
> how. Did anybody have a similar issue?

In the calling page, are you closing the custom tag?




If so, you're executing the custom tag twice. When you close a custom tag,
it'll execute once for the opening tag, and once for the closing tag. Within
the custom tag, you can check the variable ThisTag.ExecutionMode - if it's
"start", you're executing the opening tag, and if it's "end", you're
executing the closing tag. So, you can simply add some conditional logic to
your custom tag to only send the mail once.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Check out what Gartner is recommending. Drop IIS!

[Costas Piliotis]

You start off making some valid points.  However.

Regarding patching:  you're telling me there's never been an apache patch?
How about an iPlanet patch?  And you can apply it without restarting any
daemons?  Right.  No Apache patches.  Ever.  They come perfect, right out of
the box, every time.  I think they DO have patches, they just call them
REVISIONS.

Regarding reboot while patching IIS:  three days out of 90.  Not bad.  One
day a month maintaining an IIS box.  Big deal. 

The TV analogy:  Ever seen the watch that will serve as a remote control?
We still buy the tv.  People can hack cell phone calls, yet we still used
them.  Phone lines can be tapped, we still use the phone.  My car got broken
into last week.  The autobody shop said "Locks are meant to keep honest
people out".  If someone wants in, really, they'll get in eventually.  You
can't stop them.  You can only make the effort to keep it difficult.

I like what they said in "the score": If Someone built it, it can be taken
apart.  Don't for a second think that *nix is any more secure than WinBlows.

Nobody has forced you to accept "appalingly poor quality software simply
because the majority don't know".  The majority DOES know I'm afraid.  If
YOU don't like it, switch professions.  Be thankful you have a job.  I am.
Without this majority, there wouldn't be the need for IT professionals.
That's the way the world works.  It's not like a virus has never been
written for *nix, or a worm, or a DoS attack, or bad code.  It's a way of
life in IT.


-Original Message-
From: Toby Tremayne [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, September 25, 2001 10:02 PM
To: CF-Talk
Subject: Re: Check out what Gartner is recommending. Drop IIS!



I'm sorry - I've been avoiding it but I have to jump in here...

I keep reading on this list and others, and in so many news articles about
windows only being targeted because it's the most popular, and about it
being down to irresponsible admins etc etc.  Both of these points are in
some ways valid, but to me these people seem to be missing the point.

   Yes, less of this would happen if admins were responsible and used all
the latest patches etc etc.  But what am I missing here -why is it nobody
seems to see that the entire concept of windows and iis patches is the
problem in the first place - we need to patch our servers because they are
a)in some places so pathetically coded and/or untested that they break down
and let all kinds of nonsecure access through and b)at development time it
is obviously decided that security is not cost effective to implement.

These worms are all aimed at the fact that explorer/iis/outlook let you
arbitrarily execute all kinds of foreign code or local commands without any
kind of checking or restraint whatsoever.  And yes perhaps there are patches
for the majority of these - but they should never have been released
requiring those patches in the first place.  Windows is targetted not purely
because of it's market share but because it makes possible the functions of
these worms.  I don't agree with the idea that there are more windows based
hackers than unix based hackers - the thought is ludicrous - and it makes
little difference.  You don't need any great level of expertise to write one
of these things, and as bad as the last year or two have become it's
astounding there aren't more of them.  And still microsoft continues to
release software with these vulnerabilities coded into them - and we
continue to buy them.

Look at it this way, if someone made a television that did all the
normal stuff, but had an extra "feature" that let anyone arbitrarily connect
to it and start changing your channels, you'd never buy it.  And if you'd
already bought it and later found out, you'd kick up an enormous stink.  It
ought to be no different with software - especially software that's mission
critical and costs you large sums of money when it fails - not to mention
inadvertently hammering the daylights out of *other* people's software
without you being able to stop it.

These are just my opinions, but I'm seriously tired of the fact that we
who know better get forced to accept appalingly poor quality software simply
because the majority don't know or care what the problems are and follow the
upgrade paths dished out to them.  We don't help this situation any when we
let these kind of arguments ride without pointing out the truth.



cheers,

Toby
P.S.  Just for the record, I too run Win2K, IIS, AND Linux


 Life is poetry, write it in your own words



Toby Tremayne
Architect / Developer
Code Poet and Zen Master of the Heavy Sleep
MercuryRed
Lvl 9, 123 Queen st
Melbourne
VIC 3000
p: +61 3 9605 5035
m: +61 416 048 090
ICQ: 13107913

help with selectthreerelated

[Janine Jakim]

I'm using the custom tag  and can't get it to work
completely.  I can get the first two to drill down, but when I code in for
the 3rd box I get no results... the form comes up with all the labels etc,
but no data.  Sooo somehow I am not properly passing the variableor
somethingand I think I've been staring at it way too long.  
This is the query that makes the 3 select boxesThis is where I assume
the problem lies although I added the queries from my action page also...
Any help would be wonderful. Thanks,
j


SELECT AM.CRSTITLE, AS.GRADE,  
AS.LASTNAME, AS.FIRSTNAME, 
AS.GENDER, AC.CLASSLINK, 
AC.SCHOOLNUM, AC.TeachType, AS.PERMNUM, User.ULastName, User.UFirstName 
FROM AM INNER JOIN ((Users INNER JOIN AC
ON User.CLASSLINK = AC.CLASSLINK) INNER JOIN 
AS ON AC.PERMNUM = AS.PERMNUM)
ON (AM.SCHOOLNUM = AC.SCHOOLNUM) AND 
(AM.CLASSLINK = AC.CLASSLINK)
WHERE (((AC.TeachType) = 'H'))
AND AC.SCHOOLNUM=#CLIENT.SCHOOLNUM#
AND AM.TCHNUM=Users.TCHNUM  AND AC.CLASSLINK=AM.CLASSLINK
AND AC.PERMNUM =AS.PERMNUM
ORDER BY AS.GRADE, User.ULastName, 
AS.LASTNAME



NAME1="GRADE1"
NAME2="CLASSLINK1"
NAME3="NAME"
VALUE1="GRADE"
VALUE2="CLASSLINK"
VALUE3="PERMNUM"






SELECT cs.Skill, AS.GRADE, 
AC.CLASSLINK, AS.PERMNUM, AS.LASTNAME, 
AS.FIRSTNAME, cs.Skill, Grade.GradeForSubject, 
Grade.SkillID, Grade.GradingPeriod, AC.TeachType, 
cs.CourseID, cs.GradeLevel 
FROM ((AS INNER JOIN Grade ON 
AS.PERMNUM = Grade.PERMNUM) INNER JOIN tbl_cs ON 
Grade.SkillID = cs.SkillID) INNER JOIN AC ON 
AS.PERMNUM = AC.PERMNUM
WHERE AC.SCHOOLNUM=#CLIENT.SCHOOLNUM# AND 
 AC.TeachType='H' 
AND 
AS.GRADE='#Trim(Attributes.GRADE1)#' AND
AC.CLASSLINK=#VAL(attributes.CLASSLINK1)#
AND AS.PERM='#trim(Attributes.NAME)#'
ORDER BY AS.GRADE, AC.CLASSLINK, AS.LASTNAME, AS.FIRSTNAME, Grade.SkillID





SELECT SkillID, Skill, el.CourseID
FROM tbl_CourseSkill, el
WHERE el.CourseID =#CourseID#
AND GradeLevel='#GradeLevel#'
ORDER BY SkillID
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Help with CFMail

[Omar Salas Lieves]

Actually,

I'm not calling the e-mail code using a custom tag. It's the action
page. I'm submitting the logTran field, test if it's equal to yes and
run the CFMAIL tag.

Thanks again for any help.

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, September 26, 2001 12:43 PM
To: CF-Talk
Subject: RE: Help with CFMail

> I'm using the following piece of code to send a notification e-mail:
>
> 
>from="#application.companyemail#">
>   xxx
>   
>   
> 
>
> For some reason, the e-mail notification is sent twice. I don't know
> how. Did anybody have a similar issue?

In the calling page, are you closing the custom tag?




If so, you're executing the custom tag twice. When you close a custom
tag,
it'll execute once for the opening tag, and once for the closing tag.
Within
the custom tag, you can check the variable ThisTag.ExecutionMode - if
it's
"start", you're executing the opening tag, and if it's "end", you're
executing the closing tag. So, you can simply add some conditional logic
to
your custom tag to only send the mail once.

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

~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: "disable back button"

[Timur Catakli]

Hi Todd,
I don't know if I am passing you the information you need but you might want
to go to
http://www.netshift.com/support/su_u.html
and check for NT Key Blocking Utility...

Thanks

***
Timur Catakli
Senior e-Business Developer
Langtech Systems Consulting
[EMAIL PROTECTED]
415 928 6064 ext.604
***

-Original Message-
From: Todd Ashworth [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 26, 2001 11:17 AM
To: CF-Talk
Subject: "disable back button"


I have an app that I don't want people backing up in.  I've disabled the
tool bar, the right and middle mouse buttons, and all keypress
combinations on the keyboard.  The only problem is that the backspace
key will still work.  The app sees the backspace keypress event and
calls the function, but when the user clicks OK on the alert box, the
app still backs up.  Is there any way I can interrupt that process?

Todd




~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

ASP Vs. CF

[Yager, Brian T Contractor/NCCIM]

Does anyone have a presentation on ASP Vs. CF?  I have some but not enough for
30-45 minutes.  I would like to present this for my next CFUG meeting.

Thanks,

Brian Yager
President - North AL Cold Fusion Users Group
Sr. Systems Analyst
NCCIM/CIC
[EMAIL PROTECTED]
(256) 842-8342
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

double quotes

[Won Lee]

I have a text box.  When the user hits submit the data is either inserted
into the database or updates it.  When I input in a double quote, the insert
and update fail.

I know there is a perservesinglequotes function.  IS there something for a
double quote or do I have to parse through the whole text?
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Apache VS IIS Speed revisted, here is a utility to test

[Robert Everland]

Ok I got this utility from tomcatsoftware that makes a prodict
similar to CF. It is supposed to test page response time. If you run IIS and
Apache please run it so we can get an idea of how much of a difference these
things are. http://www.tomahawktech.com/downloads/HTTPTester.zip

Robert Everland III
Dixon Ticonderoga
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Highlight Script

[Rich Tretola]

Does anyone know of a script that will work on a  tag like this one
that works on regular form tags?
http://www.dynamicdrive.com/dynamicindex11/highlightform.htm

Thansk,
Rich
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Highlight Script

[Dave Watts]

> Does anyone know of a script that will work on a  tag 
> like this one that works on regular form tags?
> http://www.dynamicdrive.com/dynamicindex11/highlightform.htm

I haven't tried using this script specifically, but you should be able to
use it with CFFORM by simply using the PASSTHROUGH attribute to pass the
ONCLICK event handler information:



Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Long client var in Oracle [was: WDDX]

[Chris Norloff]

Thanks!  That looks good.

Do you figure this will work with client variables and writing right to the CDATA 
table?  Or would it be best to use a different table and not use CF's client variables?

I ask because if I manually write a variable to the CDATA table, then I wonder if CF 
would just write over it when it saves all the client variables at the end of the page 
request.

thanks,
Chris Norloff

-- Original Message --
from: "Deanna Schneider" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
date: Tue, 25 Sep 2001 12:58:35 -0500

>I believe that you just have to use a  tag to insert long
>or clob data into oracle - something like
>password="#pword#">
>INSERT INTO longtest(clientvars)
>VALUES(value="#cfclientvariables#">)
>
>
>cfclientvariables would be the variable name of the client variables you are
>inserting. I just tried this on our setup and it worked great.
>
>-Deanna
>
>
>
>
>Deanna Schneider
>Interactive Media Developer
>[EMAIL PROTECTED]
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: help with selectthreerelated

[Janine Jakim]

No I know there aren't any periods/single quotes.  However, it's a set text
field that has empty spaces.  So if you look at the screen and see the
number 7666 and you run a query to find 7666 you'll come up blank unless you
put in the correct number of spaces before it. ie: -7666.  Could that be
it?  It's something I can't change because it comes from a separate
databasehmmm

-Original Message-
From: ChristianWatt [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 26, 2001 4:30 PM
To: CF-Talk
Subject: RE: help with selectthreerelated


See if any of your data has a single quote (') or period (.).  I ran into
the same problem filling it with country, state, city.  A number of cities
had one or the other, as soon as I removed all quotes and periods, problem
solved.

Christian

-Original Message-
From: Janine Jakim [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 26, 2001 12:34 PM
To: CF-Talk
Subject: help with selectthreerelated


I'm using the custom tag  and can't get it to work
completely.  I can get the first two to drill down, but when I code in for
the 3rd box I get no results... the form comes up with all the labels etc,
but no data.  Sooo somehow I am not properly passing the variableor
somethingand I think I've been staring at it way too long.  
This is the query that makes the 3 select boxesThis is where I assume
the problem lies although I added the queries from my action page also...
Any help would be wonderful. Thanks,
j


SELECT AM.CRSTITLE, AS.GRADE,  
AS.LASTNAME, AS.FIRSTNAME, 
AS.GENDER, AC.CLASSLINK, 
AC.SCHOOLNUM, AC.TeachType, AS.PERMNUM, User.ULastName, User.UFirstName 
FROM AM INNER JOIN ((Users INNER JOIN AC
ON User.CLASSLINK = AC.CLASSLINK) INNER JOIN 
AS ON AC.PERMNUM = AS.PERMNUM)
ON (AM.SCHOOLNUM = AC.SCHOOLNUM) AND 
(AM.CLASSLINK = AC.CLASSLINK)
WHERE (((AC.TeachType) = 'H'))
AND AC.SCHOOLNUM=#CLIENT.SCHOOLNUM#
AND AM.TCHNUM=Users.TCHNUM  AND AC.CLASSLINK=AM.CLASSLINK
AND AC.PERMNUM =AS.PERMNUM
ORDER BY AS.GRADE, User.ULastName, 
AS.LASTNAME



NAME1="GRADE1"
NAME2="CLASSLINK1"
NAME3="NAME"
VALUE1="GRADE"
VALUE2="CLASSLINK"
VALUE3="PERMNUM"






SELECT cs.Skill, AS.GRADE, 
AC.CLASSLINK, AS.PERMNUM, AS.LASTNAME, 
AS.FIRSTNAME, cs.Skill, Grade.GradeForSubject, 
Grade.SkillID, Grade.GradingPeriod, AC.TeachType, 
cs.CourseID, cs.GradeLevel 
FROM ((AS INNER JOIN Grade ON 
AS.PERMNUM = Grade.PERMNUM) INNER JOIN tbl_cs ON 
Grade.SkillID = cs.SkillID) INNER JOIN AC ON 
AS.PERMNUM = AC.PERMNUM
WHERE AC.SCHOOLNUM=#CLIENT.SCHOOLNUM# AND 
 AC.TeachType='H' 
AND 
AS.GRADE='#Trim(Attributes.GRADE1)#' AND
AC.CLASSLINK=#VAL(attributes.CLASSLINK1)#
AND AS.PERM='#trim(Attributes.NAME)#'
ORDER BY AS.GRADE, AC.CLASSLINK, AS.LASTNAME, AS.FIRSTNAME, Grade.SkillID





SELECT SkillID, Skill, el.CourseID
FROM tbl_CourseSkill, el
WHERE el.CourseID =#CourseID#
AND GradeLevel='#GradeLevel#'
ORDER BY SkillID


~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: "disable back button"

[Billy Cravens]

To expand on what Critter said, try:




Untitled 


   





---
Billy Cravens
Web Development, EDS
[EMAIL PROTECTED]


-Original Message-
From: Critter [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, September 26, 2001 1:27 PM
To: CF-Talk
Subject: Re: "disable back button"


Hello Todd,

on the preceding pages.

history.forward();



-- 
Critter, MMCP
Certified ColdFusion Developer

Crit[s2k] - 
---
Wednesday, September 26, 2001, 2:17:25 PM, you wrote:

TA> I have an app that I don't want people backing up in.  I've disabled

TA> the
TA> tool bar, the right and middle mouse buttons, and all keypress 
TA> combinations on the keyboard.  The only problem is that the
backspace 
TA> key will still work.  The app sees the backspace keypress event and 
TA> calls the function, but when the user clicks OK on the alert box,
the 
TA> app still backs up.  Is there any way I can interrupt that process?

TA> Todd



TA> 

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Updating a multiple select box dynamically. question?

[Dave Watts]

> i have a update page that has a Multiple Select box that i 
> want to be able to dynamically up date. now if there has only 
> been one prior selection, then it shows up in the update 
> select box. but if there has been more then one selection 
> made, then nothing shows up.
> 
>  
>   
>  value="#rs_Consultant_Types.Consultant_Types_ID# output>" 
>  #edit.Consultant_Types_ID#)>SELECTED>
>  
> #rs_Consultant_Types.Consultant_Types_Name# t>
>   
> 

If you have more than one value that should be selected, you should be
checking the current value that you're looping over against a list of
selected values. Let's assume that the list of selected values is contained
in a variable My_Consultant_Types_List. If so, you could use ListFind to
mark the appropriate items as selected:

 SELECTED

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CyberCash to VeriSign

[Jim McAtee]

Someone on another list said that the API is mostly unchanged.  Support of
online check payments has been dropped, however.

Jim


- Original Message -
From: "Kamie Curfman" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, September 26, 2001 9:27 AM
Subject: CyberCash to VeriSign


> One of my clients just received the below notice yesterday from
> VeriSign:
>
> "IMPORTANT CYBERCASH MIGRATION NOTICE:
> Our records show that you are currently registered to process payments
> through the CyberCash payment gateway.
>
> Your account is currently scheduled for migration to VeriSign's Payflow
> (SM) service on or after October 2, 2001.

~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Updating a multiple select box dynamically. question?

[Dave Watts]

> > 
>
> Replace multiple with multiple="yes"

Actually, that's not necessary. The MULTIPLE attribute of the HTML SELECT
tag is a Boolean attribute, and those don't require explicit values. There
are a few of these in HTML, such as the SELECTED attribute of OPTIONs and
the CHECKED attribute of checkboxes and radio buttons.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CFGRID problems in CF5 (need workaround)

[Dave Watts]

> I'm writing a new grid.  A super grid.  A grid with every 
> function I've wanted but Allaire has never put in.
> 
> I now possess enough Java knowledge to do this.
> 
> It shall be mine. Oh yes, it shall be mine.

There's no reason to go to all this trouble. I'm sure that there are already
plenty of Java grids with the features that you want - I know there are many
Java grids available from component companies, and many have almost the same
feature sets that the COM/ActiveX grids do.

What you'd have to do, though, is write the necessary CF custom tags to pass
data in and out of the grids.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Updating a multiple select box dynamically. question?

[Paul Ihrig]

Greg, thank You!
that worked like a charm!

really do appreciate it!
all i needed to change [on my insert form] was to insert the name, instead
of the number!
takes up a bit more room, but works!

thanks

p.s.
what is #i#?

-paul

-\




#i#





#Consultant_Types_Name#

 

---\


-Original Message-
From: Greg Luce [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 26, 2001 11:31 AM
To: CF-Talk
Subject: RE: Updating a multiple select box dynamically. question?


I've accomplished the task by doing this, it displays the selected
values first in the list:


(First loop over the existing values for "linemaintenanceplanes" and
display them.)


#i#


(Then loop over the entire list of planes, and display them only if they
aren't in the list of "selected planes")


#misc1#

 


It seemed to fit the bill when you have a huge list also, so you don't
need to scroll through all 100 just to see what you have "selected"
already.

Greg Luce
954-763-4504


-Original Message-
From: Paul Ihrig [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, September 26, 2001 8:57 AM
To: CF-Talk
Subject: Updating a multiple select box dynamically. question?

Hello all.
i have a update page that has a Multiple Select box that i want to be
able
to dynamically up date.
now if there has only been one prior selection, then it shows up in the
update select box.
but if there has been more then one selection made, then nothing shows
up.

i hope you know what i mean!
any help would be great!
thanks
-paul

 
  
SELECTED>
 
#rs_Consultant_Types.Consultant_Types_Name#
  


-paul



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: XML-XSL-CF_SOXML

[Nelson Winters]

Timur,

You should try posting your question on SiteObjects' forum?  Brett is
usually very helpful.

Nelson

- Original Message -
From: "Timur Catakli" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, September 26, 2001 1:56 PM
Subject: XML-XSL-CF_SOXML


> Hi everybody,
> my question is simple :
> I have an XML and a XSL file.
> XSL file is formatted in a way that it outputs HTML tags.
> I am using CF_SOXML custom tag to transform the XSL file into a CF file.
>
> But whenever I do that, the transformation returns XSL tags. I checked
> http://forums.siteobjects.com for a solution but couldn't find anything. I
> am using MSXML 2.0+.
> So my question is (which was simple, remember) :
> What are other ways to transform XML and XSL into HTML using Cold Fusion
and
> MSXML DOM object.
> Are there other people that used SOXML and succeded ?
>
> Thanks guys and have a great day. Bye
>
>
> Timur Catakli
> 
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Check out what Gartner is recommending. Drop IIS!

[Benjamin Falloon]

Amen.

- Original Message -
From: "Jeremy Allen" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, September 26, 2001 7:03 AM
Subject: RE: Check out what Gartner is recommending. Drop IIS!


> It is not reasonably difficult to secure a system against
> these worms. Every single security weakness Nimda exploited
> already had a patch. Our development server never missed
> a beat, and is publicly visible on the Internet.
>
> I do think security is mostly relative to your administrator,
> and somewhat on your operating system and web serving software.
> I think the human factor, as in the administrators, is the bigger
> issue here. Nothing against anyone but any good admin following
> procedure could have secured their systems against this.
>
> That said, IIS is thrust into the hands of unsuspecting users
> who are NOT system administrators. Your average business user
> does not have a clue about securing a NT system. Yet the tool
> is run by default and put into the hands of business users on
> fat net pipes. I also see it proliferate extremely virally on
> my DSL subnet. This says to me that people have IIS running
> and are probably not even aware they have been hit and are
> infecting others, of course this statement is largely based
> on assumptions, no other explanation works very well since the
> fixes for these worms were out before code red.
>
> Herein lies my real complaint with this situation. IIS should
> not be turned on and should not be used by people who know what
> they are doing. Microsoft helps propagate these kind of worms
> by insecure default configurations. Whereas, if you actually
> turn IIS on somehow, you probably have a much better clue
> about what your doing. Of course, I have seen default installations
> of RedHat come with remotely exploitable holes. Solaris with a
> default installation is a joke, pick your root kit and have at it.
>
> I do believe Apache is not *inherently* more secure. However
> I will raise a challenge to say that Apache tends to have
> less severe bugs, the frequency is less often, and you can
> fix the bug yourself, or quickly get a patch for it, without
> reliance on Microsoft. The architecture is generally more
> well known, and the software is at this point, rather nice.
> I run Apache on my W2K system at home, no remote exploits or
> even regular exploits to hit my machine, I am still waiting.
>
> So there will always be Microsoft hates, but whatever works. If
> your machines get hit by this a lot, and you lose a lot of time
> on stuff like this; hit the books and be sensible about using
> software, any software, on the Internet. Knowledge is the only
> real way to stop these kind of bugs from being proliferated. :-D
>
> Thanks
>
> Jeremy Allen
> elliptIQ Inc.
> -Original Message-
> From: Tony Gruen [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, September 25, 2001 4:44 PM
> To: CF-Talk
> Subject: RE: Check out what Gartner is recommending. Drop IIS!
>
>
> It comes down to responsible administration. We have watched this come and
> still going on without incident and several IIS servers.
>
> Tony Gruen
> sfnetworks
>
>
> 
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Highlight Script

[Tilbrook, Peter]

Try this:


//Highlight form element- © Dynamic Drive (www.dynamicdrive.com)
//For full source code, 100's more DHTML scripts, and TOS,
//visit http://www.dynamicdrive.com

var highlightcolor="lightyellow"

var ns6=document.getElementById&&!document.all
var previous=''
var eventobj

//Regular expression to highlight only form elements
var intended=/INPUT|TEXTAREA|SELECT|OPTION/

//Function to check whether element clicked is form element
function checkel(which){
if (which.style&&intended.test(which.tagName)){
if (ns6&&eventobj.nodeType==3)
eventobj=eventobj.parentNode.parentNode
return true
}
else
return false
}

//Function to highlight form element
function highlight(e){
eventobj=ns6? e.target : event.srcElement
if (previous!=''){
if (checkel(previous))
previous.style.backgroundColor=''
previous=eventobj
if (checkel(eventobj))
eventobj.style.backgroundColor=highlightcolor
}
else{
if (checkel(eventobj))
eventobj.style.backgroundColor=highlightcolor
previous=eventobj
}
}



Your CFFORM tag should look something like this:




Cheers!

Peter Tilbrook
ColdFusion Applications Developer
Australia New Zealand Food Authority
Boeing House
55 Blackall Street
BARTON ACT 2600
Ph: +61-2-6271-2671
Fax: +61-2-6271-2278

http://www.anzfa.gov.au



**

This transmission is intended only for the use of the addressee(s)
and may contain confidential or legally privileged information. If you are
not the intended recipient, you are notified that any use or dissemination
of this communication is strictly prohibited. If you have received this
transmission in error, please notify the ANZFA IT helpdesk prior to deleting
all copies of this transmission together with any attachments.

ANZFA helpdesk:

E-mail:  [EMAIL PROTECTED]
This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Highlight Script

[Mike Tangorre]

Neat!  :-)


- Original Message -
From: "Tilbrook, Peter" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, September 26, 2001 8:22 PM
Subject: RE: Highlight Script


> Try this:
>
> 
> //Highlight form element- © Dynamic Drive (www.dynamicdrive.com)
> //For full source code, 100's more DHTML scripts, and TOS,
> //visit http://www.dynamicdrive.com
>
> var highlightcolor="lightyellow"
>
> var ns6=document.getElementById&&!document.all
> var previous=''
> var eventobj
>
> //Regular expression to highlight only form elements
> var intended=/INPUT|TEXTAREA|SELECT|OPTION/
>
> //Function to check whether element clicked is form element
> function checkel(which){
> if (which.style&&intended.test(which.tagName)){
> if (ns6&&eventobj.nodeType==3)
> eventobj=eventobj.parentNode.parentNode
> return true
> }
> else
> return false
> }
>
> //Function to highlight form element
> function highlight(e){
> eventobj=ns6? e.target : event.srcElement
> if (previous!=''){
> if (checkel(previous))
> previous.style.backgroundColor=''
> previous=eventobj
> if (checkel(eventobj))
> eventobj.style.backgroundColor=highlightcolor
> }
> else{
> if (checkel(eventobj))
> eventobj.style.backgroundColor=highlightcolor
> previous=eventobj
> }
> }
> 
>
>
> Your CFFORM tag should look something like this:
>
>  enctype="multipart/form-data"  passthrough="onClick='highlight(event)
> '">
> 
>
> Cheers!
>
> Peter Tilbrook
> ColdFusion Applications Developer
> Australia New Zealand Food Authority
> Boeing House
> 55 Blackall Street
> BARTON ACT 2600
> Ph: +61-2-6271-2671
> Fax: +61-2-6271-2278
>
> http://www.anzfa.gov.au
>
>
>
> **
>
> This transmission is intended only for the use of the addressee(s)
> and may contain confidential or legally privileged information. If you are
> not the intended recipient, you are notified that any use or dissemination
> of this communication is strictly prohibited. If you have received this
> transmission in error, please notify the ANZFA IT helpdesk prior to
deleting
> all copies of this transmission together with any attachments.
>
> ANZFA helpdesk:
>
> E-mail:  [EMAIL PROTECTED]
> This footnote also confirms that this email message has been swept by
> MIMEsweeper for the presence of computer viruses.
>
> www.mimesweeper.com
> 
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists