Groups > comp.lang.basic.visual.misc > #823

Re: Another VB6 ADO Problem

From	"Farnsworth" <nospam@nospam.com>
Newsgroups	comp.lang.basic.visual.misc
Subject	Re: Another VB6 ADO Problem
Date	2012-02-27 01:30 -0500
Organization	Aioe.org NNTP Server
Message-ID	<jif7ut$iiq$1@speranza.aioe.org> (permalink)
References	<aef20ecb-3299-4890-9489-8e6106e1e9ed@p12g2000yqe.googlegroups.com>

Show all headers | View raw

"Jason Bodine" <jbodine1974@gmail.com> wrote in message 
news:aef20ecb-3299-4890-9489-8e6106e1e9ed@p12g2000yqe.googlegroups.com...
>          Set Cmd = New ADODB.Command
>          With Cmd
>               .ActiveConnection = Con
>               .CommandText = "SELECT * FROM [User_Profiles] WHERE
> [User_Name]=" & cmbSelect.Text

Not sure what else is wrong, but the above line doesn't surround the user 
name with double quotes.

Back to comp.lang.basic.visual.misc | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Another VB6 ADO Problem Jason Bodine <jbodine1974@gmail.com> - 2012-02-26 21:31 -0800
  Re: Another VB6 ADO Problem "Farnsworth" <nospam@nospam.com> - 2012-02-27 01:30 -0500
    Re: Another VB6 ADO Problem Jason Bodine <jbodine1974@gmail.com> - 2012-02-27 21:39 -0800
  Re: Another VB6 ADO Problem GS <gs@somewhere.net> - 2012-02-27 11:10 -0500
    Re: Another VB6 ADO Problem Jason Bodine <jbodine1974@gmail.com> - 2012-02-27 21:38 -0800
      Re: Another VB6 ADO Problem ralph <nt_consulting64@yahoo.net> - 2012-02-28 04:38 -0600
        Re: Another VB6 ADO Problem john@jeasonNoSpam.cix.co.uk (John K.Eason) - 2012-02-28 12:21 +0000

csiph-web