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 SkipVought 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. MarkSweetland

    VS 2022, BC30456 'Join' is not a member of Path - ?!

    Path.Combine() if you are working in the .Net Framework or .Net Standard 2.0 and below. Join was added to .Net Standard 2.1. The documentation page you show has .Net 8 as the Version number reference. Mark "You guys pair up in groups of three, then line up in a circle." - Bill...
  2. MarkSweetland

    How exactly TypeOf operator works?

    TypeOf really checks that an object is compatible with a certain data type, not that a parameter (variable) is a particular type. At the Project level, if you turn Option Strict on, the variable declaration determines the type (i.e., tiArg will always be an Integer in your example). If Option...
  3. MarkSweetland

    SQL_CALC_FOUND_ROWS still runs in MySQL 8.0.29

    Depreciated doesn't mean removed. It will be removed in a future version. Think of it as a warning that you should refactor your code if you do use it. Mark "You guys pair up in groups of three, then line up in a circle." - Bill Peterson, a Florida State football coach
  4. MarkSweetland

    How do I make a page with multiple AJAX custom controls?

    The ScriptManager or ToolScriptManager reference should go in the host page, not in the controls and should be one or the other, not both. ScriptManager is part of ASP.Net and ToolScriptManager is part of AJAX Toolkit, but ToolScriptManager was supposedly removed in AjaxToolkit version 15.1...
  5. MarkSweetland

    Java script blocked due to MIME type error

    My first guess is that the script_global.js is not JavaScript, but may contain JSON. In that case, you'd have to add type="application/json" to the <script> tag to indicate the content is not executable. Mark "You guys pair up in groups of three, then line up in a circle." - Bill...
  6. MarkSweetland

    Management Studio behavior question

    I don't use the view builder, or the table designer. I'm more apt to create and test the query I want and then preface it with CREATE VIEW dbo.[view_name] AS to actually create the view. Same for tables. I'd rather create and name the objects like I want via script rather than have to go back...
  7. MarkSweetland

    Management Studio behavior question

    ORDER BY should be used in the most outer query for present result in desired order, not within the view itself. There is a good chance that the TOP/ORDER BY will not return the data in the order specified from the view result anyway. Mark "You guys pair up in groups of three, then...
  8. MarkSweetland

    Arrays in VB .NET VS 2019

    I think it needs to be initialized. Try: Public Dim gaFileTypes() As String = New String() {} Mark "You guys pair up in groups of three, then line up in a circle." - Bill Peterson, a Florida State football coach
  9. MarkSweetland

    difference ways of creatin

    Shared data sources are just that, shared connection information for multiple SSRS reports to connect to your data. The shared data source is one method to connect your report to the data, another is to embed the connection information within the report itself. The shared data source is my...
  10. MarkSweetland

    Using date picker gives an error message, only at application start

    The input box does not exist in the Request.Form on the initial GET because it is part of the Response (not the Request) as the client has just arrived at the page and the server is delivering the content. It will only exist in the Request.Form after a POST request by the client. You'll need...
  11. MarkSweetland

    How to link a condition to a session(&quot;UID&quot;) ?

    The comparison assumes the Session variable and the recordset column are of the same datatype. rsRC("MemberID") = 123456 Session("UID"] = "123456" rsRC("MemberID") <> Session("UID"] Mark "You guys pair up in groups of three, then line up in a circle." - Bill Peterson, a Florida...
  12. MarkSweetland

    IDENTITY_INSERT

    You need to specify the particular columns for the insert: INSERT INTO CMMSSrc.dbo.rtblChecklistSeed(columnName1, columnName2, etc...) Mark "You guys pair up in groups of three, then line up in a circle." - Bill Peterson, a Florida State football coach
  13. MarkSweetland

    Chrome Issue

    I've never used it, but there is an IE Tab Extension that emulates IE and supports Java, Silverlight, SharePoint, etc. inside Chrome. Mark "You guys pair up in groups of three, then line up in a circle." - Bill Peterson, a Florida State football coach
  14. MarkSweetland

    Chrome Issue

    I don't think there is a work around for applets. Chrome dropped Java NPAPI applet support: https://java.com/en/download/help/chrome.html Mark "You guys pair up in groups of three, then line up in a circle." - Bill Peterson, a Florida State football coach
  15. MarkSweetland

    View and access only own records, and not the records by others on SharePoint.

    May want to try forum820, this is the Microsoft Exchange forum. Mark "You guys pair up in groups of three, then line up in a circle." - Bill Peterson, a Florida State football coach
  16. MarkSweetland

    How to combine JS and ASP ?

    var_day in your example exists on the server. JavaScript lives on the client. You'll have to inject your server value into a JavaScript variable in order for the client to see it. <p id="demo"></p> <script> { var var_day = '<%=Day(date())%>'; var d = ""; d = d + Number.isInteger(var_day)...
  17. MarkSweetland

    SQL syntax problem

    I don't think they can be combined. You'll need to define what the overall intent of the query is. The first returns details of both BookA and BookB that is associated with a memberid, whereas the second returns overall totals of BookA + BookB associated with memberid regardless of the...
  18. MarkSweetland

    SQL syntax problem

    You use IN and OUT as column names which could cause problems without encompassing in brackets. You also need to close and alias the last parenthesis for the initial SELECT FROM SQL = "SELECT SUM(S_IN) AS TotIN, SUM(S_OUT) AS TotOUT FROM &_ "(" &_ "SELECT SUM([Out]) AS S_OUT, SUM([In]) AS...
  19. MarkSweetland

    SQL syntax problem

    You probably need to add spaces at the end of your concatenations. It's running all lines together so the syntax doesn't make sense: SQL = "SELECT SUM(S_IN) AS TotIN, SUM(S_OUT) AS TotOUT FROM (SELECT SUM(Out) AS S_OUT, SUM(In) AS S_IN " & _ "FROM BookA" & _ "WHERE membersid =" & session...
  20. MarkSweetland

    Unable to access my router

    If the router has been reset, I think the default IP is 192.168.31.1 Mark "You guys pair up in groups of three, then line up in a circle." - Bill Peterson, a Florida State football coach

Part and Inventory Search

Back
Top