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.
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?
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.
--
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.
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...
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...
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.
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...
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?
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?.
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.
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.
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...
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'.
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...
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
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.