I'm interested in building a graphical timeline for a series of tasks that are stored in a SQL Server 2000 database. The tasks reside within a table. We also have a table to track the history and date of status changes. Some of the status flags are as follows:
1 - In Progress.
2 - Awaiting Info.
3 - On review server.
For each task, using ASP or ASP.Net, I would like to be able to display a graphical timeline for each task, with the status changes denoted for a given date range.
Does anyone have any ideas on the best approach for this task?
How to include pie graphs in a web page using ASP.net and VB.net code behind and MS SQL ...is there any special componenets or any other options rather than crystal reports.
I would want to create an asp page that can generate reports from raw datas coming from a database. I need the page to as well display a graphical representation of the reports like a Bar graph, line graph or even a pie graph. How can I do this?I really dont have an idea how am i going to make this possible? Do i need to install any active x control for html? or maybe export the graph from an MS excel?
I have the following piece of code:If RS.EOF or RS.BOF Then Session("Authenticated") = False
Response.Write "Sorry, your userid or password did not match" Response.Write "<BR>" Response.Write " or you have not registerd yet, please register" Response.Write <a href="default.asp">Clik here Response.End Here, I need to build the line (Response.Write <a href="default.asp">Clik here) dynamically, so that the html output from asp page gives us <a href="default.asp">Clik here
I have a situation where I have to update a single table with information from a bunch of fields. So I can explain better this is a sample table with some data... Code:
I am having trouble with structuring my query for searching using "LIKE". I return no records with my current SQL statement. Here is the string I am sending through ASP using VBScript as my language.
Other piece: strClass = Request("SiteLOCCode")
String from ASP page: "SELECT * FROM LDSWSNames WHERE WSName LIKE '" & strClass & "' "
Output string from ASP: SELECT * FROM LDSWSNames WHERE WSName LIKE 'KYLEXAD01'
I am creating a search page and need help writing the code to build the sql string.
I have 3 fields on the main page which a user can choose to enter search terms in any of the 3 fields. My question is how do I write the logic so it only includes the fields in the search criteria where the user has entered anything.
Fields are
Production No Production Title Synopsis
The user may enter any, all or some of the search teams in the fields.
On the search page I am using lots of if conditions to build my sql string like
strSQL = "Select * from Productions where "
now after where there are lots of permutations and combination like production no could be empty or it could be filled in and the other fields might be empty or filled in as well.
Does someone has a simple logic to build the correct sql String?
I'm about to start building a website which has a MS SQL back-end database. The host annoyingly won't allow me to connect to the database through Enterprise Manager, so he's advised that the database be created entirely though scripts.
I'm not particuarly good with T-SQL, so is there a tool I can use to generate the scripts from a database I have built? Can Enterprise Manager output the source code to build a database once it has been built? Could I set up and test the database on a different MS SQL server, then export the entire script and contents into a SQL query which could then be run through an ASP script to build the same database on a different server?
Basically I need to create a recruitment website whereby the recruitment company can post up new jobs and create new categories. On the home page it must display all the categories in boxes with each job that relates to that particular category displayed underneath it. For example: Code:
I'm trying to build a details page that is reachable when a user clicks on the ID of a query that's returned multiple rows of data. The first piece of code is the querytest.asp page, and the second is the details.asp page. However, how do I get the user_id passed to the details page? Code:
I need to build an UPDATE statement that copies the values of roughly 40 fields from a table that stores standard or default values into a table of specific contracts. There are 8 or so fields in the source table that are not in the destination table. The remaining field names are identical in both tables.
How do I create a recordset of the field names I am interested in so that I can loop through it to build my UPDATE statement?
I have spent the past several weeks building an ASP.NET 2.0 Application that has a Users.xml file where all user information is stored. I am now designing the administrator tools and want to be able to sort through the records in the XML file. Essentially, I want to be able to build this:
It seems that every example i hit is a sqlserver example and there doesn't seem to be very good sorting capabilities for XML. is this true? how do i acheive the above link? I would really appreciate any code examples or code links if you know/have them.
I want to build a website who handle 3 different countries (english, german, french). The changes between the countries is the text on the website. I know that i can put the text in a database to change it dynamic. But i wonder if i can do it on another way?
I seem to have a very good library for PHP, XML, Cold Fusion, Flash, JavaScript, and Java..but Im wanting to begin building some helpful references for ASP.net. I got one book called "Designing ASP.net Applications" from Microsoft, but it, sadly, wasnt very good for someone like me thats starting out.
Can we use this thread to possibly suggest good books on ASP.net, VB.net, C#, etc that have helped you, and perhaps others can benefit from it, as well as me?
Is it possible to build a pop up calender using dreamweaver? I have a text box where user need to type a date format. I want to a calender to display when the user double click on the text box so that the user can choose a date and then the date must be appear in the text box.
I've been following the building an FAQ tutorial and have uploaded all my files to the server but get a message saying the page cannot be displayed when I try to access it.
Can anyone tell me what obvious mistakes I might have made? I've checked the code over and over again but the only thing I'm not sure about is the connection to the database. How do I know the path to my database?
i want to build simple chat system for fun. but i dont know where should i start. i know asp and little JS , AJAX .
i think these are enough for that kind of target. actually most important question is where should i store messages? and how can i send incoming messages to users "AT THE SAME MOMENT" . i mean how can i make continuous connection or is it possible?
i'm trying to build a simple re-usable function which lets me connect to a database, using whatever parameters i pass through, and which i can then call from inside other functions in my page which use the data.
e.g. this is the kind of thing i'm trying so far, but at the moment it's throwing up an "Object required: 'rs'" error. Code:
I am currently putting together an eCommerce site. I have almost everything in place, but I am not happy with the category system for our products.
There are around 2500 products in a SQL Sever db, each assigned 1 of 300 odd categories. Currently, I have statically built the category tree but wish to automate this task as it is becoming increasingly difficult to manage.
I have googled plenty of info, specifically for ADO data shaping. Is this the right route to take, especially considering each branch of the category tree may differ in depth of categories? How exactly do other eCommerce sites automate this task?
I would also want to be able to copy the category system that provides links to previously selected categories i.e.
Category 1 > Sub Category 2 > Sub Category 3 > etc etc
Is this possible with the SHAPE command? Are there other methods of performing this task?
I am particularly concerned about the database taking a major performance hit from all of these SHAPE queries, which would be required on every category page. Could I use a stored procedure, and how much would it improve performance? Considering I will be hosting on a shared server, I want to make this as efficient as possible.
what is the correct way to dynamically build a call to a function in asp? i have the name of the function i want to call in a dictionary object, this works to execute the function but the output_value variable does not get set.
functionString = d.Item("create_contract_function_name") 'set variable for the create contract function name that was retrieved functionString = "output_value = " & functionString & "(param1, param2)"
. Operation Behind the Online Money Transaction. . If Once The client paid the money, . How is it validated..( Credit Card) . Also how Can the Admin of the Site will get the Money from the User.
Wondering about best practices as regarding database connections and usage (MS SQL). Was building a class to contain all of the methods and suddenly wondered if this was the best way? Using a sledgehammer to crack a walnut etc.... Code:
When you submit the form you can see I am trying to get the each row of the form elements into a format such that I can build multiple insert statements. Here is what I am working with:
<% Dim x For x = 1 to Request.Form.Count Response.Write Request.Form.Item(x) Next
Would I use some type of Mod operator on the value of x to determine my line breaks?
