It's based on the ExtJS live search sample.
We were running it with Ext version 1.1, but had issues with paging. By default it uses "start" and "limit" as parameters - both reserved words with PL/SQL.
If you search the Ext forums, you'll find a solution for Ext 2.0 - just search for mark.lancaster.
Thursday, February 14, 2008
ExtJS Ajax Search field
Here is a screenshot of an AJAX search field running in Apex.
Putting an example up on the Oracle Apex demo site may not be possible, as I call a PL/SQL package directly.
It's based on the ExtJS live search sample.
We were running it with Ext version 1.1, but had issues with paging. By default it uses "start" and "limit" as parameters - both reserved words with PL/SQL.
If you search the Ext forums, you'll find a solution for Ext 2.0 - just search for mark.lancaster.
It's based on the ExtJS live search sample.
We were running it with Ext version 1.1, but had issues with paging. By default it uses "start" and "limit" as parameters - both reserved words with PL/SQL.
If you search the Ext forums, you'll find a solution for Ext 2.0 - just search for mark.lancaster.
Subscribe to:
Post Comments (Atom)
9 comments:
Mark,
there should be no problem to create a package/procedure on apex.oracle.com. Just grant it to apex_public_user or public as you would normally do.
Patrick
BTW, this posting has no title... :-)
Hi Patrick
Thanks for the tip on packages, I'll try it out soon.
Sometimes I make assumptions without investigating first :)
Nice work.
I tried to test the same on my apex page. But I am getting some error message "invalid label".
I have used same procedure that u mentioned. Below I have pasted the json data ( pl/sql procedure output)
{"totalRows":4,"rowset":[ {"id":"1", "customer":"Test","address":"Manama","locality":"Test","email":"Test@gmail.com"}, {"id":"2", "customer":"Test Hi","address":"Manama","locality":"Test","email":"Test@gmail.com"}, {"id":"3", "customer":"Test and Test","address":"Manama","locality":"Test","email":"Test@gmail.com"} ] }
I found the problem.
Once again thx
hi Satheesh Kumar
i have the same result plsql
but have an error invalid label
{"totalRows":1,
"rowset":[
{"ind":"164",
"nom":"amel",
"prenom":"",
"adress":"aaaaaaaaaa"}
] }
can you help me please
i resolved the probleme
you should beginning the return data json with(stccallback)exactelly we should create in pl/sql:
"htp.p(p_callback||('({"totalRows":..)"
so the p_callback is the parameter of procedure (customer_lookup)
Good luck for evry when , i hope that help yuo
thank you very much for this post Marck_Lancaster
you are the baest.....
regerd anonymous
Hi,
I am still trying to get this working, but I think I am having problems with getting the SQL procedure correct.
My Javascript seems to be almost identical to Mark's demo app.
Is there any chance an example of the PL/SQL procedure could be posted? I think my issues may lie around the callback, but not 100% sure!
I look forward to your responses.
Kindest Regards,
Cj
Post a Comment