<% 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 dette særtema ser vi på, hvordan cloud og AI bliver fundamentet for virksomhedernes digitale forretning, og hvordan de nye muligheder for automatisering og forretningsværdi kan udnyttes uden at miste overblik, sikkerhed og menneskelig kontrol.
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.
