|
r u a programmer or trainee.
SSK.
Anyone who says sunshine brings happiness has never danced in the rain.
|
|
|
|
|
hi!
My problem is:
I HAVE A 3 COLUMNS(ID,NAME&CITY) IN TABLE T1.
IN MY TABLE MY (ID) COLUMN HAS NO VALUE. BUT OTHER TWO COLUMN HAS ITS OWN SAME VALUE.
eg: OUR (NAME) COLUMN HAS ONLY CONTAIN "VICKY" IN WHOLE COLUMN. AND
(CITY) COLUMN HAS ONLY CONTAIN "DELHI" IN WHOLE COLUMN.
MY REQUIREMENT IS THAT, I WANT TO INSERT THE VALUE IN ID COLUMN AS 1,2,3 AND SO ON.
PLEASE SOLVE MY PROBLEM
THANKS
|
|
|
|
|
if you're using SQL Server, declare the ID column as an Identity column. google this out yourself. You need to specify it as an identity field with a seed and increment value and SQL Server will handle the rest itself.
Hope it solves ur problem
|
|
|
|
|
hi sir!
Sir I don't know what is the procedure to add the identity in my table. beacuse my table has been already created.
please help me.
bye
|
|
|
|
|
|
a/c to your advice i did. but folloeing errors occured. because in id column contain null value
------
'T1' table
- Unable to modify table.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'ID', table 'Zaid.dbo.Tmp_T1'; column does not allow nulls. INSERT fails.
[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.
-------
|
|
|
|
|
how many records do u have in that table already?
Can u afford to delete that table and create it again?
|
|
|
|
|
sorry sir, I can't delete because that is the problem.
|
|
|
|
|
yes I think Bob got to the root of that problem, I really think you'd read some manuals atleast to get to grips with this. try removing the ID column from the insert statement
|
|
|
|
|
Thts because you need to omit identity columns from your insert.
It seems you have very little understanding of sql, I suggest you read up on it before going much further.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
hi,
please check http://www.golsinc.com/app7/
i need to make it in such way that when user moves his pointer inside the image, it generates coordinated inside the textbox. after one click it stores the value the when again user moves his pointer then movement looks inside 2nd textbox.
likewise he does for 3rd textbox.
Currently in this application i am not able to show changing values on mouse move. all 3 types of clicks creates rectsngle, square and tringle.
Help me please. I am making this application in Asp.net. You may help me with Javascript code also.
Thankx
Any Movie, Software, Song, Game and many more.... Only at Developer's Solution
http://www.devsol.co.nr
Search Any Torrent You Want
A Software for Torrent search only....
Must check it
...VAIBHAV SARAN
vikysaran@gmail.com
|
|
|
|
|
how to copy Data at fast performance.
Piyush Vardhan Singh
p_vardhan14@rediffmail.com
http://holyschoolofvaranasi.blogspot.com
http://holytravelsofvaranasi.blogspot.com
|
|
|
|
|
The answers posted by me are suggestions only and cannot be used in anyway against me.
|
|
|
|
|
How to reduce time of copy through IO.copy method or any other solution.
Please Help me.
Thanks
Piyush Vardhan Singh
p_vardhan14@rediffmail.com
http://holyschoolofvaranasi.blogspot.com
http://holytravelsofvaranasi.blogspot.com
|
|
|
|
|
I have made a simple application which will do a callback to the server side. Means I have used ICallbackEventHandler to get RaiseCallbackEvent to be called from javascript.
Here in the callback I need to get the content of another page just similar to what Server.Execute does.
Is it possible to request a page from server side and load it into a div, which we do from client using XMLHttpRequest, without moving the context to that page.
Please let me know.
Abhishek Sur
|
|
|
|
|
no one to answer my query..... 
Abhishek Sur
|
|
|
|
|
I am using asp.net 2.0 with C#.
In my application i have to put a icon on the left of URL.as in codeproject.com have.for it i am using this code,
<head id="Head1" runat="server">
<link rel="sortcut Icon" href="favicon.ico" type="image/x-icon"/>
</head>
but this is not working.icon is not shown with url.
can any one tell me me how i show favicon icon with my application.
thanks
|
|
|
|
|
Make sure the image is 16x16px. I had a problem when this wasnt the correct size and it didnt show.
The answers posted by me are suggestions only and cannot be used in anyway against me.
|
|
|
|
|
Thanks for replying me.
I make that image 16X16 px.
but its not shown.
I am IE7.
thanks
|
|
|
|
|
ARe you using a masterpage with your website. The favicon has to go in your masterpage.
Below is the code I am using and it works fine:
Try deleting the cache in your browser and then closing and opening it again.
The answers posted by me are suggestions only and cannot be used in anyway against me.
|
|
|
|
|
thanks for replying me.
some time i used masterpage and some time simple page.
now icon shown on FireFox,but on IE still not shown.
how i will rectify it.
also i removed history and cache may time.
but still not working.
i cant understand it.
thanks
|
|
|
|
|
Sorry Im not really sure.
Check out some articles on creating a favicon and make sure you have followed everything perfectly.
The answers posted by me are suggestions only and cannot be used in anyway against me.
|
|
|
|
|
thanks a lot.
when i got any solution i will tell u too.
thanks a lot once again.
|
|
|
|
|
I have to validate input text boxes for the below sample character.
NI╤O TARAZONA [Notice a special character in the string]. There ca n be many more special characters like this. These are accents and not a regular english character.
So we thought of handling these issues to validate the text for the range of ASCII characters 32 to 126. Is there a way we can do it? I wrote a regular expression but it never worked.
I'll appreciate any leads on this.
Regards,
Pavas
|
|
|
|
|
Hello Friends,
I want to display images like google image result.
How to disply it.
Please help me,
Thanks in advance.
Adarsh
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
