Best uses for RSS - ASP
In this article, I will talk about some of the best uses for RSS. Some of the uses for RSS are for both business and fun! Think about it, you can log or blog your daily activities or log special events for families to see or even log your ... [... more]
Bella Online |
Joining Tables in SQL - ASP
Do you have two tables, and want to be able to calculate totals and merge information across them? Just join them together! This isn't even an ASP command, it's just regular SQL. Let's say you have two table, one with your sale items in it and ... [... more]
Bella Online |
Create a Table with SQL Syntax - ASP
Need to create a table to put data in? It's very easy to put together SQL Syntax to build the table to store your newsletter members, poll votes, or more. To start with, get a connection to your databse using ODBC, Access, PowerBuilder, or ... [... more]
Bella Online |
Selecting All Rows from a Table - ASP
There are many times that you will want to select all rows from a given database table. How do you move through the records, and display the data? Let's say you have a table with BookName as a field and you want to write to the screen all ... [... more]
Bella Online |
Advanced SQL Update Command: Using Two Tables - ASP
There are times that you need to update one SQL database table, and want to use values from another table to do the update with. Here is how you would do that in ASP. First, the scenario to make this easier to understand. Let's say you are moving ... [... more]
Bella Online |
RSS and its future. - ASP
I want to talk a little about RSS and what the future holds for it. If you don't know, RSS stands for "Really Simple Syndication" which is a technology for displaying news articles and other important information. This information can be [... more]
Bella Online |
Handling Apostrophes in ASP and SQL - ASP
An important step when using character data in SQL and ASP is making sure that any apostrophes (') in the data doesn't interfere with your SQL statement! Your SQL statement is going to have apostrophes around each text value. If your text value ... [... more]
Bella Online |
MAX - Selecting a Maximum Number in SQL - ASP
SQL provides an easy to use method of determining the largest, or maximum, number in a database. This can get you the largest salary, next available ID number, and much more. The function is called MAX and it can be used on any numeric field. ... [... more]
Bella Online |
Force Download Dialog box with ASP - ASP
Have you ever been frustrated when you get to a website and there is documents, images and other content available for download and you want to do just that, download it! Instead, when you click on a content item, it proceeds to open in your ... [... more]
Bella Online |
Inserting Into a Database with ASP - ASP
The INSERT command is very commonly used in ASP to add rows into a SQL database. Here is the syntax for inserting into your tables. Let's say that you have built yourself a little guestbook, where visitors have a form in which they can enter ... [... more]
Bella Online |
MIN - Selecting a Minimum Number in SQL - ASP
The MIN function in SQL is much like the MAX function. Where the MAX function gives you the highest number found in a given field, the MIN gives you the smallest number. Let's say you were running a sale on soap products and you wanted to ... [... more]
Bella Online |
Updating a SQL Database with ASP - ASP
Often, you'll want to use ASP to update a database record using SQL. Here is how it is done! Let's say you are writing ad rotation code, and you have already done the Select of the Ad. Now you want to update the database row so that the ad's ... [... more]
Bella Online |
