Angel: Connor, this is Spike and Illyria. Guys, this is Connor. Connor: Hi. umm...I like your outfit. Illyria: Your body warms. This one is lusting after me. Connor: Oh...no, I--I--it's just that it's the outfit. I guess I've had a thing for older women. Angel: They were supposed to fix that.

'Origin'


Buffistechnology 3: "Press Some Buttons, See What Happens."

Got a question about technology? Ask it here. Discussion of hardware, software, TiVos, multi-region DVDs, Windows, Macs, LINUX, hand-helds, iPods, anything tech related. Better than any helpdesk!


§ ita § - May 04, 2007 8:50:14 am PDT #1490 of 25496
Well not canonically, no, but this is transformative fiction.

Gud, that's the answer. I dislike that it's the answer, since it means I need a more complex WHERE clause to catch nulls and normal inequality. Does "=" have three possible values in most RDBMSs?

::searches::

Looks like MySQL behaves the same way, and includes a "NULL safe equal" to accomodate it.

I had no idea.


Gudanov - May 04, 2007 8:53:37 am PDT #1491 of 25496
Coding and Sleeping

Gud, that's the answer. I dislike that it's the answer, since it means I need a more complex WHERE clause to catch nulls and normal inequality.

Sometimes the truth hurts.


Liese S. - May 04, 2007 8:55:15 am PDT #1492 of 25496
"Faded like the lilac, he thought."

Yeah, I don't think there's any way around a more complex where. This is cludgy, but...

SELECT TableA.colA, TableA.colB
FROM TableA
WHERE [colA]<>[colB]
OR (IsNull([colA])=True AND IsNull([colB])=False)
OR (IsNull([colB])=True AND IsNull([colA])=False);

You don't need the last bit since your dataset doesn't contain nulls in B, but you would if it might.


Dana - May 04, 2007 9:16:30 am PDT #1493 of 25496
I'm terrifically busy with my ennui.

Barkley? Is that actually Barkley?

Drawn out of lurking by SQL?


§ ita § - May 04, 2007 9:43:41 am PDT #1494 of 25496
Well not canonically, no, but this is transformative fiction.

SQL is hot. Don't let the mundanes tell you different.

Okay--flipping tech. Cell phones. I'm a Cingular customer who'd like to have an easier time texting (I have a RAZR, and the T9 is better than the Ericsson that preceded it, but still). I'd like to be able to read email on the thing, but don't care too much about sending it. Camera's good, don't need video or particularly hi-res.

I need Bluetooth, and would like it to be able to serve as a modem.

There's some education I'm missing. 3G? What transmission technologies should I be looking at?

I have an irrational dislike for Windows, so I'm looking at the Pearl.

Does anyone know the delivery dates for the iPhone or the Linux Treo?


Gudanov - May 04, 2007 9:55:12 am PDT #1495 of 25496
Coding and Sleeping

SQL is hot. Don't let the mundanes tell you different.

I don't know how the squggles get along without it.


NoiseDesign - May 04, 2007 10:18:55 am PDT #1496 of 25496
Our wings are not tired

The iPhone is supposed to arrive towards the end part of June. They haven't announced an exact date yet. That's the one that I'm waiting for. Don't try any of the WindowsMobile devices, they really aren't good, I used an 8125 for most of last year until it died about a week ago so I'm using a RAZR V3i until the iPhone comes out and I can snag one.


Gudanov - May 04, 2007 10:22:31 am PDT #1497 of 25496
Coding and Sleeping

BTW, cool Podcast ND.


NoiseDesign - May 04, 2007 10:28:45 am PDT #1498 of 25496
Our wings are not tired

Thanks! I'm glad you like it. We're having a blast recording it. We are watching Ice Pirates and Terror Firmer on Sunday to prep for the next episode.


§ ita § - May 04, 2007 12:31:12 pm PDT #1499 of 25496
Well not canonically, no, but this is transformative fiction.

The Treo running Linux appeals to me, and perhaps a fair amount because it'll come with Opera. I'm kinda easy that way.

Then, the iPhone is just so freaking sexy, but there is the lack of keyboard thing.