Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Searching a range
Right, Tony, that's pretty much what I figured. Thanks much! -
Changing field type?
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... -
Searching a range
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? -
Changing field type?
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... ? -
Changing field type?
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 :) -
Searching a range
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! -
Changing field type?
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? -
Variable variables?
THANK YOU!!! That worked perfectly!! You have been MOST helpful. I appreciate you taking the time to answer. Gratefully, Dawn -
Variable variables?
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... -
Variable variables?
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... -
-
Variable variables?
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? -
Variable variables?
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')); #... -
Variable variables?
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... -
-
Variable variables?
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... -
Variable variables?
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...
