SELECT * FROM VDBM_tblPlants LIMIT 1
Unable to request safe column list from datasource!
Please notify an administrator!
ArrayAppend(cols, "`OWNERNAME`");
ArrayAppend(vals, "'#Cookie.u#'");
ArrayAppend(cols, "`ID`");
ArrayAppend(vals, "''");
ArrayAppend(cols, "`DateEntered`");
ArrayAppend(vals, "'#DateFormat(Now(), "yyyy-mm-dd")# #TimeFormat(Now(), "HH:mm:ss tt")#'");
thisVal = trim(evaluate("Form.#item#"));
thisVal = PreserveSingleQuotes(thisVal);
ArrayAppend(cols, "`#item#`");
ArrayAppend(vals, "'#thisVal#'");
INSERT INTO `VDBM_tblPlants` (#ArrayToList(cols, ", ")#) VALUES (#ArrayToList(vals, ", ")#)
Error inserting new record!
Please notify an administrator.
StructDelete(Form, item);
SELECT Size FROM VDBM_tblPlants GROUP BY Size ORDER BY Size
Unable to collect a list of Sizes!
Please notify an administrator.
SELECT Hybridizer FROM VDBM_tblPlants GROUP BY Hybridizer ORDER BY Hybridizer
Unable to collect a list of Hybridizers!
Please notify an administrator.
SELECT BloomColor FROM VDBM_tblPlants GROUP BY BloomColor ORDER BY BloomColor
Unable to collect a list of BloomColors!
Please notify an administrator.
SELECT BloomType FROM VDBM_tblPlants GROUP BY BloomType ORDER BY BloomType
Unable to collect a list of BloomTypes!
Please notify an administrator.
SELECT LeafColor FROM VDBM_tblPlants GROUP BY LeafColor ORDER BY LeafColor
Unable to collect a list of LeafColors!
Please notify an administrator.
SELECT LeafType FROM VDBM_tblPlants GROUP BY LeafType ORDER BY LeafType
Unable to collect a list of LeafTypes!
Please notify an administrator.
SELECT Source FROM VDBM_tblPlants GROUP BY Source ORDER BY Source
Unable to collect a list of Sources!
Please notify an administrator.
SELECT Location FROM VDBM_tblPlants GROUP BY Location ORDER BY Location
Unable to collect a list of Locations!
Please notify an administrator.
SELECT growthHabit FROM VDBM_tblPlants GROUP BY growthHabit ORDER BY growthHabit
Unable to collect a list of GrowthHabits!
Please notify an administrator.
if (NOT IsDefined("Form.#item#")) {
evaluate("Form.#item#=''");
}
Type values for these fields and then press enter.
Several fields, like DateEntered, are populated automatically.