Sue, Have you considered using your RDBMS to perform the qualification?
For intricate validations I frequently find it's easier to create a user defined function in your database, then run a Set Fields SQL command in ARS to perform the validation. You can then call your function many times throughout your ARS application without additional validation programming. Here is a SQL Server function that returns the number of gigabytes if the number passed is between 1 and 1000 (change the range to match your requirements). CREATE FUNCTION [dbo].[udf_ValidateRequestedDiskspace] ( @Diskspace VARCHAR(20) ) RETURNS INT AS BEGIN IF @Diskspace = NULL OR ISNUMERIC(@Diskspace) = 0 RETURN NULL DECLARE @Tmp BIGINT SET @Tmp = CONVERT(INT,ROUND(CONVERT(FLOAT,@Diskspace),0)) IF @Tmp <= 0 OR @Tmp > 1000 RETURN NULL RETURN CONVERT(INT,@Tmp) END In workflow: Set Fields, SQL, SELECT dbo.udf_ValidateRequestedDiskspace('$Requested storage amount in GB: $'). The next Filter would then check your field for $NULL $. If null, then display a message to the user. Stephen -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rabi Tripathi Sent: Friday, March 30, 2007 4:00 PM To: arslist@ARSLIST.ORG Subject: Re: Validate field data - allowing some to be NULL 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: arslist@ARSLIST.ORG > 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: arslist@ARSLIST.ORG > > 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"