VBscript for adodb query

Question

I need to add a few lines to our billing system, and I don't know enough about the syntax of this call. Can someone tell me what the zero's in the first line of this query means?

 strSqlStmt = strSqlStmt & "SELECT Trim(users.PILastName & ' ' & users.PIFirstName), 0, 0, 0, 0, Count(plab.billing), 0, 0, 0 " strSqlStmt = strSqlStmt & "FROM plab, pform, users, userinfo " strSqlStmt = strSqlStmt & "WHERE userinfo.PI=users.PI " strSqlStmt = strSqlStmt & " AND UCase(users.location) ='S' " strSqlStmt = strSqlStmt & " AND plab.sampleid=pform.sampleid " strSqlStmt = strSqlStmt & " AND plab.email=userinfo.email " strSqlStmt = strSqlStmt & " AND plab.finisheddate Between " & dtmRange & " " strSqlStmt = strSqlStmt & " AND plab.finished=True " strSqlStmt = strSqlStmt & " AND plab.billing = 1 " strSqlStmt = strSqlStmt & "GROUP BY Trim(users.PILastName & ' ' & users.PIFirstName) "

Those are just constants that are going to be output as part of the query as column values. — Roberto Hernandez
– Roberto Hernandez, Commented May 3, 2013 at 17:34

peterm · Accepted Answer · 2013-05-03 17:42:32Z

2

It's just static (constant) values 0 return in positions (columns) specified from SELECT statement

Here is a SQLFiddle example

edited May 3, 2013 at 17:42

answered May 3, 2013 at 17:34

peterm

93k16 gold badges157 silver badges162 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

A. Cristian Nogueira Over a year ago

+1 for the nice explanation and the SQLFiddle example.

Collectives™ on Stack Overflow

VBscript for adodb query

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related