View Single Post
  #4  
Old 05-23-2006, 09:54 PM
 
Chris B Chris B is offline
 

eXpert
  
Join Date: Oct 2002
Posts: 226
 

Default I can't get this mode to work...

I keep getting the following error:

Quote:
INVALID SQL: 1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND fieldid= 2' at line 1
SQL QUERY FAILURE: SELECT value FROM xcart_extra_field_values WHERE productid = AND fieldid= 2


I'm probably not doing something right in the display code. (I just arbitrarily used the number 2 as the field I wanted displayed.)


Code:
{assign var="shirtcolors" value=$products[product].productid|extrafield:2} {if $shirtcolors ne ""} Shirt Colors : {$shirtcolors} {/if}

Thanks,
Chris

Version 4.0.18
__________________
4.0x - 4.5x
Reply With Quote