I am trying to build a list from a query run against a sybase db. This part works fine. My problem is this, I want to display values in a list depending
on the value of certain fields i.e. See below which works for two. Unfortunately, I need it to work for 3 values. I don't know how I can do this for 3. I did try doing a select case but I was getting errors.
i.e. if value =0 then "Card Check" if Value = - Then "Card Spend" Else "Money Added"
The below immediate iif works brilliantly for two but as I say I need to build this with 3 different values.
$idItem = GUICtrlCreateListViewItem( _iif($adoRs.Fields("TransactionAmount").value =0, "Card check","Money Added")
Any help appreciated.
I have an array which is populated among results found with the AD UDF. So there can be hundreds of results. This array is output in a txt file in order to read the lines:
Here's some lines:
307|3| USERID|CN=XXXX,OU=Users,OU=SITE,OU=Brazil,OU=LA,DC=XXXX,DC=XXXX|NAME, FIRST NAME XXXX|CN=XXXX,OU=Users,OU=XXXX,OU=Mexico,OU=LA,DC=XXXX,DC=XXXX|XXXX XXXX XXXX|CN=XXXX,OU=Users,OU=XXXX,OU=Argentina,OU=LA,DC=XXXX,DC=XXXX|XXXX XXXX The first value is the number of returned results; the second one is the number of rows of the array. The file will always be outputted like the "code" above.
What I would like to achieve is to put all results in a listbox looking like the "windows explorer". I mean that it would contain 5 row that can be sorted by the "headers" (I've uploaded a photo to better explain). Also, I'd like to have the possibility to double click on a line where the value in the "User ID" would be stored in a variable (for further treatment but I know what to do with it ^^)
I know this can be a "huge" request but I've no idea where to start or how to achieve it.
Thanks in advance to all that can offer help, I'm sure my knowledge will grow