[SOLVED] baaGrid Problem.

[shamilton]

I am currently messing around with the baaGrid class by Barry Andrew.

I have the following sql statement:

 

SELECT 
'<a href=\"?sortby=Name&sort=$nameSort\">Name</a>' = CASE Name
WHEN '' THEN '[Empty]'
ELSE Name
END,
'<a href=\"#\">Address</a>' = CASE Address1
WHEN '' THEN '[Empty]'
ELSE Address1
END,	
'<a href=\"#\">City</a>' = CASE City
WHEN '' THEN '[Empty]'
ELSE City
END,
'<a href=\"#\">State</a>' = CASE State
WHEN '' THEN '[Empty]'
ELSE State
END,
'<a href=\"#\">Zip</a>' = CASE Zip
WHEN '' THEN '[Empty]'
ELSE Zip
END,
' ' = CASE ID
WHEN 0 THEN '<strong style=\"color:red;\">ERROR</strong>'
ELSE 
'<div align=\"center\">
	<button type=\"reset\" id=\"viewButton\" onclick=\"location.href=''index.php?click=manager&section=1&CustNum='+ numb +'''\">View</button>
</div>'
END
FROM 
(SELECT TOP $max_results * 
FROM 
(SELECT TOP $depth * 
	FROM Customer 
	ORDER BY $sortby $sort) 
AS tempTable1 
ORDER BY $sortby $altsort) 
AS tempTable2 
ORDER BY $sortby $sort

 

You'll notice on line #2:

'<a href=\"?sortby=Name&sort=$nameSort\">Name</a>' = CASE Name

this still works...but no matter what it is set to...only the first 30 characters show...this sucks because it cuts off my URL.

 

Anyone got any ideas?

[LiamProductions]

Set a chracter parameter

[shamilton]

I solved it another way - but do you have a an example of your method?

 

I solved it by adding another function called setLinkHeader which is just like setLink but it only focuses on the headers.