note 34992 added to function.odbc-exec

From: Date: Thu, 14 Aug 2003 11:08:20 +0000
Subject: note 34992 added to function.odbc-exec
Groups: php.notes 
Request: Send a blank email to php-notes+get-54155@lists.php.net to get a copy of this message
I used the ODBC function for my forum program to handle user entered infos the form passes user entered data to post.php, inside which i had a program parsing the data, then put into the access file through ODBC connectivity. it works fine, , but there is one thing that bothers me very much!! sometimes it gets the following error messages: ----------------------------------------------------------- SQL error: [Microsoft][ODBC Microsoft Access Driver]COUNT SQL state 07001 in SQLExecDirect in post.php on line 20 ----------------------------------------------------------- especially when the user entered a large size article into the database, i thought it might be that i parsed the data ($userdata=nl2br(stripslashes(htmlspecialchars($userdata)))), so i double slashed this line, but the problem wasnt solved at'll! then i tried using addslashes: $data=addslashes($data), and still, i got error if the data is too big. is there anyway to work out this?!! this is really frustrating, i d rather get back and stick to mysql!!!! or maybe i am just too stupid to work it out... ---- Manual Page -- http://www.php.net/manual/en/function.odbc-exec.php Edit Note -- http://master.php.net/manage/user-notes.php?action=edit+34992 Delete Note -- http://master.php.net/manage/user-notes.php?action=delete+34992&report=yes Reject Note -- http://master.php.net/manage/user-notes.php?action=reject+34992&report=yes

« previous php.notes (#54155) next »