|
Paul Conrad wrote: once a minute or two, run a trigger that checked if the user had been idle for more than 10 minutes
Tell about the trigger please . What kind of thing is it ? I am sure it is not the trigger concept in SQL. Can you elaborate ?
|
|
|
|
|
Here is a google search on triggers: Triggers in SQL Server[^]
Also, here at CP: http://www.codeproject.com/database/SquaredRomis.asp[^]
Not just using triggers, but have sql server run a scheduled task every so often ( you set the time between runs of the task ) take care of it for you. Maybe have it in a stored procedure.
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
I already know about triggers well. What I don't know is the "scheduled task" you talked about. How can I define such thing in SQL ? I have not heard anything about it till now.
|
|
|
|
|
As long as you are not using SQL Server 2005 Express or MSDE, SQL Server should have the ability for you to schedule jobs that can run queries or stored procedures. If you are using SQL Server 2005 Express or MSDE, you are stuck with writing a utility app that executes the query/stored proc on your database at the time/date you specify with the Schedule Tasks in Windows Control Panel (kind of cheap, but it works).
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
As a matter of fact I am using SQL Server 2000. But I have not seen anything about scheduled jobs in "Books online". You will do me favor if you at least give me the expression for creating such scheduled jobs. Just mention the keyword and I will find details in Books Online.
|
|
|
|
|
Usually I just go through Enterprise Manager.
This google search might help: Scheduled Tasks in SQL Server[^]
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
Hi Friends,
I got the code Bubble Tooltip.js (http://www.adesblog.com/2006/04/15/bubble-tooltipjs/) to display a bubble tooltip. Its only used whereever we have a href(anchor tag). But i need to display a bubble tooltip for a Label(asp.net Label). I tried to search this.Please help me to display a Bubble tooltip for a Label(asp.net Label)
Its urgent Please help me.
-- modified at 10:35 Saturday 27th October, 2007
|
|
|
|
|
I'm creating an image editing tool website and I want to know how I can display a bitmap class on a webpage like you can do in windows forms. There is an image control supplied but that only lets me specify a url.
I could just save it to a file and set the image url to that but then if they refresh the page they will see someone else's work.
|
|
|
|
|
If you would want to do that, you would have to create a component that you could run in the browser, that would display the image. It would not be very efficient, though, as the data in a bitmap object is not compressed.
The browser itself is only capable of displaying images in the form of an image file. They don't have to be saved on the server as an actual file, though, you can create a page that creates the image file data and sends it as a response to the browser.
---
"Anything that is in the world when you're born is normal and ordinary and is just a natural part of the way the world works. Anything that's invented between when you're fifteen and thirty-five is new and exciting and revolutionary and you can probably get a career in it. Anything invented after you're thirty-five is against the natural order of things."
-- Douglas Adams
|
|
|
|
|
Acutually I want to prevent cross-site scripting in asp.net forums.
If I want to protect from user input data when user (lamer) enter script in the textbox in asp.net forms. If I get to textbox string and convert the <, >, & symbol to HTMLEncoding in the string. Is this process enough for prevent cross-site scripting?
Best Regards...
|
|
|
|
|
Yes.
But you ought to process HTML on the way out as it's getting displayed on screen rather than store it in the database in HTML encoded format. This ensures the database stores the data in a platform neutral format, also because some ASP.NET controls perform their own HTML encoding (such as the ToolTip property, or Text property for TextBox controls), and you'll end up encoding the encoding and the user will see < on the screen instead of <
Use Server.HtmlEncode(outputString), but don't do this for control properties that already do their own encoding for above reason.
|
|
|
|
|
hi to all
i am using a radiobutton list ,and want to change the back ground color of the select item text.
please help me some one.
rajeev kumar sharma
vri software pvt. ltd.
new delhi India
|
|
|
|
|
set AutoPostBack="True" and try following code
protected void RadioButtonList1_SelectedIndexChanged(object sender, EventArgs e)
{
RadioButtonList1.SelectedItem.Attributes.Add("style","background-color:Black");
}
please don't forget to vote on the post that helped you.
|
|
|
|
|
very very thank sir
rajeev kumar sharma
vri software pvt. ltd.
new delhi India
|
|
|
|
|
how to change the forecolor of selected radiobuttonlist...
|
|
|
|
|
RadioButtonList.SelectedItem.Attributes.Add("style", "color:red;");
bEst rEgard
pAthan
please don't forget to vote on the post that helped you.
|
|
|
|
|
Thanx ya!
Its working!
|
|
|
|
|
how to integrate more than one clipping in a single mediaplayer using html
|
|
|
|
|
I want to show the selected video clip in the asp page.so am using the embed object and iwant to pass the selected videos path to that object.i tried lot but none of them is working.embed object code below
<OBJECT id='mediaPlayer' width="320" height="320"
classid='CLSID:22d6f312-b0f6-11d0-94ab-0080c74c7e95'
codebase='http://activex.microsoft.com/activex/controls/mplayer/en/nsmp2inf.cab#Version=5,1,52,701'
standby='Loading Microsoft Windows Media Player components...' type='application/x-oleobject'>
<param id="path" name='fileName' value=""
<param name='animationatStart' value='true'>
<param name='transparentatStart' value='true'>
<param name='autoStart' value="true">
<param name='showControls' value="true">
<param name='loop' value="true">
<Embed type='application/x-mplayer2'
pluginspage='http://microsoft.com/windows/mediaplayer/en/download/'
id='media' name='mediaPlayer' displaysize='4' autosize='-1'
bgcolor='darkblue' showcontrols="true" showtracker='-1'
showdisplay='0' showstatusbar='-1' videoborder3d='-1' width="320" height="363"
src="" autostart="true" designtimesp='5311' loop="true">
</Embed>
</OBJECT>
i used javascript to pass the value to the object but it is not working
javascript follows
function playAudio(){
var doc = document.getElementById('path');
var doc1 = document.getElementById('media');
doc.value=hdVideo.value;
doc1.src=hdVideo.value;
}
</script>
hdVideo is a hidden field,am setting value in this hidden field from their am taking the value.if am doing window.alert am getting the value,suppose if am hardcoding this value in the embed object it is working.but i want to pass the value at run time.
Then body onload event i called this javascript.
|
|
|
|
|
Hi everybody!
how to integrate more than one clipping in a single mediaplayer using html
Pandi
|
|
|
|
|
|
hi,
my requirement is that i have to enable user to type both string and also allow him to choose the image
For this,
i used ifrmae and file so that user can choose the picture which will be visible in ifram and also he can type the text.. all r working fine
problem is
in iframe i can have more than a picture and string so while saving how can i get the path to upload in server..
pls help me
|
|
|
|
|
|
there is a content placeholder in the master page , now in the content place holder , i have a button, i have to write the javascript function , how i should use the getelementbyid function to access this button control
Soniagupta1@yahoo.co.in
Yahoo Messenger Id = soniagupta1
|
|
|
|
|
if you want to call javascript in master page
getElementById('masterIdPage_buttonId')
if you want to call javascript in content page
getElementById('buttonId')
bEst rEgard
pAthan
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
