Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

SQL phone number format check

504552Aug 16 2010 — edited Aug 16 2010
Hello, I am looking for a programmatic way to check phone number formats in my database using SQL. The phone numbers MUST be one of 2 formats:

XXX-XXX-XXXX or (XXX)XXX-XXXX

I want to return the row if they are NOT one of these formats.

Thank you!

Comments

843844
bjohnnj wrote:
<a4j:support event="onchange" action="#{PosterCreator.getScreenShot_ShortName()}" reRender="Poster_form" ajaxSingle="true"/>
The action shouldn't have "()". Plus I would try using another name for the action, not starting from "get" or "set". I think JSF may get confused (just a guess).

Do you get any JavaScript errors from IE when you run this?
You can use the <a4j:log /> tag to debug ajax requests.
843844
Hey Stef,

thanks for reply... Actually this is my first a4j page which I am developing. I have tried tips u had given, But still It works fine on fire fox..but totally response less on the IE. It is just not calling server from any of the a4j tags, I am using it in 3 pages across the project.. I guess... is there some thing crucial out side this method, which has to be included on the HTML or .java file to invoke server form a4j......

thanks once again.

Regards
Bejoy
1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 13 2010
Added on Aug 16 2010
6 comments
6,740 views