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. jgpasko

    COPY records from one table of a DB to another table of another DB

    Use Data Transformation Services that is included with the SQL Server bundle. This is the ETL utility that ships with it. You can create a package and map each table field to field while performing other tasks such as populating default values for the additional fields that don't exist in the...
  2. jgpasko

    Delete Multiple rows

    Dennis, heh, I use a SB Triple Espresso IV Drip. John Pasko "No matter where you go, there you are." -- Buckaroo Bonzai
  3. jgpasko

    Delete Multiple rows

    ************* Start of code EXEC('SELECT * FROM tblqaCorrespdence WHERE iIndex IN (' + @tmpIndex + ')') ************* End of code These are the values that need to pass - Execute spTest(1,2,4,6,7) Shouldn't the SELECT be a DELETE? John Pasko "No matter where you go, there you are." --...
  4. jgpasko

    C# beginner. Really basic webapplication question

    The Web is a stateless environment which means it has no memory regarding variables, etc. Each time you fire an event such as you button click it will make a round trip to the server (A postback) and render an entirely new version of the page unless you utilize server controls that have...
  5. jgpasko

    Calling .asp page in .NET

    You can have the asp page in the .NET solution, but it should be its own project. John Pasko jpasko@telemetrysoft.com
  6. jgpasko

    How can I user web user control from another project?

    passs, Try this: Add the User Control (<file>.ascx) as an existing object to the project you want to instantiate in. Make sure that you change the Namespace to the Namespace of your current project. Then declare the user control: protected UserControl <usercontrolname>; then add it to the...
  7. jgpasko

    How can I capture the UNC for my Current Directory?

    Kris, The Assembly is going to be running on 2 servers (QA and PROD) so I will get the server names (Local Machine) as the UNC. John John Pasko john@rts-sd.com &quot;No matter where you go, there you are.&quot;
  8. jgpasko

    How can I capture the UNC for my Current Directory?

    Kris, Thanks for the reply. I was just entering that I found the solution. I am using the Environment.MachineName property and this seems to have worked. Again, thanks for the response. John John Pasko john@rts-sd.com &quot;No matter where you go, there you are.&quot;
  9. jgpasko

    How can I capture the UNC for my Current Directory?

    I need to capture the UNC for the Server I am running my app on to determine if it is a QA or PROD Environment. When I use the following code, I only get the drive path, not the actual server path. // Get the current directory. string path = Directory.GetCurrentDirectory(); I...
  10. jgpasko

    Java or C++?

    Thanks for your responses and the reading list. Take Care, John Pasko john@rts-sd.com &quot;No matter where you go, there you are.&quot;
  11. jgpasko

    Java or C++?

    Hi, If someone where to pursue and OO Language, would you recommend Java or C++ as a start? Thanks John Pasko john@rts-sd.com &quot;No matter where you go, there you are.&quot;
    • jgpasko
    • Thread
    • Replies: 9
    • Forum: C++
  12. jgpasko

    On Demand Sub Report showing Blank (Web App)

    I have an Active Server Page that passes parameters used by a stored proc in a CR. The Main report has an On-demand Sub that uses the same stored proc but provides a parameter that was able to be null in the main. I am able to View the Main Report using the ActiveX Smart Viewer, but when I...
  13. jgpasko

    Utility to migrate MS Access Forms to VB Forms

    Try ZDNET in downloads. Do a search that is &quot;Access to VB convert&quot; -- Leave the quotes off. Good Luck John Pasko john@rts-sd.com &quot;No matter where you go, there you are.&quot;
  14. jgpasko

    DAO to ADO covertion

    CCLINT, It looks like the Client is already in place (Using VB) with an access mdb as the backend. Malicka has to upsize to SQL Server. Why rewrite it as an mdb when the Client code, forms etc is already in VB? This is what I gathered from the limited scope of info provided. :-) John Pasko...
  15. jgpasko

    DAO to ADO covertion

    Malicka, You don't necessarily have to convert over to ADO. MS SQL Server is backward compatible with DAO. It is recommended that you eventually migrate to ADO, but you can perform this in stages. The big issue will if you want to leverage SQL Server's full power and convert some of your...
  16. jgpasko

    ADO command will not return recordset

    Could be your driver. MS Access 97 is MS Jet 3.x, you're using JET 4.x. Good Luck, John Pasko john@rts-sd.com &quot;No matter where you go, there you are.&quot;
  17. jgpasko

    ADO command will not return recordset

    Is an error raised? If so what is it? Thanks John Pasko john@rts-sd.com &quot;No matter where you go, there you are.&quot;
  18. jgpasko

    ADO command will not return recordset

    What error is raised when you execute? Just off the top...is your Connection Object global? I see Conn.Open &quot;Provider...&quot; But I don't see Dim Conn As ADODB.Connection, etc John John Pasko john@rts-sd.com &quot;No matter where you go, there you are.&quot;
  19. jgpasko

    Can anyone recommend a good SQL Server reference book?

    The &quot;Unleashed&quot; Series Sams is excellent. I use both the SQL Server and VB versions. John Pasko john@rts-sd.com &quot;No matter where you go, there you are.&quot;
  20. jgpasko

    Please Advise on MS SQL Server 6.5 Issue!!!!!

    Mean Green: Yes it does. Thanks for the feedback. John Pasko john@rts-sd.com &quot;No matter where you go, there you are.&quot;

Part and Inventory Search

Back
Top