Home Switzerland Forum Switzerland Guide Moving to Switzerland Real Estate Healthcare in Switzerland
Switzerland
Resources
City Guides
JoinSign In
Cigna International Health Insurance

Switzerland Forum

PM's Friends Profile

Our Switzerland Expat Network provides extensive information about moving to Switzerland. Moving overseas requires a lot of research, and our forum for expats in Switzerland will help you find out what living in Switzerland and working in Switzerland requires. Contains expat reports and articles about living Switzerland and more. Ask about jobs in Switzerland, international living and life in Geneva, apartments in switzerland and more!

Post New Topic
  Topic Originator Last Post
pinned post pinned post Coronavirus Information & Support (No Politics) (0) adminee 3/20/2020 12:49 PM
no new messages Abenteuer in Deutschland (0) ESue8215 4/8/2002 3:40 PM
no new messages Looking for Doctor in Geneva (0) mkleckner 4/8/2002 2:06 PM
no new messages Can American Dentist work in Switzerland? (2) vickyf 3/29/2002 9:08 AM
no new messages is life in Zurich recommendable? (5) rkelly 3/21/2002 3:53 AM
no new messages AHV/ALV when leaving CH (2) wlibby 2/22/2002 10:47 AM
Cigna International Health Insurance

no new messages work in Zurich (4) Kiwigirl 2/18/2002 6:02 PM
no new messages Need a home (0) windquest 2/13/2002 2:54 PM
no new messages Living in Fribourg (0) thh101 2/5/2002 4:57 AM
no new messages American expat in Germany needs a helping hand. (2) amiexpat 2/1/2002 10:19 AM
no new messages Publications for US Expats in Switzerland (3) bonanza81 1/28/2002 12:26 PM
no new messages Don't accept "deals" from Atlas! (0) ElyMom 1/15/2002 8:14 AM
poll taxes (0) dan 12/31/2001 5:24 PM
no new messages American education in Lugano (0) Marcello 12/5/2001 3:33 PM
<<  < 34   35   36   37   of 37 pages
34   35   36   37   of 37 pages
Expatriate Health Insurance

Get a quote for expat health insurance in Switzerland.

International Moving Quotes

Moving to Switzerland? Get a moving quote.


Mail Forwarding to Switzerland

Mail Forwarding to Switzerland.


Expat Tax

Expat Tax Preparation, Expat Tax Professionals

Join Today (free)

Join Expat Exchange to meet expats in your area or get advice before your move. It's FREE and takes 1 minute!

Cigna Expat Health InsuranceExpatriate Health Insurance

Get a quote for expat health insurance in Switzerland from our partner, Cigna Global Health.
Get a Quote

Expats-in-Switzerland10 Tips for Living in Switzerland

Advice from expats in Switzerland on housing search, finding a job in Switzerland, international schools, expat clubs and organizations, learning the language and cost of living. A must read for newcomers and anyone moving to Switzerland.

Advice from expats in Switzerland on housing search, finding a job in Switzerland, international schools, expat clubs and organizations, learning the language and cost of living. A must read for newc...

Expats-in-Switzerland5 Tips for Living in Zug, Switzerland

Zug, Switzerland is a beautiful city and very popular among expats. 30 minutes south of Zurich, this low-tax region is home to numerous multinational companies.

Zug, Switzerland is a beautiful city and very popular among expats. 30 minutes south of Zurich, this low-tax region is home to numerous multinational companies. ...

Expats-in-Zurich5 Tips for Living in Zurich, Switzerland

Expats in Zurich, Switzerland find themselves in one of the most important financial centers in Europe, and the world. While they are treated to a city with many English speakers, it can be difficult to find good housing... and friends!

Expats in Zurich, Switzerland find themselves in one of the most important financial centers in Europe, and the world. While they are treated to a city with many English speakers, it can be difficult...

Switzerland Guide
Other Links
Our Story Our Team Contact Us Submit an Article Advertising Travel Warnings

Copyright 1997-2020 Burlingame Interactive, Inc.

Privacy Policy Legal


Debugging Information
ColdFusion Server Enterprise 9,0,2,282541
Template /expat/index.cfm
Time Stamp 07-Jul-20 08:20 AM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 162.158.78.230
Host Name 162.158.78.230


Execution Time

Total Time Avg Time Count Template
110 ms 110 ms 1 /home/www/html/expat/Application.cfm
49 ms 49 ms 1 /home/www/html/expat/navsidesbottomforum_rdesign5.cfm
49 ms 49 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
48 ms 48 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
33 ms 33 ms 1 /home/www/html/expat/topics_rdesign5.cfm
22 ms 22 ms 1 /home/www/html/navcontentbox.cfm
17 ms 17 ms 1 /home/www/html/expat/navtop2forum_rdesign5.cfm
16 ms 16 ms 1 /home/www/html/expat/queries/mysql/qry_GetTopics.cfm
10 ms 10 ms 1 /home/www/html/navmetaforums_rdesign5.cfm
6 ms 6 ms 1 /home/www/html/expat/queries/mysql/qry_GetPinnedTopics.cfm
6 ms 6 ms 1 /home/www/html/navtop_rdesign5.cfm
2 ms 2 ms 1 /home/www/html/navleader_rdesign5.cfm
2 ms 2 ms 1 /home/www/html/navmpu_rdesign5.cfm
1 ms 1 ms 1 /home/www/html/bottommobilenav_rdesign5.cfm
1 ms 1 ms 1 /home/www/html/expat/ibstyle.cfm
1 ms 1 ms 1 /home/www/html/expat/queries/qry_DesignSet.cfm
1 ms 1 ms 1 /home/www/html/expat/queries/qry_GetModerators.cfm
1 ms 1 ms 2 /home/www/html/navinjection.cfm
0 ms 0 ms 1 /home/www/html/bottomnav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/expat/constants.cfm
0 ms 0 ms 1 /home/www/html/expat/copyright.cfm
0 ms 0 ms 1 /home/www/html/expat/datasources.cfm
0 ms 0 ms 1 /home/www/html/expat/ibkey.cfm
0 ms 0 ms 1 /home/www/html/expat/index.cfm
0 ms 0 ms 1 /home/www/html/expat/instaboard.cfm
0 ms 0 ms 1 /home/www/html/expat/navforumads_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/expat/queries/qry_GeneralSet.cfm
0 ms 0 ms 1 /home/www/html/expat/queries/qry_GetCategory.cfm
0 ms 0 ms 1 /home/www/html/leftnav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/navjoin_rdesign4.cfm
0 ms 0 ms 3 /home/www/html/rewritearticle.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
110 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

GeneralSet (Datasource=forum, Time=0ms, Records=1, Cached Query) in /home/www/html/expat/queries/qry_GeneralSet.cfm @ 08:20:54.054
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=1ms, Records=1) in /home/www/html/expat/Application.cfm @ 08:20:54.054
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getname (Datasource=expert, Time=1ms, Records=1) in /home/www/html/expat/navtop2forum_rdesign5.cfm @ 08:20:54.054
	Select *
	From Networks
	Where frmid = 301 
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmetaforums_rdesign5.cfm @ 08:20:54.054
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 08:20:54.054
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 104 
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 08:20:54.054
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, welcomefrmid, networkintro, shortnamecap
	From Networks
	Where frmid = 301 
getcities (Datasource=expert, Time=1ms, Records=7) in /home/www/html/navmetaforums_rdesign5.cfm @ 08:20:54.054
	Select *
	From citynetworks
	Where networkID = 104
	and status <> 'hold'
	ORDER by city
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmetaforums_rdesign5.cfm @ 08:20:54.054
  SELECT f.frmid, frmname, f.catid
  FROM forums f
  WHERE dbname = "ee"
and frmname <> "ee"
and frmname <> "Ecuador Welcome Forum"
and f.catid = 2
  GROUP BY f.frmid
  ORDER BY frmname
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 08:20:54.054
	Select *
	From Networks
	Where networkID = 104 
getcountryphoto (Datasource=expert, Time=0ms, Records=6) in /home/www/html/navmetaforums_rdesign5.cfm @ 08:20:54.054
	Select *
	From countryphotos
	Where hpimg <> ''
	and networkid = 104
	order by lastsent ASC
GetTopics (Datasource=forum, Time=6ms, Records=610) in /home/www/html/navmetaforums_rdesign5.cfm @ 08:20:54.054
  SELECT t.tpcid, t.frmid, t.userid, tpcupdate, t.msgcount-1 as replycount, tpcname, ispoll, t.isclosed, t.isapproved, t.urlchanged, t.tpcrewriteurl, t.section, t.citynetworkid 
  FROM topics t  
  WHERE t.frmid = 301
  AND t.isapproved = 1
  GROUP by t.tpcid
   ORDER BY tpcupdate DESC
checklog (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 08:20:54.054
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.230'
and logtime > "2020-04-07"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=1ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 08:20:54.054
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.230'
and logtime > "2020-07-07 00:00:00.000"
and logtime < "2020-07-07 23:59:59.999"
and param1 <> 'aw'
and param1 <> 'awdyn'
ORDER BY logtime DESC
checklogdynamicpre (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 08:20:54.054
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.230'
and logtime > "2020-06-30"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 08:20:54.054
	SELECT *
	From contentcountcountry
	Where networkid = 104 
gettopbanner (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 08:20:54.054
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight > 8
    and toDate > "2020-07-06"
    and fromDate < "2020-07-07"
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 08:20:54.054
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 865 
GetNavigator (Datasource=forum, Time=5ms, Records=686) in /home/www/html/expat/Application.cfm @ 08:20:54.054
  SELECT catid, allowattach, isreviewed, isprivate, f.frmid as frmid, frmname, frmdesc, frmorder, frmpass, frmnotice, isapproved, f.isclosed as frmclosed, tpcname, tpcid, t.isclosed as tpcclosed, ispoll, isreviewed
  FROM forums f, topics t  
  WHERE f.frmid = 301 
  AND f.isactive = 1
  
  and f.frmid = t.frmid
GetModerators (Datasource=forum, Time=1ms, Records=0) in /home/www/html/expat/queries/qry_GetModerators.cfm @ 08:20:54.054
  SELECT u.userid, u.username, u.userdbname 
  FROM users u, moderators mo
  WHERE u.userid = mo.userid
  AND mo.frmid = 301
  AND u.userdbname = "ee"
  ORDER BY u.username
GetCategory (Datasource=forum, Time=0ms, Records=1, Cached Query) in /home/www/html/expat/queries/qry_GetCategory.cfm @ 08:20:54.054
  SELECT *
  FROM categories
  WHERE catid = "2"
DesignSet (Datasource=forum, Time=0ms, Records=1, Cached Query) in /home/www/html/expat/queries/qry_DesignSet.cfm @ 08:20:54.054
  SELECT * FROM designset
  WHERE designsetid = 11 
GetForumleaders (Datasource=forum, Time=0ms, Records=0) in /home/www/html/expat/topics_rdesign5.cfm @ 08:20:54.054
  SELECT u.userid, u.username, u.userdbname
  FROM users u, forumleaders fl, userprofiles
  WHERE u.userid = fl.userid
  AND fl.frmid = 301
  and u.userid = userprofiles.userid
  AND u.userdbname = "ee"
  ORDER BY u.username
getcritical (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expat/topics_rdesign5.cfm @ 08:20:54.054
	Select *
	From articles, articlePlacement
	Where articlePlacement.networkID = 104 
    AND articlePlacement.articleID = articles.articleID 
    and articles.hinet = 'c'
    and articles.general = 'no'
    and articles.hitopic <> ''
    and articles.hidescript <> ''
    and publishdate <{ts '2020-07-07 08:20:54'}
    ORDER by aDate desc
GetTopics (Datasource=forum, Time=16ms, Records=543) in /home/www/html/expat/queries/mysql/qry_GetTopics.cfm @ 08:20:54.054
  SELECT t.tpcid, t.frmid, t.userid, tpcupdate, t.msgcount-1 as replycount, tpcname, ispoll, t.isclosed, t.isapproved, users.userid, users.username, users.userdbname, t.urlchanged, t.tpcrewriteurl, t.section, t.citynetworkid, m.msgdate
  FROM users, topics t, messages m
  WHERE t.frmid = 301
  AND t.isapproved = 1
  AND t.tpcid = m.tpcid
  and m.msgparent = 0
  and m.isdeleted = 0
  AND t.userid = users.userid 
  and t.pinned = 0
  GROUP by t.tpcid
  ORDER BY tpcupdate DESC 
GetPinnedTopics (Datasource=forum, Time=6ms, Records=1) in /home/www/html/expat/queries/mysql/qry_GetPinnedTopics.cfm @ 08:20:54.054
  SELECT t.tpcid, t.frmid, t.userid, tpcupdate, t.msgcount-1 as replycount, tpcname, ispoll, t.isclosed, t.isapproved, users.userid, users.username, users.userdbname, t.urlchanged, t.tpcrewriteurl, t.section, t.citynetworkid, m.msgdate, t.pinned, t.pinneduntil
  FROM users, topics t, messages m
  WHERE t.frmid = 301
  AND "ee" = "ee"
  AND t.isapproved = 1
  AND t.tpcid = m.tpcid
  and m.msgparent = 0
  and m.isdeleted <> 1
  and t.pinned = 1
  and (pinneduntil > "2020-07-07" or pinneduntil = '')
  AND t.userid = users.userid 
  GROUP by t.tpcid
  ORDER BY tpcupdate DESC 
gethpbox (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 08:20:54.054
	Select *
	From banners
	WHERE status <> "hold"
	AND (position = "eehpbox" or position = "eehpboxglobal")
    and toDate > {ts '2020-07-06 08:20:54'}
    and fromDate <{ts '2020-07-07 08:20:54'}
    and banners.type <> 'swf'
    
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 08:20:54.054
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 866 
getclasscheck (Datasource=tipripper, Time=25ms, Records=0) in /home/www/html/navrightmidcolumn_rdesign5.cfm @ 08:20:54.054
	SELECT answersphoto.photo, answersphoto.answerid, answersphoto.qid, answers.rid, allreports.networkname, allreports.networkid, allreports.city, allreports.state
	FROM answersphoto, answers, allreports 
	WHERE answersphoto.answerid = answers.answerid
	and allreports.answerid = answers.answerid
	and allreports.topicid = 6
	and allreports.hide <> 'y'
	and (answers.paid = 'yes' or answers.paid = 'free')
	AND answersphoto.qid = '104'
	AND allreports.networkid = 104
	AND "2020-07-07" < allreports.enddate
	AND answersphoto.photo <> 'none'
	ORDER BY answerid DESC
checkrptarticles (Datasource=reports, Time=5ms, Records=0) in /home/www/html/navcontentbox.cfm @ 08:20:54.054
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-07-07"
     
         and rptarticlenetworks.networkid = 104 
    ORDER by rptarticles.rptarticleID asc   
    
gettaxgeneral2 (Datasource=expert, Time=5ms, Records=3) in /home/www/html/navcontentbox.cfm @ 08:20:54.054
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 104 
	AND articlePlacement.articleID = articles.articleID
	and hidescript <> ''
    and type = '3'
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
    and hpimg <> 'none'
    and summary <> ''
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-07-07"

    ORDER by articles.articleID asc   
    
checkretirefeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/navcontentbox.cfm @ 08:20:54.054
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 104 
         and city <> ''
         and date > '2013-04-01'
         order by date DESC
checkmovingfeature (Datasource=expert, Time=6ms, Records=0) in /home/www/html/navcontentbox.cfm @ 08:20:54.054
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 104 
          and date > '2013-04-01'
		order by date DESC


Scope Variables

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=/home/www/html/expat/index.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=on
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING=gzip
HTTP_ACCEPT_LANGUAGE=en-US,en;q=0.5
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=
HTTP_HOST=www.expatexchange.com
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/2.0 (https://commoncrawl.org/faq/)
PATH_INFO=
PATH_TRANSLATED=/home/www/html/expat/index.cfm
QUERY_STRING=frmid=301&s=526
REMOTE_ADDR=162.158.78.230
REMOTE_HOST=162.158.78.230
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/expat/index.cfm
SERVER_NAME=www.expatexchange.com
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Apache
WEB_SERVER_API=
Cookie Variables:
MS=flat
Session Variables:
cfid=31209814
cftoken=47400252
sessionid=IBEXPATEXCHANGE.COM_31209814_47400252
urltoken=CFID=31209814&CFTOKEN=47400252
URL Parameters:
frmid=301
s=526
Debug Rendering Time: 11 ms