This topic is locked

LOOKUPWIZARD

9/3/2006 6:27:10 AM
ASPRunnerPro General questions
C
chris theodosiou author

Function BuildSelectControl(strName, strValue, bAdd)
Set rsTemp = server.CreateObject ("ADODB.Recordset")

strSQL =""

strSize = 1

if IsNull(strValue) then strValue=""

BuildSelectControl = " "
bAddNewItem = false
if "Alternate_Address" = strName then strSize = 1 : strSQL = "SELECT DISTINCT [Alternate_Address], [Alternate_Address] FROM [dbo].[ALTADDRESS] " & " ORDER BY [Alternate_Address]" : strField="Alternate_Address" : bAddNewItem = false : strLookupTable="dbo.ALTADDRESS" : strLinkField="Alternate_Address" : strDisplayField="Alternate_Address" end if
THIS IS OK!
WHAT I WOULD LIKE TO DO IS - :

if "Alternate_Address" = strName then strSize = 1 : strSQL = "SELECT DISTINCT [Alternate_Address], [xxxfield] FROM [dbo].[ALTADDRESS] " & " WHERE "xxxfield= yyyfield " : strField="Alternate_Address" : bAddNewItem = false : strLookupTable="dbo.ALTADDRESS" : strLinkField="Alternate_Address" : strDisplayField="Alternate_Address" end if
IT THIS POSSIBLE!!

Sergey Kornilov admin 9/7/2006

Not really sure what is the question here.
You can modify generated code according to your needs.