trying to modify this page but I kee getting this error
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ')'.
/absadmin/newcarprospects.asp, line 104
here is the code...can't seem to figure out where the error is...
<%
'---------getting customers that has not been assigned to a dealership------
sql = "SELECT mastercustomers.*,creditunions.divisionID FROM mastercustomers INNER JOIN creditunions "
sql = sql & "ON mastercustomers.cuID=creditunions.cuID where mastercustomers.mastercusID not in(select customers.mastercusID from customers)"
'response.write sql
set newcus = conn.execute(sql)
%>
<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="../xxxx.css" rel="stylesheet" type="text/css">
</head>
<Body><center>
<table width="800" border="1" cellpadding="0" cellspacing="0" bordercolor="#000000">
<tr bgcolor="#CCCCCC" class="CategoryTxt">
<td width="7%" height="19"> </td>
<td width="15%" height="19" class="AdminTitle">Name</td>
<td width="14%" height="19" class="AdminTitle">Date-Time Rec</td>
<td width="10%" height="19" class="AdminTitle">Make </td>
<td width="10%" height="19" class="AdminTitle">Model</td>
<td width="23%" height="19" class="AdminTitle">ZipCode</td>
<td width="*" height="19" class="AdminTitle">Assign to Dealership</td>
</tr>
<%
x = 0
while not newcus.eof
fullname = newcus("lname") & ", " & newcus("fname")
car = newcus("yy") & " " & newcus("make")
fulladdress = newcus("zipcode")
mastercusID = newcus("mastercusID")
if x = 0 then
bg = "#FFFFFF"
x = 1
else
bg = "#CCCCCC"
x = 0
end if
%>
<tr bgcolor="<%=bg%>">
<td width="7%" class="blacktext10" height="19" align="center">
<a href="javascript
:HelpWindow=window.open('prospect. asp?mastercusID=<%=mastercusID%>',
'HelpWindow','copyhistory=yes,toolbar=no,directori es=0,menubar=0,scrollbars=1,resizeable=1,width=650 ,height=400') ;if
(window.name != HelpWindow) { HelpWindow.focus(); }"><img src="../images/view.gif" width="45" height="12" border="0"></a>
</td>
<td width="15%" class="blacktext10" height="19"><%=fullname%></td>
<td height="19" class="blacktext10" width="14%"><%=newcus("datetimesubmitted")%>
</td>
<td height="19" class="blacktext10" width="10%"><%=car%></td>
<td height="19" class="blacktext10" width="10%"><%=newcus("model")%> </td>
<td height="19" class="blacktext10" width="23%"><%=fulladdress%></td>
<td width="*">
<%
sql = "select makerID from makers where maker='"&newcus("make")&"'"
set ma = conn.execute(sql)
response.write" debug sql is " & sql & "
"
if ma.eof then
MMmakerID = 0
else
MMmakerID = ma("makerID")
end if
sql = "select dealerships.*,makers.maker from dealerships INNER JOIN makers ON "
sql = sql & "dealerships.makerID=makers.makerID where (dactive=1 and newused='New' and dealerships.makerID="&MMmakerID&" and divisionID="&newcus("makeID")&") order by dealername"
response.write "debug sql is " & sql & "
"
set dealers = conn.execute(sql)
%>
<select name="deaID" onChange="window.open('prospectassign.asp?mastercu sID=<%=newcus("mastercusID")%>&deaID='+this.option s[this.selectedIndex].value,'_top')" class="blacktext10">
<option></option>
<%
while not dealers.eof
%>
<option value="<%=dealers("deaID")%>"><%=dealers("dealerna me")%> (<%=dealers("maker")%> - <%=dealers("newused")%>)</option>
<%
dealers.movenext
wend
%>
</select>
</td>
</tr>
<%
newcus.movenext
wend
%>
</table>
help keep getting this error
