null string compared with number and sql account status

hi, thanks in advance...

1. if i do this:

	Code:
	dim snull, string, "" dim ssource, string, "12342" dim bequal, boolean isequal ssource,snull, bequal ifthen bequal, theend1 theend1:

i will get "type mismatch". i was actually using gettoken to go through a line, and using "" to know that there are no more tokens. however, some of the tokens are numbers("12342") and some of them are strings("onefive"), and i run into this type mismatch problem.
is there a way around this?

2. roughly, how can i use JAL or the SQL statements functions in 24x7 to see if a sql account(mssql express) is locked?

Hi,

Data type declarations are a mostly legacy thing in JAL. When comparing 2 variables, it compares their actual values. To prevent issues with numeric values, before comparison prefix both values by some alpha symbol, for example,

	Code:
	Concat "x", snull, x_snull Concat "x", ssource, x_ssource isEqual x_snull, x_ssource, bequal ...

um..the other thing is i'd really like to be able to run, lets say,

SELECT LOGINPROPERTY('loginname', 'IsLocked')

and assign the result of that to a variable in JAL.

is it possible to do that?

Thanks again!

Do you mean a database command? It is sure possible

	Code:
	// connect to database DatabaseConnect( ... profile_name_here... ) // run query DatabaseRetrieve( "SELECT ...", rows ) // get the value of first row, first column DatabaseGet( 1, 1, my_var ) // disconnect DatabaseDisconnect( )