asp server side validation

[RabbieBurns]

Ive got a web form to enter codes, which updates a table in a database. The field it's updating is linked to another table, which has a table of all the codes, and therefore the code being entered has to exist in the table of codes.

If I enter in the form a code that doesnt exist in the other table, I get this message, which is understandable.

[Microsoft][ODBC Microsoft Access Driver] You cannot add or change a record because a related record is required in table 'codes'.

How would I go about making sure that what is entered in the form is a valid code in the code table?

Would I do another query on the update page, and then compare the data from the form to the recordset from the new query or something like that?

[CESIL]

How many codes are there?

Could you populate a dropdown with all the valid codes to avoid the problem?

[CESIL]

Or you could execute a query to return any matching records from the code table against the code from the form.

If any records are returned (it should be just 1 I guess) then the code is valid.

[ICTNUT]

I agree with cadjs, is there any reason why you cannot create adrop downlist with the codes pre populated.

This would avoid the requirement for validation completly.

If you need code forthe dropdown let me know

[RabbieBurns]

hmm, thats an idea actually..

however, its basically a form for changing the set a student is in, and theres 38 set codes, but only 2-4 sets per subject.

So I thought for them to just change "4MATH 4" to "4MATH 3"
by just changing the last digit, it might be easier.



I will have a dabble with the dropdown, thanks for the idea

[CESIL]

you should be able to filter the codes in the dropdown by using the subject.

That way they will only see valid codes for the subject involved.

[RabbieBurns]

I agree with cadjs, is there any reason why you cannot create adrop downlist with the codes pre populated.

This would avoid the requirement for validation completly.

If you need code forthe dropdown let me know

Ive changed them to dropdowns, however my code only seems to populate the first entry with all of the available codes, then not the rest.

Ive obvioulsy messed up a loop somewhere..

Can you spot my mistake?

edugeek private pastebin - collaborative debugging tool

[RabbieBurns]

you should be able to filter the codes in the dropdown by using the subject.

That way they will only see valid codes for the subject involved.

Sounds ideal.. could you show or point me in the direction to learn about filtering please, its not something I know about yet.

[CESIL]

you need to reset the record pointer to the first record in your recordset once the first loop is done

[CESIL]

to filter the codes you could either do a query per subject or use the subject to determine each subject as you loop through the recordset. As long as the codes are sorted by subject you would know that all the maths ones are together etc.

[RabbieBurns]

Sorted, thanks.

Now, to be able to filter the sets per subject would be the icing on the cake

edit:

to filter the codes you could either do a query per subject or use the subject to determine each subject as you loop through the recordset. As long as the codes are sorted by subject you would know that all the maths ones are together etc.

I cant think in my head how that would work, the codes are sorted alphabetically, as are the subjects, but different subjects have different amounts of codes etc

[CESIL]

BTW I think your counter 'bug' is caused by staring the counter at 1 rather than 0...

[RabbieBurns]

BTW I think your counter 'bug' is caused by staring the counter at 1 rather than 0...

If i start it at 0 I get this:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'reportID ='.

/S4/updatesets.asp, line 36

which corresponds to the conn.execute line here:

http://edugeek.pastebin.com/m38b8a3b4

[RabbieBurns]

Actually, thinking about it, I am just going to leave the dropdown as it is.

Often here students change their subjects from say maths to Art instead for example. This way itll let me change the whole subject by just changing the set.

[CESIL]

there is a counter in the update page that starts at 1...this should probably start at 0 as well...