SQL Syntax error

Ignition
1

[code]param1 = event.source.parent.getComponent(‘Container’).getComponent(‘Group’).getComponent(‘lblJobNumber’).text
param2 = results

system.nav.openWindow(‘Popups/Create New Wroker Order’, {‘jobNumber’ : param1})
system.nav.centerWindow(‘Popups/Create New Wroker Order’)

results = system.db.runPrepQuery(“SELECT COUNT(“work_order_number”) FROM work_order WHERE job_id LIKE ?”, [param1])[/code]

Error:

Unable to register action actionPerformed
Parse Error:
SyntaxError: (“no viable alternative at input ‘work_order_number’”, (’’, 13, 48, ‘results = system.db.runPrepQuery(“SELECT COUNT(“work_order_number”) FROM work_order WHERE job_id LIKE ?”, [param1])\n’))

2

Check your spelling. You have two lines where Worker is spelled Wroker

3 
results = system.db.runPrepQuery("SELECT COUNT("work_order_number") FROM work_order WHERE job_id LIKE ?", [param1])

Can you have quotes inside of quotes? I don’t think you can in this case… This may be your issue as well.

4

Good catch.