Albert Hopkins

Hi...
I have a sql script called student.sql .

How can I call that script directly using JSP.

Example : Query = student.sql;

thanks

p.s : I hope I'm in the right topic.

Hi...

I wrote

ResultSet rs25 = stmt.executeQuery("SELECT count(BLESS_SEVERITY) as sbmseverity3 from BLESS where BLESS_SEVERITY=3 AND bless_orno like '%_QSC_%'" + "SELECT count(BLESS_SEVERITY) as no2 from bless"); rs25.next(); out.println("<p>Test with harstate (SEV1) = "+ rs25.getInt("sbmseverity3") + "</p>"); out.println("<p>Test with harstate (SEV1) = "+ rs25.getInt("no2") + "</p>");

But, I got SQLException: ORA-00933: SQL command not properly ended message.

What I did wrong?? please

Hi..
thank you for the reply..

can you give me an example how to do it???

I'm really a beginner...just trying & trying...until I'm brain dead

ok...

the script compares string

"RDBMS" using .equals

How if i don't want to use equals, because I want the script to compare without using the whole "RDBMS". Just compare "R....S" ??

Can you suggest??

Hi...
I have many Resultset in a page. For evert resultset, we have to the next() thing right??

ResultSet rs13 = stmt.executeQuery("SELECT count(BLESS_SEVERITY) as sbmseverity1 from BLESS where BLESS_SEVERITY=1 AND bless_orno like '%_LOG_%'"); rs13.next(); out.println("<p>Result for Login Module (SEV1) = "+ rs13.getInt("sbmseverity1") + "</p>"); ResultSet rs14 = stmt.executeQuery("SELECT count(BLESS_SEVERITY) as sbmseverity2 from BLESS where BLESS_SEVERITY=2 AND bless_orno like '%_LOG_%'"); rs14.next(); out.println("<p>Result for Login Module (SEV2) = "+ rs14.getInt("sbmseverity2") + "</p>");

When I try to display the result nicely on my page, I realized I have to display it concurrently because it is fixed by the next(). I can't display rs13 with rs14 together in my layout.

How to do this?? thank you

Thank you.

Ok..this is another example

try { if (configId != null && configId.trim().length() > 0) { Config dsConfig = dataService.getConfig(configId); if (config != null) { dataSourceType = dsConfig.getDataSourceType(); ArrayList configProperties = dsConfig.getProperties(); propertyIterator = configProperties.iterator(); if("RDBMS".equals(dataSourceType)){ String jdbcUrl = dsConfig.getPropertyValue(DBConstants.PROTOCOL); if(jdbcUrl != null){ rdbmsEngineType = Utils.getRDBMSEngine(jdbcUrl); } } } } else { configId = "";

you can see this if("RDBMS".equals(dataSourceType)){ line.

It queries "RDBMS" from the database. I want that the script queries any word contains any "R _ _ _ S" . The result will come out.

In SQL, I understand we can use ( select dataSourceType from data where dataSourceType like 'r_ _ _s') .

I hope this helps.

thank you

Hi...
please assist me:

I want to query a name called "hello_sbm_007" from a field.

I used this code:

if ("Development".equals(STATENAME) & "_SBM_".equals(BLESS_ORNO) ) { if ("1".equals(BLESS_SEVERITY)) devsubcount1 = devsubcount1 + 1; if ("2".equals(BLESS_SEVERITY)) devsubcount2 = devsubcount2 + 1; if ("3".equals(BLESS_SEVERITY)) devsubcount3 = devsubcount3 + 1; }

The code should query word that contains "_SBM_" . It didn't worked for me.

Pleas help

Originally posted by Amol Nayak:
When your are displaying source code it might contain characters like <,>,& etc..
So you will need to escape these special characters. have a look at the JSTL tag suggested by Bear, that will give you the answer.

The work "escape" from Amol and hint from bear really helped.

Thanks.

what if i use

< & > ??? is it ok??

thanks

i just want to display source code examples in a webpage. So that people can copy & paste it.

please help me. An example would be very appreciated

i'm sure its something very easy.

Gonna find it out.

hi..
thanks..

but still, i can't find it out..

please help me

Hi..
I'm developing a small project that displays source code examples.

what is the suitable tags can be used??