Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Mr. Chip Man
Starting Member
4 Posts |
 Posted - 2006-04-16 : 11:35:14
|
| Hello,I am a new user with my first post. I am working with a developer who created a Web application in .NET that uses a SQL Server 2000 database. The application is used for creating and displaying multi-screen online forms. All logic is performed server-side.Here is an overview of the process for a multi-screen form. The respondent enters in their responses on Screen 1, then clicks Next. The application records their Screen 1 data in the SQL2000 table on the server then displays Screen 2. The process repeats for every screen.Here is my question. I would like to include a relatively simple animated GIF in some of my screens. The animation would have a picture fade to black after a set time of say 10 seconds. I know how to create an animated GIF. However, when I tested the animated GIF in my application I discovered that certain browser security settings or firewall packages (like Zone Alarm) will block the animation from running. The GIF will display - but it never fades to black. When I set my security settings to a lower setting and turn off Zone Alarm, the animation runs. Since most people will not have their security settings so low, this method won't work.I wanted to see if there is some way I could program this simple animation on the server. I have two ideas how to do this. First, I thought I could create two screens. Screen A has all the text and the picture I want to display for 10 seconds. Screen B has the same text but the picture has been removed. I need a way for the transition from Screen A to Screen B to automatically occur after 10 seconds. In other words, I cannot ask respondents to click the Next button after 10 seconds. Rather, I need either .NET or SQL to start a counter when Screen A is displayed, then after 10 seconds, for it to record a value in the table as if the respondent clicked the Next button so that Screen B is then displayed. Is this possible?The other idea is to have some form of timer built into a screen that works as follows. I would set up two images, Image 1 is the GIF picture and Image 2 is another GIF of the same dimensions that is all black. First the screen posts displaying Image 1 (the GIF picture). After the screen posts a timer starts. After a time period I set (say 10 seconds), the screen refreshes and displays Image 2. I am not sure if this is possible since everything is done server-side. I hope the above makes sense. I am not a programmer. I asked my developer and he said that the software requires the user to enter data (i.e., click the Next button) before it will advance to the next screen. I was hoping one of you would have a creative solution I could propose to him for the above. Any ideas?Thanks in advance for your time and help! I am thrilled to have found a SQL forum and look forward to using this a lot in the future.Chip |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-04-16 : 11:42:13
|
| isn't there a time delay or time object in .net? is this asp?in sql you can delay transactions executed in a batch by using 'waitfor'by my suggestion is to handle this in the apps layer instead of server side--------------------keeping it simple... |
 |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2006-04-16 : 17:16:27
|
| Look up Meta Refresh. That may be the solution to your problem here.Meta refresh will "send" the user to a page after being on a page for X number of seconds.Michael<Yoda>Use the Search page you must. Find the answer you will. Cursors, path to the Dark Side they are. Avoid them, you must. Use Order By NewID() to get a random record you will.</Yoda>Opinions expressed in this post are not necessarily those of TeleVox Software, inc. All information is provided "AS IS" with no warranties and confers no rights. |
|
|
|
|
|
|
|
|
How to get a timed action in .NET/SQL2000