question on insert string

[SgtB]

The insert string from an MS app to a mysql db looks like this:

insert ( `field1`, `field2`, `field3` ) values ( 'test1', test2, 'test3' )

See how the second value is not enclosed with ' marks?

Is it possible to force the mysql server or the MyODBC driver to force the values to be enclosed in ' marks?


I'll see your DMCA and raise you a First Amendment.

http://www.anti-dmca.org

 

[SgtB]

Sorry-
MySQL 4.0.13 running on FreeBSD 5.1
MyODBC driver - 3.51

I'll see your DMCA and raise you a First Amendment.

http://www.anti-dmca.org