Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SELECT COUNT not counting always gives value of 1

Status
Not open for further replies.
gavray

gavray

Programmer
Jul 17, 2000
65
GB
Hi,

I've just converted from MS ACCESS and understand that u can't use rs.REcordcount to get the number of values in a field. I've got the code below which gives me the value 1 for all cases when they range from 1 to 10, in many instances.

sql2 = "SELECT ID,SongView,Song,Count(ID) AS num FROM SongTable"
sql2=sql2 & " WHERE myID = "&myID
sql2=sql2 & " AND LiveSong=1"
sql2=sql2 & " Group by SongView,Song"

numberofsongs=rs("num")

Any ideas please,

Many Thanks

Gavin
[afro2]
the boho from soho
 
Status
Not open for further replies.

Similar threads

BobThornton
  • Locked
  • Question
Drop/Truncate tables based on a stored procedures value 1
Replies
6
Views
281
BobThornton
BobThornton
waubain
  • Locked
  • Question
mysqli_multi_query not not returning any results
Replies
2
Views
217
waubain
waubain
madcelt
  • Locked
  • Question
Select query not showing error but not showing result either
Replies
2
Views
89
madcelt
madcelt
Samus Aran
  • Locked
  • Question
Looking for specific data using SELECT
Replies
0
Views
86
Samus Aran
Samus Aran
FoxAll
  • Locked
  • Question
Lots of data !
Replies
0
Views
62
FoxAll
FoxAll

Part and Inventory Search

Sponsor

Back
Top