Hi,
I have DDLB object in my PB app. It populates the data I want and I can select the list items and do what I want to. However I noticed that when I change the listed item in the DDLB and save I keep getting an SQL error. I am using Trim(Right(ddlb_debit_trans_type.Text, 1)) to get the value of the selected item. So the first time I select an item it gets the value correctly (For example 1). But if I change the item in the list box it will give me some junk data next to the value like '2>E' etc instead of 2.
Can someone explain why it is getting the junk data.
Thanks,
latha.
I have DDLB object in my PB app. It populates the data I want and I can select the list items and do what I want to. However I noticed that when I change the listed item in the DDLB and save I keep getting an SQL error. I am using Trim(Right(ddlb_debit_trans_type.Text, 1)) to get the value of the selected item. So the first time I select an item it gets the value correctly (For example 1). But if I change the item in the list box it will give me some junk data next to the value like '2>E' etc instead of 2.
Can someone explain why it is getting the junk data.
Thanks,
latha.