Editing!

Blog post

Author
Message

Rocket Man
Posts: 383
Posted on: 2012-11-01 17:17:39.000
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
Posts: 18
Posted 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
Posts: 383
Posted on: 2012-10-31 23:35:41.000
wow that comment is going to disappear soon.. this is a test post :)

Rocket Man
Posts: 383
Posted on: 2012-10-31 23:36:09.000
as in, I'm testing stuff and will probably delete the post soon :)

Rocketeer
Posts: 18
Posted on: 2012-10-31 23:37:37.000
Missed by this much: (fingers (this(far(apart (miss)))))

Rocketeer
Posts: 18
Posted on: 2012-10-31 23:38:19.000
So this is chat too?

Rocketeer
Posts: 18
Posted on: 2012-10-31 23:39:25.000
Still can't edit!

Rocketeer
Posts: 18
Posted on: 2012-10-31 23:40:25.000
Time's wrong too.

Rocket Man
Posts: 383
Posted 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
Posts: 383
Posted 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
Posts: 383
Posted on: 2012-10-31 23:44:31.000
It's like a primitive chat, lol

Rocketeer
Posts: 18
Posted on: 2012-10-31 23:54:44.000
You'll have to save it out and frame it....

Rocket Man
Posts: 383
Posted on: 2012-11-01 00:38:03.000
Okay time to go home...

Rocketeer
Posts: 18
Posted on: 2012-11-01 00:44:23.000
okay

Rocket Man
Posts: 383
Posted on: 2012-11-01 00:58:00.000
Ha ha! I'm posting on the bus using my phone on the INTERNET!

Rocketeer
Posts: 18
Posted on: 2012-11-01 11:22:47.000
DAMN IT IS HARD TO GET THE LAST WORD.

Rocket Man
Posts: 383
Posted 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
Posts: 383
Posted on: 2012-11-01 20:06:42.000
Also when you add a comment it jumps as well. Saves on scrolling.

denis
Posts: 1
Posted on: 2012-11-05 23:34:09.000
Hello, folks! :-)

Rocket Man
Posts: 383
Posted on: 2012-11-06 17:29:01.000
Hi Denis! Nice to see you!


Views: 5991