Re: perl+Mysql - Ramzi S. Abdallah - com.mysql.lists.perl

5 messages in com.mysql.lists.perlRe: perl+Mysql

From	Sent On	Attachments
ed phillips	03 Oct 2000 23:15
Ramzi S. Abdallah	04 Oct 2000 00:15
Dan Cutting	04 Oct 2000 01:53
Ramzi S. Abdallah	05 Oct 2000 16:52
Ramzi S. Abdallah	05 Oct 2000 18:43

Subject:	Re: perl+Mysql
From:	Ramzi S. Abdallah (rs...@acl.edu.au)
Date:	10/05/2000 04:52:09 PM
List:	com.mysql.lists.perl

Thanks Ed, I have attached a copy of the script. I appreciate any help as I am not an experienced Perl programmer. I will try to find more info about this in the archieves but first I have to know where they are.

Thanks

Ramzi

Well,

You would have to show us the script for us to tell you what you are doing wrong; furthermore, have you read the docs, or the archives?

It seems most likely that you are not escaping single quotes. We've been over this one too many times on the list.

"Ramzi S. Abdallah" wrote:

Hi, I wrote a set of perl scripts that takes input from a web form for and saves the information to the Mysql database. The scripts works perfect except when there is a word with an apostrophe example "don't" the INSERT command does not complain but nothing gets saved to the database. The problem does not occur if I try to insert manually by connecting to mysql so most likely it is happening from the PERL DBI module.

I am using Mysql version 3.22.32 and just upgrade to DBI-1.13.

Any help is much appreciated.

Ramzi

To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail msql...@lists.mysql.com instead.