Search results for query: *

How can I display something other than this Invalid Use of Null error? I know there is no data in the database for what I've searched on, but I don't want the user to see this error. I'd rather see something like "No Results Found for your Search". Here is some of my code: These...

I have a website for my office that I need help with... Currently, it pulls data based on Month, but now that 2004 is coming, I'm adding a variable to include the year as well. So, now I've got the code pulling up the year and displaying 2003, 2004, 2005 (pulls this from the database). The user...

Does anyone know if I can take the following 5 queries and make them into one? They are all querying the same table for similar criteria. QUERY #1: TOTAL FOR FRAGMENT 1: SELECT Clng(Sum(Dashboard.Recycled_Usage)) AS SumOfRecycle, Clng(Sum(Dashboard.Usage)) AS SumOfUsage...

I have a website form where a user will enter various data that will update an Access database through the mssql code in my page. I am receiving an error : "Syntax error in INSERT INTO statement", which is related to the 2 Date/Time fields I have in the form. My guess is that the...

I am calculating how long a job runs using jsp & sql to query a MSAccess DB . I have a StartTime (6:14:33) and EndTime (20:07:23) and I have calculated the time TotalTime (=15:52:50). Code: Format((StartTime - EndTime), 'HH:MM:SS') AS TotalTime My question is: Is there a way to 1.) Round to...

I'm not sure if I'm posting this in the right forum, but I think this could be done using sql..just not sure how. Is it possible to create a report (displayed on a website) based on criteria selected from a form? (3 or 4 drop down boxes) i.e. User selects Month: April, Team: 1 and 2. Can I...

I'm not sure if I'm posting this in the right forum, but I think this could be done using sql..just not sure how. Is it possible to create a report (displayed on a website) based on criteria selected from a form? (3 or 4 drop down boxes) i.e. User selects Month: April, Team: 1 and 2. Can I...

Hi all, Is there a way to export data using html table information which is displayed on the screen to MSExcel? Currently what the users have to do is drag the mouse over the html table and then click ctrl c to copy the information which is displayed as raw html table and then open up excel...

Hi, I am trying to validate a form when the user hits the submit button. Currently, when a field is left blank, an error message pops up to instruct the user to enter something in the blank field, but when you click Ok on the error message, it processes the submit (which processes a query). I...

Is it possible to have an if else statement in a SQL Update statement? I want to... Update Table1 If (field1 != 0) set field1 = variable ,field2 = variable2 ,field3 = variable3 else field4 = variable4 etc.. What I'm really trying to do is allow null values to be entered in my form...

I'm using MS Access 97 db with SQL & Java web front-end. I figured out how to convert the date to a readable format when I display it on the page, but I can't figure out how to get the date formatted to update the table. Here's my code... String sql= "UPDATE " +...

Is there a way to get around entering information in every field on a web form? Have Access 97 db w/ web (jsp/java) front end...whenever the user doesn't enter information into every field on the form, an error occurs: Syntax error in UPDATE statement If the user enters info in every field...

I'm using java to make a web front-end of an Access 97 db. I currently have one main table with 4 linked tables. What I want is... When the user adds a new project to the Main table, I want the project_id (autonum primary key of main table) to be sent to the other 4 tables. This will then be...

PLEASE HELP....Here is my code: <% String initnum = request.getParameter(&quot;initnum&quot;); String pname = request.getParameter(&quot;projname&quot;); String status = request.getParameter(&quot;primstatus&quot;); String stage = request.getParameter(&quot;projstage&quot;)...