Try: select * from courses where "course name" = 'My Course'
Double-quotes for table and field names and single-quotes for string values. Hope this helps. Cheers... >>> [EMAIL PROTECTED] 01/17/03 17:35 PM >>> Even Rbase will balk at course name, the space is a killer. how about either sel * from courses where coursename='My Course' sel * from courses where course_name='My Course' -----Original Message----- From: Dan Stein <[EMAIL PROTECTED]> To: Multiple recipients of list witango-talk <[EMAIL PROTECTED]> Date: Friday, January 17, 2003 5:02 PM Subject: Re: Witango-Talk: Execute SQL taf Yeah they were there I commented one of them out it makes no difference I just put it back in and you get the same results Select * from courses where course name=''My Course'' Could it be it works for you in Rbase but not for me in SQL 2000? -- Dan Stein Digital Software Solutions 799 Evergreen Circle Telford PA 18969 Land: 215-799-0192 Mobile: 610-256-2843 Fax 413-410-9682 FMP, WiTango, EDI,SQL 2000 [EMAIL PROTECTED] www.dss-db.com > From: "Ben Johansen" <[EMAIL PROTECTED]> > Organization: Intelisoft, Inc. > Reply-To: [EMAIL PROTECTED] > Date: Fri, 17 Jan 2003 16:23:46 -0800 > To: Multiple recipients of list witango-talk <[EMAIL PROTECTED]> > Subject: RE: Witango-Talk: Execute SQL taf > > You need to add the following assignments to the taf > > <@ASSIGN noSQLEncoding true> > to the section prior to submitting the DirectDBMS > > and > > <@ASSIGN noSQLEncoding false> > to the top of results section or the DirectDBMS > > Ben Johansen - http://www.pcforge.com > Authorized Witango Reseller http://www.pcforge.com/WitangoGoodies.htm > Latest downloads & List Archives @ http://www.witango.ws > > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] On Behalf Of Dan Stein > Sent: Friday, January 17, 2003 4:15 PM > To: Multiple recipients of list witango-talk > Subject: Witango-Talk: Execute SQL taf > > I have used this for awhile as a way to do a query, update, insert etc > to my > DB but I always have a problem with > Select * from courses where course name='My Course' > > The debug code shows > > Select * from courses where course name=''My Course'' > > Or if I put in Select * from courses where course name=My Course > > It gives me Select * from courses where course name=My Course > > Which is also an error > > What am I doing wrong and is there another solution > > > -- > Dan Stein > Digital Software Solutions > 799 Evergreen Circle > Telford PA 18969 > Land: 215-799-0192 > Mobile: 610-256-2843 > Fax 413-410-9682 > FMP, WiTango, EDI,SQL 2000 > [EMAIL PROTECTED] > www.dss-db.com > > > > ________________________________________________________________________ > TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] > with unsubscribe witango-talk in the message body > ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
