Fossil

Differences From Artifact [099b1647e2]:

• File src/db.c — part of check-in [4db6d7c5ce] at 2011-10-02 19:56:46 on branch json — Added empty_Stmt, analog to empty_Blob, to work around an assertion triggered during some error handling code. (user: stephan size: 65856)

To Artifact [c2652e950e]:

• File src/db.c — part of check-in [30431ff903] at 2011-10-05 03:32:18 on branch json — const-correctness tweak in db_text(). (user: stephan size: 65862)

576
577
578
579
580
581
582
583
584
585
586
587
588
589
590

/*
** Execute a query.  Return the first column of the first row
** of the result set as a string.  Space to hold the string is
** obtained from malloc().  If the result set is empty, return
** zDefault instead.
*/
char *db_text(char *zDefault, const char *zSql, ...){
  va_list ap;
  Stmt s;
  char *z;
  va_start(ap, zSql);
  db_vprepare(&s, 0, zSql, ap);
  va_end(ap);
  if( db_step(&s)==SQLITE_ROW ){

|

576
577
578
579
580
581
582
583
584
585
586
587
588
589
590

/*
** Execute a query.  Return the first column of the first row
** of the result set as a string.  Space to hold the string is
** obtained from malloc().  If the result set is empty, return
** zDefault instead.
*/
char *db_text(char const *zDefault, const char *zSql, ...){
  va_list ap;
  Stmt s;
  char *z;
  va_start(ap, zSql);
  db_vprepare(&s, 0, zSql, ap);
  va_end(ap);
  if( db_step(&s)==SQLITE_ROW ){