hes - it's not needed.
HTH
MS
- Original Message -
From: "Keith C. Ivey" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: "Daneman" <[EMAIL PROTECTED]>
Sent: Monday, February 24, 2003 1:45 PM
Subject: Re: Question mark becomes NULL
> On 24 Feb
At 15:45 24-2-03 -0500, Keith C. Ivey wrote:
On 24 Feb 2003, at 21:07, Daneman wrote:
> INSERT INTO MyTable (MyFields) VALUES ($val1, $val2, etc);
>
> Question marks are no longer replaced with NULL values in the text
> column this way, still, when I enter question marks into the charvar
> fields,
If you want to insert question marks into a character field, then you
must surround them with quotation marks as you would
with any string.
I don't see you entering any questionmarks.
I see you defining an insert command that uses placeholders for the
values entered in the execute statement.
You
On 24 Feb 2003, at 21:07, Daneman wrote:
> INSERT INTO MyTable (MyFields) VALUES ($val1, $val2, etc);
>
> Question marks are no longer replaced with NULL values in the text
> column this way, still, when I enter question marks into the charvar
> fields, the record is not taken into he database. I
At 14:25 24-2-03 -0600, gerald_clark wrote:
And you still have not shown us how you are entering the question marks.
Like this:
$sql = qq{ INSERT INTO main (id, categorie, achternaam, voornaam,
aanspreektitel, straat, huisnummer, postcode, plaatsnaam, telefoon, mobiel,
email1, email2, tekst) VAL
And you still have not shown us how you are entering the question marks.
Daneman wrote:
At 10:06 24-2-03 -0500, Keith C. Ivey wrote:
On 24 Feb 2003, at 13:42, Daneman wrote:
> I use a perl script & DBI to insert records into a mySQL database.
> This database holds 1 text-column. Now when this
At 10:06 24-2-03 -0500, Keith C. Ivey wrote:
On 24 Feb 2003, at 13:42, Daneman wrote:
> I use a perl script & DBI to insert records into a mySQL database.
> This database holds 1 text-column. Now when this text-field holds any
> question marks, they appear in the record as`NULL`.
Post the Perl co
On 24 Feb 2003, at 13:42, Daneman wrote:
> I use a perl script & DBI to insert records into a mySQL database.
> This database holds 1 text-column. Now when this text-field holds any
> question marks, they appear in the record as`NULL`.
Post the Perl code you're using for the insert query. It so
Greetings,
I have this strange problem.
I use a perl script & DBI to insert records into a mySQL database. This
database holds 1 text-column.
Now when this text-field holds any question marks, they appear in the
record as`NULL`. I went thrue the mySQL docs to find out how to avoid this
but to