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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Form Field Validation - No Spaces
cfif Len(Trim(Form.Field1)) ...contains data cfelse ... spaces only /cfif 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=listsbody=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=listsbody=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. cfif #Trim(Form.FormName)# is NOT "" code ... /cfif 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=listsbody=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=listsbody=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 cfif Len(Trim(Form.Field1)) ...contains data cfelse ... spaces only /cfif 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=listsbody=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=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Form Field Validation - No Spaces
Dick Applebaum wrote: cfif Len(Trim(Form.Field1)) ...contains data cfelse ... spaces only /cfif 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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.