I get data from a MS SQL table. The data has a data type of nchar. A sample data is as follows,
00:00:01.500000 0
The above data represents Hrs:Mins:Secs
Now i need to convert this data into a suitable data type so that i can add all such related data. After adding i will get total hrs, mins and secs. How can i do this. Please provide some ideas.
pugalenthi
Last Activity: May 14 '08, 08:52 AM
Joined: Jan 12 '07
Location:
-
pugalenthi started a topic How to perform this data type conversion and following it up with SUM operation?.in PHPHow to perform this data type conversion and following it up with SUM operation?.
-
pugalenthi started a topic Storing a C# data of data type timestamp into sql server table and then perform SUMin SQL ServerStoring a C# data of data type timestamp into sql server table and then perform SUM
I need to store a c# variable of data type timestamp into the SQL Server 2005 database. An example of how the variable value looks is as follows,
00:00:01.500000 0
It represents the hours:mins:seco nds
Once i store a series of these values into the sql table, then i need to make a SUM of all these values. What would be the best datatype to use for this value. Please help me in this regard. -
Is it possible to accomplish the cascading drop down list by reloading the webpage. If yes, how ?... -
How to create a dependent drop down box ?
I have created a dropdown box which is populated by data from the mssql server database connected using ODBC. Now i need to populate another dropdown box which will also be from the database but will be based on the value selected in the already created dropdown box. The following is how i have created a dropdown box,
[php]
$sql_visitor= "SELECT DISTINCT Contained FROM IAIS_Ubisense";
$rs3=odbc_exec( $connection,$sq l_visitor);... -
I ran the phpinfo() function and i got long page listing all but the mssql extensions.
I have two .ini files in the path C:\PHP namely php-activescript.in i and php.ini. One was configured during active script installation. Should i remove that .ini file ?....Leave a comment:
-
It was me who had installed and configured the php. The SQL Server is also installed in the same computer. I am able to create an ODBC connection to sql server using php script....Leave a comment:
-
Please suggest a solution to the above error.Leave a comment:
-
Error Connecting to SQL Server 2005 using PHP script
I am trying to connect to the SQL Server and then to create a database table using PHP script. The code is as follows,[php]<job id="sqlserver1" >
<script language="PHPSc ript">
$connection = mssql_connect(' UIE-LAPTOP-01\SQLEXPRESS', 'pugalenthi' , 'Qwert1!');
mssql_select_db ('tempdb', $connection);
$sql = "CREATE TABLE Catalog(Catalog Id VARCHAR(25), Journal
VARCHAR(25), Publisher... -
I have set the formatting to Fixed, decimal places to 1 for the field AI_grade.
This is how i find AI_grade,
AI_grade: Round(([AI_1_grade]*3+[AI_2_grade]+[AI_3_grade]*2)/6,1)
the value of the expression ([AI_1_grade]*3+[AI_2_grade]+[AI_3_grade]*2)/6 is 1,6499999761581 4. I want this value to be rounded off to one decimal place, so that the value of AI_grade is 1,7. But the value what i get is 2,0 instead...Leave a comment:
-
I get a syntax error when i try the above in the query design....Leave a comment:
-
This is how i tried,
AI_grade: Round(([AI_1_grade]*3+[AI_2_grade]+[AI_3_grade]*2)/6,1)
and got the value for AI_grade as 2, instead of 1.7...Leave a comment:
-
I tried this already and got the value as 2 instead of 1.7. What could be wrong then ?....Leave a comment:
-
AI_grade: ([AI_1_grade]*3+[AI_2_grade]+[AI_3_grade]*2)/6
the above gives the value 1.6499999761581 4 for field AI_grade. Now i need the value of AI_grade to be 1.7 after round off. How to do it in the same query?....Leave a comment:
-
I actually use the query design view to generate the above value for a field. Is it possible to round off the above number using the Round() function in the query design....Leave a comment:
-
How to round a text box value in the access form
For example, i have a text box with value 1.6499999761581 4. How can i round it off to 1.7 ?.
Is this possible using the text box control properties ?. -
How can i add values in the fields of a table and store the result in a new field of the same table....Leave a comment:
-
How to perform mathematical operation on field values in a table ?
I want to add values of few fields in a row and then divide it by a constant value and store the result in a new field on the same row. How can i do this ?. -
But I was able to update the table when i used NewRow().
DataRow thisRow = thisDataSet.Tab les["Table"].NewRow();
thisRow["Exit_time"] = Exittime;
thisDataSet.Tab les["Table"].Rows.Add(thisR ow);
thisAdapter.Upd ate(thisDataSet , "Table");
The only difference was i got the Exittime entered everytime in a new row....Leave a comment:
-
How about modifying the table using SQL UPDATE command. Please help me in running the SQL update command in c# to perform the modification.Leave a comment:
-
I tried it, still im not able to modify the last row value....Leave a comment:
No activity results to display
Leave a comment: