question about BCP process. The problem is when I transfer the data in date time type field the date '00000000' is not transferable, which is understandable, however it also kicking out some data with appropriate date. Any idea why it occur?

I am getting an error msg: "The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value." when I have the following code in where close: and n.dateentered between (case When DatePart (dw , getdate())=2 Then (getDate()-3 ) When DatePart (dw , getdate())=4 Then (getDate()-2 ) When DatePart (dw , getdate())=6 Then (getDate()-2 ) Else GetDate() End ) and (getdate()-1) but when I run with this (I put dates manually) it is fine. and n.dateentered between '09/20/2003' and '09/29/2003' Any idea why?

I am trying to display my result this way:

Volumes Amounts
22 12
45 89
897 954
Total: 1055

When I run the program I get this:

Volumes Amounts
22 12
45 89
897 954
Total: 1055

I am trying to display my result this way: Volumes Amounts 22 12 45 89 897 954 Total: 1055 When I run the program I get this: Please help Volumes Amounts 22 12 45 89 897 954 Total: 1055 cout<<"\nTotal number of bills: "<0) { cout<

The size of the array is the same, because I am using the parallel array.

I have 2 arrays and I need to display data this way: array1 array2 data1 data1 data2 data2 data3 data3 How do I dot this?

I have a batch file where I am put a file into ftp site. The problem is that my file name are changing every day. How do I supply this file into batch file? Or is any other way to do this? open ftp.site user test pass test lcd C:\ cd .. put test.txt bye

Thank you for comments it explains a lot (I am in school ) :)

Thanks for the comments. It helps a lot. One more question: I am trying to display all values after user enters 0. I wrote the following code. I can't see what is incorrect in this code. displayArray(); void displayArray(const int volumes[NUM];const int NUM) { count<<"\n"; int count=0; while (count

Here is my code: Can you help me? #include using namespace std; const NUM = 2; int volumes[NUM], volume; int count=0; int amounts[NUM],amount; const double price=0.05; const double fee=12.0; int main() { do { cout<<"Please enter the volume of water used by a customer "; cout<< "during a month (in gallons).(Zero to end):"; cin>>volume; if (volume==0.0) break; if (count==NUM) break; volumes[count++]=volume; amount=(volume*price)+fee; amounts[count++]=amount; } while(true); return 0; }

I have an array:int amounts[] How do I define size of arrays as an enumeration literal Num in an anonymous enumeration?

I am so sorry. But I could not compile your example. And also I did not understand :( Please explain one more time...

Here is my updated code, but it is not doing what it should. If user enters outside the range 1,2 it should show only cout<<"Please enter 1 or 2 (3 to exit program):"; in all other cases main menu #include //using namespace std; int main(void) { int choice; float c; float f; bool enter; enter==true; do { if (enter=true ) { cout<<"Please select the task to perform:"<>choice; switch (choice) { case 1: { cout<<"Enter value in Fahrenheit:" ; cin>>f; c=((f-32)*5/9); cout<<"The value in Centigrade is:"<>c; f=((c+32)*9/5); cout<<"The value in Fahrenheit is:"<

Here is my modified code. It still not going to the cout<<"Please select the task to perform:"< //using namespace std; int main(void) { int choice; float c; float f; bool enter; do { if (enter=true ) { cout<<"Please select the task to perform:"<>choice; switch (choice) { case 1: { cout<<"Enter value in Fahrenheit:" ; cin>>f; c=((f-32)*5/9); cout<<"The value in Centigrade is:"<>c; f=((c+32)*9/5); cout<<"The value in Fahrenheit is:"<

can you give the example? I am new to C++

Please help Here is my code. I was able to modified to go to main menu. But If user enter a value outside the range it should not go to the main menu. It should display only: cout<<"Please enter 1 or 2 (3 to exit program):"; cin>>choice; #include //using namespace std; int main(void) { int choice; float c; //Declare variable to be displayed. float f; //Question:Will it be the best practice to do this: float c=0? //Question:I used float, but I am not sure if in this case better to use int or double? for(;;) // empty to promt a user to enter correct choice value { cout<<"Please select the task to perform:"<>choice; switch (choice) { // use switch in order to do validation and calculation case 1: { cout<<"Enter value in Fahrenheit:" ; cin>>f; c=((f-32)*5/9); cout<<"The value in Centigrade is:"<>c; f=((c+32)*9/5); cout<<"The value in Fahrenheit is:"<

cout<<"Please enter 1 or 2 (3 to exit program):"; cin>>choice;

I have the following code: My question is: how to pass a element od array to procedure to validate? Private Sub btnStart_Click() Dim Age(0 To 5) As String '6 element array Dim Counter As Integer For Counter = 0 To 5 Age(Counter) = InputBox("Records entered:" & Counter & " Please Enter Age :") Call checkAge(Age()) Next End Sub Sub checkAge(Age()) If Age < 17 Then MsgBox "You should not drive yet" Else MsgBox "Eligible for driving" End If End Sub

Please help. When I use @From it fails with the following error , but at the same time when I spesify date is runs fine. "The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value." Declare @From as varchar(10) Set @From =(case When DatePart (dw , getdate())=2 Then convert(varchar(10),(getDate()-3),101) When DatePart (dw , getdate())=4 Then convert(varchar(10),(getDate()-2),101) When DatePart (dw , getdate())=6 Then convert(varchar(10),(getDate()-2),101) Else convert(varchar(10),(getdate()),101) End ) select @From select dateentered from NormalizedData_Out n join MaxDate_Out m on n.StudentID= m.StudentID and (isnull(n.DateEntered, '1/1/1900') =isnull(m.maxdate, '1/1/1900')) and n.dateentered between @From and getdate() --and n.dateentered between '08/27/2003' and getdate()

here is my sp. For some reason it won't attache file. Any idea why? CREATE PROCEDURE CDO_SendMail_test( @From varchar(255) = 's@yahoo.com', @To varchar(255), @Cc varchar(255) = '', @Bcc varchar(255) = '', @Subject varchar(255), @MessageFormat int = 0, -- default to HTML, 1 = text, 0 = html @Message varchar(8000), @Priority int = 2, @AttachFile varchar(8000) -- default to high, 1 = normal, 0 = low ) AS DECLARE @CDO int, @OLEResult int, @Out int --Create CDONTS.NewMail object EXECUTE @OLEResult = sp_OACreate 'CDONTS.NewMail', @CDO OUT IF @OLEResult <> 0 PRINT 'CDONTS.NewMail' --Set CDONTS.NewMail properties execute @OLEResult = sp_OASetProperty @CDO, 'From', @From execute @OLEResult = sp_OASetProperty @CDO, 'To', @To execute @OLEResult = sp_OASetProperty @CDO, 'Cc', @Cc execute @OLEResult = sp_OASetProperty @CDO, 'Bcc', @Bcc execute @OLEResult = sp_OASetProperty @CDO, 'Subject', @Subject execute @OLEResult = sp_OASetProperty @CDO, 'BodyFormat', @MessageFormat execute @OLEResult = sp_OASetProperty @CDO, 'Body', @Message execute @OLEResult = sp_OASetProperty @CDO, 'Importance', @Priority execute @OLEResult = sp_OAMethod @CDO, 'AttachFile', @AttachFile--'' [, ''] [, ] --Call Send method of the object execute @OLEResult = sp_OAMethod @CDO, 'Send', Null IF @OLEResult <> 0 PRINT 'Send' --Destroy CDO EXECUTE @OLEResult = sp_OADestroy @CDO return @OLEResult GO exec CDO_SendMail_test @From = 'yyr@yahoo.com', @To = 'tt@chickering.com', @Cc = '', @Bcc = '', @Subject = 'test', @MessageFormat = 0, @Message = '', @AttachFile ='\\bsar\test.txt'