Welcome Guest Search | Active Topics | Members | Log In | Register

Displaying Queries in Flex Options · View
nkanibal
Posted: Tuesday, March 23, 2010 5:10:35 PM
Rank: Newbie Coder
Groups: Member

Joined: 3/23/2010
Posts: 2
Points: 6
Location: Santiago
Hi, I'm starting with Flex and Weborb for mySql. I have a database with multiple tables and I need to display a datagrid with data from multiple tables (innerjoin). I've generate a "view" in mySql and then import it to Weborb as a table. The problem is that Weborb says that the table (view) does not have a primary key and does not generate the code.

Help Please!, how can I do a query from 2 tables and display it in my app?.

Thanks
xleon
Posted: Wednesday, April 21, 2010 5:33:29 PM

Rank: Apprentice Coder
Groups: Member

Joined: 4/20/2010
Posts: 25
Points: 75
Location: spain
Hi, I created a view with this query, and I can see that in console data management > Databases like if it was another table:

SELECT
documents.*, documentCategories.name AS categoryName

FROM
documentcategories, documents

WHERE
documentcategories.idCategory=documents.category

===================
Twitter: diegoxleon
Users browsing this topic
Guest


Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Main Forum RSS : RSS

YAFVision Theme Created by Jaben Cargman (Tiny Gecko)
Powered by Yet Another Forum.net version 1.9.1.8 (NET v4.0) - 3/29/2008
Copyright © 2003-2008 Yet Another Forum.net. All rights reserved.
This page was generated in 0.093 seconds.