Search Results - ASP Message Board

Search:

Type: Posts; User: Bill Wilkinson

Page 1 of 20 1 2 3 4

Search: Search took 1.41 seconds.

  1. I *TOLD* you to try it IN SQL SERVER first! Do...

    I *TOLD* you to try it IN SQL SERVER first! Do that and tell us what error message, if any, you get. If no error message, then what is wrong with the results?

    You *could* change the second and...
  2. I *know* that! LOOK AT MY CODE: I used just...

    I *know* that! LOOK AT MY CODE: I used just stanica *TWO TIMES*, but I gave it a different ALIAS ("AS S_OD", "AS S_DO") so it acts as two different tables, as it should.
  3. Firsat of all, there is no reason to use a GROUP...

    Firsat of all, there is no reason to use a GROUP BY in this query. If you are getting duplicate records (I don't see how, but I suppose it is possible), use SELECT DISTINCT, not GROUP BY.

    Also, I...
  4. As Andrew said, you will just have to start over...

    As Andrew said, you will just have to start over creating the web-based version of the forms, et al. It's a pain, but it's well worth it in the long run.
  5. Replies
    1
    Views
    111

    What you *SAID* was: SELECT Cust_ID,...

    What you *SAID* was:


    SELECT Cust_ID, SUM(Amount) AS Total
    FROM yourtablename
    WHERE Cust_Type = 'KDF'
    GROUP BY Cust_ID
    ORDER BY Cust_ID

    I quote you "....if CUST_Type = KDF then Sum Amount...
  6. Replies
    1
    Views
    80

    No code, no help. You will need to show us the...

    No code, no help. You will need to show us the code that is doing this.
  7. Replies
    7
    Views
    1,362

    Well, good luck. I do feel it's a mess that...

    Well, good luck. I do feel it's a mess that could be MUCH simplified. Certainly no reason to use ReturnURL unless you allow people to login from multiple .aspx pages.
  8. Replies
    7
    Views
    1,362

    You wrote In other words, you seem to want to...

    You wrote
    In other words, you seem to want to show them a message *BEFORE* sending them to hiddenfile.aspx.

    You can *NOT* do that with Response.Redirect. You can only use Response.Redirect...
  9. Replies
    7
    Views
    1,362

    I assume you mean you want to display that...

    I assume you mean you want to display that message for a few seconds and then auto-direct them to the new site?
    If so, then you would need to do that via JavaScript.

    Example:

    <script...
  10. Replies
    7
    Views
    1,362

    It's all right here: Dim manager = New...

    It's all right here:

    Dim manager = New UserManager()
    Dim user As ApplicationUser = manager.Find(username.Text, password.Text)

    UserManager is a library class that handles all the SQL...
  11. Yes, one (or more) of your fields really is "too...

    Yes, one (or more) of your fields really is "too short" to hold the data you are trying to insert.

    You will have to inspect the table's schema (list of fields and field types and field sizes) to...
  12. Yes, and about 90% of it is verified. Oh, the...

    Yes, and about 90% of it is verified. Oh, the stuff older than 1600 or so is suspect, but even the 1600s are pretty accurate. Helps to have a common ancestry with Richard Nixon, for example. ...
  13. Replies
    3
    Views
    279

    Is it possible that the href is now incorrect? ...

    Is it possible that the href is now incorrect? That is, your new page is not in the same folder as the old page? If so, one easy answer is to use the *FULL URL* of the CSS file in the href. Yes,...
  14. Thanks very much! I've been wanting to put my...

    Thanks very much! I've been wanting to put my tree onto my own site for some time now.
    Here's my grandson's tree on RootsWeb:...
  15. Replies
    3
    Views
    261

    Sorry about the FOR loop. Been doing too much...

    Sorry about the FOR loop. Been doing too much PHP and JavaScript lately, where it would start with zero. DOH on me.
  16. I have to ask you: Where did you get the GEDCOM...

    I have to ask you: Where did you get the GEDCOM database from??

    That is, where did you find a program that will convert a ".ged" to a ".mdb"???
  17. Replies
    3
    Views
    261

    Yes, the problem with UN-checked checkboxes is...

    Yes, the problem with UN-checked checkboxes is that *NOTHING* is sent from the browser to the server for them!

    So indeed you might have an array of 5 comments, but if only 2 checkboxes where...
  18. Replies
    5
    Views
    299

    If you are *REALLY* worried about efficiency then...

    If you are *REALLY* worried about efficiency then I say again: Do *NOT* use a LOOP! Learn to use regular expressions. They are *AT LEAST* an order of magnitude (10 times, that is) more efficient....
  19. Ready to kick yourself? connstr2...

    Ready to kick yourself?



    connstr2 ="Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("/db/GEDCOM.mdb") & ";"
    conn2.Open connstr2
    ...
    Set GEDCOM = conn.Execute(selSQLtxt)
    ...
  20. Replies
    5
    Views
    299

    Finally, probably the fastest and shortest code...

    Finally, probably the fastest and shortest code would be a variation on the RegExp version:


    <%
    ' at the top of your page someplace:
    Set isAlpha = New RegExp : isAlpha.Pattern = "^[a-zA-Z]+$"
    ...
  21. Replies
    5
    Views
    299

    Even if you think you need to use a loop, for...

    Even if you think you need to use a loop, for some reason, you can do it more efficiently:

    Function isAlpha( str )
    Dim i, ch
    str = UCase(str)
    For i = 1 To Len(str)
    ch = Mid(...
  22. Replies
    5
    Views
    299

    I would surely HOPE that you could improve on...

    I would surely HOPE that you could improve on code from September 7, 1999!

    But your code DOES NOT WORK!!! Did you even bother to test it???
    This line:
    if testValue > 64 AND teestValue < 91 then...
  23. Replies
    1
    Views
    226

    You ready to kick yourself? Look at the...

    You ready to kick yourself?

    Look at the "Requested URL": http://localhost:50662/Account/Login

    WHERE does it say "Login.aspx" there? Unless you have your web.config file set to redirect...
  24. Searching in files is tedious at best. You...

    Searching in files is tedious at best.

    You really have no choice but to open each file, read in all its contents, search through all the text in the entire file, somehow write out/highlight lines...
  25. If you use code such as Set location to...

    If you use code such as

    Set location to database
    location = Server.MapPath("../data/someAccessFile.mdb")




    ' DSN-less connection string
    connStr = "Provider=Microsoft.Jet.OLEDB.4.0; Data...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4


More ASP Resources

Resources:
-- ASP Articles
-- ASP.NET Information
-- 4Guys ASP F.A.Q.
-- ASPFAQs.com
-- ASP Coding Tips
-- Related Web Technologies
-- User Tips!!
-- JavaScripts


Development Centers
-- HTML5 Development Center
-- Windows Mobile Development Center
-- Android Development Center
-- Cloud Development Project Center


Development Technology
Check out these sites for more articles, tutorials, FAQs, discussions, and code!
-- CodeGuru.com
-- VBForums.com
-- DevX.com
-- Developer.com
-- HTMLGoodies