Re: [ic] page generation for the admin area orders

[Peter <suppressed>]

On 11/01/2005 05:14 PM, James P. Kinney III wrote:
> Plus I got an error message when I ran a test:
>
> table transactions: set_slice error as called by Vend::Data: DBD::Pg::st
> execute failed: ERROR: invalid input syntax for type timestamp: "" query
> was:update transactions SET
> currency_locale=?,fname=?,subtotal=?,po_number=?,comments=?,state=?,b_country=?,email=?,campaign=?,b_lname=?,shipping=?,order_number=?,parent=?,salestax=?,b_company=?,archived=?,order_wday=?,username=?,b_fname=?,zip=?,payment_method=?,b_phone=?,order_date=?,b_address1=?,lname=?,b_state=?,address1=?,shipmode=?,phone_day=?,store_id=?,status=?,avs=?,b_city=?,phone_night=?,city=?,fax=?,order_ymd=?,company=?,b_zip=?,country=?,b_address2=?,order_id=?,affiliate=?,deleted=?,total_cost=?,address2=?,nitems=?,update_date=?,handling=?,complete=? WHERE code = 'TEST0004' values were:'','wilma','169','','','MA','','suppressed','','','0.00','TEST0004','','0.00','','','2','00003','','10111','credit_card','','20051101 20:07:01','','flintstone','','123 any st','JACKSVAC (Jacks $7.95 rate)','5551234','','pending','','','','bedrock','','20051101','','','US','','','ORDER_DESK','','176.95','','1','','0.00','0'

You have a field of type timestamp, probably update_date that you're 
leaving blank, and a blank value is not a valid timestamp for 
Postgresql.  You need to fill in the update_date for it to work, or 
change the field type to something else such as character varying(26) 
(gives enough space for YYYY-MM-DD HH:MM:SS.mmmmmm).

> > > > Where is the "process" page generated?
> >
> > process isn't a real page.  See 
> > <http://www.icdevgroup.org/interchange-doc-5.2.0/icfaq.html#Where%20is%20process.html>
>
>
> Thanks. That was what I thought it was. Now to dig into the guts...

Also see <http://www.interchange.rtfm.info/docs/frames/ictemplates_35.html>.

Peter
_______________________________________________
interchange-users mailing list
suppressed
http://www.icdevgroup.org/mailman/listinfo/interchange-users