Well, I've answered my own question! Apparently, you cannot use the addslashes
function in the sql statement, not the way I am anyways. Does anyone know the proper
way if any to do that without having to do a bunch of extra coding before every sql
statment just to addslashes? Thanks!
Angie
>>> "Angie Tollerson" <[EMAIL PROTECTED]> 08/23/01 04:41PM >>>
I guess the only thing windows related about this is that I have this whole setup on
windows :) But I've tried to help out as much as I can on here so maybe someone will
be kind to me :) Here goes:
I have set up a mysql database column to be LongText (I've also tried LongBlob) and I
tried uploading a block of text to it about 1000 chars in length thru my script. The
sql statement died with a failure to execute. I cut the text in half and then it let
me do it! So I assumed it was length. Which didn't make sense cuz the long fields
don't have length restrictions. So I copy and pasted the same 1000 char data into my
phpMyAdmin to upload it straight into the database that way, and it took it! Anybody
have any ideas as to why my script might be doing this? I won't bother to put all the
code in here, cuz it's just a simple update sql statment like this:
UPDATE dictionary_pending set alt_spelling='addslashes($alt_spelling)',
description='addslashes($description)'";
The description field being the one failing if it is too long. As you can see I tried
adding slashes but to no avail..it really seems to be the length for my scripts but
phpmyadmin doesn't care. Any ideas?
Angie Tollerson
Alliance Technologies
Web Programmer
(515)245-7628
[EMAIL PROTECTED]
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
