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...
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...
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...
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?
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...
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...
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?
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
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...
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.
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.