could anyone tell me why this isnt working .Im getting back empty fields 

even though the table in the databse is populated 

Thanks 

Leigh 



set rs = conn.execute("select LastTrade from trade where StockName = '" & 

share & "' AND (getday =  '"& Date &  "') 

'pvariable = rs("LastTrade") 

if not rs.eof then 

pvariable = rs("LastTrade") 

else 

'no records in db 

end if 



set rs1 = conn.execute("select balance from sharesuser where UserName = '" 

& Session("strLogin") & "' ") 

if not rs.eof then 

balvarialbe = rs1("balance") 

else 

'no records in db 

end if 



'balvarialbe = rs1("balance") 



set rs5= conn.execute("select Quantity from sharesuser where ShareOption 

= '" & share & "'  ") 

if not rs.eof then 

qvariable = rs5 ("Quantity") 

else 

'no records in db 

end if 





costsofstock = (qleigh * pvariable ) 

updatebal = (balvarialbe + pvariable ) 

newquant =( qvariable - qleigh )