SQL COUNT

[Trond Hoyem]

Use getone() instead of getrow()

Hi

I am now having a similar challenge, but this time with the table I get from the string.split function. I have the following code;

Code:

startHG = string.split(start, '/')

This takes the Group address and splits it to the three values from the addres, giving med the table;

* table:
[1]
  * string: 26
[2]
  * string: 0
[3]
  * string: 0

How can I now get the different values entered in seperate variables? I would like to have a variable for maing group (e.g. mg) that should have the value 26 and so on.

---

Use getone() instead of getrow()

Hi

I am now having a similar challenge, but this time with the table I get from the string.split function. I have the following code;

Code:

startHG = string.split(start, '/')

This takes the Group address and splits it to the three values from the addres, giving med the table;

* table:
[1]
  * string: 26
[2]
  * string: 0
[3]
  * string: 0

How can I now get the different values entered in seperate variables? I would like to have a variable for maing group (e.g. mg) that should have the value 26 and so on.

Nevermind. I found it out by trial and error. The code needs to be;

Code:

startHG = tonumber(string.split(start, '/')[1])

That will get the main group as a number.