Search Results - ASP Message Board

Search:

Type: Posts; User: Bill Wilkinson

Page 1 of 20 1 2 3 4

Search: Search took 1.24 seconds.

  1. I presume you aren't seeing any error from...

    I presume you aren't seeing any error from WriteAllText(). So weird. Well, you know, what you are doing in your working code is undoubtedly nearly identical to what wrterAllText() does behind the...
  2. Just for grins... Try: string FilePath =...

    Just for grins...

    Try:

    string FilePath = Server.MapPath("~/Files/");
    string fname = FilePath + FileName;
    File.WriteAllText(fname, FileContent);

    And use the debugger to find out what the...
  3. It's called CDOSYS. There are *TONS* of...

    It's called CDOSYS.

    There are *TONS* of options with it. And even the simplest is more complex than CDONTS.

    But it's not too hard for simple tasks.

    Here's the skeleton of what I use:

    ...
  4. Replies
    1
    Views
    61

    You could create your own database-based...

    You could create your own database-based "session" variables. Same as ASP.NET can do it. Otherwise have it work as do normal session variables: Encrypt the key to the session and put it in a...
  5. Replies
    1
    Views
    88

    You can *EITHER* use aliases OR just use the...

    You can *EITHER* use aliases OR just use the table names. Aliases are for convenience, only.

    For this query, though, where the heck does the table names (or aliases) "consnr" or "a_buyer" come...
  6. This part makes no sense: ' WHERE content_id = '...

    This part makes no sense:
    ' WHERE content_id = ' + cast(@rfid as nvarchar(100))
    Assuming that content_id is an INT field, then why would you want to compare it to an NVARCHAR value? SQL Server...
  7. Cursor to memory is just RS.CursorLocation =...

    Cursor to memory is just RS.CursorLocation = adUseClient

    I think adUseClient is 3.
  8. Okay. Are you aware that a recordset can be...

    Okay. Are you aware that a recordset can be disconnected? That is, after you have the recordset in memory (you have to move the cursor to memory to do that...I forget the exact code, as it's been...
  9. It really depends on your real world. In the...

    It really depends on your real world. In the simple example you gave, where you use ORDERS and CUSTOMERS, it is clear that there MUST be a customer record for every order record (and of course could...
  10. SHAME ON ME! i utterly missed the fact that you...

    SHAME ON ME! i utterly missed the fact that you are using two different DB systems!

    UGH!

    You know, there might be a way to do this pretty efficiently! Even the sort you wanted, at the end....
  11. SUGGESTION: Never use a DB field name "ID". ...

    SUGGESTION: Never use a DB field name "ID".

    Instead, always prefix "ID" with the name (or shortened name) of the table.

    Thus I would have custid in the customers table and orderid in the...
  12. HORRIBLE HORRIBLE! NEVER use a SQL query...

    HORRIBLE HORRIBLE!

    NEVER use a SQL query inside of any kind of loop. Learn to build more complex SQL queries.

    And use SQL to do your sorting/ordering.


    SQL = "SELECT O.id, C.customer_name...
  13. This code is also so very old that it's nearly...

    This code is also so very old that it's nearly ancient. It really needs a complete rewrite. And a *LOT* of simplification.
  14. I think you are doing it all wrong. Your...

    I think you are doing it all wrong.

    Your function checking_icaptca() is a waste of code.

    You are already setting SESSION("code") so just let "save.asp" check that against the user's code value...
  15. Replies
    3
    Views
    200

    And would you care to show how? Remember, using...

    And would you care to show how? Remember, using ASP code, only.
  16. That should read = '" & search & "'" at the end.

    That should read
    = '" & search & "'" at the end.
  17. Maybe like this? SQL = "SELECT * FROM...

    Maybe like this?


    SQL = "SELECT * FROM sometable WHERE LEFT(somefield," & LEN(search) & ") = '" & somefield & "'"

    But I would bet that if you go back to ".mdb" that the % will start working.
  18. You can try, but you'd almost surely get more and...

    You can try, but you'd almost surely get more and better answers in an Oracle-specific forum.
  19. Did you try saving the database as an...

    Did you try saving the database as an old-fashioned ".mdb" file? So far as I know, JET doesn't really understand ".accdb" files. There's no advantage to saving in the latest format, in any case. ...
  20. Replies
    3
    Views
    248

    Why did you use Request.QueryString instead of ...

    Why did you use Request.QueryString instead of
    cmd.Parameters.AddWithValue("@strEmail", UserEmail.Text)???

    That query string is only going to work if you see
    ?UserEmail=john@abc.com (or...
  21. The answer is actually (sort of) on this site. ...

    The answer is actually (sort of) on this site. Wasn't easy to find, but...

    http://www.4guysfromrolla.com/webtech/102998-1.shtml

    There, he is running the batch file "ping.bat" from ASP code. ...
  22. Replies
    1
    Views
    412

    I would *GUESS* that the valule of attribute is:...

    I would *GUESS* that the valule of attribute is:

    (a) wrong. Maybe you are using a relative path that is wrong. Maybe you should be using an absolute path (that is, starting with a / character). ...
  23. Replies
    3
    Views
    248

    Ignore the blue line. What happens when you RUN...

    Ignore the blue line. What happens when you RUN the code?

    Anyway, I don't understand this sequence, *AT ALL*:


    Dim Sql As String = "SELECT strEmail FROM university (strEmail) WHERE...
  24. Well, the docs say that the value returned is a...

    Well, the docs say that the value returned is a LONG (long integer).

    But VBScript does not support long integers. (The CLNG() function only produces 32 bit integers, which were long integers in...
  25. Do you want the answer in SQL or in VBScript...

    Do you want the answer in SQL or in VBScript code?

    It's nearly the same thing.

    VBScript:

    diff = DateDiff("s", starttime, endtime )
    diff = TimeSerial( 0, 0, diff )
    ...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4