Comments by Abed Al Rahman Hussien Balhawan

Abed Al Rahman Hussien Balhawan 1-Apr-24 9:01am View

Hello Pete, the code that generates this file is working fine, the file is also working fine in the server, only when using the readfile function this Is happening.

Abed Al Rahman Hussien Balhawan 1-Apr-24 6:54am View

when I download the file I see the size is correct. The extension type too, however when I try to access it returns a warning message(Excel cannot open the file 'generated_BOQ1.xlsx'because the file format or file extension is not valid, verify that the file has not been corrupted and that the file extension matches the format of the file.)

Abed Al Rahman Hussien Balhawan 29-Mar-24 10:14am View

Hello Andre, thank you for your response,I will try the script you provided and let you know,

please note that the purpose of my script is that users upload an excel file from his machine to the server path
'C:\\xampp\\htdocs\\HTML\\SSProcess\\ExcelFiles' by a button called "upload" in HTML scrip
bellow is part of code I did not include at the beginning of my question:

if(isset($_POST['upload'])){
$targetDir="C:\\SSProcess\\ExcelFiles\\";
$excel_path = $targetDir . basename ($_FILES["excelFile"][name]);

if (move_uploaded_file($_FILES["excelFile"]["tmp_name"], $excel_path)) {
echo "The file ". basename( $_FILES["excelFile"]["name"]). " has been uploaded.";
echo "file path = ", $excel_path, " .";

the idea is after the file is uploaded, the VBScript should be then executed all happening in the server side only, and yes office 365 are installed on the servers.

also, this is only one of 15 vbscripts to be executed, if there is an alternative way instead of changing the entire logic to jvscript I will be glad.

much thanks.

Abed Al Rahman Hussien Balhawan 29-Mar-24 4:47am View

Hello the application runs in a server in xaamp file, the user uploads an excel file from him local PC to xaamp using a PHP script and then VBScript and python script are executed inside the server and after execution the PHP sends the file back to the user as a download.

please let me know if this is possible to achieve

Abed Al Rahman Hussien Balhawan 15-Mar-20 11:59am View

Yes a last table called branch(branch_name,branch_city,assets)

Abed Al Rahman Hussien Balhawan 15-Mar-20 11:30am View

its giving me an error :
ORA-02292: integrity constraint (SYS.FK_LOAN_TAKE) violated - child record found

Abed Al Rahman Hussien Balhawan 15-Mar-20 11:20am View

DELETE Loan
WHERE loan_number IN (SELECT t.loan_number
FROM take t JOIN customer c ON c.cust_ID=t.cust_ID
WHERE c.cust_name='Jones')

something like this ?

Abed Al Rahman Hussien Balhawan 15-Mar-20 10:59am View

i tried a select query with join , still i cannot figure out how to convert it to delete

select c.cust_name,c.cust_id,l.loan_number
from customer c
join take t on c.cust_id=t.cust_id
join loan l on l.loan_number=t.loan_number
where c.cust_name = 'Smith'

Abed Al Rahman Hussien Balhawan 10-Mar-20 13:59pm View

it worked now , i was missing a letter,

so u do not suggest creating a function with an input , and then calling it in main ?

Abed Al Rahman Hussien Balhawan 10-Mar-20 13:46pm View

100% i forgot to define num1 , num2 in main much thanks!

Abed Al Rahman Hussien Balhawan 10-Mar-20 13:45pm View

this one didnot work for me sir

Abed Al Rahman Hussien Balhawan 4-Mar-20 14:55pm View

something like that ?
CREATE OR REPLACE TYPE PERSON AS OBJECT (
P_ID integer,
Name Char(20),
Age Integer
);

Abed Al Rahman Hussien Balhawan 4-Mar-20 14:08pm View

thank you for the clarification

Abed Al Rahman Hussien Balhawan 3-Mar-20 23:43pm View

amazing clarification , oracle10g is giving me this error

ORA-02292: integrity constraint (SYS.FK_LOAN_TAKE) violated - child record found

Abed Al Rahman Hussien Balhawan 3-Mar-20 23:28pm View

Deleted

Amazing !!! clarification i understood the every taken step!!

Thank You Sir

Abed Al Rahman Hussien Balhawan 2-Mar-20 23:42pm View

i tried update using inner join method, it did not work
error code : ORA-00933: SQL command not properly ended

Abed Al Rahman Hussien Balhawan 2-Mar-20 23:28pm View

your version did not work on my oracle10G

i modified it as the following

SELECT Cust_ID, Account_Balance,Account_Balance*1.1 as NewBalance
FROM Account a
INNER JOIN Has h ON a.Account_Number = h.Account_Number
WHERE h.Cust_ID = 3

Resulting:
CUST_ID ACCOUNT_BALANCE NEWBALANCE
3 440 484
3 550 605

thank you for the information Madmyche i really appreciate :)

Abed Al Rahman Hussien Balhawan 2-Mar-20 22:15pm View

I will try to do it with a inner join now.

Abed Al Rahman Hussien Balhawan 2-Mar-20 22:14pm View

i fixed it
UPDATE account
SET account.account_balance = account.account_balance * 1.1
WHERE EXISTS (SELECT h.account_number
FROM has h
where account.account_number = h.account_number
and h.cust_id=3)

Abed Al Rahman Hussien Balhawan 2-Mar-20 22:01pm View

hello, i tried those queries and they did not work on oracle database10G

I tried this one on a similar case it works pretty fine , but here it us updating all rows, i do not understand why it is not reading the last statment
(((and h.cust_id=3)))

Abed Al Rahman Hussien Balhawan 2-Mar-20 13:54pm View

hopefully i will become like you :) :D

Abed Al Rahman Hussien Balhawan 2-Mar-20 13:49pm View

yes exactly,i need more revision because its been 5 years since i graduated, and concerning your first query

UPDATE employee
SET employee.emp_salary = employee.emp_salary * 2.0
WHERE EXISTS (SELECT c.EMP_ID FROM customer c WHERE c.emp_id = employee.emp_id AND c.cust_id=4

i meant i forgot the last parentheses as shown above , a silly mistake i made.
yet again thank you for the help :)

Abed Al Rahman Hussien Balhawan 2-Mar-20 13:36pm View

to be honest with you i just tried it the same as u written it, but i forgot to close the parentheses. my mistake , much thanks !!!

Abed Al Rahman Hussien Balhawan 2-Mar-20 13:28pm View

i tried , i am still doing something wrong somewhere, can you show me how u do it ?

Abed Al Rahman Hussien Balhawan 2-Mar-20 13:19pm View

code not working :(

Abed Al Rahman Hussien Balhawan 2-Mar-20 13:15pm View

i am afraid not , only the employee who is working with cust_id=4 must be doubled
i tryed this
update employee
set emp_salary=emp_salary*2
from employee e
inner join customer c on c.emp_id=e.emp_id
having c.cust_id=4

Abed Al Rahman Hussien Balhawan 2-Mar-20 13:09pm View

The salary of employee dealing with customer having id=4 has been doubled

Abed Al Rahman Hussien Balhawan 2-Mar-20 13:03pm View

can you help me with this one ?

The salary of employee dealing with customer having id=4 has been doubled

i tried this:

update employee e
set e.emp_salary=e.emp_salary*2
from employee e
join customer c on c.emp_id=e.emp_id
having c.cust_id=4

Abed Al Rahman Hussien Balhawan 2-Mar-20 11:21am View

thank you for the help and clarification wish you all the best in your career. :)
i would rate you 10 star vote if possible.

Abed Al Rahman Hussien Balhawan 2-Mar-20 11:08am View

i tried this one before seeing your idea and it worked , would u accept it as a solution aswell ?

select c.cust_name, t.loan_number,l.amount,l.branch_name
from customer c
join take t on c.cust_id=t.cust_id
join loan l on l.loan_number=t.loan_number
where l.branch_name='Perryridge'

Abed Al Rahman Hussien Balhawan 1-Mar-20 22:29pm View

the first method was missing a C. before the cust_id

thank you for showing me two methods MadMyche i wish you all the best in your career.

can you explain to me where i was wrong and why?

Abed Al Rahman Hussien Balhawan 24-Feb-20 11:16am View

actually they are 62 question, i just need help with these 4

Abed Al Rahman Hussien Balhawan 24-Feb-20 10:26am View

ORA-01779: cannot modify a column which maps to a non key-preserved table

thank you for the help ill be checking the link you sent.

Abed Al Rahman Hussien Balhawan 24-Feb-20 10:02am View

ORA-00904: "EMP_SALARY": invalid identifier

2nd Method

ORA-00933: SQL command not properly ended

Abed Al Rahman Hussien Balhawan 24-Feb-20 9:59am View

ORA-00904: "EMP_SALARY": invalid identifier

2nd Method

ORA-00933: SQL command not properly ended

Abed Al Rahman Hussien Balhawan 24-Feb-20 9:53am View

customer table and employee table are connected by a one to many relationship
One Employee can have Many Customers, as an example of a banking system.
the code is not working, and i am sure i need a join between the two tables.

Abed Al Rahman Hussien Balhawan 24-Feb-20 9:41am View

yes i did a mistake by tagging mysql.

Abed Al Rahman Hussien Balhawan 24-Feb-20 9:33am View

an error message is showing: ORA-00971: missing SET keyword

Comments by Abed Al Rahman Hussien Balhawan (Top 38 by date)