shamilton Posted July 12, 2007 Share Posted July 12, 2007 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§ion=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 More sharing options...
LiamProductions Posted July 12, 2007 Share Posted July 12, 2007 Set a chracter parameter Link to comment https://forums.phpfreaks.com/topic/59665-solved-baagrid-problem/#findComment-296556 Share on other sites More sharing options...
shamilton Posted July 12, 2007 Author Share Posted July 12, 2007 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. Link to comment https://forums.phpfreaks.com/topic/59665-solved-baagrid-problem/#findComment-296561 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.