|
Jet/Access doesn't support multiple statements in a query, otherwise known at a batch in the SQL world. Only single statements are allowed. You'll have to break this up into two seperate queries and run them seperately.
I think your second query should look like this:
SELECT COUNT(DISTINCT Number) FROM TableInfo
No quotes around the DISTINCT Number part.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
|
OK. It works perfectly in SQL Server. I knew I hated Access for some reason. The equivelent in Jet T-SQL is:
SELECT Count(*) AS DistinctNumberCount FROM
(SELECT DISTINCT Number AS DistinctNumbers FROM TableInfo);
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
As for SSL/TLS, sending a notify is important. However it doesn't seem like SSLStream support that.
Please correct me if I am wrong, and what is the solution for this issue?
Thanks 
Elapid For The Win
|
|
|
|
|
Need some help here pls 
Elapid For The Win
|
|
|
|
|
First, we don't get paid to do this. This is an all-volunteer effort, not a job.
Second, putting this little "I REALLY NEED HELP!" note up 4 hours after you posted the "question" probably got your post ignored even more.
Third, and probably what really got your question ignored, is your question really doesn't make any sense. Why would a stream class concern itself with putting up an Alert messagebox or anything else User Interface related? It's not what a Stream object is concerned with!
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
-- modified at 16:08 Thursday 19th January, 2006
|
|
|
|
|
Of course it doesn't support putting up an Alert Message. It supplies a Stream! Why would SSLStream concern itself with anything about a user interface element?
Sending a notification for what? That's going to be up to you and whatever you want to tell the user based on some condition...
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Sorry for the lack of my courtesy
Okay let me verify my question.
In SSL/TLS, there are a struct called Alert Message. Now what it does is to notify the server/client a few things according to what it is going on.
Now with the SSLStream in .NET 2, it doesnt seem to have an option of handling that alert (notification).
So now my question is .. do i need to implement it? because if there is something that I am missing and can handle that, then i dont have to do it
THANK YOU.
Elapid For The Win
|
|
|
|
|
Thanks for the clarification.
No, the SSL Alert protocol has not been implemented in the .NET Framework, ... yet anyway.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
you are the man!
Thanks
Elapid For The Win
|
|
|
|
|
Hello all,
I have to develop a project which can generate/capture a media streaming of different protocol(e.g. RTP,Microsoft multimedia server(MMS), ...).
So, is there any thing by which i can handle differet protocol?
Also mention that all stream are captured by media player/My own.So, I hava to handle different Encodeing/decoding(e.g. mp3,wav) techniques.
I mention that I see the functionaliy of VLC Player. But I have no idea to handle the component(axVLCPlugin) by C#.Net.
|
|
|
|
|
Hi!
I'm working on some math routines, and I need to see if two double's are *almost* equal. I've read
http://www.cygnus-software.com/papers/comparingfloats/comparingfloats.htm
and tried to implement the same thing in C# with doubles. After a bit of fiddling I got this following code:
public static bool CheckedApproximatelyEqual(double a, double b, int maxSteps)
{
if (double.IsInfinity(a) || double.IsInfinity(b))
return false;
if (double.IsNaN(a) || double.IsNaN(b))
return false;
ulong aInt = unchecked((ulong)BitConverter.DoubleToInt64Bits(a));
if ((aInt & 0x8000000000000000) == 0x8000000000000000) aInt = 0x8000000000000000 - aInt;
ulong bInt = unchecked((ulong)BitConverter.DoubleToInt64Bits(b));
if ((bInt & 0x8000000000000000) == 0x8000000000000000) bInt = 0x8000000000000000 - bInt;
long dif = unchecked(Math.Abs((long)aInt - (long)bInt));
return dif <= maxSteps;
}
Now the question is how does this look? Do you have any methods you believe are better for comparing floats?
There's *AT LEAST* one problem with this implementation, and that is denormalized values. Any suggestions on how to handle them? I guess I can just round them off to either zero or the smallest normalized value depending on their value!?
|
|
|
|
|
Hi,
I need a way to search a file with regular expressions to find the following syntax:
somevariable = "daaata on maybe one line" +
"might even be continued on more lines" +
"and so on...";
So actually to get from 'somevariable ..' to the end of it at 'on...";'.
Now, I have been using regular expressions numerous times, but I cannot determine how to check this?
Thanks!
- -
Regards SirErugor
-- modified at 9:43 Thursday 19th January, 2006
|
|
|
|
|
How do i remove white spaces from the beginning of a rich text.
thanks
Nana
|
|
|
|
|
Use the Trim method...
Q:What does the derived class in C# tell to it's parent?
A:All your base are belong to us!
|
|
|
|
|
Thanks. But it is not working. I used the enter key to return to the next line. I did that through a couple of lines before typing the data. Now what I need to do is remove those return characters from the beginning while keeping the format.
thx
Nana
|
|
|
|
|
Well those are not spaces, so logically it will not work, eh?
Then you will have to use the Replace method, figuring out the algoritm shouldn't be to hard...
Q:What does the derived class in C# tell to it's parent?
A:All your base are belong to us!
|
|
|
|
|
|
Hi All,
This might stem back to 'C' days and I probably ought to change my 'mindset' and other such phrases but old habits die hard. Call me Cliché Man...
When I write an applicaton, I tend to have a source file or two put aside to put all 'those little useful functions' in. You know, generic things like formatting a postal code, validating things etc. that don't fit in with a specific class anywhere. Well, using C#, I've implementing this as follows:
In library.cs:
<br />
namespace mylib {<br />
public class rog {<br />
static public int DoSomething(int arg) {<br />
return arg+1;<br />
}<br />
}<br />
}<br />
To call this function, I'm putting this in app1.cs:
<br />
using mylib;<br />
...<br />
b = rog.DoSomething(3);<br />
This seems like using a class where there is really no need. I'd like to just call 'DoSomething(3)' without the 'rog.' part.
I'm new to C# so be gentle, I'm old to C and C++ so feel free to be harsh.
Am I being stupid?
Thanks for any confirmation or denial...
Rog
|
|
|
|
|
You can't have methods without a class in C#...
So considering that your aproach is ok, but maybe not so OOish
Q:What does the derived class in C# tell to it's parent?
A:All your base are belong to us!
|
|
|
|
|
You can't do that in C#
In latest java (1.5) you can do static import and in C# 2.0 you can have static class that will force you to have only static members and can't instentiate that class.
One possible (but not recommended) solution would be to have
class rog
{
... static methods here...
}
class myclass : rog
{
... now you can call methods of rog without rog.
}
|
|
|
|
|
That's sort of what I'm after - I didn't think of deriving my class from the library - seems a roundabout way of resolving the function names though.
What I'm after really is a way of defining functions in the same way as you would, for example, the 'sin()' function as I'd much rather use:
result = sin(pi*4);
then
result = rog.sin(pi*4);
The library doesn't have any actual data (or if it is, it'll be static) and I don't intend to instantiate an instance of it.
I still have this nagging feeling that I just haven't 'got the hang' of C# yet...!
Rog
|
|
|
|
|
Hi everybody!! Is it possible to bind a bidimensional array of double to a datagrid?if yes how can i do this?
I can't manage this.
Thank you so much
Alessio
|
|
|
|
|
You wrote:
8) now place the encryption/decryption key in the registry and lock it down with security so that only your application has the rights to read it.
what do you mean about registry, and "lock it down with security.."?
|
|
|
|
|
Please reply to the appropriate message rather than start a new thread. If "RealCondor" has elected to receive email notifications of a replies to his post then he'll get an email telling him that - there is even less of a guarantee that he'll see this message.
ColinMackay.net
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius
"If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
