| Access DSN-Less Connection Generator |
| So you need a DSN-Less connection but your not quite sure what to do. Well we can do this for you. A quick and easy way to make a connection without a DSN. This will work for your MS Access database only. |
| An easy and quick form 2 db solution |
| You fill in the blanks, and you are given the source code for the form, and a page to display the information in the database. Also the database is ready to download with all fields in your form |
| An Easy Way To Add A Record |
| Adding a record from a database table is a simple task. Fill out the form below and click submit. The sql statement will be generated for you. It's just that easy. |
| An easy way to add tables: |
| Insert a table into a database dynamically. You don't even have to open MS Access. One simple asp does the trick! Using ADOX you can add and manipulate tables easily once you know how |
| An easy way to CDONTS forms |
| Use this quick wizard-like form to actually build a form that sends email using CDONTS. In a couple of minutes you will be able to recieve feedback |
| An Easy Way To Delete Records |
| Deleting a record from a database table is a simple task. Answer the four questions below and click submit. The sql statement will be generated for you. It's just that easy |
| An easy way to JMail forms |
| Use this quick wizard-like form to actually build a form that sends email using JMail. In a couple of minutes you will be able to recieve feedback |
| Array() Function |
| Arrays are good for storing small pieces of information to be used at any point. It is important to note that all arrays are zero based. Meaning that you count the first piece of the array is always 0 not 1. |
| Array() Function II |
| Here is another example of using arrays. As you can see the pieces are all put in a named array on one line. Small arrays can be handled and printed quickly and easily with only five lines of code. |
| Arrays in plain English |
| Arrays are without a doubt mans best friend. Sorry dogs but I think you now come in second. There are many ways to use arrays. Here are a couple of quick examples |
| Banner Control Wizard |
| Use this wizard to create the Banner Control System for your site. This application will give you the ability to rotate banners on all pages in your site rotating them randomly while giving them equal page views at the same time. Using an Access database and asp your ad management problems are solved. |
| CDate Function |
| The CDate function will convert any valid time and date to a date. |
| Copyright Auto-Update Script |
| Never update your copyright again! This quick little script will do it for you. |
| Counting Records Wizard |
| I have seen many requests in forums and messageboards for counting records and displaying the total. Well, this little wizard will help you accomplish this task. Fill in the form below and it will crank out the code for you. |
| Creating Cookies With ASP |
| No matter how you feel about cookies, good bad or indifferent, they are an integral part of many webs. Why not unlock the mystery and write your own? Here's a quick rundown on this. |
| Cross Browser Scripting |
| Many times it is necessary to consider the clients browser. Some things Are not cross browser compliant. Often you have to write something one way for Internet Explorer and another for Netscape. Often, people will write TWO pages and use a browser redirect script. Rather than having two pages with the same content, there is another option. It's really a simple solution. By looking at the USER AGENT we can do a little server side scripting to show what is needed depending on the browser. |
| Date Function |
| The Date function will return the system date to the page. |
| DateAdd Function |
| Learn to add and subtract dates and times using DateAdd function |
| DateDiff Function |
| Using the DateDiff() function it's easy tofind out how much time has elapsed between two dates. From seconds to years or anything in between. |
| DatePart() Function |
| Learn to get part of the date from the DatePart Function using vbscript and asp. You can get any part of the date from seconds to year. |
| DateValue() Function |
| Using the Date Value Function you can represent any date/time format as a Short Date (VbShortDate) Format OR MM/DD/YYYY. |
| Day() Function |
| Use the Day() function to display just the day number. For example it will display 1 through 31 (or less depending on the month). Quick easy way to show just the day number. |
| Day() Function |
| Use the Day() function to display just the day number. For example it will display 1 through 31 (or less depending on the month). Quick easy way to show just the day number. |
| File Last Modified Script |
| Displaying the date last modified is a simple thing to do. All it takes is calling up the ol File Scripting Object and there you have it! The last modified date, DYNAMICALLY! Every time the file is modified this info is written into the file. The FSO knows just how to read that for you. |
| FormatDateTime() Function |
| The FormatDateTime() Function will allow you to set the time up any way you like. Time, Date Date AND Time Etc. It allows for VbShortDate, VbLongDate, VbLongTime, VbShortTime and VbGeneralDate. |
| If ElseIf End If Example |
| Many times we need to perform an action or display something different based on some different parameters. Using If ElseIf End If is one such way to do this |
| Julian Date |
| On occasion one will need to use the julian date from asp or vbscript. Here is a quick way to get the Julian Date. |
| Left() Mid() Right() |
| There will come a time when you need to dice up a string which is all one word or a number. In this particular case, Split() won't work for you. What we will discuss here is Left() Mid() and Right(). These functions will allow you to get only the part of a word or number you need. |
| Minute() Function |
| Use the Minute() function to display just the minute number. For example it will display 0 through 59. A quick and easy way to show just the minute number. |
| Month() Function |
| Use the Month() function to display just the month number. For example it will display one through twelve. Quick easy way to show just the day number. |
| MonthName() Function |
| By using MonthName() you can display the month as a string instead of a number. Either use the number of the month or incorporate the DatePart() Function. Display the whole name or the short name. |
| Now() function |
| Now() is just that, NOW. It cant get any simpler than that. The Now() function will return the current system time to the page. It can also be passed to databases etc... |
| ODPac Internet Search |
| ODPac is a search script which will allow your visitors to search the internet without ever leaving your site. This can greatly increase the stickiness of your website and aid in generating additional page views and possibly increasing ad revenue. It could also lead to greater amounts of return or repeat traffic. ODPac uses the XML object which should already be installed on most hosts. Installation is fast and painless. |
| PacLog Password Protection |
| Login system complete with admin area and lost password retrieval via email. Password protect all or part of your site in under ten minutes. Well documented and easy to follow setup instructions |
| PacMail V 1.0 |
| PacMail is an easy to use mailing list administrator. Uses asp and access. Get repeat traffic by having your visitors to sign up for your mailing list. PacMail takes all the work out of this for you. Subscription registration is automated. Make a few changes and in less than 10 minutes you have a fully functional mailing list utility. You can then send mail to the list at any interval you like! |
| PacPoll V 2.0 |
| Put PacPoll on your site today. This poll was made to be setup and run with ease. All you have to do is drop it in your web write and put an include statement where you want the poll. This poll comes complete with all the asp pages and the Access database |
| Playing With Dates |
| There are several different ways of displaying dates. You can also add and subtract from them as well. Using the FormatDateTime function we can display dates in any manner. |
| Playing With Times |
| There are several different ways of displaying times. Using FormatDateTime and DatePart functions we can manipulate the time in many different ways. |
| Popup Feedback Form |
| Learn how to put a popup email form on your site using javascript and asp. It supports CDONTS and JMAIL. Form is validated to keep blank emails from filling your box. All you have to do is set the fonts and colors. EASY INSTALLATION! |
| Query String Example |
| Passing info between pages is a simple task. We have all seen the long URLs that look like this: http:www.pacosdrivers.com/asp/name.asp?name=Paco This is done by passing data in a query string. |
| Second() Function |
| Use the Second() function to display just the second number. For example it will display 0 through 59. A quick and easy way to show just the second number. |
| Select Case Example |
| Many times we need to perform an action or display something different based on some different parameters. Using select case is one such way to do this. |
| Simple Counter Using Graphics |
| This example is a simple counter using graphics to display the numbers. I call it simple because it will only show page views, not actual visitors. It uses the File Scripting Object to interact with a text file |
| Simple Text Counter |
| This example is a simple text based counter. I call it simple because it will only show page views, not actual visitors. It uses the File Scripting Object to interact with a text file. The first thing it does is read the current number in the file and add one to it, then displays it as text on the page. |
| Split() Function |
| This example will show you how to split a string and turn it into an array. It matters not the size of the string, Split() will put it into a nice tidy array to use as you please. |
| SQL Reserved Words |
| Many times people will make the mistake of naming a database field with an SQL Reserved word. This is an easy mistake to make. It's hard to remember EVERY single one. Here's a concise listing of SQL Reserved words to help you along. |
| The Len() Function |
| Lets talk about the Len() function for just a minute. Len as you may have deduced is LENGTH. It's really pretty straight forward. Here's a quick example |
| Time() Function |
| Time() can be used to display just the system time. It can be done two ways. It can give the time as AM or PM or on a 24 hr format using the FormatDateTime funtion. |
| Timer() Funtion |
| Though I have never used it before, there is a way to tell exactly how many seconds after midnight it is. The Timer() Function will do this for you quick and easy. |
| Using The Split() Function |
| Often times it is necessary to take a string and dice it up in order to extract portions to be used for some obscure purpose. Enter the Split() function. Split is a very easy concept to grasp. Just decide where you want to split your string and away you go |
| WeekDay() Funtion |
| By using the WeekDay() Function you can get the day of the week number. 1 through 7. One being sunday of course. This is a fairly simple way to print just the number. |
| WeekDayName() Function |
| The WeekDayName() Function will display the name of the day of the week for you. You can do this by either entering a date or simply by using 1 through 7. |
| Year() Function |
| Use the Year() function to display just the year number. For example it will display 2003 or whatever the current system year is. Quick easy way to show just the year number. |
