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: *

  1. sherly

    RE: Creating a RECORDSET - problem with .txt flat file.

    Maybe you should try to enclose your table name with '' SELECT * FROM 'Data.txt' If the Dreamweaver keep altering your code, try to save all your changes and edit your file using a text editor for your future amendments.
  2. sherly

    Embedding Video

    I couldnt get the movie displayed too because i don't have the plugin. I suggest u can put up a link to download Quicktime plugin for visitors. Try to use flash or windows media file since it's more common..
  3. sherly

    How to control user disk usage quota ?

    Sorry, this couldn't works for me, coz user login using FTP, they don't have accounts in Windows 2000.
  4. sherly

    How to control user disk usage quota ?

    Hello, we have a win 2000 server and we have a few folders assigned to a few user. Each user should have only 5MB of maximum usage for their individual's folder. We are using the WarFTP server. Is there anyway to control the user disk usage? Any 3rd party software to control this? Coz currently...
  5. sherly

    Query in Comparing Values

    Hello, I'm using Microsoft Access & I'm trying to comparing values from the following tables. Hi all, I have 2 tables. One is called [master] and another is [details]. [Master] will hold all the unique counter name where else the [details] will hold all the records of the counters. Master...
  6. sherly

    Timeout Expired

    I have tried to execute the query using SQL Enterprise. It also give me the timeout response. What should I do beside fixing my query?
  7. sherly

    Timeout Expired

    Hello, I wrote some scripts using ASP to update the SQL Server 2000. I have include the following codes at my ASP : Response.Buffer = "True" Response.Flush Server.ScriptTimeOut =3600 But I keep getting this message displayed before the update query is completed Microsoft OLE DB...
  8. sherly

    TimeOut Expired

    Hello, I wrote some scripts using ASP to update the SQL Server 2000. I have include the following codes at my ASP : Response.Buffer = "True" Response.Flush Server.ScriptTimeOut =3600 But I keep getting this message displayed before the update query is completed Microsoft OLE DB...
  9. sherly

    Problem in Running This Statement in SQL 2000

    Yes, I tried putting C.CounterDate, still the same err msg Column 'C.CounterDate' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY Clause
  10. sherly

    Problem in Running This Statement in SQL 2000

    Yes, I tried yours, William. I got this error message : Column 'C.CounterDate' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY Clause
  11. sherly

    Problem in Running This Statement in SQL 2000

    This one is for the version of Raj1Patel. There's an error message of : Column 'C.High' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY Clause
  12. sherly

    Problem in Running This Statement in SQL 2000

    Hi Williamu, I tried your statement and it gives me the error message of Column 'C.CounterDate' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY Clause
  13. sherly

    Problem in Running This Statement in SQL 2000

    There's an error message of : Column 'C.High' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY Clause
  14. sherly

    Problem in Running This Statement in SQL 2000

    UPDATE SecCounter SET HHigh = Max ( SELECT TOP 200 C.High FROM CONS C GROUP BY C.CounterName WHERE C.CounterName = S.CounterName ORDER BY CounterDate DESC ) , CloseV = Max ( SELECT TOP 1 C.CloseV FROM CONS C GROUP BY C.CounterName WHERE...

Part and Inventory Search

Back
Top