A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
JDBC and Relational Databases
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
[OCA 8 Book]
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?
stuck up in the problem
Doubt Regarding PreparedStatement
HibernateException while using native sql query
'Syntax Error in Query operator' MS Access
Hibernate not deleting rows
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015