I have got some problem with my sql query in oracle 9i.
i m trying to stop several occurances of same Do_No.
In the following example (Example1)shows that each Do_No have different MR_No and different MR_Amount.The problem is, we can see that same DO_No occourars several times.But i want it once only when show report on screen(see Example2).
Exmple:1
Query:
select
v_do_sales6.do_ no,
v_mreceipt1.mr_ no,...
boss1
Last Activity: Aug 17 '09, 09:47 AM
Joined: Sep 27 '07
Location:
-
Oracle Query problem...
-
how to stop upadting data fields with empty in php
hi everyone,
i m having a problem with my php update code.
i have 7 text fields in a webpage.
i have written a code for updating multiple fields in database and it's working properly.but the problem is that, suppose when i m trying to update 3 outof 7 fields to be updated,the rest of the fields updates with simply with empty values.
now what can i do to restrict the others fields from updating.... -
hi,
A new problem is arised.A massege is coming when i use form action="selfpaf e"
and redirection is used that is header("Locatio n:/welcome.php");
The massege is:
The requested URL / welcome.php was not found on this server
Note:the previous error massege is not found again.
so what now?..pls.. -
hello,
i m havimg another problem when i use header("Locatio n: welcome.php"); i get this massege is in below:
You don't have permission to access /new/="/new/welcome.php" on this server.
i have used the directory in httpconf file is:
DirectoryIndex index.php index.html
still the the massege is showing.So now what can i do?
pls help meLeave a comment:
-
hi Atli,
Thank u for ur cooperation.
Here is my code :
[code=php]
<html>
<head><head>
code:(text)
<?
if ($c=ocilogon("a a","bb","ccc "))
//echo"successful ly connected to database.\n";
?>
<?
$insert="insert into member_tbl(id,n ame,age) values('".$_POS T['id']."','".$_POS T['name']."','".$_POS T['age']."')";...Leave a comment:
-
problem with page redirect and data insertion together
Hi all,
i m having a problem with inserting data in oracle db.
When i use form action =(call self page) then data is inserting properly.But problem with when using form action=(Another _page).data is not insering into database.For ur kind infromation i m using oracle db and php for my application.
sample code:
[code=html]
...Leave a comment:
-
hei,
i need ur help wthh my specified problem previously disscussed.
it's urgent for me so, pls help me.
ThanksLeave a comment:
-
hi,
Thanks for ur cooperation.
it willbe help for me if u make it clear in my given example for how to use "header"to redirect the page into welcome.php.
thanks againLeave a comment:
-
hi,
Thanks for reply.
My fisrt page is "test.php" from where i m trying to insert data
After press on submit button form data will store in db and a success massege will show on the "wlcome.php"pag e.
[code=html]
<html>
<body><form action="welcome .php" method="post">
Name: <input type="text" name="name" />...Leave a comment:
-
problem with page redirect and data insertion together
Hi all,
i m having a problem with inserting data in oracle db.
When i use form action =(call self page) then data is inserting properly.But problem with when using form action=(Another _page).data is not insering into database.For ur kind infromation i m using oracle db and php for my application.
sample code:
[code=php]
<form action="welcome .php" method="post">
... -
boss1 started a topic How to populate second drop down list depending on selected on first with php+oraclein PHPHow to populate second drop down list depending on selected on first with php+oracle
hello everyone,
I am having a problem with populating second a drop down list depending on selected value of first drop down list. I have been searching the net for the last couple of days i found php with mysql and but couldn't find anything for oracle + php. in php using sql pulling from and oracle db. Can anyone help or tell me .
Thanks in advance -
Hi acoder,
Thank you so much. Your given idea is working properly.
i have spent a lot days for it.But i could'nt now it's working.
Tank u so much againLeave a comment:
-
Hello Tom
Thanks for your co-operation.If u please provide me an example,it will be more clear to me. But one thing i need to call the self page agian.
ThanksLeave a comment:
-
The way you have suggested is not working for me. i willbe happy if you give me an example. here i have given some code of me.Try to give a soluation from it.
[code=javascript]
This is my ajax code:
if (ObjectName=="P ARTY_CODE")
{
document.getEle mentById("txtHi nt2").innerHTML =xmlHttp.respon seText
}[/code]
This is where i want to show value:
[HTML]...Leave a comment:
-
how to restrict inserting data into db while html page refreshing
hello everyone,
i need your help.
i m using update query for a table to update data. i want to insert data when submit button is pressed but when page is refeshed the table data is automatically updated the value. now i want to restrict automatic update except submit button is pressed.
how to do it ?
can any one please help me out.
Thanks -
how to put div id content inside a input box in html page
hello everyone,
i need your help.
i m using ajax to retrieve value from database and showing it within html form insise div tag .its working well.But now i need to show div id content(field value from database) inside a input box.i m using onchange event.
how to do it ?
can any one please help me out.
Thanks -
how to show div id value inside a text box in php?
hello everyone,
i need your help.
i m using ajax to retrieve value from database and showing it within html form insise div tag .its working well.But now i need to show div id content(field value from database) inside a input box.i m using onchange event.
how to do it ?
can any one please help me out.
Thanks -
hi ,thank you for ur response.
but the code does not showing any output.
i wanted to show last row value for selective column by using"echo"
But it does not show any result.
[php]$query5 = "SELECT * FROM depo_location_t bl";
$statement = ociparse ($c, $query5);
ociexecute ($statement);
$norows = ocifetchstateme nt($statement, $results);
if ($norows > 0) {
...Leave a comment:
-
hi ,thank you for ur response.
but the code does not showing any output.
i wanted to show last row value for selective column by using"echo"
But it does not show any result.[php]$query5 = "SELECT * FROM depo_location_t bl";
$statement = ociparse ($c, $query5);
ociexecute ($statement);
$norows = ocifetchstateme nt($statement, $results);
if ($norows > 0) {
$lastrow=$norow s-1;...Leave a comment:
-
get selected column value for the last row in oracle db
hi all'
i m using php4 and oracle 9idb for my web-application.
i have got a problem .that is i just want to know how to get selected column value for the last row in table.
suppose i have employee table having 10 rows and 8 columns.Now i want to get the value for :column1,column 5,column8 for the 10th(last row) no.of row.
How to do this in oracle,php..can anybody help me?
...
No activity results to display
Leave a comment: