Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
Arduino in Action
this week in the
A special promo:
Enter your blog post or vote on a blogger to be featured in an upcoming Journal
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
HibernateException while using native sql query
Doubt Regarding PreparedStatement
stuck up in the problem
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2013