Below you find some script samples what you can do with the conn object you are retrieving from the database object. Please check database.html for further details and note that the conn object is of the type ADODB.Connection of ADO2.5

'Copyright 2005 by www.aloaha.com
'furhter questions please send to info@aloaha.com or visit our Forum at:
'http://www.aloaha.com/html/portal

 

'declare Variables
dim database
dim conn 'as ADODB.Connection

'Create Objects
Set database = CreateObject("dbfunctions.dba")
set conn = database.open_database("")

'add domain to domain whitelist
sql = "INSERT INTO whitelist (entry) VALUES ('"aloaha.com"')"
conn.Execute (sql)

set conn = Nothing
set database = Nothing

Back to Index