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 SkipVought 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: k8277
  • Order by date
  1. k8277

    Dynamic SQL - update with a double quote in my field

    The reason for the loop is because the actual code is not as simple as I made it seem.
  2. k8277

    Dynamic SQL - update with a double quote in my field

    Hello - I am building some dynamic sql and I have a problem with a field I am reading from a database that contains a double quote that I am then trying to include in some dynamic sql to update another table. Basically I have this problem: create a recordset by selecting * from table A loop...
  3. k8277

    Call stored procedure in another database

    I am stuck here. I have 3 databases, A, B and C. Databases A & B contain my data for two different locations. Database C contains my custom stored procedures and functions. I would like to be able to call a stored procedure which resides in database C from database A. I want the stored...
  4. k8277

    Display additional announcements

    Thanks, That does work, however it changes the formatting and turns the data into a list of items instead of the default announcement display. Is there anyway to have it not change it to a list format. We are including images in the body of the announcement and when I make your change, they...
  5. k8277

    Display additional announcements

    I am using WSS 3.0. With regard to the built in Announcement web part, I would like to display more than 5 current announcements at a time on the main page. Currently, it only displays the 5 newest announcements. Can this be increased, preferrably to display all that have not expired?
  6. k8277

    500 Internal Server error missing details from log file

    Chris, thanks. Why is it that sometimes the iis log file contains the problem (line number from the page and details), but not always?
  7. k8277

    500 Internal Server error missing details from log file

    IIS 6.0 Last week a page on my classic asp site started producing frequent 500 errors. The iis log file contains the error, however it is missing the detailed data of where the error occurred and why. It has the page and the 500 error, but doesn't tell me on what line and why the error...
  8. k8277

    Modify the new user welcome email

    How do you modify/customize the email message that is sent when you add a new user to your sharepooint site?
  9. k8277

    WSS v3 with Forms Authentication

    I have this up and running, but I need to know how to modify the forms login page. I am trying to use Sharepoint Designer 2007, but when I attempt to save the login.aspx file, it tells me there server must be running either Frontpage extensions or Sharepoint Services. What am I missing here...
  10. k8277

    WSS pushing content updates to subsites

    With WSS 2.0 is there a way to add content (ex. an announcement) to a site and then automatically have it update all of the subsites with the same addition?
  11. k8277

    Need to add a site template to the top level template list

    WSS 2.0 I saved a site as a template, so now I have a xx.stp file. I would like to include this template in the list that you get when you create a brand new top level site. How can this be done? Right now, I just see the default templates that Microsoft gives you out of the box. Thanks
  12. k8277

    Disaster Recovery - moving master db to new server and new partition

    I am creating some disaster recovery documentation and doing some testing. My problem is: On my production SQL server all of the sql data is located on drive E:\mssql\data\*.* and I am trying to restore all of the data to a new server on C:\mssql\data. I was able to restore the master db...
  13. k8277

    Out of Memory Error

    tsuji - I tried your demo code and yes it does produce the out of memory error. I guess I need to determine how the condition ** Ubound(xArray,2) = -1 ** comes about. Thanks for the help.
  14. k8277

    Out of Memory Error

    I have a line of code that is randomly giving users a problem: Redim yArray(3,Ubound(xArray,2)-1) In the IIS log file it gives me a 500 Out of Memory. The server has 2GB and pretty much runs with 1.3GB free. Other posts on the net have said this could be caused by two things in the second...
  15. k8277

    Http 500 Internal Server Error - how to find error details

    In looking at my post and the logs, I do have the page, I just need the full error message and the line #.
  16. k8277

    Http 500 Internal Server Error - how to find error details

    I have friendly error messages turned on, so when a user experiences an Http 500 error, it will display the page, line number and error. Is there a way to retrieve this data from the web server. If I look at the IIS logfiles, it just gives me an abbreviated portion of the error. I need to...
  17. k8277

    SQL Mail / Outlook - outlook.pst in use problems

    I have setup SQL Server Agent to use an Outlook Mail profile. When I created the mail profile, I used the same domain account that the SQL Server Agent runs under. I believe everything was working and now I have some problems. Right now I can successfully start and stop a mail session by...
  18. k8277

    Contains Function - Need help soon

    You said I don't need the "eval" code -- what is the "eval" code doing in the first example? I assumed the formatnumber function was doing a format, so I was just trying to get rid of the eval code.
  19. k8277

    Contains Function - Need help soon

    Thanks, So can I replace my existing line of code: <xsl:eval>formatNumber(parseFloat(this.selectSingleNode("SalesOrder/Total").text),"$#,###,###,###.00")</xsl:eval> With this: <xsl:if test="formatNumber(parseFloat(this.selectSingleNode("SalesOrder/Total").text),"$#,###,###,###.00")"></xsl:if>

Part and Inventory Search

Back
Top