Hi all
This is my Query
[code=sql]
select m1.msgid as readstatus,Mess age.msgid,msgre cdate as sentdate,msgsub ject as subject,message ,
userdetails.nam e as sender
from message
inner join userdetails on userdetails.id = Message.msgfrom usrid
left outer join (select distinct messagelog.msgi d from messagelog
inner join message on
messagelog.msgi d=message.msgid ) m1 on
m1.msgid=messag e.msgid...
kavi2012
Last Activity: Oct 15 '07, 08:01 AM
Joined: Sep 11 '07
Location:
-
Problem in Select Query
-
Urgent: Multilanguage Support in Datagridview
Hi all
I want to display the text in a datagridview supporting all the languages like English, Hindi, Tamil,..etc using Globalization.
Please help me how to implement this in .NET 2.0 windows Application
Thanks -
About Visual Source Safe for .NET
Hi Everybody
I am new to the Visual Source Safe (VSS). I want to know why we need VSS and what are all the advantages of using this.
please send me the details about this.
Thanks
Kavitha -
thank you for your fast reply. It is working fine.. -
Top Value in a Table
Hi all
I need to get a 2'nd top Salary from the table Employee. I don't know how to write a query for this in postgresql. Could you please help me out to write.
I tried in MSSQL. It is working fine.
select top 3 salary from employee
But it is not working in Postgre. What is the equivalent for Top in postgre.
Thanks
Kavitha -
hi amitpatel
will u please give me an example of how to use date_trunc i can't understand. Please help me.
thanks
kavitha....Leave a comment:
-
hi amitpatel,
First query is working when i give 21 aug instead of 20 aug. Its ok but my need is that i want to get the result when i give either exact from date or to date.
ie., if i give between 20-aug-2006 and 21-aug-2007 i have to get the result having these two dates ie., my result retrieve rows having both 20-aug-06 as well as 21-aug-07 dates. for that what i have to do. Please try to solve this.
Then ,In...Leave a comment:
-
hi amitpatel
I tried both the above queries but when i use this query
[code=oracle]
select id,name, to_char(dob,'mm/dd/yyyy') as dob from Employee
where dob BETWEEN '20-AUG-2006' AND '20-AUG-2007'
[/code]
records are not retrieving..... .
and for the next query
[code=oracle]
select id,name, to_char(dob,'mm/dd/yyyy') as dob from Employee
where (trunc(dob)...Leave a comment:
-
how to Disable cut,Copy & Paste Event in the Text Box using Javascript
Hi
I used the following function to disable the cut, Copy & paste in the Textbox.
It works fine for me when I use ctrl+C,ctrl+X & ctrl+V.
function disable(e)
{
if(event.ctrlKe y)
{
event.returnVal ue = false;
}
}
But when I use (alt E+P), It is allowing to paste the data in a textbox.
It is not working for the alt+key Combination.... -
Problem: Retrieving Records based on the From & To Date
Hi All
I want to Retrieve Records from the table based on the DOB. All the Dateformat in mm/dd/yyyy. I am using PostGreSql 8.2
Table: Employee
-------------------------
id Bigserial
name Character Varying
DOB TimeStamp without Timezone
Normal Select Query
-------------------------------
[code=sql]
select id,name,to_char (dob,'mm/dd/yyyy hh:mi:ss')... -
Thanks for your reply.
I don't know the syntax for writing Stored Procedure and Triggers.
Send me some samples for writing this.
thanks
Kavitha...Leave a comment:
-
PostgreSql Documents
Hi all
I want to know how to write a Stored Procedure and triggers in PostgreSql.
If anybody know please send me..
Thanks
Kavitha
No activity results to display
Leave a comment: