13/03/2003, 12:10
|
| | | Fecha de Ingreso: enero-2002 Ubicación: Perez Zeledon Costa Rica
Mensajes: 1.009
Antigüedad: 23 años, 3 meses Puntos: 11 | |
| erro de sintaxis
Ven donde esta el error?
yo no!
gsSQL = ""
gsSQL = gsSQL & "SELECT * FROM Auctions WHERE CategoryID = " & SQLVal(iCatID) & " "
gsSQL = gsSQL & " AND AvailDate <= " & SQLDate(NOW)
'gsSQL = gsSQL & " And Ended = 0AND AUCTIONS.ITEMID=FOTOS.ITEMID"
gsSQL = gsSQL & " And Ended = 0"
gsSQL = gsSQL & " AND ItemOwner = " & iOwnerId & " "
gsSQL = gsSQL & " ORDER BY pay= 1"
me marce esto:
SELECT * FROM Auctions WHERE CategoryID = 2 AND AvailDate <= #3/13/2003 12:42# And Ended = 0 AND ItemOwner = ORDER BY pay= 1
Microsoft OLE DB Provider for ODBC Drivers error '80040e09'
[TCX][MyODBC]You have an error in your SQL syntax near '' at line 1
/real-estate/viewsales-x.asp, line 58
la linea 58 es:
donde lee la consulta:
objPagingRS.Open gsSQL, GobjConnect, adOpenStatic, adLockReadOnly, adCmdText
Gracias!. |