Search results for query: *

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. --------------------------------------------------------------------------------...

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...

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

Yes. How do you do that?

Thanks adamroof. That did the trick.

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

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...

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...

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

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...

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?

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

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!

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...

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 =...

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...

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

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 +...

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,#" &...

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.