Robert
|
| Posted: 03/06/2003, 5:00 PM |
|
Using PHP4 and MySQL
*When I place this in the CC GRID FORM PROPERTIES SQL box(Where):
pcat=myword
*This is what CC creates within the .php page:
$sWhere = " WHERE pcat=myword";
*And this is the error I get:
Database error: Invalid SQL: select p.p_id as p_p_id, p.pcat as p_pcat, p.pdesc as p_pdesc, p.pn as p_pn, p.pname as p_pname, p.pprice as p_pprice, p.punit as p_punit, p.vmdl as p_vmdl, p.vyr as p_vyr from parts p WHERE pcat=myword order by p.p_id Asc
MySQL Error: 1054 (Unknown column 'myword' in 'where clause')
Session halted.
I just want the page to display records that match the "myword" in the pcat column. What should I place in the CC GRID FORM PROPERTIES SQL "Where" box to do that??
Thanks in advance!!
|
|
|
 |
Robert
|
| Posted: 03/07/2003, 1:22 PM |
|
NEVER MIND!
I got it figured out - works good 'now' :)
DIDN'T WORK:
*When I place this in the CC GRID FORM PROPERTIES SQL box(Where):
pcat=myword
DOES WORK:
pcat='myword'
And It works without Input Tab parameters!
I needed this custom SQL capability because when search engines index hyperlinks as: mypage.php?pcat=myword - They sometimes interpret the link as: mypage.php%3Fs_pcat%3Dmyword - this don't work (404)!
|
|
|
|
|
