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 derfloh 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: AnthonyJ20
  • Order by date
  1. AnthonyJ20

    SQL Connection Error

    Thanks for the response guys. Your thoughts helped me get past that error. But now toward the end of my code, just before diplaying records, I get this error. Server Error in '/WebApplication1' Application. --------------------------------------------------------------------------------...
  2. AnthonyJ20

    SQL Connection Error

    Hope someone can help me. I'm having a problem making a connection to an SQL Server database using .Net. This is the error Server Error in '/WebApplication1' Application. -------------------------------------------------------------------------------- Compilation Error Description: An error...
  3. AnthonyJ20

    Removing projects from project view

    Thanks jbeson001! Man, it would really help is Microsoft included this feature.
  4. AnthonyJ20

    Removing projects from project view

    Yes. How do you do that?
  5. AnthonyJ20

    Getting an error message

    Thanks adamroof. That did the trick.
  6. AnthonyJ20

    Removing projects from project view

    Does anyone know how to delete an existing project from the projects view window in .Net?
  7. AnthonyJ20

    Getting an error message

    Thanks for the response. I did see those files in the WebApplication1 directory. Here is the code to the .vb file. What do I need to edit in this file? WebForm1.aspx.vb Public Class WebForm1 Inherits System.Web.UI.Page #Region " Web Form Designer Generated Code " 'This call is...
  8. AnthonyJ20

    Getting an error message

    Hello, I hope someone can point me in the right direction. I'm in the process of learning how to use ASP.Net. Currently I have a web application that's all ASP. I'd like to port it over to .Net but I'm have some problems. For example, I'm getting this error when I try to view a .Net page that I...
  9. AnthonyJ20

    SQL Challenge

    Got it 10091976. I'll give it a shot.
  10. AnthonyJ20

    SQL Challenge

    Just a bit more info. The variables MyDate and MyDate2 are request.form objects that get their values from dates I pick from a calendar. If I want to see data for Oct 1-17 I pick 10/1/2005 as my start date and 10/17/2005 as my end date. You mentioned changing the date range to something earlier...
  11. AnthonyJ20

    SQL Challenge

    Just one more question 10091976. The SQL is working fine, but it's showing only the previous month's data. Can the function be switched so that the Current month is displayed while still containing the data from the previous month?
  12. AnthonyJ20

    Using DatePart or DateAdd functions

    It sure did!! Thanks, that's just what I was looking for.
  13. AnthonyJ20

    SQL Challenge

    10091976, Thank you!! Man you saved the day. My hat off to you as well DotNetGnat for sticking with this as long as you did in your efforts to assist. You guys are awesome!
  14. AnthonyJ20

    Using DatePart or DateAdd functions

    Hello, I have a question. Can either the DatePart or DateAdd functions be used to automatically get the first day of a previous month? For example, when the month rolls over from one to the next, as in the case of September to October, how can either of these functions be used to present the...
  15. AnthonyJ20

    SQL Challenge

    Don't give up just yet. I tried what you suggested, commenting out the line. But still the same error. Can this thing be beaten? Microsoft VBScript compilation (0x800A0401) Expected end of statement /NewPercentSpreadSheet.asp, line 47, column 97 & "Where ((CustomerBoxes.CustomerID =...
  16. AnthonyJ20

    SQL Challenge

    You know this is killing me that it's so close. Still the same error. Error Type: Microsoft VBScript compilation (0x800A0401) Expected end of statement /NewPercentSpreadSheet.asp, line 50, column 87 & "Where ((CustomerBoxes.CustomerID = tblDataTableNew.DataTable) AND (VolDate BETWEEN...
  17. AnthonyJ20

    SQL Challenge

    I forgot to mention that I tried responsing the sql so that I could see it but the error stops is short of that.
  18. AnthonyJ20

    SQL Challenge

    Okay, here is the error that came back. Expected end of statement /NewPercentSpreadSheet.asp, line 50, column 83 & "Where CustomerBoxes.CustomerID = tblDataTableNew.DataTable AND VolDate BETWEEN "#"&DateAdd("m",-1,#" & MyDate & "#)&"#" AND "#"&DateAdd("m",-1,#" & MyDate2 & "#)&"#" AND FullPay +...
  19. AnthonyJ20

    SQL Challenge

    It's got to be close now. I'm getting an expected end of statement error. What am I missing? Sql = "SELECT * from CustomerBoxes,tblDataTableNew " _ & "Where CustomerBoxes.CustomerID = tblDataTableNew.DataTable AND VolDate BETWEEN DateAdd("m",-1,#" & MyDate & "#) AND DateAdd("m",-1,#" &...
  20. AnthonyJ20

    SQL Challenge

    DotNetGnat, is the mm in the DateAdd function for calling up a month? If so that may be part of my problem since I don't have a field in the table for the month. Of course I could be way wrong.

Part and Inventory Search

Back
Top