Great!!! Thanks, that did the trick, but whats the deal with the Plus signs???
In a message dated 2/26/02 9:20:28 PM, mbenonis_lists at mac dot com writes:
>You have to set the SQLQuery in code somewhere. Properties can't contain
>references to other properties.
>
>Put this in the Action Event of the Button, before you run the query:
>DatabaseQuery1.SQLQuery="Select * from dvd where title
>='"+titleField.text+"'"
>
>HTH,
>-Mike
>
>on 2/26/02 8:58 PM, Danandjulies at aol dot com at 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>
>
>
>----------------------- Headers --------------------------------
>Return-Path: <realbasic-nug at lists dot realsoftware dot com>
>Received: from rly-yg05.mx.aol.com (rly-yg05.mail.aol.com [172.18.147.5])
>by air-yg01.mail.aol.com (v83.35) with ESMTP id MAILINYG18-0226212028;
>Tue, 26 Feb 2002 21:20:28 -0500
>Received: from lists.realsoftware.com (lists.realsoftware.com
[209.198.132.125])
>by rly-yg05.mx.aol.com (v83.35) with ESMTP id MAILRELAYINYG53-0226211954;
>Tue, 26 Feb 2002 21:19:54 -0500
>Received: from mac.com by lists.realsoftware.com with SMTP; Tue, 26 Feb
> 2002 20:19:27 -0600
>User-Agent: Microsoft-Entourage/10.0.0.1309
>Date: Tue, 26 Feb 2002 21:19:36 -0500
>Subject: Re: List box help
>From: Mike Benonis <mbenonis_lists at mac dot com>
>To: REALbasic Network Users Group <realbasic-nug at lists dot realsoftware dot
>com>
>Message-ID: <B8A1AC68 dot 56A4%mbenonis_lists at mac dot com>
>In-Reply-To: <146 dot a2f2698 dot 29ad9763 at aol dot com>
>Mime-version: 1.0
>Content-type: text/plain; charset="US-ASCII"
>Content-transfer-encoding: 7bit
>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>
>
>
|