Editing!


Post #: 51
Date: 2012-11-01 17:17:39.000
Author: Rocket Man

So, now we have the final U in CRUD done, and I can finally edit posts. YOU can't edit comments yet, but that's coming soon, probably tomorrow.

That's fun. EDITING ROCKS! It's also a really neat macro that makes it pretty easy to do SQL update statements.

Here's another neat thing: Basically, I use the exact same statement to create and update a post:

(update-record "Posts" Id PosterId PostDate PostSubject PostContent) ; It's the U in CRUD!

(create-record "Posts" Id PosterId PostDate PostSubject PostContent) ; It's the C in CRUD!

There's a lot of stuff going on behind the scenes to translate the above into two very different SQL statements. Basically the Id in the first is to CHECK for Id's value, and in the second statement it is to SET Id to that value. I like the symmetry,


Rocketeer on 2012-10-31 23:34:52.000

I do however believe that most people put too much stock in
these things because in the age of information with the
present technology they are illusory protections. Dedicated
efforts with cameras, recording devices, shills, informants,
stings, blackmail <of others if necessary> and such render
most everyone <especially those with something to conceal>
vulnerable to co-option or setup for a fall.

Rocket Man on 2012-10-31 23:35:41.000

wow that comment is going to disappear soon.. this is a test post :)

Rocket Man on 2012-10-31 23:36:09.000

as in, I'm testing stuff and will probably delete the post soon :)

Rocketeer on 2012-10-31 23:37:37.000

Missed by this much: (fingers (this(far(apart (miss)))))

Rocketeer on 2012-10-31 23:38:19.000

So this is chat too?

Rocketeer on 2012-10-31 23:39:25.000

Still can't edit!

Rocketeer on 2012-10-31 23:40:25.000

Time's wrong too.

Rocket Man on 2012-10-31 23:42:40.000

yeah time is way off. On completely the wrong timezone. Have to fix timezones somehow.

I can't edit either! I'm still writing that part!

Rocket Man on 2012-10-31 23:44:05.000

It's apparently on UTC. So it's the correct time if you happen to live in Greenwich.

Rocket Man on 2012-10-31 23:44:31.000

It's like a primitive chat, lol

Rocketeer on 2012-10-31 23:54:44.000

You'll have to save it out and frame it....

Rocket Man on 2012-11-01 00:38:03.000

Okay time to go home...

Rocketeer on 2012-11-01 00:44:23.000

okay

Rocket Man on 2012-11-01 00:58:00.000

Ha ha! I'm posting on the bus using my phone on the INTERNET!

Rocketeer on 2012-11-01 11:22:47.000

DAMN IT IS HARD TO GET THE LAST WORD.

Rocket Man on 2012-11-01 20:05:27.000

Indeed!

I've changed the way the comment button works so it jumps directly to the most recent comment. This should make it easier to get the last word in. :)

Rocket Man on 2012-11-01 20:06:42.000

Also when you add a comment it jumps as well. Saves on scrolling.

denis on 2012-11-05 23:34:09.000

Hello, folks! :-)

Rocket Man on 2012-11-06 17:29:01.000

Hi Denis! Nice to see you!

View this post in the forums

Views: 3715