This is causing a big work stoppage for me.  If I cannot find the solution, 
I will have to redesign my database tables.  Currently I have:
 
json_dir:

   - build 
   - program 
   - directory

block_info:

   - block_name 
   - filename 
   - json_dir_id

And given a build and program (or multiple build-program pairs), I need to 
display all the block_info as well as the corresponding build and program.  
I'm new to web stuff and database design, but I thought that this design 
was better to reduce the repetitiveness of the build, program & directory 
data.  At this point, since no one has really answered my question it looks 
like I either have to
 
1) ditch the json_dir table and make block_info have:

   - block_name 
   - filename 
   - build 
   - program 
   - directory

even though that means that multiple rows in the block_info table will have 
the exact same build, program, and directory.  But this way I can do the 
SQL grid on a query of just one table so that the checkbox values will be 
unique, since they will certainly come from the block_info table id.
 
or
 
2) Ditch the SQL grid and build my own display with checkboxes.  Hmph, 
isn't that grid supposed to be there for convenience so that we don't have 
to construct our own?
 

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Reply via email to