Prepared statement with ' problem
From: Antonio (etantonio_at_libero.it)
Date: 01/16/04
- Next message: Markku Salminen: "Re: Please help ,I dont know what is the problem in my code?"
- Previous message: Andy: "Cleint Server Help (beans)"
- Next in thread: Scorpio: "Re: Prepared statement with ' problem"
- Reply: Scorpio: "Re: Prepared statement with ' problem"
- Reply: Joe Weinstein: "Re: Prepared statement with ' problem"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: 16 Jan 2004 08:08:10 -0800
Good Morning,
I've this prepared statement
PreparedStatement pstm =
" select domicilio from anagrafe where id_struttura IN (?) "
pstm.setString(1, " '60' , '12' , '85' , '45' ");
it seems that the ' in the string inserted like a parameter is a problem
how can I solve this ?? I've a variable number of values inside the IN.
Thanks
Antonio D'Ottavio
- Next message: Markku Salminen: "Re: Please help ,I dont know what is the problem in my code?"
- Previous message: Andy: "Cleint Server Help (beans)"
- Next in thread: Scorpio: "Re: Prepared statement with ' problem"
- Reply: Scorpio: "Re: Prepared statement with ' problem"
- Reply: Joe Weinstein: "Re: Prepared statement with ' problem"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]