insert Apostrophe in MS Access
[237 byte] By [Daiesha] at [2007-11-27 9:49:27] 
Hai,How can i insert Apostrophe character in Ms-access dadabase?insert into student values('name','good' boy);when i execute this i got error?. How do make the query to run Apostrophe.advance wishes
1. You escape the character by doubling it:'don''t prefer this way'2. Use PreparedStatement. It takes care of this and much more automagically.
BigDaddyLoveHandlesa at 2007-7-13 0:17:58 >
it's working :)thanks.
Daiesha at 2007-7-13 0:17:58 >
I hope you chose well.
BigDaddyLoveHandlesa at 2007-7-13 0:17:58 >
Java Essentials New Topic
Java Essentials Hot Topic
Java Essentials
All Classified
- Archived Forums
- Enterprise & Remote Computing
- Java Essentials
- Desktop
- Core
- Solaris Operating System
- Security
- Database Connectivity
- Java Mobility Forums
- Web & Directory Servers
- Development Tools
- Application & Integration Servers
- Java HotSpot Virtual Machine
- Other Topics
- E-Mail, Calendar, & Collaboration
- Developer Tools
- General
- Administration Tools
- Sun Hardware
- Storage Forums
- Java Enterprise System
- StarOffice
- Open Source Technologies
- BigAdmin
- Real-Time
- Java Coding