|
SOOOO embarrassed about this, but I feel like I must post, so as not to further dissuade anyone from using MySql.
As it turns out, the code the was executing in production, somehow (um, me) was double-building an inner join.
So, instead of something like this:
select s.id, s.tag, s.gline, s.sex, bdCal.yyyymmdd as birth_date
from weaner_83 s inner join calendar bdCal on bdCal.dddd=s.birthdate
where id in ('X05008869E1G7','X05028869E1G7')
I was getting this:
select s.id, s.tag, s.gline, s.sex, bdCal.yyyymmdd as birth_date
from weaner_83 s inner join calendar inner join calendar bdCal on bdCal.dddd=s.birthdate
where id in ('X05008869E1G7','X05028869E1G7')
These ids can only exist once in the table. With these two Id's, i was getting 380,000 records. Why, you ask? about 190,000 records in the table, and 10,000 in the calendar table.
Of course my actual code was query much more than just these two id's.
I'll probably never know how this happened, but most assuredly it's my fault. Now it's fixed, and i've burned a good 8 hours.
Thanks for you willingness to help.
|
|
|
|
|
Glad to hear you solved it  I are Troll 
|
|
|
|
|
Hello to All,
I want to know that what is the diffrence between Compact Framework and Normal Framework.
ThanksIf you can think then I Can.
|
|
|
|
|
The .NET Compact Framework is a subset of the full .NET Framework. It implements approximately 30 percent of the full .NET Framework class library and also contains features and classes that are specific to mobile and embedded development. I are Troll
|
|
|
|
|
Dear Friends.
I've making a wpf application. in a part of my program, I need some "windows forms" controls. I use WindowsFormsHost for using that controls. it work correctly, but the theme of controls (in windowsformshost) is windows classic. but I using Windows Aero (Windows 7).
Here is an Image of my Problem:
<a href="http://ghiasi.net/wpf.jpg">http://ghiasi.net/wpf.jpg</a>[<a href="http://ghiasi.net/wpf.jpg" target="_blank" title="New Window">^</a>]
How can i correct the theme of Windows Forms Controls in WPF Application?Regards.
Mehdi Ghiasi
|
|
|
|
|
The normal Windows Forms control do not support WPF themes, nor Aero Glass. You have to replace the controls with ones that do.
You may want to look into a third party control library if you want to get up and running faster, or put the time in to develop your own.
|
|
|
|
|
I need to check all element of an array to see if all are equal to 1 or 'T' then do something.
how can i do this?
|
|
|
|
|
My first guess would be to iterate over the array and check the values, but of course that may be to simple for you to figure out.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
loop cant help because, may be I'm missing something
for i=0 to array.length-1
if array(0) = 1 then
check = true
else
check = false
end if
next
this doent work for me because if the last element is 1 then the check(boolean variable)becomes true while it is possible that other elements for example first one is not equal to 1. but I need to make sure are all of them (all elements) are equal to 1 or not.
Help please
|
|
|
|
|
golisarmi wrote: may be I'm missing something
Yes, you are. This is a good exercise to weed out the pretenders from the performers. Which are you?
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
are you here to help people, specially beginners or to blame them. if you don’t know or don't want to say please don’t annoy them.
Anybody else could help?
|
|
|
|
|
We are here to help, not give you everything. This is a very simple exercise in logic, don't get upset if you are not up to the task.
golisarmi wrote: or to blame them
Read the previous posts carefully, there is no blame being assigned
You are still new here so I would hold the attitude if I where you.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
You should probably encapsulate this into a function and return false for the first one that does not match and return true if you get to the end of the array without finding one that does not match.
Incidentally, if you are using .NET 3.5, the built in All extension method from LINQ will do just that.
|
|
|
|
|
Gideon
Thanks for response.
|
|
|
|
|
check=true
for i=0 to array.length-1
if array(0) <> 1 then
check = false
exit for
end if
next
|
|
|
|
|
I think this should work. If it doesn't, reply me back..
for i=0 to array.length-1
if array(i) = 1 then
check = true
else
check = false
end if
nextsuchitamanandhar@hotmail.com
|
|
|
|
|
Morning CPians, dig me out here
I need to send an E-mail from my app through the default E-mail setup on a client system. (invoices and order confirmations, exciting stuff)
I have learned through some Googles that MAPI used to do this (no I haven't tried, it looks pretty old), then MAPI was replaced by System.Web.Mail, which has now been replaced by System.Net.Mail. Great, BUT, these .NET replacements both need to be told the E-mail server's address and/or domain, which my users will definitely not know.
The Outlook automation assemblies look like an easy option, but I'd just as soon not limit myself to Outlook, or move outside .NET
Is there some way to have System.Net.Mail just send the mail through whatever default E-mail settings exist on a user's machine?
Perhaps I can look up the E-mail settings somewhere? Magically impersonate the user?
Ideas? Guidance?
|
|
|
|
|
Hi,
I use MailMessage, MailAddress, and SmtpClient classes, and keep some strings as settings, including the mail server name (which SmtpClient constructor needs).
I know of no way to solve it without settings for all possible situations.
|
|
|
|
|
If you need it to actually display the message in the users default email client (like Outlook, Live Mail, etc.) you can use some interop to MAPI, but you need to be very careful about resource leaks. Keep in mind that this isn't officially supported and is actually not recommended, but I think as long as you are careful and only use it to open a mail message it's safe.
Otherwise, you can use the built-in .NET classes but you will need to ask the user for the email server. You can save that information as a setting somewhere so you only need to ask for it once, but there isn't a way (as far as I know) to automatically get that information.Scott Dorman Microsoft® MVP - Visual C# | MCPD
President - Tampa Bay IASA
[ Blog][ Articles][ Forum Guidelines]
Hey, hey, hey. Don't be mean. We don't have to be mean because, remember, no matter where you go, there you are. - Buckaroo Banzai
|
|
|
|
|
Hrmph.
Thanks very much both of you, I suspected as much.
Cheers!
-Jack
|
|
|
|
|
Hi
I am facing one proble with DataAdapter.
Problem is I have multiple rows in my DataTable and i am going to save it.
I have set DataAdapter 's 'ContinueUpdateOnError' property to true
so that i can continue on to next row.
I have 6 rows and i get some check constraint error from DataBase on my 4th row.
and i have called whole operation through .Net TransactionScope Class.
because of error i will call Dispose method of TransactionScope Object.
so actually no row will be saved.
but what happened , the next 2 rows after 4th row , that is 5th and 6th rows got saved in DataBase !!!!!!! ????????????
strange .........
please
if you have some idea reply me.
Thank you.
you can see my code
..
..
..
..
DataAdapter daWOStdVal = new DataAdapter();
..
..
daWOStdVal.ContinueUpdateOnError = true;
daWOStdVal.RowUpdated += new SqlRowUpdatedEventHandler(OnWOStdValRowChng);
daWOStdVal.Update(dtSCStdVal);
..
..
..
Regards
Gaurav Teli
|
|
|
|
|
Why would you set ContinueUpdateOnError to true if you don't want it to continue updates on error? Rather than call dispose why wouldn't you just set a flag to call rollback when you are done processing rows? It seems you are doing everything you can to make sure it isn't a real transaction.
|
|
|
|
|
Dear All:
I installed VS 2008.NET in my computer which is Win7 System. I tried to find the .NET configuration tool snap-in but I couldn't find either the mscorcfg.msc or the administrative tool from the start menu and control panel.
I read the article on the MSDN website but none of the method mentioned there solves the problem.
Most importantly, it seems that the file mscorcfg.msc is not installed on my computer.
Besides, I tried to install the framework SDK 2.0 but it doesn't solve the problem
Could anyone point me how to find the configuration tool please?
ThanksAsura
|
|
|
|
|
SDK 2.0 is the way to go.
There is an updated article on MSDN[^] for .Net 3.5 which is what you will have.
Hope this helps.
|
|
|
|
|
Hello,
I would like to ask if how do allow 2 input only in a textbox
after entering decimal.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
