Hi,
I'd like to see how this is done, even though it is not necessary and I like my
ColdFusion thank you very much. Can someone give me a general idea of how this
code would look in SQL Server? It takes literally 5 minutes to write in CF; but
for me to put it into a SQL Server stored procedure I'm lost. Here's the code.
<cfquery datasource="#request.dsn#" name="qryLooper">
SELECT RecordType FROM LHF_Line
where quarter = '#lastQuarter#'
</cfquery>
<cfloop query="qryLooper">
<cfif recordtype eq "MC" or recordtype eq "NA">
<CFQUERY DATASOURCE="#request.dsn#">
INSERT INTO LHF_Line...abc
</CFQUERY>
<cfelse>
<CFQUERY DATASOURCE="#request.dsn#">
INSERT INTO LHF_Line...def
</CFQUERY>
</cfif>
</cfloop>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 &
Flex 2
Free Trial
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272686
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
