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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Mdiaz

  1. Mdiaz

    SQL statement issue

    Thanks for your help. OK, I made the changes and now I'm getting the following error: Invalid procedure call or argument: 'DatePart' Here is the entire section of code: If Session("ChapterID")<>"" Then sqlstatement="SELECT EventDate, detail FROM calendar WHERE...
  2. Mdiaz

    SQL statement issue

    I am having a problem with the following statement. Can you folks help out? sqlstatement="SELECT EventDate, detail FROM calendar WHERE (((DatePart('ww',EventDate))=" & datepart("ww",Date()) & " And ChapterID=" & Session("Chapter") & ")) ORDER BY EventDate" I am getting the following error...
  3. Mdiaz

    SQL statement issue

    I am having a heck of a time trying to figure out what is wrong with the following chunk of code. Maybe a new look at it from someone else might see the issue. Thanks... >>>>>>>>> CODE <<<<<<<<<<<<<<< Dim loConn, lsSQL, loRs Set loConn = CreateObject("ADODB.Connection") ' Open a connection to...
  4. Mdiaz

    How to break up query results

    Do any of you folks have any snippets of how to break up a query results onto several pages. You know, like only showing ten results and then providing a link at that allows the user to page through more pages. Thanks...
  5. Mdiaz

    problem sharing session state between asp and aspx

    I understand that you can mix traditional asp with aspx pages. I am trying to do that with a login page (now in aspx)that sets session variables whicj will allow users to enter restricted pages. Those pages are currently *.asp pages. For some reason the *.asp pages do not seem to get the...
  6. Mdiaz

    fetching a single row

    DigiDuck, Thanks for the help. It worked fine. Mike Diaz...
  7. Mdiaz

    User control issue

    I have created an *acsx file for my navigation. In it there is some logic for the log in button. In the old asp version I checked a session variable to see if user was logged in and if so to replace the log-in button with a log-out button. I am having problem trying to do the same in the asp.net...
  8. Mdiaz

    Formatting frames issue

    Chris, That is exactly what I'm trying to accomplish. I will study your code that utilizes the Iframe and css Float. Thanks for your help. I had given up on it. Again thanks... Mike Diaz
  9. Mdiaz

    fetching a single row

    I am an avid ASP programer, but I seem to be having problems getting thing done with asp.net. My first asp.net page is a login page where I check to see if the user exists, then if he exists I need to fetch data from two tables so that I can set some session variables. I can't seem to do it. I...
  10. Mdiaz

    Formatting frames issue

    I hardly ever use frames and I am working on a project that requires a page using frames. Please look at it and tell me where I've gone wrong. I can't seem to get everything to fit together nicely. I'm also going to try and use tables to format the layout. Thanks... view page at <A...
  11. Mdiaz

    Displaying colors in a dropdown menu

    To assign font colors do this: <html> <body> <form> <select name=&quot;colors&quot;> <option value=&quot;red&quot; style=&quot;color:red;&quot;>Red</option> <option value=&quot;blue&quot; style=&quot;color:blue;&quot;>Blue</option> <option value=&quot;green&quot...
  12. Mdiaz

    Getting records for week using DatePart()

    What would a SQL statement look like that retrieves records that fall within the current week, using the DatePart('ww',field) function? Thanks, Mike...
  13. Mdiaz

    Easy softball query

    Thanks Dave. Actually the fiels I want to update to the table is the EmployeeID. So I'll Just UPDATE tblPersonalRecords Set EmployeeID = t.EmployeeID from tmpTable t where t.SSN = tblpersonalrecords.SSN Again, tahnks, Mike Diaz...
  14. Mdiaz

    Easy softball query

    Here is an easy question, hope I don't affend you. I have a table = tblPersonalRecords that has a field &quot;SSN&quot; Have another table ( tmpTable )that I imported that has &quot;EmployeeID&quot; and &quot;SSN&quot; The tblPersonalRecords has the EmployeeID field added now I need to...
  15. Mdiaz

    Only 1 entry from SQL table gets returned onto the ASP page

    You need to filter only the records you want like: Inventory.Source = &quot;SELECT * FROM dbo.Inventory WHERE ProductMake ='&quot; & strTypeProduct & &quot;'&quot; Where strProductType = to the field that contains the type product. Mike Diaz...
See more

Part and Inventory Search

Back
Top