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

    Count of records for past week.

    Hello Guys, I have a query which looks like this: Select COUNT(SaleOrder_ID) AS ThisWeekCount From SaleOrder Where Placed IS NOT NULL And Placed >= DateAdd(Week, DateDiff(Week, 0, GetDate()), 0) I thought that this would count the number of sale orders placed in the...
  2. TamedTech

    Conditionals

    Hello Guys, I'm looking for a little advice on how to best form this query. I have three columns in a table, these are all 'int' datatypes and represent a 'state' for the record. ConfigState int EventState int MessageState int What I'm looking to achieve is a query which if the...
  3. TamedTech

    A time out occurred while...

    Hello Guys, I've noticed some really slow performance on an application which is backed by a SQL Server database and it all seemed a little stange so thought I would take a look through the server logs, and it appears SQL Server is throwing a large number of error messages, all saying. This...
  4. TamedTech

    SQL 2k5 Database Migration

    Hello Guys, I've got a couple of remote servers, both running win2k3 and SQL 2005 Workgroup. I'm looking to migrate one of my databases from one server to the next and thought I'd come and get some advice from you on the best way to do it. The database is currently sitting at around 7GB in...
  5. TamedTech

    Error 80092004

    Hello Guys, I've come into the office this morning to get spme work done and for some reason when trying to access my local SQL Express databases I get an error saying that connection is refused. So, I too a look at the running services on my system and noticed that SQL Express service hadnt...
  6. TamedTech

    Outlook 2k7 on Vista forgetting passwords

    Hello Guys, I've come into the office this morning and my Outlook 2k7 seems to have decided to start playing silly buggers with me. It wont remember the passwords for any of my pop accounts. I have done some googling around and found this tech note on the knowledge base which seems to describe...
  7. TamedTech

    Bluescreen On Boot

    Hello Chaps, I've got a system here running XP which is blue screening on boot with the following error message: I've tried all the usual F8 boot options for safe mode and last known working configuration and those kind of things but keep running into the same error. I've also tried the...
  8. TamedTech

    Select, Modify & Insert Records

    Hello Guys, I've got a requirement I supose to duplicate set of data between a certain date and time for a particular table. I essentialy need to SELECT all records from the table as follows: SELECT Unit_ID LogRef_ID DateTime FROM Message_Log WHERE Unit_ID = 4 AND DateTime...
  9. TamedTech

    Delete Records Before Date X

    Hello Chaps, This is only a simple one, and to be honest I feel like a moron for even having to ask, but its a frosty cold morning in the south of england, and my brain appears to be working at half speed. I have a table called MessageLog which has a datetime column named LogDateTime, and I'm...
  10. TamedTech

    Hierarchical Query Help

    Hello Guys and Girls, I'm completely new to Hierarchical Queries and so I'm feeling a little lost, I've read through some litterature on the web but it all seems rather complex to me at the moment, so I'm after a little help and hopefully I'll learn somthing from you. Basicly this query is to...
  11. TamedTech

    Delete File On Boot

    Hello Guys, I have a file which I want to delete as early on in the boot process as possible, before I have a particular application started in the inittab file. Whats the best way to achieve this? I've tried kick starting a shell script from the top of the inittab file which was meant to...
  12. TamedTech

    Bash Binary Check

    Hello Guys, I'm trying to write a small script that does a check to ensure an application hasnt frozen for my watchdog timer. The script needs to return a brinary 0 if all is fine, and 1 if there is a problem. I'm not sure of the best way to check that the application hasnt frozen, but at the...
  13. TamedTech

    Help Fixing Bug.

    Hello Guys, I'm having a bit of trouble with this, probably due to my lack of knowledge when it comes to JavaScript. I've implemented a little datepicker expanding div as found on the javascript toolkit site http://www.mattkruse.com/javascript/calendarpopup/ but it seems to be conflicting with...
  14. TamedTech

    IIS7, Vista, Could not load all ISAPI filters...

    Hello Guys, I've just installed IIS7 on my vista system to start doing some local development work, and I keep getting the following error when I browse to the local host, regardless of the extension, ASP, CFM, HTML etc... Now, as a little self diagnosis I checked through the event viewer...
  15. TamedTech

    Zapatek Date Selector

    Hello Guys, I'm using the little date selector widget from zapatek and it seems to be working just fine, however I'm looking to edit the function that is run when a date is selected. <script type="text/javascript">//<![CDATA[ function flatCalendarCallback(cal) { if...
  16. TamedTech

    Checkbox Form Control

    Hello Guys, I've got a form that allows users to enter the start and end times for an event into two small text unput fields on the form. Now what I'm looking to do it have a little checkbox for 'this is an all day event' which can be checked, which then disables or hides the two text fields...
  17. TamedTech

    Calendar Layout, Somthing Sexy!

    Hello Guys. I'm looking for an attractive looking CSS/Table calendar for my site. I'm not talking about a tiny little one, but a full blow calendar with events listed for each day and suchlike. I've looked around the next and found a few design ideas, but they're all based around little...
  18. TamedTech

    Opacity Problems

    Afternoon Chaps, Been a while since I've delved into the old CSS stuff and got a little problem on my latest template with opacity/transparancy and things, which I've not worked with before. Basicly I have a dark colour background to the page, with an opaque white <UL> over the top of it, like...
  19. TamedTech

    Style Select List Fonts

    Hello Guys, I have a SELECT drop down box containing the names of different fonts and I'm hoping to be able to have the name of the font displayed in that font face. Can I style the font face of the items in the select list? if so then how? Thanks guys, Rob
  20. TamedTech

    Pulling My Hair Because Of FTP

    Hello Guys, I'm really struggling with getting my IIS6 FTP site to play correctly, every time I get it working it seems to brake shortly thereafter and its driving me nuts. So I know that FTP is a plain text protocol so will not likely be _THAT_ safe buy I'd like to do my best and at least...

Part and Inventory Search

Back
Top