Re: Form Field Validation - No Spaces

2000-05-25 Thread Andrew C. Davis

Dick Applebaum wrote:
> 
> 
>...contains data
> 
>... spaces only
> 
> 

Thanks Dick!

Andrew C. Davis ([EMAIL PROTECTED])
TAMMIS Website Administrator / Systems Administrator
Metrica, Inc. * San Antonio, TX
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: Form Field Validation - No Spaces

2000-05-25 Thread Randy Adkins

Here is a question for people who have knowledge in Storedprocedures
and SQL 7.0 backing.

I am using CFSTOREDPROC and passing my variables into it without a problem.
My Stored Proc in SQL is using the Order by clause.

This does not work.. Any idea on another solution?
I have used the query analyzer and it stated Order By is not support by SQL.

What gives?


- Original Message -
From: "Dick Applebaum" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 25, 2000 9:26 AM
Subject: Re: Form Field Validation - No Spaces


> 
>...contains data
> 
>... spaces only
> 
>
>
> At 8:13 AM -0500 5/25/2000, Andrew C. Davis wrote:
> >I have a form that has fields that, when validated, allow the user to
> >enter "spaces".  I want to be able to check for fields that contain only
> >spaces and then inform the user that they must enter text.  How do I do
> >this?
> >
> >Andrew C. Davis ([EMAIL PROTECTED])
> >TAMMIS Website Administrator / Systems Administrator
> >Metrica, Inc. * San Antonio, TX
>
>---
---
> >Archives: http://www.eGroups.com/list/cf-talk
> >To Unsubscribe visit
> >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_tal
> >k or send a message to [EMAIL PROTECTED] with
> >'unsubscribe' in the body.
>
> --

> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Form Field Validation - No Spaces

2000-05-25 Thread Henry, David B

Andy,

It is possible to remove this complexity from the users by using a cfif
along with the trim function.


code ...


This This would strip all of the spaces out from the beginning and end of
the form field string.  

If this is not what you are looking for, let me know.  I hope this helps.


David Henry
HPER Technology Services
School of Health, Physical Education and Recreation
Indiana University 
(812)855-4270
[EMAIL PROTECTED]


-Original Message-
From: Andrew C. Davis [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 25, 2000 8:14 AM
To: Cold Fusion List
Subject: Form Field Validation - No Spaces


I have a form that has fields that, when validated, allow the user to
enter "spaces".  I want to be able to check for fields that contain only
spaces and then inform the user that they must enter text.  How do I do
this?

Andrew C. Davis ([EMAIL PROTECTED])
TAMMIS Website Administrator / Systems Administrator
Metrica, Inc. * San Antonio, TX

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: Form Field Validation - No Spaces

2000-05-25 Thread Dick Applebaum


   ...contains data

   ... spaces only



At 8:13 AM -0500 5/25/2000, Andrew C. Davis wrote:
>I have a form that has fields that, when validated, allow the user to
>enter "spaces".  I want to be able to check for fields that contain only
>spaces and then inform the user that they must enter text.  How do I do
>this?
>
>Andrew C. Davis ([EMAIL PROTECTED])
>TAMMIS Website Administrator / Systems Administrator
>Metrica, Inc. * San Antonio, TX
>--
>Archives: http://www.eGroups.com/list/cf-talk
>To Unsubscribe visit 
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_tal 
>k or send a message to [EMAIL PROTECTED] with 
>'unsubscribe' in the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.