Uploading data to a mySQL database

General
21

right thats what i did. I set the debug node to display the complete msg object but it is still showing this error:

"Invalid property expression: unexpected ' at position 4"

which is pretty strange because is shoeld be seeing the query in the msg.topic right?

22

I did untill i changed my query to this thanks to the help of @shrickus

INSERT INTO algemeen
    (machine, persoon, status, overtime)
VALUES
(
    {{ flow.get('machine') }},
    {{ flow.get('persoon') }},
    {{ flow.get('statusGoed') }},
    {{ flow.get('overtime') }}
)

but i should not be getting permission denied errors because the users has all of the permisions.

23

I can't try a new client as of right now because the server running on a server and not on my laptop

24

The syntax for flow context is not correct for the template node. Try

INSERT INTO algemeen
    (machine, persoon, status, overtime)
VALUES
(
    {{flow.machine}},
    {{flow.persoon}},
    {{flow.statusGoed}},
    {{flow.overtime}}
)

It is possible to use a property from the flow context or global context. Just use {{flow.name}} or {{global.name}} , or for persistable store store use {{flow[store].name}} or {{global[store].name}}

25

right. well your solution seems to work a bit better but it is still giving me an syntax error for some reason:

image
image594Ɨ1215 65.8 KB

26

Flow.persoon seems to be blank does it exist, the error seems to be the 2 commas in succession.

27

value is missing in the query

28

well flow.persoon definitly exists but i removed it anyway. got a new error though:

"Error: ER_BAD_FIELD_ERROR: Unknown column 'S' in 'field list'"
29

Should the strings be in quotes?
[edit]

I see at least two strings in your query.

30

Yes must have "S-110-1"

31

right so how do i do that?
because this is my query

INSERT INTO algemeen
    (machine, persoon, status, overtime)
VALUES
    (
        {{flow.machine}},
        {{flow.statusGoed}},
        {{flow.overtime}}
    );

and this is the output im gettinh:

INSERT INTO algemeen
    (machine, persoon, status, overtime)
VALUES
    (
        ,
        ,
        
    );

so where should i put the "?

32

First you need to confirm the flow context exists check in info pane under context . refresh the flow context and post here.

quotes go around strings

        '{{flow.machine}}',
        '{{flow.statusGoed}}',
        {{flow.overtime}}

and remove persoon from columns

33

oh i'm dumb

and remove persoon from columns

i forgot to remove "persoon" -_-

34

right it seems to work now. i'm going to need to experiment some more before i close this topic. But for now i'd like to thank all of you for the help i've gotten.