Link to home
Start Free TrialLog in
Avatar of Aleks
AleksFlag for United States of America

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
%>

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of Big Monty
Big Monty
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Aleks

ASKER

I believe it is:  c.Blobdata

It still won't show the data on the ASP  :$
Avatar of Aleks

ASKER

The field should be at the end and it is, looking into other issues that may cause this problem.