<cftransaction>
<cfloop index="i" from="1" to="11">
<cfquery datasource="zzCL" result="result">
insert into aAccess
(accessLevel, accessName)
values (\'#i#\',\'accessName#i#\')
</cfquery>
</cfloop>
<cfloop index="i" from="1" to="101">
<cfquery datasource="zzCL">
insert into aAccounts
(accountName)
values (\'accountName#i#\')
</cfquery>
</cfloop>
<cfloop index="i" from="1" to="1001">
<cfquery datasource="zzCL">
insert into aUsers
(firstName, lastName)
values (\'firstName#i#\', \'lastName#i#\')
</cfquery>
<cfloop index="ii" from="1" to="101">
<cfset random = randRange(1,11)/>
<cfquery datasource="zzCL">
insert into aUserAccounts
(accountId, userId, accessLevel)
values (\'#ii#\', \'#i#\', \'#random#\')
</cfquery>
</cfloop>
</cfloop>
</cftransaction>