djmonkey1 Posted November 2, 2005 Share Posted November 2, 2005 I've got the following sql query: INSERT INTO configuration SET configuration_title='Set "Contact Us" Email List', date_added=NOW(), sort_order='11', configuration_group_id='1', configuration_key='CONTACT_US_LIST', configuration_value= '', configuration_description='On the "Contact Us" Page, set the list of email addresses , in this format: Name 1 <email@address1>, Name 2 <email@address2>', use_function = NULL , set_function = NULL; But the value of the corresponding text box that's created is too small, only 255 characters. How should this sql query be written to change this? I want to have a text field of unlimited length. Thanks Stew Do, or do not. There is no try. Order Editor 5.0.6 "Ultra Violet" is now available! For support or to post comments, suggestions, etc, please visit the Order Editor support thread. Link to comment Share on other sites More sharing options...
♥yesudo Posted November 2, 2005 Share Posted November 2, 2005 It is not the query you need to change but the data type in the database for that field. http://dev.mysql.com/tech-resources/articl...-datatypes.html Your online success is Paramount. Link to comment Share on other sites More sharing options...
djmonkey1 Posted November 2, 2005 Author Share Posted November 2, 2005 It is not the query you need to change but the data type in the database for that field. http://dev.mysql.com/tech-resources/articl...-datatypes.html I don't see an option to do that from within my database manager. Do, or do not. There is no try. Order Editor 5.0.6 "Ultra Violet" is now available! For support or to post comments, suggestions, etc, please visit the Order Editor support thread. Link to comment Share on other sites More sharing options...
djmonkey1 Posted November 2, 2005 Author Share Posted November 2, 2005 Gah, found it, thanks!!! Do, or do not. There is no try. Order Editor 5.0.6 "Ultra Violet" is now available! For support or to post comments, suggestions, etc, please visit the Order Editor support thread. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.