Mssql Database Driven Spry Type Horizontal Menu
how to create asp spry type horizontal menu that is populated from a mssql database. Only able to find help for asp.net, need help for strait asp.
View Replieshow to create asp spry type horizontal menu that is populated from a mssql database. Only able to find help for asp.net, need help for strait asp.
View RepliesI 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>
<%
Names.MoveNext
Loop
Response.Write "</TABLE>"
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?
View Replies View RelatedDoes 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.
View Replies View Relatedwhat 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" ?
View Replies View RelatedI 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#.
Firstly, apologies if this is the wrong section!
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 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 need web based mssql database manager.
features
create table
edit table
del table
add-del-edit records
and free
What I need to do is connect to my database server from my webserver [which are both in my LAN] and bring back some data and allow the end user to search through the data.
Is ASP the best way to go about this?
I am currently writing a little gadget where users can create, delete, alter... tables in a database. Some kind of MyAspAdmin... Everything works fine as long as I specify the MSSQL-Login-Infos database, user and password.
But if I want to make it possible to switch from one database to another, here comes the problem: The user has to choose a database that he wants to work in, and type in user and password.
I need the (probably very easy) solution, how i can check if this user/password/chosen_database combination is correct. Code:
Can anyone recommend, pop up /hover menu that populates data from the database? At the moment we are using http://dhtmlcentral.com/projects/coolmenus/ but it seems to take a while to load. I'm just wondering if there is more efficient script available.
View Replies View RelatedI have a dropdown menu (HTML's form->select) i have options in it, and I need as soon as one of the options is chosen (onChange)to update my database's (mdb) field
like this:
mdbVar("some_field")=1
mdbVar.update
that simple, but i cant figureout how to connect the onChange to this code.
I've created a web form that will post to an Access database. All of
the form fields correctly save to the database upon submit using:
<td><font face="MS Gothic">Site:</td><td><INPUT TYPE="TEXT"
NAME="Site"></td>
Below is what I have for one of the drop-down menus. Could anyone help
with how to add the VB code to this so that the selected menu item
will submit to the database as well? Code:
what is code for populating a list menu with data from a database. also the default(first) option in the list should be "ALL".
View Replies View RelatedHow would i make my navigation horizontal. I currently have an unordered list but it all lignes up vertically which i dont want as i am trying to replace a table with a css navigation system. Code:
View Replies View RelatedI need to create a drop down list that will auto Generate numbers from 1-60.
So when they select the drop down list, it will display 1 thought to 60.
I want to display records horzontally in columns and rows.
For example
Record 1 Record 2 Record 3
image image image
text text text
Record 4 Record 5 Record 6
image image image
text text text
Then if there is more than 6 records. I would like the next button to display. This is for my project like and I have not got a clue how this works!!!.
Let's say I have a dynamic list/menu, which gets its values from a
database table, for example a list of contact people where the value is
an ID number and the label is the name. However, if the value the user
wants is not in the list I would like to place a hyperlink which
will...
(1) open a small window, with an ASP form to allow the user to add a
new entry
(2) save the entry to the database
(3) add that value to the list/menu in the parent window and make it
the selected option
(4) close the small window and return to the original window.
I can handle the code for 1,2 and 4, but 3 is what I'm not sure about.
I don't like the idea of forcing the user to leave the current screen,
go to some other form, add the entry they need to the lookup table,
then come back; this seems like a logical approach, but just wondering
how to make it work.
This seems like a common enough situation; anyone have any code samples
or suggestions about how to do this?
I have an image database, I want my images to be displayed like google when you try to search an image - displays horizontally.
How would I check if the first row already has, say 5 images, and then add another row for the next set of images and so on?
can someone show me a tutorial, an article for this one?
mine doesnt require to search for any images, just concerned with the display.
i am stuck on this issue from morning i am displaying 6 horizontal pics on a page i want 3 pics on each row and below is my code for it what i am trying to do is display the pic and then below the pic write the name of the pic write now what my code does is display the pic and display the name at the side of the pic which is wrong Code:
View Replies View Relatedi have 25 fields on a form vertical display and i want them to be displayed horizontal. i want to support my idea of horizontal display to my manager the reason why i want horizontal display is because the user wont have to scroll down. so i need some articles from the web or technical articles which support my idea.
View Replies View RelatedI'm having a bit of a problem and I can't seem to fix it. I have a page which brings back the results from the database and instead of the results being Vertical, I would like them to be horizontal.
I know the answer is something like RepeatDirection="Horizontal" but as I am not an asp expert and it is a ready to go package that has crappy support... Code:
I want to find out what type of Access database (97 or 2000) I'm running, from an ASP script.Is this possible? If so, how?
View Replies View Related<%
Option Explicit
Dim oConn, sConnection, SelectValues, ItemData
Set oConn = Server.CreateObject("ADODB.Connection")
sConnection = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=c:sitesSingle16aoawebdatabase
otars.md b;" & _
"Persist Security Info=False"
oConn.Open(sConnection)
SelectValues = "SELECT * FROM agents WHERE aid = '" & Request("aid") & "'"
set ItemData = oConn.Execute(SelectValues)
%>
Microsoft JET Database Engine error '80040e07'
Data type mismatch in criteria expression.
/admin/viewfullnotary.asp, line 10
I am trying to insert the fields into the DB by quering an insert statement in my form
i get the following error on line:
objConn.Execute(strSQL)
Microsoft JET Database Engine (0x80040E07)
Data type mismatch in criteria expression.
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?
Does anyone know where I can find any resources for dynamically creating pop out menus using a database backend for the links?
View Replies View RelatedI 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.
View Replies View RelatedI 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.
View Replies View Relatedwhen 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?
View Replies View Related