more help needed

[noodleweb]

well in the hopes of getting some more help here goes
why doesnt this query work
i get a 500 internal sevrer error message and no debug info
:confused;

<cfquery name="features" datasource="852.com-property">
SELECT * FROM propmain,prop2
WHERE location = '#form.location#' AND propmain.ref = prop2.refid
<CFIF IsDefined("Form.minbeds") IS "YES">
<CFIF Form.minbeds IS NOT "">
AND propmain.bedrooms >= #Form.minbeds#
</CFIF>
</CFIF> </cfquery>

[mxstu]

Are you using Internet Explorer ?

[noodleweb]

yes i am
so i would like to know why there is no debug info for 500 errors.
i think i got the qeury stuff sorted.
after a table join do you refer to elements as the fiels name only without
table identifier.
this seems to work #refid# wheras #prop2.refid# causes servver error.

[mxstu]

I was having that same problem (HTTP 500 error). Try changing the following
settings in Internet Explorer to see it will display a more helpful error
message:
[Tools][Internet Options] [Advanced][Browsing] and uncheck "Show friendly HTTP
error messages"..