|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
February 16th, 2005, 11:02 PM
|
|||
|
|||
|
any1 knows wat is the new value?
SQLSt2 = "SELECT JOBNO,SNO,CUSTOMER,DATENO, COUNT(*) as NUMBERFROM MAIN_TA WHERE CUSTOMER = '" & customer & "'"
this is my sql statment..... is my count(*) syntax correct? how do i do a response.write on the number of tuples return?? can any1 enlighten me?? The search returns <b></b><%response.write(rs2.Fields("NUMBER").value)%></b> results. the above gives me an error that Item cannot be found in the collection corresponding to the requested name or ordinal. ????
|
|
#2
February 16th, 2005, 11:12 PM
|
|||
|
|||
|
i think your sql statement must be like this :
Quote:
|
|
| Viewing: ASP Free Forums > Database > Microsoft SQL Server > any1 knows wat is the new value? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
