sql - How do I find records added to my database table in the past 24 hours? -

-

i'm using mysql in particular, i'm hoping cross-vendor solution. i'm using now() function add timestamp column each record.

insert messages  (typeid, messagetime, stationid, message)  values  (?, now(), ?, ?) 

select * messages date_sub(curdate(),interval 1 day) <= messagetime

Comments

Post a Comment

Popular posts from this blog

windows - Why does Vista not allow creation of shortcuts to "Programs" on a NonAdmin account? Not supposed to install apps from NonAdmin account? -

-
i'm working on installer (using wise installer, older version 1999). i'm creating shortcut in programs group exe. i'm creating shortcut on desktop. if install run admin account, create shortcut on common desktop , common program group (i.e., read hkey_local_machine\explorer\shellfor users). if it's installed nonadmin account, install hkey_current_user's desktop , program group. behavior install on: xp nonadmin - desktop , program shortcuts install ok. vista admin - desktop & program shortcuts install ok. vista non-admin, uac off - desktop shortcut installs, program shortcut not . however, program group folder they're supposed installed does created. at end of install, launch program group has shorcut. launches in of above. can manually drag shortcut folder , works fine. i'm bloody baffled. i've tried installing other commercial apps (opera, foxit, firefox) firefox install under nonadmin (and if select other program files,...
Read more

c++ - How do I get a multi line tooltip in MFC -

-
right now, have tool tip pops when hover on edit box. problem tool tip contains multiple error messages , in 1 long line. need have each error message on own line. error messages contained in cstring new line seperating them. my existing code below. bool ontooltiptext(uint, nmhdr* pnmhdr, lresult* presult) { assert(pnmhdr->code == ttn_needtexta || pnmhdr->code == ttn_needtextw); // need handle both ansi , unicode versions of message tooltiptexta* pttta = (tooltiptexta*)pnmhdr; tooltiptextw* ptttw = (tooltiptextw*)pnmhdr; // tchar szfulltext[256]; cstring strtiptext=_t(""); uint nid = pnmhdr->idfrom; if (pnmhdr->code == ttn_needtexta && (pttta->uflags & ttf_idishwnd) || pnmhdr->code == ttn_needtextw && (ptttw->uflags & ttf_idishwnd)) { // idfrom hwnd of tool nid = ::getdlgctrlid((hwnd)nid); } //m_errprojaccel[ch] contains 1 or more error messages each...
Read more

ssis - How do I fix the error unable to enlist Sybase database in distributed transaction? -

-
i know little (arguably nothing) sybase setup, know ssis having trouble enlisting sybase in distributed transaction. has been able make work? the ssis runtime has failed enlist ole db connection in distributed transaction error 0x80004005 "unspecified error". this happens when change package's transactionoption required. when revert default "supported", package runs without errors (albeit not thread safe). i had same problem when tried create transaction around read gupta sqlbase. basically, seems ssis (at least of 2005) isn't able enroll other providers in transaction part of package. i've tried few times without luck, , end reading data oledb temporary table, , creating transaction around import of data resting place in sql server. that's read side, though - if you're trying use transaction write sybase, you'll need on side - ssis won't able use transaction push data provider. i addition that, didn't want trans...
Read more