TheunisP
Posts: 342
|
Posted: 09/01/2011, 7:12 AM |
|
hi guys, below my sql - it runs fine and returns row and values - I have 2 labels in a grid the problem is that labels arent displaying the values - it is correctly assigned, it has a text type for the label
SELECT Min(strEventJacketScheduleTimeStart) AS min_strEventJacketScheduleTimeStart,
Max(strEventJacketScheduleTimeEnd) AS max_strEventJacketScheduleTimeEnd
FROM tblEventJacketSchedule
GROUP BY intEventJacketKey
|
|
|
TheunisP
Posts: 342
|
Posted: 09/01/2011, 7:23 AM |
|
ok - I came over from ASP so just need to know does PHP have a limitation on length of the name of the field you return? I changed the 2 AS to min_Time and max_Time and it works now - so the only difference is the length of the names?!
|
|
|
mamboBROWN
Posts: 1713
|
Posted: 09/05/2011, 10:34 AM |
|
TheunisP,
How large is the name of the field that you are returning? I would think that PHP could definitely handle it (assuming that the field name is not a million characters long).
|
|
|
TheunisP
Posts: 342
|
Posted: 09/05/2011, 10:48 AM |
|
According to the PHP docs - the lib it uses for MS SQL can only handle 30 chars for a field name - it truncates the field name without telling you
sad but true it seems
ps. it also cant handle nvarchar - so my PHP test is going nowhere fast
|
|
|