Please help. I am creating a site that needs to do a search based on postocode from the postcode table and then use it to use the solicitorsid's it receives and search the solicitors details table and the fees tables. I have the following code

Code:
 <cfquery name="getpostcode" datasource="conveyancingshoppers"> SELECT solicitorsid from postcodesselected where RM="RM"</cfquery><cfloop query="getpostcode"><cfquery
...