2. PHPRunner General questions
  3. Table View format and SQL hrlp for version 3.1
This topic is locked

Table View format and SQL hrlp for version 3.1

 		7/29/2007 4:21:08 PM
PHPRunner General questions
D
 DouglasB author

OK, it's been about a year since I toughted this stuff so I've forgotten everything Sergey once taught me! A couple of simple questions I can find answers to.
In version 3.1 I've create a table view. I want to format the List Page and the View Page diffrently. On both Pages I want a couple of fields to support HTML so I set the property to HTML. On the List Page though I want 2 of these field to be cantonated, but I can't seem to do that AND have HTML as a property. What am I missing?
D
 		DouglasB author 7/29/2007

Ok, why do these SQL statements Not work?
select `id`,

`agency_name`,

`sysnopsis`,

`bid_date`,

`contact_name`,

`contact_phone`,

`contact_email`,

`meeting_date`,

`meeting_location`,

`value_of_procurement`,

`reference_number`,

`notes`,

`User_ID`,

`Plans`,

`attachments`,

`bid_entered`,

`Archive_dte`

From `bid_main` Where ('Archive_dte' = '8/16/2007')
Or even this one:

select `id`,

`agency_name`,

`sysnopsis`,

`bid_date`,

`contact_name`,

`contact_phone`,

`contact_email`,

`meeting_date`,

`meeting_location`,

`value_of_procurement`,

`reference_number`,

`notes`,

`User_ID`,

`Plans`,

`attachments`,

`bid_entered`,

`Archive_dte`

From `bid_main` Where ('Archive_dte' < NOW())
Sergey Kornilov admin 7/29/2007

You need to use backtiks instead of single quotes to wrap field names

From `bid_main` Where (`Archive_dte` = '8/16/2007')
D
 		DouglasB author 7/29/2007

You need to use backtiks instead of single quotes to wrap field names


From `bid_main` Where (`Archive_dte` = '8/16/2007')


OH, DUH!!!!

Told you they were stupid questions!
Can you help me with my first question?
Thanks