Strange. Make sure you have the "^" in the qual. --- "Barber, Sue" <[EMAIL PROTECTED]> wrote:
> This is still allowing me to enter text into the > field as well as > numbers. It is getting closer though - I will post > whatever Remedy > tells me when I hear back. Thanks for the help. > > Sue > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Rabi > Tripathi > Sent: Friday, March 30, 2007 12:33 PM > To: [email protected] > Subject: Re: Validate field data - allowing some to > be NULL > > Sue: > I am not sure why you gave up on the character > field. > > Did you try the qualification I sent? Using that or > a > variaion of it, you can keep the character field and > be in complete control of the type of message the > user > gets. > > Here's a refined scheme: > First do the following Set Field... > RTRIM( LTRIM( 'Requested storage amount in GB: ')) > > ...on field 'Requested storage amount in GB: ' to > remove leading and trailing blank characters and > then > use the qualification: > > ( 'Requested storage amount in GB: ' LIKE > "*[^.0-9]*" ) > OR ( 'Requested storage amount in GB: ' LIKE > "*.*.*" > ) > OR ( 'Requested storage amount in GB: ' = "." ) > on a filter to throw the error. > > If the field won't be used in a numeric calculation, > there is no harm in keeping it as a character field. > > --- "Barber, Sue" <[EMAIL PROTECTED]> wrote: > > > I think I will have to go with changing the field > - > > I still have to > > throw an error though - they don't want the system > > message. I was > > hoping not to change the field as this is already > in > > use. > > > > Thanks, Sue > > > > -----Original Message----- > > From: Action Request System discussion > list(ARSList) > > [mailto:[EMAIL PROTECTED] On Behalf Of Rabi > > Tripathi > > Sent: Friday, March 30, 2007 11:04 AM > > To: [email protected] > > Subject: Re: Validate field data - allowing some > to > > be NULL > > > > If you insist on keeaping the character field, > try: > > ( 'Requested storage amount in GB: ' LIKE > > "*[^.0-9]*" > > ) OR ( 'Requested storage amount in GB: ' LIKE > > "*.*.*" )...then throw error > > > > You can play around and make it smarter by > allowing > > leading or trailing spaces, disallowing "." etc. > > > > -Rabi Tripathi > > > > --- "Barber, Sue" <[EMAIL PROTECTED]> wrote: > > > > > Hi all, > > > > > > > > > > > > I have a question for you on validating field > > data. > > > I did search the > > > archives and it isn't allowing me to open the > > notes > > > - says file not > > > found, sooo... > > > > > > > > > > > > I have a form that people can use to request > > > additional network space > > > with and the field in question is for them to > > enter > > > the amount of space > > > in GB that they want. I originally had the > field > > > limited with $DIGIT$, > > > but when they made a mistake the entire form was > > > being reset. They > > > decided they would like a message to be used > > > instead, so I have created > > > a filter that verifies the field as such: > > > > > > > > > > > > ( 'Requested storage amount in GB: ' != $NULL$ ) > > > > AND ( NOT ( > > > 'Requested storage amount in GB: ' LIKE > > > "[.0-9][.0-9][.0-9] > > > [.0-9][.0-9]")) > > > > > > > > > > > > However, I don't want to force them to enter a > > > number into all 5 > > > spaces, so I need to allow 4 of these to be > NULL. > > > Anyone know if there > > > is a way to do that? They want to be able to > > enter > > > numbers or > > > decimals - like 2 or 2.5. > > > > > > > > > > > > Thanks, Sue > > > > > > > > > > > > ARS 6.3 - patch 20 > > > > > > Solaris > > > > > > Help Desk 6 > > > > > > > > > > > > > > > > > > _______________________________________________________________________ > > ________ > > > UNSUBSCRIBE or access ARSlist Archives at > > > www.arslist.org ARSlist:"Where the Answers Are" > > > > > > > > > > > > > > _______________________________________________________________________ > > _____________ > > Expecting? Get great news right away with email > > Auto-Check. > > Try the Yahoo! Mail Beta. > > > http://advision.webevents.yahoo.com/mailbeta/newmail_tools.html > > > > > > > _______________________________________________________________________ > > ________ > > UNSUBSCRIBE or access ARSlist Archives at > > www.arslist.org > > ARSlist:"Where the Answers Are" > > > > > _______________________________________________________________________ > ________ > > UNSUBSCRIBE or access ARSlist Archives at > > www.arslist.org ARSlist:"Where the Answers Are" > > > > > > > _______________________________________________________________________ > _____________ > Looking for earth-friendly autos? > Browse Top Cars by "Green Rating" at Yahoo! Autos' > Green Center. > http://autos.yahoo.com/green_center/ > > _______________________________________________________________________ > ________ > UNSUBSCRIBE or access ARSlist Archives at > www.arslist.org > ARSlist:"Where the Answers Are" > === message truncated === ____________________________________________________________________________________ The fish are biting. Get more visitors on your site using Yahoo! Search Marketing. http://searchmarketing.yahoo.com/arp/sponsoredsearch_v2.php _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
