[ic] search-region/query conflict? - Please Help

[Thomas J.M. Burton]

Mike Heins wrote:
> Quoting Thomas J.M. Burton (tom at globalfocusdm.com):
>>>Mike Heins wrote:
>>>I don't understand why you are only getting two things, but I think
>>>you have a more basic thing that should be done.
>>>
>>>This is normal for IC:
>>>
>>>  [perl tables="promotions"]
>>>    # Query promotions table
>>>    my $sql = qq{SELECT code,discount_amount
>>>       FROM promotions ORDER BY type,active_month};
>>>
>>>    my $db = $Db{promotions};
>>>
>>>    my $hash_results = $db->query({ sql => $sql, hashref => 1 });
>>>
>>>    # Loop through query results, output text
>>>    foreach my $row (@$hash_results) {
>>>      $out.= "$row->{code}	";
>>>      $out.= "$row->{discount_amount}\n";
>>>    }
>>>
>>>    return $out;
>>>  [/perl]
>>
>>
>>Thanks for the tip, Mike. It's nice to have a simple example of how that 
>>code should be done. However, this does still leave me with my 
>>problem...and if you don't know why the full query results are not being 
>>returned, then who does?
> 
> 
> If they are not being returned with that code, there is something wrong
> with your database. I note you don't mention what it is or what its
> structure and IC configuration is....
> 

Full results are returned when that code is used in any page besides the 
results.html page, in which it only returns two results.

I'm using the default DB, set up as follows:

dbconf/default_db/promotions.dbm
Database            promotions     promotions.txt      TAB
Database            promotions     HOT                 1


products/promotions.txt
code	type	active_month	timed	start_date	end_date	use_year 
discount_skus	discount_type	discount_amount	dep_1	dep_op_1 
dep_val_1	dep_2	dep_op_2	dep_val_2	dep_3	dep_op_3	dep_val_3	dep_4 
dep_op_4	dep_val_4	description_1	url	link_text	description_2 
teaser_text	cart_text
PR00004	1	04		20040607	20040607	 
MAXI-SPEED,MULTI-SPEED,VTRAINER	1	10													 
search="/co=yes/fi=products/sf=show_thumb/se=1/sf=category/se=equipment/sf=code/se=MULTI-SPEED|MAXI-SPEED|VTRAINER/tf=sortord/va=promo=1"
PR00011	1	11		20040607	20040607	 
A-LADDER,B-LADDER,B-LADDER-JR	1	10													 
search="/co=yes/fi=products/sf=show_thumb/se=1/sf=category/se=equipment/sf=code/se=A-LADDER|B-LADDER|S-LADDER|S-LADDER-JR/tf=sortord/va=promo=1"
PR00002	1	02		20040607	20040607	 
HURDLE,HURDLE-12,HURDLE-6	1	10														HURDLE
PR00008	1	08		20040607	20040607	 
S-BALL,S-BALL-65,S-BALL-55,S-BALL-75	1	10														S-BALL
PR00006	1	06		20040607	20040607	 
A-LADDER,B-LADDER,B-LADDER-JR	1	10													 
search="/co=yes/fi=products/sf=show_thumb/se=1/sf=category/se=equipment/sf=code/se=A-LADDER|B-LADDER|S-LADDER|S-LADDER-JR/tf=sortord/va=promo=1"
PR00012	1	12		20040607	20040607			1	10	cat	1	videos											videos
PR00010	1	10		20040607	20040607		BJR,SJR,CWROPE	1	10													 
search="/co=yes/fi=products/sf=show_thumb/se=1/sf=category/se=equipment/sf=code/se=BJR|SJR|CWROPE/tf=sortord/va=promo=1"
PR00009	1	09		20040607	20040607	 
DMB,MB,DMB-10,DMB-02,DMB-08,DMB-06,DMB-04,MB-3,MB-2,MB-5,MB-4	1	10							 
					 
search="/co=yes/fi=products/sf=show_thumb/se=1/sf=category/se=equipment/sf=code/se=DMB|MB/tf=sortord/va=promo=1"
PR00007	1	07		20040607	20040607			1	10													 
search="/co=yes/fi=products/sf=show_thumb/se=1/sf=category/se=training/sf=code/se=WRK-baseball|WRK-basketball|WRK-football|WRK-soccer|WRK-volleyball/tf=sortord/va=promo=1"
PR00005	1	05		20040607	20040607		LRESIST	1	10														LRESIST
PR00003	1	03		20040607	20040607		SVEST	1	10														SVEST
PR00001	1	01		20040607	20040607		S-BALL,S-BALL-65,S-BALL-55,S-BALL-75	1	10
PR00033	2			20040609	20040609		SFV-020	1	10	itemqty	2	HURDLE6=6,HURDLE12=6
PR00028	2			20040609	20040609		SFV-011	1	10	item	1 
A-LADDER,VTRAINER,MAXSPEEDB,MAXSPEEDV															Promo Price (ordered 
with related equipment)


Hope that's what you were asking.

Thanks,
Tom


-- 
________________________________________
Thomas J.M. Burton
Design & Production Director
Global Focus Digital Media, LLC
www.globalfocusdm.com