Re: [ic] [query] Question

[adam@opusvl.com]

what would happen if you were to rewrite the
query to be something like below ?

 [sql type="set" base="CompanyInfo" interpolate="1"]
  UPDATE CompanyInfo SET
   contactname = '[value contactname]',
   company = '[value company]'
 [/sql]

does it also return an error ?

adam

Support wrote:
> 
> Hello everyone --
> 
> Here is a quick question...
> 
> [query interpolate=1 sql="UPDATE CompanyInfo SET contactname='[value
> contactname]', company='[value company]'"][seti
> name="updated"]DONE.[/seti][/query]
> 
> But, in the error.log (catalog) I get the following error message:
> 
> [18/September/2001:08:54:43 -0400] webstore
> /cgi-bin/webstore/process.html SQL query failed for CompanyInfo: DBI
> tables must be updated natively.
> 
> Any ideas?  Running Interchange 4.8.1 - "AllowGlobal webstore" in the
> interchange.cfg file is already enabled for the catalog.  MySQL
> database.
> 
> Thanks,
> 
> Jason Korkin
> President
> Korksoft LLC

-- 
 -- 110010100 --
_______________________________________________
interchange-users mailing list
interchange-users@interchange.redhat.com
http://interchange.redhat.com/mailman/listinfo/interchange-users