thierry
|
| Posted: 07/18/2002, 12:26 AM |
|
I want to validate form before displaying it on internet how can I do?
for example if someone cmplete a form I want to verify the data , I don't want the form to be on the web as soos as it was validate by the visitor. help please
|
|
|
 |
Nicole
|
| Posted: 07/18/2002, 7:18 AM |
|
Thierry,
You should let user to insert new record to the table, then catch the newly inserted primary key, add it to redirect user link or save it to session and redirect user to the form with the same record opened in edit mode. There user will be able to review the data and update (confirm) or delete (approve) the record. So the problem is to catch primary key. Please refer to the following article to find how to do it. The approach is the same both for CC and CCS.
http://www.gotocode.com/art.asp?art_id=80&
Then I advice you to store it in session variable. For the record form you redirect user make sure that Table parameter source type is set to Session and not to URL.
|
|
|
|
thierry
|
| Posted: 07/19/2002, 12:37 AM |
|
Nicole,
Before everything Thankd for your great job o this forum
In my website Im the administrator so what I want is to create a form
whixh allows me to be able to update data entered by visitor for example
if a visitor publish an event I want ,before being on the net, to be able to update it if something is wrong, and how can I create a session in CCS to resolve this problem, Thanks again for your great job evenrybody agrees.
|
|
|
|
Tomasz
|
| Posted: 11/12/2002, 1:04 AM |
|
this is not a good idea.
user can close window without clicking confirmation/ delete button, and it that case record will stay in db!!!!
|
|
|
|
RonB
|
| Posted: 11/12/2002, 2:43 AM |
|
If I understand correctly you want to make sure that the data is aproved by you before it shows on the web:
add a field aproved to the table and set the default value to 2(meaning no)
on the page in the where clause include: where aproved=1 (meaning yes)_. only aproved entries will show.
on your admin page make a grid showing al none aproved entries and a link to a record grid where you can set aproved to 1(yes).
this way no coding is required and everything is handled by the databse thus saving recources (slq is almost always faster then any coding you could do)
|
|
|
|
|
