DaNcE-eViL
[H]ard|Gawd
- Joined
- Oct 31, 2001
- Messages
- 1,128
hey,
I was hoping you guys could point me out in right direction or help me with this coding, simply I'm having hard time to get rid of the last comma "," with mark as red
eg:
"21115","21121","21117",
to
"21115","21121","21117"
if i use this code below it will remove all ","
For above issue, the coding can be found below: mark as yellow
after that i'd like to put those value into array ()
I was hoping you guys could point me out in right direction or help me with this coding, simply I'm having hard time to get rid of the last comma "," with mark as red
eg:
"21115","21121","21117",
to
"21115","21121","21117"
if i use this code below it will remove all ","
Code:
Left(str,Len(str)-1)
For above issue, the coding can be found below: mark as yellow
Code:
mySQL3 = "SELECT classification " _
& "FROM cartRows " _
& "WHERE idOrder = " & validSQL(idOrder,"I") & " AND Project = 'Image' AND idproduct = '"&IDproduct&"' "
set rs3 = openRSexecute(mySQL3)
if NOT rs3.eof then
RemoveClassificationGroup = rs3("classification")
test = rs3.GetRows()
Dim iRowLoop, iColLoop
For iRowLoop = 0 to UBound(test, 2)
For iColLoop = 0 to UBound(test, 1)
[COLOR="Yellow"] Response.Write (""""&(test(iColLoop, iRowLoop)&""",")) 'checking output value[/COLOR]
'thisArray = Array("21115","21121","21117") 'Testing this value to see if it is working
Next 'iColLoop
Next 'iRowLoop
else
end if
after that i'd like to put those value into array ()