cancel
Showing results for 
Search instead for 
Did you mean: 

How can we return error return by sql Query in javascript function.

Former Member
0 Kudos

HI ,

I am executing one update query in my javascript function by using the following code but If that query execution fails how can I return the database error.

var url="http://192.168.128.41:50700/XMII/CM/MIIDemoHome/Bikshu/Mobile_DemoOrder_Confirm/ProposedQuantity_b.irpt";// It contains Query and xslt file.

url=url"?ConfNum="ConfNum"&""Yield="+Yield;

var div="GTable";

loadXMLDoc(url,div);// where Qery will be executed and returns the results in to xslt table.

Please help me in this issue.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Bhikshu

Modify your xslt accordingly.

Like in xslt you are creating html td and tr on Rowsets/Rowset/Row.

In the case of query error it will return Rowsets/FatalError.

Update xslt to catch this error on html table or hidden variable.

After load you can use this value to alert in javascript.

Regards

Anshul

Answers (0)