Convert a DateTime string to a Unix timestamp in VbScript / Classic ASP

To convert a datetime string value like “YYYY-MM-DD HH:MM:SS” to a Unix timestamp (the seconds from 01/01/1970 to the input datetime) You can use a conversion function as the following: Then, to get back the datetime from the Unix timestamp … Read More

How to export an ASP Associative Array to XML

“Asp Associative Array Class” provides a method to easly export all items to a well formatted XML string. For example, You can create a new *.ASP file : [sourcecode language=”vb”] <!–#include file="AssociativeArrayClass.asp" –> <% Dim Person, God Set Person = … Read More

How to populate an ASP Associative Array with records from MySQL / Access database Table

In this example, You can learn how to populate an ASP Associative Array with the records of a database table (MS Access or MySQL); then, how to programmatically manage well structured data without any extra SQL. Before to start: For … Read More

How to use Associative Arrays in ASP

First of all, You need to download the “Asp Associative Array class” then include the file “AssociativeArrayClass.asp” in your asp page. Right now, You can start declaring associative arrays in ASP with the following syntax: [sourcecode language=”vb”] Dim Person Set … Read More

VBScript Class to create easly Associative Arrays in ASP like in PHP

I’ve posted a project at Source Forge with an ASP/VBScript class to create easly associative arrays like in PHP; visit http://sourceforge.net/projects/asp-assoc-array/ It is possible also load in an associative-array the data coming from MySQL or MS Access databases, then You … Read More

PHP Date or Datetime to MySQL Datetime and viceversa

Two useful PHP functions to convert normal date/datetime (“25.12.2010 12:10:00” or “25.12.2010”) to MySQL datetime (like “2010-12-25 12:10:00” or “2010-12-25 00:00:00″); You can get back a date/datetime from MySQL datetime too: [sourcecode language=”php”] function datetime2mysqldatetime($datetime){ // ‘25.12.2010 12:10:00’ -> ‘2010-12-25 … Read More

MySqlHelper VB.NET class – easly execute commands against a MySQL database

posted in: C#, Database, MySQL, Programming, VB.Net 0

Hi all, with the following free .net helper class you can easly execute SQL commands against a MySQL database, execute stored procedures, get or programmatically update tables/DataSet objects and convert to and from MySQL datetime types. Enjoy! 🙂 [sourcecode language=”vb”] … Read More