Jump to main content Jump to doc navigation

xPDOQuery::command

Sets the SQL command the query will execute. Valid values are SELECT (the default), UPDATE and DELETE. For UPDATE and DELETE the class alias is reset to the table name, because those statements do not use column aliases.

Syntax

xPDOQuery command ([string $command = 'SELECT'])

Example

$query = $xpdo->newQuery('Box');
$query->command('DELETE');
$query->where(array('width:<' => 10));
$xpdo->exec($query->toSQL());

See Also

Support the team building MODX with a monthly donation.

The budget raised through OpenCollective is transparent, including payouts, and any contributor can apply to be paid for their work on MODX.

Backers

  • modmore
  • STERC
  • Digital Penguin
  • Jens Wittmann – Gestaltung & Entwicklung
  • CrewMark
  • Fabian Christen
  • Sepia River Studios
  • Dannevang Digital
  • Alex
  • A. Moreno
  • Chris Fickling
  • Stéphane Jäggi
  • Murray Wood
  • Anton Tarasov
  • JT Skaggs
  • deJaya
  • Lefthandmedia
  • eydolan
  • Following Sea
  • Guido Gallenkamp
  • YJ
  • Raffy
  • Snow Creative
  • Nick Clark
  • Guest
  • Helen
  • krisznet
  • Yanni
  • Richard

Budget

$194 per month—let's make that $500!

Learn more