Querying the Database?

[CWebguy]

When querying the database from something like a UDT, the standard code for a basic query isn't working.

Is there a special code I need?  I searched the docs.

Thanks.

[CWebguy]

Sorry, when looking at the error messages, it may be that I just have to open a new connection.  I'll try that now.

But I'm guessing there is a class I can use?

Thanks.

[alby]

But I'm guessing there is a class I can use?

Why not look some examples already done?
Search in wiki for share your UDT

Alby

[CWebguy]

what something like:

Code: Select all

global $gCms;
$hm =& $gCms->GetHierarchyManager();
$db = &$gCms->db;

?

Thanks.

[alby]

what something like:

Here you have a SELECT and one INSERT

Alby

[CWebguy]

cool, so I'm guessing

global $gCms;
$db = &$gCms->db;

creates a connection to the database then?

Thanks.

[alby]

creates a connection to the database then?

better: you use same connection of CMSMS

Alby

[CWebguy]

ok, so this is the right code for a DB connection?

Thanks.