Why don't you make it a stored procedure?
-----Original Message-----
From: Jones, Becky [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 23, 2001 7:57 AM
To: CF-Talk
Subject: sql query
can anyone help me translate this FROM in my SQL query so CF will like it?
it works fine in SQL but bombs in CF with syntax errors.
FROM ((((INT_AUX_LISTING
LEFT JOIN int_aux_listing as CompanyListing
ON (int_aux_listing.company_list_id =
CompanyListing.Listing_ID)
AND (int_aux_listing.Company_list_src_id =
CompanyListing.Listing_src_id))
left JOIN INT_AUX_LST_ADDR
ON (INT_AUX_LISTING.LISTING_SRC_ID =
INT_AUX_LST_ADDR.LISTING_SRC_ID)
AND (INT_AUX_LISTING.LISTING_ID =
INT_AUX_LST_ADDR.LISTING_ID))
left JOIN INT_AUX_ADDRESS
ON (INT_AUX_LST_ADDR.ADDRESS_SRC_ID =
INT_AUX_ADDRESS.ADDRESS_SRC_ID)
AND (INT_AUX_LST_ADDR.ADDRESS_ID =
INT_AUX_ADDRESS.ADDRESS_ID)
left JOIN INT_AUX_LST_PHONE
ON (int_aux_listing.LISTING_ID =
INT_AUX_LST_PHONE.LISTING_ID)
AND (int_aux_listing.LISTING_SRC_ID =
INT_AUX_LST_PHONE.LISTING_SRC_ID))
left JOIN INT_AUX_PHONE
ON (INT_AUX_PHONE.PHONE_ID = INT_AUX_LST_PHONE.PHONE_ID)
AND (INT_AUX_PHONE.PHONE_SRC_ID =
INT_AUX_LST_PHONE.PHONE_SRC_ID))
left join int_phone_typ
on (int_aux_phone.phone_typ_id = int_phone_typ.phone_typ_id)
left join int_relation_typ as Phone_Relation_TYP
on (int_aux_lst_phone.rltn_typ_id =
phone_relation_typ.rltn_typ_id)
i was working with the query builder and it seemed like it was using {
instead of (.
thanks for your help
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
