I am consulting my database and the process presents a single error when loading the data in the JsonResults gives me an error: "500 - Internal Server Error
The server encountered an unexpected condition that prevented it from fulfilling the request." , any suggestions
Dim db As mySQLCommunityServer
db=New mySQLCommunityServer
db.host=“192.68.1.139”
db.databaseName=“admin”
db.userName=“pruebas”
db.Password=“12345**”
Var sql As String
sql = “SELECT dueno from agencias where cedula = " + jsonData+”;"
Var rs As RowSet
Try
db.Connect
rs = DB.SelectSQL(sql)
Var jsonCustomers As New Dictionary
For Each row As DatabaseRow In rs
Var cust As New Dictionary
cust.Value(“dueno”) = row.Column(“dueno”).StringValue
jsonCustomers.Value(row.Column("dueno").StringValue) = cust
Next
rs.Close
Var jsonResults As New JSONItem
jsonResults.Value(“GetAllCustomers”) = jsonCustomers
Return jsonResults
Catch error As DatabaseException
System.DebugLog("DB Error: " + error.Message)
Var jsonError As New JSONItem
jsonError.Value(“DBError”) = error.Message
Return jsonError
End Try