My client is using an Access DB for maintaining a large list of companies (about 1500). They are exporting the db to a CSV text file that is then being imported into a Form & List module on their website.

There is one column in the Access db that indicates registered status (Yes or No) with a "1" or "0" in that column (they aren't using the logical Y/N field type in Access). Is there any way for F&L to display the word "yes" or "no" based on finding a "1" or "0" in the associated field? I assume that it might be doable via the XSL script, but I know nothing about XSL programming.

Thanks for any suggestions offered!

Jim

That would work, but I'm trying to make the module as simple to operate for the client as possible. That being the case, they would go into settings for the FnL and change the field type each time they import. By adding the logic to the template, the field would correctly displayed without tweaking the settings each time.

Do you think you might be be able to write a little xsl code fragment for me?

I would think that a choose / when / otherwise would work. The current line that displays the "1" or "0" in the xsl template is:

<td>
      <xsl:value-of select="udt:FA_Y_x002F_N" disable-output-escaping="yes" />
</td>

I made a wild guess (and of course it didn't work...) with the following:

<td>
   <xsl:variable name="statusType">
      <xsl:variable name="statusType" select="udt:FA_Y_x002F_N" />
      <xsl:choose>
         <xsl:when test="$statusType='1'">
            <xsl:text>Yes</xsl:text>
         </xsl:when>
         <xsl:otherwise>
            <xsl:text>No</xsl:text>
          </xsl:otherwise>
      </xsl:choose>
   </xsl:variable>
</td>

Thanks for any help you can provide!

Jim

It didn't work. I figure it had to do with the logic not matching the actual value in the udt:FA_Y_x002F_N field.

I did get it working though :-) With a little more testing and I ended up with the following code.

<xsl:choose>
      <xsl:when test="udt:FA_Y_x002F_N > 0">
         <td><xsl:text>Yes</xsl:text></td>
      </xsl:when>
      <xsl:otherwise>
         <td><xsl:text>No</xsl:text></td>
      </xsl:otherwise>
</xsl:choose>

Thanks again!