Hello,
I'm creating a report using HTML & ASP from an Access97 database. The fields have numerous lines of text however, when I extract the information using an SQL query, I am only able to see two lines of text.
If anyone has any suggestions or fixes, I would love to hear them.
Sample Code:
dim conntemp, rstemp
set conntemp=server.createobject("adodb.connection"
conntemp.open dbSource
'* Split the IDValue by commas, in case more than one is returned
theNum = request.querystring("IDValue"
arNum = Split(theNum,","
SQLquery = "SELECT DISTINCT " & dbStreamFieldList & " FROM " & dbTable & " WHERE " & dbIDField & " = '" & arNum(element) & "'"
set rstemp=conntemp.execute(SQLquery)
response.write "<FONT FACE='Arial,sans-serif' SIZE='-2'><B>" & rstemp(6) & "</B></FONT>"
The output looks like this:
The xx River system has been severely impacted by urbanization (loss of riparian vegetation, poor water quality and extensive impermeable surface area), and industrial activities (i.e. gravel removal, logging). xx Lake is impacted by fluctu
but it should look like this:
The xx River system has been severely impacted by urbanization (loss of riparian vegetation, poor water quality and extensive impermeable surface area), and industrial activities (i.e. gravel removal, logging). xx Lake is impacted by fluctuations in water level due to the dam (xx Lake is a reservoir for hydro and domestic water supply).
I'm creating a report using HTML & ASP from an Access97 database. The fields have numerous lines of text however, when I extract the information using an SQL query, I am only able to see two lines of text.
If anyone has any suggestions or fixes, I would love to hear them.
Sample Code:
dim conntemp, rstemp
set conntemp=server.createobject("adodb.connection"
conntemp.open dbSource
'* Split the IDValue by commas, in case more than one is returned
theNum = request.querystring("IDValue"
arNum = Split(theNum,","
SQLquery = "SELECT DISTINCT " & dbStreamFieldList & " FROM " & dbTable & " WHERE " & dbIDField & " = '" & arNum(element) & "'"
set rstemp=conntemp.execute(SQLquery)
response.write "<FONT FACE='Arial,sans-serif' SIZE='-2'><B>" & rstemp(6) & "</B></FONT>"
The output looks like this:
The xx River system has been severely impacted by urbanization (loss of riparian vegetation, poor water quality and extensive impermeable surface area), and industrial activities (i.e. gravel removal, logging). xx Lake is impacted by fluctu
but it should look like this:
The xx River system has been severely impacted by urbanization (loss of riparian vegetation, poor water quality and extensive impermeable surface area), and industrial activities (i.e. gravel removal, logging). xx Lake is impacted by fluctuations in water level due to the dam (xx Lake is a reservoir for hydro and domestic water supply).