"Lakrom" <la****@terra.cl> wrote in message
news:GC****************@jagger.tie.cl...
hello to all, i have this sql sentence Set xRs=pCon.Execute("SELECT
sum(monto_abono) AS TpuntosM FROM con_vtas WHERE
RUTGTE='"&session("rut")&"'
and month("fecha")='#month("date")#'")
but this (month("fecha")='#month("date")#'") is correct?
the browser send me error "Error de compilación de Microsoft VBScript
(0x800A03EE)
Se esperaba ')'"
thank
--
Marco Antonio Artus S.
Lakromsoft INC.
56-9-9594663
Assign your sql query to a variable then
Set xRs=pCon.Execute(strsql)
I expect the compilation error will occur when your try to assign the
variable, because I am not sure if you have the right number of " marks,
hard to tell from looking.
Once you have that working, if you still get the error (and I think you will
because I don't know what month("date") is supposed to do), you can at least
do a response.write of the var so that you know what you are trying to
execute. You can then paste the output into MS Access (if you have it) and
run the query there, which will give you much more informative error
messages.
--
John Blessing
http://www.LbeHelpdesk.com - Help Desk software priced to suit all
businesses
http://www.room-booking-software.com - Schedule rooms & equipment bookings
for your meeting/class over the web.
http://www.lbetoolbox.com - Remove Duplicates from MS Outlook