Carencia Native Nursery
      16101 Carencia Lane  ▪  Odessa, FL  33556

    Home | About Us | Return to Current Inventory  | Contact Us
 
<% 'Setup connection and recordset objects set conn = server.createobject("adodb.connection") conn.open strconn set rs = server.createobject("adodb.recordset") ' get the record to fill the updateForm ' Set SQL statement strSQL = "SELECT * FROM Plants WHERE ID= " & record_ID 'Open the Recordset object and retrieve data rs.Open strSQL,conn, adOpenStatic %> <% dollars = rs("Price") %>