thank you too krikor,

you were both correct with the code. i simply provided the two lines code for the url to be generated.
BUT somewhere in the code where missing the alias of the item in the select query

you can close this

thank you guys