Wednesday, 15 May 2013

vbscript - Populating the Condition of IF statement from a database in SQL Server -



vbscript - Populating the Condition of IF statement from a database in SQL Server -

i want populate status of if statement table in database stored in sql server. retrieving status sql server using:

... sql_cond = "select cond condition" recordset.open sql_cond,connstring cond = recordset(0).value msgbox cond ...

this shows status in msgbox, status '0.8*table_a_rows > table_b_rows' stored varchar in sqlserver. want utilize status in if statement follows

... if (cond) ... 'process ... end if

so can status string typecasted datatype not show type mismatch , when placed within parameter of if? feasible ?

the next works in vbscript:

... dim cond = a>b 'which datatype this?? lets phone call status info type if (cond) msgbox "a>b" else msgbox "a<b"

but can string converted status info type usage in if statement?

eval() should want.

sql-server vbscript

No comments:

Post a Comment