I believe you are correct in saying that text in MySql does not work without adjustment.
 
It's relatively easy to do though.  If you look at the xsl stylesheet (below is an excerpt from generate_list_editable), you can just add this:   or @fieldType='text '   ----  in a couple of places and things work fine.
 
I have a lot of little changes to my sheets or I'd just send them.
 
Perhaps this is a change that should be made to the originals included in the distribution.
 
Shawn
 
..... 
 
 <!-- we create input fields for NON-AUTOMATIC values only -->
 
           <xsl:if test="not(@autoInc) or @autoInc = 'false' ">
 
             <td>
 
               <xsl:choose>
                 <xsl:when test="@fieldType='int' or @fieldType='smallint'  or @fieldType='tinyint'">
                   <db:textField fieldName="{@name}" size="{@size}" />
                 </xsl:when>
                 <xsl:when test="@fieldType='char' or @fieldType='text' or @fieldType='varchar' or @fieldType='varchar2'  or @fieldType='nvarchar'  or @fieldType='longvarchar'">
                   <xsl:choose>
                     <xsl:when test="@size>80 or @fieldType='text'">
                        <db:textArea fieldName="{@name}" cols="40" rows="3" wrap="virtual" />
                     </xsl:when>

Reply via email to