[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