cdbutil Class

cdbutil.asp to include

Properties and Methods


Properties

  • oggconn
  • Private property to retrieve with oconn get method

Methods

  • accessconn(strnomedb)
  • Open a connection taking strnomedb parameter that is namedb, we set an instance connection doing classinstance.oconn
  • recset()
  • Set simply a recordset
  • strselectquery(strtable)
  • return a select query string with parameter strtable to pass
  • rsselectquery(squery)
  • return a recordset, need parameter squery, the query you want to use, you can use first strselect query
  • insertquery(siq, valarrcol)
  • Insert data in your db, need siq that is a select and valarrcol parameter an array that match your columns in the datatable
  • updatequery(uq, valarrcolupd)
  • Update data in your db, need uq that is a select and valarrcolupd parameter an array that match your columns in the datatable