Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by WorkrAnt

  1. WorkrAnt

    Pull a Vbscript object into a Javascript function??

    I used a global Javascript variable. And it worked. Thank you. <script Language="JavaScript"> <!-- var QT = <%= rsprod("QOH") %>; function FrontPage_Form1_Validator(theForm) { if (parseFloat(theForm.Qty.value) > QT) { alert("Please enter an amount less than the amount in stock.")...
  2. WorkrAnt

    Pull a Vbscript object into a Javascript function??

    I will try a global and see what happens. Im kinda new at this. Thanks!
  3. WorkrAnt

    Pull a Vbscript object into a Javascript function??

    I am trying to pull the "Quantity on Hand" value in Vbscript into my Javascript function. I have tried everything and its not working. Please help... Thanks! Code: <%@ LANGUAGE = "VBScript" %> <!-- #include file="db.inc" --> <!-- #include file="config.inc" --> if stage="" or stage=null then...
  4. WorkrAnt

    Maximize Values in a Row

    From what you described, it sounds like you are trying to make the query table behave like an Excel spreadsheet. This is not possible through a query alone. When someone wants calculated fields you could possibly run another query with the max of the fiels as "new fields" and use these values...
  5. WorkrAnt

    Show me how to throw a ADODB.recordset field into a variable

    Thank you very much!!!! Since I was trying to get the max value of a field, I had to change a few things, but it worked. strSQL3 = "SELECT max(S_CUSTNO) as newnum FROM CUSTOMER" rcd0.Open strSQL3, cn2, adOpenStatic, adLockReadOnly, adCmdText cn.Execute strSQL3 g =...
  6. WorkrAnt

    Show me how to throw a ADODB.recordset field into a variable

    I want to find out the value of a single field in a sql stmt and put it into a variable for later use. I dont want to add, or update the table. For instance.... Private Sub cmdCustomer_Click() 'Recordsets Dim cn As ADODB.Connection, _ rcd0 As New ADODB.Recordset, _ fldDealerNo As ADODB.Field...
See more

Part and Inventory Search

Back
Top