Debugging Information
| ColdFusion Server Standard |
7,0,2,142559 |
| Template |
/index.cfm |
| Time Stamp |
02-Dec-08 06:38 AM |
| Locale |
English (UK) |
| User Agent |
ColdFusion |
| Remote IP |
84.23.9.163 |
| Host Name |
84.23.9.163 |
Execution Time
| Total Time |
Avg Time |
Count |
Template |
| 1562 ms |
1562 ms |
1 |
D:\waterwaysireland\1.waterways.biznetservers.com\www_root\index.cfm |
| 1515 ms |
1515 ms |
1 |
D:\waterwaysireland\1.waterways.biznetservers.com\www_root\options\inc_faq.cfm |
| 79 ms |
10 ms |
8 |
CFC[ D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc | lang_switch(dsn = WaterWays, def_lang_key = 1, lang_key = 1, item_key = 3, method = ffaq_cat_lang) ] from D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc |
| 63 ms |
11 ms |
6 |
CFC[ D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc | lang_switch(dsn = WaterWays, def_lang_key = 1, lang_key = 1, item_key = 4, method = ffaq_cat_lang) ] from D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc |
| 47 ms |
47 ms |
1 |
D:\waterwaysireland\1.waterways.biznetservers.com\www_root\inc_page_head.cfm |
| 32 ms |
8 ms |
4 |
CFC[ D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc | lang_switch(dsn = WaterWays, def_lang_key = 1, lang_key = 1, item_key = 13, method = ffaq_cat_lang) ] from D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc |
| 32 ms |
16 ms |
2 |
CFC[ D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc | lang_switch(dsn = WaterWays, def_lang_key = 1, lang_key = 1, item_key = 74, method = ffaq_lang) ] from D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc |
| 32 ms |
32 ms |
1 |
D:\waterwaysireland\1.waterways.biznetservers.com\www_root\Application.cfm |
| 31 ms |
2 ms |
13 |
CFC[ D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc | lang_switch(dsn = WaterWays, def_lang_key = 1, lang_key = 1, item_key = 8, method = ffaq_cat_lang) ] from D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc |
| 31 ms |
31 ms |
1 |
D:\waterwaysireland\1.waterways.biznetservers.com\www_root\common\inc_queries.cfm |
| 30 ms |
4 ms |
7 |
CFC[ D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc | lang_switch(dsn = WaterWays, def_lang_key = 1, lang_key = 1, item_key = 2, method = ffaq_cat_lang) ] from D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc |
| 16 ms |
16 ms |
1 |
CFC[ D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc | fGetcats(deployment = 1, language = 1, faq = 148) ] from D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc |
| 16 ms |
16 ms |
1 |
CFC[ D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc | fGetcats(deployment = 1, language = 1, faq = 89) ] from D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc |
| 16 ms |
8 ms |
2 |
CFC[ D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc | lang_switch(dsn = WaterWays, def_lang_key = 1, lang_key = 1, item_key = 11, method = ffaq_cat_lang) ] from D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc |
| 16 ms |
4 ms |
4 |
CFC[ D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc | lang_switch(dsn = WaterWays, def_lang_key = 1, lang_key = 1, item_key = 7, method = ffaq_cat_lang) ] from D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc |
| 16 ms |
8 ms |
2 |
CFC[ D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc | lang_switch(dsn = WaterWays, def_lang_key = 1, lang_key = 1, item_key = 88, method = ffaq_lang) ] from D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc |
| 16 ms |
16 ms |
1 |
D:\waterwaysireland\1.waterways.biznetservers.com\www_root\common\inc_banner.cfm |
| 15 ms |
15 ms |
1 |
CFC[ D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc | fGetcats(deployment = 1, language = 1, faq = 74) ] from D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc |
| 15 ms |
15 ms |
1 |
CFC[ D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc | lang_switch(dsn = WaterWays, def_lang_key = 1, lang_key = 1, item_key = 12, method = ffaq_cat_lang) ] from D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc |
| 15 ms |
8 ms |
2 |
CFC[ D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc | lang_switch(dsn = WaterWays, def_lang_key = 1, lang_key = 1, item_key = 148, method = ffaq_lang) ] from D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc |
| 15 ms |
3 ms |
5 |
CFC[ D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc | lang_switch(dsn = WaterWays, def_lang_key = 1, lang_key = 1, item_key = 21, method = ffaq_cat_lang) ] from D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc |
| 15 ms |
5 ms |
3 |
CFC[ D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc | lang_switch(dsn = WaterWays, def_lang_key = 1, lang_key = 1, item_key = 24, method = ffaq_cat_lang) ] from D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc |
| 15 ms |
8 ms |
2 |
CFC[ D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc | lang_switch(dsn = WaterWays, def_lang_key = 1, lang_key = 1, item_key = 75, method = ffaq_lang) ] from D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc |
| 15 ms |
8 ms |
2 |
CFC[ D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc | lang_switch(dsn = WaterWays, def_lang_key = 1, lang_key = 1, item_key = 89, method = ffaq_lang) ] from D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc |
| 0 ms |
0 ms |
1 |
CFC[ D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc | fGetcats(deployment = 1, language = 1, faq = 105) ] from D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc |
| 0 ms |
0 ms |
1 |
CFC[ D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc | fGetcats(deployment = 1, language = 1, faq = 154) ] from D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc |
| 0 ms |
0 ms |
1 |
CFC[ D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc | fGetcats(deployment = 1, language = 1, faq = 157) ] from D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc |
| 0 ms |
0 ms |
1 |
CFC[ D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc | fGetcats(deployment = 1, language = 1, faq = 289) ] from D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc |
| 0 ms |
0 ms |
1 |
CFC[ D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc | fGetcats(deployment = 1, language = 1, faq = 298) ] from D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc |
| 0 ms |
0 ms |
1 |
CFC[ D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc | fGetcats(deployment = 1, language = 1, faq = 65) ] from D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc |
| 0 ms |
0 ms |
1 |
CFC[ D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc | fGetcats(deployment = 1, language = 1, faq = 75) ] from D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc |
| 0 ms |
0 ms |
1 |
CFC[ D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc | fGetcats(deployment = 1, language = 1, faq = 88) ] from D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc |
| 0 ms |
0 ms |
1 |
CFC[ D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc | fGetcats(deployment = 1, language = 1, faq = 90) ] from D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc |
| 0 ms |
0 ms |
1 |
CFC[ D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc | fGetcats(language = 1, deployment = 1) ] from D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc |
| 0 ms |
0 ms |
1 |
CFC[ D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc | fgetquestions(deployment = 1, language = 1, category = 8) ] from D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc |
| 0 ms |
0 ms |
2 |
CFC[ D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc | lang_switch(dsn = WaterWays, def_lang_key = 1, lang_key = 1, item_key = 10, method = ffaq_cat_lang) ] from D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc |
| 0 ms |
0 ms |
2 |
CFC[ D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc | lang_switch(dsn = WaterWays, def_lang_key = 1, lang_key = 1, item_key = 105, method = ffaq_lang) ] from D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc |
| 0 ms |
0 ms |
1 |
CFC[ D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc | lang_switch(dsn = WaterWays, def_lang_key = 1, lang_key = 1, item_key = 14, method = ffaq_cat_lang) ] from D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc |
| 0 ms |
0 ms |
1 |
CFC[ D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc | lang_switch(dsn = WaterWays, def_lang_key = 1, lang_key = 1, item_key = 15, method = ffaq_cat_lang) ] from D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc |
| 0 ms |
0 ms |
2 |
CFC[ D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc | lang_switch(dsn = WaterWays, def_lang_key = 1, lang_key = 1, item_key = 154, method = ffaq_lang) ] from D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc |
| 0 ms |
0 ms |
2 |
CFC[ D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc | lang_switch(dsn = WaterWays, def_lang_key = 1, lang_key = 1, item_key = 157, method = ffaq_lang) ] from D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc |
| 0 ms |
0 ms |
1 |
CFC[ D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc | lang_switch(dsn = WaterWays, def_lang_key = 1, lang_key = 1, item_key = 16, method = ffaq_cat_lang) ] from D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc |
| 0 ms |
0 ms |
1 |
CFC[ D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc | lang_switch(dsn = WaterWays, def_lang_key = 1, lang_key = 1, item_key = 18, method = ffaq_cat_lang) ] from D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc |
| 0 ms |
0 ms |
2 |
CFC[ D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc | lang_switch(dsn = WaterWays, def_lang_key = 1, lang_key = 1, item_key = 20, method = ffaq_cat_lang) ] from D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc |
| 0 ms |
0 ms |
2 |
CFC[ D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc | lang_switch(dsn = WaterWays, def_lang_key = 1, lang_key = 1, item_key = 22, method = ffaq_cat_lang) ] from D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc |
| 0 ms |
0 ms |
1 |
CFC[ D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc | lang_switch(dsn = WaterWays, def_lang_key = 1, lang_key = 1, item_key = 23, method = ffaq_cat_lang) ] from D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc |
| 0 ms |
0 ms |
1 |
CFC[ D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc | lang_switch(dsn = WaterWays, def_lang_key = 1, lang_key = 1, item_key = 25, method = ffaq_cat_lang) ] from D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc |
| 0 ms |
0 ms |
2 |
CFC[ D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc | lang_switch(dsn = WaterWays, def_lang_key = 1, lang_key = 1, item_key = 289, method = ffaq_lang) ] from D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc |
| 0 ms |
0 ms |
2 |
CFC[ D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc | lang_switch(dsn = WaterWays, def_lang_key = 1, lang_key = 1, item_key = 298, method = ffaq_lang) ] from D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc |
| 0 ms |
0 ms |
4 |
CFC[ D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc | lang_switch(dsn = WaterWays, def_lang_key = 1, lang_key = 1, item_key = 5, method = ffaq_cat_lang) ] from D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc |
| 0 ms |
0 ms |
2 |
CFC[ D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc | lang_switch(dsn = WaterWays, def_lang_key = 1, lang_key = 1, item_key = 6, method = ffaq_cat_lang) ] from D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc |
| 0 ms |
0 ms |
2 |
CFC[ D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc | lang_switch(dsn = WaterWays, def_lang_key = 1, lang_key = 1, item_key = 65, method = ffaq_lang) ] from D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc |
| 0 ms |
0 ms |
2 |
CFC[ D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc | lang_switch(dsn = WaterWays, def_lang_key = 1, lang_key = 1, item_key = 9, method = ffaq_cat_lang) ] from D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc |
| 0 ms |
0 ms |
2 |
CFC[ D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc | lang_switch(dsn = WaterWays, def_lang_key = 1, lang_key = 1, item_key = 90, method = ffaq_lang) ] from D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc |
| 0 ms |
0 ms |
1 |
D:\waterwaysireland\1.waterways.biznetservers.com\www_root\OnRequestEnd.cfm |
| 0 ms |
0 ms |
12 |
D:\waterwaysireland\1.waterways.biznetservers.com\www_root\options\paragraph.cfm |
| 0 ms |
0 ms |
1 |
D:\waterwaysireland\1.waterways.biznetservers.com\www_root\sesConverter.cfm |
| 0 ms | |
STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN |
| 1594 ms | |
TOTAL EXECUTION TIME |
red = over 250 ms average execution time
SQL Queries
qGetLangsDef (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\Application.cfm @ 06:38:19.019
SELECT language_key, language_default, language_abbr
FROM language
WHERE language_default = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_BIT) = YES
qGetLangs (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\inc_page_head.cfm @ 06:38:19.019
SELECT language_key, language_abbr
FROM language
WHERE language_key = ?;
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1
qGetLangs (Datasource=WaterWays, Time=0ms, Records=8) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\common\inc_queries.cfm @ 06:38:19.019
SELECT DISTINCT L.language_key, L.language_name, L.language_abbr
FROM language L
qGetcats (Datasource=WaterWays, Time=0ms, Records=22) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:19.019
SELECT FC.faq_category_key
FROM FAQ_CATEGORY FC
INNER JOIN FAQVSFAQ_CATEGORY FFC ON FC.faq_category_key = FFC.faq_category_key
INNER JOIN FAQ F ON FFC.faq_key = F.faq_key
INNER JOIN FAQVSDEPLOYMENT FD ON F.faq_key = FD.faq_key
INNER JOIN MAIN_FAQ MF ON F.faq_key = MF.faq_key
WHERE FD.deployment_key = ?
GROUP BY FC.faq_category_key
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1
qGetquestions (Datasource=WaterWays, Time=0ms, Records=12) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:19.019
SELECT F.faq_key
FROM FAQ F
INNER JOIN FAQVSFAQ_CATEGORY FFC ON F.faq_key = FFC.faq_key
INNER JOIN FAQVSDEPLOYMENT FD ON F.faq_key = FD.faq_key
WHERE F.faq_ans = ?
AND FD.deployment_key = ?
AND FFC.faq_category_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_BIT) = YES
Parameter #2(CF_SQL_INTEGER) = 1
Parameter #3(CF_SQL_INTEGER) = 8
qGetbanners (Datasource=WaterWays, Time=16ms, Records=9) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\common\inc_banner.cfm @ 06:38:19.019
SELECT banner_image
FROM banner
WHERE banner_show = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_BIT) = YES
qgetcat_faq (Datasource=WaterWays, Time=15ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:19.019
SELECT MC.faq_category_name, FC.faq_category_key
FROM FAQ_CATEGORY FC
INNER JOIN MAIN_FAQCATEGORY MC ON FC.faq_category_key = MC.faq_category_key
WHERE FC.faq_category_key = ?
AND MC.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2
Parameter #2(CF_SQL_INTEGER) = 1
qgetcat_faq (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:19.019
SELECT MC.faq_category_name, FC.faq_category_key
FROM FAQ_CATEGORY FC
INNER JOIN MAIN_FAQCATEGORY MC ON FC.faq_category_key = MC.faq_category_key
WHERE FC.faq_category_key = ?
AND MC.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3
Parameter #2(CF_SQL_INTEGER) = 1
qgetcat_faq (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:19.019
SELECT MC.faq_category_name, FC.faq_category_key
FROM FAQ_CATEGORY FC
INNER JOIN MAIN_FAQCATEGORY MC ON FC.faq_category_key = MC.faq_category_key
WHERE FC.faq_category_key = ?
AND MC.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 4
Parameter #2(CF_SQL_INTEGER) = 1
qgetcat_faq (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:19.019
SELECT MC.faq_category_name, FC.faq_category_key
FROM FAQ_CATEGORY FC
INNER JOIN MAIN_FAQCATEGORY MC ON FC.faq_category_key = MC.faq_category_key
WHERE FC.faq_category_key = ?
AND MC.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 5
Parameter #2(CF_SQL_INTEGER) = 1
qgetcat_faq (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:19.019
SELECT MC.faq_category_name, FC.faq_category_key
FROM FAQ_CATEGORY FC
INNER JOIN MAIN_FAQCATEGORY MC ON FC.faq_category_key = MC.faq_category_key
WHERE FC.faq_category_key = ?
AND MC.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 6
Parameter #2(CF_SQL_INTEGER) = 1
qgetcat_faq (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:19.019
SELECT MC.faq_category_name, FC.faq_category_key
FROM FAQ_CATEGORY FC
INNER JOIN MAIN_FAQCATEGORY MC ON FC.faq_category_key = MC.faq_category_key
WHERE FC.faq_category_key = ?
AND MC.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 7
Parameter #2(CF_SQL_INTEGER) = 1
qgetcat_faq (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:19.019
SELECT MC.faq_category_name, FC.faq_category_key
FROM FAQ_CATEGORY FC
INNER JOIN MAIN_FAQCATEGORY MC ON FC.faq_category_key = MC.faq_category_key
WHERE FC.faq_category_key = ?
AND MC.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 8
Parameter #2(CF_SQL_INTEGER) = 1
qgetcat_faq (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:19.019
SELECT MC.faq_category_name, FC.faq_category_key
FROM FAQ_CATEGORY FC
INNER JOIN MAIN_FAQCATEGORY MC ON FC.faq_category_key = MC.faq_category_key
WHERE FC.faq_category_key = ?
AND MC.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 9
Parameter #2(CF_SQL_INTEGER) = 1
qgetcat_faq (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:19.019
SELECT MC.faq_category_name, FC.faq_category_key
FROM FAQ_CATEGORY FC
INNER JOIN MAIN_FAQCATEGORY MC ON FC.faq_category_key = MC.faq_category_key
WHERE FC.faq_category_key = ?
AND MC.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 10
Parameter #2(CF_SQL_INTEGER) = 1
qgetcat_faq (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:19.019
SELECT MC.faq_category_name, FC.faq_category_key
FROM FAQ_CATEGORY FC
INNER JOIN MAIN_FAQCATEGORY MC ON FC.faq_category_key = MC.faq_category_key
WHERE FC.faq_category_key = ?
AND MC.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 11
Parameter #2(CF_SQL_INTEGER) = 1
qgetcat_faq (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:19.019
SELECT MC.faq_category_name, FC.faq_category_key
FROM FAQ_CATEGORY FC
INNER JOIN MAIN_FAQCATEGORY MC ON FC.faq_category_key = MC.faq_category_key
WHERE FC.faq_category_key = ?
AND MC.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 12
Parameter #2(CF_SQL_INTEGER) = 1
qgetcat_faq (Datasource=WaterWays, Time=16ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:19.019
SELECT MC.faq_category_name, FC.faq_category_key
FROM FAQ_CATEGORY FC
INNER JOIN MAIN_FAQCATEGORY MC ON FC.faq_category_key = MC.faq_category_key
WHERE FC.faq_category_key = ?
AND MC.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 13
Parameter #2(CF_SQL_INTEGER) = 1
qgetcat_faq (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:19.019
SELECT MC.faq_category_name, FC.faq_category_key
FROM FAQ_CATEGORY FC
INNER JOIN MAIN_FAQCATEGORY MC ON FC.faq_category_key = MC.faq_category_key
WHERE FC.faq_category_key = ?
AND MC.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 14
Parameter #2(CF_SQL_INTEGER) = 1
qgetcat_faq (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:19.019
SELECT MC.faq_category_name, FC.faq_category_key
FROM FAQ_CATEGORY FC
INNER JOIN MAIN_FAQCATEGORY MC ON FC.faq_category_key = MC.faq_category_key
WHERE FC.faq_category_key = ?
AND MC.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 15
Parameter #2(CF_SQL_INTEGER) = 1
qgetcat_faq (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:19.019
SELECT MC.faq_category_name, FC.faq_category_key
FROM FAQ_CATEGORY FC
INNER JOIN MAIN_FAQCATEGORY MC ON FC.faq_category_key = MC.faq_category_key
WHERE FC.faq_category_key = ?
AND MC.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 16
Parameter #2(CF_SQL_INTEGER) = 1
qgetcat_faq (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:19.019
SELECT MC.faq_category_name, FC.faq_category_key
FROM FAQ_CATEGORY FC
INNER JOIN MAIN_FAQCATEGORY MC ON FC.faq_category_key = MC.faq_category_key
WHERE FC.faq_category_key = ?
AND MC.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 18
Parameter #2(CF_SQL_INTEGER) = 1
qgetcat_faq (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:19.019
SELECT MC.faq_category_name, FC.faq_category_key
FROM FAQ_CATEGORY FC
INNER JOIN MAIN_FAQCATEGORY MC ON FC.faq_category_key = MC.faq_category_key
WHERE FC.faq_category_key = ?
AND MC.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 20
Parameter #2(CF_SQL_INTEGER) = 1
qgetcat_faq (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:19.019
SELECT MC.faq_category_name, FC.faq_category_key
FROM FAQ_CATEGORY FC
INNER JOIN MAIN_FAQCATEGORY MC ON FC.faq_category_key = MC.faq_category_key
WHERE FC.faq_category_key = ?
AND MC.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 21
Parameter #2(CF_SQL_INTEGER) = 1
qgetcat_faq (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:19.019
SELECT MC.faq_category_name, FC.faq_category_key
FROM FAQ_CATEGORY FC
INNER JOIN MAIN_FAQCATEGORY MC ON FC.faq_category_key = MC.faq_category_key
WHERE FC.faq_category_key = ?
AND MC.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 22
Parameter #2(CF_SQL_INTEGER) = 1
qgetcat_faq (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:19.019
SELECT MC.faq_category_name, FC.faq_category_key
FROM FAQ_CATEGORY FC
INNER JOIN MAIN_FAQCATEGORY MC ON FC.faq_category_key = MC.faq_category_key
WHERE FC.faq_category_key = ?
AND MC.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 23
Parameter #2(CF_SQL_INTEGER) = 1
qgetcat_faq (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:19.019
SELECT MC.faq_category_name, FC.faq_category_key
FROM FAQ_CATEGORY FC
INNER JOIN MAIN_FAQCATEGORY MC ON FC.faq_category_key = MC.faq_category_key
WHERE FC.faq_category_key = ?
AND MC.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 24
Parameter #2(CF_SQL_INTEGER) = 1
qgetcat_faq (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:19.019
SELECT MC.faq_category_name, FC.faq_category_key
FROM FAQ_CATEGORY FC
INNER JOIN MAIN_FAQCATEGORY MC ON FC.faq_category_key = MC.faq_category_key
WHERE FC.faq_category_key = ?
AND MC.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 25
Parameter #2(CF_SQL_INTEGER) = 1
qget_faq (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:19.019
SELECT MF.faq_question, MF.faq_answer, MF.faq_title, F.faq_key, F.faq_ans, F.faq_name, F.faq_email, F.faq_ans_date, F.faq_ask_date, F.faq_date, F.faq_email_sender, F.faq_name_sender, F.faq_lang_sender
FROM MAIN_FAQ MF
INNER JOIN FAQ F ON MF.faq_key = F.faq_key
WHERE F.faq_key = ?
AND MF.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 148
Parameter #2(CF_SQL_INTEGER) = 1
qget_faq (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:19.019
SELECT MF.faq_question, MF.faq_answer, MF.faq_title, F.faq_key, F.faq_ans, F.faq_name, F.faq_email, F.faq_ans_date, F.faq_ask_date, F.faq_date, F.faq_email_sender, F.faq_name_sender, F.faq_lang_sender
FROM MAIN_FAQ MF
INNER JOIN FAQ F ON MF.faq_key = F.faq_key
WHERE F.faq_key = ?
AND MF.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 154
Parameter #2(CF_SQL_INTEGER) = 1
qget_faq (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:19.019
SELECT MF.faq_question, MF.faq_answer, MF.faq_title, F.faq_key, F.faq_ans, F.faq_name, F.faq_email, F.faq_ans_date, F.faq_ask_date, F.faq_date, F.faq_email_sender, F.faq_name_sender, F.faq_lang_sender
FROM MAIN_FAQ MF
INNER JOIN FAQ F ON MF.faq_key = F.faq_key
WHERE F.faq_key = ?
AND MF.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 157
Parameter #2(CF_SQL_INTEGER) = 1
qget_faq (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:19.019
SELECT MF.faq_question, MF.faq_answer, MF.faq_title, F.faq_key, F.faq_ans, F.faq_name, F.faq_email, F.faq_ans_date, F.faq_ask_date, F.faq_date, F.faq_email_sender, F.faq_name_sender, F.faq_lang_sender
FROM MAIN_FAQ MF
INNER JOIN FAQ F ON MF.faq_key = F.faq_key
WHERE F.faq_key = ?
AND MF.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 65
Parameter #2(CF_SQL_INTEGER) = 1
qget_faq (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:19.019
SELECT MF.faq_question, MF.faq_answer, MF.faq_title, F.faq_key, F.faq_ans, F.faq_name, F.faq_email, F.faq_ans_date, F.faq_ask_date, F.faq_date, F.faq_email_sender, F.faq_name_sender, F.faq_lang_sender
FROM MAIN_FAQ MF
INNER JOIN FAQ F ON MF.faq_key = F.faq_key
WHERE F.faq_key = ?
AND MF.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 289
Parameter #2(CF_SQL_INTEGER) = 1
qget_faq (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:19.019
SELECT MF.faq_question, MF.faq_answer, MF.faq_title, F.faq_key, F.faq_ans, F.faq_name, F.faq_email, F.faq_ans_date, F.faq_ask_date, F.faq_date, F.faq_email_sender, F.faq_name_sender, F.faq_lang_sender
FROM MAIN_FAQ MF
INNER JOIN FAQ F ON MF.faq_key = F.faq_key
WHERE F.faq_key = ?
AND MF.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 298
Parameter #2(CF_SQL_INTEGER) = 1
qget_faq (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:19.019
SELECT MF.faq_question, MF.faq_answer, MF.faq_title, F.faq_key, F.faq_ans, F.faq_name, F.faq_email, F.faq_ans_date, F.faq_ask_date, F.faq_date, F.faq_email_sender, F.faq_name_sender, F.faq_lang_sender
FROM MAIN_FAQ MF
INNER JOIN FAQ F ON MF.faq_key = F.faq_key
WHERE F.faq_key = ?
AND MF.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 105
Parameter #2(CF_SQL_INTEGER) = 1
qget_faq (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:19.019
SELECT MF.faq_question, MF.faq_answer, MF.faq_title, F.faq_key, F.faq_ans, F.faq_name, F.faq_email, F.faq_ans_date, F.faq_ask_date, F.faq_date, F.faq_email_sender, F.faq_name_sender, F.faq_lang_sender
FROM MAIN_FAQ MF
INNER JOIN FAQ F ON MF.faq_key = F.faq_key
WHERE F.faq_key = ?
AND MF.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 90
Parameter #2(CF_SQL_INTEGER) = 1
qget_faq (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:19.019
SELECT MF.faq_question, MF.faq_answer, MF.faq_title, F.faq_key, F.faq_ans, F.faq_name, F.faq_email, F.faq_ans_date, F.faq_ask_date, F.faq_date, F.faq_email_sender, F.faq_name_sender, F.faq_lang_sender
FROM MAIN_FAQ MF
INNER JOIN FAQ F ON MF.faq_key = F.faq_key
WHERE F.faq_key = ?
AND MF.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 89
Parameter #2(CF_SQL_INTEGER) = 1
qget_faq (Datasource=WaterWays, Time=16ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:19.019
SELECT MF.faq_question, MF.faq_answer, MF.faq_title, F.faq_key, F.faq_ans, F.faq_name, F.faq_email, F.faq_ans_date, F.faq_ask_date, F.faq_date, F.faq_email_sender, F.faq_name_sender, F.faq_lang_sender
FROM MAIN_FAQ MF
INNER JOIN FAQ F ON MF.faq_key = F.faq_key
WHERE F.faq_key = ?
AND MF.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 88
Parameter #2(CF_SQL_INTEGER) = 1
qget_faq (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:19.019
SELECT MF.faq_question, MF.faq_answer, MF.faq_title, F.faq_key, F.faq_ans, F.faq_name, F.faq_email, F.faq_ans_date, F.faq_ask_date, F.faq_date, F.faq_email_sender, F.faq_name_sender, F.faq_lang_sender
FROM MAIN_FAQ MF
INNER JOIN FAQ F ON MF.faq_key = F.faq_key
WHERE F.faq_key = ?
AND MF.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 75
Parameter #2(CF_SQL_INTEGER) = 1
qget_faq (Datasource=WaterWays, Time=32ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:19.019
SELECT MF.faq_question, MF.faq_answer, MF.faq_title, F.faq_key, F.faq_ans, F.faq_name, F.faq_email, F.faq_ans_date, F.faq_ask_date, F.faq_date, F.faq_email_sender, F.faq_name_sender, F.faq_lang_sender
FROM MAIN_FAQ MF
INNER JOIN FAQ F ON MF.faq_key = F.faq_key
WHERE F.faq_key = ?
AND MF.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 74
Parameter #2(CF_SQL_INTEGER) = 1
qget_faq (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:19.019
SELECT MF.faq_question, MF.faq_answer, MF.faq_title, F.faq_key, F.faq_ans, F.faq_name, F.faq_email, F.faq_ans_date, F.faq_ask_date, F.faq_date, F.faq_email_sender, F.faq_name_sender, F.faq_lang_sender
FROM MAIN_FAQ MF
INNER JOIN FAQ F ON MF.faq_key = F.faq_key
WHERE F.faq_key = ?
AND MF.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 148
Parameter #2(CF_SQL_INTEGER) = 1
qGetcats (Datasource=WaterWays, Time=0ms, Records=2) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:19.019
SELECT FC.faq_category_key
FROM FAQ_CATEGORY FC
INNER JOIN FAQVSFAQ_CATEGORY FFC ON FC.faq_category_key = FFC.faq_category_key
INNER JOIN FAQ F ON FFC.faq_key = F.faq_key
INNER JOIN FAQVSDEPLOYMENT FD ON F.faq_key = FD.faq_key
INNER JOIN MAIN_FAQ MF ON F.faq_key = MF.faq_key
WHERE FD.deployment_key = ?
AND F.faq_key = ?
GROUP BY FC.faq_category_key
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1
Parameter #2(CF_SQL_INTEGER) = 148
qgetcat_faq (Datasource=WaterWays, Time=16ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:19.019
SELECT MC.faq_category_name, FC.faq_category_key
FROM FAQ_CATEGORY FC
INNER JOIN MAIN_FAQCATEGORY MC ON FC.faq_category_key = MC.faq_category_key
WHERE FC.faq_category_key = ?
AND MC.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3
Parameter #2(CF_SQL_INTEGER) = 1
qgetcat_faq (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:19.019
SELECT MC.faq_category_name, FC.faq_category_key
FROM FAQ_CATEGORY FC
INNER JOIN MAIN_FAQCATEGORY MC ON FC.faq_category_key = MC.faq_category_key
WHERE FC.faq_category_key = ?
AND MC.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 8
Parameter #2(CF_SQL_INTEGER) = 1
qget_faq (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:19.019
SELECT MF.faq_question, MF.faq_answer, MF.faq_title, F.faq_key, F.faq_ans, F.faq_name, F.faq_email, F.faq_ans_date, F.faq_ask_date, F.faq_date, F.faq_email_sender, F.faq_name_sender, F.faq_lang_sender
FROM MAIN_FAQ MF
INNER JOIN FAQ F ON MF.faq_key = F.faq_key
WHERE F.faq_key = ?
AND MF.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 154
Parameter #2(CF_SQL_INTEGER) = 1
qGetcats (Datasource=WaterWays, Time=0ms, Records=3) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:19.019
SELECT FC.faq_category_key
FROM FAQ_CATEGORY FC
INNER JOIN FAQVSFAQ_CATEGORY FFC ON FC.faq_category_key = FFC.faq_category_key
INNER JOIN FAQ F ON FFC.faq_key = F.faq_key
INNER JOIN FAQVSDEPLOYMENT FD ON F.faq_key = FD.faq_key
INNER JOIN MAIN_FAQ MF ON F.faq_key = MF.faq_key
WHERE FD.deployment_key = ?
AND F.faq_key = ?
GROUP BY FC.faq_category_key
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1
Parameter #2(CF_SQL_INTEGER) = 154
qgetcat_faq (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:19.019
SELECT MC.faq_category_name, FC.faq_category_key
FROM FAQ_CATEGORY FC
INNER JOIN MAIN_FAQCATEGORY MC ON FC.faq_category_key = MC.faq_category_key
WHERE FC.faq_category_key = ?
AND MC.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2
Parameter #2(CF_SQL_INTEGER) = 1
qgetcat_faq (Datasource=WaterWays, Time=16ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:19.019
SELECT MC.faq_category_name, FC.faq_category_key
FROM FAQ_CATEGORY FC
INNER JOIN MAIN_FAQCATEGORY MC ON FC.faq_category_key = MC.faq_category_key
WHERE FC.faq_category_key = ?
AND MC.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3
Parameter #2(CF_SQL_INTEGER) = 1
qgetcat_faq (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:19.019
SELECT MC.faq_category_name, FC.faq_category_key
FROM FAQ_CATEGORY FC
INNER JOIN MAIN_FAQCATEGORY MC ON FC.faq_category_key = MC.faq_category_key
WHERE FC.faq_category_key = ?
AND MC.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 8
Parameter #2(CF_SQL_INTEGER) = 1
qget_faq (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:19.019
SELECT MF.faq_question, MF.faq_answer, MF.faq_title, F.faq_key, F.faq_ans, F.faq_name, F.faq_email, F.faq_ans_date, F.faq_ask_date, F.faq_date, F.faq_email_sender, F.faq_name_sender, F.faq_lang_sender
FROM MAIN_FAQ MF
INNER JOIN FAQ F ON MF.faq_key = F.faq_key
WHERE F.faq_key = ?
AND MF.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 157
Parameter #2(CF_SQL_INTEGER) = 1
qGetcats (Datasource=WaterWays, Time=0ms, Records=5) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:19.019
SELECT FC.faq_category_key
FROM FAQ_CATEGORY FC
INNER JOIN FAQVSFAQ_CATEGORY FFC ON FC.faq_category_key = FFC.faq_category_key
INNER JOIN FAQ F ON FFC.faq_key = F.faq_key
INNER JOIN FAQVSDEPLOYMENT FD ON F.faq_key = FD.faq_key
INNER JOIN MAIN_FAQ MF ON F.faq_key = MF.faq_key
WHERE FD.deployment_key = ?
AND F.faq_key = ?
GROUP BY FC.faq_category_key
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1
Parameter #2(CF_SQL_INTEGER) = 157
qgetcat_faq (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:19.019
SELECT MC.faq_category_name, FC.faq_category_key
FROM FAQ_CATEGORY FC
INNER JOIN MAIN_FAQCATEGORY MC ON FC.faq_category_key = MC.faq_category_key
WHERE FC.faq_category_key = ?
AND MC.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3
Parameter #2(CF_SQL_INTEGER) = 1
qgetcat_faq (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:19.019
SELECT MC.faq_category_name, FC.faq_category_key
FROM FAQ_CATEGORY FC
INNER JOIN MAIN_FAQCATEGORY MC ON FC.faq_category_key = MC.faq_category_key
WHERE FC.faq_category_key = ?
AND MC.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 4
Parameter #2(CF_SQL_INTEGER) = 1
qgetcat_faq (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:19.019
SELECT MC.faq_category_name, FC.faq_category_key
FROM FAQ_CATEGORY FC
INNER JOIN MAIN_FAQCATEGORY MC ON FC.faq_category_key = MC.faq_category_key
WHERE FC.faq_category_key = ?
AND MC.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 5
Parameter #2(CF_SQL_INTEGER) = 1
qgetcat_faq (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:19.019
SELECT MC.faq_category_name, FC.faq_category_key
FROM FAQ_CATEGORY FC
INNER JOIN MAIN_FAQCATEGORY MC ON FC.faq_category_key = MC.faq_category_key
WHERE FC.faq_category_key = ?
AND MC.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 8
Parameter #2(CF_SQL_INTEGER) = 1
qgetcat_faq (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:19.019
SELECT MC.faq_category_name, FC.faq_category_key
FROM FAQ_CATEGORY FC
INNER JOIN MAIN_FAQCATEGORY MC ON FC.faq_category_key = MC.faq_category_key
WHERE FC.faq_category_key = ?
AND MC.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 21
Parameter #2(CF_SQL_INTEGER) = 1
qget_faq (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:19.019
SELECT MF.faq_question, MF.faq_answer, MF.faq_title, F.faq_key, F.faq_ans, F.faq_name, F.faq_email, F.faq_ans_date, F.faq_ask_date, F.faq_date, F.faq_email_sender, F.faq_name_sender, F.faq_lang_sender
FROM MAIN_FAQ MF
INNER JOIN FAQ F ON MF.faq_key = F.faq_key
WHERE F.faq_key = ?
AND MF.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 65
Parameter #2(CF_SQL_INTEGER) = 1
qGetcats (Datasource=WaterWays, Time=0ms, Records=3) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:19.019
SELECT FC.faq_category_key
FROM FAQ_CATEGORY FC
INNER JOIN FAQVSFAQ_CATEGORY FFC ON FC.faq_category_key = FFC.faq_category_key
INNER JOIN FAQ F ON FFC.faq_key = F.faq_key
INNER JOIN FAQVSDEPLOYMENT FD ON F.faq_key = FD.faq_key
INNER JOIN MAIN_FAQ MF ON F.faq_key = MF.faq_key
WHERE FD.deployment_key = ?
AND F.faq_key = ?
GROUP BY FC.faq_category_key
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1
Parameter #2(CF_SQL_INTEGER) = 65
qgetcat_faq (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:20.020
SELECT MC.faq_category_name, FC.faq_category_key
FROM FAQ_CATEGORY FC
INNER JOIN MAIN_FAQCATEGORY MC ON FC.faq_category_key = MC.faq_category_key
WHERE FC.faq_category_key = ?
AND MC.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2
Parameter #2(CF_SQL_INTEGER) = 1
qgetcat_faq (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:20.020
SELECT MC.faq_category_name, FC.faq_category_key
FROM FAQ_CATEGORY FC
INNER JOIN MAIN_FAQCATEGORY MC ON FC.faq_category_key = MC.faq_category_key
WHERE FC.faq_category_key = ?
AND MC.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 7
Parameter #2(CF_SQL_INTEGER) = 1
qgetcat_faq (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:20.020
SELECT MC.faq_category_name, FC.faq_category_key
FROM FAQ_CATEGORY FC
INNER JOIN MAIN_FAQCATEGORY MC ON FC.faq_category_key = MC.faq_category_key
WHERE FC.faq_category_key = ?
AND MC.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 8
Parameter #2(CF_SQL_INTEGER) = 1
qget_faq (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:20.020
SELECT MF.faq_question, MF.faq_answer, MF.faq_title, F.faq_key, F.faq_ans, F.faq_name, F.faq_email, F.faq_ans_date, F.faq_ask_date, F.faq_date, F.faq_email_sender, F.faq_name_sender, F.faq_lang_sender
FROM MAIN_FAQ MF
INNER JOIN FAQ F ON MF.faq_key = F.faq_key
WHERE F.faq_key = ?
AND MF.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 289
Parameter #2(CF_SQL_INTEGER) = 1
qGetcats (Datasource=WaterWays, Time=0ms, Records=3) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:20.020
SELECT FC.faq_category_key
FROM FAQ_CATEGORY FC
INNER JOIN FAQVSFAQ_CATEGORY FFC ON FC.faq_category_key = FFC.faq_category_key
INNER JOIN FAQ F ON FFC.faq_key = F.faq_key
INNER JOIN FAQVSDEPLOYMENT FD ON F.faq_key = FD.faq_key
INNER JOIN MAIN_FAQ MF ON F.faq_key = MF.faq_key
WHERE FD.deployment_key = ?
AND F.faq_key = ?
GROUP BY FC.faq_category_key
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1
Parameter #2(CF_SQL_INTEGER) = 289
qgetcat_faq (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:20.020
SELECT MC.faq_category_name, FC.faq_category_key
FROM FAQ_CATEGORY FC
INNER JOIN MAIN_FAQCATEGORY MC ON FC.faq_category_key = MC.faq_category_key
WHERE FC.faq_category_key = ?
AND MC.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 8
Parameter #2(CF_SQL_INTEGER) = 1
qgetcat_faq (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:20.020
SELECT MC.faq_category_name, FC.faq_category_key
FROM FAQ_CATEGORY FC
INNER JOIN MAIN_FAQCATEGORY MC ON FC.faq_category_key = MC.faq_category_key
WHERE FC.faq_category_key = ?
AND MC.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 13
Parameter #2(CF_SQL_INTEGER) = 1
qgetcat_faq (Datasource=WaterWays, Time=15ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:20.020
SELECT MC.faq_category_name, FC.faq_category_key
FROM FAQ_CATEGORY FC
INNER JOIN MAIN_FAQCATEGORY MC ON FC.faq_category_key = MC.faq_category_key
WHERE FC.faq_category_key = ?
AND MC.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 21
Parameter #2(CF_SQL_INTEGER) = 1
qget_faq (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:20.020
SELECT MF.faq_question, MF.faq_answer, MF.faq_title, F.faq_key, F.faq_ans, F.faq_name, F.faq_email, F.faq_ans_date, F.faq_ask_date, F.faq_date, F.faq_email_sender, F.faq_name_sender, F.faq_lang_sender
FROM MAIN_FAQ MF
INNER JOIN FAQ F ON MF.faq_key = F.faq_key
WHERE F.faq_key = ?
AND MF.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 298
Parameter #2(CF_SQL_INTEGER) = 1
qGetcats (Datasource=WaterWays, Time=0ms, Records=10) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:20.020
SELECT FC.faq_category_key
FROM FAQ_CATEGORY FC
INNER JOIN FAQVSFAQ_CATEGORY FFC ON FC.faq_category_key = FFC.faq_category_key
INNER JOIN FAQ F ON FFC.faq_key = F.faq_key
INNER JOIN FAQVSDEPLOYMENT FD ON F.faq_key = FD.faq_key
INNER JOIN MAIN_FAQ MF ON F.faq_key = MF.faq_key
WHERE FD.deployment_key = ?
AND F.faq_key = ?
GROUP BY FC.faq_category_key
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1
Parameter #2(CF_SQL_INTEGER) = 298
qgetcat_faq (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:20.020
SELECT MC.faq_category_name, FC.faq_category_key
FROM FAQ_CATEGORY FC
INNER JOIN MAIN_FAQCATEGORY MC ON FC.faq_category_key = MC.faq_category_key
WHERE FC.faq_category_key = ?
AND MC.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2
Parameter #2(CF_SQL_INTEGER) = 1
qgetcat_faq (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:20.020
SELECT MC.faq_category_name, FC.faq_category_key
FROM FAQ_CATEGORY FC
INNER JOIN MAIN_FAQCATEGORY MC ON FC.faq_category_key = MC.faq_category_key
WHERE FC.faq_category_key = ?
AND MC.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3
Parameter #2(CF_SQL_INTEGER) = 1
qgetcat_faq (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:20.020
SELECT MC.faq_category_name, FC.faq_category_key
FROM FAQ_CATEGORY FC
INNER JOIN MAIN_FAQCATEGORY MC ON FC.faq_category_key = MC.faq_category_key
WHERE FC.faq_category_key = ?
AND MC.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 5
Parameter #2(CF_SQL_INTEGER) = 1
qgetcat_faq (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:20.020
SELECT MC.faq_category_name, FC.faq_category_key
FROM FAQ_CATEGORY FC
INNER JOIN MAIN_FAQCATEGORY MC ON FC.faq_category_key = MC.faq_category_key
WHERE FC.faq_category_key = ?
AND MC.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 6
Parameter #2(CF_SQL_INTEGER) = 1
qgetcat_faq (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:20.020
SELECT MC.faq_category_name, FC.faq_category_key
FROM FAQ_CATEGORY FC
INNER JOIN MAIN_FAQCATEGORY MC ON FC.faq_category_key = MC.faq_category_key
WHERE FC.faq_category_key = ?
AND MC.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 8
Parameter #2(CF_SQL_INTEGER) = 1
qgetcat_faq (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:20.020
SELECT MC.faq_category_name, FC.faq_category_key
FROM FAQ_CATEGORY FC
INNER JOIN MAIN_FAQCATEGORY MC ON FC.faq_category_key = MC.faq_category_key
WHERE FC.faq_category_key = ?
AND MC.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 9
Parameter #2(CF_SQL_INTEGER) = 1
qgetcat_faq (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:20.020
SELECT MC.faq_category_name, FC.faq_category_key
FROM FAQ_CATEGORY FC
INNER JOIN MAIN_FAQCATEGORY MC ON FC.faq_category_key = MC.faq_category_key
WHERE FC.faq_category_key = ?
AND MC.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 10
Parameter #2(CF_SQL_INTEGER) = 1
qgetcat_faq (Datasource=WaterWays, Time=16ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:20.020
SELECT MC.faq_category_name, FC.faq_category_key
FROM FAQ_CATEGORY FC
INNER JOIN MAIN_FAQCATEGORY MC ON FC.faq_category_key = MC.faq_category_key
WHERE FC.faq_category_key = ?
AND MC.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 11
Parameter #2(CF_SQL_INTEGER) = 1
qgetcat_faq (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:20.020
SELECT MC.faq_category_name, FC.faq_category_key
FROM FAQ_CATEGORY FC
INNER JOIN MAIN_FAQCATEGORY MC ON FC.faq_category_key = MC.faq_category_key
WHERE FC.faq_category_key = ?
AND MC.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 13
Parameter #2(CF_SQL_INTEGER) = 1
qgetcat_faq (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:20.020
SELECT MC.faq_category_name, FC.faq_category_key
FROM FAQ_CATEGORY FC
INNER JOIN MAIN_FAQCATEGORY MC ON FC.faq_category_key = MC.faq_category_key
WHERE FC.faq_category_key = ?
AND MC.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 21
Parameter #2(CF_SQL_INTEGER) = 1
qget_faq (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:20.020
SELECT MF.faq_question, MF.faq_answer, MF.faq_title, F.faq_key, F.faq_ans, F.faq_name, F.faq_email, F.faq_ans_date, F.faq_ask_date, F.faq_date, F.faq_email_sender, F.faq_name_sender, F.faq_lang_sender
FROM MAIN_FAQ MF
INNER JOIN FAQ F ON MF.faq_key = F.faq_key
WHERE F.faq_key = ?
AND MF.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 105
Parameter #2(CF_SQL_INTEGER) = 1
qGetcats (Datasource=WaterWays, Time=0ms, Records=3) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:20.020
SELECT FC.faq_category_key
FROM FAQ_CATEGORY FC
INNER JOIN FAQVSFAQ_CATEGORY FFC ON FC.faq_category_key = FFC.faq_category_key
INNER JOIN FAQ F ON FFC.faq_key = F.faq_key
INNER JOIN FAQVSDEPLOYMENT FD ON F.faq_key = FD.faq_key
INNER JOIN MAIN_FAQ MF ON F.faq_key = MF.faq_key
WHERE FD.deployment_key = ?
AND F.faq_key = ?
GROUP BY FC.faq_category_key
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1
Parameter #2(CF_SQL_INTEGER) = 105
qgetcat_faq (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:20.020
SELECT MC.faq_category_name, FC.faq_category_key
FROM FAQ_CATEGORY FC
INNER JOIN MAIN_FAQCATEGORY MC ON FC.faq_category_key = MC.faq_category_key
WHERE FC.faq_category_key = ?
AND MC.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2
Parameter #2(CF_SQL_INTEGER) = 1
qgetcat_faq (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:20.020
SELECT MC.faq_category_name, FC.faq_category_key
FROM FAQ_CATEGORY FC
INNER JOIN MAIN_FAQCATEGORY MC ON FC.faq_category_key = MC.faq_category_key
WHERE FC.faq_category_key = ?
AND MC.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 8
Parameter #2(CF_SQL_INTEGER) = 1
qgetcat_faq (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:20.020
SELECT MC.faq_category_name, FC.faq_category_key
FROM FAQ_CATEGORY FC
INNER JOIN MAIN_FAQCATEGORY MC ON FC.faq_category_key = MC.faq_category_key
WHERE FC.faq_category_key = ?
AND MC.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 13
Parameter #2(CF_SQL_INTEGER) = 1
qget_faq (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:20.020
SELECT MF.faq_question, MF.faq_answer, MF.faq_title, F.faq_key, F.faq_ans, F.faq_name, F.faq_email, F.faq_ans_date, F.faq_ask_date, F.faq_date, F.faq_email_sender, F.faq_name_sender, F.faq_lang_sender
FROM MAIN_FAQ MF
INNER JOIN FAQ F ON MF.faq_key = F.faq_key
WHERE F.faq_key = ?
AND MF.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 90
Parameter #2(CF_SQL_INTEGER) = 1
qGetcats (Datasource=WaterWays, Time=0ms, Records=5) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:20.020
SELECT FC.faq_category_key
FROM FAQ_CATEGORY FC
INNER JOIN FAQVSFAQ_CATEGORY FFC ON FC.faq_category_key = FFC.faq_category_key
INNER JOIN FAQ F ON FFC.faq_key = F.faq_key
INNER JOIN FAQVSDEPLOYMENT FD ON F.faq_key = FD.faq_key
INNER JOIN MAIN_FAQ MF ON F.faq_key = MF.faq_key
WHERE FD.deployment_key = ?
AND F.faq_key = ?
GROUP BY FC.faq_category_key
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1
Parameter #2(CF_SQL_INTEGER) = 90
qgetcat_faq (Datasource=WaterWays, Time=0ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:20.020
SELECT MC.faq_category_name, FC.faq_category_key
FROM FAQ_CATEGORY FC
INNER JOIN MAIN_FAQCATEGORY MC ON FC.faq_category_key = MC.faq_category_key
WHERE FC.faq_category_key = ?
AND MC.language_key = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3
Parameter #2(CF_SQL_INTEGER) = 1
qgetcat_faq (Datasource=WaterWays, Time=16ms, Records=1) in D:\waterwaysireland\1.waterways.biznetservers.com\www_root\components\faqs.cfc @ 06:38:20.020
SELECT MC.faq_category_name, FC.faq_category_key
FROM FAQ_CATEGORY FC
INNER JOIN MAIN_FAQCATEGORY MC ON FC.faq_category_key = MC.faq_category_key |