i have a problem with syntax in my query andi, i have this
sqlStmt =
"SELECT Chron.ID, Chron.EmpID, Chron.WDate, Chron.OrID, Emplo.FName, Emplo.LName, Emplo.ID AS Expr1, Emplo.NUser,
Emplo.Passw FROM Chron INNER JOIN Emplo ON Chron.EmpID = Emplo.ID WHERE (Emplo.ID ='" & s1 &
"'AND Chron.WDate ='" &
"'"& s2 &
"')"
my problem is with the sigle and the double quotes, i tried some different methods but nothing.
im trying to import a CSV file, however a single quote has been used to enclose strings ie. 'aaaa','bbbbbb',ccccccc'
Im having problems because some strings contain commas or apostrophes ie... 'aaaa,aaa' , bbbbb'bbbb',
This is causing me trouble and i need to replace the enclosing character for all strings from a single quote to a double quote....
I dont have access to the source that the csv was generated from, I just have the CSV file..
Since both are acceptable by HTML as well as languages like ASP.NET and PHP when using attributes or strings, why is it that some people use single quotes and double quotes interchangeably? It is my understanding that it is syntactically correct to use double quotes where possible, single when you need to embed a double quote for inline logic. Is there something I am missing? For examples: HTML
<a href='[URL]
PHP
<? echo 'Hello World!'; ?>
ASP.NET
<form id='myForm' runat='server'></form>
In my database, there is a column "summary" with single quot in it.I am fetching this data inside Gridview. Data is shown inside Gridview as:
<summary>"
I want single quot to be shown inside Gridview as (')for that I tried to change the code as below:
<asp:GridView ID="GridView1" runat="server" Width="100%" BackColor="White" DataKeyNames="IssueId"
AutoGenerateColumns="False" AllowPaging="True" PageSize="8" CssClass="Grid" OnRowDataBound="GridView1_RowDataBound">
[code]....
using sql server 2005.I need to query some nchar fields to see if any of them contain string with double quotes (char(34)).whats the syntax to do this? I was thinking something like this but I think the first query would get exactly the text Char(34) when I only want to get the double quotes:SELECT fieldA FROM myTable where fieldA LIKE '%char(34)%'ORSELECT fieldA FROM myTable where fieldA LIKE '%'+char(34)+'%'
View 3 RepliesIam Facing the problem with Insert query in sql Server i want to insert value India's, Iam not unable insert 's in sql server DB.
View 17 RepliesI'm trying to get my URLs to contain double quotes (") and other special characters such as <, > etc in my MVC2 application. Here's an example:
[URL]
The above would throw up a System.ArgumentException: Illegal characters in path.
I have written this narly Select Statement for my site, this is for the data in my control panel, I did it this way to have only one access instead of six I currently have, but I keep gettin a syntax error near'customer_data'
I have tried several things, but I still get the error, could someone check for me please
[Code]....
As you can see I have aliased customer_data as CD
i am writing the following connection string into web.config but it giving me error.what is the correct way to write it?
<add name="stargaze_stargazeConnectionString1" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename="D:Work At DS19th Janmyastrolove.com_newApp_DatadbName.mdf";Integrated Security=True;User Instance=True"/>
I am using SQL Server 2008 Web Edition and it seems my SQL queries are automagically having the double quotes replaced with ' + CHAR(34) + '. I am trying to pin down why this is happening, I am using Delphi with ASP.NET and using the ADO.NET object for the SQL.
Has anyone come across this before?
how this string concatenation taking place? i am really confuse what is happening why that slash i there and how the double quotes are used
SessionStateItemCollection items = new SessionStateItemCollection();
items["LastName"] = "Wilson";
items["FirstName"] = "Dan";
foreach (string s in items.Keys)
Response.Write("items["" + s + ""] = " + items[s].ToString() + "<br />");
Response.Write("items["" + s + ""] = " + items[s].ToString() + "<br />");
I'm working in a Repeater over blog posts and I'm displaying a ShareThis JavaScript piece at the bottom. The Title and URL of the post are being sent to JS. In one test case, the title of a post has a single quote, e.g. Mark's test post Since I need to preserve that single quote when being sent to ShareThis, I need to wrap that JavaScript string in double quotes, however the string is being bound via a Literal and I cannot wrap the literal in double quotes: This is want I want but DOES NOT WORK:
SHARETHIS.addEntry({ title: "<asp:Literal ID="ltlTitle" runat="server" />", etc..
I can only wrap the literal with single quotes like so:
SHARETHIS.addEntry({ title: '<asp:Literal ID="ltlTitle" runat="server" />', etc..
But that will result in bad front-end code:
SHARETHIS.addEntry({ title: 'Mark's test post', etc..
How can I encode this correctly or somehow wrap the control in double quotes? I'm aware of HttpUtility.HtmlEncode and Server.HtmlEncode
How can I put " in this regular expression
Regex PhRegEx = new Regex(@"^[a-zA-Z0-9-+_,(): ]*$", RegexOptions.Compiled);
im using asp.net and somehow my escape characters dont seem to work
string testing = "my name is "abc"";
this gives the output : my name is "abc"
ive read all the tutorials, everywhere it says that ive to put " to use double quotes inside a string but i have no idea why my system isnt accepting the escape character.
I want user to allow double quotes(") in text box. I am trying it throught regular expression. How to put double quote (")in below expression.
[code]....
How to not allow < > in text box using regular expression.
Why does this
string test = "Text1, Text2";
string [] tests = test.Split(", ".ToArray());
returns this
[0] = "Text1"
[1] = ""
[2] = "Text2"
what's with the quotes in tests[1] ? I thought the output would be like this
[0] = "Text1"
[1] = "Text2"
I have string. There are no items to show in this view of the "Personal Documents" then assign to string str variable string str ="There are no items to show in this view of the "Personal Documents" library" Now planning to replace "" and make it to actual string to str object. I tried below, but did not worked
str = str.Replace(@"",string.Empty);
I want str value should be string str ="There are no items to show in this view of the "Personal Documents" library" I need to find this string in another string. While searching into that string. I couldn't found because str contains "".
How to disallow use of double quotes " in a textbox
View 5 RepliesI am trying to insert dynamic data into a onclick property for a control the code looks like this
onclick="openRadWindow('<%#Eval("ID";) %>','<%#Eval("ParentObjectID") %>');"
I cant get it to fire and the trouble seems to be the double quotes, what is the correct method on escaping the quotes so that this fires.
I am using .Net Framework 3.5 on an ASP.net web project using jquery.ajax to make web service calls. My web service returns objects serialized as JSON by specifying the content type of my POST as "application/json". I would like just one of my many properties to return a non quoted javascript function name instead of a quoted string. Serialized as such:
{"dataInit": functionName, "id": "myID"}
instead of
{"dataInit": "functionName", "id":"myID"}
In VS2008, it used to be that whenever I was typing an html attribute in an .aspx page when I hit '=' a pair of double quotes was automatically inserted and the cursor placed inside them. I guess I've changed a setting, but I don't know what to change to get that functionality back. I am using Resharper if it makes a difference.
View 1 Repliesi would like to insert text in sql server that contains words like select and a single quotation mark but sql server gives errors like if i wanna insert this :
View 1 Replieswhy ''' is not getting converted to single quotes while using server.htmldecode()?
What is the best way to do the decoding while using '"'"?
I have a hyperlink in asp.net that I want to dynamically create. I also add additional attributes like onmouseover to call a javascript function. My problem is that instead of setting my attribute to
onmouseover="myJSFunc('param')"
it converts it to
onmouseover="myJSFunc('param')".
Any ideas how to get this to work in ASP.NET C#?
EDIT:
These controls are in a repeater. This is what I have in my code behind;
hypNav.Attributes.Add("onmouseover", "myJSFunc('" + divNav.ClientID + "')");
n my datatable i am retrieving values which contain single quotes. .(eg: paul's, john's, raj's 199:LOQ etc. .) i want to replace these values with ''(double single quotes), so that these records can be inserted in the sqlserver database. . all these values are in single column.
View 3 Replies