RE: how to retrieving data by age of record in MSSQL

[Sicular, Alexander]

oops change day to yy or 

-Original Message-
From: Sicular, Alexander [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 11:47 PM
To: CF-Talk
Subject: RE: how to retrieving data by age of record in MSSQL


Something like

Select * from mytableostuff
Where salesdate > 'DATEADD(day, -5, getdate())'

Gl,

Alexander Sicular
Chief Technology Architect
Neurological Institute of New York
Columbia University
as867 [at] columbia {dot} edu


|-Original Message-
|From: han peng [mailto:[EMAIL PROTECTED]] 
|Sent: Thursday, March 21, 2002 11:49 PM
|To: CF-Talk
|Subject: how to retrieving data by age of record in MSSQL
|
|
|hihi..all gurus.. i know this is not appropriate here... sorry 
|to bother u all  i need to write a query to retrieve 
|existing records by age of the records..
|
|
|eg. user want to see Sales orders that are  5 yrs old..
|
|so i need to write a query to retrieve from sales table.. 
|where theres a orderdate column int it.. datatype is datetime.
|
|so how am i going to write the query in mssql..??
| oracle can use trunc() .. but mssql dont hav that... :(
|
|help help..
|
|hanpeng
|
|

__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
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: how to retrieving data by age of record in MSSQL

[Paul Giesenhagen]

select columnames
from tablename
where orderdate < #variables.olddate#


that should do ya up!

Paul Giesenhagen
QuillDesign
http://www.quilldesign.com
SiteDirector v2.0 - Commerce Builder



- Original Message -
From: "han peng" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, March 21, 2002 10:48 PM
Subject: how to retrieving data by age of record in MSSQL


> hihi..all gurus.. i know this is not appropriate here... sorry to bother u
all
>  i need to write a query to retrieve existing records by age of the
records..
>
>
> eg. user want to see Sales orders that are  5 yrs old..
>
> so i need to write a query to retrieve from sales table.. where theres a
orderdate column int it..
> datatype is datetime.
>
> so how am i going to write the query in mssql..??
>  oracle can use trunc() .. but mssql dont hav that... :(
>
> help help..
>
> hanpeng
>
> 
__
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: how to retrieving data by age of record in MSSQL

[Sicular, Alexander]

Something like

Select * from mytableostuff
Where salesdate > 'DATEADD(day, -5, getdate())'

Gl,

Alexander Sicular
Chief Technology Architect
Neurological Institute of New York
Columbia University
as867 [at] columbia {dot} edu


|-Original Message-
|From: han peng [mailto:[EMAIL PROTECTED]] 
|Sent: Thursday, March 21, 2002 11:49 PM
|To: CF-Talk
|Subject: how to retrieving data by age of record in MSSQL
|
|
|hihi..all gurus.. i know this is not appropriate here... sorry 
|to bother u all  i need to write a query to retrieve 
|existing records by age of the records..
|
|
|eg. user want to see Sales orders that are  5 yrs old..
|
|so i need to write a query to retrieve from sales table.. 
|where theres a orderdate column int it.. datatype is datetime.
|
|so how am i going to write the query in mssql..??
| oracle can use trunc() .. but mssql dont hav that... :(
|
|help help..
|
|hanpeng
|
|
__
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

how to retrieving data by age of record in MSSQL

[han peng]

hihi..all gurus.. i know this is not appropriate here... sorry to bother u all
 i need to write a query to retrieve existing records by age of the records..


eg. user want to see Sales orders that are  5 yrs old..

so i need to write a query to retrieve from sales table.. where theres a orderdate 
column int it..
datatype is datetime.

so how am i going to write the query in mssql..??
 oracle can use trunc() .. but mssql dont hav that... :(

help help..

hanpeng

__
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: Problem with math in query !!!

[one]

Thanks, that solved the problem:)


- Original Message - 
From: "John Wilker" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, March 21, 2002 6:37 PM
Subject: RE: Problem with math in query !!!


> What error do you get?
> 
> This may not be the culprit but I'd wrap "payments - (pastdue30 +
> pastdue60)" in another set a parens.  "(payments - (pastdue30 +
> pastdue60))" just to make sure SQL (I presume) knows for certain what
> you are doing.
> 
> Just some initial off the top of my head stuff
> 
>  J.
>  
> John Wilker
> Web Applications Consultant, and Author
> Macromedia Certified ColdFusion Developer
> President/Founder, Inland Empire CFUG.
> www.red-omega.com
>  
> "more people are killed by donkeys than by airplane crashes each year"
> 
> 
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
> Sent: Thursday, March 21, 2002 7:10 PM
> To: CF-Talk
> Subject: Re: Problem with math in query !!!
> 
> 
> Hi, I'm having a prob. with the following query to generate a report.
> There are 3 colums called:
> 
> pastdue30
> pastdue60
> payments
> region
> 
> So what I'm trying to do is add up pastdue30 and pastdue60 amounts and
> then minus payments - which is payment a customer has made to show what
> the net balance is thats still owed.
> 
> The report needs to display only customers who are past due more than
> $1, hence the attempt to define this through the WHERE clause.
> 
> 
> SELECT  region, payments - (pastdue30 + pastdue60) as netdue FROM
> accounts_receivable where (payments) - (pastdue30 + pastdue60) > 1 order
> by total_due ASC 
> 
> Any ideas where I might be messing up on this code?
> 
> Also, if you wanted to summarize totals by region, and show the % each
> region is contributing to the overall total of past due accounts with
> the company, whats the best way to write a query for that?
> 
> Thanks,
> Pardee.
> 
> 
> 
__
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: CF & JS Menus

[Lee Fuller]

Works great for us.  Yes.. Very nice implementation.

| -Original Message-
| From: JamesEdmunds [mailto:[EMAIL PROTECTED]] 
| Sent: Thursday, March 21, 2002 5:30 PM
| To: CF-Talk
| Subject: Re: CF & JS Menus
| 
| 
| I had trouble with them in NS6 and NS4.7, and in both the 
| main menu on the home page loaded strangely. -JE
| 
| Kevin Mansel wrote:
| 
| > I just wanted to say that I am extremely impressed with 
| QuillDesign's 
| > menu program.  Well done!
| >
| > -Kev
| >
| > ~
| > Kevin Mansel
| > Senior Web Developer
| > Fox Communications
| > [EMAIL PROTECTED]
| > DL : 425-649-1321
| > C : 425-346-7221
| >
| > -Original Message-
| > From: Michael Tangorre [mailto:[EMAIL PROTECTED]]
| > Sent: Thursday, March 21, 2002 4:52 PM
| > To: CF-Talk
| > Subject: Re: CF & JS Menus
| >
| > Thanks Shawn.
| > This is for a school project I am putting together..so free 
| is what I 
| > am looking for. I'd like to get into DHTML, Javascript, and 
| DOM more, 
| > but with graduation coming up, I just dont have time right now...
| >
| > so anyone reading this..any free menus would be great.
| > I am looking for something that I can use with CF.
| > I have a query that grabs the main categories and then loops around 
| > another query passing in the main catid to get the sub cats 
| and thus I 
| > get the info needed to give the javascript to generate the 
| menus.. I 
| > have on working in some versions of NS and all IE but need 
| it to work 
| > in IE4+, NS4.08+.
| >
| > Thanks for any links.. advice, help.. much appreciated.
| > Mike
| >
| > - Original Message -
| > From: "Shawn Grover" <[EMAIL PROTECTED]>
| > To: "CF-Talk" <[EMAIL PROTECTED]>
| > Sent: Thursday, March 21, 2002 7:48 PM
| > Subject: RE: CF & JS Menus
| >
| > > Hiermenus is now charging for licensed use.  And their prices are 
| > > pretty extreme. I checked into this in January sometime - it was 
| > > something like $500 if
| > your
| > > site had less than 20 pages, $900 if it was between 20 
| and 40 pages, 
| > > and $1500 if you had more than 40 pages.
| > >
| > > After doing some checking around, there are some very 
| good systems 
| > > out
| > there
| > > that are much less (free even), and meet or exceed Hiermenus'
| > capabilities.
| > > Unfortunately, I don't have the links with me I'll 
| see if I can 
| > > dig
| > them
| > > out tonight...
| > >
| > > Shawn Grover
| > >
| > > -Original Message-
| > > From: Chuck McElwee [mailto:[EMAIL PROTECTED]]
| > > Sent: Thursday, March 21, 2002 4:23 PM
| > > To: CF-Talk
| > > Subject: RE: CF & JS Menus
| > >
| > >
| > > You might also want to check out 
| > > http://www.webreference.com/dhtml/hiermenus/
| > >
| > >
| > > Chuck McElwee
| > > etech solutions inc
| > > www.etechsolutions.com
| > >
| > >
| > > -Original Message-
| > > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
| > > Sent: Thursday, March 21, 2002 4:37 PM
| > > To: CF-Talk
| > > Subject: Re: CF & JS Menus
| > >
| > >
| > > We have a very solid script that is very compatible with many 
| > > browsers.
| > >
| > > http://www.quilldesign.com/popupmenupro/index.cfm
| > >
| > > Drop in and check it out...
| > >
| > > Paul Giesenhagen
| > > QuillDesign
| > > http://www.quilldesign.com
| > > SiteDirector v2.0 - Commerce Builder
| > >
| > >
| > > > Hello Everyone.
| > > >
| > > > I have been playing with the IE DOM and NS DOM for the past two 
| > > > weeks,
| > and
| > > > decided to ask if anyone knows of any good JS menu scripts that 
| > > > looks
| > nice
| > > > and work in IE4+, NS4.08+?
| > > > I would appreciate any links or advice.
| > > >
| > > > 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

RE: Problem with math in query !!!

[John Wilker]

What error do you get?

This may not be the culprit but I'd wrap "payments - (pastdue30 +
pastdue60)" in another set a parens.  "(payments - (pastdue30 +
pastdue60))" just to make sure SQL (I presume) knows for certain what
you are doing.

Just some initial off the top of my head stuff

 J.
 
John Wilker
Web Applications Consultant, and Author
Macromedia Certified ColdFusion Developer
President/Founder, Inland Empire CFUG.
www.red-omega.com
 
"more people are killed by donkeys than by airplane crashes each year"


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, March 21, 2002 7:10 PM
To: CF-Talk
Subject: Re: Problem with math in query !!!


Hi, I'm having a prob. with the following query to generate a report.
There are 3 colums called:

pastdue30
pastdue60
payments
region

So what I'm trying to do is add up pastdue30 and pastdue60 amounts and
then minus payments - which is payment a customer has made to show what
the net balance is thats still owed.

The report needs to display only customers who are past due more than
$1, hence the attempt to define this through the WHERE clause.


SELECT  region, payments - (pastdue30 + pastdue60) as netdue FROM
accounts_receivable where (payments) - (pastdue30 + pastdue60) > 1 order
by total_due ASC 

Any ideas where I might be messing up on this code?

Also, if you wanted to summarize totals by region, and show the % each
region is contributing to the overall total of past due accounts with
the company, whats the best way to write a query for that?

Thanks,
Pardee.


__
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: Problem with math in query !!!

[one]

Hi, I'm having a prob. with the following query to generate a report. There
are 3 colums called:

pastdue30
pastdue60
payments
region

So what I'm trying to do is add up pastdue30 and pastdue60 amounts and then
minus payments - which is payment a customer has made to show what the net
balance is thats still owed.

The report needs to display only customers who are past due more than $1,
hence the attempt to define this through the WHERE clause.


SELECT  region, payments - (pastdue30 + pastdue60) as netdue
FROM accounts_receivable
where (payments) - (pastdue30 + pastdue60) > 1
order by total_due ASC


Any ideas where I might be messing up on this code?

Also, if you wanted to summarize totals by region, and show the % each
region is contributing to the overall total of past due accounts with the
company, whats the best way to write a query for that?

Thanks,
Pardee.

__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
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: Password Protected File Downloads

[Tony Schreiber]

In my intranet, I created a directory outside the webroot and gave it no
permissions except to the system account. Then I use cfcontent to push the
file to the user (after being authenticated via cf).

> What is the most efficient way to provide files for download to a client
> after username/password authentication *without* using NT Authentication.
>
> The simple way is to validate the user using CF and then just display the
> documents using CFDirectory, but, if anyone know the URL to the document,
> they can bypass the cfm template altogether.  I was thinking about randomly
> renaming documents and storing the filenames in a DB, but that seems sloppy
> too.
>
> This client is currently in a virtual hosting environment, so adding
> directory security seems out of the question.
>
> Any thoughts would be greatly appreciated.
>
> TIA,
>
> - jim
>
>
> 
__
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: CF & JS Menus

[JamesEdmunds]

Maybe there is something here of value:
http://www.dynamicdrive.com/dynamicindex1/index.html
Hope this is helpful,
James

Michael Tangorre wrote:

> Thanks Shawn.
> This is for a school project I am putting together..so free is what I am
> looking for. I'd like to get into DHTML, Javascript, and DOM more, but with
> graduation coming up, I just dont have time right now...
>
> so anyone reading this..any free menus would be great.
> I am looking for something that I can use with CF.
> I have a query that grabs the main categories and then loops around another
> query passing in the main catid to get the sub cats and thus I get the info
> needed to give the javascript to generate the menus.. I have on working in
> some versions of NS and all IE but need it to work in IE4+, NS4.08+.
>
> Thanks for any links.. advice, help.. much appreciated.
> Mike
>
> - Original Message -
> From: "Shawn Grover" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, March 21, 2002 7:48 PM
> Subject: RE: CF & JS Menus
>
> > Hiermenus is now charging for licensed use.  And their prices are pretty
> > extreme.
> > I checked into this in January sometime - it was something like $500 if
> your
> > site had less than 20 pages, $900 if it was between 20 and 40 pages, and
> > $1500 if you had more than 40 pages.
> >
> > After doing some checking around, there are some very good systems out
> there
> > that are much less (free even), and meet or exceed Hiermenus'
> capabilities.
> > Unfortunately, I don't have the links with me I'll see if I can dig
> them
> > out tonight...
> >
> > Shawn Grover
> >
> > -Original Message-
> > From: Chuck McElwee [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, March 21, 2002 4:23 PM
> > To: CF-Talk
> > Subject: RE: CF & JS Menus
> >
> >
> > You might also want to check out
> > http://www.webreference.com/dhtml/hiermenus/
> >
> >
> > Chuck McElwee
> > etech solutions inc
> > www.etechsolutions.com
> >
> >
> > -Original Message-
> > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, March 21, 2002 4:37 PM
> > To: CF-Talk
> > Subject: Re: CF & JS Menus
> >
> >
> > We have a very solid script that is very compatible with many browsers.
> >
> > http://www.quilldesign.com/popupmenupro/index.cfm
> >
> > Drop in and check it out...
> >
> > Paul Giesenhagen
> > QuillDesign
> > http://www.quilldesign.com
> > SiteDirector v2.0 - Commerce Builder
> >
> >
> > > Hello Everyone.
> > >
> > > I have been playing with the IE DOM and NS DOM for the past two weeks,
> and
> > > decided to ask if anyone knows of any good JS menu scripts that looks
> nice
> > > and work in IE4+, NS4.08+?
> > > I would appreciate any links or advice.
> > >
> > > 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

Re: CF & JS Menus

[JamesEdmunds]

I had trouble with them in NS6 and NS4.7, and in both the main menu on the home page 
loaded strangely.
-JE

Kevin Mansel wrote:

> I just wanted to say that I am extremely impressed with QuillDesign's menu
> program.  Well done!
>
> -Kev
>
> ~
> Kevin Mansel
> Senior Web Developer
> Fox Communications
> [EMAIL PROTECTED]
> DL : 425-649-1321
> C : 425-346-7221
>
> -Original Message-
> From: Michael Tangorre [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 21, 2002 4:52 PM
> To: CF-Talk
> Subject: Re: CF & JS Menus
>
> Thanks Shawn.
> This is for a school project I am putting together..so free is what I am
> looking for. I'd like to get into DHTML, Javascript, and DOM more, but with
> graduation coming up, I just dont have time right now...
>
> so anyone reading this..any free menus would be great.
> I am looking for something that I can use with CF.
> I have a query that grabs the main categories and then loops around another
> query passing in the main catid to get the sub cats and thus I get the info
> needed to give the javascript to generate the menus.. I have on working in
> some versions of NS and all IE but need it to work in IE4+, NS4.08+.
>
> Thanks for any links.. advice, help.. much appreciated.
> Mike
>
> - Original Message -
> From: "Shawn Grover" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, March 21, 2002 7:48 PM
> Subject: RE: CF & JS Menus
>
> > Hiermenus is now charging for licensed use.  And their prices are pretty
> > extreme.
> > I checked into this in January sometime - it was something like $500 if
> your
> > site had less than 20 pages, $900 if it was between 20 and 40 pages, and
> > $1500 if you had more than 40 pages.
> >
> > After doing some checking around, there are some very good systems out
> there
> > that are much less (free even), and meet or exceed Hiermenus'
> capabilities.
> > Unfortunately, I don't have the links with me I'll see if I can dig
> them
> > out tonight...
> >
> > Shawn Grover
> >
> > -Original Message-
> > From: Chuck McElwee [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, March 21, 2002 4:23 PM
> > To: CF-Talk
> > Subject: RE: CF & JS Menus
> >
> >
> > You might also want to check out
> > http://www.webreference.com/dhtml/hiermenus/
> >
> >
> > Chuck McElwee
> > etech solutions inc
> > www.etechsolutions.com
> >
> >
> > -Original Message-
> > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, March 21, 2002 4:37 PM
> > To: CF-Talk
> > Subject: Re: CF & JS Menus
> >
> >
> > We have a very solid script that is very compatible with many browsers.
> >
> > http://www.quilldesign.com/popupmenupro/index.cfm
> >
> > Drop in and check it out...
> >
> > Paul Giesenhagen
> > QuillDesign
> > http://www.quilldesign.com
> > SiteDirector v2.0 - Commerce Builder
> >
> >
> > > Hello Everyone.
> > >
> > > I have been playing with the IE DOM and NS DOM for the past two weeks,
> and
> > > decided to ask if anyone knows of any good JS menu scripts that looks
> nice
> > > and work in IE4+, NS4.08+?
> > > I would appreciate any links or advice.
> > >
> > > 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

Re: Multiple File Upload

[Birgit Pauli-Haack]

I found two java applet solutions: both around $200 if I recall it
correctly...

AppletFile by Infomentum, Inc.
http://www.infomentum.com/products/

or

JUpload by  Persits Software, Inc.
http://www.aspupload.com/jupload.html

Birgit


Thursday, March 21, 2002, 11:08:26 AM, you wrote:

>> I need to have a multiple file upload.

OL> I've only ever heard two answers to this:

OL> 1. Some kind of custom Active-X somethingorother.
OL> 2. Multiple file input fields, followed by looping over cffile.

OL> I'd certainly be interested if anyone has any better solutions.

OL> -- Owen

OL> 
OL> Athens County Library Services
OL> http://www.athenscounty.lib.oh.us


OL> 
__
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: CF & JS Menus

[LANCASTER, STEVEN M. (JSC-OL) (BAR)]

Here is a tutorial that Macromedia gave me about a year ago. check it out
and see if you can use it..

http://www.projectseven.com/tutorials/menuing/mcloser/index.htm

-Original Message-
From: Michael Tangorre [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 6:52 PM
To: CF-Talk
Subject: Re: CF & JS Menus


Thanks Shawn.
This is for a school project I am putting together..so free is what I am
looking for. I'd like to get into DHTML, Javascript, and DOM more, but with
graduation coming up, I just dont have time right now...

so anyone reading this..any free menus would be great.
I am looking for something that I can use with CF.
I have a query that grabs the main categories and then loops around another
query passing in the main catid to get the sub cats and thus I get the info
needed to give the javascript to generate the menus.. I have on working in
some versions of NS and all IE but need it to work in IE4+, NS4.08+.

Thanks for any links.. advice, help.. much appreciated.
Mike


- Original Message -
From: "Shawn Grover" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, March 21, 2002 7:48 PM
Subject: RE: CF & JS Menus


> Hiermenus is now charging for licensed use.  And their prices are pretty
> extreme.
> I checked into this in January sometime - it was something like $500 if
your
> site had less than 20 pages, $900 if it was between 20 and 40 pages, and
> $1500 if you had more than 40 pages.
>
> After doing some checking around, there are some very good systems out
there
> that are much less (free even), and meet or exceed Hiermenus'
capabilities.
> Unfortunately, I don't have the links with me I'll see if I can dig
them
> out tonight...
>
> Shawn Grover
>
> -Original Message-
> From: Chuck McElwee [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 21, 2002 4:23 PM
> To: CF-Talk
> Subject: RE: CF & JS Menus
>
>
> You might also want to check out
> http://www.webreference.com/dhtml/hiermenus/
>
>
> Chuck McElwee
> etech solutions inc
> www.etechsolutions.com
>
>
> -Original Message-
> From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 21, 2002 4:37 PM
> To: CF-Talk
> Subject: Re: CF & JS Menus
>
>
> We have a very solid script that is very compatible with many browsers.
>
> http://www.quilldesign.com/popupmenupro/index.cfm
>
> Drop in and check it out...
>
> Paul Giesenhagen
> QuillDesign
> http://www.quilldesign.com
> SiteDirector v2.0 - Commerce Builder
>
>
> > Hello Everyone.
> >
> > I have been playing with the IE DOM and NS DOM for the past two weeks,
and
> > decided to ask if anyone knows of any good JS menu scripts that looks
nice
> > and work in IE4+, NS4.08+?
> > I would appreciate any links or advice.
> >
> > 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

Re: CFSCRIPT & Preservesinglequotes()

[James Sleeman]

Yea this is a really wierd bug that I have encountered also, basically what
I see happening is.. when you supply your variable to the UDF - inside a
cfquery block CF escapes quotes in the variable before handing to the UDF,
and then it takes the value your UDF returns and escapes the quotes again.
So your one quote becomes '' when going into the UDF and then  coming
out of the UDF :-o

Two ways to fix it, what I did was unescape the single quotes in the value
my UDF gets, so I have something like

function myUDF(someValue) {
someValue = Replace(someValue, "''", "'", "ALL");
... do stuff ...
return someValue;
   }

or I think you could also use preserve single quotes when passing the value
to the UDF, something like...


   SOME SQL STUFF
#myUDF(preserveSingleQuotes(yourVariable))#


which should stop the escapement of single quotes when passing yourVariable
into myUDF, the single quotes will still be escaped coming out, but that's
what you'd expect, if you didn't want that either you could do

#preserveSingleQuotes(myUDF(preserveSingleQuotes(yourVariable)))#


Whatever way you look at it it's a very wierd thing, it's one thing to
escape values being spit out to the database, it's another to escape values
when feeding them to a UDF.

- Original Message -
From: "Sean Daniels" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, March 22, 2002 5:06 AM
Subject: CFSCRIPT & Preservesinglequotes()


> I have written a seemingly simple UDF for cleaning up data before an
insert
> or update statement (it trims the string, inserts null when necessary,
wraps
> string in single quotes if it's a char field):
>
>
> 
> function checknull(ii,isint) {
> if (isint) {
> return iif(len(trim(ii)),de(trim(ii)),de("null")); }
> else {
> return
> iif(len(trim(ii)),de(chr(39)&trim(ii)&chr(39)),de("null")); }
> }
> 
>
> Basically, my insert statement looks like:
>
> Insert into tablename (intfield,charfield)
> Values (#checknull(intfield,1)#,#checknull(charfield,0)#)
>
> It works great except for when the charfield contains apostrophes. It
> escapes them all and the result is that twice as many apostrophes get
> inserted. I know that somewhere in here I should probably be using
> preservesinglequotes() but everywhere I attempt to use it in the UDF I get
a
> JIT compilation error. I also get a JIT if I put the preservesinglequotes
> function in the calling template
> [preservesinglequotes(checknull(charfield,0))]
>
> Any suggestions? Please? Unfortunately I used this function all through an
> app before finding the bug, so I would be psyched to make repairs to the
> function itself not all the code that uses it.
>
> - Sean
>
> ~~
> Sean Daniels
>   Director, Engineering
>   Marketplace Technologies, Inc
> (T): 207.363.7374
> (C): 207.332.6340
> (F): 240.269.6319
> ~~
>   http://www.dealforce.com
>   http://www.mergernetwork.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

Data Ignored Error

[Gregory Taylor]

For the past week or so I've been experiencing a very strange error that I've never 
seen before.

"Error","TID=1376","03/20/02","15:31:40","Web server provided content data when none 
was expected. Data ignored."

My first inclination is that someone has somehow spoofed my page and are trying to 
access the database directly. When
I compare the error message to my server logs there doesn't seem to be anyone logged 
in and accessing any strange
pages or information.

Has anyone else experienced this type of error before?

Gregory Taylor


__
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: CF & JS Menus

[Kevin Mansel]

I just wanted to say that I am extremely impressed with QuillDesign's menu
program.  Well done!

-Kev

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



-Original Message-
From: Michael Tangorre [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 4:52 PM
To: CF-Talk
Subject: Re: CF & JS Menus


Thanks Shawn.
This is for a school project I am putting together..so free is what I am
looking for. I'd like to get into DHTML, Javascript, and DOM more, but with
graduation coming up, I just dont have time right now...

so anyone reading this..any free menus would be great.
I am looking for something that I can use with CF.
I have a query that grabs the main categories and then loops around another
query passing in the main catid to get the sub cats and thus I get the info
needed to give the javascript to generate the menus.. I have on working in
some versions of NS and all IE but need it to work in IE4+, NS4.08+.

Thanks for any links.. advice, help.. much appreciated.
Mike


- Original Message -
From: "Shawn Grover" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, March 21, 2002 7:48 PM
Subject: RE: CF & JS Menus


> Hiermenus is now charging for licensed use.  And their prices are pretty
> extreme.
> I checked into this in January sometime - it was something like $500 if
your
> site had less than 20 pages, $900 if it was between 20 and 40 pages, and
> $1500 if you had more than 40 pages.
>
> After doing some checking around, there are some very good systems out
there
> that are much less (free even), and meet or exceed Hiermenus'
capabilities.
> Unfortunately, I don't have the links with me I'll see if I can dig
them
> out tonight...
>
> Shawn Grover
>
> -Original Message-
> From: Chuck McElwee [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 21, 2002 4:23 PM
> To: CF-Talk
> Subject: RE: CF & JS Menus
>
>
> You might also want to check out
> http://www.webreference.com/dhtml/hiermenus/
>
>
> Chuck McElwee
> etech solutions inc
> www.etechsolutions.com
>
>
> -Original Message-
> From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 21, 2002 4:37 PM
> To: CF-Talk
> Subject: Re: CF & JS Menus
>
>
> We have a very solid script that is very compatible with many browsers.
>
> http://www.quilldesign.com/popupmenupro/index.cfm
>
> Drop in and check it out...
>
> Paul Giesenhagen
> QuillDesign
> http://www.quilldesign.com
> SiteDirector v2.0 - Commerce Builder
>
>
> > Hello Everyone.
> >
> > I have been playing with the IE DOM and NS DOM for the past two weeks,
and
> > decided to ask if anyone knows of any good JS menu scripts that looks
nice
> > and work in IE4+, NS4.08+?
> > I would appreciate any links or advice.
> >
> > Mike
> >
>
>
> 

__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
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: CF & JS Menus

[Michael Tangorre]

Thanks Shawn.
This is for a school project I am putting together..so free is what I am
looking for. I'd like to get into DHTML, Javascript, and DOM more, but with
graduation coming up, I just dont have time right now...

so anyone reading this..any free menus would be great.
I am looking for something that I can use with CF.
I have a query that grabs the main categories and then loops around another
query passing in the main catid to get the sub cats and thus I get the info
needed to give the javascript to generate the menus.. I have on working in
some versions of NS and all IE but need it to work in IE4+, NS4.08+.

Thanks for any links.. advice, help.. much appreciated.
Mike


- Original Message -
From: "Shawn Grover" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, March 21, 2002 7:48 PM
Subject: RE: CF & JS Menus


> Hiermenus is now charging for licensed use.  And their prices are pretty
> extreme.
> I checked into this in January sometime - it was something like $500 if
your
> site had less than 20 pages, $900 if it was between 20 and 40 pages, and
> $1500 if you had more than 40 pages.
>
> After doing some checking around, there are some very good systems out
there
> that are much less (free even), and meet or exceed Hiermenus'
capabilities.
> Unfortunately, I don't have the links with me I'll see if I can dig
them
> out tonight...
>
> Shawn Grover
>
> -Original Message-
> From: Chuck McElwee [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 21, 2002 4:23 PM
> To: CF-Talk
> Subject: RE: CF & JS Menus
>
>
> You might also want to check out
> http://www.webreference.com/dhtml/hiermenus/
>
>
> Chuck McElwee
> etech solutions inc
> www.etechsolutions.com
>
>
> -Original Message-
> From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 21, 2002 4:37 PM
> To: CF-Talk
> Subject: Re: CF & JS Menus
>
>
> We have a very solid script that is very compatible with many browsers.
>
> http://www.quilldesign.com/popupmenupro/index.cfm
>
> Drop in and check it out...
>
> Paul Giesenhagen
> QuillDesign
> http://www.quilldesign.com
> SiteDirector v2.0 - Commerce Builder
>
>
> > Hello Everyone.
> >
> > I have been playing with the IE DOM and NS DOM for the past two weeks,
and
> > decided to ask if anyone knows of any good JS menu scripts that looks
nice
> > and work in IE4+, NS4.08+?
> > I would appreciate any links or advice.
> >
> > 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

RE: CF & JS Menus

[Shawn Grover]

Hiermenus is now charging for licensed use.  And their prices are pretty
extreme.
I checked into this in January sometime - it was something like $500 if your
site had less than 20 pages, $900 if it was between 20 and 40 pages, and
$1500 if you had more than 40 pages.

After doing some checking around, there are some very good systems out there
that are much less (free even), and meet or exceed Hiermenus' capabilities.
Unfortunately, I don't have the links with me I'll see if I can dig them
out tonight...

Shawn Grover

-Original Message-
From: Chuck McElwee [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 4:23 PM
To: CF-Talk
Subject: RE: CF & JS Menus


You might also want to check out
http://www.webreference.com/dhtml/hiermenus/


Chuck McElwee
etech solutions inc
www.etechsolutions.com


-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 4:37 PM
To: CF-Talk
Subject: Re: CF & JS Menus


We have a very solid script that is very compatible with many browsers.

http://www.quilldesign.com/popupmenupro/index.cfm

Drop in and check it out...

Paul Giesenhagen
QuillDesign
http://www.quilldesign.com
SiteDirector v2.0 - Commerce Builder


> Hello Everyone.
>
> I have been playing with the IE DOM and NS DOM for the past two weeks, and
> decided to ask if anyone knows of any good JS menu scripts that looks nice
> and work in IE4+, NS4.08+?
> I would appreciate any links or advice.
>
> Mike
>


__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
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 SQL Join

[Jim Curran]

Hey all,

Anyone know how to do the following SQL join (if it's even possible)

Table 1

Contact_ID  Name
1   Joe
2   John
3   Jerry

Table 2 (JN table Using letters here for clarification)
industry_ID Contact_ID
1   A
1   B
1   C
2   A
2   B
3   A


Results I want:
contact_ID  industries
1   A,B,C
2   A,B
3   A

I know how to do in CF, but would love to figure out if it's
possible/efficient in SQL

TIA

- j

-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 5:14 PM
To: CF-Talk
Subject: Re: multiple aggregrates in single query


Cantrell, Adam wrote:
> Anyone know how to get this in SQLserver without two queries? I'm
outputting
> something like: "10 incomplete out of 23 for user Joe Shmoe". I know this
is
> totally wrong, but maybe someone will get my drift:
>
> 
>   SELECT
>   tIncomplete.count(*) AS incompleteTasks,
>   tTotal.count(*) AS totalTasks
>   FROM TASKS AS tIncomplete, TASKS AS tTotal
>   WHERE
>   tIncomplete.num_peopleID = 184 AND
>   tIncomplete.bit_complete = 0 AND
>   tTotal.num_peopleID = 184
> 

Datatypes? What is the definition of an incomplete task? What is the
definition of a completed task?

Jochem


__
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: CF & JS Menus

[Chuck McElwee]

You might also want to check out
http://www.webreference.com/dhtml/hiermenus/


Chuck McElwee
etech solutions inc
www.etechsolutions.com


-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 4:37 PM
To: CF-Talk
Subject: Re: CF & JS Menus


We have a very solid script that is very compatible with many browsers.

http://www.quilldesign.com/popupmenupro/index.cfm

Drop in and check it out...

Paul Giesenhagen
QuillDesign
http://www.quilldesign.com
SiteDirector v2.0 - Commerce Builder


> Hello Everyone.
>
> I have been playing with the IE DOM and NS DOM for the past two weeks, and
> decided to ask if anyone knows of any good JS menu scripts that looks nice
> and work in IE4+, NS4.08+?
> I would appreciate any links or advice.
>
> 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: CF & Javascript frames

[Dave Carabetta]

>How can you refresh a specifc frame from a popup window and then close that
>window?
>I just can't find the correct syntax.
>
>Any ideas?
>
>
>
>//parent.LeftFrameBottom.location.href=".././modules.cfm?#client.u
>rltoken#";
> window.close();
>

A couple things. First, your path reference looks off to me. I think you 
just want ../modules.cfm, but I could be wrong as I don't know your 
architecture. I think that ".././" just puts you in the same directory 
you're already in. But here's how to do what you're looking for:





Again, not sure about your URL (I could be wrong), but that's how you do the 
refresh and close.

Regards,
Dave.

_
Send and receive Hotmail on your mobile device: http://mobile.msn.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: CF admin password

[James Sleeman]

CF servers on unix machines keep thier own "registry" files, on windows
machines they use the windows registry.

- Original Message -
From: "Douglas Brown" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, March 22, 2002 10:30 AM
Subject: Re: CF admin password


> I know nothing of UNIX, but I do not believe it has a registry setting.
>
>
>
>
> "Success is a journey, not a destination!!"
>
>
>
> Doug Brown
> - Original Message -
> From: "Dave Watts" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, March 21, 2002 2:18 PM
> Subject: RE: CF admin password
>
>
> > > I am on a Unix System running Apache and I need to
> > > reset the CF Admin password for CF 4.5 because it
> > > was forgotten can someone tell me how to do this.
> > > Please email me off list.
> >
> > 1. Stop the CF server.
> > 2. Edit the registry file (typically
/opt/coldfusion/registry/cf.registry).
> > 3. Find the entry
> > HKLM\SOFTWARE\Allaire\ColdFusion\CurrentVersion\Server\UseAdminPassword
and
> > set it to "0".
> > 4. Save the registry file.
> > 5. Start the CF server.
> > 6. Open the CF Administrator - it won't require a password - and enable
the
> > password, and set the password to the desired value.
> >
> > Dave Watts, CTO, Fig Leaf Software
> > http://www.figleaf.com/
> > voice: (202) 797-5496
> > fax: (202) 797-5444
> >
> >
> 
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
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: CF & Javascript frames

[Scott Van Vliet]

window.opener is the parent window reference from a js popup window ^_^

so, try:window.opener.LeftFrameBottom.location = "..."

HTH

- Original Message -
From: "Bosky, Dave" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, March 21, 2002 2:30 PM
Subject: CF & Javascript frames


> How can you refresh a specifc frame from a popup window and then close
that
> window?
> I just can't find the correct syntax.
>
> Any ideas?
>
> 
>
>
//parent.LeftFrameBottom.location.href=".././modules.cfm?#client.u
> rltoken#";
> window.close();
> 
>
> Thanks,
> Dave
>
>
>
>
>
> 
__
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: multiple aggregrates in single query

[Cantrell, Adam]

got it, I needed an END in my case statement. Here's what it looks like:

SELECT 
COUNT(ALL CASE WHEN bit_complete = 'n' THEN 1 ELSE NULL END) AS
incompleteTasks,
COUNT(*) AS totalTasks
FROM TASKS
WHERE 
num_peopleID = 184

thanks for any replies.

ps. please ignore my bit_field = '', I needed to change it to a string to
accept Pending (p) status.

Adam.


> -Original Message-
> From: Cantrell, Adam [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 21, 2002 4:06 PM
> To: CF-Talk
> Subject: multiple aggregrates in single query
> 
> 
> Anyone know how to get this in SQLserver without two queries? 
> I'm outputting
> something like: "10 incomplete out of 23 for user Joe Shmoe". 
> I know this is
> totally wrong, but maybe someone will get my drift:
> 
> 
>   SELECT 
>   tIncomplete.count(*) AS incompleteTasks,
>   tTotal.count(*) AS totalTasks
>   FROM TASKS AS tIncomplete, TASKS AS tTotal
>   WHERE 
>   tIncomplete.num_peopleID = 184 AND
>   tIncomplete.bit_complete = 0 AND
>   tTotal.num_peopleID = 184
> 
> 
> 
> I could just do it in two queries, but I'm really trying to 
> do this project
> right this time - hehe.
> 
> Adam.
> 
> 
__
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

CF & Javascript frames

[Bosky, Dave]

How can you refresh a specifc frame from a popup window and then close that
window?
I just can't find the correct syntax.
 
Any ideas?
 

 
//parent.LeftFrameBottom.location.href=".././modules.cfm?#client.u
rltoken#";
window.close();

 
Thanks,
Dave
 
 
 
 

__
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: CF admin password

[Douglas Brown]

I know nothing of UNIX, but I do not believe it has a registry setting.




"Success is a journey, not a destination!!"



Doug Brown
- Original Message - 
From: "Dave Watts" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, March 21, 2002 2:18 PM
Subject: RE: CF admin password


> > I am on a Unix System running Apache and I need to 
> > reset the CF Admin password for CF 4.5 because it 
> > was forgotten can someone tell me how to do this. 
> > Please email me off list.
> 
> 1. Stop the CF server.
> 2. Edit the registry file (typically /opt/coldfusion/registry/cf.registry).
> 3. Find the entry
> HKLM\SOFTWARE\Allaire\ColdFusion\CurrentVersion\Server\UseAdminPassword and
> set it to "0".
> 4. Save the registry file.
> 5. Start the CF server.
> 6. Open the CF Administrator - it won't require a password - and enable the
> password, and set the password to the desired value.
> 
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> voice: (202) 797-5496
> fax: (202) 797-5444
> 
> 
__
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: multiple aggregrates in single query

[Cantrell, Adam]

PS, I've also tried this, which errors out:

SELECT 
COUNT(ALL CASE WHEN bit_complete = 'n' THEN 1 ELSE NULL) AS
incompleteTasks, 
COUNT(*) AS totalTasks 
FROM TASKS 
WHERE num_peopleID = 184


this results in:
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 2: Incorrect syntax near
')'.




> -Original Message-
> From: Cantrell, Adam [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 21, 2002 4:06 PM
> To: CF-Talk
> Subject: multiple aggregrates in single query
> 
> 
> Anyone know how to get this in SQLserver without two queries? 
> I'm outputting
> something like: "10 incomplete out of 23 for user Joe Shmoe". 
> I know this is
> totally wrong, but maybe someone will get my drift:
> 
> 
>   SELECT 
>   tIncomplete.count(*) AS incompleteTasks,
>   tTotal.count(*) AS totalTasks
>   FROM TASKS AS tIncomplete, TASKS AS tTotal
>   WHERE 
>   tIncomplete.num_peopleID = 184 AND
>   tIncomplete.bit_complete = 0 AND
>   tTotal.num_peopleID = 184
> 
> 
> 
> I could just do it in two queries, but I'm really trying to 
> do this project
> right this time - hehe.
> 
> Adam.
> 
> 
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
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: CF_TwoSelectsRelated and browser back button

[Cornillon, Matthieu]

Joseph,

Thanks for the idea.  I tried it, and all of a sudden it worked, but not
completely.  It's behaving very strangely.  I can't even quite figure out
the logic of the weirdness.  For example, I select Rhode Island -
Narragansett, then hit the back button.  Still Rhode Island - Narragansett.
Then I change it to Massachusetts - Cambridge.  I submit it, then hit the
back button and get Massachusetts - Narragansett!  It's the right state, and
the right place in the city list (the second entry), but the wrong city
list, as Narragansett is in Rhode Island.

Thanks again for taking a stab.

Matthieu

-Original Message-
From: Joseph Thompson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 4:57 PM
To: CF-Talk
Subject: Re: CF_TwoSelectsRelated and browser back button


My guess.. Do you have "AutoSelect" set to "yes"?  If you set it to no that
may explain why it is not automatically selecting that value. (the default
should be "yes" if you are not specifying that attribute)


>  For some reason, the form now shows with
> Rhode Island selected, but a blank under the City dropdown.


__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
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: dateadd with grouped query and cfgraph

[Robert Gatton]

 over the query and do your dateadd to the date field before you
feed the query to cfgraph

- Original Message -
From: "Jeff Beer" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, March 21, 2002 3:00 PM
Subject: dateadd with grouped query and cfgraph


> I run a graph on a server in a different time zone.  I'd like to modify
the
> times (hour only) by adding two hours.  However, the query is grouped by
day
> and hour, then fed into CFGRAPH.
>
> Anyone know if this can be done without modifying the data in the table?
>
> Thanks!
>
> Jeff
>
> 
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
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: multiple aggregrates in single query

[Jochem van Dieten]

Cantrell, Adam wrote:
> Anyone know how to get this in SQLserver without two queries? I'm outputting
> something like: "10 incomplete out of 23 for user Joe Shmoe". I know this is
> totally wrong, but maybe someone will get my drift:
> 
> 
>   SELECT 
>   tIncomplete.count(*) AS incompleteTasks,
>   tTotal.count(*) AS totalTasks
>   FROM TASKS AS tIncomplete, TASKS AS tTotal
>   WHERE 
>   tIncomplete.num_peopleID = 184 AND
>   tIncomplete.bit_complete = 0 AND
>   tTotal.num_peopleID = 184
> 

Datatypes? What is the definition of an incomplete task? What is the 
definition of a completed task?

Jochem

__
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: CF admin password

[Dave Watts]

> I am on a Unix System running Apache and I need to 
> reset the CF Admin password for CF 4.5 because it 
> was forgotten can someone tell me how to do this. 
> Please email me off list.

1. Stop the CF server.
2. Edit the registry file (typically /opt/coldfusion/registry/cf.registry).
3. Find the entry
HKLM\SOFTWARE\Allaire\ColdFusion\CurrentVersion\Server\UseAdminPassword and
set it to "0".
4. Save the registry file.
5. Start the CF server.
6. Open the CF Administrator - it won't require a password - and enable the
password, and set the password to the desired value.

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

__
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: Q: Looping through a CSV File

[Christopher Olive]

it's kind of kludgy, but you could upload the file, do a CFHTTP to the new file, use 
File.Contents as the variable over which to list loop.

additionally, why not rename the old file, then upload the new file to the same name?

christopher olive
cto, vp of web development, vp it security
atnet solutions, inc.
410.931.4092
http://www.atnetsolutions.com


-Original Message-
From: Marlon Moyer [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 4:19 PM
To: CF-Talk
Subject: Re: Q: Looping through a CSV File


I used to use a custom tag that would create datasources in cf4.5, I'm not
sure of the name anymore, but I got it off of the developer exchange.  In
essence it rewrites some registry settings, so I'm not sure if your hosting
company would allow it.  The other option is to have a permanent ODBC entry
set up on the server and then just replace the text file with one of the
same name.

Marlon

- Original Message -
From: <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, March 21, 2002 2:57 PM
Subject: RE: Q: Looping through a CSV File


> Are these ODBC options available in CFServer 4.5?  I
> have 5.0 (dev server) but our web hosting company is
> still at 4.5.
>
>
> > The structure will always be the same but the file name is going to
> > change though. I am backing up the old file before I push the new file
> > up.
> >
> > Thanks,
> > Jason Larson
> >
> >
> > -Original Message-
> > From: Marlon Moyer [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, March 21, 2002 9:35 AM
> > To: CF-Talk
> > Subject: Re: Looping through a CSV File
> >
> > If the csv structure will always be the same, you could set up an ODBC
> > connection and treat it like a table.
> >
> >
> > - Original Message -
> > From: "Mike Townend" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Thursday, March 21, 2002 10:26 AM
> > Subject: RE: Looping through a CSV File
> >
> >
> > > Treat the file as a list of lists...
> > >
> > > List 1 - Delimiter = #Chr(10)##Chr(13)#
> > >
> > > And each element of that list is a list with delimeter ,
> > >
> > > HTH
> > >
> > >
> > >
> > > -Original Message-
> > > From: Jason Larson [mailto:[EMAIL PROTECTED]]
> > > Sent: 21 March 2002 16:14
> > > To: CF-Talk
> > > Subject: Looping through a CSV File
> > >
> > >
> > > I have a CSV File that I am pushing up using cffile. I want to loop
> > > through the csv file and insert the content into a database, and I am
> > > not sure how to do this. Any help our guidance would help?
> > >
> > > Thanks
> > > Jason
> > >
> > >
> > >
> > >
> >
> >
> 

__
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

multiple aggregrates in single query

[Cantrell, Adam]

Anyone know how to get this in SQLserver without two queries? I'm outputting
something like: "10 incomplete out of 23 for user Joe Shmoe". I know this is
totally wrong, but maybe someone will get my drift:


SELECT 
tIncomplete.count(*) AS incompleteTasks,
tTotal.count(*) AS totalTasks
FROM TASKS AS tIncomplete, TASKS AS tTotal
WHERE 
tIncomplete.num_peopleID = 184 AND
tIncomplete.bit_complete = 0 AND
tTotal.num_peopleID = 184



I could just do it in two queries, but I'm really trying to do this project
right this time - hehe.

Adam.

__
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

CF admin password

[LANCASTER, STEVEN M. (JSC-OL) (BAR)]

I am on a Unix System running Apache and I need to reset the CF Admin
password for CF 4.5 because it was forgotten can someone tell me how to do
this. Please email me off list.


Steven Lancaster
__
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: cfexecute

[Shawn McKee]

Thanks.  The CFHTTP solution works like a champ.

Shawn

-Original Message-
From: Joseph Thompson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 11:14 AM
To: CF-Talk
Subject: Re: cfexecute


It is possible to "spawn" a task.

Use CFEXECUTE to start a new thread.  The code in that thread just goes
about it's business while the "calling" page can continue.

http://cfhub.com/forum//index.cfm?Fuseaction=Thread&TopicID=1037&start=1

It is also possible (and even better in some cases) to use CFHTTP to call
the "worker" file but set the timeout in the CFHTTP tag to like "one
second".  Now your calling page starts the remote script... then just
ignores it after the timeout.  The worker thread goes about it's business as
does your calling page.



> If not our first solution was to create a Perl script and execute it with
a
>  call.  The problem here is that I have to sit and wait for the
> job to finish before moving on and that can take awhile.  Is there a way
to
> "walk away" from a  without ending up with a bunch of defunct
> jobs on the server?
>



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

[Paul Giesenhagen]

Thanks... Perfect solution!

Paul Giesenhagen
QuillDesign
http://www.quilldesign.com
SiteDirector v2.0 - Commerce Builder



> OTTOMH,
>
> In your CFOUTPUT use startrow="3"
>
> I think the first two dirs are *always* the . and ..  Anyone back me up on
> this?
>
> - j
>
> -Original Message-
> From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 21, 2002 4:43 PM
> To: CF-Talk
> Subject: cfdirectory
>
>
> I am using the cfdirectory tag to get a list of directories .. how do not
> show the two top directories.
>
> my directory looks like this
> .
> .
> dir1
> dir2
> dir3
>
> I just want to show the dir1,dir2,dir3 and not the period directories
> (whatever they are called).
>
> Thanks
> Paul Giesenhagen
> QuillDesign
> http://www.quilldesign.com
> SiteDirector v2.0 - Commerce Builder
>
>
>
> 
__
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: CF_TwoSelectsRelated and browser back button

[Joseph Thompson]

My guess.. Do you have "AutoSelect" set to "yes"?  If you set it to no that
may explain why it is not automatically selecting that value. (the default
should be "yes" if you are not specifying that attribute)


>  For some reason, the form now shows with
> Rhode Island selected, but a blank under the City dropdown.

__
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: CF 404 error template?

[VAN VLIET, SCOTT E (SBCSI)]

In IIS, you can actually select a URL to handle your 404 error.  If you
choose a *.cfm file, it will not send it to ColdFusion, and it will just
serve up your ColdFusion code as well HTML. HTH.

-- 
SCOTT VAN VLIET 
SENIOR ANALYST 
SBC SERVICES, INC 
Tel: 858.886.3878 
Fax: 858.653.6763 
Email: [EMAIL PROTECTED]  




-Original Message-
From: Will Ryan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 1:47 PM
To: CF-Talk
Subject: CF 404 error template?


Hello All,

 I'm polishing up a website and I've setup in IIS the custom error templates
that I need (404 etc,,,) I'm not having any luck handling *.cfm files
though.  Is there a way to throw a custom error message for those in the
application.cfm using 
That doesn't seem to be working for me either what gives?

-Will

ex) www.mysite.com/customer.cfm should be www.mysite.com/customerInfo.cfm
and throw a custom 404 error message


__
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

[VAN VLIET, SCOTT E (SBCSI)]

#Name#
 



-- 
SCOTT VAN VLIET 
SENIOR ANALYST 
SBC SERVICES, INC 
Tel: 858.886.3878 
Fax: 858.653.6763 
Email: [EMAIL PROTECTED]  




-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 1:43 PM
To: CF-Talk
Subject: cfdirectory


I am using the cfdirectory tag to get a list of directories .. how do not
show the two top directories.

my directory looks like this
.
.
dir1
dir2
dir3

I just want to show the dir1,dir2,dir3 and not the period directories
(whatever they are called).

Thanks
Paul Giesenhagen
QuillDesign
http://www.quilldesign.com
SiteDirector v2.0 - Commerce Builder



__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
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: CF 404 error template?

[Dan Phillips]

In the 404 config screen, set it up as a URL, not a file. Then go to the
home directory, tab, configuration, and find the *.cfm extension. Click edit
and check the box that says "check that file exists"

This should make the 404 page show up the way you want it to.


Dan Phillips
CFXHosting.com

-Original Message-
From: Will Ryan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 4:47 PM
To: CF-Talk
Subject: CF 404 error template?


Hello All,

 I'm polishing up a website and I've setup in IIS the custom error templates
that I need (404 etc,,,) I'm not having any luck handling *.cfm files
though.  Is there a way to throw a custom error message for those in the
application.cfm using 
That doesn't seem to be working for me either what gives?

-Will

ex) www.mysite.com/customer.cfm should be www.mysite.com/customerInfo.cfm
and throw a custom 404 error message


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

[Clint Tredway]

Couldn't you put an mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 3:43 PM
To: CF-Talk
Subject: cfdirectory


I am using the cfdirectory tag to get a list of directories .. how do not
show the two top directories.

my directory looks like this
.
.
dir1
dir2
dir3

I just want to show the dir1,dir2,dir3 and not the period directories
(whatever they are called).

Thanks
Paul Giesenhagen
QuillDesign
http://www.quilldesign.com
SiteDirector v2.0 - Commerce Builder



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

[Jim Curran]

OTTOMH,

In your CFOUTPUT use startrow="3"

I think the first two dirs are *always* the . and ..  Anyone back me up on
this?

- j

-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 4:43 PM
To: CF-Talk
Subject: cfdirectory


I am using the cfdirectory tag to get a list of directories .. how do not
show the two top directories.

my directory looks like this
.
.
dir1
dir2
dir3

I just want to show the dir1,dir2,dir3 and not the period directories
(whatever they are called).

Thanks
Paul Giesenhagen
QuillDesign
http://www.quilldesign.com
SiteDirector v2.0 - Commerce Builder



__
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: CF & JS Menus

[Matt Robertson]

I found Milonic DHTML menus from recommendations on this list.  Its either free with a 
link or $30 annually for a support contract, which lets you use it link-free.

http://milonic.com/menu

I built a free tag that works with it on dynamic menus populated from query output:

http://devex.macromedia.com/developer/gallery/info.cfm?ID=03A655E5-107A-11D6-83FE00508B94F380&method=Full

Not a standalone app, but should show you how to insert it into your own system real 
easy.

---
Matt Robertson[EMAIL PROTECTED]
MSB Designs, Inc., www.mysecretbase.com
---


-- Original Message --
from: "Tangorre, Michael T." <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
date: Thu, 21 Mar 2002 16:22:02 -0500

Hello Everyone.

I have been playing with the IE DOM and NS DOM for the past two weeks, and
decided to ask if anyone knows of any good JS menu scripts that looks nice
and work in IE4+, NS4.08+?
I would appreciate any links or advice.

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

Re: cfdirectory

[Howie Hamlin]

Unfortunately, Windows considers the "." and ".." to be valid directories (current 
directory and parent directory respectively) so
you are always going to see those in a directory list.  The best thing to do is to 
filter them out in your code.


  do something


HTH,

--
Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc. - www.CoolFusion.com  - 631-737-4668 x101
inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server
>>> Find out how iMS Stacks up to the competition: 
>http://www.coolfusion.com/imssecomparison.cfm

- Original Message -
From: "Paul Giesenhagen" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, March 21, 2002 4:42 PM
Subject: cfdirectory


> I am using the cfdirectory tag to get a list of directories .. how do not
> show the two top directories.
>
> my directory looks like this
> .
> .
> dir1
> dir2
> dir3
>
> I just want to show the dir1,dir2,dir3 and not the period directories
> (whatever they are called).
>
> Thanks
> Paul Giesenhagen
> QuillDesign
> http://www.quilldesign.com
> SiteDirector v2.0 - Commerce Builder
>
>
> 
__
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: Cfmail mimeattach vs. cfmailparam

[Howie Hamlin]

I would recommend using cfmailparam exclusively as it replaces mimeattach and I would 
imagine that mimeattach could be deprecated in
the future.

Regards,

--
Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc. - www.CoolFusion.com  - 631-737-4668 x101
inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server
>>> Find out how iMS Stacks up to the competition: 
>http://www.coolfusion.com/imssecomparison.cfm


- Original Message -
From: "Owen Leonard" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, March 21, 2002 4:35 PM
Subject: Cfmail mimeattach vs. cfmailparam


> Is there any practical difference between using cfmail's mimeattach versus
> adding a cfmailparam tag, besides the ability to attach more than one file
> to a message with cfmailparam?
>
> -- Owen
>
> 
> Athens County Library Services
> http://www.athenscounty.lib.oh.us
>
>
> 
__
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

CF 404 error template?

[Will Ryan]

Hello All,

 I'm polishing up a website and I've setup in IIS the custom error templates
that I need (404 etc,,,) I'm not having any luck handling *.cfm files
though.  Is there a way to throw a custom error message for those in the
application.cfm using 
That doesn't seem to be working for me either what gives?

-Will

ex) www.mysite.com/customer.cfm should be www.mysite.com/customerInfo.cfm
and throw a custom 404 error message

__
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

cfdirectory

[Paul Giesenhagen]

I am using the cfdirectory tag to get a list of directories .. how do not
show the two top directories.

my directory looks like this
.
.
dir1
dir2
dir3

I just want to show the dir1,dir2,dir3 and not the period directories
(whatever they are called).

Thanks
Paul Giesenhagen
QuillDesign
http://www.quilldesign.com
SiteDirector v2.0 - Commerce Builder


__
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

Cfmail mimeattach vs. cfmailparam

[Owen Leonard]

Is there any practical difference between using cfmail's mimeattach versus
adding a cfmailparam tag, besides the ability to attach more than one file
to a message with cfmailparam?

-- Owen


Athens County Library Services
http://www.athenscounty.lib.oh.us


__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
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: CF & JS Menus

[Paul Giesenhagen]

We have a very solid script that is very compatible with many browsers.

http://www.quilldesign.com/popupmenupro/index.cfm

Drop in and check it out...

Paul Giesenhagen
QuillDesign
http://www.quilldesign.com
SiteDirector v2.0 - Commerce Builder


> Hello Everyone.
>
> I have been playing with the IE DOM and NS DOM for the past two weeks, and
> decided to ask if anyone knows of any good JS menu scripts that looks nice
> and work in IE4+, NS4.08+?
> I would appreciate any links or advice.
>
> 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

OT: Slow Response (Test Sent at 1:29 PM PST)

[VAN VLIET, SCOTT E (SBCSI)]

Test, Please Ignore.

-- 
SCOTT VAN VLIET 
SENIOR ANALYST 
SBC SERVICES, INC 
Tel: 858.886.3878 
Fax: 858.653.6763 
Email:   [EMAIL PROTECTED]


 

__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
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

CF & JS Menus

[Tangorre, Michael T.]

Hello Everyone.

I have been playing with the IE DOM and NS DOM for the past two weeks, and
decided to ask if anyone knows of any good JS menu scripts that looks nice
and work in IE4+, NS4.08+?
I would appreciate any links or advice.

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: dateadd with grouped query and cfgraph

[VAN VLIET, SCOTT E (SBCSI)]

You could modify your query object before sending it to .

EXAMPLE:


SELECT Date, Value
FROM TableName
ORDER BY Date




QuerySetCell(graphData, "Date",  DateAdd("h", 2, graphData.Date),
graphData.CurrentRow);



HTH ^_^

-- 
SCOTT VAN VLIET 
SENIOR ANALYST 
SBC SERVICES, INC 
Tel: 858.886.3878 
Fax: 858.653.6763 
Email: [EMAIL PROTECTED]  




-Original Message-
From: Jeff Beer [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 12:01 PM
To: CF-Talk
Subject: dateadd with grouped query and cfgraph


I run a graph on a server in a different time zone.  I'd like to modify the
times (hour only) by adding two hours.  However, the query is grouped by day
and hour, then fed into CFGRAPH.

Anyone know if this can be done without modifying the data in the table?

Thanks!

Jeff


__
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: Q: Looping through a CSV File

[Marlon Moyer]

I used to use a custom tag that would create datasources in cf4.5, I'm not
sure of the name anymore, but I got it off of the developer exchange.  In
essence it rewrites some registry settings, so I'm not sure if your hosting
company would allow it.  The other option is to have a permanent ODBC entry
set up on the server and then just replace the text file with one of the
same name.

Marlon

- Original Message -
From: <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, March 21, 2002 2:57 PM
Subject: RE: Q: Looping through a CSV File


> Are these ODBC options available in CFServer 4.5?  I
> have 5.0 (dev server) but our web hosting company is
> still at 4.5.
>
>
> > The structure will always be the same but the file name is going to
> > change though. I am backing up the old file before I push the new file
> > up.
> >
> > Thanks,
> > Jason Larson
> >
> >
> > -Original Message-
> > From: Marlon Moyer [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, March 21, 2002 9:35 AM
> > To: CF-Talk
> > Subject: Re: Looping through a CSV File
> >
> > If the csv structure will always be the same, you could set up an ODBC
> > connection and treat it like a table.
> >
> >
> > - Original Message -
> > From: "Mike Townend" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Thursday, March 21, 2002 10:26 AM
> > Subject: RE: Looping through a CSV File
> >
> >
> > > Treat the file as a list of lists...
> > >
> > > List 1 - Delimiter = #Chr(10)##Chr(13)#
> > >
> > > And each element of that list is a list with delimeter ,
> > >
> > > HTH
> > >
> > >
> > >
> > > -Original Message-
> > > From: Jason Larson [mailto:[EMAIL PROTECTED]]
> > > Sent: 21 March 2002 16:14
> > > To: CF-Talk
> > > Subject: Looping through a CSV File
> > >
> > >
> > > I have a CSV File that I am pushing up using cffile. I want to loop
> > > through the csv file and insert the content into a database, and I am
> > > not sure how to do this. Any help our guidance would help?
> > >
> > > Thanks
> > > Jason
> > >
> > >
> > >
> > >
> >
> >
> 
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
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

CF_TwoSelectsRelated and browser back button

[Cornillon, Matthieu]

Hello.  I am using Nate Weiss' invaluable CF_TwoSelectsRelated tag, with
almost flawless results.  But I am encountering a problem, and I wonder
whether I am alone.

I have a multi-page form, a few pages of which use CF_TwoSelectsRelated.
Each page submits its data to an action page which writes the data to a
Session variable, for later writing to the back end database.  This all
works very nicely.  For the most part, if the user hits the back button,
there is no problem.  Except in cases of pages with the CF_TwoSelectsRelated
tag.  Here's what happens:

Let's say that I have the user pick their state and city from an instance of
CF_TwoSelectsRelated.  Here are the possible options:

State dropdown   City dropdown
IdahoBoise
MassachusettsBoston
MassachusettsCambridge
MassachusettsNorthampton
Rhode Island Cranston
Rhode Island Narragansett
Rhode Island Pawtucket
Rhode Island Wakefield

They pick Rhode Island from the State dropdown, and from the four City
options that are then displayed, pick Cranston.  They submit the form, and
Rhode Island and Cranston are stored in the Session variable.  No problem.
Now, they hit the back button.  For some reason, the form now shows with
Rhode Island selected, but a blank under the City dropdown.  If you click
the City dropdown, you can't see the list of four cities that should appear.
If you change the State to Idaho, say, and then change it back to Rhode
Island, the appropriate cities then appear.  I can guess why this is
happening.  Since I have decided not to programmatically restrict use of the
back button, I was wondering whether anyone else had encountered this and
had an idea for a solution.  To a certain extent, I don't care if they hit
the back button, as long as the appropriate values are displayed in the
dropdowns.

I'd greatly appreciate any help.

Thanks,
Matthieu
__
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: CFREPORT error again!!! dll's grrrrrr..

[Frank Mamone]

There main reason is that CF_REPORT is really limited in it's output of the
report. I solved the exact same requirements as you by using a product
called Recrystallize (www.recrystallize.com) to produce both the input and
process web pages. Granted they are written in ASP, but I transform the
input parameter screen to CF and point it to the asp process page which
launches the viewer of your choice i.e., ActiveX, Java , DHTML.

You will however need Crystal installed on the web server.

There's a limited demo on their website.



- Original Message -
From: "Paul Ihrig" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, March 20, 2002 10:44 AM
Subject: RE: CFREPORT error again!!! dll's grr..


> thanks Frank
> i have looked every where.
> installed all the updates.
>
> i cant find the PDF you are referring to though..
> why use crystal any ways?
>
> seems like most reports can just be created using straight cf?
> but some one at my Co. wants crystal to run on the server
>
> not getting very far
> feels like a Monday
>
> -paul
>
>
>
> -Original Message-
> From: Frank Mamone [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 20, 2002 9:42 AM
> To: CF-Talk
> Subject: Re: CFREPORT error again!!! dll's grr..
>
>
> Check the KB at www.crystaldecisions.com. They have a PDF with possible
> causes for this error.
>
>
> - Original Message -
> From: "Paul Ihrig" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, March 20, 2002 9:30 AM
> Subject: CFREPORT error again!!! dll's grr..
>
>
> > cfstudio 5
> > crystal 8
> >
> > i have it loaded on my local machine with local server
> > i cant get this piece of crystal to work!
> >
> > i have read every thing i can find.
> > most articles said to delete this or move that dll.. but none of it
seems
> to
> > work for me!
> >
> > any ideas???
> >
> > thank you!
> > -paul
> >
> > 
> > Error Diagnostic Information
> > Error occurred while processing CFREPORT
> >
> >
> > An unexpected error occurred while using the Crystal Engine.
> >
> > Error number 534 ocurred (Error detected by database DLL.).
> >
> > Crystal Library = C:\WINNT\system32\CRPE32.DLL (2/10/2001 1:43)
> > DLL Version = 8.80, Engine Version = 8.80
> >
> >
> > The error occurred while processing an element with a general identifier
> of
> > (CFREPORT), occupying document position (9:1) to (9:125).
> >
> >
> > Date/Time: 03/20/02 06:28:04
> > Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0)
> > Remote Address: 10.232.1.20
> >
>
> 
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
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: Password Protected File Downloads

[Shawn Grover]

that's how I've done it.  Also allows you to log file access and such...

-Original Message-
From: Haggerty, Michael A. [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 1:14 PM
To: CF-Talk
Subject: RE: Password Protected File Downloads


Use CFCONTENT to serve up the actual document and store the file in a
subdirectory somewhere off the root.

That would be my guess.

M

-Original Message-
From: Jim Curran [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 2:54 PM
To: CF-Talk
Subject: Password Protected File Downloads


Hey all,

What is the most efficient way to provide files for download to a client
after username/password authentication *without* using NT Authentication.

The simple way is to validate the user using CF and then just display the
documents using CFDirectory, but, if anyone know the URL to the document,
they can bypass the cfm template altogether.  I was thinking about randomly
renaming documents and storing the filenames in a DB, but that seems sloppy
too.

This client is currently in a virtual hosting environment, so adding
directory security seems out of the question.

Any thoughts would be greatly appreciated.

TIA,

- jim




__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
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: Password Protected File Downloads

[Jim Curran]

Thanks Bryan and Mike, 

Works perfectly.

- j


__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
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: Password Protected File Downloads

[VAN VLIET, SCOTT E (SBCSI)]

What about in digital asset distribution, such as ESD's?

Does CFCONTENT store the file in memory before it serves it to the client?
If so, then won't your server crash (or will the user just experience a long
wait before the data is sent) if you have 15 clients downloading an 80 MB
file at one time?  Or does CFCONTENT stream the file data?

Thoughts?

-- 
SCOTT VAN VLIET 
SENIOR ANALYST 
SBC SERVICES, INC 
Tel: 858.886.3878 
Fax: 858.653.6763 
Email: [EMAIL PROTECTED]  




-Original Message-
From: Chambers, Bryan (NE) [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 12:55 PM
To: CF-Talk
Subject: RE: Password Protected File Downloads


Hi Jim,

CFCONTENT may be the way to go to serve up the files.  The files to be
downloaded would sit outside of the webroot so it would be impossible to get
to them by typing in a URL.

-Bryan

-Original Message-
From: Jim Curran [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 2:54 PM
To: CF-Talk
Subject: Password Protected File Downloads


Hey all,

What is the most efficient way to provide files for download to a client
after username/password authentication *without* using NT Authentication.

The simple way is to validate the user using CF and then just display the
documents using CFDirectory, but, if anyone know the URL to the document,
they can bypass the cfm template altogether.  I was thinking about randomly
renaming documents and storing the filenames in a DB, but that seems sloppy
too.

This client is currently in a virtual hosting environment, so adding
directory security seems out of the question.

Any thoughts would be greatly appreciated.

TIA,

- jim




__
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: Q: Looping through a CSV File

[coldfusion . developer]

Are these ODBC options available in CFServer 4.5?  I 
have 5.0 (dev server) but our web hosting company is 
still at 4.5.


> The structure will always be the same but the file name is going to
> change though. I am backing up the old file before I push the new file
> up.
> 
> Thanks,
> Jason Larson
>  
> 
> -Original Message-
> From: Marlon Moyer [mailto:[EMAIL PROTECTED]] 
> Sent: Thursday, March 21, 2002 9:35 AM
> To: CF-Talk
> Subject: Re: Looping through a CSV File
> 
> If the csv structure will always be the same, you could set up an ODBC
> connection and treat it like a table.
> 
> 
> - Original Message -
> From: "Mike Townend" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, March 21, 2002 10:26 AM
> Subject: RE: Looping through a CSV File
> 
> 
> > Treat the file as a list of lists...
> >
> > List 1 - Delimiter = #Chr(10)##Chr(13)#
> >
> > And each element of that list is a list with delimeter ,
> >
> > HTH
> >
> >
> >
> > -Original Message-
> > From: Jason Larson [mailto:[EMAIL PROTECTED]]
> > Sent: 21 March 2002 16:14
> > To: CF-Talk
> > Subject: Looping through a CSV File
> >
> >
> > I have a CSV File that I am pushing up using cffile. I want to loop
> > through the csv file and insert the content into a database, and I am
> > not sure how to do this. Any help our guidance would help?
> >
> > Thanks
> > Jason
> >
> >
> >
> > 
> 
> 
__
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: Password Protected File Downloads

[Chambers, Bryan (NE)]

Hi Jim,

CFCONTENT may be the way to go to serve up the files.  The files to be
downloaded would sit outside of the webroot so it would be impossible to get
to them by typing in a URL.

-Bryan

-Original Message-
From: Jim Curran [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 2:54 PM
To: CF-Talk
Subject: Password Protected File Downloads


Hey all,

What is the most efficient way to provide files for download to a client
after username/password authentication *without* using NT Authentication.

The simple way is to validate the user using CF and then just display the
documents using CFDirectory, but, if anyone know the URL to the document,
they can bypass the cfm template altogether.  I was thinking about randomly
renaming documents and storing the filenames in a DB, but that seems sloppy
too.

This client is currently in a virtual hosting environment, so adding
directory security seems out of the question.

Any thoughts would be greatly appreciated.

TIA,

- jim



__
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 and flash part 2.5

[Douglas Brown]

I notice that half of it is done in flash, but the actual cart is still done in html. 
With a 98% market share, I am not in the least bit worried about the 2% that cannot 
view flash.







"Success is a journey, not a destination!!"



Doug Brown
- Original Message - 
From: "Jason Kufner" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, March 21, 2002 12:07 PM
Subject: cold fusion and flash part 2.5


> This is a multi-part message in MIME format.
> 
> --=_NextPart_000_0001_01C1D0D0.F5A41230
> Content-Type: text/plain;
> charset="us-ascii"
> Content-Transfer-Encoding: 7bit
> 
> I'm just jumping in... I haven't read all the back post on this yet.
> (I'm busy for two days and I come back to 329 emails)
>  
> I've been working on flash and coldfusion as well. So this thread caught
> my attention. Someone said they wanted to make the first flash shopping
> cart. This web site did it a while ago. It was macromedias' site of the
> day in June 2001.
>  
> http://www.ajgear.com/
>  
>  
> There are some REAL navigation issues with this website, but get what
> you can out of it. (An interesting note:  the first launch had no html
> option. Only flash. You still need two versions even with macromedias
> 98% market.) share.
>  
>  
> 
> --=_NextPart_000_0001_01C1D0D0.F5A41230
> Content-Type: text/html;
> charset="us-ascii"
> Content-Transfer-Encoding: quoted-printable
> 
>  xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
> xmlns=3D"http://www.w3.org/TR/REC-html40";>
> 
> 
>  charset=3Dus-ascii">
> 
> 
> 
> 
> 
> cid:[EMAIL PROTECTED]";>
> 
> 
> 
> 
> 
> 
> 
>  style=3D'tab-interval:.5in'>
> 
> 
> 
>  style=3D'mso-layout-grid-align:none;text-autospace:none'> size=3D2 face=3D"Courier New"> style=3D'font-size:10.0pt;font-family:"Courier New"'>I'm
> just jumping in... I haven’t read all the back post on this yet. =
> (I'm
> busy for two days and I come back to 329 =
> emails)
> 
>  style=3D'mso-layout-grid-align:none;text-autospace:none'> size=3D2 face=3D"Courier New"> style=3D'font-size:10.0pt;font-family:"Courier =
> New"'> 
> 
>  style=3D'mso-layout-grid-align:none;text-autospace:none'> size=3D2 face=3D"Courier New"> style=3D'font-size:10.0pt;font-family:"Courier New"'>I've
> been working on flash and coldfusion as =
> well. So this
> thread caught my attention. Someone said they wanted to make the first =
> flash
> shopping cart. This web site did it a while ago. It was macromedias' =
> site of
> the day in June 2001.
> 
>  style=3D'mso-layout-grid-align:none;text-autospace:none'> size=3D2 face=3D"Courier New"> style=3D'font-size:10.0pt;font-family:"Courier =
> New"'> 
> 
>  style=3D'mso-layout-grid-align:none;text-autospace:none'> size=3D2 face=3D"Courier New"> style=3D'font-size:10.0pt;font-family:"Courier New"'> href=3D"http://www.ajgear.com/";>http://www.ajgear.com/ an>
> 
>  style=3D'mso-layout-grid-align:none;text-autospace:none'> size=3D2 face=3D"Courier New"> style=3D'font-size:10.0pt;font-family:"Courier =
> New"'> 
> 
>  style=3D'mso-layout-grid-align:none;text-autospace:none'> size=3D2 face=3D"Courier New"> style=3D'font-size:10.0pt;font-family:"Courier =
> New"'> 
> 
>  style=3D'mso-layout-grid-align:none;text-autospace:none'> size=3D2 face=3D"Courier New"> style=3D'font-size:10.0pt;font-family:"Courier New"'>There
> are some REAL navigation issues with this website, but get what you can =
> out of
> it. (An interesting note:  =
> the first
> launch had no html option. Only flash. You still need two versions even =
> with
> macromedias 98% market.)  class=3DGramE>share.
> 
>  style=3D'mso-layout-grid-align:none;text-autospace:none'> size=3D2 face=3D"Courier New"> style=3D'font-size:10.0pt;font-family:"Courier =
> New"'> 
> 
>  style=3D'font-size:10.0pt;
> font-family:Arial'> 
> 
> 
> 
> 
> 
> 
> 
> --=_NextPart_000_0001_01C1D0D0.F5A41230--
> 
> 
> FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
> Archives: http://www.mail-archiv

RE: dateadd with grouped query and cfgraph

[Jeff Beer]

Adam, Dave, and anyone who answers before this hits the list - thanks for
the assist!!


-Original Message-
From: Cantrell, Adam [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 3:13 PM
To: CF-Talk
Subject: RE: dateadd with grouped query and cfgraph


Not exactly sure how your db handles INTERVAL functions, but you could
select your  +  AS offsetDateTime.  being a CF
variable equaling your offset, which would be 0 for anything local, 2 for
your example.

Adam.



> -Original Message-
> From: Jeff Beer [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 21, 2002 2:01 PM
> To: CF-Talk
> Subject: dateadd with grouped query and cfgraph
>
>
> I run a graph on a server in a different time zone.  I'd like
> to modify the
> times (hour only) by adding two hours.  However, the query is
> grouped by day
> and hour, then fed into CFGRAPH.
>
> Anyone know if this can be done without modifying the data in
> the table?
>
> Thanks!
>
> Jeff
>
>

__
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: PreserveSingleQuotes() - CF 5 Bug?

[James Ang]

Scott,

Are you sure PreserveSingleQuotes(Trim(blah)) works in CF 4.5.x? If so,
then the CFML parser was erroneously "optimized". I am guessing, and I
have been known to be completely wrong with my guesses, they
consolidated the "general addressing" and "complex expressions with
functions" parse logic in CF 5 for performance reason.

I know from memory that PreserveSingleQuotes(a[b]) (i.e. with "general
addressing") does not work in CF 4.5.x. It has been a while since I last
coded for CF 4.5.x servers ;)

Good luck!

James Ang
MedSeek, Inc.

-Original Message-
From: VAN VLIET, SCOTT E (SBCSI) [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, March 21, 2002 11:44 AM
To: CF-Talk
Subject: RE: PreserveSingleQuotes() - CF 5 Bug?


This works in CF 4.5, though.

What's changed from CF 4.5 to 5 to make this no longer work?

-- 
SCOTT VAN VLIET 
SENIOR ANALYST 
SBC SERVICES, INC 
Tel: 858.886.3878 
Fax: 858.653.6763 
Email: [EMAIL PROTECTED]  




-Original Message-
From: James Ang [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 11:15 AM
To: CF-Talk
Subject: RE: PreserveSingleQuotes() - CF 5 Bug?


This is a known bug. It was discovered at the latter stage of the CF5
Beta. I can't remember the engineer who worked with me to determine the
bug. But it is related to a bug in CFQUERY. You cannot have pounded
variables within CFQUERY that uses "general addressing" (the actual term
used by the Allaire engineer). A variable that is referenced via
"general addressing" has the square brackets in it. Examples are arrays,
structures, and queries referencing that looks like a[b].

For PreserveSingleQuotes(), you cannot have anything complex between the
parentheses such as an expression that requires the execution of a
function which in your case is Trim(). Keep your calls to
PreserveSingleQuotes() to the format: PreserveSingleQuotes(a) or
PreserveSingleQuotes(a.b.c.d)

I wonder if this is fixed in NEO

Oh well. Got a project deadline to meet... :)

Good luck!

James Ang
MedSeek, Inc.

-Original Message-
From: VAN VLIET, SCOTT E (SBCSI) [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, March 21, 2002 10:24 AM
To: CF-Talk
Subject: PreserveSingleQuotes() - CF 5 Bug?


When nesting functions in the PreserveSingleQuotes() function, CF 5
throws an error.

EXAMPLE:



This throws the following error:


Error Diagnostic Information
Just in time compilation error

Invalid parser construct found on line 27 at position 37. ColdFusion was
looking at the following text:

(

Invalid expression format. The usual cause is an error in the expression
structure.


Is this a known bug?  If I pull out the trim and throw it into a
variable, it works.

EXAMPLE




Is this a known bug? Have any of you encountered this?

Thanks!

-- 
SCOTT VAN VLIET 
SENIOR ANALYST 
SBC SERVICES, INC 
Tel: 858.886.3878 
Fax: 858.653.6763 
Email: [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: dateadd with grouped query and cfgraph

[Jeff Beer]

I figured it out - sorry for the bother.  here's the fix:


blah blah blah...

DATEPART(hh, DATEADD(hh, 2, who.ActionDateTime)) AS HOURS

GROUP BY DATEPART(hh, DATEADD(hh, 2, who.ActionDateTime))

blah blah blah
mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 3:01 PM
To: CF-Talk
Subject: dateadd with grouped query and cfgraph


I run a graph on a server in a different time zone.  I'd like to modify the
times (hour only) by adding two hours.  However, the query is grouped by day
and hour, then fed into CFGRAPH.

Anyone know if this can be done without modifying the data in the table?

Thanks!

Jeff


__
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: dateadd with grouped query and cfgraph

[Cantrell, Adam]

Not exactly sure how your db handles INTERVAL functions, but you could
select your  +  AS offsetDateTime.  being a CF
variable equaling your offset, which would be 0 for anything local, 2 for
your example.

Adam.



> -Original Message-
> From: Jeff Beer [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 21, 2002 2:01 PM
> To: CF-Talk
> Subject: dateadd with grouped query and cfgraph
> 
> 
> I run a graph on a server in a different time zone.  I'd like 
> to modify the
> times (hour only) by adding two hours.  However, the query is 
> grouped by day
> and hour, then fed into CFGRAPH.
> 
> Anyone know if this can be done without modifying the data in 
> the table?
> 
> Thanks!
> 
> Jeff
> 
> 
__
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: Password Protected File Downloads

[Haggerty, Michael A.]

Use CFCONTENT to serve up the actual document and store the file in a
subdirectory somewhere off the root. 

That would be my guess.

M

-Original Message-
From: Jim Curran [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 2:54 PM
To: CF-Talk
Subject: Password Protected File Downloads


Hey all,

What is the most efficient way to provide files for download to a client
after username/password authentication *without* using NT Authentication.

The simple way is to validate the user using CF and then just display the
documents using CFDirectory, but, if anyone know the URL to the document,
they can bypass the cfm template altogether.  I was thinking about randomly
renaming documents and storing the filenames in a DB, but that seems sloppy
too.

This client is currently in a virtual hosting environment, so adding
directory security seems out of the question.

Any thoughts would be greatly appreciated.

TIA,

- jim



__
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: dateadd with grouped query and cfgraph

[Dave Watts]

> I run a graph on a server in a different time zone. I'd like 
> to modify the times (hour only) by adding two hours. However, 
> the query is grouped by day and hour, then fed into CFGRAPH.
> 
> Anyone know if this can be done without modifying the data in 
> the table?

You could modify the data in the query object, after running the query,
using QuerySetCell and the other query functions. You could even use the
query-of-query functionality to do the same thing with SQL.

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

__
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

cold fusion and flash part 2.5

[Jason Kufner]

This is a multi-part message in MIME format.

--=_NextPart_000_0001_01C1D0D0.F5A41230
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

I'm just jumping in... I haven't read all the back post on this yet.
(I'm busy for two days and I come back to 329 emails)
 
I've been working on flash and coldfusion as well. So this thread caught
my attention. Someone said they wanted to make the first flash shopping
cart. This web site did it a while ago. It was macromedias' site of the
day in June 2001.
 
http://www.ajgear.com/
 
 
There are some REAL navigation issues with this website, but get what
you can out of it. (An interesting note:  the first launch had no html
option. Only flash. You still need two versions even with macromedias
98% market.) share.
 
 

--=_NextPart_000_0001_01C1D0D0.F5A41230
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

http://www.w3.org/TR/REC-html40";>








cid:[EMAIL PROTECTED]";>











I'm
just jumping in... I haven’t read all the back post on this yet. =
(I'm
busy for two days and I come back to 329 =
emails)

 

I've
been working on flash and coldfusion as =
well. So this
thread caught my attention. Someone said they wanted to make the first =
flash
shopping cart. This web site did it a while ago. It was macromedias' =
site of
the day in June 2001.

 

http://www.ajgear.com/";>http://www.ajgear.com/

 

 

There
are some REAL navigation issues with this website, but get what you can =
out of
it. (An interesting note:  =
the first
launch had no html option. Only flash. You still need two versions even =
with
macromedias 98% market.) share.

 

 







--=_NextPart_000_0001_01C1D0D0.F5A41230--


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: Flash MX and CF5 pt2.5

[VAN VLIET, SCOTT E (SBCSI)]

FYI - I think the first actual Flash-based shopping cart (that was featured
by Macromedia) was The Blair Witch project (using Flash 4, I believe).
There is also a sample Flash-based shopping cart in "Flash 4 Magic", and I
can assume that there were a bunch with Flash 5.

-- 
SCOTT VAN VLIET 
SENIOR ANALYST 
SBC SERVICES, INC 
Tel: 858.886.3878 
Fax: 858.653.6763 
Email: [EMAIL PROTECTED]  




-Original Message-
From: Jason Kufner [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 11:48 AM
To: CF-Talk
Subject: re: Flash MX and CF5 pt2.5


I'm just jumping in... I haven't read all the back post on this yet.
(I'm busy for two days and I come back to 329 emails)

I've been working on flash and coldfusion as well. So this thread caught
my attention. Someone said they wanted to make the first flash shopping
cart. This web site did it a while ago. It was macromedias' site of the
day in June 2001.

http://www.ajgear.com/


There are some REAL navigation issues with this website, but get what
you can out of it. (An interesting note:  the first launch had no html
option. Only flash. You still need two versions even with macromedias
98% market.) share.


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: Client variable security (Re: The trouble with cookies ...)

[Dave Watts]

> > You can simply write them once, by setting the
> > SETCLIENTCOOKIE attribute of CFAPPLICATION to "false" or 
> > "no", and then creating your own CFID and CFTOKEN "session" 
> > cookies with the appropriate CFID and CFTOKEN values from 
> > the Client or Session scope.
> 
> OK .. I've disabled setclientcookies, but I don't quite understand 
> the second 1/2 of the sentance. Would you mind explaining a little 
> more?

I posted this snippet yesterday:











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

__
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

dateadd with grouped query and cfgraph

[Jeff Beer]

I run a graph on a server in a different time zone.  I'd like to modify the
times (hour only) by adding two hours.  However, the query is grouped by day
and hour, then fed into CFGRAPH.

Anyone know if this can be done without modifying the data in the table?

Thanks!

Jeff

__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
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

Password Protected File Downloads

[Jim Curran]

Hey all,

What is the most efficient way to provide files for download to a client
after username/password authentication *without* using NT Authentication.

The simple way is to validate the user using CF and then just display the
documents using CFDirectory, but, if anyone know the URL to the document,
they can bypass the cfm template altogether.  I was thinking about randomly
renaming documents and storing the filenames in a DB, but that seems sloppy
too.

This client is currently in a virtual hosting environment, so adding
directory security seems out of the question.

Any thoughts would be greatly appreciated.

TIA,

- jim


__
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: Flash MX and CF5 pt2.5

[Jason Kufner]

I'm just jumping in... I haven't read all the back post on this yet.
(I'm busy for two days and I come back to 329 emails)

I've been working on flash and coldfusion as well. So this thread caught
my attention. Someone said they wanted to make the first flash shopping
cart. This web site did it a while ago. It was macromedias' site of the
day in June 2001.

http://www.ajgear.com/


There are some REAL navigation issues with this website, but get what
you can out of it. (An interesting note:  the first launch had no html
option. Only flash. You still need two versions even with macromedias
98% market.) share.


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: PreserveSingleQuotes() - CF 5 Bug?

[VAN VLIET, SCOTT E (SBCSI)]

This works in CF 4.5, though.

What's changed from CF 4.5 to 5 to make this no longer work?

-- 
SCOTT VAN VLIET 
SENIOR ANALYST 
SBC SERVICES, INC 
Tel: 858.886.3878 
Fax: 858.653.6763 
Email: [EMAIL PROTECTED]  




-Original Message-
From: James Ang [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 11:15 AM
To: CF-Talk
Subject: RE: PreserveSingleQuotes() - CF 5 Bug?


This is a known bug. It was discovered at the latter stage of the CF5
Beta. I can't remember the engineer who worked with me to determine the
bug. But it is related to a bug in CFQUERY. You cannot have pounded
variables within CFQUERY that uses "general addressing" (the actual term
used by the Allaire engineer). A variable that is referenced via
"general addressing" has the square brackets in it. Examples are arrays,
structures, and queries referencing that looks like a[b].

For PreserveSingleQuotes(), you cannot have anything complex between the
parentheses such as an expression that requires the execution of a
function which in your case is Trim(). Keep your calls to
PreserveSingleQuotes() to the format: PreserveSingleQuotes(a) or
PreserveSingleQuotes(a.b.c.d)

I wonder if this is fixed in NEO

Oh well. Got a project deadline to meet... :)

Good luck!

James Ang
MedSeek, Inc.

-Original Message-
From: VAN VLIET, SCOTT E (SBCSI) [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, March 21, 2002 10:24 AM
To: CF-Talk
Subject: PreserveSingleQuotes() - CF 5 Bug?


When nesting functions in the PreserveSingleQuotes() function, CF 5
throws an error.

EXAMPLE:



This throws the following error:


Error Diagnostic Information
Just in time compilation error

Invalid parser construct found on line 27 at position 37. ColdFusion was
looking at the following text:

(

Invalid expression format. The usual cause is an error in the expression
structure.


Is this a known bug?  If I pull out the trim and throw it into a
variable, it works.

EXAMPLE




Is this a known bug? Have any of you encountered this?

Thanks!

-- 
SCOTT VAN VLIET 
SENIOR ANALYST 
SBC SERVICES, INC 
Tel: 858.886.3878 
Fax: 858.653.6763 
Email: [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: Recursion issue

[Don Vawter]

You may want to put a maximum number of steps in your recursion for testing
to make sure you havent gotten into a loop. You can always take it out later
when you are sure the function is well behaved.

°¿°
 ~
Don Vawter

- Original Message -
From: "Michael Corrigan" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, March 21, 2002 12:31 PM
Subject: Re: Recursion issue


> >From what I can tell yes.  It displays the information the way it is
supposed to and it appears that the browser stops 'thinking' and I can keep
working in the app, but a few minutes later it crashes.  Our administrator
is stumped.  I ran the function while he was watching the resource meter and
it looked like everything was fine.  I just wasn't sure if there was
something tricky with CF5 that I'm not aware of. I was told of a possible
memory leak with NT4 but we're properly patched so that doesn't appear to be
it.  I love using the recursive function because it's perfect for what I'm
doing (a series of parent child relationships).  I'm going to take a look at
the data and see if a parent and child are pointing to one another.  That
might screw things up.  I didn't think to handle that
> exception.
>
>
> Michael Corrigan
> Programmer
> Endora Digital Solutions
> 1900 Highland Avenue, Suite 200
> Lombard, IL 60148
> 630-627-5055 ext.-136
> 630/627-5255 Fax
>   - Original Message -
>   From: Christopher Olive
>   To: CF-Talk
>   Sent: Thursday, March 21, 2002 1:05 PM
>   Subject: RE: Recursion issue
>
>
>   is the exit condition being met correctly in the recursive function?
>
>   christopher olive
>   cto, vp of web development, vp it security
>   atnet solutions, inc.
>   410.931.4092
>   http://www.atnetsolutions.com
>
>
>   -Original Message-
>   From: Michael Corrigan [mailto:[EMAIL PROTECTED]]
>   Sent: Thursday, March 21, 2002 12:28 PM
>   To: CF-Talk
>   Subject: Recursion issue
>
>
>   We have an NT4 box with CF5 and I have a recursive function that appears
to run fine, but about five -ten minutes later, our system resources max out
and locks the server.  I can't find anything about this and was wondering if
anyone has had a similar problem?
>
>   Thanks,
>
>   Michael Corrigan
>   Programmer
>   Endora Digital Solutions
>   1900 Highland Avenue, Suite 200
>   Lombard, IL 60148
>   630-627-5055 ext.-136
>   630/627-5255 Fax
>
>
>
> 
__
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: Interesting Select Problem.

[Neil H.]

Figured it out :)  It was a problem on my machine but man that was
confusing.  I couldn't pop a big select box.  Gotta love windows :)

Neil

- Original Message -
From: "Neil H." <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, March 21, 2002 2:29 PM
Subject: Interesting Select Problem.


> I am using a style sheet to pretty up a select box.  I can't get the
select
> box to drop down.  I can hit the down arrow and I can see the options
> change.  I noticed this on select boxes with a large number of selections.
> The same style on smaller groups in a select box seem to work.
>
> This seems very strange, and ideas out there?
>
> Thanks,
>
> 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

RE: Inserting CFIF into CFINPUT

[Sam Roach]

-Original Message-
From: Angel Stewart [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 11:07 AM
To: CF-Talk
Subject: Inserting CFIF into CFINPUT


Hey all,

I want to make a CFINPUT Radio button checked or unchecked depending on
the value of a variable from the database.
Simple right?

Yup..I thought so too.

So why doesn't it work?


CHECKED = "TRUE"  >

I get this error:

---

Just in time compilation error

Invalid token found on line 52 at position 67. ColdFusion was looking at
the following text:

<
Invalid expression element. The usual cause of this error is a
misspelling in the expression text.
The last successfully parsed CFML construct was a CFINPUT tag occupying
document position (52:21) to (52:28).

---

Any ideas on what I'm doing wrong? I expect it to be some simple syntax
error.

-Gel




__
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: Recursion issue

[Michael Corrigan]

>From what I can tell yes.  It displays the information the way it is supposed to and 
>it appears that the browser stops 'thinking' and I can keep working in the app, but a 
>few minutes later it crashes.  Our administrator is stumped.  I ran the function 
>while he was watching the resource meter and it looked like everything was fine.  I 
>just wasn't sure if there was something tricky with CF5 that I'm not aware of. I was 
>told of a possible memory leak with NT4 but we're properly patched so that doesn't 
>appear to be it.  I love using the recursive function because it's perfect for what 
>I'm doing (a series of parent child relationships).  I'm going to take a look at the 
>data and see if a parent and child are pointing to one another.  That might screw 
>things up.  I didn't think to handle that 
exception.


Michael Corrigan
Programmer
Endora Digital Solutions
1900 Highland Avenue, Suite 200
Lombard, IL 60148
630-627-5055 ext.-136
630/627-5255 Fax
  - Original Message - 
  From: Christopher Olive 
  To: CF-Talk 
  Sent: Thursday, March 21, 2002 1:05 PM
  Subject: RE: Recursion issue


  is the exit condition being met correctly in the recursive function?

  christopher olive
  cto, vp of web development, vp it security
  atnet solutions, inc.
  410.931.4092
  http://www.atnetsolutions.com


  -Original Message-
  From: Michael Corrigan [mailto:[EMAIL PROTECTED]]
  Sent: Thursday, March 21, 2002 12:28 PM
  To: CF-Talk
  Subject: Recursion issue


  We have an NT4 box with CF5 and I have a recursive function that appears to run 
fine, but about five -ten minutes later, our system resources max out and locks the 
server.  I can't find anything about this and was wondering if anyone has had a 
similar problem?

  Thanks,

  Michael Corrigan
  Programmer
  Endora Digital Solutions
  1900 Highland Avenue, Suite 200
  Lombard, IL 60148
  630-627-5055 ext.-136
  630/627-5255 Fax


  
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
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

Interesting Select Problem.

[Neil H.]

I am using a style sheet to pretty up a select box.  I can't get the select
box to drop down.  I can hit the down arrow and I can see the options
change.  I noticed this on select boxes with a large number of selections.
The same style on smaller groups in a select box seem to work.

This seems very strange, and ideas out there?

Thanks,

Neil

__
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: Inserting CFIF into CFINPUT

[Dave Watts]

> I want to make a CFINPUT Radio button checked or unchecked 
> depending on the value of a variable from the database.
> Simple right?
> 
> Yup..I thought so too.
> 
> So why doesn't it work?
> 
>  eq "Male"> CHECKED = "TRUE"  >
> 
> I get this error ...
> 
> Any ideas on what I'm doing wrong? I expect it to be some 
> simple syntax error.

As Matt points out, you can't nest one CF tag directly within another CF
tag.

The easiest solution in this case would be to simply use the HTML INPUT tag,
instead of the CFML tag CFINPUT, which provides extra functionality which
you don't seem to be using anyway. Alternatively, if you want to use
CFINPUT, you could use the inline if function, which lets you convert your
tag-based condition into an expression:



Personally, though, I'd just use the HTML INPUT. CFINPUT doesn't seem to add
any useful functionality to radio buttons and checkboxes, in my opinion.

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

__
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: Inserting CFIF into CFINPUT

[Stephenie Hamilton]

you can't do this with cfinput tag, only with input...ie:

CHECKED>


~~
Stephenie Hamilton
Macromedia Certified ColdFusion Professional
http://coldfusionwebs.com




-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 2:20 PM
To: CF-Talk
Subject: Re: Inserting CFIF into CFINPUT


It may be an extra # around that tag and nothing to do with the
tag (I can't see anything wrong
excpet the use of # around GEC.Sex is not required).

HTH

Bryan Stevenson
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
p. 250.920.8830
e. [EMAIL PROTECTED]
-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder & Director
www.cfug-vancouverisland.com

- Original Message -
From: "Angel Stewart" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, March 21, 2002 11:06 AM
Subject: Inserting CFIF into CFINPUT


> Hey all,
>
> I want to make a CFINPUT Radio button checked or unchecked
depending on
> the value of a variable from the database.
> Simple right?
>
> Yup..I thought so too.
>
> So why doesn't it work?
>
> 
> CHECKED = "TRUE"  >
>
> I get this error:
> ---
-
> ---
>
> Just in time compilation error
>
> Invalid token found on line 52 at position 67. ColdFusion was
looking at
> the following text:
>
> <
> Invalid expression element. The usual cause of this error is a
> misspelling in the expression text.
> The last successfully parsed CFML construct was a CFINPUT tag
occupying
> document position (52:21) to (52:28).
> ---
-
> ---
>
> Any ideas on what I'm doing wrong? I expect it to be some
simple syntax
> error.
>
> -Gel
>
>
>
>
_
_
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


__
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:SOLVED: Inserting CFIF into CFINPUT

[Angel Stewart]

There ya go :)

Ok..

-Gel


-Original Message-
From: Matthew R. Small [mailto:[EMAIL PROTECTED]] 

Because you can't nest cf tags.

- Matt Small

-Original Message-
From: Angel Stewart [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, March 21, 2002 2:07 PM
To: CF-Talk
Subject: Inserting CFIF into CFINPUT

Hey all,

I want to make a CFINPUT Radio button checked or unchecked depending on
the value of a variable from the database. Simple right?

Yup..I thought so too.

So why doesn't it work?


CHECKED = "TRUE"  >

I get this error:

---

Just in time compilation error

Invalid token found on line 52 at position 67. ColdFusion was looking at
the following text:

<
Invalid expression element. The usual cause of this error is a
misspelling in the expression text. The last successfully parsed CFML
construct was a CFINPUT tag occupying document position (52:21) to
(52:28).

---

Any ideas on what I'm doing wrong? I expect it to be some simple syntax
error.

-Gel





__
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: Inserting CFIF into CFINPUT

[Tim Claremont]

You could set a variable OUTSIDE the tag, and then put the value of that
variable INSIDE the tag.

Logically, like this...

If sex = m, let foobar = checked
If sex = f, let foobar = unchecked



T




-Original Message-
From: Matthew R. Small [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, March 21, 2002 2:20 PM
To: CF-Talk
Subject: RE: Inserting CFIF into CFINPUT


Because you can't nest cf tags.

- Matt Small

-Original Message-
From: Angel Stewart [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, March 21, 2002 2:07 PM
To: CF-Talk
Subject: Inserting CFIF into CFINPUT

Hey all,

I want to make a CFINPUT Radio button checked or unchecked depending on
the value of a variable from the database. Simple right?

Yup..I thought so too.

So why doesn't it work?


CHECKED = "TRUE"  >

I get this error:

---

Just in time compilation error

Invalid token found on line 52 at position 67. ColdFusion was looking at
the following text:

<
Invalid expression element. The usual cause of this error is a
misspelling in the expression text. The last successfully parsed CFML
construct was a CFINPUT tag occupying document position (52:21) to
(52:28).

---

Any ideas on what I'm doing wrong? I expect it to be some simple syntax
error.

-Gel





__
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: Inserting CFIF into CFINPUT

[Bryan Stevenson]

It may be an extra # around that tag and nothing to do with the tag (I can't see 
anything wrong
excpet the use of # around GEC.Sex is not required).

HTH

Bryan Stevenson
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
p. 250.920.8830
e. [EMAIL PROTECTED]
-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder & Director
www.cfug-vancouverisland.com

- Original Message -
From: "Angel Stewart" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, March 21, 2002 11:06 AM
Subject: Inserting CFIF into CFINPUT


> Hey all,
>
> I want to make a CFINPUT Radio button checked or unchecked depending on
> the value of a variable from the database.
> Simple right?
>
> Yup..I thought so too.
>
> So why doesn't it work?
>
> 
> CHECKED = "TRUE"  >
>
> I get this error:
> 
> ---
>
> Just in time compilation error
>
> Invalid token found on line 52 at position 67. ColdFusion was looking at
> the following text:
>
> <
> Invalid expression element. The usual cause of this error is a
> misspelling in the expression text.
> The last successfully parsed CFML construct was a CFINPUT tag occupying
> document position (52:21) to (52:28).
> 
> ---
>
> Any ideas on what I'm doing wrong? I expect it to be some simple syntax
> error.
>
> -Gel
>
>
>
> 
__
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: Inserting CFIF into CFINPUT

[VAN VLIET, SCOTT E (SBCSI)]

Whoops! Didn't see the CFINPUT :)

-- 
SCOTT VAN VLIET 
SENIOR ANALYST 
SBC SERVICES, INC 
Tel: 858.886.3878 
Fax: 858.653.6763 
Email: [EMAIL PROTECTED]  




-Original Message-
From: VAN VLIET, SCOTT E (SBCSI) 
Sent: Thursday, March 21, 2002 11:16 AM
To: '[EMAIL PROTECTED]'
Subject: RE: Inserting CFIF into CFINPUT


Try This:


CHECKED>

-- 
SCOTT VAN VLIET 
SENIOR ANALYST 
SBC SERVICES, INC 
Tel: 858.886.3878 
Fax: 858.653.6763 
Email: [EMAIL PROTECTED]  




-Original Message-
From: Angel Stewart [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 11:07 AM
To: CF-Talk
Subject: Inserting CFIF into CFINPUT


Hey all,

I want to make a CFINPUT Radio button checked or unchecked depending on
the value of a variable from the database.
Simple right?

Yup..I thought so too.

So why doesn't it work?


CHECKED = "TRUE"  >

I get this error:

---

Just in time compilation error

Invalid token found on line 52 at position 67. ColdFusion was looking at
the following text:

<
Invalid expression element. The usual cause of this error is a
misspelling in the expression text.
The last successfully parsed CFML construct was a CFINPUT tag occupying
document position (52:21) to (52:28).

---

Any ideas on what I'm doing wrong? I expect it to be some simple syntax
error.

-Gel




__
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: Inserting CFIF into CFINPUT

[VAN VLIET, SCOTT E (SBCSI)]

Try This:


CHECKED>

-- 
SCOTT VAN VLIET 
SENIOR ANALYST 
SBC SERVICES, INC 
Tel: 858.886.3878 
Fax: 858.653.6763 
Email: [EMAIL PROTECTED]  




-Original Message-
From: Angel Stewart [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 11:07 AM
To: CF-Talk
Subject: Inserting CFIF into CFINPUT


Hey all,

I want to make a CFINPUT Radio button checked or unchecked depending on
the value of a variable from the database.
Simple right?

Yup..I thought so too.

So why doesn't it work?


CHECKED = "TRUE"  >

I get this error:

---

Just in time compilation error

Invalid token found on line 52 at position 67. ColdFusion was looking at
the following text:

<
Invalid expression element. The usual cause of this error is a
misspelling in the expression text.
The last successfully parsed CFML construct was a CFINPUT tag occupying
document position (52:21) to (52:28).

---

Any ideas on what I'm doing wrong? I expect it to be some simple syntax
error.

-Gel




__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
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: PreserveSingleQuotes() - CF 5 Bug?

[James Ang]

This is a known bug. It was discovered at the latter stage of the CF5
Beta. I can't remember the engineer who worked with me to determine the
bug. But it is related to a bug in CFQUERY. You cannot have pounded
variables within CFQUERY that uses "general addressing" (the actual term
used by the Allaire engineer). A variable that is referenced via
"general addressing" has the square brackets in it. Examples are arrays,
structures, and queries referencing that looks like a[b].

For PreserveSingleQuotes(), you cannot have anything complex between the
parentheses such as an expression that requires the execution of a
function which in your case is Trim(). Keep your calls to
PreserveSingleQuotes() to the format: PreserveSingleQuotes(a) or
PreserveSingleQuotes(a.b.c.d)

I wonder if this is fixed in NEO

Oh well. Got a project deadline to meet... :)

Good luck!

James Ang
MedSeek, Inc.

-Original Message-
From: VAN VLIET, SCOTT E (SBCSI) [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, March 21, 2002 10:24 AM
To: CF-Talk
Subject: PreserveSingleQuotes() - CF 5 Bug?


When nesting functions in the PreserveSingleQuotes() function, CF 5
throws an error.

EXAMPLE:



This throws the following error:


Error Diagnostic Information
Just in time compilation error

Invalid parser construct found on line 27 at position 37. ColdFusion was
looking at the following text:

(

Invalid expression format. The usual cause is an error in the expression
structure.


Is this a known bug?  If I pull out the trim and throw it into a
variable, it works.

EXAMPLE




Is this a known bug? Have any of you encountered this?

Thanks!

-- 
SCOTT VAN VLIET 
SENIOR ANALYST 
SBC SERVICES, INC 
Tel: 858.886.3878 
Fax: 858.653.6763 
Email: [EMAIL PROTECTED]

__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
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: Inserting CFIF into CFINPUT

[Scott Brader]

I don't know if this is the best way, but I've successfully used:







Scott Brader
Prairie Software Development LLC
101 East Sadd Street
PO Box 235
North Prairie, WI 53153-0235

Phone: 262.392.9173
Fax: 262.392.9174

Toll Free: 888.821.3427
Mobile: 262.490.1376 



Amateurs practice until they get it right,
Experts practice until they can't get it wrong.

-Original Message-
From: Angel Stewart [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 13:07
To: CF-Talk
Subject: Inserting CFIF into CFINPUT


Hey all,

I want to make a CFINPUT Radio button checked or unchecked depending on
the value of a variable from the database.
Simple right?

Yup..I thought so too.

So why doesn't it work?


CHECKED = "TRUE"  >

I get this error:

---

Just in time compilation error

Invalid token found on line 52 at position 67. ColdFusion was looking at
the following text:

<
Invalid expression element. The usual cause of this error is a
misspelling in the expression text.
The last successfully parsed CFML construct was a CFINPUT tag occupying
document position (52:21) to (52:28).

---

Any ideas on what I'm doing wrong? I expect it to be some simple syntax
error.

-Gel




__
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: Inserting CFIF into CFINPUT

[Matthew R. Small]

Because you can't nest cf tags.

- Matt Small

-Original Message-
From: Angel Stewart [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, March 21, 2002 2:07 PM
To: CF-Talk
Subject: Inserting CFIF into CFINPUT

Hey all,

I want to make a CFINPUT Radio button checked or unchecked depending on
the value of a variable from the database.
Simple right?

Yup..I thought so too.

So why doesn't it work?


CHECKED = "TRUE"  >

I get this error:

---

Just in time compilation error

Invalid token found on line 52 at position 67. ColdFusion was looking at
the following text:

<
Invalid expression element. The usual cause of this error is a
misspelling in the expression text.
The last successfully parsed CFML construct was a CFINPUT tag occupying
document position (52:21) to (52:28).

---

Any ideas on what I'm doing wrong? I expect it to be some simple syntax
error.

-Gel




__
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

Inserting CFIF into CFINPUT

[Angel Stewart]

Hey all,

I want to make a CFINPUT Radio button checked or unchecked depending on
the value of a variable from the database.
Simple right?

Yup..I thought so too.

So why doesn't it work?


CHECKED = "TRUE"  >

I get this error:

---

Just in time compilation error

Invalid token found on line 52 at position 67. ColdFusion was looking at
the following text:

<
Invalid expression element. The usual cause of this error is a
misspelling in the expression text.
The last successfully parsed CFML construct was a CFINPUT tag occupying
document position (52:21) to (52:28).

---

Any ideas on what I'm doing wrong? I expect it to be some simple syntax
error.

-Gel



__
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: Recursion issue

[Christopher Olive]

is the exit condition being met correctly in the recursive function?

christopher olive
cto, vp of web development, vp it security
atnet solutions, inc.
410.931.4092
http://www.atnetsolutions.com


-Original Message-
From: Michael Corrigan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 12:28 PM
To: CF-Talk
Subject: Recursion issue


We have an NT4 box with CF5 and I have a recursive function that appears to run fine, 
but about five -ten minutes later, our system resources max out and locks the server.  
I can't find anything about this and was wondering if anyone has had a similar problem?

Thanks,

Michael Corrigan
Programmer
Endora Digital Solutions
1900 Highland Avenue, Suite 200
Lombard, IL 60148
630-627-5055 ext.-136
630/627-5255 Fax


__
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: browser detection UDF

[Greg Alton]

A free UDF browser check library is available at CFDev.
http://www.cfdev.com/products/productdetail.cfm?id=1003

It's simple to use, but please note that we can't provide support for our
free tags and UDFs. You can of course post questions to our forums for
answers from other developers with experience using these.

Greg Alton
CFDev

- Original Message -
From: "Raymond Camden" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, March 21, 2002 12:21 PM
Subject: RE: browser detection UDF


> Actually I'm pretty sure we don't have one for this yet. So... any
> enterprising developers out there want to submit one?
>
> ===
> Raymond Camden, Principal Spectra Compliance Engineer for Macromedia
>
> Email: [EMAIL PROTECTED]
> Yahoo IM : morpheus
>
> "My ally is the Force, and a powerful ally it is." - Yoda
>
> > -Original Message-
> > From: Jason Larson [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, March 21, 2002 12:20 PM
> > To: CF-Talk
> > Subject: RE: browser detection UDF
> >
> >
> > Go to: www.cflib.org all sort of goodies
> >
> > Thanks,
> > Jason
> >
> >
> >
> > -Original Message-
> > From: Clint Tredway [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, March 21, 2002 9:45 AM
> > To: CF-Talk
> > Subject: browser detection UDF
> >
> > Someone posted a UDF that detected the browser..
> >
> > Does someone have this handy? I have misplaced it :0)
> >
> > Thanks,
> > Clint
> >
> >
> 
__
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

EVENT: Last Chance! ColdFusion 5 Secrets this Tuesday 3/26/02 Wash DC

[Michael Smith]

We will be holding our popular ColdFusion 5 in Depth class again
featuring Charlie Arehart.  Don't miss out - class is this Tuesday,
March 26th.

Classes limited to 12 students each so that you can be sure to get
your own questions answered! Sign up today to guarantee a place - the
last session of this class completely sold out!

- Michael Smith, TeraTech, Inc http://www.teratech.com/



CF 203 - CF 5 in Depth: Opportunities and Challenges

by CF expert Charlie Arehart
Tuesday, 3/26/02
Full Day course Sign in 9:30am, Class 10am - 5pm - $299
Do you really know what's new in CF 5?
If you can't name more than 10 new features, you're missing out!

For full details and registration see
http://www.teratech.com/training/

In this day-long seminar, veteran CF trainer/user group speaker
Charlie Arehart will show youin his popular presentation stylenot
only what's new but also how to make the most of Release 5.

Sharing practical, real-world experiences and his encyclopedic
knowledge of ColdFusion 5, Charlie will demonstrate that Release
5 offers much more than most will know, even if they've seen
presentations and articles or read the information offered on the
Release 5 Overview page at Macromedia's site.

And it's one thing to "know" the feature exists, but quite another to
see the code to make it work, and learn the gotchas. Youll
save yourself days or perhaps weeks of effort and have real working
code examples (and walk through setup/use of the nifty
new administrative tools).

Finally, even if you've read the manuals cover to cover like he has
(if you knew there were manuals and had access to them), there
are still things that are not well-documented, if at all.

Topics:
* The "usual suspect" list of most - discussed new features
  CFFLUSH, CFGRAPH, CFLOG, UDFs, query of queries, CFDUMP,
  Server Analysis, Verity K2, Crystal Reports 8, ADS, COM,...
* Dozens (yes, dozens!) of still more new features
* Real uses of all the new features
* Details and challenges of using all of the new features
* The gotchas (installation issues, bugs, doc, mistakes and more)
* Previous release problems now fixed
* Features available only in Enterprise, or on some platforms
* Topics not covered well in the documentation and release notes
* Dozens of available CF 5 resources

Sure, there are the usual suspects:
 - Query of Queries, User Defined Functions, CFGRAPH, CFFLUSH, Verity
K2, and more
 - System Monitoring/Reporting/Logging/Archival features;
Performance/memory enhancements

But are you aware of the following other new features, to name just a
few:
 - you can now query a datasource without needing a datasource (dsn)
defined in the admin
 - how dsn-less connections have maintain connections on by default, &
how to change that
 - CFSAVECONTENT, CFOBJECTCACHE, the incredibly useful CFDUMP
 - how CFSAVECONTENT can be used to cache slow, nearly static portions
of a page
 - the new dynamic java class loader for working with java objects
 - you can validate input with regular expressions within CFFORM
 - the new updated TagInfusion pack for Studio 4.5.2, holding the tag
definitions/help for R5
 - you can now add your own templates/applications to the
administrator interface
 - how to use the new Merant Wire protocol drivers, and where to find
addl docs within CF
 - GetHTTPRequestData() for SOAP processing, GetException() for Java
processing
 - CFGRID is enhanced, including drop-down lists, checkboxes, columns
that sort on dbl-click
 - enhanced resource view for advanced security, and the new buttons
to flush its cache
 - a change in licensing allowing use of a single license on multiple
OSs (on a single machine)
 - there are pre-built examples of CFGRAPH, UDF, Query of queries,
CFGRID

And even among the usual suspects, did you know about the following
features, to name several:
 - the 9 tags that create result sets useful for query of queries,
CFGraph, and more
 - when a query of queries makes sense, and when it doesnt
 - when user defined functions (UDFs) make sense, and when they dont
 - public UDF libraries, like CFLib.org with dozens of open source
string/math/data/security UDFs
 - you can setup CFGraphs to support drill-down by clicking on a bar
or pie wedge
 - you can also graph non-query data, passing one more values with
CFGRAPHDATA
 - the 6 tags that you cant use on a page that does CFFLUSH, such as
CFLOCATION/CFCOOKIE
 - Verity K2 Server supports site spidering, searching remote servers,
and more
 - every change to the administrator is now tracked and can be
reported/monitored
 - how to setup both default and custom  server probes in the Monitor
feature
 - the purpose of the tools in cfusion\cfam\btauxdir
 - you can setup probe to monitor a remote server (such as a hosted
server) to track any failures
 - how to setup an email notification process for one, rather than
simply all, probes
 - you can use the archive/deploy feature to serve up packaged
applications 

Re: MS Access - Updating a date value broke

[Bryan Stevenson]

change #dateformat(now(),"MM/DD/")#

to #CreateODBCDate(Now())# for just date with 12:00AM for time

OR to #CreateODBCDateTime(Now())#  to get current date and time

HTH

Bryan Stevenson
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
p. 250.920.8830
e. [EMAIL PROTECTED]
-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder & Director
www.cfug-vancouverisland.com

- Original Message -
From: "Brian Fox" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, March 21, 2002 10:32 AM
Subject: MS Access - Updating a date value broke


> Hi -
>
> Here's a query that is run against a Microsoft Access database.  It has been
> working fine for a few years now, but has suddenly broke.  Starting this
> month, Access is recording the DATE_SUBMITTED as a time value, usually
> around 12:00 AM, instead of a date.  The last recorded correct date is
> 1/8/2002.
>
> Anyone know what would cause this?
>
> 
> update courses
> set WEB_STATUS=2,DATE_SUBMITTED=#dateformat(now(),"MM/DD/")#
> Where CRN='#attributes.crn#' and
>  (INSTRUCTOR_ID_1='#User#' or INSTRUCTOR_ID_2='#User#' or
> INSTRUCTOR_ID_3='#User#')
> 
>
> Thanks,
> Brian
> 
__
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

MS Access - Updating a date value broke

[Brian Fox]

Hi -

Here's a query that is run against a Microsoft Access database.  It has been
working fine for a few years now, but has suddenly broke.  Starting this
month, Access is recording the DATE_SUBMITTED as a time value, usually
around 12:00 AM, instead of a date.  The last recorded correct date is
1/8/2002.  

Anyone know what would cause this?


update courses 
set WEB_STATUS=2,DATE_SUBMITTED=#dateformat(now(),"MM/DD/")# 
Where CRN='#attributes.crn#' and 
 (INSTRUCTOR_ID_1='#User#' or INSTRUCTOR_ID_2='#User#' or
INSTRUCTOR_ID_3='#User#')


Thanks,
Brian
__
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: Client variable security (Re: The trouble with cookies ...)

[Todd]

> You can simply write them once, by setting the
> SETCLIENTCOOKIE attribute of CFAPPLICATION to "false" or "no", and then
> creating your own CFID and CFTOKEN "session" cookies with the appropriate
> CFID and CFTOKEN values from the Client or Session scope.
>
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> voice: (202) 797-5496
> fax: (202) 797-5444

OK .. I've disabled setclientcookies, but I don't quite understand the
second 1/2 of the sentance.  Would you mind explaining a little more?

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

PreserveSingleQuotes() - CF 5 Bug?

[VAN VLIET, SCOTT E (SBCSI)]

When nesting functions in the PreserveSingleQuotes() function, CF 5 throws
an error.

EXAMPLE:



This throws the following error:


Error Diagnostic Information
Just in time compilation error

Invalid parser construct found on line 27 at position 37. ColdFusion was
looking at the following text:

(

Invalid expression format. The usual cause is an error in the expression
structure.


Is this a known bug?  If I pull out the trim and throw it into a variable,
it works.

EXAMPLE




Is this a known bug? Have any of you encountered this?

Thanks!

-- 
SCOTT VAN VLIET 
SENIOR ANALYST 
SBC SERVICES, INC 
Tel: 858.886.3878 
Fax: 858.653.6763 
Email: [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

CFSCRIPT & Preservesinglequotes()

[Sean Daniels]

I have written a seemingly simple UDF for cleaning up data before an insert
or update statement (it trims the string, inserts null when necessary, wraps
string in single quotes if it's a char field):



function checknull(ii,isint) {
if (isint) {
return iif(len(trim(ii)),de(trim(ii)),de("null")); }
else {
return 
iif(len(trim(ii)),de(chr(39)&trim(ii)&chr(39)),de("null")); }
}


Basically, my insert statement looks like:

Insert into tablename (intfield,charfield)
Values (#checknull(intfield,1)#,#checknull(charfield,0)#)

It works great except for when the charfield contains apostrophes. It
escapes them all and the result is that twice as many apostrophes get
inserted. I know that somewhere in here I should probably be using
preservesinglequotes() but everywhere I attempt to use it in the UDF I get a
JIT compilation error. I also get a JIT if I put the preservesinglequotes
function in the calling template
[preservesinglequotes(checknull(charfield,0))]

Any suggestions? Please? Unfortunately I used this function all through an
app before finding the bug, so I would be psyched to make repairs to the
function itself not all the code that uses it.

- Sean

~~
Sean Daniels
  Director, Engineering
  Marketplace Technologies, Inc
(T): 207.363.7374
(C): 207.332.6340
(F): 240.269.6319
~~
  http://www.dealforce.com
  http://www.mergernetwork.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: Cluster Cats strange behaviour and endless reboots! DHCP

[Dave Watts]

> This system is now locked in an endless reboot loop, 
> Cluster Cats (which of course cannot operate with DHCP) 
> keeps re booting the box before we can get to network 
> properties to reset the DHCP back to a fixed IP. Anyone 
> got ant thoughts on this?

You can boot the box with ERD Commander, a third-party product, and turn off
the ClusterCATS service:
http://www.winternals.com/products/repairandrecovery/erdcommander2002.asp

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

__
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: Looping through a CSV File

[Carlisle, Eric]

Read the contents of the file into a variable.  Then use something like
this.









INSERT INTO myTable (column1, column2, column3)
VALUES
('#listGetAt(cvsfile,1)#','#listGetAt(cvsfile,2)#','#listGetAt(cvsfile,3)#')





You will probably want to add more code for error protection/correction.
That's how I would do it, though. :)

Good luck!

EC


-Original Message-
From: Jason Larson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 11:14 AM
To: CF-Talk
Subject: Looping through a CSV File


I have a CSV File that I am pushing up using cffile. I want to loop
through the csv file and insert the content into a database, and I am
not sure how to do this. Any help our guidance would help?

Thanks
Jason



__
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