Hannu Krosing <hannu@trust.ee> writes:
Auteur: <input width="30" name="auteur" value=""><br>
why no type=text ?
Oops forgot it. Well it worked without it :-)
This is definitely wrong ;(
something like INSERT INTO messages (auteur,title,bookdate,any_good) VALUES ('testing again', 'blahblahblah', 'now', 'f')
Ow you're right. But this hasn't changed anything, it still ask me for the parameters after clicking on submit :-( In the HTML form, I replaced the action with '<form action="add_message/manage_test" method="get">' where add_message is the Z SQL method. And it adds correctly the record to my Database, but displays 'This was not a query'. And, well, I don't think taht's the correct method to add records, by using the test method :-)) Is there anywhere an example of product adding some records to a database ?
might have worked. You may also mean current_date or current_time instead of now or now()
What's the difference between now and current_date / current_time I tried all of them, and they give exactly the same result (the good date :-) Thanks, Luc -- Luc Stepniewski <lstep@mail.dotcom.fr> http://www.planete.net/~rstep/pubkey.txt KeyID: 1024D/76A31F52 GnuPG: 819D 1F8E 7BE2 B80C AA2C 0473 CCED 48B6 76A3 1F52
On 14 Mar 1999 lstep@mail.dotcom.fr wrote:
In the HTML form, I replaced the action with '<form action="add_message/manage_test" method="get">'
where add_message is the Z SQL method. And it adds correctly the record to my Database, but displays 'This was not a query'. And, well, I don't think taht's the correct method to add records, by using the test method :-))
Is there anywhere an example of product adding some records to a database ?
Try something like: <form action="add_message_result" method="get"> And then create a DTMLDocument or DTMLMethod called add_message_result like this: <!--#var standard_html_header--> <!--#call "add_message(REQUEST)"--> <h2>Success!</h2> <p> Your message was added successfully! Thanks! </p> <!--#var standard_html_footer--> The success message will only be shown if the query succeeds, because it is below the #call statement. Hope this helps!
Thanks, Luc
jkh
participants (2)
-
Jeff K. Hoffman -
lstep＠mail.dotcom.fr