Posted on 2004-11-29
I am trying to make a simple search form and results page.
The problem I have is getting the results page recordset working.
I have the following query that I want to use as a recordset.
SELECT employee.Name,employee.HireDate, DATE_ADD(DATE_ADD(HireDate, INTERVAL yearTable.yearNumber YEAR), INTERVAL ExtendedLeaveDays DAY) AS annDate, yearTable.yearNumber
FROM employee, yearTable
WHERE employee.Name Like 'Name'
I don't know how to set the variable dreamweaver mx for Name.
From what I have read it says to add the variable in the add recordset dialog box by clicking the + and giving it a name and default value of % and runtime value of echo $HTTP_GET_VARS['Name']; but when I do this and click test it errors out.
When I say ok it deletes the recordset.