28. september 2006 - 08:48Der er
2 kommentarer og 1 løsning
Fejl i SQL sætning
Hej, Jeg er ved at opgive, at finde fejlen i denne sql-sætning :(
Fejlmeldingen lyder "[Microsoft][ODBC SQL Server Driver][SQL Server]The column prefix 'tbl_products_list' does not match with a table name or alias name used in the query."
Jeg håber at I vil hjælpe mig videre.
sql = "select * from tbl_products_list, " & _ "(select count(*) from tbl_products_customerlists where tbl_products_customerlists.pID = tbl_products_list.pID and tbl_products_customerlists.cID="&cID&")as 'IsSelected' " & _ "from tbl_products_list order by pName ASC"
Hej igen, Nu er fejlen ændret?? Det er dog samme SQL sætning.
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'IsSelected'.
sql = "select * from tbl_products_list, " & _ "(select count(*) from tbl_products_customerlists where tbl_products_customerlists.pID = tbl_products_list.pID and tbl_products_customerlists.cID="&cID&")as 'IsSelected'" & _ "from tbl_products_list order by pName ASC"
sql = "select * from tbl_products_list, " & _ "(select count(*) from tbl_products_customerlists where tbl_products_customerlists.pID = tbl_products_list.pID and tbl_products_customerlists.cID="&cID&")as IsSelected" & _ " from tbl_products_list order by pName ASC"
jeg har netop lige rettet sql sætningen og det virker. Her er min løsning: sql = "select " & _ "* ," & _ "(" & _ "select " & _ "count(*) " & _ "from tbl_products_customerlists " & _ "where tbl_products_customerlists.pID = tbl_products_list.pID " & _ "and tbl_products_customerlists.cID= "&cID&"" & _ ") as 'IsSelected'" & _ "from tbl_products_list " & _ "order by pName ASC"
Synes godt om
Ny brugerNybegynder
Din løsning...
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.
