system.db.runPrepQuery

Ignition
1

Hello … I have a issue when try to run a PrepQuery using system.db.runPrepQuery

This is my scripting…
####################################################3
StartDate = ‘2018-07-13 06:00:00.000’
EndDate = ‘2018-07-13 16:00:00.000’

results = system.db.runPrepQuery(“SELECT * FROM [paint].[dbo].[paint_system_history] WHERE time_stamp >= (?) AND time_stamp < (?)”,[StartDate] [EndDate])

print results

##########################################################
But not works
what is the exactly syntax when the query has multiple placeholders (?)

I hope could help me!!!

Best Regards

2

use ``` triple back quotes to enclose your code to format it for the forum. Syntax here

try this……[StartDate,EndDate]

2 Likes
3

hii dkhayes117… works good thanks for your help and time…

regards