I want to put my existing review books webpage in Asp/Database because I have more than 5000 of them and its now too complicated to keep tracks of it all in HTML only. My database is ready, I know how to connect to it, how to list records and how to select in them, I know how to pass a variable from a page to another, I know how to add, modify and delete records... yeah its about that so far.
Here is how I want my website to look like. I want to have physical pages categories, like all the science fiction books should be listed in sf pages separated alphabetically Ex reviews of Lord of the ring will be in sciencefictionT.asp and so on for each categories. I want too that a page with all the reviews listed linking to the right place. In my database I have already categories for each books.So is it possible to do or I complicate my life too much?
I know that it would be much more easier just to make a review.asp and have the review one at the time there, but I like the way my website is already is, that make it different from others.
I am using MS Access & open 3 table, 1 for Product 1 for Genre, 1 more for Product_Genre (because one product maybe have many categories)
But when I have tried many ways to delete one of categories, also fail to do it.
What I want to do is : When delete a category,
1) it must delete the Product which is under the Category (to be delete) 2) at the same time it must also delete the records from table 'Product_Genre' which is related with the Category (to be deleted)Code:
I'm using Crystal Reports 8.0 and Asp. When i try to see my reports it show me an error "Physical Databse Not Found". Whether u run the repprt on server or on clent.
I have a list in a database that I have categorised using a category field. I now want to retrieve all records but grouped by categories. how do i get my asp to loop through each category creating a recordset for each one rather than hard code a new recordset for each category i would rather it did it dynamically if thats possible ??? Code:
i am working on ecommerce site and would like to display the categories (and sub categories) from the db recursively, i did it but i also want to add the level of each category like : main_cat_1 (level 1) --------sub_1 (level 1_1) --------sub_2 (level 1_2) ------------sub_sub_2 (level 1_2_1) ------------sub_sub_2 (level 1_2_2) ------------sub_sub_2 (level 1_2_3) --------sub_3 (level 1_3) main_cat_2 (level 2) main_cat_3 (level 3) --------sub_3 (level 3_1)
im developing a Product configurator (just like alienware use) where in my database i have (systems table) a list of PC systems
systemID (categories table) a list of PC product categories (ie. CPU, RAM...) categoryID (products table) a list of all products productID, catID (link table) sysID and prodID
Now before i put the code ive done so far, let me explain that the first page lists all systems wich then gives the systemID for the link table. Once this page loads it needs to go through each category then list the products available to that category where sysID = systemID. Now a query i put together to list all products for that sysID is:
select * from PRODUCTS inner join link on link.prodID = PRODUCTS.productID where link.sysID=systemID
Now this query works great and lists all of the products for that systemID, but what im unable to do is (using GetRows()) have the category name listed as a title then have each product under the respected category. Code:
I've got a products table and a productCategories table related by a categoryID field. The categories table uses autonumber for the categoryID and I've got about 4 or 5 different categories in there right now.
I'm creating an Add Product page now and I'd like to create a drop down menu with which to select the correct category. How do I make it so that my drop down menu actually shows the category names and then populates my tables accordingly?
I won't need to ever add a new category here, simply use the current categories in a drop down so I don't have to guess/remember which number is which category.
I have a default catalogue/product page (code shown below list_item.asp) which list all the products from the database. But since I have lots of category in the catalog/product page, i want to separate them according to their respective categories like writing instruments, desktops, pantry etc.
This will enable the user to go to a respective page and choose the individual product from the respective categories. If I adjust the SQL statement to be "SELECT * from Product " WHERE category LIKE 'DESKTOPS', this page will lists all the items from that category selection. But if i were to make another page such as pen.asp and adjust the SQL statement to category LIKE 'PEN'.
The first page lists the products from the pen category and the following page unfortunately shows category from Desktops. how to segragate these categories so that it will only show the products from the individual categories.
Please let me know how to avoid giving physical path & line number in the error messages of web applications. Instead i would like to replace it with general error message to the user.
I have created a dropdown menu that allows users to navigate and load other pages into a different frame (detail) than the one in which the dropdown is sited. All menu items and urls are stored in an access db.
Now I would like to try and make 2 improvements but I don't know how:
1. I would like to use the [Category] field in my data set to produce (non-clickable) headings in the drop down list. Code:
I've setup several FTP shares on IIS 5, where some of the shares are located on another computer, while other directories are on the local computer.
Is there a function similar to server.mappath that I can use to return the physical path of a FTP virtual directory using ASP?
For example, I have a virtual directory called TestA located at C:TestA on the local computer running IIS 5. I have another virtual directory called TestB located at DevserverTestB where Devserver is another machine on the network.
In my ASP code, I need to be able to access the physical directories directly and I would like to avoid having additional code to deal with hard coded directory paths.
Is there something similar to the command server.mappath("TestB") which would return "DevserverTestB"? This way, the physical path is transparent and I can treat local and network shares in the same way.
Is it possible to include my remote web server path eg: m:/html/root/site1 | m:/html/root/site2 etc
....in virtual includes....
Thus eliminating the need to create duplicate INC files in each sub-domain on my remote web server host domain IP. eg: http://72.3.5.6.0 (www.site1.com; www.site2.com)
I would like to be able to use a UNIVERSAL INC file in the root of my web IP for the benefit of all my sub domains.
If the physical path of a page is : " e:facecgi_bindetails\_Nviews.asp "
and i want to remove "\_Nviews.asp" portion from this path ...means whenever the page refreshes,no matter what the name of the page is ....the last portion of the name of the page with slash must skip out from this path string .....how can i do this while using VBscript Functions.....like using Split(),RIGHT(),LEN(),LEFT()...etc..
im looking for an asp (not .net) script based on a user forum where as the admin i can set up different users to only see related forum topics (i want to use it for project management) uploading files to the forum would also be a massive advantage!!!
I have a Physical path that I need to convert on the FLY I thought using Replace would be a good idea, and it almost works
function MapURL(path)
dim url2 'Convert a physical file path to a URL for hypertext links. url2 = (path) MapURL = Replace(url2, "", "/") MapURL = Replace (url2,"E:","http://myscs/docLibraryDocs") MapURL = Replace (url2, "IntranetLibrary", "")
end function %>
- Is it possible to have multiple replace on the same variable ? - am I doing it the right way ? or is it possible to concatenate those replace in one go ?
Is there a limit on how many Replace one can use for one variable ?
The problem I have is that it takes the first two Replace in consideration but not the third one. If I remove or comment the second one then the First and the third one works fine. For some reason, it doesn't like to have the three in the same time.
by the way, the link I try to change is as follow: Code:
Using IIS 5.0 and sometime some asp pages (absolutely randomly) showing as blank white pages. So far only one way of fixing it - restart whole server. Restarting IIS, or specific web server not helping, only whole server.
I enable server side and client side debugging, but no errors showing up...
In view source pages always look like this: ----------------------- <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=Content-Type content="text/html; charset=windows-1251"></HEAD> <BODY></BODY></HTML> -----------------------
is it possible to create pages using other pages. Here is an example... Can I make a page that has a menu on it, but the menu is actually a seperate page that I call with ASP?
We run a website with pages that are created using ASP. The website is used by different people from different networks. For some people, the pages are stuck. It looks like the were able to open the page, but it is not displayed on their browser. We think that it might be something to do with their proxy. Does anybody know how to solve this problem?
I had a 404 page set up in IIS 5.0 that would the the URL of the requested page from the query string. i recently upgraded to IIS 6.0 but it doesn't seem to put the requested URL in the query string as it did in IIS 5.0 and 3.0. Does anyone know how i can get the requested url property in IIS 6?
I have a bout 5 different pages of which each will contain a form requiring users to complete. These forms are all related as one project. It is necessary that if the user was to only complete the first form they could theoretically quit, come back later (time not dependant) and complete the remaining pages. Therefore I think the best way to do this is to write the values to the database upon each click of the next button. The only other issue with this is that the user will also be receiving a pdf file at the end of the full form submission with all their information inserted into this pdf and finalized. Now. I am aware of pdflib in which I need php but my choice was to do this in asp. What are my options here? Should I combine them, should I draw all the info from the db at the very end with php and then create the pdf, should I use sessions during the entire process
When asp.net pages are made in vs.net, loading on the local host displays the labels all in the top left corner of the screen. Also, all textboxes and image buttons are not even displayed at all. If pages are made on a remote server, they load perfetly fine, it is just the local host displaying them incorrectly. Is this a common problem?? I have iis 5.0 installed with windows 2000. i use the full version of vs.net to make asp.net pages.
I have a web site I've recently moved to a new provider.It has worked for years.On the new provider's servers ( Win2k Server .NET 1.1 ) my asp 3.0 pages often don't completely execute. Here is what happens: Most of the page starts displaying in the browser, then you see some HTML, then nothing. If you refresh a few times, the page finally completely loads. There is never an error reported during any of this.
I have installed IIS 5 on Windows 2000 Server and have applied all the neccessary updates and patches. I am unable to run any ASP pages on the local server. I am able to view the HTML pages though. I have checked everything but cannot seem to figure it out. I end up getting HTTP 500 for all the web pages.
I am trying to setup a demo server for an asp.net web site that is working on my real website. The demo is Win2K and I have installed .net framework and IIS, both successfully,I think. The problem is that when I try to access the demo site, the pages are not being served correctly - only lables are displayed, and not as configured. HTML pages display correclty. I tried to run aspnet_regiss, but get an unkown function error.
i can make a database, add entries to database, delete from database, but the only thing i want is "How to divide entries in Pages" like we can see in the guest-book etc Scripts. This is an Example: Quote:
Entries: 500 Pages: 1|2|3|4|5
how to divide the entries in pages, like 10 entries per page..?
I've got a site that's been up and running for a couple of years.I've added some new stuff and it looks fine on my computer. However other people are seeing the old stuff.
I've tried a manual refresh of both my browser and theirs but nothing, the URL's are identical . This is a real problem as i'm away for a month as of Friday and the site is needed for a project.
