Home Menu

Menu


ExcelBanter » Excel Newsgroups » Excel Programming > ADO SQL
Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
  
Posts: 3,101
Default ADO SQL
Hi all I'm really at a loss any help would be great
Thanks Mike

I have SQL that works with no problem

strSQL1 = "SELECT MultVend.VENDOR_ID, MultVend.VEND_PART_NUM,
MultVend.VEND_DESC " _
& " FROM MultVend " _
& " WHERE (((MultVend.VEND_PART_NUM)=""14002"")); "

and this will NOT
Where myString = me.textbox1.value

strSQL1 = "SELECT MultVend.VENDOR_ID, MultVend.VEND_PART_NUM,
MultVend.VEND_DESC " _
& " FROM MultVend " _
& " WHERE (((MultVend.VEND_PART_NUM)=" & myString & ")); "
Reply With QuoteReply With Quote
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
  
Posts: 3,101
Default ADO SQL
I'm think its because the field is text ? but still can't get it to work.

"Mike" wrote:

Hi all I'm really at a loss any help would be great
Thanks Mike

I have SQL that works with no problem

strSQL1 = "SELECT MultVend.VENDOR_ID, MultVend.VEND_PART_NUM,
MultVend.VEND_DESC " _
& " FROM MultVend " _
& " WHERE (((MultVend.VEND_PART_NUM)=""14002"")); "

and this will NOT
Where myString = me.textbox1.value

strSQL1 = "SELECT MultVend.VENDOR_ID, MultVend.VEND_PART_NUM,
MultVend.VEND_DESC " _
& " FROM MultVend " _
& " WHERE (((MultVend.VEND_PART_NUM)=" & myString & ")); "
Reply With QuoteReply With Quote
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
  
Posts: 2,452
Default ADO SQL
One of these 3 should work, probably the last:

strSQL1 = "SELECT MultVend.VENDOR_ID, MultVend.VEND_PART_NUM, " & _
"MultVend.VEND_DESC " & _
"FROM MultVend " & _
"WHERE (((MultVend.VEND_PART_NUM) = " & _
myString & ")); "

strSQL1 = "SELECT MultVend.VENDOR_ID, MultVend.VEND_PART_NUM, " & _
"MultVend.VEND_DESC " & _
"FROM MultVend " & _
"WHERE (((MultVend.VEND_PART_NUM) = " & _
Chr(34) & myString & Chr(34) & ")); "

strSQL1 = "SELECT MultVend.VENDOR_ID, MultVend.VEND_PART_NUM, " & _
"MultVend.VEND_DESC " & _
"FROM MultVend " & _
"WHERE (((MultVend.VEND_PART_NUM) = " & _
Chr(39) & myString & Chr(39) & ")); "


RBS


"Mike" wrote in message
...
Hi all I'm really at a loss any help would be great
Thanks Mike

I have SQL that works with no problem

strSQL1 = "SELECT MultVend.VENDOR_ID, MultVend.VEND_PART_NUM,
MultVend.VEND_DESC " _
& " FROM MultVend " _
& " WHERE (((MultVend.VEND_PART_NUM)=""14002"")); "

and this will NOT
Where myString = me.textbox1.value

strSQL1 = "SELECT MultVend.VENDOR_ID, MultVend.VEND_PART_NUM,
MultVend.VEND_DESC " _
& " FROM MultVend " _
& " WHERE (((MultVend.VEND_PART_NUM)=" & myString & ")); "

Reply With QuoteReply With Quote
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
  
Posts: 3,101
Default ADO SQL
Thanks but just got it with this i had to have 3 """ instead of 2 ""
WHERE (((MultVend.VEND_PART_NUM)=""" & myString & """));
By the way what does the Chr(34) do ?

"RB Smissaert" wrote:

One of these 3 should work, probably the last:

strSQL1 = "SELECT MultVend.VENDOR_ID, MultVend.VEND_PART_NUM, " & _
"MultVend.VEND_DESC " & _
"FROM MultVend " & _
"WHERE (((MultVend.VEND_PART_NUM) = " & _
myString & ")); "

strSQL1 = "SELECT MultVend.VENDOR_ID, MultVend.VEND_PART_NUM, " & _
"MultVend.VEND_DESC " & _
"FROM MultVend " & _
"WHERE (((MultVend.VEND_PART_NUM) = " & _
Chr(34) & myString & Chr(34) & ")); "

strSQL1 = "SELECT MultVend.VENDOR_ID, MultVend.VEND_PART_NUM, " & _
"MultVend.VEND_DESC " & _
"FROM MultVend " & _
"WHERE (((MultVend.VEND_PART_NUM) = " & _
Chr(39) & myString & Chr(39) & ")); "


RBS


"Mike" wrote in message
...
Hi all I'm really at a loss any help would be great
Thanks Mike

I have SQL that works with no problem

strSQL1 = "SELECT MultVend.VENDOR_ID, MultVend.VEND_PART_NUM,
MultVend.VEND_DESC " _
& " FROM MultVend " _
& " WHERE (((MultVend.VEND_PART_NUM)=""14002"")); "

and this will NOT
Where myString = me.textbox1.value

strSQL1 = "SELECT MultVend.VENDOR_ID, MultVend.VEND_PART_NUM,
MultVend.VEND_DESC " _
& " FROM MultVend " _
& " WHERE (((MultVend.VEND_PART_NUM)=" & myString & ")); "


Reply With QuoteReply With Quote
  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
  
Posts: 2,452
Default ADO SQL
By the way what does the Chr(34) do ?

That is the double-quote character.
Chr(39) is a single quote.
If your 3 double quotes work then the one with Chr(34) may also work.
I think it gets less confusing if you combining single or double quotes to
use
the character codes instead, so Chr(34) etc.

RBS


"Mike" wrote in message
...
Thanks but just got it with this i had to have 3 """ instead of 2 ""
WHERE (((MultVend.VEND_PART_NUM)=""" & myString & """));
By the way what does the Chr(34) do ?

"RB Smissaert" wrote:

One of these 3 should work, probably the last:

strSQL1 = "SELECT MultVend.VENDOR_ID, MultVend.VEND_PART_NUM, " & _
"MultVend.VEND_DESC " & _
"FROM MultVend " & _
"WHERE (((MultVend.VEND_PART_NUM) = " & _
myString & ")); "

strSQL1 = "SELECT MultVend.VENDOR_ID, MultVend.VEND_PART_NUM, " & _
"MultVend.VEND_DESC " & _
"FROM MultVend " & _
"WHERE (((MultVend.VEND_PART_NUM) = " & _
Chr(34) & myString & Chr(34) & ")); "

strSQL1 = "SELECT MultVend.VENDOR_ID, MultVend.VEND_PART_NUM, " & _
"MultVend.VEND_DESC " & _
"FROM MultVend " & _
"WHERE (((MultVend.VEND_PART_NUM) = " & _
Chr(39) & myString & Chr(39) & ")); "


RBS


"Mike" wrote in message
...
Hi all I'm really at a loss any help would be great
Thanks Mike

I have SQL that works with no problem

strSQL1 = "SELECT MultVend.VENDOR_ID, MultVend.VEND_PART_NUM,
MultVend.VEND_DESC " _
& " FROM MultVend " _
& " WHERE (((MultVend.VEND_PART_NUM)=""14002"")); "

and this will NOT
Where myString = me.textbox1.value

strSQL1 = "SELECT MultVend.VENDOR_ID, MultVend.VEND_PART_NUM,
MultVend.VEND_DESC " _
& " FROM MultVend " _
& " WHERE (((MultVend.VEND_PART_NUM)=" & myString & ")); "



Reply With QuoteReply With Quote
  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
  
Posts: 92
Default ADO SQL
FYI single quotes ' work also

so this should work
" WHERE (((MultVend.VEND_PART_NUM)='" & myString & "')); "

"Mike" wrote in message
...
: Thanks but just got it with this i had to have 3 """ instead of 2 ""
: WHERE (((MultVend.VEND_PART_NUM)=""" & myString & """));
: By the way what does the Chr(34) do ?
:
: "RB Smissaert" wrote:
:
: One of these 3 should work, probably the last:
:
: strSQL1 = "SELECT MultVend.VENDOR_ID, MultVend.VEND_PART_NUM, " & _
: "MultVend.VEND_DESC " & _
: "FROM MultVend " & _
: "WHERE (((MultVend.VEND_PART_NUM) = " & _
: myString & ")); "
:
: strSQL1 = "SELECT MultVend.VENDOR_ID, MultVend.VEND_PART_NUM, " & _
: "MultVend.VEND_DESC " & _
: "FROM MultVend " & _
: "WHERE (((MultVend.VEND_PART_NUM) = " & _
: Chr(34) & myString & Chr(34) & ")); "
:
: strSQL1 = "SELECT MultVend.VENDOR_ID, MultVend.VEND_PART_NUM, " & _
: "MultVend.VEND_DESC " & _
: "FROM MultVend " & _
: "WHERE (((MultVend.VEND_PART_NUM) = " & _
: Chr(39) & myString & Chr(39) & ")); "
:
:
: RBS
:
:
: "Mike" wrote in message
: ...
: Hi all I'm really at a loss any help would be great
: Thanks Mike
:
: I have SQL that works with no problem
:
: strSQL1 = "SELECT MultVend.VENDOR_ID, MultVend.VEND_PART_NUM,
: MultVend.VEND_DESC " _
: & " FROM MultVend " _
: & " WHERE (((MultVend.VEND_PART_NUM)=""14002"")); "
:
: and this will NOT
: Where myString = me.textbox1.value
:
: strSQL1 = "SELECT MultVend.VENDOR_ID, MultVend.VEND_PART_NUM,
: MultVend.VEND_DESC " _
: & " FROM MultVend " _
: & " WHERE (((MultVend.VEND_PART_NUM)=" & myString & ")); "
:
:


Reply With QuoteReply With Quote
  #7   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
  
Posts: 2,452
Default ADO SQL
Yes, that is the Chr(39)

RBS


"PaulD" <nospam wrote in message
...
FYI single quotes ' work also

so this should work
" WHERE (((MultVend.VEND_PART_NUM)='" & myString & "')); "

"Mike" wrote in message
...
: Thanks but just got it with this i had to have 3 """ instead of 2 ""
: WHERE (((MultVend.VEND_PART_NUM)=""" & myString & """));
: By the way what does the Chr(34) do ?
:
: "RB Smissaert" wrote:
:
: One of these 3 should work, probably the last:
:
: strSQL1 = "SELECT MultVend.VENDOR_ID, MultVend.VEND_PART_NUM, " & _
: "MultVend.VEND_DESC " & _
: "FROM MultVend " & _
: "WHERE (((MultVend.VEND_PART_NUM) = " & _
: myString & ")); "
:
: strSQL1 = "SELECT MultVend.VENDOR_ID, MultVend.VEND_PART_NUM, " & _
: "MultVend.VEND_DESC " & _
: "FROM MultVend " & _
: "WHERE (((MultVend.VEND_PART_NUM) = " & _
: Chr(34) & myString & Chr(34) & ")); "
:
: strSQL1 = "SELECT MultVend.VENDOR_ID, MultVend.VEND_PART_NUM, " & _
: "MultVend.VEND_DESC " & _
: "FROM MultVend " & _
: "WHERE (((MultVend.VEND_PART_NUM) = " & _
: Chr(39) & myString & Chr(39) & ")); "
:
:
: RBS
:
:
: "Mike" wrote in message
: ...
: Hi all I'm really at a loss any help would be great
: Thanks Mike
:
: I have SQL that works with no problem
:
: strSQL1 = "SELECT MultVend.VENDOR_ID, MultVend.VEND_PART_NUM,
: MultVend.VEND_DESC " _
: & " FROM MultVend " _
: & " WHERE (((MultVend.VEND_PART_NUM)=""14002"")); "
:
: and this will NOT
: Where myString = me.textbox1.value
:
: strSQL1 = "SELECT MultVend.VENDOR_ID, MultVend.VEND_PART_NUM,
: MultVend.VEND_DESC " _
: & " FROM MultVend " _
: & " WHERE (((MultVend.VEND_PART_NUM)=" & myString & ")); "
:
:



Reply With QuoteReply With Quote
  #8   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
  
Posts: 3,101
Default ADO SQL
Thanks RD
I have been at coding for about 8 months at the school of 9pm till 3am LOL
Still learning and thanks for the lesson

"RB Smissaert" wrote:

By the way what does the Chr(34) do ?

That is the double-quote character.
Chr(39) is a single quote.
If your 3 double quotes work then the one with Chr(34) may also work.
I think it gets less confusing if you combining single or double quotes to
use
the character codes instead, so Chr(34) etc.

RBS


"Mike" wrote in message
...
Thanks but just got it with this i had to have 3 """ instead of 2 ""
WHERE (((MultVend.VEND_PART_NUM)=""" & myString & """));
By the way what does the Chr(34) do ?

"RB Smissaert" wrote:

One of these 3 should work, probably the last:

strSQL1 = "SELECT MultVend.VENDOR_ID, MultVend.VEND_PART_NUM, " & _
"MultVend.VEND_DESC " & _
"FROM MultVend " & _
"WHERE (((MultVend.VEND_PART_NUM) = " & _
myString & ")); "

strSQL1 = "SELECT MultVend.VENDOR_ID, MultVend.VEND_PART_NUM, " & _
"MultVend.VEND_DESC " & _
"FROM MultVend " & _
"WHERE (((MultVend.VEND_PART_NUM) = " & _
Chr(34) & myString & Chr(34) & ")); "

strSQL1 = "SELECT MultVend.VENDOR_ID, MultVend.VEND_PART_NUM, " & _
"MultVend.VEND_DESC " & _
"FROM MultVend " & _
"WHERE (((MultVend.VEND_PART_NUM) = " & _
Chr(39) & myString & Chr(39) & ")); "


RBS


"Mike" wrote in message
...
Hi all I'm really at a loss any help would be great
Thanks Mike

I have SQL that works with no problem

strSQL1 = "SELECT MultVend.VENDOR_ID, MultVend.VEND_PART_NUM,
MultVend.VEND_DESC " _
& " FROM MultVend " _
& " WHERE (((MultVend.VEND_PART_NUM)=""14002"")); "

and this will NOT
Where myString = me.textbox1.value

strSQL1 = "SELECT MultVend.VENDOR_ID, MultVend.VEND_PART_NUM,
MultVend.VEND_DESC " _
& " FROM MultVend " _
& " WHERE (((MultVend.VEND_PART_NUM)=" & myString & ")); "




Reply With QuoteReply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

Posting Rules
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


All times are GMT +1. The time now is 11:14 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Contact Us ExcelBanter forum home Privacy Statement