PDA

View Full Version : ASP Tips & Code Snippets

  1. Handling Spaces in Strings
  2. Sessions
  3. Record Count
  4. Displaying a Specified Amount of Records
  5. Case Conversion
  6. Adding Your Logo to a Bookmark
  7. Sorting Queries
  8. Passing Variables from Page to Page
  9. Using Unions in your Queries
  10. Simple DATE Function
  11. Populate Dropdown Box
  12. Cookie Basics
  13. Arrays
  14. Time and Dates
  15. Sending Mail Using CDONTS
  16. Pull Data from Database with Hyperlinks
  17. Testing for EOF (End Of File)
  18. Disabling Session State
  19. Using a Date Range
  20. Counting Lines in a Text File
  21. Random Number Generator
  22. URL History
  23. Solving the Apostrophe Problem
  24. Detect Whether a File Exists or Not
  25. DSN-Less Connection
  26. Adding a New Table
  27. Error Trapping
  28. Text Area Formatting
  29. A Function to Replace Apostrophes
  30. Incrementing a Number Field
  31. Inserting Into a Database Field
  32. URLEncode and HTMLEncode
  33. Speed up Your ASP Pages
  34. List your Table Fields
  35. Multiple Form Submit Buttons
  36. Using the DateDiff() Function
  37. Looping Through an Array
  38. Order By Count(*)
  39. Select Case
  40. Formatting Currency
  41. Display the Last Record Added
  42. Using the LIKE statement to find similar words
  43. Counting the Occurances of a Letter in a String
  44. Preventing Pages from being Cached
  45. Using Sub Selects
  46. Getting the Datatypes of your Fields
  47. Using the Max() Function to Return the Maximum Value of a Field
  48. Do Away with your outdated ADOVBS File
  49. Creating an OLEDB Connection
  50. Adding a New Table (SQL Server)
  51. Using Anchors in QueryStrings
  52. Retrieving and Displaying All ServerVariables at One Time
  53. Preserving Line Breaks in a Database
  54. Banning Certain IP Address' To Your Site
  55. About Dimming Your Variables<
  56. DISTINCT vs DISTINCTROW
  57. Securing Logins Using Cookies
  58. A Form Validation Routine
  59. Copy One Table to Another Table
  60. Using DateAdd() For Modifying Time and Dates
  61. Getting the Most Common Field
  62. Passing Form Input Into Subroutines
  63. How To Update Checkboxes in an Access Database
  64. Using MOD To Determine Even or Odd
  65. How To Ditch a Session
  66. Using IN() and NOT IN() with your SQL statement
  67. Break up those long SQL statements
  68. Searching for NULL
  69. Password Encryption
  70. Getting Browser Name and Version
  71. Formatting Strings
  72. Building a Dynamic Checkbox
  73. Response.Write a URL
  74. Creating an Access DB 'On the Fly'
  75. Using Access Dates in SQL Statement
  76. ASP Image Map
  77. Iterating Through The Forms Collection
  78. More On JOINS
  79. Searching For Multiple Items In One Field
  80. Formatting Long Dates
  81. Deleting Records Depending On An Expire Date
  82. Reading From a Text File
  83. Creating and Writing to a Text File
  84. Adding A Dynamic MARQUEE To Your Page
  85. Inserting Records Security Issue
  86. Stuffing a Javascript Value into a VBScript Variable
  87. Converting a String to Proper Case
  88. Virtual Frames
  89. Form Responses to Text File
  90. A Disable the Back Button Hack
  91. Counting the Occurrences of a Letter in a String - Revisited
  92. Validate a UserID and Password against multiple tables in your database
  93. Update a Field in a Table from a Form
  94. Alphanumeric Function
  95. Parsing a Form's Text Field
  96. Getting the Number of Work Days Between Two Dates
  97. Display the Time Without the Seconds
  98. Alternating Row Colors Script
  99. Getting Time and Date Simplified
  100. Randomly Generate Lotto Number Picks
  101. A "Something of the Day" Script (Sequential Order)
  102. A Time and Date Function That Works
  103. Limiting Text in Query Results
  104. Generate Random Password
  105. Vbscript Reference For Asp
  106. Scroll Bar Colors (JavaScript)
  107. Regular Expression to validate email addresses.
  108. Included Configuration File
  109. DB Maintenance - Locking Out Users While Uploading and Downloading the DB
  110. Login
  111. File Upload
  112. Shopping Cart
  113. QueryString
  114. The ASP Concept
  115. Multi-Language Web Site
  116. ODBC DNS Less for all sort of database
  117. Regular Expressions to test Email Addresses
  118. How to send email !!!!!
  119. New Items Displayed
  120. Tell a Friend
  121. Repair - Backup - Compact
  122. Onclick Confirm Function (JAVA)
  123. 2 Part Pure ASP Upload From MSDN
  124. Image dimensions with ASP
  125. Removing or Disabling HTML Tags in Form Input
  126. send mail via CDONTS easy and fast
  127. Sever-side printing via ASP
  128. Never Need an include File again
  129. Strip ASP Code Function
  130. Form Post Validation
  131. Delete a Folder - If It Exists
  132. Format SQL Input
  133. Ascii to Hex Function
  134. Function to Check Whether IP is Private Address
  135. Validate IP Address Function
  136. Change String to Proper Case
  137. Reserved Words In Microsoft Access
  138. isAlphaNumeric Function
  139. Pagination Function
  140. Replace String Between 2 HTML Tags
  141. The Char Code List
  142. Replace those Nasty Single Quotes after Form Submit
  143. O/R Mapping
  144. Code using Div tag to display popupwindow
  145. Check to see if a Field Exists in a RecordSet
  146. Radio button checked and db example
  147. Tell a friend using cdosys
  148. Get the last record ID Inserted
  149. Adding multi-select feature in datagrid
  150. Display a Random Include File
  151. Login Script Hack fix
  152. Database Security
  153. Simple Counter