Hello folks ! i dont know if i am wrong here or not. but i didnt find aslike subject about Notes or IBM. Well i have a Problem with my Notes Mail Client SPAM Filter. it worked fine more than a year and suddenly since one Month My SPAM Rule in Notes Mail Client doesnt work anymore i didnt change anything. i tryied a lot of other Rule for SPAM but nothing worked. if somebody had the same Problem or an idea i will be very glad to hear for him. thanks.

ok thank you and i will be happy if you find something! On the other hand, i am thinking if we can put an HTML code inside the (HeaderText:"") Example: NAME HTML> and inside this HTML something like: do this Text Horizontaly. the Problem i am not very good in HTML and i am not sure if its exists something like that ( do Text Horizontaly) i know only we can change the Text to Bold like () or Italian like ()... ??

Thanks for replying, my GridView is in a Div with a Vertical Scroll, but i think it looks better when the user doesnt need to Scroll a long moment to see all the GridView, and my Table have a lot of columns and the best way is (if their a way like this) to put the headers Horizontally then the user dont need to scroll a lot.

hi all, how can i display a HeaderText in a GridView Horizontaly ? i know normaly it doesnt exist in .NET HeaderText Horizontaly but mabe a workaround with HTML or something. i need it horizontaly cause vertical take a lot of space in my GridView and i dont have so much. thanks in advanced

i will try to ask but anyway thanks for answering

hi all, how can i display a HeaderText in a GridView Horizontaly ? i need it horizontaly cause vertical take a lot of space in my GridView and i dont have a lot. thanks in advanced

Hi All,

var MyDataSet = (from devicesPermissions in userDevicePermissions
where devicesPermissions.Username == "MyName"
orderby devicesPermissions.IslandID, devicesPermissions.DeviceGroupsID,
devicesPermissions.DevicesID
group devicesPermissions by devicesPermissions.IslandsName).Distinct()

      foreach (var dataSet in MyDataSet)
         {
            Console.WriteLine(dataSet.Key);

            foreach (var devgro in dataSet)
            {
                Console.WriteLine(devgro.DeviceGroupsID);

                 //Till here works fine like i want.
              //\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*

                foreach (var devices in **devgro**) ////\*\*here i get an Error:
                 ///Error: foreach statement cannot operate on variables of type 'Vw\_MyView' because         'Vw\_MyView' does not contain a public definition for 'GetEnumerator'.	
                {
                    Console.WriteLine(devices.**DevicesID**);
                }
            }

concerning my Code i want that it gives me this output: Key1 --DeviceGroup1 ----Devices1 ----Devices2 ----DeviceGroup2 --DeviceGroup3 Key2 --DeviceGroup4 ----Devices3 --DeviceGroup5 ----Devices4 ----Devices5 Please Help me !

modified on Tuesday, December 16, 2008 6:11 AM

Howard wrote: If you have a LINQ to SQL class for the parent table, e.g. Customer then you can use this to obtain SELECT * FROM Inserted thus: var newData = dc.ExecuteQuery("SELECT * FROM inserted"); i tried but it throws now an SQL Exception: didnt found an Object with the name INSERTED. now i am convinced and i will make it with the native SQL. thanks

Pete O'Hanlon wrote: ...(and frankly, I didn't think it was possible to do LINQ in a trigger; you live and you learn). well must first create a new Library Project to get the Linq References and then i generated as an assembly in my Database and with my CLRSQL-Project which i create my Trigger i add this reference and make the linq Code inside. and it works.

well i think mixing it, native SQL and Linq in a Trigger maybe cost more time as only Linq or only T-SQL. do you have an idea what is 'Select * from inserted' in Linq ? Thanks for replying..

Hi, try this please maybe the syntax problem is in the Having count-->

select R.City_Nam Receiver_City,R.St_Prvnc_Cd Receiver_State,R.cntry_id Reciever_Country,
R.Postl_Cd Receiver_Postal, R.Svc_Lvl_Cd Receiver_Service_Area_Code,
U.Frst_Nam||' ' ||U.last_nam Name,
S.STR_ADDR_1 Sender_Street_Address1, S.Str_Addr_2 Sender_Street_Address2
from shpt SH
Right Outer Join shpt_addr S
on sh.shpt_id = S.shpt_id
Right Outer Join shpt_addr R
ON S.shpt_id = R.shpt_id
Right Outer Join Users U
ON SH.User_Id = U.User_Id
Right Outer Join Cust C
On S.Cust_Nbr = C.Cust_Nbr
where S.ADDR_TYP_CD = 1 and R.Addr_Typ_Cd = 2
and c.creat_dt between trunc(sysdate) and trunc(sysdate-90)
group By S.Cust_Nbr Desc
Having Count(sh.shpt_id) >= 25

Hi, what kind of Error do u get??

well Linq to SQL does support SQL-CLR cause i can create this Trigger without problem and it works fine but like i said i have two Querry after an update : 1. i s_elect * from inserted_ better said from updated and after this 2. i insert them in the other database . the first querry i do it in a T-SQL way and the other Querry in Linq and the Trigger works fine like i want, but to make the performance and the maintainability better i want to make all my Queries in Linq.

Hi All, i am new in Linq and have a problem; i have a SQLCLR Trigger and its job is to insert the query in another DB (A) after updating it in DB (B), it is like an HistoryLog DB all Updated Queries must be logged in DBHistoy. now i have a mix Code between T_SQL und Linq in my Trigger, it works fine; i get the Datas from my Updates with: 'SELECT * FROM INSERTED' and with Linq i insert them in DBHistory, but i am not happy about this, i want to have only a linq Code inside but i didnt found an equivalent to 'Select * from Inserted' into Linq. please Help ! Thanks in advance...