Nope that does not work either. Tried
Select * from registration where lname='stein' And Select * from "registration" where "lname"='stein' Debug says [Query] Select * from "registration" where "lname"=''stein'' Seems like the single quotes is being returned with a single quotes around the single quotes. -- 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: "Scott Cadillac" <[EMAIL PROTECTED]> > Reply-To: [EMAIL PROTECTED] > Date: Fri, 17 Jan 2003 17:47:56 -0800 > To: Multiple recipients of list witango-talk <[EMAIL PROTECTED]> > Subject: Re: Witango-Talk: Execute SQL taf > > 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 > ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
