WildCard Defaults

[Bill]

I'm trying to use % as the default value in the query variables. I have a
select list displaying numbers. At the top of the select list I want an
"Select All" option. When I try to use % in either the form or the query I
get the following error

Error Type:
Microsoft JET Database Engine (0x80040E14)
Syntax error in query expression 'DP_homes.price>=0 AND
DP_homes.price<=100001 AND DP_homes.totbed=% AND DP_homes.list_type=1'.
/searchlist.asp, line 51

this is line 51
open rsDisplayList.Open()

If I replace % with an actual field value like 1 it works fine but only
return all which meet that criteria.

Any help finding what I'm doing wrong would be greatly appreciated.

Bill

[Julian Roberts]

Needs to be LIKE '%'

--
Jules
[url]http://www.charon.co.uk/charoncart[/url]
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004

[Bill]

Using that I get this

Error Type:
Microsoft JET Database Engine (0x80040E14)
Syntax error in query expression 'DP_homes.price>=0 AND
DP_homes.price<=100001 AND DP_homes.totbed=''%'' AND DP_homes.list_type=1'.
/searchlist.asp, line 51

Bill
"Julian Roberts" <newsg@charon.co.uk> wrote in message
news:d3eo70$1ih$1@forums.macromedia.com...

> Needs to be LIKE '%'
>
> --
> Jules
> [url]http://www.charon.co.uk/charoncart[/url]
> Charon Cart 3
> Shopping Cart Extension for Dreamweaver MX/MX 2004
>
>

[Les Matthews]

In that query, the value of totbed must be a percent sign.
I don't see the LIKE operator Jules mentioned.
If the value of totbed can be anything, why include it in the query at all?

"Bill @gmail.com>" <bill.betournay<SpamTrap> wrote in message
news:d3etgs$944$1@forums.macromedia.com...

> Using that I get this
>
> Error Type:
> Microsoft JET Database Engine (0x80040E14)
> Syntax error in query expression 'DP_homes.price>=0 AND
> DP_homes.price<=100001 AND DP_homes.totbed=''%'' AND
> DP_homes.list_type=1'.
> /searchlist.asp, line 51
>
> Bill
> "Julian Roberts" <newsg@charon.co.uk> wrote in message
> news:d3eo70$1ih$1@forums.macromedia.com...

>> Needs to be LIKE '%'
>>
>> --
>> Jules
>> [url]http://www.charon.co.uk/charoncart[/url]
>> Charon Cart 3
>> Shopping Cart Extension for Dreamweaver MX/MX 2004
>>
>>

>
>

[Bill]

Hey Guys

Thought I'd stop back in and thank you both for the help. That didn't really
correct my problem but it did get me pointed in the right direction.

Bill


"Les Matthews" <LesAMatthews@yahoo.com> wrote in message
news:d3ev2q$b1u$1@forums.macromedia.com...

> In that query, the value of totbed must be a percent sign.
> I don't see the LIKE operator Jules mentioned.
> If the value of totbed can be anything, why include it in the query at
> all?
>
> "Bill @gmail.com>" <bill.betournay<SpamTrap> wrote in message
> news:d3etgs$944$1@forums.macromedia.com...

>> Using that I get this
>>
>> Error Type:
>> Microsoft JET Database Engine (0x80040E14)
>> Syntax error in query expression 'DP_homes.price>=0 AND
>> DP_homes.price<=100001 AND DP_homes.totbed=''%'' AND
>> DP_homes.list_type=1'.
>> /searchlist.asp, line 51
>>
>> Bill
>> "Julian Roberts" <newsg@charon.co.uk> wrote in message
>> news:d3eo70$1ih$1@forums.macromedia.com...

>>> Needs to be LIKE '%'
>>>
>>> --
>>> Jules
>>> [url]http://www.charon.co.uk/charoncart[/url]
>>> Charon Cart 3
>>> Shopping Cart Extension for Dreamweaver MX/MX 2004
>>>
>>>

>>
>>

>
>