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 TouchToneTommy 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: *

  • Users: sinyce
  • Content: Threads
  • Order by date
  1. sinyce

    ASP from text file

    I have a simple asp splash page (default.asp) for my company website that requires constant update to the lower half. For example: Company Operational Status: No Work Tomorrow for Electricians, stay home OR Company Operational Status: Everyone is fired, stay home. The boss would like the...
  2. sinyce

    Query problem

    I have two tables Table 1 SALES LNUM AMOUNT ABC 101 100 ABC 102 200 ABC 103 450 XYZ 674 234 Table2 SALES LIMIT ABC 4000 XYZ 2000 Trying to write a Query to give me this result: SALES LNUM AMOUNT...
  3. sinyce

    Startup Script

    AIX 5.1 ML3 I've written a script called rc.local that is in the /etc folder. I would like this script to run upon startup after the CDE loads. Script is owned by root, and belongs to system with rwxrwx--- permissions Anyone can tell me what to do next? Sinyce
  4. sinyce

    Nokia IP350

    Help this is killing me: Just bought a Nokia IP350 with 4 interfaces ISP gives me a /30 block IP LAN1 172.17.30.0 Mailserver Clients NT Server DNS LAN2 172.17.31.0 Clients I've got DNS to work. How do I get HTTP? HTTPS. I cant get any web pages. Clients configured: Default G/W is the...
  5. sinyce

    Crosstab Report

    I have a table similar to the following: NAME APPLICATION JOE WINDOWS JOE OFFICE XP JOE WINZIP MARY WINDOWS MARY ADOBE MARY CRYSTAL BOB WINDOWS BOB NETSCAPE BOB WINZIP BOB ADOBE Trying to create a report that will look thus...
  6. sinyce

    DNS for Intranet web pages

    Scenario: Clients -->Internal DNS Server --->F/W ---ISP All my internal clients make requests to an internal DNS Server (NT 4.0) which forwards to the Firewall and that gets the pages from my ISP. Problem: How do I have my clients type in http://contacts and this can resolve to an internal...
  7. sinyce

    Excel Calc Days in Month

    Is there a way to calculate the number of days in any month? Like a canned formula? I've looked thru all none seems to return the days of month, eg =DAYSOFMONTH(MONTH())=30 (of course DAYSOFMONTH is not real)
  8. sinyce

    Dropped ICMP

    Checkpoint NG FP3 / Nokia IP350 Firewall with 2 subnets NET172 NET192 --- ROUTER | | F I R E W A L L Trying to configure a Server(SRV1) in NET172 to connect to router (RT1) in NET192. RT1 also handles DNS resolve for SRV1. RULE: SOURCE: SRV1 DESTINATION: RT1 ANY ANY...
  9. sinyce

    SMTP and Proxy

    Migrating to new CheckPoint NG FP3 Firewall. Have 2 Objects: NBMSW (Mailsweeper Server) NBPROXY (WebSweeper Server) These are configured both sit behind the current FW: For Mail:(inbound) FIREWALL ---->NBMSW -----> EXCHANGE 5.5 For HTTP /HTTPs Request: CLIENT --->NBPROXY ----> FW --...
  10. sinyce

    Timesync Dilemma

    NetWare 5.1 Server with SP 5. Server is behind a Firewall which blocks ICMP / IGMP. Server cannot ping anything external, but UDP port 123 is open. So is there anyway to configure Timesync to point to an internal NT / W2K Server for its time? Or even an internal Unix server? Reason: I got an...
  11. sinyce

    Codes behind Menu

    Looking at an Access database left by an intern, the application launches with a Menu on top that goes like this: CRS EXTRACT CRS REPORTS CRS BACKUP EXTRACT GL Generate Report Backup Data EXTRACT SPOT Print Report EXTRACT RATES Save Report Is there anyway...
  12. sinyce

    Crosstab Query?

    I have an table in Access that looks like this: NAME APPLICATION JOE WINDOWS JOE OFFICE XP JOE WINZIP MARY WINDOWS MARY ADOBE MARY CRYSTAL BOB WINDOWS BOB NETSCAPE BOB WINZIP BOB ADOBE TRYING TO GET A QUERY TO DISPLAY THIS: NAME...
  13. sinyce

    Look up another table

    I have two tables: CUSTOMER TABLE CUSTID CCY AMOUNT TYPE 10001 USD 9.99 2 10002 CAD 8.88 99 10003 JPY 7.77 99 COUNTRY TABLE CUSTID 10001 99999 88888 ... The TYPE in [CUSTOMER TABLE] is set to 99 unless the CUSTID is present in [COUNTRY TABLE] then it is set...
  14. sinyce

    NDPS Printing

    I've looked all over Novell forum but couldn't find a hit that would allow some of my older Applications to print directly for the exact unc syntax. All my printers are NDPS Public Accessed, NetWare 5.1 Service Pack 5 and latest HPGATE drivers. All printers are HP 4000/4050/4100 with JetDirect...
  15. sinyce

    import table via ODBC

    Every day I import a table from our AS/400 using: File | Get External Data | Import | ODBC Databases | Machine Data Source [NYC400] Here I insert the Password and select my Table and I am done. This works beautiful. I'm trying to automate this with VBA code without any luck so far this is...
  16. sinyce

    DNS and Intranet

    I have an internal DNS running on NT 4.0 Client HTTP/s, WWW ---> Proxy -->F/W -- ISP Workstation browsers are pointed to a Proxy Server for HTTP/WWW requests, DNS resolves or forwards to F/W, F/W fetches from ISP / Internic. I've added a webserver on another segment of the network. Without...
  17. sinyce

    DNS and Intranet

    My configuration: Clients -->Proxy Server--->Firewall--->Internet Internal DNS / WINS / DHCP Now I've added an Webserver inside Firewall. How do I dynamically get DNS to resolve http://employees to my Webserver 10.2.2.2 (IP) I do this now via the host file on the workstation and configure...
  18. sinyce

    Print Report with No Records

    Every day I print a Report based upon a query. Some days the query returns no records, which I still want to print, but with a big text box or image file that says: "NO ENTRIES TO LOGFILE" somewhere in the middle of the page. I've tried to put a text box in the middle and set...
  19. sinyce

    failedlogin

    Every day I run a cron job to get the users who failed in their attempt to login to the RS/6000 (AIX 4.3.3.10): in the etc/security - #who failedlogin >login.txt This creates a text file of all the failed logins. The file is in 5 columns and a sample of two rows look thus: root pts/1...
  20. sinyce

    Query based upon Now()

    Every day I generate a report based on a query which uses the Now()-1 (on the DATE field) to only give me the events for the previous day only. Example of Table: DATE TIME EVENTID USERID SEVERITY 7/7/2002 09:05 644 MIKEYJ LOCKOUT 7/8/2002 11:06 644 JACKOJ...

Part and Inventory Search

Back
Top