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

    Cisco 1600 Connectivity Issues

    Thanks Burt! Can you post how to do the recovery and I will try it out tonight? Also, should this be done via TCP/IP or direct through a terminal cable?
  2. 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...
  3. SWTpaul

    #Error with MonthName within IIF clause

    Month(Now) would return 11 for the current month of November. I am using Month(Now) + <#> because I am using a report format that starts with the current month (currently November), and then lists the next 11 months. The 4th column would be Month(Now) + 4, returning 15. The IFF clause would...
  4. 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...
  5. 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...
  6. 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...
  7. SWTpaul

    Operation is not allowed when the object is closed.

    Excellent... thank you... that was the next step.
  8. 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 =...
  9. 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...
  10. SWTpaul

    Pulling data from a namespace?

    Thanks! That worked... :)
  11. SWTpaul

    Pulling data from a namespace?

    Link to code: http://xml.weather.yahoo.com/forecastrss?p=90230 <?xml version="1.0" encoding="UTF-8" standalone="yes" ?> - <rss version="2.0" xmlns:yweather="http://xml.weather.yahoo.com/ns/rss/1.0" xmlns:geo="http://www.w3.org/2003/01/geo/wgs84_pos#"> - <channel> <title>Yahoo! Weather -...
  12. 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...
  13. 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...
  14. 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...
  15. SWTpaul

    Error inserting a new record to mySQL

    Looks like I will have to resort to SQL statements... those work just fine. Yes, Line 51 was working, a record was being inserted everytime... :o\ Thanks for the tips.
  16. SWTpaul

    Error inserting a new record to mySQL

    I manually set the variable in the code to a simple string like "this is some text" to test it out... and it still gave an error. :o\
  17. 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...
  18. 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...
  19. 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...

Part and Inventory Search

Back
Top