User login

Benjamin Melançon

RDFa for telephone, IRC links that open, and other spiffiness for Agaric's client support page

RDFa-ing up our support page.

recommends FOAF for most contact stuff, and there is a FOAF:Organization for companies and weird hybrid collective

The tel URI for Telephone Numbers

Must use ->fields() method in select statements in Drupal 7 database layer (DBTNG)

An error like this one:

PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM block block WHERE (theme = 'bartik')' at line 1: SELECT FROM {block} block WHERE (theme = :db_condition_placeholder_0) ; Array ( [:db_condition_placeholder_0] => bartik ) in xray_block_statistics() (line 80 of /home/ben/workspace/dgd7all/sites/default/modules/xray/xray.module).

Stumbling through DBTNG, Drupal 7's new database layer

Order matters. condition() before countQuery()

This fails (note it trying to do a subquery):

return db_select('block')->countQuery()->condition('theme', $theme)->execute()->fetchField();

Prevent LibreOffice/OpenOffice from splitting a string of text on symbols in the text

OpenOffice was insisting on splitting a line a string of text !$has_money between the exclamation point and the dollar sign.

As far as i can tell the only solution is to insert a special character, the "zero-width non-breaking space": U+FEFF.

It's something like fifth from last when using the insert special character dialog.

The Ultimate Notetaking Drupal Site

  1. Title must be optional.
  2. Saving must be automatic.
  3. Must allow multiple edit tabs to be open at once.
  4. Tagging and crossreferencing preferred.

For me, it should be the one place for everything. This implies, if done with one content type, possibly having an optional date field, a private textarea...


Ideally the tabs would be vertical, and somehow in the application, but really it can just use the browser's tabs.

Sadly, some brilliant text had to be jettisoned from the Definitive Guide. Some of it lives here.

Castaways from the writing process:

Of course we should have an API or three. We know Jeff Eaton would stick APIs in a novelty module called Eldorado Superfly. No, actually, he didn't. From this we can learn that if our module is simple enough and uses enough of Drupal's APIs, it doesn't need to create its own.

[Eaton] drawing on his experience with VotingAPI, which, we might note, puts API right in the name of the module, and if that doesn't mean something, what does?

Pushing our local repository to Gitorious

git checkout master
git remote add origin
git push origin master

This was for a module named "remarkup" as covered in

Agaric's Trac workflow

This is in etc/trac/trac.ini. Note that each project can override in its own trac.inin (which for Agaric's system is in /srv/trac/PROJECTNAME/conf/trac.ini).

Syndicate content