escape characters

[Theodore Morse]

Hello everyone!
 
I have an SQL insert statement that contains ' symbols in it, however
as I use the ' symbol to denote the differences between columns in the
VALUES(...) part, I was wondering if there was another way of doing it
so I could include more characters like ' in the statment, a sample
would look something like this:

INSERT INTO parts VALUES('val1', 'val2', 'val3') 

if I did something like:
 
INSERT INTO parts VALUES('val1', 'bob's value', 'val3')

it would die, is there anyway to make that valid, like doing a
\' instead of just '?
 
Theodore Morse 

--
Theodore Morse
CIHOLAS Enterprises
[EMAIL PROTECTED]


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Embedded MySQL server crashing

[Theodore Morse]

Sorry for the ambiguity. My application is a gui application written in
Borland C++ Builder 6. It features one form with 4 buttons consisting of
Create, Connect, Disconnect, Destroy. Only the relevant buttons are
availible at certain times. (For instance, you cannot destroy a server
when one is not created, therefore you have to click create in order to
hit destroy). The purpose of the Create button is to call
mysql_server_init, which creates the mysqld embedded server. After which
you hit connect to connect to the created server, and then you can
disconnect and destroy the server with their respective buttons. I can
click the following button and have it crash:

o Create button
o Destroy button
o Create button again
o Destroy button --(Crashes here)

I hope this clears things up. The destroy button simply calls the
mysql_server_end(), and nothing else, just to kill the server. The speed
issues I had before (with it waiting 30 seconds to kill the server) were
resolved with adding the skip-innodb option to my configuration file. This
also fixed the previous crash after creating the server the second time,
but now has moved the crash one step ahead, the destruction of the server.

Ted

-- 
Ted Morse
CIHOLAS Enterprises
[EMAIL PROTECTED]

On Tue, 18 Jun 2002, miguel solorzano wrote:

 At 08:35 17/6/2002 -0500, Theodore Morse wrote:
 Hi,
 
 
 I tried the skip-innodb in my configuration file, it helps to a point, now
 I can create the server twice, but can only destroy it once, the procedure
 goes like this:
 
 Please clarify:
 
 o Create server
 o Destroy server
 
 Your application is closed ? or you did the below server instance
 immediately the above destroy action without to know if the server
 clean up was finished ? 
 
 
 o Create server
 o CRASH!!
 
 


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Embedded MySQL server crashing

[Theodore Morse]

Hello to all!

I am currently working on a GUI Application in Borland C++ Builder, and
must use an embedded MySQL server in it. I am having difficulties,
however, because whenever I create an instance, and destroy it, then
try to make another instance of an embedded server, the second time it 
tries to create the server, the application crashes. Furthermore,
it takes a lot longer than expected to shut down the mySQL embedded
server than it does to create it. Are there any bugs, or other
gotchas when using the embedded version?

Ted

-- 
Ted Morse
CIHOLAS Enterprises
[EMAIL PROTECTED]


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php