This was an OK statement in SQL Server 7.0:
CREATE TRIGGER [TriggerNm] ON [Table1]
FOR INSERT, UPADATE
AS
UPDATE [Table1]
SET Table.Col1=(SELECT DISTINCT ColA FROM Table2
WHERE Table1.Col2=Table2.ColB),
Col3 = (SELECT DISTINCT ColX from Table3
WHERE Table1.Col4=Table3.ColY)
In SQL Server...
I have a lot of information about my customers.
I want the customers to see this information on the Internet. But I want them to see only "their own" information, not the information I've stored about other customers.
To do this I need:
A query tool/script that prompts for a login...
I need a script that views all images in a directory, and because the directory contains a lot of images, I want the newest image to be presented first.
(I'm not very familiar with cgi, I read but don't write the code...)
I've found a simple script that views the images, but they are sorted...
The System Default Number Format (File - Options - Fields - Number - Number) is with Thousands Separator.
I don't want to change that. (This is different on different computers, too...)
I have a field in SQL Server that stores dates in this format: yyyymmdd.
Because of this System Default...
A cgi news publisher creates the pages on my site. (www.mydomain.com/news/page1324.cgi etc.)
I want to include these cgi pages in other pages. An example:
When a visitor clicks on this link, created automatically by the news publisher: www.mydomain.com/news/page1324.cgi, I don't want this page...
I always have an internet radio running in a small browser window.
When I click on the Internet Explorer icon on my dekstop to open a new browser, my homepage opens in the small radio browser.
How do I force the Internet Explorer icon on my desktop to open in a new window?
I create a view like this:
SELECT column
FROM table1
UNION ALL
SELECT column
FROM table2
I run the query, and everything looks OK. I see data, no errors.
When I try to save this view, I get this error:
"View definition includes no output columns or no items in the FROM clause."
Why...
In order to use the same discussion board with several layouts, i need to open specified links in different frames.
Example:
Link to www.board.com/1.html opens in _Top
Link to www.board.com/2.html opens in _Blank
Link to www.board.com/3.html has no target
The <base target> tag effects on all...
When I try to run a SSI cgi-script (or pl) on IIS, I get the following error:
Failed to execute script '`c:/path/script' Win32 Error Code = 87
I've checked all my permissions (I think) :-), and I can't find what I'm doing wrong.
Any ideas?
When I have published the cube, it's critical for the users to know <i>when</i> the cube was processed.<br><br>How do I publish the "Processed date" to an intranet site?
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.