Top Rated Scripts | ASP | Tutorials & Tips | Development

This tutorial is about a piece of ASP functionality that is as old and common as grandma's blueberry pie ---> how to build a drop down menu using ASP. Specifically, how to create a select menu element for each record returned in an ASP recordset. I'll show you how to do it in 4 simple steps...

One of the most common problems encountered in ASP when using SQL statements, is the existence of an apostrophe (i.e. single quotation mark) in an SQL query string. I say problem because SQL Server (or any T-SQL database server) interprets single quotes as the representation of a string value - that is, as delimiters. Therefore to avoid conflict between single quote delimiters and apostrophes we need to let ASP know that we want an actual apostrophe and not the end of the string. My short tutorial will show you how.....so let's get started