Jump to content
Xtreme .Net Talk

Recommended Posts

Posted

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

Posted

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

"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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...