PHP DB - Re: [PHP-DB] Single quotes in INSERT statements?

Author

Re: [PHP-DB] Single quotes in INSERT statements?

dpgirago@mdanderson.org

2006-04-26, 6:58 pm

Martin Alterisio wrote:

>2006/4/26, dpgirago@mdanderson.org <dpgirago@mdanderson.org>:
>
> Well, 80% of solving a problem is finding out what the problem is. If you
> ask them to solve that 80% on their own then asking for help is rather
> pointless. Anyway I agree that the subject was misleading, but this was
> caused by how he explained the problem, particularly on the assumption
that
> addslashes was not doing what it was supposed to do so. What I advise is
to
> avoid assumptions and just present the symptoms of the problem.

The devil is in the detail, no?

I'm not disagreeing with you, Martin. Clearly incorrect assumptions were
made by the initial poster, and responses were consequently at first
off-base. Far be it for me to discourage anyone from asking a question,
well considered or not. And to be honest, I even rather enjoy those that
are off-topic.

My apologies if my preceding response seemed impatient or impolite. We all
once were beginners, and I still have one or more "brain dead" moments each
day. Reminds me I'm human.

David

Skip Evans

2006-04-26, 6:58 pm

Geez, did I start all this?

I can see now that my initial assumption that
addslashes() was not doing what it was supposed to
do was wrong, and that I should have checked the
DB before firing off the message. Clearly I should
have done more investigation on my own. (Which is
often the case.)

However, the initial response that was made about
perhaps the field itself truncating the data
tipped me off to what I should have done
previously, look in the database, so once I did
that it was clear what the problem was.

And then another list member had mentioned
htmlentities() and that lit the the old proverbial
overhead bulb, and bingo: problem solved.

Perhaps a zig zag, somewhat sloppy path to the
solution, and I accept responsibility for that,
but a solution nonetheless. I must confess I'm
happy about that.

I do apologize for my assumption starting a thread
that was misnamed, and not doing the diligence
thing before firing off the message.

But I certainly do value and appreciate the
assistance given.

Skip

dpgirago@mdanderson.org wrote:
>
> Martin Alterisio wrote:
>
>
>
> that
>
>
> to
>
>
>
> The devil is in the detail, no?
>
> I'm not disagreeing with you, Martin. Clearly incorrect assumptions were
> made by the initial poster, and responses were consequently at first
> off-base. Far be it for me to discourage anyone from asking a question,
> well considered or not. And to be honest, I even rather enjoy those that
> are off-topic.
>
> My apologies if my preceding response seemed impatient or impolite. We all
> once were beginners, and I still have one or more "brain dead" moments each
> day. Reminds me I'm human.
>
> David
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>

--
Skip Evans
Big Sky Penguin, LLC
61 W Broadway
Butte, Montana 59701
406-782-2240

Sponsored Links