hi:
"session.find<User>;" query all field of table,but sometimes I want to
query only some field not all,How to implement it?I reference
session.find,I use session.query
(tutorial1.C continued)
typedef dbo::collection< dbo::ptr<User> > Users;
Users users = session.find<User>();
std::cerr << "We have " << users.size() << " users:" << std::endl;
for (Users::const_iterator i = users.begin(); i != users.end(); ++i)
std::cerr << " user " << (*i)->name
<< " with karma of " << (*i)->karma << std::endl;
here is my code :
typedef Wt::Dbo::ptr<XDBBlog> XDBBlogPtr;
typedef Wt::Dbo::collection<Wt::Dbo::ptr<XDBBlog> > XDBBlogs;
Wt::Dbo::Transaction dbTran(*mpWebApp->mpDBSession);
XDBBlogs aDBBlogs = mpWebApp->mpDBSession->query<XDBBlogPtr>("SELECT
fuid,ftitle,fdate,freader,frun FROM tblog").where("fshow=1 AND
fshare=1").limit(miPageRows).orderBy("frun DESC,fuid ASC").offset(offset_page);
for (XDBBlogs::const_iterator ii = aDBBlogs.begin(); ii != aDBBlogs.end();
++ii)
{
sUid=boost::lexical_cast<string>((*ii)->mUid);
//稿件标题
sVal="#/"+msID+"/show/"+sUid;
pAnchor=new WAnchor(sVal,WString::fromUTF8((*ii)->mTitle),pDiv);
pAnchor->setTarget(TargetNewWindow);
pAnchor ->setId("title");
}
dbTran.commit();
when run , [fatal] "Session::query(): too many aliases for result"
error occur
------------------------------------------------------------------------------
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and,
should the need arise, upgrade to a full multi-node Oracle RAC database
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
_______________________________________________
witty-interest mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/witty-interest
