Recent content by bikebanditcom

muy bueno, gracias senor dan

wow, im an idiot sometime...thanks alot bro.

hey your great! thanks. if i could trouble you for one more problem that'd be great, or anyone else who may have an idea error is: Microsoft VBScript runtime error '800a01a8' Object required: '[string: "SELECT outerjoinPaid"]' /pbc/reporting/TMPawt1umvt0t.asp, line 9 sql is ...

thanks so much, that worked perfectly. :)

mark, that doesnt work, same error, however this code does set noBillSQL = pbcDB.execute("SELECT tblLots.lotNum, tblSales.saleDate, tblSales.projectName, tblSales.phase, tblSales.kbAmnt, tblSales.PBCAmnt, tblSales.VOO, tblSales.billed, tblSalesPackages.status FROM (tblSales INNER JOIN...

fixed it, i needed to remove the quotes around from complete, now i have this problem same error msg set noBillSQL = pbcDB.execute("SELECT tblLots.lotNum, tblSales.saleDate, tblSales.projectName, tblSales.phase, tblSales.kbAmnt, tblSales.PBCAmnt, tblSales.VOO, tblSales.billed...

the problem was that i needed single quotes around "completed", but now i've added a date range to the mix and am getting the same problem set noBillSQL = pbcDB.execute("SELECT tblLots.lotNum, tblSales.saleDate, tblSales.projectName, tblSales.phase, tblSales.kbAmnt...

mark, i've counted them all and they are all needed as far as i can tell, but i've also removed one set of them and i get the same problem :( damnit man it doesnt make any sense...

working on this statement and am getting <error> Microsoft VBScript compilation error '800a03ee' Expected ')' /pbc/reporting/xlReports/TMPz49damvdu9.asp, line 8 </error> the sql: <code> set compReport = pbcDB.execute(&quot;SELECT tblLots.lotNum, tblSales.saleDate...

that was it thanks so much, now im working on this statement and am getting Microsoft VBScript compilation error '800a03ee' Expected ')' /pbc/reporting/xlReports/TMPz49damvdu9.asp, line 8 set compReport = pbcDB.execute(&quot;SELECT tblLots.lotNum, tblSales.saleDate...

Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC Microsoft Access Driver] Missing ), ], or Item in query expression '(((tblSalesmen.salesmanName)= 'Hiram') AND (((tblSalesPackages.status)='Cancelled'))'. /pbc/reporting/cancelledReport.asp, line 8

thanks for the advice, now i have one other problem that has surfaced since fixing that Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC Microsoft Access Driver] Missing ), ], or Item in query expression '(((tblSalesmen.salesmanName)= Hiram) AND...

THANKS! let me go try that out. you guys are the best.

thanks for the advice, i was quickly able to determine the problem, fixed my dsn and now am not having these problems, but no my new problem is this: Microsoft VBScript compilation error '800a0409' Unterminated string constant /pbc/reporting/cancelledReport.asp, line 12 set cancelledSQL =...

this is what i have, but i get page cannnot be displayed: <%@LANGUAGE=&quot;VBSCRIPT&quot; CODEPAGE=&quot;1252&quot;%> <% salesman = request.form(&quot;salesman&quot;) set pbcDB = server.createObject(&quot;ADODB.Connection&quot;) pbcDB.open &quot;pbc&quot; theSQL =...