The lock is written into the query. You'll need to check into the correct syntax for your specific database.

Why do you need regex for this? Can you not use basic string functions like LEFT, MID, and RIGHT?

Have you added a loop to display the output?

<cfquery name="players" datasource="connsilvereagles">
SELECT *
FROM player
ORDER BY playernumber DESC</cfquery>

<cfoutput>
<table>
<cfloop...

Try the CFFormProtect:
http://cfformprotect.riaforge.org/