Search Results - ASP Message Board

Search:

Type: Posts; User: Bill Wilkinson

Page 1 of 20 1 2 3 4

Search: Search took 1.48 seconds.

  1. Replies
    2
    Views
    137

    In general, you can't. There is no such thing as...

    In general, you can't. There is no such thing as "row numbers" in database tables or SELECT results. However...

    However, since you don't seem to be using SQL Server, tell us what you are using...
  2. WOW! What database *IS* this???? I have...

    WOW! What database *IS* this????

    I have *NEVER* had to use parentheses for multiple INNER JOINs in SQL Server! That's a "feature" of Access, and of old versions of Access at that!
  3. 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...
  4. 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.
  5. 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...
  6. 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.
  7. Replies
    1
    Views
    123

    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...
  8. Replies
    1
    Views
    90

    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.
  9. Replies
    7
    Views
    2,106

    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.
  10. Replies
    7
    Views
    2,106

    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...
  11. Replies
    7
    Views
    2,106

    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...
  12. Replies
    7
    Views
    2,106

    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...
  13. 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...
  14. 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. ...
  15. Replies
    3
    Views
    356

    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,...
  16. 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:...
  17. Replies
    3
    Views
    276

    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.
  18. 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"???
  19. Replies
    3
    Views
    276

    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...
  20. Replies
    5
    Views
    310

    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....
  21. 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)
    ...
  22. Replies
    5
    Views
    310

    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]+$"
    ...
  23. Replies
    5
    Views
    310

    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(...
  24. Replies
    5
    Views
    310

    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...
  25. Replies
    1
    Views
    231

    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...
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