stored proc help

[ryan]

ok so I'm trying to move some procs to MySQL and this is what I did:

CREATE PROCEDURE Products.TrafficTrack (IN SiteID INT,IN AffiliateID INT,IN IPAddress VARCHAR(15)) ..... INSERT INTO TrafficTrack(SiteID,AffiliateID,IPAddress,DateTime) VALUES (@SiteID,@AffiliateID,@IPAddress,now());

now I'm trying execute it like this

call TrafficTrack(@1,@1,@"192.168.101.187");

and its inserting null for each param.

please help!

thanks