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 dencom 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: ljwilson
  • Content: Threads
  • Order by date
  1. ljwilson

    Regular Expression Help (Numbers with Decimal)

    I am trying to create an array with the matched elements from a string. I am not having much success (the result is an empty array). Here is what I got: var regpattern = new RegExp("^\d+(\.\d{1,2})?$"); var myarray = new Array; myarray[21] = "TEXT NOT NEEDED"; myarray[22] = "Diagnosis: Other...
  2. ljwilson

    Fields run together when printing

    What would cause some fields to run together when printing? The report looks fine when viewed in the web browser (RS2008 is what we use), but when the report it printed, two fields occupy the same space and overwrite each other. Thanks!
  3. ljwilson

    Specify Server on a Web Farm

    Is there any possible way for me to choose what server I get assigned on my Web Farm? I have three webservers in that cluster and am using one of them for development for an ASP app. I have people that need to test changes that are being made, but they don't always get assigned that server...
  4. ljwilson

    Register and consume a .NET dll with Classic ASP

    I have tried to register and consume a .NET dll with plain classic asp (Server.CreateObject). I think I have registered the DLL correctly (it shows up in Component Services just fine and gave me some error messages when the authentication wasn't setup properly), but I can't seem to get classic...
  5. ljwilson

    jQuery IE Ajax Error (but not on page refresh)

    I am getting errors in IE when making simple ajax calls. The calls work in other pages, but not in this page. The IE Script Debugger picked this out as causing the issue: return new A.XMLHttpRequest The error is Object doesn't support this property or method on line 123 character 183 The...
  6. ljwilson

    Unicode Characters in Database

    I am having serious issues with several webpages. It seems to be happening when people copy and paste text from applications like MS Word. I have written a function to replace some of these with the proper html characters (single quotes, double quotes, etc), but now more symbols are showing up...
  7. ljwilson

    Unicode Characters in Database

    I am having serious issues with several webpages. It seems to be happening when people copy and paste text from applications like MS Word. I have written a function to replace some of these with the proper html characters (single quotes, double quotes, etc), but now more symbols are showing...
  8. ljwilson

    Set value of datetimepicker to value from database on form load

    I am struggling with this. I have a datetimepicker. I have code to get data from database on form load. All that works just fine. What won't work is for the datetimepickers to be set to the date I get back from the DB. I can do a MessageBox.Show on the variable that holds the date coming...
  9. ljwilson

    Print directly to printer (Reporting Services report) from VB.NET

    I have a Windows Forms application and need to print a reporting services report directly to a printer. Right now, I can bring it up in a browser, but really need to bypass the viewing and just send output to a printer. Any advice? Thanks, ElJay
  10. ljwilson

    INT Conversion Error (Wierd)

    This is wierd. I am trying to use a variable for the where clause in an SP. I am using EXEC (for now) to execute a built string of SQL. This part breaks it: DECLARE @WHERE_SQL AS VARCHAR(500) IF @STATUS = 'ALL' SET @WHERE_SQL = ' r.creator = ''' + @UID + ''' ' ELSE SET @WHERE_SQL = '...
  11. ljwilson

    Using INT Variables in Stored Proc (EXEC)

    I am having trouble with this one. I am trying to do pagination (JQGrid) and am dynamically created a sql statement to be executed. Right now, I am getting an error message: Msg 245, Level 16, State 1, Procedure pEreq_Get_RequestSummaryByUID, Line 52 Conversion failed when converting the...
  12. ljwilson

    Databind textboxes and checkboxes

    I have a fairly simple Windows Form (UserControl). What I have is two tabs (a tab control) that both reference the same UserControl. I have several Textboxes and Checkboxes that need to get populated from a DataTable. The DataTable is working fine (getting data from an SP). I have also build...
  13. ljwilson

    Datagrid and SqlDataSource issue

    I am trying to change the datasource of a GridView and then show the rows. It works perfectly when the Grid is loaded the first time, however when I do something to change the datasource, I get a "object reference not set to an instance of an object" error.I still get the grid to update either...
  14. ljwilson

    Datagrid and SqlDataSource issue

    I am trying to change the datasource of a GridView and then show the rows. It works perfectly when the Grid is loaded the first time, however when I do something to change the datasource, I get a "object reference not set to an instance of an object" error. I still get the grid to update...
  15. ljwilson

    Using declared variables in place of table names

    How can I use declared variables in the place of table names? What I am trying to do is write a stored proc that will take data from a linked server and put it into tables in a local DB. There are several tables that I have to deal with and was just wanting to assign the current local table...
  16. ljwilson

    Create tables based off structure and data from a linked server

    I am trying to create tables and insert data based on a linked server. The linked server may not always be available so we need to have a local copy of the data. Since I am not in control of the linked server, I won't know when table structure changes. Is there a way to create a SP that will...
  17. ljwilson

    ActiveSheet.Name not working

    This is wierd. This was working until the workbook was modified. What I am doing is automatically populating the footer area with text and barcodes based on cell contents. Since both sheets have different print size percentages (and also different cells where the data for the barcode exists)...
  18. ljwilson

    SQL Query Problem

    I am trying to modify the following query so that it will not pull results where we have more records for a given account in #tempBarTransactions than we do in the view_finalizedVisitsProcedureDetail. In other words, currently the following query will return results for an account that has...
  19. ljwilson

    SQL View with TOP Clause

    I need some help. Here is the situation, I need to only show the record with the highest activity level from the CHAOS_Awards table. In the CHAOS_Awards table, they can be several records for each award_fk. That table has a column for ActivityNumber which increments for each record of a...
  20. ljwilson

    GridView Problem calling event handler

    I am really new to ASP.NET I have a gridview that I am working with and simply want to put a button on it that will fire a stored proc I have written that takes a parameter (id). The id field is bound to the datasource. Here is what I have: <body> <form id="form1" runat="server">...

Part and Inventory Search

Back
Top