View Single Post
  #3 (permalink)  
Old August 24th, 2011, 03:35 AM
disel2010 disel2010 is offline
Authorized User
Points: 448, Level: 7
Points: 448, Level: 7 Points: 448, Level: 7 Points: 448, Level: 7
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2011
Posts: 86
Thanks: 1
Thanked 12 Times in 12 Posts
Default

Hi 4Wheels,


looks like either common_name or group_nbr is empty or null.

The parameters are probably declared and initialised in content.asp, aren't they?
Best approach to debug this is to add some debug output in index.asp before line 31
Code:
response.write "<br>common_name: " & common_name
response.write "<br>group_nbr: " & group_nbr
response.flush
response.end
Or alternatively look at the entire sql statement (again to be added right before line 31):
Code:
response.write strSQL 
response.flush
response.end


Hope this helps.

Last edited by disel2010; August 24th, 2011 at 03:37 AM..
Reply With Quote
The Following User Says Thank You to disel2010 For This Useful Post:
4Wheels (August 25th, 2011)