hi,
i am using php/mysql.
i have a product table .
in which most product have starting name with number.
i want to listout all products start with any number.
any one have idea about it....
Hi everyone,
I want to crate new table for each new user on the web site and I assume that there will be many users, I am sure that search performance will be good, but what is with maintenance??
It is MySQL which has no limit in number of tables.
Thanks a lot.
I am trying to get the value of a cell in a table view but it won't let me. If someone could help that would be great.
int numberOfChecks = -1;
numberOfChecks = numberOfChecks +1;
if ([objectsForTable count]-1 >= numberOfChecks) {
UITableViewCell *cell = [self.tableView cellForRowAtIndexPath:numberOfChecks];
NSString *cellTitle = cell.textLabel.text;
}
I am getting data from a query and processing it using Javascript in the xaction file.
Now I want to pass the processed data (a 2D array) down to a prpt where it will be used to generate graph and table.
What is the format in which Javascript would generate the data and how is it passed to and received by the prpt file from the xaction.
Thanks...
I have 'Service' table and the following column description as below
Is User Verification Required for service ?
Is User's Email Activation Required for the service ?
Is User's Mobile Activation required for the service ?
I Hesitate in naming these columns as below
IsVerificationRequired
IsEmailActivationRequired
IsMobileActivationRequired
or
RequireVerification
RequireEmailActivation
RequireMobileActivation
I can't determined which way is the best .So, Is one of the above suggested name is the best or is there other better ones ?
I have 2 lists in my program one that store objects of type student and another one which stores objects of type marks.
I have 3 methods one that inputs the details of the students, one that inputs the marks and one to view student details and their marks. My question is how I can use a hash table to get the Id of a student and then use it to input the marks and then how to retrieve both the student details and their marks altogether.
Please help me if you can.
We had a process that crashed while trying to manipulate an expected mysql record set, running the offending query from the mysql cli showed the following.
mysql SELECT ...;
ERROR 1030: Got error 127 from table handler
Is there a way to easily recreate this condition so we can validate our fix ? (production DB was already repaired).
How can I change the Default Size of the filterBy text box in Rich Table? In all the columns, it has a same (fix) size.
I used the property width, but it didn't work.
I am having a hard time understanding how to change the width of columns when creating a table view.
I know you can set the width in pixels of a column but that is not what I want to do.
Say, for instance, I have 2 columns and want each column to take up half the screen. How do I do this without explicitly setting the pixels, so that my code can work on multiple screen sizes?
I was trying to run the following query
UPDATE blog_post SET `thumbnail_present`=0, `thumbnail_size`=0, `thumbnail_data`=''
WHERE `blog_post` NOT IN (
SELECT `blog_post`
FROM blog_post
ORDER BY `blog_post` DESC
LIMIT 10)
But Mysql doesn't allow 'LIMIT' in an 'IN' subquery.
I think I can make a select to count the table rows and then make an ordered update limited by 'COUNT - 10', but I was wondering if there is a better way.
Thanks in advance.
hey guys,
a curl function returns a string $widget that contains regular html - two divs where the first div holds a table with various values inside of <td>'s.
i wonder what's the easiest and best way for me to extract only all the values inside of the <td>'s so i have blank values without the remaining html.
any idea what the pattern for the preg_match should look like?
thank you.
My table looks like this with duplicates in col1
col1, col2, col3, col4
1, 1, 0, a
1, 2, 1, a
1, 3, 1, a
2, 4, 1, b
3, 5, 0, c
I want to select distinct col1 with max (col3) and min(col2);
so result set will be:
col1, col2, col3, col4
1, 2, 1, a
2, 4, 1, b
3, 5, 0, c
I have a solution but looking for best ideas?
Hi All,
Is there some way to backup the data in a table in sql server by using sql scripts. Note: I dont want to take the backup of the whole database.
And later on restore the same data back in case of any failure.
Please suggest some solution.
Iam quite new to functions in SQL and I would like to create a function to compare values in a MySQL table against previous and I am not sure how to do this.
For example (iId is the input value)
DECLARE pVal INT(20);
DECLARE val INT(20);
SELECT price INTO pVal FROM products WHERE Id=iId;
SELECT price FROM products;
IF price == pVal THEN
SET val = price;
END IF;
Thanks
On the Members table are columns "MemberID" and "PointsEarned".
I want to update the PointsEarned column from the result of this query:
SELECT m.MemberID, m.UserName,
( (SELECT COUNT(*) FROM EventsLog as e WHERE e.MemberID=m.MemberID AND e.EventsTypeID=2)*10 ) +
( (SELECT COUNT(*) FROM EventsLog as e WHERE e.MemberID=m.MemberID AND e.EventsTypeID=3)*3 ) +
( (SELECT COUNT(*) FROM ChatMessages as c WHERE c.MemberID=m.MemberID)*.1 )
as PointsEarned
FROM Members as m
Can anybody tell me how I should do it with a single query?
Thanks!
hello i have a issue and i want your help i have a table which is called citylink[10][2]
and i want to make a check before i move on in my code if it's full to continue if it's not to break!!i know that i should use an if loop but i don't know what to put inside it!!
Hi,
I have two tables like of this structure
content (content_id, content_type, user_id, time, comment_count)
comments (comment_id, content_id, userid, comment, comment_time)
What I wold like to do is update the comments_count field with sum of comments i.e COUNT(content_id) from the comments table.
I am not able to figure out the right syntax
Thanks
I try to draw a table on a panel in C# Windows Form by using GDI+. The problem is that when I minimize the application, my drawing disappears. How can I avoid this and why acting this way?
I want to setup a table that can:
Save the data on the user's machine
Reference & present the data in the GUI
Capable of adding rows dynamically during runtime
What's the best way to go about this?
DataGridView or TableLayoutPanel or...? I'm having trouble with SQL server CE, as I was going to connect it with the DataGridView, but I'm very new to this kind of work, and wondered if it was even necessary to use SQL.
IN my table there are two field one is name and other is gender I want to fire query so that
every male is update with female and vice a versa.
I don't want to use procedure ,trigger or function.I have to do this only with simple query.
Hey all
i am working at my project where it collects information from two database, one is supplied by the program lets name it DB Y and the other supplied by the user lets name it DB X , now i have an query that depends on companies which is on DB x so i want to transfer this table from DB x to DB y at run time and also checks if there is new updates in DB x and transfer them but i am confused
I'm usig tablesorter jQuery to parse this xml file
<?xml version="1.0" encoding="iso-8859-1"?>
<CATALOG>
<CD>
<TITLE>Title 01</TITLE>
<ARTIST>Artist 01</ARTIST>
<COUNTRY>Country 01</COUNTRY>
<PRICE>10.00</PRICE>
<YEAR>2010</YEAR>
<INFO>Tooltip Info 01</INFO>
</CD>
<CD>
<TITLE>Title 02</TITLE>
<ARTIST>Artist 02</ARTIST>
<COUNTRY>Country 02</COUNTRY>
<PRICE>9.00</PRICE>
<YEAR>2009</YEAR>
<INFO>Tooltip Info 02</INFO>
</CD>
<CD>
<TITLE>Title 03</TITLE>
<ARTIST>Artist 03</ARTIST>
<COUNTRY>Country 03/COUNTRY>
<PRICE>8.00</PRICE>
<YEAR>2008</YEAR>
<INFO>Tooltip Info 03</INFO>
</CD>
</CATALOG>
and with this code
<script type="text/javascript">
$(document).ready(function(){
$.ajax({
type: "GET",
url: "file.xml",
dataType: "xml",
success: function(xml){
$(xml).find("CD").each(function(){
$("#tablebody").append('<tr><td>'
+ $(this).find("TITLE").text()
+ '</td><td>'+ $(this).find("ARTIST").text()
+ '</td><td>'+ $(this).find("COUNTRY").text()
+ '</td><td>'+ $(this).find("PRICE").text()
+ '</td><td>'+ $(this).find("YEAR").text()
+ '</td></tr>');
});
}
});
});
</script>
I'm new at javascript and have been trying with no luck for a couple of hrs to get the text from the INFO/INFO tags in the xml file to show as title attributes for each table row. The reason for that is that I need to have individual popup tooltips on mouse-over each table row.
Many Thanks in advance for any kind of help or suggestions!
I'm having a table and i have a row which is initially set to the display property of 'none'
and i changing it to 'block' at some selection of value from my select box , at that point of time the row is not aligned properly. My two columns are set inside a single column of the above row?
but when i change it again to 'none' all the other rows are aligned correctly..
I have a table row that has the error message in it.
...
Now if someone forgets to enter text or bad text in a textbox, I want this form field to be set to visible.
Can I use a asp.net validator for this or?
If I have a Parent and Child table in MySQL related by a foreign key, is it possible using a SQL statement to move certain rows from Parent and the related rows from Child into archive tables (e.g. Parent_Archive and Child_Archive) in an atomic manner?