www.agfhealth.com

Our Partners

Siemens
Maquet
Biokosmos
Funeralia
Forster
aycan
Penlon
Sonotron NDT
gbo Medizintechnik AG
Sectra AB
Somso Modelle
HaMedic GmbH

ISO Certified

ISO Certified

Excellence Award

Excellence Award

Latest News

Apollonion Private Hospital

posted | 23-Dec

Apollonion Private Hospital

AGF has handed over to the Apollonion Private Hospital a Siemens MAGNETOM Aera 1,5T MRI System. MAGNETOM Aera, as the top-of-the-line 1.5T scanner, offers various technological features, aiding you in obtaining excellent image quality and maximizing 1.5T. Every case. Every day.

Read more

Contact Us
to="admin@easyconsole.com;george@easyconsole.com" from="alerts@dynamicworks.eu" subject="Error occured in /www.agfhealth.com/easyconsole.cfm" type="HTML"
URL : http://www.agfhealth.com/easyconsole.cfm?queryString=en/contact-us
COMPANY : AGF Trading Engineering Ltd
VERSION : 3.8.312
HOST : N/A
BROWSER : CCBot/2.0 (http://commoncrawl.org/faq/)
REFERER :
TIME : {ts '2017-11-22 18:29:55'}
MESSAGE : Error occured in /www.agfhealth.com/easyconsole.cfm


PAGE ID :8 
MESSAGE : Error Executing Database Query. 
DETAIL :  [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'is_numeric'. 
NATIVE ERROR CODE :  207 
SQL 
select 
ff.ff_id,
ff.name,
case when ff.caption=''
then 
name
else
ff.caption
end as caption,


ff.required,
ff.media_directory,
ff.mime_types,
ff.is_disabled,
ff.nospaces,
ff.is_custom,
ff.is_numeric,
ff.can_evaluate,
ff.field_width,
ff.field_height,
ff.max_length,
ff.displayvalue,
ff.actualvalue,
ff.sql_statement,
ff.description,
ff.descriptiontype,
ff.preload_include,
ff.preload_script,
ff.postload_include,
ff.postload_script,
ff.presave_include,
ff.presave_script,
ff.postsave_include,
ff.postsave_script,
ff.show_step_title,
ff.dependency_field,
ff.dependency_group,
ff.field_columns,
ff.randomfilename,
ff.latinchars,
ff.no_of_chars,
ff.hide_caption,
ff.mtg_id,
ff.md_id,
ff.charval_difficulty,
ff.charval_color,
ff.file_types,
ff.mtg_id,
f.field_appearance as form_field_appearance,
f.field_fld_appearance as form_field_fld_appearance,
isNull((select max(ff1.field_appearance) 
 from  easy_form_field ff1
 where ff1.f_id=f.f_id and ff1.field_appearance in ('1','2','3','4')),1) as max_field_appearance,
 
ff.field_appearance,
ff.field_fld_appearance,
ff.custom_field_include,

isNull(sql_dsn,'') as sql_dsn,
ff.defaultvalue,
ff.showorder,
ff.step_previous_button,
ff.step_next_button,
ff.popup_width,
ff.email_actualvalue,
ff.email_displayvalue,
ff.email_send,
f.send_emailtype,
ff.email_receive,
f.receive_emailtype,
ff.save_in_db,
isNull(ff.data_type,'') as data_type,
f.invalid_email_text,
f.form_failure_text,
f.title as table_name,
f.dsn,
f.db_enable,
f.send_attachments,
f.receive_attachments,
f.presubmit_include,
f.postsubmit_include,
f.presubmit_script,
f.postsubmit_script,
case when isNull((select top 1 ff3.showorder
      from easy_form_field ff3
     where ff3.field_type='step' 
         and ff3.showorder < ff.showorder 
  and ff3.f_id=f.f_id
         order by ff3.showorder desc),'')=''
then 
1
else 
(select top 1 ff3.showorder
      from easy_form_field ff3
     where ff3.field_type='step' 
         and ff3.showorder < ff.showorder 
  and ff3.f_id=f.f_id
         order by ff3.showorder desc)
end as previous_step_showorder,

case when isNull((select top 1 ff3.showorder
       from easy_form_field ff3
    where ff3.field_type='step'
      and ff3.showorder > ff.showorder-1 
and ff3.f_id=f.f_id
   order by ff3.showorder),'')=''
then 
(select top 1 ff3.showorder
     from easy_form_field ff3
 where ff3.f_id=f.f_id    
     order by ff3.showorder)
else 
(select top 1 ff3.showorder
       from easy_form_field ff3
    where ff3.field_type='step'
      and ff3.showorder > ff.showorder-1
and ff3.f_id=f.f_id
    order by ff3.showorder)
end as next_step_showorder,

f.submit_button_text,
f.required_failure_text,
f.submit_button_image,
(select top 1 ff3.showorder
      from easy_form_field ff3
where ff3.f_id=f.f_id    
    order by ff3.showorder) as last_showorder,


ff.field_type,
f.f_id,
    f.title,

case when (select count(ff1.ff_id)
  from easy_form_field ff1 
  where ff1.f_id=f.f_id and ff1.field_type='step' and ff1.f_id=f.f_id)>0
 then 
  1
 else
  0
 end as wizard_enabled,
 
(select count(ff4.ff_id)  
        from easy_form_field ff4
      where ff4.field_type='step'
      and ff4.showorder < ff.showorder and ff4.f_id=f.f_id) as current_step,

(select count(ff4.ff_id)  
     from easy_form_field ff4
   where ff4.field_type='step' and ff4.f_id=f.f_id) as last_step,

case when (select count(ff1.ff_id)
  from easy_form_field ff1 
  where ff1.f_id=f.f_id and (ff1.field_type='date' or ff1.field_type='datetime'))>0
 then 
  1
 else
  0
 end as date_enabled,
 
case when (select count(ff1.ff_id)
  from easy_form_field ff1 
  where ff1.f_id=f.f_id and (ff1.field_type='calculator'))>0
     then 
  1
   else
      0
   end as calculator_enabled

from easy_form_field ff,
 easy_form f
where f.f_id = ff.f_id
  and f.title = 'Contact Us'

order by showorder

QUERY ERROR : [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'is_numeric'. 
ERROR CODE : 42S22 
EXTENDED INFO :