| Author |
 Topic  |
|
kwikwisi
Constraint Violating Yak Guru
278 Posts |
 Posted - 04/14/2008 : 05:48:21
|
i mean some sentenses are saved completely but some are saved partially.
quote:
Originally posted by Peso
Also, which long sentences are stored, and which are not stored?
E 12°55'05.25"
N 56°04'39.16"
|
 |
|
|
kwikwisi
Constraint Violating Yak Guru
278 Posts |
Posted - 04/14/2008 : 05:52:47
|
this is result of ur queryplz check
UserID 1 int null
ProblemID 2 int null
ProblemDescription 3 text 2147483647
ProblemAnswer 4 text 2147483647
ProblemResolution 5 text 2147483647
Chk 6 int null
quote:
Originally posted by Peso
You tell me.
Run this code and post back the resultSELECT COLUMN_NAME,
ORDINAL_POSITION,
DATA_TYPE,
CHARACTER_MAXIMUM_LENGTH
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'TempAns'
E 12°55'05.25"
N 56°04'39.16"
|
|
|
|
SwePeso
Patron Saint of Lost Yaks
Sweden
29138 Posts |
Posted - 04/14/2008 : 05:55:04
|
Do you have some examples of the sentences that DO NOT save?
Do you have some examples of the sentences that DO save?
Also, I am still waiting for the output from the query I gave you earlier.
E 12°55'05.25"
N 56°04'39.16" |
|
|
|
kwikwisi
Constraint Violating Yak Guru
278 Posts |
Posted - 04/14/2008 : 05:58:15
|
for example:
save this one
"User received fax from abuse department stating that they had suspended his IP due to open proxy issue. Ping and traceroute test did show IP could be suspended. Clarify with abuse department and confirm account suspended, will lift suspension only if they ensure network is cleared."
but don't save this one
"Using ST 585, DSL led stable but internet led light red. User had rebooted the router but still cannot connect. Radius log did not show any bad password."
save partially like that
"Using ST 585, DS"
E 12°55'05.25"
N 56°04'39.16"
[/quote] |
|
|
|
SwePeso
Patron Saint of Lost Yaks
Sweden
29138 Posts |
Posted - 04/14/2008 : 06:43:58
|
Do you get any error messages?
Do you run a cached ASP-page which do not have the new parameter value?
Do you get any error messages when saving?
If so, which ones?
E 12°55'05.25"
N 56°04'39.16" |
|
|
|
kwikwisi
Constraint Violating Yak Guru
278 Posts |
Posted - 04/14/2008 : 10:31:05
|
sorry for my late message
no error found in saving ,
but when i check in database table and retrieve data i see only some portion of data was saved.
i've got no error msg in execution. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
Sweden
29138 Posts |
Posted - 04/14/2008 : 10:41:06
|
You do realize that Query Analyzer and SSMS only retreives the first 256 characters back to QA or SSMS for viewing,
and all characters when update and insert?
Run this query
SELECT DATALENGTH(ProblemAnswer), ProblemAnswer
FROM TempAns
to see what you get...
I can imagine that you have exactly the same problem in your code when fetching the data (as you had when inserting the data).
E 12°55'05.25"
N 56°04'39.16" |
Edited by - SwePeso on 04/14/2008 10:41:38 |
|
|
|
kwikwisi
Constraint Violating Yak Guru
278 Posts |
Posted - 04/14/2008 : 21:25:18
|
Hmm...
how can i solve this problem?
should be all save or not save.
but now, some sentense are saved completely and some partially.
how can i understand  |
Edited by - kwikwisi on 04/14/2008 21:43:20 |
|
|
|
kwikwisi
Constraint Violating Yak Guru
278 Posts |
Posted - 04/14/2008 : 22:39:11
|
hi peso,
now saved all completely and works well
thanks alot |
Edited by - kwikwisi on 04/14/2008 22:43:22 |
|
|
|
SwePeso
Patron Saint of Lost Yaks
Sweden
29138 Posts |
Posted - 04/15/2008 : 03:11:16
|
Please tell us what you changed to make it work.
E 12°55'05.25"
N 56°04'39.16" |
|
|
|
kwikwisi
Constraint Violating Yak Guru
278 Posts |
Posted - 04/15/2008 : 09:10:53
|
Actually i have 2pages to modify parameter length and i changed only in one page.i forgot another page to modify.
your given solution is right.
That's my fault  |
|
|
|
SwePeso
Patron Saint of Lost Yaks
Sweden
29138 Posts |
Posted - 04/15/2008 : 09:21:30
|
Thanks for the feedback.
E 12°55'05.25"
N 56°04'39.16" |
|
|
|
Topic |
|
how many charaters can save in text datatype?
