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 Rhinorhino 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: techzone12
  • Content: Threads
  • Order by date
  1. techzone12

    how to perform an agregate on two non uniform tables

    I have a table called "Daily" (Daily data) that looks like this: DateStamp KWH 11/6/2005 1867 11/7/2005 2001 11/8/2005 2023 . . A second table called "15_min" (15 minute data) looks like this: [DateTime] KW 11/8/2005 00:00 am 201 11/8/2005 00:15 am 198 ...
  2. techzone12

    How to update Table in dB with new data

    I have this code that displays the results of a select query: <%@ LANGUAGE="VBSCRIPT" %> <% Option Explicit%> <HTML> <body> <% ' Open Database connection '*********************************************** DIM objConn, dbname, data_source Set objConn = Server.CreateObject("ADODB.Connection")...
  3. techzone12

    How to pass DateTime variable to stored procedure

    I have some ASP code that looks like this: objRs.Open "Execute Proc1 " & strTableName & ", " & strColumn , objConn The Stored procedure "Proc1" looks like this: CREATE PROCEDURE [Proc1] @strTable varchar(50), @strColumn varchar(50) AS Exec('SELECT ' + @strColumn + ' FROM ' + @strtable + '...
  4. techzone12

    How to pass DateTime to stored procedure from ASP

    How can I pass DateTime Paramter to stored procedure from within an ASP page? Can you give me an example - or maybe point me to a link where this is explained? Thanks
  5. techzone12

    How to pass Multiple aparamters, including datetime to sp

    I have an ASP page with this code: strTable = "table1" oRsSubs.Open "Execute sp_Proc " & strTable, conn The stored procedure in SQL looks like this: CREATE PROCEDURE sp_Proc ( @strTable varchar(50) ) AS EXEC('SELECT * FROM ' + @strTable) This work fine. I am trying however to add some...
  6. techzone12

    how to pass paramters form ASP to SQL Stored Procedures

    I have an ASP page that contains a database table name as a string variable, i.e "strTableName". I need to pass this string form the ASP page to a SQL stored procedure. The sp will execute something like: select * from @strTableName The results will be retured to the ASP in a record Set. How...
  7. techzone12

    SQL conditional query with DateTime

    I have a SQL View called "KWH_Daily", and it’s driven by a 15 minutes table called "KW_15min" The 15-min table has data in 15-min intervals, i.e.: [DateTime] KW 9/13/2005 11:00 am 300 9/13/2005 11:15 am 304 9/13/2005 11:30 am 298 The Daily View (KWH_Daily) is constructed by using the...
  8. techzone12

    mutliple forms in the same ASP page

    I have an ASP page called "sample.asp" that has two forms. The first form (form1) has a dropdown list box and a submit button. When selecttion is made and the submit is clicked ,tha user selection is passed to the same page (sample.asp). I am using: <form name="form1" method="post"...
  9. techzone12

    Cascaded dropdown lists in the same ASP page

    I want to have multiple frames within a single ASP/HTML page. The idea is that one frame will have a drop down menu and a submit button. When the submit button is clicked, the second frame should display. The second frame will have the dynamic content based on the selection that was made in the...
  10. techzone12

    Multiple cascaded drop down lists

    I want to have multiple frames within a single ASP/HTML page. The idea is that one frame will have a drop down menu and a submit button. When the submit button is clicked, the second frame should display. The second frame will have the dynamic content based on the selection that was made in the...
  11. techzone12

    SQL calculated value Overflow prevention

    I have T-SQL query,in which I do a calculation as follows: SELECT CONVERT(int, Volts * Amps * 0.001732 * PF / 100) AS KW FROM Elec_Table I want the query to check if the number calculated (KW) is higher that say 1000, then to produce a null or zero. How do I do this? Thanks

Part and Inventory Search

Back
Top