On Tue, 27 Aug 2002 13:54:25 -0500 Dan Muey <[EMAIL PROTECTED]> wrote:
>
>
> >1) is the id field a character? in other words, do you need the
> >quotes? id='10' ??
> It is -> ID INT(11) NOT NULL AUTO_INCREMENT and -> PRIMARY KEY(ID)
>
> >2) why not just use
>
> >DELETE FROM customer WHERE ID in ('7','8','9','10')
>
> >??
> >...I'll try that...
>
> I tried the above method and same thing. It would only delete record '7'
> I tried the above and the old with out the single quotes and then it
> wouldn't do anything except die.
Add $dbh -> trace( 4, "file" ); before the do() to see what DBI thinks is
happening.
--
Mac :})
** I normally forward private questions to the appropriate mail list. **
Ask Smarter: http://www.tuxedo.org/~esr/faqs/smart-questions.html
Give a hobbit a fish and he eats fish for a day.
Give a hobbit a ring and he eats fish for an age.
