Re: (Admin) Machine move
The TTL is the Time-To-Live of the DNS information from your DNS servers, it means how long the information remains valid before the DNS server requesting the info will consider old and request new info. If you drop your TTL's to like 60 minutes a few days before the move, then name servers around the net will start to have the 60 min TTL's in cache and request a new ip within an hour. Essentially, once the move takes place, you'd only have an hour of time with old ip info around the net. Once the move is complete, change your TTL back to 24 hours or whatever your default value is... > I don't exactly understand what you mean. > > > > Sounds great! Would not lowering the ttl values on the domain for the > > few days preceding the move stop any dns outages from occuring in the > > first place? > > > > jon > > > > Michael Dinowitz wrote: > > > > >CFHosting.com, a major supporter of the House of Fusion lists and the > host of our box will be moving said box to a new location (with higher > bandwidth). This will result in an outage of mail for a few hours today > (Sunday Sept. 30) and will probably result in some small DNS problems in the > next 2 or 3 days as it propagates. > > > > > > ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: (Admin) Machine move
I don't exactly understand what you mean. > Sounds great! Would not lowering the ttl values on the domain for the > few days preceding the move stop any dns outages from occuring in the > first place? > > jon > > Michael Dinowitz wrote: > > >CFHosting.com, a major supporter of the House of Fusion lists and the host of our box will be moving said box to a new location (with higher bandwidth). This will result in an outage of mail for a few hours today (Sunday Sept. 30) and will probably result in some small DNS problems in the next 2 or 3 days as it propagates. > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: (Admin) Machine move
Sounds great! Would not lowering the ttl values on the domain for the few days preceding the move stop any dns outages from occuring in the first place? jon Michael Dinowitz wrote: >CFHosting.com, a major supporter of the House of Fusion lists and the host of our box >will be moving said box to a new location (with higher bandwidth). This will result >in an outage of mail for a few hours today (Sunday Sept. 30) and will probably result >in some small DNS problems in the next 2 or 3 days as it propagates. > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Points of failure for session variables
Thanks, Jim. No cookies. No clusters. -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 30, 2001 5:39 PM To: CF-Talk Subject: Re: Points of failure for session variables If you're relying on cookies to implement session variables, then there are a lot of ways that cookies can be blocked or otherwise not passed from server to client or vise versa. Hardware firewalls, software firewalls, proxy servers, browser settings are a few. Then there are issues at the server end... clustering, load balancing. Jim ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Points of failure for session variables
I have a question semi related. I am studying CF while I finish up school and was getting into how an e-commerce site works in terms of sessions and what not. In an e-commerce site, is it best to not use cookies at all? What is a good approach to an e-commerce site? Mike - Original Message - From: "Jim McAtee" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, September 30, 2001 8:39 PM Subject: Re: Points of failure for session variables > If you're relying on cookies to implement session variables, then there are > a lot of ways that cookies can be blocked or otherwise not passed from > server to client or vise versa. Hardware firewalls, software firewalls, > proxy servers, browser settings are a few. Then there are issues at the > server end... clustering, load balancing. > > Jim > > > - Original Message - > From: <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Sunday, September 30, 2001 6:30 PM > Subject: Points of failure for session variables > > > > Of course I've used system variables several times in the past, but never > in > > an application where their proper functioning is absolutely necessary, > until > > now. > > > > The application I'm building now relies heavily on session variables and > > will fail if variables are not properly passed. > > > > Of course, I'm using CFLock around all session variables (both read and > > write). > > > > Besides that, I'm wondering are their other problems to look and plan for? > > Is it possible that session variables will not work with some clients? If > > so, under what conditions. How do you plan for such possible failures? > > > > I just want to do my best to cover all of the bases here. > > > > H. > ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT: Unicode
Has anyone had abny experience with Unicode-based dynamic web sites? It seems to me that Unicode is the only option when dealing with a one-system multilingual site that stores Japanese/Chinese/etc information.. Can you convert a Double-byte record to Unicode? --- Regards, Darryl Lyons Senior Systems Developer Fuzion: http://www.fuzion.com.au Email : [EMAIL PROTECTED] Phone : (07) 3620 1000 Fax : (07) 3620 1001 Technical Support : 1300 888 480 'merging business + technology' ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Points of failure for session variables
If you're relying on cookies to implement session variables, then there are a lot of ways that cookies can be blocked or otherwise not passed from server to client or vise versa. Hardware firewalls, software firewalls, proxy servers, browser settings are a few. Then there are issues at the server end... clustering, load balancing. Jim - Original Message - From: <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, September 30, 2001 6:30 PM Subject: Points of failure for session variables > Of course I've used system variables several times in the past, but never in > an application where their proper functioning is absolutely necessary, until > now. > > The application I'm building now relies heavily on session variables and > will fail if variables are not properly passed. > > Of course, I'm using CFLock around all session variables (both read and > write). > > Besides that, I'm wondering are their other problems to look and plan for? > Is it possible that session variables will not work with some clients? If > so, under what conditions. How do you plan for such possible failures? > > I just want to do my best to cover all of the bases here. > > H. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Points of failure for session variables
Of course I've used system variables several times in the past, but never in an application where their proper functioning is absolutely necessary, until now. The application I'm building now relies heavily on session variables and will fail if variables are not properly passed. Of course, I'm using CFLock around all session variables (both read and write). Besides that, I'm wondering are their other problems to look and plan for? Is it possible that session variables will not work with some clients? If so, under what conditions. How do you plan for such possible failures? I just want to do my best to cover all of the bases here. H. ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Using CFLoop to delete from an Array 2
yes, I tried it. I pretty much went through all of the Array functions (at least those that seemed logical to try) and got the same results. H. -Original Message- From: Kevin Langevin [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 30, 2001 5:03 PM To: CF-Talk Subject: RE: Using CFLoop to delete from an Array 2 How about trying the Arraylen() function? Kevin Langevin Web Guy in Charge UsWebGuys 954-327-5780 [EMAIL PROTECTED] ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Using CFLoop to delete from an Array 2
How about trying the Arraylen() function? Kevin Langevin Web Guy in Charge UsWebGuys 954-327-5780 [EMAIL PROTECTED] > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Sunday, September 30, 2001 8:07 PM > To: CF-Talk > Subject: RE: Using CFLoop to delete from an Array 2 > > > OK, > > Now that I've got the multiple deletes from the array working > (thanks, guys) > .. I've got a problem when every element in the array is deleted > (an option > a user could conceivably take). > > There is later on the page, of course, code that assumes there is going to > be information in the array to read. If everything in the array > is deleted, > then there's an error. > > The obvious thing to do is set up some sort of conditional to > find that the > array has been cleared of all items, but I'm having trouble finding the > right syntax. > > I've tried things like: > > > the array is empty > > > And variations of other conditional tests and I repeatedly get this error > message: > > "The element at position 1 in dimension 1 of object > "session.cart" cannot > be found. > The object has elements in positions 1 through 1. Please, > modify the index > expression. > > So I've run out of ideas to try to catch this now empty array and > through up > some appropriate HTML. > > H. > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Using CFLoop to delete from an Array 2
OK, Now that I've got the multiple deletes from the array working (thanks, guys) .. I've got a problem when every element in the array is deleted (an option a user could conceivably take). There is later on the page, of course, code that assumes there is going to be information in the array to read. If everything in the array is deleted, then there's an error. The obvious thing to do is set up some sort of conditional to find that the array has been cleared of all items, but I'm having trouble finding the right syntax. I've tried things like: the array is empty And variations of other conditional tests and I repeatedly get this error message: "The element at position 1 in dimension 1 of object "session.cart" cannot be found. The object has elements in positions 1 through 1. Please, modify the index expression. So I've run out of ideas to try to catch this now empty array and through up some appropriate HTML. H. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Unexpected query results
Sure can you reference 4 tables in your from clause and in your where clause
you are only joining 2 of the tables :
> u.user_id *= dn.user_id
So all the tables that you didn't restrict in your join are build you a
cartesian join. To avoid this kind of error use the ANSI JOIN sytax. I
tried to write an example for you below but I didn't have all the
information to really fill it out, but you should get the idea.
-eric
SELECT
u.first_nm,
u.last_nm,
c.category_nm,
c.category_id,
c.dataType,
c.department_id,
dn.date_dt,
SUM(dn.quantity_nb)AS totalForMonth,
g.goal_nb
FROM
tblUsers u,
INNER JOIN
tblDailyNumbers dn ON u.user_id = dn.user_id
INNER JOIN
tblGoals g ON g. = __.___
INNER JOIN
tblcategories c ON c. = ___._
WHERE
DatePart("mm", dn.date_dt) = 9 AND
DatePart("yy", dn.date_dt) = 2001
GROUP BY u.last_nm,
c.category_nm,
c.category_id,
c.department_id,
g.goal_nb,
c.dataType,
ufirst_nm,
dn.date_dt
- Original Message -
From: "John Barleycorn" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Sunday, September 30, 2001 5:40 PM
Subject: Unexpected query results
> Hello everyone, i'm currently running a query that is returning some odd
> results. I'm trying to get the total number of sales in each category for
a
> salesperson. The query i'm running is below. With the data i have right
now
> i would expect to get back 4 for the total of sales per category for the
> month indicated. I am however, getting back a total of 144. Can anyone
tell
> me what it is that is incorrect in my SQL statement that would cause this?
> Thank you for your help.
>
> j
>
> SELECT
> u.first_nm
> , u.last_nm
> , c.category_nm
> , c.category_id
> , c.dataType
> , c.department_id
> , dn.date_dt
> , SUM(dn.quantity_nb)AS totalForMonth
> , g.goal_nb
> FROM
> tblcategories c
> , tblDailyNumbers dn
> , tblUsers u
> , tblGoals g
> WHERE
> DatePart("mm", dn.date_dt) = 9
> AND
> DatePart("yy", dn.date_dt) = 2001
> AND
> u.user_id *= dn.user_id
> GROUP BY u.last_nm
> , c.category_nm
> , c.category_id
> , c.department_id
> , g.goal_nb
> , c.dataType
> , u.first_nm
> , dn.date_dt
>
>
>
>
~~
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Using CFLoop to delete from an Array
Doh! I knew it would be something simple. Thanks. H. -Original Message- From: cf refactoring [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 30, 2001 2:25 PM To: CF-Talk Subject: RE: Using CFLoop to delete from an Array Then you'll need to do "desc")> before your loop --- [EMAIL PROTECTED] wrote: > That's what I was trying to do with the ListSort() > function. > > > H. > ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Unexpected query results
Hello everyone, i'm currently running a query that is returning some odd
results. I'm trying to get the total number of sales in each category for a
salesperson. The query i'm running is below. With the data i have right now
i would expect to get back 4 for the total of sales per category for the
month indicated. I am however, getting back a total of 144. Can anyone tell
me what it is that is incorrect in my SQL statement that would cause this?
Thank you for your help.
j
SELECT
u.first_nm
, u.last_nm
, c.category_nm
, c.category_id
, c.dataType
, c.department_id
, dn.date_dt
, SUM(dn.quantity_nb)AS totalForMonth
, g.goal_nb
FROM
tblcategories c
, tblDailyNumbers dn
, tblUsers u
, tblGoals g
WHERE
DatePart("mm", dn.date_dt) = 9
AND
DatePart("yy", dn.date_dt) = 2001
AND
u.user_id *= dn.user_id
GROUP BY u.last_nm
, c.category_nm
, c.category_id
, c.department_id
, g.goal_nb
, c.dataType
, u.first_nm
, dn.date_dt
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Using CFLoop to delete from an Array
You probalby want something like this : #ArrayDeleteAt(session.cart, itemNum)# #ArrayResize(session.cart, 1)# Hope this helps. -eric > > #ListSort(form.remove, "numeric", "desc")# > > > > > > > > > > #ArrayDeleteAt(session.cart, i)# > > #ArrayResize(session.cart, 1)# > > > > > > > > - Original Message - From: <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, September 30, 2001 5:25 PM Subject: RE: Using CFLoop to delete from an Array > That's what I was trying to do with the ListSort() function. > > > H. > > > -Original Message- > From: Hanz Zarcovic [mailto:[EMAIL PROTECTED]] > Sent: Sunday, September 30, 2001 1:46 PM > To: CF-Talk > Subject: Re: Using CFLoop to delete from an Array > > > I think what you are describing is a common problem. > The problem is that when you start your loop the array is 7 elements long, > you delete the first and the array is now only 6 long , but your loop still > thinks the array has 7 items. > > The trick is to loop in reverse, from the end of your array *down to* the > first item. This way you are never trying to delete an item that dosen't > exist. > > Hope this helps. > -eric > > - Original Message - > From: <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Sunday, September 30, 2001 4:08 PM > Subject: Using CFLoop to delete from an Array > > > > I have a form that will allow users to randomly select items to remove > from > > a form. All of the items in the form are an Array of Structures. > > > > By clicking "remove" the number of the array position is identified. More > > than remove checkbox can be checked. They can be checked in any order. > > > > Currently, if only one item is check and the submit button is clicked, the > > item is removed from the Array without a problem. > > > > The problem comes in when there is an attempt to remove two or more items > > simultaneously. > > > > An error such as this is displayed: > > > > "ArrayDeleteAt(Array, Position): Cannot delete element at position 7. > > The array has only 6 elements. > > > > "The error occurred while evaluating the expression: > > #ArrayDeleteAt(session.cart, i)#" > > > > I've tried various ways to get this to work, so as sorting the array > (which > > didn't work because the first element isn't a simple variable), and trying > > to get the cfloop to remove the bottom item before the top item. That > isn't > > working. > > > > Below is my current code, but my question is ... how can I loop through > the > > array and remove all of the items I want? > > > > Current Code: > > > > > > #ListSort(form.remove, "numeric", "desc")# > > > > > > > > > > #ArrayDeleteAt(session.cart, i)# > > #ArrayResize(session.cart, 1)# > > > > > > > > > > > > > > ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
(Admin) Machine move
CFHosting.com, a major supporter of the House of Fusion lists and the host of our box will be moving said box to a new location (with higher bandwidth). This will result in an outage of mail for a few hours today (Sunday Sept. 30) and will probably result in some small DNS problems in the next 2 or 3 days as it propagates. ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Using CFLoop to delete from an Array
Then you'll need to do "desc")> before your loop --- [EMAIL PROTECTED] wrote: > That's what I was trying to do with the ListSort() > function. > > > H. > > > -Original Message- > From: Hanz Zarcovic > [mailto:[EMAIL PROTECTED]] > Sent: Sunday, September 30, 2001 1:46 PM > To: CF-Talk > Subject: Re: Using CFLoop to delete from an Array > > > I think what you are describing is a common problem. > The problem is that when you start your loop the > array is 7 elements long, > you delete the first and the array is now only 6 > long , but your loop still > thinks the array has 7 items. > > The trick is to loop in reverse, from the end of > your array *down to* the > first item. This way you are never trying to delete > an item that dosen't > exist. > > Hope this helps. > -eric > > - Original Message - > From: <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Sunday, September 30, 2001 4:08 PM > Subject: Using CFLoop to delete from an Array > > > > I have a form that will allow users to randomly > select items to remove > from > > a form. All of the items in the form are an Array > of Structures. > > > > By clicking "remove" the number of the array > position is identified. More > > than remove checkbox can be checked. They can be > checked in any order. > > > > Currently, if only one item is check and the > submit button is clicked, the > > item is removed from the Array without a problem. > > > > The problem comes in when there is an attempt to > remove two or more items > > simultaneously. > > > > An error such as this is displayed: > > > > "ArrayDeleteAt(Array, Position): Cannot delete > element at position 7. > > The array has only 6 elements. > > > > "The error occurred while evaluating the > expression: > > #ArrayDeleteAt(session.cart, i)#" > > > > I've tried various ways to get this to work, so as > sorting the array > (which > > didn't work because the first element isn't a > simple variable), and trying > > to get the cfloop to remove the bottom item before > the top item. That > isn't > > working. > > > > Below is my current code, but my question is ... > how can I loop through > the > > array and remove all of the items I want? > > > > Current Code: > > > > > > #ListSort(form.remove, "numeric", > "desc")# > > > > > > > > > > #ArrayDeleteAt(session.cart, i)# > > #ArrayResize(session.cart, 1)# > > > > > > > > = I-Lin Kuo Macromedia CF5 Advanced Developer Sun Certified Java 2 Programmer ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Using CFLoop to delete from an Array
That's what I was trying to do with the ListSort() function. H. -Original Message- From: Hanz Zarcovic [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 30, 2001 1:46 PM To: CF-Talk Subject: Re: Using CFLoop to delete from an Array I think what you are describing is a common problem. The problem is that when you start your loop the array is 7 elements long, you delete the first and the array is now only 6 long , but your loop still thinks the array has 7 items. The trick is to loop in reverse, from the end of your array *down to* the first item. This way you are never trying to delete an item that dosen't exist. Hope this helps. -eric - Original Message - From: <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, September 30, 2001 4:08 PM Subject: Using CFLoop to delete from an Array > I have a form that will allow users to randomly select items to remove from > a form. All of the items in the form are an Array of Structures. > > By clicking "remove" the number of the array position is identified. More > than remove checkbox can be checked. They can be checked in any order. > > Currently, if only one item is check and the submit button is clicked, the > item is removed from the Array without a problem. > > The problem comes in when there is an attempt to remove two or more items > simultaneously. > > An error such as this is displayed: > > "ArrayDeleteAt(Array, Position): Cannot delete element at position 7. > The array has only 6 elements. > > "The error occurred while evaluating the expression: > #ArrayDeleteAt(session.cart, i)#" > > I've tried various ways to get this to work, so as sorting the array (which > didn't work because the first element isn't a simple variable), and trying > to get the cfloop to remove the bottom item before the top item. That isn't > working. > > Below is my current code, but my question is ... how can I loop through the > array and remove all of the items I want? > > Current Code: > > > #ListSort(form.remove, "numeric", "desc")# > > > > > #ArrayDeleteAt(session.cart, i)# > #ArrayResize(session.cart, 1)# > > > > > > ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Using CFLoop to delete from an Array
I think what you are describing is a common problem. The problem is that when you start your loop the array is 7 elements long, you delete the first and the array is now only 6 long , but your loop still thinks the array has 7 items. The trick is to loop in reverse, from the end of your array *down to* the first item. This way you are never trying to delete an item that dosen't exist. Hope this helps. -eric - Original Message - From: <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, September 30, 2001 4:08 PM Subject: Using CFLoop to delete from an Array > I have a form that will allow users to randomly select items to remove from > a form. All of the items in the form are an Array of Structures. > > By clicking "remove" the number of the array position is identified. More > than remove checkbox can be checked. They can be checked in any order. > > Currently, if only one item is check and the submit button is clicked, the > item is removed from the Array without a problem. > > The problem comes in when there is an attempt to remove two or more items > simultaneously. > > An error such as this is displayed: > > "ArrayDeleteAt(Array, Position): Cannot delete element at position 7. > The array has only 6 elements. > > "The error occurred while evaluating the expression: > #ArrayDeleteAt(session.cart, i)#" > > I've tried various ways to get this to work, so as sorting the array (which > didn't work because the first element isn't a simple variable), and trying > to get the cfloop to remove the bottom item before the top item. That isn't > working. > > Below is my current code, but my question is ... how can I loop through the > array and remove all of the items I want? > > Current Code: > > > #ListSort(form.remove, "numeric", "desc")# > > > > > #ArrayDeleteAt(session.cart, i)# > #ArrayResize(session.cart, 1)# > > > > > > ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Using CFLoop to delete from an Array
I have a form that will allow users to randomly select items to remove from a form. All of the items in the form are an Array of Structures. By clicking "remove" the number of the array position is identified. More than remove checkbox can be checked. They can be checked in any order. Currently, if only one item is check and the submit button is clicked, the item is removed from the Array without a problem. The problem comes in when there is an attempt to remove two or more items simultaneously. An error such as this is displayed: "ArrayDeleteAt(Array, Position): Cannot delete element at position 7. The array has only 6 elements. "The error occurred while evaluating the expression: #ArrayDeleteAt(session.cart, i)#" I've tried various ways to get this to work, so as sorting the array (which didn't work because the first element isn't a simple variable), and trying to get the cfloop to remove the bottom item before the top item. That isn't working. Below is my current code, but my question is ... how can I loop through the array and remove all of the items I want? Current Code: #ListSort(form.remove, "numeric", "desc")# #ArrayDeleteAt(session.cart, i)# #ArrayResize(session.cart, 1)# ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cf to excel display issue
I have set up an excel sheet to show results of a search. I also want to add another search- when the field is null or X. The query works, however, it does not show up correctly on the excel sheet. 1. The excel sheet does not line the nulls under the correct headings. No matter where on the sheet the nulls are, the excel sheet fills in the nulls as if they were at the begining and then leaves half drawn spreadsheat at the end. For example: If I wanted the following to show Heading1Heading2Heading3Heading4Heading5 Heading6 A B C (Null) (Null) D it shows up like: Heading1Heading2Heading3Heading4Heading5 Heading6 (Null) (Null) So I think it's like a list- filling in/not having any blanks. So I'm not quite sure how to get it to display correctly. I hope I've made this clear- I'm finding it difficult to explain. Is there a good way to do what I want to do? ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE:
It is also possible to write: #name# The single quotes is equivalent to DE(). I'm not sure if this is any faster. Overall though, IIF always seems to be incredibly slow. -Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED]] Sent: September 30, 2001 11:26 AM To: CF-Talk Subject: Re: The IIf way would be: #name# Or something along those lines, it is slower though due to the DE() functions. Why not just put the CFIF within the option tag? selected>#name# This all assumes that Form.Name is always defined, I am guessing you have a cfparam towards the top of the page for that, like so: Snipe - - Original Message - From: "Bryan LaPlante" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, September 30, 2001 11:46 AM Subject: Re: > I imagine you are pulling your list from a database and using the query of a > cfoutput, just add this code to it. > > > = ""> > #name# > > > there is a way to do it in one line with iif() but I can't remember that one > right off. > > Bryan > > - Original Message - > From: "Tony Hicks" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Sunday, September 30, 2001 5:00 AM > Subject: > > > Hey Guys... > > I have a problem, my site, www.bibleclicks.com has one request from people > that send me feedback.. they want me to set it so that when a user selects a > book and searches, the book remains selected on the next page.. the problem > comes in here: > > It would take about 75 cfif tags to do it and some of them would be long.. > my host is generous with bandwidth but.. I'm smart, I don't want to push the > limits.. is there an easy way to do this? > > Thanks, > Tony Hicks > > > ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re:
The IIf way would be: #name# Or something along those lines, it is slower though due to the DE() functions. Why not just put the CFIF within the option tag? selected>#name# This all assumes that Form.Name is always defined, I am guessing you have a cfparam towards the top of the page for that, like so: Snipe - - Original Message - From: "Bryan LaPlante" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, September 30, 2001 11:46 AM Subject: Re: > I imagine you are pulling your list from a database and using the query of a > cfoutput, just add this code to it. > > > = ""> > #name# > > > there is a way to do it in one line with iif() but I can't remember that one > right off. > > Bryan > > - Original Message - > From: "Tony Hicks" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Sunday, September 30, 2001 5:00 AM > Subject: > > > Hey Guys... > > I have a problem, my site, www.bibleclicks.com has one request from people > that send me feedback.. they want me to set it so that when a user selects a > book and searches, the book remains selected on the next page.. the problem > comes in here: > > It would take about 75 cfif tags to do it and some of them would be long.. > my host is generous with bandwidth but.. I'm smart, I don't want to push the > limits.. is there an easy way to do this? > > Thanks, > Tony Hicks > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Removing HTML tags from cflocation URL
Thanks Jon. Reason I had to get a "cover up" as it was preventing things working for registered members. I'm working on the proper fix now to stop it causing the erroneous tags. Cheers Will - Original Message - From: "Jon Hall" <[EMAIL PROTECTED]> Newsgroups: cf-talk Sent: Sunday, September 30, 2001 3:02 AM Subject: Re: Removing HTML tags from cflocation URL > The way to fix this is to fix the problem that is causing the bad data > to exist in the first place, not cover it up with a workaround. > > However, the workaround is fairly straightforward. > > http://www.test.com"> > > > jon > W Luke wrote: > > >Hi. > > > >I have a bit of a problem with URLs and Cflocation. Occasionally, a URL is > >submitted into the Database which contains extra HTML tags that aren't > >needed as shown below: > > > >http://www.mywebpage.com > > > >Cflocation doesn't (yet!) have the power to strip out non-URL content such > >as and , AFAIK, and as such it errors. What I need to do is assign > >the link to a var prior to unleashing cflocation onto it, and validate it > >and remove any erroneous tags if there are any to make it a nice clean link. > > > >Is this is long refindnocase job, or is there a tag or function that could > >help? > > > >Many thanks once again. > > > >Will > > > > > >-- > >http://www.localbounty.com - free local and national advertising > > > ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re:
I imagine you are pulling your list from a database and using the query of a cfoutput, just add this code to it. #name# there is a way to do it in one line with iif() but I can't remember that one right off. Bryan - Original Message - From: "Tony Hicks" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, September 30, 2001 5:00 AM Subject: Hey Guys... I have a problem, my site, www.bibleclicks.com has one request from people that send me feedback.. they want me to set it so that when a user selects a book and searches, the book remains selected on the next page.. the problem comes in here: It would take about 75 cfif tags to do it and some of them would be long.. my host is generous with bandwidth but.. I'm smart, I don't want to push the limits.. is there an easy way to do this? Thanks, Tony Hicks ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re:
That's why I asked :-) The Bible -- Old Testament New Testament -- Books of Law Books of History Psalms & Writings The Prophets The Gospels Acts Pauline Letters General Epistles -- Genesis Exodus Leviticus Numbers Deuteronomy Joshua Judges Ruth 1 Samuel 2 Samuel 1 Kings 2 Kings 1 Chronicles 2 Chronicles Ezra Nehemiah Esther Job Psalms Proverbs Ecclesiastes Song of Solomon Isaiah Jeremiah Lamentations Ezekiel Daniel Hosea Joel Amos Obadiah Jonah Micah Nahum Habakkuk Zephaniah Haggai Zechariah Malachi Matthew Mark Luke John Acts Romans 1 Corinthians 2 Corinthians Galatians Ephesians Philippians Colossians 1 Thessalonians 2 Thessalonians 1 Timothy 2 Timothy Titus Philemon Hebrews James 1 Peter 2 Peter 1 John 2 John 3 John Jude Revelation -- Search the Holy Bible: http://www.bibleclicks.com - Original Message - From: "Koo Pai Lao" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, September 30, 2001 6:52 AM Subject: Re: > LOL lets see your code. i bet it will only take less than 7 lines of code > > > > > > > > > >From: "Tony Hicks" <[EMAIL PROTECTED]> > >Reply-To: [EMAIL PROTECTED] > >To: CF-Talk <[EMAIL PROTECTED]> > >Subject: > >Date: Sun, 30 Sep 2001 05:00:59 -0500 > > > >Hey Guys... > > > >I have a problem, my site, www.bibleclicks.com has one request from people > >that send me feedback.. they want me to set it so that when a user selects > >a > >book and searches, the book remains selected on the next page.. the problem > >comes in here: > > > >It would take about 75 cfif tags to do it and some of them would be long.. > >my host is generous with bandwidth but.. I'm smart, I don't want to push > >the > >limits.. is there an easy way to do this? > > > >Thanks, > >Tony Hicks > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT - Email Server Software?
There are also HKSI's Classic templates: just install the things (dirt-simple) add a generic logo and go. More customization if you want, or not. One of my most satisfying server s/w purchases: dirt cheap, no brains required and nicely elegant. My customers love 'em... so much so that when I asked if an upgrade to the very nice Killer ver was OK they unanimously voted to stick with the Classics. Insofar as Imail is concerned, it seems as if its a product geared towards ease of administration for an ISP with lots of domains/users -- stellar on that front, both for the ISP admin and domain admin. Big lists and mass mailings can bog it down (s-l-o-w, but not stop), so if mass-capacity is important be avised. Also the current ver seems to still have some kinks after a recent upgrade. - Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com - - Original Message - From: "Ron Hornbaker" <[EMAIL PROTECTED]> Another plus for IMail is that you can use our very customizable Killer webmail ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re:
LOL lets see your code. i bet it will only take less than 7 lines of code >From: "Tony Hicks" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: >Date: Sun, 30 Sep 2001 05:00:59 -0500 > >Hey Guys... > >I have a problem, my site, www.bibleclicks.com has one request from people >that send me feedback.. they want me to set it so that when a user selects >a >book and searches, the book remains selected on the next page.. the problem >comes in here: > >It would take about 75 cfif tags to do it and some of them would be long.. >my host is generous with bandwidth but.. I'm smart, I don't want to push >the >limits.. is there an easy way to do this? > >Thanks, >Tony Hicks > > ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Delivering files with CFCONTENT
Hi all, I'm building a webmail client right now, and i can't seem to get the attachment part right. For some reason my tag that prompts the user to save/open doesn't accept all extension. The case in point is a .psd file, but my mail client should be able to handle any extension. Right now the TYPE is set to "application/*" but i have also tried to set it to "unknown". Any help would be highly appreciated! Best wishes ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Email Server Software?
I use iMail 7 which has been great so far. It has plenty of command line executable that you can use to do all kinds of stuff in CF like create domains, add and modify users etc. The webmail system it comes with is very nice and robust, and yes we use the humankind systems' classic web templates which go for like $100 (best $100 I have ever spent). J.J. Merrick Director of Technology Churchmatters, Inc Nashville, TN. http://www.churchmatters.com http://www.echurchonline.com > Date: Sun, 30 Sep 2001 00:38:17 -0500 > From: "Ron Hornbaker" <[EMAIL PROTECTED]> > Subject: RE: Email Server Software? > Message-ID: <[EMAIL PROTECTED]> > > > Imail from Ipswitch.com is very good and robust... > > > Another plus for IMail is that you can use our very customizable Killer > webmail system with it. Demo at http://killerwebmail.com/. > > > Ron Hornbaker > President/CTO > . . . . . . . . . . . . http://humankindsystems.com > . . . . . . . . . . . . w e c o d e. w e c a r e. > . . . http://AnswerTrack.com - eCRM email tracking solution > > ~~ > Get the mailserver that powers this list at http://www.coolfusion.com > FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cf-talk@houseoffusion.com
Hey Guys... I have a problem, my site, www.bibleclicks.com has one request from people that send me feedback.. they want me to set it so that when a user selects a book and searches, the book remains selected on the next page.. the problem comes in here: It would take about 75 cfif tags to do it and some of them would be long.. my host is generous with bandwidth but.. I'm smart, I don't want to push the limits.. is there an easy way to do this? Thanks, Tony Hicks ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
