date:20020409


Shahzad,

You probably need to URL encode the variable questions, but I just notice
that you're passing Questions as BodyText on your CFLocation and trying to
display BodyContent.

Where are attributes.question1 to attributes.questionX coming from?  Are
they form fields?
If they are, why not just go straight to your Fuseaction
SubmitQuestionsForSubcategory and generate this content in there rather than
adding this additional step and trusting your app to the stability of
cflocation?

Hope this helps

Regards

Stephen

- Original Message -
From: Shahzad.Butt [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, April 09, 2002 10:27 AM
Subject: CFSaveContent Variable


 Hi all

 Is there any way to pass variable used in CFSavecontent (Not using FORM)
 but using CFLocation. Following is code how can I make it working?


  CFSavecontent variable=Questions
  cfoutput
   User Name: #CGI.AUTH_USER#br
   Browser and Windows: #CGI.HTTP_USER_AGENT#br
   Remote Address: #CGI.REMOTE_ADDR#
  /cfoutputbr
  CFLoop From=1 To=#Attributes.NumberOfQuestionsAsked#
 Index=Counter
   cfoutput#Evaluate(Attributes.Question#Counter#)#:
   #Evaluate(Attributes.Question#Counter#)#br/cfoutput
  /cfloop
  /CFSavecontent

 CFLocation
 URL=#self#?Fuseaction=#Attributes.XFA.SubmitQuestionsForSubcategory#
 UserID=#Attributes.UserID#ContactType=#Attributes.ContactType#Contact
 Phone=#Attributes.ContactPhone#
 ContactEmail=#ContactEmail#CaseDescription=#Attributes.CaseDescription
 #SubCategoryID=#Attributes.SubCategoryID#BodyText=#Questions#

 It gives blank page if i display #Attributes.BodyContent# in next
 page..


__
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: CFSaveContent Variable

2002-04-09 Thread Shahzad.Butt


Right- attributes.question1... Are coming from form fields. 

I understand its better to go straight there, but problem is I have to
have separate fuse doing this action. Its because
Currently we are just assigning CGI variables and stuff, but we 've to
do lot more actions in this specific FUSE. E.g sending emails and stuff.
So I was wondering is there any way to do so using CFLocationIf not
then probably I'll go other way.


-Original Message-
From: Stephen Moretti [mailto:[EMAIL PROTECTED]] 
Sent: 09 April 2002 10:57
To: CF-Talk
Subject: Re: CFSaveContent Variable


Shahzad,

You probably need to URL encode the variable questions, but I just
notice that you're passing Questions as BodyText on your CFLocation
and trying to display BodyContent.

Where are attributes.question1 to attributes.questionX coming from?  Are
they form fields? If they are, why not just go straight to your
Fuseaction SubmitQuestionsForSubcategory and generate this content in
there rather than adding this additional step and trusting your app to
the stability of cflocation?

Hope this helps

Regards

Stephen

- Original Message -
From: Shahzad.Butt [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, April 09, 2002 10:27 AM
Subject: CFSaveContent Variable


 Hi all

 Is there any way to pass variable used in CFSavecontent (Not using 
 FORM) but using CFLocation. Following is code how can I make it 
 working?


  CFSavecontent variable=Questions
  cfoutput
   User Name: #CGI.AUTH_USER#br
   Browser and Windows: #CGI.HTTP_USER_AGENT#br
   Remote Address: #CGI.REMOTE_ADDR#
  /cfoutputbr
  CFLoop From=1 To=#Attributes.NumberOfQuestionsAsked#
 Index=Counter
   cfoutput#Evaluate(Attributes.Question#Counter#)#:
   #Evaluate(Attributes.Question#Counter#)#br/cfoutput
  /cfloop
  /CFSavecontent

 CFLocation 
 URL=#self#?Fuseaction=#Attributes.XFA.SubmitQuestionsForSubcategory#
 UserID=#Attributes.UserID#ContactType=#Attributes.ContactType#Conta
 ct
 Phone=#Attributes.ContactPhone#

ContactEmail=#ContactEmail#CaseDescription=#Attributes.CaseDescription
 #SubCategoryID=#Attributes.SubCategoryID#BodyText=#Questions#

 It gives blank page if i display #Attributes.BodyContent# in next 
 page..



__
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

CFGRAPH

2002-04-09 Thread Jerry Staple


Hi 
Does anyone know how to add multiple lines as the valuecolumn on a
line type graph??
 
TIA
 

Jerry Staple 
Web Application Developer 
Certified Coldfusion (5.0) Developer 


Head Office 
133-137 Lisburn Road, Belfast 
Northern Ireland BT9 7AG 
T +44 (0) 28 9022 3224 
F +44 (0) 28 9022 3223 
E [EMAIL PROTECTED] 
W www.biznet-solutions.com 



**

If you are not the intended recipient, or person responsible for
delivering it to the intended recipient, you are not authorized to and
must not disclose, copy, distribute or retain this message or any part
of it.

The opinions / views / comments on this e-mail do not necessarily
reflect any views or policies of biznet

The recipient should check this email and any attachments for the
presence of viruses. biznet accepts no liability for any damage caused
by any virus transmitted by this email. biznet 2001.


**

 


 

 

 


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

Re: StructClear(session)

2002-04-09 Thread Bud


On 4/8/02, sebastian palmigiani penned:
After I do a

StructClear(Session)

the Session.URLToken that I have added to links also get cleared out and I
get a message that Session.URLToken can't be found. How do I prevent it from
doing it that?

If you only have a couple session variables you could just delete them.

cfscript
structdelete(session, 'variable1');
structdelete(session, 'variable2');
/cfscript

Otherwise, just make a local variables before you clear the session 
then reset the Session.URLToken.

cfscript
variables.URLToken = session.URLToken;
structclear(session);
session.URLToken = variables.URLToken;
/cfscript

Don't forget to lock either. :)
-- 

Bud Schneehagen - Tropical Web Creations

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.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: Opinions/Experience with Webex?

2002-04-09 Thread Bill Grover


We use Webex and are very happy with it and we use it for demo's and
training.

Our company specializes in printing, personalization and mailing.  As such
to assist our customers we maintain an inventory of their finished goods in
our plant.  We have developed a set of web pages that allow our clients to
view what we have in inventory and request that we pull items from inventory
and ship them to any give address.

One of the primary places we use Webex is to setup a training with our
clients on this feature.  We will create a Webex meeting, bring the customer
online and go through the system showing them how to use the system and
answering any questions they have.  Our clients have loved it because it
allows us to provide solutions to them faster than if we had to travel to
their site.

Hope this helps.
__ 

Bill Grover 
Supervisor MIS  Phone:  301.424.3300 x3324  
EU Services, Inc.   FAX:301.424.3696
649 North Horners Lane  E-Mail: [EMAIL PROTECTED]
Rockville, MD 20850-1299WWW:http://www.euservices.com
__ 



 -Original Message-
 From: Ken Wilson [mailto:[EMAIL PROTECTED]]
 Sent: Monday, April 08, 2002 2:21 PM
 To: CF-Talk
 Subject: Opinions/Experience with Webex?
 
 
 Anyone here have any experience with Webex 
 http://www.webex.com that you
 could share? Or alternatives in the online meeting realm? 
 Webex appears to
 suit our needs but would appreciate any feedback pro or con 
 that anyone
 could share. Primary use will be for remotely training 
 personnel on several
 CF-based web applications.
 
 Thanks,
 
 Ken
 
 
 
__
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: garbled PDF titles in Verity results (2nd try)

2002-04-09 Thread Gyrus


 My guess is it isn't a CF issue - it's more likely and issue with the
way
 Solaris interprets the metadata attached to each PDF.

 Does it show the body text OK in the summary?

Yeah, it does. Didn't know the OS could be at fault. I've searched the
Adobe site to no avail, though - kind of a pain cos their support docs
are geared to their products, so if you're just having a general PDF
problem, there doesn't seem to be much coverage.

I'll get my client's sysadmin to look into it, but in the end I think
I'm just going to run a query to the DB for each file being displayed in
search results. I may have to do this anyway to get the file date, so I
may as well get the title while I'm at it and not rely on the title
provided by cfindex.

Thanks anyway,

- Gyrus


- [EMAIL PROTECTED]
work: http://www.tengai.co.uk
play: http://www.norlonto.net
- PGP key available


__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.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: CFSaveContent Variable


Shahzad,

 Right- attributes.question1... Are coming from form fields.

 I understand its better to go straight there, but problem is I have to
 have separate fuse doing this action. Its because
 Currently we are just assigning CGI variables and stuff, but we 've to
 do lot more actions in this specific FUSE. E.g sending emails and stuff.
 So I was wondering is there any way to do so using CFLocationIf not
 then probably I'll go other way.


I think you're probably better just working this through the one fuseaction
and just adding new action fuses when you need to. i.e. an email fuse etc.

Better to just have one request to the server than multiple requests and
less passing of information around on URLs.

Regards

Stephen


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

2002-04-09 Thread Bruce Sorge


You have run into one of the limitations of CFGRAPH. The line chart is really used for 
trending averages over a period of time. In fact, if you look over the docs, and in 
Forta's book, and in the on-line tutorials, you will see that line charts get a brief 
mention that it exists, and that is pretty much it. If you want to be able to create 
some really cool graphs that offer many options, you would need to invest in a third 
party application. If you are looking for something that you can buy and pretty much 
hit the ground running with a low learning curve, and that works with ASP and CFM, I 
would give Corda Technologies PopCharts a look. We bought ut here at my company and it 
is working out great. Their URL is http://Corda.com

Bruce Sorge
Senior Software Developer
Baylor Health Care e-Strategies
Dallas, TX 75201

-- Original Message --
From: Jerry Staple [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Date:  Tue, 9 Apr 2002 11:21:40 +0100

Hi 
Does anyone know how to add multiple lines as the valuecolumn on a
line type graph??
 
TIA
 

Jerry Staple 
Web Application Developer 
Certified Coldfusion (5.0) Developer 


Head Office 
133-137 Lisburn Road, Belfast 
Northern Ireland BT9 7AG 
T +44 (0) 28 9022 3224 
F +44 (0) 28 9022 3223 
E [EMAIL PROTECTED] 
W www.biznet-solutions.com 



**

If you are not the intended recipient, or person responsible for
delivering it to the intended recipient, you are not authorized to and
must not disclose, copy, distribute or retain this message or any part
of it.

The opinions / views / comments on this e-mail do not necessarily
reflect any views or policies of biznet

The recipient should check this email and any attachments for the
presence of viruses. biznet accepts no liability for any damage caused
by any virus transmitted by this email. biznet 2001.


**

 


 

 

 



__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.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: [IPCop-user] 2Qs: FTPing from GREEN to ORANGE and GREEN to RE D

2002-04-09 Thread Aidan Whitehall


Thanks for the reply.

 I had a similar problem in a different environment. It turned out
 port 20 and 21 needed to be open to allow anything more then
 a login.

Well, I don't mind opening up 20 and 21 (and if possible restricting that to
the GREEN network), but the firewall was blocking the return traffic on port
20 (when the FTP client issued an 'ls' command, it then appeared to hang). I
thought switching to PASV was the workaround.

Is there a way to open up outbound traffic from the server on port 20? I can
see how to open up pinholes based on the *destination* port, but not the
port on which the traffic originates (which we know is 20 for data). Plus we
don't know what the destination port is going to be, so I guess there must
be a way of specifying *any*.

BTW, please correct me if anything above sounds daft - this is all new stuff
to me.


Regards

-- 
Aidan Whitehall [EMAIL PROTECTED]
Macromedia ColdFusion Developer
Fairbanks Environmental +44 (0)1695 51775


__
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: IIS Log Tool

2002-04-09 Thread Len Conrad


Anyone using a good tool for parsing IIS logs and producing html output with
graphs? If so can you point me in the right direction.

webalizer, analog, and there is an add-on for analog to produce better graphs.

Len



http://MenAndMice.com/DNS-training
http://BIND8NT.MEIway.com : ISC BIND for NT4  W2K
http://IMGate.MEIway.com  : Build free, hi-perf, anti-abuse mail gateways

__
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: garbled PDF titles in Verity results (2nd try)

2002-04-09 Thread Janine Jakim


Check the type of fonts used.  Make sure the configurations are correct (ie:
we had a problem when Adobe reader version didn't match the plug-in set for
internet explorer)
Also Adobe site stinks for help. Try http://www.pdfzone.com/ or
http://www.planetpdf.com/
They have some forums- I found alot of useful info by searching the archives
on pdfzone.


-Original Message-
From: Gyrus [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 7:26 AM
To: CF-Talk
Subject: Re: garbled PDF titles in Verity results (2nd try)


 My guess is it isn't a CF issue - it's more likely and issue with the
way
 Solaris interprets the metadata attached to each PDF.

 Does it show the body text OK in the summary?

Yeah, it does. Didn't know the OS could be at fault. I've searched the
Adobe site to no avail, though - kind of a pain cos their support docs
are geared to their products, so if you're just having a general PDF
problem, there doesn't seem to be much coverage.

I'll get my client's sysadmin to look into it, but in the end I think
I'm just going to run a query to the DB for each file being displayed in
search results. I may have to do this anyway to get the file date, so I
may as well get the title while I'm at it and not rely on the title
provided by cfindex.

Thanks anyway,

- Gyrus


- [EMAIL PROTECTED]
work: http://www.tengai.co.uk
play: http://www.norlonto.net
- PGP key available



__
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

Better way? Loop, Sql help

2002-04-09 Thread Paul Ihrig


ok i am trying to get this down  am running into problems
Any Help would be greatly appreciated.

First in rsStudioIN.StudioID i am trying to generate a list of id's that
where created this month
it seems to being working, but when i call rsStudioIN.StudioID in my next
Query, it only takes the first ID, Not A list...
 
but if i 
cfloop query=rsStudioIN
cfoutput#StudioID#/cfoutput
/cfloop
then it shows all the correct ids..?

So in the second Query i only want to display items where the
rsStudio.StudioID are not in the list from rsStudioIN.StudioID

On top of all that, if there is a better way to write this using inner or
left/right joins in one statement that would be cool to see how it works.

Thanks Again Guys.
-paul

CFSET todayDate = #DateFormat(Now())#

cfquery name=rsStudioIN datasource=kid dbtype=ODBC
SELECT tblKid.StudioID, tblKid.KidDate
FROM tblKid
WHERE Month(tblKid.KidDate) IN (#Month(todayDate)#)/cfquery 

cfquery name=rsStudio datasource=kid
SELECT tblStudio.StudioID, tblStudio.StuShort, tblStudio.StudioName
FROM tblStudio
cfif rsStudioIN.StudioID NEQ 
WHERE tblStudio.StudioID NOT IN (#rsStudioIN.StudioID#)
/cfif
ORDER BY tblStudio.StudioName ASC
/cfquery

__
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: garbled PDF titles in Verity results (2nd try)

2002-04-09 Thread Dave Carabetta


  My guess is it isn't a CF issue - it's more likely and issue with the
way
  Solaris interprets the metadata attached to each PDF.
 
  Does it show the body text OK in the summary?

Yeah, it does. Didn't know the OS could be at fault. I've searched the
Adobe site to no avail, though - kind of a pain cos their support docs
are geared to their products, so if you're just having a general PDF
problem, there doesn't seem to be much coverage.

I'll get my client's sysadmin to look into it, but in the end I think
I'm just going to run a query to the DB for each file being displayed in
search results. I may have to do this anyway to get the file date, so I
may as well get the title while I'm at it and not rely on the title
provided by cfindex.


When you open a PDF and go to File-Document Info-General..., do you see 
the garbled text there? Verity indexes those fields too (I think). I could 
be wrong on that, but I did a project some years back like this and had the 
same issue. I seem to remember that when I filled in the relevant info in 
those metadata fields, Verity indexed things OK. At the same time though, I 
think I was using CF 3.1, and things have certainly changed since then! Just 
a thought though.

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: Pausing using CF


cfscript
/**
 * Pauses the processing for CF for a specified amount of time
 * 
 * @param seconds  number of seconds you would like to pause CF for
 * @author Tony Petruzzi ([EMAIL PROTECTED]
 * @version 1, April, 09 2002
 */
function PauseCF(seconds){
var currenttime = now();
while(DateDiff(s, currenttime, now()) LTE seconds){
continue;
}
}
/cfscript


Here is a function a wrote to do this. All you have to do to use it is
assign the function to a variable.

cfset temp = PauseCF(10)

Have fun!

Anthony Petruzzi
Webmaster
954-321-4703
http://www.sheriff.org


-Original Message-
From: Michael Tangorre [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 08, 2002 7:53 PM
To: CF-Talk
Subject: Pausing using CF


Hello.

Can anyone think of a way that I can achieve a pause for like 30 seconds to
a minute between iterations in a loop?

would another loop inside work that did nothing or is there a better way?

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: Better way? Loop, Sql help

2002-04-09 Thread Dave Carabetta


ok i am trying to get this down  am running into problems
Any Help would be greatly appreciated.

First in rsStudioIN.StudioID i am trying to generate a list of id's that
where created this month
it seems to being working, but when i call rsStudioIN.StudioID in my next
Query, it only takes the first ID, Not A list...

but if i
cfloop query=rsStudioIN
cfoutput#StudioID#/cfoutput
/cfloop
then it shows all the correct ids..?

So in the second Query i only want to display items where the
rsStudio.StudioID are not in the list from rsStudioIN.StudioID

On top of all that, if there is a better way to write this using inner or
left/right joins in one statement that would be cool to see how it works.

Thanks Again Guys.
-paul

CFSET todayDate = #DateFormat(Now())#

cfquery name=rsStudioIN datasource=kid dbtype=ODBC
SELECT tblKid.StudioID, tblKid.KidDate
FROM tblKid
WHERE Month(tblKid.KidDate) IN (#Month(todayDate)#)/cfquery

cfquery name=rsStudio datasource=kid
SELECT tblStudio.StudioID, tblStudio.StuShort, tblStudio.StudioName
FROM tblStudio
cfif rsStudioIN.StudioID NEQ 
WHERE tblStudio.StudioID NOT IN (#rsStudioIN.StudioID#)
/cfif
ORDER BY tblStudio.StudioName ASC
/cfquery

A couple things. First, always scope your variables. It increases 
readability and is more efficient. Second, you don't need pound signs around 
CF variables within a CFSET. Third, you're having your problem because you 
are only referring to the first record in the record set of your first 
query. You need to use ValueList() to get a list of the values returned from 
the first query. Here's a solution:

cfset variables.todayDate = DateFormat(Now())

cfquery name=rsStudioIN datasource=kid dbtype=ODBC
SELECT tblKid.StudioID, tblKid.KidDate
FROM tblKid
WHERE Month(tblKid.KidDate) IN '#Month(todayDate)#'
/cfquery

cfset variables.studioINList = ValueList(rsStudioIN.StudioID)

cfquery name=rsStudio datasource=kid
SELECT tblStudio.StudioID, tblStudio.StuShort, tblStudio.StudioName
FROM tblStudio
cfif ListLen(variables.studioINList)
  WHERE tblStudio.StudioID NOT IN (#variables.studioINList#)
/cfif
ORDER BY tblStudio.StudioName ASC
/cfquery

Hope this helps,
Dave.

_
Send and receive Hotmail on your mobile device: http://mobile.msn.com

__
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: Stop/restarting CF from a web page - in Unix (well Linux at l east)


sorry, i'm not a unix guru. so off to google groups i go

Searched for linux stop service

quoted from the newgroups:


If you're on RH, you can use:

service service_name stop
service service_name start
service service_name restart

Where service_name is replaced with the service you want to address,
e.g. xinetd, xntpd, afs, autofs, etc.

and stop, start, restart are what you want the service to do. 
Stop kills it, start starts it, restart does a stop then start.

Good luck.

Cheers,
Dave

-- 
Dave BarnettSystem Software Engineerx1434



So with that said. I gues what you could do is write a script like this
(assume we are saving it to the /usr directory)


Create file called CFRestart

service Put name of CF service here restart


Give it Execute Permission
==
chmod +x /usr/CFRestart


Call From CF Page
=
cfexecute name=/usr/CFRestart/cfexecute


Try it out and let us know what happens. ;)


Anthony Petruzzi
Webmaster
954-321-4703
http://www.sheriff.org


-Original Message-
From: Mak Wing Lok [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 1:53 AM
To: CF-Talk
Subject: RE: Stop/restarting CF from a web page


any idea how it can be done for Unix?



-Original Message-
From: Douglas Brown [mailto:[EMAIL PROTECTED]]
Sent: 09 April 2002 01:19
To: CF-Talk
Subject: Re: Stop/restarting CF from a web page


Here is a custom CFX tag for this, but i believe it is for NT

http://devex.macromedia.com/developer/gallery/info.cfm?ID=A155CF05-7445-11D4
-AAA
400508B94F380method=Full







Success is a journey, not a destination!!



Doug Brown
- Original Message -
From: phumes1 [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, April 08, 2002 10:08 AM
Subject: Re: Stop/restarting CF from a web page


 Hi,

 How can I stop and start the CF server from within a webpage?




+---

+

 Philip Humeniuk
 [EMAIL PROTECTED]
 [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

Multiple Checkbox update?


Does anyone happen to know where I can find a good example of a multiple
checkbox update?  I need one today and I've never done it before.   Any,
input would be appreciated.  Thanks!
__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.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 Checkbox update?

2002-04-09 Thread Paul Giesenhagen


There are many ways to skin this cat, but it all depends on your checkboxes
and what your trying to accomplish.  If you could provide more details, I am
sure you will get some good help!

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



 Does anyone happen to know where I can find a good example of a multiple
 checkbox update?  I need one today and I've never done it before.   Any,
 input would be appreciated.  Thanks!
 
__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.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: Better way? Loop, Sql help

2002-04-09 Thread Paul Ihrig


Dave Thank You!
I do appreciate the help

one thing i had to change was adding () around the IN date
cfquery name=rsStudioIN datasource=kid dbtype=ODBC
SELECT tblKid.StudioID, tblKid.KidDate
FROM tblKid
WHERE Month(tblKid.KidDate) IN ('#Month(todayDate)#')
/cfquery

Thanks Again
-paul



-Original Message-
From: Dave Carabetta [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 9:11 AM
To: CF-Talk
Subject: Re: Better way? Loop, Sql help


ok i am trying to get this down  am running into problems
Any Help would be greatly appreciated.

First in rsStudioIN.StudioID i am trying to generate a list of id's that
where created this month
it seems to being working, but when i call rsStudioIN.StudioID in my next
Query, it only takes the first ID, Not A list...

but if i
cfloop query=rsStudioIN
cfoutput#StudioID#/cfoutput
/cfloop
then it shows all the correct ids..?

So in the second Query i only want to display items where the
rsStudio.StudioID are not in the list from rsStudioIN.StudioID

On top of all that, if there is a better way to write this using inner or
left/right joins in one statement that would be cool to see how it works.

Thanks Again Guys.
-paul

CFSET todayDate = #DateFormat(Now())#

cfquery name=rsStudioIN datasource=kid dbtype=ODBC
SELECT tblKid.StudioID, tblKid.KidDate
FROM tblKid
WHERE Month(tblKid.KidDate) IN (#Month(todayDate)#)/cfquery

cfquery name=rsStudio datasource=kid
SELECT tblStudio.StudioID, tblStudio.StuShort, tblStudio.StudioName
FROM tblStudio
cfif rsStudioIN.StudioID NEQ 
WHERE tblStudio.StudioID NOT IN (#rsStudioIN.StudioID#)
/cfif
ORDER BY tblStudio.StudioName ASC
/cfquery

A couple things. First, always scope your variables. It increases 
readability and is more efficient. Second, you don't need pound signs around

CF variables within a CFSET. Third, you're having your problem because you 
are only referring to the first record in the record set of your first 
query. You need to use ValueList() to get a list of the values returned from

the first query. Here's a solution:

cfset variables.todayDate = DateFormat(Now())

cfquery name=rsStudioIN datasource=kid dbtype=ODBC
SELECT tblKid.StudioID, tblKid.KidDate
FROM tblKid
WHERE Month(tblKid.KidDate) IN '#Month(todayDate)#'
/cfquery

cfset variables.studioINList = ValueList(rsStudioIN.StudioID)

cfquery name=rsStudio datasource=kid
SELECT tblStudio.StudioID, tblStudio.StuShort, tblStudio.StudioName
FROM tblStudio
cfif ListLen(variables.studioINList)
  WHERE tblStudio.StudioID NOT IN (#variables.studioINList#)
/cfif
ORDER BY tblStudio.StudioName ASC
/cfquery

Hope this helps,
Dave.

_
Send and receive Hotmail on your mobile device: http://mobile.msn.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: Date Problems Again :: Yet Another one

2002-04-09 Thread Paul Ihrig


Thanks Matthew
DISTINCT was a good idea.

-paul



-Original Message-
From: Matthew Walker [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 08, 2002 5:54 PM
To: CF-Talk
Subject: RE: Date Problems Again :: Yet Another one


Something like 

SELECT DISTINCT Year([KidDate]) AS TheYear, Month([KidDate]) AS TheMonth
FROM tblKid
ORDER BY Year([KidDate]), Month([KidDate]);

Then you don't need the CF group at all. You will need MonthAsString().

Regards,
Matthew Walker
/*
Cabbage Tree Creative Ltd
Christchurch - New Zealand

http://www.matthewwalker.net.nz/
http://www.cabbagetree.co.nz/
*/


-Original Message-
From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 9 April 2002 9:02 a.m.
To: CF-Talk
Subject: Date Problems Again :: Yet Another one


Yet Another Problem
i am trying to group by Month/Year
i just cant seem to get it.

i have read ever thing i can find in WACK
on group, GROUP BY,  CreateODBCDate
to no avail.

I have tried cfoutput query=rsViewDate
group=#LSDateFormat(rsViewDate.KidDate,' ')# but that does
nothing good.


in this query.
i want it to show my dates entered
but on duplicates of the date.

so all the entrees for this month would just be in the select as April
2002

Thank You!


cfquery name=rsViewDate datasource=kid
SELECT KidDate
FROM tblKid
GROUP BY KidDate
ORDER BY KidDate ASC 
/cfquery

select name=KidDate class=input
option value=Select Date/option
cfoutput query=rsViewDate group=KidDate 
option
value=#rsViewDate.KidDate##LSDateFormat(rsViewDate.KidDate,'
')#/option
/cfoutput /select

-paul


__
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: Better way? Loop, Sql help


Afternoon Paul,

What you need to do is create a value list from the StudioID column and use
that in your next query, like this

cfset StudioIDlist = ValueList(reStudioIN.StudioID)

cfquery name=rsStudio datasource=kid
SELECT tblStudio.StudioID, tblStudio.StuShort, tblStudio.StudioName
FROM tblStudio
cfif listlen(StudionList)
WHERE tblStudio.StudioID NOT IN (#StudioIDList#)
/cfif
ORDER BY tblStudio.StudioName ASC
/cfquery

Incidentally you can probably do this :

cfquery name=rsStudio datasource=kid
SELECT tblStudio.StudioID, tblStudio.StuShort, tblStudio.StudioName
FROM tblStudio
WHERE tblStudio.StudioID
NOT IN (SELECT StudioID
FROM tblKid
WHERE Month(KidDate) IN (#Month(todayDate)#))
ORDER BY tblStudio.StudioName ASC
/cfquery

I suspect that there is a JOIN of some kind, but its too warm in the office
and my brain isn't working quite right this afternoon... ;o)

Hope that helps

Regards

Stephen
- Original Message -
From: Paul Ihrig [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, April 09, 2002 2:01 PM
Subject: Better way? Loop, Sql help


 ok i am trying to get this down  am running into problems
 Any Help would be greatly appreciated.

 First in rsStudioIN.StudioID i am trying to generate a list of id's that
 where created this month
 it seems to being working, but when i call rsStudioIN.StudioID in my next
 Query, it only takes the first ID, Not A list...

 but if i
 cfloop query=rsStudioIN
 cfoutput#StudioID#/cfoutput
 /cfloop
 then it shows all the correct ids..?

 So in the second Query i only want to display items where the
 rsStudio.StudioID are not in the list from rsStudioIN.StudioID

 On top of all that, if there is a better way to write this using inner or
 left/right joins in one statement that would be cool to see how it works.

 Thanks Again Guys.
 -paul

 CFSET todayDate = #DateFormat(Now())#

 cfquery name=rsStudioIN datasource=kid dbtype=ODBC
 SELECT tblKid.StudioID, tblKid.KidDate
 FROM tblKid
 WHERE Month(tblKid.KidDate) IN (#Month(todayDate)#)/cfquery

 cfquery name=rsStudio datasource=kid
 SELECT tblStudio.StudioID, tblStudio.StuShort, tblStudio.StudioName
 FROM tblStudio
 cfif rsStudioIN.StudioID NEQ 
 WHERE tblStudio.StudioID NOT IN (#rsStudioIN.StudioID#)
 /cfif
 ORDER BY tblStudio.StudioName ASC
 /cfquery

 
__
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 Checkbox update?


All I need to do is have the action page either enter a 1 into a field
in my DB if the checkbox is defined (selected).  

I've got a list of clients and they want the ability to check them off
on a monthly basis inorder to keep track of billing.  So, I have a drop
down that has our different services.  The user selects the ares they
want, then it lists all the clients with a checkbox.  If the checkbox is
checked, they were billed in the previous cycle, if it isn't they will
check it and add it to our accounting system.



-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, April 09, 2002 9:29 AM
To: CF-Talk
Subject: Re: Multiple Checkbox update?


There are many ways to skin this cat, but it all depends on your
checkboxes and what your trying to accomplish.  If you could provide
more details, I am sure you will get some good help!

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



 Does anyone happen to know where I can find a good example of a
multiple
 checkbox update?  I need one today and I've never done it before.
Any,
 input would be appreciated.  Thanks!
 

__
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: I need printable reports in browser from Oracle (must be an alter native to Crystal#!@?#!!?

2002-04-09 Thread Matthew R. Small


I don't think there's any easy answer for this, but if you're using
Windows and Word, you can do what I do and generate the reports in CF
then send to Word via COM.  Email me off list for more info.

- Matt Small

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, April 09, 2002 5:11 AM
To: CF-Talk
Subject: I need printable reports in browser from Oracle (must be an
alter native to Crystal#!@?#!!?

There must be a good reporting tool out there. At the moment we use
Crystal
to produce them and it's active-x viewer app to display and print them.
But
Crystal is a dog, that fs up every server we have installed it on
and
you have to install on the web server to get the viewer to work, despite
the
fact that you're not supposed to need to. Plus it's inflexible and
limited
in terms of the reports it produces. 
Short of writing reports in CF and using something to turn them into
PDF's,
what else is there? There must be something? Please tell me there's any
easy
answer to this.



**

The opinions expressed in this E-mail are those  of  the individual  and
not  necessarily  the  company.  This E-mail and  any files transmitted 
with it are confidential and solely for the use of the intended
recipients


**


__
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: Borland JBuilder6 for CFX

2002-04-09 Thread Matthew R. Small

You have it looking for cfx.jar, right?

- Matt Small

-Original Message-
From: James McCullough [mailto:[EMAIL PROTECTED]] 
Sent: Monday, April 08, 2002 9:08 PM
To: CF-Talk
Subject: OT: Borland JBuilder6 for CFX

Has anyone here used Jbuilder to build CFX tags? I am trying to setup a
project environment to import the com.allaire.cfx.* classes and Jbuilder
says that it cannot find the classes. When I use the command line
compiler with the classpath attributes supplied,  the tag compiles and
works. However I don't want to use CF Studio and would like to take
advantage of the features in JBuilder. Any ideas on how to set it up?
New to JBuilder.

__
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: inetinfo.exe taking 99% of CPU?

2002-04-09 Thread David Grabbe


Nope -- ANY CF script, even without any database processing, loops, etc.

David

David Grabbe
Manager, Information Systems
Church of the Great God
[EMAIL PROTECTED]
http://www.cgg.org



-Original Message-
From: Christopher Olive [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 9:46 AM
To: CF-Talk
Subject: RE: inetinfo.exe taking 99% of CPU?


is it any particular CF script?  if so, perhaps there's an infinite loop or
somesuch.

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


-Original Message-
From: David Grabbe [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 08, 2002 9:53 PM
To: CF-Talk
Subject: SOT: inetinfo.exe taking 99% of CPU?


Hello all,

I've run into a problem with my local development machine (Win2k, IIS, CF
4.5).  For some bizarre reason today whenever I try to run a CF script, the
INETINFO.exe service suddenly pegs out at 99% of the CPU, and the only way I
can get it to release is to reboot.  I have tried uninstalling and
reinstalling IIS, but that didn't help.  Has anyone else run into this
problem with inetinfo before?  Any ideas why this started happening, and how
I can make it stop?  :)

TIA,
David


David Grabbe
Manager, Information Systems
Church of the Great God
[EMAIL PROTECTED]
http://www.cgg.org




__
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 Checkbox update?

I guess my problem is that I have all of these checkboxes and I need to
update the field associated with it in my databse but they all have the
same name. So, I figured I would use the primary key with the name but
now I don't know how to incorporate that in my query?

-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, April 09, 2002 9:48 AM
To: CF-Talk
Subject: Re: Multiple Checkbox update?

If you have lets say 10 different checkboxes and each of those
checkboxes relate to a column in your database, and if it is checked,
you want a 1 and if not, a 0, use cfparam to set the default value of
the checkboxes to 0 and then if a checkbox is actually checked and the
form field has the value of 1, cfparam will be ignored, and the value
will be set to 1, if the checkbox is not checked, the form value will
default to 0.

cfparam name=form.checkboxvalueA default=0
cfparam name=form.checkboxvalueB default=0
cfparam name=form.checkboxvalueC default=0

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

 All I need to do is have the action page either enter a 1 into a field

 in my DB if the checkbox is defined (selected).

 I've got a list of clients and they want the ability to check them off

 on a monthly basis inorder to keep track of billing.  So, I have a 
 drop down that has our different services.  The user selects the ares 
 they want, then it lists all the clients with a checkbox.  If the 
 checkbox is checked, they were billed in the previous cycle, if it 
 isn't they will check it and add it to our accounting system.

 -Original Message-
 From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, April 09, 2002 9:29 AM
 To: CF-Talk
 Subject: Re: Multiple Checkbox update?

 There are many ways to skin this cat, but it all depends on your 
 checkboxes and what your trying to accomplish.  If you could provide 
 more details, I am sure you will get some good help!

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

  Does anyone happen to know where I can find a good example of a
 multiple
  checkbox update?  I need one today and I've never done it before.
 Any,
  input would be appreciated.  Thanks!

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

Re: Multiple Checkbox update?

2002-04-09 Thread Valerie L. Criswell


What about placing the client names into a dropdown and allow multiple
selections?  This would send a comma delimited list of the ClientIDs, then
you could loop through the list in the action page, placing the IDs in your
WHERE clause.  This would save some real estate on the page depending on how
many clients there are.

Otherwise, if you're sure you want to do the checkboxes, do a cfparam
value=Form.ClientIDHere default=0 for each ClientID just before the
UPDATE/INSERT so that each client has a value.  Then you'll either insert a
1 or 0 for each client.

I hope my thinking is on the right track here for you.  (That's my
disclaimer) In any event, enjoy the day!

~Val

- Original Message -
From: Kris Pilles [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, April 09, 2002 9:32 AM
Subject: RE: Multiple Checkbox update?


 All I need to do is have the action page either enter a 1 into a field
 in my DB if the checkbox is defined (selected).

 I've got a list of clients and they want the ability to check them off
 on a monthly basis inorder to keep track of billing.  So, I have a drop
 down that has our different services.  The user selects the ares they
 want, then it lists all the clients with a checkbox.  If the checkbox is
 checked, they were billed in the previous cycle, if it isn't they will
 check it and add it to our accounting system.



 -Original Message-
 From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, April 09, 2002 9:29 AM
 To: CF-Talk
 Subject: Re: Multiple Checkbox update?


 There are many ways to skin this cat, but it all depends on your
 checkboxes and what your trying to accomplish.  If you could provide
 more details, I am sure you will get some good help!

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



  Does anyone happen to know where I can find a good example of a
 multiple
  checkbox update?  I need one today and I've never done it before.
 Any,
  input would be appreciated.  Thanks!
 

 
__
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 Checkbox update?


form ...
input type=checkbox name=customerOne
input type=checkbox name=customerTwo
input type=checkbox name=customerThree
/form

Then when your doing your insert query

cfquery name=insert datasource=#request.dsn# ...
INSERT INTO tblSubscribe

(customerOne,customerTwo,customerThree)
(
cfif IsDefined(form.customerOne)cfset
customerOne=1#customerOne#,cfelse0,/cfif
cfif IsDefined(form.customerTwo)cfset
customerTwo=1#customerTwo#,cfelse0,/cfif
cfif IsDefined(form.customerThree)cfset
customerThree=1#customerThree#,cfelse0/cfif
)
/cfquery

Then if you had another page showing who has done what it could look
something like this

cfquery name=get datasource=#request.dsn# ...
select customerOne,customerTwo,customerThree
from dbo.somewhere
where someid=#maybesomevar#
/cfquery
cfparam name=ATTRIBUTES.customerOne default=#get.customerOne#
cfparam name=ATTRIBUTES.customerTwo default=#get.customerTwo#
cfparam name=ATTRIBUTES.customerThree default=#get.customerThree#

FORM 
input type=checkbox name=customerOne cfif len(ATTRIBUTES.customerOne)
GT 0selected/cfif
input type=checkbox name=customerTwo cfif len(ATTRIBUTES.customerTwo)
GT 0selected/cfif
input type=checkbox name=customerThree cfif
len(ATTRIBUTES.customerThree) GT 0selected/cfif
/FORM

Just a quick and straight forward way but there are others and probably
better,

J

-Original Message-
From: Kris Pilles [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 2:33 PM
To: CF-Talk
Subject: RE: Multiple Checkbox update?


All I need to do is have the action page either enter a 1 into a field
in my DB if the checkbox is defined (selected).  

I've got a list of clients and they want the ability to check them off
on a monthly basis inorder to keep track of billing.  So, I have a drop
down that has our different services.  The user selects the ares they
want, then it lists all the clients with a checkbox.  If the checkbox is
checked, they were billed in the previous cycle, if it isn't they will
check it and add it to our accounting system.



-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, April 09, 2002 9:29 AM
To: CF-Talk
Subject: Re: Multiple Checkbox update?


There are many ways to skin this cat, but it all depends on your
checkboxes and what your trying to accomplish.  If you could provide
more details, I am sure you will get some good help!

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



 Does anyone happen to know where I can find a good example of a
multiple
 checkbox update?  I need one today and I've never done it before.
Any,
 input would be appreciated.  Thanks!
 


__
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: Big Record Set Return

2002-04-09 Thread Frank Mamone

If it's an IE only application you can use the ActiveX Combo box which is
installed with IE.

- Original Message -
From: Garza, Jeff [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, April 09, 2002 2:24 AM
Subject: RE: Big Record Set Return

 What we did to limit the resultset was use an initial search page with
 wildcards and return the matching records in a paged format.  This worked
 really well and avoided the select scrolling issues that my users hated so
 much.  I try to Just Say No to dropdowns with more than 100 elements.
 Now, if there was a good combobox out there that actually worked like a
 combobox, I might rethink that number...

 Jeff

 -Original Message-
 From: Douglas Brown
 To: CF-Talk
 Sent: 4/8/02 11:17 PM
 Subject: Re: Big Record Set Return

 I would say so. I wouldnt even take the time to look through 500 items
 in a dropdown
 list.

 Success is a journey, not a destination!!

 Doug Brown
 - Original Message -
 From: Peter Tilbrook [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Monday, April 08, 2002 11:00 PM
 Subject: RE: Big Record Set Return

  You should really build some sort of previous/next functionality of
 say
  100 rows at a time - and perhaps a search feature also.

  -Original Message-
  From: Paul Hastings [mailto:[EMAIL PROTECTED]]
  Sent: Tuesday, 9 April 2002 3:28 PM
  To: CF-Talk
  Subject: Re: Big Record Set Return

   I have a query that returns 7,300 records (just two columns, and
  eventually
   but the output is slow.  The results are written to a drop down
 menu.  It

  rendering clientside will be a bear not to mention who's going to pull
  down a select of 7k rows? that will take patience of biblical
 proportions.

  i think you need a re-think.

__
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: inetinfo.exe taking 99% of CPU?

2002-04-09 Thread Christopher Olive


what do the logs say?

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


-Original Message-
From: David Grabbe [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 9:45 AM
To: CF-Talk
Subject: RE: inetinfo.exe taking 99% of CPU?


Nope -- ANY CF script, even without any database processing, loops, etc.

David

David Grabbe
Manager, Information Systems
Church of the Great God
[EMAIL PROTECTED]
http://www.cgg.org



-Original Message-
From: Christopher Olive [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 9:46 AM
To: CF-Talk
Subject: RE: inetinfo.exe taking 99% of CPU?


is it any particular CF script?  if so, perhaps there's an infinite loop or
somesuch.

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


-Original Message-
From: David Grabbe [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 08, 2002 9:53 PM
To: CF-Talk
Subject: SOT: inetinfo.exe taking 99% of CPU?


Hello all,

I've run into a problem with my local development machine (Win2k, IIS, CF
4.5).  For some bizarre reason today whenever I try to run a CF script, the
INETINFO.exe service suddenly pegs out at 99% of the CPU, and the only way I
can get it to release is to reboot.  I have tried uninstalling and
reinstalling IIS, but that didn't help.  Has anyone else run into this
problem with inetinfo before?  Any ideas why this started happening, and how
I can make it stop?  :)

TIA,
David


David Grabbe
Manager, Information Systems
Church of the Great God
[EMAIL PROTECTED]
http://www.cgg.org





__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.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: inetinfo.exe taking 99% of CPU?


Quoting from google groups:

=
you don't have to reboot to kill inetinfo..
maybe you should try stopping the services in control panel services
next take a look at microsofts ftp site for the updates and / or
patches..
are you running site server?
cause it's not the netinfo.exe causeing the problem, check to see what other
IIS 4.0 related servers you have running and look at thos as well
===

maybe try stop/starting the World Wide Web Publishing Service (which is
IIS) from the services control panel. If that doesn't work try getting the
utility called kill.exe


There's probably some network configuration problem, I had 
this problem with NT4.0 a while back. You open Task 
manager and try to end the process and it refuses to. NT 
Option pack(or was it the resource kit?) came with a 
utility called kill.exe which allows you to execute the 
command kill inetinfo.exe from a command line, not a 
permanent fix but it will allow you to get back to work 
until you can diagnose the true cause.
==

And the solution:

===
I had a problem not long ago with the process Inetinfo.exe grabbing 100% of
the CPU on my NT 4.0 server.  After contacting Microsoft and getting the ASP
Hotfix mentioned in several message here, I had no luck.  But I did find my
problem, and I could have slapped my forehead after I found it.  The
Frontpage forms that posted to a forms result html page had grown so large
(5 - 10 MB) that simply working with them had stalled out the server.  After
archiving and flushing the forms results pages the Server runs smoothly
again.  As I said, a real forehead slapper, but sometimes it is the simple
ones that cause some trouble.  If anyone else is slapping there foreheads at
this moment,  just know you're not alone.
==

this suggest that the problem is a coding problem and not related to file
corruption or a service pack fix. I would suggest you look at you code more
closly or post it here for all the gang to take a crack at.




Anthony Petruzzi
Webmaster
954-321-4703
http://www.sheriff.org


-Original Message-
From: David Grabbe [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 9:45 AM
To: CF-Talk
Subject: RE: inetinfo.exe taking 99% of CPU?


Nope -- ANY CF script, even without any database processing, loops, etc.

David

David Grabbe
Manager, Information Systems
Church of the Great God
[EMAIL PROTECTED]
http://www.cgg.org



-Original Message-
From: Christopher Olive [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 9:46 AM
To: CF-Talk
Subject: RE: inetinfo.exe taking 99% of CPU?


is it any particular CF script?  if so, perhaps there's an infinite loop or
somesuch.

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


-Original Message-
From: David Grabbe [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 08, 2002 9:53 PM
To: CF-Talk
Subject: SOT: inetinfo.exe taking 99% of CPU?


Hello all,

I've run into a problem with my local development machine (Win2k, IIS, CF
4.5).  For some bizarre reason today whenever I try to run a CF script, the
INETINFO.exe service suddenly pegs out at 99% of the CPU, and the only way I
can get it to release is to reboot.  I have tried uninstalling and
reinstalling IIS, but that didn't help.  Has anyone else run into this
problem with inetinfo before?  Any ideas why this started happening, and how
I can make it stop?  :)

TIA,
David


David Grabbe
Manager, Information Systems
Church of the Great God
[EMAIL PROTECTED]
http://www.cgg.org





__
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, etc., with CF running under own user account

2002-04-09 Thread Earl, George


  If we set up CF to run not as a system account but under 
  its own user account do we then have to give that user 
  account permissions to access any folders on which we 
  want to use cfdirectory, cffile, etc.?
 
 Yes. Full details of required permissions for CF on Windows 
 with IIS are available here:
 http://www.defusion.com/articles/index.cfm?ArticleID=89
 
 Dave Watts, CTO, Fig Leaf Software

Thanks for the reference. Good stuff. A lot of it is over my head . . .

As a matter of general principle, is it acceptable or good practice to set
up ColdFusion server under its own account?

We have a requirement to bring back lists of files from folders on remote
servers and then make links to the remote files. To do this we need to run
CF under its own account instead of under the system account. Since this is
our only CF server, should we let the requirement to access remote
folders/files drive the type of account under which CF runs? Are there
drawbacks to switching CF from running under a system account to running
under its own account? What would you do?

Thanks!

George
[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

Anyone use Actuate's e.Reporting? was- I need printable reports i n browser from Oracle (must be an alter native to Crystal#!@?#!!?

2002-04-09 Thread Kevan . Windle

So I,m now looking at actuate's e.Reporting as an alternative to Crystal
http://www.actuate.com/ it looks a pretty cool. Anyone with views on it?

-Original Message-
From: Matthew R. Small [mailto:[EMAIL PROTECTED]]
Sent: 09 April 2002 14:41
To: CF-Talk
Subject: RE: I need printable reports in browser from Oracle (must be an
alter native to Crystal#!@?#!!?

I don't think there's any easy answer for this, but if you're using
Windows and Word, you can do what I do and generate the reports in CF
then send to Word via COM.  Email me off list for more info.

- Matt Small

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, April 09, 2002 5:11 AM
To: CF-Talk
Subject: I need printable reports in browser from Oracle (must be an
alter native to Crystal#!@?#!!?

There must be a good reporting tool out there. At the moment we use
Crystal
to produce them and it's active-x viewer app to display and print them.
But
Crystal is a dog, that fs up every server we have installed it on
and
you have to install on the web server to get the viewer to work, despite
the
fact that you're not supposed to need to. Plus it's inflexible and
limited
in terms of the reports it produces. 
Short of writing reports in CF and using something to turn them into
PDF's,
what else is there? There must be something? Please tell me there's any
easy
answer to this.

**

The opinions expressed in this E-mail are those  of  the individual  and
not  necessarily  the  company.  This E-mail and  any files transmitted 
with it are confidential and solely for the use of the intended
recipients

**

__
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: inetinfo.exe taking 99% of CPU?

2002-04-09 Thread David Grabbe


Here's the code:

-

cfif ParameterExists(m) IS No
cfset m=d
/cfif

cfif ParameterExists(s) IS No
cfset s=photo_date
/cfif


cfquery name=ygt_gallery datasource=cgg maxrows=10
SELECT *
FROM gallery
ORDER BY #s#
cfif m IS dDESCcfelseASC/cfif
/cfquery

html
head
titlePhoto Gallery/title



SCRIPT LANGUAGE=JavaScript
!--

function SetAll()
{

}

function launchModify(int_num) {
terms = window.open(ygt_gallery_modify.cfm?int_num= + 
int_num, mini,
scrollbars=yes,resizable=yes,status=yes,width=800,height=600);
self.mini = terms
}

function launchAdd() {
terms = window.open(ygt_gallery_modify.cfm, mini,
scrollbars=yes,resizable=yes,status=yes,width=800,height=600);
self.mini = terms
}

function launchDelete(int_num) {
terms = window.open(ygt_gallery_delete.cfm?int_num= + 
int_num, mini,
scrollbars=yes,resizable=yes,status=yes,width=800,height=250);
self.mini = terms
}


//--
/SCRIPT


/head

body  OnLoad=SetAll() LANGUAGE=JavaScript


cfset flag=0

div align=center


A  href=JavaScript:launchAdd()font size=2 face=arialAdd
New/a/font

/div
table align=center border=1 bordercolor=black cellspacing=0
cellpadding=0trtd
table
cf_clickable_header
column_headers = Photo Date,Title,Caption,Filename,Active?,,
field_names = photo_date,title,caption,file_name,active_rec
column_sort = Y,Y,N,Y,N
file_name = ygt_gallery_admin.cfm
m=#m#
s=#s#
bg_color=a8a8ff

cfoutput query=ygt_gallery

cfif flag IS 1
CFSET flag=0
tr bgcolor=c1 
cfelse
CFSET flag=1
tr
/cfif


tdfont size=2 face=arial#DateFormat(photo_date, 
m/d/)#/td
tdfont size=2 face=arial#title#/td
tdfont size=2 face=arial#caption#/a/td
td align=centerfont size=2 face=arial#file_name#/td
td align=centerfont size=2 face=arial#active_rec#/td
td

A  href=JavaScript:launchModify('#int_num#')

font size=2 face=arialedit/anbsp:nbsp;nbsp;nbsp;

A  href=JavaScript:launchDelete('#int_num#')

font size=2 face=arialdelete/a
/td
/tr




/cfoutput

/table
/td/tr/table

/body
/html

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 9:52 AM
To: CF-Talk
Subject: RE: inetinfo.exe taking 99% of CPU?


[snip]

this suggest that the problem is a coding problem and not related to file
corruption or a service pack fix. I would suggest you look at you code more
closly or post it here for all the gang to take a crack at.




Anthony Petruzzi
Webmaster
954-321-4703
http://www.sheriff.org


-Original Message-
From: David Grabbe [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 9:45 AM
To: CF-Talk
Subject: RE: inetinfo.exe taking 99% of CPU?


Nope -- ANY CF script, even without any database processing, loops, etc.

David

David Grabbe
Manager, Information Systems
Church of the Great God
[EMAIL PROTECTED]
http://www.cgg.org



-Original Message-
From: Christopher Olive [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 9:46 AM
To: CF-Talk
Subject: RE: inetinfo.exe taking 99% of CPU?


is it any particular CF script?  if so, perhaps there's an infinite loop or
somesuch.

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


-Original Message-
From: David Grabbe [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 08, 2002 9:53 PM
To: CF-Talk
Subject: SOT: inetinfo.exe taking 99% of CPU?


Hello all,

I've run into a problem with my local development machine (Win2k, IIS, CF
4.5).  For some bizarre reason today whenever I try to run a CF script, the
INETINFO.exe service suddenly pegs out at 99% of the CPU, and the only way I
can get it to release is to reboot.  I have tried uninstalling and
reinstalling IIS, but that didn't help.  Has anyone else run into this
problem with inetinfo before?  Any ideas why this started happening, and how
I can make it stop?  :)

TIA,
David


David Grabbe
Manager, Information Systems
Church of the Great God
[EMAIL PROTECTED]
http://www.cgg.org






__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ:

RE: Multiple Checkbox update?

On another note, is it possible to incorporatre a checkbox into CFGRID?

If so, this will work for me?

-Original Message-
From: John McCosker [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, April 09, 2002 9:53 AM
To: CF-Talk
Subject: RE: Multiple Checkbox update?

form ...
input type=checkbox name=customerOne
input type=checkbox name=customerTwo
input type=checkbox name=customerThree
/form

Then when your doing your insert query

cfquery name=insert datasource=#request.dsn# ...
INSERT INTO tblSubscribe

(customerOne,customerTwo,customerThree)
(
cfif IsDefined(form.customerOne)cfset
customerOne=1#customerOne#,cfelse0,/cfif
cfif IsDefined(form.customerTwo)cfset
customerTwo=1#customerTwo#,cfelse0,/cfif
cfif IsDefined(form.customerThree)cfset
customerThree=1#customerThree#,cfelse0/cfif
)
/cfquery

Then if you had another page showing who has done what it could look
something like this

cfquery name=get datasource=#request.dsn# ...
select customerOne,customerTwo,customerThree
from dbo.somewhere
where someid=#maybesomevar#
/cfquery
cfparam name=ATTRIBUTES.customerOne default=#get.customerOne#
cfparam name=ATTRIBUTES.customerTwo default=#get.customerTwo#
cfparam name=ATTRIBUTES.customerThree default=#get.customerThree#

FORM 
input type=checkbox name=customerOne cfif
len(ATTRIBUTES.customerOne) GT 0selected/cfif input type=checkbox
name=customerTwo cfif len(ATTRIBUTES.customerTwo) GT
0selected/cfif input type=checkbox name=customerThree cfif
len(ATTRIBUTES.customerThree) GT 0selected/cfif
/FORM

Just a quick and straight forward way but there are others and probably
better,

J

-Original Message-
From: Kris Pilles [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 2:33 PM
To: CF-Talk
Subject: RE: Multiple Checkbox update?

All I need to do is have the action page either enter a 1 into a field
in my DB if the checkbox is defined (selected).  

I've got a list of clients and they want the ability to check them off
on a monthly basis inorder to keep track of billing.  So, I have a drop
down that has our different services.  The user selects the ares they
want, then it lists all the clients with a checkbox.  If the checkbox is
checked, they were billed in the previous cycle, if it isn't they will
check it and add it to our accounting system.

-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, April 09, 2002 9:29 AM
To: CF-Talk
Subject: Re: Multiple Checkbox update?

There are many ways to skin this cat, but it all depends on your
checkboxes and what your trying to accomplish.  If you could provide
more details, I am sure you will get some good help!

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

 Does anyone happen to know where I can find a good example of a
multiple
 checkbox update?  I need one today and I've never done it before.
Any,
 input would be appreciated.  Thanks!

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

SQL help - getting first rec of field????

2002-04-09 Thread Amanda Stern


Hello,

I have been trying to figure out how to write this SQL
stmt..I have it written but it needs one more
modificationI need the query to only pull the
first unique EventID...

SELECT  CMME.iMonthlyEventId as EventID, 
CMME.iCMApptId as CMapptID, 
cli.vClientFName + cli.vClientLName as  
  ClientName,
CMME.dMonthlyEventDate as Event Date, 
cas.iCasacApptID as CasacID,
cas.dCasacDate as CasacDate,
emp.vEmpFName + emp.vEmpLNAme as Case_Manager,
cd1.vcodedecode as eventtypeName
FROMCMMonthlyEvent CMME,  codedecode cd1, 
Client cli, employee emp, CasacAppt cas,  
CasacApptRelationship rel
WHERE  emp.iempId = CMME.iempId
ANDcas.iClientID  =  cli.iClientID
ANDcd1.icodedecodeId = CMME.cEventTypeId
ANDCMME.iCMApptId = rel.iCMApptId
ANDcas.iCasacApptID = rel.icasacapptid
order by   CMME.iCMApptId, dmonthlyeventdate

the partial results are:

EventID   CMapptID ...
  601
  601  
  751
  751
  803
  803
  803 

I want the results to be..
  601
  751 
  803



 


__
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.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: What IDE are you using for Java CFX?

2002-04-09 Thread BillyC


JRun Studio is the same thing as Studio, only with more focus on JSP
(thing of the difference between Homesite and Studio).  It wouldn't get
you anywhere as far as building CFX's goes.

---
Billy Cravens


-Original Message-
From: VAN VLIET, SCOTT E (SBCSI) [mailto:[EMAIL PROTECTED]] 
Sent: Monday, April 08, 2002 5:24 PM
To: CF-Talk
Subject: OT: What IDE are you using for Java CFX?

What IDE are you folks out there using for developing Java CFX?  I am
currently using CF Studio and the command line compiler (pain in the
@$$).
I was considering buyin' a copy of JRun Studio, but wanted to see what
the
masses think.  Thanks!

--
Scott Van Vliet
Senior Analyst
SBC Services, Inc.
ITO Enterprise Tools
Office: 858.886.3878
Pager: 858.536.0070
Email: [EMAIL PROTECTED]


-Original Message-
From: James McCullough [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 08, 2002 6:08 PM
To: CF-Talk
Subject: OT: Borland JBuilder6 for CFX


Has anyone here used Jbuilder to build CFX tags? I am trying to setup a
project environment to import the com.allaire.cfx.* classes and Jbuilder
says that it cannot find the classes. When I use the command line
compiler
with the classpath attributes supplied,  the tag compiles and works.
However
I don't want to use CF Studio and would like to take advantage of the
features in JBuilder. Any ideas on how to set it up? New to JBuilder.



__
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: inetinfo.exe taking 99% of CPU?

2002-04-09 Thread BillyC


Sounds more like your CF DLL is messed up (make sure you're pointing to
cfusion\bin\iscf.dll)  Also, are you running the last version of 4.5?
What about Windows service packs and updates?

---
Billy Cravens


-Original Message-
From: David Grabbe [mailto:[EMAIL PROTECTED]] 
Sent: Monday, April 08, 2002 8:53 PM
To: CF-Talk
Subject: SOT: inetinfo.exe taking 99% of CPU?

Hello all,

I've run into a problem with my local development machine (Win2k, IIS,
CF
4.5).  For some bizarre reason today whenever I try to run a CF script,
the
INETINFO.exe service suddenly pegs out at 99% of the CPU, and the only
way I
can get it to release is to reboot.  I have tried uninstalling and
reinstalling IIS, but that didn't help.  Has anyone else run into this
problem with inetinfo before?  Any ideas why this started happening, and
how
I can make it stop?  :)

TIA,
David


David Grabbe
Manager, Information Systems
Church of the Great God
[EMAIL PROTECTED]
http://www.cgg.org



__
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: SQL help - getting first rec of field????

2002-04-09 Thread Kevin Schmidt


SELECT DISTINCT(CMME.iMonthlyEventID)

:)

Kevin


-Original Message-
From: Amanda Stern [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, April 09, 2002 9:18 AM
To: CF-Talk
Subject: SQL help - getting first rec of field

Hello,

I have been trying to figure out how to write this SQL
stmt..I have it written but it needs one more
modificationI need the query to only pull the
first unique EventID...

SELECT  CMME.iMonthlyEventId as EventID, 
CMME.iCMApptId as CMapptID, 
cli.vClientFName + cli.vClientLName as  
  ClientName,
CMME.dMonthlyEventDate as Event Date, 
cas.iCasacApptID as CasacID,
cas.dCasacDate as CasacDate,
emp.vEmpFName + emp.vEmpLNAme as Case_Manager,
cd1.vcodedecode as eventtypeName
FROMCMMonthlyEvent CMME,  codedecode cd1, 
Client cli, employee emp, CasacAppt cas,  
CasacApptRelationship rel
WHERE  emp.iempId = CMME.iempId
ANDcas.iClientID  =  cli.iClientID
ANDcd1.icodedecodeId = CMME.cEventTypeId
ANDCMME.iCMApptId = rel.iCMApptId
ANDcas.iCasacApptID = rel.icasacapptid
order by   CMME.iCMApptId, dmonthlyeventdate

the partial results are:

EventID   CMapptID ...
  601
  601  
  751
  751
  803
  803
  803 

I want the results to be..
  601
  751 
  803



 


__
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/

__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.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 Checkbox update?

2002-04-09 Thread Stocke Terri


Hi Kris--

Here's one example. This code loops over a set of query results to display
the number of needed checkboxes. If the database has the field as 1, then
the checkbox is checked when displayed. Otherwise it is unchecked:

cfloop query=myquery

input type=hidden name=primarykey#currentRow#
value=#myquery.primarykey#
cfif myquery.field is 1
cfinput type=Checkbox name=field#currentRow#
checked=Yes

cfelse
cfinput type=Checkbox name=field#currentRow#

/cfif
/CFloop

input type=hidden name=NumRecords value=#myquery.recordcount#




Now you need the action page:

!---  Loop through the form fields and update the table. Remember, checkbox
fields are ONLY passed here
if the checkbox was checked. So, we have to check to see if the checkbox for
each row was defined. If so, set field to 1.
If not, assume the box wasn't checked and set field to NULL.---
 
CFLOOP FROM = 1 TO = #NumRecords# INDEX = ThisRow
CFIF IsDefined(Form.field  ThisRow)
cfset field=1
cfelse
cfset field=NULL
/cfif
CFQUERY DATASOURCE = mydatasource
name=update#ThisRow#
UPDATE table
SET field= #field#
WHERE primarykey = #Evaluate(form.primarykey  ThisRow)#
/CFQUERY

/CFLOOP



-Original Message-
From: Kris Pilles [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 9:52 AM
To: CF-Talk
Subject: RE: Multiple Checkbox update?


I guess my problem is that I have all of these checkboxes and I need to
update the field associated with it in my databse but they all have the
same name. So, I figured I would use the primary key with the name but
now I don't know how to incorporate that in my query?

-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, April 09, 2002 9:48 AM
To: CF-Talk
Subject: Re: Multiple Checkbox update?


If you have lets say 10 different checkboxes and each of those
checkboxes relate to a column in your database, and if it is checked,
you want a 1 and if not, a 0, use cfparam to set the default value of
the checkboxes to 0 and then if a checkbox is actually checked and the
form field has the value of 1, cfparam will be ignored, and the value
will be set to 1, if the checkbox is not checked, the form value will
default to 0.

cfparam name=form.checkboxvalueA default=0
cfparam name=form.checkboxvalueB default=0
cfparam name=form.checkboxvalueC default=0

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



 All I need to do is have the action page either enter a 1 into a field

 in my DB if the checkbox is defined (selected).

 I've got a list of clients and they want the ability to check them off

 on a monthly basis inorder to keep track of billing.  So, I have a 
 drop down that has our different services.  The user selects the ares 
 they want, then it lists all the clients with a checkbox.  If the 
 checkbox is checked, they were billed in the previous cycle, if it 
 isn't they will check it and add it to our accounting system.



 -Original Message-
 From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, April 09, 2002 9:29 AM
 To: CF-Talk
 Subject: Re: Multiple Checkbox update?


 There are many ways to skin this cat, but it all depends on your 
 checkboxes and what your trying to accomplish.  If you could provide 
 more details, I am sure you will get some good help!

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



  Does anyone happen to know where I can find a good example of a
 multiple
  checkbox update?  I need one today and I've never done it before.
 Any,
  input would be appreciated.  Thanks!
 

 


__
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 Checkbox update?


Yep this would be another way of presenting the data,
handy for people who are used to using access which is usually accounts type
people,

of course the data would be represented in a cfgrid column
as oppossed to checkbox on output,

I'm not sure about using cfgrid for initial fresh input,

John


-Original Message-
From: Kris Pilles [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 3:14 PM
To: CF-Talk
Subject: RE: Multiple Checkbox update?


On another note, is it possible to incorporatre a checkbox into CFGRID?


If so, this will work for me?

-Original Message-
From: John McCosker [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, April 09, 2002 9:53 AM
To: CF-Talk
Subject: RE: Multiple Checkbox update?


form ...
input type=checkbox name=customerOne
input type=checkbox name=customerTwo
input type=checkbox name=customerThree
/form

Then when your doing your insert query

cfquery name=insert datasource=#request.dsn# ...
INSERT INTO tblSubscribe

(customerOne,customerTwo,customerThree)
(
cfif IsDefined(form.customerOne)cfset
customerOne=1#customerOne#,cfelse0,/cfif
cfif IsDefined(form.customerTwo)cfset
customerTwo=1#customerTwo#,cfelse0,/cfif
cfif IsDefined(form.customerThree)cfset
customerThree=1#customerThree#,cfelse0/cfif
)
/cfquery

Then if you had another page showing who has done what it could look
something like this

cfquery name=get datasource=#request.dsn# ...
select customerOne,customerTwo,customerThree
from dbo.somewhere
where someid=#maybesomevar#
/cfquery
cfparam name=ATTRIBUTES.customerOne default=#get.customerOne#
cfparam name=ATTRIBUTES.customerTwo default=#get.customerTwo#
cfparam name=ATTRIBUTES.customerThree default=#get.customerThree#

FORM 
input type=checkbox name=customerOne cfif
len(ATTRIBUTES.customerOne) GT 0selected/cfif input type=checkbox
name=customerTwo cfif len(ATTRIBUTES.customerTwo) GT
0selected/cfif input type=checkbox name=customerThree cfif
len(ATTRIBUTES.customerThree) GT 0selected/cfif
/FORM

Just a quick and straight forward way but there are others and probably
better,

J

-Original Message-
From: Kris Pilles [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 2:33 PM
To: CF-Talk
Subject: RE: Multiple Checkbox update?


All I need to do is have the action page either enter a 1 into a field
in my DB if the checkbox is defined (selected).  

I've got a list of clients and they want the ability to check them off
on a monthly basis inorder to keep track of billing.  So, I have a drop
down that has our different services.  The user selects the ares they
want, then it lists all the clients with a checkbox.  If the checkbox is
checked, they were billed in the previous cycle, if it isn't they will
check it and add it to our accounting system.



-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, April 09, 2002 9:29 AM
To: CF-Talk
Subject: Re: Multiple Checkbox update?


There are many ways to skin this cat, but it all depends on your
checkboxes and what your trying to accomplish.  If you could provide
more details, I am sure you will get some good help!

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



 Does anyone happen to know where I can find a good example of a
multiple
 checkbox update?  I need one today and I've never done it before.
Any,
 input would be appreciated.  Thanks!
 




__
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: inetinfo.exe taking 99% of CPU?


does this just happen with this page or does it happen will all pages CF
tries to process?

Anthony Petruzzi
Webmaster
954-321-4703
http://www.sheriff.org
__
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 Checkbox update?

But it wouldn't display as a checkbox is what your saying?

-Original Message-
From: John McCosker [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, April 09, 2002 10:24 AM
To: CF-Talk
Subject: RE: Multiple Checkbox update?

Yep this would be another way of presenting the data,
handy for people who are used to using access which is usually accounts
type people,

of course the data would be represented in a cfgrid column
as oppossed to checkbox on output,

I'm not sure about using cfgrid for initial fresh input,

John

-Original Message-
From: Kris Pilles [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 3:14 PM
To: CF-Talk
Subject: RE: Multiple Checkbox update?

On another note, is it possible to incorporatre a checkbox into CFGRID?

If so, this will work for me?

-Original Message-
From: John McCosker [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, April 09, 2002 9:53 AM
To: CF-Talk
Subject: RE: Multiple Checkbox update?

form ...
input type=checkbox name=customerOne
input type=checkbox name=customerTwo
input type=checkbox name=customerThree
/form

Then when your doing your insert query

cfquery name=insert datasource=#request.dsn# ...
INSERT INTO tblSubscribe

(customerOne,customerTwo,customerThree)
(
cfif IsDefined(form.customerOne)cfset
customerOne=1#customerOne#,cfelse0,/cfif
cfif IsDefined(form.customerTwo)cfset
customerTwo=1#customerTwo#,cfelse0,/cfif
cfif IsDefined(form.customerThree)cfset
customerThree=1#customerThree#,cfelse0/cfif
)
/cfquery

Then if you had another page showing who has done what it could look
something like this

cfquery name=get datasource=#request.dsn# ...
select customerOne,customerTwo,customerThree
from dbo.somewhere
where someid=#maybesomevar#
/cfquery
cfparam name=ATTRIBUTES.customerOne default=#get.customerOne#
cfparam name=ATTRIBUTES.customerTwo default=#get.customerTwo#
cfparam name=ATTRIBUTES.customerThree default=#get.customerThree#

FORM 
input type=checkbox name=customerOne cfif
len(ATTRIBUTES.customerOne) GT 0selected/cfif input type=checkbox
name=customerTwo cfif len(ATTRIBUTES.customerTwo) GT
0selected/cfif input type=checkbox name=customerThree cfif
len(ATTRIBUTES.customerThree) GT 0selected/cfif
/FORM

Just a quick and straight forward way but there are others and probably
better,

J

-Original Message-
From: Kris Pilles [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 2:33 PM
To: CF-Talk
Subject: RE: Multiple Checkbox update?

All I need to do is have the action page either enter a 1 into a field
in my DB if the checkbox is defined (selected).  

I've got a list of clients and they want the ability to check them off
on a monthly basis inorder to keep track of billing.  So, I have a drop
down that has our different services.  The user selects the ares they
want, then it lists all the clients with a checkbox.  If the checkbox is
checked, they were billed in the previous cycle, if it isn't they will
check it and add it to our accounting system.

-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, April 09, 2002 9:29 AM
To: CF-Talk
Subject: Re: Multiple Checkbox update?

There are many ways to skin this cat, but it all depends on your
checkboxes and what your trying to accomplish.  If you could provide
more details, I am sure you will get some good help!

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

 Does anyone happen to know where I can find a good example of a
multiple
 checkbox update?  I need one today and I've never done it before.
Any,
 input would be appreciated.  Thanks!

__
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

Access2000 file size limits?

2002-04-09 Thread Jeff Green


Was wondering what file size limits Access2000 DB have?

TIA,
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

CFERROR

2002-04-09 Thread Yves Arsenault


I'm about to use the CFERROR tag for the first time, and I'd just like to
know what the best way to use it is.

In an application.cfm file, or for specific errors on the same
template...

Any input?
Yves Arsenault
Carrefour Infotech
5,promenade Acadian
Charlottetown, IPE
C1C 1M2
[EMAIL PROTECTED]
(902)368-1895 ext.242
ICQ #117650823


__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.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 Checkbox update?


As far as I'm aware,
No!!

Check your documentation,
type cfgrid in studio click in it and press F1,

J

-Original Message-
From: Kris Pilles [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 3:29 PM
To: CF-Talk
Subject: RE: Multiple Checkbox update?


But it wouldn't display as a checkbox is what your saying?

-Original Message-
From: John McCosker [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, April 09, 2002 10:24 AM
To: CF-Talk
Subject: RE: Multiple Checkbox update?


Yep this would be another way of presenting the data,
handy for people who are used to using access which is usually accounts
type people,

of course the data would be represented in a cfgrid column
as oppossed to checkbox on output,

I'm not sure about using cfgrid for initial fresh input,

John


-Original Message-
From: Kris Pilles [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 3:14 PM
To: CF-Talk
Subject: RE: Multiple Checkbox update?


On another note, is it possible to incorporatre a checkbox into CFGRID?


If so, this will work for me?

-Original Message-
From: John McCosker [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, April 09, 2002 9:53 AM
To: CF-Talk
Subject: RE: Multiple Checkbox update?


form ...
input type=checkbox name=customerOne
input type=checkbox name=customerTwo
input type=checkbox name=customerThree
/form

Then when your doing your insert query

cfquery name=insert datasource=#request.dsn# ...
INSERT INTO tblSubscribe

(customerOne,customerTwo,customerThree)
(
cfif IsDefined(form.customerOne)cfset
customerOne=1#customerOne#,cfelse0,/cfif
cfif IsDefined(form.customerTwo)cfset
customerTwo=1#customerTwo#,cfelse0,/cfif
cfif IsDefined(form.customerThree)cfset
customerThree=1#customerThree#,cfelse0/cfif
)
/cfquery

Then if you had another page showing who has done what it could look
something like this

cfquery name=get datasource=#request.dsn# ...
select customerOne,customerTwo,customerThree
from dbo.somewhere
where someid=#maybesomevar#
/cfquery
cfparam name=ATTRIBUTES.customerOne default=#get.customerOne#
cfparam name=ATTRIBUTES.customerTwo default=#get.customerTwo#
cfparam name=ATTRIBUTES.customerThree default=#get.customerThree#

FORM 
input type=checkbox name=customerOne cfif
len(ATTRIBUTES.customerOne) GT 0selected/cfif input type=checkbox
name=customerTwo cfif len(ATTRIBUTES.customerTwo) GT
0selected/cfif input type=checkbox name=customerThree cfif
len(ATTRIBUTES.customerThree) GT 0selected/cfif
/FORM

Just a quick and straight forward way but there are others and probably
better,

J

-Original Message-
From: Kris Pilles [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 2:33 PM
To: CF-Talk
Subject: RE: Multiple Checkbox update?


All I need to do is have the action page either enter a 1 into a field
in my DB if the checkbox is defined (selected).  

I've got a list of clients and they want the ability to check them off
on a monthly basis inorder to keep track of billing.  So, I have a drop
down that has our different services.  The user selects the ares they
want, then it lists all the clients with a checkbox.  If the checkbox is
checked, they were billed in the previous cycle, if it isn't they will
check it and add it to our accounting system.



-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, April 09, 2002 9:29 AM
To: CF-Talk
Subject: Re: Multiple Checkbox update?


There are many ways to skin this cat, but it all depends on your
checkboxes and what your trying to accomplish.  If you could provide
more details, I am sure you will get some good help!

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



 Does anyone happen to know where I can find a good example of a
multiple
 checkbox update?  I need one today and I've never done it before.
Any,
 input would be appreciated.  Thanks!
 






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

RE: Access2000 file size limits?

2002-04-09 Thread Dan Phillips


None that I know of. However, if you are going to use them for web
development, don't go over 20MB, at least IMHO


Dan Phillips
CFXHosting.com

-Original Message-
From: Jeff Green [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 10:38 AM
To: CF-Talk
Subject: Access2000 file size limits?


Was wondering what file size limits Access2000 DB have?

TIA,
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: SQL help - getting first rec of field????

2002-04-09 Thread Amanda Stern


Kevin,

I actually tried this earlier and it still gave me the
same results...I think its because the CasacID can be
a one - two relationshipI am tring to make it work
as an embedded query so it will select the top
iMonthlyEventID, grouped by iMonthlyEventIDnto
sure if this is possible though...


--- Kevin Schmidt [EMAIL PROTECTED] wrote:
 SELECT DISTINCT(CMME.iMonthlyEventID)
 
 :)
 
 Kevin
 
 
 -Original Message-
 From: Amanda Stern [mailto:[EMAIL PROTECTED]] 
 Sent: Tuesday, April 09, 2002 9:18 AM
 To: CF-Talk
 Subject: SQL help - getting first rec of field
 
 Hello,
 
 I have been trying to figure out how to write this
 SQL
 stmt..I have it written but it needs one more
 modificationI need the query to only pull the
 first unique EventID...
 
 SELECTCMME.iMonthlyEventId as EventID, 
 CMME.iCMApptId as CMapptID, 
 cli.vClientFName + cli.vClientLName as  
   ClientName,
 CMME.dMonthlyEventDate as Event Date, 
 cas.iCasacApptID as CasacID,
 cas.dCasacDate as CasacDate,
 emp.vEmpFName + emp.vEmpLNAme as
 Case_Manager,
   cd1.vcodedecode as eventtypeName
 FROM  CMMonthlyEvent CMME,  codedecode cd1, 
 Client cli, employee emp, CasacAppt cas,  
 CasacApptRelationship rel
 WHEREemp.iempId = CMME.iempId
 ANDcas.iClientID  =  cli.iClientID
 AND  cd1.icodedecodeId = CMME.cEventTypeId
 AND  CMME.iCMApptId = rel.iCMApptId
 ANDcas.iCasacApptID = rel.icasacapptid
 order by   CMME.iCMApptId, dmonthlyeventdate
 
 the partial results are:
 
 EventID   CMapptID ...
   601
   601  
   751
   751
   803
   803
   803 
 
 I want the results to be..
   601
   751 
   803
 
 
 
  
 
 
 __
 Do You Yahoo!?
 Yahoo! Tax Center - online filing with TurboTax
 http://taxes.yahoo.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: Multiple CFMail Problem

2002-04-09 Thread Willy Ray


What do you think would be the best way to add a delay?  Just loop through some math a 
couple thousand times?

Willy

 [EMAIL PROTECTED] 04/08/02 11:38AM 
Hi,

Thanks for shedding some light on this subject.  Just for the record it is 
not fixed in CF5 as we experience this same behavior you described and have 
solved it somewhat by adding in a delay.

Thanks

Chuck Rodgers

At 12:30 PM 4/8/02 -0500, you wrote:
We experienced this problem with all versions of 4.5.  Allaire never did
'fix' the error.  They claimed it was fixed in 4.5.1, however it still
existed, just wasn't as persistent as earlier versions.

Our own diagnosis determined that the cause of the error was the
cfmail.dll(I forget the actual name of the DLL) was trying to write two
files at the same time. Or perhaps more correctly, it would attempt to
write the second file before the first was closed.  We would typically
end up with 0k files in the undeliverable section.

Anyway, adding some pause between the cfmails may solve your problem
provided the site isn't terribly active and there aren't too many
simultaneous requests to these cfmail calls. We found the size of the
emails also greatly affected how often this error would occur.  For
example, if you have a page that sends 4 different emails to 4 different
contacts at one company and each email contains a 10k attachment, you
can start to duplicate this bug with some regularity.  Now imagine that
page being hit every 5 seconds... Now, the speed of your server and file
system are also going to affect how often this happens.  So, adding
pauses and using smaller emails MAY solve your problem depends on how
active your site is.

Ultimately, our solution was to switch to an alternate means of
generating email.  We switched to an ASP product that is actually
multi-threaded unlike Allaire/Macromedias solution.

For years, I have been suggesting that CF Enterprise be bundled with a
robust multi-threaded smtp spooler that should be directly tied to the
application engine.  Enterprise sites that deal with high mail loads
would benefit from this.  Also, it would add more product disparity
between pro and ent, something I personally feel is lacking.

I have not tested these same errors (bugs?) in CF 5.  Perhaps it has
been corrected, but honestly, if past performance of eliminating mail
bugs between revisions is any indication, I would suspect they only
added new and more exciting problems ;)

Trey Rouse
Internet Project Coordinator
Web Services - Rice University
MS 119 - 713.348.4799

PS - I love CFM, I just loath CFMAIL.

-Original Message-
From: Willy Ray [mailto:[EMAIL PROTECTED]] 
Sent: Monday, April 08, 2002 10:43 AM
To: CF-Talk
Subject: Multiple CFMail Problem

Hey All,

Here's my situation.  I have an application that generates 3 total
emails.  User clicks submit, it generates one email, then they're taken
to another page on which they can submit additional info.  If they do
this, two more emails are created, one to the person who is gathering
the info, and another back to the user thanking them for sending
additional info.

My problem is, the middle email doesn't always get sent.  I click the
first submit button, I always get the email, I do the additional info,
hit submit, and I always get the thanks for the more info message, but
I only get the additional info message if I then hit the back button,
and re-click submit!

It seems like the time between messages is to short, and I'm getting
these additional info messages in my undelivrable folder.  How long do I
need to wait between messages, and what's the best way to accomplish the
waiting?  two separate templates?

Help!

Willy Ray



-
Willy Ray
Web Applications Developer
Certified Advanced ColdFusion Developer
Westminster College




__
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 Checkbox update?

2002-04-09 Thread Valerie L. Criswell


If I remember correctly, Booleans in cfgrid display a 1 or 0 and require the
user to input 1 or 0 as well (not too user-friendly).

My experience with cfgrid isn't the greatest.  If you're working in an
intranet sort of environment where you can manually make sure the right java
version gets loaded properly on each machine, it's alright.  However, if the
grid will be used in the real world, it's not too cool. cfgrid is a great
idea with poor implementation.   But that's just my opinion.

~Val

- Original Message -
From: John McCosker [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, April 09, 2002 10:32 AM
Subject: RE: Multiple Checkbox update?


 As far as I'm aware,
 No!!

 Check your documentation,
 type cfgrid in studio click in it and press F1,

 J

 -Original Message-
 From: Kris Pilles [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, April 09, 2002 3:29 PM
 To: CF-Talk
 Subject: RE: Multiple Checkbox update?


 But it wouldn't display as a checkbox is what your saying?

 -Original Message-
 From: John McCosker [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, April 09, 2002 10:24 AM
 To: CF-Talk
 Subject: RE: Multiple Checkbox update?


 Yep this would be another way of presenting the data,
 handy for people who are used to using access which is usually accounts
 type people,

 of course the data would be represented in a cfgrid column
 as oppossed to checkbox on output,

 I'm not sure about using cfgrid for initial fresh input,

 John


 -Original Message-
 From: Kris Pilles [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, April 09, 2002 3:14 PM
 To: CF-Talk
 Subject: RE: Multiple Checkbox update?


 On another note, is it possible to incorporatre a checkbox into CFGRID?


 If so, this will work for me?

 -Original Message-
 From: John McCosker [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, April 09, 2002 9:53 AM
 To: CF-Talk
 Subject: RE: Multiple Checkbox update?


 form ...
 input type=checkbox name=customerOne
 input type=checkbox name=customerTwo
 input type=checkbox name=customerThree
 /form

 Then when your doing your insert query

 cfquery name=insert datasource=#request.dsn# ...
 INSERT INTO tblSubscribe

 (customerOne,customerTwo,customerThree)
 (
 cfif IsDefined(form.customerOne)cfset
 customerOne=1#customerOne#,cfelse0,/cfif
 cfif IsDefined(form.customerTwo)cfset
 customerTwo=1#customerTwo#,cfelse0,/cfif
 cfif IsDefined(form.customerThree)cfset
 customerThree=1#customerThree#,cfelse0/cfif
 )
 /cfquery

 Then if you had another page showing who has done what it could look
 something like this

 cfquery name=get datasource=#request.dsn# ...
 select customerOne,customerTwo,customerThree
 from dbo.somewhere
 where someid=#maybesomevar#
 /cfquery
 cfparam name=ATTRIBUTES.customerOne default=#get.customerOne#
 cfparam name=ATTRIBUTES.customerTwo default=#get.customerTwo#
 cfparam name=ATTRIBUTES.customerThree default=#get.customerThree#

 FORM 
 input type=checkbox name=customerOne cfif
 len(ATTRIBUTES.customerOne) GT 0selected/cfif input type=checkbox
 name=customerTwo cfif len(ATTRIBUTES.customerTwo) GT
 0selected/cfif input type=checkbox name=customerThree cfif
 len(ATTRIBUTES.customerThree) GT 0selected/cfif
 /FORM

 Just a quick and straight forward way but there are others and probably
 better,

 J

 -Original Message-
 From: Kris Pilles [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, April 09, 2002 2:33 PM
 To: CF-Talk
 Subject: RE: Multiple Checkbox update?


 All I need to do is have the action page either enter a 1 into a field
 in my DB if the checkbox is defined (selected).

 I've got a list of clients and they want the ability to check them off
 on a monthly basis inorder to keep track of billing.  So, I have a drop
 down that has our different services.  The user selects the ares they
 want, then it lists all the clients with a checkbox.  If the checkbox is
 checked, they were billed in the previous cycle, if it isn't they will
 check it and add it to our accounting system.



 -Original Message-
 From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, April 09, 2002 9:29 AM
 To: CF-Talk
 Subject: Re: Multiple Checkbox update?


 There are many ways to skin this cat, but it all depends on your
 checkboxes and what your trying to accomplish.  If you could provide
 more details, I am sure you will get some good help!

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



  Does anyone happen to know where I can find a good example of a
 multiple
  checkbox update?  I need one today and I've never done it before.
 Any,
  input would be appreciated.  Thanks!
 






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

RE: Pausing using CF


Just out of curiousity,
why would you do this, or when would you.

J

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 2:02 PM
To: CF-Talk
Subject: RE: Pausing using CF


cfscript
/**
 * Pauses the processing for CF for a specified amount of time
 * 
 * @param seconds  number of seconds you would like to pause CF for
 * @author Tony Petruzzi ([EMAIL PROTECTED]
 * @version 1, April, 09 2002
 */
function PauseCF(seconds){
var currenttime = now();
while(DateDiff(s, currenttime, now()) LTE seconds){
continue;
}
}
/cfscript


Here is a function a wrote to do this. All you have to do to use it is
assign the function to a variable.

cfset temp = PauseCF(10)

Have fun!

Anthony Petruzzi
Webmaster
954-321-4703
http://www.sheriff.org


-Original Message-
From: Michael Tangorre [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 08, 2002 7:53 PM
To: CF-Talk
Subject: Pausing using CF


Hello.

Can anyone think of a way that I can achieve a pause for like 30 seconds to
a minute between iterations in a loop?

would another loop inside work that did nothing or is there a better way?

Mike





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

RE: Access2000 file size limits?

2002-04-09 Thread Mark A. Kruger - CFG


Since it's file based, at least some of your limitation will be based on
your disk subsystem.  You could probably get away with a file larger than
20megs if you have a strong disk system (read that not ide), but I
wouldn't want a larger file than say 100 megs... and then you better compact
it frequently.  Realistically, if you are already concerned about file size,
then access is probably not the best choice in any case...


-Original Message-
From: Dan Phillips [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 9:36 AM
To: CF-Talk
Subject: RE: Access2000 file size limits?


None that I know of. However, if you are going to use them for web
development, don't go over 20MB, at least IMHO


Dan Phillips
CFXHosting.com

-Original Message-
From: Jeff Green [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 10:38 AM
To: CF-Talk
Subject: Access2000 file size limits?


Was wondering what file size limits Access2000 DB have?

TIA,
Jeff


__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.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: Access2000 file size limits?

2002-04-09 Thread Jeff Green


hehehe,

Your gonna love this then :)

Im using Access for temp storage of some dynamically generated code, Im
approaching 400mb access .mdb file ;)

jeff

-Original Message-
From: Dan Phillips [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 7:36 AM
To: CF-Talk
Subject: RE: Access2000 file size limits?


None that I know of. However, if you are going to use them for web
development, don't go over 20MB, at least IMHO


Dan Phillips
CFXHosting.com

-Original Message-
From: Jeff Green [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 10:38 AM
To: CF-Talk
Subject: Access2000 file size limits?


Was wondering what file size limits Access2000 DB have?

TIA,
Jeff


__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.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 Checkbox update?

I agree, this is a internal...not much else our programmer can build
today application...

-Original Message-
From: Valerie L. Criswell [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, April 09, 2002 10:45 AM
To: CF-Talk
Subject: Re: Multiple Checkbox update?

If I remember correctly, Booleans in cfgrid display a 1 or 0 and require
the user to input 1 or 0 as well (not too user-friendly).

My experience with cfgrid isn't the greatest.  If you're working in an
intranet sort of environment where you can manually make sure the right
java version gets loaded properly on each machine, it's alright.
However, if the grid will be used in the real world, it's not too cool.
cfgrid is a great
idea with poor implementation.   But that's just my opinion.

~Val

- Original Message -
From: John McCosker [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, April 09, 2002 10:32 AM
Subject: RE: Multiple Checkbox update?

 As far as I'm aware,
 No!!

 Check your documentation,
 type cfgrid in studio click in it and press F1,

 J

 -Original Message-
 From: Kris Pilles [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, April 09, 2002 3:29 PM
 To: CF-Talk
 Subject: RE: Multiple Checkbox update?

 But it wouldn't display as a checkbox is what your saying?

 -Original Message-
 From: John McCosker [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, April 09, 2002 10:24 AM
 To: CF-Talk
 Subject: RE: Multiple Checkbox update?

 Yep this would be another way of presenting the data,
 handy for people who are used to using access which is usually 
 accounts type people,

 of course the data would be represented in a cfgrid column as 
 oppossed to checkbox on output,

 I'm not sure about using cfgrid for initial fresh input,

 John

 -Original Message-
 From: Kris Pilles [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, April 09, 2002 3:14 PM
 To: CF-Talk
 Subject: RE: Multiple Checkbox update?

 On another note, is it possible to incorporatre a checkbox into 
 CFGRID?

 If so, this will work for me?

 -Original Message-
 From: John McCosker [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, April 09, 2002 9:53 AM
 To: CF-Talk
 Subject: RE: Multiple Checkbox update?

 form ...
 input type=checkbox name=customerOne
 input type=checkbox name=customerTwo
 input type=checkbox name=customerThree
 /form

 Then when your doing your insert query

 cfquery name=insert datasource=#request.dsn# ...
 INSERT INTO tblSubscribe

 (customerOne,customerTwo,customerThree)
 (
 cfif IsDefined(form.customerOne)cfset
 customerOne=1#customerOne#,cfelse0,/cfif
 cfif IsDefined(form.customerTwo)cfset
 customerTwo=1#customerTwo#,cfelse0,/cfif
 cfif IsDefined(form.customerThree)cfset
 customerThree=1#customerThree#,cfelse0/cfif
 )
 /cfquery

 Then if you had another page showing who has done what it could look 
 something like this

 cfquery name=get datasource=#request.dsn# ...
 select customerOne,customerTwo,customerThree
 from dbo.somewhere
 where someid=#maybesomevar#
 /cfquery
 cfparam name=ATTRIBUTES.customerOne default=#get.customerOne# 
 cfparam name=ATTRIBUTES.customerTwo default=#get.customerTwo# 
 cfparam name=ATTRIBUTES.customerThree 
 default=#get.customerThree#

 FORM 
 input type=checkbox name=customerOne cfif
 len(ATTRIBUTES.customerOne) GT 0selected/cfif input 
 type=checkbox name=customerTwo cfif len(ATTRIBUTES.customerTwo) 
 GT
 0selected/cfif input type=checkbox name=customerThree cfif
 len(ATTRIBUTES.customerThree) GT 0selected/cfif
 /FORM

 Just a quick and straight forward way but there are others and 
 probably better,

 J

 -Original Message-
 From: Kris Pilles [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, April 09, 2002 2:33 PM
 To: CF-Talk
 Subject: RE: Multiple Checkbox update?

 All I need to do is have the action page either enter a 1 into a field

 in my DB if the checkbox is defined (selected).

 I've got a list of clients and they want the ability to check them off

 on a monthly basis inorder to keep track of billing.  So, I have a 
 drop down that has our different services.  The user selects the ares 
 they want, then it lists all the clients with a checkbox.  If the 
 checkbox is checked, they were billed in the previous cycle, if it 
 isn't they will check it and add it to our accounting system.

 -Original Message-
 From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, April 09, 2002 9:29 AM
 To: CF-Talk
 Subject: Re: Multiple Checkbox update?

 There are many ways to skin this cat, but it all depends on your 
 checkboxes and what your trying to accomplish.  If you could provide 
 more details, I am sure you will get some good help!

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

  Does anyone happen to know where I can find a good example of a
 multiple
  checkbox update?  I need one today and I've never done it before.
 Any,
  input would be appreciated.  Thanks!

RE: Pausing using CF

2002-04-09 Thread Rick Eidson

We use a cf_Spleep to paus the script to wait for a file to convert or move
to a different folder.

Rick

-Original Message-
From: John McCosker [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 9:45 AM
To: CF-Talk
Subject: RE: Pausing using CF

Just out of curiousity,
why would you do this, or when would you.

J

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 2:02 PM
To: CF-Talk
Subject: RE: Pausing using CF

cfscript
/**
 * Pauses the processing for CF for a specified amount of time
 * 
 * @param seconds  number of seconds you would like to pause CF for
 * @author Tony Petruzzi ([EMAIL PROTECTED]
 * @version 1, April, 09 2002
 */
function PauseCF(seconds){
var currenttime = now();
while(DateDiff(s, currenttime, now()) LTE seconds){
continue;
}
}
/cfscript

Here is a function a wrote to do this. All you have to do to use it is
assign the function to a variable.

cfset temp = PauseCF(10)

Have fun!

Anthony Petruzzi
Webmaster
954-321-4703
http://www.sheriff.org

-Original Message-
From: Michael Tangorre [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 08, 2002 7:53 PM
To: CF-Talk
Subject: Pausing using CF

Hello.

Can anyone think of a way that I can achieve a pause for like 30 seconds to
a minute between iterations in a loop?

would another loop inside work that did nothing or is there a better way?

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: Multiple Checkbox update?


I totally agree,

its slow on the client and cumbersome, you'll have to give it a lot of tlc,
a html equivalent would be fresher and faster and not java enabled
(dependant),
also your free to be a bit more creative than just a grid,

j

-Original Message-
From: Valerie L. Criswell [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 3:45 PM
To: CF-Talk
Subject: Re: Multiple Checkbox update?


If I remember correctly, Booleans in cfgrid display a 1 or 0 and require the
user to input 1 or 0 as well (not too user-friendly).

My experience with cfgrid isn't the greatest.  If you're working in an
intranet sort of environment where you can manually make sure the right java
version gets loaded properly on each machine, it's alright.  However, if the
grid will be used in the real world, it's not too cool. cfgrid is a great
idea with poor implementation.   But that's just my opinion.

~Val

- Original Message -
From: John McCosker [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, April 09, 2002 10:32 AM
Subject: RE: Multiple Checkbox update?


 As far as I'm aware,
 No!!

 Check your documentation,
 type cfgrid in studio click in it and press F1,

 J

 -Original Message-
 From: Kris Pilles [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, April 09, 2002 3:29 PM
 To: CF-Talk
 Subject: RE: Multiple Checkbox update?


 But it wouldn't display as a checkbox is what your saying?

 -Original Message-
 From: John McCosker [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, April 09, 2002 10:24 AM
 To: CF-Talk
 Subject: RE: Multiple Checkbox update?


 Yep this would be another way of presenting the data,
 handy for people who are used to using access which is usually accounts
 type people,

 of course the data would be represented in a cfgrid column
 as oppossed to checkbox on output,

 I'm not sure about using cfgrid for initial fresh input,

 John


 -Original Message-
 From: Kris Pilles [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, April 09, 2002 3:14 PM
 To: CF-Talk
 Subject: RE: Multiple Checkbox update?


 On another note, is it possible to incorporatre a checkbox into CFGRID?


 If so, this will work for me?

 -Original Message-
 From: John McCosker [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, April 09, 2002 9:53 AM
 To: CF-Talk
 Subject: RE: Multiple Checkbox update?


 form ...
 input type=checkbox name=customerOne
 input type=checkbox name=customerTwo
 input type=checkbox name=customerThree
 /form

 Then when your doing your insert query

 cfquery name=insert datasource=#request.dsn# ...
 INSERT INTO tblSubscribe

 (customerOne,customerTwo,customerThree)
 (
 cfif IsDefined(form.customerOne)cfset
 customerOne=1#customerOne#,cfelse0,/cfif
 cfif IsDefined(form.customerTwo)cfset
 customerTwo=1#customerTwo#,cfelse0,/cfif
 cfif IsDefined(form.customerThree)cfset
 customerThree=1#customerThree#,cfelse0/cfif
 )
 /cfquery

 Then if you had another page showing who has done what it could look
 something like this

 cfquery name=get datasource=#request.dsn# ...
 select customerOne,customerTwo,customerThree
 from dbo.somewhere
 where someid=#maybesomevar#
 /cfquery
 cfparam name=ATTRIBUTES.customerOne default=#get.customerOne#
 cfparam name=ATTRIBUTES.customerTwo default=#get.customerTwo#
 cfparam name=ATTRIBUTES.customerThree default=#get.customerThree#

 FORM 
 input type=checkbox name=customerOne cfif
 len(ATTRIBUTES.customerOne) GT 0selected/cfif input type=checkbox
 name=customerTwo cfif len(ATTRIBUTES.customerTwo) GT
 0selected/cfif input type=checkbox name=customerThree cfif
 len(ATTRIBUTES.customerThree) GT 0selected/cfif
 /FORM

 Just a quick and straight forward way but there are others and probably
 better,

 J

 -Original Message-
 From: Kris Pilles [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, April 09, 2002 2:33 PM
 To: CF-Talk
 Subject: RE: Multiple Checkbox update?


 All I need to do is have the action page either enter a 1 into a field
 in my DB if the checkbox is defined (selected).

 I've got a list of clients and they want the ability to check them off
 on a monthly basis inorder to keep track of billing.  So, I have a drop
 down that has our different services.  The user selects the ares they
 want, then it lists all the clients with a checkbox.  If the checkbox is
 checked, they were billed in the previous cycle, if it isn't they will
 check it and add it to our accounting system.



 -Original Message-
 From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, April 09, 2002 9:29 AM
 To: CF-Talk
 Subject: Re: Multiple Checkbox update?


 There are many ways to skin this cat, but it all depends on your
 checkboxes and what your trying to accomplish.  If you could provide
 more details, I am sure you will get some good help!

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



  Does anyone happen to know where I can find a good example of a
 multiple
  checkbox update?  I need one

RE: Access2000 file size limits?

2002-04-09 Thread Dan Phillips

It all depends on the server you are on too. If you are hosted on a shared
server (meaning there could be almost 100 other sites on the same server)
you may run into some issues. If you are the only one on the server, I doubt
you will have much trouble.

-Original Message-
From: Jeff Green [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 10:57 AM
To: CF-Talk
Subject: RE: Access2000 file size limits?

hehehe,

Your gonna love this then :)

Im using Access for temp storage of some dynamically generated code, Im
approaching 400mb access .mdb file ;)

jeff

-Original Message-
From: Dan Phillips [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 7:36 AM
To: CF-Talk
Subject: RE: Access2000 file size limits?

None that I know of. However, if you are going to use them for web
development, don't go over 20MB, at least IMHO

Dan Phillips
CFXHosting.com

-Original Message-
From: Jeff Green [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 10:38 AM
To: CF-Talk
Subject: Access2000 file size limits?

Was wondering what file size limits Access2000 DB have?

TIA,
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

--- Dave Watts [EMAIL PROTECTED] escribió:
This is the problem that's eating my brain now.
I need to access to a asp file that send me back a
cvs
file as attachment. I can not see how to get the
cvs
file. Down there is the piece of cf code and
continuesly
what I see in the client side. Any ideas???

//
//This is what I see in the browser
///
The requested file is not ASCII text and can not
be
rendered.

The mime-type:

application/unknown

Versions of CF prior to 5.0, I think, will not let
you display
CFHTTP.FileContent if CF doesn't recognize the MIME
type to be text. I don't
think there's much you can do about that, but you
can work around it by
using the FILE attribute of CFHTTP to write the
content to a file, then use
CFFILE to read it.

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

You were right Dave.Thanks a lot!. I solved 95 %
of my problem following your suggestion. I already got
the data (in fact is a cvs file) saved in a file after
using CFHTTP's FILE and Path attributes. My final goal
is to make a query with the cvs file's data. CFHTTP
tag give me the posibility to do that directly but I
Think I can't do that 'cause the delimiter caracter
(,)
is part of some data's fields too. and I don't see how
to modify the file before using cfhttp. Is there any
easy way to accomplish that.Perhaps working from
the saved file???.
Thanks ,Thanks again
Mario
I,m posting down here the modified script and the
results that showed up in the browser.

//the modified script

cfhttp NAME=InstrLedAttQuery
COLUMNS=Username,FirstName,MiddleInitial,LastName,GroupID,GroupName,Email,Address1,Address2,City,State/Province,PostalCode,Country,Title,StartDate,EndDate,Audit?,Completed?,CEUCredit?,EnterTime,ExitTime,ElapsedTime(minutes)
RESOLVEURL=Yes REDIRECT=No
USERAGENT=Mozilla/4.0 (compatible; MSIE 6.0 Windows
NT 5.1; Q312461) PATH=D:\ek_content\EkOutsideRetriv
FILE=test1.cvs METHOD=POST URL=#InstrLedAttURL#

cfhttpparam NAME=ZDUSMSK TYPE=Cookie
VALUE=#cook#
/cfhttp

CFOUTPUT QUERY=InstrLedAttQuery
//
#Username#,#FirstName#,#MiddleInitial#
/
/CFOUTPUT

//
//This what I get in the browser.

Error Occurred While Processing Request
Error Diagnostic Information
QUERY

The QUERY attribute of the tag does not specify the
name of an available query

The error occurred while processing an element with a
general identifier of (CFOUTPUT), occupying document
position (199:1) to (199:35).

Date/Time: 03/11/02 09:22:18
Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows
NT 5.0)
Remote Address: 66.109.35.50

_
Do You Yahoo!?
Información de Estados Unidos y América Latina, en Yahoo! Noticias.
Visítanos en http://noticias.espanol.yahoo.com
__
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Access2000 file size limits?

2002-04-09 Thread Mark A. Kruger - CFG


Jeff,

I once had an access file as large as a gigabyte (mine's bigger than yours
phbbbt!), and a dBase file of almost 2 gigs.  However, that's not a
recomended procedure.  If your access is all look-ups (written to little and
read a lot), then with caching you can make it work reasonably well. If you
are doing e-com, CRM or anything that requires a lot of data manipulation
into and out of the DB, then access is less than desirable choice. IMHO 
or maybe just IMO (hehe).

-Mark

-Original Message-
From: Jeff Green [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 9:57 AM
To: CF-Talk
Subject: RE: Access2000 file size limits?


hehehe,

Your gonna love this then :)

Im using Access for temp storage of some dynamically generated code, Im
approaching 400mb access .mdb file ;)

jeff

-Original Message-
From: Dan Phillips [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 7:36 AM
To: CF-Talk
Subject: RE: Access2000 file size limits?


None that I know of. However, if you are going to use them for web
development, don't go over 20MB, at least IMHO


Dan Phillips
CFXHosting.com

-Original Message-
From: Jeff Green [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 10:38 AM
To: CF-Talk
Subject: Access2000 file size limits?


Was wondering what file size limits Access2000 DB have?

TIA,
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

UDFDates and week numbers

2002-04-09 Thread CF_JONNY


Happy Tuesday!

I would like to automatically generate the weeks of the year as a number and
then have the date automatically come along with it.

Example:
1 - 12-31-01
2 - 01-07-02
3 - 01-14-02
4 - 01-21-02
52 - 12-

Is anyone aware of a UDF that can return such an animal?

Then, I would like to query those results and return a range of the current
week and two previous and two following.

Any Ideas would be great

JON



_

Do You Yahoo!?

Get your free yahoo.com address at http://mail.yahoo.com



__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.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

Input parameters for stored procedures

2002-04-09 Thread Janine Jakim


I have a stored procedure set that gives info for an entire grade or just
one class depending on what the user chooses (by way of select boxes).
But I can't seem to get the cfprocparam correct- When I try to pull by grade
only I keep getting the error 

ODBC Error Code = 22005 (Error in assignment)
[Microsoft][ODBC SQL Server Driver]Invalid character value for cast
specification
SQL = sproc_GetStudents

This is how I'm calling the sp
CFSTOREDPROC PROCEDURE= sproc_GetStudents DATASOURCE=#Request.dsn#

CFPROCPARAM TYPE=IN DBVARNAME=GRADE CFSQLTYPE=CF_SQL_VarChar
VALUE=#GRADE#
CFPROCPARAM TYPE=IN DBVARNAME=TCHRLINK CFSQLTYPE=CF_SQL_INTEGER
VALUE=#TCHRLINK#
CFPROCPARAM TYPE=OUT DBVARNAME=STUDENTID CFSQLTYPE=CF_SQL_VarChar
VARIABLE=STUDENTID
CFPROCRESULT NAME=StudentPrint
/CFSTOREDPROC

I added Null=yes but then just received a blank screen back. 
Thanks for any help
__
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

is this even possible?? Loop using lists?

2002-04-09 Thread Jeff Fongemie


Hello cf-talk,

Is this even possible??

I have a form, that collects name, age, and gender, for a list of
  people. I get the it all as a form submission as in form.name1,
  form.age1, form.gender1, form.name2, form.age2 and so on.

  What I need to do, is create a new record in a parent table, to hold
  some other stuff for the transaction, then add each name, age and
  gender as a new record into a child table.  THe parent record and
  each child record share a customerID.

  The parent table is easy, but I'm having trouble getting a loop to
  run through and insert each name,age,gender combo as a new record in
  the child table.

  This is my attempt:

 !--- set up list of names to loop through ---
cfoutput
cfset namelist = 
#form.name1#,#form.name2#,#form.name3#,#form.name4#,#form.name5#,#form.name6#,#form.name7#,#form.name8#,#form.name9#,#form.name10#,#form.name11#
 

cfset agelist = 
#form.age1#,#form.age2#,#form.age3#,#form.age4#,#form.age5#,#form.age6#,#form.age7#,#form.age8#,#form.age9#,#form.age10#,#form.age11#
 

cfset genderlist =
#form.gender1#,#form.gender2#,#form.gender3#,#form.gender4#,#form.gender5#,#form.gender6#,#form.gender7#,#form.gender8#,#form.gender9#,#form.gender10#,#form.gender11#
 

!--- set up the number of items in the list so we know when to stop ---
cfset length=listLen(nameList)

/cfoutput


THEN, I INSERT to the parent table to make a new record and get a
customerID.

Now the hard part:  I'm having trouble getting a loop to use all three
lists. Is the following even close??


cfquery name=addmembers datasource=pfestregistration dbtype=ODBC
cfloop from=1 to=#length# list=#namelist#
INSERT INTO Customers_members

(customerid,
name,
age,
gender,
address, 
address2, 
city, 
state, 
zip, 
telephone, 
email,
emergencycontact,
emergencynumber)
Values 
('#customerid#', 

'#namelist#',
'#agelist#',
'#genderlist#',

'#form.address2#', 
'#form.city#', 
'#form.state#', 
'#form.zip#', 
'#form.telephone#',
'#form.email#',
'#form.emergencycontact#',
'#form.contactnumber#'); 

/cfloop
/cfquery
  


Best regards,
 Jeff Fongemie  mailto:[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: Input parameters for stored procedures

2002-04-09 Thread Andy Ewings


Are the order of your params in the SP the same order as you are passing
them in?  i.e. grade then thcrlink, then studentid?they need to be.
Also double check that the datatypes of the variables in the SP are the same
as the datatypes in the procparam tag.  Finally ensure that the data being
passed in is of the datatype that you have specified

-Original Message-
From: Janine Jakim [mailto:[EMAIL PROTECTED]]
Sent: 09 April 2002 16:37
To: CF-Talk
Subject: Input parameters for stored procedures


I have a stored procedure set that gives info for an entire grade or just
one class depending on what the user chooses (by way of select boxes).
But I can't seem to get the cfprocparam correct- When I try to pull by grade
only I keep getting the error 

ODBC Error Code = 22005 (Error in assignment)
[Microsoft][ODBC SQL Server Driver]Invalid character value for cast
specification
SQL = sproc_GetStudents

This is how I'm calling the sp
CFSTOREDPROC PROCEDURE= sproc_GetStudents DATASOURCE=#Request.dsn#

CFPROCPARAM TYPE=IN DBVARNAME=@GRADE CFSQLTYPE=CF_SQL_VarChar
VALUE=#GRADE#
CFPROCPARAM TYPE=IN DBVARNAME=@TCHRLINK CFSQLTYPE=CF_SQL_INTEGER
VALUE=#TCHRLINK#
CFPROCPARAM TYPE=OUT DBVARNAME=@STUDENTID CFSQLTYPE=CF_SQL_VarChar
VARIABLE=STUDENTID
CFPROCRESULT NAME=StudentPrint
/CFSTOREDPROC

I added Null=yes but then just received a blank screen back. 
Thanks for any help

__
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: is this even possible?? Loop using lists?

2002-04-09 Thread Kevin Schmidt


You might do better to store the information you want to go into the
child table in a structure rather than a list.  You can pull the info
out a little easier, you could also use an array.  That way you have all
your info in one place rather than 3 separate lists. 

Kevin


-Original Message-
From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, April 09, 2002 10:47 AM
To: CF-Talk
Subject: is this even possible?? Loop using lists?

Hello cf-talk,

Is this even possible??

I have a form, that collects name, age, and gender, for a list of
  people. I get the it all as a form submission as in form.name1,
  form.age1, form.gender1, form.name2, form.age2 and so on.

  What I need to do, is create a new record in a parent table, to hold
  some other stuff for the transaction, then add each name, age and
  gender as a new record into a child table.  THe parent record and
  each child record share a customerID.

  The parent table is easy, but I'm having trouble getting a loop to
  run through and insert each name,age,gender combo as a new record in
  the child table.

  This is my attempt:

 !--- set up list of names to loop through ---
cfoutput
cfset namelist =
#form.name1#,#form.name2#,#form.name3#,#form.name4#,#form.name5#,#form.
name6#,#form.name7#,#form.name8#,#form.name9#,#form.name10#,#form.name11
# 

cfset agelist =
#form.age1#,#form.age2#,#form.age3#,#form.age4#,#form.age5#,#form.age6#
,#form.age7#,#form.age8#,#form.age9#,#form.age10#,#form.age11# 

cfset genderlist =
#form.gender1#,#form.gender2#,#form.gender3#,#form.gender4#,#form.gende
r5#,#form.gender6#,#form.gender7#,#form.gender8#,#form.gender9#,#form.ge
nder10#,#form.gender11# 

!--- set up the number of items in the list so we know when to stop
---
cfset length=listLen(nameList)

/cfoutput


THEN, I INSERT to the parent table to make a new record and get a
customerID.

Now the hard part:  I'm having trouble getting a loop to use all three
lists. Is the following even close??


cfquery name=addmembers datasource=pfestregistration
dbtype=ODBC
cfloop from=1 to=#length# list=#namelist#
INSERT INTO Customers_members

(customerid,
name,
age,
gender,
address, 
address2, 
city, 
state, 
zip, 
telephone, 
email,
emergencycontact,
emergencynumber)
Values 
('#customerid#', 

'#namelist#',
'#agelist#',
'#genderlist#',

'#form.address2#', 
'#form.city#', 
'#form.state#', 
'#form.zip#', 
'#form.telephone#',
'#form.email#',
'#form.emergencycontact#',
'#form.contactnumber#'); 

/cfloop
/cfquery
  


Best regards,
 Jeff Fongemie  mailto:[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: Input parameters for stored procedures

2002-04-09 Thread Mark A. Kruger - CFG


Janine,

I suspect that one of your chose types is wrong.  instead of
CF_SQL_VARCHAR have you tried any other character types?  How is your local
variable declared within the stored proc?

-Original Message-
From: Janine Jakim [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 10:37 AM
To: CF-Talk
Subject: Input parameters for stored procedures


I have a stored procedure set that gives info for an entire grade or just
one class depending on what the user chooses (by way of select boxes).
But I can't seem to get the cfprocparam correct- When I try to pull by grade
only I keep getting the error

ODBC Error Code = 22005 (Error in assignment)
[Microsoft][ODBC SQL Server Driver]Invalid character value for cast
specification
SQL = sproc_GetStudents

This is how I'm calling the sp
CFSTOREDPROC PROCEDURE= sproc_GetStudents DATASOURCE=#Request.dsn#

CFPROCPARAM TYPE=IN DBVARNAME=@GRADE CFSQLTYPE=CF_SQL_VarChar
VALUE=#GRADE#
CFPROCPARAM TYPE=IN DBVARNAME=@TCHRLINK CFSQLTYPE=CF_SQL_INTEGER
VALUE=#TCHRLINK#
CFPROCPARAM TYPE=OUT DBVARNAME=@STUDENTID CFSQLTYPE=CF_SQL_VarChar
VARIABLE=STUDENTID
CFPROCRESULT NAME=StudentPrint
/CFSTOREDPROC

I added Null=yes but then just received a blank screen back.
Thanks for any help

__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.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: is this even possible?? Loop using lists?

2002-04-09 Thread David Schmidt


It is.  Example:

cfset list=one,two,three,four
cfloop list=#yourlist# index=listitem
  cfoutput#listitem#/cfoutputbr
/cfloop

Will produce:

one
two
three
four



 -Original Message-
 From: Jeff Fongemie [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, April 09, 2002 8:47 AM
 To: CF-Talk
 Subject: is this even possible?? Loop using lists?
 
 
 Hello cf-talk,
 
 Is this even possible??
 
 I have a form, that collects name, age, and gender, for a list of
   people. I get the it all as a form submission as in form.name1,
   form.age1, form.gender1, form.name2, form.age2 and so on.
 
   What I need to do, is create a new record in a parent table, to hold
   some other stuff for the transaction, then add each name, age and
   gender as a new record into a child table.  THe parent record and
   each child record share a customerID.
 
   The parent table is easy, but I'm having trouble getting a loop to
   run through and insert each name,age,gender combo as a new record in
   the child table.
 
   This is my attempt:
 
  !--- set up list of names to loop through ---
 cfoutput
 cfset namelist = 
 #form.name1#,#form.name2#,#form.name3#,#form.name4#,#form.name5#,
 #form.name6#,#form.name7#,#form.name8#,#form.name9#,#form.name10#,
 #form.name11# 
 
 cfset agelist = 
 #form.age1#,#form.age2#,#form.age3#,#form.age4#,#form.age5#,#form
 .age6#,#form.age7#,#form.age8#,#form.age9#,#form.age10#,#form.age11# 
 
 cfset genderlist =
 #form.gender1#,#form.gender2#,#form.gender3#,#form.gender4#,#form
 .gender5#,#form.gender6#,#form.gender7#,#form.gender8#,#form.gende
 r9#,#form.gender10#,#form.gender11# 
 
 !--- set up the number of items in the list so we know when to stop ---
 cfset length=listLen(nameList)
 
 /cfoutput
 
 
 THEN, I INSERT to the parent table to make a new record and get a
 customerID.
 
 Now the hard part:  I'm having trouble getting a loop to use all three
 lists. Is the following even close??
 
 
 cfquery name=addmembers datasource=pfestregistration 
 dbtype=ODBC
 cfloop from=1 to=#length# list=#namelist#
 INSERT INTO Customers_members
 
 (customerid,
 name,
 age,
 gender,
 address, 
 address2, 
 city, 
 state, 
 zip, 
 telephone, 
 email,
 emergencycontact,
 emergencynumber)
 Values 
 ('#customerid#', 
 
 '#namelist#',
 '#agelist#',
 '#genderlist#',
 
 '#form.address2#', 
 '#form.city#', 
 '#form.state#', 
 '#form.zip#', 
 '#form.telephone#',
 '#form.email#',
 '#form.emergencycontact#',
 '#form.contactnumber#'); 
 
 /cfloop
 /cfquery
   
 
 
 Best regards,
  Jeff Fongemie  mailto:[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: is this even possible?? Loop using lists?

2002-04-09 Thread Robert Gatton


i think it would be easier on you to use evaluate() as in...
cfloop index=i from=1 to=#number_of_peeps#
 cfquery datasource=blah
   insert into peeps(name,age,gender)
   values(
'#Evaluate(form.name#i#)#',
'#Evaluate(form.age#i#)#',
'#Evaluate(form.gender#i#)#'
   )
 /cfquery
/cfloop

- Original Message -
From: Jeff Fongemie [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, April 09, 2002 11:46 AM
Subject: is this even possible?? Loop using lists?


 Hello cf-talk,

 Is this even possible??

 I have a form, that collects name, age, and gender, for a list of
   people. I get the it all as a form submission as in form.name1,
   form.age1, form.gender1, form.name2, form.age2 and so on.

   What I need to do, is create a new record in a parent table, to hold
   some other stuff for the transaction, then add each name, age and
   gender as a new record into a child table.  THe parent record and
   each child record share a customerID.

   The parent table is easy, but I'm having trouble getting a loop to
   run through and insert each name,age,gender combo as a new record in
   the child table.

   This is my attempt:

  !--- set up list of names to loop through ---
 cfoutput
 cfset namelist =
#form.name1#,#form.name2#,#form.name3#,#form.name4#,#form.name5#,#form.name
6#,#form.name7#,#form.name8#,#form.name9#,#form.name10#,#form.name11# 

 cfset agelist =
#form.age1#,#form.age2#,#form.age3#,#form.age4#,#form.age5#,#form.age6#,#fo
rm.age7#,#form.age8#,#form.age9#,#form.age10#,#form.age11# 

 cfset genderlist =

#form.gender1#,#form.gender2#,#form.gender3#,#form.gender4#,#form.gender5#,
#form.gender6#,#form.gender7#,#form.gender8#,#form.gender9#,#form.gender10#,
#form.gender11# 

 !--- set up the number of items in the list so we know when to stop ---
 cfset length=listLen(nameList)

 /cfoutput


 THEN, I INSERT to the parent table to make a new record and get a
 customerID.

 Now the hard part:  I'm having trouble getting a loop to use all three
 lists. Is the following even close??


 cfquery name=addmembers datasource=pfestregistration
dbtype=ODBC
 cfloop from=1 to=#length# list=#namelist#
 INSERT INTO Customers_members

 (customerid,
 name,
 age,
 gender,
 address,
 address2,
 city,
 state,
 zip,
 telephone,
 email,
 emergencycontact,
 emergencynumber)
 Values
 ('#customerid#',

 '#namelist#',
 '#agelist#',
 '#genderlist#',

 '#form.address2#',
 '#form.city#',
 '#form.state#',
 '#form.zip#',
 '#form.telephone#',
 '#form.email#',
 '#form.emergencycontact#',
 '#form.contactnumber#');

 /cfloop
 /cfquery



 Best regards,
  Jeff Fongemie  mailto:[EMAIL PROTECTED]
 

 
__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.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: is this even possible?? Loop using lists?

2002-04-09 Thread BEN MORRIS


Since you are already using digits in the form field names, you can just loop through 
the number of items, like:

cfloop from=1 to=10 index=i
  cfset ThisName = Trim(Evaluate(form.Name#i#))
  cfset ThisAge = Trim(Evaluate(form.Age#i#))
  cfset ThisGender = Trim(Evaluate(form.Gender#i#))
  !--- You should probably do an if to make sure the values are not null ---
  cfquery ...
 INSERT INTO 
  VALUES ('#ThisName#', '#ThisAge#', '#ThisGender#'...
  /cfquery
/cfloop

 Jeff Fongemie [EMAIL PROTECTED] 04/09/02 11:46AM 
Hello cf-talk,

Is this even possible??

I have a form, that collects name, age, and gender, for a list of
  people. I get the it all as a form submission as in form.name1,
  form.age1, form.gender1, form.name2, form.age2 and so on.

  What I need to do, is create a new record in a parent table, to hold
  some other stuff for the transaction, then add each name, age and
  gender as a new record into a child table.  THe parent record and
  each child record share a customerID.

  The parent table is easy, but I'm having trouble getting a loop to
  run through and insert each name,age,gender combo as a new record in
  the child table.

  This is my attempt:

 !--- set up list of names to loop through ---
cfoutput
cfset namelist = 
#form.name1#,#form.name2#,#form.name3#,#form.name4#,#form.name5#,#form.name6#,#form.name7#,#form.name8#,#form.name9#,#form.name10#,#form.name11#
 

cfset agelist = 
#form.age1#,#form.age2#,#form.age3#,#form.age4#,#form.age5#,#form.age6#,#form.age7#,#form.age8#,#form.age9#,#form.age10#,#form.age11#
 

cfset genderlist =
#form.gender1#,#form.gender2#,#form.gender3#,#form.gender4#,#form.gender5#,#form.gender6#,#form.gender7#,#form.gender8#,#form.gender9#,#form.gender10#,#form.gender11#
 

!--- set up the number of items in the list so we know when to stop ---
cfset length=listLen(nameList)

/cfoutput


THEN, I INSERT to the parent table to make a new record and get a
customerID.

Now the hard part:  I'm having trouble getting a loop to use all three
lists. Is the following even close??


cfquery name=addmembers datasource=pfestregistration dbtype=ODBC
cfloop from=1 to=#length# list=#namelist#
INSERT INTO Customers_members

(customerid,
name,
age,
gender,
address, 
address2, 
city, 
state, 
zip, 
telephone, 
email,
emergencycontact,
emergencynumber)
Values 
('#customerid#', 

'#namelist#',
'#agelist#',
'#genderlist#',

'#form.address2#', 
'#form.city#', 
'#form.state#', 
'#form.zip#', 
'#form.telephone#',
'#form.email#',
'#form.emergencycontact#',
'#form.contactnumber#'); 

/cfloop
/cfquery
  


Best regards,
 Jeff Fongemie  mailto:[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: is this even possible?? Loop using lists?

2002-04-09 Thread Bryan Stevenson


1) You should loop over NameList and remove the from and to attributes and a add the 
index atribute
(index=currentValue)

2) Set a variable called LoopCount to 0 before your querythen increment it by 1 
for each pass of
the loop (cfset LoopCount = LoopCount + 1)

3) Where you want the element in the same position in another list (say AgeList) don't 
use
#AgeList#, use #ListGetAt(AgeList,LoopCount)#

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: Jeff Fongemie [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, April 09, 2002 8:46 AM
Subject: is this even possible?? Loop using lists?


 Hello cf-talk,

 Is this even possible??

 I have a form, that collects name, age, and gender, for a list of
   people. I get the it all as a form submission as in form.name1,
   form.age1, form.gender1, form.name2, form.age2 and so on.

   What I need to do, is create a new record in a parent table, to hold
   some other stuff for the transaction, then add each name, age and
   gender as a new record into a child table.  THe parent record and
   each child record share a customerID.

   The parent table is easy, but I'm having trouble getting a loop to
   run through and insert each name,age,gender combo as a new record in
   the child table.

   This is my attempt:

  !--- set up list of names to loop through ---
 cfoutput
 cfset namelist =
#form.name1#,#form.name2#,#form.name3#,#form.name4#,#form.name5#,#form.name6#,#form.name7#,#form.na
me8#,#form.name9#,#form.name10#,#form.name11# 

 cfset agelist =
#form.age1#,#form.age2#,#form.age3#,#form.age4#,#form.age5#,#form.age6#,#form.age7#,#form.age8#,#fo
rm.age9#,#form.age10#,#form.age11# 

 cfset genderlist =

#form.gender1#,#form.gender2#,#form.gender3#,#form.gender4#,#form.gender5#,#form.gender6#,#form.gen
der7#,#form.gender8#,#form.gender9#,#form.gender10#,#form.gender11# 

 !--- set up the number of items in the list so we know when to stop ---
 cfset length=listLen(nameList)

 /cfoutput


 THEN, I INSERT to the parent table to make a new record and get a
 customerID.

 Now the hard part:  I'm having trouble getting a loop to use all three
 lists. Is the following even close??


 cfquery name=addmembers datasource=pfestregistration dbtype=ODBC
 cfloop from=1 to=#length# list=#namelist#
 INSERT INTO Customers_members

 (customerid,
 name,
 age,
 gender,
 address,
 address2,
 city,
 state,
 zip,
 telephone,
 email,
 emergencycontact,
 emergencynumber)
 Values
 ('#customerid#',

 '#namelist#',
 '#agelist#',
 '#genderlist#',

 '#form.address2#',
 '#form.city#',
 '#form.state#',
 '#form.zip#',
 '#form.telephone#',
 '#form.email#',
 '#form.emergencycontact#',
 '#form.contactnumber#');

 /cfloop
 /cfquery



 Best regards,
  Jeff Fongemie  mailto:[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: is this even possible?? Loop using lists?

2002-04-09 Thread Raymond Camden


Ack! Evaluate police!

You do not need to use evaluate to get dynamic form names. Just use
bracket notation.

cfset thisName = form[name#i#]
etc.

===
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: BEN MORRIS [mailto:[EMAIL PROTECTED]] 
 Sent: Tuesday, April 09, 2002 11:53 AM
 To: CF-Talk
 Subject: Re: is this even possible?? Loop using lists?
 
 
 Since you are already using digits in the form field names, 
 you can just loop through the number of items, like:
 
 cfloop from=1 to=10 index=i
   cfset ThisName = Trim(Evaluate(form.Name#i#))
   cfset ThisAge = Trim(Evaluate(form.Age#i#))
   cfset ThisGender = Trim(Evaluate(form.Gender#i#))
   !--- You should probably do an if to make sure the values 
 are not null ---
   cfquery ...
  INSERT INTO 
   VALUES ('#ThisName#', '#ThisAge#', '#ThisGender#'...
   /cfquery
 /cfloop
 
  Jeff Fongemie [EMAIL PROTECTED] 04/09/02 11:46AM 
 Hello cf-talk,
 
 Is this even possible??
 
 I have a form, that collects name, age, and gender, for a list of
   people. I get the it all as a form submission as in form.name1,
   form.age1, form.gender1, form.name2, form.age2 and so on.
 
   What I need to do, is create a new record in a parent table, to hold
   some other stuff for the transaction, then add each name, age and
   gender as a new record into a child table.  THe parent record and
   each child record share a customerID.
 
   The parent table is easy, but I'm having trouble getting a loop to
   run through and insert each name,age,gender combo as a new record in
   the child table.
 
   This is my attempt:
 
 

__
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: RE: is this even possible?? Loop using lists?

2002-04-09 Thread ksuh

I wonder if Raymond dreams evaluate? :)

- Original Message -
From: Raymond Camden [EMAIL PROTECTED]
Date: Tuesday, April 9, 2002 10:00 am
Subject: RE: is this even possible?? Loop using lists?

 Ack! Evaluate police!

 You do not need to use evaluate to get dynamic form names. Just use
 bracket notation.

 cfset thisName = form[name#i#]
 etc.

===
 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: BEN MORRIS [mailto:[EMAIL PROTECTED]] 
  Sent: Tuesday, April 09, 2002 11:53 AM
  To: CF-Talk
  Subject: Re: is this even possible?? Loop using lists?

  Since you are already using digits in the form field names, 
  you can just loop through the number of items, like:

  cfloop from=1 to=10 index=i
cfset ThisName = Trim(Evaluate(form.Name#i#))
cfset ThisAge = Trim(Evaluate(form.Age#i#))
cfset ThisGender = Trim(Evaluate(form.Gender#i#))
!--- You should probably do an if to make sure the values 
  are not null ---
cfquery ...
   INSERT INTO 
    VALUES ('#ThisName#', '#ThisAge#', '#ThisGender#'...
/cfquery
  /cfloop

   Jeff Fongemie [EMAIL PROTECTED] 04/09/02 11:46AM 
  Hello cf-talk,

  Is this even possible??

  I have a form, that collects name, age, and gender, for a list of
people. I get the it all as a form submission as in form.name1,
form.age1, form.gender1, form.name2, form.age2 and so on.

What I need to do, is create a new record in a parent table, 
 to hold
some other stuff for the transaction, then add each name, age and
gender as a new record into a child table.  THe parent record and
each child record share a customerID.

The parent table is easy, but I'm having trouble getting a 
 loop to
run through and insert each name,age,gender combo as a new 
 record in
the child table.

This is my attempt:

__
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: RE: is this even possible?? Loop using lists?

2002-04-09 Thread Mike Townend

Obviously not... He dreams bracket notation ;)

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
Sent: 09 April 2002 17:06
To: CF-Talk
Subject: Re: RE: is this even possible?? Loop using lists?

I wonder if Raymond dreams evaluate? :)

- Original Message -
From: Raymond Camden [EMAIL PROTECTED]
Date: Tuesday, April 9, 2002 10:00 am
Subject: RE: is this even possible?? Loop using lists?

 Ack! Evaluate police!

 You do not need to use evaluate to get dynamic form names. Just use 
 bracket notation.

 cfset thisName = form[name#i#]
 etc.

===
 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: BEN MORRIS [mailto:[EMAIL PROTECTED]]
  Sent: Tuesday, April 09, 2002 11:53 AM
  To: CF-Talk
  Subject: Re: is this even possible?? Loop using lists?

  Since you are already using digits in the form field names,
  you can just loop through the number of items, like:

  cfloop from=1 to=10 index=i
cfset ThisName = Trim(Evaluate(form.Name#i#))
cfset ThisAge = Trim(Evaluate(form.Age#i#))
cfset ThisGender = Trim(Evaluate(form.Gender#i#))
!--- You should probably do an if to make sure the values
  are not null ---
cfquery ...
   INSERT INTO 
    VALUES ('#ThisName#', '#ThisAge#', '#ThisGender#'...
/cfquery
  /cfloop

   Jeff Fongemie [EMAIL PROTECTED] 04/09/02 11:46AM 
  Hello cf-talk,

  Is this even possible??

  I have a form, that collects name, age, and gender, for a list of
people. I get the it all as a form submission as in form.name1,
form.age1, form.gender1, form.name2, form.age2 and so on.

What I need to do, is create a new record in a parent table,
 to hold
some other stuff for the transaction, then add each name, age and
gender as a new record into a child table.  THe parent record and
each child record share a customerID.

The parent table is easy, but I'm having trouble getting a
 loop to
run through and insert each name,age,gender combo as a new
 record in
the child table.

This is my attempt:

__
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, etc., with CF running under own user account

2002-04-09 Thread Dave Watts


 As a matter of general principle, is it acceptable or good 
 practice to set up ColdFusion server under its own account?

Yes, in general, it's a good practice to do this with any service or daemon
which allows it. This lets you limit the reach of that service, from a
security standpoint. The SYSTEM security context is extremely powerful
within Windows, and thus if your CF service is compromised (with a rogue CF
file, for example), that bad code will run as a local administrator,
essentially.
 
 We have a requirement to bring back lists of files from 
 folders on remote servers and then make links to the remote 
 files. To do this we need to run CF under its own account 
 instead of under the system account. Since this is our only 
 CF server, should we let the requirement to access remote
 folders/files drive the type of account under which CF runs?

I think you can actually do this without switching the CF account, but it's
been a while since I've tried to do that. I believe you can create a mapping
that will be available to the entire system by creating a persistent mapping
as a domain administrator. Of course, that has its own drawbacks.

So, yes, you should run CF as a user with the appropriate rights.
 
 Are there drawbacks to switching CF from running under a 
 system account to running under its own account? What would 
 you do?

Yes, there are drawbacks. The biggest one is simply getting everything to
work; by default, SYSTEM has the right permissions to touch all the files
and registry keys needed by CF. When you switch to another account, you have
to ensure that the new account has the necessary rights.

Beyond that, the drawbacks are minor. You can't use the CFIMPERSONATE tag,
for example, which requires that CF have the right to impersonate another
user (this is reserved for SYSTEM by default).

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: UDFDates and week numbers


look at the Week() in the studio documentation.

Anthony Petruzzi
Webmaster
954-321-4703
http://www.sheriff.org


-Original Message-
From: CF_JONNY [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 11:23 AM
To: CF-Talk
Subject: UDFDates and week numbers


Happy Tuesday!

I would like to automatically generate the weeks of the year as a number and
then have the date automatically come along with it.

Example:
1 - 12-31-01
2 - 01-07-02
3 - 01-14-02
4 - 01-21-02
52 - 12-

Is anyone aware of a UDF that can return such an animal?

Then, I would like to query those results and return a range of the current
week and two previous and two following.

Any Ideas would be great

JON



_

Do You Yahoo!?

Get your free @yahoo.com address at http://mail.yahoo.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: is this even possible?? Loop using lists?

2002-04-09 Thread Valerie L. Criswell

What is this bracket notation and where can I find more info?  It looks
mighty handy.

~Val

- Original Message -
From: Raymond Camden [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, April 09, 2002 12:00 PM
Subject: RE: is this even possible?? Loop using lists?

 Ack! Evaluate police!

 You do not need to use evaluate to get dynamic form names. Just use
 bracket notation.

 cfset thisName = form[name#i#]
 etc.

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

remove evaluate question...

2002-04-09 Thread Erik Retz


Hello,

Is it possible to change the syntax of the following code to remove the 
evaluate function? I can't seem to come up with the proper way.

cfscript
stPortal.name = Evaluate(server.#new_portal_id#.name);
stPortal.prename = Evaluate(server.#new_portal_id#.prename);
stPortal.postname = Evaluate(server.#new_portal_id#.postname);
stPortal.url = Evaluate(server.#new_portal_id#.url);
stPortal.state = Evaluate(server.#new_portal_id#.state);
stPortal.phone = Evaluate(server.#new_portal_id#.phone);
stPortal.defaultzip = Evaluate(server.#new_portal_id#.defaultzip);
/cfscript

Thanks,

-Erik

__
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: Big Record Set Return

2002-04-09 Thread Owens, Howard


Ah, an answer rather than a criticism ... thanks, Frank ... where can I find
info on this, especially any example of implementing within CF?

For the record, this is for an Intranet application and we'll train users
how to use the drop-down, which is very easy and fast to use, even with
7,000 records, once you know how to use it.  It's less time consuming than
sending users through multiple screens or other search mechinisms.  The
download takes about 3 seconds, but I would rather avoid the delay, if
possible.

H.


 -Original Message-
 From: Frank Mamone [SMTP:[EMAIL PROTECTED]]
 Sent: Tuesday, April 09, 2002 6:55 AM
 To:   CF-Talk
 Subject:  Re: Big Record Set Return
 
 If it's an IE only application you can use the ActiveX Combo box which is
 installed with IE.
 
 
 
 - Original Message -
 From: Garza, Jeff [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Tuesday, April 09, 2002 2:24 AM
 Subject: RE: Big Record Set Return
 
 
  What we did to limit the resultset was use an initial search page with
  wildcards and return the matching records in a paged format.  This
 worked
  really well and avoided the select scrolling issues that my users hated
 so
  much.  I try to Just Say No to dropdowns with more than 100 elements.
  Now, if there was a good combobox out there that actually worked like a
  combobox, I might rethink that number...
 
  Jeff
 
  -Original Message-
  From: Douglas Brown
  To: CF-Talk
  Sent: 4/8/02 11:17 PM
  Subject: Re: Big Record Set Return
 
  I would say so. I wouldnt even take the time to look through 500 items
  in a dropdown
  list.
 
 
  Success is a journey, not a destination!!
 
 
 
  Doug Brown
  - Original Message -
  From: Peter Tilbrook [EMAIL PROTECTED]
  To: CF-Talk [EMAIL PROTECTED]
  Sent: Monday, April 08, 2002 11:00 PM
  Subject: RE: Big Record Set Return
 
 
   You should really build some sort of previous/next functionality of
  say
   100 rows at a time - and perhaps a search feature also.
  
   -Original Message-
   From: Paul Hastings [mailto:[EMAIL PROTECTED]]
   Sent: Tuesday, 9 April 2002 3:28 PM
   To: CF-Talk
   Subject: Re: Big Record Set Return
  
  
I have a query that returns 7,300 records (just two columns, and
   eventually
but the output is slow.  The results are written to a drop down
  menu.  It
  
   rendering clientside will be a bear not to mention who's going to pull
   down a select of 7k rows? that will take patience of biblical
  proportions.
  
   i think you need a re-think.
  
  
  
 
  
 
__
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: remove evaluate question...

2002-04-09 Thread Bryan Love


you only really need one


cfscript
foo = Evaluate(server.#new_portal_id#);

stPortal.name = foo.name;
stPortal.prename = foo.prename;
stPortal.postname = foo.postname;
stPortal.url = foo.url;
etc
/cfscript

+---+
Bryan Love
  Macromedia Certified Professional
  Internet Application Developer
  Database Analyst
Telecommunication Systems
[EMAIL PROTECTED]
+---+

...'If there must be trouble, let it be in my day, that my child may have
peace'...
- Thomas Paine, The American Crisis



-Original Message-
From: Erik Retz [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 9:33 AM
To: CF-Talk
Subject: remove evaluate question...


Hello,

Is it possible to change the syntax of the following code to remove the 
evaluate function? I can't seem to come up with the proper way.

cfscript
stPortal.name = Evaluate(server.#new_portal_id#.name);
stPortal.prename = Evaluate(server.#new_portal_id#.prename);
stPortal.postname = Evaluate(server.#new_portal_id#.postname);
stPortal.url = Evaluate(server.#new_portal_id#.url);
stPortal.state = Evaluate(server.#new_portal_id#.state);
stPortal.phone = Evaluate(server.#new_portal_id#.phone);
stPortal.defaultzip = Evaluate(server.#new_portal_id#.defaultzip);
/cfscript

Thanks,

-Erik


__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.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: Access2000 file size limits?

2002-04-09 Thread Joseph Thompson


My 23MB Access2000 database is still holding up ok... it starts to choke
when more than 60 people at a time are browsing the site but is ok around
50..

.I know.. time to upgrade :-)


 Was wondering what file size limits Access2000 DB have?



__
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

NEO presentation?


Just wondering if anyone has a NEO presentation that they put together for a
user group that they wouldn't mind sharing. haven't had time to play with
NEO and would like to check out some of the features that people have played
with.

Anthony Petruzzi
Webmaster
954-321-4703
http://www.sheriff.org

__
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: Access2000 file size limits?


From Access 2000 help:

Max Database size: 2GB.

Anthony Petruzzi
Webmaster
954-321-4703
http://www.sheriff.org


-Original Message-
From: Joseph Thompson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 1:04 PM
To: CF-Talk
Subject: Re: Access2000 file size limits?


My 23MB Access2000 database is still holding up ok... it starts to choke
when more than 60 people at a time are browsing the site but is ok around
50..

I know.. time to upgrade :-)


 Was wondering what file size limits Access2000 DB have?




__
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: remove evaluate question...


 you only really need one


 cfscript
 foo = Evaluate(server.#new_portal_id#);

 stPortal.name = foo.name;
 stPortal.prename = foo.prename;
 stPortal.postname = foo.postname;
 stPortal.url = foo.url;
 etc
 /cfscript


Thought there might be a way to do this with no evaluates, but just tried it
and nope sorry doesn't work

Don't forget to put cflocks around your references to Server scope
variables.

Erk!  Just realised - I need to go cflock some of my server scope requests!!

Regards

Stephen


__
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: remove evaluate question...

2002-04-09 Thread Erik Retz


Yes,

I've been unable to get it to work either.  I've got everything 
cflocked already. Thanks.

-Erik


Stephen Moretti wrote:
you only really need one


cfscript
foo = Evaluate(server.#new_portal_id#);

stPortal.name = foo.name;
stPortal.prename = foo.prename;
stPortal.postname = foo.postname;
stPortal.url = foo.url;
etc
/cfscript

 
 Thought there might be a way to do this with no evaluates, but just tried it
 and nope sorry doesn't work
 
 Don't forget to put cflocks around your references to Server scope
 variables.
 
 Erk!  Just realised - I need to go cflock some of my server scope requests!!
 
 Regards
 
 Stephen
 
 
 
__
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: Access2000 file size limits?

2002-04-09 Thread Joel Blanchette


I think I saw something about 2 gigs.  400mb..that is nothing...I have a
database that is 908mb!!!

 
 
joel


-Original Message-
From: Jeff Green [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, April 09, 2002 9:57 AM
To: CF-Talk
Subject: RE: Access2000 file size limits?


hehehe,

Your gonna love this then :)

Im using Access for temp storage of some dynamically generated code, Im
approaching 400mb access .mdb file ;)

jeff

-Original Message-
From: Dan Phillips [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 7:36 AM
To: CF-Talk
Subject: RE: Access2000 file size limits?


None that I know of. However, if you are going to use them for web
development, don't go over 20MB, at least IMHO


Dan Phillips
CFXHosting.com

-Original Message-
From: Jeff Green [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 10:38 AM
To: CF-Talk
Subject: Access2000 file size limits?


Was wondering what file size limits Access2000 DB have?

TIA,
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: remove evaluate question...

2002-04-09 Thread Raymond Camden


Simple. Change your data. Instead of saving to server.#dynamic#, do:

cfset server.mydata = structNew()

Then save new_portal_id as a key to mydata. You can then get data using
normal bracket notation.

cfset name = server.mydata[new_portal_id].name

etc

If for some reason you can't, you could use one evaluate command to make
a copy of the structure instead. Or, even better, StructGet()

cfset server.foo = structnew()
cfset server.foo.name = ray
cfset key = foo
cfset ptr = structget(server.#key#)
cfdump var=#ptr#

===
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: Erik Retz [mailto:[EMAIL PROTECTED]] 
 Sent: Tuesday, April 09, 2002 12:33 PM
 To: CF-Talk
 Subject: remove evaluate question...
 
 
 Hello,
 
 Is it possible to change the syntax of the following code to 
 remove the 
 evaluate function? I can't seem to come up with the proper way.
 
 cfscript
 stPortal.name = Evaluate(server.#new_portal_id#.name);
 stPortal.prename = Evaluate(server.#new_portal_id#.prename);
 stPortal.postname = Evaluate(server.#new_portal_id#.postname);
 stPortal.url = Evaluate(server.#new_portal_id#.url);
 stPortal.state = Evaluate(server.#new_portal_id#.state);
 stPortal.phone = Evaluate(server.#new_portal_id#.phone);
 stPortal.defaultzip = Evaluate(server.#new_portal_id#.defaultzip);
 /cfscript
 
 Thanks,
 
 -Erik
 
 
__
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: Input parameters for stored procedures

2002-04-09 Thread Janine Jakim


Well I rechecked all my variable types-in the tables/queries/stored
procedure and the passing order, all seems ok (unless my eyes have gone
totally batty)
But the prob still seems to be only when I try to do a whole grade- it works
fine if I pick only the teacher.  
The only way I can seem to get it to work to get all by grade is by removing
the teacher link part from the page and stored procedure leaving my code to
look like this
CFPROCPARAM TYPE=IN DBVARNAME=@GRADE CFSQLTYPE=CF_SQL_VarChar
VALUE=#GRADE#
CFPROCPARAM TYPE=IN DBVARNAME=@TCHRLINK CFSQLTYPE=CF_SQL_INTEGER
VALUE=#TCHRLINK#
CFPROCRESULT NAME=StudentPrint
/CFSTOREDPROC

Is there any other place I should look?


-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 11:48 AM
To: CF-Talk
Subject: RE: Input parameters for stored procedures


Are the order of your params in the SP the same order as you are passing
them in?  i.e. grade then thcrlink, then studentid?they need to be.
Also double check that the datatypes of the variables in the SP are the same
as the datatypes in the procparam tag.  Finally ensure that the data being
passed in is of the datatype that you have specified

-Original Message-
From: Janine Jakim [mailto:[EMAIL PROTECTED]]
Sent: 09 April 2002 16:37
To: CF-Talk
Subject: Input parameters for stored procedures


I have a stored procedure set that gives info for an entire grade or just
one class depending on what the user chooses (by way of select boxes).
But I can't seem to get the cfprocparam correct- When I try to pull by grade
only I keep getting the error 

ODBC Error Code = 22005 (Error in assignment)
[Microsoft][ODBC SQL Server Driver]Invalid character value for cast
specification
SQL = sproc_GetStudents

This is how I'm calling the sp
CFSTOREDPROC PROCEDURE= sproc_GetStudents DATASOURCE=#Request.dsn#

CFPROCPARAM TYPE=IN DBVARNAME=@GRADE CFSQLTYPE=CF_SQL_VarChar
VALUE=#GRADE#
CFPROCPARAM TYPE=IN DBVARNAME=@TCHRLINK CFSQLTYPE=CF_SQL_INTEGER
VALUE=#TCHRLINK#
CFPROCPARAM TYPE=OUT DBVARNAME=@STUDENTID CFSQLTYPE=CF_SQL_VarChar
VARIABLE=STUDENTID
CFPROCRESULT NAME=StudentPrint
/CFSTOREDPROC

I added Null=yes but then just received a blank screen back. 
Thanks for any help


__
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: is this even possible?? Loop using lists?

2002-04-09 Thread Raymond Camden


Not sure where it is in the docs - maybe in the same area that describes
structures in general?

Basically, if the name of the key is hard coded, and does not contain a
space, you can use dot noation.

cfoutput#person.age#/cfoutput

If the key is dynamic, you must use bracket notation.

cfset key = age
cfoutput#person[key]#/cfoutput

Or, if the key contains a space, use bracket notation:

cfoutput#person[last name]#/cfoutput

PS

Did you know if you do this in CF:

cfset x.y = 1

WITHOUT first doing:

cfset x = structNew()

that you have actually created a variable named x.y instead of a
structure? 

===
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: Valerie L. Criswell [mailto:[EMAIL PROTECTED]] 
 Sent: Tuesday, April 09, 2002 12:27 PM
 To: CF-Talk
 Subject: Re: is this even possible?? Loop using lists?
 
 
 What is this bracket notation and where can I find more info? 
  It looks
 mighty handy.
 
 ~Val
 
 - Original Message -
 From: Raymond Camden [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Tuesday, April 09, 2002 12:00 PM
 Subject: RE: is this even possible?? Loop using lists?
 
 
  Ack! Evaluate police!
 
  You do not need to use evaluate to get dynamic form names. Just use
  bracket notation.
 
  cfset thisName = form[name#i#]
  etc.
 
 
 
 
__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Input parameters for stored procedures