I'm attempting to rewrite all my asp/mssql in php/mysql and I have a problem with continuing the select statement string on a separate/second line.
In asp my Select statement would look partially like this -
strSQL = "SELECT books.recid AS recid, books.date_created AS cdate, "
strSQL = strSQL &...
I was able to solve my problem another way. I ran across a website - maketecheasier.com - that had an example for adding the "Copy To" and "Move To" functions to the Context Menu using the registry and CLSID. The name of the article on the website is "Customize the Right Click Menu in Windows 7"...
I can't seem to figure out how to add the "Save as" function to the context menu when right-clicking on a (jpeg) file or any file. I've added an exe program once before and it worked fine but never where you hover over a file and right-click and explorer pops up for selecting where to save the...
Thank you very much for responding so quickly. It’s a service order system and when an error is made you void out that particular invoice and its status is changed from “Approved” to “Void”. If the invoice is reentered then the new amount is included in the grand total. The original invoice...
I’m having a difficult time figuring out how to deal with one record out of eight where the amount should not be included in a grand total formula. The records are invoices with a “status” field. In seven records the status is “Approved” and one is “Void”. The amount is a positive amount in all...
Thank you DrSql for the information. Where you say "and there are several scripts" are you saying to run the job as one with two steps or two seperate jobs? I' ve been reading a lot on the shrinking and realize that it only needs to be executed when necessary. Now I'm working on the word...
I have a question about setting up Maintenance Plan jobs and their configuration (SQL 2005). We’ve always run them as independent jobs, like one for integrity checks and one for reindexing and one for shrinking, etc. However, when I was doing the research looking for solutions to our integrity...
This is a follow-up to our SQL 2005 database integrity problems. We were finally able to communicate with the vendor that made the original SQL 2000 to SQL 2005 conversion. It turns out there was a Stored Procedure that was no longer used that was causing the errors. All we had to do was delete...
Thanks again DrSql for the response, very informative and helpful. While I’m certainly not going to ignore these errors, I get the impression that if it takes me a while, like a couple of weeks (customer schedule) to fix them that may be ok. I can’t verify when the migration to 2005 occurred but...
Thanks DrSql for the response. It's our (small company hired to make local conversion) understanding the DB was converted from 2000 to 2005 several years ago by the previous vendor doing the hosting. We got involved back in October and everything we've been working with is 2005. I've tried to...
Hello, I need some advice on a MS SQL 2005 problem. Our customer had their POS application and database hosted by a vendor that informed them two months ago that they were no longer hosting and the customer would have host the application and the DB locally. We were contracted to make the...
Thanks Dan for the response and they do have toolbars installed. I did not realize a toolbar could have such an effect. That will be easy to look into. Thanks again.
On a web site that I maintain for a customer there is a data entry page that has the following Javascript code for launching a small help page/window.
<script type="text/javascript">
function epicHELP()...
Thanks for the response. CS3 performs the same as PS7 does for preferences but that did not solve the problem. I forgot to mention that I can click on the icon on the left side of the blue bar and select Move and I can move the canvas with no problem, but only once. If I want to move it a second...
Hello, I'm using CS3 and when I create a new canvas I cannot move it. I've been using Photoshop since ver4 but this is the first time I've run into this problem. I can move it by moving the corners a little bit at a time to get it to another part of the workspace but that's a lot of trouble. I...
Thank you very much for the help. I've been using this code for some time but just never thought about the detail that you described until I saw my site in Mozilla. And I've looked at a lot of CSS sites and books but none seem to make it as clear as you have. Any suggestions on what site or book...
I just realized I have a problem with some of my hyperlinks. I'm using this CSS class on several links,
A:hover.clsHMpage { color:"#ffff33"; text-decoration:underline }
.clsHMpage { color:"#fff5c8"; text-decoration: none }
and when you view the page in IE it looks as it should. When it's...
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.