dbDisplayLookUpList and ODBC Failure

[Bruce]

Hi,
I get this when I run the code below using SQL 6.5, EP and dbDisplayLookUpList. Everything else seems fine. Any ideas?
-----
Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
The request properties can not be supported by this ODBC Driver.
-----
Grid.dbSQL ="SELECT tblCommitteesGroups.CommitteesGroupsID, tblCommitteesGroups.CID,tblCommitteesGroups.GID FROM tblCommitteesGroups"

DLL = ""
DLL = DLL + "CID,,SELECT CID,CommitteeName FROM tblCommittees ORDER BY CommitteeName;"
DLL = DLL + "GID,,SELECT GID,Name FROM tblGroups ORDER BY Name;"
Grid.dbDisplayLookUpList = DLL

[John]

Hi Bruce,

I think the problem is that you need to define custom delimiters in your
Display Lookup List. I see you're using comma as a delimiter, and your
SELECT statement has a comma in it too. That's not good. Override them
at the beginning with another character (like tilde (~)) and see if that
does the trick!

John

------------
Bruce at 1/11/00 10:27:14 AM

Hi,
I get this when I run the code below using SQL 6.5, EP and dbDisplayLookUpList. Everything else seems fine. Any ideas?
-----
Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
The request properties can not be supported by this ODBC Driver.
-----
Grid.dbSQL ="SELECT tblCommitteesGroups.CommitteesGroupsID, tblCommitteesGroups.CID,tblCommitteesGroups.GID FROM tblCommitteesGroups"

DLL = ""
DLL = DLL + "CID,,SELECT CID,CommitteeName FROM tblCommittees ORDER BY CommitteeName;"
DLL = DLL + "GID,,SELECT GID,Name FROM tblGroups ORDER BY Name;"
Grid.dbDisplayLookUpList = DLL

[Mark]

Bruce,
See an on-line example of this at: http://www.aspdb.com/V2/V2_LookUp.asp
Plus you can see the source code.
Mark.


------------
John at 1/14/00 4:58:23 AM


Hi Bruce,

I think the problem is that you need to define custom delimiters in your
Display Lookup List. I see you're using comma as a delimiter, and your
SELECT statement has a comma in it too. That's not good. Override them
at the beginning with another character (like tilde (~)) and see if that
does the trick!

John

------------
Bruce at 1/11/00 10:27:14 AM

Hi,
I get this when I run the code below using SQL 6.5, EP and dbDisplayLookUpList. Everything else seems fine. Any ideas?
-----
Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
The request properties can not be supported by this ODBC Driver.
-----
Grid.dbSQL ="SELECT tblCommitteesGroups.CommitteesGroupsID, tblCommitteesGroups.CID,tblCommitteesGroups.GID FROM tblCommitteesGroups"

DLL = ""
DLL = DLL + "CID,,SELECT CID,CommitteeName FROM tblCommittees ORDER BY CommitteeName;"
DLL = DLL + "GID,,SELECT GID,Name FROM tblGroups ORDER BY Name;"
Grid.dbDisplayLookUpList = DLL

[Frank]

Also, avoid using ORDER BY in lookup as it is a performance killer. understand that "order by" the lookup source will not make any gains.


------------
Mark at 1/14/00 9:25:37 AM

Bruce,
See an on-line example of this at: http://www.aspdb.com/V2/V2_LookUp.asp
Plus you can see the source code.
Mark.


------------
John at 1/14/00 4:58:23 AM


Hi Bruce,

I think the problem is that you need to define custom delimiters in your
Display Lookup List. I see you're using comma as a delimiter, and your
SELECT statement has a comma in it too. That's not good. Override them
at the beginning with another character (like tilde (~)) and see if that
does the trick!

John

------------
Bruce at 1/11/00 10:27:14 AM

Hi,
I get this when I run the code below using SQL 6.5, EP and dbDisplayLookUpList. Everything else seems fine. Any ideas?
-----
Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
The request properties can not be supported by this ODBC Driver.
-----
Grid.dbSQL ="SELECT tblCommitteesGroups.CommitteesGroupsID, tblCommitteesGroups.CID,tblCommitteesGroups.GID FROM tblCommitteesGroups"

DLL = ""
DLL = DLL + "CID,,SELECT CID,CommitteeName FROM tblCommittees ORDER BY CommitteeName;"
DLL = DLL + "GID,,SELECT GID,Name FROM tblGroups ORDER BY Name;"
Grid.dbDisplayLookUpList = DLL