I need help with a fairly simple query, but I need it in VBScript and know NOTHING about VBS at all. Can someone help me with converting an ASP query to a VBScript???
This query is working now, but our new web platform want it in VBScript.
<asp:SqlDataSource runat="server" ID="SqlDataSource1" ConnectionString="Dsn=DSNDATA;uid=userid;pwd=password" ProviderName="System.Data.Odbc" SelectCommand="SELECT MFITEM.ITITEM, MFITEM.ITPKR, MFITEM.ITDESC, MFITEM.ITPACK, MFITEM.ITSIZE, IVITEM.IVQOHC, IVITEM.IVQOHU, MFITEM.ITBKCS
FROM A10358DC.DTSDATA.IVITEM IVITEM, A10358DC.DTSDATA.MFITEM MFITEM
WHERE MFITEM.ITITEM = IVITEM.IVITM# AND ((MFITEM.ITPRBK='Y') AND (MFITEM.ITACTV='Y') AND (IVITEM.IVQOHC>0) OR (MFITEM.ITPRBK='Y') AND (MFITEM.ITACTV='Y') AND (IVITEM.IVQOHU>0))
ORDER BY MFITEM.ITDESC">
Before anybody freaks out, I have changed everything that is important or could pose a security risk.