OraFAQ Forum: Application Express & MOD_PLSQL

Home » Developer & Programmer » Application Express & MOD_PLSQL » Validation problem (apex 4.0.2)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Validation problem [message #535822]

Fri, 16 December 2011 08:36

balckbandit5
Messages: 104
Registered: December 2011

Senior Member

Hello

,

I'm having a bit of trouble with a validation. Its weird, I could have sworn i've done this for another one and it was fine...although thinking about it I think that may have been a condition.
Anyway, I want the validation to make sure ITEM_A does not contain the words "GVA airport". So I set the validation as 'Item in Expression 1 is NOT contained in Expression 2' (the wording of which seemed weird to me in the first place) Expression 1: ITEM_A, Expression 2: GVA airport. Now if you put "GVA airport" in, it stops it but it doesn't stop "GVA airport asdf" or even "GVA airport " (theres a space after).
Is there a way to do this?
thanks Smile

Report message to a moderator

Re: Validation problem [message #535834 is a reply to message #535822]

Fri, 16 December 2011 09:12

c_stenersen
Messages: 253
Registered: August 2007

Senior Member

This doesn't work in that way. It's really more intended for comma separated lists, so that you can say that the value should not be either a,b,c or d for instance.
You can do it with an SQL expression validation though. Then you can just use the like operator.

Report message to a moderator

Re: Validation problem [message #535844 is a reply to message #535834]

Fri, 16 December 2011 10:23

balckbandit5
Messages: 104
Registered: December 2011

Senior Member

Perfect thanks Smile

Report message to a moderator

Re: Validation problem [message #535847 is a reply to message #535844]

Fri, 16 December 2011 10:32

Littlefoot
Messages: 16998
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Or even

... where instr(:YOUR_ITEM, 'GVA airport') = 0

Report message to a moderator

Previous Topic:	Web service implementaion help
Next Topic:	Calling report from a form/report

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 25 15:57:38 CDT 2013

Total time taken to generate the page: 0.76532 seconds