Welcome, Guest ( Customer Panel | Login )




 All Forums
 VPCart Forum
 Customization
 description field sql
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

gledav
VP-CART New User

Australia
66 Posts

Posted - September 01 2008 :  22:38:45  Show Profile  Visit gledav's Homepage  Reply with Quote
Id like to customise the cdescription (short description) field so it picks up a portion (about the first 150 characters) of the extendeddesc field (Long description) and include a few dots at the end. I think I know how to write the sql to generate this: Left([extendeddesc],150)&""&"..." but I'm not sure where abouts to put it. Can anyone help?
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000
0 Item(s)
$0.00