search

optikalefx / OpenJS-Grid

OpenJS Grid is the easiest jQuery Grid ever. With very little work you can have a data grid that can do everything from sorting and searching to complex database queries. Best of all, its open source. So you can learn how it's all done.
http://square-bracket.com/openjs
MIT License
96 stars 46 forks source link

sql where statement #22

Closed tokick4 closed 11 years ago

tokick4 commented 11 years ago

Sean, Sorry to bomb bard you with so many questions. Can the where statement take two values like this: "where"=>"inspection_date = 'CURDATE()'" && "assigned = '0'", I am wanting to filter it down.

Also is there any way to set the widths of the columns?

By the way thanks for all the help Jon

tokick4 commented 11 years ago

I figured out the sql statement that I needed, "where"=>"inspection_date = CURDATE()&&assigned = '0'" ,

I just need to fix the widths of the table so that they don't cut off the description of data within them.

optikalefx commented 11 years ago

Yep its just a string for the entire where clause.

Just add to do widths