I'm trying to create several screens to allow my technician to keep a log of problem reports. I chose to create a search form. The data will display in the usual table form and the user will select the item wanted for display in an update form with the values shown as default field values. In the table view, I created a link to my next form in the following way: <a href="http://localhost:8080/School/Admin/Computer/displayitem?id=<dtml-var id>&Submit=Submit&Query"> The problem is that no data gets stuffed into the values="" attributes of the form which leads me to believe that either I'm not using the <dtml-sqlvar> tags correctly or I'm not calling the data selected from the database (mysql) for use in the new form correctly. I read the how-to on inserting sql data, but I want to create a form that will update existing records. Any help will be appreciated, Joe
Joe Hewitt wrote:
I'm trying to create several screens to allow my technician to keep a log of problem reports.
I chose to create a search form. The data will display in the usual table form and the user will select the item wanted for display in an update form with the values shown as default field values.
In the table view, I created a link to my next form in the following way:
<a href="http://localhost:8080/School/Admin/Computer/displayitem?id=<dtml-var id>&Submit=Submit&Query">
The problem is that no data gets stuffed into the values="" attributes of the form which leads me to believe that either I'm not using the <dtml-sqlvar> tags correctly or I'm not calling the data selected from the database (mysql) for use in the new form correctly.
It looks like you are trying to use an anchor tag to submit a form. This will not work as it is not proper HTML. You need to use an <input type=submit...> or some other valid way of submiting the form. -Michel
Michel, I'm trying to use a link on the Report Form to call another form that displays the single database record with each field filling in the new form. If the user is the proper authenticated user, an update button will be available, anonymous will only get a listing of the record. Granted, I'm not doing it the right way. Perhaps my question is how do you select a value, in this case the record number, and use that value as a key to pass the entire record to the form for display. My calling DTML Method is listed below. So the question is how can I call up my new form with my selection appearing as data. Thanks, Joe On Mon, 20 Mar 2000, Michel Pelletier wrote:
It looks like you are trying to use an anchor tag to submit a form. This will not work as it is not proper HTML. You need to use an <input type=submit...> or some other valid way of submiting the form.
-Michel
participants (2)
-
Joe Hewitt -
Michel Pelletier