Uh-oh ;-)
I think you put the HEX in the wrong part. Shouldn't it be in the VALUES
clause?
snprintf(query_length,query,"INSERT INTO
idsmatch(sip,sport,dip,dport,payload)
VALUES('%s',%d,'%s',%d,HEX('%s'))",
inet_ntoa(ip->saddr),dbsport,inet_ntoa(ip->daddr),dbdport,temp);
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Philippe Poelvoorde <[EMAIL PROTECTED]> wrote on 06/08/2005
09:24:04 AM:
> Hi,
>
> > snprintf(query_length,query,
> "INSERT INTO
> idsmatch(sip,sport,dip,dport,HEX(payload))VALUES('%s',%d,'%s',%d,'%s')",
> > inet_ntoa(ip->saddr),dbsport,inet_ntoa(ip->daddr),dbdport,temp);
>
> --
> Philippe Poelvoorde
> COS Trading Ltd.
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
