Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.
<% Dim connectstr, mSQL1, rs1 set connectstr = server.createobject("ADODB.Connection") connectstr.open = "Provider=SQLNCLI10;Server=SERVER\EXACTSQLEXPRESS;Database=ppp;Uid=portal; Pwd=password;" 'mSQL1 = "SELECT Job, Customer FROM Job" mSQL1 = "SELECT Job.Job, Job.Customer, Job.Part_Number, Job.Description, Job.Rev, Job.Status, Job.Customer_PO, Job.Customer_PO_LN, Delivery.Promised_Quantity, Job.Order_Unit, Delivery.Promised_Date, Delivery.Comment, Job.Terms FROM Job INNER JOIN Delivery ON Job.Job = Delivery.Job" Set rs1 = connectstr.Execute(mSQL1) 'Do until rs1.EOF %> <tr> <td width="200"><%Response.Write rs1("job")%></td> <td><%Response.Write rs1("customer")%></td> </tr> <%'rs1.MoveNext()
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.