Jump to content

[SOLVED] baaGrid Problem.


shamilton

Recommended Posts

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?

Link to comment
https://forums.phpfreaks.com/topic/59665-solved-baagrid-problem/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.