SELECT i.inumber as itemid, i.ititle as title, i.ibody as body, m.mname as author, m.mrealname as authorname, i.itime, i.imore as more, m.mnumber as authorid, m.memail as authormail, m.murl as authorurl, c.cname as category, i.icat as catid, i.iclosed as closed FROM nucleus_item as i, nucleus_member as m, nucleus_category as c WHERE i.iblog=1 and i.iauthor=m.mnumber and i.icat=c.catid and i.idraft=0 and i.itime<="2008-12-05 04:04:21" AND i.iblog = 1 AND i.inumber IN (25,59) ORDER BY i.itime DESC LIMIT 1,5
stdClass Object
(
[itemid] => 25
[title] => TOYS!
[body] => I got a Sony Clie PEG-TJ37. I was thinking about the PEG-TJ55, but I just could NOT deal with the wheel thing in the back – too awkward.
Since the info on getting this puppy to work with linux seemed a little scattered, I figured I’d make my notes here, maybe someone else would find them handy, too.
[author] => erin
[authorname] => Erin Schnabel
[itime] => 2004-05-19 16:44:00
[more] => Just as a side comment, syncing with jpilot worked oddly until I changed from devfs to udev (I left devfs in the kernel, but used the boot option to prevent it from being mounted). Once I switched to udev, behavior made much more sense.
linux distro: gentoo
kernel version: 2.6.5-gentoo-r1 (gentoo-dev-sources)
kernel options:
CONFIG_USB=y
CONFIG_USB_DEVICEFS=y
CONFIG_USB_EHCI_HCD=m
CONFIG_USB_UHCI_HCD=y
CONFIG_USB_SERIAL=m
CONFIG_USB_SERIAL_VISOR=m
References:
I got a Sony Clie PEG-TJ37. I was thinking about the PEG-TJ55, but I just could NOT deal with the wheel thing in the back – too awkward.
Since the info on getting this puppy to work with linux seemed a little scattered, I figured I’d make my notes here, maybe someone else would find them handy, too.
