date:20010313

insteadof using a list, dynamically name your input forms, then in your
cfoutput, u can output those forms.

like #Form.Question1# #Form.Remark1#
#Form.Question1# #Form.Remark1#

- Original Message -
From: han peng [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, March 13, 2001 4:32 AM
Subject: cfloop for 2 list?!!!

 hi.. i hav a prob. here. i hav a tool to key in remarks for mulitple
users.
 Eg. Page1.cfm

  form action="page2.cfm" method="post"
   cfloop query="part_info"
 textarea cols="20" rows="2"
name="p_arrival_remarks"#p_arrival_remarks#/textarea
 input type="hidden" name="p_username" value="#part_info.p_username#"
   /cfloop
  input type="submit" value="Submit" 
 /form

 So in page2.cfm...
 how can i insert the remarks into the database using the respective
username.??

 i cant use cfloop INDEX="test" LIST="??!!"
 as it can only use for 1 list...

 another prob.. i try CFOUTPUT the 2 list...
#p_username#,#p_arrival_remarks#
 and notice that if theres no input for remarks.. both list length doesnt
match..

 any advice how i shld go abt doing it?!!

 thanx in advance,
 han

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

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

RE: cfloop for 2 list?!!!


For inserting the remarks into the DB simply 
suffix your textarea variable with the ID number
or some unique value that would indicate the 
record they are putting the remarks to.

Example:


-Original Message-
From: han peng [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 5:32 AM
To: CF-Talk
Subject: cfloop for 2 list?!!!

form action="page2.cfm" method="post" 
  cfloop query="part_info" 
textarea cols="20" rows="2"
name="p_arrival_remarks"#p_arrival_remarks#/textarea
input type="hidden" name="p_username" value="#part_info.p_username#"
input type="hidden" name="ID" value="#part_info.part_info_ID#"
   /cfloop
 input type="submit" value="Submit" 
/form  

ON PAGE2.CFM
IF INSERTING INTO A NEW TABLE:
cfquery name=insremarks datasource=blahblahblah
insert into remarksTable(remark_id,Username,remarks)
values(#form.ID#,'#form.p_username#','#form.p_arrivale_remarks#')
/cfquery

IF UPDATING THE TABLE WITH THE REMARKS
cfquery name=updateremarks datasource=blahblahblah
UPDATE remarksTable
Set Remarks = '#form.P-arrival_remarks#'
Where Part_info_ID = #form.ID#
/cfquery

This UPDATE is assuming you have a UNIQUE Identifier within
the table. Else you will have to determine the unique record by some 
means of combining fields.




hi.. i hav a prob. here. i hav a tool to key in remarks for mulitple users. 
Eg. Page1.cfm

 form action="page2.cfm" method="post" 
  cfloop query="part_info" 
textarea cols="20" rows="2"
name="p_arrival_remarks"#p_arrival_remarks#/textarea
input type="hidden" name="p_username" value="#part_info.p_username#"
  /cfloop
 input type="submit" value="Submit" 
/form  

So in page2.cfm...
how can i insert the remarks into the database using the respective
username.??

i cant use cfloop INDEX="test" LIST="??!!" 
as it can only use for 1 list...

another prob.. i try CFOUTPUT the 2 list... #p_username#,#p_arrival_remarks#
and notice that if theres no input for remarks.. both list length doesnt
match.. 

any advice how i shld go abt doing it?!!

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

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

RE: Can CF work with a FileMakerPro database?


If you decide to take the project and the database is
going to be access by the Internet public, make sure its the FM Pro 5
Unlimited version. The standard FM Pro 5 has a '10 IPs per 12 hour' limit.

Surely if it was being accessed through CF it would only be via one IP - The
IP of the CF-Server machine...

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

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

RE: Advanced Security

2001-03-13 Thread Steve Drucker


The procedure is that you would create a set of UserObject rules within the
security context, assign users/groups access rights to the userObject rule,
and within your application check to see if the user has permission using
the isAuthorized() function.

Regards,
Steve Drucker
CEO
Fig Leaf Software
http://www.figleaf.com


-Original Message-
From: Heidi Belal [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 3:27 AM
To: CF-Talk
Subject: Re: Advanced Security


Hi!
Have you found a solution? Cause i need to do
something similar!
I have people logging in.  So what i thought i'd do
was divide the people to groups according to their
level of access.  Then check on each page before
displaying it if they are one of those that are
allowed access to that page or not.
what do you think?!
Heidi

--- Vance Duke [EMAIL PROTECTED] wrote:
 I have a Security context with all Domain Users
 allowed the access the
 application.  No problem there.  NOW, I want to
 limit a part of the
 application to just a certain subset of domain users
 setup in a User Group.
 Those users would have access to the main part of
 the application, but also
 need access to the HR functions.  Do I need to set
 up another security context and Authorize them
 against that context also (in
 other words, 2 CFAuthenticate statements)?  Or how
 would I do that?  How do
 I know that they are part of that User Group when
 they log in?
 
 Thanks for the help,
 Vance Duke
 
 
 

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

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

RE: Responding to Post's

2001-03-13 Thread Arden Weiss


Okay, tell me more -- what are you talking about -- what is "the appropriate post 
note" -- I don't have an "any key" either.

 ^
/ \__
   (@\___
  /  O
 /(_/
/_/
Whoof...
410-757-3487

-Original Message-
From:   Michael [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, March 13, 2001 6:28 AM
To: CF-Talk
Subject:OT: Responding to Post's

Why cant people respond to the post in the appropriate post note and not mix
match things, ??

Just a question, not trying to start a flame war or something, just seems
that lately alot of this is happening, then again maybe its just me.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: Project Mgmt for CF development?

2001-03-13 Thread Jeff Gombala


You also have to remember that this information is vital in planning a
production schedule for a company.  Just imagine what it would be like to
schedule 5 projects between 7 developers over a period of 2 months without
any idea how long it takes for the developers to complete something.  It
lets team leads and/or Directors schedule projects based off of historical
data.  All in all the more you keep track or your time the more you forget
you are doing it the future, and the data that you are collecting is
invaluable to a Web Application Development company.  Especially for
budgeting, bidding, and scheduling.

just my .02

Jeff Gombala

- Original Message -
From: "Andy Ewings" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, March 13, 2001 6:11 AM
Subject: RE: Project Mgmt for CF development?


 Michael

 You're not missing the boat at all!  Exactly what we've done.  Our
 Intranet/extranet contains a timesheet and a scheduler.  Project managers
 within the company create and manage projects using the scheduler by
 specifying start date and deadline of projects.  The scheduler then
 calculates the deadlines for various stages of the project (Outline,
Design
 Development, etc)  Tasks can then be assigned in each stage to various
 staff.  Each staff member fills in a timesheet at the end of the weeek.
The
 combination of these 2 components allows us to produce stats telling us
how
 much time we are spending on projects compared with how much time we
 allocated for them.  Also how well deadlines get met and it also helps to
 manage people's workload.  All this was written in house using CF.  We
felt
 that something like MS Project was too restrictive and needed something
more
 tailored to the way we operate.

 A

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



 -Original Message-
 From: BORKMAN Lee [mailto:[EMAIL PROTECTED]]
 Sent: 13 March 2001 05:17
 To: CF-Talk
 Subject: RE: Project Mgmt for CF development?


 Yeah, we did that here, and next month we are rolling out an application
 that lets people send electronic letters to each other.  You should see
it!
 Very impressive considering our core business is building roads.

 All in all, I'd recommend your philosophy as a great approach to problem
 solving;-)

 LBB.

 -Original Message-
 From: Michael [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, March 13, 2001 10:55 AM
 To: CF-Talk
 Subject: Re: Project Mgmt for CF development?


 Why not just write and in house program that will do all of what you want,
 and then alot more?

 Or am I missing the boat here?



 IMPORTANT NOTICE:
 This e-mail and any attachment to it is intended only to be read or used
by
 the named addressee.  It is confidential and may contain legally
privileged
 information.  No confidentiality or privilege is waived or lost by any
 mistaken transmission to you.  If you receive this e-mail in error, please
 immediately delete it from your system and notify the sender.  You must
not
 disclose, copy or use any part of this e-mail if you are not the intended
 recipient.  The RTA is not responsible for any unauthorised alterations to
 this e-mail or attachment to it.

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

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

nesting queries


I have 3 queries.  But when i try to nest the cfoutput tags i get an error
that says this in to allowed.  
how do you use the cfoutput tags to output your information if the data to
your second and third query is dependent upon the info from the first?  
here are my first 2 queries.
!--- Query to get all User's info. ---
cfquery name="qryAllEmp" datasource="ITData"
SELECT * FROM tblEmployees
WHERE   
tblEmployees.FName LIKE '#fname#%'
AND tblEmployees.LName LIKE '#lname#%'
cfif office eq "All Offices"
AND tblEmployees.Office LIKE '%'
cfelse
AND tblEmployees.Office LIKE '#office#%'
/cfif  
ORDER BY tblEmployees.lname
/cfquery
!--- Query to get the users Equipment info. Setting iEquipID eq the
previous query's results. ---
cfset iEquipID = qryAllEmp.EmpID
cfquery name="qryEquipment" datasource="ITData"
SELECT * from tblEquipment
WHERE EquipID = #iEquipID#
/cfquery 
I want to be able to have one table that i can put the information all
together.  any ideas?


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



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

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

RE: nesting queries


You can place a CFOUTPUT at the very top
of the Queries and instead of using CFOUTPUT QUERY,
use a CFLOOP Query just make sure when you are
outputing the query results you use the prefix
for the given query

Example:

CFOUPUT

CFLOOP QUERY=Query1
#Query1.MYFIELD#
CFLOOP Query=Query2
#Query2.MyField#
CFLOOP Query=Query3
#Query3.MyField#


Also make sure you close the loops when needed
to reduce the looping through unneeded records.

HTH


-Original Message-
From: Jones, Becky [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 8:58 AM
To: CF-Talk
Subject: nesting queries


I have 3 queries.  But when i try to nest the cfoutput tags i get an error
that says this in to allowed.  
how do you use the cfoutput tags to output your information if the data to
your second and third query is dependent upon the info from the first?  
here are my first 2 queries.
!--- Query to get all User's info. ---
cfquery name="qryAllEmp" datasource="ITData"
SELECT * FROM tblEmployees
WHERE   
tblEmployees.FName LIKE '#fname#%'
AND tblEmployees.LName LIKE '#lname#%'
cfif office eq "All Offices"
AND tblEmployees.Office LIKE '%'
cfelse
AND tblEmployees.Office LIKE '#office#%'
/cfif  
ORDER BY tblEmployees.lname
/cfquery
!--- Query to get the users Equipment info. Setting iEquipID eq the
previous query's results. ---
cfset iEquipID = qryAllEmp.EmpID
cfquery name="qryEquipment" datasource="ITData"
SELECT * from tblEquipment
WHERE EquipID = #iEquipID#
/cfquery 
I want to be able to have one table that i can put the information all
together.  any ideas?


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

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

Re: Responding to Post's

2001-03-13 Thread Michael


All I am saying is if responding to a message respond to the message in that
message's header, like this one
"Arden Weiss" [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
 Okay, tell me more -- what are you talking about -- what is "the
appropriate post note" -- I don't have an "any key" either.

  ^
 / \__
(@\___
   /  O
  /(_/
 /_/
 Whoof...
 410-757-3487

 -Original Message-
 From: Michael [SMTP:[EMAIL PROTECTED]]
 Sent: Tuesday, March 13, 2001 6:28 AM
 To: CF-Talk
 Subject: OT: Responding to Post's

 Why cant people respond to the post in the appropriate post note and not
mix
 match things, ??

 Just a question, not trying to start a flame war or something, just seems
 that lately alot of this is happening, then again maybe its just me.

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

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

Re: nesting queries


it's a matter of how u do your query.  in this case, u do one query, and use
agreggratataacrap functions.  sorry i have stutter problems.  the thing is,
u have to call out every column individually, instead of using the asterisk
*.  here is an example.  notice i am using aliases

CFQUERY name="snifflebutt" DATASOURCE="ITDATA"
SELECT a.EMPID, a.LName, a.FName, a.Office, a.address, b.EquipID,
b.description, b.callnumber
FROM tblEmployess a, tblEquipment b
WHERE
a.FName LIKE '#fname#%'
AND a.LName LIKE '#lname#%'
cfif office eq "All Offices"
AND a.Office LIKE '%'
cfelse
AND a.Office LIKE '#office#%'
/cfif
AND a.EMPID = b.EquipID
ORDER BY a.lname
/CFQUERY


just try something like that,adn u can output all that information in one
cfoutput


- Original Message -
From: Jones, Becky [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, March 13, 2001 7:57 AM
Subject: nesting queries


 I have 3 queries.  But when i try to nest the cfoutput tags i get an error
 that says this in to allowed.
 how do you use the cfoutput tags to output your information if the data to
 your second and third query is dependent upon the info from the first?
 here are my first 2 queries.
 !--- Query to get all User's info. ---
 cfquery name="qryAllEmp" datasource="ITData"
 SELECT * FROM tblEmployees
 WHERE
   tblEmployees.FName LIKE '#fname#%'
 AND tblEmployees.LName LIKE '#lname#%'
 cfif office eq "All Offices"
 AND tblEmployees.Office LIKE '%'
 cfelse
 AND tblEmployees.Office LIKE '#office#%'
 /cfif
 ORDER BY tblEmployees.lname
 /cfquery
 !--- Query to get the users Equipment info. Setting iEquipID eq the
 previous query's results. ---
 cfset iEquipID = qryAllEmp.EmpID
 cfquery name="qryEquipment" datasource="ITData"
 SELECT * from tblEquipment
 WHERE EquipID = #iEquipID#
 /cfquery
 I want to be able to have one table that i can put the information all
 together.  any ideas?


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




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

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

Re: Advanced Security

2001-03-13 Thread Vance Duke

Thanks Steve.  That helped immensely.  And that it worked and pointed me in
the right direction.

Thanks,
Vance Duke

- Original Message -
From: "Steve Drucker" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, March 13, 2001 7:34 AM
Subject: RE: Advanced Security

 The procedure is that you would create a set of UserObject rules within
the
 security context, assign users/groups access rights to the userObject
rule,
 and within your application check to see if the user has permission using
 the isAuthorized() function.

 Regards,
 Steve Drucker
 CEO
 Fig Leaf Software
 http://www.figleaf.com

 -Original Message-
 From: Heidi Belal [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, March 13, 2001 3:27 AM
 To: CF-Talk
 Subject: Re: Advanced Security

 Hi!
 Have you found a solution? Cause i need to do
 something similar!
 I have people logging in.  So what i thought i'd do
 was divide the people to groups according to their
 level of access.  Then check on each page before
 displaying it if they are one of those that are
 allowed access to that page or not.
 what do you think?!
 Heidi

 --- Vance Duke [EMAIL PROTECTED] wrote:
  I have a Security context with all Domain Users
  allowed the access the
  application.  No problem there.  NOW, I want to
  limit a part of the
  application to just a certain subset of domain users
  setup in a User Group.
  Those users would have access to the main part of
  the application, but also
  need access to the HR functions.  Do I need to set
  up another security context and Authorize them
  against that context also (in
  other words, 2 CFAuthenticate statements)?  Or how
  would I do that?  How do
  I know that they are part of that User Group when
  they log in?

  Thanks for the help,
  Vance Duke

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

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

RE: Any recommendations on an E-commerce software?

2001-03-13 Thread paul smith


Which is?  All I could find is:

"Actinic e-store solutions begin at less than $500."

which suggests the price is $495 per store.  Which is fine.
I just find it annoying to find it hard to find the price.

best,  paul

At 10:07 AM 3/13/01 +, you wrote:
I'll second this one. It really is awesome for the price.


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

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

SNMP and CF

2001-03-13 Thread Lewis Steven


Is there a way to monitor CF using SNMP right now?

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

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

RE: Project Mgmt for CF development?

Some one who has access to a Polling System... if you would I would like
to see how many people use a project mgmt system and which ones... 

HOWEVER   Let's not all respond to the list... in fact if you want 

Respond to me and I will add up the responses.

To: [EMAIL PROTECTED]
Subject: Project Mgmt System Poll

After I get 100+ responses I will send out a results...  or if the responses
quit coming in.

 -Original Message-
 From: Jeff Gombala [SMTP:[EMAIL PROTECTED]]
 Sent: Tuesday, March 13, 2001 7:52 AM
 To:   CF-Talk
 Subject:  Re: Project Mgmt for CF development?

 You also have to remember that this information is vital in planning a
 production schedule for a company.  Just imagine what it would be like to
 schedule 5 projects between 7 developers over a period of 2 months without
 any idea how long it takes for the developers to complete something.  It
 lets team leads and/or Directors schedule projects based off of historical
 data.  All in all the more you keep track or your time the more you forget
 you are doing it the future, and the data that you are collecting is
 invaluable to a Web Application Development company.  Especially for
 budgeting, bidding, and scheduling.

 just my .02

 Jeff Gombala

 - Original Message -
 From: "Andy Ewings" [EMAIL PROTECTED]
 To: "CF-Talk" [EMAIL PROTECTED]
 Sent: Tuesday, March 13, 2001 6:11 AM
 Subject: RE: Project Mgmt for CF development?

  Michael

  You're not missing the boat at all!  Exactly what we've done.  Our
  Intranet/extranet contains a timesheet and a scheduler.  Project
 managers
  within the company create and manage projects using the scheduler by
  specifying start date and deadline of projects.  The scheduler then
  calculates the deadlines for various stages of the project (Outline,
 Design
  Development, etc)  Tasks can then be assigned in each stage to
 various
  staff.  Each staff member fills in a timesheet at the end of the weeek.
 The
  combination of these 2 components allows us to produce stats telling us
 how
  much time we are spending on projects compared with how much time we
  allocated for them.  Also how well deadlines get met and it also helps
 to
  manage people's workload.  All this was written in house using CF.  We
 felt
  that something like MS Project was too restrictive and needed something
 more
  tailored to the way we operate.

  A

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

  -Original Message-
  From: BORKMAN Lee [mailto:[EMAIL PROTECTED]]
  Sent: 13 March 2001 05:17
  To: CF-Talk
  Subject: RE: Project Mgmt for CF development?

  Yeah, we did that here, and next month we are rolling out an application
  that lets people send electronic letters to each other.  You should see
 it!
  Very impressive considering our core business is building roads.

  All in all, I'd recommend your philosophy as a great approach to problem
  solving;-)

  LBB.

  -Original Message-
  From: Michael [mailto:[EMAIL PROTECTED]]
  Sent: Tuesday, March 13, 2001 10:55 AM
  To: CF-Talk
  Subject: Re: Project Mgmt for CF development?

  Why not just write and in house program that will do all of what you
 want,
  and then alot more?

  Or am I missing the boat here?

  IMPORTANT NOTICE:
  This e-mail and any attachment to it is intended only to be read or used
 by
  the named addressee.  It is confidential and may contain legally
 privileged
  information.  No confidentiality or privilege is waived or lost by any
  mistaken transmission to you.  If you receive this e-mail in error,
 please
  immediately delete it from your system and notify the sender.  You must
 not
  disclose, copy or use any part of this e-mail if you are not the
 intended
  recipient.  The RTA is not responsible for any unauthorised alterations
 to
  this e-mail or attachment to it.

~~

RE: nesting queries


i tried that and i only get results from the first query...
cfoutput
cfloop query="qryAllEmp"
tr
td colspan="2" bgcolor="E0" b#qryAllEmp.FName#
#strSpace# #qryAllEmp.MI#   #StrSpace#
#qryAllEmp.LName#/b  br
#qryAllEmp.Dept#
/td
/tr
tr
td colspan="2" bgcolor="E0"br/td
/tr
tr
td colspan="2" bgcolor="E0" 

#qryAllEmp.Office#br#qryAllEmp.Floor#br#qryAllEmp.Phone#
/td
/tr
tr
td colspan="2" bgcolor="E0"br /td
/tr
!--- Variable to output Label Equipment once. ---
cfset iEqcnt = 1
cfloop query="qryEquipment"
tr
td width="10%" bgcolor="E0"
cfif iEqcnt eq 1b Equipment: /b cfset
iEqcnt=0 /cfif 
/td   
td bgcolor="E0"#qryEquipment.Description#/td
/tr
/cfloop 
/cfloop
/cfoutput

-Original Message-
From: Adkins, Randy [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 8:58 AM
To: CF-Talk
Subject: RE: nesting queries


You can place a CFOUTPUT at the very top
of the Queries and instead of using CFOUTPUT QUERY,
use a CFLOOP Query just make sure when you are
outputing the query results you use the prefix
for the given query

Example:

CFOUPUT

CFLOOP QUERY=Query1
#Query1.MYFIELD#
CFLOOP Query=Query2
#Query2.MyField#
CFLOOP Query=Query3
#Query3.MyField#


Also make sure you close the loops when needed
to reduce the looping through unneeded records.

HTH


-Original Message-
From: Jones, Becky [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 8:58 AM
To: CF-Talk
Subject: nesting queries


I have 3 queries.  But when i try to nest the cfoutput tags i get an error
that says this in to allowed.  
how do you use the cfoutput tags to output your information if the data to
your second and third query is dependent upon the info from the first?  
here are my first 2 queries.
!--- Query to get all User's info. ---
cfquery name="qryAllEmp" datasource="ITData"
SELECT * FROM tblEmployees
WHERE   
tblEmployees.FName LIKE '#fname#%'
AND tblEmployees.LName LIKE '#lname#%'
cfif office eq "All Offices"
AND tblEmployees.Office LIKE '%'
cfelse
AND tblEmployees.Office LIKE '#office#%'
/cfif  
ORDER BY tblEmployees.lname
/cfquery
!--- Query to get the users Equipment info. Setting iEquipID eq the
previous query's results. ---
cfset iEquipID = qryAllEmp.EmpID
cfquery name="qryEquipment" datasource="ITData"
SELECT * from tblEquipment
WHERE EquipID = #iEquipID#
/cfquery 
I want to be able to have one table that i can put the information all
together.  any ideas?


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

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

faulty join?

2001-03-13 Thread megan sherman


Hi,
I'm trying to display (kayak) class information on a web page. I have 3
tables, one for class description (primary key "classID"), one for class
prerequisites (primary key "prereqID"), and one for class schedule
(primary key "scheduleID"). I have slimmed down the query and the output
below. It only sorta works. I get a single output of the description,
and a single output of the location/date (no repeats), but something
goes wrong with the prereq's. If there is class with three
prerequisites, say #1 #2 and #5, then the output loop for that class
yields #5 #1 #2, #1 #2 #5,  and #1 #5 #2. I only want the list of
prerequisites to show up once. I've tried a bunch of stuff, but I'm
obviously just guessing. Does anybody have a suggestion toward what I'm
doing wrong?
Thanks in advance,
Megan

SELECT class.classID, class.content, class_schedule.scheduleID,
class_schedule.location, class_schedule.date, class_prereq.prereqID,
class_prereq.prereq
 FROM class, class_schedule, class_prereq
 WHERE (pagename = 'classes_sea' and
class.classID=class_schedule.classID and
class_prereq.classID=class.classID)
 ORDER by rank, class_schedule.location, class_schedule.date

CFOUTPUT QUERY="content" group="classID"
p
class:br /
#content#br /
cfoutput group="prereqID"#prereq# br //cfoutput
cfoutput group="scheduleID"#location#, #date# br //cfoutput
/p
/CFOUTPUT


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

RE: nesting queries

Then it is possible that the 2nd Query returns no records, 

Can you show me both queries

-Original Message-
From: Jones, Becky [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 9:45 AM
To: CF-Talk
Subject: RE: nesting queries

i tried that and i only get results from the first query...
cfoutput
cfloop query="qryAllEmp"
tr
td colspan="2" bgcolor="E0" b#qryAllEmp.FName#
#strSpace# #qryAllEmp.MI#   #StrSpace#
#qryAllEmp.LName#/b  br
#qryAllEmp.Dept#
/td
/tr
tr
td colspan="2" bgcolor="E0"br/td
/tr
tr
td colspan="2" bgcolor="E0" 

#qryAllEmp.Office#br#qryAllEmp.Floor#br#qryAllEmp.Phone#
/td
/tr
tr
td colspan="2" bgcolor="E0"br /td
/tr
!--- Variable to output Label Equipment once. ---
cfset iEqcnt = 1
cfloop query="qryEquipment"
tr
td width="10%" bgcolor="E0"
cfif iEqcnt eq 1b Equipment: /b cfset
iEqcnt=0 /cfif 
/td   
td bgcolor="E0"#qryEquipment.Description#/td
/tr
/cfloop 
/cfloop
/cfoutput

-Original Message-
From: Adkins, Randy [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 8:58 AM
To: CF-Talk
Subject: RE: nesting queries

You can place a CFOUTPUT at the very top
of the Queries and instead of using CFOUTPUT QUERY,
use a CFLOOP Query just make sure when you are
outputing the query results you use the prefix
for the given query

Example:

CFOUPUT

CFLOOP QUERY=Query1
#Query1.MYFIELD#
CFLOOP Query=Query2
#Query2.MyField#
CFLOOP Query=Query3
#Query3.MyField#

Also make sure you close the loops when needed
to reduce the looping through unneeded records.

HTH

-Original Message-
From: Jones, Becky [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 8:58 AM
To: CF-Talk
Subject: nesting queries

I have 3 queries.  But when i try to nest the cfoutput tags i get an error
that says this in to allowed.  
how do you use the cfoutput tags to output your information if the data to
your second and third query is dependent upon the info from the first?  
here are my first 2 queries.
!--- Query to get all User's info. ---
cfquery name="qryAllEmp" datasource="ITData"
SELECT * FROM tblEmployees
WHERE   
tblEmployees.FName LIKE '#fname#%'
AND tblEmployees.LName LIKE '#lname#%'
cfif office eq "All Offices"
AND tblEmployees.Office LIKE '%'
cfelse
AND tblEmployees.Office LIKE '#office#%'
/cfif  
ORDER BY tblEmployees.lname
/cfquery
!--- Query to get the users Equipment info. Setting iEquipID eq the
previous query's results. ---
cfset iEquipID = qryAllEmp.EmpID
cfquery name="qryEquipment" datasource="ITData"
SELECT * from tblEquipment
WHERE EquipID = #iEquipID#
/cfquery 
I want to be able to have one table that i can put the information all
together.  any ideas?

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

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

RE: nesting queries


sure,
i checked the database for one specific person that i know has information
in the equipment table so the info is there..i just cant get it out! :) 
qry one:
cfquery name="qryAllEmp" datasource="ITData"
SELECT * FROM tblEmployees
WHERE   
tblEmployees.FName LIKE '#fname#%'
AND tblEmployees.LName LIKE '#lname#%'
cfif office eq "All Offices"
AND tblEmployees.Office LIKE '%'
cfelse
AND tblEmployees.Office LIKE '#office#%'
/cfif  
ORDER BY tblEmployees.lname
/cfquery
qry two:
!--- Query to get the users Equipment info. Setting iEquipID eq the
previous
query's results. ---
cfset iEquipID = qryAllEmp.EmpID
cfquery name="qryEquipment" datasource="ITData"
SELECT * from tblEquipment
WHERE EquipID = #iEquipID#
/cfquery 

-Original Message-
From: Adkins, Randy [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 9:49 AM
To: CF-Talk
Subject: RE: nesting queries


Then it is possible that the 2nd Query returns no records, 

Can you show me both queries


-Original Message-
From: Jones, Becky [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 9:45 AM
To: CF-Talk
Subject: RE: nesting queries


i tried that and i only get results from the first query...
cfoutput
cfloop query="qryAllEmp"
tr
td colspan="2" bgcolor="E0" b#qryAllEmp.FName#
#strSpace# #qryAllEmp.MI#   #StrSpace#
#qryAllEmp.LName#/b  br
#qryAllEmp.Dept#
/td
/tr
tr
td colspan="2" bgcolor="E0"br/td
/tr
tr
td colspan="2" bgcolor="E0" 

#qryAllEmp.Office#br#qryAllEmp.Floor#br#qryAllEmp.Phone#
/td
/tr
tr
td colspan="2" bgcolor="E0"br /td
/tr
!--- Variable to output Label Equipment once. ---
cfset iEqcnt = 1
cfloop query="qryEquipment"
tr
td width="10%" bgcolor="E0"
cfif iEqcnt eq 1b Equipment: /b cfset
iEqcnt=0 /cfif 
/td   
td bgcolor="E0"#qryEquipment.Description#/td
/tr
/cfloop 
/cfloop
/cfoutput

-Original Message-
From: Adkins, Randy [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 8:58 AM
To: CF-Talk
Subject: RE: nesting queries


You can place a CFOUTPUT at the very top
of the Queries and instead of using CFOUTPUT QUERY,
use a CFLOOP Query just make sure when you are
outputing the query results you use the prefix
for the given query

Example:

CFOUPUT

CFLOOP QUERY=Query1
#Query1.MYFIELD#
CFLOOP Query=Query2
#Query2.MyField#
CFLOOP Query=Query3
#Query3.MyField#


Also make sure you close the loops when needed
to reduce the looping through unneeded records.

HTH


-Original Message-
From: Jones, Becky [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 8:58 AM
To: CF-Talk
Subject: nesting queries


I have 3 queries.  But when i try to nest the cfoutput tags i get an error
that says this in to allowed.  
how do you use the cfoutput tags to output your information if the data to
your second and third query is dependent upon the info from the first?  
here are my first 2 queries.
!--- Query to get all User's info. ---
cfquery name="qryAllEmp" datasource="ITData"
SELECT * FROM tblEmployees
WHERE   
tblEmployees.FName LIKE '#fname#%'
AND tblEmployees.LName LIKE '#lname#%'
cfif office eq "All Offices"
AND tblEmployees.Office LIKE '%'
cfelse
AND tblEmployees.Office LIKE '#office#%'
/cfif  
ORDER BY tblEmployees.lname
/cfquery
!--- Query to get the users Equipment info. Setting iEquipID eq the
previous query's results. ---
cfset iEquipID = qryAllEmp.EmpID
cfquery name="qryEquipment" datasource="ITData"
SELECT * from tblEquipment
WHERE EquipID = #iEquipID#
/cfquery 
I want to be able to have one table that i can put the information all
together.  any ideas?


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

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

RE: faulty join?

2001-03-13 Thread Hayes, David


Hi, Megan

You will get the prereq list for each distinct schedule date for the class;
I'm assuming your query is returning 3 dates for the class.

Dave

-Original Message-
From: megan sherman [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 9:02 AM
To: CF-Talk
Subject: faulty join?


Hi,
I'm trying to display (kayak) class information on a web page. I have 3
tables, one for class description (primary key "classID"), one for class
prerequisites (primary key "prereqID"), and one for class schedule
(primary key "scheduleID"). I have slimmed down the query and the output
below. It only sorta works. I get a single output of the description,
and a single output of the location/date (no repeats), but something
goes wrong with the prereq's. If there is class with three
prerequisites, say #1 #2 and #5, then the output loop for that class
yields #5 #1 #2, #1 #2 #5,  and #1 #5 #2. I only want the list of
prerequisites to show up once. I've tried a bunch of stuff, but I'm
obviously just guessing. Does anybody have a suggestion toward what I'm
doing wrong?
Thanks in advance,
Megan

SELECT class.classID, class.content, class_schedule.scheduleID,
class_schedule.location, class_schedule.date, class_prereq.prereqID,
class_prereq.prereq
 FROM class, class_schedule, class_prereq
 WHERE (pagename = 'classes_sea' and
class.classID=class_schedule.classID and
class_prereq.classID=class.classID)
 ORDER by rank, class_schedule.location, class_schedule.date

CFOUTPUT QUERY="content" group="classID"
p
class:br /
#content#br /
cfoutput group="prereqID"#prereq# br //cfoutput
cfoutput group="scheduleID"#location#, #date# br //cfoutput
/p
/CFOUTPUT


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

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

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

RE: nesting queries


Considering that do a simple join on the two tables
to obtain results in one recordset.

Thus:
One Query: cfouput query=qyrAllEmp
All variables would be: qryAllEmp.fieldnames

Then you only need one CFOUTPUT and No CFLOOPS
Also considering that within the Equipment table that 
EquipID is actually the Employee ID from the Employee Table.

By what you showed in this statement is is.
cfset iEquipID = qryAllEmp.EmpID

Somewhat odd, I would think that the EquipID would be
the indtifier for the Equipment not the employee.


cfquery name="qryAllEmp" datasource="ITData"
SELECT
tblEmployees.FieldOne,tblEmployees.FieldTwo,tblEquipment.Description
FROM tblEmployees, tblEquipment
WHERE   
tblEmployees.FName LIKE '#fname#%'
AND tblEmployees.LName LIKE '#lname#%'
cfif office eq "All Offices"
AND tblEmployees.Office LIKE '%'
cfelse
AND tblEmployees.Office LIKE '#office#%'
/cfif
AND tblEmployees.EMPID = tblEquipment.EquipID
ORDER BY tblEmployees.lname
/cfquery

-Original Message-
From: Jones, Becky [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 10:01 AM
To: CF-Talk
Subject: RE: nesting queries


sure,
i checked the database for one specific person that i know has information
in the equipment table so the info is there..i just cant get it out! :) 
qry one:
cfquery name="qryAllEmp" datasource="ITData"
SELECT * FROM tblEmployees
WHERE   
tblEmployees.FName LIKE '#fname#%'
AND tblEmployees.LName LIKE '#lname#%'
cfif office eq "All Offices"
AND tblEmployees.Office LIKE '%'
cfelse
AND tblEmployees.Office LIKE '#office#%'
/cfif  
ORDER BY tblEmployees.lname
/cfquery
qry two:
!--- Query to get the users Equipment info. Setting iEquipID eq the
previous
query's results. ---
cfset iEquipID = qryAllEmp.EmpID
cfquery name="qryEquipment" datasource="ITData"
SELECT * from tblEquipment
WHERE EquipID = #iEquipID#
/cfquery 

-Original Message-
From: Adkins, Randy [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 9:49 AM
To: CF-Talk
Subject: RE: nesting queries


Then it is possible that the 2nd Query returns no records, 

Can you show me both queries


-Original Message-
From: Jones, Becky [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 9:45 AM
To: CF-Talk
Subject: RE: nesting queries


i tried that and i only get results from the first query...
cfoutput
cfloop query="qryAllEmp"
tr
td colspan="2" bgcolor="E0" b#qryAllEmp.FName#
#strSpace# #qryAllEmp.MI#   #StrSpace#
#qryAllEmp.LName#/b  br
#qryAllEmp.Dept#
/td
/tr
tr
td colspan="2" bgcolor="E0"br/td
/tr
tr
td colspan="2" bgcolor="E0" 

#qryAllEmp.Office#br#qryAllEmp.Floor#br#qryAllEmp.Phone#
/td
/tr
tr
td colspan="2" bgcolor="E0"br /td
/tr
!--- Variable to output Label Equipment once. ---
cfset iEqcnt = 1
cfloop query="qryEquipment"
tr
td width="10%" bgcolor="E0"
cfif iEqcnt eq 1b Equipment: /b cfset
iEqcnt=0 /cfif 
/td   
td bgcolor="E0"#qryEquipment.Description#/td
/tr
/cfloop 
/cfloop
/cfoutput

-Original Message-
From: Adkins, Randy [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 8:58 AM
To: CF-Talk
Subject: RE: nesting queries


You can place a CFOUTPUT at the very top
of the Queries and instead of using CFOUTPUT QUERY,
use a CFLOOP Query just make sure when you are
outputing the query results you use the prefix
for the given query

Example:

CFOUPUT

CFLOOP QUERY=Query1
#Query1.MYFIELD#
CFLOOP Query=Query2
#Query2.MyField#
CFLOOP Query=Query3
#Query3.MyField#


Also make sure you close the loops when needed
to reduce the looping through unneeded records.

HTH


-Original Message-
From: Jones, Becky [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 8:58 AM
To: CF-Talk
Subject: nesting queries


I have 3 queries.  But when i try to nest the cfoutput tags i get an error
that says this in to allowed.  
how do you use the cfoutput tags to output your information if the data to
your second and third query is dependent upon the info from the first?  
here are my first 2 queries.
!--- Query to get all User's info. ---
cfquery name="qryAllEmp" datasource="ITData"
SELECT * FROM tblEmployees
WHERE   
tblEmployees.FName LIKE '#fname#%'
AND tblEmployees.LName LIKE '#lname#%'
cfif office eq "All Offices"
AND

OT/Summary: DB Server Upgrade Dilemma

2001-03-13 Thread Tony Schreiber


I've been wrestling with whether to upgrade a Compaq Proliant 6000 or get
a new server entirely. We're preparing to drastically increase the size 
and use of our database and I need to make a decision.

We're running Oracle 8.0.5 on NT4 SP6 right now. The 6000 is a 1x 400mhz
Xeon 512k. (it was here when I got here...) For about $1300 I can add
three more Xeons and make it a 4-cpu server and was going to rebuild using
Win2k AS.

My basic question was what's better? 4 x 400mhz or 2 x 800mhz? Everyone I
talked to seemed to agree that for this purpose (database, particularly
Oracle), the 4 cpu setup would be better, especially for simultaneous
access among clients. And given that for $1300, it's still on a redundant
power supply machine with a raid drive array and all that good heavy duty
server stuff that I wouldn't be able to get in a dual 800mhz machine for
less than $4k...

Thoughts, comments, suggestions?


Tony Schreiber, Senior Partner  Man and Machine, Limited
mailto:[EMAIL PROTECTED]   http://www.technocraft.com

http://www.linktoss.com ___The Fastest Way to Send a Link to Anyone!
http://www.digitacamera.com __DigitA Camera Scripts and Tips
http://www.is300.net ___The Enthusiast's Home of the Lexus IS300
http://www.cfug-sfl.org ___South Florida Cold Fusion Users Group
http://www.simplemessageboard.com ___Free Forum Software for Cold Fusion


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

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

Javascript IsDefined

2001-03-13 Thread Jeanne Sarfaty Glazer


Hi Folks,

What is the Javascript equivalent to the Cold Fusion IsDefined function?  
(or does one even exist?!)

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

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

RE: nesting queries


i tried doing that first.  but the problem i run into is that i want to have
Prev/next buttons.  and when i loop thru, it minuses one of the
applications/equipment for an indivual person each time it loops.
inotherwords...say for me i have 3 pieces of equipment.  my record count
shows that i have 3 records not one.  and if i click on the next button it
will have my name minus a piece of equipment.  and so on.  so i thought
maybe doing seperate queries would help with the record counting.  but i
guess that is another issue.  

-Original Message-
From: Adkins, Randy [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 10:03 AM
To: CF-Talk
Subject: RE: nesting queries


Considering that do a simple join on the two tables
to obtain results in one recordset.

Thus:
One Query: cfouput query=qyrAllEmp
All variables would be: qryAllEmp.fieldnames

Then you only need one CFOUTPUT and No CFLOOPS
Also considering that within the Equipment table that 
EquipID is actually the Employee ID from the Employee Table.

By what you showed in this statement is is.
cfset iEquipID = qryAllEmp.EmpID

Somewhat odd, I would think that the EquipID would be
the indtifier for the Equipment not the employee.


cfquery name="qryAllEmp" datasource="ITData"
SELECT
tblEmployees.FieldOne,tblEmployees.FieldTwo,tblEquipment.Description
FROM tblEmployees, tblEquipment
WHERE   
tblEmployees.FName LIKE '#fname#%'
AND tblEmployees.LName LIKE '#lname#%'
cfif office eq "All Offices"
AND tblEmployees.Office LIKE '%'
cfelse
AND tblEmployees.Office LIKE '#office#%'
/cfif
AND tblEmployees.EMPID = tblEquipment.EquipID
ORDER BY tblEmployees.lname
/cfquery

-Original Message-
From: Jones, Becky [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 10:01 AM
To: CF-Talk
Subject: RE: nesting queries


sure,
i checked the database for one specific person that i know has information
in the equipment table so the info is there..i just cant get it out! :) 
qry one:
cfquery name="qryAllEmp" datasource="ITData"
SELECT * FROM tblEmployees
WHERE   
tblEmployees.FName LIKE '#fname#%'
AND tblEmployees.LName LIKE '#lname#%'
cfif office eq "All Offices"
AND tblEmployees.Office LIKE '%'
cfelse
AND tblEmployees.Office LIKE '#office#%'
/cfif  
ORDER BY tblEmployees.lname
/cfquery
qry two:
!--- Query to get the users Equipment info. Setting iEquipID eq the
previous
query's results. ---
cfset iEquipID = qryAllEmp.EmpID
cfquery name="qryEquipment" datasource="ITData"
SELECT * from tblEquipment
WHERE EquipID = #iEquipID#
/cfquery 

-Original Message-
From: Adkins, Randy [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 9:49 AM
To: CF-Talk
Subject: RE: nesting queries


Then it is possible that the 2nd Query returns no records, 

Can you show me both queries


-Original Message-
From: Jones, Becky [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 9:45 AM
To: CF-Talk
Subject: RE: nesting queries


i tried that and i only get results from the first query...
cfoutput
cfloop query="qryAllEmp"
tr
td colspan="2" bgcolor="E0" b#qryAllEmp.FName#
#strSpace# #qryAllEmp.MI#   #StrSpace#
#qryAllEmp.LName#/b  br
#qryAllEmp.Dept#
/td
/tr
tr
td colspan="2" bgcolor="E0"br/td
/tr
tr
td colspan="2" bgcolor="E0" 

#qryAllEmp.Office#br#qryAllEmp.Floor#br#qryAllEmp.Phone#
/td
/tr
tr
td colspan="2" bgcolor="E0"br /td
/tr
!--- Variable to output Label Equipment once. ---
cfset iEqcnt = 1
cfloop query="qryEquipment"
tr
td width="10%" bgcolor="E0"
cfif iEqcnt eq 1b Equipment: /b cfset
iEqcnt=0 /cfif 
/td   
td bgcolor="E0"#qryEquipment.Description#/td
/tr
/cfloop 
/cfloop
/cfoutput

-Original Message-
From: Adkins, Randy [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 8:58 AM
To: CF-Talk
Subject: RE: nesting queries


You can place a CFOUTPUT at the very top
of the Queries and instead of using CFOUTPUT QUERY,
use a CFLOOP Query just make sure when you are
outputing the query results you use the prefix
for the given query

Example:

CFOUPUT

CFLOOP QUERY=Query1
#Query1.MYFIELD#
CFLOOP Query=Query2
#Query2.MyField#
CFLOOP Query=Query3
#Query3.MyField#


Also make sure you close the loops when needed
to reduce the looping through unneeded records.

HTH


-Original Message-
From: Jones,

RE: Javascript IsDefined

2001-03-13 Thread Hayes, David


You can use the "typeof" operator.

if (typeof myVarName == "undefined"){

}

-Original Message-
From: Jeanne Sarfaty Glazer [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 9:27 AM
To: CF-Talk
Subject: Javascript IsDefined


Hi Folks,

What is the Javascript equivalent to the Cold Fusion IsDefined function?  
(or does one even exist?!)

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

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

RE: Javascript IsDefined

2001-03-13 Thread Michael Rosario


JS doesn't inherently have isDefined... The functions that follow should
help you though

Michael Rosario
Internet Applications Dev
[EMAIL PROTECTED]



**


//  DESCRIPTION:Returns the value named in a URL parameter
//  PARAMS: strName is a string naming the what you want
//  EXAMPLE:If window.location.href
="../../somePage?screenid=cm100action=doSomething"
//  getURLValue("action") will
return "doSomething"

function getURLValue(strName)
{   
returnValue = null;
params = window.location.search;
temp = params.substring(1,params.length); //Kill off the '?'

valuePairList = temp.split("");

for(i=0;  ivaluePairList.length;  i++)
{   
temp=   valuePairList[i].split("=");
name=   temp[0];
value=  temp[1];
if(  name.toLowerCase()  ==  strName.toLowerCase()  )
returnValue=value;  

}
return returnValue;
}

//  DESCRIPTION:Works just like the CF isDefined function
//  PARAMS: strName is a string naming the what you want
//  EXAMPLE:If window.location.href
="../../somePage?screenid=cm100action=doSomething"
//  getURLValue("action") will
return true 

function isDefined(strName)
{   
returnValue = false;
params = window.location.search;
temp = params.substring(1,params.length); //Kill off the '?'

valuePairList = temp.split("");

for(i=0;  ivaluePairList.length;  i++)
{   
temp=   valuePairList[i].split("=");
name=   temp[0];
if(  name.toLowerCase()==strName.toLowerCase()  )
returnValue=true;   

}
return returnValue;
}

-Original Message-
From: Jeanne Sarfaty Glazer [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 10:27 AM
To: CF-Talk
Subject: Javascript IsDefined


Hi Folks,

What is the Javascript equivalent to the Cold Fusion IsDefined function?  
(or does one even exist?!)

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

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

RE: Javascript IsDefined

2001-03-13 Thread Douglas Knudsen




why not use this...

For variable x do:

if (x) then balh blah blah

IIRC, in JavaScript, if a var is 'defined', then a conditional returns
true.

ie:  if (document.layers) then blah blah

-
Douglas Knudsen
Leveraged Technologies Group
Alltel AIS
678-351-6063
Got Linux? http://linuxmall.com




From: [EMAIL PROTECTED] AT INTERNET on 03/13/2001 10:32 AM

To:   [EMAIL PROTECTED] AT INTERNET@CCMAIL
cc:(bcc: Douglas Knudsen/ATL/ALLTELCORP)

Subject:  RE: Javascript IsDefined


JS doesn't inherently have isDefined... The functions that follow
should
help you though

Michael Rosario
Internet Applications Dev
[EMAIL PROTECTED]


**
**
**


// DESCRIPTION: Returns the value named in a URL parameter
// PARAMS:   strName is a string naming the what you want
// EXAMPLE:  If window.location.href
="../../somePage?screenid=cm100action=doSomething"
//  getURLValue("action") will
return "doSomething"

function getURLValue(strName)
{
 returnValue = null;
 params = window.location.search;
 temp = params.substring(1,params.length); //Kill off the '?'

 valuePairList = temp.split("");

 for(i=0;  ivaluePairList.length;  i++)
 {
  temp=valuePairList[i].split("=");
  name=temp[0];
  value=temp[1];
  if(  name.toLowerCase()  ==  strName.toLowerCase()  )
  returnValue=   value;

 }
 return returnValue;
}

// DESCRIPTION: Works just like the CF isDefined function
// PARAMS:   strName is a string naming the what you want
// EXAMPLE:  If window.location.href
="../../somePage?screenid=cm100action=doSomething"
//  getURLValue("action") will
return true

function isDefined(strName)
{
 returnValue = false;
 params = window.location.search;
 temp = params.substring(1,params.length); //Kill off the '?'

 valuePairList = temp.split("");

 for(i=0;  ivaluePairList.length;  i++)
 {
  temp=valuePairList[i].split("=");
  name=temp[0];
  if(  name.toLowerCase()==strName.toLowerCase()  )
  returnValue=   true;

 }
 return returnValue;
}

-Original Message-
From: Jeanne Sarfaty Glazer [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 10:27 AM
To: CF-Talk
Subject: Javascript IsDefined


Hi Folks,

What is the Javascript equivalent to the Cold Fusion IsDefined
function?
(or does one even exist?!)

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

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

CF Studio 4.5.2 Memory Leak?


CF Studio 4.5.2 Memory Leak?

My question is my fellow employees and I seem to be having lots of problems
with memory when we have CF Studio 4.5.2 open.   Even if we boot up a
machine and don't do anything more then open CF Studio 4.5.2 and leave the
machine open all day it will lock up before the day is out.  

Has anyone else had this problem?   

Is Allaire addressing this problem?

Is the a fix for this problem?

Nathan

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

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

RE: CF Studio 4.5.2 Memory Leak?

2001-03-13 Thread Corrine Clark

I have never experienced a problem with my studio 4.5.2 and I run it with my
database open, email, browser, and adobe photoshop.  I am running on a 2000
professional and never had a problem.

-Original Message-
From: Nathan Stanford [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 9:50 AM
To: CF-Talk
Subject: CF Studio 4.5.2 Memory Leak?

CF Studio 4.5.2 Memory Leak?

My question is my fellow employees and I seem to be having lots of problems
with memory when we have CF Studio 4.5.2 open.   Even if we boot up a
machine and don't do anything more then open CF Studio 4.5.2 and leave the
machine open all day it will lock up before the day is out.  

Has anyone else had this problem?   

Is Allaire addressing this problem?

Is the a fix for this problem?

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

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

cfexecute and prompts

2001-03-13 Thread Todd Ashworth


I am trying to run a program with cfexecute.  The problem I am having is
that the program has a prompt built into it.  Every time I run it via
cfexecute it gets to the prompt and just sits there waiting on an answer.
Does cfexecute have any provisions for skipping over things like this?  Is
there any way at all to get past the prompt programmatically?

Todd Ashworth --
Web Application Developer
Network Administrator

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



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

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

Re: [cfexecute and prompts]

2001-03-13 Thread Alex


yes. post your code.

"Todd Ashworth" [EMAIL PROTECTED] wrote:
I am trying to run a program with cfexecute.  The problem I am having is
that the program has a prompt built into it.  Every time I run it via
cfexecute it gets to the prompt and just sits there waiting on an answer.
Does cfexecute have any provisions for skipping over things like this?  Is
there any way at all to get past the prompt programmatically?

Todd Ashworth --
Web Application Developer
Network Administrator

Saber Corporation
314 Oakland Ave.
Rock Hill, SC 29730
(803) 327-0137 [111]
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Re: CF Studio 4.5.2 Memory Leak?

2001-03-13 Thread Douglas Knudsen




What OS?  How much memory?  We are running 4.5.1 and 4.5.2 on NT4 SP6
and 128MB of ram on PIIIs.  Version 4.5.1 tends to freak out if it is
run all day, but not 4.5.2.


-
Douglas Knudsen
Leveraged Technologies Group
Alltel AIS
678-351-6063
Got Linux? http://linuxmall.com




From: [EMAIL PROTECTED] AT INTERNET on 03/13/2001 10:49 AM

To:   [EMAIL PROTECTED] AT INTERNET@CCMAIL
cc:(bcc: Douglas Knudsen/ATL/ALLTELCORP)

Subject:  CF Studio 4.5.2 Memory Leak?


CF Studio 4.5.2 Memory Leak?

My question is my fellow employees and I seem to be having lots of
problems
with memory when we have CF Studio 4.5.2 open.   Even if we boot up a
machine and don't do anything more then open CF Studio 4.5.2 and leave
the
machine open all day it will lock up before the day is out.

Has anyone else had this problem?

Is Allaire addressing this problem?

Is the a fix for this problem?

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

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

Thanks for the info: migration from NT4 to Solaris

2001-03-13 Thread Capolinea


Thanks a lot !


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

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

Re: CF Studio 4.5.2 Memory Leak?

2001-03-13 Thread Lewis Steven


If you send a query requests to the CF Server and it returns a large
number of records I've seen studio lock up.

But thats about it

Corrine Clark wrote:
 
 I have never experienced a problem with my studio 4.5.2 and I run it with my
 database open, email, browser, and adobe photoshop.  I am running on a 2000
 professional and never had a problem.
 
 -Original Message-
 From: Nathan Stanford [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, March 13, 2001 9:50 AM
 To: CF-Talk
 Subject: CF Studio 4.5.2 Memory Leak?
 
 CF Studio 4.5.2 Memory Leak?
 
 My question is my fellow employees and I seem to be having lots of problems
 with memory when we have CF Studio 4.5.2 open.   Even if we boot up a
 machine and don't do anything more then open CF Studio 4.5.2 and leave the
 machine open all day it will lock up before the day is out.
 
 Has anyone else had this problem?
 
 Is Allaire addressing this problem?
 
 Is the a fix for this problem?
 
 Nathan

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

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

Re: Project Mgmt for CF development?

2001-03-13 Thread Peter Theobald


Did you ever think that this information might be necessary to bill clients? Or to 
allocate resources to projects efficiently? Or to make accurate estimates of project 
completion dates? Or to forecast hiring needs?

(I'm not saying your manager wasn't an asshole :-) I didn't know the guy. Just that 
tracking this information, while annoying, can be very useful, and often meets a lot 
of resistance from the 'creative' talent)

At 09:06 PM 3/12/01 -0800, laszlo wrote:
..we use a time keeping system, where developers enter how much
hours they worked on for certain tasks on a certain day
Many years ago I worked for an asshole manager who's primary task was to do this.
I was in charge to write the stupid 'time-tracking' app..
Needless to say, creative programmers were forced to spend more time maintaining 
their 'progress report' and
justifying their hours than working on the actual project.
It just didn't not make any other sence, than the guy covered his behind in front of 
the 'upper' management.
There is a certain level of trust/enpowerment, managers should exercise or they are 
just out of touch...
Unfortunately, there are still way too may of them out there with way too much power.

just my 2c's,
laszlo

Phoeun Pha wrote:

 here at work we use a time keeping system, where developers enter how much
 hours they worked on for certain tasks on a certain day (tasks, developers
 can be added/deleted/edited).  u also enter the allotted time for that
 certain task, and if it goes over, the hours put into that task turns red.
 u can also view reports, so u can get a better look at how far along the
 project is going, and get a good idea of how long it will take u to do
 certain things.  in the end, u learn how to manage time better.  oh i
 forgot, that u can also add new projects.

 i also recommend a web based bug-list, where testers can report bugs, and
 check off bugs that have been fixed.  u know, display who reported the bug,
 when it was tested, description, stuff like that.  oh, also u can upload a
 screen shot!  To make it even cooler, allow users to only mess with one
 part(s) of the bug list, so that way another person can use the buglist
 (with those parts missing)! (i've coded that kinda stuff several times).

 how about running a frame containing email throughout your app?  it wil only
 contain the subject of the email, but it would be convenient if i had access
 to it at all times.  u can set it to refresh every 20 seconds or 40 minutes
 or whatever (or allow the user to do it).  and when they get new email they
 see it, and make it play a loud annoying sound, and they click on a link,
 and a javascript pop up window shows up with the message.

 how about another frame to the left that displays the name of all developers
 currently working on the project at that moment?  click on their name, and a
 java applet shows up and u can send them a message, or have a little chat.
 but why do that when u have MSN messenger??? nevermind!

 -Original Message-
 From: Leighton Tebay [mailto:[EMAIL PROTECTED]]
 Sent: Monday, March 12, 2001 4:34 PM
 To: CF-Talk
 Subject: OT: Project Mgmt for CF development?

 We are feeling the need to implement a project managment/collaboration
 software.  Outlook just doesn't cut it.

 What do you recommend for web app development?

 Leighton Tebay

 - Original Message -
 From: "Bryan Love" [EMAIL PROTECTED]
 To: "CF-Talk" [EMAIL PROTECTED]
 Sent: Monday, March 12, 2001 4:06 PM
 Subject: RE: Any recommendations on an E-commerce software?

  How bout a fully fuseboxed, scalable commerce app available with open
  source?
 
  for a demo go here:
  http://writtenword.adhost.com/blove/Admin/
 
  Uname: demo
  Pword: demo
 
 
  Bryan Love ACP
  Internet Application Developer
  [EMAIL PROTECTED]
 
 
 
  -Original Message-
  From: Ashley Hart [mailto:[EMAIL PROTECTED]]
  Sent: Monday, March 12, 2001 7:55 AM
  To: CF-Talk
  Subject: Any recommendations on an E-commerce software?
 
 
  Hi,
 
  I have a client that has a limited budget and can't afford for us to
  build them an e-commerce store from scratch, so I wanted to find out if
  anyone knew a good software that had admin reports, allowed for design,
  product and layout setup customization, and allowed repeat customers to
  have an account setup that they could view what they bought in the past,
  saved all of their account information, including their credit cards
  (like Amazon).  I used Miva Merchant once, and it was awful.
 
  -ashley
 
 



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

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

Re: [cfexecute and prompts]

2001-03-13 Thread Todd Ashworth


Basicly what I am doing is having someone upload a zip file which I can then
unzip using a command line program.

cfexecute name="#Attributes.ExecutionPath#wzunzip.exe" arguments="-ybc
#Attributes.DirectoryPath##File.ServerFile#
#Attributes.DirectoryPath#"/cfexecute

The first thing the command line program does upon being executed is ask a
question and wait for a response.  Since the execution can never be
completed, it just sits in memory forever.

Todd Ashworth --
Web Application Developer
Network Administrator

Saber Corporation
314 Oakland Ave.
Rock Hill, SC 29730
(803) 327-0137 [111]
- Original Message -
From: "Alex" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, March 13, 2001 10:56 AM
Subject: Re: [cfexecute and prompts]


| yes. post your code.
|
| "Todd Ashworth" [EMAIL PROTECTED] wrote:
| I am trying to run a program with cfexecute.  The problem I am having is
| that the program has a prompt built into it.  Every time I run it via
| cfexecute it gets to the prompt and just sits there waiting on an
answer.
| Does cfexecute have any provisions for skipping over things like this?
Is
| there any way at all to get past the prompt programmatically?



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

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

RE: CF Studio 4.5.2 Memory Leak?

2001-03-13 Thread James Maltby


My version of CF Studio 4.5.2 is very touchy - I've had to re-install it
three times over the past 3 months, sometimes the RDS does not link and
fails completely with a "can't find library" file error, other days the code
checker falls over completely, refusing to run - (but if I open the previous
4.1 version and run code checker it works - then go back to 4.5.2 and re-run
code validator it then works), also I can be running CF Studio on its own
(with nothing else open) on a PIII 650 with 256mb of RAM and with nearly
1gig of virtual mem and it warns me that my memory is running low

J

-Original Message-
From: Lewis Steven [mailto:[EMAIL PROTECTED]]
Sent: 13 March 2001 16:01
To: CF-Talk
Subject: Re: CF Studio 4.5.2 Memory Leak?


If you send a query requests to the CF Server and it returns a large
number of records I've seen studio lock up.

But thats about it

Corrine Clark wrote:
 
 I have never experienced a problem with my studio 4.5.2 and I run it with
my
 database open, email, browser, and adobe photoshop.  I am running on a
2000
 professional and never had a problem.
 
 -Original Message-
 From: Nathan Stanford [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, March 13, 2001 9:50 AM
 To: CF-Talk
 Subject: CF Studio 4.5.2 Memory Leak?
 
 CF Studio 4.5.2 Memory Leak?
 
 My question is my fellow employees and I seem to be having lots of
problems
 with memory when we have CF Studio 4.5.2 open.   Even if we boot up a
 machine and don't do anything more then open CF Studio 4.5.2 and leave the
 machine open all day it will lock up before the day is out.
 
 Has anyone else had this problem?
 
 Is Allaire addressing this problem?
 
 Is the a fix for this problem?
 
 Nathan

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

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

First crack at commerce, sort of.

2001-03-13 Thread Kortland, Brian


This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

--_=_NextPart_001_01C0ABD9.673F79C0
Content-Type: text/plain;
charset="iso-8859-1"

Hi All,

I have a number of small clients who mostly have very basic Cold Fusion
driven sites. I have a potential new client (a Deli) who has corporate
customers that want to have access his menus and place orders online. He
does not yet want full blown e-commerce with CC transactions but does want
to allow about 1,000 users into the site to place orders on a daily basis.
For my smaller sites I have used Access 2000 and have not had problems. With
this new client I have concerns regarding concurrent hits to the DB to pull
menu items and to capture and archive orders. Most things I have read state
that Access 97 is not to be used for even moderate traffic sites, but I have
seen claims by MicroSoft that Access 2000 is more robust. Is this just hype?

Should my menus, order info, and security all be kept in separate databases?

If anyone has any other advice based on my scenario I'd love to hear it.

Brian Kortland
Cyberplugs.com

--_=_NextPart_001_01C0ABD9.673F79C0
Content-Type: text/html;
charset="iso-8859-1"

!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"
HTML
HEAD
META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"
META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2654.19"
TITLEFirst crack at commerce, sort of./TITLE
/HEAD
BODY

PFONT SIZE=2Hi All,/FONT
/P

PFONT SIZE=2I have a number of small clients who mostly have very basic Cold 
Fusion/FONT
BRFONT SIZE=2driven sites. I have a potential new client (a Deli) who has 
corporate/FONT
BRFONT SIZE=2customers that want to have access his menus and place orders online. 
He/FONT
BRFONT SIZE=2does not yet want full blown e-commerce with CC transactions but does 
want/FONT
BRFONT SIZE=2to allow about 1,000 users into the site to place orders on a daily 
basis./FONT
BRFONT SIZE=2For my smaller sites I have used Access 2000 and have not had 
problems. With/FONT
BRFONT SIZE=2this new client I have concerns regarding concurrent hits to the DB 
to pull/FONT
BRFONT SIZE=2menu items and to capture and archive orders. Most things I have read 
state/FONT
BRFONT SIZE=2that Access 97 is not to be used for even moderate traffic sites, but 
I have/FONT
BRFONT SIZE=2seen claims by MicroSoft that Access 2000 is more robust. Is this 
just hype?/FONT
/P

PFONT SIZE=2Should my menus, order info, and security all be kept in separate 
databases?/FONT
/P

PFONT SIZE=2If anyone has any other advice based on my scenario I'd love to hear 
it./FONT
/P

PFONT SIZE=2Brian Kortland/FONT
BRFONT SIZE=2Cyberplugs.com/FONT
/P

/BODY
/HTML
--_=_NextPart_001_01C0ABD9.673F79C0--

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

cfloop

2001-03-13 Thread John McCosker


From a select box I am selecting a single vehicle or all vehicles and pass
the parameter to a second template which determines my vairables type of
existence,

cfif not isdefined("form.callsign")
cflocation url="mapTest.cfm" addtoken="No"
cfelseif isdefined("form.callsign") and form.callsign eq "all"

!--- here I loop through my query and pass the multable parameters for each
---
cfloop index="item" list="#form.callsign#"
cfquery name="qry_getVeichle" datasource="#application.dsn#"
username="#application.gateway#" password="#application.key#"
SELECT  callsign, vowner, dt, Lat, Lon, Speed, Direction,
Veh_Reg
FROMdbo.vehicles
WHERE   vowner = 222
/cfquery
/cfloop

!--- else just a normal single vehicle ---
cfelse
cfquery name="qry_getVeichle" datasource="#application.dsn#"
username="#application.gateway#" password="#application.key#"
SELECT  callsign, vowner, dt, Lat, Lon, Speed, Direction,
Veh_Reg
FROMdbo.vehicles
WHERE   callsign = '#form.callsign#'
/cfquery
/cfif

Then I am passing to a second server to get the vehicle positioning,
I wanted to do this the proper way with cfhttp, but due to buggy problems
with 4.5.1 and cfhttp

I have done it this way,
cfset start = 1
cfset max = qry_getVeichle.recordCount
cfset zoom = "10"
cfset data = "world"
cfset mode = "init"

cfoutput
trtd colspan="11"
img
src="http://maps.whereonearth.com/cgi-bin/mapview.exe?mode=#mode#data=#data
#zoom=#zoom#x=#qry_getVeichle.lon#y=#qry_getVeichle.lat#symbol=#qry_getV
eichle.lon#,#qry_getVeichle.lat#,target,#callsign#"/td/tr
/cfoutput

This is fine for one vehicle, but for multable I still only get the first
vehicle in the recordset, even though I loop through my query for the
existence of all.

If I test my looped query like so,

cfset start = 1
cfset max = qry_getVeichle.recordCount

cfloop query="qry_getVeichle" startrow="#start#" endrow="#max#"
cfoutput
trtd colspan="11"
img
src="http://maps.whereonearth.com/cgi-bin/mapview.exe?mode=#mode#data=#data
#zoom=#zoom#x=#qry_getVeichle.lon#y=#qry_getVeichle.lat#symbol=#qry_getV
eichle.lon#,#qry_getVeichle.lat#,target,#callsign#"/td/tr
/cfoutput
/cfloop

the obvious happens I get multable vehieles displayed but on multible maps,
(I know, duuu!!)

so I think that my problem lies somewhere around

startrow="#start#" endrow="#max#" which works fine when outputting to html

or else the problems with the 'mapview.exe' which would be a completely
different issue.

If some one could send me in the right direction with my cfloop though, it
would be mighty appreciated.

Thanx world..



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

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

RE: cfexecute and prompts

2001-03-13 Thread Craig Dudley

Not unless the program in question accepts paramaters from the command line.

-Original Message-
From: Todd Ashworth [mailto:[EMAIL PROTECTED]]
Sent: 13 March 2001 15:55
To: CF-Talk
Subject: cfexecute and prompts

I am trying to run a program with cfexecute.  The problem I am having is
that the program has a prompt built into it.  Every time I run it via
cfexecute it gets to the prompt and just sits there waiting on an answer.
Does cfexecute have any provisions for skipping over things like this?  Is
there any way at all to get past the prompt programmatically?

Todd Ashworth --
Web Application Developer
Network Administrator

Saber Corporation
314 Oakland Ave.
Rock Hill, SC 29730
(803) 327-0137 [111]
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Ben Forta tonite!! in Dallas

2001-03-13 Thread Billy Cravens


Just wanted to post this message in case there's anyone in here who
would be interested in attending tonite's meeting of the Dallas/Fort
Worth ColdFusion User Group, where Ben will be speaking.  For details go
to www.dfwcfug.org

--
Billy Cravens
HR Web Development, Sabre
[EMAIL PROTECTED]



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

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

Re: [Re: [cfexecute and prompts]]

2001-03-13 Thread Alex


write a DOS batch file and call that from cfexecute. 
you need 2 files ..1)the *.bat and 2)a text file that is just a y and carriage
return
 
ex. *.bat
wzunzip stuffvariable  y.txt

"Todd Ashworth" [EMAIL PROTECTED] wrote:
Basicly what I am doing is having someone upload a zip file which I can then
unzip using a command line program.

cfexecute name="#Attributes.ExecutionPath#wzunzip.exe" arguments="-ybc
#Attributes.DirectoryPath##File.ServerFile#
#Attributes.DirectoryPath#"/cfexecute

The first thing the command line program does upon being executed is ask a
question and wait for a response.  Since the execution can never be
completed, it just sits in memory forever.

Todd Ashworth --
Web Application Developer
Network Administrator

Saber Corporation
314 Oakland Ave.
Rock Hill, SC 29730
(803) 327-0137 [111]
- Original Message -
From: "Alex" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, March 13, 2001 10:56 AM
Subject: Re: [cfexecute and prompts]


| yes. post your code.
|
| "Todd Ashworth" [EMAIL PROTECTED] wrote:
| I am trying to run a program with cfexecute.  The problem I am having is
| that the program has a prompt built into it.  Every time I run it via
| cfexecute it gets to the prompt and just sits there waiting on an
answer.
| Does cfexecute have any provisions for skipping over things like this?
Is
| there any way at all to get past the prompt programmatically?
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: cfloop

2001-03-13 Thread Jason Lees (National Express)



Have you tried


cfoutput query=#MyQuery#  Or use a CFLoop
trtd Colspan="11"
img
src="http://maps.whereonearth.com/cgi-bin/mapview.exe?mode=#mode#data=#data
#zoom=#zoom#x=#qry_getVeichle.lon#y=#qry_getVeichle.lat#symbol=#qry_getV
eichle.lon#,#qry_getVeichle.lat#,target,#callsign#"
/td/tr
/cfoutput


Jason Lees 
National Express
Email : [EMAIL PROTECTED]


-Original Message-
From: John McCosker [mailto:[EMAIL PROTECTED]]
Sent: 13 March 2001 16:19
To: CF-Talk
Subject: cfloop


From a select box I am selecting a single vehicle or all vehicles and pass
the parameter to a second template which determines my vairables type of
existence,

cfif not isdefined("form.callsign")
cflocation url="mapTest.cfm" addtoken="No"
cfelseif isdefined("form.callsign") and form.callsign eq "all"

!--- here I loop through my query and pass the multable parameters for each
---
cfloop index="item" list="#form.callsign#"
cfquery name="qry_getVeichle" datasource="#application.dsn#"
username="#application.gateway#" password="#application.key#"
SELECT  callsign, vowner, dt, Lat, Lon, Speed, Direction,
Veh_Reg
FROMdbo.vehicles
WHERE   vowner = 222
/cfquery
/cfloop

!--- else just a normal single vehicle ---
cfelse
cfquery name="qry_getVeichle" datasource="#application.dsn#"
username="#application.gateway#" password="#application.key#"
SELECT  callsign, vowner, dt, Lat, Lon, Speed, Direction,
Veh_Reg
FROMdbo.vehicles
WHERE   callsign = '#form.callsign#'
/cfquery
/cfif

Then I am passing to a second server to get the vehicle positioning,
I wanted to do this the proper way with cfhttp, but due to buggy problems
with 4.5.1 and cfhttp

I have done it this way,
cfset start = 1
cfset max = qry_getVeichle.recordCount
cfset zoom = "10"
cfset data = "world"
cfset mode = "init"

cfoutput
trtd colspan="11"
img
src="http://maps.whereonearth.com/cgi-bin/mapview.exe?mode=#mode#data=#data
#zoom=#zoom#x=#qry_getVeichle.lon#y=#qry_getVeichle.lat#symbol=#qry_getV
eichle.lon#,#qry_getVeichle.lat#,target,#callsign#"/td/tr
/cfoutput

This is fine for one vehicle, but for multable I still only get the first
vehicle in the recordset, even though I loop through my query for the
existence of all.

If I test my looped query like so,

cfset start = 1
cfset max = qry_getVeichle.recordCount

cfloop query="qry_getVeichle" startrow="#start#" endrow="#max#"
cfoutput
trtd colspan="11"
img
src="http://maps.whereonearth.com/cgi-bin/mapview.exe?mode=#mode#data=#data
#zoom=#zoom#x=#qry_getVeichle.lon#y=#qry_getVeichle.lat#symbol=#qry_getV
eichle.lon#,#qry_getVeichle.lat#,target,#callsign#"/td/tr
/cfoutput
/cfloop

the obvious happens I get multable vehieles displayed but on multible maps,
(I know, duuu!!)

so I think that my problem lies somewhere around

startrow="#start#" endrow="#max#" which works fine when outputting to html

or else the problems with the 'mapview.exe' which would be a completely
different issue.

If some one could send me in the right direction with my cfloop though, it
would be mighty appreciated.

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

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

OT: Who's the Moderator of this List?

2001-03-13 Thread Erika L Walker


This seems like a silly question and please don't yell at me for asking, but
I was looking for a moderator's direct email address and name and couldn't
find one, here or on the website. (I have over 4000 CF_Talk emails, and I
searched through all of them) although, not knowing the person's actual name
was a hindrance.

Sorry in advance for an extra email in your box,

Erika



AIM: WebErika5
Yahoo: WebErika
MSN: WebErika
AskMe.com Expert: WebErika

Erika L. Walker
Vice President
RUWebby, LLC
201-370-4272 (c)
973-244-9120 (o)
153 Rutgers Lane
Parsippany, NJ 07054

Website Design/Programming
Database Integration
Allaire Partner - ColdFusion




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

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

RE: Responding to Post's

2001-03-13 Thread Arden Weiss


Get It - Got It - Good   :-))

 ^
/ \__
   (@\___
  /  O
 /(_/
/_/
Whoof...
410-757-3487

-Original Message-
From:   Michael [SMTP:[EMAIL PROTECTED]]
Sent:   Tuesday, March 13, 2001 9:14 AM
To: CF-Talk
Subject:Re: Responding to Post's

All I am saying is if responding to a message respond to the message in that
message's header, like this one
"Arden Weiss" [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
 Okay, tell me more -- what are you talking about -- what is "the
appropriate post note" -- I don't have an "any key" either.

  ^
 / \__
(@\___
   /  O
  /(_/
 /_/
 Whoof...
 410-757-3487

 -Original Message-
 From: Michael [SMTP:[EMAIL PROTECTED]]
 Sent: Tuesday, March 13, 2001 6:28 AM
 To: CF-Talk
 Subject: OT: Responding to Post's

 Why cant people respond to the post in the appropriate post note and not
mix
 match things, ??

 Just a question, not trying to start a flame war or something, just seems
 that lately alot of this is happening, then again maybe its just me.

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

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

Re: nesting queries

2001-03-13 Thread Paul Johnston


At the risk of having seventeen other people tell you how to do it...

All that this code...

cfoutput query="myQuery"
/cfoutput

does is:

cfoutput
cfloop query="myQuery"
/cfloop
/cfoutput

Try using cfloop instead.

Also if you want to create a query based on another query, you have to loop
over the first query, create the new query, and then output that query:

cfquery name="Query1" datasource="#dsn#"
SELECT * FROM myTable ORDER BY myField asc
/cfquery

cfoutput
cfloop query="Query1"
cfquery name="Query2" datasource="#dsn#"
SELECT * FROM table WHERE aField = '#query1.myfield#'
/cfquery
cfloop query="Query2"
#Query2.aField#br
/cfloop
/cfloop
/cfoutput

However, this is not efficient as there are going to be the same number of
database calls as there are records returned in the first query!  Try to use
the database to return a much more useful result set (if you're using MS SQL
Server that means a stored procedure - ask if you're not sure).  If you can
then output the resultset once, you only need to go to the database once and
you only need to output it once (and it's a lot easier on ColdFusion too!).

I hope this makes sense!

Paul

Paul Johnston
PJ Net Solutions Ltd
E: [EMAIL PROTECTED]
M: 07866 573013
- Original Message -
From: "Jones, Becky" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, March 13, 2001 1:57 PM
Subject: nesting queries


 I have 3 queries.  But when i try to nest the cfoutput tags i get an error
 that says this in to allowed.
 how do you use the cfoutput tags to output your information if the data to
 your second and third query is dependent upon the info from the first?
 here are my first 2 queries.
 !--- Query to get all User's info. ---
 cfquery name="qryAllEmp" datasource="ITData"
 SELECT * FROM tblEmployees
 WHERE
   tblEmployees.FName LIKE '#fname#%'
 AND tblEmployees.LName LIKE '#lname#%'
 cfif office eq "All Offices"
 AND tblEmployees.Office LIKE '%'
 cfelse
 AND tblEmployees.Office LIKE '#office#%'
 /cfif
 ORDER BY tblEmployees.lname
 /cfquery
 !--- Query to get the users Equipment info. Setting iEquipID eq the
 previous query's results. ---
 cfset iEquipID = qryAllEmp.EmpID
 cfquery name="qryEquipment" datasource="ITData"
 SELECT * from tblEquipment
 WHERE EquipID = #iEquipID#
 /cfquery
 I want to be able to have one table that i can put the information all
 together.  any ideas?


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




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

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

Re: Who's the Moderator of this List?

2001-03-13 Thread Howie Hamlin


Michael Dinowitz
Publisher: Fusion Authority weekly news alert
(www.fusionauthority.com/alert)
Listmaster: CF-Talk, CF-Jobs, Spectra-Talk, Jrun-Talk, etc.
(www.houseoffusion.com)


- Original Message -
From: "Erika L Walker" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, March 13, 2001 11:38 AM
Subject: OT: Who's the Moderator of this List?


 This seems like a silly question and please don't yell at me for asking,
but
 I was looking for a moderator's direct email address and name and couldn't
 find one, here or on the website. (I have over 4000 CF_Talk emails, and I
 searched through all of them) although, not knowing the person's actual
name
 was a hindrance.

 Sorry in advance for an extra email in your box,

 Erika


 
 AIM: WebErika5
 Yahoo: WebErika
 MSN: WebErika
 AskMe.com Expert: WebErika
 
 Erika L. Walker
 Vice President
 RUWebby, LLC
 201-370-4272 (c)
 973-244-9120 (o)
 153 Rutgers Lane
 Parsippany, NJ 07054
 
 Website Design/Programming
 Database Integration
 Allaire Partner - ColdFusion
 





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

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

RE: Who's the Moderator of this List?

2001-03-13 Thread Braver, Ben:

Michael Dinowitz [[EMAIL PROTECTED]]

-Original Message-
From: Erika L Walker [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 8:39 AM
To: CF-Talk
Subject: OT: Who's the Moderator of this List?

This seems like a silly question and please don't yell at me for asking, but
I was looking for a moderator's direct email address and name and couldn't
find one, here or on the website. (I have over 4000 CF_Talk emails, and I
searched through all of them) although, not knowing the person's actual name
was a hindrance.

Sorry in advance for an extra email in your box,

Erika

AIM: WebErika5
Yahoo: WebErika
MSN: WebErika
AskMe.com Expert: WebErika

Erika L. Walker
Vice President
RUWebby, LLC
201-370-4272 (c)
973-244-9120 (o)
153 Rutgers Lane
Parsippany, NJ 07054

Website Design/Programming
Database Integration
Allaire Partner - ColdFusion

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

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

Re: CF Studio 4.5.2 Memory Leak?

2001-03-13 Thread Michael S. Kimmett

Nathan,

When I have Studio and Server running all day I also have my system lock up.
This has become quite annoying especially at the end of a long day.

- Original Message -
From: "Nathan Stanford" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, March 13, 2001 9:49 AM
Subject: CF Studio 4.5.2 Memory Leak?

 CF Studio 4.5.2 Memory Leak?

 My question is my fellow employees and I seem to be having lots of
problems
 with memory when we have CF Studio 4.5.2 open.   Even if we boot up a
 machine and don't do anything more then open CF Studio 4.5.2 and leave the
 machine open all day it will lock up before the day is out.

 Has anyone else had this problem?

 Is Allaire addressing this problem?

 Is the a fix for this problem?

 Nathan

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

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

RE: First crack at commerce, sort of.

go with SQL or mysql

-Original Message-
From: Kortland, Brian [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 10:20 AM
To: CF-Talk
Subject: First crack at commerce, sort of.

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

--_=_NextPart_001_01C0ABD9.673F79C0
Content-Type: text/plain;
charset="iso-8859-1"

Hi All,

I have a number of small clients who mostly have very basic Cold Fusion
driven sites. I have a potential new client (a Deli) who has corporate
customers that want to have access his menus and place orders online. He
does not yet want full blown e-commerce with CC transactions but does want
to allow about 1,000 users into the site to place orders on a daily basis.
For my smaller sites I have used Access 2000 and have not had problems. With
this new client I have concerns regarding concurrent hits to the DB to pull
menu items and to capture and archive orders. Most things I have read state
that Access 97 is not to be used for even moderate traffic sites, but I have
seen claims by MicroSoft that Access 2000 is more robust. Is this just hype?

Should my menus, order info, and security all be kept in separate databases?

If anyone has any other advice based on my scenario I'd love to hear it.

Brian Kortland
Cyberplugs.com

--_=_NextPart_001_01C0ABD9.673F79C0
Content-Type: text/html;
charset="iso-8859-1"

!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"
HTML
HEAD
META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"
META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2654.19"
TITLEFirst crack at commerce, sort of./TITLE
/HEAD
BODY

PFONT SIZE=2Hi All,/FONT
/P

PFONT SIZE=2I have a number of small clients who mostly have very basic
Cold Fusion/FONT
BRFONT SIZE=2driven sites. I have a potential new client (a Deli) who
has corporate/FONT
BRFONT SIZE=2customers that want to have access his menus and place
orders online. He/FONT
BRFONT SIZE=2does not yet want full blown e-commerce with CC
transactions but does want/FONT
BRFONT SIZE=2to allow about 1,000 users into the site to place orders on
a daily basis./FONT
BRFONT SIZE=2For my smaller sites I have used Access 2000 and have not
had problems. With/FONT
BRFONT SIZE=2this new client I have concerns regarding concurrent hits
to the DB to pull/FONT
BRFONT SIZE=2menu items and to capture and archive orders. Most things I
have read state/FONT
BRFONT SIZE=2that Access 97 is not to be used for even moderate traffic
sites, but I have/FONT
BRFONT SIZE=2seen claims by MicroSoft that Access 2000 is more robust.
Is this just hype?/FONT
/P

PFONT SIZE=2Should my menus, order info, and security all be kept in
separate databases?/FONT
/P

PFONT SIZE=2If anyone has any other advice based on my scenario I'd love
to hear it./FONT
/P

PFONT SIZE=2Brian Kortland/FONT
BRFONT SIZE=2Cyberplugs.com/FONT
/P

/BODY
/HTML
--_=_NextPart_001_01C0ABD9.673F79C0--

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

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

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

Server log errors

2001-03-13 Thread Andy Ewings


I have a setup of 4 servers - 2 web servers (NT  IIS) and 2 database
servers (SQL 7), one active and one passive.  The web servers are load
balanced but both use the actyive SQL machine.  Sometimes both CF servers
die and by looking at the error logs it appears that SQL Server is
deadlocking.  What is the likely cause of this?  Will it be a coding issue?

In the CF server log I get a meesage saying:
"Error","TID=67","03/13/01","09:40:58","ExprParser: CFuncIsDefined::DoIt:
unknown".followed by:

"Error","TID=67","03/13/01","09:40:58","Unexpected exception while
processing a tag with a general identifier of (CFIF), occupying document
position (32:1) to (32:40), while executing template file
D:\www\connexions\Application.cfm"

The line of code in question it is complaining about in the application.cfm
is:  cfif NOT ISDEFINED("Client.rollCount")

CF then restarts itself and the same thing happens again but on a different
line in the application.cfm.  This time  line 47 which is: cfset
cftoken_local = Cookie.CFTOKEN

Anyone had this happen before?

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



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

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

RE: First crack at commerce, sort of.

2001-03-13 Thread Kevin Miller



I agree that you should use a true DBMS if possible, but Access can probably be made 
to work Ok for just 1000 users.I would consider switching away from Access if you 
have more than 5-10 simultaneous connections, or more than a 100-200k records.

If you use Access, make judicious use of cached queries and other optimizations as 
much as possible.

Kevin

 [EMAIL PROTECTED] 03/13/01 08:49AM 
go with SQL or mysql

-Original Message-
From: Kortland, Brian [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, March 13, 2001 10:20 AM
To: CF-Talk
Subject: First crack at commerce, sort of.


This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

--_=_NextPart_001_01C0ABD9.673F79C0
Content-Type: text/plain;
charset="iso-8859-1"

Hi All,

I have a number of small clients who mostly have very basic Cold Fusion
driven sites. I have a potential new client (a Deli) who has corporate
customers that want to have access his menus and place orders online. He
does not yet want full blown e-commerce with CC transactions but does want
to allow about 1,000 users into the site to place orders on a daily basis.
For my smaller sites I have used Access 2000 and have not had problems. With
this new client I have concerns regarding concurrent hits to the DB to pull
menu items and to capture and archive orders. Most things I have read state
that Access 97 is not to be used for even moderate traffic sites, but I have
seen claims by MicroSoft that Access 2000 is more robust. Is this just hype?

Should my menus, order info, and security all be kept in separate databases?

If anyone has any other advice based on my scenario I'd love to hear it.

Brian Kortland
Cyberplugs.com

--_=_NextPart_001_01C0ABD9.673F79C0
Content-Type: text/html;
charset="iso-8859-1"

!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"
HTML
HEAD
META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"
META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2654.19"
TITLEFirst crack at commerce, sort of./TITLE
/HEAD
BODY

PFONT SIZE=2Hi All,/FONT
/P

PFONT SIZE=2I have a number of small clients who mostly have very basic
Cold Fusion/FONT
BRFONT SIZE=2driven sites. I have a potential new client (a Deli) who
has corporate/FONT
BRFONT SIZE=2customers that want to have access his menus and place
orders online. He/FONT
BRFONT SIZE=2does not yet want full blown e-commerce with CC
transactions but does want/FONT
BRFONT SIZE=2to allow about 1,000 users into the site to place orders on
a daily basis./FONT
BRFONT SIZE=2For my smaller sites I have used Access 2000 and have not
had problems. With/FONT
BRFONT SIZE=2this new client I have concerns regarding concurrent hits
to the DB to pull/FONT
BRFONT SIZE=2menu items and to capture and archive orders. Most things I
have read state/FONT
BRFONT SIZE=2that Access 97 is not to be used for even moderate traffic
sites, but I have/FONT
BRFONT SIZE=2seen claims by MicroSoft that Access 2000 is more robust.
Is this just hype?/FONT
/P

PFONT SIZE=2Should my menus, order info, and security all be kept in
separate databases?/FONT
/P

PFONT SIZE=2If anyone has any other advice based on my scenario I'd love
to hear it./FONT
/P

PFONT SIZE=2Brian Kortland/FONT
BRFONT SIZE=2Cyberplugs.com/FONT
/P

/BODY
/HTML
--_=_NextPart_001_01C0ABD9.673F79C0--

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

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

CF_EmbedFields Crashes my server?

2001-03-13 Thread Jay Patton


hello all,
I am using the CF_EmbedFields tag in a 3 part form.  the first day that I used it 
everything worked fine. however now when I run that form. (3 days latter with NO 
changes to the site) my cfserver.exe ends up taking up 95% of the CPU usage (this is 
running local). has anyone else ever ran into this before? here is the code that I 
have used it in just in case you see something that might be doing this: Thanks for 
the help/input.
if you need more than what I have given I will post it.
Thanks,

!--- Form Part 1 (10 formfields)

cfform action="NewClient2.cfm" method="post"
!-- REST OF FORM HERE--
input type="Submit" value="Next --"
 /cfform
--

!-- FORM Part 2 (9 formfields)

cfform action="NewClient3.cfm" method="post"
CF_EmbedFields
!-- REST OF FORM HERE --
/cfform
--

!-- FORM Part 3 (4 formfields)

cfform action="AddClient.cfm" method="post"
CF_EmbedFields
!-- REST OF FORM HERE --
/cfform
--

Jay Patton
Web Design / Application Design
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com

*
"Trust Everyone
But Always Cut The Cards."
*


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

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

Re: First crack at commerce, sort of.

2001-03-13 Thread Jay Patton


I would use SQL or MySQL for this NOT! Access

Jay Patton
Web Design / Application Design
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
- Original Message -
From: "Kortland, Brian" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, March 13, 2001 9:19 AM
Subject: First crack at commerce, sort of.


 This message is in MIME format. Since your mail reader does not understand
 this format, some or all of this message may not be legible.

 --_=_NextPart_001_01C0ABD9.673F79C0
 Content-Type: text/plain;
 charset="iso-8859-1"

 Hi All,

 I have a number of small clients who mostly have very basic Cold Fusion
 driven sites. I have a potential new client (a Deli) who has corporate
 customers that want to have access his menus and place orders online. He
 does not yet want full blown e-commerce with CC transactions but does want
 to allow about 1,000 users into the site to place orders on a daily basis.
 For my smaller sites I have used Access 2000 and have not had problems.
With
 this new client I have concerns regarding concurrent hits to the DB to
pull
 menu items and to capture and archive orders. Most things I have read
state
 that Access 97 is not to be used for even moderate traffic sites, but I
have
 seen claims by MicroSoft that Access 2000 is more robust. Is this just
hype?

 Should my menus, order info, and security all be kept in separate
databases?

 If anyone has any other advice based on my scenario I'd love to hear it.

 Brian Kortland
 Cyberplugs.com

 --_=_NextPart_001_01C0ABD9.673F79C0
 Content-Type: text/html;
 charset="iso-8859-1"

 !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"
 HTML
 HEAD
 META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"
 META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2654.19"
 TITLEFirst crack at commerce, sort of./TITLE
 /HEAD
 BODY

 PFONT SIZE=2Hi All,/FONT
 /P

 PFONT SIZE=2I have a number of small clients who mostly have very
basic Cold Fusion/FONT
 BRFONT SIZE=2driven sites. I have a potential new client (a Deli) who
has corporate/FONT
 BRFONT SIZE=2customers that want to have access his menus and place
orders online. He/FONT
 BRFONT SIZE=2does not yet want full blown e-commerce with CC
transactions but does want/FONT
 BRFONT SIZE=2to allow about 1,000 users into the site to place orders
on a daily basis./FONT
 BRFONT SIZE=2For my smaller sites I have used Access 2000 and have not
had problems. With/FONT
 BRFONT SIZE=2this new client I have concerns regarding concurrent hits
to the DB to pull/FONT
 BRFONT SIZE=2menu items and to capture and archive orders. Most things
I have read state/FONT
 BRFONT SIZE=2that Access 97 is not to be used for even moderate
traffic sites, but I have/FONT
 BRFONT SIZE=2seen claims by MicroSoft that Access 2000 is more robust.
Is this just hype?/FONT
 /P

 PFONT SIZE=2Should my menus, order info, and security all be kept in
separate databases?/FONT
 /P

 PFONT SIZE=2If anyone has any other advice based on my scenario I'd
love to hear it./FONT
 /P

 PFONT SIZE=2Brian Kortland/FONT
 BRFONT SIZE=2Cyberplugs.com/FONT
 /P

 /BODY
 /HTML
 --_=_NextPart_001_01C0ABD9.673F79C0--

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



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

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

Re: CF Studio 4.5.2 Memory Leak?

2001-03-13 Thread Michael Kear


Any time I have brought this issue up with Allaire or their distributors,
they just look at me with scorn, as though I am some kind of fool and say
"well you should be using Win2000"   and the implied rest of the sentence
seems to be "... instead of that childs toy you are using."

My answer is, .. there are a lot of reasons I might be using Win98 on one
machine, Win95 on another and Win2000 on a third.  And it doesnt matter,
because Allaire's specs don't say studio needs Win2K to work.  It says
specifically, that it works on Win95,98, and win2K.  

So it's my contention that Studio (all versions since 4.0.1, the first
I've used) breach the Australian Sale Of Goods Act as being not of
merchantable quality and unfit for the purpose for which they're sold.  It
could be a brilliant app, and even with all its faults I still use it, but
I think it's poor value at about 50% more than Microsoft Office.

And they don't seem to be doing anything at all about the issues.   They
even had the hide to send my client a bill for more than 50% of the
original price as renewal of the subscription.  And they hadn't done
anything at all for the first year's!

They need a session or two with Ralph Nader I reckon.

Cheers,
Mike Kear
AFP Webworks,
Windsor, NSW, Australia


On Tue, 13 Mar 2001, Douglas Knudsen wrote:

 
 
 What OS?  How much memory?  We are running 4.5.1 and 4.5.2 on NT4 SP6
 and 128MB of ram on PIIIs.  Version 4.5.1 tends to freak out if it is
 run all day, but not 4.5.2.
 
 
 -
 Douglas Knudsen
 Leveraged Technologies Group
 Alltel AIS
 678-351-6063
 Got Linux? http://linuxmall.com
 
 
 
 
 From: [EMAIL PROTECTED] AT INTERNET on 03/13/2001 10:49 AM
 
 To:   [EMAIL PROTECTED] AT INTERNET@CCMAIL
 cc:(bcc: Douglas Knudsen/ATL/ALLTELCORP)
 
 Subject:  CF Studio 4.5.2 Memory Leak?
 
 
 CF Studio 4.5.2 Memory Leak?
 
 My question is my fellow employees and I seem to be having lots of
 problems
 with memory when we have CF Studio 4.5.2 open.   Even if we boot up a
 machine and don't do anything more then open CF Studio 4.5.2 and leave
 the
 machine open all day it will lock up before the day is out.
 
 Has anyone else had this problem?
 
 Is Allaire addressing this problem?
 
 Is the a fix for this problem?
 
 Nathan

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

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

RE: CF Studio 4.5.2 Memory Leak?


CFSTUIDO 4.5.2 is not the most stable app in the world, and is very easy to
crash (try closing a window with JS in the internal browser - and watch
those error messages!!!)

but as far as memory holes go, its not nearly as bad as previous versions
(I've been working with it for 2 days and I'm only upto 25Mb VM usage)

I think if anything though, overall stability is no better, if not worse -
but I'm not sure if this is studio, or MMC for ent manger running on NT -
together they require me to reboot every couple of days..

Also - since upgrading to IE 5.5, memory usage seems to have gone through
the roof... oten using over 50MB within a few hours of booting...

-Original Message-
From: Michael S. Kimmett [mailto:[EMAIL PROTECTED]]
Sent: 13 March 2001 16:54
To: CF-Talk
Subject: Re: CF Studio 4.5.2 Memory Leak?


Nathan,

When I have Studio and Server running all day I also have my system lock up.
This has become quite annoying especially at the end of a long day.


- Original Message -
From: "Nathan Stanford" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, March 13, 2001 9:49 AM
Subject: CF Studio 4.5.2 Memory Leak?


 CF Studio 4.5.2 Memory Leak?

 My question is my fellow employees and I seem to be having lots of
problems
 with memory when we have CF Studio 4.5.2 open.   Even if we boot up a
 machine and don't do anything more then open CF Studio 4.5.2 and leave the
 machine open all day it will lock up before the day is out.

 Has anyone else had this problem?

 Is Allaire addressing this problem?

 Is the a fix for this problem?

 Nathan


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

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

RE: CF Studio 4.5.2 Memory Leak?


If you do a search on Allaire's own ColdFusion Forum's in the CF Studio area
you get 32 notes about this problem.  April 1999 is the first request about
the problem and the fact that using projects increases the problem.  A
Allaire Employee said that the project deployment increases the memory
usage.   There were some comments that it is not a Leak just a Memory Hog.
When CF Studio tends to take more memory then PhotoShop then I think this
needs fixed.

Nathan

P.S. I will see Ben tonight at the DFWCFUG Meeting. 



 -Original Message-
 From: Michael S. Kimmett [SMTP:[EMAIL PROTECTED]]
 Sent: Tuesday, March 13, 2001 10:54 AM
 To:   CF-Talk
 Subject:  Re: CF Studio 4.5.2 Memory Leak?
 
 Nathan,
 
 When I have Studio and Server running all day I also have my system lock
 up.
 This has become quite annoying especially at the end of a long day.
 
 
 - Original Message -
 From: "Nathan Stanford" [EMAIL PROTECTED]
 To: "CF-Talk" [EMAIL PROTECTED]
 Sent: Tuesday, March 13, 2001 9:49 AM
 Subject: CF Studio 4.5.2 Memory Leak?
 
 
  CF Studio 4.5.2 Memory Leak?
 
  My question is my fellow employees and I seem to be having lots of
 problems
  with memory when we have CF Studio 4.5.2 open.   Even if we boot up a
  machine and don't do anything more then open CF Studio 4.5.2 and leave
 the
  machine open all day it will lock up before the day is out.
 
  Has anyone else had this problem?
 
  Is Allaire addressing this problem?
 
  Is the a fix for this problem?
 
  Nathan
 
 

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

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

one more Paradox question...

2001-03-13 Thread kmansel


Ok we are going to be connecting to a Paradox 4.5 systemyes i
knowoldbut besides that, i know that the M$ ODBC driver will lock
the tables and mess everything up... :oP   so has anyone worked with this
and found a better ODBC driver?   

TIA

Kevin

~
Kevin Mansel
Web Developer
Fox Communications
[EMAIL PROTECTED]


 Kevin Mansel.vcf 


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

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

RE: CF Studio 4.5.2 Memory Leak?

2001-03-13 Thread Richard Kuryk


If it crashes and eats through memory don't use it and certainly don't
purchase it!  There are many good programmer editors out there.  UltraEdit,
MultiEdit, and the list goes on and on, give your money to something that is
stable and is not counterproductive.  Most of these editors have demos or
eval copies and can be customized to do whatever you like.  I have even read
that the new multiedit integrates into studio, not sure I would want that
but hey maybe it makes studio more stable.

Rich


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

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

RE: Javascript IsDefined

2001-03-13 Thread Patricia Lee


The correct syntax is
if (typeof(myvarname) == "undefined") {
[do your stuff]
}

|-Original Message-
|From: Hayes, David [mailto:[EMAIL PROTECTED]]
|Sent: Tuesday, March 13, 2001 10:32 AM
|To: CF-Talk
|Subject: RE: Javascript IsDefined
|
|
|You can use the "typeof" operator.
|
|if (typeof myVarName == "undefined"){
|
|}
|
|-Original Message-
|From: Jeanne Sarfaty Glazer [mailto:[EMAIL PROTECTED]]
|Sent: Tuesday, March 13, 2001 9:27 AM
|To: CF-Talk
|Subject: Javascript IsDefined
|
|
|Hi Folks,
|
|What is the Javascript equivalent to the Cold Fusion IsDefined 
|function?  
|(or does one even exist?!)
|
|TIA,
|- - - Jeanne
|
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: parsing form submission into an html file?


I have in the past used CFFILE to generate .htm files - what exactly are you
wanting to do???

-Original Message-
From: Jon Tillman [mailto:[EMAIL PROTECTED]]
Sent: 09 March 2001 01:48
To: CF-Talk
Subject: parsing form submission into an html file?


-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

does anyone know of a way to create an html file from a form submission, or 
to insert the form fields into a template and save the result as an html
file?
I can't find anything on the net, and cffile seems to not be what I need.

- -- 
Jon Tillman
http://www.eruditum.org
finger [EMAIL PROTECTED] to annoy the MPAA

To be yourself, in a world that tries, night and day, to make you just like 
everybody else - is to fight the greatest battle there ever is to fight, and

never stop fighting. --e.e. cummings

-BEGIN PGP SIGNATURE-
Version: PGP 6.5.1i

iQA/AwUBOqg2Vtga7tZtnIOtEQJKDACgq6xlHux9uAaJd8mXljcgylUGMcAAn0xj
K/bfzq+xEIRNVqU+6203y4Xs
=RuM9
-END PGP SIGNATURE-
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: CF Studio 4.5.2 Memory Leak?

2001-03-13 Thread Philip Arnold - ASP


 CFSTUIDO 4.5.2 is not the most stable app in the world, and is
 very easy to
 crash (try closing a window with JS in the internal browser - and watch
 those error messages!!!)

I'm sorry, but "Well DUH!" - how are you meant to close a window that's
built in to the system?

 Also - since upgrading to IE 5.5, memory usage seems to have gone through
 the roof... oten using over 50MB within a few hours of booting...

We've had to dump IE5.5 from most of our machines as it's so hungry -
combine that with WindowsMe and you've got a REAL winner...

*** Standard Joke time ***
The only way you could call Studio 4.5.2 stable is if you put a horse in it!

Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133

"Websites for the real world"

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



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

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

RE: CF Studio 4.5.2 Memory Leak?

2001-03-13 Thread Mark W. Breneman


I have fought this problem for some time now. I could not get CFS to be
happy under windows 9x.  But, windows 2000 seems to handle the CFS MUCH
better.

I found a solution that works very well for me:

Windows 2000
196MB RAM
CF Studio 4.5.2

It is very stable.  And believe me I hammer CF studio and the entire system
very very hard.  I will very often have 14+ larger apps open at the same
time (i.e. outlook, pcanywhere, word, excel, multi sessions of SQL mangers,
Access, Query32, winamp and the list goes on.)

Rock solid... I reboot once a week.

Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770


-Original Message-
From: Richard Kuryk [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 11:46 AM
To: CF-Talk
Subject: RE: CF Studio 4.5.2 Memory Leak?


If it crashes and eats through memory don't use it and certainly don't
purchase it!  There are many good programmer editors out there.  UltraEdit,
MultiEdit, and the list goes on and on, give your money to something that is
stable and is not counterproductive.  Most of these editors have demos or
eval copies and can be customized to do whatever you like.  I have even read
that the new multiedit integrates into studio, not sure I would want that
but hey maybe it makes studio more stable.

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

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

OT: Access '97 repair log?

2001-03-13 Thread W Luke


Hi,

Just fixed a DB in Access 97 using the Repair function - is it possible to
see a log of what it fixed?

Thanks

Will

--
[EMAIL PROTECTED] -=- www.lukrative.com
Local-Advertising -=- www.localbounty.com


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

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

(Review) Conditional loops

2001-03-13 Thread Michael Dinowitz


I just did some more tests and I've got some more interesting results. The test 
was to compare conditional loops between the CFLOOP and the two conditional 
loops in CFSCRIPT (while and do-while). My tests showed that the CFSCRIPT 
statments were about twice as fast as the CFLOOP statment. This was my expected 
results. It looks like the only loop that is faster outside of CFSCRIPT is the 
for loop (from-to). 
For those who want to test my code and see my results, I've pasted it below. To 
do a real test, try a loop count of 1000, 1 or even higher. 

CFSET loopcount=0
CFSET start=GetTickCount()
CFLOOP condition="loopcount LTE 1000"
CFSET loopcount=loopcount+1
/CFLOOP
CFSET cf=gettickcount()-start
BR

CFSET loopcount=0
CFSET start=GetTickCount()
CFSCRIPT
while (loopcount LTE 1000)
loopcount=loopcount+1;
/CFSCRIPT
CFSET wh=gettickcount()-start
BR

CFSET loopcount=0
CFSET start=GetTickCount()
CFSCRIPT
do
loopcount=loopcount+1;
while (loopcount LTE 1000);
/CFSCRIPT
CFSET do=gettickcount()-start

HR
CFOUTPUT
CF-#cf#BR
While - #wh#BR
do-#do#
/CFOUTPUT

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

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

RE: CF Studio 4.5.2 Memory Leak?


-Original Message-
 CFSTUIDO 4.5.2 is not the most stable app in the world, and is
 very easy to
 crash (try closing a window with JS in the internal browser - and watch
 those error messages!!!)

I'm sorry, but "Well DUH!" - how are you meant to close a window that's
built in to the system?

Of course I'd not expect it to work - but I would expect it to gracefully
inform you, instead of crashing quite so dramatically - I laughed reading
the error messages you get...

I'd expect it to popup something like "You really are a thick T*** - do you
really expect to be able to do that within studio"

Just a little bit more  basic exception handling would be nice..

 Also - since upgrading to IE 5.5, memory usage seems to have gone through
 the roof... oten using over 50MB within a few hours of booting...

We've had to dump IE5.5 from most of our machines as it's so hungry -
combine that with WindowsMe and you've got a REAL winner...

Arggg...
I'm on NT4 with 128mb at work - and generally it takes about 1.5 days
between reboots...
I'm on 2000 at home with IE5 and 384Mb, and generally the only  time I need
to reboot is when I install / uninstall some old S/W - my system is often up
for weeks at a time...

I was going to upgrade to IE5.5 at home - but I think I might give it a miss
now...

I really dont like win9x (ME inc) at all...
Had to install single user CF Server and PWS on a 98 laptop for a client
yesterday - should have taken max 1/2 hour - but due to win98 crashing at
99.9% of the way through installing CF, in total I installed it 4 times (and
removed it 3 times).
Add to that, as soon as the machine tried to restart, it fatally locked up -
and no task manager to kill the problem tasks - had to powerdown and restart
(scandisk found an error on the disk at least once on reboot...)

If I had my own way - all the machines would have 2k on them... although I
might have a job on my laptop (cyrix 586 120 with 16Mb ram and a 750Mb
HD!)

*** Standard Joke time ***
The only way you could call Studio 4.5.2 stable is if you put a horse in
it!

Not bad :)

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

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

OLE DB vs. ODBC

2001-03-13 Thread S R


htmlDIVHi,/DIV
DIVnbsp;/DIV
DIVI've been told in the past that when using CF server and SQL Server to use OLE DB 
instead of ODBC when connecting to databases. I've never been told why? Is it faster? 
Another thing is they use ODBC where I work to connect to SQL Server databases and are 
asking me to create a test so that they can see the differences between the two. Which 
kind of tests would you create and is there going to be that much of a difference to 
show them?/DIV
DIVnbsp;/DIV
DIVThanks/DIV
DIVnbsp;/DIV
DIVSal/DIVbr clear=allhrGet your FREE download of MSN Explorer at a 
href="http://explorer.msn.com"http://explorer.msn.com/abr/p/html

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

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

TID errorlist

2001-03-13 Thread Joseph Thompson


Well, the post I sent to Allaire looking for the list of "TID" errors (and I
was thinking, maybe the definitions/solutions) came and went without an
answer.

Any one here know if there is such an animal?

What prompted me to ask was a TID=4100 error on a linux server. (not mine)


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

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

RE: (Review) Conditional loops


What do make of this then???
CFLOOP is (fairly substantially) quicker when you have 1,000,000
repetitions...

1,000,000 repetitions:

CF-34781
While - 50079
do-50391

100,000 repetitions:
===
CF-3360
While - 1859
do-1813 

10,000 repetitions:
==
CF-343
While - 172
do-188

1,000 repetitions:

CF-46
While - 16
do-16

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 13 March 2001 18:26
To: CF-Talk
Subject: (Review) Conditional loops


I just did some more tests and I've got some more interesting results. The
test 
was to compare conditional loops between the CFLOOP and the two conditional 
loops in CFSCRIPT (while and do-while). My tests showed that the CFSCRIPT 
statments were about twice as fast as the CFLOOP statment. This was my
expected 
results. It looks like the only loop that is faster outside of CFSCRIPT is
the 
for loop (from-to). 
For those who want to test my code and see my results, I've pasted it below.
To 
do a real test, try a loop count of 1000, 1 or even higher. 

CFSET loopcount=0
CFSET start=GetTickCount()
CFLOOP condition="loopcount LTE 1000"
CFSET loopcount=loopcount+1
/CFLOOP
CFSET cf=gettickcount()-start
BR

CFSET loopcount=0
CFSET start=GetTickCount()
CFSCRIPT
while (loopcount LTE 1000)
loopcount=loopcount+1;
/CFSCRIPT
CFSET wh=gettickcount()-start
BR

CFSET loopcount=0
CFSET start=GetTickCount()
CFSCRIPT
do
loopcount=loopcount+1;
while (loopcount LTE 1000);
/CFSCRIPT
CFSET do=gettickcount()-start

HR
CFOUTPUT
CF-#cf#BR
While - #wh#BR
do-#do#
/CFOUTPUT
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: (Review) Conditional loops

2001-03-13 Thread Garza, Jeff


Me thinks you are wrong...  Did you remember to change the loop count in the
CFLOOP to 1,000,000 as well?  Your results are awfully close to those of the
100,000 group.

1,000,000 on my machine... PIII 600MHz 782MB RAM
***
CF-44063
While - 28562
do-25297 

These results are inline with all the others.  Twice as fast in CFSCRIPT.

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

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



-Original Message-
From: Daniel Lancelot [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, March 13, 2001 11:37 AM
To: CF-Talk
Subject: RE: (Review) Conditional loops


What do make of this then???
CFLOOP is (fairly substantially) quicker when you have 1,000,000
repetitions...

1,000,000 repetitions:

CF-34781
While - 50079
do-50391

100,000 repetitions:
===
CF-3360
While - 1859
do-1813 

10,000 repetitions:
==
CF-343
While - 172
do-188

1,000 repetitions:

CF-46
While - 16
do-16

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 13 March 2001 18:26
To: CF-Talk
Subject: (Review) Conditional loops


I just did some more tests and I've got some more interesting results. The
test 
was to compare conditional loops between the CFLOOP and the two conditional 
loops in CFSCRIPT (while and do-while). My tests showed that the CFSCRIPT 
statments were about twice as fast as the CFLOOP statment. This was my
expected 
results. It looks like the only loop that is faster outside of CFSCRIPT is
the 
for loop (from-to). 
For those who want to test my code and see my results, I've pasted it below.
To 
do a real test, try a loop count of 1000, 1 or even higher. 

CFSET loopcount=0
CFSET start=GetTickCount()
CFLOOP condition="loopcount LTE 1000"
CFSET loopcount=loopcount+1
/CFLOOP
CFSET cf=gettickcount()-start
BR

CFSET loopcount=0
CFSET start=GetTickCount()
CFSCRIPT
while (loopcount LTE 1000)
loopcount=loopcount+1;
/CFSCRIPT
CFSET wh=gettickcount()-start
BR

CFSET loopcount=0
CFSET start=GetTickCount()
CFSCRIPT
do
loopcount=loopcount+1;
while (loopcount LTE 1000);
/CFSCRIPT
CFSET do=gettickcount()-start

HR
CFOUTPUT
CF-#cf#BR
While - #wh#BR
do-#do#
/CFOUTPUT
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: (Review) Conditional loops


Yeah - I checked that...

ran it again:

CF-33671
While - 27625
do-18782 

must have been some other factor...
-Original Message-
From: Garza, Jeff [mailto:[EMAIL PROTECTED]]
Sent: 13 March 2001 18:49
To: CF-Talk
Subject: RE: (Review) Conditional loops


Me thinks you are wrong...  Did you remember to change the loop count in the
CFLOOP to 1,000,000 as well?  Your results are awfully close to those of the
100,000 group.

1,000,000 on my machine... PIII 600MHz 782MB RAM
***
CF-44063
While - 28562
do-25297 

These results are inline with all the others.  Twice as fast in CFSCRIPT.

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

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



-Original Message-
From: Daniel Lancelot [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, March 13, 2001 11:37 AM
To: CF-Talk
Subject: RE: (Review) Conditional loops


What do make of this then???
CFLOOP is (fairly substantially) quicker when you have 1,000,000
repetitions...

1,000,000 repetitions:

CF-34781
While - 50079
do-50391

100,000 repetitions:
===
CF-3360
While - 1859
do-1813 

10,000 repetitions:
==
CF-343
While - 172
do-188

1,000 repetitions:

CF-46
While - 16
do-16

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 13 March 2001 18:26
To: CF-Talk
Subject: (Review) Conditional loops


I just did some more tests and I've got some more interesting results. The
test 
was to compare conditional loops between the CFLOOP and the two conditional 
loops in CFSCRIPT (while and do-while). My tests showed that the CFSCRIPT 
statments were about twice as fast as the CFLOOP statment. This was my
expected 
results. It looks like the only loop that is faster outside of CFSCRIPT is
the 
for loop (from-to). 
For those who want to test my code and see my results, I've pasted it below.
To 
do a real test, try a loop count of 1000, 1 or even higher. 

CFSET loopcount=0
CFSET start=GetTickCount()
CFLOOP condition="loopcount LTE 1000"
CFSET loopcount=loopcount+1
/CFLOOP
CFSET cf=gettickcount()-start
BR

CFSET loopcount=0
CFSET start=GetTickCount()
CFSCRIPT
while (loopcount LTE 1000)
loopcount=loopcount+1;
/CFSCRIPT
CFSET wh=gettickcount()-start
BR

CFSET loopcount=0
CFSET start=GetTickCount()
CFSCRIPT
do
loopcount=loopcount+1;
while (loopcount LTE 1000);
/CFSCRIPT
CFSET do=gettickcount()-start

HR
CFOUTPUT
CF-#cf#BR
While - #wh#BR
do-#do#
/CFOUTPUT
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Linking to URLs with Ampersands

2001-03-13 Thread Terra Durrant


Hello,

For our Web site, I use a ColdFusion redirect page to display a legal
disclaimer when linking to external sites.  To have this redirect text
appear in the template before the user leaves our site, I must use the
following format for a link tag:

A
HREF="#Session.TemplatePath#Template=Redirect.cfmLocation=http://www.leg.s
tate.co.us/2001/inetcbill.nsf/fsbillcont/F0ACA8F6AE0D6AE7872569BC005A272F?Op
enfile=001_rn2.pdf" TARGET="_blank"

Since ColdFusion uses the ampersand to define variables, I am running into
trouble linking to Web sites that use ampersands in their URLs.  Because of
the two variables previously defined in this tag, any of the URL after (and
including) an ampersand is deleted.  So, the above URL would be truncated
to:

http://www.leg.state.co.us/2001/inetcbill.nsf/fsbillcont/F0ACA8F6AE0D6AE7872
569BC005A272F?Open

Thus, rendering my link useless.  I have tried using CFOUTPUT tags, using
two ampersands, and using the HTML code for an ampersand to replace the
ampersand in the URL.  None of these options have worked.  Since the
redirect page isn't something I can just *not* use, I am wondering if any of
you have found an alternative way to deal with this issue.

Thanks in advance!

Terra Durrant
On-Line Specialist
American Collectors Association
(952) 928-8000, ext. 755
www.collector.com


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

RE: Javascript IsDefined

2001-03-13 Thread Caulfield, Michael

Actually typeof is an operator, not a function, so it is generally used the
way Dave described.

-Original Message-
From: Patricia Lee [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 11:51 AM
To: CF-Talk
Subject: RE: Javascript IsDefined

The correct syntax is
if (typeof(myvarname) == "undefined") {
[do your stuff]
}

|-Original Message-
|From: Hayes, David [mailto:[EMAIL PROTECTED]]
|Sent: Tuesday, March 13, 2001 10:32 AM
|To: CF-Talk
|Subject: RE: Javascript IsDefined
|
|
|You can use the "typeof" operator.
|
|if (typeof myVarName == "undefined"){
|
|}
|

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

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

Re: First crack at commerce, sort of.

2001-03-13 Thread Billy Cravens


I'd recommend taking a look at MSDE, which is essentially the engine behind SQL 
Server, just without the pretty
front end, and it easily upgrades to full-blown SQL Server.  You can use Access as the 
front end, but under the
scenes, it's SQL Server.

I say that because it may or may not be cost-justifiable to go to SQL Server for those 
(potentially) rare
situations when the concurrency is too much for Access.  That's true for MySQL also, 
since you'd need to buy a
second box (if you use the recommended version, which is on Linux).

However, I agree that your primary focus should be on how your code is written: on a 
properly optimized site,
concurrency won't be much of a problem.  I'll take a well written site using Access 
over a poorly written site with
SQL Server any day of the week.  Not to mention configuration headaches (You mean I 
was supposed to put a password
on "sa"?  doh)

Whatever you do, don't fall prey to the typical IT argument of simply throwing more 
hardware/software at a problem,
as opposed to analyzing all of the variables and finding the proper solution for your 
specific situation.

--
Billy Cravens
HR Web Development, Sabre
[EMAIL PROTECTED]



Jay Patton wrote:

 I would use SQL or MySQL for this NOT! Access

 Jay Patton
 Web Design / Application Design
 Web Pro USA
 406.549.3337 ext. 203
 1.888.5WEBPRO
 www.webpro-usa.com
 - Original Message -
 From: "Kortland, Brian" [EMAIL PROTECTED]
 To: "CF-Talk" [EMAIL PROTECTED]
 Sent: Tuesday, March 13, 2001 9:19 AM
 Subject: First crack at commerce, sort of.

  This message is in MIME format. Since your mail reader does not understand
  this format, some or all of this message may not be legible.
 
  --_=_NextPart_001_01C0ABD9.673F79C0
  Content-Type: text/plain;
  charset="iso-8859-1"
 
  Hi All,
 
  I have a number of small clients who mostly have very basic Cold Fusion
  driven sites. I have a potential new client (a Deli) who has corporate
  customers that want to have access his menus and place orders online. He
  does not yet want full blown e-commerce with CC transactions but does want
  to allow about 1,000 users into the site to place orders on a daily basis.
  For my smaller sites I have used Access 2000 and have not had problems.
 With
  this new client I have concerns regarding concurrent hits to the DB to
 pull
  menu items and to capture and archive orders. Most things I have read
 state
  that Access 97 is not to be used for even moderate traffic sites, but I
 have
  seen claims by MicroSoft that Access 2000 is more robust. Is this just
 hype?
 
  Should my menus, order info, and security all be kept in separate
 databases?
 
  If anyone has any other advice based on my scenario I'd love to hear it.
 
  Brian Kortland
  Cyberplugs.com
 
  --_=_NextPart_001_01C0ABD9.673F79C0
  Content-Type: text/html;
  charset="iso-8859-1"
 
  !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"
  HTML
  HEAD
  META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"
  META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2654.19"
  TITLEFirst crack at commerce, sort of./TITLE
  /HEAD
  BODY
 
  PFONT SIZE=2Hi All,/FONT
  /P
 
  PFONT SIZE=2I have a number of small clients who mostly have very
 basic Cold Fusion/FONT
  BRFONT SIZE=2driven sites. I have a potential new client (a Deli) who
 has corporate/FONT
  BRFONT SIZE=2customers that want to have access his menus and place
 orders online. He/FONT
  BRFONT SIZE=2does not yet want full blown e-commerce with CC
 transactions but does want/FONT
  BRFONT SIZE=2to allow about 1,000 users into the site to place orders
 on a daily basis./FONT
  BRFONT SIZE=2For my smaller sites I have used Access 2000 and have not
 had problems. With/FONT
  BRFONT SIZE=2this new client I have concerns regarding concurrent hits
 to the DB to pull/FONT
  BRFONT SIZE=2menu items and to capture and archive orders. Most things
 I have read state/FONT
  BRFONT SIZE=2that Access 97 is not to be used for even moderate
 traffic sites, but I have/FONT
  BRFONT SIZE=2seen claims by MicroSoft that Access 2000 is more robust.
 Is this just hype?/FONT
  /P
 
  PFONT SIZE=2Should my menus, order info, and security all be kept in
 separate databases?/FONT
  /P
 
  PFONT SIZE=2If anyone has any other advice based on my scenario I'd
 love to hear it./FONT
  /P
 
  PFONT SIZE=2Brian Kortland/FONT
  BRFONT SIZE=2Cyberplugs.com/FONT
  /P
 
  /BODY
  /HTML
  --_=_NextPart_001_01C0ABD9.673F79C0--
 
  Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
  Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
 


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

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

RE: one more Paradox question...

2001-03-13 Thread Hoffman, Joe (CIT)


Try http://www.merant.com/

Joe Hoffman mailto:[EMAIL PROTECTED]
National Institutes of Health 
Center for Information Technology 
Division of Computer System Services

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 12:31 PM
To: CF-Talk
Subject: one more Paradox question...


Ok we are going to be connecting to a Paradox 4.5 systemyes i
knowoldbut besides that, i know that the M$ ODBC driver will lock
the tables and mess everything up... :oP   so has anyone worked with this
and found a better ODBC driver?   

TIA

Kevin

~
Kevin Mansel
Web Developer
Fox Communications
[EMAIL PROTECTED]


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

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

RE: Javascript IsDefined

2001-03-13 Thread Patricia Lee


Ah... I stand corrected.  I'll have to give that way a shot.  The person who
informed me of it used that syntax and it's worked for me but now I know
better.

|-Original Message-
|From: Caulfield, Michael [mailto:[EMAIL PROTECTED]]
|Sent: Tuesday, March 13, 2001 2:11 PM
|To: CF-Talk
|Subject: RE: Javascript IsDefined
|
|
|Actually typeof is an operator, not a function, so it is 
|generally used the
|way Dave described.
|
|-Original Message-
|From: Patricia Lee [mailto:[EMAIL PROTECTED]]
|Sent: Tuesday, March 13, 2001 11:51 AM
|To: CF-Talk
|Subject: RE: Javascript IsDefined
|
|
|The correct syntax is
|if (typeof(myvarname) == "undefined") {
|   [do your stuff]
|}
|
||-Original Message-
||From: Hayes, David [mailto:[EMAIL PROTECTED]]
||Sent: Tuesday, March 13, 2001 10:32 AM
||To: CF-Talk
||Subject: RE: Javascript IsDefined
||
||
||You can use the "typeof" operator.
||
||if (typeof myVarName == "undefined"){
||
||}
||
|
|
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

What Version of LDAP server to use for Win 2000

2001-03-13 Thread Vance Duke


Question for those of you using the LDAP server and CF.  What version are
you using for Win 2000?  I looked at the Netscape site, and version 4.12 and
4.13 of iPlanet Directory Server (the successor to the LDAP server) is not
supported for Win 2000; and version 5, which does support Win 2000, is still
beta.  I am looking to try it out and play with it and would like some
insight for what version people are running on Win 2000.

Thanks,
Vance Duke



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

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

Re: Linking to URLs with Ampersands

2001-03-13 Thread Al Musella, DPM

Just use urlencodedformat() around the URl.
in your case:

A
HREF="#Session.TemplatePath#Template=Redirect.cfmLocation=#urlencodedformat(http://www.leg.s
tate.co.us/2001/inetcbill.nsf/fsbillcont/F0ACA8F6AE0D6AE7872569BC005A272F?Op
enfile=001_rn2.pdf)#" TARGET="_blank"

Another possibility, and the way I always use, is to hold all of the links
in a database. In your situation, just pass the link ID, and look it up on
the redirect page. I do this to keep track of how many times people click
a link, as well as let people rate the links' importance.
see virtualtrials.com/links.cfm for it in action!

Al Musella, DPM
A1webs.com

At 01:06 PM 3/13/2001 -0600, you wrote:
Hello,

For our Web site, I use a ColdFusion redirect page to display a legal
disclaimer when linking to external sites. To have this redirect text
appear in the template before the user leaves our site, I must use the
following format for a link tag:

A
HREF="#Session.TemplatePath#Template=Redirect.cfmLocation=http://www.leg.s
tate.co.us/2001/inetcbill.nsf/fsbillcont/F0ACA8F6AE0D6AE7872569BC005A272F?Op
enfile=001_rn2.pdf" TARGET="_blank"

Since ColdFusion uses the ampersand to define variables, I am running into
trouble linking to Web sites that use ampersands in their URLs. Because of
the two variables previously defined in this tag, any of the URL after (and
including) an ampersand is deleted. So, the above URL would be truncated
to:

http://www.leg.state.co.us/2001/inetcbill.nsf/fsbillcont/F0ACA8F6AE0D6AE7872
569BC005A272F?Open

Thus, rendering my link useless. I have tried using CFOUTPUT tags, using
two ampersands, and using the HTML code for an ampersand to replace the
ampersand in the URL. None of these options have worked. Since the
redirect page isn't something I can just *not* use, I am wondering if any of
you have found an alternative way to deal with this issue.

Thanks in advance!

Terra Durrant
On-Line Specialist
American Collectors Association
(952) 928-8000, ext. 755
www.collector.com

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

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

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

Re: SNMP and CF

2001-03-13 Thread Jon Hall


I dont believe there will be until version 5 comes out. The current beta
does include the MIB scripts though.
I am not 100% on this, but the current CF 4.5 Enterprise does include a
cluster monitoring utitlity that might be able to be used to monitor CF
server. I saw it once, and it had a lot of information about the servers on
the screen.

I think the best way for now would be to monitor the cfserver processs
through Windows SNMP...

jon
- Original Message -
From: "Lewis Steven" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, March 13, 2001 9:30 AM
Subject: SNMP and CF


 Is there a way to monitor CF using SNMP right now?


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

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

Re: (Review) Conditional loops

2001-03-13 Thread Michael Dinowitz


I tried out your suggestion of using an evaluation vs. a variable rather than 
against a number and the results moved from CFSCRIPT being twice as fast to it 
only being about a third as fast. I only tested on 1,000 and 10,000. 
 
 My understanding was that loops inside a CFSCRIPT slowed considerably when 
the 
 loop included the evaluation of a variable.
 
 Like this:
 
 CFSCRIPT
 loopcount=0;
 loopend=1000 ---  New
 start=GetTickCount();
 
 
 do
   loopcount=loopcount+1;
 while (loopcount LTE loopend);--- Changed
 do=gettickcount()-start
 /CFSCRIPT
 


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

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

Form Fields cleared on Back

2001-03-13 Thread Adrian Cesana


Im going nuts trying to figure this one out, I have a form with about 110
fields (ya i know), there is lots of server side validation, if an input
error occurs I CFABORT and give the user a JavaScript back button to go back
an correct the input.  On some users PC the form gets cleared on other PC's
it does not.  I also use some of the CF built in validation (_required) so
the user has to use the browser back button, same thing happens on some of
these peoples browsers.  Of coarse it does not happen on mine.  I setup a
few test forms for the problems users and it things work ok.  These users
are all using IE 5.x, any one else have such problems, could it be the large
number of INPUT fields? any browser settings? registry settings? Voodoo
dances? anything?

Thanks,Adrian



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

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

Re: What Version of LDAP server to use for Win 2000

2001-03-13 Thread Douglas Knudsen




Isn't that thingy called Active Directory LDAP compliant?  Not
suggesting using it, just thinking outloud here.


-
Douglas Knudsen
Leveraged Technologies Group
678-351-6063
Got Linux? http://linuxmall.com




From: [EMAIL PROTECTED] AT INTERNET on 03/13/2001 02:34 PM

To:   [EMAIL PROTECTED] AT INTERNET@CCMAIL
cc:(bcc: Douglas Knudsen/ATL/ALLTELCORP)

Subject:  What Version of LDAP server to use for Win 2000


Question for those of you using the LDAP server and CF.  What version
are
you using for Win 2000?  I looked at the Netscape site, and version
4.12 and
4.13 of iPlanet Directory Server (the successor to the LDAP server) is
not
supported for Win 2000; and version 5, which does support Win 2000, is
still
beta.  I am looking to try it out and play with it and would like some
insight for what version people are running on Win 2000.

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

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

Re: Form Fields cleared on Back

2001-03-13 Thread S R

I've found that this is something that happens on IE5. Netscape doesn't do 
this. The only way I've gotten around is to painstakingly include a bunch of 
'hidden' form fields that way when the user presses the back button it 
repopulates the form.

From: "Adrian Cesana" [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: Form Fields cleared on Back
Date: Tue, 13 Mar 2001 11:46:49 -0800

Im going nuts trying to figure this one out, I have a form with about 110
fields (ya i know), there is lots of server side validation, if an input
error occurs I CFABORT and give the user a JavaScript back button to go 
back
an correct the input.  On some users PC the form gets cleared on other PC's
it does not.  I also use some of the CF built in validation (_required) so
the user has to use the browser back button, same thing happens on some of
these peoples browsers.  Of coarse it does not happen on mine.  I setup a
few test forms for the problems users and it things work ok.  These users
are all using IE 5.x, any one else have such problems, could it be the 
large
number of INPUT fields? any browser settings? registry settings? Voodoo
dances? anything?

Thanks,Adrian

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

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

RE: (Review) Conditional loops

2001-03-13 Thread Top-Link Tech (John Ceci)


1,000,000 on my machine... PIII 750MHz 512MB RAM
===
CF-64360
While - 34062
do-31563



-Original Message-
From: Garza, Jeff [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 12:49 PM
To: CF-Talk
Subject: RE: (Review) Conditional loops


Me thinks you are wrong...  Did you remember to change the loop count in the
CFLOOP to 1,000,000 as well?  Your results are awfully close to those of the
100,000 group.

1,000,000 on my machine... PIII 600MHz 782MB RAM
***
CF-44063
While - 28562
do-25297

These results are inline with all the others.  Twice as fast in CFSCRIPT.

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

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



-Original Message-
From: Daniel Lancelot [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 11:37 AM
To: CF-Talk
Subject: RE: (Review) Conditional loops


What do make of this then???
CFLOOP is (fairly substantially) quicker when you have 1,000,000
repetitions...

1,000,000 repetitions:

CF-34781
While - 50079
do-50391

100,000 repetitions:
===
CF-3360
While - 1859
do-1813

10,000 repetitions:
==
CF-343
While - 172
do-188

1,000 repetitions:

CF-46
While - 16
do-16

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 13 March 2001 18:26
To: CF-Talk
Subject: (Review) Conditional loops


I just did some more tests and I've got some more interesting results. The
test
was to compare conditional loops between the CFLOOP and the two conditional
loops in CFSCRIPT (while and do-while). My tests showed that the CFSCRIPT
statments were about twice as fast as the CFLOOP statment. This was my
expected
results. It looks like the only loop that is faster outside of CFSCRIPT is
the
for loop (from-to).
For those who want to test my code and see my results, I've pasted it below.
To
do a real test, try a loop count of 1000, 1 or even higher.

CFSET loopcount=0
CFSET start=GetTickCount()
CFLOOP condition="loopcount LTE 1000"
CFSET loopcount=loopcount+1
/CFLOOP
CFSET cf=gettickcount()-start
BR

CFSET loopcount=0
CFSET start=GetTickCount()
CFSCRIPT
while (loopcount LTE 1000)
loopcount=loopcount+1;
/CFSCRIPT
CFSET wh=gettickcount()-start
BR

CFSET loopcount=0
CFSET start=GetTickCount()
CFSCRIPT
do
loopcount=loopcount+1;
while (loopcount LTE 1000);
/CFSCRIPT
CFSET do=gettickcount()-start

HR
CFOUTPUT
CF-#cf#BR
While - #wh#BR
do-#do#
/CFOUTPUT
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

Another Note RE: CF Studio 4.5.2 Memory Leak?


Not to keep this going but I have observed one other problem.

when you deploy a project and it scrolls through line by line the speed at
which it deploys changes if you drag the results window away from the bottom
of CF Studio  

An example I did was to minimize the window to one line of text and it took
10 sec  then I almost maxed out the window and it to 1min and 1 sec  Then I
minimized it to where you could not see the text and it took 9 sec?

What is up with this?

Nathan



 -Original Message-
 From: Daniel Lancelot [SMTP:[EMAIL PROTECTED]]
 Sent: Tuesday, March 13, 2001 12:25 PM
 To:   CF-Talk
 Subject:  RE: CF Studio 4.5.2 Memory Leak?
 
 -Original Message-
  CFSTUIDO 4.5.2 is not the most stable app in the world, and is
  very easy to
  crash (try closing a window with JS in the internal browser - and watch
  those error messages!!!)
 
 I'm sorry, but "Well DUH!" - how are you meant to close a window that's
 built in to the system?
 
 Of course I'd not expect it to work - but I would expect it to gracefully
 inform you, instead of crashing quite so dramatically - I laughed reading
 the error messages you get...
 
 I'd expect it to popup something like "You really are a thick T*** - do
 you
 really expect to be able to do that within studio"
 
 Just a little bit more  basic exception handling would be nice..
 
  Also - since upgrading to IE 5.5, memory usage seems to have gone
 through
  the roof... oten using over 50MB within a few hours of booting...
 
 We've had to dump IE5.5 from most of our machines as it's so hungry -
 combine that with WindowsMe and you've got a REAL winner...
 
 Arggg...
 I'm on NT4 with 128mb at work - and generally it takes about 1.5 days
 between reboots...
 I'm on 2000 at home with IE5 and 384Mb, and generally the only  time I
 need
 to reboot is when I install / uninstall some old S/W - my system is often
 up
 for weeks at a time...
 
 I was going to upgrade to IE5.5 at home - but I think I might give it a
 miss
 now...
 
 I really dont like win9x (ME inc) at all...
 Had to install single user CF Server and PWS on a 98 laptop for a client
 yesterday - should have taken max 1/2 hour - but due to win98 crashing at
 99.9% of the way through installing CF, in total I installed it 4 times
 (and
 removed it 3 times).
 Add to that, as soon as the machine tried to restart, it fatally locked up
 -
 and no task manager to kill the problem tasks - had to powerdown and
 restart
 (scandisk found an error on the disk at least once on reboot...)
 
 If I had my own way - all the machines would have 2k on them... although I
 might have a job on my laptop (cyrix 586 120 with 16Mb ram and a 750Mb
 HD!)
 
 *** Standard Joke time ***
 The only way you could call Studio 4.5.2 stable is if you put a horse in
 it!
 
 Not bad :)
 

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

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

RE: (Review) Conditional loops

2001-03-13 Thread Garza, Jeff


I forgot to mention that I'm running CF5.0.  So that may have influenced the
results.  I'll have to try again on a 4.5.2 machine.

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

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


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, March 13, 2001 1:51 PM
To: CF-Talk
Subject: RE: (Review) Conditional loops


1,000,000 on my machine... PIII 750MHz 512MB RAM
===
CF-64360
While - 34062
do-31563



-Original Message-
From: Garza, Jeff [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 12:49 PM
To: CF-Talk
Subject: RE: (Review) Conditional loops


Me thinks you are wrong...  Did you remember to change the loop count in the
CFLOOP to 1,000,000 as well?  Your results are awfully close to those of the
100,000 group.

1,000,000 on my machine... PIII 600MHz 782MB RAM
***
CF-44063
While - 28562
do-25297

These results are inline with all the others.  Twice as fast in CFSCRIPT.

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

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



-Original Message-
From: Daniel Lancelot [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 11:37 AM
To: CF-Talk
Subject: RE: (Review) Conditional loops


What do make of this then???
CFLOOP is (fairly substantially) quicker when you have 1,000,000
repetitions...

1,000,000 repetitions:

CF-34781
While - 50079
do-50391

100,000 repetitions:
===
CF-3360
While - 1859
do-1813

10,000 repetitions:
==
CF-343
While - 172
do-188

1,000 repetitions:

CF-46
While - 16
do-16

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 13 March 2001 18:26
To: CF-Talk
Subject: (Review) Conditional loops


I just did some more tests and I've got some more interesting results. The
test
was to compare conditional loops between the CFLOOP and the two conditional
loops in CFSCRIPT (while and do-while). My tests showed that the CFSCRIPT
statments were about twice as fast as the CFLOOP statment. This was my
expected
results. It looks like the only loop that is faster outside of CFSCRIPT is
the
for loop (from-to).
For those who want to test my code and see my results, I've pasted it below.
To
do a real test, try a loop count of 1000, 1 or even higher.

CFSET loopcount=0
CFSET start=GetTickCount()
CFLOOP condition="loopcount LTE 1000"
CFSET loopcount=loopcount+1
/CFLOOP
CFSET cf=gettickcount()-start
BR

CFSET loopcount=0
CFSET start=GetTickCount()
CFSCRIPT
while (loopcount LTE 1000)
loopcount=loopcount+1;
/CFSCRIPT
CFSET wh=gettickcount()-start
BR

CFSET loopcount=0
CFSET start=GetTickCount()
CFSCRIPT
do
loopcount=loopcount+1;
while (loopcount LTE 1000);
/CFSCRIPT
CFSET do=gettickcount()-start

HR
CFOUTPUT
CF-#cf#BR
While - #wh#BR
do-#do#
/CFOUTPUT
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

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

RE: Form Fields cleared on Back

it is DEFINITLEY the large number of input fields.  i had a problem like
that once, where i allowed the admin to enter different events for different
artists as many times as they wanted.  anything about 20 times made the page
work wierd, so i limited to 10 times only.  hehe

-Original Message-
From: Adrian Cesana [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 1:47 PM
To: CF-Talk
Subject: Form Fields cleared on Back

Im going nuts trying to figure this one out, I have a form with about 110
fields (ya i know), there is lots of server side validation, if an input
error occurs I CFABORT and give the user a JavaScript back button to go back
an correct the input.  On some users PC the form gets cleared on other PC's
it does not.  I also use some of the CF built in validation (_required) so
the user has to use the browser back button, same thing happens on some of
these peoples browsers.  Of coarse it does not happen on mine.  I setup a
few test forms for the problems users and it things work ok.  These users
are all using IE 5.x, any one else have such problems, could it be the large
number of INPUT fields? any browser settings? registry settings? Voodoo
dances? anything?

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

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

RE: Form Fields cleared on Back

2001-03-13 Thread Jason Aden


What type of inputs are they? I know that IE will clear password fields when
you hit the browser back button.

Jason


Jason Aden
Allaire Certified Developer
[EMAIL PROTECTED]
www.wwstudios.com

 -Original Message-
 From: Adrian Cesana [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, March 13, 2001 2:47 PM
 To: CF-Talk
 Subject: Form Fields cleared on Back


 Im going nuts trying to figure this one out, I have a form with about 110
 fields (ya i know), there is lots of server side validation, if an input
 error occurs I CFABORT and give the user a JavaScript back button
 to go back
 an correct the input.  On some users PC the form gets cleared on
 other PC's
 it does not.  I also use some of the CF built in validation (_required) so
 the user has to use the browser back button, same thing happens on some of
 these peoples browsers.  Of coarse it does not happen on mine.  I setup a
 few test forms for the problems users and it things work ok.  These users
 are all using IE 5.x, any one else have such problems, could it
 be the large
 number of INPUT fields? any browser settings? registry settings? Voodoo
 dances? anything?

 Thanks,Adrian




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

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

RE: Form Fields cleared on Back

2001-03-13 Thread Maia, Eric


The way I do it is to first create a structure with all of the form field
preloads (if editing a record) or all blank values (if a new record). I use
this struct to populate the form fields. 

Then, if there's an error detected upon submittal, I load the form data into
the struct (so it'll keep their new entries), and save the struct in a
session variable. I also save any error messages in a session variable.

That way, when I reload the form, I just check to see if the session
variables are defined, and if they are, display the error messages and grab
the struct from the session variable to re-populate the form fields.

(I also make sure to clear the session variable once the validation passes,
so they don't get any incorrect error messages if they go back to the form.)

Eric

-Original Message-
From: S R [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 11:51 AM
To: CF-Talk
Subject: Re: Form Fields cleared on Back


I've found that this is something that happens on IE5. Netscape doesn't do 
this. The only way I've gotten around is to painstakingly include a bunch of

'hidden' form fields that way when the user presses the back button it 
repopulates the form.


From: "Adrian Cesana" [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: Form Fields cleared on Back
Date: Tue, 13 Mar 2001 11:46:49 -0800

Im going nuts trying to figure this one out, I have a form with about 110
fields (ya i know), there is lots of server side validation, if an input
error occurs I CFABORT and give the user a JavaScript back button to go 
back
an correct the input.  On some users PC the form gets cleared on other PC's
it does not.  I also use some of the CF built in validation (_required) so
the user has to use the browser back button, same thing happens on some of
these peoples browsers.  Of coarse it does not happen on mine.  I setup a
few test forms for the problems users and it things work ok.  These users
are all using IE 5.x, any one else have such problems, could it be the 
large
number of INPUT fields? any browser settings? registry settings? Voodoo
dances? anything?

Thanks,Adrian




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

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

Broken Images / Testing for file existence

2001-03-13 Thread Tony Schreiber


I have an application where I list several items on a page and display an
image for that item based on a reference number (ie, productnum+.jpg). The
database table does not tell me whether there is an image for that item
and there are many that do have one.

I'd like to display an alternate image (or nothing at all) when there is
no image present, but I can't see using an CFIF FileExists for every
item for 50 or so on a page. Plus, I can't even do that because I'm
grabbing the images from a different server via http only (IMG
SRC="http://otherserver/path/number.jpg)...

How can I avoid displaying broken images?


Tony Schreiber, Senior Partner  Man and Machine, Limited
mailto:[EMAIL PROTECTED]   http://www.technocraft.com

http://www.linktoss.com ___The Fastest Way to Send a Link to Anyone!
http://www.digitacamera.com __DigitA Camera Scripts and Tips
http://www.is300.net ___The Enthusiast's Home of the Lexus IS300
http://www.cfug-sfl.org ___South Florida Cold Fusion Users Group
http://www.simplemessageboard.com ___Free Forum Software for Cold Fusion


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

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

RE: Form Fields cleared on Back

2001-03-13 Thread Bryan Love


I've come up with a very handy solution to this...

IF you use fusebox try this (I call it stacking):


cfcase value="bugList"
cfinclude template="act_deleteBugs.cfm"
cfinclude template="../dsp_header.cfm"
cfinclude template="qry_getBugs.cfm"
cfinclude template="qry_getUsers.cfm"
cfinclude template="dsp_BugList.cfm"
cfinclude template="../dsp_footer.cfm"
/cfcase

the ACT_DELETEBUGS.CFM template only runs if the form fields from
DSP_BUGLIST.CFM are defined (if the form has been submitted).  

Inside the action fuse is where the form validation occurrs.  At the end of
this fuse I check to see if an error occurred - relocate to the next step if
no errors, otherwise drop right on through where the form will appear again
populated with it's own values.

In DSP_BUGLIST.CFM you'll need to put an if statement to default the form
values for the first time through.

Works like a charm! 


Bryan Love ACP
Internet Application Developer
[EMAIL PROTECTED]



-Original Message-
From: Adrian Cesana [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 11:47 AM
To: CF-Talk
Subject: Form Fields cleared on Back


Im going nuts trying to figure this one out, I have a form with about 110
fields (ya i know), there is lots of server side validation, if an input
error occurs I CFABORT and give the user a JavaScript back button to go back
an correct the input.  On some users PC the form gets cleared on other PC's
it does not.  I also use some of the CF built in validation (_required) so
the user has to use the browser back button, same thing happens on some of
these peoples browsers.  Of coarse it does not happen on mine.  I setup a
few test forms for the problems users and it things work ok.  These users
are all using IE 5.x, any one else have such problems, could it be the large
number of INPUT fields? any browser settings? registry settings? Voodoo
dances? anything?

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

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

RE: Form Fields cleared on Back PART 2