zohaib khan

Greenhorn
+ Follow
since Apr 13, 2009
Merit badge: grant badges
For More
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by zohaib khan

Hi,

I am using Oracle Database.My images are stored in database in ORD Image format.

ORD Image = > http://docs.oracle.com/cd/E11882_01/appdev.112/e10776/ch_imgref.htm

I am fetching image and displaying in JSP.

I want to resize image stored in database.

Any solution guys?





- Thanks
Zohaib.
11 years ago
Hi,

I am able to limit resultset in pagination using mysql but in oracle rownum is not working as expected.

For mysql

SELECT * FROM TABLENAME WHERE TYPE=1 LIMIT 0,5
SELECT * FROM TABLENAME WHERE TYPE=1 LIMIT 5,10
SELECT * FROM TABLENAME WHERE TYPE=1 LIMIT 10,15

For Oracle (Not working)

SELECT * FROM TABLENAME WHERE TYPE=1 AND ROWNUM > 0 AND ROWNUM < 5
SELECT * FROM TABLENAME WHERE TYPE=1 AND ROWNUM > 5 AND ROWNUM < 10
SELECT * FROM TABLENAME WHERE TYPE=1 AND ROWNUM > 10 AND ROWNUM < 15


Any idea?

- Thanks
Zohaib.
Hi,

I am developing pagination in JSP.

I want to get number of records return by query.

In PHP we have function mysql_num_rows which give count of rows return by query.

Any idea how to get number of rows in JSP.



- Thanks
Zohaib.
Hi,

I have used NLog in .Net application and feature to send email to administrator when exception occurs in application.

I have JSP and Oracle application. I am looking for Advanced logging tool to send email to administrator when exception occurs in application.

I found Log4j (http://en.wikipedia.org/wiki/Log4j) but no idea how to make it working with JSP and oracle application to send exception message in email to administrator?

- Thanks
Zohaib.
11 years ago
JSP
Thanks Stefan Evans and other people for reply and support.

I do not write SQL in JSP.I write package and stored procedure in oracle database.

For forum example I have written sql in jsp.

I have 2 solutions [1]. JQWidget jqxMenu built from JSON data [2]. Jquery-mega-drop-down-menu.1.3.3.

Solution [2]. Mega menu. Do not offer JSON solution.

I like JSON solution and it is faster and modular.

However I am using both solutions.

I am able create JSON data from database from single query and working fine.

I will create required dynamic HTML using Stefan single query.

Thanks once again.

Zohaib.
11 years ago
JSP
Hi Shamsa Al Neyadi,


You can use FOR loop to iterate over array list




- Thanks
Zohaib.
11 years ago
JSP
Hi,

I am developing HTML dynamically using looping over result set 2 times and using 2 sql query.

I want to get the same result using 1 sql query or any other way like using arraylist etc

Following is the sql and jsp code.







Any idea how to achieve this?

- Thanks
Zohaib.
11 years ago
JSP
Thanks guys for reply and support.

Vishal img tag did not give expected result as it show image on same page instead of pop up.

I got it working using frames.

- Thanks
Zohaib.
11 years ago
JSP
Hi,

Thanks for reply.

Sorry I can not use servlet for some xyz reasons.

JQuery ColorBox plugin http://www.jacklmoore.com/colorbox/example1/ show images gallery.

Example 1 - No Transition + fixed width and height (75% of screen size)

Images are stored on images folder on file system and location specified in href.

I my case images are in oracle database and JSP page display image fetching from database.

But when I call jsp from href then it is not working with like file system image gallery.


- Thanks
Zohaib.
11 years ago
JSP
Hi,

I am developing image gallery from images stored in oracle database.

I am using JQuery ColorBox plugin (http://www.jacklmoore.com/colorbox/example1/) and I need to specify image in href for plugin.

My JSP page (http://localhost:8080/gallery/show_image.jsp?id=1) fetch image from database and show.

I can see image in browser when I run url http://localhost:8080/gallery/show_image.jsp?id=1.

But following not working when JSP page specify in href.



Any solution?

- Thanks
Zohaib.
11 years ago
JSP
Hi,

I want to generate following JSON data dynamically using JSP and database.

following is the table and json structure data.



Any Solution?


- Thanks
Zohaib.
11 years ago
JSP
Hi

Thanks for reply.

May I get simple example of JSON structure data to send from server side jsp and read data in ajax response.


- Thanks
Zohaib.
Hi,

I am able use single string return from ajax response and I need help in using multiple string.

following is the code.

index.jsp



getDetails.jsp




I want to assign values return for No and Name from ajax to respective textfield.

any solution?

- Thanks
Zohaib.
Hi,

I am using Jforum in my project. I will be using JForum in Arabic language.

I have change forum direction from Right to Left and new language properties file for Arabic.

Now When I post topic in forum Arabic text is not coming but french,portogese,italian etc text working.

I am getting??? For Arabic text.

When I add text from database then it is displayed properly in UI but when added from UI then getting ??? characters.

I want to add arabic language support in Jforum like other languages French,German,Italian etc

Any solution for this problem?

-Thanks
Zohaib.
11 years ago