SELECT ALL

[Work23]

Hello. I would like to do a SELECT ALL or SELECT * from the table in this code below. How would I actually code that?





SQLString = "SELECT" &_
" COUNT(*) AS Views," &_
" ESOLDTO" &_
" FROM" &_
" STATS" &_
" WHERE" &_
" EVENTNAME = 'LOGIN' AND" &_

" ETIMESTAMP BETWEEN '" & Request.Form("txtFromDate") & " 00:00:00' AND '" & Request.Form("txtToDate") & " 23:59:00'" &_
" GROUP BY" &_
" ESOLDTO" &_
" ORDER BY " &_
orderByText & ";

 

[Sheco]

Do you mean: SELECT * FROM STATS ???

If not I'm afraid I don't understand the question.

 

[Work23]

Is that how you would code that within a SQLString within an ASP program?

 

[DotNetGnat]

Yes. Did you try it to see if it is working?

-DNG

 

[Sheco]

What error do you see when you use:
SQLString = "SELECT * FROM STATS"

There is no problem with this syntax so there must be some other explanation for an error.

 

[Work23]

Actually, I think the ASP program has other parameters in it that are not allowing it to display the neccessary data. Im going to try to see if I can get around it. Thanks so much.

 

[DotNetGnat]

Post the error here so that we can suggest you in the right direction...

Thanks

-DNG

 

[Work23]

Sorry. I didn't make it clear in the last post. There isn't actually an error. And I have it working now. Thanks so much again.