I have generated Bar, Line and Pie charts using the MSOWC.DLL and its fantastic.
The ONLY problem I have encountered is when generating Pie charts it shows the quntities of each piece inside the Pie chart and its very hard to read. But in Excel it shows outside the Pie chart. So, I want to find out a solution for this.
first, say I have a payment processing scheme, and after a value is returned letting the program know that a sucessful payment is made, that somehow I dynamically create a GUID, (or something of the like). I want to have it somehow embedded in the program as well as well as sent to the buyer so that he can enter in that GUID and it unlocks the program.
So somehow I want to generate a GUID, either inside the program or outside of it which either way is incorperated into the program, and so that I have a copy of it. I want this all to be able to be done dynamically and I assume it would have to be done in ASP.NET as it doesen't seem feasable to run a .exe program on the web.
Any leads? Or perhaps there is some sort of "shell" that I can embed my program in that will do this for me. Any ideas?
I am using dreamweaver MX to connect to a microsoft database with the typical data stored such as name, address etc. I gt this information to displlay via recordsets and thats all good.
BUt im having trouble exporting the data from the database inot an XML document. I know I can do it on Acces itself but i want to be able to generate it using ASP. How do I do this?
I tried to display an error detail on my webpage when I got an "HTTP 500 Internal Server Error" of my .asp page, but I was failed I did setup in IIS so it will display debug error on my asp page as well as setting up my browser internet option.
Can you help me how to set it up so I am able to see the error detail on my browser when I get "HTTP 500 Internal Server Error" ( Currently, I just got a blank page with "HTTP 500 Internal Server Error" in the web page title)I run IIS 5.0 and window professional xp browser.
below is my code, i recieve error 500 in the browser, dont know what when wrong. it happen after i delete the Msacees table, and build a new one. Code:
I'm setting up a simple competition entry system in ASP where users can enter their name and email address to be added into a prize draw. It's pretty simple stuff, with the data being added into an Access DB table.I've created an index on the 'email' field to stop the same person entering more than once (unless they have more than one address, but let's pretend that's never the case ).Instead of doing a SELECT query to find whether they've entered before, I simply want to attempt to INSERT the data into the table, and if it returns an error along the lines of "no duplicate values in the index" it would give the user an error.My question is, is it possible to display a user-friendly version of the standard ugly ASP generated error message when this error is detected? Or am I stuck with the incredibly unattractive error message we're used to?
How can I return an error code from a sql server stored procedure and use it in my asp page to generate an alert indicating that some error has ocurred?
I am trying to set up a staff update page for a local school and have set up a database to record it. I know the database works because I can populate it and display the content. When I went to write the insert statement I get an error that i am unsure how to solve. This is the statement. Code:
In Kevin Yank's book, he shows how to put in error checking at various stages of working with a database: connecting, querying, etc. I presume the same general principles apply to ASP/SQLServer but I don't know the code. Can someone tell me at what stages I should be checking for errors and some generic code that I could use at each stage?
if ((form1.Decline.value=='') && (form1.OfficeStatus == "YES") & (form1.FloorBldgDiscStat.value=='')) { alert('Enter value on floorbldgstat') return (false); }
This validation does not work when i try to update my asp page i should prompt the alert msg. My OfficeStatus field is a dropdown with value of "YES" and "NO". What i should i use to get the value "YES" i javascript. Single equal sign(=) or double equal sign (==), and anothe one is what should i use in enclosing the "YES" value. '' or "".
<% Function CstrN(str) If IsNull(str) Then CstrN = "" Else CstrN = Cstr(str) End If End Function %> chkboxvalue = CstrN(RS("field1")) & CstrN(RS("field2"))
Error message: Microsoft VBScript runtime error '800a000d' Type mismatch
This error number usually generates when there is spelling or any mismatch variables, etc. I checked and I couldn't find any error. Then, is it the syntax?
The following code has run-time error on "divide by 0" error. I expect "do the work<br>" will not print in the browser, since it happen after the code that cause the error. However, this is the output: any ideas why?? Or this is the nature of ASP scripting language that is being executed in sequential order? Code:
after reinstalling Windows XP (incl. IIS) it is not possible to create new webs on the local IIS in the likeweise reinstalled Visual Interdev 6.0.
After typing in the name of the desired webserver (machine name or localhost) the following error comes up: "Method not allowed(Error code = 80070005)". It is however possible to create webs with Interdev on other webservers in our network.
The employees who use it are not allowed access to the server it's requried to sit on which means that my username and password have to be included in the logon.asp page which I HATE! So when this fails, it publishes my usernanme and password on the screen for the user to see...brilliant!
Since nobody is willing to create a dummy account is there a way that I can keep that line of code from displaying if in error? I've added the code to this thread...
I wanted to know that is there someway in ASP that I can generate images on-the-fly without using ne 3rd party component?? Like its possible in CGI-Perl to generate ne type of image on-the-fly, is there a way 2 that in ASP? OK, if the 3rd party components r the only way, then r there ne free ones available?
I need to generate some reports with graphical charts (line, pie, bar and polar). I want to generate those charts which represent database values. Hope I have to use a 3rd party control for this.
I've been surfing the web and this forum for methods to upload images through a form in a browser. I've come up with a few results, e.g. Dundas free upload component.
Besides that I've got the free product from ServerObjects.com to check the ImageSize and found some other non-component method to check the Image dimensions at: LearnASP.com.
Users should be enabled to upload a thumb for their profile. Since I can't expect each user to be a computer literate they might upload an image which is a bit too big. Are their free methods with ASP to reduce those images in size? I'm simply using ASP here with IIS. For now I can only give them an error stating that their image is too big.
A second matter might be a photogallery where there's bigger images and thumbnails. Right now I'm using Irfanview/Ifranview to quickly make thumbs for each regular image. Like with the example above it would be ideal if this can be automized as well, since users should be enabled to put up some small photogallery as well.
I know there's some fancy expensive methods to achieve this, but usually they offer loads more and all I need is something to crop or resize (resizing is best).
I'm looking for a code or a component that will enable me to generate images on the fly, through my ASP code. For example: Retrieve some textual data from a database and make an image out of it. OR Combine text and an existing image into one new image. OR Read an HTML file that contains text and image and generate an image from it. I've found programs that do it (like ABC Amber Text2Image Converter), but I fail to make it work through a code and not through a software console.
I have been asked to produce reports which will be triggered and generated automatically via scheduled tasks against data in SQL SERVER. The reports will be generated as CSV's to provide compatibility with Excel. The reports will then e-mailed as attatchments to an agreed list of recipients. This all has to be done with the use of ASP and SQL Server. Can anyone advise on how the prolem should be approached?
I'm generating excel spreadsheets online with many manufacturers. One particular manufacturer has 5000 more records than the next highest. When I query for that manuf the table does not form. Just plain text. It doesn't time out. Just doesn't form properly.
Is there a cache or setting I need to increase to get this much data?
Does anyone know of any freely usable code that helps automate the process of generating RTF files from ASP (particularly generating the code needed for tables)?
Basically I have a site where the administrator adds new students to a college system. This code just adds a new student to the database. When they are added a username is generated by taking the first letter of the forename and the first from the surname and joining them to the date.
(ie, James Brown would generate JB2005) Obviously some people will have the same initials so i'm trying to get all the records from the student table in my database that has the first two letters as the student I'm trying to add and adding the value of the count of that recordset before the date of the new students initials. (ie, if Jane Bennett was added the username would be JB12005 because there is already a user with the initials JB in the database)
At the moment if i add a new member to the database, the fields are populated but the count of the recordset is not added so I end up with duplicate usernames. I'm not sure if the recordset is even being filled or whether the recordcount is not working. Code: