Jump to content
The mkiv Supra Owners Club

SQL / ASPX problem


ozz

Recommended Posts

We have a small application on our internet that displays production to date figures. We have a stupid problem that the page template shows a value in koz but the live page shows Koz. We've looked through the SQL tables, VB scripts, JS scipts, HTML, ASPx and we cannot find the label!! We've lost vendor support so no help there.

 

The string overwriting the table is:

 

 

Anyone got any useful ideas where we can look? We've tried the stored procedures and text searches but cannot find this lblmonthtodate value. Its overwriting the 12.5koz value with say 400 Koz.

 

 

Help!!!! We're not developers as you may have guessed!

Link to comment
Share on other sites

Do you have the source code, you could step through the code in debug mode to check.

This Value (400) will be selected from the DB and the Code Behind.. The .vb (I assume as you mentioned VB Scripts, .CS for C-Sharp code) will be where the query is run and the value of the Label updated.

 

What is the issue? Is the Value wrong or is the suffix (Koz) wrong?

 

Also in your case what is Koz?

 

Paul.

Link to comment
Share on other sites

Its the suffix that is wrong, its coming through as Koz instead of koz (kilo ounces, refining output). The underlying SQL table only has the number stored, so we can only assume the lable includes Koz but we can't find it in an table or code.

Link to comment
Share on other sites

Its embedded within a web page, thats the only code I can find on the page that relates to it.

 

vAlign="top" noWrap borderColor="#008000" width="246">

vAlign="top" noWrap borderColor="#008000">

 

If I change the text associated with "Production year to date" then it changes on the live website. If I change "402.2 Koz then it makes no difference. I can't find where this label "lblYearToDate" is defined?!

Link to comment
Share on other sites

The more digging I do, the more I'm sure I'm missing a load of code. perhaps something to do with the webpage header:

 

 

I can't find this acintranet.aspx.vb page anywhere on my intranet server. Its somewhere, as the site works fine.

Link to comment
Share on other sites

I think I found the answer, but its not good. Apparantly codebehind means there should be a seperate.vb file with the code in, as i suspected, however its been compilled to a dll and at first glance there is no way to reverse engineer and we don't have the source code.

 

Thank you for input though, I'm not a developer and I've spent hours on this today when I should be getting audit information but it was bugging the hell out of me!

 

If anyone has a bright idea for reverse engineering a dll I'm all ears, but I think its a non-starter.

Link to comment
Share on other sites

  • 4 weeks later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. You might also be interested in our Guidelines, Privacy Policy and Terms of Use.