OPTIONLIST problem

by Jon Grosse, July 1, 2008 08:42

I have never had any success using AS in the OPTIONLIST statement to rename the display field.

My ODB.exe file data
Created 16/05/07
Modified 09/04/08

======================
If I do NOT use the AS clause:

      <% set SupplierID=$vCoshhSupplierID$ %>
      <Select SupplierInfo  <% OPTIONLIST SupplierID, SupplierName from Suppliers %>  

The SupplierInfo dropdown list displays the correct SupplierName.

$sql_statement$; = SELECT DISTINCT SupplierID, SupplierName from Suppliers
$sql_error$; = null
======================
If I DO use the AS clause:

      <% set SupplierID=$vCoshhSupplierID$ %>
      <Select SupplierInfo  <% OPTIONLIST SupplierID, SupplierName AS xSupplierName from Suppliers %> 

The SupplierInfo dropdown list has nothing in it.

$sql_statement$;  and $sql_error$;  do NOT display at all.
======================

Replies:

• (Reply), Dave, 07-08-2008
Next | Previous | Top

Post Your Reply:

Name   
E-mail  optional
Topic  

HTTP Link: 
Link text: