Re: Form Field Validation - No Spaces
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
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
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
...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.