List/Menu set value equal to

[newflavour]

I have a list/menu that I have manually entered the values to and then applied
DWMX 04's Dynamic list server behaviour to so that it initially selects the
value stored in the database. However it's not selecting anything.

I can output the field value using:
<%=(registrations.Fields.Item("paymentStatus").Val ue)%>

The recordset code is:
<%
Dim registrations__MMColParam
registrations__MMColParam = "1"
If (Request.Form("registrationID") <> "") Then
registrations__MMColParam = Request.Form("registrationID")
End If
%>
<%
Dim registrations
Dim registrations_numRows

Set registrations = Server.CreateObject("ADODB.Recordset")
registrations.ActiveConnection = MM_dsn_botr_STRING
registrations.Source = "SELECT * FROM tbl_Users WHERE registrationID = " +
Replace(registrations__MMColParam, "'", "''") + ""
registrations.CursorType = 0
registrations.CursorLocation = 2
registrations.LockType = 1
registrations.Open()

registrations_numRows = 0
%>



The form code is:
<select name="paymentStatus">
<option value="Not Yet Received" <%If (Not
isNull((registrations.Fields.Item("paymentStatus") .Value))) Then If ("Not Yet
Received" = CStr((registrations.Fields.Item("paymentStatus").V alue))) Then
Response.Write("SELECTED") : Response.Write("")%>>Not Yet Received</option>
<option value="Received" <%If (Not
isNull((registrations.Fields.Item("paymentStatus") .Value))) Then If ("Received"
= CStr((registrations.Fields.Item("paymentStatus").V alue))) Then
Response.Write("SELECTED") : Response.Write("")%>>Received</option>
<option value="Processing" <%If (Not
isNull((registrations.Fields.Item("paymentStatus") .Value))) Then If
("Processing" = CStr((registrations.Fields.Item("paymentStatus").V alue))) Then
Response.Write("SELECTED") : Response.Write("")%>>Processing</option>
<option value="Approved" <%If (Not
isNull((registrations.Fields.Item("paymentStatus") .Value))) Then If ("Approved"
= CStr((registrations.Fields.Item("paymentStatus").V alue))) Then
Response.Write("SELECTED") : Response.Write("")%>>Approved</option>
</select>


your help is appreciated.

thanks,
mark.

[newflavour]

ok, while cooking dinner I had a brain wave. What if DW wasn't the issue but my
DB was.

Well, I opened the DB and changed the column "paymentStatus" from 'memo' to
'text' and it now works. This is fine for now, but does anyone have a fix for
DB columns that are set to 'memo'?