How can these both show as Saturday? 12/31/04 was a Friday. It's messing up my reporting...argh!
Response.Write "<br>Dec 31 " & WeekdayName(weekday(12/31/04),7)
Response.Write "<br>Jan 1 " & WeekdayName(weekday(1/1/05),7)
TIA,
Jessica [ponytails2]
Hi!
Not sure if this is the correct forum. Didn't see one for Terminal services.
We have TS2003 with MSN Messenger 6.2 installed. We can all log in & communicate with each other internally, as well as with external Messenger users.
All seems well, as I'm busily working away, I glance down...
I have a program that creates msn-like alerts on certain conditions. So a little form pops up in the lower-right hand corner. The problem is, if I'm typing in another app, the popups are taking focus.
I tried to use the setwindowpos and flag swp_noactivate, but it's not working. Is there...
Hi!
I have gotten some great code snippets from this forum. What I'm doing is searching for an IE window that has a particular title & bring it to the front. (Intranet app, so title should always be the same) If it's not open, open it.
What I'm looking for now:
Now that I have the window...
Hi!
A few people are having problems sending an email from my registration page. Not everyone is having a problem. I haven't been able to discern a pattern as of yet.
Any ideas would be appreciated!
The error is as follows:
The page cannot be displayed There is a problem with the page you...
I have a page that is returning a record set based on a sql query.
Is there a way to pass this recordset to a stored procedure for manipulation?
TIA
Jessica [ponytails2]
Hi!
I have a cool htm file that uses javascript to open another htm page based on what you type in a text box.
I'd like to do the same to open an asp page from what I type in a text box.
Reason why I want this:
1. remote debugging of customer site
2. do not have ftp access, and they do not...
Hi!
My query is:
select l.label
from listbox l
where l.fieldname = 'Municipality'
and l.value in ('rams','ak','cret')
I'm looking for the easiest way to display the records in the same order as 'rams','ak','cret'. Currently it sorts them in alphabetical order of l.label.
TIA!
Jessica...
Hi!
I've searched for this, and have found a few issues that relate, but still not able to resolve this.
I have 3 tables: problems, project_phases and phases.
problems--> project_phases (left outer join)
project_phases --> phases (left outer join)
This shows me all the records I want...until...
Hi!
I'm working with a remote customer site, so am unable to test things at will. I'm hoping someone can give me a direction.
I have an include file which has this:
function calText(elTarget)
if (showModalDialog) {
var sRtn;
sRtn= showModalDialog("<% response.write...
Hi!
Here's the setup:
Physical webserver1 running SQL server "A"; db1
Physical webserver2 running SQL server "B"; db2
They are networked together.
I need to create a DTS package that will copy a table from db1 to db2.
I know how to do it if the dbs were both in the same...
Hi! Would normally search for this...
I have a stored procedure where one of the parameters is used in an IN clause. I want to pass a comma delimited list to the sp. Like:
exec sp_test "'val1','val2','val3'"
CREATE PROCEDURE sp_test
@proptype varchar(100)as
select p.uid,
from prp...
Try this, notice I changed the select options values
function doThis(obj) {
// user already viewed one anchor so just replace the info
if (location.hash != "") {
location.hash = obj.options[obj.selectedIndex].value;
loc = parent.location
}
// user hasn't selected an...
Hi!
I have one page that has a div which has information in it. What I'd like to do is open a new window & output the div's contents to the new window.
Is this possible?
Also, If I output information to a div that I have hidden, does this affect the rendering time to the browser? I have a...
Hello!
Ok, I think I understand the clustered vs non & single vs composite.
Now I'm working with a table that already has indexes defined. And I'm just trying to determine if I need to add another one or not. (my forte is not SQL!)
Question 1:
So, here's what exists:
INDEX Uid on Uid...
Hi!
I can't seem to find an answer for this...
I'd like to have one txt file with multiple variables in it, like:
a=blah blah
b=more blah
c=even more
d=etc
Right now, I have the file loading & created the dynamic text boxes, but it only seems to recognize the first variable. For example...
Thanks to this forum, I've managed to get the last log(s) records based on max(date) grouped by uid. Results are below. The only (!) problem I have now is you'll notice the first two rows are for the same uid, and they also have the same date, BUT I need to have only 1 final result for each...
Hi! I've successfully used the case statement with character fields but am having trouble with numbers.
select case c.label
when 'sold'
then c.label + ' Units'
when 'pending'
then c.label + ' Units'
else
'Cancelled/Expired/Withdrawn'
end
as type...
I'm trying to perform a mail merge with word and have found several examples here and on Microsoft's site. My problem is I'm getting a run-time error '48' when trying to run this basic code.
Option Explicit
Dim wrdApp As Word.Application
Dim wrdDoc As Word.Document
Private Sub...
Palm - 3.5.0
Desktop - 4.1
Hotsync - 3.1.1
I just upgraded my palm desktop software to 4.1 and the hotsync to 3.1.1.
Now, when I try to install a file I get:
INSTAPP.EXE is linked to missing export file userdata.dll -154
When I try to hotsync - it gets through the data and then fails saying...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.