Tip: ColdFusion, SQL Azure, and embedded SQL 1

[TimeTraveler]

So you saw the other tip on configuring the driver for the datasource for using SQL Azure with ColdFusion 9.

Here is the next part.

Any embedded queries or stored procedures will likely cause some errors at some point without the following modifications. Mostly this applies to the embedded SQL between the CFQUERY tags.

BEFORE SQL AZURE

<CFQUERY NAME="myQry" ...>
SELECT * FROM foo WHERE ...
</CFQUERY>

AFTER WORKAROUNDS APPLIED

<CFQUERY NAME="myQry" ...>
SET NOCOUNT ON
SET ANSI_WARNINGS OFF
SELECT foo.[col1], foo.[coln], ... FROM foo WHERE ...
</CFQUERY>
<CFPARAM NAME="myQry.recordCount" DEFAULT="0">