Search results for query: *

Thanks, that worked!

All of our phones in the office previously had the same one-touch dialing configuration. My goal was to have only one-touch extensions for people on my team. After I set all new one-touch extensions, when any of the new people I added has their phone picked up, their light on my phone doesn't...

I'd let to set content expiration for a reason other than normal: We need clients to cache a specific page for a period of time. We're doing this for bandwidth issues. So basically, the question is, if I set this for 14 days, how do the clients know when 14 days is up? The machines that are...

Here is what works, without using the calendar dates database: While ((Repeat3__numRows <> 0) AND (NOT rs_events.EOF)) dim dStartDate, dCurrentDate, dEndDate dStartDate = cDate(rs_events.Fields.Item("f_datestart").Value) dCurrentDate = dStartDate dEndDate =...

Here is my current code, which is looping through the start and end dates. I suppose I could get confused if I have to loop through these within the current loop statement, so if I have to do that, I may need some assistance with that also: While ((Repeat3__numRows <> 0) AND (NOT...

OK, so I have a table with only a single field (f_dates), and that field is set as the primary key. I'm not concerned about holidays or weekends, as it is just a calender to highlight "regional events". Now my primary question, is since all of my events are in a separate database, once I...

Ooooh...gotcha'. So that code was to automatically create and populate the SQL database. Any idea where I could find an Access database with those dates already populated? Otherwise I guess I could use Excel to fill down a number of years and import that into Access.

That was so ridiculously over my head that I can't even see it. I'm not even sure what it was talking about. I think that might be WAY too much for me to do.

I have a database where there is a "Start Date" and and "End Date" of an event. I need to get all the days between those two days. The reason I need this is because of a calendaring application where I'm highlighting days where events occur. Here is my current code, which loops and highlights...

onpnt, I have a question regarding what we talked about. I have moved my queries from ADODB.Recordset to ADODB.Command to prevent SQL injection, so how do I specify the CursorType and LockType now? Here is my new SQL query: =========================== <% Dim rs_attractionscat Dim...

I've printed it out, and will be storing it under my keyboard to take home over the weekend, thanks. And thanks also for all the help today, you've saved both my forehead and my keyboard a lot of unnecessary pain.

I really wish you could edit posts here. I mean "So in theory, could LockType set to 1 be used to prevent SQL injection attacks?

So in theory, could LockType set to 0 be used to prevent SQL injection attacks?

Sorry, I meant "even if I leave LockType to 1.

OK, so it works even if I leave LockType to 0, but change CursorType to 3. What are the implications of this? I'm not trying to be difficult, I swear, I'm just trying to learn as I go.

So what you have above is not correct then? CursorType and LockType need to be 3?

How do I display the number of records in a recordset? The reason I ask is because I need to determine if a recordset contains only 1 record, and if it does, then display a different heading, say "Records" versus "Record". Here is my SQL query: ================================== <% Dim...

Haha, well following the quote in your signature, I appear to have made it work with your code: <% If (request.QueryString("contact") = "" AND request.QueryString("contactcomplete") = "") Then %> When I hit this page, I get the ratings: http://portal.thinix.com/attractions.asp?ID=4 When I...

That's mightly close, except that the "Ratings System" doesn't show when the querystring only contains ID: http://portal.thinix.com/attractions.asp?ID=1 Believe me, I appreciate the help you gave even without your coffee.

OK, now I'm thoroughly confused. So you appear to be correct: http://portal.thinix.com/attractions.asp?ID=1&contact=yes&contactcomplete=yes DOES NOT DISPLAY RATINGS http://portal.thinix.com/attractions.asp?ID=1&contact=yes DOES DISPLAY RATINGS...