ASP & MySql

Romi · Post by **Romi** » Fri Dec 30, 2005 6:32 pm

I'm moving from the js files to a db driven menu. And I have a couple of questions.

Is there another way to sort the menu items. It seems to be sorted how the items are inputed. The only way I can change the sort is to export, change sql, delete table, and recreate table. I tried to edit the default.asp to sort (ORDER BY) itemid. But I cant get the query right. Here is the line (line 124 from default.asp) I am trying to edit:

Code: Select all

query="select * from "&table_prefix&"items where menuid="&rs2("menuid")

Second Question
I have dotted borders. In the js version, I see dots in both IE & FF. In the db version, I see dots in just IE and not FF. Any ideas

JS version
DB version

Post by **Ruth** » Sat Dec 31, 2005 8:02 am

Hi,

I can't answer about the sorting, but I think the border problem is a result of bordercolor="#"; I think FF needs a color specified? That's the only thing I notice that might do that.

Ruth

Post by **Ruth** » Sat Dec 31, 2005 11:07 pm

Hi,

I just realized that a user posted an asp menu editor they created. Perhaps this is something you can use? I don't know anything about asp/php/mysql so not sure if this is something you can use.

viewtopic.php?t=6437

Ruth

Romi · Post by **Romi** » Wed Jan 04, 2006 12:55 am

Thanks for you help on this Ruth. Defining the bordercolor solved the firefox issue.

The asp files created didnt work for me... but I am still working on it.