Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jlsmithhartfiel

    Dec 31 04 & Jan 01 05 both show weekday as Sat

    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]
  2. jlsmithhartfiel

    Terminal Services 2003 and MSN Messenger Status says &quot;away&quot;

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

    form on top without focus

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

    Found window, now navigate to frame

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

    0x8004020F error sending email

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

    Pass a recordset to a stored procedure?

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

    asp page to generate another asp page?

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

    Keep order of &quot;field in (list)&quot;

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

    Missing records - 3 table join

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

    Variable is undefined: 'Session'

    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(&quot;<% response.write...
  11. jlsmithhartfiel

    export data from physical svr 1 to phys. svr 2?

    Hi! Here's the setup: Physical webserver1 running SQL server &quot;A&quot;; db1 Physical webserver2 running SQL server &quot;B&quot;; 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...
  12. jlsmithhartfiel

    Sending multi-values in one param to sp

    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 &quot;'val1','val2','val3'&quot; CREATE PROCEDURE sp_test @proptype varchar(100)as select p.uid, from prp...
  13. jlsmithhartfiel

    How to connect anchors to drop down list?

    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 != &quot;&quot;) { location.hash = obj.options[obj.selectedIndex].value; loc = parent.location } // user hasn't selected an...
  14. jlsmithhartfiel

    write div contents to another window?

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

    Index usage question

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

    Load multiple variables from one txt file

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

    limiting record set

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

    using case in select with int field

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

    runtime error 48 with createobject(&quot;word.application&quot;)

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

    Can't hotsync after palm desktop &amp; hotsync upgrade

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

Part and Inventory Search

Back
Top