Recent content by jobi

I still get an error: Error 170: Line 5: Incorrect syntaxnear '('.

I don't think this is what I want. In SQL Server 7.0, when i use comma (,) I start a new set command. In my example, I set values to Table1.Col1 AND Col3. I update both fields in one trigger. In SQL Server 2000 the comma returns an error. (Lekar: This is not the error. A misspell in this...

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...

SQL Server 2000: Instead of SELECT * FROM table1 I need SELECT * FROM stored_procedure1 But I don't know the syntax.

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...

No, I don' have access to the server config. Does it exist a script that can do this for me? (I need it to create the shtml file automatically.)

I did not explain this good enough. I want this to happen in a dynamic way. page1234.cgi shall be a part of page1234.shtml. I want the same for 1233.cgi, 1232.cgi, and all the other 2000 pages. This means I can't MAKE all the shtml pages, these pages must be "created" because the...

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've tried to use alias too, but this has no effect. This is actually the exact view definition, only with different column and table names. And everything is OK in SQL 7.0. Is this a bug?

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...

I can't add target in the links. I need to use one code in the discussion board. But at the same time, I want some of the links to behave different when the discussion board is enteres from different frames. I'm not lazy, but I'm not going to write different versions of the discussion...

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...