Re: apostrophe and comma error on submit
you could try the replace function of mySQL
lewell
The content of this email when sent is as full as practical. Due to the
settling of the words the contents might not appear as full as it was but
the weight remains the same. The contents is being sent by weight and not by
volume.
- Original Message -
From: Bryant Hester [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, February 07, 2003 6:48 AM
Subject: RE: apostrophe and comma error on submit
You need to delimit them:
INSERT INTO table VALUES ('value','Don\'t know','');
If you're inserting via PHP, you need to add a backslash before
apostrophes or commas in the post data, as apostrophes and commas are
used by MySQL to delimit fields on INSERT statements.
It's also in the manual, somewhere
HTH,
Bryant Hester
Mysql, query
-Original Message-
From: ahimsa [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 05, 2003 11:43 AM
To: [EMAIL PROTECTED]
Subject: apostrophe and comma error on submit
Does anyone know about an error that occurs when you try to submit into
mysql.
Whever i try to imput any text with a comma in it or an appostrophe, i
get an error until i remove it.
Any suggestions. .. anyone...? Im using php and submiting via post,
when i get the error. Thank you so much for your time. Leeann
-
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
-
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
-
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: Date Conversion with UltraDev (ASP)
you could use the format function of vbScript format(string, -mm-dd) The content of this email when sent is as full as practical. Due to the settling of the words the contents might not appear as full as it was but the weight remains the same. The contents is being sent by weight and not by volume. - Original Message - From: Dana Shields [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, February 08, 2003 9:13 AM Subject: Date Conversion with UltraDev (ASP) I am using MySQL with Ultradev (asp server model), and I'm creating a recordset insert form; however, the documenation is obvious that the user has to enter the date in -mm-dd format. However, this will not work for my users, and I need to allow them to enter mm/dd/ or even mm/dd/yy format. Does anyone know of an ultradev extension (for ASP) that will convert to the MySQL date format? This is easily handled with MS Access and SQL Server, so hopefully there's something out there that does this as well. If anyone thinks this posting is misplaced and should be in an Ultradev list, please feel free to let me know. Thank you. Dana - 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 - 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: Mail Problems
same here i also received mails 12hrs+ after i posted it. what seems to be the problem, it will take days before ppl could suggest help on mysql problems lewell The content of this email when sent is as full as practical. Due to the settling of the words the contents might not appear as full as it was but the weight remains the same. The contents is being sent by weight and not by volume. - Original Message - From: Simon Windsor [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, February 09, 2003 12:06 AM Subject: Mail Problems SQL Hi Two or three days ago, the mail list appeared to stop, and now I am getting mail two or three days old. What has happened? Is there a delay in processing mail. The last two emails I have received are Re: InnoDB foreign keys bug Yesterday 12:30:56 am BUG: InnoDB ORDER BY DESC may hang in 4.0.10 Yesterday 12:40:40 am and they arrived 24 hours after being sent! Simon -- Simon Windsor Email: [EMAIL PROTECTED] Tel: 01454 617689 Mob: 07720 447385 - 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 - 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: hang then resume....
bump? The content of this email when sent is as full as practical. Due to the settling of the words the contents might not appear as full as it was but the weight remains the same. The contents is being sent by weight and not by volume. - Original Message - From: pazenko [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, February 05, 2003 7:27 AM Subject: Re: hang then resume the whole program halts by itself, this is how my software work * form loads, then i open a connection, then i close connection but not terminating it to be use later * the user click the 'add' button, all related textbox will be enabled. * the user type in all the details, while typing the the user experience a temporary halt of the program for about 2secs then it resumes(random) * the user click the button save, i open the connection then execute 'Insert' command then the record is save, then i close the connection. * upon exit of the program i terminate the connection before and after halt of the program i'm not requesting any large query from the db server lewell The content of this email when sent is as full as practical. Due to the settling of the words the contents might not appear as full as it was but the weight remains the same. The contents is being sent by weight and not by volume. - Original Message - From: Victor Pendleton [EMAIL PROTECTED] To: 'pazenko' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, February 05, 2003 7:12 AM Subject: RE: hang then resume What type of 'hang' are you reporting? Have you checked the processlist to see if the connection is processing a request? Are you returning a large result set that needs to be displayed? -Original Message- From: pazenko [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 04, 2003 7:43 AM To: [EMAIL PROTECTED] Subject: hang then resume i'm currently developing a software using vb6 and mysql 4.0 the problem is i'm getting a random hang from the software i develop, the hang last for about 2 seconds or more and then it resumes again. my test environment is win98se and the production environment is also win98. the hang symptoms also appear on the production evironment. does anyone have experience this kind of behaviour? lewell The content of this email when sent is as full as practical. Due to the settling of the words the contents might not appear as full as it was but the weight remains the same. The contents is being sent by weight and not by volume. - 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 - 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 - 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: hang then resume....
the whole program halts by itself, this is how my software work * form loads, then i open a connection, then i close connection but not terminating it to be use later * the user click the 'add' button, all related textbox will be enabled. * the user type in all the details, while typing the the user experience a temporary halt of the program for about 2secs then it resumes(random) * the user click the button save, i open the connection then execute 'Insert' command then the record is save, then i close the connection. * upon exit of the program i terminate the connection before and after halt of the program i'm not requesting any large query from the db server lewell The content of this email when sent is as full as practical. Due to the settling of the words the contents might not appear as full as it was but the weight remains the same. The contents is being sent by weight and not by volume. - Original Message - From: Victor Pendleton [EMAIL PROTECTED] To: 'pazenko' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, February 05, 2003 7:12 AM Subject: RE: hang then resume What type of 'hang' are you reporting? Have you checked the processlist to see if the connection is processing a request? Are you returning a large result set that needs to be displayed? -Original Message- From: pazenko [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 04, 2003 7:43 AM To: [EMAIL PROTECTED] Subject: hang then resume i'm currently developing a software using vb6 and mysql 4.0 the problem is i'm getting a random hang from the software i develop, the hang last for about 2 seconds or more and then it resumes again. my test environment is win98se and the production environment is also win98. the hang symptoms also appear on the production evironment. does anyone have experience this kind of behaviour? lewell The content of this email when sent is as full as practical. Due to the settling of the words the contents might not appear as full as it was but the weight remains the same. The contents is being sent by weight and not by volume. - 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 - 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
hang then resume....
i'm currently developing a software using vb6 and mysql 4.0 the problem is i'm getting a random hang from the software i develop, the hang last for about 2 seconds or more and then it resumes again. my test environment is win98se and the production environment is also win98. the hang symptoms also appear on the production evironment. does anyone have experience this kind of behaviour? lewell The content of this email when sent is as full as practical. Due to the settling of the words the contents might not appear as full as it was but the weight remains the same. The contents is being sent by weight and not by volume. - 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: setting up mysql for windows...
try running winmysqladmin.exe under mysql folder lewell The content of this email when sent is as full as practical. Due to the settling of the words the contents might not appear as full as it was but the weight remains the same. The contents is being sent by weight and not by volume. - Original Message - From: Stick Dragon [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 30, 2003 9:28 AM Subject: setting up mysql for windows... i'm trying to set mysql up on windows 2000, and having some problems. i download file and installed. what do i have to do to get it running. never done it on windows just linux _ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail - 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 - 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
upgrade mySQL
Greetings I'm currently upgrading mySQL v3.23 to mySQL v4.0, the installation of v4.0 was a success,I tried to execute mysql_fix_privilege_tables c:\mysql\binmysql -e mysql_fix_privilege_tables but i keep on getting the error: ERROR 1064 at line 1: You have an error in your SQL syntax. Check the manual that corresponds to your mySQL server version for the right syntax to use near 'mysql_fix_privilege_tables' at line 1 what is the right way of running this script? OS: win98se mySQL: version 4.0.9 -gamma winMySQLAdmin 1.4: started lewell The content of this email when sent is as full as practical. Due to the settling of the words the contents might not appear as full as it was but the weight remains the same. The contents is being sent by weight and not by volume. - 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
