Search results for query: *

Greetings: I'm trying to figure out how to Select a record from an Access 2002 database with SQL by identifying from the date field (rDate), the first date that exists prior to today's date. Has anyone dealt with this that could steer me in the right direction?

I'm having a problem updating my Access 2002 db using an ASP variable whose value is provided from a form text box. If I simply use the following, the db is updated correctly with the number 5. Set conn = server.createobject("adodb.connection") conn.connectionstring = "DRIVER={Microsoft Access...

I am running the following in an ASP page and it works perfectly: <% dim Rdate dim PrevRdate Set conn = server.createobject("adodb.connection") conn.connectionstring = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=C:\tradersreportsdata\reportevents.mdb;pwd=matrix" conn.Open Set...

I'm trying to write an SQL query that identifies today's date, and then provides the date range for that date's week, so I can return all my database records that fall in that week's date range and display them in my ASP page. Is there a way to do this? Regards

I'm trying to write an SQL query that identifies today's date, and then provides the date range for that date's week, so I can return all my database records that fall in that week's date range. Is there a way to do this? Regards

I am trying to query an Access 2002 database from my asp page and have the data in the 'Time' field displayed in the custom format that I designated when I built the Access table. I am using the following format in Access: h:nnam/pm to return 8:30am. When I query the 'Time' field from my page...

Greetings I am trying to write a string to a file using the following: dim ReportObject,ReportFile set ReportObject=Server.CreateObject("Scripting.FileSystemObject") set ReportFile=ReportObject.CreateTextFile(Server.MapPath("\reports\reportfile.asp")) ReportFile.WriteLine("<%@...