Ler Ping
|
| Posted: 03/19/2002, 7:17 AM |
|
Currently running on Oracle, on JSP. Why doesn't my previously inserted data
show through the generated files? Insertion is perfect, no problems happen.
But display only shows the records that I inserted through the JSP files,
but not the ones that already resided in the database which i inserted
through .sql files. These insertions through .sql files are fine becasue a
quick Select statement shoes that they have been inserted. I did a select
statement for the records that the JSP files inserted and they appear to be
the same. So what is hindering the JSP from displaying the previously
inserted data?
|
|
|
 |
Michael Rachow
|
| Posted: 03/19/2002, 11:37 PM |
|
Maybe you have not committed the sql-inserted data!?
Michael
"Ler Ping" <mimaclit69@hotmail.com> schrieb im Newsbeitrag
news:a77kq0$ili$1@news.codecharge.com...
> Currently running on Oracle, on JSP. Why doesn't my previously inserted
data
> show through the generated files? Insertion is perfect, no problems
happen.
> But display only shows the records that I inserted through the JSP files,
> but not the ones that already resided in the database which i inserted
> through .sql files. These insertions through .sql files are fine becasue a
> quick Select statement shoes that they have been inserted. I did a select
> statement for the records that the JSP files inserted and they appear to
be
> the same. So what is hindering the JSP from displaying the previously
> inserted data?
>
>
>
>
>
|
|
|
|
Ler Ping
|
| Posted: 03/20/2002, 3:00 AM |
|
How do I commit the data? Could you teach me?
Yours,
Ler Ping
|
|
|
|
Alexey Alexapolsky
|
| Posted: 03/20/2002, 6:05 AM |
|
Print out sSQL variable via out.println(sSQL) in Form Open event
and then execute resulting sql in SQL+ , see if results are indetical to the
ones
from CC app.
--
Alex
CodeCharge Developer
"Ler Ping" <mimaclit69@hotmail.com> wrote in message
news:a77kq0$ili$1@news.codecharge.com...
> Currently running on Oracle, on JSP. Why doesn't my previously inserted
data
> show through the generated files? Insertion is perfect, no problems
happen.
> But display only shows the records that I inserted through the JSP files,
> but not the ones that already resided in the database which i inserted
> through .sql files. These insertions through .sql files are fine becasue a
> quick Select statement shoes that they have been inserted. I did a select
> statement for the records that the JSP files inserted and they appear to
be
> the same. So what is hindering the JSP from displaying the previously
> inserted data?
>
>
>
>
|
|
|
|
RonB
|
| Posted: 03/23/2002, 4:46 AM |
|
"Ler Ping" <mimaclit69@hotmail.com> schreef in bericht
news:a79q55$l05$1@news.codecharge.com...
> How do I commit the data? Could you teach me?
>
> Yours,
> Ler Ping
>
>
after the insert sql has done it's job(assuming you use sql plus for that)
type commit; and enter that's it.
RonB
|
|
|
|
|
