ASP + Access database

[diegoarbe]

Has anyone successfully implemented the menu with asp and access database?

thanks!

[drumbo]

I run part of mine thru asp and MS Access

[John]

Lots of folks using many different languages to work this system - .cfm, .asp, .php, etc. If you have ASP code in your data file, simply change the suffix to .asp, as menu_data.asp; i.e., nothing says it has to be .js.

Use the Search feature to find Topics.

[bertvlit]

Has anyone a example using asp and access.
I used the example in the package but cannot getting it to work.
Setup the database, put the scripts in place and run, but nothing shows up.
When i lookup in "View Source" on the screen i see the menu items in the source.
But again nothing shows up.
Please help, thanks in advance.

[drumbo]

bervlit,

it is possible - I have used ASP and MSAccess on my site (although with the latest version - it broke). If you need help I can try and help - not an total expert tho

[bertvlit]

Drumbo,
Thanks for the reply.
I made some progress myself.
I created the database and tables in MSSQL with the 'menu.sql' file.
I also loaded the tables with the CSV files
Then I noticed that the tables where a little bit different than I had in MSAccess.
So I exported the database to MSAccess and now I see somthing more comming on.
So there is some progress only I do not quit see how the tables are related to change the contents to get different menu items.
If you know the relationship between the tables that would be very handy as well.
Is there a smart and handy ASP prog to alter the menu. So I can change it to my menu items I like to use.
Regards,
Bert.

[drumbo]

I am afraid I don't know the relationship - mine was put together by a bit of a trial and error. Haven't seen any app although I believe Dreamweaver can be made to use the menu (thru templates) although this is way beyond my meagre skill level.

This is an example of part of mine - if it helps

with(milonic=new menuname("Main Menu")){
alwaysvisible=1;
left=30;
overflow="scroll";
style=HeadersStyle;
top=140;
aI("align=center;separatorsize=1;separatorcolor=#66CCFF;fontweight=bold;text=<%=header%>;type=header;");

<%
x=0
DO WHILE x <= ubound(split(session("MenuName"),","))
image = "image=/images/" + trim(split(session("Image_Name"),",")(x)) + ".gif;"
IF trim(split(session("menu_subitem"),",")(x)) = "0" THEN' changed here
response.write "aI(""" & image & "status=" & trim(split(session("MenuName"),",")(x)) & ";text=" & trim(split(session("MenuName"),",")(x)) & ";tooltip=" & trim(split(session("tooltip"),",")(x)) & ";url=javascript:mm_openUrl('" & trim(split(session("MenuURL"),",")(x)) & "?PGDesc=" & trim(split(session("MenuName"),",")(x)) & "');"");"
ELSE
response.write "aI(""" & image & "showmenu="& trim(split(session("menuname"),",")(x)) &";text=" & trim(split(session("MenuName"),",")(x)) & ";tooltip=" & trim(split(session("tooltip"),",")(x)) & ";"");"
'changed the first two sessions
END IF
set image= nothing
x=x+1

LOOP
%>
}