|
Lines 756-768
int format3(struct ftio *ftio, struct op
Link Here
|
| 756 |
strcat (query, fields); |
756 |
strcat (query, fields); |
| 757 |
strcat (query, ") VALUES ("); |
757 |
strcat (query, ") VALUES ("); |
| 758 |
strcat (query, values); |
758 |
strcat (query, values); |
| 759 |
strcat (query, ")"); |
759 |
strcat (query, ")"); |
| 760 |
|
760 |
|
| 761 |
if (debug) |
761 |
/* if (debug) |
| 762 |
fprintf(stderr, "field=%s\n val=%s\n query=%s\n", fields, values, |
762 |
fprintf(stderr, "field=%s\n val=%s\n query=%s\n", fields, values, |
| 763 |
query); |
763 |
query); |
|
|
764 |
*/ |
| 764 |
|
765 |
|
| 765 |
if (mysql_real_query(&mysql, query, strlen(query)) != 0) |
766 |
if (mysql_real_query(&mysql, query, strlen(query)) != 0) |
| 766 |
fterr_warnx("mysql_real_query(): %s", mysql_error(&mysql)); |
767 |
fterr_warnx("mysql_real_query(): %s", mysql_error(&mysql)); |
| 767 |
|
768 |
|
| 768 |
} |
769 |
} |
|
Lines 927-939
int format5(struct ftio *ftio, struct op
Link Here
|
| 927 |
strcat (query, fields); |
928 |
strcat (query, fields); |
| 928 |
strcat (query, ") VALUES ("); |
929 |
strcat (query, ") VALUES ("); |
| 929 |
strcat (query, values); |
930 |
strcat (query, values); |
| 930 |
strcat (query, ")"); |
931 |
strcat (query, ")"); |
| 931 |
|
932 |
|
| 932 |
if (debug) |
933 |
/* if (debug) |
| 933 |
fprintf(stderr, "field=%s\n val=%s\n query=%s\n", fields, values, |
934 |
fprintf(stderr, "field=%s\n val=%s\n query=%s\n", fields, values, |
| 934 |
query); |
935 |
query); |
|
|
936 |
*/ |
| 935 |
|
937 |
|
| 936 |
res = PQexec(conn, query); |
938 |
res = PQexec(conn, query); |
| 937 |
if (!res || PQresultStatus(res) != PGRES_COMMAND_OK) { |
939 |
if (!res || PQresultStatus(res) != PGRES_COMMAND_OK) { |
| 938 |
PQclear(res); |
940 |
PQclear(res); |
| 939 |
fterr_errx(1,"PQexec(): %s\n", PQerrorMessage(conn)); |
941 |
fterr_errx(1,"PQexec(): %s\n", PQerrorMessage(conn)); |
