ASP + Access database

Poster: diegoarbe
Dated: Wednesday March 29 2006 - 19:01:40 BST

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

thanks!

Poster: drumbo
Dated: Monday April 3 2006 - 20:49:36 BST

I run part of mine thru asp and MS Access

Poster: John
Dated: Wednesday April 5 2006 - 15:12:09 BST

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.

ASP + Access database

Poster: bertvlit
Dated: Saturday April 8 2006 - 17:31:51 BST

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.

Poster: drumbo
Dated: Monday April 24 2006 - 20:17:11 BST

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

Poster: bertvlit
Dated: Monday April 24 2006 - 22:11:10 BST

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.

Poster: drumbo
Dated: Tuesday April 25 2006 - 20:22:22 BST

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
%>
}