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 strongm 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. corneI

    Get the username of user editing a file

    Hi, We have an ini file that points to a licence file. It works wonderfully but there is a user or process that changes where the file points to. I have used the FileSystemWatcher class but it does not contain the username. Any ideas? Thanks Corne'
  2. corneI

    Logging received net send's info

    Hi all, I have setup SQl to send an net send to my PC to show the status of the sql jobs ie. Completed/Failed. Now my PC gets over run with net sends. I need to log each net send for example : Server Message I have searched high and low for something to show how I can get to the above. Any...
  3. corneI

    Triggers and replication

    Hi all... How are triggers treated during replication? Are they replicated with the table or not? Thanks :-)
  4. corneI

    Need the max 2 of a group

    Thanks nigelrivett. A real blond moment!!!!! :-) Stupid me! It works wonderfully!!!!!! Thanks a lot!!!!!!!!!!!
  5. corneI

    Need the max 2 of a group

    Thanks nigelrivett for your quick reply!!! :-) But I only have one table that looks the same as the example! Thanks :-)
  6. corneI

    Need the max 2 of a group

    Hi all.. My problem is a very simple and stupid one. I need the top 2 values per group. For example Group Value 1 10 1 20 1 30 2 100 2 200 2 100 2 50 What I need is. Group Value...
  7. corneI

    How to get top 10 in pivot table

    Thanks a lot Sorry for wasting your time
  8. corneI

    How to get top 10 in pivot table

    Hi all. Is it at all possible to get only the top 10 in a pivot table using VBA? Any ideas how to do it? Corne' #-)
  9. corneI

    Connecting to a mysql database and my SQL scripting help

    Hi 1)Try reading these thread333-524696 faq333-3801 2)Please refrase your question. Stuff???????????????????? A bit confusing for my blonde brain Corne' #-)
  10. corneI

    Dynamically updating a page through form input.

    Hi Read the following : FAQ333-3656 I think it will answer your question? Corne' #-)
  11. corneI

    Unique ID for Every Session

    bowettwow: You don't have to add a new record to the table just add 1 to the last recordnumber. Maybe somebody knows a quick way to do this so that you don't have to query the database for the last record? Corne' #-)
  12. corneI

    Date Subtraction

    onpnt : How wrong was I ????? I missed all the syntax errors. What else did I miss????????? Please accept my apoligizes Corne' [sadeyes]
  13. corneI

    Unique ID for Every Session

    bowettwow : If you have a Database, onpnt's idea will definatly work the best. It will cut the overhead of reading and writing to the text file as well as the creation of the FSO object.100% faster and safer. Corne' #-)
  14. corneI

    Date Subtraction

    Hi Is validtodate in time/date formate? If it is try sqlBanner = sqlBanner & &quot;WHERE datepart(dd,banner.validtodate) <= &quot; & &quot;'&quot; & DateAdd(&quot;d&quot;, -nodays, Now()) & &quot;'&quot; I'am just not to sure if the dd should be &quot;dd&quot;??????? If I where you I would...
  15. corneI

    Unique ID for Every Session

    Please correct me if i'am wrong but I do try I have never done this before but here goes!!!!!!!! In the global asa put the following sub: Sub Session_OnStart end sub This will be run when a new session is created. Then create a text file which contains a 0 Then use the file system object in...
  16. corneI

    Knocking on the right door?

    Hi So the format you want would look like: Previous | Next PHOTO Image 2 of 4 <CODE> <TABLE WIDTH=&quot;300&quot;> <TR> <TD WIDTH=&quot;300&quot; ALIGN=&quot;Right&quot;> <%=Buttons(ImageCount, ImageNumber)%> </TD> </TR> <TR> <TD WIDTH=&quot;300&quot...
  17. corneI

    Cache or Refresh

    Don't worry!!!!!!!!! Played around and found it. All I had to do was set <%Response.Expires = 0%> <%Response.ExpiresAbsolute = Now() - 2%> <%Response.AddHeader &quot;pragma&quot;,&quot;no-cache&quot;%> <%Response.AddHeader &quot;cache-control&quot;,&quot;private&quot;%> <%Response.CacheControl...
  18. corneI

    Cache or Refresh

    [sadeyes] I'am busy with a ASP page that contains href's to pdf's. I just need to know how I can refresh the page when the user clicks the back button after viewing a pdf?? Because the pdf's get updated quite often and the user needs to only see the most up to date pdf's. I have tried the...

Part and Inventory Search

Back
Top