X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;f=doc%2Fref_clsql.xml;h=c24b2ced5462fb4ac7780fcd83e973e22638a296;hb=d4bb1303dea9ba6734b86abc34e904edb3e36f6f;hp=9f5c0d67514818d6cffa5c73e846c7640f4bed32;hpb=e5744a78271044484b3399d4fc1d55b3e8808784;p=clsql.git diff --git a/doc/ref_clsql.xml b/doc/ref_clsql.xml index 9f5c0d6..c24b2ce 100644 --- a/doc/ref_clsql.xml +++ b/doc/ref_clsql.xml @@ -1680,7 +1680,7 @@ The default is &nil;. success - A boolean flag. If &t;, a new database wa + A boolean flag. If &t;, a new database was successfully created. @@ -1700,6 +1700,7 @@ The default is &nil;. => T (create-database '("localhost" "new" "dent" "badpasswd") :database-type :mysql) +=> Error: While trying to access database localhost/new/dent using database-type MYSQL: Error database-create failed: mysqladmin: connect to server at 'localhost' failed @@ -1716,8 +1717,7 @@ error: 'Access denied for user: 'root@localhost' (Using password: YES)' Exceptional Situations An exception will be thrown if the database system does not allow new databases to be created or if database creation - fails. Currently, only the :postgresql-socket - does not allow new databases to be created. + fails. Notes @@ -1762,7 +1762,7 @@ error: 'Access denied for user: 'root@localhost' (Using password: YES)' success - A boolean flag. If &t;, a new database wa + A boolean flag. If &t;, the database was successfully destroyed. @@ -1782,6 +1782,7 @@ error: 'Access denied for user: 'root@localhost' (Using password: YES)' => T (destroy-database '("localhost" "new" "dent" "dent") :database-type :postgresql) +=> Error: While trying to access database localhost/test2/root using database-type POSTGRESQL: Error database-destory failed: dropdb: database removal failed: ERROR: database "test2" does not exist @@ -1797,9 +1798,7 @@ Error: While trying to access database localhost/test2/root Exceptional Situations An exception will be thrown if the database system does not allow databases to be removed, the database does not exist, or - if database removal fails. Currently, only the - :postgresql-socket does not allow - databases to be destroyed. + if database removal fails. Notes @@ -1817,7 +1816,7 @@ Error: While trying to access database localhost/test2/root PROBE-DATABASE - tests for existance of a database + tests for existence of a database Function @@ -1853,7 +1852,7 @@ Error: While trying to access database localhost/test2/root Description - This function tests for the existance of a database in + This function tests for the existence of a database in the database system specified by database-type. @@ -1872,8 +1871,8 @@ Error: While trying to access database localhost/test2/root Exceptional Situations An exception maybe thrown if the database system does - not receive administrator-level authentication. This function - may need to read the administrative table of the database + not receive administrator-level authentication since function + may need to read the administrative database of the database system. @@ -2100,7 +2099,7 @@ Error: While trying to access database localhost/test2/root Syntax - query query-expression &key database result-types => result + query query-expression &key database result-types field-names => result Arguments and Values @@ -2165,6 +2164,15 @@ Error: While trying to access database localhost/test2/root + + field-names + + A boolean with a default value of &t;. When &t;, this + function results a second value of a list of field + names. When &nil;, this function only returns one value + - the list of rows. + + result