Forum Moderators: open
Database connection works, can add edit data etc
however i am making a page management system and things go a little pear shaped...
The pages are part of a access db table with an autonumber primary key for each page
I can add to the database, however, when i click on my link to edit or delete the page, iis gives me a 404 because it thinks the link is in the wwwroot\bin folder, and not in my wwwroot\mysite folder.
The link to edit or delete is part of a datagrid where two of the columns are hyperlinks, I have tried the option in dreamweaver that says site root or relative to document but it makes no difference. No mention of the bin folder is made in my code.
any ideas anyone? if you need more info give me a shout - I think it may be IIS to blame and not my code - the code is from a training book i am working through - Dreamweaver MX and Databases
You could post a little code here, or probably better in the ASP forum.
In fact, I'm going to move this post up there since it looks like an ASP issue.
Certain users who log on are allowed to edit the pages, so session variables are used
Then the page is split into two sections. If you aren't authorised you get the "soory" message.
If you are authorised you get the list of pages for that department, with edit, and delete links
I made a dataset and chose connection to access database, and selected the table. The fields were Department, PageID, and PageTitle. There was a filter to look for pages in the dataset that corresponded to the session variable sessDepartment.
Then I made a datagrid with those 3 fields, and turned the Page Title into a hyperlink. Instead of just typing the name in I hit browse, then typed the name in and when I okayed it it looked like this
edit_page.aspx?PageID={0}
the edit_page.aspx file is in the same folder
c:\inetpub\wwwroot\myweb
then when i connect using IE, i log on fine, the department pages show fine, and I can add content to new pages, which get a new PageID
However the link to edit_page.aspx is under the impression that it is in the c:\inetpub\wwwroot\bin folder
Dreamweaver Site Definition KNOWS that the site is contained in the myweb folder, so COULD it be something to do with virtual directories in IIS? I don't have much of a clue about IIS, (even less when it comes to Apache) as I'm just a humble Graphic Designer truying to transmogrify into some sort of programming geinius overnight, but like i said in my 1st post, the coding is from the book Dreamweaver MX and Databases so I don't think it would make a mistake and I have sat last night till half two scrutinising the code (ASP.NET VB for those who want to know - and I guesss you all do)- looks fine to me - all makes sense - no mention of a bin folder anywhere
