Search results for query: *

Right, Tony, that's pretty much what I figured. Thanks much!

It isn't for numerical order, it's to find certain groupings. The customer is a realtor and she wants to be able to find a house by sold price, even if she can't remember the exact price. So, for example, anything between 100,000 and 150,000 ... or between 75,000 and 100,000 Would this...

This goes with my other question... currently the field is set as a varchar()... can this sort of search ("between") be used with a string or would I need to make that field an int field? That is the sort of thing I'm looking for, though. What further info would you need, Tony?

In that case, WOULD it be possible to search a range on the string, thus not needing to change the field type? The field is a price, and I need to be able to search - for example - everything less than 100,000 or anything above 100,000 or everything between 100,000 and 150,000... ?

Because I set it as varchar() when it really needs to be int I'm wanting to be able to search a range... it seems like that would be more feasible with integers than with strings. Thanks :)

I have a database where the customer wants to be able to find a price range (she has entered a definite price for each item)... how do I set it up for that sort of search? Thanks in advance!

If I have a field that is all numerical, but is set up as varchar, will it cause any problems in the already-entered data if I alter it to make that field an int field?

THANK YOU!!! That worked perfectly!! You have been MOST helpful. I appreciate you taking the time to answer. Gratefully, Dawn

Paul, I'm not really sure how to do it so most of that first bit is bits and pieces from other people's suggestions. I just included everything in the declaration so it wouldn't give me an Internal Server Error :) The $params($name) = $value was an obviously mistaken attempt to achieve the...

It still isn't doing what I need. Here is more info. sub update_closing { my ($name, $value, $params, %params, @variables, $variables, $loop, @values, $values); $params{$name} = $value; foreach $name ( param() ) { $value=$dbh->quote(param($name)); print "$name = $value "; push...

Thank you VERY much!!

How do I get each variable out of @variables as a $variable? That code made @variables contain v1v2v3v4v5 (etc) but I need $v1 $v2 (etc) How do I access them that way?

Ok, here's the whole entire subroutine. sub update_closing { my ($name, $value); foreach $name ( param() ) { $value=$dbh->quote(param($name)); print "$name = $value "; } # $dateclosed=$dbh->quote(param('dateclosed')); # $houseadd=$dbh->quote(param('houseadd')); #...

Right, exactly! Except it didn't work :) Here's what I'm doing - I'm passing a set of variables from one part of the script to the next. (I'm using one script, changing actions via CASE.) Rather than doing it the way I used to - listing each variable and assigning the param to it - I am trying...

Thank you!!

I have the following in my script: foreach $name ( param() ) { $value=$dbh->quote(param($name)); print "$name = $value "; } I need each $name to also be listed as variable $$name... is there any way to tell it to do that? I tried adding a line $$name=$name but that did not work...

I have the following in my script: foreach $name ( param() ) { $value=$dbh->quote(param($name)); print "$name = $value "; } I need each $name to also be listed as variable $$name... is there any way to tell it to do that? I tried adding a line $$name=$name but that did not work. Right...