Error Executing Database Query.
|
[Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 'RPT.Kursteam_med_SlunikTeam'.
|
|
The error occurred in D:/web-sites/University/evald.slu.se/print_student.cfm: line 67
Called from |SQLServer|6.0.0.1282|: line 1085
Called from |SQLServer|6.0.0.1282|: line 980
Called from |SQLServer|6.0.0.1282|: line 1124
Called from |SQLServer|6.0.0.1282|: line 193
Called from |SQLServer|6.0.0.1282|: line 1153
Called from |SQLServer|6.0.0.1282|: line 4126
Called from |SQLServer|6.0.0.1282|: line 1059
Called from |SQLServer|6.0.0.1282|: line 4275
Called from |SQLServer|6.0.0.1282|: line 2035
Called from |SQLServer|6.0.0.1282|: line 632
Called from |SQLServer|6.0.0.1282|: line 2699
Called from |SQLServer|6.0.0.1282|: line 526
Called from |SQLServer|6.0.0.1282|: line 2508
Called from |SQLServer|6.0.0.1282|: line 1358
Called from |SQLServer|6.0.0.1282|: line 2703
Called from |SQLServer|6.0.0.1282|: line 525
Called from |SQLServer|6.0.0.1282|: line 1085
Called from |SQLServer|6.0.0.1282|: line 980
Called from |SQLServer|6.0.0.1282|: line 1124
Called from |SQLServer|6.0.0.1282|: line 193
Called from |SQLServer|6.0.0.1282|: line 1153
Called from |SQLServer|6.0.0.1282|: line 4126
Called from |SQLServer|6.0.0.1282|: line 1059
Called from |SQLServer|6.0.0.1282|: line 4275
Called from |SQLServer|6.0.0.1282|: line 2035
Called from |SQLServer|6.0.0.1282|: line 632
Called from |SQLServer|6.0.0.1282|: line 2699
Called from |SQLServer|6.0.0.1282|: line 526
Called from |SQLServer|6.0.0.1282|: line 2508
Called from |SQLServer|6.0.0.1282|: line 1358
Called from |SQLServer|6.0.0.1282|: line 2703
Called from |SQLServer|6.0.0.1282|: line 525
Called from D:/web-sites/University/evald.slu.se/print_student.cfm: line 67
|
65 : [slu].[Kurs] k ON kt.UTBILDNINGSINSTANS_UID = k.UTBILDNINGSINSTANS_UID
66 : WHERE kt.Utbildningstillfalle_kod+'.'+lasar = <cfqueryparam value="#GetKurs.AnmKod#" cfsqltype="cf_sql_varchar">
67 : AND k.Utbildning_kod = <cfqueryparam value="#GetKurs.KursKod#" cfsqltype="cf_sql_varchar">
68 : </cfquery>
69 :
|
|
SQLSTATE |
42S02 |
EXCEPTIONS |
<small><i>not set</i></small> |
DATASOURCE |
slunik_prod |
VENDORERRORCODE |
208 |
SQL |
SELECT Omfattningsvarde AS Hp, kt.studietakt_kod AS Studietakt,
k.Nivainomstudieordning_kod AS nivaid,
TRIM(SUBSTRING(
(
SELECT ', '+ST1.namn AS [text()]
FROM [RPT].[Kursteam_med_SlunikTeam] ST1
WHERE kt.Utbildningstillfalle_kod+'.'+kt.lasar = ST1.Anmkod
AND kt.Utbildning_kod = ST1.kurskod
AND teamroll = 'Kursledare'
ORDER BY ST1.namn
FOR XML PATH (''), TYPE
).value('text()[1]','nvarchar(max)'), 2, 1000)) AS Kursansvarig_namn,
isnuLL(LEFT(Undervisningssprak_kod,1),' ') AS sprak_id,
'' AS Nivakod
FROM [slu].[Kurstillfalle] kt JOIN
[slu].[Kurs] k ON kt.UTBILDNINGSINSTANS_UID = k.UTBILDNINGSINSTANS_UID
WHERE kt.Utbildningstillfalle_kod+'.'+lasar = (param 1)
AND k.Utbildning_kod = (param 2) |
|
Resources:
|
Browser |
claudebot |
Remote Address |
18.207.126.53 |
Referrer |
|
Date/Time |
29-Mar-24 11:25 AM |
|