Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. abig99

    Russian Text in Insert Into

    Collegue resolved this for me. Its a known globalization issue with SQL Server and ASP.NET apparently. on the insert into you need to add an N in front of each field you want to become Unicode. so: INSERT INTO ORDERS (OrderNo, DelName, Title) Values ('" & vOrderNo & "',, '" &...
  2. abig99

    Russian Text in Insert Into

    Hi All, I have created an INSERT INTO that adds russian text to one of my SQL databases, however, the russian text appears in the database as ??? where the actual characters should be. I initially thought it was because my collation was incorrect as it was set to default for the database so I...
  3. abig99

    FileUpload/regularexpressionvalidator

    OK, well thanks for the help Jim, completely confused about this now :( Will keep searching.
  4. abig99

    FileUpload/regularexpressionvalidator

    Are you using a large file? Its pretty quick untill you get into the 100mb+ range, then you can really notice the upload time.
  5. abig99

    FileUpload/regularexpressionvalidator

    Hi Jim, I changed my code to run your suggested code, still seems to submit the page inclusive of the file. <%@ Page Language="VB" AutoEventWireup="True" %> <%@ Import Namespace="System.IO" %> <html> <head> <script runat="server"> Sub ValidateBtn_OnClick(sender As Object, e As...
  6. abig99

    FileUpload/regularexpressionvalidator

    Guess im getting confused, you said checking if the file is a .zip serverside would not upload the file to the server, but looking at my example it does, ignore the fact im checking for length, you could replace that with .zip and it would still submit the file to the server i believe.
  7. abig99

    FileUpload/regularexpressionvalidator

    Hi Jim, Ok, I tried what you suggested to see if it worked, you can do the same by pasting the code below into a blank aspx page. If I attempt to check a 150mb file server side it will actually place the whole page into the servers memory before doing server side checking. If you did this a...
  8. abig99

    FileUpload/regularexpressionvalidator

    Hi Jim, thanks for your reply, where would I place that code for it to run before page submission, i have something similar on the submit button but alas thats server side checking? To my eyes that looks like server side code, which would require you to submit the page (if its a big file the...
  9. abig99

    FileUpload/regularexpressionvalidator

    OK, i found the problem myself. Basically the regular expression microsoft give you on their examples doesnt work correctly with the fileupload control. In my case i used. =".*(.zip|.ZIP)$" This checks the last 4 characters are .zip or .ZIP, which works fine. If your worried about .exe.zip...
  10. abig99

    FileUpload Size Limit

    The strange thing is i have a 150mb test file im using, if i set the application level config file to 25mb, the server fails and i cant get a custom error to appear (using the asax file and the redirect, see below). If however i increase the application level config file to 200mb, the upload...
  11. abig99

    FileUpload Size Limit

    Again, thank you for the reply ca8msm. You mention the error if the size is too big, are you referring to the dns error you get when basically it stops responding, or can we generate a custom error if the size exceeds the config file paramter? If i could make a custom error it would be fine...
  12. abig99

    FileUpload/regularexpressionvalidator

    No pipe either. ="(^((([a-zA-Z]:)|(\\{2}\w+)\$?)(\\(\w([\w*\s*\d*\(*\)*\\*_*\-*]*)))+(.zip|.ZIP))
  13. abig99

    FileUpload/regularexpressionvalidator

    ="(^([\w*\s*\d*\(*\)*\\*_*\-*]*)$|^((([a-zA-Z]:)|(\\{2}\w+)\$?)(\\(\w([\w*\s*\d*\(*\)*\\*_*\-*]*)))+(.zip|.ZIP)) Should be ="(|^((([a-zA-Z]:)|(\\{2}\w+)\$?)(\\(\w([\w*\s*\d*\(*\)*\\*_*\-*]*)))+(.zip|.ZIP)) Was messing about thinking it was my regex that was faulty.
  14. abig99

    FileUpload Size Limit

    Ahh yes, i just read that, thanks for the reply, however the aim is to allow uploads of 25mb. I either want to set the .config file to 25mb so its not trying to upload massive files into memmory, or find a way to stop the user uploading files greater then this before it sends its response to...
  15. abig99

    FileUpload Size Limit

    While im here may as well ask my other question. Using the FileUpload Function, If i exceed the size specified in the config file i get an nds error, now ive read alot of posts that recommend putting an error sub into the asax file, however any redirect(response.redirect server.redirect) ive...
  16. abig99

    FileUpload/regularexpressionvalidator

    Hi all, mostly i do VBA programming so this is somewhat new to me, ive set up a page with a fileupload control on it, however, my regularexpressionvalidator doesnt work correctly, after uploading the first zip file, the regularexpression error message doesnt clear itself, by using a...
  17. abig99

    count categories, group by category not date

    This is partly guess work as i cant see your report in design view (my fault i know, i should have asked), but if you have your subreport inside your detail section on your report then what you are doing is displaying a duplicate set of info per detail section. Your main report has 2 records...
  18. abig99

    count categories, group by category not date

    I found it hard to understand what you mean, any chance you could post a link to a picture of the report your getting? and tell me what table is linked to the main report and what table is linked to the sub report.
  19. abig99

    bind a textbox in report to a field in tbl

    Below is a section of code i added on a forms current event, you can add the same code to a button. Private Sub Form_Current() Me.mycontrol.ControlSource = "alternatecontrolsource" End Sub Reports are trickier as they are generally not friendly towards changing their data source on the fly. In...
  20. abig99

    1.045 - 1 = error

    Hah, ignore me, just followed your method through and its working nicely, very easy way of doing it. Thanks again MichaelRed

Part and Inventory Search

Back
Top