hiii urgent

[ishwarya mahadevan]

hi i need to make an entry in the session table once the user logs. need to use web service methods for everything. i ve written a stored prov for login and within that i ve called the session procedure. while running web service method i m getting an error "string or binary truncated. statement has been terminated". as i couldnt spot the error i tried writing a separate method for session in webservice and tried calling it from login method. i m not getting any error but the entry is not made in the session table. can anyone help me out?

[Brij]

First read How-to-get-an-answer-to-your-question

Cheers!! Brij

[ishwarya mahadevan]

may i know what was the problem??? i dint ask for the coding too...i just wanted to know where i had gone wrong...

[Brij]

Didn't read the link that I mentioned ."3.Keep the subject line brief, but descriptive.".Also somthing may be urgent for you not for others..

Cheers!! Brij

[Abhijit Jana]

So, you want to store session information in a table from Web Services ? or any thing else you are expecting ? Can you please rephrase your question. :confused:

Cheers ! Abhijit Codeproject MVP

[ishwarya mahadevan]

ya i want to store session information in table from web service

[Abhijit Jana]

< Updated Subject > So, what you have written in your code? Can you please show us the code? Did you debugeed your code? Are you able to access session variable in Web service ? :)

Cheers ! Abhijit Codeproject MVP

[saanj]

The length of the value that you are going to put in the column is exceeding the size of the column. Just compare the lentgh of the value with the columns data size.

There is no foolish question, there is no final answer...