leggn at denison
May 16, 2011, 1:02 PM
Post #2 of 3
(335 views)
Permalink
|
|
Re: Remove expire date via bric_soap or database
[In reply to]
|
|
Hi Chris,
You could write a quick perl script using the Bric API to accomplish
this, or just an update query in the DB directly. The bric_soap issue
sounds like a bug to me.
The timestamp field in the DB won't accept an empty string, but you can
set it to NULL to make it blank.
-Nick
On 5/16/2011 3:57 PM, Schults, Chris wrote:
> I need to remove the expire date from hundreds of stories. Any ideas on
> how to do this?
>
> I've tried using bric_soap by removing the<expire_date> element
> altogether and replacing with<expire_date></expire_date> with no
> change.
>
> When updating the story table, I can't seem to insert a blank value as I
> get an "invalid input syntax for type timestamp" error.
>
> Thanks,
>
> Chris
>
> --------------------------------
>
> Chris Schults
> Web Developer
> PCC Natural Markets
> 206-547-1222 x104
> chris.schults [at] pccsea
> http://www.pccnaturalmarkets.com
>
>
|
