I have an HTML table having n rows and each rows contain one radiobutton in the Row.Using jQuery , How can i look thru these radio buttons to check which one is checked ?
I have created a a bufferedImage of 6 tiles of 2 rows and 3 columns and i want to rotate the last tile of the second row. This tile serves as a crossing for my animation.
My problems are :
How can i get access to that specifc tile alone and rotate it alone without affecting others.
I have googled for a while but no answer.
I have the following query
SELECT *
FROM attend
RIGHT OUTER JOIN noattend ON attend.date = noattend.date2
WHERE attend.date
BETWEEN '2010-02-01'
AND '2010-04-01'
AND attend.customerid =1
ORDER BY date DESC
LIMIT 0 , 30
Attend is the table with customerid
noattend is the table with a row for each date (date2) I followed the advice in other questions to right outer join it to create values where there is no record in attend but it still isn't filling in the empties
any help much appreciated
Hi,
In many cases, it could be useful to know the number of a row in a table (a kind) in a datastore using Google Application Engine. There is not clear and fast solution . At least I have not found one.. Have you?
Hi,
i have two tables
Order(id, date, note)
and
Delivery(Id, Note, Date)
I want to create a trigger that updates the date in Delivery when the date is updated in Order.
I was thinking to do something like
CREATE OR REPLACE TRIGGER your_trigger_name
BEFORE UPDATE
ON Order
DECLARE
BEGIN
UPDATE Delivery set date = ??? where id = ???
END;
How do I get the date and row id?
thanks
We have a MySQL database and would like to have row-level security implemented at the database level. I have been playing with the Veil plug-in for PostgreSQL and like what it does. Is there something similar for MySQL so we do not have to convert over to PostgreSQL?
Hi guys, I've got this table
CREATE TABLE `subevents` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(150) DEFAULT NULL,
`content` text,
`class` tinyint(4) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM
Each row can have a different value in the 'class' field.
I'd like to select any number of rows, ordered randomly, as long as the sum of the values in the 'class' field is equal to 100.
How could I accomplish it directly in the MySQL query without doing it later in PHP?
Thanks everybody!
hii..I want to edit single row.i used
$this-data = $this-BuildingProperty-read(null,$id);
but it didnt fetch the values of this id.
so what can i do. Give me any suggestion.
Hi, how can I remove specific rows and columns from an excel file using only classic ASP? For example, given the excel file
col1 col2 col3
one two three
four five six
I want to be able to programmatically delete the first row and second column to produce
one three
four six
Thanks!
Is there an ability to import fixed width file to oracle?
Preferably through .net(c#) for catching errors during import and showing them to user.
P.S. File has 5 types of rows. For example 1 row has 5 columns, 2-nd has 50 columns.
i have a datagrid. which display some values which is already inserted and that is fetched from database.but from the datagrid i need to insert the values to database. how to find in which row a new record get inserted and to pass all the values to database
any idea???
Hi,
I'm trying out Zend Studio trial and I have a few things on my mind related to PhpDoc.
If I have the following code:
public function sum($a, $b)
{
echo $a + $b;
}
and then I start typing /** in the front of the function and press Enter, Zend Studio automatically makes the following text:
/**
* [cursor]
* @param unknown_type $a
* @param unknown_type $b
*/
However, I want to customize this so that it also includes @return void automatically since there's no return inside the function. Is there a way to do this? And what about things like @access? It's obviously "public".
Another thing I want is that when I create a new file and I use the code templates with ${user}, it will use my Windows account, but I want it to use something else - is there a way to specify this "user"?
Can a trigger for a table can be applied for tracking in same table?
That is IF I have table Say "employee" Now can i create a triggers such that it tracks the change in the same "employee" table
trigger such as
create trigger "<triggers_name>" before insert on employee
For each row
Begin
insert into employee field = timestamp;
end
I am new to iphone development.I parsing a url and displayed its content in the table.On clicking a row it plays a video.When i click a done button, i once again call the tableview.When i call the table view it parse the url once again to display the contents .I want to limit the parsing for 1 time and for the next time i want to display the contents which are parsed at the first time.How can i achieve it ?Please help me out.Thanks.
I don't know the best way to title this question but am trying to accomplish the following goal:
When a client logs into their profile, they are presented with a link to download data from an existing database in CSV format. The process works, however, I would like for this data to be 'fresh' each time they click the link so my plan was - once a user has clicked the link and downloaded the CSV file, the database table would 'erase' all of its data and start fresh (be empty) until the next set of data populated it.
My EXISTING CSV creation code:
<?php
$host = 'localhost';
$user = 'username';
$pass = 'password';
$db = 'database';
$table = 'tablename';
$file = 'export';
$link = mysql_connect($host, $user, $pass) or die("Can not connect." . mysql_error());
mysql_select_db($db) or die("Can not connect.");
$result = mysql_query("SHOW COLUMNS FROM ".$table."");
$i = 0;
if (mysql_num_rows($result) > 0) {
while ($row = mysql_fetch_assoc($result)) {
$csv_output .= $row['Field'].", ";
$i++;
}
}
$csv_output .= "\n";
$values = mysql_query("SELECT * FROM ".$table."");
while ($rowr = mysql_fetch_row($values)) {
for ($j=0;$j<$i;$j++) {
$csv_output .= '"'.$rowr[$j].'",';
}
$csv_output .= "\n";
}
$filename = $file."_".date("Y-m-d",time());
header("Content-type: application/vnd.ms-excel");
header("Content-disposition: csv" . date("Y-m-d") . ".csv");
header( "Content-disposition: filename=".$filename.".csv");
print $csv_output;
exit;
?>
any ideas?
I have a set of data in a matrix which I would like to display in my iPhone app with all of the rows and columns intact. Everything I can find on the web dealing with "tables iPhone" gives me information on UITableView, which only lets you show a list of items to the user - not an actual table in the HTML sense. What's the best way on the iPhone to display an actual table of data to the user, with column & row headings and table cells?
I have a script that retrieves a file via SFTP, in some cases (hard to reproduce) the file arrives with only the 5 first characters of each row. Example:
<?xml
<resu
</res
Instead of :
<?xml version="1.0"?>
<results>
</results>
What can cause such behaviour?
I've an h:dataTable to display my item information (in my case a customer support request) and for each row I'd like to put an h:inputText and h:commandButton to add a comment to the desired item. I've no problem with action, but my question is about the correct way to manage many h:inputText and related value on backbean.
I'm not sure that is correct to make all h:inputText set the value to the same backbean property. Any suggestions? Thanks all.
I need to store a 30 letter combination, but each letter can only be "0", "1" or "2". When I use sizeof(myString), it returns 32.
I want to use this 30 letter combination to access a row of an array, so I'm wondering if it is possible to use a 3 value bool of some sort to store 1 of 3 values in.
Hi..
Can any one tell me how to set the item to be selected forcefully..
I tried this after adding items to list row..
QModelIndex index = mylistview->currentIndex();
mylistview ->setCurrentIndex(index);
its not working.. index I am getting index (-1,-1)..
can any one help me on this
Thanks
i want to delete a row and cascade all foreign keys in hibernate
i am new to hibernate
and i want to know
if there's a method to delete an entity session.delete();
like the session.save and session.update methods in hibernate?
Hi there,
I need to make a program that writes some data to an excel spreadsheet. Something basic along the lines of First name, last name, phone number, e-mail per row with each category in its own column.
I don't even know where to start. If someone could tell me which assemblies to reference and maybe point me to a website or a book that covers writing/reading data from an excel spreadsheet via a c# program that would be great.
Many thanks.
HI,
i have a table,
new_id----old_id----created_on
1234------5678------20100912
5678------3456------20100808
etc.
i wrote this query,
$q = "select event1.new_id, event1.old_id, event1.created_on,event2.new_id, event2.old_id, event2.created_on
FROM replaced_isbns event1
JOIN replaced_isbns event2
ON event2.new_id = event1.old_id
WHERE event1.new_id='$id'";
but i get result as
5678 - 1234, ie only one row, i want all rows...
plz help me.
Thanks,
SLC
I am trying to deserialize a field:
"presenters":[{...},{...}]
but some of the rows come back with only:
"presenters":""
When the serializer gets to the row with that empty string I get:
Error converting value "" to type 'System.Collections.Generic.List`1[DataPrototype.Model.Presenter]'.
Am I right in thinking that I need a JsonConverter that will change the empty string into an empty List?
Hi ,
How to test procedures with record type parameters.I have a procedure which takes test_ap ,basic and user_name as inputs.where test_ap is of record/row type,basic record array type and user_name charater varying.
I need to test the procedure in pgadmin.
test_client(test_ap test_base, basic test_base_detail[], user_name character varying)
Any suggestions plz.