Follow us on Twitter X-Cart on Facebook Wiki
Shopping cart software Solutions for online shops and malls

Problems with Searching Extra Fields

 
Reply
   X-Cart forums > X-Cart 4 > Dev Questions > Changing design
 
Thread Tools Search this Thread
  #1  
Old 07-08-2003, 12:43 PM
 
harold5370 harold5370 is offline
 

Newbie
  
Join Date: Jun 2003
Location: Moreno Valley, CA.
Posts: 7
 

Default Problems with Searching Extra Fields

I am trying to extend the functionality of the search by setting param00 to a lsit of keywords which I can search on.. I have modified the following line
Code:
$substring_condition = ($substring==""?"":"and ($sql_tbl[products].product like '%$substring%' or $sql_tbl[products].descr like '%$substring%') ");

to this

Code:
$substring_condition = ($substring==""?"":"and ($sql_tbl[products].product like '%$substring%' or $sql_tbl[products].descr like '%$substring%' or $sql_tbl[products].param00 like '%$substring%') ");

but I still can not seem to return any results to match the text in the keywords (param00) field. Does anyone have experience or suggestions with this?
Reply With Quote
  #2  
Old 07-14-2003, 12:25 PM
 
harold5370 harold5370 is offline
 

Newbie
  
Join Date: Jun 2003
Location: Moreno Valley, CA.
Posts: 7
 

Default

Doesn't anyone have any idea here?
Reply With Quote
  #3  
Old 07-20-2003, 07:57 AM
 
walteis walteis is offline
 

Advanced Member
  
Join Date: Jan 2003
Location: USA
Posts: 65
 

Default

Where did you make the change? I did a similar change to customer/search.php and it works fine.

Walt
Reply With Quote
  #4  
Old 08-19-2003, 10:56 AM
 
rodneyw rodneyw is offline
 

Senior Member
  
Join Date: Mar 2003
Posts: 162
 

Default

ok, after searching the forums and trying to figure this out I can't not get the customer/search.php to pick up on the extra field (param00)

There seems to be only 2 places where it makes sense to add the conditions for param00 and that is in the $substring_query. Anything wrong with my code here?

Code:
$substring_query = "AND (($sql_tbl[products].param00 like '%$substring%' or $sql_tbl[products].product like '%$substring%' ....

and

Code:
$substring_query = "AND ($sql_tbl[products].param00 like '%$substring%' or $sql_tbl[products].product like '%$substring%' OR ....
Reply With Quote
  #5  
Old 08-19-2003, 11:12 AM
  groovico's Avatar 
groovico groovico is offline
 

X-Man
  
Join Date: Apr 2003
Location: Firetanksoftware.com
Posts: 2,326
 

Default

From our experience there is bugs or strange logic in the way x-cart deals with extrafields. You are not guaranteed slot param00 if you have deleted/removed/edited your extra fields any anyway.

They appear to shift around when one is removed.
__________________
Groovico

Used by X-carters the world over:
Marketing Manager Pro Bundle For X-cart
Featured Product Manager for X-cart
Feed manager pro for X-cart

http://www.firetanksoftware.com

Celebrating 7 Years of providing quality X-cart Add ons and X-cart Mods for x-cart 3.X to X-cart 4.4.X
Reply With Quote
  #6  
Old 08-19-2003, 11:53 AM
 
rodneyw rodneyw is offline
 

Senior Member
  
Join Date: Mar 2003
Posts: 162
 

Default

Reply With Quote
Reply
   X-Cart forums > X-Cart 4 > Dev Questions > Changing design


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -8. The time now is 01:30 PM.

   

 
X-Cart forums © 2001-2020