Web Development

9-Sep-07 21:42

Hi,

I am working on an ASP application with oracle as backend. my application was residing on windows 2000 server previously and everything was working fine then we moved our application from windows 2000 to windows 2003 server. now application is giving me few problems and one of them is a strange problem.

First i am sending some data to a procedure in the backend from my asp page and then trying to get the result returned by the procedure.

when i send the data from frontend procedure returns error message but when with the same data i directly test the procedure at backend then it gives the perfect result. I have tested the data going from frontend its going perfectly. the query at the front end if i run as it is copy paste at backend gives me the right result.

The connection string and database i am using in frontend is perfect..iam pasting the function which is calling the procedure and not giving me the desried result coming from the database.

--------------------------------------------------------------------------------------
CODE:
--------------------------------------------------------------------------------------
'Function to check if the combination of Cost Centre,
'Nominal Account is valid for a particular user
function isValidChargeAC(staffnr,cc,nom,subnom,akey)
dim strSql,rs
costcentre=trim(cc)
on error resume next
isValidChargeAC="Error: Validation could not be performed."
strSql = "Select XX_EGPO_SRO_REQ_PKG.Req_Validate('" & cstr(staffnr) & "','" & cstr(costcentre) & "','" & cstr(nom) & "','" & cstr(subnom) & "','" & cstr(akey) & "') From Dual"
Set rs=Server.CreateObject("ADODB.Recordset")
rs.Open strSql,con1,1,3

if err.number=0 then
if not rs.eof and not rs.bof then
isValidChargeAC=rs.fields(0) NOT GIVING ME DESIRED VALUE COMING FROM DATABASE
end if
end if

end function
--------------------------------------------------------------------------------------

KINDLY HELP,

THANK YOU.

AZEEM QAISER

Re: Strange Problem

Guffa9-Sep-07 23:52

9-Sep-07 23:52

Azi Qaiser wrote:
when i send the data from frontend procedure returns error message

What error message?

Azi Qaiser wrote:
NOT GIVING ME DESIRED VALUE COMING FROM DATABASE

In what way does the value differ from the value that you desire?

---
single minded; short sighted; long gone;

Re: Strange Problem

Azi Qaiser10-Sep-07 16:51

10-Sep-07 16:51

The error message is a custom error message written by myself ... my desried result which should come from the database is "Y" but i am getting "custom error message".

at the backend when i check the procedure it gives my "Y" that the validation is passed but when i try from front end it send custom error message which means validation fails. values i am sending while calling the procedure are prefect in terms of datatype and sequence.

Re: Strange Problem

Guffa11-Sep-07 2:25

11-Sep-07 2:25

Then you have to make a better custom error message. The one you have only tells you that the value is not the expected one, but it doesn't tell you what the problem is or what the actual value is.

---
single minded; short sighted; long gone;

URGENT HELP

Azi Qaiser11-Sep-07 16:47

11-Sep-07 16:47

Guffa

i think the problem is not with the code, the problem is with IIS since previously the application was hosted on Windows 2000 server/IIS 5.0/oracle9i client and since the application has been moved to windows 2003 server/IIS 6.0/Oracle 10g client.

I think the problem is IIS, it might be a possibility that the code has been dealt in diffrent way coz the same application is working perfectly fine on the previous configuration.

kindly look into this aspect and advice.

thanks.

Azeem Qaiser

Re: URGENT HELP

Guffa11-Sep-07 21:42

11-Sep-07 21:42

Regardless of where the source of the problem is, your code has to produce a better error message for you to be able to find the problem. If you don't know anything about why you get an error message, you have very small chances of finding the source of the error.

Azi Qaiser wrote:
I think the problem is IIS, it might be a possibility that the code has been dealt in diffrent way coz the same application is working perfectly fine on the previous configuration.

The fact that an application works without a problem doesn't guarantee that the code is correct. I have seen examples of code that has been used for years without producing errors, but stopped working because of a minor change in the environment, because the code was wrong from the beginning.

---
single minded; short sighted; long gone;

Re: URGENT HELP

Azi Qaiser12-Sep-07 18:34

12-Sep-07 18:34

thanks for your reply guffa..u were right i found the error after implementing proper error reporting module.

thanks.

a small request can u please send me a code block for calling the below mentioned stored procedure which is returning ref cursor.

PROCEDURE get_fin_approvers(p_user_id IN VARCHAR2,
p_ccc IN VARCHAR2,
o_cursor1 OUT NOCOPY REF_CURSOR)
AS

v_ccc VARCHAR2(100);
v_grade VARCHAR2(10);

BEGIN

select hou.attribute1 into v_ccc from apps.hr_all_organization_unitS hou,
apps.pay_cost_allocation_keyflex pcaf
where pcaf.COST_ALLOCATION_KEYFLEX_ID = hou.COST_ALLOCATION_KEYFLEX_ID
and pcaf.segment2 = p_ccc;

select grade into v_grade from hrr_t_emp_master
where staffnr = p_user_id and term_date is null;

ekg_lp_gen.get_approvers(p_user_id => p_user_id,
p_ccc => v_ccc,
p_grade => substr(v_grade,4),
o_cursor => o_cursor1 );

END get_fin_approvers;

thanks,

azeem

Re: URGENT HELP

Guffa12-Sep-07 22:44

Placing flowplayer.swf in different folder than flv files folder [modified]

12-Sep-07 22:44

Azi Qaiser wrote:
a small request can u please send me a code block for calling the below mentioned stored procedure which is returning ref cursor.

No, I can't, at least not without doing an unreasonable amount of research. I've never called an Oracle stored procedure, and I don't know whan a ref cursor is...

---
single minded; short sighted; long gone;

harryforum9-Sep-07 20:45

harryforum

9-Sep-07 20:45

hi,

I've a query that how can we place flowplayer.swf file in a different folder than where the flv files are placed.

I'm using this code:
<object id="FlowPlayer" type="application/x-shockwave-flash" data="FlowPlayer.swf"width="320" height="263" align="top">
<param name="movie" value="FlowPlayer.swf" />
<param name="quality" value="high" />
<param name="scale" value="noScale" />
<param name="wmode" value="transparent" />
<param name="flashvars" value="config={baseURL:'images/flv/' videoFile:'ad.flv' }" />

</object>

But it is not working. so can any body Pls. tell me how to do it?
Flowplayer.swf file is placed at root of the application.
ad.flv file is placed in the flv folder(flv folder is inside the images folder, and images folder is placed at the root of the application)

When i place ad.flv file at the rot of the application then flowplayer displayes the file but when ad.flv is placed in the imegs/flv folder then flowlayer doesn't lay that file.

It really urgent.................

I'm doing all this using c#.net2.0

Thanks,
Harry

-- modified at 2:55 Monday 10th September, 2007

media clips o0n web page

raj4ranjit9-Sep-07 20:24

raj4ranjit

9-Sep-07 20:24

Is it possible to play media clips on a web page by just clicking on a link without taking much time? if , then how? Please help me in this regard.

Warm Regards,
Raj

XMLHTTPRequest in FF [modified]

JimmyRopes9-Sep-07 8:48

9-Sep-07 8:48

I have an AJAX script that dynamically updates a database and returns some value to be used to update a control on an HTML page.

It works fine in IE (ActiveX) and Opera (native XMLHTTPRequest) but not in FF. I can see the database being updated so I know that the server side script (php) is executing even from FF but I do not get any request state posted to the assigned Req.onreadystatechange() handler.

I put an alert in the state change handler to see the states being returned and see them on IE and Opera but do not see any activity on FF. The database is updated so I know the request is firing but just not getting a return on FF.

Does anyone know why this is happening?

-- modified at 17:37 Sunday 9th September, 2007

I installed Firebug as suggested and now I am really confused.

According to Firebug the transaction is executing properly and I am receiving the proper response.

There are no errors apparent (I am not quite sure what I am looking for) and the transaction returns the expected data. I tried a few different posts and each returned the proper data for the parms I passed.

The only problem is that I never receive a state change in the assigned state change handler so I don't know when the transaction completes.

At least I now know the transaction is completing properly.

Would anyone have any insight into why the state change handler is not getting signaled on FF when it is getting signaled on IE and Opera? Confused | :confused:

I am using the following code. It would be greatly appreciated if anyone can spot where I am going wrong.

<br />
var HTTPREQUEST_UNINITIALIZED = 0;<br />
var HTTPREQUEST_LOADING       = 1;<br />
var HTTPREQUEST_LOADED        = 2;<br />
var HTTPREQUEST_INTERACTIVE   = 3;<br />
var HTTPREQUEST_COMPLETED     = 4;<br />
var HTTPREQUEST_SUCCESS       = 200;<br />
<br />
  //-----------------------------------------------------------------------------<br />
  // Define and initialize an HttpRequest object for posting data.<br />
  //-----------------------------------------------------------------------------<br />
   Request = new getXMLHttpRequest();<br />
   Request.onreadystatechange = StateChangeHandler;<br />
   var data = '';<br />
   <br />
  Request.abort();<br />
	var path = "<?php echo $_ENV['SCRIPT_URI']; ?>";<br />
	path = path.substring(0, path.lastIndexOf('/') + 1) + "getHood.php";<br />
  Request.open("post", path, true);<br />
  Request.setRequestHeader("Content-Type", "application/x-www-form-urlencoded;");<br />
  data = "City=" + city<br />
  + "&State=" + state;<br />
  Request.send(data);<br />
} // function getHood()<br />
<br />
function StateChangeHandler(){<br />
//alert('StateChangeHandler()'+ ' ' + Request.readyState);<br />
 if (HTTPREQUEST_COMPLETED == Request.readyState){<br />
   if (HTTPREQUEST_SUCCESS == Request.status){<br />
~~~~~~~~~~~~~~ Code here to handle the response ~~~~~~~~~~~~~~~~~~~~~~~<br />
   }	// if (HTTPREQUEST_SUCCESS == Request.status)<br />
   else{<br />
      alert("Error: HTTP "<br />
       + Request.status<br />
       + " "<br />
       + Request.statusText<br />
       + " Please contact our WebMaster from the link on our Contact Us page explaining the error you received.  Thank you.");<br />
   }	// else [if (HTTPREQUEST_SUCCESS == Request.status)]<br />
 }	// if (HTTPREQUEST_COMPLETED == Request.readyState)<br />
}	// function StateChangeHandler()<br />
<br />

Simply Elegant Designs JimmyRopes Designs
Think inside the box! ProActive Secure Systems

I'm on-line therefore I am.
JimmyRopes

Christian Graus9-Sep-07 9:38

Christian Graus

9-Sep-07 9:38

I don't know, but download Firebug for Firefox. It's an add-in that gives you javascript debugging in FF, it's invaluable.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

JimmyRopes9-Sep-07 11:03

9-Sep-07 11:03

Thanks for the reply Christian.

I am trying to find a download site suitable for windows but have not been able to so far.

I remember having firebug installed on a previous system so I know there are such places. Do you know where I can download firebug for installation on a windows platform?

Simply Elegant Designs JimmyRopes Designs
Think inside the box! ProActive Secure Systems

I'm on-line therefore I am.
JimmyRopes

Ed.Poore9-Sep-07 11:14

Ed.Poore

9-Sep-07 11:14

GetFireBug.com[^]

JimmyRopes9-Sep-07 11:36

9-Sep-07 11:36

Thanks Ed. I installed it and now I am really confused.

According to Firebug the transaction is executing properly and I am receiving the proper response.

There are no errors apparent (I am not quite sure what I am looking for) and the transaction returns the expected data. I tried a few different posts and each returned the proper data for the parms I passed.

The only problem is that I never receive a state change in the assigned state change handler so I don't know when the transaction completes.

Thanks for pointing me to the firebug site. At least now I know the transaction is completing properly.

Would you have any insight into why the state change handler is not getting signaled? Confused | :confused:

Simply Elegant Designs JimmyRopes Designs
Think inside the box! ProActive Secure Systems

I'm on-line therefore I am.
JimmyRopes

Ed.Poore9-Sep-07 11:42

Ed.Poore

9-Sep-07 11:42

JimmyRopes wrote:
Would you have any insight into why the state change handler is not getting signaled?

Without seeing the code involved the only thing I can think of (I'm by no means a JS / Web guru) would be have you spelt the handler wrong? I know, I know, but I've been bitten by this before.

JimmyRopes9-Sep-07 11:57

9-Sep-07 11:57

Ed.Poore wrote:
have you spelt the handler wrong

If I did it wouldn't work in IE and Opera. I am not saying that I am above doing something like this but unless I unknowingly have the clairvoyant versions of IE and Opera I would expect them to choke also.

Here is the code. Let me know if you can spot anything.

<br />
var HTTPREQUEST_UNINITIALIZED = 0;<br />
var HTTPREQUEST_LOADING       = 1;<br />
var HTTPREQUEST_LOADED        = 2;<br />
var HTTPREQUEST_INTERACTIVE   = 3;<br />
var HTTPREQUEST_COMPLETED     = 4;<br />
var HTTPREQUEST_SUCCESS       = 200;<br />
<br />
  //-----------------------------------------------------------------------------<br />
  // Define and initialize an HttpRequest object for posting data.<br />
  //-----------------------------------------------------------------------------<br />
   Request = new getXMLHttpRequest();<br />
   Request.onreadystatechange = StateChangeHandler;<br />
   var data = '';<br />
   <br />
  Request.abort();<br />
	var path = "<?php echo $_ENV['SCRIPT_URI']; ?>";<br />
	path = path.substring(0, path.lastIndexOf('/') + 1) + "getHood.php";<br />
  Request.open("post", path, true);<br />
  Request.setRequestHeader("Content-Type", "application/x-www-form-urlencoded;");<br />
  data = "City=" + city<br />
  + "&State=" + state;<br />
  Request.send(data);<br />
} // function getHood()<br />
<br />
function StateChangeHandler(){<br />
//alert('StateChangeHandler()'+ ' ' + Request.readyState);<br />
 if (HTTPREQUEST_COMPLETED == Request.readyState){<br />
   if (HTTPREQUEST_SUCCESS == Request.status){<br />
~~~~~~~~~~~~~~ Code here to handle the response ~~~~~~~~~~~~~~~~~~~~~~~<br />
   }	// if (HTTPREQUEST_SUCCESS == Request.status)<br />
   else{<br />
      alert("Error: HTTP "<br />
       + Request.status<br />
       + " "<br />
       + Request.statusText<br />
       + " Please contact our WebMaster from the link on our Contact Us page explaining the error you received.  Thank you.");<br />
   }	// else [if (HTTPREQUEST_SUCCESS == Request.status)]<br />
 }	// if (HTTPREQUEST_COMPLETED == Request.readyState)<br />
}	// function StateChangeHandler()<br />
<br />

Simply Elegant Designs JimmyRopes Designs
Think inside the box! ProActive Secure Systems

I'm on-line therefore I am.
JimmyRopes

Ed.Poore9-Sep-07 13:44

Ed.Poore

9-Sep-07 13:44

Sorry, I couldn't see anything of note.

JimmyRopes9-Sep-07 18:51