|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
|
|||
|
|||
|
Mysql Help With Asp
I just made a query on SQL Query Analyzer... I am wondering how to change the code from query analyzer to make it work with ASP... any help would be appreciated, code below:
SELECT UPPER(ts.DateSubmitted) AS Date, UPPER(ts.CompanyName) AS Company, UPPER(ts.SupportType) AS SupportType, UPPER(ts.FirstName) AS FirstName, UPPER(ts.LastName) AS LastName, UPPER(ts.Question1) AS Problem FROM TechnicalSupport ts WHERE (ts.SupportType = 'Corporate Employee' or ts.SupportType = 'Field Inspector' or ts.SupportType = 'Customer' or ts.SupportType = 'Consumer') AND ts.DateSubmitted > '1/1/2005' GROUP BY ts.CompanyName, ts.SupportType, ts.FirstName, ts.LastName, ts.DateSubmitted, ts.Question1 ORDER BY DateSubmitted ASC |
|
#2
|
|||
|
|||
|
Please do not crosspost. You should get the help you need in the ASP forum.
__________________
"A pawn is the most important piece on the chessboard -- to a pawn" |
![]() |
| Viewing: Dev Articles Community Forums > Databases > MySQL Development > Mysql Help With Asp |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|