Go Back   CodingForums.com > Search Forums
Reload this Page Search Results

Before you post, read our: Rules & Posting Guidelines

Showing results 1 to 11 of 11
Search took 0.04 seconds. Search: Posts Made By: savannah_becket
Forum: Java and JSP 11-18-2010, 07:55 PM
Replies: 0
Views: 1,670
Posted By savannah_becket
Question Javamail: How to Search Email in Multiple Folders at Once?

Hi,
I am using Javamail api. I know how to search email in one folder, but how to search email in multiple folders at once? Like issue one search command as a global search to the email account,...
Forum: MySQL 10-27-2010, 01:19 AM
Replies: 11
Views: 2,918
Posted By savannah_becket
Question no, the values in the array is unknown ahead of...

no, the values in the array is unknown ahead of time and the values can be string too, so I cannot save the values in a permanent table.
Forum: MySQL 10-27-2010, 12:17 AM
Replies: 11
Views: 2,918
Posted By savannah_becket
Question What if my array is different each time a user...

What if my array is different each time a user visit my website? Is it still efficient to use temporary table? Would there be a problem if there are 50 concurrent users visiting with 50 temporary...
Forum: MySQL 10-26-2010, 06:12 PM
Replies: 11
Views: 2,918
Posted By savannah_becket
Question There must be a way to do it in sql. There are...

There must be a way to do it in sql. There are potentially 100k rows in the table, I can't just fetch them all and then do array_diff.
Forum: MySQL 10-26-2010, 06:11 PM
Replies: 11
Views: 2,918
Posted By savannah_becket
Question No, this will only return nothing because 1,3,5...

No, this will only return nothing because 1,3,5 are in that array. I want it to return 2 and 4.
Forum: MySQL 10-26-2010, 07:37 AM
Replies: 11
Views: 2,918
Posted By savannah_becket
Question How to select values that are not in a table?

Hi,
I have an array of values, I want to find the ones that are not in column b of the table.
e.g. my array = {1,2,3,4,5}

table:
a|b
---
x|1
y|3
z|5
Forum: MySQL 10-16-2010, 10:05 PM
Replies: 8
Views: 1,454
Posted By savannah_becket
Question Would it be good idea to use only 1 table and use...

Would it be good idea to use only 1 table and use company name and ditch the coid? Maybe yours is a better since it's faster to compare integer than string?
Forum: MySQL 10-16-2010, 09:56 PM
Replies: 8
Views: 1,454
Posted By savannah_becket
Question I already thought of what you are thinking. But...

I already thought of what you are thinking. But my worry is that this table will contain more than 50 million rows because of many client relationships for each company. If I keep it in one row per...
Forum: MySQL 10-16-2010, 05:30 PM
Replies: 8
Views: 1,454
Posted By savannah_becket
Question How to Select rows that have mutual values in their columns?

Hi,
I have a table with following columns:

company | clients
------------------------------------------------------
ibm | microsoft sun hp dell
hp | sun ibm microsoft...
Forum: MySQL 07-15-2010, 11:30 PM
Replies: 5
Views: 940
Posted By savannah_becket
Question No. My string is ijklmn. The column in table...

No. My string is ijklmn. The column in table consists of ijk. I want to know if any row in the table is the prefix of my string ijklmn. And ijklmn is not the only string in my program, all my...
Forum: MySQL 07-15-2010, 10:57 PM
Replies: 5
Views: 940
Posted By savannah_becket
Question How to Match Prefix?

Hi,
I have a table of rows of string, "abc","def","ijk", and these are prefixes. I want to see if a row exists in this table that match my string, e.g. "ijklmnopq" as prefix. So in this case ijk...
Showing results 1 to 11 of 11

 
Forum Jump

All times are GMT +1. The time now is 06:22 AM.