Organization Chart Logic
We need to create an org chart from our employee data but struglling. We are using ASP with SQL Server 2000. Does anyone know of a commercial component or some sample code to help us get started?
Ideally a component will be great as we need to turn this around quite quickly and also the chart needs to be interactive so various nodes can be hidden or expanded by the user. Many of you have been in development and I am sure would have been asked to present the employee or similar hierarchical data in tree structure.
View Replies
ADVERTISEMENT
I am wondering if their are any links out their dealing with best practices when it comes to enterprise web site organization. We are still maintaining classic ASP applications so keeping that slant in mind would be great.
How do you all organize your code / presentation / modules / classes /images ect?
Does your web site file structure reflect any modulization in your code?
View Replies
View Related
May I want to know ASP or Javascript can generate a chart (pie chart) ?
or other method can do that?
View Replies
View Related
I have a recordset that returns company names, their are duplicates, sorted
by company name.
sCompanyName = ors("company")
How can I show only one company name from each company and display nothing for the next name if its the same in the previouse row,
COKE $2.14
$2.16
$2.16
PEPSI $3.13
$3.11
$3.12
FANTA $1.26
$1.26
View Replies
View Related
as i enter text in the textbox i want to narrow down there result in the box below that has all the listing of the products. i.e as i enter 'a' in textbox it will filter all products starting with 'a' then if i enter 'b' as second character it will show onlythose products that are starting with 'ab'... so how could i do that.
View Replies
View Related
I have an MySQL query that counts the number of clients that have been added in the last week.
strsql = "SELECT COUNT(visitorref) As no_visitors FROM visitors WHER datediff(curdate(),date(loa))<="&weekday(date())-1&" AND client_count IS NULL"
This works fine for Monday through Friday. But, I want to change the week etaphorically speaking! ) to run from Thursday to Wednesday, so on a Tuesday it'll show the count from last Thursday to the Tuesday.I'm gradually beginning to think I can't do it this easily anymore and just can't figure out what I want the datediff to equal.
View Replies
View Related
i ussually use www.domainname.com?uid=1111 .this one use request.quarystring right?so, what is the logic to change to www.domainname.com/1111
View Replies
View Related
i was building a internet based search engine and heard of fuzzy search algorithms.
Can anybody give fuzzy logic search algorithm for string search.
View Replies
View Related
Write an exe/dll (which will be better please tell me)..which has code to only control my logic or rather data conversion/manipulation of the raw data recieved thru and .mdb file and then display the exe/dll manipulated data thru an asp page.??
View Replies
View Related
I am working on this for someone: the user sees a list of chocolates which they can click on to add to a virtual chocolate box.
Each choc. is represented as an image of the choc - clicking on the image adds that choc. into a db. storing the product id of the selected choc. The user can select 8 chocolates. When the box is full, they can select no more chocolates.
I loop through the db. to display the number of chocs in the cart, like this: Code:
View Replies
View Related
Up until now I have mostly used a script that I got from somewhere way back for adding the page navigation on a results page ie.
<< 1 2 3 .. 4 5 6 >>
Ive decided to make my own but there seams to be too many cases/options in my script.I am using an array to store my results so if anyone knows a place where I can view a simple one or even some logic behind it.
View Replies
View Related
I've been looking at pure ASP solutions to uploading a file from a form, and I'm a bit confused just on the logic.Each solution I've seen includes a binary read of all of the POST data and a parse to find the file.
Why can't the request.form collection just be used to get the binary directly? I mean, even if the request.form collection reads an ASCII value, isn't ASCII just an interpretation of binary (so shouldn't we be able to simply write it to a file and be done with it)?
View Replies
View Related
I have created a dynamic form ,different under different conditions. The elements of the page are dynamically created with the required infor . coming from tables. Now, i have to store the values, states of all individual elements of the form, for future processing . The values are the part of a survey. I hav to analyse the values and create a report.
Now , i m getting confused in the way , the values of all dynamic fields to be stored. I m not getting a good way to store the values and later process for survey analysis.
View Replies
View Related
i am having a hard time finding out whats wrong i get the users login name from the first page and then i have this page which displays the abstracts
whats happening now is if the user has 9 abstracts assigned to him he sees 5 abstracts on the page and then there is page navigation so he sees the number 2 when i click on number 2 i should see the rest 4 abstracts but i cant see anything it doesnt give an error can anyone tell me whats wrong Code:
View Replies
View Related
I am using access with sch_time_start,end,start_time,end as text fields not as Date/time....I am getting wrong amount of record...Example:
If db has 6 records like start_time and end_time = 12:00 AM- 05:15 AM,
and person has sch_time_start and sch_time_end = 12:15 AM-05:12 AM.....I am missing smth...maybe logic is wrong.. Code:
View Replies
View Related
Something is not right when I generate the results for assigning drivers to routes...My [ response.Write(rs5.recordcount & " " & rs5("Tot") & " " & rs1("Full_Part") & "<br>") ]
The rs5("Tot") is always zero when the recordcount is 1...with rs5 I am trying to control not to assing more than 42 hours for full timers and 22 hours for part-time drivers per week.... What is wrong with the logic ?
View Replies
View Related
I'm trying to put the 4 latest(by publication date) articles published in my press table on the front page of my site. What's the logic here:
Show only the 4 latest articles
and if there is no addition to the article db:
Show latest articles for 1 month.
View Replies
View Related
I had downloaded your bar chart. Is it possible to read the values from the database?? If possible, how??
View Replies
View Related
Ineed to create a something like a horizontal bar chart connected to a db. this is all very new for me, Can some one please suggest something....
View Replies
View Related
I'm trying to develop some graphs for my site and hoped this would be a solution.
I have one question really. We've installed the MS Office 2003 components on our webserver -2003- but i seem unable to create a reference to it in the code i.e.
dim owc
set owc = createObject("owc.chart")
It comes back with an error which doesn't seem to make sense as the component is registered on the server, does anyone know what might be causing this?
Code:
View Replies
View Related
I ve created a table of information and now i need to make a number of pie charts from this table.
Ive attatched an image of the table, to make it easier for you to know what i mean. a pie chart i want to make for example is, say, the number of red,yellow and green projects in Fixed Income, ie 14 red, 4 yellow and 4 green.
View Replies
View Related
how I can do this pulling from a Microsoft Access database?
View Replies
View Related
I have been making a dynamic chart in ASP, and it's working fine so far. However there's only one thing that is not working. The color of Plotarea!
I don't know how to define the color of plotarea. I tried to specify the color of Plotarea as below but it didn't work.
set oChart = Server.CreateObject("OWC.Chart")
set objChart = oChart.Charts.Add()
objChart.PlotArea.Interior.Color ="#FFFFFF"
View Replies
View Related
what the best way to produce radar charts from asp would be? I know that I will probably need to install a component on the server. Any comments on what the best / cheapest one would be?
View Replies
View Related
I've heard conflicting stories on the ability of Office Web Components to access a data source that resides on the internet (as opposed to the intranet). Some say you can, some say you cannot. I can get the owc chart to connect to my database on IIS but I would like to publish this on my webpage.I'd like to insert a chart on a page which I like to use data from an Access database on my webpage. How do I get that chart to link to a data source on my website? I use the following line to connect to my database normally:
Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("amsydb est.mdb"))
But where do I insert this in the data connection section so I can get my OWC chart to connect to this database?
View Replies
View Related
I have a problem,i create an excel chart by using the asp, but due to my selected database is quite large until the chart shows the data in a messy way and it is too tight even the name for the unit also cannot see.
is any way to seperate it ? i mean show it in another way for eg show it for 10 data in a page and can click on a "next" to link another page , or create another drop down list to select for how many data to show in a page? and may i know how to write that ??
thank you very much
another question is , once created the chart , how to view it like a pic in a part of IE just like the stock market value?for your information, i connected to database and created the excel chart , and just link to show it in IE for whole.
View Replies
View Related
i have a problem,i create an excel chart by using the asp, but due to my selected database is quite large until the chart shows the data in a messy way and it is too tight even the name for the unit also cannot see.
is any way to seperate it ? i mean show it in another way for eg show it for 10 data in a page and can click on a "next" to link another page , or create another drop down list to select for how many data to show in a page? and may i know how to write that ??
another question is , once created the chart , how to view it like a pic in a part of IE just like the stock market value?for your information, i connected to database and created the excel chart , and just link to show it in IE for whole.
View Replies
View Related
I prepare a owc chart in asp.
in category axis (x-axis) i want to adjust date format according to date range, For Example: if data is of 5 years then tick lables show Years as below
Large data : 2005,2006
Medium : Jan, Feb
Samll : Mon, Tue
I've tried by NumberFormat property
Chartspace.Charts(0).Axes(0).NumberFormat = "dd,mm,yy"
but it is not working.
can it be done through ASP or via SQL statement. if SQL then how
View Replies
View Related
Can someone provide me sample codes to plot line chart.
View Replies
View Related
I have been asked that every user in the site should have a chart that shows individual calories, fat, carbs of items that the user selects in any restaurant so And the user would be able to plan how those items would effect their diet plan.
Also the charts and graphs will be for Weekly Progress Chart , as the site is for diet progress for the users.If anyone knows how this can be done,please help as i am stuck here and i am a newbie to ASP.
View Replies
View Related
is there any component available for creating Organisation Chart. I hope, I don't have to write code for creating boxes & lines for creating this Org Chart.
View Replies
View Related
I have made a page to display a chart based on data from my SQL-server. I have used Office Web-component graph. Here I can set the correct SQL statement and the graph works fine.
Now I want the user to be able to input the WHERE part of the sql sentence. Can anyone point me to info or code on the web to do this ?
View Replies
View Related
I create an excel chart by using the asp, but due to my selected database is quite large until the chart shows the data in a messy way and it is too tight even the name for the unit also cannot see.
Is any way to seperate it? i mean show it in another way for eg show it for 10 data in a page and can click on a "next" to link another page, or create another drop down list to select for how many data to show in a page? and how to write that ?
View Replies
View Related
