241 Posted June 3, 2004 Share Posted June 3, 2004 I have installed the contribution Infobox Admin which has generally screwed up my layout due to the way it sorts the number location. It counts in the alphabetic 1,10,11,2,20 etc instead of 1,2,3,4,5,6,7,8,9,10,11 etc does anyone have a quick fix for this Quote No longer giving free advice. Please place deposit in meter slot provided. Individual: [=] SME: [==] Corporation: [===] If deposit does not fit one of the slots provided then you are asking too much! Is your Osc dated try Phoenix raising oscommerce from the ashes. Link to comment Share on other sites More sharing options...
241 Posted June 3, 2004 Author Share Posted June 3, 2004 Is anyone else using this contribution having this issue. I have had to number my boxes 1,10,11,12,13,14,15,16,17,18,19,20 in order to get a sort order of 1,2,3,4,5,6,7,8,9,10,11,12 for both left and right columns if you use the convensional 1,2,3,4,5,6 etc then it will mess up your box orders. Quote No longer giving free advice. Please place deposit in meter slot provided. Individual: [=] SME: [==] Corporation: [===] If deposit does not fit one of the slots provided then you are asking too much! Is your Osc dated try Phoenix raising oscommerce from the ashes. Link to comment Share on other sites More sharing options...
241 Posted June 3, 2004 Author Share Posted June 3, 2004 Could the issue be here with the sql location varchar(64) NOT NULL default '', this is giving the chance of 64 characters as location is entered by number should this not be int as in location int(5) NOT NULL default '', anyone any ideas or is it just me. Quote No longer giving free advice. Please place deposit in meter slot provided. Individual: [=] SME: [==] Corporation: [===] If deposit does not fit one of the slots provided then you are asking too much! Is your Osc dated try Phoenix raising oscommerce from the ashes. Link to comment Share on other sites More sharing options...
Guest Posted June 3, 2004 Share Posted June 3, 2004 If there are only numbers, then yes, INT should be the column type - check for any 'order by' clauses in the query if its still a problem Quote Link to comment Share on other sites More sharing options...
241 Posted June 3, 2004 Author Share Posted June 3, 2004 Thanks for that conformation Matti and yes the 'order by' is set to location. I changed this as a temp solution to order by sort_order with the location as varchar that would probably explain why the sorting was being done alphabetic rather than numeric. Would that be a correct assumption Matti Quote No longer giving free advice. Please place deposit in meter slot provided. Individual: [=] SME: [==] Corporation: [===] If deposit does not fit one of the slots provided then you are asking too much! Is your Osc dated try Phoenix raising oscommerce from the ashes. Link to comment Share on other sites More sharing options...
Guest Posted June 5, 2004 Share Posted June 5, 2004 Hey, I am having a problem with the spacing of the info box. It looks like there is a link but it is nothin just an empty line? any ideas? Thanks Danny Heres the link to the problem...i print screened Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.