Stored procedures

Scheduler Javascript
#1

Hi,
Is it possible to execute stored procedures inside render_sql method? Is it possible to use ORDER BY in render_sql method for query? if I use ORDER BY i am getting ArrayIndexOutOfBoundsException. Do you know why?

Regards,
Karthick K.

#2

hi,
Is printing service of scheduler is available for java version? If available, kindly send me the updated package. I did see printing service of scheduler in php. Expecting your reply soon.

Thanks,
Karthick K.

#3

Is printing service of scheduler is available for java version?
Nope, there is only php version.
But you can use java backend for all operations and separate php installation for printing.
Printing service doesn’t need any access to data or resources, so it can work in parallel with any other back-end.

#4

Is it possible to execute stored procedures inside render_sql method
There is no special support, you can use any sql commands inside render_sql, while they are can be processed as valid “SELECT” operation.

Is it possible to use ORDER BY in render_sql method for query
Can you provide a sample of sql query which causes such result.

#5

Hi,
This is the query which caused ArrayIndexOutOfBoundException,
leadName.render_sql(“select username as label, userid as value from users ORDER BY username”, “userid”, “username(label),userid(value)”)

How to disable enter key for saving an event? and how to enable just the enter key instead of shift+enter inside textarea to go to the next line ?

Thanks,
Karthick K.