|
I'm creating a contract database that has over 80 different calculations and formulas. I'm using one table with fields and one query for formulas. I need to run/update query through the browser. Does anyone have any idea how this should be done? I'm using this SQL statement in the query, maybe there is a better SQL statement I can use to automatically update my fields in the table? Please help!
I appreciate any help from you guys.
|
|
|
|
|
I am working on a web form project where I need to upload files to a server. The first part in this process is to select the files from the users local machine. My question is how do I open a file dialog box from a web form. Can I even do this? Thanks in advance for any help you can give...
Eric
|
|
|
|
|
By your mention of WebForms I will assume that you're using .NET.
From memory there isn't an ASPX server control, but, you should be using a file element in your client side form:
<INPUT id="somefile" type="file">
This will automatically show a textbox for the URI and a browse button, which is automatically linked up to an open dialog.
When the form is submitted you will receive the contents of the file in, either the querystring (if you use GET) or in the headers section of the request (if you use POST). Either way, if you call Request("somefile") you should be able to get the contents of the file.
If you are using a more complex WebForm you may want to write your own ASPX server control wrapper for the <INPUT type="file"> element.
Tatham Oddie (VB.NET/C#/ASP.NET/VB6/ASP/JavaScript)
tatham@e-oddie.com
+61 414 275 989
|
|
|
|
|
|
As you know, there are many restrictions in an ASP page.
For that reason, I need to know how to perform some operations by another application on server.
I am looking forward any ideas.
|
|
|
|
|
There is the easy way and the (not so) hard way:
1. The easy way: go for ASP.NET
2. The (not so) hard way: use a COM component.
I see dumb people
|
|
|
|
|
I intend to use COM as a resolution but I wonder if we can use that COM to invoke an Automation such as Excel Automation inside its code ?
I have had problems in invoking Excel Automation directly inside ASP page.
Help me if you can !!!
|
|
|
|
|
as long as excel is installed on the server which will run the COM component, then you shouldn't have any trouble automating excel.
if you need any samples then let me know and i'll give you some simple demos.
|
|
|
|
|
I want to count the number of records.... and display it in my web-page using my ASp page. I know that the "Select count(*) from table" will give the count in the database - MS Access.
How can I retrive the 'result' from that query and pass it on to my ASP page??
Any help?
I was born intelligent
Education ruined me!.
|
|
|
|
|
Take the value of the first field from returned recordset, like this:
rs.Open "SELECT Count(*) FROM Table", con
intCount = CLng(rs(0))
,assuming that "rs" is an ADO recordset and "con" is ADO Connection
Philip Patrick
Web-site: www.stpworks.com
"Two beer or not two beer?" Shakesbeer
|
|
|
|
|
You could also give an alias to the item you are returning (along with just about anything in your query), for example:
SELECT COUNT(*) AS THECOUNT FROM TABLE
Then you could do:
Dim count : count = rs("THECOUNT")
Just another option ...
|
|
|
|
|
Hi everyone,
I cannot find answer to the mentioned problem. I created an inform band, but like to prove the user with less mysterious way to show the band than seeking 'View/Toolbar' or 'View/Explorer band' (sorry for mistakes - menu names translated from polish IE version). So I added the toolbar button and it works perfectly (btw: does anybody know how to reset the IE toolbar, so the new placed button will always be visible?). Me current goal is to place menu item in 'Tools' menu. Everything works fine, till I tried to show the band. Following the MSDN - seems that only toolbar button can show band (lack of 'BandCLSID' in menu item registration). As a workaround I implemented IOleCommandTarget, but I don't know how to simulate pressing of button, that will show my band.
Any help will be appreciated.
Merry Christmas to everyone 
Best regards
/Bart
|
|
|
|
|
hi all,
i got an interview within a week
i have no prior knowledge of scripting
i need a book with got basic on
scripting in windows,ASP
|
|
|
|
|
|
I'd look for "Beginning Active Server Pages 3.0" from Wrox Press. Most of the examples use VBScript, unfortunately, but then so does most of MSDN. It's a great introduction, and goes well beyond the usual Beginner level in content. It also happens to be very well written, unusual for programming books.
"How many times do I have to flush before you go away?" - Megan Forbes, on Management (12/5/2002)
|
|
|
|
|
hi all,
i got an interview within a week
i have no prior knowledge of scripting
i need a book with got basic on
scripting in windows,ASP
|
|
|
|
|
Hello,
I am taking a Fundamentals of JAVA from CISCO. The course is designed such that at the end of the course students are to submit a project called "JBank" code.
Is there anyone who took this course and has a working JBank codes? I am having some trouble writing it. I seem to be the type of a person who is good at twicking/modifying the existing codes.
I would really appreciate the help.
thanks,
|
|
|
|
|
|
I am taking the course not to become a programmer, just to learn the theory and understand the concept of OO.
However the project has to be handed in in order to have a passing grade.
Well, if anyone thinks he/she could help me on this matter that would be really appreciated.
thanks,
|
|
|
|
|
Anonymous wrote:
just to learn the theory and understand the concept of OO.
Oh, I see, so you are not after a passing grade.
Anonymous wrote:
However the project has to be handed in in order to have a passing grade.
So you do not need to deliver the project, right?
I see dumb people
|
|
|
|
|
lol, good reply
todo....
:: insert inpirational text here ::
|
|
|
|
|
I am currently running on a server that does not support ASP. What are my programming options if i want to do form extraction, eg. user registration, things of that sort without ASP. I am really lost with all the different cgi, php and everything else that is out there. I can't seem to understand if they all do the same thing just in a different language (like basic and c++) or they are for different uses. That's why I think that I need to get my hands on some books that explain these things more in detail. For now though, in your opinion which would be the best language (easy and versatile) to have access to forms, hit counters, search engines, etc. Otherwise, can someone tell me some affordable servers around $8/month or so which support ASP? Thanks.
|
|
|
|
|
Although ASP makes form handling simple, it isn't necessary. Javascript is one good tool for writing client side scripts to create and send form data, and for composing server scripts for extracting the information. One decent hosting service that supports ASP is Readyhosting.com[^]. At $99/ year they're quite affordable, and the services they provide are very good, including 500MB space, unlimited email addresses, unmetered data transfer, and unlimited databases. After you host you first site, all future sites are 1/2 price though you can bill your customers full rate. Also, if you use them to register a domain for a customer they renew it at no charge for as long as the site is hosted with them.
"How many times do I have to flush before you go away?" - Megan Forbes, on Management (12/5/2002)
|
|
|
|
|
All server-side scripting methods do the same thing in different languages. All of them make the form data available, but the syntax is different.
|
|
|
|
|
Check out www.ucvhost.com[^]. You can get a domain for USD$10 and then basic ASP hosting for USD$1/month with unlimited pop3 etc.
I've had a reasonable experience but make sure you double check some things like your DNS setup (www.dnsreport.com). They're a bit scabby in some areas but you've just got to tell them and they'll fix it.
Tatham Oddie (VB.NET/C#/ASP.NET/VB6/ASP/JavaScript)
tatham@e-oddie.com
+61 414 275 989
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
