Techniques

This section makes it possible to gather a whole of techniques or scripts which have the originality to manage to solve a difficulty with the least effort or which are particularly effective...The grayed entries relate to the future headings which will supplement soon this toolbox.

---

PDF : Generate PDF files on the fly for free

---

•  How to convert HTML files into PDF ones

•  Generate PDF files from a stored procedure : ASP and SQL Server

•  Create PDF files for free by using a virtual printer

•  Create PDF files by using a code library.

•  Generate PDF files by using the FDF Toolkit.

---

Excel : Create XLS on the fly for free

---

•  Create real XSL files (BIFF format) from ASP with DypsXLS

•  How to create a simple Excel report by changing the MIME Type of the webpage

•  Populate Excel WorkSheets on the fly using A.D.O. and ASP

•  Extract data from Excel Spreadsheet using ASP and ADO

•  Create and save an XLS file with COM and ASP

•  Generate an Excel stream by creating a C.S.V. (Comma Separated Values) File

•  Create an XLS File by using the SYLK Format

•  Create an XLS File with XML and ASP

•  Generate real XLS files on client side with COM

---

Word : How to create free Word files on the fly from ASP

---

•  Generate a Word file on the fly by using a MHT stream

•  Create a simple Word file on the fly by changing the MIME Type of the web page

---

ASP/SVG

---

•  How to transform an XML file in SVG with ASP and XSLT technique.

---

ASP Components:

---

•  DypsXLS - XLS Generator: a COM component to create real XLS files (compiled BIFF8 format) on the fly from ASP!

•  Pop3 Checker for ASP, for checking and retrieve emails from a pop server

•  Svg Pie Chart Maker : a component to create real vectorial (SVG) charts on the fly from ASP!

•  DypsRC4 : a COM component to encrypt and decrypt files using RC4 cypher.

•  DypsAntiSpam, a free hight performant COM component to display CAPTCHA on the fly from ASP.

---

Upload/Download of files from ASP

---

•  Alternative to zip files : MHT files, 1 HTTP request and multiple ressources downloaded !

•  How to retrieve files from FTP protocol without any third party component

•  How to upload files with ASP:

---

Sorting arrays with ASP

---

•  Bubble Sorting to sort arrays with ASP

•  QuickSort to sort arrays with ASP

---

Astuces ASP

---

•  How to post arrays from a page to other with ASP

•  Measure Script execution time

•  How to simply deal with yes/no value with ASP

•  Obtain a list of the data posted to a web page

•  Display server drives (available space,total space,name,...) .

•  List files in a directory using FSO

•  How to create a Temp file with FSO

•  Check the existence of file with FSO

•  How to read contents of a file with FSO

•  How to run a command line from ASP.

•  How to retrieve remote HTML Content with XMLHTTP.

•  How to protect your web with a login page.

•  How to prohibit access of certain page of your web.

•  How to de/encrypt files with DypsRC4 on the fly from ASP.

---

ASP and String

---

•  Number of occurences of a pattern in a string.

---

SQL

---

•  Find the first lacking id of a table

•  Find the values in double in a table

•  Display a treenode menu with a simple query. [Menu intervallaire]

---

ASP and date/time

---

•  Format date and time with ASP

---

SQL and safety

---

•  Caution: The SQL injection technique

---

Miscellanous scripts

---

•  Cloaking with ASP

•  Create youre bot with VB6 or VBScript and MSN Messenger

•  Check if an email address is a valid one

---

CSS

---

•  How to create a special CSS based tooltip without JavaScript.