Shurikn Posted September 20, 2004 Posted September 20, 2004 oki have this: requeteSql="SELECT Sum(CréditsDeVente) AS SumEnCours "+ "FROM tblProjet, tblIndividus "+ "WHERE statut=\"En cours\" "+ "AND tblProjet.ProjetIndividu=tblIndividus.NomPrénom "+ "AND tblIndividus.IndividuChargéDeCompte="+userId; the query is working in acess but it's not giving anything in asp.net is the SUm not working or something? if you need more details, please ask. ill check in aboiut an hour, then tomorow morning Quote
Arch4ngel Posted September 20, 2004 Posted September 20, 2004 First... I recommend switching "CréditDeVente" by "[CréditDeVente]". Every part where is an acute or anything on your identifier... make some [...] around it. so.... tblIndividus.NomPrénom will become tblIndividus.[NomPrénom] and so on.... It should be more compatible Quote "If someone say : "Die mortal !"... don't stay to see if he isn't." - Unknown "Learning to program is like going out with a new girl friend. There's always something that wasn't mentioned in the documentation..." - Me "A drunk girl is like an animal... it scream at everything like a cat and roll in the grass like a dog." - Me after seeing my girlfriend drunk and some of her drunk friend. C# TO VB TRANSLATOR
bri189a Posted September 20, 2004 Posted September 20, 2004 What are you using to execute the SQL; it should be ExecuteScalar I believe. Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.