[thelist] Comments won't write to database...
Ken Kogler
ken.kogler at cph.org
Mon Jul 15 14:10:25 CDT 2002
Here you've got a form field named "Comments"...
> <input type=text name="Comments">
And here (on the next page) you're asking for the value of a form field
names "fcomments"...
> sql = "Insert into Timelog (" &_
> "Initials, First, Last, Comments, IPaddy, Signin) " &_
> "values (" &_
> "'" & DupQ(request.querystring ("fint")) & "', " &_
> "'" & DupQ(request.querystring ("ffirst")) & "', " &_
> "'" & DupQ(request.querystring ("flast")) & "', " &_
> "'" & DupQ(request.querystring ("fcomments")) & "', " &_
> "'" & DupQ(request.querystring ("fip")) & "', " &_
> "1)"
Since "fcomments" doesn't exist, you get an empty cell in the DB... change
"DupQ(request.querystring ("fcomments"))" to "DupQ(request.querystring
("Comments"))" and see what happens.
HTH!
--ken
More information about the thelist
mailing list