Search results for query: *

I have an app at work that will only allow me to customize the WHERE clause on a SQL statement. Currently the SQL Statement is hard coded something like this: SELECT * FROM `ERRORS` Is there a way to do a DISTINCT in the WHERE clause that would return the same results as: SELECT DISTINCT...

I have an app at work that will only allow me to customize the WHERE clause on a SQL statement. Currently the SQL Statement is hard coded something like this: SELECT * FROM ERRORS Is there a way to do a DISTINCT in the WHERE clause that would return the same results as: SELECT DISTINCT...

I have an app at work that will only allow me to customize the WHERE clause on a SQL statement. Currently the SQL Statement is hard coded something like this: SELECT * FROM ERRORS Is there a way to do a DISTINCT in the WHERE clause that would return the same results as: SELECT DISTINCT...

I have a query that is taking about 10 seconds to execute. I'm trying to optimize the query. Here is the code: SELECT ACCOUNT_LEVEL,PROGRAM,ANNUAL_FEE, APR_FLOOR_RATE,CASH_ADV_RATE,LATE_FEE,NSF_FEE,APR_RATE,APR_BASIS,LATE_GRACE_DAYS...

What I want to do is use ajax to return a table that was generated using a jsp. I am getting the table back and it is displaying on the page but it is returning all of the tags with it. IE. <table><tr><td></td></tr></table> My parsing javascript method looks like this: function...

What I'm doing is I have a website that sends a command property to a front controller servlet and then forwards onto a class. All that I want this class to do is get the command property and dynamically call the appropriate class and its method. For example if the command is "Login" then I want...

I am trying to get my SRS 2000 reports to hook up with my ASP.NET 2.0 reportViewer. Currently I have a page that has a reportViewer Control. The control is pointing to a remote SQL server 2005 database . I can view my reports just fine on the server so I know that they work. When ever I...

I'm a newbie at this so bare with me. I created a login screen for a website using Visual Studio 2005 using their login tools. Our webserver is running SQL server 2000. I ran aspnet_regsql.exe and imported the database into sql server 2000. Now I just need to change the web.config file to...

I am converting about a dozen Access databases to SQL Server 2005 and when they import their default datatype is nvarchar. My employer wants me to convert them all to varchar. What is the fastest way to do this besides going into each table and manually converthing the databtypes. Is there...

I have a form that is using 10 different tab pages. I want to be able to tab to each tab. What I mean is once I get to the end of my first page by tabbing it will move to page 2 instead of looping back to tab index 0 on that tab page. Any suggestions?

I have two combo boxes at the top of my form that are font size 24. It looks a little tacky because of the small down arrow on the right. Is there a ways to enlarge this to fill the size of the font.

I am creating a trigger for my database that will populate 6 tables with an ID. I know how to write the code I just can't seem to figure out how to make it my concise. Can anyone shoten this code for me please. Thanks create or replace trigger WELL_ID_TRIGGER after insert on WELLS for each...

I have Access connected to Oracle though ODBC and I am trying to make of form that uses two combo boxes to update 7 subforms on tabs. All relationship are a 1 to 1. I have everything working perfectly except that if the combo box reflects a record, the record counter at the bottom still show...