|
Hi,
I am developing an application. i have 3 main tables in mysql database . tables are
table1 : products (1000 rows)
table2 : parts
table3 : products_parts (M:N relationship) contains over 40,000 rows with parts that can work with upto 1000 products.
I need to select all products that have no specific part assigned. I tried a left join
"select cols from products left join parts on products.id = products_parts.productid where partid!=3 and products_parts.productid is null"
The statement is correct to my knowledge but because of too much data in relationship table, fatal timeout exception is thrown. i also tried using not in and not exists... Again statements are correct but i get fatal exception. I say statements are correct because they work with small tables...
How will i get around this issue. For left join i would bring into consideration that product1 can work with part1,2,3 . At same time product2 can work with part 1,2 so with left join even if i say select products that doesn't work with part1 , i will get product 1 because association is with part3 this time... ( i don't know whether this was useful or not)
Actually , i want an exact inverse of inner join (not using left join coz too much data throws fatal exception, not in and not exists also not working...)
Is there any special command?
Please provide help in this regard (i am using Asp.net with mysql)
Thanks
|
|
|
|
|
If you are sure your sql is correct (and it does look OK to me) and your problem is actually the query timing out, how about either increase the query timeout (not sure how on MYSQL, but its probably part of the connection properties) or, better still, have a look at the indices. The table sizes your quote are very small, I would expect any database system to handle this volume of data with ease, but not if you are missing indices for your joins and there are tablescans going on.
Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP
|
|
|
|
|
Thanks for replying.
I used nested select statements and it worked. Left join wasn't returning proper rows because it was a many to many relationship table so product existed a number of times.
|
|
|
|
|
Hello,
I have a CGI script (written in C) which performs some fairly lengthy operations and I would like to display a page saying something like "Please wait while we process your request..." while the script executes.
If possible I would also like to display temporary results as the script runs (but this isn't that important).
Does anyone know how to do this using CGI?
Thanks,
Sylvain
|
|
|
|
|
Hello All.
I'm trying to take the index of one dropdownList, and force the other DropDown list to be equal to the first (in terms of selectedIndex and item selected)
I can successfully retrieve the index of the first dropdown by using:
<pre> var ddIndex1 = document.getElementById('mylist1').selectedIndex; </pre>
I have tried to assign the 2nd by doing the following:
<pre>document.getElementById('mylist2').selectedIndex = ddIndex1;</pre>
I then do:
<pre> alert(document.getElementById('mylist2').selectedIndex) </pre> and I can see that the index has been modifed however, when I view my page, it still displays 'Select One' which is at Index0. 
Any ideas?
-Here is how the Drop Downs are generated-
<pre>
// GENERATE DROP DOWN BOXES
function _generateDropDown(oname,bname,btype,bfield,bvalue,allOptions,numOptions){
this.o_name=oname;this.m_name=bname;this.m_type=btype;
this.m_field=bfield;this.m_value=bvalue;
this.m_allOptions=allOptions;this.m_numOptions=numOptions;
var x = "";
var myString = new String(allOptions);
var myOptions= new Array(numOptions);
var z=myString.length;
var y=0;
var currCharIndex=0;
myOptions[0]='';
try{
// PUT ALL OPTIONS FOR THIS DROP DOWN INTO AN ARRAY
for(i=currCharIndex; i<z; i++){
if (myString.charAt(i) != ";"){
myOptions[y]=myOptions[y] + myString.charAt(i);
this.m_value=myOptions[y];
}
else if (myString.charAt(i) == ";"){
y++;
currCharIndex=i;
myOptions[y]='';
}
}
//WHEN A DATE IS SELECTED
if (parent.dateIndex != -1){
complete_rs.movefirst;
var x = new String(complete_rs(bfield));
if (x == "null" || x == "undefined" || x == "Select One"){
x = "";
}
}
//WHEN NO DATE IS SELECTED
else if (parent.dateIndex == -1){
x = "";
}
if (this.m_name != "selectDate"){
document.writeln("<select name=",this.m_name," onChange=",this.o_name,".updateDB(value)><br />");
document.writeln("<option value=\"Select One\">Select One</option>");
for(i=0; i<this.m_numOptions; i++){
if (myOptions[i]==x){
this.m_selected="selected";
}
else{
this.m_selected="";
}
document.writeln("<option value=\"",myOptions[i], "\" ", this.m_selected,">",myOptions[i],"</option>");
}
}
document.writeln("</select>");
}//END TRY
catch(E){
//alert("generateDropDown()"+ E);
}//END CATCH
}
</pre>
and here are my attempts, all which do not modify the drop down to change.
(ps. the value of the dropdown is added to the database afterwards)
<pre>
var index1 = document.getElementById('mylist1').selectedIndex;
//this updates the index, however fails to change what is display in the dropdown list
document.getElementById('mylist1').selectedIndex = index1;
//this updates the index, however fails to change what is display in the dropdown list
document.getElementById('mylist1').options[index].value = index1;
//this updates the index, however fails to change what is display in the dropdown list
var tempDDL = document.getElementById('mylist1');
tempDLL.selectedIndex = index1;
</pre>
Any type of help or suggestions is greatly appreciated.
Cheers!!!
|
|
|
|
|
<br />
<br />
function _generateDropDown(oname,bname,btype,bfield,bvalue,allOptions,numOptions){<br />
this.o_name=oname;this.m_name=bname;this.m_type=btype;<br />
this.m_field=bfield;this.m_value=bvalue;<br />
this.m_allOptions=allOptions;this.m_numOptions=numOptions;<br />
var x = "";<br />
var myString = new String(allOptions);<br />
var myOptions= new Array(numOptions);<br />
var z=myString.length;<br />
var y=0;<br />
var currCharIndex=0;<br />
myOptions[0]='';<br />
<br />
try{<br />
for(i=currCharIndex; i<z; i++){<br />
if (myString.charAt(i) != ";"){<br />
myOptions[y]=myOptions[y] + myString.charAt(i);<br />
this.m_value=myOptions[y];<br />
}<br />
else if (myString.charAt(i) == ";"){<br />
y++;<br />
currCharIndex=i;<br />
myOptions[y]='';<br />
}<br />
}<br />
<br />
if (parent.dateIndex != -1){<br />
complete_rs.movefirst; <br />
var x = new String(complete_rs(bfield));<br />
if (x == "null" || x == "undefined" || x == "Select One"){<br />
x = "";<br />
}<br />
}<br />
else if (parent.dateIndex == -1){<br />
x = "";<br />
}<br />
<br />
if (this.m_name != "selectDate"){<br />
document.writeln("<select name=",this.m_name," onChange=",this.o_name,".updateDB(value)><br />");<br />
document.writeln("<option value=\"Select One\">Select One</option>");<br />
for(i=0; i<this.m_numOptions; i++){<br />
if (myOptions[i]==x){<br />
this.m_selected="selected";<br />
}<br />
else{<br />
this.m_selected="";<br />
}<br />
document.writeln("<option value=\"",myOptions[i], "\" ", this.m_selected,">",myOptions[i],"</option>");<br />
}<br />
}<br />
document.writeln("</select>");<br />
}
catch(E){<br />
}
}<br />
<br />
<br />
<br />
|
|
|
|
|
i m making registration form .
in that i take select tag for country.
another select tag for states .
my problem is that i am working in asp script.
when i select country india .
then i must get the states in another select tag related to country india.
from yesterday i m asking for this solution no one tell me .how to do this?
i dont know ajax. thats why i put it third time for same question.
|
|
|
|
|
So you have now asked the same question 4 times.
rajiv_kadam wrote: from yesterday i m asking for this solution no one tell me .how to do this?
You have had at least 2 answers. The first time you asked, I said
So you need to apply a filter to the content of combobox2. Without knowing anything about how it is populated or even what language you are using thats all I can tell you.
another time you were advised to use AJAX, so you complain
rajiv_kadam wrote: i dont know ajax. thats why i put it third time for same question.
Asking the same question repeatedly will NOT get any better answers. You give very little information, and when you get an answer you ignore it.
What do you want, a full blown code solution. You'll not get it. If you can't write the code, and can't be bothered to do a little research then I advise a career change - and the sooner the better.
Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP
|
|
|
|
|
hi sir,
i am using following javascript for showing and hide my div.but it's working only for internet explorer not for mozilla.
please help me and give me solution.
function showdiv(id)
{
if (document.getElementById)
{
obj = document.getElementById(id);
if (obj.style.display == "none")
{
obj.style.display = "block";
}
else
{
obj.style.display = "none";
}
}
}
|
|
|
|
|
I used the below code and it worked fine in Firefox 3.5
<html>
<head>
<script type="text/javascript">
function showdiv(id)
{
if (document.getElementById)
{
obj = document.getElementById(id);
if (obj.style.display == "none")
{
obj.style.display = "block";
}
else
{
obj.style.display = "none";
}
}
}
</script>
</head>
<body>
<div id="d1" style="display:block">EEE</div>
<input value="ttt" type=button onclick="showdiv('d1')" />
</body>
</html>
|
|
|
|
|
hi sir
thanks for suggestion
but my mozilla shows that div only on click and then that div will further hidden.but in explorer that div will remain stay after click.and for my point of view explorer is correct and i want same for mozilla.
please help me sir.
|
|
|
|
|
Hi,
Instead of using "block" can u try just giving "". Let me know if it works.
Thanks and Regards
KC
|
|
|
|
|
hi sir
i used your suggestion but there is no effect on mozilla but explorer is same as before.
please give another suggestion if u have.
thanks,
|
|
|
|
|
Are you using any specific css class for the div? If then please show it here. Also check whether you get to see the div without the help of the above javascipt. i mean to say remove style if any is added in the div which makes it hidden in the page load and see whether its appearing in Firefox on page load.
|
|
|
|
|
vikas shukla wrote: function showdiv(id)
{
if (document.getElementById)
{
obj = document.getElementById(id);
if (obj.style.display == "none")
{
obj.style.display = "block";
}
else
{
obj.style.display = "none";
}
}
}
function showdiv(id){
var obj = document.getElementById(id);
if (obj.style.display == "none"){
obj.style.display = "block";
obj.style.visibility = "visible";
} else {
obj.style.display = "none";
obj.style.visibility = "hidden";
}
}
|
|
|
|
|
in html i used select tag for country.
another select tag i used for states.
when i select country india .
then it should show me the states related to india .
which was in another select tag.
how to filter combobox using javascript?
|
|
|
|
|
use ajax for this problem.
For selected country make a server call.
Fetch the state list, and populate the dropdown with the response
|
|
|
|
|
Hi ,
My requirement is something like this.
We have pages hosted my 3rd party vendors for registration purpose.
We need to create a page in our domain to simulate the purpose what third party registration is serving.
What we have?
We have the url of the pages of the third party and know the field names to be entered. We have to invoke those pages through our code (user won't be presented with third party registration form)and pass the details and invoke the functionailty what they achieve in their page.
We dont have the option to get the registration app of 3rd party vendor as a webservice exposed. We have to simulate the user entry through that registration process in our page.
Language used: C# ASP.NET 2.0 Web development
Please let me know if you have any idea to achieve this or if you have done something similar.
Thanks in advance
KC
|
|
|
|
|
I've just taken a very simple, as the subject says, one page, web site live. It advertises two cottages that my client rents out, nothing special, in town, but I need at least a little SEO. I know I need a nice crowd of keywords in the META, and I've registered with Google, and will with Bing. I'll also sign up for listing in a few local directories/indexes as I did for her husband, which appears to have worked. The site I did for him is generating business.
Is there anything I'm overlooking, anything I can do re adding rel tags to content, images, etc. so that the bots 'hook' more that just meta and title. Anything at all I'm overlooking?
|
|
|
|
|
Hi,
A critical vulnerability "IIS 5.0 Denial of Service" has been identified in my web application by HP WebInspect tool.
we need to remediate this vulnerability ASAP.
I have checked for WebDev in IIS manager, it is disabled.
I am trying to search for best solution for this vulnerability, but still not able to search.
Please help me on this.
Thanks,
Ankur Bakliwal
|
|
|
|
|
How do I add the Notification like on facebook at the bottom page of my Project?
modified on Thursday, August 20, 2009 6:14 AM
|
|
|
|
|
Hi friends,
how can i download a wav file on clicking a HTML Download Link?...
Note: without zipping that file
Thanks in advance
|
|
|
|
|
Please clarify your question.
Do you want to create a link?
Is this what you are looking for?
<a href="yourfilename.wav">Click here to download</a>
If it's not, please post your question with more details.
Regards
tech
|
|
|
|
|
Hi msn92,
Actually, i am looking to download wav file when the link gets clicked..
In the above code, what u have sent..if i click the link, wav file starts playing instead of getting download!...By zipping wav file i can download,but that is not the required task...The aim is, i should download wav file by clicking a link..which should be done in htmlpage but not in aspx page and not by zipping wav file.......Please guide.
i will be waiting for your reply...
Thanks,,
|
|
|
|
|
<<a href="Untitled.wav">Download</a>
The code above worked in Internet Explorer (v8) and Firefox (v3.5). They both DID let me download.
I don't know why it's not working in your case. What browser are you using?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
