M
SS
CSSC
KSSKC
P
Y
. I need help accessing tables in databases. I have created a database and binded it to my worker through workers.toml file. But when I make a search in a particular table, it gives "no such table" error. Here is an image of tables in my database, "Customers" is just for test purposes.
Y
app.get('/posts/:lang/:slug/comments', async c => {
const { results } = await c.env.comDB.prepare();
return c.text(results, 200);
}Y
YC
—local flag
ICIIY
C
.all()Error: D1_TYPE_ERROR: Type 'boolean' not supported for value 'true'CPP
email_verified BOOLEAN DEFAULT 0,PCtrue1
R
U
T
K
G
HGHGH
H
INSERT INTO 'tablename' ('column1', 'column2') VALUES
('data1', 'data2'),
('data3', 'data4'),
('data5', 'data6'),
('data7', 'data8');`app.get('/posts/:lang/:slug/comments', async c => {
const { results } = await c.env.comDB.prepare();
return c.text(results, 200);
}—localError: D1_TYPE_ERROR: Type 'boolean' not supported for value 'true'email_verified BOOLEAN DEFAULT 0,