I need help deriving a sql statement that can select a specific criteria from my database.
Set Con = Server.CreateObject("ADODB.Connection")
Set catRS2 = Server.CreateObject( "ADODB.Recordset" )
catRS2.Open "SELECT * FROM AllJobTbl", Con
sqlString = "SELECT CASE CurrentValue WHEN 0 THEN 0 ELSE (Balance / CurrentValue) END AS column_alias FROM AllJobTbl"
Set objrs = Con.Execute(sqlString)
I need All Balance / Current Value to display those that are <= .65
also where "Credit" = "Fair" or "Poor"
WHERE "State" = AL, CA
And I need it to response a viewable table back to an asp page.
I cant seem to understand how to prevent buffer overflow on response.