Solved

field length and truncated data

Posted on 2008-10-05
3
391 Views
Last Modified: 2013-11-05
Hi - I have a comment field on a webform, and I've set the db to the values as shown in the attached image.

The problem is a) I already had 1 response that went over the 1000 character limit, and b) everytime I export as an xls file through phpmyadmin, the data is being truncated even further down to 255.

So my question is, have I set up the db correctly on the server, and how do I export the data so I can view it all later in excel or access?

I realise that's 2 questions, but I assume they are related somehow to an incorrect setting on my part?

Thanks ;-)
sqlcode.gif
0
Comment
Question by:seanpowell
  • 2
3 Comments
 
LVL 8

Accepted Solution

by:
Leo Eikelman earned 500 total points
ID: 22644585
You need to set the MAXLENGTH attribute in your webform for that text area to 1000.  This will limit the number of characters the user can put in.

I am not too sure about the export, I have never had this problem before.  You can use the following tutorial if you are still having problems:

http://www.tutorialized.com/view/tutorial/Export-MySQL-to-Excel/16570
0
 
LVL 31

Author Comment

by:seanpowell
ID: 22649016
Hi - I'm afraid the tutorial didn't help, I'll need to dig deeper to find out why excel is truncating the data at 255 characters.

Thanks.
0
 
LVL 31

Author Comment

by:seanpowell
ID: 22649467
Looking more closely the tutorial gets me in the direction where I need to go - I appreciate you help in posting the link ;-)
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

A lot of articles have been written on splitting mysqldump and grabbing the required tables. A long while back, when Shlomi (http://code.openark.org/blog/mysql/on-restoring-a-single-table-from-mysqldump) had suggested a “sed” way, I actually shell …
All XML, All the Time; More Fun MySQL Tidbits – Dynamically Generate XML via Stored Procedure in MySQL Extensible Markup Language (XML) and database systems, a marriage we are seeing more and more of.  So the topics of parsing and manipulating XM…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now