date:20061221

Well since we are being smart asses... the question was "how can I clear
either one when I click on any one of the radio buttons."

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED] 
Sent: Thursday, December 21, 2006 7:34 PM
To: CF-Talk
Subject: RE: Javascript help

> I don't consider Netscape 2 (or IE pre 5) when I use the 
> phrase 'cross browser compatible'. Especially when dealing 
> with JS and/or CSS.

I thought the question was, "what is the most compatible way to address a
form in JS", not "what browsers do you prefer to disregard?"

Right now, the answer to that question is to use the forms array. In XHTML
1.0, the FORM element should not even have a NAME attribute! (It's been
deprecated.)

http://www.w3.org/TR/xhtml1/#h-4.10

However, the HTML DOM still supports the forms array, and will do so for the
foreseeable future:

http://www.w3.org/TR/DOM-Level-2-HTML/html.html#ID-1689064

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264865
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: ?

>also, just out of curiousity... your first 2 radio buttons >aren't
>named, so aren't passing anything to the action page, are >they?  just
>wondered what purpose they served.

Actually they do, I just shortened a little so it was more readable.

>You might also just want to have one form field for >"price", and then
>a checkbox as to whether or not it's "negotiable".  that'd >save you
>the hassle of checking this form field's length vs that form >field's
>length...

I had thought about that, but people always forget to tick a checkbox and
then get irritated things are not more user friendly.


Doug B.


~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264864
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: ?

try a trim() as well.

  ... (etc)

also, just out of curiousity... your first 2 radio buttons aren't
named, so aren't passing anything to the action page, are they?  just
wondered what purpose they served.

You might also just want to have one form field for "price", and then
a checkbox as to whether or not it's "negotiable".  that'd save you
the hassle of checking this form field's length vs that form field's
length...

On 12/21/06, Doug Brown <[EMAIL PROTECTED]> wrote:
> Just to make this easy for everybody to understand. Here is what is happing,
> bye the way this is an update to the database.
>
> 
> User enters price (firm price)
> OR
>  value=""> User enters price (Negotiable price)
> OR
> 
> 
>
>
>
> And the update query
>
>
>   username="#APPLICATION.UN#" password="#APPLICATION.PW#">
>  UPDATE #APPLICATION.DBPRE#Advertisements
>  SET CategoryID =   #ARGUMENTS.CategoryID#,
>   SCategoryID = #ARGUMENTS.SCategoryID#,
>   title ='#ARGUMENTS.title#',
>
> 
> 
> 
> price = #arguments.asking1#,
> 
>  
>price = #arguments.asking2#,
>  
> 
> 
> price = 0,
> 
>  
>
>
>
>
>
>
>
> Doug B.
>
>
> 

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264863
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: HTML DL and P Nesting

2006-12-21 Thread Sandra Clark

I would not use the p tag unless its necessary to split up paragraphs. In
which case I would use them in both.  But that's your call.  Text within a
 is not considered anonymous text.  It is valid.

You can style your p within the dd using the following selector

 dd p {margin:.25em 0;padding:0}   which will give you a top and bottom
margin and a 0 left and right margin. The 0 padding will then allow you to
simply style the dd.




Sandra Clark
==
http://www.shayna.com
Training in Cascading Style Sheets and Accessibility


-Original Message-
From: Dawson, Michael [mailto:[EMAIL PROTECTED] 
Sent: Thursday, December 21, 2006 6:57 PM
To: CF-Talk
Subject: SOT: HTML DL and P Nesting

This is something that has always bugged me for the sake of consistency...
 
If I have a definition list such as:
 

Term Goes Here
The long definition goes here 
 
Then, I have a definition list with two paragraphs such as:
 

Term Goes Here

The long definition goes here
The second line goes here


 
Now, these two lists are not consistent in the use of the  tag.  The
first example does not use  but the second example does, if only to break
the paragraphs apart.
 
So, how do you handle these cases?  Do you always use a  tag even if
there would only be one paragraph within the  tag?
 
Or, do you just keep it brief and not use a  tag unless you have more
than one paragraph?
 
If I always use the  tag, then I know my CSS styling will be consistent.
Otherwise, I would need to style both my  and  tags the same to keep
the same margins and padding.
 
Thanks




~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264862
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: ?

Just to make this easy for everybody to understand. Here is what is happing,
bye the way this is an update to the database.


User enters price (firm price)
OR
 User enters price (Negotiable price)
OR





And the update query


 
 UPDATE #APPLICATION.DBPRE#Advertisements
 SET CategoryID =   #ARGUMENTS.CategoryID#,
  SCategoryID = #ARGUMENTS.SCategoryID#,
  title ='#ARGUMENTS.title#',




price = #arguments.asking1#,

 
   price = #arguments.asking2#,
 


price = 0,

 







Doug B.


~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264861
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: SOT: MyISAM or innoDB Storage Engine for MySQL?

2006-12-21 Thread Aaron Roberson

Is there any extra steps needed to convert over to innoDB from MyISAM?

-Aaron

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264860
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: ?

Nope, wont work. Still the same result as before, 2nd field will not insert
and default wont either.

Doug B.


~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264859
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: ?

2006-12-21 Thread Andrew Scott

  
  price = #ARGUMENTS.asking1#,
  
  price = #ARGUMENTS.asking2#,
  
  price = NULL,
  
  



Andrew Scott
Senior Coldfusion Developer
Aegeon Pty. Ltd.
www.aegeon.com.au
Phone: +613  8676 4223
Mobile: 0404 998 273

-Original Message-
From: Doug Brown [mailto:[EMAIL PROTECTED] 
Sent: Friday, 22 December 2006 11:16 AM
To: CF-Talk
Subject: ?

I am having some troubles with an if statement and cannot seem to get it
right. I have 2 text fields that hold the value of the price of items a user
is selling, a user can fill in either one of the fields or none at all. If
the user chooses not to fill in these fields, then I want to add a default
value of 0 to the price in the database.


I am using this so far with not luck. I tried using  with no luck
either. In the below code, I will get two price objects due to one or both
fields being empty.

  
  price = #ARGUMENTS.asking1#,
  
  
  
  price = #ARGUMENTS.asking2#,
  
  
  
  price = NULL,
  



Doug B.



~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264858
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: grouped output and Mod 2

2006-12-21 Thread Richard Dillman

geee i feel dumb now

Backing away from the keyboard.


On 12/21/06, Charlie Griefer <[EMAIL PROTECTED]> wrote:
>
> set a counter var and increment it inside the inner 
>
> 
> 
>  
>  
>  
>   do stuff
>   
>   do other stuff
>   
> 
> 
>
> On 12/21/06, Richard Dillman <[EMAIL PROTECTED]> wrote:
> > Im trying to make a table output grouped query info.
> > Then i want to make a 2 column list of the grouped data within.
> Dynamically
> > generating the Tr's in the right spots.
> >
> > I'm finding that using MOD wont work because i never know where ill be
> > starting the row at after the title
> >
> > Any thoughts?
> >
> >  > password="#dbpassword#">
> >   Select TYPE, NAME, ID
> >   from BUSINESS
> >   Order by TYPE ASC
> > 
> > 
> > 
> >   
> > 
> >#TYPE#
> >  
> >   
> > 
> >   
> > 
> >   
> > 
> >#NAME#
> > 
> >   
> > 
> >   
> >  
> > 
> > 
> >
> > --
> > --
> > Richard Dillman
> > [EMAIL PROTECTED]
> > (317) 916-8341
> >
> > "If you want happiness for an hour -- take a nap.
> > If you want happiness for a day -- go fishing.
> > If you want happiness for a month -- get married.
> > If you want happiness for a year -- inherit a fortune.
> > If you want happiness for a lifetime -- help someone else."
> > -- Chinese proverb --
> >
> >
> >
>
> 

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264857
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: ?

2006-12-21 Thread Dan Vega

You want to use the cfparam tag then to set default paramters.

Now when you do the insert it will either enter the default which in this
case is an empty string (it can be anything) or if form.asking1 or 2
isdefined on submit it will grab those values.

Dan

On 12/21/06, Doug Brown <[EMAIL PROTECTED]> wrote:
>
> No, it is not the syntax that is the problem. What happens when the user
> does not enter any information into one of the two fields, then I need to
> be
> able to add a default value to the database. If a user enters an amount,
> then I need to place that info in the database. I hope this makes sense.
>
> Doug B.
>
>
> 

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264856
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: ?

2006-12-21 Thread Josh Nathanson

How 'bout



price = #arguments.asking1#,

price = #arguments.asking2#,


price = 0,


- Original Message - 
From: "Doug Brown" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Thursday, December 21, 2006 4:15 PM
Subject: ?


>I am having some troubles with an if statement and cannot seem to get it 
>right. I have 2 text fields that hold the value of the price of items a 
>user is selling, a user can fill in either one of the fields or none at 
>all. If the user chooses not to fill in these fields, then I want to add a 
>default value of 0 to the price in the database.
>
>
> I am using this so far with not luck. I tried using  with no 
> luck either. In the below code, I will get two price objects due to one or 
> both fields being empty.
>
>  
>  price = #ARGUMENTS.asking1#,
>  
>
>  
>  price = #ARGUMENTS.asking2#,
>  
>
>  
>  price = NULL,
>  
>
>
>
> Doug B.
>
> 

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264855
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: grouped output and Mod 2

set a counter var and increment it inside the inner 


 
  
  
  
   do stuff
   
   do other stuff
   
 


On 12/21/06, Richard Dillman <[EMAIL PROTECTED]> wrote:
> Im trying to make a table output grouped query info.
> Then i want to make a 2 column list of the grouped data within. Dynamically
> generating the Tr's in the right spots.
>
> I'm finding that using MOD wont work because i never know where ill be
> starting the row at after the title
>
> Any thoughts?
>
>  password="#dbpassword#">
>   Select TYPE, NAME, ID
>   from BUSINESS
>   Order by TYPE ASC
> 
> 
> 
>   
> 
>#TYPE#
>  
>   
> 
>   
> 
>   
> 
>#NAME#
> 
>   
> 
>   
>  
> 
> 
>
> --
> --
> Richard Dillman
> [EMAIL PROTECTED]
> (317) 916-8341
>
> "If you want happiness for an hour -- take a nap.
> If you want happiness for a day -- go fishing.
> If you want happiness for a month -- get married.
> If you want happiness for a year -- inherit a fortune.
> If you want happiness for a lifetime -- help someone else."
> -- Chinese proverb --
>
>
> 

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264854
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Javascript help

> I don't consider Netscape 2 (or IE pre 5) when I use the 
> phrase 'cross browser compatible'. Especially when dealing 
> with JS and/or CSS.

I thought the question was, "what is the most compatible way to address a
form in JS", not "what browsers do you prefer to disregard?"

Right now, the answer to that question is to use the forms array. In XHTML
1.0, the FORM element should not even have a NAME attribute! (It's been
deprecated.)

http://www.w3.org/TR/xhtml1/#h-4.10

However, the HTML DOM still supports the forms array, and will do so for the
foreseeable future:

http://www.w3.org/TR/DOM-Level-2-HTML/html.html#ID-1689064

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264853
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: ?

2006-12-21 Thread Dan Vega

oops





On 12/21/06, Dan Vega <[EMAIL PROTECTED]> wrote:
>
> if your searching for length or lack there of I prefer to use the len()
> method along with trimming any trailing or preceeding whitespace
>
> 
>
> 
>
> On 12/21/06, John Cox <[EMAIL PROTECTED]> wrote:
> >
> > On 12/21/06, Doug Brown <[EMAIL PROTECTED]> wrote:
> > >
> > > I am having some troubles with an if statement and cannot seem to get
> > it
> > > right. I have 2 text fields that hold the value of the price of items
> > a user
> > > is selling, a user can fill in either one of the fields or none at
> > all. If
> > > the user chooses not to fill in these fields, then I want to add a
> > default
> > > value of 0 to the price in the database.
> > >
> > >
> > > I am using this so far with not luck. I tried using  with no
> > > luck either. In the below code, I will get two price objects due to
> > one or
> > > both fields being empty.
> > >
> > >   
> > >   price = #ARGUMENTS.asking1#,
> > >   
> >
> >
> >
> > I believe:
> >
> > 
> >
> > Will work.
> >
> >
> > 

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264852
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: ?

No, it is not the syntax that is the problem. What happens when the user
does not enter any information into one of the two fields, then I need to be
able to add a default value to the database. If a user enters an amount,
then I need to place that info in the database. I hope this makes sense.

Doug B.


~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264851
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: ?

2006-12-21 Thread Dan Vega

if your searching for length or lack there of I prefer to use the len()
method along with trimming any trailing or preceeding whitespace





On 12/21/06, John Cox <[EMAIL PROTECTED]> wrote:
>
> On 12/21/06, Doug Brown <[EMAIL PROTECTED]> wrote:
> >
> > I am having some troubles with an if statement and cannot seem to get it
> > right. I have 2 text fields that hold the value of the price of items a
> user
> > is selling, a user can fill in either one of the fields or none at all.
> If
> > the user chooses not to fill in these fields, then I want to add a
> default
> > value of 0 to the price in the database.
> >
> >
> > I am using this so far with not luck. I tried using  with no
> > luck either. In the below code, I will get two price objects due to one
> or
> > both fields being empty.
> >
> >   
> >   price = #ARGUMENTS.asking1#,
> >   
>
>
>
> I believe:
>
> 
>
> Will work.
>
>
> 

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264850
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: ?

Ignore the NULL bye the way !!!





Doug B.

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264849
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: ?

On 12/21/06, Doug Brown <[EMAIL PROTECTED]> wrote:
>
> I am having some troubles with an if statement and cannot seem to get it
> right. I have 2 text fields that hold the value of the price of items a user
> is selling, a user can fill in either one of the fields or none at all. If
> the user chooses not to fill in these fields, then I want to add a default
> value of 0 to the price in the database.
>
>
> I am using this so far with not luck. I tried using  with no
> luck either. In the below code, I will get two price objects due to one or
> both fields being empty.
>
>   
>   price = #ARGUMENTS.asking1#,
>   



I believe:



Will work.


~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264848
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

?

I am having some troubles with an if statement and cannot seem to get it right. 
I have 2 text fields that hold the value of the price of items a user is 
selling, a user can fill in either one of the fields or none at all. If the 
user chooses not to fill in these fields, then I want to add a default value of 
0 to the price in the database.


I am using this so far with not luck. I tried using  with no luck 
either. In the below code, I will get two price objects due to one or both 
fields being empty.

  
  price = #ARGUMENTS.asking1#,
  
  
  
  price = #ARGUMENTS.asking2#,
  
  
  
  price = NULL,
  



Doug B.

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264847
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

grouped output and Mod 2

2006-12-21 Thread Richard Dillman

Im trying to make a table output grouped query info.
Then i want to make a 2 column list of the grouped data within. Dynamically
generating the Tr's in the right spots.

I'm finding that using MOD wont work because i never know where ill be
starting the row at after the title

Any thoughts?


  Select TYPE, NAME, ID
  from BUSINESS
  Order by TYPE ASC



  

   #TYPE#
 
  

  

  

   #NAME#

  

  
 



-- 
-- 
Richard Dillman
[EMAIL PROTECTED]
(317) 916-8341

"If you want happiness for an hour -- take a nap.
If you want happiness for a day -- go fishing.
If you want happiness for a month -- get married.
If you want happiness for a year -- inherit a fortune.
If you want happiness for a lifetime -- help someone else."
-- Chinese proverb --


~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264846
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

SOT: HTML DL and P Nesting

2006-12-21 Thread Dawson, Michael

This is something that has always bugged me for the sake of
consistency...
 
If I have a definition list such as:
 

Term Goes Here
The long definition goes here

 
Then, I have a definition list with two paragraphs such as:
 

Term Goes Here

The long definition goes here
The second line goes here


 
Now, these two lists are not consistent in the use of the  tag.  The
first example does not use  but the second example does, if only to
break the paragraphs apart.
 
So, how do you handle these cases?  Do you always use a  tag even if
there would only be one paragraph within the  tag?
 
Or, do you just keep it brief and not use a  tag unless you have more
than one paragraph?
 
If I always use the  tag, then I know my CSS styling will be
consistent.  Otherwise, I would need to style both my  and  tags
the same to keep the same margins and padding.
 
Thanks


~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264845
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Javascript help

> > This seems to work, but will it work in all browser?
> > 
> >  onFocus="document.updClassified.asking1.value = 
> > '',document.updClassified.asking2.value = ''"
> >
> No it won't.
> 
> For that you'll need a function and you'll need to write a 
> javascript browser diction script and have separate clauses 
> in the function for each browser.
> 
> Mainly you'll use document.all and document.getElementById()

The original code would work fine, as long as the two statements are
separated by semicolons, not commas.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264844
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Javascript help

> You can stack arguments that way, but will calling the field 
> that way work cross browser?

Yes, there's nothing wrong with having multiple statements within an event
handler, other than readability.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264843
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Javascript help

so I asked said, "You use WHAT browser?" 

I dont consider Netscape 2 (or IE pre 5) when I use the phrase 'cross
browser compatible'. Especially when dealing with JS and/or CSS.

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED] 
Sent: Thursday, December 21, 2006 5:42 PM
To: CF-Talk
Subject: RE: Javascript help

> > document.formname.fieldname.value is about as standard as it 
> > gets AFAIK.
>
> Yes, it is as vanilla as it gets and easiest for most people 
> to read and understand. But if you'd like to make it NOT work 
> in all browsers that can read JS you can try some of these lol
> 
> document.forms[0].myfield.value
> document.forms[0]['myfield'].value
> document.forms['myform'].myfield.value
> document.forms['myform']['myfield'] .value

Actually, the first one in Bobby's list (document.forms[0].myfield.value) is
the most compatible; it works in Netscape 2, while
document.formname.myfield.value will not, if I recall correctly. Support for
addressing forms (and elements) using array notation was introduced with the
first version of JavaScript.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264842
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: SOT: MyISAM or innoDB Storage Engine for MySQL?

2006-12-21 Thread Michael E. Carluen

Also check with your hosting service too (if you're using one), before you
use InnoDB.  I know that there are several hosting companies who only allow
myISAM tables on certain plans.



> -Original Message-
> From: Matt Robertson [mailto:[EMAIL PROTECTED]
> Sent: Thursday, December 21, 2006 2:31 PM
> To: CF-Talk
> Subject: Re: SOT: MyISAM or innoDB Storage Engine for MySQL?
> 
> on my mySQL5 installation it created InnoDB tables with everything
> when I migrated all my 4.x stuff over from another server.  I haven't
> noticed any deleterious effects (i.e. slowing stuff down since we all
> know myISAM is real fast) and in fact I have seen an increase in
> stability; given that there was one particular error that I could
> expect a myISAM table to throw every month or so and I haven't had a
> single problem yet.  But that could be mySQL5 being more stable than
> 4.x too.
> 
> Unless you have a specific reason for myISAM I would use innoDB.  Its
> a more robust table type in general.  Just not as fast.
> 
> --
> [EMAIL PROTECTED]
> Janitor, MSB Web Systems
> mysecretbase.com
> 
> 

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264841
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Is there a better way to do this

2006-12-21 Thread Bruce Sorge

Loathe,
That was close. I made a couple of changes and it worked like a champ.
Thanks for getting me on the right track.


~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264840
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Javascript help

> > document.formname.fieldname.value is about as standard as it 
> > gets AFAIK.
>
> Yes, it is as vanilla as it gets and easiest for most people 
> to read and understand. But if you'd like to make it NOT work 
> in all browsers that can read JS you can try some of these lol
> 
> document.forms[0].myfield.value
> document.forms[0]['myfield'].value
> document.forms['myform'].myfield.value
> document.forms['myform']['myfield'] .value

Actually, the first one in Bobby's list (document.forms[0].myfield.value) is
the most compatible; it works in Netscape 2, while
document.formname.myfield.value will not, if I recall correctly. Support for
addressing forms (and elements) using array notation was introduced with the
first version of JavaScript.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264839
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: SOT: MyISAM or innoDB Storage Engine for MySQL?

2006-12-21 Thread Matt Robertson

on my mySQL5 installation it created InnoDB tables with everything
when I migrated all my 4.x stuff over from another server.  I haven't
noticed any deleterious effects (i.e. slowing stuff down since we all
know myISAM is real fast) and in fact I have seen an increase in
stability; given that there was one particular error that I could
expect a myISAM table to throw every month or so and I haven't had a
single problem yet.  But that could be mySQL5 being more stable than
4.x too.

Unless you have a specific reason for myISAM I would use innoDB.  Its
a more robust table type in general.  Just not as fast.

-- 
[EMAIL PROTECTED]
Janitor, MSB Web Systems
mysecretbase.com

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264838
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: SOT: MyISAM or innoDB Storage Engine for MySQL?

2006-12-21 Thread Will Tomlinson

>I think that MyISAM is the default storage engine for MySQL but I am
>constantly getting SQL scripts that are built with innoDB. Which
>engine should I use?

Doesn't innoDB support FK's and myIsam doesn't? If you need FK's, use InnoDB
This is what I remember but what I remember usually isn't right. lol!

Will

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264837
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

SOT: MyISAM or innoDB Storage Engine for MySQL?

2006-12-21 Thread Aaron Roberson

I think that MyISAM is the default storage engine for MySQL but I am
constantly getting SQL scripts that are built with innoDB. Which
engine should I use?

Thanks,
Aaron

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264836
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: automatically generate password

I'm not saying that it's not random enough. :o) I was just talking about 
using Randomize();. Like the docs say, it just seeds the ColdFusion 
random number generator with an integer. Seeding the generator helps to 
ensure that the Rand function returns highly random numbers.

Even given that, I like the udf. The valid character string idea is 
really good. :o)

Chris


Bobby Hartsfield wrote:
> The strings are pretty random. It picks a random charset to get a character
> from... then it picks a random character IN that charset 
>
> I COULD then loop from 1 to the final strings length; pull out a random char
> each time and use them to rebuild it from left to right but I don't see much
> point ;-) 
>
> -Original Message-
> From: Christopher Jordan [mailto:[EMAIL PROTECTED] 
> Sent: Thursday, December 21, 2006 4:44 PM
> To: CF-Talk
> Subject: Re: automatically generate password
>
> I wrote a random number generator for CFLib.org called getRandomNumber 
> , but it only returns numbers. :o( you 
> can however pass it any length (in digits) that you want and you'll get 
> a number back with that many digits. I like the idea of being able to 
> tell the UDF what character set to use. Good Idea. I don't see you 
> seeding the random number generator. Check out my udf (the link above) 
> and see what I'm doing for seeding. My original version had that all 
> screwed up and my numbers weren't very random at all... :o( My buddy, 
> Steven worked on that bit with me and I think the solution we came up 
> with is pretty cool.
>
>
>
>
> Bobby Hartsfield wrote:
>   
>> Ok... here it is. I just submitted it to cflib.org so it should be up
>> 
> there
>   
>> soon under the name 'randStr'. I checked the processing time for a bit and
>> couldn't get anything over 0 until I started generating strings 200+ in
>> length.
>>
>> The two required params are strLen and charSet
>>
>> strLen: can either be a single digit like 8 which would generate an 8
>> character string every time. OR it can be a comma delimited list of 2
>> numbers such as 8,16 which would result in a random length between 8 and
>> 
> 16
>   
>> characters.
>>
>> charSet: can be any combination of the three words alpha, numeric and
>> 
> upper
>   
>> that you can come up with.
>>
>> EXAMPLES:
>> Alpha
>> Alphanumeric
>> Alphanumericupper
>> Alphaupper
>> Etc...
>>
>> Alpha: a-z
>> Numeric: 0-9
>> Upper: A-Z
>>
>>
>> I did not add a lower option since you can just leave upper out and
>> 
> achieve
>   
>> that.
>>
>> If you use upper, you will have a mix of uppercase and lowercase
>> 
> characters.
>   
>> If you want only upper, wrap the final output in ucase().
>>
>> You COULD use 'numeric' as the charset but that will just result in a
>> 
> random
>   
>> number at the specified length... there are better ways to do that.
>>
>> I did not put in special characters because I don't like them :-)
>> Actually, special characters are spread out in the ascii ranges so they
>> 
> are
>   
>> a pain, I may add them later when time permits. It shouldn't be too hard.
>> 
> I
>   
>> basically just have to take the time to pick out the ranges and add them
>> 
> to
>   
>> the array. 
>>
>> ===
>> Example use: #randstr('8,16', 'alphanumericupper')#
>> ===
>>
>> 
>> function randStr(strLen, charSet)
>> {
>>  var usableChars = '';
>>  var charSets = arrayNew(1);
>>  var tmpStr = '';
>>  
>>  charSets[1] = '48,57';  // 0-9
>>  charSets[2] = '65,90';  // A-Z
>>  charSets[3] = '97,122'; // a=z
>>  
>>  if (findnocase('alpha', charSet))
>>  { usableChars = listappend(usableChars, 3); }
>>  
>>  if (findnocase('numeric', charSet))
>>  { usableChars = listappend(usableChars, 1); }
>>  
>>  if (findnocase('upper', charSet))
>>  { usableChars = listappend(usableChars, 2); }
>>  
>>  if (len(usableChars) is 0)
>>  { usableChars = '1,2,3'; }
>>
>>  if(listlen(strLen) gt 1 and listfirst(strLen) lt listlast(strLen))
>>  { strLen = randrange(listfirst(strLen), listlast(strLen)); }
>>  else if (val(strLen) is 0)
>>  { strLen = 8; }
>>  
>>  for (i=1; i lte strLen; i=i+1)
>>  {
>>  if (listlen(usableChars) gt 1)
>>  { 
>>  Set = listgetat(usableChars, randrange(1,
>> listlen(usableChars)));
>>  thisChar = chr(randrange(listfirst(charSets[Set]),
>> listlast(charSets[Set])));
>>  tmpStr = tmpStr & thisChar;
>>  }
>>  else
>>  { 
>>  Set = usableChars;
>>  thisChar = chr(randrange(listfirst(charSets[Set]),
>> listlast(charSets[Set])));
>>  tmpStr = tmpStr &
>> chr(randrange(listfirst(charSets[usableChars]),
>> listlast(charSets[usab

RE: automatically generate password

The strings are pretty random. It picks a random charset to get a character
from... then it picks a random character IN that charset 

I COULD then loop from 1 to the final strings length; pull out a random char
each time and use them to rebuild it from left to right but I dont see much
point ;-) 

-Original Message-
From: Christopher Jordan [mailto:[EMAIL PROTECTED] 
Sent: Thursday, December 21, 2006 4:44 PM
To: CF-Talk
Subject: Re: automatically generate password

I wrote a random number generator for CFLib.org called getRandomNumber 
, but it only returns numbers. :o( you 
can however pass it any length (in digits) that you want and you'll get 
a number back with that many digits. I like the idea of being able to 
tell the UDF what character set to use. Good Idea. I don't see you 
seeding the random number generator. Check out my udf (the link above) 
and see what I'm doing for seeding. My original version had that all 
screwed up and my numbers weren't very random at all... :o( My buddy, 
Steven worked on that bit with me and I think the solution we came up 
with is pretty cool.




Bobby Hartsfield wrote:
> Ok... here it is. I just submitted it to cflib.org so it should be up
there
> soon under the name 'randStr'. I checked the processing time for a bit and
> couldn't get anything over 0 until I started generating strings 200+ in
> length.
>
> The two required params are strLen and charSet
>
> strLen: can either be a single digit like 8 which would generate an 8
> character string every time. OR it can be a comma delimited list of 2
> numbers such as 8,16 which would result in a random length between 8 and
16
> characters.
>
> charSet: can be any combination of the three words alpha, numeric and
upper
> that you can come up with.
>
> EXAMPLES:
> Alpha
> Alphanumeric
> Alphanumericupper
> Alphaupper
> Etc...
>
> Alpha: a-z
> Numeric: 0-9
> Upper: A-Z
>
>
> I did not add a lower option since you can just leave upper out and
achieve
> that.
>
> If you use upper, you will have a mix of uppercase and lowercase
characters.
> If you want only upper, wrap the final output in ucase().
>
> You COULD use 'numeric' as the charset but that will just result in a
random
> number at the specified length... there are better ways to do that.
>
> I did not put in special characters because I don't like them :-)
> Actually, special characters are spread out in the ascii ranges so they
are
> a pain, I may add them later when time permits. It shouldn't be too hard.
I
> basically just have to take the time to pick out the ranges and add them
to
> the array. 
>
> ===
> Example use: #randstr('8,16', 'alphanumericupper')#
> ===
>
> 
> function randStr(strLen, charSet)
> {
>   var usableChars = '';
>   var charSets = arrayNew(1);
>   var tmpStr = '';
>   
>   charSets[1] = '48,57';  // 0-9
>   charSets[2] = '65,90';  // A-Z
>   charSets[3] = '97,122'; // a=z
>   
>   if (findnocase('alpha', charSet))
>   { usableChars = listappend(usableChars, 3); }
>   
>   if (findnocase('numeric', charSet))
>   { usableChars = listappend(usableChars, 1); }
>   
>   if (findnocase('upper', charSet))
>   { usableChars = listappend(usableChars, 2); }
>   
>   if (len(usableChars) is 0)
>   { usableChars = '1,2,3'; }
>
>   if(listlen(strLen) gt 1 and listfirst(strLen) lt listlast(strLen))
>   { strLen = randrange(listfirst(strLen), listlast(strLen)); }
>   else if (val(strLen) is 0)
>   { strLen = 8; }
>   
>   for (i=1; i lte strLen; i=i+1)
>   {
>   if (listlen(usableChars) gt 1)
>   { 
>   Set = listgetat(usableChars, randrange(1,
> listlen(usableChars)));
>   thisChar = chr(randrange(listfirst(charSets[Set]),
> listlast(charSets[Set])));
>   tmpStr = tmpStr & thisChar;
>   }
>   else
>   { 
>   Set = usableChars;
>   thisChar = chr(randrange(listfirst(charSets[Set]),
> listlast(charSets[Set])));
>   tmpStr = tmpStr &
> chr(randrange(listfirst(charSets[usableChars]),
> listlast(charSets[usableChars]))); 
>   }
>   }
>   return tmpStr;
> }
> 
>
>
>   

-- 
http://www.cjordan.info





~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264834
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: CSS / HTML Compliant issue

Thanks John, I found an example on the maxdesign site that resembled
what I was
Trying to achieve. Now to tweak it a bit and should be good to go :-)

-Original Message-
From: John Cox [mailto:[EMAIL PROTECTED] 
Sent: Thursday, December 21, 2006 4:27 PM
To: CF-Talk
Subject: Re: CSS / HTML Compliant issue

On 12/21/06, Adkins, Randy <[EMAIL PROTECTED]> wrote:
>
> Okay I did that, however the box (DIV) does not act as a link until 
> you mouse over the text itself.
> My goal is to be able to mouse over the box or the text and click to 
> proceed to the link not just the text.

Then use a span inside the anchor, but you can't use block level items
inside an anchor AFAIK.

Better yet, instead of using a divisions, you should be using a list or
a dl / dt, since that is really what your menu is.  Don't get too bogged
down in using divisions, rather use the correct HTML element for the
job.

http://css.maxdesign.com.au/listamatic/

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264833
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: automatically generate password

I wrote a random number generator for CFLib.org called getRandomNumber 
, but it only returns numbers. :o( you 
can however pass it any length (in digits) that you want and you'll get 
a number back with that many digits. I like the idea of being able to 
tell the UDF what character set to use. Good Idea. I don't see you 
seeding the random number generator. Check out my udf (the link above) 
and see what I'm doing for seeding. My original version had that all 
screwed up and my numbers weren't very random at all... :o( My buddy, 
Steven worked on that bit with me and I think the solution we came up 
with is pretty cool.




Bobby Hartsfield wrote:
> Ok... here it is. I just submitted it to cflib.org so it should be up there
> soon under the name 'randStr'. I checked the processing time for a bit and
> couldn't get anything over 0 until I started generating strings 200+ in
> length.
>
> The two required params are strLen and charSet
>
> strLen: can either be a single digit like 8 which would generate an 8
> character string every time. OR it can be a comma delimited list of 2
> numbers such as 8,16 which would result in a random length between 8 and 16
> characters.
>
> charSet: can be any combination of the three words alpha, numeric and upper
> that you can come up with.
>
> EXAMPLES:
> Alpha
> Alphanumeric
> Alphanumericupper
> Alphaupper
> Etc...
>
> Alpha: a-z
> Numeric: 0-9
> Upper: A-Z
>
>
> I did not add a lower option since you can just leave upper out and achieve
> that.
>
> If you use upper, you will have a mix of uppercase and lowercase characters.
> If you want only upper, wrap the final output in ucase().
>
> You COULD use 'numeric' as the charset but that will just result in a random
> number at the specified length... there are better ways to do that.
>
> I did not put in special characters because I don't like them :-)
> Actually, special characters are spread out in the ascii ranges so they are
> a pain, I may add them later when time permits. It shouldn't be too hard. I
> basically just have to take the time to pick out the ranges and add them to
> the array. 
>
> ===
> Example use: #randstr('8,16', 'alphanumericupper')#
> ===
>
> 
> function randStr(strLen, charSet)
> {
>   var usableChars = '';
>   var charSets = arrayNew(1);
>   var tmpStr = '';
>   
>   charSets[1] = '48,57';  // 0-9
>   charSets[2] = '65,90';  // A-Z
>   charSets[3] = '97,122'; // a=z
>   
>   if (findnocase('alpha', charSet))
>   { usableChars = listappend(usableChars, 3); }
>   
>   if (findnocase('numeric', charSet))
>   { usableChars = listappend(usableChars, 1); }
>   
>   if (findnocase('upper', charSet))
>   { usableChars = listappend(usableChars, 2); }
>   
>   if (len(usableChars) is 0)
>   { usableChars = '1,2,3'; }
>
>   if(listlen(strLen) gt 1 and listfirst(strLen) lt listlast(strLen))
>   { strLen = randrange(listfirst(strLen), listlast(strLen)); }
>   else if (val(strLen) is 0)
>   { strLen = 8; }
>   
>   for (i=1; i lte strLen; i=i+1)
>   {
>   if (listlen(usableChars) gt 1)
>   { 
>   Set = listgetat(usableChars, randrange(1,
> listlen(usableChars)));
>   thisChar = chr(randrange(listfirst(charSets[Set]),
> listlast(charSets[Set])));
>   tmpStr = tmpStr & thisChar;
>   }
>   else
>   { 
>   Set = usableChars;
>   thisChar = chr(randrange(listfirst(charSets[Set]),
> listlast(charSets[Set])));
>   tmpStr = tmpStr &
> chr(randrange(listfirst(charSets[usableChars]),
> listlast(charSets[usableChars]))); 
>   }
>   }
>   return tmpStr;
> }
> 
>
>
>   

-- 
http://www.cjordan.info



~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264832
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Javascript help

Yes, it is as vanilla as it gets and easiest for most people to read and
understand. But if you'd like to make it NOT work in all browsers that can
read JS you can try some of these lol

document.forms[0].myfield.value
document.forms[0]['myfield'].value
document.forms['myform'].myfield.value
document.forms['myform']['myfield'] .value


-Original Message-
From: Charlie Griefer [mailto:[EMAIL PROTECTED] 
Sent: Thursday, December 21, 2006 4:23 PM
To: CF-Talk
Subject: Re: Javascript help

i'm pretty sure it'll work.  but of course i say that and invariably
someone comes along and proves that it won't :)

seriously tho.  document.formname.fieldname.value is about as standard
as it gets AFAIK.

On 12/21/06, loathe <[EMAIL PROTECTED]> wrote:
> You can stack arguments that way, but will calling the field that way work
> cross browser?
>
> I don't know, I still write it using different techniques.
>
> > -Original Message-
> > From: Charlie Griefer [mailto:[EMAIL PROTECTED]
> > Sent: Thursday, December 21, 2006 4:09 PM
> > To: CF-Talk
> > Subject: Re: Javascript help
> >
> > That should work cross-browser, no?  it's pretty standard JS syntax.
> >
> > onfocus="statement1; statement2; statement3..."
> >
> > as long as each is separated by a semi-colon it should be ok?
> >
> > On 12/21/06, loathe <[EMAIL PROTECTED]> wrote:
> > > No it won't.
> > >
> > > For that you'll need a function and you'll need to write a javascript
> > > browser diction script and have separate clauses in the function for
> > each
> > > browser.
> > >
> > > Mainly you'll use document.all and document.getElementById()
> > >
> > > > -Original Message-
> > > > From: Doug Brown [mailto:[EMAIL PROTECTED]
> > > > Sent: Thursday, December 21, 2006 3:51 PM
> > > > To: CF-Talk
> > > > Subject: Re: Javascript help
> > > >
> > > > This seems to work, but will it work in all browser?
> > > >
> > > >  onFocus="document.updClassified.asking1.value =
> > > > '',document.updClassified.asking2.value = ''"
> > > >
> > > > Doug B.
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
> 



~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264831
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: upload excel to update database

2006-12-21 Thread Chad Gray

Ya, I ran into this.  My work around was to put the excel file on my computer 
in the exact same path at the web server.

The web server happened to store the files on the D drive.  My D drive was my 
CD burner.  So I burnt the path with Excel file onto a CD and mapped the Excel 
into the Access file from the CD.

Worked great, but it is quite a kludge.  :)



> -Original Message-
> From: Claude Schneegans [mailto:[EMAIL PROTECTED]
> Sent: Thursday, December 21, 2006 2:20 PM
> To: CF-Talk
> Subject: Re: upload excel to update database
> 
>  >>In MS Access do an external link to an Excel file.
> 
> This could work also, but the problem is that the link is an absolute
> path to the file on your disk.
> At least, I've never found a way to make it relative to the main
> database, then it will not work when you transfer the database on your
> server.
> 
> --
> ___
> REUSE CODE! Use custom tags;
> See http://www.contentbox.com/claude/customtags/tagstore.cfm
> (Please send any spam to this address: [EMAIL PROTECTED])
> Thanks.
> 
> 
> 

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264830
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: CSS / HTML Compliant issue

2006-12-21 Thread Sandra Clark

You can't, without using JavaScript.

Per the spec, inline elements (such as an anchor) may not contain block
level elements such as a .

If you really want to only use CSS.  Use display:block on your anchors and
pad them to achieve the height you want so that the anchor is as big.  Get
rid of the divs and use an unordered list.  (Structured HTML does really
make life easier, I promise)

http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd";>

http://www.w3.org/1999/xhtml"; xml:lang="en" lang="en">

Not This (Compliant)
Like This (non-compliant)
Program Services
Admission Process
Location / Directions
Payment for Services
Confidentiality / Privacy
Contact Us

Sandra Clark
==
http://www.shayna.com
Training in Cascading Style Sheets and Accessibility

-Original Message-
From: Adkins, Randy [mailto:[EMAIL PROTECTED] 
Sent: Thursday, December 21, 2006 4:11 PM
To: CF-Talk
Subject: RE: CSS / HTML Compliant issue

Okay I did that, however the box (DIV) does not act as a link until you
mouse over the text itself.
My goal is to be able to mouse over the box or the text and click to proceed
to the link not just the text. 

-Original Message-
From: John Cox [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 21, 2006 4:03 PM
To: CF-Talk
Subject: Re: CSS / HTML Compliant issue

On 12/21/06, Adkins, Randy <[EMAIL PROTECTED]> wrote:
>
> If you will look at this one page, I am having a problem with being 
> compliant with CSS and HTML and achieving the desired behavior and 
> look.
>
> http://test.mksweb.net/

Take your width and positioning out of your anchor elements:

a.LeftNav { width:191px;font-weight:bold;color:#525252;font-family:
'Arial';text-decoration: none;font-size: 13px;}

and place them in your division definitions.  Once done, move your anchors
inside your divisions.

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264829
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: CSS / HTML Compliant issue

2006-12-21 Thread Dave Francis

I did this with with  outside the href at www.murmar.com - Not 
exactly
what you want, but should be adaptable. Stylesheet is styles.css.
And yes, I know this is a frowned-upon use of , but I'm not 
changing it
now.

-Original Message-
From: Adkins, Randy [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 21, 2006 4:11 PM
To: CF-Talk
Subject: RE: CSS / HTML Compliant issue

Okay I did that, however the box (DIV) does not act as a link until you
mouse over the text itself.
My goal is to be able to mouse over the box or the text and click to
proceed to the link not just
the text.

-Original Message-
From: John Cox [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 21, 2006 4:03 PM
To: CF-Talk
Subject: Re: CSS / HTML Compliant issue

On 12/21/06, Adkins, Randy <[EMAIL PROTECTED]> wrote:
>
> If you will look at this one page, I am having a problem with being
> compliant with CSS and HTML and achieving the desired behavior and
> look.
>
> http://test.mksweb.net/

Take your width and positioning out of your anchor elements:

a.LeftNav { width:191px;font-weight:bold;color:#525252;font-family:
'Arial';text-decoration: none;font-size: 13px;}

and place them in your division definitions.  Once done, move your
anchors inside your divisions.

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264828
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: automatically generate password

Ok... here it is. I just submitted it to cflib.org so it should be up there
soon under the name 'randStr'. I checked the processing time for a bit and
couldnt get anything over 0 until I started generating strings 200+ in
length.

The two required params are strLen and charSet

strLen: can either be a single digit like 8 which would generate an 8
character string every time. OR it can be a comma delimited list of 2
numbers such as 8,16 which would result in a random length between 8 and 16
characters.

charSet: can be any combination of the three words alpha, numeric and upper
that you can come up with.

EXAMPLES:
Alpha
Alphanumeric
Alphanumericupper
Alphaupper
Etc...

Alpha: a-z
Numeric: 0-9
Upper: A-Z


I did not add a lower option since you can just leave upper out and achieve
that.

If you use upper, you will have a mix of uppercase and lowercase characters.
If you want only upper, wrap the final output in ucase().

You COULD use 'numeric' as the charset but that will just result in a random
number at the specified length... there are better ways to do that.

I did not put in special characters because I dont like them :-)
Actually, special characters are spread out in the ascii ranges so they are
a pain, I may add them later when time permits. It shouldn't be too hard. I
basically just have to take the time to pick out the ranges and add them to
the array. 

===
Example use: #randstr('8,16', 'alphanumericupper')#
===


function randStr(strLen, charSet)
{
var usableChars = '';
var charSets = arrayNew(1);
var tmpStr = '';

charSets[1] = '48,57';  // 0-9
charSets[2] = '65,90';  // A-Z
charSets[3] = '97,122'; // a=z

if (findnocase('alpha', charSet))
{ usableChars = listappend(usableChars, 3); }

if (findnocase('numeric', charSet))
{ usableChars = listappend(usableChars, 1); }

if (findnocase('upper', charSet))
{ usableChars = listappend(usableChars, 2); }

if (len(usableChars) is 0)
{ usableChars = '1,2,3'; }

if(listlen(strLen) gt 1 and listfirst(strLen) lt listlast(strLen))
{ strLen = randrange(listfirst(strLen), listlast(strLen)); }
else if (val(strLen) is 0)
{ strLen = 8; }

for (i=1; i lte strLen; i=i+1)
{
if (listlen(usableChars) gt 1)
{ 
Set = listgetat(usableChars, randrange(1,
listlen(usableChars)));
thisChar = chr(randrange(listfirst(charSets[Set]),
listlast(charSets[Set])));
tmpStr = tmpStr & thisChar;
}
else
{ 
Set = usableChars;
thisChar = chr(randrange(listfirst(charSets[Set]),
listlast(charSets[Set])));
tmpStr = tmpStr &
chr(randrange(listfirst(charSets[usableChars]),
listlast(charSets[usableChars]))); 
}
}
return tmpStr;
}



-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.432 / Virus Database: 268.15.26/594 - Release Date: 12/20/2006
3:54 PM
 



~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264827
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: CSS / HTML Compliant issue

On 12/21/06, Adkins, Randy <[EMAIL PROTECTED]> wrote:
>
> Okay I did that, however the box (DIV) does not act as a link until you
> mouse over the text itself.
> My goal is to be able to mouse over the box or the text and click to
> proceed to the link not just
> the text.

Then use a span inside the anchor, but you can't use block level items
inside an anchor AFAIK.

Better yet, instead of using a divisions, you should be using a list or a dl
/ dt, since that is really what your menu is.  Don't get too bogged down in
using divisions, rather use the correct HTML element for the job.

http://css.maxdesign.com.au/listamatic/

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264826
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Javascript help

Check out jQuery. This sort of thing would be a snap in jQuery 
(http://jQuery.com).


Doug Brown wrote:
> I have a form with 2 text fields and some radio button, and what I would like 
> to do is clear any text in the text fields if any of the radio buttons are 
> selected. I can do this with one text field, but not sure how to work it with 
> two
>
> This will work with one text field...
>
>   ClassAdDetails.quantity_option eq 
> "quantity">value="#ClassAdDetails.AQuantity#">
>
>  onFocus="document.updClassified.Aquantity.value = ''">
>
>
>
> But.Say just one of these text fields have a value, how can I clear 
> either one when I click on any one of the radio buttons.
>
>  
>  
>
>
>  onFocus="?">
>  onFocus="?">
>  onFocus="?">
>
>
> Doug B.
>
> 

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264825
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Javascript help

i'm pretty sure it'll work.  but of course i say that and invariably
someone comes along and proves that it won't :)

seriously tho.  document.formname.fieldname.value is about as standard
as it gets AFAIK.

On 12/21/06, loathe <[EMAIL PROTECTED]> wrote:
> You can stack arguments that way, but will calling the field that way work
> cross browser?
>
> I don't know, I still write it using different techniques.
>
> > -Original Message-
> > From: Charlie Griefer [mailto:[EMAIL PROTECTED]
> > Sent: Thursday, December 21, 2006 4:09 PM
> > To: CF-Talk
> > Subject: Re: Javascript help
> >
> > That should work cross-browser, no?  it's pretty standard JS syntax.
> >
> > onfocus="statement1; statement2; statement3..."
> >
> > as long as each is separated by a semi-colon it should be ok?
> >
> > On 12/21/06, loathe <[EMAIL PROTECTED]> wrote:
> > > No it won't.
> > >
> > > For that you'll need a function and you'll need to write a javascript
> > > browser diction script and have separate clauses in the function for
> > each
> > > browser.
> > >
> > > Mainly you'll use document.all and document.getElementById()
> > >
> > > > -Original Message-
> > > > From: Doug Brown [mailto:[EMAIL PROTECTED]
> > > > Sent: Thursday, December 21, 2006 3:51 PM
> > > > To: CF-Talk
> > > > Subject: Re: Javascript help
> > > >
> > > > This seems to work, but will it work in all browser?
> > > >
> > > >  onFocus="document.updClassified.asking1.value =
> > > > '',document.updClassified.asking2.value = ''"
> > > >
> > > > Doug B.
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
> 

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264824
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Javascript help

Also your using a comma and not a semi colon, sorry forgot to add that.

> -Original Message-
> From: loathe [mailto:[EMAIL PROTECTED]
> Sent: Thursday, December 21, 2006 4:07 PM
> To: CF-Talk
> Subject: RE: Javascript help
> 
> No it won't.
> 
> For that you'll need a function and you'll need to write a javascript
> browser diction script and have separate clauses in the function for each
> browser.
> 
> Mainly you'll use document.all and document.getElementById()
> 
> > -Original Message-
> > From: Doug Brown [mailto:[EMAIL PROTECTED]
> > Sent: Thursday, December 21, 2006 3:51 PM
> > To: CF-Talk
> > Subject: Re: Javascript help
> >
> > This seems to work, but will it work in all browser?
> >
> >  onFocus="document.updClassified.asking1.value =
> > '',document.updClassified.asking2.value = ''"
> >
> > Doug B.
> >
> >
> >
> 
> 

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264823
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Javascript help

You can stack arguments that way, but will calling the field that way work
cross browser?

I don't know, I still write it using different techniques.

> -Original Message-
> From: Charlie Griefer [mailto:[EMAIL PROTECTED]
> Sent: Thursday, December 21, 2006 4:09 PM
> To: CF-Talk
> Subject: Re: Javascript help
> 
> That should work cross-browser, no?  it's pretty standard JS syntax.
> 
> onfocus="statement1; statement2; statement3..."
> 
> as long as each is separated by a semi-colon it should be ok?
> 
> On 12/21/06, loathe <[EMAIL PROTECTED]> wrote:
> > No it won't.
> >
> > For that you'll need a function and you'll need to write a javascript
> > browser diction script and have separate clauses in the function for
> each
> > browser.
> >
> > Mainly you'll use document.all and document.getElementById()
> >
> > > -Original Message-
> > > From: Doug Brown [mailto:[EMAIL PROTECTED]
> > > Sent: Thursday, December 21, 2006 3:51 PM
> > > To: CF-Talk
> > > Subject: Re: Javascript help
> > >
> > > This seems to work, but will it work in all browser?
> > >
> > >  onFocus="document.updClassified.asking1.value =
> > > '',document.updClassified.asking2.value = ''"
> > >
> > > Doug B.
> > >
> > >
> > >
> >
> >
> 
> 

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264822
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

SOLVED Re: SESSION vars and subdomains

2006-12-21 Thread Bryan Stevenson

Thanks Scott...actually I just had to flick setClinetCookies to yes and all is 
well

Cheers

Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electricedgesystems.com
- Original Message - 
From: "Scott Stroz" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Thursday, December 21, 2006 1:06 PM
Subject: Re: SESSION vars and subdomains


>I have seen this question before,  In your  tag (or in
> Application.cfc) set 'setDomainCookies' equal to yes. I think that will help
> resolve this issue.
>
> On 12/21/06, Bryan Stevenson < [EMAIL PROTECTED]> wrote:
>>
>> Hey All,
>>
>> I have an app that works fine locally (via localhost), but live at
>> HostMySite, SESSION vars get set during a login process, but as soon as I
>> cflocate the user (after successful login), the SESSION vars vanish.
>>
>> The live app is hosted at a URL like so: http://subDomain.domainName.com
>>
>> So are there known issues with SESSION vars and sub-domains?
>>
>> CFMX 7.
>>
>> TIA
>>
>> Cheers
>>
>> Bryan Stevenson B.Comm.
>> VP & Director of E-Commerce Development
>> Electric Edge Systems Group Inc.
>> phone: 250.480.0642
>> fax: 250.480.1264
>> cell: 250.920.8830
>> e-mail: [EMAIL PROTECTED]
>> web: www.electricedgesystems.com
>>
>>
>>
>
> 

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264821
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: What's the best way to handle this?

What's the environment?

In IIS you can give sites custom HTTP headers, which you could use to store
a siteID.

Then you use the ID to query the DB and the site specific settings.  One
code base that way, any changes you make would update all the sites at once.

Or you could have something in your application.cfm or application.cfc that
looks at cgi.server_name like you said, but then you would have to update a
list of the sites, with the HTTP headers you would add the ID when you first
set up the web site in IIS, and never have to worry about it again.

> -Original Message-
> From: Rick Faircloth [mailto:[EMAIL PROTECTED]
> Sent: Thursday, December 21, 2006 2:54 PM
> To: CF-Talk
> Subject: SOT: What's the best way to handle this?
> 
> Hi, all.
> 
> I'm building my multi-domain CMS system where
> I have a custom website on the front, a multi-user
> CMS in the middle, and an individual database on the backend.
> 
> My question is:  What's the best way to get the user
> to the CMS?  CNAME?  Masked Forwarding?
> 
> Let's say the user has the domain bodafordhomes.com.
> 
> Could I set up a CNAME Alias called SiteManager.BodafordHomes.com
> that would go to my CMS, called "RESM.WhiteStoneMedia.com"?
> 
> Can CNAME's be used that way?  Or would I have to use masked forwarding
> to go to a completely different domain, in this case, from
> bodadfordhomes.com
> to whitestonemedia.com?
> 
> Ideally, I would be able to setup a CNAME for each domain that would use
> the CMS and simply route the CNAME to my CMS for whatever domain is
> using it.  I would have a query on RESM.WhiteStoneMedia.com that would
> check the CGI.Server_Name and assign appropriate variables based on the
> domain name used.
> 
> Thoughts?  Suggestions?
> 
> Rick
> 
> 
> 
> 

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264820
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: CSS / HTML Compliant issue

Okay I did that, however the box (DIV) does not act as a link until you
mouse over the text itself.
My goal is to be able to mouse over the box or the text and click to
proceed to the link not just
the text. 

-Original Message-
From: John Cox [mailto:[EMAIL PROTECTED] 
Sent: Thursday, December 21, 2006 4:03 PM
To: CF-Talk
Subject: Re: CSS / HTML Compliant issue

On 12/21/06, Adkins, Randy <[EMAIL PROTECTED]> wrote:
>
> If you will look at this one page, I am having a problem with being 
> compliant with CSS and HTML and achieving the desired behavior and 
> look.
>
> http://test.mksweb.net/

Take your width and positioning out of your anchor elements:

a.LeftNav { width:191px;font-weight:bold;color:#525252;font-family:
'Arial';text-decoration: none;font-size: 13px;}

and place them in your division definitions.  Once done, move your
anchors inside your divisions.

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264819
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Javascript help

That should work cross-browser, no?  it's pretty standard JS syntax.

onfocus="statement1; statement2; statement3..."

as long as each is separated by a semi-colon it should be ok?

On 12/21/06, loathe <[EMAIL PROTECTED]> wrote:
> No it won't.
>
> For that you'll need a function and you'll need to write a javascript
> browser diction script and have separate clauses in the function for each
> browser.
>
> Mainly you'll use document.all and document.getElementById()
>
> > -Original Message-
> > From: Doug Brown [mailto:[EMAIL PROTECTED]
> > Sent: Thursday, December 21, 2006 3:51 PM
> > To: CF-Talk
> > Subject: Re: Javascript help
> >
> > This seems to work, but will it work in all browser?
> >
> >  onFocus="document.updClassified.asking1.value =
> > '',document.updClassified.asking2.value = ''"
> >
> > Doug B.
> >
> >
> >
>
> 

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264818
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

I am really trying to get into test driven development as the benefits are
fairly obvious after having done development any other way. However, in terms
of doing this with ColdFusion, I am either not getting it or there is a lot of
talk going on regarding TDD, but not much in actual practice.

My biggest issue comes with object dependencies. Ideally, your objects are as
loosely coupled as possible, but it is simply not possible to have an
application full of completely disjoint objects with no dependencies at all.
One of the premises of unit testing though is to test only the functionality of
one individual object or unit and not test all of its dependencies. Other
languages appear to handle this with mock objects which allow for simulating
and testing any object dependencies. However, the mock object frameworks for
Java and other languages simply don't port to ColdFusion because of language
construct differences. Without a mock object framework, the only other option
I see is to hand create and maintain stub or mock objects, and this just does
not seem like a feasible practice in an application of any size.

So, how do you test ColdFusion objects when there are dependencies involved?

Thanks.

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264817
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: SESSION vars and subdomains

2006-12-21 Thread Scott Stroz

I have seen this question before,  In your  tag (or in
Application.cfc) set 'setDomainCookies' equal to yes. I think that will help
resolve this issue.

On 12/21/06, Bryan Stevenson < [EMAIL PROTECTED]> wrote:
>
> Hey All,
>
> I have an app that works fine locally (via localhost), but live at
> HostMySite, SESSION vars get set during a login process, but as soon as I
> cflocate the user (after successful login), the SESSION vars vanish.
>
> The live app is hosted at a URL like so: http://subDomain.domainName.com
>
> So are there known issues with SESSION vars and sub-domains?
>
> CFMX 7.
>
> TIA
>
> Cheers
>
> Bryan Stevenson B.Comm.
> VP & Director of E-Commerce Development
> Electric Edge Systems Group Inc.
> phone: 250.480.0642
> fax: 250.480.1264
> cell: 250.920.8830
> e-mail: [EMAIL PROTECTED]
> web: www.electricedgesystems.com
>
>
> 

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264815
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: CSS / HTML Compliant issue

BTW:  This behavior works in IE 7 but not in Firefox.

-Original Message-
From: Adkins, Randy [mailto:[EMAIL PROTECTED] 
Sent: Thursday, December 21, 2006 3:58 PM
To: CF-Talk
Subject: CSS / HTML Compliant issue

If you will look at this one page, I am having a problem with being
compliant with CSS and HTML and achieving the desired behavior and look.

http://test.mksweb.net/

Can someone see what I am doing wrong? CSS validates fine. HTML doesn't.
I know it is the positioning
of the DIV tags in relation to the A HREF tag but that throws off the
look and feel.

BTW: This is just a small section of the site which is all CSS. No
tables or anything. 

Thanks!

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264816
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Javascript help

No it won't.

For that you'll need a function and you'll need to write a javascript
browser diction script and have separate clauses in the function for each
browser.

Mainly you'll use document.all and document.getElementById()

> -Original Message-
> From: Doug Brown [mailto:[EMAIL PROTECTED]
> Sent: Thursday, December 21, 2006 3:51 PM
> To: CF-Talk
> Subject: Re: Javascript help
> 
> This seems to work, but will it work in all browser?
> 
>  onFocus="document.updClassified.asking1.value =
> '',document.updClassified.asking2.value = ''"
> 
> Doug B.
> 
> 
> 

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264814
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: CSS / HTML Compliant issue

On 12/21/06, Adkins, Randy <[EMAIL PROTECTED]> wrote:
>
> If you will look at this one page, I am having a problem with being
> compliant with CSS and HTML and
> achieving the desired behavior and look.
>
> http://test.mksweb.net/

Take your width and positioning out of your anchor elements:

a.LeftNav { width:191px;font-weight:bold;color:#525252;font-family:
'Arial';text-decoration: none;font-size: 13px;}

and place them in your division definitions.  Once done, move your
anchors inside your divisions.

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264813
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

SESSION vars and subdomains

2006-12-21 Thread Bryan Stevenson

Hey All,

I have an app that works fine locally (via localhost), but live at HostMySite, 
SESSION vars get set during a login process, but as soon as I cflocate the user 
(after successful login), the SESSION vars vanish.

The live app is hosted at a URL like so: http://subDomain.domainName.com

So are there known issues with SESSION vars and sub-domains?

CFMX 7.

TIA

Cheers

Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electricedgesystems.com


~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264812
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Javascript help

1. Don't use on focus, use on click.  Users (well power users) and the
disabled tab through form fields, and if you do on focus it will empty to
form field even if they don't want to.

2.  When dealing with multiple fields I would recommend your using a
function in a script block kicked off by the onchange event.

Example:



JS Test

function clearForm(){
document.myForm.myField1.value="";
document.myForm.myField2.value="";
}











Also a couple of other tips.

1. Try and use XHTML.  All attributes and tags need to be lower cased.
2. Only use pound signs when they are needed, same with parens.  
3. DO NOT use camel case inside a tag unless your referencing a variable,
everything else should be in lowers.
4. If you decide you don't want to create a function to handle this you can
string statements together in the event handler using the semi-colon ;
Example:



One thing to be aware of with this is that you need to use different quotes,
one for CF/HTML and one for JS.

See you're declaring a string inside where your telling the object what
event handler to run, or in this case writing the event handler on the tag.
I use double quotes in tags, and singles in JS, it's a bit more difficult
when you're creating dynamic SQL as you have to use the single quote.

Anyway, hope it helps.

> -Original Message-
> From: Doug Brown [mailto:[EMAIL PROTECTED]
> Sent: Thursday, December 21, 2006 3:34 PM
> To: CF-Talk
> Subject: Javascript help
> 
> I have a form with 2 text fields and some radio button, and what I would
> like to do is clear any text in the text fields if any of the radio
> buttons are selected. I can do this with one text field, but not sure how
> to work it with two
> 
> This will work with one text field...
> 
>   ClassAdDetails.quantity_option eq
> "quantity">value="#ClassAdDetails.AQuantity#">
> 
>  onFocus="document.updClassified.Aquantity.value = ''">
> 
> 
> 
> But.Say just one of these text fields have a value, how can I clear
> either one when I click on any one of the radio buttons.
> 
>  
>  
> 
> 
>  onFocus="?">
>  onFocus="?">
>  onFocus="?">
> 
> 
> Doug B.
> 
> 

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264811
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

CSS / HTML Compliant issue

If you will look at this one page, I am having a problem with being
compliant with CSS and HTML and
achieving the desired behavior and look.
 
http://test.mksweb.net/
 
Can someone see what I am doing wrong? CSS validates fine. HTML doesn't.
I know it is the positioning
of the DIV tags in relation to the A HREF tag but that throws off the
look and feel.
 
BTW: This is just a small section of the site which is all CSS. No
tables or anything. 
 
Thanks!


~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264810
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: redirect to home after login

No sweat. What are forums for, right? Holler if something doesn't make 
sense. :o)

Chris

Richard White wrote:
> hi christopher, thanks for your reply. 
>
> thanks you have got the point and made me understand it much better :)
>
> thanks again chris
>
> 

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264809
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Javascript help

This seems to work, but will it work in all browser?

 onFocus="document.updClassified.asking1.value =
'',document.updClassified.asking2.value = ''"

Doug B.


~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264808
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Is there a better way to do this

I think I see what your going for, but would like to have better
requirements.

Try this:

























 








   



> -Original Message-
> From: Bruce Sorge [mailto:[EMAIL PROTECTED]
> Sent: Thursday, December 21, 2006 3:33 PM
> To: CF-Talk
> Subject: Is there a better way to do this
> 
> First I would like to thank those of you who replied to my session time
> out
> issue without being condescending. I still am amazed that I actually
> posted
> that question and I feel totally stupid. LOL




~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264807
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Javascript help

On the radio button...

Onclick="document.myform.mytextfield.value='';"

If you are saying you want to clear both text fields

Onclick="document.myform.mytextfield.value='';
document.myform.myothertextfield.value='';"



-Original Message-
From: Doug Brown [mailto:[EMAIL PROTECTED] 
Sent: Thursday, December 21, 2006 3:34 PM
To: CF-Talk
Subject: Javascript help

I have a form with 2 text fields and some radio button, and what I would
like to do is clear any text in the text fields if any of the radio buttons
are selected. I can do this with one text field, but not sure how to work it
with two

This will work with one text field...

 value="#ClassAdDetails.AQuantity#">





But.Say just one of these text fields have a value, how can I clear
either one when I click on any one of the radio buttons.

 
 







Doug B.



~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264806
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Javascript help

I have a form with 2 text fields and some radio button, and what I would like 
to do is clear any text in the text fields if any of the radio buttons are 
selected. I can do this with one text field, but not sure how to work it with 
two

This will work with one text field...

 value="#ClassAdDetails.AQuantity#">





But.Say just one of these text fields have a value, how can I clear either 
one when I click on any one of the radio buttons.

 
 







Doug B.

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264805
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Is there a better way to do this

2006-12-21 Thread Bruce Sorge

First I would like to thank those of you who replied to my session time out
issue without being condescending. I still am amazed that I actually posted
that question and I feel totally stupid. LOL

Now for my new issue.
I have an edit form that I generate dynamically. There are a total of 10
rows and three columns in this form. What I am doing is, if there is a
record in the table, I pre-fill however many rows that there are records in
the database, and the rest of the rows are blank. I tried using if
statements checking for data in each row, and if there is data show the
pre-filled rows and then spit out the remainder of the rows with blank
fields but everything I tried only produced the rows that had data and
nothing else. Here is what I have.

Surely there has to be a more elegant way of doing this?
One thing that I noticed though. in the first loop, if I put to="10", then I
get the X number of rows pre-filled, then I get the remainder of the rows
output but no data like so:

And so on until all 10 rows are complete. So I know that it is actually
looping through the rows all 10 times, so there has to be a way to get the
blank records to fill in these rows.

Thanks,
--
Bruce Sorge

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264804
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: No, I'll call you...

2006-12-21 Thread Ian Skinner

Hmm, I hadn't thought of that.  Net set works on my network, but can I do that 
from a Linux webserver?

~Brad

I don't know. I don't get to play with Linux very often, but if it doesn't the 
web server maybe able to call the NET SEND from another machine if the 
appropriate paths and permissions are allowed.  I have never played with this 
either.




--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA

-
| 1 |   |
-  Binary Soduko
|   |   |
-
 
"C code. C code run. Run code run. Please!"
- Cynthia Dunning

Confidentiality Notice:  This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message. 




~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264803
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: harvesting email addresses

Indeed it does but it's not going away anytime soon. All we can do is do the
best we can to accomplish what we need to with as little impact on the
performance of our applications and as little annoyance to our users as
possible... or become spammers. lol

-Original Message-
From: Christopher Jordan [mailto:[EMAIL PROTECTED] 
Sent: Thursday, December 21, 2006 1:49 PM
To: CF-Talk
Subject: Re: harvesting email addresses

Sucks that we have to go to these sorts of lengths to do this kind of 
thing, doesn't it?
:o(
Chris

Chris Ditty wrote:
> The only way your email address will be semi-safe would be to hardcode
> it in the actual cfmail tag.  That or set a variable.
>
> What I did for on gig was to do a dropdown box showing the names and
> giving each a value.  When someone submitted the form, I let a simple
> cfif handle the rest.  The user never knew the actual email address
> that their request was sent to.
>
> On 12/21/06, Ray Champagne <[EMAIL PROTECTED]> wrote:
>   
>> Depends on what you're doing, but if the email address is visible in the
>> source of the processed cfm page, then yes, it can be harvested.
>>
>> 
-- 
http://www.cjordan.info

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264802
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: redirect to home after login

2006-12-21 Thread Richard White

hi christopher, thanks for your reply. 

thanks you have got the point and made me understand it much better :)

thanks again chris

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264801
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

SOT: What's the best way to handle this?

2006-12-21 Thread Rick Faircloth

Hi, all.

I'm building my multi-domain CMS system where
I have a custom website on the front, a multi-user
CMS in the middle, and an individual database on the backend.

My question is:  What's the best way to get the user
to the CMS?  CNAME?  Masked Forwarding?

Let's say the user has the domain bodafordhomes.com.

Could I set up a CNAME Alias called SiteManager.BodafordHomes.com
that would go to my CMS, called "RESM.WhiteStoneMedia.com"?

Can CNAME's be used that way?  Or would I have to use masked forwarding
to go to a completely different domain, in this case, from
bodadfordhomes.com
to whitestonemedia.com?

Ideally, I would be able to setup a CNAME for each domain that would use
the CMS and simply route the CNAME to my CMS for whatever domain is
using it.  I would have a query on RESM.WhiteStoneMedia.com that would
check the CGI.Server_Name and assign appropriate variables based on the
domain name used.

Thoughts?  Suggestions?

Rick



~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264800
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: No, I'll call you...

2006-12-21 Thread Rick Root

Brad,

We've got an application where the user requests the report, and the actual
report generation is handled by an asynchronous event gateway.  When the
gateway is done generating the report, it then generates an email to the
user notifying them that their report is ready.  Our users will have a
"Report Inbox" page on the web that will be flex powered, and if they keep
that screen up, the report just automatically appears there, but they're
free to do other stuff while they're waiting.

Rick


~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264799
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: OT: harvesting email addresses

2006-12-21 Thread Claude Schneegans

 >>an email addresses be harvested off .cfm and .php pages,

Sure they can, when they receive the page, it is not CF or php code 
anymore, it is plain vanilla HTML.
If there is an address in it, they'll find it.

 >>My client says they are receiving a lot of spam

Tell them to send their sexy jokes in BCC ;-)

 >> but i'm not sure that encoding the email address on the .cfm or .php 
will solve anything or if spam is just part of the internet now.

Well, yes and no. If you encode addresses on your clients sites, they 
will still receive spam, but they will not be able to blame you.
So, as far you're concern, it IS a solution.

-- 
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.


~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264798
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: upload excel to update database

2006-12-21 Thread Claude Schneegans

 >>Actually if I make a system dsn in windows linking to the Excel file 
then hook this into CF administrator.  What is the table name of the 
worksheet?

I may be wrong, but I think that the datasource points to a directory in 
which every .xls file is considered as a table. Then the query goes like 
this:

 SELECT FROM myExcelFile.xls
..

Personally, I'm using files in CSV format, but it should work the same 
way for Excel files.

 >>Also my MS Access idea linking to the excel it appears that if you 
update the excel file and query the datasource again the updated data in 
the excel file does not appear.  I wonder if it is being cached and how 
to purge it.

Make sure you uncheck the Maintain connections across client requests in 
the Datasources options.

-- 
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.


~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264797
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: upload excel to update database

2006-12-21 Thread Claude Schneegans

 >>In MS Access do an external link to an Excel file.

This could work also, but the problem is that the link is an absolute 
path to the file on your disk.
At least, I've never found a way to make it relative to the main 
database, then it will not work when you transfer the database on your 
server.

-- 
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.


~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264796
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: redirect to home after login

Richard,

I'm sorry, but I'm afraid I only just now read your original post. You 
don't (and can't) have that kind of control over a user's browser. Just 
imagine, if someone could programmatically keep you from browsing to 
another site via the address bar! Wow, would the world be in trouble.

I've never used the dreamweaver extensions (or dreamweaver for that 
matter), but writing a login page is pretty simple. I gave you some of 
the very basic components in my last post. If I'm missing your point, 
try me again. I can probably help you out.

Cheers,
Chris

Richard White wrote:
> hi, am just wondering if anyone can help me, i haven't had any luck with this 
> all day and i have to give a presentation tomorrow :(
>
> Also, i need to set up some session variables as soon as the user is logged 
> on, but because i cant work out how to direct the page  when they are logged 
> on, i cant find the place where i need to setup the session variables.
>
> I enter the session variables in the piece of code where i say 'if password = 
> dbpassword' then authentication = "YES". i add the session variables here but 
> they dont appear to be read. very strange
>
> would appreciate any help thanks
>
> 

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264795
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: redirect to home after login

Richard,

In order to have access to session variables, you need to have a line 
like this in your Application.cfm file:

Then you'll access session variables like this:

SELECT *
FROM UsersTable
WHERE 1=1
AND UserName = '#Form.UserName#'
AND Password = '#Form.Password#'

In order to redirect a user you'll use the  tag. Like this:

Does this help? I'm sorry if I got too basic. I mean no offense. Holler 
if you're still having trouble. :o)

Cheers,
Chris

Richard White wrote:
> hi, am just wondering if anyone can help me, i haven't had any luck with this 
> all day and i have to give a presentation tomorrow :(
>
> Also, i need to set up some session variables as soon as the user is logged 
> on, but because i cant work out how to direct the page  when they are logged 
> on, i cant find the place where i need to setup the session variables.
>
> I enter the session variables in the piece of code where i say 'if password = 
> dbpassword' then authentication = "YES". i add the session variables here but 
> they dont appear to be read. very strange
>
> would appreciate any help thanks
>
> 

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264794
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: automatically generate password

Never thought about that :-)

-Original Message-
From: Christopher Jordan [mailto:[EMAIL PROTECTED] 
Sent: Thursday, December 21, 2006 1:32 PM
To: CF-Talk
Subject: Re: automatically generate password

LOL! :o) I think we're actually using that UDF!

One drawback to the coldfusion.runtime.SessionTracker method (if memory 
serves) is that accessing it resets the timer on the session. We use it 
so that if someone logs into a privilaged account, they can see everyone 
who's logged in and how long their session has been active. But since 
this resets the timer on their sessions, the sessions never time out. 
:o( So we had to write some custom code that handled the problem. I 
forget off-hand what we did specifically.

Still, pretty cool stuff. :o)

Bobby Hartsfield wrote:
> Man I hate control + enter...
>
>  as I was saying, yes it is a great site... especially this page
> http://cflib.org/udf.cfm?id=1135 heh
>
> I should really submit some stuff to Ray but I'm too lazy lol
>
> -Original Message-
> From: Christopher Jordan [mailto:[EMAIL PROTECTED] 
> Sent: Thursday, December 21, 2006 1:02 PM
> To: CF-Talk
> Subject: Re: automatically generate password
>
> Sweet! If you think it's better than what CFLib.org has, then submit it 
> there as well. I've got a few UDFs there. it's a great site. :o)
>
> Chris
>   
-- 

http://www.cjordan.info

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264793
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: openid cfc

2006-12-21 Thread Brian Rinaldi

> has anyone created an openid cfc that they would like to share?  I 
> would rater not recreate the wheel if it is already in existence.
> 
> Thanks, 
> Doug 
R

Thanks for posting about this Doug...I saw it mentioned on Techmeme (Which 
picked it up from O'Reilly Radar) today. It looks interesting (and I signed 
up). This doesn't look too difficult to do (and I might be willing to do it), 
but it appears the tricky part would be to handle caching the results since it 
could require a handful of cfhttp requests. Perhaps over my holiday break I 
will take this on :)

- Brian Rinaldi
http://www.remotesynthesis.com/blog

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264792
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: redirect to home after login

2006-12-21 Thread Richard White

hi, am just wondering if anyone can help me, i haven't had any luck with this 
all day and i have to give a presentation tomorrow :(

Also, i need to set up some session variables as soon as the user is logged on, 
but because i cant work out how to direct the page  when they are logged on, i 
cant find the place where i need to setup the session variables.

I enter the session variables in the piece of code where i say 'if password = 
dbpassword' then authentication = "YES". i add the session variables here but 
they dont appear to be read. very strange

would appreciate any help thanks

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264791
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: No, I'll call you...

2006-12-21 Thread Brad Wood

Hmm, I hadn't thought of that.  Net set works on my network, but can I
do that from a Linux webserver?

~Brad

-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED] 
Sent: Thursday, December 21, 2006 11:55 AM
To: CF-Talk
Subject: RE: No, I'll call you...

If your network will support it, I've done some messaging of this type
with NET SEND called with  tags.

HTH

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264790
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: harvesting email addresses

Sucks that we have to go to these sorts of lengths to do this kind of 
thing, doesn't it?
:o(
Chris

Chris Ditty wrote:
> The only way your email address will be semi-safe would be to hardcode
> it in the actual cfmail tag.  That or set a variable.
>
> What I did for on gig was to do a dropdown box showing the names and
> giving each a value.  When someone submitted the form, I let a simple
> cfif handle the rest.  The user never knew the actual email address
> that their request was sent to.
>
> On 12/21/06, Ray Champagne <[EMAIL PROTECTED]> wrote:
>   
>> Depends on what you're doing, but if the email address is visible in the
>> source of the processed cfm page, then yes, it can be harvested.
>>
>> 
-- 
http://www.cjordan.info



~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264789
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: OT: harvesting email addresses

On 12/21/06, Jason Rogoz <[EMAIL PROTECTED]> wrote:
>
> Hi all
>
> I just wanted to follow up with my previous post regarding hiding email
> addresses on form.  Can email addresses be harvested off .cfm and .php
> pages, or are the addresses invisible to the bots on server side scripts. My
> client says they are receiving a lot of spam but i'm not sure that encoding
> the email address on the .cfm or .php will solve anything or if spam is just
> part of the internet now.

Really, this has nothing to do with PHP or CF.  If an email address is in a
readible format then they can be harvested.  What you need is to either use
hex or some javascript.  Here is a pretty good page for reference:

http://www.csarven.ca/hiding-email-addresses

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264788
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: harvesting email addresses

2006-12-21 Thread Chris Ditty

The only way your email address will be semi-safe would be to hardcode
it in the actual cfmail tag.  That or set a variable.

What I did for on gig was to do a dropdown box showing the names and
giving each a value.  When someone submitted the form, I let a simple
cfif handle the rest.  The user never knew the actual email address
that their request was sent to.

On 12/21/06, Ray Champagne <[EMAIL PROTECTED]> wrote:
> Depends on what you're doing, but if the email address is visible in the
> source of the processed cfm page, then yes, it can be harvested.
>
> > -Original Message-
> > From: Jason Rogoz [mailto:[EMAIL PROTECTED]
> > Sent: Thursday, December 21, 2006 1:29 PM
> > To: CF-Talk
> > Subject: OT: harvesting email addresses
> >
> > Hi all
> >
> > I just wanted to follow up with my previous post regarding hiding email
> addresses
> > on form.  Can email addresses be harvested off .cfm and .php pages, or are
> the
> > addresses invisible to the bots on server side scripts. My client says
> they are
> > receiving a lot of spam but i'm not sure that encoding the email address
> on
> > the .cfm or .php will solve anything or if spam is just part of the
> internet now.
> >
> > Thanks
> >
> >
>
> 

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264787
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: upload excel to update database

Try HXTT.com's type 4 JDBC Excel driver. I've not used it, but I am 
using their Type 4 JDBC DBF driver (to access FoxPro). They also have an 
Access driver.

The advantage of these drivers is the Type 4 JDBC part. They eliminate 
the need to use the crappy not-ready-for-primetime-nor-will-it-ever-be 
JDBC-ODBC Bridge (or Type 1 JDBC Driver).

Give it a shot. See what happens. I'm very happy with the DBF driver. It 
give me control over FoxPro free tables (.DBF) that FoxPro didn't even 
provide natively.

Cheers,
Chris

Chad Gray wrote:
> The problem I see with doing the windows DSN is the excel sheet gets locked.
>
> Even if a user were to upload a new one I doubt that CFFile will be able to 
> over write it.
>
> I started testing more with the MS Access linking to the excel sheet and I 
> like it better so far.  The excel file is not locked and I was wrong in a 
> previous post.  If I update the excel sheet and re-query with CF on the 
> Access database then the new data does get displayed.
>
> As long as the excel file does not lock I think I will continue to experiment 
> with the MS Access linking to the excel file.
>
> Thanks for the help!
>
>
>
>   
>> -Original Message-
>> From: Christopher Jordan [mailto:[EMAIL PROTECTED]
>> Sent: Thursday, December 21, 2006 1:22 PM
>> To: CF-Talk
>> Subject: Re: upload excel to update database
>>
>> I think it's supposed to be the name of the worksheet... which it looks
>> like you're doing... but what's the '$'? Try renaming the sheet
>> something like "test" and trying that.
>>
>> Also, I think you may find that you'll have to set up a new DSN for each
>> excell file (if they have different workbook names, maybe?)... I
>> remember running across this once. Another user in the conversation on
>> this subject a few days ago said that he was able to set up a generic
>> excel DSN.
>>
>> I'll see if I can dig up that post for you.
>>
>> Chris
>>
>> Chad Gray wrote:
>> 
>>> That did not work.. maybe I have it setup wrong.
>>>
>>> [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Excel
>>>   
>> Driver] Syntax error in FROM clause.
>> 
>>> 
>>> SELECT *
>>> FROM Sheet1$
>>> 
>>>
>>>
>>>
>>>
>>>   
 -Original Message-
 From: Peterson, Chris [mailto:[EMAIL PROTECTED]
 Sent: Thursday, December 21, 2006 12:44 PM
 To: CF-Talk
 Subject: RE: upload excel to update database

 Use Sheet1$

 -Original Message-
 From: Chad Gray [mailto:[EMAIL PROTECTED]
 Sent: Thursday, December 21, 2006 12:44 PM
 To: CF-Talk
 Subject: RE: upload excel to update database

 Actually if I make a system dsn in windows linking to the Excel file
 then hook this into CF administrator.  What is the table name of the
 worksheet?

 I tried the following and no luck
 
 SELECT *
 FROM Sheet1
 

 Also my MS Access idea linking to the excel it appears that if you
 update the excel file and query the datasource again the updated data
 
>> in
>> 
 the excel file does not appear.  I wonder if it is being cached and how
 to purge it.




 
> -Original Message-
> From: Chad Gray [mailto:[EMAIL PROTECTED]
> Sent: Thursday, December 21, 2006 12:30 PM
> To: CF-Talk
> Subject: RE: upload excel to update database
>
> Oh I see what you are saying... make the DSN in windows... then
>
>   
 hook

 
> into that with the Administrator...  This works for me and is better
>
>   
 then

 
> what I tried below.
>
> In MS Access do an external link to an Excel file.  Now the excel
>
>   
 sheet is

 
> in Access as a table that I can query with CF.  I haven not tried
>
>   
 changing

 
> or updating the excel file to see what happens to the data returned in
>
>   
 CF,

 
> but it might work.
>
>
>
>
>
>   
>> -Original Message-
>> From: Claude Schneegans [mailto:[EMAIL PROTECTED]
>> Sent: Thursday, December 21, 2006 12:15 PM
>> To: CF-Talk
>> Subject: Re: upload excel to update database
>>
>>  >>In the server administrator?  I don't see a datatype of excel?
>>
>> Aaaah this is the "pleasure" of working with JDBC! :-(
>> I suppose you're under CFMX, under CF 5 all ODBC drivers were
>>
>> 
 available,

 
>> including Excel.
>>
>> With CFMX, you need to first create an ODBC datasource on your Excel
>> file from Windows.
>> THEN you can create the JDBC datasource on that ODBC DSN in the CF
>> Administrator using the ODBC socket.
>>
>> I think MM should have kept the ODBC connection creation tool in the
>> administrator and con

RE: harvesting email addresses

If you can't see it in the generated html, then neither can a bot. (view
source)

-Original Message-
From: Jason Rogoz [mailto:[EMAIL PROTECTED] 
Sent: Thursday, December 21, 2006 1:29 PM
To: CF-Talk
Subject: OT: harvesting email addresses

Hi all

I just wanted to follow up with my previous post regarding hiding email
addresses on form.  Can email addresses be harvested off .cfm and .php
pages, or are the addresses invisible to the bots on server side scripts. My
client says they are receiving a lot of spam but i'm not sure that encoding
the email address on the .cfm or .php will solve anything or if spam is just
part of the internet now.

Thanks

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264785
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: harvesting email addresses

2006-12-21 Thread Ray Champagne

Depends on what you're doing, but if the email address is visible in the
source of the processed cfm page, then yes, it can be harvested.  

> -Original Message-
> From: Jason Rogoz [mailto:[EMAIL PROTECTED]
> Sent: Thursday, December 21, 2006 1:29 PM
> To: CF-Talk
> Subject: OT: harvesting email addresses
> 
> Hi all
> 
> I just wanted to follow up with my previous post regarding hiding email
addresses
> on form.  Can email addresses be harvested off .cfm and .php pages, or are
the
> addresses invisible to the bots on server side scripts. My client says
they are
> receiving a lot of spam but i'm not sure that encoding the email address
on
> the .cfm or .php will solve anything or if spam is just part of the
internet now.
> 
> Thanks
> 
> 

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264784
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: automatically generate password

LOL! :o) I think we're actually using that UDF!

One drawback to the coldfusion.runtime.SessionTracker method (if memory 
serves) is that accessing it resets the timer on the session. We use it 
so that if someone logs into a privilaged account, they can see everyone 
who's logged in and how long their session has been active. But since 
this resets the timer on their sessions, the sessions never time out. 
:o( So we had to write some custom code that handled the problem. I 
forget off-hand what we did specifically.

Still, pretty cool stuff. :o)

Bobby Hartsfield wrote:
> Man I hate control + enter...
>
>  as I was saying, yes it is a great site... especially this page
> http://cflib.org/udf.cfm?id=1135 heh
>
> I should really submit some stuff to Ray but I'm too lazy lol
>
> -Original Message-
> From: Christopher Jordan [mailto:[EMAIL PROTECTED] 
> Sent: Thursday, December 21, 2006 1:02 PM
> To: CF-Talk
> Subject: Re: automatically generate password
>
> Sweet! If you think it's better than what CFLib.org has, then submit it 
> there as well. I've got a few UDFs there. it's a great site. :o)
>
> Chris
>   
-- 

http://www.cjordan.info

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264783
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

OT: harvesting email addresses

2006-12-21 Thread Jason Rogoz

Hi all

I just wanted to follow up with my previous post regarding hiding email 
addresses on form.  Can email addresses be harvested off .cfm and .php pages, 
or are the addresses invisible to the bots on server side scripts. My client 
says they are receiving a lot of spam but i'm not sure that encoding the email 
address on the .cfm or .php will solve anything or if spam is just part of the 
internet now.

Thanks

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264782
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: upload excel to update database

2006-12-21 Thread Chad Gray

The problem I see with doing the windows DSN is the excel sheet gets locked.

Even if a user were to upload a new one I doubt that CFFile will be able to 
over write it.

I started testing more with the MS Access linking to the excel sheet and I like 
it better so far.  The excel file is not locked and I was wrong in a previous 
post.  If I update the excel sheet and re-query with CF on the Access database 
then the new data does get displayed.

As long as the excel file does not lock I think I will continue to experiment 
with the MS Access linking to the excel file.

Thanks for the help!



> -Original Message-
> From: Christopher Jordan [mailto:[EMAIL PROTECTED]
> Sent: Thursday, December 21, 2006 1:22 PM
> To: CF-Talk
> Subject: Re: upload excel to update database
> 
> I think it's supposed to be the name of the worksheet... which it looks
> like you're doing... but what's the '$'? Try renaming the sheet
> something like "test" and trying that.
> 
> Also, I think you may find that you'll have to set up a new DSN for each
> excell file (if they have different workbook names, maybe?)... I
> remember running across this once. Another user in the conversation on
> this subject a few days ago said that he was able to set up a generic
> excel DSN.
> 
> I'll see if I can dig up that post for you.
> 
> Chris
> 
> Chad Gray wrote:
> > That did not work.. maybe I have it setup wrong.
> >
> > [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Excel
> Driver] Syntax error in FROM clause.
> >
> > 
> > SELECT *
> > FROM Sheet1$
> > 
> >
> >
> >
> >
> >> -Original Message-
> >> From: Peterson, Chris [mailto:[EMAIL PROTECTED]
> >> Sent: Thursday, December 21, 2006 12:44 PM
> >> To: CF-Talk
> >> Subject: RE: upload excel to update database
> >>
> >> Use Sheet1$
> >>
> >> -Original Message-
> >> From: Chad Gray [mailto:[EMAIL PROTECTED]
> >> Sent: Thursday, December 21, 2006 12:44 PM
> >> To: CF-Talk
> >> Subject: RE: upload excel to update database
> >>
> >> Actually if I make a system dsn in windows linking to the Excel file
> >> then hook this into CF administrator.  What is the table name of the
> >> worksheet?
> >>
> >> I tried the following and no luck
> >> 
> >> SELECT *
> >> FROM Sheet1
> >> 
> >>
> >> Also my MS Access idea linking to the excel it appears that if you
> >> update the excel file and query the datasource again the updated data
> in
> >> the excel file does not appear.  I wonder if it is being cached and how
> >> to purge it.
> >>
> >>
> >>
> >>
> >>> -Original Message-
> >>> From: Chad Gray [mailto:[EMAIL PROTECTED]
> >>> Sent: Thursday, December 21, 2006 12:30 PM
> >>> To: CF-Talk
> >>> Subject: RE: upload excel to update database
> >>>
> >>> Oh I see what you are saying... make the DSN in windows... then
> >>>
> >> hook
> >>
> >>> into that with the Administrator...  This works for me and is better
> >>>
> >> then
> >>
> >>> what I tried below.
> >>>
> >>> In MS Access do an external link to an Excel file.  Now the excel
> >>>
> >> sheet is
> >>
> >>> in Access as a table that I can query with CF.  I haven not tried
> >>>
> >> changing
> >>
> >>> or updating the excel file to see what happens to the data returned in
> >>>
> >> CF,
> >>
> >>> but it might work.
> >>>
> >>>
> >>>
> >>>
> >>>
>  -Original Message-
>  From: Claude Schneegans [mailto:[EMAIL PROTECTED]
>  Sent: Thursday, December 21, 2006 12:15 PM
>  To: CF-Talk
>  Subject: Re: upload excel to update database
> 
>   >>In the server administrator?  I don't see a datatype of excel?
> 
>  Aaaah this is the "pleasure" of working with JDBC! :-(
>  I suppose you're under CFMX, under CF 5 all ODBC drivers were
> 
> >> available,
> >>
>  including Excel.
> 
>  With CFMX, you need to first create an ODBC datasource on your Excel
>  file from Windows.
>  THEN you can create the JDBC datasource on that ODBC DSN in the CF
>  Administrator using the ODBC socket.
> 
>  I think MM should have kept the ODBC connection creation tool in the
>  administrator and connect the datasource automatically through the
> 
> >> ODBC
> >>
>  socket.
> 
>  Now, if you're uner Unix or Mac, that's even another story.
> 
>  --
>  ___
>  REUSE CODE! Use custom tags;
>  See http://www.contentbox.com/claude/customtags/tagstore.cfm
>  (Please send any spam to this address: [EMAIL PROTECTED])
>  Thanks.
> 
> 
> 
> 
> >>>
> >>
> >>
> >>
> >
> >
> 
> 

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264781
Subscription: http://www.houseoffusion.com/group

Re: upload excel to update database

I think it's supposed to be the name of the worksheet... which it looks 
like you're doing... but what's the '$'? Try renaming the sheet 
something like "test" and trying that.

Also, I think you may find that you'll have to set up a new DSN for each 
excell file (if they have different workbook names, maybe?)... I 
remember running across this once. Another user in the conversation on 
this subject a few days ago said that he was able to set up a generic 
excel DSN.

I'll see if I can dig up that post for you.

Chris

Chad Gray wrote:
> That did not work.. maybe I have it setup wrong. 
>
> [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Excel 
> Driver] Syntax error in FROM clause.
>
> 
> SELECT *
> FROM Sheet1$
> 
>
>
>
>   
>> -Original Message-
>> From: Peterson, Chris [mailto:[EMAIL PROTECTED]
>> Sent: Thursday, December 21, 2006 12:44 PM
>> To: CF-Talk
>> Subject: RE: upload excel to update database
>>
>> Use Sheet1$
>>
>> -Original Message-
>> From: Chad Gray [mailto:[EMAIL PROTECTED]
>> Sent: Thursday, December 21, 2006 12:44 PM
>> To: CF-Talk
>> Subject: RE: upload excel to update database
>>
>> Actually if I make a system dsn in windows linking to the Excel file
>> then hook this into CF administrator.  What is the table name of the
>> worksheet?
>>
>> I tried the following and no luck
>> 
>> SELECT *
>> FROM Sheet1
>> 
>>
>> Also my MS Access idea linking to the excel it appears that if you
>> update the excel file and query the datasource again the updated data in
>> the excel file does not appear.  I wonder if it is being cached and how
>> to purge it.
>>
>>
>>
>> 
>>> -Original Message-
>>> From: Chad Gray [mailto:[EMAIL PROTECTED]
>>> Sent: Thursday, December 21, 2006 12:30 PM
>>> To: CF-Talk
>>> Subject: RE: upload excel to update database
>>>
>>> Oh I see what you are saying... make the DSN in windows... then
>>>   
>> hook
>> 
>>> into that with the Administrator...  This works for me and is better
>>>   
>> then
>> 
>>> what I tried below.
>>>
>>> In MS Access do an external link to an Excel file.  Now the excel
>>>   
>> sheet is
>> 
>>> in Access as a table that I can query with CF.  I haven not tried
>>>   
>> changing
>> 
>>> or updating the excel file to see what happens to the data returned in
>>>   
>> CF,
>> 
>>> but it might work.
>>>
>>>
>>>
>>>
>>>   
 -Original Message-
 From: Claude Schneegans [mailto:[EMAIL PROTECTED]
 Sent: Thursday, December 21, 2006 12:15 PM
 To: CF-Talk
 Subject: Re: upload excel to update database

  >>In the server administrator?  I don't see a datatype of excel?

 Aaaah this is the "pleasure" of working with JDBC! :-(
 I suppose you're under CFMX, under CF 5 all ODBC drivers were
 
>> available,
>> 
 including Excel.

 With CFMX, you need to first create an ODBC datasource on your Excel
 file from Windows.
 THEN you can create the JDBC datasource on that ODBC DSN in the CF
 Administrator using the ODBC socket.

 I think MM should have kept the ODBC connection creation tool in the
 administrator and connect the datasource automatically through the
 
>> ODBC
>> 
 socket.

 Now, if you're uner Unix or Mac, that's even another story.

 --
 ___
 REUSE CODE! Use custom tags;
 See http://www.contentbox.com/claude/customtags/tagstore.cfm
 (Please send any spam to this address: [EMAIL PROTECTED])
 Thanks.



 
>>>   
>>
>>
>> 
>
> 

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264780
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: automatically generate password

Man I hate control + enter...

 as I was saying, yes it is a great site... especially this page
http://cflib.org/udf.cfm?id=1135 heh

I should really submit some stuff to Ray but I'm too lazy lol

-Original Message-
From: Christopher Jordan [mailto:[EMAIL PROTECTED] 
Sent: Thursday, December 21, 2006 1:02 PM
To: CF-Talk
Subject: Re: automatically generate password

Sweet! If you think it's better than what CFLib.org has, then submit it 
there as well. I've got a few UDFs there. it's a great site. :o)

Chris

Bobby Hartsfield wrote:
> Agreed. I actually rewrote this one somewhere to speed it up using
cfscript
> and randrange(n, n) for ascii values instead of using lists of characters.
>
> I'll dig it up eventually and post an update to the other one... I wrote
> that one in 2002 :-)
>
> -Original Message-
> From: Christopher Jordan [mailto:[EMAIL PROTECTED] 
> Sent: Thursday, December 21, 2006 12:18 PM
> To: CF-Talk
> Subject: Re: automatically generate password
>
> I know. I'm just stating for the masses why they maybe would want to 
> consider making it a habit to code stuff in cfscript wherever they can 
> whether the time difference between it and similar tag based code is 
> measurable. :o)
>
> Chris
>
> Bobby Hartsfield wrote:
>   
>> I didn't disagree. I just said it wasn't enough processing to matter.
>>
>> -Original Message-
>> From: Christopher Jordan [mailto:[EMAIL PROTECTED] 
>> Sent: Thursday, December 21, 2006 9:51 AM
>> To: CF-Talk
>> Subject: Re: automatically generate password
>>
>> Hmm... well, cfscript code is still closer to the native java than tag 
>> based code. To quote a guy from my local CFUG.
>>
>> "That is exactly what I've been saying / seeing for many years (pre & 
>> post CFMX). The reason that tags are slower is because when the template 
>> JITs, it adds extra libraries into the class. So in other words, when 
>> you write your code in cfscript, your code needs fewer cftag libraries 
>> mentioned as Java import namespaces because your code is closer to the 
>> native Java and requires less overhead. Also, the tag named import also 
>> contains functionality you may not be using. Therefore, you have thinner 
>> JITs and faster code.
>>
>> Now, if we could just get adobe to start offering cfscript equivalents 
>> for the most used tags, we wouldn't have to have functions that replace 
>> our tags inside cfscript. We can only hope!"
>>
>> To see this comment in context, check out this blog entry 
>>
>> 
>
   
>> ned--script-VS-tag>.
>>
>> I've also seen the speed increases. Here's an email that I recently 
>> posted to my CFUG mailing list. The numbers at the bottom of the email 
>> amazed me.
>>
>> <-- BEGIN -->
>> Not to beat a dead horse, but I just wanted to share some numbers. Just 
>> this morning I changed the part of the code in one of my CFCs from this:
>>
>> 
>> 
>> 
>> 
>>   
>> 
>> 
>> > Default="#ThisStafpakClientID#">
>> > Default="#ThisStafpakPath#">
>>   
>> 
>> 
>> 
>> 
>>
>> to this:
>>
>> 
>> var My = StructNew();
>> My.OrderID= "";
>> My.FieldList= "*";
>> My.StafpakID= ThisStafpakClientID;
>> My.Path= ThisStafpakPath;
>> My.ArgumentList = StructKeyList(Arguments);
>>   
>> // loop over the Arguments Structure and put all key values 
>> into the local
>> // 'My' scope...
>> for (My.i = 1; My.i LTE StructCount(Arguments); My.i = My.i 
>> + 1){
>> My.KeyName = ListGetAt(My.ArgumentList, My.i);
>> "My.#My.KeyName#" = Arguments[My.KeyName];
>> }
>> 
>>
>> and then looked at the numbers in the debugging. I was amazed!
>>
>> The old way:
>> 5170 ms 5170 ms 1 CFC[ C:\Inetpub\wwwroot\Include\CFC\StafPak.cfc | 
>> FetchThisOrder(...
>>
>> The new way:
>> 140 ms 140 ms 1 CFC[ C:\Inetpub\wwwroot\Include\CFC\StafPak.cfc | 
>> FetchThisOrder(...
>>
>> Holy milliseconds, Batman!
>>
>> Just because I know the numbers fluctuate I ran both again.
>>
>> The old way (take 2):
>> 1124 ms 1124 ms 1 CFC[ C:\Inetpub\wwwroot\Include\CFC\StafPak.cfc | 
>> FetchThisOrder(...
>>
>> The new way (take 2):
>> 78 ms 78 ms 1 CFC[ C:\Inetpub\wwwroot\Include\CFC\StafPak.cfc | 
>> FetchThisOrder(...
>>
>> Jinkies!! That was smokin'!
>>
>> I'm definitely changing the way I do some things around here... ;o)
>> <-- END -->
>>
>> Anyway, the speed increase gained in changing your code in this instance 
>> may be immeasurable, but in general cfscript code is faster than tagged 
>> code. I find this topic fascinating. I hope you don't think I've wasted 
>> anyone's time. :o)
>>
>> Cheers,
>> Chris
>>
>> Bobby Hartsfield wrote:
>>   
>> 
>>> I converted this to

RE: automatically generate password

Yes it is a great site ;-)

Especially this page.

-Original Message-
From: Christopher Jordan [mailto:[EMAIL PROTECTED] 
Sent: Thursday, December 21, 2006 1:02 PM
To: CF-Talk
Subject: Re: automatically generate password

Sweet! If you think it's better than what CFLib.org has, then submit it 
there as well. I've got a few UDFs there. it's a great site. :o)

Chris

Bobby Hartsfield wrote:
> Agreed. I actually rewrote this one somewhere to speed it up using
cfscript
> and randrange(n, n) for ascii values instead of using lists of characters.
>
> I'll dig it up eventually and post an update to the other one... I wrote
> that one in 2002 :-)
>
> -Original Message-
> From: Christopher Jordan [mailto:[EMAIL PROTECTED] 
> Sent: Thursday, December 21, 2006 12:18 PM
> To: CF-Talk
> Subject: Re: automatically generate password
>
> I know. I'm just stating for the masses why they maybe would want to 
> consider making it a habit to code stuff in cfscript wherever they can 
> whether the time difference between it and similar tag based code is 
> measurable. :o)
>
> Chris
>
> Bobby Hartsfield wrote:
>   
>> I didn't disagree. I just said it wasn't enough processing to matter.
>>
>> -Original Message-
>> From: Christopher Jordan [mailto:[EMAIL PROTECTED] 
>> Sent: Thursday, December 21, 2006 9:51 AM
>> To: CF-Talk
>> Subject: Re: automatically generate password
>>
>> Hmm... well, cfscript code is still closer to the native java than tag 
>> based code. To quote a guy from my local CFUG.
>>
>> "That is exactly what I've been saying / seeing for many years (pre & 
>> post CFMX). The reason that tags are slower is because when the template 
>> JITs, it adds extra libraries into the class. So in other words, when 
>> you write your code in cfscript, your code needs fewer cftag libraries 
>> mentioned as Java import namespaces because your code is closer to the 
>> native Java and requires less overhead. Also, the tag named import also 
>> contains functionality you may not be using. Therefore, you have thinner 
>> JITs and faster code.
>>
>> Now, if we could just get adobe to start offering cfscript equivalents 
>> for the most used tags, we wouldn't have to have functions that replace 
>> our tags inside cfscript. We can only hope!"
>>
>> To see this comment in context, check out this blog entry 
>>
>> 
>
   
>> ned--script-VS-tag>.
>>
>> I've also seen the speed increases. Here's an email that I recently 
>> posted to my CFUG mailing list. The numbers at the bottom of the email 
>> amazed me.
>>
>> <-- BEGIN -->
>> Not to beat a dead horse, but I just wanted to share some numbers. Just 
>> this morning I changed the part of the code in one of my CFCs from this:
>>
>> 
>> 
>> 
>> 
>>   
>> 
>> 
>> > Default="#ThisStafpakClientID#">
>> > Default="#ThisStafpakPath#">
>>   
>> 
>> 
>> 
>> 
>>
>> to this:
>>
>> 
>> var My = StructNew();
>> My.OrderID= "";
>> My.FieldList= "*";
>> My.StafpakID= ThisStafpakClientID;
>> My.Path= ThisStafpakPath;
>> My.ArgumentList = StructKeyList(Arguments);
>>   
>> // loop over the Arguments Structure and put all key values 
>> into the local
>> // 'My' scope...
>> for (My.i = 1; My.i LTE StructCount(Arguments); My.i = My.i 
>> + 1){
>> My.KeyName = ListGetAt(My.ArgumentList, My.i);
>> "My.#My.KeyName#" = Arguments[My.KeyName];
>> }
>> 
>>
>> and then looked at the numbers in the debugging. I was amazed!
>>
>> The old way:
>> 5170 ms 5170 ms 1 CFC[ C:\Inetpub\wwwroot\Include\CFC\StafPak.cfc | 
>> FetchThisOrder(...
>>
>> The new way:
>> 140 ms 140 ms 1 CFC[ C:\Inetpub\wwwroot\Include\CFC\StafPak.cfc | 
>> FetchThisOrder(...
>>
>> Holy milliseconds, Batman!
>>
>> Just because I know the numbers fluctuate I ran both again.
>>
>> The old way (take 2):
>> 1124 ms 1124 ms 1 CFC[ C:\Inetpub\wwwroot\Include\CFC\StafPak.cfc | 
>> FetchThisOrder(...
>>
>> The new way (take 2):
>> 78 ms 78 ms 1 CFC[ C:\Inetpub\wwwroot\Include\CFC\StafPak.cfc | 
>> FetchThisOrder(...
>>
>> Jinkies!! That was smokin'!
>>
>> I'm definitely changing the way I do some things around here... ;o)
>> <-- END -->
>>
>> Anyway, the speed increase gained in changing your code in this instance 
>> may be immeasurable, but in general cfscript code is faster than tagged 
>> code. I find this topic fascinating. I hope you don't think I've wasted 
>> anyone's time. :o)
>>
>> Cheers,
>> Chris
>>
>> Bobby Hartsfield wrote:
>>   
>> 
>>> I converted this to a udf but it's not any faster. Not really enough
>>> processing to make a difference really.
>>>
>>> -Original Message-
>>> From: Christopher

RE: upload excel to update database

2006-12-21 Thread Chad Gray

That did not work.. maybe I have it setup wrong. 

[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Excel Driver] 
Syntax error in FROM clause.


SELECT *
FROM Sheet1$




> -Original Message-
> From: Peterson, Chris [mailto:[EMAIL PROTECTED]
> Sent: Thursday, December 21, 2006 12:44 PM
> To: CF-Talk
> Subject: RE: upload excel to update database
> 
> Use Sheet1$
> 
> -Original Message-
> From: Chad Gray [mailto:[EMAIL PROTECTED]
> Sent: Thursday, December 21, 2006 12:44 PM
> To: CF-Talk
> Subject: RE: upload excel to update database
> 
> Actually if I make a system dsn in windows linking to the Excel file
> then hook this into CF administrator.  What is the table name of the
> worksheet?
> 
> I tried the following and no luck
> 
> SELECT *
> FROM Sheet1
> 
> 
> Also my MS Access idea linking to the excel it appears that if you
> update the excel file and query the datasource again the updated data in
> the excel file does not appear.  I wonder if it is being cached and how
> to purge it.
> 
> 
> 
> > -Original Message-
> > From: Chad Gray [mailto:[EMAIL PROTECTED]
> > Sent: Thursday, December 21, 2006 12:30 PM
> > To: CF-Talk
> > Subject: RE: upload excel to update database
> >
> > Oh I see what you are saying... make the DSN in windows... then
> hook
> > into that with the Administrator...  This works for me and is better
> then
> > what I tried below.
> >
> > In MS Access do an external link to an Excel file.  Now the excel
> sheet is
> > in Access as a table that I can query with CF.  I haven not tried
> changing
> > or updating the excel file to see what happens to the data returned in
> CF,
> > but it might work.
> >
> >
> >
> >
> > > -Original Message-
> > > From: Claude Schneegans [mailto:[EMAIL PROTECTED]
> > > Sent: Thursday, December 21, 2006 12:15 PM
> > > To: CF-Talk
> > > Subject: Re: upload excel to update database
> > >
> > >  >>In the server administrator?  I don't see a datatype of excel?
> > >
> > > Aaaah this is the "pleasure" of working with JDBC! :-(
> > > I suppose you're under CFMX, under CF 5 all ODBC drivers were
> available,
> > > including Excel.
> > >
> > > With CFMX, you need to first create an ODBC datasource on your Excel
> > > file from Windows.
> > > THEN you can create the JDBC datasource on that ODBC DSN in the CF
> > > Administrator using the ODBC socket.
> > >
> > > I think MM should have kept the ODBC connection creation tool in the
> > > administrator and connect the datasource automatically through the
> ODBC
> > > socket.
> > >
> > > Now, if you're uner Unix or Mac, that's even another story.
> > >
> > > --
> > > ___
> > > REUSE CODE! Use custom tags;
> > > See http://www.contentbox.com/claude/customtags/tagstore.cfm
> > > (Please send any spam to this address: [EMAIL PROTECTED])
> > > Thanks.
> > >
> > >
> > >
> >
> >
> 
> 
> 
> 

~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:264777
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: automatically generate password