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 gkittelson 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: *

  1. Dorine

    Alternative for IN

    I am sorry, it is an SQL server...not a MySQL server. My mistake.
  2. Dorine

    Alternative for IN

    I tried your solutions but my code still gets stuck. I am using AQT to run my queries and the program will just not respond. Could it be that I have too many sub-queries? Here is my complete code...maybe anybody sees something else I have done wrong... Thanks again!!! CREATE PROCEDURE...
  3. Dorine

    Save the value return from stored procedure in a varibale

    Can you pass parameters with the stored procedure as well? CREATE TABLE #ProcColumn ( ProcColumn varchar(100) ) INSERT #ProcColumn (ProcColumn) EXEC [MOAD].[dbo].[usp_SysData_Select] DEFAULT
  4. Dorine

    Alternative for IN

    I have the following (summarized) code: Select * from dbo.PRSEBA where tfvrnr IN (select tfvrnr from pfftpr where tfsoid = 40) I am using a tool called AQT to run queries on a MySQL server. The code gets stuck on the IN statement. Does anybody know other code to replace IN ? Actually my code...
  5. Dorine

    Help me with JOIN??

    Thanks swampBoogie
  6. Dorine

    Help me with JOIN??

    I would like to join to tables. I would like to see all the data from table a and only the data from table f which corresponds with table a. I thought a left join would be the solution but I still get all the data from the two tables. I have read the paper on joins but I know I am doing...
  7. Dorine

    Join with different datatypes, HOW??

    I have made a simple mistake and fixed it myself. Thanks Hvass.
  8. Dorine

    Join with different datatypes, HOW??

    Dear all, I would like to join two tables. The column to join on is char (8) on one table and varchar (8) on the other. Now I get an error. Does anybody know a solution?? Thanks! Dorine
  9. Dorine

    Help needed on local host...

    Probably my server isn't working then. It look like it is because i dont see errors in my log and the service starts normal. But when i do http://localhost it doesn't work. But i have spent enough of your time. I'll just play with it some more :-(
  10. Dorine

    Help needed on local host...

    Probably my server isn't working then. It look like it is because i dont see errors in my log and the service starts normal. But when i do http://localhost it doesn't work. But i have spent enough of your time. I'll just play with it some more :-(
  11. Dorine

    Help needed on local host...

    I searched the forum but it did not work for me :-( I installed the Apache server successfully and it works as a service under Windows 2000. I wanted to watch the confirmation screen in my browser and typed: http://127.0.0.1/ Nothing good happened. My browser wanted to go to the internet (which...
  12. Dorine

    I searched...it must be simple....installation question

    Wullie, The Apache server is up and running as a service. But when i type http://127.0.0.1/ in my browser i cannot see the server screen (a book told me i should see a sort of confirmation screen). I also tried: http://localhost/ Do you know what i have to do?? Thanks again!!
  13. Dorine

    I searched...it must be simple....installation question

    Thanks Wullie, This helps a lot. Should i put localhost for both the server name as the domain name? Thanks again!!
  14. Dorine

    I searched...it must be simple....installation question

    Hi everybody, I am very new to apache. I just installed MySQL and i would like to install Apache and PHP to start exploring dynamic internet sites. During the installation of Apache it asked: Server Name Domain Name Administrative email account Well, i want to install it at home where i don't...

Part and Inventory Search

Back
Top