If I don't put it in quotes, then it just displays all the data in the db.
Thanks for the reply
In a message dated 2/26/02 9:09:39 PM, apex at forked dot net writes:
>I have never used a database in rb, and don't use them much in general,
>
>but it looks to me like
>'titleField.text' shouldn't be in quotes?
>
>Regards,
>Jon Daniels
>
>
>On Tuesday, February 26, 2002, at 04:58 PM, Danandjulies at aol dot com wrote:
>
>> OK, here's my delima. I've got an application that I use to maintain
>an
>> inventory of my dvds. cds etc... I've got the db thing working great
>and
>> I've
>> got a listbox that will display all the info in the db. My problem is,
>I
>> want
>> to be able to search for a dvd by entering the title in an editfield.
>I
>> want
>> the search to be accomplished with a pushbutton. I've got the
>> databasequery
>> bound to the listbox, but I can't get the sqlselect from where to work.
>
>> It's
>> either not working, or my listbox isn't displaying the info. heres the
>
>> query
>>
>> Select * from dvd where title ='titleField.text'
>>
>> the action event for the pushbutton is
>>
>> databasequery1.runQuery
>>
>> The binding for the databasequery to the list box is
>>
>> bind listbox1 with list data from databaseQuery1 results
>>
>> is there something that I'm missing?
>>
>> Is it possible to to use the editfield this way, or do I have to convert
>
>> the
>> text from the editfield to something else before the databasequery can
>
>> use it
>> in a search?
>>
>> Thanks
>> Dan
>>
>> ---
>> Subscribe to the digest:
>> <mailto:realbasic-nug-digest at lists dot realsoftware dot com>
>> Unsubscribe:
>> <mailto:realbasic-nug-off at lists dot realsoftware dot com>
>>
>
>
>---
>Subscribe to the digest:
><mailto:realbasic-nug-digest at lists dot realsoftware dot com>
>Unsubscribe:
><mailto:realbasic-nug-off at lists dot realsoftware dot com>
>
>
>----------------------- Headers --------------------------------
>Return-Path: <realbasic-nug at lists dot realsoftware dot com>
>Received: from rly-yd03.mx.aol.com (rly-yd03.mail.aol.com [172.18.150.3])
>by air-yd03.mail.aol.com (v83.35) with ESMTP id MAILINYD31-0226210939;
>Tue, 26 Feb 2002 21:09:39 -0500
>Received: from lists.realsoftware.com (lists.realsoftware.com
[209.198.132.125])
>by rly-yd03.mx.aol.com (v83.35) with ESMTP id MAILRELAYINYD34-0226210900;
>Tue, 26 Feb 2002 21:09:00 -0500
>Received: from forked.net by lists.realsoftware.com with SMTP; Tue, 26
>Feb
> 2002 20:08:31 -0600
>Date: Tue, 26 Feb 2002 17:07:32 -0900
>Subject: Re: List box help
>Content-Type: text/plain; charset=US-ASCII; format=flowed
>Mime-Version: 1.0 (Apple Message framework v481)
>From: Jon Daniels <apex at forked dot net>
>To: "REALbasic Network Users Group" <realbasic-nug at lists dot realsoftware
>dot com>
>Content-Transfer-Encoding: 7bit
>In-Reply-To: <146 dot a2f2698 dot 29ad9763 at aol dot com>
>Message-Id: <C23C32F4-2B26-11D6-AC20-000A27E387A8 at forked dot net>
>X-Mailer: Apple Mail (2.481)
>Reply-To: "REALbasic Network Users Group"
> <realbasic-nug at lists dot realsoftware dot com>
>Sender: <realbasic-nug at lists dot realsoftware dot com>
>Precedence: Bulk
>List-Software: LetterRip Pro 3.0.7 by Fog City Software, Inc.
>List-Subscribe: <mailto:realbasic-nug-on at lists dot realsoftware dot com>
>List-Digest: <mailto:realbasic-nug-digest at lists dot realsoftware dot com>
>List-Unsubscribe: <mailto:realbasic-nug-off at lists dot realsoftware dot com>
>
>
|