Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







Remove Double Quotes


if l have a field conating data that has quoutes around it like field idno "2809085009084 ". How would l remove the quotes ????


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
Single Quotes And Double Quotes
I had a procdure in SQL 7.0 in which I am using both single quote and double quotes for string values. This proceudreused to work fine in SQL 7.0 but when I upgraded SQL 7.0 to SQL 2000, this proceudre stopped working. When I changed the double quotes to single quotes, it worked fine.

Any Idea why ??

Thanks

Manish

View Replies !   View Related
Double Quotes
Hi,
I am creating a flat file connection to a .csv file
In the columns section of the flatt file connection manager editor, I am not sure why the texts in the .csv file are shown with double quotes arouond them.
They do not have "" in the .csv file.
Thanks

View Replies !   View Related
Double Quotes Replacement
Hi,It seems to be simple, however, it stumbles me.how to replace all the double quotes (") within the followingsentence (or a column) with single quotes ('),colA = this is a freaking "silly" thing to dointocolA this is a freaking 'silly' thing to doSelect Replace(colA,'"',''')[color=blue]>From tblXYZ[/color]won't work,Select Replace(colA,'"',"'")[color=blue]>From tblXYZ[/color]won't work neither.How come? Thanks.

View Replies !   View Related
Contains Predicate And Double Quotes
I have been searching for an escape character or a way of escapingdouble quotes that are actually in a string that I am using in thecontains predicate.Here is an exampleselect *from tablewhere contains(field, '"he said "what is wrong", that is what hesaid"')I need the double quotes in the string because they are part of thetext. Of course, Fulltext search raises the errorServer: Msg 7631, Level 15, State 1, Line 1Syntax error occurred near 'what is wrong", that is what he said'.Expected ''''' in search condition '"he said "what is wrong", that iswhat he said"'.If I remove the double quotes, the search does not return the properresults.Thanks in advance for the helpBill

View Replies !   View Related
BCP And Commas/double-quotes
Hello all,

I am using SQL Server 6.5 SP5a.

I have to use bcp to import two text files everyday for database update. The problem is that some of the character fields that are being imported have double-quotes and/or commas in them. When these are imported into the SQL Server tables additional double quotes are being added into these strings.

Example:
INCOMING STRING = a"a
IMPORTED STRING = "a""a"

INCOMING STRING = b,b
IMPORTED STRING = "b,b"


I have searched through BOL and have not been able to find any information.

Does anyone know what is causing this and if so how to correct it?

Thanks,

Bryan Ziel

View Replies !   View Related
Losing Double Quotes??
Hi,

I have written a little bit of VB.NET code that basically takes three strings, transforms them, and returns a single string to be stored in my table.

I am running into a strange problem, however... for some reason, a number of my processed rows are missing a pair of double quotes (").

The vast majority of the records are formatted properly, and have the double quotes in the expected locations.

The most frustrating thing about it is that I have included the offensive input strings in my Test.sql test script, and when I step through the entire routine, the return value is perfect...

i apologize for being the worst ever at posting questions here, please let me know if i can add anything


View Replies !   View Related
Double Quotes In CSV File
I have a lot of data coming in from CSV files.  I have many CSV files (~20), with varying amounts of data- but some are quite large (largest file is ~230mb)

I'm trying to import it into a SQL database via SSIS, but the data is a little bit frustrating. 

I have data that looks like this:

"Text from vendor ""Vendor Name, Inc."" blah blah", "Next string", "", 1234

Many things to notice here - as well you can imagine some of the difficulties here.

After parsing, this data should have 4 columns-

Column1                                                                          Column2              Column3               Column4

Text From Vendor "Vendor Name, Inc." blah blah      Next string            <blank>                1234

The biggest problems stem from the double quotes mixed in with the comma because it is a comma delimited file with quotes as the text qualifier.  The other problem is the double quotes with blank text ... which prevents me from doing a replace on the double quotes ... I think ...

What would be your suggestions to help me parse this out?  (don't forget, some of these are large files with about 260,000 records- )

Thanks in advance,

Rob

View Replies !   View Related
Handling Double Quotes
Hi
i am importing data from table to flat file(csv). i have two problems
1. if a column has commas(,) it should not create a new column i.e the column in csv file can have commas
2.if a column has double quotes then csv file column should have double quotes. please help me.I am using derived column I dont know how to search double quotes in string.



if my table has 2 columns

col1 col2

a abc,"scfddf"ghisk

b bc,de

c de



my csv file should look like this



a abc,"scfddf" ghisk

b bc,de

c de





thanks

View Replies !   View Related
Named Sets And Double Quotes
Hi!
I am trying to add a named set to a dataset in RS. The purpose is to set Investigated_Period = Reported_Period. The format is [YYYY].[QQ], e.g. [2005].[Q1].

I am using the following code:

="With
set [Inv_Per_Eq_Rep_Per] as 'strtoset("{[investigated].[INVYear].[" + Reported.CurrentMember.parent.name +"].[" + Reported.CurrentMember.name +"]}")'

member1....
Select....
From....
Where ....)"


When trying to look at the report in "Preview" in RS I get the following error:
BC30205: End of statement expected

I have tried to declare a named set in Analysis Services instead, but I get an error there as well.

Ideas anyone?
I would appreciate your help!

View Replies !   View Related
SP Parameter With Imbedded Double Quotes
From Access97 I need to execute a SQL 7.0 stored procedure that accepts several input parameters. A few of these are strings that can have imbedded single and/or double quotes (used as feet and inch identifiers). I've tried extra double quotes around the string, square brackets etc. in every combination that I can think of, with minimul success.

Can anyone provide the correct syntax?

Regards........

View Replies !   View Related
Double Quotes In ASCII File
I've an issue with double-quotes in CSV file. One of the columns may contain this kind of value: "STATUS ""H"" "

I've got quote set to "

The file source fails on such records.

I found this threadand Scott tells us there that the file can't contain " in data.

Is this 100% correct?

I've got mutliple text columns and the pain is that I don't know which column might have these cases in future. To create a script means to write my own file parser for all files I use.

Any ideas?

Dima.



View Replies !   View Related
Double Quotes In Error Messages!
I have a problem when trying to display an error message from sql server 2005 on a web page with an alert (javascript command).

The Sql server 2005 returns a message like:

Insert statement conflicted with foreign key constraint "bla bla". The conflict occured indatabase "databasename", table "tablename", column 'columnname'.

In sql server 2000 the error message is the same except all names (constraint, database, table) is in single quotation marks; just like the columnname in the above example.

Is it a configurable issue on the sql server. I would prefer not to solve this issue on a number of different web pages!

Thanks in advance.

Futte

View Replies !   View Related
Single - Double Quotes Problem In Query
Hi All, I am facing quotes problem. Without using the quotes
my query is running fine, but I need to use IIF condition so for that I
need quotes adjustment. I didn't figured it out how to adjust them, try
several techniques but no success. I am using dotnetnuke. {IIF,"[frmradio,form]=text"," SELECT Docs.FileName, Dept_LegalLaw.MediaID, Dept_LegalLaw.ID, Dept_LegalLaw.LevelID, Dept_LegalLaw.LawID, Dept_LegalLaw.LawDate, Dept_LegalLaw.Agreement, Dept_LegalLaw.Name, Dept_LegalLaw.NameSearch, Dept_LegalLawType.LawType, Dept_LegalLaw.LawNo, Dept_LegalMinistries.RegID, Dept_LegalLaw.IssueNo, Dept_LegalLaw.Attachment, Dept_LegalLaw.Amendment, Dept_LegalLaw.Scanned, Dept_LegalLaw.Html, Dept_LegalMinistries.Description FROM OPENQUERY(LEGALDBSERVER, 'SELECT Filename FROM SCOPE() WHERE Contains('" @FilterAnyWrd ")' ) AS Docs INNER JOIN Dept_LegalLaw ON Docs.FileName = Dept_LegalLaw.FileName INNER JOIN Dept_LegalMinistries ON Dept_LegalLaw.RegID = Dept_LegalMinistries.RegID INNER JOIN Dept_LegalLawType ON Dept_LegalLaw.LawID = Dept_LegalLawType.LawID ", " "} {IIF,"'[frmradio,form]'='title'"," SELECT MediaID, Dept_LegalLaw.ID, Dept_LegalLaw.LevelID, Dept_LegalLaw.LawID, LawDate, Agreement, Name, NameSearch, Dept_LegalLawType.LawType, LawNo, Dept_LegalMinistries.RegID, IssueNo, Attachment, Amendment, Scanned, Html, Dept_LegalMinistries.Description, Dept_LegalLaw.FileName FROM Dept_LegalLaw LEFT JOIN Dept_LegalMinistries ON Dept_LegalLaw.RegID COLLATE DATABASE_DEFAULT = Dept_LegalMinistries.RegID COLLATE DATABASE_DEFAULT INNER JOIN Dept_LegalLawType ON Dept_LegalLaw.LawID COLLATE DATABASE_DEFAULT = Dept_LegalLawType.LawID COLLATE DATABASE_DEFAULT WHERE @FilterLawNo AND @FilterLawID AND @FilterRegID AND @FilterIssueNo AND @FilterFromDate AND @FilterToDate AND @FilterNtContNew AND @FilterAgreement AND @FilterAllWrdNew AND @FilterExWrdNew AND @FilterAnyWrdNew ORDER BY [SORTTAG] ", " "} Thanks for any help

View Replies !   View Related
Insert Double Quotes Into Sql Server Table
hi,just wanted to know if i need to insert a string with double quotes init into a sql server table, do i need to use any delimeters, like "?an insert like:insert into producttable values(key, "double quote text")where i need the "double quote text" to go in like that, with the " "at both ends.Thank you.

View Replies !   View Related
BCP Output - Putting Double Quotes Around Text
Folks,

How can I program BCP to output text items in double quotes (")?
Here is an example (please try it) that trys to output some columns from a table to csv file. However, due to the existence of commas within the fields, the comma separation gets messed up.

------------------------------------
USE [MASTER]

IF EXISTS (SELECT 1 FROM sysobjects WHERE name = 'mcg1')
DROP TABLE mcg1
go

CREATE TABLE mcg1
(pkINT IDENTITY(1,1)
,Address_1VARCHAR(100)
,CityVARCHAR(100))
go

INSERT INTO mcg1 (Address_1, City) VALUES ('100 Road1, Suburb1' , 'BigCity1')
INSERT INTO mcg1 (Address_1, City) VALUES ('200 Road2, Suburb2' , 'BigCity2')

SELECT * FROM mcg1

Exec Master..xp_Cmdshell 'bcp "SELECT Address_1, City FROM mcg1" queryout "C:mcg1.csv" -c -t,"'

------------------------------------
The output I get is below. You can see how the use of commas in the text makes the comma separate list all confused
100 Road1, Suburb1,BigCity1
200 Road2, Suburb2,BigCity2

Thus what I want is
"100 Road1, Suburb1","BigCity1"
"200 Road2, Suburb2","BigCity2"

You can do this OK in DTS by specifying the text identifier to be double-quotes.
I do NOT want to use DTS and want to be able to do via a T-SQL procedure. Note that the real table I will export from has numeric datatypes and I would prefer NOT to wrap them in double-quotes too.

Thus, how can I alter the Exec Master..xp_Cmdshell command, to wrap each text field in double quotes. I may have to use a format file in which case please provide the format file too.

Thanks in advance
Mgale1

View Replies !   View Related
How To Handle Double Quotes In The Source CSV Files


I am running into an issue with the SSIS when I try to load a CSV file that contains double quotes wrapped around a field (CSV files have double quotes when field contains a comma; example: "Streams, Inc")



Has anyone worked around this issue?



View Replies !   View Related
Trouble Importing Data With Double Quotes
I have to import a flat file with commas and double quotes as the text qualifier in a SSIS package. However, when I try to import the data into a table, the data moves the information to right, therefore, the last field will capture mulitple fields worth of data. When I create the Connection Manager for the flat file, I have the format as [Delimited] and Text qualifier as ["]. I do not check the unicode button, but under Advanced, make each field a Unicode string [DT-WSTR]. I have included a sample of my data below.



"Internal Sales Document ",9/23/2005 0:00,0.58,"STORES ISSUES","TAPE, PACKING, 2" X 55 YD, CLE ","EP0079771","US363800","2065431980"
"Internal Sales Document ",10/7/2005 0:00,3.76,"STORES ISSUES","Post-It Note Pads, 3"x3", Cana ","EP0079770","US363799","2065431980"


As I highlighted above, I will have a description field that will have double quotes and commas within the text before the end of field.



Please let me know if this is user error. Thanks,

View Replies !   View Related
Newbie Q: Inserting Strings With Single Or Double Quotes
Hi: Got a newbie question that's been giving me fits! Basically I'm replicating what's going on here on this board...creating a "posting" interface that takes the "message" and inserts it into a table using an ADODB connection (using INSERT INTO table name,tablecells and VALUES)

However, if someone types in a single or double quote in the body of the message, I get an error similar to this:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 's'.

/test.asp, line 29


I think I understand why it's happening (SQL is interpreting the quote mark as a string-end), but what am I supposed to do to get around it?

View Replies !   View Related
How To Import Flat Files With Single And Double Quotes Imbedded In Them?
I've got a flat file data source, that is to large to edit with most Windows apps on my server that contains both single and double quote characters that I need to load in a varchar column.

So I attempted to do it with a Replace in data transformation, but I can't get SSIS to allow me to use a variable or pair of single or double quotes within the replace.

If I don't replace the single quote characters with a pair then therecords containing these charactersall end up in my failed records output file.

Here are 5 example property legal descriptions from my FLAT FILE data source:

COM 441'6" N OF SW/C OF NW4 OF SEC 22-29-20 ELY1340' N200' CROSSING THE CNTR OF TR AT 100 WLY1240' S200' TO POB CONTAINING 6 3/10 ACRE MOL

N 50' OF S 330' OF W 122' OF E 735' OF SW4 OF NE4 OF SEC 28/28/18 A/K/A LOT

271 BLK "M" OF$PB 14/36-T

LOT 9 BLK "BA" OF$PB 39/1

OVERCODED POST LTS 17 21-42 47-55 & 69 PB 27/110"ALL" SECS 16-21, 28 29/31/19 & "ALL"

N 100' OF S 815' OF TR "H" OF PB 28/58 LESS W 15' FOR ESMT ESMT DESC AS W 15' OF S 815' OF TR "H" OF PB 28/58

View Replies !   View Related
Form Field Returns Name With Double Quotes Instead Of Single Quote During Update Process.
I've a weird problem in my application. In of the pages, while trying to update the text box "Name", when I enter Linda's test, it gets saved as Linda''s test. I'm not sure if this is a problem due to SQL server. When I look at the stored procedure, I don't anything different. Also, when I update the table directly in SQL Server, the result is displayed in single quote. But if I update the field thro' the application, the returned name is with double quotes instead of single quote.  Has any of you faced problems like this? What am I missing? What do I need to do to get the name saved the way I entered (with single quotes) instead of double quotes?

View Replies !   View Related
How To Remove Quotes From A Query


Hi,

i have a query like

select * from table1 where @variable1

and variable1 id holding the value id=1

so what i want is select * from table1 where id=1

but here the values variable1 is passesed from a c# program which encloses the vaule within single quotes.

so what i get is select * from table1 where 'id=1'

how to correct this?

hope my question is clear.

Thanks

View Replies !   View Related
Remove Double Value
HyNever use/practice SQL a lot, (vb... more, have free msde 2000) .2 questionsA)is it simple to write a T-SQL query for having 2) at result startingfrom 1) .B)how to test dynamically sql with parmaeter ( using vb ADO)1) before querycolumA columBd e <-samee d <-samee ee d <-same2)after querycolumA columBd e or e de e

View Replies !   View Related
How Do I Remove Single Quotes Out Of Text
How do I remove single quotes from text. Ex. I would like O'BRIAN to be Replaced in the table with OBRIAN.

How do I Remove the single Quote in the Name?

Thanks in Advance

View Replies !   View Related
Remove Quotes In Bulk Insert
Hi all

I am importing a csv, there are quotes around all the field data which i would like to remove on import.
Is this possible??


Thanks

Rich

View Replies !   View Related
Problems Importing Text Files With Double-quotes As Text Qualifier
I have text data files from a third party and they use comma as field delimiters and enclose the text for each column in double-quotes. Not a problem for most of the data files until they start sending files where there is " within the column values. SSIS package fails with the error:

The column delimiter for column "Column 1" was not found.

Any ideas on how to resolve this issue will be greatly appreciated.Thankspcp

View Replies !   View Related
Remove Double Results Inside A Delimited Result
Hi,

I have now this (1 record) result:
;Admins;Sales;SalesAdmin;Other;Sales;Admins;All users;

Now, as you can see, there are some double rolenames.
I see admins and Sales 2 times between ";".

Is there a way to filter that out?
So that this will be the result:
;SalesAdmin;Other;Sales;Admins;All users;

Thanks!

View Replies !   View Related
How Do I Clean Up The SQL Server (ctp) From ADD/REMOVE Program Without The Change/remove Button
I have uninstalled the CTP version of the SQL Server express so that I can install the released version but CTP version is still listed in the add/remove program list but without the change/remove button. I have been to different sites to find information on cleaning this up and I have ran all the uninstall tool I can find but the problem still prevails. I cannot install the released version without completely getting rid of the CTP version. Please help anyone.

Thanks

deebeez1

View Replies !   View Related
Unable To Remove SQL Instance In Add/Remove Program
I need help,

I am having a hard time removing my SQL instance inside the Add/Remove program. After i select the SQL Instance name and thenI tried to remove it but it won't allow me to delete it. There isn't any error message or whatsoever. Actually, when i try to log it in my SQL Management studio, that certain sql instance name is not existing according to the message box. Is there any way to remove the Sql Instance in my system?

I appreciate your help, Thanks

IS Support

View Replies !   View Related
SQL Server Management Studio: Can Not Remove AdventureWorksDB In &&"Add Or Remove Programs&&" Of Control Panel
Hi all,

I tried to remove AdventureWorksDB in the "Add or Remove Programs" of Contol Panel and I got the following errors: (1) AdventureWorksDB     Error 1326: Error getting file security: CProgram FilesMicrosoft SQL ServerMSSQL1MSSQLGetLastError: 5.      |OK|   and (2) Add or Remove Programs   Fatal Error during installation (after I clicked the |OK| button).   Please help and tell me how I can solve this problem.

Thanks in advance,

Scott  Chang 

View Replies !   View Related
Sp Quotes
below is the code of my sp
it's giving my wrong result: 1 instead 0 and vice versa
could you please check what's wrong with it: i think there is something related to @var2 in the code colored in orange.

Thanks!


Code:

ALTER PROCEDURE sp_name
(
@param1 int = NULL,
@param2 int = NULL,
@Result int OUTPUT
)

AS

DECLARE @var1 AS varchar(255)
DECLARE @var2 AS varchar(255)
DECLARE @x AS varchar(1000)

IF @param1 IS NOT NULL
BEGIN
SET @var1 = (
SELECT t1col1
FROM tabl1
WHERE t1col2 = @param1)

SET @var2 = ''

DECLARE crsr CURSOR FOR

SELECT t2col1 FROM tabl2 WHERE t2col2 = @var1

OPEN crsr
FETCH NEXT FROM crsr INTO @x

WHILE @@FETCH_STATUS = 0
BEGIN
SET @var2 = @var2 + '''' + @x + '''' + ', '

FETCH NEXT FROM crsr INTO @x
END

CLOSE crsr
DEALLOCATE crsr

SET @var2 = SUBSTRING(@var2, 1, LEN(@var2) - 1)

END
ELSE
BEGIN
SET @var2 = (SELECT t2col1 FROM t2 WHERE tb2col3 = @param2)
SET @var2 = '''' + @var2 + ''''
END

PRINT @var2

IF EXISTS (SELECT * FROM tabl3 WHERE t3col1 IN (@var2))
OR
EXISTS (SELECT * FROM tabl4 WHERE t4col1 IN (@var2))
BEGIN
SET @Result = 1
END
ELSE
BEGIN
SET @Result = 0
END

View Replies !   View Related
Quotes In Quotes..
Hi all,

How do you put quotes in quotes so it looks like this below?


exec('select IDENT_CURRENT('table')')

Not


exec('select IDENT_CURRENT('table')')



I just don't want the middle quotes to end the initial quote..



thanks in advance..

View Replies !   View Related
BCP Quotes Problem
Hello :

I am using bcp to load data from text file to a temporary
table in sql server 6.5 ( by running load.bat from dos prompt )

Contents of try.txt file ( Total 5 fields )
(4) charcter fields are put in quotes
and (1) numeric field ( does not have quotes around it )

"0000777376676570",1.01,"10021998","111","abc"

My load.bat file is as follows :

bcp MANISH..TEMP in c:ry.txt -c -t, -Usa

MY OUTPUT to the temp table in sql server is as follows :

CharFld1 "000077737667657
NumFld2 1.01
CharFld3 "10021998"
CharFld4 "111"
CharFld5 "abc"

PROBLEM : Quotes should not be transferred into the temp table.

If I remove the quotes(") from the try.txt file it works fine.


Manish Mehta

View Replies !   View Related
Single Quotes And Sql
How to deal with single quotes in the contains predicate ?

I explain : i have to search strings like this :
contains(title,'"ennemi"' AND '"d'etat"')

I know that my syntax is wrong but i don't know how to correct it

Could someone help me ?

TIA

Isabelle

View Replies !   View Related
String Quotes Between &#39; And &#34;
Hi,

Your help would be appreciated if you could give me some idea about why SQL 2000 takes single quote(') as a default for string searching instead of double quotes("). I have couple of stored procedures which were developed with string comparison with double quotes in SQL 6.5. If any one knows how I can change default as a double quotes(") instead of single quote(') in SQL 2000, would be great. Thanks

View Replies !   View Related
Quotes In SQL Statement
This is the sql statement I have:

Code:

select * from tblCalls where TNum = [NUMBER] and Street like '[TEXT]'


The problem is that the Street field contains street names with quotes (ex. DE L'ACADIE). When I run this query using this street name, it doesn't work because of the ' between the L and the A. How can I tell SQL to "ignore" the ' in the text?

View Replies !   View Related
Quotes Issue In MDX
Can some one help me fixing the quote issue in this "SET", I am not sure what I am missing, It fails saying Type mismatch at '+' operator.

SET [FISCAL WK NBR] AS
{
StrToMember('[DIM TIME].[FISC YR WK NBR].[FISC YR WK NBR].['+ " & Parameters!prmStartWeek_INT.Value &" + ']' ):
StrToMember('[DIM TIME].[FISC YR WK NBR].[FISC YR WK NBR].['+" & Parameters!prmEndWeek_INT.Value &" + ']' )
}

Pls note prmStartWeek_INT and prmEndWeek_INT are parameters passes from Reporting servcies - Parameter.

View Replies !   View Related
Quotes Within A Query
Help, please.

I'm going crazy trying to figure out how to form this SQL query. I am querying an Informix linked server and I need to passa variabledate. I am using an expression to create the query like so

"Select count(*) from " + @[User::varDBName] + ":informix.doc_tl WHERE " + @[User::varDBName] +":informix.doc_tl.d_received = {D " + @[User::varDate] +"} "

The informix query needs the date to be {D "2007-01-15"} but for the life of me, I can't get the date enclosed in quotes.

The error I get is

An OLE DB record is available. Source: "(null)". HResult: 0x80040E14

Description: "(null)"

Can anyone tell me what I'm doing wrong?

Thanks

View Replies !   View Related
Identifying Quotes
Has previous work been done on this? Is their a library one can download? Here's the problem. In an aricle a person or author may make a statement about a subject or a person. I am making a database on this.

For example, here in Israel, PM Olmert may make a statement on the teacher's strike or on Abu Mazen. The article may say, speaking of Mazen, Olmert said such and such. PM Olmert said, "xxxxxxx......." with the previous material making it clear whathe was speaking of.

Right now I have ugly code. Is there a neat way of doing this?

If this is the wrong forum, can somebody direct me to the right forum?

Thanks.

Dennist

View Replies !   View Related
Replacing Quotes With Stringbuilder
Hi, below is the query that i use.update user set user_description=' "+ userDesc +" ' where user_id = 1;userDesc is the value taken from a textbox and is supposed to be used with the update query.userDesc = "kad'nsad'kasnd'nak";The quotes in userDesc is affecting the update. Is there anyway to replace quotes with ' using stringbuilder?

View Replies !   View Related
Single Quotes And Parameters
Help please! I have a problem with passing quotes in a parameter. I am using asp.net (vb) passing a parameter to a stored procedure.

Here is an example of the parameter I am passing from the asp page.

strIndexFilesFound = " 'file1.pdf', 'file2.pdf' "
.......Parameters("@IndexFilesFound").Value = strIndexFilesFound

And the Procedure parts

...
@IndexFilesFound char(100) = ''
....
WHERE IndexFile IN(@IndexFilesFound)


The result should be that the where query receives the data like this.
WHERE IndexFile IN ('file1.pdf', 'file2.pdf')

The number of files passed is unknown for any given query.

Much Thanks!

View Replies !   View Related
Triple Single Quotes
I was having some issues with converting this @BeginDate(which is passed in as a datetime) correctly and someone suggested the syntax below. It enloses it in triple single quotes. That seemed to work, but it also seems to work with single quotes too. Can someone explain the use of triple single quotes in stored procedures?


''' + CAST(@BeginDate as Varchar(30)) + '''

View Replies !   View Related
Escaping Single Quotes
Hi,

I need to have an varchar value with single quotes. For eg: the below code throws compilation error.

Declare @val VARCHAR(20)
SELECT @val = ''+name+''
print @val

Error: Invalid column 'name'


I want to print name enclosed with single quotes. Please guide me.

Regards,
Sam

View Replies !   View Related
Trouble With Single Quotes
Hello Everyone!

I am having a problem with updating a password within a table. Below is the old and new password that needs to be updated.
Old2"3("-"3#@(%P="''_DD@D*
New :"I+)#]*1#E,%R-''7^,TEA$X&^O_-68DIK,@

Below is the query that I am trying to run. I believe my problem is becuase of the Single Quotes found within both the old and new password.

I have tried to escape the single quotes, @local_variable, CHAR(39) and other ways of playing with the string. I cannot seem to find a solution.

If you were to ignore the update statement, the SELECT statement would return no results even though the PRINT statement displays the required data.
This is what baffles me and why I cannot run the UPDATE statement, becuase of course, nothing would be updated since no results were returned.

Can anyone offer their assistance?

Thank you in advance.

__________________________________________________ _______________

DECLARE
@OLD_PASSWORD VARCHAR(50),
@NEW_PASSWORD VARCHAR(50)

-- 2"3("-"3#@(%P="''_DD@D* ///// The old password.

SET @OLD_PASSWORD = '2"3("-"3#@(%P="' + CHAR(39) + CHAR(39) + '_DD@D*'

-- :"I+)#]*1#E,%R-''7^,TEA$X&^O_-68DIK,@ ///// The new password.

SET @NEW_PASSWORD = ':"I+)#]*1#E,%R-' + CHAR(39) + CHAR(39) + '7^,TEA$X&^O_-68DIK,@'

PRINT @OLD_PASSWORD
PRINT @NEW_PASSWORD

SELECT *
FROM Credentials
WHERE
Is_Active = 1 AND
[Password] = @OLD_PASSWORD

/* Attempt to update the password table. */
UPDATE Credentials
SET [Password] = @NEW_PASSWORD
WHERE [ID] IN
(SELECT [ID]
FROM Credentials
WHERE
Is_Active = 1 AND
[Password] = @OLD_PASSWORD )

View Replies !   View Related
Handling Quotes And Apostraphies
I`m new to sql and am having trouble with updates. I`m trying to make a web page where people can enter text and have it submitted to the database. The problem is that I need to let people submit text with quotes (single and double). When my cgi generates the sql, the quotes cause problems with the dbms (ie. in the statement:

UPDATE mytable SET thetext = `This is Joe`s text.` WHERE user = `joe`

the apostraphy in "joe`s" is interpreted as meaning the end of the string to enter into "thetext" ). I expect that there`s some escape character that I don`t know about? I know this is a very basic question, but any help would be greatly appreciated.

-Daren

View Replies !   View Related
Single Quote Becoming Two Quotes
I have 2 SQL 6.5 databases on separate servers. Server A replicates a text field into a table on server B.

On server A the field contains text similar to THIS IS FRED'S HOUSE. After replication to Server B it looks like THIS IS FRED''S HOUSE. The distribution database also has it as THIS IS FRED''S HOUSE. Using ODBC trace I cannot see the value being passed in the text field as it is displayed as a question mark e.g. ?.

How do I fix the problem ?
Thanks

View Replies !   View Related
Eliminating Quotes In Columns
i want to eliminate single quotes from columns such as joe's pizza in the result set as well as in columns anyeefecient methods to do will be appreciated
tia

View Replies !   View Related
Escape Single Quotes
Hi,

I want to pass a query to SQL Server 2005 through the table adapter query.

Some of the variables with have single quotes e.g. He's

I know with PHP/MySQL Addslashes() is used.

What is the alternative for C#?

Thanks.

View Replies !   View Related
How To INSERT A String That Contains Single-quotes?
My code results in SQL statements like the following one - and it gives an error because of the extra single-quotes in 'it's great': 
UPDATE Comments SET Comment='it's great' WHERE UserID='joe' AND GameID='503'
Here's the error I get when I try this code in SQL Server: 
Msg 102, Level 15, State 1, Line 1Incorrect syntax near 's'.Msg 105, Level 15, State 1, Line 1Unclosed quotation mark after the character string ''.
I need to know how I can insert a string such as 'it's great' - how do I deal with the extra quotes issue? is there a way to ecape it like this 'it/'s great' ? This doesn't seem to work.
Here's the code that generates the SQL. I'm using a FCKeditor box instead of a TextBox, but I got the same error when I was using the TextBox:
string strUpdate = "UPDATE Comments SET Comment='";strUpdate = strUpdate + FCKeditor1.Value;//strUpdate = strUpdate + ThisUserCommentTextBox.Text;strUpdate = strUpdate + "' WHERE UserID='";strUpdate = strUpdate + (string)Session["UserID"];strUpdate = strUpdate + "'";strUpdate = strUpdate + " AND GameID='";strUpdate = strUpdate + Request.QueryString["GameID"];strUpdate = strUpdate + "'";
SqlConnection myConnection = new SqlConnection(...);SqlCommand myCommand = new SqlCommand(strUpdate, myConnection);
try{myCommand.Connection.Open();myCommand.ExecuteNonQuery();}catch (SqlException ex){ErrorLabel.Text = "Error: " + ex.Message;
}finally{myCommand.Connection.Close();}
 
I'm using SQL Server 2005 and ASP.NET 2.0 
Much thanks

View Replies !   View Related
How To INSERT Text That Contains Single Quotes?
When users enter text into a textbox, to be INSERTed into my table, SQL Server throws an error if their text contains a single quote.
For example, if they enter "It's great!" then it causes this error:Error: Incorrect syntax near 's'. Unclosed quotation mark after the character string ''.
How can I allow text with single quotes to be inserted into the table?
 
Here's my code: 
string strInsert = "INSERT INTO [Comments] ([GameID], [UserID], [Comment]) VALUES (@GameID, @UserID, @Comment)";
SqlConnection myConnection = new SqlConnection(<<myconnectionstuff>>);SqlCommand myCommand = new SqlCommand(strInsert, myConnection);
myCommand.Parameters.Add( "@GameID", Request.QueryString["GameID"] );myCommand.Parameters.Add( "@UserID", (string)Session["UserID"] );myCommand.Parameters.Add( "@Comment", ThisUserCommentTextBox.Text );
try {myCommand.Connection.Open();myCommand.ExecuteNonQuery();}
catch (SqlException ex) {ErrorLabel.Text = "Error: " + ex.Message;}
finally {myCommand.Connection.Close();}
 
 

View Replies !   View Related
How To Use LIKE In Stored Procedure With Single Quotes
I'm trying to build a dynamic sql statement in a stored procedurre and can't get the like statement to work. My problem is with the single quote.  for example LIKE '%@searchvalue%'.  This works fine: select * from view_searchprinters where serialnumber like '%012%' But I can't figure out how to create this in a stored procedure.  What syntax should I use for the line in bold?SET NOCOUNT ON;DECLARE @sn varchar(50)SET @sn = N'012'DECLARE @sql nvarchar(4000)SELECT @sql = 'select top 10 * from view_searchprinters'    + ' WHERE 1 = 1 'SELECT @sql = @sql + ' 'IF @sn IS NOT NULL   SELECT @sql = @sql + 'and serialnumber LIKE ''' + '%' + '@sn' + '%' + ''' 'EXEC sp_executesql @sql, N'@sn varchar(50)', @sn  

View Replies !   View Related

Copyright 2005-08 www.BigResource.com, All rights reserved