Ask a Question related to Dreamweaver AppDev, Design and Development.
-
Nathon Jones #1
WHERE currencyfield IS WITHIN £20, either side, OF othercurrencyfield?
Sorry, about the description, but I have a currency field in my Access
table.
On a results page, I would like to list other items that are within £20,
either above or below, the price of the original item.
So if I create a new recordset, what is my SELECT statement going to have to
be?
SELECT *
FROM table
WHERE currencyfield = ('varField'-20) OR currencyfield = ('varField'+20)
I know that isn't right, but can't think of what I need? => or <= or a
mixture of both?
Hoping someone can help.
Thanks
Nath.
Nathon Jones Guest
-
read server side file from clent side
Hello all, i m using Influxis server.I have used these lines of code to create text file at server side:-> var myFile = new File("log_file.txt");... -
flashcom: client side cant access server side
hi all, i hav install the flash com on the PC. It work well, on the server PC, i can access and log in to the 'chat room'.. however, if im... -
Controls with a client side onLoad function or seting a cursor server side
Is there any way to create a web control that calls a client side onLoad function? Its diffucilt since you are not able to access the form or... -
Client side and server side scripting problem
Hiya I have a problem with using some client side and server side scripting together in an ASP. I'm using VBScript. What I'm trying to achieve... -
button evet ---- server side - client side ???
I want to use button. My question is that How can use server side and client site event at the same time. That is: I want to use button : when... -
Michael Fesser #2 Re: WHERE currencyfield IS WITHIN £20, either side, OF othercurrencyfield?
.oO(Nathon Jones)
Yep. Something like>On a results page, I would like to list other items that are within £20,
>either above or below, the price of the original item.
>
>So if I create a new recordset, what is my SELECT statement going to have to
>be?
>
>SELECT *
>FROM table
>WHERE currencyfield = ('varField'-20) OR currencyfield = ('varField'+20)
>
>I know that isn't right, but can't think of what I need? => or <= or a
>mixture of both?
SELECT ...
FROM table
WHERE currencyfield >= ('varField' - 20)
AND currencyfield <= ('varField' + 20)
You could also use the BETWEEN operator instead:
SELECT ...
FROM table
WHERE currencyfield BETWEEN ('varField' - 20) AND ('varField' + 20)
HTH
Micha
Michael Fesser Guest
-
Nathon Jones #3 Re: WHERE currencyfield IS WITHIN £20, either side, OF othercurrencyfield?
Thanks Michael.
Just wasn't sure how the statement should read.
Used the BETWEEN option and it's worked out fine.
Much appreciated.
Nath.
"Michael Fesser" <netizen@gmx.net> wrote in message
news:e0d851t51g1s4u48o97l3hclb0fg1jum8i@4ax.com...> .oO(Nathon Jones)
>>>>On a results page, I would like to list other items that are within £20,
>>either above or below, the price of the original item.
>>
>>So if I create a new recordset, what is my SELECT statement going to have
>>to
>>be?
>>
>>SELECT *
>>FROM table
>>WHERE currencyfield = ('varField'-20) OR currencyfield = ('varField'+20)
>>
>>I know that isn't right, but can't think of what I need? => or <= or a
>>mixture of both?
> Yep. Something like
>
> SELECT ...
> FROM table
> WHERE currencyfield >= ('varField' - 20)
> AND currencyfield <= ('varField' + 20)
>
> You could also use the BETWEEN operator instead:
>
> SELECT ...
> FROM table
> WHERE currencyfield BETWEEN ('varField' - 20) AND ('varField' + 20)
>
> HTH
> Micha
Nathon Jones Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
