Hello everyone,
I'm having trouble displaying an array field, qty\-ordered[1]. I added a backslash (\) before the hyphen (-) because that's the rule when you have a hyphen in a field name. I put brackets in array 1 and it works fine in my sql select statement. But when I tried to display the Response.Write rs("qty\-ordered[1]"), qty-ordered[1], qty\-ordered__1, or qty\-ordered__1, neither of these works! I'm helpless... please help!! BTW, I'm using Progress Version 9.1b06. Below is my code:
str="SELECT DISTINCT spechist.item, spechist.qty\-ordered[1] FROM pennaux.spechist WHERE (spechist.rec\-type='I') "
....
....
....
Do while Not rs.EOF
Response.Write rs("item")
** Is this the right way to display arrays??? **
Response.Write rs("qty-ordered[1]")
rs.MoveNext
Loop
...
...
I'm having trouble displaying an array field, qty\-ordered[1]. I added a backslash (\) before the hyphen (-) because that's the rule when you have a hyphen in a field name. I put brackets in array 1 and it works fine in my sql select statement. But when I tried to display the Response.Write rs("qty\-ordered[1]"), qty-ordered[1], qty\-ordered__1, or qty\-ordered__1, neither of these works! I'm helpless... please help!! BTW, I'm using Progress Version 9.1b06. Below is my code:
str="SELECT DISTINCT spechist.item, spechist.qty\-ordered[1] FROM pennaux.spechist WHERE (spechist.rec\-type='I') "
....
....
....
Do while Not rs.EOF
Response.Write rs("item")
** Is this the right way to display arrays??? **
Response.Write rs("qty-ordered[1]")
rs.MoveNext
Loop
...
...