2. ASPRunnerPro General questions
  3. Select Statements and displaying fields
This topic is locked

Select Statements and displaying fields

 		3/11/2004 10:38:45 AM
ASPRunnerPro General questions
B
 bblazewink author

Hello,
My question is...when I choose "lookup field' for an edit/add page, and modify the SQL statement to contain several fields of a record from a table instead of just one field, all those fields do not display in the list boxwhen the page loads.

I posted yesterday regarding the drop down lists, and am still beating my head against the wall on that one.
Thanks in advance for any input...
Sergey Kornilov admin 3/12/2004

You need to stick several fields together in SQL query for this purpose:

select ID, field1 + field2 + field3 from tablename


Make sure that field1, field2, field3 are text fields or use conversion functions in other case.
B
 		bblazewink author 3/15/2004

Sergey,
So after modifying the SQL string to :
if "CustomerCode" = strName then strSize = 1 : strSQL = "SELECT [CustomerCode], [CustomerCode] + [CustomerName] FROM [CUSTOMERS] " end if
which effectively gives the user the values needed to make a selection, is it possible to use an onchange event here to create the next selection box? I have never done this straight from ASP code, I have looked at this for about 5 days, and am still very perplexed...
Any assistance you can provide would be appreciated-have searched the web over on this one.

Brenda