Nope, same situation...When you hit the submit button, nothing happens...I check the database afterwards and find out that nothing was inserted...
George "I think there is a world market for maybe five computers." Thomas Watson, Chairman of IBM, 1943. ----- Original Message ----- From: "Rob A. Brahier" <[EMAIL PROTECTED]> To: "Lekeas GK" <[EMAIL PROTECTED]> Sent: Friday, July 18, 2003 5:01 PM Subject: RE: Working with the text datatype in Mysql | hmm, add this after your mysql_query() line in the script | | echo mysql_error(); | | Does that return anything? | | | -----Original Message----- | From: Lekeas GK [mailto:[EMAIL PROTECTED] | Sent: Friday, July 18, 2003 11:52 AM | To: Rob A. Brahier | Cc: [EMAIL PROTECTED] | Subject: Re: Working with the text datatype in Mysql | | | Rob, | | The script is indeed written in PHP version 4.3.1. The full version of mysql | I am using is 3.23.30-gamma. | | Thanks, | George | | "I think there is a world market for maybe five computers." | Thomas Watson, Chairman of IBM, 1943. | | ----- Original Message ----- | From: "Rob A. Brahier" <[EMAIL PROTECTED]> | To: "Lekeas GK" <[EMAIL PROTECTED]> | Sent: Friday, July 18, 2003 4:31 PM | Subject: RE: Working with the text datatype in Mysql | | | | George, | | You keep leaving out the vital bits. What are your sers using to enter | | this data? We know it's a web page, but what script does that web page | run | | when the user submits their data? Is it a script written in the PHP | | programming language or something else? What is the FULL version number | of | | the MySQL server you are using, and what is the version of the programming | | language that you wrote your script in? | | | | -Rob | | | | -----Original Message----- | | From: Lekeas GK [mailto:[EMAIL PROTECTED] | | Sent: Friday, July 18, 2003 10:17 AM | | To: gerald_clark | | Cc: [EMAIL PROTECTED] | | Subject: Re: Working with the text datatype in Mysql | | | | | | The checking is done from the mysql command line tool and all special | | characters are properly quoted (even tried it with a sequence of | characters | | without any punctuation marks or anything else). The mysql_query() call | has | | a die() statement as well but it is not coming up. | | | | George | | | | "I think there is a world market for maybe five computers." | | Thomas Watson, Chairman of IBM, 1943. | | | | ----- Original Message ----- | | From: "gerald_clark" <[EMAIL PROTECTED]> | | To: "Lekeas GK" <[EMAIL PROTECTED]> | | Cc: <[EMAIL PROTECTED]> | | Sent: Friday, July 18, 2003 3:00 PM | | Subject: Re: Working with the text datatype in Mysql | | | | | | | | | | | | | Lekeas GK wrote: | | | | | | >Gerald, | | | > | | | >The version of MySQL is 3.23, | | | > | | | That only spans 50 some odd releases. Which one? | | | | | | > the platform is Solaris, the language is | | | >English | | | > | | | Computer language. | | | PHP? | | | Perl? | | | Python? | | | Mysql command line tool? | | | | | | Did the program performing the insert properly quote special characters? | | | Did it check for sucess of the insert? | | | | | | > and the way I check whether data has been entered in the database or | | | >not is by running a select query on the database. | | | > | | | Useing Which language above? | | | | | | > | | | >Was that of any help? I tried searching the net but couldn't find more | | | >information about what might be causing the problem... | | | > | | | >Thanks, | | | >George | | | > | | | >"I think there is a world market for maybe five computers." | | | >Thomas Watson, Chairman of IBM, 1943. | | | > | | | >----- Original Message ----- | | | >From: "gerald_clark" <[EMAIL PROTECTED]> | | | >To: "Lekeas GK" <[EMAIL PROTECTED]> | | | >Cc: <[EMAIL PROTECTED]> | | | >Sent: Friday, July 18, 2003 2:11 PM | | | >Subject: Re: Working with the text datatype in Mysql | | | > | | | > | | | >| You supply almost no useful information here. | | | >| What version of MySQL are you using? | | | >| What platform? | | | >| What language? | | | >| How do you check to see if anything was entered? | | | >| | | | >| | | | >| Lekeas GK wrote: | | | >| | | | >| >Hi All, | | | >| > | | | >| >I am managing a small database where a few fields are defined as | being | | of | | | >| >type text. In my understanding, this would allow the user to enter | up | | to | | | >| >about 65,000 characters in the text field. | | | >| > | | | >| >However, if the user types about 2,000 characters, then nothing is | | | >entered | | | >| >in the database. I have checked the max_packet_allowed and the | | | >| >net_buffer_length and the limits are quite high. | | | >| > | | | >| >Could somebody advice me on how to go about solving this problem? | | | >| > | | | >| >I look forward to hearing from you soon. | | | >| > | | | >| >Thanks in advance. | | | >| > | | | >| >George | | | >| > | | | >| >"I think there is a world market for maybe five computers." | | | >| >Thomas Watson, Chairman of IBM, 1943. | | | >| > | | | >| > | | | >| > | | | >| > | | | >| > | | | >| | | | >| | | | > | | | > | | | > | | | > | | | | | | | | | | | -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
