Categories
Code Talking

AS400 SQL Concatenation

I needed to concatenate some information in a table, and I wanted to do it with a SQL query, but I could not for the life of me figure out how to combine the two strings (one a constant, the other a field name) in order to produce a joined value.

Finally, I found it- concat.

 update tablename
 set fieldname = 'constant' concat 'fieldname'
Categories
Code Talking

Anchors Away!

I was redesigning the plugin pages to get the documentation into a useful format, and found that I needed an anchor tag so that the reader could jump to a particular place in the document.

Categories
Code Talking

Attach an SQL Database

The other day, I had the need to attach to a Microsoft SQL Server database that a customer had sent on CD. Not a backup mind you, just the raw files. Took me a little while to figure out this puzzler, so I figured I’d post it here in case you had run into the same thing.

Categories
Code Talking

Verification Image with PHP

I’m sure you’ve seen those images that display a changing value in them, something that you have to read and then type into a field so that you verify that you’re human (the assumption being that a machine couldn’t read the image to extract the text). They’re everywhere.

Do you need one? That’s a question I can’t answer for you. But I can tell you how to create the image. I am working on another bit to tell you how to actually use the image for verification, but since I can’t quite get it working myself, I’m going to leave that part out. This just shows you how to create the image itself.

Categories
Code Talking

More AS400 SQL

I’m sure everyone else already knows this stuff, but since I use my blog for reference when I don’t feel like trying to look things up, I’m going to do another piece on SQL. Specifically, another piece on SQL subselects.

Categories
Code Talking

Close Your Tags in XHTML

During some conversations today, I found out that neither my experimental site nor my regular site was rendering in Mozilla. The culprit is not a new one. I had added some formatting to the page and forgot to close my tags.

Categories
Code Talking

Infrastructure Upgrades

I often have to change the location of web pages, and try to make sure nothing breaks in the process. Ideally, you won’t see any changes at all, and clients won’t lose any functionality whatsoever.

Categories
Code Talking

AS400 SQL

I had to use more SQL than usual the other day. It had been a while since I had much call to use SQL in my job for something more than a simple query, however. I needed to use it to update some records in a file as I really just didn’t want to write a program to do the work. SQL should have been much faster, had I a clue what I needed to do. Eventually, I struggled my way through it and it was much faster – assuming you didn’t count the time spent on the learning curve to get to where I could actually use it!

Categories
Code Talking

Serving Content

I came across a post by someone who found something I wrote to be useful. That’s cool. I’m glad someone is reading.

One thing that this post reminded me of, that I didn’t mention previously, is the MIME type of the document being served. In the case of HTML, the longstanding tradition has been to serve the document as text/html. This is what we’ve always done, and this is what most people continue to do now.

Categories
Code Talking

Creating CSS Buttons

I had a request the other day for some more information on creating buttons without the use of images. Hopefully I can shed some more light on the process.