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

Search results for query: *

  • Users: Mdiaz
  • Order by date
  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

    ...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 seesion variables that I created in the login.aspx page. I made sure that 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

    ...= New System.Data.SqlClient.SqlConnection(connectionString) Dim queryString As String = &quot;SELECT * FROM [Agency], [Users] WHERE (([Users].[UserLogin] = @UserLogin&quot;& _ &quot;) AND ([Users].[Pass] = @Pass)) AND ([Users].[DeptID] = [Agency].[DeptID])&quot...
  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...
  16. Mdiaz

    how to determine auto generate key on insert

    Here is a snippet: <%set rs = Server.CreateObject(&quot;ADODB.Recordset&quot;) sqlstatement=&quot;Select * FROM table&quot; rs.Open sqlstatement, &quot;DSN=dbName;UID=;PWD=;&quot;,1,3 rs.AddNew rs(&quot;column1&quot;)=request.form(&quot;frField&quot;)...
  17. Mdiaz

    Public scope?

    Tarwn, I know you were not criticizing. I do remember reading something about others being able to view the contents of an include file. Do you mean that someone can view a .inc file? If I want to use an asp page for the same purpose do I then just name my include file Something.inc? With a...
  18. Mdiaz

    I need some opinion and comment.

    I use a fileupload component to upload files. I have used: SAFileUp; by softartisans.com ASPUpLoad; by persits.com Both of these have extensive properties and methods which allow a user to upload a file. If a file with an existing name already exist then it cancanates a &quot;(1) to the file...
  19. Mdiaz

    I need some opinion and comment.

    I would dump uploaded files into a single directory or maybe a select few. Keep in mind that the power of your database can be used to administer files and do house keeping. For example, files that need to be pitched after two years can filtered and deleted using a query. The DB knows where the...
  20. Mdiaz

    Public scope?

    Tarwn, Don't know exactly, maybe it was the way I was brought up... Just kidding. Thats the way I have always used it. No other reason. I'll research and maybe learn something new.

Part and Inventory Search

Back
Top