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

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

    Cisco 1600 Connectivity Issues

    To start I am not well versed in Cisco products or technologies relating to WAN. We have a Cisco 1600 at the main office, and a 1600 at the warehouse. There were strange connectivity issues a couple months ago, and now the demons have come back. There have been no network configuration...
  2. SWTpaul

    #Error with MonthName within IIF clause

    I am a little baffled with this error... here is my code: =IIF( Month(Now)+7 > 12, MonthName(Month(Now)+7-12), MonthName(Month(Now)+7) ) If I change it to... =IIF( Month(Now)+7 > 12, MonthName(Month(Now)+7-12), Month(Now)+7 ) ... it will return the month name if the condition is true...
  3. SWTpaul

    Turning Multiple Rows Into Single Row/Multiple Columns

    I have a Forecast table that has the the previous year, current year, and future year forecast figures for items. I have a query that simply returns the current month forecast and the future 11 months. I need to be able to create a report that will list one row per item with the quantities in...
  4. SWTpaul

    Updating SQL Tables from another DB

    Our main box is an IBM iSeries which is used for all our business applications. I have been able to use DTS to copy the tables I want and push them into MS SQL Server. The problem is, if I run the same DTS it will insert the same records into the tables, creating multiple records (that I don't...
  5. SWTpaul

    Operation is not allowed when the object is closed.

    I get the following error: Operation is not allowed when the object is closed. It points the the line that reads: While Not Rs.EOF Sort of baffled, I don't know why the recorset would be closed?! Dim sZipCode, sMiles sZipCode = "91403" sMiles = 5 Set MyConn =...
  6. SWTpaul

    Inserting XML date in IMG tag in XSL doc

    The following code returns a number. The number is the name of a picture (ie 32.gif, 33.gif, etc) <xsl:value-of select="//yweather:condition/@code"/> My question is, how can I insert the number in the IMG tag (see red code in the main XSL document)? So it would read like so... <img...
  7. SWTpaul

    Pulling data from a namespace?

    I am pretty much new to XML and all that goes with it. I want to put the current weather on our local intranet. The following XML file contains all the data I need, and then some: http://xml.weather.yahoo.com/forecastrss?p=90230 The following contains what I want to extract...
  8. SWTpaul

    Simple String problems...

    The ItmCls is retrieved from the previous page, and equals RRXXX. String webCls = request.getParameter("ItmCls"); String itmCls = webCls.substring(0,2); if (itmCls == "RR") { <perform actions here> } else { <do this> } Some reason the condition will not test true. I have outputed itmCls...
  9. SWTpaul

    While condition not looping...

    Some reason the WHILE condition will not loop while the 3 functions (highlighted) are there. If I comment out the functions like so (]<%'=sQtyPrior1(sItemNo)%>), the while loop will work. When it is not commented it will display the information for the first record, then gives the following...
  10. SWTpaul

    Error inserting a new record to mySQL

    I receive the following error... doing a little Google searching it supposedly means the data being inserted is longer than the set value of the table field. I set the field to varchar(255) and it still gives an error no matter what. I added Trim() around the variable for giggles, and that...
  11. SWTpaul

    FTP not accepting Logins

    Platform: Win2k Server Components: Active Directory I have added 3 accounts to the FTP Site Operators, and unchecked Allow Anonymous Connections. When I go to the FTP site its prompts me to login, so I tried the 3 accounts (and my administrator account), but the FTP site does not recognize the...
  12. SWTpaul

    Opening a project other than one I created does not work

    For some reason if I create a project and save my work... I can go into my project folders and just double-click the SLN file and it opens my project. If I try to do the same on a project that was created on another computer (same version of VB.Net), it opens VB but the project does not open...
  13. SWTpaul

    Combining similar items into one amongst many items

    I have a few products amongst about 1,000 that have extensions to the item #, such as DF and SP. Is there a way to find those items that have multiple item #'s and combine their data? Such as... MICROWAVE 4400924 $1,920.25 MICROWAVE 4400924DF $1,195.13 MICROWAVE 4400924SP $1,241.29...
  14. SWTpaul

    AS/400 CPYTOIMPF Help Needed

    I am trying to output a file, but have ran into a few things. The command I am using is as follows: ===> CPYTOIMPF FROMFILE(BRANDNEW/CARCODE) TOSTMF('QIBM/CARCODE.TXT') MBROPT(*REPLACE) RCDDLM(*CRLF) FLDDLM('|') Problems: 1) The output file that is created is in ASCII characters. I noticed...
  15. SWTpaul

    MySql service will not start

    I installed MySQL and MyODBC on a Win2k server, got it all working fine. Created a database and tables, pulled all information through ASP files. Just randomly MySQL stopped. I went to Services and tried to restart it... it attempts to start but fails. Event View gives no cause, just says...
  16. SWTpaul

    OWA - Some e-mails are not viewable

    In some message, they give a IE error, saying the page doesn't exist. Of course when viewing through Outlook the e-mail is there. I can't seem to find a trend with the unviewable e-mails in OWA... anyone have an idea on why OWA can't display some of these e-mails?
  17. SWTpaul

    W3SVC error

    Yesterday the Exchange Server was having a beep come every few seconds, and finally a BSD that linked to the HAL.DLL file. Restarted the server and everything worked fine... This morning Exchange was not working, checked event logs, and got the following information... Event: 101 Source...

Part and Inventory Search

Back
Top