missing operator fejl

Det betyder at du ikke har noget efter "hcity = "

Der skal stå noget der!

Det er en fejl i din sql-sætning! Prøv evt. at vise os hvordan du opbygger dit sql-statement?

dna

Er det i denne linie:

whtSQL = "Select hprice, bedroom, bath, haddress, hstreet, hID, LoginID, cPic1, squarefeet FROM homedetails where active = 2 and hcity = " & location & " and active = 2;"

Jeg ville tro der er fordi din variabel "location" er tom, og så får du en fejl da din sql ikke er rigtig.

Du kunne gøre:

IF NOT location = "" Then
sql2 = "and hcity = " & location & "
Else
sql2 = ""
End if

whtSQL = "Select hprice, bedroom, bath, haddress, hstreet, hID, LoginID, cPic1, squarefeet FROM homedetails where active = 2" & sql2 & " and active = 2;"

/korup

Korup, desværre - så får jeg blot vist alle annoncer uanset location. Men scriptet kører så, men ikke efter hensigten.
Jeg tillader mig lige at vise version 1.) Det oprindelige script som virker perfekt. Og version 2.) som nu laver ovenstående fejl. Jeg kan simpelthen ikke se fejlen i forskellen:

Version 1 som virker perfekt:
<!-- #INCLUDE VIRTUAL="/housing/common/header_main.asp" -->
<table border="0" cellspacing="2" cellpadding="6">
<tr>
   
    <td valign="top">
    <h3><%=thecity%></h3>
<%
whtSQL = "Select hprice, bedroom, bath, haddress, hstreet, hID, LoginID, cPic1, squarefeet FROM homedetails where active = 2 and hcity = " & location & " and active = 2;"
    'Response.Write whtSQL
    Set whtRS = Server.CreateObject("ADODB.RecordSet")
    whtRS.Open whtSQL, whtConn, 1, 3
    recordcount = whtRS.recordcount
    if recordcount > 0 then
        response.write("<table border=0 cellpadding=0 cellspacing=0 class=indent>")
        while not whtRS.EOF
        'SET VARIABLES
        bedroom = whtRS("bedroom")
        bath = whtRS("bath")
        LoginID = whtRS("LoginID")
        cPic1 = whtRS("cPic1")
        PicPath = "/housing/userfiles/" & LoginID & "/thumbs/" & cpic1
        haddress = whtRS("haddress") & " " & whtRS("hstreet")
        hID = whtRS("hID")
        hprice = whtRS("hPrice")
        squarefeet = whtRS("squarefeet")
%>
    <table width="100%" cellspacing="0" cellpadding="2" border="0">
        <tr>
            <td width="100%" height="1" colspan="4" valign="top"><hr noshade color="#000000" size=1></td>
        </tr>
        <tr>
            <td width="65" valign="top" rowspan="4" class="locationText">
            <a href="/housing/search_results.asp?hID=<%=hID%>">
            <% if cpic1 <> "" then %>
            <img src="<%=picpath%>" alt="<%=haddress%>" name="<%=haddress%>" border="0">
            <% else %>
            <img src="/housing/images/photo_not_yet_available.jpg" alt="Photo Not Yet Available" border="1">
            <% end if %>
            </a>   
            <a href="/housing/search_results.asp?hID=<%=hID%>">details</a></td>
           
            <td width="34%" nowrap class="locationText"><b>Price: </b><%=FormatCurrency(hPrice, 0)%></td>
            <td width="33%" nowrap class="locationText"><b>Bedrooms: </b><%=bedroom%></td>
        </tr>
   
        <tr>
            <td width="34%" nowrap class="locationText"><%=haddress%></td>
            <td width="33%" nowrap class="locationText"><b>Bathrooms: </b><%=bath%></td>
        </tr>
   
        <tr>
            <td width="34%" nowrap class="locationText"><%=city%></td>
            <td width="33%" nowrap class="locationText"><b>Square Ft: </b><%=squarefeet%></td>
        </tr>
    </table>
    <%
            whtRS.moveNext
            Wend
        end if

                whtRS.Close
                Set whtRS = Nothing
                closewht()
            %>
        </td>
    </tr>
</table>

-------------------
Version 2 som giver ovenstående fejl:
<!-- #INCLUDE VIRTUAL="/housing/common/header_main.asp" -->





<%
whtSQL = "Select hprice, bedroom, bath, haddress, hstreet, hID, LoginID, cPic1, squarefeet FROM homedetails where active = 2 and hcity = " & location & " and active = 2;"
    'Response.Write whtSQL
    Set whtRS = Server.CreateObject("ADODB.RecordSet")
    whtRS.Open whtSQL, whtConn, 1, 3
    recordcount = whtRS.recordcount
    if recordcount > 0 then
        response.write("<table border=0 cellpadding=0 cellspacing=0 class=indent>")
        while not whtRS.EOF
        'SET VARIABLES
        bedroom = whtRS("bedroom")
        bath = whtRS("bath")
        LoginID = whtRS("LoginID")
        cPic1 = whtRS("cPic1")
        PicPath = "/housing/userfiles/" & LoginID & "/thumbs/" & cpic1
        haddress = whtRS("haddress") & " " & whtRS("hstreet")
        hID = whtRS("hID")
        hprice = whtRS("hPrice")
        squarefeet = whtRS("squarefeet")
%>
   



<table BORDER='0' CELLPADDING='1' CELLSPACING='0' align='center' BGCOLOR='#929292'>
<tr>
<td>
<table width='400' align='center' cellpadding='0' cellspacing='0' border='0' bgcolor='#D2D2E3'>
<tr>
<td>
<table width='100%' cellpadding='0' cellspacing='5' border='0' bgcolor='#D2D2E3' align='center'>
<tr>
<td width='15'>&nbsp;</td>
<td valign='top'>
<a href="/housing/search_results.asp?hID=<%=hID%>">
        <% if cpic1 <> "" then %>
        <img src="<%=picpath%>" alt="<%=haddress%>" name="<%=haddress%>" border="0">
        <% else %>
        <img src="/housing/images/photo_not_yet_available.jpg" alt="Photo Not Yet Available" border="1">
        <% end if %>
        </a>   

</td>
<td>&nbsp;</td>
<td  nowrap class="locationText" valign='top' width='80%'>
   

<br><br>
<b>Location:</b><br>
<b>Type Of Home:</b><br>
<b>Size m2:</b> <%=squarefeet%><br>
<b>Bedrooms:</b><%=bedroom%><br>
<b>Furnishings:</b><%=bath%><br>
<b>Euro Price:</b><%=FormatCurrency(hPrice, 0)%><br>
<b>Description:</b>  Click on details to read more...<br><br>
<a href="/housing/search_results.asp?hID=<%=hID%>"><img src='images/details.gif' align='right' border='0'></a></td>
</tr>
</table>
</td></tr></table>


<%
            whtRS.moveNext
            Wend
        end if

                whtRS.Close
                Set whtRS = Nothing
                closewht()
            %>



</td></tr></table>


Håber meget I kan hjælpe :-)

Fejlen ligger ikke i selve scripetet men i at du ikke sender noget med i parameteren "location", har du sikret dig at den indeholder noget og at du har skrevet det ens allesteder :)

/korup

OK - Tak