Doesnt connect #21

New Issue

wilderpizza · 2022-08-31T16:17:19Z

wilderpizza commented

2022-08-31 16:17:19 +00:00

Any Idea what i did wrong?

command /dbtest:
trigger:
set {sql} to the database "mysql://localhost:3306/skypixel?user=Pizza&password=*******useSSL=false"
execute "select alonsolevels from table" in {sql} and store the result in {_output::}
send {_output::}

Any Idea what i did wrong? command /dbtest: trigger: set {sql} to the database "mysql://localhost:3306/skypixel?user=Pizza&password=*********useSSL=false" execute "select alonsolevels from table" in {sql} and store the result in {_output::*} send {_output::*}

Govindas commented

2022-08-31 18:29:20 +00:00

Any errors? and your use of output variable seems wrong, should be
send {_output::table::*}

Any errors? and your use of output variable seems wrong, should be send {_output::table::*}

wilderpizza commented

2022-08-31 18:52:37 +00:00

command /dbtest:
trigger:
set {sql} to the database "mysql://localhost:3306/skypixel?user=Pizza&password=*******useSSL=false"
execute "select * from alonsolevels" in {sql} and store the result in {output::}
send "First entry in column: %{_output::table::}%"
send {_output::table::}

This also doenst work and theres no errors at all

command /dbtest: trigger: set {sql} to the database "mysql://localhost:3306/skypixel?user=Pizza&password=**********useSSL=false" execute "select * from alonsolevels" in {sql} and store the result in {output::*} send "First entry in column: %{_output::table::*}%" send {_output::table::*} This also doenst work and theres no errors at all

Govindas commented

2022-09-01 11:15:33 +00:00

use send last sql error

use `send last sql error`

wilderpizza commented

2022-09-01 15:24:47 +00:00

ik theres no errors if i use it