Charlie Arehart

It may be hard to believe, but there are times when you should pay careful attention to case (use of upper and lower case letters) when spelling the datasource name in a CFQUERY tag. Case sensitivity is a common issue in Unix environments, but there is an issue that can arise unexpectedly in Windows environments.

If you issue an updating statement (SQL INSERT, UPDATE, or Delete) or CFUPDATE/CFINSERT tag in one template and use CFLOCATION to go to another template to do a query against the same datasource to displays the record(s) you just updated, and the case of the datasource names in the two templates does not match, the updates won't be reflected on that next page's query results until it is refreshed. It's true! The record is indeed updated as expected, but for some reason the results are not depicted until the page is refreshed. (A previous version of this tip said the case must match the name of the datasource as defined in the administrator, but I've since learned that it's just a question of them matching each other on the two pages.)

In an example application, simply changing the case of the datasource name of the two templates to match each other solved the problem. Allaire has recognized the problem but has no solution as yet.

Charlie Arehart Education Director, Fig Leaf Software