Re: Strip Email function

[Les Mizzell]

>>How about: isVALID(email,#form.email#)
> Shouldn't that be isValid("email",form.email) ?

Probably! It's late and my last cup of coffee has worn off!

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234981
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: cfquery and insert help needed

[James Holmes]

Sorry for abbreviating - "as should be done in every query in which
user input is used"

On 3/10/06, S. Isaac Dealey <[EMAIL PROTECTED]> wrote:
> It's not dangerous if it's a hard-coded value...
>
> Otherwise, yes, use 
>
> > Use cfqueryparm as should be done in every query.

--
CFAJAX docs and other useful articles:
http://jr-holmes.coldfusionjournal.com/

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234980
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: cfquery and insert help needed

[Aaron Rouse]

Nah, I was leaving it off to see if he was paying attention to my
description of the fix and not just copy n pasting my solution.


Ok, you are right, I missed that one.


On 3/9/06, S. Isaac Dealey <[EMAIL PROTECTED]> wrote:
>
> > You need to double up that single quote within your string
> > that you are
> > inserting.  Are you just doing this directly in the DB or
> > through CF?  If in
> > CF, using a cfqueryparam should take care of this for you.
> > If directly in
> > the DB then change it to:
>
> > insert into RADIA4.ZSERVICE_LIST(REMOVAL,ZSTOP000)
> > values ('U','WORDPOS(EDMGETV(ZMASTER,ZOS),'' WIN2K
> > WINXP')=0')
>
> You missed the 2nd single-quote after WINXP ... doh!
>
>
> s. isaac dealey 434.293.6201
> new epoch : isn't it time for a change?
>
> add features without fixtures with
> the onTap open source framework
>
> http://www.fusiontap.com
> http://coldfusion.sys-con.com/author/4806Dealey.htm
>
>
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234979
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Q about CFEclipse

[S . Isaac Dealey]

> Does cfeclipse have the built in FTP file browser like
> Homesite does?  I
> find that to be a useful feature

> Rick

There is an FTP plugin for eclipse iirc... I'm not using it yet...
eclipse/cfe still doesn't have features that I use every day... most
notably auto-synch (Dreamweaver - put files on save in the project).
Really, ideally eclipse or cfeclipse should have something that's a
bit more robust than what Dreamweaver has currently. It should a)
provide auto-synchronization for any file operation which occurs in
the file browser (move, rename, delete -- preferably paired with SVN
integration, so that I can svn-rename and have that change
automatically coppied to a remote folder (I don't test projects in my
svn working directory)) and b) should support multiple remote sites so
that if I make changes to /index.cfm in project x I can have it
automatically copy that file both to another mirrored local directory
and to an ftp site if I want. This would save me the considerable
hassle of trying to get rsync working on my windows machine. ... I
think somebody recommended a windows alternative to rsync although at
the moment I can't remember the name of it... damn... that was
probably important... oh well...




s. isaac dealey 434.293.6201
new epoch : isn't it time for a change?

add features without fixtures with
the onTap open source framework

http://www.fusiontap.com
http://coldfusion.sys-con.com/author/4806Dealey.htm


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234978
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: cfquery and insert help needed

[S . Isaac Dealey]

It's not dangerous if it's a hard-coded value...

Otherwise, yes, use 

> Use cfqueryparm as should be done in every query.

> On 3/10/06, Charles Heizer <[EMAIL PROTECTED]> wrote:
>> Hello,
>> I'm trying to insert a value in to a column in oracle and
>> I'm getting
>> a missing comma error.
>>
>> I know the problem has to do with value "'WORDPOS(EDMGETV
>> (ZMASTER,ZOS),' WIN2K WINXP')=0'" I just don't know what
>> to do to fix
>> it.


s. isaac dealey 434.293.6201
new epoch : isn't it time for a change?

add features without fixtures with
the onTap open source framework

http://www.fusiontap.com
http://coldfusion.sys-con.com/author/4806Dealey.htm


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234977
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Strip Email function

[S . Isaac Dealey]

>> Why would you strip those characters out rather than just
>> use an
>> isEmail() function and refuse to accept invalid input?


> How about: isVALID(email,#form.email#)

> Works good for me...

Shouldn't that be isValid("email",form.email) ?

s. isaac dealey 434.293.6201
new epoch : isn't it time for a change?

add features without fixtures with
the onTap open source framework

http://www.fusiontap.com
http://coldfusion.sys-con.com/author/4806Dealey.htm


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234975
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: cfquery and insert help needed

[S . Isaac Dealey]

> You need to double up that single quote within your string
> that you are
> inserting.  Are you just doing this directly in the DB or
> through CF?  If in
> CF, using a cfqueryparam should take care of this for you.
> If directly in
> the DB then change it to:

> insert into RADIA4.ZSERVICE_LIST(REMOVAL,ZSTOP000)
> values ('U','WORDPOS(EDMGETV(ZMASTER,ZOS),'' WIN2K
> WINXP')=0')

You missed the 2nd single-quote after WINXP ... doh!


s. isaac dealey 434.293.6201
new epoch : isn't it time for a change?

add features without fixtures with
the onTap open source framework

http://www.fusiontap.com
http://coldfusion.sys-con.com/author/4806Dealey.htm


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234976
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: cfquery and insert help needed

[S . Isaac Dealey]

> Hello,
> I'm trying to insert a value in to a column in oracle and
> I'm getting
> a missing comma error.

> I know the problem has to do with value "'WORDPOS(EDMGETV
> (ZMASTER,ZOS),' WIN2K WINXP')=0'" I just don't know what
> to do to fix
> it.

> Thanks,
> - charles

> Here is my sql code...
> insert into RADIA4.ZSERVICE_LIST(REMOVAL,ZSTOP000)
> values ('U','WORDPOS(EDMGETV(ZMASTER,ZOS),' WIN2K
> WINXP')=0')


You need to escape the single quotes in your 2nd value:

insert into RADIA4.ZSERVICE_LIST(REMOVAL,ZSTOP000)
values ('U','WORDPOS(EDMGETV(ZMASTER,ZOS),'' WIN2K WINXP'')=0')


s. isaac dealey 434.293.6201
new epoch : isn't it time for a change?

add features without fixtures with
the onTap open source framework

http://www.fusiontap.com
http://coldfusion.sys-con.com/author/4806Dealey.htm


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234974
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: OT: Styling form inputs

[Les Mizzell]

dave wrote:
> input:focus,textarea:focus { background-color: #CCFF99; border: 1px dashed 
> #E92D68; }


Ooo - that's nice. I've never thought abour trying that one.

I've been working on a bunch of government sites lately, so 
accessibility is important. Looks like a cool thing to assist the 
visually impared (which reminds me that my eyes are starting to suck 
some these days too...).

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234973
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: cfquery and insert help needed

[James Holmes]

Use cfqueryparm as should be done in every query.

On 3/10/06, Charles Heizer <[EMAIL PROTECTED]> wrote:
> Hello,
> I'm trying to insert a value in to a column in oracle and I'm getting
> a missing comma error.
>
> I know the problem has to do with value "'WORDPOS(EDMGETV
> (ZMASTER,ZOS),' WIN2K WINXP')=0'" I just don't know what to do to fix
> it.

--
CFAJAX docs and other useful articles:
http://jr-holmes.coldfusionjournal.com/

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234972
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: cfquery and insert help needed

[Aaron Rouse]

You need to double up that single quote within your string that you are
inserting.  Are you just doing this directly in the DB or through CF?  If in
CF, using a cfqueryparam should take care of this for you.  If directly in
the DB then change it to:

insert into RADIA4.ZSERVICE_LIST(REMOVAL,ZSTOP000)
values ('U','WORDPOS(EDMGETV(ZMASTER,ZOS),'' WIN2K WINXP')=0')

On 3/9/06, Charles Heizer <[EMAIL PROTECTED]> wrote:
>
> Hello,
> I'm trying to insert a value in to a column in oracle and I'm getting
> a missing comma error.
>
> I know the problem has to do with value "'WORDPOS(EDMGETV
> (ZMASTER,ZOS),' WIN2K WINXP')=0'" I just don't know what to do to fix
> it.
>
> Thanks,
> - charles
>
> Here is my sql code...
> insert into RADIA4.ZSERVICE_LIST(REMOVAL,ZSTOP000)
> values ('U','WORDPOS(EDMGETV(ZMASTER,ZOS),' WIN2K WINXP')=0')
>
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234971
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

cfquery and insert help needed

[Charles Heizer]

Hello,
I'm trying to insert a value in to a column in oracle and I'm getting  
a missing comma error.

I know the problem has to do with value "'WORDPOS(EDMGETV 
(ZMASTER,ZOS),' WIN2K WINXP')=0'" I just don't know what to do to fix  
it.

Thanks,
- charles

Here is my sql code...
insert into RADIA4.ZSERVICE_LIST(REMOVAL,ZSTOP000)
values ('U','WORDPOS(EDMGETV(ZMASTER,ZOS),' WIN2K WINXP')=0')

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234970
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Determine Visitors OS

[Eric Roberts]

I believe it is one of the cgi variables...I don't have my documentation in
front of me to look it up, but I do believe that is the case.

Eric 

-Original Message-
From: jonese [mailto:[EMAIL PROTECTED] 
Sent: Thursday, 09 March 2006 16:58
To: CF-Talk
Subject: Determine Visitors OS

Anyone have a function which will determine the OS of a visitor to a
website?

I've already searched the usual suspects and couldn't come up with anything.

jonese



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234969
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Source Code Versioning with ColdFusion

[Stephen Collins]

> I am researching source code versioning software for our team.
> We are 4 ColdFusion developers using Dreamweaver and SQL mainly for 
> our development and currently do not use any code versioning software.
> What would you recommend for us or what are you using and how is that
> going?

Allan

You've opened a can of worms here, my friend!

As a fan of Open Source, I'd have to recommend you use either CVS or 
Subversion.  Both are very good, with Subversion being the newer project.

The model used by both differs markedly to VSS (which will cost you money).  If 
you look on Google using "cvs vss subversion feature comparison", you can find 
a wealth of information on all the SCM options out there.  I use CVS at work 
and Subversion at home.

Try looking at:

- http://better-scm.berlios.de/comparison/comparison.html
- http://www.sesp.cse.clrc.ac.uk/Publications/cvs-svn/cvs-svn.pdf

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234968
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Strip Email function

[Les Mizzell]

> Why would you strip those characters out rather than just use an 
> isEmail() function and refuse to accept invalid input?


How about: isVALID(email,#form.email#)

Works good for me...

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234967
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Source Code Versioning with ColdFusion

[Eric Roberts]

I am assuming you are in a Windows system...MS's Visual Source Safe works
great and works pretty seamlessly with Dreamweaver.  If you are on a flavor
of Unix, there are a few more options already built in, but I do not know
how well they work with DW.

Eric 

-Original Message-
From: Jagos, Allan [mailto:[EMAIL PROTECTED] 
Sent: Thursday, 09 March 2006 10:39
To: CF-Talk
Subject: Source Code Versioning with ColdFusion

I am researching source code versioning software for our team.
We are 4 ColdFusion developers using Dreamweaver and SQL mainly for our
development and currently do not use any code versioning software.
What would you recommend for us or what are you using and how is that going?
Thanks for the feedback.
 

  Allan M. Jagos 
   Web Developer

   Robinson & Cole LLP
   280 Trumbull Street
   Hartford, CT  06103-3597
   Direct (860) 275-8335 | Fax (860) 275-8299  
   [EMAIL PROTECTED] | www.rc.com   
   Contact Card   


 Boston  New London  Hartford  Stamford  White Plains  New York Sarasota 
 

__
This transmittal may be a confidential attorney-client communication or may
otherwise be privileged or confidential. If it is not clear that you are the
intended recipient, you are hereby notified that you have received this
transmittal in error; any review, dissemination, distribution or copying of
this transmittal is strictly prohibited. If you suspect that you have
received this communication in error, please notify us immediately by
telephone at 1-860-275-8200, or e-mail at [EMAIL PROTECTED] and immediately 
delete
this message and all its attachments.
__
This email has been scanned by the MessageLabs Email Security System.



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234966
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Q about CFEclipse

[Rick Root]

Does cfeclipse have the built in FTP file browser like Homesite does?  I 
find that to be a useful feature

Rick

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234965
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: SQL-generated primary keys

[S . Isaac Dealey]

But use scope_identity() instead of @@identity, otherwise you'll have
the same race condition you have now.

> My mistake...
> 
>insert into mytable([columns])
> values([values])
> select @@identity as user_id
> 

> All in one query, not two like I posted.
> -Original Message-
> From: Jacob [mailto:[EMAIL PROTECTED]
> Sent: Thursday, March 09, 2006 2:13 PM
> To: CF-Talk
> Subject: RE: SQL-generated primary keys

> After the command for inserting the new user, use the
> following:

> select @@identity
> from MyTable

> 

> 
> What ever your SQL is to insert the new user
> 

> 
> select @@identity
> from MyTable
> 

> 


> -Original Message-
> From: Chris Mueller [mailto:[EMAIL PROTECTED]
> Sent: Thursday, March 09, 2006 1:35 PM
> To: CF-Talk
> Subject: SQL-generated primary keys

> Here's a question I've been wrestling wtih.

> Suppose that there is an HTML form to create a new user.
> When the form
> is submitted, that user's information is added to the
> 'user' table.
> The table uses an auto-increment integer for its primary
> key/user id,
> so I'd like to grab that value for the newly created user.

> I've been using queries like this one: "SELECT
> MAX(user_id) FROM
> users", but I worry that if two users are created at the
> same time,
> then my query might give me the user id of the wrong user.

> Is there a better way to do this? Or maybe I shouldn't
> even worry about
> this?

> Thanks.
> Chris





> ~~
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234963
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: fusionkart??

[S . Isaac Dealey]

> Bud wrote:
>> Anyone out there using FusionKart? If so can you contact
>> me off list?
>>
>> Thanks a million.
>>
> Is that like mariokart but with ben forta instead of super
> mario?

It plays a wav of Forta saying "Mama Mia!" when your transaction
completes. :)


s. isaac dealey 434.293.6201
new epoch : isn't it time for a change?

add features without fixtures with
the onTap open source framework

http://www.fusiontap.com
http://coldfusion.sys-con.com/author/4806Dealey.htm


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234964
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Server-side validation with hidden input tags and security?

[S . Isaac Dealey]

> Any time you construct a query in CF, use cfqueryparam. As
> long as the
> DB supports bind parameters, the query is safe from SQL
> injection.

> Regardless, you still should validate server-side anyway.

> On 3/10/06, Oleg Gunkin <[EMAIL PROTECTED]> wrote:
>> I am trying to validate simple data like dates, emails to
>> prevent clients from dropping my database tables even if
>> they really want to.


That's true unless you use variables to construct portions of the
query which can't have cfqueryparam applied to them, i.e.



select ...
from table1
#join# join table2 on (...)


Although most queries don't need to use techniques like this, but if
you use a technique like this, then you need something other than
cfqueryparam to ensure the string is appropriate and not dangerous.
(The onTap framework's sql abstraction engine checks to make sure
tables and columns exist before generating the query, which eliminates
the possibility that these values could be used for sql injection --
the only exception is the order by argument which the documentation
says should never be populated with user data -- users can provide a
sort argument to override the order by, which is tested to prevent
injection)

However, for standard ColdFusion queries where only the values of
columns are dynamic (and not the structure of the query) then
cfqueryparam will protect you completely from sql injection attacks.

This is entirely separate from the issue of form validation, and no,
 is not secure and I
don't recommend using it. Though if you're diligent about using
cfqueryparam (which you should be anyway) even if you do get a
malicious user who changes the form, they won't be able to perform sql
injection by removing your form validation. That being said, I still
wouldn't use the hidden input elements (which is what the new cfform
features in CF7 use for server-side validation, so they're not secure
either), not to prevent sql injection (because that's handled
separately) but rather to prevent a malicious user from receiving a
ColdFusion error as a result of having abused the form. There are two
reasons for not wanting this 1) although it's a good idea to use a
cferror template or sitewide error handler to suppress the default
error display, these aren't always implemented and can provide the
malicous user with information they shouldn't have (whether it's
useful to them may be another story) and 2) even if the error message
isn't helpful to them in hacking your site, I'd rather not give them
the impression that the site might be hackable by letting them disable
validation on an input element.

My advice would be either become very friendly with isValid() and use
that exclusively for form validation, or find or build a tool or
framework for form validation. The onTap framework has one built in,
which may give you some ideas even if you don't necessarily want to
use the whole framework. There's also TerraForm which was written by
Matthew Walker and is not phenomenally expensive.


s. isaac dealey 434.293.6201
new epoch : isn't it time for a change?

add features without fixtures with
the onTap open source framework

http://www.fusiontap.com
http://coldfusion.sys-con.com/author/4806Dealey.htm


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234962
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

re: Flash form popup window

[dave]

search the archives, we had this very much in detail but i didnt use code and 
dont have it anymore

~Dave the disruptor~ 


From: Steve Milburn <[EMAIL PROTECTED]>
Sent: Thursday, March 09, 2006 7:29 PM
To: CF-Talk 
Subject: Flash form popup window 

Can anyone point me in the right direction for creating a popup window 
when using flash forms? I am looking for similar functionality to what 
Ben Forta has on his web site for submitting a review for an ISP. It 
creates a new window with a new form allowing you to complete the review.

I've seen a few examples that use the popup manager class, but the 
contentPath is throwing me off. It looks like it wants a .swf file. I 
want it to display another cf form.

Any help is appreciated.

Steve
---
---



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234961
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: I still use HomeSite+ 5.5 - Should I ""Upgrade"" to something else?

[Jeff Garza]

My biggest issue with DW is that it uses it's own HTTP system instead of
relying on the OS, like Homesite+ does.  This causes major issues with
internet proxies that require authentication.  There is nowhere to set a
username/password for http.  This effectively renders RDP dead for me.

..02

Jeff

-Original Message-
From: James Holmes [mailto:[EMAIL PROTECTED] 
Sent: Thursday, March 09, 2006 6:52 PM
To: CF-Talk
Subject: Re: I still use HomeSite+ 5.5 - Should I ""Upgrade"" to something
else?

You know that DW's inbuilt FTP allows you to edit a site directly on the
remote server, right?

On 3/9/06, Terry Schmitt <[EMAIL PROTECTED]> wrote:
> I seem to try every version of DW as it comes out, but quickly get dizzly
looking at all the [EMAIL PROTECTED] in the GUI and go right back to HS+.
> Mapping a drive really seems to bog things down and FTP is a pain, as
I prefer to develop on the development servers instead of my local PC.


--
CFAJAX docs and other useful articles:
http://jr-holmes.coldfusionjournal.com/



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234960
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: I still use HomeSite+ 5.5 - Should I ""Upgrade"" to something else?

[James Holmes]

You know that DW's inbuilt FTP allows you to edit a site directly on
the remote server, right?

On 3/9/06, Terry Schmitt <[EMAIL PROTECTED]> wrote:
> I seem to try every version of DW as it comes out, but quickly get dizzly 
> looking at all the [EMAIL PROTECTED] in the GUI and go right back to HS+.
> Mapping a drive really seems to bog things down and FTP is a pain, as I 
> prefer to develop on the development servers instead of my local PC.


--
CFAJAX docs and other useful articles:
http://jr-holmes.coldfusionjournal.com/

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234959
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Strip Email function

[Rick Root]

Mike | NZSolutions Ltd wrote:
> Hi all, I have just created a simple function to remove characters that
> may cause the cfmail tag to crash...

Why would you strip those characters out rather than just use an 
isEmail() function and refuse to accept invalid input?

Seems kinda silly to strip content from email addresses.

http://www.cflib.org/udf.cfm?ID=216

Rick

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234958
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Query of Queries and GROUP - problem

[Roberto Perez]

>When you figure out the specs on the production server, be sure to post -
>because I've never had this problem and it this is a new issue with 7 (we're
>not there yet), we're going to be in for  a world of hurt.
>


Turned out it was an issue with CF5. The server was a W2K server with IIS 5 and 
CF5. That seems to be the reason why several things that worked fine on my 6.0 
MX developer edition were throwing an error when uploaded to the CF5 server.

Roberto

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234957
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Flash form popup window

[Martyn Bowis]

getURL("put your url in here to your cfm page");

Need to use the quotes :)
  - Original Message - 
  From: Steve Milburn 
  To: CF-Talk 
  Sent: Friday, March 10, 2006 1:25 PM
  Subject: Flash form popup window


  Can anyone point me in the right direction for creating a popup window 
  when using flash forms?  I am looking for similar functionality to what 
  Ben Forta has on his web site for submitting a review for an ISP.  It 
  creates a new window with a new form allowing you to complete the review.

  I've seen a few examples that use the popup manager class, but the 
  contentPath is throwing me off.  It looks like it wants a .swf file.  I 
  want it to display another cf form.

  Any help is appreciated.

  Steve
  ---
  ---


  

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234956
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Flash form popup window

[Martyn Bowis]

Try using the following actionscript:

getURL(http://domain.com/page.cfm);

Cheers,
Martyn


On 3/10/2006 1:25:23 PM, cf-talk@houseoffusion.com wrote:
> Can anyone point me in the right direction for creating a popup window
> 
> when using flash forms?  I am looking for similar functionality to what
> 
> Ben Forta has on his web site for submitting a review for an ISP.  It
> 
> creates a new window with a new form allowing you to complete the review.
> 
> 
> 
> I've seen a few examples that use the popup manager class, but the
> contentPath is throwing me off.  It looks like it wants a .swf file.  I
> want it to display another cf form.
> 
> Any help is appreciated.
> 
> Steve
> ---
> ---
> 
> 
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234955
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Determine Visitors OS

[jonese]

Yea i was just hoping to avoid writing the code myself if someone else
has already done it.

jonese

On 3/9/06, Dave Watts <[EMAIL PROTECTED]> wrote:
> > Anyone have a function which will determine the OS of a
> > visitor to a website?
> >
> > I've already searched the usual suspects and couldn't come up
> > with anything.
>
> You can usually determine the client operating system by examining
> CGI.HTTP_USER_AGENT, although the reliability of this information cannot be
> guaranteed.
>
> 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!
>
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234954
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Flash form popup window

[Steve Milburn]

Can anyone point me in the right direction for creating a popup window 
when using flash forms?  I am looking for similar functionality to what 
Ben Forta has on his web site for submitting a review for an ISP.  It 
creates a new window with a new form allowing you to complete the review.

I've seen a few examples that use the popup manager class, but the 
contentPath is throwing me off.  It looks like it wants a .swf file.  I 
want it to display another cf form.

Any help is appreciated.

Steve
---
---


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234953
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Strip Email function

[Mike | NZSolutions Ltd]

Hi all, I have just created a simple function to remove characters that
may cause the cfmail tag to crash...


  





)", "",
"ALL")>












  


Can anyone think of some obvious items I am missing with this?

I also use the following javascript when the form is submitted...


function validateForm(passForm) {
if (passForm.email.value == "") {
alert ("Please enter a valid email address.");
passForm.email.focus();
return false;
}

if (passForm.email.value.indexOf('@',0) == -1 ||
passForm.email.value.indexOf('@',0) == 0 ||
passForm.email.value.indexOf('.',0) == -1) {
alert ("Please make sure your email address has
been entered in the correct format.");
passForm.email.select();
passForm.email.focus();
return false;
}

return true;
}


mike



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234952
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Server-side validation with hidden input tags and security?

[James Holmes]

Any time you construct a query in CF, use cfqueryparam. As long as the
DB supports bind parameters, the query is safe from SQL injection.

Regardless, you still should validate server-side anyway.

On 3/10/06, Oleg Gunkin <[EMAIL PROTECTED]> wrote:
> I am trying to validate simple data like dates, emails to prevent clients 
> from dropping my database tables even if they really want to.


--
CFAJAX docs and other useful articles:
http://jr-holmes.coldfusionjournal.com/

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234951
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Server-side validation with hidden input tags and security?

[Oleg Gunkin]

Ha-ha, I think I know how to dump and drop databases of most sites made with 
coldfusion :). That settles it then; I am not using hidden input tags for 
validation.

--
Oleg Gunkin
Email: [EMAIL PROTECTED]
Phone: (604) 666-9392
Emerging Technologies / Pacific Web Services
Information Technology Services
Public Works and Government Services Canada (Pacific)

-Original Message-
From: Russ [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 09, 2006 16:07
To: CF-Talk
Subject: RE: Server-side validation with hidden input tags and security?


I think he's talking about this:

http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/h
tml/wwhelp.htm?context=ColdFusion_Documentation&file=1380.htm

and no, it's not secure-per-se as a user can get around it by editing the
form, but it's secure enough so that if somebody messes around with it, and
gets an error message, it's their own fault, and as long as they can't do
anything malicious, no harm done. 

Russ



> -Original Message-
> From: Rick Root [mailto:[EMAIL PROTECTED]
> Sent: Thursday, March 09, 2006 6:56 PM
> To: CF-Talk
> Subject: Re: Server-side validation with hidden input tags and security?
> 
> What kind of stuff are you trying to "validate"?
> 
> Rick
> 
> Oleg Gunkin wrote:
> > It seems hard to believe that using special hidden input tags for
> server-side validation is a very secure method because user can save the
> form and remove the hidden tags; therefore, bypass the validation. Please,
> correct me if I am wrong. I want to know if I understand it right. Is
> using special hidden tags in forms really a secure method?
> 
> 
> 



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234950
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Server-side validation with hidden input tags and security?

[Ian Skinner]

I am trying to validate simple data like dates, emails to prevent clients from 
dropping my database tables even if they really want to.


For basic purposes - hidden fields on the client side and cfqueryparam on the 
server side will provide a fair amount of protection from this for very little 
code.

Now of course if the security complexity increases, more sophisticated measures 
may be required.


--
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. 




~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234949
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Server-side validation with hidden input tags and security?

[Oleg Gunkin]

I am trying to validate simple data like dates, emails to prevent clients from 
dropping my database tables even if they really want to.

--
Oleg Gunkin
Email: [EMAIL PROTECTED]
Phone: (604) 666-9392
Emerging Technologies / Pacific Web Services
Information Technology Services
Public Works and Government Services Canada (Pacific)

-Original Message-
From: Rick Root [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 09, 2006 15:56
To: CF-Talk
Subject: Re: Server-side validation with hidden input tags and security?


What kind of stuff are you trying to "validate"?

Rick

Oleg Gunkin wrote:
> It seems hard to believe that using special hidden input tags for server-side 
> validation is a very secure method because user can save the form and remove 
> the hidden tags; therefore, bypass the validation. Please, correct me if I am 
> wrong. I want to know if I understand it right. Is using special hidden tags 
> in forms really a secure method?




~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234948
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Server-side validation with hidden input tags and security?

[Russ]

I think he's talking about this:

http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/h
tml/wwhelp.htm?context=ColdFusion_Documentation&file=1380.htm

and no, it's not secure-per-se as a user can get around it by editing the
form, but it's secure enough so that if somebody messes around with it, and
gets an error message, it's their own fault, and as long as they can't do
anything malicious, no harm done. 

Russ



> -Original Message-
> From: Rick Root [mailto:[EMAIL PROTECTED]
> Sent: Thursday, March 09, 2006 6:56 PM
> To: CF-Talk
> Subject: Re: Server-side validation with hidden input tags and security?
> 
> What kind of stuff are you trying to "validate"?
> 
> Rick
> 
> Oleg Gunkin wrote:
> > It seems hard to believe that using special hidden input tags for
> server-side validation is a very secure method because user can save the
> form and remove the hidden tags; therefore, bypass the validation. Please,
> correct me if I am wrong. I want to know if I understand it right. Is
> using special hidden tags in forms really a secure method?
> 
> 
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234947
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Server-side validation with hidden input tags and security?

[Rick Root]

What kind of stuff are you trying to "validate"?

Rick

Oleg Gunkin wrote:
> It seems hard to believe that using special hidden input tags for server-side 
> validation is a very secure method because user can save the form and remove 
> the hidden tags; therefore, bypass the validation. Please, correct me if I am 
> wrong. I want to know if I understand it right. Is using special hidden tags 
> in forms really a secure method?


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234946
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Server-side validation with hidden input tags and security?

[Ian Skinner]

It seems hard to believe that using special hidden input tags for server-side 
validation is a very secure method because user can save the form and remove 
the hidden tags; therefore, bypass the validation. Please, correct me if I am 
wrong. I want to know if I understand it right. Is using special hidden tags in 
forms really a secure method?


NOPE!  Client side validation is never secure.  It is there for the user's 
experience.  One should always back up client side validation with server side 
validation.  Some users do not play nice.


--
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. 




~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234945
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: cfajax vs ajaxCFC Question.

[Rick Root]

Munson, Jacob wrote:
> 
> Interesting.  What license did he used to have, and how was it
> restrictive?

It was an informal "You can only redistribute it with my permission" 
license and although he apparently never refused permission to anyone, 
I'm enough of a fan of freely redistributable, open source software that 
it turned me off.

Basically because I develop applications that I want to be open source 
and freely distributable (image.cfc, blogcfm, cffm, etc)

Rick

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234944
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: cfajax vs ajaxCFC Question.

[James Holmes]

Did you add it to the wiki?

On 3/10/06, Rick Root <[EMAIL PROTECTED]> wrote:

> cfajax still has this issue but I recently posted a "fix":
>
> http://www.opensourcecf.com/1/2006/02/Getting-CFAJAX-to-handle-Safari-properly.cfm

--
CFAJAX docs and other useful articles:
http://jr-holmes.coldfusionjournal.com/

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234943
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Server-side validation with hidden input tags and security?

[Oleg Gunkin]

It seems hard to believe that using special hidden input tags for server-side 
validation is a very secure method because user can save the form and remove 
the hidden tags; therefore, bypass the validation. Please, correct me if I am 
wrong. I want to know if I understand it right. Is using special hidden tags in 
forms really a secure method?

--
Oleg Gunkin
Email: [EMAIL PROTECTED]
Phone: (604) 666-9392
Emerging Technologies / Pacific Web Services
Information Technology Services
Public Works and Government Services Canada (Pacific)

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234942
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: SQL-generated primary keys

[Aaron Rouse]

We too use a sequence per table, just thought it was an interesting approach
when I saw someone doing only one and felt like mentioning to see if any
others do that.  On some of ours we have a pre-insert trigger and others we
do not, there is no consistency here on that other than no one ever seems to
manual insert the IDs.

On 3/9/06, Bryan Stevenson <[EMAIL PROTECTED]> wrote:
>
> I never said I use 1 sequence...just an example
>
> We use a sequence for each table ;-)
>
> We also use pre-insert triggers to grab nextval if the PK is not supplied
> in the
> insert statement
>
> When inserting a parent and then children we always select from the
> sequence
> first and use the new PK val in the parent and al children inserts
>
> Cheers
>
>


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234941
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Determine Visitors OS

[Dave Watts]

> Anyone have a function which will determine the OS of a 
> visitor to a website?
> 
> I've already searched the usual suspects and couldn't come up 
> with anything.

You can usually determine the client operating system by examining
CGI.HTTP_USER_AGENT, although the reliability of this information cannot be
guaranteed.

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!

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234940
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: SQL-generated primary keys

[Bryan Stevenson]

I never said I use 1 sequence...just an example

We use a sequence for each table ;-)

We also use pre-insert triggers to grab nextval if the PK is not supplied in 
the 
insert statement

When inserting a parent and then children we always select from the sequence 
first and use the new PK val in the parent and al children inserts

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 


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234939
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Determine Visitors OS

[jonese]

Anyone have a function which will determine the OS of a visitor to a website?

I've already searched the usual suspects and couldn't come up with anything.

jonese

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234938
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: SQL-generated primary keys

[Aaron Rouse]

I did some maintenance on a project recently that did this.  They also only
had one sequence for the entire project.  Their theory was it made it harder
for someone to try and edit/delete/view records via just changing the ID in
the URL/FORM.  Since your records could go from 1 to 50 to 190.

We just use triggers here and those plug in the nextval of the sequence.  We
also almost never need the ID of what was just inserted, when we do
typically we just rely on a cftransaction and do two queries or if more
complex then an SP.


On 3/9/06, Bryan Stevenson <[EMAIL PROTECTED]> wrote:
>
>
> Just like SELECT nextval FROM dual in Oracle
>
>


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234937
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: SQL-generated primary keys

[Bryan Stevenson]

> Something I used to do when I was using PostGres years ago was select a
> new identity from a table and then use it for all subsequent updates.
> People tell me you can't do this with SQL Server, but I think this is BY
> FAR the safest way to handle this.  Here's some pseudo code for clarity:

Just like SELECT nextval FROM dual in Oracle

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

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234936
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: SQL-generated primary keys

[Munson, Jacob]

Something I used to do when I was using PostGres years ago was select a
new identity from a table and then use it for all subsequent updates.
People tell me you can't do this with SQL Server, but I think this is BY
FAR the safest way to handle this.  Here's some pseudo code for clarity:

select new id as @identity from users

update users
set fname = 'jake',
lname = 'munson'
where id = @identity





[INFO] -- Access Manager:
This transmission may contain information that is privileged, confidential 
and/or exempt from disclosure under applicable law.  If you are not the 
intended recipient, you are hereby notified that any disclosure, copying, 
distribution, or use of the information contained herein (including any 
reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in 
error, please immediately contact the sender and destroy the material in its 
entirety, whether in electronic or hard copy format.  Thank you.   A2



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234935
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Beginner Book and Tutorial

[Nathan Strutz]

If you really wanted to invest in yourself, go for the WACK.

http://www.amazon.com/gp/product/0321223675/sr=8-1/qid=1141943395/ref=pd_bbs_1/103-3913621-6167846?%5Fencoding=UTF8

This book is absolutely perfect for new CF developers. You can usually find
a copy at your local bookstore, but head online to find a cheaper copy (or,
I'm sure a few people here have one they might give you). I really can't
recommend it enough. It teaches you what web application programming is,
then it takes you into the basics of ColdFusion, and through actual code and
building useful things.

-nathan strutz
http://www.dopefly.com/


On 3/9/06, Snake <[EMAIL PROTECTED]> wrote:
>
> www.easycfm.com might be a good start
>
> Also read the docs that come with CF and check the example applications.
>
> Russ
>
> -Original Message-
> From: Jason Herbolsheimer [mailto:[EMAIL PROTECTED]
> Sent: 09 March 2006 22:17
> To: CF-Talk
> Subject: Beginner Book and Tutorial
>
> Hello all,
> I'm looking for a good source and walk-through tutorial for a beginner.
> Can anyone give me some ideas that would help someone who knows HTML try
> to
> begin and understand coldfusion?
>
> Thanks in advance.
>
>
>
>
>
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234934
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Beginner Book and Tutorial

[Ray Champagne]

WACK WACK WACK!

http://tinyurl.com/omgkm

Quintessential!

Snake wrote:
> www.easycfm.com might be a good start
> 
> Also read the docs that come with CF and check the example applications.
> 
> Russ 
> 
> -Original Message-
> From: Jason Herbolsheimer [mailto:[EMAIL PROTECTED] 
> Sent: 09 March 2006 22:17
> To: CF-Talk
> Subject: Beginner Book and Tutorial
> 
> Hello all,
> I'm looking for a good source and walk-through tutorial for a beginner.
> Can anyone give me some ideas that would help someone who knows HTML try to
> begin and understand coldfusion?
> 
> Thanks in advance.
> 
> 
> 
> 
> 
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234933
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Beginner Book and Tutorial

[Snake]

www.easycfm.com might be a good start

Also read the docs that come with CF and check the example applications.

Russ 

-Original Message-
From: Jason Herbolsheimer [mailto:[EMAIL PROTECTED] 
Sent: 09 March 2006 22:17
To: CF-Talk
Subject: Beginner Book and Tutorial

Hello all,
I'm looking for a good source and walk-through tutorial for a beginner.
Can anyone give me some ideas that would help someone who knows HTML try to
begin and understand coldfusion?

Thanks in advance.





~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234932
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Beginner Book and Tutorial

[Jason Herbolsheimer]

Hello all,
I'm looking for a good source and walk-through tutorial for a beginner.
Can anyone give me some ideas that would help someone who knows HTML try 
to begin and understand coldfusion?

Thanks in advance.



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234931
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: SQL-generated primary keys

[Jacob]

My mistake...

   insert into mytable([columns])
values([values])
select @@identity as user_id


All in one query, not two like I posted.
-Original Message-
From: Jacob [mailto:[EMAIL PROTECTED] 
Sent: Thursday, March 09, 2006 2:13 PM
To: CF-Talk
Subject: RE: SQL-generated primary keys

After the command for inserting the new user, use the following:

select @@identity
from MyTable




What ever your SQL is to insert the new user



select @@identity
from MyTable





-Original Message-
From: Chris Mueller [mailto:[EMAIL PROTECTED] 
Sent: Thursday, March 09, 2006 1:35 PM
To: CF-Talk
Subject: SQL-generated primary keys

Here's a question I've been wrestling wtih.

Suppose that there is an HTML form to create a new user. When the form
is submitted, that user's information is added to the 'user' table.
The table uses an auto-increment integer for its primary key/user id,
so I'd like to grab that value for the newly created user.

I've been using queries like this one: "SELECT MAX(user_id) FROM
users", but I worry that if two users are created at the same time,
then my query might give me the user id of the wrong user.

Is there a better way to do this? Or maybe I shouldn't even worry about
this?

Thanks.
Chris





~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234930
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: SQL-generated primary keys

[Jacob]

After the command for inserting the new user, use the following:

select @@identity
from MyTable




What ever your SQL is to insert the new user



select @@identity
from MyTable





-Original Message-
From: Chris Mueller [mailto:[EMAIL PROTECTED] 
Sent: Thursday, March 09, 2006 1:35 PM
To: CF-Talk
Subject: SQL-generated primary keys

Here's a question I've been wrestling wtih.

Suppose that there is an HTML form to create a new user. When the form
is submitted, that user's information is added to the 'user' table.
The table uses an auto-increment integer for its primary key/user id,
so I'd like to grab that value for the newly created user.

I've been using queries like this one: "SELECT MAX(user_id) FROM
users", but I worry that if two users are created at the same time,
then my query might give me the user id of the wrong user.

Is there a better way to do this? Or maybe I shouldn't even worry about
this?

Thanks.
Chris



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234929
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: SQL-generated primary keys

[S . Isaac Dealey]

> depending on your database, you can retrieve the identity
> value when
> it's created.

> SQL Server has @@identity
> mySQL has last_inserted_id

Although you really shouldn't use @@identity if you have access to SQL
Server 2000 or later... @@identity is not thread safe and will result
in the same race condition, that's why scope_identity() was introduced
in SQL 2000

s. isaac dealey 434.293.6201
new epoch : isn't it time for a change?

add features without fixtures with
the onTap open source framework

http://www.fusiontap.com
http://coldfusion.sys-con.com/author/4806Dealey.htm


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234928
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: SQL-generated primary keys

[Sandra Clark]

If it is SQL Server, do this


Insert into () Values ();
SELECT  SCOPE_IDENTITY() AS id

That will give you the correct identity id

Sandra Clark
-Original Message-
From: Chris Mueller [mailto:[EMAIL PROTECTED] 
Sent: Thursday, March 09, 2006 4:35 PM
To: CF-Talk
Subject: SQL-generated primary keys

Here's a question I've been wrestling wtih.

Suppose that there is an HTML form to create a new user. When the form is
submitted, that user's information is added to the 'user' table.
The table uses an auto-increment integer for its primary key/user id, so I'd
like to grab that value for the newly created user.

I've been using queries like this one: "SELECT MAX(user_id) FROM users", but
I worry that if two users are created at the same time, then my query might
give me the user id of the wrong user.

Is there a better way to do this? Or maybe I shouldn't even worry about
this?

Thanks.
Chris



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234927
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: SQL-generated primary keys

[S . Isaac Dealey]

> Here's a question I've been wrestling wtih.

> Suppose that there is an HTML form to create a new user.
> When the form
> is submitted, that user's information is added to the
> 'user' table.
> The table uses an auto-increment integer for its primary
> key/user id,
> so I'd like to grab that value for the newly created user.

> I've been using queries like this one: "SELECT
> MAX(user_id) FROM
> users", but I worry that if two users are created at the
> same time,
> then my query might give me the user id of the wrong user.

> Is there a better way to do this? Or maybe I shouldn't
> even worry about this?

> Thanks.
> Chris

I would definately worry about it.

Yes, if you "select max(user_id) from users" to get the inserted
record id after performing an insert without any other preparation,
you will create a race condition in which two pages could erroneously
receive the same user_id value even though 2 separate values had been
inserted into the table.

There are several ways to get around this issue.

One is to use an nvarchar, varchar or guid column in SQL server and
generate your ID prior to the insert. If you need to insert additional
records in related tables for the generated user, then you'll have to
either generate the ID in ColdFusion or you'll have to find another
way to return that GUID to CF from SQL Server (the function NewID() is
used in SQL Server to generate these id's) such as a stored procedure.
Oracle by comparison will give you SQL Standard Sequences (not widely
supported yet) which can be used similarly to identity columns but
allow you to fetch the next id prior to insert. Personally I prefer to
generate ID's in CF.

Another popular method is to use a cftransaction around the insert and
the select statements...


  insert into ...
  select max() from ...


This eliminates the race condition at the expense of carving out some
scalability. By this I mean that as the size of your table becomes
larger, it takes longer to perform the select max() query. Generally
speaking the increase in time for the 2nd query isn't noticeable, but
it's possible in theory that it could be an issue with very large
numbers of records (I would guess in the millions, so it's not likely
to be an issue with a users table specifically, but may be with some
other tables).

Another option is to use database-specific tools to fetch the new id.
With SQL Server 2000 or 2005 you can use a single query with 2
statements like so:


  insert into ...
  select scope_identity() as newid


The scope_identity() function was added in SQL Server 2000 to resolve
the issue of the previously available @@identity variable not being
thread safe (i.e. same race condition issue you have now). Of course,
the trade here is that the code then becomes dependant on the choice
of SQL Server. Most of the time this is fine, but on the off chance
the company hires a new CTO who's in love with Oracle, you'll have to
replace any references to this method. Of course, the same is largely
true of the first method above if you use newid() to generate GUIDs,
although using stored procedures to perform those inserts can insulate
the ColdFusion code from those changes (i.e. you would still have to
do the work if you needed to convert it to use Oracle, but your CF
code would remain unchanged).

So -- there are some options, plus and minus. For my money it just
seems to be easiest in general to generate ID's in advance of the
insert with CF, although in some environments it's necessary to allow
records to be inserted by non CF systems as well, at which point a
database-specific tool (usually stored procedures) becomes a
necessity.


s. isaac dealey 434.293.6201
new epoch : isn't it time for a change?

add features without fixtures with
the onTap open source framework

http://www.fusiontap.com
http://coldfusion.sys-con.com/author/4806Dealey.htm


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234926
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: SQL-generated primary keys

[Bryan Stevenson]

depends on the DB...which one are you using?

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

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234925
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: SQL-generated primary keys

[Aaron Rouse]

There are a ton of different ways to handle this.  Starting with using a
CFtransaction tag around the two queries down to just not auto-generating it
through the database and inserting the value via queries.  Some databases
offer functions for grabbing the autogenerated ID that was inserted, that
might be the best place to start looking.

On 3/9/06, Chris Mueller <[EMAIL PROTECTED]> wrote:
>
> Here's a question I've been wrestling wtih.
>
> Suppose that there is an HTML form to create a new user. When the form
> is submitted, that user's information is added to the 'user' table.
> The table uses an auto-increment integer for its primary key/user id,
> so I'd like to grab that value for the newly created user.
>
> I've been using queries like this one: "SELECT MAX(user_id) FROM
> users", but I worry that if two users are created at the same time,
> then my query might give me the user id of the wrong user.
>
> Is there a better way to do this? Or maybe I shouldn't even worry about
> this?
>
> Thanks.
> Chris
>
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234924
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: SQL-generated primary keys

[Charlie Griefer]

depending on your database, you can retrieve the identity value when
it's created.

SQL Server has @@identity
mySQL has last_inserted_id

http://weblogs.macromedia.com/cantrell/archives/2004/11/safely_selectin.cfm
http://www.webtricks.com/sourcecode/code.cfm?CodeID=23

there's a gaggle of info out there on the various techniques that the
various RDBMSs offer.  Google is your budy :)


On 3/9/06, Chris Mueller <[EMAIL PROTECTED]> wrote:
> Here's a question I've been wrestling wtih.
>
> Suppose that there is an HTML form to create a new user. When the form
> is submitted, that user's information is added to the 'user' table.
> The table uses an auto-increment integer for its primary key/user id,
> so I'd like to grab that value for the newly created user.
>
> I've been using queries like this one: "SELECT MAX(user_id) FROM
> users", but I worry that if two users are created at the same time,
> then my query might give me the user id of the wrong user.
>
> Is there a better way to do this? Or maybe I shouldn't even worry about this?
>
> Thanks.
> Chris
>
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234923
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

SQL-generated primary keys

[Chris Mueller]

Here's a question I've been wrestling wtih.

Suppose that there is an HTML form to create a new user. When the form
is submitted, that user's information is added to the 'user' table.
The table uses an auto-increment integer for its primary key/user id,
so I'd like to grab that value for the newly created user.

I've been using queries like this one: "SELECT MAX(user_id) FROM
users", but I worry that if two users are created at the same time,
then my query might give me the user id of the wrong user.

Is there a better way to do this? Or maybe I shouldn't even worry about this?

Thanks.
Chris

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234922
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: I still use HomeSite+ 5.5 - Should I ""Upgrade"" to something else?

[Stephen Collins]

> Not trying to fire off a crazy debate but this seems like a fantastic
> editor... it's got all of the keystore shortcuts I need to be really
> productive. However, this editor is 3 years old. Any reason I should 
> use
> some other tool? Opinions?

Jon

I'm going to join the choir and tell you that you should give Eclipse/CFEclipse 
a run.  It really does have everything you'll need, and is getting better all 
the time.  The latest nightly builds have some great new features, most of 
which will be in a release fairly soon.

If you're unsure of how to tackle setting everything up, take a look at my 
publication, The ACME Guide (http://www.stephencollins.org/acme/).  It's free.

Steve Collins
-- 
Steve Collins
E [EMAIL PROTECTED]
W www.stephencollins.org
ICQ 1014940 | MSN [EMAIL PROTECTED] | Yahoo trib
Google Talk [EMAIL PROTECTED] | Skype trib22

 The ACME Guide - Best practice development using
Apache - ColdFusion MX - MySQL - Eclipse/CFEclipse
   www.stephencollins.org/acme/

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234921
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: I still use HomeSite+ 5.5 - Should I "Upgrade" to something else?

[Munson, Jacob]

> I hit Ctrl+S when filling out forms within browsers. 

Lol.  I find myself doing the same kinds of things.  Also, I hit
ctrl+enter to send email messages (in both Outlook and T-Bird), and I
always hit that to submit forms.  :)


-

This transmission may contain information that is privileged, confidential 
and/or exempt from disclosure under applicable law. If you are not the intended 
recipient, you are hereby notified that any disclosure, copying, distribution, 
or use of the information contained herein (including any reliance thereon) is 
STRICTLY PROHIBITED. If you received this transmission in error, please 
immediately contact the sender and destroy the material in its entirety, 
whether in electronic or hard copy format. Thank you. A1.



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234920
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: CFLOOP in Edit Mode - Invalid CFML construct

[Claude Schneegans]

 >>If you do a  in your custom tags then you 
could do
the /> method with them.

Just what I mean: you have to do something.

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


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234919
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: cfajax vs ajaxCFC Question.

[Munson, Jacob]

> I avoided ajaxCFC because of Rob's restricted open source 
> license.  I do 
> agree that Arjun hasn't been providing much support.  If he had an 
> official open source license, I'd create a cfopen project and 
> release my 
> own "derivative" work (RabidCFAJAX, anyone?) so that we could have 
> multiple developers working on it as an active project.
> 
> Given Rob's recent switch the the Apache license, I'm more likely to 
> check it out.

Interesting.  What license did he used to have, and how was it
restrictive?


--


[INFO] -- Access Manager:
This transmission may contain information that is privileged, confidential 
and/or exempt from disclosure under applicable law.  If you are not the 
intended recipient, you are hereby notified that any disclosure, copying, 
distribution, or use of the information contained herein (including any 
reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in 
error, please immediately contact the sender and destroy the material in its 
entirety, whether in electronic or hard copy format.  Thank you.   A2



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234918
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Truncated Emails : maybe OT

[Jochem van Dieten]

Charlie Hanlon wrote:
> Do you have lines longer then 998 characters?
> 
> The contents of the emails gets generated dynamically.  I am not sure how I 
> would know the character count per line.

Ask the end user with the problem to look at the source.

Jochem

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234917
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: I still use HomeSite+ 5.5 - Should I "Upgrade" to something else?

[Jeff Fleitz]

I am a Window's user and I use Sapien's PrimalScript, and have been since I
stopped using HomeSite+ over a year ago. I also have CFE and DW8.  Currently
I am switching back and forth between CFE and PS on different projects, and
I like alot about CFE (great job guys).  But I still find myself coming back
to PS.  It is just lighter and quicker.  Great snippet support and
intellisense/code completion, auto-backups, etc. I use the enterprise
version which has a killer Visual Query Builder and XML Editor in it,
support for multisite deployment via ftp.  I supports 30 languages including
AS2 and it looks like they are gearing up to support Flex 2/AS3. It has full
support for ASP.NET, C#, VB etc., so if you are in the BD.NET camp it is a
good choice.  Some of the best support I have ever seen.

Downsides for CF'ers are that it only supports VSS for source control, and
the code competion doesn't enumerate tag attributes. Also, it ain't cheap
($350 for the Enterprise version).  But it is a great editor for Windows
users involved in multiple development environments.  45 day free eval;
might be worth your while to check it out.

www.sapien.com




On 3/9/06, Jon Block <[EMAIL PROTECTED]> wrote:
>
> Not trying to fire off a crazy debate but this seems like a fantastic
> editor... it's got all of the keystore shortcuts I need to be really
> productive. However, this editor is 3 years old. Any reason I should use
> some other tool? Opinions?
>
> Jon
>
>
> This electronic message transmission contains information from Collegiate
> Funding Services, LLC or its subsidiaries or affiliates that may be
> confidential or privileged. The information is intended to be for the use of
> only the individual or entity named above. If you are not the intended
> recipient, be aware that any disclosure, copying, distribution or use of the
> contents of this information is strictly prohibited. If you have received
> this electronic transmission in error, please notify the sender by reply
> e-mail @cfsloans.com immediately and delete this e-mail and any
> attachments from your system and any copies you may have made, electronic or
> otherwise.
>
>
>
>
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234916
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: OT: Styling form inputs

[dave]

input:focus,textarea:focus { background-color: #CCFF99; border: 1px dashed 
#E92D68; }

thats what i used on http://www.icandfashion.com/candstore/contact.cfm

~Dave the disruptor~ 





~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234915
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: cfajax vs ajaxCFC Question.

[Rick Root]

Munson, Jacob wrote:
> 
> This isn't true anymore.  The latest release, 0.66 I believe, does
> arguments the same way that cfajax does.

That's good to hear.

> 
> Also, the last cfajax release I used before jumping
> ship didn't work with Apple's Safari.  This may or may not be a concern
> for you, but for my site (http://techfeed.net/cfQuickDocs/) that was a
> deal breaker.  

cfajax still has this issue but I recently posted a "fix":

http://www.opensourcecf.com/1/2006/02/Getting-CFAJAX-to-handle-Safari-properly.cfm

> I like ajaxCFC, there's a lot better support.  Arjun is a great guy, and
> he's awesome for having created cfajax and giving it to the community,
> but he isn't very good at giving support.  Rob, on the other hand, is
> always very responsive and helpful on the ajaxCFC mailing list.

I avoided ajaxCFC because of Rob's restricted open source license.  I do 
agree that Arjun hasn't been providing much support.  If he had an 
official open source license, I'd create a cfopen project and release my 
own "derivative" work (RabidCFAJAX, anyone?) so that we could have 
multiple developers working on it as an active project.

Given Rob's recent switch the the Apache license, I'm more likely to 
check it out.

rick

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234914
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: I still use HomeSite+ 5.5 - Should I "Upgrade" to something else?

[Dawson, Michael]

I hit Ctrl+S when filling out forms within browsers. 

-Original Message-
From: Tony [mailto:[EMAIL PROTECTED] 
Sent: Thursday, March 09, 2006 2:20 PM
To: CF-Talk
Subject: Re: I still use HomeSite+ 5.5 - Should I "Upgrade" to something
else?

i hit ctrl+s in my sleep, i swear... im sooo used to it now, all the
time that i dream about it :)

man, i need to get out sometimes, cant wait for golf season

tw

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234913
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: cfajax vs ajaxCFC Question.

[Rick Root]

Nick Han wrote:
> I have used both of these APIs in my test environment.  I think they
> both work well.  There are pros and cons in choosing one over the other,
> and most of these issues I encountered were minor.  For instance,
> ajaxCFC is easier to set up, but the thing I don't like about it is the
> passed parameters are transformed and received as array arguments by the
> CFCs.  As for CFAJAX it is more work to set up, I like the fact that
> arguments are received by functions the way there have been passed by
> the calling page.  So you keep variable naming in tact for
> self-documenting and easy debugging.  Also with CFAJAX you can't use it
> within CFC framework.  So there's a mixed bag of good and bad between
> the two.

Personally, I've found cfajax fairly easy to deal with once you get it 
installed and working, so I don't really consider that an issue. 
Although the documentation talks about mappings and such there's really 
no need for the mapping.

I haven't tried ajaxCFC but I don't like the sound of what you described 
with reference to variables.

You *CAN* use cfajax in a CFC environment if you make some 
modifications.  For example, you could take the functions out of 
functions.cfm and put them into a component, and then do something like 
this in your functions.cfm file:









Rick

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234912
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: I still use HomeSite+ 5.5 - Should I "Upgrade" to something else?

[Mark Drew]

Rick,

Do not even mention He3.. pah! ;)

we have done a lot of work on CFEclipse especially recently to bring  
it in line with some of the HS user's expectations but we cant keep  
everyone happy.

I have some plans for functions in CFE that will make HS look like  
what it is... an old editor. I prefer TextPad rather than HS.

We have a browser, we have a couple... in fact we have four if you  
count the external setup.

We 'could' add it like in HS but I  I dont know about other people  
but if you are doing frameworks... well.. I dont know how that could  
help, you still need to do something like fuseaction=bla or event=bob  
etc.

I have plans for it to figure this out automatically for you in the  
future as well as CFE providing function insight into CFC's for  
you... homesite WONT do that .. ok ok.. they will add VTMs. big deal.

Anyways.. if you like what you got. keep using it.. but the question  
was about upgrading... and at the moment I think CFE is only other  
editor out there that is really focusing on coldfusion 'coders'.



anyways...



On 9 Mar 2006, at 16:35, Rick Root wrote:

> Mark Drew wrote:
>> Because its 3 years old is a good reason.. to a level I guess.  
>> also if you
>> are using it for a language (cfml) that is changing and getting new
>> features.
>
> Macromedia released tag updates for Homesite, so that's not really  
> relevant.
>
> I still use Homesite 5.5+ too...  I tried He3 and didn't like it.. my
> experiences with Eclipse from 2-3 years ago turned me off completely
> though I haven't tried CFEclipse.  Plus I've heard that CFEclipse
> doesn't have a "browse" tab like Homesite does, and I do use that from
> time to time when I'm working on layouts and such.
>
> Rick
>
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234911
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: I still use HomeSite+ 5.5 - Should I "Upgrade" to something else?

[Aaron Rouse]

With CFE how does the CSS work as you type it out?  I always liked how DWMX
deals with that.  I have seen people mention plugins for CSS, so I assume
there is one out there that gives you the same effect?  I think that is one
thing that keeps me away from CFE, not knowing what plug ins to get or not
get and being too lazy to research it :)

On 3/9/06, Rick Root <[EMAIL PROTECTED]> wrote:
>
> Munson, Jacob wrote:
> >>Oh! I didnt remember HS letting you do that! No I don't think
> >>it does let
> >>you do that, you have to hit ctrl+s :-)
> >
> >
> > It's good to save often anyway.  And with Eclipse's built-in version
> > control (the simple version compare stuff), I can't see any reason why
> > people wouldn't be hitting save every 5 seconds!  :)
>
> Granted, but sometimes I'm just testing something CSS related or
> whatever and I just type it into a blank document and click "Browse"..
>
> I'm not saving it in those cases because there's no need.
>
> Rick
>
>


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234910
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: I still use HomeSite+ 5.5 - Should I "Upgrade" to something else?

[Rick Root]

Munson, Jacob wrote:
>>Oh! I didnt remember HS letting you do that! No I don't think 
>>it does let
>>you do that, you have to hit ctrl+s :-)
> 
> 
> It's good to save often anyway.  And with Eclipse's built-in version
> control (the simple version compare stuff), I can't see any reason why
> people wouldn't be hitting save every 5 seconds!  :)

Granted, but sometimes I'm just testing something CSS related or 
whatever and I just type it into a blank document and click "Browse"..

I'm not saving it in those cases because there's no need.

Rick

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234909
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

SOT: keep info after history(-1)

[Orlini, Robert]

After finding a duplicate record my script runs:


alert ("**IDENTICAL found in inventory. record must be unique.**");
window.history.go(-1);  


When it goes back, it keeps the info the user typed in that caused the alert 
pop-up. 

How do I keep the info in the fields from the original record that was 
displaying?

Thanks as always.

Robert O.


-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.375 / Virus Database: 268.2.1/277 - Release Date: 3/8/2006
 


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234908
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: I still use HomeSite+ 5.5 - Should I "Upgrade" to something else?

[Tony]

i hit ctrl+s in my sleep, i swear... im sooo used to it now, all the time
that i dream about it :)

man, i need to get out sometimes, cant wait for golf season

tw

On 3/9/06, Munson, Jacob <[EMAIL PROTECTED]> wrote:
> > Oh! I didnt remember HS letting you do that! No I don't think
> > it does let
> > you do that, you have to hit ctrl+s :-)
>
> It's good to save often anyway.  And with Eclipse's built-in version
> control (the simple version compare stuff), I can't see any reason why
> people wouldn't be hitting save every 5 seconds!  :)
>
>
> ---
>
> This transmission may contain information that is privileged, confidential 
> and/or exempt from disclosure under applicable law. If you are not the 
> intended recipient, you are hereby notified that any disclosure, copying, 
> distribution, or use of the information contained herein (including any 
> reliance thereon) is STRICTLY PROHIBITED. If you received this transmission 
> in error, please immediately contact the sender and destroy the material in 
> its entirety, whether in electronic or hard copy format. Thank you. A1.
>
>
>
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234907
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: FCKeditor and the TMT validation javascript library.

[Andy Matthews]

Anyone have an idea on this?



-Original Message-
From: Andy Matthews [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 09, 2006 10:58 AM
To: CF-Talk
Subject: FCKeditor and the TMT validation javascript library.


I'm using the FCKeditor for a rich text field in my content management
system. I want this particular field to be required and I use the TMT
validation library for that purpose. Problem is that the way the fck field
is instantiated seperates me from the way it's created. This is the code
which is generated for the field in question:





Anyone have any ideas whatsoever on how I can get the tmt:required="true"
snip of code somewhere in there to force it to be required?




~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234906
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: CFLOOP in Edit Mode - Invalid CFML construct

[Aaron Rouse]

If you do a  in your custom tags then you could do
the /> method with them.  Although maybe there are times that could not be
done, can not honestly think of a time but I am sure there are some.  We use
a system here that uses a ton of custom tags and unfortunately it is just
second nature for me to type /> so I would find myself constantly
backspacing through my code, finally just ended up adding the cfexit tag.  I
have had to do a few XHTML classes, so it has become a hard habbit for me to
break when I type out tags, but I doubt many of the things I write would
pass the XHTML verification tools.


On 3/9/06, Claude Schneegans <[EMAIL PROTECTED]> wrote:
>
> >>It is valid XHTML
>
> Ah ok.
> Personnally, I'll use XHTML when I'll need to, for the time being,
> I prefer having all CFML and HTML tags and attributes in upper case,
> and all variables and the rest of the code in lower case, question of
> readibility,
> but of course it is personal.
> Closing unnecessary tags also creates trouble with custom tags executed
> twice,
> so I prefer not using it at all.
> One would say that you don't have to apply XHTML rules to CF tags, but
> that would
> be even more confusing.
>
> --
> ___
> REUSE CODE! Use custom tags;
> See http://www.contentbox.com/claude/customtags/tagstore.cfm
> (Please send any spam to this address: [EMAIL PROTECTED])
> Thanks.
>
>
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234905
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: CFLOOP in Edit Mode - Invalid CFML construct

[Claude Schneegans]

 >>It is valid XHTML

Ah ok.
Personnally, I'll use XHTML when I'll need to, for the time being,
I prefer having all CFML and HTML tags and attributes in upper case,
and all variables and the rest of the code in lower case, question of 
readibility,
but of course it is personal.
Closing unnecessary tags also creates trouble with custom tags executed 
twice,
so I prefer not using it at all.
One would say that you don't have to apply XHTML rules to CF tags, but 
that would
be even more confusing.

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


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234904
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: I still use HomeSite+ 5.5 - Should I ""Upgrade"" to something else?

[Robert Everland III]

Yes I used the latest version of CFE. It's not that there is a bug, it's just 
not as robust as Homesite. I realize that Homesite hasn't released a new 
version in years and I would like to use CFE, I just don't like the color 
support.


Bob

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234903
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: I still use HomeSite+ 5.5 - Should I "Upgrade" to something else?

[Munson, Jacob]

> Oh! I didnt remember HS letting you do that! No I don't think 
> it does let
> you do that, you have to hit ctrl+s :-)

It's good to save often anyway.  And with Eclipse's built-in version
control (the simple version compare stuff), I can't see any reason why
people wouldn't be hitting save every 5 seconds!  :)


---

This transmission may contain information that is privileged, confidential 
and/or exempt from disclosure under applicable law. If you are not the intended 
recipient, you are hereby notified that any disclosure, copying, distribution, 
or use of the information contained herein (including any reliance thereon) is 
STRICTLY PROHIBITED. If you received this transmission in error, please 
immediately contact the sender and destroy the material in its entirety, 
whether in electronic or hard copy format. Thank you. A1.



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234902
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: cfajax vs ajaxCFC Question.

[Munson, Jacob]

> For instance,
> ajaxCFC is easier to set up, but the thing I don't like about 
> it is the
> passed parameters are transformed and received as array 
> arguments by the
> CFCs.

This isn't true anymore.  The latest release, 0.66 I believe, does
arguments the same way that cfajax does.

> I would like to hear your advice on 
> what to watch
> out for under each and which one would you recommend if you 
> have worked
> with both.

I have used both, and personally I prefer ajaxCFC mainly because it's a
lot easer to setup.  Also, the last cfajax release I used before jumping
ship didn't work with Apple's Safari.  This may or may not be a concern
for you, but for my site (http://techfeed.net/cfQuickDocs/) that was a
deal breaker.  I don't know if this has been fixed yet (in cfajax), but
I know I mentioned it a few times over a couple of months on the mailing
list, and I never even got a response.  Which brings up the last reason
I like ajaxCFC, there's a lot better support.  Arjun is a great guy, and
he's awesome for having created cfajax and giving it to the community,
but he isn't very good at giving support.  Rob, on the other hand, is
always very responsive and helpful on the ajaxCFC mailing list.


---

This transmission may contain information that is privileged, confidential 
and/or exempt from disclosure under applicable law. If you are not the intended 
recipient, you are hereby notified that any disclosure, copying, distribution, 
or use of the information contained herein (including any reliance thereon) is 
STRICTLY PROHIBITED. If you received this transmission in error, please 
immediately contact the sender and destroy the material in its entirety, 
whether in electronic or hard copy format. Thank you. A1.



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234901
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CFlogin & form action cfc?

[Ian Skinner]

Ok, this was fixed by correcting the applicationtoken parameter.  What does 
this parameter really do?  I've not bothered with it much before, and the docs 
don't say much about it.

Applicationtoken
Optional
The current application name Unique application identifier. Limits the login 
validity to one application, as specified by the cfapplication tag or the 
Application.cfc file.

So what is this doing under the hood?

--
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. 




~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234900
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: CFLOOP in Edit Mode - Invalid CFML construct

[Aaron Rouse]

It is valid XHTML(or maybe it was part of the HTML 4.0 spec), actually all
upper case like that would not be if I remember correctly.  It was more or
less a joke on my part although it would be a good habbit for anyone to be
in.  Especially if they were ever to have to write code for things such as
cell phones.  You are not supposed to have attributes that do not equal
anything just like you are supposed to always have closing tags such as
 and when no closing tag available you end it with a " /" such as




On 3/9/06, Claude Schneegans <[EMAIL PROTECTED]> wrote:
>
> >>Even better  GetCategoriesOutput.categorie_id>selected="selected"
>
> Sorry, I don't see the point here? Is  legal
> in HTML? Even if yes, what is the advantage?
>
> Anyway, the whole loop could be optimized:
> Instead of
>
> 
> 682 :  ISDEFINED ("pre_existing")> "#Edit_Get_Selected_PressRel.pre_cat_id#"> #GetCategoriesOutput.categorie_id#>selected>#cat_name#
> 683 :   
>
> Try
> 
> ISDEFINED ("pre_existing") AND
> listFind(Edit_Get_Selected_PressRel.pre_cat_id, categorie_id)>
> selected>#cat_name#
>
>
>


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234899
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: An Old Article

[S . Isaac Dealey]

> I remember a few years back an article written about when
> to # and when not
> to #

> Just need it for a colleague who has hash's every where

Good old Hash Happy Harry. :)

Hash Happy Harry's happy hashes help him heap hordes of homogenous
horseplay on his helpmates. In hindsight it's a hash hazard.



s. isaac dealey 434.293.6201
new epoch : isn't it time for a change?

add features without fixtures with
the onTap open source framework

http://www.fusiontap.com
http://coldfusion.sys-con.com/author/4806Dealey.htm


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234898
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: OT: Styling form inputs

[Rick Root]

Sandra Clark wrote:
> Easier way
> 
> input[type="text"]{
>   background-color: white;
> }
> 
> input[type="text"]:focus{
>   background-color: yellow;
> } 
> 
> 
> wont work in IE6 but should in IE7
> 
> If you want it to work in IE, then try using a class instead of the type
> selector.

That sucks that it doesn't work in IE6 (I tried it with class 
selectors.. works fabulously in Firefox)

And since I don't have control over users browsers, I guess I'll have to 
try the javascript method.

Rick

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234897
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: CFLOOP in Edit Mode - Invalid CFML construct

[Claude Schneegans]

 >>Even better selected="selected"

Sorry, I don't see the point here? Is  legal
in HTML? Even if yes, what is the advantage?

Anyway, the whole loop could be optimized:
Instead of


682 : selected>#cat_name#
683 :   

Try

 selected>#cat_name#


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


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234896
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: OT: Styling form inputs

[Sandra Clark]

Easier way

input[type="text"]{
background-color: white;
}

input[type="text"]:focus{
background-color: yellow;
} 


wont work in IE6 but should in IE7

If you want it to work in IE, then try using a class instead of the type
selector.

Sandy

-Original Message-
From: Charlie Griefer [mailto:[EMAIL PROTECTED] 
Sent: Thursday, March 09, 2006 12:13 PM
To: CF-Talk
Subject: Re: OT: Styling form inputs




 function doStyle(obj, onoff) {
  if (onoff == "on") {
   obj.style.backgroundColor = "yellow";
  } else {
   obj.style.backgroundColor = "white";
  }
 }


On 3/9/06, Rick Root <[EMAIL PROTECTED]> wrote:
> Is it possible to style text inputs in HTML forms such that they look 
> one way when they have the focus and another way when they don't?
>
> Rick
>
> 



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234895
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: cfajax vs ajaxCFC Question.

[PINE Phyo Z]

I haven't tried CFAJAX, so I don't know the answer to your question. But
may be you might want to have a look at : JSMX
(http://www.lalabird.com/) (or is it too late for you to consider
another API) ?? I found it much easier to set up and use than ajaxCFC.
May be it is just my preference.

Regards,
Pine

-Original Message-
From: Nick Han [mailto:[EMAIL PROTECTED] 
Sent: Thursday, March 09, 2006 10:56 AM
To: CF-Talk
Subject: cfajax vs ajaxCFC Question.


I have used both of these APIs in my test environment.  I think they
both work well.  There are pros and cons in choosing one over the other,
and most of these issues I encountered were minor.  For instance,
ajaxCFC is easier to set up, but the thing I don't like about it is the
passed parameters are transformed and received as array arguments by the
CFCs.  As for CFAJAX it is more work to set up, I like the fact that
arguments are received by functions the way there have been passed by
the calling page.  So you keep variable naming in tact for
self-documenting and easy debugging.  Also with CFAJAX you can't use it
within CFC framework.  So there's a mixed bag of good and bad between
the two.

 

I am about to pick one of these APIs and use it in my production
environment and I want to hear your opinions from those of you who have
used it extensively.  I would like to hear your advice on what to watch
out for under each and which one would you recommend if you have worked
with both.  Thanks.

 

 

 

 





~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234894
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: cfajax vs ajaxCFC Question.

[Bryan Stevenson]

 Also with CFAJAX you can't use it
> within CFC framework.

Huh...perhaps you mean something else, but we use CFAJAX with CFCs just fine.

All I can say is I haven't tried ajaxCFC, but CFAJAX is the bees knees..we love 
it...we don't even post forms anymore!!! ;-)

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 


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234893
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: I still use HomeSite+ 5.5 - Should I "Upgrade" to something else?

[Michael Traher]

I mean CFE does not let you browse to unsaved HTML.
On 3/9/06, Michael Traher <[EMAIL PROTECTED]> wrote:
>
> Oh! I didnt remember HS letting you do that! No I don't think it does let
> you do that, you have to hit ctrl+s :-)
>
> On 3/9/06, Rick Root < [EMAIL PROTECTED]> wrote:
> >
> > Michael Traher wrote:
> > >
> > > Its really no different since in HS+ you had to tell it the path to
> > browse
> > > to for a file - I forget the details now but you dedicated HS'ers will
> > know
> > > what I'm referring to! CFE now lets you browse to the current page in
> > the
> > > browser pane (within the IDE) or opens an external browser window. You
> > can
> > > configure it to use your default browser or Firefox or IE as required.
> >
> > can I browse HTML code that I've typed in without saving it to a file
> > like I can in HS?
> >
> > Rick
> >
> > 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234892
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: I still use HomeSite+ 5.5 - Should I "Upgrade" to something else?

[Michael Traher]

Oh! I didnt remember HS letting you do that! No I don't think it does let
you do that, you have to hit ctrl+s :-)

On 3/9/06, Rick Root <[EMAIL PROTECTED]> wrote:
>
> Michael Traher wrote:
> >
> > Its really no different since in HS+ you had to tell it the path to
> browse
> > to for a file - I forget the details now but you dedicated HS'ers will
> know
> > what I'm referring to! CFE now lets you browse to the current page in
> the
> > browser pane (within the IDE) or opens an external browser window. You
> can
> > configure it to use your default browser or Firefox or IE as required.
>
> can I browse HTML code that I've typed in without saving it to a file
> like I can in HS?
>
> Rick
>
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234891
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: SQL Problem

[Mark Leder]

Thanks everyone.
It worked w/o the ( ) in the select statement. 

Thanks,
Mark

-Original Message-
From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] 
Sent: Thursday, March 09, 2006 1:45 PM
To: CF-Talk
Subject: RE: SQL Problem

> From: Mark Leder [mailto:[EMAIL PROTECTED]

>SELECT TOP 1 (controlID, memberID, memberSubmitDate) FROM tblList WHERE 
>memberSubmitDate ???

SELECT
TOP 1
controlID,
memberID,
memberSubmitDate
FROM
tblList
ORDER BY
memberSubmitDate DESC





~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234890
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

cfajax vs ajaxCFC Question.

[Nick Han]

I have used both of these APIs in my test environment.  I think they
both work well.  There are pros and cons in choosing one over the other,
and most of these issues I encountered were minor.  For instance,
ajaxCFC is easier to set up, but the thing I don't like about it is the
passed parameters are transformed and received as array arguments by the
CFCs.  As for CFAJAX it is more work to set up, I like the fact that
arguments are received by functions the way there have been passed by
the calling page.  So you keep variable naming in tact for
self-documenting and easy debugging.  Also with CFAJAX you can't use it
within CFC framework.  So there's a mixed bag of good and bad between
the two.

 

I am about to pick one of these APIs and use it in my production
environment and I want to hear your opinions from those of you who have
used it extensively.  I would like to hear your advice on what to watch
out for under each and which one would you recommend if you have worked
with both.  Thanks.

 

 

 

 



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234889
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: CFLOOP in Edit Mode - Invalid CFML construct

[Aaron Rouse]

Even better selected="selected"
;)

On 3/9/06, Claude Schneegans <[EMAIL PROTECTED]> wrote:
>
> >>  BAD:  #GetCategoriesOutput.categorie_id#>selected
>
> >>  GOOD:  #GetCategoriesOutput.categorie_id#>selected
>
> BETTER:  GetCategoriesOutput.categorie_id>selected
> :-)
>
> --
> ___
> REUSE CODE! Use custom tags;
> See http://www.contentbox.com/claude/customtags/tagstore.cfm
> (Please send any spam to this address: [EMAIL PROTECTED])
> Thanks.
>
>
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234888
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: I still use HomeSite+ 5.5 - Should I "Upgrade" to something else?

[Rick Root]

Michael Traher wrote:
> 
> Its really no different since in HS+ you had to tell it the path to browse
> to for a file - I forget the details now but you dedicated HS'ers will know
> what I'm referring to! CFE now lets you browse to the current page in the
> browser pane (within the IDE) or opens an external browser window. You can
> configure it to use your default browser or Firefox or IE as required.

can I browse HTML code that I've typed in without saving it to a file 
like I can in HS?

Rick

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234887
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: SQL Problem

[Michael T. Tangorre]

> From: Mark Leder [mailto:[EMAIL PROTECTED] 

>SELECT TOP 1 (controlID, memberID, memberSubmitDate)
>FROM tblList 
>WHERE memberSubmitDate ???

SELECT
TOP 1
controlID,
memberID,
memberSubmitDate
FROM
tblList
ORDER BY
memberSubmitDate DESC



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234886
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: SQL Problem

[Jeff Langevin]

Try this:

SELECT TOP 1 (controlID, memberID, memberSubmitDate)
FROM tblList
ORDER BY memberSubmitDate DESC

--Jeff

On 3/9/2006 1:36 PM, Mark Leder wrote:
> How do I do a single record select only choosing the most recent record
> based on a SQL timestamp (date/time)?  For example, I could have two
> records, one posted 03/09/2006 09:00:00, and another one posted 03/09/2006
> 10:30:06 (I'd want the 10:30:06 one).
>  
> I've tried without luck:
>  SELECT TOP 1 (controlID, memberID, memberSubmitDate)
>  FROM tblList 
>  WHERE memberSubmitDate ???
>  
>  
> Thanks,
> Mark
>  
> 
> 
> 
> 
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234885
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: SQL Problem

[Cornillon, Matthieu \(Consultant\)]

Mark,

I'd try this:

SELECT TOP 1 (controlID, memberID, memberSubmitDate)
FROM tblList 
ORDER BY memberSubmitDate DESC

HTH,
Matthieu

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234884
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: An Old Article

[Aaron Rouse]

I actually forgot that site even existed until this week, I think that is
the second link I have seen to it this week.

On 3/9/06, Bryan Stevenson <[EMAIL PROTECTED]> wrote:
>
> > He should fix that nasty error message on the bottom of that page :)
>
> I said "created" not "still operates" hehe ;-)
>
> 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
>
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234883
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: SQL Problem

[Aaron Rouse]

Could just add an order by membersubmitdate desc and strip out the where
clause.

On 3/9/06, Mark Leder <[EMAIL PROTECTED]> wrote:
>
> How do I do a single record select only choosing the most recent record
> based on a SQL timestamp (date/time)?  For example, I could have two
> records, one posted 03/09/2006 09:00:00, and another one posted 03/09/2006
> 10:30:06 (I'd want the 10:30:06 one).
>
> I've tried without luck:
> SELECT TOP 1 (controlID, memberID, memberSubmitDate)
> FROM tblList
> WHERE memberSubmitDate ???
>
>
> Thanks,
> Mark
>
>
>
>
>
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234882
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54