Advertisement
Guest User

Untitled

a guest
Oct 30th, 2014
139
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.80 KB | None | 0 0
  1. set rsDue = Server.CreateObject("ADODB.Recordset")
  2. rsDue.ActiveConnection = MM_Transmille_STRING
  3.  
  4. rsDue.Source = "SELECT Calibrations.Cert_No, Calibrations.Cust_Ref, Calibrations.Rec_Date, Instruments.Inst_ID, Instruments.Description, Instruments.Model_no, Instruments.Manufacturer, Instruments.Serial_no, Instruments.Status, Instruments.Cust_Acc_No FROM Instruments INNER JOIN Calibrations ON Instruments.Inst_ID = Calibrations.Inst_ID WHERE Instruments.Cust_Name = '" & Session("MM_Username") & "' AND Instruments.Cust_Acc_No = '" & Session("MM_Password") & "' AND Instruments.Cust_Acc_No = '" + Replace(rsDue__MMColParam, "'", "''") + "' AND Instruments.Status IN ('N') ORDER BY Calibrations.Rec_Date DESC;"
  5.  
  6.  
  7. rsDue.CursorType = 0
  8. rsDue.CursorLocation = 2
  9. rsDue.LockType = 3
  10. rsDue.Open()
  11. rsDue_numRows = 0
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement