Using variable in for each cycle

[mellthy]

Hi,

its quite stupid question i am afraid, but i cant solve it myself.

Using a variable from database query result("columns&quot shows an error - "Type difference: [String " "]" or something like that.

Here is my code:

For column = 1 To result("columns&quot
Response.Write "column number"& column
Next

I wonder, if I can use variable in for command ... ?


Thx for help,

Gany

 

[JuanitaC]

Make sure that your value result("columns&quot is actually a number:

For column = 1 To CInt(result("columns&quot)

 

[mellthy]

Actually when I return value of result("columns&quot it returns integer - i dont know why ot doesnt work.

Anyway I've added the CInt function and I received quite different error: "Type difference: CInt"

Any other ideas?