Search results for query: *

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

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

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

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

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

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

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

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

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

Ok folks here is my challenge (and yours I hope). What I really want is some nuddging toward a solution, not so mush the code to accomplish it. Below is a simple dynamic drop down list that provides a visitor with all of the product line of company Y. Here is the wrench, I want to format the...

I think I've been cursed from javascipt because I am almost always unable to run even the simplest of routines. I will now publicly profess my incompetence in this langauge. I can not get the rollovers to work. It so simple yet I can't figure it. Please help. I pasted whole page just incase I...