- From the SessionBean in the outline, double click and open the SQL
Query editor.
- Do the join and save. (Drag and dro the table from database node on to
the table design pane)
- Go back to the Page designer. Right click on the table to
- Bring the table layout and add the columns to the table you want.
Read this for more details
http://www.netbeans.org/kb/55/vwp-inserts_updates_deletes.html
- Winston
> From a "Visual Web Pack" perspective, how do I bind a table component to the
> result of a join operation?
>
> It's pretty slick how I can just drop a DB table onto the webui table and it
> binds but suppose I want to also join the DB table with another one?
>
> I modified the session bean call
>
> mlb_teamsRowSet.setCommand("...")"
>
> to have the proper join SQL but it just craps out when it hits the join part of
> the query
>
> later,
> Sean
> http://seanc.us
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: dev-unsubscribe_at_woodstock.dev.java.net
> For additional commands, e-mail: dev-help_at_woodstock.dev.java.net
>
>