検索

Question
· Sept 15, 2016

ERROR - SQL Error '[Cache ODBC][State : S1000][Native Code 29]

#ObjectScript #SQL #Caché

I have been using the query below and it was working fine but now it's giving a SQL error. There were no changes made that could cause this to stop working. There is no Field 'APPLICATIONID' in the table.

QueueSQL=select distinct (convert(char(5),SkillsetID)+'='+Skillset) from iagentbySkillsetStat where ApplicationID > 10000
QueueMappingSQL=SELECT DISTINCT (convert(char(5),SkillsetID)+'='+Skillset), SkillsetID FROM iagentbySkillsetStat iagentbySkillsetStat WHERE (iagentbySkillsetStat.ApplicationID>10000)

DB- Intersystems Cache

Error details for the log files are below.

14/09/2016 11:20:05 a.m. > ERROR - SQL Error '[Cache ODBC][State : S1000][Native Code 29]
[C:\xlink\xlink Compiled Package\Xlink Application\Isps_Ul.exe]
[SQLCODE: <-29>:]
[Cache Error: <errdone+2^%qaqqt>]
[Details: ]
[%msg: < SQL ERROR #29: Field 'APPLICATIONID' not found in the applicable tables^select distinct ( convert ( char ( 5 ) , SkillsetID ) + :%qpar(1) + Skillset ) from iagentbySkillsetStat where ApplicationID >>]'

Thanks in advance.

6 Comments
Discussion (6)0
Connectez-vous ou inscrivez-vous pour continuer
Question
· Sept 14, 2016

Question: CSP Session

#CSP #Caché

Hi,

  I was set one session in user namespce (%session.Data("sup")="login User ").but i couldn't get this session(%session.Data("sup")) in  another namespace.

Cache version:cache 16

but i can acces in cache 5.02.

4 Comments
Discussion (4)0
Connectez-vous ou inscrivez-vous pour continuer
Question
· Août 29, 2016

Regular Expression to Strip HTML Tags

#ObjectScript #Caché

I want to use the Regex Matcher to strip HTML tags, but I get a REGEX error. Can anyone explain what I'm doing wrong?

set htmlSnippet = "<h1>Hello</h1>"
set regex = ##class(%Regex.Matcher).%New()
set regex.Text = htmlSnippet
set regex.Pattern = "<[^>]*>"
set plainText = regex.ReplaceAll(" ")
write !,plainText

1 Comment
Discussion (1)0
Connectez-vous ou inscrivez-vous pour continuer
Question
· Août 29, 2016

Cache 5.02 installation

#Administration du système #Caché

Hi all,

We have one doubt regarding cache 5.02 installation.

What is the difference b/w custom and standard installation in cache 5.02?

Thanks,

Sansa.

1 Comment
Discussion (1)0
Connectez-vous ou inscrivez-vous pour continuer
Question
· Août 17, 2016

Setting ContentType in Rest Service

#HealthShare

Hello,

I am working on a Rest Service that should accept a particular content type. How and where can I set the value?

I have tried setting the value %response.ContentType by overriding Page method OnPreHttp()  but from what I see this method never got executed. 

 

Thanks

Raghu

13 Comments
Discussion (13)0
Connectez-vous ou inscrivez-vous pour continuer