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

    Cant get ado.net to 'update' to a database and delete records

    Just a note, I am still hoping for some help on doing this in ADO.net. Here is my solution in classic ado & vb. It works well, and the code is much more simple... it seems to me that the power of .net is offset by it's complexity :-/ [noevil] Option Explicit Public Con As ADODB.Connection...
  2. ElectronikBean

    Cant get ado.net to 'update' to a database and delete records

    Hello, Thanks for reading my post :-) This is the first time that I have attempted to write anything using ado.net, I am used to classic ado. I have been pulling my hair out with this one... I have written a simple function that removes duplicates from a database table. (Oh, I thought, this...
  3. ElectronikBean

    How do I keep a db connection alive in PHP OO?

    Thankyou!!! OK, I have not explained my problem very well, but you have managed to understand me enough... as you have helped me resolve it! I used your much more simiplified code (unlike my poor attempt at simplification! :~/) and used it to experiment. Your code was pretty much what I had...
  4. ElectronikBean

    How do I keep a db connection alive in PHP OO?

    Thanks for your quick response :-) I was trying to simplify the post to keep it shorter, however, I see what you mean it is difficult to see what I am on about. I have tried using mysql_connect() in the contructor with the logic that it will keep the connection open for that object and any...
  5. ElectronikBean

    How do I keep a db connection alive in PHP OO?

    I have some data stored in MySQL DB and use a class object to retrieve the data on a single php page. I want to create a single connection to the database, call the object's function several times to collect each individual peice of data, and then close the connection. So far, I have only been...
  6. ElectronikBean

    Completely halting all code and error handling

    Good idea Golom, thankyou. That might work, currently I capture the problem as an event, and the idea of letting the vb error handling work for me may tidy things up. I'll give that a go. Your a star! E-Bean
  7. ElectronikBean

    Completely halting all code and error handling

    Thanks Golom, But no. Public WithEvents Object1 as Class1 Say if the below code is my Form1 class. ---------------------------------------- Private str as String Sub Example() On Error GoTo ErrorTrap str = Object1.Property 'Other code doing other things with this property...
  8. ElectronikBean

    Completely halting all code and error handling

    Hello, and thanks for looking at my problem. I need to find a way of telling the system to stop running all code, a sort of halt completely, other than just 'Exit Sub' or 'Exit Function'. I have tried using the err.raise method, but this does not actually stop the code from running. Once the...
  9. ElectronikBean

    KDE 3.1 takes an age to login.

    Thanks RhythmAce, Sorry, it was a typo. I have 160 mb, 128 + 32mb. I have another 128mb dimm in the post now. So kde and gnome are notorious for this eh? So how much is enough? I only have 2 dimm slots on this old box. In theory then, unless I need to use the gui (i intend to mainly run...
  10. ElectronikBean

    Time Service synchronization

    By using the net time command on each users pc,(possibly including the bdc!) redirecting to the pdc. eg. c:>NET TIME \\Server /set /y It is a good idea to do this in the logon script. marcdmac has a good looking script written in vb in this very forum... of course, you will need to delete...
  11. ElectronikBean

    KDE 3.1 takes an age to login.

    Mandrake 9.1 (my first linux!) 200 mhz pentium cpu. I cant login to the KDE, in fact - it has never logged in. I can login on ICEWM, but the KDE just hangs on a blank screen showing the stopwatch. The HDD crunches, but still no desktop. I have upgraded the RAM from 32MB to 168MB - still not...
  12. ElectronikBean

    Scheduled Task

    I think that you need to work on isolating this problem. You have 3 different tasks, do they all fail or is it just one that fails? Is it a different reason for failure for each task or is it exactly the same error message/reason? Could you test to see if a normal executable file runs as...
  13. ElectronikBean

    XP will not stop asking to install disabled hardware!!!

    Thanks BCastner, I didnt think to try the ms kb for a problem like this, but then what else do I expect for an os from Microsoft? - It is bound to be a known issue. I have installed the scanner software before, yet it still would not have it. I will have to try to install some other scanner...
  14. ElectronikBean

    XP

    Hi Paul00, I am sorry, Paul, but I (and most likely others) am having trouble understanding your post. English does not appear to be your native language. As I understand - you are trying to install xp and are having trouble with partioning? Try to put the problem simply - and use more full...
  15. ElectronikBean

    XP will not stop asking to install disabled hardware!!!

    Hello all, I have a problem with xp and a HP R45 all in one printer. The fact is, HP have not posted a driver for it yet, so the scanner half is not working. The user is not interested in the scanner for now, and will make do with the R40 (R40 as R45 not availiable!) printer driver alone...
  16. ElectronikBean

    Multiple databases referenced in a single SQL query

    Jim, I have just had a look at the table it creates, and it defaults to required = "NO". Intresting question though - I will have a look into that when I get the chance. I am going to get some sleep now... its getting late here in Devon,UK. I may look into it next week...
  17. ElectronikBean

    Multiple databases referenced in a single SQL query

    I agree with CCLINT as my code did use the 'in' clause! Yet I failed to mention it :( Here is a tested and debugged update! You can use 2 connections... one for the first db and one for the third to create the table. I feel that creating and inserting the table gives you more control than...
  18. ElectronikBean

    Multiple databases referenced in a single SQL query

    Hi jopaumier, I hope this helps... I based it on a similar bit of code to rescue a corrupt database recently. Although this bit is untested... Public function ElectronikBean() Dim cnMyDB1 As New ADODB.Connection Dim cnMyDB2 As New ADODB.Connection Set cnMyDB1.ConnectionString =...
  19. ElectronikBean

    Controlling FTP access using PHP :-S

    (To sleipnir214 ) Yes you are right, I was not on the right track, but after viewing my own post last night, I re-read your comments. It is only natural for me to think Win32, as that is all I have been used to for a long time... So, to reiterate, Unix family OSs use a user directory or a...
  20. ElectronikBean

    Controlling FTP access using PHP :-S

    Thanks for the tip - and for redirecting me onto the correct path. It can be difficult to find your way when your left groping around in the dark! What the support person was saying did not make a lot of sense as - like you say, they did not even tell me the correct details. It makes sense...

Part and Inventory Search

Back
Top