nstcl  >  Documentation  >  nstcl-database  >  ns_dbquotevalue

Tcl Powered!

ns_dbquotevalue

NAME

ns_dbquotevalue — Prepares a value string for inclusion in an SQL statement

SYNOPSIS

package require nstcl-database ?1.0?
package require nstcl ?1.0?

::nstcl::ns_dbquotevalue value ?type?

DESCRIPTION

Prepares a string for inclusion in an SQL statement. The default type is "text". Values of a numeric type ("decimal", "double", "integer", "int", "real", "smallint", "bigint", "bit", "float", "numeric", or "tinyint") are left alone. All other values are surrounded by single quotes and any single quotes in value are escaped with a pair of single quotes.

If value is the empty string, the value NULL is returned instead.

KEYWORDS

database, nstcl