InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 08:07:11 GMT20http://www.sqlservercentral.com/Forums/Topic958125-150-1.aspxI have a report that accesses a MySql (5.1) database and the query runs fine, but I want to be able to use a parameter in the query. I have tried using the @ sign like that used in Sql Server and also the "?" sign as per some of the articles I have seen for MySql but neither seem to work...Here is a part of the query that I am trying to change to use a parameter:SELECT h.Host, Date(from_unixtime(clock)) as TempDate, Hour(from_unixtime(clock)) DIV 4 as IntervalY, Min(Value) as MinTemp, Max(Value) as MaxTempFROM `zabbix`.`history_uint` hu join `zabbix`.`items` i on hu.itemid = i.itemid join `zabbix`.`hosts` h on i.hostid = h.hostidwhere hu.itemid = 100100000155581I want to be able to pass in different Itemid ...Thanks in advance for any help...Fri, 23 Jul 2010 11:06:32 GMTReg_Mayfield