Just one of my tables went read only about an hour ago and created problems.
I couldn't figure out what was wrong so I rebooted my server and then it started working again.
Here is the code that writes to the table Stats, do I need a CFLock around the query to prevent this?
I couldn't figure out what was wrong so I rebooted my server and then it started working again.
Here is the code that writes to the table Stats, do I need a CFLock around the query to prevent this?
Code:
<cfquery name="InsertStat" datasource="#DSN#">
INSERT INTO Stats (listingFk, ipAddress_stats)
VALUES (<cfqueryparam value=#URL.ad# cfsqltype="cf_sql_integer"/>, <cfqueryparam value=#REMOTE_ADDR# cfsqltype="cf_sql_varchar"/>)
</cfquery>