MySQL Concat with dataset

[^MisterJingo^]

Hi all,

Usually when pulling a dataset from a DB I get the headers too, so i
can databind DataValueField and DataTextField etc. But I am trying the
below query:

SELECT CONCAT(firstname,' ',lastname) as name FROM authentication.users
WHERE users.idusers IN (SELECT idcollaborator FROM
cpd.coursecollaborators where idcourse=64 and collabtype='Other
Individuals')

This should return a header as 'name', and so i should be able to bind
with this value. But it seems ASP.Net cannot find the header when i try
this.

Any ideas?

 

[chris.withers]

Hi all,

Usually when pulling a dataset from a DB I get the headers too, so i
can databind DataValueField and DataTextField etc. But I am trying the
below query:

SELECT CONCAT(firstname,' ',lastname) as name FROM authentication.users
WHERE users.idusers IN (SELECT idcollaborator FROM
cpd.coursecollaborators where idcourse=64 and collabtype='Other
Individuals')

This should return a header as 'name', and so i should be able to bind
with this value. But it seems ASP.Net cannot find the header when i try
this.

Any ideas?

Argh, this actually works. It was my own stupidity which caused the
problem.