Aleks
asked on
Set cursor to client side
Sometimes text fields data is not displayed on the ASP file unless the cursor is set to 'client side', how can I set the cursor for the recordset below to be client side instead of server side ?
<%
Dim rs_forms__MMColParam
rs_forms__MMColParam = "0"
If (Session("firmid") <> "") Then
rs_forms__MMColParam = Session("firmid")
End If
%>
<%
Dim rs_forms__MMColParam2
rs_forms__MMColParam2 = "0"
If (Request.Querystring("caseid") <> "") Then
rs_forms__MMColParam2 = Request.Querystring("caseid")
End If
%>
<%
Dim rs_forms
Dim rs_forms_cmd
Dim rs_forms_numRows
Set rs_forms_cmd = Server.CreateObject ("ADODB.Command")
rs_forms_cmd.ActiveConnection = MM_bluedot_STRING
rs_forms_cmd.CommandText = "SELECT a.id , a.caseid , a.mainuserid , a.petitionerid , a.fname , a.fdescription , a.complete , a.qid , c.Blobid , d.FirstNm , d.MiddleNm , d.LastNm , CASE WHEN p.usertype = 'employer' THEN p.MaidenNm ELSE p.FirstNm + ' ' + p.MiddleNm + ' ' + p.LastNm END AS pet_name , c.Blobdata FROM dbo.Formscase a LEFT JOIN Forms b ON a.fname = b.FormName LEFT JOIN FormsBlb AS c ON c.Activityid = a.id INNER JOIN Users AS d ON d.UserId = a.mainuserid LEFT JOIN Users AS p ON p.UserId = a.petitionerid WHERE a.firmid = ? AND a.caseid = ? AND b.Qid IS NOT NULL AND b.IsObsolete = 0 ORDER BY fname ASC"
rs_forms_cmd.Prepared = true
rs_forms_cmd.Parameters.Append rs_forms_cmd.CreateParameter("param1", 5, 1, -1, rs_forms__MMColParam) ' adDouble
rs_forms_cmd.Parameters.Append rs_forms_cmd.CreateParameter("param2", 5, 1, -1, rs_forms__MMColParam2) ' adDouble
Set rs_forms = rs_forms_cmd.Execute
rs_forms_numRows = 0
%>
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
The field should be at the end and it is, looking into other issues that may cause this problem.
ASKER
It still won't show the data on the ASP :$