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!

Search results for query: *

  1. Shemzar

    Know any good Calendar/Scheduler Type Control

    Does anyone know where I would get a very good Calendar/Scheduler type control. What I am looking for must be something like the day, work week, week and month view of Outlook. It needs to be very programmable in that I can enter multiple tasks per day and give them different color backgrounds...
  2. Shemzar

    #include before <HTML> tag

    Where is the position of the #include to add the file m_IdentityFunction.asp ?, if this is at the begining of your ASP pages before the <HTML> tag then just put your re-direct code at the top of this file otherwise unfortunately you must put a new #include file into those ASP pages that users...
  3. Shemzar

    Wanted: A good starting point for ASP

    I found ASP IN A NUTSHELL from O'Reilly ISBN 1-56592-490-8 to be an excellent resource.
  4. Shemzar

    Len Question

    Hi dvannoy, No do the following strpath = InputBox$(&quot;Enter file name:&quot;) ' check that something was entered and append .jpg if Len(strpath) > 0 then strpath = Left(strpath, Len(strpath)) & &quot;.jpg&quot; end if Hope this helps.
  5. Shemzar

    Len Question

    Hi dvannoy, assuming that the name of your search string variable is searchstr and the name of your inputbox is inputboxvalue then the following should work. searchstr = Left(inputboxvalue, Len(inputboxvalue)) & &quot;.jpg&quot;
  6. Shemzar

    please help me out - complicated query

    Hi Angelina, assuming your table name is Table1, the following query will do it for you; SELECT Table1.data AS Data,First(Table1.primary) AS Primary, First(Table1.description) AS Description, Sum(Table1.amount) AS Amount FROM Table1 GROUP BY Table1.data ORDER BY First(Table1.primary)...
  7. Shemzar

    Need help Not Inserting duplicate records

    This example should help you, assume for the example that the MY_KEY is the record identifier that is populated by whatever is in IN_DATA1. INSERT INTO MY_TABLE (MY_KEY, MY_F1, MY_F2) SELECT IN_DATA1, IN_DATA2, IN_DATA3 FROM IN_TABLE WHERE not exists (SELECT NULL FROM...
  8. Shemzar

    Respone.Writing a count query

    Oops there was a syntax erro in the last posting (sorry!) this is try this instead; myconn=&quot;Put your database connection string in here&quot; set rs = server.CreateObject(&quot;ADODB.Recordset&quot;) getcountsql = &quot;select count(*) from tb_System&quot; rs.Open getcountsql, myconn,1,2...
  9. Shemzar

    Respone.Writing a count query

    Try This, myconn=&quot;Put your database connection string in here&quot; set rs = server.CreateObject(&quot;ADODB.Recordset&quot;) getcountsql = &quot;select count(*) from tb_System&quot; rs.Open getcountsql, myconn,1,2 if not rs.eof and not rs.bof then Response.Write(&quot;Total Record...

Part and Inventory Search

Back
Top