Wednesday, December 3, 2008
"Incorrect number of arguments for PROCEDURE sproc_t_l_Contract_Select_BySearchCriteria; expected 3, got 2”
Work long time on this sp but coudnt find it. So i tried to write it again from the begining. In this time it was work perfectly.This problem occurs because of the space between data type and its length.
pName varchar(50) - working
pName varchar (50) - Not working
But it does not mention syntax error or something.So this error message make us vulnerable.
project we had to used many client tools because each tool having pros and cons. we used following client tools;
Toad for MySQL
Nevicat 8.0 Lite
Among those tools SQLyog Community edition the best tool even though Toad for MySQL provides many features.Toad for MySQL sometimes gives errors when running a query.Nevicat 8.0 Lite is simple and good.But it has not much features. HeidiSQL is also good but it doesn't show other database objects such as stored procedures,view. Only tables are displayed.
Tuesday, November 25, 2008
As a solution for this what we can we do is, we can call a function as this way
There for because of the none existence of this function this will be raise an error.
So it is very logical..:-)
So procedure will be work very fine.....Great...
DROP PROCEDURE IF EXISTS `dbname`.`procedureName` $$
CREATE DEFINER=`root`@`%` PROCEDURE `edbname`.`procedureName`(
((Id = pId)
Name = pName,
(Id = pId);
/*There is no RaiseError metho in MySql.
Because of that reason here call nonexistent method which is 'RaiseError()'.There for this will produce an error*/
Friday, November 21, 2008
When buying things like clothes, set a rule for yourself that you can only buy something new, to replace something you already have. For example, from a practical point of view, let’s say you need to have 15 business shirts. Set a ‘budget’ of having 15 shirts, and then when you want to buy one, first throw away (or give to charity) the worst of the other. Can’t make a choice which one to throw out? Guess what: you won’t need a new shirt.
Even if you mannually typethe connection string and click on 'Test' button it will say Mysql.data.dll not exist.
This is because of compatibility issue...
To sortout this.....:-)
So i had t installed earlier version. It also did not work. So copy 'MySql.Data.dll'
to bin folder of codesmith (C:\Program Files\CodeSmith\v5.0\bin). Mannaully type the connction string and test. Then it will works fine................................
Thursday, November 20, 2008
- Create a new table with the required columns,
- Copy the data from the old table into the new table
- Delete the old table
- Then rename the new table.
Create Table A
(col1 varchar(50) null,
col2 varchar(50) null)
--Add new column col3
Create Table B
col1 varchar(50) null,
col3 varchar(50) null, -- NEW COLUMN IN MIDDLE (NULLABLE)
col2 varchar(50) null
if exists(select * from A)
exec('insert into B (col1, col2)
select col1, col2 from A with (holdlock tablockx)')
drop table A
execute sp_rename 'B', 'A', 'object'
Wednesday, November 19, 2008
This is new topic for me and I started to work on that few days ago. It is interesting to play and I learn lot during the days. :-) .Learning curve of the NHibernate is bit long and few resources are available. But using trial and error could be able to solve lot of problems.
What is ?
NHibernate is ORM solution and is intended for transparent binding .NET classes to database tables.Commonly we have mismatch beween the relational database and our objects. The aim of the NHibernate is reducing time efforts to switch application to another database provider .Basically it provides low overhead .
“NHibernate increases your performance as a developer”.
Monday, November 17, 2008
Sunday, June 1, 2008
Using COM objects you can read the word document.By doing following thing you can achieve it.
Steps you should follow;
Add a COM reference to the project by right clicking in
the solution explorer on References->Add Reference. Click on the COM
tab and look for the Microsoft Word 9.0/Microsoft Word 11.0/ Microsoft Word 12.0 Object Library. Click Select and OK.
In here the object library version depends on your MS.office package what you have installed in your machine .example: If it s Office 2007 the Microsoft Word 12.0 Object Library
using Word = Microsoft.Office.Interop.Word;
public partial class _Default : System.Web.UI.Page
protected void Page_Load(object sender, EventArgs e)
protected void btnSubmit_Click(object sender, EventArgs e)
object missing = System.Reflection.Missing.Value;
Word.ApplicationClass wordApp = new Word.ApplicationClass();
// Input box is used to get the path of the file which has to be
//uploaded into textbox.
string filePath = filePath.Text;
object file = filePath;
object nullobj = System.Reflection.Missing.Value;
// here on Document.Open there should be 16 arg.
Word.Document doc = wordApp.Documents.Open(ref fileName, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing);
Word.Document doc1 = wordApp.ActiveDocument;
string m_Content = doc1.Content.Text;
// the content is stored into the textbox.
txtDisplay.Text = m_Content;
doc.Close(ref nullobj, ref nullobj, ref nullobj);
<----------------Source code -------->
Enjoy and play with COM objects.
Tuesday, February 19, 2008
Ben Shneiderman is a giant person in information visualization field and he has contributed for many theories in this field. He has coined what he calls information visualization mantra that leads to information seeking behavior:
“Overview first, zoom and filter, then details on demand”The important point is that a good computer-based visualization is an interface that can support all of these activities. According to this mantra; system should represent the overview of the entire collection, any interested item should be able to zoom, able to filter out uninteresting items, and also able to select an item or group and
get details when needed. Any system which follows this mantra can be representing the high volume of information in an effective manner. Figure 1 shows application (Ex: Spotfire) which built upon using this mantra. In this application entire item collection are displayed and any item can be
Monday, January 21, 2008
Tuesday, January 15, 2008
Thursday, January 10, 2008
- physical-based model
- biological inspiration
In 1973, Herman Chernoff introduced a visualization technique to illustrate trends in multidimensional data. Normally we change our expression time to time. But we can easily identify them if there is slightly different. This concept is the base for Chernoff faces technique. Different data dimensions were mapped to different facial features, for example the face width, the level of the ears, the radius of the ears, the length or curvature of the mouth, the length of the nose, etc. Chernoff faces are just a cartoon like faces. With this faces we can display complex multivariate data. They draw upon the human mind's natural ability to recognize small differences in facial characteristics and to understand many facial characteristics at once. Several Variables can be assigned to facial characteristic and according the condition expressions can be generated.
As an example, here are some team statistics from the 2005 baseball season represented in a table and then as a series of Chernoff Faces:(Go)
2005 National League
In here we are using JADE flatform and Protege to develp the the system.
A heart-warming, triumph-over adversity drama, AKEELA AND THE BEE centers on a precocious eleven-years-old girl, Akeelah Anderson, form south Los Angels, who is discovered to have a talent for words. In spite of the objections of her mother Wanda,Keke enters a spelling contest. Her gift takes her to compete in the National Spelling Bee, the most famous competition of its kind in the world….
One of fabulous phrase attached with this film
“Pulchritude-its derive form Latin word pulcher meaning Beautiful .Isn’t it?
You know that feeling where everything feels right? Where you don't have to worry about tomorrow or yesterday, where you feel safe and know you're doing the best you can? There's a word for that, it's called love.
Friday, January 4, 2008
“The use of computer-supported, interactive, visual representations of abstract data to amplify cognition.”
I feel if Ptolemy did not find a way to represent a location still we don't know where we are in this world. This is a simple example which shows, to amplify our cognition there should be a stimuli.
Then information visualization is highly efficient way for the mind to directly perceive data and discover knowledge and insight from it. So lots of researches are going on this area. The reasons for that is
- Human beings are tremendously influenced by sensory perceptions
- The way that we learn, grow, understand, and adapt is based on our ability to view, perceive, and conceptualize thoughts and ideas
- The power to visualize and graphically represent results, ideas, solutions, and problems in multiple dimensions, as well as to manipulate data and virtually collaborate with others, is the next big revolution in technology.
- This will help to user to reach a decision without much effort.
These reasons may be the root course to born following Chinese proverb
“Tell me and I’ll forget…
Show me and I may remember…
Involve me and I’ll understand.”
That is why information visualization plays major role in following areas.
Medical Science,Financial Sector,Data mining,Software visualization,Geographic visualization,Forecasting,Morphological analysis,Cave Automatic Virtual Environment.
There are lot of dimensional types exist in information visualization
• One-dimensional (1D)
• Two-dimensional (2D)
• Three-dimensional (3D)
• Multi-dimensional (MultiD)
More detail of about this dimension are available