Carlos Juan

Hi,

I have an application that shows the data based on the search criteria, shows 10 records a time. I have a table with 1000+ records. When I run the following select it returns me the 1st 10

SELECT column FROM table WHERE ROWNUM BETWEEN 1 AND 10

Now if I run the following it does not return me any data

SELECT column FROM table WHERE ROWNUM BETWEEN 11 AND 20

Any help is appreciated. Thanks

Thanks, It's working just did some testing and so far all ok, It works in IE but some how FireFox it does not work. I don't know if it's because of the following or am I missing something else:
if(window.XMLHttpRequest) { obj = new XMLHttpRequest(); } else if(window.ActiveXObject) { obj = new ActiveXObject("MSXML2.XMLHTTP"); }

Here is the javascript change I made.

var str; function valCheck(url) { //url is servlet that inturn query a database a returns a value request = createRequestObject(); request.onreadystatechange = onResponse; request.open("POST", url, false); request.send(url); if(str == "PASS") return true; else return false; } function createRequestObject() { if(window.XMLHttpRequest) { obj = new XMLHttpRequest(); } else if(window.ActiveXObject) { obj = new ActiveXObject("MSXML2.XMLHTTP"); } return obj; } function checkReadyState(obj) { if(obj.readyState == 4) { if(obj.status == 200) { return true; } else { alert("HTTP " + obj.status); } } } function onResponse() { if(checkReadyState(request)) { var response = request.responseText; if(response == "PASS") { temp = window.confirm('Are you sure?'); if(temp) { str = "PASS"; return true; } else { str = "FAIL"; return false; } } else { alert("Invalid value can not submit"); str = "FAIL"; return false; } } }

Is there anything else I have to do to make it work in FireFox/Netscape. Any help is appreciated.

Thanks

Hi,

I have a form and onsubmit calling a javascript function to make sure some value does exists in database. If the value exists I
am submitting a form but if the value does not exists I don't want to submit a form rather show user a message. I am trying to use
AJAX, it does go to the databse and checks for the required value but whatever the value is it still keeps submiting the form. Can someone please
help me what am I doing wrong here. Here is my code:

In my JSP I have the following piece:
................. ................. out.println("<FORM METHOD=\"POST\" onSubmit=\"return valCheck(this.'" + fullUrlValue + "')\" ACTION=\"Complete?" + field1 + "=" field2 + "\">"); out.println("<INPUT VALUE=\"" + BUTTONVAL + "\" TYPE=\"SUBMIT\">");

Here is javascript:
function valCheck(url) { //url is servlet that inturn query a database a returns a value request = createRequestObject(); request.onreadystatechange = onResponse; request.open("POST", url, false); request.send(url); } function createRequestObject() { if(window.XMLHttpRequest) { obj = new XMLHttpRequest(); } else if(window.ActiveXObject) { obj = new ActiveXObject("MSXML2.XMLHTTP"); } return obj; } function checkReadyState(obj) { if(obj.readyState == 4) { if(obj.status == 200) { return true; } else { alert("HTTP " + obj.status); } } } function onResponse() { if(checkReadyState(request)) { var response = request.responseText; if(response == "PASS") { temp = window.confirm('Are you sure?'); if(temp) { return true; } else { return false; } } else { alert("Invalid value can not submit"); return false; } } }

In onResponse function above no matter if it returns true or false the FORM keeps on submitting. Any help is appreciated.
Thanks

I figured out the root cause it's not the hibernate. I am using JAXB and any time I get a value starting with leading zero's i.e. 00785 as I have defined nonNegativeInteger in my xsd. As can't change the xsd so probably will explicitly check if the returned value is of some specific length if not then append the leading zero's, or if someone have a better solution will be more then happy to look at. Thanks

I am using Oracle as backend database. Here is a issue I am facing and need some help.


I have a database table with datatype VARCHAR2(25)

In my hbm.xml I have the following:
................ .......... <property name="phnum" type="string"> <column name="NOPH" length="22"> </property> ........... ................

Now if I have a value 00875. When a data is saved leading zero's are some how trimmed off and only 875 is saved in the table.
How can I make to insert 00875 without trimming off any leading or trailing zero's. Any help is appreciated.

Thanks