GETTING STARTED
Life without SQL 

I've lost my direct control over the database - how can I do what I need to do?

The following table helps you convert between the tradional full access to db methdology to a new resource oriented architecture, where everything is a stream of data.

TASK Using SQL
(old way)		 Using mydigitalstructure
(new way)
Get rows of data  SELECT, WHERE

Using advanced search:

.addFilter()
.getResults() 
Get a specific row SELECT, WHERE .addFilter('id', 'EQUAL_TO', 1234)
Add a column to an existing table "object class". ALTER SETUP_STRUCTURE
Setting up structures
Adding a new table
SETUP_STRUCTURE
Setting up structures
Delete a row of data ie "object" DELETE

&id=1234
&remove=1
Update a row of data ie "object" UPDATE &id=1234
Bulk update UPDATE Programatically
Bulk add INSERT Programatically

 

 


How Advanced Search Works