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!

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

Search results for query: *

  • Users: Joelo
  • Order by date
  1. Joelo

    SQL and Join and delete

    Hey Tarwn, PLease Could show me an example of what the select query (cascade DELETE and UPDATE)looks like as I trying to do same Thanks
  2. Joelo

    Select Count query

    Thanks..it worked like a charm Please I am trying to count zoo like 1 and zoo like 2 and zoo like and display the results all in page... please any idea strsql = "SELECT COUNT(ZOO) AS prev FROM TJAB INNER JOIN TCAB AS B ON XCOW=B.BCUB" strsql = strsql & " WHERE [JOB] = "&bad&" AND [BEEV] >=...
  3. Joelo

    Select Count query

    I Tried strsql = "SELECT COUNT(ZOO) AS prev FROM TJAB INNER JOIN TCAB AS B ON XCOW=B.BCUB" strsql = strsql & " WHERE [JOB] = "&bad&" AND [BEEV] >= "&bad1&" AND [CEEV] <= "&bad2&" AND [ZOO] like 1 ORDER BY [ZOO] DESC" and got the following error Microsoft OLE DB Provider for SQL Server error...
  4. Joelo

    Select Count query

    Please could someone tell what I am doing wrong strsql = "SELECT ZOO, COUNT(ZOO) AS prev FROM TJAB INNER JOIN TCAB AS B ON XCOW=B.BCUB" strsql = strsql & " WHERE [JOB] = "&bad&" AND [BEEV] >= "&bad1&" AND [CEEV] <= "&bad2&" AND [ZOO] like 1 ORDER BY [ZOO] DESC" Thanks in advance
  5. Joelo

    Two Submit Buttons on a form

    please could somebody tell me what I am doing wrong...I can't seem to get it setaction(this.value) function to work with the same onClick event as return checkrequired(this) function <SCRIPT LANGUAGE="JavaScript"> <!-- Begin function checkrequired(which) { var pass=true; if (document.images) {...
  6. Joelo

    Two Submit Buttons on a form

    please could somebody tell me what I am doing wrong...I can't seem to get it setaction(this.value) function to work with the same onClick event as return checkrequired(this) function <SCRIPT LANGUAGE="JavaScript"> <!-- Begin function checkrequired(which) { var pass=true; if (document.images) {...
  7. Joelo

    Two Submit Buttons on a form

    I am sorry about that I want to call "return checkrequired(this)" function to validate info on the b/4 the form is submitted only when submit button is clicked on
  8. Joelo

    Two Submit Buttons on a form

    Please How do I call "return checkrequired(this)" function to validate info on the b/4 the form is submitted? thanks
  9. Joelo

    Two Submit Buttons on a form

    Please I have a form with two submit buttons. Each to cause the user to do different thing (Save Form and Submit Form) On clicking the SAVE Form Button...Information entered by the user is saved for editing later and On clicking the SAVE Form Button...Information entered by the user is...
  10. Joelo

    Auto Tabbing

    That's were I am Lost..........I need the Function min_maxCheck() to trigger function loadTI() to run .... Auto tabbing the cursor to the next textbox
  11. Joelo

    Auto Tabbing

    Please I am trying to get the validation function to auto tab to next textbox after min_maxCheck() function. please could somebody help me out <script language=javascript> function trigger(){ var a=document.getElementsByName('PRE_LEFTPRESSURE_<%=Ext_Record_Count%>')[0].value; if...
  12. Joelo

    Selecting Tab Dynamically

    Please how can I make the following script to Dynamically select any of below tabs that is available dim startTab tabsDef(1,1)="Men" tabsDef(1,2)="" tabsDef(2,1)="Women" tabsDef(2,2)="" tabsDef(3,1)="Children" tabsDef(3,2)="" tabsDef(4,1)="Adults" tabsDef(4,2)="" startTab=1 'the startTab...
  13. Joelo

    convert Html to asp

    Please anybody help me out in converting the following Html code to asp <td class="cssfont" width="215"><% x_MONTHYEAR = MonthName(Month(Now)) &- Year(Now) 'set default value %><input type="text" readonly name="x_MONTHYEAR" value="<%= x_MONTHYEAR %>" size=30...
  14. Joelo

    Converting Julian Date value to Date

    I 've tried the following: CalD= DateSerial(1900+INT(JuianD/1000),1,JulianD mod 1000) Got the same Error Message: Microsoft VBScript runtime error '800a000d' Type mismatch
  15. Joelo

    Converting Julian Date value to Date

    I tried the following: caldate = DateSerial(1900+INT(jdate/1000),1,jdate mod 1000) and got and error message: Microsoft VBScript runtime error '800a000d' Type mismatch please could anyone help me out
  16. Joelo

    Tabbed Frame

    Please is it possible to have these 5 tabbed frames display list of info related to the main asp page?
  17. Joelo

    Tabbed Frame

    How can I do Like wise in my ASP page......Is it possible?
  18. Joelo

    Tabbed Frame

    I would like to create my ASP page with 5 tabbed frames.... Just like the one in this forum Please could anybody help me out on how to do it. Thanks for your help in advance.
  19. Joelo

    Editable Grid in ASP

    Please I am Trying to create an Editable Grid in ASP...How can I do, if it possible in asp? Please How me out
  20. Joelo

    Converting Julian Date value to Date

    converting Julian date values to calendar date values. (e.g. Julian date 2451964 = 02/24/2001.)

Part and Inventory Search

Back
Top