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 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 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.
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 Replies View RelatedVB is relatively new to our company and I am putting together some eneral guidelines for people to follow when deploying their pplications.On the General Tab of the Project Properties dialog,there is a threading model section.Is there a general rule of thumb I
can put in my guidelines that people can use to determine:
1. When to use apartment threading vs single threading.
2. Whether to use Thread per Object or Thread Pool.
3. If using a Thread Pool, how many threads.
I'm about to start a project,the idea is to have a web interface to let
user specify the URL of a target HTML document,
based on that URL, retrieved and parsed the HTML document using the DHTML
object model exposed by ActiveX
control WebBrowser, getting the position and dimension of each node inside
the HTML document, processed it and pass
the result back to the user as a new HTML document.
I understand by using webBrowser control, it will means load of works for
server and is not recommended, but I couldn't
find any other solution that could get the DHTML object model, specifically
those dimension info for nodes, eg: *.clientWidth,
*.clientHeight, *.offsetheight, etc. or perhaps there are better ways?
I am in the process of evaluating an ASP application and I have come to
realize that I am a little unclear as to what exactly the ASP chacheing
model is.
As I understand it, ASP will cache a script engine and HTML pages
created from that engine. But what about the actual scripts and the machine
code they compile down to? In other words, if I refresh the same ASP page
does that mean that the script contained within that ASP page is recompiled
/ re-interpreted?
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 need some help to find a way to pas a asp variable in to the ssi include file commend
i have tryde to pass the varible like this:
<!--#include file="sets/<%=a1%>.asp" -->
that didn work for me so i tryed this way instead
a2 = "<!--#include file="sets/cenarion.asp" -->"
<%=a2%>
that didn want to wark either
im little lost how to get this to work im not sure if its even possible .
what im trying to do is pass the A1 varible to the include fille command couse A1 contains the name of the file. A1 gets its info from a request.querystring
what software do I have to use for doing programming in asp and php. Atleast I want to learn basics.
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 RelatedI am developing a blackjack game which is multiplayer, multitable game in which 4 users playing on each table.
There are 8 tables like this.
I am generating random cards through my random card function. Main problem is that I want to track cards for avoiding repitition. I can use application veriable for one table . But how to do for multitable ? We can't track it on session side as well as application side as all tables are in one application.
Can any one tell me how many programming languages are there in the world? I tried to google it but could not really get an exact or complete list of them all.cheers.
View Replies View RelatedI think following code makes just one page Landscape. It restricts the range of document. But I can run this code in asp. How can I convert this macro code to asp code?
ActiveDocument.Range(Start:=Selection.Start, End:=ActiveDocument. _
Content.End).PageSetup
..Orientation = wdOrientLandscape
I am building a site that offers the purchase of information. Clients can view a limited amount of info then they are able to view each recset in further detail once they purchase it. I am running into difficulties of how to facilitate this. I am using dbquicksite3 to build the ASP (I could do it on my own but it would take much longer). I am using Access 2000 for the DB and this also seems to be limiting me somewhat). I want to keep it simple because it is not a broad reaching website (probably several hundred recsets of purchase info and hopefully several thousand customers). Anyway, the problem is that I have a search for the basic results, I have a basic results page but I cannot figure out how to allow users to access only the pages that they purchase right after they purchase rather than watching my email account and sending the query results back via email. I suppose I could built a 'watcher' app that could parse the email from paypal for the order number and query my DB for the paidinfo/basic info results, combine them and send out an email in response....
Is this the best way? I have a log in but 9 levels does not help considering I have hundereds of recsets of info that can be purchased and if I give access by levels they would be able to view all in that tier.
I have an Access Database consisting of 10 Tables 1,table10. I need to add a new column to an existing table (e.g., table 1) without affecting the existing data in other columns.
How can I add a new column to an existing Table via ASP programming.
Why doesn't anyone ever have problems during the night when i'm not working and can post then? Why do karsh and vlince get to answer every question? And if they have jobs where they can post all day why can't i have their job?
Does no one out there feel like answering? Doesn't anyone program during the night? I know plenty of people that work the 2-10 shift, why don't they post at night? or do we need to wait for college kids to ask how to do their homework again.....It's getting to be that time of year.
What is the best or most used software for programming in ASP and/or ASP.NET? I will mostly use to program web pages. I like to know if Visual Studio .NET will allow me to program web pages using ASP and ASP.NET.
View Replies View RelatedJust started learning ASP, seems like lots of people use VBScript to program with. Though, I have spent the last year learning Java. Just wondering if I can use this to program with? along with its API's ?
Also, is it worth while to learn VBScript ? Is it industry standard or needed? Im guessing it is from the way its the language used in most ASP books. Any insight would be great.
I have 60,000 records and each row/record has one cell that contains additional 100-200 lines of data (tab delimited i believe) .. weird format. So what I need to do is extract those data in that one cell into separate records, duplicating the fields with it.
Lets say i have one record and the record has about 10 columns of data. Column C would contain about 200 additional lines of data. I need to extract that and insert new rows to insert these data into individual records.
guide me to start asp programming and shortest tips.
View Replies View RelatedMy 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 []?
My page sends an email using CDO to a username pulled from a database as follows:
With cdoMessage
Set .Configuration = cdoConfig
.From = "Admin <admin@MyCompany.com>"
.To = rs("USERName") & "@MyCompany.com"
.Subject = "Notification #" & rs("subject_Num")
.TextBody = txtVar
.Send
End With
this works great so long as USERName isn't garbage. If there are bad characters in it that IIS doesn't like, it get an error '8004020f' at the .send line.
I was wondering if there was an easy and / or publicly available code snippet that could check the user name for special chars. Ideally, it would email me if there was a problem with the USERName rather than just strip the bad chars out and send it to whatever is left.
Formulae exist in an Excel spreadsheet, linked to a Word document (a standard letter that extracts the results from the Excel cells). We want user online to fill in a web-based form, these data to be processed according to formulae in Excel sheet and then a standard document (Word or similarly formatted) is emailed to the person containing just the results from the Excel cells. At no point will the person have access to original Excel or Word files.
The Excel and Word documents will change frequently.
It is desirable if there is a way to simply upload the Excel and Word docs and the online form and all other aspects of the system will change automatically to reflect these changes.
1. Person fills in form
2. Server processes data from that form and generated answers 3. Person is emailed a standard document with the answers in place