ODBiC Discussion Board


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:


Post Your Reply:

Name   
E-mail  optional
Topic  
Message:

HTTP Link: 
Link text: 

          


Copyright ©1997-2003, Roger Harris. All rights reserved.