Home » Developer & Programmer » Application Express & MOD_PLSQL » Validation problem (apex 4.0.2)
Validation problem [message #535822] Fri, 16 December 2011 08:36 Go to next message
balckbandit5
Messages: 104
Registered: December 2011
Senior Member
Hello Smile,

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
Re: Validation problem [message #535834 is a reply to message #535822] Fri, 16 December 2011 09:12 Go to previous messageGo to next message
c_stenersen
Messages: 254
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.
Re: Validation problem [message #535844 is a reply to message #535834] Fri, 16 December 2011 10:23 Go to previous messageGo to next message
balckbandit5
Messages: 104
Registered: December 2011
Senior Member
Perfect thanks Smile
Re: Validation problem [message #535847 is a reply to message #535844] Fri, 16 December 2011 10:32 Go to previous message
Littlefoot
Messages: 19635
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Or even
... where instr(:YOUR_ITEM, 'GVA airport') = 0
Previous Topic: Web service implementaion help
Next Topic: Calling report from a form/report
Goto Forum:
  


Current Time: Mon Sep 22 15:32:25 CDT 2014

Total time taken to generate the page: 0.10155 seconds