|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
February 7th, 2005, 04:39 AM
|
|||
|
|||
What's wrong?pls help
hey, i dunno what's wrong with this query, i tried running it but nothing was return (there r exisitng records)! is it becos there are 2 conditions for grade?wen i tried running it based one condition it works.i need two condition cause the statement is something like Grade is greater and equals.
"Select Count(*) as ct from ABSSubGrade where Grade > " 1.4 " AND Grade = " 1.4 " AND ABSID = "&rs1("ABSID")&"" can anybody assist me?
|
|
#2
February 7th, 2005, 04:46 AM
|
||||
|
||||
|
ok firstly have you tried this statement in your SQL database?
I believe that there are two errors: 1) A grade can not be greater than ">" 1.4 AND equal to "=" to 1.4 at the same time, it could be greater than or equal to ">=" 1.4 2) It appears that its an asp statement, and the string is not concatenated correctly. try this: Code:
SQLString = "select count(*) from ABSSubGrade where grade >= 1.4 AND ABSID = """ & rs1("ABSID") & """
|
|
| Viewing: ASP Free Forums > Database > SQL Development > What's wrong?pls help |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
