cyrus
|
| Posted: 12/09/2005, 6:54 PM |
|
Hello Gurus,
My problem is this:
I have an option box that will display all the project names from table "Tooling". I have three projects there but when i run the program it only display "one record" or "one project". It also won't display the "-- All Projects --" value of the option box but when i empty the entire table this value will show up! I got stuck with this error and i can't continue. What's wrong with the code?Please help! Any comment(s)/help would be appreciated. Thank You.
Here is the code:
<select name="project_name"><!--BeginLBproject_name--><option value="{ID}" {Selected}>{Value}</option><!--EndLBproject_name--></select>
fldproject_name = GetParam("project_name")SetVar "LBproject_name", ""
SetVar "ID", ""
SetVar "Value", "-- All Projects --"
Parse "LBproject_name", True
openrs rsproject_name, "select tool_id, project_name from tooling"
while not rsproject_name.EOF
SetVar "ID", GetValue(rsproject_name, 1) : SetVar "Value", GetValue(rsproject_name, 1)
if cstr(GetValue(rsproject_name, 1)) = cstr(fldproject_name) then SetVar "Selected", "SELECTED" else SetVar "Selected", ""
Parse "LBproject_name", True
rsproject_name.MoveNext
wend
set rsproject_name = nothing
|
|
|
 |
|
