Ok if found the answer to my question.
Thanks
Brad Messerle
--- Brad Messerle <bradleyfmesserl..ahoo.com> wrote:
> Ok i have finally got the framwork up and running. I
> am just reusing example code.
>
> I can get the query to work, but the result set
> seems
> to return the wrong object.
>
> here is the code
>
>
Configuration.bootstrapSharedConfiguration(this.getClass());
> ctxt =
>
Configuration.getSharedConfiguration().getDomain().createDataContext();
>
> String sql = "SELECT xxx.USERPROFILE.LOGINID AS
> LOGINID, xxx.USERPROFILE.PASSWORD AS PASSWORD,
> xxx.USERPROFILE.FIRSTNAME AS FIRSTNAME,
> xxx.USERPROFILE.LASTNAME AS LASTNAME FROM
> TPF.USERPROFILE WHERE xxx.USERPROFILE.LOGINID = '"
> +
> this.getCurrectUser().getUserid().trim()+"'";
>
>
> SqlSelectQuery query = new
> SqlSelectQuery(_Userprofile.class,sql);
> //SelectQuery query = new
> SelectQuery(_Userprofile.class, qual);
> // using log level of WARN to make sure that query
> // execution is logged to STDOUT
> query.setLoggingLevel(Level.WARN);
>
> List userprofiles =
> ctxt.performQuery(query);
>
> if (userprofiles.size() == 1) {
> _Userprofile userprofile = (_Userprofile)
> userprofiles.get(0);
> System.out.println("\nFound User '" +
> userprofile.getFirstname() + "'.\n");
> // return gallery;
> }
> else if (userprofiles.size() == 0) {
> System.out.println("No matching galleries
> found.");
> }
> else {
> System.out.println("Found more than one
> matching
> gallery. Be more specific.");
> }
> }
>
>
> I hope u can make it out.
>
> But when i get the first element in the list object
> a
> hash table is returned so when i cast into my data
> object i get a cast exception.
>
> Any ideas?
>
> Thanks
> Brad Messerle
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! SiteBuilder - Free, easy-to-use web site
> design software
> http://sitebuilder.yahoo.com
__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
This archive was generated by hypermail 2.0.0 : Wed Aug 27 2003 - 14:30:12 EDT