Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
data is not making it to DB 1
- Thread starter OnAFan
- Start date
- Thread starter
- #21
- Thread starter
- #24
- Thread starter
- #26
- Thread starter
- #28
- Thread starter
- #30
If you are talking about updating the database, the error I got was due to having "date" as a field name. One of the other errors I got was the ""The method specified in the Request Line is not allowed for the resource identified by the request. Please ensure that you have the proper MIME type set up for the resource you are requesting"" I didnt fix that.
Ok Terry,
and my apologies for sending you files yesterday that I haddnt gotten fully operational.
Heres how it works.
First - you have a 97 database - I upgraded it to 2000. If you do not have access2000 no problem just in the data table we're referencing, change fields right,wrong,grade
to fldright,fldwrong,fldgrade.
Which btw adopt a uniform naming process. fields start with something like fld, tables start with something like tbl, and so on. This way you never have a problem with using reserved names.
ok, first we have login.asp individual logs in, then that takes them to the quiz, they do the quiz, hit next and it takes them to their results.
Now the results page is a javascript page. I mean total javascript. What I did was passed the results along like a regular form to results2.asp now we're entering asp mode.
everything displays - and here I carry over the individual's name who logged in. they hit send results and whammo into the database it goes.
now with the results2 page. You can also have the results emailed to someone if you'd like. it's no problem since we've entered.......................... asp.
note - I made my own connection script with the name users, a straight dsn script. if you have problems connecting just give a shout.
Stuart
and my apologies for sending you files yesterday that I haddnt gotten fully operational.
Heres how it works.
First - you have a 97 database - I upgraded it to 2000. If you do not have access2000 no problem just in the data table we're referencing, change fields right,wrong,grade
to fldright,fldwrong,fldgrade.
Which btw adopt a uniform naming process. fields start with something like fld, tables start with something like tbl, and so on. This way you never have a problem with using reserved names.
ok, first we have login.asp individual logs in, then that takes them to the quiz, they do the quiz, hit next and it takes them to their results.
Now the results page is a javascript page. I mean total javascript. What I did was passed the results along like a regular form to results2.asp now we're entering asp mode.
everything displays - and here I carry over the individual's name who logged in. they hit send results and whammo into the database it goes.
now with the results2 page. You can also have the results emailed to someone if you'd like. it's no problem since we've entered.......................... asp.
note - I made my own connection script with the name users, a straight dsn script. if you have problems connecting just give a shout.
Stuart
- Thread starter
- #33
![[wink]](/data/assets/smilies/wink.gif "[wink] [wink]")
![[bigcheeks]](/data/assets/smilies/bigcheeks.gif "[bigcheeks] [bigcheeks]")
- Status
Similar threads
- Locked
- Question
- Locked
- Question
