Comments by snorkie (Top 53 by date)

SDELETE doesn't have any flags that will do this. Do you have to use sdelete? A simple recursive function would do this.

How didn't it work? If I update the example to use the two dates you mention in your example, they return the week number that you want. Provide more feedback if you want more help.

http://bfy.tw/49fS

I don't have access to that version. Try removing all references to iTextSharp from your Solution (not just the project you're on). Then add it back in.

This is a very subjective question. Maybe consider searching CodeProject first...

http://www.codeproject.com/Articles/717523/Top-NET-Based-CMS-Content-Management-System

Yes, when you pass the query string into SQL server, it will recognize the SQL function and run it.

One more thing to try before I give up... Change to:

SET @sSQL = @sSQL + ' AND tbl_Reim_Detail.Claim_Amount ='+ CAST(@Claim_amount AS Numeric)

Hogan

Start by taking out the

where tsl.skill_level.Contains(RadioDisplayLevel.SelectedItem.Text)

and see if it returns any results. If not, then you know that your joins are not correct.

Try the following:

// sleep for 1 second
sleep(1);

http://php.net/manual/en/function.sleep.php

If you're just trying to prevent people from writing a script to guess passwords, put a sleep of 500 miliseconds into each login attempt. This will not seriously affect good users, but will make it too slow to script password guessing.

can you elaborate on what it is doing.

Are you asking for the public/external IP address(es), or the local LAN address(es)?

Guess you're gonna be in trouble!

Have you tried turning it off and back on?

Try it and see what happens!

Its worth mentioning that the solution I have suggested covers things like "private browsing" mode.

This doesn't take care of other browsers. It is simple, but only for IE, and it doesn't cover "private browsing" mode.

try adding some debugging: http://php.net/manual/en/function.mysql-query.php is a great place to start with query examples and debugging to go with it. see if they query returns true or false. I bet it'll end up being a permission issue.

What is the error you're getting from the database?

change the font :) Seriously, please help us understand the context of the problem so the correct solution can be offered.

Do you want help for C# or javascript?

Use the System.Process.Start() method. I've provided the MSDN link below with an example. As long as the machine has a mime type set up (you can double click and it opens), Windows will figure out what application is used and open it up. So place the full UNC path (if you can) or local path of the file and it'll open with your PDF viewer.

System.Diagnostics.Process openPDF = new System.Diagnostics.Process();
openPDF.StartInfo.FileName = "Your File Path.pdf";
openPDF.StartInfo.UseShellExecute = false;
openPDF.StartInfo.RedirectStandardInput = false;
openPDF.StartInfo.RedirectStandardOutput = false;
openPDF.Start();

http://msdn.microsoft.com/en-us/library/e8zac0ca.aspx

It depends on your environment. I often deal with files in other cities/country as if they were sitting next to me because the network was set up for files/server to be local.

Have you tried counting a column instead? Try COUNT([FailureModels].[Id])

Fair enough.

How would you recommend that I add additional information then? I thought this link would be useful to others...

Glad I could help. Good luck your app and have fun!

Hogan

Post the SQL you have tried and I'll help you get it straightened out.

Please help us understand what you are trying to do. Its generally not a good idea to modify the resx as its a system file. There is probably a way to do it in your class instead.

That's fair. Thanks for your response.

Christian, that's a bit harsh. Not everybody is a gifted programmer. Looking at the last post and the current post, the answers were not easy for a beginner. Using phrases like "member variable" may not mean anything to a newbie. I'm hoping that the simple solution I provided as number three will be enough to get him/her moving forward and gain some confidence. I think we get stuck on elegant solutions sometimes and need to refocus on dead simple.

CodePrakash, you need to provide more information if you want help. Are you using a third party licensing tool, or do you want to create your own licensing?

What error are you getting?

Can you provide more information. What isn't working? What database technology are you using and maybe something about the process you're trying now.

See my improved answer. Good luck!

Hogan

Instead of creating a service that constantly hits the database and check to see if a user is logged on, could you put that logic into the log in process. If a user is trying to log in and the database shows no activity, then auto log that expired session and start a new one. The benefit here is not processing the data for all users every couple of minutes. This would be a very focused query that minimizes resources and only runs when it is necessary.

Hogan

The hosts file is located in %windows%/system32/etc/hosts [no extension]. Add the DNS name like "www.codeproject.com" and then point it to another location like 127.0.0.1 and nothing will show up.

For the second example with fiddler, check out the API for fiddler at http://www.fiddler2.com/fiddler/dev/
It requires custom development, but it does have great examples to get you started.

For the third example, I'm not sure. From all the research I have done a NDIS driver is about as good as it gets.

Emilio had several great points in his solution he mentioned. Based on the environment you're going to be in and the savvy of the users, it will decide your solution. Ultimately, everything that is done can be undone.

Hogan

You need to use caution with this approach to account for a change in time zones. If a user travels several time zones away, you could incorrectly invalidate a license with this method. I like your approach, but maybe consider a 30 hour window before disabling the license.

Along these lines, it is possible to keep track of how long the program has been in use and compare that with dates to ensure that the time does not roll back too far.

Why is it that somebody always has to ask "Why are you doing this" when somebody asks an honest question? wouldn't it be easier to answer or not answer. It seems that people are reamed when they don't make their question specific enough, but people can ask this generic question and get away with it.

To shanku.shau: Are you asking for the mouse not to work within your application, or in all of Windows when you are running?

No offense taken. I wanted to clarify my answer.If I'm wrong, then I need to know so I stop making mistakes. This is a great way to validate/refute what I do every day. The .TryParse method has saved me lots of headache for unvalidated input. --Hogan

I agree that the problem is about catching a null value. However, the code I posted will catch a null via the .TryParse method and I understand it to be much safer if other invalid values are passed in. Sorry that you didn't like it! Good luck! --Hogan

Is this something that needs to be real time, or a one time change. For a one time change, I recommend using a tool such as Red Gate SQL Compare(http://www.red-gate.com/products/sql-development/sql-compare/) they have a 14 day trial to see if you like it.

If this is something that needs to be dynamic, can you provide a sample table with columns and how you need it changed. Hopefully you don't have to change column types often at run time.

Finally as a crazy idea, and one that I don't recommend, why don't you put all of your variables in the database under the nvarchar type. Then when you put anything in, you do a .ToString() and when you pull it out, convert it back to the intended type.

Thanks for the answer. Now all I have to do is figure out why it works :) Time to study! --Hogan

Yes, I just noticed that it did swallow part of my copy/paste. Thanks for the clarification.

Sorry, I got that backwards. For an XmlNode of "profile"
.InnerText returns "pp4.PowerProfileID.01".
.InnerXml returns "pp4.PowerProfileID<hour minutes="0">.01"
.value returns <null>

What i wanted is "pp4.PowerProfileID"

I don't mean to state that the .NET framework is wrong. I'm just surprised by the results. Trying to figure out if the XML was designed wrong, or I'm just trying to get at the answer the wrong way.

I'm actually looking for the text from hour's parent node.

Thanks, but innerXML will return "pp4.PowerProfileID<hour minutes="0">.01" when I am only after "pp4.PowerProfileID"

I did not mean to suggest that the DOM implementation of .NET was bad, just the design of the XML document I am working with.