View Complete Post
Hi, I am new to asp.net and I don't know what to do on this problem, can someone give me a hint/advice on how I can make my insert do the task, here is my stored procedure:
I know that it is basic questions, but I am stuck here.
I have TableOne have fields: USERNAME, PID, GID, TID, SID, NEWSID. I need to write query string to check if those value is already in the table. If not, insert those value to the table.string AddUserName = UsernameToken(GetUsername);string InsertString = "insert into TableOne(USERNAME, PID, GID, TID, SID, NEWSID) values (?, ?, ?, ?, ?, ? )" + " WHERE NOT " + " ( " [USERNAME] = '" + AddUserName + "' + " PID = '" + DropDownBoxPID.Text.Trim() + '" + " AND " + " GID = '" + DropDownBoxGID.Text.Trim() + '" + " AND " + " TID = '" + DropDownBoxtid.Text.Trim() + '" + " AND " + " SID = '" + Textboxsid.Text.Trim() + '" + " AND " + " NEWSID = '" + DropDownssid.Text.Trim() + '" + ")" ;
However, I got the many errors:
Error 1 Too many characters in character literal
Error 3 Newline in constant
Is any way to debug this? As always, your help is highly a
Make Sense? Is there anything I can do about this?
I am having the requirement where I have to use string as measures. Is this possible in Analysis services 2K.
Any help on this will be greatly appreciated