List:General Discussion« Previous MessageNext Message »
From:SGreen Date:June 8 2005 2:10pm
Subject:Re: Storing in HEX format.
View as plain text  
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 <philippe@stripped> 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/mysql?unsub=1
Thread
Storing in HEX format.preeth k8 Jun
  • Re: Storing in HEX format.Philippe Poelvoorde8 Jun
    • Re: Storing in HEX format.SGreen8 Jun
      • Re: Storing in HEX format.Philippe Poelvoorde8 Jun