Posts made by icanmakeiteasy

icanmakeiteasy

function asdf() {
getScrollHeight();
var obj = document.getElementById("popup");
obj.style.display = "block";
obj.style.top = getScrollHeight();
obj.style.left = 200;
}
function getScrollHeight() {
var h = window.pageYOffset ||
document.body.scrollTop ||
document.documentElement.scrollTop;

    return h ? h : 0;
}

icanmakeiteasy

icanmakeiteasy

srry, for the late reply am using sql server 2000, plz help me to achieve this in sql server 2000

icanmakeiteasy

icanmakeiteasy

Hi, DECLARE @Location_ID INT SELECT @Location_ID = 3 ;WITH ret AS( SELECT * FROM Locations WHERE Location_ID = @Location_ID UNION ALL SELECT t.* FROM Locations t INNER JOIN ret r ON t.Parent_ID = r.Location_ID ) SELECT * FROM ret here is my query, am getting error:Incorrect syntax near the keyword 'WITH' help me to fix this problem friends

icanmakeiteasy

icanmakeiteasy

Error here Msg 156, Level 15, State 1, Line 5 Incorrect syntax near the keyword 'WITH'.

icanmakeiteasy

icanmakeiteasy

DECLARE @Location_ID INT
SELECT @Location_ID = 3

;WITH ret AS(
SELECT *
FROM Locations
WHERE Location_ID = @Location_ID
UNION ALL
SELECT t.*
FROM Locations t INNER JOIN
ret r ON t.Parent_ID = r.Location_ID
)

SELECT * FROM ret

icanmakeiteasy

icanmakeiteasy

Location_id Parent_id Location_name
29 3 Rahway, NJ (Time Zone:EST)
3 0 United States
30 29 126 E. Lincoln Avenue
5 3 North Wales, PA (Time Zone: EST)
6 3 Whitehouse Station, NJ (Time Zone: EST)
7 5 351 North Sumneytown Pike
8 7 Upper Gwynedd
31 30 Rahway
32 3 West Point, PA (Time Zone:EST)
11 6 One Merck Drive
12 11 Whitehouse Station
33 32 770 Sumneytown Pike
34 33 West Point
35 0 United Kingdom
36 0 Germany
37 36 Munich
38 37 85540 Haar
39 38 Lindenplatz 1
40 0 Japan
41 40 Tokyo
42 41 Chiyoda-ku
43 42 Kitanomaru Square
44 43 1-13-12 Kudan-kita-Room 1425-E
45 0 Singapore
46 45 #10-03/10 Parkview Square
47 46 600 North Bridge Road-188778
48 3 San Francisco, CA
49 48 Sirna-SF-314
50 0 Brazil
51 0 Italy
52 51 Rome
53 52 VIA PONTINA KM 30, 600
54 0 Canada
55 54 16711 TRANS-CANADA HIGHWAY
56 55 Montreal H9H 3L1
57 48 1700 Owens Street, 3rd Floor - 94158
58 3 Boston, MA (TimeZone:EST)
59 58 33 Avenue Louis Pasteur
60 59 Boston

question is how to get United States child location?
relation is,
United States ID is 3,
so find out all the parent_id with '3'
ex:[North Wales, PA (Time Zone: EST)] parent_id is '3' location_id is '5'
now if any location's parent_id is '5', then that is also UnitedSates children

3 0 United States
5 3 North Wales, PA (Time Zone: EST)
6 3 Whitehouse Station, NJ (Time Zone: EST)
7 5 351 North Sumneytown Pike
8 7 Upper Gwynedd

how to get all the locations under 'United Sates'

icanmakeiteasy

icanmakeiteasy

Hi friends, help me to get multiple reports i have created two crystal reports, one using 'bar chart' and second using 'pie chart', i have implemented in two different web pages, then the result is exported to two individual pdf files... now, user asking me to build the two charts in one pdf file only, in 2 pages :( how can i ?? do some needful friends...

icanmakeiteasy

icanmakeiteasy

then if the table structure is static create a script file for server1 database.., read that file from c#, then manipulate it...

icanmakeiteasy

icanmakeiteasy

hi venu, server1 database structure is static or dynamic??

icanmakeiteasy

icanmakeiteasy

Hi all, how to set Iframe height dynamically??? my html code is:

function IframeHeight(frameId){
frame = document.getElementById(frameId);
framedoc = frame.contentWindow.document;
frame.height = framedoc.body.scrollHeight + 10;
}

</script>
</head>
<body>

< iframe id='myiframe' scrolling='no' width='100%' runat='server' />

</body>

</html>

now from c#

myiframe.Attributes.Add("src", "http://www.yahoo.com");
myiframe.Attributes.Add("onload", "IframeHeight('myiframe');");

in this way i am getting "Access denied" error message why???? if i set src as my local projects page its working fine.... htlp me frnds how to set other website url as myiframe source thanks in advance

icanmakeiteasy

icanmakeiteasy

wow that's working.. thank you.....

icanmakeiteasy

icanmakeiteasy

thanks... my input file is test.txt asdf@gmail.com qwer@gmail.com zxcv@gmail.com now i want like this asdf@gmail.com ,qwer@gmail.com ,zxcv@gmail.com ???

icanmakeiteasy

icanmakeiteasy

thank you... its working and if the mails are separated by space like this test.txt asdf@gmail.com qwer@gmail.com zxcv@gmail.com now can i get them by comma separated mails... thank you

icanmakeiteasy

icanmakeiteasy

Hi friends, i have a txt file containing email id's like test.txt asdf@gmail.com qwer@gmail.com zxcv@gmail.com when user imports test.txt file i want to get the all email id's by comma seperated value... using c# asdf@gmail.com ,qwer@gmail.com ,zxcv@gmail.com .... like this how can i?? help me plzzz...

icanmakeiteasy

icanmakeiteasy

hi, how to copy the all rows of a table to temporary table using javascript i have tried like this but it's not working ex:document.getelementbyId('tmpTable')=document.getelementbyId('baseTable'); is there any way to do this..?? thanks

icanmakeiteasy

icanmakeiteasy

Hi, in my database table having different type of languages like

id uname
1 Évian-les-Bains
2 Évreux
3 Eysines
4 Île d?Aix
5 L?Isle-d?Abeau

can i get uname values in to english language using select query thanks in advance

icanmakeiteasy

icanmakeiteasy

alert(Tableid.rows[0].cells[0].firstChild.textContent); this is working

icanmakeiteasy

icanmakeiteasy

i have tried this one tooo... i did not get it

icanmakeiteasy

icanmakeiteasy

No innerHTML also not working

icanmakeiteasy

icanmakeiteasy

Hi, please help me... my javascript code is var tdValue = TableId.cells(0).innerText; it's working in IE Browser but not in other browsers like mozilla... thanks in advance

icanmakeiteasy