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?
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>
I'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 wanna convert char to double type and convert it to date.char->double then double -> date type.I have a whole string and i trim it into 3 parts. In my item(2) is a UNIX Timestamp i'm trying to convert it into date type.
[Code]....
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"/>
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 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.
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 Repliesusing 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 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 RepliesIn 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]....
i'm a new developer...i have been given a project to generate a user name of 6 chars. the user name has 1st 2 char the 1st 2 letters of the name and remaining 4 char as any random numbers. alone with that i have to send a random password with it..
View 2 RepliesI recently found out about the andAlso operator, and I understood that it will only evaluate the right condition if the left is true, I thought this could help tidy my code so replaced nested ifs with AndAlso.
Private ds As DataSet
-----------
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
ds = nothing
If Not ds.Tables(0) Is Nothing AndAlso ds.Tables(0).Rows.Count > 0 Then
end if
end sub
I deliberately set my ds to nothing to replicate a database error and it gave me an object reference error.
I recently noticed that when a dll is replaced at my web site, the site will take a long time to come back, even though the dll is only used by limited pages. I generally have to reset IIS to make the web site come back faster. Is this the normal behavior? or some settings need to be ajusted to avoid this?
View 1 RepliesI am trying to replace a value in a drop down box. The replacing works fine (after help from this fine community) but afterwards the slide function stops working. I can't find any errors so I'm asking if this could be related to how jQuery and javaScript works? Are elements "mapped" to the DOM on load and if so; would that imply that replacing a div with another div would result in jQuery loosing track of the divs? I use this code to check if a div is clicked:
$(document).ready(function () {
$('.button_slide').click(function () {
var num = $(this).attr('rel');
$('div.content_slide:not(.' + num + ') ').slideUp(400);
$('div.' + num).slideToggle(400);
});
return false;
});
This is the div:
<div class="button_slide" rel="slide1">Alts:</div>
<div class="content_slide slide1">
<input id="Button1" rel="slide1" class="button_vertical click_button" type="button" value="2" size="10px" />
<input id="Button2" rel="slide1" class="button_vertical click_button" type="button" value="3" />
</div>
This is the jQuery that drops down the box:
$(function () {
$('.click_button').click(function () {
var num = $(this).attr('rel');
$('.button_slide[rel="' + num + '"]').replaceWith("<div class='button_slide' rel='" + num + "' >" + $(this).val() + "</div>");
$('div.content_slide').slideUp(600);
});
});
I'm pulling my hair on this one and jQuery isn't my stronger side... How would you solve this?
i have a radeditor in my webform and it posts back. if i type any thing in the editor and press enter key for new line and then use any control in the page which reloads the page, then the next line character in the editor gets replaced by $0 and other text remains same as earlier. it happens in SAFARI.
Ex.
aasdads
dsdsds
the above text replaced by: aasdads$0dsdsds$0
