Click here to Skip to main content
15,915,764 members
Home / Discussions / ASP.NET
   

ASP.NET

 
AnswerRe: Can I set a field Value in a loading ASPX page? Pin
SABhatti21-Nov-07 12:51
SABhatti21-Nov-07 12:51 
Questionhow to display table column data are starting letter in capital letter Pin
Murugan.nett21-Nov-07 8:22
Murugan.nett21-Nov-07 8:22 
AnswerRe: how to display table column data are starting letter in capital letter Pin
SABhatti21-Nov-07 8:51
SABhatti21-Nov-07 8:51 
AnswerRe: how to display table column data are starting letter in capital letter Pin
Frank Kerrigan21-Nov-07 10:07
Frank Kerrigan21-Nov-07 10:07 
AnswerRe: how to display table column data are starting letter in capital letter Pin
IssamK21-Nov-07 10:56
professionalIssamK21-Nov-07 10:56 
QuestionDatabind Image control inside a repeater Pin
Paul McGann21-Nov-07 7:08
professionalPaul McGann21-Nov-07 7:08 
AnswerRe: Databind Image control inside a repeater Pin
SABhatti21-Nov-07 8:13
SABhatti21-Nov-07 8:13 
QuestionToo many literals in the string.. Pin
Ibuprofen21-Nov-07 5:07
Ibuprofen21-Nov-07 5:07 
Can you double check my syntax on this? I keep getting an error of too many literals in the string

ScnQuestionNo and MeasID are number fields

<br />
string strInsert ="Insert INTO DataElements (Checked, Requirement, RequirementTitle," + <br />
					" MeasID,DeNr, Duplicate, LiveQuestionNo, ScnQuestionNo, DataElement, Form, QType," +<br />
					" Format, [Default], SME, [User], SA, IASME, Security, [Table], FieldName," + <br />
					" TQScenario, TQLive, Subtitle, DA) Values (" + Convert.ToInt16(ckChecked.Checked) + ",'" + Requirement.Text + "','" +RequirementTitle.Text+ "'," + MeasID.Text + ",'" + DeNr.Text + "'," + Convert.ToInt16(ckDuplicate.Checked) + ",'" + LiveQuestionNo.Text + "'," + ScnQuestionNo.Text + ",'" + DataElement.Text + "','" + Form.SelectedValue + "','" + QType.SelectedValue + "','" + Format.Text + "','" + Default.Text + "'," + Convert.ToInt16(ckSME.Checked) + "," + Convert.ToInt16(ckUser.Checked) + "," + Convert.ToInt16(ckSA.Checked) + "," + Convert.ToInt16(ckIASME.Checked) + "," + Convert.ToInt16(ckSecurity.Checked) + ",'" + TableName.SelectedValue + "','" + FieldName.Text + "'," + Convert.ToInt16(ckTQScenario.Checked) + "," + Convert.ToInt16(ckTQLive.Checked) + ",'" + Subtitle.Text + "'," + Convert.ToInt16(ckDA.Checked) + ")";<br />
<br />
<br />


Here's my debug output:


strInsert: "Insert INTO DataElements (Checked, Requirement, RequirementTitle, MeasID,DeNr, Duplicate, LiveQuestionNo, ScnQuestionNo, DataElement, Form, QType, Format, [Default], SME, [User], SA, IASME, Security, [Table], FieldName, TQScenario, TQLive, Subtitle, DA) Values (0,'Unk','Unk',,'DE 0.1.17',0,'',,'Last four digits of SSN','Demographics','N/A','char','',0,0,0,0,0,'Demographics','LastFour',0,0,'N/A',0)"


Now I get "Line 1: Incorrect syntax near ','."
AnswerRe: Too many literals in the string.. Pin
Pete O'Hanlon21-Nov-07 5:09
mvePete O'Hanlon21-Nov-07 5:09 
GeneralRe: Too many literals in the string.. Pin
Ibuprofen21-Nov-07 5:13
Ibuprofen21-Nov-07 5:13 
GeneralRe: Too many literals in the string.. Pin
Pete O'Hanlon21-Nov-07 9:25
mvePete O'Hanlon21-Nov-07 9:25 
GeneralRe: Too many literals in the string.. Pin
Ibuprofen21-Nov-07 9:36
Ibuprofen21-Nov-07 9:36 
GeneralRe: Too many literals in the string.. Pin
Not Active21-Nov-07 10:17
mentorNot Active21-Nov-07 10:17 
GeneralRe: Too many literals in the string.. Pin
Colin Angus Mackay21-Nov-07 10:24
Colin Angus Mackay21-Nov-07 10:24 
AnswerRe: Too many literals in the string.. Pin
J$21-Nov-07 9:51
J$21-Nov-07 9:51 
AnswerRe: Too many literals in the string.. Pin
Not Active21-Nov-07 10:19
mentorNot Active21-Nov-07 10:19 
Questioncontrols in collections Pin
filinM21-Nov-07 4:08
filinM21-Nov-07 4:08 
AnswerRe: controls in collections Pin
szukuro21-Nov-07 4:42
szukuro21-Nov-07 4:42 
Questionguide to beginner (Implement business logic algorithm) Pin
raquidd2221-Nov-07 3:40
raquidd2221-Nov-07 3:40 
AnswerRe: guide to beginner (Implement business logic algorithm) Pin
Frank Kerrigan21-Nov-07 10:10
Frank Kerrigan21-Nov-07 10:10 
GeneralRe: guide to beginner (Implement business logic algorithm) Pin
raquidd2221-Nov-07 16:13
raquidd2221-Nov-07 16:13 
QuestionDisplaying Dynamic Template columns Gridview Pin
irkahc21-Nov-07 3:27
irkahc21-Nov-07 3:27 
QuestionPick Id Under Working GridView Pin
Rinki Mukheraji21-Nov-07 3:09
Rinki Mukheraji21-Nov-07 3:09 
AnswerRe: Pick Id Under Working GridView Pin
SABhatti21-Nov-07 5:38
SABhatti21-Nov-07 5:38 
AnswerRe: How To Display Hierarchical Data by Using Nested Repeater Controls Pin
SABhatti21-Nov-07 5:33
SABhatti21-Nov-07 5:33 

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.