I am running SQL Server 6.5 (clients choice) and have writtena system in ASP, using IIS 5.0. I have a table with quite a few TEXT fields on it and I can write to them fine. HOWEVER.....when I try to select them off, the text fields, the SQL select runs fine, see below, but when I try to set a variable or reference the value from select I get the error below. The other field type are ok but it does not like the text fields PLEASE HELP, this is SOOOOOOOOOOO URGENT!!!! My code etc is below: ( Could i be something to do with the vartype, i have tried CStr but it did not work!)
****** SQL STATEMENT *******
set get_pro = Server.CreateObject("ADODB.Recordset"
get_pro.ActiveConnection = kol_STRING
get_pro.Source = "SELECT * FROM dbo.profiles WHERE pro_kol_id = " & Request.Querystring("kid" & ";"
get_pro.CursorType = 0
get_pro.CursorLocation = 2
get_pro.LockType = 3
get_prpen()
get_pro_numRows = 0
******* SETTING THE VARIABLE LIKE THIS ********
dim pro_address (have tried it without this line)
pro_address = get_pro.Fields.Item("pro_address".Value
******* ERROR AS FOLLOWS ********
The page cannot be displayed
There is a problem with the page you are trying to reach and it cannot be displayed.
--------------------------------------------------------------------------------
Please try the following:
Click the Refresh button, or try again later.
Open the localhost home page, and then look for links to the information you want.
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services
--------------------------------------------------------------------------------
Technical Information (for support personnel)
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
/baxterkol/kol_2_6.asp, line 181
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)
Page:
GET /baxterkol/kol_2_6.asp
Time:
Tuesday, November 20, 2001, 4:06:26 PM
More information:
Microsoft Support
****** SQL STATEMENT *******
set get_pro = Server.CreateObject("ADODB.Recordset"
get_pro.ActiveConnection = kol_STRING
get_pro.Source = "SELECT * FROM dbo.profiles WHERE pro_kol_id = " & Request.Querystring("kid"
& ";"get_pro.CursorType = 0
get_pro.CursorLocation = 2
get_pro.LockType = 3
get_pr
pen()get_pro_numRows = 0
******* SETTING THE VARIABLE LIKE THIS ********
dim pro_address (have tried it without this line)
pro_address = get_pro.Fields.Item("pro_address"
.Value******* ERROR AS FOLLOWS ********
The page cannot be displayed
There is a problem with the page you are trying to reach and it cannot be displayed.
--------------------------------------------------------------------------------
Please try the following:
Click the Refresh button, or try again later.
Open the localhost home page, and then look for links to the information you want.
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services
--------------------------------------------------------------------------------
Technical Information (for support personnel)
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
/baxterkol/kol_2_6.asp, line 181
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)
Page:
GET /baxterkol/kol_2_6.asp
Time:
Tuesday, November 20, 2001, 4:06:26 PM
More information:
Microsoft Support