INSERT statement to MS Access

Hi,

I am trying to insert this into my database but because of the speech mark I keep getting an error

INSERT INTO database (field1, field2) VALUES ('Don't do that', 'Stop it')

The ' in (don't) means I keep getting an SQL error. Is there anyway round this.

Thanks

Dave

[312 byte] By [houseofwraitha] at [2007-11-27 5:25:57]

«« Problem connecting to the internet using Sun desktop on Solaris 10
»» new solaris 10 installation - allowing xdmcp from local network

# 1

Yes, by using PreparedStatement. With this you can avoid SQL injections.Check here for a tutorial: http://java.sun.com/docs/books/tutorial/jdbc/basics/prepared.html

BalusCa at 2007-7-12 14:46:25 >

top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...

# 2

you can also use double ' like that:

INSERT INTO database (field1, field2) VALUES ('Don''t do that', 'Stop it')

but using a PreparedStatement is more elegant and easier to get optimized by the server (valid at least for Oracle)

[]

S_i_m_ua at 2007-7-12 14:46:25 >

# 3

If you are in a hurry use double ' . But using prepared statement is the professional approach

javamonka at 2007-7-12 14:46:25 >

Database Connectivity

Java Database Connectivity (JDBC)

Java Database Connectivity (JDBC)

Java programming resources: FAQs, tutorials, compiler and browser download sites, documentation, books lists, IDEs, etc.

INSERT statement to MS Access

Database Connectivity Hot Topic

Database Connectivity

All Classified