i am building a simple PM for my personal website where a user can join and send message to the registered users on my website,
i am stuck in grouping and selecting latest user (by latest msg time) in INBOX page
my table :
id msg_from msg_to msg date in_del out_del
i want to show latest user's id each in a group
here is my SQL query :
SELECT ttalk.id, ttalk.msg_from, users.first_name, users.last_name
FROM ttalk
INNER JOIN users ON ttalk.msg_from = users.id
WHERE ttalk.msg_to = '$_SESSION[user_id]' AND ttalk.in_del='0'
GROUP BY ttalk.msg_from DESC LIMIT 500
Thanks in advance :-)
i have a validationSummary in my page. i want to call a javascript function after the validationSummary is filled. how can i achieve this?
i think i should add an attribute in the code behind, but i can't figure out what is the attribute's key.
any help?
Do I need a infinite key with fbml facebook app that resides on fanpage?
I am asking user to select user and posting it(facebook posts) to my server. On my server I want to get user_id and selected friends Id. Everything is fine with selected friend_ids, but have issues with getting id of a user. sometimes I can get it all fine, sometimes I am getting session expired exception, sometimes I get nothing.
any ideas why this is happening?
I would like to call a method passing a parameter every 20 seconds,
e.g.
public void ProcessPerson(IPerson person)
I’ve been reading through the different Timer options and was wondering if anybody could recommend the most efficient way to do this?
Thank you for your help.
hi.
I have a multiple file upload form(html5) and want to update my view as soon one of the images is transfered to my image server.
Currently I upload the files with ajax and use response_to_parent to update my upload view when all images are transfered to the image server.
Is it possible to call a Javascript function from the controller more than once per action?
def upload
params[:images].each do |file|
upload_to_image_server(file)
#page << Update upload View
end
end
Thanks,
Michael
I feel like there should be a simple way to do this but I can't figure it out. I have a JFileChooser that allows the user to select directories. I want to show all the files in the directories to give the user some context, but only directories should be accepted as selections (maybe the Open button would be disabled when a file is selected). Is there an easy way of doing this?
Hi,
I often cross this kind of code transformation (or even mathematical transformation)
(python example, but applies to any language)
I've go a function
def f(x):
return x
I use it into another one.
def g(x):
return f(x)*f(x)
print g(2)
leads to 4
But I want to remove the functional dependency, and I change the function g into
def g(f):
return f*f
print g( f(2) )
leads to 4 too
How do you call this kind of transformation, locally turning a function into a scalar ?
I have two classes: Cat and DomesticCat, that extends Cat.
I want to select all Cats, but no oneDomesticCat. How to do it using NHibernate criteria API?
i am connecting to a mysql database through excel using odbc
what does this line do?
Set rs = oConn.Execute("SELECT @@identity", , adCmdText)
i am having trouble updating the database:
With rs
.AddNew ' create a new record
' add values to each field in the record
.Fields("datapath") = dpath
.Fields("analysistime") = atime
.Fields("reporttime") = rtime
.Fields("lastcalib") = lcalib
.Fields("analystname") = aname
.Fields("reportname") = rname
.Fields("batchstate") = "bstate"
.Fields("instrument") = "NA"
.Update ' stores the new record
End With
it is ONLY updating .Fields("instrument") = "NA", but for all other fields it is putting NULL values
I wonder if this is possible with straight SQL on MySQL. I need to do SELECT COUNT(*) FROM on each table in the database and output results in one result set.
Is it possible to do with just SQL?
I'm having issues with my JQuery Ajax Call. The response is always null because the callback function is executed before the request to get_friends is completed. Is there anything I'm missing? Thanks in advance.
$('#btn_update').click(function() {
url = '/get_friends/';
$.get(url, {}, function(response){
alert(response);
});
});
Hi all,,,
I am trying to do a small thing, any 1 help me, I really appricciate...
I have a drop down menu,I want when I select the value, it will call the related data, which I am access with php+mysql, I dont want to jump to other page and show
I am trying to write a query to select all records from users table where User_DateCreated (datetime field) is = 3 months from today.
Any ideas? Thanks!
How would one go about converting this into a UDF? I'll pass the product_id to the UDF.
Running SQL 2k5
SELECT
sum(qty) as qty,
product_id
FROM vProductQuantity
WHERE
product_id = @product_id
GROUP BY product_id
work on vs05 asp.net .....My gridview have 10 rows .After select a gridview row ,my browser scroll up on gridview header ......i want scroll don't move....how to set scroll fixed on selected row
Hi,
Is this possible, can a trigger in mysql can do a select first and then based on its result do a delete?, both on the same table.
Am struggling to get it right.
There are duplicate entries in a table, i need to have a trigger which selects and then deletes.
Any ideas or thoughts will be really helpful.
hei guys
i want to select two divs with the same id in jquery. how do i do it?
i tried this and it did not work
jQuery('#xx').each(function(ind,obj){
//do stuff;
});
i have jquery countdown timers in a page, and i update them via ajax. some of these countdown timers repeat and that is why i need to use the same id on the divs.
consider a tale is as follows,
EmployeeId | Name | Phone_Number
Now, i insert 10 records... When i query them back, select * from myTable they are not selected in the order i inserted. I can obviously keep an autoincrement index and ORDER BY index. But i dont want to alter the table. How can i do this without altering the table?
Say I have a dataframe df with two or more columns, is there an easy way to use unique() or other R function to create a subset of unique combinations of two or more columns?
I know I can use sqldf() and write an easy "SELECT DISTINCT var1, var2, ... varN" query, but I am looking for an R way of doing this.
It occurred to me to try ftable coerced to a dataframe and use the field names, but I also get the cross tabulations of combinations that don't exist in the dataset:
uniques <-
as.data.frame(ftable(df$var1,
df$var2))
Hi all,
Assume I have the following style table, col1 col2 and col3 have same value scopes, I want to select the records when two of the 3 columns have a value combination such as ('ab' and 'bc'), in the following example, the first 3 records should be selected. Any good way to do this? I am using Sybase.
| id | col1 | col2 | col3 |
1 ab bc null
2 null ab bc
3 ab ab bc
4 de ab xy
Thanks.