How to store ExecuteScalar value into a variable?

• MayImU

  SSC Journeyman

  Points: 86

  More actions

  October 16, 2006 at 12:17 am

  #173184

  Hey guys, I am having some strange problem here. My code is as below:

  cmd.connection = cnn

  cmd.commandtext = "select count(*) from member"

  dim i as integer

  i = CInt(cmd.executeScalar)

  However, it return the result "&H0" to me! When i check my query in sqlquery, it did show me the result as "11".

  I have no idea on what is goin on, any help is appreaciated.ty.

• MayImU

  SSC Journeyman

  Points: 86

  More actions

  October 16, 2006 at 6:52 am

  #665971

  soli guys, my code is correct. I have make a mistake... =P

  cmd.connection = cnn

  cmd.commandtext = "select count(*) from member"

  label.text = CInt(cmd.ExecuteScalar)

  Anywhere, thanks u guys all =)

• David Burrows

  SSC Guru

  Points: 65144

  More actions

  October 16, 2006 at 7:43 am

  #665979

  Are you ignoring trapped errors?

  e.g. no permission to table

  If command fails, ExecuteScalar will return nothing and CInt will convert it to zero.

  Far away is close at hand in the images of elsewhere.
  Anon.