Hi,
I have a textbox wherein multiple Id's of 4 digits(alphanumeric) can be entered separated by commas and I can enter rep id and rep id(say ABCD,BCD1) or mgr id and mgr id(say CDE1,PQRS) at any point in time and it shouldn't throw an error for this.
If I enter an emp id and a mgr id at the same time in the textbox(say ABCD is a emp id,CDE1 is a mgr id),then it should throw an error(display an alert box) saying that it is an invalid entry.Both the emp id and the mgr id are being fetched from the same
Iam using this query below and if the count is greater than 1, then I need to show an alert message through the [front end(HTML Page) when the user enters the emp id and the mgr id in the textbox at the same time ] saying that it is an invalid entry through an alert box or something.

ENGINE oracle SET DEFAULT_CONNECTION instance1
SQL SQLORA PREPARE SQLOUT FOR
select COUNT(*) from (select distinct title,type from table1
where id in ('ABCD','BCD1','CDE1')and title is not null );
END

Could anyone please help me to do this in Javscriptor/ajax.
Any help is highly appreciated.Thanks a lot in advance!

Regards!

This message has been edited. Last edited by: info4pal,

You can simply chain your textbox control to a hidden field that runs a procedure.

Then in Javascript you call a function in onInitialUpdate() or in an onchange event handler on the hidden field. That function then checks whether your hidden field contains a value - if so, show an error, if not, stay silent.

Hi,

Thanks for the reply.
Any sample code using CAR file would be really helpful.

Thanks a lot in advance!

Hi,

I will be actually entering the ID's in the textbox and the textbox will contain the values entered at any point in time.

Hope Iam clear now.

Thanks!

I just found that your question has already been answered in a related thread. Why did you start a new one?

Hi,

Wep5622 - By mistake the question has got duplicated.

Thanks!