Click here to Skip to main content
15,921,793 members
Home / Discussions / Web Development
   

Web Development

 
AnswerRe: how to pass a javascript variable into asp variable? Pin
led mike21-Sep-07 4:38
led mike21-Sep-07 4:38 
GeneralRe: how to pass a javascript variable into asp variable? Pin
Guffa22-Sep-07 7:55
Guffa22-Sep-07 7:55 
Questionhow to auto adjust pages Pin
harryforum20-Sep-07 23:18
harryforum20-Sep-07 23:18 
AnswerRe: how to auto adjust pages Pin
Christian Graus21-Sep-07 0:35
protectorChristian Graus21-Sep-07 0:35 
AnswerRe: how to auto adjust pages Pin
saini arun21-Sep-07 4:14
saini arun21-Sep-07 4:14 
Questionjsp javascript compatibility issues in safari Pin
nicetohaveyou20-Sep-07 20:53
nicetohaveyou20-Sep-07 20:53 
AnswerRe: jsp javascript compatibility issues in safari Pin
saini arun21-Sep-07 4:20
saini arun21-Sep-07 4:20 
QuestionDouble quote error in Saving Pin
hifiger200420-Sep-07 13:03
hifiger200420-Sep-07 13:03 
Hi,

I have encountered problem when saving string value with double quote in it. When I attempt to save it into the mssql database an error message will display.

Example:
Textbox1.text content is - Round Bar 1/2" dia.

Dim sItemID = "00001"
Dim sDescription = Textbox1.text

Dim ItemCmd = New SQLCommand("Insert into Item " _
& "(" _
& "ItemID, " _
& "Description " _
& ")" _
& "Values " _
& "(" _
& "'" & sItemID & "'," _
& "'" & sDescription & "'" _
& ")"

During saving the error will occur:

String or binary data would be truncated.
The statement has been terminated.


The error will be fixed if I add the "SET ANSI_WARNINGS OFF" in my sql statement, but this is not the ultimate solution because the double apostrophe or quotation will be removed by the system itself when saving.


And, if I removed the "SET ANSI_WARNINGS OFF" this error will display:

Unlclosed quotation mark


Is there a way to resolve it?

I have been solving this for two days already and no luck yet.

Thanks Guys







hifiger2004

AnswerRe: Double quote error in Saving Pin
Guffa20-Sep-07 22:36
Guffa20-Sep-07 22:36 
AnswerRe: Double quote error in Saving Pin
hifiger200421-Sep-07 4:59
hifiger200421-Sep-07 4:59 
AnswerRe: Double quote error in Saving Pin
Paddy Boyd21-Sep-07 4:44
Paddy Boyd21-Sep-07 4:44 
QuestionConvert date string into javascript date object in 'yyyy-MM-dd' and 'yyyy.MM.dd' formats Pin
Alagumani20-Sep-07 2:47
Alagumani20-Sep-07 2:47 
AnswerRe: Convert date string into javascript date object in 'yyyy-MM-dd' and 'yyyy.MM.dd' formats Pin
Guffa20-Sep-07 3:24
Guffa20-Sep-07 3:24 
AnswerRe: Convert date string into javascript date object in 'yyyy-MM-dd' and 'yyyy.MM.dd' formats Pin
Shog920-Sep-07 9:10
sitebuilderShog920-Sep-07 9:10 
Questionfind How Many SQL server Present in network Pin
Sachin Pimpale20-Sep-07 0:13
Sachin Pimpale20-Sep-07 0:13 
QuestionDreamwaver visualization help [modified] Pin
saadani19-Sep-07 23:05
saadani19-Sep-07 23:05 
QuestionSend mail through ASP Page.......... Pin
suveenmohan19-Sep-07 23:01
suveenmohan19-Sep-07 23:01 
AnswerRe: Send mail through ASP Page.......... Pin
Christian Graus20-Sep-07 0:54
protectorChristian Graus20-Sep-07 0:54 
AnswerRe: Send mail through ASP Page.......... Pin
kuyak200024-Sep-07 19:49
kuyak200024-Sep-07 19:49 
QuestionHow to use Enterprise Library for Data Access from SQL2005 Pin
babutkchn19-Sep-07 3:35
babutkchn19-Sep-07 3:35 
AnswerRe: How to use Enterprise Library for Data Access from SQL2005 Pin
Brent Lamborn21-Sep-07 9:19
Brent Lamborn21-Sep-07 9:19 
QuestionHow to Dynamically populate Checkbox in Gridview asp.net 2.0 Pin
SJSaranya19-Sep-07 3:12
SJSaranya19-Sep-07 3:12 
AnswerRe: How to Dynamically populate Checkbox in Gridview asp.net 2.0 Pin
saini arun19-Sep-07 4:27
saini arun19-Sep-07 4:27 
QuestionAlerting the user to save before leaving the page Pin
samerh19-Sep-07 3:08
samerh19-Sep-07 3:08 
AnswerRe: Alerting the user to save before leaving the page Pin
Pete O'Hanlon19-Sep-07 4:02
mvePete O'Hanlon19-Sep-07 4:02 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.