Manning's Countdown to 2014
. Use discount code crdotd14 all month for 50% off every deal.
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
It is sorta covered in the
JavaRanch Style Guide
subject: java code inside sql functions?
stuck up in the problem
'Syntax Error in Query operator' MS Access
Doubt Regarding PreparedStatement
Hibernate not deleting rows
HibernateException while using native sql query
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2013