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 wOOdy-Soft 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: jobi
  • Content: Threads
  • Order by date
  1. jobi

    The trigger worked in SQL Server 7.0!

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

    Stored procedure in a view

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

    I need a database raporting tool/script

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

    View all images in a directory, sorted by date

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

    Default thousands separator

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

    Advanced redirection: from page123.cgi to page123.shtml

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

    New browser window when clicking on a shortcut

    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?
  8. jobi

    Error in UNION ALL query

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

    Base target for specified links

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

    Execute cgi in asp

    I was wondering how I execute cgi from an asp page.
  11. jobi

    Failed to execute Script, Win32 Error Code = 87

    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?
  12. jobi

    Forced restore on MSDE

    I have a database backup from SQL 7.0. I need to restore this backup on a MSDE installation, but I don't know the syntax. Can anyone help me?
  13. jobi

    Who offers web hosting for Crystal Reports and MySQL?

    I need web hosting that include Crystal Report and MySQL support. Do you know where I can find it?
  14. jobi

    More about publishing a Microsoft OLAP cube

    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 &quot;Processed date&quot; to an intranet site?
  15. jobi

    Report when a cube is processed (msolap)

    Is there a simple way of reporting when a cube last was processed?<br><br>I need this information either on a html-page or in an Access database.

Part and Inventory Search

Back
Top