I've done a number of product catalogs/galleries with one or two category levels (Category > Subcategory). The straightforward way to do this, of course, is to use database fields for Category and Subcategory and query off of those fields.
I have a client now who is interested in what sounds to me to be an unnecessarily complex catalog with an as of yet undefined number of category levels at their disposal.
My initial response would be just to add more levels of subcategories to the database, but I was wondering if anyone had come up with a system allowing the dynamic addition of an unlimited number of subcategories to a catalog, and would be willing to share your methods. Or, if I should just stick to the obvious plan.
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.
We are looking replace site server's catalog search application. We need to crawl a public website and allow uses to search indexed pages. We need a product to index our site and index custom meta tags we put in our pages. What website crawling products are available in the marketplace?
I'm trying to set up a full text search engine on my corp website. Due to the number of documents to be indexed and the strain IS can put on as server, it was determined that the Indexing Services should be run on a dedicated box, instead of on the webserver.
This all makes good sense until I actually try to connect to the catalog in my code. From what I can tell, IIS looks to the local machine for it's catalog sources. Does anyone know if it is even possible to remotely connect to an index catalog?
I've tried adding the server namespace to the catalog name in many different syntaxes, and so far nothing has worked. Code:
I code that creates a calendar for each month and then it displays events from that month that are stored in a db. I need to loop through my recordset and display all the events, but I can't quite figure out how to do it. I am thinking I need to do an array. But I am not really sure.... any ideas. Here is where you can view the calendar. Code:
Ok, I have a Javascript ASP and in it I have a dynamic repeating table with certain attributes to people. If one of these attributes is old or invalid, i want to change the color of the text (and maybe make it flash, blink, change size, something) so that it's easy to read.
I want to create textboxes dynamically but with dynamic names also.
i am retrieveing a load of values from a table in SQL into a DataReader. Then i want to create textboxes from those variables. I want to dim various textboxes with different names depending on what I retrieve from SQL. I tried the following:
dim dtrcondet.item("contact_detail_description") as new textbox()
I am trying to create a site that has dynamic page generated based on if a value is present.
PROBLEM I want to be able to show a certain dynamic page if a certain value equals to true. The page should be able to generate values from a db e.g. <%=aspscript%>
And if the value equals to false, then the page should not appear at all. I tried using SSI (Server side inlcudes) but cant append variable names to it or use them with if then statements
I would like to have some text appear in a different color if it matches a result in a database. I am not sure how the syntax would work, this is what I have come up with so far. Not sure how to insert it.
If <%=(Picks.Fields.Item("Pick1").Value)%> = <%=(Results.Fields.Item("Pick1").Value)%> then class="style1"
Is this possible? and if it is does it have to be entered for each occurance of the dynamic text or can it be added to css?
i want o make the images on my website depending on who is logged in. I have all of the Images names stored into my database, which i have uploaded there using the Pure ASP upload 2.09 add on for dreamweaver, and that all works fine and my image is stored in the correct folder and the name of that image is stored into the database as imagename.gif which is exactly what i want, but i dont know how i need to declare that value from the database into my style sheet. Code:
I need to create a bunch of sites with slightly dynamic CSS. Basically, all the image paths in the CSS need to be dynamic, depending on the values of certain ASP variables. I can think of 3 ways to do this: 1. Write a script to create a semi-dynamic CSS file, which will be run whenever we need to make changes to the ASP variables controlling the image paths. 2. Have an ASP script generate the CSS on the fly:
3. Put all static CSS in a normal CSS file, and have a special dynamic style sheet for only those rules that require variability. We could either use method 2 above to generate a second style sheet, or place dynamic rules directly in the actual asp pages.
how to dynamically build an XML document with IIS6 and 404 error custom handler? At the moment if I dinamically create an XML page with Response.Write(xml code here) I cannot remove header "404 errorpagepath" that IIS adds automatically. How to remove that header from Response object?
i think my code is correct.but it still can't work when i run in the nokia mobile browser,i had run my wap gateway and internet service server(ISS) also.
can anyone help me to solve this problem? The attaches file is the wml,asp and database for this program.
i want to have a dynamic navigation that will look at a database and then fill the navigation side. I want to have a category, then a sub- category also. Can this be done?
it's a dynamic form which should show which option is selected. I've made zillions of these before, and this should work no problem, but there's a bug that I just can't see somewhere... Can anyone see what in god's name I'm missing? Code:
I have been searching for tutorials everywhere on how I could make a menu that is multi levels but that can be updated dynamically through asp...so basically when I add a link in the database it will update the menu...now I know how to pretty much pull links from the database for a basic menu...but lets say there is a link called about us and under about us there is more options to choose from.
How would i code this so the menu would know which ones were parents and which ones where childs? And does anyone know of a good tutorial, or of an example. and basically I want this because I would like to create a content manager...but I don't understand how the menu would work when pulling data from a database.
Is there any way to dynamically generate an include file based on a variable passed to the asp page via a url ?- so for example:
Person x clicks on a url - that ur directs them to template.asp (template.asp has no code in it other than page title etc and <!--#include file="<%variable%>" --> )
Once in template.asp the page loads the include file that is relevant to the companies website that the link was clicked from.
In that include file will be the correct form and stylesheet setting for that company.
What we are trying to do is achieve a global template file which multiple customers can direct peo[ple through and all the data is therefore stored in one central repository.
The file displayed when they reach template.asp will depend on the url they clicked. Basically how can i get the url to pass the variable which the include file will then load??
I am having to make sites accessible where images are dynamically generated.
'Display the graphical hit count
Response.Write("<img src=""counter_images/") Response.Write(Mid(lngVisitorNumber, intWriteDigitLoopCount, 1) & ".gif""") Response.Write("alt=""" & Mid(lngVisitorNumber, intWriteDigitLoopCount, 1) & """>") How do I include the width and height attributes in this code?
I currently have a form with 5 rows of textboxes (one textbox on each row). I would like when user keyed in something in the last textbox (textbox at 5th row), it will automatically create another row of texbox below it. Can someone please advise me on how I can do that?
For some of my pages I currently have part of the URL as being 'ourservices.asp?ID=1' (its got nothing to do with sessions) and I am currently changing part of it so its more SE-friendly - i.e. 'ourservices.asp?services=website-marketing'. However following Googles guidlines regarding dynamic URL's,. it says that some search engines don't crawl pages which have a '?' in them for fear of them being a session URL (which mine isn't). My question is- is there any alternative that I can use to replace the '?' with another character for my dynamic URL. Or, is this the only way I can have this dynamic URL?
i want to create a dynamic list or array in asp as we have arraylist in asp.net. what i want is that i want to hold the values selected by the user in a list and in advance i dont know that how much values the user will select. i also tried to use array with redim but that did not work as we can create array with only constant integer parameter.
I've been writing a website for dynamic access, meaning any customer can login to their website (I run a website business) and edit pages. However I'm having a delima of how I should write this part, I'm storing everything in a Access database and accessing it using SQL. The user can create a link, and then select the page it links to using a dropdown list to create links on the navigation menu. Now they need to create the page, and I'm wondering how I should store this. Should I store ALL the code (including the ASP?) into a Memo field inside access, or should I create a 'first half' asp page and a 'second half' asp page and then have my system store all the content and stuff into the access field? So basically the page would be assembled somehow: ASP Part 1 - Starting Code Content grabbed from Access Field ASP Part 2 - Closing Code and then just store the Content inside the field? If so, should I create 2 include files and then tell my system to make a new page, include part1, store the content, then include part2?
I have a variable called section. I'm trying to include the value of "section" in a server.execute so I can dynamically include a particular file based on that value.
im trying to create a dynamic sql query based on form user input in ASP. The sql query is then used to filter through a table i have in access. So far i have managed to work with the below code which uses the input from the form and puts it into SQL format.
My form has a field 'PositionTitle1', PositionTitle2' and 'PositionTitle3' all pointing to the one field in my access database. My problem lies in adding functionality for the 'OR' to be used instead of 'AND' in this situation, so that i can place a value in 'PositionTitle1' and 'PositionTitle2' and both will come up in the filtered query.
Any suggestions on how i might be able to alter the below to accomodate for this?
I'm trying to making a form which can filter the search results. Some of the infomration is in text boxes and other search options are in dropdowns. this is my current query: Code: SELECT DefendantCase.VBKey, DefendantCase.PointValue, DefendantCase.CaseNumber, DefendantCase.LastName, DefendantCase.FirstName, DefendantCase.MiddleName, StatusDescription.[Description] AS Status, ProsAttyDescription.[Description] AS ADA FROM DefendantCase LEFT JOIN StatusDescription ON StatusDescription.StatusID=DefendantCase.StatusID LEFT JOIN ProsAttyDescription ON DefendantCase.ProsAtty=ProsAttyDescription.ProsAtt yID WHERE LastName LIKE '" & lastname & "%' AND FirstName LIKE '" & firstname & "%' AND DefendantCase.StatusID IN("& statusid &") ORDER BY DefendantCase.LastName, DefendantCase.FirstName
I dont even know if ASP is the right language to be doing this, but what I am basically trying to complete is a way for a dropdown box to come, and depending on what they select data will go into a table. For instance, the dropdown will what type of taxpayer they are and if they select individual, the offered services will appear in the table.
I have a serious question here. Two websites: www.morepoweracing.com and neil.morepowerracing.com.
I am trying to build a menu system which is dynamic, and the live site, www.morepoweracing.com is what is going on right now. The test site is neil.morepowerracing.com and I am trying to make my menu dynamic so it feeds off the sql database. Secondly, I need to have a .5 second delay just like windows XP, becuase when your mouse is scrolling over from one button to the other, it tends to dissappear the menu you are looking at. Also, all severs are in house, so if you need me to copy the code down
i'm trying to create a function that will return an image of a specified width and height. rather than simply resizing an image and retaining its fat filesize, is there a way to create images on the fly from an original? i know it is possible in php, but the server i am working on doesn't have it
