Why would I get an error, "Unknown column 'street number' in 'field list' (line
25).
Line 25 is the last line in the insert query beginning with <cfqueryparam...
I figured there was a typo, but I can't see one.
<cfquery name="get_hmls_lots_land_data" datasource="c21ar">
select mls_number, listing_office as listing_office_mls_id, listing_agent
as
listing_agent_mls_id,
street_number, street_address as street_name
from hmls_lots_land_temp
</cfquery>
<cfloop query="get_hmls_lots_land_data">
<cfquery name="insert_data" datasource="c21ar">
insert into properties
( mls, mls_number, listing_office_mls_id,
listing_agent_mls_id, street_number,
street_name )
values ( <cfqueryparam cfsqltype='cf_sql_varchar'
value='hmls'>,
<cfqueryparam cfsqltype='cf_sql_varchar'
value='#get_hmls_lots_land_data.mls_number#_h'
null='#not len(trim(mls_number))#'>,
<cfqueryparam cfsqltype='cf_sql_varchar'
value='#get_hmls_lots_land_data.listing_office_mls_id#_h'
null='#not
len(trim(listing_office_mls_id))#'>,
<cfqueryparam cfsqltype='cf_sql_varchar'
value='#get_hmls_lots_land_data.listing_agent_mls_id#_h'
null='#not
len(trim(listing_agent_mls_id))#'>,
<cfqueryparam cfsqltype='cf_sql_varchar'
value='#get_hmls_lots_land_data.street_number#'
null='#not
len(trim(street_number))#'>,
<cfqueryparam cfsqltype='cf_sql_varchar'
value='#get_hmls_lots_land_data.street_name#'
null='#not len(trim(street_name))#'>
)
</cfquery>
</cfloop>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305630
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
