Hi,
I need to make a string containing this text litterally as it::
selectcommand="select * from table where field1=' " & myvar & " ' "
Dim st as string
st="selectcommand=" & ???
How can i include " in the string without it is interpreting as a string
delimiter?
Thanks
bob 7 1154
have you tried to use the char value?
"bob" <sdvsé@sds.dfgwrote in message
news:em**************@TK2MSFTNGP04.phx.gbl...
Hi,
I need to make a string containing this text litterally as it::
selectcommand="select * from table where field1=' " & myvar & " ' "
Dim st as string
st="selectcommand=" & ???
How can i include " in the string without it is interpreting as a string
delimiter?
Thanks
bob
I foun dit:
just double " in the string
"Miro" <mi******@golden.netschreef in bericht
news:ea**************@TK2MSFTNGP02.phx.gbl...
have you tried to use the char value?
"bob" <sdvsé@sds.dfgwrote in message
news:em**************@TK2MSFTNGP04.phx.gbl...
>Hi,
I need to make a string containing this text litterally as it:: selectcommand="select * from table where field1=' " & myvar & " ' "
Dim st as string st="selectcommand=" & ???
How can i include " in the string without it is interpreting as a string delimiter?
Thanks bob
Bob,
I think the standard way to do this is:
& Char(66)
"bob" <sdvsé@sds.dfgwrote in message
news:uC**************@TK2MSFTNGP03.phx.gbl...
>I foun dit:
just double " in the string
"Miro" <mi******@golden.netschreef in bericht
news:ea**************@TK2MSFTNGP02.phx.gbl...
>have you tried to use the char value? "bob" <sdvsé@sds.dfgwrote in message news:em**************@TK2MSFTNGP04.phx.gbl...
>>Hi,
I need to make a string containing this text litterally as it:: selectcommand="select * from table where field1=' " & myvar & " ' "
Dim st as string st="selectcommand=" & ???
How can i include " in the string without it is interpreting as a string delimiter?
Thanks bob
I foun dit:
just double " in the string
Yes, "" is an escape sequence for " in VB strings. I wrote a macro that
allows you pasting any text (even very long multi-line) as VB string: http://www.helixoft.com/blog/archives/12
--
Peter Macej
Helixoft - http://www.helixoft.com
VSdocman - Commenter and generator of class documentation for C#, VB
..NET and ASP .NET code
Hello Steve,
I believe you mean 34.
-Boo
Bob,
I think the standard way to do this is:
& Char(66)
"bob" <sdvsé@sds.dfgwrote in message
news:uC**************@TK2MSFTNGP03.phx.gbl...
>I foun dit: just double " in the string "Miro" <mi******@golden.netschreef in bericht news:ea**************@TK2MSFTNGP02.phx.gbl...
>>have you tried to use the char value?
"bob" <sdvsé@sds.dfgwrote in message news:em**************@TK2MSFTNGP04.phx.gbl...
Hi,
I need to make a string containing this text litterally as it:: selectcommand="select * from table where field1=' " & myvar & " ' "
Dim st as string st="selectcommand=" & ??? How can i include " in the string without it is interpreting as a string delimiter?
Thanks bob
double quotes
selectcommand="select * from table where field1=""" & myval & """
"bob" <sdvsé@sds.dfgwrote in message
news:em**************@TK2MSFTNGP04.phx.gbl...
Hi,
I need to make a string containing this text litterally as it::
selectcommand="select * from table where field1=' " & myvar & " ' "
Dim st as string
st="selectcommand=" & ???
How can i include " in the string without it is interpreting as a string
delimiter?
Thanks
bob
Opps. :)
"GhostInAK [Bastard]" <pa**@paco.netwrote in message
news:be**************************@news.microsoft.c om...
Hello Steve,
I believe you mean 34.
-Boo
>Bob, I think the standard way to do this is: & Char(66) "bob" <sdvsé@sds.dfgwrote in message news:uC**************@TK2MSFTNGP03.phx.gbl...
>>I foun dit: just double " in the string "Miro" <mi******@golden.netschreef in bericht news:ea**************@TK2MSFTNGP02.phx.gbl... have you tried to use the char value?
"bob" <sdvsé@sds.dfgwrote in message news:em**************@TK2MSFTNGP04.phx.gbl...
Hi, > I need to make a string containing this text litterally as it:: selectcommand="select * from table where field1=' " & myvar & " ' " > Dim st as string st="selectcommand=" & ??? How can i include " in the string without it is interpreting as a string delimiter? > Thanks bob
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Jacco |
last post by:
Hi,
can anyone help me with the following:
Suppose I have a variable ll_temp containing pi and a variable test
containing "ll_temp". Then with what syntax do I get the value of pi
out of test...
|
by: Ron Brennan |
last post by:
This is from an application and not an Applet.
I believe it goes to stdout but when I do a test and write an abitrary
string and then do a search of the hard disk for the string, I can't find...
|
by: Bob Maggio |
last post by:
I have created a function that returns a string containing raw HTML to
be used on a web form (see below):
private string GetReportHTML()
{
string strHTML = "";
// I have some code here that...
|
by: Alpha |
last post by:
Hi, I want to concatenate a string variable (containing file path and name)
to a sqlcommnad text string but I'm getting error about "+" can't be used
with string operand. It's very odd. What am I...
|
by: CeyloR |
last post by:
Can anyone tell me what the "c" means in a statement like this:
strTest = New String(" "c,10)
I know the 10 in above example stands for the maxlength of characters
in the string. Is it posible...
|
by: Martin Jørgensen |
last post by:
Hi,
I'm trying to move a matlab program into c language. For those who knows
matlab, this is the line I want to program in c:
hx(1:nx,1:ny) = 0; % nx=10, ny=10
It works on a 2-dimensional...
|
by: scottyman |
last post by:
I can't make this script work properly. I've gone as far as I can with
it and the rest is out of my ability. I can do some html editing but
I'm lost in the Java world. The script at the bottom of...
|
by: john |
last post by:
Hi to All,
I am new to html authoring, so sorry if my terminology is not correct or
exact.
I would like to position a footer div to the bottom of the browser window.
As I research in the web...
|
by: Mike Gleason jr Couturier |
last post by:
Why do I see a @ preceding strings in code examples?
What does the @ do?
thanks!
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
by: Shællîpôpï 09 |
last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
|
by: af34tf |
last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
| |