[Help]Converting DWORD To SQL Bigint

[robobot]

hey,
how can i convert c++ DWORD to sql server bigint? or how else can i save DWORD in sql server?

[Tyrar]

std::stringstream ss;
DWORD dwValue=1337;

ss << "INSERT INTO dwordtable VALUES (" << dwValue << ");";

mysql_query(p_mysql,ss.str().c_str());

[EXTEЯNAL]

DWORD dwMyVal = 0x12345678;
char szSqlQuery[128];
sprintf_s(szSqlQuery, 128, "INSERT INTO dwordtable VALUES (%i);", dwMyVal);
mysql_query(handle, szSqlQuery);

[MoepMeep]

[robobot]

thanks very much for your answers

Originally Posted by Momo5000

DWORD dwMyVal = 0x12345678;
char szSqlQuery[128];
sprintf_s(szSqlQuery, 128, "INSERT INTO dwordtable VALUES (%i);", dwMyVal);
mysql_query(handle, szSqlQuery);

so this does work even if the dwMyVal DWORD is a hex value as example 0xF7DC21A9?

[MoepMeep]

Originally Posted by robobot

thanks very much for your answers



so this does work even if the dwMyVal DWORD is a hex value as example 0xF7DC21A9?

Did you even read my post?

0xF7DC21A9 = 4158398889

Why shouldn't it work? ;o