Jump to content
Sign in to follow this  
Jat421

MySQL count

Recommended Posts

Hi,

How can I pass the count from the _Query() to MsgBox()

$i = _Query($sql, "select count(link_no) from temp_tbl")
   With $i
$a = .GetRows
EndWith
MsgBox(0,'Count',$a)

Share this post


Link to post
Share on other sites

count will only return one row, so to .getrows isn't the way. Try .value ;)

or maybe it's .fields(0).Value

i forget, but one should work

Edited by jdelaney

IEbyXPATH-Grab IE DOM objects by XPATH IEscriptRecord-Makings of an IE script recorder ExcelFromXML-Create Excel docs without excel installed GetAllWindowControls-Output all control data on a given window.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...