<% function stilling(TEAMNAME) { var sqlquery = "insert stilling select "+TEAMNAME+".... conn1 = conn.execute(sqlquery); } %> ************************************************
Fejlen er: ************************************************ Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'AGF'. /dabweb03/stilling.asp, line 9
Linie 9 er den linie der begynder med "var sqlquery"
I lang tid har samarbejdsbranchen fokuseret på at forbedre enhedsfunktioner – bedre kameraer, klarere lyd og smartere software. Men den virkelige forvandling handler ikke om funktioner.
jeg skal have sat mange forskelligeværdier ind i den sammetabel,ogikke kun en.
************************************************************************ var sqlquery = "insert stilling select "+teamname+" , count(matchday), ( select sum(home_team_points)from matches where home_team="+ teamname+")+( select sum(away_team_points)from matches where away_team="+ teamname+") ,( select sum(home_team_goals)from matches where home_team="+ teamname+")+( select sum(away_team_goals)from matches where away_team="+ teamname+"),( select sum(home_team_goals)from matches where away_team="+ teamname+")+( select sum(away_team_goals)from matches where home_team="+ teamname+"),( select sum(home_team_points)from matches where home_team="+ teamname+"),(select sum(home_team_goals) from matches where home_team ="+ teamname+"),(select sum(away_team_goals) from matches where home_team="+ teamname+"),( select sum(away_team_points)from matches where away_team="+ teamname+") ,(select sum(away_team_goals) from matches where away_team ="+ teamname+"),(select sum(home_team_goals) from matches where away_team="+ teamname+") from matches where (home_team="+ teamname+" or away_team="+ teamname+")" **************************************************************************
Det ser ud til at du kun mangler nogle ' omkring strenge.
var sqlquery = "insert stilling select '"+teamname+"' , count(matchday), ( select sum(home_team_points)from matches where home_team='"+ teamname+"')+( select sum(away_team_points)from matches where away_team='"+ teamname+"') ,( select sum(home_team_goals)from matches where home_team='"+ teamname+"')+( select sum(away_team_goals)from matches where away_team='"+ teamname+"'),( select sum(home_team_goals)from matches where away_team='"+ teamname+"')+( select sum(away_team_goals)from matches where home_team='"+ teamname+"'),( select sum(home_team_points)from matches where home_team='"+ teamname+"'),(select sum(home_team_goals) from matches where home_team='"+ teamname+"'),(select sum(away_team_goals) from matches where home_team='"+ teamname+"'),( select sum(away_team_points)from matches where away_team='"+ teamname+"') ,(select sum(away_team_goals) from matches where away_team='"+ teamname+"'),(select sum(home_team_goals) from matches where away_team='"+ teamname+"') from matches where (home_team='"+ teamname+"' or away_team='"+ teamname+"')"
Og det svarer også fint til fejlen med at den ikke kunne finde en kolonne der heller AGF.
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.
