File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
java code inside sql functions?
Joined: Jun 19, 2007
Nov 25, 2008 11:03:00
I am running a sql query which uses some sql functions like date_add() or max()
Query is something like : delete from <tablename> where date=date_add(<date>,interval <expression>
I wish to write the above query in
The problem is i am not able to pass the parameters to the sql functions in java code.
"delete from student where date=date_add("+date_variable+","+parameter_@+")"
How can this be done.
Joined: Oct 23, 2005
Nov 25, 2008 16:22:00
Can you post your java code? It's hard to know what you're doing wrong without see the
Down Home Country Coding with Scott Selikoff
Joined: Oct 11, 2000
Nov 25, 2008 22:20:00
The usual way to achieve your aim is to use a
I agree. Here's the link:
subject: java code inside sql functions?
'Syntax Error in Query operator' MS Access
Hibernate not deleting rows
stuck up in the problem
HibernateException while using native sql query
Doubt Regarding PreparedStatement
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014