Why can’t I get something this simple to work…
<cfoutput query="qryWithData">
<cftry>
<cfquery name="addrecords" datasource="MyDSN">
Insert into tblVerity (listing_number, address, type, listing_price, beds, baths, districtAreaSchool)
VALUES (#qryWithData.listing_number#, ‘#qryWithData.address#’, ‘#qryWithData.type#’, #qryWithData.listing_price#, #qryWithData.beds#, #qryWithData.baths#, ‘#qryWithData.districtAreaSchool#’)
</cfquery>
<cfcatch>
<p>#error.diagnostics#</p>
</cfcatch>
</cftry>
</cfoutput>
Leave a Reply