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!

Register Log in
  • 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: bamundsen
  • Content: Threads
  • Order by date
  1. bamundsen

    How to troubleshoot a Microsoft VBScript compilation error '800a03e9'

    While running a page, I received the following error: Microsoft VBScript compilation error '800a03e9' Out of memory /shopadmin1.asp, line 0 Once this error occurred every product page generated the same error. i looked up the error code and the common solution was to make sure that any SQL...
  2. bamundsen

    Import text file not working

    hello: I am trying to replace a string of data in one column of one table. I exported the data into a text file, made the required changes to the text file, and tried to import the changes using DTS. I am getting a "violation of primary key constraint PK_products" error. I am not updating the...
  3. bamundsen

    PHP 5.2.5 / MSSQL Error

    Hello: I am definitely a newby, so I apologize for any frustration! I am migrating from windows 2000 to 2003. We have a web server and a sql server. There is one PHP application we run that requires access to the SQL database. It works fine on the old 2000 Server, but will not work on the new...
  4. bamundsen

    Newbie Help - cname mapping

    Hello: We currently host our own DNS (windows 2000 server) and have decided to use GoDaddy for email hosting only. On their website, they say you need to do the following if you need to retrieve email messages from GoDaddy but host your DNS elsewhere: --------------------------------- If...
  5. bamundsen

    Popup Window within response.write statement

    Response.Write(tablerow & tablecolumn & langCheckoutCVN & tablecolumnend & "<td><input size=3 name=strOcardCVN value=" & Chr(34) & strOcardCVN & Chr(34) & "><a href='popup_page.asp' class='ccCSV' onClick='window.open(this.href, 'popup_page'...
  6. bamundsen

    MS Excel - Setting value after decimal to .95

    Hello: I have a spreadsheet of numerical values. I have a simple formula where C1 = A1+B1. If A1 = 5.59 and B1 = 6.32, is there any way to make the total equal 11.95 instead of 11.91? I would always want the value after the decimal point to be .95 Any help or ideas would be greatly...
  7. bamundsen

    Sub Domain Help

    Hello: We recently created a wordpress blog for our website. Wordpress offers domain mapping that will redirect blog.ourdomain.com to ourblog.wordpress.com. For the redirect, wordpress says to add the following CNAME record to our DNS: blog 14400 IN CNAME ourblog.wordpress.com.. We run our...
  8. bamundsen

    Data disappearing after nightly backup

    Hello: Windows 2000 Server/SQL Server 2000 Two nights ago I noticed that data was disappearing from our ORDERS table after our nightly backup routine. We have approximatley 60000 records in the table. After the backup, all records from 1 - 55600 have been deleted. I have looked through log...
  9. bamundsen

    Query problems

    Hello: Here is an example of my data: catalogid item_desc sell_price item_cost 1 black widget 25 5 2 black widget 25 5 3 green widget 20 3.5 4 green widget 20...
  10. bamundsen

    Network Migration - Lower the TTL

    Hello all: Out data center is forcing us to move to a new IP block, and we host our own DNS Servers, 2 Web Servers and 1 SQL Server. I am unsure how to lower the TTL on the DNS servers so the other Windows 2000 servers will resolve the new DNS. FYI: the two DNS servers are Windows 2000 Advanced...
  11. bamundsen

    SEO Question

    If have a page that has 2 <HTML> tags, 2 <BODY> tags, & 2 <head> tags. Will spiders crawl a page with duplicate tags, or will a spider jump off the page? This is happening because I am running an asp site that has #include files which have HTML tags in the code. The product pages also have HTML...
  12. bamundsen

    Crystal 8.0 Enterprise Web Management Console

    Hello: I had an issue on my server (win 2000) that required a reinstall of IIS 5.0. Unfortuanteley, I did not copy enough info down regarding our Crystal configuration. I cannot access the Crystal Management Console via: http://<our web server>/crystal/enterprise/admin I am a complete newbie...
  13. bamundsen

    Excel Formula help

    Hello: I have a column of year ranges like this: Year 1999-1999 1990-1997 2005-2005 I would like to convert any year ranges that are identical such as 2005-2005 to 2005. Currently I run a Find/Replace, but I have year ranges all the way back to 1965. Is there any way to do this w/an excel...
  14. bamundsen

    IIS Error

    Hello: I am receiving the following 2 errors in the event viewer. I am running IIS 5 and Windows 2000 w/front page server extensions. Error 1: Microsoft FrontPage Server Extensions: Error #3005f Message: Unable to read configuration for Microsoft Internet Information Server...
  15. bamundsen

    #include file vs. virtual

    I have taken over an ASP website on IIS 5 that is very very messy. All files are at the root level, and there are 1000+ files. I would like to sort out the .asp & .htm pages by manufacturer and put them in their own directories. However, when I place a file in a directory the include files do...
  16. bamundsen

    Sub Domain

    Hello: I have a website we will call website.com. How can I create a sub domain such as testing.website.com? I want the outside world to be able to resolve this IP. I run windows 2000 Server and IIS 5. Thanks, Brett
  17. bamundsen

    Import .txt file to SQL

    I have a table which is structured as so: ID data1 data2 == ===== ===== 1 sample00 sample 2 sample01 sample ID is my PK. I have exported out the data from the table into excel and made changes to the data1 column. The table now looks as such: ID data1...
  18. bamundsen

    Duplicate Rows: Delete Both Duplicate rows

    I have a spreadsheet which contains two columns, make and model. I need to delete all duplicate rows. I have searched the forum, but have only found examples of deleting or flagging only one of the duplicate rows. Spreadsheet example: make model ==== ===== chev camaro chev camaro chev...
  19. bamundsen

    Duplicate records

    I have a table that contains duplicate records. I need to identify the duplicates and remove them. Table example: UniqueID YearID VehicleID ====== ====== ========= 001 41 1 002 39 2 003 40 3 004 41 1 005...
  20. bamundsen

    Excel: Sort by Font Type

    I received a spreadsheet which contains part # updates. Unfortunately, the sender marked all new or modifed part #'s with bold font (the entire row is in bold). Is there anyway I can sort the spreadsheet by font type or return a value of 1 if a cell has bold font? Thanks, Brett

Part and Inventory Search

Back
Top