ASPDB

Results 1 to 4 of 4

Thread: ASPDB

  1. #1
    Join Date
    Dec 1969
    Posts
    428

    Default ASPDB

    Set Connection=Server.CreateObject("ADODB.Connection") <BR>Connection.Open "MyDsn"<BR>&#039Check for valid SalesID<BR>sql = " SELECT * FROM AE " & _<BR>"WHERE (SalesID = " & _<BR>salesID & _<BR> ")"<BR>i did this code but is not working correctly in order to verify the user ID against the database.<BR>any help.<BR>

  2. #2
    Join Date
    Dec 1969
    Posts
    2,849

    Default RE: ASPDB

    Do a Response.Write(sql) and see what your SQL string returns. Are you getting an error, or just not getting back the data you expected?

  3. #3
    Join Date
    Dec 1969
    Posts
    428

    Default RE: ASPDB

    Im not getting the data

  4. #4
    Join Date
    Dec 1969
    Posts
    2,849

    Default RE: ASPDB

    Are you sure that there exists rows in the database where SalesID = whatever you are looking for?


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •