VB String in VB SQL Query

365 100+

Hello, i am trying to use VB strings in queries... with no luck... i can get VB integers to work but not strings

i have several situations i need this and at the moment i am having to use a dlookup to set the value of a text box or set the value as the string and use that in the query

for number it works (as im sure you know)...

Expand|Select|Wrap|Line Numbers

 mySQL = "SELECT something FROM somewhere WHERE something = " & VBNumber
 

so for string values i have tried the same..
as well as variations of single quotes and double quotes etc...

Can someone let me know where i am going wrong?

Thanks

Dan

Dec 18 '07 #1

Subscribe Post Reply

2246

puppydogbuddy

1,923

Expert 1GB

Hello, i am trying to use VB strings in queries... with no luck... i can get VB integers to work but not strings

i have several situations i need this and at the moment i am having to use a dlookup to set the value of a text box or set the value as the string and use that in the query

for number it works (as im sure you know)...

mySQL = "SELECT something FROM somewhere WHERE something = " & VBNumber

so for string values i have tried the same..
as well as variations of single quotes and double quotes etc...

Can someone let me know where i am going wrong?

Thanks

Dan

Expand|Select|Wrap|Line Numbers

 mySQL = "SELECT something FROM somewhere WHERE something = '" & VBTextString & "'"
 

Dec 18 '07 #2

NeoPa

32,556

Expert Mod 16PB

Check out Quotes (') and Double-Quotes (") - Where and When to use them.

Dec 19 '07 #3

by: Andy | last post by:

I haven't done any web work for over a year and for the life of me I cannot remember how to use a query string in a URL. I want the link to be page.aspx?ID=1 then pass 1 into a query like this ...

.NET Framework

How do I always chop off both query string and "#" from document.location.href?

by: Phil Powell | last post by:

if (document.location.href.indexOf('?') >= 0) document.location.href = document.location.href.substring(0, document.location.href.indexOf('?')); if (document.location.href.indexOf('#') >= 0) {...

Javascript

Using query string to create link

by: Dr. Oz | last post by:

Hi, I am trying to read in a query string from one page and build a link to another page based on the query string. Here's the code I am using to read in the query string: <script...

Javascript

How to find a string in a stream of binary data?

by: Angus Comber | last post by:

Hello My code below opens a Word document in binary mode and places the data into a buffer. I then want to search this buffer for a string. I tried using strstr but think it stops looking when...

C / C++

encrypting query string

by: Onur Bozkurt | last post by:

I'am sending some data by the querystring. But I don't want it to be seen exactly because of security reasons. Is there a way to encrypt it and later decrypt when reading the querystring...? I...

ASP.NET

How to create this string? Thank You.

by: Miguel Dias Moura | last post by:

Hello, I am calling an ASP.NET / VB as follows: search.aspx?search=asp%20book%20london Then I create a string with the keywords like this: Dim keywords() As String =...

ASP.NET

Accessing a Web Service using a Query String

by: Jim Lewis | last post by:

I have read several things that state accessing a Web Service through a Query String should work. However, when I try to execute http://localhost/webservice1/service1.asmx/HelloWorld I get the...

.NET Framework

NZ always returns a zero-length string when used in a query expression?

by: Lyle Fairfield | last post by:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbaac11/html/acfctNZ_HV05186465.asp "If the value of the variant argument is Null, the Nz function returns the number zero or a...

Microsoft Access / VBA

PHP concatenated string part desaperas

by: bilibytes | last post by:

Hi, I am having a problem with a concatenated string. I start my string outside of a for() and then, concatenate the string generated with the loop to it. the string out of the loop looks like...

PHP

Method param in string variable

by: Looch | last post by:

All, I'm trying to output but I can only get (brackets for clarity) when using the code below. How can I "break" into the query variable in the InsertName method to add the name parameter to...

C# / C Sharp

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

Similar topics