[DiscordArchive] Hello all, i cannot create custom script bcs PQuery() cut SQL query?
[DiscordArchive] Hello all, i cannot create custom script bcs PQuery() cut SQL query?
Archived author: MaxtorCoder • Posted: 2022-04-02T13:39:17.946000+00:00
Original source
Yeah but we don't know what is different in a other core
Archived author: Sicker • Posted: 2022-04-02T13:40:55.740000+00:00
Original source
Im wait answer from official devs.
Archived author: Sicker • Posted: 2022-04-02T13:41:12.994000+00:00
Original source
Like modox, shauren and etc -_-
Archived author: Fabian • Posted: 2022-04-02T13:49:50.929000+00:00
Original source
I mean.. it’s p2p support here so in general i don’t see an issue
Archived author: ModoX • Posted: 2022-04-02T14:05:55.674000+00:00
Original source
<@316276139255398401> ur using sql wrong, ur mixing INSERT INTO and UPDATE
Archived author: ModoX • Posted: 2022-04-02T14:06:44.772000+00:00
Original source
Output being cut in console is intended (but its only in console, imagine having a 1 million lines statement being printed to console)
Archived author: ModoX • Posted: 2022-04-02T14:09:00.998000+00:00
Original source
```sql
INSERT INTO `table` (`column1`, `column2`) VALUES (val1, val2);
vs
UPDATE `table` SET `column1`=val1, `column2`=val2 WHERE blah;
```
Also non-text fields do NOT require '' around their values
Archived author: ZaDarkSide • Posted: 2022-04-02T14:09:14.200000+00:00
Original source
also check your queries in a sql client before of putting them in the code and compiling
Archived author: ZaDarkSide • Posted: 2022-04-02T14:09:39.115000+00:00
Original source
make a mockup with test values to see it's really working
Archived author: ZaDarkSide • Posted: 2022-04-02T14:09:47.278000+00:00
Original source
and not giving an error