vbscript, Problem returning data from a scroll text box to an Access memo field

Problem returning data from a scroll text box to an Access memo field

Author	Message
Denis War #1 / 4	Problem returning data from a scroll text box to an Access memo field Hello, I have set up a form with various objects including radio buttons, check boxes, one line text boxes and scrolling text boxes. I am using some script to process the form to populate an Access database. All data comes through except for the scrolling text box data. It appears as though anything after a hard return is not recognised. If I write the variable to an ASP page, all the data is being stored OK in the variable. If I process this to the database, only the first line, up until the hard return is stored. If anyone can help, I would be most appreciative. Regards Denis Ward My code looks as follows : <SCRIPT LANGUAGE=VBScript RUNAT=Server> Dim cn 'Connection var Dim rs 'Recordset var Dim SQL Set cn = Server.CreateObject("ADODB.Connection") Set rs = Server.CreateObject("ADODB.Recordset") Session("Q1dVar") = Request.Form("Q1d") ' this is on another page. cn.Open "DNSname" SQL = "Select * From tblSurvey Where FirstName = 'xxxyzxc'" rs.Open SQL,cn,1,2 rs.AddNew rs("FirstName") = Session("FirstNameVar") rs("Q1d") = Session("Q1dVar") ' this is the variable passing the data from the scrolling text box named Q1d rs.Update rs.close Set rs = Nothing cn.close Set cn = Nothing </SCRIPT>
Mon, 17 Mar 2003 15:36:47 GMT

Jimb #2 / 4	Problem returning data from a scroll text box to an Access memo field Do you have the Q1D field set to memo in the DB? Quote: > Hello, > I have set up a form with various objects including radio buttons, check > boxes, one line text boxes and scrolling text boxes. I am using some script > to process the form to populate an Access database. > All data comes through except for the scrolling text box data. > It appears as though anything after a hard return is not recognised. If I > write the variable to an ASP page, all the data is being stored OK in the > variable. If I process this to the database, only the first line, up until > the hard return is stored. > If anyone can help, I would be most appreciative. > Regards > Denis Ward > My code looks as follows : > <SCRIPT LANGUAGE=vbscript RUNAT=Server> > Dim cn 'Connection var > Dim rs 'Recordset var > Dim SQL > Set cn = Server.CreateObject("ADODB.Connection") > Set rs = Server.CreateObject("ADODB.Recordset") > Session("Q1dVar") = Request.Form("Q1d") ' this is on another page. > cn.Open "DNSname" > SQL = "Select * From tblSurvey Where FirstName = 'xxxyzxc'" > rs.Open SQL,cn,1,2 > rs.AddNew > rs("FirstName") = Session("FirstNameVar") > rs("Q1d") = Session("Q1dVar") ' this is the variable passing the data from > the scrolling text box named Q1d > rs.Update > rs.close > Set rs = Nothing > cn.close > Set cn = Nothing > </SCRIPT>
Mon, 17 Mar 2003 03:00:00 GMT

Marvin Thompso #3 / 4	Problem returning data from a scroll text box to an Access memo field Denis, I bet all of your data is in the database. Try retrieving it and displaying it on a page. Marvin Thompson Quote: > Jimbo, > Yes the field in the DB is set to memo. > It does appear that the problem is the line feed. I used a replace statement > that I found under the solution to someone else's problem in the newsgroup > to remove to the line feed. > Session("Q1dVar") = Replace(Session("Q1dVar"),vbCrlf," - ") > Thanks for your help. > Denis > > Do you have the Q1D field set to memo in the DB? > > > Hello, > > > I have set up a form with various objects including radio buttons, check > > > boxes, one line text boxes and scrolling text boxes. I am using some > > script > > > to process the form to populate an Access database. > > > All data comes through except for the scrolling text box data. > > > It appears as though anything after a hard return is not recognised. If > I > > > write the variable to an ASP page, all the data is being stored OK in > the > > > variable. If I process this to the database, only the first line, up > until > > > the hard return is stored. > > > If anyone can help, I would be most appreciative. > > > Regards > > > Denis Ward > > > My code looks as follows : > > > <SCRIPT LANGUAGE=vbscript RUNAT=Server> > > > Dim cn 'Connection var > > > Dim rs 'Recordset var > > > Dim SQL > > > Set cn = Server.CreateObject("ADODB.Connection") > > > Set rs = Server.CreateObject("ADODB.Recordset") > > > Session("Q1dVar") = Request.Form("Q1d") ' this is on another page. > > > cn.Open "DNSname" > > > SQL = "Select * From tblSurvey Where FirstName = 'xxxyzxc'" > > > rs.Open SQL,cn,1,2 > > > rs.AddNew > > > rs("FirstName") = Session("FirstNameVar") > > > rs("Q1d") = Session("Q1dVar") ' this is the variable passing the data > > from > > > the scrolling text box named Q1d > > > rs.Update > > > rs.close > > > Set rs = Nothing > > > cn.close > > > Set cn = Nothing > > > </SCRIPT>
Mon, 17 Mar 2003 03:00:00 GMT

Denis War #4 / 4	Problem returning data from a scroll text box to an Access memo field Jimbo, Yes the field in the DB is set to memo. It does appear that the problem is the line feed. I used a replace statement that I found under the solution to someone else's problem in the newsgroup to remove to the line feed. Session("Q1dVar") = Replace(Session("Q1dVar"),vbCrlf," - ") Thanks for your help. Denis Quote: > Do you have the Q1D field set to memo in the DB? > > Hello, > > I have set up a form with various objects including radio buttons, check > > boxes, one line text boxes and scrolling text boxes. I am using some > script > > to process the form to populate an Access database. > > All data comes through except for the scrolling text box data. > > It appears as though anything after a hard return is not recognised. If I > > write the variable to an ASP page, all the data is being stored OK in the > > variable. If I process this to the database, only the first line, up until > > the hard return is stored. > > If anyone can help, I would be most appreciative. > > Regards > > Denis Ward > > My code looks as follows : > > <SCRIPT LANGUAGE=vbscript RUNAT=Server> > > Dim cn 'Connection var > > Dim rs 'Recordset var > > Dim SQL > > Set cn = Server.CreateObject("ADODB.Connection") > > Set rs = Server.CreateObject("ADODB.Recordset") > > Session("Q1dVar") = Request.Form("Q1d") ' this is on another page. > > cn.Open "DNSname" > > SQL = "Select * From tblSurvey Where FirstName = 'xxxyzxc'" > > rs.Open SQL,cn,1,2 > > rs.AddNew > > rs("FirstName") = Session("FirstNameVar") > > rs("Q1d") = Session("Q1dVar") ' this is the variable passing the data > from > > the scrolling text box named Q1d > > rs.Update > > rs.close > > Set rs = Nothing > > cn.close > > Set cn = Nothing > > </SCRIPT>
Tue, 18 Mar 2003 11:44:30 GMT

Page 1 of 1

[ 4 post ]