Forum  Discuss AliComm...  Discussions  Batch Update VIA sql to LongDescription
Previous Previous
 
Next Next
New Post 9/3/2008 2:16 AM
Unresolved
  Bacus812
30 posts
No Ranking


Batch Update VIA sql to LongDescription 

Frank,

I'm executing some sql script on the LongDesription field to remove some undesirable html.  The problem is the changes don't take affect until I actually edit the product via Store Admin and Click Update.  Just to be clear, under store admin / product edit I do not modify the longDescription whatsoever I only click the product udpate button and the changes appear.  It's like the data is being cached but I've gone as far to restart the application, IIS-7 and clear DNN cache.

Any ideas?

Bacus

 
New Post 9/3/2008 4:08 AM
  AliCommerce
1056 posts
1st Level Poster


Re: Batch Update VIA sql to LongDescription 

It's a bit weird. Actually, no products are cached. Did changes show up after you restarted IIS?


Frank Wang
Software Architect
AliCommerce.com
The best DNN eCommerce, shopping cart and store modules. 100% satisfaction guaranteed.
 
New Post 9/3/2008 7:35 AM
  Bacus812
30 posts
No Ranking


Re: Batch Update VIA sql to LongDescription 

Hi  Frank,

No they won't show up until I edit the product and click update.

Bacus

 
New Post 9/3/2008 1:55 PM
  AliCommerce
1056 posts
1st Level Poster


Re: Batch Update VIA sql to LongDescription 

Ok, we'll investigate this soon.


Frank Wang
Software Architect
AliCommerce.com
The best DNN eCommerce, shopping cart and store modules. 100% satisfaction guaranteed.
 
New Post 9/5/2008 7:11 PM
  Bacus812
30 posts
No Ranking


Re: Batch Update VIA sql to LongDescription 

Frank,

Another strange observation I've discovered about this is that if I edit a product and place FCK Editor in "Basic Text Box" mode and proceed to make changes to the html then update the product it does NOT apply the changes to the product.

In one case I removed quotes, updated the product, then viewed in a different browser and the quote was still there.  When I switch to "Rich Text Editor" mode and follow the same process then the updates apply.

This may help you pinpoint the issue.

Thanks,

Bacus

 
Previous Previous
 
Next Next
  Forum  Discuss AliComm...  Discussions  Batch Update VIA sql to LongDescription
Copyright 2008 by CandoSuite Terms Of Use Privacy Statement