Re: asp.net data access thru oracle 9i client

2004-06-14 Thread BDOTNET
---

New Message on BDOTNET

---
From: swtshalu
Message 2 in Discussion

Hi,   Try giving ASP.NET user full control on the folder in which you have installed 
Oracle. Like, if it is D:\Oracle, then give full rights to ASP.NET user to it and also 
make sure that it applies to the subfolders as well.   Check out the sqlnet.ora file 
in your system. If you find something like:   SQLNET.AUTHENTICATION_SERVICES = (NTS)   
modify it to   SQLNET.AUTHENTICATION_SERVICES = (none)   HTH

---

To stop getting this e-mail, or change how often it arrives, go to your E-mail 
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw

Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help

For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact

If you do not want to receive future e-mail from this MSN group, or if you received 
this message by mistake, please click the Remove link below. On the pre-addressed 
e-mail message that opens, simply click Send. Your e-mail address will be deleted 
from this group's mailing list.
mailto:[EMAIL PROTECTED]


Com + Transaction Properties

2004-06-14 Thread Shekhar
---

New Message on BDOTNET

---
From: Shekhar
Message 1 in Discussion


Hi 
All,
 
I 
am facing serious problem in transaction handling through com+, I have a 
transaction which is initiated from VB component1 with property Require 
transaction. Now this VB component1 is calling another VB component2 with 
transaction property set to Requires new transaction, this component2 
executes fallowing stored procedure to get unique id based on 
table.
 
CREATEPROCEDURE 
SP_TXN_ID   (@lngTxnId VARCHAR(20) OUTPUT)AS
BEGIN
begin 
transaction
set transaction isolation level serializable
UPDATE 
TRANSACTION_ID SET LAST_NO=LAST_NO+1
SELECT @lngTxnId=last_no from 
transaction_id
commit transaction
END
GO
SET QUOTED_IDENTIFIER OFF 

GO
SET ANSI_NULLS ON 
GO
 

After getting uniqueid from VB component2, VB component1 calls VB component3 
with property set as Requires transaction. And this VB component3 once again 
calls VB component2 to get the another unique id. All these components are 
deployed in com+ service, Every connection is opened with SET TRANSACTION 
ISOLATION LEVEL READ COMMITTED. VB component2 doesn't have 
Interface.
 
   Problem 
is when second time VB component2 is called through VB component3 to get the 
unique id, it fails with error TIME OUT.
 

Some of the solution I tried are,

-Setting property of VB component2 to not supported, still same 
error

-Calling VB component2 through non supported VB component4, still same 
error

-Changed the stored procedure and removed serializable level, still same 
problem
 

-When tried to call stored procedure directly from VB component1 and VB 
component3 I am able to get the unique ids, a common function is added to common 
bas file to call this stored procedure. Since this unique id generation required 
in lot of components (500), so I don't want to change all these components to 
get this result.
 
 

Please let me know why this is giving Time out error when I call it through VB 
component2.
 

Thanks



Shekhar.
 
 


 

---

To stop getting this e-mail, or change how often it arrives, go to your E-mail 
Settings.
http://groups.msn.com/BDotNet/_emailsettings.msnw

Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help

For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact

If you do not want to receive future e-mail from this MSN group, or if you received 
this message by mistake, please click the Remove link below. On the pre-addressed 
e-mail message that opens, simply click Send. Your e-mail address will be deleted 
from this group's mailing list.
mailto:[EMAIL PROTECTED]


How to preserve the order in Hashtable?

2004-06-14 Thread DotnetRajee
---

New Message on BDOTNET

---
From: DotnetRajee
Message 1 in Discussion

hi,   How can i preserve the order in which items are added to the hashtable while 
retrieving the values using foreach statement?For ex.I i had added keys 
m1,m2,abc etc and while i retrieve the keys using foreach statement, the order 
is changed. Thanks

---

To stop getting this e-mail, or change how often it arrives, go to your E-mail 
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw

Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help

For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact

If you do not want to receive future e-mail from this MSN group, or if you received 
this message by mistake, please click the Remove link below. On the pre-addressed 
e-mail message that opens, simply click Send. Your e-mail address will be deleted 
from this group's mailing list.
mailto:[EMAIL PROTECTED]


OUTLOOK

2004-06-14 Thread BDOTNET
---

New Message on BDOTNET

---
From: hi4masrpreethi
Message 1 in Discussion

hi, i want to add some functinality into outlook how can add interface into that.any 
resource?.   thx, preethi

---

To stop getting this e-mail, or change how often it arrives, go to your E-mail 
Settings.
http://groups.msn.com/BDOTNET/_emailsettings.msnw

Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help

For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact

If you do not want to receive future e-mail from this MSN group, or if you received 
this message by mistake, please click the Remove link below. On the pre-addressed 
e-mail message that opens, simply click Send. Your e-mail address will be deleted 
from this group's mailing list.
mailto:[EMAIL PROTECTED]


Required help in achieving MCP in C#

2004-06-14 Thread Iamtheoneurwarnedabout
---

New Message on BDOTNET

---
From: Iamtheoneurwarnedabout
Message 1 in Discussion

Hi All,   I want to take Microsoft .Net exam (MCP) in C# windows based. Can anyone 
suggest me if there are any Free sites where in I can take free mock test before I 
take head on.   Thanks,   GodThrone

---

To stop getting this e-mail, or change how often it arrives, go to your E-mail 
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw

Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help

For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact

If you do not want to receive future e-mail from this MSN group, or if you received 
this message by mistake, please click the Remove link below. On the pre-addressed 
e-mail message that opens, simply click Send. Your e-mail address will be deleted 
from this group's mailing list.
mailto:[EMAIL PROTECTED]


Re: asp.net data access thru oracle 9i client

2004-06-14 Thread BDOTNET
---

New Message on BDOTNET

---
From: akash
Message 3 in Discussion

Thanks, but even after doing the necessary changes in SQLNET.ORA file I'm still 
getting the same exception. Pls look into this, TIA, Akash  

---

To stop getting this e-mail, or change how often it arrives, go to your E-mail 
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw

Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help

For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact

If you do not want to receive future e-mail from this MSN group, or if you received 
this message by mistake, please click the Remove link below. On the pre-addressed 
e-mail message that opens, simply click Send. Your e-mail address will be deleted 
from this group's mailing list.
mailto:[EMAIL PROTECTED]


Re: Required help in achieving MCP in C#

2004-06-14 Thread BDOTNET
---

New Message on BDOTNET

---
From: ramaprasad
Message 2 in Discussion

 Hi,
Just follow this link for the details on this exam.
http://www.microsoft.com/learning/exams/70-316.asp
It also contains link to testsites. You can also use
test questions which comes with Developing and Implementing 
Windows-based Applications with Microsoft Visual C# .NET and 
Microsoft Visual Studio .NET [MS press]book CD.   
Regards,
Ramaprasad Upadhyaya
MCSD | Microsoft .NET MVP

---

To stop getting this e-mail, or change how often it arrives, go to your E-mail 
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw

Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help

For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact

If you do not want to receive future e-mail from this MSN group, or if you received 
this message by mistake, please click the Remove link below. On the pre-addressed 
e-mail message that opens, simply click Send. Your e-mail address will be deleted 
from this group's mailing list.
mailto:[EMAIL PROTECTED]


Requirement on Chart

2004-06-14 Thread Jitendra Vemula
---

New Message on BDOTNET

---
From: Jitendra Vemula
Message 1 in Discussion

 
Hi, 
I have requirement to show a chart with 3 y-axis for the same x-axis, this I can’t 
show in series as the 3 y-axis must have different scales. I can’t change this scale 
as this one is plotting an engineering stuff which must follow this scaling. 
o:p /o:p 
I am using component one Chat control right now,  
o:p /o:p 
Any help regarding this will very helpful for me, 
o:p /o:p 
Thanking You, 
o:p /o:p 
With Regards, 
Jitendra Kumar Vemula 
[EMAIL PROTECTED]

---

To stop getting this e-mail, or change how often it arrives, go to your E-mail 
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw

Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help

For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact

If you do not want to receive future e-mail from this MSN group, or if you received 
this message by mistake, please click the Remove link below. On the pre-addressed 
e-mail message that opens, simply click Send. Your e-mail address will be deleted 
from this group's mailing list.
mailto:[EMAIL PROTECTED]


opening a URL from ASP.Net App

2004-06-14 Thread PremAnand7
---

New Message on BDOTNET

---
From: PremAnand7
Message 1 in Discussion

Hi, i want to open an IE based on a URL which i would be getting from the DB. in my 
ASP.Net app. i tried System.Diagnostics.Process.Start(URL). This works only in windows 
app, but gives error in ASP.net App The System cannot find the file specified even 
when the URL is a valid one.   Any other way to do it. thanx in advance  Prem

---

To stop getting this e-mail, or change how often it arrives, go to your E-mail 
Settings.
http://groups.msn.com/BDOTNET/_emailsettings.msnw

Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help

For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact

If you do not want to receive future e-mail from this MSN group, or if you received 
this message by mistake, please click the Remove link below. On the pre-addressed 
e-mail message that opens, simply click Send. Your e-mail address will be deleted 
from this group's mailing list.
mailto:[EMAIL PROTECTED]


Requirement in my company

2004-06-14 Thread Rhegde
---

New Message on BDOTNET

---
From: Rhegde
Message 1 in Discussion




Hi All, 

There is a requirement in my team 
@Honeywell Bangalore.The following are the 
criteria for the short listing of the profile 

1)Candidate should have at least 2 
Years of work experience
2)Candidate should have exposure to 
C,C++,VC++,COM/DCOM and .Net(C#,VB.Net etc.)
3)Candidate should have exposure 
to database programing
i.e MS SQL and Oracle
4)Willing to do testing 
also(75% development 25% testing)
5) Candidate should have knowledge of 
testing process in SDLC
6)Excellent communication, willing to learn new 
things.
7)Exposure to avionics or automation control domain is added 
advantage.
8) Salory is at market standard. 

 

If anybody suits for this requirement 
please send me the resume.

 

Regards

Raghavendra

---

To stop getting this e-mail, or change how often it arrives, go to your E-mail 
Settings.
http://groups.msn.com/BDOTNET/_emailsettings.msnw

Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help

For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact

If you do not want to receive future e-mail from this MSN group, or if you received 
this message by mistake, please click the Remove link below. On the pre-addressed 
e-mail message that opens, simply click Send. Your e-mail address will be deleted 
from this group's mailing list.
mailto:[EMAIL PROTECTED]


Re: Required help in achieving MCP in C#

2004-06-14 Thread Iamtheoneurwarnedabout
---

New Message on BDOTNET

---
From: Iamtheoneurwarnedabout
Message 3 in Discussion



Hi Ram



Thanks a lot friend.



Regards,

Arshad,





---

To stop getting this e-mail, or change how often it arrives, go to your E-mail 
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw

Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help

For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact

If you do not want to receive future e-mail from this MSN group, or if you received 
this message by mistake, please click the Remove link below. On the pre-addressed 
e-mail message that opens, simply click Send. Your e-mail address will be deleted 
from this group's mailing list.
mailto:[EMAIL PROTECTED]


VALIDATORs IN drop dwon lsit

2004-06-14 Thread mag_mani
---

New Message on BDOTNET

---
From: mag_mani
Message 1 in Discussion

Hi   We can use validators like Regular Expression or  Required Filed or compare 
validaotor for dropdown list. If yes pls provide some link where i can refer  

---

To stop getting this e-mail, or change how often it arrives, go to your E-mail 
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw

Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help

For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact

If you do not want to receive future e-mail from this MSN group, or if you received 
this message by mistake, please click the Remove link below. On the pre-addressed 
e-mail message that opens, simply click Send. Your e-mail address will be deleted 
from this group's mailing list.
mailto:[EMAIL PROTECTED]


Problem with File Copy

2004-06-14 Thread -Aman_Garg-
---

New Message on BDOTNET

---
From: -Aman_Garg-
Message 1 in Discussion

  
Hi,o:p/o:p 
o:p/o:p 
Let me define the problem, I hope that I can put in right words.o:p/o:p 
o:p/o:p 
I am working on a web app and the user clicks on the copy button. When he clicks on a 
copy button, the files should get copied from some given path (\\Machine2\C$\test.txt) 
to another path (\\Machine3\C$\text.txt). I have access credentials to both these 
machines. o:p/o:p 
o:p/o:p 
Can someone help me on what’s the easiest of the methods to achieve the 
same?o:p/o:p 
Regardso:p/o:p 
Aman Gargo:p/o:p

---

To stop getting this e-mail, or change how often it arrives, go to your E-mail 
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw

Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help

For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact

If you do not want to receive future e-mail from this MSN group, or if you received 
this message by mistake, please click the Remove link below. On the pre-addressed 
e-mail message that opens, simply click Send. Your e-mail address will be deleted 
from this group's mailing list.
mailto:[EMAIL PROTECTED]


Re: Required help in achieving MCP in C#

2004-06-14 Thread priyanka_dotnet
---

New Message on BDOTNET

---
From: priyanka_dotnet
Message 4 in Discussion

hi,Try out thishttp://www.braindumpcentral.com   cheers :) Priyanka

---

To stop getting this e-mail, or change how often it arrives, go to your E-mail 
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw

Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help

For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact

If you do not want to receive future e-mail from this MSN group, or if you received 
this message by mistake, please click the Remove link below. On the pre-addressed 
e-mail message that opens, simply click Send. Your e-mail address will be deleted 
from this group's mailing list.
mailto:[EMAIL PROTECTED]


Xml Web services

2004-06-14 Thread priyanka_dotnet
---

New Message on BDOTNET

---
From: priyanka_dotnet
Message 1 in Discussion

hi,Please tell me how can we call/access web services using javascript. if it is 
possible . plz give exampleThanks  Priyanka  

---

To stop getting this e-mail, or change how often it arrives, go to your E-mail 
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw

Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help

For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact

If you do not want to receive future e-mail from this MSN group, or if you received 
this message by mistake, please click the Remove link below. On the pre-addressed 
e-mail message that opens, simply click Send. Your e-mail address will be deleted 
from this group's mailing list.
mailto:[EMAIL PROTECTED]


Regarding In Line Code

2004-06-14 Thread ManchanaHari
---

New Message on BDOTNET

---
From: ManchanaHari
Message 1 in Discussion



Hi,

  Please anyone can tell me how to access methods written classes in Inline Code in 
ASP.Net.


The MSN mobile contest! Free talktime ‘n smart phones! Register now to win! 

---

To stop getting this e-mail, or change how often it arrives, go to your E-mail 
Settings.
http://groups.msn.com/BDOTNET/_emailsettings.msnw

Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help

For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact

If you do not want to receive future e-mail from this MSN group, or if you received 
this message by mistake, please click the Remove link below. On the pre-addressed 
e-mail message that opens, simply click Send. Your e-mail address will be deleted 
from this group's mailing list.
mailto:[EMAIL PROTECTED]


Re: Xml Web services

2004-06-14 Thread BDOTNET
---

New Message on BDOTNET

---
From: rags_rao
Message 2 in Discussion

use webservice behavior (web service.htc)   
http://msdn.microsoft.com/library/default.asp?url=/workshop/author/webservice/overview.asp
 -- Do you know we've been led to slaughters by placid admirals and that fat 
slow generals are getting obcene on young blood? Do you know we are ruled by TV? - 
Jim morrison

---

To stop getting this e-mail, or change how often it arrives, go to your E-mail 
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw

Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help

For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact

If you do not want to receive future e-mail from this MSN group, or if you received 
this message by mistake, please click the Remove link below. On the pre-addressed 
e-mail message that opens, simply click Send. Your e-mail address will be deleted 
from this group's mailing list.
mailto:[EMAIL PROTECTED]


Re: How to preserve the order in Hashtable?

2004-06-14 Thread BDOTNET
---

New Message on BDOTNET

---
From: rags_rao
Message 2 in Discussion

ordering in hash table is done based on hash output with the key as its input. perhaps 
hashtable is not the one you want to use. try namevaluecollection   -- Do you 
know we've been led to slaughters by placid admirals and that fat slow generals are  
getting obscene on young blood? Do you know we are ruled by TV?
- Jim morrison


---

To stop getting this e-mail, or change how often it arrives, go to your E-mail 
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw

Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help

For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact

If you do not want to receive future e-mail from this MSN group, or if you received 
this message by mistake, please click the Remove link below. On the pre-addressed 
e-mail message that opens, simply click Send. Your e-mail address will be deleted 
from this group's mailing list.
mailto:[EMAIL PROTECTED]


New to .Net

2004-06-14 Thread RAravind1
---

New Message on BDOTNET

---
From: RAravind1
Message 1 in Discussion

I'm a new member of the group and would like to pursue a career in the .net .
I'm still in a dilema. Which course would give me a better job prospect: J2EE or .net

I hope to get a good suggestion from you.

Thanks  Regards,
Aravind. R


---

To stop getting this e-mail, or change how often it arrives, go to your E-mail 
Settings.
http://groups.msn.com/BDOTNET/_emailsettings.msnw

Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help

For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact

If you do not want to receive future e-mail from this MSN group, or if you received 
this message by mistake, please click the Remove link below. On the pre-addressed 
e-mail message that opens, simply click Send. Your e-mail address will be deleted 
from this group's mailing list.
mailto:[EMAIL PROTECTED]


Re: OUTLOOK

2004-06-14 Thread DotNetTechie1976
---

New Message on BDOTNET

---
From: DotNetTechie1976
Message 2 in Discussion






R
u working in outlook application? I need some inputs on that. Can u please help
me? Iam going to start project on that.


My question is r u using .Net with outlook?


 


 


-Original Message-

From: BDOTNET
[mailto:[EMAIL PROTECTED] 

Sent: Monday, June 14, 2004 2:04
PM

To: BDOTNET

Subject: OUTLOOK


 





 
  
  

  
  
  
New
  Message on BDOTNET
  
 
 
  
  

  
 





 


OUTLOOK


 
  
  
Reply

  
  
  
  
   


 



Recommend




Message 1 in
Discussion 

   
  
  

  
 
 
  
  
   


From: hi4masrpreethi 

   
   


 


hi,



i want to add some functinality into outlook how
can add interface into that.any resource?.



 



thx,



preethi


   
  
  

  
 





View other groups in this
category. 



 language=JavaScript
//![CDATA[
var pathString;
var MSAdsEmbed=0, MSAdsUseFlash=0, MSNadsBGCOLOR=#FF, MSNadsMENU=FALSE, 
MSNadsWIDTH=728, MSNadsHEIGHT=90;

function dlWrite_603726(){document.write('');}
var g_bShowFlash=false;
if (navigator.appVersion.indexOf(Win)=0  
parseFloat(navigator.appVersion.substr(navigator.appVersion.indexOf(MSIE )+5))=4) 
{document.write('SCR' + 'IPT LANGUAGE=VBScript\ \n');document.write('on error resume 
next \n');document.write('g_bShowFlash = ( 
IsObject(CreateObject(ShockwaveFlash.ShockwaveFlash.4)))\n');document.write('/SCR' 
+ 'IPT\');}
if(g_bShowFlash == true)
{
var sFlashObjName = msn_click + Math.floor(1*Math.random());
document.write('object classid=clsid:D27CDB6E-AE6D-11cf-96B8-44455354 
codebase=http://active.macromedia.com/flash2/cabs/swflash.cab#version=3,0,0,0; id=' 
+ sFlashObjName + ' width=' + MSNadsWIDTH + '  height=' + MSNadsHEIGHT + ' 
style=z-index:-1param name=movie 
value=http://global.msads.net/ads/52680/052680_63124.swf;param 
name=wmode value=opaqueparam name=quality value=highparam name=loop 
value=true/object');
document.all[sFlashObjName].attachEvent(fscommand, function (cmd,args) {if 
(cmd==URL1) 
{window.open(http://g.msn.com/0ADO/603726.1??PID=2277815UIT=MTargetID=1032731AN=24409PG=WBCSCO,_blank;);}});
}
else
{
dlWrite_603726();
}

//]]
/script



---

To stop getting this e-mail, or change how often it arrives, go to your E-mail 
Settings.
http://groups.msn.com/BDOTNET/_emailsettings.msnw

Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help

For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact

If you do not want to receive future e-mail from this MSN group, or if you received 
this message by mistake, please click the Remove link below. On the pre-addressed 
e-mail message that opens, simply click Send. Your e-mail address will be deleted 
from this group's mailing list.
mailto:[EMAIL PROTECTED]


HELP NEEDED: MS FlexGrid control to be used in ASP.NET

2004-06-14 Thread Ujain
---

New Message on BDOTNET

---
From: Ujain
Message 1 in Discussion






Hi group,o:p/o:p


o:p /o:p


In our
project I am in a situation where I’ve to use FlexGrid
control in ASP.NET.o:p/o:p


o:p /o:p


After a lot
of RD I am unable to use it in our project. If any one of you has done
same work then kindly let me know the solution for this.o:p/o:p


o:p /o:p


I
specifically require FlexGrid to be used in the
project.o:p/o:p


o:p /o:p


Regards,o:p/o:p


Umesh Kumar Jain.o:p/o:p


Software Engineer.o:p/o:p


Second Foundation India Pvt. Ltd.o:p/o:p


st1:Cityst1:placeChandigarh/st1:place/st1:City.o:p/o:p


o:p /o:p





---

To stop getting this e-mail, or change how often it arrives, go to your E-mail 
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw

Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help

For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact

If you do not want to receive future e-mail from this MSN group, or if you received 
this message by mistake, please click the Remove link below. On the pre-addressed 
e-mail message that opens, simply click Send. Your e-mail address will be deleted 
from this group's mailing list.
mailto:[EMAIL PROTECTED]


Re: VALIDATORs IN drop dwon lsit

2004-06-14 Thread BDOTNET
---

New Message on BDOTNET

---
From: ramaprasad
Message 2 in Discussion

  Hi,
Pls go thro the link and download the code.
That should help you in implementing the 
same in your code.
http://www.1perlstreet.com/vb/scripts/ShowCode.asp?txtCodeId=1770lngWId=10 Regards,
Ramaprasad Upadhyaya
MCSD | Microsoft .NET MVP
Wipro Technology
Bangalore

---

To stop getting this e-mail, or change how often it arrives, go to your E-mail 
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw

Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help

For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact

If you do not want to receive future e-mail from this MSN group, or if you received 
this message by mistake, please click the Remove link below. On the pre-addressed 
e-mail message that opens, simply click Send. Your e-mail address will be deleted 
from this group's mailing list.
mailto:[EMAIL PROTECTED]


How to assign values to labels dynamically

2004-06-14 Thread smith_p78
---

New Message on BDOTNET

---
From: smith_p78
Message 1 in Discussion



  

frnds,

 I am doing a web application in which i have  a group of

 labels like Label1,Label2,Label3 etc.

 What i have to do is to assign values to labels dynamically.

 ie not by giving label1.text=SomeString.

 I want to iterate through the controls and to assign

 values to it.

 Does anybody have idea about it.

 Any help will be appreciated.

regards

smithesh









---

To stop getting this e-mail, or change how often it arrives, go to your E-mail 
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw

Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help

For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact

If you do not want to receive future e-mail from this MSN group, or if you received 
this message by mistake, please click the Remove link below. On the pre-addressed 
e-mail message that opens, simply click Send. Your e-mail address will be deleted 
from this group's mailing list.
mailto:[EMAIL PROTECTED]


Re: How to assign values to labels dynamically

2004-06-14 Thread Pandurang_Nayak
---

New Message on BDOTNET

---
From: Pandurang_Nayak
Message 2 in Discussion

Hi Smithesh,   The following code should work for you:  
private void SetLabelsText()
{
foreach(Control cntl in Form1.Controls)
{
if(cntl.GetType() == typeof(Label))
{
Label x = (Label) cntl;
x.Text = SetLabelText;
}
}
}

---

To stop getting this e-mail, or change how often it arrives, go to your E-mail 
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw

Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help

For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact

If you do not want to receive future e-mail from this MSN group, or if you received 
this message by mistake, please click the Remove link below. On the pre-addressed 
e-mail message that opens, simply click Send. Your e-mail address will be deleted 
from this group's mailing list.
mailto:[EMAIL PROTECTED]


Re: New to .Net

2004-06-14 Thread Pandurang_Nayak
---

New Message on BDOTNET

---
From: Pandurang_Nayak
Message 2 in Discussion

Hi Aravind,   Both J2EE and .NET are platforms which provide excellent support for 
building enterprise applications and large systems.   It is a matter of choice for 
which platform to go to.   I work in the .NET environment and I can tell you that 
stuff here is exciting. There are a lot of advances made in a very short timeframe by 
Microsoft to scale up to a platform like .NET for development. The work hasn't stopped 
and we're seeing newer things coming in everyday. If I'm not wrong, in the J2EE world 
- this is not the case at the moment. There are too many vendors and hence differing 
standards.   I would suggest you look at which technology really interests you and 
then get into the same stream.   Regards Pandurang http://pandurang.thinkingMS.com

---

To stop getting this e-mail, or change how often it arrives, go to your E-mail 
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw

Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help

For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact

If you do not want to receive future e-mail from this MSN group, or if you received 
this message by mistake, please click the Remove link below. On the pre-addressed 
e-mail message that opens, simply click Send. Your e-mail address will be deleted 
from this group's mailing list.
mailto:[EMAIL PROTECTED]


urgent help needed on visio 2003 and asp.net integration

2004-06-14 Thread smartchips
---

New Message on BDOTNET

---
From: smartchips
Message 1 in Discussion

Hi,   I am doing reverse engineering to develop UML diagrams from asp.net. Everything 
is working fine, except the final Visio diagram is unable to open. I am getting a 
mesaage as the file is not a vaild visio or it is currupted. Any idea why is this 
happening..? I am using MS-Visio 2003.   Any help is appreciated.   Thanx in advance,  
 Cheers RaghauMCP

---

To stop getting this e-mail, or change how often it arrives, go to your E-mail 
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw

Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help

For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact

If you do not want to receive future e-mail from this MSN group, or if you received 
this message by mistake, please click the Remove link below. On the pre-addressed 
e-mail message that opens, simply click Send. Your e-mail address will be deleted 
from this group's mailing list.
mailto:[EMAIL PROTECTED]


Re: opening a URL from ASP.Net App

2004-06-14 Thread Pandurang_Nayak
---

New Message on BDOTNET

---
From: Pandurang_Nayak
Message 3 in Discussion

if you don't want a startup script, you could also use
Page.RegisterClientScriptBlock Regards Pandurang http://pandurang.thinkingMS.com

---

To stop getting this e-mail, or change how often it arrives, go to your E-mail 
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw

Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help

For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact

If you do not want to receive future e-mail from this MSN group, or if you received 
this message by mistake, please click the Remove link below. On the pre-addressed 
e-mail message that opens, simply click Send. Your e-mail address will be deleted 
from this group's mailing list.
mailto:[EMAIL PROTECTED]


Re: opening a URL from ASP.Net App

2004-06-14 Thread Pandurang_Nayak
---

New Message on BDOTNET

---
From: Pandurang_Nayak
Message 2 in Discussion

Use client-side JavaScript (on page load or any other event):   
Page.RegisterStartupScript(scriptwindow.open(' + strURL + ');/script);

---

To stop getting this e-mail, or change how often it arrives, go to your E-mail 
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw

Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help

For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact

If you do not want to receive future e-mail from this MSN group, or if you received 
this message by mistake, please click the Remove link below. On the pre-addressed 
e-mail message that opens, simply click Send. Your e-mail address will be deleted 
from this group's mailing list.
mailto:[EMAIL PROTECTED]


Re: New to .Net

2004-06-14 Thread Varad_RS
---

New Message on BDOTNET

---
From: Varad_RS
Message 3 in Discussion

Hi, I go with Pandurang!   In the business world both .NET and J2EE have the similar 
market.   With my experience in working with .NET, the area is very challenging and 
interesting. You can do what ever you want and you will be more productive in the .NET 
world. MS has advancing the .NET technology to help the developers code efficiently 
and easily. Also in my personal opinion leaning .NET is much easier than learning Java 
or J2EE.   Also, According to a recent study 56% of enterprises surveyed will be using 
the .NET Framework as their primary development environment in 2005.For more 
details read the full report.   All the best, Rgds, Varad. 
http://varadarajans.blogspot.com

---

To stop getting this e-mail, or change how often it arrives, go to your E-mail 
Settings.
http://groups.msn.com/BDotNet/_emailsettings.msnw

Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help

For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact

If you do not want to receive future e-mail from this MSN group, or if you received 
this message by mistake, please click the Remove link below. On the pre-addressed 
e-mail message that opens, simply click Send. Your e-mail address will be deleted 
from this group's mailing list.
mailto:[EMAIL PROTECTED]


Re: Xml Web services

2004-06-14 Thread Varad_RS
---

New Message on BDOTNET

---
From: Varad_RS
Message 3 in Discussion


Hi Priyanka,
If you are using Microsoft IE 5 or later, you can use the behavior/HTML-Component 
WebService to access a Web service. The WebService behavior communicates with Web 
services over HTTP using Simple Object Access Protocol (SOAP). 
To use the WebService behavior, you must attach it to an element using the STYLE 
attribute, as follows:
DIV ID=GiveItAName
STYLE=behavior:url(webservice.htc)/DIV 
A complete example taken from the Microsoft Web site is as follows: 
html
head
script language=JavaScript
var iCallID; 
function init()
{
service.useService
(http://myserver.com/services/myservice.asmx?WSDL;,
   servicename);
} 
function onmyresult()
{
   if ((event.result.error)(iCallID==event.result.id))
   {
  var xfaultcode = event.result.errorDetail.code;
  var xfaultstring = event.result.errorDetail.string;
  var xfaultsoap = event.result.errorDetail.raw; 
  // Add code to output error information here
  alert(Error );
   }
   else
   {
  service.innerHTML= The method returned the result: 
 + event.result.value;
   }
}
/script
/HEAD
body onload=init();
BR
Enter a Value input type='text' id='param1'
BR
button onclick='iCallID = service.servicename.callService
(ProcedureName, param1.value);'Call A Web Method/button
div id=service
 style=behavior:url(webservice.htc)
 onresult=onmyresult();
/div
/body
/html 
Hope this helps..If you need more Pls revert back.. 
Rgds,
Varad.
http://varadarajans.blogspot.com 
 

---

To stop getting this e-mail, or change how often it arrives, go to your E-mail 
Settings.
http://groups.msn.com/BDotNet/_emailsettings.msnw

Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help

For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact

If you do not want to receive future e-mail from this MSN group, or if you received 
this message by mistake, please click the Remove link below. On the pre-addressed 
e-mail message that opens, simply click Send. Your e-mail address will be deleted 
from this group's mailing list.
mailto:[EMAIL PROTECTED]


Re: Problem with File Copy

2004-06-14 Thread Varad_RS
---

New Message on BDOTNET

---
From: Varad_RS
Message 2 in Discussion

Hi, You can use FileCopy method in FileSystemObjects Class.   Thanks, Varad.

---

To stop getting this e-mail, or change how often it arrives, go to your E-mail 
Settings.
http://groups.msn.com/BDotNet/_emailsettings.msnw

Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help

For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact

If you do not want to receive future e-mail from this MSN group, or if you received 
this message by mistake, please click the Remove link below. On the pre-addressed 
e-mail message that opens, simply click Send. Your e-mail address will be deleted 
from this group's mailing list.
mailto:[EMAIL PROTECTED]


Re: Where r the Presentations of Yesterday's UG Meet

2004-06-14 Thread THESOFTWAREARCHITECT
---

New Message on BDOTNET

---
From: THESOFTWAREARCHITECT
Message 3 in Discussion

Dear Saravana,   Thanks man 4 the presentationsC u @ da  next meetingBest 
Regards   {  Anil Mahadev AI 2 Da MAX in the Database  }

---

To stop getting this e-mail, or change how often it arrives, go to your E-mail 
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw

Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help

For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact

If you do not want to receive future e-mail from this MSN group, or if you received 
this message by mistake, please click the Remove link below. On the pre-addressed 
e-mail message that opens, simply click Send. Your e-mail address will be deleted 
from this group's mailing list.
mailto:[EMAIL PROTECTED]


Re: Multi-lingual application through database

2004-06-14 Thread DotNetTechie1976
---

New Message on BDOTNET

---
From: DotNetTechie1976
Message 4 in Discussion






The
reason for me not to use resource manager is, this resource file need to be provided
by us. But the client is expecting where he does not depend on us for resource file.
Any language change, he just need to use enter information in database side and
start using it.


 


I you can throw some input on this it would
be fine. Can u explain me how u make resource file in .net? May be based on that
I can design my database.


 


 


 


-Original Message-

From: BDOTNET
[mailto:[EMAIL PROTECTED] 

Sent: Monday, June 14, 2004 9:31
AM

To: BDOTNET

Subject: Re: Multi-lingual
application through database


 





 
  
  

  
  
  
New
  Message on BDOTNET
  
 
 
  
  

  
 





 


Multi-lingual
application through database


 
  
  
Reply

  
  
  
  
   


 



Recommend




Message 2 in
Discussion 

   
  
  

  
 
 
  
  
   


From: Peruri


   
   


 


Yes, I have worked with Mulit Lingual support. But
I have used resource manager, because it is all taken care by .net and fast
and lightweight to load and look for the translations to a string.



 



However , its good to understand why you 
do not want to use the resource manager before you want to design
yourself a resource manager.



 



Yes, you can design your own resource manager,
which practically could be a singleton ,loads the transalations into memory
depending on several factors like , all  labels or  only high hit
into the singleton object which maintains hashtable for each locale , which
contains a untranslated and translated messages.



 



So you have to design a singleton that knows how
to  connect to database or configurable,  maintains list of
hashtables for each locale you are willing to support. Hashtable specific
to locale should load untranslated as keys and translated as values.



 



Hope this helps to start with.



 If you have any questions feel free to post.


   
  
  

  
 





View other groups in this
category. 



 language=JavaScript  type=text/javascript
document.write(''); 
/script



---

To stop getting this e-mail, or change how often it arrives, go to your E-mail 
Settings.
http://groups.msn.com/BDOTNET/_emailsettings.msnw

Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help

For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact

If you do not want to receive future e-mail from this MSN group, or if you received 
this message by mistake, please click the Remove link below. On the pre-addressed 
e-mail message that opens, simply click Send. Your e-mail address will be deleted 
from this group's mailing list.
mailto:[EMAIL PROTECTED]


Re: New to .Net

2004-06-14 Thread RAravind1
---

New Message on BDOTNET

---
From: RAravind1
Message 4 in Discussion

Thank you Pandurang and Varad for your suggestions. I get a better picture now of the 
scenario. Now that i'm a beginner with just some basic programming knowledge in C++ , 
how long would it take me to gain a confident level in .Net Do you have any specific 
institutes that are good in  training in .Net. Are there any area of specialization 
that you would recommend?   Thanks  Regards,  Aravind. R

---

To stop getting this e-mail, or change how often it arrives, go to your E-mail 
Settings.
http://groups.msn.com/BDOTNET/_emailsettings.msnw

Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help

For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact

If you do not want to receive future e-mail from this MSN group, or if you received 
this message by mistake, please click the Remove link below. On the pre-addressed 
e-mail message that opens, simply click Send. Your e-mail address will be deleted 
from this group's mailing list.
mailto:[EMAIL PROTECTED]


Re: How to assign values to labels dynamically

2004-06-14 Thread smith_p78
---

New Message on BDOTNET

---
From: smith_p78
Message 3 in Discussion

pandurang,
 This code will work only in Windows form.
 Do you have any idea about doing the same 
 with asp web controls.
regards
smithesh

---

To stop getting this e-mail, or change how often it arrives, go to your E-mail 
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw

Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help

For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact

If you do not want to receive future e-mail from this MSN group, or if you received 
this message by mistake, please click the Remove link below. On the pre-addressed 
e-mail message that opens, simply click Send. Your e-mail address will be deleted 
from this group's mailing list.
mailto:[EMAIL PROTECTED]


Re: Problem with File Copy

2004-06-14 Thread -Aman_Garg-
---

New Message on BDOTNET

---
From: -Aman_Garg-
Message 3 in Discussion


I have tried using the FileCopy. It works fine if I want to copy the file from the 
same machine. But my problem is how to send it another and how to pass the credentials 
along with. In words how can I create a session between the source and the destination 
machine.

Cheers

Aman Garg

Catch up with old friends. Bring back the good times. Reconnect with the past. 

---

To stop getting this e-mail, or change how often it arrives, go to your E-mail 
Settings.
http://groups.msn.com/BDotNet/_emailsettings.msnw

Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help

For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact

If you do not want to receive future e-mail from this MSN group, or if you received 
this message by mistake, please click the Remove link below. On the pre-addressed 
e-mail message that opens, simply click Send. Your e-mail address will be deleted 
from this group's mailing list.
mailto:[EMAIL PROTECTED]


Re: How to assign values to labels dynamically

2004-06-14 Thread nitin_karan
---

New Message on BDOTNET

---
From: nitin_karan
Message 4 in Discussion

Hi Smithesh,   First add a placeholder (design time) and then do the following.   
Sample   form runat=server
How many TextBoxes would you like to create?
asp:textbox runat=Server id=txt1 Columns=3 / br /
asp:button runat=server Text=Create Dynamic TextBoxes
   OnClick=CreateTextBoxes / p
asp:PlaceHolder runat=server id=TextBoxesHere /
/form   Then use the following segment in the button click   void 
CreateTextBoxes(Object sender, EventArgs e)
{ 
  int n = Int32.Parse(txtTBCount.Text);
  
  // now, create n TextBoxes, adding them to the PlaceHolder TextBoxesHere
  for (int i = 0; i  n; i++)
  {
TextBoxesHere.Controls.Add(new TextBox());
  }
  
  // now, set the Text property of each TextBox
  IterateThroughChildren(this);
}   Then to Access the Control, you can do something like this.   void 
IterateThroughChildren(Control parent)
{
  foreach (Control c in parent.Controls)
  {
if (c.GetType().ToString().Equals(System.Web.UI.WebControls.TextBox)
   c.ID == null)
{
  // ...do something...
}

if (c.Controls.Count  0)
{  
  IterateThroughChildren(c);  
}
  }
}
   I think this should help you. However i would like to suggest you somethings. Do 
you have a knowledge of Repeater Control, this particular control is very helpful in 
implementing in adding controls.   If what you're creating dynamically repeats based 
on some kind of loop, either from a database, an array, the file system, or similar, 
again you don't need to use dynamic controls.  This is where a Repeater comes in 
handy.  You can use a Repeater to repeat just about anything, including repeating a 
Datagrid for every row in a database table, for example.
 --Nitin

---

To stop getting this e-mail, or change how often it arrives, go to your E-mail 
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw

Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help

For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact

If you do not want to receive future e-mail from this MSN group, or if you received 
this message by mistake, please click the Remove link below. On the pre-addressed 
e-mail message that opens, simply click Send. Your e-mail address will be deleted 
from this group's mailing list.
mailto:[EMAIL PROTECTED]


Why I can't use global vairable in union query

2004-06-14 Thread microdotnet
---

New Message on BDOTNET

---
From: microdotnet
Message 1 in Discussion

Hi,   I am facing a strange problem...   I have a query given below... when I am 
trying to define a global variable mode with value as '1'  and try to access in query 
using '?' .  I am not able to use this in a query before union  but able to use it in 
after union statement.  Any reason why ?Any help will be appreciated..   Thanks 
Sagar   SELECT
 OH.ORDNUM AS HSBA,
 N1.COSTCT AS HFCC,
 N1.FLSSTE AS HFSITE,
 N2.COSTCT AS HTCC,
 N2.FLSSTE AS HTSITE,
 ' ' AS HETA,
 ' ' AS HETAID,
 max(OD.DELMTD) AS HMODE,
 OH.EVTNUM AS HFROM,
 upper(replace(stuff(replace(convert(char(20) ,OH.ENTDTE, 113), ':', ''),12,1,':'),' 
','') ) AS HODAT,
 CASE  
  WHEN (SELECT ISNULL(SUM(IDL.SHPQTY),0) FROM INVHDR IH, INVDTL IDL
  WHERE IH.SHIPID = IDL.SHIPID AND IH.ORDNUM = OH.ORDNUM) = 0 THEN 0
  ELSE 1
 END as HSTAT,
 ' ' AS HSHIPF
FROM  ORDHDR OH, ORDDTL OD, NODMST N1, NODMST N2
WHERE  OH.ORDNUM = OD.ORDNUM AND
 OH.STCUST = N1.NODNUM AND
 OD.SUPNOD = N2.NODNUM and ('1' = ? or ('0' = ? and N1.SYSTYP = 'SLS' and N2.SYSTYP = 
'SLS'))
GROUP BY OH.ORDNUM, N1.COSTCT, N1.FLSSTE, N2.COSTCT, N2.FLSSTE, OH.EVTNUM, OH.ENTDTE
UNION
SELECT --salesorder Non-FSL's
 OH.ORDNUM AS HSBA,
 ' ' AS HFCC,
 C.FINSTE AS HFSITE,
 N1.COSTCT AS HTCC,
 N1.FLSSTE AS HTSITE,
 ' ' AS HETA,
 ' ' AS HETAID,
 max(OD.DELMTD) AS HMODE,
 OH.EVTNUM AS HFROM,
 upper(replace(stuff(replace(convert(char(20) ,OH.ENTDTE, 113), ':', ''),12,1,':'),' 
','') ) AS HODAT,
 CASE  
  WHEN (SELECT ISNULL(SUM(IDL.SHPQTY),0) FROM INVHDR IH, INVDTL IDL
  WHERE IH.SHIPID = IDL.SHIPID AND IH.ORDNUM = OH.ORDNUM) = 0 THEN 0
  ELSE 1
 END as HSTAT,
 ' ' AS HSHIPF
FROM  ORDHDR OH, ORDDTL OD, NODMST N1, CSTMST C
WHERE  OH.ORDNUM = OD.ORDNUM AND
 OH.STCUST = C.STCUST AND
 OD.SUPNOD = N1.NODNUM and ('1' = ? or ('0'  = ? and N1.SYSTYP = 'SLS'))
GROUP BY OH.ORDNUM, N1.COSTCT, N1.FLSSTE, C.FINSTE, OH.EVTNUM, OH.ENTDTE

---

To stop getting this e-mail, or change how often it arrives, go to your E-mail 
Settings.
http://groups.msn.com/BDotNet/_emailsettings.msnw

Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help

For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact

If you do not want to receive future e-mail from this MSN group, or if you received 
this message by mistake, please click the Remove link below. On the pre-addressed 
e-mail message that opens, simply click Send. Your e-mail address will be deleted 
from this group's mailing list.
mailto:[EMAIL PROTECTED]