Witango-Talk: String Conversion Problem

Lawrence Reeve Fri, 04 Nov 2005 11:31:37 -0800

Title: String Conversion Problem

Hello,

I ran into the following problem on Witango running on solaris against sybase:

I have a varchar(10) field called room in a table called hosts.

I have a form with the following select field:

<@assign scope=request name=room value='<@COLUMN "hosts.room">'>

<OPTION VALUE="<@col 1>"<@IF EXPR="('<@col NUM=1>' = '<@VAR request$Room>')"> SELECTED</@IF>><@col 1></OPTION>
</@ROWS>
</SELECT>

The rooms array consists of the following values:

This works fine to display the correct room number when changed unless I select room 104. If I select room 104 and enter, '104' is entered in the database, but the form displays '104E'. The view source of the form below shows why. Both 104 and 104E are selected, and the last one is displayed.

</SELECT>

Since this only occurs with room numbers with an E at the end, I assume Witango is doing some kind of conversion where it reads both 104 and 104E as the same number.

Has anyone run into this. Is there an elegant fix?

--

Lawrence Reeve
[EMAIL PROTECTED]
650 604 4529



________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Witango-Talk: String Conversion Problem

Reply via email to