Adapting Search to Customized Page
I would appreciate your assistance in figuring out why my page resulting in errors when I try to adapt an all ready customized list page (not using DA) with DataAssist's Search feature.
I did the following steps:
1. Created a form with a 'Search' textbox and a button called 'go'.
2. Accessed DataAssist Search
a. Trigger: button 'go' pressed
b. Recordset 'getEmployee', 'MySQL'
c. Default WHERE clause: "WHERE 0=0"
d. Server Behavior Configuration (I only created one for testing): Key, firstname, T=<?php echo $row_getEmployee['firstname']; ?>
3. RESULT when page first loads:
a. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE 0=0' at line 1
How can I modify your DA code to where I don't need the WHERE clause (or do I?) if I have my own query displaying the results as I want them?
Also, I all ready have SESSIONS coded, how can I adapt DA's to where I don't need it?
4. How can I use your product with my web page? I've attached my web page code for your review, which includes the DA code as well.
Thank you in advance!