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!

Register Log in
  • Congratulations strongm 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: andreas57
  • Order by date
  1. andreas57

    special left join

    sorry, the variables are irrelevant (hwo could you know) but the 2. question is important, here's the query: select tblL.*,tblT.desc,tblT.text from tblL left join tblT using(idtblL) where idtblLang=2 || idtblLang is null order by position idtblLang is in the 2 table (tblT) andreas owen
  2. andreas57

    special left join

    im using following statement: select $tblL.*,$tblT.desc,$tblT.text from $tblL left join $tblT using(id$tblL) where id$tblLang=2 || id$tblLang is null order by position my problem is that the the enties from the 1. table aren't displayed if there is no entry in the 2. table eventhough i set the...
  3. andreas57

    display webImage

    i wont to display a image from a webserver in c# compact framework on a pocketpc. the only way i found of doing that is to make a request and work with buffers and so on. isn't there a simpler way? thanks andreas owen aowen@swissonline.ch
  4. andreas57

    display external image in compact framework

    until now i you added the image to the resource file and yould display it in a picturebox. how can i display a image from a server? andreas owen aowen@swissonline.ch
  5. andreas57

    Filtering Data shown in a DataGrid

    i think your problem is that you don't repaint the datagrid. you have to overwrite the exeisting dataset of the datagrid and then repaint/refresh/... the datagrid. to definatly check the sql-query you could give out the row_count in a popup. andreas owen aowen@swissonline.ch
  6. andreas57

    redirect

    i've got a beculiar problem with a redirect. with firebird it works without problems but the IE wont do it. i do a metrefresh with following link: ftp://univers@ftp.univers-werbetechnik.ch it just wont recognize the username, if i copy the link directly into the adressbar it works but as link...
  7. andreas57

    php DSN-less connection trouble

    i'm not 100% sure but to use "$conn->open" $conn would have to be a class width the function open and the variables would have to be seperated width ",". it looks more like as asp-script and not php. andreas owen aowen@swissonline.ch
  8. andreas57

    special characters

    this may be a stupid question but isn't there a function that transforms text input to mssql compatible expressions? for example when i search for "her's" i get a runtime error near s. andreas owen aowen@swissonline.ch
  9. andreas57

    mozilla mouse coordinates

    i want to open a popup next to the cursor when i use cal(). i always get the message back, tha e is not defined. can someone help? function getX(e) { var posx = 0; if (!e) var e = window.event; if (e.pageX) { posx = e.pageX; } else if (e.clientX || e.clientY){ posx = e.clientX +...
  10. andreas57

    display "my computer"

    i want fetch a filename from my hard drive or mappen drives and use the name in a form, just the name and not the file. has anyone a idea how i could do that? thanks andreas owen aowen@swissonline.ch
  11. andreas57

    drag & drop

    hi there i'm using the d&d functions in IE and want to limit the d&d functions to the actual window. it shouldn't be possible to drag something from the desktop or any other application into my window (homepage). how can i do that? it's probably something with "ondragenter" thanks andreas...
  12. andreas57

    drag & drop in IE

    hi there i'm using the d&d functions in IE and want to limit the d&d functions to the window. it shouldn't be possible to drag something from the desktop or other application into my window. haw can i do that? it's probalby something with "ondragenter" thanks andreas owen aowen@swissonline.ch
  13. andreas57

    drag & drop

    you have to drop in in upload andreas owen aowen@swissonline.ch
  14. andreas57

    drag & drop

    sorry, that file done yesterday but not anymore, but the file "afg 1.2.1.cad" in "test1.2" still does it andreas owen aowen@swissonline.ch
  15. andreas57

    drag & drop

    hi there, the easiest way is to go to http://netbox.adz.ch user:test pwd:test here you can browse through the left tree and drag the element test_elektro.cad to one of the right frames andreas owen aowen@swissonline.ch
  16. andreas57

    drag & drop

    i forgot to post the parent frame with the drag functions: function handleMouseMove(tmp) { if (window.parent.tree.event.button == 1) { eval('parent.tree.document.all.divDrag' + tmp + '.dragDrop()'); } } function handleDragStart(tmp,tmp2) {...
  17. andreas57

    drag & drop

    hello i've got a small problem with the data object. i always get the dragged text with "undefined" at the end. why? source frame: <html> <head> <title>netBox</title> <link rel="STYLESHEET" type="text/css" href="include/main.css"> <script> ns4 = (document.layers)? true:false; ie4 =...
  18. andreas57

    outer joins

    no that's not the problem. i've done it deliberatley this way for sveral reasons and it doesn't matter if i always get the same back or not!!! andreas owen aowen@swissonline.ch
  19. andreas57

    outer joins

    i just want it to select 1 entry from the b-table. i dont care wich one! regardes andreas owen aowen@swissonline.ch
  20. andreas57

    outer joins

    is there a workaround for outer joins in mysql? i've got to tables (a,b). what i want to do is select all of a and only the first match from b. thanks andreas owen aowen@swissonline.ch

Part and Inventory Search

Back
Top