Search:

Type: Posts; User: techgnome

Page 1 of 13 1 2 3 4

Search: Search took 3.01 seconds.

  1. Replies
    19
    Views
    329

    Re: [RESOLVED] Wierd issue in javascript

    but you didn't have alert(myString) ... you had alert("+clid+") ... the clid isn't part of the javascript ... it's value is ... so you need to enclose its VALUE in quotes to have it treated like a...
  2. Replies
    19
    Views
    329

    Re: [RESOLVED] Wierd issue in javascript

    It's the difference between this:


    alert(100);l

    and this:


    alert('this is a string');
  3. Replies
    19
    Views
    329

    Re: Wierd issue in javascript

    I'd change this:


    <td><button class='smallbutton' onclick='ReleaseStation("+clid+");'>"+istatus+station+"</button></td>

    To this:


    <td><button class='smallbutton' ...
  4. VS 2019 Re: Keeping excel opened during project utilization

    Do you understand the concept of variable scope? That's what's going on here. You're defining variables in a sub and expecting them to be available elsewhere. That's like making a sandwich at your...
  5. Re: Need help understanding the use of SET

    Well, excuse me.
    I'll show myself the door.

    Or, oooh ooh grunt oooh oh ohhooh oogh, (gesture).


    -tg
  6. Re: Need help understanding the use of SET

    That would make sense and jives with my memories. I've been using BASIC since 81/82 (gawd, has it been that long?) all the way through .NET ... Initially there was the Let statement, which was for...
  7. Re: Very Slow SQL Query When Using IP in Connection String

    Check the link that PD gave for the protocols. I think by default names pipes is enabled, but IP isn't. you'll need to turn it on.
    Secondly, is there a reason for wanting to use the IP of the...
  8. Replies
    3,207
    Views
    267,677

    Re: What song are you listening to right now?

    Never saw Fight Club... couldn't tell you... (checks IMDB ...) Yep ... He played Robert Paulson ...

    -tg
  9. Replies
    3,207
    Views
    267,677

    Re: What song are you listening to right now?

    Not sure about Fight Club ... but he played Eddie in Rocky Horror Picture Show.

    -tg
  10. Replies
    3,207
    Views
    267,677

    Re: What song are you listening to right now?

    Meat Loaf ... RIP ... :cry:


    https://www.youtube.com/watch?v=9X_ViIPA-Gc

    A part of my youth soundtrack has passed...

    -tg
  11. Replies
    5,159
    Views
    428,164

    Re: Corona virus, China major city lockdowns, etc.

    How about mine? Some how my wife and kid came down with it ... probably from school... where the Governor has hanstrung the district's ability to enforce rules that would have slowed the spread, as a...
  12. Replies
    18
    Views
    467

    Re: Mostly Merging Multiple Tables

    Why can't you just shove the data into a staging table and then upserted into the final table? That's what I'd do with it. I never just import data. Ever. I don't care where it comes from, don't...
  13. Replies
    26
    Views
    1,992

    Re: Vb6 Community Compiler

    Naw... I think he's reluctant to post the code because he plans to sell it commercially ... if he posts it here, then anyone would be able to swipe it, and he'd lose out on all da big buck$.

    -tg
  14. Replies
    26
    Views
    1,992

    Re: Vb6 Community Compiler

    Did you really have it write it out to the C:\ ? yeah... I don't think Windows is going to allow that ... try writing it out to a folder somewhere ... your desktop even... or just anywhere anywhere...
  15. VS 2012 Re: How to calculate formulas with variables?

    There's a namespace in ,NET that you can use to build and execute .NET code, can be as simple or as complex as you want (as far as I know).



    -tg
  16. Re: setting RecordsetClone.RecordCount in a form in code

    So check to see if you have a RecorsetClone, or nothign...



    Function anyfunction(frm As Form )
    ' other stuff
    if frm.RecorssetClonee is Nothing then exit Funciton

    If...
  17. Replies
    10
    Views
    379

    Re: Management of sql server using vb6

    Keep in mind that the pathing to any files for the backup/restore of the database are relative TO THE SERVER, and NOT the application. So if you backup a database to...
  18. Replies
    153
    Views
    2,944

    Re: Is this justice???

    Something to keep in mind is that SYG isn't universal - not all states have it. Some have the Castle Doctrine instead. It's similar, but works differently and that difference can get people into...
  19. Replies
    13
    Views
    539

    Re: Adding Group by ID to a query

    Maybe ... depending on what the intent was ... A Distinct might also make more sense ... or maybe not... don't really know ... the query is pretty small and simple, so I'm not sure what's to be...
  20. Replies
    13
    Views
    539

    Re: Adding Group by ID to a query

    I'm also going to ask about the other elephant in the room and ask why are you grouping on the ID of the table? There doesn't seem to be a reason for it. There's no aggregation going on, and the ID...
  21. Replies
    153
    Views
    2,944

    Re: Is this justice???

    Every time I see/hear the word "plethora" I think of the movie Three Amigos!


    -tg
  22. Replies
    13
    Views
    539

    Re: Adding Group by ID to a query

    No... not like that .... like this .... pay attention to where you start and stop your strings...



    Sql = "Select from St_Tbl " & _
    " Where MDate Between " & FirstDate & " And " & LastDate & "...
  23. Replies
    13
    Views
    539

    Re: Adding Group by ID to a query

    try putting it inside of quotes...


    -tg
  24. Thread: TwinBasic

    by techgnome
    Replies
    862
    Views
    282,359

    Re: TwinBasic

    Really? You sure about that? Count me the number of ways you can concatenate strings in VB.NET ....

    -tg
  25. Thread: SQL Express

    by techgnome
    Replies
    26
    Views
    857

    Re: SQL Express

    Yes, by default, SQL Server will put the mdf/ldf files in a {some redoncously long path}MSSQL/DATA folder ... and that's fine ... that's the default location for those files. If you detach them and...
  26. Replies
    153
    Views
    2,944

    Re: Is this justice???

    That's actually not saying much ... the political landscape used to be very different ... Political Polarity has shifted ... there was a time though Republicans were liberal (Lincoln was a...
  27. Replies
    13
    Views
    501

    Re: VB6 Randomly Pastes in Reverse Order

    It's been a while ... but if memory serves ... it has to do with the way you're selecting them in the first place. I want to say if you click the first one, then shift-click the last one so that it...
  28. Thread: SQL Express

    by techgnome
    Replies
    26
    Views
    857

    Re: SQL Express

    Yes... you can stop SQL Server and copy the files... You can also do a "Detach Database" ... but then what? you need to re-start SQL Server and re-attach the files in order to use the database.
    ...
  29. Replies
    9
    Views
    359

    Re: getting this long sql qerry to vb

    That's because you're just using code blindly without understanding what you're doing or the code is doing.
    You need to put the line continuation character after EVERY line that you want to keep...
  30. Replies
    5,159
    Views
    428,164

    Re: Corona virus, China major city lockdowns, etc.

    If they are still doing that ... I'd hope they were fewer and father than before. I'm not saying that they aren't doing it, because that wouldn't surprise me. But seems like a crappy thing to do.
    ...
  31. Replies
    5,159
    Views
    428,164

    Re: Corona virus, China major city lockdowns, etc.

    I think that was early on... and mostly due to the lack of the ability to test for it at the time. Other places probably went the other route, and marked it as a Covid death regardless since "it...
  32. Replies
    13
    Views
    754

    Re: Randomize Questions and Answers

    Yeah, that simplifies somethings, but now ca, wa1, wa2, & wa3 need to be further shuffled so that sometimes the correct answer moves around randomly. It may be as simple as putting the 4 possible...
  33. Replies
    13
    Views
    754

    Re: Randomize Questions and Answers

    While the Universal Answer to Life, the Universe, and Everything is 42, in this case you want 46 .... you have 50 possible answers ... you need to leave 4 ... 50 -4 = 46 ... so you need to remove 46...
  34. Replies
    13
    Views
    754

    Re: Randomize Questions and Answers

    The number of questions aren't really the problem... the number of answers are. The code creates a copy of the answers, shuffles then removes two items from the list (I'm assuming the original code...
  35. VS 2015 Re: [RESOLVED] Breaking text into page size portions

    YEah, so that's what I thought... it's dropping that last little bit of your document. Your flaw is in the calculation of the numberOfPages ... the fact that you're doing it at all ... especially at...
  36. VS 2015 Re: Breaking text into page size portions

    How much of your document is missing? Half? More? Less? The last page? Ever other page? I have some guesses about what may be wrong but I'm not going to waste my time or yours going down that road if...
  37. Replies
    12
    Views
    987

    Re: log4j - High vulnerability malware

    Nope, not a virus.... just a vulnerability in an existing widely used logging library. Problem is, as soon as one vulnerability is patched, another hole seems to crop up. It's kind of like playing...
  38. Replies
    5,159
    Views
    428,164

    Re: Corona virus, China major city lockdowns, etc.

    Different times, different people, different locations, different results...

    -tg
  39. Replies
    31
    Views
    945

    Re: Teaching people to crawl

    Yeah, I know the thread you're talking about ... the same one where I tried to tell the op that the string "10" isn't the same as the number 10 and if he was sending over contents of his text box...
  40. Replies
    11
    Views
    566

    Re: eleminate surgable dates

    Wait... is all you're trying to do is see if the datetime is between midnight and 6am, and if it is, subtract a day? Just use DATEPART and pull the HOUR and look to see if it's between 0 and 5 the...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width