Lectora values to a Access database
June 1, 2006 12:00 AM
Ok...I just found this post and will attempt to work through this with you since I am one who has posted quite a bit about databases.....This is what I would do to try to debug it.....Let's see if the problem is in the asp file, the database, or how lectora is passing information to the asp file. What I would do is rem out the lines with request.form in them and place some values into the variables within your asp file. So, it would look like this...'testname=Request.form("TestName") testname="myfirsttest"'score=Request.form("TestName_Score") score="85"'name=Request.form("userName")name="Jeff"Do that for the rest of the request.forms, run the asp file directly in your browser then go look to see if the data is in the Access database. If it is, then the problem is how the data is being passed to the asp file (the asp file itself and Access db would then be ok), if it isn't then the problem is in your asp file or your database itself. This narrows down our hunt.Now with that said, there are a couple of places you might want to quickly look. Make sure that the fields you are claiming in your SQL statement are in fact the column names in your database. I know that sounds dumb but I made that very error last week.....ok it is dumb...but check it anyway.Secondly, I don't like to use the variable "name" as an asp variable. I think that may cause trouble. Change it to something like userName. I like to use the same names for my Lectora variables, asp variables, and field names because it makes it much easier to track things.Let me know how these fixes go and get back here to post the results. I will watch this board closely the next week or so. Or feel free to email me directly at my email address in my profile.Edited By: tekprof on 2006-6-2 9:50:34
Discussions have been disabled for this post