Doubt limiting user size upload

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ ASP Server
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Ranges of dates I'm sure there's a simple way to do this, but I can't seem to find it: If today is after February 1st and before February 15th then do valentines elseif today is after March 1st and before March 17th then do stpatty's day elseif today is April 1st then do April Fool elseif today is after April 15th and before May 5th then do CincodeMayo else just do the regular thing end if I know about date() and I know about datepart and I know about month(date()) and day(date()). Right now I do: if month(date()) = 2 and day(date()) => 1 and day(date()) < 15 then 'do valentines elseif month(date()) = 3 and day(date()) < 18 then 'do st pattys elseif month(date()) = 4 and day(date()) = 1 then 'do April fool 'then I get confused about the best way to do Cinco De Mayo else 'do the regular thing end if Is there an easier/better way to do this? Thanks in advance for any tips, solutions, etc. -- Adrienne Boswell at work Administrator nextBlock.com http://atlas.nextblock.com/files/ Please respond to the group so others can share Tag: Doubt limiting user size upload Tag: 329797
  - 2
    - Getting option's text value Hi, I have a select list that gets populated from the DB. When the user makes a selection I am able to retrieve this value via Request.Form(...) However, I am wondering if you can retrieve the text value using ASP?? I know this can be done in JavaScript using the options text attribute, but it is possible in ASP? Any input would be appreciated....Thanks! Tag: Doubt limiting user size upload Tag: 329796
  - 3
    - B2B dolution in classical ASP Hi all, Recently, a couple of our clients have asked if it is possible for them to pass data in xml format to our server program for processing it. Would you please give me some guide lines or point me to a starting point how I should do it in classical asp program. Thank you. -- Betty Tag: Doubt limiting user size upload Tag: 329793
  - 4
    - Looking for a great designer/design team! Hi All, I work for a Startup based out of San Diego, CA. We are succesfull team of entrepreneurs with a proven track record. We have finished an initial design for a site that helps people be more productive with social networking aspects. This means we have a bunch of use cases and wireframes completed. We need help in putting it all together and creating a great overall design. We are looking for referrals from the community for designers with solid portfolios. West Coast bases teams/indivduals are preferred. Thanks! Art You can also email me individually at formless@formless.com Tag: Doubt limiting user size upload Tag: 329792
  - 5
    - New Windows www.middlesexccl.com During testing on my home PC running XP when any of the big blue buttons are clicked a new web page opens. If a team is selected from the drop-down list a new page opens with the selected team details in it. However when deployed live, whenever any of the buttons are clicked, not only does the new window appear for that content, but also the new team page window appear with an error because no team has been selected. Can anyone explain this, and more importantly advise how I make the live web site function as intended and how it does when testing. PWS Tag: Doubt limiting user size upload Tag: 329790
  - 6
    - ASP Debugging Text Editor Can someone please suggest me a text editor especially for DEBUGGING ASP scripts apart from Microsoft Visual Interdev? I tried using Visual Interdev & created a project but Interdev generates some error related to FrontPage extensions. I couldn't exactly understand the error. I tried to create the project in C: \Inetpub\wwwroot. If I just open a ASP file (by navigating to the File-->Open File... menu), then Interdev doesn't give the option to debug. Please do not suggest using Response.Write, Response.End etc. I guess I am aware of most of such debugging techniques that are globally used by ASP developers :-) Tag: Doubt limiting user size upload Tag: 329783
  - 7
    - image file cannot be printed out Hi all, I am not a person usually works with image file. I am just wondering while some images in html /asp cannot be printed out? Thank you. -- Betty Tag: Doubt limiting user size upload Tag: 329778
  - 8
    - Operation must use an updateable query - local server error I am using Windows XP Pro, and since I updated to Internet Explorer 7 I am having problems getting web sites to work on my PC in Internet Explorer using the local IIS web server. These web sites are using ASP and Access databases. The two errors I get are: Operation must use an updateable query or Cannot modify the design of table 'TABLE_NAME'. It is in a read-only database Does anyone know how I can get this working so I can test my web sites locally before uploading them to the live sites? Thanks, Stephen Tag: Doubt limiting user size upload Tag: 329776
  - 9
    - mail program in asp Problem 1> I m writing a mail program in asp my first page is mail.asp where I subitting address, subject, body and second page is send_mail.asp Contents of Page mail.asp <html> <head> <meta name="GENERATOR" content="Microsoft FrontPage 5.0"> <meta name="ProgId" content="FrontPage.Editor.Document"> <meta http-equiv="Content-Type" content="text/html; charset=windows-1252"> <title>New Page 1</title> </head> <body> <form name = form1 action = "send_mail.asp" method = post> To<input type = text name = "To"/ size="20" ><br/> From<input type = text name = "from" size="20"/> <br/> Subject<input type = text name = "subject" size="20"/></br> Body <TextArea name = "body" rows = 5 column =20 wrap = "physical" cols="20"> </textArea> <input type = submit name = submit value = submit> </form> </body> </html> Contents of page sendmail.asp <html> <head> <meta name="GENERATOR" content="Microsoft FrontPage 5.0"> <meta name="ProgId" content="FrontPage.Editor.Document"> <meta http-equiv="Content-Type" content="text/html; charset=windows-1252"> <title>New Page 1</title> </head> <body> <% 'Send An Email dim mail Set mail = Server.CreateObject("CDO.Message") mail.To = Request.Form("To") mail.From = Request.Form("From") mail.Subject = Request.Form("Subject") mail.TextBody = Request.Form("Body") mail.Send() ' This is Line No 19 Response.write("Mail Sent!") 'Destroy The mail Object Set mail = Nothing %> </body> </html> My Error is : CDO.Message.1 (0x80040220) The "SendUsing" configuration value is invalid. /vkasp/aspMail/send_mail.asp, line 19 I have mention the Line no 19 in above code Tag: Doubt limiting user size upload Tag: 329773
  - 10
    - Real Exams I have personally used the site [url]www.exams.ws[/url] and found it very good. The exams are not expensive but quality wise good. When I say quality wise good it does not mean the quality of text and diagrams but the turn out in real live exam. -- jhon ------------------------------------------------------------------------ Posted via http://www.codecomments.com ------------------------------------------------------------------------ Tag: Doubt limiting user size upload Tag: 329768
  - 11
    - stored Procedure with argument I am Beginner in ASP Problem:I have a table named emp which fields are(id int(4), name varchar(50), rollNo int(4)) I have to just pass the name of the emp and it will just say that record is found or Not My code is : <% nm1 = request.form("txtName") Set cmd = Server.CreateObject("adodb.Command") cmd.ActiveConnection = con cmd.CommandText = "sp_search" cmd.CommandType = adCmdStoredProc cmd.Parameters.Append cmd.CreateParameter("nm", adchar, adParamInput) 'Just Above Line no is 19 cmd.Parameters.Append cmd.CreateParameter("flag",adInteger, adParamReturnValue) cmd.execute x = cmd.Parameters("flag") Response.write (x) y = Cint(x) if y = 1 then %> <script language = "JavaScript"> alert("Record Found") </Script> <% else %> <script language = "JavaScript"> alert("Record Not Found") </Script> <% end if %> My Stored Procedure is CREATE PROCEDURE sp_search(@nm varchar(50), @flag int output) AS if exists(select name from emp where name = @nm) begin select @flag = 1 return @flag end else begin select @flag = 0 return @flag end GO My Error is Error Type: ADODB.Parameters (0x800A0E7C) Parameter object is improperly defined. Inconsistent or incomplete information was provided. /vkasp/search_rec.asp, line 19 Tag: Doubt limiting user size upload Tag: 329767
  - 12
    - return record set I am beginner in ASP 1> how can I return a recordset through a function in asp. 2>Suppose there are two buttons in asp. I want if I presss the first button then it should go to page1.asp and if I press the second button then it should go to page2.asp. Is it possible by any way. Please Help Me Thank You. Tag: Doubt limiting user size upload Tag: 329766
  - 13
    - Querystring issue Hi all, is there anyway of separating a string by either a space or + sign, I have an sms.asp page that receives a string in this format below http://acompany.co.uk/online/internal/InboundSms.asp?api_id=2920893&from=447912956700&to=447624813579×tamp=2007-04-07+03%3A56%3A42&text=19%2Bdavid the last part text= I need to split into 2 parts I need to read the first part 19 and match that to the db and then deal with the name David, I have tried everything, is there anyway of doing this even if the string read text=19+david if there was a way of separating the two. Thanks in advance. Regards Simon Gare The Gare Group Limited website: www.thegaregroup.co.uk website: www.privatehiresolutions.co.uk Tag: Doubt limiting user size upload Tag: 329758
  - 14
    - click to download Can I have this function? When a user click on a link, my ASP page generates a text file call test.txt containing a string of "This ia s test msg.", and then a download dialogue appears. Any reference for me? Thanks in advance. Tag: Doubt limiting user size upload Tag: 329752
  - 15
    - Performance Question ? Hello: I have a database with 300,000 records. I have two "DATE" columns and I need to calcluate the difference and display the number of days in one of the reports. I was wondering if this calculation of days should be done on the fly or is it OK to have a "Difference Date" column[Contains Number of Days] and retrieve the same ? Their will be not more than 50 concurrent users accesing it. However, in the next 6 months the record size is expected to reach 800,000. The database will be hosted on a shared hosting on the internet. Kindly share your thoughts. Thanks. Tag: Doubt limiting user size upload Tag: 329751
  - 16
    - drop down Problem in asp I m beginner in asp 1> I want if seleted list of drop down in asp is changed then its related record in table should be displayed simultaniously in a single page. Please give its full solution in asp 2> How can access the selected value of drop down in another page. 3> I want to make a search command in a Sngle page in asp. Please Help me Thank You. Tag: Doubt limiting user size upload Tag: 329743
  - 17
    - asp JavaScript I have a problem Some asp Problem 1>I want to use two button in asp and want if first button is pressed then it should go to a page and if another button is pressed then it should go to another page. Problem 2> I want if a button is pressed a particular function or procedure should be call. Tag: Doubt limiting user size upload Tag: 329740
  - 18
    - FormatDateTime question I set my computer Regional Setting (Control Panel - Regional and Language Options - Customize - Date) to dd/mm/yy. In my ASP page I do the following: FormatDateTime("1/20/07",2) and it returns 1/20/07 instead of 20/1/07. I though my setting it to 2, it will display a date using the short date format specified in your computer's regional settings, how come it is not ? How can I set the string to display a date using the computer's regional setting ? IIS is running on my machine, I am not on a network, it is just my machine. Thank you. Tag: Doubt limiting user size upload Tag: 329738
  - 19
    - FormatDateTime question I set my computer Regional Setting (Control Panel - Regional and Language Options - Customize - Date) to dd/mm/yy. In my ASP page I do the following: FormatDateTime("1/20/07",2) and it returns 1/20/07 instead of 20/1/07. I though my setting it to 2, it will display a date using the short date format specified in your computer's regional settings, how come it is not ? How can I set the string to display a date using the computer's regional setting ? Thank you. Tag: Doubt limiting user size upload Tag: 329737
  - 20
    - Load Testing and performance We have an asp application some of which will be being ported over to asp.net so this may be a little OT. It is having some bad performance problems and we need to isolate which areas are causing the problems. The main performance problems are database related i.e. timeouts and deadlocks Some questions: Microsoft's ACT. How is it better than the Web Stress Application Tool? Is ACT purely .net or can be used to look at any web app. What is a good way of assessing which pages are causing the problems. How can I relate the performance of the database to the application. The system has LOTS (this app has 1000's of pages) of sql passed as strings will this affect how easy the profiler is to read. I suspect there are lots of memory leaks, are there any tools to look at what is being left in the memory. I guess what I want is a tool which will identify which pages are hogging the most resources and if they are not being released so we can look at optimising the code. Tag: Doubt limiting user size upload Tag: 329733
  - 21
    - replica watches Tag: Doubt limiting user size upload Tag: 329729
  - 22
    - Classic ASP and FFMPEG Anyone have any tutorials or examples on to use FFMPEG inconjunction with classic ASP to provide a youtube like site that includes the ability to convert videos of different formats? Tag: Doubt limiting user size upload Tag: 329727
  - 23
    - a free ASP photo album that I can post on my ASP website is there a free ASP photo album that I can post on my ASP website Tag: Doubt limiting user size upload Tag: 329724
  - 24
    - Replace commas in values in an array Although this is a client side issue, I am also posting to asp.general in case there is someway to do this only server side (which I would prefer). Here's my form: <form method="post" action="<%=request.servervariables("Script_name") %>" <% for i - 0 to 4%> Header: <input type="text" name="header" id="header<%=i%>" onblur="function(this)"><br> Description: <input type="text" name="description" id="description<%=i %>" onblur="function(this)"> <% next%> <input type="submit" value="Submit"> </form> When the data gets returned it's something like: header: "socks, shoes, pizza, cats, dogs" description: "good for feet, wear with socks, cheese only, have lots of hair, bark a lot" Problem comes when the description or header have a comma. I need a little javascript that will replace the comma with a semicolon client side before it gets to the server, preferably as they leave the field. Any help with this would be much appreciated. -- Adrienne Boswell at work Administrator nextBlock.com http://atlas.nextblock.com/files/ Please respond to the group so others can share Tag: Doubt limiting user size upload Tag: 329719
  - 25
    - Simple ASP to give IP/time/username? I am new to ASP and would like to know if anyone has a page that will display username, time, IP TIA - Grego Tag: Doubt limiting user size upload Tag: 329715
- Next
  - 1
    - iTechArt Group - Custom Software Development and Offshore outsourcing Company iTechArt Group - Custom Software Development and Offshore outsourcing Company http://www.itechart.com/ Offshore custom software development company iTechArt - Web site and Content Management Solutions development, CMS consulting: Ektron, Drupal and DotNetNuke iTechArt Group provides high quality custom software development services and offshore software development. On December 2006, iTechArt Group became an authorized Microsoft Certified Partner. This means that our company has been recognized by Microsoft for our vast expertise and authorized to custom software development; provide IT service consulting and custom business solutions. Custom Software Development and Offshore outsourcing Company iTechArt has worked together since 2003 to design build and deliver .NET Web Content Management software solutions that help clients meet their strategic objectives. We are agile oriented development partner able to consistently deliver solid results. iTechArt software development team assemblies specialists in the development of custom software applications and offshore software outsourcing services. Working concepts of our company are based on proven approaches and international standards used for custom software development such as Capability Maturity Model Integration for Software Engineering (CMMI- SW). In the same breath we have our own standpoint on software development process management which is fully effective and comprehensible for our clients. iTechArt offers software development in the next main directions: 1. Custom Software Development (Offshore outsourcing for worldwide based software development companies.) 2. Software Development for Digital Signage (Media content development and remote displays / information kiosks Web-based software application management.) 3. Web Site Development (E-commerce solutions, CMS/DotNetNuke/Ektron/ Drupal, Web 2.0/PHP/MySQL/AJAX, Flash/Action script/Flex and many more.) 4. Offshore Development Center (Dedicated development team of software developers. Our offshore development centers operate as an extension to clients' existing software engineering business.) Contact iTechArt ( http://www.itechart.com/ )about custom software development, end-to-end software solutions, outsourcing software development, custom DotNetNuke module development, DotNetNuke consulting, dotnetnuke hosting, first class Java and .Net developers, software application design, software testing, Quality Assurance, functionality testing and defect analysis, performance and stress testing, usability testing, Microsoft Media Services and Adobe Media Flash Server solutions, digital signage solutions and custom development, Ektron CMS400.NET developers, CMS, .NET Web Content Management software solutions Web: http://www.itechart.com/ http://www.itechart.com/Pages/ProductsServices/HowWeWork.aspx http://www.itechart.com/Pages/ProductsServices/BusinessModels.aspx http://www.itechart.com/Pages/ProductsServices/CustomSoftwareDevelopment.aspx http://www.itechart.com/Pages/ProductsServices/DotNetNukeModuleDevelopment.aspx Tag: Doubt limiting user size upload Tag: 329713
  - 2
    - Vista / IIS question Which version of Vista includes IIS ? Thanks, PW Tag: Doubt limiting user size upload Tag: 329710
  - 3
    - Running Access Stored Queries with Parameters Hi. I am working with classic ASP. I'd like to transfer al my hard coded sql queries to access stored queries and use them with parameters. Actually, I did not find any strong information how to do that. Please, provide me official information, or give me at least one example of using it(with Select statement or other). Thanks a lot in advance . Michael Tag: Doubt limiting user size upload Tag: 329706
  - 4
    - Adding Basic User Control, cannot get event to wire I am trying to add a basic user control to a web site; coming from visual studio 2003 this was extremely easy. I would just add the user control and then add the controls that I want on that user control, but I am not able to get a basic link button to click. This seems so ridiculously basic, but I am not able to get this to work. What am I missing? Tag: Doubt limiting user size upload Tag: 329704
  - 5
    - buy viagra Tag: Doubt limiting user size upload Tag: 329703
  - 6
    - website issuing multiple ASPSESSIONID to same client..make it stop!!! Hello- For some reason, at a website that has been trouble free for a couple of months, multiple ASPSESSIONID's are now being set by IIS for each client visitor, rather than the one you'd expect. When you first visit the site and hit a page that sets a session, the response.write of the HTTP_COOKIE server variable looks like you'd expect...with just the one IIS-assigned ASPSESSIONID: HTTP_COOKIE= ASPSESSIONIDQSADRADT=DJGKPNMACDAJEPGHHKEPFOEB ...but when you add items to your shopping basket(stored in a db, no persistent cookies being used), then go view your order or continue shopping and view the response.write again, it's now a string of ASPSESSIONID's like: HTTP_COOKIE= ASPSESSIONIDQSADRADT=DJGKPNMACDAJEPGHHKEPFOEB; ASPSESSIONIDQSCCTBDS=NPKKPFKAPCNEEBMEKIDCPNKG; ASPSESSIONIDSSCARBCS=JDCHGKPAOJFMKEAGIIMLGCAD The problem manifests itself in that RANDOMLY, IIS appears to be recognizing the user/client as one or the other of the ASPSESSIONID's in the string...in effect, IIS no longer recognizes the user that added items to their basket a minute ago because it is paying attention to one of the other ASPSESSIONID's in the string which haven't got any session variables defined via scripting....you can refresh your page a few times and it thinks you are a different visitor with no sessions...refresh a few more times and it thinks you're the original person with active sessions...a very frustrating issue. The server is Windows Server 2003 and has IIS 6 on it. I've done a lot of digging on the web for information about this phenomenon, but nothing I've found seemed applicable ...or worked. 1. The website doesn't use frames 2. The problem occurs whether staying in http or https or crossing between the two types of connections 3. The server is not a member of a web farm that utilizes load balancing 4. I've assured that my global.asa file has read and execute permissions for IUSR 5. I've stubbed out everything in the Session_OnStart sub of my global.asa file 6. I've pulled out hand-fulls of hair, cussed and gritted my teeth for several days ..nothing works... Any help making it stop this behavior would be greatly appreciated!!! Thanks, Steve Tag: Doubt limiting user size upload Tag: 329702
  - 7
    - Error running ASP in IIS I am trying to run an ASP page in IIS 6.0 and I keep getting one of two errors: -2147467259 (0x80004005) The remote procedure call failed and did not execute. I have Win XP. It's been running fine for a long time and then yesterday, for no apparent reason, I get this. I've tried the links to asp.faq that I've seen others post and nothing works. As a test, I created a simple ASP page with just '<% Response.Write("Hello") %>' in it and still the error occurs so it's not a scripting or database problem. DotNet seems to run fine and I can run HTML pages, I also have Apache and can run PHP scripts with no problem ... everything except classic ASP. Any ideas? This is driving me crazy and I need IIS running because I am falling behind in my work. As I mentioned, I've been running ASP scripts on this machine for years and have never seen this problem. Thanks, Steve Tag: Doubt limiting user size upload Tag: 329701
  - 8
    - Easy question - Trouble with Request.Form I am new to asp and I am having a little trouble with the Request.form option. What I want to do is I have a dropdown box. <select name="selecter" class="text" id="selecter"> <option value="page1.htm" selected>Page 1</option> <option value="page2.htm">Page 2</option> <option value="page3.htm">Page 3</option> </select> and I want to use a button that then will take you to the page you selected so I have been trying codes like this. <a href="<%= Request.Form("selecter") %>" ><img src="submit.jpg" width="45" height="18" border="0"></a> Any idea what I am doing wrong, any help is apprieciated. Thanks, Randy Tag: Doubt limiting user size upload Tag: 329690
  - 9
    - Large insert string Hi, I have an asp page with a form, which has a lot of fields ........ 30 to 40 ! Is there an easier way to loop through all the fields submitted to the insert page or is the only way to do it using the standard, request.form for each field and then INSERT INTO Reports (ReportID, ReceivedDa .................... very lengthy for this amount of fields. Perhaps there is a way of looping through some sort of collection ??? Thanks David Tag: Doubt limiting user size upload Tag: 329686
  - 10
    - Creating Project from existing site Hi all, I'm running into some trouble figuring out how to create a 'project' from an existing asp application. The ASP app was written entirely with plain text editors. I would like to set up debugging for it, but it seems that in order to debug, I must have a 'project'. I cannot figure out how one might go about this task. The project is rather large (180K lines, and a few hundred files in many different sub-dirs), and I have been playing & researching for about 4 hours now, and I can't figure it out. Can anyone make a suggestion as to what I must do to get something going (preferably vs2003, but I have VID also) Thanks so much Brian Ackermann Tag: Doubt limiting user size upload Tag: 329684
  - 11
    - ADO recordset returns UTF8 instead ISO-8859-1 I'm using ADO to read an access database using ASP. My problem is, that i get e.g. =C3=BC instead of =FC Does anyone know y? I am using following doctype: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/ TR/xhtml11/DTD/xhtml11.dtd"> I am using following contenttype: <meta http-equiv=3D"content-type" content=3D"text/html; charset=3Diso-8859-1"> Tag: Doubt limiting user size upload Tag: 329683
  - 12
    - Insert statement Hi, I have an asp page which runs an update into our mysql database. The only problem I have is that a user selects a customer from a dropdown (this is database fed), and I require the selected item to be loaded into the db. All I can get in the database is the first part of their name upto the first space ? i.e. if the selected item from the dropdown is A B Knowles, the database entry is 'A' cust = request.form("customername") I have tried adding ' " & cust & " ' for the insert statement What do I need to do to fix this minor glitch Thanks David Tag: Doubt limiting user size upload Tag: 329678
  - 13
    - small dooubt on recordset Hello Friend, I have a doubt. I am connecting to mysql db and there is only one table and i am retrieving the data like city, state, county, etc.. from db to comboboxes. so i am using one recordset for each retrivel and showing into combobox. it is going slowly. SO what happens if i use multiple recordsets in single ASP page? So I think we can use only one recordset for all the data retrievel from the db? waiting for your reply. Gaffar. Thanks Tag: Doubt limiting user size upload Tag: 329676
  - 14
    - replica watches Tag: Doubt limiting user size upload Tag: 329674
  - 15
    - "Breaking out" of a Server.Execute call? Greetings, folks. Wondering if someone might be able to shed some light on this without my having to load up 'n test it for myself. I have a page calling another with Server.Execute, but depending on what the outcome of some data checks on that called page is, it may need to "break out" of the call with a Response.Redirect. What I want to know is, will this eventually lead to memory leaks because there's no return to the original calling page? The environment's a "plain vanilla" IIS installation under Windows Server 2003 Web Edition. Ultimately I suppose it's not entirely crucial that I need to use this method; I could always break the original page into two and use Server.Transfer to avoid the possibility of "left-overs," but I hope someone here can state with at least a little authority whether or not this problem might occur. Thanks in advance, -- Bob Milutinovic Cognicom - "Australia's Web Presence Specialists" http://www.cognicom.tk/ telephone (0417) 45-77-66 facsimile (02) 4727-1898 ------------------------------------------------------- To respond by e-mail: <myname>@<mydomain> (work it out) Tag: Doubt limiting user size upload Tag: 329673
  - 16
    - Save As Dialog Box When users submit a Form with a SQL query, the resultset is retrieved from a MS-Access database table which is then exported to an MS-Excel worksheet. After the records get exported to MS-Excel, I want to give users the option to download the Excel file to their local machine. In other words, when users click a download link, I want the Save As.. dialog box to pop-up so that users can save the Excel file to their local machine (note that I don't want users to view the Excel worksheet in their browser). This is how I tried it: <% Dim strFile 'here strFile is just the file name & does not include it's physical path strFile=Request("file") Response.ContentType="application/octetstream" Response.AddHeader "Content-Disposition","filename=" & strFile Dim objStream strFile=Server.MapPath(strFile) Set objStream=Server.CreateObject("ADODB.STREAM") objStream.Open objStream.Type=1 objStream.LoadFromFile(strFile) Response.BinaryWrite(objStream.Read) objStream.Close Set objStream=Nothing %> The above code doesn't give users the option to save the Excel file in their local machines. Rather the Excel worksheet opens in the browser. What am I doing wrong here? What I find is if I pass the PHYSICAL PATH of the Excel file to the LoadFromFile method, say, something like C:\Inetpub\wwwroot\XL \XLFile.xls & change the above code slightly to look like this: <% Dim strFile,strFileName strFile=Request("file") strFile="C:\Inetpub\wwwroot\XL\" & strFile 'just get the file name; exclude it's path strFileName=Right(strFile,Len(strFile)-InStrRev(strFile,"\")) Response.ContentType="application/octetstream" Response.AddHeader "Content-Disposition","filename=" & strFileName Dim objStream Set objStream=Server.CreateObject("ADODB.STREAM") objStream.Open objStream.Type=1 objStream.LoadFromFile(strFile) Response.BinaryWrite(objStream.Read) objStream.Close Set objStream=Nothing %> In the 2nd code, I am passing the file name as well as it's entire PHYSICAL PATH to the LoadFromFile method & this does pop-up the Save As... dialog box so that users can download the Excel file to their local machines. But in the 1st code, I am passing the file name along with it's VIRTUAL PATH to the LoadFromFile method. Hence to get the PHYSICAL PATH, I am using Server.MapPath but the Excel file opens up in the browser & doesn't pop-up the Save As.. dialog box. Tag: Doubt limiting user size upload Tag: 329671
  - 17
    - strings with quotes in < input type=text name="PageTitle" id="PageTitle" value="<%=strPageTitle%>" > How do I "escape" any quotes, accidental carriage returns etc that are contained within strPageTitle? Do I have to use a series of replace() functions, or is there a cunning way that makes it OK? (Using escape(strPageTitle) fills the box with % signs...) Thanks in advance Giles Tag: Doubt limiting user size upload Tag: 329666
  - 18
    - test dropdown value from form Hi, I have an asp page with a simple form. The form has a dropdown which is database fed. Once the user selects a value from the dropdown, I need some code to test the value selected. If the value is 'X' then, make certain other form fields visible, otherwise hide them. Can this be done ? perhaps it needs to be done in clientside javascript (obviously a different group before I get shouted at :-) Thanks David Tag: Doubt limiting user size upload Tag: 329661
  - 19
    - Removing obscure chars Hi All I have an ASP function in place to strip invalid chars out of a data store before I create an XML file of this data, but my function doesn't work on a certain set of chars. As far as I can see these are the following: a) trademark char b) long hyphen/dash char c) smart/curly quotes (both left and right) Even though my function is set up as follows: Function ReFormatStringForXML(s) IF LEN(s) > 0 AND NOT IsNull(s) THEN s = Replace(s,"™","™") s = Replace(s,"—","-") s = Replace(s,"’",""") s = Replace(s,"'",""") s = Replace(s,"""",""") s = Replace(s,"&","&") s = Replace(s,"<","<") s = Replace(s,">",">") END IF ReFormatStringForXML = s End Function These chars still pass by and foul up my XML file. I have a feeling that its down to the fact that my function is looking for the html equiv rather than the actual char, but I can't possibly get away with simply copy and pasting these friggin(!!) chars into my function. Surely this is bad practise? Does anybody know how I can trap and replace/remove these chars if need be? Thanks Tag: Doubt limiting user size upload Tag: 329660
  - 20
    - Removing obscure chars Hi All I have an ASP function in place to strip invalid chars out of a data store before I create an XML file of this data, but my function doesn't work on a certain set of chars. As far as I can see these are the following: a) trademark char b) long hyphen/dash char c) smart/curly quotes (both left and right) Even though my function is set up as follows: Function ReFormatStringForXML(s) IF LEN(s) > 0 AND NOT IsNull(s) THEN s = Replace(s,"™","™") s = Replace(s,"—","-") s = Replace(s,"’",""") s = Replace(s,"'",""") s = Replace(s,"""",""") s = Replace(s,"&","&") s = Replace(s,"<","<") s = Replace(s,">",">") END IF ReFormatStringForXML = s End Function These chars still pass by and foul up my XML file. I have a feeling that its down to the fact that my function is looking for the html equiv rather than the actual char, but I can't possibly get away with simply copy and pasting these friggin(!!) chars into my function. Surely this is bad practise? Does anybody know how I can trap and replace/remove these chars if need be? Thanks Tag: Doubt limiting user size upload Tag: 329658
  - 21
    - Problem repeating a query within an ADO Transaction I have a fairly simple ASP application talking to an Oracle 10g DB using a mixture of ADO (OraOLEDB) and OO4O - the query here concerns some ADO code. One part of the application records PartNo/SerialNo combinations; the user specifies a PartNo, a SerialNo and the parent PartNo - the parent takes the SerialNo from the child object - and the application INSERTs these as records into the DB. Amongst the validation, is a check to confirm that each PartNo/SerialNo combination has not be used before. This code seems to work fine. Clearly, if the user enters the same PartNo for both the child and parent items, the DB would ordinarily complain: "ORA-00001: unique constraint (IFSAPP.PART_SERIAL_CATALOG_PK) violated ORA-06512" However, I'm expecting the validation routines to handle this clash before the INSERT statement is attempted. Unfortunately, in this type of scenario this is not the case - the validation routine responds that the parent PartNo/SerialNo has not been used before, and thus the INSERT is attempted and the unique constraint error occurs. I assume that this is because previous INSERTs were not committed since the whole operation is wrapped up within an ADO transaction. However, I would have expected that the validation code would have taken an changes made within the transaction into account, but it doesn't appear to be the case. Is my logic wrong, or should I be expecting the validation to consider previous statements within the same transaction? If my expectations are correct, where might I be going wrong? Thanks in advance Chris Selected code snippets: - ASP: Function SerialExists (sSerialNo, sPartNo) Dim iResult, bResult With oDB .Parameters.Add "sPartNo", sPartNo, ORAPARM_INPUT, 1 .Parameters.Add "sSerialNo", sSerialNo, ORAPARM_INPUT, 1 .Parameters.Add "iResult", 0, ORAPARM_OUTPUT .Parameters("iResult").serverType = 1 .ExecuteSQL ("declare iResult VARCHAR2(100); Begin :iResult := IFSAPP.PART_SERIAL_CATALOG_API.CHECK_EXIST(:sPartNo, :sSerialNo); end;") SerialExists = .Parameters("iResult").Value .Parameters.Remove "sPartNo" .Parameters.Remove "sSerialNo" .Parameters.Remove "iResult" End With End Function - Oracle: FUNCTION Check_Exist___ ( part_no_ IN VARCHAR2, serial_no_ IN VARCHAR2 ) RETURN BOOLEAN IS dummy_ NUMBER; CURSOR exist_control IS SELECT 1 FROM PART_SERIAL_CATALOG_TAB WHERE part_no = part_no_ AND serial_no = serial_no_; BEGIN OPEN exist_control; FETCH exist_control INTO dummy_; IF (exist_control%FOUND) THEN CLOSE exist_control; RETURN(TRUE); END IF; CLOSE exist_control; RETURN(FALSE); END Check_Exist___; Tag: Doubt limiting user size upload Tag: 329656
  - 22
    - Pass Parameters to  What is the workaround of passign a parameter to any included asp file:  This obviously does not work:  Thank you Tag: Doubt limiting user size upload Tag: 329654
  - 23
    - ASP error Server object error 'ASP 0178 : 80070005' Server.CreateObject Access Error /asp/aspincludes/CRFunctions.asp, line 20 The call to Server.CreateObject failed while checking permissions. Access is denied to this object. Tag: Doubt limiting user size upload Tag: 329653
  - 24
    - ASP error Server object error 'ASP 0178 : 80070005' Server.CreateObject Access Error /asp/aspincludes/CRFunctions.asp, line 20 The call to Server.CreateObject failed while checking permissions. Access is denied to this object. Tag: Doubt limiting user size upload Tag: 329652
  - 25
    - asynchronous callback component We have an asp.net application that will also use MSMQ. When a client makes a request, we want to check several databases and put each response in MSMQ. We don't want the client to wait for all responses to come back. We were wondering if there is some component that will sit on the client and listen for call backs from the the server. We are also concidering using AJAX to poll MSMQ every 5 seconds and show any new responses. Has anyone had any experience with this? Tag: Doubt limiting user size upload Tag: 329649

Hi, how are you doing?

I need to develop an asp application wich allow users to upload files, but I
need to limit every user folder with 10MB...

How can I do that?

not pure asp solution? each user must be a IIS/FTP user that will control
that?

Thanks

Bye

Top

Re: Doubt limiting user size upload by Paulo

Paulo
Tue Apr 10 19:32:09 CDT 2007

The site is public...

Just like a host web provider wich gives the user some limited X MB to
upload files to server HD via FTP, I need it but via interface web, not
FTP...

I think I will have to record the files/sizes of each user on any db and
sums up the values...

What do you think about this solution?

Any others?

Thanks

"Paulo" <prbspfc@uol.com.br> escreveu na mensagem
news:ugckHN7eHHA.4604@TK2MSFTNGP06.phx.gbl...
> Hi, how are you doing?
>
> I need to develop an asp application wich allow users to upload files, but
> I need to limit every user folder with 10MB...
>
> How can I do that?
>
> not pure asp solution? each user must be a IIS/FTP user that will control
> that?
>
> Thanks
>
> Bye
>

Top