Search results for query: *

Hi Guys I recently updated the time of a scheduled job on our Oracle system. Now when the job runs or the procedure is run it starts the scheduled job at the same times then fails. When the scheduled job is started manually it tries to run it 3-4 times resulting in failures. Has anyone seen...

Hi Guys This might not be the right place for this question, if it isnt let me know and i'll find the right forum. I have a selection of links that when i roll over them they go an alternate color,this works but what i need is for the link to stay that color when clicked and revert back to the...

Hi Guys I have a problem with some SQL I have inherited....am better with ASP than SQL... Anyway I need to add to this statement to compare two columns and if they match then display 0.00. SELECT AgentCode , BranchName , ParkCode , TACode , BookingNumber , LeadName ...

Hi Guys Just a quick question.......how do you connect to an OLAP Cube in ASP/ASP.NET....... Thanks Glen Conception | Execution

Hi Guys var cur_lyr; // holds id of currently visible layer function swapLayers(id) { if (cur_lyr) hideLayer(cur_lyr); showLayer(id); cur_lyr = id; } function showLayer(id) { var lyr = getElemRefs(id); if (lyr && lyr.css) lyr.css.visibility = "visible"; } function hideLayer(id) {...

Hi Guys I have written a query that almost does what I need it to do. I am trying to count the number of products purchased by category. What I am getting is: Cat QTY CATID -------------------------------- Fans 12 AJ CPU's 35 DF HDD's...

Hi guys I am having trouble with getting an order by clause working.... this may be more ASP related but thought I ask you first. It works in the query analyzer but not when called in the ASP page. set replies = server.CreateObject("ADODB.Recordset") replies.ActiveConnection = databaseString...

Hi Guys I am currently upgrading a system from access to SQL server. One aspect of the system (web app) is it takes 'quotes' then sends a mail for users to respond. The time of the quote and response (date & time) is captured but i am struggling to make the time diffence in 'working day eg...

Hi Guys I have an ASP script that creates a text file for are archaic shipping label printer..... The problem is that the file is created on one server [S1] then the asp tries to move the file to [S2] Both servers are networked in a 'wan' type fashion, but the I get access denied when trying...

Hi Guys I am having trouble getting my head round writing a query to producte the results i need. What i currently have is a table in the following format:- ID Cat_ID Man_ID UName UEmail DistributorID 011 10 23 Glen glen@glen 23,250,10,103 012 25 45...

Hi Guys, I have had a quick search for a similar topic as I am sure it would have been asked before....... Right, what i need to do is to update a table with the record ID of another. They both have a matching field. tbl 1 RecID Name tbl 2 UID Name Category I need to update tbl 2 with...

Hi Guys, I have an ASP page that inserts multiple rows through a looping ASP function, the problem is that it says the amount of columns and values don't match however when I print the queries out the colum and value counts are the same.......any suggestions? ' Application ' allow users to...

Hi Guys I have a Function in an include file that searches across multiple tables to find product in formation. What i would like to do is to show a results total on the screen when a sub parameter has been chosen. What currently is returned is the total for the initial search, when a sub...

Hi Guys I am having trouble achieving the following to things..... 1. Get the total number of Items from the 'cart table' 2. Get the total value of the order the database has a table containing cart info [id, order id, productid, qty] and the product table has all product information...

Hi Guys I have the following SQL statment in SQL Server 2k that I use in an ASP page. -------------------------------------- SELECT DISTINCT OrderBody.OrderID AS Expr1, OrderBody.Quantity AS qty, OrderBody.ProductID AS product, OrderBody.CustomerEmail, OrderBody.SellPrice, OrderBody.BuyPrice...