zahirudin
Posts: 4
|
Posted: 12/17/2008, 5:51 PM |
|
Hi all,
I using vb script.. I have problem to show 2 column value inside one single dropdownlist..
For 1 value can work properly but i try to write some code inside custom code.. Below is the code
+++++++++++++++++++++++++++++++++
'Dim objDataReader As SqlDataReader
'txtPhone.text = objDataReader("f_name") +("-")+ objDataReader("Phone")
+++++++++++++++++++++++++++++++++
error msg said "cannot define objDataReader "
after that i also add some code inside add.asp. I found private sub Class_Initialize() i put some code inside & look like this
+++++++++++++++++++++++++++++++++
Set txtPhone = CCCreateList(ccsListBox, "txtPhone", Empty, ccsText, CCGetRequestParam("txtPhone", Method), Empty)
txtPhone.BoundColumn = "phone" +"-"+ "f_name"
txtPhone.TextColumn = "phone" +"-"+ "f_name"
Set txtPhone.DataSource = CCCreateDataSource(dsTable,DBConMCR, Array("SELECT * " & _
"FROM crEtc_contact {SQL_Where} {SQL_OrderBy}", "", ""))
+++++++++++++++++++++++++++++++++++++++++++
Error message said : "Item cannot be found in the collection corresponding to the requested name or ordinal.
/intranet/v2/Classes.asp, line 2713
"
May some one help me,, what should i do..
Thanks
_________________
*****************************************
MOHD ZAHIRUDIN
Web Developer
zahir@mayflower.com.my
zahirudin84@gmail.com
***************************************** |
|
|
|