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 Chriss Miller 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. williamu

    Animated GIF in element with ID.

    Ok I can see the logic in that BillyRay I'll give that a go but the image is a perpetual loop animation, but worth a try all the same. Thanks.
  2. williamu

    Animated GIF in element with ID.

    Thanks for that but I see no relevance to my situation here as I am using a style with visibility:hidden; to hide the DIV that contains the image. In addition to this the image height and width are both known and set within the IMG tag. Or have I missed something.
  3. williamu

    Animated GIF in element with ID.

    Hi All, I have an animated GIF contained within an invisible DIV tag, however, when this tag is made visible the Animation does not play in I.E. but it does in FF and NS. Does anyone know why and is there a fix for this?
  4. williamu

    Am I missing something?

    Hi audiopro, In answer to your question BUFFER_SIZE is a constant defined as 8192. But in this instance is quite redundant as the image is saved to disk as expected. --
  5. williamu

    Am I missing something?

    Hey, now that's an impressive response time. Thanks. Ok, the " qoutes now works but results in this: Exception 435: unable to write blob `/tmp/magick-LAe12710': Bad file descriptor. but there may not be any ImageMagic guys here, is there? Thanks again.
  6. williamu

    Am I missing something?

    Hi All, I have the following code: sub SaveAttachment { my $Success = 0 ; my $fh = $CGI->upload("MyPrint") || undef ; my $fn = sprintf("%lX.jpg", time()) ; my $File = sprintf("%s/%s", UPLOAD_DIR, $fn) ; if ($fh) { $Tmp->param(FileName => $fn) ...
  7. williamu

    No rows returned via ASP but works in QA

    Cheers Man you've made my day, can you explain to me why this is, just so as I know.
  8. williamu

    No rows returned via ASP but works in QA

    Hi all, I have a stored procedure that returns some 365 rows (one for each day of the coming year). When executed in Query Analyser or Enterprize Manager it works. However when executed via ASP it doesn't return a result set, I'm totally at a loss with this and I was wondering if anyone has...
  9. williamu

    Intermittent SQL Server Error

    Hi, On some records within a database I'm getting the following error, however, on others it works. Microsoft OLE DB Provider for SQL Server error '80040e14' SqlDumpExceptionHandler: Process 64 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this...
  10. williamu

    Setting column value in a trigger.

    Thanks to all who helped, I worked this one out yesterday and I'm please to say it now does as expected. If anyone wishes to see the finished trigger then please ask.
  11. williamu

    Setting column value in a trigger.

    Nope it still doesn't work, either that or I'm just missing the point. I want to create an ID that it raised to the power of 2 on each insert, and I want to use a trigger for this. Here's what I've got. CREATE TRIGGER Attribs_Sequence_ID ON Attribs FOR INSERT AS DECLARE @CurrID INT DECLARE...
  12. williamu

    Setting column value in a trigger.

    This may work but I want to set the column value for the table the trigger is executing on. This INSERTs into another table. What I want to do is UPDATE Inserted but as this can't be done using UPDATE Inserted SET xxx = yyy, how do I do it?
  13. williamu

    Setting column value in a trigger.

    Hi, How do I set a column's value within a trigger? For example I have a table with 2 fields A. & B. B's data is user supplied and A's is inserted in a trigger, how do I do it? I can't find the answer after 30 mins of msdn and googling. Can anyone tell me please?.
  14. williamu

    Forward Engineering Database

    Does Visio support forward engineering a Database Diagram to generate / update the database from the drawing? I'm sure it does but I can't see where it can be done. Any help would be appreciated.
  15. williamu

    Well I can't see what's wrong, can you?

    Thanks guys. That's that one solved. It was missing the FROM Inserted Clause but I've opted to go for the Computed Column as it's more elegant. Have a star guys.
  16. williamu

    Well I can't see what's wrong, can you?

    This is what I get: Server: Msg 207, Level 16, State 3, Procedure Booking_Duration, Line 2 Invalid column name 'ToDate'. Server: Msg 207, Level 16, State 1, Procedure Booking_Duration, Line 2 Invalid column name 'FromDate'. Using: CREATE TRIGGER Booking_Duration ON Booking FOR INSERT, UPDATE...
  17. williamu

    Well I can't see what's wrong, can you?

    Jeez, that was quick thanks, and it is the complete trigger. But if I remove the SET from the statement I now get: Server: Msg 170, Level 15, State 1, Procedure Booking_Duration, Line 2 Line 2: Incorrect syntax near 'DaysStay'.
  18. williamu

    Well I can't see what's wrong, can you?

    This very simple trigger : CREATE TRIGGER Booking_Duration ON Booking FOR INSERT, UPDATE AS SET DaysStay = (SELECT DATEDIFF(dd, FromDate, ToDate)) Fails with this error: Server: Msg 170, Level 15, State 1, Procedure Booking_Duration, Line 2 Line 2: Incorrect syntax near '='. I can't see...
  19. williamu

    Whats quicker - execute query or update a recordset

    Hi David, You may want to read the thread thread222-866413 as it appears to be relevant to your situation. HTH William Software Engineer ICQ No. 56047340
  20. williamu

    Status Bar Question

    Thanks guys. Did a combination of both suggestions, and added the ability to increase the refresh period via the Apps properties. *'s to you both. William Software Engineer ICQ No. 56047340

Part and Inventory Search

Back
Top