| Title | Description |
| 1 | Format datetime of MySql with ASP | Convert those standard DateTime format in MySql to understandable and meaningful texts. Also, this function will work in different language easily. The following is the sample to print DateTime text in English.
Tag -ASP -Quick Paste |
| 2 | Update records | mySql command, update records in table
Tag -MySql -Syntax Reference |
| 3 | Join two tables in mySql | mySql command, join two tables from mySql
Tag -MySql -Syntax Reference |
| 4 | Insert new records | mySql command, insert new records into table.
Tag -MySql -Syntax Reference |
| 5 | Delete records | mySql command, delete records.
Tag -MySql -Syntax Reference |
| 6 | Display mySql records with NEXT and PREVIOUS page | Display records from mySql with ASP, and the records on page with the layout of NEXT page and PREVIOUS page.
(codes from web open source)
Tag -ASP -Navigation |
| 7 | One record per row and do paging with group | Display records from mySql into table inASP with simple one record per row in table in page, and do paging with NEXT x PAGES/PREVIOUS x PAGES.
Tag -ASP -Navigation |
| 8 | Paging the records from database | Do paging from MySQL with ASP, and display the page number with next X pages or previous X pages. Also display the records with multi records per row in table.
Tag -ASP -Navigation |
| 9 | iframe | Use iframe in HTML page
Tag -HTML -Syntax Reference -Quick Paste |
| 10 | the quote | Display quote symbol in html page(to use it by remove the "-")
Tag -Quick Paste |
| 11 | Close tag | Display close tag symbol in HTML page
NOTE:To use it by remove the "-".
Tag -Quick Paste |
| 12 | Open tag | Display open tag symbol in HTML page
Tag -Quick Paste
|
Some useful codes I collected from the web or I wrote for our projects in the past. Some tips, some notes.
