Skip to content

SiteKickr Web Development

search
search
Jun04June 4, 2011Brick Wall, SQL / Database

MySQL GeomFromText Polygon returns null

Trying to add a POLYGON using GeomFromText? I don't know about you, but although it's documented as being able to "construct a geometry value of…

May27SQL / Database

MySQL full text search w/ relevance percentage

We're using an FAQ table below, to demonstrate how to return a result set that includes the keyword relevance as a percentage of the maximum…

May25Server / Performance, SQL / Database

Make those SQL queries chunky

I'm by no means saying that my tests below are evidence enough to support the case for "chunky" SQL queries. By chunky, I mean queries…

Apr29Brick Wall, SQL / Database

MySQL Duplicate Key issues

So you're doing a bulk import into your MySQL database, knowing that your primary key values are unique. Yet, MySQL throws the Duplicate Key message…

Mar21May 30, 2011ColdFusion, SQL / Database

ColdFusion / JDBC / MySQL & VarBinary fields

If you've used a varbinary field to store data, such as an encrypted password, you mind find that the JDBC Connector (used by ColdFusion) falls…

Mar12Algorithms, ColdFusion, Server / Performance, SQL / Database

Bulk inserts to reduce trips to database

By combining multiple inserts into one bulk insert statement, you can reduce the total number of statements sent to the database, speeding up combined execution…

Posts navigation

Previous 1 … 3 4
© 2025 SiteKickr