Great, that is really the better way to go.
Larry
On 12/8/05, Michael Laccetti [c] <[EMAIL PROTECTED]> wrote:
> Yeah, I just saw Eric's suggestion. That looks pretty good, I'm going to
> switch it to that tomorrow.
arry means iterating your list, that would still result in one query, but
one that works and still protects against SQL injection.
Niels
-Original Message-
From: Michael Laccetti [c] [mailto:[EMAIL PROTECTED]
Sent: donderdag 8 december 2005 23:12
To: user-java@ibatis.apache.org
Subject: RE: Multip
: RE: Multiple deletes? [signed]
If I used iteration, I'd have a lot of queries. Since this database can
scale to be pretty huge, I'd prefer to not do that.
Also, the information isn't blindly pulled from a form, and then jammed
into
the database. Validation does happen.
And it
If I used iteration, I'd have a lot of queries. Since this database can
scale to be pretty huge, I'd prefer to not do that.
Also, the information isn't blindly pulled from a form, and then jammed into
the database. Validation does happen.
And it worked. Thanks kindly. :)
-Original Messa
alid
character string format for type INTEGER".Vijai- Original Message -From: "Michael Laccetti [c]" <[EMAIL PROTECTED]>
To: <user-java@ibatis.apache.org>Sent: Thursday, December 08, 2005 12:13 PMSubject: Multiple deletes? [signed]>I have the following statement d
parameter type as String, u r getting the error "Invalid
character string format for type INTEGER".
Vijai
- Original Message -
From: "Michael Laccetti [c]" <[EMAIL PROTECTED]>
To:
Sent: Thursday, December 08, 2005 12:13 PM
Subject: Multiple deletes? [signe
You could do this:
DELETE FROM ALERTS WHERE ID IN ($value$)
It is beggin for SQL injection, but...it will work.
A better route would be to use iteration to do it.
Larry
On 12/8/05, Michael Laccetti [c] <[EMAIL PROTECTED]> wrote:
> I have the following statement defined in iBATIS:
>
>
> DEL
I have the following statement defined in iBATIS:
DELETE FROM ALERTS WHERE ID IN (#value#)
I pass it a String in the form of 322,321,320,319,318,317,316,315,314,313.
Now, when I call it, I get the following:
DEBUG [08 Dec 05 11:19:26] [http-8080-Processor23]
java.sql.PreparedStatement - {pst