I want to create a breadcrumb trail on a site, but instead of being
generated by cookies or a directory structure, it needs to be database
driven. My website details hundreds of products, each belonging to a
category. Each category can belong to a parent category, and so on.
My site will feature master/detail pages, and both need to feature a
trail, e.g.
Books > Hobbies > Sport > Football
The master page will list all items within the current category, and the
trail will allow the user to click to any parent category for a wider
listing.
The detail page will show the item detail, along with a full trail to
the category/parent categories it belongs to.
The category structure will grow over time, and different branches will
have different number of levels so it needs to be maintainable.
I am trying to create a URL from a list of names from a database...it showing up blank. Trying to pass ID and Name as parameters too. the code I tried is below, thanks in advance.
NAMES.Open() Names.MoveFirst Response.Write "<TABLE Border='1'>" Do While NOT NameS.EOF %> <a href="access.asp?intID=<%Response.Write(Names("ID")) %>&strName=<%Response.Write Server.URLEncode(Names("Name"))%>"> </a>
I have found some code on the net and been given permission to use it. However I wish to connect this code to a SQL Server database, so what would I use? I am mainly an ASP/HTML/JS user but it will not let me use the standard VB script on a .xml page. How do I connect my XML to the database?
Does anyone know where I can find a free simple script to create a search engine using Access Database backend and will allow the user to type in a word (not a using drop down list) and it will search the table.
what i want to do is create an image gallery, that when u click on a picture it opens in a pop up with the images caption and name there also. I've stored the captions and image names in a database - images.mdb table - Images
I just need a page now that sorts it all out to display the correct image, caption and title in the pop up. The images are stored in folder images and the database in the website root directory.
i've read a couple of articles on various websites, and played with the image gallery wizard on Frontpage but the websites dont explain my problem, and i cant adapt the gallery on frontpage. I'm a bit of a novice in ASP so I would really appreciate it if you could some how make the bits of the script I need to change standout.
I always heard the term "data/database driven programming" model in ASP database, SQL programming, and web programming circles. But I don't quite sure what does it mean? Does it mean the web software's responds are based on data request from the user? Just like in Windows, we call it "event-driven programming" model because the windows program's responds based on user's responses? That's why we call "data driven programming" ?
I want to develop a site with the following features:
1. A movie library (DVD's, VCD's etc) 2. A database 3. search by category, title, actor, etc 4. membership signup 5. tracking system for lent out titles
Now am new to ASP just dived in am using Visual web developer express edition. Please point me in the right direction on the best way to do this. Am self taught kind a person and will not take me a long time to get the hang of it once in the right direction. Am not conversant with Visual basic or C#.
Ive created a site using ASP and an Access database. At the moment the database is unprotected, and I haven't used any usernames or passwords to access the database. Now that development of the core site is almost complete, i want to secure the database.
I have this file called "inc_BreadCrumbs.asp" basically this is a Navigation include file as breadcrumbs style, and I inserted this to every page in my site. It works fine but one thing I cant configure is that:
It displays the file names as for example: search.asp or results.asp etc... But i want it to display as SEARCH or RESULTS etc... How to implement this? Can it display only page title name or something else how can you change it? Code:
I'd want to make a custom class that will generate breadcrumb navigation for my site via a recursive query, e.g. Home > Page1 > Subpage 1. I've structured my database with hierarchical parent/child relationships.
I'm using ASP VBScript, and I have a table structure similar to the following: Code:
I want to create a database and its tables and populate it through a web page, using ASP. The database is MySQL on win32 (4.10.13-nt) and the driver is MyOLEDB 3.0.
One thing, to set up the ole-db connection, it seems I have to specify a data source, which is an already existing database.
The Connection works and I actually can create the database, but the code for the table creation generates a 500 server error. The SQL itself is taken straight out of MySQLcc query window, so I know it's all good, syntactically.
(Also, regarding the connection, I can connect to and read from an existing database. It's the table creation that seems to be the trouble.)
I did a response.write to the page to make sure that the code coming out is what went in and that is the case. So, I guess one question is, what could be different about creating tables in a db that would fail, when "create database test_links;" and "use test_links;" both complete successfully (and the newly-created database shows up, just no tables in it).
To test the sql, i made three strings of SQL and executed each of them sequentially. The first two work, the third (table generation) fails.
A second question is, is there a way to capture any error message that might be generated at the MySQL end, rather than having the page bomb out; and then display the error. I tried using a RecordSet object, that didn't work, the page still crashes.
Is it possible to create a database of any sort not only Access using nothing but code?
To this day I still create databases using Access on my hardrive then upgrade them and use code to modify them... would be very convinient if there was a way to just create with ASP code and edit from ASP as well...
i have to do a code in ASP that including this code:
set c=server.createobject("adodb.connection") c.open "dsn=MyDSN;" c.execute "create table first_tables(Name char, Tel char)"
and i am geting that error:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E09) [Microsoft][ODBC Text Driver] Cannot modify the design of table 'first_tables'. It is in a read-only database. /1.asp, line 4
Does anyone know of a database system available in which users could establish a user name and password to register products, buy merchandise and access a message board? I have moderate asp skills, but have no idea how to write or where to purchase software to create this database.
I need to create a chart/graph with the following data from my database:
Each record is opened and then closed at a later stage. I then calculate the time it took from when the record was entered to when it was closed.
Now i need a pie chart to display how many records was closed in certain times. for example 10 records was closed within the first 10 minutes, 2 in 20 minutes and so on.
this also is to happen for dates that the user entered. i.e a Weekly report and a monthly report.
Any advice and help will be appreciated. I found alot of examples of hardcoded graphs but none extracting data from database.
So first i need to count the records that fits each section of minutes and then use that data to draw my graph?
I am using a repeated field to bring in to my page repeated records, and I have been able to retrieve values that are entered into text boxes that are associated with these repeated fields. I would like to post these values into a database, but I'm not sure how to set up my table as I know that each employee's values as well as number of fields will be different.
I thought about setting up two tables. One that houses the dynamic question and the other to house the answers, but I'm not sure if that will work. I could really use help as to the syntax to write a loop statement that will insert my returned variables and create the field names dynamically into my database table. I believe this is what i need to do.
I am tryin to create a database of users for my system,each user is given a username based on their own name(surname and first name), however if 2 users with the same or similar name enter their details they will be given the same username,for example john drew would return drewj as thier username, so would jack drew, when a new user is entering their details how do i check that the username generated for them does not already exist,i.e i need to compare the username generated for the new user with all usernames already held in the database,if the username does already exist i want to add a digit to the end of the username how is this done using asp?
I have created a database connection function which I use to open my database connection and recordset and another to close it. Easy stuff I know. The problem is this.
I want to be able to create database conenctions and recordsets specifically when I call the function. For example Code:
I am using an Access database, and for a field called size the client entered some values such as 20" x 20" Unfortunately when I try to print that field to the page, the cursor stops typing at 20 because I'm assuming it considers the first " inside the 20" x 20" to be the end of the string.
I am simply trying to print the whole string <%=(rsProdsUpdate("size1"))%>
Is there a workaround this without having to change all the values in the database?
My client has 35 domains (web addresses) that they want to host on a Windows 2K box with IIS 5. They want one application built using ASP and SQL server, hosted somehow on the IIS so that it appears as the same application for each domain. The end user of each domain will actually be using the same application.The head of each of the 35 domain, or the jr. web master of each domain should be able to cutomize the look of the each of their domain. This customization feature would be built into the ASP application. Things that can be changed would be some text, color of text, size and color of input boxes. This application will be similar to some of the eCommerce sites that have a web interface for their merchants to be able to modify their individual sites. Sort of selecting and modifying templates. They want 1 application so any changes and update of the application will reflect on all domains.My question is how do I start designing this? Where can I get info on this project, any opensource stuff I can look at? Do I incorporate XML anywhere?The domains will be accessing the same DB, how do I minimize DB trips?
I just got in charge of a weekly online magazine. I was wondering if there are any webmasters out there who might recommend a good ASP driven CMS for this task, better if free.
I am looking for info and maybe an example on a database driven dual drop down. I need the second drop down populated by the selection of the first drop down.
when doing a dynamic site such as this, how does one handle the articles? is the whole article dropped into the db? or does it sit somewhere else and the db just references it?
i'm going to convert a large static site over to asp this summer and am starting to plan the architecture and i haven't really been able to find the answer.
I have 3 websites and make use of free counters provided by other web hosting companies to count the no of hits. Now I want to install a multiple-user databased driven asp counter (with initial value setting) in one of my sites to provide the statistics. I try to use the google search to look for a free script but to no avail. Anyone know of a free asp script that I could use for this purpose?
My client has an annual calendar of events consisting of a record for each event, key field is the event date saved as a date type field. They would like the display to start with the current month, list to the end of the year then start the beginning of the year and list up to the current month.How does one retrieve data based on date? I guess I'd like something like :
SELECT * FROM EVENTS WHERE [month is greater than or equal to the current month] ORDER BY Date
Then :
SELECT * FROM EVENTS WHERE [month is less than the current month] ORDER BY Date
What is the syntax for the month bits between the []?
I'm currently in the middle of the most advanced ASP project I have ever worked on, and was wondering if I can get any feedback on what anyone thinks about it so far (or suggestions for improvement later, etc.)
Basically, it will be a single core set of ASP files, that will allow anyone to set up a webpage in minutes by simply selecting a pre-developed site template, and pre-developed site plugins (a plug-in being anything from a menu, to a CC processing tool, etc.), so that user's can simply "manage" their site look/use rather than program everything over and over again. In the end there will even be an import to instantly convert any existing site.
Developers can build templates and plug-ins at will, and will be interchangeable on the site with the click of a link or button.
This project is planned to be open source but is still months away from completion, but to check out a sample of how it basically will work, we are currently testing it at URL.
I entered a whole year's worth of events. I want to display a range of events which change according to the date, so only 2 weeks later and one week earlier are displayed on the main page.
How did other people deal with similar issues? I know I can set a range mathematically speaking (date + 14 AND date -7). But did other people encounter other issues? How did you solve them?
Is there a way to have an asp page displayed with all the data from a db but not truly getting the data from the data base.
I want to perform updates to the data base and not have them "publish" untill I say go. I figured one way to do this is to have two tables (one live and the other pre-production) of the page and just copy the preproduction table the live table when ready. But, I read in some search engine optimization artcle that there is a way to basically have a pure html version of an asp db driven page so the search bots do not ignore it. Does anyone know of something like this?
Environment: Development PC: W2K Professional WebServer: W2K Server, IIS 5.0 Peer-to-Peer network
I'd like to create a new asp.net project on a remote server (not on the local (development) machine. I have looked for info on how to do this, but all I can find are instructions on how to create on localhost, then deploy later to remote machine.
